NAICS?%20YIKES!

1
NAICS? YIKES!

• (North American industry classification system
  (NAICS)?
• Yearly index of constant (k) dollar estimates
  (YIKES)!)
• Jeff Moon, Queens (moonj_at_post.queensu.ca) Laine
  Ruus, University of Toronto (laine.ruus_at_utoronto.c
  a)
• OLA 2006/02/03
• http//www.chass.utoronto.ca/laine/misc/naics_yik
  es.ppt

2
Overview

• Finding what youre looking for
• Searching www.statcan.ca and Bibliocat
• Decoding Stats Can catalogue numbers
• Finding what things mean (definitions)
• Finding classifications and concordances
• Getting access to it
• Levels of access
• Getting to the DSP www collection
• Whats not available on the DSP www site

3
Overview (contd)

• And your question is.?
• Some things we learned this year
• CPI index year versus basket
• Census community profiles versus census profiles
  versus profiles on E-stat
• Health region census profile

4
Searching -- www.statcan.ca

5
(No Transcript)
6
(No Transcript)
7
The Daily
CANSIM
Census
8
(No Transcript)
9
(No Transcript)
10

• 75-001-XIE
• 75 subject group (Employment/Labour)
• 001 unique number for the product
• X preliminary, revision, supplement etc
• status of the product (Xnot applicable)
• I medium Internet/pdf format
• E language (EEnglish)

11
(No Transcript)
12
(No Transcript)
13
(No Transcript)
14
More on decoding Stats Can Product Codes
Table of media and language codes

• Source At the bottom of the STC Daily New
  products listing, e.g.
• http//www.statcan.ca/Daily/English/060119/p060119
  .htm

Last published overview of codes 1997 Stat Can
catalogue
15
Where are product codes used?

• Used
• In the Stats Can Products and services database
• In the Daily
• In Bibliocat (STC Library Catalogue)
• On Stats Can publications (print and electronic)
• Searchable
• On Stats Can web site
• In Stats Can Products and Services database
• In the Daily
• In Bibliocat
• In CANSIM I on www.chass.utoronto.ca (DLI only)

16
Speaking of Bibliocat
17
Speaking of Bibliocat
Use BiblioCat to search for older publications
and resources. Alternatives include the 1994 STC
catalogue and the Historical Catalogue of
Statistics Canada Publications, 1918 1980.
18
Finding what things mean (definitions)
http//www.statcan.ca/english/concepts/index.htm
http//www4.statcan.ca/english/thesaurus/index.htm

• Also look in Statistics Canada print/print-like
  (PDF) products

19
Finding what things mean (contd)

• Note the thesaurus is well hidden on the STC web
  site, search the web site for it.
• See also other web sites
• Economic concepts
• http//canadianeconomy.gc.ca/english/economy/conce
  pts.html
• Glossary of frequently used financial and
  economic terms
• http//www.fin.gc.ca/gloss/gloss-e.html
• Thesauri and controlled vocabularies
• http//www.collectionscanada.ca/8/4/r4-280-e.html

20
Classifications and concordances

• Classifications
• Available from Definitions, data sources and
  methods
• Outline the hierarchical structure of non-numeric
  concepts
• Indicate what is included excluded at each
  level of the classification
• Updated to accommodate new goods, services,
  concepts, definitions
• Eg NAICS 1997, NAICS 2002, NAICS 2007

21
(No Transcript)
22
(No Transcript)
23
Classifications and concordances (contd)

• Concordances
• Cross-walk between classifications, ie outline
  which categories in one classification are the
  same as/different from which categories in
  another classification
• Especially important when comparing categories
  over time

24
(No Transcript)
25
(No Transcript)
26
SOC 1980
NOC 1992
27
Changes in classifications over time
28
Getting access

• Levels of access
• Access to the DSP collection
• Whats not in the DSP collection

29
Levels of access

• Who has access to what, where, when, and at what
  cost?
• One view is Chuck Humphreys continuum of access
  approach, outlined at
• http//www.statcan.ca/english/Dli/continuumofacces
  s.htm

30
http//www.statcan.ca/english/Dli/continuumofacces
s.htm
Free, Unrestricted
Continuum of Access http//www.statcan.ca/english/
Dli/continuumofaccess.htm Chuck Humphrey, U of
Alberta Data Library
31
Levels of access for Census 2001

• Level 1
• 'public good access
• on the STC web site
• available to the entire general public
• Level 2
• "public good - expanded access
• more detailed data (eg lower geography)
• available to DLI, DSP, provincial focal points,
  funding federal departments
• IP address controlled

32
Levels of access for Census 2001 (contd)

• Level 2
• DLI (via DLI ftp site)
• geography to DA and FSA levels
• includes spatial data products geographic
  reference files (eg Postal code conversion file)
• selected semi-custom products (eg Travel to work
  files) and public use microdata files
• Level 3
• has the most detail (geography and
  characteristics)
• for internal STC employees only

33
Whats not on the DSP web site

• Many statistical (non-pdf) products
• eg Annual demographic statistics Excel files
• ESAS, Employment dynamics, Small area data,
  Canadian Centre for Justice Statistics files,etc.
• Gradually moving to free STC web access, eg
• Health indicators database
• Human activity and the environment
• Health regions cd-rom
• Public use microdata files
• Semi-custom and custom products

34
Some things we learned this year

• CPI index year versus basket
• Census profiles community profiles, electronic
  profiles, versus E-stat profiles
• Profile of health regions (2001 census)

35
CPI index year versus basket
36
Baskets
37
Baskets

• About 600 goods services priced each month
  (incl. GST PST)
• Weights assigned to reflect importance of the
  items in the basket
• 1 change in price of milk affects index more
  than 5 change in price of tea
• Updated about every 4 years
• 1992 basket was first to include GST
• 2001 basket contains Internet service charges,
  previous baskets didnt

38
Index years
39
Base (index) years

• The CPI reflects prices relative to a base year
• Dec. 2002 price of Internet access
  (Ontario)100.0
• Dec. 2005 price of Internet access (Ontario)
  97.0
• Ie price fell ((97.0-100.0/100.0)100)3 between
  the end of 2002 and end of 2005
• We dont know what the prices were at those to
  times, just that the price came down
• Average prices of foods, gasoline and tobacco in
  current basket in 62-001-XIB

40
How do I convert an index to another base year?

• Compute a ratio new index at time1/old index
  at time1. Eg
• new index has base year 1995100 the old index
  has base year 1985100
• the index value for year 1995 (1985100) was
  127.5 the value for year 1995 (1995100) is 100
• the ratio is (100/127.5).7843
• Multiply values on the old index by .7843 to
  convert them to the new base year (1995100).

41
Conversion factor (100/127.5)0.7843
New series (old series x conversion factor)
42
Census profiles many flavours

• There are 5 main products you should be aware of
  (2001 census)
• Community profiles
• Electronic profiles
• Census profiles on the E-stat web site
• Profile of health regions
• Topic-based tabulations for additional
  breakdowns (in addition to gender)

43
(No Transcript)
44
Community profiles (2001)

• available to the public (on STC web site)
• main characteristics only (about 190
  characteristics per geographic area)
• many are percentages (rather than counts)
• breakdowns by geography only
• geography includes provinces/territories,
  counties (CD), municipalities (CSD), CMAs and
  health regions
• comparison with province level statistics is
  default
• output print, or comma-separated file (with no
  extension)

45
(No Transcript)
46
(No Transcript)
47
(No Transcript)
48
(No Transcript)
49
if Stats Can has not registered your IP
address (level 1 access)
50
if Stats Can has registered your IP
address (level 2 access)
51
Electronic profiles

• Available to the public STC web page DSP
• About 1700 characteristics per geographic area
• Many characteristics broken down by gender
• Wide range of available geographies, from
  province to census tract. (DA and FSA are DLI
  only)
• Comparison with other geographies manually
• Output comma-separated file, text file, or
  Beyond 20/20

52
estat.statcan.ca
53
(No Transcript)
54
Profiles on E-stat

• available to the public under DSP
• includes all census profile characteristics
  (1700)
• geography by county (CD), municipality (CSD), CMA
  and census tract only
• select by postal code capability (census-tract
  level profiles)
• widest range of output products, including
  interactive mapping
• includes Census of Agriculture products

55
Profile of health regions (2001)

• Not linked to 2001 census profiles web pages
• Access from Health regions web page
• About 1250 census characteristics
• Beyond 20/20 format

56
(No Transcript)
57
And your question is?