Education In India

District and state-wise primary & secondary school education data, 2015-16

@kaggle.rajanand_education_in_india

Table List

6 tables(3.19 MB)

N 2015–16 Districtwise

N 2015–16 Districtwise Metadata

N 2015–16 Statewise Elementary

N 2015–16 Statewise Elementary Metadata

N 2015–16 Statewise Secondary

N 2015–16 Statewise Secondary Metadata

N 2015–16 Statewise Secondary

@kaggle.rajanand_education_in_india.n_2015_16_statewise_secondary

516.27 KB
36 rows
630 columns
Only the first 100 columns are shown

ac_year Ac Year	statcd Statcd	statname Statname	area_sqkm Area Sqkm	tot_population Tot Population	urban_population Urban Population	grwoth_rate Grwoth Rate	sexratio Sexratio	sc_population Sc Population	st_population St Population	literacy_rate Literacy Rate	male_literacy_rate Male Literacy Rate	female_literacy_rate Female Literacy Rate	distcd Distcd	blkcd Blkcd	villages Villages	clusters Clusters	schools Schools	sch_1 Sch 1	sch_2 Sch 2	sch_3 Sch 3	sch_4 Sch 4	sch_5 Sch 5	sch_6 Sch 6	sch_7 Sch 7	sch_r_1 Sch R 1	sch_r_2 Sch R 2	sch_r_3 Sch R 3	sch_r_4 Sch R 4	sch_r_5 Sch R 5	sch_r_6 Sch R 6	sch_r_7 Sch R 7	sch_u_1 Sch U 1	sch_u_2 Sch U 2	sch_u_3 Sch U 3	sch_u_4 Sch U 4	sch_u_5 Sch U 5	sch_u_6 Sch U 6	sch_u_7 Sch U 7	enr_1 Enr 1	enr_2 Enr 2	enr_3 Enr 3	enr_4 Enr 4	enr_5 Enr 5	enr_6 Enr 6	enr_7 Enr 7	enr_all Enr All	enr_r_1 Enr R 1	enr_r_2 Enr R 2	enr_r_3 Enr R 3	enr_r_4 Enr R 4	enr_r_5 Enr R 5	enr_r_6 Enr R 6	enr_r_7 Enr R 7	enr_r_all Enr R All	enr_u_1 Enr U 1	enr_u_2 Enr U 2	enr_u_3 Enr U 3	enr_u_4 Enr U 4	enr_u_5 Enr U 5	enr_u_6 Enr U 6	enr_u_7 Enr U 7	enr_u_all Enr U All	tch_1 Tch 1	tch_2 Tch 2	tch_3 Tch 3	tch_4 Tch 4	tch_5 Tch 5	tch_6 Tch 6	tch_7 Tch 7	tch_all Tch All	tch_r_1 Tch R 1	tch_r_2 Tch R 2	tch_r_3 Tch R 3	tch_r_4 Tch R 4	tch_r_5 Tch R 5	tch_r_6 Tch R 6	tch_r_7 Tch R 7	tch_r_all Tch R All	tch_u_1 Tch U 1	tch_u_2 Tch U 2	tch_u_3 Tch U 3	tch_u_4 Tch U 4	tch_u_5 Tch U 5	tch_u_6 Tch U 6	tch_u_7 Tch U 7	tch_u_all Tch U All	sing_cls_sch_1 Sing Cls Sch 1	sing_cls_sch_2 Sing Cls Sch 2	sing_cls_sch_3 Sing Cls Sch 3	sing_cls_sch_4 Sing Cls Sch 4	sing_cls_sch_5 Sing Cls Sch 5	sing_cls_sch_6 Sing Cls Sch 6	sing_cls_sch_7 Sing Cls Sch 7	sing_cls_sch_all Sing Cls Sch All	sing_tch_sch_1 Sing Tch Sch 1	sing_tch_sch_2 Sing Tch Sch 2	sing_tch_sch_3 Sing Tch Sch 3	sing_tch_sch_4 Sing Tch Sch 4	sing_tch_sch_5 Sing Tch Sch 5
2015-16	1	Jammu And Kashmir	222236	12548.93	20.05	23.71	883	7.4	11.9	68.74	78.26	58.01	22	201	7263	1628	4202	486	95	2693	414	34	478	2	264	90	2012	376	30	346		222	5	681	38	4	132	2	116698	27584	165991	38229	3669	231066	1729	584967	56114	25939	123808	35258	3265	141880		386265	60584	1645	42183	2971	404	89186	1729	198702	4864	1418	11828	2656	384	10073	48	31275	2351	1239	8303	2363	335	6366		20961	2513	179	3525	293	49	3707	48	10314			67					67
2015-16	2	Himachal Pradesh	55673	6856.51	8.69	12.81	974	25.2	5.7	83.78	90.83	76.6	12	124	10120	2243	3782	565	1634	684	884	2	4	9	418	1543	565	869	2	1	6	147	91	119	15		3	3	84525	336705	22783	36192	27	879	1383	482494	48611	297232	17724	35510	27	43	996	400143	35914	39473	5059	682		836	387	82351	5061	20160	2327	2836	14	53	93	30545	3250	18193	1838	2769	14	4	65	26134	1811	1967	489	67		49	28	4411		13	4	96				113
2015-16	3	Punjab	50362	27704.24	29.82	13.73	893	31.9		76.68	81.48	71.34	22	146	13195	1782	9171	2593	1754	2743	1869	6	63	143	1323	1390	1353	1722	4	38	57	1270	364	1390	147	2	25	86	613610	602297	134929	174839	238	19673	33374	1578960	243248	389398	60338	156559	187	12751	8533	871014	370362	212899	74591	18280	51	6922	24841	707946	30788	25738	10644	11276	19	900	1714	81117	13533	17954	5184	10002	13	588	573	47858	17255	7784	5460	1274	6	312	1141	33259		10	34	88				132	2	1		8	1
2015-16	4	Chandigarh	114	1054.69	76.66	17.1	818	18.9		86.43	90.54	81.38	1	20	84	20	160	85	5	70					9		5					76	5	65					61622	4018	14520					80160	4691		1475					6166	56931	4018	13045					73994	2688	206	1057					3951	236		93					329	2452	206	964					3622			1					1
2015-16	5	Uttarakhand	53483	10116.75	21.54	19.17	963	18.8	2.9	79.63	88.33	70.7	13	95	11989	995	3512	487	1600	164	895	235	116	15	274	1399	105	855	216	90	9	213	199	59	40	19	26	6	179781	410036	13810	52078	14002	25536	2051	697294	91695	326759	8848	48429	12111	19265	1104	508211	88086	81877	4962	3649	1891	6271	947	187683	4114	22750	589	5393	1251	1034	130	35391	2309	19819	354	5186	1159	841	69	29824	1805	2900	235	207	92	193	61	5536		8	2	25	8	3		46	2	1	1	2	14
2015-16	6	Haryana	44212	25353.08	24.12	19.9	877	20.2		76.64	85.38	66.77	21	126	7438	1523	7663	2329	1924	1926	1437		46	1	1364	1626	1171	1326		41		965	298	755	111		5	1	677656	521186	147058	119727		8665	753	1475045	321769	365802	86495	107022		7409		888497	355887	155384	60563	12705		1256	753	586548	29494	34368	9517	11530		470	18	85423	15493	26828	5750	10427		403		58907	14001	7540	3767	1103		67	18	26516	1	6	20	17		1		45	2	1		5
2015-16	7	Delhi	1483	16753.24	77.03	20.96	866	16.8		86.34	91.03	80.93	9	69	1201	69	2061	1135	545	260	117		3	1	30	26	10	4				1105	519	250	113		3	1	744072	386687	34136	41786		1441	29	1208151	13594	7187	649	408				21838	730478	379500	33487	41378		1441	29	1186313	30433	13744	1616	1418		92	2	47316	571	361	44	24				1000	29862	13383	1572	1394		92	2	46316
2015-16	8	Rajasthan	342239	68621.01	19.26	21.44	926	17.8	13.5	67.06	80.51	52.66	33	302	41441	10594	28195	15297	1176	10827	398	12	485		11965	691	7758	222	6	210		3332	485	3069	176	6	275		2882268	308553	581759	29552	838	185350		3988574	1954163	137468	426701	16039	561	61408		2596594	928105	171085	155058	13513	277	123942		1391980	101479	9844	41631	1889	70	5960		160904	72810	4930	30096	1025	40	1989		110902	28669	4914	11535	864	30	3971		50002	142	5	375	4				526	5	3	11	2
2015-16	9	Uttar Pradesh	240928	199581.48	17.31	20.09	908	20.7	0.6	69.72	79.24	59.26	75	971	98470	9423	24569	2595	8123	959	2842	4831	5205	14	1511	6615	620	2534	4264	4273	11	1084	1508	339	308	566	931	3	1444256	5406311	149719	563587	914387	3480782	6065	11981220	869267	4371297	104478	519028	811038	3034076	4763	9725972	574989	1035014	45241	44559	102823	446654	1302	2254670	20336	74845	3328	11895	22634	41990	85	175352	10303	55636	2002	10495	19668	33833	53	132193	10033	19209	1326	1400	2962	8151	32	43149		2	2	6	1			11	64	275	27	159	872
2015-16	10	Bihar	94163	103804.64	8.36	25.07	916	15.9	1.3	63.82	73.39	53.33	38	537	40779	5633	7627	938	92	2281	246	1174	2530	366	767	60	2115	189	1022	2049	238	171	32	166	57	152	481	128	226581	36288	383506	40739	632920	2769323	568495	4657852	157660	20301	361657	32513	552044	2143958	377620	3645753	68921	15987	21849	8226	80876	625365	190875	1012099	2532	893	4722	1194	10436	34139	7778	66406	1581	560	4313	854	9071	24878	4860	50352	951	333	409	340	1365	9261	2918	16054	7	1	28	3	2	2	1	44	4		3	4	9


CREATE TABLE n_2015_16_statewise_secondary (
  "ac_year" VARCHAR,
  "statcd" BIGINT,
  "statname" VARCHAR,
  "area_sqkm" DOUBLE,
  "tot_population" DOUBLE,
  "urban_population" DOUBLE,
  "grwoth_rate" DOUBLE,
  "sexratio" DOUBLE,
  "sc_population" DOUBLE,
  "st_population" DOUBLE,
  "literacy_rate" DOUBLE,
  "male_literacy_rate" DOUBLE,
  "female_literacy_rate" DOUBLE,
  "distcd" BIGINT,
  "blkcd" BIGINT,
  "villages" BIGINT,
  "clusters" BIGINT,
  "schools" BIGINT,
  "sch_1" BIGINT,
  "sch_2" BIGINT,
  "sch_3" BIGINT,
  "sch_4" BIGINT,
  "sch_5" BIGINT,
  "sch_6" BIGINT,
  "sch_7" BIGINT,
  "sch_r_1" BIGINT,
  "sch_r_2" BIGINT,
  "sch_r_3" BIGINT,
  "sch_r_4" BIGINT,
  "sch_r_5" BIGINT,
  "sch_r_6" BIGINT,
  "sch_r_7" BIGINT,
  "sch_u_1" BIGINT,
  "sch_u_2" BIGINT,
  "sch_u_3" BIGINT,
  "sch_u_4" BIGINT,
  "sch_u_5" BIGINT,
  "sch_u_6" BIGINT,
  "sch_u_7" BIGINT,
  "enr_1" BIGINT,
  "enr_2" BIGINT,
  "enr_3" BIGINT,
  "enr_4" BIGINT,
  "enr_5" BIGINT,
  "enr_6" BIGINT,
  "enr_7" BIGINT,
  "enr_all" BIGINT,
  "enr_r_1" BIGINT,
  "enr_r_2" BIGINT,
  "enr_r_3" BIGINT,
  "enr_r_4" BIGINT,
  "enr_r_5" BIGINT,
  "enr_r_6" BIGINT,
  "enr_r_7" BIGINT,
  "enr_r_all" BIGINT,
  "enr_u_1" BIGINT,
  "enr_u_2" BIGINT,
  "enr_u_3" BIGINT,
  "enr_u_4" BIGINT,
  "enr_u_5" BIGINT,
  "enr_u_6" BIGINT,
  "enr_u_7" BIGINT,
  "enr_u_all" BIGINT,
  "tch_1" BIGINT,
  "tch_2" BIGINT,
  "tch_3" BIGINT,
  "tch_4" BIGINT,
  "tch_5" BIGINT,
  "tch_6" BIGINT,
  "tch_7" BIGINT,
  "tch_all" BIGINT,
  "tch_r_1" BIGINT,
  "tch_r_2" BIGINT,
  "tch_r_3" BIGINT,
  "tch_r_4" BIGINT,
  "tch_r_5" BIGINT,
  "tch_r_6" BIGINT,
  "tch_r_7" BIGINT,
  "tch_r_all" BIGINT,
  "tch_u_1" BIGINT,
  "tch_u_2" BIGINT,
  "tch_u_3" BIGINT,
  "tch_u_4" BIGINT,
  "tch_u_5" BIGINT,
  "tch_u_6" BIGINT,
  "tch_u_7" BIGINT,
  "tch_u_all" BIGINT,
  "sing_cls_sch_1" DOUBLE,
  "sing_cls_sch_2" DOUBLE,
  "sing_cls_sch_3" DOUBLE,
  "sing_cls_sch_4" DOUBLE,
  "sing_cls_sch_5" DOUBLE,
  "sing_cls_sch_6" DOUBLE,
  "sing_cls_sch_7" DOUBLE,
  "sing_cls_sch_all" DOUBLE,
  "sing_tch_sch_1" DOUBLE,
  "sing_tch_sch_2" DOUBLE,
  "sing_tch_sch_3" DOUBLE,
  "sing_tch_sch_4" DOUBLE,
  "sing_tch_sch_5" DOUBLE
);