entity_statement

46 rows where foundingdate = "2019-04-23" and iscomponent = "false"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: statementdate, publicationdetails_publicationdate, statementdate (date), foundingdate (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
103249 50d3f90a-348f-480e-a03f-96bd4e4e120a entityStatement 2019-11-06 false registeredEntity Sabiedrība ar ierobežotu atbildību "CARPOOL" 2019-04-23 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    
103250 e91a0c2d-8ffc-41de-85f8-20ffb73c87ce entityStatement 2020-09-29 false registeredEntity SIA "LATEC LV" 2019-04-23 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    
103251 0a17263b-89b5-4c59-95d5-7c19fc199d28 entityStatement 2019-04-23 false registeredEntity SIA "Commerce24 online" 2019-04-23 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    
29500 5351a342-4ca2-4398-a1be-94d1679e0299 entityStatement   false registeredEntity Biedrība "AKTĪVAI KOKNESEI" 2019-04-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    
29501 ada73bd8-738f-4845-a852-972ca64697dd entityStatement 2020-06-25 false registeredEntity LATVIJAS KREDĪTŅĒMĒJU PALĪDZĪBAS PROGRAMMA 2019-04-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    
29502 68724ac2-07cc-46d3-80b3-1b8d46bbe7f0 entityStatement 2019-04-23 false registeredEntity Latvijas cīņas sporta sportistu apvienība 2019-04-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    
29503 6c232467-cce2-4824-a26a-09ea790d969b entityStatement   false registeredEntity MVK "Elegance" 2019-04-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    
29504 0fe1794b-1a56-410e-b543-ce2c908f9dd5 entityStatement   false registeredEntity "Krīzes zvans" 2019-04-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    
88383 914441a0-6bdb-4d7f-b89f-3da800cd4d64 entityStatement 2019-04-23 false registeredEntity SIA "MM mikro" 2019-04-23 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    
88384 f7b57f9f-d10b-4a3a-8772-7615f37107af entityStatement 2019-04-23 false registeredEntity SIA OJ Serviss 2019-04-23 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    
88385 e037e32e-180a-4806-ac93-4974dd4b7ef4 entityStatement 2019-04-23 false registeredEntity Sabiedrība ar ierobežotu atbildību "Puķubode IG" 2019-04-23 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    
88386 152e508d-32a7-4dd3-b3a0-3db7cb41efe9 entityStatement 2019-04-23 false registeredEntity SIA COCO NUTS 2019-04-23 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    
88387 91014419-ab00-4002-b78b-6086eb2a915d entityStatement 2019-04-23 false registeredEntity Sabiedrība ar ierobežotu atbildību AVE-K 2019-04-23 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    
88388 52c0b140-16da-4539-b49b-57af49066b56 entityStatement 2019-04-23 false registeredEntity Sabiedrība ar ierobežotu atbildību "Skorpis GG" 2019-04-23 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    
88389 9ffcb24f-5337-4aa1-a2b9-973c247fb4f0 entityStatement 2019-04-23 false registeredEntity SIA Domini Este 2019-04-23 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    
88390 89a8bf07-8306-40d3-87e1-65f7f5a17d95 entityStatement 2019-04-23 false registeredEntity SIA "Make It Rain" 2019-04-23 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    
88391 eefdfae5-3655-4ac8-88ac-99d13d4905ca entityStatement 2019-04-23 false registeredEntity SIA "Bobslejs" 2019-04-23 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    
88392 54278fe2-e26e-49e5-a7ce-d35467acee3d entityStatement 2019-04-23 false registeredEntity SIA "SALIDE" 2019-04-23 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    
88393 2a0bf0da-c08d-44a7-b069-1081d72e008d entityStatement 2019-04-23 false registeredEntity SIA Metamorphology 2019-04-23 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    
88394 4b79ac3e-0d3a-4650-a167-b2beb810e6b7 entityStatement 2020-07-07 false registeredEntity Gustava parks projekti SIA 2019-04-23 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    
88395 dee2668b-89b2-40dd-8df9-d4b11d3ba40e entityStatement 2019-04-23 false registeredEntity Sabiedrība ar ierobežotu atbildību "Amilara" 2019-04-23 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    
88396 6e262be9-ebbe-48e7-a742-f42d9b4178f2 entityStatement 2019-04-23 false registeredEntity Sabiedrība ar ierobežotu atbildību "Riga Transfer" 2019-04-23 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    
88397 f160ee3d-1073-4d86-9e86-5c971b3d034a entityStatement 2019-04-23 false registeredEntity SIA "YUSHKOV.CO" 2019-04-23 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    
88398 b57cb4c3-dd7c-46db-b4bb-90aec4a048db entityStatement 2019-04-23 false registeredEntity SIA "ADVENTURE CONSTRUCTIONS" 2019-04-23 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    
88399 52d27e17-c041-4980-966d-5efa676883c9 entityStatement 2019-04-23 false registeredEntity SIA "TRITOM GROUP" 2019-04-23 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    
88400 456dc69f-c42c-48f9-a6f6-e64a69555917 entityStatement 2019-04-23 false registeredEntity Sabiedrība ar ierobežotu atbildību "32 lv" 2019-04-23 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    
88401 dc5d0cc7-f6d8-41ef-a80d-8537c50f3c5a entityStatement 2020-04-21 false registeredEntity Sabiedrība ar ierobežotu atbildību "JABI" 2019-04-23 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    
88402 61d75302-1a10-44db-8b76-dbb05b36adac entityStatement 2019-04-23 false registeredEntity SIA MESA 2019-04-23 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    
88403 dab804ab-342c-42bf-bb24-e351cb6a0a84 entityStatement 2019-04-23 false registeredEntity SIA "BŪVNIECĪBAS UZRAUDZĪBAS BIROJS" 2019-04-23 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    
88404 b8e7b500-cb38-4f5c-a094-35c25e087d55 entityStatement 2019-04-23 false registeredEntity Sabiedrība ar ierobežotu atbildību "LAS GROUP" 2019-04-23 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    
88405 8bf589ad-6f7a-49c2-9902-6d95371c834c entityStatement 2019-04-23 false registeredEntity Sabiedrība ar ierobežotu atbildību "BPC World" 2019-04-23 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    
88406 5bc715f1-8bf8-49b2-bf45-17ab1405b92e entityStatement 2019-04-23 false registeredEntity SIA "RRAIM" 2019-04-23 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    
88407 179bed71-3429-497f-ab7c-1e87f6bf7fdb entityStatement 2019-04-23 false registeredEntity SIA "BOLDYIELD" 2019-04-23 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    
88408 c6cd72ba-5db3-4b6b-a57b-416b88cec163 entityStatement 2019-04-23 false registeredEntity SIA 3 Producers 2019-04-23 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    
88409 de199dd1-8b3c-4d02-8858-bbf850cf7091 entityStatement 2019-04-23 false registeredEntity Sabiedrība ar ierobežotu atbildību "KNIT Latvia" 2019-04-23 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    
88410 ea2c2729-e088-4040-afaa-82b6b2afd528 entityStatement 2019-04-23 false registeredEntity SIA "Moon print" 2019-04-23 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    
88411 6ee83ee4-4c73-4524-9cae-064d0492e13a entityStatement 2020-02-24 false registeredEntity Wholesale bulk fruit juices SIA 2019-04-23 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    
88413 b8e99af3-93b0-4cc3-95bb-bc3c63e580e7 entityStatement 2019-04-23 false registeredEntity SIA TEHREM-S 2019-04-23 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    
88414 e0362dbe-ba72-4aa8-94b3-d680ba3e5520 entityStatement 2019-04-23 false registeredEntity Sabiedrība ar ierobežotu atbildību "RG Concept Store" 2019-04-23 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    
88415 6a4c66f2-d75c-429c-9c71-8229f778a1b0 entityStatement 2019-04-23 false registeredEntity SIA "AM Invest" 2019-04-23 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    
88416 6a5cacd5-80c7-4b4f-89bc-f2a2d62ceebd entityStatement 2019-04-23 false registeredEntity Sabiedrība ar ierobežotu atbildību "ASKA Design" 2019-04-23 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    
88417 6f1a0aee-0bf9-47c5-95ba-c6d0ca4e7815 entityStatement 2019-04-23 false registeredEntity Sabiedrība ar ierobežotu atbildību "OAP BIROJS" 2019-04-23 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    
88418 c1afc57b-1a94-489c-8518-566e866e13d6 entityStatement 2019-04-23 false registeredEntity SIA "RAL Trans" 2019-04-23 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    
88419 f73a56ef-1a95-486c-8cac-a758186a47bb entityStatement 2019-04-23 false registeredEntity Sabiedrība ar ierobežotu atbildību "Trans Baltic ltd." 2019-04-23 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    
92753 adff7277-4f26-4408-aa2b-eaeb1d3b299b entityStatement 2019-04-23 false registeredEntity SIA KBTRANS 2019-04-23 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    
92754 c5147aaf-38bf-4aee-9184-0589a6cb1155 entityStatement 2019-04-23 false registeredEntity SIA DM WL 2019-04-23 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]) 
);