home / latvia

entity_statement

16 rows where foundingdate = "2005-03-23" 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
104643 debcb9f2-7044-4264-9720-3eab3db66424 entityStatement 2019-07-16 false registeredEntity Sabiedrība ar ierobežotu atbildību "EuroKom" 2005-03-23 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    
17699 9afb186b-9c56-4186-9dc1-2adfcee566ae entityStatement 2019-02-15 false registeredEntity SIA "DVI" 2005-03-23 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    
17700 12caf323-ccd1-4649-abe0-908be33894b3 entityStatement 2019-07-10 false registeredEntity Sabiedrība ar ierobežotu atbildību "Bed and Breakfast" 2005-03-23 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    
17701 e495200f-7446-40bf-ab57-c1e3d5cb1ba6 entityStatement 2019-07-10 false registeredEntity SIA "GK Financial Group" 2005-03-23 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    
17702 a8549345-2b7e-47fe-9201-55ca9aecfd22 entityStatement 2019-07-10 false registeredEntity SIA "LARO MM" 2005-03-23 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    
17703 c51b1b35-8272-4a08-9268-c0845dd208f7 entityStatement 2019-07-10 false registeredEntity Sabiedrība ar ierobežotu atbildību "SAN ESTERA" 2005-03-23 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    
17704 0ffb1e22-33b1-456a-871f-de015d68bce6 entityStatement 2019-07-10 false registeredEntity SIA "LAKENA" 2005-03-23 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    
17705 6d6ee074-a13c-4f3e-824c-4bbd764d5a07 entityStatement 2019-07-10 false registeredEntity SIA "ORTON" 2005-03-23 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    
17706 50bba88c-06ab-4315-81d7-ab31082c6eee entityStatement 2019-07-10 false registeredEntity SIA "ARKA projekts" 2005-03-23 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    
17707 0da71acb-aed8-4d04-a0b3-331c5644df13 entityStatement 2018-03-06 false registeredEntity SIA "Egļu Ciemats" 2005-03-23 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    
17708 79601e48-f395-4a7d-9c5d-d5319d5adcb2 entityStatement 2018-03-13 false registeredEntity SIA "Samskip" 2005-03-23 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    
17709 947c21a4-9546-45f4-b0de-d79bca8d31c8 entityStatement 2019-07-10 false registeredEntity SIA "EVELATUS" 2005-03-23 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    
17710 9ac24085-4bde-481a-afaf-da647dc468cc entityStatement 2019-07-10 false registeredEntity SIA "ERNO" 2005-03-23 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    
17711 e1d7049f-1a44-4bde-96d7-595ea164a0fb entityStatement 2019-07-10 false registeredEntity Sabiedrība ar ierobežotu atbildību "P.E.C. PRO ELEKTRIC COMPANY" 2005-03-23 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    
17712 4fe0e9a1-940c-4fd1-a0aa-855e92974403 entityStatement 2019-07-10 false registeredEntity Sabiedrība ar ierobežotu atbildību "Composite Latvija" 2005-03-23 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    
17713 7892e1e0-d325-43e1-857a-6cb4436061c0 entityStatement 2019-07-10 false registeredEntity Sabiedrība ar ierobežotu atbildību "S.A. PARTNERI" 2005-03-23 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    

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]) 
);
Powered by Datasette · Queries took 1288.409ms