entity_statement
10 rows where foundingdate = "2011-01-05", iscomponent = "false" and statementdate = "2019-07-11"
This data as json, CSV (advanced)
Suggested facets: 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 40182 | b3c216a9-52a5-46ab-a0de-1369ab3fae00 | entityStatement | 2019-07-11 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "PROGRES REFORM" | 2011-01-05 | 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 | ||
| 40183 | 442ea6ad-28e0-412f-9953-45a7b8e8f590 | entityStatement | 2019-07-11 | false | registeredEntity | GETI SIA | 2011-01-05 | 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 | ||
| 40184 | 45ba3234-013e-4bf9-bd4a-ec2d970c3698 | entityStatement | 2019-07-11 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "LINELE" | 2011-01-05 | 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 | ||
| 40185 | b84f29af-017d-456b-9003-65a62ee92ec0 | entityStatement | 2019-07-11 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "HELLAS FORWARDING" | 2011-01-05 | 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 | ||
| 40186 | 9aee7cc5-1469-4b57-865e-71b916170a97 | entityStatement | 2019-07-11 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Hiligzeem accounting office" | 2011-01-05 | 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 | ||
| 40189 | 2358733f-dd3e-4057-b9e1-3500a566262b | entityStatement | 2019-07-11 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "EDILLIJA" | 2011-01-05 | 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 | ||
| 40191 | 6f84fab2-6851-4ff7-a73a-108918685b73 | entityStatement | 2019-07-11 | false | registeredEntity | SIA "NV OPTIMA" | 2011-01-05 | 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 | ||
| 40192 | 654d68e8-0e81-4bc7-8797-45d98159c1cf | entityStatement | 2019-07-11 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Creative Dimension" | 2011-01-05 | 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 | ||
| 40193 | e01b919f-74fa-4cc3-abe3-00f7d9a4472d | entityStatement | 2019-07-11 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Māja Lukss" | 2011-01-05 | 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 | ||
| 40194 | dc9f3326-46f8-43cd-85b7-13a22fd2b298 | entityStatement | 2019-07-11 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Egle un Egle" | 2011-01-05 | 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]) );