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
407 rows where country = "HR" and rating_value = 3
This data as json, CSV (advanced)
Suggested facets: municipality, source_type
venue_type 5
- hotel 280
- camping 74
- holiday_village_resort 28
- self_catering 21
- aparthotel 4
family 4
- hotels 284
- camping 74
- resorts 28
- self_catering_villas 21
group 1
- stay 407
country 1
- HR · 407 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 99099 | 99099 | Amfiteatar | HR | stay | hotels | hotel | normal | 3 | star | 3* | 34 | 18 | Pula | Istarska | Amfiteatarska 6 | HR-MINT | Hotel | 3* | |||||
| 99100 | 99100 | Amfora | HR | stay | hotels | hotel | normal | 3 | star | 3* | 112 | 52 | Rabac | Istarska | Rabac bb | HR-MINT | Hotel | 3* | |||||
| 99101 | 99101 | Aminess Laguna hotel (ex Laguna) | HR | stay | hotels | hotel | normal | 3 | star | 3* | 422 | 207 | Novigrad | Istarska | Tere 4 | HR-MINT | Hotel | 3* | |||||
| 99102 | 99102 | Arte Casa | HR | stay | hotels | hotel | normal | 3 | star | 3* | 16 | 8 | Umag | Istarska | Prva ulica 10, Murine | HR-MINT | Hotel | 3* | |||||
| 99103 | 99103 | Artena | HR | stay | hotels | hotel | normal | 3 | star | 3* | 42 | 18 | Istarska | Valturska ulica 12, | HR-MINT | Hotel | 3* | ||||||
| 99104 | 99104 | Aurora | HR | stay | hotels | hotel | normal | 3 | star | 3* | 31 | 11 | Pula | Istarska | Put od fortica 98 | HR-MINT | Hotel | 3* | |||||
| 99105 | 99105 | Carmen | HR | stay | hotels | hotel | normal | 3 | star | 3* | 57 | 18 | Krnica | Istarska | Luka Krnica 146 | HR-MINT | Hotel | 3* | |||||
| 99106 | 99106 | Duga Uvala (ex Croatia) | HR | stay | hotels | hotel | normal | 3 | star | 3* | 315 | 115 | Krnica | Istarska | Duga uvala 1 | HR-MINT | Hotel | 3* | |||||
| 99107 | 99107 | Paradiso (ex Filipini) | HR | stay | hotels | hotel | normal | 3 | star | 3* | 20 | 4 | Poreč | Istarska | Filipini 1 | HR-MINT | Hotel | 3* | |||||
| 99108 | 99108 | Fontana | HR | stay | hotels | hotel | normal | 3 | star | 3* | 93 | 52 | Buzet | Istarska | Trg Fontana 1 | HR-MINT | Hotel | 3* | |||||
| 99109 | 99109 | Galija | HR | stay | hotels | hotel | normal | 3 | star | 3* | 28 | 14 | Pula | Istarska | Epulonova 3 | HR-MINT | Hotel | 3* | |||||
| 99110 | 99110 | Gran Vista Plava Laguna (ex Laguna Gran Vista) | HR | stay | hotels | hotel | normal | 3 | star | 3* | 326 | 138 | Poreč | Istarska | Zelena Laguna 13 | HR-MINT | Hotel | 3* | |||||
| 99111 | 99111 | Holiday (ex Mutila) | HR | stay | hotels | hotel | normal | 3 | star | 3* | 394 | 186 | Medulin | Istarska | Osipovica 32 | HR-MINT | Hotel | 3* | |||||
| 99112 | 99112 | Istra (ex Neptun-Istra) | HR | stay | hotels | hotel | normal | 3 | star | 3* | 188 | 77 | Pula | Istarska | Veli Brijun | HR-MINT | Hotel | 3* | |||||
| 99113 | 99113 | Istra Plava Laguna | HR | stay | hotels | hotel | normal | 3 | star | 3* | 376 | 160 | Poreč | Istarska | Zelena Laguna 12 | HR-MINT | Hotel | 3* | |||||
| 99114 | 99114 | Kaštel | HR | stay | hotels | hotel | normal | 3 | star | 3* | 68 | 31 | Motovun | Istarska | Trg Andrea Antico 7 | HR-MINT | Hotel | 3* | |||||
| 99115 | 99115 | Katarina s depandansom | HR | stay | hotels | hotel | normal | 3 | star | 3* | 290 | 110 | Rovinj | Istarska | Otok Katarina 1 | HR-MINT | Hotel | 3* | |||||
| 99116 | 99116 | Koral | HR | stay | hotels | hotel | normal | 3 | star | 3* | 64 | 10 | Medulin | Istarska | Osipovica 13 | HR-MINT | Hotel | 3* | |||||
| 99117 | 99117 | Livadić | HR | stay | hotels | hotel | normal | 3 | star | 3* | 46 | 18 | Ližnjan | Istarska | Put za Marleru 5 | HR-MINT | Hotel | 3* | |||||
| 99118 | 99118 | Makin | HR | stay | hotels | hotel | normal | 3 | star | 3* | 28 | 14 | Novigrad | Istarska | Šaini 2A | HR-MINT | Hotel | 3* | |||||
| 99119 | 99119 | Marina | HR | stay | hotels | hotel | normal | 3 | star | 3* | 18 | 9 | Fažana | Istarska | Trg Stare škole2 | HR-MINT | Hotel | 3* | |||||
| 99120 | 99120 | Materada Plava Laguna (ex Laguna Materada) | HR | stay | hotels | hotel | normal | 3 | star | 3* | 806 | 361 | Poreč | Istarska | Materada 35 | HR-MINT | Hotel | 3* | |||||
| 99121 | 99121 | Mediteran Plava Laguna (ex Mediteran) | HR | stay | hotels | hotel | normal | 3 | star | 3* | 595 | 322 | Poreč | Istarska | Plava Laguna 1 | HR-MINT | Hotel | 3* | |||||
| 99122 | 99122 | Minerva | HR | stay | hotels | hotel | normal | 3 | star | 3* | 51 | 29 | Medulin | Istarska | Sad 33 | HR-MINT | Hotel | 3* | |||||
| 99123 | 99123 | Miramar Sunny Hotel & Residence (ex Miramar Sunny Plus Hotel & Residence) | HR | stay | hotels | hotel | normal | 3 | star | 3* | 340 | 155 | Rabac | Istarska | Sv. Andrije 1 | HR-MINT | Hotel | 3* | |||||
| 99124 | 99124 | Natura | HR | stay | hotels | hotel | normal | 3 | star | 3* | 22 | 11 | Umag | Istarska | Klija 18a, Vilanija | HR-MINT | Hotel | 3* | |||||
| 99125 | 99125 | Nostromo | HR | stay | hotels | hotel | normal | 3 | star | 3* | 17 | 6 | Rabac | Istarska | Obala maršala Tita 7 | HR-MINT | Hotel | 3* | |||||
| 99126 | 99126 | Park Plaza Arena s dvije depandanse Garden Suit (ex Park) | HR | stay | hotels | hotel | normal | 3 | star | 3* | 400 | 168 | Pula | Istarska | Verudela 31 | HR-MINT | Hotel | 3* | |||||
| 99127 | 99127 | Pineta | HR | stay | hotels | hotel | normal | 3 | star | 3* | 170 | 92 | Vrsar | Istarska | Pineta 1 | HR-MINT | Hotel | 3* | |||||
| 99128 | 99128 | Plavi Plava Laguna (ex Plavi) | HR | stay | hotels | hotel | normal | 3 | star | 3* | 392 | 212 | Poreč | Istarska | Zelena Laguna 10 | HR-MINT | Hotel | 3* | |||||
| 99129 | 99129 | Poreč | HR | stay | hotels | hotel | normal | 3 | star | 3* | 89 | 52 | Poreč | Istarska | Rade Končara 1 | HR-MINT | Hotel | 3* | |||||
| 99130 | 99130 | Pula | HR | stay | hotels | hotel | normal | 3 | star | 3* | 368 | 172 | Pula | Istarska | Sisplac 31 | HR-MINT | Hotel | 3* | |||||
| 99131 | 99131 | Rabac Sunny Hotel & Residence (ex Allegro Sunny Hotel & Residence) | HR | stay | hotels | hotel | normal | 3 | star | 3* | 368 | 176 | Rabac | Istarska | Sv. Andrije 4 | HR-MINT | Hotel | 3* | |||||
| 99132 | 99132 | Scaletta | HR | stay | hotels | hotel | normal | 3 | star | 3* | 22 | 12 | Pula | Istarska | Flavijevska 26 | HR-MINT | Hotel | 3* | |||||
| 99133 | 99133 | Valamar Rubin | HR | stay | hotels | hotel | normal | 3 | star | 3* | 483 | 248 | Poreč | Istarska | Brulo 3 | HR-MINT | Hotel | 3* | |||||
| 99134 | 99134 | Villa Cittar | HR | stay | hotels | hotel | normal | 3 | star | 3* | 24 | 10 | Novigrad | Istarska | Sveti Anton 4 | HR-MINT | Hotel | 3* | |||||
| 99135 | 99135 | Villa Holiday | HR | stay | hotels | hotel | normal | 3 | star | 3* | 32 | 12 | Poreč | Istarska | Buići 36 | HR-MINT | Hotel | 3* | |||||
| 99136 | 99136 | Villa Vrsar | HR | stay | hotels | hotel | normal | 3 | star | 3* | 35 | 9 | Vrsar | Istarska | Brostolade 23 | HR-MINT | Hotel | 3* | |||||
| 99137 | 99137 | Vista | HR | stay | hotels | hotel | normal | 3 | star | 3* | 86 | 28 | Poreč | Istarska | Rade Končara 52 | HR-MINT | Hotel | 3* | |||||
| 99138 | 99138 | Zlatna vala | HR | stay | hotels | hotel | normal | 3 | star | 3* | 19 | 10 | Umag | Istarska | Svetog Ivana 45 | HR-MINT | Hotel | 3* | |||||
| 99139 | 99139 | Zorna | HR | stay | hotels | hotel | normal | 3 | star | 3* | 377 | 207 | Poreč | Istarska | Zelena Laguna 15 | HR-MINT | Hotel | 3* | |||||
| 99208 | 99208 | Centinera | HR | stay | resorts | holiday_village_resort | normal | 3 | star | 3* | 326 | 139 | Banjole | Istarska | Indije 1 | HR-MINT | Turističko naselje | 3* | |||||
| 99209 | 99209 | Del Mar Emotion | HR | stay | resorts | holiday_village_resort | normal | 3 | star | 3* | 604 | 30 | Istarska | Put za Puntice 102, | HR-MINT | Turističko naselje | 3* | ||||||
| 99210 | 99210 | Funtana | HR | stay | resorts | holiday_village_resort | normal | 3 | star | 3* | 444 | 220 | Funtana | Istarska | Valkanela 2 | HR-MINT | Turističko naselje | 3* | |||||
| 99211 | 99211 | Park Plaza Verudela (ex Punta Plaza Verudela) | HR | stay | resorts | holiday_village_resort | normal | 3 | star | 3* | 651 | Pula | Istarska | Ulica Verudela 11 | HR-MINT | Turističko naselje | 3* | ||||||
| 99212 | 99212 | Savudrija | HR | stay | resorts | holiday_village_resort | normal | 3 | star | 3* | 444 | 107 | Savudrija | Istarska | Mojmirska 22 | HR-MINT | Turističko naselje | 3* | |||||
| 99213 | 99213 | Sol Polynesia | HR | stay | resorts | holiday_village_resort | normal | 3 | star | 3* | 1174 | Umag | Istarska | 52470 Umag | HR-MINT | Turističko naselje | 3* | ||||||
| 99214 | 99214 | Solaris Camping Resort (ex Solaris) | HR | stay | resorts | holiday_village_resort | normal | 3 | star | 3* | 568 | 128 | Tar | Istarska | Solaris 1 | HR-MINT | Turističko naselje | 3* | |||||
| 99215 | 99215 | Valalta | HR | stay | resorts | holiday_village_resort | normal | 3 | star | 3* | 918 | 219 | Rovinj | Istarska | Cesta za Valaltu - Lim 7 | HR-MINT | Turističko naselje | 3* | |||||
| 99216 | 99216 | Villas Rubin | HR | stay | resorts | holiday_village_resort | normal | 3 | star | 3* | 909 | 85 | Rovinj | Istarska | Villas Rubin 1 | HR-MINT | Turističko naselje | 3* | |||||
| 99238 | 99238 | Bi Village | HR | stay | self_catering_villas | self_catering | normal | 3 | star | 3* | 786 | Fažana | Istarska | Dragonja 115 | HR-MINT | Turistički apartmani | 3* | ||||||
| 99239 | 99239 | Rabac Sunny Hotel & Residence (ex Miramar Sunny Hotel & Residence by Valamar) | HR | stay | self_catering_villas | self_catering | normal | 3 | star | 3* | 27 | Rabac | Istarska | Sv. Andrije 1 | HR-MINT | Turistički apartmani | 3* | ||||||
| 99240 | 99240 | Riva | HR | stay | self_catering_villas | self_catering | normal | 3 | star | 3* | 81 | Vrsar | Istarska | Obala maršala Tita 27b | HR-MINT | Turistički apartmani | 3* | ||||||
| 99241 | 99241 | Stella Plava Laguna | HR | stay | self_catering_villas | self_catering | normal | 3 | star | 3* | 537 | Umag | Istarska | Stella Maris 8A | HR-MINT | Turistički apartmani | 3* | ||||||
| 99242 | 99242 | Splendid (ex Horizont Splendid) | HR | stay | self_catering_villas | self_catering | normal | 3 | star | 3* | 595 | Pula | Istarska | Verudela 6b | HR-MINT | Turistički apartmani | 3* | ||||||
| 99243 | 99243 | Valamar Diamant Hotel & Residence (ex Residence Valamar Diamant) | HR | stay | self_catering_villas | self_catering | normal | 3 | star | 3* | 368 | Poreč | Istarska | Brulo 1/1 | HR-MINT | Turistički apartmani | 3* | ||||||
| 99244 | 99244 | Verudela Beach & Villa Resort (ex Europa) | HR | stay | self_catering_villas | self_catering | normal | 3 | star | 3* | 468 | Pula | Istarska | Verudela 11 | HR-MINT | Turistički apartmani | 3* | ||||||
| 99258 | 99258 | Arena Medulin Campsite (ex Medulin) | HR | stay | camping | camping | normal | 3 | star | 3* | Medulin | Istarska | Osipovica 30 | HR-MINT | Kamp | 3* | |||||||
| 99259 | 99259 | Camping Finida (ex Finida) | HR | stay | camping | camping | normal | 3 | star | 3* | Umag | Istarska | Križine 55a | HR-MINT | Kamp | 3* | |||||||
| 99260 | 99260 | Centinera | HR | stay | camping | camping | normal | 3 | star | 3* | 15 | Banjole | Istarska | Indije 1 | HR-MINT | Kamp | 3* | ||||||
| 99261 | 99261 | Kastanija | HR | stay | camping | camping | normal | 3 | star | 3* | Novigrad | Istarska | Kastanija bb | HR-MINT | Kamp | 3* | |||||||
| 99262 | 99262 | Kranjski kamp | HR | stay | camping | camping | normal | 3 | star | 3* | 69 | Pula | Istarska | Runke 52 | HR-MINT | Kamp | 3* | ||||||
| 99263 | 99263 | Mali kamp Funtana | HR | stay | camping | camping | normal | 3 | star | 3* | Funtana | Istarska | Istarska 2A | HR-MINT | Kamp | 3* | |||||||
| 99264 | 99264 | Oliva | HR | stay | camping | camping | normal | 3 | star | 3* | 130 | Rabac | Istarska | Maslinica 1 | HR-MINT | Kamp | 3* | ||||||
| 99265 | 99265 | Orsera Camping Resort by Valamar (ex Orsera) | HR | stay | camping | camping | normal | 3 | star | 3* | 55 | Vrsar | Istarska | Sv. Martin 2/1 | HR-MINT | Kamp | 3* | ||||||
| 99266 | 99266 | Vita Mia | HR | stay | camping | camping | normal | 3 | star | 3* | 6 | Istarska | Pazin, Lindar 131B | HR-MINT | Kamp | 3* | |||||||
| 99267 | 99267 | Peškera | HR | stay | camping | camping | normal | 3 | star | 3* | 49 | Banjole | Istarska | Indije 73 | HR-MINT | Kamp | 3* | ||||||
| 99268 | 99268 | Puntica | HR | stay | camping | camping | normal | 3 | star | 3* | 30 | Poreč | Istarska | Puntica 3 | HR-MINT | Kamp | 3* | ||||||
| 99269 | 99269 | Rojnić | HR | stay | camping | camping | normal | 3 | star | 3* | 8 | Banjole | Istarska | Dvorine 26a | HR-MINT | Kamp | 3* | ||||||
| 99270 | 99270 | Solaris Camping by Valamar (skraćeno: Solaris Camping Resort) | HR | stay | camping | camping | normal | 3 | star | 3* | 670 | Tar | Istarska | Ulica Solaris 1 | HR-MINT | Kamp | 3* | ||||||
| 99271 | 99271 | Vela Stina Camping | HR | stay | camping | camping | normal | 3 | star | 3* | Istarska | Stanica Roč 75, | HR-MINT | Kamp | 3* | ||||||||
| 99272 | 99272 | Veli Jože | HR | stay | camping | camping | normal | 3 | star | 3* | 101 | Savudrija | Istarska | Borozija 3c | HR-MINT | Kamp | 3* | ||||||
| 99322 | 99322 | AD Turres | HR | stay | hotels | hotel | normal | 3 | star | 3* | 80 | 40 | Crikvenica | Primorsko-goranska | Kralja Tomislava 111 | HR-MINT | Hotel | 3* | |||||
| 99323 | 99323 | Adria | HR | stay | hotels | hotel | normal | 3 | star | 3* | 74 | 38 | Malinska | Primorsko-goranska | Obala 40 | HR-MINT | Hotel | 3* | |||||
| 99324 | 99324 | Amadria Park Hotel Continetal s dep. Villa Continental (ex Gardenija s depandansom Continental) | HR | stay | hotels | hotel | normal | 3 | star | 3* | 153 | 73 | Opatija | Primorsko-goranska | Maršala Tita 85 | HR-MINT | Hotel | 3* | |||||
| 99325 | 99325 | Aminess Magal Hotel (ex Beli Kamik) | HR | stay | hotels | hotel | normal | 3 | star | 3* | 729 | 375 | Njivice | Primorsko-goranska | Primorska cesta 40 | HR-MINT | Hotel | 3* | |||||
| 99326 | 99326 | Aminess Veya Hotel (ex Jadran) | HR | stay | hotels | hotel | normal | 3 | star | 3* | 425 | 223 | Njivice | Primorsko-goranska | Primorska cesta 29 | HR-MINT | Hotel | 3* | |||||
| 99327 | 99327 | Argentum | HR | stay | hotels | hotel | normal | 3 | star | 3* | 22 | 11 | Vrbnik | Primorsko-goranska | Supec 68 | HR-MINT | Hotel | 3* | |||||
| 99328 | 99328 | Bor | HR | stay | hotels | hotel | normal | 3 | star | 3* | 70 | 34 | Krk | Primorsko-goranska | Šetalište Dražica 5 | HR-MINT | Hotel | 3* | |||||
| 99329 | 99329 | Continental | HR | stay | hotels | hotel | normal | 3 | star | 3* | 138 | 73 | Rijeka | Primorsko-goranska | Šetalište Andrije Kačića Miošića 1 | HR-MINT | Hotel | 3* | |||||
| 99330 | 99330 | Corinthia Baška Sunny Hotel by Valamar | HR | stay | hotels | hotel | normal | 3 | star | 3* | 888 | 267 | Baška | Primorsko-goranska | Emila Geistlicha 39 | HR-MINT | Hotel | 3* | |||||
| 99331 | 99331 | Dobrovit (ex Tamaris) | HR | stay | hotels | hotel | normal | 3 | star | 3* | 81 | 19 | Baška | Primorsko-goranska | Emila Geistlicha 54b | HR-MINT | Hotel | 3* | |||||
| 99332 | 99332 | Dražica s depandansama Tamaris i Lovorika | HR | stay | hotels | hotel | normal | 3 | star | 3* | 482 | 188 | Krk | Primorsko-goranska | Ružmarinska 6 | HR-MINT | Hotel | 3* | |||||
| 99333 | 99333 | Epario | HR | stay | hotels | hotel | normal | 3 | star | 3* | 38 | 20 | Rab | Primorsko-goranska | Lopar 456 a | HR-MINT | Hotel | 3* | |||||
| 99334 | 99334 | Esperanto | HR | stay | hotels | hotel | normal | 3 | star | 3* | 74 | 26 | Selce | Primorsko-goranska | Emila Antića 24 | HR-MINT | Hotel | 3* | |||||
| 99335 | 99335 | Galeb | HR | stay | hotels | hotel | normal | 3 | star | 3* | 52 | 20 | Opatija | Primorsko-goranska | Maršala Tita 160 | HR-MINT | Hotel | 3* | |||||
| 99336 | 99336 | Hotel Kristal | HR | stay | hotels | hotel | normal | 3 | star | 3* | 227 | 130 | Primorsko-goranska | Maršala Tita 135, | HR-MINT | Hotel | 3* | ||||||
| 99337 | 99337 | Hotel Villa Aurora | HR | stay | hotels | hotel | normal | 3 | star | 3* | 47 | 20 | Primorsko-goranska | Ante Starčevića 32, | HR-MINT | Hotel | 3* | ||||||
| 99338 | 99338 | Hotel Stanger | HR | stay | hotels | hotel | normal | 3 | star | 3* | 43 | 19 | Lovran | Primorsko-goranska | Šetalište maršala Tita 128 | HR-MINT | Hotel | 3* | |||||
| 99339 | 99339 | International (ex Ros Maris) | HR | stay | hotels | hotel | normal | 3 | star | 3* | 260 | 130 | Rab | Primorsko-goranska | Obala kralja Petra Krešimira IV 4 | HR-MINT | Hotel | 3* | |||||
| 99340 | 99340 | Istra | HR | stay | hotels | hotel | normal | 3 | star | 3* | 319 | 168 | Opatija | Primorsko-goranska | Ulica maršala Tita 145 | HR-MINT | Hotel | 3* | |||||
| 99341 | 99341 | Istra | HR | stay | hotels | hotel | normal | 3 | star | 3* | 186 | 99 | Rab | Primorsko-goranska | Šetalište Markantuna Dominisa bb | HR-MINT | Hotel | 3* | |||||
| 99342 | 99342 | Kaštel | HR | stay | hotels | hotel | normal | 3 | star | 3* | 178 | 66 | Crikvenica | Primorsko-goranska | Frankopanska 22 | HR-MINT | Hotel | 3* | |||||
| 99343 | 99343 | Kimen s depandansom | HR | stay | hotels | hotel | normal | 3 | star | 3* | 388 | 195 | Cres | Primorsko-goranska | Melin 1/16 | HR-MINT | Hotel | 3* | |||||
| 99344 | 99344 | Krk Sunny Hotel by Valamar (ex Valamar Koralj) | HR | stay | hotels | hotel | normal | 3 | star | 3* | 394 | 173 | Krk | Primorsko-goranska | Vlade Tomašića 38 | HR-MINT | Hotel | 3* | |||||
| 99345 | 99345 | Kul In Ablana | HR | stay | hotels | hotel | normal | 3 | star | 3* | 55 | 22 | Primorsko-goranska | Obala bana Stjepana Šubića 1, Jablanac | HR-MINT | Hotel | 3* | ||||||
| 99346 | 99346 | Lovran | HR | stay | hotels | hotel | normal | 3 | star | 3* | 105 | 53 | Lovran | Primorsko-goranska | Šetalište Maršala Tita 19/2 | HR-MINT | Hotel | 3* | |||||
| 99347 | 99347 | Lungomare (ex Residenz) | HR | stay | hotels | hotel | normal | 3 | star | 3* | 89 | 49 | Opatija | Primorsko-goranska | Maršala Tita 133 | HR-MINT | Hotel | 3* | |||||
| 99348 | 99348 | Mance | HR | stay | hotels | hotel | normal | 3 | star | 3* | 14 | 6 | Brod na Kupi | Primorsko-goranska | Trg kralja Tomislava 2 | HR-MINT | Hotel | 3* | |||||
| 99349 | 99349 | Mediteran | HR | stay | hotels | hotel | normal | 3 | star | 3* | 135 | 69 | Mošćenička Draga | Primorsko-goranska | Trg slobode 1 | HR-MINT | Hotel | 3* |
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");