[Demography] Mortality in Italy by province, age and sex — COVID excess, aging, and territorial gaps (2013–2024)

[Gabrymi93]

New dataset: DEMO_R_MAGEC3 — Deaths by age group, sex and NUTS3 region

Just published: 1,618,272 rows covering all EU countries, 12 years (2013–2024), at NUTS3 (province) level.

What's in the data

Italy totals by year:

Year	Deaths
2013	2,402,976
2014	2,393,456
2015	2,590,284
...	...
2019	2,537,668
2020	2,961,268 ← +16.7% excess
2021	2,805,384
2022	2,860,308
2023	2,684,260
2024	2,612,436

COVID excess (2020): 423,600 extra deaths vs 2019 — consistent with known COVID impact.

Deaths by sex (2024):

• Female: 338,705 (51.9%)
• Male: 314,404 (48.1%)

Elderly concentration: 82% of deaths are 75+, and 42% are 85+.

Top provinces for deaths (2024):

Province	Deaths
Roma	87,624
Milano	63,732
Napoli	57,340
Torino	52,662
Palermo	25,590

Questions this data can answer

• Excess mortality per province — which areas were hit hardest by COVID?
• Aging divide — where do people die older? North vs South vs Islands?
• Gender gap — female mortality advantage: how many more women than men over 80?
• Province rankings — standardised mortality rates (once you have population data to normalise)

How to query

-- Total deaths in Italian provinces, 2024, male vs female
SELECT geo_label_en, sex_label_en, SUM(value) AS deaths
FROM read_parquet('gs://dataciviclab-clean/eurostat/eurostat_demo_r_magec3_nuts3/eurostat_demo_r_magec3_nuts3_2026_clean.parquet')
WHERE geo LIKE 'IT%' AND year=2024 AND unit='NR' AND age='TOTAL'
GROUP BY geo_label_en, sex_label_en
ORDER BY deaths DESC;

Or via MCP: eurostat_query(slug='eurostat_demo_r_magec3_nuts3', sql="...")

What would you like to explore?

Post your questions below. Some ideas:

• Which province had the highest COVID excess mortality?
• How does male vs female mortality change with age?
• Is the North-South gap in life expectancy growing or shrinking?