Browse

European harvests and weather, 2000–2024

Public
Explore tables

European harvests and weather, 2000–2024

Explore how European crop yields vary with early-season weather and FAO price context. This fixed snapshot covers five crops across 69 regions from 2000 to 2024, with one row per region, crop, and harvest year. Use it for regional yield models with a June 1 predictor cutoff.

Weather is a single grid point per region, not a cropland-weighted average.

Coverage

  • Geography: 69 regions in Czechia, Austria, Poland, Germany and metropolitan France. Germany uses NUTS 1 states. The others use NUTS 2 regions.
  • Grain: region × crop × harvest year. Verified 7,596 records and 47 columns after matching positive crop area to reported production.
  • Crops: common wheat and spelt, barley, grain maize, rapeseed and potatoes.
  • Window: harvests in 2000–2024, with varying regional histories. Snapshot only. No scheduled updates.
  • Predictor cutoff: June 1. Weather uses January 1–May 31. FAO prices use January–April to allow for monthly publication delay.

Columns

  • country, region, region_name, nuts_level, crop_code, crop_name, harvest_year: identifiers and classifications.
  • predictor_cutoff: June 1 of the harvest year, a date cutoff, not a historical release-vintage guarantee.
  • weather_latitude, weather_longitude: GISCO cartographic label point used for the NASA request.
  • outcome_area_ha, outcome_production_t, outcome_yield_t_ha: reported area, final production at EU standard humidity and production/area yield. Exclude all three from predictors. Yield is the continuous outcome. Define a poor-harvest threshold downstream.
  • crop_observation_flags: original Eurostat provisional, estimate or break flags, combined across area and production.
  • weather_days, complete_weather_days: observed and complete days, expected 151 or 152 each year.
  • jan_may_mean_temp_c, jan_may_max_temp_c, jan_may_min_temp_c: mean temperature and extremes, degrees C.
  • jan_may_rainfall_mm, jan_may_humidity_pct, jan_may_solar_mj_m2: accumulated precipitation, mean humidity and accumulated shortwave irradiance.
  • jan_may_frost_days, jan_may_hot_days, jan_may_dry_days: days below 0 C minimum, at least 30 C maximum, or below 1 mm precipitation.
  • jan_* through may_*: monthly temperature means, precipitation totals and shortwave irradiance totals.
  • fao_food_*, fao_cereals_*, fao_oils_*: January–April means and April levels, 2014–2016=100. fao_months verifies four observations.

Missing values

Rows without reported production or a positive area are excluded. No area or yield is imputed. NASA -999 sentinels become null. Complete early-year weather and FAO coverage are checked before accepting the table. Zero production with positive area is retained.

Suitable for

  • Regional yield and weather exploration, maps and simple prediction baselines.
  • Comparing heat, rain, frost and market conditions across crops.
  • Downstream poor-harvest modelling with year-based and region-based validation. Weather repeats across crops within a region/year. Commodity prices repeat across regions. Rows are not independent trials.

Weather is a local grid proxy at a cartographic label point, not a cropland-weighted regional average. Predictors omit the previous autumn, soils, irrigation and farm management. Series use current region identifiers where observations exist, without reconstructing past boundaries. Revised source data and weather reanalysis are not historical release vintages, so this table does not prove real-time forecast performance.

Source and rights

Eurostat APRO_CPSHR and GISCO NUTS 2024. NASA POWER MERRA-2/CERES. FAO Food Price Index, accessed 9 September 2026. Derived by projection, unit conversion, weather aggregation and joins. Attribute original publishers. No endorsement or responsibility for this derivative is implied. Original data are freely accessible. GISCO geographic reuse conditions apply. Research use, with publisher-specific terms rather than a single blanket licence.

Tables

Table healthLiveregional_harvest_weatherTable detailsNameregional_harvest_weatherColumns47
Table overviewPublished rows7,596Columns47 rows47 cols
Update detailsStatusLiveLast published9 Sept 2026

Sources

3 publishers
NASA POWER HomepageReliable analysis-ready data from NASA Earth observations, modeling, and scientific expertise to inform decisions in energy, infrastructure, and agriculture.1 endpoint
About
Reliable analysis-ready data from NASA Earth observations, modeling, and scientific expertise to inform decisions in energy, infrastructure, and agriculture.
Requests
69 requests across 1 endpoint
EndpointRequests / coverage
/api/temporal/daily/point69 requests
European Commission, official websiteThe official website of the European Commission, providing access to information about its political priorities, policies and services7 endpoints
About
The official website of the European Commission, providing access to information about its political priorities, policies and services
Requests
7 requests across 7 endpoints
EndpointRequests / coverage
ec.europa.eu/eurostat/api/dissemination/sdmx/2.1/data/apro_cpshr/A.C1110+C1300+C1500+I1110+R1000.AR_THS_HA+HPRD_HUMD_EU_THS_T.FR10+FRB0+FRC1+FRC2+FRD1+FRD2+FRE1+FRE2+FRF1+FRF2+FRF3+FRG0+FRH0+FRI1+FRI2+FRI3+FRJ1+FRJ2+FRK1+FRK2+FRL0+FRM01 request
ec.europa.eu/eurostat/api/dissemination/sdmx/2.1/data/apro_cpshr/A.C1110+C1300+C1500+I1110+R1000.AR_THS_HA+HPRD_HUMD_EU_THS_T.AT11+AT12+AT13+AT21+AT22+AT31+AT32+AT33+AT341 request
ec.europa.eu/eurostat/api/dissemination/sdmx/2.1/data/apro_cpshr/A.C1110+C1300+C1500+I1110+R1000.AR_THS_HA+HPRD_HUMD_EU_THS_T.PL21+PL22+PL41+PL42+PL43+PL51+PL52+PL61+PL62+PL63+PL71+PL72+PL81+PL82+PL84+PL91+PL921 request
gisco-services.ec.europa.eu/distribution/v2/nuts/geojson/NUTS_LB_2024_4326_LEVL_2.geojson1 request
ec.europa.eu/eurostat/api/dissemination/sdmx/2.1/data/apro_cpshr/A.C1110+C1300+C1500+I1110+R1000.AR_THS_HA+HPRD_HUMD_EU_THS_T.CZ01+CZ02+CZ03+CZ04+CZ05+CZ06+CZ07+CZ081 request
gisco-services.ec.europa.eu/distribution/v2/nuts/geojson/NUTS_LB_2024_4326_LEVL_1.geojson1 request
ec.europa.eu/eurostat/api/dissemination/sdmx/2.1/data/apro_cpshr/A.C1110+C1300+C1500+I1110+R1000.AR_THS_HA+HPRD_HUMD_EU_THS_T.DE1+DE2+DE4+DE7+DE8+DE9+DEA+DEB+DEC+DED+DEE+DEF+DEG1 request
www.fao.orgwww.fao.org1 endpoint
Requests
1 request across 1 endpoint
EndpointRequests / coverage
/media/docs/worldfoodsituationlibraries/default-document-library/food_price_indices_data.csv1 request

Details

Contents
1 table · 7,596 rows (est.) · 47 columns
Updated
9 September 2026
Published
12 September 2026
Version
2026-09-09
Visibility
Public
Publisher
Mostly Right
Topics
agriculture · europe · crop yields +4

Activity

Views237+237 in the last 30 days
Likes1+1 in the last 30 days
Uses0+0 in the last 30 days

Comments

0

No comments yet. Questions about coverage, licensing, or how a column is derived belong here, in the open, beside the data.

Sign in to join the conversation.

Use this data for free

A free workspace gives you an API key to query whole tables, download Parquet and connect your AI tools.

We are in open beta, so expect changes week to week.

Create a free workspace

Already have an account? Log in

DocsPricingTermsPrivacyStatus