entity_statement

43 rows where "foundingdate" is on date 2019-04-26

✎ View and edit SQL

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
103258 2e09c49d-2699-466f-b6da-7714081eea0c entityStatement 2019-04-26 false registeredEntity SIA RSW 2019-04-26 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    
103259 f16a4be2-8f52-47ed-808f-ae429f14b5fc entityStatement 2019-04-26 false registeredEntity SIA "Hamburger" 2019-04-26 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    
103260 3fd347f2-c53e-4e51-846c-e0df6fff6aa5 entityStatement 2019-04-26 false registeredEntity Pilnsabiedrība CTB-MIKOR 2019-04-26 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    
103261 3549357b-e0d0-4617-8a52-c4e710aff657 entityStatement 2019-04-26 false registeredEntity SIA "POPROKSKOLA" 2019-04-26 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    
103262 f35840d9-7f67-46e3-9e7a-ed811893b312 entityStatement 2019-08-23 false registeredEntity SIA "maxfit" 2019-04-26 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    
103263 ceda42b8-fc53-4156-8f63-c0b01c179175 entityStatement 2019-04-26 false registeredEntity Sabiedrība ar ierobežotu atbildību "Teirdarbs HR" 2019-04-26 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    
103264 213a9897-ae13-44ba-8b63-9eb07e90f92c entityStatement 2019-04-26 false registeredEntity SIA "Krastiņu laivu noma" 2019-04-26 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    
103265 36b56afa-7bf3-4001-b1a4-765ada2feb98 entityStatement 2020-09-07 false registeredEntity Sabiedrība ar ierobežotu atbildību "AU79" 2019-04-26 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    
103266 a49eff93-b12c-469f-b3f8-334b346c2027 entityStatement 2019-04-26 false registeredEntity SIA "Victor Shipbuilding Company" 2019-04-26 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    
103267 a33dc2a6-2eac-436a-8cbe-314713efc526 entityStatement 2019-04-26 false registeredEntity SIA denesi 2019-04-26 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    
106344 51c0290e-e75a-4778-9a2d-896b09a4d4b6 entityStatement 2019-04-26 false registeredEntity Sabiedrība ar ierobežotu atbildību "AUTOBON" 2019-04-26 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    
106345 0c30adec-7609-4eaf-b11f-aa61de1d5fb4 entityStatement 2019-04-26 false registeredEntity Sabiedrība ar ierobežotu atbildību "ZIGOR MZ" 2019-04-26 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    
112440 b24df4e4-91d6-4eca-992f-7fad5dd4b733 entityStatement 2019-04-26 false registeredEntity SIA "Riverside Guest House" 2019-04-26 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    
112441 05835489-65b7-4de2-8752-363d57523a1a entityStatement 2019-04-26 false registeredEntity SIA "IHA AUTO" 2019-04-26 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    
112442 7e9cdbe8-7236-43ab-930d-17b778d884c8 entityStatement 2019-04-26 false registeredEntity SIA "DIMKRAFT" 2019-04-26 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    
29515 2b9341f8-b8be-4296-80cc-f27e2f781e3b entityStatement   false registeredEntity Biedrība "Latviskās dzīves ziņas kopa "Silavoti"" 2019-04-26 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    
88465 3d908b19-f0bf-4e51-bf34-ea8bbf069491 entityStatement 2019-04-26 false registeredEntity Data Lab SIA 2019-04-26 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    
88466 eb55e6ee-1be8-43e7-9772-fbc574d42a1b entityStatement 2019-04-26 false registeredEntity SIA "RACARAC" 2019-04-26 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    
88467 289fa924-1e00-44cf-9216-05a00a8f1b31 entityStatement 2019-04-26 false registeredEntity SIA "CDX TEKMET" 2019-04-26 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    
88468 2152f09d-c0e6-465f-b2e9-a550bee97e4c entityStatement 2019-04-26 false registeredEntity Sabiedrība ar ierobežotu atbildību "7a7s" 2019-04-26 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    
88469 6fe56b0c-0eb0-4e70-bb04-0783497674c9 entityStatement 2019-04-26 false registeredEntity SIA Geraldus 2019-04-26 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    
88470 99d58862-ea22-4f55-8a02-c99827c18eec entityStatement 2019-04-26 false registeredEntity Sabiedrība ar ierobežotu atbildību "OSC Autoserviss" 2019-04-26 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    
88471 f08a0759-3dae-4c8f-8281-fc876505ecc1 entityStatement 2019-04-26 false registeredEntity SIA "RIVARS STUDIO" 2019-04-26 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    
88472 2e4b47f3-7cdc-42e6-a036-56b642435701 entityStatement 2019-04-26 false registeredEntity SIA "GREENCOSMETICS EUROPE" 2019-04-26 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    
88473 a20ada77-ae8a-4ace-b127-300202a4b1b3 entityStatement 2019-04-26 false registeredEntity SIA "SKADI B" 2019-04-26 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    
88474 2b207876-e5ec-4a84-9d26-149dda70db9d entityStatement 2019-04-26 false registeredEntity SIA "SK Kursi" 2019-04-26 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    
88475 2952c435-808d-448c-882e-112c9db7e9c3 entityStatement 2019-04-26 false registeredEntity Sabiedrība ar ierobežotu atbildību "Malina" 2019-04-26 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    
88476 465d83f5-8278-46ea-ada8-fe22c73749dd entityStatement 2019-04-26 false registeredEntity SIA Divi autoparts 2019-04-26 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    
88477 fbae0789-2940-4590-9d0a-a9f62778443d entityStatement 2019-04-26 false registeredEntity Sabiedrība ar ierobežotu atbildību "SmartBaby.lv" 2019-04-26 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    
88478 e6faf483-b6e5-4d2e-8d3b-2f533a1f3612 entityStatement 2019-04-26 false registeredEntity Bercman Innovations SIA 2019-04-26 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    
88479 ac7c6f45-eca9-4378-b6e7-3e8cad95bc88 entityStatement 2019-04-26 false registeredEntity SIA NEJ 2019-04-26 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    
88480 7b07535d-d8f9-45e5-a275-3b1b2afd6a4e entityStatement 2019-04-26 false registeredEntity SIA "Dizaina Ambulance" 2019-04-26 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    
88481 9da211c1-e39f-4a49-9c97-cdf9f8eec184 entityStatement 2019-04-26 false registeredEntity Sabiedrība ar ierobežotu atbildību "ALVIN" 2019-04-26 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    
88482 db95addf-5fac-44f4-8623-f0c57cd7b32e entityStatement 2019-08-14 false registeredEntity SIA "Baltic Green Investments I" 2019-04-26 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    
88483 24d779b9-279a-4d04-bc4c-430e7f2cb136 entityStatement 2019-04-26 false registeredEntity SIA "EJ PROJEKTI" 2019-04-26 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    
88484 43755cd4-8d6d-4878-a8ab-989d8f839453 entityStatement 2019-04-26 false registeredEntity SIA "BĀRS2" 2019-04-26 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    
88485 a6099175-aad7-44dd-8cc6-d2e7f3b3e48d entityStatement 2019-04-26 false registeredEntity KF Talent SIA 2019-04-26 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    
88486 f5169d77-ddfe-43eb-a635-8df716599915 entityStatement 2019-04-26 false registeredEntity SIA house of caviar 2019-04-26 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    
88487 d2b5e620-e3c9-4211-849c-33d102477fec entityStatement 2019-04-26 false registeredEntity SIA EKSPRES-EKSPERTS 2019-04-26 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    
88488 57526657-2fd4-4a08-bc50-fa28babe0cc0 entityStatement 2019-04-26 false registeredEntity SIA "Veles International Group" 2019-04-26 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    
88489 7bbafe49-bd80-4c13-ba50-cf2efa5f0ebe entityStatement 2019-04-26 false registeredEntity SIA AMO Export 2019-04-26 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    
92756 6acb736c-867e-4a61-8ab5-1bbea7457dad entityStatement 2020-01-27 false registeredEntity Sabiedrība ar ierobežotu atbildību "Mane Nova" 2019-04-26 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    
97442 a69f3106-0b11-4a2f-bc24-3b94882435fc entityStatement 2019-04-26 false registeredEntity SIA "PALunited" 2019-04-26 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]) 
);