Premium Density and Population Demographics
This dataset offers detailed insurance premium, penetration, and demographic metrics by geographic area, including population, household income, GDP, and property values. It enables market opportunity analysis, segmentation, and benchmarking for insurers, consultants, and financial analysts seeking to identify growth potential and underserved regions.
Sample rows
preview · 8 of 600 rows · all 16 columns| area_idstring | average_household_incomefloat | countrystring | area_namestring | state_provincestring | citystring | postal_codestring | population_totalinteger | household_countinteger | gdpfloat | average_property_valuefloat | insurance_premium_totalfloat | insurance_penetration_ratefloat | premium_density_per_capitafloat | premium_density_per_householdfloat | data_yearinteger |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| US_NY_001_MN | 124700 | US | Manhattan District | NY | New York | 10001 | 1623000 | 732100 | 295000000000 | 2100000 | 2350000000 | 0.8 | 1448.25 | 3209.95 | 2023 |
| UK_LND_002_WM | 137300 | UK | Westminster Central | London | London | SW1A1AA | 107500 | 49300 | 8500000000 | 2450000 | 370000000 | 4.35 | 3441.86 | 7509.13 | 2021 |
| FR_IDF_003_PA | 121500 | France | Paris Arrondissement | Île-de-France | Paris | 75001 | 215100 | 102800 | 12000000000 | 1870000 | 530000000 | 4.42 | 2463.67 | 5154.39 | 2022 |
| DE_BE_004_MZ | 94000 | Germany | Mitte Zentrum | Berlin | Berlin | 10115 | 365400 | 196200 | 9800000000 | 1450000 | 270000000 | 2.76 | 738.98 | 1376.28 | 2020 |
| IN_KA_005_BN | 65000 | India | Bangalore Urban | Karnataka | Bangalore | 560001 | 8820000 | 1958000 | 22000000000 | 1100000 | 325000000 | 1.48 | 36.85 | 165.97 | 2024 |
| BR_SP_006_SP | 74000 | Brazil | São Paulo Central | São Paulo | São Paulo | 01001-000 | 12380000 | 3465000 | 72000000000 | 890000 | 520000000 | 0.72 | 41.99 | 150.07 | 2022 |
| AU_VIC_007_MB | 98000 | Australia | Melbourne City | Victoria | Melbourne | 3000 | 1492000 | 520900 | 32000000000 | 1540000 | 670000000 | 2.09 | 449.12 | 1286.57 | 2023 |
| CA_BC_008_VC | 112000 | Canada | Vancouver Metro | British Columbia | Vancouver | V6B3K9 | 675200 | 324700 | 10200000000 | 1240000 | 350000000 | 3.43 | 518.62 | 1078.53 | 2021 |
| FR_IDF_009_MT | 93000 | France | Montreuil District | Île-de-France | Montreuil | 93100 | 110500 | 48200 | 2600000000 | 860000 | 69000000 | 2.65 | 624.43 | 1432.78 | 2019 |
| NG_LA_010_IK | 23400 | Nigeria | Ikeja Centre | Lagos | Ikeja | 100271 | 803000 | 205100 | 810000000 | 180000 | 6700000 | 0.83 | 8.34 | 32.67 | 2024 |
| JP_TK_011_SB | 2520000 | Japan | Shibuya District | Tokyo | Shibuya | 150-0001 | 225800 | 135800 | 6200000000 | 67000000 | 98000000 | 1.58 | 433.98 | 721.68 | 2022 |
| CN_BJ_012_BJ | 102000 | China | Beijing Urban | Beijing | Beijing | 100000 | 21700000 | 5002000 | 430000000000 | 2600000 | 2800000000 | 0.65 | 128.99 | 559.68 | 2023 |
| IT_LAZ_013_RM | 88000 | Italy | Rome Centro | Lazio | Rome | 00184 | 2873000 | 1048000 | 42000000000 | 1100000 | 600000000 | 1.43 | 208.89 | 572.77 | 2024 |
| ZA_GP_014_JSB | 67000 | South Africa | Johannesburg CBD | Gauteng | Johannesburg | 2001 | 957000 | 302300 | 5700000000 | 380000 | 32000000 | 0.56 | 33.43 | 105.87 | 2022 |
| RU_MOS_015_MS | 84000 | Russia | Moscow City | Moscow | Moscow | 101000 | 11920000 | 3864000 | 72000000000 | 990000 | 780000000 | 1.08 | 65.43 | 201.81 | 2023 |
| SG__016_CT | 79000 | Singapore | Central Singapore | blank | Singapore | 049315 | 560000 | 186700 | 5200000000 | 1480000 | 120000000 | 2.31 | 214.29 | 643.12 | 2024 |
| CH_ZH_017_ZH | 166000 | Switzerland | Zürich Zentrum | Zürich | Zürich | 8001 | 428700 | 153700 | 6800000000 | 2100000 | 67000000 | 0.99 | 156.34 | 435.91 | 2021 |
| AR_BA_018_BA | 52000 | Argentina | Buenos Aires Centro | Buenos Aires | Buenos Aires | C1000 | 3056000 | 1272000 | 15600000000 | 910000 | 84000000 | 0.54 | 27.5 | 66.05 | 2022 |
| US_CA_019_LA | 94000 | US | Los Angeles Metro | CA | Los Angeles | 90001 | 3986000 | 1358900 | 93200000000 | 880000 | 650000000 | 0.7 | 163.1 | 478.41 | 2023 |
| CA_ON_020_TR | 103000 | Canada | Toronto Downtown | Ontario | Toronto | M5H2N2 | 2732000 | 956100 | 51000000000 | 1280000 | 520000000 | 1.02 | 190.44 | 544.03 | 2022 |
What the 600 rows show
from the 600-row sample- 97,000median average_
household_ income - 115state provinces
- 126cities
- 820,000median population_
total - 296,500median household_
count - 8,110,000,000median gdp
Median 97,000, from 0.0 to 4,700,000.
- string 6
- integer 3
- float 7
Columns
16 columns in two groups| column | type | description | example |
|---|---|---|---|
| Text 6 columns | |||
area_id | string | Unique identifier for the geographic area (e.g., city, county, region)unique | US_NY_001_MN |
area_name | string | Name of the geographic area | Manhattan District |
country | string | Country where the geographic area is located | US |
state_province | string | State or province of the geographic areaoptional | NY |
city | string | City of the geographic areaoptional | New York |
postal_code | string | Postal code of the area (if applicable)optional | 10001 |
| Numbers 10 columns | |||
population_total | integer | Total population in the geographic area0 or more | 1623000 |
household_count | integer | Number of households in the geographic area0 or more | 732100 |
average_household_income | float | Average household income in the area (in local currency)0 or more | 124700 |
gdp | float | Gross Domestic Product for the area (in local currency)0 or more · optional | 295000000000 |
average_property_value | float | Average property value in the area (in local currency)0 or more · optional | 2100000 |
insurance_premium_total | float | Total insurance premium collected in the area (in local currency)0 or more | 2350000000 |
insurance_penetration_rate | float | Insurance penetration rate (premium as a percentage of GDP)0 to 100 · optional | 0.8 |
premium_density_per_capita | float | Insurance premium per capita in the area0 or more · optional | 1448.25 |
premium_density_per_household | float | Insurance premium per household in the area0 or more · optional | 3209.95 |
data_year | integer | Year the data was collected1,900 to 2,100 | 2023 |
Use it for
An insurance dashboard
Average_
household_ income and a breakdown of country. Excel, Power BI or Tableau. What pattern can you find in 600 rows?
A class exercise
Hand out the rows and one question. Everyone works from the same 600 rows.
- Areas600US_NY_001_MN124700UK_LND_002_WM137300FR_IDF_003_PA121500
A software demo
Believable areas with area_
name, country and state_ province to fill a screen in front of a buyer.
blueprint · premium-density-and-population-demographics
Behind this dataset
Same schema. As many rows as you need.
These 600 rows came out of a blueprint — 16 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.
- Premium per capita
- Premium per household
- Premium as percentage of income
- Insurance penetration rate
- Population density
- Median household income
- Home ownership rates
- Vehicle ownership rates
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
- premium-density-and-population-demographics