-
Notifications
You must be signed in to change notification settings - Fork 4
Expand file tree
/
Copy path0007_Locations.sql
More file actions
149 lines (144 loc) · 21.5 KB
/
Copy path0007_Locations.sql
File metadata and controls
149 lines (144 loc) · 21.5 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
IF NOT EXISTS (SELECT TOP(1) [Id] FROM [Configuration].[Location])
BEGIN
SET IDENTITY_INSERT [Configuration].[Location] ON;
INSERT INTO Configuration.Location (Id, Name, ContractId, LifetimeStart, LifetimeEnd, ParentLocationId, GenderProvisionId, LocationTypeId, Created, CreatedBy)
VALUES
(-2, N'Unmapped Community Location', null, '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 2, 9, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(-1, N'Unmapped Custody Location', null, '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 2, 8, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(0, N'Unmapped Location', null, '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 2, 7, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(1, N'HMP Risley', N'con_24036', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 0, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(2, N'HMP Lancaster Farms', N'con_24036', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 0, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(3, N'HMP Forest Bank', N'con_24036', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 1, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(4, N'HMP Altcourse', N'con_24036', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 1, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(5, N'HMP Preston', N'con_24036', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 1, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(6, N'HMP Buckley Hall', N'con_24036', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(7, N'HMP Liverpool', N'con_24036', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(8, N'HMP Manchester', N'con_24036', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(9, N'HMP Thorn Cross', N'con_24036', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(10, N'HMP Haverigg', N'con_24036', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(11, N'HMP Hindley', N'con_24036', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(12, N'HMP Kirkham', N'con_24036', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(13, N'HMP Wymott', N'con_24036', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(14, N'HMP Styal', N'con_24036', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 1, 3, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(15, N'HMP Holme House', N'con_24037', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 0, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(16, N'HMP Northumberland', N'con_24037', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 0, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(17, N'HMP Durham', N'con_24037', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 1, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(18, N'HMP Kirklevington Grange', N'con_24037', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(19, N'HMP Low Newton', N'con_24037', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 1, 3, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(20, N'HMP Wealstun', N'con_24038', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 0, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(21, N'HMP Moorland', N'con_24038', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 0, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(22, N'HMP Humber', N'con_24038', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 0, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(23, N'HMP Doncaster', N'con_24038', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 1, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(24, N'HMP Leeds', N'con_24038', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 1, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(25, N'HMP Hull', N'con_24038', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 1, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(26, N'HMP Full Sutton', N'con_24038', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(27, N'HMP Hatfield', N'con_24038', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(28, N'HMP Lindholme', N'con_24038', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(29, N'HMP Askham Grange', N'con_24038', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 1, 3, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(30, N'HMP New Hall', N'con_24038', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 1, 3, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(31, N'HMP Featherstone', N'con_24041', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 0, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(32, N'HMP Drake Hall', N'con_24041', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 0, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(33, N'HMP Birmingham', N'con_24041', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 1, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(34, N'HMP Brinsford', N'con_24041', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(35, N'HMP Dovegate', N'con_24041', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(36, N'HMP Hewell', N'con_24041', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(37, N'HMP Oakwood', N'con_24041', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(38, N'HMP Stoke Heath', N'con_24041', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(39, N'HMP Swinfen Hall', N'con_24041', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(40, N'HMP Ranby', N'con_24042', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 0, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(41, N'HMP Nottingham', N'con_24042', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 1, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(42, N'HMP Five Wells', N'con_24042', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(43, N'HMP Lincoln', N'con_24042', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(44, N'HMP North Sea Camp', N'con_24042', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(45, N'HMP Onley', N'con_24042', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(46, N'HMP Stocken', N'con_24042', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(47, N'HMP Whatton', N'con_24042', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(48, N'HMP Foston Hall', N'con_24042', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 1, 3, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(49, N'HMP The Mount', N'con_24043', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 0, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(50, N'HMP Peterborough (M)', N'con_24043', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 1, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(51, N'HMP Bedford', N'con_24043', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 1, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(52, N'HMP Chelmsford', N'con_24043', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(53, N'HMP Highpoint', N'con_24043', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(54, N'HMP Hollesley Bay', N'con_24043', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(55, N'HMP Littlehey', N'con_24043', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(56, N'HMP Norwich', N'con_24043', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(57, N'HMP Wayland', N'con_24043', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(58, N'HMP Peterborough (F)', N'con_24043', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 1, 3, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(59, N'HMP High Down', N'con_24044', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 0, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(60, N'HMP Wandsworth', N'con_24044', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 1, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(61, N'HMP Thameside', N'con_24044', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 1, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(62, N'HMP Brixton', N'con_24044', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(63, N'HMP Feltham', N'con_24044', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(64, N'HMP Isis', N'con_24044', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(65, N'HMP Pentonville', N'con_24044', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(66, N'HMP Bronzefield', N'con_24044', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 1, 3, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(67, N'HMP Downview', N'con_24044', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 1, 3, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(68, N'HMP Portland', N'con_24045', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 0, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(69, N'HMP Exeter', N'con_24045', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 1, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(70, N'HMP Bristol', N'con_24045', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 1, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(71, N'HMP Channings Wood', N'con_24045', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(72, N'HMP Dartmoor', N'con_24045', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(73, N'HMP Leyhill', N'con_24045', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(74, N'HMP Guys Marsh', N'con_24045', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(75, N'HMP The Verne', N'con_24045', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(76, N'HMP Eastwood Park', N'con_24045', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 1, 3, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(77, N'HMP Rochester', N'con_24046', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 0, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(78, N'HMP Elmley', N'con_24046', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 1, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(79, N'HMP Lewes', N'con_24046', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 1, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(80, N'HMP Winchester', N'con_24046', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 1, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(81, N'HMP Aylesbury', N'con_24046', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(82, N'HMP Bullingdon', N'con_24046', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(83, N'HMP Ford', N'con_24046', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(84, N'HMP Spring Hill', N'con_24046', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(85, N'HMP Stanford Hill', N'con_24046', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(86, N'HMP Swaleside', N'con_24046', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(87, N'HMP Woodhill', N'con_24046', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(88, N'HMP Send', N'con_24046', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 1, 3, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(89, N'HMP East Sutton Park', N'con_24046', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 1, 3, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(90, N'North West Community', N'con_24036', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 2, 4, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(91, N'North East Community', N'con_24037', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 2, 4, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(92, N'Yorkshire and Humberside Community', N'con_24038', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 2, 4, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(93, N'West Midlands Community', N'con_24041', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 2, 4, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(94, N'East Midlands Community', N'con_24042', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 2, 4, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(95, N'East Of England Community', N'con_24043', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 2, 4, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(96, N'London Community', N'con_24044', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 2, 4, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(97, N'South West Community', N'con_24045', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 2, 4, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(98, N'South East Community', N'con_24046', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 2, 4, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(99, N'Manchester', N'con_24036', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 2, 5, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(100, N'Liverpool', N'con_24036', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 2, 5, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(101, N'Warrington', N'con_24036', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', 100, 2, 6, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(102, N'Blackpool', N'con_24036', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 2, 5, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(103, N'Preston', N'con_24036', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', 102, 2, 6, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(104, N'Blackburn', N'con_24036', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', 102, 2, 6, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(105, N'Durham', N'con_24037', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 2, 5, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(106, N'Middlesbrough', N'con_24037', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', 105, 2, 6, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(107, N'Darlington', N'con_24037', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', 105, 2, 6, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(108, N'Sunderland', N'con_24037', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 2, 5, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(109, N'Newcastle', N'con_24037', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', 108, 2, 6, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(110, N'Leeds', N'con_24038', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 2, 5, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(111, N'Bradford', N'con_24038', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', 110, 2, 6, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(112, N'Huddersfield', N'con_24038', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', 110, 2, 6, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(113, N'Doncaster', N'con_24038', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 2, 5, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(114, N'Sheffield', N'con_24038', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', 113, 2, 6, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(115, N'Hull', N'con_24038', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 2, 5, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(116, N'Birmingham', N'con_24041', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 2, 5, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(117, N'Wolverhampton', N'con_24041', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 2, 5, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(118, N'Stoke', N'con_24041', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', 117, 2, 6, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(119, N'Nottingham', N'con_24042', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 2, 5, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(120, N'Leicester', N'con_24042', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', 119, 2, 6, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(121, N'Derby', N'con_24042', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', 119, 2, 6, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(122, N'Peterborough', N'con_24043', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 2, 5, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(123, N'Luton', N'con_24043', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', 122, 2, 6, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(124, N'Croydon', N'con_24044', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 2, 5, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(125, N'Lambeth', N'con_24044', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', 124, 2, 6, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(126, N'Lewisham', N'con_24044', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', 124, 2, 6, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(127, N'Bristol', N'con_24045', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 2, 5, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(128, N'Plymouth', N'con_24045', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', 127, 2, 6, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(129, N'Chatham', N'con_24046', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 2, 5, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(130, N'Southampton', N'con_24046', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', 129, 2, 6, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(131, N'Portsmouth', N'con_24046', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', 129, 2, 6, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(132, N'HMP Leicester', N'con_24042', '01 Aug 2024', N'2029-03-31 23:59:59.0000000', null, 0, 2, '01 Aug 2024', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(133, N'HMP Wormwood Scrubs', N'con_24044', '12 Jun 2026', N'2029-03-31 23:59:59.0000000', null, 0, 1, '12 Jun 2026', N'2a9b3450-1feb-4be3-ab94-24e64cd34829'),
(134, N'HMP Erlestoke', N'con_24045', '12 Jun 2026', N'2029-03-31 23:59:59.0000000', null, 0, 2, '12 Jun 2026', N'2a9b3450-1feb-4be3-ab94-24e64cd34829');
SET IDENTITY_INSERT [Configuration].[Location] OFF;
END;