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

24 rows where country = "ES", family = "rural" and rating_value = 5

This data as json, CSV (advanced)

Suggested facets: rating_label, capacity_persons, rooms, fit_wedding, reachability_score, isolation_score, city_km, town_km, venues_5km, city, municipality, source, source_type, source_category

rating_value 1

group 1

family 1

  • rural · 24 ✖

country 1

best_for 1

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
560852 560852 CASA PIPA ES stay rural rural_agritourism normal 5 star CINCO ESTRELLAS 8   wedding 55 0 0 0 0   55 10 42.7 VLC 14.2 0.5 10 ALFONDEGUILLA CASTELLÓN/CASTELLÓ C CASTILLO 21 39.8373 -0.2694     ES-GVA Casa rural CINCO ESTRELLAS CV-ARU000831-CS
560853 560853 CA PERFECTO ES stay rural rural_agritourism normal 5 star CINCO ESTRELLAS 9   wedding 55 0 0 0 0   70 10 11.4 CDT 28.5 0.0 13 COVES DE VINROMÀ, LES CASTELLÓN/CASTELLÓ CALLE LA SALZADELLA, Nº 2 40.3098 0.1208     ES-GVA Casa rural CINCO ESTRELLAS CV-ARU000892-CS
560854 560854 VALLIVANA SUITES & SPA ES stay rural rural_agritourism normal 5 star CINCO ESTRELLAS 8   wedding 55 0 0 0 0   45 0 47.4 CDT 48.0 0.1 80 MORELLA CASTELLÓN/CASTELLÓ C Virgen de Vallivana 21 40.6189 -0.1     ES-GVA Casa rural CINCO ESTRELLAS CV-ARU000794-CS
560855 560855 MAS LA PAU ES stay rural rural_agritourism normal 5 star CINCO ESTRELLAS 16   wedding 55 0 0 0 0   65 0 72.0 ALC 9.3 0.0 1358 LLÍBER ALICANTE/ALACANT CM FALCONETS 4 38.7283 0.0415     ES-GVA Casa rural CINCO ESTRELLAS CV-ARU000447-A
560856 560856 CASA THIAR JULIA ES stay rural rural_agritourism normal 5 star CINCO ESTRELLAS 12   wedding 55 0 0 0 0   55 0 39.1 CDT 16.7 0.1 271 TRAIGUERA CASTELLÓN/CASTELLÓ C LA FONT 6,7 y 9 40.5245 0.2898     ES-GVA Casa rural CINCO ESTRELLAS CV-ARU000484-CS
560857 560857 OSTALEA Casa Rural ES stay rural rural_agritourism normal 5 star CINCO ESTRELLAS 8   wedding 55 0 0 0 0   70 10 2.0 CDT 20.2 4.6 645 VILANOVA D'ALCOLEA CASTELLÓN/CASTELLÓ CALLE CALVARI, 13 40.2318 0.0741     ES-GVA Casa rural CINCO ESTRELLAS CV-ARU000901-CS
560858 560858 CASA RURAL MENSIN ES stay rural rural_agritourism normal 5 star CINCO ESTRELLAS 4   wedding 55 0 0 0 0   60 30 19.9 CDT 36.1 6.6 8 VILAR DE CANES CASTELLÓN/CASTELLÓ C SAGRISTIA 2 40.3582 -0.0655     ES-GVA Casa rural CINCO ESTRELLAS CV-ARU000841-CS
560859 560859 Villa Paula ES stay rural rural_agritourism normal 5 star CINCO ESTRELLAS 15   wedding 55 0 0 0 0   80 10 1.8 VLC 2.7 2.7 88 MANISES VALENCIA/VALÈNCIA Poligono 6 Nr 7, El Racó 39.504 -0.4901     ES-GVA Casa rural CINCO ESTRELLAS CV-ARU000608-V
560860 560860 LA CAMBRA ES stay rural rural_agritourism normal 5 star CINCO ESTRELLAS 2   wedding 55 0 0 0 0   65 0 68.4 VLC 5.8 0.2 75 POTRIES VALENCIA/VALÈNCIA C JAUME I 46 38.9151 -0.1946     ES-GVA Casa rural CINCO ESTRELLAS CV-ARU000553-V
560861 560861 CASA RABAT ES stay rural rural_agritourism normal 5 star CINCO ESTRELLAS 13   wedding 55 0 0 0 0   65 0 67.6 VLC 4.1 0.0 5532 RAFELCOFER VALENCIA/VALÈNCIA C Cervantes 25 38.9322 -0.1677     ES-GVA Casa rural CINCO ESTRELLAS CV-ARU000464-V
562268 562268 CAN BENEÏT ES stay rural rural_agritourism normal 5 star 5 estrelles 20 10 wedding 55 0 0 0 0   80 10 28.3 PMI 5.7 2.0 16 Caimari SELVA Polígon 13 PARCEL·LA 70. 07313 Caimari, SELVA, Mallorca 39.77242822832715 2.9045628867340993     ES-BAL Agroturisme 5 estrelles AG/125
562321 562321 FINCA SERENA MALLORCA ES stay rural rural_agritourism normal 5 star 5 estrelles 50 25 wedding 65 0 0 0 0   70 20 18.3 PMI 11.9 3.9 8 Montuïri MONTUÏRI Polígon 8, PARCELA 1. CTRA PINA-MONTUIRI, KM 3. 07230 MONTUÏRI, Mallorca 39.58908183816069 2.9462882812344273     ES-BAL Agroturisme 5 estrelles AG/185
562446 562446 PLETA DE MAR ES stay rural rural_agritourism normal 5 star 5 estrelles Gran Luxe 60 30 wedding 65 0 0 0 0                 Capdepera CAPDEPERA DE LES CALES, S/N. -, -         ES-BAL Agroturisme 5 estrelles Gran Luxe AG/337
562469 562469 ES RACÓ D´ARTÀ ES stay rural rural_agritourism normal 5 star 5 estrelles Gran Luxe 68 31 wedding 65 0 0 0 0                 Artà ARTÀ Carretera Cala Torta - Artà, km., 1,6. 07570 ARTÀ, Mallorca         ES-BAL Agroturisme 5 estrelles Gran Luxe AG/362
562476 562476 THE LODGE ES stay rural rural_agritourism normal 5 star 5 estrelles 48 24 wedding 65 0 0 0 0                 Pobla (La) SA POBLA Polígon 2 Parcel·la 91. 07420 Pobla (La), SA POBLA, Mallorca         ES-BAL Agroturisme 5 estrelles AG/369
562478 562478 TREURER ES stay rural rural_agritourism normal 5 star 5 estrelles 16 8 wedding 55 0 0 0 0                 Algaida ALGAIDA Carretera Llucmajor-Algaida, km, 5,7. 07210 ALGAIDA, Mallorca         ES-BAL Agroturisme 5 estrelles AG/370
563051 563051 SON NET ES stay rural rural_agritourism normal 5 star 5 estrelles Gran Luxe 62 31 wedding 65 0 0 0 0   80 10 20.1 PMI 6.7 0.3 11 Puigpunyent PUIGPUNYENT Polígon 2 PARCELA 792, CALLE CASTILLO DE SON NET S/N. 07194 PUIGPUNYENT, Mallorca 39.623923801661896 2.5241170529835113     ES-BAL Hotel rural 5 estrelles Gran Luxe HR/11
563055 563055 S´OLIVARET ES stay rural rural_agritourism normal 5 star 5 estrelles 50 27 wedding 65 0 0 0 0   80 20 21.1 PMI 9.3 3.5 14 Alaró ALARÓ Carretera ALARO-ORIENT, KM 2, S/N. 07340 ALARÓ, Mallorca 39.73490476939221 2.80340697822176     ES-BAL Hotel rural 5 estrelles HR/15
563057 563057 CARROSSA HOTEL - SPA - VILLAS ES stay rural rural_agritourism normal 5 star 5 estrelles 154 76 wedding 85 0 0 0 0   55 30 49.7 PMI 14.5 4.9 3 Artà ARTÀ Polígon 8, PARC 1. 07570 ARTÀ, Mallorca 39.683044984139165 3.2939309973380744     ES-BAL Hotel rural 5 estrelles HR/17
563066 563066 CAN SIMONETA ES stay rural rural_agritourism normal 5 star 5 estrelles 36 18 wedding 65 0 0 0 0   55 30 60.4 PMI 20.9 5.9 14 Canyamel CAPDEPERA Carretera ARTÀ-CANYAMEL KM 8, S/N. 07589 Canyamel, CAPDEPERA, Mallorca 39.64405151496057 3.4332927458955615     ES-BAL Hotel rural 5 estrelles HR/27
563072 563072 CAP ROCAT ES stay rural rural_agritourism normal 5 star 5 estrelles Gran Luxe 62 31 wedding 65 0 0 0 0   70 10 7.9 PMI 12.5 2.3 117 Llucmajor LLUCMAJOR BATERIAS 8 I 9. CAP ENDERROCAT, S/N. 07620 LLUCMAJOR, Mallorca 39.48055509401429 2.7394095537138856     ES-BAL Hotel rural 5 estrelles Gran Luxe HR/34
563079 563079 CASTELL SON CLARET ES stay rural rural_agritourism normal 5 star 5 estrelles Gran Luxe 82 43 wedding 75 0 0 0 0                 Capdellà (El) CALVIÀ Carretera ES CAPDELLÀ-GALILEA, KM. 1,5. 07196 Capdellà (El), CALVIÀ, Mallorca         ES-BAL Hotel rural 5 estrelles Gran Luxe HR/40
563998 563998 PALACIO CAN MARQUES ES stay rural rural_agritourism normal 5 star 5 estrelles 32 13 wedding 65 0 0 0 0                 Palma PALMA Carrer APUNTADORS, 15. 07012 PALMA, Mallorca         ES-BAL Turisme d´interior 5 estrelles TI/201
564026 564026 PORTELLA PALMA ES stay rural rural_agritourism normal 5 star 5 estrelles 30 14 wedding 65 0 0 0 0   80 0 7.7 PMI 0.3 0.3 93 Palma PALMA Carrer PORTELLA, 9. 07001 PALMA, Mallorca 39.56663599804901 2.6505427350397537     ES-BAL Turisme d´interior 5 estrelles TI/229

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE venues ("name" TEXT, "country" TEXT, "group" TEXT, "family" TEXT, "venue_type" TEXT, "type_granularity" TEXT, "rating_value" INTEGER, "rating_scheme" TEXT, "rating_label" TEXT, "capacity_persons" INTEGER, "rooms" INTEGER, "best_for" TEXT, "fit_wedding" INTEGER, "fit_conference" INTEGER, "fit_banquet" INTEGER, "fit_spa" INTEGER, "fit_party" INTEGER, "common_areas" TEXT, "reachability_score" INTEGER, "isolation_score" INTEGER, "airport_km" REAL, "nearest_airport" TEXT, "city_km" REAL, "town_km" REAL, "venues_5km" INTEGER, "city" TEXT, "municipality" TEXT, "address" TEXT, "lat" REAL, "lng" REAL, "valid_until" TEXT, "stop_date" TEXT, "source" TEXT, "source_type" TEXT, "source_category" TEXT, "cert_number" TEXT);
CREATE INDEX idx_country ON venues("country");
CREATE INDEX idx_group ON venues("group");
CREATE INDEX idx_family ON venues("family");
CREATE INDEX idx_venue_type ON venues("venue_type");
CREATE INDEX idx_rating_value ON venues("rating_value");
CREATE INDEX idx_rating_scheme ON venues("rating_scheme");
CREATE INDEX idx_city ON venues("city");
CREATE INDEX idx_best_for ON venues("best_for");
CREATE INDEX idx_common_areas ON venues("common_areas");