#Caritas
CARITAS PROJECT
A team of newbie Hackers called #AfamilyAffair. We are: 2 parents and 2 kids - the other 2 younger kids were just along for the ride. We were unable to get our mic to work to record the audio. We're trying to fix it so can hopefully upload a video with audio soon.
Project Overview
CARITAS is a project to illuminate how well the not-for-profit sector provides support to indigenous people on a range of important issues, initially juvenile offending, mental illness and homelessness. CARITAS achieves this by combining and comparing data from a range of Australian government data-sets and presenting the results in an accessible way on a map. Initially, the analysis is to be done state-on-state, although greater granularity would ultimately be desirable.
Data-sets Used
1. ACNC 2013 Annual Information Statement data from the Australian Charities and Not For Profit Commission
2. Youth Justice Detention Data from Health and Welfare
3. Aboriginal and Torres Strait Islander Population Projections, State/Territory from Australian Bureau of Statistics
4. Census Information from Australian Bureau of Statistics
5. Hospitalisations for principal diagnosis of mental-health-related conditions, by Indigenous status, sex and state/territory, Australia, 2011–12 to 2012–13 from Australian Institute of Health and Welfare
6. Rate of service use(a) by specialist homelessness services clients, by state and territory, remoteness and Indigenous status, 2012–13, adjusted for service non-response from Australian Institute of Health and Welfare
Method
The ACNC data is enriched by calculating for each charity a staffing effectiveness factor based on staff numbers as a means of comparing how much capacity each charity has to tackle a given issue. This is achieved by totalling the number of full time employees, half the number of part-time employees and half the number of volunteers and dividing by the number of states in which the charity is active to achieve a rough estimate of the number of staff a particular charity can bring to bear per state. If a charity has not specified which state(s) it is active in, it has been excluded from the analysis (this only applied to a very small proportion of the almost fifty thousand charities registered).
Separately, figures for the general and indigenous populations of each state were extracted for 2013 and the proportion of the indigenous population compared to the general was calculated.
Additionally, figures were calculated for the following:
- an average nightly population was calculated for the last six quarters available (2012 and first half of 2013) for the total number of indigenous males and females (aged 11-17), sentenced and unsentenced for each state;
- total figures for each state for mental-health-related hospitalisations of indigenous people were extracted for 2013;
- total figures by state were extracted for uses of homelessness services by indigenous persons.
Excel logic algorithms were then used to identify which charities focussed on each of the three issues in which state and to then sum the total of charity staffing capacity for each issue in each state. If the charity indicated that it focussed on indigenous people specifically, the staffing effectiveness factor was given additional weighting in line with all of the charity’s efforts being devoted to indigenous persons. The results were summarised in tabular format using a factor between 1 and 100 where 100 represented the factor for the state where the greatest capacity was available.
The results of the analysis were then exported to mapline.com in order to produce a graphical representation of the data. Colour was used varying from red through orange and yellow to green to represent gradation from less to more staffing capacity.
Results https://www.dropbox.com/s/el0gj9d5cvtlmap/GovHack%20Caritas%20Entry%20Ro...
The formatting for this chart is not uploading as we'd like it. Please see the above link to view our chart.
NSW
Vic
Qld
WA
SA
Tas
ACT
NT
Young Offenders
Measure of charitable assistance available as value between 1 and 100
4.08
38.63
4.22
2.63
9.85
100.00
30.89
2.78
Mental Health
Measure of charitable assistance available as value between 1 and 100
3.84
14.18
3.60
2.69
4.80
39.34
100.00
6.55
Homelessness
Measure of charitable assistance available as value between 1 and 100
22.52
27.02
16.50
23.07
30.93
90.59
100.00
15.66
Young Offenders
We are unable to insert our photo here. Please see the above link to see the map indicating the stats for Young Offenders.
Mental Health
We are unable to insert our photo here. Please see the above link to see the map indicating the stats for Mental Health.
Homelessness
We are unable to insert our photo here. Please see the above link to see the map indicating the stats for Homelessness.
Technology used:
Webflow
YouTube video editor
#OnlineParticipants for GovHack 2015. Come tweet with us - Join in the converstation on Twitter with #GovHack and #GovHackCanberra and #AfamilyAffair! We'd love to hear from other online and virtual participants.