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,323 rows where best_for = "banquet", family = "bars_pubs" and group = "eat_drink"

This data as json, CSV (advanced)

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

rating_value 5

  • 1 917
  • 4 650
  • 2 387
  • 3 207
  • 5 143

country 3

group 1

  • eat_drink · 2,323 ✖

family 1

  • bars_pubs · 2,323 ✖

best_for 1

  • banquet · 2,323 ✖

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
45685 45685 CONTINENTAL, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 0 4.2 ARW 1.0 1.0 408 Mun. Arad ARAD   46.1741356 21.318273     RO-SITUR BAR DE ZI 4 - STELE  
45905 45905 VALEA CU PESTI, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   55 0 66.0 SBZ 22.3 0.2 89 Com. Arefu ARGEŞ   45.3333451 24.6357028     RO-SITUR BAR DE ZI 4 - STELE  
46035 46035 GATO, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 50   banquet 0 0 60 0 55   50 0 96.0 CRA 1.4 1.4 141 Mun. Piteşti ARGEŞ   44.8415687 24.8529893     RO-SITUR BAR DE ZI 4  
46043 46043 PRESIDENT, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   40 20 86.2 CRA 11.4 1.6 4 Mun. Piteşti ARGEŞ   44.8026721 24.7384709     RO-SITUR BAR DE ZI 4 - STELE  
46048 46048 RUBIN, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   50 0 99.1 CRA 1.8 1.8 145 Mun. Piteşti ARGEŞ   44.8646074 24.8772602     RO-SITUR BAR DE ZI 4 - STELE  
46056 46056 VICTORIA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   50 0 98.2 CRA 0.7 0.7 142 Mun. Piteşti ARGEŞ   44.8539224 24.8742953     RO-SITUR BAR DE ZI 4 - STELE  
46079 46079 HELEN, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 10 4.3 BCM 3.1 2.5 130 Com. Măgura BACĂU   46.5534109 26.878445     RO-SITUR BAR DE ZI 4 - STELE  
46080 46080 HELEN, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 10 4.3 BCM 3.1 2.5 130 Com. Măgura BACĂU   46.5534109 26.878445     RO-SITUR BAR DE ZI 4 - STELE  
46267 46267 CRYSTAL CAFE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 0 6.8 OMR 7.6 1.8 411 Com. Sânmartin BIHOR   46.9895138 21.9758953     RO-SITUR BAR DE ZI 5 - STELE  
46361 46361 CAFE CRIŞ, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 10 4.8 OMR 2.5 2.5 375 Mun. Oradea BIHOR   47.0544533 21.948455     RO-SITUR BAR DE ZI 4 - STELE  
46367 46367 CONTINENTAL, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 10 4.5 OMR 2.1 2.1 374 Mun. Oradea BIHOR   47.055657 21.941854     RO-SITUR BAR DE ZI 4 - STELE  
46378 46378 MAXIM, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 10 4.8 OMR 2.2 2.2 363 Mun. Oradea BIHOR   47.0620087 21.9348834     RO-SITUR BAR DE ZI 4 - STELE  
46388 46388 PISCINA CONTINENTAL, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 10 4.5 OMR 2.1 2.1 374 Mun. Oradea BIHOR   47.055657 21.941854     RO-SITUR BAR DE ZI 4 - STELE  
46400 46400 THE HUB 1, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 0 3.5 OMR 1.1 1.1 359 Mun. Oradea BIHOR   47.0556 21.916233     RO-SITUR BAR DE ZI 4 - STELE  
46401 46401 THE HUB 2, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 0 3.5 OMR 1.1 1.1 359 Mun. Oradea BIHOR   47.0556 21.916233     RO-SITUR BAR DE ZI 4 - STELE  
46432 46432 PANORAMIC COLIBIŢA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   30 0 87.4 TGM 31.1 0.6 69 Com. Bistriţa Bârgăului, Sat Colibiţa BISTRIŢA-NĂSĂUD   47.1776112 24.9056372     RO-SITUR BAR DE ZI 4 - STELE  
46486 46486 OZANA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   65 0 74.2 CLJ 1.5 1.5 91 Mun. Bistriţa BISTRIŢA-NĂSĂUD   47.144322 24.510262     RO-SITUR BAR DE ZI 4 - STELE  
46529 46529 PISCINA CLUB BAZIN CONSTANTIN, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 0 23.7 SCV 0.8 0.8 49 Mun. Botoşani BOTOŞANI   47.7446532 26.6591075     RO-SITUR BAR DE ZI 4 - STELE  
46572 46572 EDYS HOUSE, CRAMĂ RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   65 0 63.0 TCE 0.6 0.6 90 Mun. Brăila BRĂILA   45.2717266 27.9669803     RO-SITUR CRAMĂ 4 - STELE  
46640 46640 NECTAR, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 42   banquet 0 0 50 0 45   80 0 27.5 GHV 9.1 0.5 462 Com. Bran, Sat Şimon BRAŞOV   45.4849579730916 25.3630292693726     RO-SITUR BAR DE ZI 3  
46763 46763 AMBIENT, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 0 8.6 GHV 0.6 0.6 1175 Mun. Braşov BRAŞOV   45.6486552 25.5983695     RO-SITUR BAR DE ZI 4 - STELE  
46770 46770 ARO PALACE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 0 8.5 GHV 1.2 1.2 1175 Mun. Braşov BRAŞOV   45.6453981 25.5910919     RO-SITUR BAR DE ZI 5 - STELE  
46778 46778 BELVEDERE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 10 8.0 GHV 2.2 2.2 1158 Mun. Braşov BRAŞOV   45.6450749 25.5788229     RO-SITUR BAR DE ZI 4 - STELE  
46815 46815 EXECUTIVE LOUNGE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 0 8.7 GHV 1.1 1.1 1170 Mun. Braşov BRAŞOV   45.6449623 25.593145     RO-SITUR BAR DE ZI 4 - STELE  
46816 46816 FAVORIT, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 0 8.7 GHV 0.5 0.5 1176 Mun. Braşov BRAŞOV   45.649327 25.6003015     RO-SITUR BAR DE ZI 4 - STELE  
46825 46825 GRAND HOTEL, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 10 13.2 GHV 4.3 4.0 759 Mun. Braşov BRAŞOV   45.6156845 25.6347064     RO-SITUR BAR DE ZI 4 - STELE  
46842 46842 LOBBY BAR, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 0 8.7 GHV 1.1 1.1 1170 Mun. Braşov BRAŞOV   45.6449623 25.593145     RO-SITUR BAR DE ZI 4 - STELE  
46863 46863 PANORAMIC, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 50   banquet 0 0 60 0 55   80 0 9.1 GHV 1.5 1.5 1174 Mun. Braşov BRAŞOV   45.6394198 25.5924023     RO-SITUR BAR DE ZI 4  
46867 46867 PRALLINI, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 0 8.7 GHV 1.4 1.4 1172 Mun. Braşov BRAŞOV   45.6604267 25.6140594     RO-SITUR BAR DE ZI 4 - STELE  
46899 46899 SWISSOTEL, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 9   banquet 0 0 50 0 45   80 20 13.2 GHV 7.8 5.4 219 Mun. Braşov BRAŞOV   45.588846 25.5537933     RO-SITUR BAR DE ZI 4  
46904 46904 THE VINTAGE PUB, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 0 8.7 GHV 1.1 1.1 1170 Mun. Braşov BRAŞOV   45.6451496 25.5930093     RO-SITUR BAR DE ZI 4 - STELE  
46911 46911 ACASA LA DRACULA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 20 12.4 GHV 6.7 5.1 287 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.5969445 25.5609009     RO-SITUR BAR DE ZI 4 - STELE  
46915 46915 ATHRIUM LOUNGE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 45   banquet 0 0 60 0 45   80 20 12.4 GHV 7.3 5.8 250 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.5955044 25.5513291     RO-SITUR BAR DE ZI 4  
46924 46924 CASA VIOREL, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 20 12.4 GHV 6.6 5.1 297 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.597786 25.5619193     RO-SITUR BAR DE ZI 4 - STELE  
46928 46928 CIGAR LOUNGE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 20 12.4 GHV 7.2 5.8 252 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.5962808 25.5512779     RO-SITUR BAR DE ZI 4 - STELE  
46933 46933 ESCALADE 2, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 20 12.2 GHV 7.0 5.8 266 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.5977233 25.5523932     RO-SITUR BAR DE ZI 4 - STELE  
46935 46935 FAVORIT - BOWLING, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 20 12.4 GHV 7.3 5.8 250 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.5955044 25.5513291     RO-SITUR BAR DE ZI 4 - STELE  
46937 46937 LOBBY BAR SPORT, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 20 12.7 GHV 7.3 5.5 243 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.5935681 25.5549924     RO-SITUR BAR DE ZI 4 - STELE  
46940 46940 MIRAJ, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 20 12.1 GHV 6.7 5.5 293 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.5990582 25.5573974     RO-SITUR BAR DE ZI 4 - STELE  
46941 46941 MIRAJ, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 20 12.1 GHV 6.7 5.5 293 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.5990582 25.5573974     RO-SITUR BAR DE ZI 4 - STELE  
46949 46949 PIATRA MARE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 20 12.5 GHV 7.5 6.0 239 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.5947093 25.5485191     RO-SITUR BAR DE ZI 4 - STELE  
46951 46951 PIATRA MARE - PISCINA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 20 12.5 GHV 7.5 6.0 239 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.5947093 25.5485191     RO-SITUR BAR DE ZI 4 - STELE  
46959 46959 RIZZO BOUTIQUE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 20 13.2 GHV 7.6 5.9 222 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.5881319 25.5473425     RO-SITUR BAR DE ZI 4 - STELE  
46963 46963 SiHA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 12   banquet 0 0 50 0 45   80 20 12.2 GHV 7.0 5.8 265 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.5981756 25.5523954     RO-SITUR BAR DE ZI 4  
46991 46991 HANUL MURESENILOR, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 0 18.9 GHV 1.2 1.2 56 Mun. Săcele BRAŞOV   45.6089602 25.7223254     RO-SITUR BAR DE ZI 4 - STELE  
46992 46992 HANUL MURESENILOR 2, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 0 18.9 GHV 1.2 1.2 56 Mun. Săcele BRAŞOV   45.6089602 25.7223254     RO-SITUR BAR DE ZI 4 - STELE  
47072 47072 GARDENIA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   70 10 25.9 GHV 15.0 2.9 400 Oraş Predeal BRAŞOV   45.4742381 25.5623289     RO-SITUR BAR DE ZI 4 - STELE  
47104 47104 ROZMARIN, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   70 0 21.8 GHV 12.3 1.4 348 Oraş Predeal BRAŞOV   45.5125271 25.5714637     RO-SITUR BAR DE ZI 4 - STELE  
47107 47107 ROZMARIN, CRAMĂ RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   70 0 21.8 GHV 12.3 1.4 348 Oraş Predeal BRAŞOV   45.5125271 25.5714637     RO-SITUR CRAMĂ 4 - STELE  
47149 47149 EDEL HOUSE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 0 13.0 GHV 1.8 1.8 152 Oraş Râşnov BRAŞOV   45.5963907 25.4639618     RO-SITUR BAR DE ZI 4 - STELE  
47197 47197 WOLF 2, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 0 20.4 GHV 5.4 0.3 343 Oraş Zărneşti BRAŞOV   45.5493591 25.3853652     RO-SITUR BAR DE ZI 4 - STELE  
47477 47477 PUB & CLUB CODA VINCI, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   65 0 32.1 CSB 0.8 0.8 70 Mun. Reşiţa CARAŞ-SEVERIN   45.2969089 21.881118     RO-SITUR BAR DE ZI 4 - STELE  
47503 47503 CERNA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE 40   banquet 0 0 50 0 45   45 0 60.8 CSB 34.1 1.2 215 Oraş Băile Herculane CARAŞ-SEVERIN   44.8867276 22.4240877     RO-SITUR BAR DE ZI 2 - STELE  
47581 47581 SUNGARDEN RESORT, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   70 20 15.5 CLJ 10.0 2.4 12 Com. Baciu CLUJ   46.8108691 23.4856338     RO-SITUR BAR DE ZI 5 - STELE  
47583 47583 VENEZIA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 0 12.4 CLJ 6.5 0.9 209 Com. Baciu CLUJ   46.7934309 23.5236679     RO-SITUR BAR DE ZI 5 - STELE  
47604 47604 WONDERLAND, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 10 10.2 CLJ 5.1 2.1 343 Com. Feleacu CLUJ   46.7215052 23.5898268     RO-SITUR BAR DE ZI 4 - STELE  
47630 47630 WEST CITY, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 0 15.0 CLJ 8.2 0.3 135 Com. Floreşti CLUJ   46.7457892 23.4974304     RO-SITUR BAR DE ZI 4 - STELE  
47698 47698 360 SPA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 0 5.0 CLJ 1.9 1.9 1152 Mun. Cluj-Napoca CLUJ   46.7712101 23.6236353     RO-SITUR BAR DE ZI 4 - STELE  
47730 47730 ASTORIA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 0 7.7 CLJ 1.4 1.4 1219 Mun. Cluj-Napoca CLUJ   46.7749566 23.5854757     RO-SITUR BAR DE ZI 4 - STELE  
47740 47740 AVOCADO LOUNGE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 0 5.0 CLJ 1.9 1.9 1152 Mun. Cluj-Napoca CLUJ   46.7712101 23.6236353     RO-SITUR BAR DE ZI 4 - STELE  
47751 47751 BELVEDERE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 0 8.1 CLJ 1.9 1.9 1213 Mun. Cluj-Napoca CLUJ   46.776479 23.5802671     RO-SITUR BAR DE ZI 4 - STELE  
47759 47759 BEYFIN, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 0 7.0 CLJ 0.6 0.6 1219 Mun. Cluj-Napoca CLUJ   46.7711111 23.5961111     RO-SITUR BAR DE ZI 4 - STELE  
47767 47767 BLACK TULIP, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   70 0 3.7 CLJ 10.6 0.7 35 Mun. Cluj-Napoca CLUJ   46.7899081 23.734572     RO-SITUR BAR DE ZI 4 - STELE  
47799 47799 CASA ALBA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 0 7.7 CLJ 1.6 1.6 1218 Mun. Cluj-Napoca CLUJ   46.7767378 23.5848833     RO-SITUR BAR DE ZI 4 - STELE  
47888 47888 ERATTO, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 15   banquet 0 0 50 0 45   80 10 10.5 CLJ 4.9 3.0 515 Mun. Cluj-Napoca CLUJ   46.7251457 23.5798925     RO-SITUR BAR DE ZI 4  
47911 47911 GOLDEN TULIP ANA DOME, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 10 9.1 CLJ 2.4 2.4 1173 Mun. Cluj-Napoca CLUJ   46.7518647 23.5772424     RO-SITUR BAR DE ZI 4 - STELE  
47917 47917 GRAND ITALIA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 0 7.1 CLJ 1.7 1.7 1222 Mun. Cluj-Napoca CLUJ   46.7520955 23.6060333     RO-SITUR BAR DE ZI 5 - STELE  
47997 47997 LOBBY, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 0 6.6 CLJ 0.4 0.4 1227 Mun. Cluj-Napoca CLUJ   46.7652447 23.6050962     RO-SITUR BAR DE ZI 5 - STELE  
48050 48050 OPAL, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 0 6.2 CLJ 1.2 1.2 1205 Mun. Cluj-Napoca CLUJ   46.7602548 23.613419     RO-SITUR BAR DE ZI 4 - STELE  
48053 48053 OPERA PLAZA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 0 6.8 CLJ 0.3 0.3 1226 Mun. Cluj-Napoca CLUJ   46.7688698 23.6005709     RO-SITUR BAR DE ZI 5 - STELE  
48070 48070 PARADIS, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 0 5.6 CLJ 1.8 1.8 1159 Mun. Cluj-Napoca CLUJ   46.7800646 23.6132856     RO-SITUR BAR DE ZI 4 - STELE  
48091 48091 RADISSON BLUE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 10 8.8 CLJ 2.0 2.0 1212 Mun. Cluj-Napoca CLUJ   46.7675542 23.5735682     RO-SITUR BAR DE ZI 4 - STELE  
48101 48101 RIVIERA, TERASĂ RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 0 7.3 CLJ 1.3 1.3 1215 Mun. Cluj-Napoca CLUJ   46.7763135 23.5903666     RO-SITUR TERASĂ 4 - STELE  
48158 48158 SYNDICATE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 40   banquet 0 0 60 0 45   80 0 7.9 CLJ 1.2 1.2 1227 Mun. Cluj-Napoca CLUJ   46.769805 23.584261     RO-SITUR BAR DE ZI 4  
48235 48235 INFANTE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 10   banquet 0 0 50 0 45   80 10 11.5 Câmpia Turzii Air Base 2.3 2.3 100 Mun. Turda CLUJ   46.5856067 23.7966332     RO-SITUR BAR DE ZI 4  
48240 48240 PRINTUL VANATOR, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 0 10.9 Câmpia Turzii Air Base 0.7 0.7 105 Mun. Turda CLUJ   46.5724553 23.7870053     RO-SITUR BAR DE ZI 5 - STELE  
48279 48279 CASA TARANEASCĂ, TERASĂ RO eat_drink bars_pubs bar_pub normal 1 star 1 - STELE 330   banquet 0 0 70 0 65   55 0 47.9 CND 15.1 0.6 811 Com. Costineşti CONSTANŢA   43.9451161 28.6369006     RO-SITUR TERASĂ 1 - STELE  
48348 48348 CHARM, TERASĂ RO eat_drink bars_pubs bar_pub normal 2 star 2 STELE 150   banquet 0 0 70 0 65   55 0 46.5 CND 16.8 1.3 825 Com. Costineşti, Sat Costineşti CONSTANŢA   43.9590015 28.6435257     RO-SITUR TERASĂ 2 STELE  
48487 48487 BAR CONSTANŢA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 0 24.5 CND 1.5 1.5 642 Mun. Constanţa CONSTANŢA   44.1759147 28.6519359     RO-SITUR BAR DE ZI 4 - STELE  
48489 48489 BAVARIA BLU, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 10 19.7 CND 4.4 2.9 1000 Mun. Constanţa CONSTANŢA   44.2200014 28.6350977     RO-SITUR BAR DE ZI 4 - STELE  
48502 48502 BUDDHA BAR, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 0 24.5 CND 1.6 1.6 651 Mun. Constanţa CONSTANŢA   44.1767469 28.6536425     RO-SITUR BAR DE ZI 5 - STELE  
48513 48513 CAROL, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 0 24.2 CND 1.5 1.5 672 Mun. Constanţa CONSTANŢA   44.1789096 28.6527281     RO-SITUR BAR DE ZI 4 - STELE  
48527 48527 CHARM, BAR DE ZI RO eat_drink bars_pubs bar_pub normal   none   40   banquet 0 0 50 0 45   80 10 22.4 CND 2.9 2.9 776 Mun. Constanţa CONSTANŢA   44.201348 28.656871     RO-SITUR BAR DE ZI    
48570 48570 GREEN HOUSE, TERASĂ RO eat_drink bars_pubs bar_pub normal 2 star 2 stele 96   banquet 0 0 60 0 55   80 10 19.9 CND 3.8 2.8 931 Mun. Constanţa CONSTANŢA   44.2149798 28.6303916     RO-SITUR TERASĂ 2 stele  
48635 48635 MONDIAL, CRAMĂ RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 0 24.5 CND 1.5 1.5 642 Mun. Constanţa CONSTANŢA   44.1759147 28.6519359     RO-SITUR CRAMĂ 4 - STELE  
48646 48646 OPOSSUM, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 10 21.0 CND 2.6 2.6 860 Mun. Constanţa CONSTANŢA   44.2038081 28.6323331     RO-SITUR BAR DE ZI 5 - STELE  
48651 48651 PIANO BAR, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE 45   banquet 0 0 60 0 45   80 10 20.9 CND 3.5 3.5 873 Mun. Constanţa CONSTANŢA   44.2112327 28.6450222     RO-SITUR BAR DE ZI 4 - STELE  
48720 48720 VOILA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 0 24.7 CND 1.9 1.9 616 Mun. Constanţa CONSTANŢA   44.1764329 28.6573739     RO-SITUR BAR DE ZI 4 - STELE  
48733 48733 AMIRAL, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 10 15.4 CND 6.4 3.8 1783 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.2607202 28.6194491     RO-SITUR BAR DE ZI 4 - STELE  
48758 48758 BELINDA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 0 18.4 CND 5.3 1.9 948 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.2282474 28.6249708     RO-SITUR BAR DE ZI 4 - STELE  
48792 48792 CONDOR, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 0 17.6 CND 6.3 2.0 1029 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.2365444 28.62345     RO-SITUR BAR DE ZI 4 - STELE  
48809 48809 DEL MAR MAMAIA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE 20   banquet 0 0 50 0 45   80 10 15.2 CND 6.2 4.0 1841 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.2623995 28.6187463     RO-SITUR BAR DE ZI 4 - STELE  
48831 48831 FIZZ, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 STELE 65   banquet 0 0 60 0 55   80 10 15.2 CND 6.2 4.0 1841 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.2623995 28.6187463     RO-SITUR BAR DE ZI 4 STELE  
48900 48900 MAMAIA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 10 15.2 CND 6.2 4.0 1841 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.2623995 28.6187463     RO-SITUR BAR DE ZI 5 - STELE  
48945 48945 PALAS, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 10 25.2 CND 2.4 2.4 527 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.1731722 28.6627174     RO-SITUR BAR DE ZI 4 - STELE  
48960 48960 PIANO BAR, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 10 19.8 CND 4.2 2.9 918 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.2183558 28.6350359     RO-SITUR BAR DE ZI 4 - STELE  
49008 49008 SAVOY, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 10 15.3 CND 6.3 4.0 1841 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.262147 28.619991     RO-SITUR BAR DE ZI 4 - STELE  
49045 49045 THE LOBBY, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE 40   banquet 0 0 50 0 45   80 10 15.2 CND 6.2 4.0 1841 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.2623995 28.6187463     RO-SITUR BAR DE ZI 2 - STELE  
49058 49058 VATRA ROMÂNEASCĂ, TERASĂ RO eat_drink bars_pubs bar_pub normal 2 star 2 STELE 88   banquet 0 0 60 0 55   80 10 15.2 CND 6.2 4.0 1841 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.2623995 28.6187463     RO-SITUR TERASĂ 2 STELE  
49068 49068 ENJOY PIZZA, TERASĂ RO eat_drink bars_pubs bar_pub normal 2 star 2 STELE 180   banquet 0 0 70 0 65   80 10 19.6 CND 4.2 2.7 908 Mun. Constanţa, Sat Vacanță - Zona Luna Park - Lot 4 CONSTANŢA   44.2182610611448 28.631403589991     RO-SITUR TERASĂ 2 STELE  

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