entity_statement
34 rows where iscomponent = "false" and "statementdate" is on date 2020-01-06
This data as json, CSV (advanced)
Suggested facets: publicationdetails_publicationdate, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 100354 | f3068f25-1506-441c-87a4-6edab9ad6430 | entityStatement | 2020-01-06 | false | registeredEntity | SIA "REKLĀMAS DIZAINS" | 2009-10-06 | 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 | ||
| 108247 | a18356ec-ae83-4c6e-9b72-c7324bfbf2cf | entityStatement | 2020-01-06 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "BAUSKAS BŪVNIEKS un CO" | 1994-05-11 | 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 | ||
| 16258 | 6101c7db-5c5b-4470-9cd6-7285d63d9ea8 | entityStatement | 2020-01-06 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "PEKUSS" | 2004-07-06 | 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 | ||
| 18031 | 55bc8a05-c808-498a-bc30-ecf74b3b2d7c | entityStatement | 2020-01-06 | false | registeredEntity | SIA "Hansahold" | 2005-05-23 | 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 | ||
| 21666 | fdd277a5-3c22-46e1-9196-9061c7fb9105 | entityStatement | 2020-01-06 | false | registeredEntity | SIA "SKAISTUMA KLĪNIKA MONRO" | 2006-10-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 | ||
| 24711 | b743623c-11f9-451a-8603-77cef5489473 | entityStatement | 2020-01-06 | false | registeredEntity | SIA "A.R.T. projekts" | 2007-09-13 | 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 | ||
| 26086 | bf766f05-8413-42e8-92d4-b2251caedfd1 | entityStatement | 2020-01-06 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "PPL ENERGY" | 2008-02-28 | 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 | ||
| 28012 | 9be6f9fb-92c4-47f2-aafc-c7f2ab78cec5 | entityStatement | 2020-01-06 | false | registeredEntity | Rotaract Club of Riga International | 2016-06-10 | 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 | ||
| 38453 | 8159e033-21f2-4c06-b8d1-dc22dfe6410c | entityStatement | 2020-01-06 | false | registeredEntity | SIA "Autobrava" | 2010-09-24 | 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 | ||
| 4014 | d9075c76-683b-4594-897d-356f1edabe5e | entityStatement | 2020-01-06 | false | registeredEntity | "Kompeksim Rīga" SIA | 1991-12-05 | 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 | ||
| 41233 | 71d39551-56a3-4a14-9c05-56b4e28bf85f | entityStatement | 2020-01-06 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "space in engineers" | 2011-02-28 | 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 | ||
| 4667 | 453ce60c-d5ca-43b7-83cf-cdaabc9859da | entityStatement | 2020-01-06 | false | registeredEntity | SIA "RADIO SKONTO" | 1993-02-15 | 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 | ||
| 52464 | 48aa935e-3b13-4758-9f95-898fdfa67894 | entityStatement | 2020-01-06 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Eleja" | 2013-02-01 | 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 | ||
| 60253 | 785a7da5-5dc5-41fe-b3e8-eb5a898d7a68 | entityStatement | 2020-01-06 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Sottile consulting" | 2014-05-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 | ||
| 61591 | 28cec049-f9fb-487b-809f-1f34f48778ff | entityStatement | 2020-01-06 | false | registeredEntity | G-Twelve SIA | 2014-08-06 | 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 | ||
| 61712 | 1ab9ca50-aaa5-496e-ac67-2ce4b544cb76 | entityStatement | 2020-01-06 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Ex Index" | 2014-08-13 | 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 | ||
| 62176 | 3a376774-67f2-4a03-a34b-eb11bdd18b5c | entityStatement | 2020-01-06 | false | registeredEntity | SWANSSON ADVISORS SIA | 2014-09-10 | 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 | ||
| 63125 | 31818337-31cd-4b78-93ed-860e9d483095 | entityStatement | 2020-01-06 | false | registeredEntity | SIA "SANELĪ" | 2014-11-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 | ||
| 69999 | 1705a13b-8cc8-4f9a-a359-80c033858498 | entityStatement | 2020-01-06 | false | registeredEntity | SIA "Vito Bau" | 2016-01-12 | 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 | ||
| 70025 | 18e3337c-efa8-4af2-a807-a966bdecda78 | entityStatement | 2020-01-06 | false | registeredEntity | SIA "MDT-SERVISS" | 2016-01-14 | 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 | ||
| 70721 | b1e708cc-ce83-4e36-a2cb-6703a60d3f8f | entityStatement | 2020-01-06 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "U26" | 2016-02-24 | 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 | ||
| 70971 | 5ee7623d-9cbb-4de7-a013-06a447b944d0 | entityStatement | 2020-01-06 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "GREEN BLOC" | 2016-03-10 | 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 | ||
| 71214 | e9e92b92-c0df-4e81-8624-57f3b46e19e8 | entityStatement | 2020-01-06 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Ūdens Visiem" | 2016-03-29 | 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 | ||
| 75141 | 0efc75a1-c29b-42a0-9fec-57b1db5d1f10 | entityStatement | 2020-01-06 | false | registeredEntity | SIA "Kaldupes" | 2016-12-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 | ||
| 75248 | 47592303-3347-40fd-8824-f2393021e606 | entityStatement | 2020-01-06 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Dzirnavu Apartamenti" | 2016-12-27 | 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 | ||
| 77660 | 871f8c63-087b-410b-8409-64c77f9680dd | entityStatement | 2020-01-06 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "DIAM" | 2017-06-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 | ||
| 78907 | fcb14a8e-38a8-4ae6-a4be-589b53a2b09a | entityStatement | 2020-01-06 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Viktorystar" | 2017-09-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 | ||
| 79030 | bb4cab39-9c13-483f-a01a-b8591afca2a5 | entityStatement | 2020-01-06 | false | registeredEntity | SIA "Zaļā vārpa" | 2017-09-14 | 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 | ||
| 8192 | af720b32-e816-483e-92bf-1a0eff7e196d | entityStatement | 2020-01-06 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Finvest" | 1997-11-26 | 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 | ||
| 82266 | 4d3e4cbf-c8bc-470e-93cf-3b7b19903dca | entityStatement | 2020-01-06 | false | registeredEntity | SIA "ZipMama" | 2018-03-27 | 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 | ||
| 84006 | 0d721673-a0a1-4477-b7da-a371a89faddd | entityStatement | 2020-01-06 | false | registeredEntity | SIA Hansa1RE | 2018-07-16 | 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 | ||
| 84059 | a60ce787-20b8-4940-b149-a94b936a3c1c | entityStatement | 2020-01-06 | false | registeredEntity | SIA "JL PROJEKTS" | 2018-07-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 | ||
| 93410 | bca2529d-5bd6-4d18-9f5f-87eed39de346 | entityStatement | 2020-01-06 | false | registeredEntity | Vaboles pagasta zemnieku saimniecība "Sniegi" | 2004-05-31 | 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 | ||
| 95568 | 4d157109-81e7-478d-a454-a98567022f6c | entityStatement | 2020-01-06 | false | registeredEntity | SIA "EKOTE" | 2011-08-30 | 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
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]) );