🏛️ Council area comparison

How do different council areas compare for submission volumes and action rates? Coventry has the highest action rate (74.1%), Walsall the lowest (65.9%) — an 8-point spread across areas with meaningful volume.

Custom SQL query returning 146 rows (hide) 

select council_area as [Council area], count(*) as [Total reports], 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 letter], sum(case when disposal = 'Fixed Penalty' then 1 else 0 end) as [Fixed penalty], sum(case when disposal = 'Court' then 1 else 0 end) as Court, sum(case when disposal = 'NFA' then 1 else 0 end) as NFA, round(100.0 * sum(case when disposal not in ('NFA', 'Duplicate Submission') then 1 else 0 end) / count(*), 0) as [Action rate %] from reports where council_area is not null and council_area != 'Out of Force Area' group by council_area order by [Total reports] desc

Edit SQL

This data as json, CSV

Council areaTotal reportsEducationWarning letterFixed penaltyCourtNFAAction rate %
Birmingham 16801 2831 5398 3189 669 4374 73.0
Coventry 2780 569 597 746 114 712 74.0
Dudley 1677 307 426 278 117 505 70.0
Sandwell 1573 252 440 262 79 496 68.0
Solihull 1279 284 295 209 66 403 68.0
Wolverhampton 1217 195 333 169 67 407 66.0
Walsall 1155 245 219 191 62 391 66.0
Sutton Coldfield 866 164 247 186 28 229 73.0
Halesowen 96 13 19 21 8 34 65.0
Metropolitan Borough Of Dudley 59 3 36 10 0 1 86.0
Metropolitan Borough 27 2 22 2 0 1 96.0
Area 16 0 0 0 0 16 0.0
Out Of Force Area 11 0 0 0 0 11 0.0
Boiurmt Oinf Gfhoarmce 10 0 1 2 0 6 40.0
Mbirmingham 6 0 0 0 1 5 17.0
Osru Cttloons Ecoldfield 5 0 3 0 0 2 60.0
Banirdm Tinhgeh Qaem Hospital 4 0 0 0 0 1 75.0
Soauntd Owf Eflolrce 4 0 0 0 1 3 25.0
Awll Alsall 3 1 1 1 0 0 100.0
Edldu Dalveey Brierley Hill 3 0 3 0 0 0 100.0
Hbeiramthingham 3 0 1 0 0 2 33.0
Abyirmingham 2 0 0 2 0 0 100.0
Aorueta Of Force 2 0 0 0 0 2 0.0
Bdirmingham 2 0 0 0 0 2 0.0
Coouvt Eonft Fryorce 2 0 0 0 0 2 0.0
Ds Rutotoand Coldfield 2 0 0 2 0 0 100.0
Mcoy)Ventry 2 0 0 0 0 2 0.0
Ubdirymaridn Gghraomve 2 0 2 0 0 0 100.0
Ysandwell 2 0 0 1 0 1 50.0
`Birmingham 2 0 0 0 0 2 0.0
)Birmingham 1 0 0 1 0 0 100.0
.Birmingham 1 0 0 0 0 1 0.0
0C1Oventry 1 0 0 1 0 0 100.0
3B2Irmingham 1 0 0 0 0 1 0.0
4C4O4V)Entry 1 0 1 0 0 0 100.0
6B Itromwianrgdhsa Smalford C 1 0 0 0 1 0 100.0
Abdirmingham 1 1 0 0 0 0 100.0
Ao)Ut Of Force Area 1 0 0 0 0 1 0.0
Ao4U0T9 O7F Force Area 1 0 0 0 0 1 0.0
Aofufts Opfo Floirccee) Area 1 0 0 0 0 1 0.0
Aonudt B Olyf Tfhorce Area 1 0 0 0 0 1 0.0
Askoelsihpuellare Drive 1 0 0 0 0 1 0.0
Askust Rtoona Dcoldfield 1 0 0 1 0 0 100.0
Asvaennduweell 1 0 0 1 0 0 100.0
B34Ir Mwianlgshaallm Road 1 0 0 1 0 0 100.0
Bafifromrdin Grhoaamd 1 0 0 0 0 1 0.0
Basirtmingham 1 1 0 0 0 0 100.0
Bbiirrmminingghahmam 1 0 0 0 0 1 0.0
Bboiurmt Oinf Gthhea Mjunction 1 0 0 0 0 1 0.0
Bbrirommiwngichham 1 0 0 1 0 0 100.0
Bnliermy Ilnagnheam 1 0 0 0 1 0 100.0
Borirt Mrionagdham 1 1 0 0 0 0 100.0
Bridrmingham 1 0 1 0 0 0 100.0
C O V E N T R Y 1 0 0 1 0 0 100.0
Cboirrnmeirngham 1 0 0 1 0 0 100.0
Cbtiiromningham 1 0 0 1 0 0 100.0
Coe Ulot Coaf Tfioonrce Area 1 0 0 0 0 1 0.0
Coeustte Orfs Hfiorrece Area 1 0 0 0 0 1 0.0
Coorpvoernattriyon Street 1 0 0 0 1 0 100.0
Cst Arnadwell 1 1 0 0 0 0 100.0
D7)Udley 1 0 0 0 1 0 100.0
Dbirmingham 1 0 0 1 0 0 100.0
Do Ujnt 3Of Force Area 1 0 0 0 0 1 0.0
Ds Bainrcdhwleeyll Island 1 0 0 1 0 0 100.0
Eb Ihrmilli)Ngham 1 0 1 0 0 0 100.0
Eb Ivrmaleingham 1 1 0 0 0 0 100.0
Ebirmingham 1 0 0 0 0 1 0.0
Ebtir Bmirimngihnaghmam 1 0 0 1 0 0 100.0
Ebtisrm Cinogrhnamer 1 1 0 0 0 0 100.0
Ecnoventry 1 1 0 0 0 0 100.0
Edr Uwditlhe Ystaffs Police 1 0 1 0 0 0 100.0
Edwud Rleoyad 1 0 0 1 0 0 100.0
Eo)Ut Of Force Area 1 0 1 0 0 0 100.0
Eorucita Of Force Area 1 0 0 0 0 1 0.0
Eout Of Force Area 1 0 0 0 0 1 0.0
Ewetalsall 1 0 1 0 0 0 100.0
Gbhirammin Gham 1 0 0 0 0 1 0.0
Gsautteto N Coldfield 1 0 0 0 0 1 0.0
Gwe)Alsall 1 0 1 0 0 0 100.0
Hbaimrm Binagsheadm 1 0 0 0 0 1 0.0
Hbeiramthi Nrgohaadm 1 1 0 0 0 0 100.0
Hbiirrlmeyingham 1 0 0 1 0 0 100.0
Hc Sotventry 1 0 0 1 0 0 100.0
Hsoaunsdew Welaly 1 0 0 1 0 0 100.0
Hsuolllihull 1 0 0 0 1 0 100.0
Ibnigrtmoinngham 1 0 0 1 0 0 100.0
Idseudtt Obny Cprol)Dfield 1 0 0 1 0 0 100.0
Iewlda Lrsoalald, Rushall 1 0 0 0 1 0 100.0
Kbirmingham 1 0 0 0 0 1 0.0
Lsouwtetor Nq Cuoelednfi Esldtreet , Sutton Col 1 0 0 0 0 1 0.0
Mbinirgmhianmgham 1 0 0 0 1 0 100.0
Metropolitan Boroug 1 0 1 0 0 0 100.0
Moeunt Dof Force Area 1 0 0 0 0 1 0.0
Moeurtc Oiaf Force Area 1 0 0 0 0 1 0.0
Moeust Voaf Lfleoyr)Ce Area 1 0 0 0 0 1 0.0
Msolihull 1 0 0 0 0 1 0.0
Mswaincdhwell 1 0 0 0 0 1 0.0
Nbdir)Mingham 1 0 0 1 0 0 100.0
Nbiicrmorinn Ghhilal Amnd Church Green W 1 0 1 0 0 0 100.0
Nboirrmtoinng.Ham 1 1 0 0 0 0 100.0
Nbs Irrmdingham 1 0 1 0 0 0 100.0
Nodut Of Force Area 1 0 0 0 0 1 0.0
Nostuetr Of Force Area 1 0 1 0 0 0 100.0
Nsolihull 1 0 1 0 0 0 100.0
Nwolverhampton 1 1 0 0 0 0 100.0
Ob.I R2M8Ingham 1 0 0 0 0 1 0.0
Obsierm ,I Nbgirhmaimngham 1 0 0 0 0 1 0.0
Obtti Rrmoinagdh ,A Bmirmingham 1 0 0 0 0 1 0.0
Oguret Eonf Force Area 1 0 0 0 0 1 0.0
Optuotn Of Force Area 1 0 0 0 0 1 0.0
Osmanwdiwchell 1 0 0 1 0 0 100.0
Osnutton Coldfield 1 0 0 0 0 1 0.0
Ouruyt Of Force Area 1 0 0 0 0 1 0.0
Owlvoelrvhearmhapmtopnton 1 0 0 1 0 0 100.0
Rbdir Mingham 1 0 1 0 0 0 100.0
Rbmirimnginhgahmam 1 0 0 1 0 0 100.0
Rocuht Sotfr Eftotorcne Area 1 0 0 0 0 1 0.0
Royut Of Force Area 1 0 0 0 0 1 0.0
Rsoaanddwell 1 0 0 1 0 0 100.0
Rsohuirte O)F Force Area 1 0 0 0 0 1 0.0
Sanodlih Jucltl 4 1 0 0 0 0 1 0.0
Sbtirremeitn,G Bhiarmmingham 1 1 0 0 0 0 100.0
Scoouvtehn Try 1 0 0 0 0 1 0.0
So Tuotp Of Force Area 1 0 0 0 0 1 0.0
Sowutetor Nq Cueoeldnf Iseltdreet 1 0 0 0 0 1 0.0
Swe Ollavneerh Ra/Mapton 1 0 0 1 0 0 100.0
Tbanirtmonin Rghda Nmr Junction With Cambrid 1 1 0 0 0 0 100.0
Tbirmingham 1 0 0 0 0 1 0.0
Toauffts Of Force Area 1 0 0 0 0 1 0.0
Toount Corfo Sfsorrocaed As.Rea 1 1 0 0 0 0 100.0
Tshawnidcwkell 1 1 0 0 0 0 100.0
Two Bolrvaedrmhaomrep Rtooand 1 0 0 0 0 1 0.0
Ubeiernmsiwngahyam 1 0 0 0 0 1 0.0
Ublilrmingham 1 0 0 0 1 0 100.0
Unknown 1 0 0 0 0 1 0.0
Uwnodlavbeorhuatmpton 1 1 0 0 0 0 100.0
Vceonvtreyntry 1 0 0 0 0 1 0.0
Vceostveern Rtreystaurant) 1 0 0 1 0 0 100.0
Vseutton Coldfield 1 0 0 0 1 0 100.0
Wallalsall 1 0 0 1 0 0 100.0
Wcaoyventry 1 0 0 1 0 0 100.0
Woaurtd Osf Dfeovrcoen Area 1 0 0 0 0 1 0.0
Yb Irmingham 1 0 0 0 0 1 0.0
Yb Riromaidngham 1 0 0 1 0 0 100.0
Yout Of Force Area 1 0 0 0 0 1 0.0
Yw Soclhvoeorhl Awm`Tpotonn 1 0 0 0 0 1 0.0