150 likes | 293 Views
Unearthing the rough diamonds of Census data. Census data structure. Dwellings Internet, number of bedrooms Families Family type, family income Persons Age, birthplace, marital status. DWELLINGS. FAMILIES. Persons. PERSONS. Relationship between levels. Dwelling
E N D
Census data structure Dwellings • Internet, number of bedrooms Families • Family type, family income Persons • Age, birthplace, marital status DWELLINGS FAMILIES Persons PERSONS
Relationship between levels Dwelling Number of bedrooms, Tenure type, Internet, Dwelling structure, etc. Family 1 Couple family with children Family 2 Lone parent family Peter 37 Frank 40 April 8 Mary 38 Jack 12 Luke 6
User defined fields • Creating new variables by tailoring and combining existing variables
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.
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.