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
50,621 rows where country = "GB", family = "bars_pubs" and group = "eat_drink"
This data as json, CSV (advanced)
Suggested facets: valid_until (date)
group 1
- eat_drink · 50,621 ✖
family 1
- bars_pubs · 50,621 ✖
country 1
- GB · 50,621 ✖
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 | |||||||||
| 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 | |||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 54375 | 54375 | Somercotes Snooker Club | GB | eat_drink | bars_pubs | bar_pub | coarse | none | 0 | 0 | 40 | 0 | 45 | 80 | 10 | 26.4 | NQT | 2.1 | 2.1 | 202 | Amber Valley | Somercotes Snooker Club 69 Leabrooks Road Somercotes Alfreton Derbyshire | 53.0798817 | -1.3713673 | 2019-06-18T00:00:00 | UK-FSA | Pub/bar/nightclub | ||||||||||
| 54377 | 54377 | Acres Inn | GB | eat_drink | bars_pubs | bar_pub | coarse | none | 0 | 0 | 40 | 0 | 45 | 80 | 0 | 15.8 | MAN | 0.4 | 0.4 | 627 | Denton | Tameside | Acres Inn, 120 Acre Street, Denton, Tameside | 53.4530676 | -2.1160308 | 2025-11-21T00:00:00 | UK-FSA | Pub/bar/nightclub | |||||||||
| 54378 | 54378 | Amber Valley Rugby Club | GB | eat_drink | bars_pubs | bar_pub | coarse | none | 0 | 0 | 40 | 0 | 45 | 80 | 10 | 25.4 | NQT | 3.1 | 3.1 | 214 | Amber Valley | Lower Somercotes Somercotes Alfreton Derbyshire | 53.075222 | -1.357511 | 2026-05-18T00:00:00 | UK-FSA | Pub/bar/nightclub | ||||||||||
| 54379 | 54379 | Three Horse Shoes | GB | eat_drink | bars_pubs | bar_pub | coarse | none | 0 | 0 | 40 | 0 | 45 | 80 | 10 | 26.2 | NQT | 2.5 | 2.5 | 198 | Amber Valley | 68 Main Road Leabrooks Alfreton Derbyshire | 53.075713 | -1.373684 | 2025-06-05T00:00:00 | UK-FSA | Pub/bar/nightclub | ||||||||||
| 54381 | 54381 | The Crown Inn | GB | eat_drink | bars_pubs | bar_pub | coarse | none | 0 | 0 | 40 | 0 | 45 | 80 | 0 | 26.8 | NQT | 1.9 | 1.9 | 195 | Amber Valley | 73 Sleetmoor Lane Somercotes Alfreton Derbyshire | 53.080764 | -1.377029 | 2026-06-24T00:00:00 | UK-FSA | Pub/bar/nightclub | ||||||||||
| 54382 | 54382 | Old English Gentleman | GB | eat_drink | bars_pubs | bar_pub | coarse | none | 0 | 0 | 40 | 0 | 45 | 80 | 10 | 25.9 | NQT | 2.6 | 2.6 | 212 | Amber Valley | 365 Somercotes Hill Somercotes Alfreton Derbyshire | 53.077746 | -1.363877 | 2024-07-11T00:00:00 | UK-FSA | Pub/bar/nightclub | ||||||||||
| 54383 | 54383 | Devonshire Arms | GB | eat_drink | bars_pubs | bar_pub | coarse | none | 0 | 0 | 40 | 0 | 45 | 80 | 10 | 26.1 | NQT | 2.4 | 2.4 | 211 | Amber Valley | 241 Somercotes Hill Somercotes Alfreton Derbyshire | 53.07911 | -1.366768 | 2025-04-29T00:00:00 | UK-FSA | Pub/bar/nightclub | ||||||||||
| 54385 | 54385 | The Steampacket | GB | eat_drink | bars_pubs | bar_pub | coarse | none | 0 | 0 | 40 | 0 | 45 | 80 | 10 | 27.5 | NQT | 2.6 | 2.6 | 174 | Amber Valley | Derby Road Swanwick Alfreton Derbyshire | 53.075923 | -1.398728 | 2017-06-22T00:00:00 | UK-FSA | Pub/bar/nightclub | ||||||||||
| 54386 | 54386 | Swanwick Methodist Church | GB | eat_drink | bars_pubs | bar_pub | coarse | none | 0 | 0 | 40 | 0 | 45 | 80 | 10 | 27.5 | NQT | 2.6 | 2.6 | 174 | Amber Valley | Derby Road Swanwick Alfreton Derbyshire | 53.075923 | -1.398728 | 2026-06-23T00:00:00 | UK-FSA | Pub/bar/nightclub | ||||||||||
| 54387 | 54387 | Cross Keys | GB | eat_drink | bars_pubs | bar_pub | coarse | none | 0 | 0 | 40 | 0 | 45 | 80 | 10 | 27.7 | NQT | 2.3 | 2.3 | 170 | Amber Valley | Derby Road Swanwick Alfreton Derbyshire | 53.078635 | -1.398272 | 1901-01-01T00:00:00 | UK-FSA | Pub/bar/nightclub | ||||||||||
| 54390 | 54390 | The Gate Inn | GB | eat_drink | bars_pubs | bar_pub | coarse | none | 0 | 0 | 40 | 0 | 45 | 80 | 10 | 26.9 | NQT | 2.8 | 2.8 | 179 | Amber Valley | The Delves Swanwick Alfreton Derbyshire | 53.073079 | -1.390962 | 2026-05-20T00:00:00 | UK-FSA | Pub/bar/nightclub | ||||||||||
| 54391 | 54391 | Boot & Slipper | GB | eat_drink | bars_pubs | bar_pub | coarse | none | 0 | 0 | 40 | 0 | 45 | 80 | 10 | 27.5 | NQT | 2.7 | 2.7 | 169 | Amber Valley | The Green Swanwick Alfreton Derbyshire | 53.075263 | -1.399723 | 2026-06-24T00:00:00 | UK-FSA | Pub/bar/nightclub | ||||||||||
| 54393 | 54393 | Bear Inn And Hotel | GB | eat_drink | bars_pubs | bar_pub | coarse | none | 0 | 0 | 40 | 0 | 45 | 80 | 10 | 29.5 | EMA | 5.9 | 3.4 | 53 | Amber Valley | Belper Road/ Wirksworth Road Alderwasley Belper Derbyshire | 53.067245 | -1.529835 | 2023-09-28T00:00:00 | UK-FSA | Pub/bar/nightclub | ||||||||||
| 54394 | 54394 | Belper Amateurs Cricket Club | GB | eat_drink | bars_pubs | bar_pub | coarse | none | 0 | 0 | 40 | 0 | 45 | 80 | 10 | 27.8 | EMA | 4.2 | 4.2 | 122 | Amber Valley | Sandyford Lane Alderwasley Belper Derbyshire | 53.053765 | -1.517405 | 2017-09-22T00:00:00 | UK-FSA | Pub/bar/nightclub | ||||||||||
| 54395 | 54395 | The Family Tree | GB | eat_drink | bars_pubs | bar_pub | coarse | none | 0 | 0 | 40 | 0 | 45 | 65 | 10 | 30.7 | EMA | 7.1 | 4.4 | 63 | Amber Valley | Derby Road Whatstandwell Matlock Derbyshire | 53.085551 | -1.506345 | 2024-09-06T00:00:00 | UK-FSA | Pub/bar/nightclub | ||||||||||
| 54396 | 54396 | Cliff Inn | GB | eat_drink | bars_pubs | bar_pub | coarse | none | 0 | 0 | 40 | 0 | 45 | 65 | 10 | 30.7 | EMA | 6.9 | 3.2 | 41 | Amber Valley | Town End Crich Matlock Derbyshire | 53.090358 | -1.486684 | 2026-04-16T00:00:00 | UK-FSA | Pub/bar/nightclub | ||||||||||
| 54398 | 54398 | The Black Swan | GB | eat_drink | bars_pubs | bar_pub | coarse | none | 0 | 0 | 40 | 0 | 45 | 65 | 10 | 30.0 | EMA | 6.5 | 2.8 | 40 | Amber Valley | 6 Bowns Hill Crich Matlock Derbyshire | 53.085486 | -1.478471 | 2023-08-02T00:00:00 | UK-FSA | Pub/bar/nightclub | ||||||||||
| 54399 | 54399 | Comrades Club | GB | eat_drink | bars_pubs | bar_pub | coarse | none | 0 | 0 | 40 | 0 | 45 | 80 | 10 | 29.9 | EMA | 6.4 | 2.8 | 39 | Amber Valley | School Lane Crich Matlock Derbyshire | 53.083981 | -1.477638 | 2021-02-19T00:00:00 | UK-FSA | Pub/bar/nightclub | ||||||||||
| 54402 | 54402 | Red Lion | GB | eat_drink | bars_pubs | bar_pub | coarse | none | 0 | 0 | 40 | 0 | 45 | 80 | 10 | 28.4 | EMA | 5.6 | 2.8 | 83 | Amber Valley | Front Street Fritchley Derbyshire | 53.072597 | -1.466552 | 2025-02-27T00:00:00 | UK-FSA | Pub/bar/nightclub | ||||||||||
| 54404 | 54404 | Denby Lodge | GB | eat_drink | bars_pubs | bar_pub | coarse | none | 0 | 0 | 40 | 0 | 45 | 80 | 0 | 21.0 | EMA | 2.3 | 2.0 | 193 | Amber Valley | 55 Church Street Denby Ripley Derbyshire | 53.013774 | -1.410026 | 2024-07-11T00:00:00 | UK-FSA | Pub/bar/nightclub | ||||||||||
| 54405 | 54405 | Denby Cricket Club | GB | eat_drink | bars_pubs | bar_pub | coarse | none | 0 | 0 | 40 | 0 | 45 | 80 | 0 | 21.2 | EMA | 1.8 | 1.8 | 154 | Amber Valley | Denby Cricket Club High Bank Denby Village Ripley Derbyshire | 53.017578 | -1.395962 | 2023-09-29T00:00:00 | UK-FSA | Pub/bar/nightclub | ||||||||||
| 54406 | 54406 | The Bulls Head | GB | eat_drink | bars_pubs | bar_pub | coarse | none | 0 | 0 | 40 | 0 | 45 | 80 | 0 | 21.5 | EMA | 1.6 | 1.6 | 151 | Amber Valley | 17 Denby Common Denby Ripley Derbyshire | 53.020153 | -1.391424 | 2026-04-21T00:00:00 | UK-FSA | Pub/bar/nightclub | ||||||||||
| 54409 | 54409 | The Jug And Glass | GB | eat_drink | bars_pubs | bar_pub | coarse | none | 0 | 0 | 40 | 0 | 45 | 65 | 0 | 33.8 | EMA | 8.8 | 2.0 | 116 | Amber Valley | Lea Main Road Lea Matlock Derbyshire | 53.114352 | -1.512902 | 2026-04-16T00:00:00 | UK-FSA | Pub/bar/nightclub | ||||||||||
| 54411 | 54411 | Emmanuel Community Church | GB | eat_drink | bars_pubs | bar_pub | coarse | none | 0 | 0 | 40 | 0 | 45 | 80 | 0 | 20.4 | EMA | 4.0 | 0.2 | 175 | Amber Valley | 32 Chapel Street Duffield Belper Derbyshire | 52.987522 | -1.486905 | 2019-09-26T00:00:00 | UK-FSA | Pub/bar/nightclub | ||||||||||
| 54412 | 54412 | Pattenmakers Arms | GB | eat_drink | bars_pubs | bar_pub | coarse | none | 0 | 0 | 40 | 0 | 45 | 80 | 0 | 20.6 | EMA | 3.9 | 0.3 | 164 | Amber Valley | 4 Crown Street Duffield Belper Derbyshire | 52.988429 | -1.490783 | 2026-02-18T00:00:00 | UK-FSA | Pub/bar/nightclub | ||||||||||
| 54415 | 54415 | Bridge Inn | GB | eat_drink | bars_pubs | bar_pub | coarse | none | 0 | 0 | 40 | 0 | 45 | 80 | 0 | 19.9 | EMA | 4.1 | 0.8 | 189 | Amber Valley | Duffield Bank Duffield Belper Derbyshire | 52.9862 | -1.476449 | 2024-07-05T00:00:00 | UK-FSA | Pub/bar/nightclub | ||||||||||
| 54416 | 54416 | Duffield Club | GB | eat_drink | bars_pubs | bar_pub | coarse | none | 0 | 0 | 40 | 0 | 45 | 80 | 0 | 20.4 | EMA | 4.1 | 0.1 | 175 | Amber Valley | 13 Town Street Duffield Belper Derbyshire | 52.986961 | -1.488119 | 2025-06-17T00:00:00 | UK-FSA | Pub/bar/nightclub | ||||||||||
| 54418 | 54418 | Duffield Rackets And Fitness Club | GB | eat_drink | bars_pubs | bar_pub | coarse | none | 0 | 0 | 40 | 0 | 45 | 80 | 0 | 20.4 | EMA | 4.1 | 0.1 | 175 | Amber Valley | 23 Town Street Duffield Belper Derbyshire | 52.986961 | -1.488119 | 1901-01-01T00:00:00 | UK-FSA | Pub/bar/nightclub | ||||||||||
| 54419 | 54419 | The White Hart | GB | eat_drink | bars_pubs | bar_pub | coarse | none | 0 | 0 | 40 | 0 | 45 | 80 | 0 | 20.3 | EMA | 4.2 | 0.1 | 179 | Amber Valley | 36 Town Street Duffield Belper Derbyshire | 52.985909 | -1.488012 | 2026-02-18T00:00:00 | UK-FSA | Pub/bar/nightclub | ||||||||||
| 54420 | 54420 | Kings Head | GB | eat_drink | bars_pubs | bar_pub | coarse | none | 0 | 0 | 40 | 0 | 45 | 80 | 0 | 20.4 | EMA | 4.1 | 0.1 | 175 | Amber Valley | 1 Town Street Duffield Belper Derbyshire | 52.986961 | -1.488119 | 2026-06-19T00:00:00 | UK-FSA | Pub/bar/nightclub | ||||||||||
| 54424 | 54424 | The Dead Poets Inn | GB | eat_drink | bars_pubs | bar_pub | coarse | none | 0 | 0 | 40 | 0 | 45 | 80 | 0 | 21.3 | EMA | 2.5 | 1.4 | 155 | Amber Valley | 38 Chapel Street Holbrook Belper Derbyshire | 53.005158 | -1.4602 | 2024-03-14T00:00:00 | UK-FSA | Pub/bar/nightclub | ||||||||||
| 54425 | 54425 | Holbrook Sports And Social Club | GB | eat_drink | bars_pubs | bar_pub | coarse | none | 0 | 0 | 40 | 0 | 45 | 80 | 0 | 21.5 | EMA | 2.2 | 1.8 | 151 | Amber Valley | Holbrook Miners Welfare Shaw Lane Holbrook Belper Derbyshire | 53.00575 | -1.465871 | 2025-11-25T00:00:00 | UK-FSA | Pub/bar/nightclub | ||||||||||
| 54428 | 54428 | The Coach And Horses | GB | eat_drink | bars_pubs | bar_pub | coarse | none | 0 | 0 | 40 | 0 | 45 | 80 | 0 | 19.7 | EMA | 4.3 | 1.1 | 154 | Amber Valley | 47 Church Street Horsley Derby Derbyshire | 52.996325 | -1.435771 | 2024-09-26T00:00:00 | UK-FSA | Pub/bar/nightclub | ||||||||||
| 54429 | 54429 | Horsley Bowls Club | GB | eat_drink | bars_pubs | bar_pub | coarse | none | 0 | 0 | 40 | 0 | 45 | 80 | 0 | 19.7 | EMA | 4.2 | 1.1 | 156 | Amber Valley | French Lane Horsley Derby Derbyshire | 52.995824 | -1.438296 | 1901-01-01T00:00:00 | UK-FSA | Pub/bar/nightclub | ||||||||||
| 54431 | 54431 | The Old Oak Inn | GB | eat_drink | bars_pubs | bar_pub | coarse | none | 0 | 0 | 40 | 0 | 45 | 80 | 0 | 19.8 | EMA | 3.8 | 1.5 | 173 | Amber Valley | 176 Main Street Horsley Woodhouse Ilkeston Derbyshire | 53.000869 | -1.418039 | 2025-02-25T00:00:00 | UK-FSA | Pub/bar/nightclub | ||||||||||
| 54432 | 54432 | Sitwell Arms | GB | eat_drink | bars_pubs | bar_pub | coarse | none | 0 | 0 | 40 | 0 | 45 | 80 | 0 | 18.8 | EMA | 4.4 | 1.2 | 110 | Amber Valley | 30 Wood Lane Horsley Woodhouse Ilkeston Derbyshire | 52.9927708 | -1.4089978 | 1901-01-01T00:00:00 | UK-FSA | Pub/bar/nightclub | ||||||||||
| 54433 | 54433 | Kedleston Park Golf Club | GB | eat_drink | bars_pubs | bar_pub | coarse | none | 0 | 0 | 40 | 0 | 45 | 80 | 0 | 19.6 | EMA | 5.5 | 1.1 | 158 | Amber Valley | Kedleston Road Quarndon Derbyshire | 52.964252 | -1.520024 | 2025-01-27T00:00:00 | UK-FSA | Pub/bar/nightclub | ||||||||||
| 54436 | 54436 | Kilburn Social Club | GB | eat_drink | bars_pubs | bar_pub | coarse | none | 0 | 0 | 40 | 0 | 45 | 80 | 0 | 20.9 | EMA | 3.5 | 0.5 | 189 | Amber Valley | Chapel Street Kilburn Belper Derbyshire | 53.008045 | -1.43152 | 2022-05-05T00:00:00 | UK-FSA | Pub/bar/nightclub | ||||||||||
| 54437 | 54437 | Hunters Arms | GB | eat_drink | bars_pubs | bar_pub | coarse | none | 0 | 0 | 40 | 0 | 45 | 80 | 0 | 20.9 | EMA | 3.4 | 0.1 | 168 | Amber Valley | 23 Church Street Kilburn Belper Derbyshire | 53.006799 | -1.438049 | 2017-05-10T00:00:00 | UK-FSA | Pub/bar/nightclub | ||||||||||
| 54438 | 54438 | Blue Bell Inn | GB | eat_drink | bars_pubs | bar_pub | coarse | none | 0 | 0 | 40 | 0 | 45 | Amber Valley | Adams Road Kirk Langley Ashbourne Derbyshire | 2026-03-04T00:00:00 | UK-FSA | Pub/bar/nightclub | |||||||||||||||||||
| 54440 | 54440 | The Dog | GB | eat_drink | bars_pubs | bar_pub | coarse | none | 0 | 0 | 40 | 0 | 45 | 80 | 10 | 27.0 | EMA | 4.0 | 2.6 | 167 | Amber Valley | Main Road Pentrich Ripley Derbyshire | 53.067702 | -1.419587 | 2026-04-16T00:00:00 | UK-FSA | Pub/bar/nightclub |
Advanced export
JSON shape: default, array, newline-delimited
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");