Transcript USA experience in dissemination of economic census results

U.S. Economic Census
Dissemination Overview
Second International Workshop on Economic Census
Seoul, Republic of Korea
July 6 - 9, 2009
presented by:
Ronald H. Lee, Senior Economic Advisor
Office of the Deputy Director
U.S. Census Bureau
1
Economic Census
Dissemination Process
• Five distinct parts or phases
• Data product definition
• Data organization
• Data preparation and product creation
• Data access modes and release
• Product publicity and data user support
2
Product Definition
3
Determining our Products
• Starts about the time report forms are finalized
• What we did last time
• “Expert” knowledge
• Ongoing discussions with key customers
• Trade association & respondent comments
• Data user surveys
• Legal requirements – ADA / Section 508
4
Gathering User Feedback
• Economic Census User Surveys
• Feedback at Trade Shows and
Conferences
• E-mail / Telephone Inquiries
5
Users Want Data That Are:
• In electronic format
• More timely
• Easier to find
• Consistent across programs and sectors
• Easy to manipulate
• Combinable across
- Time Periods
- Surveys
6
Product Organization
7
Categories for Data
• Industry (NAICS)
• Geography
• Time Period / Frequency
• Other Cross-Tabs
• Data Items
8
NAICS Sectors
11
Agriculture, Forestry,
Fishing, and Hunting
21
Mining
22
Utilities
23
Construction
31-33 Manufacturing
42
Wholesale Trade
44-45 Retail Trade
48-49 Transportation and
Warehousing
51
Information
52
Finance and Insurance
53
Real Estate and Rental
and Leasing
54 Professional, Scientific and Technical
Services
55 Management of Companies and
Enterprises
56 Administrative and Support and
Waste Management and
Remediation Services
61 Educational Services
62 Health Care and Social Assistance
71 Arts, Entertainment and
Recreation
72 Accommodation and Food Services
81 Other Services (except Public
Administration)
92 Public Administration
Not covered by Econ Census; Partial coverage in Econ Census
9
NAICS Sectors (cont.)
11 Agriculture, Forestry, Fishing, and Hunting – Covered by the Census of
Agriculture published by the US Dept of Agriculture and partially covered by
County Business Patterns and Nonemployer Statistics.
48-49 Transportation and Warehousing – Excludes the US Postal Service and
railroads. Both covered by US Dept of Transportation, Bureau of
Transportation Statistics (For 2002 and before, also excluded airlines.)
61 Educational Services – Excludes elementary & secondary schools,
colleges/universities, and professional schools. All covered by US Dept of Ed.
81
Other Services (except Public Administration) – Excludes labor, political,
and religious organizations and private households. Labor unions covered by
Statistics of US Business (Census Bureau), political parties by Congressional
Quarterly, religious orgs by non-government sources.
92 Public Administration – Covered by the Census of Governments published
by the Census Bureau
10
Geographies
• United States
• Census Regions and Divisions
• States (and equivalents)
• Metropolitan Areas
• Counties (and equivalents)
• Places
• ZIP Codes
11
Economic Census Geographic Coverage
Sector
States
Mining
X
Utilities
X
Construction
X
Manufacturing
X
Wholesale Trade
MA's
Counties
Places
ZIP
Codes
X
X
X
X
X
X
X
Retail Trade
X
X
X
X
Transportation and Warehousing
X
X
Information
X
X
X
X
Finance and Insurance
X
X
Real Estate and Rental and Leasing
X
X
X
X
Professional, Scientific, and Technical Services
X
X
X
X
X
Management of Companies and Enterprise
X
Administrative and Support and Waste Management and Remediation Services
X
X
X
X
X
Educational Services
X
X
X
X
X
Health Care and Social Assistance
X
X
X
X
X
Arts, Entertainment and Recreation
X
X
X
X
X
Accommodation and Food Services
X
X
X
X
X
Other Services (Except Public Administration)
X
X
X
X
X
X
X
12
Places
• 2002 and Prior Censuses
- Incorporated places only
- Only Population criteria for inclusion
- Population cutoffs varied widely
• 2007
- Incorporated and Unincorporated
- Census Designated Places
- Population and Jobs criteria for inclusion
- Cutoffs standardized
13
Other Cross-Tab Categories
• Employment/Sales Size of Establishments/Firms
• Legal Form of Organization
• Tax Status and Type of Operation
• Class of Customer
• Concentration Ratios
• Sex, Race/Ethnicity (Survey of Business Owners)
• Other “Specialty” Cross-Tabs
14
Preparation and Product Creation
15
Metadata
• “Data about data”
• Everything about the statistical
presentation except the numbers
in the cells
16
Metadata (cont.)
• Defines content, structure, and data
relationships
• Makes data interpretable
• Helps searching and navigation
• Facilitates applications
17
Preparing the Economic Census
Data for Release
• Dissemination Metadata Repository (DMR)
• Dissemination Metadata User Interface
(DMUI)
• Final Data Review Tool (FDRT)
18
DMR and DMUI
• Dissemination metadata stored and
managed in DMR
• Metadata reused throughout processing
• Metadata accessed, reviewed, and
updated via the DMUI
19
FDRT
• Review data in dissemination format
• Add/remove data symbols
• Add footnotes
• Identify rows of data for publication
• Preview data prior to release
• Finalize, recall, and revise data
20
Access Modes and Release
21
Dissemination Formats – Change Over Time
100
90
80
70
Percent
60
50
40
30
20
10
0
1987
1992
Print
1997
PDF
HTML
2002
2007
Database
22
Gateways to the Economic Census
2007 Economic Census
INFORMATIONAL
Business.census.gov
MARKETING
American FactFinder
FUNCTIONAL
23
2007 Economic Census
www.census.gov/econ2007
24
business.census.gov
25
Industry Snapshot
26
American FactFinder (AFF)
factfinder.census.gov
27
AFF Release Formats
• Fact Sheets
- Selected data across sectors presented in a table
• Quick Reports
- Selected data for an industry or geography in a table
• Thematic Maps
- Selected data (including ratios) presented in a map
• Detailed Datasets
28
Sample Fact Sheet
29
Sample Industry Quick Report
30
Sample Geographic Quick Report
31
Sample Thematic Map
32
Sample Detailed Dataset View
33
AFF Features
• Search for and Filter datasets (by geography,
industry, other dimensions, and by data item)
• List datasets (by program, survey, or sector)
• Filter within a dataset
• Modify display (Show/Hide, Create, Move Columns)
• Sort data in table
• Print and Download data (plus FTP site)
• Access to textual metadata
• Reference Maps
34
2007 Economic Census
Release Schedule
Advance Report
Industry Series
Geographic Area Series (GAS)
Franchise Statistics Report
Comparison & Bridge Reports
Subjects Series
ZIP Codes
Mar. 2009
Apr. – Dec. 2009
Nov. 2009 – Aug. 2010
Nov. 2010
Jun. 2011
Oct. 2010 – Jun. 2011
Jun. 2011
1,700 + reports
2.7 billion cells of data
1 – 3 months ahead of 2002 schedule
35
36
Promotion and Support
37
Product Publicity
• Press Releases and Product Announcements
• Tip Sheets
• Brochures – “Preview to Economic Census”
• State Data Centers & Depository Libraries
• Census Information Centers
• Conferences / Trade Shows
• Internet
38
Data User Support
• Headquarters Staff
• State Data Centers & Depository Libraries
• Census Information Centers
• Data User Conference Series
• Industry and Business Trade Shows
• Internet
39
QUESTIONS?
40