entity_statement

40 rows where "foundingdate" is on date 2011-01-14 and iscomponent = "false"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: statementdate, publicationdetails_publicationdate, statementdate (date), 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
100547 1130bf1f-4099-4f75-ad7f-d1055c62a05a entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Agrostars" 2011-01-14 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    
100548 f286b38d-60ff-40fe-a055-e7f8e2d6d8c3 entityStatement 2018-04-05 false registeredEntity SIA "INREX FINANCE" 2011-01-14 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    
27316 3091e9c0-9978-4947-a04d-0d787f4e3de8 entityStatement 2019-07-27 false registeredEntity "Labdarības fonds "BlagoDar"" 2011-01-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    
40328 5a3c6a49-9b6a-4010-b2e0-4e00d25ff3fc entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "WEB GURU" 2011-01-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    
40329 2f5c6255-2656-443b-862e-e546124ba92f entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "Kupena" 2011-01-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    
40330 41e6f65f-6c2b-468e-b58d-f15bace412b4 entityStatement 2019-07-12 false registeredEntity Sabiedrība ar ierobežotu atbildību "BG Sistēma" 2011-01-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    
40331 04adcafb-65b2-4f5a-8657-130760d2202a entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "AGKM" 2011-01-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    
40332 c64ef664-ede9-475a-be44-234cb38b584c entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "Parks menedžments" 2011-01-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    
40333 0be4969d-f101-4caa-a911-0e2c6838fc29 entityStatement 2018-03-02 false registeredEntity SIA "EKODAT" 2011-01-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    
40334 c8aca7da-acb0-4f61-a737-a13e4b6dde3a entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "Esences Deco" 2011-01-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    
40335 f2902a3f-5d86-47af-bc40-605aee1f62a6 entityStatement 2020-10-07 false registeredEntity Sabiedrība ar ierobežotu atbildību "Figures" 2011-01-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    
40336 b923009d-e2d5-445e-bcf5-2a41d118bb9c entityStatement 2019-07-11 false registeredEntity SIA "Vīngliemeži" 2011-01-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    
40337 71cf2275-c821-410c-b657-0a56ea517920 entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "Dati-IT" 2011-01-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    
40338 4bbf556c-94a4-4950-a2e7-2c703d2eded7 entityStatement 2018-08-02 false registeredEntity Sabiedrība ar ierobežotu atbildību "Berjozka" 2011-01-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    
40339 4f3caf12-313c-46ad-a5d3-82ca9e18613c entityStatement 2019-06-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "BI Sistēmas" 2011-01-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    
40340 aa70a876-b803-4b5f-bc2f-077eff59d9f2 entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "Stellaria" 2011-01-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    
40341 cb3150ad-f772-42e1-9222-4e0dd423815f entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "Edons" 2011-01-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    
40342 85c9285e-eb3a-407e-870a-996edb0bb008 entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "CONTA AUDIT" 2011-01-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    
40343 0e6d93e4-4a0f-4393-878f-8e6e498899fd entityStatement 2019-07-11 false registeredEntity SIA "KOKA MĒBELES" 2011-01-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    
40344 9aaad51f-9372-4261-9446-c476d1e88e2a entityStatement 2019-07-11 false registeredEntity SIA "Anna Style" 2011-01-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    
40345 987441c6-d37d-40e6-805c-e89ad1952d8d entityStatement 2018-10-03 false registeredEntity SIA "IV Risinājumi" 2011-01-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    
40346 51ad2973-0545-40cd-9383-bcd00dac8713 entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "POLLERE" 2011-01-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    
40347 c8cfded2-60e6-4724-af83-c6dfa58bcc7b entityStatement 2019-07-11 false registeredEntity "ESPRESSOBLUE" SIA 2011-01-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    
40348 4812f150-2877-4f8b-98a6-b6754eba1d6d entityStatement 2018-04-06 false registeredEntity SIA "AB Holding" 2011-01-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    
40349 95e717f3-7a66-4a5f-bf3d-c53ef7325279 entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "Providencia" 2011-01-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    
40350 4fdeb15f-8bb1-4218-9399-f5f7e8afd9b8 entityStatement 2019-07-11 false registeredEntity SIA "Complete Payment Systems" 2011-01-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    
40351 040f4bbb-a01b-4b6a-8a61-959d338c2ca9 entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "Autogalaktika" 2011-01-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    
40352 354f4992-65b1-4cc7-8beb-ddb12e3178dc entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "LIRA 7" 2011-01-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    
40353 30d49e34-a2fc-4654-83a5-9ce8ea08307d entityStatement 2019-07-11 false registeredEntity SIA "AKTO" 2011-01-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    
40354 4f38dd12-5477-4a2b-b3b4-19bddf55c0c5 entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "Oleander" 2011-01-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    
40355 39668cb7-6168-48e6-8a80-fc22ca7d1160 entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "TILBĪTE-A" 2011-01-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    
40356 000d5992-4b7c-4f7b-a1cf-d839e9f9fe18 entityStatement 2017-12-14 false registeredEntity ULTIMA RATIO GROUP SIA 2011-01-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    
40357 3f89594c-2989-45ed-bfc1-5c6ee5835597 entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "Ze Food" 2011-01-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    
40358 c4704a91-65a2-4959-b2da-832a2a410ddd entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "EGK" 2011-01-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    
40359 2b032cbe-a99a-4685-814c-3e29b185d53c entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "Reivita" 2011-01-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    
40360 40e3f813-3113-4aaf-b7aa-e511605a8a6f entityStatement 2019-07-11 false registeredEntity SIA "DL PROJEKTS" 2011-01-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    
90874 00959c7b-3676-48d9-ba8d-e1b753fa8478 entityStatement 2019-07-15 false registeredEntity SIA "MARJAS" 2011-01-14 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    
95401 0c9a562d-db75-4351-b4f0-a77eadb8853f entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "AKER-D" 2011-01-14 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    
95402 a74d1a18-9cb8-418e-8bd0-22641197a28b entityStatement 2019-07-15 false registeredEntity SIA "AKAB" 2011-01-14 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    
95403 d7067e17-d7ef-423e-b74d-9dffec565870 entityStatement 2019-05-10 false registeredEntity Sabiedrība ar ierobežotu atbildību "ADO Loģistika" 2011-01-14 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

CSV options: 

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]) 
);