entity_statement

54 rows where incorporatedinjurisdiction_code = "LV" and "statementdate" is on date 2018-07-23

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: iscomponent, 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
108618 aead099f-f78f-4575-955a-07c511051e68 entityStatement 2018-07-23 false registeredEntity SIA "V & P" 2003-09-05 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    
117968 b5556b96-8ecc-4bd8-9e20-4e202e3a3703 entityStatement 2018-07-23 true registeredEntity SIA "CREATOR CAPITAL PARTNERS"   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    
117969 9776e092-198f-417d-b54e-d101a3839463 entityStatement 2018-07-23 true registeredEntity SIA "AMENIUS INVESTMENTS LIMITED"   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    
118250 32430791-586a-4cae-ac69-c33a3553a44a entityStatement 2018-07-23 true registeredEntity "Noordam Agri Estate" SIA   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    
120819 32ce0389-e93d-4e48-9d47-5adc1035889b entityStatement 2018-07-23 true registeredEntity Akciju sabiedrība "Ieguldījumu projekti"   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    
120820 d7871fca-3ab7-4ca8-948a-c9eb08d46b23 entityStatement 2018-07-23 true registeredEntity SIA "Finanšu restrukturizācijas risinājumi"   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    
120821 805d8486-4264-4ab3-8191-efda730178d2 entityStatement 2018-07-23 true registeredEntity SIA "FRR projekti"   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    
120822 613188cd-5a43-412c-9dda-341f4d93513a entityStatement 2018-07-23 true registeredEntity SIA "Jūras transporta loģistika"   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    
14524 dab3d9aa-1b09-48b7-982d-a2ceb805c48d entityStatement 2018-07-23 false registeredEntity Sabiedrība ar ierobežotu atbildību "VIVAX COMMUNICATIONS GROUP" 2003-06-12 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    
14553 fa2e1995-0e2a-4943-b7f5-822ebfad4ff1 entityStatement 2018-07-23 false registeredEntity Sabiedrība ar ierobežotu atbildību "APARTAMENTS" 2003-06-20 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    
20200 1e65455c-0d53-4968-bca7-54f971456890 entityStatement 2018-07-23 false registeredEntity Sabiedrība ar ierobežotu atbildību "BERKON" 2006-04-04 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    
20360 7ec948d0-85cb-48cf-99d2-24380236ad61 entityStatement 2018-07-23 false registeredEntity Biroja Tehnika, SIA 2006-04-24 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    
21743 a45a7105-e3af-4b06-b723-c4d0730187cc entityStatement 2018-07-23 false registeredEntity SIA "ALMEZ" 2006-10-12 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    
23483 af2bacff-cb54-4632-8cfb-3b3bae464ca8 entityStatement 2018-07-23 false registeredEntity SIA "FinansSoft" 2007-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    
24239 664c1947-3de6-468c-b6eb-d2098cce1181 entityStatement 2018-07-23 false registeredEntity SIA Realto Mallen 2007-07-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    
28775 ae90bd39-be14-45a0-8acb-e3a961aa4add entityStatement 2018-07-23 false registeredEntity "Labākai Pasaulei" 2018-07-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    
28776 76a9ab8e-3344-4b0d-9bc0-6953c8f5d81d entityStatement 2018-07-23 false registeredEntity "Sporta Klubs Cēsu Basketbols" 2018-07-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    
32805 d47ecd5f-1c30-4404-8de7-90c552de3057 entityStatement 2018-07-23 false registeredEntity SIA "CREATOR CAPITAL PARTNERS" 2008-07-10 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    
36547 f51e091e-152b-4ca7-8c1a-5a1383b1f581 entityStatement 2018-07-23 false registeredEntity Sabiedrība ar ierobežotu atbildību "JARVA" 2010-03-02 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    
38369 d108f28a-adcd-4708-9087-a3b77c3bf474 entityStatement 2018-07-23 false registeredEntity Sabiedrība ar ierobežotu atbildību "BP rent a car" 2010-09-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    
39902 682de53c-31bd-40a9-a015-578d8339f962 entityStatement 2018-07-23 false registeredEntity SIA "Double 9" 2010-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    
43426 d841f1dd-b9ad-46f9-b8ff-6d54b5f8e8c0 entityStatement 2018-07-23 false registeredEntity Sabiedrība ar ierobežotu atbildību "Makaj Foundation" 2011-07-05 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    
44424 a7863a3b-0b39-450d-9965-b7eb63dc30ee entityStatement 2018-07-23 false registeredEntity SIA "Akusherstvo.lv" 2011-09-06 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    
47051 248da872-54ef-43cf-8563-f608ae1e9e9d entityStatement 2018-07-23 false registeredEntity "Agri-Properties" SIA 2012-02-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    
50461 e3ccb09b-72df-48e0-be43-b6c4f62c3d1c entityStatement 2018-07-23 false registeredEntity Sabiedrība ar ierobežotu atbildību "ABBI" 2012-09-24 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    
51016 6d192335-c41c-46e4-89fc-221c4f27eee6 entityStatement 2018-07-23 false registeredEntity SIA "GraSan" 2012-10-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    
52243 cfa45487-613d-4c73-9855-e9f131257750 entityStatement 2018-07-23 false registeredEntity SIA "Construction Solutions" 2013-01-21 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    
52576 fc5b9652-ec3c-4eab-bef3-52cf333c6889 entityStatement 2018-07-23 false registeredEntity Sabiedrība ar ierobežotu atbildību "Wood4U" 2013-02-07 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    
52619 1fe3b746-675a-442b-9900-0e54d955bcc1 entityStatement 2018-07-23 false registeredEntity SIA "ANYPIT" 2013-02-11 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    
52788 20a77c1d-b0c9-44ee-87df-127b188f2f33 entityStatement 2018-07-23 false registeredEntity Sabiedrība ar ierobežotu atbildību "SAN WINGS AVIA" 2013-02-19 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    
53960 7d1bcb99-965e-46de-95d2-8a92e013dab8 entityStatement 2018-07-23 false registeredEntity SIA "ATTA print" 2013-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    
5746 85aab8a8-954a-426f-bb8b-86e7c7331654 entityStatement 2018-07-23 false registeredEntity Sabiedrība ar ierobežotu atbildību "VK Mobil" 1994-10-13 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    
60715 604238db-4909-4426-bf92-862eb9442a1e entityStatement 2018-07-23 false registeredEntity Sabiedrība ar ierobežotu atbildību "Melngaiļa autostāvvieta" 2014-06-11 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    
61500 e286eecd-a3da-4b53-9361-02843345b219 entityStatement 2018-07-23 false registeredEntity Sabiedrība ar ierobežotu atbildību "Juridico" 2014-07-31 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    
66627 d0ea4a94-7551-48ec-98d8-73bad4dd7275 entityStatement 2018-07-23 false registeredEntity Sabiedrība ar ierobežotu atbildību "VK Real" 2015-06-03 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    
67952 c1342ee5-110f-49a6-a0ef-75f9537da67f entityStatement 2018-07-23 false registeredEntity Sabiedrība ar ierobežotu atbildību "EURO MINING GROUP" 2015-09-03 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    
69562 1a6397c0-d9fd-4937-b45b-92c505ef4513 entityStatement 2018-07-23 false registeredEntity SIA "KJV 1" 2015-12-14 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    
7725 868210c7-16f1-40fa-9d75-32343094735f entityStatement 2018-07-23 false registeredEntity Sabiedrība ar ierobežotu atbildību "ZAMELSONS" 1997-05-19 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    
77373 a80461b2-b93f-484e-8070-a04debdbdb43 entityStatement 2018-07-23 false registeredEntity Sabiedrība ar ierobežotu atbildību "GENERATION P" 2017-05-19 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    
78994 e9428f94-5935-4f40-819b-2f0a330be453 entityStatement 2018-07-23 false registeredEntity SIA "Hungrila" 2017-09-13 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    
79195 801fde3a-027c-4eea-9540-833edc0af6c5 entityStatement 2018-07-23 false registeredEntity Filco Food and Beverage SIA 2017-09-25 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    
79957 d6456d2c-8ddf-412f-b836-a39f48005141 entityStatement 2018-07-23 false registeredEntity Sabiedrība ar ierobežotu atbildību "DL Fortune" 2017-11-10 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    
84109 aeadcded-f1cb-4a05-b761-f9e19cf02e18 entityStatement 2018-07-23 false registeredEntity SIA "MAZĀ CILTS" 2018-07-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    
84111 7899714a-07de-4fa0-af8e-ab91d34bac96 entityStatement 2018-07-23 false registeredEntity SIA "Green Performance" 2018-07-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    
84112 24babd70-b797-4750-9dc6-930e6c3fab91 entityStatement 2018-07-23 false registeredEntity SIA "F TECH SERVISS" 2018-07-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    
84115 975df778-608d-4e08-b427-1d1368cf42e7 entityStatement 2018-07-23 false registeredEntity Sabiedrība ar ierobežotu atbildību "VARIRAD" 2018-07-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    
84116 d259bd15-7e4d-4f28-a459-a536220af96e entityStatement 2018-07-23 false registeredEntity Sabiedrība ar ierobežotu atbildību "Led Go" 2018-07-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    
84117 3eba975c-0fa1-4096-bef5-2df59e86667a entityStatement 2018-07-23 false registeredEntity SIA "JTL INVEST" 2018-07-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    
84118 f38f3599-84a9-4f64-940d-73aca745ebdf entityStatement 2018-07-23 false registeredEntity SIA "Rotallieta.lv" 2018-07-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    
84120 8c4c279f-56ed-48d7-b59c-debfda185215 entityStatement 2018-07-23 false registeredEntity REACTDESIGN SIA 2018-07-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    
84122 f7faa622-3a05-41ff-964a-84662b75ee8d entityStatement 2018-07-23 false registeredEntity SIA "VAP Company" 2018-07-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    
84123 31bcdc1d-d9aa-455d-9b91-9796264d8afc entityStatement 2018-07-23 false registeredEntity Sabiedrība ar ierobežotu atbildību "Panic Studio" 2018-07-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    
96061 31dfae3c-c64e-4c7b-9ab0-a467fad9e929 entityStatement 2018-07-23 false registeredEntity Sabiedrība ar ierobežotu atbildību "Melnā mamba" 2013-07-10 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    
97205 1f7cd19a-bede-494f-aac5-09ed54795445 entityStatement 2018-07-23 false registeredEntity SIA "MASLINA BALTIC" 2018-07-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]) 
);