venues

Data license: Compiled from official public government tourism registers · Data source: National tourism registers (BG · RO · GB · ES · FR · PT · PL · IE · HR · GR · ME)

group
Top group: Stay / Eat & Drink / Other
family
Simplified family (Hotels, Guesthouses, Restaurants, Bars & Pubs…)
venue_type
Detailed canonical type (see the venue_types table)
type_granularity
'coarse' when the source lumps several real types (e.g. UK FSA)
rating_value
Normalized 1–5 grade, or blank if unrated
rating_scheme
star / key / flower / approved / none (see rating_schemes)
rating_label
Original rating string from the source (provenance)
source_type
Original type string from the national register (provenance)
source_category
Original category/rating field from the register
capacity_persons
Comparable headline capacity — beds/guests (stay) or seats (food)
rooms
Number of rooms / units (accommodation)
best_for
The single event this venue is best suited to (blank = not an event venue)
fit_wedding
Wedding-suitability score 0–100 (type + capacity + rating)
fit_conference
Conference-suitability score 0–100
fit_banquet
Banquet-suitability score 0–100
fit_spa
Spa-retreat-suitability score 0–100
fit_party
Party/celebration-suitability score 0–100
common_areas
On-site shared function space, from the register only (event_venue) — blank = not stated, never inferred
reachability_score
How easy to reach 0–100 (nearer airport + city = higher)
isolation_score
How remote 0–100 (farther from towns + fewer nearby venues = higher)
airport_km
Distance to nearest airport (km)
nearest_airport
Nearest airport (IATA or name)
city_km
Distance to nearest city ≥15k people (km)
town_km
Distance to nearest settlement ≥500 people (km)
venues_5km
Number of other venues within 5 km (local density)
cert_number
Certificate / registration number in the national register
source
Source register the row came from

1,590 rows where best_for = "banquet", group = "eat_drink" and rating_value = 3

This data as json, CSV (advanced)

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

family 4

country 2

rating_value 1

  • 3 · 1,590 ✖

group 1

  • eat_drink · 1,590 ✖

best_for 1

  • banquet · 1,590 ✖

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
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
46554 46554 PERLA, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 40   banquet 0 0 50 0 0   65 10 65.0 TCE 7.8 2.2 42 Com. Chiscani, Sat Chiscani BRĂILA   45.2155144 27.9149728     RO-SITUR SNACK-BAR 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  
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  
46640 46640 NECTAR, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 42   banquet 0 0 50 0 45   80 0 27.5 GHV 9.1 0.5 462 Com. Bran, Sat Şimon BRAŞOV   45.4849579730916 25.3630292693726     RO-SITUR BAR DE ZI 3  
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  
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  
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  
46717 46717 ZODIA CRAIULUI, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 STELE 48   banquet 0 0 50 0 0   80 0 27.7 GHV 7.1 1.0 538 Com. Moieciu, Sat Peştera BRAŞOV   45.4974009 25.3275309     RO-SITUR RESTAURANT CLASIC 3 STELE  
46800 46800 CITRIN, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE 70   banquet 0 0 50 0 0   80 0 9.3 GHV 0.5 0.5 1180 Mun. Braşov BRAŞOV   45.6498881 25.611657     RO-SITUR RESTAURANT CLASIC 3 - STELE  
46833 46833 JASMINE, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 40   banquet 0 0 50 0 0   80 0 8.1 GHV 1.4 1.4 1173 Mun. Braşov BRAŞOV   45.6608285 25.6046761     RO-SITUR RESTAURANT CLASIC 3  
46873 46873 REGAL, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE 40   banquet 0 0 50 0 0   80 0 7.5 GHV 1.6 1.6 1172 Mun. Braşov BRAŞOV   45.6597678 25.5933014     RO-SITUR RESTAURANT CLASIC 3 - STELE  
46889 46889 SERGIANA-CORESI SHOPPING RESORT, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 STELE 92   banquet 0 0 60 0 0   80 10 8.4 GHV 3.0 3.0 1111 Mun. Braşov BRAŞOV   45.6731678 25.6207622     RO-SITUR RESTAURANT CLASIC 3 STELE  
46925 46925 CASA VIOREL, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3- STELE 88   banquet 0 0 60 0 0   80 20 12.4 GHV 6.6 5.1 297 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.597786 25.5619193     RO-SITUR RESTAURANT CLASIC 3- STELE  
46931 46931 EL BACHA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE 60   banquet 0 0 50 0 0   80 20 12.4 GHV 7.4 6.0 244 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.5954554 25.5489389     RO-SITUR RESTAURANT CLASIC 3 - STELE  
46944 46944 MONTERAI, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE 120   banquet 0 0 60 0 0   80 20 11.0 GHV 6.0 6.0 646 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.6092027267224 25.5540482423279     RO-SITUR RESTAURANT CLASIC 3 - STELE  
46947 46947 NOIR, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE 250   banquet 0 0 70 0 0   80 20 11.4 GHV 6.9 6.1 287 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.6044189 25.543052     RO-SITUR RESTAURANT CLASIC 3 - STELE  
46964 46964 SIHA RESTAURANT & LOUNGE, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE 75   banquet 0 0 50 0 0   80 20 12.2 GHV 7.0 5.8 265 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.5982101 25.5523649     RO-SITUR RESTAURANT CLASIC 3 - STELE  
46971 46971 Vanatorul, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 144   banquet 0 0 60 0 0   80 20 12.4 GHV 7.3 5.8 250 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.5955044 25.5513291     RO-SITUR RESTAURANT CLASIC 3  
46997 46997 Q , BRASERIE SAU BISTROU RO eat_drink restaurants restaurant normal 3 star 3 98   banquet 0 0 60 0 0   80 0 18.9 GHV 1.2 1.2 56 Mun. Săcele BRAŞOV   45.6088979 25.7223343     RO-SITUR BRASERIE SAU BISTROU 3  
47013 47013 ANDY GRAND RESTAURANT, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE 79   banquet 0 0 50 0 0   70 0 21.9 GHV 12.2 1.2 352 Oraş Predeal BRAŞOV   45.5111503 25.5677452     RO-SITUR RESTAURANT CLASIC 3 - STELE  
47058 47058 EDEN GRAND RESORT, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE 100   banquet 0 0 60 0 0   70 10 22.3 GHV 13.6 2.2 337 Oraş Predeal BRAŞOV   45.5105307 25.5909466     RO-SITUR RESTAURANT CLASIC 3 - STELE  
47094 47094 MOUNTAIN VIEW, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE 50   banquet 0 0 50 0 0   70 0 23.2 GHV 13.6 1.0 340 Oraş Predeal BRAŞOV   45.5008012 25.5793007     RO-SITUR RESTAURANT CLASIC 3 - STELE  
47112 47112 SKI&SKY, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 110   banquet 0 0 60 0 0   70 0 23.1 GHV 13.5 0.8 340 Oraş Predeal BRAŞOV   45.5009137 25.5763884     RO-SITUR RESTAURANT CLASIC 3  
47225 47225 AQUARIUS, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE 56   banquet 0 0 50 0 0   70 0 27.6 Boboc Air Base 15.1 0.2 41 Com. Merei, Sat Sărata-Monteoru BUZĂU   45.1475653 26.6409383     RO-SITUR RESTAURANT CLASIC 3 - STELE  
47228 47228 CAZINO, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE 246   banquet 0 0 70 0 0   70 0 28.1 Boboc Air Base 15.7 0.7 41 Com. Merei, Sat Sărata-Monteoru BUZĂU   45.1484629 26.6332925     RO-SITUR RESTAURANT CLASIC 3 - STELE  
47247 47247 IZVORANU, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 3 star 3 94   banquet 0 0 60 0 0   55 10 31.0 Boboc Air Base 21.8 3.5 27 Com. Tisău, Sat Izvoranu BUZĂU   45.2354856791621 26.5832933428528     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 3  
47249 47249 KVD EVENTS, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE 300   banquet 0 0 70 0 0   80 10 17.4 Boboc Air Base 2.5 0.2 20 Com. Valea Râmnicului, Sat Oreavul BUZĂU   45.3692289 27.0245686     RO-SITUR RESTAURANT CLASIC 3 - STELE  
47256 47256 ART TRATORIA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE 62   banquet 0 0 50 0 0   80 0 14.5 Boboc Air Base 1.3 1.3 138 Mun. Buzău BUZĂU   45.1528554 26.8167224     RO-SITUR RESTAURANT CLASIC 3 - STELE  
47272 47272 FREEDOM & RELAX, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 100   banquet 0 0 60 0 0   80 0 14.7 Boboc Air Base 1.9 1.9 138 Mun. Buzău BUZĂU   45.157174 26.81074     RO-SITUR RESTAURANT CLASIC 3  
47291 47291 UVA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE 60   banquet 0 0 50 0 0   80 0 14.8 Boboc Air Base 1.3 1.3 137 Mun. Buzău BUZĂU   45.14165 26.82247     RO-SITUR RESTAURANT CLASIC 3 - STELE  
47293 47293 AVO GASTROHAN, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE 110   banquet 0 0 60 0 0   80 10 18.1 Boboc Air Base 1.7 1.0 20 Mun. Râmnicu Sărat BUZĂU   45.3746032 27.0316467     RO-SITUR RESTAURANT CLASIC 3 - STELE  
47449 47449 BRÂNDUŞA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE 125   banquet 0 0 60 0 0   80 20 23.8 CSB 8.3 4.1 16 Mun. Reşiţa CARAŞ-SEVERIN   45.3054742 21.9952726     RO-SITUR RESTAURANT CLASIC 3 - STELE  
47474 47474 ORA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 41   banquet 0 0 50 0 0   65 0 31.3 CSB 2.0 2.0 70 Mun. Reşiţa CARAŞ-SEVERIN   45.317504 21.8799649     RO-SITUR RESTAURANT CLASIC 3  
47577 47577 MARTY PLAZA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 136   banquet 0 0 60 0 0   80 10 9.0 CLJ 2.2 2.2 1199 CLUJ-NAPOCA CLUJ   46.7636298 23.571808     RO-SITUR RESTAURANT CLASIC 3  
47642 47642 DALIA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE 40   banquet 0 0 50 0 0   70 10 24.9 CLJ 18.2 3.6 25 Com. Gilău, Sat Gilău CLUJ   46.7645834316093 23.3605296423279     RO-SITUR RESTAURANT CLASIC 3 - STELE  
47790 47790 CAMPEADOR INN, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE 100   banquet 0 0 60 0 0   80 10 4.2 CLJ 2.9 2.9 1082 Mun. Cluj-Napoca CLUJ   46.7822674 23.6306684     RO-SITUR RESTAURANT CLASIC 3 - STELE  
47850 47850 CRISTAL, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE 60   banquet 0 0 50 0 0   80 10 9.0 CLJ 2.1 2.1 1209 Mun. Cluj-Napoca CLUJ   46.7647727 23.5723363     RO-SITUR RESTAURANT CLASIC 3 - STELE  
47871 47871 DESAGA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 215   banquet 0 0 70 0 0   80 10 9.7 CLJ 3.0 3.0 1118 Mun. Cluj-Napoca CLUJ   46.768396728237 23.5613124907379     RO-SITUR RESTAURANT CLASIC 3  
48011 48011 MARTY CITY, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 184   banquet 0 0 70 0 0   80 10 4.8 CLJ 2.0 2.0 1147 Mun. Cluj-Napoca CLUJ   46.7725505 23.6254121     RO-SITUR RESTAURANT CLASIC 3  
48014 48014 MARTY RESTAURANTS, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE 123   banquet 0 0 60 0 0   80 0 7.7 CLJ 1.1 1.1 1222 Mun. Cluj-Napoca CLUJ   46.7717581 23.5872748     RO-SITUR RESTAURANT CLASIC 3 - STELE  
48015 48015 MARTY SPORTS BAR & GRILL, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 180   banquet 0 0 70 0 0   80 0 7.7 CLJ 1.2 1.2 1222 Mun. Cluj-Napoca CLUJ   46.7561626 23.5944239     RO-SITUR RESTAURANT CLASIC 3  
48016 48016 MARTY WEST SIDE, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE 138   banquet 0 0 60 0 0   80 10 12.2 CLJ 5.3 3.1 695 Mun. Cluj-Napoca CLUJ   46.7524682422149 23.5334334285583     RO-SITUR RESTAURANT CLASIC 3 - STELE  
48055 48055 OPUS SUMMER, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 90   banquet 0 0 60 0 0   80 0 7.6 CLJ 1.1 1.1 1222 Mun. Cluj-Napoca CLUJ   46.7730405 23.5884009     RO-SITUR RESTAURANT CLASIC 3  
48130 48130 SKYLINE DINING, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 STELE 85   banquet 0 0 60 0 0   80 10 0.6 CLJ 7.0 3.0 149 Mun. Cluj-Napoca CLUJ   46.7807014027348 23.689108564418     RO-SITUR RESTAURANT CLASIC 3 STELE  
48180 48180 UNIVERS , RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE 310   banquet 0 0 70 0 0   80 10 4.7 CLJ 2.1 2.1 1139 Mun. Cluj-Napoca CLUJ   46.7725017 23.6268804     RO-SITUR RESTAURANT CLASIC 3 - STELE  
48278 48278 CASA DUCA, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 3 star 3 - STELE 195   banquet 0 0 70 0 0   55 0 46.7 CND 16.0 0.6 809 Com. Costineşti CONSTANŢA   43.955113 28.6304675     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 3 - STELE  
48327 48327 SPRINGTIME, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 STELE 300   banquet 0 0 70 0 0   55 0 46.6 CND 16.4 0.9 815 Com. Costineşti CONSTANŢA   43.9569653 28.6380974     RO-SITUR SNACK-BAR 3 STELE  
48341 48341 VOX MARIS 1, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 3 star 3 - STELE 200   banquet 0 0 70 0 0   55 0 48.2 CND 14.7 0.6 820 Com. Costineşti CONSTANŢA   43.9416847 28.6353874     RO-SITUR RESTAURANT-AUTOSERVIRE 3 - STELE  
48342 48342 VOX MARIS 2, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 3 star 3 - STELE 400   banquet 0 0 70 0 0   55 0 48.2 CND 14.7 0.6 820 Com. Costineşti CONSTANŢA   43.9416847 28.6353874     RO-SITUR RESTAURANT-AUTOSERVIRE 3 - STELE  
48346 48346 ALESSIO, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 60   banquet 0 0 50 0 0   80 0 23.5 CND 0.3 0.3 691 Com. Costineşti, Sat Costineşti CONSTANŢA   44.1783874 28.6346376     RO-SITUR RESTAURANT CLASIC 3  
48354 48354 MIAMI, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 80   banquet 0 0 60 0 0   55 0 46.6 CND 16.4 0.9 815 Com. Costineşti, Sat Costineşti CONSTANŢA   43.9569653 28.6380974     RO-SITUR SNACK-BAR 3  
48397 48397 PORTO, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 STELE 50   banquet 0 0 50 0 0   65 10 51.9 Balchik Airfield 2.8 2.8 831 Com. Limanu, Sat 2 Mai CONSTANŢA   43.7907255 28.5794034     RO-SITUR RESTAURANT CLASIC 3 STELE  
48409 48409 BOLO STEAK HOUSE, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE 200   banquet 0 0 70 0 0   65 20 48.6 Balchik Airfield 6.8 5.9 376 Com. Limanu, Sat Vama Veche CONSTANŢA   43.7555447 28.5740228     RO-SITUR RESTAURANT CLASIC 3 - STELE  
48417 48417 ELEKTRA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 66   banquet 0 0 50 0 0   65 20 48.1 Balchik Airfield 7.6 6.8 373 Com. Limanu, Sat Vama Veche CONSTANŢA   43.7476865 28.5764692     RO-SITUR RESTAURANT CLASIC 3  
48458 48458 1896 BRASSERIE & LOUNGE, BRASERIE SAU BISTROU RO eat_drink restaurants restaurant normal 3 star 3 - STELE 66   banquet 0 0 50 0 0   80 0 24.0 CND 1.4 1.4 689 Mun. Constanţa CONSTANŢA   44.1811230554761 28.6518732023773     RO-SITUR BRASERIE SAU BISTROU 3 - STELE  
48511 48511 CARAGIALE, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE 90   banquet 0 0 60 0 0   80 10 20.8 CND 3.5 3.5 885 Mun. Constanţa CONSTANŢA   44.2118364 28.6432018     RO-SITUR RESTAURANT CLASIC 3 - STELE  
48552 48552 ELEGANCE, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 100   banquet 0 0 60 0 0   80 0 24.5 CND 1.5 1.5 642 Mun. Constanţa CONSTANŢA   44.1759147 28.6519359     RO-SITUR SNACK-BAR 3  
48575 48575 IANI EVENTS, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE 180   banquet 0 0 70 0 0   80 10 19.9 CND 3.8 2.8 930 Mun. Constanţa CONSTANŢA   44.2143661 28.6302443     RO-SITUR RESTAURANT CLASIC 3 - STELE  
48586 48586 KAIF SUSHI BAR, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 40   banquet 0 0 50 0 0   80 10 19.5 CND 4.4 2.6 993 Mun. Constanţa CONSTANŢA   44.2202778 28.6316667     RO-SITUR SNACK-BAR 3  
48609 48609 LUPA BY BUENO, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 STELE 55   banquet 0 0 50 0 0   80 0 24.5 CND 1.6 1.6 635 Mun. Constanţa CONSTANŢA   44.1759682 28.6538351     RO-SITUR RESTAURANT CLASIC 3 STELE  
48659 48659 QUEEN VERA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 STELE 160   banquet 0 0 70 0 0   55 0 41.9 GHV 13.4 0.4 206 Mun. Constanţa CONSTANŢA   45.730116 24.983845     RO-SITUR RESTAURANT CLASIC 3 STELE  
48729 48729 ALEXANDRA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 STELE 184   banquet 0 0 70 0 0   80 10 18.5 CND 5.3 2.1 969 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.228553 28.6276968     RO-SITUR RESTAURANT CLASIC 3 STELE  
48732 48732 AMBIENT, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE 152   banquet 0 0 70 0 0   80 10 15.2 CND 6.3 3.9 1832 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.2621293 28.6190239     RO-SITUR RESTAURANT CLASIC 3 - STELE  
48735 48735 AMIRAL, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 3 star 3 200   banquet 0 0 70 0 0   80 10 15.4 CND 6.4 3.8 1783 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.2607202 28.6194491     RO-SITUR RESTAURANT-AUTOSERVIRE 3  
48747 48747 ASYLUM, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 150   banquet 0 0 70 0 0   80 10 14.6 CND 5.3 4.5 2036 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.2715885121401 28.6207283046463     RO-SITUR RESTAURANT CLASIC 3  
48762 48762 BLUE, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 STELE 64   banquet 0 0 50 0 0   80 10 15.2 CND 6.2 4.0 1841 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.2623995 28.6187463     RO-SITUR RESTAURANT CLASIC 3 STELE  
48813 48813 DIPLOMATIC SELF SERVICE, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 3 star 3 - STELE 150   banquet 0 0 70 0 0   80 10 15.2 CND 6.2 4.0 1841 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.2623995 28.6187463     RO-SITUR RESTAURANT-AUTOSERVIRE 3 - STELE  
48821 48821 DORNA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE 103   banquet 0 0 60 0 0   80 10 15.8 CND 7.0 3.2 1471 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.254906 28.618898     RO-SITUR RESTAURANT CLASIC 3 - STELE  
48825 48825 EVENTS BY DON CORLEONE, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE 180   banquet 0 0 70 0 0   80 10 16.2 CND 7.5 2.9 1270 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.2510643 28.6208896     RO-SITUR RESTAURANT CLASIC 3 - STELE  
48830 48830 FIESTA DEL MAR, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 3 star 3 STELE 244   banquet 0 0 70 0 0   80 10 15.2 CND 6.2 4.0 1841 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.2623995 28.6187463     RO-SITUR RESTAURANT-AUTOSERVIRE 3 STELE  
48871 48871 JUPITER, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE 328   banquet 0 0 70 0 0   80 10 15.2 CND 6.2 4.0 1841 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.2623995 28.6187463     RO-SITUR RESTAURANT CLASIC 3 - STELE  
48895 48895 MAJESTIC, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 3 star 3 - STELE 116   banquet 0 0 60 0 0   80 10 16.9 CND 7.3 2.8 1106 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.2463526 28.6258147     RO-SITUR RESTAURANT-AUTOSERVIRE 3 - STELE  
48902 48902 MANAROLA RISTORANTE, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 188   banquet 0 0 70 0 0   80 10 15.2 CND 6.2 4.0 1841 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.2623995 28.6187463     RO-SITUR RESTAURANT CLASIC 3  

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