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
340 rows where country = "ES", family = "hostels" and group = "stay"
This data as json, CSV (advanced)
Suggested facets: rating_label, fit_wedding, reachability_score, isolation_score, nearest_airport, municipality, source, source_type, source_category
group 1
- stay · 340 ✖
family 1
- hostels · 340 ✖
country 1
- ES · 340 ✖
best_for 1
- wedding 54
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 470158 | 470158 | BARRIKA SURF CAMP | ES | stay | hostels | hostel | normal | none | S | 26 | 35 | 0 | 0 | 0 | 0 | 80 | 10 | 12.4 | BIO | 6.5 | 1.4 | 15 | Barrika | Bizkaia | 43.4052554955654 | -2.96573902296243 | ES-EUS | Albergues | S | BBI00002 | |||||||
| 470159 | 470159 | MOANA SURF HOSTEL | ES | stay | hostels | hostel | normal | none | S | 75 | 45 | 0 | 0 | 0 | 0 | 80 | 10 | 8.4 | BIO | 5.3 | 1.1 | 15 | Urduliz | Bizkaia | 43.3709388791933 | -2.94911924358427 | ES-EUS | Albergues | S | BBI00001 | |||||||
| 470160 | 470160 | GANBARA | ES | stay | hostels | hostel | normal | none | S | 62 | 45 | 0 | 0 | 0 | 0 | 80 | 0 | 4.8 | BIO | 0.6 | 0.6 | 186 | Bilbao | Bizkaia | 43.2583651967523 | -2.91871262025516 | ES-EUS | Albergues | S | BBI00004 | |||||||
| 470161 | 470161 | PIL PIL HOSTEL | ES | stay | hostels | hostel | normal | none | S | 63 | 45 | 0 | 0 | 0 | 0 | 80 | 0 | 5.2 | BIO | 1.7 | 1.7 | 191 | Bilbao | Bizkaia | 43.262776242491 | -2.94655542372641 | ES-EUS | Albergues | S | BBI00003 | |||||||
| 470162 | 470162 | BILBAO AKELARRE YOUTH HOSTEL | ES | stay | hostels | hostel | normal | none | S | 34 | 45 | 0 | 0 | 0 | 0 | 80 | 10 | 5.1 | BIO | 2.5 | 2.5 | 197 | Bilbao | Bizkaia | 43.2687045091022 | -2.95443208837744 | ES-EUS | Albergues | S | BBI00005 | |||||||
| 470163 | 470163 | URBAN HOUSE | ES | stay | hostels | hostel | normal | none | S | 30 | 45 | 0 | 0 | 0 | 0 | 80 | 0 | 16.0 | EAS | 1.2 | 1.2 | 199 | Donostia / San Sebastián | Gipuzkoa | 43.3215506963448 | -1.98276478037686 | ES-EUS | Albergues | S | BSS00004 | |||||||
| 470164 | 470164 | UBA HOSTEL | ES | stay | hostels | hostel | normal | none | S | 196 | wedding | 65 | 0 | 0 | 0 | 0 | 80 | 0 | 14.4 | EAS | 1.7 | 1.7 | 203 | Donostia / San Sebastián | Gipuzkoa | 43.3078797266407 | -1.95497944920439 | ES-EUS | Albergues | S | BSS00005 | ||||||
| 470167 | 470167 | ZARAUTZ HOSTEL | ES | stay | hostels | hostel | normal | none | S | 24 | 35 | 0 | 0 | 0 | 0 | 65 | 0 | 30.8 | EAS | 0.9 | 0.9 | 107 | Zarautz | Gipuzkoa | 43.2846143096364 | -2.15888656506313 | ES-EUS | Albergues | S | BSS00008 | |||||||
| 470169 | 470169 | MOON HOSTEL BIO | ES | stay | hostels | hostel | normal | none | S | 84 | wedding | 55 | 0 | 0 | 0 | 0 | 80 | 10 | 4.3 | BIO | 2.0 | 2.0 | 198 | Bilbao | Bizkaia | 43.2722987353625 | -2.94677847047635 | ES-EUS | Albergues | S | BBI00011 | ||||||
| 470170 | 470170 | SAN FERMIN 1 | ES | stay | hostels | hostel | normal | none | S | 44 | 45 | 0 | 0 | 0 | 0 | 80 | 0 | 16.1 | EAS | 1.4 | 1.4 | 199 | Donostia / San Sebastián | Gipuzkoa | 43.3231732667082 | -1.98482386356533 | ES-EUS | Albergues | S | BSS00006 | |||||||
| 470171 | 470171 | SAN FERMIN 2 | ES | stay | hostels | hostel | normal | none | S | 18 | 35 | 0 | 0 | 0 | 0 | 80 | 0 | 16.1 | EAS | 1.4 | 1.4 | 199 | Donostia / San Sebastián | Gipuzkoa | 43.3231732667082 | -1.98482386356533 | ES-EUS | Albergues | S | BSS00007 | |||||||
| 470184 | 470184 | BBK BILBAO GOOD HOSTEL | ES | stay | hostels | hostel | normal | none | S | 104 | wedding | 55 | 0 | 0 | 0 | 0 | 80 | 0 | 6.0 | BIO | 0.9 | 0.9 | 181 | Bilbao | Bizkaia | 43.2467781848223 | -2.90985744973047 | ES-EUS | Albergues | S | BBI00012 | ||||||
| 470191 | 470191 | GALERNA ZARAUTZ HOSTEL | ES | stay | hostels | hostel | normal | none | S | 18 | 35 | 0 | 0 | 0 | 0 | 65 | 0 | 31.4 | EAS | 0.4 | 0.4 | 112 | Zarautz | Gipuzkoa | 43.2834113941069 | -2.16507167215803 | ES-EUS | Albergues | S | BSS00002 | |||||||
| 470192 | 470192 | DOWNTOWN RIVER | ES | stay | hostels | hostel | normal | none | S | 23 | 35 | 0 | 0 | 0 | 0 | 80 | 0 | 15.8 | EAS | 0.7 | 0.7 | 202 | Donostia / San Sebastián | Gipuzkoa | 43.3185152401597 | -1.97944719791815 | ES-EUS | Albergues | S | BSS00010 | |||||||
| 470198 | 470198 | SURFING ETXEA | ES | stay | hostels | hostel | normal | none | S | 18 | 35 | 0 | 0 | 0 | 0 | 80 | 0 | 15.2 | EAS | 1.3 | 1.3 | 196 | Donostia / San Sebastián | Gipuzkoa | 43.3248119871467 | -1.9736440311791 | ES-EUS | Albergues | S | BSS00009 | |||||||
| 470201 | 470201 | BILBAO CENTRAL HOSTEL | ES | stay | hostels | hostel | normal | none | S | 54 | 45 | 0 | 0 | 0 | 0 | 80 | 0 | 5.1 | BIO | 0.9 | 0.9 | 189 | Bilbao | Bizkaia | 43.2587863680574 | -2.93460893127434 | ES-EUS | Albergues | S | BBI00008 | |||||||
| 470202 | 470202 | BILBAO ATERPETXEA HOSTEL | ES | stay | hostels | hostel | normal | none | S | 166 | wedding | 65 | 0 | 0 | 0 | 0 | 80 | 10 | 5.9 | BIO | 2.9 | 2.9 | 198 | Bilbao | Bizkaia | 43.2632149651643 | -2.96161953430324 | ES-EUS | Albergues | S | BBI00014 | ||||||
| 470206 | 470206 | LEKEITIO ATERPETXEA HOSTEL | ES | stay | hostels | hostel | normal | none | S | 22 | 35 | 0 | 0 | 0 | 0 | 55 | 10 | 33.2 | BIO | 14.9 | 0.9 | 19 | Ispaster | Bizkaia | 43.3562973520276 | -2.50680457688858 | ES-EUS | Albergues | S | BBI00009 | |||||||
| 470318 | 470318 | BIDE ONA | ES | stay | hostels | hostel | normal | none | S | 40 | 45 | 0 | 0 | 0 | 0 | 80 | 0 | 9.3 | BIO | 0.3 | 0.3 | 46 | Portugalete | Bizkaia | 43.3187833871443 | -3.02337361387363 | ES-EUS | Albergues | S | BBI00017 | |||||||
| 470321 | 470321 | LIZARRUSTI PARKETXEA | ES | stay | hostels | hostel | normal | none | S | 40 | 45 | 0 | 0 | 0 | 0 | 55 | 50 | 42.6 | PNA | 19.5 | 6.5 | 0 | Ataun | Gipuzkoa | 42.9604753638978 | -2.09942254604331 | ES-EUS | Albergues | S | BSS00015 | |||||||
| 470332 | 470332 | LA BODEGA DE SALINILLAS | ES | stay | hostels | hostel | normal | none | S | 16 | 35 | 0 | 0 | 0 | 0 | 70 | 30 | 29.1 | VIT | 11.0 | 3.6 | 3 | Labastida/Bastida | Araba/Álava | 42.6335533457627 | -2.83269851428492 | ES-EUS | Albergues | S | BVI00002 | |||||||
| 470335 | 470335 | IZARBIDE | ES | stay | hostels | hostel | normal | none | S | 30 | 45 | 0 | 0 | 0 | 0 | 55 | 0 | 42.5 | BIO | 14.0 | 1.4 | 22 | Mutriku | Gipuzkoa | 43.2941245776486 | -2.38593047746742 | ES-EUS | Albergues | S | BSS00013 | |||||||
| 470336 | 470336 | BEIZAMAKO ATERPETXEA | ES | stay | hostels | hostel | normal | none | S | 20 | 35 | 0 | 0 | 0 | 0 | 65 | 10 | 41.3 | EAS | 9.9 | 0.0 | 6 | Beizama | Gipuzkoa | 43.1340058944754 | -2.19959677289112 | ES-EUS | Albergues | S | BSS00019 | |||||||
| 470337 | 470337 | SANTA BARBARA | ES | stay | hostels | hostel | normal | none | S | 40 | 45 | 0 | 0 | 0 | 0 | 55 | 10 | 39.3 | VIT | 13.0 | 1.4 | 8 | Urretxu | Gipuzkoa | 43.0923477072016 | -2.33458788855361 | ES-EUS | Albergues | S | BSS00017 | |||||||
| 470343 | 470343 | UZTARTZA | ES | stay | hostels | hostel | normal | none | S | 47 | 45 | 0 | 0 | 0 | 0 | 80 | 10 | 27.0 | EAS | 6.3 | 0.1 | 12 | Aduna | Gipuzkoa | 43.20331981451 | -2.04958941320516 | ES-EUS | Albergues | S | BSS00012 | |||||||
| 470347 | 470347 | LASTURKO ATERPETXEA | ES | stay | hostels | hostel | normal | none | S | 60 | 45 | 0 | 0 | 0 | 0 | 55 | 10 | 45.5 | EAS | 13.4 | 4.2 | 25 | Deba | Gipuzkoa | 43.2507636491129 | -2.33338039476776 | ES-EUS | Albergues | S | BSS00011 | |||||||
| 470356 | 470356 | TRINKETE ETXEA ATERPETXEA | ES | stay | hostels | hostel | normal | none | S | 54 | 45 | 0 | 0 | 0 | 0 | 55 | 10 | 33.6 | BIO | 15.5 | 0.4 | 19 | Lekeitio | Bizkaia | 43.367557839406 | -2.50491815744327 | ES-EUS | Albergues | S | BBI00018 | |||||||
| 470357 | 470357 | HARIZTI ERDI | ES | stay | hostels | hostel | normal | none | S | 44 | 45 | 0 | 0 | 0 | 0 | 55 | 10 | 39.5 | VIT | 18.5 | 0.1 | 13 | Zerain | Gipuzkoa | 43.0130822775344 | -2.27347734990214 | ES-EUS | Albergues | S | BSS00014 | |||||||
| 470361 | 470361 | OTARDI LANDA ATERPETXEA | ES | stay | hostels | hostel | normal | none | S | 30 | 45 | 0 | 0 | 0 | 0 | 65 | 10 | 30.1 | EAS | 8.2 | 1.4 | 14 | Asteasu | Gipuzkoa | 43.206551309835 | -2.10076133138755 | ES-EUS | Albergues | S | BSS00022 | |||||||
| 470368 | 470368 | LA PARRA HOSTEL | ES | stay | hostels | hostel | normal | none | S | 22 | 35 | 0 | 0 | 0 | 0 | 80 | 10 | 16.4 | BIO | 7.1 | 0.1 | 13 | Bakio | Bizkaia | 43.4285664405041 | -2.80821823892269 | ES-EUS | Albergues | S | BBI00016 | |||||||
| 470376 | 470376 | MANDOIA | ES | stay | hostels | hostel | normal | none | S | 16 | 35 | 0 | 0 | 0 | 0 | 80 | 30 | 17.8 | BIO | 8.4 | 3.5 | 5 | Zeberio | Bizkaia | 43.1609738419719 | -2.80397460837161 | ES-EUS | Albergues | S | BBI00021 | |||||||
| 470378 | 470378 | ALL IRON HOSTEL | ES | stay | hostels | hostel | normal | none | S | 84 | wedding | 55 | 0 | 0 | 0 | 0 | 80 | 0 | 4.6 | BIO | 0.8 | 0.8 | 184 | Bilbao | Bizkaia | 43.2597147464169 | -2.91251904205588 | ES-EUS | Albergues | S | BBI00027 | ||||||
| 470382 | 470382 | QUARTIER BILBAO | ES | stay | hostels | hostel | normal | none | S | 78 | 45 | 0 | 0 | 0 | 0 | 80 | 0 | 5.1 | BIO | 0.7 | 0.7 | 186 | Bilbao | Bizkaia | 43.2561968059457 | -2.92346305053172 | ES-EUS | Albergues | S | BBI00019 | |||||||
| 470392 | 470392 | CATS HOSTELS SAN SEBASTIAN | ES | stay | hostels | hostel | normal | none | S | 134 | wedding | 55 | 0 | 0 | 0 | 0 | 80 | 10 | 17.8 | EAS | 2.1 | 2.1 | 211 | Donostia / San Sebastián | Gipuzkoa | 43.3109703887186 | -2.00105700301458 | ES-EUS | Albergues | S | BSS00024 | ||||||
| 470407 | 470407 | KOBA HOSTEL | ES | stay | hostels | hostel | normal | none | S | 68 | 45 | 0 | 0 | 0 | 0 | 80 | 0 | 15.2 | EAS | 1.1 | 1.1 | 197 | Donostia / San Sebastián | Gipuzkoa | 43.3228759556452 | -1.97295100580457 | ES-EUS | Albergues | S | BSS00027 | |||||||
| 470442 | 470442 | HOSTEL GETARIA | ES | stay | hostels | hostel | normal | none | S | 20 | 35 | 0 | 0 | 0 | 0 | 65 | 0 | 34.0 | EAS | 3.5 | 0.1 | 95 | Getaria | Gipuzkoa | 43.3028276865161 | -2.20486869135371 | ES-EUS | Albergues | S | BSS00031 | |||||||
| 470449 | 470449 | Balea hostel | ES | stay | hostels | hostel | normal | none | S | 36 | 45 | 0 | 0 | 0 | 0 | 80 | 0 | 15.2 | EAS | 0.9 | 0.9 | 212 | Donostia / San Sebastián | Gipuzkoa | 43.3070824054572 | -1.96650700210534 | ES-EUS | Albergues | S | BSS00030 | |||||||
| 470455 | 470455 | A ROOM IN THE CITY | ES | stay | hostels | hostel | normal | none | S | 214 | wedding | 65 | 0 | 0 | 0 | 0 | 80 | 0 | 16.2 | EAS | 0.8 | 0.8 | 203 | Donostia / San Sebastián | Gipuzkoa | 43.3164171628975 | -1.98367257223533 | ES-EUS | Albergues | S | BSS00023 | ||||||
| 470456 | 470456 | ARRITXULO ATERPETXEA | ES | stay | hostels | hostel | normal | none | S | 82 | wedding | 55 | 0 | 0 | 0 | 0 | 80 | 30 | 9.4 | EAS | 7.5 | 7.5 | 8 | Oiartzun | Gipuzkoa | 43.2722303576939 | -1.79580137584217 | ES-EUS | Albergues | S | BSS00020 | ||||||
| 470470 | 470470 | ERLETXE | ES | stay | hostels | hostel | normal | none | S | 10 | 35 | 0 | 0 | 0 | 0 | 80 | 10 | 6.5 | EAS | 3.8 | 3.2 | 36 | Lezo | Gipuzkoa | 43.3254008030074 | -1.85864873766588 | ES-EUS | Albergues | S | BSS00034 | |||||||
| 470473 | 470473 | Albergue Natura Sobron | ES | stay | hostels | hostel | normal | none | S | 26 | 35 | 0 | 0 | 0 | 0 | 55 | 40 | 34.1 | VIT | 16.8 | 8.0 | 4 | Lantarón | Araba/Álava | 42.773991752383 | -3.11503233895801 | ES-EUS | Albergues | S | BVI00005 | |||||||
| 470476 | 470476 | ALARPE | ES | stay | hostels | hostel | normal | none | S | 21 | 35 | 0 | 0 | 0 | 0 | 55 | 10 | 46.7 | EAS | 13.0 | 0.8 | 16 | Zaldibia | Gipuzkoa | 43.0335038624392 | -2.15851811779063 | ES-EUS | Albergues | S | BSS00035 | |||||||
| 470481 | 470481 | MOANA ECO SURF HOUSE | ES | stay | hostels | hostel | normal | none | S | 112 | wedding | 55 | 0 | 0 | 0 | 0 | 80 | 10 | 11.2 | BIO | 3.0 | 0.9 | 18 | Sopela | Bizkaia | 43.3809515688641 | -2.99438122465234 | ES-EUS | Albergues | S | BBI00052 | ||||||
| 470482 | 470482 | Laga surf camp | ES | stay | hostels | hostel | normal | none | S | 36 | 45 | 0 | 0 | 0 | 0 | 80 | 0 | 24.6 | BIO | 8.1 | 0.3 | 22 | Ibarrangelu | Bizkaia | 43.3892631437705 | -2.63129373838049 | ES-EUS | Albergues | S | BBI00057 | |||||||
| 470485 | 470485 | USANDI | ES | stay | hostels | hostel | normal | none | S | 26 | 35 | 0 | 0 | 0 | 0 | 80 | 20 | 29.8 | BIO | 8.0 | 4.4 | 11 | Ziortza-Bolibar | Bizkaia | 43.25033442 | -2.5498144 | ES-EUS | Albergues | S | BBI00051 | |||||||
| 470501 | 470501 | BLAI BLAI ATERPEA | ES | stay | hostels | hostel | normal | none | S | 24 | 35 | 0 | 0 | 0 | 0 | 65 | 0 | 31.3 | EAS | 0.4 | 0.4 | 109 | Zarautz | Gipuzkoa | 43.2859738987417 | -2.16570804213199 | ES-EUS | Albergues | S | BSS00029 | |||||||
| 470537 | 470537 | LATROUPE LA GRANJA | ES | stay | hostels | hostel | normal | none | S | 202 | wedding | 65 | 0 | 0 | 0 | 0 | 80 | 0 | 4.6 | BIO | 0.2 | 0.2 | 187 | Bilbao | Bizkaia | 43.2616264350183 | -2.92706276652397 | ES-EUS | Albergues | S | BBI00058 | ||||||
| 470542 | 470542 | HOSTEL GATZAGAK ETXEA | ES | stay | hostels | hostel | normal | none | S | 20 | 35 | 0 | 0 | 0 | 0 | 70 | 40 | 23.2 | VIT | 13.3 | 10.5 | 6 | Añana | Araba/Álava | 42.8020591839829 | -2.98657059756361 | ES-EUS | Albergues | S | BVI00006 | |||||||
| 470551 | 470551 | KORTA ATERPETXEA | ES | stay | hostels | hostel | normal | none | S | 16 | 35 | 0 | 0 | 0 | 0 | 55 | 10 | 32.9 | VIT | 23.8 | 0.8 | 6 | Asparrena | Araba/Álava | 42.8895594832495 | -2.32073707462965 | ES-EUS | Albergues | S | BVI00007 | |||||||
| 470582 | 470582 | HOSTEL A UN PASO | ES | stay | hostels | hostel | normal | none | S | 10 | 35 | 0 | 0 | 0 | 0 | 80 | 0 | 9.1 | BIO | 0.2 | 0.2 | 47 | Portugalete | Bizkaia | 43.3230313666644 | -3.01934904006412 | ES-EUS | Albergues | S | BBI00061 | |||||||
| 470600 | 470600 | POSHTEL BILBAO | ES | stay | hostels | hostel | normal | none | S | 166 | wedding | 65 | 0 | 0 | 0 | 0 | 80 | 0 | 4.2 | BIO | 0.7 | 0.7 | 190 | Bilbao | Bizkaia | 43.2669819716912 | -2.93160845257476 | ES-EUS | Albergues | S | BBI00024 | ||||||
| 470608 | 470608 | UBILLA ATERPETXEA | ES | stay | hostels | hostel | normal | none | S | 20 | 35 | 0 | 0 | 0 | 0 | 70 | 10 | 28.3 | BIO | 10.1 | 0.5 | 8 | Aulesti | Bizkaia | 43.2983152080274 | -2.5614376930622 | ES-EUS | Albergues | S | BBI00063 | |||||||
| 470610 | 470610 | ABARAXKA AZKOITIA HOSTEL | ES | stay | hostels | hostel | normal | none | S | 72 | 45 | 0 | 0 | 0 | 0 | 55 | 10 | 46.7 | EAS | 13.3 | 0.6 | 7 | Azkoitia | Gipuzkoa | 43.1722984055784 | -2.30853882553479 | ES-EUS | Albergues | S | BSS00037 | |||||||
| 470619 | 470619 | LOGUNE ROOMS | ES | stay | hostels | hostel | normal | none | S | 42 | 45 | 0 | 0 | 0 | 0 | 80 | 0 | 5.9 | VIT | 0.3 | 0.3 | 52 | Vitoria-Gasteiz | Araba/Álava | 42.8487309977915 | -2.66950763818381 | ES-EUS | Albergues | S | BVI00009 | |||||||
| 470622 | 470622 | ALBERGUE RURAL DE MANZANOS | ES | stay | hostels | hostel | normal | none | S | 6 | 35 | 0 | 0 | 0 | 0 | 80 | 30 | 20.0 | VIT | 8.4 | 2.1 | 2 | Ribera Baja/Erriberabeitia | Araba/Álava | 42.741674659954 | -2.87635421811706 | ES-EUS | Albergues | S | BVI00010 | |||||||
| 470635 | 470635 | COLO COLO | ES | stay | hostels | hostel | normal | none | S | 28 | 35 | 0 | 0 | 0 | 0 | 80 | 0 | 15.8 | EAS | 0.8 | 0.8 | 202 | Donostia / San Sebastián | Gipuzkoa | 43.318926658364 | -1.97964857710778 | ES-EUS | Albergues | S | BSS00040 | |||||||
| 470646 | 470646 | ZARAUTZ_SURFHOUSE | ES | stay | hostels | hostel | normal | none | S | 44 | 45 | 0 | 0 | 0 | 0 | 65 | 0 | 32.0 | EAS | 0.4 | 0.4 | 109 | Zarautz | Gipuzkoa | 43.2865448649755 | -2.17455692133311 | ES-EUS | Albergues | S | BSS00038 | |||||||
| 470650 | 470650 | PAORRA BASERRIA | ES | stay | hostels | hostel | normal | none | S | 40 | 45 | 0 | 0 | 0 | 0 | 80 | 10 | 27.7 | EAS | 5.5 | 2.2 | 43 | Aia | Gipuzkoa | 43.2632230625154 | -2.10823742746477 | ES-EUS | Albergues | S | BSS00042 | |||||||
| 470656 | 470656 | URBIZIXA | ES | stay | hostels | hostel | normal | none | S | 14 | 35 | 0 | 0 | 0 | 0 | 65 | 30 | 44.1 | VIT | 7.1 | 3.6 | 3 | Elgoibar | Gipuzkoa | 43.1917031134717 | -2.38432144929863 | ES-EUS | Albergues | S | BSS00041 | |||||||
| 470661 | 470661 | UNEONAK | ES | stay | hostels | hostel | normal | none | S | 15 | 35 | 0 | 0 | 0 | 0 | 80 | 10 | 17.7 | EAS | 2.4 | 2.4 | 231 | Donostia / San Sebastián | Gipuzkoa | 43.2955657200326 | -1.99228515327876 | ES-EUS | Albergues | S | BSS00043 | |||||||
| 470663 | 470663 | KEIN HOSTEL | ES | stay | hostels | hostel | normal | none | S | 20 | 35 | 0 | 0 | 0 | 0 | 65 | 0 | 31.9 | EAS | 0.3 | 0.3 | 110 | Zarautz | Gipuzkoa | 43.2866915511059 | -2.17251789267125 | ES-EUS | Albergues | S | BSS00044 | |||||||
| 470674 | 470674 | URI | ES | stay | hostels | hostel | normal | none | S | 27 | 35 | 0 | 0 | 0 | 0 | 80 | 0 | 3.8 | BIO | 0.7 | 0.7 | 191 | Bilbao | Bizkaia | 43.2679160587399 | -2.9210508213643 | ES-EUS | Albergues | S | BBI00060 | |||||||
| 470684 | 470684 | POZUETA | ES | stay | hostels | hostel | normal | none | S | 16 | 35 | 0 | 0 | 0 | 0 | 80 | 0 | 15.0 | BIO | 3.8 | 1.7 | 26 | Muxika | Bizkaia | 43.3029356827165 | -2.72570887113744 | ES-EUS | Albergues | S | BBI00034 | |||||||
| 470685 | 470685 | ERROTA ATERPETXEA | ES | stay | hostels | hostel | normal | none | S | 20 | 35 | 0 | 0 | 0 | 0 | 80 | 10 | 27.5 | BIO | 1.2 | 1.2 | 13 | Durango | Bizkaia | 43.1611423082763 | -2.63058747776359 | ES-EUS | Albergues | S | BBI00030 | |||||||
| 470686 | 470686 | OPTIMI ROOMS | ES | stay | hostels | hostel | normal | none | S | 60 | 45 | 0 | 0 | 0 | 0 | 80 | 0 | 5.5 | BIO | 1.6 | 1.6 | 186 | Bilbao | Bizkaia | 43.2582127034517 | -2.94393021212731 | ES-EUS | Albergues | S | BBI00043 | |||||||
| 470687 | 470687 | BCOOL GUITAR | ES | stay | hostels | hostel | normal | none | S | 44 | 45 | 0 | 0 | 0 | 0 | 80 | 0 | 5.1 | BIO | 0.8 | 0.8 | 189 | Bilbao | Bizkaia | 43.2584770329824 | -2.93321134923983 | ES-EUS | Albergues | S | BBI00055 | |||||||
| 470688 | 470688 | URDAIBAI BIRD CENTER | ES | stay | hostels | hostel | normal | none | S | 22 | 35 | 0 | 0 | 0 | 0 | 80 | 0 | 21.1 | BIO | 4.0 | 1.6 | 23 | Gautegiz Arteaga | Bizkaia | 43.3469270500343 | -2.6570851449223 | ES-EUS | Albergues | S | BBI00054 | |||||||
| 470689 | 470689 | ALBERGUE AMALURRA | ES | stay | hostels | hostel | normal | none | S | 38 | 45 | 0 | 0 | 0 | 0 | 70 | 20 | 26.1 | BIO | 16.4 | 4.3 | 7 | Artzentales | Bizkaia | 43.2355496406319 | -3.21946274034203 | ES-EUS | Albergues | S | BBI00056 | |||||||
| 470710 | 470710 | ALBERGUE AKARREGI | ES | stay | hostels | hostel | normal | none | S | 24 | 35 | 0 | 0 | 0 | 0 | 65 | 0 | 34.4 | EAS | 3.8 | 0.5 | 95 | Getaria | Gipuzkoa | 43.30295196 | -2.21000639 | ES-EUS | Albergues | S | BSS00045 | |||||||
| 470715 | 470715 | LARRAITZ | ES | stay | hostels | hostel | normal | none | S | 35 | 45 | 0 | 0 | 0 | 0 | 65 | 0 | 37.4 | EAS | 5.7 | 1.8 | 59 | Aizarnazabal | Gipuzkoa | 43.27165191 | -2.23830295 | ES-EUS | Albergues | S | BSS00046 | |||||||
| 470728 | 470728 | OLABE | ES | stay | hostels | hostel | normal | none | S | 30 | 45 | 0 | 0 | 0 | 0 | 70 | 10 | 28.2 | BIO | 10.9 | 0.7 | 14 | Ea | Bizkaia | 43.3767817 | -2.57754686 | ES-EUS | Albergues | S | BBI00064 | |||||||
| 470733 | 470733 | URBAN GARDEN BILBAO | ES | stay | hostels | hostel | normal | none | S | 10 | 35 | 0 | 0 | 0 | 0 | 80 | 0 | 5.4 | BIO | 0.9 | 0.9 | 185 | Bilbao | Bizkaia | 43.25502478 | -2.92957059 | ES-EUS | Albergues | S | BBI00065 | |||||||
| 470747 | 470747 | LAMIA BBK WOMEN HOSTEL | ES | stay | hostels | hostel | normal | none | S | 64 | 45 | 0 | 0 | 0 | 0 | 80 | 10 | 6.2 | BIO | 2.1 | 2.1 | 184 | Bilbao | Bizkaia | 43.2517763360229 | -2.94665727897357 | ES-EUS | Albergues | S | BBI00066 | |||||||
| 470750 | 470750 | APTC ETXEA | ES | stay | hostels | hostel | normal | none | S | 26 | 35 | 0 | 0 | 0 | 0 | 80 | 0 | 5.5 | VIT | 0.1 | 0.1 | 52 | Vitoria-Gasteiz | Araba/Álava | 42.850405 | -2.67364515 | ES-EUS | Albergues | S | BVI00011 | |||||||
| 470771 | 470771 | MONTE BASERRIA | ES | stay | hostels | hostel | normal | none | S | 22 | 35 | 0 | 0 | 0 | 0 | 65 | 20 | 30.8 | BIO | 6.9 | 4.0 | 12 | Ziortza-Bolibar | Bizkaia | 43.2434904326046 | -2.53831100180574 | ES-EUS | Albergues | S | BBI00067 | |||||||
| 470783 | 470783 | MUNITIBARREKO ALBERGEA | ES | stay | hostels | hostel | normal | none | S | 8 | 35 | 0 | 0 | 0 | 0 | 80 | 30 | 26.0 | BIO | 9.3 | 4.4 | 5 | Munitibar-Arbatzegi Gerrikaitz | Bizkaia | 43.26550666 | -2.59295169 | ES-EUS | Albergues | S | BBI00068 | |||||||
| 470795 | 470795 | SALLOBANTE ATERPETXEA | ES | stay | hostels | hostel | normal | none | S | 14 | 35 | 0 | 0 | 0 | 0 | 80 | 0 | 15.8 | BIO | 3.3 | 1.5 | 24 | Errigoiti | Bizkaia | 43.32992818 | -2.71954618 | ES-EUS | Albergues | S | BBI00069 | |||||||
| 470813 | 470813 | AREITZ SOROA ATERPE | ES | stay | hostels | hostel | normal | none | S | 10 | 35 | 0 | 0 | 0 | 0 | 70 | 10 | 18.9 | BIO | 11.4 | 1.5 | 6 | Galdames | Bizkaia | 43.25897674 | -3.13668013 | ES-EUS | Albergues | S | BBI00070 | |||||||
| 470824 | 470824 | ALBERGUE GEREKIZ | ES | stay | hostels | hostel | normal | none | S | 30 | 45 | 0 | 0 | 0 | 0 | 80 | 20 | 13.9 | BIO | 4.9 | 2.6 | 17 | Morga | Bizkaia | 43.29960307 | -2.73903828 | ES-EUS | Albergues | S | BBI00071 | |||||||
| 470827 | 470827 | SAN BARTOLOME UDAL ATERPETXEA / ALBERGUE MUNICIPAL SAN BARTOLOME | ES | stay | hostels | hostel | normal | none | S | 16 | 35 | 0 | 0 | 0 | 0 | 70 | 20 | 28.4 | RJL | 20.7 | 1.2 | 2 | Lagrán | Araba/Álava | 42.61941895 | -2.59448616 | ES-EUS | Albergues | S | BVI00012 | |||||||
| 470840 | 470840 | ARANTZAZU ATERPETXEA | ES | stay | hostels | hostel | normal | none | S | 56 | 45 | 0 | 0 | 0 | 0 | 70 | 30 | 28.4 | VIT | 11.8 | 5.9 | 6 | Oñati | Gipuzkoa | 42.9798026444567 | -2.40132125905179 | ES-EUS | Albergues | S | BSS00026 | |||||||
| 470847 | 470847 | BILBAO METROPOLITAN HOSTEL | ES | stay | hostels | hostel | normal | none | S | 92 | wedding | 55 | 0 | 0 | 0 | 0 | 80 | 0 | 5.3 | BIO | 1.0 | 1.0 | 188 | Bilbao | Bizkaia | 43.2565440039731 | -2.93409637455345 | ES-EUS | Albergues | S | BBI00041 | ||||||
| 562107 | 562107 | MONTE CARMELO | ES | stay | hostels | hostel | normal | none | 35 | 0 | 0 | 0 | 0 | 80 | 0 | 21.5 | ALC | 0.0 | 0.0 | 2077 | PINÓS, EL/PINOSO | ALICANTE/ALACANT | PD DE ENCEBRAS 2 | 38.4288 | -0.3977 | ES-GVA | Albergue | CV-ALT000001-A | |||||||||
| 562108 | 562108 | CASA REFUGIO EL BOIXAR | ES | stay | hostels | hostel | normal | none | 35 | 0 | 0 | 0 | 0 | 45 | 20 | 50.8 | CDT | 33.2 | 6.4 | 26 | POBLA DE BENIFASSÀ, LA | CASTELLÓN/CASTELLÓ | C Major-El Boixar 28 | 40.6639 | 0.1757 | ES-GVA | Albergue | CV-ALT000001-CS | |||||||||
| 562109 | 562109 | EL ALTICO | ES | stay | hostels | hostel | normal | none | 35 | 0 | 0 | 0 | 0 | 55 | 0 | 39.8 | VLC | 25.4 | 1.0 | 92 | CHULILLA | VALENCIA/VALÈNCIA | PO III-PARCELA 317 | 39.6561 | -0.892 | ES-GVA | Albergue | CV-ALT000001-V | |||||||||
| 562110 | 562110 | ALBERGUE LA SURERA | ES | stay | hostels | hostel | normal | none | 35 | 0 | 0 | 0 | 0 | 55 | 0 | 41.5 | VLC | 20.4 | 0.9 | 97 | ALMEDÍJAR | CASTELLÓN/CASTELLÓ | C CARBONERAS 4 | 39.862 | -0.4582 | ES-GVA | Albergue | CV-ALT000003-CS | |||||||||
| 562111 | 562111 | LAS VIÑUELAS | ES | stay | hostels | hostel | normal | none | 35 | 0 | 0 | 0 | 0 | 55 | 20 | 69.7 | VLC | 29.4 | 0.2 | 1 | SINARCAS | VALENCIA/VALÈNCIA | C Protectora 57 | 39.7326 | -1.2307 | ES-GVA | Albergue | CV-ALT000003-V | |||||||||
| 562112 | 562112 | MAS DE NOGUERA | ES | stay | hostels | hostel | normal | none | 35 | 0 | 0 | 0 | 0 | 55 | 0 | 51.5 | VLC | 26.2 | 0.3 | 55 | CAUDIEL | CASTELLÓN/CASTELLÓ | Mas de Noguera | 39.9477 | -0.5673 | ES-GVA | Albergue | CV-ALT000004-CS | |||||||||
| 562113 | 562113 | EMBALSE BENAGEBER | ES | stay | hostels | hostel | normal | none | 35 | 0 | 0 | 0 | 0 | 55 | 40 | 72.5 | VLC | 19.7 | 5.2 | 2 | BENAGÉBER | VALENCIA/VALÈNCIA | CM PANTANO, Plaza del Cerrillar s/n | 39.5264 | -1.325 | ES-GVA | Albergue | CV-ALT000004-V | |||||||||
| 562114 | 562114 | LES ALCUSSES | ES | stay | hostels | hostel | normal | none | 35 | 0 | 0 | 0 | 0 | 55 | 10 | 68.0 | ALC | 14.0 | 0.1 | 16 | MOIXENT/MOGENTE | VALENCIA/VALÈNCIA | CR Moixent Fontanars, Km 7 | 38.8749 | -0.7523 | ES-GVA | Albergue | CV-ALT000006-V | |||||||||
| 562115 | 562115 | LA PARRETA | ES | stay | hostels | hostel | normal | none | 35 | 0 | 0 | 0 | 0 | 45 | 0 | 36.9 | CDT | 50.3 | 0.0 | 21 | VILAFRANCA/VILLAFRANCA DEL CID | CASTELLÓN/CASTELLÓ | PD PARRETA | 40.4288 | -0.2577 | ES-GVA | Albergue | CV-ALT000007-CS | |||||||||
| 562116 | 562116 | MAS DE LA CASA BLANCA | ES | stay | hostels | hostel | normal | none | 35 | 0 | 0 | 0 | 0 | 65 | 10 | 56.5 | ALC | 9.1 | 0.0 | 16 | MURO DE ALCOY | ALICANTE/ALACANT | PD LA CABANYA S/N | 38.7812 | -0.4361 | ES-GVA | Albergue | CV-ALT000008-A | |||||||||
| 562117 | 562117 | CIRAT | ES | stay | hostels | hostel | normal | none | 35 | 0 | 0 | 0 | 0 | 55 | 0 | 48.9 | CDT | 19.9 | 1.2 | 45 | CIRAT | CASTELLÓN/CASTELLÓ | PL VIRGEN 3 | 40.0549 | -0.4628 | ES-GVA | Albergue | CV-ALT000008-CS | |||||||||
| 562118 | 562118 | LA BESANA | ES | stay | hostels | hostel | normal | none | 35 | 0 | 0 | 0 | 0 | 55 | 10 | 74.1 | ABC | 21.4 | 0.0 | 17 | VENTA DEL MORO | VALENCIA/VALÈNCIA | C SAN JUAN 9 | 39.4833 | -1.35 | ES-GVA | Albergue | CV-ALT000009-V | |||||||||
| 562119 | 562119 | RIERA D'AGRES | ES | stay | hostels | hostel | normal | none | 35 | 0 | 0 | 0 | 0 | 65 | 10 | 55.5 | ALC | 9.1 | 0.4 | 17 | AGRES | ALICANTE/ALACANT | PD LA FITA, DISEMINADOS 10 | 38.7801 | -0.516 | ES-GVA | Albergue | CV-ALT000010-A | |||||||||
| 562120 | 562120 | ALBERGUE EL DHARMA | ES | stay | hostels | hostel | normal | none | 35 | 0 | 0 | 0 | 0 | 55 | 0 | 51.4 | CDT | 23.3 | 1.4 | 40 | MONTANEJOS | CASTELLÓN/CASTELLÓ | AV Avda. Fuente de Baños 39 | 40.0667 | -0.5 | ES-GVA | Albergue | CV-ALT000010-CS | |||||||||
| 562121 | 562121 | RABOSA | ES | stay | hostels | hostel | normal | none | 35 | 0 | 0 | 0 | 0 | 55 | 10 | 67.6 | ALC | 16.0 | 2.4 | 180 | VALL DE LAGUAR, LA | ALICANTE/ALACANT | C Colón, 7 - Benimaurell | 38.7766 | -0.1066 | ES-GVA | Albergue | CV-ALT000011-A | |||||||||
| 562122 | 562122 | LOS CENTENARES | ES | stay | hostels | hostel | normal | none | 35 | 0 | 0 | 0 | 0 | 70 | 20 | 29.8 | TEV | 27.3 | 2.2 | 9 | CASTIELFABIB | VALENCIA/VALÈNCIA | Los Centenares S7N | 40.15 | -1.3 | ES-GVA | Albergue | CV-ALT000011-V | |||||||||
| 562123 | 562123 | ALBERGUE DEL SERPIS | ES | stay | hostels | hostel | normal | none | 35 | 0 | 0 | 0 | 0 | 55 | 40 | 67.0 | ALC | 16.4 | 5.2 | 4 | ORXA, L'/LORCHA | ALICANTE/ALACANT | PD FONTETES S/N | 38.85 | -0.3 | ES-GVA | Albergue | CV-ALT000012-A | |||||||||
| 562124 | 562124 | LA FONT LLUNY | ES | stay | hostels | hostel | normal | none | 35 | 0 | 0 | 0 | 0 | 45 | 20 | 50.8 | CDT | 33.2 | 6.4 | 26 | POBLA DE BENIFASSÀ, LA | CASTELLÓN/CASTELLÓ | CM LA FONT LLUNY S/N | 40.6639 | 0.1757 | ES-GVA | Albergue | CV-ALT000012-CS |
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");