�ݺ�ߣ

Help! I’m an Accidental Government Information Librarian presents… the Economic Census NCLA Government Resources Section June 15, 2011

How much of your reference work is done in support of regional economic development?

Making Cities Stronger Public Library Contributions to Local Economic Development The Making Cities Stronger report, which is based on data from a national survey and case studies from nine sites across the country, provides new insights into the economic impact of public libraries in American cities. The report highlights ways in which library programming in the areas early literacy, employment services, and small business development, contribute to local economic development strategies. Source: The Urban Institute 2007 CARLOS A. MANJARREZ , JESSICA CIGNA , BEATA BAJAJ www.urban.org Mary G. Scanlon

Outline Definition & description Benefits and limitations How to find data Where is it? How is it organized What’s included? Case study (apply what we’ve learned) Q&A Mary G. Scanlon

Definition & Description Data sets comprised of domestic economic data organized by industry and geography Collected and published by the Bureau of the Census Conducted every 5 years in years ending in ‘2’ and ‘7’ Self-reported, but mandatory Mary G. Scanlon

Benefits & Limitations Benefits: Free Reliable Data available at varying levels of granularity From nation to zip code Current – kinda, sorta Mary G. Scanlon

Sector States MA's Counties Places ZIP Codes 21: Mining X 22: Utilities X X 23: Construction X 31-33: Manufacturing X X X X 42: Wholesale Trade X X X X 44-45: Retail Trade X X X X X 48-49: Transportation and Warehousing X X 51: Information X X X X 52: Finance and Insurance X X 53: Real Estate and Rental and Leasing X X X X 54: Professional, Scientific, and Technical Services X X X X X 55: Management of Companies and Enterprise X 56: Admin. and Support and Waste Management and Remediation Services X X X X X 61: Educational Services X X X X X 62: Health Care and Social Assistance X X X X X 71: Arts, Entertainment and Recreation X X X X X 72: Accommodation and Food Services X X X X X 81: Other Services (Except Public Administration) X X X X X

Benefits & Limitations Limitations: Data dribbles out Domestic operations, only Companies with employees Some industries excluded Mary G. Scanlon

Roll-out Dates for 2007 Economic Census Mary G. Scanlon

Excluded Industries 11 482 525 6111-6113 8131 81393 81394 814 92 Agriculture, forestry Rail transportation Funds, trusts Schools & colleges Religious organizations Labor Unions Political organizations Private Households Public administration Mary G. Scanlon

Where to Find the Data U. S. Bureau of the Census at www.census.gov Mary G. Scanlon

How the Data is Organized & Reported By primary industry North American Industrial Classification System Introduced in 1997 Replaced SIC codes (Standard Industrial Classification) Mary G. Scanlon

NAICS North American Industrial Classification System Classification system for industry groups Numerical Hierarchical: the longer the number, the more detailed the category Mary G. Scanlon

NAICS North American Industrial Classification System 51 Information 511 Publishing Industries (except Internet) 5111 Newspaper, Periodical, Book, and Directory Publishers 51111 Newspaper Publishers 511110 Newspaper Publishers 51112 Periodical Publishers 511120 Periodical Publishers 51113 Book Publishers 511130 Book Publishers Mary G. Scanlon

NAICS 2007 Sectors (Sample) 23 31 - 33 42 44 - 45 48 – 49 51 52 71 72 Construction Manufacturing Wholesale trade Retail trade Transportation & warehousing Information Finance and Insurance Arts, Entertainment and Recreation Accommodation and Food Service Mary G. Scanlon

Terms & Considerations Companies vs. Establishments Value of Shipments, Receipts, Contracts Privacy issues for employers Mary G. Scanlon

Questions? Are you ready to move into the case study? Mary G. Scanlon

Case Study Earlier this month, the NC legislature considered a bill that would protect pharmaceutical companies from liability in lawsuits. A patron wants to know, how important is the pharmaceutical industry to NC? Mary G. Scanlon

Case Study From data to information: Industry size Industry growth rate Number of employees Payroll Mary G. Scanlon

Case Study - Process Identify NAICS code Locate data Convert data to information Mary G. Scanlon

Identify the NAICS Code Mary G. Scanlon

Locate the Data Mary G. Scanlon

NC Pharmaceutical Industry From data to information NC Industry size: $18.5 Bil (2007) Number of people employed: 9,600 Payroll: $500,000 Mary G. Scanlon

Tools: Print & Download Mary G. Scanlon

In Excel Mary G. Scanlon Geography Number of employer establishments Number of paid employees for pay period including March 12 Annual payroll ($1,000) Employer sales, shipments, receipts, revenue, or business done ($1,000) United States 991 158,531 11,843,186 142,876,257 California 170 26,762 1,927,014 20,082,378 North Carolina 28 9,599 499,745 18,506,226 New York 76 12,218 676,150 16,295,750 New Jersey 87 18,654 1,655,750 12,066,809 Illinois 30 18,691 2,325,540 9,148,072 Massachusetts 38 7,442 678,752 4,962,618 Michigan 25 5,884 406,999 4,038,576 Texas 39 3,798 180,762 3,684,900 Missouri 33 4,382 312,315 2,959,825 Tennessee 15 2,180 155,512 2,862,393 Ohio 21 3,746 241,929 1,624,498 Florida 45 6,173 355,116 887,759 Kansas 11 1,736 105,335 861,405 Utah 26 2,474 143,511 859,318 Minnesota 18 1,196 73,348 586,967 Arizona 18 726 34,845 513,292 Iowa 14 801 46,916 223,190 Kentucky 7 477 D 171,435 Alabama 8 462 20,849 154,957 Wisconsin 14 300 16,194 121,572

NC Pharmaceutical Industry From data to information North Carolina is the nation’s second largest producing state NC accounts for 13% of all domestic production Mary G. Scanlon

NC Pharmaceutical Industry From data to information Industry growth between 2002 and 2007: Value of shipments: 31% Payroll: 6% Mary G. Scanlon

NC Pharmaceutical Industry From data to information Review of Information in the Quick Report: Industry size: $18.5 Bil Number of people employed: 9,600 Payroll: $500,000 NC is the nation’s second largest producing state NC accounts for 13% of all domestic production Industry growth between 2002 and 2007: Value of shipments: 31% Payroll: 6% Mary G. Scanlon

Locating Data Beyond the Quick Report Mary G. Scanlon

Information Available in the Detailed Data Sets Selection of HR-related items reported: Number of employees Annual payroll Total fringe benefits Employer's cost for health insurance Employer's cost for defined benefit pension plans Employer's cost for defined contribution plans Employer's cost for other fringe benefits Mary G. Scanlon

Information Available in the Detailed Data Sets Selection of operational items reported: Cost of purchased fuels Purchased electricity ($) Quantity of electricity purchased (kWh) Capital expenditures: computer and data processing equipment Advertising and promotional services Purchased professional and technical services Mary G. Scanlon

Information Available in the Detailed Data Sets Cost Structure and Key Inputs: Wages, salaries and benefits Materials Capital equipment Professional services Marketing and advertising Mary G. Scanlon

Information Available in the Detailed Data Sets Uses of pro-forma financial statements and industry ratios: Benchmark company performance against industry averages Guide entrepreneurs as they prepare financial statements for business plans Validate financial statement estimates when applying for loans or seeking investors Mary G. Scanlon

Using the Economic Census Conclusion: The Economic Census provides valuable data that supports business and economic research Mary G. Scanlon

Using the Economic Census Questions? Contact Info: Mary Scanlon E: [email_address] Twitter: @mgscanlon LinkedIn Facebook Mary G. Scanlon

�ݺ�ߣ

Using the 2007 Economic Census

More Related Content

Using the 2007 Economic Census

Editor's Notes