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

197 rows where country = "ME" and family = "cafes"

This data as json, CSV (advanced)

Suggested facets: reachability_score, isolation_score, airport_km, nearest_airport, city_km, town_km, venues_5km, municipality, lat, lng, source_type

group 1

family 1

  • cafes · 197 ✖

country 1

  • ME · 197 ✖

rating_value 0

common_areas 0

best_for 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
760512 760512 OSTOJIĆ ALEKSA ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 31.8 TGD 0.3 0.3 2461   BAR   42.096 19.1     ME-CTR Kafić    
766617 766617 autobuska stanica ME eat_drink cafes cafe normal   none         0 0 40 0 0   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Poslastičarnica    
766618 766618 expres restoran ME eat_drink cafes cafe normal   none         0 0 40 0 0   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Poslastičarnica    
766624 766624 RUŠTULA ME eat_drink cafes cafe normal   none         0 0 40 0 0   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Poslastičarnica    
766666 766666 FONTANA 7 ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 44.8 TIV 0.0 0.0 511   NIKŠIĆ   42.773 18.944     ME-CTR Poslastičarnica    
766676 766676 C VIZ ME eat_drink cafes cafe normal   none         0 0 40 0 0   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Poslastičarnica    
766697 766697 CALYPSO ME eat_drink cafes cafe normal   none         0 0 40 0 0   30 0 81.0 DBV 43.4 0.5 146   PLUŽINE   43.156 18.841     ME-CTR Kafić    
766789 766789 SUR MIMOZA ME eat_drink cafes cafe normal   none         0 0 40 0 0   55 0 77.0 PRN 22.6 0.8 98   ROŽAJE   42.842 20.167     ME-CTR Poslastičarnica    
766901 766901 VILA MANOJLOVIĆ ME eat_drink cafes cafe normal   none         0 0 40 0 0   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Poslastičarnica    
767038 767038 kafe poslastičarnica NOVI CAPRI ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 66.1 UZC 0.1 0.1 191   PLJEVLJA   43.357 19.359     ME-CTR Poslastičarnica    
767261 767261 TRI SLATKIŠA ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 31.8 TGD 0.3 0.3 2461   BAR   42.096 19.1     ME-CTR Poslastičarnica    
767271 767271 CAFFE GRIL GOOD FOOD ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 31.8 TGD 0.3 0.3 2461   BAR   42.096 19.1     ME-CTR Kafić    
767305 767305 CAFFE IGRAONICA DVORIŠTE ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 31.8 TGD 0.3 0.3 2461   BAR   42.096 19.1     ME-CTR Kafić    
767308 767308 CAFFE GRILL PARILLA ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 31.8 TGD 0.3 0.3 2461   BAR   42.096 19.1     ME-CTR Kafić    
767328 767328 MORITZ EIS ME eat_drink cafes cafe normal   none         0 0 40 0 0   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Poslastičarnica    
767375 767375 MINJONAK ME eat_drink cafes cafe normal   none         0 0 40 0 0   70 0 4.1 TIV 13.1 0.2 1279   TIVAT   42.436 18.696     ME-CTR Poslastičarnica    
767383 767383 MA CHERIE ME eat_drink cafes cafe normal   none         0 0 40 0 0   70 0 4.1 TIV 13.1 0.2 1279   TIVAT   42.436 18.696     ME-CTR Poslastičarnica    
767410 767410 BOEM ME eat_drink cafes cafe normal   none         0 0 40 0 0   70 0 6.5 TGD 10.1 0.1 74   TUZI   42.365 19.331     ME-CTR Poslastičarnica    
767469 767469 poslastičarnica FRANCA ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 66.1 UZC 0.1 0.1 191   PLJEVLJA   43.357 19.359     ME-CTR Poslastičarnica    
767536 767536 AUTOBUSKA STANICA ME eat_drink cafes cafe normal   none         0 0 40 0 0   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Poslastičarnica    
767537 767537 EXPRES RESTORAN ME eat_drink cafes cafe normal   none         0 0 40 0 0   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Poslastičarnica    
767554 767554 ČAROLIJA ME eat_drink cafes cafe normal   none         0 0 40 0 0   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Poslastičarnica    
767630 767630 AMICI ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 31.8 TGD 0.3 0.3 2461   BAR   42.096 19.1     ME-CTR Kafić    
767631 767631 CAFFE KORNI ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 31.8 TGD 0.3 0.3 2461   BAR   42.096 19.1     ME-CTR Poslastičarnica    
767643 767643 RESTORAN"RIVA" ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 31.8 TGD 0.3 0.3 2461   BAR   42.096 19.1     ME-CTR Kafić    
767646 767646 OSTOJIĆ ALEKSA ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 31.8 TGD 0.3 0.3 2461   BAR   42.096 19.1     ME-CTR Kafić    
767647 767647 CAFFE BAR LOVĆEN ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 31.8 TGD 0.3 0.3 2461   BAR   42.096 19.1     ME-CTR Kafić    
767678 767678 CITY CAFFE ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 31.8 TGD 0.3 0.3 2461   BAR   42.096 19.1     ME-CTR Kafić    
767690 767690 ERCIYES ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 31.8 TGD 0.3 0.3 2461   BAR   42.096 19.1     ME-CTR Kafić    
767691 767691 ERCIYES ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 31.8 TGD 0.3 0.3 2461   BAR   42.096 19.1     ME-CTR Kafić    
767692 767692 CAFFE BAR MM ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 31.8 TGD 0.3 0.3 2461   BAR   42.096 19.1     ME-CTR Kafić    
767693 767693 CAFFE BAR MM ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 31.8 TGD 0.3 0.3 2461   BAR   42.096 19.1     ME-CTR Kafić    
767703 767703 CAFFE BAR SKANDAL ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 31.8 TGD 0.3 0.3 2461   BAR   42.096 19.1     ME-CTR Kafić    
767807 767807 PČELA ME eat_drink cafes cafe normal   none         0 0 40 0 0   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Poslastičarnica    
767891 767891 PALMA ME eat_drink cafes cafe normal   none         0 0 40 0 0   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Poslastičarnica    
767917 767917 MORITZ EIS ME eat_drink cafes cafe normal   none         0 0 40 0 0   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Poslastičarnica    
767928 767928 LOUNGE KAFFE ME eat_drink cafes cafe normal   none         0 0 40 0 0   45 0 52.6 TGD 37.5 0.2 85   GUSINJE   42.562 19.831     ME-CTR Kafić    
768090 768090 VILA MANOJLOVIĆ ME eat_drink cafes cafe normal   none         0 0 40 0 0   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Poslastičarnica    
768097 768097 CAFFE BAR RIO ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 31.8 TGD 0.3 0.3 2461   BAR   42.096 19.1     ME-CTR Kafić    
768161 768161 GRILL CAFFE ČUDESA OD MESA ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 31.8 TGD 0.3 0.3 2461   BAR   42.096 19.1     ME-CTR Kafić    
768169 768169 CHOCOBASH ME eat_drink cafes cafe normal   none         0 0 40 0 0   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Poslastičarnica    
768182 768182 GRILL CAFFE LUKA ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 31.8 TGD 0.3 0.3 2461   BAR   42.096 19.1     ME-CTR Kafić    
768312 768312 CREMA D ORO 51 ME eat_drink cafes cafe normal   none         0 0 40 0 0   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Poslastičarnica    
768338 768338 GODO ME eat_drink cafes cafe normal   none         0 0 40 0 0   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Poslastičarnica    
768394 768394 THINKERS COFFEE SHOP ME eat_drink cafes cafe normal   none         0 0 40 0 0   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Poslastičarnica    
768523 768523 EXPRES RESTORAN ME eat_drink cafes cafe normal   none         0 0 40 0 0   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Poslastičarnica    
768524 768524 AUTOBUSKA STANICA ME eat_drink cafes cafe normal   none         0 0 40 0 0   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Poslastičarnica    
768586 768586 PALMA ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 31.8 TGD 0.3 0.3 2461   BAR   42.096 19.1     ME-CTR Kafić    
768704 768704 CALYPSO CAFE ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 31.8 TGD 0.3 0.3 2461   BAR   42.096 19.1     ME-CTR Kafić    
768751 768751 POSLASTIČARNICA ČOKOMANIJA ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 31.8 TGD 0.3 0.3 2461   BAR   42.096 19.1     ME-CTR Poslastičarnica    
768753 768753 CAFFE BAR - CAFFE ICE ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 31.8 TGD 0.3 0.3 2461   BAR   42.096 19.1     ME-CTR Kafić    
768761 768761 CAFFE BAR MAXBET ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 31.8 TGD 0.3 0.3 2461   BAR   42.096 19.1     ME-CTR Kafić    
768776 768776 DOO RIVA ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 31.8 TGD 0.3 0.3 2461   BAR   42.096 19.1     ME-CTR Kafić    
768780 768780 MORITZ EIS ME eat_drink cafes cafe normal   none         0 0 40 0 0   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Poslastičarnica    
768781 768781 BAR NAPOLEON ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 31.8 TGD 0.3 0.3 2461   BAR   42.096 19.1     ME-CTR Kafić    
768793 768793 GODDO ME eat_drink cafes cafe normal   none         0 0 40 0 0   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Poslastičarnica    
768812 768812 ČOKOLATISIMA ME eat_drink cafes cafe normal   none         0 0 40 0 0   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Poslastičarnica    
768820 768820 DOLCE ME eat_drink cafes cafe normal   none         0 0 40 0 0   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Poslastičarnica    
768828 768828 KAFANA CASPER ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 31.8 TGD 0.3 0.3 2461   BAR   42.096 19.1     ME-CTR Kafić    
768855 768855 POSLESTIČARNICA MARTINA ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 31.8 TGD 0.3 0.3 2461   BAR   42.096 19.1     ME-CTR Poslastičarnica    
768856 768856 "FONTANA" ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 44.8 TIV 0.0 0.0 511   NIKŠIĆ   42.773 18.944     ME-CTR Poslastičarnica    
768960 768960 poslastičarnica kiosk STREET SHOW ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 66.1 UZC 0.1 0.1 191   PLJEVLJA   43.357 19.359     ME-CTR Poslastičarnica    
769019 769019 TODAY'S ME eat_drink cafes cafe normal   none         0 0 40 0 0   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Poslastičarnica    
769033 769033 KALAMPER PETROL 3 ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 31.8 TGD 0.3 0.3 2461   BAR   42.096 19.1     ME-CTR Kafić    
769180 769180 CAFFEEINA ME eat_drink cafes cafe normal   none         0 0 40 0 0   70 0 4.1 TIV 13.1 0.2 1279   TIVAT   42.436 18.696     ME-CTR Poslastičarnica    
769205 769205 VILA MANOJLOVIĆ ME eat_drink cafes cafe normal   none         0 0 40 0 0   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Poslastičarnica    
769212 769212 GRIL KAFANA BERLIN ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 31.8 TGD 0.3 0.3 2461   BAR   42.096 19.1     ME-CTR Kafić    
769313 769313 PALAČINKARNICA YUMMY ME eat_drink cafes cafe normal   none         0 0 40 0 0   70 0 4.1 TIV 13.1 0.2 1279   TIVAT   42.436 18.696     ME-CTR Poslastičarnica    
769347 769347 MARITIMO ME eat_drink cafes cafe normal   none         0 0 40 0 0   55 0 47.9 TGD 21.0 0.0 2653   ULCINJ   41.929 19.224     ME-CTR Poslastičarnica    
769352 769352 VRUĆA ČOKOLADA ME eat_drink cafes cafe normal   none         0 0 40 0 0   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Poslastičarnica    
769374 769374 ISKRA 1947 ME eat_drink cafes cafe normal   none         0 0 40 0 0   70 10 24.6 TGD 17.8 2.3 93   DANILOVGRAD   42.554 19.109     ME-CTR Poslastičarnica    
769505 769505 POSLASTIČARNICA SLATKI ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 31.8 TGD 0.3 0.3 2461   BAR   42.096 19.1     ME-CTR Poslastičarnica    
769576 769576 CAFFE IGRAONICA DVORIŠTE ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 31.8 TGD 0.3 0.3 2461   BAR   42.096 19.1     ME-CTR Kafić    
769654 769654 SHISHA BAR "MAHALA" Plav ME eat_drink cafes cafe normal   none         0 0 40 0 0   55 0 62.3 TGD 29.1 0.3 121   PLAV   42.596 19.941     ME-CTR Kafić    
769658 769658 LOUNGE BAR "LE BARON - MN" Plav ME eat_drink cafes cafe normal   none         0 0 40 0 0   55 0 62.3 TGD 29.1 0.3 121   PLAV   42.596 19.941     ME-CTR Kafić    
769666 769666 POSLASTIČARNICA "MORITZ EIS" ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 31.8 TGD 0.3 0.3 2461   BAR   42.096 19.1     ME-CTR Poslastičarnica    
769677 769677 CAFFE BAR FLAMINGO ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 31.8 TGD 0.3 0.3 2461   BAR   42.096 19.1     ME-CTR Kafić    
770152 770152 ŠAR ME eat_drink cafes cafe normal   none         0 0 40 0 0   45 0 52.6 TGD 37.5 0.2 85   GUSINJE   42.562 19.831     ME-CTR Poslastičarnica    
770255 770255 OREX ME eat_drink cafes cafe normal   none         0 0 40 0 0   50 0 85.7 TGD 0.1 0.1 249   BIJELO POLJE   43.038 19.748     ME-CTR Poslastičarnica    
770265 770265 CAFFE BAR "DE GUESTO" Plav ME eat_drink cafes cafe normal   none         0 0 40 0 0   55 0 62.3 TGD 29.1 0.3 121   PLAV   42.596 19.941     ME-CTR Kafić    
770350 770350 Kafe-bar TAJNA ME eat_drink cafes cafe normal   none         0 0 40 0 0   40 10 84.6 TGD 22.7 0.1 7   PETNJICA   42.91 19.965     ME-CTR Kafić    
770531 770531 AUTOBUSKA STANICA ME eat_drink cafes cafe normal   none         0 0 40 0 0   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Poslastičarnica    
770533 770533 EXPRES RESTORAN ME eat_drink cafes cafe normal   none         0 0 40 0 0   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Poslastičarnica    
770702 770702 MORITZ EIS ME eat_drink cafes cafe normal   none         0 0 40 0 0   70 0 4.5 TIV 12.3 0.4 2064   KOTOR   42.424 18.771     ME-CTR Poslastičarnica    
770706 770706 KONTRA BAR ME eat_drink cafes cafe normal   none         0 0 40 0 0   55 0 72.1 TGD 16.0 0.1 160   MOJKOVAC   42.96 19.583     ME-CTR Kafić    
770757 770757 HAYDAY ME eat_drink cafes cafe normal   none         0 0 40 0 0   70 0 4.5 TIV 12.3 0.4 2064   KOTOR   42.424 18.771     ME-CTR Poslastičarnica    
771270 771270 kafana IPON ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 66.1 UZC 0.1 0.1 191   PLJEVLJA   43.357 19.359     ME-CTR Kafić    
771271 771271 CAFE BAR "PEGAZ" Plav ME eat_drink cafes cafe normal   none         0 0 40 0 0   55 0 62.3 TGD 29.1 0.3 121   PLAV   42.596 19.941     ME-CTR Kafić    
771482 771482 "CAFFE BAR GRAND " PLAV ME eat_drink cafes cafe normal   none         0 0 40 0 0   55 0 62.3 TGD 29.1 0.3 121   PLAV   42.596 19.941     ME-CTR Kafić    
771601 771601 BUREKDŽINICA GORA ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 31.8 TGD 0.3 0.3 2461   BAR   42.096 19.1     ME-CTR Poslastičarnica    
771684 771684 GG UMIA ME eat_drink cafes cafe normal   none         0 0 40 0 0   80 0 9.1 TGD 0.0 0.0 2155   PODGORICA   42.441 19.263     ME-CTR Poslastičarnica    
771691 771691 ELAN SHISHA BAR Plav ME eat_drink cafes cafe normal   none         0 0 40 0 0   55 0 62.3 TGD 29.1 0.3 121   PLAV   42.596 19.941     ME-CTR Kafić    
771778 771778 CAFFE BAR TIME OUT ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 31.8 TGD 0.3 0.3 2461   BAR   42.096 19.1     ME-CTR Kafić    
771779 771779 CAFE BAR DD ME eat_drink cafes cafe normal   none         0 0 40 0 0   65 0 31.8 TGD 0.3 0.3 2461   BAR   42.096 19.1     ME-CTR Kafić    
771988 771988 " ELAN LOUNGE BAR " Plav ME eat_drink cafes cafe normal   none         0 0 40 0 0   55 0 62.3 TGD 29.1 0.3 121   PLAV   42.596 19.941     ME-CTR Kafić    
771990 771990 KVARTIĆ ME eat_drink cafes cafe normal   none         0 0 40 0 0   70 0 4.1 TIV 13.1 0.2 1279   TIVAT   42.436 18.696     ME-CTR Kafić    
772016 772016 GELATERIA ME eat_drink cafes cafe normal   none         0 0 40 0 0   55 0 47.9 TGD 21.0 0.0 2653   ULCINJ   41.929 19.224     ME-CTR Poslastičarnica    
772117 772117 "FIGARO" poslastičarsko-buregdžijska radnja ME eat_drink cafes cafe normal   none         0 0 40 0 0   55 0 77.0 PRN 22.6 0.8 98   ROŽAJE   42.842 20.167     ME-CTR Poslastičarnica    
772368 772368 JARA ME eat_drink cafes cafe normal   none         0 0 40 0 0   55 0 47.9 TGD 21.0 0.0 2653   ULCINJ   41.929 19.224     ME-CTR Poslastičarnica    
772374 772374 MORITZ EIS ME eat_drink cafes cafe normal   none         0 0 40 0 0   80 0 16.1 TIV 0.1 0.1 6452   BUDVA   42.288 18.84     ME-CTR Poslastičarnica    

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