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,430 rows where country = "RO", group = "eat_drink" and rating_value = 2

This data as json, CSV (advanced)

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

family 4

best_for 2

rating_value 1

  • 2 · 3,430 ✖

group 1

  • eat_drink · 3,430 ✖

country 1

  • RO · 3,430 ✖

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
45444 45444 STEAUA ARIESULUI, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   45 0 67.0 CLJ 37.9 0.2 30 Com. Albac ALBA   46.452808 22.954159     RO-SITUR RESTAURANT CLASIC 2 - STELE  
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  
45447 45447 CABANA VARTOP, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   30 20 81.9 OMR 43.1 7.5 38 Com. Arieşeni ALBA   46.5142687 22.6771063     RO-SITUR RESTAURANT CLASIC 2 - STELE  
45451 45451 SKY HUB, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   45 0 78.5 CLJ 37.1 1.4 104 Com. Arieşeni ALBA   46.4666561 22.7682126     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 2 - STELE  
45453 45453 VANK, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   45 0 79.3 CLJ 38.3 0.6 91 Com. Arieşeni ALBA   46.4766179 22.7499137     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 2 - STELE  
45454 45454 VRAJA MUNTELUI, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   30 20 81.2 CLJ 41.8 5.2 93 Com. Arieşeni ALBA   46.5051118 22.7036806     RO-SITUR RESTAURANT CLASIC 2 - STELE  
45455 45455 ELA & CĂTĂ, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   45 10 65.5 Câmpia Turzii Air Base 33.1 0.5 17 Com. Bistra ALBA   46.3639212 23.0556952     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 2 - STELE  
45458 45458 LA VERDINA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 STELE 30     0 0 40 0 0   55 10 39.4 Câmpia Turzii Air Base 14.7 0.1 9 Com. Galda de Jos, Sat Benic ALBA   46.2124985 23.5914445     RO-SITUR RESTAURANT CLASIC 2 STELE  
45461 45461 POARTA OILOR, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   70 10 29.5 SBZ 15.8 1.3 6 Com. Gârbova ALBA   45.8593251 23.7201921     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 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  
45468 45468 CĂSUŢA DIN POVEŞTI, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   45 0 64.5 CLJ 42.7 0.3 37 Com. Horea ALBA   46.4997283 22.9505161     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 2 - STELE  
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  
45474 45474 MAMA LUTA, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   55 10 53.8 Câmpia Turzii Air Base 10.9 1.0 10 Com. Meteş ALBA   46.1171325 23.4626738     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 2 - STELE  
45475 45475 CASA AMPOIŢANĂ, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   55 10 53.2 Câmpia Turzii Air Base 10.2 1.8 14 Com. Meteş, Sat Ampoiţa ALBA   46.1182608 23.4735226     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 2 - STELE  
45476 45476 CASA AMPEIA, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   65 10 55.7 Câmpia Turzii Air Base 9.6 0.3 7 Com. Meteş, Sat Tăuţi ALBA   46.0940497 23.4658928     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 2 - STELE  
45477 45477 GELA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   80 20 16.3 Câmpia Turzii Air Base 6.6 0.1 1 Com. Mirăslău ALBA   46.3824267 23.764068     RO-SITUR RESTAURANT CLASIC 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  
45479 45479 GE-LUX, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   45 50 47.5 Câmpia Turzii Air Base 39.0 8.9 0 Com. Poşaga, Sat Inceşti ALBA   46.4674718 23.267582     RO-SITUR RESTAURANT CLASIC 2 - STELE  
45480 45480 CASA KIRALY VENDEGHAZ, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   70 0 25.0 Câmpia Turzii Air Base 20.2 0.8 45 Com. Rimetea ALBA   46.4568176 23.5659942     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 2 - STELE  
45484 45484 SUB PIATRA, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   55 20 35.2 Câmpia Turzii Air Base 21.6 3.5 9 Com. Sălciua ALBA   46.3833121 23.4607753     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 2 - STELE  
45485 45485 PODUL CETĂŢII, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   65 10 40.9 SBZ 8.6 1.3 10 Com. Săsciori ALBA   45.8789306 23.5761176     RO-SITUR RESTAURANT CLASIC 2 - STELE  
45486 45486 ALEX & TONI, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   65 10 48.0 SBZ 3.8 3.0 34 Com. Săsciori, Sat Sebeşel ALBA   45.9701267 23.5257476     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 2 - STELE  
45489 45489 CASA DAVID, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   55 0 34.1 SBZ 22.0 0.6 22 Com. Şugag ALBA   45.766502 23.6481876     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 2 - STELE  
45491 45491 NUŢA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   55 40 46.8 SBZ 17.9 15.9 8 Com. Şugag ALBA   45.5707961 23.5694096     RO-SITUR BAR DE ZI 2 - STELE  
45494 45494 VALEA FRUMOASEI, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   55 0 35.5 SBZ 20.7 0.9 22 Com. Şugag ALBA   45.7747999 23.629573     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 2 - STELE  
45496 45496 COTUL ARIEŞULUI, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   45 20 69.1 CLJ 32.5 2.2 11 Com. Vadu Moţilor ALBA   46.3888 22.99     RO-SITUR RESTAURANT CLASIC 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  
45499 45499 MELINDA, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   80 10 24.3 Câmpia Turzii Air Base 1.3 1.3 17 Mun. Aiud ALBA   46.3085781 23.7380219     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 2 - STELE  
45500 45500 MOBIS, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   80 10 24.1 Câmpia Turzii Air Base 0.8 0.8 17 Mun. Aiud ALBA   46.3177485 23.7214069     RO-SITUR RESTAURANT CLASIC 2 - STELE  
45505 45505 BIP, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   65 0 50.5 SBZ 0.8 0.8 191 Mun. Alba Iulia ALBA   46.0732725 23.5804886     RO-SITUR BAR DE ZI 2 - STELE  
45507 45507 CETATE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   65 0 50.9 SBZ 1.1 1.1 191 Mun. Alba Iulia ALBA   46.0688966 23.5688882     RO-SITUR BAR DE ZI 2 - STELE  
45508 45508 CETATE, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   65 0 50.9 SBZ 1.1 1.1 191 Mun. Alba Iulia ALBA   46.0688966 23.5688882     RO-SITUR RESTAURANT CLASIC 2 - STELE  
45515 45515 FLAMINGO, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   65 0 50.4 SBZ 0.5 0.5 191 Mun. Alba Iulia ALBA   46.068374 23.577362     RO-SITUR RESTAURANT CLASIC 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  
45523 45523 MĂCINIC, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   65 0 49.7 SBZ 0.2 0.2 191 Mun. Alba Iulia ALBA   46.0656391 23.5855531     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 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  
45543 45543 TARA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   65 10 46.2 Câmpia Turzii Air Base 7.6 2.1 24 Mun. Alba Iulia ALBA   46.1288213 23.6229013     RO-SITUR RESTAURANT CLASIC 2 - STELE  
45544 45544 TRANSILVANIA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   65 0 50.3 SBZ 0.6 0.6 191 Mun. Alba Iulia ALBA   46.0719002 23.5822101     RO-SITUR RESTAURANT CLASIC 2 - STELE  
45547 45547 DI ANGELLO, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   65 0 36.4 Câmpia Turzii Air Base 0.4 0.4 28 Mun. Blaj ALBA   46.1750442 23.9104969     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 2 - STELE  
45548 45548 LA POPA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   65 0 36.4 Câmpia Turzii Air Base 0.2 0.2 28 Mun. Blaj ALBA   46.1758335 23.9174815     RO-SITUR RESTAURANT CLASIC 2 - STELE  
45549 45549 MAN PRESIDENT, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   65 0 36.5 Câmpia Turzii Air Base 0.8 0.4 28 Mun. Blaj ALBA   46.1738826 23.9049233     RO-SITUR RESTAURANT CLASIC 2 - STELE  
45551 45551 MONTANA POPA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   65 0 36.3 Câmpia Turzii Air Base 0.6 0.6 28 Mun. Blaj ALBA   46.1766368 23.9238982     RO-SITUR RESTAURANT CLASIC 2 - STELE  
45554 45554 TARNAVELE, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   65 0 36.3 Câmpia Turzii Air Base 0.5 0.5 28 Mun. Blaj ALBA   46.176657 23.922037     RO-SITUR RESTAURANT CLASIC 2 - STELE  
45561 45561 DACIA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   65 0 43.1 SBZ 1.1 1.1 30 Mun. Sebeş ALBA   45.950638 23.582642     RO-SITUR RESTAURANT CLASIC 2 - STELE  
45567 45567 DETUNATA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   55 20 66.6 Câmpia Turzii Air Base 27.5 2.9 14 Oraş Abrud ALBA   46.2573866 23.0929582     RO-SITUR RESTAURANT CLASIC 2 - STELE  
45570 45570 FRUCTELE PĂDURII, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   45 20 47.7 Câmpia Turzii Air Base 34.2 0.6 4 Oraş Baia de Arieş ALBA   46.3812885 23.2883653     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 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  
45574 45574 TULNIC, RESTAURANT CLASIC RO eat_drink restaurants restaurant 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 RESTAURANT CLASIC 2 - STELE  
45575 45575 LA POCIU, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   45 20 64.4 Câmpia Turzii Air Base 33.2 2.3 17 Oraş Câmpeni, Loc. Vârşi ALBA   46.3544064 23.0736277     RO-SITUR RESTAURANT CLASIC 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  
45578 45578 COMPLEX AGREMENT BELLAVI, BRASERIE SAU BISTROU RO eat_drink restaurants restaurant normal 2 star 2 30     0 0 40 0 0   80 10 12.6 Câmpia Turzii Air Base 1.6 1.6 15 Oraş Ocna Mureş ALBA   46.389827 23.8687533     RO-SITUR BRASERIE SAU BISTROU 2  
45579 45579 GOLD TERRACE, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   80 10 13.5 Câmpia Turzii Air Base 0.5 0.5 14 Oraş Ocna Mureş ALBA   46.3822351 23.8565323     RO-SITUR RESTAURANT CLASIC 2 - STELE  
45581 45581 LEU DE AUR, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   55 20 66.7 Câmpia Turzii Air Base 27.6 0.3 3 Oraş Zlatna ALBA   46.1091895 23.2301661     RO-SITUR RESTAURANT CLASIC 2 - STELE  
45582 45582 LOTUS, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   80 0 3.9 ARW 0.3 0.3 408 ARAD ARAD   46.1847585 21.312928     RO-SITUR RESTAURANT CLASIC 2 - STELE  
45584 45584 CASA BATA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   45 30 58.7 TSR 35.9 2.7 2 Com. Bata, Sat Ţela ARAD   45.9949722 22.0483951     RO-SITUR RESTAURANT CLASIC 2 - STELE  
45585 45585 MARIA RUSTIC RESORT, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   45 20 68.1 ARW 55.3 1.4 1 Com. Buteni ARAD   46.3288898 22.1223923     RO-SITUR RESTAURANT CLASIC 2 - STELE  
45586 45586 MARIA RUSTIC RESORT, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   45 20 60.3 ARW 56.2 0.7 1 Com. Buteni, Sat Cuied ARAD   46.3357344 22.0140324     RO-SITUR RESTAURANT CLASIC 2 - STELE  
45587 45587 LA AMADEUS & MONICA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE 30     0 0 40 0 0   70 10 26.5 ARW 22.7 0.9 18 Com. Ghioroc, Sat Miniş ARAD   46.1288802 21.6011326     RO-SITUR RESTAURANT CLASIC 2 - STELE  
45588 45588 MUNTELE GAINA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   40 10 96.7 CSB 21.1 0.9 9 Com. Hălmagiu ARAD   46.2594277 22.5777148     RO-SITUR RESTAURANT CLASIC 2 - STELE  
45589 45589 MUNTELE GĂINA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   40 10 96.7 CSB 21.1 0.9 9 Com. Hălmagiu ARAD   46.2594277 22.5777148     RO-SITUR RESTAURANT CLASIC 2 - STELE  
45590 45590 MUNTELE GĂINA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   40 10 96.7 CSB 21.1 0.9 9 Com. Hălmagiu, Sat Hălmagiu ARAD   46.2594277 22.5777148     RO-SITUR RESTAURANT CLASIC 2 - STELE  
45591 45591 AVIV, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   80 10 10.6 ARW 6.9 0.1 14 Com. Livada ARAD   46.2237705 21.3843369     RO-SITUR RESTAURANT CLASIC 2 - STELE  
45593 45593 CODRU MOMA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   45 0 68.3 OMR 54.6 1.2 36 Com. Moneasa ARAD   46.4603468 22.2535709     RO-SITUR BAR DE ZI 2 - STELE  
45594 45594 CODRU MOMA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   45 0 68.3 OMR 54.6 1.2 36 Com. Moneasa ARAD   46.4603468 22.2535709     RO-SITUR RESTAURANT CLASIC 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  
45601 45601 TANAMERA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   45 0 68.3 OMR 54.2 1.8 36 Com. Moneasa ARAD   46.4629061 22.2637441     RO-SITUR RESTAURANT CLASIC 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  
45609 45609 RODICA, CAFE-BAR SAU CAFENEA RO eat_drink cafes cafe normal 2 star 2 - STELE       0 0 40 0 0   60 20 27.0 ARW 31.1 0.7 5 Com. Semlac ARAD   46.1139125 20.9255219     RO-SITUR CAFE-BAR SAU CAFENEA 2 - STELE  
45610 45610 RODICA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   60 20 27.0 ARW 31.1 0.7 5 Com. Semlac ARAD   46.1139125 20.9255219     RO-SITUR RESTAURANT CLASIC 2 - STELE  
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  
45613 45613 LA FORESTERIA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   55 20 31.0 ARW 26.9 1.3 4 Com. Şiria, Sat Galşa ARAD   46.2831692 21.6359103     RO-SITUR RESTAURANT CLASIC 2 - STELE  
45617 45617 GIOVANNI, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   40 20 90.9 OMR 29.0 0.1 3 Com. Vârfurile ARAD   46.3436132 22.5600489     RO-SITUR BAR DE ZI 2 - STELE  
45618 45618 GIOVANNI, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   40 20 90.9 OMR 29.0 0.1 3 Com. Vârfurile, Sat Lazuri ARAD   46.3436132 22.5600489     RO-SITUR BAR DE ZI 2 - STELE  
45619 45619 CASA VERDE, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   80 0 11.3 ARW 7.6 0.9 49 Com. Vladimirescu ARAD   46.1617681 21.4100291     RO-SITUR RESTAURANT CLASIC 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  
45622 45622 KF, CAFE-BAR SAU CAFENEA RO eat_drink cafes cafe normal 2 star 2 - STELE       0 0 40 0 0   80 0 11.2 ARW 7.5 0.8 51 Com. Vladimirescu ARAD   46.1607201 21.4084347     RO-SITUR CAFE-BAR SAU CAFENEA 2 - STELE  
45623 45623 NEGREA EVENTS, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   80 0 5.3 ARW 1.3 1.3 405 Com. Vladimirescu ARAD   46.1798028 21.3326994     RO-SITUR RESTAURANT CLASIC 2 - STELE  
45624 45624 SAFIR 2, RESTAURANT CLASIC RO eat_drink restaurants restaurant 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 RESTAURANT CLASIC 2 - STELE  
45625 45625 WEST, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   80 0 11.4 ARW 7.6 0.9 48 Com. Vladimirescu ARAD   46.1618168 21.4106479     RO-SITUR RESTAURANT CLASIC 2 - STELE  
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  
45628 45628 ZERIND, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   55 20 53.3 ARW 18.1 0.7 1 Com. Zerind ARAD   46.6225105 21.5174194     RO-SITUR RESTAURANT CLASIC 2 - STELE  
45630 45630 ROUTE 94, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   70 20 15.5 ARW 12.5 0.4 4 Com. Zimandu Nou ARAD   46.2815966 21.3959958     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 2 - STELE  
45634 45634 AMI-AMI, CAFE-BAR SAU CAFENEA RO eat_drink cafes cafe normal 2 star 2 - STELE       0 0 40 0 0   80 0 8.9 ARW 5.1 1.6 200 Mun. Arad ARAD   46.1686651 21.3799167     RO-SITUR CAFE-BAR SAU CAFENEA 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  
45642 45642 ARIZONA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 10 7.2 ARW 5.1 3.7 221 Mun. Arad ARAD   46.1419298 21.3443804     RO-SITUR BAR DE ZI 2 - STELE  
45643 45643 ART CAFE GALLERY, CAFE-BAR SAU CAFENEA RO eat_drink cafes cafe normal 2 star 2 - STELE       0 0 40 0 0   80 0 4.1 ARW 1.5 1.5 405 Mun. Arad ARAD   46.1699864 21.316343     RO-SITUR CAFE-BAR SAU CAFENEA 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  
45646 45646 BELVEDERE, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   80 10 2.7 ARW 3.3 3.3 361 Mun. Arad ARAD   46.1604413 21.2901977     RO-SITUR RESTAURANT CLASIC 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  
45656 45656 BUCEGI, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   80 0 3.4 ARW 1.3 1.3 397 Mun. Arad ARAD   46.1899728 21.3034969     RO-SITUR RESTAURANT CLASIC 2 - STELE  
45664 45664 CARTEL IMPEX, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   80 10 3.5 ARW 2.8 2.8 344 Mun. Arad ARAD   46.2019114 21.2914272     RO-SITUR RESTAURANT CLASIC 2 - STELE  
45665 45665 CARTURESTI, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 4.6 ARW 0.8 0.8 400 Mun. Arad ARAD   46.1905128 21.320372     RO-SITUR BAR DE ZI 2 - STELE  
45667 45667 CASA NEAMTU, RESTAURANT CU SPECIFIC NAȚIONAL RO eat_drink restaurants restaurant normal 2 star 2 - STELE       0 0 40 0 0   80 0 3.3 ARW 0.9 0.9 412 Mun. Arad ARAD   46.1789728 21.3066053     RO-SITUR RESTAURANT CU SPECIFIC NAȚIONAL 2 - STELE  
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  
45669 45669 CATANGA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 2 star 2 - STELE       0 0 40 0 45   80 0 3.9 ARW 1.9 1.9 401 Mun. Arad ARAD   46.1664915 21.3125355     RO-SITUR BAR DE ZI 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");