🏛️ Council area comparison

How do different council areas compare for submission volumes and action rates? Birmingham dominates by volume, but smaller areas may have different enforcement patterns.

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 15578 2682 4791 3023 633 4184 73.0
Coventry 2594 532 568 677 110 674 74.0
Dudley 1593 290 398 264 113 494 69.0
Sandwell 1482 233 419 241 71 477 68.0
Solihull 1158 249 275 203 59 356 69.0
Wolverhampton 1135 176 311 156 61 388 66.0
Walsall 1027 221 182 181 58 360 65.0
Sutton Coldfield 804 148 232 179 26 211 74.0
Halesowen 91 10 19 21 7 33 64.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