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

156,813 rows where family = "restaurants" and group = "eat_drink"

This data as json, CSV (advanced)

Suggested facets: valid_until (date)

country 6

rating_value 5

  • 2 4,249
  • 3 3,668
  • 1 3,263
  • 4 865
  • 5 208

group 1

  • eat_drink · 156,813 ✖

family 1

  • restaurants · 156,813 ✖

best_for 1

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
10557 10557 ΞΕΝΟΔΟΧΕΙΟ PARADISE LOST GR eat_drink restaurants restaurant normal   none         0 0 40 0 0                   ΑΡΓΟΛΙΔΑΣ ΑΝΑΓΝΩΣΤH ΣΚΑΛΙΔΗ 12, ΤΟΛΟ, ΤΚ 21056         GR-MINTOUR Εστιατόριο ΕΣΠΕΚ    
10558 10558 ΞΕΝΟΔΟΧΕΙΟ VALIS RESORT ΕΣΤΙΑΤΟΡΙΟ "ΤΟ ΤΣΙΠΟΥΡΑΔΙΚΟ" GR eat_drink restaurants restaurant normal   none         0 0 40 0 0                   ΜΑΓΝΗΣΙΑΣ ΣΤΑΘΜΟΣ ΑΓΡΙΑΣ ΒΟΛΟΥ, ΤΚ 37300         GR-MINTOUR Εστιατόριο ΕΣΠΕΚ    
10559 10559 ΕΣΤΙΑΤΟΡΙΟ REMETZO GR eat_drink restaurants restaurant normal   none         0 0 40 0 0                   ΑΤΤΙΚΗΣ ΠΕΡΔΙΚΑ , ΑΙΓΙΝΑ, ΤΚ 18010         GR-MINTOUR Εστιατόριο ΕΣΠΕΚ    
10560 10560 ΤΙΤΑΝΙΑ HOTEL - OLIVE GARDEN GR eat_drink restaurants restaurant normal   none         0 0 40 0 0                   ΑΤΤΙΚΗΣ ΠΑΝΕΠΙΣΤΗΜΙΟΥ 52, ΑΘΗΝΑ, ΤΚ 10678         GR-MINTOUR Εστιατόριο ΕΣΠΕΚ    
10561 10561 THERMAE SYLLA - ΜΕΣΟΓΕΙΟΣ GR eat_drink restaurants restaurant normal   none         0 0 40 0 0                   ΕΥΒΟΙΑΣ ΠΟΣΕΙΔΩΝΟΣ 2, Λ. ΑΙΔΗΨΟΥ, ΤΚ 34300         GR-MINTOUR Εστιατόριο ΕΣΠΕΚ    
10562 10562 ΚΡΗΤΩΝ ΓΕΥΣΕΙΣ…ΕΝ ΑΙΓΙΝΗ GR eat_drink restaurants restaurant normal   none         0 0 40 0 0                   ΑΤΤΙΚΗΣ Π. ΗΡΕΙΩΤΗ & ΔΑΜΩΝΟΣ, ΑΙΓΙΝΑ, ΤΚ 18010         GR-MINTOUR Εστιατόριο ΕΣΠΕΚ    
10563 10563 CLUB HOTEL LOUTRAKI - DEEP BLUE - ΒΑΘΥ ΜΠΛΕ GR eat_drink restaurants restaurant normal   none         0 0 40 0 0                   ΚΟΡΙΝΘΙΑΣ ΑΚΤΗ ΠΟΣΕΙΔΩΝΟΣ 48, ΛΟΥΤΡΑΚΙ, ΤΚ 20300         GR-MINTOUR Εστιατόριο ΕΣΠΕΚ    
10564 10564 DOMOTEL ΞΕΝΙΑ ΒΟΛΟΣ, SEA YOU (πρώην OPEN KITCHEN RESTAURANT) GR eat_drink restaurants restaurant normal   none         0 0 40 0 0                   ΜΑΓΝΗΣΙΑΣ ΠΛΑΣΤΗΡΑ 1, ΒΟΛΟΣ, ΤΚ 38222         GR-MINTOUR Εστιατόριο ΕΣΠΕΚ    
10565 10565 MEDITERRANEAN HOTEL - THALASSA GR eat_drink restaurants restaurant normal   none         0 0 40 0 0                   ΔΩΔΕΚΑΝΗΣΟΥ ΚΩ 35-37, ΡΟΔΟΣ, ΤΚ 85100         GR-MINTOUR Εστιατόριο ΕΣΠΕΚ    
10566 10566 BOLIVAR GR eat_drink restaurants restaurant normal   none         0 0 40 0 0                   ΑΤΤΙΚΗΣ Λ. ΠΟΣΕΙΔΩΝΟΣ, ΑΚΤΗ ΤΟΥ ΗΛΙΟΥ, ΣΥΓΚΡΟΤΗΜΑ ΠΛΑΖ ΑΛΙΜΟΥ, ΑΛΙΜΟΣ ΤΚ 174 55         GR-MINTOUR Εστιατόριο ΕΣΠΕΚ    
10567 10567 ΠΕΡΕΚ GR eat_drink restaurants restaurant normal   none         0 0 40 0 0                   ΘΕΣΣΑΛΟΝΙΚΗΣ ΜΟΝΟΠΗΓΑΔΟ ΘΕΡΜΗ,Σ ΘΕΣΣΑΛΟΝΙΚΗ, ΤΚ 57006         GR-MINTOUR Εστιατόριο ΕΣΠΕΚ    
10568 10568 ΑΚΤΗ ΑΤΛΑΝΤΙΣ GR eat_drink restaurants restaurant normal   none         0 0 40 0 0                   ΡΕΘΥΜΝΟΥ ΑΡΗ ΒΕΛΟΥΧΙΩΤΗ 28, ΡΕΘΥΜΝΟ ΤΚ 74133         GR-MINTOUR Εστιατόριο ΕΣΠΕΚ    
10569 10569 ΝΑΟΣ ΣΑΝΤΟΡΙΝΗ GR eat_drink restaurants restaurant normal   none         0 0 40 0 0                   ΚΥΚΛΑΔΩΝ Ν.ΝΟΜΙΚΟΥ, ΘΗΡΑ, ΤΚ 84702         GR-MINTOUR Εστιατόριο ΕΣΠΕΚ    
10570 10570 OREGANO-ATLANTICA CALDERA PALACE-ΗΡΑΚΛΕΙΟ GR eat_drink restaurants restaurant normal   none         0 0 40 0 0                   ΚΡΗΤΗΣ ΑΝΑΛΗΨΗ ΧΕΡΣΟΝΗΣΟΥ, ΚΡΗΤΗ, ΤΚ 70014         GR-MINTOUR Εστιατόριο ΕΣΠΕΚ    
10571 10571 ΕΣΤΙΑΤΟΡΙΟ ΜΑΡΓΙΩΡΑ - ΧΩΡΑ ΚΥΘΝΟΥ GR eat_drink restaurants restaurant normal   none         0 0 40 0 0                   ΚΥΚΛΑΔΩΝ ΧΩΡΑ ΚΥΘΝΟΥ - ΚΥΘΝΟΣ, ΤΚ 84006         GR-MINTOUR Εστιατόριο ΕΣΠΕΚ    
10572 10572 WESURFIN BEACH RESTO GR eat_drink restaurants restaurant normal   none         0 0 40 0 0                   ΚΥΚΛΑΔΩΝ ΠΕΡΙΦΕΡΕΙΑΚΗ ΟΔΟΣ ΓΑΥΡΙΟΥ- ΜΠΑΤΣΙ - ΚΥΠΡΙ - ΑΝΔΡΟΣ, ΤΚ 84501         GR-MINTOUR Εστιατόριο ΕΣΠΕΚ    
10573 10573 ΕΛΛΗΝΙΚΟ ΕΣΤΙΑΤΟΡΙΟ ΓΛΑΡΟΣ GLAROS - ΞΕΝΟΔΟΧΕΙΟ ATLANTICA KALLISTON GR eat_drink restaurants restaurant normal   none         0 0 40 0 0                   ΧΑΝΙΩΝ ΓΛΑΡΟΣ ΚΥΔΩΝΙΑΣ, ΠΑΛ ΕΘΝΙΚΗ ΟΔΟΣ ΧΑΝΙΩΝ - ΚΙΣΣΑΜΟΥ, ΧΑΝΙΑ, ΤΚ 73100         GR-MINTOUR Εστιατόριο ΕΣΠΕΚ    
10574 10574 ΕΣΤΙΑΤΟΡΙΟ LEVANTE GR eat_drink restaurants restaurant normal   none         0 0 40 0 0                   ΕΥΒΟΙΑΣ ΕΡΕΤΡΙΑΣ 19, ΘΕΣΗ ΜΑΛΑΚΩΝΤΑ, ΕΥΒΟΙΑ, ΤΚ 34008         GR-MINTOUR Εστιατόριο ΕΣΠΕΚ    
10575 10575 ΜΑΙΑΜΙ GR eat_drink restaurants restaurant normal   none         0 0 40 0 0                   ΘΕΣΣΑΛΟΝΙΚΗΣ ΘΕΤΙΔΟΣ 18, ΚΑΛΑΜΑΡΙΑ ΘΕΣΣΑΛΟΝΙΚΗ, ΤΚ 55135         GR-MINTOUR Εστιατόριο ΕΣΠΕΚ    
10576 10576 ΞΕΝΟΔΟΧΕΙΟ ESPERAS ΣΑΝΤΟΡΙΝΗ - ΕΣΤΙΑΤΟΡΙΟ OMBRA GR eat_drink restaurants restaurant normal   none         0 0 40 0 0                   ΚΥΚΛΑΔΩΝ ΟΙΑ ΣΑΝΤΟΡΙΝΗΣ ΤΚ 84702         GR-MINTOUR Εστιατόριο ΕΣΠΕΚ    
10577 10577 ΕΣΤΙΑΤΟΡΙΟ BLUE FISH GR eat_drink restaurants restaurant normal   none         0 0 40 0 0                   ΑΤΤΙΚΗΣ ΠΟΣΕΙΔΩΝΟΣ 4, ΒΟΥΛΑ, ΤΚ 16671         GR-MINTOUR Εστιατόριο ΕΣΠΕΚ    
10578 10578 ΕΣΤΙΑΤΟΡΙΟ ΔΙΟΓΕΝΗΣ ΠΛΑΚΑ GR eat_drink restaurants restaurant normal   none         0 0 40 0 0                   ΑΤΤΙΚΗΣ ΠΛΑΤΕΙΑ ΛΥΣΙΚΡΑΤΟΥΣ 1-3, ΠΛΑΚΑ, ΤΚ 10558         GR-MINTOUR Εστιατόριο ΕΣΠΕΚ    
10579 10579 ΕΣΤΙΑΤΟΡΙΟ ΑΣΤΑΚΟΣ ΓΛΥΦΑΔΑ GR eat_drink restaurants restaurant normal   none         0 0 40 0 0                   ΑΤΤΙΚΗΣ ΔΙΑΔΟΧΟΥ ΠΑΥΛΟΥ 46, ΓΛΥΦΑΔΑ Τ.Κ. 16675         GR-MINTOUR Εστιατόριο ΕΣΠΕΚ    
10580 10580 ΕΣΤΙΑΤΟΡΙΟ LEDA & ΤΗΕ SWAN ΞΕΝΟΔΟΧΕΙΟ ELIVI ΣΚΙΑΘΟΣ GR eat_drink restaurants restaurant normal   none         0 0 40 0 0                   ΣΠΟΡΑΔΕΣ ΚΟΥΚΟΥΝΑΡΙΕΣ ΣΚΙΑΘΟΣ, 37002         GR-MINTOUR Εστιατόριο ΕΣΠΕΚ    
10581 10581 ΕΣΤΙΑΤΟΡΙΟ ZONAR'S ΔΙΟΝΥΣΟΣ ΠΛΑΚΑ - DIONYSOS ZONAR'S GR eat_drink restaurants restaurant normal   none         0 0 40 0 0                   ΑΤΤΙΚΗΣ ΡΟΒΕΡΤΟΥ ΓΚΑΛΛΙ 43, ΑΘΗΝΑ Τ.Κ. 11742         GR-MINTOUR Εστιατόριο ΕΣΠΕΚ    
10582 10582 ΕΣΤΙΑΤΟΡΙΟ ΣΧΕΔΙΑ ΚΟΙΝ. Σ.Ε.Π. GR eat_drink restaurants restaurant normal   none         0 0 40 0 0                   ΑΤΤΙΚΗΣ ΚΟΛΟΚΟΤΡΩΝΗ 56, ΑΘΗΝΑ, 10560         GR-MINTOUR Εστιατόριο ΕΣΠΕΚ    
10583 10583 KYMI PALACE RESTAURANT GR eat_drink restaurants restaurant normal   none         0 0 40 0 0                   ΕΥΒΟΙΑΣ ΠΑΡΑΛΙΑ ΚΥΜΗΣ ΕΥΒΟΙΑ ΤΚ. 34003         GR-MINTOUR Εστιατόριο ΕΣΠΕΚ    
10584 10584 ΕΣΤΙΑΤΟΡΙΟ DEL MARE GR eat_drink restaurants restaurant normal   none         0 0 40 0 0                   ΦΘΙΩΤΙΔΑΣ ΓΛΥΦΑ ΦΘΙΩΤΙΔΑΣ, ΤΚ 35013         GR-MINTOUR Εστιατόριο ΕΣΠΕΚ    
10585 10585 ΕΣΤΙΑΤΟΡΙΟ ΚΑΛΑΜΑΤΙΑΝΟΣ GR eat_drink restaurants restaurant normal   none         0 0 40 0 0                   ΘΕΣΣΑΛΟΝΙΚΗΣ ΣΤΑΥΡΟΣ ΘΕΣΣΑΛΟΝΙΚΗΣ, ΤΚ 57014         GR-MINTOUR Εστιατόριο ΕΣΠΕΚ    
10586 10586 CROCΟ MYKONOS GR eat_drink restaurants restaurant normal   none         0 0 40 0 0                   ΚΥΚΛΑΔΩΝ ΤΟΥΡΛΟΣ ΜΥΚΟΝΟΥ ΤΚ 84600         GR-MINTOUR Εστιατόριο ΕΣΠΕΚ    
10587 10587 ΝΟΣΤΟΣ ΓΕΥΣΕΩΝ GR eat_drink restaurants restaurant normal   none         0 0 40 0 0                   ΕΥΡΥΤΑΝΙΑΣ 3ο ΧΛΜ ΚΑΡΠΕΝΗΣΙΟΥ ΠΡΟΥΣΣΟΥ, ΤΚ 36100         GR-MINTOUR Εστιατόριο ΕΣΠΕΚ    
10588 10588 ΕΣΤΙΑΤΟΡΙΟ ΝΙΝΕΜΙΑ GR eat_drink restaurants restaurant normal   none         0 0 40 0 0                   ΕΥΒΟΙΑΣ ΟΝΕΙΡΩΝ 2, ΕΡΕΤΡΙΑ ΤΚ 34008         GR-MINTOUR Εστιατόριο ΕΣΠΕΚ    
10589 10589 ΕΚΕΙΜΕΡΟΣ GR eat_drink restaurants restaurant normal   none         0 0 40 0 0                   ΗΜΑΘΙΑΣ ΝΕΟΣ ΠΡΟΔΡΟΜΟΣ - ΘΕΣΗ ΜΟΔΙ, ΤΚ 59031         GR-MINTOUR Εστιατόριο ΕΣΠΕΚ    
10590 10590 ΙΠΠΟΤΙΚΟΝ GR eat_drink restaurants restaurant normal   none         0 0 40 0 0                   ΚΥΚΛΑΔΩΝ ΔΗΜΟΣΘΕΝΟΥΣ, ΡΟΔΟΣ 5 ΤΚ 85100         GR-MINTOUR Εστιατόριο ΕΣΠΕΚ    
10591 10591 Ν.Ο.Τ. GR eat_drink restaurants restaurant normal   none         0 0 40 0 0                   ΑΤΤΙΚΗΣ ΒΟΥΤΑΔΩΝ 16, ΑΘΗΝΑ, ΤΚ 11854         GR-MINTOUR Εστιατόριο ΕΣΠΕΚ    
10592 10592 SELINI - ΞΕΝΟΔΟΧΕΙΟ FZEEN RETREATS GR eat_drink restaurants restaurant normal   none         0 0 40 0 0                   ΚΕΦΑΛΛΗΝΙΑΣ ΛΟΥΔΑΤΑ ΚΕΦΑΛΛΟΝΙΑ, ΤΚ 28083         GR-MINTOUR Εστιατόριο ΕΣΠΕΚ    
10593 10593 ΕΣΤΙΑΤΟΡΙΟ ΕΝΤΟΣ ΤΟΥ ΞΕΝΟΔΟΧΕΙΟΥ CAMVILLIA RESORT GR eat_drink restaurants restaurant normal   none         0 0 40 0 0                   ΜΕΣΣΗΝΙΑ ΒΟΥΝΑΡΙΑ ΚΟΡΩΝΗΣ ΜΕΣΣΗΝΙΑΣ, ΤΚ 24004         GR-MINTOUR Εστιατόριο ΕΣΠΕΚ    
10594 10594 ΑΥΛΗ ΣΤΑ ΜΑΛΛΙΑ GR eat_drink restaurants restaurant normal   none         0 0 40 0 0                   ΚΡΗΤΗΣ ΑΓΙΟΥ ΙΩΑΝΝΟΥ 1 & 28ης ΟΚΤΩΒΡΙΟΥ, ΜΑΛΙΑ-ΤΚ 70007         GR-MINTOUR Εστιατόριο ΕΣΠΕΚ    
10595 10595 PIATO CREATIVE GREEK CUISINE GR eat_drink restaurants restaurant normal   none         0 0 40 0 0                   ΚΡΗΤΗΣ ΑΚΤΗ ΙΩΣΗΦ ΚΟΥΝΔΟΥΡΟΥ 8, ΑΓΙΟΣ ΝΙΚΟΛΑΟΣ, ΤΚ 72100         GR-MINTOUR Εστιατόριο ΕΣΠΕΚ    
45444 45444 STEAUA ARIESULUI, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   45 0 67.0 CLJ 37.9 0.2 30 Com. Albac ALBA   46.452808 22.954159     RO-SITUR RESTAURANT CLASIC 2 - STELE  
45446 45446 PERLA APUSENILOR, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   45 0 68.3 CLJ 36.9 1.1 30 Com. Albac, Sat Pleşeşti ALBA   46.4469616 22.9399791     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 3 - STELE  
45447 45447 CABANA VARTOP, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   30 20 81.9 OMR 43.1 7.5 38 Com. Arieşeni ALBA   46.5142687 22.6771063     RO-SITUR RESTAURANT CLASIC 2 - STELE  
45448 45448 CASA MOTULUI, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   30 0 80.4 CLJ 38.7 1.9 86 Com. Arieşeni ALBA   46.4795259 22.7324206     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45449 45449 GIANINA, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   45 0 79.0 CLJ 38.3 0.2 94 Com. Arieşeni ALBA   46.4767851 22.7543707     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 3 - STELE  
45450 45450 SARRA VANK, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   45 0 79.0 CLJ 38.3 0.2 94 Com. Arieşeni ALBA   46.4767851 22.7543707     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45451 45451 SKY HUB, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   45 0 78.5 CLJ 37.1 1.4 104 Com. Arieşeni ALBA   46.4666561 22.7682126     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 2 - STELE  
45452 45452 TAVERNA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   45 0 79.0 CLJ 38.3 0.2 94 Com. Arieşeni ALBA   46.4767851 22.7543707     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45453 45453 VANK, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   45 0 79.3 CLJ 38.3 0.6 91 Com. Arieşeni ALBA   46.4766179 22.7499137     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 2 - STELE  
45454 45454 VRAJA MUNTELUI, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   30 20 81.2 CLJ 41.8 5.2 93 Com. Arieşeni ALBA   46.5051118 22.7036806     RO-SITUR RESTAURANT CLASIC 2 - STELE  
45455 45455 ELA & CĂTĂ, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   45 10 65.5 Câmpia Turzii Air Base 33.1 0.5 17 Com. Bistra ALBA   46.3639212 23.0556952     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 2 - STELE  
45457 45457 BLEUMARIN, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   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 RESTAURANT CLASIC 3 - STELE  
45458 45458 LA VERDINA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 STELE 30     0 0 40 0 0   55 10 39.4 Câmpia Turzii Air Base 14.7 0.1 9 Com. Galda de Jos, Sat Benic ALBA   46.2124985 23.5914445     RO-SITUR RESTAURANT CLASIC 2 STELE  
45459 45459 FLOARE DE COLŢ, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   55 30 39.8 Câmpia Turzii Air Base 16.6 4.4 3 Com. Galda de Jos, Sat Poiana Galdei ALBA   46.2433979 23.527937     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45460 45460 CASA BUNĂ, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   55 20 33.2 SBZ 12.9 2.1 7 Com. Gârbova ALBA   45.8650605 23.674016     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45461 45461 POARTA OILOR, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   70 10 29.5 SBZ 15.8 1.3 6 Com. Gârbova ALBA   45.8593251 23.7201921     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 2 - STELE  
45462 45462 CONACUL SAMFIREI, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   45 0 73.7 CLJ 36.4 1.0 34 Com. Gârda de Sus ALBA   46.4579234 22.8470327     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45463 45463 MAMA UŢA, RESTAURANT CU SPECIFIC NAȚIONAL RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   45 0 76.6 CLJ 36.0 1.2 70 Com. Gârda de Sus ALBA   46.4568635 22.805182     RO-SITUR RESTAURANT CU SPECIFIC NAȚIONAL 3 - STELE  
45465 45465 ONELIA, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   45 0 76.8 CLJ 36.0 1.3 70 Com. Gârda de Sus ALBA   46.4563802 22.8022573     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 3 - STELE  
45467 45467 LA VIE, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   45 10 75.1 CLJ 39.6 3.7 76 Com. Gârda de Sus, Sat Izvoarele ALBA   46.4888357 22.8028004     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45468 45468 CĂSUŢA DIN POVEŞTI, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   45 0 64.5 CLJ 42.7 0.3 37 Com. Horea ALBA   46.4997283 22.9505161     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 2 - STELE  
45469 45469 COTA 1600 PETREASA, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   45 10 63.2 CLJ 46.4 3.8 29 Com. Horea, Sat Petreasa ALBA   46.5361053 22.9424224     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 3 - STELE  
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  
45471 45471 CASTEL TEMPLUL CAVALERILOR, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   80 20 25.9 Câmpia Turzii Air Base 8.0 0.2 3 Com. Livezile, Sat Livezile ALBA   46.3479534 23.631976     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45472 45472 CASA APUSEANA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   45 20 54.1 Câmpia Turzii Air Base 40.1 0.6 4 Com. Lupşa ALBA   46.3690965 23.2063265     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45473 45473 GALAXY, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   45 20 54.1 Câmpia Turzii Air Base 40.1 0.6 4 Com. Lupşa ALBA   46.3690965 23.2063265     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45474 45474 MAMA LUTA, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   55 10 53.8 Câmpia Turzii Air Base 10.9 1.0 10 Com. Meteş ALBA   46.1171325 23.4626738     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 2 - STELE  
45475 45475 CASA AMPOIŢANĂ, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   55 10 53.2 Câmpia Turzii Air Base 10.2 1.8 14 Com. Meteş, Sat Ampoiţa ALBA   46.1182608 23.4735226     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 2 - STELE  
45476 45476 CASA AMPEIA, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   65 10 55.7 Câmpia Turzii Air Base 9.6 0.3 7 Com. Meteş, Sat Tăuţi ALBA   46.0940497 23.4658928     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 2 - STELE  
45477 45477 GELA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   80 20 16.3 Câmpia Turzii Air Base 6.6 0.1 1 Com. Mirăslău ALBA   46.3824267 23.764068     RO-SITUR RESTAURANT CLASIC 2 - STELE  
45479 45479 GE-LUX, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   45 50 47.5 Câmpia Turzii Air Base 39.0 8.9 0 Com. Poşaga, Sat Inceşti ALBA   46.4674718 23.267582     RO-SITUR RESTAURANT CLASIC 2 - STELE  
45480 45480 CASA KIRALY VENDEGHAZ, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   70 0 25.0 Câmpia Turzii Air Base 20.2 0.8 45 Com. Rimetea ALBA   46.4568176 23.5659942     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 2 - STELE  
45481 45481 CONACUL SECUIESC I, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   70 0 26.1 Câmpia Turzii Air Base 17.5 0.2 42 Com. Rimetea ALBA   46.4241956 23.5641929     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 3 - STELE  
45482 45482 PERLA TRASCĂULUI, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   70 10 23.5 Câmpia Turzii Air Base 18.0 3.9 37 Com. Rimetea ALBA   46.4839922 23.5806213     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45483 45483 CODRU, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   55 10 36.9 Câmpia Turzii Air Base 24.7 0.5 9 Com. Sălciua ALBA   46.4000233 23.4275147     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45484 45484 SUB PIATRA, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   55 20 35.2 Câmpia Turzii Air Base 21.6 3.5 9 Com. Sălciua ALBA   46.3833121 23.4607753     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 2 - STELE  
45485 45485 PODUL CETĂŢII, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   65 10 40.9 SBZ 8.6 1.3 10 Com. Săsciori ALBA   45.8789306 23.5761176     RO-SITUR RESTAURANT CLASIC 2 - STELE  
45486 45486 ALEX & TONI, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   65 10 48.0 SBZ 3.8 3.0 34 Com. Săsciori, Sat Sebeşel ALBA   45.9701267 23.5257476     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  
45488 45488 OLIMPIC, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   55 20 31.6 SBZ 13.4 0.1 4 Com. Şpring ALBA   45.9380803 23.7420489     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45489 45489 CASA DAVID, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   55 0 34.1 SBZ 22.0 0.6 22 Com. Şugag ALBA   45.766502 23.6481876     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 2 - STELE  
45490 45490 NEDEI HOTEL&SPA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   55 10 36.6 SBZ 18.0 0.6 19 Com. Şugag ALBA   45.7973968 23.6148127     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45492 45492 SF. PETRU, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   55 40 48.9 SBZ 17.2 15.5 8 Com. Şugag ALBA   45.5838755 23.527565     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45494 45494 VALEA FRUMOASEI, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   55 0 35.5 SBZ 20.7 0.9 22 Com. Şugag ALBA   45.7747999 23.629573     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 2 - STELE  
45495 45495 COLŢ DIN RAI, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   55 40 49.1 SBZ 17.2 15.5 8 Com. Şugag, Sat Tău Bistra ALBA   45.5861587 23.5222225     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 3 - STELE  
45496 45496 COTUL ARIEŞULUI, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   45 20 69.1 CLJ 32.5 2.2 11 Com. Vadu Moţilor ALBA   46.3888 22.99     RO-SITUR RESTAURANT CLASIC 2 - 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  
45499 45499 MELINDA, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   80 10 24.3 Câmpia Turzii Air Base 1.3 1.3 17 Mun. Aiud ALBA   46.3085781 23.7380219     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 2 - STELE  
45500 45500 MOBIS, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   80 10 24.1 Câmpia Turzii Air Base 0.8 0.8 17 Mun. Aiud ALBA   46.3177485 23.7214069     RO-SITUR RESTAURANT CLASIC 2 - STELE  
45501 45501 TRANSILVANIA CASA ŞI MASA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   80 10 25.6 Câmpia Turzii Air Base 0.8 0.8 17 Mun. Aiud ALBA   46.3045497 23.7152587     RO-SITUR RESTAURANT CLASIC 3 - 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  
45504 45504 ASTORIA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   65 0 49.9 SBZ 0.9 0.9 191 Mun. Alba Iulia ALBA   46.0598655 23.5766037     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45506 45506 CASA TRAIANA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   65 0 51.3 SBZ 2.2 1.5 182 Mun. Alba Iulia ALBA   46.0861184 23.5832981     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45508 45508 CETATE, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   65 0 50.9 SBZ 1.1 1.1 191 Mun. Alba Iulia ALBA   46.0688966 23.5688882     RO-SITUR RESTAURANT CLASIC 2 - 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  
45510 45510 CROWN ROYAL, BRASERIE SAU BISTROU RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   65 0 51.2 SBZ 1.8 1.8 185 Mun. Alba Iulia ALBA   46.0823356 23.579963     RO-SITUR BRASERIE SAU BISTROU 3 - STELE  
45511 45511 EAGLE RAY, RESTAURANT CU SPECIFIC NAȚIONAL RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   65 0 49.9 SBZ 0.1 0.1 191 Mun. Alba Iulia ALBA   46.0662255 23.5832138     RO-SITUR RESTAURANT CU SPECIFIC NAȚIONAL 3 - STELE  
45513 45513 ELISABETA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   65 0 52.7 Câmpia Turzii Air Base 2.9 1.7 167 Mun. Alba Iulia ALBA   46.0859029 23.5584424     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45514 45514 ELISABETA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   65 0 52.6 Câmpia Turzii Air Base 2.7 1.8 167 Mun. Alba Iulia ALBA   46.0860794 23.5617206     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45515 45515 FLAMINGO, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   65 0 50.4 SBZ 0.5 0.5 191 Mun. Alba Iulia ALBA   46.068374 23.577362     RO-SITUR RESTAURANT CLASIC 2 - STELE  
45517 45517 HANUL CU BERZE, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   65 0 49.5 SBZ 3.3 0.9 159 Mun. Alba Iulia ALBA   46.0412652 23.5623064     RO-SITUR RESTAURANT CLASIC 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");