entity_statement
11 rows where foundingdate = "2005-08-23", "foundingdate" is on date 2005-08-23 and iscomponent = "false"
This data as json, CSV (advanced)
Suggested facets: publicationdetails_publicationdate, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 108798 | 800b59f5-540e-44d3-9b23-ae8359db24e8 | entityStatement | 2019-07-16 | false | registeredEntity | SIA "TANDEMTRANS" | 2005-08-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 | ||
| 108799 | bdf66883-eebd-4f8b-88d1-6cf932f893ad | entityStatement | 2018-05-16 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "EVENA TRAVEL" | 2005-08-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 | ||
| 114032 | e7387a6f-8768-4427-bd81-87591bd5de10 | entityStatement | 2019-07-26 | false | registeredEntity | Skaņkalnes pagasta I.Slotiņa zemnieka saimniecība "BIRZES" | 2005-08-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 | ||
| 18587 | 2988946a-da71-4ff9-8182-a2bab0ca946b | entityStatement | 2019-06-27 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "ALDEKO" | 2005-08-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 | ||
| 18588 | 935e2d98-2e11-4846-8920-262e36b57d1c | entityStatement | 2019-07-10 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "R2A" | 2005-08-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 | ||
| 18589 | b07d6be5-d6b2-40f2-8d21-6026f86b5bcf | entityStatement | 2019-07-10 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Zigmunds un partneri" | 2005-08-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 | ||
| 18590 | 5c13191d-56e7-434d-ac8f-97306f44208e | entityStatement | 2020-02-06 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "BALTTERRA" | 2005-08-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 | ||
| 18591 | 4960f381-c2fc-4b1f-af33-7d27a7524302 | entityStatement | 2019-07-10 | false | registeredEntity | SIA "Kuvera pluss" | 2005-08-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 | ||
| 18592 | 4bea9c9a-f355-441c-ad3a-5d1a8c68d32b | entityStatement | 2019-07-10 | false | registeredEntity | SIA "Matīsa 103" | 2005-08-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 | ||
| 90241 | ce9e0f9d-2c92-4c4c-89f8-c45863d5fc4d | entityStatement | 2019-03-21 | false | registeredEntity | SIA "SEAMASTER" | 2005-08-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 | ||
| 90242 | f45c200b-989b-4830-8c23-5b2b38f09c82 | entityStatement | 2018-07-11 | false | registeredEntity | AS "INVESTMENT ACTIVITY" | 2005-08-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 |
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]) );