MCC Country Selection Indicators For FY25

CREATE TABLE child_health_fy25 (
  "chcountry" VARCHAR,
  "chyear" BIGINT,
  "chthreshold" VARCHAR,
  "choriginal_data" DOUBLE,
  "chscore" DOUBLE,
  "chround_score" DOUBLE,
  "chmedian" DOUBLE,
  "chround_median" DOUBLE,
  "chpercentrank" DOUBLE,
  "chcountrycode" VARCHAR
);

CREATE TABLE civil_liberties_fy25 (
  "civlibcountry" VARCHAR,
  "civlibyear" BIGINT,
  "civlibthreshold" VARCHAR,
  "civliboriginal_data" DOUBLE,
  "civlibround_score" DOUBLE,
  "civlibminimum" DOUBLE,
  "civlibpercentrank" DOUBLE,
  "civlibcountrycode" VARCHAR
);

CREATE TABLE control_of_corruption_fy25 (
  "concorcountry" VARCHAR,
  "concoryear" BIGINT,
  "concorthreshold" VARCHAR,
  "concororiginal_data" DOUBLE,
  "concorstderr" DOUBLE,
  "concormedian_calculation" DOUBLE,
  "concorscore" DOUBLE,
  "concorround_score" DOUBLE,
  "concormedian" DOUBLE,
  "concorpercentrank" DOUBLE,
  "concorcountrycode" VARCHAR
);

CREATE TABLE education_expenditures_fy25 (
  "educexpcountry" VARCHAR,
  "educexpyear" BIGINT,
  "educexpthreshold" VARCHAR,
  "educexporiginal_data" DOUBLE,
  "educexplast_known_data" DOUBLE,
  "educexpscore" DOUBLE,
  "educexpround_score" DOUBLE,
  "educexpmedian" DOUBLE,
  "educexpround_median" DOUBLE,
  "educexppercentrank" DOUBLE,
  "educexpcountrycode" VARCHAR
);

CREATE TABLE employment_opportunity_fy25 (
  "empoppcountry" VARCHAR,
  "empoppyear" BIGINT,
  "empoppthreshold" VARCHAR,
  "empoppdisability_data" DOUBLE,
  "empoppdiscrimination_data" DOUBLE,
  "empoppslavery_data" DOUBLE,
  "empoppcso_data" DOUBLE,
  "empoppdisability_percentrank" DOUBLE,
  "empoppdiscrimination_percentrank" DOUBLE,
  "empoppslavery_percentrank" DOUBLE,
  "empoppcso_percentrank" DOUBLE,
  "empoppscore" DOUBLE,
  "empoppround_score" DOUBLE,
  "empoppmedian" DOUBLE,
  "empoppround_median" DOUBLE,
  "empopppercentrank" DOUBLE,
  "empoppcountrycode" VARCHAR
);

CREATE TABLE fiscal_policy_fy25 (
  "fispolcountry" VARCHAR,
  "fispolyear" BIGINT,
  "fispolthreshold" VARCHAR,
  "fispolfiscal_data_2021" DOUBLE,
  "fispolfiscal_data_2022" DOUBLE,
  "fispoloriginal_data" DOUBLE,
  "fispolscore" DOUBLE,
  "fispolround_score" DOUBLE,
  "fispolmedian" DOUBLE,
  "fispolround_median" DOUBLE,
  "fispolpercentrank" DOUBLE,
  "fispolcountrycode" VARCHAR
);

CREATE TABLE freedom_of_information_fy25 (
  "freedominfocountry" VARCHAR,
  "freedominfoyear" BIGINT,
  "freedominfothreshold" VARCHAR,
  "freedominfofreedom_of_press_original_data" DOUBLE,
  "freedominforight_to_information_original_data" DOUBLE,
  "freedominforight_to_information_calculation" DOUBLE,
  "freedominfofreedom_of_internet_original_data" DOUBLE,
  "freedominfofreedom_of_internet_calculation" DOUBLE,
  "freedominfoscore" DOUBLE,
  "freedominforound_score" DOUBLE,
  "freedominfomedian" DOUBLE,
  "freedominfopercentrank" DOUBLE,
  "freedominfocountrycode" VARCHAR
);

CREATE TABLE girls_lower_secondary_education_completion_rates_fy25 (
  "girlslowerseccountry" VARCHAR,
  "girlslowersecyear" BIGINT,
  "girlslowersecthreshold" VARCHAR,
  "girlslowersecoriginal_data" DOUBLE,
  "girlslowerseclast_known_data" DOUBLE,
  "girlslowersecscore" DOUBLE,
  "girlslowersecround_score" DOUBLE,
  "girlslowersecmedian" DOUBLE,
  "girlslowersecround_median" DOUBLE,
  "girlslowersecpercentrank" DOUBLE,
  "girlslowerseccountrycode" VARCHAR
);

CREATE TABLE girls_primary_education_fy25 (
  "girlsprimcountry" VARCHAR,
  "girlsprimyear" BIGINT,
  "girlsprimthreshold" VARCHAR,
  "girlsprimoriginal_data" DOUBLE,
  "girlsprimlast_known_data" DOUBLE,
  "girlsprimscore" DOUBLE,
  "girlsprimround_score" DOUBLE,
  "girlsprimmedian" DOUBLE,
  "girlsprimround_median" DOUBLE,
  "girlsprimpercentrank" DOUBLE,
  "girlsprimcountrycode" VARCHAR
);

CREATE TABLE girls_upper_secondary_education_completion_rates_fy25 (
  "girlsupperseccountry" VARCHAR,
  "girlsuppersecyear" BIGINT,
  "girlsuppersecthreshold" VARCHAR,
  "girlsuppersecoriginal_data" DOUBLE,
  "girlsupperseclast_known_data" DOUBLE,
  "girlsuppersecscore" DOUBLE,
  "girlsuppersecround_score" DOUBLE,
  "girlsuppersecmedian" DOUBLE,
  "girlsuppersecround_median" DOUBLE,
  "girlsuppersecpercentrank" DOUBLE,
  "girlsupperseccountrycode" VARCHAR
);

CREATE TABLE gni_fy25 (
  "country" VARCHAR,
  "us_dollars" DOUBLE,
  "threshold" VARCHAR
);

CREATE TABLE gni_limits_fy25 (
  "gnilimitinccat" VARCHAR,
  "gnilimitlow" BIGINT,
  "gnilimithigh" BIGINT
);

CREATE TABLE government_effectiveness_fy25 (
  "govteffcountry" VARCHAR,
  "govteffyear" BIGINT,
  "govteffthreshold" VARCHAR,
  "govtefforiginal_data" DOUBLE,
  "govteffstderr" DOUBLE,
  "govteffmedian_calculation" DOUBLE,
  "govteffscore" DOUBLE,
  "govteffround_score" DOUBLE,
  "govteffmedian" DOUBLE,
  "govteffpercentrank" DOUBLE,
  "govteffcountrycode" VARCHAR
);

CREATE TABLE health_expenditures_fy25 (
  "healthcountry" VARCHAR,
  "healthyear" BIGINT,
  "healththreshold" VARCHAR,
  "healthoriginal_data" DOUBLE,
  "healthround_score" DOUBLE,
  "healthmedian" DOUBLE,
  "healthround_median" DOUBLE,
  "healthpercentrank" DOUBLE,
  "healthcountrycode" VARCHAR
);

CREATE TABLE hisc_indicators_fy25 (
  "countryname" VARCHAR,
  "healthscore" DOUBLE,
  "polrigscore" BIGINT,
  "civlibscore" BIGINT,
  "concorscore" DOUBLE,
  "govteffscore" DOUBLE,
  "rulelawscore" DOUBLE,
  "freedominfoscore" DOUBLE,
  "immunscore" DOUBLE,
  "educexpscore" DOUBLE,
  "chscore" DOUBLE,
  "nrmscore" DOUBLE,
  "regqualityscore" DOUBLE,
  "lrascore" DOUBLE,
  "empopportunityscore" DOUBLE,
  "tradescore" DOUBLE,
  "inflscore" DOUBLE,
  "fispolscore" DOUBLE,
  "accesscreditscore" DOUBLE,
  "womeneconscore" DOUBLE,
  "girlsuppersecscore" DOUBLE
);

CREATE TABLE immunization_rates_fy25 (
  "immuncountry" VARCHAR,
  "immunyear" BIGINT,
  "immunthreshold" VARCHAR,
  "immundtp3_original_data" DOUBLE,
  "immundtp3_weight" DOUBLE,
  "immunmcv1_original_data" DOUBLE,
  "immunmcv1_weight" DOUBLE,
  "immunscore" DOUBLE,
  "immunround_score" DOUBLE,
  "immunmedian" DOUBLE,
  "immunminimum" DOUBLE,
  "immunpercentrank" DOUBLE,
  "immuncountrycode" VARCHAR
);

CREATE TABLE income_categories_fy25 (
  "incomecategory" VARCHAR,
  "incomecategorydesc" VARCHAR
);

CREATE TABLE indicators_threshold_fy25 (
  "indicatorname" VARCHAR,
  "incomecategory" VARCHAR,
  "reportyear" BIGINT,
  "medianvalue" DOUBLE,
  "thresholdcode" VARCHAR
);

CREATE TABLE inflation_fy25 (
  "inflcountry" VARCHAR,
  "inflyear" BIGINT,
  "inflthreshold" VARCHAR,
  "infloriginal_data" DOUBLE,
  "inflscore" DOUBLE,
  "inflround_score" DOUBLE,
  "inflmaximum" DOUBLE,
  "inflpercentrank" DOUBLE,
  "inflcountrycode" VARCHAR
);

CREATE TABLE land_rights_and_access_fy25 (
  "lracountry" VARCHAR,
  "lrayear" BIGINT,
  "lrathreshold" VARCHAR,
  "lraifad_data" DOUBLE,
  "lraifad_percentrank" DOUBLE,
  "lrav_dem_data" DOUBLE,
  "lrav_dem_percentrank" DOUBLE,
  "lrascore" DOUBLE,
  "lraround_score" DOUBLE,
  "lramedian" DOUBLE,
  "lraround_median" DOUBLE,
  "lrapercentrank" DOUBLE,
  "lracountrycode" VARCHAR
);

CREATE TABLE lisc_indicators_fy25 (
  "countryname" VARCHAR,
  "healthscore" DOUBLE,
  "polrigscore" BIGINT,
  "civlibscore" BIGINT,
  "concorscore" DOUBLE,
  "govteffscore" DOUBLE,
  "rulelawscore" DOUBLE,
  "freedominfoscore" DOUBLE,
  "immunscore" DOUBLE,
  "educexpscore" DOUBLE,
  "chscore" DOUBLE,
  "nrmscore" DOUBLE,
  "regqualityscore" DOUBLE,
  "lrascore" DOUBLE,
  "empopportunityscore" DOUBLE,
  "tradescore" DOUBLE,
  "inflscore" DOUBLE,
  "fispolscore" DOUBLE,
  "accesscreditscore" DOUBLE,
  "womeneconscore" DOUBLE,
  "girlspriscore" DOUBLE
);

CREATE TABLE misc_indicators_fy25 (
  "countryname" VARCHAR,
  "healthscore" DOUBLE,
  "polrigscore" BIGINT,
  "civlibscore" BIGINT,
  "concorscore" DOUBLE,
  "govteffscore" DOUBLE,
  "rulelawscore" DOUBLE,
  "freedominfoscore" DOUBLE,
  "immunscore" DOUBLE,
  "educexpscore" DOUBLE,
  "chscore" DOUBLE,
  "nrmscore" DOUBLE,
  "regqualityscore" DOUBLE,
  "lrascore" DOUBLE,
  "empopportunityscore" DOUBLE,
  "tradescore" DOUBLE,
  "inflscore" DOUBLE,
  "fispolscore" DOUBLE,
  "accesscreditscore" DOUBLE,
  "womeneconscore" DOUBLE,
  "girlslowersecscore" DOUBLE
);

CREATE TABLE natural_resource_protection_fy25 (
  "nrmcountry" VARCHAR,
  "nrmyear" BIGINT,
  "nrmthreshold" VARCHAR,
  "nrmoriginal_data" DOUBLE,
  "nrmscore" DOUBLE,
  "nrmround_score" DOUBLE,
  "nrmmedian" DOUBLE,
  "nrmround_median" DOUBLE,
  "nrmpercentrank" DOUBLE,
  "nrmcountrycode" VARCHAR
);

CREATE TABLE political_rights_fy25 (
  "polrigcountry" VARCHAR,
  "polrigyear" BIGINT,
  "polrigthreshold" VARCHAR,
  "polrigoriginal_data" DOUBLE,
  "polriground_score" DOUBLE,
  "polrigminimum" DOUBLE,
  "polrigpercentrank" DOUBLE,
  "polrigcountrycode" VARCHAR
);

CREATE TABLE regulatory_quality_fy25 (
  "regqualitycountry" VARCHAR,
  "regqualityyear" BIGINT,
  "regqualitythreshold" VARCHAR,
  "regqualityoriginal_data" DOUBLE,
  "regqualitystderr" DOUBLE,
  "regqualitymedian_calculation" DOUBLE,
  "regqualityscore" DOUBLE,
  "regqualityround_score" DOUBLE,
  "regqualitymedian" DOUBLE,
  "regqualitypercentrank" DOUBLE,
  "regqualitycountrycode" VARCHAR
);