entity_statement

30 rows where foundingdate = "2015-07-24" and iscomponent = "false"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: statementdate, 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
111111 a57e472d-0db2-40dd-acda-8feaf39eee4a entityStatement 2019-07-16 false registeredEntity Sabiedrība ar ierobežotu atbildību "TEOGRO" 2015-07-24 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    
111112 9544e305-6a14-4e58-84d0-d7d1259d40d4 entityStatement 2019-07-16 false registeredEntity SIA "SigmaBit" 2015-07-24 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    
27901 23d7571f-bf5c-44cd-939d-5b7b59095980 entityStatement 2020-05-14 false registeredEntity Nodibinājums "Mežaparka Rezidences apsaimniekošana" 2015-07-24 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    
67257 117329c5-f7f1-447c-aa77-b3f9125e42b9 entityStatement 2019-07-15 false registeredEntity SIA "MEDPART" 2015-07-24 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    
67258 db30e0f3-0d23-4b6e-95a2-fa45b01ca891 entityStatement 2018-10-15 false registeredEntity SIA "Rogneda" 2015-07-24 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    
67259 e56f69ff-7a85-4ebd-b957-1d092eb2212e entityStatement 2019-06-06 false registeredEntity SIA "BYSEL" 2015-07-24 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    
67260 484e08ec-d0f3-4922-992e-5e8f2e39ce20 entityStatement 2019-07-14 false registeredEntity SIA Gimnasium 2015-07-24 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    
67261 522a92e6-7f0c-4187-a953-1312f42648d5 entityStatement 2019-07-15 false registeredEntity SIA "Biznesa vadības centrs" 2015-07-24 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    
67262 2d75192a-ae85-45f4-bf1f-20bff675531c entityStatement 2019-04-05 false registeredEntity SIA "AP Ltd" 2015-07-24 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    
67263 8902576a-4a2d-4773-981d-a34aec1fd188 entityStatement 2019-07-15 false registeredEntity Sexton Legal Translations SIA 2015-07-24 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    
67264 40ad3343-ab62-441b-a3f0-dded409ddd03 entityStatement 2019-07-15 false registeredEntity SIA "Autoloks" 2015-07-24 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    
67265 748ff61b-68da-41f2-9948-d798c385ef2c entityStatement 2017-12-20 false registeredEntity SIA "Baltic construction corporation" 2015-07-24 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    
67266 2e7295c7-0099-41f8-812b-e5e248c154fa entityStatement 2019-07-14 false registeredEntity SIA "BioTer" 2015-07-24 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    
67267 70f8a307-30cb-49ed-bfd1-9768325d6c6b entityStatement 2018-12-14 false registeredEntity KLIMATUM SIA 2015-07-24 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    
67268 b1e6817a-5c29-44b2-823a-473b79cc5620 entityStatement 2019-06-03 false registeredEntity SIA "Saules Auto Plus" 2015-07-24 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    
67269 19d29299-47e2-4bd7-92d8-e721a521a460 entityStatement 2019-07-15 false registeredEntity SIA Green Focus 2015-07-24 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    
67270 5c855d56-72be-4a29-bc44-6a68533c5842 entityStatement 2018-04-26 false registeredEntity Sabiedrība ar ierobežotu atbildību "Frozen grapes" 2015-07-24 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    
67271 de6ae3a8-a35a-4e53-9687-1ce6dd6d0911 entityStatement   false registeredEntity Sabiedrība ar ierobežotu atbildību "NIF INVESTĪCIJA 2" 2015-07-24 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    
67272 5680b8fb-11b0-4c27-ab3b-77e7b8269b1a entityStatement 2019-09-09 false registeredEntity SIA "RESPECT ORGANIC" 2015-07-24 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    
67273 c0b0b747-2f2d-4932-84f2-cc3c9eb6d2ac entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "Runa-M" 2015-07-24 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    
67274 5714729f-4f63-41a7-8a68-1d8eceea1e25 entityStatement 2019-07-15 false registeredEntity SIA "ANENSI" 2015-07-24 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    
67275 d374e795-dd75-4d8d-a13c-be98a545b6a5 entityStatement 2018-07-04 false registeredEntity Sabiedrība ar ierobežotu atbildību "Svaigi" 2015-07-24 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    
67276 1aa0eceb-6413-4522-9693-0a5aa6b782ad entityStatement 2019-06-06 false registeredEntity Sabiedrība ar ierobežotu atbildību "Moroni" 2015-07-24 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    
67277 81408934-d2be-42ea-bcd0-0f5d93383131 entityStatement 2018-01-24 false registeredEntity SIA "Idoma" 2015-07-24 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    
67278 f13a63ae-c87d-4bde-96c3-472b27afc109 entityStatement 2019-05-07 false registeredEntity Sabiedrība ar ierobežotu atbildību "AL & NOSTRA" 2015-07-24 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    
67279 aed71c3e-f773-4a9e-8c8a-a14ffbe82ddc entityStatement 2019-07-14 false registeredEntity SIA "EVOR LATVIJA" 2015-07-24 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    
67280 21a3427f-26c9-45d6-8d67-a9519e05c10e entityStatement 2019-07-14 false registeredEntity SIA "Aplot" 2015-07-24 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    
93595 da4a973f-fb43-4628-b5da-a88794f4c846 entityStatement 2019-07-25 false registeredEntity Skaistas pagasta Zemnieku saimniecība "Andra Krasti" 2015-07-24 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    
96490 735cbb66-908f-4f45-a5f8-58a0d55048bd entityStatement 2018-12-17 false registeredEntity SIA "MTehnika.lv" 2015-07-24 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    
96491 6cd99580-cd25-44e2-91de-7d3c98643d31 entityStatement 2018-12-04 false registeredEntity Sabiedrība ar ierobežotu atbildību "Cosmo Logistics" 2015-07-24 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]) 
);