entity_statement
26 rows where foundingdate = "2012-10-05", "foundingdate" is on date 2012-10-05 and iscomponent = "false"
This data as json, CSV (advanced)
Suggested facets: 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 101014 | d7481c4f-9f0d-487f-8dfe-31cd89dc6102 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "INVESTMENT AND TRADE" | 2012-10-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 | ||
| 27540 | 074ea8aa-aca1-4df2-9300-10f85b4eac91 | entityStatement | 2019-07-27 | false | registeredEntity | Starptautiskais fonds "BETAHON" | 2012-10-05 | 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 | ||
| 50661 | 6c2450ff-737e-41d2-bae1-78735de624f6 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Boat rent" | 2012-10-05 | 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 | ||
| 50662 | 51be960b-54f4-4568-8e22-deb27f03989a | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Fortuna 77" | 2012-10-05 | 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 | ||
| 50663 | 3d37003a-9dcb-4048-83f8-822309c4359f | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Claims Handling Systems" | 2012-10-05 | 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 | ||
| 50664 | 043e6103-25fe-4719-a54c-63bf973e163f | entityStatement | 2019-02-01 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Ambercar" | 2012-10-05 | 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 | ||
| 50665 | 8ba6edd4-2e64-4370-9b05-0aec30ccbe05 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "M-Trade" | 2012-10-05 | 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 | ||
| 50666 | f43e6d9b-1315-4bb2-ac1e-6fdd1eaced1d | entityStatement | 2020-07-30 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "RMP19" | 2012-10-05 | 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 | ||
| 50667 | 77a3a4df-9b01-475b-aaea-879dd227e2f4 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Oromēbeles" | 2012-10-05 | 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 | ||
| 50668 | 3608222b-b5f7-4e30-a7d2-40862ccb639c | entityStatement | 2019-07-13 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "INVESTMENT ROADS" | 2012-10-05 | 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 | ||
| 50669 | 82823aaf-6754-49b2-9751-f4b4a8b9f3d8 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Sniega serviss" | 2012-10-05 | 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 | ||
| 50670 | 579f68e3-b178-4653-b082-c229040c3f44 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Ultimate Capital" | 2012-10-05 | 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 | ||
| 50671 | 2b009a7c-67c0-4979-8fba-a6e20145961d | entityStatement | 2019-07-13 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "VINTER AIR LV" | 2012-10-05 | 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 | ||
| 50672 | 43fc520f-d5f1-46bf-9878-d4f0a169de13 | entityStatement | 2019-07-13 | false | registeredEntity | SIA "SPEEDY COMPANY" | 2012-10-05 | 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 | ||
| 50673 | 81da1643-5720-44b8-b66d-59ec62096cff | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "VERO Consulting" | 2012-10-05 | 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 | ||
| 50674 | 00cdf502-c37a-42e7-96e1-b19b10617e28 | entityStatement | 2019-06-25 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "FIN.GB" | 2012-10-05 | 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 | ||
| 50675 | fc78e9ef-2367-4f8e-a189-1d852946575e | entityStatement | 2019-07-15 | false | registeredEntity | SIA "STANCE GARAGE" | 2012-10-05 | 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 | ||
| 50676 | d06c39be-01ab-4da0-b144-d3e93d57251e | entityStatement | 2019-07-15 | false | registeredEntity | SIA "ZIPLINE" | 2012-10-05 | 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 | ||
| 50677 | 1f91ae88-98f8-47e8-8e28-5f963d353365 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Saules Zobārstniecība" | 2012-10-05 | 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 | ||
| 50678 | 223e11cd-ad0b-44a7-b0a4-413e6c04810d | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "RT Rītupe" | 2012-10-05 | 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 | ||
| 50679 | 45bce099-3fa6-4861-a204-ede5deb287a1 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "BND Gaming" | 2012-10-05 | 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 | ||
| 50680 | bd5493ed-6c45-4fce-a0b3-b4093fbbec79 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "AUSTRUMI 5" | 2012-10-05 | 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 | ||
| 50681 | 63425204-a0c2-499c-aaa6-5ab9a67abdc3 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Energostandarts" | 2012-10-05 | 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 | ||
| 50682 | a55f11c8-60fd-4872-8e99-f2ca73a99f2c | entityStatement | 2019-07-15 | false | registeredEntity | SIA "DP dizains" | 2012-10-05 | 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 | ||
| 50683 | a984bd5c-2e28-46d9-a7db-acfae88562bd | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Stari Plus" | 2012-10-05 | 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 | ||
| 95865 | db5e53c0-2b32-4b5f-baec-6a0b95ad095e | entityStatement | 2018-02-02 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Picu Bode" | 2012-10-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]) );