entity_statement
32 rows where "foundingdate" is on date 2018-05-08
This data as json, CSV (advanced)
Suggested facets: statementdate, publicationdetails_publicationdate, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 106143 | f6b9a217-7cbc-4a45-9521-a78889ea7e0e | entityStatement | 2018-05-08 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "DK izdevējs" | 2018-05-08 | 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 | ||
| 106144 | 8b153053-55ea-4fa8-8590-90e36f449374 | entityStatement | 2018-05-08 | false | registeredEntity | SIA Siemtecha | 2018-05-08 | 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 | ||
| 111975 | 5118754a-5e8b-49af-a936-daf6ed9709ec | entityStatement | 2020-08-28 | false | registeredEntity | SIA "JK Market" | 2018-05-08 | 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 | ||
| 28586 | 09d233e3-3c68-4fd2-b6a9-7618c5e2ecee | entityStatement | false | registeredEntity | Biedrība "LAUKĀRES" | 2018-05-08 | 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 | |||
| 82875 | 2f201f3c-e45a-40c5-ab41-d031c40e8e07 | entityStatement | 2019-10-01 | false | registeredEntity | SIA "Baltā baznīca" | 2018-05-08 | 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 | ||
| 82876 | 2a47548f-7aa6-4bb9-b1e4-8f4f198493d9 | entityStatement | 2019-08-23 | false | registeredEntity | SIA Dark Knight | 2018-05-08 | 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 | ||
| 82877 | 0ee6ee70-d7e6-40d7-8675-98573b5971f5 | entityStatement | 2019-05-22 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "IGILONS" | 2018-05-08 | 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 | ||
| 82878 | e58f631d-53c8-40ec-a481-ee6df4f5b813 | entityStatement | 2018-05-08 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "KamTra" | 2018-05-08 | 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 | ||
| 82879 | 87369acd-337f-47a1-bb89-716f5feea994 | entityStatement | 2018-05-08 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Trīs Mārči" | 2018-05-08 | 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 | ||
| 82880 | 72edae20-b291-4208-a6d8-f95307a8d05f | entityStatement | 2018-05-08 | false | registeredEntity | Spilek SIA | 2018-05-08 | 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 | ||
| 82881 | d29e3202-56a3-4b41-9c49-40616ef0eae3 | entityStatement | 2019-02-01 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "ORIS" | 2018-05-08 | 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 | ||
| 82882 | 90475321-5a77-40a6-9e59-f559e6dce3e7 | entityStatement | 2018-05-08 | false | registeredEntity | SIA PaulaGarden | 2018-05-08 | 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 | ||
| 82883 | c9df6ca7-65cb-4111-a4ff-a7467c7f7f0c | entityStatement | 2018-05-08 | false | registeredEntity | SIA Space | 2018-05-08 | 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 | ||
| 82884 | eb87d989-4ab3-45d0-b345-599797c69bd6 | entityStatement | 2018-05-08 | false | registeredEntity | "Purčika kebabs" SIA | 2018-05-08 | 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 | ||
| 82885 | 7a23e4b1-16f1-4eed-96ac-d99203df32ad | entityStatement | 2018-05-08 | false | registeredEntity | SIA "ALBO ALLIANZ" | 2018-05-08 | 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 | ||
| 82886 | d0549e6f-6f40-479d-a66c-5d19080b0b83 | entityStatement | 2018-05-08 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "E&N" | 2018-05-08 | 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 | ||
| 82887 | 2b9e4fb3-4768-4e87-9320-be43348e15ea | entityStatement | 2018-05-08 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Strauja dzirksts" | 2018-05-08 | 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 | ||
| 82888 | c5c99f3b-ccfc-4275-bd56-3b64f0d1779f | entityStatement | 2018-05-08 | false | registeredEntity | SIA AGV Tectum | 2018-05-08 | 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 | ||
| 82889 | c6d153a4-e7f5-48d1-9073-becb46698df0 | entityStatement | 2018-05-08 | false | registeredEntity | SIA "MVLBŪVE" | 2018-05-08 | 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 | ||
| 82890 | 987e8d80-da19-4d13-a247-0c36a796c270 | entityStatement | 2018-05-08 | false | registeredEntity | SIA "Fruits & more" | 2018-05-08 | 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 | ||
| 82891 | 7f5f62d3-b04d-4302-913a-a71cb74f3067 | entityStatement | 2018-05-08 | false | registeredEntity | HDI Serviss SIA | 2018-05-08 | 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 | ||
| 82892 | 52552702-b977-4284-8136-57fd4da13918 | entityStatement | 2018-05-08 | false | registeredEntity | SIA Alpsline | 2018-05-08 | 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 | ||
| 82893 | c4732199-1d65-4f49-af79-3bae73e808fc | entityStatement | 2020-06-19 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Driver33" | 2018-05-08 | 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 | ||
| 82894 | 32002215-0801-409a-99c2-1577f18613e0 | entityStatement | 2018-05-08 | false | registeredEntity | SIA "4safety" | 2018-05-08 | 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 | ||
| 82895 | e695b67d-ceb2-483e-84ea-fd7adf34d379 | entityStatement | 2018-05-08 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Ķekavas Dolomīts" | 2018-05-08 | 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 | ||
| 82896 | a6b66e17-970f-4c36-af9c-64d138ebe883 | entityStatement | 2018-05-08 | false | registeredEntity | SIA "PERFECT LEVEL" | 2018-05-08 | 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 | ||
| 82897 | 71a4d0b2-3254-45d3-b4f9-e38df16f1938 | entityStatement | 2019-03-04 | false | registeredEntity | SIA "Biķernieku13" | 2018-05-08 | 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 | ||
| 82898 | d20a910a-7a13-46c7-841d-78cd07506e28 | entityStatement | 2019-01-30 | false | registeredEntity | SIA "Candera 7A" | 2018-05-08 | 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 | ||
| 82899 | 03535d52-624a-42fe-a68e-5cbccabc22b1 | entityStatement | 2018-05-08 | false | registeredEntity | AS "JK Capital Holding" | 2018-05-08 | 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 | ||
| 82900 | 0a87c805-6b46-43a5-99df-a73fde540eaa | entityStatement | 2020-10-20 | false | registeredEntity | SIA "RĪGAS LOGI" | 2018-05-08 | 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 | ||
| 92468 | 0e1ac753-f37f-4432-a3a6-77c224a51d97 | entityStatement | 2018-05-08 | false | registeredEntity | SIA "KM Arum" | 2018-05-08 | 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 | ||
| 97156 | fa7747c5-c886-4acc-8f0d-d92447ae46b5 | entityStatement | 2018-05-08 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "AULA EVENTS" | 2018-05-08 | 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]) );