entity_statement
39 rows where "foundingdate" is on date 2017-06-05
This data as json, CSV (advanced)
Suggested facets: statementdate, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
102159 | 6ae1433d-a9bb-442a-9a46-5528fad10721 | entityStatement | 2019-07-16 | false | registeredEntity | SIA "Akvalat k" | 2017-06-05 | 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 | ||
105947 | b5736e69-a95a-4d99-8119-00364a4a6273 | entityStatement | 2019-07-16 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Zemes un debesu maģija" | 2017-06-05 | 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 | ||
111651 | 2191a7e3-3422-4631-82c0-59b932ea1c66 | entityStatement | 2019-07-16 | false | registeredEntity | SIA RZL | 2017-06-05 | 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 | ||
111652 | 63309f80-e535-436e-8811-9f04f5458ec3 | entityStatement | 2019-07-16 | false | registeredEntity | SIA "DERMOLV" | 2017-06-05 | 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 | ||
77591 | 70a1f54b-cf13-4fbf-8373-e61b9f003fd1 | entityStatement | 2020-08-28 | false | registeredEntity | SIA "Integrālās izglītības institūts- I3" | 2017-06-05 | 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 | ||
77592 | a3ee46d3-2bf8-4d74-98ea-6e1dc4bd5968 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "STELLA AKG" | 2017-06-05 | 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 | ||
77593 | 82143700-8cab-48f2-bd50-8b362e34fcfb | entityStatement | 2019-07-14 | false | registeredEntity | SIA "Māras ziedi" | 2017-06-05 | 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 | ||
77594 | a113f1b7-cac5-4fd1-8834-b5980aa9e593 | entityStatement | 2018-07-16 | false | registeredEntity | Pilnsabiedrība "Vektors TB" | 2017-06-05 | 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 | ||
77595 | 37d7715e-487e-479c-8cd0-cf8aa455862d | entityStatement | 2019-04-11 | false | registeredEntity | SIA "Starbridge" | 2017-06-05 | 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 | ||
77596 | 57bdb07f-21f3-4485-9d31-33f7a815bdee | entityStatement | 2019-07-15 | false | registeredEntity | SIA "EK logistics" | 2017-06-05 | 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 | ||
77597 | df04da5f-224d-4fdc-825a-da45cb39463d | entityStatement | 2019-07-15 | false | registeredEntity | SIA "AD.Ws" | 2017-06-05 | 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 | ||
77598 | 2b9b1521-2df8-4aca-aab4-b87949b60e79 | entityStatement | 2019-02-01 | false | registeredEntity | SIA AVERONA | 2017-06-05 | 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 | ||
77599 | 2ef93175-d33d-4478-9863-9390cd5f80c2 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Krāsainās Pērles" | 2017-06-05 | 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 | ||
77600 | 3ba26607-14d8-4d6e-b4a1-c42046e31dd0 | entityStatement | 2019-07-14 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Urban Woods" | 2017-06-05 | 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 | ||
77601 | cd654879-fbd5-48de-8172-f8dfa9ef133c | entityStatement | 2019-11-06 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "C.W.T. INTERNATIONAL" | 2017-06-05 | 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 | ||
77602 | cbe89c12-b3af-45a8-ab29-e0fd6233f6c0 | entityStatement | 2019-07-15 | false | registeredEntity | SIA SAKR | 2017-06-05 | 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 | ||
77603 | 888c0ee6-3014-4909-a249-2b810b6e064a | entityStatement | 2019-07-14 | false | registeredEntity | SIA "Gofingo" | 2017-06-05 | 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 | ||
77604 | fae74e03-7042-4fd3-aee3-e758ca700e47 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "authentic" | 2017-06-05 | 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 | ||
77605 | 1f654417-1ab3-448f-87e4-a4f3d10b6f6e | entityStatement | 2019-07-14 | false | registeredEntity | SIA "Lumino" | 2017-06-05 | 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 | ||
77606 | 222bf8c6-0aa9-4c92-9e5a-0f51abc2c38d | entityStatement | 2020-12-10 | false | registeredEntity | SIA Smart Finance Holding | 2017-06-05 | 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 | ||
77607 | e1e5679f-d992-4dcf-bab0-fba635f0ff13 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Innovative Media Centre" | 2017-06-05 | 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 | ||
77608 | 5f48fd0c-7491-4e3b-998e-cb935a2accc2 | entityStatement | 2019-07-15 | false | registeredEntity | Kardānu serviss SIA | 2017-06-05 | 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 | ||
77609 | 38a700d9-4c5f-4d09-93e3-e5ed0d1acf78 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "AADK" | 2017-06-05 | 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 | ||
77610 | 7105d78e-a7a1-4df3-b8b2-348467d79c90 | entityStatement | 2019-02-06 | false | registeredEntity | SIA "Kebway" | 2017-06-05 | 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 | ||
77611 | 01f3cbd6-eb42-4776-8b0c-03db57a12f14 | entityStatement | 2020-08-12 | false | registeredEntity | SIA "Nova Trader" | 2017-06-05 | 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 | ||
77612 | eb33b08d-fcb6-4cc2-8b20-74be2f685ce3 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Furserviss" | 2017-06-05 | 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 | ||
77613 | 0fd368ab-1188-4677-9eaf-376e8d722db1 | entityStatement | 2018-01-25 | false | registeredEntity | SIA "AV Marketplace" | 2017-06-05 | 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 | ||
77614 | 5dfc7325-7ed2-472b-81e5-16aa1706cef9 | entityStatement | 2019-07-14 | false | registeredEntity | SIA "SCANDIC PROJECTS" | 2017-06-05 | 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 | ||
77615 | 77fe7486-8239-4283-9d8a-21787c62eb82 | entityStatement | 2020-01-09 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Vertexo" | 2017-06-05 | 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 | ||
77616 | 0b5bb1d6-0740-4e35-8f90-6002e055181a | entityStatement | 2020-12-29 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "AK1" | 2017-06-05 | 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 | ||
77617 | 2e1ce896-6e2c-4dab-94cf-93ce1df42b43 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "WSWCF Agency" | 2017-06-05 | 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 | ||
77618 | efbba440-41d6-4368-abde-d6e7fe574bd4 | entityStatement | 2020-02-07 | false | registeredEntity | SIA "ADELIA" | 2017-06-05 | 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 | ||
77619 | 34287281-5838-4f42-8f7b-8b4699d1ac13 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "LATSOFA" | 2017-06-05 | 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 | ||
77620 | dc1818d5-0a55-4ac0-99b1-41fb8944425f | entityStatement | 2019-07-15 | false | registeredEntity | SIA MK Opus | 2017-06-05 | 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 | ||
77621 | 43cdd71f-ce52-4222-a4fe-4908c2256b7a | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Modras mēbeles" | 2017-06-05 | 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 | ||
77622 | ca5c9605-da3f-4b25-aa29-972ff3af04b9 | entityStatement | 2019-05-02 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "REKS Group" | 2017-06-05 | 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 | ||
92232 | 4a4be046-c950-4a37-8559-88edf422cb19 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "TransOV" | 2017-06-05 | 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 | ||
92233 | 1660e679-bd1c-4911-aeb3-a5580346a071 | entityStatement | 2019-07-14 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Salčuks" | 2017-06-05 | 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 | ||
92234 | 607953ff-0033-484f-af2c-6ea5a81ba6d2 | entityStatement | 2018-06-04 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Lexa ID" | 2017-06-05 | 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]) );