entity_statement

35 rows where "foundingdate" is on date 2015-03-26, incorporatedinjurisdiction_name = "Latvia" and iscomponent = "false"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: statementdate, publicationdetails_publicationdate, statementdate (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
101634 bfe16c34-20d8-4fdb-9133-26c42aa0c998 entityStatement 2019-07-15 false registeredEntity SIA Contrario Agro 2015-03-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    
101635 667b8af6-90a2-4f97-b5ef-1e43c07cfb35 entityStatement 2019-07-15 false registeredEntity SIA "Rozes TM" 2015-03-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    
101636 1864b5a8-3725-4b4d-b5d8-73d5bba309f6 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Deimingi" 2015-03-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    
101637 54bac944-80ce-406f-a521-2fdab33e877e entityStatement 2019-07-15 false registeredEntity SIA "Eastern Sun Bazaar" 2015-03-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    
103999 3f984181-9133-47d4-bd94-d2bbfc712bc5 entityStatement 2019-07-25 false registeredEntity Čornajas pagasta zemnieku saimniecība "STRAUJUPĪTE" 2015-03-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    
27853 031b8178-abe0-4ba6-92e9-a15a511e7866 entityStatement 2020-09-01 false registeredEntity "Būvniecības fonds" 2015-03-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    
65465 c8015024-4b22-48c2-a71f-ed2f8b949c12 entityStatement   false registeredEntity SIA Gunpro 2015-03-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    
65466 b85f1a94-1ad7-42d1-b218-cf3e8bffbc17 entityStatement 2019-11-04 false registeredEntity SIA "Jaunais kapitāls" 2015-03-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    
65467 07388ec9-c3cf-48c7-89c5-f8e3858c4096 entityStatement 2020-10-30 false registeredEntity SIA "Building Foils Center" 2015-03-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    
65468 74a85bed-af53-4fd1-9f72-6c12c4388367 entityStatement 2019-07-14 false registeredEntity SIA "GANGWAN" 2015-03-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    
65469 4844fdb2-2a2b-4fb7-9996-46f1877ff361 entityStatement 2019-07-15 false registeredEntity SIA "TBK GLOBAL INFORMATION SYSTEMS" 2015-03-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    
65470 66e6c70c-9e51-4e70-bf19-37e2cd22fc72 entityStatement 2019-07-15 false registeredEntity SIA E.P.A Service 2015-03-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    
65471 56cec390-3d83-47eb-9825-30ebec91f6dc entityStatement 2019-07-15 false registeredEntity SIA "RDN SERVISS" 2015-03-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    
65472 15a3df15-37f1-4400-bc19-1a14bfaa9e27 entityStatement 2019-07-14 false registeredEntity SIA "1 Print" 2015-03-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    
65473 12ad7495-9236-4b6d-b20a-10fc079c0495 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Ringus Māja" 2015-03-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    
65474 26208b36-20d4-42e4-9e8b-77a60d8f8e9e entityStatement 2019-07-15 false registeredEntity SIA "ALMOIS" 2015-03-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    
65475 0013df50-5235-495b-b70f-d50ff1bd19c1 entityStatement 2019-09-04 false registeredEntity Sabiedrība ar ierobežotu atbildību "Kurzemes meliorācija" 2015-03-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    
65476 dc9c70cb-c46f-4248-a413-b2ad64e28a24 entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "LansiMed" 2015-03-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    
65477 01a1c152-7e55-4fbc-b073-8d340004d6b4 entityStatement 2019-07-15 false registeredEntity SIA "GGM pakalpojumi" 2015-03-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    
65478 c3b6d648-ae10-40cc-8705-00d4a3185ce8 entityStatement 2019-07-14 false registeredEntity SIA "Carpenter" 2015-03-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    
65479 52974342-410c-4046-b720-6bd7bbab0f7c entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "Spriedze" 2015-03-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    
65480 ab266751-b938-4f0c-a8e7-612a860f16b6 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "LAKIS JR" 2015-03-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    
65481 d3494622-86dc-482f-9bc0-7bb7c5bca15f entityStatement 2019-04-18 false registeredEntity ALTEJA LV SIA 2015-03-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    
65482 a93b7abc-d79a-4dcf-8b5a-eb1dec0b819a entityStatement 2019-07-14 false registeredEntity SIA "INTERNATIONAL SHOW PRODUCTION" 2015-03-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    
65483 219a7859-7a02-4a17-830e-9eea4a74d90c entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Like" 2015-03-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    
65484 f384ddc2-3213-413e-a550-719f3ba86533 entityStatement 2019-07-14 false registeredEntity SIA "Kolibri & R" 2015-03-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    
65485 7fc533a7-380c-42b3-bcaf-a78c1922191b entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "Araisis" 2015-03-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    
65486 be6f7a25-c974-4149-948e-3098430a6879 entityStatement 2019-07-15 false registeredEntity SIA "Landmesser" 2015-03-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    
65487 76e4e79c-b9c3-4535-8449-9c078cdd4e3c entityStatement 2019-07-14 false registeredEntity SIA "Daster" 2015-03-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    
65488 1aa3d9f3-b419-45ba-8b70-8fc42cc9a3a1 entityStatement 2018-04-24 false registeredEntity SIA "COUNTRY HELI" 2015-03-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    
65489 55841745-0dce-42dc-9001-6120df25aaba entityStatement 2019-07-15 false registeredEntity SIA "Battle Arena Underground" 2015-03-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    
65490 7788ea74-e58b-4c1d-8097-7ff6c561e5a7 entityStatement 2020-10-06 false registeredEntity Sabiedrība ar ierobežotu atbildību "Tukāni" 2015-03-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    
65491 46cc4596-df6a-4106-9d47-b3b07e8504d2 entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "Quick Clean" 2015-03-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    
65492 b6a43e1f-7841-42e6-af67-51d88b2eb61f entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "BARAVAS" 2015-03-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    
96427 0b37f23f-e78e-4dbc-819a-a525d0956d18 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Fire Show studio" 2015-03-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]) 
);