entity_statement

42 rows where "foundingdate" is on date 2011-02-07

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: statementdate, publicationdetails_publicationdate, statementdate (date), foundingdate (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
109679 ebab9bb8-6389-49dc-87ad-57d4e90b8747 entityStatement 2019-07-16 false registeredEntity Sabiedrība ar ierobežotu atbildību "G-Lines" 2011-02-07 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    
27324 35620b8d-5abf-4885-9016-7b9bb383e426 entityStatement 2019-07-27 false registeredEntity Nodibinājums "Vidzemes katoļu jauniešu centrs" 2011-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    
40803 f71d7aff-25d3-4c4d-a9ef-0ced33ecce54 entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "Printeriem.lv" 2011-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    
40804 f03e158b-289f-4873-a6f0-312abd49c5ab entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "Cobert Forest" 2011-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    
40805 8d61f89c-06fd-434d-a17f-f9e759e352fe entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "REFEXPERT" 2011-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    
40806 b86e1669-e660-4f79-940e-0a00aff77140 entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "Concordia LL" 2011-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    
40807 788a1489-9cc8-489c-aba5-07a4ece09073 entityStatement 2018-01-04 false registeredEntity SIA "APRAEL" 2011-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    
40808 f77de262-34d0-4cba-b742-b3699f9f9d5a entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "I.S.K." 2011-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    
40809 5a732986-8f13-4007-863d-02c97e41e3d6 entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "BalticTour" 2011-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    
40810 9677807c-d2ba-4339-864a-a4667f5fb547 entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "N.I.S. Grupa" 2011-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    
40811 876fb77f-17a7-4916-882e-605073b5f96d entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "Loyalty" 2011-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    
40812 66b0544e-34aa-4a92-9dc1-0bc466f9f07a entityStatement 2020-09-01 false registeredEntity SIA "HO Invest" 2011-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    
40813 1c73b676-2909-4b4d-888e-958ecde10ce6 entityStatement 2019-07-11 false registeredEntity SIA "MUTE music" 2011-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    
40814 e86033b5-7c33-4d95-b8c0-f8eceeb97747 entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "ROTOLINE" 2011-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    
40815 61b23935-61ec-47ce-97de-1ba07708eeb3 entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "Forumu serviss" 2011-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    
40816 28e2a6ed-d8e7-4d5a-96ce-b2c1249728a7 entityStatement 2019-07-11 false registeredEntity SIA "Franklin Lakes" 2011-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    
40817 e13a24c6-acce-4dc5-9286-b8993cd184b2 entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "Lili21" 2011-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    
40818 340800d3-f3bd-48d8-85b9-0ccbcbc4f0d3 entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "Māju apkope" 2011-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    
40819 878fc9d2-5c64-406a-95e0-d2e5d00338ed entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "Dabas zirgi" 2011-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    
40820 0c2c087f-ac21-45ba-8046-5d7ba579c63f entityStatement 2019-07-11 false registeredEntity SIA "Metal Market" 2011-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    
40821 ac9276ea-751a-4a88-8023-f444a06fca6f entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "ABerg" 2011-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    
40822 0ad59e57-ee02-4711-a4a3-a9daba7e61f1 entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "EGANN" 2011-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    
40823 2a7359b0-982d-43e5-9083-9eef10538f71 entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "WALKET SERVICE" 2011-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    
40824 04a2bb96-a356-4887-a637-ab6d38d4a8dd entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "RaFinRi" 2011-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    
40825 2af3ab2d-e10e-44e4-bc86-2a5a0278d84e entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "JD Accounting Services" 2011-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    
40826 6e7af68a-45de-4528-9c7e-c1a3ff826170 entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "IRENAEUS" 2011-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    
40827 a3ead4e7-f5e6-401a-ace8-c9b0412fbf96 entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "TK Serviss" 2011-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    
40828 3047abc3-87ec-461a-9f4c-013ef3f9c622 entityStatement 2019-07-11 false registeredEntity SIA "AR Management" 2011-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    
40829 db5f0fac-8665-48c6-9752-488e2161da86 entityStatement 2019-07-11 false registeredEntity SIA "V & P-AUTOSERVISS" 2011-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    
40830 07ac8cc4-3336-4eda-9cb1-190ba707f5ea entityStatement 2019-07-11 false registeredEntity SIA "SIGITA VET" 2011-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    
40831 b8e1b71c-737a-4e46-a477-25b9e35b8d1a entityStatement 2019-07-11 false registeredEntity SIA "LABA KOPIJA" 2011-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    
40832 1bd16e8a-8ade-4e71-b9d2-110fbb610875 entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "Eskona" 2011-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    
40833 81f6f30e-c608-4851-b3a6-b3177de5ecc8 entityStatement 2020-02-04 false registeredEntity Sabiedrība ar ierobežotu atbildību "Florens A" 2011-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    
40834 0ce5858c-b605-4a3f-9073-28fb6d967a45 entityStatement 2019-07-11 false registeredEntity SIA "PATIO" 2011-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    
40835 58ef2179-d8db-49a8-8b8e-4df4d8bb6e25 entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "RINCOM" 2011-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    
40836 caf1c125-ac4b-4be8-86ec-7eab2d131601 entityStatement 2018-12-28 false registeredEntity SIA "BEWE RIX" 2011-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    
40837 3693cca7-2c34-4c70-850b-0f8b8fafcde3 entityStatement 2019-04-23 false registeredEntity Sabiedrība ar ierobežotu atbildību "ANDY HOLDING" 2011-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    
40838 2fb48045-7be0-4653-b37a-331604482565 entityStatement 2019-07-11 false registeredEntity SIA "My Beauty" 2011-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    
40839 4d65e2da-b6ed-49ad-9a7f-ba5a003f9770 entityStatement 2019-07-11 false registeredEntity Pušpure SIA 2011-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    
40840 9f544d65-3633-4b0b-87e2-cedd62f52eb9 entityStatement 2019-07-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "BišuJānis" 2011-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    
95422 9e55e7a9-6098-492a-9f93-b9760c978eec entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Tera Art" 2011-02-07 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    
95423 c00c36eb-1d48-4402-b2a5-8fa1d8414837 entityStatement 2020-09-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "GLADIATORS SECURITY" 2011-02-07 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]) 
);