entity_statement
40 rows where "foundingdate" is on date 2019-04-24
This data as json, CSV (advanced)
Suggested facets: statementdate, publicationdetails_publicationdate, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
103252 | b8b0de42-f799-4520-bcdb-3c6b8a330575 | entityStatement | 2019-11-27 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "TWL BA" | 2019-04-24 | 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 | ||
112435 | 5ba64e4d-6f0f-4c67-afa4-0d02ad41ebeb | entityStatement | 2019-04-24 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Mēbeļmeistars" | 2019-04-24 | 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 | ||
112436 | 56f978ce-6b06-4b8f-b08d-e91c370f74ec | entityStatement | 2019-04-24 | false | registeredEntity | SIA "T.B. Accounting" | 2019-04-24 | 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 | ||
29505 | 7c459d17-693a-4435-a6e5-918c0936ec83 | entityStatement | 2019-04-24 | false | registeredEntity | "Kultūras, izglītības un sporta starptautiskā asociācija (KISSA)" | 2019-04-24 | 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 | ||
29506 | 289f4c54-4605-46be-819f-4eea4150853d | entityStatement | false | registeredEntity | "Hokeja klubs Baltijas vilki" | 2019-04-24 | 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 | |||
29507 | c150c50a-f19b-481e-b2f1-f0fbc64c63a8 | entityStatement | false | registeredEntity | "Tu Esi Vērtīgs" | 2019-04-24 | 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 | |||
29508 | 4a558bf4-2cb2-4123-bda6-0372f8293c2b | entityStatement | false | registeredEntity | "Gaujas 4" | 2019-04-24 | 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 | |||
29509 | a3f51907-2a0d-4216-93f9-c19dc1cb1d04 | entityStatement | false | registeredEntity | "Skeptiskā biedrība" | 2019-04-24 | 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 | |||
29510 | 2c42fa32-5c03-4b72-9d5a-31fd18beaf62 | entityStatement | false | registeredEntity | "Biedrība Jūras Draugi" | 2019-04-24 | 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 | |||
29511 | c206ff37-2d74-4fc1-83ac-97959d197889 | entityStatement | false | registeredEntity | "Telpa Sev" | 2019-04-24 | 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 | |||
29512 | 2f5ea147-7509-4abe-a579-6672e8d62f80 | entityStatement | false | registeredEntity | "DICE CHESS FEDERATION" | 2019-04-24 | 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 | |||
29513 | e8acfc09-05e4-410b-a908-f4710c7ab9c2 | entityStatement | false | registeredEntity | Mednieku un makšķernieku biedrība "Piekūns" | 2019-04-24 | 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 | |||
88412 | 07131a73-c8d5-4c00-8e72-b74894eee8cf | entityStatement | 2019-04-24 | false | registeredEntity | SIA "ALKALINE" | 2019-04-24 | 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 | ||
88420 | 66d1df58-07fc-4a84-beb3-07d794741f01 | entityStatement | 2019-04-24 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "SUPLatvia" | 2019-04-24 | 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 | ||
88421 | 5b7b142e-4303-4e6b-b507-35d3fe881b75 | entityStatement | 2019-04-24 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību Drava-L | 2019-04-24 | 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 | ||
88422 | 7a0c839e-d35f-4f2d-8e29-c0c9d2cbeb6a | entityStatement | 2019-04-24 | false | registeredEntity | SIA "KONG MOBILITY" | 2019-04-24 | 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 | ||
88423 | 2d7e3272-9f74-4600-9f83-ddc47e5c75bc | entityStatement | 2019-04-24 | false | registeredEntity | SIA Sinti Films | 2019-04-24 | 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 | ||
88424 | c7cd1102-2f87-4329-ba20-bf75bf60b7f5 | entityStatement | 2020-12-17 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Vex Media Group" | 2019-04-24 | 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 | ||
88425 | 85b2daa6-8697-4746-b024-e13f6bdc4ac1 | entityStatement | 2019-08-14 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "QUICK RENT" | 2019-04-24 | 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 | ||
88426 | 38c4a56c-1adf-4b70-be46-84bea9a2d2ba | entityStatement | 2019-10-16 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Kurilskiy bereg intl" | 2019-04-24 | 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 | ||
88427 | eb066c77-22ed-4632-98c6-a8d8040ae4ab | entityStatement | 2019-04-24 | false | registeredEntity | SIA Valenti 21 | 2019-04-24 | 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 | ||
88428 | 51d301ca-957f-454b-a5d9-5996670a1150 | entityStatement | 2019-04-24 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Video Factory" | 2019-04-24 | 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 | ||
88429 | 30b2733b-f3b8-44a2-989d-a265acf79f0e | entityStatement | 2019-04-24 | false | registeredEntity | SIA TransformMe | 2019-04-24 | 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 | ||
88430 | 5dfa96f4-30dd-4c16-ac4d-fce30954ee88 | entityStatement | 2019-04-24 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Best Lux" | 2019-04-24 | 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 | ||
88431 | 08ed6b3a-c07d-4218-a872-f8334d540106 | entityStatement | 2019-04-24 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Zaļais drakons 888" | 2019-04-24 | 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 | ||
88432 | b20ffe2b-3590-4f0a-9402-2f3a6e809b93 | entityStatement | 2019-04-24 | false | registeredEntity | SIA EcoSpoon | 2019-04-24 | 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 | ||
88433 | bbde1c09-5614-4d8c-931f-9ffc9f563008 | entityStatement | 2019-04-24 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "The Tent" | 2019-04-24 | 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 | ||
88434 | e5beb4d3-bbbc-4bfe-af5f-f954dcfae7ba | entityStatement | 2020-08-14 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "KO Auto" | 2019-04-24 | 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 | ||
88435 | 3b1a88ab-6032-4cf1-9d8c-fd9ba6472e0f | entityStatement | 2019-04-24 | false | registeredEntity | SIA E&D Metal | 2019-04-24 | 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 | ||
88436 | e12fcf13-99d3-4f7e-bbdc-cf292172e895 | entityStatement | 2019-04-24 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "FurDeco" | 2019-04-24 | 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 | ||
88437 | a15b39e1-6b70-4387-97a8-05fdd00e62e4 | entityStatement | 2019-04-24 | false | registeredEntity | SIA S&K | 2019-04-24 | 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 | ||
88438 | 1ae75722-d956-4c78-9325-297202ec587f | entityStatement | 2019-04-24 | false | registeredEntity | PfP SIA | 2019-04-24 | 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 | ||
88439 | 5c53598d-815c-4751-ad1f-19a7a728711b | entityStatement | 2019-04-24 | false | registeredEntity | SIA "Paper geek" | 2019-04-24 | 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 | ||
88440 | ffb62aaf-d5ce-4d4c-ad45-eb17524d8edc | entityStatement | 2019-04-24 | false | registeredEntity | SIA "Lotus Beauty" | 2019-04-24 | 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 | ||
88441 | 1859c878-7e93-4d1a-b158-4aa0598c1f3f | entityStatement | 2019-04-24 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "iTech Solutions" | 2019-04-24 | 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 | ||
88442 | ebc05c77-bedd-4e29-b52a-224d397e4b4a | entityStatement | 2019-04-24 | false | registeredEntity | SIA Annas Dārzs AP | 2019-04-24 | 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 | ||
88443 | e52a7348-9d7b-4d81-9e88-ae4bb9ec5632 | entityStatement | 2019-04-24 | false | registeredEntity | SIA "G&M" | 2019-04-24 | 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 | ||
88444 | 6f752436-4a22-45be-9c20-25fa8c7fe840 | entityStatement | 2019-04-24 | false | registeredEntity | SIA VIVA FLORA | 2019-04-24 | 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 | ||
88445 | 719f78ce-41d1-4e47-baba-a5d9114a7abe | entityStatement | 2019-04-24 | false | registeredEntity | SIA "GRIKS GROUP" | 2019-04-24 | 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 | ||
88446 | 062a8563-789e-45c7-a5ab-c2de903ea343 | entityStatement | 2019-04-24 | false | registeredEntity | SIA "KK International" | 2019-04-24 | 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]) );