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
219 rows where country = "HR" and rating_value = 5
This data as json, CSV (advanced)
Suggested facets: municipality, source_type
venue_type 4
- marina 138
- hotel 63
- camping 9
- holiday_village_resort 9
country 1
- HR · 219 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 99196 | 99196 | Grand Park Hotel Rovinj (ex Park) | HR | stay | hotels | hotel | normal | 5 | star | 5* | 418 | 198 | Rovinj | Istarska | Smareglijeva ulica - Via Antonio Smareglia 1A | HR-MINT | Hotel | 5* | |||||
| 99197 | 99197 | Hotel Jadran, Valamar Collection | HR | stay | hotels | hotel | normal | 5 | star | 5* | 24 | 12 | Istarska | Eugena Kumičića 3, | HR-MINT | Hotel | 5* | ||||||
| 99198 | 99198 | Hotel Mulino Casino | HR | stay | hotels | hotel | normal | 5 | star | 5* | 134 | 66 | Buje | Istarska | Škrile 75/A | HR-MINT | Hotel | 5* | |||||
| 99199 | 99199 | Kempinski Hotel Adriatic | HR | stay | hotels | hotel | normal | 5 | star | 5* | 372 | 176 | Savudrija | Istarska | Alberi 300a | HR-MINT | Hotel | 5* | |||||
| 99200 | 99200 | Monte Mulini | HR | stay | hotels | hotel | normal | 5 | star | 5* | 202 | 99 | Rovinj | Istarska | A. Smareglia 3 | HR-MINT | Hotel | 5* | |||||
| 99201 | 99201 | Monumenti s depandansom | HR | stay | hotels | hotel | normal | 5 | star | 5* | 198 | 89 | Istarska | Vallelunga 89, | HR-MINT | Hotel | 5* | ||||||
| 99229 | 99229 | TN San Canzian Hotel & Residences (ex San Canzian Village & Hotel) | HR | stay | resorts | holiday_village_resort | normal | 5 | star | 5* | 50 | 21 | Buje | Istarska | Mužolini Donji br. 2,3,3A,4 i 7 | HR-MINT | Turističko naselje | 5* | |||||
| 99230 | 99230 | Stancija Meneghetti | HR | stay | resorts | holiday_village_resort | normal | 5 | star | 5* | 110 | 39 | Bale | Istarska | Stancija Menegeti 1 | HR-MINT | Turističko naselje | 5* | |||||
| 99231 | 99231 | Girandella Resort, Valamr Collection (ex Valamar Collection Girandella Resort) | HR | stay | resorts | holiday_village_resort | normal | 5 | star | 5* | 676 | 28 | Istarska | Ulica slobode 82 | HR-MINT | Turističko naselje | 5* | ||||||
| 99232 | 99232 | Valamar Collection Marea Suites (ex Pinia Residence) | HR | stay | resorts | holiday_village_resort | normal | 5 | star | 5* | 384 | 24 | Poreč | Istarska | Šetalište Antona Restovića 25 | HR-MINT | Turističko naselje | 5* | |||||
| 99233 | 99233 | Isabella Island Resort, Valamar Collection (ex Valamar Isabella Miramare Island Resort) | HR | stay | resorts | holiday_village_resort | normal | 5 | star | 5* | 174 | 43 | Poreč | Istarska | Otok sv. Nikola | HR-MINT | Turističko naselje | 5* | |||||
| 99302 | 99302 | Boutique Camping Santa Marina | HR | stay | camping | camping | normal | 5 | star | 5* | 78 | Vabriga | Istarska | Santa Marina 12 | HR-MINT | Kamp | 5* | ||||||
| 99303 | 99303 | Istra Premium Camping Resort by Valamar (ex Istra) | HR | stay | camping | camping | normal | 5 | star | 5* | Poreč | Istarska | Funtana, Grgeti 35 | HR-MINT | Kamp | 5* | |||||||
| 99304 | 99304 | San Servolo Wellness Camping | HR | stay | camping | camping | normal | 5 | star | 5* | Buje | Istarska | Momjanska ulica 44 | HR-MINT | Kamp | 5* | |||||||
| 99305 | 99305 | Veštar | HR | stay | camping | camping | normal | 5 | star | 5* | 10 | Rovinj | Istarska | Veštar 1 | HR-MINT | Kamp | 5* | ||||||
| 99306 | 99306 | 2 | HR | other | marina | marina | normal | 5 | star | 5* | 50 | Istarska | HR-MINT | Marina | 5* | ||||||||
| 99307 | 99307 | Funtana | HR | other | marina | marina | normal | 5 | star | 5* | 50 | Vrsar | Istarska | Ribarska 11 | HR-MINT | Marina | 5* | ||||||
| 99308 | 99308 | Medulin | HR | other | marina | marina | normal | 5 | star | 5* | Medulin | Istarska | Osipovica 40 | HR-MINT | Marina | 5* | |||||||
| 99309 | 99309 | 3 | HR | other | marina | marina | normal | 5 | star | 5* | 330 | Istarska | HR-MINT | Marina | 5* | ||||||||
| 99310 | 99310 | ACI marina Pomer | HR | other | marina | marina | normal | 5 | star | 5* | 30 | Pula | Istarska | 52100 Pula | HR-MINT | Marina | 5* | ||||||
| 99311 | 99311 | ACI marina Pula | HR | other | marina | marina | normal | 5 | star | 5* | Pula | Istarska | Riva 1 | HR-MINT | Marina | 5* | |||||||
| 99312 | 99312 | Marina Poreč (ex Usluga Poreč) | HR | other | marina | marina | normal | 5 | star | 5* | Poreč | Istarska | Mlinska 1 | HR-MINT | Marina | 5* | |||||||
| 99313 | 99313 | Marina Veruda | HR | other | marina | marina | normal | 5 | star | 5* | 300 | Pula | Istarska | Cesta prekomorskih brigada 12 | HR-MINT | Marina | 5* | ||||||
| 99314 | 99314 | 4 | HR | other | marina | marina | normal | 5 | star | 5* | 50 | Istarska | HR-MINT | Marina | 5* | ||||||||
| 99315 | 99315 | Nautica (ex Marina Nautica) | HR | other | marina | marina | normal | 5 | star | 5* | 50 | Novigrad | Istarska | Sv. Antona 15 | HR-MINT | Marina | 5* | ||||||
| 99316 | 99316 | 5 | HR | other | marina | marina | normal | 5 | star | 5* | 42 | Istarska | HR-MINT | Marina | 5* | ||||||||
| 99317 | 99317 | Marina Polesana | HR | other | marina | marina | normal | 5 | star | 5* | 42 | Istarska | Vallelunga 90 | HR-MINT | Marina | 5* | |||||||
| 99318 | 99318 | ACI marina Rovinj | HR | other | marina | marina | normal | 5 | star | 5* | Rovinj | Istarska | Šetalište Vijeća Europe 1 | HR-MINT | Marina | 5* | |||||||
| 99425 | 99425 | Alhambra s depandansom Vila Augusta | HR | stay | hotels | hotel | normal | 5 | star | 5* | 102 | 36 | Mali Lošinj | Primorsko-goranska | Čikat 15A | HR-MINT | Hotel | 5* | |||||
| 99426 | 99426 | Amabilis | HR | stay | hotels | hotel | normal | 5 | star | 5* | 132 | 44 | Selce | Primorsko-goranska | Emila Antića 68 | HR-MINT | Hotel | 5* | |||||
| 99427 | 99427 | Amadria Park Hotel Milenij (ex Milenij) | HR | stay | hotels | hotel | normal | 5 | star | 5* | 189 | 87 | Opatija | Primorsko-goranska | Maršala Tita 109 | HR-MINT | Hotel | 5* | |||||
| 99428 | 99428 | Ambasador | HR | stay | hotels | hotel | normal | 5 | star | 5* | 486 | 227 | Opatija | Primorsko-goranska | Feliksa Peršića 1 | HR-MINT | Hotel | 5* | |||||
| 99429 | 99429 | Aminess Younique Narrivi Hotel | HR | stay | hotels | hotel | normal | 5 | star | 5* | 80 | 39 | Primorsko-goranska | Trg Stjepana Radića 12, Crikvenica | HR-MINT | Hotel | 5* | ||||||
| 99430 | 99430 | Bellevue s depandansom Hortenzija | HR | stay | hotels | hotel | normal | 5 | star | 5* | 442 | 192 | Mali Lošinj | Primorsko-goranska | Čikat 9 i 9a | HR-MINT | Hotel | 5* | |||||
| 99431 | 99431 | Bevanda | HR | stay | hotels | hotel | normal | 5 | star | 5* | 19 | 10 | Opatija | Primorsko-goranska | Zert 8 | HR-MINT | Hotel | 5* | |||||
| 99432 | 99432 | Hilton Costabella Beach Resort & Spa | HR | stay | hotels | hotel | normal | 5 | star | 5* | 318 | 125 | Rijeka | Primorsko-goranska | Opatijska 9 | HR-MINT | Hotel | 5* | |||||
| 99433 | 99433 | Keight Hotel Opatija, Curio Collection by Hilton | HR | stay | hotels | hotel | normal | 5 | star | 5* | 108 | 52 | Primorsko-goranska | Veli Jože2, | HR-MINT | Hotel | 5* | ||||||
| 99434 | 99434 | Milenij Sveti Jakov | HR | stay | hotels | hotel | normal | 5 | star | 5* | 50 | 25 | Opatija | Primorsko-goranska | Pava Tomašića 1 | HR-MINT | Hotel | 5* | |||||
| 99435 | 99435 | Navis | HR | stay | hotels | hotel | normal | 5 | star | 5* | 88 | 40 | Opatija | Primorsko-goranska | Ulica Ivana Matetića Ronjgova 10 | HR-MINT | Hotel | 5* | |||||
| 99436 | 99436 | Riva | HR | stay | hotels | hotel | normal | 5 | star | 5* | 98 | 47 | Malinska | Primorsko-goranska | Obala 56 | HR-MINT | Hotel | 5* | |||||
| 99437 | 99437 | Riva Retreat Luxury Boutique Hotel & Spa (ex Ikador Luxury Boutique Hotel & Spa) | HR | stay | hotels | hotel | normal | 5 | star | 5* | 32 | 10 | Ika | Primorsko-goranska | Ulica Viktora Cara Emina 1A, | HR-MINT | Hotel | 5* | |||||
| 99438 | 99438 | The Isolano, Cres, Autograph Collection | HR | stay | hotels | hotel | normal | 5 | star | 5* | 80 | 49 | Primorsko-goranska | Lungo mare Sv. Mikule 17, Cres | HR-MINT | Hotel | 5* | ||||||
| 99444 | 99444 | Hilton Costabella Beach Resort & Spa | HR | stay | resorts | holiday_village_resort | normal | 5 | star | 5* | 92 | Rijeka | Primorsko-goranska | Opatijska 9 | HR-MINT | Turističko naselje | 5* | ||||||
| 99488 | 99488 | Krk Premium Camping Resort by Valamar (ex Politin, ex Krk) | HR | stay | camping | camping | normal | 5 | star | 5* | 100 | Krk | Primorsko-goranska | Narodnog preporoda 80 | HR-MINT | Kamp | 5* | ||||||
| 99489 | 99489 | Omišalj | HR | stay | camping | camping | normal | 5 | star | 5* | Omišalj | Primorsko-goranska | Vodotoč 1 | HR-MINT | Kamp | 5* | |||||||
| 99490 | 99490 | 1 | HR | other | marina | marina | normal | 5 | star | 5* | 0 | Primorsko-goranska | HR-MINT | Marina | 5* | ||||||||
| 99491 | 99491 | 2 | HR | other | marina | marina | normal | 5 | star | 5* | 0 | Primorsko-goranska | HR-MINT | Marina | 5* | ||||||||
| 99492 | 99492 | 3 | HR | other | marina | marina | normal | 5 | star | 5* | 158 | Primorsko-goranska | HR-MINT | Marina | 5* | ||||||||
| 99493 | 99493 | ACI marina Supetarska Draga | HR | other | marina | marina | normal | 5 | star | 5* | 53 | Rab | Primorsko-goranska | Supetarska Draga, o. Rab | HR-MINT | Marina | 5* | ||||||
| 99494 | 99494 | Marina Lošinj | HR | other | marina | marina | normal | 5 | star | 5* | 105 | Primorsko-goranska | Runjica 4/a, | HR-MINT | Marina | 5* | |||||||
| 99495 | 99495 | 4 | HR | other | marina | marina | normal | 5 | star | 5* | 340 | Primorsko-goranska | HR-MINT | Marina | 5* | ||||||||
| 99496 | 99496 | Marina Admiral | HR | other | marina | marina | normal | 5 | star | 5* | 40 | Opatija | Primorsko-goranska | Maršala Tita 139 | HR-MINT | Marina | 5* | ||||||
| 99497 | 99497 | Punat | HR | other | marina | marina | normal | 5 | star | 5* | 300 | Punat | Primorsko-goranska | Puntica 7 | HR-MINT | Marina | 5* | ||||||
| 99498 | 99498 | 5 | HR | other | marina | marina | normal | 5 | star | 5* | 80 | Primorsko-goranska | HR-MINT | Marina | 5* | ||||||||
| 99499 | 99499 | ACI marina Cres | HR | other | marina | marina | normal | 5 | star | 5* | 70 | Cres | Primorsko-goranska | Obala Sv. Benedikta 3 | HR-MINT | Marina | 5* | ||||||
| 99500 | 99500 | Marina Novi | HR | other | marina | marina | normal | 5 | star | 5* | 10 | Novi Vinodolski | Primorsko-goranska | Mel 1b | HR-MINT | Marina | 5* | ||||||
| 99526 | 99526 | Veladrion s depandansama Vila Gacka i Vila Degenija (ex Almaris s dep. Vila Gacka i Vila Degenija) | HR | stay | hotels | hotel | normal | 5 | star | 5* | 36 | 12 | Ličko-senjska | Volarice 247b, | HR-MINT | Hotel | 5* | ||||||
| 99543 | 99543 | 1 | HR | other | marina | marina | normal | 5 | star | 5* | 0 | Ličko-senjska | HR-MINT | Marina | 5* | ||||||||
| 99544 | 99544 | 2 | HR | other | marina | marina | normal | 5 | star | 5* | 0 | Ličko-senjska | HR-MINT | Marina | 5* | ||||||||
| 99545 | 99545 | 3 | HR | other | marina | marina | normal | 5 | star | 5* | 0 | Ličko-senjska | HR-MINT | Marina | 5* | ||||||||
| 99546 | 99546 | 4 | HR | other | marina | marina | normal | 5 | star | 5* | 0 | Ličko-senjska | HR-MINT | Marina | 5* | ||||||||
| 99547 | 99547 | 5 | HR | other | marina | marina | normal | 5 | star | 5* | 0 | Ličko-senjska | HR-MINT | Marina | 5* | ||||||||
| 99598 | 99598 | Diadora | HR | stay | hotels | hotel | normal | 5 | star | 5* | 460 | 163 | Petrčane | Zadarska | Punta Skala bb | HR-MINT | Hotel | 5* | |||||
| 99599 | 99599 | Hyatt Regency Zadar | HR | stay | hotels | hotel | normal | 5 | star | 5* | 266 | 110 | Zadarska | Obala kneza Trpimira 7, | HR-MINT | Hotel | 5* | ||||||
| 99600 | 99600 | Iadera | HR | stay | hotels | hotel | normal | 5 | star | 5* | 420 | 206 | Petrčane | Zadarska | Punta Skala | HR-MINT | Hotel | 5* | |||||
| 99601 | 99601 | Molum Hotel & Residence | HR | stay | hotels | hotel | normal | 5 | star | 5* | 120 | 60 | Zadarska | Jadranska cesta 61, | HR-MINT | Hotel | 5* | ||||||
| 99610 | 99610 | Lioqa Resort | HR | stay | resorts | holiday_village_resort | normal | 5 | star | 5* | 94 | Zadarska | Put Kralješine 37, | HR-MINT | Turističko naselje | 5* | |||||||
| 99611 | 99611 | Molum Hotel & Residence | HR | stay | resorts | holiday_village_resort | normal | 5 | star | 5* | 213 | Zadarska | Jadranska cesta 61, | HR-MINT | Turističko naselje | 5* | |||||||
| 99665 | 99665 | Aminess Avalona Camping Resort | HR | stay | camping | camping | normal | 5 | star | 5* | Zadarska | Put Rastavnca 10, | HR-MINT | Kamp | 5* | ||||||||
| 99666 | 99666 | Premium Camping Zadar (ex Borik) | HR | stay | camping | camping | normal | 5 | star | 5* | Zadar | Zadarska | Majstora Radovana 7 | HR-MINT | Kamp | 5* | |||||||
| 99667 | 99667 | 1 | HR | other | marina | marina | normal | 5 | star | 5* | 0 | Zadarska | HR-MINT | Marina | 5* | ||||||||
| 99668 | 99668 | 2 | HR | other | marina | marina | normal | 5 | star | 5* | 0 | Zadarska | HR-MINT | Marina | 5* | ||||||||
| 99669 | 99669 | 3 | HR | other | marina | marina | normal | 5 | star | 5* | 25 | Zadarska | HR-MINT | Marina | 5* | ||||||||
| 99670 | 99670 | Olive Island Marina | HR | other | marina | marina | normal | 5 | star | 5* | 25 | Ugljan | Zadarska | Otok Ugljan | HR-MINT | Marina | 5* | ||||||
| 99671 | 99671 | 4 | HR | other | marina | marina | normal | 5 | star | 5* | 70 | Zadarska | HR-MINT | Marina | 5* | ||||||||
| 99672 | 99672 | Kornati | HR | other | marina | marina | normal | 5 | star | 5* | 70 | Biograd na moru | Zadarska | Šetalište kneza Branimira 1 | HR-MINT | Marina | 5* | ||||||
| 99673 | 99673 | 5 | HR | other | marina | marina | normal | 5 | star | 5* | 30 | Zadarska | HR-MINT | Marina | 5* | ||||||||
| 99674 | 99674 | Marina Drage | HR | other | marina | marina | normal | 5 | star | 5* | 30 | Zadarska | Put Malenice 10A, | HR-MINT | Marina | 5* | |||||||
| 99729 | 99729 | 1 | HR | other | marina | marina | normal | 5 | star | 5* | 0 | Šibensko-Kninska | HR-MINT | Marina | 5* | ||||||||
| 99730 | 99730 | 2 | HR | other | marina | marina | normal | 5 | star | 5* | 12 | Šibensko-Kninska | HR-MINT | Marina | 5* | ||||||||
| 99731 | 99731 | Zaton | HR | other | marina | marina | normal | 5 | star | 5* | 12 | Zaton | Šibensko-Kninska | Dobri Dolac bb | HR-MINT | Marina | 5* | ||||||
| 99732 | 99732 | 3 | HR | other | marina | marina | normal | 5 | star | 5* | 115 | Šibensko-Kninska | HR-MINT | Marina | 5* | ||||||||
| 99733 | 99733 | ACI marina Vodice | HR | other | marina | marina | normal | 5 | star | 5* | 55 | Vodice | Šibensko-Kninska | Artina 13A | HR-MINT | Marina | 5* | ||||||
| 99734 | 99734 | Betina | HR | other | marina | marina | normal | 5 | star | 5* | 60 | Betina | Šibensko-Kninska | Nikole Škevine 15 | HR-MINT | Marina | 5* | ||||||
| 99735 | 99735 | 4 | HR | other | marina | marina | normal | 5 | star | 5* | 65 | Šibensko-Kninska | HR-MINT | Marina | 5* | ||||||||
| 99736 | 99736 | D-Marin Mandalina Marina | HR | other | marina | marina | normal | 5 | star | 5* | 50 | Šibenik | Šibensko-Kninska | Obala Jerka Šižgorića 1 | HR-MINT | Marina | 5* | ||||||
| 99737 | 99737 | Marina Pirovac | HR | other | marina | marina | normal | 5 | star | 5* | 15 | Pirovac | Šibensko-Kninska | Obala Rtine 1a | HR-MINT | Marina | 5* | ||||||
| 99738 | 99738 | 5 | HR | other | marina | marina | normal | 5 | star | 5* | 0 | Šibensko-Kninska | HR-MINT | Marina | 5* | ||||||||
| 99889 | 99889 | Ambasador | HR | stay | hotels | hotel | normal | 5 | star | 5* | 196 | 98 | Splitsko-dalmatinska | Trumbićeva obala 18, Split | HR-MINT | Hotel | 5* | ||||||
| 99890 | 99890 | Aminess Khalani Beach Hotel | HR | stay | hotels | hotel | normal | 5 | star | 5* | 600 | 280 | Makarska | Splitsko-dalmatinska | Ivana Gorana Kovačića 16 | HR-MINT | Hotel | 5* | |||||
| 99891 | 99891 | Atrium | HR | stay | hotels | hotel | normal | 5 | star | 5* | 256 | 124 | Split | Splitsko-dalmatinska | Domovinskog rata 49/a | HR-MINT | Hotel | 5* | |||||
| 99892 | 99892 | Berulia s depandansama (ex Berulia) | HR | stay | hotels | hotel | normal | 5 | star | 5* | 469 | 230 | Brela | Splitsko-dalmatinska | Frankopanska 66 | HR-MINT | Hotel | 5* | |||||
| 99893 | 99893 | Cornaro Hotel s depandansom | HR | stay | hotels | hotel | normal | 5 | star | 5* | 313 | 151 | Split | Splitsko-dalmatinska | Sinjska ulica 6 | HR-MINT | Hotel | 5* | |||||
| 99894 | 99894 | Damianii | HR | stay | hotels | hotel | normal | 5 | star | 5* | 24 | 12 | Duće | Splitsko-dalmatinska | Poljićka cesta Golubinka 11a | HR-MINT | Hotel | 5* | |||||
| 99895 | 99895 | Hotel Moeesy, Blue & Green Oasis | HR | stay | hotels | hotel | normal | 5 | star | 5* | 74 | 37 | Splitsko-dalmatinska | Vlade Avelinija 7 | HR-MINT | Hotel | 5* | ||||||
| 99896 | 99896 | Le Meridien Lav | HR | stay | hotels | hotel | normal | 5 | star | 5* | 768 | 359 | Podstrana | Splitsko-dalmatinska | Grljevačka 2/a | HR-MINT | Hotel | 5* | |||||
| 99897 | 99897 | Maslina | HR | stay | hotels | hotel | normal | 5 | star | 5* | 102 | 49 | Stari Grad | Splitsko-dalmatinska | Uvala Maslinica | HR-MINT | Hotel | 5* | |||||
| 99898 | 99898 | Palace Elisabeth Hvar Heritage Hotel (ex The Palace) | HR | stay | hotels | hotel | normal | 5 | star | 5* | 82 | 33 | Hvar | Splitsko-dalmatinska | Trg Sv. Stjepana 5 | HR-MINT | Hotel | 5* | |||||
| 99899 | 99899 | Palazzo President | HR | stay | hotels | hotel | normal | 5 | star | 5* | 64 | 29 | Splitsko-dalmatinska | Starčevićeva 1, | HR-MINT | Hotel | 5* | ||||||
| 99900 | 99900 | Park | HR | stay | hotels | hotel | normal | 5 | star | 5* | 135 | 70 | Split | Splitsko-dalmatinska | Hatzeov perivoj 3 | HR-MINT | Hotel | 5* |
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");