home / nhsadmin

Prisons in England and Wales

Data source: OUseful Databeat

161 rows

View and edit SQL

This data as .json

Suggested facets: Address Line 3, Open Date

Link rowid Organisation Code Name Address Line 1 Address Line 2 Address Line 3 Address Line 4 Address Line 5 Postcode Open Date Close Date Contact Telephone Number Amended Record Indicator
1 YDE01 HMP NORTHUMBERLAND ACKLINGTON     MORPETH NORTHUMBERLAND NE65 9XG 2003-04-01 00:00:00     0
2 YDE02 HMP ISLE OF WIGHT CLISSOLD ROAD     NEWPORT ISLE OF WIGHT PO30 5RS 2003-04-01 00:00:00     0
3 YDE03 HMP ALTCOURSE HIGHER LANE FAZAKERLEY   LIVERPOOL MERSEYSIDE L9 7LH 2003-04-01 00:00:00     0
4 YDE05 HMP BEDFORD ST. LOYES STREET     BEDFORD BEDFORDSHIRE MK40 1HG 2003-04-01 00:00:00     0
5 YDE06 HMP BELMARSH 1 BELMARSH ROAD WESTERN WAY THAMESMEAD LONDON GREATER LONDON SE28 0EB 2003-04-01 00:00:00     0
6 YDE07 HMP BIRMINGHAM WINSON GREEN ROAD     BIRMINGHAM WEST MIDLANDS B18 4AS 2003-04-01 00:00:00     0
7 YDE09 HMP BLANTYRE HOUSE GOUDHURST HORDEN   CRANBROOK KENT TN17 2NH 2003-04-01 00:00:00     0
8 YDE11 HMP BRISTOL 19 CAMBRIDGE ROAD     BRISTOL AVON BS7 8PS 2003-04-01 00:00:00     0
9 YDE12 HMP BRIXTON PO BOX 369 JEBB AVENUE BRIXTON LONDON GREATER LONDON SW2 5XF 2003-04-01 00:00:00     0
10 YDE14 HMP BUCKLEY HALL BUCKLEY ROAD     ROCHDALE LANCASHIRE OL12 9DP 2003-04-01 00:00:00     0
11 YDE15 HMP BULLINGDON PO BOX 50     BICESTER OXFORDSHIRE OX25 1PZ 2003-04-01 00:00:00     0
12 YDE17 HMP CANTERBURY 46 LONGPORT     CANTERBURY KENT CT1 1PJ 2003-04-01 00:00:00     0
13 YDE18 HMP CHANNINGS WOOD DENBURY     NEWTON ABBOT DEVON TQ12 6DW 2003-04-01 00:00:00     0
14 YDE19 HMP COLDINGLEY SHAFTESBURY ROAD BISLEY   WOKING SURREY GU24 9EX 2003-04-01 00:00:00     0
15 YDE1A HMP/ YOI CHELMSFORD 200 SPRINGFIELD ROAD     CHELMSFORD ESSEX CM2 6LQ 2003-04-01 00:00:00     0
16 YDE1C HMP/ YOI DONCASTER OFF NORTH BRIDGE ROAD MARSHGATE   DONCASTER SOUTH YORKSHIRE DN5 8UX 2003-04-01 00:00:00     0
17 YDE1D HMP/ YOI DRAKE HALL DRAKE HALL ECCLESHALL   STAFFORD STAFFORDSHIRE ST21 6LQ 2003-04-01 00:00:00     0
18 YDE1E HMP/ YOI EAST SUTTON PARK SUTTON VALENCE     MAIDSTONE KENT ME17 3DF 2003-04-01 00:00:00     0
19 YDE1F HMP/ YOI EASTWOOD PARK FALFIELD     WOTTON-UNDER-EDGE GLOUCESTERSHIRE GL12 8DB 2003-04-01 00:00:00     0
20 YDE1G HMP/ YOI EXETER NEW NORTH ROAD     EXETER DEVON EX4 4EX 2003-04-01 00:00:00     0
21 YDE1H HMP/ YOI FOREST BANK AGECROFT ROAD PENDLEBURY SALFORD MANCHESTER GREATER MANCHESTER M27 8FB 2003-04-01 00:00:00     0
22 YDE1K HMP/ YOI GUYS MARSH GUYS MARSH     SHAFTESBURY DORSET SP7 0AH 2003-04-01 00:00:00     0
23 YDE1L HMP/ YOI HIGHPOINT SOUTH STRADISHALL     NEWMARKET SUFFOLK CB8 9YG 2003-04-01 00:00:00     0
24 YDE1M HMP/ YOI HOLLESLEY BAY RECTORY ROAD HOLLESLEY   WOODBRIDGE SUFFOLK IP12 3JW 2003-04-01 00:00:00     0
25 YDE1N HMP/ YOI HOLLOWAY PARKHURST ROAD     LONDON GREATER LONDON N7 0NU 2003-04-01 00:00:00     0
26 YDE1P HMP / YOI LANCASTER FARMS STONE ROW HEAD OFF QUERNMORE ROAD   LANCASTER LANCASHIRE LA1 3QZ 2003-04-01 00:00:00     0
27 YDE1Q HMP LEWES 1 BRIGHTON ROAD     LEWES EAST SUSSEX BN7 1EA 2003-04-01 00:00:00     0
28 YDE1T HMP/ YOI NEW HALL DIAL WOOD FLOCKTON   WAKEFIELD WEST YORKSHIRE WF4 4XX 2003-04-01 00:00:00     0
29 YDE1V HMP/ YOI NORWICH KNOX ROAD     NORWICH NORFOLK NR1 4LU 2003-04-01 00:00:00     0
30 YDE1W HMP/ YOI PARC HEOL HOPCYN JOHN COITY   BRIDGEND MID GLAMORGAN CF35 6AP 2003-04-01 00:00:00     0
31 YDE1X HMP/ YOI PRESCOED COED-Y-PAEN     PONTYPOOL GWENT NP4 0TB 2003-04-01 00:00:00     0
32 YDE1Y HMP / YOI STYAL STYAL     WILMSLOW CHESHIRE SK9 4HR 2003-04-01 00:00:00     0
33 YDE20 HMP COOKHAM WOOD SIR EVELYN ROAD     ROCHESTER KENT ME1 3LU 2003-04-01 00:00:00     0
34 YDE21 HMP DARTMOOR PRINCETOWN     YELVERTON DEVON PL20 6RR 2003-04-01 00:00:00     0
35 YDE22 HMP DORCHESTER 7 NORTH SQUARE     DORCHESTER DORSET DT1 1JD 2003-04-01 00:00:00     0
36 YDE23 HMP DOVEGATE DOVEGATE     UTTOXETER STAFFORDSHIRE ST14 8XR 2003-04-01 00:00:00     0
37 YDE24 HMP DOWNVIEW SUTTON LANE     SUTTON SURREY SM2 5PD 2003-04-01 00:00:00     0
38 YDE25 HMP DURHAM OLD ELVET     DURHAM COUNTY DURHAM DH1 3HU 2003-04-01 00:00:00     0
39 YDE26 HMP ELMLEY CHURCH ROAD EASTCHURCH   SHEERNESS KENT ME12 4DZ 2003-04-01 00:00:00     0
40 YDE27 HMP ERLESTOKE ERLESTOKE HOUSE ERLESTOKE   DEVIZES WILTSHIRE SN10 5TU 2003-04-01 00:00:00     0
41 YDE28 HMP HUMBER 1A BECK ROAD EVERTHORPE   BROUGH NORTH HUMBERSIDE HU15 1RB 2003-04-01 00:00:00     0
42 YDE29 HMP FEATHERSTONE NEW ROAD     WOLVERHAMPTON WEST MIDLANDS WV10 7PU 2003-04-01 00:00:00     0
43 YDE2A HMYOI & RC READING FORBURY ROAD     READING BERKSHIRE RG1 3HY 2003-04-01 00:00:00     0
44 YDE2C HMYOI AYLESBURY BIERTON ROAD     AYLESBURY BUCKINGHAMSHIRE HP20 1EH 2003-04-01 00:00:00     0
45 YDE2D HMYOI BRINSFORD NEW ROAD FEATHERSTONE   WOLVERHAMPTON WEST MIDLANDS WV10 7PY 2003-04-01 00:00:00     0
46 YDE2E HMYOI DEERBOLT BOWES ROAD     BARNARD CASTLE COUNTY DURHAM DL12 9BG 2003-04-01 00:00:00     0
47 YDE2G HMYOI HATFIELD THORNE ROAD HATFIELD   DONCASTER SOUTH YORKSHIRE DN7 6EL 2003-04-01 00:00:00     0
48 YDE2H HMYOI HINDLEY GIBSON STREET BICKERSHAW   WIGAN LANCASHIRE WN2 5TH 2003-04-01 00:00:00     0
49 YDE2J HMYOI HUNTERCOMBE HUNTERCOMBE PLACE NUFFIELD   HENLEY-ON-THAMES OXFORDSHIRE RG9 5SB 2003-04-01 00:00:00     0
50 YDE2K HMP LOW NEWTON BRASSIDE     DURHAM COUNTY DURHAM DH1 5YA 2003-04-01 00:00:00     0
51 YDE2M HMP ONLEY WILLOUGHBY     RUGBY WARWICKSHIRE CV23 8AP 2003-04-01 00:00:00     0
52 YDE2N HMYOI PORTLAND 104 GROVE ROAD EASTON   PORTLAND DORSET DT5 1DL 2003-04-01 00:00:00     0
53 YDE2P HMYOI STOKE HEATH STOKE HEATH     MARKET DRAYTON SHROPSHIRE TF9 2JL 2003-04-01 00:00:00     0
54 YDE2Q HMYOI SWINFEN HALL SWINFEN     LICHFIELD STAFFORDSHIRE WS14 9QS 2003-04-01 00:00:00     0
55 YDE2R HMYOI THORN CROSS ARLEY ROAD APPLETON THORN   WARRINGTON CHESHIRE WA4 4RL 2003-04-01 00:00:00     0
56 YDE2T HMYOI WERRINGTON ASH BANK ROAD WERRINGTON   STOKE-ON-TRENT STAFFORDSHIRE ST9 0DX 2003-04-01 00:00:00     0
57 YDE2V HMYOI WETHERBY YORK ROAD     WETHERBY WEST YORKSHIRE LS22 5ED 2003-04-01 00:00:00     0
58 YDE2W HMP/YOI FELTHAM BEDFONT ROAD     FELTHAM MIDDLESEX TW13 4ND 2003-04-01 00:00:00     0
59 YDE2X HMYOI/RC GLEN PARVA 10 TIGERS ROAD     WIGSTON LEICESTERSHIRE LE18 4TN 2003-04-01 00:00:00     0
60 YDE2Y HMP HIGHPOINT NORTH STRADISHALL     NEWMARKET SUFFOLK CB8 9YN 2003-04-01 00:00:00     0
61 YDE30 HMP FORD FORD ROAD     ARUNDEL WEST SUSSEX BN18 0BX 2003-04-01 00:00:00     0
62 YDE31 HMP/YOI FOSTON HALL FOSTON     DERBY DERBYSHIRE DE65 5DN 2003-04-01 00:00:00     0
63 YDE32 HMP FRANKLAND BRASSIDE     DURHAM COUNTY DURHAM DH1 5YD 2003-04-01 00:00:00     0
64 YDE33 HMP FULL SUTTON FULL SUTTON     YORK NORTH YORKSHIRE YO41 1PS 2003-04-01 00:00:00     0
65 YDE34 HMP GARTH ULNES WALTON LANE     LEYLAND LANCASHIRE PR26 8NE 2003-04-01 00:00:00     0
66 YDE35 HMP GARTREE GALLOW FIELD ROAD     MARKET HARBOROUGH LEICESTERSHIRE LE16 7RP 2003-04-01 00:00:00     0
67 YDE37 HMP HAVERIGG NORTH LANE HAVERIGG   MILLOM CUMBRIA LA18 4NA 2003-04-01 00:00:00     0
68 YDE39 HMP HIGH DOWN SUTTON LANE     SUTTON SURREY SM2 5PJ 2003-04-01 00:00:00     0
69 YDE3A HMP GRENDON & SPRINGHILL GRENDON UNDERWOOD     AYLESBURY BUCKINGHAMSHIRE HP18 0TL 2003-04-01 00:00:00     0
70 YDE3C HMP WEALSTUN CHURCH CAUSEWAY THORP ARCH   WETHERBY WEST YORKSHIRE LS23 7AZ 2003-04-01 00:00:00     0
71 YDE3D IRC HASLAR (IMMIGRATION REMOVAL CENTRE) 2 DOLPHIN WAY     GOSPORT HAMPSHIRE PO12 2AW 2003-04-01 00:00:00     0
72 YDE3E HMYOI WARREN HILL HOLLESLEY BAY COLONY RECTORY ROAD HOLLESLEY WOODBRIDGE SUFFOLK IP12 3JW 2003-04-01 00:00:00     0
73 YDE3F HMP SPRING HILL GRENDON UNDERWOOD     AYLESBURY BUCKINGHAMSHIRE HP18 0TL 2003-04-01 00:00:00     0
74 YDE3G HMP BRONZEFIELD WOODTHORPE ROAD     ASHFORD MIDDLESEX TW15 3JZ 2004-06-01 00:00:00     0
75 YDE3H HMP PETERBOROUGH SAVILLE ROAD WESTFIELD   PETERBOROUGH CAMBRIDGESHIRE PE3 7PD 2005-03-28 00:00:00     0
76 YDE3J HMP/YOI MOORLAND THORNE ROAD HATFIELD   DONCASTER SOUTH YORKSHIRE DN7 6EL 2003-04-01 00:00:00     0
77 YDE3K HMP KENNET PARKBOURN MAGHULL   LIVERPOOL MERSEYSIDE L31 1HX 2007-06-01 00:00:00     0
78 YDE3L HMP HEWELL HEWELL LANE     REDDITCH WORCESTERSHIRE B97 6QS 2008-04-01 00:00:00     0
79 YDE3M HMP BURE JAGUAR DRIVE SCOTTOW   NORWICH NORFOLK NR10 5GB 2008-10-01 00:00:00     0
80 YDE40 HMP HOLME HOUSE HOLME HOUSE ROAD     STOCKTON-ON-TEES CLEVELAND TS18 2QU 2003-04-01 00:00:00     0
81 YDE41 HMP HULL HEDON ROAD     HULL NORTH HUMBERSIDE HU9 5LS 2003-04-01 00:00:00     0
82 YDE43 HMP KIRKHAM FRECKLETON ROAD KIRKHAM   PRESTON LANCASHIRE PR4 2RN 2003-04-01 00:00:00     0
83 YDE44 HMP KIRKLEVINGTON GRANGE KIRKLEVINGTON GRANGE     YARM CLEVELAND TS15 9PA 2003-04-01 00:00:00     0
84 YDE46 HMP LATCHMERE HOUSE CHURCH ROAD     RICHMOND SURREY TW10 5HH 2003-04-01 00:00:00     0
85 YDE47 HMP LEEDS GLOUCESTER TERRACE ARMLEY   LEEDS WEST YORKSHIRE LS12 2TJ 2003-04-01 00:00:00     0
86 YDE48 HMP LEICESTER 116 WELFORD ROAD     LEICESTER LEICESTERSHIRE LE2 7AJ 2003-04-01 00:00:00     0
87 YDE49 HMP LEYHILL LEYHILL     WOTTON-UNDER-EDGE GLOUCESTERSHIRE GL12 8BT 2003-04-01 00:00:00     0
88 YDE4A PENNINE HOUSE IMMIGRATION REMOVAL CENTRE ROOM 1506-1510 TERMINAL TWO MANCHESTER AIRPORT MANCHESTER GREATER MANCHESTER M90 4AG 2014-04-01 00:00:00     0
89 YDE50 HMP LINCOLN GREETWELL ROAD     LINCOLN LINCOLNSHIRE LN2 4BD 2003-04-01 00:00:00     0
90 YDE51 HMP LINDHOLME BAWTRY ROAD HATFIELD WOODHOUSE   DONCASTER SOUTH YORKSHIRE DN7 6EE 2003-04-01 00:00:00     0
91 YDE52 HMP LITTLEHEY PERRY     HUNTINGDON CAMBRIDGESHIRE PE28 0SR 2003-04-01 00:00:00     0
92 YDE53 HMP LIVERPOOL 68 HORNBY ROAD     LIVERPOOL MERSEYSIDE L9 3DF 2003-04-01 00:00:00     0
93 YDE54 HMP LONG LARTIN SOUTH LITTLETON     EVESHAM WORCESTERSHIRE WR11 8TZ 2003-04-01 00:00:00     0
94 YDE55 HMP LOWDHAM GRANGE OLD EPPERSTONE ROAD LOWDHAM   NOTTINGHAM NOTTINGHAMSHIRE NG14 7DA 2003-04-01 00:00:00     0
95 YDE56 HMP MAIDSTONE 36 COUNTY ROAD     MAIDSTONE KENT ME14 1UZ 2003-04-01 00:00:00     0
96 YDE57 HMP MANCHESTER SOUTHALL STREET     MANCHESTER GREATER MANCHESTER M60 9AH 2003-04-01 00:00:00     0
97 YDE59 HMP NORTH SEA CAMP CROPPERS LANE FREISTON   BOSTON LINCOLNSHIRE PE22 0QX 2003-04-01 00:00:00     0
98 YDE60 HMP NOTTINGHAM 112 PERRY ROAD SHERWOOD   NOTTINGHAM NOTTINGHAMSHIRE NG5 3AG 2003-04-01 00:00:00     0
99 YDE61 HMP PARKHURST CLISSOLD ROAD     NEWPORT ISLE OF WIGHT PO30 5NX 2003-04-01 00:00:00     0
100 YDE62 HMP PENTONVILLE NORTH WALL GATE PENTONVILLE CALEDONIAN ROAD LONDON GREATER LONDON N7 8TT 2003-04-01 00:00:00     0

Next page

CREATE TABLE "eprison" (
"Organisation Code" TEXT,
  "Name" TEXT,
  "Address Line 1" TEXT,
  "Address Line 2" TEXT,
  "Address Line 3" TEXT,
  "Address Line 4" TEXT,
  "Address Line 5" TEXT,
  "Postcode" TEXT,
  "Open Date" TIMESTAMP,
  "Close Date" TIMESTAMP,
  "Contact Telephone Number" REAL,
  "Amended Record Indicator" INTEGER
)
Powered by Datasette · Query took 9.355ms · Data source: OUseful Databeat