1 of 63

Sources FOR BUSINESS

SLA Data Community

February 25th, 2022 Online Webinar

Jennifer C. Boettcher

Business

MENU

ANALYSIS

CONTACT

2 of 63

Hello!

Jennifer C. Boettcher

boettcher@georgetown.edu

202 687-7495

@jennywombat

Data ANALYSIS

MENU

ANALYSIS

CONTACT

Submit all questions and comments via Chat (lower right)

Slides will be distributed to participants https://tinyurl.com/SLAdata22

Where are you?

3 of 63

Librarian & Information Scientist

As a Librarian, I

As a Librarian, I don’t

–Publish the primary source

–Have your context or expertise

–Do statistical analysis

–Interpret the data

–Do data entry

–Have legal expertise

All opinions are my own

-Understand the source

–Know how to find the source

–Know the subjects covered

–Know how it’s connected to other sources

–Know how to read the data

–Make connections between publisher and researcher

4 of 63

TABLE OF CONTENT

Why Government Information

01

Discovery Methods

02

Public Domain vs Open Access Data

03

NAICS update

04

sometimes better than commercially-available business data

Beyond a Google Search

Knowing the difference will save you money

Major changes in Retail, Wholesale, and Services

Data ANALYSIS

MENU

ANALYSIS

CONTACT

5 of 63

DIAGNOSTIC

TYPES OF DATA ANALYSIS

DESCRIPTIVE

PREDICTIVE

PRESCRIPTIVE

Relationships

Increase/decrease

Estimates

Policy & Decision Making

Data ANALYSIS

MENU

ANALYSIS

CONTACT

6 of 63

Words about Data

Data ANALYSIS

MENU

ANALYSIS

CONTACT

Data are not:

Information Technology

Digital Analytics

Evidence

Research

Visualizations

Ideas

Data are

collected facts

“raw material”

Adaptations of DIKW pyramid by US Army Knowledge Managers,

from https://en.wikipedia.org/wiki/DIKW_pyramid

7 of 63

Pierre Simon, Marquis de Laplace

"The most important questions of life are, for the most part, really only problems of probability."

Data ANALYSIS

MENU

ANALYSIS

CONTACT

8 of 63

01

Free large datasets

Data ANALYSIS

MENU

ANALYSIS

CONTACT

9 of 63

Federal Government Information is Business

Executive Branch

  • Regulations
  • Data, API
  • Data, Statistics or Indicators
  • Press releases or Trade press or Bulletin
  • Handbooks or Fact Books
  • Department’s Reports
  • Industry Reports or Surveys or Review
  • State of the Industry and Outlooks
  • Geographic specific
  • New Technology and direction

Congressional Branch

  • Forthcoming laws
  • Committee reports/prints
  • Congressional Research Section
  • Library of Congress, Reading Rooms
  • Government Publishing Office

Judicial Branch

  • Interpreting laws
  • Courts, transcribes
  • Courts, defendants

10 of 63

Commercial

Government

PROBLEM - Cons

Expensive

Preparatory/Licensing

Small Samples

Unknown Methodology

Faddish

Old (2 years behind)

Not customizable

Security and Privacy Concerns

Compatibility

Depends on Funding

Data ANALYSIS

MENU

ANALYSIS

CONTACT

11 of 63

Commercial

Government

SOLUTION - Pro

Commissioned

Value Added Services

Projections/predictions

Branding

FREE

Historic

No permissions needed

Larger sample sizes

Known methodology

Findable, Acessisable, Interoperable, Reusable (FAIR)

Data ANALYSIS

MENU

ANALYSIS

CONTACT

12 of 63

How do you present data

Graphs for time series

Bar charts showing the differences

Pie charge for comparison to the whole

Common-size to per capita for story

13 of 63

02

Beyond a Google Search

Data ANALYSIS

MENU

ANALYSIS

CONTACT

14 of 63

Google

What most people do

Data.Gov

Commercial

Data ANALYSIS

MENU

ANALYSIS

CONTACT

15 of 63

Kinds of Federal Sources: Social Science

Demographics, Manufacturing, Retail, Wholesale, Construction, most other industries

Labor and price data

Banking & economic conditions

Ideal for tourism and comparisons

Publicly Traded Companies

Complaintes, cable, mobil, broadcasting, broadband

16 of 63

Kinds of Federal Sources: Natural Science

Including Fisheries and Forestry

Including Minerals

and Energy

State sources will be better

Regional center better

17 of 63

Business of Government

Procurement

Sam.com

Assistance

Public Finance

18 of 63

Funding for Federal Data Collection

NIH- National Institutes of Health (HHS)

NSF- National Science Foundation

AHRQ- Agency for Healthcare Research & Quality (HHS)

FDA- Food & Drug Agency (HHS)

BEA- Bureau of Economic Analysis (DoC)

BJS- Bureau of Justice Statistics (DoJ)

BTS- Bureau of Transportation Stat. (DoT)

Census- DoC

EIA- Energy Information Admin. (DoE)

ERS- Economic Research Service (DoA)

NASS- Nat. Agricultural Stat. Service (DoA)

NCES- Nat. Center of Education Stat. (DoE)

NCHS- Nat. Center for Health Stat . (HHS)

NCSES- Nat. Center for Science and Engineering Sat. (NSF)

ORES- Off. of Research, Evaluation, and Statistcs (SSA)

SOI- Statistics of Income (IRS)

Image from AmStat (permission pending)

19 of 63

One Statistical Office in US: Why Not?

1. Privacy: The Privacy Act of 1974, Confidential Information Protection and Statistical Efficiency Act of 2002 (CIPSEA), and Statistical Policy Directive No. 1 (2014) require agencies to ensure that the collection and maintenance of citizens' data is accurate, confidential, and within legal restrictions. With different offices having access to those records, there would be less possibility of everything being leaked.

2. Security: Along the lines of fewer offices having access to data records. The more servers that hold the data, the safer it is. The times when an exchange of information is necessary laws and regulations among departments allow to protect access to data.

3. Integrity: The income you report to IRS might be different from what you report to the Census Bureau.

4. Methodology: Sometimes data must have a higher number of people questioned so the accuracy will be better; different methods of collection or sampling may be required.

5. Popularity: Anything being done by the government has a political dimension, especially funding for employees and for modernizing and updating technology, attractiveness of the research, and repetition of statistical programs by agencies.

20 of 63

Future of the Bureau of Labor Statistics

In danger: Nat. Longitudinal Sur., JOLTS, Am. Time Use Sur., Employee Benefits Sur.,

Cen. of Fatal Occupational Injuries, Evaluation $27M>$2M

Protected

Principal Federal Economic Indicators (PFEI) and programs written into or referenced by law for allocation or other purpose. 85% of budget

21 of 63

Questions?

CC0, https://pixabay.com/en/hedgehog-child-young-hedgehog-1759027

22 of 63

03

Knowing the difference will save you money

Data ANALYSIS

MENU

ANALYSIS

CONTACT

23 of 63

Flavors of data

Data ANALYSIS

Public Domain

FAIR

Open Access

Commercial

MENU

ANALYSIS

CONTACT

24 of 63

Why is IP important?

Facts are not copyrighted (In no case does copyright protection for an original work of authorship extend to any idea, procedure, process, system, method of operation, concept, principle, or discovery, regardless of the form in which it is described, explained, illustrated, or embodied in such work.) 17 USC 102

  • Public Domain: No ownership
  • Open Data policies: Owned, but generous license
  • FAIR: Findabile, Accessible, Interoperabile, Reusable

Understand where your data comes from before using it.

Federal information is in the public domain

Some states have different IP for different items

ALWAYS provide ATTRIBUTION through Citation

25 of 63

Government Information and Public Domain: No Copyright Restrictions

Public Domain is not protected by intellectual property laws. Anyone can use a public domain work without obtaining permission, but no one can ever own it.

Example: no longer protected due to age of creative work.

Works produced for the U.S. Government by its officers and employees should not be subject to copyright. The provision applies the principle equally to unpublished and published works. 17 USC 105

REMEMBER: Public domain data must be attributed.

26 of 63

  • Open Access is not law. It’s a license agreement from the copyright owner and a set of principles: CC0
    • Do you have the right to convey copyright?
    • States and local governments
    • NGO’s and non-profit
  • Principals
    • Reuse and redistribution of the data
    • Allows derivative works as Open only
    • No restrictions on who can access and use
    • Electronically transferable
    • Machine-readable

Data ANALYSIS

MENU

ANALYSIS

CONTACT

Why Open Data Exists

27 of 63

Public Domain Vs. Open Access

  • Public Domain
    • Free data flow
    • Law
    • Fed Government products
    • Data at any stage can be retrieved by FOIA
    • Not for some sub-nationals
  • Open Access
    • Free data flow
    • Because of ownership of copyright
    • Principles and license
    • More popular than Public Domain
    • Created for a specific purpose, by-product of decision making

28 of 63

International Data OPEN Sources

By topic

By Country

National Statistical Offices

More data available in national language

Some charge for access

Citizens of that country might have free access

National Repositories/Archives

Historical

Datasets

29 of 63

04

What is getting counted changes

Data ANALYSIS

MENU

ANALYSIS

CONTACT

30 of 63

NEWS: Death notice for SIC

February 26, 2020 OMB ask for permission to kill the Standard Industrial Classification (SIC). With 86 FR No. 242 72277, December 21, 2021 SIC will be eliminated effective immediately.

Long live the North American Industry Classification System (NAICS). Thank you Economic Classification Policy Committee (ECPC)

V. OMB Statistical Policy Directive No. 8, Standard Industrial Classification of Establishments The ECPC is soliciting public comments at the request of OMB on the advisability of formally updating Statistical Policy Directive No. 8, Standard Industrial Classification of Establishments, and seeking comments on the proposed text of the update.

VI. OMB Statistical Policy Directive No. 9, Standard Industrial Classification of Enterprises The ECPC proposes elimination of Statistical Policy Directive No. 9, Standard Industrial Classification of Enterprises.

31 of 63

Which Industry?

32 of 63

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

33 of 63

North American Industry Classification System (NAICS) Structure

Data ANALYSIS

MENU

ANALYSIS

CONTACT

Level

Code

Description

Sector *

52

Finance and Insurance

Subsector *

524

Insurance Carriers and Related Activities

Industry Group *

5241

Insurance Carriers

Industry

52411

Direct Life, Health, and Medical Insurance Carriers

U.S. Industry

524113

Insurance carriers, life, direct

* Mexico & Canada Compatible

34 of 63

Indicators

  • Employment

35 of 63

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

451212

News Dealers and Newsstands

459210

Book Retailers and News Dealers

454110

Electronic Shopping and Mail-Order Houses

513130

Book Publishers

511130

Book Publishers

513130

Book Publishers

519130

Internet Publishing and Broadcasting and Web Search Portals - Internet book publishers

36 of 63

224

New 2022 NAICS Codes

Data ANALYSIS

MENU

ANALYSIS

CONTACT

31

title change, no content change

185

new code for 2022 NAICS

7

re-used code, content change

4

re-used code, content change at lower level with insignificant

37 of 63

Mining

2022

21214 surface coal

212115 underground

212220 gold & silver

212290 other metal ore

21232 Kaolin, clay…

212339 Other Nonmetallic Mineral Quarrying

2017

212111 bituminous & 212113 anthracite

212112 bituminous & 212113 anthracite

212221 gold & 212221 silver

212222 uranium & 212299 all other metals

212324 Kaolin & 212325 Clay, ceramic,...

Potash, Phosphate, other chem, all other nonmetallic mineral mining

38 of 63

Manufacturing

2022

2017

315120 (Apparel Knitting Mills)

315250(Cut & Sew Apparel)

31699 (Other Leather & Allied

321215 (Engineered Wood)

32212(Paper Mills)

R 325314(Fertilizer)

325315(Compost)

31511 (Hosiery & Socks) & 31519 (Other Apparel Knitting)

31522 (Men’s & Boy’s Cut & Sew Apparel) & 31524(Woman’s, Girl’s, & Infant’s Cut) & 31526 (Other Cut & Sew Apparel)

316992 (Women’s Handbag & Purse) & 316998 (All other Leather Good & Allied Product)

321213 (Engineered Wood Member) & 321214 (Truss)

322121(Paper [except Newsprint]) & 322121 (Newsprint)

325314 (Fertilizer)

325314 (Compost )

39 of 63

Manufacturing

2022

2017

333248 All Other Industrial

333310Commercial & Services Industry Mach

333996 All Other Misc

334610 Reproduction Magnetic & Optical Media

333244 Printing Machinery & 333249 Other Industrial

333314 Optical & 333316 Photographic & 333318 Other Commercial & Services Industry Machinery

333997 Scale & Balance & 333999 All Other Misc General

334613 Blank Magnetic Recording Media & 334614 Software & Other PreRecorded CD, Tape, & Record

40 of 63

Manufacturing

2022

2017

335131 Electric Lighting

335132 Commercial Industrial & Institutional

335139 Electric Lamp Bulbs & Other

33591 Battery

33611 Auto & Light Duty Motor Vehicles

337126 Household Furniture (except Wood & Upholstered)

335121 Residential Electric Lighting Fixtures

335122 Commercial Industrial & Institutional Electric Lighting Fixtures

33511 Electric Lamp Bulbs and Parts & 335129 Other Lighting Equipment

335911 Storage Battery & 335912 Primary Battery

336111 Automobile & 336112 Light Trucks & Utility Vehicles

337125 Metal Household Furniture & 337125 Household furniture (except wood & Metal)

41 of 63

Wholesale

2022

2017

42435 Clothing & Clothing Accessories

R 42512 Wholesale Trade Agents & Brokers

424320 Men’s and Boy’s Clothing and Furnishing & 424330 Woman’s and Childers, and Infants clothing and Assoc

425111 Business to Business Electronic Markets

42 of 63

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

513130

Book Publishers

511130

Book Publishers

513130

Book Publishers

Pt 519130

Internet Publishing and Broadcasting and Web Search Portals - Internet book publishers

43 of 63

Other Retail

2022

2017

445132 Vending Machines

45811 Clothing & Clothing Accessories

45993 Manufactured (Mobile) Home Dealers

459991 Tobacco, Electric Cigarette, & Other Smoking

45421 Vending Machines Operators

Men’s, Women’s, Children’s, Family Clothing Stores & Clothing accessories & Other Clothing Stores & Electronic Shopping & Mail-Order Houses & Other Direct Selling Establishments

45393 Manufactured (Mobile) Home Dealers

453991 Tobacco Stories

44 of 63

Publishing

2022

2017

51311 Newspaper

51312 Periodical

51313 Book

51314 Directory & Mailing Lists

513191 Greeting Cards

513199 All Other Publishing

51321 Software

51111 Newspaper Publishers & Pt 51913 Internet Newspaper

51112 Periodical & Pt 51913 Internet Periodicals

51113 Books & Pt 51913 Internet Books

51114 Directory & Mailing Lists & Pt 51913 Internet Directory and Mailing Lists

511191 Greeting Cards & Pt 51913 Internet Greeting Cards

513199 All Other Publishing & Pt 51913 Internet All Other Publishing

51121 Software Publishing

45 of 63

Broadcasting & Content Providers

2022

2017

51611 Radio

51612 Television

51621 Media Streaming Distribution Services, Social Networks, and Other Media Networks & Content providers

515112 Radio Stations

Pt 515120 Television Broadcasting

515111 Radio Networks & 51521 Cable & Other Subscription Programming & 51911 News Syndicates & Pt 51512 Television Networks & Pt Internet Broadcasting

46 of 63

Telecommunications

2022

2017

517111 Wired Carriers

517112 Wireless Carriers

717121 Telecom Resellers

517122 Agents For Wireless

51781 All Other

517311 Wired Telecommunications Carriers

Pt. 517312 Wireless Carriers except Agents

Pt 517911 Telecommunications Resellers except Agents

Pt 517312 Wireless Agents & Pt 517911 Resellers except Agents

517919 All Other Telecommunications

47 of 63

Web Search Portals, Libraries, Archives, Others Information Services

2022

2017

519

51921 Libraries & Archives

51929 Web Search Portals and All Other Information Services

Pt 519 News syndicates and Internet publishing & Broadcasting

51912 Libraries & Archives

Pt 519130 Web Search Portals & 51919 All Other Information Services

48 of 63

Banking

2022

2017

522180 Savings Institutions & Other Depository Credit Intermediation

533399 International, Secondary Market, & All Other Nondepository Credit

52315 Investment Banking & Securities Intermediation

52316 Commodity Contracts

523940 Portfolio Management & Investment Advice

52212 Savings Institutions & 52219 Other Depository Credit Intermediation

522293 International Trade Financing & 522294 Secondary Market Financing & 522298 All Other Nondepository Credit Intermediation

52311 Investment Banking and Securities Dealing & 523120 Securities Brokerage

52313 Commodity Contracts Dealing & 523140 Commodity Contracts Brokerage

52392 Portfolio Management & 52393 Investment Advice

49 of 63

Repair Services

2022

2017

811114 Specialized Automotive Repair

81121 Electronic & Precision equipment Repair & Maintenance

811112 Auto Exhaust System & 811113 Auto Transmission &

811118 Other Automotive Mechanical & Electrical Maint

811211 Consumer Electronics & 811212 Computer and Office Machine & 811213 Communications Equipment & 811219 Other Electronic and Precision Equipment Repair and Maintenance

50 of 63

Subject Series NAPCS x NAICS

  • Use to be
    • Merchandise Line
    • Product Line
    • Revenue Line
    • Service Line

51 of 63

North American Product Classification System 2017 (NAPCS 2017) version Beta 1.0

Hierarchical Structure

Example (library services)

New Product-, Merchandise-,

and Services- Lines

52 of 63

What and why NAPCS?

What is the purpose of NAPCS?

Comprehensive demand/market-oriented classification framework for services and goods.

NAPCS was developed as a reference classification to facilitate the analysis of economic data based on markets rather than production processes and allows comparisons of products among the three North American countries.

What is the relationship between NAPCS and NAICS?

NAPCS, a product classification system, and NAICS, an industry classification system, are independent but complementary.

A product produced/sold/distributed by multiple industries carries the same title, definition, and code in NAPCS, regardless of its industries of origin.

Products can be linked to the industries that produce/sell/distribute them, and industries can be linked to the products.

What else can NAPCS be used for?

BEA’s National Accounts (NIIP), Harmonized Commodity Description and Coding System (HS) 2012 and Extended Balance of Payments Services (EBOPS) 2010.

53 of 63

NAPCS Structure

54 of 63

NAPCS: Books

55 of 63

Other Changes with the 2017 Economic Census

  • New disclosure rules -- new privacy rules will result in the establishment count being suppressed when less than 3 or when the other statistics are suppressed.
    • You will be seeing a lot more of D
  • Local areas published by sector – Place-level data will no longer be available for the Manufacturing sector and the NAICS and geographic levels published for other sectors may be adjusted based on data quality and privacy issues.
    • less geographic details
  • Introduction to the Annual Business Survey (ABS) -- The Survey replaces three existing surveys: the five-year Survey of Business Owners (SBO) for employer businesses, the Annual Survey of Entrepreneurs (ASE), and the Business Research and Development and Innovation Survey for Microbusinesses (BRDI-M).

56 of 63

Changes

Economic Census NOT Population & Housing Census

North American Industry Classification System (NAICS)

How are Industries classified

North American Product Classification System (NAPCS)

How are Products classified

Cigarettes are Products and Convenience Stores are the Industry

Understanding the levels of Geography in Economic Census

Going beyond the Geographic Reports into the Series Reports

Subject Reports coming out in November 2020

Review the survey instrument for the industry of interest.

https://bhs.econ.census.gov/ombpdfs

57 of 63

Data ANALYSIS

MENU

ANALYSIS

CONTACT

Sir Arthur Conan Doyle

58 of 63

Reflection

What is your next step with this information?

Jamboard

59 of 63

Let’s discuss

boettcher@georgetown.edu

202 687-7495

Twitter: @jennywombat

These slides are licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.

© Bill Waterhouse, with permission

60 of 63

61 of 63

THANKS!

Do you have any questions?

youremail@freepik.com

+91 620 421 838

yourcompany.com

Please keep this slide for attribution

Data ANALYSIS

MENU

ANALYSIS

CONTACT

CREDITS: This presentation template was created by Slidesgo, including icons by Flaticon and infographics & images by Freepik

62 of 63

Boettcher webinars to watch

2019

2019

2021

2020

2018

2017

ZombieList

Slides only

2022

63 of 63

Instructions for use

In order to use this template, you must credit Slidesgo by keeping the Thanks slide.

You are allowed to:

- Modify this template.

- Use it for both personal and commercial projects.

You are not allowed to:

- Sublicense, sell or rent any of Slidesgo Content (or a modified version of Slidesgo Content).

- Distribute Slidesgo Content unless it has been expressly authorized by Slidesgo.

- Include Slidesgo Content in an online or offline database or file.

- Offer Slidesgo templates (or modified versions of Slidesgo templates) for download.

- Acquire the copyright of Slidesgo Content.

For more information about editing slides, please read our FAQs or visit Slidesgo School:

https://slidesgo.com/faqs and https://slidesgo.com/slidesgo-school