MCC Country Selection Indicators For FY16

CREATE TABLE business_start_up_indicator_calculation_details_for_fy16 (
  "busstartup_id" VARCHAR,
  "busstartupcountrycode" VARCHAR,
  "busstartupyear" VARCHAR,
  "busstartupinccat" VARCHAR,
  "busstartupdatadays" VARCHAR,
  "busstartupdaysmin" VARCHAR,
  "busstartupdaysmax" VARCHAR,
  "busstartupdaysnormal" VARCHAR,
  "busstartupdatacost" VARCHAR,
  "busstartupcostmin" VARCHAR,
  "busstartupcostmax" VARCHAR,
  "busstartupcostnormal" VARCHAR,
  "busstartupagg" VARCHAR,
  "busstartupdisplay" VARCHAR,
  "busstartupmedianvalue" VARCHAR,
  "busstartupprvalue" VARCHAR
);

CREATE TABLE child_health_indicator_calculation_details_for_fy16 (
  "ch_id" VARCHAR,
  "chcountrycode" VARCHAR,
  "chyear" VARCHAR,
  "chinccat" VARCHAR,
  "chdata" VARCHAR,
  "chdisplay" VARCHAR,
  "chmedianvalue" VARCHAR,
  "chprvalue" VARCHAR
);

CREATE TABLE civil_liberties_indicator_calculation_details_for_fy16 (
  "civlib_id" VARCHAR,
  "civlibcountrycode" VARCHAR,
  "civlibyear" VARCHAR,
  "civlibinccat" VARCHAR,
  "civlibdata" VARCHAR,
  "civlibdisplay" VARCHAR,
  "civlibmedianvalue" VARCHAR,
  "civlibprvalue" VARCHAR
);

CREATE TABLE control_of_corruption_indicator_calculation_details_for_fy16 (
  "concorid" VARCHAR,
  "country" VARCHAR,
  "countrycode" VARCHAR,
  "concoryear" VARCHAR,
  "concor" VARCHAR,
  "concorse" VARCHAR
);

CREATE TABLE education_expenditures_indicator_calculation_details_for_fy16 (
  "educexp_id" VARCHAR,
  "educexpcountrycode" VARCHAR,
  "educexpyear" VARCHAR,
  "educexpinccat" VARCHAR,
  "educexpdatapost" VARCHAR,
  "educexpdataunesco" VARCHAR,
  "educexpagg" VARCHAR,
  "educexpdisplay" VARCHAR,
  "educexpmedianvalue" VARCHAR,
  "educexpprvalue" VARCHAR
);

CREATE TABLE fiscal_policy_indicator_calculation_details_for_fy16 (
  "fispol_id" VARCHAR,
  "fispolcountrycode" VARCHAR,
  "fispolyear" VARCHAR,
  "fispolinccat" VARCHAR,
  "fispoldata" VARCHAR,
  "fispolagg" VARCHAR,
  "fispoldisplay" VARCHAR,
  "fispolmedianvalue" VARCHAR,
  "fispolprvalue" VARCHAR
);

CREATE TABLE freedom_of_information_indicator_calculation_details_for_fy16 (
  "freedominfo_id" VARCHAR,
  "freedominfocountrycode" VARCHAR,
  "freedominfoyear" VARCHAR,
  "freedominfoinccat" VARCHAR,
  "freedominfodatafreepress" VARCHAR,
  "freedominfodatafoia" VARCHAR,
  "freedominfodataintertools" VARCHAR,
  "freedominfodatapolynet" VARCHAR,
  "freedominfoagg" VARCHAR,
  "freedominfodisplay" VARCHAR,
  "freedominfomedianvalue" VARCHAR,
  "freedominfoprvalue" VARCHAR
);

CREATE TABLE gender_in_the_economy_indicator_calcuation_details_for_fy16 (
  "genderecon_id" VARCHAR,
  "gendereconcountrycode" VARCHAR,
  "gendereconyear" VARCHAR,
  "gendereconinccat" VARCHAR,
  "genderecondata" VARCHAR,
  "genderecondisplay" VARCHAR,
  "gendereconmedianvalue" VARCHAR,
  "gendereconprvalue" VARCHAR
);

CREATE TABLE girls_primary_education_completion_rates_indicator_cal_396132a8 (
  "girlsprim_id" VARCHAR,
  "girlsprimcountrycode" VARCHAR,
  "girlsprimyear" VARCHAR,
  "girlspriminccat" VARCHAR,
  "girlsprimdata" VARCHAR,
  "girlsprimagg" VARCHAR,
  "girlsprimmedianvalue" VARCHAR,
  "girlsprimprvalue" VARCHAR
);

CREATE TABLE girls_secondary_education_enrollment_rates_for_fy16 (
  "girlssec_id" VARCHAR,
  "girlsseccountrycode" VARCHAR,
  "girlssecyear" VARCHAR,
  "girlssecinccat" VARCHAR,
  "girlssecdata" VARCHAR,
  "girlssecagg" VARCHAR,
  "girlssecmedianvalue" VARCHAR,
  "girlssecprvalue" VARCHAR
);

CREATE TABLE gni_indicator_calculation_details_for_fy16 (
  "gnicapid" VARCHAR,
  "country" VARCHAR,
  "countrycode" VARCHAR,
  "gnicapyear" VARCHAR,
  "gnicap" VARCHAR,
  "gniinccatoverride" VARCHAR
);

CREATE TABLE gni_limits_indicator_calculation_details_for_fy16 (
  "gnilimitid" VARCHAR,
  "gnilimityear" VARCHAR,
  "gnilimitinccat" VARCHAR,
  "gnilimitlow" VARCHAR,
  "gnilimithigh" VARCHAR
);

CREATE TABLE government_effectiveness_indicator_calculation_details_for_fy16 (
  "govteff_id" VARCHAR,
  "govteffcountrycode" VARCHAR,
  "govteffyear" VARCHAR,
  "govteffinccat" VARCHAR,
  "govteffdata" VARCHAR,
  "govteffagg" VARCHAR,
  "govteffdisplay" VARCHAR,
  "govteffse" VARCHAR,
  "govteffmedianvalue" VARCHAR,
  "govteffnormalizedmedianvalue" VARCHAR,
  "govteffprvalue" VARCHAR
);

CREATE TABLE health_expenditures_indicator_calculation_details_for_fy16 (
  "health_id" VARCHAR,
  "healthcountrycode" VARCHAR,
  "healthyear" VARCHAR,
  "healthinccat" VARCHAR,
  "healthdata" VARCHAR,
  "healthdisplay" VARCHAR,
  "healthmedianvalue" VARCHAR,
  "healthprvalue" VARCHAR
);

CREATE TABLE immunization_rates_indicator_calculation_details_for_fy16 (
  "immun_id" VARCHAR,
  "immuncountrycode" VARCHAR,
  "immunyear" VARCHAR,
  "immuninccat" VARCHAR,
  "immundatadpt3" VARCHAR,
  "immundatamcv" VARCHAR,
  "immunagg" VARCHAR,
  "immundisplay" VARCHAR,
  "immunmedianvalue" VARCHAR,
  "immunprvalue" VARCHAR
);

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

CREATE TABLE indicators_threshold_calculation_details_for_fy16 (
  "indicatorcode" VARCHAR,
  "incomecategory" VARCHAR,
  "reportyear" VARCHAR,
  "medianvalue" VARCHAR,
  "sevalue" VARCHAR,
  "thresholdcode" VARCHAR
);

CREATE TABLE inflation_indicator_calculation_details_for_fy16 (
  "infl_id" VARCHAR,
  "inflcountrycode" VARCHAR,
  "inflyear" VARCHAR,
  "inflinccat" VARCHAR,
  "infldata" VARCHAR,
  "infldisplay" VARCHAR,
  "inflmedianvalue" VARCHAR,
  "inflprvalue" VARCHAR
);

CREATE TABLE land_rights_and_access_indicator_calculation_details_for_fy16 (
  "lra_id" VARCHAR,
  "lracountrycode" VARCHAR,
  "lrayear" VARCHAR,
  "lrainccat" VARCHAR,
  "lradataifad" VARCHAR,
  "lraifadmin" VARCHAR,
  "lraifadmax" VARCHAR,
  "lraifadnormal" VARCHAR,
  "lradataifctime" VARCHAR,
  "lraifctimemin" VARCHAR,
  "lraifctimemax" VARCHAR,
  "lraifctimenormal" VARCHAR,
  "lradataifccost" VARCHAR,
  "lraifccostmin" VARCHAR,
  "lraifccostmax" VARCHAR,
  "lraifccostnormal" VARCHAR,
  "lraagg" VARCHAR,
  "lradisplay" VARCHAR,
  "lramedianvalue" VARCHAR,
  "lraprvalue" VARCHAR
);

CREATE TABLE lic_countries_indicators_summary_fy16 (
  "countrycode" VARCHAR,
  "healthdisplay" VARCHAR,
  "polrigdisplay" VARCHAR,
  "civlibdisplay" VARCHAR,
  "concordisplay" VARCHAR,
  "govteffdisplay" VARCHAR,
  "rulelawdisplay" VARCHAR,
  "freedominfodisplay" VARCHAR,
  "immundisplay" VARCHAR,
  "educexpdisplay" VARCHAR,
  "chdisplay" VARCHAR,
  "nrmdisplay" VARCHAR,
  "regqualitydisplay" VARCHAR,
  "lradisplay" VARCHAR,
  "busstartupdisplay" VARCHAR,
  "tradedisplay" VARCHAR,
  "infldisplay" VARCHAR,
  "fispoldisplay" VARCHAR,
  "accesscreditdisplay" VARCHAR,
  "genderecondisplay" VARCHAR,
  "girlssecagg" VARCHAR
);

CREATE TABLE lmic_indicator_calculation_details_for_fy16 (
  "countrycode" VARCHAR,
  "healthdisplay" VARCHAR,
  "polrigdisplay" VARCHAR,
  "civlibdisplay" VARCHAR,
  "concordisplay" VARCHAR,
  "govteffdisplay" VARCHAR,
  "rulelawdisplay" VARCHAR,
  "freedominfodisplay" VARCHAR,
  "immundisplay" VARCHAR,
  "educexpdisplay" VARCHAR,
  "chdisplay" VARCHAR,
  "nrmdisplay" VARCHAR,
  "regqualitydisplay" VARCHAR,
  "lradisplay" VARCHAR,
  "busstartupdisplay" VARCHAR,
  "tradedisplay" VARCHAR,
  "infldisplay" VARCHAR,
  "fispoldisplay" VARCHAR,
  "accesscreditdisplay" VARCHAR,
  "genderecondisplay" VARCHAR,
  "girlssecagg" VARCHAR
);

CREATE TABLE natural_resource_protection_indicator_calculation_deta_9c2d7b60 (
  "nrm_id" VARCHAR,
  "nrmcountrycode" VARCHAR,
  "nrmyear" VARCHAR,
  "nrminccat" VARCHAR,
  "nrmdata" VARCHAR,
  "nrmdisplay" VARCHAR,
  "nrmmedianvalue" VARCHAR,
  "nrmprvalue" VARCHAR
);

CREATE TABLE political_rights_indicator_calclulation_details_for_fy16 (
  "polrig_id" VARCHAR,
  "polrigcountrycode" VARCHAR,
  "polrigyear" VARCHAR,
  "polriginccat" VARCHAR,
  "polrigdata" VARCHAR,
  "polrigdisplay" VARCHAR,
  "polrigmedianvalue" VARCHAR,
  "polrigprvalue" VARCHAR
);

CREATE TABLE regulatory_quality_indicator_calculation_details_fro_fy16 (
  "regquality_id" VARCHAR,
  "regqualitycountrycode" VARCHAR,
  "regqualityyear" VARCHAR,
  "regqualityinccat" VARCHAR,
  "regqualitydata" VARCHAR,
  "regqualityagg" VARCHAR,
  "regqualitydisplay" VARCHAR,
  "regqualityse" VARCHAR,
  "regqualitymedianvalue" VARCHAR,
  "regqualitynormalizedmedianvalue" VARCHAR,
  "regqualityprvalue" VARCHAR
);

CREATE TABLE rule_of_law_indicator_calculation_details_for_fy16 (
  "rulelaw_id" VARCHAR,
  "rulelawcountrycode" VARCHAR,
  "rulelawyear" VARCHAR,
  "rulelawinccat" VARCHAR,
  "rulelawdata" VARCHAR,
  "rulelawagg" VARCHAR,
  "rulelawdisplay" VARCHAR,
  "rulelawse" VARCHAR,
  "rulelawmedianvalue" VARCHAR,
  "rulelawnormalizedmedianvalue" VARCHAR,
  "rulelawprvalue" VARCHAR
);