entity_statement

36 rows where foundingdate = "2015-05-06", "foundingdate" is on date 2015-05-06 and iscomponent = "false"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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
101668 61716484-3584-4488-9edf-038deb5f82d3 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Druvnieks" 2015-05-06 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    
101669 de872598-369f-474e-9a95-410870a8943b entityStatement 2019-07-15 false registeredEntity SIA "LOLLA" 2015-05-06 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    
111037 17ba3c31-91f0-4fd1-9c94-d3d9ffe6212d entityStatement 2019-07-16 false registeredEntity SIA "BOLSPRO" 2015-05-06 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    
111038 f70dd0ef-98ae-48c0-8b8c-3388275bd602 entityStatement 2018-03-07 false registeredEntity SIA "ENERSTENA LATVIJA" 2015-05-06 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    
111039 1f2c5820-7938-4710-9a17-ef89e6aed7b5 entityStatement 2019-07-16 false registeredEntity MIGRO, SIA 2015-05-06 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    
111040 a91f4db4-18ab-4cab-b0fa-d7f541045c91 entityStatement 2019-07-16 false registeredEntity Sabiedrība ar ierobežotu atbildību "LIATRIS" 2015-05-06 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    
111041 6e011254-9c52-4534-9c2f-f368cf560918 entityStatement 2019-07-16 false registeredEntity Sabiedrība ar ierobežotu atbildību "MeM-AUTO" 2015-05-06 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    
27871 68b1be44-bf0a-4579-94bc-c32bd91fe036 entityStatement   false registeredEntity ""CENTRUS" Dzīvokļu īpašnieku biedrība" 2015-05-06 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    
66142 e644cd86-7459-4461-b4f7-91d417aba125 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "M.M. Meliora" 2015-05-06 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    
66143 299106ec-63b3-4eda-9c44-b2d38c22c14a entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "BALTIMORA" 2015-05-06 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    
66144 0f8cfc94-7a3c-4145-a7b2-5a42074a9d98 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Auto Baneri" 2015-05-06 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    
66145 97c74c71-4602-42d8-b85f-2b700f23ca36 entityStatement 2020-08-07 false registeredEntity SIA "ART8 Cargo" 2015-05-06 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    
66146 3aaefe9c-b262-4be3-a7e4-23d367ede932 entityStatement 2020-10-27 false registeredEntity SIA "ZAPTE" 2015-05-06 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    
66147 40617a8c-9279-4ae2-a17f-36e3c812e797 entityStatement 2019-07-15 false registeredEntity SIA "ROSE 7" 2015-05-06 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    
66148 2e3e70d6-f10b-4749-92be-e2f1e6afe913 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Lollipop" 2015-05-06 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    
66149 4b7ce893-a55b-4eae-9f27-461d28b0bf19 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "ROAD Pluss" 2015-05-06 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    
66150 3c8b255e-51b6-44a5-876b-6c2b7b065a00 entityStatement 2019-07-14 false registeredEntity GRAINMILL SIA 2015-05-06 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    
66151 a6a3207e-e963-4dcf-acae-eec446407037 entityStatement 2018-01-16 false registeredEntity SIA "Beton Industrial" 2015-05-06 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    
66152 11d565b1-75a0-4d44-9082-caae1c9ac43d entityStatement 2019-07-14 false registeredEntity SIA Multi Heritage 2015-05-06 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    
66153 cb4d2a1e-f0b5-4883-9302-eef0ec8a4c6e entityStatement 2018-12-19 false registeredEntity SIA "Riga Vision" 2015-05-06 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    
66154 d0924ee0-5e61-4d70-a9aa-c4fd1a628f13 entityStatement 2019-08-08 false registeredEntity SIA "F-01" 2015-05-06 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    
66155 e28de12f-93a9-47e5-a143-1817afb709fe entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "Dendansi" 2015-05-06 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    
66156 2e913af2-cc67-4c56-a4c0-da997edb2433 entityStatement 2019-07-15 false registeredEntity SIA "Kallax" 2015-05-06 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    
66157 6f56d8c3-b2a0-4ece-b88f-9bd57b80364f entityStatement 2019-08-28 false registeredEntity SIA "L-01" 2015-05-06 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    
66158 f2592c04-6b56-419b-9f15-ffd1369e6934 entityStatement 2018-02-21 false registeredEntity Sabiedrība ar ierobežotu atbildību LEGALOS 2015-05-06 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    
66159 d422a3d4-4fbe-484c-b7a9-c7c003b9f390 entityStatement 2019-07-14 false registeredEntity SIA "COLORIST BALTIC" 2015-05-06 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    
66160 68e9d9d0-7277-481d-a849-320b0d195b58 entityStatement 2018-03-05 false registeredEntity AS EA investments 2015-05-06 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    
66161 ab5dfcfe-0791-4001-b4b8-5ce058ce1b17 entityStatement 2019-07-14 false registeredEntity SIA "New Line Group" 2015-05-06 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    
66162 38203b79-b029-49fd-afca-161169cdb73b entityStatement 2018-01-17 false registeredEntity Sabiedrība ar ierobežotu atbildību "CARGO TRADE" 2015-05-06 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    
66163 efa60f7b-9b40-448d-9def-638c708b108c entityStatement 2019-07-14 false registeredEntity SIA "11MK" 2015-05-06 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    
66164 0f4d9da5-a054-4789-931e-7b90a1f869c5 entityStatement 2020-08-10 false registeredEntity SIA "Baltic Taxi" 2015-05-06 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    
66165 646546bf-53b3-4a41-882c-4e4c3cfbbc69 entityStatement 2019-07-14 false registeredEntity SIA LL Mazgātava 2015-05-06 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    
66166 c5a06b36-69cb-4770-8eda-5129fa20a2ed entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "MOSS Consulting" 2015-05-06 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    
66167 2d576c20-06e8-4fdf-a840-817ba599f332 entityStatement 2019-08-16 false registeredEntity Sabiedrība ar ierobežotu atbildību "Ownitlife" 2015-05-06 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    
93592 cf343561-1eef-4ede-a61e-2086897ea7f3 entityStatement 2019-07-25 false registeredEntity Andrupenes pagasta zemnieku saimniecība "Lejas stidziņas" 2015-05-06 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    
96449 fde8bc71-d390-496f-881e-56ddbb24c4f6 entityStatement 2018-10-12 false registeredEntity SIA "Pikton" 2015-05-06 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]) 
);