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_state_id > :p3 or (district_state_id = :p3 and rowid > :p2)) order by district_state_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
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
1753637	IN	school	1806600	2275	Middlebury Community Schools	180660001165	1733	Northridge High School	Regular School	No	High	09	12	2019	adult	5.0	3.0	8.0	5	3	8
1909067	IN	school	1806600	2275	Middlebury Community Schools	180660001165	1733	Northridge High School	Regular School	No	High	09	12	2020	adult	2.0	3.0	5.0	2	3	5
1921037	IN	school	1806600	2275	Middlebury Community Schools	180660001165	1733	Northridge High School	Regular School	No	High	09	12	2021	adult	2.0	3.0	5.0	2	3	5
1161617	IN	school	1812240	2285	Wa-Nee Community Schools	181224001956	1737	North Wood High School	Regular School	No	3.0	09	12	2015	adult	0.0	1.0	1.0	0	1	1
1753660	IN	school	1812240	2285	Wa-Nee Community Schools	181224001956	1737	North Wood High School	Regular School	No	High	09	12	2019	adult	1.0	3.0	4.0	1	3	4
1789398	IN	school	1812240	2285	Wa-Nee Community Schools	181224001956	1737	North Wood High School	Regular School	No	High	09	12	2018	adult	1.0	0.0	1.0	1	0	1
1909091	IN	school	1812240	2285	Wa-Nee Community Schools	181224001956	1737	North Wood High School	Regular School	No	High	09	12	2020	adult	1.0	1.0	2.0	1	1	2
1921070	IN	school	1812240	2285	Wa-Nee Community Schools	181224001956	1737	North Wood High School	Regular School	No	High	09	12	2021	adult	2.0	5.0	7.0	2	5	7
1161679	IN	school	1803270	2305	Elkhart Community Schools	180327000429	1749	Elkhart Central High School	Regular School	No	3.0	09	12	2015	adult	2.0	2.0	4.0	2	2	4
1161685	IN	school	1803270	2305	Elkhart Community Schools	180327000430	1750	Elkhart Memorial High School	Regular School	No	3.0	09	12	2015	adult	13.0	15.0	28.0	13	15	28
1283079	IN	school	1803270	2305	Elkhart Community Schools	180327000429	1749	Elkhart Central High School	Regular School	No	3.0	09	12	2016	adult	1.0	1.0	2.0	1	1	2
1283085	IN	school	1803270	2305	Elkhart Community Schools	180327000430	1750	Elkhart Memorial High School	Regular School	No	3.0	09	12	2016	adult	19.0	15.0	34.0	19	15	34
1295117	IN	school	1803270	2305	Elkhart Community Schools	180327000429	1749	Elkhart Central High School	Regular School	No	High	09	12	2017	adult	1.0	1.0	2.0	1	1	2
1295123	IN	school	1803270	2305	Elkhart Community Schools	180327000430	1750	Elkhart Memorial High School	Regular School	No	High	09	12	2017	adult	20.0	14.0	34.0	20	14	34
1753723	IN	school	1803270	2305	Elkhart Community Schools	180327000429	1749	Elkhart Central High School	Regular School	No	High	09	12	2019	adult	3.0	6.0	9.0	3	6	9
1753729	IN	school	1803270	2305	Elkhart Community Schools	180327000430	1750	Elkhart Memorial High School	Regular School	No	High	09	12	2019	adult	24.0	13.0	37.0	24	13	37
1789461	IN	school	1803270	2305	Elkhart Community Schools	180327000429	1749	Elkhart Central High School	Regular School	No	High	09	12	2018	adult	1.0	7.0	8.0	1	7	8
1789467	IN	school	1803270	2305	Elkhart Community Schools	180327000430	1750	Elkhart Memorial High School	Regular School	No	High	09	12	2018	adult	19.0	10.0	29.0	19	10	29
1789473	IN	school	1803270	2305	Elkhart Community Schools	180327002585	1752	Elkhart Alternative Education	Regular School	No	Other	01	12	2018	adult	1.0	0.0	1.0	1	0	1
1909154	IN	school	1803270	2305	Elkhart Community Schools	180327000429	1749	Elkhart Central High School	Regular School	No	High	09	12	2020	adult	3.0	7.0	10.0	3	7	10
1909160	IN	school	1803270	2305	Elkhart Community Schools	180327000430	1750	Elkhart Memorial High School	Regular School	No	High	09	12	2020	adult	21.0	6.0	27.0	21	6	27
1909166	IN	school	1803270	2305	Elkhart Community Schools	180327002585	1752	Elkhart Alternative Education	Regular School	No	Other	KG	12	2020	adult	2.0	3.0	5.0	2	3	5
1921134	IN	school	1803270	2305	Elkhart Community Schools	180327002585	1752	Elkhart Alternative Education	Regular School	No	Other	01	12	2021	adult	1.0	0.0	1.0	1	0	1
1921149	IN	school	1803270	2305	Elkhart Community Schools	180327002693	1754	Elkhart High School	Regular School	No	High	09	12	2021	adult	17.0	10.0	27.0	17	10	27
1295249	IN	school	1803930	2315	Goshen Community Schools	180393000654	1821	Goshen High School	Regular School	No	High	09	12	2017	adult	0.0	1.0	1.0	0	1	1
1753855	IN	school	1803930	2315	Goshen Community Schools	180393000654	1821	Goshen High School	Regular School	No	High	09	12	2019	adult	10.0	12.0	22.0	10	12	22
1789592	IN	school	1803930	2315	Goshen Community Schools	180393000654	1821	Goshen High School	Regular School	No	High	09	12	2018	adult	8.0	10.0	18.0	8	10	18
1909264	IN	school	1803930	2315	Goshen Community Schools	180393000659	1629	Goshen Middle School	Regular School	No	Middle	06	09	2020	adult	0.0	1.0	1.0	0	1	1
1909284	IN	school	1803930	2315	Goshen Community Schools	180393000654	1821	Goshen High School	Regular School	No	High	09	12	2020	adult	20.0	18.0	38.0	20	18	38
1921236	IN	school	1803930	2315	Goshen Community Schools	180393000659	1629	Goshen Middle School	Regular School	No	Middle	06	09	2021	adult	0.0	1.0	1.0	0	1	1
1921256	IN	school	1803930	2315	Goshen Community Schools	180393000654	1821	Goshen High School	Regular School	No	High	09	12	2021	adult	19.0	24.0	43.0	19	24	43
1161846	IN	school	1803510	2395	Fayette County School Corp	180351000498	1889	Connersville Sr High School	Regular School	No	3.0	09	12	2015	adult	1.0	0.0	1.0	1	0	1
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
1162021	IN	school	1810620	2455	Southeast Fountain School Corp	181062001742	2022	Fountain Central High School	Regular School	No	3.0	07	12	2015	adult	0.0	1.0	1.0	0	1	1
1789819	IN	school	1810620	2455	Southeast Fountain School Corp	181062001742	2022	Fountain Central High School	Regular School	No	High	07	12	2018	adult	1.0	0.0	1.0	1	0	1
1160016	IN	school	1802850	255	East Allen County Schools	180285000353	297	New Haven High School	Regular School	No	3.0	09	12	2015	adult	0.0	2.0	2.0	0	2	2
1281361	IN	school	1802850	255	East Allen County Schools	180285000349	49	Leo Junior/Senior High School	Regular School	No	3.0	07	12	2016	adult	6.0	4.0	10.0	6	4	10
1281373	IN	school	1802850	255	East Allen County Schools	180285000344	81	Heritage Jr/Sr High School	Regular School	No	3.0	07	12	2016	adult	7.0	3.0	10.0	7	3	10
1281394	IN	school	1802850	255	East Allen County Schools	180285000361	285	Woodlan Jr/Sr High School	Regular School	No	3.0	07	12	2016	adult	7.0	1.0	8.0	7	1	8
1281410	IN	school	1802850	255	East Allen County Schools	180285000353	297	New Haven High School	Regular School	No	3.0	09	12	2016	adult	12.0	9.0	21.0	12	9	21
1293415	IN	school	1802850	255	East Allen County Schools	180285000349	49	Leo Junior/Senior High School	Regular School	No	High	07	12	2017	adult	2.0	2.0	4.0	2	2	4
1293428	IN	school	1802850	255	East Allen County Schools	180285000344	81	Heritage Jr/Sr High School	Regular School	No	High	07	12	2017	adult	7.0	1.0	8.0	7	1	8
1293449	IN	school	1802850	255	East Allen County Schools	180285000361	285	Woodlan Jr/Sr High School	Regular School	No	High	07	12	2017	adult	10.0	1.0	11.0	10	1	11
1293465	IN	school	1802850	255	East Allen County Schools	180285000353	297	New Haven High School	Regular School	No	High	09	12	2017	adult	9.0	9.0	18.0	9	9	18
1752039	IN	school	1802850	255	East Allen County Schools	180285000349	49	Leo Junior/Senior High School	Regular School	No	High	07	12	2019	adult	5.0	1.0	6.0	5	1	6
1752051	IN	school	1802850	255	East Allen County Schools	180285000344	81	Heritage Jr/Sr High School	Regular School	No	High	07	12	2019	adult	6.0	1.0	7.0	6	1	7
1752072	IN	school	1802850	255	East Allen County Schools	180285000361	285	Woodlan Jr/Sr High School	Regular School	No	High	07	12	2019	adult	10.0	3.0	13.0	10	3	13
1752088	IN	school	1802850	255	East Allen County Schools	180285000353	297	New Haven High School	Regular School	No	High	09	12	2019	adult	16.0	4.0	20.0	16	4	20
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
1787784	IN	school	1802850	255	East Allen County Schools	180285000349	49	Leo Junior/Senior High School	Regular School	No	High	07	12	2018	adult	3.0	3.0	6.0	3	3	6
1787796	IN	school	1802850	255	East Allen County Schools	180285000344	81	Heritage Jr/Sr High School	Regular School	No	High	07	12	2018	adult	5.0	2.0	7.0	5	2	7
1787817	IN	school	1802850	255	East Allen County Schools	180285000361	285	Woodlan Jr/Sr High School	Regular School	No	High	07	12	2018	adult	7.0	2.0	9.0	7	2	9
1787833	IN	school	1802850	255	East Allen County Schools	180285000353	297	New Haven High School	Regular School	No	High	09	12	2018	adult	13.0	6.0	19.0	13	6	19
1787862	IN	school	1802850	255	East Allen County Schools	180285002532	394	East Allen University	Regular School	No	High	09	12	2018	adult	1.0	0.0	1.0	1	0	1
1907479	IN	school	1802850	255	East Allen County Schools	180285000349	49	Leo Junior/Senior High School	Regular School	No	High	07	12	2020	adult	2.0	3.0	5.0	2	3	5
1907491	IN	school	1802850	255	East Allen County Schools	180285000344	81	Heritage Jr/Sr High School	Regular School	No	High	07	12	2020	adult	4.0	2.0	6.0	4	2	6
1907512	IN	school	1802850	255	East Allen County Schools	180285000361	285	Woodlan Jr/Sr High School	Regular School	No	High	07	12	2020	adult	10.0	4.0	14.0	10	4	14
1907528	IN	school	1802850	255	East Allen County Schools	180285000353	297	New Haven Jr/Sr High School	Regular School	No	High	07	12	2020	adult	7.0	4.0	11.0	7	4	11
1919445	IN	school	1802850	255	East Allen County Schools	180285000349	49	Leo Junior/Senior High School	Regular School	No	High	07	12	2021	adult	2.0	2.0	4.0	2	2	4
1919457	IN	school	1802850	255	East Allen County Schools	180285000344	81	Heritage Jr/Sr High School	Regular School	No	High	07	12	2021	adult	1.0	0.0	1.0	1	0	1
1919478	IN	school	1802850	255	East Allen County Schools	180285000361	285	Woodlan Jr/Sr High School	Regular School	No	High	07	12	2021	adult	8.0	5.0	13.0	8	5	13
1919494	IN	school	1802850	255	East Allen County Schools	180285000353	297	New Haven Jr/Sr High School	Regular School	No	High	07	12	2021	adult	10.0	7.0	17.0	10	7	17
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
1283477	IN	school	1809630	2645	Rochester Community Sch Corp	180963001576	2173	Rochester Community High Sch	Regular School	No	3.0	09	12	2016	adult	1.0	1.0	2.0	1	1	2
1295522	IN	school	1809630	2645	Rochester Community School Corp	180963001576	2173	Rochester Community High School	Regular School	No	High	09	12	2017	adult	2.0	1.0	3.0	2	1	3
1754126	IN	school	1809630	2645	Rochester Community School Corp	180963001576	2173	Rochester Community High School	Regular School	No	High	09	12	2019	adult	4.0	1.0	5.0	4	1	5
1789861	IN	school	1809630	2645	Rochester Community School Corp	180963001576	2173	Rochester Community High School	Regular School	No	High	09	12	2018	adult	2.0	0.0	2.0	2	0	2
1909552	IN	school	1809630	2645	Rochester Community School Corp	180963001576	2173	Rochester Community High School	Regular School	No	High	09	12	2020	adult	1.0	3.0	4.0	1	3	4
1921514	IN	school	1809630	2645	Rochester Community School Corp	180963001576	2173	Rochester Community High School	Regular School	No	High	09	12	2021	adult	2.0	2.0	4.0	2	2	4
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
1789938	IN	school	1807770	2735	North Gibson School Corporation	180777001326	2249	Princeton Community High School	Regular School	No	High	09	12	2018	adult	1.0	2.0	3.0	1	2	3
1921592	IN	school	1807770	2735	North Gibson School Corporation	180777001326	2249	Princeton Community High School	Regular School	No	High	09	12	2021	adult	1.0	1.0	2.0	1	1	2
1295618	IN	school	1810350	2765	South Gibson School Corporation	181035001688	2211	Gibson Southern High School	Regular School	No	High	09	12	2017	adult	3.0	1.0	4.0	3	1	4
1789959	IN	school	1810350	2765	South Gibson School Corporation	181035001688	2211	Gibson Southern High School	Regular School	No	High	09	12	2018	adult	1.0	2.0	3.0	1	2	3
1909650	IN	school	1810350	2765	South Gibson School Corporation	181035001688	2211	Gibson Southern High School	Regular School	No	High	09	12	2020	adult	1.0	1.0	2.0	1	1	2
1921613	IN	school	1810350	2765	South Gibson School Corporation	181035001688	2211	Gibson Southern High School	Regular School	No	High	09	12	2021	adult	1.0	1.0	2.0	1	1	2
1909726	IN	school	1806870	2855	Mississinewa Community School Corp	180687001189	2333	Mississinewa High School	Regular School	No	High	09	12	2020	adult	1.0	1.0	2.0	1	1	2
1921682	IN	school	1806870	2855	Mississinewa Community School Corp	180687001189	2333	Mississinewa High School	Regular School	No	High	09	12	2021	adult	3.0	0.0	3.0	3	0	3
1754321	IN	school	1806390	2865	Marion Community Schools	180639001117	2351	Marion High School	Regular School	No	High	09	12	2019	adult	8.0	3.0	11.0	8	3	11
1790056	IN	school	1806390	2865	Marion Community Schools	180639001117	2351	Marion High School	Regular School	No	High	09	12	2018	adult	9.0	3.0	12.0	9	3	12
1909748	IN	school	1806390	2865	Marion Community Schools	180639001117	2351	Marion High School	Regular School	No	High	09	12	2020	adult	8.0	4.0	12.0	8	4	12
1921704	IN	school	1806390	2865	Marion Community Schools	180639001117	2351	Marion High School	Regular School	No	High	09	12	2021	adult	6.0	3.0	9.0	6	3	9
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
1162327	IN	school	1805910	2950	Linton-Stockton School Corp	180591001049	2437	Linton-Stockton High School	Regular School	No	3.0	09	12	2015	adult	2.0	3.0	5.0	2	3	5
1790126	IN	school	1805910	2950	Linton-Stockton School Corporation	180591001049	2437	Linton-Stockton High School	Regular School	No	High	09	12	2018	adult	1.0	0.0	1.0	1	0	1
1921774	IN	school	1805910	2950	Linton-Stockton School Corporation	180591001049	2437	Linton-Stockton High School	Regular School	No	High	09	12	2021	adult	1.0	1.0	2.0	1	1	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
1921931	IN	school	1810650	3005	Hamilton Southeastern Schools	181065001752	2499	Hamilton Southeastern HS	Regular School	No	High	09	12	2021	adult	4.0	2.0	6.0	4	2	6
1295935	IN	school	1804260	3025	Hamilton Heights School Corp	180426000728	2477	Hamilton Heights High School	Regular School	No	High	09	12	2017	adult	1.0	0.0	1.0	1	0	1
1754543	IN	school	1804260	3025	Hamilton Heights School Corp	180426000728	2477	Hamilton Heights High School	Regular School	No	High	09	12	2019	adult	3.0	0.0	3.0	3	0	3
1790283	IN	school	1804260	3025	Hamilton Heights School Corp	180426000728	2477	Hamilton Heights High School	Regular School	No	High	09	12	2018	adult	1.0	0.0	1.0	1	0	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	0.0	1.0	1	0	1