entity_statement

35 rows where foundingdate = "2012-04-28" and iscomponent = "false"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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
103958 2d2ec0b0-bba3-4e63-b05e-4d5f3ed71488 entityStatement 2019-07-25 false registeredEntity Dricānu pagasta zemnieka saimniecība "Višņakovi" 2012-04-28 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    
105247 3b31f958-0fa5-43a7-9d05-673c01344471 entityStatement 2019-07-16 false registeredEntity Sabiedrība ar Ierobežotu Atbildību "KOBATA" 2012-04-28 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    
110072 0266d8b6-8183-4058-ab62-0da421c5f011 entityStatement 2019-07-16 false registeredEntity Sabiedrība ar ierobežotu atbildību "DH BALTICS" 2012-04-28 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    
48187 2c4a9a24-972a-4d05-a396-5ae88fae328f entityStatement 2019-05-07 false registeredEntity Sabiedrība ar ierobežotu atbildību "Orange Deal" 2012-04-28 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    
48188 ae389ff2-f9c6-4b70-a0ec-69af48a37e68 entityStatement 2019-07-12 false registeredEntity SIA "Kozimoart" 2012-04-28 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    
48189 1ce15f70-b236-4c2d-bcfa-45ff6b849165 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Poster" 2012-04-28 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    
48190 10b235d9-79c3-4a6d-babb-92cb93b0c7f3 entityStatement 2019-07-12 false registeredEntity SIA "Mark Trading" 2012-04-28 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    
48191 085f4afb-a422-4134-ab6c-c19c635e8ad0 entityStatement 2018-01-30 false registeredEntity Sabiedrība ar ierobežotu atbildību "WARM MONTĀŽA" 2012-04-28 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    
48192 30142bb3-a8e0-4aa5-8f19-165ab4836eac entityStatement 2019-07-12 false registeredEntity Sabiedrība ar ierobežotu atbildību "ADH noma" 2012-04-28 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    
48193 d781efce-3c83-475c-a91e-e38f2520fb31 entityStatement 2019-07-15 false registeredEntity SIA "GEPA" 2012-04-28 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    
48194 b14ad27a-ba00-4449-95da-02c719109721 entityStatement 2020-09-18 false registeredEntity SIA Jūrmala Properties 2012-04-28 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    
48195 a9f7e1a4-19a2-45f1-b39b-70ece2d89a55 entityStatement 2020-12-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "AEG Būve" 2012-04-28 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    
48196 6929c471-4d64-4053-a11d-51e3c59684af entityStatement 2017-12-06 false registeredEntity Sabiedrība ar ierobežotu atbildību "EINOS" 2012-04-28 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    
48197 44ea0978-dec1-440d-81e4-16e742ca56d8 entityStatement 2018-07-26 false registeredEntity Sabiedrība ar ierobežotu atbildību "VĀL B72" 2012-04-28 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    
48198 5c413be9-2879-4908-89ab-e9dd4c5f5d0c entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Kleo K" 2012-04-28 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    
48199 fb528ca9-11c2-4f77-adc7-fb0547f76f40 entityStatement 2019-07-12 false registeredEntity Sabiedrība ar ierobežotu atbildību "Āfrikas idejas" 2012-04-28 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    
48200 b57c0d8e-d6ae-4da0-86c0-a4b615849d1b entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "AT Nami" 2012-04-28 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    
48201 c6c2f0f9-457e-4729-bdc8-118cc0257537 entityStatement 2019-07-15 false registeredEntity SIA "Max box" 2012-04-28 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    
48202 b5ba5a30-690e-4664-9127-25a2fc579855 entityStatement 2019-07-12 false registeredEntity Sabiedrība ar ierobežotu atbildību "Sanity Limit" 2012-04-28 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    
48203 8bf4df71-5845-4337-a55e-333825caafb6 entityStatement 2019-07-15 false registeredEntity SIA "mCloud" 2012-04-28 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    
48204 bfd07188-92de-45d0-8cce-e2332b931a8c entityStatement 2019-07-15 false registeredEntity SIA "ANGELICA" 2012-04-28 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    
48205 4e72965e-4da8-42d5-8b85-f362d5073a94 entityStatement 2020-03-30 false registeredEntity SIA "Roug Inc." 2012-04-28 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    
48206 d644f215-69f6-41db-9939-90f9ee331fb4 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Pultechnics" 2012-04-28 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    
48207 b38c67c3-7104-4008-b0ab-2315c22fce13 entityStatement 2019-07-15 false registeredEntity SIA "Tours shop" 2012-04-28 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    
48208 ac3fd73a-a5dd-42a4-b6ed-87aaa5dd10d4 entityStatement 2019-07-15 false registeredEntity SIA "BIGSA" 2012-04-28 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    
48209 bacb088b-df3c-4596-b8a1-254a4a27516b entityStatement 2019-07-15 false registeredEntity SIA Amandiņa 2012-04-28 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    
48210 e2121109-e8e0-42a3-9c2a-efc5fe426be3 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "AD meritum" 2012-04-28 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    
48211 3f3dcdc1-dd1d-40ac-bed9-53342bbc4cc9 entityStatement 2019-07-15 false registeredEntity SIA "Global Nordic Metals" 2012-04-28 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    
48212 5d3eef13-3794-49ff-b784-9fda9c186df2 entityStatement 2019-07-15 false registeredEntity SIA "Para bellum" 2012-04-28 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    
48213 b7e18c06-b01e-4b67-800c-8919de5b484e entityStatement 2019-07-12 false registeredEntity Sabiedrība ar ierobežotu atbildību "SP Auto" 2012-04-28 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    
48214 986a9a3d-ec57-4a12-98ec-ede85741c0e6 entityStatement 2019-07-12 false registeredEntity Sabiedrība ar ierobežotu atbildību "UMONTAGE" 2012-04-28 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    
48215 2edea2d1-ec89-4094-94f6-d3eee4762ca8 entityStatement 2019-07-12 false registeredEntity Sabiedrība ar ierobežotu atbildību "Green Projects" 2012-04-28 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    
48216 e3095eeb-8da1-4b7c-92e1-6b989948856a entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "BALTIC DIZAINS" 2012-04-28 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    
48217 7492d8a4-db29-478f-82b0-67f597f15251 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "EuroAfro Group" 2012-04-28 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    
782 117e2f39-d297-429d-b9a2-f01055bcf464 entityStatement 2019-07-24 false registeredEntity Jērcēnu pagasta ZS Saulespuķes 2012-04-28 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    

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]) 
);