[Education] Early school leaving in Europe — 10 questions about who drops out, where and why (2000-2025)

What this dataset contains

eurostat_early_school_leavers_nuts2 (DataCivicLab, source Eurostat) measures the share of 18-24 year olds with at most lower secondary education who are not in further education or training — by NUTS2 region, sex, and age group, for all EU countries.

Coverage: 40K rows, 17 columns, 2000–2025
Granularity: regional (NUTS2), annual
Metric: percentage of population aged 18-24 not in education and without upper secondary degree

---

Questions the data can answer

1. Why is early school leaving 37× higher in Southeast Turkey than in Prague?

Şanlıurfa, Diyarbakır (TR): 48.7% — nearly half of young adults
Praha (CZ): 1.3% — virtually universal upper secondary education

The gap between the best and worst NUTS2 regions in Europe is 37×. Is this driven by economic development, cultural factors, or education policy? Or all three?

2. Is Southern Europe's dropout problem structural?

Spain: several regions above 20% (Ceuta 26%, Melilla 26%)
Italy: Sicilia 15.2%, Sardegna 14.5%, Campania 13.3%
Portugal: some regions above 15%

Mediterranean countries consistently score worse than Northern and Central Europe. Yet Greece (Attiki 2.8%) is an exception. What makes the difference?

3. Which EU countries have virtually solved the dropout problem?

Czechia: Praha 1.3%, Jihovýchod 2.7%
Croatia: Jadranska Hrvatska 1.5%, Panonska 2.4%
Poland: Śląskie 4.1%, several regions under 5%

These countries have dropout rates under 5% across most of their territory. Is it the vocational education system? Stronger social safety nets?

4. Does the gender gap persist everywhere?

In almost all regions, more young men than women leave school early. But the gap varies widely: in some regions it's 1:1, in others men drop out at 2× the rate. Where are women being left behind?

5. Has COVID increased dropouts?

The dataset covers 2020-2025, so you can test whether the pandemic year disrupted education permanently. Some regions showed a spike in 2020; others saw no change. Did COVID widen the gap between rich and poor regions?

6. Is the trend improving across Europe?

The EU target (2030) is to reduce early school leaving to below 9%. Many regions are already there (Czechia, Croatia, Poland at 3-5%). Others (Turkey 25%+, Spain 15%+) have a long way to go. Who will meet the target?

7. Why does Bolzano (€61k GDP/capita) have 14.7% dropout?

Bolzano is the richest region in Italy by GDP per capita. Yet its early school leaving rate (14.7%) is among the highest in Italy — worse than Calabria (10.8%). Is this the "tourist economy effect" — young people leave school early because jobs in hospitality don't require degrees?

8. Are capital regions systematically better?

In many countries, the capital region outperforms the rest: Praha (1.3%), Attiki (2.8%), Wien (~6%), București (~5%). But Warsaw (~8%) and Roma/Lazio (7.4%) are closer to the national average. Maybe the capital effect diminishes as countries develop?

9. How do French overseas territories compare?

Mayotte (42%) and Guyane (29.4%) — French overseas departments — have dropout rates closer to Turkey than to mainland France. Is this a colonial legacy, an economic issue, or a data quality question?

10. Can we map the "educational divide" of Europe?

If you draw a line from Lisbon through Madrid, Rome, and Athens to Istanbul — everything south of this line has higher dropout rates. Everything north (plus Czechia, Austria, Switzerland) has lower rates. Is this the real European divide: education, not GDP?

---

How to explore

Available via MCP: eurostat_query(slug='eurostat_early_school_leavers_nuts2', sql='...')

-- Worst 10 regions in Europe (2024)
SELECT geo_label_en, ROUND(value, 1) AS dropout_pct
FROM data
WHERE unit='PC' AND sex='T' AND year=2024 AND nuts_level='NUTS2' AND value IS NOT NULL
ORDER BY value DESC LIMIT 10;

-- Best 10 regions
SELECT geo_label_en, ROUND(value, 1) AS dropout_pct
FROM data
WHERE unit='PC' AND sex='T' AND year=2024 AND nuts_level='NUTS2' AND value IS NOT NULL
ORDER BY value ASC LIMIT 10;

-- Gender gap in Italy (2024)
SELECT geo_label_en, sex_label_en, ROUND(value, 1) AS pct
FROM data
WHERE unit='PC' AND year=2024 AND nuts_level='NUTS2' AND geo LIKE 'IT%'
  AND sex IN ('M','F')
ORDER BY geo_label_en, sex;

Note: EU-SILC survey data (sample-based). Values under 1% should be treated with caution due to small sample sizes. Turkey is not in the EU but is included in the Eurostat dataset.