schools

Data source: Big Local News · About: Big Local

Custom SQL query returning 101 rows (hide)

select rowid, state, county, county_state_id, admin_level, district_nces_id, district_state_id, district_state_type, district, school_nces_id, school_state_id, school, school_state_type, ccd_school_type, ccd_charter_school, ccd_school_lvl, ccd_school_low_grade, ccd_school_high_grade, year, term, grade, white, black, hispanic, native_american, native_american_alaskan_native, asian, native_hawaiian, asian_pacific_islander, native_hawaiian_pacific_islander, pacific_islander, multiracial, unknown_race, male, female, non_binary, unknown_gender, ell, ell_percent, homeless, homeless_percent, low_income, free_and_reduced, free_and_reduced_percent, disability, section_504, total, white_int, black_int, hispanic_int, native_american_int, native_american_alaskan_native_int, asian_int, native_hawaiian_int, asian_pacific_islander_int, native_hawaiian_pacific_islander_int, pacific_islander_int, multiracial_int, unknown_race_int, male_int, female_int, non_binary_int, unknown_gender_int, ell_int, homeless_int, low_income_int, free_and_reduced_int, disability_int, section_504_int, total_int from enrollments where "grade" = :p0 and "state" = :p1 order by female_int limit 101

Query parameters

This data as json, CSV

rowid	state	admin_level	district_nces_id	district_state_id	district	school_nces_id	school_state_id	school	ccd_school_type	ccd_charter_school	ccd_school_lvl	ccd_school_low_grade	ccd_school_high_grade	year	grade	male	female	total	male_int	female_int	total_int
1160396	IN	school	1801290	750	Carroll Consolidated Sch Corp	180129002103	629	Carroll Elementary	Regular School	No	1.0	PK	06	2015	pre_kindergarten	1.0	0.0	1.0	1	0	1
1161458	IN	school	1803960	2120	Greater Jasper Con Schs	180396000684	1569	Ireland Elementary School	Regular School	No	1.0	PK	05	2015	pre_kindergarten	3.0	0.0	3.0	3	0	3
1162611	IN	school	1801200	3060	Carmel Clay Schools	180120000196	2510	College Wood Elementary Sch	Regular School	No	1.0	PK	05	2015	pre_kindergarten	1.0	0.0	1.0	1	0	1
1162665	IN	school	1801200	3060	Carmel Clay Schools	180120001405	2522	Towne Meadow Elementary Sch	Regular School	No	1.0	PK	05	2015	pre_kindergarten	1.0	0.0	1.0	1	0	1
1162726	IN	school	1807650	3070	Noblesville Schools	180765002340	2538	Hazel Dell Elementary School	Regular School	No	1.0	PK	05	2015	pre_kindergarten	13.0	0.0	13.0	13	0	13
1162887	IN	school	1800690	3180	North Harrison Com School Corp	180069000142	2621	Morgan Elementary School	Regular School	No	1.0	PK	05	2015	pre_kindergarten	1.0	0.0	1.0	1	0	1
1162973	IN	school	1808100	3295	North West Hendricks Schools	180810001385	2685	North Salem Elementary School	Regular School	No	1.0	PK	05	2015	pre_kindergarten	1.0	0.0	1.0	1	0	1
1164268	IN	school	1813230	4455	Whitko Community School Corp	181323002087	9173	South Whitley Elementary Sch	Regular School	No	1.0	PK	05	2015	pre_kindergarten	2.0	0.0	2.0	2	0	2
1164513	IN	school	1805450	4615	Lake Central School Corp	180545002143	4349	Homan Elementary School	Regular School	No	1.0	PK	04	2015	pre_kindergarten	7.0	0.0	7.0	7	0	7
1165138	IN	school	1807560	4805	New Prairie United School Corp	180756001301	4693	Rolling Prairie Elem Sch	Regular School	No	1.0	PK	05	2015	pre_kindergarten	3.0	0.0	3.0	3	0	3
1165868	IN	school	1808820	5340	Perry Township Schools	180882001459	5333	Glenns Valley Elem Sch	Regular School	No	1.0	PK	05	2015	pre_kindergarten	1.0	0.0	1.0	1	0	1
1165977	IN	school	1808910	5350	M S D Pike Township	180891001485	5359	Eastbrook Elementary School	Regular School	No	1.0	PK	05	2015	pre_kindergarten	1.0	0.0	1.0	1	0	1
1168778	IN	school	1810290	7205	South Bend Community Sch Corp	181029001651	7435	Darden Primary Center	Regular School	No	1.0	PK	04	2015	pre_kindergarten	8.0	0.0	8.0	8	0	8
1169105	IN	school	1810140	7365	Shelbyville Central Schools	181014002496	7671	Especially Kidz Health & Rehab Cnt	Regular School	No	4.0	PK	12	2015	pre_kindergarten	2.0	0.0	2.0	2	0	2
1169913	IN	school	1810590	8020	South Vermillion Com Sch Corp	181059001735	8409	Central Elementary School	Regular School	No	1.0	PK	05	2015	pre_kindergarten	1.0	0.0	1.0	1	0	1
1169921	IN	school	1810590	8020	South Vermillion Com Sch Corp	181059001736	8431	Ernie Pyle Elementary School	Regular School	No	1.0	PK	05	2015	pre_kindergarten	5.0	0.0	5.0	5	0	5
1281900	IN	school	1809370	940	West Clark Community Schools	180937001530	767	Henryville Elementary School	Regular School	No	1.0	PK	06	2016	pre_kindergarten	1.0	0.0	1.0	1	0	1
1281934	IN	school	1809370	940	West Clark Community Schools	180937002469	818	Silver Creek Primary School	Regular School	No	1.0	PK	01	2016	pre_kindergarten	2.0	0.0	2.0	2	0	2
1282181	IN	school	1802130	1150	Clinton Central School Corp	180213000256	961	Clinton Central Elementary School	Regular School	No	1.0	PK	06	2016	pre_kindergarten	2.0	0.0	2.0	2	0	2
1283530	IN	school	1802940	2725	East Gibson School Corporation	180294000382	2201	Francisco Elementary School	Regular School	No	1.0	PK	06	2016	pre_kindergarten	1.0	0.0	1.0	1	0	1
1284026	IN	school	1801200	3060	Carmel Clay Schools	180120000196	2510	College Wood Elementary School	Regular School	No	1.0	PK	05	2016	pre_kindergarten	1.0	0.0	1.0	1	0	1
1285458	IN	school	1807830	4315	North Knox School Corp	180783001332	3521	North Knox Primary School	Regular School	No	1.0	PK	02	2016	pre_kindergarten	1.0	0.0	1.0	1	0	1
1286533	IN	school	1807560	4805	New Prairie United School Corp	180756001301	4693	Rolling Prairie Elem Sch	Regular School	No	1.0	PK	05	2016	pre_kindergarten	2.0	0.0	2.0	2	0	2
1286545	IN	school	1807560	4805	New Prairie United School Corp	180756001300	7349	Olive Township Elem Sch	Regular School	No	1.0	PK	05	2016	pre_kindergarten	1.0	0.0	1.0	1	0	1
1286662	IN	school	1802190	4940	South Central Com School Corp	180219000262	4734	South Central Elementary School	Regular School	No	1.0	PK	06	2016	pre_kindergarten	2.0	0.0	2.0	2	0	2
1286747	IN	school	1805580	4945	LaPorte Community School Corp	180558001011	4773	Handley Elementary School	Regular School	No	1.0	PK	05	2016	pre_kindergarten	1.0	0.0	1.0	1	0	1
1289229	IN	school	1800118	6375	North Central Parke Comm Schl Corp	180011801857	6647	Turkey Run Elementary School	Regular School	No	1.0	PK	06	2016	pre_kindergarten	1.0	0.0	1.0	1	0	1
1289806	IN	school	1801770	6825	Randolph Central School Corp	180177002191	7146	Deerfield Elementary School	Regular School	No	1.0	PK	05	2016	pre_kindergarten	3.0	0.0	3.0	3	0	3
1290772	IN	school	1811220	7775	Switzerland County School Corp	181122001808	7985	Jefferson-Craig Elementary School	Regular School	No	1.0	PK	06	2016	pre_kindergarten	3.0	0.0	3.0	3	0	3
1291328	IN	school	1810590	8020	South Vermillion Com Sch Corp	181059001741	8435	Van Duyn Elementary School	Regular School	No	1.0	PK	05	2016	pre_kindergarten	10.0	0.0	10.0	10	0	10
1291917	IN	school	1810770	8425	Southern Wells Com Schools	181077001764	9057	Southern Wells Elem Sch	Regular School	No	1.0	PK	06	2016	pre_kindergarten	1.0	0.0	1.0	1	0	1
1295176	IN	school	1803270	2305	Elkhart Community Schools	180327000436	1773	Mary Daly Elementary School	Regular School	No	Elementary	PK	06	2017	pre_kindergarten	1.0	0.0	1.0	1	0	1
1297383	IN	school	1801440	4205	Center Grove Community School Corp	180144002333	3444	Pleasant Grove Elementary School	Regular School	No	Elementary	PK	05	2017	pre_kindergarten	2.0	0.0	2.0	2	0	2
1297949	IN	school	1805450	4615	Lake Central School Corporation	180545002143	4349	Homan Elementary School	Regular School	No	Elementary	PK	04	2017	pre_kindergarten	10.0	0.0	10.0	10	0	10
1301142	IN	school	1810950	6195	Spencer-Owen Community Schools	181095001787	6605	Gosport Elementary School	Regular School	No	Elementary	PK	06	2017	pre_kindergarten	1.0	0.0	1.0	1	0	1
1303333	IN	school	1810590	8020	South Vermillion Com Sch Corp	181059001735	8409	Central Elementary School	Regular School	No	Elementary	PK	05	2017	pre_kindergarten	4.0	0.0	4.0	4	0	4
1303485	IN	school	1812090	8030	Vigo County School Corp	181209001910	8561	Meadows Elementary School	Regular School	No	Elementary	PK	05	2017	pre_kindergarten	1.0	0.0	1.0	1	0	1
1755418	IN	school	1803150	3480	Eastern Howard School Corporation	180315000412	2909	Eastern Elementary School	Regular School	No	Elementary	PK	07	2019	pre_kindergarten	10.0	0.0	10.0	10	0	10
1757481	IN	school	1810440	5255	South Madison Com Sch Corp	181044001676	5064	Maple Ridge Elementary School	Regular School	No	Elementary	PK	06	2019	pre_kindergarten	1.0	0.0	1.0	1	0	1
1758666	IN	school	1804770	5385	Indianapolis Public Schools	180477000858	5609	Jonathan Jennings School 109	Regular School	No	Elementary	PK	06	2019	pre_kindergarten	2.0	0.0	2.0	2	0	2
1759220	IN	school	1810450	5845	South Montgomery Com Sch Corp	181045001714	6233	Ladoga Elementary School	Regular School	No	Elementary	PK	05	2019	pre_kindergarten	1.0	0.0	1.0	1	0	1
1759307	IN	school	1806510	5925	M S D Martinsville Schools	180651001132	6309	Green Township Elementary School	Regular School	No	Elementary	PK	04	2019	pre_kindergarten	1.0	0.0	1.0	1	0	1
1759334	IN	school	1806510	5925	M S D Martinsville Schools	180651001129	6341	Centerton Elementary School	Regular School	No	Elementary	PK	04	2019	pre_kindergarten	1.0	0.0	1.0	1	0	1
1760132	IN	school	1807110	6620	Eastern Pulaski Community Sch Corp	180711001204	6994	Eastern Pulaski Elementary School	Regular School	No	Elementary	PK	05	2019	pre_kindergarten	4.0	0.0	4.0	4	0	4
1761015	IN	school	1810140	7365	Shelbyville Central Schools	181014002496	7671	Especially Kidz Health & Rehab Cnt	Regular School	No	Other	PK	12	2019	pre_kindergarten	4.0	0.0	4.0	4	0	4
1761732	IN	school	1803450	7995	Evansville Vanderburgh School Corp	180345000470	8317	Hebron Elementary School	Regular School	No	Elementary	PK	05	2019	pre_kindergarten	1.0	0.0	1.0	1	0	1
1762041	IN	school	1812090	8030	Vigo County School Corp	181209001916	8605	Sugar Grove Elementary School	Regular School	No	Elementary	PK	05	2019	pre_kindergarten	4.0	0.0	4.0	4	0	4
1762494	IN	school	1808220	8435	Northern Wells Community Schools	180822001411	9081	Ossian Elementary	Regular School	No	Elementary	PK	05	2019	pre_kindergarten	1.0	0.0	1.0	1	0	1
1762553	IN	school	1803810	8525	Frontier School Corporation	180381000604	9113	Frontier Elementary	Regular School	No	Elementary	PK	06	2019	pre_kindergarten	8.0	0.0	8.0	8	0	8
1789121	IN	school	1807320	1970	Muncie Community Schools	180732002153	1482	South View Elementary School	Regular School	No	Elementary	PK	05	2018	pre_kindergarten	4.0	0.0	4.0	4	0	4
1792079	IN	school	1813230	4455	Whitko Community School Corp	181323002087	9173	South Whitley Elementary School	Regular School	No	Elementary	PK	05	2018	pre_kindergarten	2.0	0.0	2.0	2	0	2
1792128	IN	school	1813110	4525	Westview School Corporation	181311001587	3704	Meadowview Elementary School	Regular School	No	Elementary	PK	06	2018	pre_kindergarten	11.0	0.0	11.0	11	0	11
1792232	IN	school	1809690	4600	Merrillville Community School Corp	180969001582	3821	Henry P Fieler Elementary School	Regular School	No	Elementary	PK	04	2018	pre_kindergarten	1.0	0.0	1.0	1	0	1
1797766	IN	school	1812090	8030	Vigo County School Corp	181209001914	8525	Rio Grande Elementary School	Regular School	No	Elementary	PK	05	2018	pre_kindergarten	1.0	0.0	1.0	1	0	1
1797839	IN	school	1812090	8030	Vigo County School Corp	181209001922	8609	West Vigo Elementary School	Regular School	No	Elementary	PK	05	2018	pre_kindergarten	1.0	0.0	1.0	1	0	1
1909902	IN	school	1810650	3005	Hamilton Southeastern Schools	181065001560	2471	Hoosier Road Elementary School	Regular School	No	Elementary	PK	04	2020	pre_kindergarten	1.0	0.0	1.0	1	0	1
1910198	IN	school	1807650	3070	Noblesville Schools	180765001311	2529	North Elementary School	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	2.0	0.0	2.0	2	0	2
1913598	IN	school	1812810	5375	M S D Wayne Township	181281002035	5257	McClelland Elementary School	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	1.0	0.0	1.0	1	0	1
1913616	IN	school	1812810	5375	M S D Wayne Township	181281002037	5265	Robey Elementary School	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	1.0	0.0	1.0	1	0	1
1913625	IN	school	1812810	5375	M S D Wayne Township	181281000238	5267	North Wayne Elementary School	Regular School	No	Elementary	PK	06	2020	pre_kindergarten	2.0	0.0	2.0	2	0	2
1914551	IN	school	1800630	5740	Monroe County Community Sch Corp	180063002613	6199	Hoosier Hills Childcare Center	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	6.0	0.0	6.0	6	0	6
1916423	IN	school	1810140	7365	Shelbyville Central Schools	181014002496	7671	Especially Kidz Health & Rehab Cnt	Regular School	No	Other	01	12	2020	pre_kindergarten	4.0	0.0	4.0	4	0	4
1917338	IN	school	1812090	8030	Vigo County School Corp	181209001899	8497	Sugar Creek Consolidated Elem Sch	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	1.0	0.0	1.0	1	0	1
1917416	IN	school	1812090	8030	Vigo County School Corp	181209002173	8543	Hoosier Prairie Elementary School	Regular School	No	Elementary	PK	05	2020	pre_kindergarten	1.0	0.0	1.0	1	0	1
1919417	IN	school	1803630	235	Fort Wayne Community Schools	180363000566	269	Washington Center Elementary Sch	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	8.0	0.0	8.0	8	0	8
1920903	IN	school	1803960	2120	Greater Jasper Consolidated Schs	180396000684	1569	Ireland Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	3.0	0.0	3.0	3	0	3
1921322	IN	school	1803510	2395	Fayette County School Corporation	180351000499	1897	Eastview Elementary School	Regular School	No	Elementary	PK	06	2021	pre_kindergarten	1.0	0.0	1.0	1	0	1
1921733	IN	school	1806390	2865	Marion Community Schools	180639001119	2405	Riverview Elementary School	Regular School	No	Elementary	PK	04	2021	pre_kindergarten	1.0	0.0	1.0	1	0	1
1922025	IN	school	1806480	3055	Sheridan Community Schools	180648001125	2465	Sheridan Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	5.0	0.0	5.0	5	0	5
1923290	IN	school	1805190	4015	Jennings County School Corporation	180519000924	3397	North Vernon Elementary School	Regular School	No	Elementary	PK	06	2021	pre_kindergarten	2.0	0.0	2.0	2	0	2
1923719	IN	school	1811370	4445	Tippecanoe Valley School Corp	181137001838	3603	Mentone Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	2.0	0.0	2.0	2	0	2
1925562	IN	school	1812810	5375	MSD Wayne Township	181281002042	5273	Westlake Elementary School	Regular School	No	Elementary	PK	06	2021	pre_kindergarten	1.0	0.0	1.0	1	0	1
1925666	IN	school	1804770	5385	Indianapolis Public Schools	180477000896	5515	Thomas D Gregg School 15	Regular School	No	Elementary	PK	06	2021	pre_kindergarten	1.0	0.0	1.0	1	0	1
1925732	IN	school	1804770	5385	Indianapolis Public Schools	180477000817	5546	Daniel Webster School 46	Regular School	No	Elementary	PK	08	2021	pre_kindergarten	1.0	0.0	1.0	1	0	1
1925761	IN	school	1804770	5385	Indianapolis Public Schools	180477000805	5554	Brookside School 54	Regular School	No	Elementary	PK	06	2021	pre_kindergarten	2.0	0.0	2.0	2	0	2
1925794	IN	school	1804770	5385	Indianapolis Public Schools	180477000841	5557	George W Julian School 57	Regular School	No	Elementary	PK	08	2021	pre_kindergarten	2.0	0.0	2.0	2	0	2
1925939	IN	school	1804770	5385	Indianapolis Public Schools	180477000811	5605	Charles Warren Fairbanks Sch 105	Regular School	No	Elementary	PK	06	2021	pre_kindergarten	1.0	0.0	1.0	1	0	1
1925983	IN	school	1804770	5385	Indianapolis Public Schools	180477001426	5619	George S Buck School 94	Regular School	No	Elementary	PK	06	2021	pre_kindergarten	3.0	0.0	3.0	3	0	3
1928356	IN	school	1810140	7365	Shelbyville Central Schools	181014002496	7671	Especially Kidz Health & Rehab Cnt	Regular School	No	Other	02	12	2021	pre_kindergarten	1.0	0.0	1.0	1	0	1
1929315	IN	school	1812090	8030	Vigo County School Corp	181209001904	8517	Farrington Grove Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	2.0	0.0	2.0	2	0	2
1929392	IN	school	1812090	8030	Vigo County School Corp	181209001916	8605	Sugar Grove Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten	1.0	0.0	1.0	1	0	1
1930295	IN	school	1800011	9320	Community Montessori Inc	180001101737	1536	Community Montessori	Regular School	Yes	Other	PK	12	2021	pre_kindergarten	3.0	0.0	3.0	3	0	3
1159942	IN	school	1803630	235	Fort Wayne Community Schools	180363000566	269	Washington Center Elem Sch	Regular School	No	1.0	PK	05	2015	pre_kindergarten	8.0	1.0	9.0	8	1	9
1160413	IN	school	1802700	755	Delphi Community School Corp	180270000328	641	Delphi Community Elementary School	Regular School	No	1.0	PK	05	2015	pre_kindergarten	6.0	1.0	7.0	6	1	7
1160535	IN	school	1809370	940	West Clark Community Schools	180937001539	815	William W Borden Elem Sch	Regular School	No	1.0	PK	06	2015	pre_kindergarten	5.0	1.0	6.0	5	1	6
1160987	IN	school	1811190	1560	Sunman-Dearborn Com Sch Corp	181119001805	7211	Sunman Elementary School	Regular School	No	1.0	PK	04	2015	pre_kindergarten	2.0	1.0	3.0	2	1	3
1161434	IN	school	1810870	2110	Southwest Dubois Co Sch Corp	181087001776	1529	Holland Elementary School	Regular School	No	1.0	PK	05	2015	pre_kindergarten	0.0	1.0	1.0	0	1	1
1162301	IN	school	1800600	2920	Bloomfield School District	180060000112	2417	Bloomfield Elementary School	Regular School	No	1.0	PK	06	2015	pre_kindergarten	2.0	1.0	3.0	2	1	3
1162653	IN	school	1801200	3060	Carmel Clay Schools	180120002101	2518	Forest Dale Elementary School	Regular School	No	1.0	PK	05	2015	pre_kindergarten	8.0	1.0	9.0	8	1	9
1163110	IN	school	1802550	3325	Danville Community School Corp	180255000306	2721	North Elementary School	Regular School	No	1.0	PK	05	2015	pre_kindergarten	11.0	1.0	12.0	11	1	12
1164280	IN	school	1809300	4515	Prairie Heights Com Sch Corp	180930001524	3686	Prairie Heights Elem Sch	Regular School	No	1.0	PK	04	2015	pre_kindergarten	1.0	1.0	2.0	1	1	2
1165150	IN	school	1807560	4805	New Prairie United School Corp	180756001300	7349	Olive Township Elem Sch	Regular School	No	1.0	PK	05	2015	pre_kindergarten	0.0	1.0	1.0	0	1	1
1165352	IN	school	1805580	4945	LaPorte Community School Corp	180558001011	4773	Handley Elementary School	Regular School	No	1.0	PK	05	2015	pre_kindergarten	0.0	1.0	1.0	0	1	1
1165537	IN	school	1800120	5265	Alexandria Com School Corp	180012000009	5069	Alexandria-Monroe Elementary	Regular School	No	1.0	PK	03	2015	pre_kindergarten	1.0	1.0	2.0	1	1	2
1165860	IN	school	1808820	5340	Perry Township Schools	180882001456	5325	Clinton Young Elem Sch	Regular School	No	1.0	PK	05	2015	pre_kindergarten	1.0	1.0	2.0	1	1	2
1165920	IN	school	1808820	5340	Perry Township Schools	180882001809	5372	Rosa Parks-Edison Elem	Regular School	No	1.0	PK	05	2015	pre_kindergarten	1.0	1.0	2.0	1	1	2
1167623	IN	school	1812900	6065	West Noble School Corporation	181290002055	6491	West Noble Primary School	Regular School	No	1.0	PK	01	2015	pre_kindergarten	13.0	1.0	14.0	13	1	14
1167822	IN	school	1800118	6375	North Central Parke Comm Schl Corp	180011801578	6645	Rockville Elementary School	Regular School	No	1.0	PK	06	2015	pre_kindergarten	11.0	1.0	12.0	11	1	12
1167831	IN	school	1800118	6375	North Central Parke Comm Schl Corp	180011801857	6647	Turkey Run Elementary School	Regular School	No	1.0	PK	06	2015	pre_kindergarten	3.0	1.0	4.0	3	1	4
1168455	IN	school	1800390	6895	Batesville Community Sch Corp	180039002381	7218	Batesville Primary School	Regular School	No	1.0	PK	02	2015	pre_kindergarten	7.0	1.0	8.0	7	1	8
1168928	IN	school	1810290	7205	South Bend Community Sch Corp	181029001664	7601	Nuner Primary Center	Regular School	No	1.0	PK	04	2015	pre_kindergarten	5.0	1.0	6.0	5	1	6