entity_statement
29 rows where foundingdate = "2019-02-15", iscomponent = "false" and statementdate = "2019-02-15"
This data as json, CSV (advanced)
Suggested facets: 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 102952 | 3050e10e-35b1-4cef-a500-e431225cb59d | entityStatement | 2019-02-15 | false | registeredEntity | SIA EMPRIK | 2019-02-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 | ||
| 102953 | 6179fa7b-5f5d-4e46-9c9c-3fa48f365dd2 | entityStatement | 2019-02-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Sailing Team Rīga" | 2019-02-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 | ||
| 102954 | dbbc2c04-e783-439c-96f2-d36d78a4445a | entityStatement | 2019-02-15 | false | registeredEntity | SIA AESEN Company | 2019-02-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 | ||
| 102955 | 76802928-e1ca-4a2c-9ea7-7fd2e7145649 | entityStatement | 2019-02-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Nelsons Family" | 2019-02-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 | ||
| 102957 | 26b7f409-e704-4634-8d3b-d1b7a3388b29 | entityStatement | 2019-02-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Vitauts&Co" | 2019-02-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 | ||
| 29329 | bd3df885-972c-4179-a338-5bc60689ae86 | entityStatement | 2019-02-15 | false | registeredEntity | "Prieka Spārni" | 2019-02-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 | ||
| 87373 | c8ba80f9-79a3-4486-8d55-eaad1570cab7 | entityStatement | 2019-02-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "UK Būve" | 2019-02-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 | ||
| 87374 | 9f124f5a-a2b6-4a89-82ae-e50b5bd5cd76 | entityStatement | 2019-02-15 | false | registeredEntity | SIA "VOSTOK" | 2019-02-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 | ||
| 87375 | 2930db25-a948-4dea-bc92-2ce46adc4f18 | entityStatement | 2019-02-15 | false | registeredEntity | SIA "BOCTOK" | 2019-02-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 | ||
| 87376 | d409e7d7-bc63-4ee2-be97-634600e589b1 | entityStatement | 2019-02-15 | false | registeredEntity | SIA GB Telekom | 2019-02-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 | ||
| 87377 | 7ffa4cfd-f685-42a5-b723-04a8f647cf15 | entityStatement | 2019-02-15 | false | registeredEntity | SIA "RTM" | 2019-02-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 | ||
| 87378 | 0f8fc0a5-f44e-44ec-8916-32951c553b61 | entityStatement | 2019-02-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "V-Construct" | 2019-02-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 | ||
| 87379 | 3ca28d54-33fc-4f63-ae25-820eb5d3b582 | entityStatement | 2019-02-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "ClinTrend" | 2019-02-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 | ||
| 87380 | ace8ef88-17ac-4a3e-8f08-915f539c4616 | entityStatement | 2019-02-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Kombucha Factory" | 2019-02-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 | ||
| 87381 | 5123b54c-14c7-45ed-a1bc-e63a8ae6c64d | entityStatement | 2019-02-15 | false | registeredEntity | SIA "Frenky" | 2019-02-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 | ||
| 87382 | 0e987840-49f1-4dfc-8fb2-1464980c3a7a | entityStatement | 2019-02-15 | false | registeredEntity | SIA "B&W idea" | 2019-02-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 | ||
| 87383 | 9b331510-2dfa-4b06-8924-104e7bff5e0a | entityStatement | 2019-02-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "ON consulting" | 2019-02-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 | ||
| 87384 | 2dc6b0ce-b6c0-46a9-a4f1-d7587b6c3bf1 | entityStatement | 2019-02-15 | false | registeredEntity | SIA "Jung" | 2019-02-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 | ||
| 87386 | 9a10c692-113f-4e08-a1a5-0f0f0d0359c8 | entityStatement | 2019-02-15 | false | registeredEntity | PS "Lat-China Partnership for Investment" | 2019-02-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 | ||
| 87387 | eb5d1a84-da21-4faf-9057-6947c8723cde | entityStatement | 2019-02-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Powactive" | 2019-02-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 | ||
| 87388 | f9b37470-c1ae-4454-88bb-ab0b527b5859 | entityStatement | 2019-02-15 | false | registeredEntity | SIA "Tavira" | 2019-02-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 | ||
| 87389 | feea9602-1102-4bed-8367-86dea439b4cc | entityStatement | 2019-02-15 | false | registeredEntity | SIA "JUNO MEDIA" | 2019-02-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 | ||
| 87390 | a997fcf2-84e5-4043-abd9-eeedd76cc583 | entityStatement | 2019-02-15 | false | registeredEntity | SIA "Webo" | 2019-02-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 | ||
| 87391 | abf2cb79-8cb3-417f-ab36-32b6007665d5 | entityStatement | 2019-02-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "DScapital" | 2019-02-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 | ||
| 87392 | 7f8765ac-b245-415f-bf36-20078a57706b | entityStatement | 2019-02-15 | false | registeredEntity | SIA Elektrodrošs | 2019-02-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 | ||
| 87393 | 789d2f0b-226c-4bbe-82a3-c0c0d3665434 | entityStatement | 2019-02-15 | false | registeredEntity | SIA "IG partneri" | 2019-02-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 | ||
| 87394 | e80a7e3f-f6dd-495e-bd33-78c66c9ae155 | entityStatement | 2019-02-15 | false | registeredEntity | SIA "ARCTIC TRAWLERS LTD." | 2019-02-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 | ||
| 92683 | ebcb6169-3b57-41dc-b57b-ebc9c8347380 | entityStatement | 2019-02-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "ALISING AA" | 2019-02-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 | ||
| 97374 | 27c011db-e1db-4bd2-8501-180af9756e55 | entityStatement | 2019-02-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "KMK eksperts" | 2019-02-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]) );