| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | A) Pivot Table summary of Roads in KH Ph 1 zone and Moseley F2 LTN zone | |||||||||||||||||||||||||
2 | ||||||||||||||||||||||||||
3 | True Speed Limit | Speed limit on Road as recorded in STATS19 / TfWM extract | ||||||||||||||||||||||||
4 | ||||||||||||||||||||||||||
5 | ||||||||||||||||||||||||||
6 | Count of Casualty Severity | Incident Severity | speed_lim | |||||||||||||||||||||||
7 | Serious | Serious Total | Slight | Slight Total | Grand Total | |||||||||||||||||||||
8 | Road 1 | 20 | 30 | 20 | 30 | 40 | ||||||||||||||||||||
9 | 30 | A4040 HOWARD RD A4040 | 3 | 3 | 3 | |||||||||||||||||||||
10 | 30 | A4040 HOWARD ROAD (A4040) | 1 | 1 | 1 | |||||||||||||||||||||
11 | 30 | A4040 HOWARD ROAD (A4040) AT JUNCTION WITH HAZELHURST ROAD | 5 | 2 | 7 | 7 | ||||||||||||||||||||
12 | 30 | A4040 HOWARD ROAD A4040 AT JN WITH ALL SAINTS ROAD | 3 | 3 | 3 | |||||||||||||||||||||
13 | 30 | A4040 HOWARD ROAD A4040 AT JN WITH CAR PARK OF RED LION PUBLIC HOUSE | 3 | 3 | 3 | |||||||||||||||||||||
14 | 30 | A4040 HOWARD ROAD A4040 AT JN WITH COLMORE ROAD | 1 | 1 | 1 | |||||||||||||||||||||
15 | 30 | A4040 HOWARD ROAD EAST A4040 AT JN WITH ALCESTER ROAD SOUTH A435 | 1 | 1 | 1 | |||||||||||||||||||||
16 | 30 | A4040 O/S NO 85 HOWARD ROAD (A4040) | 1 | 1 | 1 | |||||||||||||||||||||
17 | 20 | A4040 VICARAGE ROAD A4040 AT JN WITH HOWARD ROAD A4040 | 1 | 1 | 1 | |||||||||||||||||||||
18 | 20 | A435 18 KINGS HEATH HIGH ST A435 | 2 | 2 | 2 | |||||||||||||||||||||
19 | 20 | A435 ALCESTER RD A435 | 2 | 2 | 2 | |||||||||||||||||||||
20 | 20 | A435 ALCESTER RD SOUTH A435 | 1 | 1 | 1 | |||||||||||||||||||||
21 | 20 | A435 ALCESTER ROAD (A435) NEAR JUNCTION WITH VALENTINE ROAD | 1 | 1 | 1 | |||||||||||||||||||||
22 | 20 | A435 ALCESTER ROAD SOUTH | 1 | 1 | 1 | |||||||||||||||||||||
23 | 20 | A435 ALCESTER ROAD SOUTH (A435) | 4 | 4 | 4 | 4 | 8 | |||||||||||||||||||
24 | 20 | A435 ALCESTER ROAD SOUTH (A435) - 26 METRES FROM JUNCTION WITH ADDISON ROAD (B4146) | 2 | 2 | 2 | |||||||||||||||||||||
25 | 20 | A435 ALCESTER ROAD SOUTH (A435) AT JUNCTION WITH MIDDLETON ROAD | 1 | 1 | 1 | |||||||||||||||||||||
26 | 20 | A435 ALCESTER ROAD SOUTH (A435) AT JUNCTION WITH MOSSFIELD ROAD | 1 | 1 | 1 | |||||||||||||||||||||
27 | 20 | A435 ALCESTER ROAD SOUTH (A435) NEAR JUNCTION WITH VICARAGE ROAD (B4122) | 1 | 1 | 1 | |||||||||||||||||||||
28 | 20 | A435 BIG JOHNS HIGH ST A435 | 1 | 1 | 1 | |||||||||||||||||||||
29 | 20 | A435 HIGH ST A435 | 2 | 7 | 9 | 9 | ||||||||||||||||||||
30 | 20 | A435 HIGH STREET (A435) | 1 | 1 | 2 | 1 | 3 | 4 | ||||||||||||||||||
31 | 20 | A435 HIGH STREET (A435) - 24 METRES FROM JUNCTION WITH BANK STREET | 1 | 1 | 1 | |||||||||||||||||||||
32 | 20 | A435 HIGH STREET (A435) - 30 METRES FROM JUNCTION WITH KINGSFIELD ROAD | 1 | 1 | 1 | |||||||||||||||||||||
33 | 20 | A435 HIGH STREET (A435) - 40 METRES FROM JUNCTION WITH MILFORD PLACE | 2 | 2 | 2 | |||||||||||||||||||||
34 | 20 | A435 HIGH STREET (A435) AT JUNCTION WITH BANK STREET | 1 | 1 | 1 | |||||||||||||||||||||
35 | 20 | A435 HIGH STREET (A435) AT JUNCTION WITH FINDLAY ROAD | 1 | 1 | 1 | |||||||||||||||||||||
36 | 20 | A435 HIGH STREET (A435) AT JUNCTION WITH HEATHFIELD ROAD | 1 | 1 | 1 | |||||||||||||||||||||
37 | 20 | A435 HIGH STREET (A435) NEAR JUNCTION WITH FINDLAY ROAD | 1 | 1 | 1 | |||||||||||||||||||||
38 | 20 | A435 HIGH STREET (A435) NEAR JUNCTION WITH HEATHFIELD ROAD | 3 | 3 | 3 | |||||||||||||||||||||
39 | 20 | A435 HIGH STREET (A435) NEAR JUNCTION WITH QUEENSBRIDGE ROAD | 1 | 1 | 1 | |||||||||||||||||||||
40 | 20 | A435 HIGH STREET (A435) NEAR JUNCTION WITH VICARAGE ROAD | 1 | 1 | 1 | |||||||||||||||||||||
41 | 20 | A435 HIGH STREET (A435) NEAR JUNCTION WITH VICARAGE ROAD (B4122) | 1 | 1 | 1 | |||||||||||||||||||||
42 | 20 | A435 HIGH STREET A435 AT JN WITH FINDLAY ROAD | 1 | 1 | 1 | 1 | 2 | |||||||||||||||||||
43 | 20 | A435 HIGH STREET A435 AT JN WITH VALENTINE ROAD | 1 | 1 | 1 | |||||||||||||||||||||
44 | 20 | A435 O/S 161 HIGH STREET (A435) - 35 METRES FROM JUNCTION WITH KINGSFIELD ROAD | 1 | 1 | 1 | |||||||||||||||||||||
45 | 20 | A435 O/S NO. 132 HIGH STREET (A435) | 1 | 1 | 1 | |||||||||||||||||||||
46 | 20 | A435 O/S NO. 37 HIGH STREET (A435) | 1 | 1 | 1 | |||||||||||||||||||||
47 | 20 | A435 O/S NO. 37 HIGH STREET (A435) NEAR JUNCTION WITH SPRINGFIELD DRIVE | 1 | 1 | 1 | |||||||||||||||||||||
48 | 20 | A435 SHELL ALCESTER RD A435 | 1 | 1 | 1 | |||||||||||||||||||||
49 | 20 | A435 THE GOOSE PUBLIC HOUSE HIGH STREET A435 NEAR JN WITH POPLAR ROAD | 1 | 1 | 1 | |||||||||||||||||||||
50 | 20 | B4122 VICARAGE RD B4122 | 3 | 3 | 3 | |||||||||||||||||||||
51 | 20 | B4122 VICARAGE ROAD (B4122) | 1 | 1 | 1 | |||||||||||||||||||||
52 | 20 | B4122 VICARAGE ROAD (B4122) - 97 METRES FROM JUNCTION WITH UNCLASSIFIED ROAD | 1 | 1 | 1 | |||||||||||||||||||||
53 | 20 | B4122 VICARAGE ROAD (B4122) AT JUNCTION WITH AVENUE ROAD | 1 | 1 | 1 | |||||||||||||||||||||
54 | 20 | B4122 VICARAGE ROAD B4122 AT JN WITH ABBOTS ROAD | 1 | 1 | 1 | 1 | 2 | |||||||||||||||||||
55 | 20 | B4122 VICARAGE ROAD B4122 AT JN WITH HIGHBURY ROAD | 2 | 2 | 2 | |||||||||||||||||||||
56 | 20 | B4122 VICARAGE ROAD B4122 NEAR JN WITH VICARAGE ROAD A435 | 1 | 1 | 1 | |||||||||||||||||||||
57 | 20 | B4146 BROOK LANE B4146 NEAR JN WITH SPRINGFIELD ROAD | 1 | 1 | 1 | |||||||||||||||||||||
58 | 20 | Unknown 28 ABBOTS ROAD | 1 | 1 | 1 | |||||||||||||||||||||
59 | 20 | Unknown 3 HIGH STREET AT JN WITH SILVER STREET | 1 | 1 | 1 | |||||||||||||||||||||
60 | 20 | Unknown 310 STATION RD NEAR JN WITH AVENUE ROAD | 1 | 1 | 1 | |||||||||||||||||||||
61 | 20 | Unknown ALL SAINTS RD AT JN WITH HOWARD RD A4040 | 1 | 1 | 1 | |||||||||||||||||||||
62 | 20 | Unknown AVENUE ROAD | 1 | 1 | 1 | |||||||||||||||||||||
63 | 20 | Unknown AVENUE ROAD - 33 METRES FROM JUNCTION WITH DADS LANE | 1 | 1 | 1 | |||||||||||||||||||||
64 | 20 | Unknown AVENUE ROAD NEAR JUNCTION WITH GRANGE ROAD | 1 | 1 | 1 | |||||||||||||||||||||
65 | 20 | Unknown BALACLAVA RD | 1 | 1 | 1 | |||||||||||||||||||||
66 | 20 | Unknown BILLESLEY LANE | 1 | 1 | 1 | |||||||||||||||||||||
67 | 20 | Unknown BILLESLEY LANE - 29 METRES FROM JUNCTION WITH DYOTT ROAD | 1 | 1 | 1 | |||||||||||||||||||||
68 | 20 | Unknown BILLESLEY LANE AT JN WITH OXFORD ROAD | 2 | 2 | 2 | |||||||||||||||||||||
69 | 20 | Unknown BILLESLEY LANE AT JUNCTION WITH OXFORD ROAD | 2 | 2 | 2 | |||||||||||||||||||||
70 | 20 | Unknown BILLESLEY LANE NEAR JN WITH CAMBRIDGE ROAD | 1 | 1 | 1 | |||||||||||||||||||||
71 | 20 | Unknown BLENHEIM RD | 2 | 2 | 2 | |||||||||||||||||||||
72 | 20 | Unknown CAMBRIDGE ROAD NEAR JUNCTION WITH BILLESLEY LANE | 1 | 1 | 1 | |||||||||||||||||||||
73 | 20 | Unknown DADS LANE AT JN WITH SHUTLOCK LANE | 1 | 1 | 1 | |||||||||||||||||||||
74 | 20 | Unknown DADS LANE AT JN WITH UFFCULME ROAD | 2 | 2 | 2 | |||||||||||||||||||||
75 | 20 | Unknown DADS LANE NEAR JUNCTION WITH PINEAPPLE ROAD | 1 | 1 | 1 | |||||||||||||||||||||
76 | 20 | Unknown DADS LANE NEAR JUNCTION WITH SHUTLOCK LANE | 1 | 1 | 1 | |||||||||||||||||||||
77 | 20 | Unknown FAIRFIELD ROAD - 21 METRES FROM JUNCTION WITH SILVER STREET | 1 | 1 | 1 | |||||||||||||||||||||
78 | 20 | Unknown GRANGE RD | 1 | 1 | 1 | |||||||||||||||||||||
79 | 20 | Unknown GRANGE ROAD AT JN WITH HIGHBURY ROAD | 2 | 2 | 2 | |||||||||||||||||||||
80 | 20 | Unknown GRANGE ROAD AT JN WITH YORK ROAD | 1 | 1 | 1 | |||||||||||||||||||||
81 | 20 | Unknown GRANGE ROAD AT JUNCTION WITH SOUTH ROAD | 1 | 1 | 1 | |||||||||||||||||||||
82 | 20 | Unknown GROVE AVENUE | 1 | 1 | 1 | |||||||||||||||||||||
83 | 20 | Unknown HIGHBURY ROAD - 96 METRES FROM JUNCTION WITH GRANGE ROAD | 1 | 1 | 1 | |||||||||||||||||||||
84 | 20 | Unknown INSTITUTE ROAD | 1 | 1 | 1 | |||||||||||||||||||||
85 | 20 | Unknown MOOR GREEN LANE NEAR JN WITH YEW TREE ROAD | 1 | 1 | 1 | |||||||||||||||||||||
86 | 20 | Unknown O/S NO. 121 WESTFIELD ROAD - 42 METRES FROM JUNCTION WITH HIGHBURY ROAD | 1 | 1 | 1 | |||||||||||||||||||||
87 | 20 | Unknown O/S NO. 214 GRANGE ROAD | 1 | 1 | 1 | |||||||||||||||||||||
88 | 20 | Unknown O/S NO.30 SPRINGFIELD ROAD | 1 | 1 | 1 | |||||||||||||||||||||
89 | 20 | Unknown OXFORD RD AT JN WITH SCHOOL ROAD | 1 | 1 | 1 | |||||||||||||||||||||
90 | 20 | Unknown OXFORD ROAD AT JUNCTION WITH BILLESLEY LANE | 1 | 1 | 1 | |||||||||||||||||||||
91 | 20 | Unknown OXFORD ROAD NEAR JN WITH SCHOOL ROAD | 1 | 1 | 1 | |||||||||||||||||||||
92 | 20 | Unknown OXFORD ROAD NEAR JUNCTION WITH SCHOOL ROAD | 1 | 1 | 1 | |||||||||||||||||||||
93 | 20 | Unknown QUEENSBRIDGE ROAD - O/S QUEENSBRIDGE SCHOOL | 1 | 1 | 1 | |||||||||||||||||||||
94 | 20 | Unknown SCHOOL RD | 1 | 1 | 1 | |||||||||||||||||||||
95 | 20 | Unknown SCHOOL RD AT JN WITH OXFORD ROAD | 1 | 1 | 1 | |||||||||||||||||||||
96 | 20 | Unknown SCHOOL ROAD - 30 METRES FROM JUNCTION WITH ASHFIELD ROAD | 1 | 1 | 1 | |||||||||||||||||||||
97 | 20 | Unknown SILVER STREET - 48 METRES FROM JUNCTION WITH WHITESMITHS CROFT | 1 | 1 | 1 | |||||||||||||||||||||
98 | 20 | Unknown SPRINGFIELD ROAD AT JUNCTION WITH INSTITUTE ROAD | 3 | 3 | 3 | |||||||||||||||||||||
99 | 20 | Unknown STATION ROAD NEAR JN WITH HIGHBURY ROAD | 1 | 1 | 1 | |||||||||||||||||||||
100 | 20 | Unknown VALENTINE RD | 1 | 1 | 1 |