entity_statement
12 rows where foundingdate = "1992-01-03" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 106462 | 4302a9c9-a8d8-4002-8265-5909dd0d7691 | entityStatement | 2019-07-25 | false | registeredEntity | Alūksnes rajona Ziemeru pagasta zemnieku saimniecība "MEŽĀRES" | 1992-01-03 | 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 | ||
| 106463 | 2e7a61b7-e2a1-470c-8eb1-63fc4e8c2113 | entityStatement | 2019-07-25 | false | registeredEntity | Alūksnes rajona Apes zemnieku saimniecība "LAPSUKALNI" | 1992-01-03 | 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 | ||
| 106464 | dbf760ab-1be3-4bba-8392-19b112b12e82 | entityStatement | 2019-07-25 | false | registeredEntity | Alūksnes rajona Ziemeru pagasta A.Sormules zemnieka saimniecība "BRIEDNIEKI" | 1992-01-03 | 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 | ||
| 106793 | ca6c080c-821a-4663-9bf3-49422a761396 | entityStatement | 2018-06-01 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "VALDIS" | 1992-01-03 | 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 | ||
| 112648 | c21c378e-d2b5-4a96-8f7e-934736615e7d | entityStatement | 2019-07-25 | false | registeredEntity | Valmieras rajona Dikļu pagasta zemnieku saimniecība "LAPURGAS" | 1992-01-03 | 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 | ||
| 112649 | bd7ee979-0701-4d4b-ac31-5dc566f99ba1 | entityStatement | 2019-07-25 | false | registeredEntity | Valmieras rajona zemnieku saimniecība "ZEMZARI" | 1992-01-03 | 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 | ||
| 30867 | cdd161dd-eee8-4943-a6db-2036967ce589 | entityStatement | 2019-07-11 | false | registeredEntity | "ALIT" SIA | 1992-01-03 | 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 | ||
| 30868 | 56a79afe-a704-425e-8253-4fe30c03f07c | entityStatement | 2019-07-11 | false | registeredEntity | SIA "SANTA K" | 1992-01-03 | 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 | ||
| 30869 | a63eafab-4696-493f-bb13-9b04fec2ead3 | entityStatement | 2019-07-11 | false | registeredEntity | SIA "LEKA" | 1992-01-03 | 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 | ||
| 92781 | d2fab81c-1a9b-46e1-a556-628ffad3aa6f | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "KĻAVAS V" | 1992-01-03 | 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 | ||
| 94002 | 2a74f813-62b1-4974-9cf2-08cf25c43e14 | entityStatement | 2019-07-14 | false | registeredEntity | "Elektrība" Daugavpils pilsētas A.Kamenecka Sabiedrība ar ierobežotu atbildību | 1992-01-03 | 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 | ||
| 98682 | 10724390-78dd-4c0f-b840-8598f9dc8a33 | entityStatement | 2018-03-07 | false | registeredEntity | SIA "OSTKOM" | 1992-01-03 | 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]) );