entity_statement
8 rows where foundingdate = "1992-09-08", iscomponent = "false" and publicationdetails_publicationdate = "2021-01-19"
This data as json, CSV (advanced)
Suggested facets: statementdate, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 103413 | ce73be01-8f1c-4ad4-aa0c-652af33e1dcc | entityStatement | 2019-07-25 | false | registeredEntity | Zemnieku saimniecība "ROBEŽNIEKI" | 1992-09-08 | 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 | ||
| 92862 | 3597515d-ddf1-4a63-8c73-95359bdbf705 | entityStatement | 2020-07-27 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "SUDRABIŅI KR" | 1992-09-08 | 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 | ||
| 97535 | 2f09f1a9-17c3-41dd-bff9-4703673067e1 | entityStatement | 2019-12-17 | false | registeredEntity | Grosa Jelgavas rajona zemnieku saimniecība "BĒTRAS" | 1992-09-08 | 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 | ||
| 97536 | 13f559f3-2d2c-4227-90d8-dc1101d8294a | entityStatement | 2019-07-25 | false | registeredEntity | Sutra Jelgavas rajona zemnieku saimniecība "LĪČI" | 1992-09-08 | 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 | ||
| 97537 | f67ef046-b5e4-42cd-a620-a69cf1652b86 | entityStatement | 2019-07-25 | false | registeredEntity | Vilces pagasta zemnieku saimniecība "Svētes" | 1992-09-08 | 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 | ||
| 98183 | 4ea2d7d4-b871-4d71-b57c-35c89d8097c9 | entityStatement | 2019-07-25 | false | registeredEntity | Liepājas rajona Vaiņodes pagasta zemnieku saimniecība "ZVAIGZNES-I" | 1992-09-08 | 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 | ||
| 98184 | 0125c45c-397f-41c6-8598-569cc5c0f1c2 | entityStatement | 2019-07-25 | false | registeredEntity | Liepājas rajona Bunkas pagasta zemnieku saimniecība "SIKSNAS-I" | 1992-09-08 | 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 | ||
| 98185 | 12f36650-a30c-4647-8bf4-5ddc265b902a | entityStatement | 2019-07-25 | false | registeredEntity | Liepājas rajona Vaiņodes pagasta zemnieku saimniecība "UPENIEKI-3" | 1992-09-08 | 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]) );