entity_statement
22 rows where "foundingdate" is on date 2000-04-13 and iscomponent = "false"
This data as json, CSV (advanced)
Suggested facets: statementdate, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10745 | 5015b272-25f6-4f0a-a634-0195f1be5040 | entityStatement | 2019-07-10 | false | registeredEntity | SIA "RIOTEKS" | 2000-04-13 | 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 | ||
| 10746 | 9b8308bd-adaa-4129-805a-4f6e347e707a | entityStatement | 2019-07-10 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Juridiskais birojs "RESPONDERE"" | 2000-04-13 | 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 | ||
| 10747 | d16a8f47-ea95-41e3-ba19-a85f832a486c | entityStatement | 2019-07-10 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "BRUNO D" | 2000-04-13 | 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 | ||
| 10748 | d43427b7-c4b9-4b6f-a23a-1cce834b2631 | entityStatement | 2019-07-10 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "TERMOTEKS" | 2000-04-13 | 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 | ||
| 10749 | 7172eb4d-f7ee-48ef-9282-a410e4509400 | entityStatement | 2019-07-10 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "S GRAUDS" | 2000-04-13 | 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 | ||
| 10750 | 266c3e36-d8ad-4f8a-9afe-97b155bb59a0 | entityStatement | 2019-07-10 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "BELMAST" | 2000-04-13 | 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 | ||
| 10751 | 87d85420-ddc6-4cc9-8d13-ef31a905ce9d | entityStatement | 2019-10-07 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "GRAFA" | 2000-04-13 | 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 | ||
| 10752 | d7711849-09e6-4e15-8d6c-31ef541e65ef | entityStatement | 2019-07-10 | false | registeredEntity | SIA "MELSS" | 2000-04-13 | 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 | ||
| 10753 | d5df1de9-a30f-4e0f-8ce6-3f0362630124 | entityStatement | 2019-07-27 | false | registeredEntity | "NODIBINĀJUMS BRIEŽU DĀRZS KAKTI" | 2000-04-13 | 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 | ||
| 10754 | 56ec0cc3-3aba-4d79-8a65-d3f43fae75f7 | entityStatement | 2019-07-10 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Grotto" | 2000-04-13 | 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 | ||
| 113783 | e9695e38-e0ec-4986-bdad-a0f3118fb7b1 | entityStatement | 2019-07-26 | false | registeredEntity | Nītaures pagasta Jāņa Apsīša zemnieka saimniecība "KRONĪŠI" | 2000-04-13 | 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 | ||
| 26472 | eca3091c-bc99-4000-af33-0655b5d0603e | entityStatement | 2019-07-27 | false | registeredEntity | Malienas skolas fonds | 2000-04-13 | 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 | ||
| 26473 | ea54e00d-ba36-4520-bd5b-16920b448ff3 | entityStatement | 2019-07-27 | false | registeredEntity | "LŪCIJAS GARŪTAS FONDS" | 2000-04-13 | 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 | ||
| 3345 | 3bb27c0c-f7e0-4cf6-84a8-b0623febe132 | entityStatement | 2019-07-24 | false | registeredEntity | Rīgas pils. A.Bērziņa instrumentu ražošanas individuālais uzņēmums "ASS M A V" | 2000-04-13 | 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 | ||
| 93276 | 509b58b6-e490-4528-b024-57a9c9c87e2c | entityStatement | 2019-07-25 | false | registeredEntity | Konstantinovas pagasta P.Kavuna zemnieku saimniecība "EŽI" | 2000-04-13 | 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 | ||
| 93277 | 3193f767-c20a-490d-833f-87f8c1cd9bb5 | entityStatement | 2019-07-25 | false | registeredEntity | Medumu pagasta I.Belovas zemnieku saimniecība "SĒRMUĻI" | 2000-04-13 | 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 | ||
| 93278 | 367b6a40-d5ec-434c-96d0-375b28e80e6d | entityStatement | 2019-07-25 | false | registeredEntity | Sutru pagasta I.Vasiļjeva zemnieku saimniecība "TILTAVĪTA" | 2000-04-13 | 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 | ||
| 94296 | 98ead6a8-bd34-42e8-91ae-42b17f573fa3 | entityStatement | 2020-12-22 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "ŠARLOTE K" | 2000-04-13 | 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 | ||
| 94297 | 1617fd42-d300-41b9-b469-659404f89953 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "LAIMDOTA D" | 2000-04-13 | 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 | ||
| 94298 | f653e60f-f36e-4841-a34e-18040f92a7a3 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "SHERMAN LINE" | 2000-04-13 | 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 | ||
| 99162 | c0dae74b-e8a2-474b-a032-d3c725ee14b0 | entityStatement | 2019-07-25 | false | registeredEntity | Liepājas pilsētas Semenovičas daudznozaru individuālais uzņēmums "VENĒRA S.I." | 2000-04-13 | 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 | ||
| 99498 | 69d974c1-a2a2-4fe3-a601-4e12db995a53 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "ELEKTRO L.R." | 2000-04-13 | 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]) );