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 order by district 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
1159473	IN	school	1800060	15	Adams Central Community Schools	180006000007	21	Adams Central High School	Regular School	No	3.0	09	12	2015	adult	1.0	1.0	2.0	1	1	2
1280863	IN	school	1800060	15	Adams Central Community Schools	180006000007	21	Adams Central High School	Regular School	No	3.0	09	12	2016	adult	2.0	1.0	3.0	2	1	3
1292926	IN	school	1800060	15	Adams Central Community Schools	180006000007	21	Adams Central High School	Regular School	No	High	09	12	2017	adult	2.0	1.0	3.0	2	1	3
1751558	IN	school	1800060	15	Adams Central Community Schools	180006000007	21	Adams Central High School	Regular School	No	High	09	12	2019	adult	3.0	0.0	3.0	3	0	3
1787299	IN	school	1800060	15	Adams Central Community Schools	180006000007	21	Adams Central High School	Regular School	No	High	09	12	2018	adult	1.0	0.0	1.0	1	0	1
1906999	IN	school	1800060	15	Adams Central Community Schools	180006000007	21	Adams Central High School	Regular School	No	High	09	12	2020	adult	1.0	1.0	2.0	1	1	2
1918965	IN	school	1800060	15	Adams Central Community Schools	180006000007	21	Adams Central High School	Regular School	No	High	09	12	2021	adult	1.0	1.0	2.0	1	1	2
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
1794629	IN	school	1800180	5470	Argos Community Schools	180018000048	5937	Argos Comm Jr-Sr High School	Regular School	No	High	07	12	2018	adult	1.0	0.0	1.0	1	0	1
1926115	IN	school	1800180	5470	Argos Community Schools	180018000048	5937	Argos Comm Jr-Sr High School	Regular School	No	High	06	12	2021	adult	0.0	2.0	2.0	0	2	2
1295434	IN	school	1800210	2435	Attica Consolidated School Corp	180021000050	2053	Attica High School	Regular School	No	High	07	12	2017	adult	0.0	1.0	1.0	0	1	1
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
1919990	IN	school	1800212	935	Borden-Henryville School Corp	180021201540	813	William W Borden High School	Regular School	No	High	07	12	2021	adult	3.0	2.0	5.0	3	2	5
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
1171092	IN	school	1800038	9620	Burris Laboratory School	180003800185	1441	Burris Laboratory School	Regular School	No	4.0	KG	12	2015	adult	0.0	1.0	1.0	0	1	1
1918583	IN	school	1800038	9620	Burris Laboratory School	180003800185	1441	Burris Laboratory School	Regular School	No	Other	KG	12	2020	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
1292774	IN	school	1800101	9880	Career Academy High School	180010102521	7564	Career Academy High School	Regular School	Yes	3.0	09	12	2016	adult	1.0	0.0	1.0	1	0	1
1304800	IN	school	1800101	9880	Career Academy High School	180010102521	7567	Career Academy High School	Regular School	Yes	High	09	12	2017	adult	1.0	2.0	3.0	1	2	3
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
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
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
1161527	IN	school	1802400	2270	Concord Community Schools	180240000271	1713	Concord Junior High School	Regular School	No	4.0	06	12	2015	adult	0.0	1.0	1.0	0	1	1
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
1282929	IN	school	1802400	2270	Concord Community Schools	180240000271	1713	Concord Junior High School	Regular School	No	2.0	07	09	2016	adult	0.0	1.0	1.0	0	1	1
1282934	IN	school	1802400	2270	Concord Community Schools	180240000269	1715	Concord Community High School	Regular School	No	3.0	09	12	2016	adult	2.0	0.0	2.0	2	0	2
1294966	IN	school	1802400	2270	Concord Community Schools	180240000271	1713	Concord Junior High School	Regular School	No	Other	07	10	2017	adult	0.0	1.0	1.0	0	1	1
1753577	IN	school	1802400	2270	Concord Community Schools	180240000269	1715	Concord Community High School	Regular School	No	High	09	12	2019	adult	0.0	3.0	3.0	0	3	3
1789314	IN	school	1802400	2270	Concord Community Schools	180240000269	1715	Concord Community High School	Regular School	No	High	09	12	2018	adult	1.0	0.0	1.0	1	0	1
1909008	IN	school	1802400	2270	Concord Community Schools	180240000269	1715	Concord Community High School	Regular School	No	High	09	12	2020	adult	2.0	2.0	4.0	2	2	4
1920977	IN	school	1802400	2270	Concord Community Schools	180240000269	1715	Concord Community High School	Regular School	No	High	09	12	2021	adult	3.0	0.0	3.0	3	0	3
1160863	IN	school	1802440	1300	Crawford Co Com School Corp	180244000279	1059	Crawford County Jr-Sr HS	Regular School	No	3.0	07	12	2015	adult	1.0	0.0	1.0	1	0	1
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	0.0	1.0	1	0	1
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