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 total_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
1163107	IN	school	1802550	3325	Danville Community School Corp	180255000306	2721	North Elementary School	Regular School	No	1.0	PK	05	2015	grade_5	1.0	0.0	1.0	1	0	1
1164402	IN	school	1804620	4590	River Forest Community Sch Corp	180462000778	3797	Henry S Evans Elementary Sch	Regular School	No	1.0	KG	06	2015	grade_5	1.0	0.0	1.0	1	0	1
1164413	IN	school	1804620	4590	River Forest Community Sch Corp	180462000779	3805	John I Meister Elementary School	Regular School	No	1.0	KG	06	2015	grade_5	0.0	1.0	1.0	0	1	1
1167060	IN	school	1808850	5635	Peru Community Schools	180885001477	6089	Peru Junior High School	Regular School	No	2.0	04	09	2015	grade_5	1.0	0.0	1.0	1	0	1
1168689	IN	school	1806840	7200	School City of Mishawaka	180684000531	7467	Joint Service Campus Program	Special Education School	No	4.0	03	12	2015	grade_5	1.0	0.0	1.0	1	0	1
1283004	IN	school	1812240	2285	Wa-Nee Community Schools	181224001958	1669	North Wood Middle School	Regular School	No	2.0	05	09	2016	grade_5	0.0	1.0	1.0	0	1	1
1284513	IN	school	1802550	3325	Danville Community School Corp	180255000306	2721	North Elementary School	Regular School	No	1.0	PK	05	2016	grade_5	0.0	1.0	1.0	0	1	1
1293089	IN	school	1808250	225	Northwest Allen County Schools	180825002160	145	Allen Co Youth Services Center	Alternative School	No	Other	05	11	2017	grade_5	1.0	0.0	1.0	1	0	1
1296550	IN	school	1802550	3325	Danville Community School Corp	180255000306	2721	North Elementary School	Regular School	No	Elementary	PK	05	2017	grade_5	0.0	1.0	1.0	0	1	1
1296718	IN	school	1807440	3445	New Castle Community School Corp	180744001289	2853	Sunnyside Elementary School	Regular School	No	Elementary	KG	07	2017	grade_5	0.0	1.0	1.0	0	1	1
1297101	IN	school	1809420	3815	Rensselaer Central School Corp	180942001542	3213	Rensselaer Central Primary School	Regular School	No	Elementary	PK	05	2017	grade_5	1.0	0.0	1.0	1	0	1
1300338	IN	school	1809060	5485	Plymouth Community School Corp	180906001503	5933	Menominee Elementary School	Regular School	No	Elementary	KG	05	2017	grade_5	1.0	0.0	1.0	1	0	1
1300347	IN	school	1809060	5485	Plymouth Community School Corp	180906001499	5949	Lincoln Junior High School	Regular School	No	Middle	05	08	2017	grade_5	1.0	0.0	1.0	1	0	1
1300476	IN	school	1808340	5625	Oak Hill United School Corp	180834001432	6081	Sweetser Elementary School	Regular School	No	Elementary	KG	05	2017	grade_5	0.0	1.0	1.0	0	1	1
1302106	IN	school	1806840	7200	School City of Mishawaka	180684000531	7467	Oaklawn Campus Program	Special Education School	No	Other	03	12	2017	grade_5	1.0	0.0	1.0	1	0	1
1753597	IN	school	1802400	2270	Concord Community Schools	180240000272	1723	Concord Ox-Bow Elementary School	Regular School	No	Elementary	KG	05	2019	grade_5	0.0	1.0	1.0	0	1	1
1753835	IN	school	1803930	2315	Goshen Community Schools	180393000659	1629	Goshen Middle School	Regular School	No	High	05	12	2019	grade_5	0.0	1.0	1.0	0	1	1
1754562	IN	school	1813080	3030	Westfield-Washington Schools	181308002074	2491	Westfield Middle School	Regular School	No	Middle	05	08	2019	grade_5	0.0	1.0	1.0	0	1	1
1755714	IN	school	1809420	3815	Rensselaer Central School Corp	180942001542	3213	Rensselaer Central Primary School	Regular School	No	Elementary	PK	05	2019	grade_5	1.0	0.0	1.0	1	0	1
1755805	IN	school	1806120	3995	Madison Consolidated Schools	180612001088	3333	Emery O Muncie Elementary School	Regular School	No	Elementary	KG	05	2019	grade_5	1.0	0.0	1.0	1	0	1
1761673	IN	school	1803450	7995	Evansville Vanderburgh School Corp	180345002649	8271	Harwood Career Prep High School	Regular School	No	Other	01	12	2019	grade_5	1.0	0.0	1.0	1	0	1
1788499	IN	school	1803940	1010	Greater Clark County Schools	180394000832	886	Old Corden Porter School	Special Education School	No	High	05	12	2018	grade_5	1.0	0.0	1.0	1	0	1
1789355	IN	school	1806600	2275	Middlebury Community Schools	180660001162	1657	Northridge Middle School	Regular School	No	Other	04	11	2018	grade_5	1.0	0.0	1.0	1	0	1
1789382	IN	school	1806600	2275	Middlebury Community Schools	180660000199	1734	Orchard View School	Regular School	No	Elementary	KG	05	2018	grade_5	1.0	0.0	1.0	1	0	1
1789573	IN	school	1803930	2315	Goshen Community Schools	180393000659	1629	Goshen Middle School	Regular School	No	Middle	05	12	2018	grade_5	0.0	1.0	1.0	0	1	1
1791840	IN	school	1807620	4255	Nineveh-Hensley-Jackson United	180762001306	3409	Indian Creek Elementary School	Regular School	No	Elementary	PK	05	2018	grade_5	1.0	0.0	1.0	1	0	1
1794656	IN	school	1809060	5485	Plymouth Community School Corp	180906001503	5933	Menominee Elementary School	Regular School	No	Elementary	KG	05	2018	grade_5	1.0	0.0	1.0	1	0	1
1908001	IN	school	1806030	875	Logansport Community Sch Corp	180603001052	715	Columbia 6th Grade Academy	Regular School	No	Other	02	09	2020	grade_5	1.0	0.0	1.0	1	0	1
1909028	IN	school	1802400	2270	Concord Community Schools	180240000272	1723	Concord Ox-Bow Elementary School	Regular School	No	Elementary	KG	05	2020	grade_5	1.0	0.0	1.0	1	0	1
1910003	IN	school	1813080	3030	Westfield-Washington Schools	181308002074	2491	Westfield Middle School	Regular School	No	Middle	05	08	2020	grade_5	1.0	0.0	1.0	1	0	1
1917495	IN	school	1806270	8045	Manchester Community Schools	180627001101	8633	Manchester Elementary School	Regular School	No	Elementary	PK	06	2020	grade_5	1.0	0.0	1.0	1	0	1
1917662	IN	school	1812390	8130	Warrick County School Corp	181239001976	8793	Boonville Middle School	Regular School	No	Middle	05	08	2020	grade_5	1.0	0.0	1.0	1	0	1
1919968	IN	school	1806030	875	Logansport Community Sch Corp	180603001052	715	Columbia 6th Grade Academy	Regular School	No	Other	03	12	2021	grade_5	1.0	0.0	1.0	1	0	1
1921018	IN	school	1806600	2275	Middlebury Community Schools	180660001162	1657	Northridge Middle School	Regular School	No	Middle	05	09	2021	grade_5	1.0	0.0	1.0	1	0	1
1921047	IN	school	1806600	2275	Middlebury Community Schools	180660000199	1734	Orchard View School	Regular School	No	Elementary	KG	05	2021	grade_5	0.0	1.0	1.0	0	1	1
1923122	IN	school	1809420	3815	Rensselaer Central School Corp	180942001544	3221	Rensselaer Middle School	Regular School	No	Middle	05	08	2021	grade_5	1.0	0.0	1.0	1	0	1
1927087	IN	school		6470	Duneland School Corporation		6811	Porter County Education Services						2021	grade_5	1.0	0.0	1.0	1	0	1
1927139	IN	school		6510	East Porter County School Corp		6811	Porter County Education Services						2021	grade_5	1.0	0.0	1.0	1	0	1
1927246	IN	school		6550	Portage Township Schools		6811	Porter County Education Services						2021	grade_5	1.0	0.0	1.0	1	0	1
1161574	IN	school	1806600	2275	Middlebury Community Schools	180660001162	1657	Northridge Middle School	Regular School	No	2.0	04	09	2015	grade_5	0.0	2.0	2.0	0	2	2
1163375	IN	school	1804470	3490	Western School Corp	180447000756	2921	Western High School	Regular School	No	4.0	04	12	2015	grade_5	2.0	0.0	2.0	2	0	2
1163660	IN	school	1809420	3815	Rensselaer Central School Corp	180942001542	3213	Rensselaer Central Primary School	Regular School	No	1.0	PK	05	2015	grade_5	1.0	1.0	2.0	1	1	2
1164032	IN	school	1807620	4255	Nineveh-Hensley-Jackson United	180762001306	3409	Indian Creek Elementary Sch	Regular School	No	1.0	KG	05	2015	grade_5	2.0	0.0	2.0	2	0	2
1166916	IN	school	1809060	5485	Plymouth Community School Corp	180906001503	5933	Menominee Elementary School	Regular School	No	1.0	KG	05	2015	grade_5	2.0	0.0	2.0	2	0	2
1169098	IN	school	1810140	7365	Shelbyville Central Schools	181014002496	7671	Especially Kidz Health & Rehab Cnt	Regular School	No	4.0	PK	12	2015	grade_5	0.0	2.0	2.0	0	2	2
1170515	IN	school	1809510	8385	Richmond Community Schools	180951000366	9056	Community Youth Services	Special Education School	No	4.0	KG	12	2015	grade_5	2.0	0.0	2.0	2	0	2
1281027	IN	school	1808250	225	Northwest Allen County Schools	180825002160	145	Allen Co Youth Services Center	Alternative Education School	No	4.0	01	10	2016	grade_5	1.0	1.0	2.0	1	1	2
1282082	IN	school	1803940	1010	Greater Clark County Schools	180394000832	886	Old Corden Porter School	Special Education School	No	4.0	05	12	2016	grade_5	2.0	0.0	2.0	2	0	2
1282776	IN	school	1807320	1970	Muncie Community Schools	180732001232	1524	Youth Opportunity Center	Alternative Education School	No	4.0	03	12	2016	grade_5	2.0	0.0	2.0	2	0	2
1283098	IN	school	1803270	2305	Elkhart Community Schools	180327002585	1752	Elkhart Alternative Education	Regular School	No	4.0	01	12	2016	grade_5	2.0	0.0	2.0	2	0	2
1285066	IN	school	1809420	3815	Rensselaer Central School Corp	180942001542	3213	Rensselaer Central Primary School	Regular School	No	1.0	PK	05	2016	grade_5	1.0	1.0	2.0	1	1	2
1285718	IN	school	1813110	4525	Westview School Corporation	181311001587	3704	Meadowview Elementary School	Regular School	No	1.0	KG	06	2016	grade_5	1.0	1.0	2.0	1	1	2
1288315	IN	school	1809060	5485	Plymouth Community School Corp	180906001503	5933	Menominee Elementary School	Regular School	No	1.0	KG	05	2016	grade_5	0.0	2.0	2.0	0	2	2
1291902	IN	school	1809510	8385	Richmond Community Schools	180951000366	9056	Community Youth Services	Special Education School	No	4.0	KG	12	2016	grade_5	2.0	0.0	2.0	2	0	2
1294141	IN	school	1803940	1010	Greater Clark County Schools	180394000832	886	Old Corden Porter School	Special Education School	No	Other	04	12	2017	grade_5	1.0	1.0	2.0	1	1	2
1297765	IN	school	1813110	4525	Westview School Corporation	181311001587	3704	Meadowview Elementary School	Regular School	No	Elementary	PK	05	2017	grade_5	2.0	0.0	2.0	2	0	2
1302511	IN	school	1810140	7365	Shelbyville Central Schools	181014002496	7671	Especially Kidz Health & Rehab Cnt	Regular School	No	Other	KG	12	2017	grade_5	1.0	1.0	2.0	1	1	2
1303927	IN	school	1809510	8385	Richmond Community Schools	180951000366	9056	Community Youth Services	Special Education School	No	Other	01	12	2017	grade_5	2.0	0.0	2.0	2	0	2
1755718	IN	school	1809420	3815	Rensselaer Central School Corp	180942001544	3221	Rensselaer Middle School	Regular School	No	Middle	05	08	2019	grade_5	2.0	0.0	2.0	2	0	2
1758992	IN	school	1808850	5635	Peru Community Schools	180885001477	6089	Peru Junior High School	Regular School	No	Middle	05	08	2019	grade_5	0.0	2.0	2.0	0	2	2
1790302	IN	school	1813080	3030	Westfield-Washington Schools	181308002074	2491	Westfield Middle School	Regular School	No	Middle	05	08	2018	grade_5	2.0	0.0	2.0	2	0	2
1791073	IN	school	1807440	3445	New Castle Community School Corp	180744001289	2853	Sunnyside Elementary School	Regular School	No	Elementary	KG	06	2018	grade_5	1.0	1.0	2.0	1	1	2
1791464	IN	school	1809420	3815	Rensselaer Central School Corp	180942001542	3213	Rensselaer Central Primary School	Regular School	No	Elementary	PK	05	2018	grade_5	2.0	0.0	2.0	2	0	2
1908847	IN	school	1807320	1970	Muncie Community Schools	180732001232	1524	Youth Opportunity Center	Alternative School	No	High	05	12	2020	grade_5	2.0	0.0	2.0	2	0	2
1912191	IN	school	1803870	4690	Gary Community School Corp	180387002684	4068	Gary Virtual Academy	Regular School	No	Other	02	09	2020	grade_5	1.0	1.0	2.0	1	1	2
1913709	IN	school	1804770	5385	Indianapolis Public Schools	180477002651	108	Impact Academy	Regular School	No	Other	03	12	2020	grade_5	2.0	0.0	2.0	2	0	2
1914261	IN	school	1809060	5485	Plymouth Community School Corp	180906001503	5933	Menominee Elementary School	Regular School	No	Elementary	KG	05	2020	grade_5	0.0	2.0	2.0	0	2	2
1916418	IN	school	1810140	7365	Shelbyville Central Schools	181014002496	7671	Especially Kidz Health & Rehab Cnt	Regular School	No	Other	01	12	2020	grade_5	0.0	2.0	2.0	0	2	2
1920822	IN	school	1807320	1970	Muncie Community Schools	180732001232	1524	Youth Opportunity Center	Alternative School	No	High	05	12	2021	grade_5	2.0	0.0	2.0	2	0	2
1923787	IN	school	1813110	4525	Westview School Corporation	181311001587	3704	Meadowview Elementary School	Regular School	No	Elementary	PK	06	2021	grade_5	2.0	0.0	2.0	2	0	2
1926143	IN	school	1809060	5485	Plymouth Community School Corp	180906001503	5933	Menominee Elementary School	Regular School	No	Elementary	KG	05	2021	grade_5	1.0	1.0	2.0	1	1	2
1160681	IN	school	1803940	1010	Greater Clark County Schools	180394000832	886	Old Corden Porter School	Special Education School	No	4.0	04	12	2015	grade_5	3.0	0.0	3.0	3	0	3
1171262	IN	school	1800131	9760	Smith Academy for Excellence	180013102539	242	Smith Academy for Excellence	Regular School	Yes	4.0	03	11	2015	grade_5	3.0	0.0	3.0	3	0	3
1282974	IN	school	1806600	2275	Middlebury Community Schools	180660001162	1657	Northridge Middle School	Regular School	No	2.0	05	09	2016	grade_5	2.0	1.0	3.0	2	1	3
1288457	IN	school	1808850	5635	Peru Community Schools	180885001477	6089	Peru Junior High School	Regular School	No	2.0	04	09	2016	grade_5	2.0	1.0	3.0	2	1	3
1290482	IN	school	1810140	7365	Shelbyville Central Schools	181014002496	7671	Especially Kidz Health & Rehab Cnt	Regular School	No	4.0	02	12	2016	grade_5	2.0	1.0	3.0	2	1	3
1295012	IN	school	1806600	2275	Middlebury Community Schools	180660001162	1657	Northridge Middle School	Regular School	No	Other	05	10	2017	grade_5	2.0	1.0	3.0	2	1	3
1295136	IN	school	1803270	2305	Elkhart Community Schools	180327002585	1752	Elkhart Alternative Education	Regular School	No	Other	01	12	2017	grade_5	3.0	0.0	3.0	3	0	3
1300487	IN	school	1808850	5635	Peru Community Schools	180885001477	6089	Peru Junior High School	Regular School	No	Elementary	04	08	2017	grade_5	2.0	1.0	3.0	2	1	3
1759339	IN	school	1806510	5925	M S D Martinsville Schools	180651002355	6344	South Elementary School	Regular School	No	Elementary	PK	06	2019	grade_5	2.0	1.0	3.0	2	1	3
1761009	IN	school	1810140	7365	Shelbyville Central Schools	181014002496	7671	Especially Kidz Health & Rehab Cnt	Regular School	No	Other	PK	12	2019	grade_5	2.0	1.0	3.0	2	1	3
1763248	IN	school	1800131	9760	Smith Academy for Excellence	180013102539	242	Smith Academy for Excellence	Regular School	Yes	Other	04	12	2019	grade_5	3.0	0.0	3.0	3	0	3
1789481	IN	school	1803270	2305	Elkhart Community Schools	180327002585	1752	Elkhart Alternative Education	Regular School	No	Other	01	12	2018	grade_5	3.0	0.0	3.0	3	0	3
1792124	IN	school	1813110	4525	Westview School Corporation	181311001587	3704	Meadowview Elementary School	Regular School	No	Elementary	PK	06	2018	grade_5	1.0	2.0	3.0	1	2	3
1796423	IN	school	1806840	7200	School City of Mishawaka	180684000531	7467	Oaklawn Campus Program	Special Education School	No	Other	03	12	2018	grade_5	3.0	0.0	3.0	3	0	3
1911164	IN	school	1809420	3815	Rensselaer Central School Corp	180942001544	3221	Rensselaer Middle School	Regular School	No	Middle	05	08	2020	grade_5	3.0	0.0	3.0	3	0	3
1913642	IN	school		5375	M S D Wayne Township		5271	Sanders School						2020	grade_5	3.0	0.0	3.0	3	0	3
1926632	IN	school	1806510	5925	MSD Martinsville Schools	180651002355	6344	South Elementary School of Communi	Regular School	No	Elementary	PK	06	2021	grade_5	1.0	2.0	3.0	1	2	3
1928350	IN	school	1810140	7365	Shelbyville Central Schools	181014002496	7671	Especially Kidz Health & Rehab Cnt	Regular School	No	Other	02	12	2021	grade_5	2.0	1.0	3.0	2	1	3
1164542	IN	school	1811460	4645	Tri-Creek School Corporation	181146001851	3851	Lowell Middle School	Regular School	No	2.0	05	08	2015	grade_5	2.0	2.0	4.0	2	2	4
1285928	IN	school	1811460	4645	Tri-Creek School Corporation	181146001851	3851	Lowell Middle School	Regular School	No	2.0	05	08	2016	grade_5	4.0	0.0	4.0	4	0	4
1290080	IN	school	1806840	7200	School City of Mishawaka	180684000531	7467	Joint Service Campus Program	Special Education School	No	4.0	04	12	2016	grade_5	4.0	0.0	4.0	4	0	4
1795155	IN	school	1806510	5925	M S D Martinsville Schools	180651002355	6344	South Elementary School	Regular School	No	Elementary	PK	06	2018	grade_5	2.0	2.0	4.0	2	2	4
1921958	IN	school	1813080	3030	Westfield-Washington Schools	181308002074	2491	Westfield Middle School	Regular School	No	Middle	05	08	2021	grade_5	2.0	2.0	4.0	2	2	4
1929813	IN	school	1809510	8385	Richmond Community Schools	180951000366	9056	Community Youth Services	Special Education School	No	Other	01	12	2021	grade_5	4.0	0.0	4.0	4	0	4
1171233	IN	school	1800121	9740	Thurgood Marshall Leadership Acad	180012102540	138	Thurgood Marshall Leadership Acad	Regular School	Yes	1.0	KG	08	2015	grade_5	1.0	4.0	5.0	1	4	5
1753741	IN	school	1803270	2305	Elkhart Community Schools	180327002585	1752	Elkhart Alternative Education	Regular School	No	Other	02	12	2019	grade_5	5.0	0.0	5.0	5	0	5
1756362	IN	school	1813110	4525	Westview School Corporation	181311001587	3704	Meadowview Elementary School	Regular School	No	Elementary	PK	06	2019	grade_5	4.0	1.0	5.0	4	1	5
1789156	IN	school	1807320	1970	Muncie Community Schools	180732001232	1524	Youth Opportunity Center	Alternative School	No	Other	03	12	2018	grade_5	3.0	2.0	5.0	3	2	5
1794803	IN	school	1808850	5635	Peru Community Schools	180885001477	6089	Peru Junior High School	Regular School	No	Middle	05	08	2018	grade_5	4.0	1.0	5.0	4	1	5
1798811	IN	school	1800023	9605	IN Sch for the Blind & Vis Imprd	180002302257	C460	IN Sch for the Blind & Vis Imprd	Special Education School	No	Other	PK	12	2018	grade_5	3.0	2.0	5.0	3	2	5