MCC Country Selection Indicators For FY20

CREATE TABLE access_to_credit_fy20 (
  "accesscreditcountry" VARCHAR,
  "accesscredityear" BIGINT,
  "accesscreditthreshold" VARCHAR,
  "accesscreditdepth_of_credit_data" DOUBLE,
  "accesscreditdepth_of_credit_weight" BIGINT,
  "accesscreditlegal_rights_data" DOUBLE,
  "accesscreditlegal_rights_weight" BIGINT,
  "accesscreditscore" DOUBLE,
  "accesscreditround_score" DOUBLE,
  "accesscreditmedian" BIGINT,
  "accesscreditpercentrank" DOUBLE,
  "accesscreditcountrycode" VARCHAR
);

CREATE TABLE business_start_up_fy20 (
  "busstartupcountry" VARCHAR,
  "busstartupyear" BIGINT,
  "busstartupthreshold" VARCHAR,
  "busstartuptime_original_data" DOUBLE,
  "busstartupmodified_dataset_time" DOUBLE,
  "busstartuptime_maximum" BIGINT,
  "busstartuptime_sub_score" DOUBLE,
  "busstartuptime_minimum" DOUBLE,
  "busstartuptime_normalized" DOUBLE,
  "busstartuptime_weight" DOUBLE,
  "busstartupcost_original_data" DOUBLE,
  "busstartupmodified_dataset_cost" DOUBLE,
  "busstartupcost_maximum" DOUBLE,
  "busstartupcost_sub_score" DOUBLE,
  "busstartupcost_minimum" BIGINT,
  "busstartupcost_normalized" DOUBLE,
  "busstartupcost_weight" DOUBLE,
  "busstartupscore" DOUBLE,
  "busstartupround_score" DOUBLE,
  "busstartupmedian" DOUBLE,
  "busstartupround_median" DOUBLE,
  "busstartuppercentrank" DOUBLE,
  "busstartupcountrycode" VARCHAR
);

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

CREATE TABLE control_of_corruption_fy20 (
  "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_fy20 (
  "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 fiscal_policy_fy20 (
  "fispolcountry" VARCHAR,
  "fispolyear" BIGINT,
  "fispolthreshold" VARCHAR,
  "fispolfiscal_data_2016" DOUBLE,
  "fispolfiscal_data_2017" DOUBLE,
  "fispoloriginal_data" DOUBLE,
  "fispolscore" DOUBLE,
  "fispolround_score" DOUBLE,
  "fispolmedian" DOUBLE,
  "fispolround_median" DOUBLE,
  "fispolpercentrank" DOUBLE,
  "fispolcountrycode" VARCHAR
);

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

CREATE TABLE gender_in_the_economy_fy20 (
  "gendereconcountry" VARCHAR,
  "gendereconyear" BIGINT,
  "gendereconthreshold" VARCHAR,
  "gendereconscore" DOUBLE,
  "gendereconround_score" DOUBLE,
  "gendereconmedian" DOUBLE,
  "gendereconpercentrank" DOUBLE,
  "gendereconcountrycode" VARCHAR
);

CREATE TABLE girls_primary_education_fy20 (
  "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_fy20 (
  "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_fy20 (
  "country" VARCHAR,
  "us_dollars" DOUBLE,
  "threshold" VARCHAR
);

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

CREATE TABLE government_effectiveness_fy20 (
  "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_fy20 (
  "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_fy20 (
  "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,
  "busstartupscore" DOUBLE,
  "tradescore" DOUBLE,
  "inflscore" DOUBLE,
  "fispolscore" DOUBLE,
  "accesscreditscore" BIGINT,
  "gendereconscore" DOUBLE,
  "girlssecscore" DOUBLE
);

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

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

CREATE TABLE inflation_fy20 (
  "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_fy20 (
  "lracountry" VARCHAR,
  "lrayear" BIGINT,
  "lrathreshold" VARCHAR,
  "lraland_data" DOUBLE,
  "lralast_known_ifad_data" DOUBLE,
  "lraifad_maximum" DOUBLE,
  "lraifad_sub_score" DOUBLE,
  "lraifad_minimum" DOUBLE,
  "lraifad_normalized" DOUBLE,
  "lraifad_normalized_1" DOUBLE,
  "lraland_weight" DOUBLE,
  "lratime_days" DOUBLE,
  "lramodified_dataset_time" DOUBLE,
  "lraifc_time_maximum" BIGINT,
  "lraifc_time_sub_score" DOUBLE,
  "lraifc_time_minimum" BIGINT,
  "lraifc_time_normalized_score" DOUBLE,
  "lratime_weight" DOUBLE,
  "lracost" DOUBLE,
  "lramodified_dataset_cost" DOUBLE,
  "lraifc_cost_maximum" DOUBLE,
  "lraifc_cost_sub_score" DOUBLE,
  "lraifc_cost_minimum" BIGINT,
  "lraifc_cost_normalized_score" DOUBLE,
  "lracost_weight" DOUBLE,
  "lrascore" DOUBLE,
  "lraround_score" DOUBLE,
  "lramedian" DOUBLE,
  "lraround_median" DOUBLE,
  "lrapercentrank" DOUBLE,
  "lracountrycode" VARCHAR
);

CREATE TABLE lisp_indicator_fy20 (
  "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,
  "busstartupscore" DOUBLE,
  "tradescore" DOUBLE,
  "inflscore" DOUBLE,
  "fispolscore" DOUBLE,
  "accesscreditscore" DOUBLE,
  "gendereconscore" DOUBLE,
  "girlspriscore" DOUBLE
);

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

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

CREATE TABLE selection_indicators_fy20 (
  "countryname" VARCHAR,
  "indicatorname" VARCHAR,
  "datayear" BIGINT,
  "datavalue" DOUBLE,
  "displayvalue" DOUBLE,
  "datapr" DOUBLE,
  "datase" DOUBLE
);

CREATE TABLE time_series_fy20 (
  "country_name" VARCHAR,
  "year" BIGINT,
  "trade_policy" DOUBLE,
  "depth_of_credit_information" DOUBLE,
  "strength_of_legal_rights" DOUBLE,
  "access_to_credit" DOUBLE,
  "days_to_start_a_business" DOUBLE,
  "cost_to_start_a_business" DOUBLE,
  "business_start_up" DOUBLE,
  "child_health" DOUBLE,
  "civil_liberties" DOUBLE,
  "control_of_corruption" DOUBLE,
  "education_expenditure_unesco" DOUBLE,
  "fiscal_policy_actual_year" DOUBLE,
  "fiscal_policy_three_year_average" DOUBLE,
  "freedom_of_press_rsf" DOUBLE,
  "freedom_of_internet" DOUBLE,
  "right_to_information" DOUBLE,
  "freedom_of_information" DOUBLE,
  "gender_in_the_economy" DOUBLE,
  "girls_primary_education_completion_rates" DOUBLE,
  "girls_secondary_enrollment_rates" DOUBLE,
  "government_effectiveness" DOUBLE,
  "health_expenditures" DOUBLE,
  "dpt3_immunization_rates" DOUBLE,
  "mcv_immunization_rates" DOUBLE,
  "immunization_rates" DOUBLE,
  "inflation" DOUBLE,
  "ifad_rural_land_assessment" DOUBLE,
  "days_to_register_a_property" DOUBLE,
  "cost_to_register_a_property" DOUBLE,
  "land_rights_and_access" DOUBLE,
  "natural_resource_protection" DOUBLE,
  "political_rights" DOUBLE,
  "regulatory_quality" DOUBLE,
  "rule_of_law" DOUBLE
);

CREATE TABLE trade_policy_fy20 (
  "tradecountry" VARCHAR,
  "tradeyear" BIGINT,
  "tradethreshold" VARCHAR,
  "tradetariff_rate" DOUBLE,
  "tradetrade_freedom" DOUBLE,
  "traderound_score" DOUBLE,
  "trademedian" DOUBLE,
  "tradepercentrank" DOUBLE,
  "tradecountrycode" VARCHAR
);