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

This data as json, CSV (advanced)

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

family 4

best_for 2

rating_value 1

  • 3 · 3,950 ✖

group 1

  • eat_drink · 3,950 ✖

country 1

  • RO · 3,950 ✖

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
45446 45446 PERLA APUSENILOR, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   45 0 68.3 CLJ 36.9 1.1 30 Com. Albac, Sat Pleşeşti ALBA   46.4469616 22.9399791     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 3 - STELE  
45448 45448 CASA MOTULUI, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   30 0 80.4 CLJ 38.7 1.9 86 Com. Arieşeni ALBA   46.4795259 22.7324206     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45449 45449 GIANINA, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   45 0 79.0 CLJ 38.3 0.2 94 Com. Arieşeni ALBA   46.4767851 22.7543707     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 3 - STELE  
45450 45450 SARRA VANK, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   45 0 79.0 CLJ 38.3 0.2 94 Com. Arieşeni ALBA   46.4767851 22.7543707     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45452 45452 TAVERNA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   45 0 79.0 CLJ 38.3 0.2 94 Com. Arieşeni ALBA   46.4767851 22.7543707     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45456 45456 BLEUMARIN, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   55 30 39.8 Câmpia Turzii Air Base 14.0 2.9 5 Com. Galda de Jos ALBA   46.1816893 23.6566509     RO-SITUR BAR DE ZI 3 - STELE  
45457 45457 BLEUMARIN, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   55 30 39.8 Câmpia Turzii Air Base 14.0 2.9 5 Com. Galda de Jos ALBA   46.1816893 23.6566509     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45459 45459 FLOARE DE COLŢ, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   55 30 39.8 Câmpia Turzii Air Base 16.6 4.4 3 Com. Galda de Jos, Sat Poiana Galdei ALBA   46.2433979 23.527937     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45460 45460 CASA BUNĂ, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   55 20 33.2 SBZ 12.9 2.1 7 Com. Gârbova ALBA   45.8650605 23.674016     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45462 45462 CONACUL SAMFIREI, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   45 0 73.7 CLJ 36.4 1.0 34 Com. Gârda de Sus ALBA   46.4579234 22.8470327     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45463 45463 MAMA UŢA, RESTAURANT CU SPECIFIC NAȚIONAL RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   45 0 76.6 CLJ 36.0 1.2 70 Com. Gârda de Sus ALBA   46.4568635 22.805182     RO-SITUR RESTAURANT CU SPECIFIC NAȚIONAL 3 - STELE  
45465 45465 ONELIA, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   45 0 76.8 CLJ 36.0 1.3 70 Com. Gârda de Sus ALBA   46.4563802 22.8022573     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 3 - STELE  
45467 45467 LA VIE, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   45 10 75.1 CLJ 39.6 3.7 76 Com. Gârda de Sus, Sat Izvoarele ALBA   46.4888357 22.8028004     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45469 45469 COTA 1600 PETREASA, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   45 10 63.2 CLJ 46.4 3.8 29 Com. Horea, Sat Petreasa ALBA   46.5361053 22.9424224     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 3 - STELE  
45471 45471 CASTEL TEMPLUL CAVALERILOR, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   80 20 25.9 Câmpia Turzii Air Base 8.0 0.2 3 Com. Livezile, Sat Livezile ALBA   46.3479534 23.631976     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45472 45472 CASA APUSEANA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   45 20 54.1 Câmpia Turzii Air Base 40.1 0.6 4 Com. Lupşa ALBA   46.3690965 23.2063265     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45473 45473 GALAXY, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   45 20 54.1 Câmpia Turzii Air Base 40.1 0.6 4 Com. Lupşa ALBA   46.3690965 23.2063265     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45481 45481 CONACUL SECUIESC I, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   70 0 26.1 Câmpia Turzii Air Base 17.5 0.2 42 Com. Rimetea ALBA   46.4241956 23.5641929     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 3 - STELE  
45482 45482 PERLA TRASCĂULUI, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   70 10 23.5 Câmpia Turzii Air Base 18.0 3.9 37 Com. Rimetea ALBA   46.4839922 23.5806213     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45483 45483 CODRU, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   55 10 36.9 Câmpia Turzii Air Base 24.7 0.5 9 Com. Sălciua ALBA   46.4000233 23.4275147     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45487 45487 MARTINI, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE 140   banquet 0 0 60 0 0   65 10 42.5 SBZ 7.3 0.6 8 Com. Săsciori, Sat Sebeşel ALBA   45.8915553 23.559796     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45488 45488 OLIMPIC, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   55 20 31.6 SBZ 13.4 0.1 4 Com. Şpring ALBA   45.9380803 23.7420489     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45490 45490 NEDEI HOTEL&SPA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   55 10 36.6 SBZ 18.0 0.6 19 Com. Şugag ALBA   45.7973968 23.6148127     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45492 45492 SF. PETRU, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   55 40 48.9 SBZ 17.2 15.5 8 Com. Şugag ALBA   45.5838755 23.527565     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45493 45493 SF. PETRU, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   55 40 48.9 SBZ 17.2 15.5 8 Com. Şugag ALBA   45.5838755 23.527565     RO-SITUR BAR DE ZI 3 - STELE  
45495 45495 COLŢ DIN RAI, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   55 40 49.1 SBZ 17.2 15.5 8 Com. Şugag, Sat Tău Bistra ALBA   45.5861587 23.5222225     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 3 - STELE  
45501 45501 TRANSILVANIA CASA ŞI MASA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   80 10 25.6 Câmpia Turzii Air Base 0.8 0.8 17 Mun. Aiud ALBA   46.3045497 23.7152587     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45502 45502 WINE&SIMPHONY RESORT, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 stele 180   banquet 0 0 70 0 0   80 10 23.1 Câmpia Turzii Air Base 3.6 0.6 17 Mun. Aiud, Sat Ciumbrud ALBA   46.3112094 23.7680104     RO-SITUR RESTAURANT CLASIC 3 stele  
45503 45503 WINE&SIMPHONY RESORT, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 stele 20     0 0 40 0 45   80 10 23.1 Câmpia Turzii Air Base 3.6 0.6 17 Mun. Aiud, Sat Ciumbrud ALBA   46.3112094 23.7680104     RO-SITUR BAR DE ZI 3 stele  
45504 45504 ASTORIA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   65 0 49.9 SBZ 0.9 0.9 191 Mun. Alba Iulia ALBA   46.0598655 23.5766037     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45506 45506 CASA TRAIANA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   65 0 51.3 SBZ 2.2 1.5 182 Mun. Alba Iulia ALBA   46.0861184 23.5832981     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45509 45509 CETATE, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 184   banquet 0 0 70 0 0   65 0 51.0 SBZ 1.1 1.1 191 Mun. Alba Iulia ALBA   46.0699016 23.5696515     RO-SITUR RESTAURANT CLASIC 3  
45510 45510 CROWN ROYAL, BRASERIE SAU BISTROU RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   65 0 51.2 SBZ 1.8 1.8 185 Mun. Alba Iulia ALBA   46.0823356 23.579963     RO-SITUR BRASERIE SAU BISTROU 3 - STELE  
45511 45511 EAGLE RAY, RESTAURANT CU SPECIFIC NAȚIONAL RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   65 0 49.9 SBZ 0.1 0.1 191 Mun. Alba Iulia ALBA   46.0662255 23.5832138     RO-SITUR RESTAURANT CU SPECIFIC NAȚIONAL 3 - STELE  
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  
45513 45513 ELISABETA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   65 0 52.7 Câmpia Turzii Air Base 2.9 1.7 167 Mun. Alba Iulia ALBA   46.0859029 23.5584424     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45514 45514 ELISABETA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   65 0 52.6 Câmpia Turzii Air Base 2.7 1.8 167 Mun. Alba Iulia ALBA   46.0860794 23.5617206     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45517 45517 HANUL CU BERZE, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   65 0 49.5 SBZ 3.3 0.9 159 Mun. Alba Iulia ALBA   46.0412652 23.5623064     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45519 45519 HERMES, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   65 10 51.9 SBZ 2.1 2.1 169 Mun. Alba Iulia ALBA   46.0753981 23.5595508     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45520 45520 LA MAISON DE CAROLINE, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 STELE 40   banquet 0 0 50 0 0   65 0 50.1 SBZ 0.4 0.4 191 Mun. Alba Iulia ALBA   46.0700226 23.5840516     RO-SITUR RESTAURANT CLASIC 3 STELE  
45521 45521 LA MAISON DE CAROLINE, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 STELE 1     0 0 40 0 0   65 0 50.1 SBZ 0.4 0.4 191 Mun. Alba Iulia ALBA   46.0700226 23.5840516     RO-SITUR RESTAURANT CLASIC 3 STELE  
45522 45522 LA UNCHIUL NICKY, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   65 0 50.5 SBZ 0.8 0.8 191 Mun. Alba Iulia ALBA   46.0732725 23.5804886     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45524 45524 MARISS, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   65 0 50.5 SBZ 0.8 0.8 191 Mun. Alba Iulia ALBA   46.0732725 23.5804886     RO-SITUR RESTAURANT CLASIC 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  
45526 45526 MERCURE ALBA IULIA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 150   banquet 0 0 70 0 0   65 0 50.0 SBZ 0.7 0.7 191 Mun. Alba Iulia ALBA   46.0621519 23.5765002     RO-SITUR RESTAURANT CLASIC 3  
45527 45527 MERCURE ALBA IULIA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 5     0 0 40 0 45   65 0 50.1 SBZ 0.8 0.8 191 Mun. Alba Iulia ALBA   46.0623621 23.5755425     RO-SITUR BAR DE ZI 3  
45528 45528 MIURA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 44   banquet 0 0 50 0 0   65 0 50.7 SBZ 0.8 0.8 191 Mun. Alba Iulia ALBA   46.0688610634541 23.5731972226845     RO-SITUR RESTAURANT CLASIC 3  
45529 45529 NEPTUN, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   65 0 49.7 SBZ 1.2 1.2 172 Mun. Alba Iulia ALBA   46.0570317 23.5764588     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45530 45530 NOVA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   65 0 50.3 SBZ 0.4 0.4 191 Mun. Alba Iulia ALBA   46.0681867 23.5780252     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45531 45531 NOVA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   65 0 50.3 SBZ 0.4 0.4 191 Mun. Alba Iulia ALBA   46.0681867 23.5780252     RO-SITUR BAR DE ZI 3 - STELE  
45532 45532 PARC, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   65 0 50.2 SBZ 0.3 0.3 191 Mun. Alba Iulia ALBA   46.0691429 23.581314     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45533 45533 PARC, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   65 0 50.2 SBZ 0.3 0.3 191 Mun. Alba Iulia ALBA   46.0691429 23.581314     RO-SITUR BAR DE ZI 3 - STELE  
45534 45534 PENSIUNEA MA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   65 0 51.2 SBZ 2.2 1.5 182 Mun. Alba Iulia ALBA   46.0862059 23.5839806     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45536 45536 SALA ARMELOR, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   65 0 50.6 SBZ 0.9 0.9 191 Mun. Alba Iulia ALBA   46.0671679 23.5722201     RO-SITUR BAR DE ZI 3 - STELE  
45539 45539 SELECT, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   65 0 49.5 SBZ 4.4 0.9 134 Mun. Alba Iulia ALBA   46.0327439 23.5544652     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45540 45540 SELECT, CRAMĂ RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   65 0 49.5 SBZ 4.4 0.9 134 Mun. Alba Iulia ALBA   46.0327439 23.5544652     RO-SITUR CRAMĂ 3 - STELE  
45542 45542 STEAUA NORDULUI, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   65 0 51.8 SBZ 2.0 2.0 184 Mun. Alba Iulia ALBA   46.0809587 23.5679724     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45545 45545 TRANSILVANIA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   65 0 50.3 SBZ 0.6 0.6 191 Mun. Alba Iulia ALBA   46.0716803 23.582319     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45546 45546 TRANSILVANIA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   65 0 50.3 SBZ 0.6 0.6 191 Mun. Alba Iulia ALBA   46.0716803 23.582319     RO-SITUR BAR DE ZI 3 - STELE  
45550 45550 MAN PRESIDENT, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   65 0 36.6 Câmpia Turzii Air Base 0.7 0.5 28 Mun. Blaj ALBA   46.1735298 23.9073741     RO-SITUR BAR DE ZI 3 - STELE  
45552 45552 PARADISUL TRANSILVANIEI, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   65 0 33.9 Câmpia Turzii Air Base 3.7 0.2 26 Mun. Blaj ALBA   46.2002006 23.9470361     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45553 45553 PARADISUL TRANSILVANIEI, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   65 0 33.9 Câmpia Turzii Air Base 3.7 0.2 26 Mun. Blaj ALBA   46.2002006 23.9470361     RO-SITUR BAR DE ZI 3 - STELE  
45555 45555 TAVERNA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - 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 3 - STELE  
45556 45556 LA VIE, CRAMĂ RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   65 0 37.1 Câmpia Turzii Air Base 1.1 0.1 28 Mun. Blaj, Loc. Izvoarele ALBA   46.1690262 23.904278     RO-SITUR CRAMĂ 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  
45558 45558 ALLEGRIA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   65 0 46.7 SBZ 3.4 0.2 32 Mun. Sebeş ALBA   45.9849776 23.5554968     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45559 45559 CLASIC, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   65 0 44.7 SBZ 0.5 0.5 33 Mun. Sebeş ALBA   45.9595588 23.5663758     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45560 45560 CLASIC, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   65 0 43.4 SBZ 0.8 0.8 30 Mun. Sebeş ALBA   45.9528829 23.5803278     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45562 45562 LEUL DE AUR, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   65 0 44.6 SBZ 0.4 0.4 33 Mun. Sebeş ALBA   45.9573216 23.5665329     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45563 45563 RYN, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   65 0 45.6 SBZ 1.4 1.4 33 Mun. Sebeş ALBA   45.9599339 23.553387     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 3 - STELE  
45564 45564 BOEMA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   65 0 47.5 SBZ 4.4 0.9 35 Mun. Sebeş, Loc. Lancrăm ALBA   45.9938147 23.5502981     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45565 45565 REICHAU TRANSILVANIA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   65 0 46.8 SBZ 3.5 0.1 32 Mun. Sebeş, Sat Răhău ALBA   45.9863892 23.5553295     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45566 45566 CASA DOMENIILE VINULUI, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   80 10 23.9 Câmpia Turzii Air Base 3.3 0.4 17 Oraş Abrud ALBA   46.3046369 23.7630726     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 3 - STELE  
45568 45568 FILONUL DE AUR, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   55 10 67.1 Câmpia Turzii Air Base 27.3 1.9 14 Oraş Abrud ALBA   46.2642446 23.0827721     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45569 45569 SILINEL TURIST, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   55 10 67.0 Câmpia Turzii Air Base 27.3 1.8 14 Oraş Abrud ALBA   46.2644518 23.0830242     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 3 - STELE  
45571 45571 BALEA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   45 10 65.5 Câmpia Turzii Air Base 33.0 0.6 17 Oraş Câmpeni ALBA   46.363137 23.0553594     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45573 45573 RIVALY, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 78   banquet 0 0 50 0 0   55 0 41.9 GHV 13.4 0.4 206 Oraş Câmpeni ALBA   45.730116 24.983845     RO-SITUR RESTAURANT CLASIC 3  
45576 45576 PERLA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   65 20 54.2 SBZ 2.3 2.3 7 Oraş Cugir ALBA   45.8213808 23.3894353     RO-SITUR RESTAURANT CLASIC 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  
45595 45595 LACUL LINIŞTIT, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   45 0 68.4 OMR 54.1 1.9 36 Com. Moneasa ARAD   46.4630007 22.2654462     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45597 45597 PANORAMIC, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   45 0 68.3 OMR 54.3 1.5 36 Com. Moneasa ARAD   46.4617702 22.259481     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45598 45598 PARC, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   45 0 68.3 OMR 54.3 1.5 36 Com. Moneasa ARAD   46.4617702 22.259481     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45599 45599 PARC, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   45 0 68.3 OMR 54.3 1.5 36 Com. Moneasa ARAD   46.4617702 22.259481     RO-SITUR BAR DE ZI 3 - STELE  
45600 45600 SANTANA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - 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 3 - STELE  
45605 45605 CONACUL DE PE LAC, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   70 20 13.0 ARW 14.0 1.1 2 Com. Şagu ARAD   46.0597281 21.2840562     RO-SITUR RESTAURANT CLASIC 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  
45612 45612 LA FORESTERIA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - 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 3 - STELE  
45615 45615 AGROVILLAGE, CLUB SAU DISCO-BAR RO eat_drink bars_pubs nightclub normal 3 star 3 - STELE     party 0 0 40 0 60   45 30 39.2 TSR 31.6 7.6 6 Com. Şiştarovăţ ARAD   45.96272 21.794351     RO-SITUR CLUB SAU DISCO-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  
45631 45631 ACTIV CLUB - BLUE ARCTIC, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 10 5.3 ARW 2.4 2.4 387 Mun. Arad ARAD   46.1644716 21.3308937     RO-SITUR BAR DE ZI 3 - STELE  
45632 45632 AKADEMOS, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 0 3.5 ARW 1.5 1.5 403 Mun. Arad ARAD   46.1707836 21.3096421     RO-SITUR BAR DE ZI 3 - STELE  
45633 45633 AKADEMOS, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   80 0 3.5 ARW 1.5 1.5 403 Mun. Arad ARAD   46.1707836 21.3096421     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45637 45637 ANA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   80 10 6.7 ARW 2.7 2.7 392 Mun. Arad ARAD   46.1790234 21.3511016     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45640 45640 ANIROC SIGNATURE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 0 3.8 ARW 1.4 1.4 404 Mun. Arad ARAD   46.1709468 21.3134831     RO-SITUR BAR DE ZI 3 - STELE  
45641 45641 ARAD, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   80 0 4.2 ARW 1.1 1.1 406 Mun. Arad ARAD   46.1731963 21.3189087     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45645 45645 BARRIO, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   80 0 4.6 ARW 0.5 0.5 410 Mun. Arad ARAD   46.1821931 21.3236329     RO-SITUR RESTAURANT CLASIC 3 - STELE  
45647 45647 BEST WESTERN CENTRAL, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 0 4.0 ARW 0.8 0.8 411 Mun. Arad ARAD   46.1762734 21.316574     RO-SITUR BAR DE ZI 3 - STELE  
45648 45648 BEST WESTERN CENTRAL, CRAMĂ RO eat_drink bars_pubs bar_pub normal 3 star 3 - STELE       0 0 40 0 45   80 0 4.0 ARW 0.8 0.8 411 Mun. Arad ARAD   46.1762734 21.316574     RO-SITUR CRAMĂ 3 - STELE  
45649 45649 BEST WESTERN CENTRAL, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 3 star 3 - STELE       0 0 40 0 0   80 0 4.0 ARW 0.8 0.8 411 Mun. Arad ARAD   46.1762734 21.316574     RO-SITUR RESTAURANT CLASIC 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");