Commercial Lines Premium by Industry Segment

This dataset provides detailed commercial insurance premium and exposure data broken down by SIC/NAICS industry codes, economic sectors, and portfolios over time. It enables in-depth analysis of business mix, industry concentration, and portfolio diversification, supporting risk management and strategic decision-making for insurers and analysts.

  • last updated 2 Nov 2025
  • by GoMask
The brief that made it

Portfolio diversification and concentration analysis

Sample rows

preview · 8 of 800 rows · all 13 columns
record_idstringwritten_premiumfloatsic_codestringnaics_codestringindustry_namestringeconomic_sectorstringpolicy_yearintegerexposurefloatbusiness_mix_percentagefloatindustry_concentration_percentagefloatportfolio_idstringdata_sourcestringlast_updateddatetime
REC000000015200000.542752blankCommercial Printing ServicesManufacturing201784000000.238.237.95PORT001MarketScan USA2017-06-15T10:34:05
REC00000002230000blank541612Human Resources ConsultingServices202015000001.411.52PORT002GlobalData Direct2020-09-21T14:08:20
REC00000003740000.455999blankMiscellaneous Retail StoresRetail2019121000002.212.18PORT001InsureNet2019-02-12T11:19:53
REC000000041250000blank212112Bituminous Coal Underground MiningMining201680000002.672.44PORT004IndustryRisk2016-12-08T09:05:15
REC00000005320000.38211blankElementary and Secondary SchoolsGovernment202180000000.791.01PORT003PolicyDataHub2021-03-27T16:46:32
REC000000061800000.7blank722513Limited-Service RestaurantsHospitality2018250000004.153.97PORT004MarketScan USA2018-07-18T17:42:50
REC000000072100000.111521blankGeneral Contractors - Residential BuildingsConstruction2022240000005.274.91PORT002GlobalData Direct2022-01-11T13:12:37
REC0000000850000blank111120Cotton FarmingAgriculture20156500000.110.19PORT005AgriInsure2015-10-05T08:25:29

What the 800 rows show

from the 800-row sample
  • 2,200,000median written_premium
  • 49economic sectors
  • 144data sources
  • 179portfolios
  • 52,490,000median exposure
  • 3.0median business_mix_percentage
written_premium800 rows, in bands of 10M
037575074542900004040M80Mwritten_premium →

Median 2,200,000, from 50,000 to 75,000,000.

13 columns by typefrom the column list below
  • string 7
  • integer 1
  • float 4
  • datetime 1

Columns

13 columns in three groups
blueprint · 13 columns
columntypedescriptionexample
Text 7 columns
record_idstringUnique identifier for each premium recorduniqueREC00000001
sic_codestringStandard Industrial Classification code representing the industry segmentoptional2752
naics_codestringNorth American Industry Classification System code representing the industry segmentoptional541612
industry_namestringDescriptive name of the industry segmentCotton Farming
economic_sectorstringEconomic sector to which the industry belongs (e.g., Manufacturing, Services, Agriculture)Manufacturing
portfolio_idstringIdentifier for the insurance portfolio or book of businessPORT001
data_sourcestringSource system or provider of the premium and exposure dataoptionalMarketScan USA
Numbers 5 columns
policy_yearintegerYear for which the premium and exposure data is reported1,900 to 2,1002017
written_premiumfloatTotal written premium amount for the industry segment in the given year (in USD)0 or more5200000.54
exposurefloatExposure value for the industry segment (e.g., payroll, sales, units insured)0 or more84000000.23
business_mix_percentagefloatPercentage of total portfolio premium represented by this industry segment0 to 100 · optional8.23
industry_concentration_percentagefloatPercentage of total portfolio exposure represented by this industry segment0 to 100 · optional7.95
Dates and times 1 column
last_updateddatetimeTimestamp when this record was last updatedoptional2017-06-15T10:34:05

Use it for

  • median written…2,200,000800 rows

    An insurance dashboard

    Written_premium. Excel, Power BI or Tableau.

  • What pattern can you find in 800 rows?

    A class exercise

    Hand out the rows and one question. Everyone works from the same 800 rows.

  • A software demo

    Believable records with sic_code, naics_code and industry_name to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 13 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset800 rows13 columns
Yours1,000 rows13 columns

blueprint · commercial-lines-premium-by-industry-segment

Behind this dataset

Same schema. As many rows as you need.

These 800 rows came out of a blueprint — 13 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • SIC (Standard Industrial Classification) codes
  • NAICS (North American Industry Classification System)
  • Industry group aggregations
  • Premium by industry segment
  • Policy count by industry
  • Industry concentration limits
  • Economic sector diversification
  • Cyclical industry exposure
Rows
Open the blueprint in Data Factory

1 credit per row. New accounts start with 25 free credits.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
commercial-lines-premium-by-industry-segment

More in Insurance

Browse all
Also in InsuranceFacultative Reinsurance PlacementsDriver Behavior Risk IndicatorsInsurance Claims Fraud DetectionAll 1,954 datasets

What should your data show?

Preview 20 rows free
No signup. No card.