entity_statement
9 rows where "foundingdate" is on date 1992-09-24 and iscomponent = "false"
This data as json, CSV (advanced)
Suggested facets: statementdate
| _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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 104278 | 3541e4f6-1040-4ce0-b9de-068f3152e52d | entityStatement | 2019-07-16 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "RĒZEKNES MELIORĀTORS" | 1992-09-24 | 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 | ||
| 104279 | fb436aa1-53e7-4584-aa80-3c2f418c6de4 | entityStatement | false | registeredEntity | Akciju sabiedrība "LATGALES ENERĢĒTIKA" | 1992-09-24 | 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 | |||
| 106919 | 0f4ce44f-598c-48b6-8bde-ae8177045e01 | entityStatement | 2019-07-25 | false | registeredEntity | Medņevas pagasta zemnieku saimniecība "ZVEJNIEKI" | 1992-09-24 | 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 | ||
| 106920 | 4326f57e-ef82-4b23-b535-e0d8c84cb898 | entityStatement | 2019-07-25 | false | registeredEntity | Kubuļu pagasta zemnieku saimniecība "LAZDAS" | 1992-09-24 | 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 | ||
| 107303 | d0d48dcd-6ad4-43a0-a8b4-1baf60755d38 | entityStatement | 2019-07-25 | false | registeredEntity | Pluča Gunta Iecavas pagasta zemnieku saimniecība "PLUČI" | 1992-09-24 | 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 | ||
| 29587 | 411b1fb1-5968-4bea-a5cd-3cbffaedae7d | entityStatement | 2019-03-05 | false | registeredEntity | SIA "Gregori" | 1992-09-24 | 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 | ||
| 31142 | e0e9cc71-15ca-458e-8bbc-24793d24bc1d | entityStatement | 2018-05-09 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Z UN Z" | 1992-09-24 | 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 | ||
| 31143 | 0b5319bf-09aa-43f4-86e6-701d24a2fe98 | entityStatement | 2020-11-11 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "EMERALD" | 1992-09-24 | 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 | ||
| 4460 | 4ec4225b-b18c-4c90-84f3-d86e3aaf9e35 | entityStatement | 2019-07-05 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "SkaNa" | 1992-09-24 | 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 |
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]) );