entity_statement
30 rows where foundingdate = "2017-09-07", iscomponent = "false" and publicationdetails_publicationdate = "2021-01-19"
This data as json, CSV (advanced)
Suggested facets: statementdate
| _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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 102229 | e265d84a-8a9b-4c9c-9a6b-9250cda8b2dd | entityStatement | 2019-07-16 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Ginta Dīķe" | 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 | ||
| 102230 | b14ddf20-9632-47c9-9149-0e10c1f7eb55 | entityStatement | 2018-02-22 | false | registeredEntity | SIA "DeCorGips" | 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 | ||
| 78895 | 69ed59a9-ad4c-4de7-93a0-33882da36b97 | entityStatement | 2019-03-13 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Listt Events" | 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 | ||
| 78896 | 2b8f25d0-a957-468a-90b1-15fa8ebab540 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Woodmill" | 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 | ||
| 78897 | 81b8d3a7-9a6c-46aa-a770-12c61b212208 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "JD LINE" | 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 | ||
| 78898 | f7f4aa87-6ae4-4fd2-81c9-c9483ca83aec | entityStatement | 2020-09-02 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "ALMAX HOLDING" | 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 | ||
| 78899 | 5c5ac2da-6f2d-4cbf-bced-e9f91dfb0dca | entityStatement | 2019-07-14 | false | registeredEntity | SIA "Blade Sharpening" | 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 | ||
| 78900 | ddf5a00f-875b-46ec-bdfc-15bd07b841c7 | entityStatement | 2019-06-28 | false | registeredEntity | SIA Optimal Expert | 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 | ||
| 78901 | 166b39fa-d784-43ac-ad5d-bcd7ba4cf817 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "ES46" | 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 | ||
| 78902 | 0d459e07-f245-4234-a00f-be91574aabcf | entityStatement | 2018-10-25 | false | registeredEntity | SIA "PELIAS" | 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 | ||
| 78903 | 75ff2b58-1cb4-43b7-bf95-8197186a1b36 | entityStatement | 2018-06-08 | false | registeredEntity | SIA Gavrelia | 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 | ||
| 78904 | 2aa4a814-0bd3-48b9-835e-a1db03a113fe | entityStatement | 2019-07-14 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "GLOBAL CARGO INTERNATIONAL" | 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 | ||
| 78905 | 15342f32-9a64-4a52-950c-dc35fb582b50 | entityStatement | 2019-07-15 | false | registeredEntity | SIA RENTIJUM | 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 | ||
| 78906 | 340f6e7d-8261-4a75-a5b6-df34e230efd7 | entityStatement | 2018-07-30 | false | registeredEntity | SIA "ONLY Interior" | 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 | ||
| 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 | ||
| 78908 | 937457c0-85ac-44a2-8ba9-22cb7ea7ce51 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Lapegles24" | 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 | ||
| 78909 | 2ba2aaab-46a5-4403-ac4f-e084154f8241 | entityStatement | 2019-03-25 | false | registeredEntity | SIA "Strend.lv" | 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 | ||
| 78910 | 53d748d0-aa8e-432d-9e43-6abd2b903e41 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "DE Future" | 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 | ||
| 78911 | b89639cb-9701-4607-bb74-b96d9e443169 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Bernstein Woodworks" | 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 | ||
| 78912 | 3d5b65d1-acfa-4fb6-9a5b-e9b872e5ef1c | entityStatement | 2017-12-08 | false | registeredEntity | SIA "MA Experts" | 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 | ||
| 78913 | f0113654-5f39-45fa-b9b3-5b7dd8f18072 | entityStatement | 2019-07-14 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "APE MEŽS" | 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 | ||
| 78914 | 70332569-be19-4256-86ef-3e713e036278 | entityStatement | 2019-12-02 | false | registeredEntity | SIA "AIRONI" | 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 | ||
| 78915 | faea8b5a-1d7c-4f3c-bd57-b480f2012527 | entityStatement | 2018-07-18 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Miklava" | 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 | ||
| 78916 | a43ecf60-3538-44f6-98cf-f81d65e469ae | entityStatement | 2019-07-15 | false | registeredEntity | SIA "VK sporta klubs" | 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 | ||
| 78917 | 3dc89677-8876-4329-91c8-48b9f6fc249e | entityStatement | 2019-07-14 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Strobus" | 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 | ||
| 78918 | 470e6fc4-78b3-4b05-93d8-75fcf7314169 | entityStatement | 2018-07-27 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "ORaimet" | 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 | ||
| 78919 | 88b37323-7e93-4aa8-bb70-ea48797f18f9 | entityStatement | 2019-07-14 | false | registeredEntity | SIA "Careva Contemporary" | 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 | ||
| 78920 | 8c0e787f-562b-44b0-8ff3-6d276098868e | entityStatement | 2018-11-16 | false | registeredEntity | SIA "ISB" | 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 | ||
| 78921 | c26de7cd-d13d-491a-929d-f2c2d22f3a35 | entityStatement | 2018-03-22 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "SV kompani" | 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 | ||
| 92278 | 96bac1e1-0592-4660-8bb8-de93d7cef301 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Miss Clover" | 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 |
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]) );