entity_statement

33 rows where foundingdate = "2019-02-18", "foundingdate" is on date 2019-02-18 and iscomponent = "false"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: statementdate, 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
102958 2c357234-1bee-4294-b4d0-313a973bacce entityStatement 2019-02-18 false registeredEntity SIA Infinity Stone Pro 2019-02-18 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    
102959 a9e244f1-a623-4b66-874d-057ec66f86f7 entityStatement 2019-02-18 false registeredEntity LD IT Investments SIA 2019-02-18 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    
102960 c27ea875-bd0b-4301-979b-18a5cc58c449 entityStatement 2019-02-18 false registeredEntity SIA "BALTIC GLOBAL TRADE" 2019-02-18 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    
102961 2de72aa6-a6c6-4884-bbc1-655758c6ecb1 entityStatement 2020-04-09 false registeredEntity Sabiedrība ar ierobežotu atbildību "MANUFACTURA" 2019-02-18 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    
102962 19956318-1ef2-4987-8748-63992cb916b2 entityStatement 2020-08-24 false registeredEntity SIA "Wok N Roll" 2019-02-18 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    
102963 fec97924-d372-4407-b1d5-a2d5bd112265 entityStatement 2019-02-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "Baltijas Apzaļumošana" 2019-02-18 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    
106305 ed9c0bbd-e704-407d-bd93-c157b1b23ea7 entityStatement 2019-02-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "Roots Coffee" 2019-02-18 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    
112325 f18e9410-2369-4847-b9d1-f3ac362adc23 entityStatement 2019-02-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "Cenītis" 2019-02-18 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    
112326 62d5e9b4-b3c6-4498-9d60-edaf19b01f3f entityStatement 2019-02-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "AĀMD" 2019-02-18 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    
112327 601e09a7-c0f7-41ba-9184-362bcd8cabe6 entityStatement 2019-02-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "RJD" 2019-02-18 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    
112328 c24abb4e-70fc-4472-8b85-a8319f947c00 entityStatement 2019-10-09 false registeredEntity REORBIS SIA 2019-02-18 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    
112329 f68358d0-7626-438e-b22b-1ebff64968a9 entityStatement 2019-02-18 false registeredEntity GEHEIT SIA 2019-02-18 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    
112330 f1eeabb5-eb82-4992-889d-26004eebf939 entityStatement 2019-02-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "FIFO" 2019-02-18 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    
29332 a1791dbf-1c3f-4341-a09b-528015b9be27 entityStatement   false registeredEntity Biedrība "FOTO VĒSTNIECĪBA" 2019-02-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    
87395 65efa48e-7fd9-4c60-8929-11e666aac85c entityStatement 2020-08-18 false registeredEntity SIA "Meder Beauty" 2019-02-18 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    
87396 bf03341a-5bd2-4952-b774-cd2c80583e33 entityStatement 2019-02-18 false registeredEntity SIA "Sofija Group" 2019-02-18 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    
87397 0d7c19e8-8352-4212-b405-02f1d01e8c7e entityStatement 2019-02-18 false registeredEntity SIA "SL-Strom" 2019-02-18 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    
87398 1b99ef65-9e6c-48f9-afb7-4d3b2ebfef9d entityStatement 2019-02-18 false registeredEntity Ostbridge SIA 2019-02-18 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    
87399 ac0defb5-0381-4899-9cd6-5dbd6c133c9e entityStatement 2019-02-18 false registeredEntity Davidbasier SIA 2019-02-18 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    
87400 bdf3206c-7e16-40b5-92a5-345963cc4234 entityStatement 2019-02-18 false registeredEntity SIA "LemoWood" 2019-02-18 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    
87401 a12ade25-8c30-4eb6-bee2-d4761d69944f entityStatement 2019-02-18 false registeredEntity SIA WALLERY 2019-02-18 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    
87402 cba211f6-e9b9-44bc-b8b2-4f9b2d459658 entityStatement 2019-02-18 false registeredEntity SIA "ElisEmis" 2019-02-18 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    
87403 2b5fefe1-f2e1-4877-9737-d1cc4d1f7911 entityStatement 2020-01-21 false registeredEntity SIA "SRI SHIRDI SAI" 2019-02-18 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    
87404 0e721331-a3d1-4109-a5df-a79be9530e66 entityStatement 2019-02-18 false registeredEntity SIA RB MUSIC 2019-02-18 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    
87405 a1bf7c3f-551c-4fc2-9294-dc927bfcf857 entityStatement 2019-02-18 false registeredEntity SIA "in.beauty.salon" 2019-02-18 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    
87406 7f8916ab-84ab-40db-ba92-1fa881ca21a5 entityStatement 2019-02-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "RUNAS SKOLA" 2019-02-18 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    
87407 ffd521f6-b592-47df-9c2f-b8b6cb984617 entityStatement 2019-02-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "DVR" 2019-02-18 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    
87408 42ff3db3-a589-472a-9cae-b66a0b49d4d9 entityStatement 2019-02-18 false registeredEntity SIA Mercury 1 2019-02-18 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    
87409 b39dff0f-eb96-4635-b675-79f77971f13d entityStatement 2019-02-18 false registeredEntity SIA "RJR studio" 2019-02-18 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    
87410 c4164c05-2cfb-49a3-9e9a-33826c7e6d0a entityStatement 2019-02-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "PAGORS" 2019-02-18 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    
87411 9ba37340-f12b-4e44-9aff-2d84c77846f0 entityStatement 2019-09-03 false registeredEntity Sabiedrība ar ierobežotu atbildību "Aftershock" 2019-02-18 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    
97375 fcb6fa5e-4bb5-40aa-8b03-64f082b54803 entityStatement 2019-02-18 false registeredEntity SIA "O.Kļaviņas ģimenes ārsta prakse" 2019-02-18 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    
97376 f4e54bba-7dcf-471f-9049-5bbf1ca78b15 entityStatement 2019-02-18 false registeredEntity Sabiedrība ar ierobežotu atbildību ID Tīkli 2019-02-18 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]) 
);