entity_statement
25 rows where foundingdate = "2015-02-18" and publicationdetails_publicationdate = "2021-01-18"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 64721 | cd8ec0bd-d8b4-47e2-8b38-f2c192519f1d | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Snaillat" | 2015-02-18 | 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 | ||
| 64744 | c031453e-1185-4909-88b5-815e2bc1fa77 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Artcore" | 2015-02-18 | 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 | ||
| 64745 | 3ba729a2-47ef-41f3-b079-5abdf59cff03 | entityStatement | 2018-03-16 | false | registeredEntity | SIA "J.S.Hamilton Baltic" | 2015-02-18 | 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 | ||
| 64746 | f84bf5c8-d7a9-4ac5-a018-3a4628af6ace | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "The store" | 2015-02-18 | 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 | ||
| 64747 | 242d3c18-1630-481f-94ee-be5ba5260a83 | entityStatement | 2019-09-17 | false | registeredEntity | Pilnsabiedrība "Daugavas KREISĀ krasta uzturētājs" | 2015-02-18 | 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 | ||
| 64748 | b117b08c-c00d-4a97-bfd4-854a73df0a58 | entityStatement | 2018-08-29 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "EKOBALTENERGO" | 2015-02-18 | 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 | ||
| 64749 | 55489383-4f88-426c-9458-6bd5a139a580 | entityStatement | 2019-07-14 | false | registeredEntity | SIA "Zilzobis" | 2015-02-18 | 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 | ||
| 64750 | 2ce339e2-414c-48d8-b21e-249fde0a735e | entityStatement | 2020-10-01 | false | registeredEntity | SIA SELF STORAGE | 2015-02-18 | 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 | ||
| 64751 | 174ca95b-900a-46e3-92fc-3c223dfa948a | entityStatement | 2018-04-21 | false | registeredEntity | SIA "Alterno M" | 2015-02-18 | 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 | ||
| 64752 | cf92a31f-c235-4501-b1e6-e0ce8dff5ee7 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "BALTREVIS" | 2015-02-18 | 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 | ||
| 64753 | 565daaeb-7d50-4e41-971a-7dd9a11a7563 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Rubīns Logistics" | 2015-02-18 | 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 | ||
| 64754 | 7221e668-9c50-44c6-b35b-bb03bf637e75 | entityStatement | 2019-07-14 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Barons Export" | 2015-02-18 | 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 | ||
| 64755 | 479ed66b-3f15-44cc-918b-838afbacc355 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "GreenFood" | 2015-02-18 | 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 | ||
| 64756 | 680ee901-9fbe-4621-a84c-d9676c247091 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Tattoo Removal" | 2015-02-18 | 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 | ||
| 64757 | d4e65f9c-f9dd-42e3-8c39-94797b934e1f | entityStatement | 2019-07-15 | false | registeredEntity | SIA "BCT Auto" | 2015-02-18 | 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 | ||
| 64758 | 87d4db6e-41c5-4d5e-b7fc-ed7f30a74be7 | entityStatement | 2019-07-14 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "FILEJA" | 2015-02-18 | 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 | ||
| 64759 | c50fcabd-802f-427c-9728-06c71edfbd3c | entityStatement | 2020-09-24 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Riga Investments" | 2015-02-18 | 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 | ||
| 64760 | 69d78499-63e7-4063-9f4e-af02129ea4e4 | entityStatement | 2019-09-17 | false | registeredEntity | Pilnsabiedrība "Daugavas LABĀ krasta uzturētājs" | 2015-02-18 | 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 | ||
| 64761 | 270f531b-09b3-43ee-bbc7-530a8a1e9994 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "FNC management" | 2015-02-18 | 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 | ||
| 64762 | e1484261-85c7-4769-90db-f5fd08c49afb | entityStatement | 2018-03-15 | false | registeredEntity | SIA "MILLA LUCK" | 2015-02-18 | 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 | ||
| 64763 | 950c5749-08f3-483c-8001-07633c6e7d29 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Radošuma attīstības centrs" | 2015-02-18 | 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 | ||
| 64764 | 2c017e01-9990-4b31-acff-c776706858ce | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "EF investīcijas" | 2015-02-18 | 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 | ||
| 64765 | 0c889937-5864-490d-ba62-c28f365f07d3 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Powerwoman events" | 2015-02-18 | 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 | ||
| 64766 | afbbc126-f00e-493a-b724-f1af249ed960 | entityStatement | 2020-07-16 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Norden Group" | 2015-02-18 | 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 | ||
| 64767 | e0e3e8e9-3976-4791-bf3e-a0aa969dcfe4 | entityStatement | 2019-07-14 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "CAMDEN" | 2015-02-18 | 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]) );