venues

Data license: Compiled from official public government tourism registers · Data source: National tourism registers (BG · RO · GB · ES · FR · IE · HR · PT)

group
Top group: Stay / Eat & Drink / Other
family
Simplified family (Hotels, Guesthouses, Restaurants, Bars & Pubs…)
venue_type
Detailed canonical type (see the venue_types table)
type_granularity
'coarse' when the source lumps several real types (e.g. UK FSA)
rating_value
Normalized 1–5 grade, or blank if unrated
rating_scheme
star / key / flower / approved / none (see rating_schemes)
rating_label
Original rating string from the source (provenance)
source_type
Original type string from the national register (provenance)
source_category
Original category/rating field from the register
capacity_persons
Comparable headline capacity — beds/guests (stay) or seats (food)
rooms
Number of rooms / units (accommodation)
cert_number
Certificate / registration number in the national register
source
Source register the row came from

25 rows where country = "ES", family = "rural" and rating_value = 4

This data as json, CSV (advanced)

Suggested facets: capacity_persons, city, municipality, address

venue_type 1

rating_value 1

group 1

family 1

  • rural · 25 ✖

country 1

Link rowid ▼ name country group family venue_type type_granularity rating_value rating_scheme rating_label capacity_persons rooms city municipality address lat lng valid_until stop_date source source_type source_category cert_number
212963 212963 BOLET CASA MODERNISTA ES stay rural rural_agritourism normal 4 flower 4 Espigues 10   Castellví de la Marca Alt Penedès Carretera Sant Marçal km 15 Finca Mas LLuet s/n         ES-CAT Turisme rural 4 Espigues PB-001213
213068 213068 CAL ROS ES stay rural rural_agritourism normal 4 flower 4 Espigues 15   Calonge de Segarra Anoia Disseminat Masia Cal Ros s/n         ES-CAT Turisme rural 4 Espigues PCC-000162
213142 213142 Les Planes ES stay rural rural_agritourism normal 4 flower 4 Espigues 12   Odèn Solsonès Carrer Les Planes s/n         ES-CAT Turisme rural 4 Espigues PCC-000286
213150 213150 Casanova de la Salada ES stay rural rural_agritourism normal 4 flower 4 Espigues 9   Lladurs Solsonès Carretera Sant Llorenç KM 12,6         ES-CAT Turisme rural 4 Espigues PCC-000301
213272 213272 Can Xisquet ES stay rural rural_agritourism normal 4 flower 4 Espigues 10   Viladrau Osona Carretera GI-520 KM 3,100         ES-CAT Turisme rural 4 Espigues PCC-000515
213276 213276 La Salada ES stay rural rural_agritourism normal 4 flower 4 Espigues 8   Lladurs Solsonès Carretera Sant Llorenç KM 12,6         ES-CAT Turisme rural 4 Espigues PCC-000523
213291 213291 Cal Grau de La Llavinera ES stay rural rural_agritourism normal 4 flower 4 Espigues 11   Sant Pere Sallavinera Anoia Carrer Cal Grau s/n         ES-CAT Turisme rural 4 Espigues PCC-000551
213293 213293 El Racó de la Guita ES stay rural rural_agritourism normal 4 flower 4 Espigues 7   Odèn Solsonès Carrer Casa Call s/n         ES-CAT Turisme rural 4 Espigues PCC-000553
213339 213339 LA CASA GRAN ES stay rural rural_agritourism normal 4 flower 4 Espigues 14   Olost Lluçanès Camí vell s/n         ES-CAT Turisme rural 4 Espigues PCC-000724
213340 213340 Rústic Vilella ES stay rural rural_agritourism normal 4 flower 4 Espigues 15   Gisclareny Berguedà Camí Turbians-Cal Pere Vilella s/n         ES-CAT Turisme rural 4 Espigues PCC-000725
213574 213574 Casa La Parera ES stay rural rural_agritourism normal 4 flower 4 Espigues 15   Avià Berguedà Disseminat La Parera s/n         ES-CAT Turisme rural 4 Espigues PCC-001211
213619 213619 CASTELL DE L'AGUDA ES stay rural rural_agritourism normal 4 flower 4 Espigues 10   Torà Solsonès Camí CAL COBERÓ S/N         ES-CAT Turisme rural 4 Espigues PCC-001519
213687 213687 Can Masó ES stay rural rural_agritourism normal 4 flower 4 Espigues 12   Fontcoberta Pla de l'Estany Disseminat Masó s/n         ES-CAT Turisme rural 4 Espigues PG-000053
213718 213718 Sense especificar ES stay rural rural_agritourism normal 4 flower 4 Espigues 15   Sant Julià del Llor i Bonmatí Selva Camí CAN VILA - TURISME RURAL s/n         ES-CAT Turisme rural 4 Espigues PG-000101
213793 213793 Can Xargay ES stay rural rural_agritourism normal 4 flower 4 Espigues 15   Porqueres Pla de l'Estany Carrer Pau Casals 35         ES-CAT Turisme rural 4 Espigues PG-000205
214238 214238 La Escapada Ventalló ES stay rural rural_agritourism normal 4 flower 4 Espigues 10   Ventalló Alt Empordà Carrer Oliveres s/n         ES-CAT Turisme rural 4 Espigues PG-000811
214665 214665 Casa Parramon ES stay rural rural_agritourism normal 4 flower 4 Espigues 14   Baix Pallars Pallars Sobirà Carrer Major 2         ES-CAT Turisme rural 4 Espigues PL-000206
214670 214670 Cal Rei ES stay rural rural_agritourism normal 4 flower 4 Espigues 15   Lles de Cerdanya Cerdanya Carrer Travessera 16         ES-CAT Turisme rural 4 Espigues PL-000213
214729 214729 Casa Leonardo ES stay rural rural_agritourism normal 4 flower 4 Espigues 15   Senterada Pallars Jussà Avinguda La Bedoga 2         ES-CAT Turisme rural 4 Espigues PL-000321
215245 215245 Masia Puig-Adoll ES stay rural rural_agritourism normal 4 flower 4 Espigues 9   Montmell, el Baix Penedès Carretera TV-2443 KM 9         ES-CAT Turisme rural 4 Espigues PT-000285
215254 215254 Mas Llagostera ES stay rural rural_agritourism normal 4 flower 4 Espigues 13   Bisbal del Penedès, la Baix Penedès Carretera T-240 KM 0,5         ES-CAT Turisme rural 4 Espigues PT-000298
215324 215324 CA L'ARCADI ES stay rural rural_agritourism normal 4 flower 4 Espigues 14   Alforja Baix Camp Carrer del Bolcador 22         ES-CAT Turisme rural 4 Espigues PT-001174
215351 215351 MASIA TORRES DE SELMA ES stay rural rural_agritourism normal 4 flower 4 Espigues 20   Aiguamúrcia Alt Camp Polígon 21 PARCEL LA 9- PLA DE MANLLEU 21         ES-CAT Turisme rural 4 Espigues PT-001438
215359 215359 Cal Joan de l'Hort ES stay rural rural_agritourism normal 4 flower 4 Espigues 20   Nulles Alt Camp Carrer DE SANT JOAN 4         ES-CAT Turisme rural 4 Espigues PT-001534
215518 215518 LO INDIANO ES stay rural rural_agritourism normal 4 flower 4 Espigues 20   Prat de Comte Terra Alta Carrer FAIXA 3         ES-CAT Turisme rural 4 Espigues PTE-001343

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, "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");