entity_statement
15 rows where publicationdetails_publicationdate = "2021-01-19" and "statementdate" is on date 2019-11-19
This data as json, CSV (advanced)
Suggested facets: iscomponent, foundingdate, incorporatedinjurisdiction_name, incorporatedinjurisdiction_code, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 100423 | 14fa5b34-dde5-4372-a377-f132176cb3ef | entityStatement | 2019-11-19 | false | registeredEntity | SIA "ML Īpašumi" | 2010-04-28 | 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 | ||
| 101145 | 2d87dee6-32f8-4d56-82ff-58c293ae6cce | entityStatement | 2019-11-19 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Inter GS" | 2013-03-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 | ||
| 103034 | 4540f776-ac83-465b-8f07-da44ea646d2e | entityStatement | 2019-11-19 | false | registeredEntity | SIA "Grand banquet" | 2019-03-05 | 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 | ||
| 106197 | c5a0a525-a5fd-4858-9289-aa7540ea9df6 | entityStatement | 2019-11-19 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "BEW" | 2018-08-08 | 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 | ||
| 112324 | 897463bb-35f6-49ff-9a49-7fd81ef370d4 | entityStatement | 2019-11-19 | false | registeredEntity | SIA Globuss financial | 2019-02-15 | 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 | ||
| 120933 | 2311e8ea-6e36-4e45-8955-456ab620d7ac | entityStatement | 2019-11-19 | true | registeredEntity | SIA "AK Family Investments" | 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 | |||
| 120934 | b9b746f6-0032-4a10-a217-41c5cc1d77f2 | entityStatement | 2019-11-19 | true | registeredEntity | Mogo Finance S.A. | Luxembourg | LU | 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 | |||
| 120935 | 4711301b-d18b-4ed6-ab76-0181ee5503fc | entityStatement | 2019-11-19 | true | registeredEntity | AS "Mogo Baltics and Caucasus" | 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 | |||
| 120936 | 6ba7acf5-424f-4f7a-8b55-d01ba60724ea | entityStatement | 2019-11-19 | true | registeredEntity | AS "mogo" | 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 | |||
| 77388 | 324fc188-9260-4e61-af2b-f6f786dfbf83 | entityStatement | 2019-11-19 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Rigahus" | 2017-05-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 | ||
| 78407 | 72ce3103-0db6-4d53-a15e-d001c9033226 | entityStatement | 2019-11-19 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "ARHIS" | 2017-08-01 | 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 | ||
| 80471 | 0d0ca302-2dc0-49c6-87c0-e0b88b46b86e | entityStatement | 2019-11-19 | false | registeredEntity | SIA "Support and Translation Services" | 2017-12-13 | 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 | ||
| 85378 | 0e4ef3f8-67c1-4ed8-9871-fd976f04f484 | entityStatement | 2019-11-19 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "AKD Trading" | 2018-10-03 | 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 | ||
| 85534 | 24a7bf41-1e78-48f0-8d9d-a0a8b28ee7b3 | entityStatement | 2019-11-19 | false | registeredEntity | AS "Renti" | 2018-10-10 | 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 | ||
| 86094 | c0823a51-9bc0-4009-b2d1-6209674f6cbc | entityStatement | 2019-11-19 | false | registeredEntity | SIA "GEMMA doktorāts" | 2018-11-15 | 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]) );