Aggregated And Disaggregated Subnational Public Employment
OECD dataset from agency OECD.CFE.RDG: DSD_SUBEMP@DF_SUBEMP (2019 - 2023)
@oecd.oecd_cfe_rdg_dsd_subemp_df_subemp_v1_0
OECD dataset from agency OECD.CFE.RDG: DSD_SUBEMP@DF_SUBEMP (2019 - 2023)
@oecd.oecd_cfe_rdg_dsd_subemp_df_subemp_v1_0
The pilot database on aggregated subnational public employment (Aggregated SUBEMP) provides a selection of indicators on public employment with a gender perspective for subnational administrations in OECD and EU countries. It is complemented by disaggregated data, that is data for individual subnational governments in a given country, which can be downloaded directly from the links below.
Data was collected for the latest year available with the time coverage ranging from 2019 to 2023 (based on data availability). This database has been produced in the context of the OECD/EU joint project Strengthening analytical frameworks and data on subnational government finance and public employment, with the goal of collecting, standardising, and disseminating high-quality comparable data for local government finance and employment.
This data provides information to assess the capacities and decision-making power of municipalities and regions, whose role is essential in developing place-based policy. It also allows for within and cross-country comparisons, which sheds light on the disparities between subnational governments in terms of fulfilling their mandates and their ability to raise own-source revenue. You will find more information on subnational government responsibilities in the World Observatory on Subnational Government Finance and Investment.
CREATE TABLE observations (
"dataflow" VARCHAR,
"ref_area" VARCHAR,
"measure" VARCHAR,
"sex" VARCHAR,
"cofog" VARCHAR,
"sector" VARCHAR,
"age" VARCHAR,
"occupation" VARCHAR,
"attainment_lev" VARCHAR,
"contract" VARCHAR,
"work_time_arngmnt" 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.