entity_statement
40 rows where "foundingdate" is on date 2018-03-15 and iscomponent = "false"
This data as json, CSV (advanced)
Suggested facets: statementdate (date), foundingdate (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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 102399 | d2a27dce-04b3-4a3e-bd3c-dd39ea57d09f | entityStatement | 2018-03-15 | false | registeredEntity | SIA "MGT SERVISS" | 2018-03-15 | 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 | ||
| 106104 | 319f81d5-acae-4a78-b396-5cda5f344423 | entityStatement | 2018-03-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Viļānu auto" | 2018-03-15 | 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 | ||
| 28426 | fcd7569e-5210-404f-9d3c-e7bbfbf40f66 | entityStatement | false | registeredEntity | "Laiks un Meti" | 2018-03-15 | 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 | |||
| 28427 | c9703f0f-ccd5-4996-b727-13d0d253dc24 | entityStatement | false | registeredEntity | "BDRB" | 2018-03-15 | 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 | |||
| 28428 | 1d9f33ba-3658-441b-aa4b-7e87e0398c44 | entityStatement | false | registeredEntity | "Disku golfa klubs "UFOGOLF"" | 2018-03-15 | 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 | |||
| 28429 | 0e2897ba-4cbb-4532-a4ad-7845e62206bc | entityStatement | false | registeredEntity | "Lāču iela" | 2018-03-15 | 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 | |||
| 28430 | 934718d8-100e-444f-8005-8e9a0300f44f | entityStatement | false | registeredEntity | "Peldu5 Saldus" | 2018-03-15 | 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 | |||
| 28431 | a6051ce6-3ac4-4d24-8bd0-9016b7afdef7 | entityStatement | false | registeredEntity | "Mārcienas Jaunā iela 2" | 2018-03-15 | 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 | |||
| 82007 | 7b06c280-5355-4d9d-b5b5-52765edbfd49 | entityStatement | 2018-03-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Auto Dinastija" | 2018-03-15 | 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 | ||
| 82008 | 4e828666-aad9-4f3e-a42d-51a6a80549ee | entityStatement | 2018-03-15 | false | registeredEntity | SIA "forma prima" | 2018-03-15 | 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 | ||
| 82009 | a1e5de5d-cfc2-4e82-8bd7-50882696fb2f | entityStatement | 2018-03-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "nbdesign" | 2018-03-15 | 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 | ||
| 82010 | 5c280dc2-47b3-4fd5-b718-f3cc50c7e238 | entityStatement | 2018-03-15 | false | registeredEntity | SIA Fitnes Jump | 2018-03-15 | 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 | ||
| 82011 | c6f32ed8-6d72-46d1-8edd-23bca058efb9 | entityStatement | 2018-03-15 | false | registeredEntity | SIA "NOVASPEC" | 2018-03-15 | 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 | ||
| 82012 | 6c7bd163-e931-40ef-a486-6ab83642850f | entityStatement | 2020-01-20 | false | registeredEntity | SIA "GREEN AUTO GREEN" | 2018-03-15 | 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 | ||
| 82013 | 0946f67e-00c1-439f-bd1a-f5936a6a8530 | entityStatement | 2018-03-15 | false | registeredEntity | SIA "INFINITA" | 2018-03-15 | 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 | ||
| 82014 | 8bdec7b0-ba5f-49a0-b1ac-6dd4130bb509 | entityStatement | 2018-03-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "TTA Labs" | 2018-03-15 | 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 | ||
| 82015 | 9781296b-b7b7-48e1-9e34-5df537e73346 | entityStatement | 2018-03-15 | false | registeredEntity | Runaholic SIA | 2018-03-15 | 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 | ||
| 82016 | f6b63c0a-74f2-4a77-9e13-af95eff32277 | entityStatement | 2018-03-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "ME Tech" | 2018-03-15 | 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 | ||
| 82017 | e7b5919d-8b17-484b-9f4b-ee66b8596966 | entityStatement | 2018-03-15 | false | registeredEntity | SIA OrionKa | 2018-03-15 | 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 | ||
| 82018 | b708ac1a-f851-4195-83f1-8e801aae5b63 | entityStatement | 2018-03-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Forest & Garden" | 2018-03-15 | 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 | ||
| 82019 | be25d65c-3040-49a9-aca1-d3273ed6ebe3 | entityStatement | 2019-03-26 | false | registeredEntity | SIA "ROSii" | 2018-03-15 | 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 | ||
| 82020 | 46bd9d9f-0f06-4d15-b3fc-064633f5cb65 | entityStatement | 2018-03-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "VIZARTS" | 2018-03-15 | 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 | ||
| 82021 | 90bb6c55-d794-471d-9ec9-a9738f3a4c3d | entityStatement | 2018-03-15 | false | registeredEntity | SIA "DIG ST" | 2018-03-15 | 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 | ||
| 82022 | f1bb414e-4595-47f7-826d-7bb9415b6c0c | entityStatement | 2018-03-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību VRONE.LV | 2018-03-15 | 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 | ||
| 82023 | 4428f8cd-14aa-4ebc-ac4e-ef84de64b512 | entityStatement | 2018-03-15 | false | registeredEntity | SIA "Nival" | 2018-03-15 | 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 | ||
| 82024 | 878c943c-cc2e-453c-93bc-6fb2d9894e85 | entityStatement | 2020-05-27 | false | registeredEntity | SIA HES | 2018-03-15 | 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 | ||
| 82025 | 579d19ae-64fc-43cf-883b-e9868660762e | entityStatement | 2018-03-15 | false | registeredEntity | SIA "LV amatnieki" | 2018-03-15 | 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 | ||
| 82026 | bad56d35-e9d7-430b-a0eb-c8c0c320a36f | entityStatement | 2018-03-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Prospera Lingua" | 2018-03-15 | 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 | ||
| 82027 | 94a3fc2e-717a-43fa-bf49-ce8406199517 | entityStatement | 2018-03-15 | false | registeredEntity | SIA "Yugen" | 2018-03-15 | 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 | ||
| 82028 | f07db16d-92b1-4ddd-9730-8a3e2d735855 | entityStatement | 2018-03-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Losker" | 2018-03-15 | 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 | ||
| 82029 | 61e3b271-a79e-4652-863c-071a9e025f88 | entityStatement | 2018-03-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Game Changer" | 2018-03-15 | 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 | ||
| 82030 | 9a68941a-cc80-4a1c-801b-d6ef4cc6352b | entityStatement | 2018-03-15 | false | registeredEntity | SIA "VIJA TOURS" | 2018-03-15 | 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 | ||
| 82031 | 65c31145-1f4f-4e12-afda-c0ab9a45ccb7 | entityStatement | 2018-08-14 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "42Rigas" | 2018-03-15 | 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 | ||
| 82032 | 792a19ab-70fa-4027-9ec3-5deaec90f276 | entityStatement | 2018-03-15 | false | registeredEntity | ANTIKS PAINT SIA | 2018-03-15 | 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 | ||
| 82033 | 72b29265-9f14-4049-98cc-9e5d26b5c5f4 | entityStatement | 2018-11-02 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "ARSANA" | 2018-03-15 | 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 | ||
| 82034 | 3c9ccbb3-d232-4288-9531-5c8293acefa6 | entityStatement | 2018-03-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "WePack" | 2018-03-15 | 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 | ||
| 82035 | a2d2fe06-d42b-4422-904c-fc8e65880e3d | entityStatement | 2018-03-15 | false | registeredEntity | SIA "FP Technologies" | 2018-03-15 | 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 | ||
| 82036 | e0294557-681f-40f1-a621-923518e744f4 | entityStatement | 2018-03-15 | false | registeredEntity | SIA "Parre Consult" | 2018-03-15 | 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 | ||
| 82037 | 3087f7ca-e0b8-4ae0-aad9-7bd6c6f29e1b | entityStatement | 2018-03-15 | false | registeredEntity | SIA "ShieldPack" | 2018-03-15 | 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 | ||
| 82038 | 0153544a-050c-4c53-af92-e819e63bdf0d | entityStatement | 2018-09-19 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Mobity" | 2018-03-15 | 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]) );