County Business Patterns CBP

1
County Business Patterns (CBP) Jon A.
Youngman Email Jon.A.Youngman_at_census.gov
2
County Business Patterns (CBP) Overview

• County Business Patterns is an annual series that
  provides sub-national economic data by industry.
• Data items are number of establishments,
  employment, 1st quarter payroll and annual
  payroll.
• Includes information by employment size class.
• Provides data for establishments in the United
  States, including the District of Columbia.
  Puerto Rico data are also available separately.

3
County Business Patterns (CBP) Overview

• Includes all industries except
• Self-employed Individuals
• Employees of Private Households
• Railroad Employees
• Agricultural Production Employees
• And Most Government Employees
• Changed from Standard Industrial Classification
  (SIC) System to 1997 North American Industry
  Classification System (NAICS) in 1998 data year
• Changed from 1997 NAICS to 2002 NAICS in 2003
  data year
• Tabulation of about 7 million business
  establishments

4
County Business Patterns (CBP)CBP Data Are Used

• To study the economic activity of small areas
• To analyze economic change over time
• As a benchmark for statistical series, surveys,
  and databases between economic censuses

5
County Business Patterns (CBP) In a Survey of
Federal Statistics Data Users, CBP Ranked

• 2nd in Accessibility
• 2nd in Detail
• 2nd in Overall Usefulness (Decennial Census was
  1st)
• 4th in Accuracy
• 6th in Timeliness

6
COUNTY BUSINESS PATTERNS (CBP) ON THE INTERNET
7
Click Index
8
Click C
CBP
9
Click 1st Drop Down Box
10
Starting Point to Display U.S., State, or County
Data
11
Select State Totals or County Data
12
Selected County
Noise Infusion A Method For Maintaining Data
Confidentiality
Greater Industry Detail
Year Selector
13
Compare Across Same Geographic Level
6-Digit NAICS Is Most Detail Available From CBP
14
NAICS 238350 Now Compared Across All Maryland
Counties
Cell Disclosures
15
Export Buttons
Start Over For a New Geographic Area
16
Noise Flag Definitions G - Low Noise Infusion H -
Medium Noise Infusion D - Withheld to Avoid
Disclosing Data for Individual Companies
Data are Included in Higher Level Totals S
Withheld Because Estimate Did Not Meet
Publication Standards Note Flags are Links to
Popup Box Definitions
17
PR Metro Business Patterns Display Same As
County Business Patterns
18
Enter Zip Code To View
19
Employment Payroll for ZIP Totals Only
ZIP Data By Industry Only Shows Establishment
Counts
20
View CBP in American FactFinder
21
CBP Located In Data Sets Annual Economic Surveys
22
Click on 1st Geographic Area Series Link
23
Geographic Area Totals by Industry, But No
Employment Size Breakdown
24
Select to filter data by State, County,
Industry, etc
25
Filter CBP Data to Only Show Totals for Alabama
26
Click on Hyperlink to Get Code Definition
CBP Data for Alabama
27
Filter CBP Data by Selected Alabama County
28
CBP Data for Autauga County, AL
29
To Print or Download CBP Data
30
Click on 2nd Geographic Area Series Link
31
CBP Data by Emp Size Class
Emp Size Class
32
Click on these Links for Zip Code Business
Patterns
33
Totals for Each Zip Code But, No Industry Detail
34
ZBP by Emp Size Class Industry, But No Emp Or
Payroll
Industry Emp Size Class
Estabs
35
Download Complete Data Sets
36
Reference Links Important for Understanding Data
Files
37
North American Industry Classification System
(NAICS) Reference
38
State/County Reference
39
Record Layout for U.S. File
40
Large Data Files Are Compressed in .ZIP Format
41
County File Only Has Establishment Counts (fields
beginning with n) By Employment Size
Column Headings In First Row. Comma-separated
Values (csv) Format.
42
The U.S. File and State File Also Contain
Employment, First Quarter Payroll, and Annual
Payroll By Employment Size.
43
STATE FILE All States In One File Alabama
(state code 01) Immediately Followed by Alaska
(state code 02) etc
44
ZIP Code Totals File Contains Employment,
Payroll, and Establishment Counts, But Has No
Industry Detail
45
ZIP Code Detail File Has Industry Detail, But
Only For Establishment Counts
46
Click For CBP Data Prior to 1998 By SIC Industry
Codes
47
Pdf CD-ROM Formats Discontinued after 2004
48
PDF Format Discontinued After 2004
49
(No Transcript)
50
CD-ROM/DVD Formats Discontinued After 2004
51
Importing Downloaded Data Files Into Microsoft
Access
52
File Menu Get External Data - Import
53
Select Type Of File To Open - Text File
54
Access Automatically Detects File is in Delimited
Format
55
Click To Check This Box
56
Accept Storing Of Data In New Table
57
Just Click Next At This Screen. Field Name And
Data Type Info Already Included In Text File.
58
Use The No Primary Key Selection.
59
(No Transcript)
60
(No Transcript)
61
(No Transcript)
62
Click Query Tab on Left and Then Create Query to
Extract Only The Data You Want
63
Click Add to Put Table in Query Designer
64
Drag and Drop Fields You Want
65
Enter Filter Criteria
66
Run Query
67
Results Only Show Filter Criteria. Results Can Be
Saved to Another File (Exported).