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,864 rows where country = "ME" and family = "bars_pubs"

This data as json, CSV (advanced)

Suggested facets: venue_type, rating_scheme, rating_label, fit_banquet, fit_party, reachability_score, isolation_score, airport_km, nearest_airport, city_km, town_km, venues_5km, municipality, lat, lng, source_type, source_category

rating_value 3

best_for 2

group 1

family 1

  • bars_pubs · 1,864 ✖

country 1

  • ME · 1,864 ✖

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
758881 758881 PUSTI LISAC ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.6 TIV 0.8 0.8 288   CETINJE   42.391 18.924     ME-CTR Bar    
758882 758882 Malia ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   65 0 44.8 TIV 0.0 0.0 511   NIKŠIĆ   42.773 18.944     ME-CTR Bar    
758888 758888 coffein ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.0 0.0 2416   HERCEG NOVI   42.453 18.538     ME-CTR Bar    
762589 762589 USLUGE SMJEŠTAJA ŠKRIJELJ ME eat_drink bars_pubs bar_pub normal 3 star 3***       0 0 40 0 45   55 0 47.9 TGD 21.0 0.0 2653   ULCINJ   41.929 19.224     ME-CTR Bar 3***  
764054 764054 "Bistro bar Amići" ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   65 0 44.8 TIV 0.0 0.0 511   NIKŠIĆ   42.773 18.944     ME-CTR Bar    
766525 766525 bifrost ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Bar    
766526 766526 NAPOLEON ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   65 0 31.8 TGD 0.3 0.3 2461   BAR   42.096 19.1     ME-CTR Bar    
766527 766527 CAFE BAR ARKA PUB ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   65 0 31.8 TGD 0.3 0.3 2461   BAR   42.096 19.1     ME-CTR Bar    
766544 766544 Štala kafe ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   30 0 81.0 DBV 43.4 0.5 146   PLUŽINE   43.156 18.841     ME-CTR Bar    
766549 766549 COFFEE MONKEY ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Bar    
766550 766550 AZZUR ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Bar    
766551 766551 grbalj ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Bar    
766554 766554 gral ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Bar    
766555 766555 SEA KING ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Bar    
766556 766556 21B ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Bar    
766557 766557 "Brick pub" ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   65 0 44.8 TIV 0.0 0.0 511   NIKŠIĆ   42.773 18.944     ME-CTR Bar    
766562 766562 plaža čejović ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Bar    
766572 766572 KB ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Bar    
766573 766573 CAFFE MONTENEGRO ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Bar    
766574 766574 ice club mb ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Bar    
766585 766585 tequila bar ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Bar    
766587 766587 park ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.0 0.0 2416   HERCEG NOVI   42.453 18.538     ME-CTR Bar    
766588 766588 tri šešira ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.0 0.0 2416   HERCEG NOVI   42.453 18.538     ME-CTR Bar    
766590 766590 ZIG ZAG ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Bar    
766592 766592 toggy hookan & bar ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Bar    
766593 766593 my place is your place ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Bar    
766594 766594 SYDNEY PUB ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Bar    
766595 766595 NORTH COFFEE SHOP ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Bar    
766598 766598 caffe petrol ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Bar    
766599 766599 EXCLUSIVE CLUB-SAN REMO ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Bar    
766601 766601 RAVENITE ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Bar    
766602 766602 BELLAMI ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Bar    
766607 766607 BISTRO ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Bar    
766610 766610 2 R ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   65 0 44.8 TIV 0.0 0.0 511   NIKŠIĆ   42.773 18.944     ME-CTR Bar    
766612 766612 LA FAMILIA ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Bar    
766613 766613 jeff ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Bar    
766614 766614 B5 ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Bar    
766615 766615 jedro ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Bar    
766616 766616 AMERICAN PUB ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Bar    
766626 766626 old town pub ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Bar    
766635 766635 AVLIJA ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Bar    
766641 766641 4 BARRELS CRAFT BEER PUB ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Bar    
766642 766642 E BAR ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Bar    
766643 766643 PIKOLO ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Bar    
766651 766651 PROMENADA ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Bar    
766652 766652 PROMENADA ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Bar    
766664 766664 HAPPY KIDS ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Bar    
766665 766665 kafe bar-catering gatto ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.0 0.0 2416   HERCEG NOVI   42.453 18.538     ME-CTR Bar    
766670 766670 THE GARRISON ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Bar    
766672 766672 "SKVER" ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   65 0 44.8 TIV 0.0 0.0 511   NIKŠIĆ   42.773 18.944     ME-CTR Bar    
766673 766673 KROPKA ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Bar    
766675 766675 GREEN CAFFE ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Bar    
766681 766681 ZORA ZABJELO ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Bar    
766682 766682 ALTER EGO ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Bar    
766683 766683 FENIX-T ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Bar    
766684 766684 AMITY ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Bar    
766685 766685 AGRENTO ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Bar    
766690 766690 JAZZVA LOUNGE ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Bar    
766691 766691 T I M ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Bar    
766692 766692 CAFFEE SHOP CAFFEINE ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Bar    
766699 766699 HIDEOUT ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Bar    
766709 766709 DIKO ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   65 0 66.1 UZC 0.1 0.1 191   PLJEVLJA   43.357 19.359     ME-CTR Bar    
766714 766714 STARI PLATAN 1326 ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Bar    
766715 766715 IRISH PUB DUBLIN ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Bar    
766719 766719 DUBLIN PUB ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   65 0 31.8 TGD 0.3 0.3 2461   BAR   42.096 19.1     ME-CTR Bar    
766729 766729 HOOPER`S SPORT CAFE ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Bar    
766730 766730 ART GALERIJA I KAFE ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Bar    
766745 766745 PICCOLO ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   55 0 47.9 TGD 21.0 0.0 2653   ULCINJ   41.929 19.224     ME-CTR Bar    
766767 766767 VERSE LOUNGE BAR ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Bar    
766782 766782 CHILL OUT ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Bar    
766788 766788 KAFE BAR TOMICA ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Bar    
766790 766790 ADMIRAL KLUB ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Bar    
766793 766793 "SPORTSKI BIFE" ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   55 0 73.7 TGD 23.8 0.4 234   BERANE   42.843 19.868     ME-CTR Bar    
766803 766803 JOLLY $ ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Bar    
766833 766833 lumbrella ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Bar    
766836 766836 KOD CACI ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Bar    
766837 766837 KUĆA ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Bar    
766838 766838 RAKIJA AND WINE BAR ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Bar    
766843 766843 "TIME-OUT" ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   55 0 73.7 TGD 23.8 0.4 234   BERANE   42.843 19.868     ME-CTR Bar    
766845 766845 "HYPE" ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   55 0 73.7 TGD 23.8 0.4 234   BERANE   42.843 19.868     ME-CTR Bar    
766848 766848 CAFE BAR ENERGY ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Bar    
766850 766850 BEACH BAR ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Bar    
766851 766851 caffe bar BOLERO ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   65 0 66.1 UZC 0.1 0.1 191   PLJEVLJA   43.357 19.359     ME-CTR Bar    
766854 766854 HOLIDAY 21 ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Bar    
766855 766855 POD MURVOM ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Bar    
766856 766856 kamenovo beach ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Bar    
766857 766857 san trope ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Bar    
766859 766859 BELLA VISTA ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Bar    
766860 766860 MADEMOISELLEQ ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Bar    
766862 766862 VENI VIDI VICI ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   65 0 44.8 TIV 0.0 0.0 511   NIKŠIĆ   42.773 18.944     ME-CTR Bar    
766865 766865 PLAŽNI BAR ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Bar    
766867 766867 NARGILA BAR ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Bar    
766868 766868 DOLCE VITA ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Bar    
766869 766869 GALATA II ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Bar    
766871 766871 ARENA ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Bar    
766872 766872 GRAL ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Bar    
766873 766873 CASPER ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Bar    
766880 766880 WALL STREET ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Bar    
766881 766881 CBR ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Bar    
766882 766882 BOCUN ME eat_drink bars_pubs bar_pub normal   none         0 0 40 0 45   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Bar    

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");