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 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
1159636	IN	school	1808250	225	Northwest Allen County Schools	180825002160	145	Allen Co Youth Services Ctr	Alternative Education School	No	4.0	04	11	2015	grade_4	2.0	0.0	2.0	2	0	2
1160680	IN	school	1803940	1010	Greater Clark County Schools	180394000832	886	Old Corden Porter School	Special Education School	No	4.0	04	12	2015	grade_4	1.0	0.0	1.0	1	0	1
1161372	IN	school	1807320	1970	Muncie Community Schools	180732001232	1524	Youth Opportunity Center	Alternative Education School	No	4.0	03	12	2015	grade_4	2.0	0.0	2.0	2	0	2
1161573	IN	school	1806600	2275	Middlebury Community Schools	180660001162	1657	Northridge Middle School	Regular School	No	2.0	04	09	2015	grade_4	1.0	0.0	1.0	1	0	1
1161602	IN	school	1806600	2275	Middlebury Community Schools	180660000199	1734	Orchard View Sch	Regular School	No	1.0	KG	04	2015	grade_4	1.0	0.0	1.0	1	0	1
1164743	IN	school	1803870	4690	Gary Community School Corp	180387000617	4081	Dr Bernard C Watson Acad for Boys	Regular School	No	1.0	KG	06	2015	grade_4	24.0	0.0	24.0	24	0	24
1168688	IN	school	1806840	7200	School City of Mishawaka	180684000531	7467	Joint Service Campus Program	Special Education School	No	4.0	03	12	2015	grade_4	2.0	0.0	2.0	2	0	2
1170514	IN	school	1809510	8385	Richmond Community Schools	180951000366	9056	Community Youth Services	Special Education School	No	4.0	KG	12	2015	grade_4	4.0	0.0	4.0	4	0	4
1171261	IN	school	1800131	9760	Smith Academy for Excellence	180013102539	242	Smith Academy for Excellence	Regular School	Yes	4.0	03	11	2015	grade_4	3.0	0.0	3.0	3	0	3
1281654	IN	school	1802830	630	Zionsville Community Schools	180283002046	510	Zionsville West Middle School	Regular School	No	2.0	04	08	2016	grade_4	1.0	0.0	1.0	1	0	1
1283097	IN	school	1803270	2305	Elkhart Community Schools	180327002585	1752	Elkhart Alternative Education	Regular School	No	4.0	01	12	2016	grade_4	2.0	0.0	2.0	2	0	2
1284524	IN	school	1802550	3325	Danville Community School Corp	180255000305	2743	Danville Middle School	Regular School	No	1.0	03	08	2016	grade_4	1.0	0.0	1.0	1	0	1
1285065	IN	school	1809420	3815	Rensselaer Central School Corp	180942001542	3213	Rensselaer Central Primary School	Regular School	No	1.0	PK	05	2016	grade_4	1.0	0.0	1.0	1	0	1
1286133	IN	school	1803870	4690	Gary Community School Corp	180387000617	4081	Dr Bernard C Watson Acad for Boys	Regular School	No	1.0	KG	08	2016	grade_4	22.0	0.0	22.0	22	0	22
1288456	IN	school	1808850	5635	Peru Community Schools	180885001477	6089	Peru Junior High School	Regular School	No	2.0	04	09	2016	grade_4	1.0	0.0	1.0	1	0	1
1290079	IN	school	1806840	7200	School City of Mishawaka	180684000531	7467	Joint Service Campus Program	Special Education School	No	4.0	04	12	2016	grade_4	1.0	0.0	1.0	1	0	1
1291121	IN	school	1803450	7995	Evansville Vanderburgh Sch Corp	180345002462	8270	Academy for Innovative Studies	Regular School	No	4.0	01	12	2016	grade_4	6.0	0.0	6.0	6	0	6
1291901	IN	school	1809510	8385	Richmond Community Schools	180951000366	9056	Community Youth Services	Special Education School	No	4.0	KG	12	2016	grade_4	3.0	0.0	3.0	3	0	3
1292630	IN	school	1800131	9760	Smith Academy for Excellence	180013102539	242	Smith Academy for Excellence	Regular School	Yes	4.0	02	12	2016	grade_4	7.0	0.0	7.0	7	0	7
1292842	IN	school	1800108	9920	Damar Charter Academy	180010802503	5191	Damar Charter Academy	Regular School	Yes	4.0	KG	12	2016	grade_4	10.0	0.0	10.0	10	0	10
1294140	IN	school	1803940	1010	Greater Clark County Schools	180394000832	886	Old Corden Porter School	Special Education School	No	Other	04	12	2017	grade_4	1.0	0.0	1.0	1	0	1
1294812	IN	school	1807320	1970	Muncie Community Schools	180732001232	1524	Youth Opportunity Center	Alternative School	No	Other	02	12	2017	grade_4	2.0	0.0	2.0	2	0	2
1296494	IN	school	1800270	3315	Avon Community School Corp	180027002092	2729	Avon Intermediate School West	Regular School	No	Elementary	04	06	2017	grade_4	2.0	0.0	2.0	2	0	2
1296549	IN	school	1802550	3325	Danville Community School Corp	180255000306	2721	North Elementary School	Regular School	No	Elementary	PK	05	2017	grade_4	1.0	0.0	1.0	1	0	1
1296560	IN	school	1802550	3325	Danville Community School Corp	180255000305	2743	Danville Middle School	Regular School	No	Elementary	04	08	2017	grade_4	2.0	0.0	2.0	2	0	2
1298176	IN	school	1803870	4690	Gary Community School Corp	180387000617	4081	Dr Bernard C Watson Acad for Boys	Regular School	No	Elementary	KG	08	2017	grade_4	27.0	0.0	27.0	27	0	27
1300486	IN	school	1808850	5635	Peru Community Schools	180885001477	6089	Peru Junior High School	Regular School	No	Elementary	04	08	2017	grade_4	1.0	0.0	1.0	1	0	1
1302105	IN	school	1806840	7200	School City of Mishawaka	180684000531	7467	Oaklawn Campus Program	Special Education School	No	Other	03	12	2017	grade_4	1.0	0.0	1.0	1	0	1
1303150	IN	school	1803450	7995	Evansville Vanderburgh School Corp	180345002462	8270	Academy for Innovative Studies	Regular School	No	Other	KG	12	2017	grade_4	2.0	0.0	2.0	2	0	2
1303926	IN	school	1809510	8385	Richmond Community Schools	180951000366	9056	Community Youth Services	Special Education School	No	Other	01	12	2017	grade_4	6.0	0.0	6.0	6	0	6
1304668	IN	school	1800131	9760	Smith Academy for Excellence	180013102539	242	Smith Academy for Excellence	Regular School	Yes	Other	04	12	2017	grade_4	8.0	0.0	8.0	8	0	8
1304869	IN	school	1800108	9920	Damar Charter Academy	180010802503	5191	Damar Charter Academy	Regular School	Yes	Other	KG	12	2017	grade_4	9.0	0.0	9.0	9	0	9
1752563	IN	school	1806030	875	Logansport Community Sch Corp	180603001052	715	Columbia 6th Grade Academy	Regular School	No	Middle	04	08	2019	grade_4	1.0	0.0	1.0	1	0	1
1753416	IN	school	1807320	1970	Muncie Community Schools	180732001232	1524	Youth Opportunity Center	Alternative School	No	Other	04	12	2019	grade_4	1.0	0.0	1.0	1	0	1
1753583	IN	school	1802400	2270	Concord Community Schools	180240002484	1718	Concord Intermediate School	Regular School	No	Middle	04	06	2019	grade_4	2.0	0.0	2.0	2	0	2
1753740	IN	school	1803270	2305	Elkhart Community Schools	180327002585	1752	Elkhart Alternative Education	Regular School	No	Other	02	12	2019	grade_4	2.0	0.0	2.0	2	0	2
1755109	IN	school	1800270	3315	Avon Community School Corp	180027002092	2729	Avon Intermediate School West	Regular School	No	Middle	04	06	2019	grade_4	1.0	0.0	1.0	1	0	1
1755174	IN	school	1802550	3325	Danville Community School Corp	180255000305	2743	Danville Middle School	Regular School	No	Other	04	09	2019	grade_4	1.0	0.0	1.0	1	0	1
1755713	IN	school	1809420	3815	Rensselaer Central School Corp	180942001542	3213	Rensselaer Central Primary School	Regular School	No	Elementary	PK	05	2019	grade_4	1.0	0.0	1.0	1	0	1
1758213	IN	school		5375	M S D Wayne Township		5271	Sanders School						2019	grade_4	3.0	0.0	3.0	3	0	3
1760614	IN	school	1806840	7200	School City of Mishawaka	180684000531	7467	Oaklawn Campus Program	Special Education School	No	Other	04	12	2019	grade_4	1.0	0.0	1.0	1	0	1
1761661	IN	school	1803450	7995	Evansville Vanderburgh School Corp	180345002462	8270	Academy for Innovative Studies	Regular School	No	Other	01	12	2019	grade_4	7.0	0.0	7.0	7	0	7
1762464	IN	school	1809510	8385	Richmond Community Schools	180951000366	9056	Community Youth Services	Special Education School	No	Other	KG	12	2019	grade_4	7.0	0.0	7.0	7	0	7
1763247	IN	school	1800131	9760	Smith Academy for Excellence	180013102539	242	Smith Academy for Excellence	Regular School	Yes	Other	04	12	2019	grade_4	5.0	0.0	5.0	5	0	5
1789155	IN	school	1807320	1970	Muncie Community Schools	180732001232	1524	Youth Opportunity Center	Alternative School	No	Other	03	12	2018	grade_4	1.0	0.0	1.0	1	0	1
1789320	IN	school	1802400	2270	Concord Community Schools	180240002484	1718	Concord Intermediate School	Regular School	No	Middle	04	06	2018	grade_4	3.0	0.0	3.0	3	0	3
1789354	IN	school	1806600	2275	Middlebury Community Schools	180660001162	1657	Northridge Middle School	Regular School	No	Other	04	11	2018	grade_4	1.0	0.0	1.0	1	0	1
1789480	IN	school	1803270	2305	Elkhart Community Schools	180327002585	1752	Elkhart Alternative Education	Regular School	No	Other	01	12	2018	grade_4	5.0	0.0	5.0	5	0	5
1790913	IN	school	1802550	3325	Danville Community School Corp	180255000305	2743	Danville Middle School	Regular School	No	Middle	04	08	2018	grade_4	2.0	0.0	2.0	2	0	2
1791072	IN	school	1807440	3445	New Castle Community School Corp	180744001289	2853	Sunnyside Elementary School	Regular School	No	Elementary	KG	06	2018	grade_4	1.0	0.0	1.0	1	0	1
1791463	IN	school	1809420	3815	Rensselaer Central School Corp	180942001542	3213	Rensselaer Central Primary School	Regular School	No	Elementary	PK	05	2018	grade_4	3.0	0.0	3.0	3	0	3
1797466	IN	school	1803450	7995	Evansville Vanderburgh School Corp	180345002462	8270	Academy for Innovative Studies	Regular School	No	Other	01	12	2018	grade_4	7.0	0.0	7.0	7	0	7
1797910	IN	school	1812180	8050	M S D Wabash County Schools	181218001944	8677	Metro North Elementary School	Regular School	No	Elementary	KG	04	2018	grade_4	1.0	0.0	1.0	1	0	1
1798248	IN	school	1809510	8385	Richmond Community Schools	180951000366	9056	Community Youth Services	Special Education School	No	Other	KG	12	2018	grade_4	6.0	0.0	6.0	6	0	6
1798993	IN	school	1800131	9760	Smith Academy for Excellence	180013102539	242	Smith Academy for Excellence	Regular School	Yes	Other	04	12	2018	grade_4	3.0	0.0	3.0	3	0	3
1908000	IN	school	1806030	875	Logansport Community Sch Corp	180603001052	715	Columbia 6th Grade Academy	Regular School	No	Other	02	09	2020	grade_4	2.0	0.0	2.0	2	0	2
1910620	IN	school	1802550	3325	Danville Community School Corp	180255000305	2743	Danville Middle School	Regular School	No	Other	04	09	2020	grade_4	1.0	0.0	1.0	1	0	1
1911160	IN	school	1809420	3815	Rensselaer Central School Corp	180942001542	3213	Rensselaer Central Primary School	Regular School	No	Elementary	PK	04	2020	grade_4	2.0	0.0	2.0	2	0	2
1913708	IN	school	1804770	5385	Indianapolis Public Schools	180477002651	108	Impact Academy	Regular School	No	Other	03	12	2020	grade_4	4.0	0.0	4.0	4	0	4
1917067	IN	school	1803450	7995	Evansville Vanderburgh School Corp	180345002462	8270	Academy for Innovative Studies	Regular School	No	Other	01	12	2020	grade_4	13.0	0.0	13.0	13	0	13
1917884	IN	school	1809510	8385	Richmond Community Schools	180951000366	9056	Community Youth Services	Special Education School	No	Other	KG	12	2020	grade_4	1.0	0.0	1.0	1	0	1
1918709	IN	school	1800131	9760	Smith Academy for Excellence	180013102539	242	Smith Academy for Excellence	Regular School	Yes	Other	04	12	2020	grade_4	4.0	0.0	4.0	4	0	4
1920983	IN	school	1802400	2270	Concord Community Schools	180240002484	1718	Concord Intermediate School	Regular School	No	Middle	04	08	2021	grade_4	1.0	0.0	1.0	1	0	1
1923181	IN	school	1806120	3995	Madison Consolidated Schools	180612001091	3313	Madison Consolidated Jr High Sch	Regular School	No	Middle	04	08	2021	grade_4	3.0	0.0	3.0	3	0	3
1927245	IN	school		6550	Portage Township Schools		6811	Porter County Education Services						2021	grade_4	4.0	0.0	4.0	4	0	4
1928009	IN	school	1810290	7205	South Bend Community School Corp	181029002699	7248	South Bend Virtual School	Regular School	No	Other	01	12	2021	grade_4	2.0	0.0	2.0	2	0	2
1930087	IN	school	1800222	9000	Phalen Virtual Leadership Academy	180022202707	9992	Phalen Virtual Leadership Academy	Regular School	Yes	Other	02	12	2021	grade_4	1.0	0.0	1.0	1	0	1
1930697	IN	school	1800131	9760	Smith Academy for Excellence	180013102539	242	Smith Academy for Excellence	Regular School	Yes	Other	04	12	2021	grade_4	6.0	0.0	6.0	6	0	6
1161540	IN	school	1802400	2270	Concord Community Schools	180240002484	1718	Concord Intermediate School	Regular School	No	1.0	03	06	2015	grade_4	6.0	1.0	7.0	6	1	7
1163106	IN	school	1802550	3325	Danville Community School Corp	180255000306	2721	North Elementary School	Regular School	No	1.0	PK	05	2015	grade_4	0.0	1.0	1.0	0	1	1
1163117	IN	school	1802550	3325	Danville Community School Corp	180255000305	2743	Danville Middle School	Regular School	No	2.0	04	08	2015	grade_4	0.0	1.0	1.0	0	1	1
1163374	IN	school	1804470	3490	Western School Corp	180447000756	2921	Western High School	Regular School	No	4.0	04	12	2015	grade_4	0.0	1.0	1.0	0	1	1
1163659	IN	school	1809420	3815	Rensselaer Central School Corp	180942001542	3213	Rensselaer Central Primary School	Regular School	No	1.0	PK	05	2015	grade_4	1.0	1.0	2.0	1	1	2
1164358	IN	school	1808320	4570	Northwest Indiana Spec Ed Coop	180832002208	4287	Eagle Park Community School	Special Education School	No	4.0	KG	12	2015	grade_4	7.0	1.0	8.0	7	1	8
1166236	IN	school		5375	M S D Wayne Township		5271	Sanders School						2015	grade_4	5.0	1.0	6.0	5	1	6
1166815	IN	school	1800105	5390	Southside Sp Srvs Of Marion Co	180010502502	5320	RISE Learning Center	Regular School	No	4.0	KG	12	2015	grade_4	6.0	1.0	7.0	6	1	7
1167059	IN	school	1808850	5635	Peru Community Schools	180885001477	6089	Peru Junior High School	Regular School	No	2.0	04	09	2015	grade_4	0.0	1.0	1.0	0	1	1
1169097	IN	school	1810140	7365	Shelbyville Central Schools	181014002496	7671	Especially Kidz Health & Rehab Cnt	Regular School	No	4.0	PK	12	2015	grade_4	2.0	1.0	3.0	2	1	3
1169731	IN	school	1803450	7995	Evansville Vanderburgh Sch Corp	180345002462	8270	Academy for Innovative Studies	Regular School	No	4.0	KG	12	2015	grade_4	13.0	1.0	14.0	13	1	14
1171058	IN	school	1800023	9605	IN Sch for the Blind & Vis Imprd	180002302257	C460	Indiana School For The Blind	Alternative Education School	No	4.0	PK	12	2015	grade_4	8.0	1.0	9.0	8	1	9
1171469	IN	school	1800108	9920	Damar Charter Academy	180010802503	5191	Damar Charter Academy	Regular School	Yes	4.0	KG	12	2015	grade_4	9.0	1.0	10.0	9	1	10
1282775	IN	school	1807320	1970	Muncie Community Schools	180732001232	1524	Youth Opportunity Center	Alternative Education School	No	4.0	03	12	2016	grade_4	4.0	1.0	5.0	4	1	5
1284512	IN	school	1802550	3325	Danville Community School Corp	180255000306	2721	North Elementary School	Regular School	No	1.0	PK	05	2016	grade_4	0.0	1.0	1.0	0	1	1
1287638	IN	school		5375	M S D Wayne Township		5271	Sanders School						2016	grade_4	1.0	1.0	2.0	1	1	2
1290481	IN	school	1810140	7365	Shelbyville Central Schools	181014002496	7671	Especially Kidz Health & Rehab Cnt	Regular School	No	4.0	02	12	2016	grade_4	2.0	1.0	3.0	2	1	3
1295040	IN	school	1806600	2275	Middlebury Community Schools	180660000199	1734	Orchard View School	Regular School	No	Elementary	KG	04	2017	grade_4	1.0	1.0	2.0	1	1	2
1295135	IN	school	1803270	2305	Elkhart Community Schools	180327002585	1752	Elkhart Alternative Education	Regular School	No	Other	01	12	2017	grade_4	3.0	1.0	4.0	3	1	4
1296717	IN	school	1807440	3445	New Castle Community School Corp	180744001289	2853	Sunnyside Elementary School	Regular School	No	Elementary	KG	07	2017	grade_4	0.0	1.0	1.0	0	1	1
1297100	IN	school	1809420	3815	Rensselaer Central School Corp	180942001542	3213	Rensselaer Central Primary School	Regular School	No	Elementary	PK	05	2017	grade_4	3.0	1.0	4.0	3	1	4
1297484	IN	school	1807620	4255	Nineveh-Hensley-Jackson United	180762001306	3409	Indian Creek Elementary School	Regular School	No	Elementary	PK	04	2017	grade_4	1.0	1.0	2.0	1	1	2
1299675	IN	school		5375	M S D Wayne Township		5271	Sanders School						2017	grade_4	5.0	1.0	6.0	5	1	6
1302510	IN	school	1810140	7365	Shelbyville Central Schools	181014002496	7671	Especially Kidz Health & Rehab Cnt	Regular School	No	Other	KG	12	2017	grade_4	0.0	1.0	1.0	0	1	1
1756016	IN	school	1803690	4225	Franklin Community School Corp	180369002440	3458	Custer Baker Intermediate School	Regular School	No	Middle	04	06	2019	grade_4	0.0	1.0	1.0	0	1	1
1758278	IN	school	1804770	5385	Indianapolis Public Schools	180477002651	108	Impact Academy	Regular School	No	Other	03	12	2019	grade_4	2.0	1.0	3.0	2	1	3
1761672	IN	school	1803450	7995	Evansville Vanderburgh School Corp	180345002649	8271	Harwood Career Prep High School	Regular School	No	Other	01	12	2019	grade_4	2.0	1.0	3.0	2	1	3
1791542	IN	school	1806120	3995	Madison Consolidated Schools	180612001091	3313	Madison Consolidated Jr High Sch	Regular School	No	Middle	03	08	2018	grade_4	0.0	1.0	1.0	0	1	1
1796822	IN	school	1810140	7365	Shelbyville Central Schools	181014002496	7671	Especially Kidz Health & Rehab Cnt	Regular School	No	Other	02	12	2018	grade_4	1.0	1.0	2.0	1	1	2
1799194	IN	school	1800108	9920	Damar Charter Academy	180010802503	5191	Damar Charter Academy	Regular School	Yes	Other	KG	12	2018	grade_4	10.0	1.0	11.0	10	1	11
1913641	IN	school		5375	M S D Wayne Township		5271	Sanders School						2020	grade_4	4.0	1.0	5.0	4	1	5
1914383	IN	school	1808340	5625	Oak Hill United School Corp	180834001431	2306	Swayzee Elementary School	Regular School	No	Middle	04	06	2020	grade_4	0.0	1.0	1.0	0	1	1
1916417	IN	school	1810140	7365	Shelbyville Central Schools	181014002496	7671	Especially Kidz Health & Rehab Cnt	Regular School	No	Other	01	12	2020	grade_4	2.0	1.0	3.0	2	1	3