entity_statement
20 rows where iscomponent = "false", "publicationdetails_publicationdate" is on date 2021-01-18 and "statementdate" is on date 2020-03-20
This data as json, CSV (advanced)
| _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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13182 | e8c90f25-050d-44d8-9b31-2908de42ace6 | entityStatement | 2020-03-20 | false | registeredEntity | SIA "HOFMAN STUDIO" | 2002-05-08 | 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 | ||
| 15737 | ca62eb85-e49a-4b14-8fcb-fcfe07d25dbe | entityStatement | 2020-03-20 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "EIROTEX" | 2004-04-01 | 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 | ||
| 16749 | e90209b8-95d4-4b26-abf1-4551a9c8fb7c | entityStatement | 2020-03-20 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "FINEST DEVELOPMENT" | 2004-10-08 | 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 | ||
| 21268 | a60b7c2c-eec8-4c42-8a06-46630c5c4893 | entityStatement | 2020-03-20 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "VIRTUS IT" | 2006-08-21 | 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 | ||
| 24823 | 30e30c94-181e-4571-be46-956242a5d09b | entityStatement | 2020-03-20 | false | registeredEntity | SIA "Auto Online" | 2007-09-27 | 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 | ||
| 24874 | a4d6ad96-0c4c-4b3f-bea0-bb0c8e0b593d | entityStatement | 2020-03-20 | false | registeredEntity | SIA "VAIDOMA" | 2007-10-04 | 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 | ||
| 26519 | 25c6157d-0294-45d3-b273-f1ae4b5d177e | entityStatement | 2020-03-20 | false | registeredEntity | "PROJECT SERVICE" | 2001-04-12 | 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 | ||
| 26987 | 8fc8e625-0a96-4acf-bd15-0c31aff2d6b4 | entityStatement | 2020-03-20 | false | registeredEntity | Pētera Avena labdarības fonds "Paaudze" | 2008-05-30 | 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 | ||
| 2725 | 3311dce1-3eee-4de9-a934-029e7b099cd1 | entityStatement | 2020-03-20 | false | registeredEntity | SIA "BLANES" | 1997-07-16 | 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 | ||
| 34047 | f4fd11f7-1a9a-4094-a2d4-3a26a16bb112 | entityStatement | 2020-03-20 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "SCONTO" | 2009-02-05 | 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 | ||
| 46697 | 408bd5f0-ec43-46d6-889c-6af0887e8395 | entityStatement | 2020-03-20 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "A.B.FIRST" | 2012-02-02 | 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 | ||
| 47325 | d3334e1c-69ef-4081-ae3a-18ce271df2ab | entityStatement | 2020-03-20 | false | registeredEntity | SIA "Alatus" | 2012-03-09 | 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 | ||
| 48046 | ef130c19-4aac-4127-acb3-12bcd2413d6a | entityStatement | 2020-03-20 | false | registeredEntity | SIA "AMBERLAND" | 2012-04-23 | 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 | ||
| 4888 | 615671c6-c81b-4ed4-a938-9e801b117898 | entityStatement | 2020-03-20 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "FONONS" | 1993-07-14 | 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 | ||
| 49025 | c8af41c7-bd2a-4fd7-9983-c8753b570fbc | entityStatement | 2020-03-20 | false | registeredEntity | SIA "ENDRJUS" | 2012-06-20 | 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 | ||
| 50083 | b5a870bd-3107-470a-884f-16916d07d94b | entityStatement | 2020-03-20 | false | registeredEntity | SIA "HOMIES" | 2012-08-29 | 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 | ||
| 57313 | f4309763-7e6f-4c49-abf1-31bcf223a700 | entityStatement | 2020-03-20 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "International Restorāns Jūrmala" | 2013-11-15 | 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 | ||
| 66103 | 221a54f6-5974-46ed-b659-395460cd9977 | entityStatement | 2020-03-20 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "RAMEJ CONSTRUCTION" | 2015-04-30 | 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 | ||
| 6620 | 5cbf7131-41d7-4837-b37d-75eef47a6d7a | entityStatement | 2020-03-20 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "SATEKS R" | 1995-12-29 | 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 | ||
| 8735 | 826ec739-4351-4ca3-baa7-958c7d28de68 | entityStatement | 2020-03-20 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Citadeles moduļi" | 1998-06-09 | 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]) );