entity_statement
39 rows where "foundingdate" is on date 2018-10-19
This data as json, CSV (advanced)
_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
102580 | 7526d230-0880-4170-b834-60d3b1041bfd | entityStatement | 2018-10-19 | false | registeredEntity | SIA "Bernitz Realty" | 2018-10-19 | 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 | ||
102581 | 74c4e8e2-1414-4d99-b876-42a0cb25955c | entityStatement | 2018-10-19 | false | registeredEntity | SIA "NBBQ" | 2018-10-19 | 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 | ||
102582 | 7f94b4e6-65e2-4c7f-95f0-3654fb43fddd | entityStatement | 2018-10-19 | false | registeredEntity | SIA "D-aset" | 2018-10-19 | 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 | ||
106243 | ba8a1851-2824-4400-bf95-60031f570d8c | entityStatement | 2018-10-19 | false | registeredEntity | SIA "VERUM G" | 2018-10-19 | 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 | ||
106244 | 8b9c5c8f-85cb-4699-9eec-8df2202eab47 | entityStatement | 2018-10-19 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Candy Land" | 2018-10-19 | 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 | ||
29009 | be74eb88-c09b-4c32-bd65-c6ce045d0966 | entityStatement | false | registeredEntity | "Baltijas Inovāciju māja" | 2018-10-19 | 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 | |||
29010 | 77f9d9c5-bc7c-4f4b-8181-f1ef33d7ebf3 | entityStatement | false | registeredEntity | Biedrība "Ramaņa 7" | 2018-10-19 | 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 | |||
29011 | 995f5e2b-6a8a-470c-9b60-9d2f758246a2 | entityStatement | false | registeredEntity | Nodibinājums "DRAUGI" | 2018-10-19 | 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 | |||
29012 | 2410aa8c-86be-460f-bb4e-1339c2a5ca33 | entityStatement | 2018-10-19 | false | registeredEntity | "Miera 91" | 2018-10-19 | 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 | ||
29013 | c3c4e102-50b6-458f-928c-37870cb90b03 | entityStatement | false | registeredEntity | Elpas Telpa | 2018-10-19 | 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 | |||
29014 | 64a64788-6a8d-4fdc-a27a-fca885c7535d | entityStatement | false | registeredEntity | Futbola klubs Valor Rīga | 2018-10-19 | 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 | |||
29015 | 5fc01713-60ae-4428-8494-88808f869678 | entityStatement | false | registeredEntity | "Latvian-Chinese Development Association" | 2018-10-19 | 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 | |||
85707 | 36f8b486-a3b1-47ce-b2a2-b4981779df69 | entityStatement | 2020-02-21 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "SUPER MM" | 2018-10-19 | 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 | ||
85708 | 5717782b-3c69-44ee-aeee-42a121e014b5 | entityStatement | 2018-10-19 | false | registeredEntity | SIA "AB International" | 2018-10-19 | 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 | ||
85709 | e1a4e507-3ba8-44f6-8f55-82d98e71973f | entityStatement | 2018-10-19 | false | registeredEntity | SIA ELBE | 2018-10-19 | 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 | ||
85710 | b73929e8-6619-446e-8149-4e52ed0f3f3d | entityStatement | 2018-10-19 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "FIORI ziedi" | 2018-10-19 | 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 | ||
85711 | 25732ce4-b8e4-485d-a09d-3c0c1c757115 | entityStatement | 2018-10-19 | false | registeredEntity | SIA NEDEX | 2018-10-19 | 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 | ||
85712 | 440dec13-3b20-40a1-8bb0-173f78c79dfa | entityStatement | 2018-10-19 | false | registeredEntity | SIA "SalonVīns" | 2018-10-19 | 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 | ||
85713 | 32557d2e-8375-4fdf-a340-8789e2a078cf | entityStatement | 2018-11-09 | false | registeredEntity | SIA "KJB" | 2018-10-19 | 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 | ||
85714 | 81b8add3-e834-4e66-a0da-2a5ba58e313d | entityStatement | 2018-10-19 | false | registeredEntity | SIA PLAYERS | 2018-10-19 | 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 | ||
85715 | 2ac35475-19a7-4597-9e42-1a46e142dfdc | entityStatement | 2020-03-05 | false | registeredEntity | SIA "STREETFOOD LATVIA" | 2018-10-19 | 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 | ||
85716 | bc5be3b5-388f-4289-8cb0-c8f300f64493 | entityStatement | 2018-10-19 | false | registeredEntity | SIA "Line arhitekti" | 2018-10-19 | 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 | ||
85717 | 28d72c79-68d2-4cf1-8548-beb33404b82e | entityStatement | 2019-07-12 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "5Road" | 2018-10-19 | 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 | ||
85718 | 08ad41b2-9fea-4c01-94bd-8cd8871e9ff0 | entityStatement | 2018-10-19 | false | registeredEntity | SIA "Motivācija" | 2018-10-19 | 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 | ||
85719 | b98284a0-59d0-4276-853e-37fee4a0d0a7 | entityStatement | 2019-07-03 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Levorg" | 2018-10-19 | 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 | ||
85720 | 4f4d2649-a3b7-488d-875d-b884077bac90 | entityStatement | 2018-12-11 | false | registeredEntity | SIA Baltic birch wave | 2018-10-19 | 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 | ||
85721 | c0316690-2296-45fd-92c8-52ba605396ab | entityStatement | 2018-10-19 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "ELZAVIRS" | 2018-10-19 | 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 | ||
85722 | e7a804c2-6cc2-4c73-b94d-1518ee58e2ad | entityStatement | 2018-10-19 | false | registeredEntity | SIA "FLOWER CAFE" | 2018-10-19 | 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 | ||
85723 | e769b99a-4b4e-49f2-ae7a-6672698be970 | entityStatement | 2018-10-19 | false | registeredEntity | SIA CarHouse | 2018-10-19 | 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 | ||
85724 | 998dca5c-63e1-443c-9415-181f68db9d66 | entityStatement | 2019-03-15 | false | registeredEntity | SIA "LAUNDRY BOX" | 2018-10-19 | 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 | ||
85725 | 42c7635b-c061-4e99-b70d-8a92e1fa600d | entityStatement | 2018-10-19 | false | registeredEntity | SIA "Friday" | 2018-10-19 | 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 | ||
85726 | 35c7b72a-5a22-4c59-b972-d6f318cbba8b | entityStatement | 2018-10-19 | false | registeredEntity | SIA AR Print | 2018-10-19 | 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 | ||
85727 | 934753a4-2cdb-4788-bfed-7d2e48e2ac10 | entityStatement | 2019-02-22 | false | registeredEntity | SIA We Baltics | 2018-10-19 | 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 | ||
85728 | 420194b4-daa7-445e-893c-ba00efaba04b | entityStatement | 2018-10-19 | false | registeredEntity | SIA Domina IT | 2018-10-19 | 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 | ||
85729 | 1c212cef-a83c-4a94-856f-5a78c8189860 | entityStatement | 2018-10-19 | false | registeredEntity | SIA "Best Movies" | 2018-10-19 | 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 | ||
85730 | 32970ded-7d40-47af-a980-f2ab3b0e8be9 | entityStatement | 2018-10-19 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Inspirational" | 2018-10-19 | 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 | ||
92579 | 549b397c-e75d-49f5-a77b-4ce207fb0540 | entityStatement | 2018-10-19 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "MMM Bygg" | 2018-10-19 | 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 | ||
92580 | e6c01010-2fbc-418b-92b5-6b9f474088a4 | entityStatement | 2018-10-19 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "MV Bygg" | 2018-10-19 | 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 | ||
92581 | 54b0f146-f3ce-4641-b122-805d21f38868 | entityStatement | 2018-10-19 | false | registeredEntity | SIA "Aurum Private" | 2018-10-19 | 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]) );