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 school_state_id 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	total	total_int
114079	WI	Walworth	school	5503640	1380	Public school	Delavan-Darien	550364002239	10	Darien Elementary		Regular School	No	1.0	PK	05	2015	grade_2	35	35
116001	WI	La Crosse	school	5506540	2562	Public school	Holmen	550654002259	10	Evergreen Elementary		Regular School	No	1.0	KG	05	2015	grade_2	70	70
116063	WI	Outagamie	school	5506600	2583	Public school	Hortonville Area	550660002407	10	Greenville Elementary		Regular School	No	1.0	PK	04	2015	grade_2	108	108
116212	WI	Saint Croix	school	5506690	2611	Public school	Hudson	550669002332	10	Willow River Elementary		Regular School	No	1.0	KG	05	2015	grade_2	64	64
120421	WI	Green	school	5509840	3682	Public school	Monroe	550984002771	10	Abraham Lincoln Elementary		Regular School	No	1.0	PK	05	2015	grade_2	44	44
120454	WI	Marquette	school	5509870	3689	Public school	Montello	550987001302	10	Forest Lane Community School	charter	Regular School	Yes	1.0	PK	06	2015	grade_2	46	46
121015	WI	Saint Croix	school	5510620	3962	Public school	New Richmond	551062000225	10	New Richmond Paperjack Elementary		Regular School	No	1.0	PK	05	2015	grade_2	47	47
121264	WI	Milwaukee	school	5510830	4018	Public school	Oak Creek-Franklin Joint	551083001406	10	Carollton Elementary		Regular School	No	1.0	PK	05	2015	grade_2	68	68
121770	WI	Jefferson	school	5511350	4221	Public school	Palmyra-Eagle Area	551135001513	10	Eagle Elementary		Regular School	No	1.0	PK	06	2015	grade_2	19	19
121914	WI	Vilas	school	5511710	4330	Public school	Phelps	551171001539	10	Phelps Elementary		Regular School	No	1.0	PK	08	2015	grade_2	4	4
123551	WI	Washburn	school	5513710	5306	Public school	Shell Lake	551371000507	10	Shell Lake Primary (K-2)		Regular School	No	1.0	PK	02	2015	grade_2	53	53
123661	WI	Washington	school	5513950	5390	Public school	Slinger	551395001818	10	Allenton Elementary		Regular School	No	1.0	PK	05	2015	grade_2	61	61
123720	WI	Milwaukee	school	5514040	5439	Public school	South Milwaukee	551404001826	10	Blakewood Elementary		Regular School	No	1.0	PK	05	2015	grade_2	49	49
124830	WI	Bayfield	school	5515540	6027	Public school	Washburn	551554002453	10	Washburn Elementary		Regular School	No	1.0	PK	05	2015	grade_2	30	30
284057	WI	Walworth	school	5503640	1380	Public school	Delavan-Darien	550364002239	10	Darien Elementary		Regular School	No	1.0	PK	05	2016	grade_2	28	28
285997	WI	La Crosse	school	5506540	2562	Public school	Holmen	550654002259	10	Evergreen Elementary		Regular School	No	1.0	KG	05	2016	grade_2	59	59
286059	WI	Outagamie	school	5506600	2583	Public school	Hortonville Area	550660002407	10	Greenville Elementary		Regular School	No	1.0	PK	04	2016	grade_2	100	100
286210	WI	Saint Croix	school	5506690	2611	Public school	Hudson	550669002332	10	Willow River Elementary		Regular School	No	1.0	KG	05	2016	grade_2	54	54
290379	WI	Green	school	5509840	3682	Public school	Monroe	550984002771	10	Abraham Lincoln Elementary		Regular School	No	1.0	PK	05	2016	grade_2	43	43
290413	WI	Marquette	school	5509870	3689	Public school	Montello	550987001302	10	Forest Lane Community School	charter	Regular School	Yes	1.0	PK	06	2016	grade_2	42	42
290975	WI	Saint Croix	school	5510620	3962	Public school	New Richmond	551062000225	10	New Richmond Paperjack Elementary		Regular School	No	1.0	PK	05	2016	grade_2	55	55
291233	WI	Milwaukee	school	5510830	4018	Public school	Oak Creek-Franklin Joint	551083001406	10	Carollton Elementary		Regular School	No	1.0	PK	05	2016	grade_2	78	78
291732	WI	Jefferson	school	5511350	4221	Public school	Palmyra-Eagle Area	551135001513	10	Eagle Elementary		Regular School	No	1.0	PK	06	2016	grade_2	22	22
291875	WI	Vilas	school	5511710	4330	Public school	Phelps	551171001539	10	Phelps Elementary		Regular School	No	1.0	PK	08	2016	grade_2	10	10
293505	WI	Washburn	school	5513710	5306	Public school	Shell Lake	551371000507	10	Shell Lake Primary (K-2)		Regular School	No	1.0	PK	02	2016	grade_2	51	51
293616	WI	Washington	school	5513950	5390	Public school	Slinger	551395001818	10	Allenton Elementary		Regular School	No	1.0	PK	05	2016	grade_2	53	53
293675	WI	Milwaukee	school	5514040	5439	Public school	South Milwaukee	551404001826	10	Blakewood Elementary		Regular School	No	1.0	PK	05	2016	grade_2	51	51
294764	WI	Bayfield	school	5515540	6027	Public school	Washburn	551554002453	10	Washburn Elementary		Regular School	No	1.0	PK	05	2016	grade_2	39	39
329878	WI	La Crosse	school	5506540	2562	Public school	Holmen	550654002259	10	Evergreen Elementary		Regular School	No	Elementary	KG	05	2017	grade_2	67	67
329940	WI	Outagamie	school	5506600	2583	Public school	Hortonville Area	550660002407	10	Greenville Elementary		Regular School	No	Elementary	PK	04	2017	grade_2	121	121
330088	WI	Saint Croix	school	5506690	2611	Public school	Hudson	550669002332	10	Willow River Elementary		Regular School	No	Elementary	KG	05	2017	grade_2	65	65
334250	WI	Green	school	5509840	3682	Public school	Monroe	550984002771	10	Abraham Lincoln Elementary		Regular School	No	Elementary	PK	05	2017	grade_2	36	36
334286	WI	Marquette	school	5509870	3689	Public school	Montello	550987001302	10	Forest Lane Community School	charter	Regular School	Yes	Elementary	PK	05	2017	grade_2	42	42
334838	WI	Saint Croix	school	5510620	3962	Public school	New Richmond	551062000225	10	New Richmond Paperjack Elementary		Regular School	No	Elementary	PK	05	2017	grade_2	56	56
335085	WI	Milwaukee	school	5510830	4018	Public school	Oak Creek-Franklin Joint	551083001406	10	Carollton Elementary		Regular School	No	Elementary	PK	05	2017	grade_2	69	69
335601	WI	Jefferson	school	5511350	4221	Public school	Palmyra-Eagle Area	551135001513	10	Eagle Elementary		Regular School	No	Elementary	PK	06	2017	grade_2	20	20
335749	WI	Vilas	school	5511710	4330	Public school	Phelps	551171001539	10	Phelps Elementary		Regular School	No	Elementary	PK	08	2017	grade_2	8	8
337396	WI	Washburn	school	5513710	5306	Public school	Shell Lake	551371000507	10	Shell Lake Primary (K-2)		Regular School	No	Elementary	PK	02	2017	grade_2	50	50
337506	WI	Washington	school	5513950	5390	Public school	Slinger	551395001818	10	Allenton Elementary		Regular School	No	Elementary	PK	05	2017	grade_2	54	54
337566	WI	Milwaukee	school	5514040	5439	Public school	South Milwaukee	551404001826	10	Blakewood Elementary		Regular School	No	Elementary	PK	05	2017	grade_2	57	57
338667	WI	Bayfield	school	5515540	6027	Public school	Washburn	551554002453	10	Washburn Elementary		Regular School	No	Elementary	PK	05	2017	grade_2	44	44
2322425	WI	La Crosse	school	5506540	2562	Public school	Holmen	550654002259	10	Evergreen Elementary		Regular School	No	Elementary	KG	05	2020	grade_2	59	59
2322500	WI	Outagamie	school	5506600	2583	Public school	Hortonville Area	550660002407	10	Greenville Elementary		Regular School	No	Elementary	PK	04	2020	grade_2	124	124
2322651	WI	Saint Croix	school	5506690	2611	Public school	Hudson	550669002332	10	Willow River Elementary		Regular School	No	Elementary	PK	05	2020	grade_2	46	46
2326854	WI	Green	school	5509840	3682	Public school	Monroe	550984002771	10	Abraham Lincoln Elementary		Regular School	No	Elementary	PK	05	2020	grade_2	33	33
2326892	WI	Marquette	school	5509870	3689	Public school	Montello	550987001302	10	Forest Lane Community School		Regular School	No	Elementary	PK	05	2020	grade_2	32	32
2327456	WI	Saint Croix	school	5510620	3962	Public school	New Richmond	551062000225	10	New Richmond Paperjack Elementary		Regular School	No	Elementary	KG	05	2020	grade_2	56	56
2327731	WI	Milwaukee	school	5510830	4018	Public school	Oak Creek-Franklin Joint	551083001406	10	Carollton Elementary		Regular School	No	Elementary	PK	05	2020	grade_2	58	58
2328229	WI	Jefferson	school	5511350	4221	Public school	Palmyra-Eagle Area	551135001513	10	Eagle Elementary		Regular School	No	Elementary	PK	06	2020	grade_2	10	10
2328385	WI	Vilas	school	5511710	4330	Public school	Phelps	551171001539	10	Phelps Elementary		Regular School	No	Elementary	PK	08	2020	grade_2	7	7
2329991	WI	Washburn	school	5513710	5306	Public school	Shell Lake	551371000507	10	Shell Lake Primary (K-2)		Regular School	No	Elementary	PK	02	2020	grade_2	46	46
2330100	WI	Washington	school	5513950	5390	Public school	Slinger	551395001818	10	Allenton Elementary		Regular School	No	Elementary	PK	05	2020	grade_2	59	59
2330173	WI	Milwaukee	school	5514040	5439	Public school	South Milwaukee	551404001826	10	Blakewood Elementary		Regular School	No	Elementary	PK	05	2020	grade_2	47	47
2331343	WI	Bayfield	school	5515540	6027	Public school	Washburn	551554002453	10	Washburn Elementary		Regular School	No	Elementary	PK	06	2020	grade_2	29	29
2337252	WI	La Crosse	school	5506540	2562	Public school	Holmen	550654002259	10	Evergreen Elementary		Regular School	No	Elementary	KG	05	2021	grade_2	55	55
2337342	WI	Outagamie	school	5506600	2583	Public school	Hortonville Area	550660002407	10	Greenville Elementary		Regular School	No	Elementary	PK	04	2021	grade_2	118	118
2337496	WI	Saint Croix	school	5506690	2611	Public school	Hudson	550669002332	10	Willow River Elementary		Regular School	No	Elementary	PK	05	2021	grade_2	53	53
2341721	WI	Green	school	5509840	3682	Public school	Monroe	550984002771	10	Abraham Lincoln Elementary		Regular School	No	Elementary	PK	05	2021	grade_2	37	37
2341759	WI	Marquette	school	5509870	3689	Public school	Montello	550987001302	10	Forest Lane Community School		Regular School	No	Elementary	PK	05	2021	grade_2	30	30
2342330	WI	Saint Croix	school	5510620	3962	Public school	New Richmond	551062000225	10	New Richmond Paperjack Elementary		Regular School	No	Elementary	KG	05	2021	grade_2	52	52
2342616	WI	Milwaukee	school	5510830	4018	Public school	Oak Creek-Franklin Joint	551083001406	10	Carollton Elementary		Regular School	No	Elementary	PK	05	2021	grade_2	67	67
2343126	WI	Jefferson	school	5511350	4221	Public school	Palmyra-Eagle Area	551135001513	10	Eagle Elementary		Regular School	No	Elementary	PK	06	2021	grade_2	36	36
2343275	WI	Vilas	school	5511710	4330	Public school	Phelps	551171001539	10	Phelps Elementary		Regular School	No	Elementary	PK	08	2021	grade_2	3	3
2344886	WI	Washburn	school	5513710	5306	Public school	Shell Lake	551371000507	10	Shell Lake Primary (K-2)		Regular School	No	Elementary	PK	02	2021	grade_2	45	45
2344997	WI	Washington	school	5513950	5390	Public school	Slinger	551395001818	10	Allenton Elementary		Regular School	No	Elementary	PK	05	2021	grade_2	70	70
2345077	WI	Milwaukee	school	5514040	5439	Public school	South Milwaukee	551404001826	10	Blakewood Elementary		Regular School	No	Elementary	PK	05	2021	grade_2	47	47
2346266	WI	Bayfield	school	5515540	6027	Public school	Washburn	551554002453	10	Washburn Elementary		Regular School	No	Elementary	PK	06	2021	grade_2	36	36
3078176	WI	La Crosse	school	5506540	2562	Public school	Holmen	550654002259	10	Evergreen Elementary		Regular School	No	Elementary	KG	05	2019	grade_2	56	56
3078251	WI	Outagamie	school	5506600	2583	Public school	Hortonville Area	550660002407	10	Greenville Elementary		Regular School	No	Elementary	PK	04	2019	grade_2	138	138
3078402	WI	Saint Croix	school	5506690	2611	Public school	Hudson	550669002332	10	Willow River Elementary		Regular School	No	Elementary	KG	05	2019	grade_2	48	48
3082620	WI	Green	school	5509840	3682	Public school	Monroe	550984002771	10	Abraham Lincoln Elementary		Regular School	No	Elementary	PK	05	2019	grade_2	31	31
3082661	WI	Marquette	school	5509870	3689	Public school	Montello	550987001302	10	Forest Lane Community School		Regular School	No	Elementary	PK	05	2019	grade_2	43	43
3083212	WI	Saint Croix	school	5510620	3962	Public school	New Richmond	551062000225	10	New Richmond Paperjack Elementary		Regular School	No	Elementary	KG	05	2019	grade_2	55	55
3083468	WI	Milwaukee	school	5510830	4018	Public school	Oak Creek-Franklin Joint	551083001406	10	Carollton Elementary		Regular School	No	Elementary	PK	05	2019	grade_2	60	60
3083980	WI	Jefferson	school	5511350	4221	Public school	Palmyra-Eagle Area	551135001513	10	Eagle Elementary		Regular School	No	Elementary	PK	06	2019	grade_2	14	14
3084135	WI	Vilas	school	5511710	4330	Public school	Phelps	551171001539	10	Phelps Elementary		Regular School	No	Elementary	PK	08	2019	grade_2	12	12
3085721	WI	Washburn	school	5513710	5306	Public school	Shell Lake	551371000507	10	Shell Lake Primary (K-2)		Regular School	No	Elementary	PK	02	2019	grade_2	46	46
3085832	WI	Washington	school	5513950	5390	Public school	Slinger	551395001818	10	Allenton Elementary		Regular School	No	Elementary	PK	05	2019	grade_2	63	63
3085892	WI	Milwaukee	school	5514040	5439	Public school	South Milwaukee	551404001826	10	Blakewood Elementary		Regular School	No	Elementary	PK	05	2019	grade_2	45	45
3087040	WI	Bayfield	school	5515540	6027	Public school	Washburn	551554002453	10	Washburn Elementary		Regular School	No	Elementary	PK	06	2019	grade_2	39	39
3092949	WI	La Crosse	school	5506540	2562	Public school	Holmen	550654002259	10	Evergreen Elementary		Regular School	No	Elementary	KG	05	2018	grade_2	68	68
3093011	WI	Outagamie	school	5506600	2583	Public school	Hortonville Area	550660002407	10	Greenville Elementary		Regular School	No	Elementary	PK	04	2018	grade_2	100	100
3093160	WI	Saint Croix	school	5506690	2611	Public school	Hudson	550669002332	10	Willow River Elementary		Regular School	No	Elementary	KG	05	2018	grade_2	61	61
3097323	WI	Green	school	5509840	3682	Public school	Monroe	550984002771	10	Abraham Lincoln Elementary		Regular School	No	Elementary	PK	05	2018	grade_2	37	37
3097359	WI	Marquette	school	5509870	3689	Public school	Montello	550987001302	10	Forest Lane Community School		Regular School	No	Elementary	PK	05	2018	grade_2	45	45
3097915	WI	Saint Croix	school	5510620	3962	Public school	New Richmond	551062000225	10	New Richmond Paperjack Elementary		Regular School	No	Elementary	KG	05	2018	grade_2	56	56
3098169	WI	Milwaukee	school	5510830	4018	Public school	Oak Creek-Franklin Joint	551083001406	10	Carollton Elementary		Regular School	No	Elementary	PK	05	2018	grade_2	75	75
3098678	WI	Jefferson	school	5511350	4221	Public school	Palmyra-Eagle Area	551135001513	10	Eagle Elementary		Regular School	No	Elementary	PK	06	2018	grade_2	15	15
3098831	WI	Vilas	school	5511710	4330	Public school	Phelps	551171001539	10	Phelps Elementary		Regular School	No	Elementary	PK	08	2018	grade_2	12	12
3100452	WI	Washburn	school	5513710	5306	Public school	Shell Lake	551371000507	10	Shell Lake Primary (K-2)		Regular School	No	Elementary	PK	02	2018	grade_2	53	53
3100561	WI	Washington	school	5513950	5390	Public school	Slinger	551395001818	10	Allenton Elementary		Regular School	No	Elementary	PK	05	2018	grade_2	70	70
3100620	WI	Milwaukee	school	5514040	5439	Public school	South Milwaukee	551404001826	10	Blakewood Elementary		Regular School	No	Elementary	PK	05	2018	grade_2	46	46
3101737	WI	Bayfield	school	5515540	6027	Public school	Washburn	551554002453	10	Washburn Elementary		Regular School	No	Elementary	PK	06	2018	grade_2	34	34
117778	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852002263	15	Lincoln Elementary		Regular School	No	1.0	PK	05	2015	grade_2	5	5
124874	WI	Racine	school	5515660	6113	Public school	Waterford Graded J1	551566002454	15	Evergreen Elementary		Regular School	No	1.0	PK	06	2015	grade_2	49	49
294807	WI	Racine	school	5515660	6113	Public school	Waterford Graded J1	551566002454	15	Evergreen Elementary		Regular School	No	1.0	PK	06	2016	grade_2	45	45
338710	WI	Racine	school	5515660	6113	Public school	Waterford Graded J1	551566002454	15	Evergreen Elementary		Regular School	No	Elementary	PK	06	2017	grade_2	50	50
2331387	WI	Racine	school	5515660	6113	Public school	Waterford Graded J1	551566002454	15	Evergreen Elementary		Regular School	No	Elementary	PK	06	2020	grade_2	56	56
2346309	WI	Racine	school	5515660	6113	Public school	Waterford Graded J1	551566002454	15	Evergreen Elementary		Regular School	No	Elementary	PK	05	2021	grade_2	46	46
3087084	WI	Racine	school	5515660	6113	Public school	Waterford Graded J1	551566002454	15	Evergreen Elementary		Regular School	No	Elementary	PK	06	2019	grade_2	53	53
3101781	WI	Racine	school	5515660	6113	Public school	Waterford Graded J1	551566002454	15	Evergreen Elementary		Regular School	No	Elementary	PK	06	2018	grade_2	51	51