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

2,758 rows where country = "ES", group = "stay" and rating_value = 4

This data as json, CSV (advanced)

Suggested facets: venue_type, rating_scheme, rating_label, fit_wedding, fit_conference, fit_banquet, fit_spa, reachability_score, isolation_score, source, source_type, source_category

family 4

rating_value 1

  • 4 · 2,758 ✖

group 1

  • stay · 2,758 ✖

country 1

  • ES · 2,758 ✖

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
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
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
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
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
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
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
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
348545 348545 Playafels ES stay hotels hotel normal 4 star 4 estrelles 70   wedding 80 70 50 50 0   80 10 12.3 BCN 3.1 3.1 3979 Castelldefels Baix Llobregat Lloc Ribera de Sant Pere 1-9 41.264 1.938     ES-CAT Hotels 4 estrelles HB-000144
348546 348546 Gran Hotel Rey Don Jaime ES stay hotels hotel normal 4 star 4 estrelles 410   wedding 100 90 70 50 0   80 10 12.3 BCN 3.1 3.1 3979 Castelldefels Baix Llobregat Avinguda Hotel 22 41.264 1.938     ES-CAT Hotels 4 estrelles HB-000146
348551 348551 Gran Hotel Balneari Blancafort ES stay hotels hotel normal 4 star 4 estrelles 274   wedding 100 90 70 50 0   65 0 30.1 Folgueroles Airfield 7.4 0.2 63 Garriga, la Vallès Oriental Carrer Mina 7 41.6829 2.2861     ES-CAT Hotels 4 estrelles HB-000169
348567 348567 Tròpic Park ES stay hotels hotel normal 4 star 4 estrelles 391   wedding 100 90 70 50 0   80 0 28.7 GRO 0.0 0.0 1841 Malgrat de Mar Maresme Passeig Marítim 68 41.6466 2.7413     ES-CAT Hotels 4 estrelles HB-000276
348568 348568 Bel-Air ES stay hotels hotel normal 4 star 4 estrelles 86   wedding 90 80 60 50 0   80 10 12.3 BCN 3.1 3.1 3979 Castelldefels Baix Llobregat Passeig Marítim 169 41.264 1.938     ES-CAT Hotels 4 estrelles HB-000279
348572 348572 HOTEL MARITIM ES stay hotels hotel normal 4 star 4 estrelles 311   wedding 100 90 70 50 0   65 0 32.9 GRO 1.3 1.3 2233 Calella Maresme Passeig LES ROQUES s/n 41.6168 2.6691     ES-CAT Hotels 4 estrelles HB-000296
348581 348581 H Top Pineda Palace ES stay hotels hotel normal 4 star 4 estrelles superior 388   wedding 100 90 70 50 0   65 0 31.4 GRO 0.0 0.0 2352 Pineda de Mar Maresme Passeig Marítim 9 41.6276 2.6889     ES-CAT Hotels 4 estrelles superior HB-000336
348583 348583 FERGUS Club Pineda Splash ES stay hotels hotel normal 4 star 4 estrelles 498   wedding 100 90 70 50 0   65 0 31.4 GRO 0.0 0.0 2352 Pineda de Mar Maresme Carrer de les puntaires 20 41.6276 2.6889     ES-CAT Hotels 4 estrelles HB-000339
348591 348591 Eurostars Cristal Palace ES stay hotels hotel normal 4 star 4 estrelles 250   wedding 100 90 70 50 0   80 0 12.6 BCN 0.2 0.2 11156 Barcelona Barcelonès Carrer Diputació 257 41.3898 2.1643     ES-CAT Hotels 4 estrelles HB-000372
348593 348593 Zènit Barcelona ES stay hotels hotel normal 4 star 4 estrelles 118   wedding 90 80 60 50 0   80 0 12.3 BCN 0.1 0.1 11156 Barcelona Barcelonès Carrer Santaló 8 41.397 2.1423     ES-CAT Hotels 4 estrelles HB-000386
348595 348595 HOTEL SORRABONA ES stay hotels hotel normal 4 star 4 estrelles 150   wedding 100 80 70 50 0   65 0 31.4 GRO 0.0 0.0 2352 Pineda de Mar Maresme Passeig Marítim 10 41.6276 2.6889     ES-CAT Hotels 4 estrelles HB-000388
348632 348632 HOTEL SORRA DAURADA SPLASH ES stay hotels hotel normal 4 star 4 estrelles 500   wedding 100 90 70 50 0   80 0 28.7 GRO 0.0 0.0 1841 Malgrat de Mar Maresme Passeig Maritim 6 41.6466 2.7413     ES-CAT Hotels 4 estrelles HB-000709
348642 348642 Monteplaya ES stay hotels hotel normal 4 star 4 estrelles superior 296   wedding 100 90 70 50 0   80 0 28.7 GRO 0.0 0.0 1841 Malgrat de Mar Maresme Passeig Marítim 50-52 41.6466 2.7413     ES-CAT Hotels 4 estrelles superior HB-000764
348646 348646 Alegria Maripins ES stay hotels hotel normal 4 star 4 estrelles 360   wedding 100 90 70 50 0   80 0 28.7 GRO 0.0 0.0 1841 Malgrat de Mar Maresme Passeig Marítim 20 41.6466 2.7413     ES-CAT Hotels 4 estrelles HB-000791
348661 348661 Sumus Hotel Stella & Spa 4*S ES stay hotels hotel normal 4 star 4 estrelles superior 367   wedding 100 90 70 50 0   65 0 31.4 GRO 0.0 0.0 2352 Pineda de Mar Maresme Carrer de les Puntaires 1 41.6276 2.6889     ES-CAT Hotels 4 estrelles superior HB-000948
348677 348677 Gótico ES stay hotels hotel normal 4 star 4 estrelles 149   wedding 90 80 60 50 0   80 0 12.5 BCN 0.2 0.2 11022 Barcelona Barcelonès Carrer Jaume I 14 41.3823 2.176     ES-CAT Hotels 4 estrelles HB-001219
348678 348678 Golf Can Rafel ES stay hotels hotel normal 4 star 4 estrelles 50   wedding 80 70 50 50 0   80 0 14.8 BCN 4.0 0.0 103 Cervelló Baix Llobregat Carretera de Can Rafael s/n 41.3959 1.9592     ES-CAT Hotels 4 estrelles HB-001239
348690 348690 HOTEL SANTA MONICA ES stay hotels hotel normal 4 star 4 estrelles 392   wedding 100 90 70 50 0   65 0 32.9 GRO 1.3 1.3 2233 Calella Maresme Avinguda DEL TURISME 72-78 41.6168 2.6691     ES-CAT Hotels 4 estrelles HB-001703
348693 348693 Best Western Hotel Mediterráneo ES stay hotels hotel normal 4 star 4 estrelles 89   wedding 90 80 60 50 0   80 10 12.3 BCN 3.1 3.1 3979 Castelldefels Baix Llobregat Passeig Marítim 294 41.264 1.938     ES-CAT Hotels 4 estrelles HB-001723
348698 348698 Calípolis ES stay hotels hotel normal 4 star 4 estrelles 335   wedding 100 90 70 50 0   80 0 24.3 BCN 1.7 1.7 2936 Sitges Garraf Avinguda Sofia 2 41.2446 1.7962     ES-CAT Hotels 4 estrelles HB-001798
348700 348700 Golden Taurus Park Resort ES stay hotels hotel normal 4 star 4 estrelles 929   wedding 100 90 70 50 0   65 0 31.4 GRO 0.0 0.0 2352 Pineda de Mar Maresme Passeig Marítim 33 41.6276 2.6889     ES-CAT Hotels 4 estrelles HB-001832
348708 348708 Hesperia Presidente ES stay hotels hotel normal 4 star 4 estrelles 301   wedding 100 90 70 50 0   80 0 12.3 BCN 0.1 0.1 11156 Barcelona Barcelonès Avinguda Diagonal 570 41.397 2.1423     ES-CAT Hotels 4 estrelles HB-001911
348711 348711 Royal ES stay hotels hotel normal 4 star 4 estrelles 226   wedding 100 90 70 50 0   80 0 12.5 BCN 0.2 0.2 11022 Barcelona Barcelonès Carrer Rambla 117 41.3823 2.176     ES-CAT Hotels 4 estrelles HB-001934
348715 348715 NH Barcelona Stadium ES stay hotels hotel normal 4 star 4 estrelles 185   wedding 100 80 70 50 0   80 0 9.9 BCN 0.4 0.4 10064 Barcelona Barcelonès Travessera Corts 150 41.378 2.1278     ES-CAT Hotels 4 estrelles HB-001969
348720 348720 Best Western Premier Hotel Dante ES stay hotels hotel normal 4 star 4 estrelles 144   wedding 90 80 60 50 0   80 0 12.1 BCN 0.3 0.3 11156 Barcelona Barcelonès Carrer Mallorca 181 41.3906 2.1521     ES-CAT Hotels 4 estrelles HB-002007
348726 348726 HCC Hotel Regente ES stay hotels hotel normal 4 star 4 estrelles 143   wedding 90 80 60 50 0   80 0 12.6 BCN 0.2 0.2 11156 Barcelona Barcelonès Rambla Catalunya 76 41.3898 2.1643     ES-CAT Hotels 4 estrelles HB-002057
348761 348761 Wilson Boutique ES stay hotels hotel normal 4 star 4 estrelles 95   wedding 90 80 60 50 0   80 0 12.3 BCN 0.1 0.1 11156 Barcelona Barcelonès Avinguda Diagonal 568 41.397 2.1423     ES-CAT Hotels 4 estrelles HB-002460
348763 348763 Subur Maritim ES stay hotels hotel normal 4 star 4 estrelles 90   wedding 90 80 60 50 0   80 0 24.3 BCN 1.7 1.7 2936 Sitges Garraf Passeig Marítim s/n 41.2446 1.7962     ES-CAT Hotels 4 estrelles HB-002490
348774 348774 Balmoral ES stay hotels hotel normal 4 star 4 estrelles 196   wedding 100 80 70 50 0   80 0 12.9 BCN 0.6 0.6 11887 Barcelona Barcelonès Via Augusta 5 41.4008 2.1481     ES-CAT Hotels 4 estrelles HB-002606
348787 348787 U232 ES stay hotels hotel normal 4 star 4 estrelles 186   wedding 100 80 70 50 0   80 0 12.1 BCN 0.3 0.3 11156 Barcelona Barcelonès Carrer Comte Urgell 232 41.3906 2.1521     ES-CAT Hotels 4 estrelles HB-002733
348791 348791 H Top Amaika ES stay hotels hotel normal 4 star 4 estrelles superior 448   wedding 100 90 70 50 0   65 0 32.9 GRO 1.3 1.3 2233 Calella Maresme Carrer Diputació 2 41.6168 2.6691     ES-CAT Hotels 4 estrelles superior HB-002757
348793 348793 Derby ES stay hotels hotel normal 4 star 4 estrelles 212   wedding 100 90 70 50 0   80 0 11.3 BCN 0.6 0.6 10505 Barcelona Barcelonès Carrer Loreto 21 41.3868 2.1424     ES-CAT Hotels 4 estrelles HB-002794
348809 348809 Summer Hotel ES stay hotels hotel normal 4 star 4 estrelles 143   wedding 90 80 60 50 0   65 0 32.9 GRO 1.3 1.3 2233 Calella Maresme Carrer Montnegre 15 41.6168 2.6691     ES-CAT Hotels 4 estrelles HB-002941
348815 348815 Hotel Alhambra ES stay hotels hotel normal 4 star 4 estrelles 379   wedding 100 90 70 50 0   80 0 29.6 GRO 2.4 1.0 2439 Santa Susanna Maresme Avinguda del Mar 19 41.6411 2.7111     ES-CAT Hotels 4 estrelles HB-002976
348828 348828 HOTEL IBERSOL ANTEMARE ES stay hotels hotel normal 4 star 4 estrelles 223   wedding 100 90 70 50 0   80 0 24.3 BCN 1.7 1.7 2936 Sitges Garraf Carrer d' Enric Morera 16 41.2446 1.7962     ES-CAT Hotels 4 estrelles HB-003092
348833 348833 HOTEL RIVIERA ES stay hotels hotel normal 4 star 4 estrelles 483   wedding 100 90 70 50 0   80 0 29.6 GRO 2.4 1.0 2439 Santa Susanna Maresme Avinguda Mar 21 41.6411 2.7111     ES-CAT Hotels 4 estrelles HB-003125
348849 348849 ARENAS ATIRAM HOTEL ES stay hotels hotel normal 4 star 4 estrelles 110   wedding 90 80 60 50 0   80 0 10.1 BCN 1.0 0.6 6071 Barcelona Barcelonès Carrer del Capità Arenas 20 41.3859 2.1066     ES-CAT Hotels 4 estrelles HB-003272
348850 348850 Volga ES stay hotels hotel normal 4 star 4 estrelles 305   wedding 100 90 70 50 0   65 0 32.9 GRO 1.3 1.3 2233 Calella Maresme Carrer Jovara 350 41.6168 2.6691     ES-CAT Hotels 4 estrelles HB-003276
348854 348854 H TOP CALELLA PALACE ES stay hotels hotel normal 4 star 4 estrelles superior 671   wedding 100 90 70 50 0   65 0 32.9 GRO 1.3 1.3 2233 Calella Maresme Carrer de Maria Cardona 10-40 41.6168 2.6691     ES-CAT Hotels 4 estrelles superior HB-003303
348862 348862 Mercure Barcelona Condor ES stay hotels hotel normal 4 star 4 estrelles 169   wedding 100 80 70 50 0   80 0 12.9 BCN 0.6 0.6 11887 Barcelona Barcelonès Via AUGUSTA 127 41.4008 2.1481     ES-CAT Hotels 4 estrelles HB-003342
348865 348865 AC Victoria Suites ES stay hotels hotel normal 4 star 4 estrelles 122   wedding 90 80 60 50 0   80 0 10.1 BCN 1.0 0.6 6071 Barcelona Barcelonès Carrer Beltrán i Rózpide 7-9 41.3859 2.1066     ES-CAT Hotels 4 estrelles HB-003364
348866 348866 Amaraigua ES stay hotels hotel normal 4 star 4 estrelles 165   wedding 100 80 70 50 0   80 0 28.7 GRO 0.0 0.0 1841 Malgrat de Mar Maresme Passeig Pins 7 41.6466 2.7413     ES-CAT Hotels 4 estrelles HB-003368
348870 348870 Europa Splash ES stay hotels hotel normal 4 star 4 estrelles superior 258   wedding 100 90 70 50 0   80 0 28.7 GRO 0.0 0.0 1841 Malgrat de Mar Maresme Passeig Marítim 76 41.6466 2.7413     ES-CAT Hotels 4 estrelles superior HB-003387
348883 348883 NH Sants Barcelona ES stay hotels hotel normal 4 star 4 estrelles 347   wedding 100 90 70 50 0   80 0 11.3 BCN 0.6 0.6 10505 Barcelona Barcelonès Carrer Numància 72-74 41.3868 2.1424     ES-CAT Hotels 4 estrelles HB-003542
348885 348885 MOXY BARCELONA ES stay hotels hotel normal 4 star 4 estrelles 804   wedding 100 90 70 50 0   80 0 10.1 BCN 0.2 0.2 9904 Barcelona Barcelonès Carrer MALLORCA 1-23 41.376 2.1382     ES-CAT Hotels 4 estrelles HB-003580
348887 348887 HOTEL OASIS PARK SPLASH ES stay hotels hotel normal 4 star 4 estrelles 422   wedding 100 90 70 50 0   65 0 32.9 GRO 1.3 1.3 2233 Calella Maresme Carrer MONTNEGRE 54 41.6168 2.6691     ES-CAT Hotels 4 estrelles HB-003629
348905 348905 Alegria Mar Mediterània ES stay hotels hotel normal 4 star 4 estrelles superior 236   wedding 100 90 70 50 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 Hotels 4 estrelles superior HB-003731
348908 348908 Gran Derby ES stay hotels hotel normal 4 star 4 estrelles 86   wedding 90 80 60 50 0   80 0 11.3 BCN 0.6 0.6 10505 Barcelona Barcelonès Carrer Loreto 28 41.3868 2.1424     ES-CAT Hotels 4 estrelles HB-003751
348911 348911 Catalonia Park Putxet ES stay hotels hotel normal 4 star 4 estrelles 288   wedding 100 90 70 50 0   80 0 14.0 BCN 0.2 0.2 11883 Barcelona Barcelonès Carrer Putxet 68-74 41.4129 2.1454     ES-CAT Hotels 4 estrelles HB-003757
348925 348925 Catalonia Barcelona 505 ES stay hotels hotel normal 4 star 4 estrelles 192   wedding 100 80 70 50 0   80 0 13.1 BCN 0.2 0.2 10529 Barcelona Barcelonès Carrer Muntaner 505 41.407 2.1346     ES-CAT Hotels 4 estrelles HB-003795
348930 348930 HOTEL REKORD ES stay hotels hotel normal 4 star 4 estrelles 26   wedding 70 60 40 50 0   80 0 12.3 BCN 0.1 0.1 11156 Barcelona Barcelonès Carrer MUNTANER 352 41.397 2.1423     ES-CAT Hotels 4 estrelles HB-003805
348931 348931 Catalonia Atenas ES stay hotels hotel normal 4 star 4 estrelles 356   wedding 100 90 70 50 0   80 0 15.5 BCN 0.1 0.1 11675 Barcelona Barcelonès Avinguda Meridiana 151 41.4118 2.1838     ES-CAT Hotels 4 estrelles HB-003809
348932 348932 HG CITY SUITES BARCELONA ES stay hotels hotel normal 4 star 4 estrelles 116   wedding 90 80 60 50 0   80 0 12.9 BCN 0.6 0.6 11887 Barcelona Barcelonès Via Augusta 89 41.4008 2.1481     ES-CAT Hotels 4 estrelles HB-003821
348940 348940 Florida Park ES stay hotels hotel normal 4 star 4 estrelles 638   wedding 100 90 70 50 0   80 0 29.6 GRO 2.4 1.0 2439 Santa Susanna Maresme Avinguda Mar 17 41.6411 2.7111     ES-CAT Hotels 4 estrelles HB-003845
348941 348941 Catalonia Plaça Catalunya ES stay hotels hotel normal 4 star 4 estrelles 257   wedding 100 90 70 50 0   80 0 12.5 BCN 0.2 0.2 11022 Barcelona Barcelonès Carrer Bergara 11 41.3823 2.176     ES-CAT Hotels 4 estrelles HB-003846
348944 348944 ALEXANDRA BARCELONA HOTEL, CURIO COLLECTION BY HILTON ES stay hotels hotel normal 4 star 4 estrelles superior 226   wedding 100 90 70 50 0   80 0 12.7 BCN 0.5 0.5 11859 Barcelona Barcelonès Carrer Mallorca 251 41.3937 2.1586     ES-CAT Hotels 4 estrelles superior HB-003851
348945 348945 Best Western Alfa Aeropuerto ES stay hotels hotel normal 4 star 4 estrelles 190   wedding 100 80 70 50 0   80 0 6.7 BCN 2.0 1.4 2772 Barcelona Barcelonès Lloc Franca-carrer K s/n 41.345 2.1272     ES-CAT Hotels 4 estrelles HB-003859
348947 348947 Aqua Hotel Aquamarina Spa ES stay hotels hotel normal 4 star 4 estrelles 1053   wedding 100 90 70 50 0   80 0 29.6 GRO 2.4 1.0 2439 Santa Susanna Maresme Avinguda Mar 16 41.6411 2.7111     ES-CAT Hotels 4 estrelles HB-003862
348951 348951 HOTEL INDALO PARK ES stay hotels hotel normal 4 star 4 estrelles 616   wedding 100 90 70 50 0   80 0 29.6 GRO 2.4 1.0 2439 Santa Susanna Maresme Avinguda del Mar 19 41.6411 2.7111     ES-CAT Hotels 4 estrelles HB-003869
348957 348957 Rívoli Ramblas ES stay hotels hotel normal 4 star 4 estrelles 241   wedding 100 90 70 50 0   80 0 12.5 BCN 0.2 0.2 11022 Barcelona Barcelonès Carrer Rambla 128 41.3823 2.176     ES-CAT Hotels 4 estrelles HB-003878
348958 348958 Caprici ES stay hotels hotel normal 4 star 4 estrelles 433   wedding 100 90 70 50 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 Hotels 4 estrelles HB-003881
348961 348961 Hesperia Sant Just ES stay hotels hotel normal 4 star 4 estrelles 300   wedding 100 90 70 50 0   80 0 9.8 BCN 0.6 0.6 682 Sant Just Desvern Baix Llobregat Carrer Frederic Mompou 1 41.3849 2.0746     ES-CAT Hotels 4 estrelles HB-003884
348964 348964 Bernat II ES stay hotels hotel normal 4 star 4 estrelles superior 249   wedding 100 90 70 50 0   65 0 32.9 GRO 1.3 1.3 2233 Calella Maresme Avinguda Turisme 42 41.6168 2.6691     ES-CAT Hotels 4 estrelles superior HB-003887
348965 348965 Balmes ES stay hotels hotel normal 4 star 4 estrelles 196   wedding 100 80 70 50 0   80 0 12.7 BCN 0.5 0.5 11859 Barcelona Barcelonès Carrer Mallorca, 216 216 41.3937 2.1586     ES-CAT Hotels 4 estrelles HB-003888
348967 348967 HCC Hotel St. Moritz ES stay hotels hotel normal 4 star 4 estrelles 169   wedding 100 80 70 50 0   80 0 12.6 BCN 0.2 0.2 11156 Barcelona Barcelonès Carrer Diputació 262 Bis 41.3898 2.1643     ES-CAT Hotels 4 estrelles HB-003891
348968 348968 Hilton Barcelona ES stay hotels hotel normal 4 star 4 estrelles superior 580   wedding 100 90 70 50 0   80 0 10.1 BCN 0.2 0.2 9904 Barcelona Barcelonès Avinguda Diagonal 589-591 41.376 2.1382     ES-CAT Hotels 4 estrelles superior HB-003892
348972 348972 Guitart Grand Passage ES stay hotels hotel normal 4 star 4 estrelles superior 98   wedding 90 80 60 50 0   80 0 12.1 BCN 0.3 0.3 11156 Barcelona Barcelonès Carrer Muntaner 212 41.3906 2.1521     ES-CAT Hotels 4 estrelles superior HB-003896
348973 348973 Mercury ES stay hotels hotel normal 4 star 4 estrelles superior 646   wedding 100 90 70 50 0   80 0 29.6 GRO 2.4 1.0 2439 Santa Susanna Maresme Avinguda Mar 2 41.6411 2.7111     ES-CAT Hotels 4 estrelles superior HB-003898
348974 348974 San Sebastián Playa ES stay hotels hotel normal 4 star 4 estrelles 102   wedding 90 80 60 50 0   80 0 24.3 BCN 1.7 1.7 2936 Sitges Garraf Carrer Port Alegre 53 41.2446 1.7962     ES-CAT Hotels 4 estrelles HB-003900
348977 348977 HOTEL ALMIRANTE ES stay hotels hotel normal 4 star 4 estrelles 151   wedding 100 80 70 50 0   80 0 13.0 BCN 0.3 0.3 11149 Barcelona Barcelonès Via Laietana 42 41.3831 2.1848     ES-CAT Hotels 4 estrelles HB-003906
348980 348980 URH Ciutat de Mataró ES stay hotels hotel normal 4 star 4 estrelles 242   wedding 100 90 70 50 0   65 0 40.9 BCN 0.0 0.0 533 Mataró Maresme Camí Ral 640-648 41.5421 2.4445     ES-CAT Hotels 4 estrelles HB-003910
348982 348982 DOMO ES stay hotels hotel normal 4 star 4 estrelles 88   wedding 90 80 60 50 0   65 0 32.1 BCN 0.5 0.5 120 Vilafranca del Penedès Alt Penedès Carrer FRANCESC MACIÀ 4 41.35 1.7     ES-CAT Hotels 4 estrelles HB-003913
348984 348984 Hotel Catalonia Boulevard ES stay hotels hotel normal 4 star 4 estrelles superior 215   wedding 100 90 70 50 0   80 0 12.7 BCN 0.5 0.5 11859 Barcelona Barcelonès Carrer del Rosselló 249 41.3937 2.1586     ES-CAT Hotels 4 estrelles superior HB-003915
348985 348985 Gran Hotel Havana ES stay hotels hotel normal 4 star 4 estrelles superior 290   wedding 100 90 70 50 0   80 0 13.2 BCN 0.5 0.5 11964 Barcelona Barcelonès Gran Via de les Corts Catalanes 647 41.3913 2.1749     ES-CAT Hotels 4 estrelles superior HB-003916
348987 348987 Catalonia Diagonal Centro ES stay hotels hotel normal 4 star 4 estrelles 162   wedding 100 80 70 50 0   80 0 12.7 BCN 0.5 0.5 11859 Barcelona Barcelonès Carrer Balmes 142-146 41.3937 2.1586     ES-CAT Hotels 4 estrelles HB-003918
348988 348988 Abbot ES stay hotels hotel normal 4 star 4 estrelles 78   wedding 80 70 50 50 0   80 0 11.3 BCN 0.6 0.6 10505 Barcelona Barcelonès Avinguda Roma 23 41.3868 2.1424     ES-CAT Hotels 4 estrelles HB-003923
348994 348994 Acta City 47 ES stay hotels hotel normal 4 star 4 estrelles 130   wedding 90 80 60 50 0   80 0 11.3 BCN 0.6 0.6 10505 Barcelona Barcelonès Carrer Nicaragua 47 41.3868 2.1424     ES-CAT Hotels 4 estrelles HB-003934
348996 348996 Don Cándido ES stay hotels hotel normal 4 star 4 estrelles superior 246   wedding 100 90 70 50 0   80 0 30.0 BCN 1.5 1.5 210 Terrassa Vallès Occidental Rambla Pare Alegre 98 41.5601 2.0005     ES-CAT Hotels 4 estrelles superior HB-003938
348999 348999 HOTEL CATALONIA SABADELL ES stay hotels hotel normal 4 star 4 estrelles 218   wedding 100 90 70 50 0   80 0 28.4 BCN 1.9 1.9 134 Sabadell Vallès Occidental Plaça de Catalunya 10 41.5525 2.0898     ES-CAT Hotels 4 estrelles HB-003942
349002 349002 Melià Sitges ES stay hotels hotel normal 4 star 4 estrelles 609   wedding 100 90 70 50 0   80 0 24.3 BCN 1.7 1.7 2936 Sitges Garraf Carrer Joan Salvat Papasseit 38 41.2446 1.7962     ES-CAT Hotels 4 estrelles HB-003945
349005 349005 Novotel Barcelona Sant Cugat ES stay hotels hotel normal 4 star 4 estrelles 300   wedding 100 90 70 50 0   80 0 18.9 BCN 0.5 0.5 188 Sant Cugat del Vallès Vallès Occidental Plaça Xavier Cugat s/n 41.4667 2.0833     ES-CAT Hotels 4 estrelles HB-003949
349006 349006 Silken Ramblas ES stay hotels hotel normal 4 star 4 estrelles 210   wedding 100 90 70 50 0   80 0 11.9 BCN 0.1 0.1 10973 Barcelona Barcelonès Carrer Pintor Fortuny 13 41.3799 2.1687     ES-CAT Hotels 4 estrelles HB-003951
349007 349007 HOTEL CONDES DE BARCELONA ES stay hotels hotel normal 4 star 4 estrelles 143   wedding 90 80 60 50 0   80 0 12.7 BCN 0.5 0.5 11859 Barcelona Barcelonès Passeig DE GRÀCIA 73 41.3937 2.1586     ES-CAT Hotels 4 estrelles HB-003952
349008 349008 Top Royal Sun ES stay hotels hotel normal 4 star 4 estrelles 408   wedding 100 90 70 50 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 Hotels 4 estrelles HB-003953
349009 349009 Barceló Sants ES stay hotels hotel normal 4 star 4 estrelles 754   wedding 100 90 70 50 0   80 0 10.1 BCN 0.2 0.2 9904 Barcelona Barcelonès Plaça Països Catalans s/n 41.376 2.1382     ES-CAT Hotels 4 estrelles HB-003954
349010 349010 Vila de Caldes ES stay hotels hotel normal 4 star 4 estrelles 60   wedding 80 70 50 50 0   65 0 37.4 Folgueroles Airfield 0.0 0.0 39 Caldes de Montbui Vallès Oriental Plaça Àngel 5 41.6333 2.1667     ES-CAT Hotels 4 estrelles HB-003955
349012 349012 GRAN HOTEL VERDI ES stay hotels hotel normal 4 star 4 estrelles 336   wedding 100 90 70 50 0   80 0 29.1 BCN 1.7 1.7 123 Sabadell Vallès Occidental Avinguda de Francesc Macià 62 41.5579 2.1037     ES-CAT Hotels 4 estrelles HB-003957
349016 349016 Hotel Augusta Barcelona Valles ES stay hotels hotel normal 4 star 4 estrelles 197   wedding 100 80 70 50 0   65 0 33.3 BCN 2.0 2.0 66 Vilanova del Vallès Vallès Oriental Carretera AP - 7 Granollers Sortida 13 41.5534 2.2858     ES-CAT Hotels 4 estrelles HB-003966
349017 349017 Catalonia Barcelona Plaza ES stay hotels hotel normal 4 star 4 estrelles 658   wedding 100 90 70 50 0   80 0 10.1 BCN 0.2 0.2 9904 Barcelona Barcelonès Plaça Espanya 6-8 41.376 2.1382     ES-CAT Hotels 4 estrelles HB-003967
349018 349018 Gran Hotel Barcino ES stay hotels hotel normal 4 star 4 estrelles 116   wedding 90 80 60 50 0   80 0 12.5 BCN 0.2 0.2 11022 Barcelona Barcelonès Carrer JAUME I 6 41.3823 2.176     ES-CAT Hotels 4 estrelles HB-003969
349022 349022 Husa L'Illa ES stay hotels hotel normal 4 star 4 estrelles 204   wedding 100 90 70 50 0   80 0 11.3 BCN 0.6 0.6 10505 Barcelona Barcelonès Avinguda Diagonal 555 41.3868 2.1424     ES-CAT Hotels 4 estrelles HB-003973
349024 349024 Eurostars Parc del Vallès ES stay hotels hotel normal 4 star 4 estrelles 164   wedding 100 80 70 50 0   80 0 22.2 BCN 0.0 0.0 59 Cerdanyola del Vallès Vallès Occidental Carrer Artesans 2-8 41.4911 2.1408     ES-CAT Hotels 4 estrelles HB-003976
349025 349025 Aqua Hotel Promenade ES stay hotels hotel normal 4 star 4 estrelles 358   wedding 100 90 70 50 0   65 0 31.4 GRO 0.0 0.0 2352 Pineda de Mar Maresme Passeig Marítim 7 41.6276 2.6889     ES-CAT Hotels 4 estrelles HB-003977

Next page

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