venues
Data license: Compiled from official public government tourism registers · Data source: National tourism registers (BG · RO · GB · ES · FR · IE · HR · PT)
- group
- Top group: Stay / Eat & Drink / Other
- family
- Simplified family (Hotels, Guesthouses, Restaurants, Bars & Pubs…)
- venue_type
- Detailed canonical type (see the venue_types table)
- type_granularity
- 'coarse' when the source lumps several real types (e.g. UK FSA)
- rating_value
- Normalized 1–5 grade, or blank if unrated
- rating_scheme
- star / key / flower / approved / none (see rating_schemes)
- rating_label
- Original rating string from the source (provenance)
- source_type
- Original type string from the national register (provenance)
- source_category
- Original category/rating field from the register
- capacity_persons
- Comparable headline capacity — beds/guests (stay) or seats (food)
- rooms
- Number of rooms / units (accommodation)
- cert_number
- Certificate / registration number in the national register
- source
- Source register the row came from
23 rows where country = "HR" and venue_type = "aparthotel"
This data as json, CSV (advanced)
Suggested facets: rating_label, capacity_persons, rooms, city, municipality, source_category
| Link | rowid ▼ | name | country | group | family | venue_type | type_granularity | rating_value | rating_scheme | rating_label | capacity_persons | rooms | city | municipality | address | lat | lng | valid_until | stop_date | source | source_type | source_category | cert_number |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 99202 | 99202 | Adeo | HR | stay | hotels | aparthotel | normal | 4 | star | 4* | 54 | Poreč | Istarska | Stancija Molindrio 16 | HR-MINT | Aparthotel | 4* | ||||||
| 99203 | 99203 | Adrion Aparthotel | HR | stay | hotels | aparthotel | normal | 4 | star | 4* | 24 | Pula | Istarska | Puntižela 40 | HR-MINT | Aparthotel | 4* | ||||||
| 99204 | 99204 | Petram resort s depandansom | HR | stay | hotels | aparthotel | normal | 4 | star | 4* | 518 | Istarska | Vila Cijani 35, Crveni Vrh, | HR-MINT | Aparthotel | 4* | |||||||
| 99205 | 99205 | Punta Blu s depandansom Flora | HR | stay | hotels | aparthotel | normal | 4 | star | 4* | 86 | Premantura | Istarska | Selo b.b. | HR-MINT | Aparthotel | 4* | ||||||
| 99439 | 99439 | Gimi | HR | stay | hotels | aparthotel | normal | 4 | star | 4* | 19 | Primorsko-goranska | Šetalište 25. travnja 10, | HR-MINT | Aparthotel | 4* | |||||||
| 99527 | 99527 | Joel s depandansom | HR | stay | hotels | aparthotel | normal | 4 | star | 4* | 32 | Novalja | Ličko-senjska | Jadranski put 17 | HR-MINT | Aparthotel | 4* | ||||||
| 99602 | 99602 | Lekavski | HR | stay | hotels | aparthotel | normal | 3 | star | 3* | 27 | 6 | Zaton | Zadarska | Dražnikova 15, Zaton-Nin | HR-MINT | Aparthotel | 3* | |||||
| 99603 | 99603 | Tota | HR | stay | hotels | aparthotel | normal | 3 | star | 3* | 20 | 2 | Zadarska | Trg Stjepana Radića 1b, | HR-MINT | Aparthotel | 3* | ||||||
| 99711 | 99711 | Arancini Residence | HR | stay | hotels | aparthotel | normal | 4 | star | 4* | 72 | Šibensko-Kninska | Mićin Stanka 9d, | HR-MINT | Aparthotel | 4* | |||||||
| 99904 | 99904 | Amfora s depandansom | HR | stay | hotels | aparthotel | normal | 2 | star | 2* | 234 | Splitsko-dalmatinska | Europske zajednice 6, | HR-MINT | Aparthotel | 2* | |||||||
| 99905 | 99905 | Pharia | HR | stay | hotels | aparthotel | normal | 3 | star | 3* | 40 | 10 | Hvar | Splitsko-dalmatinska | Put Podstina 1 | HR-MINT | Aparthotel | 3* | |||||
| 99906 | 99906 | Flora | HR | stay | hotels | aparthotel | normal | 4 | star | 4* | 68 | Tučepi | Splitsko-dalmatinska | Dračevice 32 | HR-MINT | Aparthotel | 4* | ||||||
| 99907 | 99907 | Hotel Sol (ex Villa Džamonja) | HR | stay | hotels | aparthotel | normal | 4 | star | 4* | 60 | Bol | Splitsko-dalmatinska | Andrije Kačića Miošića 1 | HR-MINT | Aparthotel | 4* | ||||||
| 99908 | 99908 | Medistone | HR | stay | hotels | aparthotel | normal | 4 | star | 4* | 42 | 10 | Splitsko-dalmatinska | Kralja Tomislava 8, | HR-MINT | Aparthotel | 4* | ||||||
| 99909 | 99909 | Milenij | HR | stay | hotels | aparthotel | normal | 4 | star | 4* | 93 | Baška Voda | Splitsko-dalmatinska | Šetalište Kralja Petra Krešimira IV | HR-MINT | Aparthotel | 4* | ||||||
| 99910 | 99910 | Miramare | HR | stay | hotels | aparthotel | normal | 4 | star | 4* | 225 | 26 | Makarska | Splitsko-dalmatinska | Šetalište Sv. Petra 1 | HR-MINT | Aparthotel | 4* | |||||
| 99911 | 99911 | Remaneo | HR | stay | hotels | aparthotel | normal | 4 | star | 4* | 46 | Splitsko-dalmatinska | Guvno 3, | HR-MINT | Aparthotel | 4* | |||||||
| 99912 | 99912 | Sky Beach Aparthotel | HR | stay | hotels | aparthotel | normal | 4 | star | 4* | 24 | 2 | Marina | Splitsko-dalmatinska | Obala 137 | HR-MINT | Aparthotel | 4* | |||||
| 99913 | 99913 | Sunčeva postelja | HR | stay | hotels | aparthotel | normal | 4 | star | 4* | 27 | 1 | Brela | Splitsko-dalmatinska | Podraće 13 | HR-MINT | Aparthotel | 4* | |||||
| 99914 | 99914 | Tamaris | HR | stay | hotels | aparthotel | normal | 4 | star | 4* | 203 | 24 | Tučepi | Splitsko-dalmatinska | Slatina 2 | HR-MINT | Aparthotel | 4* | |||||
| 100068 | 100068 | Kalamota | HR | stay | hotels | aparthotel | normal | 4 | star | 4* | 36 | Koločep | Dubrovačko-neretvanska | Gornje Čelo 17 | HR-MINT | Aparthotel | 4* | ||||||
| 100189 | 100189 | Calypso | HR | stay | hotels | aparthotel | normal | 3 | star | 3* | 45 | 11 | Lučko | Grad Zagreb | Ventilatorska bb | HR-MINT | Aparthotel | 3* | |||||
| 100190 | 100190 | Republika | HR | stay | hotels | aparthotel | normal | 4 | star | 4* | 29 | Zagreb | Grad Zagreb | Vladimira Nazora 61 | HR-MINT | Aparthotel | 4* |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE venues ("name" TEXT, "country" TEXT, "group" TEXT, "family" TEXT, "venue_type" TEXT, "type_granularity" TEXT, "rating_value" INTEGER, "rating_scheme" TEXT, "rating_label" TEXT, "capacity_persons" INTEGER, "rooms" INTEGER, "city" TEXT, "municipality" TEXT, "address" TEXT, "lat" REAL, "lng" REAL, "valid_until" TEXT, "stop_date" TEXT, "source" TEXT, "source_type" TEXT, "source_category" TEXT, "cert_number" TEXT);
CREATE INDEX idx_country ON venues("country");
CREATE INDEX idx_group ON venues("group");
CREATE INDEX idx_family ON venues("family");
CREATE INDEX idx_venue_type ON venues("venue_type");
CREATE INDEX idx_rating_value ON venues("rating_value");
CREATE INDEX idx_rating_scheme ON venues("rating_scheme");
CREATE INDEX idx_city ON venues("city");