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
115 rows where country = "ES", family = "camping" and rating_value = 2
This data as json, CSV (advanced)
Suggested facets: rating_label, fit_wedding, reachability_score, isolation_score, nearest_airport, municipality, source, source_type, source_category
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 456589 | 456589 | CAMPING EL TORO AZUL | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 723 | wedding | 65 | 0 | 0 | 0 | 0 | 65 | 0 | 40.0 | GRO | 0.0 | 0.0 | 1112 | Arenys de Mar | Maresme | Carretera NACIONAL 2 658 | 41.5819 | 2.5494 | ES-CAT | Càmpings | 2 estrelles | KB-000004 | ||||
| 456590 | 456590 | CAMPING EL CARRO | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 180 | wedding | 65 | 0 | 0 | 0 | 0 | 65 | 0 | 38.0 | GRO | 2.8 | 0.0 | 1336 | Canet de Mar | Maresme | Carretera N-II KM 658,50 - | 41.5905 | 2.5812 | ES-CAT | Càmpings | 2 estrelles | KB-000011 | ||||
| 456591 | 456591 | Els Pins | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 441 | wedding | 65 | 0 | 0 | 0 | 0 | 80 | 0 | 28.7 | GRO | 0.0 | 0.0 | 1841 | Malgrat de Mar | Maresme | Camí Pomareda s/n | 41.6466 | 2.7413 | ES-CAT | Càmpings | 2 estrelles | KB-000013 | ||||
| 456593 | 456593 | Càmping Stella Maris | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 102 | wedding | 55 | 0 | 0 | 0 | 0 | 80 | 0 | 28.7 | GRO | 0.0 | 0.0 | 1841 | Malgrat de Mar | Maresme | Passeig Marítim 84 | 41.6466 | 2.7413 | ES-CAT | Càmpings | 2 estrelles | KB-000022 | ||||
| 456596 | 456596 | El Pinar | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 351 | wedding | 65 | 0 | 0 | 0 | 0 | 80 | 0 | 29.6 | GRO | 2.4 | 1.0 | 2439 | Santa Susanna | Maresme | Passeig Marítim s/n | 41.6411 | 2.7111 | ES-CAT | Càmpings | 2 estrelles | KB-000040 | ||||
| 456603 | 456603 | Costa Dorada | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 240 | wedding | 65 | 0 | 0 | 0 | 0 | 65 | 0 | 38.0 | GRO | 2.8 | 0.0 | 1336 | Canet de Mar | Maresme | Carretera N-II KM 660 | 41.5905 | 2.5812 | ES-CAT | Càmpings | 2 estrelles | KB-000058 | ||||
| 456609 | 456609 | Victoria | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 1038 | wedding | 65 | 0 | 0 | 0 | 0 | 65 | 0 | 38.0 | GRO | 2.8 | 0.0 | 1336 | Canet de Mar | Maresme | Carretera N-II km 659 s/n | 41.5905 | 2.5812 | ES-CAT | Càmpings | 2 estrelles | KB-000076 | ||||
| 456611 | 456611 | CAMPING MARCOS, SL | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 276 | wedding | 65 | 0 | 0 | 0 | 0 | 65 | 0 | 40.0 | GRO | 0.0 | 0.0 | 1112 | Arenys de Mar | Maresme | Carrer CARRETERA NACIONAL II 658 | 41.5819 | 2.5494 | ES-CAT | Càmpings | 2 estrelles | KB-000083 | ||||
| 456615 | 456615 | L'Esplanada | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 210 | wedding | 65 | 0 | 0 | 0 | 0 | 65 | 0 | 34.2 | Folgueroles Airfield | 5.6 | 0.0 | 55 | Santa Eulàlia de Ronçana | Vallès Oriental | Carretera Barcelona KM 11,825 | 41.65 | 2.2333 | ES-CAT | Càmpings | 2 estrelles | KB-000093 | ||||
| 456624 | 456624 | Can Cervera | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 150 | wedding | 65 | 0 | 0 | 0 | 0 | 65 | 0 | 30.5 | Folgueroles Airfield | 3.5 | 0.7 | 96 | Montseny | Vallès Oriental | Disseminat Can Cervera s/n | 41.7 | 2.45 | ES-CAT | Càmpings | 2 estrelles | KB-000126 | ||||
| 456626 | 456626 | FONTMARTINA | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 750 | wedding | 65 | 0 | 0 | 0 | 0 | 80 | 0 | 27.1 | Folgueroles Airfield | 5.9 | 0.0 | 104 | Fogars de Montclús | Vallès Oriental | Carretera BV 5119 10 | 41.7333 | 2.45 | ES-CAT | Càmpings | 2 estrelles | KB-000136 | ||||
| 456628 | 456628 | Marisol | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 144 | wedding | 55 | 0 | 0 | 0 | 0 | 80 | 0 | 28.7 | GRO | 0.0 | 0.0 | 1841 | Malgrat de Mar | Maresme | Camí Pomareda s/n | 41.6466 | 2.7413 | ES-CAT | Càmpings | 2 estrelles | KB-000166 | ||||
| 456629 | 456629 | Celmar | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 165 | wedding | 65 | 0 | 0 | 0 | 0 | 80 | 0 | 28.7 | GRO | 0.0 | 0.0 | 1841 | Malgrat de Mar | Maresme | Camí Pomareda s/n | 41.6466 | 2.7413 | ES-CAT | Càmpings | 2 estrelles | KB-000167 | ||||
| 456631 | 456631 | Camping Les Illes | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 150 | wedding | 65 | 0 | 0 | 0 | 0 | 70 | 20 | 22.8 | Folgueroles Airfield | 11.0 | 5.3 | 22 | Montseny | Vallès Oriental | Carretera Santa Maria Palautordera-Seva km. 20 s/n | 41.7588 | 2.3953 | ES-CAT | Càmpings | 2 estrelles | KB-000171 | ||||
| 456634 | 456634 | Parc Mediambiental de Gualba | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 324 | wedding | 65 | 0 | 0 | 0 | 0 | 80 | 0 | 28.8 | GRO | 4.8 | 0.3 | 58 | Gualba | Vallès Oriental | Disseminat Can Illa Vell s/n | 41.7315 | 2.5026 | ES-CAT | Càmpings | 2 estrelles | KB-000186 | ||||
| 456638 | 456638 | Rectoria de la Selva | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 102 | wedding | 55 | 0 | 0 | 0 | 0 | 45 | 20 | 43.1 | LEU | 39.3 | 9.5 | 50 | Navès | Solsonès | Carrer Rectoria de la Selva s/n | 41.9509 | 1.4178 | ES-CAT | Càmpings | 2 estrelles | KCC-000054 | ||||
| 456643 | 456643 | Vilademàger | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 90 | wedding | 55 | 0 | 0 | 0 | 0 | 55 | 0 | 47.1 | REU | 14.1 | 0.0 | 21 | Llacuna, la | Anoia | Disseminat Can Marquet s/n | 41.4712 | 1.5326 | ES-CAT | Càmpings | 2 estrelles | KCC-000119 | ||||
| 456644 | 456644 | La Balma | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 270 | wedding | 65 | 0 | 0 | 0 | 0 | 70 | 10 | 13.0 | Folgueroles Airfield | 15.1 | 3.3 | 45 | Espinelves | Osona | Carretera C-25 Girona-Lleida,sortida 202,1km dir. espinelves 202 | 41.8691 | 2.4178 | ES-CAT | Càmpings | 2 estrelles | KCC-000120 | ||||
| 456648 | 456648 | Aigua d'Ora | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 525 | wedding | 65 | 0 | 0 | 0 | 0 | 55 | 0 | 32.9 | Folgueroles Airfield | 12.7 | 0.0 | 33 | Castellar del Riu | Berguedà | Carretera Berga-Sant Llorenç KM 19 | 42.1356 | 1.9943 | ES-CAT | Càmpings | 2 estrelles | KCC-000134 | ||||
| 456652 | 456652 | Càmping Mirador al Pedraforca | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 174 | wedding | 65 | 0 | 0 | 0 | 0 | 70 | 0 | 29.3 | LEU | 16.6 | 0.7 | 21 | Saldes | Berguedà | Carretera de lObaga s/n | 42.2275 | 1.7327 | ES-CAT | Càmpings | 2 estrelles | KCC-000146 | ||||
| 456655 | 456655 | Molí de Bojons | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 177 | wedding | 65 | 0 | 0 | 0 | 0 | 80 | 0 | 3.7 | Folgueroles Airfield | 5.8 | 0.0 | 31 | Sant Sadurní d'Osormort | Osona | Carretera Vic-Sant Hilari, C-25 sortida 195 KM 13 | 41.9219 | 2.3245 | ES-CAT | Càmpings | 2 estrelles | KCC-000152 | ||||
| 456659 | 456659 | La Vall de Merlès | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 282 | wedding | 65 | 0 | 0 | 0 | 0 | 70 | 10 | 27.3 | Folgueroles Airfield | 16.2 | 4.5 | 33 | Santa Maria de Merlès | Berguedà | Cases Riambau s/n | 42.0 | 1.9833 | ES-CAT | Càmpings | 2 estrelles | KCC-000158 | ||||
| 456660 | 456660 | CAMPING SUSEN | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 213 | wedding | 65 | 0 | 0 | 0 | 0 | 70 | 0 | 29.3 | LEU | 16.6 | 0.7 | 21 | Saldes | Berguedà | Carretera CASA SUSEN B400 KM10,5 | 42.2275 | 1.7327 | ES-CAT | Càmpings | 2 estrelles | KCC-000159 | ||||
| 456661 | 456661 | La Tatgera | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 138 | wedding | 55 | 0 | 0 | 0 | 0 | 70 | 10 | 29.5 | Folgueroles Airfield | 19.4 | 0.0 | 10 | Talamanca | Bages | Carretera BV-1221 KM 29,6 | 41.8637 | 1.9709 | ES-CAT | Càmpings | 2 estrelles | KCC-000162 | ||||
| 456662 | 456662 | Cal Paradís | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 132 | wedding | 55 | 0 | 0 | 0 | 0 | 55 | 40 | 56.6 | Folgueroles Airfield | 20.0 | 8.4 | 3 | Sant Mateu de Bages | Bages | Carretera BV-3002 , km 9 KM 9,220 | 41.8444 | 1.6395 | ES-CAT | Càmpings | 2 estrelles | KCC-000163 | ||||
| 456663 | 456663 | CAMPING FREIXA | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 234 | wedding | 65 | 0 | 0 | 0 | 0 | 65 | 0 | 46.0 | Folgueroles Airfield | 1.2 | 1.2 | 182 | Manresa | Bages | Camí DEL GRAU C-16 KM 3 s/n | 41.7322 | 1.8369 | ES-CAT | Càmpings | 2 estrelles | KCC-000168 | ||||
| 456666 | 456666 | Puig-reig | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 231 | wedding | 65 | 0 | 0 | 0 | 0 | 55 | 10 | 35.1 | Folgueroles Airfield | 15.6 | 0.0 | 17 | Puig-reig | Berguedà | Disseminat Cal Rector s/n | 41.9667 | 1.8833 | ES-CAT | Càmpings | 2 estrelles | KCC-000174 | ||||
| 456667 | 456667 | Santa Eugènia Park | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 315 | wedding | 65 | 0 | 0 | 0 | 0 | 80 | 0 | 6.2 | Folgueroles Airfield | 4.1 | 0.0 | 47 | Santa Eugènia de Berga | Osona | Urbanització Creu del Cim s/n | 41.9 | 2.2833 | ES-CAT | Càmpings | 2 estrelles | KCC-000175 | ||||
| 456669 | 456669 | Serrat Roig | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 129 | wedding | 55 | 0 | 0 | 0 | 0 | 65 | 0 | 39.8 | Folgueroles Airfield | 4.2 | 0.0 | 114 | Avià | Berguedà | Carrer Afores s/n | 42.0667 | 1.85 | ES-CAT | Càmpings | 2 estrelles | KCC-000177 | ||||
| 456672 | 456672 | Hostalet | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 354 | wedding | 65 | 0 | 0 | 0 | 0 | Viver i Serrateix | Berguedà | Carretera B-423 Serrateix-Sura s/n | ES-CAT | Càmpings | 2 estrelles | KCC-000200 | |||||||||||||
| 456673 | 456673 | Forest Days | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 12 | 35 | 0 | 0 | 0 | 0 | 45 | 20 | 43.1 | LEU | 39.3 | 9.5 | 50 | Navès | Solsonès | Cases Corbera s/n | 41.9509 | 1.4178 | ES-CAT | Càmpings | 2 estrelles | KCC-000202 | |||||
| 456674 | 456674 | CAMPING MONTSERRAT | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 375 | wedding | 65 | 0 | 0 | 0 | 0 | 65 | 10 | 50.2 | BCN | 6.9 | 0.0 | 14 | Sant Salvador de Guardiola | Bages | Cases COMASUA 13 | 41.6833 | 1.7667 | ES-CAT | Càmpings | 2 estrelles | KCC-000228 | ||||
| 456689 | 456689 | CAMPING PLA DE LA TORRE | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 210 | wedding | 65 | 0 | 0 | 0 | 0 | 80 | 0 | 26.3 | GRO | 4.8 | 0.6 | 4232 | Calonge i Sant Antoni | Baix Empordà | Carrer PINEDA 23 | 41.8634 | 3.0752 | ES-CAT | Càmpings | 2 estrelles | KG-000018 | ||||
| 456695 | 456695 | CAMPING INTERNACIONAL DE PALAMOS | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 1359 | wedding | 65 | 0 | 0 | 0 | 0 | 65 | 0 | 31.0 | GRO | 2.1 | 1.6 | 5703 | Palamós | Baix Empordà | Camí CAP DE PLANES s/n | 41.8667 | 3.1333 | ES-CAT | Càmpings | 2 estrelles | KG-000025 | ||||
| 456711 | 456711 | Pous | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 150 | wedding | 65 | 0 | 0 | 0 | 0 | 65 | 0 | 43.3 | GRO | 0.2 | 0.2 | 416 | Figueres | Alt Empordà | Carretera Nacional II KM 8,5 | 42.2651 | 2.9618 | ES-CAT | Càmpings | 2 estrelles | KG-000043 | ||||
| 456718 | 456718 | Les Tries | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 216 | wedding | 65 | 0 | 0 | 0 | 0 | 80 | 0 | 29.3 | Folgueroles Airfield | 0.6 | 0.6 | 220 | Olot | Garrotxa | Avinguda Pere Badosa 11 | 42.1812 | 2.4834 | ES-CAT | Càmpings | 2 estrelles | KG-000053 | ||||
| 456720 | 456720 | Solana de Ter | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 159 | wedding | 65 | 0 | 0 | 0 | 0 | 70 | 0 | 28.9 | Folgueroles Airfield | 16.0 | 0.3 | 79 | Ripoll | Ripollès | Carretera Comarcal 17 KM 92,5 | 42.1984 | 2.1931 | ES-CAT | Càmpings | 2 estrelles | KG-000055 | ||||
| 456735 | 456735 | Castell d'Aro | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 840 | wedding | 65 | 0 | 0 | 0 | 0 | 70 | 10 | 12.4 | GRO | 13.0 | 2.8 | 134 | Castell d'Aro, Platja d'Aro i s'Agaró | Baix Empordà | Carretera S'Agaró KM 1 | 41.8844 | 2.9093 | ES-CAT | Càmpings | 2 estrelles | KG-000074 | ||||
| 456736 | 456736 | Molí Serradell | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 228 | wedding | 65 | 0 | 0 | 0 | 0 | 55 | 10 | 34.5 | Folgueroles Airfield | 21.7 | 2.3 | 29 | Campdevànol | Ripollès | Carretera crta de Gombrèn km 4,5 0 | 42.2455 | 2.1672 | ES-CAT | Càmpings | 2 estrelles | KG-000075 | ||||
| 456765 | 456765 | Sadernes | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 123 | wedding | 55 | 0 | 0 | 0 | 0 | 55 | 0 | 35.9 | GRO | 13.0 | 0.1 | 106 | Sales de Llierca | Garrotxa | Camí Montagut-Sant Aniol s/n | 42.2151 | 2.6413 | ES-CAT | Càmpings | 2 estrelles | KG-000109 | ||||
| 456769 | 456769 | CAMPING AMPURDANES | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 153 | wedding | 65 | 0 | 0 | 0 | 0 | 65 | 0 | 52.7 | GRO | 0.2 | 0.2 | 5350 | Roses | Alt Empordà | Lloc Almadraba-Rembrandt B 12 | 42.2632 | 3.1785 | ES-CAT | Càmpings | 2 estrelles | KG-000113 | ||||
| 456771 | 456771 | Vila Village | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 114 | wedding | 55 | 0 | 0 | 0 | 0 | 70 | 10 | 20.0 | GRO | 13.0 | 4.4 | 31 | Sant Feliu de Buixalleu | Selva | Carretera 35 KM 67 | 41.7833 | 2.5833 | ES-CAT | Càmpings | 2 estrelles | KG-000115 | ||||
| 456773 | 456773 | Resort Guilleries | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 150 | wedding | 65 | 0 | 0 | 0 | 0 | 70 | 10 | 17.7 | GRO | 19.9 | 4.8 | 36 | Osor | Selva | Passeig de la Piscina s/n | 41.946 | 2.5554 | ES-CAT | Càmpings | 2 estrelles | KG-000118 | ||||
| 456775 | 456775 | Can Toni Manescal | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 135 | wedding | 55 | 0 | 0 | 0 | 0 | 80 | 0 | 4.9 | GRO | 5.0 | 0.0 | 172 | Fornells de la Selva | Gironès | Barri Barceloneta-bústia B9 | 41.9316 | 2.8091 | ES-CAT | Càmpings | 2 estrelles | KG-000122 | ||||
| 456779 | 456779 | Els Alous | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 60 | 45 | 0 | 0 | 0 | 0 | 65 | 0 | 35.8 | Folgueroles Airfield | 6.5 | 0.0 | 76 | Montagut i Oix | Garrotxa | Disseminat Els Alous s/n | 42.2197 | 2.5495 | ES-CAT | Càmpings | 2 estrelles | KG-000126 | |||||
| 456781 | 456781 | La Fradera | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 150 | wedding | 65 | 0 | 0 | 0 | 0 | 55 | 0 | 46.2 | GRO | 15.4 | 0.0 | 32 | Sant Llorenç de la Muga | Alt Empordà | Carretera GI-511 KM 6,7 | 42.3198 | 2.7889 | ES-CAT | Càmpings | 2 estrelles | KG-000128 | ||||
| 456782 | 456782 | La Vall del Vidal | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 93 | wedding | 55 | 0 | 0 | 0 | 0 | 70 | 0 | 22.5 | GRO | 14.4 | 0.0 | 90 | Arbúcies | Selva | Disseminat El Vidal s/n | 41.8167 | 2.5167 | ES-CAT | Càmpings | 2 estrelles | KG-000129 | ||||
| 456787 | 456787 | Masia Can Patxet | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 162 | wedding | 65 | 0 | 0 | 0 | 0 | 65 | 0 | 30.5 | Folgueroles Airfield | 7.7 | 0.2 | 154 | Santa Pau | Garrotxa | Carrer Can Patxet s/n | 42.1455 | 2.5702 | ES-CAT | Càmpings | 2 estrelles | KG-000135 | ||||
| 456790 | 456790 | CAMPING PARDINES | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 234 | wedding | 65 | 0 | 0 | 0 | 0 | 55 | 0 | 41.5 | Folgueroles Airfield | 28.7 | 1.1 | 190 | Pardines | Ripollès | Cases CAN BARRATORT s/n | 42.3129 | 2.1737 | ES-CAT | Càmpings | 2 estrelles | KG-000139 | ||||
| 456791 | 456791 | Masia Can Coromines | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 135 | wedding | 55 | 0 | 0 | 0 | 0 | 55 | 0 | 36.5 | GRO | 12.3 | 1.0 | 106 | Maià de Montcal | Garrotxa | Edifici Can Coromines s/n | 42.2183 | 2.6304 | ES-CAT | Càmpings | 2 estrelles | KG-000140 | ||||
| 456792 | 456792 | CÀMPING MOLÍ DE VILAMALA | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 111 | wedding | 55 | 0 | 0 | 0 | 0 | 70 | 10 | 23.3 | GRO | 14.8 | 2.6 | 65 | Planes d'Hostoles, les | Garrotxa | Lloc MAS MOLI DE VILAMALA s/n | 42.0667 | 2.5833 | ES-CAT | Càmpings | 2 estrelles | KG-000141 | ||||
| 456795 | 456795 | MASIA CAN BANAL | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 210 | wedding | 65 | 0 | 0 | 0 | 0 | 55 | 0 | 38.7 | GRO | 10.3 | 0.0 | 124 | Montagut i Oix | Garrotxa | Carrer Sant Eudald s/n | 42.23 | 2.5963 | ES-CAT | Càmpings | 2 estrelles | KG-000146 | ||||
| 456798 | 456798 | Mas Coguleres | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 108 | wedding | 55 | 0 | 0 | 0 | 0 | 65 | 0 | 30.5 | Folgueroles Airfield | 7.7 | 0.2 | 154 | Santa Pau | Garrotxa | Camí Mas Coguleres 1 | 42.1455 | 2.5702 | ES-CAT | Càmpings | 2 estrelles | KG-000149 | ||||
| 456799 | 456799 | CÀMPING L'ALGUER | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 231 | wedding | 65 | 0 | 0 | 0 | 0 | 70 | 10 | 23.3 | GRO | 14.8 | 2.6 | 65 | Planes d'Hostoles, les | Garrotxa | Carretera DE LES ENCIES SN | 42.0667 | 2.5833 | ES-CAT | Càmpings | 2 estrelles | KG-000150 | ||||
| 456800 | 456800 | Càmping Riudarenes | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 507 | wedding | 65 | 0 | 0 | 0 | 0 | 70 | 0 | 9.7 | GRO | 13.9 | 0.8 | 252 | Riudarenes | Selva | Carretera Mallorquines-Hostalric km 7 | 41.8243 | 2.7164 | ES-CAT | Càmpings | 2 estrelles | KG-000151 | ||||
| 456801 | 456801 | Saiol | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 150 | wedding | 65 | 0 | 0 | 0 | 0 | 70 | 10 | 28.7 | Folgueroles Airfield | 16.0 | 3.4 | 81 | Llosses, les | Ripollès | Disseminat Can Saiol s/n | 42.185 | 2.1552 | ES-CAT | Càmpings | 2 estrelles | KG-000152 | ||||
| 456802 | 456802 | La Bauma | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 60 | 45 | 0 | 0 | 0 | 0 | 70 | 10 | 27.1 | Folgueroles Airfield | 15.5 | 4.3 | 114 | Vallfogona de Ripollès | Ripollès | Lloc La Bauma s/n | 42.1966 | 2.3034 | ES-CAT | Càmpings | 2 estrelles | KG-000153 | |||||
| 456805 | 456805 | Camping la Vall de Campmajor | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 150 | wedding | 65 | 0 | 0 | 0 | 0 | 80 | 10 | 23.1 | GRO | 8.5 | 3.4 | 24 | Sant Miquel de Campmajor | Pla de l'Estany | Carretera Collell KM 1,500 | 42.1 | 2.6667 | ES-CAT | Càmpings | 2 estrelles | KG-000156 | ||||
| 456811 | 456811 | La Sureda | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 363 | wedding | 65 | 0 | 0 | 0 | 0 | 70 | 0 | 22.5 | GRO | 14.4 | 0.0 | 90 | Arbúcies | Selva | Carretera GI-550 KM 4,7 | 41.8167 | 2.5167 | ES-CAT | Càmpings | 2 estrelles | KG-000164 | ||||
| 456812 | 456812 | Cabanes als Arbres | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 102 | wedding | 55 | 0 | 0 | 0 | 0 | 70 | 0 | 18.9 | Folgueroles Airfield | 21.1 | 0.6 | 71 | Sant Hilari Sacalm | Selva | Carretera de Vallclara s/n | 41.8782 | 2.5131 | ES-CAT | Càmpings | 2 estrelles | KG-000165 | ||||
| 456813 | 456813 | Montori Rural | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 153 | wedding | 65 | 0 | 0 | 0 | 0 | 70 | 0 | 27.3 | GRO | 15.7 | 1.3 | 264 | Ultramort | Baix Empordà | Camí Vell de Rupià s/n | 42.0289 | 3.0462 | ES-CAT | Càmpings | 2 estrelles | KG-000166 | ||||
| 456814 | 456814 | Can Bora Lodges | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 54 | 45 | 0 | 0 | 0 | 0 | 70 | 10 | 10.6 | GRO | 10.2 | 3.2 | 35 | Sant Gregori | Gironès | Disseminat Camping Can Bora Lodges S/N | 41.9705 | 2.6694 | ES-CAT | Càmpings | 2 estrelles | KG-000220 | |||||
| 456815 | 456815 | Cabanyes entre valls | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 24 | 35 | 0 | 0 | 0 | 0 | 80 | 10 | 29.2 | Folgueroles Airfield | 4.2 | 2.9 | 322 | Vall de Bianya, la | Garrotxa | Camí Mas Espunya s/n | 42.1569 | 2.5301 | ES-CAT | Càmpings | 2 estrelles | KG-000221 | |||||
| 456823 | 456823 | CAMPING BONETA | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 135 | wedding | 55 | 0 | 0 | 0 | 0 | 45 | 0 | 53.2 | LEU | 59.0 | 0.1 | 483 | Vall de Boí, la | Alta Ribagorça | Carrer del Riu 3 | 42.5049 | 0.8011 | ES-CAT | Càmpings | 2 estrelles | KL-000006 | ||||
| 456824 | 456824 | Buchaca | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 180 | wedding | 65 | 0 | 0 | 0 | 0 | 70 | 20 | 5.7 | LEU | 20.1 | 8.6 | 28 | Montferrer i Castellbó | Alt Urgell | Carretera C-1313 KM 127 | 42.3733 | 1.3583 | ES-CAT | Càmpings | 2 estrelles | KL-000008 | ||||
| 456829 | 456829 | CAMPING VALL D'ANEU | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 120 | wedding | 55 | 0 | 0 | 0 | 0 | 45 | 0 | 37.6 | LEU | 36.4 | 0.0 | 129 | Guingueta d'Àneu, la | Pallars Sobirà | Carretera C-147 s/n | 42.5784 | 1.0867 | ES-CAT | Càmpings | 2 estrelles | KL-000014 | ||||
| 456831 | 456831 | Serra | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 351 | wedding | 65 | 0 | 0 | 0 | 0 | 55 | 30 | 34.0 | LEU | 25.5 | 13.9 | 50 | Lladorre | Pallars Sobirà | Carretera Llavorsí-Tavascan KM 15,7 | 42.6205 | 1.2497 | ES-CAT | Càmpings | 2 estrelles | KL-000017 | ||||
| 456837 | 456837 | Noguera Pallaresa | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 600 | wedding | 65 | 0 | 0 | 0 | 0 | 60 | 0 | 24.3 | LEU | 33.8 | 0.2 | 239 | Sort | Pallars Sobirà | Carretera C-147 KM 110 | 42.4117 | 1.1306 | ES-CAT | Càmpings | 2 estrelles | KL-000027 | ||||
| 456842 | 456842 | Pica d'Estats | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 162 | wedding | 65 | 0 | 0 | 0 | 0 | 70 | 30 | 28.6 | LEU | 18.3 | 11.2 | 28 | Alins | Pallars Sobirà | Carretera Llavorsí-Àreu KM 18,6 | 42.5889 | 1.3266 | ES-CAT | Càmpings | 2 estrelles | KL-000033 | ||||
| 456843 | 456843 | Molí de Fórnols | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 132 | wedding | 55 | 0 | 0 | 0 | 0 | 70 | 20 | 17.5 | LEU | 27.1 | 7.7 | 23 | Vansa i Fórnols, la | Alt Urgell | Carretera Vansa s/n | 42.2333 | 1.5667 | ES-CAT | Càmpings | 2 estrelles | KL-000034 | ||||
| 456845 | 456845 | Frontera | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 690 | wedding | 65 | 0 | 0 | 0 | 0 | 70 | 10 | 6.0 | LEU | 15.2 | 2.4 | 109 | Valls de Valira, les | Alt Urgell | Carretera d'Andorra KM 8 | 42.3798 | 1.4572 | ES-CAT | Càmpings | 2 estrelles | KL-000039 | ||||
| 456849 | 456849 | Aigües Braves | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 300 | wedding | 65 | 0 | 0 | 0 | 0 | 70 | 10 | 23.7 | LEU | 22.2 | 2.9 | 68 | Llavorsí | Pallars Sobirà | Carretera Esterri s/n | 42.5167 | 1.25 | ES-CAT | Càmpings | 2 estrelles | KL-000048 | ||||
| 456850 | 456850 | Solau | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 66 | 45 | 0 | 0 | 0 | 0 | 45 | 0 | 37.6 | LEU | 36.4 | 0.0 | 129 | Espot | Pallars Sobirà | Carrer Sant Maurici s/n | 42.5784 | 1.0867 | ES-CAT | Càmpings | 2 estrelles | KL-000049 | |||||
| 456854 | 456854 | Taüll | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 342 | wedding | 65 | 0 | 0 | 0 | 0 | 45 | 10 | 50.3 | LEU | 55.2 | 4.2 | 483 | Vall de Boí, la | Alta Ribagorça | Carretera Taüll s/n | 42.5203 | 0.8474 | ES-CAT | Càmpings | 2 estrelles | KL-000053 | ||||
| 456856 | 456856 | Alta Ribagorça | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 96 | wedding | 55 | 0 | 0 | 0 | 0 | 35 | 0 | 55.4 | LEU | 64.9 | 0.0 | 77 | Pont de Suert, el | Alta Ribagorça | Carrer Les Bordes s/n | 42.4082 | 0.7417 | ES-CAT | Càmpings | 2 estrelles | KL-000057 | ||||
| 456857 | 456857 | Sol i Fred | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 300 | wedding | 65 | 0 | 0 | 0 | 0 | 45 | 40 | 44.8 | LEU | 53.8 | 11.1 | 19 | Sarroca de Bellera | Pallars Jussà | Carretera Esglésies s/n | 42.4201 | 0.8756 | ES-CAT | Càmpings | 2 estrelles | KL-000058 | ||||
| 456859 | 456859 | CAMPING LLAVORSI - RIBERIES | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 156 | wedding | 65 | 0 | 0 | 0 | 0 | 70 | 10 | 23.7 | LEU | 22.2 | 2.9 | 68 | Llavorsí | Pallars Sobirà | Camí DE RIBERIES 1 | 42.5167 | 1.25 | ES-CAT | Càmpings | 2 estrelles | KL-000061 | ||||
| 456861 | 456861 | Organyà | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 162 | wedding | 65 | 0 | 0 | 0 | 0 | 60 | 20 | 18.1 | LEU | 35.8 | 8.7 | 42 | Organyà | Alt Urgell | Passatge Lloredes s/n | 42.1761 | 1.4226 | ES-CAT | Càmpings | 2 estrelles | KL-000063 | ||||
| 456868 | 456868 | Camping Terra del Congost | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 30 | 45 | 0 | 0 | 0 | 0 | 45 | 10 | 47.2 | LEU | 34.3 | 4.6 | 38 | Tremp | Pallars Jussà | Camí de Les Cases del Pacient s/n | 41.9548 | 1.1653 | ES-CAT | Càmpings | 2 estrelles | KL-000233 | |||||
| 456870 | 456870 | Cala d'Oques | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 456 | wedding | 65 | 0 | 0 | 0 | 0 | 65 | 10 | 37.9 | REU | 4.8 | 2.6 | 2140 | Vandellòs i l'Hospitalet de l'Infant | Baix Camp | Via Augusta s/n | 41.1791 | 1.619 | ES-CAT | Càmpings | 2 estrelles | KT-000010 | ||||
| 456871 | 456871 | Platja Llarga | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 126 | wedding | 55 | 0 | 0 | 0 | 0 | 80 | 0 | 8.0 | REU | 1.2 | 1.2 | 2145 | Tarragona | Tarragonès | Carretera N-340 KM 11 | 41.1238 | 1.2585 | ES-CAT | Càmpings | 2 estrelles | KT-000014 | ||||
| 456879 | 456879 | Mar de Cunit | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 648 | wedding | 65 | 0 | 0 | 0 | 0 | 80 | 0 | 9.9 | BCN | 1.3 | 1.3 | 3979 | Cunit | Baix Penedès | Avinguda Tarragona 146 | 41.2667 | 1.9667 | ES-CAT | Càmpings | 2 estrelles | KT-000028 | ||||
| 456881 | 456881 | La Llosa | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 1212 | wedding | 65 | 0 | 0 | 0 | 0 | 80 | 0 | 12.4 | REU | 0.2 | 0.2 | 3793 | Cambrils | Baix Camp | Carretera N-340-Partida Les Lloses KM 1143 | 41.0721 | 1.0597 | ES-CAT | Càmpings | 2 estrelles | KT-000032 | ||||
| 456882 | 456882 | Sant Salvador | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 1089 | wedding | 65 | 0 | 0 | 0 | 0 | 80 | 0 | 29.0 | BCN | 1.6 | 1.6 | 3442 | Vendrell, el | Baix Penedès | Avinguda Palfuriana 88-92 | 41.2283 | 1.7438 | ES-CAT | Càmpings | 2 estrelles | KT-000039 | ||||
| 456889 | 456889 | Las Salinas | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 246 | wedding | 65 | 0 | 0 | 0 | 0 | 80 | 0 | 8.0 | REU | 1.2 | 1.2 | 2145 | Tarragona | Tarragonès | Lloc Llarga s/n | 41.1238 | 1.2585 | ES-CAT | Càmpings | 2 estrelles | KT-000071 | ||||
| 456890 | 456890 | La Corona | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 1800 | wedding | 65 | 0 | 0 | 0 | 0 | 80 | 0 | 12.4 | REU | 0.2 | 0.2 | 3793 | Cambrils | Baix Camp | Avinguda Mas de Clariana s/n | 41.0721 | 1.0597 | ES-CAT | Càmpings | 2 estrelles | KT-000076 | ||||
| 456913 | 456913 | Siurana | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 102 | wedding | 55 | 0 | 0 | 0 | 0 | 70 | 30 | 23.2 | REU | 18.5 | 2.4 | 5 | Cornudella de Montsant | Priorat | Carrer Coll de Ginebre s/n | 41.2579 | 0.9324 | ES-CAT | Càmpings | 2 estrelles | KT-000128 | ||||
| 456924 | 456924 | La Tancada | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 54 | 45 | 0 | 0 | 0 | 0 | 65 | 0 | 69.5 | REU | 0.1 | 0.1 | 425 | Amposta | Montsià | Partida La Tancada-pol 78 83 | 40.7095 | 0.5774 | ES-CAT | Càmpings | 2 estrelles | KTE-000120 | |||||
| 456926 | 456926 | Riba-roja | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 195 | wedding | 65 | 0 | 0 | 0 | 0 | 45 | 30 | 53.3 | ILD | 42.4 | 6.0 | 17 | Riba-roja d'Ebre | Ribera d'Ebre | Carretera TV-7411-Embassament de Riba-roja d'Ebre KM 6 | 41.25 | 0.4833 | ES-CAT | Càmpings | 2 estrelles | KTE-000124 | ||||
| 456929 | 456929 | Sense especificar | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 123 | wedding | 55 | 0 | 0 | 0 | 0 | 45 | 20 | 62.5 | ILD | 43.1 | 0.0 | 4 | Pobla de Massaluca, la | Terra Alta | Carretera TV 7231 KM 29 | 41.1833 | 0.35 | ES-CAT | Càmpings | 2 estrelles | KTE-000135 | ||||
| 456934 | 456934 | Espalias | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 138 | wedding | 55 | 0 | 0 | 0 | 0 | 35 | 10 | 41.3 | Aérodrome de Saint-Girons - Antichan | 69.9 | 3.2 | 154 | Bossòst | Aran | Carretera N-230 KM 180 | 42.7833 | 0.7 | ES-CAT | Càmpings | 2 estrelles | KVA-000036 | ||||
| 456939 | 456939 | Era Lana | ES | stay | camping | camping | normal | 2 | star | 2 estrelles | 84 | wedding | 55 | 0 | 0 | 0 | 0 | 35 | 20 | 42.2 | Aérodrome de Saint-Girons - Antichan | 70.2 | 7.2 | 101 | Arres | Aran | Camí Reiau s/n | 42.7475 | 0.7269 | ES-CAT | Càmpings | 2 estrelles | KVA-000059 | ||||
| 561972 | 561972 | LA TORRETA | ES | stay | camping | camping | normal | 2 | star | DOS ESTRELLAS | 35 | 0 | 0 | 0 | 0 | 65 | 0 | 46.9 | ALC | 0.0 | 0.0 | 5653 | BENIDORM | ALICANTE/ALACANT | AV Dr. Severo Ochoa 11 | 38.5382 | -0.131 | ES-GVA | Camping | DOS ESTRELLAS | CV-CAM000042-A | ||||||
| 561973 | 561973 | BENIDORM | ES | stay | camping | camping | normal | 2 | star | DOS ESTRELLAS | 35 | 0 | 0 | 0 | 0 | 65 | 0 | 46.9 | ALC | 0.0 | 0.0 | 5653 | BENIDORM | ALICANTE/ALACANT | AV Dr. Severo Ochoa S.N | 38.5382 | -0.131 | ES-GVA | Camping | DOS ESTRELLAS | CV-CAM000016-A | ||||||
| 561978 | 561978 | CAMPERALIA FINESTRAT | ES | stay | camping | camping | normal | 2 | star | DOS ESTRELLAS | 35 | 0 | 0 | 0 | 0 | 65 | 0 | 43.7 | ALC | 6.9 | 0.0 | 855 | FINESTRAT | ALICANTE/ALACANT | C Beniarres 6 | 38.5674 | -0.2124 | ES-GVA | Camping | DOS ESTRELLAS | CV-CAM000122-A | ||||||
| 561980 | 561980 | FONTS DE L'ALGAR | ES | stay | camping | camping | normal | 2 | star | DOS ESTRELLAS | 35 | 0 | 0 | 0 | 0 | 65 | 0 | 56.1 | ALC | 4.1 | 0.0 | 242 | CALLOSA D'EN SARRIÀ | ALICANTE/ALACANT | PD ALGAR - PDA. TORRETA-SEGARRA 146 | 38.65 | -0.1167 | ES-GVA | Camping | DOS ESTRELLAS | CV-CAM000119-A | ||||||
| 561983 | 561983 | CAMPER AREA 7 | ES | stay | camping | camping | normal | 2 | star | DOS ESTRELLAS | 35 | 0 | 0 | 0 | 0 | 80 | 0 | 21.5 | ALC | 0.0 | 0.0 | 2077 | CAMPELLO, EL | ALICANTE/ALACANT | AV Fabraquer 14 | 38.4288 | -0.3977 | ES-GVA | Camping | DOS ESTRELLAS | CV-CAM000104-A | ||||||
| 561984 | 561984 | AREA NATUR PLAYAMUCHAVISTA | ES | stay | camping | camping | normal | 2 | star | DOS ESTRELLAS | 35 | 0 | 0 | 0 | 0 | 80 | 0 | 21.5 | ALC | 0.0 | 0.0 | 2077 | CAMPELLO, EL | ALICANTE/ALACANT | C ANCORES 25-29 | 38.4288 | -0.3977 | ES-GVA | Camping | DOS ESTRELLAS | CV-CAM000116-A | ||||||
| 561985 | 561985 | CAMPER AREA CAMPELLO BEACH | ES | stay | camping | camping | normal | 2 | star | DOS ESTRELLAS | 35 | 0 | 0 | 0 | 0 | 80 | 0 | 21.5 | ALC | 0.0 | 0.0 | 2077 | CAMPELLO, EL | ALICANTE/ALACANT | C Juan de laCierva 8 | 38.4288 | -0.3977 | ES-GVA | Camping | DOS ESTRELLAS | CV-CAM000094-A | ||||||
| 561986 | 561986 | CAMPER PARK ALICANTE | ES | stay | camping | camping | normal | 2 | star | DOS ESTRELLAS | 35 | 0 | 0 | 0 | 0 | 80 | 0 | 21.5 | ALC | 0.0 | 0.0 | 2077 | CAMPELLO, EL | ALICANTE/ALACANT | C/ Palamós, nº 7-Parc. A1 | 38.4288 | -0.3977 | ES-GVA | Camping | DOS ESTRELLAS | CV-CAM000133-A |
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");