NAICS Code Reference

Understanding NAICS industry codes and how to query them in the PPP Loans dataset.

NAICS (North American Industry Classification System) codes are 6-digit hierarchical codes used to classify businesses by industry. Every PPP loan record includes the borrower's NAICS code, making it one of the most useful filters for industry-level analysis.

How NAICS Codes Work

NAICS codes follow a hierarchical structure where each additional digit narrows the industry:

Digits	Level	Example	Meaning
2	Sector	`72`	Accommodation and Food Services
3	Subsector	`722`	Food Services and Drinking Places
4	Industry Group	`7225`	Restaurants and Other Eating Places
5	Industry	`72251`	Restaurants and Other Eating Places
6	National Industry	`722511`	Full-Service Restaurants

Querying NAICS Codes

Use the like operator with wildcards to query at any level of the hierarchy:

# All Accommodation & Food Services (sector 72)
?naics_code=like.72*

# Just restaurants (industry group 7225)
?naics_code=like.7225*

# Exact: Full-Service Restaurants only
?naics_code=eq.722511

# Multiple sectors
?naics_code=in.(722511,722513,722514)

NAICS Sector Table

All 20 top-level NAICS sectors and how to filter for them:

Code	Sector	Filter	PPP Relevance
`11`	Agriculture, Forestry, Fishing and Hunting	`like.11*`	Farms, ranches, fisheries
`21`	Mining, Quarrying, and Oil and Gas Extraction	`like.21*`	Oil/gas, mining operations
`22`	Utilities	`like.22*`	Electric, gas, water utilities
`23`	Construction	`like.23*`	General contractors, specialty trades
`31-33`	Manufacturing	`like.31` or `like.32` or `like.33*`	Factories, food processing, fabrication
`42`	Wholesale Trade	`like.42*`	Distributors, merchant wholesalers
`44-45`	Retail Trade	`like.44` or `like.45`	Stores, dealerships, e-commerce
`48-49`	Transportation and Warehousing	`like.48` or `like.49`	Trucking, airlines, warehouses
`51`	Information	`like.51*`	Publishing, telecom, software
`52`	Finance and Insurance	`like.52*`	Banks, insurance, investment firms
`53`	Real Estate and Rental and Leasing	`like.53*`	Property management, real estate agents
`54`	Professional, Scientific, and Technical Services	`like.54*`	Law firms, consulting, accounting, engineering
`55`	Management of Companies and Enterprises	`like.55*`	Holding companies, corporate offices
`56`	Administrative and Support Services	`like.56*`	Staffing, janitorial, security services
`61`	Educational Services	`like.61*`	Schools, training centers, tutoring
`62`	Health Care and Social Assistance	`like.62*`	Doctors, dentists, hospitals, daycare
`71`	Arts, Entertainment, and Recreation	`like.71*`	Theaters, gyms, amusement parks
`72`	Accommodation and Food Services	`like.72*`	Hotels, restaurants, bars, catering
`81`	Other Services (except Public Administration)	`like.81*`	Auto repair, salons, nonprofits, religious orgs
`92`	Public Administration	`like.92*`	Government agencies (rare in PPP)

Top PPP Industries in Detail

These sectors received the most PPP loans. Here are their most common sub-codes:

Restaurants and Food Services (72)

Code	Description	Example Query
`722511`	Full-Service Restaurants	`?naics_code=eq.722511`
`722513`	Limited-Service Restaurants	`?naics_code=eq.722513`
`722514`	Cafeterias and Buffets	`?naics_code=eq.722514`
`722515`	Snack and Nonalcoholic Beverage Bars	`?naics_code=eq.722515`
`721110`	Hotels and Motels	`?naics_code=eq.721110`
`722310`	Food Service Contractors	`?naics_code=eq.722310`
`722410`	Drinking Places (Alcoholic Beverages)	`?naics_code=eq.722410`

Health Care (62)

Code	Description	Example Query
`621111`	Offices of Physicians	`?naics_code=eq.621111`
`621210`	Offices of Dentists	`?naics_code=eq.621210`
`621310`	Offices of Chiropractors	`?naics_code=eq.621310`
`621399`	Offices of Other Health Practitioners	`?naics_code=eq.621399`
`623110`	Nursing Care Facilities	`?naics_code=eq.623110`
`624410`	Child Day Care Services	`?naics_code=eq.624410`

Construction (23)

Code	Description	Example Query
`236220`	Commercial Building Construction	`?naics_code=eq.236220`
`236115`	New Single-Family Housing	`?naics_code=eq.236115`
`238220`	Plumbing, Heating, and AC	`?naics_code=eq.238220`
`238210`	Electrical Contractors	`?naics_code=eq.238210`
`238910`	Site Preparation Contractors	`?naics_code=eq.238910`

Professional Services (54)

Code	Description	Example Query
`541110`	Offices of Lawyers	`?naics_code=eq.541110`
`541211`	Offices of CPAs	`?naics_code=eq.541211`
`541511`	Custom Computer Programming	`?naics_code=eq.541511`
`541611`	Management Consulting	`?naics_code=eq.541611`
`541330`	Engineering Services	`?naics_code=eq.541330`
`541810`	Advertising Agencies	`?naics_code=eq.541810`

Retail Trade (44-45)

Code	Description	Example Query
`441110`	New Car Dealers	`?naics_code=eq.441110`
`445110`	Supermarkets and Grocery Stores	`?naics_code=eq.445110`
`448140`	Family Clothing Stores	`?naics_code=eq.448140`
`452210`	Department Stores	`?naics_code=eq.452210`
`453110`	Florists	`?naics_code=eq.453110`

Example Queries

Find all full-service restaurants in California:

curl "https://newbizbot.ai/api/data/ppp_loans?borrower_state=eq.CA&naics_code=eq.722511&limit=5" \
  -H "Authorization: Bearer YOUR_API_KEY"

Compare healthcare vs. restaurant loans in Texas using aggregate RPCs:

# Healthcare in TX
curl "https://newbizbot.ai/api/data/rpc/ppp_stats_by_industry?p_state=TX&p_naics_prefix=62" \
  -H "Authorization: Bearer YOUR_API_KEY"

# Restaurants in TX
curl "https://newbizbot.ai/api/data/rpc/ppp_stats_by_industry?p_state=TX&p_naics_prefix=7225" \
  -H "Authorization: Bearer YOUR_API_KEY"

Find construction companies that received large loans:

curl "https://newbizbot.ai/api/data/ppp_loans?naics_code=like.23*&initial_approval_amount=gt.1000000&borrower_state=eq.FL&limit=10&order=initial_approval_amount.desc" \
  -H "Authorization: Bearer YOUR_API_KEY"

On this page