venues_public

509k venues across 8 countries. Browse by Stay / Eat & Drink / Other, then by family (Hotels, Guesthouses, Restaurants, Bars & Pubs…). Capacity, rating and location are the key event filters.

Event quick-starts: Wedding-friendly · Conference hotels · Large banquet venues · Spa retreats · Browse all + map

Note: ratings are normalized to a value + scheme; a 3★ in one country is not equivalent to another (scheme & country are shown). UK types are coarse (food-hygiene register), and several countries don't star-rate.

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

Queries

Tables

meta

key, value

3 rows

rating_schemes

slug, label, description

5 rows

venue_families

slug, group, label, sort, icon

17 rows

venue_groups

slug, label, sort, icon

3 rows

venue_types

slug, family, label, sort, icon

30 rows

venues

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

520,125 rows

... and 5 hidden tables