entity_statement
35 rows where "foundingdate" is on date 2012-04-28 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 103958 | 2d2ec0b0-bba3-4e63-b05e-4d5f3ed71488 | entityStatement | 2019-07-25 | false | registeredEntity | Dricānu pagasta zemnieka saimniecība "Višņakovi" | 2012-04-28 | 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 | ||
| 105247 | 3b31f958-0fa5-43a7-9d05-673c01344471 | entityStatement | 2019-07-16 | false | registeredEntity | Sabiedrība ar Ierobežotu Atbildību "KOBATA" | 2012-04-28 | 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 | ||
| 110072 | 0266d8b6-8183-4058-ab62-0da421c5f011 | entityStatement | 2019-07-16 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "DH BALTICS" | 2012-04-28 | 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 | ||
| 48187 | 2c4a9a24-972a-4d05-a396-5ae88fae328f | entityStatement | 2019-05-07 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Orange Deal" | 2012-04-28 | 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 | ||
| 48188 | ae389ff2-f9c6-4b70-a0ec-69af48a37e68 | entityStatement | 2019-07-12 | false | registeredEntity | SIA "Kozimoart" | 2012-04-28 | 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 | ||
| 48189 | 1ce15f70-b236-4c2d-bcfa-45ff6b849165 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Poster" | 2012-04-28 | 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 | ||
| 48190 | 10b235d9-79c3-4a6d-babb-92cb93b0c7f3 | entityStatement | 2019-07-12 | false | registeredEntity | SIA "Mark Trading" | 2012-04-28 | 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 | ||
| 48191 | 085f4afb-a422-4134-ab6c-c19c635e8ad0 | entityStatement | 2018-01-30 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "WARM MONTĀŽA" | 2012-04-28 | 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 | ||
| 48192 | 30142bb3-a8e0-4aa5-8f19-165ab4836eac | entityStatement | 2019-07-12 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "ADH noma" | 2012-04-28 | 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 | ||
| 48193 | d781efce-3c83-475c-a91e-e38f2520fb31 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "GEPA" | 2012-04-28 | 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 | ||
| 48194 | b14ad27a-ba00-4449-95da-02c719109721 | entityStatement | 2020-09-18 | false | registeredEntity | SIA Jūrmala Properties | 2012-04-28 | 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 | ||
| 48195 | a9f7e1a4-19a2-45f1-b39b-70ece2d89a55 | entityStatement | 2020-12-11 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "AEG Būve" | 2012-04-28 | 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 | ||
| 48196 | 6929c471-4d64-4053-a11d-51e3c59684af | entityStatement | 2017-12-06 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "EINOS" | 2012-04-28 | 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 | ||
| 48197 | 44ea0978-dec1-440d-81e4-16e742ca56d8 | entityStatement | 2018-07-26 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "VĀL B72" | 2012-04-28 | 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 | ||
| 48198 | 5c413be9-2879-4908-89ab-e9dd4c5f5d0c | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Kleo K" | 2012-04-28 | 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 | ||
| 48199 | fb528ca9-11c2-4f77-adc7-fb0547f76f40 | entityStatement | 2019-07-12 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Āfrikas idejas" | 2012-04-28 | 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 | ||
| 48200 | b57c0d8e-d6ae-4da0-86c0-a4b615849d1b | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "AT Nami" | 2012-04-28 | 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 | ||
| 48201 | c6c2f0f9-457e-4729-bdc8-118cc0257537 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Max box" | 2012-04-28 | 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 | ||
| 48202 | b5ba5a30-690e-4664-9127-25a2fc579855 | entityStatement | 2019-07-12 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Sanity Limit" | 2012-04-28 | 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 | ||
| 48203 | 8bf4df71-5845-4337-a55e-333825caafb6 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "mCloud" | 2012-04-28 | 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 | ||
| 48204 | bfd07188-92de-45d0-8cce-e2332b931a8c | entityStatement | 2019-07-15 | false | registeredEntity | SIA "ANGELICA" | 2012-04-28 | 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 | ||
| 48205 | 4e72965e-4da8-42d5-8b85-f362d5073a94 | entityStatement | 2020-03-30 | false | registeredEntity | SIA "Roug Inc." | 2012-04-28 | 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 | ||
| 48206 | d644f215-69f6-41db-9939-90f9ee331fb4 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Pultechnics" | 2012-04-28 | 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 | ||
| 48207 | b38c67c3-7104-4008-b0ab-2315c22fce13 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Tours shop" | 2012-04-28 | 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 | ||
| 48208 | ac3fd73a-a5dd-42a4-b6ed-87aaa5dd10d4 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "BIGSA" | 2012-04-28 | 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 | ||
| 48209 | bacb088b-df3c-4596-b8a1-254a4a27516b | entityStatement | 2019-07-15 | false | registeredEntity | SIA Amandiņa | 2012-04-28 | 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 | ||
| 48210 | e2121109-e8e0-42a3-9c2a-efc5fe426be3 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "AD meritum" | 2012-04-28 | 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 | ||
| 48211 | 3f3dcdc1-dd1d-40ac-bed9-53342bbc4cc9 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Global Nordic Metals" | 2012-04-28 | 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 | ||
| 48212 | 5d3eef13-3794-49ff-b784-9fda9c186df2 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Para bellum" | 2012-04-28 | 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 | ||
| 48213 | b7e18c06-b01e-4b67-800c-8919de5b484e | entityStatement | 2019-07-12 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "SP Auto" | 2012-04-28 | 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 | ||
| 48214 | 986a9a3d-ec57-4a12-98ec-ede85741c0e6 | entityStatement | 2019-07-12 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "UMONTAGE" | 2012-04-28 | 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 | ||
| 48215 | 2edea2d1-ec89-4094-94f6-d3eee4762ca8 | entityStatement | 2019-07-12 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Green Projects" | 2012-04-28 | 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 | ||
| 48216 | e3095eeb-8da1-4b7c-92e1-6b989948856a | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "BALTIC DIZAINS" | 2012-04-28 | 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 | ||
| 48217 | 7492d8a4-db29-478f-82b0-67f597f15251 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "EuroAfro Group" | 2012-04-28 | 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 | ||
| 782 | 117e2f39-d297-429d-b9a2-f01055bcf464 | entityStatement | 2019-07-24 | false | registeredEntity | Jērcēnu pagasta ZS Saulespuķes | 2012-04-28 | 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]) );