entity_statement
16 rows where foundingdate = "2005-03-23" and iscomponent = "false"
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
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]) );