Subnational Government Investment By Functional Classification (COFOG)
OECD dataset from agency OECD.CFE.RDG: DSD_DASHBOARD@COFOG_INV (2022 - 2022)
@oecd.oecd_cfe_rdg_dsd_dashboard_cofog_inv_v1_0
OECD dataset from agency OECD.CFE.RDG: DSD_DASHBOARD@COFOG_INV (2022 - 2022)
@oecd.oecd_cfe_rdg_dsd_dashboard_cofog_inv_v1_0
This dataset includes data on direct investment of subnational governments by functions, based on the Classification of the Functions of Government (COFOG) of the National Accounts. The COFOG includes ten categories: general public services; defence; public order and safety; economic affairs; environmental protection; housing and community amenities; health; recreation, culture and religion; education; and social protection.
This dataset provides data for general public services; economic affairs; environmental protection; housing and community amenities; education; and "other" (which includes: defence; public order and safety; health; recreation, culture and religion; and social protection).
The Subnational Government Structure and Finance Dashboard compiles several datasets with comparable data on institutional organisation and public finance at subnational government level. It provides data for all 38 OECD member countries, and the average for the European Union. It includes data for the subnational government sector (for both state and local government levels).
The data is also available in PDF format and via an Interactive dashboard.
CREATE TABLE observations (
"dataflow" VARCHAR,
"ref_area" VARCHAR,
"measure" VARCHAR,
"cofog" VARCHAR,
"sector" VARCHAR,
"size_class" VARCHAR,
"statistical_operation" VARCHAR,
"unit_measure" VARCHAR,
"time_period" BIGINT,
"obs_value" DOUBLE,
"decimals" BIGINT,
"obs_status" VARCHAR,
"unit_mult" BIGINT,
"conf_status" VARCHAR
);Anyone who has the link will be able to view this.