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

62,045 rows where family = "bars_pubs"

This data as json, CSV (advanced)

Suggested facets: valid_until (date), stop_date (date)

rating_value 5

  • 1 4,849
  • 2 1,964
  • 3 1,836
  • 4 670
  • 5 150

country 4

best_for 2

group 1

family 1

  • bars_pubs · 62,045 ✖

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  
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  
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  
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  
45516 45516 FLAMINGO, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 1 star 1 - STELE       0 0 40 0 45   65 0 50.4 SBZ 0.5 0.5 191 Mun. Alba Iulia ALBA   46.068374 23.577362     RO-SITUR BAR DE ZI 1 - 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  
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  
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  
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  
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  
45635 45635 AMICITIA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 1 star 1 - STELE       0 0 40 0 45   80 10 3.1 ARW 3.3 3.3 337 Mun. Arad ARAD   46.201116 21.282796     RO-SITUR BAR DE ZI 1 - STELE  
45636 45636 AMIGO, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 1 star 1 - STELE       0 0 40 0 45   80 0 4.3 ARW 0.3 0.3 413 Mun. Arad ARAD   46.1812022 21.3199167     RO-SITUR BAR DE ZI 1 - 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  
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  
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  
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  
45655 45655 BRAO-CAN, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 1 star 1 - STELE       0 0 40 0 45   80 0 3.8 ARW 0.9 0.9 410 Mun. Arad ARAD   46.1752026 21.3134537     RO-SITUR BAR DE ZI 1 - STELE  
45661 45661 CAPPUCCINO, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 1 star 1 - STELE       0 0 40 0 45   80 0 3.8 ARW 1.1 1.1 406 Mun. Arad ARAD   46.1912851 21.3081574     RO-SITUR BAR DE ZI 1 - 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  
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  
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  
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  
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  
45695 45695 DERBY, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 1 star 1 - STELE       0 0 40 0 45   80 0 3.3 ARW 1.6 1.6 392 Mun. Arad ARAD   46.1923368 21.3003668     RO-SITUR BAR DE ZI 1 - 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  
45700 45700 EXPO ARAD, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 1 star 1 - STELE       0 0 40 0 45   80 20 3.2 ARW 5.4 5.4 158 Mun. Arad ARAD   46.2035634 21.253201     RO-SITUR BAR DE ZI 1 - STELE  
45702 45702 FAN CLUB DINAMO ARAD, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 1 star 1 - STELE       0 0 40 0 45   80 0 3.8 ARW 1.0 1.0 410 Mun. Arad ARAD   46.174408 21.3138165     RO-SITUR BAR DE ZI 1 - 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  
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  
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  
45713 45713 GIOIA CAFFE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 1 star 1 - 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 1 - STELE  
45716 45716 GOLD WINNER, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 1 star 1 - STELE       0 0 40 0 45   80 0 3.7 ARW 0.6 0.6 405 Mun. Arad ARAD   46.1869349 21.3099598     RO-SITUR BAR DE ZI 1 - STELE  
45717 45717 GOLD WINNER, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 1 star 1 - STELE       0 0 40 0 45   80 10 3.5 ARW 2.8 2.8 344 Mun. Arad ARAD   46.2019114 21.2914272     RO-SITUR BAR DE ZI 1 - 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  
45720 45720 GROS MARKET, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 1 star 1 - STELE       0 0 40 0 45   80 10 5.2 ARW 2.1 2.1 386 Mun. Arad ARAD   46.2015835 21.3208386     RO-SITUR BAR DE ZI 1 - 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  
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  
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  
45730 45730 IOANA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 1 star 1 - STELE       0 0 40 0 45   80 10 2.4 ARW 2.7 2.7 386 Mun. Arad ARAD   46.166288 21.2916811     RO-SITUR BAR DE ZI 1 - 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  
45735 45735 JOKER, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 1 star 1 - STELE       0 0 40 0 45   80 0 4.6 ARW 0.6 0.6 408 Mun. Arad ARAD   46.1823783 21.3239345     RO-SITUR BAR DE ZI 1 - 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  
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  
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  
45746 45746 LA MOROSANU, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 1 star 1 - STELE       0 0 40 0 45   80 10 5.9 ARW 4.9 4.9 226 Mun. Arad ARAD   46.1396926 21.3204384     RO-SITUR BAR DE ZI 1 - 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  
45749 45749 LA VOGLIA MIA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 1 star 1 - STELE       0 0 40 0 45   80 10 2.0 ARW 2.3 2.3 401 Mun. Arad ARAD   46.1734386 21.2906039     RO-SITUR BAR DE ZI 1 - 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  
45761 45761 MARIO, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 1 star 1 - STELE       0 0 40 0 45   80 0 4.2 ARW 0.2 0.2 412 Mun. Arad ARAD   46.1822962 21.3179659     RO-SITUR BAR DE ZI 1 - 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  
45777 45777 NADLAC, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 1 star 1 - STELE       0 0 40 0 45   80 10 2.1 ARW 3.4 3.4 335 Mun. Arad ARAD   46.1930958 21.2754031     RO-SITUR BAR DE ZI 1 - 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  
45784 45784 OGI, TERASĂ RO eat_drink bars_pubs bar_pub normal 1 star 1 - 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 TERASĂ 1 - 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  
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  
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  
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  
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  
45811 45811 PREMIER, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 1 star 1 - 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 1 - STELE  
45812 45812 PREMIER, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 1 star 1 - STELE       0 0 40 0 45   80 10 5.6 ARW 4.2 4.2 312 Mun. Arad ARAD   46.146068 21.321992     RO-SITUR BAR DE ZI 1 - 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  
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  
45824 45824 RAUL CAFFE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 1 star 1 - STELE       0 0 40 0 45   80 0 3.3 ARW 1.0 1.0 411 Mun. Arad ARAD   46.1764832 21.307255     RO-SITUR BAR DE ZI 1 - STELE  
45826 45826 REIFF CAFE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 1 star 1 - STELE       0 0 40 0 45   80 0 3.6 ARW 1.6 1.6 393 Mun. Arad ARAD   46.1942716 21.3037716     RO-SITUR BAR DE ZI 1 - 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  
45837 45837 ROVAL TRADING, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 1 star 1 - STELE       0 0 40 0 45   80 0 3.7 ARW 0.6 0.6 405 Mun. Arad ARAD   46.1869349 21.3099598     RO-SITUR BAR DE ZI 1 - 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");