📍 Top reported locations

The 50 streets with the most Operation Snap submissions. Washwood Heath Road in Birmingham leads with 1,000 reports in 14 months.

Custom SQL query returning 50 rows (hide) 

select offence_location as Location, council_area as [Council area], count(*) as [Total reports], sum(case when disposal in ('Fixed Penalty', 'Court') then 1 else 0 end) as [Fines/court], sum(case when disposal = 'Education' then 1 else 0 end) as Education, sum(case when disposal = 'Warning Letter' then 1 else 0 end) as [Warning letters], sum(case when disposal = 'NFA' then 1 else 0 end) as NFA, round(100.0 * sum(case when disposal != 'NFA' then 1 else 0 end) / count(*), 0) as [Action rate %] from reports where offence_location is not null group by offence_location, council_area order by [Total reports] desc limit 50

Edit SQL

This data as json, CSV

LocationCouncil areaTotal reportsFines/courtEducationWarning lettersNFAAction rate %
Washwood Heath Road Birmingham 997 208 360 349 74 93.0
Lozells Road Birmingham 262 17 60 159 26 90.0
Stratford Road Birmingham 250 62 44 70 72 71.0
Glenville Drive Birmingham 218 158 13 39 8 96.0
Alcester Road Birmingham 214 92 18 59 43 80.0
Stoney Stanton Road Coventry 180 66 51 51 11 94.0
Chester Road Birmingham 171 25 42 50 54 68.0
Pershore Road Birmingham 140 34 49 27 30 79.0
Bristol Road Birmingham 136 39 26 24 46 66.0
Barnsley Road Birmingham 129 0 0 105 24 81.0
Cannock Road Wolverhampton 129 4 5 32 65 50.0
Coventry Road Birmingham 125 37 26 21 40 68.0
Witton Road Birmingham 116 13 40 43 20 83.0
Hagley Road Birmingham 115 35 12 34 30 74.0
Kingstanding Road Birmingham 106 18 20 45 14 87.0
Foleshill Road Coventry 100 63 12 8 17 83.0
Dudley Road Birmingham 96 15 15 43 22 77.0
Gayfield Avenue Dudley 93 11 9 39 34 63.0
Bradford Street Birmingham 89 15 1 35 37 58.0
Daw End Lane Walsall 89 44 27 7 11 88.0
Tyburn Road Birmingham 88 25 21 16 26 70.0
Tower Street Dudley 85 52 0 11 22 74.0
Walsall Road Birmingham 84 9 21 24 30 64.0
Moseley Road Birmingham 83 16 13 39 12 86.0
Norwood Road Dudley 81 33 20 8 20 75.0
Bromford Lane Birmingham 78 20 20 25 11 86.0
Warwick Road Birmingham 74 19 17 21 16 78.0
Augustus Road Birmingham 72 65 3 2 2 97.0
Lower Queen Street Sutton Coldfield 69 29 5 27 8 88.0
Coleshill Road Birmingham 66 21 21 17 7 89.0
Northfield Road Birmingham 65 14 14 12 25 62.0
M6 Birmingham 62 6 8 20 25 60.0
Clifford Bridge Road Coventry 60 34 12 8 5 92.0
Harborne Road Birmingham 59 40 9 6 4 93.0
Stratford Road Solihull 57 14 14 11 17 70.0
Chester Road Sutton Coldfield 56 11 16 12 17 70.0
Yardley Wood Road Birmingham 56 19 14 11 12 79.0
Earlsdon Street Coventry 55 25 11 14 5 91.0
Eddish Road Birmingham 55 6 1 23 24 56.0
Metchley Lane Birmingham 55 39 0 4 11 80.0
Hurstcroft Road Birmingham 53 17 5 21 10 81.0
Aston Webb Boulevard Birmingham 50 42 2 2 4 92.0
Poplar Road Birmingham 50 5 8 32 5 90.0
Bell Green Road Coventry 49 34 7 3 5 90.0
Wake Green Road Birmingham 48 10 12 14 12 75.0
Washwood Heath Road , Birmingham Birmingham 48 0 0 3 45 6.0
Rotten Park Road Birmingham 46 12 2 16 15 67.0
Abbey Road Sandwell 45 0 1 32 10 78.0
Church Road Birmingham 45 7 11 18 8 82.0
High Street, Tettenhall Wolverhampton 45 10 15 15 5 89.0