🏛️ 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 14348 2451 4300 2877 577 3942 72.0
Coventry 2358 460 514 641 99 616 74.0
Dudley 1443 237 356 252 103 468 68.0
Sandwell 1399 209 399 231 67 457 67.0
Wolverhampton 1071 158 294 146 55 378 65.0
Solihull 1059 220 248 182 55 338 68.0
Walsall 953 197 166 170 51 344 64.0
Sutton Coldfield 747 136 212 173 23 198 73.0
Halesowen 88 9 18 20 7 33 63.0
Metropolitan Borough Of Dudley 51 2 33 9 0 1 90.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