entity_statement
23 rows where "foundingdate" is on date 2017-03-28, incorporatedinjurisdiction_code = "LV" and "publicationdetails_publicationdate" is on date 2021-01-19
This data as json, CSV (advanced)
Suggested facets: statementdate (date), foundingdate (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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 102117 | 8c62b4f3-4118-4a03-8385-03e569406a1a | entityStatement | 2019-07-16 | false | registeredEntity | SIA "MASTERforce" | 2017-03-28 | 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 | ||
| 105922 | 4697dbfe-0daf-4915-9bbb-70996714d096 | entityStatement | 2019-07-16 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Kidstock" | 2017-03-28 | 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 | ||
| 111598 | ab2e734b-673c-4e7a-a07c-f6e3fa543310 | entityStatement | 2019-07-16 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Servot" | 2017-03-28 | 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 | ||
| 76558 | 6f77a666-23ac-4291-80d4-9f9677bb8bc9 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "WHITE SAND DESIGN" | 2017-03-28 | 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 | ||
| 76559 | c53e29ef-facc-4f1f-bf06-96afc8185472 | entityStatement | 2019-07-14 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Top Management" | 2017-03-28 | 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 | ||
| 76560 | 645d3ed9-603e-4726-953f-b1c9cb7f76df | entityStatement | 2018-04-24 | false | registeredEntity | SIA "SDL" | 2017-03-28 | 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 | ||
| 76561 | 036eb8e4-ffa7-4429-af69-005db3f50771 | entityStatement | 2019-07-14 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Diamond Dream" | 2017-03-28 | 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 | ||
| 76562 | 927836e9-9626-4fdc-bf79-1b4dac8d8e96 | entityStatement | 2019-07-14 | false | registeredEntity | SIA "BLACK PEPPER LTD" | 2017-03-28 | 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 | ||
| 76563 | eef9092a-899b-4689-96a4-5a288c1bef12 | entityStatement | 2020-05-26 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Alexius" | 2017-03-28 | 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 | ||
| 76564 | af0e2668-1990-4f48-9201-7e59612da128 | entityStatement | 2018-11-05 | false | registeredEntity | SIA Bacchus | 2017-03-28 | 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 | ||
| 76565 | c061ac4a-843d-4604-aef6-7a044644f767 | entityStatement | 2019-07-14 | false | registeredEntity | SIA "Shiawasedo Europe" | 2017-03-28 | 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 | ||
| 76566 | 094106ac-b228-49d7-92a7-b6b32a987a19 | entityStatement | 2020-12-29 | false | registeredEntity | SIA NIKA-BŪVSERVISS | 2017-03-28 | 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 | ||
| 76567 | 30d97ec1-817b-4fac-918a-375f82c98a36 | entityStatement | 2019-07-08 | false | registeredEntity | SIA "Integrated Crewing Services" | 2017-03-28 | 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 | ||
| 76568 | 5fa9ae17-0c21-430f-9904-a7543d7001a8 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "ADV Consulting" | 2017-03-28 | 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 | ||
| 76569 | d972d526-77c8-481a-8d1b-2b50b602379b | entityStatement | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Edieni un Co" | 2017-03-28 | 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 | |||
| 76570 | f2f8b053-25cd-4eb2-a787-e2e29788cb37 | entityStatement | 2018-05-17 | false | registeredEntity | SIA "Projekts B" | 2017-03-28 | 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 | ||
| 76571 | 5fd58239-754d-4597-bba4-8a5a4be5cf52 | entityStatement | 2018-06-07 | false | registeredEntity | Legalbet SIA | 2017-03-28 | 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 | ||
| 76572 | d0b195a7-a1e5-4673-8839-f255025492be | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Europe Gateway" | 2017-03-28 | 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 | ||
| 76573 | 4bf00103-8098-48cc-8737-7e2e32a95d81 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "ADDIRECT" | 2017-03-28 | 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 | ||
| 76574 | a9729afa-e5b0-44aa-84b5-246dacbe4bd4 | entityStatement | 2018-09-11 | false | registeredEntity | SIA "KDA Company" | 2017-03-28 | 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 | ||
| 76575 | 55aa54d3-1e25-4a4a-a6d6-09008b516c19 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "KETA" | 2017-03-28 | 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 | ||
| 76576 | cb3e7a7b-18d3-4ab9-9e2e-312cc4e48480 | entityStatement | 2019-07-14 | false | registeredEntity | SIA Riso 7 | 2017-03-28 | 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 | ||
| 76577 | ace539f6-ae6b-4c55-8126-043d4fe9c728 | entityStatement | 2020-08-20 | false | registeredEntity | SIA RENAMS | 2017-03-28 | 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]) );