entity_statement
39 rows where "foundingdate" is on date 2014-01-17
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
101338 | ba393668-2b7e-4198-81e1-809cf2a4da33 | entityStatement | 2019-04-16 | false | registeredEntity | SIA "AG Racing" | 2014-01-17 | 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 | ||
110609 | 7c324ef4-af89-4607-ba9c-3b2661a9208e | entityStatement | 2018-07-31 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "4 Oaks" | 2014-01-17 | 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 | ||
27709 | 7dfa6394-96f7-4f20-bcf7-f59b41287be3 | entityStatement | 2019-07-27 | false | registeredEntity | Nodibinājums "LFF Kurzemes futbola centrs" | 2014-01-17 | 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 | ||
27710 | b456a8e6-8a4a-4345-bc2d-0d64c84cd319 | entityStatement | 2019-07-27 | false | registeredEntity | Nodibinājums "LFF Latgales futbola centrs" | 2014-01-17 | 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 | ||
27711 | 7ff1aef2-5502-4810-8e6f-b57fd8fe5482 | entityStatement | 2019-07-27 | false | registeredEntity | Nodibinājums "LFF Vidzemes futbola centrs" | 2014-01-17 | 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 | ||
27712 | 0faeafed-4ff3-4b25-9f49-a3c2f3d1f3bc | entityStatement | 2020-09-01 | false | registeredEntity | Nodibinājums "LFF Zemgales futbola centrs" | 2014-01-17 | 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 | ||
27713 | eeb97b5e-ea9d-4076-91ec-93fdfc289896 | entityStatement | 2020-09-01 | false | registeredEntity | Nodibinājums "LFF Ziemeļaustrumu futbola centrs" | 2014-01-17 | 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 | ||
58156 | cf982e3f-7ce5-4d6f-84b2-ecf52f5051f2 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "PROF-X" | 2014-01-17 | 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 | ||
58157 | 7a93bf10-9082-4826-a9a5-2d15942b0c19 | entityStatement | 2019-06-11 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "EMI Electronics" | 2014-01-17 | 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 | ||
58158 | 16c4b2e8-3a5c-407b-824c-6ae33b899f44 | entityStatement | 2019-07-13 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "J.Smiltiņas psihologa prakse" | 2014-01-17 | 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 | ||
58159 | 4331914f-73cf-45c2-8b54-cc7785a9efc2 | entityStatement | 2019-07-13 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "BALTIK STAR" | 2014-01-17 | 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 | ||
58160 | e0a4b10f-c6a8-4a8b-82ad-4253c3e04633 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "V-COM" | 2014-01-17 | 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 | ||
58161 | 9f2f0934-15da-4c4b-9b86-ef44b0c2ccfc | entityStatement | 2020-01-29 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību ARDP | 2014-01-17 | 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 | ||
58162 | 9171b5ab-fbe5-4c1c-b489-010eb18557c6 | entityStatement | 2019-07-13 | false | registeredEntity | SIA "DAMATI" | 2014-01-17 | 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 | ||
58163 | 0815a5f8-f511-4093-a612-48dc7c253666 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Pescador" | 2014-01-17 | 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 | ||
58164 | c7e29c85-0dfe-472b-b3ee-20b5975762c9 | entityStatement | 2018-11-07 | false | registeredEntity | SIA "MaxPlast" | 2014-01-17 | 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 | ||
58165 | cd9f6266-a21d-4c8c-9c10-693c02748a86 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "FINSEL" | 2014-01-17 | 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 | ||
58166 | 4f175ea1-35cc-4c78-8912-991705de755f | entityStatement | 2019-07-13 | false | registeredEntity | SIA "MARIVAN" | 2014-01-17 | 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 | ||
58167 | 0f3a93ce-6cae-4cd5-836f-7f37cb8283b6 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Erfolg TM" | 2014-01-17 | 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 | ||
58168 | 2ae55f0c-ac1d-49ee-9f41-9223c6bc3565 | entityStatement | 2019-07-13 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "BERKANATRANS" | 2014-01-17 | 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 | ||
58169 | c2e1850a-d34f-48b4-94b6-7c68df9e63cb | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "ARV SERVISS" | 2014-01-17 | 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 | ||
58170 | cc16132b-05a8-4e43-af7f-4488503fc362 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Gāzes apgāde" | 2014-01-17 | 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 | ||
58171 | 7f1811ff-800f-400a-81d2-46b5fae9e30c | entityStatement | 2019-07-13 | false | registeredEntity | SIA "Dripe" | 2014-01-17 | 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 | ||
58172 | 07378dc9-8845-432e-ae25-f62eb1413701 | entityStatement | 2020-08-10 | false | registeredEntity | SIA "ART8 Rent" | 2014-01-17 | 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 | ||
58173 | 9498d6de-ebc1-4eea-8d5c-570ccd8b49d3 | entityStatement | 2019-04-29 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Recycling LC" | 2014-01-17 | 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 | ||
58174 | 46b28a07-1133-4b47-9127-81c5b6f69c1b | entityStatement | 2019-07-13 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Fructus Temporum" | 2014-01-17 | 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 | ||
58175 | b0d3acbd-70e6-405e-890d-602b08c28352 | entityStatement | 2019-08-12 | false | registeredEntity | SIA "ALEKSANDRAS ĪPAŠUMI" | 2014-01-17 | 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 | ||
58176 | 01e885d7-e25b-467e-9f9e-2c5ce2fe3201 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "EFIT" | 2014-01-17 | 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 | ||
58177 | e73c49d7-cc48-4a83-ae52-9530cfbfe16f | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Localliving" | 2014-01-17 | 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 | ||
58178 | 8924c2d9-bea0-4c31-a976-7c6ca053893c | entityStatement | 2019-07-15 | false | registeredEntity | SIA "A22" | 2014-01-17 | 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 | ||
58179 | cf8903e2-0b64-4f90-bc89-6e41b6636a9e | entityStatement | 2018-02-07 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Donix" | 2014-01-17 | 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 | ||
58180 | 4d27ff62-85c1-4709-a453-f46f156aadae | entityStatement | 2018-02-23 | false | registeredEntity | SIA "Parks S3" | 2014-01-17 | 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 | ||
58181 | bfa51236-b338-4c61-a078-9f18efc11f48 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "K14" | 2014-01-17 | 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 | ||
58182 | 9555b225-ba1b-4837-a3fe-961965c482d2 | entityStatement | 2018-07-30 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "LBM GROUP" | 2014-01-17 | 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 | ||
58183 | 3d9eca1e-60b9-4fa1-934e-5abc6b706a44 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Mega Autoserviss" | 2014-01-17 | 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 | ||
58184 | 62fc7d83-e03f-4d12-8d06-9c1e3a7482e6 | entityStatement | 2019-06-25 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Hombres" | 2014-01-17 | 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 | ||
58185 | 2c6e441f-bbec-40f3-ac5e-09b2947bb8d8 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Oxior" | 2014-01-17 | 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 | ||
58186 | 69513fa1-df7c-4422-9c08-0b3010b851f8 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Abens Konsultants" | 2014-01-17 | 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 | ||
58187 | e371e6c3-991c-4f2b-b179-54b66afa59b2 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Untamed Fashion Assembly" | 2014-01-17 | 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]) );