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 and (district_nces_id > :p3 or (district_nces_id = :p3 and rowid > :p2)) order by district_nces_id, 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
1163079	IN	school	1800270	3315	Avon Community School Corp	180027000057	2737	Avon High School	Regular School	No	3.0	09	12	2015	adult	7.0	1.0	8.0	7	1	8
1284485	IN	school	1800270	3315	Avon Community School Corp	180027000057	2737	Avon High School	Regular School	No	3.0	09	12	2016	adult	8.0	2.0	10.0	8	2	10
1296523	IN	school	1800270	3315	Avon Community School Corp	180027000057	2737	Avon High School	Regular School	No	High	09	12	2017	adult	10.0	6.0	16.0	10	6	16
1755139	IN	school	1800270	3315	Avon Community School Corp	180027000057	2737	Avon High School	Regular School	No	High	09	12	2019	adult	13.0	8.0	21.0	13	8	21
1790877	IN	school	1800270	3315	Avon Community School Corp	180027000057	2737	Avon High School	Regular School	No	High	09	12	2018	adult	10.0	7.0	17.0	10	7	17
1910584	IN	school	1800270	3315	Avon Community School Corp	180027000057	2737	Avon High School	Regular School	No	High	09	12	2020	adult	11.0	7.0	18.0	11	7	18
1922536	IN	school	1800270	3315	Avon Community School Corp	180027000057	2737	Avon High School	Regular School	No	High	09	12	2021	adult	4.0	3.0	7.0	4	3	7
1168445	IN	school	1800390	6895	Batesville Community Sch Corp	180039000084	7217	Batesville High School	Regular School	No	3.0	09	12	2015	adult	3.0	2.0	5.0	3	2	5
1289840	IN	school	1800390	6895	Batesville Community School Corp	180039000084	7217	Batesville High School	Regular School	No	3.0	09	12	2016	adult	1.0	0.0	1.0	1	0	1
1301863	IN	school	1800390	6895	Batesville Community School Corp	180039000084	7217	Batesville High School	Regular School	No	High	09	12	2017	adult	1.0	1.0	2.0	1	1	2
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
1796181	IN	school	1800390	6895	Batesville Community School Corp	180039000084	7217	Batesville High School	Regular School	No	High	09	12	2018	adult	2.0	2.0	4.0	2	2	4
1915784	IN	school	1800390	6895	Batesville Community School Corp	180039000084	7217	Batesville High School	Regular School	No	High	09	12	2020	adult	2.0	2.0	4.0	2	2	4
1927709	IN	school	1800390	6895	Batesville Community School Corp	180039000084	7217	Batesville High School	Regular School	No	High	09	12	2021	adult	1.0	1.0	2.0	1	1	2
1161509	IN	school	1800420	2260	Baugo Community Schools	180042000090	1701	Jimtown High School	Regular School	No	3.0	09	12	2015	adult	0.0	1.0	1.0	0	1	1
1908986	IN	school	1800420	2260	Baugo Community Schools	180042000090	1701	Jimtown High School	Regular School	No	High	09	12	2020	adult	3.0	1.0	4.0	3	1	4
1920956	IN	school	1800420	2260	Baugo Community Schools	180042000090	1701	Jimtown High School	Regular School	No	High	09	12	2021	adult	2.0	1.0	3.0	2	1	3
1758254	IN	school	1800450	5380	Beech Grove City Schools	180045000093	5449	Beech Grove Sr High School	Regular School	No	High	09	12	2019	adult	0.0	2.0	2.0	0	2	2
1794044	IN	school	1800450	5380	Beech Grove City Schools	180045000093	5449	Beech Grove Sr High School	Regular School	No	High	09	12	2018	adult	0.0	1.0	1.0	0	1	1
1913683	IN	school	1800450	5380	Beech Grove City Schools	180045000093	5449	Beech Grove Sr High School	Regular School	No	High	09	12	2020	adult	0.0	1.0	1.0	0	1	1
1788035	IN	school	1800570	515	Blackford County Schools	180057000102	489	Blackford High School	Regular School	No	High	09	12	2018	adult	0.0	1.0	1.0	0	1	1
1162302	IN	school	1800600	2920	Bloomfield School District	180060000113	2419	Bloomfield Jr-Sr High School	Regular School	No	3.0	07	12	2015	adult	1.0	0.0	1.0	1	0	1
1283714	IN	school	1800600	2920	Bloomfield School District	180060000113	2419	Bloomfield Jr-Sr High School	Regular School	No	3.0	07	12	2016	adult	2.0	0.0	2.0	2	0	2
1790101	IN	school	1800600	2920	Bloomfield School District	180060000113	2419	Bloomfield Jr-Sr High School	Regular School	No	High	07	12	2018	adult	1.0	0.0	1.0	1	0	1
1167150	IN	school	1800630	5740	Monroe County Com Sch Corp	180063000120	6166	Bloomington High School South	Regular School	No	3.0	09	12	2015	adult	2.0	4.0	6.0	2	4	6
1167156	IN	school	1800630	5740	Monroe County Com Sch Corp	180063000119	6168	Bloomington High School North	Regular School	No	3.0	09	12	2015	adult	3.0	1.0	4.0	3	1	4
1288548	IN	school	1800630	5740	Monroe County Com Sch Corp	180063000120	6166	Bloomington High School South	Regular School	No	3.0	09	12	2016	adult	4.0	3.0	7.0	4	3	7
1288554	IN	school	1800630	5740	Monroe County Com Sch Corp	180063000119	6168	Bloomington High School North	Regular School	No	3.0	09	12	2016	adult	2.0	0.0	2.0	2	0	2
1300576	IN	school	1800630	5740	Monroe County Community Sch Corp	180063000120	6166	Bloomington High School South	Regular School	No	High	09	12	2017	adult	4.0	4.0	8.0	4	4	8
1300582	IN	school	1800630	5740	Monroe County Community Sch Corp	180063000119	6168	Bloomington High School North	Regular School	No	High	09	12	2017	adult	2.0	0.0	2.0	2	0	2
1759075	IN	school	1800630	5740	Monroe County Community Sch Corp	180063000120	6166	Bloomington High School South	Regular School	No	High	09	12	2019	adult	5.0	4.0	9.0	5	4	9
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
1794893	IN	school	1800630	5740	Monroe County Community Sch Corp	180063000120	6166	Bloomington High School South	Regular School	No	High	09	12	2018	adult	3.0	4.0	7.0	3	4	7
1794899	IN	school	1800630	5740	Monroe County Community Sch Corp	180063000119	6168	Bloomington High School North	Regular School	No	High	09	12	2018	adult	0.0	1.0	1.0	0	1	1
1926369	IN	school	1800630	5740	Monroe County Community Sch Corp	180063000120	6166	Bloomington High School South	Regular School	No	High	09	12	2021	adult	7.0	5.0	12.0	7	5	12
1926375	IN	school	1800630	5740	Monroe County Community Sch Corp	180063000119	6168	Bloomington High School North	Regular School	No	High	09	12	2021	adult	3.0	0.0	3.0	3	0	3
1296335	IN	school	1800690	3180	North Harrison Com School Corp	180069000144	2629	North Harrison High School	Regular School	No	High	09	12	2017	adult	3.0	2.0	5.0	3	2	5
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	0.0	1.0	1	0	1
1917931	IN	school	1800720	8445	M S D Bluffton-Harrison	180072000146	9089	Bluffton High School	Regular School	No	High	09	12	2020	adult	0.0	1.0	1.0	0	1	1
1166896	IN	school	1800900	5480	Bremen Public Schools	180090000168	5941	Bremen Senior High School	Regular School	No	3.0	09	12	2015	adult	1.0	0.0	1.0	1	0	1
1914241	IN	school	1800900	5480	Bremen Public Schools	180090000168	5941	Bremen Senior High School	Regular School	No	High	09	12	2020	adult	0.0	1.0	1.0	0	1	1
1160350	IN	school	1800960	670	Brown County School Corporation	180096000169	573	Brown County High School	Regular School	No	3.0	09	12	2015	adult	2.0	2.0	4.0	2	2	4
1281747	IN	school	1800960	670	Brown County School Corporation	180096000169	573	Brown County High School	Regular School	No	3.0	09	12	2016	adult	5.0	2.0	7.0	5	2	7
1293802	IN	school	1800960	670	Brown County School Corporation	180096000169	573	Brown County High School	Regular School	No	High	09	12	2017	adult	3.0	0.0	3.0	3	0	3
1788171	IN	school	1800960	670	Brown County School Corporation	180096000169	573	Brown County High School	Regular School	No	High	09	12	2018	adult	2.0	1.0	3.0	2	1	3
1907860	IN	school	1800960	670	Brown County School Corporation	180096000169	573	Brown County High School	Regular School	No	High	09	12	2020	adult	0.0	1.0	1.0	0	1	1
1919826	IN	school	1800960	670	Brown County School Corporation	180096000169	573	Brown County High School	Regular School	No	High	09	12	2021	adult	0.0	1.0	1.0	0	1	1
1162993	IN	school	1801020	3305	Brownsburg Community Sch Corp	180102000176	2709	Brownsburg High School	Regular School	No	3.0	09	12	2015	adult	5.0	1.0	6.0	5	1	6
1284398	IN	school	1801020	3305	Brownsburg Community Sch Corp	180102000176	2709	Brownsburg High School	Regular School	No	3.0	09	12	2016	adult	13.0	4.0	17.0	13	4	17
1296436	IN	school	1801020	3305	Brownsburg Community School Corp	180102000176	2709	Brownsburg High School	Regular School	No	High	09	12	2017	adult	12.0	5.0	17.0	12	5	17
1755044	IN	school	1801020	3305	Brownsburg Community School Corp	180102000176	2709	Brownsburg High School	Regular School	No	High	09	12	2019	adult	9.0	4.0	13.0	9	4	13
1790789	IN	school	1801020	3305	Brownsburg Community School Corp	180102000176	2709	Brownsburg High School	Regular School	No	High	09	12	2018	adult	12.0	6.0	18.0	12	6	18
1910490	IN	school	1801020	3305	Brownsburg Community School Corp	180102000176	2709	Brownsburg High School	Regular School	No	High	09	12	2020	adult	4.0	5.0	9.0	4	5	9
1922440	IN	school	1801020	3305	Brownsburg Community School Corp	180102000176	2709	Brownsburg High School	Regular School	No	High	09	12	2021	adult	6.0	4.0	10.0	6	4	10
1285000	IN	school	1801050	3695	Brownstown Cnt Com Sch Corp	180105000180	3126	Brownstown Central High School	Regular School	No	3.0	09	12	2016	adult	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
1791391	IN	school	1801050	3695	Brownstown Cnt Com Sch Corp	180105001408	3108	Jackson Co Juvenile Detention Cntr	Alternative School	No	High	08	12	2018	adult	1.0	0.0	1.0	1	0	1
1915107	IN	school	1801170	6340	Cannelton City Schools	180117000191	6733	Cannelton Elementary & High School	Regular School	No	Other	PK	12	2020	adult	1.0	0.0	1.0	1	0	1
1293832	IN	school	1801290	750	Carroll Consolidated School Corp	180129000203	621	Carroll Senior High School	Regular School	No	High	09	12	2017	adult	0.0	2.0	2.0	0	2	2
1919856	IN	school	1801290	750	Carroll Consolidated School Corp	180129000203	621	Carroll Senior High School	Regular School	No	High	09	12	2021	adult	0.0	1.0	1.0	0	1	1
1285303	IN	school	1801440	4205	Center Grove Com Sch Corp	180144000209	3437	Center Grove High School	Regular School	No	3.0	09	12	2016	adult	2.0	0.0	2.0	2	0	2
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
1291801	IN	school	1801560	8360	Centerville-Abington Com Schs	180156000217	8981	Centerville Sr High School	Regular School	No	3.0	09	12	2016	adult	1.0	0.0	1.0	1	0	1
1303826	IN	school	1801560	8360	Centerville-Abington Com Schs	180156000217	8981	Centerville Sr High School	Regular School	No	High	09	12	2017	adult	2.0	0.0	2.0	2	0	2
1798148	IN	school	1801560	8360	Centerville-Abington Com Schs	180156000217	8981	Centerville Sr High School	Regular School	No	High	09	12	2018	adult	2.0	0.0	2.0	2	0	2
1917784	IN	school	1801560	8360	Centerville-Abington Com Schs	180156000217	8981	Centerville Sr High School	Regular School	No	High	09	12	2020	adult	0.0	3.0	3.0	0	3	3
1294590	IN	school	1801590	1835	DeKalb Co Ctl United Sch Dist	180159000220	1345	DeKalb High School	Regular School	No	High	09	12	2017	adult	3.0	1.0	4.0	3	1	4
1753209	IN	school	1801590	1835	DeKalb Co Ctl United Sch Dist	180159000220	1345	DeKalb High School	Regular School	No	High	09	12	2019	adult	8.0	0.0	8.0	8	0	8
1788948	IN	school	1801590	1835	DeKalb Co Ctl United Sch Dist	180159000220	1345	DeKalb High School	Regular School	No	High	09	12	2018	adult	4.0	7.0	11.0	4	7	11
1908640	IN	school	1801590	1835	DeKalb Co Ctl United Sch Dist	180159000220	1345	DeKalb High School	Regular School	No	High	09	12	2020	adult	4.0	1.0	5.0	4	1	5
1920612	IN	school	1801590	1835	DeKalb Co Ctl United Sch Dist	180159000220	1345	DeKalb High School	Regular School	No	High	09	12	2021	adult	4.0	1.0	5.0	4	1	5
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
1300970	IN	school	1801710	6055	Central Noble Com School Corp	180171000230	6453	Central Noble Junior Senior HS	Regular School	No	Other	06	12	2017	adult	0.0	1.0	1.0	0	1	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
1926760	IN	school	1801710	6055	Central Noble Com School Corp	180171000230	6453	Central Noble Junior Senior HS	Regular School	No	High	06	12	2021	adult	0.0	1.0	1.0	0	1	1
1759689	IN	school	1801740	6325	Perry Central Com Schools Corp	180174000234	6708	Perry Central Jr-Sr High School	Regular School	No	High	07	12	2019	adult	1.0	3.0	4.0	1	3	4
1795513	IN	school	1801740	6325	Perry Central Com Schools Corp	180174000234	6708	Perry Central Jr-Sr High School	Regular School	No	High	07	12	2018	adult	1.0	1.0	2.0	1	1	2
1915099	IN	school	1801740	6325	Perry Central Com Schools Corp	180174000234	6708	Perry Central Jr-Sr High School	Regular School	No	High	07	12	2020	adult	1.0	1.0	2.0	1	1	2
1926976	IN	school	1801740	6325	Perry Central Com Schools Corp	180174000234	6708	Perry Central Jr-Sr High School	Regular School	No	High	07	12	2021	adult	0.0	2.0	2.0	0	2	2
1168386	IN	school	1801770	6825	Randolph Central School Corp	180177000242	7125	Winchester Community High Sch	Regular School	No	3.0	09	12	2015	adult	2.0	2.0	4.0	2	2	4
1289780	IN	school	1801770	6825	Randolph Central School Corp	180177000242	7125	Winchester Community High School	Regular School	No	3.0	09	12	2016	adult	1.0	2.0	3.0	1	2	3
1163851	IN	school	1801890	4145	Clark-Pleasant Com School Corp	180189000246	3421	Whiteland Community High Sch	Regular School	No	3.0	09	12	2015	adult	3.0	1.0	4.0	3	1	4
1285257	IN	school	1801890	4145	Clark-Pleasant Com School Corp	180189000246	3421	Whiteland Community High School	Regular School	No	3.0	09	12	2016	adult	4.0	1.0	5.0	4	1	5
1297294	IN	school	1801890	4145	Clark-Pleasant Community Sch Corp	180189000246	3421	Whiteland Community High School	Regular School	No	High	09	12	2017	adult	3.0	0.0	3.0	3	0	3
1755889	IN	school	1801890	4145	Clark-Pleasant Community Sch Corp	180189000246	3421	Whiteland Community High School	Regular School	No	High	09	12	2019	adult	1.0	2.0	3.0	1	2	3
1791651	IN	school	1801890	4145	Clark-Pleasant Community Sch Corp	180189000246	3421	Whiteland Community High School	Regular School	No	High	09	12	2018	adult	0.0	1.0	1.0	0	1	1
1911332	IN	school	1801890	4145	Clark-Pleasant Community Sch Corp	180189000246	3421	Whiteland Community High School	Regular School	No	High	09	12	2020	adult	4.0	2.0	6.0	4	2	6
1923298	IN	school	1801890	4145	Clark-Pleasant Community Sch Corp	180189000246	3421	Whiteland Community High School	Regular School	No	High	09	12	2021	adult	5.0	0.0	5.0	5	0	5
1160540	IN	school	1801920	1000	Clarksville Com School Corp	180192000249	833	Clarksville Senior High Sch	Regular School	No	3.0	09	12	2015	adult	0.0	2.0	2.0	0	2	2
1281935	IN	school	1801920	1000	Clarksville Com School Corp	180192000249	833	Clarksville Senior High School	Regular School	No	3.0	09	12	2016	adult	1.0	0.0	1.0	1	0	1
1293993	IN	school	1801920	1000	Clarksville Community School Corp	180192000249	833	Clarksville Senior High School	Regular School	No	High	09	12	2017	adult	1.0	0.0	1.0	1	0	1
1752620	IN	school	1801920	1000	Clarksville Community School Corp	180192000249	833	Clarksville Senior High School	Regular School	No	High	09	12	2019	adult	2.0	0.0	2.0	2	0	2
1788359	IN	school	1801920	1000	Clarksville Community School Corp	180192000249	833	Clarksville Senior High School	Regular School	No	High	09	12	2018	adult	1.0	0.0	1.0	1	0	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	0.0	2.0	2	0	2
1168300	IN	school	1802220	6750	Cloverdale Community Schools	180222000265	7077	Cloverdale High School	Regular School	No	3.0	09	12	2015	adult	1.0	0.0	1.0	1	0	1
1301716	IN	school	1802220	6750	Cloverdale Community Schools	180222000265	7077	Cloverdale High School	Regular School	No	High	09	12	2017	adult	0.0	1.0	1.0	0	1	1
1796035	IN	school	1802220	6750	Cloverdale Community Schools	180222000265	7077	Cloverdale High School	Regular School	No	High	09	12	2018	adult	0.0	1.0	1.0	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	0.0	1.0	1	0	1
1927543	IN	school	1802220	6750	Cloverdale Community Schools	180222000265	7077	Cloverdale High School	Regular School	No	High	09	12	2021	adult	1.0	0.0	1.0	1	0	1
1170696	IN	school	1802280	8665	Whitley Co Cons Schools	180228000267	9187	Columbia City High School	Regular School	No	3.0	09	12	2015	adult	4.0	1.0	5.0	4	1	5
1292085	IN	school	1802280	8665	Whitley Co Cons Schools	180228000267	9187	Columbia City High School	Regular School	No	3.0	09	12	2016	adult	5.0	1.0	6.0	5	1	6