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 total 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	male	female	ell	disability	total	white_int	male_int	female_int	ell_int	disability_int	total_int
1751720	IN	school	1803630	235	Fort Wayne Community Schools	180363002174	100	Allen Co Juvenile Center	Regular School	No	High	08	12	2019	grade_11		1.0	0.0			1.0		1	0			1
1751721	IN	school	1803630	235	Fort Wayne Community Schools	180363002174	100	Allen Co Juvenile Center	Regular School	No	High	08	12	2019	grade_12		1.0	0.0			1.0		1	0			1
1751722	IN	school	1803630	235	Fort Wayne Community Schools	180363002174	100	Allen Co Juvenile Center	Regular School	No	High	08	12	2019	grade_8		1.0	0.0			1.0		1	0			1
1751723	IN	school	1803630	235	Fort Wayne Community Schools	180363002174	100	Allen Co Juvenile Center	Regular School	No	High	08	12	2019	grade_9		1.0	0.0			1.0		1	0			1
1752117	IN	school	1802850	255	East Allen County Schools	180285002532	394	East Allen University	Regular School	No	High	09	12	2019	adult		1.0	0.0			1.0		1	0			1
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
1752528	IN	school	1806030	875	Logansport Community Sch Corp	180603001058	702	Logansport Junior High School	Regular School	No	Middle	06	08	2019	grade_6		1.0	0.0			1.0		1	0			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
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
1753111	IN	school	1802610	1655	Decatur County Community Schools	180261000311	1263	South Decatur Jr-Sr High School	Regular School	No	High	07	12	2019	adult		1.0	0.0			1.0		1	0			1
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
1753325	IN	school	1807230	1910	Yorktown Community Schools	180723001217	1389	Yorktown High School	Regular School	No	High	09	12	2019	adult		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
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
1753617	IN	school	1806600	2275	Middlebury Community Schools	180660001162	1657	Northridge Middle School	Regular School	No	Middle	06	10	2019	grade_10		1.0	0.0			1.0		1	0			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
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
1753833	IN	school	1803930	2315	Goshen Community Schools	180393000659	1629	Goshen Middle School	Regular School	No	High	05	12	2019	grade_11		1.0	0.0			1.0		1	0			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
1753888	IN	school	1803930	2315	Goshen Community Schools	180393002180	1847	Prairie View Elementary School	Regular School	No	Elementary	PK	07	2019	grade_7		1.0	0.0			1.0		1	0			1
1754194	IN	school	1807770	2735	North Gibson School Corporation	180777001324	2223	Princeton Comm Intermediate School	Regular School	No	Elementary	KG	05	2019	grade_2		1.0	0.0			1.0		1	0			1
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
1754356	IN	school		2865	Marion Community Schools		2416	Grant County Comm Justice Center						2019	grade_11		1.0	0.0			1.0		1	0			1
1754357	IN	school		2865	Marion Community Schools		2416	Grant County Comm Justice Center						2019	pk_12_total	1.0	1.0	0.0	0.0	0.0	1.0	1	1	0	0	0	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
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
1755165	IN	school	1802550	3325	Danville Community School Corp	180255000306	2721	North Elementary School	Regular School	No	Elementary	KG	03	2019	grade_3		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
1755179	IN	school	1802550	3325	Danville Community School Corp	180255000305	2743	Danville Middle School	Regular School	No	Other	04	09	2019	grade_9		1.0	0.0			1.0		1	0			1
1755300	IN	school	1807440	3445	New Castle Community School Corp	180744001290	2825	New Castle High School	Regular School	No	High	07	12	2019	grade_8		1.0	0.0			1.0		1	0			1
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
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
1755443	IN	school	1804470	3490	Western School Corporation	180447002224	2923	Western Intermediate School	Regular School	No	Middle	03	08	2019	grade_7		1.0	0.0			1.0		1	0			1
1755448	IN	school	1804470	3490	Western School Corporation	180447000755	2935	Western Primary School	Regular School	No	Elementary	KG	03	2019	grade_3		1.0	0.0			1.0		1	0			1
1755646	IN	school	1801050	3695	Brownstown Cnt Com Sch Corp	180105000180	3126	Brownstown Central High School	Regular School	No	High	09	12	2019	adult		1.0	0.0			1.0		1	0			1
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
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
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
1755777	IN	school	1806120	3995	Madison Consolidated Schools	180612001090	3309	Madison Consolidated High School	Regular School	No	High	08	12	2019	grade_8		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
1755978	IN	school	1803240	4215	Edinburgh Community School Corp	180324000422	3447	Edinburgh Community High School	Regular School	No	High	09	12	2019	adult		1.0	0.0			1.0		1	0			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
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
1756578	IN	school	1811460	4645	Tri-Creek School Corporation	181146001852	3865	Lowell Senior High School	Regular School	No	High	09	12	2019	adult		1.0	0.0			1.0		1	0			1
1756584	IN	school	1805460	4650	Lake Ridge New Tech Schools	180546000989	3869	Calumet New Tech High School	Regular School	No	High	09	12	2019	adult		1.0	0.0			1.0		1	0			1
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
1757030	IN	school	1804590	4730	School City of Hobart	180459000214	4327	Joan Martin Elementary School	Regular School	No	Elementary	KG	06	2019	kindergarten		1.0	0.0			1.0		1	0			1
1757481	IN	school	1810440	5255	South Madison Com Sch Corp	181044001676	5064	Maple Ridge Elementary School	Regular School	No	Elementary	PK	06	2019	pre_kindergarten		1.0	0.0			1.0		1	0			1
1758219	IN	school		5375	M S D Wayne Township		5271	Sanders School						2019	kindergarten		1.0	0.0			1.0		1	0			1
1758816	IN	school	1800180	5470	Argos Community Schools	180018000048	5937	Argos Comm Jr-Sr High School	Regular School	No	High	07	12	2019	adult		1.0	0.0			1.0		1	0			1
1758893	IN	school	1810170	5520	Shoals Community School Corp	181017001635	5985	Shoals Community High School	Regular School	No	High	09	12	2019	adult		1.0	0.0			1.0		1	0			1
1758980	IN	school	1808340	5625	Oak Hill United School Corp	180834001432	6081	Sweetser Elementary School	Regular School	No	Elementary	KG	04	2019	grade_1		0.0	1.0			1.0		0	1			1
1758981	IN	school	1808340	5625	Oak Hill United School Corp	180834001432	6081	Sweetser Elementary School	Regular School	No	Elementary	KG	04	2019	grade_2		1.0	0.0			1.0		1	0			1
1758984	IN	school	1808340	5625	Oak Hill United School Corp	180834001432	6081	Sweetser Elementary School	Regular School	No	Elementary	KG	04	2019	kindergarten		1.0	0.0			1.0		1	0			1
1758998	IN	school	1808850	5635	Peru Community Schools	180885001471	6093	Blair Pointe Upper Elementary	Regular School	No	Elementary	KG	06	2019	grade_2		0.0	1.0			1.0		0	1			1
1759003	IN	school	1808850	5635	Peru Community Schools	180885001471	6093	Blair Pointe Upper Elementary	Regular School	No	Elementary	KG	06	2019	kindergarten		1.0	0.0			1.0		1	0			1
1759081	IN	school	1800630	5740	Monroe County Community Sch Corp	180063000119	6168	Bloomington High School North	Regular School	No	High	09	12	2019	adult		0.0	1.0			1.0		0	1			1
1759220	IN	school	1810450	5845	South Montgomery Com Sch Corp	181045001714	6233	Ladoga Elementary School	Regular School	No	Elementary	PK	05	2019	pre_kindergarten		1.0	0.0			1.0		1	0			1
1759271	IN	school	1804140	5900	Monroe-Gregg School District	180414000716	6321	Monrovia High School	Regular School	No	High	09	12	2019	adult		0.0	1.0			1.0		0	1			1
1759307	IN	school	1806510	5925	M S D Martinsville Schools	180651001132	6309	Green Township Elementary School	Regular School	No	Elementary	PK	04	2019	pre_kindergarten		1.0	0.0			1.0		1	0			1
1759314	IN	school	1806510	5925	M S D Martinsville Schools	180651002600	6332	John R. Wooden Middle School	Regular School	No	Middle	06	08	2019	grade_6		1.0	0.0			1.0		1	0			1
1759334	IN	school	1806510	5925	M S D Martinsville Schools	180651001129	6341	Centerton Elementary School	Regular School	No	Elementary	PK	04	2019	pre_kindergarten		1.0	0.0			1.0		1	0			1
1759468	IN	school	1801710	6055	Central Noble Com School Corp	180171000230	6453	Central Noble Junior Senior HS	Regular School	No	High	06	12	2019	adult		0.0	1.0			1.0		0	1			1
1759743	IN	school	1800118	6375	North Central Parke Comm Schl Corp	180011801857	6647	Turkey Run Elementary School	Regular School	No	Elementary	PK	05	2019	pre_kindergarten		0.0	1.0			1.0		0	1			1
1759904	IN	school	1811700	6530	Union Township School Corp	181170001873	6841	Wheeler High School	Regular School	No	High	09	12	2019	adult		1.0	0.0			1.0		1	0			1
1760101	IN	school	1807950	6600	M S D North Posey Co Schools	180795001366	6975	North Posey High School	Regular School	No	High	09	12	2019	adult		1.0	0.0			1.0		1	0			1
1760223	IN	school	1803990	6755	Greencastle Community School Corp	180399000690	7089	Greencastle Senior High School	Regular School	No	High	09	12	2019	adult		1.0	0.0			1.0		1	0			1
1760232	IN	school	1803990	6755	Greencastle Community School Corp	180399000689	7093	Greencastle Middle School	Regular School	No	Middle	06	09	2019	grade_9		1.0	0.0			1.0		1	0			1
1760289	IN	school	1810740	6805	Randolph Southern School Corp	181074001763	7121	Randolph Southern Jr-Sr High Sch	Regular School	No	High	07	12	2019	adult		1.0	0.0			1.0		1	0			1
1760367	IN	school	1810530	6865	South Ripley Com Sch Corp	181053001729	7182	South Ripley High School	Regular School	No	High	09	12	2019	adult		1.0	0.0			1.0		1	0			1
1760373	IN	school	1800390	6895	Batesville Community School Corp	180039000084	7217	Batesville High School	Regular School	No	High	09	12	2019	adult		0.0	1.0			1.0		0	1			1
1760470	IN	school	1809120	7150	John Glenn School Corporation	180912001505	7453	John Glenn High School	Regular School	No	High	09	12	2019	adult		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
1760615	IN	school	1806840	7200	School City of Mishawaka	180684000531	7467	Oaklawn Campus Program	Special Education School	No	Other	04	12	2019	grade_6		1.0	0.0			1.0		1	0			1
1760747	IN	school	1810290	7205	South Bend Community School Corp	181029001878	7534	Rise Up Academy at Eggleston	Regular School	No	High	09	12	2019	grade_9		0.0	1.0			1.0		0	1			1
1760969	IN	school	1808310	7350	Northwestern Con School Corp	180831001423	7689	Triton Central High School	Regular School	No	High	09	12	2019	adult		1.0	0.0			1.0		1	0			1
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
1761010	IN	school	1810140	7365	Shelbyville Central Schools	181014002496	7671	Especially Kidz Health & Rehab Cnt	Regular School	No	Other	PK	12	2019	grade_7		0.0	1.0			1.0		0	1			1
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
1761520	IN	school	1808040	7935	Tri-Central Community Schools	180804001379	8155	Tri Central Middle-High School	Regular School	No	High	06	12	2019	adult		0.0	1.0			1.0		0	1			1
1761668	IN	school	1803450	7995	Evansville Vanderburgh School Corp	180345002649	8271	Harwood Career Prep High School	Regular School	No	Other	01	12	2019	grade_1		0.0	1.0			1.0		0	1			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
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
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
1762569	IN	school	1811430	8535	Tri-County School Corporation	181143001846	9141	Tri-County Jr/Sr High School	Regular School	No	High	06	12	2019	grade_6		0.0	1.0			1.0		0	1			1
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
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
1762879	IN	school	1800138	9335	Excel Center - Lafayette Square	180013802554	5912	Excel Center - Lafayette Square	Regular School	Yes	High	09	12	2019	grade_9		0.0	1.0			1.0		0	1			1
1763165	IN	school	1800064	9670	Indianapolis Metropolitan High Sch	180006402408	5664	Indianapolis Metropolitan High Sch	Regular School	Yes	High	09	12	2019	adult		0.0	1.0			1.0		0	1			1
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
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
1763534	IN	school	1800175	9995	Excel Center - Shelbyville	180017502606	1117	Excel Center - Shelbyville	Regular School	Yes	High	10	12	2019	grade_10		0.0	1.0			1.0		0	1			1
1751871	IN	school	1803630	235	Fort Wayne Community Schools	180363000533	164	J Wilbur Haley Elementary School	Regular School	No	Elementary	PK	05	2019	pre_kindergarten		8.0	2.0			10.0		8	2			10
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
1752762	IN	school	1803940	1010	Greater Clark County Schools	180394000832	886	Old Corden Porter School	Special Education School	No	High	06	12	2019	grade_9		8.0	2.0			10.0		8	2			10
1753722	IN	school	1803270	2305	Elkhart Community Schools	180327000424	1693	Bristol Elementary School	Regular School	No	Elementary	PK	06	2019	pre_kindergarten		3.0	7.0			10.0		3	7			10
1754173	IN	school	1802940	2725	East Gibson School Corporation	180294000382	2201	Francisco Elementary School	Regular School	No	Elementary	KG	06	2019	grade_3		2.0	8.0			10.0		2	8			10