Transcript Unearthing the rough diamonds of Census data

Unearthing the rough diamonds
of Census data
Census data structure
Dwellings
Internet, number
of bedrooms
DWELLINGS
Families
Family type, family
income
FAMILIES
Persons
Persons
PERSONS
 Age, birthplace,
marital status
Relationship between levels
Dwelling
Number of bedrooms, Tenure type, Internet, Dwelling structure, etc.
Family 1
Family 2
Couple family with children
Mary
38
Peter
37
Lone parent family
Jack
12
Frank
40
April
8
Luke
6
User defined fields
• Creating new variables by tailoring and
combining existing variables
P
P
P
D
Example 1
P
P
Relationship in
household
Indigenous status
D
Indigenous
household
Example 1
Example 2
P
Age
P
(copy)
Relationship
in household
(filter)
F
Age of oldest
non-dependent
child
Example 2
Example 2
Example 3
Housing Utilisation
The Canadian National Occupancy Standard (CNOS)
• no more than two persons per bedroom
• children less than 5 years of age and of different sexes may
reasonably share a bedroom
• children less than 18 years of age and of the same sex may
reasonably share a bedroom
• single household members aged 18 years and over should have a
separate bedroom, as should parents or couples
• a lone person household may reasonably occupy a bed sitter
Dwellings where this standard cannot be met are considered to
be overcrowded.
Example 3
P
P
Relationship
in household
Sex
D
P
Age
D
Housing
Utilisation
Number of
bedrooms
Example 3
Mining the Census diamonds
• Do it yourself - Census TableBuilder
– Basic (free)
– Pro $
• Ask ABS to do it - Information Consultancy
Service $
• Build it yourself - Census Datapacks (free
download)
Questions
?
Come and meet us in the Connect space.