Friday, January 9, 2009

Income by Occupation

Question

I have a faculty member looking for employment income by occupation from the 2006 Census. We found the following table, http://www.statcan.gc.ca/bsolc/olc-cel/olc-cel?lang=eng&catno=97-563-X2006063 , which gives the income by occupation, but only one occupation at a time can be chosen, and there are 720 occupations. I may just be overlooking something, but is there a table that will present the income for each occupation all at once?



I did find the numbers broken down by occupation for the 2001 census:



http://www.statcan.gc.ca/bsolc/olc-cel/olc-cel?lang=eng&catno=97F0019X2001003

Answer

1) You are accessing the table from the Statistics Canada website and viewing it in HTML format, which has limited capabilities. However, that same table (97-563-X2006063) can be accessed from the DLI FTP site and viewed in Beyond 20/20 format:

/ftp/dli/census/2006/Topic-based-tabulations/income-and-earnings/b2020

Once you have obtained the table from the FTP site, you can then drag and drop in the variables of interest to create the table that you need.

2) Go to the bottom of the table and choose the IVT link – this will open the file in Beyond 20/20. You can manipulate the table to cross show all occupations against income.

3) Go into IDLS (http://idls.ca), and do a file name search for 97-563-XCB2006062/97-563-XCB2006063

This will give you links to Beyond 20/20 table with national/provincial totals, and the one which you had found for Census Metropolitan Areas/Census Agglomerations), from which you can grab all occupations at once.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.