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 "state" = :p0 and "year" = :p1 and (female_int > :p3 or (female_int = :p3 and rowid > :p2)) order by female_int, rowid 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	white	black	hispanic	asian	native_hawaiian_pacific_islander	multiracial	male	female	ell	free_and_reduced	disability	total	white_int	black_int	hispanic_int	asian_int	native_hawaiian_pacific_islander_int	multiracial_int	male_int	female_int	ell_int	free_and_reduced_int	disability_int	total_int
1761007	IN	school	1810140	7365	Shelbyville Central Schools	181014002496	7671	Especially Kidz Health & Rehab Cnt	Regular School	No	Other	PK	12	2019	grade_2							2.0	0.0				2.0							2	0				2
1761008	IN	school	1810140	7365	Shelbyville Central Schools	181014002496	7671	Especially Kidz Health & Rehab Cnt	Regular School	No	Other	PK	12	2019	grade_3							1.0	0.0				1.0							1	0				1
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
1761126	IN	school	1808460	7495	Oregon-Davis School Corp	180846001435	7831	Oregon-Davis Jr-Sr High School	Regular School	No	High	07	12	2019	adult							2.0	0.0				2.0							2	0				2
1761134	IN	school	1807800	7515	North Judson-San Pierre Sch Corp	180780001330	7849	N Judson-San Pierre Jr Sr High Sch	Regular School	No	High	07	12	2019	adult							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
1761663	IN	school	1803450	7995	Evansville Vanderburgh School Corp	180345002462	8270	Academy for Innovative Studies	Regular School	No	Other	01	12	2019	grade_6							7.0	0.0				7.0							7	0				7
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
1761674	IN	school	1803450	7995	Evansville Vanderburgh School Corp	180345002649	8271	Harwood Career Prep High School	Regular School	No	Other	01	12	2019	grade_6							2.0	0.0				2.0							2	0				2
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
1761882	IN	school	1812090	8030	Vigo County School Corp	181209001917	8441	Terre Haute North Vigo High School	Regular School	No	High	09	12	2019	adult							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
1762066	IN	school	1812090	8030	Vigo County School Corp	181209000926	8612	McLean Education Center (Alt)	Regular School	No	High	07	12	2019	grade_7							9.0	0.0				9.0							9	0				9
1762463	IN	school	1809510	8385	Richmond Community Schools	180951000366	9056	Community Youth Services	Special Education School	No	Other	KG	12	2019	grade_3							4.0	0.0				4.0							4	0				4
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
1762465	IN	school	1809510	8385	Richmond Community Schools	180951000366	9056	Community Youth Services	Special Education School	No	Other	KG	12	2019	grade_5							7.0	0.0				7.0							7	0				7
1762469	IN	school	1809510	8385	Richmond Community Schools	180951000366	9056	Community Youth Services	Special Education School	No	Other	KG	12	2019	grade_9							12.0	0.0				12.0							12	0				12
1762470	IN	school	1809510	8385	Richmond Community Schools	180951000366	9056	Community Youth Services	Special Education School	No	Other	KG	12	2019	kindergarten							2.0	0.0				2.0							2	0				2
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
1762539	IN	school	1808130	8515	North White School Corp	180813001396	9135	North White High School	Regular School	No	High	09	12	2019	adult							2.0	0.0				2.0							2	0				2
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
1762608	IN	school	1810230	8625	Smith-Green Community Schools	181023001638	9193	Churubusco Jr-Sr High School	Regular School	No	High	06	12	2019	adult							6.0	0.0				6.0							6	0				6
1762767	IN	school	1800006	9100	Indiana Department of Correction	180000601946	732	Logansport Juvenile Correctional	Regular School	No	High	07	12	2019	adult							21.0	0.0				21.0							21	0				21
1762769	IN	school	1800006	9100	Indiana Department of Correction	180000601946	732	Logansport Juvenile Correctional	Regular School	No	High	07	12	2019	grade_11							19.0	0.0				19.0							19	0				19
1762770	IN	school	1800006	9100	Indiana Department of Correction	180000601946	732	Logansport Juvenile Correctional	Regular School	No	High	07	12	2019	grade_12							7.0	0.0				7.0							7	0				7
1762771	IN	school	1800006	9100	Indiana Department of Correction	180000601946	732	Logansport Juvenile Correctional	Regular School	No	High	07	12	2019	grade_7							2.0	0.0				2.0							2	0				2
1762772	IN	school	1800006	9100	Indiana Department of Correction	180000601946	732	Logansport Juvenile Correctional	Regular School	No	High	07	12	2019	grade_8							11.0	0.0				11.0							11	0				11
1762773	IN	school	1800006	9100	Indiana Department of Correction	180000601946	732	Logansport Juvenile Correctional	Regular School	No	High	07	12	2019	grade_9							41.0	0.0				41.0							41	0				41
1762775	IN	school	1800006	9100	Indiana Department of Correction	180000601935	5055	Pendleton Juvenile Correctional	Regular School	No	High	07	12	2019	adult							18.0	0.0				18.0							18	0				18
1762776	IN	school	1800006	9100	Indiana Department of Correction	180000601935	5055	Pendleton Juvenile Correctional	Regular School	No	High	07	12	2019	grade_10							61.0	0.0				61.0							61	0				61
1762777	IN	school	1800006	9100	Indiana Department of Correction	180000601935	5055	Pendleton Juvenile Correctional	Regular School	No	High	07	12	2019	grade_11							15.0	0.0				15.0							15	0				15
1762778	IN	school	1800006	9100	Indiana Department of Correction	180000601935	5055	Pendleton Juvenile Correctional	Regular School	No	High	07	12	2019	grade_12							14.0	0.0				14.0							14	0				14
1762779	IN	school	1800006	9100	Indiana Department of Correction	180000601935	5055	Pendleton Juvenile Correctional	Regular School	No	High	07	12	2019	grade_7							1.0	0.0				1.0							1	0				1
1762780	IN	school	1800006	9100	Indiana Department of Correction	180000601935	5055	Pendleton Juvenile Correctional	Regular School	No	High	07	12	2019	grade_8							4.0	0.0				4.0							4	0				4
1762781	IN	school	1800006	9100	Indiana Department of Correction	180000601935	5055	Pendleton Juvenile Correctional	Regular School	No	High	07	12	2019	grade_9							100.0	0.0				100.0							100	0				100
1762782	IN	school	1800006	9100	Indiana Department of Correction	180000601935	5055	Pendleton Juvenile Correctional	Regular School	No	High	07	12	2019	pk_12_total	98.0	71.0	18.0	1.0	1.0	24.0	213.0	0.0	6.0	213.0	104.0	213.0	98	71	18	1	1	24	213	0	6	213	104	213
1762876	IN	school	1800138	9335	Excel Center - Lafayette Square	180013802554	5912	Excel Center - Lafayette Square	Regular School	Yes	High	09	12	2019	grade_10							1.0	0.0				1.0							1	0				1
1763078	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	2019	grade_2							7.0	0.0				7.0							7	0				7
1763134	IN	school	1800056	9640	Options Charter School Noblesville	180005602313	2551	Options Charter School Noblesville	Regular School	Yes	High	06	12	2019	grade_6							4.0	0.0				4.0							4	0				4
1763244	IN	school	1800131	9760	Smith Academy for Excellence	180013102539	242	Smith Academy for Excellence	Regular School	Yes	Other	04	12	2019	grade_10							11.0	0.0				11.0							11	0				11
1763245	IN	school	1800131	9760	Smith Academy for Excellence	180013102539	242	Smith Academy for Excellence	Regular School	Yes	Other	04	12	2019	grade_11							8.0	0.0				8.0							8	0				8
1763246	IN	school	1800131	9760	Smith Academy for Excellence	180013102539	242	Smith Academy for Excellence	Regular School	Yes	Other	04	12	2019	grade_12							8.0	0.0				8.0							8	0				8
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
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
1763249	IN	school	1800131	9760	Smith Academy for Excellence	180013102539	242	Smith Academy for Excellence	Regular School	Yes	Other	04	12	2019	grade_6							14.0	0.0				14.0							14	0				14
1763250	IN	school	1800131	9760	Smith Academy for Excellence	180013102539	242	Smith Academy for Excellence	Regular School	Yes	Other	04	12	2019	grade_7							7.0	0.0				7.0							7	0				7
1763251	IN	school	1800131	9760	Smith Academy for Excellence	180013102539	242	Smith Academy for Excellence	Regular School	Yes	Other	04	12	2019	grade_8							17.0	0.0				17.0							17	0				17
1763252	IN	school	1800131	9760	Smith Academy for Excellence	180013102539	242	Smith Academy for Excellence	Regular School	Yes	Other	04	12	2019	grade_9							9.0	0.0				9.0							9	0				9
1763253	IN	school	1800131	9760	Smith Academy for Excellence	180013102539	242	Smith Academy for Excellence	Regular School	Yes	Other	04	12	2019	pk_12_total	35.0	33.0	3.0			11.0	82.0	0.0	1.0	73.0	28.0	82.0	35	33	3			11	82	0	1	73	28	82
1763365	IN	school	1800106	9890	Indiana Virtual School	180010602515	2488	Indiana Virtual School	Regular School	Yes	High	06	12	2019	adult							1.0	0.0				1.0							1	0				1
1763412	IN	school	1800160	9915	Marion Academy	180016002588	5903	Marion Academy	Regular School	Yes	High	06	12	2019	grade_6							1.0	0.0				1.0							1	0				1
1763413	IN	school	1800160	9915	Marion Academy	180016002588	5903	Marion Academy	Regular School	Yes	High	06	12	2019	grade_7							2.0	0.0				2.0							2	0				2
1763421	IN	school	1800108	9920	Damar Charter Academy	180010802503	5191	Damar Charter Academy	Regular School	Yes	Other	KG	12	2019	grade_2							4.0	0.0				4.0							4	0				4
1763422	IN	school	1800108	9920	Damar Charter Academy	180010802503	5191	Damar Charter Academy	Regular School	Yes	Other	KG	12	2019	grade_3							5.0	0.0				5.0							5	0				5
1763429	IN	school	1800108	9920	Damar Charter Academy	180010802503	5191	Damar Charter Academy	Regular School	Yes	Other	KG	12	2019	kindergarten							1.0	0.0				1.0							1	0				1
1751557	IN	school	1800060	15	Adams Central Community Schools	180006000006	20	Adams Central Elementary School	Regular School	No	Elementary	PK	05	2019	pre_kindergarten							4.0	1.0				5.0							4	1				5
1752039	IN	school	1802850	255	East Allen County Schools	180285000349	49	Leo Junior/Senior High School	Regular School	No	High	07	12	2019	adult							5.0	1.0				6.0							5	1				6
1752051	IN	school	1802850	255	East Allen County Schools	180285000344	81	Heritage Jr/Sr High School	Regular School	No	High	07	12	2019	adult							6.0	1.0				7.0							6	1				7
1752342	IN	school	1802830	630	Zionsville Community Schools	180283000341	512	Zionsville Community High School	Regular School	No	High	09	12	2019	adult							9.0	1.0				10.0							9	1				10
1752468	IN	school	1801290	750	Carroll Consolidated School Corp	180129002103	629	Carroll Elementary School	Regular School	No	Elementary	PK	06	2019	pre_kindergarten							1.0	1.0				2.0							1	1				2
1752503	IN	school	1810680	815	Lewis Cass Schools	181068001755	689	Lewis Cass High School	Regular School	No	High	09	12	2019	adult							0.0	1.0				1.0							0	1				1
1752544	IN	school	1806030	875	Logansport Community Sch Corp	180603001055	709	Fairview Elementary School	Regular School	No	Elementary	PK	06	2019	grade_6							0.0	1.0				1.0							0	1				1
1752565	IN	school	1806030	875	Logansport Community Sch Corp	180603001052	715	Columbia 6th Grade Academy	Regular School	No	Middle	04	08	2019	grade_7							1.0	1.0				2.0							1	1				2
1752756	IN	school	1803940	1010	Greater Clark County Schools	180394000832	886	Old Corden Porter School	Special Education School	No	High	06	12	2019	grade_10							6.0	1.0				7.0							6	1				7
1752760	IN	school	1803940	1010	Greater Clark County Schools	180394000832	886	Old Corden Porter School	Special Education School	No	High	06	12	2019	grade_7							2.0	1.0				3.0							2	1				3
1752768	IN	school	1803940	1010	Greater Clark County Schools	180394000839	891	Clark County Middle/High School	Alternative School	No	High	07	12	2019	grade_8							5.0	1.0				6.0							5	1				6
1752897	IN	school	1809720	1180	Rossville Con School District	180972001590	1021	Rossville Middle/Senior High Sch	Regular School	No	High	06	12	2019	adult							1.0	1.0				2.0							1	1				2
1753044	IN	school	1811190	1560	Sunman-Dearborn Com Sch Corp	181119001802	7213	East Central High School	Regular School	No	High	09	12	2019	adult							5.0	1.0				6.0							5	1				6
1753077	IN	school	1800240	1600	South Dearborn Community Sch Corp	180024000056	1179	South Dearborn High School	Regular School	No	High	09	12	2019	adult							7.0	1.0				8.0							7	1				8
1753091	IN	school	1800240	1600	South Dearborn Community Sch Corp	180024000051	1197	Aurora Elementary School	Regular School	No	Elementary	PK	06	2019	pre_kindergarten							4.0	1.0				5.0							4	1				5
1753160	IN	school	1803060	1805	DeKalb Co Eastern Com Sch Dist	180306000405	1317	Eastside Junior-Senior High School	Regular School	No	High	07	12	2019	adult							1.0	1.0				2.0							1	1				2
1753184	IN	school	1803840	1820	Garrett-Keyser-Butler Com Sch Corp	180384000605	1325	Garrett High School	Regular School	No	High	09	12	2019	adult							0.0	1.0				1.0							0	1				1
1753459	IN	school	1810640	2100	Southeast Dubois Co Sch Corp	181064001745	1583	Forest Park Jr-Sr High School	Regular School	No	High	07	12	2019	adult							1.0	1.0				2.0							1	1				2
1753482	IN	school	1810870	2110	Southwest Dubois Co Sch Corp	181087001779	1588	Southridge High School	Regular School	No	High	09	12	2019	adult							2.0	1.0				3.0							2	1				3
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
1753651	IN	school	1812240	2285	Wa-Nee Community Schools	181224001958	1669	North Wood Middle School	Regular School	No	Middle	06	09	2019	grade_9							0.0	1.0				1.0							0	1				1
1753742	IN	school	1803270	2305	Elkhart Community Schools	180327002585	1752	Elkhart Alternative Education	Regular School	No	Other	02	12	2019	grade_6							5.0	1.0				6.0							5	1				6
1753806	IN	school	1803270	2305	Elkhart Community Schools	180327000437	1789	Monger Elementary School	Regular School	No	Elementary	PK	06	2019	pre_kindergarten							0.0	1.0				1.0							0	1				1
1753832	IN	school	1803930	2315	Goshen Community Schools	180393000659	1629	Goshen Middle School	Regular School	No	High	05	12	2019	grade_10							0.0	1.0				1.0							0	1				1
1753834	IN	school	1803930	2315	Goshen Community Schools	180393000659	1629	Goshen Middle School	Regular School	No	High	05	12	2019	grade_12							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
1753839	IN	school	1803930	2315	Goshen Community Schools	180393000659	1629	Goshen Middle School	Regular School	No	High	05	12	2019	grade_9							1.0	1.0				2.0							1	1				2
1754126	IN	school	1809630	2645	Rochester Community School Corp	180963001576	2173	Rochester Community High School	Regular School	No	High	09	12	2019	adult							4.0	1.0				5.0							4	1				5
1754198	IN	school	1807770	2735	North Gibson School Corporation	180777001324	2223	Princeton Comm Intermediate School	Regular School	No	Elementary	KG	05	2019	kindergarten							1.0	1.0				2.0							1	1				2
1754204	IN	school	1807770	2735	North Gibson School Corporation	180777001326	2249	Princeton Community High School	Regular School	No	High	09	12	2019	adult							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
1755168	IN	school	1802550	3325	Danville Community School Corp	180255000304	2741	Danville Community High School	Regular School	No	High	09	12	2019	adult							1.0	1.0				2.0							1	1				2
1755299	IN	school	1807440	3445	New Castle Community School Corp	180744001290	2825	New Castle High School	Regular School	No	High	07	12	2019	grade_7							1.0	1.0				2.0							1	1				2
1755333	IN	school	1807440	3445	New Castle Community School Corp	180744001289	2853	Sunnyside Elementary School	Regular School	No	Elementary	KG	03	2019	grade_3							10.0	1.0				11.0							10	1				11
1755415	IN	school	1803150	3480	Eastern Howard School Corporation	180315000412	2909	Eastern Elementary School	Regular School	No	Elementary	PK	07	2019	grade_7							0.0	1.0				1.0							0	1				1
1755423	IN	school	1803150	3480	Eastern Howard School Corporation	180315000413	2919	Eastern High School	Regular School	No	High	09	12	2019	adult							6.0	1.0				7.0							6	1				7
1755432	IN	school	1804470	3490	Western School Corporation	180447000756	2921	Western High School	Regular School	No	High	08	12	2019	grade_8							0.0	1.0				1.0							0	1				1
1755444	IN	school	1804470	3490	Western School Corporation	180447002224	2923	Western Intermediate School	Regular School	No	Middle	03	08	2019	grade_8							1.0	1.0				2.0							1	1				2
1755589	IN	school	1801230	3640	Medora Community School Corp	180123002268	3095	Medora Elementary School	Regular School	No	Elementary	PK	06	2019	grade_2							4.0	1.0				5.0							4	1				5
1755699	IN	school	1809420	3815	Rensselaer Central School Corp	180942001543	3201	Rensselaer Central High School	Regular School	No	High	09	12	2019	adult							0.0	1.0				1.0							0	1				1
1755712	IN	school	1809420	3815	Rensselaer Central School Corp	180942001542	3213	Rensselaer Central Primary School	Regular School	No	Elementary	PK	05	2019	grade_3							2.0	1.0				3.0							2	1				3
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
1756134	IN	school	1812120	4335	Vincennes Community School Corp	181212001931	3553	Lincoln High School	Regular School	No	High	09	12	2019	adult							0.0	1.0				1.0							0	1				1
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
1756666	IN	school	1802880	4670	School City of East Chicago	180288002272	3924	East Chicago Central High School	Regular School	No	High	09	12	2019	adult							0.0	1.0				1.0							0	1				1
1756841	IN	school	1804320	4710	School City of Hammond	180432000746	4417	Morton Senior High School	Regular School	No	High	09	12	2019	adult							2.0	1.0				3.0							2	1				3