entity_statement

36 rows where "foundingdate" is on date 2015-11-17

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: statementdate, 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
101798 266ca488-6a82-43e5-880f-ef2b3054f608 entityStatement 2019-07-16 false registeredEntity SIA RS 2015 2015-11-17 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    
105748 1e40ef12-246b-412e-a3c7-9141a3303b82 entityStatement 2019-07-16 false registeredEntity Sabiedrība ar ierobežotu atbildību "Samblero" 2015-11-17 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    
111234 f4671ada-b1c4-41b5-bf7d-2dee0f23457e entityStatement 2019-07-16 false registeredEntity Sabiedrība ar ierobežotu atbildību "Studija.IT" 2015-11-17 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    
69139 abf5ad0e-8d00-4ee9-bbf6-8fff9881a041 entityStatement 2019-07-14 false registeredEntity SIA "A & P Risinājumi" 2015-11-17 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    
69140 9756cba3-19d4-41ec-8187-b79673f5afb3 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Tomorrowland" 2015-11-17 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    
69141 37fceae4-ff3d-42a5-b14b-4ff88213f9d1 entityStatement 2019-07-15 false registeredEntity SIA "RenArt Trade" 2015-11-17 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    
69142 6539ce4b-629a-4cd7-a523-42f46071f2f8 entityStatement 2019-01-23 false registeredEntity SIA "Garsas invest" 2015-11-17 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    
69143 1cb2795f-43a1-4a08-8b4b-54471327e94a entityStatement 2019-07-14 false registeredEntity SIA "LVS Jurgan" 2015-11-17 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    
69144 541d8321-6a5a-4422-a466-f488c4c54ff3 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "RINEKO" 2015-11-17 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    
69145 e3bd1415-d250-48bb-ac25-3dd63294f71f entityStatement 2019-01-23 false registeredEntity Sabiedrība ar ierobežotu atbildību "Tikuna Trade" 2015-11-17 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    
69146 b8e5bea8-b67f-4276-99d5-569a83e89906 entityStatement 2018-05-29 false registeredEntity Sabiedrība ar ierobežotu atbildību "Citrus N" 2015-11-17 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    
69147 a3fce9ae-cdb1-43b8-9a21-5049e6283d8e entityStatement 2018-03-06 false registeredEntity Sabiedrība ar ierobežotu atbildību "SP Bārs" 2015-11-17 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    
69148 1fcd93a3-99c6-45cb-a117-0527a1fa1ab7 entityStatement 2018-02-21 false registeredEntity SIA "OAK Latvia" 2015-11-17 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    
69149 9d102163-9230-4839-9ba8-1d584b163382 entityStatement 2018-03-26 false registeredEntity Sabiedrība ar ierobežotu atbildību "Baltic media solution" 2015-11-17 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    
69150 58787b4f-80a6-480b-875f-30a9f0e5160a entityStatement 2019-07-15 false registeredEntity SIA AOPRINT 2015-11-17 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    
69151 af52f555-d14f-4dde-a74c-b58c7e8d3d44 entityStatement 2019-07-15 false registeredEntity "inAPP" SIA 2015-11-17 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    
69152 2eca1f6e-0437-4f69-a8a1-c1044ad4a401 entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "AL KILANI CONSULTING" 2015-11-17 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    
69153 7a72effb-32f5-4e4c-98fd-758592fd0516 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Zogotta 84" 2015-11-17 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    
69154 673932f3-2517-4911-b8a9-82fb191c7c66 entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "Spectaclion" 2015-11-17 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    
69155 de1d238d-b24a-454f-98b5-a9144214484e entityStatement 2018-03-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "RULAT" 2015-11-17 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    
69156 e1a85174-9f58-4d55-9a0e-6f643d5910a6 entityStatement 2018-05-07 false registeredEntity SIA "Bhandar" 2015-11-17 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    
69157 d15208d8-9bad-4004-b6e1-f53ed89fc7b3 entityStatement 2019-07-15 false registeredEntity SIA "KKR studija" 2015-11-17 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    
69158 5aba57e1-3281-469c-b751-a6c9032a3529 entityStatement 2019-07-14 false registeredEntity SIA "K. Unik" 2015-11-17 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    
69159 ab082dc8-923b-4420-9fae-7cd83fa96698 entityStatement 2018-02-26 false registeredEntity SIA "BALTIC INVESTOR TEAM" 2015-11-17 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    
69160 eecef629-e59c-49f9-87b3-4b9d63e144ed entityStatement 2017-12-20 false registeredEntity SIA "KFBF" 2015-11-17 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    
69161 d5cd31ca-349c-4eff-9901-1d799ded8e7c entityStatement 2019-07-14 false registeredEntity SIA Quality Clean Service 2015-11-17 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    
69162 bcfb2bd4-4452-4494-9213-ab513ce15929 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "R.A.Construction" 2015-11-17 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    
69163 7f568088-463e-477b-8c65-88acef313122 entityStatement 2018-10-04 false registeredEntity SIA Ardeņu serviss 2015-11-17 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    
69164 0dfa8a02-4217-4689-88e1-ec4d8a92b2b1 entityStatement 2019-07-15 false registeredEntity SIA "RAEDA" 2015-11-17 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    
69165 b2ed4d83-ea83-4013-a53a-c7cebd00e125 entityStatement 2019-07-15 false registeredEntity SIA "Artliner" 2015-11-17 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    
69166 6ea6a675-7d2e-4558-859d-71c8c3970fb2 entityStatement 2019-09-12 false registeredEntity SIA "Strategic Initiative group "UNITE"" 2015-11-17 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    
69167 59181fe2-e48b-409a-9a90-a19532069413 entityStatement 2019-01-09 false registeredEntity SIA "AV Darbnīca" 2015-11-17 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    
69168 1ae9b6ec-0fd5-459c-9d98-22dd690a7726 entityStatement 2018-05-24 false registeredEntity SIA "INTELTELECOM" 2015-11-17 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    
69169 3994ef91-f0e1-4c6c-85bd-3999534995ff entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "BALTINEL" 2015-11-17 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    
96570 a287d4af-c5c5-4402-871d-5367a1d9acf1 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "MZGB" 2015-11-17 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    
96571 626c2a73-21f9-423d-8ab7-acfb5c5eef1d entityStatement 2019-07-15 false registeredEntity SIA "WELIKA" 2015-11-17 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]) 
);