Country Programmable Aid (CPA)
OECD dataset from agency OECD.DCD.FSD: DSD_DAC2@DF_CPA (2000 - 2022)
@oecd.oecd_dcd_fsd_dsd_dac2_df_cpa_v1_1
OECD dataset from agency OECD.DCD.FSD: DSD_DAC2@DF_CPA (2000 - 2022)
@oecd.oecd_dcd_fsd_dsd_dac2_df_cpa_v1_1
CPA is the proportion of aid that is subjected to multi-year programming at country level, and hence represent a subset of ODA outflows. It takes as a starting point data on gross ODA disbursements by recipient but excludes spending which is: 1. inherently unpredictable (humanitarian aid and debt relief); or 2. entails no flows to the recipient country (administration costs, student costs, development awareness and research and refugee spending in donor countries); or 3. is usually not discussed between the main donor agency and recipient governments (food aid, aid from local governments, core funding to NGOs, aid through secondary agencies, ODA equity investments and aid which is not allocable by country); 4. CPA does not net out loan repayments, as these are not usually factored into aid allocation decisions. CPA is therefore a gross concept.
CREATE TABLE observations (
"dataflow" VARCHAR,
"donor" VARCHAR,
"recipient" VARCHAR,
"measure" BIGINT,
"unit_measure" VARCHAR,
"price_base" VARCHAR,
"time_period" BIGINT,
"obs_value" DOUBLE,
"base_per" DOUBLE,
"unit_mult" BIGINT,
"flow_type" VARCHAR,
"obs_status" VARCHAR
);Anyone who has the link will be able to view this.