entity_statement
6 rows where "foundingdate" is on date 2011-11-11, iscomponent = "false" and "publicationdetails_publicationdate" is on date 2021-01-19
This data as json, CSV (advanced)
Suggested facets: statementdate, foundingdate (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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 100772 | a7c1a4b2-3a85-4437-87ff-10961f898c69 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "XMatti" | 2011-11-11 | 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 | ||
| 100773 | e8513887-da12-4680-abb5-58f736ca3b0e | entityStatement | 2019-07-15 | false | registeredEntity | SIA "JS" | 2011-11-11 | 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 | ||
| 105168 | dd3505f9-c29b-474d-a76d-c763e023c130 | entityStatement | 2019-07-16 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Rio Sar" | 2011-11-11 | 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 | ||
| 105169 | d93537a5-a957-4a07-892c-6ef0c87c9d2d | entityStatement | 2019-07-16 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "MunS Auto" | 2011-11-11 | 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 | ||
| 109934 | 6cd5372f-7553-4b09-be12-d90e9e9b1183 | entityStatement | 2020-11-25 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Fileo" | 2011-11-11 | 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 | ||
| 95617 | af17bc5f-dced-4b0b-b2d2-7c800a45d364 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Golden ELL" | 2011-11-11 | 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]) );