MCC Country Selection Indicators For FY12

CREATE TABLE business_start_up_indicator_calculation_details_for_fy12 (
  "busstartupcountrycode" VARCHAR,
  "n__busstartupyear" BIGINT,
  "n__busstartupinccat" VARCHAR,
  "n__busstartupdatadays" VARCHAR,
  "n__busstartupdaysmin" DOUBLE,
  "n__busstartupdaysmax" DOUBLE,
  "n__busstartupdaysnormal" VARCHAR,
  "n__busstartupdatacost" VARCHAR,
  "n__busstartupcostmin" DOUBLE,
  "n__busstartupcostmax" DOUBLE,
  "n__busstartupcostnormal" VARCHAR,
  "n__busstartupagg" VARCHAR,
  "n__busstartupdisplay" VARCHAR,
  "n__busstartupmedianvalue" VARCHAR,
  "n__busstartupprvalue" VARCHAR
);

CREATE TABLE child_health_indicator_calculation_details_for_fy12 (
  "chcountrycode" VARCHAR,
  "n__chyear" BIGINT,
  "n__chinccat" VARCHAR,
  "n__chdata" VARCHAR,
  "n__chdisplay" VARCHAR,
  "n__chmedianvalue" VARCHAR,
  "n__chprvalue" VARCHAR
);

CREATE TABLE civil_liberties_indicator_calculation_details_for_fy12 (
  "civlibcountrycode" VARCHAR,
  "n__civlibyear" BIGINT,
  "n__civlibinccat" VARCHAR,
  "n__civlibdata" VARCHAR,
  "n__civlibdisplay" VARCHAR,
  "n__civlibmedianvalue" VARCHAR,
  "n__civlibprvalue" VARCHAR
);

CREATE TABLE control_of_corruption_indicator_calculation_details_for_fy12 (
  "concorcountrycode" VARCHAR,
  "n__concoryear" BIGINT,
  "n__concorinccat" VARCHAR,
  "n__concordata" VARCHAR,
  "n__concoragg" VARCHAR,
  "n__concordisplay" VARCHAR,
  "n__concorse" VARCHAR,
  "n__concormedianvalue" VARCHAR,
  "n__concornormalizedmedianvalue" VARCHAR,
  "n__concorprvalue" VARCHAR
);

CREATE TABLE education_expenditures_indicator_calculation_details_for_fy12 (
  "educexpcountrycode" VARCHAR,
  "n__educexpyear" BIGINT,
  "n__educexpinccat" VARCHAR,
  "n__educexpdatapost" VARCHAR,
  "n__educexpdataunesco" VARCHAR,
  "n__educexpagg" VARCHAR,
  "n__educexpdisplay" VARCHAR,
  "n__educexpmedianvalue" VARCHAR,
  "n__educexpprvalue" VARCHAR
);

CREATE TABLE fiscal_policy_indicator_calculation_details_for_fy12 (
  "fispolcountrycode" VARCHAR,
  "n__fispolyear" BIGINT,
  "n__fispolinccat" VARCHAR,
  "n__fispoldata" VARCHAR,
  "n__fispolagg" VARCHAR,
  "n__fispoldisplay" VARCHAR,
  "n__fispolmedianvalue" VARCHAR,
  "n__fispolprvalue" VARCHAR
);

CREATE TABLE freedom_of_information_indicator_calculation_details_for_fy12 (
  "freedominfocountrycode" VARCHAR,
  "n__freedominfoyear" BIGINT,
  "n__freedominfoinccat" VARCHAR,
  "n__freedominfodatafreepress" VARCHAR,
  "n__freedominfodatafoia" VARCHAR,
  "n__freedominfodataintertools" VARCHAR,
  "n__freedominfodatapolynet" VARCHAR,
  "n__freedominfoagg" VARCHAR,
  "n__freedominfodisplay" VARCHAR,
  "n__freedominfomedianvalue" VARCHAR,
  "n__freedominfoprvalue" VARCHAR
);

CREATE TABLE gender_in_the_economy_indicator_calculation_for_fy12 (
  "gendereconcountrycode" VARCHAR,
  "n__gendereconyear" BIGINT,
  "n__gendereconinccat" VARCHAR,
  "n__genderecondata" VARCHAR,
  "n__genderecondisplay" VARCHAR,
  "n__gendereconmedianvalue" VARCHAR,
  "n__gendereconprvalue" VARCHAR
);

CREATE TABLE girls_primary_education_completion_rates_indicator_cal_c7082499 (
  "girlsprimcountrycode" VARCHAR,
  "n__girlsprimyear" BIGINT,
  "n__girlspriminccat" VARCHAR,
  "n__girlsprimdata" VARCHAR,
  "n__girlsprimagg" VARCHAR,
  "n__girlsprimmedianvalue" VARCHAR,
  "n__girlsprimprvalue" VARCHAR
);

CREATE TABLE girls_secondary_education_enrollment_rates_for_fy12 (
  "girlsseccountrycode" VARCHAR,
  "n__girlssecyear" BIGINT,
  "n__girlssecinccat" VARCHAR,
  "n__girlssecdata" VARCHAR,
  "n__girlssecagg" VARCHAR,
  "n__girlssecmedianvalue" VARCHAR,
  "n__girlssecprvalue" VARCHAR
);

CREATE TABLE gni_indicator_calculation_details_for_fy12 (
  "countrycode" VARCHAR,
  "n__gnicapyear" BIGINT,
  "n__gnicap" VARCHAR,
  "n__gniinccatoverride" VARCHAR
);

CREATE TABLE gni_limits_indicator_calculation_details_for_fy12 (
  "gnilimityear" BIGINT,
  "n__gnilimitinccat" VARCHAR,
  "n__gnilimitlow" BIGINT,
  "n__gnilimithigh" BIGINT
);

CREATE TABLE government_effectiveness_indicator_calculation_details_for_fy12 (
  "govteffcountrycode" VARCHAR,
  "n__govteffyear" BIGINT,
  "n__govteffinccat" VARCHAR,
  "n__govteffdata" VARCHAR,
  "n__govteffagg" VARCHAR,
  "n__govteffdisplay" VARCHAR,
  "n__govteffse" VARCHAR,
  "n__govteffmedianvalue" VARCHAR,
  "n__govteffnormalizedmedianvalue" VARCHAR,
  "n__govteffprvalue" VARCHAR
);

CREATE TABLE health_expenditures_indicator_calculation_details_for_fy12 (
  "healthcountrycode" VARCHAR,
  "n__healthyear" BIGINT,
  "n__healthinccat" VARCHAR,
  "n__healthdata" VARCHAR,
  "n__healthdisplay" VARCHAR,
  "n__healthmedianvalue" VARCHAR,
  "n__healthprvalue" VARCHAR
);

CREATE TABLE immunization_rates_indicator_calculation_details_for_fy12 (
  "immuncountrycode" VARCHAR,
  "n__immunyear" BIGINT,
  "n__immuninccat" VARCHAR,
  "n__immundatadpt3" VARCHAR,
  "n__immundatamcv" VARCHAR,
  "n__immunagg" VARCHAR,
  "n__immundisplay" VARCHAR,
  "n__immunmedianvalue" VARCHAR,
  "n__immunprvalue" VARCHAR
);

CREATE TABLE income_categories_indicator_calculation_details_for_fy12 (
  "incomecategory" VARCHAR,
  "n__incomecategorydesc" VARCHAR
);

CREATE TABLE income_category_calculation_details_for_fy12 (
  "incomecategorydesc" VARCHAR
);

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

CREATE TABLE indicators_threshold_indicator_calculation_details_for_fy12 (
  "indicatorcode" VARCHAR,
  "n__incomecategory" VARCHAR,
  "n__reportyear" BIGINT,
  "n__medianvalue" VARCHAR,
  "n__sevalue" VARCHAR,
  "n__thresholdcode" VARCHAR
);

CREATE TABLE inflation_indicator_calculation_details_for_fy12 (
  "inflcountrycode" VARCHAR,
  "n__inflyear" BIGINT,
  "n__inflinccat" VARCHAR,
  "n__infldata" VARCHAR,
  "n__infldisplay" VARCHAR,
  "n__inflmedianvalue" VARCHAR,
  "n__inflprvalue" VARCHAR
);

CREATE TABLE land_rights_and_access_indicator_calculation_details_for_fy12 (
  "lracountrycode" VARCHAR,
  "n__lrayear" BIGINT,
  "n__lrainccat" VARCHAR,
  "n__lradataifad" VARCHAR,
  "n__lraifadmin" DOUBLE,
  "n__lraifadmax" DOUBLE,
  "n__lraifadnormal" VARCHAR,
  "n__lradataifctime" VARCHAR,
  "n__lraifctimemin" DOUBLE,
  "n__lraifctimemax" DOUBLE,
  "n__lraifctimenormal" VARCHAR,
  "n__lradataifccost" VARCHAR,
  "n__lraifccostmin" DOUBLE,
  "n__lraifccostmax" DOUBLE,
  "n__lraifccostnormal" VARCHAR,
  "n__lraagg" VARCHAR,
  "n__lradisplay" VARCHAR,
  "n__lramedianvalue" VARCHAR,
  "n__lraprvalue" VARCHAR
);

CREATE TABLE lic_countries_indicator_calculation_details_for_fy12 (
  "countrycode" VARCHAR,
  "n__polrigdisplay" DOUBLE,
  "n__civlibdisplay" DOUBLE,
  "n__concordisplay" DOUBLE,
  "n__govteffdisplay" DOUBLE,
  "n__rulelawdisplay" DOUBLE,
  "n__freedominfodisplay" DOUBLE,
  "n__immundisplay" DOUBLE,
  "n__healthdisplay" VARCHAR,
  "n__educexpdisplay" VARCHAR,
  "n__girlsprimagg" VARCHAR,
  "n__chdisplay" DOUBLE,
  "n__nrmdisplay" DOUBLE,
  "n__regqualitydisplay" DOUBLE,
  "n__lradisplay" VARCHAR,
  "n__busstartupdisplay" VARCHAR,
  "n__tradedisplay" VARCHAR,
  "n__infldisplay" VARCHAR,
  "n__fispoldisplay" VARCHAR,
  "n__accesscreditdisplay" VARCHAR,
  "n__genderecondisplay" VARCHAR
);

CREATE TABLE lmic_indicator_calculation_details_for_fy12 (
  "countrycode" VARCHAR,
  "n__polrigdisplay" DOUBLE,
  "n__civlibdisplay" DOUBLE,
  "n__concordisplay" DOUBLE,
  "n__govteffdisplay" DOUBLE,
  "n__rulelawdisplay" DOUBLE,
  "n__freedominfodisplay" DOUBLE,
  "n__immundisplay" VARCHAR,
  "n__healthdisplay" VARCHAR,
  "n__educexpdisplay" VARCHAR,
  "n__girlssecagg" VARCHAR,
  "n__chdisplay" VARCHAR,
  "n__nrmdisplay" DOUBLE,
  "n__regqualitydisplay" DOUBLE,
  "n__lradisplay" VARCHAR,
  "n__busstartupdisplay" VARCHAR,
  "n__tradedisplay" VARCHAR,
  "n__infldisplay" VARCHAR,
  "n__fispoldisplay" VARCHAR,
  "n__accesscreditdisplay" VARCHAR,
  "n__genderecondisplay" VARCHAR
);

CREATE TABLE natural_resource_protection_indicator_calculation_deta_4eb91b09 (
  "nrmcountrycode" VARCHAR,
  "n__nrmyear" BIGINT,
  "n__nrminccat" VARCHAR,
  "n__nrmdata" VARCHAR,
  "n__nrmdisplay" VARCHAR,
  "n__nrmmedianvalue" VARCHAR,
  "n__nrmprvalue" VARCHAR
);

CREATE TABLE political_rights_indicator_calculation_details_for_fy12 (
  "polrigcountrycode" VARCHAR,
  "n__polrigyear" BIGINT,
  "n__polriginccat" VARCHAR,
  "n__polrigdata" VARCHAR,
  "n__polrigdisplay" VARCHAR,
  "n__polrigmedianvalue" VARCHAR,
  "n__polrigprvalue" VARCHAR
);