Open Pubs - Derby

1. Home
2. Open Pubs

Description

Subset of the Open Pubs dataset including only pubs falling within the Derby local authority.

Includes pub name, address, and position in eastings and northings and latitude and longitude as open data.

Download

Download

Filename: open_pubs_derby.csv

Version

February 2022

Source

Derived from the Food Standard Agency's Food Hygiene Ratings and the ONS Postcode Directory.

Licence

Open data - free to use for any purpose.

Food Standard Agency's Food Hygiene Ratings is licensed under the FSA's terms & conditions.

The ONS Postcode Directory is licensed under the Open Government Licence.

Fields

Field	Possible Values	Comments
fsa_id	int	Food Standard Agency's ID for this pub.
name	string	Name of the pub.
address	string	Address fields separated by commas.
postcode	string	Postcode of the pub.
easting	int
northing	int
latitude	decimal
longitude	decimal
local authority	string	Local authority this pub falls under.

Data

List of pubs included in Open Pubs under Derby:

• A1 Snooker Club
  New Normanton Mills, Charlotte Street, Derby, DE23 6QG
• Alexandra Hotel
  203 Siddals Road, Derby, DE1 2QE
• Allestree British Legion
  39 Cornhill, Allestree, Derby Derbyshire, DE22 2FS
• Alvaston & Crewton Mens Social Club
  Trent Street, Alvaston, Derby, DE24 8RY
• Arleston Hall
  Arleston Lane, Derby, DE24 3DH
• Baby M
  18 Sadler Gate, Derby, DE1 3NH
• Baby Platinum
  10 Victoria Street, Derby, DE1 1EQ
• Bar 189
  189 Blenheim Drive, Derby, DE22 2GN
• Bar One
  Newland Street, Derby, DE1 1JD
• Bar Sport Derby
  1 Queen Street, Derby, DE1 3DL
• Bedford Arms
  Bedford Arms, 2 Bedford Street, Derby, DE22 3PB
• Bell And Castle
  Burton Road, Derby, DE1 1TG
• Belong
  7-9 Old Blacksmiths Yard, Sadler Gate, Derby, DE1 3PD
• Bishop Blaise
  114 Friar Gate, Derby, Derbyshire, DE1 1EX
• Blacksmith's Lounge
  19-20 Sadler Gate, Derby, DE1 3NH
• Blends
  Derby University, Kedleston Road, Derby, Derbyshire, DE22 1FX
• Bull And Bush
  Premises The Bull And Bush, 256 Prince Charles Avenue, Derby, DE22 4LJ
• Bunk
  8- Sadler Gate, Derby, DE1 3NF
• Bustler Market
  The Chocolate Factory, Siddals Road, Derby, DE1 2QD
• Buzz Bingo
  Liversage Street, Derby, DE1 2JD
• Carnero Lounge
  6-12 St Peters Street, Derby, DE1 1SH
• Castle And Falcon
  Castle And Falcon, East Street, Derby, DE1 2AU
• Central United Reformed Church Derby
  Society Sports Field Pavillion, Brayfield Road, Littleover, Derby, DE23 6LD
• Chaddesden Jubilee Club
  155 Chaddesden Lane, Derby, DE21 6LJ
• Chaddesden Park Social Club
  389/391 Nottingham Road, Derby, DE21 6PD
• Coach And Horses
  Coach And Horses, Mansfield Road, Derby, DE1 3RF
• Coronation Hotel
  The Coronation, Baker Street, Derby, DE24 8SL
• Crescent Inn
  83 Wild Street, Derbyshire, DE1 1GP
• Crown Hotel
  1 Chellaston Road, Allenton, Derby, DE24 9AD
• Crown Inn
  40 Curzon Street, Derby, DE1 1LL
• Cueball
  Mansfield Road, DE21 4AW
• Darley Abbey Wines Ltd
  Stables Block Darley Abbey Mills, Haslams Lane, Darley Abbey, Derby, DE22 1DZ
• Derby Athletic Club
  Moor Lane, Derby, DE24 9HY
• Derby Co Operative Bowls And Social Club
  50 Taverners Crescent, Derby, DE23 6XT
• Derby Leisure And Events Venue
  Moor Lane, Allenton, Derby, DE24 9HY
• Derby West End Bowls Club
  Markeaton Street, Derby, DE1 1DX
• Derby West Indian Community Association
  Carrington Street, Derby, DE1 2ND
• Don Burger
  9 Friar Gate, Derby, DE1 1BU
• Douglas Bar
  206 Normanton Road, Derby, DE23 6UX
• Dubrek Studios
  67-69 Bridge Street, Derby, DE1 3LB
• East Midlands Bridge Academy Limited
  The Old School, Chapel Street, Spondon, Derby, DE21 7JR
• Fat Cat Derby
  9 Friar Gate, Derby, DE1 1BU
• Ferrers Arms,
  Sinfin District Centre, Sinfin Lane, Derby, DE24 3DS
• Fever Derby
  7-11 Wardwick, Derby, DE1 1HA
• Five Lamps
  25 Duffield Road, Derby, DE1 3BH
• Furnace Inn
  9 Duke Street, Derby, DE1 3BX
• Golden Eagle
  The Golden Eagle, 55 Agard Street, Derby, DE1 1DZ
• Half Moon Inn
  534 Burton Road, Littleover, Derby, DE23 6FN
• Hickory's Smokehouse
  The Bonnie Prince, 166 Swarkestone Road, Derby, DE73 5UE
• Hideout / Ktown / Chikbox / Lockedloaded / Locoloco / Elrodeo / Burritobandits / Pizzaamore / Doughmaster
  9-11 Market Place, Derby, DE1 3QE
• Hole In The Wall
  24 Uttoxeter Road, Derby, DE3 0ZQ
• Horse And Groom
  48 Elms Street, Derby, DE1 3HN
• House Of Holes Limited
  9 Babington Lane, Derby, DE1 1TA
• Independent Order Of Oddfellows
  32 Charnwood Street, Normanton, Derby Derbyshire, DE1 2GU
• James Wyatt
  Keldholme Lane, Derby, DE24 0RY
• Jaxx Derby
  44a Babington Lane, Derby, DE1 1SX
• Jj Lloyds
  12 Albert Street, Derby, DE1 2DS
• Jonty Farmer
  Kedleston Road, Derby, DE22 1FT
• Jorrocks
  41 Iron Gate, Derby, Derbyshire, DE1 3GA
• Kings Corner
  Morley Road, Oakwood, Derby, DE21 4TD
• Little Chester Ale House
  4a Chester Green Road, Derby, DE1 3SF
• Littleover Club
  Park Lane, Littleover, Derby Derbyshire, DE23 6FX
• Littleover Social Club Ltd
  61 Blagreaves Lane, Derby, DE23 1FQ
• London Midland Railway Club Association
  45 Wellington Street, Derby, Derbyshire, DE1 2LY
• Lyndhurst Bar
  264 Normanton Road, Derby, DE23 6WD
• Marleyz
  11-13 Curzon Street, DE1 1LH
• Maypole
  42 Brook Street, Derby, DE1 3PH
• Melbourne Bar
  113 Normanton Road, Derby, DE1 2GG
• Metro Bar
  Albert Street, Derby, DE1 2DS
• Mickleover Sports Club
  Station Road, Mickleover, Derby, DE3 9FE
• Mosh Nightclub / Bar E11even
  110 Friar Gate, Derby, DE1 1EX
• Museum & Art Gallery On The Wardwick
  Wardwick, Derby, DE1 1BS
• Navigation
  805 London Road, Derby, DE24 8UU
• New Bridge Inn
  New Bridge Inn, 262 Chellaston Road, Derby, DE24 9EF
• New Zealand Arms
  New Zealand Arms, 2 Langley Street, Derby, DE22 3GL
• Noahs Ark
  23 Morledge, Derby, DE1 2AW
• Norman Arms
  Village Street, Normanton, Derby, DE23 8DF
• Nunsfield House Community Association
  33 Boulton Lane, Alvaston, Derby, DE24 0FD
• Oaklands
  The Oaklands, Oaklands Avenue, Derby, DE23 2QL
• Occasions Events Venue
  The Spot Entertainment Centre, Wilmot Street West, Derby, DE1 2JW
• Osmaston Mens Social Club
  London Road, Derby, DE24 8UW
• Peacock Inn
  Peacock Inn, 87 Nottingham Road, Derby, DE1 3QS
• Peacock Lounge
  10 Park Farm Centre, Park Farm Drive, Allestree, Derby, DE22 2QN
• Pear Tree Inn (Kitchen)
  155 St Thomas Road, Derby, DE23 8RH
• Prosecco Bars
  15a Friar Gate, Derby, DE1 1BU
• R & R Derby Ltd
  12 Derby Road, Chellaston, Derby, DE73 6RA
• Revolucion De Cuba
  1-5 The Strand, Derby, DE1 1BE
• Revolution
  1/2 The Strand, Derby, DE1 1BJ
• Royal British Legion Club Ltd
  Ypres Lodge, 30 Poppyfields Drive, Derby, DE3 9GQ
• Seven Stars Inn
  97 King Street, Derby, DE1 3EE
• Seymours (Derby) Ltd
  4 Cheapside, Derby, DE1 1BR
• Slug And Lettuce
  11 Iron Gate, Derby, DE1 3FJ
• Spondon Bowls Club
  Asterdale Banqueting&sports Cl, Borrowash Road, Spondon, Derby Derbyshire, DE21 7PH
• Spondon Conservative Club
  Spondon Village Club, 13 Chapel Street, Spondon, Derby, DE21 7JP
• Spondon Cricket Club
  The Hsg Oval, 144 Locko Road, Derby, DE21 7AR
• Spondon Liberal Club
  Moor Street, Spondon, Derby, DE21 7EA
• Stein Strasse
  19-23 Wardwick, Derby, DE1 1HA
• Suds And Soda
  119 Friar Gate, Derby, DE1 1EX
• The 102 Social Club
  73 Friar Gate, Derby, Derbyshire, DE1 1FN
• The Argosy
  Manor Road, Littleover, Derby, DE22 3HZ
• The Attic Experience
  Carrington House, Ascot Drive, Derby, DE24 8ST
• The Babington Arms
  11/13 Babington Lane, Derby, DE1 1TA
• The Bank Bar
  Bank Bar, Aspen Drive, Derby, DE21 7SG
• The Bess Of Hardwick
  15 Wardwick, Derby, DE1 1HA
• The Black Rhino
  6-7 Midland Road, Derby, DE1 2SN
• The Bless
  11/17 Chapel Street, Derby, DE1 3GU
• The Blue Jay
  Linville Close, Derby, DE21 7HX
• The Blue Note
  14a Sadler Gate, Derby, DE1 3NF
• The Blue Peter
  Shardlow Road, Alvaston, Derby, DE24 0JH
• The Brackens Hotel
  The Brackens, Brackens Lane, Derby, DE24 0AQ
• The Brick And Tile
  1 Brick Street, Derby, DE1 1DU
• The Broadway
  Duffield Road, Darley Abbey, Derby, DE22 1JB
• The Brunswick Inn
  The Brunswick Inn, 1 Railway Terrace, Derby, DE1 2RU
• The Cathedral
  18-19 Iron Gate, Derby, DE1 3GP
• The Chestnut Tree
  174 Portland Street, Normanton, Derby, DE23 8PJ
• The Coach House
  185a Duffield Road, Derby, DE22 1JB
• The Corn Exchange Sports Bar
  1st Floor Corn Exchange, Albert Street, Derby, DE1 2DS
• The Cornishman
  The Cornishman, Holbrook Road, Derby, DE24 0LX
• The Courtyard
  The Clockyard, Friar Gate, Derby, DE1 1FP
• The Creaky Floorboard
  Residence, 179 Kedleston Road, Derby, DE22 1FT
• The Derby Irish Centre
  11 Becket Street, Derby, DE1 1HT
• The Durham Ox
  124 Burton Road, Derby, Derbyshire, DE1 1TG
• The Evington Club
  244 Village Street, Normanton, Derby, DE23 8TA
• The Fairholme Club
  15 Thornhill Road, Littleover, Derby Derbyshire, DE23 6FZ
• The Falstaff
  Flat Falstaff Free House, 74 Silver Hill Road, Derby, DE23 6UJ
• The Flower Pot
  25 King Street, Derby, DE1 3DZ
• The Forge
  1-6 Old Backsmiths Yard, Sadler Gate, Derby, DE1 3PD
• The Friary / 88th Street / Value Mighty / Sin City Burger
  Friar Gate, Derby, DE1 1FG
• The Georgian House Hotel
  32-36 Ashbourne Road, Derby, DE22 3AD
• The Grampian
  2a Cromarty Close, Sinfin, Derby, DE24 9NB
• The Grange Banqueting Suite
  457 Burton Road, Derby, Derbyshire, DE23 6FL
• The Greyhound
  The Greyhound Inn, 75-76 Friar Gate, Derby, DE1 1FN
• The Hairy Dog
  1-7 Becket Street, DE1 1HT
• The Honeycomb
  The Honeycomb, Ladybank Road, Derby, DE3 0NR
• The Hoppy Place
  488 Nottingham Road, Derby, DE21 6PF
• The Hoptimist
  91 Sitwell Street, Spondon, Derby, DE21 7FH
• The Iron Ram
  27 Iron Gate, Derby, DE1 3GL
• The Kensington Tavern
  30 Drewry Lane, Derby, DE22 3QP
• The King's Highway
  Kingsway, Mackworth, Derby, DE22 3NH
• The Kingsway
  Brackensdale Avenue, Derby, DE22 4AF
• The Lace Club Limited
  170 Nottingham Road, Derby, DE21 6AQ
• The Lodge
  Grange Road, Derby, DE24 0JW
• The Malt Shovel
  Malt Shovel, Potter Street, Derby, DE21 7LH
• The Markeaton
  434 Kedleston Road, Derby, DE22 2TF
• The Masons Arms
  Masons Arms, 1 Etwall Road, Derby, DE3 0DL
• The Merlin
  1 Orient Way, Derby, DE24 8BY
• The Merry Widows
  24 Railway Terrace, Derby, DE1 2RU
• The Nags Head
  Uttoxeter Road, Mickleover, Derby, DE3 9GF
• The Needles
  Bembridge Drive, Derby, DE24 0UQ
• The Neptune
  10/12 Osmaston Road, Derby, DE1 2HR
• The Oak And Acorn
  Danebridge Crescent, Oakwood, Derby, DE21 2HT
• The Old Bell Hotel
  Sadler Gate, Derby, DE1 3NQ
• The Old Silk Mill
  Old Silk Mill, 19 Full Street, Derby, DE1 3AF
• The Orange Tree
  5 George Street, Derby, DE1 1EH
• The Paddock
  391 Mansfield Road, Breadsall, DE21 4AW
• The Paper Mill
  Darley Street, Darley Abbey, Derby, DE22 1DX
• The Pot Hole
  17 Park Farm Centre, Park Farm Drive, Derby, DE22 2QQ
• The Red Cow
  2 St Edmunds Close, Derby, DE22 2DZ
• The Robin Hotel
  The Robin, 71 Devonshire Drive, Derby, DE3 9HD
• The Royal Crown
  2 Cavan Drive, Derby, DE21 6TT
• The Royal Telegraph
  73 London Road, Derby, DE1 2QS
• The Rykneld Bowling Club Ltd
  39 Farley Road, Littleover, Derby Derbyshire, DE23 6BW
• The Shakespeare
  16 Sadler Gate, Derby, DE1 3NF
• The Silver Ghost
  Silver Ghost Inn, Field Drive, Derby, DE24 0HF
• The Smithfield
  Meadow Road, Derby, DE1 2BH
• The Standing Order
  28 - 32 Iron Gate, Derby, DE1 3GL
• The Station Inn
  12 Midland Road, Derby, DE1 2SN
• The Tavern
  123 Nottingham Road, Derby, DE1 3QR
• The Toby Carvery
  Nottingham Road, Chaddesden, Derby, DE21 6LZ
• The Travellers Rest
  185 Ashbourne Road, Derby, DE22 3AJ
• The Vine Inn
  20 Uttoxeter Road, Derby, DE3 0DA
• The Waterfall
  Railway Terrace, Derby, DE1 2RU
• The Woodpecker
  The Woodpecker, 1 Woodford Road, Derby, DE22 4EF
• Tiger Bar
  Lock Up Yard, Corn Market, DE1 2DT
• Together
  27 Wardwick, Derby, DE1 1HA
• Turtle Bay
  1-5 Wardwick, Derby, DE1 1HA
• Ukranian Social Club
  27 Charnwood Street, Derby, DE1 2GU
• Vernon Arms
  21 Locko Road, Derby, DE21 7AL
• Victoria Inn
  Victoria Inn, 12 Midland Place, Derby, DE1 2RR
• Vines Wine Bar
  51a Sadler Gate, Derby, DE1 3NQ
• Vulcan Arms
  1 St Thomas Road, Derby, DE23 8RF
• White Horse Public House
  25 Morledge, DE1 2AW
• White Swan
  Shepherd Street, Littleover, Derby, DE23 6GA
• Wilmot Arms
  Wilmot Arms, 2 Morley Road, Derby, DE21 4QU
• Wine Stories
  5-6 Strand Arcade, Derby, DE1 1BQ
• Woodlands Hotel
  Blenheim Drive, Allestree, Derby, DE22 2LH
• Woodlark Inn
  76-80 Bridge Street, Derby, DE1 3LA
• Woodlark Inn
  Woodlark Inn, 76-80 Bridge Street, Derby, DE1 3LA
• Ye Olde Dolphin
  6-7 Queen Street, Derby, DE1 3DL
• Ye Olde Spa Inne
  Ye Olde Spa Inn, 204 Abbey Street, Derby, DE22 3SU
• Windmill Inn
  Mansfield Road, Breadsall, DE21 4FY