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,836 rows where family = "bars_pubs", group = "eat_drink" and rating_value = 3

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 3

best_for 2

rating_value 1

  • 3 · 1,836 ✖

group 1

  • eat_drink · 1,836 ✖

family 1

  • bars_pubs · 1,836 ✖

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
45456 45456 BLEUMARIN, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   55 30 39.8 Câmpia Turzii Air Base 14.0 2.9 5 Com. Galda de Jos ALBA   46.1816893 23.6566509     RO-SITUR BAR DE ZI 3 - STELE  
45493 45493 SF. PETRU, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   55 40 48.9 SBZ 17.2 15.5 8 Com. Şugag ALBA   45.5838755 23.527565     RO-SITUR BAR DE ZI 3 - STELE  
45503 45503 WINE&SIMPHONY RESORT, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 stele 20     0 0 40 0 45   80 10 23.1 Câmpia Turzii Air Base 3.6 0.6 17 Mun. Aiud, Sat Ciumbrud ALBA   46.3112094 23.7680104     RO-SITUR BAR DE ZI 3 stele  
45527 45527 MERCURE ALBA IULIA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 5     0 0 40 0 45   65 0 50.1 SBZ 0.8 0.8 191 Mun. Alba Iulia ALBA   46.0623621 23.5755425     RO-SITUR BAR DE ZI 3  
45531 45531 NOVA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   65 0 50.3 SBZ 0.4 0.4 191 Mun. Alba Iulia ALBA   46.0681867 23.5780252     RO-SITUR BAR DE ZI 3 - STELE  
45533 45533 PARC, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   65 0 50.2 SBZ 0.3 0.3 191 Mun. Alba Iulia ALBA   46.0691429 23.581314     RO-SITUR BAR DE ZI 3 - STELE  
45536 45536 SALA ARMELOR, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   65 0 50.6 SBZ 0.9 0.9 191 Mun. Alba Iulia ALBA   46.0671679 23.5722201     RO-SITUR BAR DE ZI 3 - STELE  
45540 45540 SELECT, CRAMĂ RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   65 0 49.5 SBZ 4.4 0.9 134 Mun. Alba Iulia ALBA   46.0327439 23.5544652     RO-SITUR CRAMĂ 3 - STELE  
45546 45546 TRANSILVANIA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   65 0 50.3 SBZ 0.6 0.6 191 Mun. Alba Iulia ALBA   46.0716803 23.582319     RO-SITUR BAR DE ZI 3 - STELE  
45550 45550 MAN PRESIDENT, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   65 0 36.6 Câmpia Turzii Air Base 0.7 0.5 28 Mun. Blaj ALBA   46.1735298 23.9073741     RO-SITUR BAR DE ZI 3 - STELE  
45553 45553 PARADISUL TRANSILVANIEI, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   65 0 33.9 Câmpia Turzii Air Base 3.7 0.2 26 Mun. Blaj ALBA   46.2002006 23.9470361     RO-SITUR BAR DE ZI 3 - STELE  
45556 45556 LA VIE, CRAMĂ RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   65 0 37.1 Câmpia Turzii Air Base 1.1 0.1 28 Mun. Blaj, Loc. Izvoarele ALBA   46.1690262 23.904278     RO-SITUR CRAMĂ 3 - STELE  
45599 45599 PARC, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   45 0 68.3 OMR 54.3 1.5 36 Com. Moneasa ARAD   46.4617702 22.259481     RO-SITUR BAR DE ZI 3 - STELE  
45615 45615 AGROVILLAGE, CLUB SAU DISCO-BAR RO eat_drink bars_pubs nightclub normal 3 star 3 - STELE     party 0 0 40 0 60   45 30 39.2 TSR 31.6 7.6 6 Com. Şiştarovăţ ARAD   45.96272 21.794351     RO-SITUR CLUB SAU DISCO-BAR 3 - STELE  
45631 45631 ACTIV CLUB - BLUE ARCTIC, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 10 5.3 ARW 2.4 2.4 387 Mun. Arad ARAD   46.1644716 21.3308937     RO-SITUR BAR DE ZI 3 - STELE  
45632 45632 AKADEMOS, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 0 3.5 ARW 1.5 1.5 403 Mun. Arad ARAD   46.1707836 21.3096421     RO-SITUR BAR DE ZI 3 - STELE  
45640 45640 ANIROC SIGNATURE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 0 3.8 ARW 1.4 1.4 404 Mun. Arad ARAD   46.1709468 21.3134831     RO-SITUR BAR DE ZI 3 - STELE  
45647 45647 BEST WESTERN CENTRAL, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 0 4.0 ARW 0.8 0.8 411 Mun. Arad ARAD   46.1762734 21.316574     RO-SITUR BAR DE ZI 3 - STELE  
45648 45648 BEST WESTERN CENTRAL, CRAMĂ RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 0 4.0 ARW 0.8 0.8 411 Mun. Arad ARAD   46.1762734 21.316574     RO-SITUR CRAMĂ 3 - STELE  
45674 45674 CINEMA CITY, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 0 4.6 ARW 0.8 0.8 400 Mun. Arad ARAD   46.1905128 21.3203719     RO-SITUR BAR DE ZI 3 - STELE  
45696 45696 DIPLOMAT CAFE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 0 4.3 ARW 0.5 0.5 411 Mun. Arad ARAD   46.1791969 21.3198591     RO-SITUR BAR DE ZI 3 - STELE  
45699 45699 ESCAPE CLUB CAFFE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 0 4.7 ARW 0.9 0.9 400 Mun. Arad ARAD   46.1901794 21.3220619     RO-SITUR BAR DE ZI 3 - STELE  
45709 45709 GEMI SPORT, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 10 6.4 ARW 2.6 2.6 392 Mun. Arad ARAD   46.1731426 21.3467066     RO-SITUR BAR DE ZI 3 - STELE  
45710 45710 GIO, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 0 4.3 ARW 1.7 1.7 404 Mun. Arad ARAD   46.1679216 21.3182705     RO-SITUR BAR DE ZI 3 - STELE  
45721 45721 HANUL DE LA RASCRUCE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 10 5.3 ARW 3.8 3.8 278 Mun. Arad ARAD   46.2159976 21.3029531     RO-SITUR BAR DE ZI 3 - STELE  
45727 45727 IBIS STYLES ARAD, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 20 3.3 ARW 5.7 5.7 94 Mun. Arad ARAD   46.2032504 21.2478826     RO-SITUR BAR DE ZI 3 - STELE  
45731 45731 IRIS, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 0 3.1 ARW 1.6 1.6 415 Mun. Arad ARAD   46.1715719 21.3042347     RO-SITUR BAR DE ZI 3 - STELE  
45734 45734 JELEN-HAZ, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 0 3.4 ARW 1.4 1.4 409 Mun. Arad ARAD   46.1719634 21.3076679     RO-SITUR BAR DE ZI 3 - STELE  
45739 45739 KENSU, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 10 3.4 ARW 2.3 2.3 372 Mun. Arad ARAD   46.1979254 21.296246     RO-SITUR BAR DE ZI 3 - STELE  
45793 45793 PALACIO, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 0 4.0 ARW 1.1 1.1 410 Mun. Arad ARAD   46.1739029 21.3155848     RO-SITUR BAR DE ZI 3 - STELE  
45806 45806 PLANET BOWLING, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 0 4.6 ARW 0.8 0.8 400 Mun. Arad ARAD   46.1905128 21.3203719     RO-SITUR BAR DE ZI 3 - STELE  
45813 45813 PRESIDENT, BAR DE NOAPTE RO eat_drink bars_pubs nightclub normal 3 star 3 - STELE     party 0 0 40 0 60   80 10 5.8 ARW 4.6 4.6 273 Mun. Arad ARAD   46.1422618 21.3208731     RO-SITUR BAR DE NOAPTE 3 - STELE  
45844 45844 SEXY CLUB AFRODITA, CLUB SAU DISCO-BAR RO eat_drink bars_pubs nightclub normal 3 star 3 - STELE     party 0 0 40 0 60   80 10 11.4 TSR 2.0 2.0 542 Mun. Arad ARAD   45.765547 21.2060023     RO-SITUR CLUB SAU DISCO-BAR 3 - STELE  
45865 45865 VINTAGE PUB-CAFFE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 0 3.8 ARW 1.1 1.1 406 Mun. Arad ARAD   46.191279 21.3080393     RO-SITUR BAR DE ZI 3 - STELE  
45871 45871 XE-MAR, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 10 4.9 ARW 2.8 2.8 380 Mun. Arad ARAD   46.1583565 21.3221171     RO-SITUR BAR DE ZI 3 - STELE  
45876 45876 CENTRAL, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   45 10 51.8 ARW 44.0 1.1 10 Oraş Ineu ARAD   46.4248845 21.8346096     RO-SITUR BAR DE ZI 3 - STELE  
45902 45902 POSADA VIDRARU, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   55 0 66.5 SBZ 21.8 0.6 90 Com. Arefu ARGEŞ   45.3289921 24.6381558     RO-SITUR BAR DE ZI 3 - STELE  
45994 45994 IMPERIAL - SMARALD, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 4     0 0 40 0 45   45 0 60.3 GHV 33.4 1.1 78 Mun. Câmpulung ARGEŞ   45.2765814 25.0488231     RO-SITUR BAR DE ZI 3  
45999 45999 CAMINO, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   50 0 85.5 SBZ 0.3 0.3 72 Mun. Curtea de Argeş ARGEŞ   45.1372098 24.6752326     RO-SITUR BAR DE ZI 3 - STELE  
46012 46012 POSADA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   50 10 84.1 SBZ 2.0 2.0 78 Mun. Curtea de Argeş ARGEŞ   45.152189 24.675891     RO-SITUR BAR DE ZI 3 - STELE  
46013 46013 POSADA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   50 10 84.1 SBZ 2.0 2.0 78 Mun. Curtea de Argeş ARGEŞ   45.152189 24.675891     RO-SITUR BAR DE ZI 3 - STELE  
46017 46017 SUBCARPAŢI, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   50 10 84.2 SBZ 2.2 2.2 76 Mun. Curtea de Argeş ARGEŞ   45.1533136 24.681136     RO-SITUR BAR DE ZI 3 - STELE  
46022 46022 AVANTGARDE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   50 10 97.7 CRA 2.9 2.2 145 Mun. Piteşti ARGEŞ   44.8718709 24.8458077     RO-SITUR BAR DE ZI 3 - STELE  
46024 46024 CAMPUS, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   50 10 98.2 CRA 2.4 2.4 153 Mun. Piteşti ARGEŞ   44.870287 24.856257     RO-SITUR BAR DE ZI 3 - STELE  
46026 46026 CARMEN, CLUB SAU DISCO-BAR RO eat_drink bars_pubs nightclub normal 3 star 3 - STELE     party 0 0 40 0 60   50 0 98.2 CRA 0.8 0.8 142 Mun. Piteşti ARGEŞ   44.8563696 24.8717678     RO-SITUR CLUB SAU DISCO-BAR 3 - STELE  
46042 46042 PINK CLUB, CLUB SAU DISCO-BAR RO eat_drink bars_pubs nightclub normal 3 star 3 - STELE     party 0 0 40 0 60   50 10 98.2 CRA 2.4 2.4 153 Mun. Piteşti ARGEŞ   44.870287 24.856257     RO-SITUR CLUB SAU DISCO-BAR 3 - STELE  
46058 46058 ZEBRANO, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   50 10 98.2 CRA 2.4 2.4 153 Mun. Piteşti ARGEŞ   44.870287 24.856257     RO-SITUR BAR DE ZI 3 - STELE  
46078 46078 C&C KARO RESORT, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 0 5.3 BCM 2.9 1.4 133 Com. Măgura BACĂU   46.5637829 26.8767989     RO-SITUR BAR DE ZI 3 - STELE  
46104 46104 DECEBAL, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 0 4.9 BCM 0.3 0.3 145 Mun. Bacău BACĂU   46.5655773 26.9113495     RO-SITUR BAR DE ZI 3 - STELE  
46107 46107 DUMBRAVA BUSINESS RESORT, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 0 4.5 BCM 0.6 0.6 146 Mun. Bacău BACĂU   46.562238 26.911613     RO-SITUR BAR DE ZI 3 - STELE  
46110 46110 EMD, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 0 6.0 BCM 1.2 1.2 143 Mun. Bacău BACĂU   46.5745598 26.9260584     RO-SITUR BAR DE ZI 3 - STELE  
46112 46112 FIALD HOTEL &SPA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 0 6.7 BCM 1.9 1.9 144 Mun. Bacău BACĂU   46.5820215 26.9021363     RO-SITUR BAR DE ZI 3 - STELE  
46123 46123 PRESIDENT, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 0 4.8 BCM 0.5 0.5 145 Mun. Bacău BACĂU   46.5647177 26.9086548     RO-SITUR BAR DE ZI 3 - STELE  
46160 46160 COROANA MOLDOVEI, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE 8     0 0 40 0 45   55 10 49.5 BCM 23.2 2.4 107 Oraş Slănic Moldova BACĂU   46.21305 26.445962     RO-SITUR BAR DE ZI 3 - STELE  
46165 46165 DOBRU, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   55 10 50.7 BCM 24.2 3.6 115 Oraş Slănic Moldova BACĂU   46.2036377 26.4369276     RO-SITUR BAR DE ZI 3 - STELE  
46178 46178 NEMIRA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   55 10 50.2 BCM 23.7 3.1 115 Oraş Slănic Moldova BACĂU   46.2085929 26.4394408     RO-SITUR BAR DE ZI 3 - STELE  
46215 46215 IADOLINA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   35 30 66.2 OMR 61.8 9.5 11 Com. Budureasa, Sat Budureasa BIHOR   46.6909491 22.6223191     RO-SITUR BAR DE ZI 3 - STELE  
46231 46231 SOLAY, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 0 9.3 OMR 8.9 0.2 364 Com. Oşorhei, Sat Cheriu BIHOR   47.0113918 22.0237037     RO-SITUR BAR DE ZI 3 - STELE  
46278 46278 PERLA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 0 8.0 OMR 8.2 0.3 412 Com. Sânmartin BIHOR   46.997236 21.9991983     RO-SITUR BAR DE ZI 3 - STELE  
46282 46282 RIVIERA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - 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 3 - STELE  
46296 46296 AVENTUS, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 0 7.1 OMR 7.6 1.2 416 Com. Sânmartin, Sat Băile Felix BIHOR   46.9933078 21.9831643     RO-SITUR BAR DE ZI 3 - STELE  
46300 46300 INTERNATIONAL, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - 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 3 - STELE  
46311 46311 NUFARUL, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 0 6.8 OMR 7.4 1.6 416 Com. Sânmartin, Sat Băile Felix BIHOR   46.992518 21.9776     RO-SITUR BAR DE ZI 3 - STELE  
46321 46321 POIENITA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 0 7.0 OMR 7.6 1.2 418 Com. Sânmartin, Sat Băile Felix BIHOR   46.993236 21.982398     RO-SITUR BAR DE ZI 3 - STELE  
46325 46325 TERMAL, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 0 6.8 OMR 7.5 1.6 414 Com. Sânmartin, Sat Băile Felix BIHOR   46.991786 21.977312     RO-SITUR BAR DE ZI 3 - STELE  
46356 46356 ARIS BOUTIQUE HOTEL & SPA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 STELE 4     0 0 40 0 45   80 10 5.0 OMR 2.5 2.5 359 Mun. Oradea BIHOR   47.0659814 21.9319973     RO-SITUR BAR DE ZI 3 STELE  
46357 46357 ASTORIA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 0 4.1 OMR 1.6 1.6 364 Mun. Oradea BIHOR   47.057339 21.930125     RO-SITUR BAR DE ZI 3 - STELE  
46359 46359 ASTORIA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 0 4.1 OMR 1.6 1.6 364 Mun. Oradea BIHOR   47.057339 21.930125     RO-SITUR BAR DE ZI 3 - STELE  
46362 46362 CAPPSHA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 10 3.9 OMR 2.4 2.4 330 Mun. Oradea BIHOR   47.0603346 21.89487     RO-SITUR BAR DE ZI 3 - STELE  
46368 46368 ELITE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 10 4.8 OMR 2.4 2.4 374 Mun. Oradea BIHOR   47.0569106 21.9451201     RO-SITUR BAR DE ZI 3 - STELE  
46384 46384 NEVIS, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 10 4.3 OMR 2.0 2.0 347 Mun. Oradea BIHOR   47.0631495 21.9109641     RO-SITUR BAR DE ZI 3 - STELE  
46403 46403 TRANSIT, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 10 5.0 OMR 4.3 2.3 561 Mun. Oradea BIHOR   47.0275696 21.9681126     RO-SITUR BAR DE ZI 3 - STELE  
46407 46407 SLAVIA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   65 10 30.8 OMR 0.9 0.9 13 Mun. Salonta BIHOR   46.803644 21.6599765     RO-SITUR BAR DE ZI 3 - STELE  
46426 46426 ROSER HOUSE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   40 0 86.1 TGM 29.6 1.5 67 Com. Bistriţa Bârgăului BISTRIŢA-NĂSĂUD   47.1706136 24.8872624     RO-SITUR BAR DE ZI 3 - STELE  
46437 46437 JELNA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   65 10 72.4 TGM 5.0 0.2 19 Com. Cetate, Sat Satu Nou BISTRIŢA-NĂSĂUD   47.1113476 24.5577843     RO-SITUR BAR DE ZI 3 - STELE  
46456 46456 DRACULA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   30 40 96.5 TGM 30.2 10.1 15 Com. Tiha Bârgăului BISTRIŢA-NĂSĂUD   47.2352397 25.0034558     RO-SITUR BAR DE ZI 3 - STELE  
46457 46457 DRACULA, CRAMĂ RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   30 40 96.5 TGM 30.2 10.1 15 Com. Tiha Bârgăului BISTRIŢA-NĂSĂUD   47.2352397 25.0034558     RO-SITUR CRAMĂ 3 - STELE  
46463 46463 CASTEL DRACULA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   40 0 87.1 TGM 19.9 0.8 22 Com. Tiha Bârgăului, Sat Piatra Fântânele BISTRIŢA-NĂSĂUD   47.2200404 24.730445     RO-SITUR BAR DE ZI 3 - STELE  
46472 46472 DIANA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   65 0 72.5 CLJ 1.1 1.1 90 Mun. Bistriţa BISTRIŢA-NĂSĂUD   47.1392617 24.4890979     RO-SITUR BAR DE ZI 3 - STELE  
46476 46476 GRAND COROANA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE 35     0 0 40 0 45   65 0 73.0 CLJ 0.3 0.3 92 Mun. Bistriţa BISTRIŢA-NĂSĂUD   47.1360456 24.4995178     RO-SITUR BAR DE ZI 3 - STELE  
46478 46478 ILLKER KAFFE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   65 0 73.9 CLJ 1.1 1.1 93 Mun. Bistriţa BISTRIŢA-NĂSĂUD   47.1411866 24.5086561     RO-SITUR BAR DE ZI 3 - STELE  
46499 46499 ZIMVESTUL, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   55 0 56.4 CLJ 22.7 1.7 37 Oraş Beclean BISTRIŢA-NĂSĂUD   47.1745458 24.1645058     RO-SITUR BAR DE ZI 3 - STELE  
46530 46530 PREMIER, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 0 22.5 SCV 1.9 1.9 49 Mun. Botoşani BOTOŞANI   47.7461809 26.6416322     RO-SITUR BAR DE ZI 3 - STELE  
46533 46533 PREMIER, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 0 22.5 SCV 1.9 1.9 49 Mun. Botoşani BOTOŞANI   47.7461809 26.6416322     RO-SITUR BAR DE ZI 3 - STELE  
46534 46534 RAPSODIA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 0 23.9 SCV 0.6 0.6 49 Mun. Botoşani BOTOŞANI   47.7453125 26.6617581     RO-SITUR BAR DE ZI 3 - STELE  
46538 46538 REDIU, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 0 25.2 SCV 1.4 1.4 49 Mun. Botoşani BOTOŞANI   47.7422718 26.6815708     RO-SITUR BAR DE ZI 3 - STELE  
46539 46539 SIX AVENUE, CLUB SAU DISCO-BAR RO eat_drink bars_pubs nightclub normal 3 star 3 - STELE     party 0 0 40 0 60   80 0 23.2 SCV 1.2 1.2 49 Mun. Botoşani BOTOŞANI   47.7490495 26.6502675     RO-SITUR CLUB SAU DISCO-BAR 3 - STELE  
46546 46546 KIRALINA, CRAMĂ RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   55 0 62.9 TCE 10.8 0.5 23 Com. Chiscani BRĂILA   45.179314 27.9300391     RO-SITUR CRAMĂ 3 - STELE  
46547 46547 LOBBY BAR, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   55 0 62.9 TCE 10.8 0.5 23 Com. Chiscani BRĂILA   45.179314 27.9300391     RO-SITUR BAR DE ZI 3 - STELE  
46550 46550 PISCINA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   55 0 62.9 TCE 10.8 0.5 23 Com. Chiscani BRĂILA   45.179314 27.9300391     RO-SITUR BAR DE ZI 3 - STELE  
46553 46553 PERLA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 50   party 0 0 50 0 55   65 10 64.8 TCE 7.7 2.3 42 Com. Chiscani, Sat Chiscani BRĂILA   45.215172 27.9166859     RO-SITUR BAR DE ZI 3  
46565 46565 UNIQUE GARDEN, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   65 0 63.2 TCE 9.1 1.4 34 Com. Chiscani, Sat Vărsătura BRĂILA   45.1956088 27.9310483     RO-SITUR BAR DE ZI 3 - STELE  
46592 46592 SAINT-GERMAIN, CRAMĂ RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   65 0 62.3 TCE 0.3 0.3 89 Mun. Brăila BRĂILA   45.2729473 27.9782124     RO-SITUR CRAMĂ 3 - STELE  
46593 46593 SAINT-GERMAIN, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   65 0 62.3 TCE 0.3 0.3 89 Mun. Brăila BRĂILA   45.2729473 27.9782124     RO-SITUR BAR DE ZI 3 - STELE  
46617 46617 HANUL BRAN, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 0 24.1 GHV 6.4 1.6 486 Com. Bran BRAŞOV   45.5170975 25.370861     RO-SITUR BAR DE ZI 3 - 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  
46653 46653 VAMPIRE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 10 23.0 GHV 5.5 2.1 446 Com. Bran, Sat Sohodol BRAŞOV   45.5282882 25.3710635     RO-SITUR BAR DE ZI 3 - STELE  
46656 46656 BOUTIQUE GOŞ, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 0 10.0 GHV 4.7 0.8 144 Com. Cristian BRAŞOV   45.623339 25.470611     RO-SITUR BAR DE ZI 3 - STELE  
46666 46666 CHEILE GRADISTEI FUNDATA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   55 0 34.8 GHV 13.9 1.6 261 Com. Fundata BRAŞOV   45.4371446 25.2919972     RO-SITUR BAR DE ZI 3 - STELE  
46680 46680 GRADISTEA PUB, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 0 29.5 GHV 8.4 0.6 388 Com. Moieciu BRAŞOV   45.485547 25.3101774     RO-SITUR BAR DE ZI 3 - 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");