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 (ccd_school_high_grade > :p3 or (ccd_school_high_grade = :p3 and rowid > :p2)) order by ccd_school_high_grade, rowid limit 101

Query parameters

This data as json, CSV

rowid	state	county	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	grade	white	black	hispanic	native_american	asian	pacific_islander	multiracial	male	female	low_income	disability	total	white_int	black_int	hispanic_int	native_american_int	asian_int	pacific_islander_int	multiracial_int	male_int	female_int	low_income_int	disability_int	total_int
3082629	WI	Green	school		3682	Public Schools-Multidistrict Charters	Monroe		9803	JEDI Virtual K-12	charter						2019	grade_12												3												3
3082630	WI	Green	school		3682	Public Schools-Multidistrict Charters	Monroe		9803	JEDI Virtual K-12	charter						2019	grade_3												1												1
3082631	WI	Green	school		3682	Public Schools-Multidistrict Charters	Monroe		9803	JEDI Virtual K-12	charter						2019	grade_7												1												1
3082632	WI	Green	school		3682	Public Schools-Multidistrict Charters	Monroe		9803	JEDI Virtual K-12	charter						2019	grade_8												1												1
3082633	WI	Green	school		3682	Public Schools-Multidistrict Charters	Monroe		9803	JEDI Virtual K-12	charter						2019	grade_9												1												1
3082726	WI	Marathon	school		3787	Public Schools-Multidistrict Charters	Mosinee		9100	Rural Virtual Academy	charter						2019	pk_12_total	24.0					2.0	1.0	17.0	10.0	11	4	27	24					2	1	17	10	11	4	27
3082727	WI	Marathon	school		3787	Public Schools-Multidistrict Charters	Mosinee		9100	Rural Virtual Academy	charter						2019	grade_10												4												4
3082728	WI	Marathon	school		3787	Public Schools-Multidistrict Charters	Mosinee		9100	Rural Virtual Academy	charter						2019	grade_11												11												11
3082729	WI	Marathon	school		3787	Public Schools-Multidistrict Charters	Mosinee		9100	Rural Virtual Academy	charter						2019	grade_12												1												1
3082730	WI	Marathon	school		3787	Public Schools-Multidistrict Charters	Mosinee		9100	Rural Virtual Academy	charter						2019	grade_2												1												1
3082731	WI	Marathon	school		3787	Public Schools-Multidistrict Charters	Mosinee		9100	Rural Virtual Academy	charter						2019	grade_3												1												1
3082732	WI	Marathon	school		3787	Public Schools-Multidistrict Charters	Mosinee		9100	Rural Virtual Academy	charter						2019	grade_4												1												1
3082733	WI	Marathon	school		3787	Public Schools-Multidistrict Charters	Mosinee		9100	Rural Virtual Academy	charter						2019	grade_6												1												1
3082734	WI	Marathon	school		3787	Public Schools-Multidistrict Charters	Mosinee		9100	Rural Virtual Academy	charter						2019	grade_7												1												1
3082735	WI	Marathon	school		3787	Public Schools-Multidistrict Charters	Mosinee		9100	Rural Virtual Academy	charter						2019	grade_8												3												3
3082736	WI	Marathon	school		3787	Public Schools-Multidistrict Charters	Mosinee		9100	Rural Virtual Academy	charter						2019	grade_9												2												2
3082737	WI	Marathon	school		3787	Public Schools-Multidistrict Charters	Mosinee		9100	Rural Virtual Academy	charter						2019	kindergarten_4_year_old												1												1
3082862	WI	Juneau	school		3871	Public Schools-Multidistrict Charters	Necedah Area		9405	Juneau County Charter School	charter						2019	pk_12_total												0												0
3083319	WI	Vilas	school		616	Public Schools-Multidistrict Charters	North Lakeland		9418	Lakeland STAR School--Strong Talented Adventurous Remarkable	charter						2019	pk_12_total												0												0
3083975	WI	Clark	school		4207	Public Schools-Multidistrict Charters	Owen-Withee		9100	Rural Virtual Academy	charter						2019	pk_12_total	2.0								2.0	*	*	2	2								2			2
3083976	WI	Clark	school		4207	Public Schools-Multidistrict Charters	Owen-Withee		9100	Rural Virtual Academy	charter						2019	grade_12												1												1
3083977	WI	Clark	school		4207	Public Schools-Multidistrict Charters	Owen-Withee		9100	Rural Virtual Academy	charter						2019	grade_8												1												1
3084183	WI	Wood	school		4368	Public Schools-Multidistrict Charters	Pittsville		9100	Rural Virtual Academy	charter						2019	pk_12_total	10.0							5.0	5.0	*	3	10	10							5	5		3	10
3084184	WI	Wood	school		4368	Public Schools-Multidistrict Charters	Pittsville		9100	Rural Virtual Academy	charter						2019	grade_11												2												2
3084185	WI	Wood	school		4368	Public Schools-Multidistrict Charters	Pittsville		9100	Rural Virtual Academy	charter						2019	grade_12												1												1
3084186	WI	Wood	school		4368	Public Schools-Multidistrict Charters	Pittsville		9100	Rural Virtual Academy	charter						2019	grade_4												1												1
3084187	WI	Wood	school		4368	Public Schools-Multidistrict Charters	Pittsville		9100	Rural Virtual Academy	charter						2019	grade_6												2												2
3084188	WI	Wood	school		4368	Public Schools-Multidistrict Charters	Pittsville		9100	Rural Virtual Academy	charter						2019	grade_7												3												3
3084189	WI	Wood	school		4368	Public Schools-Multidistrict Charters	Pittsville		9100	Rural Virtual Academy	charter						2019	grade_9												1												1
3084459	WI	Price	school		4571	Public Schools-Multidistrict Charters	Prentice		9100	Rural Virtual Academy	charter						2019	pk_12_total												0												0
3084946	WI	Taylor	school		4795	Public Schools-Multidistrict Charters	Rib Lake		9100	Rural Virtual Academy	charter						2019	pk_12_total	10.0	2.0						5.0	7.0	3		12	10	2						5	7	3		12
3084947	WI	Taylor	school		4795	Public Schools-Multidistrict Charters	Rib Lake		9100	Rural Virtual Academy	charter						2019	grade_11												1												1
3084948	WI	Taylor	school		4795	Public Schools-Multidistrict Charters	Rib Lake		9100	Rural Virtual Academy	charter						2019	grade_12												1												1
3084949	WI	Taylor	school		4795	Public Schools-Multidistrict Charters	Rib Lake		9100	Rural Virtual Academy	charter						2019	grade_5												1												1
3084950	WI	Taylor	school		4795	Public Schools-Multidistrict Charters	Rib Lake		9100	Rural Virtual Academy	charter						2019	grade_6												5												5
3084951	WI	Taylor	school		4795	Public Schools-Multidistrict Charters	Rib Lake		9100	Rural Virtual Academy	charter						2019	grade_7												2												2
3084952	WI	Taylor	school		4795	Public Schools-Multidistrict Charters	Rib Lake		9100	Rural Virtual Academy	charter						2019	kindergarten_4_year_old												1												1
3084953	WI	Taylor	school		4795	Public Schools-Multidistrict Charters	Rib Lake		9100	Rural Virtual Academy	charter						2019	kindergarten												1												1
3085262	WI	Juneau	school		1673	Public Schools-Multidistrict Charters	Royall		9405	Juneau County Charter Sch	charter						2019	pk_12_total												0												0
3086044	WI	Marathon	school		5467	Public Schools-Multidistrict Charters	Spencer		9100	Rural Virtual Academy	charter						2019	pk_12_total	10.0							6.0	4.0	*	1	10	10							6	4		1	10
3086045	WI	Marathon	school		5467	Public Schools-Multidistrict Charters	Spencer		9100	Rural Virtual Academy	charter						2019	grade_12												3												3
3086046	WI	Marathon	school		5467	Public Schools-Multidistrict Charters	Spencer		9100	Rural Virtual Academy	charter						2019	grade_3												1												1
3086047	WI	Marathon	school		5467	Public Schools-Multidistrict Charters	Spencer		9100	Rural Virtual Academy	charter						2019	grade_5												2												2
3086048	WI	Marathon	school		5467	Public Schools-Multidistrict Charters	Spencer		9100	Rural Virtual Academy	charter						2019	grade_6												1												1
3086049	WI	Marathon	school		5467	Public Schools-Multidistrict Charters	Spencer		9100	Rural Virtual Academy	charter						2019	grade_7												2												2
3086050	WI	Marathon	school		5467	Public Schools-Multidistrict Charters	Spencer		9100	Rural Virtual Academy	charter						2019	grade_9												1												1
3086267	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2019	pk_12_total	17.0		1.0					7.0	11.0	5	1	18	17		1					7	11	5	1	18
3086268	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2019	grade_10												4												4
3086269	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2019	grade_11												3												3
3086270	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2019	grade_12												5												5
3086271	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2019	grade_5												1												1
3086272	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2019	grade_8												1												1
3086273	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2019	grade_9												4												4
3086300	WI	Marathon	school		5628	Public Schools-Multidistrict Charters	Stratford		9100	Rural Virtual Academy	charter						2019	pk_12_total	8.0							3.0	5.0	2	1	8	8							3	5	2	1	8
3086301	WI	Marathon	school		5628	Public Schools-Multidistrict Charters	Stratford		9100	Rural Virtual Academy	charter						2019	grade_11												2												2
3086302	WI	Marathon	school		5628	Public Schools-Multidistrict Charters	Stratford		9100	Rural Virtual Academy	charter						2019	grade_4												2												2
3086303	WI	Marathon	school		5628	Public Schools-Multidistrict Charters	Stratford		9100	Rural Virtual Academy	charter						2019	grade_6												1												1
3086304	WI	Marathon	school		5628	Public Schools-Multidistrict Charters	Stratford		9100	Rural Virtual Academy	charter						2019	grade_7												1												1
3086305	WI	Marathon	school		5628	Public Schools-Multidistrict Charters	Stratford		9100	Rural Virtual Academy	charter						2019	grade_8												1												1
3086306	WI	Marathon	school		5628	Public Schools-Multidistrict Charters	Stratford		9100	Rural Virtual Academy	charter						2019	kindergarten_4_year_old												1												1
3086380	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2019	pk_12_total	16.0		1.0		1.0		1.0	6.0	13.0	6	2	19	16		1		1		1	6	13	6	2	19
3086381	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2019	grade_10												1												1
3086382	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2019	grade_11												4												4
3086383	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2019	grade_12												3												3
3086384	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2019	grade_4												2												2
3086385	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2019	grade_6												3												3
3086386	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2019	grade_7												2												2
3086387	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2019	grade_8												3												3
3086388	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2019	grade_9												1												1
3086636	WI	Monroe	school		5747	Public Schools-Multidistrict Charters	Tomah Area		9100	Rural Virtual Academy	charter						2019	pk_12_total	44.0		1.0					25.0	20.0	23	13	45	44		1					25	20	23	13	45
3086637	WI	Monroe	school		5747	Public Schools-Multidistrict Charters	Tomah Area		9100	Rural Virtual Academy	charter						2019	grade_10												4												4
3086638	WI	Monroe	school		5747	Public Schools-Multidistrict Charters	Tomah Area		9100	Rural Virtual Academy	charter						2019	grade_11												3												3
3086639	WI	Monroe	school		5747	Public Schools-Multidistrict Charters	Tomah Area		9100	Rural Virtual Academy	charter						2019	grade_12												5												5
3086640	WI	Monroe	school		5747	Public Schools-Multidistrict Charters	Tomah Area		9100	Rural Virtual Academy	charter						2019	grade_2												3												3
3086641	WI	Monroe	school		5747	Public Schools-Multidistrict Charters	Tomah Area		9100	Rural Virtual Academy	charter						2019	grade_3												2												2
3086642	WI	Monroe	school		5747	Public Schools-Multidistrict Charters	Tomah Area		9100	Rural Virtual Academy	charter						2019	grade_4												4												4
3086643	WI	Monroe	school		5747	Public Schools-Multidistrict Charters	Tomah Area		9100	Rural Virtual Academy	charter						2019	grade_5												1												1
3086644	WI	Monroe	school		5747	Public Schools-Multidistrict Charters	Tomah Area		9100	Rural Virtual Academy	charter						2019	grade_6												3												3
3086645	WI	Monroe	school		5747	Public Schools-Multidistrict Charters	Tomah Area		9100	Rural Virtual Academy	charter						2019	grade_7												6												6
3086646	WI	Monroe	school		5747	Public Schools-Multidistrict Charters	Tomah Area		9100	Rural Virtual Academy	charter						2019	grade_8												3												3
3086647	WI	Monroe	school		5747	Public Schools-Multidistrict Charters	Tomah Area		9100	Rural Virtual Academy	charter						2019	grade_9												5												5
3086648	WI	Monroe	school		5747	Public Schools-Multidistrict Charters	Tomah Area		9100	Rural Virtual Academy	charter						2019	kindergarten												6												6
3086770	WI	Barron	school		5810	Public Schools-Multidistrict Charters	Turtle Lake		9410	North Star Academy	charter						2019	pk_12_total	5.0							4.0	1.0	*	*	5	5							4	1			5
3086771	WI	Barron	school		5810	Public Schools-Multidistrict Charters	Turtle Lake		9410	North Star Academy	charter						2019	grade_11												2												2
3086772	WI	Barron	school		5810	Public Schools-Multidistrict Charters	Turtle Lake		9410	North Star Academy	charter						2019	grade_12												3												3
3087117	WI	Jefferson	school		6118	Public Schools-Multidistrict Charters	Waterloo		9803	JEDI Virtual K-12	charter						2019	pk_12_total	1.0						1.0	2.0		*	*	2	1						1	2				2
3087118	WI	Jefferson	school		6118	Public Schools-Multidistrict Charters	Waterloo		9803	JEDI Virtual K-12	charter						2019	grade_10												1												1
3087119	WI	Jefferson	school		6118	Public Schools-Multidistrict Charters	Waterloo		9803	JEDI Virtual K-12	charter						2019	kindergarten												1												1
3088072	WI	Vernon	school		6321	Public Schools-Multidistrict Charters	Westby Area		9407	Vernon County Area Better Futures High	charter						2019	pk_12_total	3.0							3.0		*	*	3	3							3				3
3088073	WI	Vernon	school		6321	Public Schools-Multidistrict Charters	Westby Area		9407	Vernon County Area Better Futures High	charter						2019	grade_10												1												1
3088074	WI	Vernon	school		6321	Public Schools-Multidistrict Charters	Westby Area		9407	Vernon County Area Better Futures High	charter						2019	grade_12												2												2
3088184	WI	Langlade	school		6440	Public Schools-Multidistrict Charters	White Lake		9100	Rural Virtual Academy	charter						2019	pk_12_total	3.0							2.0	1.0	*	*	3	3							2	1			3
3088185	WI	Langlade	school		6440	Public Schools-Multidistrict Charters	White Lake		9100	Rural Virtual Academy	charter						2019	grade_2												1												1
3088186	WI	Langlade	school		6440	Public Schools-Multidistrict Charters	White Lake		9100	Rural Virtual Academy	charter						2019	grade_7												1												1
3088187	WI	Langlade	school		6440	Public Schools-Multidistrict Charters	White Lake		9100	Rural Virtual Academy	charter						2019	kindergarten												1												1
3088248	WI	Walworth	school		6461	Public Schools-Multidistrict Charters	Whitewater Unified		9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter						2019	pk_12_total												0												0
3088329	WI	Walworth	school		6482	Public Schools-Multidistrict Charters	Williams Bay		9401	Walworth Co Educ Alt High	charter						2019	pk_12_total												0												0
3088552	WI	Juneau	school		6713	Public Schools-Multidistrict Charters	Wonewoc-Union Center		9405	Juneau County Charter School	charter						2019	pk_12_total												0												0
3088607	WI	Vilas	school		6720	Public Schools-Multidistrict Charters	Woodruff J1		9418	Lakeland STAR School--Strong Talented Adventurous Remarkable	charter						2019	pk_12_total												0												0
3075075	WI	Jackson	school	5501260	476	Public school	Black River Falls	550126000176	80	Forrest Street Early Learning Center		Regular School	No	Elementary	PK	01	2019	pk_12_total	229.0	3.0	13.0	96.0	2.0	1.0	20.0	218.0	146.0	227	59	364	229	3	13	96	2	1	20	218	146	227	59	364
3075076	WI	Jackson	school	5501260	476	Public school	Black River Falls	550126000176	80	Forrest Street Early Learning Center		Regular School	No	Elementary	PK	01	2019	grade_1												112												112