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

851 rows where best_for = "banquet", country = "RO" and family = "restaurants"

This data as json, CSV (advanced)

Suggested facets: rating_scheme, rating_label, fit_banquet, reachability_score, isolation_score, nearest_airport, source_type, source_category

rating_value 5

  • 4 370
  • 3 237
  • 2 168
  • 5 62
  • 1 13

group 1

family 1

  • restaurants · 851 ✖

country 1

  • RO · 851 ✖

best_for 1

  • banquet · 851 ✖

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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
46526 46526 MARIA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 0 23.6 SCV 1.0 1.0 49 Mun. Botoşani BOTOŞANI   47.743987 26.657523     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46535 46535 RAPSODIA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 0 23.9 SCV 0.6 0.6 49 Mun. Botoşani BOTOŞANI   47.7453125 26.6617581     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46552 46552 PERLA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 120   banquet 0 0 60 0 0   65 10 64.8 TCE 7.7 2.3 42 Com. Chiscani, Sat Chiscani BRĂILA   45.215172 27.9166859     RO-SITUR RESTAURANT CLASIC 3  
46555 46555 EVAS GARDEN, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 100   banquet 0 0 60 0 0   65 10 64.9 TCE 7.8 2.2 42 Com. Chiscani, Sat Chiscani, Statiunea Lacu Sarat BRĂILA   45.2149637 27.9151842     RO-SITUR RESTAURANT CLASIC 3  
46561 46561 MARA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 116   banquet 0 0 60 0 0   65 10 64.8 TCE 7.7 2.3 42 Com. Chiscani, Sat Lacu Sărat BRĂILA   45.2152476 27.9166537     RO-SITUR RESTAURANT CLASIC 3  
46571 46571 BOULEVARD, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   65 0 62.4 TCE 0.4 0.4 89 Mun. Brăila BRĂILA   45.274462 27.977106     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46573 46573 EDYS HOUSE, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   65 0 63.0 TCE 0.6 0.6 90 Mun. Brăila BRĂILA   45.2717266 27.9669803     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46574 46574 GRAND HOTEL ORIENT, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3- STELE 200   banquet 0 0 70 0 0   65 0 62.1 TCE 0.4 0.4 90 Mun. Brăila BRĂILA   45.2698193 27.9783705     RO-SITUR RESTAURANT CLASIC 3- STELE  
46590 46590 RESET IRISH PUB, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   65 0 62.5 TCE 0.8 0.8 91 Mun. Brăila BRĂILA   45.2647011 27.9700345     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46594 46594 SCUAR BY RESET PIZZA & GRILL, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   65 10 63.1 TCE 2.5 2.5 88 Mun. Brăila BRĂILA   45.252828 27.9556134     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46604 46604 MUSATINI, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 1 star 1 40   banquet 0 0 50 0 0   45 10 42.5 Boboc Air Base 38.7 0.2 8 Oraş Ianca, Sat Plopu BRĂILA   45.1476351 27.5120288     RO-SITUR RESTAURANT CLASIC 1  
46616 46616 GALERIA BRAN, RESTAURANT CU PROGRAM ARTISTIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 0 27.2 GHV 6.8 0.5 546 Com. Bran BRAŞOV   45.5003388 25.3320077     RO-SITUR RESTAURANT CU PROGRAM ARTISTIC 4 - STELE  
46629 46629 SPICE, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 STELE 60   banquet 0 0 50 0 0   80 0 23.9 GHV 6.2 1.6 486 Com. Bran BRAŞOV   45.5191918 25.3696831     RO-SITUR RESTAURANT CLASIC 2 STELE  
46633 46633 ALISA, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 2 star 2 90   banquet 0 0 60 0 0   80 0 24.1 GHV 6.0 1.3 487 Com. Bran, Sat Bran BRAŞOV   45.5188604 25.3666751     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 2  
46634 46634 CASA DIN BRAN, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE 58   banquet 0 0 50 0 0   80 0 24.1 GHV 6.4 1.6 488 Com. Bran, Sat Bran BRAŞOV   45.5169365 25.3701681     RO-SITUR RESTAURANT CLASIC 2 - STELE  
46641 46641 STUP, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 105   banquet 0 0 60 0 0   80 0 27.5 GHV 9.2 0.5 459 Com. Bran, Sat Şimon BRAŞOV   45.4849278852863 25.3630507270447     RO-SITUR RESTAURANT CLASIC 3  
46642 46642 XCLUSIVE, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 2 star 2 40   banquet 0 0 50 0 0   70 0 29.5 GHV 10.7 1.9 432 Com. Bran, Sat Şimon BRAŞOV   45.4680457 25.3545334     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 2  
46646 46646 R.O.O.T., RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 STELE 50   banquet 0 0 50 0 0   80 0 20.8 GHV 6.2 1.0 310 Com. Bran, Sat Sohodol BRAŞOV   45.5375661 25.4040089     RO-SITUR RESTAURANT CLASIC 3 STELE  
46664 46664 CASA MUNTELUI, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 2 star 2 - STELE 58   banquet 0 0 50 0 0   55 10 35.8 GHV 15.3 2.9 227 Com. Fundata BRAŞOV   45.4235314 25.3005457     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 2 - STELE  
46668 46668 PADINA URSULUI, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 75   banquet 0 0 50 0 0   55 10 35.8 GHV 15.3 2.9 227 Com. Fundata BRAŞOV   45.4235314 25.3005457     RO-SITUR RESTAURANT CLASIC 2  
46675 46675 KASTEL TRANSYLVANIA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE 100   banquet 0 0 60 0 0   80 0 12.1 GHV 8.6 1.2 33 Com. Hărman, Sat Hărman BRAŞOV   45.7068713 25.6780528     RO-SITUR RESTAURANT CLASIC 3 - STELE  
46694 46694 BELVEDERE MOIECIU, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE 45   banquet 0 0 50 0 0   55 0 31.6 GHV 11.5 1.7 408 Com. Moieciu, Sat Drumul Carului BRAŞOV   45.4577538 25.3228403     RO-SITUR RESTAURANT CLASIC 2 - STELE  
46701 46701 CA LA MAMA DORA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 0 27.6 GHV 6.9 0.9 544 Com. Moieciu, Sat Moieciu de Jos BRAŞOV   45.4991492 25.326995     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46702 46702 PODUL TURCULUI, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE 50   banquet 0 0 50 0 0   80 0 27.0 GHV 6.7 0.3 544 Com. Moieciu, Sat Moieciu de Jos BRAŞOV   45.5021722 25.3342182     RO-SITUR RESTAURANT CLASIC 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");