MCC Monitoring And Evaluation (M&E) Program Data by US Government | Demographics and Population Studies

About this Dataset

MCC Monitoring And Evaluation (M&E) Program Data

M&E program data for a subset of Millennium Challenge Corporation programs, including M&E Plan metadata and quarterly results.
Organization: Millennium Challenge Corporation
Last updated: 2025-05-07T04:46:07.949249
Tags: evaluations, monitoring

Tables

MCC M&E Plan Indicator Definitions

@usgov.mcc_gov_mcc_monitoring_and_evaluation_me_program_data.mcc_m_e_plan_indicator_definitions

364.36 KB
2049 rows
19 columns


CREATE TABLE mcc_m_e_plan_indicator_definitions (
  "indicatorid" BIGINT,
  "regionname" VARCHAR,
  "countryname" VARCHAR,
  "programname" VARCHAR,
  "projectname" VARCHAR,
  "activityname" VARCHAR,
  "subactivityname" VARCHAR,
  "projectlogicresult" VARCHAR,
  "ci_code" VARCHAR,
  "level" VARCHAR,
  "indicatorname" VARCHAR,
  "definition" VARCHAR,
  "unitofmeasure" VARCHAR,
  "disaggregationtype" VARCHAR,
  "datasource" VARCHAR,
  "responsibleparty" VARCHAR,
  "reportfrequency" VARCHAR,
  "indicatortype" VARCHAR,
  "additionalinfo" VARCHAR
);

MCC M&E Plans Baselines And Targets

@usgov.mcc_gov_mcc_monitoring_and_evaluation_me_program_data.mcc_m_e_plans_baselines_and_targets

201.11 KB
4962 rows
25 columns


CREATE TABLE mcc_m_e_plans_baselines_and_targets (
  "indicatorid" BIGINT,
  "regionname" VARCHAR,
  "countryname" VARCHAR,
  "programname" VARCHAR,
  "projectname" VARCHAR,
  "activityname" VARCHAR,
  "subactivityname" VARCHAR,
  "level" VARCHAR,
  "indicatorname" VARCHAR,
  "unitofmeasure" VARCHAR,
  "classification" VARCHAR,
  "baseline" VARCHAR,
  "baselineyear" DOUBLE,
  "targety1" VARCHAR,
  "targety2" VARCHAR,
  "targety3" VARCHAR,
  "targety4" VARCHAR,
  "targety5" VARCHAR,
  "targety6" VARCHAR,
  "targety7" VARCHAR,
  "postprogramtarget" VARCHAR,
  "postprogramtargetyear" VARCHAR,
  "targetlinktocba" VARCHAR,
  "baselinedocumentation" VARCHAR,
  "targetdocumentation" VARCHAR
);

MCC M&E Indicator Categories

@usgov.mcc_gov_mcc_monitoring_and_evaluation_me_program_data.mcc_m_e_indicator_categories

170.15 KB
4962 rows
12 columns


CREATE TABLE mcc_m_e_indicator_categories (
  "indicatorid" BIGINT,
  "regionname" VARCHAR,
  "countryname" VARCHAR,
  "programname" VARCHAR,
  "projectname" VARCHAR,
  "activityname" VARCHAR,
  "subactivityname" VARCHAR,
  "level" VARCHAR,
  "indicatorname" VARCHAR,
  "keyindicatorflag" BOOLEAN,
  "indicatorcategories" VARCHAR,
  "publication" VARCHAR
);

MCC M&E Indicator Tracking Tables

@usgov.mcc_gov_mcc_monitoring_and_evaluation_me_program_data.mcc_m_e_indicator_tracking_tables

519.37 KB
4737 rows
55 columns


CREATE TABLE mcc_m_e_indicator_tracking_tables (
  "indicatorid" BIGINT,
  "regionname" VARCHAR,
  "countryname" VARCHAR,
  "programname" VARCHAR,
  "projectname" VARCHAR,
  "activityname" VARCHAR,
  "subactivityname" VARCHAR,
  "ci_code" VARCHAR,
  "level" VARCHAR,
  "indicatorname" VARCHAR,
  "classification" VARCHAR,
  "unitofmeasure" VARCHAR,
  "baseline" VARCHAR,
  "baselineyear" DOUBLE,
  "actualq01" VARCHAR,
  "actualq02" VARCHAR,
  "actualq03" VARCHAR,
  "actualq04" VARCHAR,
  "targety1" VARCHAR,
  "percentcompletey1" VARCHAR,
  "actualq05" VARCHAR,
  "actualq06" VARCHAR,
  "actualq07" VARCHAR,
  "actualq08" VARCHAR,
  "targety2" VARCHAR,
  "percentcompletey2" VARCHAR,
  "actualq09" VARCHAR,
  "actualq10" VARCHAR,
  "actualq11" VARCHAR,
  "actualq12" VARCHAR,
  "targety3" VARCHAR,
  "percentcompletey3" VARCHAR,
  "actualq13" VARCHAR,
  "actualq14" VARCHAR,
  "actualq15" VARCHAR,
  "actualq16" VARCHAR,
  "targety4" VARCHAR,
  "percentcompletey4" VARCHAR,
  "actualq17" VARCHAR,
  "actualq18" VARCHAR,
  "actualq19" VARCHAR,
  "actualq20" VARCHAR,
  "targety5" VARCHAR,
  "percentcompletey5" VARCHAR,
  "actualq21" VARCHAR,
  "actualq22" VARCHAR,
  "actualq23" VARCHAR,
  "actualq24" VARCHAR,
  "targety6" VARCHAR,
  "percentcompletey6" VARCHAR,
  "actualtodate" VARCHAR,
  "endofprogramtarget" VARCHAR,
  "progresstodate" VARCHAR,
  "publication" VARCHAR,
  "internal_detaileddatasource" VARCHAR
);

MCC M&E Key Performance Indicators

@usgov.mcc_gov_mcc_monitoring_and_evaluation_me_program_data.mcc_m_e_key_performance_indicators

36.89 KB
569 rows
11 columns


CREATE TABLE mcc_m_e_key_performance_indicators (
  "indicatorid" BIGINT,
  "regionname" VARCHAR,
  "countryname" VARCHAR,
  "programname" VARCHAR,
  "projectname" VARCHAR,
  "activityname" VARCHAR,
  "indicatorname" VARCHAR,
  "baseline" VARCHAR,
  "endofprogramtarget" VARCHAR,
  "actualtodate" VARCHAR,
  "progresstodate" VARCHAR
);

MCC Program Timelines

@usgov.mcc_gov_mcc_monitoring_and_evaluation_me_program_data.mcc_program_timelines

7.97 KB
362 rows
8 columns


CREATE TABLE mcc_program_timelines (
  "regionname" VARCHAR,
  "countryname" VARCHAR,
  "programname" VARCHAR,
  "eifdateactual" VARCHAR,
  "closedateactual" VARCHAR,
  "closedateexpected" VARCHAR,
  "programquarter" VARCHAR,
  "programenddate" VARCHAR
);