entity_statement
33 rows where incorporatedinjurisdiction_code = "LV", "publicationdetails_publicationdate" is on date 2021-01-18 and "statementdate" is on date 2018-07-23
This data as json, CSV (advanced)
Suggested facets: 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 117968 | b5556b96-8ecc-4bd8-9e20-4e202e3a3703 | entityStatement | 2018-07-23 | true | registeredEntity | SIA "CREATOR CAPITAL PARTNERS" | 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 | |||
| 117969 | 9776e092-198f-417d-b54e-d101a3839463 | entityStatement | 2018-07-23 | true | registeredEntity | SIA "AMENIUS INVESTMENTS LIMITED" | 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 | |||
| 118250 | 32430791-586a-4cae-ac69-c33a3553a44a | entityStatement | 2018-07-23 | true | registeredEntity | "Noordam Agri Estate" SIA | 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 | |||
| 14524 | dab3d9aa-1b09-48b7-982d-a2ceb805c48d | entityStatement | 2018-07-23 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "VIVAX COMMUNICATIONS GROUP" | 2003-06-12 | 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 | ||
| 14553 | fa2e1995-0e2a-4943-b7f5-822ebfad4ff1 | entityStatement | 2018-07-23 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "APARTAMENTS" | 2003-06-20 | 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 | ||
| 20200 | 1e65455c-0d53-4968-bca7-54f971456890 | entityStatement | 2018-07-23 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "BERKON" | 2006-04-04 | 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 | ||
| 20360 | 7ec948d0-85cb-48cf-99d2-24380236ad61 | entityStatement | 2018-07-23 | false | registeredEntity | Biroja Tehnika, SIA | 2006-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 | ||
| 21743 | a45a7105-e3af-4b06-b723-c4d0730187cc | entityStatement | 2018-07-23 | false | registeredEntity | SIA "ALMEZ" | 2006-10-12 | 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 | ||
| 23483 | af2bacff-cb54-4632-8cfb-3b3bae464ca8 | entityStatement | 2018-07-23 | false | registeredEntity | SIA "FinansSoft" | 2007-04-23 | 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 | ||
| 24239 | 664c1947-3de6-468c-b6eb-d2098cce1181 | entityStatement | 2018-07-23 | false | registeredEntity | SIA Realto Mallen | 2007-07-18 | 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 | ||
| 28775 | ae90bd39-be14-45a0-8acb-e3a961aa4add | entityStatement | 2018-07-23 | false | registeredEntity | "Labākai Pasaulei" | 2018-07-23 | 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 | ||
| 28776 | 76a9ab8e-3344-4b0d-9bc0-6953c8f5d81d | entityStatement | 2018-07-23 | false | registeredEntity | "Sporta Klubs Cēsu Basketbols" | 2018-07-23 | 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 | ||
| 32805 | d47ecd5f-1c30-4404-8de7-90c552de3057 | entityStatement | 2018-07-23 | false | registeredEntity | SIA "CREATOR CAPITAL PARTNERS" | 2008-07-10 | 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 | ||
| 36547 | f51e091e-152b-4ca7-8c1a-5a1383b1f581 | entityStatement | 2018-07-23 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "JARVA" | 2010-03-02 | 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 | ||
| 38369 | d108f28a-adcd-4708-9087-a3b77c3bf474 | entityStatement | 2018-07-23 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "BP rent a car" | 2010-09-17 | 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 | ||
| 39902 | 682de53c-31bd-40a9-a015-578d8339f962 | entityStatement | 2018-07-23 | false | registeredEntity | SIA "Double 9" | 2010-12-17 | 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 | ||
| 43426 | d841f1dd-b9ad-46f9-b8ff-6d54b5f8e8c0 | entityStatement | 2018-07-23 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Makaj Foundation" | 2011-07-05 | 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 | ||
| 44424 | a7863a3b-0b39-450d-9965-b7eb63dc30ee | entityStatement | 2018-07-23 | false | registeredEntity | SIA "Akusherstvo.lv" | 2011-09-06 | 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 | ||
| 47051 | 248da872-54ef-43cf-8563-f608ae1e9e9d | entityStatement | 2018-07-23 | false | registeredEntity | "Agri-Properties" SIA | 2012-02-23 | 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 | ||
| 50461 | e3ccb09b-72df-48e0-be43-b6c4f62c3d1c | entityStatement | 2018-07-23 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "ABBI" | 2012-09-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 | ||
| 51016 | 6d192335-c41c-46e4-89fc-221c4f27eee6 | entityStatement | 2018-07-23 | false | registeredEntity | SIA "GraSan" | 2012-10-26 | 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 | ||
| 52243 | cfa45487-613d-4c73-9855-e9f131257750 | entityStatement | 2018-07-23 | false | registeredEntity | SIA "Construction Solutions" | 2013-01-21 | 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 | ||
| 52576 | fc5b9652-ec3c-4eab-bef3-52cf333c6889 | entityStatement | 2018-07-23 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Wood4U" | 2013-02-07 | 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 | ||
| 52619 | 1fe3b746-675a-442b-9900-0e54d955bcc1 | entityStatement | 2018-07-23 | false | registeredEntity | SIA "ANYPIT" | 2013-02-11 | 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 | ||
| 52788 | 20a77c1d-b0c9-44ee-87df-127b188f2f33 | entityStatement | 2018-07-23 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "SAN WINGS AVIA" | 2013-02-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 | ||
| 53960 | 7d1bcb99-965e-46de-95d2-8a92e013dab8 | entityStatement | 2018-07-23 | false | registeredEntity | SIA "ATTA print" | 2013-04-23 | 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 | ||
| 5746 | 85aab8a8-954a-426f-bb8b-86e7c7331654 | entityStatement | 2018-07-23 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "VK Mobil" | 1994-10-13 | 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 | ||
| 60715 | 604238db-4909-4426-bf92-862eb9442a1e | entityStatement | 2018-07-23 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Melngaiļa autostāvvieta" | 2014-06-11 | 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 | ||
| 61500 | e286eecd-a3da-4b53-9361-02843345b219 | entityStatement | 2018-07-23 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Juridico" | 2014-07-31 | 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 | ||
| 66627 | d0ea4a94-7551-48ec-98d8-73bad4dd7275 | entityStatement | 2018-07-23 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "VK Real" | 2015-06-03 | 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 | ||
| 67952 | c1342ee5-110f-49a6-a0ef-75f9537da67f | entityStatement | 2018-07-23 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "EURO MINING GROUP" | 2015-09-03 | 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 | ||
| 69562 | 1a6397c0-d9fd-4937-b45b-92c505ef4513 | entityStatement | 2018-07-23 | false | registeredEntity | SIA "KJV 1" | 2015-12-14 | 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 | ||
| 7725 | 868210c7-16f1-40fa-9d75-32343094735f | entityStatement | 2018-07-23 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "ZAMELSONS" | 1997-05-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 |
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]) );