entity_statement
17 rows where foundingdate = "2016-03-11", iscomponent = "false" and "statementdate" is on date 2019-07-15
This data as json, CSV (advanced)
Suggested facets: 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 70984 | 69c2589f-7d04-4db0-9fc2-5b596b8c9ecf | entityStatement | 2019-07-15 | false | registeredEntity | SIA "ATL būve" | 2016-03-11 | 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 | ||
| 70988 | 3d8bcdef-1329-4416-8b73-6868dfc53db6 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Arvla" | 2016-03-11 | 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 | ||
| 70991 | 4cac2a09-32b9-4298-b904-b9800c00d34a | entityStatement | 2019-07-15 | false | registeredEntity | SIA "AMMERS projekti un grāmatvedība" | 2016-03-11 | 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 | ||
| 70992 | e2a0b166-32da-44f5-92bd-b9aa83550751 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "AMBRE FURS" | 2016-03-11 | 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 | ||
| 70993 | 11a760a4-2703-42f5-a4ac-7ec926d9d2a8 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "ArAuto 24" | 2016-03-11 | 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 | ||
| 70998 | 696ceedc-a0fc-4bf3-93f4-bdcac941c91e | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Bleizit" | 2016-03-11 | 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 | ||
| 71000 | 1702b855-e256-439d-b664-64ed39de836a | entityStatement | 2019-07-15 | false | registeredEntity | SIA MB Serviss | 2016-03-11 | 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 | ||
| 71001 | 7417b104-62c5-4193-80e9-ccb5af982809 | entityStatement | 2019-07-15 | false | registeredEntity | SIA DRV Auto | 2016-03-11 | 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 | ||
| 71002 | d4c17017-6914-4dd2-919f-615f776972fb | entityStatement | 2019-07-15 | false | registeredEntity | SIA Remonts ar prieku | 2016-03-11 | 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 | ||
| 71003 | 011ac7d1-9f9f-40ad-80eb-82d81e7e4f3f | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Mestre" | 2016-03-11 | 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 | ||
| 71005 | 9aa9d940-a5c4-4d8f-9a70-e3f4de73ec67 | entityStatement | 2019-07-15 | false | registeredEntity | SIA ECO BIRD | 2016-03-11 | 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 | ||
| 71008 | 26d6a95d-124c-416f-ba9c-1ea2891f4e31 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Kunkri" | 2016-03-11 | 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 | ||
| 71009 | 0431104d-1b5e-4933-b978-c48b62685dad | entityStatement | 2019-07-15 | false | registeredEntity | SIA SF Eksperts | 2016-03-11 | 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 | ||
| 71010 | 53472b5f-8632-41f6-8dda-5e77044aabc3 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "AKMENS APSTRĀDES EKSPERTS" | 2016-03-11 | 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 | ||
| 71013 | bcfa0b93-fc6d-44ef-8bda-3b1361c75d58 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Medini Latvia" | 2016-03-11 | 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 | ||
| 96626 | ed13b765-2bc9-4f60-97c6-15ca902ff6f2 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Oltija" | 2016-03-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 | ||
| 96628 | 3234676c-f189-4d84-8aa9-97574177ec7d | entityStatement | 2019-07-15 | false | registeredEntity | SIA "VPasaule" | 2016-03-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 |
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]) );