MCC Country Selection Indicators For FY23

CREATE TABLE child_health_fy23 (
  "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_fy23 (
  "civlibcountry" VARCHAR,
  "civlibyear" BIGINT,
  "civlibthreshold" VARCHAR,
  "civliboriginal_data" DOUBLE,
  "civlibround_score" DOUBLE,
  "civlibminimum" DOUBLE,
  "civlibpercentrank" DOUBLE,
  "civlibcountrycode" VARCHAR
);

CREATE TABLE control_of_corruption_fy23 (
  "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_fy23 (
  "educexpcountry" VARCHAR,
  "educexpyear" BIGINT,
  "educexpthreshold" VARCHAR,
  "educexporiginal_data" DOUBLE,
  "educexplast_known_data" DOUBLE,
  "educexpround_score" DOUBLE,
  "educexpmedian" DOUBLE,
  "educexpround_median" DOUBLE,
  "educexppercentrank" DOUBLE,
  "educexpcountrycode" VARCHAR
);

CREATE TABLE employment_opportunity_fy23 (
  "empoppcountry" VARCHAR,
  "empoppyear" BIGINT,
  "empoppthreshold" VARCHAR,
  "empoppscore" DOUBLE,
  "empoppround_score" DOUBLE,
  "empoppmedian" DOUBLE,
  "empoppround_median" DOUBLE,
  "empopppercentrank" DOUBLE,
  "empoppcountrycode" VARCHAR
);

CREATE TABLE fiscal_policy_fy23 (
  "fispolcountry" VARCHAR,
  "fispolyear" BIGINT,
  "fispolthreshold" VARCHAR,
  "fispolfiscal_data_2019" DOUBLE,
  "fispolfiscal_data_2020" DOUBLE,
  "fispoloriginal_data" DOUBLE,
  "fispolscore" DOUBLE,
  "fispolround_score" DOUBLE,
  "fispolmedian" DOUBLE,
  "fispolround_median" DOUBLE,
  "fispolpercentrank" DOUBLE,
  "fispolcountrycode" VARCHAR
);

CREATE TABLE freedom_of_information_fy23 (
  "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 gender_in_the_economy_fy23 (
  "gendereconcountry" VARCHAR,
  "gendereconyear" BIGINT,
  "gendereconthreshold" VARCHAR,
  "genderecongender_wbl_original_data" DOUBLE,
  "genderecongender_world_original_data" BIGINT,
  "gendereconscore" DOUBLE,
  "gendereconround_score" DOUBLE,
  "gendereconmedian" DOUBLE,
  "gendereconmedian_calculation" DOUBLE,
  "gendereconpercentrank" DOUBLE,
  "gendereconcountrycode" VARCHAR
);

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

CREATE TABLE girls_secondary_education_enrollment_rates_fy23 (
  "girlsseccountry" VARCHAR,
  "girlssecyear" BIGINT,
  "girlssecthreshold" VARCHAR,
  "girlssecoriginal_data" DOUBLE,
  "girlsseclast_known_data" DOUBLE,
  "girlssecround_score" DOUBLE,
  "girlssecmedian" DOUBLE,
  "girlssecround_median" DOUBLE,
  "girlssecpercentrank" DOUBLE,
  "girlsseccountrycode" VARCHAR
);

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

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

CREATE TABLE government_effectiveness_fy23 (
  "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_fy23 (
  "healthcountry" VARCHAR,
  "healthyear" BIGINT,
  "healththreshold" VARCHAR,
  "healthoriginal_data" DOUBLE,
  "healthround_score" DOUBLE,
  "healthmedian" DOUBLE,
  "healthround_median" DOUBLE,
  "healthpercentrank" DOUBLE,
  "healthcountrycode" VARCHAR
);

CREATE TABLE hisp_indicator_fy23 (
  "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,
  "gendereconscore" DOUBLE,
  "girlssecscore" DOUBLE
);

CREATE TABLE immunization_rates_fy23 (
  "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_fy23 (
  "incomecategory" VARCHAR,
  "incomecategorydesc" VARCHAR
);

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

CREATE TABLE inflation_fy23 (
  "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_fy23 (
  "lracountry" VARCHAR,
  "lrayear" BIGINT,
  "lrathreshold" VARCHAR,
  "lraland_data" DOUBLE,
  "lraifad_data" DOUBLE,
  "lraifad_maximum" DOUBLE,
  "lraifad_sub_score" DOUBLE,
  "lraifad_minimum" DOUBLE,
  "lraifad_normalized" DOUBLE,
  "lraifad_normalized_1" DOUBLE,
  "lraland_weight" DOUBLE,
  "lrav_dem_data" DOUBLE,
  "lrav_dem_maximum" DOUBLE,
  "lrav_dem_minimum" DOUBLE,
  "lrav_dem_normalized" DOUBLE,
  "lrav_dem_normalized_1" DOUBLE,
  "lrascore" DOUBLE,
  "lraround_score" DOUBLE,
  "lramedian" DOUBLE,
  "lraround_median" DOUBLE,
  "lrapercentrank" DOUBLE,
  "lracountrycode" VARCHAR
);

CREATE TABLE lisp_indicator_fy23 (
  "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,
  "gendereconscore" DOUBLE,
  "girlspriscore" DOUBLE
);

CREATE TABLE natural_resource_protection_fy23 (
  "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_fy23 (
  "polrigcountry" VARCHAR,
  "polrigyear" BIGINT,
  "polrigthreshold" VARCHAR,
  "polrigoriginal_data" DOUBLE,
  "polriground_score" DOUBLE,
  "polrigminimum" DOUBLE,
  "polrigpercentrank" DOUBLE,
  "polrigcountrycode" VARCHAR
);

CREATE TABLE regulatory_quality_fy23 (
  "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
);

CREATE TABLE rule_of_law_fy23 (
  "rulelawcountry" VARCHAR,
  "rulelawyear" BIGINT,
  "rulelawthreshold" VARCHAR,
  "rulelaworiginal_data" DOUBLE,
  "rulelawstderr" DOUBLE,
  "rulelawmedian_calculation" DOUBLE,
  "rulelawscore" DOUBLE,
  "rulelawround_score" DOUBLE,
  "rulelawmedian" DOUBLE,
  "rulelawpercentrank" DOUBLE,
  "rulelawcountrycode" VARCHAR
);