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 male_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
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
1164751	IN	school	1803870	4690	Gary Community School Corp	180387000620	4086	Frankie W McCullough Acad for Girl	Regular School	No	1.0	KG	07	2015	grade_4	0.0	50.0	50.0	0	50	50
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
1283001	IN	school	1806600	2275	Middlebury Community Schools	180660000199	1734	Orchard View Sch	Regular School	No	1.0	KG	04	2016	grade_4	0.0	2.0	2.0	0	2	2
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
1286143	IN	school	1803870	4690	Gary Community School Corp	180387000620	4086	Frankie W McCullough Acad for Girl	Regular School	No	1.0	KG	08	2016	grade_4	0.0	42.0	42.0	0	42	42
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
1298186	IN	school	1803870	4690	Gary Community School Corp	180387000620	4086	Frankie W McCullough Acad for Girl	Regular School	No	Elementary	KG	08	2017	grade_4	0.0	62.0	62.0	0	62	62
1301761	IN	school	1811730	6795	Union School Corporation	181173001874	7117	Union Elementary School	Regular School	No	Elementary	KG	06	2017	grade_4	0.0	9.0	9.0	0	9	9
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
1756750	IN	school	1803870	4690	Gary Community School Corp	180387000620	4086	Frankie W McCullough Acad for Girl	Regular School	No	Elementary	KG	05	2019	grade_4	0.0	58.0	58.0	0	58	58
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
1792521	IN	school	1803870	4690	Gary Community School Corp	180387000620	4086	Frankie W McCullough Acad for Girl	Regular School	No	Elementary	KG	08	2018	grade_4	0.0	51.0	51.0	0	51	51
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
1921046	IN	school	1806600	2275	Middlebury Community Schools	180660000199	1734	Orchard View School	Regular School	No	Elementary	KG	05	2021	grade_4	0.0	2.0	2.0	0	2	2
1922563	IN	school	1802550	3325	Danville Community School Corp	180255000306	2721	North Elementary School	Regular School	No	Elementary	KG	04	2021	grade_4	0.0	1.0	1.0	0	1	1
1922572	IN	school	1802550	3325	Danville Community School Corp	180255000305	2743	Danville Middle School	Regular School	No	Other	04	09	2021	grade_4	0.0	1.0	1.0	0	1	1
1923118	IN	school	1809420	3815	Rensselaer Central School Corp	180942001542	3213	Rensselaer Central Primary School	Regular School	No	Elementary	PK	04	2021	grade_4	0.0	1.0	1.0	0	1	1
1927138	IN	school		6510	East Porter County School Corp		6811	Porter County Education Services						2021	grade_4	0.0	1.0	1.0	0	1	1
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
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
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
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
1284456	IN	school	1800270	3315	Avon Community School Corp	180027002092	2729	Avon Intermediate School West	Regular School	No	2.0	04	06	2016	grade_4	1.0	2.0	3.0	1	2	3
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
1287638	IN	school		5375	M S D Wayne Township		5271	Sanders School						2016	grade_4	1.0	1.0	2.0	1	1	2
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1909076	IN	school	1806600	2275	Middlebury Community Schools	180660000199	1734	Orchard View School	Regular School	No	Elementary	KG	04	2020	grade_4	1.0	2.0	3.0	1	2	3
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
1912190	IN	school	1803870	4690	Gary Community School Corp	180387002684	4068	Gary Virtual Academy	Regular School	No	Other	02	09	2020	grade_4	1.0	2.0	3.0	1	2	3
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
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
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
1930830	IN	school	1800108	9920	Damar Charter Academy	180010802503	5191	Damar Charter Academy	Regular School	Yes	Other	KG	12	2021	grade_4	1.0	1.0	2.0	1	1	2
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
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
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
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
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
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
1292435	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	2016	grade_4	2.0	3.0	5.0	2	3	5
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
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
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
1304257	IN	school	1800013	9350	Timothy L Johnson Academy	180001301774	1539	Timothy L Johnson Academy	Regular School	Yes	Elementary	KG	06	2017	grade_4	2.0	11.0	13.0	2	11	13
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
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
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
1799041	IN	school	1800074	9795	Dr Robert H Faulkner Academy	180007402426	2411	Dr Robert H Faulkner Academy	Regular School	Yes	Elementary	KG	06	2018	grade_4	2.0	13.0	15.0	2	13	15
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
1909172	IN	school	1803270	2305	Elkhart Community Schools	180327002585	1752	Elkhart Alternative Education	Regular School	No	Other	KG	12	2020	grade_4	2.0	3.0	5.0	2	3	5
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
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
1919967	IN	school	1806030	875	Logansport Community Sch Corp	180603001052	715	Columbia 6th Grade Academy	Regular School	No	Other	03	12	2021	grade_4	2.0	1.0	3.0	2	1	3
1921551	IN	school	1802940	2725	East Gibson School Corporation	180294000383	2189	Barton Township Elementary	Regular School	No	Elementary	KG	06	2021	grade_4	2.0	5.0	7.0	2	5	7
1927328	IN	school		6560	Valparaiso Community Schools		6811	Porter County Education Services						2021	grade_4	2.0	1.0	3.0	2	1	3
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
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
1282940	IN	school	1802400	2270	Concord Community Schools	180240002484	1718	Concord Intermediate School	Regular School	No	2.0	04	07	2016	grade_4	3.0	3.0	6.0	3	3	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
1292600	IN	school	1800121	9740	Thurgood Marshall Leadership Acad	180012102540	138	Thurgood Marshall Leadership Acad	Regular School	Yes	1.0	KG	08	2016	grade_4	3.0	6.0	9.0	3	6	9
1294977	IN	school	1802400	2270	Concord Community Schools	180240002484	1718	Concord Intermediate School	Regular School	No	Elementary	04	07	2017	grade_4	3.0	3.0	6.0	3	3	6
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
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
1304468	IN	school	1800023	9605	IN Sch for the Blind & Vis Imprd	180002302257	C460	IN Sch for the Blind & Vis Imprd	Alternative School	No	Other	PK	12	2017	grade_4	3.0	2.0	5.0	3	2	5
1754174	IN	school	1802940	2725	East Gibson School Corporation	180294000382	2201	Francisco Elementary School	Regular School	No	Elementary	KG	06	2019	grade_4	3.0	4.0	7.0	3	4	7
1758213	IN	school		5375	M S D Wayne Township		5271	Sanders School						2019	grade_4	3.0	0.0	3.0	3	0	3
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
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
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
1921139	IN	school	1803270	2305	Elkhart Community Schools	180327002585	1752	Elkhart Alternative Education	Regular School	No	Other	01	12	2021	grade_4	3.0	1.0	4.0	3	1	4
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
1927086	IN	school		6470	Duneland School Corporation		6811	Porter County Education Services						2021	grade_4	3.0	1.0	4.0	3	1	4
1160857	IN	school	1802440	1300	Crawford Co Com School Corp	180244000280	1057	English School	Regular School	No	1.0	PK	06	2015	grade_4	4.0	9.0	13.0	4	9	13
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