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

1,340 rows where country = "BG", family = "bars_pubs" and rating_value = 2

This data as json, CSV (advanced)

Suggested facets: fit_banquet, fit_party, reachability_score, isolation_score, nearest_airport, source_type, valid_until (date), stop_date (date)

best_for 2

rating_value 1

  • 2 · 1,340 ✖

group 1

family 1

  • bars_pubs · 1,340 ✖

country 1

  • BG · 1,340 ✖

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
796120 796120 SOKAY BG eat_drink bars_pubs bar_pub normal 2 star 2 24     0 0 40 0 45   55 10 32.6 GOZ 18.9 4.5 203 Bardeni Tryavna s. Bardeni 42.88333 25.55 2029-09-20T09:00:00Z   BG-NTR Bar 2 СДУР-247
796122 796122 LOBI BAR PARK HOTEL PANORAMA BG eat_drink bars_pubs bar_pub normal 2 star 2 22     0 0 40 0 45   55 0 36.1 GOZ 14.8 0.0 222 Tryavna Tryavna ul. "Panorama" № 6 42.86667 25.5 2024-11-16T10:00:00Z   BG-NTR Bar 2 СДУР-217
796123 796123 "LOBI BAR PLAVIS" BG eat_drink bars_pubs bar_pub normal 2 star 2 24     0 0 40 0 45   55 0 36.1 GOZ 14.8 0.0 222 Tryavna Tryavna ul. "Lyaskov dyal" №1 a 42.86667 25.5 2029-09-10T09:00:00Z   BG-NTR Bar 2 СДУР-171
796126 796126 KONGRESEN TSENTAR BG eat_drink bars_pubs bar_pub normal 2 star 2 30     0 0 40 0 45   45 0 44.4 VAR 38.1 0.0 386 Kiten Primorsko hotelski kompleks "KOOP-Kiten" 43.08333 27.31667 2026-07-29T09:00:00Z   BG-NTR Bar 2 РКК-19-7981
796283 796283   BG eat_drink bars_pubs bar_pub normal 2 star 2 46   banquet 0 0 50 0 45   65 0 66.3 Graf Ignatievo Air Base 0.0 0.0 463 Velingrad Velingrad ul. Yohan Sebastiyan Bah № 6, balneohotel Velingrad 42.02754 23.99155 2031-03-22T22:00:00Z   BG-NTR Bar 2 РК-19-17523
796289 796289   BG eat_drink bars_pubs bar_pub normal 2 star 2 20     0 0 40 0 45   55 30 54.0 PDV 15.8 15.8 21 Mogilovo Chirpan ul. Krayna № 1, hotel Midalidare hotel end SPA 42.33333 25.4 2031-03-10T22:00:00Z   BG-NTR Drink bar 2 РК-19-17514
796344 796344 ALPINIST BG eat_drink bars_pubs bar_pub normal 2 star 2 60   party 0 0 50 0 55   55 30 49.9 SOF 11.6 11.6 136 Govedartsi Samokov k.k. Malyovitsa, hotel Alpinist 42.25 23.48333 2030-12-21T22:00:00Z   BG-NTR Bar 2 РК-19-17427
796366 796366 RUZH BG eat_drink bars_pubs bar_pub normal 2 star 2 70   party 0 0 50 0 55   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna ul. Mimi Balkanska № 132, hotel Ibis Sofiya Letishte 42.69751 23.32415 2030-11-23T22:00:00Z   BG-NTR Bar 2 РК-19-17388
796381 796381   BG eat_drink bars_pubs bar_pub normal 2 star 2 16     0 0 40 0 45   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna zh.k.Dianabad, ul. Konstantin Poprusinov № 1, hotel Sitihoum 42.69751 23.32415 2030-11-23T22:00:00Z   BG-NTR Bar 2 РК-19-17360
796424 796424   BG eat_drink bars_pubs bar_pub normal 2 star 2 46   banquet 0 0 50 0 45   70 0 18.5 VAR 12.9 0.0 579 Zlatni pyasatsi Varna rayon Primorski, UPI - III 235, kv. 38, hotel Riva 43.285 28.0418 2030-10-16T21:00:00Z   BG-NTR Bar 2 РК-19-17291
796439 796439   BG eat_drink bars_pubs bar_pub normal 2 star 2 35     0 0 40 0 45   80 0 7.0 VAR 0.0 0.0 1513 Varna Varna k.k. Zlatni pyasatsi, hotel Strandzha 43.21912 27.91024 2030-10-16T21:00:00Z   BG-NTR Bar 2 РК-19-17272
796468 796468   BG eat_drink bars_pubs bar_pub normal 2 star 2 40   banquet 0 0 50 0 45   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar k.k. Slanchev bryag hotel Iskar 42.6931 27.7083 2030-09-15T21:00:00Z   BG-NTR Bar 2 РК-19-17234
796551 796551   BG eat_drink bars_pubs bar_pub normal 2 star 2 20     0 0 40 0 45   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar kv. Kameliya, hotel Kokiche 42.6931 27.7083 2030-07-31T21:00:00Z   BG-NTR Bar 2 РК-19-17118
796588 796588   BG eat_drink bars_pubs bar_pub normal 2 star 2 50   party 0 0 50 0 55   70 20 9.1 Balchik Airfield 23.0 5.1 202 Albena Balchik hotel Kaliopa 43.38333 28.08333 2030-06-30T21:00:00Z   BG-NTR Bar 2 РК-19-17063
796633 796633 BAMBINI BG eat_drink bars_pubs bar_pub normal 2 star 2 65   party 0 0 50 0 55   60 0 1.9 Balchik Airfield 30.2 0.0 459 Balchik Balchik ul. Primorska № 8, apartamenten hotel Marina siti 43.42166 28.15848 2030-06-30T21:00:00Z   BG-NTR Bar 2 РК-19-17003
796642 796642 HARD BALLS BG eat_drink bars_pubs bar_pub normal 2 star 2 80   banquet 0 0 60 0 55   60 0 1.9 Balchik Airfield 30.2 0.0 459 Balchik Balchik ul. Primorska № 8, apartamenten hotel Marina Siti 43.42166 28.15848 2030-06-30T21:00:00Z   BG-NTR Bar 2 РК-19-16993
796650 796650   BG eat_drink bars_pubs bar_pub normal 2 star 2 20     0 0 40 0 45   60 0 1.9 Balchik Airfield 30.2 0.0 459 Balchik Balchik Kurortna zona, ul. Akademik Daki Yordanov № 20, hotel Naslada 43.42166 28.15848 2030-06-30T21:00:00Z   BG-NTR Bar 2 РК-19-16983
796704 796704 SLAVYANSKA BESEDA BG eat_drink bars_pubs bar_pub normal 2 star 2 19     0 0 40 0 45   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna rayon Sredets, ul. Slavyanska № 3, hotel Slavyanska beseda 42.69751 23.32415 2030-06-01T21:00:00Z   BG-NTR Bar 2 РК-19-16910
796748 796748   BG eat_drink bars_pubs bar_pub normal 2 star 2 34     0 0 40 0 45   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna r-n Triaditsa, ul. Neofit Rilski № 16, hotel Niki 42.69751 23.32415 2030-04-15T21:00:00Z   BG-NTR Bar 2 РК-19-16845
796758 796758   BG eat_drink bars_pubs bar_pub normal 2 star 2 18     0 0 40 0 45   30 0 95.8 SOF 34.4 0.0 907 Bansko Bansko ul. Strazhite № 15, apartamenten hotel Edelvays Inn / EDELWEISS INN 41.8361 23.48745 2030-03-12T22:00:00Z   BG-NTR Bar 2 РК-19-16831
796769 796769 PANORAMA BG eat_drink bars_pubs bar_pub normal 2 star 2 50   party 0 0 50 0 55   65 0 41.4 SOF 0.0 0.0 155 Samokov Samokov bul. Iskar № 4B, hotel Arena 42.33855 23.55805 2030-03-12T22:00:00Z   BG-NTR Bar 2 РК-19-16814
796789 796789 MELODI BG eat_drink bars_pubs bar_pub normal 2 star 2 100   party 0 0 60 0 65   65 0 32.3 Balchik Airfield 0.0 0.0 355 Dobrich Dobrich pl. Svoboda № 8, hotel Balgariya 43.56491 27.83138 2030-03-12T22:00:00Z   BG-NTR Bar 2 РК-19-16789
796831 796831   BG eat_drink bars_pubs bar_pub normal 2 star 2 32     0 0 40 0 45   30 0 95.8 SOF 34.4 0.0 907 Bansko Bansko kv. Gramadeto, ul. Donchovi karauli № 3, apartamenten hotel 7 Puls spa end apartments 41.8361 23.48745 2030-02-13T22:00:00Z   BG-NTR Bar 2 РК-19-16723
796832 796832 7 PULS BG eat_drink bars_pubs bar_pub normal 2 star 2 10     0 0 40 0 45   30 0 95.8 SOF 34.4 0.0 907 Bansko Bansko kv. Gramadeto, ul. Donchovi karauli № 3, apartamenten hotel 7 Puls spa end apartments 41.8361 23.48745 2030-02-13T22:00:00Z   BG-NTR Bar 2 РК-19-16722
796858 796858 FRENDS BG eat_drink bars_pubs bar_pub normal 2 star 2 20     0 0 40 0 45   30 0 95.8 SOF 34.4 0.0 907 Bansko Bansko ul. Rayna Knyaginya №2, hotel Frends 41.8361 23.48745 2029-12-30T22:00:00Z   BG-NTR Bar 2 РК-19-16683
796880 796880   BG eat_drink bars_pubs bar_pub normal 2 star 2 50   party 0 0 50 0 55   65 0 33.3 SOF 0.0 0.0 146 Pernik Pernik ul. Sv. Sv. Kiril i Metodiy № 23, hotel Elit 42.59671 23.03318 2029-12-09T22:00:00Z   BG-NTR Bar 2 РК-19-16653
796882 796882 EFBET BG eat_drink bars_pubs bar_pub normal 2 star 2 45   banquet 0 0 50 0 45   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna bul. Cherni vrah № 31, hotel Hemus 42.69751 23.32415 2029-12-09T22:00:00Z   BG-NTR Bar 2 РК-19-16647
796905 796905 Cafe Aperitif MATINEE BG eat_drink bars_pubs bar_pub normal 2 star 2 20     0 0 40 0 45   80 0 7.0 VAR 0.0 0.0 1513 Varna Varna r-n Odesos, ul. ”Doktor Lyudvig Zamenhof” № 40, hotel Bizar Hotel 43.21912 27.91024 2029-12-09T22:00:00Z   BG-NTR Drink bar 2 РК-19-16610
796967 796967   BG eat_drink bars_pubs bar_pub normal 2 star 2 20     0 0 40 0 45   65 0 41.4 SOF 0.0 0.0 155 Samokov Samokov bul. Iskar № 4B, hotel Arena 42.33855 23.55805 2029-10-17T21:00:00Z   BG-NTR Bar 2 РК-19-16521
796982 796982   BG eat_drink bars_pubs bar_pub normal 2 star 2 30     0 0 40 0 45   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna kv. Lozenets, ul. Krum Popov № 84, hotel MEG-Lozenets 42.69751 23.32415 2029-09-18T21:00:00Z   BG-NTR Bar 2 РК-19-16494
796983 796983   BG eat_drink bars_pubs bar_pub normal 2 star 2 46   banquet 0 0 50 0 45   70 20 9.1 Balchik Airfield 23.0 5.1 202 Albena Balchik hotel Elitsa 43.38333 28.08333 2029-09-18T21:00:00Z   BG-NTR Bar 2 РК-19-16492
797011 797011   BG eat_drink bars_pubs bar_pub normal 2 star 2 50   party 0 0 50 0 55   80 0 8.0 BOJ 0.0 0.0 971 Burgas Burgas zh.k. P. R. Slaveykov № 184, hotel Mikado 42.50651 27.46886 2029-09-18T21:00:00Z   BG-NTR Drink bar 2 РК-19-16454
797048 797048   BG eat_drink bars_pubs bar_pub normal 2 star 2 48   banquet 0 0 50 0 45   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar hotel Yunona 42.6931 27.7083 2029-08-28T21:00:00Z   BG-NTR Bar 2 РК-19-16403
797107 797107   BG eat_drink bars_pubs bar_pub normal 2 star 2 5     0 0 40 0 45   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar kv. Pyasatsite, hotel Bohemi 42.6931 27.7083 2029-08-28T21:00:00Z   BG-NTR Bar 2 РК-19-16328
797140 797140   BG eat_drink bars_pubs bar_pub normal 2 star 2 30     0 0 40 0 45   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar hotel Trakiya 42.6931 27.7083 2029-08-04T21:00:00Z   BG-NTR Bar 2 РК-19-16283
797177 797177   BG eat_drink bars_pubs bar_pub normal 2 star 2 50   party 0 0 50 0 55   70 0 18.5 VAR 12.9 0.0 579 Zlatni pyasatsi Varna hotel Karnival 43.285 28.0418 2029-07-03T21:00:00Z   BG-NTR Bar 2 РК-19-16234
797213 797213   BG eat_drink bars_pubs bar_pub normal 2 star 2 50   party 0 0 50 0 55   50 0 88.1 CRA 0.0 0.0 144 Vidin Vidin ul. Edelvays № 3, hotel Dunav 43.99159 22.88236 2029-07-03T21:00:00Z   BG-NTR Bar 2 РК-19-16189
797222 797222 NORIS BG eat_drink bars_pubs bar_pub normal 2 star 2 250   banquet 0 0 70 0 65   80 0 12.7 PDV 0.0 0.0 1591 Plovdiv Plovdiv ul. Ilarion Makariopolski № 27, hotel Noris 42.15387 24.75001 2029-07-03T21:00:00Z   BG-NTR Bar 2 РК-19-16173
797235 797235   BG eat_drink bars_pubs bar_pub normal 2 star 2 20     0 0 40 0 45   65 20 47.7 PDV 9.1 8.7 323 Pamporovo Chepelare hotel PANORAMA SKI 41.65525 24.69352 2029-03-21T22:00:00Z   BG-NTR Bar 2 РК-19-16153
797276 797276   BG eat_drink bars_pubs bar_pub normal 2 star 2 20     0 0 40 0 45   80 0 12.7 PDV 0.0 0.0 1591 Plovdiv Plovdiv bul.Balgariya № 125A, apartamenten hotel Plaza 42.15387 24.75001 2029-03-21T22:00:00Z   BG-NTR Bar 2 РК-19-16091
797290 797290   BG eat_drink bars_pubs bar_pub normal 2 star 2 30     0 0 40 0 45   30 0 95.8 SOF 34.4 0.0 907 Bansko Bansko ul. Glazne № 39, hotel Mura 41.8361 23.48745 2029-03-21T22:00:00Z   BG-NTR Bar 2 РК-19-16070
797386 797386 EPITSENTAR BG eat_drink bars_pubs bar_pub normal 2 star 2 300   banquet 0 0 70 0 65   65 0 33.3 SOF 0.0 0.0 146 Pernik Pernik pl. Krakra Pernishki № 1, hotel Struma 42.59671 23.03318 2028-10-22T21:00:00Z   BG-NTR Bar 2 РК-19-15930
797404 797404 PERUNIKA BG eat_drink bars_pubs bar_pub normal 2 star 2 50   party 0 0 50 0 55   70 0 18.5 VAR 12.9 0.0 579 Zlatni pyasatsi Varna hotel Perunika 43.285 28.0418 2028-10-22T21:00:00Z   BG-NTR Bar 2 РК-19-15907
797407 797407   BG eat_drink bars_pubs bar_pub normal 2 star 2 48   banquet 0 0 50 0 45   70 0 18.5 VAR 12.9 0.0 579 Zlatni pyasatsi Varna hotel Park-Hotel Tintyava 43.285 28.0418 2028-10-22T21:00:00Z   BG-NTR Bar 2 РК-19-15903
797409 797409 NEXT CLUB BG eat_drink bars_pubs bar_pub normal 2 star 2 100   party 0 0 60 0 65   70 0 18.5 VAR 12.9 0.0 579 Zlatni pyasatsi Varna hotel Perunika 43.285 28.0418 2028-10-22T21:00:00Z   BG-NTR Bar 2 РК-19-15900
797412 797412   BG eat_drink bars_pubs bar_pub normal 2 star 2 20     0 0 40 0 45   70 0 18.5 VAR 12.9 0.0 579 Zlatni pyasatsi Varna spirka Pisatel, hotel Rusalka 43.285 28.0418 2028-10-22T21:00:00Z   BG-NTR Bar 2 РК-19-15896
797429 797429   BG eat_drink bars_pubs bar_pub normal 2 star 2 40   banquet 0 0 50 0 45   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar hotel Iskar 42.6931 27.7083 2028-10-22T21:00:00Z   BG-NTR Bar 2 РК-19-15873
797440 797440   BG eat_drink bars_pubs bar_pub normal 2 star 2 12     0 0 40 0 45   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna ul. Budapeshta № 92A, hotel Budapeshta 42.69751 23.32415 2028-10-22T21:00:00Z   BG-NTR Bar 2 РК-19-15859
797447 797447 Rock bar 158 BG eat_drink bars_pubs bar_pub normal 2 star 2 100   party 0 0 60 0 65   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna ul. Knyaz Boris I № 158, hotel Art hotel 158 42.69751 23.32415 2028-10-22T21:00:00Z   BG-NTR Bar 2 РК-19-15846
797448 797448   BG eat_drink bars_pubs bar_pub normal 2 star 2 48   banquet 0 0 50 0 45   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna ul. Knyaz Boris I № 158, hotel Art hotel 158 42.69751 23.32415 2028-10-22T21:00:00Z   BG-NTR Bar 2 РК-19-15845
797455 797455 SANI DEY KLUB BG eat_drink bars_pubs bar_pub normal 2 star 2 20     0 0 40 0 45   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar kv. Chayka, hotel Sani Dey Klub 42.6931 27.7083 2028-10-22T21:00:00Z   BG-NTR Bar 2 РК-19-15832
797467 797467   BG eat_drink bars_pubs bar_pub normal 2 star 2 20     0 0 40 0 45   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar hotel Tiya Mariya 42.6931 27.7083 2028-10-22T21:00:00Z   BG-NTR Bar 2 РК-19-15817
797494 797494 BORYANA BG eat_drink bars_pubs bar_pub normal 2 star 2 100   party 0 0 60 0 65   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 Bar 2 РК-19-15776
797535 797535   BG eat_drink bars_pubs bar_pub normal 2 star 2 50   party 0 0 50 0 55   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar hotel Slavyanski 42.6931 27.7083 2028-09-12T21:00:00Z   BG-NTR Bar 2 РК-19-15722
797536 797536 SLAVYANSKI BG eat_drink bars_pubs bar_pub normal 2 star 2 50   party 0 0 50 0 55   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar hotel Slavyanski 42.6931 27.7083 2028-09-12T21:00:00Z   BG-NTR Bar 2 РК-19-15721
797541 797541   BG eat_drink bars_pubs bar_pub normal 2 star 2 150   banquet 0 0 70 0 65   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar ul. Kraybrezhna № 1, hotel Zefir 42.6931 27.7083 2028-09-12T21:00:00Z   BG-NTR Bar 2 РК-19-15715
797564 797564   BG eat_drink bars_pubs bar_pub normal 2 star 2 20     0 0 40 0 45   45 0 39.0 BOJ 35.5 0.0 587 Primorsko Primorsko ul. Opalchenska № 2, hotel Tishina Rezidens 42.26791 27.75611 2028-09-12T21:00:00Z   BG-NTR Bar 2 РК-19-15684
797651 797651   BG eat_drink bars_pubs bar_pub normal 2 star 2 45   banquet 0 0 50 0 45   45 0 40.8 BOJ 40.1 0.0 291 Obzor Nesebar ul. Chernomorska № 16, hotel Parayzo Biych 42.81998 27.88007 2028-08-01T21:00:00Z   BG-NTR Bar 2 РК-19-15565
797666 797666   BG eat_drink bars_pubs bar_pub normal 2 star 2 12     0 0 40 0 45   70 0 18.5 VAR 12.9 0.0 579 Zlatni pyasatsi Varna hotel Serdika 43.285 28.0418 2028-08-01T21:00:00Z   BG-NTR Bar 2 РК-19-15544
797715 797715   BG eat_drink bars_pubs bar_pub normal 2 star 2 20     0 0 40 0 45   60 0 25.5 BOJ 33.1 0.0 2109 Sveti Vlas Nesebar ul. Rusalka № 8, hotel Aleksandra 42.7136 27.75867 2028-06-21T21:00:00Z   BG-NTR Bar 2 РК-19-15479
797772 797772   BG eat_drink bars_pubs bar_pub normal 2 star 2 20     0 0 40 0 45   30 0 95.8 SOF 34.4 0.0 907 Bansko Bansko ul. Nayden Gerov 15, hotel DUMANOV 41.8361 23.48745 2028-04-10T21:00:00Z   BG-NTR Bar 2 РК-19-15400
797777 797777   BG eat_drink bars_pubs bar_pub normal 2 star 2 28     0 0 40 0 45   65 0 66.3 Graf Ignatievo Air Base 0.0 0.0 463 Velingrad Velingrad ul. Tsar Ivan Asen II № 25, hotel Aura 42.02754 23.99155 2028-04-10T21:00:00Z   BG-NTR Bar 2 РК-19-15393
797803 797803 ORLOVETS - VITAMIN BAR BG eat_drink bars_pubs bar_pub normal 2 star 2 20     0 0 40 0 45   65 20 47.7 PDV 9.1 8.7 323 Pamporovo Chepelare hotel Orlovets 41.65525 24.69352 2028-03-13T22:00:00Z   BG-NTR Bar 2 РК-19-15358
797808 797808   BG eat_drink bars_pubs bar_pub normal 2 star 2 20     0 0 40 0 45   65 20 47.7 PDV 9.1 8.7 323 Pamporovo Chepelare hotel Dafovska 41.65525 24.69352 2028-03-13T22:00:00Z   BG-NTR Bar 2 РК-19-15352
797809 797809   BG eat_drink bars_pubs bar_pub normal 2 star 2 48   banquet 0 0 50 0 45   65 20 47.7 PDV 9.1 8.7 323 Pamporovo Smolyan hotel Mursalitsa 41.65525 24.69352 2028-03-13T22:00:00Z   BG-NTR Bar 2 РК-19-15350
797811 797811   BG eat_drink bars_pubs bar_pub normal 2 star 2 80   banquet 0 0 60 0 55                 k.k.Pamporovo Chepelare hotel Prespa     2028-03-13T22:00:00Z   BG-NTR Bar 2 РК-19-15346
797813 797813 SNEZHANKA BG eat_drink bars_pubs bar_pub normal 2 star 2 20     0 0 40 0 45   65 20 47.7 PDV 9.1 8.7 323 Pamporovo Smolyan hotel Snezhanka 41.65525 24.69352 2028-03-13T22:00:00Z   BG-NTR Bar 2 РК-19-15343
797817 797817 BG eat_drink bars_pubs bar_pub normal 2 star 2 47   banquet 0 0 50 0 45   65 20 47.7 PDV 9.1 8.7 323 Pamporovo Smolyan k. k. Pamporovo, hotel Elina 41.65525 24.69352 2028-03-13T22:00:00Z   BG-NTR Bar 2 РК-19-15337
797827 797827   BG eat_drink bars_pubs bar_pub normal 2 star 2 20     0 0 40 0 45   55 0 73.3 SOF 12.0 0.0 391 Borovets Samokov hotel Sveti Georgi 42.10566 23.02003 2028-03-13T22:00:00Z   BG-NTR Bar 2 РК-19-15322
797829 797829 BOR BG eat_drink bars_pubs bar_pub normal 2 star 2 20     0 0 40 0 45   55 0 73.3 SOF 12.0 0.0 391 Borovets Samokov hotel Bor 42.10566 23.02003 2028-03-13T22:00:00Z   BG-NTR Bar 2 РК-19-15319
797859 797859   BG eat_drink bars_pubs bar_pub normal 2 star 2 14     0 0 40 0 45   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna r-n Oborishte, ul. Georgi S. Rakovski № 53, hotel Leda 42.69751 23.32415 2028-01-31T22:00:00Z   BG-NTR Bar 2 РК-19-15277
797878 797878   BG eat_drink bars_pubs bar_pub normal 2 star 2 56   party 0 0 50 0 55   65 0 58.3 JAM 0.0 0.0 558 Stara Zagora Stara Zagora bul. Patriarh Evtimiy № 23, Apartamenten hotel Siti 42.43205 25.64262 2028-01-31T22:00:00Z   BG-NTR Bar 2 РК-19-15250
797896 797896 BRAVO / BRAVO BG eat_drink bars_pubs bar_pub normal 2 star 2 100   party 0 0 60 0 65   65 0 33.3 SOF 0.0 0.0 146 Pernik Pernik pl. Krakra Pernishki № 1, hotel Struma 42.59671 23.03318 2027-12-28T22:00:00Z   BG-NTR Bar 2 РК-19-15215
797914 797914   BG eat_drink bars_pubs bar_pub normal 2 star 2 50   party 0 0 50 0 55   55 0 56.3 SOF 14.0 0.0 108 Varshets Varshets ul. Vasil Levski № 16, balneohotel Tintyava 43.19356 23.2868 2027-12-28T22:00:00Z   BG-NTR Bar 2 РК-19-15186
797921 797921 SEZONI BG eat_drink bars_pubs bar_pub normal 2 star 2 40   banquet 0 0 50 0 45   80 20 6.8 PDV 7.1 7.1 40 Kuklen Kuklen park Rodopi, mestnost Zdravets, hotel Eko hotel Zdravets 42.03333 24.78333 2027-12-28T22:00:00Z   BG-NTR Bar 2 РК-19-15174
797924 797924 A & M BG eat_drink bars_pubs bar_pub normal 2 star 2 54   party 0 0 50 0 55   80 0 12.7 PDV 0.0 0.0 1591 Plovdiv Plovdiv rayon Tsentralen, bul. Hristo Botev №46, hotel A & M 42.15387 24.75001 2027-12-28T22:00:00Z   BG-NTR Bar 2 РК-19-15169
797932 797932   BG eat_drink bars_pubs bar_pub normal 2 star 2 40   banquet 0 0 50 0 45   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna bul. Simeonovsko shose № 66, hotel Brod 42.69751 23.32415 2027-12-28T22:00:00Z   BG-NTR Bar 2 РК-19-15158
797982 797982   BG eat_drink bars_pubs bar_pub normal 2 star 2 20     0 0 40 0 45   30 0 95.8 SOF 34.4 0.0 907 Bansko Bansko ul. Neofit Rilski № 28, hotel KLUB HOTEL MARTIN 41.8361 23.48745 2027-12-04T22:00:00Z   BG-NTR Bar 2 РК-19-15082
797984 797984   BG eat_drink bars_pubs bar_pub normal 2 star 2 14     0 0 40 0 45   30 0 95.8 SOF 34.4 0.0 907 Bansko Bansko ul. Todorini ochi № 7, Apartamenten hotel Orbiluks 41.8361 23.48745 2027-12-04T22:00:00Z   BG-NTR Bar 2 РК-19-15079
798019 798019 AUGUSTA BG eat_drink bars_pubs bar_pub normal 2 star 2 150   banquet 0 0 70 0 65   70 0 23.3 Graf Ignatievo Air Base 16.9 0.0 422 Hisarya Hisarya bul. Gen. Gurko № 3, SPA hotel Augusta 42.5 24.7 2027-12-04T22:00:00Z   BG-NTR Bar 2 РК-19-15032
798020 798020   BG eat_drink bars_pubs bar_pub normal 2 star 2 50   party 0 0 50 0 55   70 0 23.3 Graf Ignatievo Air Base 16.9 0.0 422 Hisarya Hisarya bul. Gen. Gurko № 3, SPA hotel Augusta 42.5 24.7 2027-12-04T22:00:00Z   BG-NTR Bar 2 РК-19-15031
798021 798021   BG eat_drink bars_pubs bar_pub normal 2 star 2 130   party 0 0 60 0 65   70 0 23.3 Graf Ignatievo Air Base 16.9 0.0 422 Hisarya Hisarya bul. Gen. Gurko № 3, SPA hotel Augusta 42.5 24.7 2027-12-04T22:00:00Z   BG-NTR Bar 2 РК-19-15030
798059 798059   BG eat_drink bars_pubs bar_pub normal 2 star 2 30     0 0 40 0 45   65 0 66.3 Graf Ignatievo Air Base 0.0 0.0 463 Velingrad Velingrad ul. Han Asparuh № 116, SPA hotel Elbrus 42.02754 23.99155 2027-12-04T22:00:00Z   BG-NTR Bar 2 РК-19-14979
798068 798068 EGO BG eat_drink bars_pubs bar_pub normal 2 star 2 20     0 0 40 0 45   80 0 12.7 PDV 0.0 0.0 1591 Plovdiv Plovdiv ul. Eliezer Kalev № 2, hotel Ego 42.15387 24.75001 2027-12-04T22:00:00Z   BG-NTR Bar 2 РК-19-14968
798102 798102 PONTIKA BG eat_drink bars_pubs bar_pub normal 2 star 2 20     0 0 40 0 45   70 0 17.3 BOJ 15.6 0.0 219 Chernomorets Sozopol ul. Akra № 4, ATK Pontika 42.44408 27.63902 2027-12-04T22:00:00Z   BG-NTR Bar 2 РК-19-14920
798106 798106   BG eat_drink bars_pubs bar_pub normal 2 star 2 49   banquet 0 0 50 0 45   45 0 39.0 BOJ 35.5 0.0 587 Primorsko Primorsko ul. Stara Planina № 8, hotel Belitsa, 42.26791 27.75611 2027-12-04T22:00:00Z   BG-NTR Bar 2 РК-19-14913
798125 798125   BG eat_drink bars_pubs bar_pub normal 2 star 2 20     0 0 40 0 45   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar zona Yug, hotel Sirena i Delfin 42.6931 27.7083 2027-12-04T22:00:00Z   BG-NTR Bar 2 РК-19-14887
798132 798132   BG eat_drink bars_pubs bar_pub normal 2 star 2 50   party 0 0 50 0 55   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar ul. Shesta № 1, hotel Nesebar biych 42.6931 27.7083 2027-12-04T22:00:00Z   BG-NTR Drink bar 2 РК-19-14876
798138 798138   BG eat_drink bars_pubs bar_pub normal 2 star 2 95   banquet 0 0 60 0 55   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar ul. Shesta № 1, hotel Nesebar biych 42.6931 27.7083 2027-12-04T22:00:00Z   BG-NTR Bar 2 РК-19-14870
798140 798140   BG eat_drink bars_pubs bar_pub normal 2 star 2 50   party 0 0 50 0 55   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar kv. Chayka 245, Apartamenten turisticheski kompleks Hepi 42.6931 27.7083 2027-12-04T22:00:00Z   BG-NTR Bar 2 РК-19-14867
798145 798145 SNAK BG eat_drink bars_pubs bar_pub normal 2 star 2 50   party 0 0 50 0 55   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar hotel Orel 42.6931 27.7083 2027-12-04T22:00:00Z   BG-NTR Bar 2 РК-19-14858
798147 798147 EL AND BI BG eat_drink bars_pubs bar_pub normal 2 star 2 20     0 0 40 0 45   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar hotel El and Bi 42.6931 27.7083 2027-12-04T22:00:00Z   BG-NTR Bar 2 РК-19-14855
798182 798182 RELAKS BG eat_drink bars_pubs bar_pub normal 2 star 2 50   party 0 0 50 0 55                 Sv. sv. Konstantin i Elena Varna hotel MDU Frederik Zholio - Kyuri     2027-10-05T21:00:00Z   BG-NTR Drink bar 2 РК-19-14812
798183 798183 PANORAMA BG eat_drink bars_pubs bar_pub normal 2 star 2 50   party 0 0 50 0 55                 Sv. sv. Konstantin i Elena Varna hotel MDU Frederik Zholio - Kyuri     2027-10-05T21:00:00Z   BG-NTR Drink bar 2 РК-19-14811
798185 798185   BG eat_drink bars_pubs bar_pub normal 2 star 2 50   party 0 0 50 0 55                 Sv. sv. Konstantin i Elena Varna hotel Atlant     2027-10-05T21:00:00Z   BG-NTR Bar 2 РК-19-14808
798203 798203   BG eat_drink bars_pubs bar_pub normal 2 star 2 150   banquet 0 0 70 0 65   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar hotel Palas 42.6931 27.7083 2027-10-05T21:00:00Z   BG-NTR Bar 2 РК-19-14785
798204 798204   BG eat_drink bars_pubs bar_pub normal 2 star 2 30     0 0 40 0 45   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar hotel Shipka 42.6931 27.7083 2027-10-05T21:00:00Z   BG-NTR Bar 2 РК-19-14784
798271 798271 ALEKSANDRA PALAS BG eat_drink bars_pubs bar_pub normal 2 star 2 20     0 0 40 0 45   70 0 13.5 Balchik Airfield 18.1 0.0 340 Kranevo Balchik ul. Briz № 3, hotel Aleksandra Palas 43.34157 28.05759 2027-10-05T21:00:00Z   BG-NTR Bar 2 РК-19-14699
798311 798311   BG eat_drink bars_pubs bar_pub normal 2 star 2 20     0 0 40 0 45   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar vilna zona Zora, hotel Sanrayz 42.6931 27.7083 2027-10-05T21:00:00Z   BG-NTR Bar 2 РК-19-14643
798326 798326   BG eat_drink bars_pubs bar_pub normal 2 star 2 20     0 0 40 0 45   70 0 22.5 BOJ 21.0 0.0 810 Sozopol Sozopol ul. Republikanska №37, hotel Tabanov Biych 42.41801 27.6956 2027-10-05T21:00:00Z   BG-NTR Bar 2 РК-19-14625

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