Pakistan Dataset 1960 To 2020

CREATE TABLE pakistan_dataset_1960_to_2020 (
  "year" BIGINT,
  "transport_services_of_commercial_service_exports" DOUBLE  -- Transport Services (% Of Commercial Service Exports),
  "merchandise_exports_to_high_income_economies_of_total__b7d78356" DOUBLE  -- Merchandise Exports To High-income Economies (% Of Total Merchandise Exports),
  "commercial_service_imports_current_us" DOUBLE  -- Commercial Service Imports (current US$),
  "ores_and_metals_imports_of_merchandise_imports" DOUBLE  -- Ores And Metals Imports (% Of Merchandise Imports),
  "tariff_rate_most_favored_nation_weighted_mean_all_products" DOUBLE  -- Tariff Rate, Most Favored Nation, Weighted Mean, All Products (%),
  "import_volume_index_2000_100" DOUBLE  -- Import Volume Index (2000 \u003d 100),
  "rural_population_of_total_population" DOUBLE  -- Rural Population (% Of Total Population),
  "population_growth_annual" DOUBLE  -- Population Growth (annual %),
  "population_ages_65_and_above_female" BIGINT  -- Population Ages 65 And Above, Female,
  "population_ages_30_34_female_of_female_population" DOUBLE  -- Population Ages 30-34, Female (% Of Female Population),
  "population_ages_05_09_female_of_female_population" DOUBLE  -- Population Ages 05-09, Female (% Of Female Population),
  "fertility_rate_total_births_per_woman" DOUBLE  -- Fertility Rate, Total (births Per Woman),
  "consumption_of_iodized_salt_of_households" DOUBLE  -- Consumption Of Iodized Salt (% Of Households),
  "unemployment_female_of_female_labor_force_national_estimate" DOUBLE  -- Unemployment, Female (% Of Female Labor Force) (national Estimate),
  "unemployment_youth_male_of_male_labor_force_ages_15_24_ac19cd85" DOUBLE  -- Unemployment, Youth Male (% Of Male Labor Force Ages 15-24) (national Estimate),
  "ratio_of_female_to_male_labor_force_participation_rate_92ac1b7d" DOUBLE  -- Ratio Of Female To Male Labor Force Participation Rate (%) (national Estimate),
  "labor_force_participation_rate_for_ages_15_24_female_m_b2e5d8b4" DOUBLE  -- Labor Force Participation Rate For Ages 15-24, Female (%) (modeled ILO Estimate),
  "children_in_employment_female_of_female_children_ages_7_14" DOUBLE  -- Children In Employment, Female (% Of Female Children Ages 7-14),
  "gdp_per_person_employed_constant_2017_ppp" DOUBLE  -- GDP Per Person Employed (constant 2017 PPP $),
  "employment_to_population_ratio_15_male_national_estimate" DOUBLE  -- Employment To Population Ratio, 15+, Male (%) (national Estimate),
  "employment_in_agriculture_of_total_employment_modeled__ac922820" DOUBLE  -- Employment In Agriculture (% Of Total Employment) (modeled ILO Estimate),
  "multidimensional_poverty_headcount_ratio_male_of_male__ddadb5a9" VARCHAR  -- Multidimensional Poverty Headcount Ratio, Male (% Of Male Population),
  "income_share_held_by_highest_20" DOUBLE  -- Income Share Held By Highest 20%,
  "external_health_expenditure_per_capita_current_us" DOUBLE  -- External Health Expenditure Per Capita (current US$),
  "increase_in_poverty_gap_at_1_90_2011_ppp_poverty_line__461b2c63" DOUBLE  -- Increase In Poverty Gap At $1.90 ($ 2011 PPP) Poverty Line Due To Out-of-pocket Health Care Expenditure (% Of Poverty Line),
  "suicide_mortality_rate_female_per_100_000_female_population" DOUBLE  -- Suicide Mortality Rate, Female (per 100,000 Female Population),
  "diarrhea_treatment_of_children_under_5_receiving_oral__c375cd23" DOUBLE  -- Diarrhea Treatment (% Of Children Under 5 Receiving Oral Rehydration And Continued Feeding),
  "exclusive_breastfeeding_of_children_under_6_months" DOUBLE  -- Exclusive Breastfeeding (% Of Children Under 6 Months),
  "lifetime_risk_of_maternal_death" DOUBLE  -- Lifetime Risk Of Maternal Death (%),
  "incidence_of_hiv_ages_15_24_per_1_000_uninfected_popul_e2da39cc" DOUBLE  -- Incidence Of HIV, Ages 15-24 (per 1,000 Uninfected Population Ages 15-24),
  "demand_for_family_planning_satisfied_by_modern_methods_e5035906" DOUBLE  -- Demand For Family Planning Satisfied By Modern Methods (% Of Married Women With Demand For Family Planning),
  "number_of_under_five_deaths" DOUBLE,
  "women_who_believe_a_husband_is_justified_in_beating_hi_f15dfa10" DOUBLE  -- Women Who Believe A Husband Is Justified In Beating His Wife When She Refuses Sex With Him (%),
  "government_expenditure_per_student_tertiary_of_gdp_per_capita" DOUBLE  -- Government Expenditure Per Student, Tertiary (% Of GDP Per Capita),
  "educational_attainment_at_least_completed_short_cycle__e28680a2" DOUBLE  -- Educational Attainment, At Least Completed Short-cycle Tertiary, Population 25+, Female (%) (cumulative),
  "trained_teachers_in_secondary_education_of_total_teachers" DOUBLE  -- Trained Teachers In Secondary Education (% Of Total Teachers),
  "school_enrollment_secondary_male_gross" DOUBLE  -- School Enrollment, Secondary, Male (% Gross),
  "educational_attainment_at_least_completed_post_seconda_b3cf570c" DOUBLE  -- Educational Attainment, At Least Completed Post-secondary, Population 25+, Total (%) (cumulative),
  "adjusted_net_enrollment_rate_primary_male_of_primary_s_29e6c25b" DOUBLE  -- Adjusted Net Enrollment Rate, Primary, Male (% Of Primary School Age Children),
  "persistence_to_grade_5_female_of_cohort" DOUBLE  -- Persistence To Grade 5, Female (% Of Cohort),
  "school_enrollment_primary_gross" DOUBLE  -- School Enrollment, Primary (% Gross),
  "school_enrollment_preprimary_female_gross" DOUBLE  -- School Enrollment, Preprimary, Female (% Gross),
  "real_effective_exchange_rate_index_2010_100" DOUBLE  -- Real Effective Exchange Rate Index (2010 \u003d 100),
  "adequacy_of_social_safety_net_programs_of_total_welfar_32d6bbfa" DOUBLE  -- Adequacy Of Social Safety Net Programs (% Of Total Welfare Of Beneficiary Households),
  "dec_alternative_conversion_factor_lcu_per_us" DOUBLE  -- DEC Alternative Conversion Factor (LCU Per US$),
  "gni_per_capita_ppp_current_international" DOUBLE  -- GNI Per Capita, PPP (current International $),
  "gross_domestic_savings_of_gdp" DOUBLE  -- Gross Domestic Savings (% Of GDP),
  "gdp_growth_annual" DOUBLE  -- GDP Growth (annual %),
  "inflation_gdp_deflator_annual" DOUBLE  -- Inflation, GDP Deflator (annual %),
  "adjusted_savings_natural_resources_depletion_of_gni" DOUBLE  -- Adjusted Savings: Natural Resources Depletion (% Of GNI),
  "services_value_added_constant_lcu" DOUBLE  -- Services, Value Added (constant LCU),
  "industry_including_construction_value_added_current_lcu" DOUBLE  -- Industry (including Construction), Value Added (current LCU),
  "agriculture_forestry_and_fishing_value_added_current_us" BIGINT  -- Agriculture, Forestry, And Fishing, Value Added (current US$),
  "high_technology_exports_current_us" DOUBLE  -- High-technology Exports (current US$),
  "merchandise_exports_to_economies_in_the_arab_world_of__4117e19e" DOUBLE  -- Merchandise Exports To Economies In The Arab World (% Of Total Merchandise Exports),
  "import_value_index_2000_100" DOUBLE  -- Import Value Index (2000 \u003d 100),
  "insurance_and_financial_services_of_commercial_service_imports" DOUBLE  -- Insurance And Financial Services (% Of Commercial Service Imports),
  "share_of_tariff_lines_with_specific_rates_all_products" DOUBLE  -- Share Of Tariff Lines With Specific Rates, All Products (%),
  "international_tourism_expenditures_of_total_imports" DOUBLE  -- International Tourism, Expenditures (% Of Total Imports),
  "rural_population" BIGINT,
  "age_dependency_ratio_old_of_working_age_population" DOUBLE  -- Age Dependency Ratio, Old (% Of Working-age Population),
  "population_ages_65_69_female_of_female_population" DOUBLE  -- Population Ages 65-69, Female (% Of Female Population),
  "population_ages_25_29_female_of_female_population" DOUBLE  -- Population Ages 25-29, Female (% Of Female Population),
  "population_ages_0_14_total" BIGINT  -- Population Ages 0-14, Total,
  "life_expectancy_at_birth_total_years" DOUBLE  -- Life Expectancy At Birth, Total (years),
  "prevalence_of_undernourishment_of_population" DOUBLE  -- Prevalence Of Undernourishment (% Of Population),
  "share_of_youth_not_in_education_employment_or_training_364040e1" DOUBLE  -- Share Of Youth Not In Education, Employment Or Training, Male (% Of Male Youth Population),
  "unemployment_youth_female_of_female_labor_force_ages_1_e70a053e" DOUBLE  -- Unemployment, Youth Female (% Of Female Labor Force Ages 15-24) (national Estimate),
  "labor_force_participation_rate_female_of_female_popula_65e5cd69" DOUBLE  -- Labor Force Participation Rate, Female (% Of Female Population Ages 15+) (national Estimate),
  "children_in_employment_total_of_children_ages_7_14" DOUBLE  -- Children In Employment, Total (% Of Children Ages 7-14),
  "employment_in_services_male_of_male_employment_modeled_cfb36c87" DOUBLE  -- Employment In Services, Male (% Of Male Employment) (modeled ILO Estimate),
  "contributing_family_workers_male_of_male_employment_mo_001e135f" DOUBLE  -- Contributing Family Workers, Male (% Of Male Employment) (modeled ILO Estimate),
  "employment_to_population_ratio_15_female_national_estimate" DOUBLE  -- Employment To Population Ratio, 15+, Female (%) (national Estimate),
  "employment_in_agriculture_female_of_female_employment__2d13de2d" DOUBLE  -- Employment In Agriculture, Female (% Of Female Employment) (modeled ILO Estimate),
  "multidimensional_poverty_headcount_ratio_household_of__283a6623" VARCHAR  -- Multidimensional Poverty Headcount Ratio, Household (% Of Total Households),
  "income_share_held_by_third_20" DOUBLE  -- Income Share Held By Third 20%,
  "current_health_expenditure_per_capita_ppp_current_inte_a216693f" DOUBLE  -- Current Health Expenditure Per Capita, PPP (current International $),
  "increase_in_poverty_gap_at_1_90_2011_ppp_poverty_line__591e2c00" DOUBLE  -- Increase In Poverty Gap At $1.90 ($ 2011 PPP) Poverty Line Due To Out-of-pocket Health Care Expenditure (USD),
  "prevalence_of_stunting_height_for_age_modeled_estimate_fb1179ea" DOUBLE  -- Prevalence Of Stunting, Height For Age (modeled Estimate, % Of Children Under 5),
  "people_practicing_open_defecation_urban_of_urban_population" DOUBLE  -- People Practicing Open Defecation, Urban (% Of Urban Population),
  "people_using_at_least_basic_sanitation_services_urban__9cc9fa9d" DOUBLE  -- People Using At Least Basic Sanitation Services, Urban (% Of Urban Population),
  "number_of_maternal_deaths" DOUBLE,
  "incidence_of_hiv_all_per_1_000_uninfected_population" DOUBLE  -- Incidence Of HIV, All (per 1,000 Uninfected Population),
  "mortality_from_cvd_cancer_diabetes_or_crd_between_exac_4c902a34" DOUBLE  -- Mortality From CVD, Cancer, Diabetes Or CRD Between Exact Ages 30 And 70 (%),
  "number_of_infant_deaths" DOUBLE,
  "women_who_believe_a_husband_is_justified_in_beating_hi_148a2d54" DOUBLE  -- Women Who Believe A Husband Is Justified In Beating His Wife When She Neglects The Children (%),
  "government_expenditure_per_student_secondary_of_gdp_per_capita" DOUBLE  -- Government Expenditure Per Student, Secondary (% Of GDP Per Capita),
  "educational_attainment_at_least_master_s_or_equivalent_76c7d364" VARCHAR  -- Educational Attainment, At Least Master\u0027s Or Equivalent, Population 25+, Male (%) (cumulative),
  "trained_teachers_in_upper_secondary_education_male_of__c62ce629" DOUBLE  -- Trained Teachers In Upper Secondary Education, Male (% Of Male Teachers),
  "school_enrollment_secondary_gross" DOUBLE  -- School Enrollment, Secondary (% Gross),
  "educational_attainment_at_least_completed_post_seconda_b51bb031" DOUBLE  -- Educational Attainment, At Least Completed Post-secondary, Population 25+, Female (%) (cumulative),
  "adjusted_net_enrollment_rate_primary_of_primary_school_fe28adaf" DOUBLE  -- Adjusted Net Enrollment Rate, Primary (% Of Primary School Age Children),
  "over_age_students_primary_of_enrollment" DOUBLE  -- Over-age Students, Primary (% Of Enrollment),
  "primary_education_pupils_female" DOUBLE  -- Primary Education, Pupils (% Female),
  "pupil_teacher_ratio_preprimary" VARCHAR  -- Pupil-teacher Ratio, Preprimary,
  "coverage_of_social_insurance_programs_in_4th_quintile__b5c4efc1" DOUBLE  -- Coverage Of Social Insurance Programs In 4th Quintile (% Of Population),
  "coverage_of_unemployment_benefits_and_almp_in_4th_quin_dd692fb5" DOUBLE  -- Coverage Of Unemployment Benefits And ALMP In 4th Quintile (% Of Population),
  "net_secondary_income_net_current_transfers_from_abroad_ee88ecb8" DOUBLE  -- Net Secondary Income (Net Current Transfers From Abroad) (constant LCU),
  "gni_per_capita_growth_annual" DOUBLE  -- GNI Per Capita Growth (annual %)
);