|Segment 6: Census product - Census Tables
Census Tables are very useful when you need detailed data on a particular Census topic for a particular area. They are sourced from Community Profiles but provide an easier way to look at the tables. Note that Census Tables and Community Profiles are pre-formatted tables and the same list of variables is used for all geographic areas. There are also Census variables with full classification tables available. These tables are more detailed than the standard Census Tables. Types of variables include: Industry of Employment, Occupation, Birthplace and Language spoken at home.
Start at the ABS homepage, and click on 'Census Data' on the left hand navigation menu. Find 'Census Tables' on the page and choose which year’s Census data you want displayed. You can see that unlike other Census products, you have two search options for Census Tables: find data by either topic or location. Let’s search by location and click ‘Next’. Please note you can select different search methods using the tabs above. Type in your chosen area of interest. In this example we will type in 'Parramatta' and click ‘Search’ to continue. Select a specific location from the search results list. We will choose Parramatta LGA in this example. Once a selection has been made, a map appears to check it is the area you wanted. If it is, click on ‘Select Topic’.
Before choosing a topic, you can choose a count method. In 2006, primary output is based on Place of Usual Residence, which is the default setting. Other count method options are Location on Census night and Place of Employment. When choosing a count method note that Place of usual residence generates all person variables; however, the location on Census night count method generates variables based on dwellings and households. For example – internet and computer usage. We will leave the default setting as our preferred count method. Select a topic from the list. For this example we’ll choose Birthplace and then from the data list we will choose Country of birth by Age and Sex. Click on View Census Table.
To open the Census Table in Excel, go to the ‘Downloads Tab’ and click on the ‘Free Download’ file. You can either choose to Save or Open the file. Save the file if you expect to come back to it again. Otherwise you can open and save the file later. This is what your table will look like in Microsoft Excel: you are presented with a list of countries of birth for the Local Government Area of Parramatta. The table provides a breakdown by Sex and Age. If you want to view a full classification table, go back to the Topics page and select your topic of interest from the list .
To continue with our example we will once again select Birthplace. Then select a full classification table if it’s available from the data list. To continue, click on ‘View Census Table’. To open the Census Table, go to the ‘Downloads' tab and click on the ‘Free Download’ link on the right hand side of the page. Once again you can Save or Open the file. The table has a more detailed list of the countries of birth for people living in Parramatta; however, a breakdown by age is not provided for the full classification table.