Special Libraries Association
Jennifer C. Boettcher
March 6, 2025
Latest from the Economic Census, pt 1
Remember to record & share slides
Part 2 (hands on workshop) at SLA Annual Conference
Special Libraries Association (SLA)
SLA Mission: The Special Libraries Association promotes and strengthens its members through learning, advocacy, and networking initiatives.
Thank you to:
Data Community
District, Maryland, and Virginia (DMV) Community
Business and Finance Community
Academic and Education Community
Part 2 (workshop) at SLA Annual Conference
Table of Contents
Boettcher
Economic Census
NAICS
22 Economics Census
First Look
Island Area
Geographic
Comprehensive
22 Economics Census
Bridge
Firm Size
Miscellaneous
Product
Common Mistakes
Beginning
stop for Questions
Stop for Questions
put questions in chat
Jennifer C. Boettcher
Service�
GU Faculty Senate
Cap Area Bus Acad Lib
ALA RUSA BRASS
SLA DMV & B&F�
Employment�
Strawbery Banke Museum
National SBDC Library
Texas A&M
Georgetown University 25+�
Education�
BA in Art History, UNH
MLS, SUNY-Albany
MBA, Georgetown U
Many workshops�
boettcher@georgetown.edu https://www.linkedin.com/in/boettcher1 Bluesky:@jwombat.bsky.social CV
Scholarship
Text
text
text
Why is Intellectual Property important?
Understand where your data comes from before using it.
Federal information is in the public domain
ALWAYS provide ATTRIBUTION through Citation
Notes: under graph or table, who created it, and elements that when into the creation.
Economic Census Structure
not non-employer businesses and few other industries
Access: data.census.gov for Downloads & Maps, FTP, API, microdata at FSRDC, more on how distributed
Datasets
Geographic Area Statistics (GAS)
Comparative Statistics- using old NAICS
Product lines (NAPCS) Statistics- US & States
Miscellaneous Statistics
Selective Sectors: materials consumed, telemedicine, support activities in agriculture, Franchising Reports, Import/Export, 3d, RFID, Robots, Kiosks
Primary Type of Food Service, Business Expenses
First Look
Bridge- between new & old NAICS
Establishment and Firm Size
Concentration Ratios
Legal Form of Organization
Class of Customer
American Business Survey*
County Business Patterns*
Commodity Flow Survey*
Census of Governments*
* Separate outputs
Core Data:
Geography Covered:
National
States
Metropolitan Areas
Counties
Economic Places (2,500 or more people or jobs)
US & States only: Agriculture, Mining, Construction, Management of Companies (for confidential reasons)
Island Areas: American Samoa, the Commonwealth of the Northern Mariana Islands, Guam, Puerto Rico, and the U.S. Virgin Islands and sub areas
Regional(NE,MidWest,South,West): Construction
Off Shore: Mining
Zip Code for County Business Patterns only
Clothing Retailers in US, 2022
U.S. Census Bureau. (2022). Retail Trade: Summary Statistics for the U.S., States, and Selected Geographies: 2022. Economic Census, ECN Core Statistics Summary Statistics for the U.S., States, and Selected Geographies: 2022, Table EC2244BASIC. Retrieved February 9, 2025, from https://data.census.gov/table/ECNBASIC2022.EC2244BASIC?q=EC2244BASIC&g=010XX00US$0400000,$3100000&n=458110.
2022 State Map of Clothing and Clothing Accessories Retailers: NAICS 458110
U.S. Census Bureau. (2022). Retail Trade: Summary Statistics for the U.S., States, and Selected Geographies: 2022. Economic Census, ECN Core Statistics Summary Statistics for the U.S., States, and Selected Geographies: 2022, Table EC2244BASIC. Retrieved February 9, 2025, from https://data.census.gov/table/ECNBASIC2022.EC2244BASIC?q=EC2244BASIC&g=010XX00US$0400000,$3100000&n=458110.
2022 Metropolitan Map of Clothing and Clothing Accessories Retailers: NAICS 458110
U.S. Census Bureau. (2022). Retail Trade: Summary Statistics for the U.S., States, and Selected Geographies: 2022. Economic Census, ECN Core Statistics Summary Statistics for the U.S., States, and Selected Geographies: 2022, Table EC2244BASIC. Retrieved February 9, 2025, from https://data.census.gov/table/ECNBASIC2022.EC2244BASIC?q=EC2244BASIC&g=010XX00US$0400000,$3100000&n=458110.
Economic Census Geography
North American Industry Classification System (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 Education 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
Automobile Industry?
Sector | Description |
33 | Chassis, automobile, manufacturing |
42 | Junk yard, auto, merchant wholesalers |
44 | Auto parts dealers |
52 | Automobile finance |
53 | Automobile leasing |
54 | Automobile industrial design services |
61 | Automobile driving schools |
81 | Automobile repair and maintenance |
North American Industry Classification System
Example
Description
Code
Level
Manufacturing
33
Sector
Transportation Equipment Manufacturing*
336
Subsector
Motor Vehicle Manufacturing*
3361
Industry Group
Automobile and Light Duty Motor Vehicle Manufacturing*
33611
Industry
Automobile and Light Duty Motor Vehicle Manufacturing
336110
U.S. Industry
* Mexico & Canada Compatible
2022 U.S. Auto/Parts Manufacturers
U.S. Census Bureau. (2022). Manufacturing: Summary Statistics for the U.S., States, and Selected Geographies: 2022. Economic Census, ECN Core Statistics Summary Statistics for the U.S., States, and Selected Geographies: 2022, Table EC2231BASIC. Retrieved February 9, 2025, from https://data.census.gov/table/ECNBASIC2022.EC2231BASIC?q=EC2231BASIC&n=336:3361:336110:336120:3362:336211:336212:336213:3363:336310:336320:336330:336340:336350:336360:336370:336390.
States With the Number of establishments of Motor vehicle body manufacturing (NAICS 33621), 2022
U.S. Census Bureau. (2022). Manufacturing: Summary Statistics for the U.S., States, and Selected Geographies: 2022. Economic Census, ECN Core Statistics Summary Statistics for the U.S., States, and Selected Geographies: 2022, Table EC2231BASIC. Retrieved February 9, 2025, from https://data.census.gov/table/ECNBASIC2022.EC2231BASIC?q=EC2231BASIC&g=010XX00US$0400000&n=336211.
Changing NAICS
Note Consolidation in 2022
“Using NAICS Codes Effectively to Research Industries,” Online Searcher 46, no. 5 (September/October 2022): 15-25.
Changes in 2022
Jennifer C. Boettcher. “Changes to NAICS Revises Industry Research,” Online Searcher 46, no. 4 (July/August 2022): 16-21
2022 NAICS: Retailers not stores or website
2022 NAICS Code | 2022 NAICS Title | 2017 NAICS Code | 2017 NAICS Title |
459210 | Book Retailers and News Dealers | 451211 | Book Stores |
459210 | Book Retailers and News Dealers | Pt 451212 | News Dealers and Newsstands |
459210 | Book Retailers and News Dealers | Pt 454110 | Electronic Shopping and Mail-Order Houses |
2022 Place Map of Clothing and Clothing Accessories Retailers: NAICS 458110
U.S. Census Bureau. (2022). Retail Trade: Summary Statistics for the U.S., States, and Selected Geographies: 2022. Economic Census, ECN Core Statistics Summary Statistics for the U.S., States, and Selected Geographies: 2022, Table EC2244BASIC. Retrieved February 10, 2025, from https://data.census.gov/table/ECNBASIC2022.EC2244BASIC?g=040XX00US24$E600000&y=2022&n=45811.
2022 Place Map of Retailers: NAICS 44-45
Questions
What is not covered in the Economic Census
Exclusion of Government-Owned Establishments
The economic census does not generally include government-owned establishments, even when their primary activity would be classified in industries covered by the economic census. Because of these exclusions, economic census data for industries in many sectors might appear to be incomplete.
Sector | Illustrative Governmental Activities Excluded |
Utilities | Public electric, gas, water and sewer utilities |
Construction | Highway construction performed by government employees |
Retail Trade | Post exchanges, ship stores and similar establishments operated on military posts by agencies of the federal government |
Transportation and Warehousing | Publicly-operated buses and subway systems |
Information | Public libraries |
Administrative and Support and Waste Management and Remediation Services | Municipal trash removal |
Health Care and Social Assistance | Municipal ambulance services and County or city nursing care services |
Arts, Entertainment, and Recreation | Public museums or zoos |
More Government Run-Businesses
Exceptions have been made to include certain governmental activities in the economic census:
The economic census does include the activities of private contractors that may be carrying out governmental functions on contract:
Economic Census Technical Documentation
Before we start…
Selected new NAICS
NAICS=00 shows data for all the sectors appearing together in one table. 00 Files
Note 7 digits
4245906 - Cannabis and marijuana, recreational or medical, merchant wholesalers
4246903 - Cannabidiol (CBD oil) and other cannabis and hemp extracts and concentrates merchant wholesalers
Links to data.census.gov files
How to read data.census.gov
file names
PPYYSS where PP= program, YY= year, and SS= 2-digit NAICS sector.
For example, table EC2242BASIC is the basic statistics table for the 2022 Economic Census for sector 42 Wholesale Trade only.
For example, table EC2200BASIC is the basic statistics table for the 2022 Economic Census that shows data for all the sectors appearing together in one table.
Finding Economic Census data
County Business Patterns
Census Business Builder
American Business Survey
2022 Economic Census
Release Dates, 2024-2026
Statistical Set | Release | Revised |
Island Area Statistics | December 2024 | |
First Look Statistics | January 2024 | |
Geographic Area Statistics | March 2025 | December 2024 |
Comparative Statistics | June 2025 | February 2025 |
Bridge Statistics | June 2025 | February 2025 |
Industry (Size) Statistics | June 2025 | |
Product (NAPCS) | September 2025 | |
Miscellaneous Statistics | March 2025-26 | December 2024-2026 |
Island Areas: American Samoa, the Commonwealth of the Northern Mariana Islands, Guam, Puerto Rico, and the U.S. Virgin Islands
Noise Infusion: The flag for ‘low noise’ (G) indicates the cell value was changed by less than 2 percent by the application of noise, and the flag for ‘moderate noise’ (H) indicates the value was changed by at least 2 percent but less than 8 percent.
Island Areas: American Samoa, the Commonwealth of the Northern Mariana Islands, Guam, Puerto Rico, and the U.S. Virgin Islands
Columns
Number of establishments
Sales, value of shipments, or revenue ($1,000)
Annual payroll ($1,000)
First-quarter payroll ($1,000)
Employers cost for legally required fringe benefits ($1,000)
Employers cost for voluntarily provided fringe benefits ($1,000)
Number of employees
Columns
Operating expenses ($1,000)
Total inventories, beginning of year ($1,000)
Total inventories, end of year ($1,000)
Range indicating imputed percentage of total sales, value of shipments, or revenue
Range indicating imputed percentage of total annual payroll
Range indicating imputed percentage of total employees
Citation for previous slide:
U.S. Census Bureau. (2022). Island Areas: Geographic Area Series: Summary Statistics for American Samoa, Commonwealth of the Northern Mariana Islands, Guam, Puerto Rico, and U.S. Virgin Islands: 2022. Economic Census of Island Areas, ECNIA Economic Census of Island Areas, Table IA2200BASIC01. Retrieved February 10, 2025, from https://data.census.gov/table/ISLANDAREAS2022.IA2200BASIC01?y=2022&d=ECNIA Economic Census of Island Areas&n=00.
2022 U.S. Auto/Parts Manufacturers
U.S. Census Bureau. (2022). Manufacturing: Summary Statistics for the U.S., States, and Selected Geographies: 2022. Economic Census, ECN Core Statistics Summary Statistics for the U.S., States, and Selected Geographies: 2022, Table EC2231BASIC. Retrieved February 9, 2025, from https://data.census.gov/table/ECNBASIC2022.EC2231BASIC?q=EC2231BASIC&n=336:3361:336110:336120:3362:336211:336212:336213:3363:336310:336320:336330:336340:336350:336360:336370:336390.
Basic Data:
Geography Covered:
National
States
Metropolitan Areas
Counties
Economic Places (2,500 or more people or jobs)
US & States only: Agriculture, Mining, Construction, Management of Companies (for confidential reasons)
Island Areas: American Samoa, the Commonwealth of the Northern Mariana Islands, Guam, Puerto Rico, and the U.S. Virgin Islands and sub areas
Regional(NE,MidWest,South,West): Construction
Off Shore: Mining
Zip Code for County Business Patterns only
Possible Ratios
U.S. Census Bureau. (2022). All Sectors: County Business Patterns, including ZIP Code Business Patterns, by Legal Form of Organization and Employment Size Class for the U.S., States, and Selected Geographies: 2022. Economic Surveys, ECNSVY Business Patterns County Business Patterns, Table CB2200CBP. Retrieved February 11, 2025, from https://data.census.gov/table/CBP2022.CB2200CBP?g=040XX00US24$0500000&y=2022&n=00.
Economic Census Geography
GAS Mining (21), additional data
Number of firms
Number of establishments
Sales, value of shipments, or revenue ($1,000)
Annual payroll ($1,000)
First-quarter payroll ($1,000)
Number of employees
Production and/or development and exploration workers annual wages ($1,000)
Production and/or development and exploration workers for pay period including March 12
Construction, production and/or development and exploration workers annual hours (1,000)
Other employees annual wages ($1,000)
Other employees for pay period including March 12
Total fringe benefits ($1,000)
Employer's cost for health insurance ($1,000)
Employer's cost for defined benefit pension plans ($1,000)
Employer's cost for defined contribution plans ($1,000)
Employer's cost for other fringe benefits ($1,000)
Total cost of supplies and/or materials ($1,000)
Cost of materials, components, packaging and/or supplies used, minerals received, or purchased machinery installed ($1,000)
Cost of resales ($1,000)
Cost of contract work ($1,000)
Cost of purchased fuels consumed ($1,000)
Cost of purchased electricity ($1,000)
Quantity of electricity purchased for heat and power (1,000 kWh)
Quantity of generated electricity (1,000 kWh)
Quantity of electricity sold or transferred (1,000 kWh)
Value added ($1,000)
Total inventories, beginning of year ($1,000)
Finished goods or minerals products, crude petroleum, and natural gas liquids inventories, beginning of year ($1,000)
Materials and/or supplies, parts, fuels, etc. inventories, beginning of year ($1,000)
Total inventories, end of year ($1,000)
Finished goods or minerals products, crude petroleum, and natural gas liquids inventories, end of year ($1,000)
Materials and/or supplies, parts, fuels, etc. inventories, end of year ($1,000)
Capital expenditures (except land and mineral rights) ($1,000)
Total capital expenditures for buildings, structures, machinery, and equipment (new and used) ($1,000)
Capital expenditures for mineral exploration and development ($1,000)
Capital expenditures for mineral land and rights ($1,000)
Lease rents ($1,000)
Expensed mineral exploration, development, land, and rights ($1,000)
Current operating expenses for exploration, development, and mineral land and rights ($1,000)
Current operating expenses for royalty payments ($1,000)
Total rental payments or lease payments ($1,000)
Rental payments or lease payments for buildings and other structures ($1,000)
Rental payments or lease payments for machinery and equipment ($1,000)
Total other operating expenses ($1,000)
Temporary staff and leased employee expenses ($1,000)
Expensed computer hardware and other equipment ($1,000)
Expensed purchases of software ($1,000)
Data processing and other purchased computer services ($1,000)
Communication services ($1,000)
Repair and maintenance services of buildings and/or machinery ($1,000)
Refuse removal (including hazardous waste) services ($1,000)
Advertising and promotional services ($1,000)
Purchased professional and technical services ($1,000)
Taxes and license fees ($1,000)
All other operating expenses ($1,000)
Range indicating imputed percentage of total sales, value of shipments, or revenue
GAS Construction (23), additional data
Number of firms
Number of establishments
Sales, value of shipments, or revenue ($1,000)
Annual payroll ($1,000)
First-quarter payroll ($1,000)
Number of employees
Construction workers annual wages($1,000)
Construction workers for pay period including March 12
Construction workers for pay period including June 12
Construction workers for pay period including September 12
Construction workers for pay period including December 12
Construction, production and/or development and exploration workers annual hours (1,000)
Other employees annual wages ($1,000)
Other employees for pay period including March 12
Other employees for pay period including June 12
Other employees for pay period including September 12
Other employees for pay period including December 12
Total fringe benefits ($1,000)
Employers cost for legally required fringe benefits ($1,000)
Employers cost for voluntarily provided fringe benefits ($1,000)
Total selected costs ($1,000)
Cost of materials, components, packaging and/or supplies used, minerals received, or purchased machinery installed ($1,000)
Cost of construction work subcontracted out to others ($1,000)
Cost of purchased land ($1,000)
Total cost of selected power, fuels, and lubricants ($1,000)
Cost of gasoline and diesel fuel ($1,000)
Cost of natural gas and manufactured gas ($1,000)
Cost of on-highway use of gasoline and diesel fuel ($1,000)
Cost of off-highway use of gasoline and diesel fuel ($1,000)
Cost of all other fuels and lubricants ($1,000)
Cost of purchased electricity ($1,000)
Value of construction work ($1,000)
Value of construction work on government owned projects ($1,000)
Value of construction work on federally owned projects ($1,000)
Value of construction work on state and locally owned projects ($1,000)
Value of construction work on privately owned projects ($1,000)
Value of other business done ($1,000)
Value of construction work subcontracted in from others ($1,000)
Net value of construction work ($1,000)
Value added ($1,000)
Materials and/or supplies, parts, fuels, etc. inventories, beginning of year ($1,000)
Materials and/or supplies, parts, fuels, etc. inventories, end of year ($1,000)
Gross value of depreciable assets (acquisition costs), beginning of year ($1,000)
Total capital expenditures for buildings, structures, machinery, and equipment (new and used) ($1,000)
Total retirements ($1,000)
Gross value of depreciable assets (acquisition costs), end of year ($1,000)
Total depreciation during year ($1,000)
Total rental payments or lease payments ($1,000)
Rental payments or lease payments for buildings and other structures ($1,000)
Rental payments or lease payments for machinery and equipment ($1,000)
Total other operating expenses ($1,000)
Temporary staff and leased employee expenses ($1,000)
Expensed computer hardware and other equipment ($1,000)
Expensed purchases of software ($1,000)
Data processing and other purchased computer services ($1,000)
Communication services ($1,000)
Repair and maintenance services of buildings and/or machinery ($1,000)
Refuse removal (including hazardous waste) services ($1,000)
Advertising and promotional services ($1,000)
Purchased professional and technical services ($1,000)
Taxes and license fees ($1,000)
All other operating expenses ($1,000)
GAS Manufacturing (31-33), additional data
Number of firms
Number of establishments
Sales, value of shipments, or revenue ($1,000)
Annual payroll ($1,000)irst-quarter payroll ($1,000)
Number of employees
Production and/or development and exploration workers annual wages ($1,000)
Production workers first-quarter payroll ($1,000)
Production and/or development and exploration workers for pay period including March 12
Construction, production and/or development and exploration workers annual hours (1,000)
Other employees annual wages ($1,000)
Other employees first-quarter payroll ($1,000)
Other employees for pay period including March 12
Total fringe benefits ($1,000)
Employer's cost for health insurance ($1,000)
Employer's cost for defined benefit pension plans ($1,000)
Employer's cost for defined contribution plans ($1,000)
Employer's cost for other fringe benefits ($1,000)
Total cost of supplies and/or materials ($1,000)
Cost of materials, components, packaging and/or supplies used, minerals received, or purchased machinery installed ($1,000)
Cost of materials, components, packaging and/or supplies used, minerals received, or purchased machinery installed ($1,000)
Cost of resales ($1,000)
Cost of contract work ($1,000)
Cost of purchased fuels consumed ($1,000)
Cost of purchased electricity ($1,000)
Quantity of electricity purchased for heat and power ($1,000)
Quantity of generated electricity ($1,000)
Quantity of electricity sold or transferred ($1,000)
Value added ($1,000)
Total inventories, beginning of year ($1,000)
Finished goods or minerals products, crude petroleum, and natural gas liquids inventories, beginning of year ($1,000)
Work-in-process inventories, beginning of year ($1,000)
Materials and/or supplies, parts, fuels, etc. inventories, beginning of year ($1,000)
Total inventories, end of year ($1,000)
Finished goods or minerals products, crude petroleum, and natural gas liquids inventories, end of year ($1,000)
Work-in-process inventories, end of year ($1,000)
Materials and/or supplies, parts, fuels, etc. inventories, end of year ($1,000)
Gross value of depreciable assets (acquisition costs), beginning of year ($1,000)
Gross value of depreciable assets (acquisition costs) for buildings and other structures, beginning of year ($1,000)
Gross value of depreciable assets (acquisition costs) for machinery and equipment, beginning of year ($1,000)
Total capital expenditures for buildings, structures, machinery, and equipment (new and used) ($1,000)
Capital expenditures for buildings and other structures ($1,000)
Capital expenditures for machinery and equipment ($1,000)
Capital expenditures for automobiles, trucks, etc. for highway use ($1,000)
Capital expenditures for automobiles, trucks, etc. for highway use ($1,000)
Capital expenditures for computers and peripheral data processing equipment ($1,000)
Capital expenditures for all other machinery and equipment ($1,000)
Total retirements ($1,000)
Retirements for buildings and other structures ($1,000)
Retirements for machinery and equipment ($1,000)
Gross value of depreciable assets (acquisition costs, end of year) ($1,000)
Gross value of depreciable assets (acquisition costs) for buildings and other structures, end of year ($1,000)
Gross value of depreciable assets (acquisition costs) for machinery and equipment, end of year ($1,000)
Total depreciation during year ($1,000)
Total rental payments or lease payments ($1,000)
Rental payments or lease payments for buildings and other structures ($1,000)
Rental payments or lease payments for machinery and equipment ($1,000)
Total other operating expenses ($1,000)
Temporary staff and leased employee expenses ($1,000)
Expensed computer hardware and other equipment ($1,000)
Expensed purchases of software ($1,000)
Data processing and other purchased computer services ($1,000)
Communication services ($1,000)
Repair and maintenance services of buildings and/or machinery ($1,000)
Refuse removal (including hazardous waste) services ($1,000)
Advertising and promotional services ($1,000)
Purchased professional and technical services ($1,000)
Taxes and license fees ($1,000)
All other operating expenses ($1,000)
Range indicating imputed percentage of total sales, value of shipments, or revenue
Range indicating imputed percentage of total annual payroll
Range indicating imputed percentage of total employees
Wholesale (42) Additional Data
Number of firms
Number of establishments
Sales, value of shipments, or revenue ($1,000)
Annual payroll ($1,000)
First-quarter payroll ($1,000)
Number of employees
Operating expenses ($1,000)
Total inventories, beginning of year ($1,000)
Total inventories, end of year ($1,000)
Range indicating imputed percentage of total sales, value of shipments, or revenue
Range indicating imputed percentage of total annual payroll
Range indicating imputed percentage of total employees
Additional field under Type of Operation:
Merchant wholesalers, except manufacturers' sales branches and offices
Manufacturers' sales branches and offices
Has 7 and 8 digit NAICS for more detail
Other Geographic Statistical Area stuff
Sector Specific
Agriculture (11)- 5 digit only
Retail (44-45)- Biggest changes
Transportation & Warehousing (48)- 7 digits
Information (51)- 7 digits
Finance & Insurance (52)- 7 digits
Professional, Scientific, and Technical Services (54)- 7 digits, Tax Status, OpEx
Education Services (61)- Tax Status, OpEx
Health Care and Social Assistance (62)- 7 digits, Tax Status, OpEx
Arts, Entertainment, and Recreation (71)- Tax Status, OpEx
Other Services (except Public Administration) (81)- Tax Status, OpEx
Other
NAICS 00, not in GSA
use American Business Survey or
County Business Patterns
Table Symbols
D - Withheld to avoid disclosing data for individual companies; data are included in higher level totals
N - Not available or not comparable
S - Estimate does not meet publication standards because of high sampling variability, poor response quality, or other concerns about the estimate quality. Unpublished estimates derived from this table by subtraction are subject to these same limitations and should not be attributed to the U.S. Census Bureau. For a description of publication standards and the total quantity response rate, see link to program methodology page.
X - Not applicable
A - Relative standard error of 100% or more
r - Revised
s - Relative standard error exceeds 40%
Comparative Statistics for the U.S. (2017 NAICS Basis): 2022 and 2017
U.S. Census Bureau. (2022). All Sectors: Comparative Statistics for the U.S., States, and Selected Geographies (2017 NAICS Basis): 2022 and 2017. Economic Census, ECN Core Statistics All Sectors: Comparative Statistics for the U.S., States, and Selected Geographies (2017 NAICS Basis): 2022 and 2017, Table EC2200COMP. Retrieved February 11, 2025, from https://data.census.gov/table/ECNCOMP2022.EC2200COMP?y=2022&n=44811:44812:44813:44814:44815:44819:N0600.00.
To calculate inflation use PPI
Comparative Statistics for the U.S., States, and Selected Geographies (2017 NAICS Basis): 2022 and 2017
Number of firms
Number of establishments
Sales, value of shipments, or revenue ($1,000)
E-shipments value ($1,000)
Annual payroll ($1,000)
First-quarter payroll ($1,000)
Number of employees
(manufacturing only)
Production and/or development and exploration workers annual wages ($1,000)
Production and/or development and exploration workers for pay period including March 12
Construction, production and/or development and exploration workers annual hours (1,000)
Total fringe benefits ($1,000)
Total cost of supplies and/or materials ($1,000)
Value added ($1,000)
Total inventories, beginning of year ($1,000)
Finished goods or minerals products, crude petroleum, and natural gas liquids inventories, beginning of year ($1,000)
Work-in-process inventories, beginning of year ($1,000)
Materials and/or supplies, parts, fuels, etc. inventories, beginning of year ($1,000)
Total inventories, end of year ($1,000)
Finished goods or minerals products, crude petroleum, and natural gas liquids inventories, end of year ($1,000)
Work-in-process inventories, end of year ($1,000)
Materials and/or supplies, parts, fuels, etc. inventories, end of year ($1,000)
Total rental payments or lease payments ($1,000)
Total other operating expenses ($1,000)
Range indicating imputed percentage of total sales, value of shipments, or revenue
Range indicating imputed percentage of total annual payroll
Range indicating imputed percentage of total employees
Questions
Industry Bridge Statistics on 2017 NAICS Basis With Distribution Among 2022 NAICS-Based Industries for the U.S.: 2022
U.S. Census Bureau. (2022). Selected Sectors: Industry Bridge Statistics on 2017 NAICS Basis With Distribution Among 2022 NAICS-Based Industries for the U.S.: 2022. Economic Census, ECN Core Statistics Selected Sectors: Industry Bridge Statistics on 2017 NAICS Basis With Distribution Among 2022 NAICS-Based Industries for the U.S.: 2022, Table EC2200BRIDGE2. Retrieved February 11, 2025, from https://data.census.gov/table/ECNBRIDGE22022.EC2200BRIDGE2?y=2022&n=N0600.00.
6-digit 2022 NAICS code by 8-digit 2017 NAICS bridge code
Industry Bridge Statistics on 2022 NAICS Basis With Distribution Among 2017 NAICS-Based Industries for the U.S.: 2022
U.S. Census Bureau. (2022). Selected Sectors: Industry Bridge Statistics on 2022 NAICS Basis With Distribution Among 2017 NAICS-Based Industries for the U.S.: 2022. Economic Census, ECN Core Statistics Selected Sectors: Industry Bridge Statistics on 2022 NAICS Basis With Distribution Among 2017 NAICS-Based Industries for the U.S.: 2022, Table EC2200BRIDGE1. Retrieved February 11, 2025, from https://data.census.gov/table/ECNBRIDGE12022.EC2200BRIDGE1?y=2022&n=458110.
Same NAICS
Different Subsector
6-digit 2022 NAICS code by 8-digit 2017 NAICS bridge code levels
Bridge Tables, selected Industries
Jennifer C. Boettcher. “Changes to NAICS Revises Industry Research,” Online Searcher 46, no. 4 (July/August 2022): 16-21
Still more coming
North American Industry Classification System (NAICS)
How are Industries classified
North American Product Classification System (NAPCS)
How are Products classified
Wine is a Products and Convenience Stores are the Industry
North American PRODUCT Classification System Structure
Under NAPCS-Based
Broad Line - ends in 0
Detailed Line- ends in 1-9
3,518 broad lines and 3,716 detail lines
Examples of new 2022 NAPCS: Cannabis, cryptocurrency, electric vehicles, and remanufacturing have been added as product lines for 2022.
Industry by Products
Product by Industries (presented)
U.S. industries that prepared and served or dispensed wine and wine drinks for immediate consumption (NAPCS 7000050003), 2017
U.S. Census Bureau. (2017). EC1700NAPCSINDPRD, https://data.census.gov/table?n=N0600.00&napcs=7000050003. U.S. Department of Commerce. Retrieved August 12, 2023, from https://data.census.gov/, with last column self-calculated.
LOCATIONS
Find out how much liquor stores make by selling wine
Common Mistakes
Common Mistakes: Inclusion?
We can get there together
Not sure if you can find the data?
THANKS
Please keep this slide for attribution
CREDITS: This presentation template was created by Slidesgo, including icons by Flaticon, and infographics & images by Freepik
Special Libraries Association (SLA)
Vision:
The Special Libraries Association is the global organization for innovative information professionals and their strategic partners.
Membership: https://sla.org/page/membership
Part 2 (hands on workshop) at SLA Annual Conference
Learn more from Boettcher
NAICS/NAPCS
Economic Census
“Knowing NAPCS, the North American PRODUCT Classification System: Its Origin, Structure, Uses, and Limitations,"2023, (Slides)
“The Shifting Ground of NAICS: Retail, Information, and Other Subsectors Have Changed,” 2022, (Slides)
“Using NAICS Codes Effectively to Research Industries,” Online Searcher 46, no. 5 (September/October 2022): 15-25.
“Changes to NAICS Revises Industry Research,” Online Searcher 46, no. 4 (July/August 2022): 16-21.
Jennifer C. Boettcher and Leonard M. Gains. Industry Research Using the Economic Census. Greenwood Press: Phoenix, AZ. 2004.
“Industry Research using the Economic Census,” NCLA 2019, Webinar. (Slides)
Jennifer Boettcher, Vicki Mack, and Maria Valdisera. “American Community Survey (ACS) and the Economic Census: Gathering and Interpreting Powerful Data that is Already at Your Fingertips,” 2024, (Slides)
“Supporting Authors in Our Midst,” SLA Information Outlook. Fall 2024.
“Where Do You Find the Time: Writing Leave,” (SOUCABL), March 9, 2024, (Slides)
“Autonomy & Time: Microgrants and Writing Leave,” Washington Research Library Consortium Annual Meeting, Online Presentation. May 23, 2024 (Slides)
Other:
Jennifer C. Boettcher. “Which industries are using AI in the US: Free Data Sources,” Lauinger Library, Georgetown University. Workshop. November 4, 2024. In-person. (Slides) (Worksheet)
Writing
Forthcoming Presentation: NAPCS (2/21)
Boettcher webinars to watch
2019
2019
2020
2020
2018
2017
Slides only
2022
July 2018, article: Government Data as Intellectual Property: Is Public Domain the Same as Open Access? Online Searcher, with Matthew Dames
2022
2022