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

143 rows where best_for = "banquet", family = "bars_pubs" and rating_value = 5

This data as json, CSV (advanced)

Suggested facets: rating_label, fit_banquet, fit_party, reachability_score, isolation_score, nearest_airport, town_km, municipality, source, source_type, source_category, valid_until (date)

country 3

rating_value 1

group 1

family 1

  • bars_pubs · 143 ✖

best_for 1

  • banquet · 143 ✖

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  
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  
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  
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  
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  
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  
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  
773348 773348 GASTRO-BAR"PROTOKOL" ME eat_drink bars_pubs bar_pub normal 5 star 5*****     banquet 0 0 50 0 45   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Bar 5*****  
796266 796266   BG eat_drink bars_pubs bar_pub normal 5 star 5 60   banquet 0 0 60 0 55   30 0 95.8 SOF 34.4 0.0 907 Bansko Bansko ul. Karamanitsa № 11, hotel Premier Lakshari Mauntin Rezort 41.8361 23.48745 2031-04-19T21:00:00Z   BG-NTR Bar 5 РК-19-17554
796303 796303   BG eat_drink bars_pubs bar_pub normal 5 star 5 70   banquet 0 0 60 0 55   30 0 95.8 SOF 34.4 0.0 907 Bansko Bansko ul. Glazne № 5, Spa hotel Grand hotel Bansko 41.8361 23.48745 2031-01-25T22:00:00Z   BG-NTR Bar 5 РК-19-17488
796304 796304   BG eat_drink bars_pubs bar_pub normal 5 star 5 72   banquet 0 0 60 0 55   30 0 95.8 SOF 34.4 0.0 907 Bansko Bansko ul. Glazne № 5, Spa hotel Grand hotel Bansko 41.8361 23.48745 2031-01-25T22:00:00Z   BG-NTR Bar 5 РК-19-17487
796318 796318 BOROVETS PIKS/BOROVETS PEAKS BG eat_drink bars_pubs bar_pub normal 5 star 5 10   banquet 0 0 50 0 45   55 0 73.3 SOF 12.0 0.0 391 Borovets Samokov hotel Flora Butik Hotel 42.10566 23.02003 2031-01-25T22:00:00Z   BG-NTR Bar 5 РК-19-17467
796320 796320   BG eat_drink bars_pubs bar_pub normal 5 star 5 20   banquet 0 0 50 0 45   55 0 73.3 SOF 12.0 0.0 391 Borovets Samokov hotel Flora Butik Hotel 42.10566 23.02003 2031-01-25T22:00:00Z   BG-NTR Bar 5 РК-19-17465
796327 796327   BG eat_drink bars_pubs bar_pub normal 5 star 5 48   banquet 0 0 60 0 45   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna rayon Mladost, bul. Aleksandar Malinov № 111, biznes hotel Kraun Plaza Sofiya 42.69751 23.32415 2031-01-25T22:00:00Z   BG-NTR Bar 5 РК-19-17453
796368 796368 PURA BAR BG eat_drink bars_pubs bar_pub normal 5 star 5 150   banquet 0 0 80 0 65   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna r-n Lozenets, bul. Dzheyms Baucher № 100, biznes hotel Marinela 42.69751 23.32415 2030-11-23T22:00:00Z   BG-NTR Bar 5 РК-19-17385
796447 796447   BG eat_drink bars_pubs bar_pub normal 5 star 5 32   banquet 0 0 50 0 45   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar hotel Planeta 42.6931 27.7083 2030-09-15T21:00:00Z   BG-NTR Bar 5 РК-19-17261
796537 796537   BG eat_drink bars_pubs bar_pub normal 5 star 5 100   banquet 0 0 70 0 65   45 0 39.0 BOJ 35.5 0.0 587 Primorsko Primorsko ul. Briz № 1, hotel Belvedere Aleksandriya Klub 42.26791 27.75611 2030-07-31T21:00:00Z   BG-NTR Bar 5 РК-19-17137
796538 796538   BG eat_drink bars_pubs bar_pub normal 5 star 5 80   banquet 0 0 70 0 55   45 0 39.0 BOJ 35.5 0.0 587 Primorsko Primorsko ul. Briz № 1, hotel Belvedere Aleksandriya Klub 42.26791 27.75611 2030-07-31T21:00:00Z   BG-NTR Bar 5 РК-19-17136
796649 796649 OAZIS BG eat_drink bars_pubs bar_pub normal 5 star 5 20   banquet 0 0 50 0 45   70 0 18.5 VAR 12.9 0.0 579 Zlatni pyasatsi Varna v.k. Riviera, hotel Oazis 43.285 28.0418 2030-06-30T21:00:00Z   BG-NTR Bar 5 РК-19-16985
796693 796693   BG eat_drink bars_pubs bar_pub normal 5 star 5 20   banquet 0 0 50 0 45   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna kv. Boyana, ul.Ivanitsa Danchev № 23, hotel-rezidens Kaza Boyana 42.69751 23.32415 2030-06-01T21:00:00Z   BG-NTR Bar 5 РК-19-16925
796749 796749 Sky Bonsai BG eat_drink bars_pubs bar_pub normal 5 star 5 90   banquet 0 0 70 0 55   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna rayon Mladost, bul. Aleksandar Malinov № 111, hotel Kraun Plaza Sofiya 42.69751 23.32415 2030-04-15T21:00:00Z   BG-NTR Bar 5 РК-19-16843
796794 796794 CLUB BAR ENCORE BG eat_drink bars_pubs bar_pub normal 5 star 5 80   banquet 0 0 70 0 55   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna bul. Tsar Osvoboditel № 18 42.69751 23.32415 2030-03-12T22:00:00Z   BG-NTR Bar 5 РК-19-16782
796796 796796   BG eat_drink bars_pubs bar_pub normal 5 star 5 45   banquet 0 0 60 0 45   80 0 12.7 PDV 0.0 0.0 1591 Plovdiv Plovdiv ul. Ivan Vazov № 55, hotel Royal Plovdiv 42.15387 24.75001 2030-02-13T22:00:00Z   BG-NTR Bar 5 РК-19-16780
796865 796865 VITAMIN BG eat_drink bars_pubs bar_pub normal 5 star 5 10   banquet 0 0 50 0 45   30 0 95.8 SOF 34.4 0.0 907 Bansko Bansko ul. Pirin № 96, hotel Kempinski hotel Grand Arena 41.8361 23.48745 2029-12-30T22:00:00Z   BG-NTR Bar 5 РК-19-16674
796866 796866 BELA VISTA BG eat_drink bars_pubs bar_pub normal 5 star 5 90   banquet 0 0 70 0 55   30 0 95.8 SOF 34.4 0.0 907 Bansko Bansko ul. Pirin № 96, hotel Kempinski hotel Grand Arena 41.8361 23.48745 2029-12-30T22:00:00Z   BG-NTR Bar 5 РК-19-16673
796867 796867 SING - SING BG eat_drink bars_pubs bar_pub normal 5 star 5 90   banquet 0 0 70 0 55   30 0 95.8 SOF 34.4 0.0 907 Bansko Bansko ul. Pirin № 96, hotel Kempinski hotel Grand Arena 41.8361 23.48745 2029-12-30T22:00:00Z   BG-NTR Bar 5 РК-19-16672
796868 796868 Lobby bar BG eat_drink bars_pubs bar_pub normal 5 star 5 145   banquet 0 0 70 0 65   30 0 95.8 SOF 34.4 0.0 907 Bansko Bansko ul. Pirin № 96, hotel Kempinski hotel Grand Arena 41.8361 23.48745 2029-12-30T22:00:00Z   BG-NTR Bar 5 РК-19-16671
796886 796886   BG eat_drink bars_pubs bar_pub normal 5 star 5 36   banquet 0 0 50 0 45   80 10 7.0 GOZ 3.6 3.6 674 Arbanasi Veliko Tarnovo ul. Kapitanska № 2, hotel-rezidens Arbanasi palas 43.09815 25.66652 2029-12-09T22:00:00Z   BG-NTR Bar 5 РК-19-16641
796907 796907 LONDZH BG eat_drink bars_pubs bar_pub normal 5 star 5 59   banquet 0 0 60 0 55   70 0 23.3 Graf Ignatievo Air Base 16.9 0.0 422 Banya Razlog mestnost Koneshnitsa, SPA-hotel Grand hotel Terme 42.5 24.7 2029-12-09T22:00:00Z   BG-NTR Bar 5 РК-19-16605
796930 796930 SKY BAR BG eat_drink bars_pubs bar_pub normal 5 star 5 90   banquet 0 0 70 0 55   70 0 18.5 VAR 12.9 0.0 579 Zlatni pyasatsi Varna k.k. Zlatni pyasatsi, hotel Poseydon 43.285 28.0418 2029-10-17T21:00:00Z   BG-NTR Bar 5 РК-19-16573
796931 796931 Poseidon BG eat_drink bars_pubs bar_pub normal 5 star 5 90   banquet 0 0 70 0 55   70 0 18.5 VAR 12.9 0.0 579 Zlatni pyasatsi Varna k.k. Zlatni pyasatsi, hotel Poseydon 43.285 28.0418 2029-10-17T21:00:00Z   BG-NTR Bar 5 РК-19-16572
796984 796984   BG eat_drink bars_pubs bar_pub normal 5 star 5 24   banquet 0 0 50 0 45                 Kapitan Andreevo Svilengrad izvan regulatsionnite granitsi na seloto, hotel Goldanay     2029-09-18T21:00:00Z   BG-NTR Bar 5 РК-19-16491
797075 797075   BG eat_drink bars_pubs bar_pub normal 5 star 5 100   banquet 0 0 70 0 65   45 0 40.8 BOJ 40.1 0.0 291 Obzor Nesebar ul. Kraybrezhna № 7, hotel Reyna Del Mar 42.81998 27.88007 2029-08-28T21:00:00Z   BG-NTR Bar 5 РК-19-16367
797076 797076   BG eat_drink bars_pubs bar_pub normal 5 star 5 100   banquet 0 0 70 0 65   45 0 40.8 BOJ 40.1 0.0 291 Obzor Nesebar ul. Kraybrezhna № 7, hotel Reyna Del Mar 42.81998 27.88007 2029-08-28T21:00:00Z   BG-NTR Bar 5 РК-19-16366
797077 797077   BG eat_drink bars_pubs bar_pub normal 5 star 5 150   banquet 0 0 80 0 65   45 0 40.8 BOJ 40.1 0.0 291 Obzor Nesebar ul. Kraybrezhna № 7, hotel Reyna Del Mar 42.81998 27.88007 2029-08-28T21:00:00Z   BG-NTR Bar 5 РК-19-16365
797078 797078 Vitamina BG eat_drink bars_pubs bar_pub normal 5 star 5 20   banquet 0 0 50 0 45   45 0 40.8 BOJ 40.1 0.0 291 Obzor Nesebar ul. Kraybrezhna № 7, hotel Reyna Del Mar 42.81998 27.88007 2029-08-28T21:00:00Z   BG-NTR Bar 5 РК-19-16364
797116 797116 Piano bar BG eat_drink bars_pubs bar_pub normal 5 star 5 100   banquet 0 0 70 0 65   80 0 8.0 BOJ 0.0 0.0 971 Burgas Burgas ul. Knyaz Aleksandar Batenberg № 2, Spa- hotel Primorets 42.50651 27.46886 2029-08-04T21:00:00Z   BG-NTR Bar 5 РК-19-16315
797131 797131   BG eat_drink bars_pubs bar_pub normal 5 star 5 20   banquet 0 0 50 0 45   60 0 25.5 BOJ 33.1 0.0 2109 Sveti Vlas Nesebar m. Yurta pod patya, ul.Lyulin № 4, hotel Grand hotel Sveti Vlas 42.7136 27.75867 2029-08-04T21:00:00Z   BG-NTR Bar 5 РК-19-16296
797133 797133 LONDZH BAR BG eat_drink bars_pubs bar_pub normal 5 star 5 40   banquet 0 0 60 0 45   60 0 25.5 BOJ 33.1 0.0 2109 Sveti Vlas Nesebar m. Yurta pod patya, ul.Lyulin № 4, hotel Grand hotel Sveti Vlas 42.7136 27.75867 2029-08-04T21:00:00Z   BG-NTR Bar 5 РК-19-16294
797185 797185 Executive Lounge BG eat_drink bars_pubs bar_pub normal 5 star 5 140   banquet 0 0 70 0 65   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna rayon Triaditsa, bul. Balgariya № 1, hotel Hiltan Sofiya 42.69751 23.32415 2029-07-03T21:00:00Z   BG-NTR Bar 5 РК-19-16223
797187 797187 Regale BG eat_drink bars_pubs bar_pub normal 5 star 5 174   banquet 0 0 80 0 65   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna rayon Triaditsa, bul. Balgariya № 1, hotel Hiltan Sofiya 42.69751 23.32415 2029-07-03T21:00:00Z   BG-NTR Bar 5 РК-19-16221
797189 797189 View Point cafe BG eat_drink bars_pubs bar_pub normal 5 star 5 50   banquet 0 0 60 0 55   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna r-n Vitosha, kv. Boyana, ploshtad Sborishte № 4, hotel-rezidens Ol Siyzans Rezidens 42.69751 23.32415 2029-07-03T21:00:00Z   BG-NTR Bar 5 РК-19-16219
797195 797195 VITAMIN BG eat_drink bars_pubs bar_pub normal 5 star 5 18   banquet 0 0 50 0 45   55 0 52.7 Graf Ignatievo Air Base 16.5 0.0 126 Pavel banya Pavel banya ul. Petko Kolev № 12, Balneo- hotel Atmosfera 42.6 25.2 2029-07-03T21:00:00Z   BG-NTR Bar 5 РК-19-16210
797196 797196   BG eat_drink bars_pubs bar_pub normal 5 star 5 40   banquet 0 0 60 0 45   55 0 52.7 Graf Ignatievo Air Base 16.5 0.0 126 Pavel banya Pavel banya ul. Petko Kolev № 12, Balneo- hotel Atmosfera 42.6 25.2 2029-07-03T21:00:00Z   BG-NTR Bar 5 РК-19-16209
797198 797198   BG eat_drink bars_pubs bar_pub normal 5 star 5 70   banquet 0 0 60 0 55   55 0 52.7 Graf Ignatievo Air Base 16.5 0.0 126 Pavel banya Pavel banya ul. Petko Kolev № 12, Balneo- hotel Atmosfera 42.6 25.2 2029-07-03T21:00:00Z   BG-NTR Bar 5 РК-19-16207
797209 797209 DA UAN EKSLUKZIV/ THE ONE EXCLUSIVE & BEDRUM KLUB/ BEDROOM CLUB BG eat_drink bars_pubs bar_pub normal 5 star 5 650   banquet 0 0 80 0 65   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna rayon Seredets, ul. Ivan Vazov  №12 42.69751 23.32415 2029-07-03T21:00:00Z   BG-NTR Bar 5 РК-19-16193
797211 797211 BAZILIKA BG eat_drink bars_pubs bar_pub normal 5 star 5 90   banquet 0 0 70 0 55   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna pl. Sveta Nedelya № 5, hotel Sofiya balkan palas 42.69751 23.32415 2029-07-03T21:00:00Z   BG-NTR Bar 5 РК-19-16191
797226 797226   BG eat_drink bars_pubs bar_pub normal 5 star 5 48   banquet 0 0 60 0 45   30 0 95.8 SOF 34.4 0.0 907 Bansko Bansko ul. Banski suhodol № 3, apartamenten hotel Regnum Bansko Ski Hotel i SPA 41.8361 23.48745 2029-07-03T21:00:00Z   BG-NTR Bar 5 РК-19-16166
797313 797313   BG eat_drink bars_pubs bar_pub normal 5 star 5 60   banquet 0 0 60 0 55   30 0 95.8 SOF 34.4 0.0 907 Bansko Bansko ul. Karamanitsa № 11, hotel Premier Lakshari Mauntin Rezort 41.8361 23.48745 2029-02-07T22:00:00Z   BG-NTR Bar 5 РК-19-16036
797343 797343   BG eat_drink bars_pubs bar_pub normal 5 star 5 40   banquet 0 0 60 0 45   65 0 77.4 JAM 0.0 0.0 130 Svilengrad Svilengrad ul. Suvorov № 2, SPA-hotel MERIT GRAND MOSTA 41.76836 26.19775 2028-12-12T22:00:00Z   BG-NTR Bar 5 РК-19-15991
797344 797344   BG eat_drink bars_pubs bar_pub normal 5 star 5 150   banquet 0 0 80 0 65   65 0 77.4 JAM 0.0 0.0 130 Svilengrad Svilengrad ul. Suvorov № 2, SPA-hotel MERIT GRAND MOSTA 41.76836 26.19775 2028-12-12T22:00:00Z   BG-NTR Bar 5 РК-19-15990
797345 797345   BG eat_drink bars_pubs bar_pub normal 5 star 5 48   banquet 0 0 60 0 45   65 0 77.4 JAM 0.0 0.0 130 Svilengrad Svilengrad ul. Suvorov № 2, SPA-hotel MERIT GRAND MOSTA 41.76836 26.19775 2028-12-12T22:00:00Z   BG-NTR Bar 5 РК-19-15989
797347 797347 MERIT GRAND MOSTA BG eat_drink bars_pubs bar_pub normal 5 star 5 46   banquet 0 0 60 0 45   65 0 77.4 JAM 0.0 0.0 130 Svilengrad Svilengrad ul. Suvorov № 2, SPA-hotel Merit Grand Mosta 41.76836 26.19775 2028-12-12T22:00:00Z   BG-NTR Bar 5 РК-19-15986
797361 797361 LOBI & SALONEN BAR/ LOBBY & LOUNGE BAR BG eat_drink bars_pubs bar_pub normal 5 star 5 150   banquet 0 0 80 0 65   65 0 66.3 Graf Ignatievo Air Base 0.0 0.0 463 Velingrad Velingrad ul. "D-r Doshkinov" № 14, hotel KAShMIR SPA HOTEL 42.02754 23.99155 2028-12-12T22:00:00Z   BG-NTR Bar 5 РК-19-15966
797521 797521 LAUNDZH BG eat_drink bars_pubs bar_pub normal 5 star 5 24   banquet 0 0 50 0 45   80 0 8.0 BOJ 0.0 0.0 971 Burgas Burgas ul. Knyaz Aleksandar Batenberg № 2, SPA-hotel Primorets 42.50651 27.46886 2028-09-12T21:00:00Z   BG-NTR Bar 5 РК-19-15743
797522 797522   BG eat_drink bars_pubs bar_pub normal 5 star 5 74   banquet 0 0 60 0 55   80 0 8.0 BOJ 0.0 0.0 971 Burgas Burgas ul. Knyaz Aleksandar Batenberg № 2, SPA-hotel Primorets 42.50651 27.46886 2028-09-12T21:00:00Z   BG-NTR Bar 5 РК-19-15742
797602 797602   BG eat_drink bars_pubs bar_pub normal 5 star 5 20   banquet 0 0 50 0 45                 Dyuni Sozopol hotel Marina biych     2028-08-06T21:00:00Z   BG-NTR Bar 5 РК-19-15634
797603 797603   BG eat_drink bars_pubs bar_pub normal 5 star 5 250   banquet 0 0 80 0 65                 Dyuni Sozopol hotel Marina Biych     2028-08-06T21:00:00Z   BG-NTR Bar 5 РК-19-15633
797633 797633 Showtime Bar BG eat_drink bars_pubs bar_pub normal 5 star 5 717   banquet 0 0 80 0 65   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar hotel Alua Sani Biych Rizort end SPA 42.6931 27.7083 2028-08-01T21:00:00Z   BG-NTR Bar 5 РК-19-15587
797634 797634 Half-Time Sports Bar BG eat_drink bars_pubs bar_pub normal 5 star 5 104   banquet 0 0 70 0 65   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar hotel Alua Sani Biych Rizort end SPA 42.6931 27.7083 2028-08-01T21:00:00Z   BG-NTR Bar 5 РК-19-15586
797635 797635 Moments BG eat_drink bars_pubs bar_pub normal 5 star 5 153   banquet 0 0 80 0 65   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar hotel Alua Sani Biych Rizort end SPA 42.6931 27.7083 2028-08-01T21:00:00Z   BG-NTR Bar 5 РК-19-15585

Next page

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