MCC Country Selection Indicators For FY17

CREATE TABLE business_start_up (
  "busstartupcountry" VARCHAR,
  "busstartupyear" BIGINT,
  "busstartupthreshold" VARCHAR,
  "busstartuptime_original_data" DOUBLE,
  "busstartuptime_maximum" BIGINT,
  "busstartuptime_sub_score" DOUBLE,
  "busstartuptime_minimum" DOUBLE,
  "busstartuptime_normalized" DOUBLE,
  "busstartuptime_weight" DOUBLE,
  "busstartupcost_original_data" 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 (
  "chcountry" VARCHAR,
  "chyear" BIGINT,
  "chthreshold" VARCHAR,
  "choriginal_data" DOUBLE,
  "chscore" DOUBLE,
  "chround_score" DOUBLE,
  "chmedian" DOUBLE,
  "chround_median" DOUBLE,
  "chpercentrank" DOUBLE
);

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

CREATE TABLE control_of_corruption (
  "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_expeditures (
  "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 (
  "fispolcountry" VARCHAR,
  "fispolyear" BIGINT,
  "fispolthreshold" VARCHAR,
  "fispolfiscal_data_2013" DOUBLE,
  "fispolfiscal_data_2014" DOUBLE,
  "fispoloriginal_data" DOUBLE,
  "fispolscore" DOUBLE,
  "fispolround_score" DOUBLE,
  "fispolmedian" DOUBLE,
  "fispolround_median" DOUBLE,
  "fispolpercentrank" DOUBLE,
  "fispolcountrycode" VARCHAR
);

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

CREATE TABLE gender_in_the_economy (
  "gendereconcountry" VARCHAR,
  "gendereconyear" BIGINT,
  "gendereconthreshold" VARCHAR,
  "gendereconcan_an_unmarried_woman_apply_for_a_passport__36ee9ad0" VARCHAR  -- GenderEconCan An Unmarried Woman Apply For A Passport In The Same Way As An Unmarried Man?,
  "gendereconcan_a_married_woman_apply_for_a_passport_in__2c44fa90" VARCHAR  -- GenderEconCan A Married Woman Apply For A Passport In The Same Way As A Married Man?,
  "gendereconcan_an_unmarried_woman_travel_outside_the_co_3ad5e7b9" VARCHAR  -- GenderEconCan An Unmarried Woman Travel Outside The Country In The Same Way As An Unmarried Man?,
  "gendereconcan_a_married_woman_travel_outside_the_count_2df42b6d" VARCHAR  -- GenderEconCan A Married Woman Travel Outside The Country In The Same Way As A Married Man?,
  "gendereconcan_an_unmarried_woman_travel_outside_her_ho_65061501" VARCHAR  -- GenderEconCan An Unmarried Woman Travel Outside Her Home In The Same Way As An Unmarried Man?,
  "gendereconcan_a_married_woman_travel_outside_her_home__f84d8a14" VARCHAR  -- GenderEconCan A Married Woman Travel Outside Her Home In The Same Way As A Married Man?,
  "gendereconcan_an_unmarried_woman_get_a_job_or_pursue_a_f0975232" VARCHAR  -- GenderEconCan An Unmarried Woman Get A Job Or Pursue A Trade Or Profession In The Same Way As An Unmarried Man?,
  "gendereconcan_a_married_woman_get_a_job_or_pursue_a_tr_b52c43ed" VARCHAR  -- GenderEconCan A Married Woman Get A Job Or Pursue A Trade Or Profession In The Same Way As A Married Man?,
  "gendereconcan_an_unmarried_woman_sign_a_contract_in_th_0de60da7" VARCHAR  -- GenderEconCan An Unmarried Woman Sign A Contract In The Same Way As An Unmarried Man?,
  "gendereconcan_a_married_woman_sign_a_contract_in_the_s_4ae28ec8" VARCHAR  -- GenderEconCan A Married Woman Sign A Contract In The Same Way As A Married Man?,
  "gendereconcan_an_unmarried_woman_register_a_business_i_b58c7aa9" VARCHAR  -- GenderEconCan An Unmarried Woman Register A Business In The Same Way As An Unmarried Man?,
  "gendereconcan_a_married_woman_register_a_business_in_t_649e7ce3" VARCHAR  -- GenderEconCan A Married Woman Register A Business In The Same Way As A Married Man?,
  "gendereconcan_an_unmarried_woman_open_a_bank_account_i_9fc5f877" VARCHAR  -- GenderEconCan An Unmarried Woman Open A Bank Account In The Same Way As An Unmarried Man?,
  "gendereconcan_a_married_woman_open_a_bank_account_in_t_63b5af65" VARCHAR  -- GenderEconCan A Married Woman Open A Bank Account In The Same Way As A Married Man?,
  "gendereconcan_an_unmarried_woman_choose_where_to_live__979919e4" VARCHAR  -- GenderEconCan An Unmarried Woman Choose Where To Live In The Same Way As An Unmarried Man?,
  "gendereconcan_a_married_woman_choose_where_to_live_in__daa8fe49" VARCHAR  -- GenderEconCan A Married Woman Choose Where To Live In The Same Way As A Married Man?,
  "gendereconcan_an_unmarried_woman_confer_citizenship_on_ae7dbfda" VARCHAR  -- GenderEconCan An Unmarried Woman Confer Citizenship On Her Children In The Same Way As An Unmarried Man?,
  "gendereconcan_a_married_woman_confer_citizenship_on_he_ecb47b5c" VARCHAR  -- GenderEconCan A Married Woman Confer Citizenship On Her Children In The Same Way As A Married Man?,
  "gendereconcan_an_unmarried_woman_be_head_of_household__87ffc625" VARCHAR  -- GenderEconCan An Unmarried Woman Be "head Of Household" Or "head Of Family" In The Same Way As An Unmarried Man?,
  "gendereconcan_a_married_woman_be_head_of_household_or__e4c9a2cb" VARCHAR  -- GenderEconCan A Married Woman Be "head Of Household" Or "head Of Family" In The Same Way As A Married Man?,
  "gendereconround_score" DOUBLE,
  "gendereconmedian" DOUBLE,
  "gendereconpercentrank" DOUBLE,
  "gendereconcountrycode" VARCHAR
);

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

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

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

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

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

CREATE TABLE inflation (
  "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 (
  "lracountry" VARCHAR,
  "lrayear" BIGINT,
  "lrathreshold" VARCHAR,
  "lraland_data" DOUBLE,
  "lraifad_maximum" DOUBLE,
  "lraifad_sub_score" DOUBLE,
  "lraifad_minimum" DOUBLE,
  "lraifad_normalized" DOUBLE,
  "lraifad_normalized_1" DOUBLE  -- LraifaD Normalized -1,
  "lraland_weight" DOUBLE,
  "lratime_days" VARCHAR  -- LraTime (days),
  "lraifc_time_maximum" DOUBLE,
  "lraifc_time_sub_score" DOUBLE,
  "lraifc_time_score" DOUBLE,
  "lratime_weight" DOUBLE,
  "lracost" VARCHAR,
  "lraifc_cost_maximum" DOUBLE,
  "lraifc_cost_sub_score" DOUBLE,
  "lraifc_cost_score" DOUBLE,
  "lracost_weight" DOUBLE,
  "lrascore" DOUBLE,
  "lraround_score" DOUBLE,
  "lramedian" DOUBLE,
  "lraround_median" DOUBLE,
  "lrapercentrank" DOUBLE,
  "lracountrycode" VARCHAR
);

CREATE TABLE lic_indicators (
  "countryname" VARCHAR,
  "healthscore" DOUBLE,
  "polrigscore" BIGINT,
  "civlibscore" BIGINT,
  "concorscore" DOUBLE,
  "govteffscore" DOUBLE,
  "rulelawscore" DOUBLE,
  "freedominfoscore" BIGINT,
  "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 lmic_indicators (
  "countryname" VARCHAR,
  "healthscore" DOUBLE,
  "polrigscore" BIGINT,
  "civlibscore" BIGINT,
  "concorscore" DOUBLE,
  "govteffscore" DOUBLE,
  "rulelawscore" DOUBLE,
  "freedominfoscore" BIGINT,
  "immunscore" DOUBLE,
  "educexpscore" DOUBLE,
  "chscore" DOUBLE,
  "nrmscore" DOUBLE,
  "regqualityscore" DOUBLE,
  "lrascore" DOUBLE,
  "busstartupscore" DOUBLE,
  "tradescore" DOUBLE,
  "inflscore" DOUBLE,
  "fispolscore" DOUBLE,
  "accesscreditscore" BIGINT,
  "gendereconscore" BIGINT,
  "girlssecscore" DOUBLE
);

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

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