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

53 rows where country = "RO", family = "bars_pubs" and rating_value = 5

This data as json, CSV (advanced)

Suggested facets: venue_type, rating_label, fit_banquet, fit_party, reachability_score, isolation_score, nearest_airport, town_km, city, municipality, source_type, source_category

best_for 2

rating_value 1

group 1

family 1

  • bars_pubs · 53 ✖

country 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
46267 46267 CRYSTAL CAFE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 0 6.8 OMR 7.6 1.8 411 Com. Sânmartin BIHOR   46.9895138 21.9758953     RO-SITUR BAR DE ZI 5 - STELE  
46769 46769 ARO PALACE, BAR DE NOAPTE RO eat_drink bars_pubs nightclub normal 5 star 5 - STELE     party 0 0 50 0 60   80 0 8.7 GHV 1.0 1.0 1172 Mun. Braşov BRAŞOV   45.6450658 25.5941884     RO-SITUR BAR DE NOAPTE 5 - STELE  
46770 46770 ARO PALACE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 0 8.5 GHV 1.2 1.2 1175 Mun. Braşov BRAŞOV   45.6453981 25.5910919     RO-SITUR BAR DE ZI 5 - STELE  
47581 47581 SUNGARDEN RESORT, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   70 20 15.5 CLJ 10.0 2.4 12 Com. Baciu CLUJ   46.8108691 23.4856338     RO-SITUR BAR DE ZI 5 - STELE  
47583 47583 VENEZIA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 0 12.4 CLJ 6.5 0.9 209 Com. Baciu CLUJ   46.7934309 23.5236679     RO-SITUR BAR DE ZI 5 - STELE  
47901 47901 FLASHBACK LIVE, CLUB SAU DISCO-BAR RO eat_drink bars_pubs nightclub normal 5 star 5 - STELE     party 0 0 50 0 60   80 0 6.2 CLJ 0.9 0.9 1205 Mun. Cluj-Napoca CLUJ   46.773182 23.606395     RO-SITUR CLUB SAU DISCO-BAR 5 - STELE  
47917 47917 GRAND ITALIA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 0 7.1 CLJ 1.7 1.7 1222 Mun. Cluj-Napoca CLUJ   46.7520955 23.6060333     RO-SITUR BAR DE ZI 5 - STELE  
47997 47997 LOBBY, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 0 6.6 CLJ 0.4 0.4 1227 Mun. Cluj-Napoca CLUJ   46.7652447 23.6050962     RO-SITUR BAR DE ZI 5 - STELE  
48053 48053 OPERA PLAZA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 0 6.8 CLJ 0.3 0.3 1226 Mun. Cluj-Napoca CLUJ   46.7688698 23.6005709     RO-SITUR BAR DE ZI 5 - STELE  
48240 48240 PRINTUL VANATOR, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 0 10.9 Câmpia Turzii Air Base 0.7 0.7 105 Mun. Turda CLUJ   46.5724553 23.7870053     RO-SITUR BAR DE ZI 5 - STELE  
48502 48502 BUDDHA BAR, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 0 24.5 CND 1.6 1.6 651 Mun. Constanţa CONSTANŢA   44.1767469 28.6536425     RO-SITUR BAR DE ZI 5 - STELE  
48533 48533 CLUB EGO, CLUB SAU DISCO-BAR RO eat_drink bars_pubs nightclub normal 5 star 5 - STELE     party 0 0 50 0 60   80 10 14.7 CND 5.5 4.5 2039 Mun. Constanţa CONSTANŢA   44.2696133 28.6204603     RO-SITUR CLUB SAU DISCO-BAR 5 - STELE  
48646 48646 OPOSSUM, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 10 21.0 CND 2.6 2.6 860 Mun. Constanţa CONSTANŢA   44.2038081 28.6323331     RO-SITUR BAR DE ZI 5 - STELE  
48900 48900 MAMAIA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 10 15.2 CND 6.2 4.0 1841 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.2623995 28.6187463     RO-SITUR BAR DE ZI 5 - STELE  
49174 49174 NEW BELVEDERE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   65 0 53.9 Balchik Airfield 0.9 0.9 755 Mun. Mangalia CONSTANŢA   43.8107589 28.5847333     RO-SITUR BAR DE ZI 5 - STELE  
49468 49468 POOL SATURN, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 15   banquet 0 0 50 0 45   65 0 55.7 Balchik Airfield 1.7 1.7 962 Mun. Mangalia, Loc. Saturn CONSTANŢA   43.8285817351993 28.5887994173355     RO-SITUR BAR DE ZI 5  
49841 49841 CLUB COLONIAL, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 10 13.6 CND 3.9 2.9 2170 Oraş Năvodari CONSTANŢA   44.2859367 28.6225924     RO-SITUR BAR DE ZI 5 - STELE  
49892 49892 LOBBY, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 10 12.7 CND 4.5 3.7 1558 Oraş Năvodari CONSTANŢA   44.341087 28.6456565     RO-SITUR BAR DE ZI 5 - STELE  
50307 50307 BAR BOWLING - VIVA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   65 10 51.6 Cahul International Airport 4.2 3.6 152 Mun. Galaţi GALAŢI   45.4168202 28.0052625     RO-SITUR BAR DE ZI 5 - STELE  
50308 50308 BAR HOTEL, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   65 0 48.6 Cahul International Airport 0.7 0.7 169 Mun. Galaţi GALAŢI   45.4312501 28.0556632     RO-SITUR BAR DE ZI 5 - STELE  
50309 50309 BAR PISCINA - VIVA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   65 10 51.6 Cahul International Airport 4.2 3.6 152 Mun. Galaţi GALAŢI   45.4168202 28.0052625     RO-SITUR BAR DE ZI 5 - STELE  
50310 50310 BERARIE PIZZERIE BARBEQUE, BAR DE NOAPTE RO eat_drink bars_pubs nightclub normal 5 star 5 - STELE     party 0 0 50 0 60   65 0 49.8 Cahul International Airport 2.0 2.0 165 Mun. Galaţi GALAŢI   45.4276017 28.0287905     RO-SITUR BAR DE NOAPTE 5 - STELE  
50365 50365 TEMPTATION, BAR DE NOAPTE RO eat_drink bars_pubs nightclub normal 5 star 5 - STELE     party 0 0 50 0 60   65 10 49.6 Cahul International Airport 3.3 3.3 170 Mun. Galaţi GALAŢI   45.4353208 28.0079945     RO-SITUR BAR DE NOAPTE 5 - STELE  
51074 51074 BURGO, CRAMĂ RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 0 2.8 IAS 0.9 0.9 303 Mun. Iaşi IAŞI   47.1584549 27.6014418     RO-SITUR CRAMĂ 5 - STELE  
51124 51124 NUBO, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 0 2.8 IAS 0.9 0.9 303 Mun. Iaşi IAŞI   47.1584549 27.6014418     RO-SITUR BAR DE ZI 5 - STELE  
51177 51177 SNAGOV CLUB, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   70 0 15.3 OTP 23.2 1.4 30 Com. Snagov ILFOV   44.7017844 26.1651519     RO-SITUR BAR DE ZI 5 - STELE  
51179 51179 SNAGOV CLUB-PISCINA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   70 0 15.3 OTP 23.2 1.4 30 Com. Snagov ILFOV   44.7017844 26.1651519     RO-SITUR BAR DE ZI 5 - STELE  
51180 51180 SNAGOV CLUB-TERASA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   70 0 15.3 OTP 23.2 1.4 30 Com. Snagov ILFOV   44.7017844 26.1651519     RO-SITUR BAR DE ZI 5 - STELE  
51551 51551 INTERMEZZO, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 0 7.3 BBU 0.6 0.6 2027 Bucureşti MUNICIPIUL BUCUREŞTI   44.4376182 26.1031175     RO-SITUR BAR DE ZI 5 - STELE  
51565 51565 ARISTOCOOL, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 0 6.9 BBU 1.4 1.4 2098 Mun. Bucureşti, Sector 1 MUNICIPIUL BUCUREŞTI   44.4413458 26.0944535     RO-SITUR BAR DE ZI 5 - STELE  
51590 51590 CASA CAPSA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 0 7.5 BBU 0.7 0.7 2057 Mun. Bucureşti, Sector 1 MUNICIPIUL BUCUREŞTI   44.4353792 26.0981013     RO-SITUR BAR DE ZI 5 - STELE  
51593 51593 CENTRO, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 10 5.8 BBU 2.8 2.8 2106 Mun. Bucureşti, Sector 1 MUNICIPIUL BUCUREŞTI   44.452444 26.0856777     RO-SITUR BAR DE ZI 5 - STELE  
51594 51594 CENTRO BAR, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 10 4.4 BBU 3.9 3.9 1826 Mun. Bucureşti, Sector 1 MUNICIPIUL BUCUREŞTI   44.4649938 26.0878126     RO-SITUR BAR DE ZI 5 - STELE  
51608 51608 CROWNE CAFE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 0 4.1 BBU 1.9 1.9 862 Mun. Bucureşti, Sector 1 MUNICIPIUL BUCUREŞTI   44.4791073 26.0643015     RO-SITUR BAR DE ZI 5 - STELE  
51616 51616 ENGLISH BAR, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 0 6.9 BBU 1.3 1.3 2096 Mun. Bucureşti, Sector 1 MUNICIPIUL BUCUREŞTI   44.4411023 26.0958982     RO-SITUR BAR DE ZI 5 - STELE  
51633 51633 INTERMEZZO, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 10 5.8 BBU 2.8 2.8 2106 Mun. Bucureşti, Sector 1 MUNICIPIUL BUCUREŞTI   44.452444 26.0856777     RO-SITUR BAR DE ZI 5 - STELE  
51634 51634 INTERMEZZO, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 10 5.8 BBU 2.8 2.8 2106 Mun. Bucureşti, Sector 1 MUNICIPIUL BUCUREŞTI   44.452444 26.0856777     RO-SITUR BAR DE ZI 5 - STELE  
51656 51656 LOBBY BAR, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 0 7.5 BBU 1.6 1.6 2054 Mun. Bucureşti, Sector 1 MUNICIPIUL BUCUREŞTI   44.4367026 26.0866563     RO-SITUR BAR DE ZI 5 - STELE  
51677 51677 NAMI BEACH CLUB & MORE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 STELE 80   banquet 0 0 70 0 55   80 0 6.9 BBU 1.4 1.4 2093 Mun. Bucureşti, Sector 1 MUNICIPIUL BUCUREŞTI   44.441049 26.0935483     RO-SITUR BAR DE ZI 5 STELE  
51695 51695 PISCINA PANORAMIC, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 10 5.8 BBU 2.8 2.8 2106 Mun. Bucureşti, Sector 1 MUNICIPIUL BUCUREŞTI   44.452444 26.0856777     RO-SITUR BAR DE ZI 5 - STELE  
51842 51842 PALATUL SUTER, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 0 9.4 BBU 1.8 1.8 2018 Mun. Bucureşti, Sector 4 MUNICIPIUL BUCUREŞTI   44.4190715 26.093078     RO-SITUR BAR DE ZI 5 - STELE  
51866 51866 HERITAGE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 52   banquet 0 0 60 0 55   80 0 7.7 BBU 1.0 1.0 2079 Mun. Bucureşti, Sector 5 MUNICIPIUL BUCUREŞTI   44.4344524 26.0944721     RO-SITUR BAR DE ZI 5  
51875 51875 PAVILION LOUNGE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 10 8.9 BBU 2.4 2.4 1965 Mun. Bucureşti, Sector 5 MUNICIPIUL BUCUREŞTI   44.4256802 26.0770752     RO-SITUR BAR DE ZI 5 - STELE  
51880 51880 THE GARDEN, TERASĂ RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 10 8.8 BBU 2.4 2.4 1972 Mun. Bucureşti, Sector 5 MUNICIPIUL BUCUREŞTI   44.4261858 26.0776088     RO-SITUR TERASĂ 5 - STELE  
51886 51886 GOURMET, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 10 10.9 BBU 2.9 2.6 773 Mun. Bucureşti, Sector 6 MUNICIPIUL BUCUREŞTI   44.4160887 26.0397067     RO-SITUR BAR DE ZI 5 - STELE  
51910 51910 WINE BAR, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 10 10.9 BBU 2.9 2.6 773 Mun. Bucureşti, Sector 6 MUNICIPIUL BUCUREŞTI   44.4160887 26.0397067     RO-SITUR BAR DE ZI 5 - STELE  
52463 52463 SKY bar lobby, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   65 0 49.1 OTP 7.2 0.2 24 Com. Păuleşti PRAHOVA   45.0014594 25.9616923     RO-SITUR BAR DE ZI 5 - STELE  
52464 52464 SKY pool, TERASĂ RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   65 10 46.9 OTP 4.7 2.6 50 Com. Păuleşti PRAHOVA   44.9845273 25.9830405     RO-SITUR TERASĂ 5 - STELE  
53046 53046 ENGLISH BAR, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 10 4.2 SBZ 4.7 4.7 606 Mun. Sibiu SIBIU   45.760479 24.1269422     RO-SITUR BAR DE ZI 5 - STELE  
53579 53579 ROYAL, BAR DE NOAPTE RO eat_drink bars_pubs nightclub normal 5 star 5 - STELE     party 0 0 50 0 60   65 10 38.4 CSB 2.1 2.1 39 Mun. Lugoj TIMIŞ   45.6718724 21.9143147     RO-SITUR BAR DE NOAPTE 5 - STELE  
53750 53750 BIG FISH, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   45 0 54.1 TCE 31.5 0.1 64 Com. Crişan TULCEA   45.1743855 29.3851996     RO-SITUR BAR DE ZI 5 - STELE  
53756 53756 ELEMENTS, CLUB SAU DISCO-BAR RO eat_drink bars_pubs nightclub normal 5 star 5 - STELE     party 0 0 50 0 60   45 0 54.1 TCE 31.5 0.1 64 Com. Crişan TULCEA   45.1743855 29.3851996     RO-SITUR CLUB SAU DISCO-BAR 5 - STELE  
53757 53757 LONG ISLAND, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   45 0 54.1 TCE 31.5 0.1 64 Com. Crişan TULCEA   45.1743855 29.3851996     RO-SITUR BAR DE ZI 5 - STELE  

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