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

3,787 rows where best_for = "banquet", group = "eat_drink" and rating_value = 2

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)

family 4

country 2

rating_value 1

  • 2 · 3,787 ✖

group 1

  • eat_drink · 3,787 ✖

best_for 1

  • banquet · 3,787 ✖

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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
46704 46704 ANDOLIA, RESTAURANT CU SPECIFIC LOCAL RO eat_drink restaurants restaurant normal 2 star 2 48   banquet 0 0 50 0 0   55 0 32.6 GHV 12.3 1.3 336 Com. Moieciu, Sat Moieciu de Sus BRAŞOV   45.4506092127138 25.3163942456203     RO-SITUR RESTAURANT CU SPECIFIC LOCAL 2  
46981 46981 RA & RA, PIZZERIE RO eat_drink restaurants restaurant normal 2 star 2 - STELE 76   banquet 0 0 50 0 0   65 0 44.9 GHV 1.3 1.3 39 Mun. Făgăraş BRAŞOV   45.8424331 24.9786833     RO-SITUR PIZZERIE 2 - STELE  
46995 46995 MARABOU RESORT, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE 61   banquet 0 0 50 0 0   80 0 15.3 GHV 6.5 1.6 116 Mun. Săcele BRAŞOV   45.5922752 25.6352971     RO-SITUR RESTAURANT CLASIC 2 - STELE  
47084 47084 LA ROTONDE, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE 66   banquet 0 0 50 0 0   70 10 23.4 GHV 11.9 2.3 349 Oraş Predeal BRAŞOV   45.4956992464132 25.5372401699219     RO-SITUR RESTAURANT CLASIC 2 - STELE  
47139 47139 CERBUL CHALET, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE 51   banquet 0 0 50 0 0   80 20 21.1 GHV 8.5 5.3 72 Oraş Râşnov BRAŞOV   45.5167005 25.5030038     RO-SITUR RESTAURANT CLASIC 2 - STELE  
47154 47154 MAGGIE`S SALOON & GRILL, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 STELE 250   banquet 0 0 70 0 0   80 10 20.8 GHV 6.3 2.9 113 Oraş Râşnov BRAŞOV   45.5274631 25.439883     RO-SITUR RESTAURANT CLASIC 2 STELE  
47189 47189 PIATRA CRAIULUI, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 40   banquet 0 0 50 0 0   80 0 20.9 GHV 1.7 1.7 164 Oraş Zărneşti BRAŞOV   45.5721768 25.3326711     RO-SITUR RESTAURANT CLASIC 2  
47205 47205 COB VILLAGE, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 50   banquet 0 0 50 0 0   70 10 25.4 Boboc Air Base 19.9 1.0 14 Com. Berca, Sat Berca BUZĂU   45.2879082 26.6705113     RO-SITUR RESTAURANT CLASIC 2  
47207 47207 2D, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE 160   banquet 0 0 70 0 0   55 20 47.1 Boboc Air Base 25.4 1.5 5 Com. Cislău BUZĂU   45.2394421 26.3782599     RO-SITUR RESTAURANT CLASIC 2 - STELE  
47209 47209 HANUL OVIDIU, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE 180   banquet 0 0 70 0 0   55 20 43.6 Boboc Air Base 18.8 0.3 1 Com. Glodeanu Sărat, Sat Căldăruşeanca BUZĂU   44.8809172 26.6909244     RO-SITUR RESTAURANT CLASIC 2 - STELE  
47214 47214 LA PĂDURE, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 60   banquet 0 0 50 0 0   55 0 33.8 Boboc Air Base 25.7 1.4 24 Com. Măgura, Sat Măgura BUZĂU   45.2712111 26.5540288     RO-SITUR RESTAURANT CLASIC 2  
47238 47238 RIGOLETTO, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 66   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.6409275711639     RO-SITUR RESTAURANT CLASIC 2  
47252 47252 FERMA RUȘILOR, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 114   banquet 0 0 60 0 0   70 10 22.1 Boboc Air Base 14.6 1.9 10 Com. Verneşti, Sat Cândeşti BUZĂU   45.2400954 26.6983121     RO-SITUR RESTAURANT CLASIC 2  
47254 47254 AQUA MAX, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE 200   banquet 0 0 70 0 0   80 10 13.7 Boboc Air Base 2.4 2.2 138 Mun. Buzău BUZĂU   45.16834 26.8181294     RO-SITUR RESTAURANT CLASIC 2 - STELE  
47260 47260 BUCEGI, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 100   banquet 0 0 60 0 0   80 0 14.4 Boboc Air Base 0.9 0.9 138 Mun. Buzău BUZĂU   45.1437815 26.8259002     RO-SITUR RESTAURANT CLASIC 2  
47274 47274 ILEANA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE 75   banquet 0 0 50 0 0   80 0 13.8 Boboc Air Base 1.9 1.9 132 Mun. Buzău BUZĂU   45.1353351 26.8451557     RO-SITUR RESTAURANT CLASIC 2 - STELE  
47367 47367 CHEILE NEREI, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 2 star 2 - STELE 90   banquet 0 0 60 0 0   45 10 71.7 CSB 41.0 0.5 19 Com. Sasca Montană CARAŞ-SEVERIN   44.8957078 21.7208488     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 2 - STELE  
47488 47488 CLIM, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 40   banquet 0 0 50 0 0   55 10 48.0 CSB 23.3 1.5 9 Oraş Anina CARAŞ-SEVERIN   45.0925773 21.8537025     RO-SITUR SNACK-BAR 2  
47501 47501 CENTRAL, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 42   banquet 0 0 50 0 0   45 0 60.8 CSB 34.1 1.2 215 Oraş Băile Herculane CARAŞ-SEVERIN   44.8870188 22.4243459     RO-SITUR RESTAURANT CLASIC 2  
47503 47503 CERNA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE 40   banquet 0 0 50 0 45   45 0 60.8 CSB 34.1 1.2 215 Oraş Băile Herculane CARAŞ-SEVERIN   44.8867276 22.4240877     RO-SITUR BAR DE ZI 2 - STELE  
47551 47551 TATA ȘI FIUL 2, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 STELE 50   banquet 0 0 50 0 0   45 0 60.7 CSB 34.2 1.3 215 Oraş Băile Herculane CARAŞ-SEVERIN   44.8879478 22.4236601     RO-SITUR RESTAURANT CLASIC 2 STELE  
47552 47552 TATA ȘI FIUL 3, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 STELE 100   banquet 0 0 60 0 0   45 0 61.5 CSB 33.9 0.1 217 Oraş Băile Herculane CARAŞ-SEVERIN   44.8790901 22.4126627     RO-SITUR RESTAURANT CLASIC 2 STELE  
47588 47588 CAPUS, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 70   banquet 0 0 50 0 0   55 10 30.4 CLJ 24.0 1.4 10 Com. Căpuşu Mare, Sat Căpuşu Mare CLUJ   46.792374 23.2864917     RO-SITUR RESTAURANT CLASIC 2  
47674 47674 KRUSTA, BRASERIE SAU BISTROU RO eat_drink restaurants restaurant normal 2 star 2 Stele 40   banquet 0 0 50 0 0   45 0 43.8 CLJ 37.0 1.4 23 Com. Râşca, Sat Râşca CLUJ   46.7299645 23.1170209     RO-SITUR BRASERIE SAU BISTROU 2 Stele  
47783 47783 BURGER KING SIGMA SHOPPING CENTER, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 64   banquet 0 0 50 0 0   80 0 7.7 CLJ 1.2 1.2 1222 Mun. Cluj-Napoca CLUJ   46.7561626 23.5944239     RO-SITUR SNACK-BAR 2  
48084 48084 POPEYES SIGMA SHOPPING CENTER, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 63   banquet 0 0 50 0 0   80 0 7.7 CLJ 1.2 1.2 1222 Mun. Cluj-Napoca CLUJ   46.7561626 23.5944239     RO-SITUR SNACK-BAR 2  
48196 48196 VISUIN, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 60   banquet 0 0 50 0 0   80 0 7.6 CLJ 0.8 0.8 1225 Mun. Cluj-Napoca CLUJ   46.767712814475 23.5899020539673     RO-SITUR RESTAURANT CLASIC 2  
48210 48210 ZOFA, BRASERIE SAU BISTROU RO eat_drink restaurants restaurant normal 2 star 2 40   banquet 0 0 50 0 0   80 0 6.8 CLJ 0.5 0.5 1225 Mun. Cluj-Napoca CLUJ   46.7714817 23.599547     RO-SITUR BRASERIE SAU BISTROU 2  
48348 48348 CHARM, TERASĂ RO eat_drink bars_pubs bar_pub normal 2 star 2 STELE 150   banquet 0 0 70 0 65   55 0 46.5 CND 16.8 1.3 825 Com. Costineşti, Sat Costineşti CONSTANŢA   43.9590015 28.6435257     RO-SITUR TERASĂ 2 STELE  
48353 48353 KM 0, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - Stele 50   banquet 0 0 50 0 0   55 0 41.9 GHV 13.4 0.4 206 Com. Costineşti, Sat Costineşti CONSTANŢA   45.730116 24.983845     RO-SITUR RESTAURANT CLASIC 2 - Stele  
48359 48359 SUN UP PLACE, BUFET TIP EXPRES RO eat_drink fastfood_catering fast_food normal 2 star 2 STELE 90   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 BUFET TIP EXPRES 2 STELE  
48390 48390 BLEK SEA, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 54   banquet 0 0 50 0 0   65 10 51.7 Balchik Airfield 3.0 3.0 834 Com. Limanu, Sat 2 Mai CONSTANŢA   43.7894709 28.5771465     RO-SITUR SNACK-BAR 2  
48391 48391 CASA MARGO, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE 96   banquet 0 0 60 0 0   65 10 51.1 Balchik Airfield 3.7 3.7 766 Com. Limanu, Sat 2 Mai CONSTANŢA   43.7829692 28.5778418     RO-SITUR RESTAURANT CLASIC 2 - STELE  
48399 48399 LIMANU, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 68   banquet 0 0 50 0 0   65 0 53.1 Balchik Airfield 1.4 1.4 731 Com. Limanu, Sat Limanu CONSTANŢA   43.8152282 28.5590089     RO-SITUR RESTAURANT CLASIC 2  
48407 48407 BIBI BISTRO, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE 60   banquet 0 0 50 0 0   65 20 48.4 Balchik Airfield 7.0 6.1 376 Com. Limanu, Sat Vama Veche CONSTANŢA   43.7534625 28.5737181     RO-SITUR RESTAURANT CLASIC 2 - STELE  
48408 48408 BIZANTIN, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE 40   banquet 0 0 50 0 0   65 20 48.3 Balchik Airfield 7.2 6.3 375 Com. Limanu, Sat Vama Veche CONSTANŢA   43.7517435 28.5754475     RO-SITUR RESTAURANT CLASIC 2 - STELE  
48437 48437 POFTĂ SAU FOAME , RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 STELE 110   banquet 0 0 60 0 0   65 20 48.3 Balchik Airfield 7.2 6.4 375 Com. Limanu, Sat Vama Veche CONSTANŢA   43.7511887 28.5758528     RO-SITUR RESTAURANT CLASIC 2 STELE  
48440 48440 SANDALANDIA, GRĂDINA DE VARĂ RO eat_drink restaurants restaurant normal 2 star 2 100   banquet 0 0 60 0 0   65 20 48.1 Balchik Airfield 7.5 6.6 375 Com. Limanu, Sat Vama Veche CONSTANŢA   43.7490534 28.5757669     RO-SITUR GRĂDINA DE VARĂ 2  
48444 48444 STUF VAMA VECHE LA LYANA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 STELE 100   banquet 0 0 60 0 0   65 20 48.5 Balchik Airfield 6.9 6.0 376 Com. Limanu, Sat Vama Veche CONSTANŢA   43.7544346 28.5739605     RO-SITUR RESTAURANT CLASIC 2 STELE  
48451 48451 KARTALI, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE 140   banquet 0 0 60 0 0   80 0 9.9 CND 4.1 0.9 866 Com. Lumina, Sat Lumina CONSTANŢA   44.2913392 28.5627791     RO-SITUR RESTAURANT CLASIC 2 - STELE  
48457 48457 173 ACASĂ, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 2 star 2 50   banquet 0 0 50 0 0   80 10 22.8 CND 4.3 4.3 160 Mun. Constanţa CONSTANŢA   44.1688636 28.5828509     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 2  
48548 48548 DOBROGEA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 180   banquet 0 0 70 0 0   80 10 19.8 CND 3.9 2.7 930 Mun. Constanţa CONSTANŢA   44.2155601 28.6292305     RO-SITUR RESTAURANT CLASIC 2  
48570 48570 GREEN HOUSE, TERASĂ RO eat_drink bars_pubs bar_pub normal 2 star 2 stele 96   banquet 0 0 60 0 55   80 10 19.9 CND 3.8 2.8 931 Mun. Constanţa CONSTANŢA   44.2149798 28.6303916     RO-SITUR TERASĂ 2 stele  
48577 48577 IMAGO, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE 90   banquet 0 0 60 0 0   80 10 16.1 CND 7.3 3.0 1345 Mun. Constanţa CONSTANŢA   44.2523581 28.6205559     RO-SITUR RESTAURANT CLASIC 2 - STELE  
48589 48589 KUYDO CAFE, CAFE-BAR SAU CAFENEA RO eat_drink cafes cafe normal 2 star 2 - STELE 50   banquet 0 0 50 0 0   80 10 15.2 CND 6.2 4.0 1841 Mun. Constanţa CONSTANŢA   44.2623995 28.6187463     RO-SITUR CAFE-BAR SAU CAFENEA 2 - STELE  
48634 48634 MIRAGE FOOD CORNER, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 STELE 160   banquet 0 0 70 0 0   80 10 19.7 CND 4.1 2.7 916 Mun. Constanţa CONSTANŢA   44.2175179337809 28.6310904023331     RO-SITUR RESTAURANT CLASIC 2 STELE  
48675 48675 ROYAL BY EUXIN, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE 70   banquet 0 0 50 0 0   80 10 15.2 CND 6.2 4.0 1841 Mun. Constanţa CONSTANŢA   44.2623995 28.6187463     RO-SITUR RESTAURANT CLASIC 2 - STELE  
48717 48717 VATRA CASEI, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE 40   banquet 0 0 50 0 0   80 10 20.9 CND 3.4 3.4 878 Mun. Constanţa CONSTANŢA   44.2110221 28.6435515     RO-SITUR RESTAURANT CLASIC 2 - STELE  
48850 48850 GROOM, CAFE-BAR SAU CAFENEA RO eat_drink cafes cafe normal 2 star 2 - STELE 100   banquet 0 0 60 0 0   80 10 19.6 CND 4.3 2.8 1002 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.2192194 28.6329966     RO-SITUR CAFE-BAR SAU CAFENEA 2 - STELE  
48866 48866 ISTANBUL KEBAP, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 50   banquet 0 0 50 0 0   80 10 19.5 CND 4.5 2.7 992 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.2209364330219 28.6334501698196     RO-SITUR SNACK-BAR 2  
48928 48928 NIMAZI BY NIKKI EVENTS, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 175   banquet 0 0 70 0 0   80 10 12.7 CND 2.8 2.0 2134 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.2944071 28.6167424     RO-SITUR RESTAURANT CLASIC 2  
48936 48936 OB.A. RESTO LOUNGE, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 stele 50   banquet 0 0 50 0 0   80 0 18.0 CND 5.8 1.9 1028 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.232790552311 28.6242525091065     RO-SITUR RESTAURANT CLASIC 2 stele  
48943 48943 OVIDIU, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE 270   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 2 - STELE  
49045 49045 THE LOBBY, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE 40   banquet 0 0 50 0 45   80 10 15.2 CND 6.2 4.0 1841 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.2623995 28.6187463     RO-SITUR BAR DE ZI 2 - STELE  
49058 49058 VATRA ROMÂNEASCĂ, TERASĂ RO eat_drink bars_pubs bar_pub normal 2 star 2 STELE 88   banquet 0 0 60 0 55   80 10 15.2 CND 6.2 4.0 1841 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.2623995 28.6187463     RO-SITUR TERASĂ 2 STELE  
49068 49068 ENJOY PIZZA, TERASĂ RO eat_drink bars_pubs bar_pub normal 2 star 2 STELE 180   banquet 0 0 70 0 65   80 10 19.6 CND 4.2 2.7 908 Mun. Constanţa, Sat Vacanță - Zona Luna Park - Lot 4 CONSTANŢA   44.2182610611448 28.631403589991     RO-SITUR TERASĂ 2 STELE  
49072 49072 ȚAIS GASTROBAR, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - Stele 45   banquet 0 0 50 0 0   65 0 53.7 Balchik Airfield 1.1 1.1 744 Mun. Mangalia CONSTANŢA   43.808689915724 28.584776512117     RO-SITUR SNACK-BAR 2 - Stele  
49077 49077 ALUTUS, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE 50   banquet 0 0 50 0 0   65 0 54.3 Balchik Airfield 0.5 0.5 828 Mun. Mangalia CONSTANŢA   43.8161291 28.5827615     RO-SITUR RESTAURANT CLASIC 2 - STELE  
49092 49092 BREEZE, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE 56   banquet 0 0 50 0 0   65 0 53.9 Balchik Airfield 1.0 1.0 755 Mun. Mangalia CONSTANŢA   43.8100609 28.5858812     RO-SITUR RESTAURANT CLASIC 2 - STELE  
49119 49119 FABRICA DE CLĂTITE, PATISERIE RO eat_drink cafes cafe normal 2 star 2 40   banquet 0 0 50 0 0   65 0 57.1 CND 5.0 1.8 823 Mun. Mangalia CONSTANŢA   43.8556125 28.6059087     RO-SITUR PATISERIE 2  
49137 49137 LA CĂPITANU, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 2 star 2 - STELE 200   banquet 0 0 70 0 0   65 0 54.4 Balchik Airfield 0.9 0.9 825 Mun. Mangalia CONSTANŢA   43.815448 28.5873151     RO-SITUR RESTAURANT-AUTOSERVIRE 2 - STELE  
49144 49144 LA PLAGE, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 2 star 2 - STELE 40   banquet 0 0 50 0 0   65 10 51.9 Balchik Airfield 2.8 2.8 830 Mun. Mangalia CONSTANŢA   43.7911335 28.5792845     RO-SITUR RESTAURANT-AUTOSERVIRE 2 - STELE  
49154 49154 LEBADA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE 64   banquet 0 0 50 0 0   65 0 54.5 Balchik Airfield 0.8 0.8 840 Mun. Mangalia CONSTANŢA   43.8162118 28.5868896     RO-SITUR RESTAURANT CLASIC 2 - STELE  
49156 49156 MAMA LEONE, BRASERIE SAU BISTROU RO eat_drink restaurants restaurant normal 2 star 2 STELE 40   banquet 0 0 50 0 0   65 0 53.5 Balchik Airfield 1.0 1.0 737 Mun. Mangalia CONSTANŢA   43.8078305 28.5810295     RO-SITUR BRASERIE SAU BISTROU 2 STELE  
49168 49168 MILANO, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 50   banquet 0 0 50 0 0   65 0 54.3 Balchik Airfield 0.4 0.4 836 Mun. Mangalia CONSTANŢA   43.8167237 28.5818864     RO-SITUR RESTAURANT CLASIC 2  
49197 49197 SAILOR, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE 40   banquet 0 0 50 0 0   65 0 53.3 Balchik Airfield 0.9 0.9 705 Mun. Mangalia CONSTANŢA   43.8077646 28.5773175     RO-SITUR RESTAURANT CLASIC 2 - STELE  
49223 49223 WHITE SHARK, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 50   banquet 0 0 50 0 0   65 10 57.7 CND 4.3 2.4 987 Mun. Mangalia, Loc. Cap Aurora CONSTANŢA   43.8497026 28.6042665     RO-SITUR SNACK-BAR 2  
49244 49244 EL MEXICO JUPITER, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 STELE 120   banquet 0 0 60 0 0   65 0 56.9 CND 5.0 1.5 811 Mun. Mangalia, Loc. Jupiter CONSTANŢA   43.857437 28.603049     RO-SITUR RESTAURANT CLASIC 2 STELE  
49267 49267 RIO, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 2 star 2 - STELE 70   banquet 0 0 50 0 0   65 10 57.4 CND 4.8 2.0 935 Mun. Mangalia, Loc. Jupiter CONSTANŢA   43.8533236 28.6060325     RO-SITUR RESTAURANT-AUTOSERVIRE 2 - STELE  
49320 49320 Farul Genovez, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 95   banquet 0 0 60 0 0   65 0 55.8 CND 6.1 0.5 713 Mun. Mangalia, Loc. Neptun CONSTANŢA   43.8672248 28.6053952     RO-SITUR RESTAURANT CLASIC 2  
49321 49321 GOLD FISH, TERASĂ RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE 180   banquet 0 0 70 0 65   65 0 55.8 CND 5.7 0.8 734 Mun. Mangalia, Loc. Neptun CONSTANŢA   43.8658355 28.5946602     RO-SITUR TERASĂ 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");