Baselight

Water Accounts - Supply And Use

OECD dataset from agency OECD.ENV.EPI: DSD_WATER_PSUT@DF_WATER_PSUT (1980 - 2023)

@oecd.oecd_env_epi_dsd_water_psut_df_water_psut_v1_0

Loading...
Loading...

About this Dataset

Water Accounts - Supply And Use

Water flow accounts describe flows of water, in physical units, encompassing the initial abstraction of water resources from the environment into the economy, to the water flows within the economy in the form of supply and use by industries and households, and finally, flows of water back to the environment.

Physical supply and use tables can be compiled at various levels of detail, depending on the required policy and analytical focus and data availability. A basic PSUT for water contains information on the supply and use of water and provides an overview of water flows. The PSUT is divided into five sections which organize information on (a) abstraction of water from the environment; (b) distribution and use of abstracted water across enterprises and households; (c) flows of wastewater and reused water (between households and enterprises); (d) return flows of water to the environment; and (e) evaporation, transpiration and water incorporated into products.

Data source(s) : Joint OECD/Eurostat questionnaire on Inland Waters. Data for non-OECD countries is sourced from UNSD (https://unstats.un.org/unsd/envstats/country_files)

Contact : ENV.Stat@oecd.org

Dataset release date : September 3, 2025

Database documentation

Tables

Observations

@oecd.oecd_env_epi_dsd_water_psut_df_water_psut_v1_0.observations
  • 209.09 kB
  • 44,166 rows
  • 13 columns
Loading...
CREATE TABLE observations (
  "dataflow" VARCHAR,
  "ref_area" VARCHAR,
  "freq" VARCHAR,
  "measure" VARCHAR,
  "unit_measure" VARCHAR,
  "supply_use" VARCHAR,
  "variable" VARCHAR,
  "activity" VARCHAR,
  "time_period" BIGINT,
  "obs_value" DOUBLE,
  "obs_status" VARCHAR,
  "unit_mult" BIGINT,
  "decimals" BIGINT
);

Share link

Anyone who has the link will be able to view this.