About this Dataset

Freshwater - Abstractions

This dataset shows water abstractions by source (surface and ground water) and by major uses. Water abstractions refer to water taken from ground or surface water sources and conveyed to the place of use. If the water is returned to a surface water source, abstraction of the same water by the downstream user is counted again in compiling total abstractions.

When interpreting those data, it should be borne in mind that the definitions and estimation methods employed by member countries may vary considerably.

Data source(s) : Joint OECD/Eurostat questionnaire on Inland Waters. Data for non-OECD countries is sourced from UNSD (Country Files from the UNSD/UNEP data collection on environment statistics (available at: https://unstats.un.org/unsd/envstats/country_files))

Contact : ENV.Stat@oecd.org

Dataset release date : September 3, 2025

Country metadata - Metadonnees pays

Tables

Observations

@oecd.oecd_env_epi_dsd_water_abstract_df_water_abstract_v1_0.observations

271.62 kB
44,764 rows
14 columns

CREATE TABLE observations (
  "dataflow" VARCHAR,
  "ref_area" VARCHAR,
  "freq" VARCHAR,
  "measure" VARCHAR,
  "unit_measure" VARCHAR,
  "source" VARCHAR,
  "time_period" BIGINT,
  "obs_value" DOUBLE,
  "obs_status" VARCHAR,
  "obs_status_2" VARCHAR,
  "obs_status_3" VARCHAR,
  "obs_status_4" VARCHAR,
  "unit_mult" BIGINT,
  "decimals" BIGINT
);