entity_statement

44 rows where foundingdate = "2011-04-20" and iscomponent = "false"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: statementdate, statementdate (date), foundingdate (date), publicationdetails_publicationdate (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
100637 00c93ec0-302c-4af3-a245-47f2e80a387c entityStatement 2019-07-15 false registeredEntity SIA "Draikon" 2011-04-20 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    
100638 6a3e6e2a-4ca0-4ed9-a59d-cebdd969a2c5 entityStatement 2019-07-15 false registeredEntity SIA "BIRZĪTES DS" 2011-04-20 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    
105101 d6730415-1ed5-41f9-be62-18163d14e87e entityStatement 2019-07-16 false registeredEntity Sabiedrība ar ierobežotu atbildību "AGRO MT" 2011-04-20 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    
105102 8f4924e8-2281-4471-9b47-f7976fa83e1b entityStatement 2020-12-17 false registeredEntity Sabiedrība ar ierobežotu atbildību "WATER ELEMENT" 2011-04-20 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    
109758 05079167-790e-4f47-9337-a595f227e641 entityStatement 2019-07-16 false registeredEntity Sabiedrība ar ierobežotu atbildību "SALIMONA" 2011-04-20 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    
27363 5a778b6d-f296-434b-a24d-ce56d24b9dd8 entityStatement 2018-02-08 false registeredEntity "Fonds Latvijas Lauksaimniecības attīstībai" 2011-04-20 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    
27364 19a725c3-763c-4c3e-ab67-d043e3922fe1 entityStatement 2019-07-27 false registeredEntity "Ventspils Mūzikas skolas atbalsta fonds "DoSiM"" 2011-04-20 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    
42282 ad9c1210-bef7-4cf5-8bb1-12ddf318a203 entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "Crystal Real Estate" 2011-04-20 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    
42283 94aeadd2-6060-4861-96a6-96da25a4afcb entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "GRĀMATVEDĪBAS STIPRINĀJUMI" 2011-04-20 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    
42284 e63cc3c7-0a82-4b2e-be30-521a0e82d01b entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "JARDI.Treneri" 2011-04-20 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    
42285 be8874bf-e097-4397-9d91-72d5b846f5c4 entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "MIKS-SKS" 2011-04-20 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    
42286 10603db0-3d41-42d3-862d-fa096233c0ef entityStatement 2019-07-11 false registeredEntity SIA "MMInfo" 2011-04-20 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    
42287 c2e77e4a-6e4d-4740-bc37-dd2d3045857d entityStatement 2019-06-26 false registeredEntity Sabiedrība ar ierobežotu atbildību "Nova Consulting" 2011-04-20 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    
42288 cd155cd8-0cd8-4d36-add9-4f703ece114e entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "Orange city" 2011-04-20 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    
42289 216cf16d-50b4-4ce1-a970-415512da17a2 entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "MAXTRADE LOGISTIC" 2011-04-20 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    
42290 c20e2dc5-c057-49b4-b667-3a7bd273e749 entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "Partners for Progress" 2011-04-20 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    
42291 87539d23-920c-4643-b9eb-67a76d7ffb1e entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "RE68" 2011-04-20 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    
42292 50745072-19a5-4380-a587-d2c1ba8ecaca entityStatement 2019-03-28 false registeredEntity SIA "GOBLINS" 2011-04-20 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    
42293 07482072-701f-4599-aa88-c6cf843c2adb entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "Alta BS" 2011-04-20 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    
42294 597a7757-7990-450b-8b8d-6ed5477cffda entityStatement 2019-07-11 false registeredEntity SIA "TIRGO" 2011-04-20 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    
42295 f2bac34c-b804-4bd5-a217-32f5e31e8d0c entityStatement 2018-05-09 false registeredEntity SIA "SUIĢI" 2011-04-20 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    
42296 42fdc9f2-f25d-4279-8f1b-1da3c50e7475 entityStatement 2018-12-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "Novus Balticum" 2011-04-20 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    
42297 c45c4ede-dfcf-404f-ab28-fd9b9937ea16 entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "The Wunderbar" 2011-04-20 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    
42298 e966c3d0-eef5-4c1f-83c6-f96194d7460f entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "Bizart" 2011-04-20 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    
42299 5e4515f2-bde8-49d3-ad96-3deb841dae62 entityStatement 2019-07-11 false registeredEntity SIA "RM SERVICE" 2011-04-20 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    
42300 9ab3711c-3326-443c-8725-3699dd5d5126 entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "KRAIWI IT" 2011-04-20 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    
42301 4a2975a0-8051-4c3b-a1b6-27c1aaf40c2e entityStatement 2018-02-08 false registeredEntity Sabiedrība ar ierobežotu atbildību "Milzkalne.lv" 2011-04-20 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    
42302 e2d37d2a-8bd1-478d-b2e7-0906af1ff05e entityStatement 2018-05-07 false registeredEntity Sabiedrība ar ierobežotu atbildību "Baltic Resort Group" 2011-04-20 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    
42303 b033e548-3fe2-4759-b471-aa5e41d7d586 entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "KM BIROJS" 2011-04-20 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    
42304 6be8303e-b503-4d55-be8b-8d1add822e53 entityStatement 2019-07-11 false registeredEntity "AP DBA" SIA 2011-04-20 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    
42305 cb27179c-339b-4a6e-89b5-09647db571da entityStatement 2019-01-03 false registeredEntity Sabiedrība ar ierobežotu atbildību "E-Consultancy" 2011-04-20 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    
42306 30d0e596-a07c-4c29-a46a-1aa97b95c314 entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "Libco lv" 2011-04-20 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    
42307 d339eb18-0137-46e2-afaa-f57b7f3a0109 entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "Industrial Smart Technology" 2011-04-20 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    
42308 3eecd934-1033-43c9-8947-6c481a29b207 entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "ALIPE 74" 2011-04-20 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    
42309 21ee04c9-6677-4959-9d7b-20b4a461d711 entityStatement 2019-07-11 false registeredEntity SIA "Providence Ltd." 2011-04-20 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    
42310 f386b0f5-383f-4163-b310-505dc3893f46 entityStatement 2018-02-26 false registeredEntity Sabiedrība ar ierobežotu atbildību "Rangs JS" 2011-04-20 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    
42311 c4972e71-adc4-4923-a8c9-93b205821bfd entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "PROPERTIES SUPPORT" 2011-04-20 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    
42312 b9035a3f-8d28-4d1b-a16f-68504fff249d entityStatement 2018-01-24 false registeredEntity Sabiedrība ar ierobežotu atbildību "RE UNISERVICE" 2011-04-20 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    
89115 57e68789-2ec7-4cf7-a74b-02a8f8d25ced entityStatement 2019-07-25 false registeredEntity V.Medņa Kabiles pagasta zemnieku saimniecība "Lauksargi" 2011-04-20 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    
90954 de91b48b-eda5-41aa-8215-da80b45ee3a0 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Projekts Ltd" 2011-04-20 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    
95483 9c0bca70-9f5b-4a72-afa0-c2883a0fd0e3 entityStatement 2019-05-17 false registeredEntity Sabiedrība ar ierobežotu atbildību "RENITAPS" 2011-04-20 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    
95484 4972217b-1c77-41bc-a6c5-6300284f8cf1 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "SILTUMA GARANTS" 2011-04-20 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    
95485 258a3215-bfdb-40fa-88e0-cc5710769411 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "HS electric" 2011-04-20 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    
95486 7c90e526-4048-415d-8916-27ac2d68513c entityStatement 2019-07-15 false registeredEntity SIA "SPE LAT" 2011-04-20 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]) 
);