entity_statement
24 rows where "foundingdate" is on date 2011-04-01, publicationdetails_publicationdate = "2021-01-18" and "publicationdetails_publicationdate" is on date 2021-01-18
This data as json, CSV (advanced)
Suggested facets: statementdate (date), 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 41960 | 13b0ba60-4089-4adb-8f05-40fa38bf8b38 | entityStatement | 2018-02-14 | false | registeredEntity | SIA "Nika V Consulting" | 2011-04-01 | 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 | ||
| 41961 | 26a67866-5f3c-403a-853d-7fa599655041 | entityStatement | 2019-12-18 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "e.Beauty" | 2011-04-01 | 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 | ||
| 41962 | 02b6c252-b394-4c17-9719-8a7c0f38722a | entityStatement | 2019-07-11 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "WILLOW GROUP" | 2011-04-01 | 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 | ||
| 41963 | 3ef44840-5acc-4dfe-ae4a-163fa4050bd7 | entityStatement | 2019-07-11 | false | registeredEntity | SIA "Edward" | 2011-04-01 | 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 | ||
| 41964 | f2696f25-d66e-4742-b2f4-7e566cc3cbf2 | entityStatement | 2019-07-11 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "GB PERFORMANCE" | 2011-04-01 | 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 | ||
| 41965 | fca31c87-a5b8-4e86-aee7-9982ba94998e | entityStatement | 2019-07-11 | false | registeredEntity | SIA "TSK drošība" | 2011-04-01 | 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 | ||
| 41966 | c269f463-aa90-48ff-b7ac-d79b34e15537 | entityStatement | 2019-04-05 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Daugavgrivas 57" | 2011-04-01 | 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 | ||
| 41967 | 2e1b1e42-0044-4a6c-bbb8-f50f85475d1a | entityStatement | 2019-07-11 | false | registeredEntity | SIA "Ulrikas dārzi" | 2011-04-01 | 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 | ||
| 41968 | 295d4b14-b462-4c70-8ba2-94f0e188959f | entityStatement | 2019-07-11 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "LIGIMANTS" | 2011-04-01 | 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 | ||
| 41969 | f50edab1-a6a4-463b-8858-378764227b9f | entityStatement | 2018-03-01 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Sale Serviss" | 2011-04-01 | 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 | ||
| 41970 | 3dc1edb7-e754-4991-ad83-e43d88394818 | entityStatement | 2019-05-02 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Krasta nami" | 2011-04-01 | 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 | ||
| 41971 | 1c2ad17f-44d4-4bc6-b53a-3b343d92e5e7 | entityStatement | 2019-07-11 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "ZIPZAP" | 2011-04-01 | 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 | ||
| 41972 | d7d321f4-69a6-482b-b5be-c0c12eb5a7f6 | entityStatement | 2019-07-11 | false | registeredEntity | SIA "NINOLI" | 2011-04-01 | 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 | ||
| 41973 | 8a3e72dc-0dc5-473a-b671-f464831c6e1b | entityStatement | 2019-04-04 | false | registeredEntity | Akciju sabiedrība "TEKERS HOLDINGS" | 2011-04-01 | 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 | ||
| 41974 | 5d5feedf-53bb-469c-a0c2-87bebcb04739 | entityStatement | 2019-07-11 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Altafina" | 2011-04-01 | 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 | ||
| 41975 | 8dab3539-ff54-41cf-a9b4-0b731b8b4da7 | entityStatement | 2020-03-10 | false | registeredEntity | SIA "BEYOND BRANDS" | 2011-04-01 | 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 | ||
| 41976 | 278716d0-4593-4be7-8a54-828afd819aa6 | entityStatement | 2019-07-11 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "CDC ARTWORKS" | 2011-04-01 | 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 | ||
| 41977 | ed74fc10-52d5-48d8-8b8d-ce9ad09a82b7 | entityStatement | 2019-07-11 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "LEADERS" | 2011-04-01 | 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 | ||
| 41978 | b84c30e9-6439-4573-a675-e1df02398445 | entityStatement | 2019-07-11 | false | registeredEntity | SIA "Būvelements" | 2011-04-01 | 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 | ||
| 41979 | f9e5baac-37f2-4a05-98ca-3e4d1adaad63 | entityStatement | 2019-07-11 | false | registeredEntity | SIA "Almundo" | 2011-04-01 | 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 | ||
| 41980 | 20ee0f08-3e91-4880-96f7-c0c325cfd4e0 | entityStatement | 2020-07-22 | false | registeredEntity | SIA "Birojs PB17" | 2011-04-01 | 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 | ||
| 41981 | a84dc19e-7069-4715-b9f9-63c180062be6 | entityStatement | 2019-07-01 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "LatAcrylam" | 2011-04-01 | 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 | ||
| 41982 | f61139fe-a933-4378-a9ba-21ae91f2befc | entityStatement | 2019-07-11 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "ATK 1" | 2011-04-01 | 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 | ||
| 41983 | 7032487a-04ea-4b06-9269-2882e71b0abc | entityStatement | 2018-09-06 | false | registeredEntity | SIA "TASSMA" | 2011-04-01 | 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]) );