MCC Country Selection Indicators For FY15

CREATE TABLE child_health_indicator_calculation_details_for_fy15 (
  "chcountrycode" VARCHAR,
  "chyear" BIGINT,
  "chinccat" VARCHAR,
  "chdata" DOUBLE,
  "chdisplay" DOUBLE,
  "chmedianvalue" DOUBLE,
  "chprvalue" DOUBLE
);

CREATE TABLE civil_liberties_indicator_calculation_details_for_fy15 (
  "civlibcountrycode" VARCHAR,
  "civlibyear" BIGINT,
  "civlibinccat" VARCHAR,
  "civlibdata" DOUBLE,
  "civlibdisplay" DOUBLE,
  "civlibmedianvalue" DOUBLE,
  "civlibprvalue" DOUBLE
);

CREATE TABLE control_of_corruption_indicator_calculation_details_for_fy15 (
  "concorcountrycode" VARCHAR,
  "concoryear" BIGINT,
  "concorinccat" VARCHAR,
  "concordata" DOUBLE,
  "concoragg" DOUBLE,
  "concordisplay" DOUBLE,
  "concorse" DOUBLE,
  "concormedianvalue" DOUBLE,
  "concornormalizedmedianvalue" DOUBLE,
  "concorprvalue" DOUBLE
);

CREATE TABLE education_expenditures_indicator_calculation_details_for_fy15 (
  "educexpcountrycode" VARCHAR,
  "educexpyear" BIGINT,
  "educexpinccat" VARCHAR,
  "educexpdatapost" VARCHAR,
  "educexpdataunesco" DOUBLE,
  "educexpagg" DOUBLE,
  "educexpdisplay" DOUBLE,
  "educexpmedianvalue" DOUBLE,
  "educexpprvalue" DOUBLE
);

CREATE TABLE fiscal_policy_indicator_calculation_details_for_fy15 (
  "fispolcountrycode" VARCHAR,
  "fispolyear" BIGINT,
  "fispolinccat" VARCHAR,
  "fispoldata" DOUBLE,
  "fispolagg" DOUBLE,
  "fispoldisplay" DOUBLE,
  "fispolmedianvalue" DOUBLE,
  "fispolprvalue" DOUBLE
);

CREATE TABLE freedom_of_information_indicator_calculation_details_for_fy15 (
  "freedominfocountrycode" VARCHAR,
  "freedominfoyear" BIGINT,
  "freedominfoinccat" VARCHAR,
  "freedominfodatafreepress" DOUBLE,
  "freedominfodatafoia" DOUBLE,
  "freedominfodataintertools" DOUBLE,
  "freedominfodatapolynet" DOUBLE,
  "freedominfoagg" DOUBLE,
  "freedominfodisplay" DOUBLE,
  "freedominfomedianvalue" DOUBLE,
  "freedominfoprvalue" DOUBLE
);

CREATE TABLE gender_in_the_economy_indicator_calculation_details_for_fy15 (
  "gendereconcountrycode" VARCHAR,
  "gendereconyear" BIGINT,
  "gendereconinccat" VARCHAR,
  "genderecondata" DOUBLE,
  "genderecondisplay" DOUBLE,
  "gendereconmedianvalue" DOUBLE,
  "gendereconprvalue" DOUBLE
);

CREATE TABLE girls_primary_education_completion_rates_indicator_cal_341b8670 (
  "girlsprimcountrycode" VARCHAR,
  "girlsprimyear" BIGINT,
  "girlspriminccat" VARCHAR,
  "girlsprimdata" DOUBLE,
  "girlsprimagg" DOUBLE,
  "girlsprimmedianvalue" DOUBLE,
  "girlsprimprvalue" DOUBLE
);

CREATE TABLE girls_secondary_education_enrollment_rates_indicator_c_2607d562 (
  "girlsseccountrycode" VARCHAR,
  "girlssecyear" BIGINT,
  "girlssecinccat" VARCHAR,
  "girlssecdata" DOUBLE,
  "girlssecagg" DOUBLE,
  "girlssecmedianvalue" DOUBLE,
  "girlssecprvalue" DOUBLE
);

CREATE TABLE gni_data_for_countries_including_override_values (
  "countrycode" VARCHAR,
  "gnicapyear" BIGINT,
  "gnicap" DOUBLE,
  "gniinccatoverride" VARCHAR
);

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

CREATE TABLE government_effectiveness_indicator_calculation_details_for_fy15 (
  "govteffcountrycode" VARCHAR,
  "govteffyear" BIGINT,
  "govteffinccat" VARCHAR,
  "govteffdata" DOUBLE,
  "govteffagg" DOUBLE,
  "govteffdisplay" DOUBLE,
  "govteffse" DOUBLE,
  "govteffmedianvalue" DOUBLE,
  "govteffnormalizedmedianvalue" DOUBLE,
  "govteffprvalue" DOUBLE
);

CREATE TABLE health_expenditures_indicator_calculation_details_for_fy15 (
  "healthcountrycode" VARCHAR,
  "healthyear" BIGINT,
  "healthinccat" VARCHAR,
  "healthdata" DOUBLE,
  "healthdisplay" DOUBLE,
  "healthmedianvalue" DOUBLE,
  "healthprvalue" DOUBLE
);

CREATE TABLE immunization_rates_indicator_calculation_details_for_fy15 (
  "immuncountrycode" VARCHAR,
  "immunyear" BIGINT,
  "immuninccat" VARCHAR,
  "immundatadpt3" DOUBLE,
  "immundatamcv" DOUBLE,
  "immunagg" DOUBLE,
  "immundisplay" DOUBLE,
  "immunmedianvalue" DOUBLE,
  "immunprvalue" DOUBLE
);

CREATE TABLE indicator_categories_calculation_details_for_fy15 (
  "category" VARCHAR,
  "description" VARCHAR
);

CREATE TABLE indicators_calculation_details_for_fy15 (
  "indicator" VARCHAR,
  "category" VARCHAR,
  "description" VARCHAR,
  "source" VARCHAR
);

CREATE TABLE inflation_indicator_calculation_details_for_fy15 (
  "infldisplay" DOUBLE,
  "inflcountrycode" VARCHAR,
  "inflyear" BIGINT,
  "inflinccat" VARCHAR,
  "infldata" DOUBLE,
  "inflmedianvalue" DOUBLE,
  "inflprvalue" DOUBLE
);

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

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

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

CREATE TABLE natural_resource_protection_indicator_calculation_deta_68d28f03 (
  "nrmcountrycode" VARCHAR,
  "nrmyear" BIGINT,
  "nrminccat" VARCHAR,
  "nrmdata" DOUBLE,
  "nrmdisplay" DOUBLE,
  "nrmmedianvalue" DOUBLE,
  "nrmprvalue" DOUBLE
);

CREATE TABLE political_rights_indicator_calculation_details_for_fy15 (
  "polrigcountrycode" VARCHAR,
  "polrigyear" BIGINT,
  "polriginccat" VARCHAR,
  "polrigdata" DOUBLE,
  "polrigdisplay" DOUBLE,
  "polrigmedianvalue" DOUBLE,
  "polrigprvalue" DOUBLE
);

CREATE TABLE regulatory_quality_indicator_calculation_details_for_fy15 (
  "regqualitycountrycode" VARCHAR,
  "regqualityyear" BIGINT,
  "regqualityinccat" VARCHAR,
  "regqualitydata" DOUBLE,
  "regqualityagg" DOUBLE,
  "regqualitydisplay" DOUBLE,
  "regqualityse" DOUBLE,
  "regqualitymedianvalue" DOUBLE,
  "regqualitynormalizedmedianvalue" DOUBLE,
  "regqualityprvalue" DOUBLE
);

CREATE TABLE rule_of_law_indicator_calculation_details_for_fy15 (
  "rulelawcountrycode" VARCHAR,
  "rulelawyear" BIGINT,
  "rulelawinccat" VARCHAR,
  "rulelawdata" DOUBLE,
  "rulelawagg" DOUBLE,
  "rulelawdisplay" DOUBLE,
  "rulelawse" DOUBLE,
  "rulelawmedianvalue" DOUBLE,
  "rulelawnormalizedmedianvalue" DOUBLE,
  "rulelawprvalue" DOUBLE
);

CREATE TABLE selection_indicators_values_for_fy15 (
  "countrycode2" VARCHAR,
  "indicatorcode" VARCHAR,
  "datayear" BIGINT,
  "datavalue" DOUBLE,
  "displayvalue" DOUBLE,
  "datapr" DOUBLE,
  "datase" DOUBLE
);