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

15 rows where best_for = "wedding", family = "hostels" and rating_value = 2

This data as json, CSV (advanced)

Suggested facets: capacity_persons, rooms, fit_wedding, reachability_score, isolation_score, nearest_airport, town_km, venues_5km, city, municipality, address

rating_value 1

group 1

family 1

  • hostels · 15 ✖

country 1

best_for 1

  • wedding · 15 ✖

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
15594 15594 POARTA OILOR RO stay hostels hostel normal 2 star 2 - STELE 89 27 wedding 55 0 0 0 0   70 10 29.5 SBZ 15.8 1.3 6 Com. Gârbova, Sat Gârbova ALBA NR. 573 45.8593251 23.7201921 03.02.2021   RO-SITUR HOSTEL 2 - STELE 16307
16311 16311 MOARA CU NOROC 1 RO stay hostels hostel normal 2 star 2 - STELE 124 57 wedding 55 0 0 0 0   80 10 4.4 ARW 2.1 2.1 401 Mun. Arad ARAD STR. Strada Mucius Scaevola , NR. 11A 46.1644569 21.3194809 21.03.2022   RO-SITUR HOSTEL 2 - STELE 12118/6814
19805 19805 DUMBRAVA MINUNATĂ RO stay hostels hostel normal 2 star 2 - STELE 162 38 wedding 65 0 0 0 0   55 0 54.6 GHV 14.7 0.3 37 Com. Sâmbăta de Sus, Sat Sâmbăta de Sus BRAŞOV   45.7626028 24.8246228 05.09.2018   RO-SITUR HOSTEL 2 - STELE 16098
24624 24624 WHITE INN RO stay hostels hostel normal 2 star 2 - STELE 82 36 wedding 55 0 0 0 0   55 0 47.1 CND 15.9 0.4 808 Com. Costineşti, Sat Costineşti CONSTANŢA STR. Strada Tineretului , NR. 52 43.9525428 28.6366119 12.08.2024   RO-SITUR HOSTEL 2 - STELE 5053/3588
26766 26766 COMPLEX MAREA NEAGRA RO stay hostels hostel normal 2 star 2 - STELE 312 128 wedding 65 0 0 0 0   55 0 35.1 CND 13.0 0.2 1136 Oraş Eforie, Loc. Eforie Nord CONSTANŢA   44.0641579 28.63453 12.03.2025   RO-SITUR HOSTEL 2 - STELE 14925/8887
26916 26916 MAREA VIEŢII RO stay hostels hostel normal 2 star 2 - STELE 128 32 wedding 55 0 0 0 0   55 0 33.9 CND 11.8 1.1 959 Oraş Eforie, Loc. Eforie Nord CONSTANŢA STR. Strada Meduzei , NR. 8-10 44.0745953 28.6295603 17.07.2023   RO-SITUR HOSTEL 2 - STELE 35070
30847 30847 TISMANA RO stay hostels hostel normal 2 star 2 - STELE 112 56 wedding 55 0 0 0 0   55 20 66.9 CSB 26.9 2.3 19 Oraş Tismana, Sat Tismana GORJ   45.0644089 22.9415184 23.09.2013   RO-SITUR HOSTEL 2 - STELE 27225
31041 31041 CASA ERSA RO stay hostels hostel normal 2 star 2 - STELE 83 25 wedding 55 0 0 0 0   65 0 63.0 TGM 8.9 0.3 28 Com. Lupeni, Sat Morăreni HARGHITA STR. Strada Principală , NR. 139 46.3571262 25.2189094 29.10.2024   RO-SITUR HOSTEL 2 - STELE 28640
31293 31293 ERDELYI ERZSEBET TABOR RO stay hostels hostel normal 2 star 2 - STELE 90 23 wedding 55 0 0 0 0   40 20 80.6 TGM 22.6 6.3 31 Com. Zetea, Sat Izvoare HARGHITA NR. 109/A 46.4680519 25.4648872 16.02.2021   RO-SITUR HOSTEL 2 - STELE 22789
37442 37442 INTEGRO RO stay hostels hostel normal 2 star 2 - STELE 90 20 wedding 55 0 0 0 0   45 20 72.9 TGM 32.5 3.2 6 Com. Lunca Bradului, Sat Sălard MUREŞ   46.9368484 25.0802795 12.05.2011   RO-SITUR HOSTEL 2 - STELE 14516A
37997 37997 TELEKI RO stay hostels hostel normal 2 star 2 - STELE 110 33 wedding 55 0 0 0 0   45 10 54.2 TGM 34.9 3.1 266 Oraş Sovata MUREŞ STR. Strada Trandafirilor , NR. 147 46.6047477 25.0931037 07.03.2011   RO-SITUR HOSTEL 2 - STELE 13931A
40715 40715 NORA RO stay hostels hostel normal 2 star 2 - STELE 100 20 wedding 55 0 0 0 0   70 10 18.4 SBZ 12.7 0.8 15 Com. Râu Sadului, Sat Râu Sadului SIBIU NR. 277 45.6214984 24.058533 22.05.2012   RO-SITUR HOSTEL 2 - STELE 12008/8701
40912 40912 B 13 RO stay hostels hostel normal 2 star 2 - STELE 166 19 wedding 65 0 0 0 0   80 0 5.1 SBZ 0.6 0.6 706 Mun. Sibiu SIBIU STR. Strada Nicolae Bălcescu , NR. 13 45.7949855 24.1506504 31.10.2017   RO-SITUR HOSTEL 2 - STELE 27302
42442 42442 ALEX RO stay hostels hostel normal 2 star 2 - STELE 197 54 wedding 65 0 0 0 0   65 0 61.1 SCV 0.5 0.5 143 Mun. Câmpulung Moldovenesc SUCEAVA STR. Strada Pinului , NR. 35 - 37 47.5311625 25.5724952 02.07.2019   RO-SITUR HOSTEL 2 - STELE 8741/5747
45254 45254 CASA RUSTICĂ RO stay hostels hostel normal 2 star 2 - STELE 100 39 wedding 55 0 0 0 0   65 0 56.1 Boboc Air Base 3.8 0.7 65 Com. Câmpineanca, Sat Câmpineanca VRANCEA NR. 61 45.7088691 27.135855 30.08.2022   RO-SITUR HOSTEL 2 - STELE 31332

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