Indian School Education Statistics
Statistics for Indian Schools, includes GER, Water facility, Electricity, DR,etc
@kaggle.vidyapb_indian_school_education_statistics
Statistics for Indian Schools, includes GER, Water facility, Electricity, DR,etc
@kaggle.vidyapb_indian_school_education_statistics
CREATE TABLE percentage_of_schools_with_water_facility_2013_2016 (
"state_ut" VARCHAR,
"year" VARCHAR,
"primary_only" DOUBLE,
"primary_with_u_primary" DOUBLE,
"primary_with_u_primary_sec_hrsec" DOUBLE,
"u_primary_only" DOUBLE,
"u_primary_with_sec_hrsec" DOUBLE,
"primary_with_u_primary_sec" DOUBLE,
"u_primary_with_sec" DOUBLE,
"sec_only" DOUBLE,
"sec_with_hrsec" DOUBLE,
"hrsec_only" DOUBLE,
"all_schools" DOUBLE
);
CREATE TABLE percentage_of_schools_with_comps_2013_2016 (
"state_ut" VARCHAR,
"year" VARCHAR,
"primary_only" DOUBLE,
"primary_with_u_primary" DOUBLE,
"primary_with_u_primary_sec_hrsec" DOUBLE,
"u_primary_only" DOUBLE,
"u_primary_with_sec_hrsec" DOUBLE,
"primary_with_u_primary_sec" DOUBLE,
"u_primary_with_sec" DOUBLE,
"sec_only" DOUBLE,
"sec_with_hrsec" DOUBLE,
"hrsec_only" DOUBLE,
"all_schools" DOUBLE
);
CREATE TABLE schools_with_boys_toilet_2013_2016 (
"state_ut" VARCHAR,
"year" VARCHAR,
"primary_only" DOUBLE,
"primary_with_u_primary" DOUBLE,
"primary_with_u_primary_sec_hrsec" DOUBLE,
"u_primary_only" DOUBLE,
"u_primary_with_sec_hrsec" DOUBLE,
"primary_with_u_primary_sec" DOUBLE,
"u_primary_with_sec" DOUBLE,
"sec_only" DOUBLE,
"sec_with_hrsec" DOUBLE,
"hrsec_only" DOUBLE,
"all_schools" DOUBLE
);
CREATE TABLE schools_with_girls_toilet_2013_2016 (
"state_ut" VARCHAR,
"year" VARCHAR,
"primary_only" DOUBLE,
"primary_with_u_primary" DOUBLE,
"primary_with_u_primary_sec_hrsec" DOUBLE,
"u_primary_only" DOUBLE,
"u_primary_with_sec_hrsec" DOUBLE,
"primary_with_u_primary_sec" DOUBLE,
"u_primary_with_sec" DOUBLE,
"sec_only" DOUBLE,
"sec_with_hrsec" DOUBLE,
"hrsec_only" DOUBLE,
"all_schools" DOUBLE
);
CREATE TABLE percentage_of_schools_with_electricity_2013_2016 (
"state_ut" VARCHAR,
"year" VARCHAR,
"primary_only" DOUBLE,
"primary_with_u_primary" DOUBLE,
"primary_with_u_primary_sec_hrsec" DOUBLE,
"u_primary_only" DOUBLE,
"u_primary_with_sec_hrsec" DOUBLE,
"primary_with_u_primary_sec" DOUBLE,
"u_primary_with_sec" DOUBLE,
"sec_only" DOUBLE,
"sec_with_hrsec" DOUBLE,
"hrsec_only" DOUBLE,
"all_schools" DOUBLE
);
CREATE TABLE dropout_ratio_2012_2015 (
"state_ut" VARCHAR,
"year" VARCHAR,
"primary_boys" VARCHAR,
"primary_girls" VARCHAR,
"primary_total" VARCHAR,
"upper_primary_boys" VARCHAR,
"upper_primary_girls" VARCHAR,
"upper_primary_total" VARCHAR,
"secondary_boys" VARCHAR,
"secondary_girls" VARCHAR,
"secondary_total" VARCHAR,
"hrsecondary_boys" VARCHAR,
"hrsecondary_girls" VARCHAR,
"hrsecondary_total" VARCHAR
);
CREATE TABLE gross_enrollment_ratio_2013_2016 (
"state_ut" VARCHAR,
"year" VARCHAR,
"primary_boys" DOUBLE,
"primary_girls" DOUBLE,
"primary_total" DOUBLE,
"upper_primary_boys" DOUBLE,
"upper_primary_girls" DOUBLE,
"upper_primary_total" DOUBLE,
"secondary_boys" DOUBLE,
"secondary_girls" DOUBLE,
"secondary_total" DOUBLE,
"higher_secondary_boys" VARCHAR,
"higher_secondary_girls" VARCHAR,
"higher_secondary_total" VARCHAR
);
Anyone who has the link will be able to view this.