entity_statement
35 rows where "foundingdate" is on date 2012-01-17, incorporatedinjurisdiction_name = "Latvia" and iscomponent = "false"
This data as json, CSV (advanced)
Suggested facets: statementdate, publicationdetails_publicationdate
| _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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 100818 | bfd68e5e-e764-4387-afbe-fb7c29f3bf73 | entityStatement | 2019-07-15 | false | registeredEntity | SIA AGRIX AK | 2012-01-17 | 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 | ||
| 105194 | 2499de74-81b5-4f31-be5a-564858e21f63 | entityStatement | 2019-07-16 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Vecpils auto" | 2012-01-17 | 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 | ||
| 105195 | 7d2850a3-ad9f-4837-8362-42f177291de7 | entityStatement | 2019-07-16 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "ASB Mežsaimnieks" | 2012-01-17 | 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 | ||
| 105196 | 30285ad0-eca4-4630-8211-995a268d7f10 | entityStatement | 2019-07-16 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Juvit-R" | 2012-01-17 | 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 | ||
| 46430 | 3263186f-c9a5-47da-af00-73f5d2d7a311 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Pahris Entertainment" | 2012-01-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 | ||
| 46431 | 9ce9f228-79e1-494b-934f-7140cc0efac7 | entityStatement | 2019-07-12 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Hailovas intensitāte plus" | 2012-01-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 | ||
| 46432 | f5cb5484-8899-4970-b01c-e0b155554776 | entityStatement | 2020-09-30 | false | registeredEntity | SIA "Banknote" | 2012-01-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 | ||
| 46433 | 53d3162d-33e9-4cc1-9f90-95965a8bdc84 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "D.R.O.I.T." | 2012-01-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 | ||
| 46434 | 142bb666-6fe8-4b86-baf7-30f64233a981 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Tille-Olle" | 2012-01-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 | ||
| 46435 | f1e8b91a-e04a-458c-9ae0-c0ce7cce8b84 | entityStatement | 2020-07-23 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Compacta" | 2012-01-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 | ||
| 46436 | faaa5f7a-88b1-4c62-b48f-12fc569ad61e | entityStatement | 2019-07-15 | false | registeredEntity | "eXpedite" SIA | 2012-01-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 | ||
| 46437 | db51f755-11a9-4bfe-84f9-464a6060614f | entityStatement | 2019-07-15 | false | registeredEntity | SIA "STS Group" | 2012-01-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 | ||
| 46438 | 08819fda-b224-42e2-b5ba-2dcc21cd84b1 | entityStatement | 2019-05-03 | false | registeredEntity | SIA "IAR CONSULTING" | 2012-01-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 | ||
| 46439 | ee12ebc0-e41b-41a5-9337-33212801b5e7 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "BAIK auto" | 2012-01-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 | ||
| 46440 | c90cf17d-f63c-47ef-b07c-de331ea552fe | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Samofals" | 2012-01-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 | ||
| 46441 | 251112a3-6ef1-44ad-b435-a46117d65bef | entityStatement | 2019-07-12 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "AMK Grupa" | 2012-01-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 | ||
| 46442 | a5ec2d93-fd8c-4531-8d06-e4542c1e26fc | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "La Vision" | 2012-01-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 | ||
| 46443 | c53beab0-4c20-4955-a8a2-c8cf93f1089e | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Logistics 365" | 2012-01-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 | ||
| 46444 | 2e9d3416-c384-4370-9da7-a80f5a7dd445 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Edimar" | 2012-01-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 | ||
| 46445 | 8ce436a4-23ca-458e-9452-201099388b1f | entityStatement | 2019-07-15 | false | registeredEntity | SIA "BLD" | 2012-01-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 | ||
| 46446 | bb21b7ae-8222-40fc-9076-1b626a5f0860 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "VĒSMA-55" | 2012-01-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 | ||
| 46447 | c5599fe8-e2ee-4937-884f-a803f5ad6bcd | entityStatement | 2019-07-12 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Nov Avto Trans" | 2012-01-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 | ||
| 46448 | d78cbf14-8ae0-427f-b7d6-1fa22dfd0d03 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Parrot Reklāma" | 2012-01-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 | ||
| 46449 | 411c80eb-0e91-40d0-a3fe-85a764038af1 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību AVI service | 2012-01-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 | ||
| 46450 | 4cadc007-050e-40e6-9683-5d58f090e388 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "EURODOMUS CONSTRUCTION" | 2012-01-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 | ||
| 46451 | 93c45116-b541-4f76-a5a7-4e6d027405f8 | entityStatement | 2020-07-06 | false | registeredEntity | SIA "RC Būvnieks" | 2012-01-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 | ||
| 46452 | 880d8f1f-1dfc-40c1-8fee-fa49be6814b2 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Media Rock" | 2012-01-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 | ||
| 46453 | f2070444-f3bb-4d54-abe7-f70101f8ffe3 | entityStatement | 2019-07-12 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "JK6" | 2012-01-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 | ||
| 46454 | f0a78991-6583-4e59-a27f-3f3aea528bdf | entityStatement | 2019-07-15 | false | registeredEntity | SIA "ANETO" | 2012-01-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 | ||
| 46455 | 1321f303-7d94-4d91-87f8-b856a9e65eb3 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Dr. Irinas Kajunas ārsta prakse" | 2012-01-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 | ||
| 46456 | 1d986d1e-9f76-4336-9f0e-32fb74acd444 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "ADF Serviss" | 2012-01-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 | ||
| 46457 | a016af6e-f167-40da-a84b-b26ddda3c92a | entityStatement | 2019-07-15 | false | registeredEntity | SIA "SKAMITS" | 2012-01-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 | ||
| 46458 | 42f8ab75-c9db-4503-a595-b26b0944f11f | entityStatement | 2019-07-23 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Lūsis V" | 2012-01-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 | ||
| 46459 | d85690ea-46a3-4df0-9af2-00e40f3daeee | entityStatement | 2019-05-21 | false | registeredEntity | SIA "Labās balvas" | 2012-01-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 | ||
| 46460 | 89604c20-5ee4-4a63-b586-b856559bc064 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "LR Trading" | 2012-01-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 |
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]) );