Public Integrity Indicators
OECD dataset from agency OECD.GOV.PSI: DSD_PII@DF_PUBLIC_INTEGRITY (2020 - 2024)
@oecd.oecd_gov_psi_dsd_pii_df_public_integrity_v1_4
OECD dataset from agency OECD.GOV.PSI: DSD_PII@DF_PUBLIC_INTEGRITY (2020 - 2024)
@oecd.oecd_gov_psi_dsd_pii_df_public_integrity_v1_4
Following the adoption of the OECD Council Recommendation on Public Integrity in 2017, the Public Governance Committee (PGC), via its Working Party of Senior Public Integrity Officials (SPIO) subsidiary body, developed the OECD Public Integrity Indicators (PII) to measure the implementation of the OECD Council Recommendation on Public Integrity. The PII are complementary to the OECD Public Integrity Handbook and the OECD Public Integrity Maturity Models.
The OECD Public Integrity Indicators (PII) measure the quality and effectiveness of public integrity systems across six areas:
The OECD Public Integrity Indicators provide cross-country comparative data to help policy makers and practitioners strengthen the resilience of public integrity systems towards corruption risks and prevent the mismanagement and waste of public funds. The PIIs measure the strength of standard regulatory safeguards (de jure) and implementation of these safeguards in practice (de facto). The OECD Secretariat collaborates closely with national administrations to obtain primary data collected directly from a wide range of actors across the executive, legislative and judiciary branches.
Data is collected for all 38 OECD member states (Australia, Austria, Belgium, Canada, Chile, Colombia, Costa Rica, the Czech Republic, Denmark, Estonia, Finland, France, Germany, Greece, Hungary, Iceland, Ireland, Israel, Italy, Japan, Korea (Republic of), Latvia, Lithuania, Luxembourg, Mexico, the Netherlands, New Zealand, Norway, Poland, Portugal, the Slovak Republic, Slovenia, Spain, Sweden, Switzerland, Turkiye, the United Kingdom, and the United States), two adherents to the OECD Recommendation on Public Integrity (Argentina and Peru), and one OECD key partner (Brazil).
Data is presented for each area as a set of indicators (listed under "Measure"), which can be further broken down into criteria. Indicator values are calculated by counting the number of criteria fulfilled (based on OECD and other international standards) and expressing as a percentage of the total. Criteria values are binary, with a status of fulfilled represented as a 1 and a status of not fulfilled represented as a 0. Some outcome-level indicators consist of numerical rates calculated based on primary data values, either from administrative data sources (public registries) or surveys.
"Data not available" indicates that no data exists. "Data not provided" represents data that was not provided during the data collection process and "Data pending" represents data that is still being collected and/or assessed. "Not tracking" is used to indicate when administrations do not collate existing data into a central statistical measure.
CREATE TABLE observations (
"dataflow" VARCHAR,
"ref_area" VARCHAR,
"freq" VARCHAR,
"measure" VARCHAR,
"unit_measure" VARCHAR,
"dd_dim" VARCHAR,
"dd_id" VARCHAR,
"time_period" BIGINT,
"obs_value" VARCHAR,
"obs_status" VARCHAR,
"unit_mult" BIGINT,
"criteria" VARCHAR,
"decimals" BIGINT,
"conf_status" VARCHAR
);Anyone who has the link will be able to view this.