entity_statement
28 rows where foundingdate = "2012-09-17", "foundingdate" is on date 2012-09-17 and iscomponent = "false"
This data as json, CSV (advanced)
Suggested facets: 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 50349 | 9fdd6452-746b-4224-85d2-ee2b0a3728f2 | entityStatement | 2019-07-13 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Kids Medical" | 2012-09-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 | ||
| 50350 | cc530397-ac87-49fe-8c7f-58da3902950d | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "THINDIVIDUAL" | 2012-09-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 | ||
| 50351 | 2852d33b-a716-4567-bd84-ae746339f6dc | entityStatement | 2019-07-13 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Cado" | 2012-09-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 | ||
| 50352 | e28a2783-9d90-46f7-8607-37dead5bb530 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "TN Projekts" | 2012-09-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 | ||
| 50353 | ad43588d-10d5-4713-8a2f-312f388d758c | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Elster" | 2012-09-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 | ||
| 50354 | 1f38f633-81ee-451c-a691-341048f0686d | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "AQUAVET" | 2012-09-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 | ||
| 50355 | 976d372d-2f01-4438-ba49-c08f509f7ae1 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "IMARKETINGS" | 2012-09-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 | ||
| 50356 | 70c3b34c-4e7f-473f-bc56-02a9b1cbf021 | entityStatement | 2019-07-13 | false | registeredEntity | SIA "REM22" | 2012-09-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 | ||
| 50357 | 87748f90-e5f7-4365-a0a5-a699cf045940 | entityStatement | 2018-03-07 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Ecopay" | 2012-09-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 | ||
| 50358 | 0da1510f-04a2-43d4-8d9d-39d2676c0059 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Tīruma" | 2012-09-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 | ||
| 50359 | 5a9b0840-d993-4fad-9bca-4b1ec504b4eb | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Nacional Travel" | 2012-09-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 | ||
| 50360 | d07e4dde-8a1a-44b6-a6ef-aed1e46f847d | entityStatement | 2020-03-10 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Kraft Serviss" | 2012-09-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 | ||
| 50361 | 2887a37a-d3e8-4b89-b9c4-f07868add74b | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "ED ideja" | 2012-09-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 | ||
| 50362 | 68ef4329-3457-41c9-85e8-d190582b48a7 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "BISTEKLS" | 2012-09-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 | ||
| 50363 | 2bab0796-75aa-4d35-9c69-fcd753ac8f36 | entityStatement | 2019-06-28 | false | registeredEntity | SIA "UP Consulting" | 2012-09-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 | ||
| 50364 | bda8e435-dc0a-493f-9a0f-6e81bd341d87 | entityStatement | 2019-07-13 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "A.S. Trans Serviss" | 2012-09-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 | ||
| 50365 | 2369c37d-fcb9-484f-aa5b-025938baf0e6 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "PMO Solutions" | 2012-09-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 | ||
| 50366 | aa2c0518-2c69-4488-9a14-31dc67f60885 | entityStatement | 2019-07-13 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "ALCS" | 2012-09-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 | ||
| 50367 | 08117743-e9a7-4c1b-b635-8535fa3eaf45 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "LITUR" | 2012-09-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 | ||
| 50368 | d5b6097b-7dc7-4bfa-a0d8-46033adb965d | entityStatement | 2018-05-07 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Baltic Titan Technologies" | 2012-09-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 | ||
| 50369 | 09774ace-d657-4562-af87-cd5bcf3a4bde | entityStatement | 2019-07-13 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "PATA TIMBER" | 2012-09-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 | ||
| 50370 | 1021a7f3-4a13-40a1-adf7-f49cd4ebccbf | entityStatement | 2019-07-15 | false | registeredEntity | SIA "AG Būvnieks" | 2012-09-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 | ||
| 50371 | 65e77593-f247-4370-bec2-7743b2a654c7 | entityStatement | 2020-11-12 | false | registeredEntity | SIA "Adeļ N" | 2012-09-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 | ||
| 50372 | d44eff9e-d5a6-4eba-987d-5b7bea29c716 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Terminal Services" | 2012-09-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 | ||
| 50373 | ca80cba8-36c6-46d2-83e5-d452e2b87ddc | entityStatement | 2020-03-24 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "GINOO BLOCK" | 2012-09-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 | ||
| 50374 | 574671c8-4055-4292-92c6-a94833bf9887 | entityStatement | 2018-02-23 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "ZB69" | 2012-09-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 | ||
| 50375 | be5b6254-640c-4174-bdc5-8a4931a9ede4 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "TRID" | 2012-09-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 | ||
| 50376 | 8d0b071f-441f-411b-bc0a-5f2849d51e6c | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Kreavita" | 2012-09-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]) );