entity_statement
28 rows where foundingdate = "2019-04-12" and "statementdate" is on date 2019-04-12
This data as json, CSV (advanced)
Suggested facets: 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 103224 | 919788f4-0d53-4c48-9674-9e1b67220711 | entityStatement | 2019-04-12 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Forest of Dreams" | 2019-04-12 | 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 | ||
| 103225 | a22fad9a-ec12-42fc-be3b-a4e04ef28f26 | entityStatement | 2019-04-12 | false | registeredEntity | SIA "H divi O" | 2019-04-12 | 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 | ||
| 103226 | ad446695-7e18-4194-9a6b-3047fcbaae47 | entityStatement | 2019-04-12 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "IG Part" | 2019-04-12 | 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 | ||
| 103227 | 48158e1c-7bc7-4a0d-b84e-b96cd3439b8a | entityStatement | 2019-04-12 | false | registeredEntity | SIA "EVE" | 2019-04-12 | 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 | ||
| 103228 | 5da9d252-7046-40e6-82fc-4d77cd270da8 | entityStatement | 2019-04-12 | false | registeredEntity | SIA REDART | 2019-04-12 | 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 | ||
| 106343 | b9720d6a-e39f-445a-828b-32ee11c3bb8f | entityStatement | 2019-04-12 | false | registeredEntity | YN Consulting SIA | 2019-04-12 | 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 | ||
| 88276 | 4ffe6e20-ee95-48c3-ad6c-c1c1b3c287ff | entityStatement | 2019-04-12 | false | registeredEntity | SIA UMBRA | 2019-04-12 | 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 | ||
| 88277 | 4b3680bc-621b-4a2e-a66f-406b1ee61c83 | entityStatement | 2019-04-12 | false | registeredEntity | SIA "Bluexb" | 2019-04-12 | 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 | ||
| 88278 | 30e48c01-915d-4a88-bcbc-d4b4af71e0a0 | entityStatement | 2019-04-12 | false | registeredEntity | SIA "Escado World Services" | 2019-04-12 | 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 | ||
| 88280 | 1f0df205-bbff-4b82-8dae-c21c7afb0d44 | entityStatement | 2019-04-12 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Stamed" | 2019-04-12 | 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 | ||
| 88281 | fa8916b4-6c15-4646-a925-b743f73f51fb | entityStatement | 2019-04-12 | false | registeredEntity | SIA "Figaro Style" | 2019-04-12 | 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 | ||
| 88282 | f0cf67aa-583f-427c-87da-90d3869dbb01 | entityStatement | 2019-04-12 | false | registeredEntity | SIA "Moncor" | 2019-04-12 | 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 | ||
| 88283 | b2e9e3bc-3504-4647-a28a-c1364195688d | entityStatement | 2019-04-12 | false | registeredEntity | Franču Māja SIA | 2019-04-12 | 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 | ||
| 88284 | ed1dd4ff-289a-4f03-98f7-c665ea13555a | entityStatement | 2019-04-12 | false | registeredEntity | ABARU SIA | 2019-04-12 | 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 | ||
| 88285 | 15c89249-3d99-4d66-9e43-e3185656fd47 | entityStatement | 2019-04-12 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "INZUZO" | 2019-04-12 | 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 | ||
| 88286 | a6196b20-59aa-4a89-9c7f-9719c524094d | entityStatement | 2019-04-12 | false | registeredEntity | Mystic Flare SIA | 2019-04-12 | 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 | ||
| 88289 | 229c64b1-90c5-406c-8e5e-35da177bae0d | entityStatement | 2019-04-12 | false | registeredEntity | Pixeligence SIA | 2019-04-12 | 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 | ||
| 88290 | 3998c776-184e-4f4b-a842-8fd663d017c2 | entityStatement | 2019-04-12 | false | registeredEntity | SIA COLOR ENERGY | 2019-04-12 | 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 | ||
| 88291 | 10d3aaca-3596-47cc-abc6-920ceec5ef35 | entityStatement | 2019-04-12 | false | registeredEntity | Orbi group Management SIA | 2019-04-12 | 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 | ||
| 88292 | 4951bfed-a638-4bba-ab76-f696d2973608 | entityStatement | 2019-04-12 | false | registeredEntity | SIA "AMG Systems" | 2019-04-12 | 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 | ||
| 88293 | 4b52e98d-1bf4-4834-9c13-30983024a23e | entityStatement | 2019-04-12 | false | registeredEntity | SIA "Jeļena Simoņenko" | 2019-04-12 | 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 | ||
| 88294 | 0313e081-5174-4b6f-9704-03911a7ebc62 | entityStatement | 2019-04-12 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Trister" | 2019-04-12 | 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 | ||
| 88295 | 9994adc2-4977-4ae7-8696-963f2f9f6b5b | entityStatement | 2019-04-12 | false | registeredEntity | XOP Networks Latvia, SIA | 2019-04-12 | 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 | ||
| 88296 | 8840dd72-3828-43ff-9b6a-0a406e4729a3 | entityStatement | 2019-04-12 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "A-Z Grīdas" | 2019-04-12 | 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 | ||
| 88298 | 6395c1c6-a007-4833-a8b9-42f7c30f45f0 | entityStatement | 2019-04-12 | false | registeredEntity | SIA "Vecjūdzkalni" | 2019-04-12 | 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 | ||
| 88299 | d5cb296d-fc82-4c88-9aa6-cf93b8cce3cc | entityStatement | 2019-04-12 | false | registeredEntity | SIA "applemike" | 2019-04-12 | 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 | ||
| 92746 | 3bae801a-e454-4e80-b565-a7e9f2f013f0 | entityStatement | 2019-04-12 | false | registeredEntity | SIA "Meadow Bees" | 2019-04-12 | 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 | ||
| 92747 | 6af83ce3-115d-44f7-97c8-72ecc9260757 | entityStatement | 2019-04-12 | false | registeredEntity | SIA "STEMSILK" | 2019-04-12 | 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]) );