entity_statement

35 rows where "foundingdate" is on date 2015-08-04 and iscomponent = "false"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: statementdate, publicationdetails_publicationdate, 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
101722 9e797750-8737-431a-8444-379bd04dcdd7 entityStatement 2019-07-16 false registeredEntity SIA "JBTS Rīga" 2015-08-04 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    
105718 660a7d9b-54bb-4217-a244-dca31013b69c entityStatement 2019-07-16 false registeredEntity Sabiedrība ar ierobežotu atbildību "Mācību centrs "FORMULA"" 2015-08-04 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    
27906 3cf5fbb2-5135-46a8-a0a9-320d8004ee2e entityStatement 2019-07-27 false registeredEntity VALENTĪNA PIKUĻA FONDS 2015-08-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    
67443 b1191aa1-c515-4e90-ba6f-b7cf720d1b67 entityStatement 2019-02-21 false registeredEntity Sabiedrība ar ierobežotu atbildību "SADOVŅIKOVA MĀJA" 2015-08-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    
67444 785c3d07-73f9-4b28-a253-ddda4b8f4135 entityStatement 2018-11-23 false registeredEntity Sabiedrība ar ierobežotu atbildību "ART COOK" 2015-08-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    
67445 1c1a4810-ef12-4ed2-a33d-0d3758af7268 entityStatement 2018-11-22 false registeredEntity Sabiedrība ar ierobežotu atbildību "EGO ART" 2015-08-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    
67446 91dec74d-f1ea-416a-89ec-9d6517df666e entityStatement 2018-03-09 false registeredEntity Sabiedrība ar ierobežotu atbildību "Kolmer Holding" 2015-08-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    
67447 2ca69c84-fbb4-4852-b50b-eb4516800723 entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "IG Corporation" 2015-08-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    
67448 07b381ea-a0b8-48f2-9c63-2263b921b049 entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "WOOD INTELLIGENCE" 2015-08-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    
67449 72083582-fd28-40ab-beec-63fe693a51d6 entityStatement 2019-07-15 false registeredEntity SIA "Varenne" 2015-08-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    
67450 0b319cf9-1d9f-4e37-b7e2-ade1ca9f9aba entityStatement 2018-01-03 false registeredEntity Sabiedrība ar ierobežotu atbildību "FUGU GROUP" 2015-08-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    
67451 e9b340d2-f6c9-44f4-b06f-95103cebe902 entityStatement 2019-07-15 false registeredEntity SIA "ZG 20" 2015-08-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    
67452 36f7f5f2-3019-4379-835a-4bb89e7cb6fa entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "IS Pro Moto" 2015-08-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    
67453 8290890b-5c53-4ff2-9d32-acbfaecbe8e3 entityStatement 2019-01-03 false registeredEntity SIA "REKOLTA" 2015-08-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    
67454 6a44554d-6362-4ce0-ad4a-5f50d586ed46 entityStatement 2019-07-15 false registeredEntity SIA "WoodHaus" 2015-08-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    
67455 497e6fa9-f16d-4fd0-ad63-a2f50f151b27 entityStatement 2020-12-14 false registeredEntity SIA "DELTRA" 2015-08-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    
67456 f89a0517-55b6-415f-9e37-ae68da63c9a4 entityStatement 2020-12-28 false registeredEntity Aitkopības sistēmas 20 SIA 2015-08-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    
67457 56f469fc-a43d-4557-a3ab-175a2b960dff entityStatement 2019-07-14 false registeredEntity SIA D.N.F SOCIETY 2015-08-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    
67458 e6c4d71c-a882-4852-b403-e99f0e7cbdf3 entityStatement 2019-07-15 false registeredEntity SIA "Monteriks" 2015-08-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    
67459 a6cbe2ea-d456-43f5-ba3f-478f0a52b3a3 entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "Imperial garden" 2015-08-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    
67460 7a0abdd4-e878-4452-a6c5-bb7ffc57fb16 entityStatement 2018-02-23 false registeredEntity SIA "BALTIC MARINE SERVICES" 2015-08-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    
67461 ab72f2f3-f1d0-4e3b-bc52-34cea9bc6f6a entityStatement 2018-05-14 false registeredEntity SIA "SORALLE" 2015-08-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    
67462 c02bfea0-894e-4886-a4f1-f6bf3dc2b29c entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "CAD MASTER" 2015-08-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    
67463 0efd454d-8bf8-49df-9bbc-da899e1b230d entityStatement 2019-07-15 false registeredEntity "LĀČU 16" SIA 2015-08-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    
67464 3fbe04b5-6b29-431e-ac4f-77bd4875a89e entityStatement 2018-10-22 false registeredEntity SIA SPORTO 2015-08-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    
67465 c7992c61-475d-4b81-ab76-3dd55959b686 entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "Autovieta Grupa" 2015-08-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    
67466 c7360fa4-b251-4040-9693-5f494f4f112e entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "Klemadela" 2015-08-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    
67467 8c3f8d4a-44c9-48d7-8451-0fe0dd002794 entityStatement 2019-07-15 false registeredEntity SIA "Event Mafia" 2015-08-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    
67468 5ee5f9a0-0ef8-451b-9c80-2852e6dd2c0a entityStatement 2018-10-09 false registeredEntity Sabiedrība ar ierobežotu atbildību "DUS P5" 2015-08-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    
67469 9933ccae-1f61-4466-84f7-dd34e169f347 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Transpo" 2015-08-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    
67470 edc8b692-2d5d-4753-8984-0f05af0fbcb3 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "ORE" 2015-08-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    
67471 8a85e9c4-ab02-4ae5-bd98-7caa9f3612cf entityStatement 2019-07-15 false registeredEntity SIA "CITYCARE" 2015-08-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    
67472 b77f53be-4454-41c0-ac18-f48ccf2fe470 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Mūsu draugiem" 2015-08-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    
67473 62204f72-0e48-4134-a1a5-e3252c431315 entityStatement 2019-02-25 false registeredEntity Tax Expert SIA 2015-08-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    
96498 f210aab6-e32f-4f8c-a297-65b4022d0da8 entityStatement 2020-04-21 false registeredEntity SIA "CS Apkope" 2015-08-04 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]) 
);