entity_statement
22 rows where "foundingdate" is on date 2013-04-04, incorporatedinjurisdiction_name = "Latvia" and publicationdetails_publicationdate = "2021-01-18"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27596 | ed48f8ee-0e9a-4447-a530-6d27834f2c52 | entityStatement | 2020-09-09 | false | registeredEntity | Atbalsta centrs bērniem un jauniešiem ar ierobežotām iespējām "SMAIDS" | 2013-04-04 | 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 | ||
| 53603 | fb8f7a15-e51c-47c9-aa99-0845e8a8ab96 | entityStatement | 2019-07-13 | false | registeredEntity | SIA "KARGAT" | 2013-04-04 | 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 | ||
| 53604 | 104d3202-7331-46d7-80f5-78eb36442ccb | entityStatement | 2019-07-13 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Lūšu Drava" | 2013-04-04 | 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 | ||
| 53605 | ac081bcc-306e-4d1a-b4ed-d8f586cda1b6 | entityStatement | 2019-07-13 | false | registeredEntity | Todanoliglass SIA | 2013-04-04 | 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 | ||
| 53606 | 3fed070b-702c-4cfc-95c2-655a8400b83a | entityStatement | 2019-07-13 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "MAKS2014" | 2013-04-04 | 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 | ||
| 53607 | 8f340948-f68c-4c1f-954c-47533953ffe2 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Glori N" | 2013-04-04 | 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 | ||
| 53608 | ce1b36e8-75fa-4b49-a9a7-9a4d843dff4d | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Candy Team" | 2013-04-04 | 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 | ||
| 53609 | ea57c7e7-f185-4902-b163-e9042e62c5f4 | entityStatement | 2019-07-15 | false | registeredEntity | "Montāžnieks J" SIA | 2013-04-04 | 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 | ||
| 53610 | a87e6f1e-ec58-4e8a-86e8-ffb28f99f10f | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Rietumu austrumu projekti" | 2013-04-04 | 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 | ||
| 53611 | 34a027b8-ed5f-4675-bd93-ee9cf0710c04 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Nvision" | 2013-04-04 | 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 | ||
| 53612 | f12083d7-0f90-471c-849c-6373596074c5 | entityStatement | 2018-09-11 | false | registeredEntity | SIA "Ross Restorāni" | 2013-04-04 | 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 | ||
| 53613 | 943046a1-d6e5-4276-83c8-6b2c81a2a67d | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Brigita 110" | 2013-04-04 | 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 | ||
| 53614 | 76dd8ae7-4397-4b9f-a743-91aa2a575544 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "NK būvpakalpojumi" | 2013-04-04 | 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 | ||
| 53615 | 65ac66e6-5642-4e91-822f-8f2edf67e688 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Martin Sons" | 2013-04-04 | 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 | ||
| 53616 | 3d5e8b26-a26b-48a7-b64c-651d37d304ef | entityStatement | 2019-12-16 | false | registeredEntity | SIA "LK holdings" | 2013-04-04 | 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 | ||
| 53617 | 88fdc368-1829-47ec-938b-551206364f38 | entityStatement | 2018-06-19 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "SV Tech" | 2013-04-04 | 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 | ||
| 53618 | 874ad058-8475-4209-8ec4-79819635c703 | entityStatement | 2019-07-13 | false | registeredEntity | SIA "SN ĀRSTE" | 2013-04-04 | 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 | ||
| 53619 | 779077d6-8675-4372-9ba6-3532f204463e | entityStatement | 2019-07-15 | false | registeredEntity | SIA "ILogistics Services" | 2013-04-04 | 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 | ||
| 53620 | f91d4af1-279b-457e-bc4e-8555ac06d6bf | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Brigita 112" | 2013-04-04 | 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 | ||
| 53621 | e4eccae9-7dc8-4408-8a9e-0c4519ad0543 | entityStatement | 2019-03-13 | false | registeredEntity | Agence Aramis SIA | 2013-04-04 | 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 | ||
| 53622 | 40983bb3-5a15-490f-a29e-a77edbe37492 | entityStatement | 2018-05-16 | false | registeredEntity | Akciju sabiedrība "Baltic Telekom" | 2013-04-04 | 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 | ||
| 53623 | 7f810e11-66b2-4679-9735-7db3dfa53b5a | entityStatement | 2019-08-27 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Kārsavas Nami" | 2013-04-04 | 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 |
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]) );