entity_statement
24 rows where foundingdate = "2014-08-06", incorporatedinjurisdiction_name = "Latvia" and iscomponent = "false"
This data as json, CSV (advanced)
Suggested facets: statementdate, publicationdetails_publicationdate, statementdate (date), foundingdate (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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 101476 | a72e001e-b705-4d93-8c93-103e00df7952 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "WINGO" | 2014-08-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 | ||
| 110770 | b245e0fb-889c-4914-8552-314110d8bfe2 | entityStatement | 2019-07-16 | false | registeredEntity | SIA "Parfumerie" | 2014-08-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 | ||
| 61584 | 2bcf06bc-b0d4-4732-9247-76466b3ca783 | entityStatement | 2018-06-21 | false | registeredEntity | "HansaMatrix Innovation 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 | ||
| 61585 | 48d525b6-638a-4b7d-85da-e0c79a057e8b | entityStatement | 2019-07-14 | false | registeredEntity | SIA "ACI Asia Cardiovascular Interventions" | 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 | ||
| 61586 | 0a2e49f3-a45a-43a7-b2d0-77f3fb87671a | entityStatement | 2019-07-14 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "ZET.LV" | 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 | ||
| 61587 | 4d8a90c3-6710-47d7-9500-764b77c4a27c | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Building GB" | 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 | ||
| 61588 | 9da430c9-28ff-443c-bff2-b03b6ab99961 | entityStatement | 2019-07-14 | false | registeredEntity | SIA "AR Partneri" | 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 | ||
| 61589 | 17649c7c-deaa-4ca9-abc1-2342efa0afa4 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "VIDEJUMS" | 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 | ||
| 61590 | e59e3b98-76d6-46dc-a73b-30377d12655e | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "MASSO" | 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 | ||
| 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 | ||
| 61592 | 9cf8bc0b-1261-4fc0-b41f-21e26e500c9c | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Daumalas" | 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 | ||
| 61593 | 13d7d002-e784-4a9c-a095-3454265d5c53 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Liepennes" | 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 | ||
| 61594 | 972e722d-ea0a-41b3-aaea-6769d0df6885 | entityStatement | 2019-07-14 | false | registeredEntity | SIA "HoReCa 4U" | 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 | ||
| 61595 | 650fc4dd-e9a1-487b-9a14-4615231a895d | entityStatement | 2019-07-14 | false | registeredEntity | SIA "ARX WOOD" | 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 | ||
| 61596 | c8a759ca-6339-478b-b904-b2ba54404de8 | entityStatement | 2019-07-14 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "High Energy" | 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 | ||
| 61597 | 49f6c259-0ab9-4dd0-ae91-321e090788eb | entityStatement | 2019-07-15 | false | registeredEntity | SIA "NMKA Trading" | 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 | ||
| 61598 | d4418a8b-0a40-4c32-8843-2f6d9b41252e | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Capital Trading Ltd" | 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 | ||
| 61599 | 2421b274-ee4f-4820-b9f1-6f856cfc6967 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "AUTOSPILS" | 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 | ||
| 61600 | 53088f93-6bb5-4094-bfd5-4ea8279a90ec | entityStatement | 2019-07-14 | false | registeredEntity | SIA "GOLDMARK LTD" | 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 | ||
| 61601 | 6063e189-2a0b-414d-86e1-fafaf2ea1d00 | entityStatement | 2019-07-14 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Bliss SK" | 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 | ||
| 61602 | 2fc7f649-b067-4406-8ede-0f7355d53c92 | entityStatement | 2020-03-13 | false | registeredEntity | SIA "Aviatec Composite" | 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 | ||
| 61603 | e96b397d-481e-4e66-94d4-1438c9c4c4d9 | entityStatement | 2021-01-08 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Mobinet" | 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 | ||
| 61604 | 66ac8454-05ff-44ab-aa63-185145a5577a | entityStatement | 2017-12-21 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Photoart Riga" | 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 | ||
| 91654 | be7c72e1-8f13-4590-97c7-e00fac634eb8 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Artistic" | 2014-08-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 |
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]) );