Education In Figures 2017 (At A Glance)

CREATE TABLE campus_wise_student_enrollment_of_higher_education_by__9bd022da (
  "types_of_campus" VARCHAR,
  "female" BIGINT,
  "male" BIGINT,
  "total" BIGINT
);

CREATE TABLE examination_results_of_grade_11_and_12_by_province_reg_8ef91a2a (
  "province" VARCHAR,
  "grade_11_2073" VARCHAR  -- Grade 11 (2073),
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "grade_12_2074" VARCHAR  -- Grade 12(2074},
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14
);

CREATE TABLE examination_results_of_grade_11and_12_by_province_regu_d55d5db9 (
  "province" VARCHAR,
  "grade_11_2072" VARCHAR  -- Grade 11(2072),
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "grade_12_2073" VARCHAR  -- Grade 12(2073),
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14
);

CREATE TABLE faculty_wise_student_enrollment_of_higher_education_in_2074_bs (
  "sn" DOUBLE,
  "faculties" VARCHAR,
  "female" BIGINT,
  "male" BIGINT,
  "total" BIGINT
);

CREATE TABLE faculty_wise_total_student_enrollment_in_higher_educat_f98fc1cc (
  "description" VARCHAR,
  "agriculture" BIGINT,
  "asvsf" BIGINT,
  "buddhism" BIGINT,
  "education" BIGINT,
  "engineering" BIGINT,
  "forestry" BIGINT,
  "hss" BIGINT,
  "law" DOUBLE,
  "management" BIGINT,
  "medicine" BIGINT,
  "science_technology" BIGINT,
  "sanskrit" BIGINT,
  "total" BIGINT
);

CREATE TABLE grade_wise_student_enrollment_of_school_education_in_2074_bs (
  "grade" VARCHAR,
  "gis" BIGINT,
  "boys" BIGINT,
  "total" BIGINT,
  "share_of_girl_sby_grades" DOUBLE,
  "grade_wise_share_in_total_enrollment_by_levels" DOUBLE
);

CREATE TABLE level_wise_student_enrollment_of_higher_education_in_2074_bs (
  "level" VARCHAR,
  "male" BIGINT,
  "male_ce61de" BIGINT  -- Male,
  "total" BIGINT
);

CREATE TABLE literacy_rate_of_5_years_and_above_by_province_in_2011ad (
  "desuiption" VARCHAR,
  "province_1" DOUBLE,
  "province_2" DOUBLE,
  "province_3" DOUBLE,
  "gandaki" DOUBLE,
  "province_5" DOUBLE,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "kamaii" DOUBLE,
  "province_7" DOUBLE,
  "total" DOUBLE
);

CREATE TABLE province_wise_literacy_rate_of_5_years_and_above_popul_668a840c (
  "province" VARCHAR,
  "sex" VARCHAR,
  "population_aged_syears_above" VARCHAR  -- Population Aged Syears \u0026 Above,
  "population_who_are_can_read_write" VARCHAR  -- Population Who Are Can Read \u0026 Write,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "literacy_rate" DOUBLE
);

CREATE TABLE province_wise_literacy_rate_of_nepal_in_2011ad (
  "sn" DOUBLE,
  "province" VARCHAR,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "n__16yrsand_upto_24" VARCHAR  -- (16Yrsand Upto 24),
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "n__16yrsand_abov" VARCHAR  -- (16Yrsand AboV\u003c!),
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10
);

CREATE TABLE province_wise_student_enrollment_of_higher_education_b_883d6733 (
  "province" VARCHAR,
  "bachelor" BIGINT,
  "pgd" BIGINT,
  "master" VARCHAR,
  "m_phil" BIGINT,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "ph_d" BIGINT,
  "total" BIGINT
);

CREATE TABLE province_wise_students_enrollment_of_higher_education__6caedb3a (
  "province" VARCHAR,
  "constituent" VARCHAR,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "community" VARCHAR,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "private" VARCHAR,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "total" VARCHAR
);

CREATE TABLE province_wise_totalstudent_enrollment_by_levelin_2074_bs (
  "educational_level" VARCHAR,
  "nepal" BIGINT,
  "province_l" DOUBLE,
  "province_2" VARCHAR,
  "province_3" BIGINT,
  "gandaki" VARCHAR,
  "province_5" BIGINT,
  "karnali" BIGINT,
  "province_7" DOUBLE
);

CREATE TABLE sex_wise_student_enrollment_of_higher_education_by_pro_ed6ea217 (
  "province" VARCHAR,
  "female" BIGINT,
  "male" BIGINT,
  "total" DOUBLE
);

CREATE TABLE share_percentage_of_total_student_enrollment_in_school_ef38fdbd (
  "province" VARCHAR,
  "basic_l_s" VARCHAR  -- Basic (l�S),
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" DOUBLE  -- Unnamed: 5,
  "basic_6_ll" VARCHAR  -- Basic (6-ll),
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "secondary_9_10" VARCHAR  -- Secondary (9-10),
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "secondary_11_12" VARCHAR  -- Secondary (11–12),
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14
);

CREATE TABLE total_number_of_ecd_ppc_facilitators_in_all_types_of_e_34e10541 (
  "province" VARCHAR,
  "total" VARCHAR,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3
);

CREATE TABLE total_number_of_faculties_of_higher_education_by_provi_9d856838 (
  "province" VARCHAR,
  "science_technology" BIGINT  -- Science \u0026Technology,
  "buddhism" BIGINT,
  "mgmt" BIGINT,
  "hss" BIGINT,
  "edu" BIGINT,
  "engi" BIGINT,
  "medicine" BIGINT,
  "law" BIGINT,
  "sanskrit" BIGINT,
  "avf" BIGINT,
  "agriculture" BIGINT,
  "forestry" BIGINT,
  "total" BIGINT
);

CREATE TABLE total_number_of_schools_students_and_teachers_within_s_cc3dd402 (
  "province" VARCHAR,
  "total_no_of_schools_1_12" VARCHAR  -- Total No Of Schools (1-12),
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "total_no_of_students_1_12" VARCHAR  -- Total No Of Students (1-12),
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "total_no_of_teachers_primary_to_secondary_level_1_10" VARCHAR  -- Total No Of Teachers Primary To Secondary Level (1-10).,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10
);

CREATE TABLE total_number_of_teacher_at_primary_to_higher_secondary_1687445e (
  "province" VARCHAR,
  "total_1_12" VARCHAR  -- Total (1-12),
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3
);

CREATE TABLE total_number_of_teacher_at_primary_to_higher_secondary_7b090cb6 (
  "province" VARCHAR,
  "total_1_12" VARCHAR  -- Total (1-12),
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3
);

CREATE TABLE total_number_of_teacher_in_all_types_of_schools_by_pro_a4f47d51 (
  "province" VARCHAR,
  "total_1_12" VARCHAR  -- Total(1-12),
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "basic_1_5" VARCHAR  -- Basic (1-5),
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "basic_8" VARCHAR  -- Basic (\u0026-8),
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "secondary_9_10" VARCHAR  -- Secondary (9-10),
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "secondary_11_12" VARCHAR  -- Secondary (11-12),
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16
);

CREATE TABLE total_number_of_universities_and_campuses_i_colleges_b_a2e5e6ff (
  "sn" DOUBLE,
  "university" VARCHAR,
  "province_1" DOUBLE,
  "province_2" DOUBLE,
  "province_3" DOUBLE,
  "gandaki" DOUBLE,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "province_s" DOUBLE,
  "karnali" DOUBLE,
  "province_7" DOUBLE,
  "total" DOUBLE
);

CREATE TABLE university_wise_student_enrollment_of_higher_education_07c8dcd9 (
  "sn" DOUBLE,
  "university" VARCHAR,
  "male" BIGINT,
  "female" BIGINT,
  "total" BIGINT
);

CREATE TABLE university_wise_student_enrollment_of_higher_education_2a88c414 (
  "sn" DOUBLE,
  "university" VARCHAR,
  "bachelor" BIGINT,
  "pgd" BIGINT,
  "master" BIGINT,
  "m_phil" BIGINT,
  "ph_d" BIGINT  -- Ph. D,
  "total" DOUBLE
);