Sources for Jobs Data

1
Sources for Jobs Data

• Planning 714 Urban Spatial Structure
• Jim Ovitt
• Government Data Librarian
• jim_ovitt_at_unc.edu

2
What Well Cover

• A Few Definitions
• Irritating Issues
• Sources to Help with Your Assignment
• REIS
• QCEW
• County Business Patterns
• Leave Some Time to Work

3
What data are out there?

• Demographics
• Employment
• Unemployment
• Labor Force
• Earnings / Payroll
• Occupation

4
Well look at

• Employment and wages
• County level (and MSA)
• By Place of Work
• Helps understand economic specialization

5
A Couple of Definitions

• By Place of Residence
• By Place of Work

6
Chatham County, NC2005 Employment

• By Place of Residence
• 29,678 people living in Chatham Co. are employed
  (source LAUS)
• By Place of Work
• There are 16,704 jobs in Chatham Co. (source
  QCEW)

7
Place of Residence Data

• Answers Questions Like
• How many people living in the study area are
  employed?
• How many unemployed?
• Is the labor force growing?
• What are the demographics of the labor force, the
  educational level?

8
Place of Work Data

• Answers Questions Like
• How many jobs exist in the study area?
• In which industries?
• Which sectors are growing fastest?
• Are the new jobs low or high paying?

9
One More Definition

• Establishment
• An establishment is a single physical location
  at which business is conducted or services or
  industrial operations are performed. It is not
  necessarily identical with a company or
  enterprise, which may consist of one or more
  establishments. - Census

10
Irritating Issues

• Disclosure
• Some data suppressed completely
• Some data reported in ranges
• Often reported for central county but NOT MSA
• MSA definitions
• Industry classification
• SIC NAICS

11
Irritating Issues SIC NAICS

• SIC Standard Industrial Classification
• 1930s 1997 with revisions
• 10 Divisions
• NAICS North American Industry Classification
  System
• 1997 -gt with revisions in 2002 07
• 20 Sectors
• Hierarchical Code

12
(No Transcript)
13
Irritating Issues SIC NAICS

• Many industries are comparable but not easily
• Sectors are not directly comparable
• NAICS / SIC table
• So, there are breaks in time series for all the
  sources we will look at

14
For More on SIC NAICS

• NAICS Main page
• http//www.census.gov/epcd/www/naics.html
• 2002 NAICS look up
• http//www.census.gov/epcd/naics02/naicod02.htm
• NAICS 97 and SIC Correspondence table
• http//www.census.gov/epcd/www/naicstab.htm
• NAICS 97 and SIC Bridge table
• http//www.census.gov/epcd/ec97brdg/

15
Regional Economic Accounts (aka REIS) - BEA

• Table CA25 Total full-time part-time
  employment by industry sector. Annual averages.
• Broadest coverage
• Includes wage and salary jobs, proprietors, farm,
  non-farm, private, government, military.

16
Regional Economic Accounts (aka REIS) - BEA

• Sources
• State and federal unemployment insurance data,
• Dept. of Defense,
• Dept. of Agriculture,
• Railroad Retirement Board,
• IRS

17
Regional Economic Accounts (aka REIS) - BEA

• Very easy to see employment by sector for several
  decades
• 1969 - 2005
• http//www.bea.gov/bea/regional/reis/default.cfm
• CD-ROM for 2001 has 1999 msa definitions
• EDOCS C59.24969-2001/CD
• N.G. for Miami and Hartford

18
Quarterly Census of Employment Wages (BLS)

• Number of employees, establishments, total wages,
  average weekly wage, average annual pay, by
  industry.
• Excludes the military, self-employed,
  proprietors, domestic workers, unpaid family
  workers, and railroad workers. Includes farm
  workers but not farm owners.
• Source State and federal unemployment insurance
  data
• 1997-2006 Web-based extraction

19
Quarterly Census of Employment Wages (BLS)

• Track a more detailed industry
• Location quotient calculator determine
  specialization
• But disclosure issue
• http//www.bls.gov/cew/home.htm

20
County Business Patterns(Census)

• Wage Salary Mid-March employment, number of
  establishments by employment size class, annual
  payroll, by industry.
• Excludes self-employed, employees of private
  households, railroad employees, agricultural
  production employees, and most government
  employees.
• Source Establishment surveys and administrative
  records.

21
County Business Patterns(Census)

• Another view of specialization
• Tracking low pay jobs
• But disclosure issue

22
County Business Patterns(Census)

• CBP Main Page
• http//www.census.gov/epcd/cbp/view/cbpview.html
• Web interface 1994 1997 SIC 1998 -2005 NAICS
• American Factfinder
• http//www.factfinder.census.gov
• 2004-2005 only, but very easy to see detailed
  industry
• Use quick reports for 1 county or msa
• For multiple counties use CBP GAS County
  Business Patterns 2005 and filter rows (drop
  down near top)

23
County Business Patterns(Census)

• CBP via State of the Cities Data System
• http//socds.huduser.org/CBPSE/CBPSE_Home.htm?
• Has CBP by SIC estimates for 1992-2002
• By MSA - 1999 MSA definitions
• Good for browsing low pay jobs

24
Some Low Paying Industries by NAICS

• NAICS 452 - General merchandise stores
• NAICS 445 - Food and beverage stores
• NAICS 623 - Nursing and residential care
  facilities
• NAICS 448 - Clothing and accessories stores
• NAICS 721 Accommodation
• NAICS 722 - Food services and drinking places

25
Some Low Paying Industries by SIC

• SIC 5300 General Merchandise Stores
• SIC 5400 Food Stores
• SIC 5600 Apparel and accessory stores
• SIC 5800 Eating and Drinking Places
• SIC 7000 Hotels and Other Lodging Places
• SIC 8300 Social Services

26
More!

• Local Employment Dynamics QWI
• http//lehd-test1.did.census.gov/led/datatools/qwi
  -online.html
• Incomplete, but great data if study area is
  included
• Non-Employer Statistics
• Mostly self-employed
• http//www.census.gov/epcd/nonemployer/