entity_statement
9 rows where "foundingdate" is on date 2005-12-09, incorporatedinjurisdiction_name = "Latvia" and iscomponent = "false"
This data as json, CSV (advanced)
Suggested facets: statementdate
| _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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 108824 | 83fecf8f-e0ba-406f-8b18-51d98f403211 | entityStatement | 2019-07-16 | false | registeredEntity | SIA "Kamilli" | 2005-12-09 | 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 | ||
| 19362 | f0f41f5f-2e6b-4bda-a2ef-710d1ecbaf2a | entityStatement | 2019-07-10 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "MOSENC" | 2005-12-09 | 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 | ||
| 19363 | dd78f519-5bda-4dbe-a368-1fec6a67de28 | entityStatement | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "LDZ CARGO" | 2005-12-09 | 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 | |||
| 19364 | d5bdf548-f92f-4a60-9b09-96e35f4c3e4c | entityStatement | false | registeredEntity | "adidas Baltics" SIA | 2005-12-09 | 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 | |||
| 19366 | b5666cad-8694-4741-b126-da07c0f7e0e0 | entityStatement | 2019-07-10 | false | registeredEntity | SIA "NNK-DET" | 2005-12-09 | 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 | ||
| 19367 | 39b011c3-8f0d-48ee-a5e2-4b6500b75ea0 | entityStatement | 2019-07-10 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Biznesa un audita centrs" | 2005-12-09 | 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 | ||
| 19368 | 5b5a7e77-fef3-40b5-ad25-eda39d637b94 | entityStatement | 2019-07-10 | false | registeredEntity | "EVROPLUSS" SIA | 2005-12-09 | 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 | ||
| 19369 | 4c404cb2-3fc9-4123-823d-5f07520d6c54 | entityStatement | 2019-07-10 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Zeltkalni M.G." | 2005-12-09 | 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 | ||
| 99899 | 51f32004-8ccd-4f3d-a8c9-4978e472f508 | entityStatement | 2018-04-12 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Delfin Investment" | 2005-12-09 | 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]) );