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

2,015 rows where best_for = "banquet", country = "BG" and family = "bars_pubs"

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 914
  • 4 419
  • 2 376
  • 3 192
  • 5 96

group 1

family 1

  • bars_pubs · 2,015 ✖

country 1

  • BG · 2,015 ✖

best_for 1

  • banquet · 2,015 ✖

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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
796470 796470 OPUS BG eat_drink bars_pubs bar_pub normal 4 star 4 250   banquet 0 0 80 0 65   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna ul. Ivan Vazov № 6 42.69751 23.32415 2030-09-15T21:00:00Z   BG-NTR Bar 4 РК-19-17231
796471 796471 MET BG eat_drink bars_pubs bar_pub normal 4 star 4 80   banquet 0 0 70 0 55   80 0 7.6 SOF 0.0 0.0 451 Sofia Stolichna r-n Mladost, bul. Tsarigradsko shose № 64, biznes-hotel Metropolitan 42.69751 23.32415 2030-09-15T21:00:00Z   BG-NTR Bar 4 РК-19-17230
796473 796473   BG eat_drink bars_pubs bar_pub normal 4 star 4 20   banquet 0 0 50 0 45   70 0 13.5 Balchik Airfield 18.1 0.0 340 Kranevo Balchik ul. Kraybrezhna № 3, hotel Sani Kasal 43.34157 28.05759 2030-09-15T21:00:00Z   BG-NTR Drink bar 4 РК-19-17227
796474 796474   BG eat_drink bars_pubs bar_pub normal 4 star 4 14   banquet 0 0 50 0 45   70 0 13.5 Balchik Airfield 18.1 0.0 340 Kranevo Balchik ul. Kraybrezhna № 3, hotel Sani Kasal 43.34157 28.05759 2030-09-15T21:00:00Z   BG-NTR Bar 4 РК-19-17226
796477 796477 Living room BG eat_drink bars_pubs bar_pub normal 4 star 4 90   banquet 0 0 70 0 55   70 0 18.5 VAR 12.9 0.0 579 Zlatni pyasatsi Varna hotel Noa 43.285 28.0418 2030-09-15T21:00:00Z   BG-NTR Bar 4 РК-19-17221
796478 796478 Sky BG eat_drink bars_pubs bar_pub normal 4 star 4 50   banquet 0 0 60 0 55   70 0 18.5 VAR 12.9 0.0 579 Zlatni pyasatsi Varna hotel Noa 43.285 28.0418 2030-09-15T21:00:00Z   BG-NTR Bar 4 РК-19-17220
796484 796484 buble BG eat_drink bars_pubs bar_pub normal 4 star 4 40   banquet 0 0 60 0 45   70 0 18.5 VAR 12.9 0.0 579 Zlatni pyasatsi Varna hotel Noa 43.285 28.0418 2030-09-15T21:00:00Z   BG-NTR Bar 4 РК-19-17214
796486 796486 Noa BG eat_drink bars_pubs bar_pub normal 4 star 4 40   banquet 0 0 60 0 45   70 0 18.5 VAR 12.9 0.0 579 Zlatni pyasatsi Varna hotel Noa 43.285 28.0418 2030-09-15T21:00:00Z   BG-NTR Bar 4 РК-19-17212
796492 796492   BG eat_drink bars_pubs bar_pub normal 4 star 4 300   banquet 0 0 80 0 65   45 0 40.1 VAR 34.1 0.0 303 Byala Byala kamping Luna hotel Sol Luna Bey Rezort 42.87426 27.88865 2030-09-15T21:00:00Z   BG-NTR Bar 4 РК-19-17202
796493 796493   BG eat_drink bars_pubs bar_pub normal 4 star 4 95   banquet 0 0 70 0 55   45 0 40.1 VAR 34.1 0.0 303 Byala Byala kamping Luna hotel Sol Luna Bey Rezort 42.87426 27.88865 2030-09-15T21:00:00Z   BG-NTR Bar 4 РК-19-17201
796495 796495 SOFIYA BG eat_drink bars_pubs bar_pub normal 4 star 4 220   banquet 0 0 80 0 65   45 0 40.1 VAR 34.1 0.0 303 Byala Byala Zona za otdih Luna, hotel Sol Luna Bey Rezort 42.87426 27.88865 2030-09-15T21:00:00Z   BG-NTR Bar 4 РК-19-17198
796500 796500   BG eat_drink bars_pubs bar_pub normal 4 star 4 30   banquet 0 0 50 0 45   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar hotel Laguna Park Sanrayz 42.6931 27.7083 2030-07-31T21:00:00Z   BG-NTR Bar 4 РК-19-17190
796501 796501 BG eat_drink bars_pubs bar_pub normal 4 star 4 30   banquet 0 0 50 0 45   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar hotel Laguna Park Sanrayz 42.6931 27.7083 2030-07-31T21:00:00Z   BG-NTR Bar 4 РК-19-17189
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
796516 796516 DIONISIUS TEMPAL BG eat_drink bars_pubs bar_pub normal 4 star 4 50   banquet 0 0 60 0 55   80 0 12.7 PDV 0.0 0.0 1591 Plovdiv Plovdiv ul. Saborna № 49, hotel Boris Palas 42.15387 24.75001 2030-07-31T21:00:00Z   BG-NTR Bar 4 РК-19-17165
796520 796520   BG eat_drink bars_pubs bar_pub normal 4 star 4 110   banquet 0 0 70 0 65   80 0 12.7 PDV 0.0 0.0 1591 Plovdiv Plovdiv ul. Kapitan Raycho № 2, hotel Ramada Plovdiv Trimontsium 42.15387 24.75001 2030-07-31T21:00:00Z   BG-NTR Bar 4 РК-19-17159
796525 796525   BG eat_drink bars_pubs bar_pub normal 4 star 4 80   banquet 0 0 70 0 55   70 40 24.6 Graf Ignatievo Air Base 25.4 11.1 18 Starosel Hisarya SPA-hotel Trakiyska rezidentsiya 42.48333 24.56667 2030-07-31T21:00:00Z   BG-NTR Bar 4 РК-19-17153
796526 796526   BG eat_drink bars_pubs bar_pub normal 4 star 4 50   banquet 0 0 60 0 55   70 40 24.6 Graf Ignatievo Air Base 25.4 11.1 18 Starosel Hisarya SPA-hotel Trakiyska rezidentsiya 42.48333 24.56667 2030-07-31T21:00:00Z   BG-NTR Bar 4 РК-19-17152
796533 796533 DZHELATO/GELATO BG eat_drink bars_pubs bar_pub normal 4 star 4 50   banquet 0 0 60 0 55   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar kv. Iztok, hotel Nobel 42.6931 27.7083 2030-07-31T21:00:00Z   BG-NTR Bar 4 РК-19-17142
796534 796534   BG eat_drink bars_pubs bar_pub normal 4 star 4 20   banquet 0 0 50 0 45   45 0 39.0 BOJ 35.5 0.0 587 Primorsko Primorsko UPI XI - 255, kv.34, hotel Zheravi Aleksandriya Klub 42.26791 27.75611 2030-07-31T21:00:00Z   BG-NTR Bar 4 РК-19-17141
796535 796535   BG eat_drink bars_pubs bar_pub normal 4 star 4 150   banquet 0 0 80 0 65   45 0 39.0 BOJ 35.5 0.0 587 Primorsko Primorsko UPI XI - 255, kv.34 Hotel Zheravi Aleksandriya Klub 42.26791 27.75611 2030-07-31T21:00:00Z   BG-NTR Bar 4 РК-19-17140
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
796540 796540   BG eat_drink bars_pubs bar_pub normal 4 star 4 20   banquet 0 0 50 0 45   45 0 39.0 BOJ 35.5 0.0 587 Primorsko Primorsko ul. Primorsko shose, mestnost Pyasaka, apartamenten hotel Alyur Biych Rezort 42.26791 27.75611 2030-07-31T21:00:00Z   BG-NTR Bar 4 РК-19-17133
796544 796544 HERMES BG eat_drink bars_pubs bar_pub normal 4 star 4 110   banquet 0 0 70 0 65   45 0 52.1 BOJ 48.6 0.0 218 Tsarevo Tsarevo zona Sever, hotel Hermes Aleksandriya Klub 42.16955 27.84541 2030-07-31T21:00:00Z   BG-NTR Bar 4 РК-19-17127
796545 796545 HERMES BG eat_drink bars_pubs bar_pub normal 4 star 4 50   banquet 0 0 60 0 55   45 0 52.1 BOJ 48.6 0.0 218 Tsarevo Tsarevo zona Sever, hotel Hermes Aleksandriya Klub 42.16955 27.84541 2030-07-31T21:00:00Z   BG-NTR Bar 4 РК-19-17126
796546 796546 HERMES BG eat_drink bars_pubs bar_pub normal 4 star 4 30   banquet 0 0 50 0 45   45 0 52.1 BOJ 48.6 0.0 218 Tsarevo Tsarevo zona Sever, hotel Hermes Aleksandriya Klub 42.16955 27.84541 2030-07-31T21:00:00Z   BG-NTR Bar 4 РК-19-17125
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
796550 796550 PERLA LAKSHARI BG eat_drink bars_pubs bar_pub normal 4 star 4 60   banquet 0 0 60 0 55   45 0 39.0 BOJ 35.5 0.0 587 Primorsko Primorsko ul. Georgi Kondolov № 19, hotel Perla Lakshari 42.26791 27.75611 2030-07-31T21:00:00Z   BG-NTR Bar 4 РК-19-17119
796558 796558   BG eat_drink bars_pubs bar_pub normal 4 star 4 40   banquet 0 0 60 0 45   35 20 68.1 BOJ 64.8 5.1 116 Sinemorets Tsarevo ul. Briz № 1, hotel Bella Vista Biych Klub 42.06051 27.97497 2030-07-31T21:00:00Z   BG-NTR Bar 4 РК-19-17108
796559 796559   BG eat_drink bars_pubs bar_pub normal 4 star 4 40   banquet 0 0 60 0 45   35 20 68.1 BOJ 64.8 5.1 116 Sinemorets Tsarevo ul. Briz № 1, hotel Bella Vista Biych Klub 42.06051 27.97497 2030-07-31T21:00:00Z   BG-NTR Bar 4 РК-19-17107
796562 796562   BG eat_drink bars_pubs bar_pub normal 4 star 4 172   banquet 0 0 80 0 65   45 0 39.0 BOJ 35.5 0.0 587 Primorsko Primorsko ul. Georgi Kondolov № 19, hotel Perla Lakshari 42.26791 27.75611 2030-07-31T21:00:00Z   BG-NTR Bar 4 РК-19-17103
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
796579 796579 SINATRA BG eat_drink bars_pubs bar_pub normal 4 star 4 130   banquet 0 0 70 0 65   70 20 9.1 Balchik Airfield 23.0 5.1 202 Albena Balchik apartamenten hotel Flamingo Grand 43.38333 28.08333 2030-06-30T21:00:00Z   BG-NTR Bar 4 РК-19-17077
796590 796590 BURGER BG eat_drink bars_pubs bar_pub normal 4 star 4 120   banquet 0 0 70 0 65   70 20 9.1 Balchik Airfield 23.0 5.1 202 Albena Balchik hotel Maritim Paradays Blu Albena 43.38333 28.08333 2030-06-30T21:00:00Z   BG-NTR Bar 4 РК-19-17061
796591 796591   BG eat_drink bars_pubs bar_pub normal 4 star 4 80   banquet 0 0 70 0 55   70 20 9.1 Balchik Airfield 23.0 5.1 202 Albena Balchik hotel Maritim Paradays Blu Albena 43.38333 28.08333 2030-06-30T21:00:00Z   BG-NTR Bar 4 РК-19-17060
796592 796592   BG eat_drink bars_pubs bar_pub normal 4 star 4 100   banquet 0 0 70 0 65   70 20 9.1 Balchik Airfield 23.0 5.1 202 Albena Balchik hotel Maritim Paradays Blu Albena 43.38333 28.08333 2030-06-30T21:00:00Z   BG-NTR Bar 4 РК-19-17059
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
796601 796601 SPOT NIGHT CLUB BG eat_drink bars_pubs bar_pub normal 4 star 4 139   banquet 0 0 70 0 65   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar hotel AluaSoul Sani Biych 42.6931 27.7083 2030-06-30T21:00:00Z   BG-NTR Bar 4 РК-19-17045
796602 796602 AQUA BG eat_drink bars_pubs bar_pub normal 4 star 4 216   banquet 0 0 80 0 65   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar hotel AluaSoul Sani Biych 42.6931 27.7083 2030-06-30T21:00:00Z   BG-NTR Bar 4 РК-19-17044
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

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