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
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
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
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
);Anyone who has the link will be able to view this.