entity_statement

34 rows where foundingdate = "2014-08-08" and iscomponent = "false"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: statementdate, statementdate (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
101478 e28fd751-0359-4acd-81af-f964e5242294 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Meža Dinamika" 2014-08-08 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    
110772 17fabc47-e95e-4419-9cef-5d876cf4d32f entityStatement 2019-07-16 false registeredEntity Sabiedrība ar ierobežotu atbildību "MONRO reklāma" 2014-08-08 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    
110773 20e229d0-7c31-4382-a7ff-c9cc76711817 entityStatement 2019-07-16 false registeredEntity Sabiedrība ar ierobežotu atbildību "Ozovet" 2014-08-08 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    
110774 e9a2268d-e02a-40b7-a83f-27005270feff entityStatement 2018-06-19 false registeredEntity Sabiedrība ar ierobežotu atbildību "Easy Pack" 2014-08-08 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    
61618 c9d63d78-74f2-4082-b094-11cfebbefc48 entityStatement 2019-07-15 false registeredEntity SIA "Viens labs projekts" 2014-08-08 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    
61619 c98c84c9-0572-4f97-977a-8ddd665ae2fd entityStatement 2020-10-23 false registeredEntity SIA "JOVIEN" 2014-08-08 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    
61620 3e5fbcdc-51b5-4099-a0df-5b8124f843b9 entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "Koka meistardarbnīca" 2014-08-08 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    
61621 2ef2ddb7-529b-477d-a219-1435734658f1 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "ET media" 2014-08-08 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    
61622 c90bc1f5-18f7-4704-af36-7ffd0fd8a7eb entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Gustavs mēbeles" 2014-08-08 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    
61623 63152942-9773-46df-b093-7873f591c25e entityStatement 2019-07-14 false registeredEntity SIA "LeoneLL" 2014-08-08 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    
61624 ccf51c8d-070f-4194-9c31-49eeca008ba3 entityStatement 2018-06-28 false registeredEntity SIA "Assistance & Logistics Management" 2014-08-08 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    
61625 5615810c-e3b6-4a69-a262-9419c7e56ae3 entityStatement 2019-07-15 false registeredEntity SIA "Telpu remontdarbu kompānija MASKA" 2014-08-08 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    
61626 d1559f06-5902-45c8-afea-d171c96af438 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Lutini" 2014-08-08 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    
61627 1e1b4fc2-fd4a-4e94-ba56-08e85cb57b94 entityStatement 2018-04-26 false registeredEntity Sabiedrība ar ierobežotu atbildību "Arsenal Industrial" 2014-08-08 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    
61628 698eabbb-0eda-4f11-af0f-34decb9948b1 entityStatement 2018-01-16 false registeredEntity SIA "MARET" 2014-08-08 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    
61629 6200094e-ad9f-4790-a940-9e09e4bbfa4a entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "Business process outsourcing" 2014-08-08 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    
61630 f479fb6d-e640-41e1-b330-45148ec65514 entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "Aperture" 2014-08-08 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    
61631 8a3134dd-d46e-49bb-9396-a6e505a4103a entityStatement 2020-09-01 false registeredEntity Sabiedrība ar ierobežotu atbildību "TOPSQUARE" 2014-08-08 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    
61632 68bce2a9-8799-4125-a21d-92c823161236 entityStatement 2019-07-15 false registeredEntity SIA "Harmonijas studija" 2014-08-08 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    
61633 fe2e9490-bffb-408b-b38a-46d8c5f27224 entityStatement 2019-02-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Ķikuts Co" 2014-08-08 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    
61634 a60dedfa-e48a-4721-b1f3-49e5f434e35f entityStatement 2020-07-02 false registeredEntity Sabiedrība ar ierobežotu atbildību TEMIDIA 2014-08-08 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    
61635 8e8fba39-83c3-4dae-822f-b058f926bc43 entityStatement 2017-12-20 false registeredEntity Sabiedrība ar ierobežotu atbildību "EXCELLENTE AUTO" 2014-08-08 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    
61636 37fbcebd-928c-466a-a05a-00391c2a599d entityStatement 2018-01-26 false registeredEntity SIA Fat Pumpkin 2014-08-08 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    
61637 7364299f-b3ae-4931-afcf-546a2638379d entityStatement 2019-07-15 false registeredEntity SIA "JUMP SOUND" 2014-08-08 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    
61638 2cbe5ab1-e92b-4318-b63f-508cbfa23a6a entityStatement 2019-07-15 false registeredEntity SIA "KATEKS" 2014-08-08 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    
61639 4e55bc40-261a-42f6-bc19-21c00d6696b5 entityStatement 2018-04-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "Vēju 7" 2014-08-08 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    
61640 08557745-a246-4ee1-ac8c-963a6f35c0b0 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Silber rose" 2014-08-08 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    
61641 6f647a74-c3c1-4824-be21-7e13bb2199b1 entityStatement 2019-07-14 false registeredEntity SIA "Ripo Labi" 2014-08-08 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    
61642 af90bb81-5207-46d9-ad4e-b3049b85a49e entityStatement 2018-08-08 false registeredEntity Sabiedrība ar ierobežotu atbildību "GVARDS APSARDZE" 2014-08-08 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    
61643 b57f8342-169b-476d-bb1f-1fd522439ba3 entityStatement 2018-08-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "Asaru 57" 2014-08-08 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    
61644 919abb51-f1f3-4ae6-8e4b-9f5422028cdf entityStatement 2018-04-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "Asaru 59" 2014-08-08 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    
61645 22410897-d2a5-4905-895e-d94f3faed92f entityStatement 2019-07-14 false registeredEntity SIA "kafijatev.lv" 2014-08-08 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    
91655 f3c02c16-04d0-4370-ad5b-241c26c73d60 entityStatement 2019-07-14 false registeredEntity SIA "Kusman 14" 2014-08-08 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    
96278 c7b7d564-b67c-470e-a5d0-4a6d97bf0775 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "PILGRIM TI-MAC" 2014-08-08 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]) 
);