entity_statement

39 rows where foundingdate = "2012-12-17", incorporatedinjurisdiction_name = "Latvia" and iscomponent = "false"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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
101065 8c2cb778-1c98-4417-8f88-f4ac22f2995b entityStatement 2018-06-26 false registeredEntity Sabiedrība ar ierobežotu atbildību "ArchiJazz" 2012-12-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    
110255 1af54107-1948-4223-add1-87f8eefde7e4 entityStatement 2019-07-16 false registeredEntity Sabiedrība ar ierobežotu atbildību "Buduars.lv" 2012-12-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    
51791 2d187b59-85e1-45e0-8450-a9cc25767c76 entityStatement 2019-07-15 false registeredEntity SIA "DORADO GROUP" 2012-12-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    
51792 fb8e24a2-148a-4f48-92b5-a81307e576bd entityStatement 2019-07-13 false registeredEntity SIA MS Loģistika 2012-12-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    
51793 3a415c6c-52ab-4f63-b463-93d1007c7e21 entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "LILASTE.COM" 2012-12-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    
51794 94121a73-d2ff-41a8-a81c-486d59cf87e0 entityStatement 2019-07-15 false registeredEntity SIA "RRR holdings" 2012-12-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    
51795 f2504379-0b81-495d-85a9-425dbe2a5262 entityStatement 2019-07-15 false registeredEntity SIA "Industriālais alpīnisms" 2012-12-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    
51796 3b209baa-d553-49de-8f49-5f4faca22a14 entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "Balt Cargo Solutions" 2012-12-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    
51797 50f1fa78-3483-40e5-90b8-76107a2f3f61 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Lingua Consulting" 2012-12-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    
51798 f87fc725-1323-469e-93f1-14796c5135ff entityStatement 2018-10-02 false registeredEntity SIA "Salmaja" 2012-12-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    
51799 3eeeda89-3c1e-4c45-bd1b-f613d13e5f0a entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "Baltic Defence Club" 2012-12-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    
51800 add570cd-7145-4934-9e38-de82d25b4671 entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "Agosto" 2012-12-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    
51801 88b16bb2-e994-4b24-babb-3f585d2106cf entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "4Link" 2012-12-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    
51802 77cf32b3-190e-4691-b34d-eb2c18158d02 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "JR Auto" 2012-12-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    
51803 beb982e6-f4cf-450a-b0fe-a38fc1573b60 entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "BAL ROOF" 2012-12-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    
51804 36f2155d-0d74-4c27-9c5f-a34425eb9631 entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "Kārlis Olivers" 2012-12-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    
51805 a8881454-fb38-4360-b397-7def8cf70167 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "PMC" 2012-12-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    
51806 c0e4a70e-5956-44ca-844b-237dc6ef331f entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "BrīvBrīdis.lv" 2012-12-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    
51807 96f2a434-31ec-4580-9438-a8f976a78836 entityStatement 2018-05-16 false registeredEntity SIA "LMIKO" 2012-12-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    
51808 ecea0d30-cdc8-4506-bc93-9c47e8e394e2 entityStatement   false registeredEntity Sabiedrība ar ierobežotu atbildību "HD Forest Holding" 2012-12-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    
51809 8fff1a2a-68aa-4a70-9c26-7ee3559590c2 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Windlux" 2012-12-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    
51810 479817db-39d8-4d75-8a56-732d8fd6c4f8 entityStatement 2018-04-04 false registeredEntity Sabiedrība ar ierobežotu atbildību MOLTOM 2012-12-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    
51811 08bf9a86-3421-4ab6-95d8-77343725b69c entityStatement 2018-07-24 false registeredEntity SIA "ALTERMED" 2012-12-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    
51812 ec745ada-98df-4810-8051-72fc9289bbdd entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "GK-Consulting" 2012-12-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    
51813 7b1070cc-a23c-4c23-a28e-c4880137187a entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "AR & AR" 2012-12-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    
51814 52bda5ab-79a6-4c92-bd57-ee9514880e3e entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "ClimEco" 2012-12-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    
51815 59fab1d4-e440-436e-8c0b-716cda5a7c9a entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "My bathroom" 2012-12-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    
51816 ac5c3af5-f1d4-4c97-846d-9b5af8b0e8fc entityStatement 2018-11-02 false registeredEntity Sabiedrība ar ierobežotu atbildību "LUXURY MARINE DEVELOPMENTS" 2012-12-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    
51817 13bb5441-8991-437d-9936-89f2ec0fbad7 entityStatement 2019-05-17 false registeredEntity Sabiedrība ar ierobežotu atbildību "AGROS S" 2012-12-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    
51818 1717834c-38f0-4743-8bc5-73d7d8880bd6 entityStatement 2019-10-18 false registeredEntity SIA "LEXIA" 2012-12-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    
51819 44c2c036-6907-4fce-9657-75bae74119e1 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Auto Statuss 7" 2012-12-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    
51820 1a957d89-c02d-456e-aee4-610f2b16bb35 entityStatement 2018-03-02 false registeredEntity Sabiedrība ar ierobežotu atbildību "Tradebacking.com" 2012-12-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    
51821 d3b17198-ba55-4170-8cba-11410124e570 entityStatement 2019-07-13 false registeredEntity SIA "Autoparku Remonta Centrs" 2012-12-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    
51822 c37d6691-fe6d-4128-893f-9496d70fbcaa entityStatement 2018-04-09 false registeredEntity SIA IMGS-Marine Consultants 2012-12-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    
91260 3b899c21-9bdc-45cf-a65a-9afe3a0754fe entityStatement 2019-07-15 false registeredEntity SIA "Bāliņi IMTK" 2012-12-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    
95919 503c833b-41c3-4cb8-8860-baff00f5a8b1 entityStatement 2019-03-28 false registeredEntity Sabiedrība ar ierobežotu atbildību "BALTIJAS NOLIKTAVU SERVISS" 2012-12-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    
95920 ba455252-f38e-4e8f-a76e-5903a498ee2d entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "GEZ" 2012-12-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    
95921 1d9a9368-c993-47fc-bca2-78aff0f4ba23 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "NL BAUDA" 2012-12-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    
95922 b6e82bfd-8a79-4a92-a02a-ebbe464e4453 entityStatement 2018-11-27 false registeredEntity SIA "RIAR15" 2012-12-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]) 
);