home / venues_public

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

7 rows where best_for = "wedding", country = "PL" and family = "hostels"

This data as json, CSV (advanced)

Suggested facets: rating_label, fit_wedding, reachability_score, isolation_score, nearest_airport, town_km, venues_5km, source_type, source_category

group 1

  • stay 7

family 1

  • hostels · 7 ✖

country 1

  • PL · 7 ✖

best_for 1

  • wedding · 7 ✖

rating_value 0

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
13540 13540 CZEKAY PL stay hostels hostel normal   none KAT_I_SML 90 30 wedding 55 0 0 0 0   80 20 17.3 Łask Air Base 0.7 0.7 1 Zduńska Wola Zduńska Wola (gmina miejska) Dolna 41 51.59306735 18.937176071125     PL-CWOH RODZ_SML KAT_I_SML CWOH/1019011/2021/05/829
13615 13615 DOM WYCIECZKOWY NR 3 PL stay hostels hostel normal   none KAT_III_DOM 148 70 wedding 55 0 0 0 0   80 10 6.5 LCJ 3.4 3.4 27 Łódź Łódź (gmina miejska) Łęczycka 70 51.7414063 19.4869906     PL-CWOH RODZ_DOM KAT_III_DOM CWOH/1061011/2021/05/914
13663 13663 WORD OF LIFE Centrum Młodzieżowe PL stay hostels hostel normal   none KAT_II_SML 138 23 wedding 55 0 0 0 0   80 30 18.6 LCJ 3.8 3.8 3 Zgierz Zgierz (gmina miejska) Łanowa 24/26 51.8888197 19.3964732     PL-CWOH RODZ_SML KAT_II_SML CWOH/1020031/2021/05/967
14177 14177 Agrykola PL stay hostels hostel normal   none KAT_I_SML 81 34 wedding 55 0 0 0 0   80 0 7.7 WAW 1.6 1.6 63 Warszawa Warszawa (gmina miejska) Myśliwiecka 9 52.2205683 21.0351081248885     PL-CWOH RODZ_SML KAT_I_SML CWOH/1465011/2021/05/1544
14651 14651 SZKOLNE SCHRONISKO MŁODZIEŻOWE W CZUDCU PL stay hostels hostel normal   none KAT_I_SML 135 58 wedding 55 0 0 0 0   70 30 22.8 RZE 15.7 0.7 0 Czudec Czudec (gmina wiejska) Rzeszowska 82 49.9397636 21.8464016     PL-CWOH RODZ_SML KAT_I_SML CWOH/1819012/2021/05/2083
15259 15259 POWIATOWE CENTRUM EDUKACJI - SZKOLNE SCHRONISKO MŁODZIEŻOWE W BRZESKU PL stay hostels hostel normal   none KAT_I_SML 112 28 wedding 55 0 0 0 0   65 20 60.5 KRK 0.8 0.8 3 Brzesko Brzesko (gmina miejsko-wiejska) Piastowska 2B 49.9642250275927 20.613344907760624     PL-CWOH RODZ_SML KAT_I_SML CWOH/1202024/2021/12/3497
15396 15396 SZKOLNE SCHRONISKO MŁODZIEŻOWE ŚWIDWIN PL stay hostels hostel normal   none KAT_II_SML 286 76 wedding 65 0 0 0 0   80 30 4.6 Swidwin Military Air Base 0.9 0.9 0 Świdwin Świdwin (gmina miejska) Szczecińska 88 53.77173105 15.76356837475     PL-CWOH RODZ_SML KAT_II_SML CWOH/3216011/2021/05/3394

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");
Powered by Datasette · Queries took 3326.235ms · 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)