entity_statement

32 rows where "foundingdate" is on date 2012-11-21 and iscomponent = "false"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: statementdate, publicationdetails_publicationdate, statementdate (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
101042 342ce960-ff86-4c23-9e8d-5baeb7435194 entityStatement 2019-07-15 false registeredEntity SIA "AGAWE" 2012-11-21 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    
105353 c31e1cf4-c6b0-47da-8168-c1a03fbc98a8 entityStatement 2019-07-16 false registeredEntity Sabiedrība ar ierobežotu atbildību "Steeldram" 2012-11-21 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    
51345 2037c94e-29ba-4999-9855-728a1bd3b470 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "IP WORLD" 2012-11-21 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    
51346 0c0e78b2-515c-499c-adae-cd07308562c9 entityStatement 2018-04-11 false registeredEntity SIA "SB Factory" 2012-11-21 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    
51347 82ebc6ab-db40-4f59-8fc3-d48e79a5d3f3 entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "Tiver servis" 2012-11-21 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    
51348 c1796eb4-8858-4a2b-95da-cb5d2a3ab7d1 entityStatement 2018-05-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "Imprimus" 2012-11-21 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    
51349 19fd6d3b-590d-4e51-9f48-e6ecc8382acd entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "MARITIME SERVICES COMPANY" 2012-11-21 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    
51350 89d265da-7428-47fb-a946-96dfcf9092a4 entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "DIVIKS" 2012-11-21 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    
51351 c8c1b3a2-e777-4408-b399-1f0af78c753b entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "BLACKSTONE CHASE ASSETS" 2012-11-21 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    
51352 db0c4bbc-d1c6-40e5-8845-21bbf8589731 entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "Rumus" 2012-11-21 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    
51353 a2651cb8-3e79-4e20-82e4-04ddc878d52e entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "FaberLat" 2012-11-21 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    
51354 6849f108-bd17-41ec-b615-42e9fe4b4580 entityStatement 2019-07-13 false registeredEntity SIA "MadeDay" 2012-11-21 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    
51355 018338b6-d055-4354-9928-d4491838a579 entityStatement 2019-07-13 false registeredEntity SIA "Astra Apsardze" 2012-11-21 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    
51356 dc359dda-5df5-4a38-8426-69f77d69de5a entityStatement 2019-03-07 false registeredEntity Sabiedrība ar ierobežotu atbildību "MEDROAD" 2012-11-21 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    
51357 ffdbb5d4-97e8-419b-9670-43ff381c91b3 entityStatement 2018-02-15 false registeredEntity SIA "Centrus parking" 2012-11-21 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    
51358 883d4090-0656-4210-8d09-9b88d7eb272e entityStatement 2019-07-15 false registeredEntity SIA "Key Properties" 2012-11-21 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    
51359 a1a53ee4-1804-482f-b6d6-716c48153b5f entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "GB Construction" 2012-11-21 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    
51360 f29ab605-5cce-45e9-bda3-ac81c65f457c entityStatement 2019-04-02 false registeredEntity SIA "Latvian Lawyers" 2012-11-21 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    
51361 88e914ff-2f7c-4baf-b417-b70e7bed9b9b entityStatement 2018-03-06 false registeredEntity SIA "Veiksmes īpašumi" 2012-11-21 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    
51362 c08eacf6-8ea1-459d-bd7b-9739de03eb4c entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "WOOW" 2012-11-21 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    
51363 2dffc83b-5f2a-494c-ad84-047ef93e0c37 entityStatement 2019-07-15 false registeredEntity SIA "Intenica" 2012-11-21 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    
51364 874f6078-147d-4104-80cb-980c57bf4827 entityStatement 2020-01-08 false registeredEntity SIA "Creativus Agency" 2012-11-21 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    
51365 459dc673-4e14-448c-aa98-77cbd37282a2 entityStatement 2019-07-15 false registeredEntity SIA "AKIRA 8" 2012-11-21 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    
51366 a1a3be05-e6ab-4661-a9f7-6225cc08247c entityStatement 2019-07-15 false registeredEntity SIA "Target Property" 2012-11-21 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    
51367 bc99e6af-bc64-4efb-9deb-d61f5bb72425 entityStatement 2018-10-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "CER 7" 2012-11-21 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    
51368 1e228cba-90ed-4876-b3d2-3549967b7daf entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "OKVI" 2012-11-21 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    
51369 fc569921-5dde-4764-bd1c-50af34571180 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "armilestibu.lv" 2012-11-21 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    
51370 7c0e666b-6c0a-4ddd-bde7-90e0df9e1fbc entityStatement 2020-07-30 false registeredEntity Sabiedrība ar ierobežotu atbildību "AEGO" 2012-11-21 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    
91249 0965e2a7-f491-435d-8ac7-e6f8bb98d977 entityStatement 2019-07-14 false registeredEntity SIA "AGROINVEST LV" 2012-11-21 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    
91250 06f630c0-41d7-4577-840a-2df0b12ed887 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "GEMINI NS" 2012-11-21 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    
95900 47bf0e05-b03c-4043-b1b7-9f332dd69739 entityStatement 2018-06-26 false registeredEntity SIA "Ledland Baltics" 2012-11-21 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    
95901 c5564616-d444-4ce9-b79d-f6dcda9c38d3 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Priede L" 2012-11-21 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]) 
);