Skip to content

Ordertoai/us-workers-comp-rate-cells

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

US Workers Compensation Rate Cells Dataset

13,833 NCCI class code × US state rate cells sourced from state insurance department filings and rating-bureau publications.

Each row: an occupation classification (NCCI class code) + state combination, with the filed workers comp insurance rate per $100 of payroll.

This is the open-data dataset powering wcclasscode.com — the free workers comp rate database operated by Ordertoai LLC.

Files

  • rate-cells.csv — 13,833 rows, CSV format with header row, ~1.8 MB
  • rate-cells.json — same data, JSON array, ~4.5 MB

Schema

Column Type Description
code string NCCI class code (e.g., "5403", "8810", "9079")
occupation_primary string Primary occupation classification name (NCCI Scopes manual)
industry string Higher-level industry grouping (construction, manufacturing, retail, etc.)
state string 2-letter US state code (e.g., "CA", "NY", "TX")
state_name string Full state name
rate number Filed rate per $100 of payroll, decimal
rate_type string Filing type: "loss cost", "base rate", "advisory", etc.
effective_date string When the rate took effect (YYYY-MM-DD)
rating_authority string Authority that filed the rate (NCCI, WCIRB for CA, NYCIRB for NY, etc.)
is_top_50_code boolean Whether this is in the top 50 most-common codes nationally
state_is_indep_bureau boolean True if state uses its own rating bureau (CA, NY, PA, NJ, etc.)
state_is_monopolistic boolean True if state has monopolistic-fund coverage (OH, WA, ND, WY)

State coverage

All 50 states + DC. Coverage varies by state because some states file fewer class codes than NCCI's national set:

  • California (WCIRB): 498 codes filed
  • Alabama (NCCI): 612 codes
  • Alaska: 616 codes
  • ... (full distribution in rate-cells.csv)

Use cases

  • Building a workers comp premium estimator
  • Comparing rates across states for a specific occupation
  • Analyzing rate trends + filing patterns
  • Industry-level rate analysis
  • Academic / regulatory research

License

CC BY 4.0 — free to use, modify, redistribute with attribution to wcclasscode.com.

See it live

Browse the full database (with calculators, settlement charts, EMR explainers, and state-by-state coverage) at wcclasscode.com.

Methodology

Rates are sourced from:

  • State Department of Insurance public filings
  • NCCI Scopes Manual (public)
  • Independent rating bureau publications (WCIRB, NYCIRB, PCRB, NJCRIB, WCRIBMA, etc.)
  • AM Best public ratings

Verified on a quarterly cycle. The full methodology, source citations, and confidence audit are at:

Maintainer

This dataset is operated by Ordertoai LLC (Texas LLC). Site: wcclasscode.com. Wikidata: Q139714089.

Not legal or insurance advice

This data is provided for informational purposes only. Verify rates with your state's rating bureau or department of insurance before pricing a binding insurance quote. See the full disclaimer.

Versions

Version Date Cells Notes
1.0 2026-05-12 13,833 Initial public release

About

Open dataset: 13,833 US workers compensation NCCI class code × state rate cells. CC BY 4.0. Sourced from state insurance department filings + rating bureau publications. Powers wcclasscode.com

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors