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

1,964 rows where family = "bars_pubs", group = "eat_drink" and rating_value = 2

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), stop_date (date)

country 2

best_for 2

rating_value 1

  • 2 · 1,964 ✖

group 1

  • eat_drink · 1,964 ✖

family 1

  • bars_pubs · 1,964 ✖

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
45491 45491 NUŢA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   55 40 46.8 SBZ 17.9 15.9 8 Com. Şugag ALBA   45.5707961 23.5694096     RO-SITUR BAR DE ZI 2 - STELE  
45505 45505 BIP, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   65 0 50.5 SBZ 0.8 0.8 191 Mun. Alba Iulia ALBA   46.0732725 23.5804886     RO-SITUR BAR DE ZI 2 - STELE  
45507 45507 CETATE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   65 0 50.9 SBZ 1.1 1.1 191 Mun. Alba Iulia ALBA   46.0688966 23.5688882     RO-SITUR BAR DE ZI 2 - STELE  
45593 45593 CODRU MOMA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   45 0 68.3 OMR 54.6 1.2 36 Com. Moneasa ARAD   46.4603468 22.2535709     RO-SITUR BAR DE ZI 2 - STELE  
45617 45617 GIOVANNI, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   40 20 90.9 OMR 29.0 0.1 3 Com. Vârfurile ARAD   46.3436132 22.5600489     RO-SITUR BAR DE ZI 2 - STELE  
45618 45618 GIOVANNI, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   40 20 90.9 OMR 29.0 0.1 3 Com. Vârfurile, Sat Lazuri ARAD   46.3436132 22.5600489     RO-SITUR BAR DE ZI 2 - STELE  
45642 45642 ARIZONA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 10 7.2 ARW 5.1 3.7 221 Mun. Arad ARAD   46.1419298 21.3443804     RO-SITUR BAR DE ZI 2 - STELE  
45665 45665 CARTURESTI, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 4.6 ARW 0.8 0.8 400 Mun. Arad ARAD   46.1905128 21.320372     RO-SITUR BAR DE ZI 2 - STELE  
45669 45669 CATANGA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 3.9 ARW 1.9 1.9 401 Mun. Arad ARAD   46.1664915 21.3125355     RO-SITUR BAR DE ZI 2 - STELE  
45675 45675 CINEMA CITY, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 4.6 ARW 0.9 0.9 397 Mun. Arad ARAD   46.1911615 21.3205304     RO-SITUR BAR DE ZI 2 - STELE  
45676 45676 CLUB DEJA-VU, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 3.7 ARW 0.7 0.7 404 Mun. Arad ARAD   46.1876719 21.3098488     RO-SITUR BAR DE ZI 2 - STELE  
45677 45677 CLUB SALOMEEA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 3.7 ARW 1.3 1.3 409 Mun. Arad ARAD   46.1720548 21.3120264     RO-SITUR BAR DE ZI 2 - STELE  
45684 45684 COMPACT ZIMAR, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 3.8 ARW 1.3 1.3 402 Mun. Arad ARAD   46.1929459 21.3066671     RO-SITUR BAR DE ZI 2 - STELE  
45693 45693 DANIELA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 10 3.9 ARW 2.5 2.5 359 Mun. Arad ARAD   46.202194 21.2982475     RO-SITUR BAR DE ZI 2 - STELE  
45706 45706 G & G, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 3.7 ARW 1.4 1.4 405 Mun. Arad ARAD   46.1717377 21.3115509     RO-SITUR BAR DE ZI 2 - STELE  
45712 45712 GIOIA CAFFE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 3.6 ARW 0.9 0.9 412 Mun. Arad ARAD   46.1758152 21.3116258     RO-SITUR BAR DE ZI 2 - STELE  
45719 45719 GREEN CLUB, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 10 3.6 ARW 2.4 2.4 368 Mun. Arad ARAD   46.1995207 21.2960081     RO-SITUR BAR DE ZI 2 - STELE  
45724 45724 HELEN BAR, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 4.2 ARW 0.8 0.8 411 Mun. Arad ARAD   46.1765341 21.3194178     RO-SITUR BAR DE ZI 2 - STELE  
45725 45725 HELEN BAR, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 3.6 ARW 0.5 0.5 410 Mun. Arad ARAD   46.1822356 21.3101443     RO-SITUR BAR DE ZI 2 - STELE  
45737 45737 KATOMIC, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 3.3 ARW 1.2 1.2 400 Mun. Arad ARAD   46.1884501 21.3027758     RO-SITUR BAR DE ZI 2 - STELE  
45743 45743 LA COFFE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 10 6.3 ARW 2.4 2.4 392 Mun. Arad ARAD   46.1773401 21.3465185     RO-SITUR BAR DE ZI 2 - STELE  
45747 45747 LA NEA NICU, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 10 6.7 ARW 4.6 4.2 247 Mun. Arad ARAD   46.1447969 21.3392449     RO-SITUR BAR DE ZI 2 - STELE  
45755 45755 LOTUS, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 3.9 ARW 0.5 0.5 408 Mun. Arad ARAD   46.1865606 21.3122677     RO-SITUR BAR DE ZI 2 - STELE  
45758 45758 M.C. CAFFE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 3.0 ARW 1.3 1.3 401 Mun. Arad ARAD   46.1850002 21.300528     RO-SITUR BAR DE ZI 2 - STELE  
45759 45759 MAGNUM, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 4.5 ARW 0.4 0.4 410 Mun. Arad ARAD   46.1814148 21.321785     RO-SITUR BAR DE ZI 2 - STELE  
45760 45760 MALINA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 3.6 ARW 1.2 1.2 403 Mun. Arad ARAD   46.1909619 21.3062964     RO-SITUR BAR DE ZI 2 - STELE  
45763 45763 MAX AGREMENT, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 10 2.8 ARW 2.4 2.4 394 Mun. Arad ARAD   46.1661563 21.2971701     RO-SITUR BAR DE ZI 2 - STELE  
45766 45766 MEBO GAMES, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 3.8 ARW 1.0 1.0 410 Mun. Arad ARAD   46.1747527 21.3134474     RO-SITUR BAR DE ZI 2 - STELE  
45774 45774 MORRISON, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 4.2 ARW 1.7 1.7 405 Mun. Arad ARAD   46.16853 21.3179334     RO-SITUR BAR DE ZI 2 - STELE  
45776 45776 MULTI GAME, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 3.9 ARW 0.5 0.5 408 Mun. Arad ARAD   46.1865606 21.3122677     RO-SITUR BAR DE ZI 2 - STELE  
45779 45779 NETMAN BAR, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 3.6 ARW 0.5 0.5 410 Mun. Arad ARAD   46.1822356 21.3101443     RO-SITUR BAR DE ZI 2 - STELE  
45780 45780 NICO, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 3.9 ARW 1.5 1.5 404 Mun. Arad ARAD   46.1703406 21.3142472     RO-SITUR BAR DE ZI 2 - STELE  
45785 45785 OLD LADYS PUB, BERĂRIE RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 3.9 ARW 1.5 1.5 398 Mun. Arad ARAD   46.1946626 21.3070794     RO-SITUR BERĂRIE 2 - STELE  
45786 45786 ONE MORE BEER, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 3.7 ARW 1.3 1.3 409 Mun. Arad ARAD   46.172361 21.311627     RO-SITUR BAR DE ZI 2 - STELE  
45789 45789 ORIZOR, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 3.3 ARW 1.7 1.7 409 Mun. Arad ARAD   46.170277 21.306058     RO-SITUR BAR DE ZI 2 - STELE  
45797 45797 PISICA ALBA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 10 3.4 ARW 2.2 2.2 375 Mun. Arad ARAD   46.1968834 21.2965982     RO-SITUR BAR DE ZI 2 - STELE  
45798 45798 PISICA ALBASTRA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 4.7 ARW 0.6 0.6 408 Mun. Arad ARAD   46.1860827 21.3236862     RO-SITUR BAR DE ZI 2 - STELE  
45807 45807 PLAY & GO, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 4.8 ARW 0.8 0.8 410 Mun. Arad ARAD   46.1819508 21.3265943     RO-SITUR BAR DE ZI 2 - STELE  
45810 45810 POPEY CHICKEN, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 3.9 ARW 0.5 0.5 408 Mun. Arad ARAD   46.1865606 21.3122677     RO-SITUR BAR DE ZI 2 - STELE  
45819 45819 RANDUNICA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 10 6.6 ARW 3.0 3.0 380 Mun. Arad ARAD   46.1695417 21.3499197     RO-SITUR BAR DE ZI 2 - STELE  
45820 45820 RANOLIMITS, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 10 6.3 ARW 2.4 2.4 392 Mun. Arad ARAD   46.177186 21.3466733     RO-SITUR BAR DE ZI 2 - STELE  
45833 45833 RO SERVICE INTERNATIONAL, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 2.3 ARW 1.8 1.8 402 Mun. Arad ARAD   46.1805178 21.293298     RO-SITUR BAR DE ZI 2 - STELE  
45838 45838 ROZA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 4.9 ARW 1.5 1.5 395 Mun. Arad ARAD   46.1964373 21.3204628     RO-SITUR BAR DE ZI 2 - STELE  
45846 45846 SMART CAFFE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 4.2 ARW 1.3 1.3 405 Mun. Arad ARAD   46.171518 21.318419     RO-SITUR BAR DE ZI 2 - STELE  
45860 45860 TURIST, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 4.9 ARW 1.0 1.0 401 Mun. Arad ARAD   46.1900002 21.3247147     RO-SITUR BAR DE ZI 2 - STELE  
45861 45861 VALLORY CAFFE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 3.9 ARW 0.5 0.5 408 Mun. Arad ARAD   46.1865606 21.3122677     RO-SITUR BAR DE ZI 2 - STELE  
45863 45863 VEGAS, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 10 6.0 ARW 2.1 2.1 389 Mun. Arad ARAD   46.176775 21.342364     RO-SITUR BAR DE ZI 2 - STELE  
45868 45868 VOINICUL, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 10 7.0 ARW 3.3 3.3 377 Mun. Arad ARAD   46.1714047 21.3556087     RO-SITUR BAR DE ZI 2 - STELE  
45873 45873 ZARAZA CLUB, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 3.9 ARW 1.5 1.5 404 Mun. Arad ARAD   46.17021 21.313815     RO-SITUR BAR DE ZI 2 - STELE  
45875 45875 OLYMPIA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   55 20 39.2 ARW 24.8 0.8 4 Oraş Chişineu-Criş ARAD   46.4869454 21.50441     RO-SITUR BAR DE ZI 2 - STELE  
45929 45929 GARDEN VILLAGE RETREAT, TERASĂ RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   45 0 59.3 GHV 33.3 0.9 79 Com. Bughea de Sus ARGEŞ   45.3031374 25.024535     RO-SITUR TERASĂ 2 - STELE  
45931 45931 LAC CĂLINEŞTI, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   40 20 88.7 OTP 13.9 1.5 5 Com. Călineşti ARGEŞ   44.8290314 25.0402574     RO-SITUR BAR DE ZI 2 - STELE  
45983 45983 LA MESERIE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   45 20 54.9 GHV 33.0 2.1 14 Com. Valea Mare Pravăţ ARGEŞ   45.2921638 25.1385822     RO-SITUR BAR DE ZI 2 - STELE  
45991 45991 ELYON, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   45 0 61.4 GHV 32.5 0.6 72 Mun. Câmpulung ARGEŞ   45.2679572 25.043157     RO-SITUR BAR DE ZI 2 - STELE  
46015 46015 SIMA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   50 10 83.5 SBZ 2.9 2.9 81 Mun. Curtea de Argeş ARGEŞ   45.1600254 24.6781356     RO-SITUR BAR DE ZI 2 - STELE  
46041 46041 PANORAMIC LITORAL, TERASĂ RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   50 0 98.1 CRA 0.7 0.7 142 Mun. Piteşti ARGEŞ   44.8564798 24.8691824     RO-SITUR TERASĂ 2 - STELE  
46070 46070 KITTY PANZIO, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 10 19.7 BCM 7.3 0.5 6 Com. Gârleni BACĂU   46.6673388 26.7632177     RO-SITUR BAR DE ZI 2 - STELE  
46091 46091 REGENS, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 10 4.8 BCM 9.9 1.5 12 Com. Nicolae Bălcescu, Sat Nicolae Bălcescu BACĂU   46.4784689 26.9069585     RO-SITUR BAR DE ZI 2 - STELE  
46093 46093 LA CAPU DACULUI, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   70 20 27.3 BCM 25.3 1.7 5 Com. Orbeni BACĂU   46.282463 26.9870163     RO-SITUR BAR DE ZI 2 - STELE  
46125 46125 ROSTRA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 5.7 BCM 0.8 0.8 143 Mun. Bacău BACĂU   46.5725449 26.921148     RO-SITUR BAR DE ZI 2 - STELE  
46167 46167 EXPRES, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   55 10 49.9 BCM 23.4 2.8 107 Oraş Slănic Moldova BACĂU   46.2113129 26.4414659     RO-SITUR BAR DE ZI 2 - STELE  
46169 46169 FLORA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   55 10 50.5 BCM 23.8 3.4 115 Oraş Slănic Moldova BACĂU   46.206909 26.436186     RO-SITUR BAR DE ZI 2 - STELE  
46190 46190 VENUS, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   55 10 50.4 BCM 23.8 3.3 115 Oraş Slănic Moldova BACĂU   46.2073804 26.4374755     RO-SITUR BAR DE ZI 2 - STELE  
46195 46195 MAGURA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   55 0 35.6 BCM 20.5 0.5 55 Oraş Târgu Ocna BACĂU   46.2793615 26.6063916     RO-SITUR BAR DE ZI 2 - STELE  
46224 46224 CAMELOT, TERASĂ RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   70 20 14.1 OMR 12.1 0.3 3 Com. Ineu, Sat Husasău de Criş BIHOR   47.084238 22.0672894     RO-SITUR TERASĂ 2 - STELE  
46234 46234 PALEUS RESORT, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 9.7 OMR 7.2 1.8 54 Com. Paleu BIHOR   47.1087595 21.9374654     RO-SITUR BAR DE ZI 2 - STELE  
46235 46235 PALEUS RESORT, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 9.7 OMR 7.2 1.8 54 Com. Paleu BIHOR   47.1087595 21.9374654     RO-SITUR BAR DE ZI 2 - STELE  
46236 46236 PALEUS RESORT, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 9.7 OMR 7.2 1.8 54 Com. Paleu BIHOR   47.1087595 21.9374654     RO-SITUR BAR DE ZI 2 - STELE  
46237 46237 ANISOARA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   45 30 70.8 OMR 55.4 6.1 9 Com. Pietroasa BIHOR   46.6187097 22.6180114     RO-SITUR BAR DE ZI 2 - STELE  
46262 46262 CERES, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 8.0 OMR 8.3 0.1 410 Com. Sânmartin BIHOR   46.9958478 21.9994371     RO-SITUR BAR DE ZI 2 - STELE  
46265 46265 CRIŞANA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 4.9 OMR 5.2 0.9 466 Com. Sânmartin BIHOR   47.0112985 21.9638488     RO-SITUR BAR DE ZI 2 - STELE  
46269 46269 EVOLUTION, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 5.9 OMR 6.3 0.5 431 Com. Sânmartin BIHOR   47.0026385 21.9722313     RO-SITUR BAR DE ZI 2 - STELE  
46293 46293 APOLLO, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 7.1 OMR 7.8 1.5 410 Com. Sânmartin, Sat Băile Felix BIHOR   46.9899236 21.9803673     RO-SITUR BAR DE ZI 2 - STELE  
46305 46305 MUNCEL, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 7.3 OMR 8.1 1.4 409 Com. Sânmartin, Sat Băile Felix BIHOR   46.988122 21.9824821     RO-SITUR BAR DE ZI 2 - STELE  
46307 46307 MURES, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 7.1 OMR 7.8 1.5 410 Com. Sânmartin, Sat Băile Felix BIHOR   46.9899236 21.9803673     RO-SITUR BAR DE ZI 2 - STELE  
46313 46313 PADIS, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 7.2 OMR 8.0 1.7 409 Com. Sânmartin, Sat Băile Felix BIHOR   46.9869978 21.9786095     RO-SITUR BAR DE ZI 2 - STELE  
46323 46323 STRAND MUNCEL, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 7.3 OMR 8.1 1.4 409 Com. Sânmartin, Sat Băile Felix BIHOR   46.988122 21.9824821     RO-SITUR BAR DE ZI 2 - STELE  
46328 46328 VALENTINO CAFFEE TERASĂ& LOUNGE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 7.1 OMR 7.8 1.5 410 Com. Sânmartin, Sat Băile Felix BIHOR   46.9899236 21.9803673     RO-SITUR BAR DE ZI 2 - STELE  
46390 46390 SCORPION, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 10 5.8 OMR 3.7 3.7 329 Mun. Oradea BIHOR   47.0770595 21.9002689     RO-SITUR BAR DE ZI 2 - STELE  
46393 46393 SKY, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 10 4.4 OMR 4.0 2.1 590 Mun. Oradea BIHOR   47.0241565 21.9608412     RO-SITUR BAR DE ZI 2 - STELE  
46394 46394 SKY, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 10 4.4 OMR 4.0 2.1 590 Mun. Oradea BIHOR   47.0241565 21.9608412     RO-SITUR BAR DE ZI 2 - STELE  
46395 46395 SKY GARDEN, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 2.7 OMR 0.1 0.1 369 Mun. Oradea BIHOR   47.0465005 21.9189438     RO-SITUR BAR DE ZI 2 - STELE  
46396 46396 SKY GARDEN, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 2.7 OMR 0.1 0.1 369 Mun. Oradea BIHOR   47.0465005 21.9189438     RO-SITUR BAR DE ZI 2 - STELE  
46415 46415 PARADISE POINT, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   30 20 81.8 OMR 42.9 7.4 38 Oraş Nucet BIHOR   46.5115589 22.6716292     RO-SITUR BAR DE ZI 2 - STELE  
46443 46443 COSTAS, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   40 0 87.2 TGM 20.3 0.3 22 Com. Prundu Bârgăului BISTRIŢA-NĂSĂUD   47.2196773 24.7372329     RO-SITUR BAR DE ZI 2 - STELE  
46484 46484 OLD SHERIFF, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   65 0 76.6 CLJ 4.0 0.3 86 Mun. Bistriţa BISTRIŢA-NĂSĂUD   47.1629666 24.5307416     RO-SITUR BAR DE ZI 2 - STELE  
46494 46494 TRAIANUS, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   65 0 73.5 CLJ 0.8 0.8 93 Mun. Bistriţa BISTRIŢA-NĂSĂUD   47.1329018 24.5104153     RO-SITUR BAR DE ZI 2 - STELE  
46505 46505 HEBE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   40 10 95.3 BAY 29.6 0.7 15 Oraş Sângeorz-Băi BISTRIŢA-NĂSĂUD   47.3753428 24.6627441     RO-SITUR BAR DE ZI 2 - STELE  
46556 46556 FLORA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   65 0 67.4 TCE 9.0 0.3 27 Com. Chiscani, Sat Lacu Sărat BRĂILA   45.220328 27.8851026     RO-SITUR BAR DE ZI 2 - STELE  
46558 46558 LACU SARAT, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   65 0 67.4 TCE 9.0 0.3 27 Com. Chiscani, Sat Lacu Sărat BRĂILA   45.220328 27.8851026     RO-SITUR BAR DE ZI 2 - STELE  
46562 46562 PERLA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   65 0 67.4 TCE 9.0 0.3 27 Com. Chiscani, Sat Lacu Sărat BRĂILA   45.220328 27.8851026     RO-SITUR BAR DE ZI 2 - STELE  
46599 46599 TRAIAN, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   65 0 62.4 TCE 0.1 0.1 90 Mun. Brăila BRĂILA   45.27155 27.97549     RO-SITUR BAR DE ZI 2 - STELE  
46647 46647 SELECT HOLIDAY VILLAS, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 22.8 GHV 7.7 1.0 368 Com. Bran, Sat Sohodol BRAŞOV   45.5199897 25.3981109     RO-SITUR BAR DE ZI 2 - STELE  
46739 46739 ZARAGOZA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   55 20 33.4 GHV 13.1 0.0 2 Com. Şercaia BRAŞOV   45.8332139 25.1335324     RO-SITUR BAR DE ZI 2 - STELE  
46750 46750 CAZARE MDM, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   55 10 45.2 SBZ 24.1 0.1 12 Com. Ucea BRAŞOV   45.7843721 24.6698415     RO-SITUR BAR DE ZI 2 - STELE  
46765 46765 ANA-MARIA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 7.5 GHV 1.6 1.6 1171 Mun. Braşov BRAŞOV   45.6605726 25.5942908     RO-SITUR BAR DE ZI 2 - STELE  
46780 46780 BISTRO 2003, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 8.9 GHV 0.8 0.8 1172 Mun. Braşov BRAŞOV   45.6442543 25.5970826     RO-SITUR BAR DE ZI 2 - STELE  
46784 46784 CARPINIS, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 10 19.6 GHV 6.7 2.6 25 Mun. Braşov BRAŞOV   45.6623253 25.7669396     RO-SITUR BAR DE ZI 2 - STELE  
46807 46807 CRAMELE LUI DECEBAL II, CLUB SAU DISCO-BAR RO eat_drink bars_pubs nightclub normal 2 star 2 - STELE     party 0 0 40 0 60   80 10 11.0 GHV 2.1 2.1 1125 Mun. Braşov BRAŞOV   45.6433 25.6325761     RO-SITUR CLUB SAU DISCO-BAR 2 - STELE  
46841 46841 LEO, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 8.6 GHV 1.0 1.0 1171 Mun. Braşov BRAŞOV   45.6577487 25.6089773     RO-SITUR BAR DE ZI 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");