Friday, January 14, 2011

Updated Products - National Symmetric Input-Output Tables

National Symmetric Input-Output Tables - Aggregation Level L (15-208-XCB) 1997-2003

National Symmetric Input-Output Tables - Aggregation Level L (15-208-XCB; http://www.statcan.gc.ca/bsolc/olc-cel/olc-cel?catno=15-208-X&lang=eng) data for 1997 to 2002 have been added to the DLI FTP site and website.

We have also received new versions of the 2003 data files. Please replace the old versions of these files (2003-national-symmetric-total.xls and 2003-symétrique-nationale-total.xls) with 2003.zip

WEB: http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/io-es-eng.htm
FTP: /DissFTP/dli/DLI Coll._Other prod/Input-Output-Tables/15-208-xcb

Thank you.

Updated Products - FIUC

Financial Information of Universities and Colleges Survey (FIUC) - 2008-2009

Final data files for 2008-2009 for the Financial Information of Universities and Colleges Survey have been added to the DLI FTP and website.

The fiuc-ifuc_ver04.zip file has been renamed fiuc-ifuc_ver05.zip

The following files have been added to fiuc-ifuc_ver05.zip:
2008-2009 - fiuc data - public - englishv2.xls
2008-2009 - données ifuc - publique - françaisv2.xls

These files replace: (please delete these files)
2008-2009 - fiuc data - public - english.xls
2008-2009 - données ifuc - publique - français.xls

The following file has also been added: fiuc database 2008-2009.zip

WEB: http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/fiuc-ifuc-eng.htm
FTP: /DissFTP/dli/DLI Coll._Other prod/Financial Information of Universities and Colleges Survey - fiuc

Thank you.

Internet Use by Children

Question

Does anyone know, offhand, if stats are collected on internet usage by children under 15? I can find all sorts of surveys, but the lowest age I can find is 15.

Answer

The National Longitudinal Survey of Children and Youth (NLSCY) collected data on computer and internet use by children under 15. You can locate examples of the types of questions used to collect these data by doing a quick search for "Internet" in the questionnaires for NLSCY cycle 7 (http://www.statcan.gc.ca/cgi-bin/imdb/p2SV.pl?Function=getInstrumentLink&SurvId=4450&SurvVer=1&InstaId=16044&InstaVer=7&lang=en&db=imdb&adm=8&dis=2).

NLSCY microdata are available through the Research Data Centres (http://www.statcan.gc.ca/rdc-cdr/index-eng.htm) and custom tabulations can be produced on request on a cost recovery basis (I can refer you to an Account Executive in our Toronto regional office if custom tables are of interest). Public use microdata files for this survey haven't been produced since the late 90's due to confidentiality reasons as this is a longitudinal survey.

I also looked at the documentation for the Canadian Internet Use Survey (2007) and General Social Survey cycle 19 on time use but the target populations for these surveys appear to be too old for your needs.

I hope that this is helpful.

Census Data: Income by Educational Attainment

Question

I am new to this service, so any help on the following will be greatly appreciated. I have a student looking for 2006 census data that will cover all of the following:

• Sex (M/F)
• Individual ages (15, 16, 17, – 64)
• Employment (including self-employment)
• Educational level
• Individual income

Answer
The following 2006 Census topic-based tabulations may help the student.

Employment Income Groups (23) in Constant (2005) Dollars, Age Groups (7A), Highest Certificate, Diploma or Degree (5), Work Activity in the Reference Year (3) and Sex (3) for the Population 15 Years and Over of Canada, Provinces, Territories, Census Metropolitan Areas and Census Agglomerations, 2000 and 2005 - 20% Sample Data (97-563-XCB2006054) http://www12.statcan.gc.ca/census-recensement/2006/dp-pd/tbt/Rp-eng.cfm?TABID=1&LANG=E&A=R&APATH=3&DETAIL=0&DIM=0&FL=A&FREE=0&GC=01&GID=837928&GK=1&GRP=1&O=D&PID=94595&PRID=0&PTYPE=88971,97154&S=0&SHOWALL=0&SUB=0&Temporal=2006&THEME=81&VID=0&VNAMEE=&VNAMEF=&D1=0&D2=0&D3=0&D4=0&D5=0&D6=0

Total Income Groups (23) in Constant (2005) Dollars, Age Groups (7A), Highest Certificate, Diploma or Degree (5) and Sex (3) for the Population 15 Years and Over of Canada, Provinces, Territories, Census Metropolitan Areas and Census Agglomerations, 2000 and 2005 - 20% Sample Data (97-563-XCB2006005)
http://www12.statcan.gc.ca/census-recensement/2006/dp-pd/tbt/Rp-eng.cfm?LANG=E&APATH=3&DETAIL=0&DIM=0&FL=A&FREE=0&GC=0&GID=0&GK=0&GRP=1&PID=94188&PRID=0&PTYPE=88971,97154&S=0&SHOWALL=0&SUB=0&Temporal=2006&THEME=81&VID=0&VNAMEE=&VNAMEF=

Employment Income Statistics (4) in Constant (2005) Dollars, Work Activity in the Reference Year (3), Immigrant Status and Period of Immigration (10), Age Groups (5A), Highest Certificate, Diploma or Degree (5) and Sex (3) for the Population 15 Years and Over With Employment Income of Canada, Provinces, Territories, Census Metropolitan Areas and Census Agglomerations, 2000 and 2005 - 20% Sample Data (97-563-XCB2006059)
http://www12.statcan.gc.ca/census-recensement/2006/dp-pd/tbt/Rp-eng.cfm?TABID=1&LANG=E&A=R&APATH=3&DETAIL=0&DIM=0&FL=A&FREE=0&GC=01&GID=837928&GK=1&GRP=1&O=D&PID=96279&PRID=0&PTYPE=88971,97154&S=0&SHOWALL=0&SUB=0&Temporal=2006&THEME=81&VID=0&VNAMEE=&VNAMEF=&D1=0&D2=0&D3=0&D4=0&D5=0&D6=0

Employment Income Statistics (4) in Constant (2005) Dollars, Work Activity in the Reference Year (3), Age Groups (5A), Generation Status (4), Visible Minority Groups (15), Highest Certificate, Diploma or Degree (5) and Sex (3) for the Population 15 Years and Over With Employment Income of Canada, Provinces, Territories, Census Metropolitan Areas and Census Agglomerations, 2000 and 2005 - 20% Sample Data (97-563-XCB2006060)
http://www12.statcan.gc.ca/census-recensement/2006/dp-pd/tbt/Rp-eng.cfm?TABID=1&LANG=E&A=R&APATH=3&DETAIL=0&DIM=0&FL=A&FREE=0&GC=01&GID=837928&GK=1&GRP=1&O=D&PID=96280&PRID=0&PTYPE=88971,97154&S=0&SHOWALL=0&SUB=0&Temporal=2006&THEME=81&VID=0&VNAMEE=&VNAMEF=&D1=0&D2=0&D3=0&D4=0&D5=0&D6=0

Additional topic based tabulations are available under: http://www12.statcan.gc.ca/census-recensement/2006/dp-pd/tbt/index-eng.cfm and detailed definitions of 2006 Census concepts are available in the 2006 Census dictionary (http://www12.statcan.gc.ca/census-recensement/2006/ref/dict/index-eng.cfm).

The student could also consider using the 2006 Census public use microdata file (PUMF) but it won't contain data for individual ages (these aren't available for confidentiality reasons), only age groups. The PUMF is available on the DLI FTP site and can be used with a statistical analysis application such as SPSS or SAS. It can also be consulted on the Statistics Canada Nesstar site at www62.statcan.ca

Additional data may be available on a cost recovery basis. If this is of interest to the student, I would be happy to refer you to an Account Executive in our Halifax regional office who can confirm what tables can be produced on a custom basis and provide a cost estimate for the tables (the minimum cost for semi-custom census products is $305 and custom census tabulations start at $1115).

National Graduates Survey 2000

Question

DLI has the NGS follow-up survey; class of 2000, but not the NGS 2000?

Why is this?

Thanks. We've had a request for it.

Answer

The DLI collection includes a public use microdata file (PUMF) for the Follow-up of Graduates Survey - Class of 2000 but we don't have one for the National Graduate Survey (NGS) - class of 2000 as a PUMF wasn't produced for the National Graduate Survey (NGS) - class of 2000. We asked our education contacts about this and they explained that "It was decided to produce one PUMF for the class of 2000 that included both the NGS and the FOG in order to produce a more comprehensive PUMF for the FOG-Class of 2000. If a NGS PUMF were to have been released it would have reduced significantly the breadth of information that was released on the FOG."

Geography Questions - # of Sub-Geographies per CD/CSD

Question

Is there a way to know for any given CD or CSD how many DAs, EAs, CTs, FSAs, Postal codes they contain? I was looking at the StatCan website and I could not find that information.

I am trying to see how many of these sub-geographies there are for 32 CDs/CSDs in Canada.

Answer

This can be determined by analyzing the PCCF. Select SLI=1, RET_DATE=19000001 and the 32 CDs/CSDs you want. Then aggregate over the different levels of geography you want.

Updated Products - SLID 2008

Survey of Labour and Income Dynamics (SLID) 2008 - Public Use Microdata File (PUMF)

The Public Use Microdata File (PUMF) for the Survey of Labour and Income Dynamics (SLID) 2008 is now available on the DLI FTP and website.

"The cross-sectional public-use microdata file for the Survey of Labour and Income Dynamics (SLID) is a collection of income, labour and family variables on persons in Canada and their families. This file includes many safeguards to prevent the identification of any one person.
Although often referred to as a single file, the SLID public-use microdata file is actually four separate files: key, person, economic family and census family.

The person file contains identifier data, which allows a researcher to group persons into households, economic families and census families, as well as link each of these files together." (http://www.statcan.gc.ca/bsolc/olc-cel/olc-cel?catno=75M0010XCB&lang=eng)

WEB: http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/slid-edtr/slid-edtr2008-eng.htm
FTP: /DissFTP/dli/DLI Coll._Other prod/Survey of Labour and Income Dynamics - slid/2008

Thank you.