#Caritas

box
Team Name: 
A Family Affair

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:

  1. 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;
  2. total figures for each state for mental-health-related hospitalisations of indigenous people were extracted for 2013;
  3. 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. 

 

Datasets Used: 
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

Local Event Location: