entity_statement
19 rows where foundingdate = "1991-11-29", "foundingdate" is on date 1991-11-29 and iscomponent = "false"
This data as json, CSV (advanced)
Suggested facets: publicationdetails_publicationdate, statementdate (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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 103315 | 06af8275-d279-442c-b772-5d56800b087d | entityStatement | 2019-07-25 | false | registeredEntity | Zemnieku saimniecība "GASUĻI" | 1991-11-29 | 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 | ||
| 112584 | 9700d913-ef63-4a82-ba13-d4e52f68306b | entityStatement | 2017-12-28 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "GM" | 1991-11-29 | 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 | ||
| 30841 | 970dc4a5-222f-4caf-b983-bd6957d0f274 | entityStatement | 2019-07-11 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "AKVARIUS" | 1991-11-29 | 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 | ||
| 30842 | c2f91e0b-4c0a-4c62-ae4f-79b12c844d2a | entityStatement | 2019-07-11 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "RĪGAS MŪZIKAS UN KORA SKOLA" | 1991-11-29 | 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 | ||
| 30843 | c3e7c913-e978-4285-89bb-44462cc92b8f | entityStatement | 2019-07-11 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "CR & COMPANY" | 1991-11-29 | 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 | ||
| 30844 | 237c78c6-a842-49e0-92e7-a1c5b85b4bb1 | entityStatement | 2019-07-11 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "MAGI" | 1991-11-29 | 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 | ||
| 30845 | 987d9eac-9c72-49f2-9227-73a7183c30cf | entityStatement | 2019-07-11 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "S.M.R." | 1991-11-29 | 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 | ||
| 30846 | 6db1a713-0967-42bf-a970-3c27a3bac5f2 | entityStatement | 2019-07-11 | false | registeredEntity | SIA "SALTA" | 1991-11-29 | 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 | ||
| 3923 | c23b16a5-87fe-433d-951d-6352440c5a29 | entityStatement | 2018-03-06 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "KANTOR" | 1991-11-29 | 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 | ||
| 3952 | a88d4816-3db3-4509-9e89-debdeff06209 | entityStatement | 2019-07-05 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "LINDA BALTIJAS GRUPA" | 1991-11-29 | 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 | ||
| 3953 | 0ff095b2-bbb6-4752-8dc0-214f7e5774c5 | entityStatement | 2019-07-05 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "AJA-Z" | 1991-11-29 | 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 | ||
| 3954 | 5ff1a316-7655-43d7-98bd-c2fd5a00cf3f | entityStatement | 2019-07-05 | false | registeredEntity | SIA "ARHITEKTONISKĀS IZPĒTES GRUPA" | 1991-11-29 | 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 | ||
| 3959 | 425a0f50-9aec-462f-aef7-7aaa024c3257 | entityStatement | 2020-11-04 | false | registeredEntity | Akciju sabiedrība "VG KVADRA PAK" | 1991-11-29 | 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 | ||
| 3960 | e503e418-708d-4b05-a6aa-13b7beea7946 | entityStatement | 2019-07-18 | false | registeredEntity | Akciju sabiedrība "Poligrāfists" | 1991-11-29 | 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 | ||
| 3961 | 049585e1-72c0-4b1a-a415-fd2fb1174a03 | entityStatement | 2019-11-06 | false | registeredEntity | Akciju sabiedrība "RĪGAS ELEKTROMAŠĪNBŪVES RŪPNĪCA" | 1991-11-29 | 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 | ||
| 3976 | 0ec84077-359d-469f-a285-95ff116df044 | entityStatement | 2019-06-04 | false | registeredEntity | Akciju sabiedrība "KURZEMES ATSLĒGA 1" | 1991-11-29 | 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 | ||
| 3998 | 72d28b2e-ac44-4f50-b996-63b7d9031e6f | entityStatement | 2018-02-19 | false | registeredEntity | SIA "NIALATS" | 1991-11-29 | 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 | ||
| 3999 | 04c60a41-0032-4263-b877-afc1dcf48a9b | entityStatement | 2018-01-02 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "IMS" | 1991-11-29 | 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 | ||
| 98677 | 3cc05eef-ec73-491e-90b3-b97d0b3653e6 | entityStatement | 2019-07-25 | false | registeredEntity | Anitas Vecbaštikas salons "BALBIERIS" | 1991-11-29 | 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]) );