CC-BY-4.0 Open Research Dataset • 4,315 Audited Rows • 3 Splits

Texas Commercial Trades & Fleet Risk Index (2026)

Commercial insurance underwriting reference dataset covering 40 major Texas business trades and 24 active Texas property, casualty, and specialty coverage lines. Combines 2022 US Census County Business Patterns (FIPS 48) establishment counts, employment, and annual payroll across Texas counties with NCCI workers' compensation class codes, ISO general liability class codes, and Texas statutory licensing/financial responsibility frameworks (TDI, TxDMV, FMCSA, TDLR, TSBPE, TDI DWC).

4,315
Audited Rows
3
Parquet / CSV Splits
CC-BY-4.0
Open License
v1.0.0
10.5281/zenodo.24391176
Structured Files & Parquet Configs

Multi-Config Splits & Direct Downloads

Every split is published as UTF-8 CSV and MLCommons Croissant 1.0 metadata for direct pandas, DuckDB, and Hugging Face ingestion.

Config NameCSV DownloadRowsDescription
defaulttx_40_trade_naics_benchmarks.csv4040 Texas commercial trades — NAICS, Census CBP establishments, employment, payroll & licensing bodies
county_trade_employment_payrollcounty_trade_employment_payroll.csv4,251County-level Texas Census CBP 2022 establishment, employment & payroll matrix across the 40 trades
tx_statutory_coverage_linestx_statutory_coverage_lines.csv2424 active Texas personal & commercial insurance lines — statutory references & underwriting notes

Swipe table horizontally to view all columns →

Schema Inspection

Live Sample Preview (First 12 Rows — tx_40_trade_naics_benchmarks.csv)

Showing the first 7 columns and 12 rows of the primary release file.

trade_slugtrade_titlecategorynaics_codetx_establishments_2022tx_employees_2022tx_annual_payroll_usd
fast-casual-restaurantsFast-Casual, Cafes & Quick-ServiceFood, Hospitality & Retail722513236975136649883006000
medical-clinicsMedical Clinics, Med-Spas & PhysiciansHealth, Wellness & Care6211112042521086920832936000
full-service-restaurantsFull-Service Restaurants & SteakhousesFood, Hospitality & Retail7225112019846616111868604000
law-firmsLaw Firms & Legal PracticesProfessional, Tech & Real Estate541110136888506910347125000
dental-practicesDental, Orthodontic & Oral Surgery PracticesHealth, Wellness & Care62121011755886874995234000
real-estate-brokerageReal Estate Brokerages & AgentsProfessional, Tech & Real Estate53121011063350433190146000
hvac-contractorHVAC & Mechanical ContractorsConstruction & Trades23822086491008406629100000
plumbing-contractorPlumbing & Pipefitting ContractorsConstruction & Trades23822086491008406629100000
hotshot-long-haul-truckingHotshot & Long-Haul TruckingTrucking & Auto Services4841216568603723500624000
it-consultants-mspIT Consultants, Software & MSPsProfessional, Tech & Real Estate54151161479358311381242000
auto-repair-shopAuto Repair & Mechanical ShopsTrucking & Auto Services8111116072320931656517000
remodeling-contractorResidential Remodelers & Kitchen/BathConstruction & Trades2361185912208251220155000

Swipe table horizontally to view all columns →

Provenance & Academic Attribution

Primary Authoritative Sources & BibTeX Citation

All figures are derived directly from public federal and state records with reproducible extraction pipelines.

BibTeX Citation (CC-BY-4.0)
@dataset{giq_texas_commercial_trades_risk_2026,
  author    = {Get Insured Quick — Texas Insurance Open Research Desk},
  title     = {Texas Commercial Trades & Fleet Risk Index (2026)},
  year      = {2026},
  publisher = {Zenodo},
  version   = {1.0.0},
  doi       = {10.5281/zenodo.24391176},
  url       = {https://getinsuredquick.com/datasets/texas-commercial-trades-risk-2026/}
}
30+ Texas Carriers Texas Commercial Trades & Fleet Ri • Open Data
Get a Quote