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

92 rows where best_for = "banquet", country = "RO" and family = "fastfood_catering"

This data as json, CSV (advanced)

Suggested facets: venue_type, rating_label, fit_banquet, reachability_score, isolation_score, nearest_airport, municipality, source_type, source_category

rating_value 4

  • 2 43
  • 3 34
  • 1 13
  • 4 2

group 1

family 1

  • fastfood_catering · 92 ✖

country 1

best_for 1

  • banquet · 92 ✖

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
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  
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  
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  
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  
47148 47148 DIHAM PHOENIX, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 1 star 1 60   banquet 0 0 50 0 0   80 0 15.5 GHV 1.0 1.0 153 Oraş Râşnov BRAŞOV   45.5746274 25.4540278     RO-SITUR SNACK-BAR 1  
47341 47341 TREI APE, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 1 star 1 - STELE 65   banquet 0 0 50 0 0   70 10 24.5 CSB 22.1 2.3 31 Com. Brebu Nou CARAŞ-SEVERIN   45.2135081 22.1429926     RO-SITUR BUFET-BAR 1 - 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  
47516 47516 FLORA, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 1 star 1 - STELE 60   banquet 0 0 50 0 0   45 0 61.2 CSB 34.1 0.2 217 Oraş Băile Herculane CARAŞ-SEVERIN   44.8813974630465 22.4129256619019     RO-SITUR BUFET-BAR 1 - 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  
48262 48262 BIRTUL SATULUI, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 1 star 1 95   banquet 0 0 60 0 0   70 10 14.6 CND 11.4 3.0 48 Com. Corbu, Sat Corbu CONSTANŢA   44.4096897 28.6592871     RO-SITUR SNACK-BAR 1  
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  
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  
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  
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  
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  
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  
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  
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  
48842 48842 GOLDEN PALACE, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 10 18.8 CND 5.2 2.3 935 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.22695 28.6302168     RO-SITUR RESTAURANT-AUTOSERVIRE 4 - 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  
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  
48972 48972 POFTĂ SAU FOAME, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 1 star 1 STEA 160   banquet 0 0 70 0 0   80 10 15.5 CND 6.6 3.6 1716 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.2591124 28.6189467     RO-SITUR RESTAURANT-AUTOSERVIRE 1 STEA  
49060 49060 VENUS, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 3 star 3 - STELE 50   banquet 0 0 50 0 0   80 10 16.9 CND 7.2 2.4 1073 Mun. Constanţa, Loc. Mamaia CONSTANŢA   44.244451 28.621965     RO-SITUR RESTAURANT-AUTOSERVIRE 3 - 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  
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  
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  
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  
49308 49308 CUPIDON, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 3 star 3 - STELE 400   banquet 0 0 70 0 0   65 0 55.1 CND 6.5 0.3 667 Mun. Mangalia, Loc. Neptun CONSTANŢA   43.8727432 28.5981701     RO-SITUR RESTAURANT-AUTOSERVIRE 3 - STELE  
49319 49319 EGRETA, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 3 star 3 - STELE 75   banquet 0 0 50 0 0   65 0 57.2 CND 4.9 1.9 826 Mun. Mangalia, Loc. Neptun CONSTANŢA   43.8549544 28.6065446     RO-SITUR RESTAURANT-AUTOSERVIRE 3 - STELE  
49360 49360 RECIF, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 3 star 3 - STELE 50   banquet 0 0 50 0 0   65 0 56.1 CND 5.5 1.0 752 Mun. Mangalia, Loc. Neptun CONSTANŢA   43.8637082187204 28.5957828342545     RO-SITUR RESTAURANT-AUTOSERVIRE 3 - STELE  
49409 49409 HOLIDAY BLUE, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 3 star 3 STELE 200   banquet 0 0 70 0 0   65 0 54.4 CND 7.4 1.0 624 Mun. Mangalia, Loc. Olimp CONSTANŢA   43.8802343291688 28.6039007492126     RO-SITUR RESTAURANT-AUTOSERVIRE 3 STELE  
49418 49418 OLTENIA-STEAUA DE MARE, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 3 star 3 - STELE 380   banquet 0 0 70 0 0   65 0 53.8 CND 8.2 1.8 620 Mun. Mangalia, Loc. Olimp CONSTANŢA   43.8865997 28.6090768     RO-SITUR RESTAURANT-AUTOSERVIRE 3 - STELE  
49423 49423 PHOENICIA BLUE VIEW - CRAIOVA, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 3 star 3 STELE 300   banquet 0 0 70 0 0   65 0 54.4 CND 7.4 0.9 624 Mun. Mangalia, Loc. Olimp CONSTANŢA   43.879601 28.6030636     RO-SITUR RESTAURANT-AUTOSERVIRE 3 STELE  
49460 49460 LIDO, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 2 star 2 STELE 170   banquet 0 0 70 0 0   65 0 55.7 Balchik Airfield 1.7 1.7 959 Mun. Mangalia, Loc. Saturn CONSTANŢA   43.8291043 28.5878995     RO-SITUR RESTAURANT-AUTOSERVIRE 2 STELE  
49464 49464 NEKO, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 2 star 2 - STELE 150   banquet 0 0 70 0 0   65 0 53.8 Balchik Airfield 0.2 0.2 776 Mun. Mangalia, Loc. Saturn CONSTANŢA   43.8152436 28.5741496     RO-SITUR RESTAURANT-AUTOSERVIRE 2 - STELE  
49547 49547 SUNRISE, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 STELE 40   banquet 0 0 50 0 0   65 10 57.2 Balchik Airfield 3.3 3.2 983 Mun. Mangalia, Loc. Venus CONSTANŢA   43.843075 28.5935659     RO-SITUR SNACK-BAR 2 STELE  
49599 49599 BELONA, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 3 star 3 - STELE 50   banquet 0 0 50 0 0   55 0 35.2 CND 12.9 0.6 1135 Oraş Eforie, Loc. Eforie Nord CONSTANŢA   44.065116 28.6390954     RO-SITUR RESTAURANT-AUTOSERVIRE 3 - STELE  
49600 49600 BELSOL, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 3 star 3 - STELE 100   banquet 0 0 60 0 0   55 0 35.3 CND 13.3 0.5 1155 Oraş Eforie, Loc. Eforie Nord CONSTANŢA   44.0612904 28.6309762     RO-SITUR RESTAURANT-AUTOSERVIRE 3 - STELE  
49608 49608 BERLIN, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 3 star 3 - STELE 200   banquet 0 0 70 0 0   55 0 35.1 CND 12.9 0.2 1133 Oraş Eforie, Loc. Eforie Nord CONSTANŢA   44.0646457 28.6339633     RO-SITUR RESTAURANT-AUTOSERVIRE 3 - STELE  
49616 49616 CASA ALEXANDRA, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 2 star 2 STELE 40   banquet 0 0 50 0 0   55 0 35.9 CND 13.6 1.0 1155 Oraş Eforie, Loc. Eforie Nord CONSTANŢA   44.0582018 28.6401577     RO-SITUR RESTAURANT-AUTOSERVIRE 2 STELE  
49624 49624 CLUB DUNĂREA, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 3 star 3 - STELE 285   banquet 0 0 70 0 0   55 0 35.6 CND 13.6 0.8 1158 Oraş Eforie, Loc. Eforie Nord CONSTANŢA   44.0584809 28.6290941     RO-SITUR RESTAURANT-AUTOSERVIRE 3 - STELE  
49635 49635 DALIA, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 2 star 2 - STELE 90   banquet 0 0 60 0 0   55 0 34.0 CND 12.0 0.9 984 Oraş Eforie, Loc. Eforie Nord CONSTANŢA   44.0731345 28.6289395     RO-SITUR RESTAURANT-AUTOSERVIRE 2 - STELE  
49652 49652 EVER GREEN, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 2 star 2 88   banquet 0 0 60 0 0   55 0 34.8 CND 12.5 0.6 1106 Oraş Eforie, Loc. Eforie Nord CONSTANŢA   44.0682645 28.638684     RO-SITUR RESTAURANT-AUTOSERVIRE 2  
49654 49654 GAROFITA, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 2 star 2 - STELE 200   banquet 0 0 70 0 0   55 0 34.7 CND 12.4 0.6 1094 Oraş Eforie, Loc. Eforie Nord CONSTANŢA   44.0692665 28.6379281     RO-SITUR RESTAURANT-AUTOSERVIRE 2 - STELE  
49674 49674 MARIA, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 3 star 3 - STELE 75   banquet 0 0 50 0 0   55 0 39.6 CND 17.2 0.6 793 Oraş Eforie, Loc. Eforie Nord CONSTANŢA   44.0269947 28.6551089     RO-SITUR RESTAURANT-AUTOSERVIRE 3 - STELE  
49684 49684 NADIA, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 2 star 2 - STELE 100   banquet 0 0 60 0 0   55 0 35.3 CND 13.3 0.5 1155 Oraş Eforie, Loc. Eforie Nord CONSTANŢA   44.0612904 28.6309762     RO-SITUR RESTAURANT-AUTOSERVIRE 2 - STELE  
49713 49713 SAIGON, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 50   banquet 0 0 50 0 0   55 0 36.0 CND 13.7 1.1 1153 Oraş Eforie, Loc. Eforie Nord CONSTANŢA   44.0571853 28.6409853     RO-SITUR SNACK-BAR 2  
49720 49720 SOLERO, BUFET TIP EXPRES RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE 60   banquet 0 0 50 0 0   55 0 35.9 CND 13.6 1.0 1156 Oraş Eforie, Loc. Eforie Nord CONSTANŢA   44.0585859 28.6399329     RO-SITUR BUFET TIP EXPRES 3 - STELE  
49743 49743 ALMARIS, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 2 star 2 - STELE 200   banquet 0 0 70 0 0   55 0 38.3 CND 16.0 0.3 1169 Oraş Eforie, Loc. Eforie Sud CONSTANŢA   44.037293 28.6495862     RO-SITUR RESTAURANT-AUTOSERVIRE 2 - STELE  
49788 49788 MOJO, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 3 star 3 STELE 244   banquet 0 0 70 0 0   55 0 39.5 CND 17.3 0.3 825 Oraş Eforie, Loc. Eforie Sud CONSTANŢA   44.025341 28.647148     RO-SITUR RESTAURANT-AUTOSERVIRE 3 STELE  
49804 49804 SIXTY NINE, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 1 star 1 STEA 40   banquet 0 0 50 0 0   55 0 39.3 CND 17.0 0.6 973 Oraş Eforie, Loc. Eforie Sud CONSTANŢA   44.027949 28.6465692     RO-SITUR BUFET-BAR 1 STEA  
49849 49849 D10, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 2 star 2 - STELE 50   banquet 0 0 50 0 0   80 0 12.7 CND 2.5 0.7 2496 Oraş Năvodari CONSTANŢA   44.3057581 28.6267915     RO-SITUR RESTAURANT-AUTOSERVIRE 2 - STELE  
49861 49861 FOARTE BUN, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 2 star 2 95   banquet 0 0 60 0 0   80 0 12.0 CND 2.0 0.7 2242 Oraş Năvodari CONSTANŢA   44.3174921 28.6253561     RO-SITUR RESTAURANT-AUTOSERVIRE 2  
49866 49866 HAIDUCILOR, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 1 star 1 STEA 100   banquet 0 0 60 0 0   80 0 12.6 CND 2.6 0.8 2251 Oraş Năvodari CONSTANŢA   44.315813 28.6329243     RO-SITUR SNACK-BAR 1 STEA  
49878 49878 JENI, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 2 star 2 95   banquet 0 0 60 0 0   80 0 12.5 CND 2.4 0.4 2271 Oraş Năvodari CONSTANŢA   44.3123597136035 28.6298428356125     RO-SITUR RESTAURANT-AUTOSERVIRE 2  
49914 49914 MICUL DE AUR, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 70   banquet 0 0 50 0 0   80 0 12.7 CND 2.5 1.0 2531 Oraş Năvodari CONSTANŢA   44.3026188 28.6248818     RO-SITUR SNACK-BAR 2  
49926 49926 NO 105, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 2 star 2 60   banquet 0 0 50 0 0   80 10 12.7 CND 4.5 3.7 1558 Oraş Năvodari CONSTANŢA   44.341087 28.6456565     RO-SITUR RESTAURANT-AUTOSERVIRE 2  
49946 49946 POSEIDON, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 1 star 1 - STEA 78   banquet 0 0 50 0 0   80 0 12.0 CND 2.0 0.7 2242 Oraş Năvodari CONSTANŢA   44.3174921 28.6253561     RO-SITUR SNACK-BAR 1 - STEA  
50002 50002 DIVINO, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 100   banquet 0 0 60 0 0   80 10 19.5 CND 4.3 2.6 997 Stațiunea Mamaia CONSTANŢA   44.2196858 28.6306451     RO-SITUR SNACK-BAR 2  
50082 50082 PANORAMIC, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 4 star 4 - STELE     banquet 0 0 50 0 0   55 0 53.2 GHV 17.3 0.5 73 Oraş Covasna COVASNA   45.8472767 26.1783452     RO-SITUR BUFET-BAR 4 - STELE  
50235 50235 POPAS BAȘCOV, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 1 star 1 40   banquet 0 0 50 0 0   50 0 84.5 CRA 0.7 0.7 147 Mun. Calafat DOLJ   43.996568 22.929131     RO-SITUR SNACK-BAR 1  
50552 50552 FÜRÉSZ, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 50   banquet 0 0 50 0 0   55 0 72.7 GHV 17.6 0.9 44 Com. Căpâlniţa, Sat Căpâlniţa HARGHITA   46.3589021867986 25.5123125436554     RO-SITUR SNACK-BAR 3  
50553 50553 VITUS, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 1 star 1 40   banquet 0 0 50 0 0   55 0 72.5 GHV 19.4 1.7 40 Com. Căpâlniţa, Sat Căpâlniţa HARGHITA   46.3578198 25.5387382     RO-SITUR BUFET-BAR 1  
50640 50640 OXYGEN RESTRO , RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 3 star 3 STELE 150   banquet 0 0 70 0 0   50 0 94.0 TGM 1.2 1.2 60 Mun. Gheorgheni HARGHITA   46.7212112 25.5855274     RO-SITUR RESTAURANT-AUTOSERVIRE 3 STELE  
50700 50700 TRANZIT, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 50   banquet 0 0 50 0 0   65 0 69.2 GHV 1.0 1.0 69 Mun. Odorheiu Secuiesc HARGHITA   46.3076485551478 25.2943481656067     RO-SITUR SNACK-BAR 2  
50899 50899 A1 ORĂȘTIE DREAPTA, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 2 star 2 52   banquet 0 0 50 0 0   65 0 68.9 SBZ 1.3 1.3 34 Mun. Orăştie HUNEDOARA   45.8451246 23.2019265     RO-SITUR RESTAURANT-AUTOSERVIRE 2  
51162 51162 ELITTE INN & SUITES , BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 STELE 60   banquet 0 0 50 0 0   80 0 11.3 BBU 2.3 1.6 208 Com. Chiajna, Sat Roşu ILFOV   44.4420382 25.9886011     RO-SITUR BUFET-BAR 2 STELE  
51236 51236 ALEX, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 STELE 50   banquet 0 0 50 0 0   70 10 20.8 BAY 16.1 0.3 20 Com. Copalnic-Mănăştur, Sat Copalnic MARAMUREŞ   47.5199100417886 23.6517451615799     RO-SITUR SNACK-BAR 3 STELE  
51292 51292 LOREDANA, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 76   banquet 0 0 50 0 0   70 10 14.3 BAY 13.6 1.5 9 Com. Remetea Chioarului, Sat Remetea Chioarului MARAMUREŞ   47.537846 23.5309968     RO-SITUR SNACK-BAR 2  
51374 51374 ARDEALUL, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE 88   banquet 0 0 60 0 0   65 0 44.6 BAY 0.9 0.9 83 Mun. Sighetu Marmaţiei MARAMUREŞ   47.9345055 23.8979786     RO-SITUR SNACK-BAR 2 - STELE  
51899 51899 OSPĂTĂRIA DE SUS, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 STELE 50   banquet 0 0 50 0 0   80 10 7.2 BBU 3.4 3.4 1917 Mun. Bucureşti, Sector 6 MUNICIPIUL BUCUREŞTI   44.4438879 26.0660572     RO-SITUR BUFET-BAR 3 STELE  
52115 52115 ÎNTRE LACURI, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 50   banquet 0 0 50 0 0   45 10 53.3 TGM 34.6 2.2 266 Oraş Sovata MUREŞ   46.5996705 25.082546     RO-SITUR SNACK-BAR 3  
52138 52138 PARC, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 STELE 50   banquet 0 0 50 0 0   45 10 53.9 TGM 34.6 2.9 266 Oraş Sovata MUREŞ   46.6044638 25.0886811     RO-SITUR BUFET-BAR 2 STELE  
52679 52679 KFC SINAIA RDT, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 STELE 54   banquet 0 0 50 0 0   55 0 37.8 GHV 22.4 1.8 735 Oraş Sinaia PRAHOVA   45.3663487 25.5454743     RO-SITUR SNACK-BAR 3 STELE  
52787 52787 MESOPOTAMIA, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 78   banquet 0 0 50 0 0   55 0 37.8 GHV 22.4 1.8 735 SINAIA PRAHOVA   45.3663487 25.5454743     RO-SITUR SNACK-BAR 2  
52911 52911 ȚARA OAȘULUI, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 227   banquet 0 0 70 0 0   70 40 18.5 BAY 19.1 5.7 5 Oraş Negreşti-Oaş SATU MARE   47.8229731 23.5032722     RO-SITUR SNACK-BAR 2  
52956 52956 FLORA, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE 44   banquet 0 0 50 0 0   45 10 40.1 SBZ 33.6 4.8 23 Com. Cârţişoara, Sat Cârţişoara SIBIU   45.6733731 24.5776101     RO-SITUR BUFET-BAR 2 - STELE  
52958 52958 A1 CRISTIAN DREAPTA, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 2 star 2 120   banquet 0 0 60 0 0   70 10 6.0 SBZ 11.0 2.0 34 Com. Cristian, Sat Cristian SIBIU   45.7897753164522 24.0088569194214     RO-SITUR RESTAURANT-AUTOSERVIRE 2  
52959 52959 A1 CRISTIAN STÂNGA, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 52   banquet 0 0 50 0 0   70 0 5.8 SBZ 10.8 1.7 33 Com. Cristian, Sat Cristian SIBIU   45.7881243 24.0120713     RO-SITUR SNACK-BAR 2  
53044 53044 D 36 RESIDENCE, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 64   banquet 0 0 50 0 0   80 10 4.7 SBZ 2.1 2.1 710 Mun. Sibiu SIBIU   45.781265 24.1464778     RO-SITUR SNACK-BAR 3  
53127 53127 AGORA GRÂU, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 40   banquet 0 0 50 0 0   80 10 9.2 SBZ 3.3 3.3 74 Oraş Cisnădie, Loc. Cisnădioara SIBIU   45.7048802 24.1115493     RO-SITUR SNACK-BAR 2  
53155 53155 ANNE MARY, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 1 star 1 - STELE 46   banquet 0 0 50 0 0   55 20 32.8 SCV 13.4 1.1 4 Com. Arbore SUCEAVA   47.7297768 25.9199355     RO-SITUR BUFET-BAR 1 - STELE  
53532 53532 LA ROȘU, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 1 star 1 46   banquet 0 0 50 0 0   70 20 27.5 CSB 14.3 0.3 2 Com. Criciova, Sat Criciova TIMIŞ   45.6306769 22.0671431     RO-SITUR SNACK-BAR 1  
53588 53588 AMAZONIA, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 3 star 3 - STELE 44   banquet 0 0 50 0 0   80 10 7.9 TSR 2.8 2.8 555 Mun. Timişoara TIMIŞ   45.770369 21.2528727     RO-SITUR RESTAURANT-AUTOSERVIRE 3 - STELE  
53611 53611 CASA DE LA ROSA, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE 60   banquet 0 0 50 0 0   80 10 11.1 TSR 3.5 3.5 509 Mun. Timişoara TIMIŞ   45.7290017 21.2539564     RO-SITUR SNACK-BAR 3 - STELE  
53798 53798 LA BOGDAN, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 1 star 1 - STELE 42   banquet 0 0 50 0 0   45 0 34.8 TCE 31.4 1.4 130 Com. Murighiol TULCEA   45.0439854 29.1571213     RO-SITUR BUFET-BAR 1 - STELE  
53917 53917 DELTA PALACE, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 2 star 2 98   banquet 0 0 60 0 0   45 0 73.7 TCE 43.7 0.8 50 Oraş Sulina TULCEA   45.1565896 29.6444616     RO-SITUR RESTAURANT-AUTOSERVIRE 2  

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