entity_statement
27 rows where "foundingdate" is on date 2012-12-20 and iscomponent = "false"
This data as json, CSV (advanced)
Suggested facets: statementdate, publicationdetails_publicationdate, statementdate (date), 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 105365 | 06124dba-0ef4-436c-bccc-208031d242d2 | entityStatement | 2019-07-16 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību SALRIS | 2012-12-20 | 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 | ||
| 110258 | 4a415d9d-cb31-4cd2-a23b-fc7a9d3d9282 | entityStatement | 2019-07-16 | false | registeredEntity | SIA "Vivejas Epiņas ģimenes ārsta prakse" | 2012-12-20 | 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 | ||
| 110259 | 737430f8-ffef-4fe5-b4f3-f111518619d7 | entityStatement | 2019-07-16 | false | registeredEntity | SIA "A. Veržbicka ārsta prakse" | 2012-12-20 | 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 | ||
| 110260 | a0a7e9ef-9b44-47cb-901e-266ce751a1d4 | entityStatement | 2019-07-16 | false | registeredEntity | SIA "Ligitas Igaunes ārsta prakse neiroloģijā" | 2012-12-20 | 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 | ||
| 110261 | 3fb6a2f3-f58a-4c18-acfe-36f3cdbd4863 | entityStatement | 2019-07-16 | false | registeredEntity | SIA "Elektro AJ" | 2012-12-20 | 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 | ||
| 3500 | 0633b91a-8fed-419e-baeb-1ab3f912aa0a | entityStatement | 2019-07-24 | false | registeredEntity | Rīgas pilsētas V.A.Bundes namu pārvaldīšana | 2012-12-20 | 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 | ||
| 51865 | 198831bc-2bce-4db1-9944-3986ed0e3ed6 | entityStatement | 2019-07-13 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "IMNI" | 2012-12-20 | 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 | ||
| 51866 | dafb502a-73bd-46b8-a07b-b1ef1252ccae | entityStatement | 2019-07-15 | false | registeredEntity | SIA "VIATORE" | 2012-12-20 | 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 | ||
| 51867 | dcddde7b-72b7-4181-8f08-e07caf817e7c | entityStatement | 2018-03-02 | false | registeredEntity | SIA "Audit Service LV" | 2012-12-20 | 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 | ||
| 51868 | 61cda8f7-dfe9-4f16-8e81-a19caea4ccbb | entityStatement | 2021-01-06 | false | registeredEntity | SIA "Proinstro" | 2012-12-20 | 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 | ||
| 51869 | a07ede1c-c0d6-475e-9ea8-d519b65154d8 | entityStatement | 2019-07-15 | false | registeredEntity | SABIEDRĪBA AR IEROBEŽOTU ATBILDĪBU "AMBERSS" | 2012-12-20 | 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 | ||
| 51870 | 37d69a0b-1692-4a03-89f9-ecbd57f7a38d | entityStatement | 2019-07-13 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Stavs" | 2012-12-20 | 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 | ||
| 51871 | c359f6ee-cb00-42f7-9f7d-434cb4978114 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Binoms" | 2012-12-20 | 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 | ||
| 51872 | 3521fa85-d4bb-4530-8256-8cc65a8c0148 | entityStatement | 2019-07-13 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "STAMRAIS" | 2012-12-20 | 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 | ||
| 51873 | 3f9a059c-144f-4e52-917d-4d9061b28aeb | entityStatement | 2018-01-12 | false | registeredEntity | PVN Konsultācijas SIA | 2012-12-20 | 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 | ||
| 51874 | f28152c2-83d7-4fe7-9e60-107fc8ad08fd | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Antikvariat" | 2012-12-20 | 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 | ||
| 51875 | bf0466be-beed-4f79-b264-e8e66511a867 | entityStatement | 2019-07-13 | false | registeredEntity | SIA "AMIDA TOUR" | 2012-12-20 | 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 | ||
| 51876 | 5207cae0-37db-4e86-aca2-ab8fe34d3382 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "SJR" | 2012-12-20 | 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 | ||
| 51877 | f5228d8e-cbf1-445e-bb74-1cb2a6e5bfb6 | entityStatement | 2018-06-26 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Augstās Tehnoloģijas" | 2012-12-20 | 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 | ||
| 51878 | 22c9b6e8-d4cf-4272-a4a0-ea7ec5ba8cfb | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Save Green Planet" | 2012-12-20 | 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 | ||
| 51879 | ee270a37-ee3e-43a8-b749-7bd6a71614bc | entityStatement | 2020-01-03 | false | registeredEntity | ILANGA SIA | 2012-12-20 | 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 | ||
| 51880 | 04ccae72-3a7d-4511-aefa-5b1237a0b359 | entityStatement | 2018-05-09 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Tirgotājs LV" | 2012-12-20 | 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 | ||
| 51881 | 55b18d1f-9387-4514-8763-f5ba80c106ec | entityStatement | 2019-07-15 | false | registeredEntity | SIA "ELRATI" | 2012-12-20 | 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 | ||
| 91262 | 77790439-062f-4ace-be45-40c7e5e30769 | entityStatement | 2019-07-14 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Modra Autoskola" | 2012-12-20 | 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 | ||
| 91263 | 9574e3f1-ea64-4e37-b004-a6bfe4fbc672 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "LD 1" | 2012-12-20 | 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 | ||
| 91264 | cb0572d4-7282-4ea0-ad36-ef2d6b99791e | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "EGO-L" | 2012-12-20 | 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 | ||
| 95926 | 184c6aaf-5242-4506-90a4-fd875b5c7627 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Dzinējspēks" | 2012-12-20 | 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]) );