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

882 rows where country = "BG", family = "bars_pubs" and rating_value = 3

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

group 1

family 1

  • bars_pubs · 882 ✖

country 1

  • BG · 882 ✖

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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
796458 796458   BG eat_drink bars_pubs bar_pub normal 3 star 3 50   party 0 0 50 0 55   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar kompleks Fregata 10, hotel Kalipso 42.6931 27.7083 2030-09-15T21:00:00Z   BG-NTR Bar 3 РК-19-17247
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
796461 796461   BG eat_drink bars_pubs bar_pub normal 3 star 3 120   party 0 0 60 0 65   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-17244
796464 796464 BG eat_drink bars_pubs bar_pub normal 3 star 3 120   party 0 0 60 0 65   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-17239
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
796469 796469 VENUS BG eat_drink bars_pubs bar_pub normal 3 star 3 30     0 0 40 0 45   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar k.k. Slanchev bryag, hotel ALBA 42.6931 27.7083 2030-09-15T21:00:00Z   BG-NTR Bar 3 РК-19-17232
796487 796487 PERLA 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 Perla 43.285 28.0418 2030-09-15T21:00:00Z   BG-NTR Bar 3 РК-19-17209
796488 796488   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 k.k. Zlatni pyasatsi, hotel Perla 43.285 28.0418 2030-09-15T21:00:00Z   BG-NTR Bar 3 РК-19-17208
796491 796491   BG eat_drink bars_pubs bar_pub normal 3 star 3 30     0 0 40 0 45   70 0 18.5 VAR 12.9 0.0 579 Zlatni pyasatsi Varna k.k. Zlatni pyasatsi, hotel Palma 43.285 28.0418 2030-09-15T21:00:00Z   BG-NTR Bar 3 РК-19-17203
796497 796497   BG eat_drink bars_pubs bar_pub normal 3 star 3 50   party 0 0 50 0 55   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar k.k. Slanchev bryag - Zapad, apartamenten hotel Tarsis 42.6931 27.7083 2030-07-31T21:00:00Z   BG-NTR Bar 3 РК-19-17194
796505 796505 REDZHINA BG eat_drink bars_pubs bar_pub normal 3 star 3 100   party 0 0 60 0 65   70 0 18.5 VAR 12.9 0.0 579 Zlatni pyasatsi Varna hotel Redzhina 43.285 28.0418 2030-07-31T21:00:00Z   BG-NTR Bar 3 РК-19-17182
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
796508 796508   BG eat_drink bars_pubs bar_pub normal 3 star 3 50   party 0 0 50 0 55                 Sv. sv. Konstantin i Elena Varna hotel Koral     2030-07-31T21:00:00Z   BG-NTR Bar 3 РК-19-17178
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
796519 796519   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 r-n Zapaden, ul. Sveti Valentin № 3, hotel Landmark Kriyk 42.15387 24.75001 2030-07-31T21:00:00Z   BG-NTR Bar 3 РК-19-17161
796528 796528 DIAMANT BG eat_drink bars_pubs bar_pub normal 3 star 3 145   party 0 0 60 0 65   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar rayon Zapad, hotel Diamant 42.6931 27.7083 2030-07-31T21:00:00Z   BG-NTR Bar 3 РК-19-17149
796530 796530 SAN PALAS 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 Iztok 42.6931 27.7083 2030-07-31T21:00:00Z   BG-NTR Bar 3 РК-19-17146
796532 796532   BG eat_drink bars_pubs bar_pub normal 3 star 3 60   party 0 0 50 0 55   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar park-hotel Kontinental 42.6931 27.7083 2030-07-31T21:00:00Z   BG-NTR Bar 3 РК-19-17143
796542 796542 BG eat_drink bars_pubs bar_pub normal 3 star 3 70   party 0 0 50 0 55   45 0 44.4 VAR 38.1 0.0 386 Kiten Primorsko ul. Urdoviza № 8, hotel Dodo Biych 43.08333 27.31667 2030-07-31T21:00:00Z   BG-NTR Bar 3 РК-19-17130
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
796553 796553   BG eat_drink bars_pubs bar_pub normal 3 star 3 20     0 0 40 0 45   70 0 20.6 BOJ 27.7 0.0 2040 Nesebar Nesebar k.k. Slanchev bryag, hotel For Poynts bay Sheraton Sani Biych 42.65921 27.73602 2030-07-31T21:00:00Z   BG-NTR Bar 3 РК-19-17115
796554 796554   BG eat_drink bars_pubs bar_pub normal 3 star 3 50   party 0 0 50 0 55   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar hotel Esperanto 42.6931 27.7083 2030-07-31T21:00:00Z   BG-NTR Bar 3 РК-19-17114
796557 796557   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 kv. Chayka, UPI V - 157, hotel Opal 42.6931 27.7083 2030-07-31T21:00:00Z   BG-NTR Bar 3 РК-19-17110
796565 796565   BG eat_drink bars_pubs bar_pub normal 3 star 3 50   party 0 0 50 0 55   45 0 44.4 VAR 38.1 0.0 386 Kiten Primorsko ul. Koral № 17, hotel Printses Rezidens 43.08333 27.31667 2030-07-31T21:00:00Z   BG-NTR Bar 3 РК-19-17097
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
796568 796568   BG eat_drink bars_pubs bar_pub normal 3 star 3 50   party 0 0 50 0 55   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-17093
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
796572 796572   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 Metropol 43.285 28.0418 2030-06-30T21:00:00Z   BG-NTR Bar 3 РК-19-17088
796576 796576   BG eat_drink bars_pubs bar_pub normal 3 star 3 50   party 0 0 50 0 55   70 20 9.1 Balchik Airfield 23.0 5.1 202 Albena Balchik hotel Sendi biych 43.38333 28.08333 2030-06-30T21:00:00Z   BG-NTR Bar 3 РК-19-17082
796577 796577   BG eat_drink bars_pubs bar_pub normal 3 star 3 60   party 0 0 50 0 55   70 20 9.1 Balchik Airfield 23.0 5.1 202 Albena Balchik hotel Sendi biych 43.38333 28.08333 2030-06-30T21:00:00Z   BG-NTR Bar 3 РК-19-17081
796582 796582   BG eat_drink bars_pubs bar_pub normal 3 star 3 21     0 0 40 0 45   70 0 18.5 VAR 12.9 0.0 579 Zlatni pyasatsi Varna VK Riviera, hotel Nimfa 43.285 28.0418 2030-06-30T21:00:00Z   BG-NTR Bar 3 РК-19-17074
796584 796584   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 k.k. Chayka, hotel Kini Park 43.21912 27.91024 2030-06-30T21:00:00Z   BG-NTR Bar 3 РК-19-17071
796586 796586   BG eat_drink bars_pubs bar_pub normal 3 star 3 30     0 0 40 0 45   80 0 7.0 VAR 0.0 0.0 1513 Varna Varna k.k. Chayka, hotel Natsionalna sportna baza Sportpalas 43.21912 27.91024 2030-06-30T21:00:00Z   BG-NTR Bar 3 РК-19-17068
796589 796589   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 Liliya 43.285 28.0418 2030-06-30T21:00:00Z   BG-NTR Bar 3 РК-19-17062
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
796598 796598 BOHO BG eat_drink bars_pubs bar_pub normal 3 star 3 20     0 0 40 0 45   45 0 40.8 BOJ 40.1 0.0 291 Obzor Nesebar ul. "Chernomorska" № 14, apartamenten turisticheski kompleks La Bohem 42.81998 27.88007 2030-06-30T21:00:00Z   BG-NTR Bar 3 РК-19-17049
796607 796607   BG eat_drink bars_pubs bar_pub normal 3 star 3 32     0 0 40 0 45   70 40 24.6 Graf Ignatievo Air Base 25.4 11.1 18 Starosel Hisarya SPA-hotel Starosel 42.48333 24.56667 2030-06-30T21:00:00Z   BG-NTR Bar 3 РК-19-17037
796608 796608   BG eat_drink bars_pubs bar_pub normal 3 star 3 50   party 0 0 50 0 55   70 40 24.6 Graf Ignatievo Air Base 25.4 11.1 18 Starosel Hisarya SPA-hotel Starosel 42.48333 24.56667 2030-06-30T21:00:00Z   BG-NTR Bar 3 РК-19-17036
796610 796610 AKVA BG eat_drink bars_pubs bar_pub normal 3 star 3 100   party 0 0 60 0 65   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar k.k. Slanchev bryag-iztok, hotel Kotva 42.6931 27.7083 2030-06-30T21:00:00Z   BG-NTR Bar 3 РК-19-17033
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
796612 796612   BG eat_drink bars_pubs bar_pub normal 3 star 3 104   party 0 0 60 0 65   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-17031
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
796618 796618 SANI BIYCH KLUB BG eat_drink bars_pubs bar_pub normal 3 star 3 25     0 0 40 0 45   70 10 20.9 BOJ 28.5 4.4 2886 Slanchev bryag Nesebar zona Iztok, hotel Sani Biych Klub 42.6931 27.7083 2030-06-30T21:00:00Z   BG-NTR Bar 3 РК-19-17023
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
796629 796629   BG eat_drink bars_pubs bar_pub normal 3 star 3 50   party 0 0 50 0 55   70 0 18.5 VAR 12.9 0.0 579 Zlatni pyasatsi Varna hotel Griyn Park 43.285 28.0418 2030-06-30T21:00:00Z   BG-NTR Bar 3 РК-19-17009
796634 796634   BG eat_drink bars_pubs bar_pub normal 3 star 3 50   party 0 0 50 0 55   65 0 73.7 BBU 0.0 0.0 690 Ruse Ruse bul. Pridunavski № 22, hotel Grand hotel Riga 43.84872 25.9534 2030-06-30T21:00:00Z   BG-NTR Bar 3 РК-19-17002

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