About this Dataset

Subnational Government Climate Finance

The Subnational Government Climate Finance database provides comparable data on subnational public climate-significant expenditure and investment, covering the years from 2001 to 2019, for 33 OECD and EU countries.

This database was built using a pioneer methodology that relies on a more refined approach to the COFOG classification. Using the EU taxonomy for sustainability activities, three first-level COFOG functions (economic affairs, environmental protection, and housing and community amenities) and 13 second-level COFOG functions (e.g. transport and energy, environmental protection, waste, water management, housing development) were identified as being “climate-significant”, meaning that expenditure and investment in these areas contributes, to some extent, to climate adaptation or mitigation objectives.

For more information on the methodology used and related work on climate finance tracking, please visit: Tracking subnational government climate expenditure

This database was developed in the framework of the project “Financing Climate Action in Regions and Cities”, a joint project between the OECD and the European Commission Directorate-General for Regional and Urban Policy (DG REGIO), launched in 2022.

Tables

Observations

@oecd.oecd_cfe_rdg_dsd_sngf_csf_df_sgcf_v1_0.observations

127.96 kB
22,037 rows
13 columns

CREATE TABLE observations (
  "dataflow" VARCHAR,
  "ref_area" VARCHAR,
  "measure" VARCHAR,
  "sector" VARCHAR,
  "price_base" VARCHAR,
  "unit_measure" VARCHAR,
  "time_period" BIGINT,
  "obs_value" DOUBLE,
  "base_per" DOUBLE,
  "obs_status" VARCHAR,
  "unit_mult" BIGINT,
  "conf_status" VARCHAR,
  "decimals" BIGINT
);