entity_statement
31 rows where "foundingdate" is on date 2018-05-31
This data as json, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
112008 | 435cfb71-52e1-4db8-af15-6c4bf701a27b | entityStatement | 2018-05-31 | false | registeredEntity | SIA People Design | 2018-05-31 | 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 | ||
112009 | 39678a99-1aa3-43d6-905a-9cedac2bb182 | entityStatement | 2018-05-31 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "auto sc64" | 2018-05-31 | 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 | ||
28657 | 169c2e0b-9780-4027-a580-26b4c0448513 | entityStatement | false | registeredEntity | "ZEM VĪTOLA" | 2018-05-31 | 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 | |||
28658 | 79792340-1573-4366-a520-137e1a75ae26 | entityStatement | 2018-05-31 | false | registeredEntity | Motociklistu biedrība "MAD FOX" | 2018-05-31 | 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 | ||
28659 | 96d66c10-85c1-4b19-942b-e239dbb4e468 | entityStatement | 2018-05-31 | false | registeredEntity | Biedrība "Slokas 103" | 2018-05-31 | 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 | ||
28660 | 7364a3ad-f2fe-42f2-a382-eb2fddf0aaa8 | entityStatement | false | registeredEntity | "Ola un Ota" | 2018-05-31 | 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 | |||
28661 | 54b96b80-f18c-4cf8-96d3-0a70fd2b7613 | entityStatement | 2018-05-31 | false | registeredEntity | Aktīvās atpūtas un sporta biedrība "MAD FOX" | 2018-05-31 | 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 | ||
83302 | 3674f6bd-5b40-4756-9932-a0d74b25df1b | entityStatement | 2018-05-31 | false | registeredEntity | SIA Leporem | 2018-05-31 | 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 | ||
83303 | 940b15ed-6d38-4fa5-a10f-744cd186ab7c | entityStatement | 2018-05-31 | false | registeredEntity | SIA "RS Architects" | 2018-05-31 | 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 | ||
83304 | c899bb0a-0896-439f-8696-e35f3955ef0f | entityStatement | 2018-05-31 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "ANKRO" | 2018-05-31 | 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 | ||
83305 | 04ecf23f-aa1e-45b7-9009-8ecbd632e185 | entityStatement | 2018-05-31 | false | registeredEntity | SIA "COMPASS" | 2018-05-31 | 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 | ||
83306 | 626cd2d5-7906-43db-a29d-bfa61a122d92 | entityStatement | 2018-10-26 | false | registeredEntity | SIA "OLGORS" | 2018-05-31 | 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 | ||
83307 | 07e5628f-8669-447f-ae23-7bf61d372adb | entityStatement | 2020-03-02 | false | registeredEntity | AS "Longo Latvia" | 2018-05-31 | 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 | ||
83308 | bdc26ca0-b835-41a6-9905-b0be3ad76414 | entityStatement | 2020-02-04 | false | registeredEntity | SIA SARANA | 2018-05-31 | 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 | ||
83309 | b8e4dbdb-2588-4056-9ca3-b0a94ffddb75 | entityStatement | 2019-09-30 | false | registeredEntity | SIA "Braavos" | 2018-05-31 | 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 | ||
83310 | 58303c09-176c-4ff3-9bcf-3c2fe10fd07f | entityStatement | 2018-05-31 | false | registeredEntity | SIA "BeRolls" | 2018-05-31 | 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 | ||
83311 | 2f7d3220-3fc0-4463-96db-34fa0c4efd3b | entityStatement | 2018-05-31 | false | registeredEntity | Regimark SIA | 2018-05-31 | 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 | ||
83312 | 6cfda7f6-f353-4fdd-ab1b-9c55f450acd3 | entityStatement | 2018-05-31 | false | registeredEntity | InLable SIA | 2018-05-31 | 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 | ||
83313 | fb9f9b55-76ba-43e2-9c7b-2267efad19b1 | entityStatement | 2018-05-31 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Mācību Alianse" | 2018-05-31 | 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 | ||
83314 | 7f6e6e62-99ed-4e69-928f-18ba2614b4d6 | entityStatement | 2018-05-31 | false | registeredEntity | SIA "TD" | 2018-05-31 | 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 | ||
83315 | d1c9450d-19f3-44f3-bf03-4065c224b062 | entityStatement | 2018-05-31 | false | registeredEntity | SIA AgroFor | 2018-05-31 | 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 | ||
83316 | ffaee051-ba5c-4a6a-839d-b9aebd51fe1b | entityStatement | 2018-05-31 | false | registeredEntity | SIA "GA SAI" | 2018-05-31 | 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 | ||
83317 | 151fcc06-aa23-4184-a0b6-2efd514aeb5a | entityStatement | 2020-05-12 | false | registeredEntity | SIA "ProFinServ" | 2018-05-31 | 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 | ||
83318 | 7eaedb04-7f07-4eb8-9866-5fba44ddd25f | entityStatement | 2018-05-31 | false | registeredEntity | SIA "Alternaterra" | 2018-05-31 | 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 | ||
83319 | b03503ed-ad54-413d-a5c2-a1bb13a865c8 | entityStatement | 2018-05-31 | false | registeredEntity | SIA "ARCADIA" | 2018-05-31 | 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 | ||
83320 | c686eb97-ab99-4b93-8965-cc6e96fea186 | entityStatement | 2018-05-31 | false | registeredEntity | SIA Baby & kids | 2018-05-31 | 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 | ||
83321 | 485aab5b-2332-41a1-ac7f-48418990324f | entityStatement | 2018-05-31 | false | registeredEntity | SIA "Fest Auto" | 2018-05-31 | 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 | ||
83322 | 64fba197-193f-4515-ada1-974b53194689 | entityStatement | 2018-05-31 | false | registeredEntity | LATIF SIA | 2018-05-31 | 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 | ||
83323 | e8f21a9f-3bc1-4de6-8bc5-48a22d3f4c9a | entityStatement | 2018-05-31 | false | registeredEntity | SIA "ARTEX AM" | 2018-05-31 | 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 | ||
83324 | 5f4fdff7-74e0-46f2-b66f-65b661461aef | entityStatement | 2018-05-31 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību GOTTER | 2018-05-31 | 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 | ||
92485 | 9de0a4c8-2486-4d9d-8cf5-98506f1975ae | entityStatement | 2018-05-31 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "KGRA" | 2018-05-31 | 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]) );