entity_statement
35 rows where "foundingdate" is on date 2018-08-23
This data as json, CSV (advanced)
Suggested facets: statementdate, publicationdetails_publicationdate, statementdate (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
102522 | 649fcd0e-7752-47a9-bd83-b88366f6cadb | entityStatement | 2018-08-23 | false | registeredEntity | SIA "AVANGARDE" | 2018-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 | ||
102523 | 134aa1da-65ac-4369-8eaa-964e7b554731 | entityStatement | 2018-08-23 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Megalodon" | 2018-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 | ||
112099 | effea328-1408-48f4-81e1-e537c88aa083 | entityStatement | 2018-08-23 | false | registeredEntity | Bille ID SIA | 2018-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 | ||
112100 | edab29ff-7a74-4084-b7bb-67a6b822affc | entityStatement | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Lediņi mēbeles" | 2018-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 | |||
28855 | b056cf30-d6f5-4d57-afdd-73f104eb6725 | entityStatement | false | registeredEntity | "PILSĒTAS BULVĀRIS 11" | 2018-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 | |||
28856 | b9b2eb16-083f-4d7f-a29a-641e0f94c574 | entityStatement | 2018-08-23 | false | registeredEntity | ReWild | 2018-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 | ||
28857 | bbe4385e-da87-4f11-b71e-b4e9b9b9e0b2 | entityStatement | false | registeredEntity | MOTO POINT | 2018-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 | |||
28858 | 0e34bc56-c625-452b-8612-f502b1b26364 | entityStatement | false | registeredEntity | Latgales mednieku un makšķernieku biedrība | 2018-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 | |||
28859 | fa87666e-6a07-4100-9cd9-18ca15eceb3c | entityStatement | false | registeredEntity | LATVIJAS VOLVO APVIENĪBA | 2018-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 | |||
84652 | f1a71488-a87e-45cb-942d-fd0ef97f8eed | entityStatement | 2018-08-23 | false | registeredEntity | SIA "Algoritmics LV" | 2018-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 | ||
84653 | 892880a4-f711-4405-8a67-49249bae6d20 | entityStatement | 2018-08-23 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "IN&GO" | 2018-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 | ||
84654 | a8df8d41-7d82-4166-aabd-696d0b2bf145 | entityStatement | 2018-08-23 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "ADF BILL" | 2018-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 | ||
84655 | 574cf9d6-e4e6-4f1b-a488-493a6d8a7684 | entityStatement | 2018-08-23 | false | registeredEntity | SIA Posiitum | 2018-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 | ||
84656 | 0d8d14d7-abe3-4940-a6d9-6c6a4a0a7811 | entityStatement | 2018-08-23 | false | registeredEntity | SIA "Time Crystal" | 2018-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 | ||
84657 | 44b53e66-c0bf-4188-86da-54259d739fc5 | entityStatement | 2018-08-23 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Sofimico" | 2018-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 | ||
84658 | 942a50fc-2b9f-40da-9d41-87aaf59f9b55 | entityStatement | 2020-03-20 | false | registeredEntity | SIA Sanda and Sanita Accountancy | 2018-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 | ||
84659 | 01802623-fb0d-4d6c-9b1e-bccebddd4d98 | entityStatement | 2020-12-10 | false | registeredEntity | SIA TM Trade | 2018-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 | ||
84660 | 5b5156c8-dc99-447b-b809-f81bb5b1b93d | entityStatement | 2018-08-23 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "CarryAll" | 2018-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 | ||
84661 | cc975863-c497-481d-911b-084bc250b87f | entityStatement | 2018-08-23 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "I D Construction" | 2018-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 | ||
84662 | d0f1c684-62d8-4dc5-b249-38f73720c7d0 | entityStatement | 2018-12-27 | false | registeredEntity | GSH SIA | 2018-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 | ||
84663 | ddbf01a9-82bb-44f4-bc4d-265edcbc1055 | entityStatement | 2018-08-23 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "RG konsultācijas" | 2018-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 | ||
84664 | f62e2c85-ab26-4c4a-97a7-fb914fab74db | entityStatement | 2018-08-23 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Water Leak Pro" | 2018-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 | ||
84665 | 140e1d35-1ee1-4d4e-8b63-55d712d6e50e | entityStatement | 2018-08-23 | false | registeredEntity | SIA "BenyAmi T" | 2018-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 | ||
84666 | c6a876c6-a69a-492e-87bc-d8e245a777b9 | entityStatement | 2018-08-23 | false | registeredEntity | SIA Stabil Invest Latvia | 2018-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 | ||
84667 | 3417e23e-1a11-4a84-8f42-20ed30a884eb | entityStatement | 2018-08-23 | false | registeredEntity | SIA "FLOWER SECRET" | 2018-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 | ||
84668 | b552700e-ff1e-4076-89c2-afff5be473e5 | entityStatement | 2018-11-07 | false | registeredEntity | ORGANIKA DISTRIBUTION BALTIC SIA | 2018-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 | ||
84669 | 2df2e815-679b-4557-ae26-f25a1c36b35c | entityStatement | 2018-08-23 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Mākoņos" | 2018-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 | ||
84670 | 67c44a35-1ede-4724-a7a1-51e030178b01 | entityStatement | 2018-08-23 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "KERINE" | 2018-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 | ||
84671 | 70ab5ef1-7731-490c-8155-6861fd6c9e6d | entityStatement | 2020-09-18 | false | registeredEntity | SIA "LM Apartments" | 2018-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 | ||
84672 | 3ef21263-badc-4e8d-8dce-147235be398c | entityStatement | 2018-08-23 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Appelle" | 2018-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 | ||
84673 | 5c588db0-e156-4a22-bc65-740277b8e766 | entityStatement | 2018-08-23 | false | registeredEntity | SIA STAIRSUP | 2018-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 | ||
84674 | 27391be6-0802-4a70-beb6-33e5c6d5224e | entityStatement | 2018-08-23 | false | registeredEntity | SIA "KAROZO" | 2018-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 | ||
92536 | e616bee1-f97d-42be-ac05-6885e1984f2e | entityStatement | 2018-08-23 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Stende Forest" | 2018-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 | ||
92537 | 2bc6df28-97a8-45b7-8ece-f3a322f07f40 | entityStatement | 2018-08-23 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "BT Account" | 2018-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 | ||
92538 | 9c21427a-d41c-4f5e-9538-f41889e821e4 | entityStatement | 2018-08-23 | false | registeredEntity | SIA ValueBringers | 2018-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]) );