Historical Exposure To Drought
OECD dataset from agency OECD.ENV.EPI: DSD_ECH@EXT_DROUGHT_H (1981 - 2024)
@oecd.oecd_env_epi_dsd_ech_ext_drought_h_v2_0
OECD dataset from agency OECD.ENV.EPI: DSD_ECH@EXT_DROUGHT_H (1981 - 2024)
@oecd.oecd_env_epi_dsd_ech_ext_drought_h_v2_0
The dataset provides annual anomalies in land and cropland soil moisture content of the top soil layer (0 to 7 cm) compared to the reference period 1981-2010. Exposure indicators to drought have been prepared by the Organisation for Economic Co-operation and Development (OECD). Please see the working paper for a more complete description of the methods.
The datasets span the period 1981-2024 and is the result of the use of a variety of geospatial data sources, including the ERA5-Land averaged monthly data of volumetric soil moisture and ESA CCI land cover data. Average anomalies have been calculated for both land and cropland exposure to drought. The dataset has a global coverage on a national level; on the sub-national TL2 level (i.e. large subnational regions) results are reported for all OECD countries as well as for Argentina, Brazil, China, India, Indonesia and South Africa. A number of aggregates are included: Euro area, European Union, Advanced economies, Emerging market economies, G7, G20, OECD, OECD Europe, OECD Asia Oceania, OECD Americas and the LAC region.
Data source(s) : Copernicus Climate Change Initiative land cover data and Copernicus Climate Data Store monthly soil moisture data based on the ERA5-Land reanalysis dataset.
Contact : ENV.Stat@oecd.org
CREATE TABLE observations (
"dataflow" VARCHAR,
"ref_area" VARCHAR,
"freq" VARCHAR,
"measure" VARCHAR,
"unit_measure" VARCHAR,
"duration" VARCHAR,
"temp_threshold" VARCHAR,
"ret_period" VARCHAR,
"hurricane_wind_scale" VARCHAR,
"climate_scenario" VARCHAR,
"time_horiz" VARCHAR,
"statistical_operation" VARCHAR,
"anomaly" VARCHAR,
"time_period" BIGINT,
"obs_value" DOUBLE,
"obs_status" VARCHAR,
"unit_mult" BIGINT,
"decimals" BIGINT,
"base_per" VARCHAR,
"robustness" VARCHAR
);Anyone who has the link will be able to view this.