entity_statement

47 rows where "foundingdate" is on date 2012-03-29 and iscomponent = "false"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: statementdate, publicationdetails_publicationdate, statementdate (date)

_link ▼ statementid statementtype statementdate iscomponent entitytype name foundingdate incorporatedinjurisdiction_name incorporatedinjurisdiction_code publicationdetails_publicationdate publicationdetails_bodsversion publicationdetails_license publicationdetails_publisher_name publicationdetails_publisher_url source_type unspecifiedentitydetails_reason unspecifiedentitydetails_description
100871 d49fc6f0-406f-4545-8ad3-892100370409 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "VĒLME AI" 2012-03-29 Latvia LV 2021-01-19 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
100872 3c145579-b366-4f0f-bf1b-be4d2aa03c23 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "SMS PĒRLES" 2012-03-29 Latvia LV 2021-01-19 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
100873 be9d1787-79c7-48d5-bc71-a9338a3c763e entityStatement 2019-07-15 false registeredEntity SIA "FIDEM" 2012-03-29 Latvia LV 2021-01-19 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
100874 848233ca-e430-499d-bbdc-5129c9646e14 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "VIĢI R" 2012-03-29 Latvia LV 2021-01-19 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
105227 7571a069-4c0f-4070-8f8c-1a14be132369 entityStatement 2019-07-16 false registeredEntity Sabiedrība ar ierobežotu atbildību "Dionīss" 2012-03-29 Latvia LV 2021-01-19 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
105228 7c65b3fe-0e26-47d5-a567-5f3cbdf6d27a entityStatement 2019-07-16 false registeredEntity SIA "Digitālā tipogrāfija" 2012-03-29 Latvia LV 2021-01-19 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
110052 97a51b6f-7b01-4fc0-85a5-89870edacb8a entityStatement 2019-07-16 false registeredEntity Sabiedrība ar ierobežotu atbildību "Baltic Farm Consultancy" 2012-03-29 Latvia LV 2021-01-19 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
110053 35ae49d9-030e-43cb-87c8-63d3a158e0f6 entityStatement 2019-07-16 false registeredEntity Sabiedrība ar ierobežotu atbildību "VDU System" 2012-03-29 Latvia LV 2021-01-19 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
110054 e0886ddd-9877-40b5-9f76-7fd2f1ca68f8 entityStatement 2019-07-16 false registeredEntity Sabiedrība ar ierobežotu atbildību "AUTOTRONIKA" 2012-03-29 Latvia LV 2021-01-19 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
47657 138f9074-e835-4c49-addb-550628002fb1 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Lunaro" 2012-03-29 Latvia LV 2021-01-18 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
47658 55890539-ea87-4b5d-8c49-e9ea0f95588a entityStatement 2019-03-13 false registeredEntity SIA "ENTER BALTIC" 2012-03-29 Latvia LV 2021-01-18 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
47659 7b2b3c30-5954-4296-8331-0fc1f5a02105 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Zelta Slota" 2012-03-29 Latvia LV 2021-01-18 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
47660 50c3aad9-641e-44c1-a9bb-e3eef3b692a0 entityStatement 2019-02-05 false registeredEntity Sabiedrība ar ierobežotu atbildību "BALASTIKA" 2012-03-29 Latvia LV 2021-01-18 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
47661 87faf839-015b-44a2-b71f-b866f33f0f46 entityStatement 2018-05-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Proof Advisory Group" 2012-03-29 Latvia LV 2021-01-18 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
47662 a886d268-608b-496f-a7c1-222cfc34241c entityStatement 2019-04-26 false registeredEntity Sabiedrība ar ierobežotu atbildību "Siguldas boulings" 2012-03-29 Latvia LV 2021-01-18 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
47663 e174ce16-08ab-434d-abe1-cdfc1e838789 entityStatement 2019-07-12 false registeredEntity Sabiedrība ar ierobežotu atbildību "AS17" 2012-03-29 Latvia LV 2021-01-18 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
47664 12776358-c249-45a9-81c2-d637e5719989 entityStatement 2019-07-15 false registeredEntity SIA "DIEVS SVĒTĪ" 2012-03-29 Latvia LV 2021-01-18 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
47665 3b692ba7-fb24-4a09-b4ca-4cab438e2de2 entityStatement 2018-03-19 false registeredEntity Sabiedrība ar ierobežotu atbildību "Wit Berry" 2012-03-29 Latvia LV 2021-01-18 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
47666 86dc9a72-61c6-47bc-92c1-73107480e098 entityStatement 2019-07-15 false registeredEntity SIA "RR Solutions" 2012-03-29 Latvia LV 2021-01-18 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
47667 099e21e2-7b00-4f45-a4f7-f659d9f5f3da entityStatement 2019-07-15 false registeredEntity SIA "ComHou" 2012-03-29 Latvia LV 2021-01-18 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
47668 4cc75dbb-ec69-4dd5-bb3d-22b88ed86d82 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Altera Victoria" 2012-03-29 Latvia LV 2021-01-18 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
47669 8031c3f8-4d65-47f2-bacf-6e24fe2bf569 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "LFAB Baltics" 2012-03-29 Latvia LV 2021-01-18 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
47670 ece20d7c-60a7-4ae5-be91-bc751c9a57e0 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "JBB Auto" 2012-03-29 Latvia LV 2021-01-18 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
47671 40b58ae0-9bcd-49cc-80b0-542b60ba7538 entityStatement 2019-07-15 false registeredEntity SIA "Skaistuma Essence" 2012-03-29 Latvia LV 2021-01-18 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
47672 e64d6cff-4f8e-4d0b-8f7c-b1edb1535750 entityStatement 2019-07-15 false registeredEntity SIA "MEFU" 2012-03-29 Latvia LV 2021-01-18 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
47673 da885d2e-3f5a-49ab-be5d-c8cacfe2211a entityStatement 2019-07-12 false registeredEntity SIA DELAT GROUP 2012-03-29 Latvia LV 2021-01-18 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
47674 074a8096-49ad-4639-8711-82764f4fcf5b entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "ADL objekts" 2012-03-29 Latvia LV 2021-01-18 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
47675 15addc6a-8075-4171-93ba-a42c7de8f388 entityStatement 2019-07-12 false registeredEntity Sabiedrība ar ierobežotu atbildību "BARKANS KONSULTĀCIJAS" 2012-03-29 Latvia LV 2021-01-18 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
47676 a28424d5-68b6-4f47-8774-cb1cc89d28cf entityStatement 2019-07-12 false registeredEntity Sabiedrība ar ierobežotu atbildību "Baltic Rolling Stock" 2012-03-29 Latvia LV 2021-01-18 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
47677 27c2c869-ec53-47b0-b00f-b3b87083cabd entityStatement 2019-10-07 false registeredEntity Sabiedrība ar ierobežotu atbildību "VIRU" 2012-03-29 Latvia LV 2021-01-18 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
47678 7f89738c-e90c-4da5-8bff-b3d5057558b3 entityStatement 2020-09-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "KRUSTPILS SVARI" 2012-03-29 Latvia LV 2021-01-18 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
47679 bd06a515-ef5e-45b1-b2ab-f997389beb38 entityStatement 2018-08-07 false registeredEntity Sabiedrība ar ierobežotu atbildību "RENOVA Latvia" 2012-03-29 Latvia LV 2021-01-18 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
47680 bfeab84b-ecd7-4a7d-ae08-1c5a3102e4c4 entityStatement 2019-07-12 false registeredEntity Sabiedrība ar ierobežotu atbildību "SLE" 2012-03-29 Latvia LV 2021-01-18 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
47681 ba3ea421-e11d-47d6-a5cc-007607f5eca0 entityStatement 2019-11-22 false registeredEntity Sabiedrība ar ierobežotu atbildību "Kontransa" 2012-03-29 Latvia LV 2021-01-18 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
47682 a952ab45-c0f0-4372-ae6e-6acd9564269b entityStatement 2019-07-15 false registeredEntity SIA Payment Solutions 2012-03-29 Latvia LV 2021-01-18 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
47683 9b469d8a-b9ec-4401-85b5-65a3799ae560 entityStatement 2019-07-15 false registeredEntity SIA "Gourmet trade house" 2012-03-29 Latvia LV 2021-01-18 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
47684 41a382e7-bc38-4d20-af4a-671c1660cc0a entityStatement 2019-01-24 false registeredEntity Sabiedrība ar ierobežotu atbildību "ROBROM" 2012-03-29 Latvia LV 2021-01-18 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
47685 bc5a89ad-dee9-4786-986b-bf20f76a9259 entityStatement 2020-01-17 false registeredEntity Sabiedrība ar ierobežotu atbildību "EDVO" 2012-03-29 Latvia LV 2021-01-18 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
47686 960a44c1-0d8f-449f-a3ba-98820d831c97 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "First tax consulting group" 2012-03-29 Latvia LV 2021-01-18 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
47687 fc545ca5-7fc4-48db-8442-3b1f7032777c entityStatement 2019-06-20 false registeredEntity Sabiedrība ar ierobežotu atbildību "ENERGOUZRAUGS" 2012-03-29 Latvia LV 2021-01-18 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
47688 4fb3bb20-3fdd-40e7-8d90-b30d6fd4443d entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Derma klīnika" 2012-03-29 Latvia LV 2021-01-18 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
91120 df4e50fc-9b42-413e-9698-185e434dab03 entityStatement 2018-11-05 false registeredEntity SIA "VDV Trans" 2012-03-29 Latvia LV 2021-01-19 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
91121 b013ec61-59b6-4ff4-a0e0-fc2fe1f4bc51 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "aRmor" 2012-03-29 Latvia LV 2021-01-19 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
91122 dbc39652-2fdd-48de-bb76-0f287f8ebbe9 entityStatement 2019-03-06 false registeredEntity Sabiedrība ar ierobežotu atbildību "Kursas Lauki" 2012-03-29 Latvia LV 2021-01-19 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
93544 972c635a-1d27-4266-8fb2-0931159d599e entityStatement 2019-07-25 false registeredEntity Preiļu pagasta zemnieku saimniecība "Jasnaja Poļana" 2012-03-29 Latvia LV 2021-01-19 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
95717 7d1093e7-1056-4d1f-b29b-e8c87a8a3b51 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Polana-D" 2012-03-29 Latvia LV 2021-01-19 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
95718 82560196-8fc8-41a8-a8ec-91061eecdd15 entityStatement 2019-07-15 false registeredEntity SIA "Zariņu Medus" 2012-03-29 Latvia LV 2021-01-19 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [entity_statement] ( [_link] TEXT 
 , [statementid] TEXT 
 , [statementtype] TEXT 
 , [statementdate] TEXT 
 , [iscomponent] BOOL 
 , [entitytype] TEXT 
 , [name] TEXT 
 , [foundingdate] TEXT 
 , [incorporatedinjurisdiction_name] TEXT 
 , [incorporatedinjurisdiction_code] TEXT 
 , [publicationdetails_publicationdate] TEXT 
 , [publicationdetails_bodsversion] TEXT 
 , [publicationdetails_license] TEXT 
 , [publicationdetails_publisher_name] TEXT 
 , [publicationdetails_publisher_url] TEXT 
 , [source_type] TEXT 
 , [unspecifiedentitydetails_reason] TEXT 
 , [unspecifiedentitydetails_description] TEXT 
 , PRIMARY KEY ([_link]) 
);