entity_statement
29 rows where "foundingdate" is on date 2015-08-06 and iscomponent = "false"
This data as json, CSV (advanced)
Suggested facets: statementdate (date), foundingdate (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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27908 | 50c8e5c2-1a0c-40e4-a744-2d4c4693caea | entityStatement | 2018-04-11 | false | registeredEntity | "Fly down wind" | 2015-08-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 | ||
| 67502 | 7c7efd19-9358-4344-89ef-a928acda6f34 | entityStatement | 2019-03-08 | false | registeredEntity | SIA "VAUKSA Latvija" | 2015-08-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 | ||
| 67503 | 013784ec-8a34-4152-bc32-2d2d7f1815e5 | entityStatement | 2019-01-16 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Every Little Thing" | 2015-08-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 | ||
| 67504 | b0ac52db-5598-4128-9b0a-62e2ffca334a | entityStatement | 2019-04-01 | false | registeredEntity | SIA "Victory Consulting" | 2015-08-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 | ||
| 67505 | 27608377-20a4-478a-ac0e-b4121c563f53 | entityStatement | 2019-07-14 | false | registeredEntity | SIA "SOLTARICO" | 2015-08-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 | ||
| 67506 | df8fd856-5ef2-4618-a199-6813bbf605c6 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Growth Race" | 2015-08-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 | ||
| 67507 | 643748c6-b17e-4dfb-8012-3e6d9fb76f9c | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Fejgale" | 2015-08-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 | ||
| 67508 | 863a2c25-5cdd-4879-acce-22c18b3dc0b0 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "JV Lingerie" | 2015-08-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 | ||
| 67509 | c3e754ad-de36-4560-a8ab-8d68a82cf5d0 | entityStatement | 2019-07-18 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "RTP HOLDING" | 2015-08-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 | ||
| 67510 | 9df70a59-6d3b-4d38-8293-08b7c1c6e19d | entityStatement | 2019-07-14 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "M. AND M." | 2015-08-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 | ||
| 67511 | 501efbaa-6d94-47ec-b202-50f0e36dc6c9 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "River's Design" | 2015-08-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 | ||
| 67512 | 2a5ed908-246f-4a23-b90d-41a3518120b8 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Ary" | 2015-08-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 | ||
| 67513 | 6c2fab25-6327-482f-97a9-c6b7f03a85fb | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Atelier M" | 2015-08-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 | ||
| 67514 | b4498dfa-b261-4015-8543-a2bde885bbcb | entityStatement | 2019-07-15 | false | registeredEntity | SIA BLASTECH | 2015-08-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 | ||
| 67515 | 567ae77e-db94-416d-a849-461c1e26a32b | entityStatement | 2019-07-14 | false | registeredEntity | SIA "Virto" | 2015-08-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 | ||
| 67516 | 1806ffd4-1031-40c6-8669-7eb46a464cf1 | entityStatement | 2019-07-14 | false | registeredEntity | SIA "Nikaserviss" | 2015-08-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 | ||
| 67517 | 0433c236-54ec-494a-a948-d0e6c158964e | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Feng Li" | 2015-08-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 | ||
| 67518 | 395e2ea3-5435-43fc-9877-49e7c14374de | entityStatement | 2019-07-14 | false | registeredEntity | SIA "FISHBEIN" | 2015-08-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 | ||
| 67519 | 6eca4ecd-ffd6-44a8-a960-e6f77e7ae78d | entityStatement | 2018-09-06 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību Portāls Andelemandele | 2015-08-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 | ||
| 67520 | b4ad2709-bcb0-4327-a2f8-561fe21c680d | entityStatement | 2019-07-14 | false | registeredEntity | SIA "ARENA CS" | 2015-08-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 | ||
| 67521 | 9b49e891-cded-48de-87ef-234eb033c294 | entityStatement | 2019-01-29 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Bruņinieku nams" | 2015-08-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 | ||
| 67522 | 98beb516-4092-46c2-a43a-440fdf3742bc | entityStatement | 2019-07-14 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "TBM INVESTMENT" | 2015-08-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 | ||
| 67523 | 564ceb1b-3131-465b-91ea-3504ab64b0e0 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Plazma Master" | 2015-08-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 | ||
| 67524 | c317ae59-ff9c-4872-8fca-821b3dc2d02b | entityStatement | 2019-07-15 | false | registeredEntity | "BRC management" SIA | 2015-08-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 | ||
| 67525 | 0f55becc-258e-4c1d-92af-f2029051499c | entityStatement | 2019-04-05 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "URBAN CAR" | 2015-08-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 | ||
| 67526 | 25491b27-8c92-409d-a13c-42971b8086f6 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Rutko" | 2015-08-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 | ||
| 67527 | 50b1f661-bdc8-4594-9c41-b389feb4b9fd | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "ARDO Tehnika" | 2015-08-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 | ||
| 67528 | 338b9852-1142-4f16-ab62-91eda987bae5 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "ALSTAV" | 2015-08-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 | ||
| 67529 | cbcf675c-b7cf-4b87-98f6-5e94d7c574f7 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "JKA Serviss" | 2015-08-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 |
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]) );