No Shortcuts: Using evidence to inform public policy in Coventry
No Shortcuts
Research in practice: Using evidence to inform public policy in Coventry
Presentation to the Institute of Local Government Studies (INLOGOV), University of Birmingham, 21 November 2019
and providing understanding to make life better in Coventry” Growth – Reform – Enable “Questioning, influencing and providing understanding to make life better in Coventry.”
social care, tax & benefits Coventry and Warwickshire Partnership NHS Trust University Hospital Coventry and Warwickshire NHS Trust West Midlands Ambulance Service NHS Foundation Trust Coventry and Rugby Clinical Commissioning Group Health: hospitals, GPs, mental health Probation Housing and homelessness Police, fire and regional groups Voluntary sector and multi-agency advice and support Substance misuse Behaving as a system
OASys end-September 2016 The most common characteristic is age 26-34 gender male ethnicity white british 39% 95% 69% 0 10 20 30 40 50 18 - 20 21 - 25 26 - 34 35 - 49 50 - 64 65+ Female Male 69% 4% 3% 3% 2% 2% 2% 1% 1% 1% 1% 12% White British Black African Mixed White/Black… White Other White Irish Asian Indian Asian Chinese Asian Other Black Other Black Caribbean Mixed Other Not stated Characteristics Coventry Multiple Complex Needs n=120 People being supported by NPS Midlands (Coventry) Current cases on OASys end-September 2016 Offending-related risks Risk of serious harm 2% 57% 42% Low Medium High OASys General reoffending Predictor (OGP) score 47% 36% 14% 3% Very High Low Medium High Coventry Multiple Complex Needs n=120 People being supported by NPS Midlands (Coventry) Current cases on OASys end-September 2016 Offending-related needs Number of need categories per person 2 7 17 20 24 16 21 11 2 2 3 4 5 6 7 8 9 10 The most common needs are… needs six category thinking & behaviour 20% 99% thinking & behaviour 119 Frequency of needs lifestyle & associations 103 attitudes 91 relationships 83 alcohol misuse 77 emotional wellbeing 67 accommodation 54 financial management & income 54 drug misuse 53 EET* 35 *employment, training & education Grouped need categories social & family (100%) health & physical (94%) financial & housing (71%) employment & education (29%) Criminogenic needs are identified from a criminogenic needs assessment. For instance, a criminogenic need of “relationships” are identified and scored if close personal relationships ( ie with family or partners) generate difficulties/conflict that contribute to that individuals risk of harm or risk of reoffending. Coventry Multiple Complex Needs n=120 People being supported by SWM Community Rehabilitation Company in Coventry Current cases on OASys December 2016 Offending-related needs Coventry Multiple Complex Needs n=1,657 1534 1142 585 502 475 426 423 347 306 227 Thinking and behaviour Attitudes Lifestyle and associations Relationships Employment/training/educ… Alcohol misuse Financial management &… Drug misuse Emotional wellbeing Accommodation 89 93 488 369 160 177 123 72 58 23 5 0 1 2 3 4 5 6 7 8 9 10 The most common needs are… needs two category thinking & behaviour 29% 93% Number of need categories per person Frequency of needs Criminogenic needs are identified from a criminogenic needs assessment. For instance, a criminogenic need of “relationships” are identified and scored if close personal relationships ( ie with family or partners) generate difficulties/conflict that contribute to that individuals risk of harm or risk of reoffending. People being supported by SWM Community Rehabilitation Company in Coventry Current cases on OASys December 2016 Characteristics Coventry Multiple Complex Needs n=1,657 The most common characteristic is age 26-49 gender male ethnicity white british 68% 86% 48% 0 200 400 600 800 1000 18 - 20 21 - 25 26 - 49 50 - 64 65 + Female Male 796 57 52 52 47 37 29 28 23 13 11 8 7 6 3 1 151 336 White British White Other Asian Indian Asian Chinese Black African Black Caribbean Mixed White/Black… Asian Other Asian Pakistani Black Other White Irish Mixed White/Asian Asian Bangladeshi Mixed White/Black African Mixed Other White Gypsy/Traveller Not stated Not recorded Low 18% Medium 45% High 1% Unknown 36% People being supported by SWM Community Rehabilitation Company in Coventry Current cases on OASys December 2016 Offending-related risks Risk of serious harm Coventry Multiple Complex Needs n=1,657 OASys General reoffending Predictor (OGP) score Low 29% Medium 17% High 7% Very High 2% Unknown 45% Coventry repeat demand data from West Midlands Police Incidents recorded and police call-outs in September 2016 Incidents and call-outs Coventry Multiple Complex Needs n=7,030 20.35 Citywide 7.61 Wainbody 10.27 Whoberley 30.26 Henley 40.93 St. Michaels 31.23 Foleshill 3.41 Upper Stoke 1.60 Wainbody 1.81 Earlsdon 3.83 Foleshill 5.24 Henley 4.49 Binley & W’hall 2.23 Bablake 3.05 Citywide 5.38 St. Michaels Incidents Recorded crimes (rate per 1,000 population) (rate per 1,000 population) Coventry repeat demand data from West Midlands Police Incidents recorded and police call-outs in September 2016 Frequent callers Coventry Multiple Complex Needs n=7,030 0 5 10 15 20 25 30 5,372 incidents with phone numbers 4,036 unique phone numbers 1.24 incidents per phone number 76% (4,330 including withheld numbers) 54 calls from four residential numbers ASB + mental health 37 calls from Council monitoring unit and parking services 16 calls from National Express garage (mostly ASB) ⛽ 11 calls about bilking at ASDA, 38 total petrol station calls 28 calls from two children’s homes (mostly missing kids) 10 calls from a special school (absconding kids) 52 numbers responsible for five or more calls totalling 419 calls 12 numbers responsible for ten or more calls totalling 177 calls 14.75 incidents per phone number 8.06 incidents per phone number Coventry repeat demand data from West Midlands Police Incidents recorded and police call-outs in September 2016 Frequent locations Coventry Multiple Complex Needs n=7,030 Kasbah Nightclub (12) Swanswell Street (22) Caludon Centre (14) Salvation Army (22) St Nicholas Street (16) Vincent Wyles House (18) Henley Road (10) Ricoh Arena (15) Tesco (10) Beaconsfield Road (13) B&Q (13) Longford Park (13) Sainsbury’s (12) Co-op (12) Caradoc Hall (16) Signals Drive (20) Stoney Stanton Road (10) Kirkdale Ave (10) We cannot share that – data sharing agreements which will take a year Patient confidentiality and research ethics approval for interviews ✔ " Anonymised data ✔ " Timelines / stories ✔ " Service specifications ✔ " Case studies and working with experts by experience Multiple complex needs: what we did Characteristics Deep dive Lived experiences Frontline staff $ % ' ( Behaving as a system
Intelligence Hub: what we wanted to achieve Low High Making use of what we know High Data collected about individuals Privacy controls and democratic accountability Bringing it all together
Internal systems e.g. social care, education, finance, HR Community intelligence Partner data External data e.g. Fingertips, LGInformPlus EXTERNAL INTERNAL Bringing it all together
of truth” Health and wellbeing JSNA DPH Annual Report Cultural profiles City of Culture Trust Council Plan performance report & performance reporting Housing and homelessness Headline statistics Social care e.g. market position statement Bringing it all together
collection plan Data collection plan Import Themes Identify all the indicators we want to collect – and where they’re coming from (data sources) Culture collection plan Housing and homelessness collection plan Assign themes and sub-categories to each data item Set up import routines to import the data into the data warehouse Bringing it all together
json files via APIs Power BI ! A data model that allows us to store indicator data over any bespoke space and time: as long as an indicator has a geographical and time dimension, it will fit in this data model. Values Indicators (Metrics) Periods Geographies (Areas) Data warehouse Themes look-up table Shapes look-up table Extract Transform Load (ETL) routine to change data to correct format Import routine with refresh period Bringing it all together
Blending intelligence Facts about Coventry Place-based analytical profiles for city and localities “JSNA” data book Health and Wellbeing Strategy 2019-22 Health and Wellbeing Strategy 2016-19 2016 Citywide intelligence hub Data profiler (Power BI) Community intelligence (directory and asset maps) 2019
sichunlam
staffrecruiter
churadata
regions
kuze_k
yuka_kakiuchi
kadokawaconnected
legaseed131111
tanashu
urbanxtechnologies
umzws
nishimuraryuma
ncdc
lemiorhan
morganepeng
bcantrill
panda_program
sachag
denniskardys
philnash
bkeepers
danielanewman
matthewcrist
skipperchong
kevinliebholz
