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 (total_int > :p3 or (total_int = :p3 and rowid > :p2)) order by total_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	male	female	total	male_int	female_int	total_int
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
1161528	IN	school	1802400	2270	Concord Community Schools	180240000271	1713	Concord Junior High School	Regular School	No	4.0	06	12	2015	grade_6	1.0	1.0	2.0	1	1	2
1161531	IN	school	1802400	2270	Concord Community Schools	180240000271	1713	Concord Junior High School	Regular School	No	4.0	06	12	2015	grade_9	0.0	2.0	2.0	0	2	2
1161574	IN	school	1806600	2275	Middlebury Community Schools	180660001162	1657	Northridge Middle School	Regular School	No	2.0	04	09	2015	grade_5	0.0	2.0	2.0	0	2	2
1161781	IN	school	1803930	2315	Goshen Community Schools	180393000659	1629	Goshen Middle School	Regular School	No	4.0	06	10	2015	grade_9	0.0	2.0	2.0	0	2	2
1162359	IN	school	1800008	2980	White River Valley Sch Dist	180000802302	2429	White River Valley Jr/Sr High Sch	Regular School	No	3.0	07	12	2015	adult	0.0	2.0	2.0	0	2	2
1162503	IN	school	1813080	3030	Westfield-Washington Schools	181308002074	2491	Westfield Middle School	Regular School	No	2.0	06	08	2015	grade_6	2.0	0.0	2.0	2	0	2
1162763	IN	school	1810710	3115	Southern Hancock Co Com Sch Corp	181071001761	2565	New Palestine High School	Regular School	No	3.0	09	12	2015	adult	1.0	1.0	2.0	1	1	2
1163105	IN	school	1802550	3325	Danville Community School Corp	180255000306	2721	North Elementary School	Regular School	No	1.0	PK	05	2015	grade_3	1.0	1.0	2.0	1	1	2
1163111	IN	school	1802550	3325	Danville Community School Corp	180255000304	2741	Danville Community High Sch	Regular School	No	3.0	09	12	2015	adult	2.0	0.0	2.0	2	0	2
1163375	IN	school	1804470	3490	Western School Corp	180447000756	2921	Western High School	Regular School	No	4.0	04	12	2015	grade_5	2.0	0.0	2.0	2	0	2
1163646	IN	school	1809420	3815	Rensselaer Central School Corp	180942001543	3201	Rensselaer Central High Sch	Regular School	No	3.0	09	12	2015	adult	2.0	0.0	2.0	2	0	2
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
1163660	IN	school	1809420	3815	Rensselaer Central School Corp	180942001542	3213	Rensselaer Central Primary School	Regular School	No	1.0	PK	05	2015	grade_5	1.0	1.0	2.0	1	1	2
1164032	IN	school	1807620	4255	Nineveh-Hensley-Jackson United	180762001306	3409	Indian Creek Elementary Sch	Regular School	No	1.0	KG	05	2015	grade_5	2.0	0.0	2.0	2	0	2
1164268	IN	school	1813230	4455	Whitko Community School Corp	181323002087	9173	South Whitley Elementary Sch	Regular School	No	1.0	PK	05	2015	pre_kindergarten	2.0	0.0	2.0	2	0	2
1164280	IN	school	1809300	4515	Prairie Heights Com Sch Corp	180930001524	3686	Prairie Heights Elem Sch	Regular School	No	1.0	PK	04	2015	pre_kindergarten	1.0	1.0	2.0	1	1	2
1164353	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_10	1.0	1.0	2.0	1	1	2
1164354	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_11	1.0	1.0	2.0	1	1	2
1164403	IN	school	1804620	4590	River Forest Community Sch Corp	180462000778	3797	Henry S Evans Elementary Sch	Regular School	No	1.0	KG	06	2015	grade_6	2.0	0.0	2.0	2	0	2
1164797	IN	school	1803870	4690	Gary Community School Corp	180387000648	4163	West Side Leadership Academy	Regular School	No	3.0	09	12	2015	adult	2.0	0.0	2.0	2	0	2
1165020	IN	school	1804560	4720	School Town of Highland	180456000767	4290	Mildred Merkley Elem School	Regular School	No	1.0	KG	06	2015	grade_6	1.0	1.0	2.0	1	1	2
1165534	IN	school	1800120	5265	Alexandria Com School Corp	180012000009	5069	Alexandria-Monroe Elementary	Regular School	No	1.0	PK	03	2015	grade_3	1.0	1.0	2.0	1	1	2
1165537	IN	school	1800120	5265	Alexandria Com School Corp	180012000009	5069	Alexandria-Monroe Elementary	Regular School	No	1.0	PK	03	2015	pre_kindergarten	1.0	1.0	2.0	1	1	2
1165860	IN	school	1808820	5340	Perry Township Schools	180882001456	5325	Clinton Young Elem Sch	Regular School	No	1.0	PK	05	2015	pre_kindergarten	1.0	1.0	2.0	1	1	2
1165920	IN	school	1808820	5340	Perry Township Schools	180882001809	5372	Rosa Parks-Edison Elem	Regular School	No	1.0	PK	05	2015	pre_kindergarten	1.0	1.0	2.0	1	1	2
1166242	IN	school		5375	M S D Wayne Township		5271	Sanders School						2015	kindergarten	2.0	0.0	2.0	2	0	2
1166821	IN	school	1800105	5390	Southside Sp Srvs Of Marion Co	180010502502	5320	RISE Learning Center	Regular School	No	4.0	KG	12	2015	kindergarten	2.0	0.0	2.0	2	0	2
1166916	IN	school	1809060	5485	Plymouth Community School Corp	180906001503	5933	Menominee Elementary School	Regular School	No	1.0	KG	05	2015	grade_5	2.0	0.0	2.0	2	0	2
1166993	IN	school	1806060	5525	Loogootee Community Sch Corp	180606001067	6003	Loogootee High School	Regular School	No	3.0	09	12	2015	adult	0.0	2.0	2.0	0	2	2
1167511	IN	school	1807920	5945	North Newton School Corp	180792001363	6411	North Newton Jr-Sr High Sch	Regular School	No	3.0	07	12	2015	adult	2.0	0.0	2.0	2	0	2
1167543	IN	school	1801710	6055	Central Noble Com School Corp	180171000230	6453	Central Noble Junior Senior HS	Regular School	No	4.0	06	12	2015	adult	0.0	2.0	2.0	0	2	2
1167610	IN	school	1802970	6060	East Noble School Corp	180297000394	6485	Wayne Center Elem Sch	Regular School	No	1.0	PK	07	2015	grade_7	1.0	1.0	2.0	1	1	2
1168439	IN	school	1810530	6865	South Ripley Com Sch Corp	181053001729	7182	South Ripley High School	Regular School	No	3.0	09	12	2015	adult	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
1168831	IN	school	1810290	7205	South Bend Community Sch Corp	181029001878	7534	Rise Up Academy at Eggleston	Regular School	No	3.0	09	12	2015	grade_9	2.0	0.0	2.0	2	0	2
1168939	IN	school	1810290	7205	South Bend Community Sch Corp	181029002574	7617	Studebaker Center	Regular School	No	4.0	PK	12	2015	grade_11	1.0	1.0	2.0	1	1	2
1169098	IN	school	1810140	7365	Shelbyville Central Schools	181014002496	7671	Especially Kidz Health & Rehab Cnt	Regular School	No	4.0	PK	12	2015	grade_5	0.0	2.0	2.0	0	2	2
1169100	IN	school	1810140	7365	Shelbyville Central Schools	181014002496	7671	Especially Kidz Health & Rehab Cnt	Regular School	No	4.0	PK	12	2015	grade_7	0.0	2.0	2.0	0	2	2
1169105	IN	school	1810140	7365	Shelbyville Central Schools	181014002496	7671	Especially Kidz Health & Rehab Cnt	Regular School	No	4.0	PK	12	2015	pre_kindergarten	2.0	0.0	2.0	2	0	2
1169289	IN	school	1811100	7615	M S D Steuben County	181110001797	7893	Angola High School	Regular School	No	3.0	09	12	2015	adult	1.0	1.0	2.0	1	1	2
1169737	IN	school	1803450	7995	Evansville Vanderburgh Sch Corp	180345002462	8270	Academy for Innovative Studies	Regular School	No	4.0	KG	12	2015	kindergarten	1.0	1.0	2.0	1	1	2
1170119	IN	school	1812090	8030	Vigo County School Corp	181209000926	8612	McLean Education Center (Alt)	Regular School	No	4.0	06	12	2015	grade_6	2.0	0.0	2.0	2	0	2
1170333	IN	school	1809810	8205	Salem Community Schools	180981001600	8857	Salem High School	Regular School	No	3.0	09	12	2015	adult	2.0	0.0	2.0	2	0	2
1170508	IN	school	1809510	8385	Richmond Community Schools	180951000366	9056	Community Youth Services	Special Education School	No	4.0	KG	12	2015	grade_1	2.0	0.0	2.0	2	0	2
1170515	IN	school	1809510	8385	Richmond Community Schools	180951000366	9056	Community Youth Services	Special Education School	No	4.0	KG	12	2015	grade_5	2.0	0.0	2.0	2	0	2
1170520	IN	school	1809510	8385	Richmond Community Schools	180951000366	9056	Community Youth Services	Special Education School	No	4.0	KG	12	2015	kindergarten	2.0	0.0	2.0	2	0	2
1170757	IN	school	1800006	9100	IN Department of Correction	180000601935	5055	Pendleton Juv Correctional Fac	Regular School	No	3.0	08	12	2015	grade_8	2.0	0.0	2.0	2	0	2
1170763	IN	school	1800006	9100	IN Department of Correction	180000601943	5452	Madison Juvenile Corr Fac	Regular School	No	3.0	08	12	2015	grade_12	0.0	2.0	2.0	0	2	2
1170764	IN	school	1800006	9100	IN Department of Correction	180000601943	5452	Madison Juvenile Corr Fac	Regular School	No	3.0	08	12	2015	grade_8	0.0	2.0	2.0	0	2	2
1171056	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_2	2.0	0.0	2.0	2	0	2
1159634	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_10	3.0	0.0	3.0	3	0	3
1159641	IN	school	1803630	235	Fort Wayne Community Schools	180363002174	100	Allen Co Juvenile Center	Regular School	No	3.0	07	12	2015	grade_11	3.0	0.0	3.0	3	0	3
1160681	IN	school	1803940	1010	Greater Clark County Schools	180394000832	886	Old Corden Porter School	Special Education School	No	4.0	04	12	2015	grade_5	3.0	0.0	3.0	3	0	3
1160987	IN	school	1811190	1560	Sunman-Dearborn Com Sch Corp	181119001805	7211	Sunman Elementary School	Regular School	No	1.0	PK	04	2015	pre_kindergarten	2.0	1.0	3.0	2	1	3
1161036	IN	school	1805700	1620	Lawrenceburg Com School Corp	180570001037	1177	Lawrenceburg High School	Regular School	No	3.0	09	12	2015	adult	1.0	2.0	3.0	1	2	3
1161263	IN	school	1807230	1910	Yorktown Community Schools	180723001217	1389	Yorktown High School	Regular School	No	3.0	09	12	2015	adult	2.0	1.0	3.0	2	1	3
1161416	IN	school	1810640	2100	Southeast Dubois Co Sch Corp	181064001745	1583	Forest Park Jr-Sr High Sch	Regular School	No	3.0	07	12	2015	adult	1.0	2.0	3.0	1	2	3
1161458	IN	school	1803960	2120	Greater Jasper Con Schs	180396000684	1569	Ireland Elementary School	Regular School	No	1.0	PK	05	2015	pre_kindergarten	3.0	0.0	3.0	3	0	3
1161533	IN	school	1802400	2270	Concord Community Schools	180240000269	1715	Concord Community High School	Regular School	No	3.0	09	12	2015	adult	2.0	1.0	3.0	2	1	3
1161578	IN	school	1806600	2275	Middlebury Community Schools	180660001162	1657	Northridge Middle School	Regular School	No	2.0	04	09	2015	grade_9	2.0	1.0	3.0	2	1	3
1161585	IN	school	1806600	2275	Middlebury Community Schools	180660002427	1731	Heritage Intermediate School	Regular School	No	1.0	03	05	2015	grade_3	1.0	2.0	3.0	1	2	3
1162067	IN	school	1809630	2645	Rochester Community Sch Corp	180963001576	2173	Rochester Community High Sch	Regular School	No	3.0	09	12	2015	adult	1.0	2.0	3.0	1	2	3
1162301	IN	school	1800600	2920	Bloomfield School District	180060000112	2417	Bloomfield Elementary School	Regular School	No	1.0	PK	06	2015	pre_kindergarten	2.0	1.0	3.0	2	1	3
1162673	IN	school	1807650	3070	Noblesville Schools	180765002369	2514	MOSAICS School	Special Education School	No	3.0	07	12	2015	grade_10	2.0	1.0	3.0	2	1	3
1162978	IN	school	1808100	3295	North West Hendricks Schools	180810001387	2731	Tri-West Senior High School	Regular School	No	3.0	09	12	2015	adult	2.0	1.0	3.0	2	1	3
1163376	IN	school	1804470	3490	Western School Corp	180447000756	2921	Western High School	Regular School	No	4.0	04	12	2015	grade_6	1.0	2.0	3.0	1	2	3
1163378	IN	school	1804470	3490	Western School Corp	180447000756	2921	Western High School	Regular School	No	4.0	04	12	2015	grade_8	3.0	0.0	3.0	3	0	3
1163739	IN	school	1806120	3995	Madison Consolidated Schools	180612001090	3309	Madison Consolidated High Sch	Regular School	No	3.0	09	12	2015	adult	2.0	1.0	3.0	2	1	3
1164294	IN	school	1813110	4525	Westview School Corporation	181311002079	3697	Westview Jr-Sr High School	Regular School	No	4.0	06	12	2015	grade_6	3.0	0.0	3.0	3	0	3
1164355	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_12	3.0	0.0	3.0	3	0	3
1164364	IN	school	1808320	4570	Northwest Indiana Spec Ed Coop	180832002208	4287	Eagle Park Community School	Special Education School	No	4.0	KG	12	2015	kindergarten	2.0	1.0	3.0	2	1	3
1164853	IN	school	1804320	4710	School City of Hammond	180432000735	4411	George Rogers Clark Md/HS	Regular School	No	4.0	06	12	2015	adult	1.0	2.0	3.0	1	2	3
1164877	IN	school	1804320	4710	School City of Hammond	180432000746	4417	Morton Senior High School	Regular School	No	3.0	09	12	2015	adult	1.0	2.0	3.0	1	2	3
1165138	IN	school	1807560	4805	New Prairie United School Corp	180756001301	4693	Rolling Prairie Elem Sch	Regular School	No	1.0	PK	05	2015	pre_kindergarten	3.0	0.0	3.0	3	0	3
1165608	IN	school	1802640	5300	M S D Decatur Township	180264000312	5177	Decatur Central High School	Regular School	No	3.0	09	12	2015	adult	1.0	2.0	3.0	1	2	3
1165816	IN	school	1808820	5340	Perry Township Schools	180882001464	5307	Perry Meridian High School	Regular School	No	3.0	09	12	2015	adult	1.0	2.0	3.0	1	2	3
1166230	IN	school		5375	M S D Wayne Township		5271	Sanders School						2015	grade_1	2.0	1.0	3.0	2	1	3
1166234	IN	school		5375	M S D Wayne Township		5271	Sanders School						2015	grade_2	2.0	1.0	3.0	2	1	3
1167053	IN	school	1808850	5635	Peru Community Schools	180885001476	6085	Peru High School	Regular School	No	3.0	09	12	2015	adult	3.0	0.0	3.0	3	0	3
1167066	IN	school	1808850	5635	Peru Community Schools	180885001471	6093	Blair Pointe Upper Elementary	Regular School	No	1.0	KG	06	2015	grade_1	0.0	3.0	3.0	0	3	3
1167067	IN	school	1808850	5635	Peru Community Schools	180885001471	6093	Blair Pointe Upper Elementary	Regular School	No	1.0	KG	06	2015	grade_2	3.0	0.0	3.0	3	0	3
1167072	IN	school	1808850	5635	Peru Community Schools	180885001471	6093	Blair Pointe Upper Elementary	Regular School	No	1.0	KG	06	2015	kindergarten	3.0	0.0	3.0	3	0	3
1167229	IN	school	1800630	5740	Monroe County Com Sch Corp	180063002498	6220	Bloomington Graduation School	Regular School	No	3.0	09	12	2015	grade_9	0.0	3.0	3.0	0	3	3
1167315	IN	school	1802460	5855	Crawfordsville Com Schools	180246000287	6277	Crawfordsville Sr High School	Regular School	No	3.0	09	12	2015	adult	2.0	1.0	3.0	2	1	3
1167565	IN	school	1802970	6060	East Noble School Corp	180297000387	6457	Avilla Elementary School	Regular School	No	1.0	PK	07	2015	grade_7	2.0	1.0	3.0	2	1	3
1167744	IN	school	1810900	6260	Southwest Parke Com Sch Corp	181090002287	6627	Riverton Parke Jr-Sr High School	Regular School	No	3.0	07	12	2015	adult	3.0	0.0	3.0	3	0	3
1168608	IN	school	1808760	7175	Penn-Harris-Madison Sch Corp	180876001451	7353	Penn High School	Regular School	No	3.0	09	12	2015	adult	2.0	1.0	3.0	2	1	3
1168950	IN	school	1810290	7205	South Bend Community Sch Corp	181029000898	7632	Juvenile Justice Center	Alternative Education School	No	3.0	07	12	2015	grade_11	3.0	0.0	3.0	3	0	3
1168951	IN	school	1810290	7205	South Bend Community Sch Corp	181029000898	7632	Juvenile Justice Center	Alternative Education School	No	3.0	07	12	2015	grade_12	2.0	1.0	3.0	2	1	3
1169094	IN	school	1810140	7365	Shelbyville Central Schools	181014002496	7671	Especially Kidz Health & Rehab Cnt	Regular School	No	4.0	PK	12	2015	grade_12	2.0	1.0	3.0	2	1	3
1169096	IN	school	1810140	7365	Shelbyville Central Schools	181014002496	7671	Especially Kidz Health & Rehab Cnt	Regular School	No	4.0	PK	12	2015	grade_3	2.0	1.0	3.0	2	1	3
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
1169099	IN	school	1810140	7365	Shelbyville Central Schools	181014002496	7671	Especially Kidz Health & Rehab Cnt	Regular School	No	4.0	PK	12	2015	grade_6	2.0	1.0	3.0	2	1	3
1169102	IN	school	1810140	7365	Shelbyville Central Schools	181014002496	7671	Especially Kidz Health & Rehab Cnt	Regular School	No	4.0	PK	12	2015	grade_9	1.0	2.0	3.0	1	2	3
1169215	IN	school	1808460	7495	Oregon-Davis School Corp	180846001435	7831	Oregon-Davis Jr-Sr High School	Regular School	No	3.0	07	12	2015	adult	1.0	2.0	3.0	1	2	3
1169729	IN	school	1803450	7995	Evansville Vanderburgh Sch Corp	180345002462	8270	Academy for Innovative Studies	Regular School	No	4.0	KG	12	2015	grade_2	1.0	2.0	3.0	1	2	3
1169730	IN	school	1803450	7995	Evansville Vanderburgh Sch Corp	180345002462	8270	Academy for Innovative Studies	Regular School	No	4.0	KG	12	2015	grade_3	3.0	0.0	3.0	3	0	3
1170163	IN	school	1812180	8050	M S D Wabash County Schools	181218002178	8657	Sharp Creek Elementary School	Regular School	No	1.0	KG	06	2015	grade_1	3.0	0.0	3.0	3	0	3
1170414	IN	school	1801560	8360	Centerville-Abington Com Schs	180156000217	8981	Centerville Sr High School	Regular School	No	3.0	09	12	2015	adult	3.0	0.0	3.0	3	0	3
1170602	IN	school	1803810	8525	Frontier School Corporation	180381000603	9137	Frontier Jr-Sr High School	Regular School	No	3.0	07	12	2015	adult	1.0	2.0	3.0	1	2	3