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

670 rows where family = "bars_pubs", group = "eat_drink" and rating_value = 4

This data as json, CSV (advanced)

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

country 3

best_for 2

rating_value 1

group 1

  • eat_drink · 670 ✖

family 1

  • bars_pubs · 670 ✖

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
45654 45654 BOWLING CONTINENTAL, BAR DE NOAPTE RO eat_drink bars_pubs nightclub normal 4 star 4 - STELE     party 0 0 50 0 60   80 0 4.2 ARW 1.1 1.1 406 Mun. Arad ARAD   46.1734795 21.318392     RO-SITUR BAR DE NOAPTE 4 - STELE  
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  
46299 46299 CLUB DARK, CLUB SAU DISCO-BAR RO eat_drink bars_pubs nightclub normal 4 star 4 - STELE     party 0 0 50 0 60   80 0 7.1 OMR 7.8 1.5 410 Com. Sânmartin, Sat Băile Felix BIHOR   46.9899236 21.9803673     RO-SITUR CLUB SAU DISCO-BAR 4 - 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  
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  
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  
46837 46837 KASHO, CLUB SAU DISCO-BAR RO eat_drink bars_pubs nightclub normal 4 star 4 - STELE     party 0 0 50 0 60   80 0 8.3 GHV 1.5 1.5 1163 Mun. Braşov BRAŞOV   45.6459698 25.5867694     RO-SITUR CLUB SAU DISCO-BAR 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  
46968 46968 THE TEAM, CLUB SAU DISCO-BAR RO eat_drink bars_pubs nightclub normal 4 star 4 119   party 0 0 70 0 80   55 0 41.9 GHV 13.4 0.4 206 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.730116 24.983845     RO-SITUR CLUB SAU DISCO-BAR 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  
47106 47106 ROZMARIN, CLUB SAU DISCO-BAR RO eat_drink bars_pubs nightclub normal 4 star 4 - STELE     party 0 0 50 0 60   70 0 21.8 GHV 12.3 1.4 348 Oraş Predeal BRAŞOV   45.5125271 25.5714637     RO-SITUR CLUB SAU DISCO-BAR 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  
47476 47476 PUB & CLUB CODA VINCI, CLUB SAU DISCO-BAR RO eat_drink bars_pubs nightclub normal 4 star 4 - STELE     party 0 0 50 0 60   65 0 32.1 CSB 0.8 0.8 70 Mun. Reşiţa CARAŞ-SEVERIN   45.2969089 21.881118     RO-SITUR CLUB SAU DISCO-BAR 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  
47506 47506 DACIA, BAR DE NOAPTE RO eat_drink bars_pubs nightclub normal 4 star 4 - STELE     party 0 0 50 0 60   45 0 62.6 CSB 33.0 1.0 215 Oraş Băile Herculane CARAŞ-SEVERIN   44.8681802 22.4085127     RO-SITUR BAR DE NOAPTE 4 - STELE  
47547 47547 SFINXUL BANATEAN, BAR DE NOAPTE RO eat_drink bars_pubs nightclub normal 4 star 4 - STELE     party 0 0 50 0 60   45 0 62.6 CSB 33.0 1.0 215 Oraş Băile Herculane CARAŞ-SEVERIN   44.8681802 22.4085127     RO-SITUR BAR DE NOAPTE 4 - 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  
48049 48049 OPAL, BAR DE NOAPTE RO eat_drink bars_pubs nightclub normal 4 star 4 - STELE     party 0 0 50 0 60   80 0 6.2 CLJ 1.2 1.2 1205 Mun. Cluj-Napoca CLUJ   46.7602548 23.613419     RO-SITUR BAR DE NOAPTE 4 - 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  
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  
48150 48150 SUGAR CLUB TABLE DANCE, BAR DE NOAPTE RO eat_drink bars_pubs nightclub normal 4 star 4 - STELE     party 0 0 50 0 60   80 0 7.7 CLJ 1.1 1.1 1222 Mun. Cluj-Napoca CLUJ   46.7718846 23.587014     RO-SITUR BAR DE NOAPTE 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  
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  
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  
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  
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  
48884 48884 LE GAGA, CLUB SAU DISCO-BAR RO eat_drink bars_pubs nightclub normal 4 star 4 - STELE     party 0 0 50 0 60   80 10 15.2 CND 6.2 4.0 1841 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.2623995 28.6187463     RO-SITUR CLUB SAU DISCO-BAR 4 - STELE  
48893 48893 LUV, CLUB SAU DISCO-BAR RO eat_drink bars_pubs nightclub normal 4 star 4 - STELE     party 0 0 50 0 60   80 10 18.1 CND 5.8 2.1 1032 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.2327609 28.6266274     RO-SITUR CLUB SAU DISCO-BAR 4 - 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  
48980 48980 PRINCESS CLUB, CLUB SAU DISCO-BAR RO eat_drink bars_pubs nightclub normal 4 star 4 - STELE     party 0 0 50 0 60   80 10 17.5 CND 6.5 2.2 1033 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.239034 28.625328     RO-SITUR CLUB SAU DISCO-BAR 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  
49070 49070 AFRODITA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   65 10 57.5 Balchik Airfield 3.5 3.0 985 Mun. Mangalia CONSTANŢA   43.8439824 28.5976672     RO-SITUR BAR DE ZI 4 - STELE  
49075 49075 ALCATRAZ, CLUB SAU DISCO-BAR RO eat_drink bars_pubs nightclub normal 4 star 4 - STELE     party 0 0 50 0 60   65 0 53.8 Balchik Airfield 0.2 0.2 776 Mun. Mangalia CONSTANŢA   43.8152436 28.5741496     RO-SITUR CLUB SAU DISCO-BAR 4 - STELE  
49164 49164 MERA BRISE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   65 0 54.1 Balchik Airfield 0.8 0.8 773 Mun. Mangalia CONSTANŢA   43.8126356 28.5853857     RO-SITUR BAR DE ZI 4 - STELE  
49185 49185 PISCINA MERA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   65 0 54.1 Balchik Airfield 0.8 0.8 773 Mun. Mangalia CONSTANŢA   43.8126356 28.5853857     RO-SITUR BAR DE ZI 4 - STELE  
49193 49193 RECEPTIE MERA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   65 0 54.1 Balchik Airfield 0.8 0.8 773 Mun. Mangalia CONSTANŢA   43.8126356 28.5853857     RO-SITUR BAR DE ZI 4 - STELE  
49220 49220 MERA ONIX, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   65 10 57.7 CND 4.3 2.4 995 Mun. Mangalia, Loc. Cap Aurora CONSTANŢA   43.8495673 28.6028724     RO-SITUR BAR DE ZI 4 - STELE  
49265 49265 POSEIDON, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   65 0 56.1 CND 5.9 0.7 723 Mun. Mangalia, Loc. Jupiter CONSTANŢA   43.8651409 28.6050511     RO-SITUR BAR DE ZI 4 - 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");