Name: MCC Program Data - FY24Q2
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

MCC Program Data - FY24Q2

These .csv files contain results, status and financial data included in MCC's open data .xml files and in the IATI registry.
Organization: Millennium Challenge Corporation
Last updated: 2020-11-12T13:53:37.482720
Tags: foreign-assistance

Tables

MCC Results Data

@usgov.mcc_gov_mcc_program_data_fy20q1.mcc_results_data

159.8 kB
5,398 rows
15 columns

CREATE TABLE mcc_results_data (
  "mcccountrycode" VARCHAR,
  "fundcode" VARCHAR,
  "projectcode" VARCHAR,
  "hierarchy_level" BIGINT,
  "indicator_level" VARCHAR,
  "indicator" VARCHAR,
  "activity_name" VARCHAR,
  "classification" VARCHAR,
  "measure" VARCHAR,
  "baseline" VARCHAR,
  "baseline_year" VARCHAR,
  "actual" VARCHAR,
  "target" VARCHAR,
  "notes" VARCHAR,
  "measure_detail" VARCHAR
);

Program Descriptions

@usgov.mcc_gov_mcc_program_data_fy20q1.program_descriptions

680.62 kB
4,326 rows
10 columns

CREATE TABLE program_descriptions (
  "concatenate" VARCHAR,
  "countrycode" VARCHAR,
  "mcccountrycode" VARCHAR,
  "fundcode" VARCHAR,
  "projectcode" VARCHAR,
  "activitycode" VARCHAR,
  "hierarchy_level" BIGINT,
  "description_1" VARCHAR,
  "activity_scope" BIGINT,
  "descriptions_archived" VARCHAR
);