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 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	white	black	hispanic	male	ell	free_and_reduced	disability	total	white_int	black_int	hispanic_int	male_int	ell_int	free_and_reduced_int	disability_int	total_int
1907160	IN	school	1803630	235	Fort Wayne Community Schools	180363002174	100	Allen Co Juvenile Center	Regular School	No	Secondary	08	11	2020	grade_10				1.0				1.0				1				1
1907161	IN	school	1803630	235	Fort Wayne Community Schools	180363002174	100	Allen Co Juvenile Center	Regular School	No	Secondary	08	11	2020	grade_11				1.0				1.0				1				1
1907162	IN	school	1803630	235	Fort Wayne Community Schools	180363002174	100	Allen Co Juvenile Center	Regular School	No	Secondary	08	11	2020	grade_8				1.0				1.0				1				1
1907163	IN	school	1803630	235	Fort Wayne Community Schools	180363002174	100	Allen Co Juvenile Center	Regular School	No	Secondary	08	11	2020	grade_9				3.0				3.0				3				3
1907164	IN	school	1803630	235	Fort Wayne Community Schools	180363002174	100	Allen Co Juvenile Center	Regular School	No	Secondary	08	11	2020	pk_12_total	2.0	3.0	1.0	6.0	0.0		2.0	6.0	2	3	1	6	0		2	6
1907962	IN	school	1806030	875	Logansport Community Sch Corp	180603001060	701	Logansport Community High School	Regular School	No	High	07	12	2020	grade_8				2.0				2.0				2				2
1907998	IN	school	1806030	875	Logansport Community Sch Corp	180603001052	715	Columbia 6th Grade Academy	Regular School	No	Other	02	09	2020	grade_2				1.0				1.0				1				1
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				2.0				2				2
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				1.0				1				1
1908004	IN	school	1806030	875	Logansport Community Sch Corp	180603001052	715	Columbia 6th Grade Academy	Regular School	No	Other	02	09	2020	grade_8				1.0				1.0				1				1
1908007	IN	school		940	West Clark Community Schools		765	Henryville Jr & Sr High School						2020	adult				1.0				1.0				1				1
1908024	IN	school		940	West Clark Community Schools		777	Silver Creek High School						2020	adult				1.0				1.0				1				1
1908059	IN	school	1801920	1000	Clarksville Community School Corp	180192000249	833	Clarksville Senior High School	Regular School	No	High	09	12	2020	adult				2.0				2.0				2				2
1908192	IN	school	1803940	1010	Greater Clark County Schools	180394000832	886	Old Corden Porter School	Special Education School	No	High	06	12	2020	grade_10				11.0				11.0				11				11
1908195	IN	school	1803940	1010	Greater Clark County Schools	180394000832	886	Old Corden Porter School	Special Education School	No	High	06	12	2020	grade_6				3.0				3.0				3				3
1908198	IN	school	1803940	1010	Greater Clark County Schools	180394000832	886	Old Corden Porter School	Special Education School	No	High	06	12	2020	grade_9				3.0				3.0				3				3
1908359	IN	school	1802440	1300	Crawford County Community Sch Corp	180244000279	1059	Crawford County High School	Regular School	No	High	09	12	2020	adult				1.0				1.0				1				1
1908508	IN	school	1800240	1600	South Dearborn Community Sch Corp	180024000056	1179	South Dearborn High School	Regular School	No	High	09	12	2020	adult				2.0				2.0				2				2
1908527	IN	school	1805700	1620	Lawrenceburg Community School Corp	180570001037	1177	Lawrenceburg High School	Regular School	No	High	08	12	2020	grade_8				1.0				1.0				1				1
1908543	IN	school	1802610	1655	Decatur County Community Schools	180261000311	1263	South Decatur Jr-Sr High School	Regular School	No	High	07	12	2020	adult				1.0				1.0				1				1
1908592	IN	school	1803060	1805	DeKalb Co Eastern Com Sch Dist	180306000405	1317	Eastside Junior-Senior High School	Regular School	No	High	07	12	2020	adult				1.0				1.0				1				1
1908756	IN	school	1807230	1910	Yorktown Community Schools	180723001217	1389	Yorktown High School	Regular School	No	High	09	12	2020	adult				2.0				2.0				2				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				2.0				2				2
1908848	IN	school	1807320	1970	Muncie Community Schools	180732001232	1524	Youth Opportunity Center	Alternative School	No	High	05	12	2020	grade_6				4.0				4.0				4				4
1908890	IN	school	1810640	2100	Southeast Dubois Co Sch Corp	181064001745	1583	Forest Park Jr-Sr High School	Regular School	No	High	07	12	2020	adult				1.0				1.0				1				1
1908952	IN	school	1803480	2155	Fairfield Community Schools	180348000491	1613	Fairfield Jr-Sr High School	Regular School	No	High	07	12	2020	adult				2.0				2.0				2				2
1909006	IN	school	1802400	2270	Concord Community Schools	180240000271	1713	Concord Junior High School	Regular School	No	Middle	07	09	2020	grade_9				2.0				2.0				2				2
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				1.0				1				1
1909082	IN	school	1812240	2285	Wa-Nee Community Schools	181224001958	1669	North Wood Middle School	Regular School	No	Middle	06	09	2020	grade_9				2.0				2.0				2				2
1909167	IN	school	1803270	2305	Elkhart Community Schools	180327002585	1752	Elkhart Alternative Education	Regular School	No	Other	KG	12	2020	grade_1				1.0				1.0				1				1
1909178	IN	school	1803270	2305	Elkhart Community Schools	180327002585	1752	Elkhart Alternative Education	Regular School	No	Other	KG	12	2020	kindergarten				1.0				1.0				1				1
1909268	IN	school	1803930	2315	Goshen Community Schools	180393000659	1629	Goshen Middle School	Regular School	No	Middle	06	09	2020	grade_9				1.0				1.0				1				1
1909316	IN	school	1803930	2315	Goshen Community Schools	180393002180	1847	Prairie View Elementary School	Regular School	No	Elementary	PK	06	2020	grade_6				1.0				1.0				1				1
1909787	IN	school		2865	Marion Community Schools		2416	Grant County Comm Justice Center						2020	grade_10				1.0				1.0				1				1
1909788	IN	school		2865	Marion Community Schools		2416	Grant County Comm Justice Center						2020	grade_8				1.0				1.0				1				1
1909789	IN	school		2865	Marion Community Schools		2416	Grant County Comm Justice Center						2020	pk_12_total	2.0			2.0	0.0		2.0	2.0	2			2	0		2	2
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				1.0				1				1
1909984	IN	school	1804260	3025	Hamilton Heights School Corp	180426000728	2477	Hamilton Heights High School	Regular School	No	High	09	12	2020	adult				1.0				1.0				1				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				1.0				1				1
1910198	IN	school	1807650	3070	Noblesville Schools	180765001311	2529	North Elementary School	Regular School	No	Elementary	PK	05	2020	pre_kindergarten				2.0				2.0				2				2
1910235	IN	school	1807650	3070	Noblesville Schools	180765002621	2546	Juvenile Services Center	Alternative School	No	High	12	12	2020	grade_12				1.0				1.0				1				1
1910236	IN	school	1807650	3070	Noblesville Schools	180765002621	2546	Juvenile Services Center	Alternative School	No	High	12	12	2020	pk_12_total	1.0			1.0	0.0	1.0	0.0	1.0	1			1	0	1	0	1
1910349	IN	school	1803120	3145	Eastern Hancock Co Com Sch Corp	180312000410	2585	Eastern Hancock High School	Regular School	No	High	09	12	2020	adult				1.0				1.0				1				1
1910390	IN	school	1800690	3180	North Harrison Com School Corp	180069000144	2629	North Harrison High School	Regular School	No	High	09	12	2020	adult				1.0				1.0				1				1
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				1.0				1				1
1910817	IN	school	1811250	3460	Taylor Community School Corp	181125001814	2894	Taylor High School	Regular School	No	High	09	12	2020	adult				1.0				1.0				1				1
1910870	IN	school	1803150	3480	Eastern Howard School Corporation	180315000413	2919	Eastern High School	Regular School	No	High	09	12	2020	adult				1.0				1.0				1				1
1910890	IN	school	1804470	3490	Western School Corporation	180447002224	2923	Western Intermediate School	Regular School	No	Middle	03	08	2020	grade_8				1.0				1.0				1				1
1910894	IN	school	1804470	3490	Western School Corporation	180447000755	2935	Western Primary School	Regular School	No	Elementary	KG	03	2020	grade_3				1.0				1.0				1				1
1911145	IN	school	1809420	3815	Rensselaer Central School Corp	180942001543	3201	Rensselaer Central High School	Regular School	No	High	09	12	2020	adult				1.0				1.0				1				1
1911151	IN	school	1809420	3815	Rensselaer Central School Corp	180942001545	3205	Van Rensselaer Elementary School	Regular School	No	Elementary	01	06	2020	grade_1				1.0				1.0				1				1
1911155	IN	school	1809420	3815	Rensselaer Central School Corp	180942001545	3205	Van Rensselaer Elementary School	Regular School	No	Elementary	01	06	2020	grade_6				1.0				1.0				1				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				2.0				2				2
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				3.0				3				3
1911428	IN	school	1803240	4215	Edinburgh Community School Corp	180324000422	3447	Edinburgh Community High School	Regular School	No	High	09	12	2020	adult				1.0				1.0				1				1
1911791	IN	school	1809300	4515	Prairie Heights Community Sch Corp	180930001526	3690	Prairie Heights Sr High School	Regular School	No	High	09	12	2020	adult				1.0				1.0				1				1
1912192	IN	school	1803870	4690	Gary Community School Corp	180387002684	4068	Gary Virtual Academy	Regular School	No	Other	02	09	2020	grade_6				1.0				1.0				1				1
1912193	IN	school	1803870	4690	Gary Community School Corp	180387002684	4068	Gary Virtual Academy	Regular School	No	Other	02	09	2020	grade_7				2.0				2.0				2				2
1912215	IN	school	1803870	4690	Gary Community School Corp	180387000648	4163	West Side Leadership Academy	Regular School	No	High	09	12	2020	adult				1.0				1.0				1				1
1912466	IN	school	1804590	4730	School City of Hobart	180459000214	4327	Joan Martin Elementary School	Regular School	No	Elementary	01	06	2020	grade_6				1.0				1.0				1				1
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				1.0				1				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				1.0				1				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				2.0				2				2
1913635	IN	school		5375	M S D Wayne Township		5271	Sanders School						2020	grade_1				4.0				4.0				4				4
1913637	IN	school		5375	M S D Wayne Township		5271	Sanders School						2020	grade_11				4.0				4.0				4				4
1913640	IN	school		5375	M S D Wayne Township		5271	Sanders School						2020	grade_3				6.0				6.0				6				6
1913642	IN	school		5375	M S D Wayne Township		5271	Sanders School						2020	grade_5				3.0				3.0				3				3
1913708	IN	school	1804770	5385	Indianapolis Public Schools	180477002651	108	Impact Academy	Regular School	No	Other	03	12	2020	grade_4				4.0				4.0				4				4
1913709	IN	school	1804770	5385	Indianapolis Public Schools	180477002651	108	Impact Academy	Regular School	No	Other	03	12	2020	grade_5				2.0				2.0				2				2
1914398	IN	school	1808340	5625	Oak Hill United School Corp	180834001432	6081	Sweetser Elementary School	Regular School	No	Elementary	KG	04	2020	grade_1				2.0				2.0				2				2
1914402	IN	school	1808340	5625	Oak Hill United School Corp	180834001432	6081	Sweetser Elementary School	Regular School	No	Elementary	KG	04	2020	kindergarten				2.0				2.0				2				2
1914414	IN	school	1808850	5635	Peru Community Schools	180885001471	6093	Blair Pointe Upper Elementary	Regular School	No	Elementary	01	07	2020	grade_1				1.0				1.0				1				1
1914420	IN	school	1808850	5635	Peru Community Schools	180885001471	6093	Blair Pointe Upper Elementary	Regular School	No	Elementary	01	07	2020	grade_7				3.0				3.0				3				3
1914429	IN	school	1809480	5705	Richland-Bean Blossom C S C	180948001546	6146	Edgewood High School	Regular School	No	High	09	12	2020	adult				5.0				5.0				5				5
1914550	IN	school	1800630	5740	Monroe County Community Sch Corp	180063002613	6199	Hoosier Hills Childcare Center	Regular School	No	Prekindergarten	PK	PK	2020	pk_12_total	6.0			6.0	0.0	1.0	0.0	6.0	6			6	0	1	0	6
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				6.0				6				6
1914851	IN	school	1807920	5945	North Newton School Corp	180792001363	6411	North Newton Jr-Sr High School	Regular School	No	High	07	12	2020	adult				2.0				2.0				2				2
1915107	IN	school	1801170	6340	Cannelton City Schools	180117000191	6733	Cannelton Elementary & High School	Regular School	No	Other	PK	12	2020	adult				1.0				1.0				1				1
1915313	IN	school	1811700	6530	Union Township School Corp	181170001873	6841	Wheeler High School	Regular School	No	High	09	12	2020	adult				1.0				1.0				1				1
1915610	IN	school	1807980	6715	North Putnam Community Schools	180798001369	7061	North Putnam Sr High School	Regular School	No	High	09	12	2020	adult				1.0				1.0				1				1
1915616	IN	school	1802220	6750	Cloverdale Community Schools	180222000265	7077	Cloverdale High School	Regular School	No	High	09	12	2020	adult				1.0				1.0				1				1
1915639	IN	school	1803990	6755	Greencastle Community School Corp	180399000689	7093	Greencastle Middle School	Regular School	No	Middle	06	10	2020	grade_10				1.0				1.0				1				1
1915643	IN	school	1803990	6755	Greencastle Community School Corp	180399000689	7093	Greencastle Middle School	Regular School	No	Middle	06	10	2020	grade_9				1.0				1.0				1				1
1915778	IN	school	1810530	6865	South Ripley Com Sch Corp	181053001729	7182	South Ripley High School	Regular School	No	High	09	12	2020	adult				3.0				3.0				3				3
1916025	IN	school	1806840	7200	School City of Mishawaka	180684000531	7467	Oaklawn Campus Program	Special Education School	No	High	06	12	2020	grade_6				1.0				1.0				1				1
1916026	IN	school	1806840	7200	School City of Mishawaka	180684000531	7467	Oaklawn Campus Program	Special Education School	No	High	06	12	2020	grade_7				5.0				5.0				5				5
1916154	IN	school	1810290	7205	South Bend Community School Corp	181029001878	7534	Rise Up Academy at Eggleston	Regular School	No	High	10	12	2020	grade_10				2.0				2.0				2				2
1916267	IN	school	1810290	7205	South Bend Community School Corp	181029000898	7632	Juvenile Justice Center	Alternative School	No	Secondary	06	11	2020	grade_10				3.0				3.0				3				3
1916269	IN	school	1810290	7205	South Bend Community School Corp	181029000898	7632	Juvenile Justice Center	Alternative School	No	Secondary	06	11	2020	grade_6				2.0				2.0				2				2
1916270	IN	school	1810290	7205	South Bend Community School Corp	181029000898	7632	Juvenile Justice Center	Alternative School	No	Secondary	06	11	2020	grade_7				1.0				1.0				1				1
1916271	IN	school	1810290	7205	South Bend Community School Corp	181029000898	7632	Juvenile Justice Center	Alternative School	No	Secondary	06	11	2020	grade_8				1.0				1.0				1				1
1916272	IN	school	1810290	7205	South Bend Community School Corp	181029000898	7632	Juvenile Justice Center	Alternative School	No	Secondary	06	11	2020	grade_9				6.0				6.0				6				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				4.0				4				4
1916542	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	2020	adult				1.0				1.0				1				1
1917061	IN	school	1803450	7995	Evansville Vanderburgh School Corp	180345002462	8270	Academy for Innovative Studies	Regular School	No	Other	01	12	2020	grade_1				5.0				5.0				5				5
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				13.0				13				13
1917239	IN	school	1808070	8010	North Vermillion Com Sch Corp	180807001384	8394	North Vermillion High School	Regular School	No	High	07	12	2020	adult				1.0				1.0				1				1
1917288	IN	school	1812090	8030	Vigo County School Corp	181209001917	8441	Terre Haute North Vigo High School	Regular School	No	High	09	12	2020	adult				2.0				2.0				2				2
1917323	IN	school	1812090	8030	Vigo County School Corp	181209002676	8483	Vigo Virtual School Academy	Regular School	No	High	06	12	2020	grade_6				1.0				1.0				1				1
1917324	IN	school	1812090	8030	Vigo County School Corp	181209002676	8483	Vigo Virtual School Academy	Regular School	No	High	06	12	2020	grade_7				1.0				1.0				1				1
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				1.0				1				1