entity_statement
38 rows where "foundingdate" is on date 2018-08-09, iscomponent = "false" and publicationdetails_publicationdate = "2021-01-19"
This data as json, CSV (advanced)
Suggested facets: 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 102510 | a396501a-de3c-462d-952f-7e6ae8994371 | entityStatement | 2018-08-09 | false | registeredEntity | SIA "Jautrības Sala" | 2018-08-09 | 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 | ||
| 106199 | 4d38cf0c-7ca1-4789-82dc-9f4eec9f5b88 | entityStatement | 2018-08-09 | false | registeredEntity | Rēzeknes speciālās ekonomiskās zonas SIA "Floraplanet" | 2018-08-09 | 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 | ||
| 106200 | bf0fb6bf-82e1-4d25-b91e-f35467b26a6a | entityStatement | 2018-08-09 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "SALRIS AV" | 2018-08-09 | 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 | ||
| 112089 | 5f5cb69f-809f-4ce4-909d-30a6d08d153f | entityStatement | 2018-08-09 | false | registeredEntity | SIA "G.V. Mode" | 2018-08-09 | 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 | ||
| 112090 | 3348cb50-3769-445c-9cb8-d135237a6442 | entityStatement | 2018-08-09 | false | registeredEntity | SIA "VGA Mode" | 2018-08-09 | 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 | ||
| 112091 | b7ebab19-5c86-479e-9328-d4d79c039447 | entityStatement | 2018-08-09 | false | registeredEntity | SIA "SATVARS" | 2018-08-09 | 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 | ||
| 84388 | a1a5e1de-9a7a-4325-b391-8f8c1fc66c81 | entityStatement | 2018-08-09 | false | registeredEntity | SIA "ZK PRO" | 2018-08-09 | 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 | ||
| 84389 | 57b4976a-b6fb-4452-842d-96aedc2cf3f6 | entityStatement | 2018-08-09 | false | registeredEntity | SIA "Ambrus" | 2018-08-09 | 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 | ||
| 84390 | 79616df0-f0af-4809-9bb6-1b5b149490e7 | entityStatement | 2018-08-09 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Marine Lubricants" | 2018-08-09 | 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 | ||
| 84391 | 7a7c6743-5fe3-46d7-8eea-81b5c4220160 | entityStatement | 2018-08-09 | false | registeredEntity | SIA "DK Couture" | 2018-08-09 | 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 | ||
| 84392 | 9415daff-aa03-4e86-b27c-8c2e34d57b5d | entityStatement | 2018-08-09 | false | registeredEntity | SIA A.V.L. Plus | 2018-08-09 | 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 | ||
| 84393 | b6d200b4-bbad-406f-ab9f-ba1636b8f5b5 | entityStatement | 2018-12-12 | false | registeredEntity | SIA "Zenda" | 2018-08-09 | 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 | ||
| 84394 | 5130ab1a-ada4-40e2-9d4f-624de6134043 | entityStatement | 2018-08-09 | false | registeredEntity | SIA Easy Movers | 2018-08-09 | 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 | ||
| 84395 | 4a2fbbd5-d97c-44e2-88db-a60a4d8fe852 | entityStatement | 2020-11-26 | false | registeredEntity | Affnation SIA | 2018-08-09 | 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 | ||
| 84396 | ddb91dfd-c9d3-4b14-92be-b304bc0cc783 | entityStatement | 2018-08-09 | false | registeredEntity | SIA Baltic healthcare division | 2018-08-09 | 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 | ||
| 84397 | e68b031b-4c45-45b3-9867-e4d10d59bc9e | entityStatement | 2018-08-09 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Green-green production" | 2018-08-09 | 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 | ||
| 84398 | 02943051-c334-443c-92c4-1d94f676173c | entityStatement | 2018-08-09 | false | registeredEntity | SIA "RIX Partner" | 2018-08-09 | 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 | ||
| 84399 | f1a58bcf-ffb8-4e23-a6ff-83f3abee484c | entityStatement | 2018-08-09 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Mācību centrs FRIGA" | 2018-08-09 | 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 | ||
| 84400 | c3320a1e-fed8-4314-88b6-ca5fc775b3e8 | entityStatement | 2018-08-09 | false | registeredEntity | SIA "Nishan Enterprises" | 2018-08-09 | 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 | ||
| 84401 | cb1023ba-b6cd-4660-86a8-d02890be7143 | entityStatement | 2018-08-09 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "BAZ7" | 2018-08-09 | 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 | ||
| 84402 | 89e13974-94c4-4eae-99bf-15ef761fbdc7 | entityStatement | 2018-08-09 | false | registeredEntity | SIA "Plaza Line" | 2018-08-09 | 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 | ||
| 84403 | 9275592f-c962-48e4-b048-823e9dcf4c40 | entityStatement | 2019-12-11 | false | registeredEntity | SIA Nodexo | 2018-08-09 | 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 | ||
| 84404 | 709bbee7-8aae-42ca-a592-60b395cc0f73 | entityStatement | 2018-08-09 | false | registeredEntity | SIA "Anchorage" | 2018-08-09 | 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 | ||
| 84405 | 0c8c6af9-17f9-43dc-8ab6-61ed8c59146b | entityStatement | 2018-08-22 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "10X CAPITAL" | 2018-08-09 | 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 | ||
| 84406 | 8f355db5-2eb8-47ef-b965-962f796017dd | entityStatement | 2020-03-09 | false | registeredEntity | SIA "Capitalia Collateral Agent" | 2018-08-09 | 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 | ||
| 84407 | fbc34a55-43d9-4d97-9144-2db80578cb7a | entityStatement | 2018-08-09 | false | registeredEntity | SIA "ArtPO" | 2018-08-09 | 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 | ||
| 84408 | 9a412d4e-8202-4cba-99d4-08a64f818f2b | entityStatement | 2018-08-09 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "ANTISTAR" | 2018-08-09 | 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 | ||
| 84409 | 084e7abb-9a28-4dcd-8476-1c1358f164a2 | entityStatement | 2020-03-06 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "EURO STANDARD" | 2018-08-09 | 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 | ||
| 84410 | 3517ab63-ba32-449b-b595-9fc8bad107aa | entityStatement | 2020-10-09 | false | registeredEntity | SIA UNIVERSAL PROTECTION | 2018-08-09 | 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 | ||
| 84411 | 438f35d2-e87d-4499-bddd-eca7b240b84f | entityStatement | 2018-08-09 | false | registeredEntity | SIA "Ayurveda Latvia" | 2018-08-09 | 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 | ||
| 84412 | c70456ac-4482-4d21-8c59-90bb19175c31 | entityStatement | 2018-08-09 | false | registeredEntity | SIA "Presto Med" | 2018-08-09 | 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 | ||
| 84413 | e2b63ecf-d8a4-447d-a74d-ceda55c89e24 | entityStatement | 2018-08-09 | false | registeredEntity | SIA "SAHIL INTERNATIONAL" | 2018-08-09 | 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 | ||
| 84414 | 187a8c36-b359-4483-b3d5-4b23081ad79f | entityStatement | 2018-08-09 | false | registeredEntity | SIA AVEN-EZER | 2018-08-09 | 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 | ||
| 84415 | 0bf55140-ff8f-48d4-80bb-b22789eaddd6 | entityStatement | 2018-08-09 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "TF Assistance" | 2018-08-09 | 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 | ||
| 84416 | 1d81a807-9c6b-4424-9940-4419c7ebbd35 | entityStatement | 2018-08-09 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "AdAnna" | 2018-08-09 | 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 | ||
| 92531 | 6de7a7bb-ef77-40cc-8153-b2d1d945f03d | entityStatement | 2019-02-21 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Catalyco" | 2018-08-09 | 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 | ||
| 92532 | 251bc019-c400-49d5-9824-f2c73808db32 | entityStatement | 2018-08-09 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "ELEO Project" | 2018-08-09 | 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 | ||
| 97216 | e043b96e-4eae-4be8-b249-0258aee40cf2 | entityStatement | 2018-08-09 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "BARUT" | 2018-08-09 | 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]) );