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

266,245 rows where country = "GB" and group = "eat_drink"

This data as json, CSV (advanced)

Suggested facets: valid_until (date)

family 3

group 1

  • eat_drink · 266,245 ✖

country 1

  • GB · 266,245 ✖

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
54268 54268 Hullbridge Sports Association GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 10 7.3 SEN 3.6 3.6 209 Hullbridge Rochford Hullbridge Sports Club, Lower Road, Hullbridge, Hockley 51.616968 0.619654 2016-03-17T00:00:00   UK-FSA Pub/bar/nightclub    
54270 54270 Carmyle Bowling Club GB eat_drink restaurants restaurant coarse   none         0 0 40 0 0   80 10 18.0 GLA 2.1 2.1 547 Glasgow Glasgow City 1 River Road, Glasgow 55.82868 -4.155698 2023-04-26T00:00:00   UK-FSA Restaurant/Cafe/Canteen    
54271 54271 House For An Art Lover GB eat_drink restaurants restaurant coarse   none         0 0 40 0 0   80 10 7.9 GLA 4.0 4.0 2262 Glasgow Glasgow City 10 Dumbreck Road, Glasgow 55.847332 -4.313765 2025-12-03T00:00:00   UK-FSA Restaurant/Cafe/Canteen    
54274 54274 RAF Club GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 22.8 GLA 0.7 0.7 149   Inverclyde 11 Ardgowan Square, Greenock 55.9523462 -4.7695166 2022-09-15T00:00:00   UK-FSA Pub/bar/nightclub    
54275 54275 Ardgowan Club GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 22.7 GLA 0.6 0.6 149   Inverclyde Ardgowan Square, Greenock 55.95152595 -4.76915789 2025-03-07T00:00:00   UK-FSA Pub/bar/nightclub    
54276 54276 Gourock Bowling Club GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 26.1 GLA 3.9 0.2 136   Inverclyde Barrhill Road, Gourock 55.9602418806822 -4.82088088984636 2026-05-20T00:00:00   UK-FSA Pub/bar/nightclub    
54277 54277 Port Glasgow Bowling Club GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 18.3 GLA 3.9 0.9 124   Inverclyde Birkmyre Avenue, Port Glasgow 55.9338780030638 -4.70430631612461 2025-10-22T00:00:00   UK-FSA Pub/bar/nightclub    
54278 54278 Kellybank Caravan Park Clubhouse GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   70 10 27.7 GLA 10.7 0.8 16 Kelly Road Inverclyde Kelly Bank Inn, Kelly Bank Caravan Park, Kelly Road, WEMYSS BAY 55.8775428 -4.8767769 2025-09-03T00:00:00   UK-FSA Pub/bar/nightclub    
54279 54279 Salvation Army Citadel (Mon & Thurs Only) GB eat_drink restaurants restaurant coarse   none         0 0 40 0 0   80 0 6.1 GLO 0.5 0.5 385 Gloucestershire Gloucester City 150 Eastgate Street, Gloucester, Gloucestershire 51.8617048 -2.2395238 2026-01-26T00:00:00   UK-FSA Restaurant/Cafe/Canteen    
54280 54280 Burns Lounge GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 10 25.5 GLA 4.1 2.8 139   Inverclyde 80 Braeside Road, Greenock 55.9369163 -4.8246063 2025-02-10T00:00:00   UK-FSA Pub/bar/nightclub    
54281 54281 Ward Kitchens At GRH GB eat_drink restaurants restaurant coarse   none         0 0 40 0 0   80 0 5.5 GLO 0.6 0.6 378 Gloucester Gloucester City Gloucester Royal Hospital, Great Western Road, Gloucester 51.8671806 -2.2349926 2026-01-21T00:00:00   UK-FSA Restaurant/Cafe/Canteen    
54282 54282 Lodge Doric Kilwinning No. 68 GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 17.7 GLA 4.4 0.3 116   Inverclyde 7 Brown Street, Port Glasgow 55.9347187 -4.6944221 2026-05-15T00:00:00   UK-FSA Pub/bar/nightclub    
54283 54283 Esplanade Cafe GB eat_drink restaurants restaurant coarse   none         0 0 40 0 0   80 0 22.8 GLA 0.9 0.9 149   Inverclyde 3B Campbell Street, Greenock 55.9553604 -4.7673022 2025-03-24T00:00:00   UK-FSA Restaurant/Cafe/Canteen    
54284 54284 Lighthouse Bar GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 21.5 GLA 0.7 0.7 155   Inverclyde 37 Cathcart Street, Greenock 55.9462041 -4.7512586 2025-03-21T00:00:00   UK-FSA Pub/bar/nightclub    
54285 54285 Torpedo Factory Club GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 25.3 GLA 3.2 0.8 143   Inverclyde Chalmers Street, Gourock 55.9561225006788 -4.81055550105257 2025-02-17T00:00:00   UK-FSA Pub/bar/nightclub    
54286 54286 Gourock Golf Club GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45                 Gourock Inverclyde Golf Course, Cowal View, Gourock     2025-07-18T00:00:00   UK-FSA Pub/bar/nightclub    
54287 54287 Upper Port Glasgow Social Club GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 10 15.6 GLA 6.6 2.1 49   Inverclyde Crosshill Road, Port Glasgow 55.9201234000652 -4.66738214961516 2025-06-24T00:00:00   UK-FSA Pub/bar/nightclub    
54288 54288 Grosvenor Bowling Club GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 21.8 GLA 0.6 0.6 155   Inverclyde 2 Dempster Street, Greenock 55.9429797 -4.7593704 2023-09-04T00:00:00   UK-FSA Pub/bar/nightclub    
54289 54289 Port Glasgow Golf Club GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45                 Port Glasgow Inverclyde Golf Course, Devol Road, Port Glasgow     2026-06-22T00:00:00   UK-FSA Pub/bar/nightclub    
54290 54290 Broomhill Bar GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 22.2 GLA 0.8 0.8 156   Inverclyde 112 Drumfrochar Road, Greenock 55.9418893 -4.7658654 2025-01-09T00:00:00   UK-FSA Pub/bar/nightclub    
54291 54291 Fire Station (Port Glasgow) GB eat_drink restaurants restaurant coarse   none         0 0 40 0 0                   Inverclyde East Bay Estate Access Roads, Port Glasgow     2025-04-24T00:00:00   UK-FSA Restaurant/Cafe/Canteen    
54292 54292 Victoria Bowling Club GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 20.3 GLA 1.8 1.8 136   Inverclyde Belville Street, Greenock 55.9421670625092 -4.7342768603231 2024-03-12T00:00:00   UK-FSA Pub/bar/nightclub    
54293 54293 RWSA Boat Club GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 23.6 GLA 1.7 1.7 147   Inverclyde Esplanade, Greenock 55.9604650026182 -4.77693524565709 2025-08-20T00:00:00   UK-FSA Pub/bar/nightclub    
54294 54294 Greenock Golf Club GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 23.2 GLA 1.1 1.1 147   Inverclyde Forsyth Street, Greenock 55.9519769006316 -4.77696060220984 2026-03-20T00:00:00   UK-FSA Pub/bar/nightclub    
54295 54295 Loreto Club GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 22.6 GLA 0.6 0.6 150   Inverclyde 14 Houston Street, Greenock 55.9532736 -4.7660984 2024-11-11T00:00:00   UK-FSA Pub/bar/nightclub    
54296 54296 Lady Alice Bowling Club GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 22.7 GLA 0.6 0.6 148   Inverclyde Inverkip Road, Greenock 55.9471884434417 -4.77075138026741 2026-06-24T00:00:00   UK-FSA Pub/bar/nightclub    
54297 54297 175 Masonic Club GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 22.6 GLA 0.5 0.5 149   Inverclyde 10A Kelly Street, Greenock 55.9516627 -4.7662139 2025-06-10T00:00:00   UK-FSA Pub/bar/nightclub    
54298 54298 Kempock Bar GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 26.0 GLA 3.9 0.0 137   Inverclyde 1 Kempock Street, Gourock 55.961811 -4.8184565 2025-05-14T00:00:00   UK-FSA Pub/bar/nightclub    
54299 54299 Cleats Bar Room GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 26.0 GLA 3.9 0.1 137   Inverclyde 4 Kempock Street, Gourock 55.9620742 -4.8186075 2025-05-14T00:00:00   UK-FSA Pub/bar/nightclub    
54300 54300 Salvation Army GB eat_drink restaurants restaurant coarse   none         0 0 40 0 0   80 0 17.4 GLA 4.8 0.1 96   Inverclyde 17 King Street, Port Glasgow 55.9341867 -4.6890979 2025-01-13T00:00:00   UK-FSA Restaurant/Cafe/Canteen    
54301 54301 Cigna House GB eat_drink restaurants restaurant coarse   none         0 0 40 0 0                 Greenock Inverclyde Scott House, 1 Knowe Road, Greenock     2025-11-14T00:00:00   UK-FSA Restaurant/Cafe/Canteen    
54302 54302 Celtic Supporters Club GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 22.2 GLA 0.3 0.3 154   Inverclyde Laird Street, Greenock 55.95115351863 -4.76025260469675 2025-02-06T00:00:00   UK-FSA Pub/bar/nightclub    
54303 54303 RVS Shop - Inverclyde Royal Hospital GB eat_drink restaurants restaurant coarse   none         0 0 40 0 0   80 10 24.6 GLA 2.9 2.1 144   Inverclyde Larkfield Road, Greenock 55.943597110192 -4.80647866407238 2025-07-11T00:00:00   UK-FSA Restaurant/Cafe/Canteen    
54304 54304 Cardwell Garden Centre GB eat_drink restaurants restaurant coarse   none         0 0 40 0 0                   Inverclyde Cloch Road, Gourock     2025-10-20T00:00:00   UK-FSA Restaurant/Cafe/Canteen    
54305 54305 Greenock Rangers Supporters Club GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 21.8 GLA 0.5 0.5 155   Inverclyde 3 Lyle Street, Greenock 55.9448623 -4.7572531 2025-04-01T00:00:00   UK-FSA Pub/bar/nightclub    
54307 54307 Craigend Resource Centre GB eat_drink fastfood_catering catering coarse   none         0 0 40 0 0   80 10 19.7 GLA 2.4 2.3 129   Inverclyde Mcleod Street, Greenock 55.9393501071985 -4.72577130541223 2025-05-23T00:00:00   UK-FSA Other catering premises    
54308 54308 Inverclyde Navy Club GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 21.9 GLA 0.3 0.3 155   Inverclyde 3 Mearns Street, Greenock 55.9460851 -4.7581688 2025-10-20T00:00:00   UK-FSA Pub/bar/nightclub    
54309 54309 Greenock Wanderers Rugby Football Club GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 24.4 GLA 2.3 1.7 145   Inverclyde 75 Octavia Terrace, Greenock 55.9607225 -4.7914345 2025-06-10T00:00:00   UK-FSA Pub/bar/nightclub    
54310 54310 HM Prison Greenock GB eat_drink restaurants restaurant coarse   none         0 0 40 0 0   80 10 23.6 GLA 2.0 2.0 144   Inverclyde Old Inverkip Road, Greenock 55.9409475012857 -4.79051650424089 2025-10-15T00:00:00   UK-FSA Restaurant/Cafe/Canteen    
54311 54311 Kilmacolm Bowling Club GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45                   Inverclyde Park Road, Kilmacolm     2026-05-14T00:00:00   UK-FSA Pub/bar/nightclub    
54312 54312 Greenock Morton Supporters GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 21.9 GLA 0.3 0.3 155   Inverclyde 42A Regent Street, Greenock 55.9458842 -4.7578675 2023-08-02T00:00:00   UK-FSA Pub/bar/nightclub    
54313 54313 Britannia Social Club GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 21.6 GLA 0.6 0.6 155   Inverclyde 15 Terrace Road, Greenock 55.9450133 -4.7536264 2023-08-02T00:00:00   UK-FSA Pub/bar/nightclub    
54314 54314 The Italian Club GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 22.9 GLA 0.8 0.8 149   Inverclyde 29 Union Street, Greenock 55.9532255 -4.7699535 2023-09-28T00:00:00   UK-FSA Pub/bar/nightclub    
54315 54315 L'Arlecchino Restaurant GB eat_drink restaurants restaurant coarse   none         0 0 40 0 0   80 0 22.3 GLA 0.3 0.3 155   Inverclyde 68 West Blackhall Street, Greenock 55.9508335 -4.761536 2024-12-09T00:00:00   UK-FSA Restaurant/Cafe/Canteen    
54316 54316 Quincys GB eat_drink restaurants restaurant coarse   none         0 0 40 0 0   80 0 22.3 GLA 0.1 0.1 155   Inverclyde 17 West Stewart Street, Greenock 55.9494133 -4.7623667 2025-03-03T00:00:00   UK-FSA Restaurant/Cafe/Canteen    
54317 54317 Masonic Temple GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 22.2 GLA 0.1 0.1 155   Inverclyde West Stewart Street, Greenock 55.9494710000869 -4.76197749928869 2023-08-04T00:00:00   UK-FSA Pub/bar/nightclub    
54318 54318 Regent Club GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 22.1 GLA 0.2 0.2 154   Inverclyde 12 Westburn Street, Greenock 55.949791 -4.7592686 2026-06-18T00:00:00   UK-FSA Pub/bar/nightclub    
54319 54319 The Venue (Wemyss Bay Holiday Park) GB eat_drink restaurants restaurant coarse   none         0 0 40 0 0   70 10 28.7 GLA 10.9 0.9 19   Inverclyde Shore Road, Wemyss Bay 55.884095056797 -4.89305462933333 2026-03-24T00:00:00   UK-FSA Restaurant/Cafe/Canteen    
54320 54320 Muirshiel Resource Centre GB eat_drink fastfood_catering catering coarse   none         0 0 40 0 0   80 0 16.5 GLA 5.7 1.1 53 Port Glasgow Inverclyde Block 8 Unit 50, Gareloch Road, Port Glasgow 55.92776 -4.67754 2025-09-29T00:00:00   UK-FSA Other catering premises    
54321 54321 Royalle Club GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 25.9 GLA 3.7 0.2 136   Inverclyde 20 Royal Street, Gourock 55.9596094533337 -4.81783294881646 2023-07-31T00:00:00   UK-FSA Pub/bar/nightclub    
54322 54322 Greenock Cricket Club GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 23.4 GLA 1.3 1.3 146   Inverclyde Brisbane Street, Greenock 55.9552165022378 -4.77758849186622 2026-07-02T00:00:00   UK-FSA Pub/bar/nightclub    
54323 54323 Horsecraigs The Haven GB eat_drink fastfood_catering catering coarse   none         0 0 40 0 0   80 10 17.8 GLA 5.1 2.7 64   Inverclyde Auchenfoil Road, Kilmacolm 55.91332739 -4.70861458 2025-08-05T00:00:00   UK-FSA Other catering premises    
54324 54324 League Of Friends GB eat_drink restaurants restaurant coarse   none         0 0 40 0 0   80 10 24.8 GLA 3.0 2.0 144 Greenock Inverclyde Inverclyde Royal Hospital, Larkfield Road, Greenock 55.9439828 -4.8092491 2025-10-27T00:00:00   UK-FSA Restaurant/Cafe/Canteen    
54325 54325 Fitzgerald Resource Centre (Canteen) GB eat_drink fastfood_catering catering coarse   none         0 0 40 0 0   80 0 21.7 GLA 0.7 0.7 155   Inverclyde 108 Lynedoch Street, Greenock 55.9419518746242 -4.75786547218031 2024-11-26T00:00:00   UK-FSA Other catering premises    
54326 54326 The James Watt GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 21.6 GLA 0.5 0.5 155   Inverclyde 80 - 92 Cathcart Street, Greenock 55.946871 -4.753469 2025-02-05T00:00:00   UK-FSA Pub/bar/nightclub    
54327 54327 The Point GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 20.4 GLA 1.7 1.7 137   Inverclyde 3 James Watt Way, GREENOCK 55.9449521 -4.7340049 2025-10-14T00:00:00   UK-FSA Pub/bar/nightclub    
54328 54328 Rankin Park Bowling Club GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 23.3 GLA 1.7 1.7 144   Inverclyde Inverkip Road, Greenock 55.942728000012 -4.78570454987567 2024-09-11T00:00:00   UK-FSA Pub/bar/nightclub    
54329 54329 Holy Family Church GB eat_drink fastfood_catering catering coarse   none         0 0 40 0 0   80 10 14.9 GLA 5.3 2.5 51   Inverclyde Parkhill Avenue, Port Glasgow 55.9278055506423 -4.65049324956271 2025-05-14T00:00:00   UK-FSA Other catering premises    
54330 54330 KFC Restaurants Ltd GB eat_drink restaurants restaurant coarse   none         0 0 40 0 0   80 0 21.9 GLA 0.4 0.4 155   Inverclyde 17 Custom House Way, Greenock 55.9492532 -4.7557843 2025-05-07T00:00:00   UK-FSA Restaurant/Cafe/Canteen    
54331 54331 Royal Gourock Yacht Club GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 26.6 GLA 4.6 1.2 130   Inverclyde Ashton Road, Gourock 55.9547764168824 -4.83341583288602 2026-01-22T00:00:00   UK-FSA Pub/bar/nightclub    
54332 54332 The Kafay GB eat_drink restaurants restaurant coarse   none         0 0 40 0 0   80 0 15.6 GLA 6.3 1.9 50   Inverclyde 24 Dubbs Road, Port Glasgow 55.9250601 -4.6650186 2026-03-17T00:00:00   UK-FSA Restaurant/Cafe/Canteen    
54333 54333 Cafe Continental GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 26.1 GLA 4.0 0.1 136   Inverclyde 40 Kempock Street, Gourock 55.9619012 -4.8200787 2025-01-21T00:00:00   UK-FSA Pub/bar/nightclub    
54334 54334 The Norseman GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 10 19.8 GLA 2.3 2.3 131   Inverclyde Sinclair Street, Greenock 55.9418305500077 -4.7253802500806 2025-09-08T00:00:00   UK-FSA Pub/bar/nightclub    
54335 54335 Bluebird Centre GB eat_drink restaurants restaurant coarse   none         0 0 40 0 0   80 10 24.2 GLA 2.3 2.0 147   Inverclyde Wren Road, Greenock 55.9473428785803 -4.79811394302904 2024-11-04T00:00:00   UK-FSA Restaurant/Cafe/Canteen    
54336 54336 Good Brew GB eat_drink restaurants restaurant coarse   none         0 0 40 0 0   80 0 26.1 GLA 4.0 0.2 136   Inverclyde 74 - 76 Kempock Street, Gourock 55.9615575 -4.8207688 2025-06-16T00:00:00   UK-FSA Restaurant/Cafe/Canteen    
54337 54337 Cathay Royale GB eat_drink restaurants restaurant coarse   none         0 0 40 0 0   80 0 22.4 GLA 0.4 0.4 153   Inverclyde 134 West Blackhall Street, Greenock 55.9520923 -4.7626085 2026-02-09T00:00:00   UK-FSA Restaurant/Cafe/Canteen    
54338 54338 GMFC Hospitality GB eat_drink fastfood_catering catering coarse   none         0 0 40 0 0                 Greenock Inverclyde Cappielow Park, Sinclair Street, Greenock     2025-07-30T00:00:00   UK-FSA Other catering premises    
54339 54339 Donnachies Bar GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 17.5 GLA 4.7 0.1 102   Inverclyde 1 - 9 Scarlow Street, Port Glasgow 55.9357267 -4.6891421 2025-04-15T00:00:00   UK-FSA Pub/bar/nightclub    
54340 54340 Cafe Balfe GB eat_drink restaurants restaurant coarse   none         0 0 40 0 0   80 0 22.4 GLA 0.4 0.4 155   Inverclyde 118 West Blackhall Street, Greenock 55.9517385 -4.762293 2026-03-03T00:00:00   UK-FSA Restaurant/Cafe/Canteen    
54341 54341 MV Bute GB eat_drink fastfood_catering catering coarse   none         0 0 40 0 0                 Tarbet Street Inverclyde Retail Operations Department, Ferry Terminal, Tarbet Street, Gourock     2025-05-22T00:00:00   UK-FSA Other catering premises    
54342 54342 The Cardwell Inn GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 25.0 GLA 2.8 1.0 145   Inverclyde 49 Cardwell Road, Gourock 55.9565439 -4.8040261 2025-04-01T00:00:00   UK-FSA Pub/bar/nightclub    
54343 54343 The Victoria Bar GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 25.9 GLA 3.7 0.1 136   Inverclyde 105 Shore Street, Gourock 55.9604340089458 -4.81669489391212 2025-05-14T00:00:00   UK-FSA Pub/bar/nightclub    
54344 54344 Police Scotland GB eat_drink fastfood_catering catering coarse   none         0 0 40 0 0                   Inverclyde 210 Rue End Street, Greenock     2023-08-07T00:00:00   UK-FSA Other catering premises    
54345 54345 Ardgowan Trout Fishery GB eat_drink fastfood_catering catering coarse   none         0 0 40 0 0                 Inverkip Inverclyde Cornalees Visitor Centre, Dunrod Road, Inverkip, Inverclyde     2025-08-13T00:00:00   UK-FSA Other catering premises    
54347 54347 Alfreton Cricket Club GB eat_drink fastfood_catering catering coarse   none         0 0 40 0 0   80 0 28.8 NQT 0.9 0.9 149   Amber Valley Alfreton Park Alfreton Derbyshire 53.09486 -1.396344 2024-10-29T00:00:00   UK-FSA Other catering premises    
54348 54348 Alfreton Town Supporters Social Club GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 27.9 NQT 0.5 0.5 172   Amber Valley Alfreton Town Supporters Social Club North Street Alfreton Derbyshire 53.093813 -1.379783 2026-03-26T00:00:00   UK-FSA Pub/bar/nightclub    
54349 54349 Palmer Morewood Memorial Social Club GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 28.5 NQT 0.4 0.4 152   Amber Valley Palmer Morewood Memorial Social Club Ltd Hall Street Alfreton Derbyshire 53.095972 -1.388817 2024-07-15T00:00:00   UK-FSA Pub/bar/nightclub    
54350 54350 Blue Bell Inn GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 28.6 NQT 0.3 0.3 153   Amber Valley 30 High Street Alfreton Derbyshire 53.097211 -1.38856 2023-01-26T00:00:00   UK-FSA Pub/bar/nightclub    
54351 54351 Alfreton Snooker Hall GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 28.6 NQT 0.4 0.4 153   Amber Valley 55-57 High Street Alfreton Derbyshire 53.097655 -1.389241 2024-08-05T00:00:00   UK-FSA Pub/bar/nightclub    
54352 54352 The King Alfred GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 28.5 NQT 0.2 0.2 156   Amber Valley 58 High Street Alfreton Derbyshire 53.097427 -1.38672 2026-04-23T00:00:00   UK-FSA Pub/bar/nightclub    
54353 54353 Star Cafe GB eat_drink restaurants restaurant coarse   none         0 0 40 0 0   80 0 28.5 NQT 0.2 0.2 156   Amber Valley 68 High Street Alfreton Derbyshire 53.097427 -1.38672 2026-04-08T00:00:00   UK-FSA Restaurant/Cafe/Canteen    
54354 54354 Alfreton House Tea Rooms GB eat_drink restaurants restaurant coarse   none         0 0 40 0 0   80 0 28.4 NQT 0.1 0.1 156   Amber Valley Coffee Shop Rooms 6 And 15 Alfreton House High Street Alfreton Derbyshire 53.097418 -1.384973 2026-03-25T00:00:00   UK-FSA Restaurant/Cafe/Canteen    
54355 54355 Chatterbox Cafe GB eat_drink restaurants restaurant coarse   none         0 0 40 0 0   80 0 28.5 NQT 0.3 0.3 154   Amber Valley Severn Square Alfreton Derbyshire 53.096886 -1.388132 2024-07-22T00:00:00   UK-FSA Restaurant/Cafe/Canteen    
54356 54356 Naughty But Nice GB eat_drink restaurants restaurant coarse   none         0 0 40 0 0   80 0 28.5 NQT 0.3 0.3 154   Amber Valley Unit 3 Institute Lane Alfreton Derbyshire 53.096886 -1.388132 2023-11-30T00:00:00   UK-FSA Restaurant/Cafe/Canteen    
54357 54357 Plough Inn GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 28.3 NQT 0.1 0.1 167   Amber Valley Plough Inn 20 Nottingham Road Alfreton Derbyshire 53.09717 -1.382199 2024-07-11T00:00:00   UK-FSA Pub/bar/nightclub    
54358 54358 David Nieper GB eat_drink restaurants restaurant coarse   none         0 0 40 0 0   80 0 28.1 NQT 0.3 0.3 169   Amber Valley Orange Street Alfreton Derbyshire 53.095646 -1.38128 2023-07-19T00:00:00   UK-FSA Restaurant/Cafe/Canteen    
54359 54359 Miners Arms GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 28.3 NQT 0.7 0.7 176   Amber Valley 66 Park Street Alfreton Derbyshire 53.092728 -1.390804 2024-07-22T00:00:00   UK-FSA Pub/bar/nightclub    
54360 54360 The Village Hall GB eat_drink restaurants restaurant coarse   none         0 0 40 0 0                   Stirling Port Of Menteith, Stirling     2016-08-08T00:00:00   UK-FSA Restaurant/Cafe/Canteen    
54361 54361 Alfreton Golf Catering And Events GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 30.0 NQT 2.2 1.5 132   Amber Valley Wingfield Road Alfreton Derbyshire 53.09721 -1.416994 2024-07-26T00:00:00   UK-FSA Pub/bar/nightclub    
54362 54362 Codnor Park And Ironville Club GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 10 23.8 NQT 4.3 4.2 214   Amber Valley Codnor Park And Ironville Club Monument Lane Codnor Park Ironville Derbyshire 53.058294 -1.350615 2025-06-26T00:00:00   UK-FSA Pub/bar/nightclub    
54363 54363 Selsdon Baptist Church Hall GB eat_drink fastfood_catering catering coarse   none         0 0 40 0 0   80 0 6.6 BQH 3.0 1.6 510 South Croydon Croydon Selsdon Baptist Church, Addington Road, South Croydon 51.3449478149414 -0.0604149997234344 2024-02-12T00:00:00   UK-FSA Other catering premises    
54364 54364 The Sir Julian Huxley GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 0 6.7 BQH 3.0 1.4 506   Croydon 152 - 154 Addington Road, South Croydon 51.3436622619629 -0.0619340017437935 2024-05-18T00:00:00   UK-FSA Pub/bar/nightclub    
54365 54365 Seven Stars GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 10 25.1 NQT 3.5 3.5 207   Amber Valley 26 Church Street Riddings Alfreton Derbyshire 53.069898 -1.358769 2023-08-18T00:00:00   UK-FSA Pub/bar/nightclub    
54366 54366 Moulders Arms GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 10 25.1 NQT 3.5 3.5 207   Amber Valley 53 Church Street Riddings Alfreton Derbyshire 53.069898 -1.358769 2026-03-26T00:00:00   UK-FSA Pub/bar/nightclub    
54367 54367 Riddings Park GB eat_drink fastfood_catering catering coarse   none         0 0 40 0 0   80 10 25.6 NQT 3.2 3.2 200   Amber Valley Riddings Community Centre West Street Riddings Alfreton Derbyshire 53.070648 -1.367847 2023-08-21T00:00:00   UK-FSA Other catering premises    
54368 54368 The Aizle Cafe GB eat_drink restaurants restaurant coarse   none         0 0 40 0 0                 Glasgow Stirling A 811, Balfron Station, Glasgow     2025-10-23T00:00:00   UK-FSA Restaurant/Cafe/Canteen    
54369 54369 The Red Lion Inn GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 10 25.8 NQT 3.0 3.0 195   Amber Valley 150 Greenhill Lane Riddings Alfreton Derbyshire 53.072036 -1.37014 2017-03-21T00:00:00   UK-FSA Pub/bar/nightclub    
54370 54370 Greenhill Tavern GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 10 25.6 NQT 3.2 3.2 198   Amber Valley Greenhill Lane Riddings Alfreton Derbyshire 53.070079 -1.369005 2020-07-16T00:00:00   UK-FSA Pub/bar/nightclub    
54371 54371 Queens Head GB eat_drink bars_pubs bar_pub coarse   none         0 0 40 0 45   80 10 25.1 NQT 3.6 3.6 204   Amber Valley High Street Riddings Alfreton Derbyshire 53.067229 -1.363823 2017-01-06T00:00:00   UK-FSA Pub/bar/nightclub    
54372 54372 Harvester At The Cricketers GB eat_drink restaurants restaurant coarse   none         0 0 40 0 0   80 0 5.3 BQH 3.9 1.3 394 Croydon Croydon Addington Village Inn, 36 Addington Village Road, Croydon 51.3586158752441 -0.0300479996949434 2025-03-26T00:00:00   UK-FSA Restaurant/Cafe/Canteen    

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