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,715 rows where family = "fastfood_catering", group = "eat_drink" and rating_value = 2

This data as json, CSV (advanced)

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

country 2

rating_value 1

  • 2 · 1,715 ✖

group 1

  • eat_drink · 1,715 ✖

family 1

  • fastfood_catering · 1,715 ✖

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
45445 45445 TULNICUL MUNŢILOR, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   45 0 66.3 CLJ 38.3 0.9 30 Com. Albac ALBA   46.4546719 22.9634386     RO-SITUR BUFET-BAR 2 - STELE  
45464 45464 MARYDOR, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   45 0 75.6 CLJ 35.7 0.6 44 Com. Gârda de Sus ALBA   46.453097 22.822685     RO-SITUR BUFET-BAR 2 - STELE  
45466 45466 LA MARIAN, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 2 star 2 - STELE       0 0 40 0 0   45 10 75.0 CLJ 37.3 2.0 47 Com. Gârda de Sus, Sat Dobreşti ALBA   46.468279 22.8192915     RO-SITUR RESTAURANT-AUTOSERVIRE 2 - STELE  
45478 45478 LA HODINEALA, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   65 10 49.2 SBZ 9.4 0.9 7 Com. Pianu ALBA   45.9053678 23.4747941     RO-SITUR BUFET-BAR 2 - STELE  
45497 45497 LOREDANA, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   45 10 69.8 CLJ 33.0 0.4 15 Com. Vadu Moţilor ALBA   46.4025877 22.9627888     RO-SITUR BUFET-BAR 2 - STELE  
45518 45518 HEI ALBA IULIA 2, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   65 0 49.9 Câmpia Turzii Air Base 3.9 1.3 171 Mun. Alba Iulia ALBA   46.0991997 23.6017537     RO-SITUR SNACK-BAR 2 - STELE  
45541 45541 SNACK BAR HEI ALBA IULIA, FAST-FOOD RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   65 0 49.9 SBZ 0.9 0.9 172 Mun. Alba Iulia ALBA   46.0597906 23.5761735     RO-SITUR FAST-FOOD 2 - STELE  
45572 45572 BIP, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   45 10 66.2 Câmpia Turzii Air Base 32.5 0.5 17 Oraş Câmpeni ALBA   46.3628153 23.0459729     RO-SITUR BUFET-BAR 2 - STELE  
45596 45596 MAYUMI, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   45 0 68.4 OMR 54.4 1.3 36 Com. Moneasa ARAD   46.4605754 22.2569865     RO-SITUR SNACK-BAR 2 - STELE  
45602 45602 TESTA SILVIU, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   70 10 26.0 ARW 22.4 0.7 16 Com. Păuliş ARAD   46.1191684 21.5918833     RO-SITUR BUFET-BAR 2 - STELE  
45604 45604 A1 ŞAGU STÂNGA, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 2 star 2 - STELE       0 0 40 0 0   65 10 75.6 SBZ 6.7 1.4 6 Com. Şagu ARAD   45.8375223 23.1138075     RO-SITUR RESTAURANT-AUTOSERVIRE 2 - STELE  
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  
45607 45607 SNACK BAR HEI SAVARSIN, FAST-FOOD RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   45 20 66.1 CSB 44.1 0.4 5 Com. Săvârşin ARAD   46.0143523 22.2378524     RO-SITUR FAST-FOOD 2 - STELE  
45620 45620 FLAMINGO, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   80 0 11.0 ARW 7.2 0.5 58 Com. Vladimirescu ARAD   46.1632457 21.4060103     RO-SITUR BUFET-BAR 2 - STELE  
45638 45638 ANGELIS FOOD, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 2 star 2 - STELE       0 0 40 0 0   80 0 4.0 ARW 1.3 1.3 406 Mun. Arad ARAD   46.1720654 21.3154526     RO-SITUR RESTAURANT-AUTOSERVIRE 2 - STELE  
45644 45644 AS, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   80 20 6.1 ARW 5.1 5.1 195 Mun. Arad ARAD   46.1373519 21.3198328     RO-SITUR BUFET-BAR 2 - STELE  
45652 45652 BON PAPA, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   80 0 4.6 ARW 0.8 0.8 400 Mun. Arad ARAD   46.1905128 21.320372     RO-SITUR SNACK-BAR 2 - STELE  
45653 45653 BON PAPA, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   80 0 4.1 ARW 0.6 0.6 411 Mun. Arad ARAD   46.1783442 21.3170465     RO-SITUR SNACK-BAR 2 - STELE  
45683 45683 COMME DA MAMMA, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   80 0 3.6 ARW 0.5 0.5 410 Mun. Arad ARAD   46.1833844 21.3098801     RO-SITUR SNACK-BAR 2 - STELE  
45688 45688 CRISAN FOOD, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   80 0 4.1 ARW 1.3 1.3 401 Mun. Arad ARAD   46.1944954 21.3102432     RO-SITUR BUFET-BAR 2 - STELE  
45744 45744 LA CUSCRII, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   80 10 1.6 ARW 3.0 3.0 375 Mun. Arad ARAD   46.1699106 21.2832509     RO-SITUR BUFET-BAR 2 - STELE  
45767 45767 MIKY, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 2 star 2 - STELE       0 0 40 0 0   80 10 7.8 ARW 4.1 2.7 328 Mun. Arad ARAD   46.168974 21.3657498     RO-SITUR RESTAURANT-AUTOSERVIRE 2 - STELE  
45775 45775 MORROGALERIE, BUFET TIP EXPRES RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   80 0 4.3 ARW 1.7 1.7 405 Mun. Arad ARAD   46.1684275 21.3185143     RO-SITUR BUFET TIP EXPRES 2 - STELE  
45795 45795 PIANDRA, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - 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 2 - STELE  
45799 45799 PIT STOP, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 2 star 2 - STELE       0 0 40 0 0   80 0 3.6 ARW 0.5 0.5 410 Mun. Arad ARAD   46.183286 21.309984     RO-SITUR RESTAURANT-AUTOSERVIRE 2 - STELE  
45809 45809 POPEY CHICKEN, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   80 0 10.5 TSR 0.6 0.6 589 Mun. Arad ARAD   45.7588247 21.2233705     RO-SITUR SNACK-BAR 2 - STELE  
45816 45816 QING TIAN, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - 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 SNACK-BAR 2 - STELE  
45821 45821 RATIO WEST, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   80 10 8.5 ARW 4.6 2.1 246 Mun. Arad ARAD   46.1731207 21.3752106     RO-SITUR BUFET-BAR 2 - STELE  
45839 45839 SALON MEMOS DONER KEBAB, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   80 0 3.8 ARW 1.1 1.1 406 Mun. Arad ARAD   46.191279 21.3080393     RO-SITUR SNACK-BAR 2 - STELE  
45850 45850 SZEVAR BAR 2012, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   80 0 3.8 ARW 1.1 1.1 406 Mun. Arad ARAD   46.190785 21.30828     RO-SITUR BUFET-BAR 2 - STELE  
45856 45856 TRANSI 2, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   80 0 4.8 ARW 0.8 0.8 401 Mun. Arad ARAD   46.1887329 21.3243234     RO-SITUR BUFET-BAR 2 - STELE  
45857 45857 TRANSI 3, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   80 0 4.8 ARW 0.8 0.8 401 Mun. Arad ARAD   46.1887329 21.3243234     RO-SITUR BUFET-BAR 2 - STELE  
45864 45864 VILAS, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   80 0 4.8 ARW 1.1 1.1 405 Mun. Arad ARAD   46.1762613 21.3263591     RO-SITUR BUFET-BAR 2 - STELE  
45866 45866 VIVA, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   80 0 3.9 ARW 0.2 0.2 409 Mun. Arad ARAD   46.1835229 21.3137122     RO-SITUR SNACK-BAR 2 - STELE  
45874 45874 ZORI DE ZI, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   80 10 3.3 ARW 6.4 3.0 27 Mun. Arad ARAD   46.1480281 21.2504749     RO-SITUR BUFET-BAR 2 - STELE  
45883 45883 SNACK BAR HEI NADLAC 2, FAST-FOOD RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   55 10 39.2 ARW 21.8 0.6 6 Oraş Nădlac ARAD   46.1623178 20.7555728     RO-SITUR FAST-FOOD 2 - STELE  
45885 45885 HEI PECICA, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   70 30 11.2 ARW 15.2 4.4 3 Oraş Pecica ARAD   46.1813479 21.1193985     RO-SITUR SNACK-BAR 2 - STELE  
45899 45899 PALTINU, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE 28     0 0 40 0 0   45 40 48.3 SBZ 40.3 18.1 8 Com. Arefu ARGEŞ   45.5556163690155 24.6140987698441     RO-SITUR BUFET-BAR 2 - STELE  
45907 45907 ZIMBRU TRANSFĂGĂRĂŞAN, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   45 40 60.5 SBZ 30.3 8.1 3 Com. Arefu ARGEŞ   45.4059656 24.643812     RO-SITUR SNACK-BAR 2 - STELE  
45941 45941 BUN 88, FAST-FOOD RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   55 0 73.8 SBZ 13.4 0.2 45 Com. Corbeni, Sat Oeştii Ungureni ARGEŞ   45.25355 24.6514964     RO-SITUR FAST-FOOD 2 - STELE  
45943 45943 STILL, FAST-FOOD RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   40 30 95.4 CRA 15.3 3.8 2 Com. Cotmeana ARGEŞ   45.0041958 24.6118153     RO-SITUR FAST-FOOD 2 - STELE  
45945 45945 ANDU, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   55 0 37.9 GHV 15.7 1.7 101 Com. Dâmbovicioara ARGEŞ   45.4359403 25.224636     RO-SITUR SNACK-BAR 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  
45955 45955 FRASIN, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   55 0 47.3 GHV 25.2 1.2 50 Com. Dragoslavele ARGEŞ   45.3607125 25.166991     RO-SITUR BUFET-BAR 2 - STELE  
45960 45960 CASA RIM, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   45 0 57.8 GHV 35.4 0.6 76 Com. Lereşti, Sat Voineşti ARGEŞ   45.2946229 25.0695898     RO-SITUR BUFET-BAR 2 - STELE  
45979 45979 CHEILE DÂMBOVIŢEI, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   55 10 40.5 GHV 18.0 3.5 127 Com. Rucăr, Sat Sătic ARGEŞ   45.429875 25.1822962     RO-SITUR BUFET-BAR 2 - STELE  
46004 46004 HEI CURTEA DE ARGEŞ, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   50 10 83.4 SBZ 2.7 2.7 81 Mun. Curtea de Argeş ARGEŞ   45.1584999 24.671826     RO-SITUR SNACK-BAR 2 - STELE  
46037 46037 HEI PITEŞTI 3, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   50 10 99.7 CRA 2.3 2.3 144 Mun. Piteşti ARGEŞ   44.8673505 24.8834161     RO-SITUR SNACK-BAR 2 - STELE  
46050 46050 SNACK BAR HEI PITESTI 2, FAST-FOOD RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   50 0 97.8 CRA 3.9 1.4 132 Mun. Piteşti ARGEŞ   44.8791958 24.840104     RO-SITUR FAST-FOOD 2 - STELE  
46051 46051 SNACK BAR HEI PITESTI 4, FAST-FOOD RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   50 0 97.3 CRA 2.5 1.3 122 Mun. Piteşti ARGEŞ   44.8309308 24.8834581     RO-SITUR FAST-FOOD 2 - STELE  
46053 46053 STAŢIA DE DISTRIBUŢIE PRODUSE PETROLIERE ROMPETROL PITEŞTI 1, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   50 0 98.5 CRA 1.7 1.7 132 Mun. Piteşti ARGEŞ   44.846042 24.887306     RO-SITUR SNACK-BAR 2 - STELE  
46071 46071 DEAKY, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   45 10 62.8 BCM 30.9 0.3 6 Com. Ghimeş-Făget, Sat Ghimeş BACĂU   46.5664169 26.0914762     RO-SITUR BUFET-BAR 2 - STELE  
46088 46088 REGENS PISCINĂ, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   80 10 4.8 BCM 9.7 1.5 13 Com. Nicolae Bălcescu BACĂU   46.4797792 26.9217663     RO-SITUR BUFET-BAR 2 - STELE  
46126 46126 SIRETU, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   70 20 17.1 BCM 12.1 0.5 1 Mun. Bacău BACĂU   46.6751137 26.9283348     RO-SITUR BUFET-BAR 2 - STELE  
46127 46127 SNACK BAR HEI BACAU 1, FAST-FOOD RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   80 10 1.1 BCM 4.3 2.7 91 Mun. Bacău BACĂU   46.5290121 26.9203355     RO-SITUR FAST-FOOD 2 - STELE  
46128 46128 SNACK BAR HEI BACAU 2, FAST-FOOD RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   80 0 6.2 BCM 1.2 1.2 146 Mun. Bacău BACĂU   46.5775781 26.9152714     RO-SITUR FAST-FOOD 2 - STELE  
46129 46129 SOFERUL NOROCOS, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   80 0 9.3 BCM 4.3 0.6 117 Mun. Bacău BACĂU   46.6054111 26.9019895     RO-SITUR BUFET-BAR 2 - STELE  
46130 46130 SPORT- RESIDENCE, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   80 0 4.3 BCM 0.9 0.9 137 Mun. Bacău BACĂU   46.5598909 26.9200309     RO-SITUR BUFET-BAR 2 - STELE  
46141 46141 HEI ONEŞTI, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   45 0 31.6 BCM 31.7 1.7 37 Mun. Oneşti BACĂU   46.2543239 26.771443     RO-SITUR SNACK-BAR 2 - STELE  
46153 46153 SNACK BAR HEI COMANESTI, FAST-FOOD RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   65 10 37.0 BCM 1.2 1.2 16 Oraş Comăneşti BACĂU   46.4190806 26.4511272     RO-SITUR FAST-FOOD 2 - STELE  
46204 46204 HEI BORŞ, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   70 10 12.0 OMR 11.1 0.6 7 Com. Borş BIHOR   47.1131006 21.8100136     RO-SITUR SNACK-BAR 2 - STELE  
46212 46212 LA CINCI CĂSUŢE, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   45 40 75.7 CLJ 51.6 13.4 15 Com. Budureasa BIHOR   46.5961004 22.7324945     RO-SITUR BUFET-BAR 2 - STELE  
46218 46218 CASA GORNICULUI, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   45 30 60.4 OMR 45.2 5.1 19 Com. Bulz BIHOR   46.8401872 22.6496711     RO-SITUR BUFET-BAR 2 - STELE  
46228 46228 STRAND TERMAL MĂDĂRAŞ, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   80 10 27.2 OMR 4.4 0.6 13 Com. Mădăras BIHOR   46.8354116 21.6758945     RO-SITUR SNACK-BAR 2 - STELE  
46240 46240 DANIELA, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   45 0 69.3 OMR 53.8 0.8 32 Com. Pietroasa BIHOR   46.5902106 22.5537321     RO-SITUR BUFET-BAR 2 - STELE  
46242 46242 MIRELA, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   45 40 78.4 CLJ 49.8 11.8 16 Com. Pietroasa BIHOR   46.5779068 22.7036736     RO-SITUR BUFET-BAR 2 - STELE  
46251 46251 1 MAI, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   80 0 7.2 OMR 7.4 0.9 425 Com. Sânmartin BIHOR   47.0006355 21.9899535     RO-SITUR SNACK-BAR 2 - STELE  
46259 46259 CAII DIN VALE, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   70 10 10.2 OMR 10.7 2.5 364 Com. Sânmartin BIHOR   46.9755594 22.0149132     RO-SITUR BUFET-BAR 2 - STELE  
46264 46264 CRINUL 2, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   80 0 4.7 OMR 4.7 1.3 502 Com. Sânmartin BIHOR   47.0158885 21.9623288     RO-SITUR SNACK-BAR 2 - STELE  
46268 46268 EMA, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   80 0 5.9 OMR 6.3 0.5 431 Com. Sânmartin BIHOR   47.0026385 21.9722313     RO-SITUR BUFET-BAR 2 - STELE  
46270 46270 FELIX, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 2 star 2 - STELE       0 0 40 0 0   80 0 6.7 OMR 7.3 1.5 423 Com. Sânmartin BIHOR   46.994513 21.9787784     RO-SITUR RESTAURANT-AUTOSERVIRE 2 - STELE  
46273 46273 LOTUS, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 2 star 2 - STELE       0 0 40 0 0   80 0 5.9 OMR 6.1 0.1 434 Com. Sânmartin BIHOR   47.0066 21.9747     RO-SITUR RESTAURANT-AUTOSERVIRE 2 - STELE  
46294 46294 APOLLO, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - 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 BUFET-BAR 2 - STELE  
46303 46303 KARTOFI, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 STELE 5     0 0 40 0 0   80 0 6.8 OMR 7.4 1.4 422 Com. Sânmartin, Sat Băile Felix BIHOR   46.9942357 21.9797912     RO-SITUR SNACK-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  
46336 46336 PERLA ALBASTRA, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   45 0 48.8 OMR 37.7 1.4 38 Com. Şuncuiuş BIHOR   46.9461915 22.53508     RO-SITUR BUFET-BAR 2 - STELE  
46338 46338 LA MARIA, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 30     0 0 40 0 0   45 0 48.8 OMR 37.4 1.7 38 Com. Şuncuiuş, Sat Şuncuiuş BIHOR   46.9487301 22.536277     RO-SITUR SNACK-BAR 2  
46341 46341 LA GROTTA RESORT, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   45 0 46.6 OMR 35.7 0.6 33 Com. Vadu Crişului BIHOR   46.9782843 22.5130868     RO-SITUR BUFET-BAR 2 - STELE  
46353 46353 TERMAL, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   45 10 48.6 OMR 36.9 0.6 17 Mun. Marghita BIHOR   47.3461939 22.3393932     RO-SITUR BUFET-BAR 2 - STELE  
46370 46370 FELIX, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 2 star 2 - STELE       0 0 40 0 0   80 10 4.7 OMR 2.1 2.1 362 Mun. Oradea BIHOR   47.0621855 21.9317528     RO-SITUR RESTAURANT-AUTOSERVIRE 2 - STELE  
46372 46372 HEI ORADEA, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   80 10 4.5 OMR 2.8 2.8 429 Mun. Oradea BIHOR   47.0437231 21.9547319     RO-SITUR SNACK-BAR 2 - STELE  
46373 46373 HEI ORADEA CLUJULUI, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   80 10 5.7 OMR 4.2 3.9 382 Mun. Oradea BIHOR   47.0421595 21.9731783     RO-SITUR SNACK-BAR 2 - STELE  
46374 46374 HEY RED ORADEA 1, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   80 0 2.3 OMR 0.6 0.6 361 Mun. Oradea BIHOR   47.0454132 21.9099601     RO-SITUR SNACK-BAR 2 - STELE  
46397 46397 SNACK BAR HEI ORADEA 2, FAST-FOOD RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   80 0 2.9 OMR 1.1 1.1 351 Mun. Oradea BIHOR   47.0513403 21.9056231     RO-SITUR FAST-FOOD 2 - STELE  
46398 46398 SNACK BAR HEI ORADEA 3, FAST-FOOD RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   80 10 4.4 OMR 2.6 2.6 332 Mun. Oradea BIHOR   47.0649392 21.8987561     RO-SITUR FAST-FOOD 2 - STELE  
46409 46409 ARIEŞ, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   30 20 81.6 OMR 43.6 7.7 37 Oraş Nucet BIHOR   46.5183563 22.6767158     RO-SITUR BUFET-BAR 2 - STELE  
46490 46490 SNACK BAR HEI BISTRITA, FAST-FOOD RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   65 0 72.0 CLJ 1.6 1.6 90 Mun. Bistriţa BISTRIŢA-NĂSĂUD   47.13962 24.4813094     RO-SITUR FAST-FOOD 2 - STELE  
46536 46536 RARES, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   80 0 24.5 SCV 0.6 0.6 51 Mun. Botoşani BOTOŞANI   47.7453417 26.6700751     RO-SITUR BUFET-BAR 2 - STELE  
46577 46577 LA OLTEANU, BUFET TIP EXPRES RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   65 10 66.0 Cahul International Airport 4.3 3.2 74 Mun. Brăila BRĂILA   45.2971278 27.9330458     RO-SITUR BUFET TIP EXPRES 2 - STELE  
46595 46595 SNACK BAR HEI BRAILA 1, FAST-FOOD RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   65 10 63.7 TCE 4.7 4.6 97 Mun. Brăila BRĂILA   45.236016 27.940558     RO-SITUR FAST-FOOD 2 - STELE  
46596 46596 SNACK BAR HEI BRAILA 2, FAST-FOOD RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   65 0 63.1 TCE 1.6 1.6 85 Mun. Brăila BRĂILA   45.28598 27.974398     RO-SITUR FAST-FOOD 2 - STELE  
46598 46598 SPORT, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   65 0 62.5 TCE 0.2 0.2 90 Mun. Brăila BRĂILA   45.2731246 27.9747303     RO-SITUR BUFET-BAR 2 - STELE  
46615 46615 EAST VILLAGE, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 2 star 2 - STELE       0 0 40 0 0   80 0 24.2 GHV 6.4 1.5 489 Com. Bran BRAŞOV   45.5162413 25.3688668     RO-SITUR RESTAURANT-AUTOSERVIRE 2 - STELE  
46625 46625 MARTIN, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   80 0 23.9 GHV 6.2 1.6 486 Com. Bran BRAŞOV   45.5191918 25.3696831     RO-SITUR BUFET-BAR 2 - STELE  
46693 46693 VALEA LUI BOGDAN, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   65 0 30.2 GHV 9.6 0.6 435 Com. Moieciu, Sat Cheia BRAŞOV   45.47463 25.319699     RO-SITUR BUFET-BAR 2 - STELE  
46711 46711 SORINA, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   55 0 34.0 GHV 14.3 1.3 236 Com. Moieciu, Sat Moieciu de Sus BRAŞOV   45.4324777 25.326573     RO-SITUR BUFET-BAR 2 - STELE  
46729 46729 NICODOR, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   55 10 56.0 GHV 21.8 4.7 59 Com. Sâmbăta de Sus BRAŞOV   45.6912203 24.8020818     RO-SITUR BUFET-BAR 2 - STELE  
46730 46730 NICODOR, BUFET-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   55 10 56.0 GHV 21.8 4.7 59 Com. Sâmbăta de Sus BRAŞOV   45.6912203 24.8020818     RO-SITUR BUFET-BAR 2 - STELE  
46752 46752 HEI VIŞTEA, SNACK-BAR RO eat_drink fastfood_catering fast_food normal 2 star 2 - STELE       0 0 40 0 0   55 20 49.5 SBZ 19.7 0.0 4 Com. Viştea BRAŞOV   45.7959235 24.724279     RO-SITUR SNACK-BAR 2 - STELE  
46811 46811 DUMBRAVA MINUNATĂ, RESTAURANT-AUTOSERVIRE RO eat_drink fastfood_catering canteen normal 2 star 2 - STELE       0 0 40 0 0   80 0 9.0 GHV 0.0 0.0 1176 Mun. Braşov BRAŞOV   45.6489047 25.6060723     RO-SITUR RESTAURANT-AUTOSERVIRE 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");