entity_statement

36 rows where "foundingdate" is on date 2019-02-19

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: statementdate, 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
102964 df7e38cd-e6e8-4031-a224-b3cfc3e04f9d entityStatement 2019-02-19 false registeredEntity SIA "AQUATORIA.LV" 2019-02-19 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    
102965 afac6b7e-9c89-4f0d-8887-0d98b3478d9e entityStatement 2019-02-19 false registeredEntity Sabiedrība ar ierobežotu atbildību "CODULAT" 2019-02-19 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    
102966 04f4f47a-a85b-4993-aa91-213243314c0d entityStatement 2019-02-19 false registeredEntity Egle 21 SIA 2019-02-19 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    
102967 dfd3885e-c21d-40fa-9822-615b30f4911e entityStatement 2019-02-19 false registeredEntity Sabiedrība ar ierobežotu atbildību PERIODENT PLUS 2019-02-19 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    
102968 9694752d-bcee-441b-80b8-2d4b4d2e6339 entityStatement 2019-02-19 false registeredEntity SIA MJ 2019-02-19 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    
102969 9f09a922-9880-4379-b2c8-3caa3ac62434 entityStatement 2019-02-19 false registeredEntity Sabiedrība ar ierobežotu atbildību "Laiksservis" 2019-02-19 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    
102970 971133c0-baf2-4840-aa02-55e7562ec5dd entityStatement 2019-02-19 false registeredEntity SIA "Greenhouse - īpašumu apsaimniekošana" 2019-02-19 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    
102971 46977d3d-e15a-4454-a2ac-d656548defda entityStatement 2019-02-19 false registeredEntity SIA Nordic Woodeco 2019-02-19 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    
102972 ff209f40-9e5e-48c3-8264-c25b5c6a8bf6 entityStatement 2019-02-19 false registeredEntity Tsay Shen Kapitāls SIA 2019-02-19 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    
102973 bf15b737-6454-4a35-b0f6-d23874119739 entityStatement 2019-02-19 false registeredEntity SIA Do Design Print 2019-02-19 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    
112331 d64f9ecd-9d76-4a40-83a5-5430247e0a69 entityStatement 2019-02-19 false registeredEntity Sabiedrība ar ierobežotu atbildību "Dizaina Guru" 2019-02-19 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    
29333 f47f289a-f446-4cca-89d0-b37a5a9a9324 entityStatement   false registeredEntity Pasaciņa 2019-02-19 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    
29334 057a2147-ab38-42fe-a3c1-abbf63721afb entityStatement 2019-02-19 false registeredEntity Biedrība "Ozola basketbola skola" 2019-02-19 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    
29335 ea73d588-fe0a-4654-bd63-13b4a4388be1 entityStatement   false registeredEntity "Latvijai un Vecumniekiem" 2019-02-19 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    
29336 543abedd-9933-4c49-b242-a1e3af36e385 entityStatement   false registeredEntity "Sporta klubs METĒJI" 2019-02-19 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    
87412 281e4d6f-1802-4a7d-9d1d-02049d75540d entityStatement 2020-03-31 false registeredEntity Sabiedrība ar ierobežotu atbildību "CPB" 2019-02-19 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    
87413 9d08a954-af02-4258-a743-cfeacaf546e5 entityStatement 2019-02-19 false registeredEntity SIA "Sanamaks" 2019-02-19 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    
87414 75441963-1d0b-4e45-b8d3-4650227cb9fa entityStatement 2019-02-19 false registeredEntity SIA "Tavas Brilles" 2019-02-19 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    
87415 95680167-c2ce-4891-a457-9d3d905ee56e entityStatement 2019-02-19 false registeredEntity SIA SD Project 2019-02-19 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    
87417 e6276253-68d3-4ddd-8120-e723930dfb8d entityStatement 2019-02-19 false registeredEntity SIA "Factris LV1" 2019-02-19 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    
87418 993ccac9-9cae-4262-91b0-3522f4d75c96 entityStatement 2019-02-19 false registeredEntity SIA Motoguru 2019-02-19 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    
87419 bd778753-e43d-441d-8dba-9d778983f045 entityStatement 2020-02-27 false registeredEntity SIA "Alisa-P" 2019-02-19 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    
87420 7fae99a9-c3d7-4f6f-a2fd-9e4c752726fb entityStatement 2020-07-17 false registeredEntity SIA Toys Store 2019-02-19 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    
87421 5ff9fc71-8b1d-4af4-9bd3-ee0fe380d48a entityStatement 2019-02-19 false registeredEntity SIA "Korn L" 2019-02-19 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    
87422 5287bf5b-8d38-4a3d-8cdc-8ed4a2e19221 entityStatement 2019-02-19 false registeredEntity Sabiedrība ar ierobežotu atbildību "MOSTO" 2019-02-19 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    
87423 73351166-e569-4ce7-839b-1829ba5e25ae entityStatement 2019-02-19 false registeredEntity Sabiedrība ar ierobežotu atbildību "DGS Būve" 2019-02-19 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    
87424 def17a7d-e3f8-478c-b64b-ed72d416edd9 entityStatement 2019-02-19 false registeredEntity Sabiedrība ar ierobežotu atbildību "Team K" 2019-02-19 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    
87425 7cdada40-c82a-426b-b095-9fe31e6b3279 entityStatement 2019-02-19 false registeredEntity Sabiedrība ar ierobežotu atbildību "VESMAR" 2019-02-19 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    
87426 693e37fb-fa2c-4c3e-b266-b8fb11eb920c entityStatement 2019-02-19 false registeredEntity Sabiedrība ar ierobežotu atbildību "Sastatņu serviss" 2019-02-19 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    
87427 d48eaa32-4a12-4808-9bb3-f9cf7846f074 entityStatement 2019-02-19 false registeredEntity SIA SMS masters 2019-02-19 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    
87428 e083a7cf-a9db-40f5-a1d9-15328b8fd7f1 entityStatement 2019-02-19 false registeredEntity SIA "MedExprez" 2019-02-19 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    
92684 f990f3c4-e98a-45ac-ba1f-dae194660c2f entityStatement 2019-02-19 false registeredEntity SIA "Loģistikas konsultācijas un pakalpojumi" 2019-02-19 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    
97377 c7af3325-2127-41ac-94a8-4ef11315264b entityStatement 2019-02-19 false registeredEntity SIA "Videns" 2019-02-19 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    
97378 1d318f2a-376f-47da-8413-ed04ea2ab992 entityStatement 2019-02-19 false registeredEntity SIA "VAD motors" 2019-02-19 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    
97379 9aa40724-ef48-464f-9a1a-615c14c9e156 entityStatement 2019-02-19 false registeredEntity SIA "MR investīcijas kompānija" 2019-02-19 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    
97380 6aa15f07-d6eb-4923-aae4-1ccbbf71f8a4 entityStatement 2019-02-19 false registeredEntity SIA BEERZONE 2019-02-19 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]) 
);