venues

Data license: Compiled from official public government tourism registers · Data source: National tourism registers (BG · RO · GB · ES · FR · PT · PL · IE · HR · GR · ME)

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)
best_for
The single event this venue is best suited to (blank = not an event venue)
fit_wedding
Wedding-suitability score 0–100 (type + capacity + rating)
fit_conference
Conference-suitability score 0–100
fit_banquet
Banquet-suitability score 0–100
fit_spa
Spa-retreat-suitability score 0–100
fit_party
Party/celebration-suitability score 0–100
common_areas
On-site shared function space, from the register only (event_venue) — blank = not stated, never inferred
reachability_score
How easy to reach 0–100 (nearer airport + city = higher)
isolation_score
How remote 0–100 (farther from towns + fewer nearby venues = higher)
airport_km
Distance to nearest airport (km)
nearest_airport
Nearest airport (IATA or name)
city_km
Distance to nearest city ≥15k people (km)
town_km
Distance to nearest settlement ≥500 people (km)
venues_5km
Number of other venues within 5 km (local density)
cert_number
Certificate / registration number in the national register
source
Source register the row came from

69 rows where best_for = "wedding", country = "HR" and family = "resorts"

This data as json, CSV (advanced)

Suggested facets: rating_label, fit_wedding, fit_banquet, fit_spa, reachability_score, isolation_score, nearest_airport, town_km, venues_5km, municipality, source_category

rating_value 4

group 1

family 1

  • resorts · 69 ✖

country 1

best_for 1

  • wedding · 69 ✖

common_areas 0

Link rowid ▼ name country group family venue_type type_granularity rating_value rating_scheme rating_label capacity_persons rooms best_for fit_wedding fit_conference fit_banquet fit_spa fit_party common_areas reachability_score isolation_score airport_km nearest_airport city_km town_km venues_5km city municipality address lat lng valid_until stop_date source source_type source_category cert_number
820895 820895 Kanegra HR stay resorts holiday_village_resort normal 2 star 2* 677   wedding 80 0 60 0 0   70 30 11.6 POW 23.7 5.5 18 Umag Istarska Kanegra 2 45.3828 13.5379     HR-MINT Turističko naselje 2*  
820896 820896 Koversada Rooms (ex Villas Koversada) HR stay resorts holiday_village_resort normal 2 star 2* 432 216 wedding 80 0 60 0 0   45 10 35.9 POW 36.6 0.0 15 Vrsar Istarska Koversada 2 45.14917 13.60528     HR-MINT Turističko naselje 2*  
820897 820897 Centinera HR stay resorts holiday_village_resort normal 3 star 3* 326 139 wedding 90 0 60 0 0   80 0 2.8 PUY 5.4 0.0 33 Banjole Istarska Indije 1 44.8689 13.9161     HR-MINT Turističko naselje 3*  
820898 820898 Del Mar Emotion HR stay resorts holiday_village_resort normal 3 star 3* 604 30 wedding 90 0 60 0 0                   Istarska Put za Puntice 102,         HR-MINT Turističko naselje 3*  
820899 820899 Funtana HR stay resorts holiday_village_resort normal 3 star 3* 444 220 wedding 90 0 60 0 0   45 10 33.1 POW 39.1 0.0 15 Funtana Istarska Valkanela 2 45.17472 13.605     HR-MINT Turističko naselje 3*  
820900 820900 Park Plaza Verudela (ex Punta Plaza Verudela) HR stay resorts holiday_village_resort normal 3 star 3* 651   wedding 90 0 60 0 0   80 0 2.8 PUY 5.4 0.0 33 Pula Istarska Ulica Verudela 11 44.8689 13.9161     HR-MINT Turističko naselje 3*  
820901 820901 Savudrija HR stay resorts holiday_village_resort normal 3 star 3* 444 107 wedding 90 0 60 0 0   70 40 9.2 POW 18.3 5.9 4 Savudrija Istarska Mojmirska 22 45.50009 13.50559     HR-MINT Turističko naselje 3*  
820902 820902 Sol Polynesia HR stay resorts holiday_village_resort normal 3 star 3* 1174   wedding 90 0 60 0 0   70 30 11.6 POW 23.7 5.5 18 Umag Istarska 52470 Umag 45.3828 13.5379     HR-MINT Turističko naselje 3*  
820903 820903 Solaris Camping Resort (ex Solaris) HR stay resorts holiday_village_resort normal 3 star 3* 568 128 wedding 90 0 60 0 0   70 20 19.1 POW 28.7 0.0 5 Tar Istarska Solaris 1 45.30083 13.62528     HR-MINT Turističko naselje 3*  
820904 820904 Valalta HR stay resorts holiday_village_resort normal 3 star 3* 918 219 wedding 90 0 60 0 0   70 0 28.7 PUY 28.4 0.0 21 Rovinj Istarska Cesta za Valaltu - Lim 7 45.1064 13.7156     HR-MINT Turističko naselje 3*  
820905 820905 Villas Rubin HR stay resorts holiday_village_resort normal 3 star 3* 909 85 wedding 90 0 60 0 0   70 0 28.7 PUY 28.4 0.0 21 Rovinj Istarska Villas Rubin 1 45.1064 13.7156     HR-MINT Turističko naselje 3*  
820906 820906 Amarin HR stay resorts holiday_village_resort normal 4 star 4* 1208   wedding 100 0 70 60 0   70 0 28.7 PUY 28.4 0.0 21 Rovinj Istarska T.N. "Monsena" 2 45.1064 13.7156     HR-MINT Turističko naselje 4*  
820907 820907 Bellevue Plava Laguna (ex Laguna Bellevue) HR stay resorts holiday_village_resort normal 4 star 4* 685   wedding 100 0 70 60 0   60 10 28.0 POW 35.3 3.8 39 Poreč Istarska Plava Laguna 10 45.2305 13.7186     HR-MINT Turističko naselje 4*  
820908 820908 Belvedere HR stay resorts holiday_village_resort normal 4 star 4* 706 134 wedding 100 0 70 60 0   45 10 35.9 POW 36.6 0.0 15 Vrsar Istarska Petalon 1 45.14917 13.60528     HR-MINT Turističko naselje 4*  
820909 820909 Galijot (ex Laguna Galijot) HR stay resorts holiday_village_resort normal 4 star 4* 642 149 wedding 100 0 70 60 0   60 10 28.0 POW 35.3 3.8 39 Poreč Istarska Plava Laguna 18 45.2305 13.7186     HR-MINT Turističko naselje 4*  
820910 820910 Garden Suites & Rooms Sol Umag HR stay resorts holiday_village_resort normal 4 star 4* 108 18 wedding 90 0 60 60 0   70 30 11.6 POW 23.7 5.5 18 Umag Istarska Šetalište Miramare 1 45.3828 13.5379     HR-MINT Turističko naselje 4*  
820911 820911 Istrian Villas Plava Laguna (ex Melia Istrian Villas) HR stay resorts holiday_village_resort normal 4 star 4* 558   wedding 100 0 70 60 0   70 30 11.6 POW 23.7 5.5 18 Umag Istarska Stella Maris 8a 45.3828 13.5379     HR-MINT Turističko naselje 4*  
820912 820912 Park Plava Laguna (ex Laguna Park) HR stay resorts holiday_village_resort normal 4 star 4* 438   wedding 100 0 70 60 0   60 10 28.0 POW 35.3 3.8 39 Poreč Istarska Špadići 15b 45.2305 13.7186     HR-MINT Turističko naselje 4*  
820913 820913 Petalon HR stay resorts holiday_village_resort normal 4 star 4* 456 176 wedding 100 0 70 60 0   45 10 35.9 POW 36.6 0.0 15 Vrsar Istarska Petalon 5 45.14917 13.60528     HR-MINT Turističko naselje 4*  
820914 820914 Resort & beer spa San Servolo HR stay resorts holiday_village_resort normal 4 star 4* 38 14 wedding 80 0 40 60 0   70 30 11.2 POW 16.3 2.5 4 Buje Istarska Momjanska ulica 7a 45.4015 13.7191     HR-MINT Turističko naselje 4*  
820915 820915 Apartments Amfora Plava Laguna (ex Sol Stella Maris) HR stay resorts holiday_village_resort normal 4 star 4* 574   wedding 100 0 70 60 0   70 30 11.6 POW 23.7 5.5 18 Umag Istarska Stella Maris 8a 45.3828 13.5379     HR-MINT Turističko naselje 4*  
820916 820916 Girandella Resort, Valamar Collection (ex Valamar Collection Girandella Resort) HR stay resorts holiday_village_resort normal 4 star 4* 391 164 wedding 100 0 70 60 0                   Istarska Girandella 7         HR-MINT Turističko naselje 4*  
820917 820917 Valamar Collection Isabella Island Resort (ex Island Hotel Fortuna) HR stay resorts holiday_village_resort normal 4 star 4* 210 90 wedding 100 0 70 60 0   60 10 28.0 POW 35.3 3.8 39 Poreč Istarska Otok Sv. Nikola 45.2305 13.7186     HR-MINT Turističko naselje 4*  
820918 820918 TN San Canzian Hotel & Residences (ex San Canzian Village & Hotel) HR stay resorts holiday_village_resort normal 5 star 5* 50 21 wedding 80 0 50 70 0   70 30 11.2 POW 16.3 2.5 4 Buje Istarska Mužolini Donji br. 2,3,3A,4 i 7 45.4015 13.7191     HR-MINT Turističko naselje 5*  
820919 820919 Stancija Meneghetti HR stay resorts holiday_village_resort normal 5 star 5* 110 39 wedding 90 0 60 70 0   70 20 19.7 PUY 19.8 0.0 2 Bale Istarska Stancija Menegeti 1 45.04056 13.78361     HR-MINT Turističko naselje 5*  
820920 820920 Girandella Resort, Valamr Collection (ex Valamar Collection Girandella Resort) HR stay resorts holiday_village_resort normal 5 star 5* 676 28 wedding 100 0 70 70 0                   Istarska Ulica slobode 82         HR-MINT Turističko naselje 5*  
820921 820921 Valamar Collection Marea Suites (ex Pinia Residence) HR stay resorts holiday_village_resort normal 5 star 5* 384 24 wedding 100 0 70 70 0   60 10 28.0 POW 35.3 3.8 39 Poreč Istarska Šetalište Antona Restovića 25 45.2305 13.7186     HR-MINT Turističko naselje 5*  
820922 820922 Isabella Island Resort, Valamar Collection (ex Valamar Isabella Miramare Island Resort) HR stay resorts holiday_village_resort normal 5 star 5* 174 43 wedding 100 0 70 70 0   60 10 28.0 POW 35.3 3.8 39 Poreč Istarska Otok sv. Nikola 45.2305 13.7186     HR-MINT Turističko naselje 5*  
821129 821129 Suha punta HR stay resorts holiday_village_resort normal 2 star 2* 80 40 wedding 70 0 50 0 0   35 10 50.4 RJK 65.1 0.0 14 Rab Primorsko-goranska Suha punta bb 44.775 14.7186     HR-MINT Turističko naselje 2*  
821130 821130 Ad Turres HR stay resorts holiday_village_resort normal 3 star 3* 663 351 wedding 90 0 60 0 0   70 10 11.9 RJK 26.0 0.0 14 Crikvenica Primorsko-goranska K. Tomislava 111 45.2008 14.7217     HR-MINT Turističko naselje 3*  
821131 821131 San Marino Resort (ex San Marino) HR stay resorts holiday_village_resort normal 3 star 3* 926 360 wedding 90 0 60 0 0   35 10 50.4 RJK 65.1 0.0 14 Rab Primorsko-goranska Lopar 608 44.775 14.7186     HR-MINT Turističko naselje 3*  
821132 821132 Blue Waves (ex Riu Blue Waves) HR stay resorts holiday_village_resort normal 4 star 4* 227 46 wedding 100 0 70 60 0   70 20 12.5 RJK 25.5 2.0 15 Malinska Primorsko-goranska Rova 33 45.1069 14.5369     HR-MINT Turističko naselje 4*  
821133 821133 Hilton Costabella Beach Resort & Spa HR stay resorts holiday_village_resort normal 5 star 5* 92   wedding 90 0 60 70 0   80 20 10.7 RJK 5.7 0.0 5 Rijeka Primorsko-goranska Opatijska 9 45.3011 14.5056     HR-MINT Turističko naselje 5*  
821217 821217 Plitvička Jezera HR stay resorts holiday_village_resort normal 3 star 3* 118 39 wedding 80 0 50 0 0   55 40 37.9 Udbina Airfield 20.8 12.6 6 Plitvička Jezera Ličko-senjska Ličko Petrovo Selo 112/2 44.88126 15.62275     HR-MINT Turističko naselje 3*  
821218 821218 Fenomen Plitvice HR stay resorts holiday_village_resort normal 4 star 4* 42   wedding 80 0 50 60 0   55 40 37.9 Udbina Airfield 20.8 12.6 6 Plitvička Jezera Ličko-senjska Plitvica Selo 81 44.88126 15.62275     HR-MINT Turističko naselje 4*  
821219 821219 Mrzlin grad HR stay resorts holiday_village_resort normal 4 star 4* 20 10 wedding 70 0 40 60 0                   Ličko-senjska Vrelo Koreničko 3/1, Vrelo Koreničko         HR-MINT Turističko naselje 4*  
821293 821293 Alan HR stay resorts holiday_village_resort normal 3 star 3* 457 145 wedding 90 0 60 0 0   70 10 23.1 ZAD 26.3 0.0 9 Starigrad Zadarska Dr. Franje Tuđmana 14 44.296 15.4386     HR-MINT Turističko naselje 3*  
821294 821294 Božava HR stay resorts holiday_village_resort normal 3 star 3* 251 104 wedding 90 0 60 0 0   55 50 36.2 ZAD 25.8 15.9 1 Božava Zadarska Dugi otok 44.1411 14.9042     HR-MINT Turističko naselje 3*  
821295 821295 Margarita Maris HR stay resorts holiday_village_resort normal 3 star 3* 180   wedding 90 0 60 0 0   70 10 15.9 ZAD 23.5 0.0 8 Sveti Filip i Jakov Zadarska Put Primorja 131 43.96472 15.43     HR-MINT Turističko naselje 3*  
821296 821296 San Antonio HR stay resorts holiday_village_resort normal 3 star 3* 151 61 wedding 90 0 60 0 0   70 10 11.0 ZAD 17.6 4.4 23 Biograd na moru Zadarska Put Solina 49 43.999 15.3732     HR-MINT Turističko naselje 3*  
821297 821297 Crvena Luka HR stay resorts holiday_village_resort normal 4 star 4* 534 69 wedding 100 0 70 60 0   70 10 11.0 ZAD 17.6 4.4 23 Biograd na moru Zadarska Crvena luka 1 43.999 15.3732     HR-MINT Turističko naselje 4*  
821298 821298 Zaton HR stay resorts holiday_village_resort normal 4 star 4* 1304   wedding 100 0 70 60 0   70 30 18.4 ZAD 12.3 2.8 2 Zaton Zadarska Dražnikova 76t 44.2253 15.2076     HR-MINT Turističko naselje 4*  
821299 821299 Lioqa Resort HR stay resorts holiday_village_resort normal 5 star 5* 94   wedding 90 0 60 70 0                   Zadarska Put Kralješine 37,         HR-MINT Turističko naselje 5*  
821300 821300 Molum Hotel & Residence HR stay resorts holiday_village_resort normal 5 star 5* 213   wedding 100 0 70 70 0                   Zadarska Jadranska cesta 61,         HR-MINT Turističko naselje 5*  
821401 821401 Jezera Village (ex Jezera Lovišća) HR stay resorts holiday_village_resort normal 2 star 2* 292 8 wedding 80 0 60 0 0   55 10 41.4 ZAD 21.2 0.0 6 Jezera Šibensko-Kninska Uvala Lovišća 43.7876 15.64108     HR-MINT Turističko naselje 2*  
821604 821604 Fontana HR stay resorts holiday_village_resort normal 2 star 2* 460 151 wedding 80 0 60 0 0                   Splitsko-dalmatinska Jelsa 94, Jelsa         HR-MINT Turističko naselje 2*  
821605 821605 Adria Club HR stay resorts holiday_village_resort normal 3 star 3* 226 101 wedding 90 0 60 0 0   70 20 16.3 BWK 16.1 2.4 9 Supetar Splitsko-dalmatinska Put Vele Luke 4 43.3776 16.5226     HR-MINT Turističko naselje 3*  
821606 821606 Alemaris (ex Alem) HR stay resorts holiday_village_resort normal 3 star 3* 822 297 wedding 90 0 60 0 0                   Splitsko-dalmatinska Kralja Petra Krešimira IV, br.11         HR-MINT Turističko naselje 3*  
821607 821607 Alfa HR stay resorts holiday_village_resort normal 3 star 3* 80   wedding 80 0 50 0 0                   Splitsko-dalmatinska Magistrala Ruskamen 16         HR-MINT Turističko naselje 3*  
821608 821608 Beta HR stay resorts holiday_village_resort normal 3 star 3* 96   wedding 80 0 50 0 0                   Splitsko-dalmatinska Magistrala Ruskamen 16         HR-MINT Turističko naselje 3*  
821609 821609 Brzet HR stay resorts holiday_village_resort normal 3 star 3* 176 88 wedding 90 0 60 0 0   70 20 17.2 BWK 30.0 3.3 7 Omiš Splitsko-dalmatinska Brzet 13 43.4049 16.8117     HR-MINT Turističko naselje 3*  
821610 821610 Bretanide HR stay resorts holiday_village_resort normal 3 star 3* 208 103 wedding 90 0 60 0 0   70 30 7.2 BWK 29.7 5.0 8 Bol Splitsko-dalmatinska Put Zlatnog rata 50 43.2664 16.5933     HR-MINT Turističko naselje 3*  
821611 821611 Family Resort Urania HR stay resorts holiday_village_resort normal 3 star 3* 244 48 wedding 90 0 60 0 0                   Splitsko-dalmatinska Kralja Petra Krešimira IV, br.9         HR-MINT Turističko naselje 3*  
821612 821612 Sunny Makarska by Valamar (ex Makarska Sunny Resort) HR stay resorts holiday_village_resort normal 3 star 3* 532 230 wedding 90 0 60 0 0   60 0 27.5 BWK 50.5 0.0 25 Makarska Splitsko-dalmatinska Put Cvitačke 15 43.2969 17.0178     HR-MINT Turističko naselje 3*  
821613 821613 Sirena (ex Sirena - Beachwood resort) HR stay resorts holiday_village_resort normal 3 star 3* 252 126 wedding 90 0 60 0 0   60 20 19.5 BWK 38.4 4.7 14 Hvar Splitsko-dalmatinska Dr. Oresta Žunkovića 1 43.1667 16.5     HR-MINT Turističko naselje 3*  
821614 821614 Val (ex Jadran) HR stay resorts holiday_village_resort normal 3 star 3* 287 143 wedding 90 0 60 0 0   70 10 10.5 SPU 22.1 3.6 21 Seget Donji Splitsko-dalmatinska Hrvatskih žrtava 147 43.5912 16.1902     HR-MINT Turističko naselje 3*  
821615 821615 Aminess Vival Casa Velaris (ex Aminess Casa Velaris) HR stay resorts holiday_village_resort normal 3 star 3* 156 72 wedding 90 0 60 0 0   70 20 16.3 BWK 16.1 2.4 9 Supetar Splitsko-dalmatinska Put Vele Luke 10 43.3776 16.5226     HR-MINT Turističko naselje 3*  
821616 821616 Afrodita HR stay resorts holiday_village_resort normal 4 star 4* 336 192 wedding 100 0 70 60 0   45 0 30.5 BWK 54.4 0.0 25 Tučepi Splitsko-dalmatinska Dračevice 35 43.27222 17.05444     HR-MINT Turističko naselje 4*  
821617 821617 Bonaca HR stay resorts holiday_village_resort normal 4 star 4* 336 192 wedding 100 0 70 60 0   70 30 7.2 BWK 29.7 5.0 8 Bol Splitsko-dalmatinska Bol 43.2664 16.5933     HR-MINT Turističko naselje 4*  
821618 821618 Aminess Younique Senses Resort (ex Aminess Senses Resort) HR stay resorts holiday_village_resort normal 4 star 4* 252 134 wedding 100 0 70 60 0   60 20 11.4 BWK 40.9 0.0 4 Vrboska Splitsko-dalmatinska Vrboska 184 43.18222 16.67083     HR-MINT Turističko naselje 4*  
821619 821619 M 8 Milna (ex Waterman Milna Marina Hotel) HR stay resorts holiday_village_resort normal 4 star 4* 80 35 wedding 90 0 60 60 0   60 20 19.5 BWK 38.4 4.7 14 Milna Splitsko-dalmatinska Brdo II 43.1667 16.5     HR-MINT Turističko naselje 4*  
821620 821620 Morenia HR stay resorts holiday_village_resort normal 4 star 4* 422 140 wedding 100 0 70 60 0   45 20 47.4 OMO 47.6 2.7 8 Podaca Splitsko-dalmatinska Kapeć bb 43.12548 17.30227     HR-MINT Turističko naselje 4*  
821621 821621 Pharos, Hvar Bayhill HR stay resorts holiday_village_resort normal 4 star 4* 359 59 wedding 100 0 70 60 0   60 20 19.5 BWK 38.4 4.7 14 Hvar Splitsko-dalmatinska Dinka Kovačevića 10 43.1667 16.5     HR-MINT Turističko naselje 4*  
821622 821622 Valamar Amicor Green Resort HR stay resorts holiday_village_resort normal 4 star 4* 498 43 wedding 100 0 70 60 0                   Splitsko-dalmatinska Naselje Helios 1         HR-MINT Turističko naselje 4*  
821758 821758 Aminess Vival Port 9 Resort (ex Port 9) HR stay resorts holiday_village_resort normal 4 star 4* 352 102 wedding 100 0 70 60 0   35 30 43.9 BWK 75.5 7.9 6 Korčula Dubrovačko-neretvanska Dubrovačka cesta 19 42.9764 17.0167     HR-MINT Turističko naselje 4*  
821759 821759 Sun Gardens Dubrovnik Residences (ex Dubrovački vrtovi sunca) HR stay resorts holiday_village_resort normal 5 star 5* 766   wedding 100 0 70 70 0   70 20 26.2 DBV 10.7 0.0 4 Orašac Dubrovačko-neretvanska Na moru 1 42.70194 18.00778     HR-MINT Turističko naselje 5*  
821902 821902 Plitvice Holiday Resort HR stay resorts holiday_village_resort normal 4 star 4* 68 31 wedding 80 0 50 60 0   55 10 49.4 Udbina Airfield 23.2 0.0 7 Rakovica Karlovačka Grabovac 102 44.99315 15.65028     HR-MINT Turističko naselje 4*  
822021 822021 Stari podrum HR stay resorts holiday_village_resort normal 3 star 3* 60 30 wedding 70 0 40 0 0   55 20 45.8 OSI 12.2 0.0 2 Ilok Vukovarsko-srijemska Šetalište O. M. Barbarića 4 45.1975 19.26     HR-MINT Turističko naselje 3*  
822022 822022 Ladanjsko imanje Principovac HR stay resorts holiday_village_resort normal 4 star 4* 12   wedding 70 0 40 60 0   55 20 45.8 OSI 12.2 0.0 2 Ilok Vukovarsko-srijemska Principovac 1 45.1975 19.26     HR-MINT Turističko naselje 4*  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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, "best_for" TEXT, "fit_wedding" INTEGER, "fit_conference" INTEGER, "fit_banquet" INTEGER, "fit_spa" INTEGER, "fit_party" INTEGER, "common_areas" TEXT, "reachability_score" INTEGER, "isolation_score" INTEGER, "airport_km" REAL, "nearest_airport" TEXT, "city_km" REAL, "town_km" REAL, "venues_5km" 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");
CREATE INDEX idx_best_for ON venues("best_for");
CREATE INDEX idx_common_areas ON venues("common_areas");