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
9,235 rows where best_for = "wedding" and country = "ES"
This data as json, CSV (advanced)
Suggested facets: venue_type, rating_scheme, fit_wedding, fit_conference, fit_banquet, fit_spa, reachability_score, isolation_score, source
family 6
- hotels 8,127
- self_catering_villas 424
- camping 421
- rural 149
- guesthouses 60
- hostels 54
group 1
- stay 9,235
country 1
- ES · 9,235 ✖
best_for 1
- wedding · 9,235 ✖
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 348160 | 348160 | PARKING CARAVANING PORTAVENTURA WORLD | ES | stay | camping | camping | normal | none | Sense categoritzar | 100 | wedding | 55 | 0 | 0 | 0 | 0 | 80 | 0 | 3.8 | REU | 0.6 | 0.6 | 8763 | Vila-seca | Tarragonès | Avinguda Alcalde Pere Moles km 2 2 | 41.1167 | 1.15 | ES-CAT | Autocaravanes | Sense categoritzar | AAT-000010 | |||||
| 348161 | 348161 | Atenea Calabria | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 160 | wedding | 65 | 0 | 0 | 0 | 0 | 80 | 0 | 11.1 | BCN | 0.4 | 0.4 | 11027 | Barcelona | Barcelonès | Carrer Calabria 129 | 41.379 | 2.1552 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATB-000001 | |||||
| 348163 | 348163 | Gutenberg | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 170 | wedding | 65 | 0 | 0 | 0 | 0 | 80 | 0 | 11.9 | BCN | 0.1 | 0.1 | 10973 | Barcelona | Barcelonès | Passatge Gutenberg 7 | 41.3799 | 2.1687 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATB-000003 | |||||
| 348165 | 348165 | Silver | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 98 | wedding | 55 | 0 | 0 | 0 | 0 | 80 | 0 | 13.4 | BCN | 0.0 | 0.0 | 11928 | Barcelona | Barcelonès | Carrer Breton de los Herreros 26 | 41.4023 | 2.157 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATB-000005 | |||||
| 348171 | 348171 | Velor | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 80 | wedding | 55 | 0 | 0 | 0 | 0 | 80 | 10 | 12.3 | BCN | 3.1 | 3.1 | 3979 | Castelldefels | Baix Llobregat | Passeig Espanya 47 | 41.264 | 1.938 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATB-000012 | |||||
| 348179 | 348179 | Atenea Park II | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 80 | wedding | 55 | 0 | 0 | 0 | 0 | 65 | 0 | 30.6 | BCN | 0.0 | 0.0 | 2063 | Vilanova i la Geltrú | Garraf | Carrer Pere IV 35-39 | 41.2239 | 1.7251 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATB-000020 | |||||
| 348193 | 348193 | Bellamar | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 100 | wedding | 55 | 0 | 0 | 0 | 0 | 80 | 0 | 28.7 | GRO | 0.0 | 0.0 | 1841 | Malgrat de Mar | Maresme | Carrer Sant Esteve 20-24 | 41.6466 | 2.7413 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATB-000041 | |||||
| 348202 | 348202 | Apartaments Turistics | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 116 | wedding | 55 | 0 | 0 | 0 | 0 | 65 | 0 | 31.4 | GRO | 0.0 | 0.0 | 2352 | Pineda de Mar | Maresme | Carrer Josep Maria de Sagarra 44-46 | 41.6276 | 2.6889 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATB-000072 | |||||
| 348205 | 348205 | Mar Blau | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 94 | wedding | 55 | 0 | 0 | 0 | 0 | 65 | 0 | 32.9 | GRO | 1.3 | 1.3 | 2233 | Calella | Maresme | Carrer Riera Capaspre 75 | 41.6168 | 2.6691 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATB-000075 | |||||
| 348206 | 348206 | Aurapark Sud | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 170 | wedding | 65 | 0 | 0 | 0 | 0 | 80 | 0 | 17.6 | BCN | 0.6 | 0.6 | 7249 | Hospitalet de Llobregat, l' | Barcelonès | Avinguda Fabregada 56 | 41.4301 | 2.1925 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATB-000077 | |||||
| 348209 | 348209 | SG Costa BCN | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 124 | wedding | 55 | 0 | 0 | 0 | 0 | 80 | 10 | 12.3 | BCN | 3.1 | 3.1 | 3979 | Castelldefels | Baix Llobregat | Passeig Marina 116 | 41.264 | 1.938 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATB-000082 | |||||
| 348212 | 348212 | Midtown Apartments | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 100 | wedding | 55 | 0 | 0 | 0 | 0 | 80 | 0 | 13.2 | BCN | 0.5 | 0.5 | 11964 | Barcelona | Barcelonès | Carrer Casp 35 | 41.3913 | 2.1749 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATB-000086 | |||||
| 348241 | 348241 | BAMBLUE BOUTIQUE APARTMENTS | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 154 | wedding | 65 | 0 | 0 | 0 | 0 | 65 | 0 | 31.4 | GRO | 0.0 | 0.0 | 2352 | Pineda de Mar | Maresme | Rambla Catalunya 40 | 41.6276 | 2.6889 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATB-000260 | |||||
| 348249 | 348249 | EUROPA BARCELONA APARTMENT | ES | stay | self_catering_villas | self_catering | normal | 4 | key | 4 claus | 65 | wedding | 65 | 0 | 0 | 0 | 0 | 80 | 0 | 17.6 | BCN | 0.6 | 0.6 | 7249 | Hospitalet de Llobregat, l' | Barcelonès | Carrer del Prat de la Manta 55 | 41.4301 | 2.1925 | ES-CAT | Apartaments Turístics | 4 claus | ATB-000286 | ||||
| 348250 | 348250 | FELS APARTMENTS | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 107 | wedding | 55 | 0 | 0 | 0 | 0 | 80 | 10 | 12.3 | BCN | 3.1 | 3.1 | 3979 | Castelldefels | Baix Llobregat | Passeig de la Tramuntana 125 | 41.264 | 1.938 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATB-000287 | |||||
| 348275 | 348275 | Cel.les Abat Marcet | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 236 | wedding | 65 | 0 | 0 | 0 | 0 | 80 | 10 | 21.3 | BCN | 2.1 | 2.1 | 216 | Monistrol de Montserrat | Bages | Carrer Monestir de Montserrat s/n | 41.4883 | 2.0782 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATCC-000027 | |||||
| 348294 | 348294 | Centremar Apartaments | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 222 | wedding | 65 | 0 | 0 | 0 | 0 | 55 | 0 | 39.6 | GRO | 15.4 | 0.0 | 2118 | Torroella de Montgrí | Baix Empordà | Carretera Torrroella 121 | 42.0534 | 3.1977 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATG-000021 | |||||
| 348300 | 348300 | La Masia | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 100 | wedding | 55 | 0 | 0 | 0 | 0 | 55 | 0 | 39.6 | GRO | 15.4 | 0.0 | 2118 | Torroella de Montgrí | Baix Empordà | Carretera Torroella 129 | 42.0534 | 3.1977 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATG-000028 | |||||
| 348301 | 348301 | Blau | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 120 | wedding | 55 | 0 | 0 | 0 | 0 | 80 | 0 | 23.8 | GRO | 0.0 | 0.0 | 3315 | Lloret de Mar | Selva | Avinguda Just Marles 19 | 41.6999 | 2.8456 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATG-000031 | |||||
| 348305 | 348305 | Apartaments Pal Beach | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 186 | wedding | 65 | 0 | 0 | 0 | 0 | 65 | 0 | 31.0 | GRO | 2.1 | 1.6 | 5703 | Palamós | Baix Empordà | Carrer SALVADOR ALBERT I PEY 1 | 41.8667 | 3.1333 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATG-000035 | |||||
| 348308 | 348308 | Residencial Super STOP | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 94 | wedding | 55 | 0 | 0 | 0 | 0 | 65 | 0 | 34.0 | GRO | 1.0 | 1.0 | 4664 | Palafrugell | Baix Empordà | Avinguda Corts Catalanes 1 | 41.9238 | 3.172 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATG-000039 | |||||
| 348309 | 348309 | La Solana | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 192 | wedding | 65 | 0 | 0 | 0 | 0 | 65 | 0 | 52.7 | GRO | 0.2 | 0.2 | 5350 | Roses | Alt Empordà | Carrer Port d'el Reig 17 | 42.2632 | 3.1785 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATG-000040 | |||||
| 348312 | 348312 | Comte d'Empúries | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 610 | wedding | 65 | 0 | 0 | 0 | 0 | 65 | 0 | 46.9 | GRO | 8.4 | 0.0 | 3709 | Castelló d'Empúries | Alt Empordà | Urbanització Gran Reserva d'Empuriabrava s/n | 42.2567 | 3.0745 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATG-000045 | |||||
| 348314 | 348314 | Solineu | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 124 | wedding | 55 | 0 | 0 | 0 | 0 | 55 | 20 | 44.1 | LEU | 27.4 | 6.1 | 161 | Alp | Cerdanya | Carrer Comabella 5 | 42.3391 | 1.9457 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATG-000051 | |||||
| 348315 | 348315 | Estudis Els Molins | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 88 | wedding | 55 | 0 | 0 | 0 | 0 | 65 | 0 | 52.7 | GRO | 0.2 | 0.2 | 5350 | Roses | Alt Empordà | Avinguda Rhodes 22 | 42.2632 | 3.1785 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATG-000052 | |||||
| 348317 | 348317 | Europa | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 290 | wedding | 65 | 0 | 0 | 0 | 0 | 80 | 0 | 25.4 | GRO | 0.3 | 0.3 | 1423 | Blanes | Selva | Carrer Lluís Companys 23-25 | 41.6767 | 2.788 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATG-000056 | |||||
| 348319 | 348319 | Carpe Diem Cadaques | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 110 | wedding | 55 | 0 | 0 | 0 | 0 | 65 | 0 | 60.2 | PGF | 9.7 | 1.0 | 1045 | Cadaqués | Alt Empordà | Carretera Cap de Creus 1 | 42.294 | 3.2861 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATG-000059 | |||||
| 348322 | 348322 | Village Golf Beach | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 108 | wedding | 55 | 0 | 0 | 0 | 0 | 65 | 0 | 31.7 | GRO | 7.3 | 1.6 | 1562 | Pals | Baix Empordà | Carretera Platja de Pals 4 | 41.9791 | 3.1314 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATG-000063 | |||||
| 348323 | 348323 | GOLF RESORT APARTAMENTS | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 124 | wedding | 55 | 0 | 0 | 0 | 0 | 65 | 0 | 31.7 | GRO | 7.3 | 1.6 | 1562 | Pals | Baix Empordà | Avinguda Arenals de Mar 3 | 41.9791 | 3.1314 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATG-000064 | |||||
| 348324 | 348324 | Bolero Park | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 240 | wedding | 65 | 0 | 0 | 0 | 0 | 80 | 0 | 23.8 | GRO | 0.0 | 0.0 | 3315 | Lloret de Mar | Selva | Carrer de Francesc Cambó 15 | 41.6999 | 2.8456 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATG-000066 | |||||
| 348326 | 348326 | Condado | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 354 | wedding | 65 | 0 | 0 | 0 | 0 | 80 | 0 | 23.8 | GRO | 0.0 | 0.0 | 3315 | Lloret de Mar | Selva | Carrer Nicolau Font i Maig 2 | 41.6999 | 2.8456 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATG-000069 | |||||
| 348332 | 348332 | Casa Margarita | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 103 | wedding | 55 | 0 | 0 | 0 | 0 | 80 | 0 | 27.1 | GRO | 4.6 | 0.1 | 5164 | Castell d'Aro, Platja d'Aro i s'Agaró | Baix Empordà | Avinguda Verona Terol 17 | 41.8167 | 3.0667 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATG-000075 | |||||
| 348337 | 348337 | Agi Rescator Resort | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 160 | wedding | 65 | 0 | 0 | 0 | 0 | 65 | 0 | 52.7 | GRO | 0.2 | 0.2 | 5350 | Roses | Alt Empordà | Carrer Luxemburgo 10-16 | 42.2632 | 3.1785 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATG-000081 | |||||
| 348344 | 348344 | Goetten Apartamentos | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 215 | wedding | 65 | 0 | 0 | 0 | 0 | 80 | 0 | 27.1 | GRO | 4.6 | 0.1 | 5164 | Castell d'Aro, Platja d'Aro i s'Agaró | Baix Empordà | Avinguda Madrid 21 | 41.8167 | 3.0667 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATG-000091 | |||||
| 348354 | 348354 | L'Escala Resort | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 230 | wedding | 65 | 0 | 0 | 0 | 0 | 55 | 0 | 39.0 | GRO | 15.2 | 1.2 | 3307 | Escala, l' | Alt Empordà | Carrer Maos 8 | 42.132 | 3.1213 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATG-000106 | |||||
| 348364 | 348364 | Apartaments MONJARDÍ | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 126 | wedding | 55 | 0 | 0 | 0 | 0 | 80 | 0 | 23.8 | GRO | 0.0 | 0.0 | 3315 | Lloret de Mar | Selva | Passatge Torre Campderà 40 | 41.6999 | 2.8456 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATG-000118 | |||||
| 348370 | 348370 | Club Aire Libre | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 210 | wedding | 65 | 0 | 0 | 0 | 0 | 80 | 0 | 25.3 | GRO | 7.5 | 0.0 | 1546 | Tossa de Mar | Selva | Carrer Cala Llevado s/n | 41.7167 | 2.9333 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATG-000127 | |||||
| 348376 | 348376 | RV TREUMAL PARK | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 85 | wedding | 55 | 0 | 0 | 0 | 0 | 80 | 0 | 27.1 | GRO | 4.6 | 0.1 | 5164 | Castell d'Aro, Platja d'Aro i s'Agaró | Baix Empordà | Carrer Pi 2 | 41.8167 | 3.0667 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATG-000133 | |||||
| 348400 | 348400 | APARTAMENTS LA CARPA | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 100 | wedding | 55 | 0 | 0 | 0 | 0 | 80 | 0 | 23.6 | GRO | 0.0 | 0.0 | 229 | Banyoles | Pla de l'Estany | Passeig DARDER S/N | 42.1167 | 2.7667 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATG-000271 | |||||
| 348411 | 348411 | La Solana | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 180 | wedding | 65 | 0 | 0 | 0 | 0 | 45 | 10 | 50.3 | LEU | 55.2 | 4.2 | 483 | Vall de Boí, la | Alta Ribagorça | Urbanització Pla de l'Ermita de Sant Quirze s/n | 42.5203 | 0.8474 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATL-000003 | |||||
| 348435 | 348435 | Áncora | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 150 | wedding | 65 | 0 | 0 | 0 | 0 | 80 | 0 | 8.2 | REU | 0.0 | 0.0 | 8673 | Salou | Tarragonès | Carretera de Salou a Reus 3 | 41.0766 | 1.1416 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATT-000001 | |||||
| 348436 | 348436 | California III-IV | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 406 | wedding | 65 | 0 | 0 | 0 | 0 | 80 | 0 | 8.2 | REU | 0.0 | 0.0 | 8673 | Salou | Tarragonès | Carrer Prat d'en Carbó 1 | 41.0766 | 1.1416 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATT-000002 | |||||
| 348439 | 348439 | Can Torrents | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 101 | wedding | 55 | 0 | 0 | 0 | 0 | 80 | 0 | 9.9 | BCN | 1.3 | 1.3 | 3979 | Cunit | Baix Penedès | Carrer Mar de Xina 3 | 41.2667 | 1.9667 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATT-000007 | |||||
| 348440 | 348440 | Apartaments Pineda Park | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 248 | wedding | 65 | 0 | 0 | 0 | 0 | 80 | 0 | 7.7 | REU | 0.3 | 0.3 | 8685 | Vila-seca | Tarragonès | Carrer d' Amadeu Vives 32 | 41.079 | 1.1818 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATT-000008 | |||||
| 348441 | 348441 | Villa Engracia | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 150 | wedding | 65 | 0 | 0 | 0 | 0 | 70 | 10 | 28.1 | REU | 17.5 | 4.0 | 63 | Espluga de Francolí, l' | Conca de Barberà | Carretera Les Masies s/n | 41.395 | 1.0985 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATT-000009 | |||||
| 348443 | 348443 | Cye Salou | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 138 | wedding | 55 | 0 | 0 | 0 | 0 | 80 | 0 | 8.2 | REU | 0.0 | 0.0 | 8673 | Salou | Tarragonès | Plaça Europa 2 | 41.0766 | 1.1416 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATT-000015 | |||||
| 348444 | 348444 | Voramar | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 376 | wedding | 65 | 0 | 0 | 0 | 0 | 80 | 0 | 12.4 | REU | 0.2 | 0.2 | 3793 | Cambrils | Baix Camp | Avinguda Diputació 67 | 41.0721 | 1.0597 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATT-000016 | |||||
| 348445 | 348445 | PINS PLATJA APARTAMENTS | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 476 | wedding | 65 | 0 | 0 | 0 | 0 | 80 | 0 | 12.4 | REU | 0.2 | 0.2 | 3793 | Cambrils | Baix Camp | Avinguda de la Diputació 147 | 41.0721 | 1.0597 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATT-000021 | |||||
| 348448 | 348448 | RENTALMAR BLUE BEACH | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 321 | wedding | 65 | 0 | 0 | 0 | 0 | 80 | 0 | 8.2 | REU | 0.0 | 0.0 | 8673 | Salou | Tarragonès | Carrer de Montblanc 4 | 41.0766 | 1.1416 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATT-000024 | |||||
| 348451 | 348451 | Costa d'Or | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 302 | wedding | 65 | 0 | 0 | 0 | 0 | 65 | 0 | 34.0 | REU | 0.1 | 0.1 | 2320 | Calafell | Baix Penedès | Carrer Villamar 101 | 41.1997 | 1.5689 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATT-000032 | |||||
| 348467 | 348467 | CAL BOLI | ES | stay | self_catering_villas | self_catering | normal | 4 | key | 4 claus | 12 | wedding | 55 | 0 | 0 | 0 | 0 | 45 | 0 | 37.9 | REU | 32.8 | 0.0 | 42 | Margalef | Priorat | Carrer dels Molins 36 | 41.2849 | 0.7537 | ES-CAT | Apartaments Turístics | 4 claus | ATT-000284 | ||||
| 348481 | 348481 | BCN Resort Mar | ES | stay | self_catering_villas | self_catering | normal | none | Sense categoritzar | 180 | wedding | 65 | 0 | 0 | 0 | 0 | 55 | 0 | 49.1 | REU | 17.5 | 1.0 | 199 | Perelló, el | Baix Ebre | Carrer Garbi s/n s/n | 40.8667 | 0.7167 | ES-CAT | Apartaments Turístics | Sense categoritzar | ATTE-000013 | |||||
| 348492 | 348492 | Suizo | ES | stay | hotels | hotel | normal | 3 | star | 3 estrelles | 99 | wedding | 80 | 73 | 50 | 0 | 0 | 80 | 0 | 12.5 | BCN | 0.2 | 0.2 | 11022 | Barcelona | Barcelonès | Plaça Del Ángel 12 | 41.3823 | 2.176 | ES-CAT | Hotels | 3 estrelles | HB-000002 | ||||
| 348493 | 348493 | Hostal Abrevadero | ES | stay | hotels | hotel | normal | none | No aplica | 45 | wedding | 60 | 55 | 40 | 0 | 0 | 80 | 0 | 10.7 | BCN | 0.4 | 0.4 | 10836 | Barcelona | Barcelonès | Carrer Vila i Vilà 79 | 41.3722 | 2.1593 | ES-CAT | Hotels | No aplica | HB-000005 | |||||
| 348494 | 348494 | Hostal Valls | ES | stay | hotels | hotel | normal | none | No aplica | 17 | wedding | 50 | 45 | 30 | 0 | 0 | 80 | 0 | 12.3 | BCN | 0.1 | 0.1 | 11156 | Barcelona | Barcelonès | Carrer Laforja 82 | 41.397 | 2.1423 | ES-CAT | Hotels | No aplica | HB-000006 | |||||
| 348495 | 348495 | HOTEL FORNOS | ES | stay | hotels | hotel | normal | 2 | star | 2 estrelles | 47 | wedding | 60 | 55 | 40 | 0 | 0 | 80 | 0 | 12.5 | BCN | 0.2 | 0.2 | 11022 | Barcelona | Barcelonès | Carrer COLON 2 | 41.3823 | 2.176 | ES-CAT | Hotels | 2 estrelles | HB-000011 | ||||
| 348496 | 348496 | Granvía | ES | stay | hotels | hotel | normal | 3 | star | 3 estrelles | 105 | wedding | 80 | 73 | 50 | 0 | 0 | 80 | 0 | 12.6 | BCN | 0.2 | 0.2 | 11156 | Barcelona | Barcelonès | Carrer Gran Via Corts Catalanes 642 | 41.3898 | 2.1643 | ES-CAT | Hotels | 3 estrelles | HB-000012 | ||||
| 348497 | 348497 | Avenida Palace | ES | stay | hotels | hotel | normal | 4 | star | 4 estrelles | 274 | wedding | 100 | 90 | 70 | 50 | 0 | 80 | 0 | 12.6 | BCN | 0.2 | 0.2 | 11156 | Barcelona | Barcelonès | Carrer Gran Via Corts Catalanes 605 | 41.3898 | 2.1643 | ES-CAT | Hotels | 4 estrelles | HB-000016 | ||||
| 348498 | 348498 | Astoria | ES | stay | hotels | hotel | normal | 3 | star | 3 estrelles | 205 | wedding | 90 | 83 | 60 | 0 | 0 | 80 | 0 | 12.1 | BCN | 0.3 | 0.3 | 11156 | Barcelona | Barcelonès | Carrer París 203 | 41.3906 | 2.1521 | ES-CAT | Hotels | 3 estrelles | HB-000017 | ||||
| 348499 | 348499 | Regina | ES | stay | hotels | hotel | normal | 4 | star | 4 estrelles | 176 | wedding | 100 | 80 | 70 | 50 | 0 | 80 | 0 | 12.5 | BCN | 0.2 | 0.2 | 11022 | Barcelona | Barcelonès | Carrer Bergara 2-4 | 41.3823 | 2.176 | ES-CAT | Hotels | 4 estrelles | HB-000018 | ||||
| 348500 | 348500 | Hostal París | ES | stay | hotels | hotel | normal | none | No aplica | 68 | wedding | 60 | 55 | 40 | 0 | 0 | 80 | 0 | 12.5 | BCN | 0.2 | 0.2 | 11022 | Barcelona | Barcelonès | Carrer Cardenal Casañas 4 | 41.3823 | 2.176 | ES-CAT | Hotels | No aplica | HB-000019 | |||||
| 348501 | 348501 | Autohogar | ES | stay | hotels | hotel | normal | 3 | star | 3 estrelles | 276 | wedding | 90 | 83 | 60 | 0 | 0 | 80 | 0 | 11.9 | BCN | 0.1 | 0.1 | 10973 | Barcelona | Barcelonès | Avinguda Paral·lel 64 | 41.3799 | 2.1687 | ES-CAT | Hotels | 3 estrelles | HB-000022 | ||||
| 348502 | 348502 | Regencia Colón | ES | stay | hotels | hotel | normal | 3 | star | 3 estrelles | 95 | wedding | 80 | 73 | 50 | 0 | 0 | 80 | 0 | 12.5 | BCN | 0.2 | 0.2 | 11022 | Barcelona | Barcelonès | Carrer Sagristans 13-17 | 41.3823 | 2.176 | ES-CAT | Hotels | 3 estrelles | HB-000023 | ||||
| 348503 | 348503 | Lloret | ES | stay | hotels | hotel | normal | 1 | star | 1 estrella | 98 | wedding | 70 | 65 | 50 | 0 | 0 | 80 | 0 | 12.5 | BCN | 0.2 | 0.2 | 11022 | Barcelona | Barcelonès | Carrer Rambla 125 | 41.3823 | 2.176 | ES-CAT | Hotels | 1 estrella | HB-000025 | ||||
| 348504 | 348504 | Rialto | ES | stay | hotels | hotel | normal | 3 | star | 3 estrelles | 370 | wedding | 90 | 83 | 60 | 0 | 0 | 80 | 0 | 12.5 | BCN | 0.2 | 0.2 | 11022 | Barcelona | Barcelonès | Carrer Ferran 42 | 41.3823 | 2.176 | ES-CAT | Hotels | 3 estrelles | HB-000026 | ||||
| 348505 | 348505 | San Agustín | ES | stay | hotels | hotel | normal | 3 | star | 3 estrelles | 146 | wedding | 80 | 73 | 50 | 0 | 0 | 80 | 0 | 11.9 | BCN | 0.1 | 0.1 | 10973 | Barcelona | Barcelonès | Plaça Sant Agustí 3 | 41.3799 | 2.1687 | ES-CAT | Hotels | 3 estrelles | HB-000030 | ||||
| 348506 | 348506 | Hostal Operaramblas | ES | stay | hotels | hotel | normal | none | No aplica | 116 | wedding | 70 | 65 | 50 | 0 | 0 | 80 | 0 | 11.9 | BCN | 0.1 | 0.1 | 10973 | Barcelona | Barcelonès | Carrer Sant Pau 20 | 41.3799 | 2.1687 | ES-CAT | Hotels | No aplica | HB-000033 | |||||
| 348507 | 348507 | Inglés | ES | stay | hotels | hotel | normal | 1 | star | 1 estrella | 44 | wedding | 60 | 55 | 40 | 0 | 0 | 80 | 0 | 12.5 | BCN | 0.2 | 0.2 | 11022 | Barcelona | Barcelonès | Carrer Boqueria 17 | 41.3823 | 2.176 | ES-CAT | Hotels | 1 estrella | HB-000034 | ||||
| 348508 | 348508 | INTERNACIONAL RAMBLAS ATIRAM HOTEL | ES | stay | hotels | hotel | normal | 1 | star | 1 estrella | 92 | wedding | 70 | 65 | 50 | 0 | 0 | 80 | 0 | 12.5 | BCN | 0.2 | 0.2 | 11022 | Barcelona | Barcelonès | Carrer la Rambla 78 | 41.3823 | 2.176 | ES-CAT | Hotels | 1 estrella | HB-000035 | ||||
| 348509 | 348509 | Jardí | ES | stay | hotels | hotel | normal | none | No aplica | 65 | wedding | 60 | 55 | 40 | 0 | 0 | 80 | 0 | 12.5 | BCN | 0.2 | 0.2 | 11022 | Barcelona | Barcelonès | Plaça Sant Josep Oriol 1 | 41.3823 | 2.176 | ES-CAT | Hotels | No aplica | HB-000036 | |||||
| 348510 | 348510 | Majestic | ES | stay | hotels | hotel | normal | none | Gran luxe | 531 | wedding | 80 | 75 | 60 | 0 | 0 | 80 | 0 | 12.7 | BCN | 0.5 | 0.5 | 11859 | Barcelona | Barcelonès | Passeig Gràcia 68 | 41.3937 | 2.1586 | ES-CAT | Hotels | Gran luxe | HB-000038 | |||||
| 348511 | 348511 | Le Meridien Barcelona | ES | stay | hotels | hotel | normal | none | Gran luxe | 466 | wedding | 80 | 75 | 60 | 0 | 0 | 80 | 0 | 11.9 | BCN | 0.1 | 0.1 | 10973 | Barcelona | Barcelonès | Carrer Rambla 111 | 41.3799 | 2.1687 | ES-CAT | Hotels | Gran luxe | HB-000039 | |||||
| 348512 | 348512 | Moderno | ES | stay | hotels | hotel | normal | 3 | star | 3 estrelles | 86 | wedding | 80 | 73 | 50 | 0 | 0 | 80 | 0 | 11.9 | BCN | 0.1 | 0.1 | 10973 | Barcelona | Barcelonès | Carrer Hospital 11 | 41.3799 | 2.1687 | ES-CAT | Hotels | 3 estrelles | HB-000041 | ||||
| 348513 | 348513 | Mesón de Castilla Atiram Hotel | ES | stay | hotels | hotel | normal | 2 | star | 2 estrelles | 90 | wedding | 70 | 65 | 50 | 0 | 0 | 80 | 0 | 11.9 | BCN | 0.1 | 0.1 | 10973 | Barcelona | Barcelonès | Carrer Valldonzella 5 | 41.3799 | 2.1687 | ES-CAT | Hotels | 2 estrelles | HB-000042 | ||||
| 348514 | 348514 | Montecarlo | ES | stay | hotels | hotel | normal | 4 | star | 4 estrelles | 96 | wedding | 90 | 80 | 60 | 50 | 0 | 80 | 0 | 12.5 | BCN | 0.2 | 0.2 | 11022 | Barcelona | Barcelonès | Carrer Rambla 124 | 41.3823 | 2.176 | ES-CAT | Hotels | 4 estrelles | HB-000043 | ||||
| 348515 | 348515 | Cataluña | ES | stay | hotels | hotel | normal | 2 | star | 2 estrelles | 61 | wedding | 60 | 55 | 40 | 0 | 0 | 80 | 0 | 12.5 | BCN | 0.2 | 0.2 | 11022 | Barcelona | Barcelonès | Carrer Santa Anna 22-24 | 41.3823 | 2.176 | ES-CAT | Hotels | 2 estrelles | HB-000047 | ||||
| 348516 | 348516 | COLÓN | ES | stay | hotels | hotel | normal | 5 | star | 5 estrelles | 252 | wedding | 100 | 90 | 70 | 60 | 0 | 80 | 0 | 12.5 | BCN | 0.2 | 0.2 | 11022 | Barcelona | Barcelonès | Avinguda de la Catedral 7 | 41.3823 | 2.176 | ES-CAT | Hotels | 5 estrelles | HB-000049 | ||||
| 348517 | 348517 | Comercio | ES | stay | hotels | hotel | normal | 1 | star | 1 estrella | 88 | wedding | 70 | 65 | 50 | 0 | 0 | 80 | 0 | 12.5 | BCN | 0.2 | 0.2 | 11022 | Barcelona | Barcelonès | Carrer Escudellers 15 | 41.3823 | 2.176 | ES-CAT | Hotels | 1 estrella | HB-000050 | ||||
| 348518 | 348518 | HOTEL CONDAL | ES | stay | hotels | hotel | normal | 3 | star | 3 estrelles | 92 | wedding | 80 | 73 | 50 | 0 | 0 | 80 | 0 | 12.5 | BCN | 0.2 | 0.2 | 11022 | Barcelona | Barcelonès | Carrer Boqueria 23 | 41.3823 | 2.176 | ES-CAT | Hotels | 3 estrelles | HB-000051 | ||||
| 348519 | 348519 | Continental | ES | stay | hotels | hotel | normal | 3 | star | 3 estrelles | 73 | wedding | 70 | 63 | 40 | 0 | 0 | 80 | 0 | 12.5 | BCN | 0.2 | 0.2 | 11022 | Barcelona | Barcelonès | Carrer Rambla 138 | 41.3823 | 2.176 | ES-CAT | Hotels | 3 estrelles | HB-000053 | ||||
| 348520 | 348520 | Ibiza | ES | stay | hotels | hotel | normal | 1 | star | 1 estrella | 36 | wedding | 60 | 45 | 30 | 0 | 0 | 80 | 0 | 24.3 | BCN | 1.7 | 1.7 | 2936 | Sitges | Garraf | Carrer Sant Bartomeu 11 | 41.2446 | 1.7962 | ES-CAT | Hotels | 1 estrella | HB-000055 | ||||
| 348521 | 348521 | ME SITGES TERRAMAR | ES | stay | hotels | hotel | normal | 5 | star | 5 estrelles | 426 | wedding | 100 | 90 | 70 | 60 | 0 | 80 | 0 | 24.3 | BCN | 1.7 | 1.7 | 2936 | Sitges | Garraf | Passeig Marítim 80 | 41.2446 | 1.7962 | ES-CAT | Hotels | 5 estrelles | HB-000061 | ||||
| 348522 | 348522 | Subur | ES | stay | hotels | hotel | normal | 3 | star | 3 estrelles | 168 | wedding | 90 | 73 | 60 | 0 | 0 | 80 | 0 | 24.3 | BCN | 1.7 | 1.7 | 2936 | Sitges | Garraf | Passeig Ribera s/n | 41.2446 | 1.7962 | ES-CAT | Hotels | 3 estrelles | HB-000062 | ||||
| 348523 | 348523 | Roma Reial | ES | stay | hotels | hotel | normal | 1 | star | 1 estrella | 95 | wedding | 70 | 65 | 50 | 0 | 0 | 80 | 0 | 12.5 | BCN | 0.2 | 0.2 | 11022 | Barcelona | Barcelonès | Plaça Reial 11 | 41.3823 | 2.176 | ES-CAT | Hotels | 1 estrella | HB-000063 | ||||
| 348524 | 348524 | El Palace | ES | stay | hotels | hotel | normal | none | Gran luxe | 244 | wedding | 80 | 75 | 60 | 0 | 0 | 80 | 0 | 13.2 | BCN | 0.5 | 0.5 | 11964 | Barcelona | Barcelonès | Carrer Gran Via Corts Catalanes 668 | 41.3913 | 2.1749 | ES-CAT | Hotels | Gran luxe | HB-000064 | |||||
| 348525 | 348525 | Condado | ES | stay | hotels | hotel | normal | 3 | star | 3 estrelles | 146 | wedding | 80 | 73 | 50 | 0 | 0 | 80 | 0 | 12.3 | BCN | 0.1 | 0.1 | 11156 | Barcelona | Barcelonès | Carrer Aribau 201 | 41.397 | 2.1423 | ES-CAT | Hotels | 3 estrelles | HB-000066 | ||||
| 348526 | 348526 | Vincci Mae | ES | stay | hotels | hotel | normal | 4 | star | 4 estrelles | 170 | wedding | 100 | 80 | 70 | 50 | 0 | 80 | 0 | 12.3 | BCN | 0.1 | 0.1 | 11156 | Barcelona | Barcelonès | Avinguda Diagonal 596 | 41.397 | 2.1423 | ES-CAT | Hotels | 4 estrelles | HB-000069 | ||||
| 348527 | 348527 | Cuatro Naciones | ES | stay | hotels | hotel | normal | 2 | star | 2 estrelles | 106 | wedding | 70 | 65 | 50 | 0 | 0 | 80 | 0 | 12.5 | BCN | 0.2 | 0.2 | 11022 | Barcelona | Barcelonès | Carrer Rambla 40 | 41.3823 | 2.176 | ES-CAT | Hotels | 2 estrelles | HB-000071 | ||||
| 348528 | 348528 | HOTEL ESPAÑA | ES | stay | hotels | hotel | normal | 4 | star | 4 estrelles | 149 | wedding | 90 | 80 | 60 | 50 | 0 | 80 | 0 | 11.9 | BCN | 0.1 | 0.1 | 10973 | Barcelona | Barcelonès | Carrer SANT PAU 9-11 | 41.3799 | 2.1687 | ES-CAT | Hotels | 4 estrelles | HB-000073 | ||||
| 348529 | 348529 | Nouvel | ES | stay | hotels | hotel | normal | 3 | star | 3 estrelles | 136 | wedding | 80 | 73 | 50 | 0 | 0 | 80 | 0 | 12.5 | BCN | 0.2 | 0.2 | 11022 | Barcelona | Barcelonès | Carrer Santa Anna 18-20 | 41.3823 | 2.176 | ES-CAT | Hotels | 3 estrelles | HB-000078 | ||||
| 348530 | 348530 | Oriente Atiram Hotel | ES | stay | hotels | hotel | normal | 3 | star | 3 estrelles | 270 | wedding | 90 | 83 | 60 | 0 | 0 | 80 | 0 | 11.9 | BCN | 0.1 | 0.1 | 10973 | Barcelona | Barcelonès | Carrer Rambla 45-47 | 41.3799 | 2.1687 | ES-CAT | Hotels | 3 estrelles | HB-000080 | ||||
| 348531 | 348531 | Palermo | ES | stay | hotels | hotel | normal | none | No aplica | 42 | wedding | 60 | 55 | 40 | 0 | 0 | 80 | 0 | 12.5 | BCN | 0.2 | 0.2 | 11022 | Barcelona | Barcelonès | Carrer Boqueria 21 | 41.3823 | 2.176 | ES-CAT | Hotels | No aplica | HB-000081 | |||||
| 348532 | 348532 | Park Hotel | ES | stay | hotels | hotel | normal | 3 | star | 3 estrelles | 157 | wedding | 90 | 73 | 60 | 0 | 0 | 80 | 0 | 13.0 | BCN | 0.3 | 0.3 | 11149 | Barcelona | Barcelonès | Avinguda Marquès de l'Argentera 11 | 41.3831 | 2.1848 | ES-CAT | Hotels | 3 estrelles | HB-000082 | ||||
| 348533 | 348533 | HOSTAL PENSION LOS MARTINEZ SL | ES | stay | hotels | hotel | normal | none | No aplica | 15 | wedding | 50 | 45 | 30 | 0 | 0 | 80 | 0 | 25.8 | BCN | 1.5 | 1.5 | 154 | Sabadell | Vallès Occidental | Carrer CAN VILOCA 52 | 41.5274 | 2.1163 | ES-CAT | Hotels | No aplica | HB-000083 | |||||
| 348534 | 348534 | Principal | ES | stay | hotels | hotel | normal | 3 | star | 3 estrelles | 174 | wedding | 90 | 73 | 60 | 0 | 0 | 80 | 0 | 11.9 | BCN | 0.1 | 0.1 | 10973 | Barcelona | Barcelonès | Carrer Junta del Comerç 8-12 | 41.3799 | 2.1687 | ES-CAT | Hotels | 3 estrelles | HB-000085 | ||||
| 348535 | 348535 | Fontanella Green House | ES | stay | hotels | hotel | normal | none | No aplica | 20 | wedding | 50 | 45 | 30 | 0 | 0 | 80 | 0 | 13.0 | BCN | 0.3 | 0.3 | 11149 | Barcelona | Barcelonès | Via Laietana 71 | 41.3831 | 2.1848 | ES-CAT | Hotels | No aplica | HB-000087 | |||||
| 348536 | 348536 | Lleó | ES | stay | hotels | hotel | normal | 3 | star | 3 estrelles | 175 | wedding | 90 | 73 | 60 | 0 | 0 | 80 | 0 | 11.9 | BCN | 0.1 | 0.1 | 10973 | Barcelona | Barcelonès | Carrer Pelai 22-26 | 41.3799 | 2.1687 | ES-CAT | Hotels | 3 estrelles | HB-000088 | ||||
| 348537 | 348537 | HOSTAL LEVANTE | ES | stay | hotels | hotel | normal | none | No aplica | 85 | wedding | 70 | 65 | 50 | 0 | 0 | 80 | 0 | 12.5 | BCN | 0.2 | 0.2 | 11022 | Barcelona | Barcelonès | Carrer Baixada de Sant Miquel 2 | 41.3823 | 2.176 | ES-CAT | Hotels | No aplica | HB-000089 | |||||
| 348538 | 348538 | Layetana | ES | stay | hotels | hotel | normal | none | No aplica | 32 | wedding | 60 | 45 | 30 | 0 | 0 | 80 | 0 | 12.5 | BCN | 0.2 | 0.2 | 11022 | Barcelona | Barcelonès | Plaça Ramon Berenguer el Gran 2 | 41.3823 | 2.176 | ES-CAT | Hotels | No aplica | HB-000090 | |||||
| 348539 | 348539 | Hostal Residencia Europa | ES | stay | hotels | hotel | normal | none | No aplica | 75 | wedding | 60 | 55 | 40 | 0 | 0 | 80 | 0 | 12.5 | BCN | 0.2 | 0.2 | 11022 | Barcelona | Barcelonès | Carrer Boqueria 18 | 41.3823 | 2.176 | ES-CAT | Hotels | No aplica | HB-000094 |
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, "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");