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

16,432 rows where best_for = "banquet" and group = "eat_drink"

This data as json, CSV (advanced)

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

rating_value 5

  • 1 8,979
  • 2 3,787
  • 3 1,590
  • 4 1,573
  • 5 371

family 4

country 3

group 1

  • eat_drink · 16,432 ✖

best_for 1

  • banquet · 16,432 ✖

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
45470 45470 TERRA MYTHICA, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 2 star 2 - STELE 218   banquet 0 0 70 0 0   55 10 49.1 Câmpia Turzii Air Base 10.2 0.8 17 Com. Ighiu ALBA   46.1438947 23.5121564     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 2 - STELE  
45487 45487 MARTINI, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE 140   banquet 0 0 60 0 0   65 10 42.5 SBZ 7.3 0.6 8 Com. Săsciori, Sat Sebeşel ALBA   45.8915553 23.559796     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45498 45498 GEORGIA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 10 24.8 Câmpia Turzii Air Base 0.3 0.3 17 Mun. Aiud ALBA   46.3086633 23.724558     RO-SITUR RESTAURANT CLASIC 4 - STELE  
45502 45502 WINE&SIMPHONY RESORT, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 stele 180   banquet 0 0 70 0 0   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 RESTAURANT CLASIC 3 stele  
45509 45509 CETATE, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 184   banquet 0 0 70 0 0   65 0 51.0 SBZ 1.1 1.1 191 Mun. Alba Iulia ALBA   46.0699016 23.5696515     RO-SITUR RESTAURANT CLASIC 3  
45520 45520 LA MAISON DE CAROLINE, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 STELE 40   banquet 0 0 50 0 0   65 0 50.1 SBZ 0.4 0.4 191 Mun. Alba Iulia ALBA   46.0700226 23.5840516     RO-SITUR RESTAURANT CLASIC 3 STELE  
45526 45526 MERCURE ALBA IULIA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 150   banquet 0 0 70 0 0   65 0 50.0 SBZ 0.7 0.7 191 Mun. Alba Iulia ALBA   46.0621519 23.5765002     RO-SITUR RESTAURANT CLASIC 3  
45528 45528 MIURA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 44   banquet 0 0 50 0 0   65 0 50.7 SBZ 0.8 0.8 191 Mun. Alba Iulia ALBA   46.0688610634541 23.5731972226845     RO-SITUR RESTAURANT CLASIC 3  
45535 45535 PRECIOSA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   65 0 50.2 SBZ 0.3 0.3 191 Mun. Alba Iulia ALBA   46.0671371 23.578956     RO-SITUR RESTAURANT CLASIC 4 - STELE  
45537 45537 SALA FRUMOASEI PRIVELIŞTI, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 5 star 5 - STELE     banquet 0 0 50 0 0   65 0 50.6 SBZ 0.9 0.9 191 Mun. Alba Iulia ALBA   46.0671679 23.5722201     RO-SITUR RESTAURANT CLASIC 5 - STELE  
45538 45538 SALA REGALĂ, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 5 star 5 - STELE     banquet 0 0 50 0 0   65 0 50.6 SBZ 0.9 0.9 191 Mun. Alba Iulia ALBA   46.0671679 23.5722201     RO-SITUR RESTAURANT CLASIC 5 - STELE  
45573 45573 RIVALY, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 78   banquet 0 0 50 0 0   55 0 41.9 GHV 13.4 0.4 206 Oraş Câmpeni ALBA   45.730116 24.983845     RO-SITUR RESTAURANT CLASIC 3  
45577 45577 CASA BELLA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 160   banquet 0 0 70 0 0   80 10 13.5 Câmpia Turzii Air Base 0.5 0.5 14 Oraş Ocna Mureş ALBA   46.3823846439721 23.8566990220901     RO-SITUR RESTAURANT CLASIC 2  
45606 45606 A1 SAGU DREAPTA, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 52   banquet 0 0 50 0 0   70 20 11.6 ARW 11.5 1.6 2 Com. Şagu, Sat Şagu ARAD   46.080264555541 21.3235705032074     RO-SITUR SNACK-BAR 2  
45611 45611 MILEN, BRASERIE SAU BISTROU RO eat_drink restaurants restaurant normal 2 star 2 40   banquet 0 0 50 0 0   55 20 31.0 ARW 28.6 1.3 1 Com. Şimand, Sat Şimand ARAD   46.421796 21.45546     RO-SITUR BRASERIE SAU BISTROU 2  
45627 45627 MARIA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 129   banquet 0 0 60 0 0   70 20 23.9 ARW 22.7 1.8 2 Com. Zădăreni, Sat Zădăreni ARAD   46.3871114 21.3226008     RO-SITUR RESTAURANT CLASIC 2  
45639 45639 ANIROC SIGNATURE, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 0 3.8 ARW 1.4 1.4 404 Mun. Arad ARAD   46.1709468 21.3134831     RO-SITUR RESTAURANT CLASIC 4 - STELE  
45651 45651 BOEME CAFE & BISTRO, CAFE-BAR SAU CAFENEA RO eat_drink cafes cafe normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 0 3.7 ARW 1.0 1.0 410 Mun. Arad ARAD   46.1748575 21.3129273     RO-SITUR CAFE-BAR SAU CAFENEA 4 - STELE  
45668 45668 CASA ROMÂNEASCĂ, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 2 star 2 - STELE 45   banquet 0 0 50 0 0   80 0 3.9 ARW 0.9 0.9 402 Mun. Arad ARAD   46.190063 21.3108342     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 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  
45722 45722 HANUL DE LA RĂSCRUCE, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE 64   banquet 0 0 50 0 0   70 30 6.5 ARW 10.0 7.6 9 Mun. Arad ARAD   46.2054786 21.1906356     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45751 45751 LEON, CAFE-BAR SAU CAFENEA RO eat_drink cafes cafe normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 0 5.8 ARW 1.8 1.8 402 Mun. Arad ARAD   46.1796871 21.3397597     RO-SITUR CAFE-BAR SAU CAFENEA 4 - STELE  
45752 45752 LEON, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 0 5.8 ARW 1.8 1.8 402 Mun. Arad ARAD   46.1796871 21.3397597     RO-SITUR RESTAURANT CLASIC 4 - STELE  
45773 45773 MONDO, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 0 3.9 ARW 0.5 0.5 408 Mun. Arad ARAD   46.1865606 21.3122677     RO-SITUR RESTAURANT CLASIC 4 - STELE  
45852 45852 TEKAFFE, COFETĂRIE RO eat_drink cafes cafe normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 0 4.2 ARW 1.1 1.1 406 Mun. Arad ARAD   46.1734695 21.3182048     RO-SITUR COFETĂRIE 4 - STELE  
45882 45882 82, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 50   banquet 0 0 50 0 0   55 10 40.0 ARW 20.8 0.4 6 Oraş Nădlac ARAD   46.1673215 20.7444696     RO-SITUR RESTAURANT CLASIC 3  
45897 45897 ADONIS, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE 50   banquet 0 0 50 0 0   55 0 66.2 SBZ 22.1 0.4 90 Com. Arefu ARGEŞ   45.331266 24.6367609     RO-SITUR RESTAURANT CLASIC 2 - 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  
45906 45906 VALEA CU PESTI, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   55 0 66.0 SBZ 22.3 0.2 89 Com. Arefu ARGEŞ   45.3333451 24.6357028     RO-SITUR RESTAURANT CLASIC 4 - STELE  
45908 45908 PISCUL NEGRU, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 130   banquet 0 0 60 0 0   45 40 47.4 SBZ 39.4 17.8 8 Com. Arefu, Sat Arefu ARGEŞ   45.5567098 24.6017223     RO-SITUR RESTAURANT CLASIC 3  
45924 45924 CASA MARIA, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   50 0 97.6 CRA 2.3 1.6 124 Com. Bradu ARGEŞ   44.8341697 24.8848827     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 4 - STELE  
45942 45942 MERIDIAN, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 2 star 2 STELE 118   banquet 0 0 60 0 0   55 0 73.8 SBZ 13.3 0.3 45 Com. Corbeni, Sat Oeştii Ungureni ARGEŞ   45.253160958218 24.6520071698669     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 2 STELE  
45946 45946 BRUSTURET, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 STELE 86   banquet 0 0 60 0 0   55 10 34.8 GHV 12.3 2.5 49 Com. Dâmbovicioara ARGEŞ   45.4715192 25.2256217     RO-SITUR BUFET-BAR 2 STELE  
45961 45961 CONACUL DE PE DEAL, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE 80   banquet 0 0 60 0 0   45 0 62.7 GHV 32.7 0.8 45 Com. Mioarele ARGEŞ   45.2380877 25.0726349     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45988 45988 CASA CRISTINA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   45 0 59.1 GHV 34.6 1.9 76 Mun. Câmpulung ARGEŞ   45.2844574 25.0610227     RO-SITUR RESTAURANT CLASIC 4 - STELE  
45993 45993 IMPERIAL - SMARALD, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 84   banquet 0 0 60 0 0   45 0 60.3 GHV 33.4 1.1 78 Mun. Câmpulung ARGEŞ   45.2765814 25.0488231     RO-SITUR RESTAURANT CLASIC 3  
46010 46010 MONTANA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE 100   banquet 0 0 60 0 0   50 0 84.7 SBZ 1.3 1.3 72 Mun. Curtea de Argeş ARGEŞ   45.1461705 24.6755516     RO-SITUR RESTAURANT CLASIC 3 - STELE  
46030 46030 CORAL, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   50 0 99.1 CRA 1.8 1.8 145 Mun. Piteşti ARGEŞ   44.8646074 24.8772602     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46034 46034 GARNET, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   50 0 99.1 CRA 1.8 1.8 145 Mun. Piteşti ARGEŞ   44.8646074 24.8772602     RO-SITUR RESTAURANT CLASIC 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  
46044 46044 PRESIDENT, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   40 20 86.2 CRA 11.4 1.6 4 Mun. Piteşti ARGEŞ   44.8026721 24.7384709     RO-SITUR RESTAURANT CLASIC 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  
46049 46049 SIERRA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 540   banquet 0 0 80 0 0   50 0 96.0 CRA 1.4 1.4 141 Mun. Piteşti ARGEŞ   44.8415687 24.8529893     RO-SITUR RESTAURANT CLASIC 4  
46054 46054 TWIST, CAFE-BAR SAU CAFENEA RO eat_drink cafes cafe normal 4 star 4 - STELE     banquet 0 0 50 0 0   50 0 99.1 CRA 1.8 1.8 145 Mun. Piteşti ARGEŞ   44.8646074 24.8772602     RO-SITUR CAFE-BAR SAU CAFENEA 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  
46057 46057 VICTORIA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   50 0 98.2 CRA 0.7 0.7 142 Mun. Piteşti ARGEŞ   44.8539224 24.8742953     RO-SITUR RESTAURANT CLASIC 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  
46082 46082 LA TAVERNA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 10 4.3 BCM 3.1 2.5 130 Com. Măgura BACĂU   46.5534109 26.878445     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46083 46083 TAVERNA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 10 4.3 BCM 3.1 2.5 130 Com. Măgura BACĂU   46.5534109 26.878445     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46086 46086 HANUL MOLDOVENESC, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE 70   banquet 0 0 50 0 0   80 10 4.8 BCM 9.7 1.5 13 Com. Nicolae Bălcescu BACĂU   46.4797792 26.9217663     RO-SITUR RESTAURANT CLASIC 2 - STELE  
46089 46089 ILCOLLE, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 1 star 1 40   banquet 0 0 50 0 0   80 10 4.8 BCM 9.8 1.4 12 Com. Nicolae Bălcescu, Sat Nicolae Bălcescu BACĂU   46.4788535 26.9197151     RO-SITUR RESTAURANT CLASIC 1  
46106 46106 DUMBRAVA BUSINESS RESORT, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 0 4.5 BCM 0.6 0.6 146 Mun. Bacău BACĂU   46.562238 26.911613     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46148 46148 PARC, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE 200   banquet 0 0 70 0 0   45 0 31.6 BCM 31.7 1.7 37 Mun. Oneşti BACĂU   46.2543239 26.771443     RO-SITUR RESTAURANT CLASIC 2 - STELE  
46159 46159 CASCADA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE 150   banquet 0 0 70 0 0   55 10 52.1 BCM 25.0 5.0 93 Oraş Slănic Moldova BACĂU   46.1969911 26.4215612     RO-SITUR RESTAURANT CLASIC 3 - STELE  
46161 46161 COROANA MOLDOVEI, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE 60   banquet 0 0 50 0 0   55 10 50.9 BCM 24.2 3.8 115 Oraş Slănic Moldova BACĂU   46.2041431 26.4331932     RO-SITUR RESTAURANT CLASIC 3 - STELE  
46162 46162 CRAMA DOMNEASCA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE 60   banquet 0 0 50 0 0   55 10 50.3 BCM 23.7 3.2 115 Oraş Slănic Moldova BACĂU   46.2082481 26.4383525     RO-SITUR RESTAURANT CLASIC 2 - STELE  
46164 46164 DOBRU, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE 42   banquet 0 0 50 0 0   55 10 50.8 BCM 24.4 3.6 115 Oraş Slănic Moldova BACĂU   46.2022938 26.4380826     RO-SITUR RESTAURANT CLASIC 3 - STELE  
46179 46179 PALAS, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 42   banquet 0 0 50 0 0   55 10 50.6 BCM 23.9 3.5 115 Oraş Slănic Moldova BACĂU   46.2065312 26.4354254     RO-SITUR RESTAURANT CLASIC 3  
46183 46183 PESCOBAR, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 STELE 100   banquet 0 0 60 0 0   55 10 51.1 BCM 24.2 4.0 103 Oraş Slănic Moldova BACĂU   46.2034434 26.4299316     RO-SITUR RESTAURANT CLASIC 3 STELE  
46198 46198 PE LAC, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 STELE 45   banquet 0 0 50 0 0   55 0 34.8 BCM 19.8 1.1 55 Oraş Târgu Ocna BACĂU   46.2879973 26.6078954     RO-SITUR RESTAURANT CLASIC 3 STELE  
46207 46207 MAGNIFIC, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 94   banquet 0 0 60 0 0   70 10 11.7 OMR 10.7 0.6 7 Com. Borş, Sat Borş BIHOR   47.1112519 21.814312     RO-SITUR RESTAURANT CLASIC 2  
46213 46213 APUSENI PARK, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 STELE 68   banquet 0 0 50 0 0   45 40 75.4 CLJ 51.5 13.3 15 Com. Budureasa, Sat Budureasa BIHOR   46.5954124111414 22.7370784774414     RO-SITUR RESTAURANT CLASIC 2 STELE  
46214 46214 BRADET, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 40   banquet 0 0 50 0 0   35 10 59.9 OMR 60.5 0.1 8 Com. Budureasa, Sat Budureasa BIHOR   46.674783077065 22.500523735582     RO-SITUR RESTAURANT CLASIC 2  
46244 46244 CONACUL PEȘTERA URȘILOR, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 70   banquet 0 0 50 0 0   45 10 71.5 OMR 50.7 2.6 33 Com. Pietroasa, Sat Chişcău BIHOR   46.5601823 22.5518832     RO-SITUR RESTAURANT CLASIC 2  
46267 46267 CRYSTAL CAFE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 5 star 5 - STELE     banquet 0 0 50 0 45   80 0 6.8 OMR 7.6 1.8 411 Com. Sânmartin BIHOR   46.9895138 21.9758953     RO-SITUR BAR DE ZI 5 - STELE  
46281 46281 PRESIDENT, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 0 7.9 OMR 8.8 1.9 400 Com. Sânmartin BIHOR   46.9805797 21.9837496     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46285 46285 SALON AMBRA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 5 star 5 - STELE     banquet 0 0 50 0 0   80 0 6.8 OMR 7.6 1.8 411 Com. Sânmartin BIHOR   46.9895138 21.9758953     RO-SITUR RESTAURANT CLASIC 5 - STELE  
46298 46298 CLUB ART, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE 100   banquet 0 0 60 0 0   80 0 7.4 OMR 8.1 1.4 408 Com. Sânmartin, Sat Băile Felix BIHOR   46.9876162 21.9823216     RO-SITUR RESTAURANT CLASIC 3 - STELE  
46301 46301 INTERNATIONAL, BRASERIE SAU BISTROU RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 0 7.1 OMR 7.8 1.5 410 Com. Sânmartin, Sat Băile Felix BIHOR   46.9899236 21.9803673     RO-SITUR BRASERIE SAU BISTROU 4 - STELE  
46302 46302 INTERNATIONAL, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 0 7.1 OMR 7.8 1.5 410 Com. Sânmartin, Sat Băile Felix BIHOR   46.9899236 21.9803673     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46304 46304 LA ROTISERIE, ROTISERIE RO eat_drink restaurants restaurant normal 2 star 2 40   banquet 0 0 50 0 0   80 0 7.3 OMR 8.0 1.5 410 Com. Sânmartin, Sat Băile Felix BIHOR   46.9884156 21.981499     RO-SITUR ROTISERIE 2  
46316 46316 PALACE, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 60   banquet 0 0 50 0 0   80 0 7.9 OMR 8.6 1.6 403 Com. Sânmartin, Sat Băile Felix BIHOR   46.9833796 21.9862281     RO-SITUR RESTAURANT CLASIC 2  
46327 46327 TOPAZ, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 STELE 42   banquet 0 0 50 0 0   80 0 7.3 OMR 8.0 1.5 409 Com. Sânmartin, Sat Băile Felix BIHOR   46.9878988 21.9817845     RO-SITUR BUFET-BAR 2 STELE  
46333 46333 DUE FRATELLI , RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - Stele 65   banquet 0 0 50 0 0   55 20 47.0 OMR 25.3 3.1 9 Com. Şinteu, Sat Şinteu BIHOR   47.1266165 22.5047778     RO-SITUR RESTAURANT CLASIC 3 - Stele  
46355 46355 ARIS BOUTIQUE HOTEL & SPA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 STELE 50   banquet 0 0 50 0 0   80 10 5.0 OMR 2.5 2.5 359 Mun. Oradea BIHOR   47.0659814 21.9319973     RO-SITUR RESTAURANT CLASIC 3 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  
46377 46377 LAURUS, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 10 4.8 OMR 2.5 2.5 376 Mun. Oradea BIHOR   47.0541063 21.9489103     RO-SITUR RESTAURANT CLASIC 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  
46379 46379 MAXIM, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 10 4.8 OMR 2.2 2.2 363 Mun. Oradea BIHOR   47.0620087 21.9348834     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46383 46383 MONDO, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 10 4.5 OMR 2.1 2.1 374 Mun. Oradea BIHOR   47.055271 21.942754     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46386 46386 ORHIDEEA BY NEVIS, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE 56   banquet 0 0 50 0 0   80 10 4.3 OMR 2.0 2.0 347 Mun. Oradea BIHOR   47.0631495 21.9109641     RO-SITUR RESTAURANT CLASIC 3 - 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  
46389 46389 RAMADA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 0 3.5 OMR 1.1 1.1 359 Mun. Oradea BIHOR   47.0556 21.916233     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46392 46392 SILVER, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE 70   banquet 0 0 50 0 0   80 10 6.3 OMR 3.9 2.9 359 Mun. Oradea BIHOR   47.0661091 21.9602529     RO-SITUR RESTAURANT CLASIC 2 - 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  
46418 46418 FONTIS COMPLEX, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 200   banquet 0 0 70 0 0   45 10 38.9 DEB 37.0 0.8 9 Oraş Săcueni BIHOR   47.356086 22.0948499     RO-SITUR RESTAURANT CLASIC 3  
46431 46431 PANORAMIC COLIBIŢA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   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 RESTAURANT CLASIC 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  
46475 46475 GRAND COROANA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE 235   banquet 0 0 70 0 0   65 0 73.0 CLJ 0.3 0.3 92 Mun. Bistriţa BISTRIŢA-NĂSĂUD   47.1360456 24.4995178     RO-SITUR RESTAURANT CLASIC 3 - STELE  
46479 46479 METROPOLIS, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 5 star 5 - STELE     banquet 0 0 50 0 0   65 0 72.2 CLJ 0.8 0.8 91 Mun. Bistriţa BISTRIŢA-NĂSĂUD   47.1277594 24.4938853     RO-SITUR RESTAURANT CLASIC 5 - 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  
46487 46487 OZANA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   65 0 74.2 CLJ 1.5 1.5 91 Mun. Bistriţa BISTRIŢA-NĂSĂUD   47.144322 24.510262     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46492 46492 TERRA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   65 0 72.0 CLJ 1.6 1.6 90 Mun. Bistriţa BISTRIŢA-NĂSĂUD   47.13962 24.4813094     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46513 46513 MAJESTIC, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE 400   banquet 0 0 80 0 0   80 0 22.1 SCV 4.0 0.3 50 Com. Curteşti BOTOŞANI   47.7165332 26.6457654     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46518 46518 CASA BOEMA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE 62   banquet 0 0 50 0 0   80 0 21.0 SCV 4.5 1.1 38 Com. Mihai Eminescu, Sat Cătămăreşti-Deal BOTOŞANI   47.7638947 26.6103411     RO-SITUR RESTAURANT CLASIC 2 - STELE  
46519 46519 HQ IMPERIA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 1 star 1 100   banquet 0 0 60 0 0   55 20 39.6 SCV 15.3 1.9 1 Com. Mihai Eminescu, Sat Cucorăni BOTOŞANI   47.7993428 26.8572593     RO-SITUR RESTAURANT CLASIC 1  

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