entity_statement

46 rows where foundingdate = "2018-01-18" 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
102338 41bc0a96-648c-4d21-866b-df8e41279a08 entityStatement 2020-04-17 false registeredEntity SIA "MĀJAS GARDUMS" 2018-01-18 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    
111837 eebf8789-83cb-4697-9f43-d74053c6374c entityStatement 2018-01-18 false registeredEntity SIA Parkes 2018-01-18 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    
111838 a0e5f831-b2d8-4bee-84dd-aa44d8456f39 entityStatement 2018-01-18 false registeredEntity SIA "AKADEMIA" 2018-01-18 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    
28252 15f3cb10-9f97-475f-a872-6175b3e0dce4 entityStatement 2018-01-18 false registeredEntity "GDG Daugavpils" 2018-01-18 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    
28253 6e74ed53-906b-4802-a62f-70b9a36ac042 entityStatement 2018-01-18 false registeredEntity "Svētgrīvas" 2018-01-18 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    
28254 87dd99ea-15d9-45d7-a927-bec20057d618 entityStatement 2018-01-18 false registeredEntity "ABI EXHIBITION" 2018-01-18 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    
28255 2ee13f40-377a-48f2-ba91-edf21a91c257 entityStatement 2018-01-18 false registeredEntity "MS sports" 2018-01-18 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    
28256 e05b0607-2172-48d4-ad88-b6055e74994e entityStatement   false registeredEntity Garnizona 9 dzīvokļu īpašnieku biedrība 2018-01-18 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    
28257 d7c41803-f35a-4b31-b2db-2ad233b4a25b entityStatement 2018-01-18 false registeredEntity Nodibinājums Make Room Europe 2018-01-18 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    
28258 5756186b-3db8-46a2-972b-da7b28b113d2 entityStatement   false registeredEntity "eKonsultants" 2018-01-18 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    
81025 743a48b3-e990-4e17-a7bd-6093acb7559f entityStatement 2018-01-18 false registeredEntity SIA STROM-LV 2018-01-18 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    
81026 ac5da630-86b1-42ad-96a4-0d25f77abdb1 entityStatement 2018-01-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "Ziemeļu akcents" 2018-01-18 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    
81027 fea80bad-370f-42ed-a6ab-ffbadddd4dea entityStatement 2018-01-18 false registeredEntity SIA Inner X 2018-01-18 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    
81028 5acdfb99-e27b-4bec-9614-ef53995461f6 entityStatement 2018-06-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "MetForce" 2018-01-18 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    
81029 fe92b8b7-ae87-491d-80f7-ebd2a4e36bed entityStatement 2019-06-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "MAGINVEST" 2018-01-18 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    
81030 1482ff48-6c1c-442e-a4e0-ae3c1ed1f223 entityStatement 2020-01-09 false registeredEntity Amber Hostel SIA 2018-01-18 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    
81031 5c1fd141-c864-45fe-9a1a-8b5d47c92d2d entityStatement 2018-01-18 false registeredEntity SIA "SAMR" 2018-01-18 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    
81032 77d55720-95b2-46da-bd14-29a07cc28c5b entityStatement 2018-01-18 false registeredEntity SIA ONAIP 2018-01-18 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    
81033 40c5db4e-d352-4c6e-8c59-4765abe9920d entityStatement 2018-01-18 false registeredEntity SIA "TELEGREEN" 2018-01-18 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    
81034 401eb5a9-9e10-4969-bc92-8d5090874cdf entityStatement 2018-01-18 false registeredEntity SIA "Cube Moto" 2018-01-18 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    
81035 126024dd-5376-48ad-bc28-c05b836ede80 entityStatement 2020-04-07 false registeredEntity SIA "ALGORITM" 2018-01-18 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    
81036 f1c19cf8-b073-4cf1-bfb5-ddf8401bd771 entityStatement 2018-01-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "Bamberg" 2018-01-18 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    
81037 1f5d32cc-c53f-4694-b1df-b677d8296dd5 entityStatement 2018-01-18 false registeredEntity SIA Daina Med 2018-01-18 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    
81038 de914ab7-db01-4a2d-97f4-6bdede5d1956 entityStatement 2018-01-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "Orange consult" 2018-01-18 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    
81039 d0439a76-7b3f-4d49-80c4-851ec01c11d0 entityStatement 2018-01-18 false registeredEntity SIA "Bean Bag Latvia" 2018-01-18 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    
81040 fb83b43f-0833-4866-a42a-d2a51019d363 entityStatement 2018-01-18 false registeredEntity "T-ŠANS" SIA 2018-01-18 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    
81041 20131022-5c8b-43b5-be87-1c331c83cc72 entityStatement 2018-06-27 false registeredEntity Sabiedrība ar ierobežotu atbildību "E.G. Services" 2018-01-18 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    
81042 a35c4d95-cc03-4db0-b238-f5b542995b56 entityStatement 2018-01-18 false registeredEntity SIA "Raccoon & Co" 2018-01-18 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    
81043 e15af5a3-74d1-4be3-9cb2-9d84809c6833 entityStatement 2020-12-28 false registeredEntity UAB "DOJUS rental" Latvijas filiāle 2018-01-18 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    
81044 d11e94f3-09fa-44aa-86e1-cc45f54e158b entityStatement 2018-01-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "Trust yourself" 2018-01-18 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    
81045 d54c8a8d-ac39-40e9-86e7-39c803e56d23 entityStatement 2018-01-18 false registeredEntity Primalat, SIA 2018-01-18 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    
81046 352cbda9-054b-4069-8cb0-d3e561c8c6e2 entityStatement 2018-01-18 false registeredEntity SIA "Jutas Ošenieces ģimenes ārsta prakse" 2018-01-18 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    
81047 f879f439-d6ba-4846-be65-c72af6ff7979 entityStatement 2018-02-21 false registeredEntity Sabiedrība ar ierobežotu atbildību "CODE-ICE" 2018-01-18 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    
81048 b5facae2-19e3-4323-a00d-f64e78b53364 entityStatement 2020-09-25 false registeredEntity Sabiedrība ar ierobežotu atbildību "SMACK" 2018-01-18 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    
81049 cc6c3dc0-2033-4012-b793-1c66ae1312b2 entityStatement 2019-09-27 false registeredEntity "Alojas Biroji" SIA 2018-01-18 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    
81050 4acc72a6-8b24-4d6e-8a45-ca475beb11b1 entityStatement 2018-01-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "iWeekender Europe" 2018-01-18 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    
81051 39f7a6c9-4ace-4575-9efa-924ada552886 entityStatement 2018-01-18 false registeredEntity SIA "Tisara" 2018-01-18 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    
81052 8024b69a-7cb7-4e05-8d18-d262f7284e68 entityStatement 2019-12-02 false registeredEntity SIA "Assist Deal Solution ltd" 2018-01-18 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    
81053 2636b549-0765-4f98-af7a-ab6d02facf75 entityStatement 2018-01-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "Happening" 2018-01-18 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    
81054 9b07bbdf-8c65-4a64-8acb-749d3e97bdd5 entityStatement 2018-01-18 false registeredEntity SIA "Lumenu Centrs" 2018-01-18 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    
81055 8cb45c62-8d74-4b32-be3f-b67b57516643 entityStatement 2018-01-18 false registeredEntity Future Decision SIA 2018-01-18 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    
81056 1ad35d90-b8e7-4d79-9bf5-167fa8367add entityStatement 2019-03-21 false registeredEntity Sabiedrība ar ierobežotu atbildību "AMBITION TECHNOLOGICAL SOLUTIONS" 2018-01-18 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    
92366 0521e832-a711-4297-8fca-b5acc243ce66 entityStatement 2018-01-18 false registeredEntity SIA Simson Solutions 2018-01-18 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    
97034 dff7f0ee-930b-4122-9ce1-723183991ab6 entityStatement 2018-01-18 false registeredEntity SIA Vetements 2018-01-18 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    
97035 6adcc767-2499-4df7-8a71-921c762607c4 entityStatement 2018-01-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "Auto D-pils" 2018-01-18 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    
97036 4f9b8773-7e20-4871-86c0-1774839cf845 entityStatement 2018-01-18 false registeredEntity SIA "Latkar-sis" 2018-01-18 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]) 
);