entity_statement
7 rows where iscomponent = "true" and "statementdate" is on date 2020-03-06
This data as json, CSV (advanced)
Suggested facets: incorporatedinjurisdiction_name, incorporatedinjurisdiction_code, publicationdetails_publicationdate, statementdate (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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 115197 | 3256d286-e16f-48ab-a5a8-da1fb017d4cb | entityStatement | 2020-03-06 | true | registeredEntity | Janmon AB | Sweden | SE | 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 | |||
| 115198 | 71dc8e9e-3ce7-484c-b4b8-215dd8431994 | entityStatement | 2020-03-06 | true | registeredEntity | Aktiebolaget Halmstads Gummifabrik | Sweden | SE | 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 | |||
| 118221 | b893c3e4-bae2-48a4-9828-be86a2e537dc | entityStatement | 2020-03-06 | true | registeredEntity | Sabiedrība ar ierobežotu atbildību "Tair ABB" | 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 | |||
| 118222 | 65f34672-9587-444a-b898-32221d03239a | entityStatement | 2020-03-06 | true | registeredEntity | Sabiedrība ar ierobežotu atbildību "RONON HOTELS GROUP" | 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 | |||
| 118223 | 37108890-5dd7-447f-b070-b84b480d42e0 | entityStatement | 2020-03-06 | true | registeredEntity | Sabiedrība ar ierobežotu atbildību "DL SERVICE" | 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 | |||
| 120908 | 1b50bb3d-9a54-46ad-8c4d-5b0a2880dc75 | entityStatement | 2020-03-06 | true | registeredEntity | LIVING WATER JMZ SL | Spain | ES | 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 | |||
| 120909 | edf77fca-1d55-4bb3-a4e5-68c91cb0f77e | entityStatement | 2020-03-06 | true | registeredEntity | WORLDFOOD TO GO SL | Spain | ES | 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]) );