entity_statement
28 rows where "foundingdate" is on date 2016-07-29 and iscomponent = "false"
This data as json, CSV (advanced)
Suggested facets: statementdate, publicationdetails_publicationdate, statementdate (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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 105841 | 7cfe5e71-463d-40e9-a5af-e504cc0c2985 | entityStatement | 2019-07-16 | false | registeredEntity | SIA "Faktors X Brīvs" | 2016-07-29 | 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 | ||
| 105842 | 5bb08665-f4c9-43cc-980a-ec4ed96da75c | entityStatement | 2019-07-16 | false | registeredEntity | SIA "MyKayak" | 2016-07-29 | 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 | ||
| 111443 | bd478eac-ae05-438e-8dca-a189b650b374 | entityStatement | 2019-07-16 | false | registeredEntity | SIA "DoDž" | 2016-07-29 | 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 | ||
| 73080 | aa44133d-70a3-42be-91e3-c1c1d9218973 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "RxVision" | 2016-07-29 | 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 | ||
| 73081 | a75b6db1-859d-495d-815a-05fbd3960bc3 | entityStatement | 2019-07-14 | false | registeredEntity | SIA "ASF install" | 2016-07-29 | 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 | ||
| 73082 | a90b3ad4-8c9e-4ee5-916f-8b014a23c303 | entityStatement | 2020-01-31 | false | registeredEntity | SIA "Gaisma 8" | 2016-07-29 | 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 | ||
| 73083 | 7a72c21c-ef4c-4089-934a-65c9af65d6ec | entityStatement | 2019-07-15 | false | registeredEntity | SIA "ROSTLER" | 2016-07-29 | 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 | ||
| 73084 | b30e8113-affe-4b26-bc8b-4d01da3a849a | entityStatement | 2019-07-15 | false | registeredEntity | "Grand Room" SIA | 2016-07-29 | 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 | ||
| 73085 | c30e7595-bd03-49f3-849b-9c3113c56afc | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Anzolo" | 2016-07-29 | 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 | ||
| 73086 | e267ba68-593a-4944-9957-489598d465d6 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "JD Koks" | 2016-07-29 | 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 | ||
| 73087 | 17ef2e6c-1f60-4d40-ba9a-2f83dd01c8f1 | entityStatement | 2019-06-18 | false | registeredEntity | SIA "Clean Up Group" | 2016-07-29 | 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 | ||
| 73088 | 84ce9cef-620d-4faa-88c7-8cabc69539a3 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "BP Motors" | 2016-07-29 | 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 | ||
| 73089 | e2c65579-4adc-4b4e-9423-98ca5f95f5b5 | entityStatement | 2019-04-18 | false | registeredEntity | Linterno, SIA | 2016-07-29 | 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 | ||
| 73090 | bf433b41-fd20-44cd-a713-e22da413ddb1 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "AMEDEL" | 2016-07-29 | 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 | ||
| 73091 | 00a083a2-7f0b-4a1d-88d5-144926c40302 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "GARŠA" | 2016-07-29 | 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 | ||
| 73092 | ec387d65-e5ae-490f-a31e-daa899297909 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību LUMBA | 2016-07-29 | 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 | ||
| 73093 | 6311b6de-59bb-48c0-86e1-a328e1c9fa6a | entityStatement | 2019-07-14 | false | registeredEntity | Konsultāciju pakalpojumi, SIA | 2016-07-29 | 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 | ||
| 73094 | f1715983-1ac8-4b75-b00b-b75d569a919b | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "GRINIT" | 2016-07-29 | 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 | ||
| 73095 | d6a1f079-b106-407a-993e-7b36b3307c40 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Baltic Crab" | 2016-07-29 | 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 | ||
| 73096 | 3ce14ddb-9d57-4af9-ae06-ce3ddcbedf44 | entityStatement | 2018-05-03 | false | registeredEntity | SIA "BEST FOOD" | 2016-07-29 | 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 | ||
| 73097 | ff4724c0-2378-4278-8f06-0a0e20ce4f2b | entityStatement | 2018-12-19 | false | registeredEntity | SIA "People Work Coworking" | 2016-07-29 | 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 | ||
| 73098 | 7fa1096c-9319-4794-a831-9d85c764e10f | entityStatement | 2019-07-14 | false | registeredEntity | SIA "DionSportLab.eu" | 2016-07-29 | 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 | ||
| 73099 | 5640c986-1179-4a93-8dff-5447ad5da16c | entityStatement | 2020-08-31 | false | registeredEntity | SIA Frutta | 2016-07-29 | 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 | ||
| 73100 | 36ef3305-7553-48a8-a0cb-41cf1618eba9 | entityStatement | 2018-05-09 | false | registeredEntity | SIA "DORES ENGINEERING" | 2016-07-29 | 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 | ||
| 73101 | 8e39925e-f52e-4153-a078-5aa8706d97a3 | entityStatement | 2020-10-20 | false | registeredEntity | "Evgetel" SIA | 2016-07-29 | 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 | ||
| 73102 | d7deeca7-1692-4af6-8a96-020208425160 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Rituāls P" | 2016-07-29 | 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 | ||
| 73103 | e303cb53-b371-4c12-afbd-ff4accd2807e | entityStatement | 2019-07-14 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "House of Hair" | 2016-07-29 | 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 | ||
| 96696 | 2dbabb95-1aae-4751-a52a-0d409ad60f8b | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Liwadia" | 2016-07-29 | 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]) );