Precipitation - Regions
OECD dataset from agency OECD.CFE.EDS: DSD_REG_CLIM@DF_PRECIPITATION (1981 - 2024)
@oecd.oecd_cfe_eds_dsd_reg_clim_df_precipitation_v2_4
OECD dataset from agency OECD.CFE.EDS: DSD_REG_CLIM@DF_PRECIPITATION (1981 - 2024)
@oecd.oecd_cfe_eds_dsd_reg_clim_df_precipitation_v2_4
This dataset provides indicators on total precipitation and the number of extreme precipitation days, in large (TL2) and small (TL3) regions.
Data definition and source
Precipitation is the sum of all liquid and frozen water - such as rain and snow - that reaches the Earth's surface each year. It excludes fog, dew and any precipitation that evaporates before reaching the ground. Extreme precipitation days are defined as days with more than 20 mm of total precipitation. Changes in precipitation and extreme precipitation days are referenced to the 1981-2010 baseline average. The estimates rely on the ERA5-Land reanalysis dataset.
Definition of regions
Regions are subnational units below national boundaries. OECD countries have two regional levels: large regions (territorial level 2 or TL2) and small regions (territorial level 3 or TL3). For more information, see the OECD Territorial grid (pdf) and the OECD Territorial Correspondence Table (xlsx).
Cite this dataset
OECD Regions, Cities and Local Areas database http://oe.cd/geostats.
Further information
For questions and/or comments, please email RegionStat@oecd.org.
CREATE TABLE observations (
"dataflow" VARCHAR,
"freq" VARCHAR,
"territorial_level" VARCHAR,
"ref_area" VARCHAR,
"territorial_type" VARCHAR,
"measure" VARCHAR,
"ret_period" VARCHAR,
"heat_stress" VARCHAR,
"proj_scenario" VARCHAR,
"pollutant_concentration" VARCHAR,
"unit_measure" VARCHAR,
"time_period" BIGINT,
"obs_value" DOUBLE,
"country" VARCHAR,
"obs_status" VARCHAR,
"unit_mult" BIGINT,
"decimals" BIGINT
);Anyone who has the link will be able to view this.