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

365 rows where country = "RO", family = "fastfood_catering" and rating_value = 3

This data as json, CSV (advanced)

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

rating_value 1

group 1

family 1

  • fastfood_catering · 365 ✖

country 1

  • RO · 365 ✖

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
45512 45512 ELEMENT, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   65 10 52.2 SBZ 2.5 2.5 170 Mun. Alba Iulia ALBA   46.07182 23.5512779     RO-SITUR BUFET-BAR 3 - STELE  
45525 45525 MCdONALD`S, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   65 10 52.1 SBZ 2.2 2.2 165 Mun. Alba Iulia ALBA   46.081033 23.562986     RO-SITUR SNACK-BAR 3 - STELE  
45557 45557 EMRIS, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   65 10 40.7 Câmpia Turzii Air Base 4.5 2.3 23 Mun. Blaj, Sat Spătac ALBA   46.1384236 23.939667     RO-SITUR SNACK-BAR 3 - STELE  
45592 45592 AQUA ŞTRAND MONEASA, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   45 0 68.3 OMR 54.4 1.4 36 Com. Moneasa ARAD   46.4611992 22.258002     RO-SITUR SNACK-BAR 3 - STELE  
45608 45608 PATRIMARA, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   45 30 62.6 CSB 42.5 4.7 5 Com. Săvârşin, Sat Căprioara ARAD   45.9825412 22.2771047     RO-SITUR BUFET-BAR 3 - STELE  
45621 45621 KARTOFFELINO, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   80 20 3.3 ARW 5.8 5.8 93 Com. Vladimirescu ARAD   46.202901 21.24733     RO-SITUR SNACK-BAR 3 - STELE  
45626 45626 IOANIS, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   70 10 15.7 ARW 12.0 0.5 11 Com. Vladimirescu, Sat Mândruloc ARAD   46.144684 21.4624123     RO-SITUR BUFET-BAR 3 - STELE  
45673 45673 CHINA, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   80 0 3.7 ARW 0.6 0.6 408 Mun. Arad ARAD   46.1861391 21.3095193     RO-SITUR SNACK-BAR 3 - STELE  
45690 45690 CRISPY HOUSE, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 3 star 3 - STELE       0 0 40 0 0   80 0 4.6 ARW 0.8 0.8 400 Mun. Arad ARAD   46.1899553 21.3205996     RO-SITUR RESTAURANT-AUTOSERVIRE 3 - STELE  
45691 45691 CRYSPY HOUSE, FAST-FOOD RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   80 0 4.6 ARW 0.8 0.8 400 Mun. Arad ARAD   46.1899553 21.3205996     RO-SITUR FAST-FOOD 3 - STELE  
45736 45736 KARTOFETTE, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   80 0 3.9 ARW 0.5 0.5 408 Mun. Arad ARAD   46.1865606 21.3122677     RO-SITUR BUFET-BAR 3 - STELE  
45738 45738 KEN WOK, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   80 0 4.6 ARW 0.9 0.9 400 Mun. Arad ARAD   46.1904702 21.3208969     RO-SITUR SNACK-BAR 3 - STELE  
45740 45740 KFC, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 3 star 3 - STELE       0 0 40 0 0   80 20 3.3 ARW 5.8 5.8 92 Mun. Arad ARAD   46.202997 21.246219     RO-SITUR RESTAURANT-AUTOSERVIRE 3 - STELE  
45741 45741 LA ANA, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   80 0 3.5 ARW 1.6 1.6 392 Mun. Arad ARAD   46.1938221 21.3019318     RO-SITUR BUFET-BAR 3 - STELE  
45756 45756 LUNCA, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   80 10 3.3 ARW 6.4 3.0 27 Mun. Arad ARAD   46.148518 21.2501202     RO-SITUR BUFET-BAR 3 - STELE  
45765 45765 MCDONALDS, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 3 star 3 - STELE       0 0 40 0 0   80 0 4.1 ARW 0.9 0.9 411 Mun. Arad ARAD   46.1752935 21.317617     RO-SITUR RESTAURANT-AUTOSERVIRE 3 - STELE  
45771 45771 MILLY HOUSE KEBAB, BUFET TIP EXPRES RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   80 10 7.0 ARW 3.3 3.3 378 Mun. Arad ARAD   46.169604 21.3549262     RO-SITUR BUFET TIP EXPRES 3 - STELE  
45835 45835 ROMPETROL, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   80 10 6.8 ARW 2.8 2.8 391 Mun. Arad ARAD   46.1781368 21.352041     RO-SITUR SNACK-BAR 3 - STELE  
45836 45836 ROMPETROL, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   80 10 4.8 ARW 2.8 2.8 380 Mun. Arad ARAD   46.1587597 21.3215248     RO-SITUR SNACK-BAR 3 - STELE  
45849 45849 SUMMER, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   80 0 4.0 ARW 0.4 0.4 412 Mun. Arad ARAD   46.1799254 21.3162634     RO-SITUR SNACK-BAR 3 - STELE  
45886 45886 KOMODO, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   70 30 13.6 ARW 16.5 0.5 0 Oraş Pecica ARAD   46.2534488 21.1279736     RO-SITUR BUFET-BAR 3 - STELE  
45913 45913 MARA, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   50 20 95.1 SBZ 9.9 1.6 3 Com. Băiculeşti ARGEŞ   45.0468638 24.7000642     RO-SITUR SNACK-BAR 3 - STELE  
45923 45923 VALEA LARGĂ, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   55 10 70.2 GHV 23.0 1.7 6 Com. Berevoeşti, Sat Berevoeşti ARGEŞ   45.2267717 24.9362258     RO-SITUR BUFET-BAR 3 - STELE  
45934 45934 SWE SAR, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   55 0 72.8 SBZ 13.2 0.5 23 Com. Cicăneşti ARGEŞ   45.2445122 24.6111116     RO-SITUR BUFET-BAR 3 - STELE  
46008 46008 MESTERUL MANOLE, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 3 star 3 - STELE       0 0 40 0 0   50 10 82.9 SBZ 3.3 2.8 86 Mun. Curtea de Argeş ARGEŞ   45.1634613 24.6712244     RO-SITUR RESTAURANT-AUTOSERVIRE 3 - STELE  
46009 46009 MIKELIS, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE 26     0 0 40 0 0   50 0 85.3 SBZ 0.6 0.6 72 Mun. Curtea de Argeş ARGEŞ   45.1392266 24.6752779     RO-SITUR SNACK-BAR 3 - STELE  
46038 46038 KFC, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   50 10 99.7 CRA 2.4 2.4 144 Mun. Piteşti ARGEŞ   44.8670302 24.8847141     RO-SITUR SNACK-BAR 3 - STELE  
46052 46052 SPRING TIME, FAST-FOOD RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   50 10 99.6 CRA 2.2 2.2 144 Mun. Piteşti ARGEŞ   44.8659889 24.8837633     RO-SITUR FAST-FOOD 3 - STELE  
46114 46114 KFC, FAST-FOOD RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   80 0 6.4 BCM 1.4 1.4 145 Mun. Bacău BACĂU   46.5789743 26.918414     RO-SITUR FAST-FOOD 3 - STELE  
46116 46116 MC DONALDS, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   80 0 3.8 BCM 1.2 1.2 135 Mun. Bacău BACĂU   46.5562191 26.9121452     RO-SITUR SNACK-BAR 3 - STELE  
46117 46117 MC DONALDS, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   80 0 3.8 BCM 1.2 1.2 135 Mun. Bacău BACĂU   46.5562191 26.9121452     RO-SITUR SNACK-BAR 3 - STELE  
46193 46193 BOWLING, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   55 0 34.8 BCM 19.8 1.1 55 Oraş Târgu Ocna BACĂU   46.2879973 26.6078954     RO-SITUR SNACK-BAR 3 - STELE  
46210 46210 DIVA, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   35 10 59.9 OMR 60.5 0.1 8 Com. Budureasa BIHOR   46.6747978 22.5005291     RO-SITUR BUFET-BAR 3 - STELE  
46255 46255 ANTIC, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   80 0 6.5 OMR 6.9 0.9 425 Com. Sânmartin BIHOR   46.9999809 21.9797344     RO-SITUR SNACK-BAR 3 - STELE  
46258 46258 AQUA PRESIDENT, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 3 star 3 - STELE       0 0 40 0 0   80 0 8.0 OMR 8.8 2.0 400 Com. Sânmartin BIHOR   46.9798761 21.9835004     RO-SITUR RESTAURANT-AUTOSERVIRE 3 - STELE  
46261 46261 CASCADE, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   80 0 6.8 OMR 7.6 1.8 411 Com. Sânmartin BIHOR   46.9895138 21.9758953     RO-SITUR SNACK-BAR 3 - STELE  
46272 46272 KONFORT, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   80 0 5.8 OMR 6.5 1.1 426 Com. Sânmartin BIHOR   46.9982967 21.9685689     RO-SITUR BUFET-BAR 3 - STELE  
46279 46279 PERLA, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   80 0 8.0 OMR 8.2 0.3 412 Com. Sânmartin BIHOR   46.997236 21.9991983     RO-SITUR SNACK-BAR 3 - STELE  
46291 46291 YAMMI GRILL, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 3 star 3 - STELE       0 0 40 0 0   80 0 6.8 OMR 7.6 1.8 411 Com. Sânmartin BIHOR   46.9895138 21.9758953     RO-SITUR RESTAURANT-AUTOSERVIRE 3 - STELE  
46318 46318 POIANA, FAST-FOOD RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   80 0 7.1 OMR 7.8 1.5 410 Com. Sânmartin, Sat Băile Felix BIHOR   46.9899236 21.9803673     RO-SITUR FAST-FOOD 3 - STELE  
46360 46360 BULEVARD, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 3 star 3 - STELE       0 0 40 0 0   80 10 5.9 OMR 3.4 3.4 344 Mun. Oradea BIHOR   47.0746719 21.9308556     RO-SITUR RESTAURANT-AUTOSERVIRE 3 - STELE  
46380 46380 MC DONALDS, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   80 10 3.2 OMR 2.8 2.8 475 Mun. Oradea BIHOR   47.0279235 21.9446182     RO-SITUR SNACK-BAR 3 - STELE  
46381 46381 MCDONALDS CRISUL, FAST-FOOD RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   80 10 4.9 OMR 2.3 2.3 364 Mun. Oradea BIHOR   47.0619365 21.9380222     RO-SITUR FAST-FOOD 3 - STELE  
46385 46385 NOVOTHEOS, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   80 10 5.0 OMR 2.4 2.4 362 Mun. Oradea BIHOR   47.063545 21.93745     RO-SITUR BUFET-BAR 3 - STELE  
46419 46419 KRE SPA, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   45 10 34.2 OMR 31.7 1.6 8 Oraş Săcueni, Sat Sânnicolau de Munte BIHOR   47.2955266 22.1196917     RO-SITUR SNACK-BAR 3 - STELE  
46445 46445 BRADUL, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   40 40 104.2 BAY 23.1 6.3 4 Com. Rodna, Sat Valea Vinului BISTRIŢA-NĂSĂUD   47.4793869 24.828296     RO-SITUR SNACK-BAR 3 - STELE  
46449 46449 NARCISA, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 16     0 0 40 0 0   55 20 73.8 BAY 18.2 1.2 5 Com. Romuli, Sat Romuli BISTRIŢA-NĂSĂUD   47.5444701 24.4346366     RO-SITUR SNACK-BAR 3  
46548 46548 MC DONALD S, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 -       0 0 40 0 0   65 0 63.5 TCE 9.0 1.7 34 Com. Chiscani BRĂILA   45.1978149 27.9281988     RO-SITUR SNACK-BAR 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  
46580 46580 LITTLE ORIENT, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 3 star 3 - STELE       0 0 40 0 0   65 10 64.6 TCE 2.3 2.3 92 Mun. Brăila BRĂILA   45.2709273 27.9447918     RO-SITUR RESTAURANT-AUTOSERVIRE 3 - STELE  
46582 46582 MC DONALDS, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   65 10 63.3 TCE 3.1 3.1 95 Mun. Brăila BRĂILA   45.2481963 27.9514649     RO-SITUR SNACK-BAR 3 - STELE  
46773 46773 ASTRA, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 3 star 3 - STELE       0 0 40 0 0   80 0 10.8 GHV 1.8 1.8 1131 Mun. Braşov BRAŞOV   45.6414274 25.6264872     RO-SITUR RESTAURANT-AUTOSERVIRE 3 - STELE  
46774 46774 ATLANTIC, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   80 20 12.4 GHV 7.0 5.5 265 Mun. Braşov BRAŞOV   45.596419 25.5552457     RO-SITUR BUFET-BAR 3 - STELE  
46804 46804 COMPLEX CITY, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 3 star 3 - STELE       0 0 40 0 0   80 10 11.0 GHV 2.1 2.1 1125 Mun. Braşov BRAŞOV   45.6433 25.6325761     RO-SITUR RESTAURANT-AUTOSERVIRE 3 - STELE  
46839 46839 KFC BRASOV, FAST-FOOD RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   80 0 8.7 GHV 1.4 1.4 1173 Mun. Braşov BRAŞOV   45.642813 25.5895916     RO-SITUR FAST-FOOD 3 - STELE  
46848 46848 MC DONALDS, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   80 0 9.2 GHV 0.3 0.3 1179 Mun. Braşov BRAŞOV   45.6498719 25.6101344     RO-SITUR SNACK-BAR 3 - STELE  
46849 46849 MCDONALD S, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   80 10 8.8 GHV 2.1 2.1 1171 Mun. Braşov BRAŞOV   45.6645385 25.6197462     RO-SITUR SNACK-BAR 3 - STELE  
46868 46868 PRATO, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   80 0 8.7 GHV 1.3 1.3 1176 Mun. Braşov BRAŞOV   45.6437929 25.5906669     RO-SITUR BUFET-BAR 3 - STELE  
46876 46876 RIFF, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   80 10 11.3 GHV 2.9 2.9 1058 Mun. Braşov BRAŞOV   45.6489528 25.6439162     RO-SITUR BUFET-BAR 3 - STELE  
46883 46883 SCHUSTER BOARDING HOUSE, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   80 0 9.0 GHV 1.7 1.7 1176 Mun. Braşov BRAŞOV   45.6386936 25.5890966     RO-SITUR SNACK-BAR 3 - STELE  
46896 46896 STREET 21, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 3 star 3 - STELE       0 0 40 0 0   80 0 8.7 GHV 1.5 1.5 1171 Mun. Braşov BRAŞOV   45.6426802 25.5887252     RO-SITUR RESTAURANT-AUTOSERVIRE 3 - STELE  
46909 46909 WARTHE, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   80 10 8.0 GHV 2.1 2.1 1156 Mun. Braşov BRAŞOV   45.6451854 25.5798424     RO-SITUR BUFET-BAR 3 - STELE  
46988 46988 EZIO HOUSE, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   80 10 15.5 GHV 4.8 3.3 146 Mun. Săcele BRAŞOV   45.6009432 25.6540469     RO-SITUR BUFET-BAR 3 - STELE  
47014 47014 ANGEL, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   70 0 24.0 GHV 13.9 1.0 340 Oraş Predeal BRAŞOV   45.4920532 25.5719629     RO-SITUR BUFET-BAR 3 - STELE  
47015 47015 ANOTIMPURI, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE 30     0 0 40 0 0   70 0 23.3 GHV 13.6 0.9 340 Oraş Predeal BRAŞOV   45.4997855 25.5778858     RO-SITUR BUFET-BAR 3 - STELE  
47053 47053 DRAGA MARIA, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   70 10 23.5 GHV 12.1 2.2 350 Oraş Predeal BRAŞOV   45.4942272 25.5396804     RO-SITUR BUFET-BAR 3 - STELE  
47127 47127 CARINA, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   80 10 22.2 GHV 9.7 4.7 88 Oraş Predeal, Loc. Pârâul Rece BRAŞOV   45.5061204 25.5065929     RO-SITUR BUFET-BAR 3 - STELE  
47185 47185 MOTOROM, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   80 10 21.5 GHV 2.8 2.6 341 Oraş Zărneşti BRAŞOV   45.5534495692552 25.3527251400648     RO-SITUR BUFET-BAR 3 - STELE  
47204 47204 SPERANTA, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE 18     0 0 40 0 0   70 10 21.5 Boboc Air Base 16.6 0.1 13 Com. Berca BUZĂU   45.2744845 26.7162536     RO-SITUR BUFET-BAR 3 - STELE  
47222 47222 LA PĂDUCEL, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   70 0 27.5 Boboc Air Base 15.1 0.2 41 Com. Merei BUZĂU   45.1475463 26.6409545     RO-SITUR BUFET-BAR 3 - STELE  
47277 47277 Mc DONALDS, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   80 0 13.9 Boboc Air Base 1.9 1.9 138 Mun. Buzău BUZĂU   45.1632289 26.8178268     RO-SITUR SNACK-BAR 3 - STELE  
47278 47278 MCDONALDS, FAST-FOOD RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   80 0 14.2 Boboc Air Base 1.4 1.4 138 Mun. Buzău BUZĂU   45.1568491 26.8182862     RO-SITUR FAST-FOOD 3 - STELE  
47332 47332 SANELLA, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   30 0 89.9 CSB 56.0 0.8 25 Com. Berzasca CARAŞ-SEVERIN   44.6521454 21.8937428     RO-SITUR BUFET-BAR 3 - STELE  
47342 47342 UNICAT, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   70 0 23.1 CSB 21.1 0.6 31 Com. Brebu Nou CARAŞ-SEVERIN   45.2289481 22.1379605     RO-SITUR BUFET-BAR 3 - STELE  
47357 47357 AURMAR, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   70 10 9.7 CSB 11.7 1.2 6 Com. Glimboca CARAŞ-SEVERIN   45.4938089 22.3192226     RO-SITUR SNACK-BAR 3 - STELE  
47363 47363 RED-ROOF, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   45 0 58.9 CSB 37.5 0.5 213 Com. Mehadia CARAŞ-SEVERIN   44.8971573 22.3695645     RO-SITUR SNACK-BAR 3 - STELE  
47374 47374 BALKAN, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   30 10 87.9 CSB 53.2 0.1 14 Com. Sicheviţa, Sat Gornea CARAŞ-SEVERIN   44.6806973 21.8551886     RO-SITUR BUFET-BAR 3 - STELE  
47376 47376 CASA CREŢA, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   30 30 91.0 CSB 46.3 4.3 4 Com. Sicheviţa, Sat Liborajdea CARAŞ-SEVERIN   44.6769272 21.7679668     RO-SITUR BUFET-BAR 3 - STELE  
47411 47411 CARLA, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   70 10 16.5 CSB 18.8 0.3 9 Com. Zăvoi CARAŞ-SEVERIN   45.525048 22.4025089     RO-SITUR BUFET-BAR 3 - STELE  
47412 47412 FLORINA, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   70 30 21.9 CSB 24.7 10.2 24 Com. Zăvoi CARAŞ-SEVERIN   45.4045423 22.5323434     RO-SITUR BUFET-BAR 3 - STELE  
47436 47436 SIMINA, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   80 0 10.1 TSR 1.1 1.1 586 Mun. Caransebeş CARAŞ-SEVERIN   45.7635778 21.2255767     RO-SITUR BUFET-BAR 3 - STELE  
47443 47443 "ATLANTIC", SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   80 10 27.8 CSB 4.6 2.5 49 Mun. Reşiţa CARAŞ-SEVERIN   45.2919543 21.9465771     RO-SITUR SNACK-BAR 3 - STELE  
47445 47445 BASTILIA, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   65 0 30.9 CSB 1.1 1.1 80 Mun. Reşiţa CARAŞ-SEVERIN   45.2941251 21.8994522     RO-SITUR SNACK-BAR 3 - STELE  
47469 47469 LA TZOMPY, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   65 0 32.1 CSB 1.4 1.4 80 Mun. Reşiţa CARAŞ-SEVERIN   45.2878594 21.887172     RO-SITUR BUFET-BAR 3 - STELE  
47473 47473 OLLE, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 3 star 3 - STELE       0 0 40 0 0   65 0 31.5 CSB 1.2 1.2 80 Mun. Reşiţa CARAŞ-SEVERIN   45.290239 21.8938949     RO-SITUR RESTAURANT-AUTOSERVIRE 3 - STELE  
47497 47497 CARDINAL, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   45 0 62.9 CSB 32.8 0.6 215 Oraş Băile Herculane CARAŞ-SEVERIN   44.8646362 22.4067173     RO-SITUR BUFET-BAR 3 - STELE  
47499 47499 CASA MARIA, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   45 0 61.1 CSB 34.2 0.3 217 Oraş Băile Herculane CARAŞ-SEVERIN   44.8821037 22.4118626     RO-SITUR BUFET-BAR 3 - STELE  
47514 47514 EL PLAZZA, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   45 0 62.2 CSB 33.3 0.8 215 Oraş Băile Herculane CARAŞ-SEVERIN   44.8722752 22.4112574     RO-SITUR BUFET-BAR 3 - STELE  
47517 47517 FLORIANA, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   45 0 61.6 CSB 33.6 0.4 215 Oraş Băile Herculane CARAŞ-SEVERIN   44.878859 22.4179192     RO-SITUR SNACK-BAR 3 - STELE  
47537 47537 PARADIS, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   45 0 61.9 CSB 33.5 0.6 217 Oraş Băile Herculane CARAŞ-SEVERIN   44.8748054 22.410898     RO-SITUR SNACK-BAR 3 - STELE  
47546 47546 SELECT, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   45 0 61.5 CSB 33.8 0.1 217 Oraş Băile Herculane CARAŞ-SEVERIN   44.8784802 22.4130688     RO-SITUR BUFET-BAR 3 - STELE  
47599 47599 SALT RESORT COJOCNA, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   70 20 12.6 CLJ 18.6 0.7 3 Com. Cojocna CLUJ   46.7482233 23.8422582     RO-SITUR SNACK-BAR 3 - STELE  
47613 47613 AGAPE, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 3 star 3 - STELE       0 0 40 0 0   80 0 7.4 CLJ 0.8 0.8 1224 Com. Floreşti CLUJ   46.7703548 23.5915575     RO-SITUR RESTAURANT-AUTOSERVIRE 3 - STELE  
47625 47625 MCDONALDS, FAST-FOOD RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   80 10 12.2 CLJ 5.4 3.1 667 Com. Floreşti CLUJ   46.7502096 23.5337389     RO-SITUR FAST-FOOD 3 - STELE  
47666 47666 PERLA TRANSILVANIEI, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   70 10 16.9 Câmpia Turzii Air Base 12.0 1.3 8 Com. Moldoveneşti CLUJ   46.4954411 23.6652354     RO-SITUR SNACK-BAR 3 - STELE  
47840 47840 COROANA TRANSILVANIEI, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 3 star 3 - STELE       0 0 40 0 0   80 10 5.1 CLJ 3.6 3.6 1002 Mun. Cluj-Napoca CLUJ   46.79611 23.62058     RO-SITUR RESTAURANT-AUTOSERVIRE 3 - STELE  
47853 47853 CUCINA TUREA BACANIE, BUFET TIP EXPRES RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   80 0 7.7 CLJ 1.0 1.0 1225 Mun. Cluj-Napoca CLUJ   46.7695263 23.5872486     RO-SITUR BUFET TIP EXPRES 3 - STELE  
47869 47869 DELICIUL CARTOFILOR, FAST-FOOD RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   80 10 4.7 CLJ 2.1 2.1 1139 Mun. Cluj-Napoca CLUJ   46.7725017 23.6268804     RO-SITUR FAST-FOOD 3 - STELE  
47877 47877 DOROBANTI, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 21     0 0 40 0 0   80 0 6.0 CLJ 1.1 1.1 1200 Mun. Cluj-Napoca CLUJ   46.7742869 23.6088346     RO-SITUR SNACK-BAR 3  
47962 47962 JUNIOR, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 3 star 3 - STELE       0 0 40 0 0   80 10 7.2 CLJ 2.1 2.1 1195 Mun. Cluj-Napoca CLUJ   46.7848063 23.5916466     RO-SITUR SNACK-BAR 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");