entity_statement
13 rows where "foundingdate" is on date 1991-11-25 and "publicationdetails_publicationdate" is on date 2021-01-19
This data as json, CSV (advanced)
Suggested facets: statementdate, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 107077 | 014d220a-8d29-4cdd-a7a3-c6b4b292ceed | entityStatement | 2019-07-25 | false | registeredEntity | Codes pagasta zemnieku saimniecība "Šalkas-1" | 1991-11-25 | 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 | ||
| 107078 | d692e5d5-92a1-488f-9b90-e2dbe9fce662 | entityStatement | 2019-07-25 | false | registeredEntity | Alda Kadiķa zemnieku saimniecība "JESI" | 1991-11-25 | 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 | ||
| 107079 | 72b12cfc-c23a-4b3c-9f92-c4d76a8f3a83 | entityStatement | 2019-07-25 | false | registeredEntity | Bauskas rajona Codes pagasta zemnieku saimniecība "MAZBRIEŽI" | 1991-11-25 | 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 | ||
| 107080 | eae8761c-d342-4d8b-95cd-e6f9583d8f12 | entityStatement | 2019-07-25 | false | registeredEntity | Silvijas Auziņas zemnieku saimniecība "ČUNKAS" | 1991-11-25 | 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 | ||
| 107081 | ca593685-ee66-4bf4-8b4e-57f94ba32606 | entityStatement | 2019-07-25 | false | registeredEntity | Bauskas rajona Skaistkalnes pagasta zemnieku saimniecība "KAUSIŅI" | 1991-11-25 | 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 | ||
| 107082 | b356918f-ca67-40f1-b329-f88b3612426f | entityStatement | 2019-07-25 | false | registeredEntity | Arta Kamola zemnieku saimniecība "ROBEŽNIEKI" | 1991-11-25 | 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 | ||
| 92764 | e6f3216e-f8cf-45f1-80df-1d2cba236cc4 | entityStatement | 2019-07-25 | false | registeredEntity | Dvietes pagasta zemnieku saimniecība "VĀLODZES" | 1991-11-25 | 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 | ||
| 92765 | bb54ce3c-3e80-460c-976c-9999e7df496f | entityStatement | 2019-07-25 | false | registeredEntity | Dvietes pagasta zemnieku saimniecība "ĀBELES" | 1991-11-25 | 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 | ||
| 92766 | 07ec8d92-0a8e-453b-8c12-2d6a6616f092 | entityStatement | 2019-07-25 | false | registeredEntity | Dvietes pagasta zemnieku saimniecība "KALNĀJI" | 1991-11-25 | 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 | ||
| 92767 | bd579600-64da-432d-b4aa-22d6d48d3dc2 | entityStatement | 2019-07-25 | false | registeredEntity | Dvietes pagasta zemnieku saimniecība "KUĢĪŠI" | 1991-11-25 | 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 | ||
| 92768 | 7f2ae14c-530b-4580-877f-0a7d747be57a | entityStatement | 2019-07-25 | false | registeredEntity | Dvietes pagasta zemnieku saimniecība "CĪRULĪŠI" | 1991-11-25 | 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 | ||
| 92769 | 0fc5a551-c464-4b94-910e-4a6801b59e00 | entityStatement | 2019-07-25 | false | registeredEntity | Dvietes pagasta zemnieku saimniecība "CIEMIŅI" | 1991-11-25 | 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 | ||
| 99216 | d781fdd1-a959-45b5-b10c-23bba507d291 | entityStatement | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "KURZEMES VĀRDS" | 1991-11-25 | 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]) );