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

207 rows where best_for = "banquet", family = "bars_pubs" and rating_value = 3

This data as json, CSV (advanced)

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

country 2

rating_value 1

group 1

family 1

  • bars_pubs · 207 ✖

best_for 1

  • banquet · 207 ✖

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
46640 46640 NECTAR, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 42   banquet 0 0 50 0 45   80 0 27.5 GHV 9.1 0.5 462 Com. Bran, Sat Şimon BRAŞOV   45.4849579730916 25.3630292693726     RO-SITUR BAR DE ZI 3  
49277 49277 2D, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE 42   banquet 0 0 50 0 45   65 0 56.0 CND 5.7 0.7 734 Mun. Mangalia, Loc. Neptun CONSTANŢA   43.864865 28.6000836     RO-SITUR BAR DE ZI 3 - STELE  
49400 49400 CHARM, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 40   banquet 0 0 50 0 45   65 0 54.1 CND 7.7 1.3 623 Mun. Mangalia, Loc. Olimp CONSTANŢA   43.882775 28.6045115     RO-SITUR BAR DE ZI 3  
49422 49422 PHOENICIA BLUE VIEW - CRAIOVA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE 40   banquet 0 0 50 0 45   65 0 54.4 CND 7.4 0.9 624 Mun. Mangalia, Loc. Olimp CONSTANŢA   43.879601 28.6030636     RO-SITUR BAR DE ZI 3 - STELE  
49534 49534 PALACE HOTEL & RESORT, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 STELE 80   banquet 0 0 60 0 55   65 0 54.6 Balchik Airfield 0.7 0.7 856 Mun. Mangalia, Loc. Venus CONSTANŢA   43.8187033 28.5840794     RO-SITUR BAR DE ZI 3 STELE  
49706 49706 POEM, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 40   banquet 0 0 50 0 45   55 0 35.0 CND 12.9 0.2 1129 Oraş Eforie, Loc. Eforie Nord CONSTANŢA   44.0650395 28.634236     RO-SITUR BAR DE ZI 3  
49875 49875 INFINITY BAR, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE 42   banquet 0 0 50 0 45   80 0 12.6 CND 2.6 0.7 2254 Oraş Năvodari CONSTANŢA   44.314905 28.6327505     RO-SITUR BAR DE ZI 3 - STELE  
51570 51570 BAR BUCUREȘTI, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE 42   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 3 - STELE  
51672 51672 MICHELANGELO, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 40   banquet 0 0 50 0 45   80 10 6.1 BBU 2.2 2.2 2124 Mun. Bucureşti, Sector 1 MUNICIPIUL BUCUREŞTI   44.448565 26.0916985     RO-SITUR BAR DE ZI 3  
52518 52518 AZUGA SKI & BIKE RESORT, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 44   banquet 0 0 50 0 45   70 10 29.6 GHV 18.9 3.0 263 Oraş Azuga PRAHOVA   45.443576 25.5871343     RO-SITUR BAR DE ZI 3  
53063 53063 JAZZY, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE 46   banquet 0 0 50 0 45   80 0 4.8 SBZ 1.0 1.0 708 Mun. Sibiu SIBIU   45.7909432 24.1475061     RO-SITUR BAR DE ZI 3 - STELE  
53098 53098 SILVA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE 40   banquet 0 0 50 0 45   80 0 4.4 SBZ 1.7 1.7 709 Mun. Sibiu SIBIU   45.7850159 24.143502     RO-SITUR BAR DE ZI 3 - STELE  
53499 53499 FOREST, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 40   banquet 0 0 50 0 45   50 10 84.8 BBU 0.8 0.8 20 Mun. Alexandria TELEORMAN   43.976426982262 25.3337313322937     RO-SITUR BAR DE ZI 3  
54092 54092 CĂCIULATA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE 40   banquet 0 0 50 0 45   55 0 65.1 SBZ 14.3 0.8 204 Oraş Călimăneşti VÂLCEA   45.22759 24.3399947     RO-SITUR BAR DE ZI 3 - STELE  
54104 54104 CENTRAL, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE 40   banquet 0 0 50 0 45   55 10 59.7 SBZ 19.7 4.2 173 Oraş Călimăneşti VÂLCEA   45.2726988 24.3125001     RO-SITUR BAR DE ZI 3 - STELE  
796257 796257 19-TA DUPKA BG eat_drink bars_pubs bar_pub normal 3 star 3 90   banquet 0 0 60 0 55   30 0 90.2 SOF 33.7 0.0 237 Razlog Razlog m. Betolovoto - Tsarnako, apartamenten turisticheski kompleks Pirin Golf 41.8863 23.46714 2031-04-19T21:00:00Z   BG-NTR Drink bar 3 РК-19-17563
796321 796321   BG eat_drink bars_pubs bar_pub normal 3 star 3 40   banquet 0 0 50 0 45   55 0 73.3 SOF 12.0 0.0 391 Borovets Samokov hotel Ledeni angeli 42.10566 23.02003 2031-01-25T22:00:00Z   BG-NTR Bar 3 РК-19-17462
796335 796335   BG eat_drink bars_pubs bar_pub normal 3 star 3 41   banquet 0 0 50 0 45   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna r-n Vazrazhdane, ul. Osogovo № 49, hotel Siti Avenyu 42.69751 23.32415 2031-01-25T22:00:00Z   BG-NTR Bar 3 РК-19-17442
796336 796336   BG eat_drink bars_pubs bar_pub normal 3 star 3 48   banquet 0 0 50 0 45   30 0 95.8 SOF 34.4 0.0 907 Bansko Bansko ul. Ikonom Chuchulayn № 74-78, apartamenten hotel Pirin rivar 41.8361 23.48745 2030-12-21T22:00:00Z   BG-NTR Bar 3 РК-19-17438
796352 796352   BG eat_drink bars_pubs bar_pub normal 3 star 3 40   banquet 0 0 50 0 45   30 0 90.2 SOF 33.7 0.0 237 Razlog Razlog ul. Kulinoto № 5, apartamenten hotel Terra 41.8863 23.46714 2030-12-21T22:00:00Z   BG-NTR Bar 3 РК-19-17408
796413 796413   BG eat_drink bars_pubs bar_pub normal 3 star 3 49   banquet 0 0 50 0 45   70 0 18.5 VAR 12.9 0.0 579 Zlatni pyasatsi Varna hotel Bonita 43.285 28.0418 2030-10-16T21:00:00Z   BG-NTR Bar 3 РК-19-17308
796421 796421 EL GARDAN/L GARDEN BG eat_drink bars_pubs bar_pub normal 3 star 3 300   banquet 0 0 70 0 65   80 0 12.7 PDV 0.0 0.0 1591 Plovdiv Plovdiv bul. Ruski № 70, hotel Layptsig 42.15387 24.75001 2030-10-16T21:00:00Z   BG-NTR Bar 3 РК-19-17297
796428 796428   BG eat_drink bars_pubs bar_pub normal 3 star 3 80   banquet 0 0 60 0 55   70 0 9.4 BOJ 14.6 0.0 379 Pomorie Pomorie ul. Chayka № 2, hotel Festa Via Pontika 42.56326 27.62986 2030-10-16T21:00:00Z   BG-NTR Bar 3 РК-19-17285
796429 796429 VINEN BAR BG eat_drink bars_pubs bar_pub normal 3 star 3 80   banquet 0 0 60 0 55   70 0 9.4 BOJ 14.6 0.0 379 Pomorie Pomorie ul. Chayka № 2, hotel Festa Via Pontika 42.56326 27.62986 2030-10-16T21:00:00Z   BG-NTR Bar 3 РК-19-17284
796443 796443   BG eat_drink bars_pubs bar_pub normal 3 star 3 80   banquet 0 0 60 0 55   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar k.k. Slanchev bryag, hotel AZURO 42.6931 27.7083 2030-09-15T21:00:00Z   BG-NTR Bar 3 РК-19-17266
796450 796450 KENTIYA/KENTIA BG eat_drink bars_pubs bar_pub normal 3 star 3 192   banquet 0 0 70 0 65   45 0 40.8 BOJ 40.1 0.0 291 Obzor Nesebar ul. Chernomorska № 44, hotel Aluasan Helios Biych 42.81998 27.88007 2030-09-15T21:00:00Z   BG-NTR Bar 3 РК-19-17257
796459 796459   BG eat_drink bars_pubs bar_pub normal 3 star 3 48   banquet 0 0 50 0 45   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar k.k. Slanchev bryag - Iztok, hotel Regina 42.6931 27.7083 2030-09-15T21:00:00Z   BG-NTR Bar 3 РК-19-17246
796467 796467   BG eat_drink bars_pubs bar_pub normal 3 star 3 90   banquet 0 0 60 0 55   45 0 40.8 BOJ 40.1 0.0 291 Obzor Nesebar k.k. Obzor - sever hotel SANRAYZ OL SUITS RIZORT 42.81998 27.88007 2030-09-15T21:00:00Z   BG-NTR Bar 3 РК-19-17236
796507 796507   BG eat_drink bars_pubs bar_pub normal 3 star 3 40   banquet 0 0 50 0 45                 Sv. sv. Konstantin i Elena Varna hotel Koral     2030-07-31T21:00:00Z   BG-NTR Bar 3 РК-19-17179
796513 796513 LOTOS BG eat_drink bars_pubs bar_pub normal 3 star 3 48   banquet 0 0 50 0 45   70 0 18.5 VAR 12.9 0.0 579 Zlatni pyasatsi Varna v.k. Riviera, hotel Lotos 43.285 28.0418 2030-07-31T21:00:00Z   BG-NTR Bar 3 РК-19-17169
796549 796549   BG eat_drink bars_pubs bar_pub normal 3 star 3 40   banquet 0 0 50 0 45   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar k.k. Slanchev bryag - Zona Iztok, hotel Yavor Palas 42.6931 27.7083 2030-07-31T21:00:00Z   BG-NTR Bar 3 РК-19-17121
796567 796567   BG eat_drink bars_pubs bar_pub normal 3 star 3 40   banquet 0 0 50 0 45   70 0 18.5 VAR 12.9 0.0 579 Zlatni pyasatsi Varna hotel Shipka 43.285 28.0418 2030-06-30T21:00:00Z   BG-NTR Bar 3 РК-19-17094
796571 796571   BG eat_drink bars_pubs bar_pub normal 3 star 3 200   banquet 0 0 70 0 65   70 0 18.5 VAR 12.9 0.0 579 Zlatni pyasatsi Varna hotel Metropol 43.285 28.0418 2030-06-30T21:00:00Z   BG-NTR Bar 3 РК-19-17089
796595 796595   BG eat_drink bars_pubs bar_pub normal 3 star 3 40   banquet 0 0 50 0 45   70 20 9.1 Balchik Airfield 23.0 5.1 202 Albena Balchik hotel Kaliakra Mare 43.38333 28.08333 2030-06-30T21:00:00Z   BG-NTR Bar 3 РК-19-17054
796596 796596 KALIAKRA MARE BG eat_drink bars_pubs bar_pub normal 3 star 3 90   banquet 0 0 60 0 55   70 20 9.1 Balchik Airfield 23.0 5.1 202 Albena Balchik hotel Kaliakra Mare 43.38333 28.08333 2030-06-30T21:00:00Z   BG-NTR Bar 3 РК-19-17053
796611 796611   BG eat_drink bars_pubs bar_pub normal 3 star 3 40   banquet 0 0 50 0 45   60 0 25.5 BOJ 33.1 0.0 2109 Sveti Vlas Nesebar mestnost Kozluka, hotel Sendi Bey 42.7136 27.75867 2030-06-30T21:00:00Z   BG-NTR Bar 3 РК-19-17032
796613 796613 SENDI BEY BG eat_drink bars_pubs bar_pub normal 3 star 3 96   banquet 0 0 60 0 55   60 0 25.5 BOJ 33.1 0.0 2109 Sveti Vlas Nesebar mestnost Kozluka, hotel Sendi Bey 42.7136 27.75867 2030-06-30T21:00:00Z   BG-NTR Bar 3 РК-19-17030
796616 796616 ANIKS BG eat_drink bars_pubs bar_pub normal 3 star 3 42   banquet 0 0 50 0 45   45 0 40.8 BOJ 40.1 0.0 291 Obzor Nesebar ul. Neptun 20, apartamenten hotel Aniksi 42.81998 27.88007 2030-06-30T21:00:00Z   BG-NTR Bar 3 РК-19-17026
796619 796619 GLARUS 2 BG eat_drink bars_pubs bar_pub normal 3 star 3 80   banquet 0 0 60 0 55   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar Zona Iztok, hotel Glarus 42.6931 27.7083 2030-06-30T21:00:00Z   BG-NTR Bar 3 РК-19-17020
796620 796620 GLARUS 1 BG eat_drink bars_pubs bar_pub normal 3 star 3 82   banquet 0 0 60 0 55   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar Zona Iztok, hotel Glarus 42.6931 27.7083 2030-06-30T21:00:00Z   BG-NTR Bar 3 РК-19-17019
796645 796645   BG eat_drink bars_pubs bar_pub normal 3 star 3 40   banquet 0 0 50 0 45   70 0 18.5 VAR 12.9 0.0 579 Zlatni pyasatsi Varna hotel Vistamar 43.285 28.0418 2030-06-30T21:00:00Z   BG-NTR Bar 3 РК-19-16990
796659 796659   BG eat_drink bars_pubs bar_pub normal 3 star 3 40   banquet 0 0 50 0 45   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar hotel Ivana Palas 42.6931 27.7083 2030-06-30T21:00:00Z   BG-NTR Bar 3 РК-19-16971
796679 796679   BG eat_drink bars_pubs bar_pub normal 3 star 3 44   banquet 0 0 50 0 45   70 0 13.5 Balchik Airfield 18.1 0.0 340 Kranevo Balchik ul. Chernomorska № 45, hotel Efekt Algara Biych Rizort 43.34157 28.05759 2030-06-01T21:00:00Z   BG-NTR Bar 3 РК-19-16946
796686 796686   BG eat_drink bars_pubs bar_pub normal 3 star 3 460   banquet 0 0 70 0 65   70 0 18.5 VAR 12.9 0.0 579 Zlatni pyasatsi Varna hotel Klub hotel Bolero 43.285 28.0418 2030-06-01T21:00:00Z   BG-NTR Bar 3 РК-19-16936
796689 796689   BG eat_drink bars_pubs bar_pub normal 3 star 3 40   banquet 0 0 50 0 45   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna ul. Konstantin Stoilov № 53, hotel Via Serdika 42.69751 23.32415 2030-06-01T21:00:00Z   BG-NTR Bar 3 РК-19-16931
796695 796695   BG eat_drink bars_pubs bar_pub normal 3 star 3 40   banquet 0 0 50 0 45   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna ul. Vitoshko lale № 18, hotel Park hotel Boyana 42.69751 23.32415 2030-06-01T21:00:00Z   BG-NTR Bar 3 РК-19-16922
796703 796703 SKY BAR BG eat_drink bars_pubs bar_pub normal 3 star 3 48   banquet 0 0 50 0 45   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna r-n Slatina, ul. Liditse № 1, hotel Evropa 42.69751 23.32415 2030-06-01T21:00:00Z   BG-NTR Bar 3 РК-19-16911
796771 796771   BG eat_drink bars_pubs bar_pub normal 3 star 3 82   banquet 0 0 60 0 55   65 20 47.7 PDV 9.1 8.7 323 Pamporovo Chepelare hotel Orfey 41.65525 24.69352 2030-03-12T22:00:00Z   BG-NTR Bar 3 РК-19-16811
796772 796772 PIANO / PIANO BG eat_drink bars_pubs bar_pub normal 3 star 3 45   banquet 0 0 50 0 45   65 20 47.7 PDV 9.1 8.7 323 Pamporovo Chepelare hotel Orfey 41.65525 24.69352 2030-03-12T22:00:00Z   BG-NTR Bar 3 РК-19-16810
796774 796774 LIOS / LIO'S BG eat_drink bars_pubs bar_pub normal 3 star 3 95   banquet 0 0 60 0 55   65 20 47.7 PDV 9.1 8.7 323 Pamporovo Chepelare hotel Murgavets, prizemen etazh / suteren 41.65525 24.69352 2030-03-12T22:00:00Z   BG-NTR Bar 3 РК-19-16807
796780 796780   BG eat_drink bars_pubs bar_pub normal 3 star 3 48   banquet 0 0 50 0 45   65 20 47.7 PDV 9.1 8.7 323 Pamporovo Smolyan hotel Finlandiya 41.65525 24.69352 2030-03-12T22:00:00Z   BG-NTR Bar 3 РК-19-16801
796812 796812 FOMO BG eat_drink bars_pubs bar_pub normal 3 star 3 300   banquet 0 0 70 0 65   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna r-n Sredets, ul. Tsar Kaloyan № 6, biznes hotel Rila 42.69751 23.32415 2030-02-13T22:00:00Z   BG-NTR Bar 3 РК-19-16749
796819 796819   BG eat_drink bars_pubs bar_pub normal 3 star 3 40   banquet 0 0 50 0 45   30 0 95.8 SOF 34.4 0.0 907 Bansko Bansko ul. Pirin № 7, hotel Rodina 41.8361 23.48745 2030-02-13T22:00:00Z   BG-NTR Bar 3 РК-19-16740
796830 796830 ASKALON BG eat_drink bars_pubs bar_pub normal 3 star 3 40   banquet 0 0 50 0 45   30 0 95.8 SOF 34.4 0.0 907 Bansko Bansko ul. Kosherinata № 5, apartamenten hotel Seynt Dzhordzh Palas 41.8361 23.48745 2030-02-13T22:00:00Z   BG-NTR Bar 3 РК-19-16725
796836 796836   BG eat_drink bars_pubs bar_pub normal 3 star 3 91   banquet 0 0 60 0 55   30 0 95.8 SOF 34.4 0.0 907 Bansko Bansko ul. Georgi Nastev № 11, hotel Lion 41.8361 23.48745 2030-02-13T22:00:00Z   BG-NTR Bar 3 РК-19-16717
796860 796860   BG eat_drink bars_pubs bar_pub normal 3 star 3 40   banquet 0 0 50 0 45   30 0 90.2 SOF 33.7 0.0 237 Razlog Razlog m. Betolovoto, ul. Izvoro № 47, hotel Griyn Uud 41.8863 23.46714 2029-12-30T22:00:00Z   BG-NTR Bar 3 РК-19-16680
796893 796893   BG eat_drink bars_pubs bar_pub normal 3 star 3 48   banquet 0 0 50 0 45   55 10 51.8 SOF 19.4 2.5 190 Ribaritsa Teteven ul. Georgi Benkovski №247, hotel Planinata 42.85 24.01667 2029-12-09T22:00:00Z   BG-NTR Bar 3 РК-19-16628
796924 796924   BG eat_drink bars_pubs bar_pub normal 3 star 3 40   banquet 0 0 50 0 45   65 0 60.1 PDV 0.0 0.0 229 Haskovo Haskovo park Kenana, hotel Park-hotel zelena Evropa 41.93415 25.55557 2029-10-17T21:00:00Z   BG-NTR Bar 3 РК-19-16583
796936 796936 LILIITE BG eat_drink bars_pubs bar_pub normal 3 star 3 44   banquet 0 0 50 0 45   70 0 22.5 BOJ 21.0 0.0 810 Sozopol Sozopol mestnost Arkutino, hotel Arkutino Femili Rezort 42.41801 27.6956 2029-10-17T21:00:00Z   BG-NTR Bar 3 РК-19-16565
796941 796941 SHIPKA BG eat_drink bars_pubs bar_pub normal 3 star 3 40   banquet 0 0 50 0 45   70 0 18.5 VAR 12.9 0.0 579 Zlatni pyasatsi Varna k.k. Zlatni pyasatsi, hotel Shipka 43.285 28.0418 2029-10-17T21:00:00Z   BG-NTR Bar 3 РК-19-16557
796952 796952 FENIKS BG eat_drink bars_pubs bar_pub normal 3 star 3 200   banquet 0 0 70 0 65   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar hotel Feniks 42.6931 27.7083 2029-10-17T21:00:00Z   BG-NTR Drink bar 3 РК-19-16541
796975 796975   BG eat_drink bars_pubs bar_pub normal 3 star 3 41   banquet 0 0 50 0 45   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna r.n Vazrazhdane, ul. Osogovo № 49, hotel Siti Avenyu 42.69751 23.32415 2029-09-18T21:00:00Z   BG-NTR Bar 3 РК-19-16508
796987 796987 ROYAL GRAND BG eat_drink bars_pubs bar_pub normal 3 star 3 48   banquet 0 0 50 0 45   60 0 12.8 Balchik Airfield 42.3 0.0 207 Kavarna Kavarna ul. Chernomorska № 68-107, hotel Royal Grand Hotel end SPA 43.43601 28.33953 2029-09-18T21:00:00Z   BG-NTR Bar 3 РК-19-16487
797008 797008 Lobby bar N BG eat_drink bars_pubs bar_pub normal 3 star 3 95   banquet 0 0 60 0 55   70 0 9.4 BOJ 14.6 0.0 379 Pomorie Pomorie ul. Aleko Konstantinov № 1, hotel Paradays 42.56326 27.62986 2029-09-18T21:00:00Z   BG-NTR Bar 3 РК-19-16457
797012 797012 SAUT BIYCH BG eat_drink bars_pubs bar_pub normal 3 star 3 46   banquet 0 0 50 0 45   45 0 52.1 BOJ 48.6 0.0 218 Tsarevo Tsarevo mestnost Nestinarka, apartamenten hotel Saut Biych 42.16955 27.84541 2029-09-18T21:00:00Z   BG-NTR Bar 3 РК-19-16452
797033 797033 KAZINO BG eat_drink bars_pubs bar_pub normal 3 star 3 40   banquet 0 0 50 0 45   80 0 7.0 VAR 0.0 0.0 1513 Varna Varna kv. Odesos, bul.Slivnitsa № 33, hotel Cherno more 43.21912 27.91024 2029-08-28T21:00:00Z   BG-NTR Bar 3 РК-19-16422
797093 797093 PUB BG eat_drink bars_pubs bar_pub normal 3 star 3 95   banquet 0 0 60 0 55   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar hotel Grand Hotel Sani Biych 42.6931 27.7083 2029-08-28T21:00:00Z   BG-NTR Drink bar 3 РК-19-16345
797095 797095   BG eat_drink bars_pubs bar_pub normal 3 star 3 40   banquet 0 0 50 0 45   70 0 22.5 BOJ 21.0 0.0 810 Sozopol Sozopol ul. Yani Popov № 5, hotel Vila List 42.41801 27.6956 2029-08-28T21:00:00Z   BG-NTR Bar 3 РК-19-16343
797153 797153   BG eat_drink bars_pubs bar_pub normal 3 star 3 46   banquet 0 0 50 0 45   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar hotel Astoriya 42.6931 27.7083 2029-08-04T21:00:00Z   BG-NTR Bar 3 РК-19-16264
797156 797156 BG eat_drink bars_pubs bar_pub normal 3 star 3 44   banquet 0 0 50 0 45   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar hotel Arda 42.6931 27.7083 2029-08-04T21:00:00Z   BG-NTR Bar 3 РК-19-16260
797174 797174   BG eat_drink bars_pubs bar_pub normal 3 star 3 80   banquet 0 0 60 0 55   70 0 18.5 VAR 12.9 0.0 579 Zlatni pyasatsi Varna hotel ELPIDA BIYCh 43.285 28.0418 2029-07-03T21:00:00Z   BG-NTR Bar 3 РК-19-16238
797178 797178   BG eat_drink bars_pubs bar_pub normal 3 star 3 90   banquet 0 0 60 0 55   70 0 18.5 VAR 12.9 0.0 579 Zlatni pyasatsi Varna k.k. Zlatni pyasatsi №484, hotel Park Hotel Odesos 43.285 28.0418 2029-07-03T21:00:00Z   BG-NTR Bar 3 РК-19-16233
797228 797228   BG eat_drink bars_pubs bar_pub normal 3 star 3 47   banquet 0 0 50 0 45   45 30 54.5 Feteşti Borcea Air Base 39.7 12.4 53 Ognyanovo Garmen ul. Kanina № 8, hotel Terma Vita - Profilaktorium Ognyanovo 43.90471 27.66024 2029-07-03T21:00:00Z   BG-NTR Bar 3 РК-19-16162
797237 797237   BG eat_drink bars_pubs bar_pub normal 3 star 3 42   banquet 0 0 50 0 45   65 20 47.7 PDV 9.1 8.7 323 Pamporovo Chepelare hotel Harmoniya 41.65525 24.69352 2029-03-21T22:00:00Z   BG-NTR Bar 3 РК-19-16150
797256 797256 AKVA BG eat_drink bars_pubs bar_pub normal 3 star 3 45   banquet 0 0 50 0 45   30 0 95.8 SOF 34.4 0.0 907 Bansko Bansko ul. Pere Toshev № 2, apartamenten hotel Vihren Royal Palas 41.8361 23.48745 2029-03-21T22:00:00Z   BG-NTR Bar 3 РК-19-16126
797265 797265 R Garden and bar BG eat_drink bars_pubs bar_pub normal 3 star 3 40   banquet 0 0 50 0 45   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna ul. Solunska № 30, hotel Roslin Trakiya 42.69751 23.32415 2029-03-21T22:00:00Z   BG-NTR Bar 3 РК-19-16108
797271 797271   BG eat_drink bars_pubs bar_pub normal 3 star 3 48   banquet 0 0 50 0 45   70 0 23.3 Graf Ignatievo Air Base 16.9 0.0 422 Hisarya Hisarya ul. Beli brezi № 1, SPA-hotel Sana SPA Hotel 42.5 24.7 2029-03-21T22:00:00Z   BG-NTR Bar 3 РК-19-16098
797297 797297   BG eat_drink bars_pubs bar_pub normal 3 star 3 40   banquet 0 0 50 0 45   30 0 90.2 SOF 33.7 0.0 237 Razlog Razlog m. Betolovoto, ul. Izvoro №47, hotel RAMADA HOTEL I APARTAMENTI BAY UAYNDHEM RAZLOG GRIYN UUD 41.8863 23.46714 2029-03-21T22:00:00Z   BG-NTR Bar 3 РК-19-16060
797302 797302 ICEBERG BG eat_drink bars_pubs bar_pub normal 3 star 3 150   banquet 0 0 70 0 65   55 0 73.3 SOF 12.0 0.0 391 Borovets Samokov hotel Aysberg 42.10566 23.02003 2029-03-21T22:00:00Z   BG-NTR Bar 3 РК-19-16052
797320 797320   BG eat_drink bars_pubs bar_pub normal 3 star 3 95   banquet 0 0 60 0 55   55 0 73.3 SOF 12.0 0.0 391 Borovets Samokov ul. k.k. Borovets № 170, hotel Yastrebets SPA 42.10566 23.02003 2029-02-07T22:00:00Z   BG-NTR Bar 3 РК-19-16025
797327 797327   BG eat_drink bars_pubs bar_pub normal 3 star 3 48   banquet 0 0 50 0 45   65 20 47.7 PDV 9.1 8.7 323 Pamporovo Chepelare apartamenten hotel Kameliya 41.65525 24.69352 2029-02-07T22:00:00Z   BG-NTR Bar 3 РК-19-16015
797330 797330   BG eat_drink bars_pubs bar_pub normal 3 star 3 80   banquet 0 0 60 0 55   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna kv. Vitosha, ul. Okolovrasten pat № 72, SPA hotel Tsarsko selo 42.69751 23.32415 2028-12-12T22:00:00Z   BG-NTR Bar 3 РК-19-16009
797358 797358   BG eat_drink bars_pubs bar_pub normal 3 star 3 42   banquet 0 0 50 0 45   55 0 56.3 SOF 14.0 0.0 108 Varshets Varshets ul. Republika № 87, hotel SPA hotel Medikus 43.19356 23.2868 2028-12-12T22:00:00Z   BG-NTR Bar 3 РК-19-15971
797396 797396   BG eat_drink bars_pubs bar_pub normal 3 star 3 80   banquet 0 0 60 0 55   70 0 18.5 VAR 12.9 0.0 579 Zlatni pyasatsi Varna hotel VEMARA BIYCh 43.285 28.0418 2028-10-22T21:00:00Z   BG-NTR Bar 3 РК-19-15918
797400 797400   BG eat_drink bars_pubs bar_pub normal 3 star 3 48   banquet 0 0 50 0 45   70 0 13.5 Balchik Airfield 18.1 0.0 340 Kranevo Balchik ul. Cherno more № 25 , hotel Kristel park 43.34157 28.05759 2028-10-22T21:00:00Z   BG-NTR Bar 3 РК-19-15913
797431 797431   BG eat_drink bars_pubs bar_pub normal 3 star 3 40   banquet 0 0 50 0 45   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar hotel Ivana Palas 42.6931 27.7083 2028-10-22T21:00:00Z   BG-NTR Bar 3 РК-19-15871
797443 797443   BG eat_drink bars_pubs bar_pub normal 3 star 3 40   banquet 0 0 50 0 45   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna zh.k. Mladost- 4, bul. Aleksandar Malinov № 79 G, hotel Grami 42.69751 23.32415 2028-10-22T21:00:00Z   BG-NTR Bar 3 РК-19-15852
797457 797457 BERLIN GOLDAN BIYCH BG eat_drink bars_pubs bar_pub normal 3 star 3 170   banquet 0 0 70 0 65   70 0 18.5 VAR 12.9 0.0 579 Zlatni pyasatsi Varna hotel Berlin Goldan Biych 43.285 28.0418 2028-10-22T21:00:00Z   BG-NTR Bar 3 РК-19-15829
797489 797489 AKVA AZUR BG eat_drink bars_pubs bar_pub normal 3 star 3 80   banquet 0 0 60 0 55                 Sv. sv. Konstantin i Elena Varna r-n Primorski, hotel Akva Azur     2028-09-12T21:00:00Z   BG-NTR Bar 3 РК-19-15783
797495 797495 BORYANA BG eat_drink bars_pubs bar_pub normal 3 star 3 46   banquet 0 0 50 0 45   70 20 9.1 Balchik Airfield 23.0 5.1 202 Albena Balchik hotel Boryana 43.38333 28.08333 2028-09-12T21:00:00Z   BG-NTR Drink bar 3 РК-19-15775
797505 797505   BG eat_drink bars_pubs bar_pub normal 3 star 3 80   banquet 0 0 60 0 55   70 0 18.5 VAR 12.9 0.0 579 Zlatni pyasatsi Varna rayon Primorski, hotel ROYaL 43.285 28.0418 2028-09-12T21:00:00Z   BG-NTR Bar 3 РК-19-15763
797537 797537 VIKTORIYA BG eat_drink bars_pubs bar_pub normal 3 star 3 80   banquet 0 0 60 0 55   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar hotel Grand Viktoriya 42.6931 27.7083 2028-09-12T21:00:00Z   BG-NTR Bar 3 РК-19-15720
797559 797559   BG eat_drink bars_pubs bar_pub normal 3 star 3 600   banquet 0 0 70 0 65   45 0 40.8 BOJ 40.1 0.0 291 Obzor Nesebar ul. Kraybrezhna № 7, hotel Miramar 42.81998 27.88007 2028-09-12T21:00:00Z   BG-NTR Bar 3 РК-19-15692
797581 797581 PRESTIZH DELUKS BG eat_drink bars_pubs bar_pub normal 3 star 3 98   banquet 0 0 60 0 55   70 0 18.5 VAR 12.9 0.0 579 Zlatni pyasatsi Varna hotel PRESTIZh DELUKS AKVAPARK KLUB 43.285 28.0418 2028-09-12T21:00:00Z   BG-NTR Bar 3 РК-19-15661
797598 797598   BG eat_drink bars_pubs bar_pub normal 3 star 3 80   banquet 0 0 60 0 55   70 0 22.5 BOJ 21.0 0.0 810 Sozopol Sozopol plazh Zlatna ribka, hotel Blu Orindzh 42.41801 27.6956 2028-08-06T21:00:00Z   BG-NTR Bar 3 РК-19-15640
797609 797609   BG eat_drink bars_pubs bar_pub normal 3 star 3 45   banquet 0 0 50 0 45   70 0 22.5 BOJ 21.0 0.0 810 Sozopol Sozopol mestnost Gereni, apartamenten turisticheski kompleks HASIENDA BIYCh 42.41801 27.6956 2028-08-06T21:00:00Z   BG-NTR Bar 3 РК-19-15625
797618 797618   BG eat_drink bars_pubs bar_pub normal 3 star 3 80   banquet 0 0 60 0 55   45 30 34.3 BOJ 41.2 10.4 32 Emona Nesebar v.s. Elenite, hotel ANDALUSIYa 42.71446 27.88538 2028-08-01T21:00:00Z   BG-NTR Bar 3 РК-19-15609
797646 797646 AZURO BG eat_drink bars_pubs bar_pub normal 3 star 3 40   banquet 0 0 50 0 45   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar hotel Azuro 42.6931 27.7083 2028-08-01T21:00:00Z   BG-NTR Bar 3 РК-19-15571
797648 797648 AZURO BG eat_drink bars_pubs bar_pub normal 3 star 3 80   banquet 0 0 60 0 55   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar hotel Azuro 42.6931 27.7083 2028-08-01T21:00:00Z   BG-NTR Bar 3 РК-19-15569
797677 797677 SIRIUS BIYCH BG eat_drink bars_pubs bar_pub normal 3 star 3 44   banquet 0 0 50 0 45                 Sv. sv. Konstantin i Elena Varna № 10a , hotel Sirius Biych     2028-08-01T21:00:00Z   BG-NTR Bar 3 РК-19-15528

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