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

25 rows where country = "PL", family = "guesthouses" and rating_value = 1

This data as json, CSV (advanced)

Suggested facets: name, capacity_persons, rooms, fit_wedding, reachability_score, isolation_score, airport_km, nearest_airport, town_km, venues_5km, municipality

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