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

637 rows where best_for = "banquet", country = "RO" and rating_value = 4

This data as json, CSV (advanced)

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

rating_value 1

group 1

country 1

  • RO · 637 ✖

best_for 1

  • banquet · 637 ✖

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
45498 45498 GEORGIA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 10 24.8 Câmpia Turzii Air Base 0.3 0.3 17 Mun. Aiud ALBA   46.3086633 23.724558     RO-SITUR RESTAURANT CLASIC 4 - STELE  
45535 45535 PRECIOSA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   65 0 50.2 SBZ 0.3 0.3 191 Mun. Alba Iulia ALBA   46.0671371 23.578956     RO-SITUR RESTAURANT CLASIC 4 - STELE  
45639 45639 ANIROC SIGNATURE, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 0 3.8 ARW 1.4 1.4 404 Mun. Arad ARAD   46.1709468 21.3134831     RO-SITUR RESTAURANT CLASIC 4 - STELE  
45651 45651 BOEME CAFE & BISTRO, CAFE-BAR SAU CAFENEA RO eat_drink cafes cafe normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 0 3.7 ARW 1.0 1.0 410 Mun. Arad ARAD   46.1748575 21.3129273     RO-SITUR CAFE-BAR SAU CAFENEA 4 - STELE  
45685 45685 CONTINENTAL, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 0 4.2 ARW 1.0 1.0 408 Mun. Arad ARAD   46.1741356 21.318273     RO-SITUR BAR DE ZI 4 - STELE  
45751 45751 LEON, CAFE-BAR SAU CAFENEA RO eat_drink cafes cafe normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 0 5.8 ARW 1.8 1.8 402 Mun. Arad ARAD   46.1796871 21.3397597     RO-SITUR CAFE-BAR SAU CAFENEA 4 - STELE  
45752 45752 LEON, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 0 5.8 ARW 1.8 1.8 402 Mun. Arad ARAD   46.1796871 21.3397597     RO-SITUR RESTAURANT CLASIC 4 - STELE  
45773 45773 MONDO, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 0 3.9 ARW 0.5 0.5 408 Mun. Arad ARAD   46.1865606 21.3122677     RO-SITUR RESTAURANT CLASIC 4 - STELE  
45852 45852 TEKAFFE, COFETĂRIE RO eat_drink cafes cafe normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 0 4.2 ARW 1.1 1.1 406 Mun. Arad ARAD   46.1734695 21.3182048     RO-SITUR COFETĂRIE 4 - STELE  
45905 45905 VALEA CU PESTI, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   55 0 66.0 SBZ 22.3 0.2 89 Com. Arefu ARGEŞ   45.3333451 24.6357028     RO-SITUR BAR DE ZI 4 - STELE  
45906 45906 VALEA CU PESTI, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   55 0 66.0 SBZ 22.3 0.2 89 Com. Arefu ARGEŞ   45.3333451 24.6357028     RO-SITUR RESTAURANT CLASIC 4 - STELE  
45924 45924 CASA MARIA, RESTAURANT FAMILIAL/PENSIUNE RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   50 0 97.6 CRA 2.3 1.6 124 Com. Bradu ARGEŞ   44.8341697 24.8848827     RO-SITUR RESTAURANT FAMILIAL/PENSIUNE 4 - STELE  
45988 45988 CASA CRISTINA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   45 0 59.1 GHV 34.6 1.9 76 Mun. Câmpulung ARGEŞ   45.2844574 25.0610227     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46030 46030 CORAL, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   50 0 99.1 CRA 1.8 1.8 145 Mun. Piteşti ARGEŞ   44.8646074 24.8772602     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46034 46034 GARNET, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   50 0 99.1 CRA 1.8 1.8 145 Mun. Piteşti ARGEŞ   44.8646074 24.8772602     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46035 46035 GATO, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 50   banquet 0 0 60 0 55   50 0 96.0 CRA 1.4 1.4 141 Mun. Piteşti ARGEŞ   44.8415687 24.8529893     RO-SITUR BAR DE ZI 4  
46043 46043 PRESIDENT, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   40 20 86.2 CRA 11.4 1.6 4 Mun. Piteşti ARGEŞ   44.8026721 24.7384709     RO-SITUR BAR DE ZI 4 - STELE  
46044 46044 PRESIDENT, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   40 20 86.2 CRA 11.4 1.6 4 Mun. Piteşti ARGEŞ   44.8026721 24.7384709     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46048 46048 RUBIN, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   50 0 99.1 CRA 1.8 1.8 145 Mun. Piteşti ARGEŞ   44.8646074 24.8772602     RO-SITUR BAR DE ZI 4 - STELE  
46049 46049 SIERRA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 540   banquet 0 0 80 0 0   50 0 96.0 CRA 1.4 1.4 141 Mun. Piteşti ARGEŞ   44.8415687 24.8529893     RO-SITUR RESTAURANT CLASIC 4  
46054 46054 TWIST, CAFE-BAR SAU CAFENEA RO eat_drink cafes cafe normal 4 star 4 - STELE     banquet 0 0 50 0 0   50 0 99.1 CRA 1.8 1.8 145 Mun. Piteşti ARGEŞ   44.8646074 24.8772602     RO-SITUR CAFE-BAR SAU CAFENEA 4 - STELE  
46056 46056 VICTORIA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   50 0 98.2 CRA 0.7 0.7 142 Mun. Piteşti ARGEŞ   44.8539224 24.8742953     RO-SITUR BAR DE ZI 4 - STELE  
46057 46057 VICTORIA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   50 0 98.2 CRA 0.7 0.7 142 Mun. Piteşti ARGEŞ   44.8539224 24.8742953     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46079 46079 HELEN, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 10 4.3 BCM 3.1 2.5 130 Com. Măgura BACĂU   46.5534109 26.878445     RO-SITUR BAR DE ZI 4 - STELE  
46080 46080 HELEN, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 10 4.3 BCM 3.1 2.5 130 Com. Măgura BACĂU   46.5534109 26.878445     RO-SITUR BAR DE ZI 4 - STELE  
46082 46082 LA TAVERNA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 10 4.3 BCM 3.1 2.5 130 Com. Măgura BACĂU   46.5534109 26.878445     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46083 46083 TAVERNA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 10 4.3 BCM 3.1 2.5 130 Com. Măgura BACĂU   46.5534109 26.878445     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46106 46106 DUMBRAVA BUSINESS RESORT, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 0 4.5 BCM 0.6 0.6 146 Mun. Bacău BACĂU   46.562238 26.911613     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46281 46281 PRESIDENT, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 0 7.9 OMR 8.8 1.9 400 Com. Sânmartin BIHOR   46.9805797 21.9837496     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46301 46301 INTERNATIONAL, BRASERIE SAU BISTROU RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 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 BRASERIE SAU BISTROU 4 - STELE  
46302 46302 INTERNATIONAL, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 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 RESTAURANT CLASIC 4 - STELE  
46361 46361 CAFE CRIŞ, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 10 4.8 OMR 2.5 2.5 375 Mun. Oradea BIHOR   47.0544533 21.948455     RO-SITUR BAR DE ZI 4 - STELE  
46367 46367 CONTINENTAL, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 10 4.5 OMR 2.1 2.1 374 Mun. Oradea BIHOR   47.055657 21.941854     RO-SITUR BAR DE ZI 4 - STELE  
46377 46377 LAURUS, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 10 4.8 OMR 2.5 2.5 376 Mun. Oradea BIHOR   47.0541063 21.9489103     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46378 46378 MAXIM, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 10 4.8 OMR 2.2 2.2 363 Mun. Oradea BIHOR   47.0620087 21.9348834     RO-SITUR BAR DE ZI 4 - STELE  
46379 46379 MAXIM, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 10 4.8 OMR 2.2 2.2 363 Mun. Oradea BIHOR   47.0620087 21.9348834     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46383 46383 MONDO, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 10 4.5 OMR 2.1 2.1 374 Mun. Oradea BIHOR   47.055271 21.942754     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46388 46388 PISCINA CONTINENTAL, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 10 4.5 OMR 2.1 2.1 374 Mun. Oradea BIHOR   47.055657 21.941854     RO-SITUR BAR DE ZI 4 - STELE  
46389 46389 RAMADA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 0 3.5 OMR 1.1 1.1 359 Mun. Oradea BIHOR   47.0556 21.916233     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46400 46400 THE HUB 1, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 0 3.5 OMR 1.1 1.1 359 Mun. Oradea BIHOR   47.0556 21.916233     RO-SITUR BAR DE ZI 4 - STELE  
46401 46401 THE HUB 2, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 0 3.5 OMR 1.1 1.1 359 Mun. Oradea BIHOR   47.0556 21.916233     RO-SITUR BAR DE ZI 4 - STELE  
46431 46431 PANORAMIC COLIBIŢA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   30 0 87.4 TGM 31.1 0.6 69 Com. Bistriţa Bârgăului, Sat Colibiţa BISTRIŢA-NĂSĂUD   47.1776112 24.9056372     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46432 46432 PANORAMIC COLIBIŢA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   30 0 87.4 TGM 31.1 0.6 69 Com. Bistriţa Bârgăului, Sat Colibiţa BISTRIŢA-NĂSĂUD   47.1776112 24.9056372     RO-SITUR BAR DE ZI 4 - STELE  
46486 46486 OZANA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   65 0 74.2 CLJ 1.5 1.5 91 Mun. Bistriţa BISTRIŢA-NĂSĂUD   47.144322 24.510262     RO-SITUR BAR DE ZI 4 - STELE  
46487 46487 OZANA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   65 0 74.2 CLJ 1.5 1.5 91 Mun. Bistriţa BISTRIŢA-NĂSĂUD   47.144322 24.510262     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46492 46492 TERRA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 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 RESTAURANT CLASIC 4 - STELE  
46513 46513 MAJESTIC, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE 400   banquet 0 0 80 0 0   80 0 22.1 SCV 4.0 0.3 50 Com. Curteşti BOTOŞANI   47.7165332 26.6457654     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46526 46526 MARIA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 0 23.6 SCV 1.0 1.0 49 Mun. Botoşani BOTOŞANI   47.743987 26.657523     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46527 46527 MARIA, CAFE-BAR SAU CAFENEA RO eat_drink cafes cafe normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 0 23.6 SCV 1.0 1.0 49 Mun. Botoşani BOTOŞANI   47.743987 26.657523     RO-SITUR CAFE-BAR SAU CAFENEA 4 - STELE  
46529 46529 PISCINA CLUB BAZIN CONSTANTIN, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 0 23.7 SCV 0.8 0.8 49 Mun. Botoşani BOTOŞANI   47.7446532 26.6591075     RO-SITUR BAR DE ZI 4 - STELE  
46535 46535 RAPSODIA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 0 23.9 SCV 0.6 0.6 49 Mun. Botoşani BOTOŞANI   47.7453125 26.6617581     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46571 46571 BOULEVARD, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   65 0 62.4 TCE 0.4 0.4 89 Mun. Brăila BRĂILA   45.274462 27.977106     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46572 46572 EDYS HOUSE, CRAMĂ RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   65 0 63.0 TCE 0.6 0.6 90 Mun. Brăila BRĂILA   45.2717266 27.9669803     RO-SITUR CRAMĂ 4 - STELE  
46573 46573 EDYS HOUSE, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   65 0 63.0 TCE 0.6 0.6 90 Mun. Brăila BRĂILA   45.2717266 27.9669803     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46590 46590 RESET IRISH PUB, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   65 0 62.5 TCE 0.8 0.8 91 Mun. Brăila BRĂILA   45.2647011 27.9700345     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46594 46594 SCUAR BY RESET PIZZA & GRILL, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   65 10 63.1 TCE 2.5 2.5 88 Mun. Brăila BRĂILA   45.252828 27.9556134     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46616 46616 GALERIA BRAN, RESTAURANT CU PROGRAM ARTISTIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 0 27.2 GHV 6.8 0.5 546 Com. Bran BRAŞOV   45.5003388 25.3320077     RO-SITUR RESTAURANT CU PROGRAM ARTISTIC 4 - STELE  
46701 46701 CA LA MAMA DORA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 0 27.6 GHV 6.9 0.9 544 Com. Moieciu, Sat Moieciu de Jos BRAŞOV   45.4991492 25.326995     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46756 46756 ADAGIO, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 0 9.1 GHV 0.5 0.5 1178 Mun. Braşov BRAŞOV   45.6513176 25.6109631     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46763 46763 AMBIENT, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 0 8.6 GHV 0.6 0.6 1175 Mun. Braşov BRAŞOV   45.6486552 25.5983695     RO-SITUR BAR DE ZI 4 - STELE  
46768 46768 ARHIVE, CAFE-BAR SAU CAFENEA RO eat_drink cafes cafe normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 0 8.9 GHV 1.6 1.6 1176 Mun. Braşov BRAŞOV   45.6404045 25.5897718     RO-SITUR CAFE-BAR SAU CAFENEA 4 - STELE  
46772 46772 ARTIS, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 0 8.7 GHV 1.1 1.1 1170 Mun. Braşov BRAŞOV   45.6449623 25.593145     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46776 46776 BALLROOM, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 0 8.5 GHV 1.2 1.2 1175 Mun. Braşov BRAŞOV   45.6453981 25.5910919     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46778 46778 BELVEDERE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 10 8.0 GHV 2.2 2.2 1158 Mun. Braşov BRAŞOV   45.6450749 25.5788229     RO-SITUR BAR DE ZI 4 - STELE  
46779 46779 BELVEDERE, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 10 8.0 GHV 2.2 2.2 1158 Mun. Braşov BRAŞOV   45.6450749 25.5788229     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46787 46787 CASA HIRSCHER, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 0 8.8 GHV 1.5 1.5 1173 Mun. Braşov BRAŞOV   45.6417149 25.5898145     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46796 46796 CASA TUDOR, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 0 7.5 GHV 1.6 1.6 1167 Mun. Braşov BRAŞOV   45.6571273 25.5893403     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46806 46806 COUCHETTE, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 0 8.7 GHV 1.5 1.5 1172 Mun. Braşov BRAŞOV   45.6602196 25.6146831     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46815 46815 EXECUTIVE LOUNGE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 0 8.7 GHV 1.1 1.1 1170 Mun. Braşov BRAŞOV   45.6449623 25.593145     RO-SITUR BAR DE ZI 4 - STELE  
46816 46816 FAVORIT, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 0 8.7 GHV 0.5 0.5 1176 Mun. Braşov BRAŞOV   45.649327 25.6003015     RO-SITUR BAR DE ZI 4 - STELE  
46824 46824 GRAND HOTEL, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 10 13.2 GHV 4.2 4.0 776 Mun. Braşov BRAŞOV   45.615696 25.6330923     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46825 46825 GRAND HOTEL, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 10 13.2 GHV 4.3 4.0 759 Mun. Braşov BRAŞOV   45.6156845 25.6347064     RO-SITUR BAR DE ZI 4 - STELE  
46830 46830 HORIZON, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE 120   banquet 0 0 70 0 0   80 0 8.5 GHV 1.2 1.2 1175 Mun. Braşov BRAŞOV   45.6453981 25.5910919     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46842 46842 LOBBY BAR, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 0 8.7 GHV 1.1 1.1 1170 Mun. Braşov BRAŞOV   45.6449623 25.593145     RO-SITUR BAR DE ZI 4 - STELE  
46846 46846 MARELE ZID, RESTAURANT CU SPECIFIC NAȚIONAL RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 0 8.8 GHV 1.5 1.5 1173 Mun. Braşov BRAŞOV   45.6420176 25.5900137     RO-SITUR RESTAURANT CU SPECIFIC NAȚIONAL 4 - STELE  
46862 46862 PANORAMIC, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 292   banquet 0 0 80 0 0   80 0 9.1 GHV 1.5 1.5 1174 Mun. Braşov BRAŞOV   45.6394198 25.5924023     RO-SITUR RESTAURANT CLASIC 4  
46863 46863 PANORAMIC, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 50   banquet 0 0 60 0 55   80 0 9.1 GHV 1.5 1.5 1174 Mun. Braşov BRAŞOV   45.6394198 25.5924023     RO-SITUR BAR DE ZI 4  
46867 46867 PRALLINI, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 0 8.7 GHV 1.4 1.4 1172 Mun. Braşov BRAŞOV   45.6604267 25.6140594     RO-SITUR BAR DE ZI 4 - STELE  
46869 46869 PRATO, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 0 8.7 GHV 1.3 1.3 1176 Mun. Braşov BRAŞOV   45.6437908 25.5907772     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46886 46886 SERGIANA, RESTAURANT CU SPECIFIC NAȚIONAL RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 0 8.5 GHV 1.3 1.3 1174 Mun. Braşov BRAŞOV   45.6451889 25.5898776     RO-SITUR RESTAURANT CU SPECIFIC NAȚIONAL 4 - STELE  
46888 46888 SERGIANA CENTER, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 0 8.9 GHV 0.6 0.6 1179 Mun. Braşov BRAŞOV   45.6535635 25.6099816     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46898 46898 SWISSOTEL, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 71   banquet 0 0 60 0 0   80 20 13.2 GHV 7.8 5.4 219 Mun. Braşov BRAŞOV   45.588846 25.5537933     RO-SITUR RESTAURANT CLASIC 4  
46899 46899 SWISSOTEL, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 9   banquet 0 0 50 0 45   80 20 13.2 GHV 7.8 5.4 219 Mun. Braşov BRAŞOV   45.588846 25.5537933     RO-SITUR BAR DE ZI 4  
46904 46904 THE VINTAGE PUB, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 0 8.7 GHV 1.1 1.1 1170 Mun. Braşov BRAŞOV   45.6451496 25.5930093     RO-SITUR BAR DE ZI 4 - STELE  
46905 46905 THE VINTAGE PUB, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 0 8.7 GHV 1.1 1.1 1170 Mun. Braşov BRAŞOV   45.6451496 25.5930093     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46910 46910 ACASA LA DRACULA, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 20 12.4 GHV 6.7 5.1 287 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.5969445 25.5609009     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46911 46911 ACASA LA DRACULA, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 20 12.4 GHV 6.7 5.1 287 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.5969445 25.5609009     RO-SITUR BAR DE ZI 4 - STELE  
46913 46913 ALTITUDE, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 20 12.7 GHV 7.3 5.5 243 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.5935681 25.5549924     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46915 46915 ATHRIUM LOUNGE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 45   banquet 0 0 60 0 45   80 20 12.4 GHV 7.3 5.8 250 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.5955044 25.5513291     RO-SITUR BAR DE ZI 4  
46924 46924 CASA VIOREL, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 20 12.4 GHV 6.6 5.1 297 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.597786 25.5619193     RO-SITUR BAR DE ZI 4 - STELE  
46928 46928 CIGAR LOUNGE, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 20 12.4 GHV 7.2 5.8 252 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.5962808 25.5512779     RO-SITUR BAR DE ZI 4 - STELE  
46933 46933 ESCALADE 2, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 20 12.2 GHV 7.0 5.8 266 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.5977233 25.5523932     RO-SITUR BAR DE ZI 4 - STELE  
46934 46934 ESCALADE 2, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 20 12.2 GHV 7.0 5.8 266 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.5977233 25.5523932     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46935 46935 FAVORIT - BOWLING, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 20 12.4 GHV 7.3 5.8 250 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.5955044 25.5513291     RO-SITUR BAR DE ZI 4 - STELE  
46936 46936 FOREST, RESTAURANT CU SPECIFIC NAȚIONAL RO eat_drink restaurants restaurant normal 4 star 4 20   banquet 0 0 50 0 0   80 20 12.4 GHV 7.4 6.0 244 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.5954554 25.5489389     RO-SITUR RESTAURANT CU SPECIFIC NAȚIONAL 4  
46937 46937 LOBBY BAR SPORT, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 20 12.7 GHV 7.3 5.5 243 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.5935681 25.5549924     RO-SITUR BAR DE ZI 4 - STELE  
46939 46939 MIRAJ, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 20 12.1 GHV 6.7 5.5 293 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.5990582 25.5573974     RO-SITUR RESTAURANT CLASIC 4 - STELE  
46940 46940 MIRAJ, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 20 12.1 GHV 6.7 5.5 293 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.5990582 25.5573974     RO-SITUR BAR DE ZI 4 - STELE  
46941 46941 MIRAJ, BAR DE ZI RO eat_drink bars_pubs bar_pub normal 4 star 4 - STELE     banquet 0 0 50 0 45   80 20 12.1 GHV 6.7 5.5 293 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.5990582 25.5573974     RO-SITUR BAR DE ZI 4 - STELE  
46942 46942 MIRAJ, RESTAURANT CLASIC RO eat_drink restaurants restaurant normal 4 star 4 - STELE     banquet 0 0 50 0 0   80 20 12.1 GHV 6.7 5.5 293 Mun. Braşov, Loc. Poiana Braşov BRAŞOV   45.5990582 25.5573974     RO-SITUR RESTAURANT CLASIC 4 - 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");