ACT Socio-economic Index for Individuals (SEIFI) 2006

This spread sheet shows all of the State Suburbs for the ACT and the % of the 15-64 year old population within each Socio-Economic Indexes for Individuals (SEIFI) IRSD group. The data used to create this information was the same as used in the research paper “Socio-Economic Indexes for Areas: Getting a handle on individual diversity within areas” by Phillip Wise and Rosalynn Mathews. It is advised that this paper is read to further develop an understanding of the concepts and caveats associated with the analytical output contained in the spreadsheet.

Group 1 – Approx. most disadvantage 20% of the 15-64 year old population

Group 2 – Approx. second most disadvantaged 20% of the 15- 64 population

Group 3 – Approx. second least disadvantaged 30% of the 15-64 year old population

Group 4 – Approx. least disadvantaged 30% of the 15-64 year old population

Please also note that not all ACT CDs have been included as their populations are below the ABS population count threshold (<3), those removed are:

• 8013801 in Reid

• 8012805 in Turner

• 8014302 in Kingston

• 8021701 in Unclassified ACT

• 8010110 in Bonner

• 8023401 in Tharwa

• 8010103 in Unclassified ACT

• 8014305 in Kingston

• 8014803 in Forrest

It should be noted that multiple Compact Discs of data make up this dataset, as a result the data for each suburb is distributed across several discs. This cccounts for the multiple rows of data that appear for each suburb.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"data-act-gov-au/act-socioeconomic-index-for-individuals-seifi-2006-3if8-4tcz\".\"act_socioeconomic_index_for_individuals_seifi_2006\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.