entity_statement
22 rows where publicationdetails_publicationdate = "2021-01-18", "publicationdetails_publicationdate" is on date 2021-01-18 and "statementdate" is on date 2018-10-26
This data as json, CSV (advanced)
Suggested facets: 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11683 | 3cbedc72-1675-4cbb-8065-d3993d8b1f52 | entityStatement | 2018-10-26 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "SKULPTŪRA" | 2001-02-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 | ||
| 12408 | fabf0a64-f752-4697-aab4-b1ab28f101ec | entityStatement | 2018-10-26 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Medicīnas Biznesa Akadēmija" | 2001-09-19 | 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 | ||
| 13251 | a13ab1bb-7c52-4c8b-8d19-478f983ee206 | entityStatement | 2018-10-26 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Būves un būvsistēmas" | 2002-06-03 | 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 | ||
| 20116 | 5d9ef182-5769-4603-8300-bdab679dfdae | entityStatement | 2018-10-26 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Uhh design" | 2006-03-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 | ||
| 23459 | ce191aef-77ba-4da2-9b8e-19757ca224a4 | entityStatement | 2018-10-26 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "8 STŪRI" | 2007-04-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 | ||
| 25406 | be52def3-8717-441d-a6f3-6e5dc774c73a | entityStatement | 2018-10-26 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "DOMENS" | 2007-12-06 | 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 | ||
| 32905 | f93ae993-e39b-4987-8e02-79aed1b7fdea | entityStatement | 2018-10-26 | false | registeredEntity | SIA "PRINTMIX" | 2008-07-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 | ||
| 35154 | 35419fea-733a-443a-bee4-80f82f2b51e3 | entityStatement | 2018-10-26 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "NordTrade" | 2009-08-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 | ||
| 37508 | 6e623dba-fad8-4fa3-9c85-e262101d9495 | entityStatement | 2018-10-26 | false | registeredEntity | SIA "BEATRIC" | 2010-06-19 | 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 | ||
| 41015 | e52481ee-a400-4d30-a15b-660858854021 | entityStatement | 2018-10-26 | false | registeredEntity | SIA "Nuovo Grupa" | 2011-02-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 | ||
| 42373 | 76e4f1f3-f42b-481b-a272-352321663ab8 | entityStatement | 2018-10-26 | false | registeredEntity | SIA "Nouveau" | 2011-04-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 | ||
| 51548 | 4273e3b6-bee7-47d2-a841-bef3786f04a5 | entityStatement | 2018-10-26 | false | registeredEntity | SIA PV Pluss | 2012-11-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 | ||
| 52629 | ea6ebf12-3d19-4a62-bc28-50ab72c75def | entityStatement | 2018-10-26 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "HORCH AB" | 2013-02-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 | ||
| 56753 | 1ecbec42-4d85-4159-a06f-630cb7c64797 | entityStatement | 2018-10-26 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Skolas 2" | 2013-10-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 | ||
| 57327 | 61311821-5f60-44b1-aed2-5b33d011ed18 | entityStatement | 2018-10-26 | false | registeredEntity | SIA "Evasoft" | 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 | ||
| 59064 | 775eb888-5ed2-407a-8949-213ac49b3962 | entityStatement | 2018-10-26 | false | registeredEntity | SIA "LVS BALTIC" | 2014-03-07 | 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 | ||
| 59485 | 132ef4a5-fdd8-4063-84ec-d50bfcd285d4 | entityStatement | 2018-10-26 | false | registeredEntity | Akciju sabiedrība "Reklāmdruka" | 2014-04-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 | ||
| 61859 | dba21336-8098-4cb5-892d-96764f5af92b | entityStatement | 2018-10-26 | false | registeredEntity | SIA VanPersey | 2014-08-22 | 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 | ||
| 66379 | f7b88236-9191-4dee-8707-c53f28069dc7 | entityStatement | 2018-10-26 | false | registeredEntity | SIA "JNZ" | 2015-05-18 | 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 | ||
| 74409 | a192e8c0-9d37-41b2-9fec-117b26dbbad9 | entityStatement | 2018-10-26 | false | registeredEntity | SIA "UCE-Center" | 2016-10-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 | ||
| 74508 | 65751b83-9fa9-4453-930f-1f6f7cfcd64b | entityStatement | 2018-10-26 | false | registeredEntity | SIA "ATH" | 2016-11-03 | 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 | ||
| 8188 | 63c45180-9534-4c17-8fd2-7c883b2ba18c | entityStatement | 2018-10-26 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Elza P" | 1997-11-25 | 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]) );