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

7,442 rows where country = "BG", family = "bars_pubs" and group = "eat_drink"

This data as json, CSV (advanced)

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

rating_value 5

  • 1 4,611
  • 2 1,340
  • 3 882
  • 4 419
  • 5 96

best_for 2

group 1

  • eat_drink · 7,442 ✖

family 1

  • bars_pubs · 7,442 ✖

country 1

  • BG · 7,442 ✖

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
796124 796124 "LOBI BAR HILEZ" BG eat_drink bars_pubs bar_pub normal 1 star 1 60   party 0 0 50 0 55   55 0 36.1 GOZ 14.8 0.0 222 Tryavna Tryavna ul. "Stara planina" №17 42.86667 25.5 2029-08-22T09:00:00Z   BG-NTR Bar 1 СДУР-155
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
796255 796255   BG eat_drink bars_pubs bar_pub normal 3 star 3 50   party 0 0 50 0 55   80 0 12.7 PDV 0.0 0.0 1591 Plovdiv Plovdiv rayon Trakiya, ul. Saedinenie № 2, hotel Yegerhof 42.15387 24.75001 2031-04-19T21:00:00Z   BG-NTR Bar 3 РК-19-17566
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
796258 796258 MELODI BG eat_drink bars_pubs bar_pub normal 3 star 3 70   party 0 0 50 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 Bar 3 РК-19-17562
796261 796261 ORFEY BG eat_drink bars_pubs bar_pub normal 4 star 4 70   banquet 0 0 60 0 55   30 0 90.2 SOF 33.7 0.0 237 Razlog Razlog m. Katarino, SPA hotel Katarino 41.8863 23.46714 2031-04-19T21:00:00Z   BG-NTR Bar 4 РК-19-17559
796262 796262 VITAMINA BG eat_drink bars_pubs bar_pub normal 4 star 4 36   banquet 0 0 50 0 45   30 0 90.2 SOF 33.7 0.0 237 Razlog Razlog m. Katarino, SPA hotel Katarino 41.8863 23.46714 2031-04-19T21:00:00Z   BG-NTR Bar 4 РК-19-17558
796265 796265   BG eat_drink bars_pubs bar_pub normal 4 star 4 175   banquet 0 0 80 0 65   30 0 90.2 SOF 33.7 0.0 237 Razlog Razlog m. Katarino, SPA hotel Katarino 41.8863 23.46714 2031-04-19T21:00:00Z   BG-NTR Bar 4 РК-19-17555
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
796271 796271   BG eat_drink bars_pubs bar_pub normal 3 star 3 20     0 0 40 0 45   55 30 67.0 Graf Ignatievo Air Base 11.9 11.0 49 Starozagorski bani Stara Zagora ul. Okolovrastno shose № 23, hotel Magdalena 42.45 25.5 2031-04-06T21:00:00Z   BG-NTR Bar 3 РК-19-17544
796272 796272   BG eat_drink bars_pubs bar_pub normal 3 star 3 50   party 0 0 50 0 55   80 0 12.7 PDV 0.0 0.0 1591 Plovdiv Plovdiv rayon Yuzhen, ul. Kuklensko shose № 30 hotel ARBAN 42.15387 24.75001 2031-04-06T21:00:00Z   BG-NTR Bar 3 РК-19-17542
796275 796275   BG eat_drink bars_pubs bar_pub normal 3 star 3 20     0 0 40 0 45   30 0 95.8 SOF 34.4 0.0 907 Bansko Bansko ul. Tsar Simeon № 68, hotel Pirin 41.8361 23.48745 2031-03-22T22:00:00Z   BG-NTR Bar 3 РК-19-17535
796278 796278 OLIMP BG eat_drink bars_pubs bar_pub normal 3 star 3 12     0 0 40 0 45   65 0 66.3 Graf Ignatievo Air Base 0.0 0.0 463 Velingrad Velingrad ul. Tsar Samuil № 1A, SPA hotel Olimp 42.02754 23.99155 2031-03-22T22:00:00Z   BG-NTR Bar 3 РК-19-17530
796279 796279 OLIMP BG eat_drink bars_pubs bar_pub normal 3 star 3 50   party 0 0 50 0 55   65 0 66.3 Graf Ignatievo Air Base 0.0 0.0 463 Velingrad Velingrad ul. Tsar Samuil № 1A, SPA hotel Olimp 42.02754 23.99155 2031-03-22T22:00:00Z   BG-NTR Bar 3 РК-19-17529
796281 796281   BG eat_drink bars_pubs bar_pub normal 3 star 3 50   party 0 0 50 0 55   65 0 66.3 Graf Ignatievo Air Base 0.0 0.0 463 Velingrad Velingrad kv. Chepino, ul. Edelvays № 4, balneohotel Kamena 42.02754 23.99155 2031-03-22T22:00:00Z   BG-NTR Bar 3 РК-19-17526
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
796285 796285 FESTA UINTAR PALAS BG eat_drink bars_pubs bar_pub normal 4 star 4 48   banquet 0 0 60 0 45   55 0 73.3 SOF 12.0 0.0 391 Borovets Samokov hotel Festa Uintar Palas 42.10566 23.02003 2031-03-22T22:00:00Z   BG-NTR Bar 4 РК-19-17520
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
796299 796299 RITUAL BG eat_drink bars_pubs bar_pub normal 4 star 4 400   banquet 0 0 80 0 65   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna r-n Studentski, ul. Atanas Manchev № 6 42.69751 23.32415 2031-02-11T22:00:00Z   BG-NTR Bar 4 РК-19-17493
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
796305 796305   BG eat_drink bars_pubs bar_pub normal 4 star 4 29   banquet 0 0 50 0 45   30 0 95.8 SOF 34.4 0.0 907 Bansko Bansko ul. Stragite № 10, hotel-rezidens Amira 41.8361 23.48745 2031-01-25T22:00:00Z   BG-NTR Bar 4 РК-19-17485
796308 796308 VITAMIN BAR BG eat_drink bars_pubs bar_pub normal 4 star 4 20   banquet 0 0 50 0 45   65 20 47.7 PDV 9.1 8.7 323 Pamporovo Chepelare hotel Perelik 41.65525 24.69352 2031-01-25T22:00:00Z   BG-NTR Bar 4 РК-19-17481
796310 796310 VR BG eat_drink bars_pubs bar_pub normal 4 star 4 40   banquet 0 0 60 0 45   70 20 20.4 PDV 16.2 7.8 25 Narechenski bani Asenovgrad ul. Lyuti dol № 14, ul. Lyuti dol № 14,hotel-rezidens VR Lakshari/ VR Luxury 41.9 24.75 2031-01-25T22:00:00Z   BG-NTR Bar 4 РК-19-17479
796311 796311 BUNKER BG eat_drink bars_pubs bar_pub normal 4 star 4 20   banquet 0 0 50 0 45   70 20 20.4 PDV 16.2 7.8 25 Narechenski bani Asenovgrad ul. Lyuti dol № 14,hotel-rezidens VR Lakshari/ VR Luxury 41.9 24.75 2031-01-25T22:00:00Z   BG-NTR Bar 4 РК-19-17478
796313 796313   BG eat_drink bars_pubs bar_pub normal 3 star 3 30     0 0 40 0 45   55 0 54.1 PDV 12.1 0.0 306 Batak Batak Yazovir Batak- k.k. Tsigov chark, hotel Paradays 41.94307 24.21833 2031-01-25T22:00:00Z   BG-NTR Bar 3 РК-19-17475
796314 796314   BG eat_drink bars_pubs bar_pub normal 3 star 3 60   party 0 0 50 0 55   55 30 62.9 SOF 23.5 17.2 21 Rilski manastir Rila mestnost Bivolarnika, hotel Rilets Rezort 42.13318 23.34063 2031-01-25T22:00:00Z   BG-NTR Bar 3 РК-19-17473
796315 796315   BG eat_drink bars_pubs bar_pub normal 3 star 3 50   party 0 0 50 0 55   55 30 62.9 SOF 23.5 17.2 21 Rilski manastir Rila mestnost Bivolarnika, hotel Rilets Rezort 42.13318 23.34063 2031-01-25T22:00:00Z   BG-NTR Bar 3 РК-19-17472
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
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
796322 796322   BG eat_drink bars_pubs bar_pub normal 3 star 3 18     0 0 40 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-17461
796324 796324   BG eat_drink bars_pubs bar_pub normal 3 star 3 20     0 0 40 0 45   55 0 73.3 SOF 12.0 0.0 391 Borovets Samokov hotel Borovets Griyn 42.10566 23.02003 2031-01-25T22:00:00Z   BG-NTR Bar 3 РК-19-17458
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
796329 796329 SOFIYA KLUB BG eat_drink bars_pubs bar_pub normal 4 star 4 100   banquet 0 0 70 0 65   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna r-n Sredets, ul. Gurko № 1, biznes hotel Grand Hotel Sofiya 42.69751 23.32415 2031-01-25T22:00:00Z   BG-NTR Bar 4 РК-19-17450
796330 796330   BG eat_drink bars_pubs bar_pub normal 4 star 4 40   banquet 0 0 60 0 45   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna r-n Sredets, ul. Gurko № 1, biznes hotel Grand Hotel Sofiya 42.69751 23.32415 2031-01-25T22:00:00Z   BG-NTR Bar 4 РК-19-17449
796331 796331 GRAND KAFE BG eat_drink bars_pubs bar_pub normal 4 star 4 170   banquet 0 0 80 0 65   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna r-n Sredets, ul. Gurko № 1, biznes hotel Grand Hotel Sofiya 42.69751 23.32415 2031-01-25T22:00:00Z   BG-NTR Bar 4 РК-19-17448
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
796340 796340   BG eat_drink bars_pubs bar_pub normal 3 star 3 20     0 0 40 0 45   50 20 98.0 KVA 8.3 4.0 14 Dabnitsa Garmen ul. Parva № 1, Spa hotel Iveliya 41.56667 23.83333 2030-12-21T22:00:00Z   BG-NTR Bar 3 РК-19-17432
796342 796342   BG eat_drink bars_pubs bar_pub normal 3 star 3 18     0 0 40 0 45   30 0 95.8 SOF 34.4 0.0 907 Bansko Bansko mestnost Kosherinata, hotel Park hotel Panorama 41.8361 23.48745 2030-12-21T22:00:00Z   BG-NTR Bar 3 РК-19-17429
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
796346 796346 TRIUMF BG eat_drink bars_pubs bar_pub normal 4 star 4 40   banquet 0 0 60 0 45   65 0 41.4 SOF 0.0 0.0 155 Samokov Samokov ul. Prespa №16, hotel SamElion 42.33855 23.55805 2030-12-21T22:00:00Z   BG-NTR Bar 4 РК-19-17417
796348 796348 GRAFITI KAFE BG eat_drink bars_pubs bar_pub normal 4 star 4 192   banquet 0 0 80 0 65   80 0 7.0 VAR 0.0 0.0 1513 Varna Varna bul. Knyaz Boris I № 65, biznes hotel Galeriya Grafit 43.21912 27.91024 2030-12-21T22:00:00Z   BG-NTR Bar 4 РК-19-17414
796350 796350   BG eat_drink bars_pubs bar_pub normal 3 star 3 50   party 0 0 50 0 55   80 0 7.0 VAR 0.0 0.0 1513 Varna Varna bul. Saborni № 42 , hotel Aslan Gold 43.21912 27.91024 2030-12-21T22:00:00Z   BG-NTR Bar 3 РК-19-17412
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
796355 796355 ZARA BG eat_drink bars_pubs bar_pub normal 4 star 4 30   banquet 0 0 50 0 45   30 0 95.8 SOF 34.4 0.0 907 Bansko Bansko ul. Yavor № 42, apartamenten turisticheski kompleks Zara 41.8361 23.48745 2030-12-21T22:00:00Z   BG-NTR Bar 4 РК-19-17404
796357 796357   BG eat_drink bars_pubs bar_pub normal 4 star 4 10   banquet 0 0 50 0 45   60 0 25.5 BOJ 33.1 0.0 2109 Sveti Vlas Nesebar ul. Odesa №1, hotel Laguna Spa 42.7136 27.75867 2030-12-21T22:00:00Z   BG-NTR Bar 4 РК-19-17401
796360 796360   BG eat_drink bars_pubs bar_pub normal 3 star 3 36     0 0 40 0 45   70 0 9.4 BOJ 14.6 0.0 379 Pomorie Pomorie ul. Chayka № 3, apartamenten hotel Penelopa Palas 42.56326 27.62986 2030-12-21T22:00:00Z   BG-NTR Bar 3 РК-19-17397
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
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
796370 796370 DIVINE BG eat_drink bars_pubs bar_pub normal 3 star 3 60   party 0 0 50 0 55   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna r-n Triaditsa, bul. Vitosha № 106, biznes hotel Roslin Sentral Park Hotel Sofiya 42.69751 23.32415 2030-11-23T22:00:00Z   BG-NTR Bar 3 РК-19-17382
796371 796371 OAZIS BG eat_drink bars_pubs bar_pub normal 4 star 4 108   banquet 0 0 70 0 65   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna bul. Knyaginya Mariya Luiza № 131, biznes hotel Ramada Sofiya Siti Tsentar 42.69751 23.32415 2030-11-23T22:00:00Z   BG-NTR Bar 4 РК-19-17380
796376 796376   BG eat_drink bars_pubs bar_pub normal 4 star 4 48   banquet 0 0 60 0 45   65 0 66.3 Graf Ignatievo Air Base 0.0 0.0 463 Velingrad Velingrad kv. Chepino, ul. Edelvays № 4, SPA-hotel Selekt 42.02754 23.99155 2030-11-23T22:00:00Z   BG-NTR Bar 4 РК-19-17368
796377 796377   BG eat_drink bars_pubs bar_pub normal 4 star 4 48   banquet 0 0 60 0 45   65 0 66.3 Graf Ignatievo Air Base 0.0 0.0 463 Velingrad Velingrad kv. Chepino, ul. Edelvays № 4, SPA-hotel Selekt 42.02754 23.99155 2030-11-23T22:00:00Z   BG-NTR Bar 4 РК-19-17367
796379 796379   BG eat_drink bars_pubs bar_pub normal 4 star 4 28   banquet 0 0 50 0 45   55 0 54.1 PDV 12.1 0.0 306 Batak Batak Yazovir Batak, hotel Katalina Rezort 41.94307 24.21833 2030-11-23T22:00:00Z   BG-NTR Bar 4 РК-19-17363
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
796382 796382   BG eat_drink bars_pubs bar_pub normal 3 star 3 10     0 0 40 0 45   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna zh.k. Studentski grad, ul. Profesor Hristo Vakarelski № 1A, hotel Olivs Siti Hotel 42.69751 23.32415 2030-11-23T22:00:00Z   BG-NTR Bar 3 РК-19-17358
796384 796384 LAYF KLUB/LIVE CLUB BG eat_drink bars_pubs bar_pub normal 4 star 4 100   banquet 0 0 70 0 65   45 0 61.5 CRA 40.0 0.0 69 Kozloduy Kozloduy ul. Krayrechna №2, hotel Danubius Vyu 43.77691 23.73001 2030-11-23T22:00:00Z   BG-NTR Bar 4 РК-19-17355
796385 796385   BG eat_drink bars_pubs bar_pub normal 4 star 4 20   banquet 0 0 50 0 45   45 0 61.5 CRA 40.0 0.0 69 Kozloduy Kozloduy ul. Krayrechna №2, hotel Danubius Vyu 43.77691 23.73001 2030-11-23T22:00:00Z   BG-NTR Bar 4 РК-19-17354
796391 796391 ATRIUM BG eat_drink bars_pubs bar_pub normal 3 star 3 20     0 0 40 0 45   45 0 39.0 Dolna Mitropoliya Air Base 43.7 0.0 26 Lukovit Lukovit ul. Dimitar Talev № 2, hotel Diplomat Plaza 43.2 24.16667 2030-10-16T21:00:00Z   BG-NTR Bar 3 РК-19-17344
796393 796393 PRI MOMITE BG eat_drink bars_pubs bar_pub normal 3 star 3 100   party 0 0 60 0 65   45 0 39.0 Dolna Mitropoliya Air Base 43.7 0.0 26 Lukovit Lukovit ul. Dimitar Talev" № 2, hotel Diplomat Plaza 43.2 24.16667 2030-10-16T21:00:00Z   BG-NTR Drink bar 3 РК-19-17342
796395 796395   BG eat_drink bars_pubs bar_pub normal 4 star 4 50   banquet 0 0 60 0 55   55 0 54.1 PDV 12.1 0.0 306 Batak Batak Tsigov chark, mestnost Pushtek, hotel Brentas Rizort 41.94307 24.21833 2030-10-16T21:00:00Z   BG-NTR Bar 4 РК-19-17338
796397 796397   BG eat_drink bars_pubs bar_pub normal 3 star 3 20     0 0 40 0 45   55 30 37.4 SOF 14.8 12.6 35 Belchin Samokov Spa Kompleks Belchinski Izvor 42.36121 23.38088 2030-10-16T21:00:00Z   BG-NTR Bar 3 РК-19-17335
796399 796399   BG eat_drink bars_pubs bar_pub normal 4 star 4 15   banquet 0 0 50 0 45   65 0 41.4 SOF 0.0 0.0 155 Samokov Samokov ul. Prespa №16, hotel SamElion 42.33855 23.55805 2030-10-16T21:00:00Z   BG-NTR Bar 4 РК-19-17332
796401 796401 DA MUUN/THE MOON BG eat_drink bars_pubs bar_pub normal 4 star 4 60   banquet 0 0 60 0 55   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna r-n Izgrev, bul. Tsarigradsko shose № 28, biznes hotel Iztok Plaza Hotel 42.69751 23.32415 2030-10-16T21:00:00Z   BG-NTR Bar 4 РК-19-17328
796403 796403   BG eat_drink bars_pubs bar_pub normal 3 star 3 50   party 0 0 50 0 55   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna r-n Vitosha, Priroden park Vitosha, hotel Moreni 42.69751 23.32415 2030-10-16T21:00:00Z   BG-NTR Bar 3 РК-19-17326
796406 796406   BG eat_drink bars_pubs bar_pub normal 3 star 3 15     0 0 40 0 45   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna rayon Vitosha, kv. Dragalevtsi,ul.Karnobatski prohod № 1 hotel Dragalevtsi 42.69751 23.32415 2030-10-16T21:00:00Z   BG-NTR Bar 3 РК-19-17322
796410 796410   BG eat_drink bars_pubs bar_pub normal 3 star 3 31     0 0 40 0 45   65 0 64.7 GOZ 0.0 0.0 185 Kazanlak Kazanlak ul. 6-ti Septemvri №13A, hotel KiG Siti Hotel 42.61667 25.4 2030-10-16T21:00:00Z   BG-NTR Bar 3 РК-19-17314
796411 796411   BG eat_drink bars_pubs bar_pub normal 3 star 3 100   party 0 0 60 0 65   80 0 10.4 GOZ 0.0 0.0 594 Veliko Tarnovo Veliko Tarnovo ul. Aleksandar Penchev № 2, hotel Grand hotel Veliko Tarnovo 43.08124 25.62904 2030-10-16T21:00:00Z   BG-NTR Bar 3 РК-19-17312
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
796416 796416   BG eat_drink bars_pubs bar_pub normal 3 star 3 50   party 0 0 50 0 55   80 0 7.0 VAR 0.0 0.0 1513 Varna Varna bul. Tsar Osvoboditel № 90, hotel Kampus 90 43.21912 27.91024 2030-10-16T21:00:00Z   BG-NTR Bar 3 РК-19-17304
796418 796418   BG eat_drink bars_pubs bar_pub normal 4 star 4 20   banquet 0 0 50 0 45   60 0 25.5 BOJ 33.1 0.0 2109 Sveti Vlas Nesebar rayon Kozluka hotel AMORE BIYCh 42.7136 27.75867 2030-10-16T21:00:00Z   BG-NTR Bar 4 РК-19-17301
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
796422 796422   BG eat_drink bars_pubs bar_pub normal 3 star 3 20     0 0 40 0 45   80 0 12.7 PDV 0.0 0.0 1591 Plovdiv Plovdiv ul. Vladaya № 3, hotel Siti Hotel Plovdiv 42.15387 24.75001 2030-10-16T21:00:00Z   BG-NTR Bar 3 РК-19-17296
796423 796423   BG eat_drink bars_pubs bar_pub normal 3 star 3 142   party 0 0 60 0 65   65 0 32.3 Balchik Airfield 0.0 0.0 355 Dobrich Dobrich ul. Nezavisimost № 2, hotel Dobrudzha 43.56491 27.83138 2030-10-16T21:00:00Z   BG-NTR Bar 3 РК-19-17293
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
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
796431 796431   BG eat_drink bars_pubs bar_pub normal 3 star 3 20     0 0 40 0 45   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-17282
796432 796432 FRESH BG eat_drink bars_pubs bar_pub normal 3 star 3 20     0 0 40 0 45   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-17281
796433 796433   BG eat_drink bars_pubs bar_pub normal 3 star 3 110   party 0 0 60 0 65   70 0 20.6 BOJ 27.7 0.0 2040 Nesebar Nesebar ul, "Lyuben Karavelov" № 15, hotel Marieta Palas 42.65921 27.73602 2030-10-16T21:00:00Z   BG-NTR Bar 3 РК-19-17279
796434 796434 MARIETA PALAS BG eat_drink bars_pubs bar_pub normal 3 star 3 28     0 0 40 0 45   70 0 20.6 BOJ 27.7 0.0 2040 Nesebar Nesebar ul. Lyuben Karavelov № 15, hotel Marieta Palas 42.65921 27.73602 2030-10-16T21:00:00Z   BG-NTR Bar 3 РК-19-17278
796435 796435 MARIETA PALAS BG eat_drink bars_pubs bar_pub normal 3 star 3 144   party 0 0 60 0 65   70 0 20.6 BOJ 27.7 0.0 2040 Nesebar Nesebar ul. Lyuben Karavelov № 15, hotel Marieta Palas 42.65921 27.73602 2030-10-16T21:00:00Z   BG-NTR Bar 3 РК-19-17277
796437 796437 METSANIN BG eat_drink bars_pubs bar_pub normal 3 star 3 20     0 0 40 0 45   70 0 18.5 VAR 12.9 0.0 579 Zlatni pyasatsi Varna hotel Havana 43.285 28.0418 2030-10-16T21:00:00Z   BG-NTR Bar 3 РК-19-17274
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
796440 796440   BG eat_drink bars_pubs bar_pub normal 3 star 3 12     0 0 40 0 45   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar - Iztok, hotel Chayka Biych Rizort 42.6931 27.7083 2030-10-16T21:00:00Z   BG-NTR Bar 3 РК-19-17270
796441 796441 IRLANDSKI BG eat_drink bars_pubs bar_pub normal 3 star 3 70   party 0 0 50 0 55   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar - Iztok, hotel Chayka Biych Rizort 42.6931 27.7083 2030-10-16T21:00:00Z   BG-NTR Bar 3 РК-19-17269
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
796444 796444 AZURO BG eat_drink bars_pubs bar_pub normal 3 star 3 20     0 0 40 0 45   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-17265
796446 796446   BG eat_drink bars_pubs bar_pub normal 4 star 4 100   banquet 0 0 70 0 65   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 Drink bar 4 РК-19-17262
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
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
796451 796451 BONITO DRAY I LET /BONITO DRY&WET BG eat_drink bars_pubs bar_pub normal 3 star 3 30     0 0 40 0 45   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-17256
796452 796452 AGUA /AGUA BG eat_drink bars_pubs bar_pub normal 3 star 3 30     0 0 40 0 45   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-17255
796454 796454 Brizee BG eat_drink bars_pubs bar_pub normal 4 star 4 50   banquet 0 0 60 0 55   70 0 20.6 BOJ 27.7 0.0 2040 Nesebar Nesebar k.k. Slanchev bryag - Iztok, hotel Noma 42.65921 27.73602 2030-09-15T21:00:00Z   BG-NTR Bar 4 РК-19-17253
796455 796455 Noel BG eat_drink bars_pubs bar_pub normal 4 star 4 20   banquet 0 0 50 0 45   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar Iztok, hotel Noma 42.6931 27.7083 2030-09-15T21:00:00Z   BG-NTR Bar 4 РК-19-17252

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