entity_statement
8 rows where "foundingdate" is on date 2003-01-31
This data as json, CSV (advanced)
Suggested facets: statementdate, publicationdetails_publicationdate
| _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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14021 | 42040093-0fca-45a2-a9a0-c5bdecd7090f | entityStatement | false | registeredEntity | "STUDIO MODERNA" SIA | 2003-01-31 | 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 | |||
| 14022 | 9bf1e674-310a-4f17-a2dd-c4028ac8dc78 | entityStatement | 2018-03-28 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "B 138" | 2003-01-31 | 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 | ||
| 14023 | 628a4571-bdc9-4534-8a38-065ebda38f73 | entityStatement | 2018-03-13 | false | registeredEntity | SIA "ARHĪVA NAMS" | 2003-01-31 | 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 | ||
| 14024 | 9f391f56-5669-4fa9-8665-9cb2b1e574a8 | entityStatement | 2019-07-10 | false | registeredEntity | OPEN LOGISTICS SIA | 2003-01-31 | 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 | ||
| 14025 | 5c2e48b7-ab4e-4241-8b22-69bf106594b0 | entityStatement | 2019-07-10 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "ANGEL TURS" | 2003-01-31 | 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 | ||
| 642 | a4a535c1-d08c-4e91-aef1-a6b1bd7e5a90 | entityStatement | 2019-07-24 | false | registeredEntity | Rīgas rajona Mālpils pagasta "Plakupu" zemnieka saimniecība | 2003-01-31 | 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 | ||
| 94487 | d73fd758-262b-46c7-86eb-ea5a54751925 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "XP TECH" | 2003-01-31 | 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 | ||
| 94488 | 0e6b45f2-e5ec-4fea-8c2b-7c7da4e36dc3 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "AUTO-TOP" | 2003-01-31 | 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]) );