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
114078	WI	Walworth	school	5503640	1380	Public school	Delavan-Darien	550364002239	10	Darien Elementary		Regular School	No	1.0	PK	05	2015	grade_1	29	29
116000	WI	La Crosse	school	5506540	2562	Public school	Holmen	550654002259	10	Evergreen Elementary		Regular School	No	1.0	KG	05	2015	grade_1	58	58
116062	WI	Outagamie	school	5506600	2583	Public school	Hortonville Area	550660002407	10	Greenville Elementary		Regular School	No	1.0	PK	04	2015	grade_1	99	99
116211	WI	Saint Croix	school	5506690	2611	Public school	Hudson	550669002332	10	Willow River Elementary		Regular School	No	1.0	KG	05	2015	grade_1	53	53
120420	WI	Green	school	5509840	3682	Public school	Monroe	550984002771	10	Abraham Lincoln Elementary		Regular School	No	1.0	PK	05	2015	grade_1	43	43
120453	WI	Marquette	school	5509870	3689	Public school	Montello	550987001302	10	Forest Lane Community School	charter	Regular School	Yes	1.0	PK	06	2015	grade_1	43	43
121014	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_1	62	62
121263	WI	Milwaukee	school	5510830	4018	Public school	Oak Creek-Franklin Joint	551083001406	10	Carollton Elementary		Regular School	No	1.0	PK	05	2015	grade_1	75	75
121769	WI	Jefferson	school	5511350	4221	Public school	Palmyra-Eagle Area	551135001513	10	Eagle Elementary		Regular School	No	1.0	PK	06	2015	grade_1	21	21
121913	WI	Vilas	school	5511710	4330	Public school	Phelps	551171001539	10	Phelps Elementary		Regular School	No	1.0	PK	08	2015	grade_1	11	11
122165	WI	Crawford	school	5512150	4543	Public school	Prairie du Chien Area	551215002508	10	BA Kennedy School		Regular School	No	1.0	PK	01	2015	grade_1	80	80
123550	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_1	48	48
123660	WI	Washington	school	5513950	5390	Public school	Slinger	551395001818	10	Allenton Elementary		Regular School	No	1.0	PK	05	2015	grade_1	50	50
123719	WI	Milwaukee	school	5514040	5439	Public school	South Milwaukee	551404001826	10	Blakewood Elementary		Regular School	No	1.0	PK	05	2015	grade_1	50	50
124829	WI	Bayfield	school	5515540	6027	Public school	Washburn	551554002453	10	Washburn Elementary		Regular School	No	1.0	PK	05	2015	grade_1	35	35
284056	WI	Walworth	school	5503640	1380	Public school	Delavan-Darien	550364002239	10	Darien Elementary		Regular School	No	1.0	PK	05	2016	grade_1	18	18
285996	WI	La Crosse	school	5506540	2562	Public school	Holmen	550654002259	10	Evergreen Elementary		Regular School	No	1.0	KG	05	2016	grade_1	64	64
286058	WI	Outagamie	school	5506600	2583	Public school	Hortonville Area	550660002407	10	Greenville Elementary		Regular School	No	1.0	PK	04	2016	grade_1	112	112
286209	WI	Saint Croix	school	5506690	2611	Public school	Hudson	550669002332	10	Willow River Elementary		Regular School	No	1.0	KG	05	2016	grade_1	65	65
290378	WI	Green	school	5509840	3682	Public school	Monroe	550984002771	10	Abraham Lincoln Elementary		Regular School	No	1.0	PK	05	2016	grade_1	38	38
290412	WI	Marquette	school	5509870	3689	Public school	Montello	550987001302	10	Forest Lane Community School	charter	Regular School	Yes	1.0	PK	06	2016	grade_1	36	36
290974	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_1	60	60
291232	WI	Milwaukee	school	5510830	4018	Public school	Oak Creek-Franklin Joint	551083001406	10	Carollton Elementary		Regular School	No	1.0	PK	05	2016	grade_1	67	67
291731	WI	Jefferson	school	5511350	4221	Public school	Palmyra-Eagle Area	551135001513	10	Eagle Elementary		Regular School	No	1.0	PK	06	2016	grade_1	19	19
291874	WI	Vilas	school	5511710	4330	Public school	Phelps	551171001539	10	Phelps Elementary		Regular School	No	1.0	PK	08	2016	grade_1	8	8
292126	WI	Crawford	school	5512150	4543	Public school	Prairie du Chien Area	551215002508	10	BA Kennedy School		Regular School	No	1.0	PK	01	2016	grade_1	67	67
293504	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_1	51	51
293615	WI	Washington	school	5513950	5390	Public school	Slinger	551395001818	10	Allenton Elementary		Regular School	No	1.0	PK	05	2016	grade_1	50	50
293674	WI	Milwaukee	school	5514040	5439	Public school	South Milwaukee	551404001826	10	Blakewood Elementary		Regular School	No	1.0	PK	05	2016	grade_1	53	53
294763	WI	Bayfield	school	5515540	6027	Public school	Washburn	551554002453	10	Washburn Elementary		Regular School	No	1.0	PK	05	2016	grade_1	45	45
329877	WI	La Crosse	school	5506540	2562	Public school	Holmen	550654002259	10	Evergreen Elementary		Regular School	No	Elementary	KG	05	2017	grade_1	64	64
329939	WI	Outagamie	school	5506600	2583	Public school	Hortonville Area	550660002407	10	Greenville Elementary		Regular School	No	Elementary	PK	04	2017	grade_1	100	100
330087	WI	Saint Croix	school	5506690	2611	Public school	Hudson	550669002332	10	Willow River Elementary		Regular School	No	Elementary	KG	05	2017	grade_1	64	64
334249	WI	Green	school	5509840	3682	Public school	Monroe	550984002771	10	Abraham Lincoln Elementary		Regular School	No	Elementary	PK	05	2017	grade_1	40	40
334285	WI	Marquette	school	5509870	3689	Public school	Montello	550987001302	10	Forest Lane Community School	charter	Regular School	Yes	Elementary	PK	05	2017	grade_1	42	42
334837	WI	Saint Croix	school	5510620	3962	Public school	New Richmond	551062000225	10	New Richmond Paperjack Elementary		Regular School	No	Elementary	PK	05	2017	grade_1	58	58
335084	WI	Milwaukee	school	5510830	4018	Public school	Oak Creek-Franklin Joint	551083001406	10	Carollton Elementary		Regular School	No	Elementary	PK	05	2017	grade_1	70	70
335600	WI	Jefferson	school	5511350	4221	Public school	Palmyra-Eagle Area	551135001513	10	Eagle Elementary		Regular School	No	Elementary	PK	06	2017	grade_1	14	14
335748	WI	Vilas	school	5511710	4330	Public school	Phelps	551171001539	10	Phelps Elementary		Regular School	No	Elementary	PK	08	2017	grade_1	10	10
336005	WI	Crawford	school	5512150	4543	Public school	Prairie du Chien Area	551215002508	10	BA Kennedy School		Regular School	No	Elementary	PK	01	2017	grade_1	77	77
337395	WI	Washburn	school	5513710	5306	Public school	Shell Lake	551371000507	10	Shell Lake Primary (K-2)		Regular School	No	Elementary	PK	02	2017	grade_1	48	48
337505	WI	Washington	school	5513950	5390	Public school	Slinger	551395001818	10	Allenton Elementary		Regular School	No	Elementary	PK	05	2017	grade_1	70	70
337565	WI	Milwaukee	school	5514040	5439	Public school	South Milwaukee	551404001826	10	Blakewood Elementary		Regular School	No	Elementary	PK	05	2017	grade_1	46	46
338666	WI	Bayfield	school	5515540	6027	Public school	Washburn	551554002453	10	Washburn Elementary		Regular School	No	Elementary	PK	05	2017	grade_1	30	30
2322424	WI	La Crosse	school	5506540	2562	Public school	Holmen	550654002259	10	Evergreen Elementary		Regular School	No	Elementary	KG	05	2020	grade_1	52	52
2322499	WI	Outagamie	school	5506600	2583	Public school	Hortonville Area	550660002407	10	Greenville Elementary		Regular School	No	Elementary	PK	04	2020	grade_1	116	116
2322650	WI	Saint Croix	school	5506690	2611	Public school	Hudson	550669002332	10	Willow River Elementary		Regular School	No	Elementary	PK	05	2020	grade_1	59	59
2326853	WI	Green	school	5509840	3682	Public school	Monroe	550984002771	10	Abraham Lincoln Elementary		Regular School	No	Elementary	PK	05	2020	grade_1	39	39
2326891	WI	Marquette	school	5509870	3689	Public school	Montello	550987001302	10	Forest Lane Community School		Regular School	No	Elementary	PK	05	2020	grade_1	38	38
2327455	WI	Saint Croix	school	5510620	3962	Public school	New Richmond	551062000225	10	New Richmond Paperjack Elementary		Regular School	No	Elementary	KG	05	2020	grade_1	55	55
2327730	WI	Milwaukee	school	5510830	4018	Public school	Oak Creek-Franklin Joint	551083001406	10	Carollton Elementary		Regular School	No	Elementary	PK	05	2020	grade_1	66	66
2328228	WI	Jefferson	school	5511350	4221	Public school	Palmyra-Eagle Area	551135001513	10	Eagle Elementary		Regular School	No	Elementary	PK	06	2020	grade_1	18	18
2328384	WI	Vilas	school	5511710	4330	Public school	Phelps	551171001539	10	Phelps Elementary		Regular School	No	Elementary	PK	08	2020	grade_1	5	5
2328654	WI	Crawford	school	5512150	4543	Public school	Prairie du Chien Area	551215002508	10	BA Kennedy School		Regular School	No	Elementary	PK	01	2020	grade_1	72	72
2329990	WI	Washburn	school	5513710	5306	Public school	Shell Lake	551371000507	10	Shell Lake Primary (K-2)		Regular School	No	Elementary	PK	02	2020	grade_1	54	54
2330099	WI	Washington	school	5513950	5390	Public school	Slinger	551395001818	10	Allenton Elementary		Regular School	No	Elementary	PK	05	2020	grade_1	70	70
2330172	WI	Milwaukee	school	5514040	5439	Public school	South Milwaukee	551404001826	10	Blakewood Elementary		Regular School	No	Elementary	PK	05	2020	grade_1	45	45
2331342	WI	Bayfield	school	5515540	6027	Public school	Washburn	551554002453	10	Washburn Elementary		Regular School	No	Elementary	PK	06	2020	grade_1	38	38
2337251	WI	La Crosse	school	5506540	2562	Public school	Holmen	550654002259	10	Evergreen Elementary		Regular School	No	Elementary	KG	05	2021	grade_1	52	52
2337341	WI	Outagamie	school	5506600	2583	Public school	Hortonville Area	550660002407	10	Greenville Elementary		Regular School	No	Elementary	PK	04	2021	grade_1	94	94
2337495	WI	Saint Croix	school	5506690	2611	Public school	Hudson	550669002332	10	Willow River Elementary		Regular School	No	Elementary	PK	05	2021	grade_1	38	38
2341720	WI	Green	school	5509840	3682	Public school	Monroe	550984002771	10	Abraham Lincoln Elementary		Regular School	No	Elementary	PK	05	2021	grade_1	30	30
2341758	WI	Marquette	school	5509870	3689	Public school	Montello	550987001302	10	Forest Lane Community School		Regular School	No	Elementary	PK	05	2021	grade_1	31	31
2342329	WI	Saint Croix	school	5510620	3962	Public school	New Richmond	551062000225	10	New Richmond Paperjack Elementary		Regular School	No	Elementary	KG	05	2021	grade_1	59	59
2342615	WI	Milwaukee	school	5510830	4018	Public school	Oak Creek-Franklin Joint	551083001406	10	Carollton Elementary		Regular School	No	Elementary	PK	05	2021	grade_1	53	53
2343125	WI	Jefferson	school	5511350	4221	Public school	Palmyra-Eagle Area	551135001513	10	Eagle Elementary		Regular School	No	Elementary	PK	06	2021	grade_1	32	32
2343274	WI	Vilas	school	5511710	4330	Public school	Phelps	551171001539	10	Phelps Elementary		Regular School	No	Elementary	PK	08	2021	grade_1	3	3
2343544	WI	Crawford	school	5512150	4543	Public school	Prairie du Chien Area	551215002508	10	BA Kennedy School		Regular School	No	Elementary	PK	01	2021	grade_1	70	70
2344885	WI	Washburn	school	5513710	5306	Public school	Shell Lake	551371000507	10	Shell Lake Primary (K-2)		Regular School	No	Elementary	PK	02	2021	grade_1	21	21
2344996	WI	Washington	school	5513950	5390	Public school	Slinger	551395001818	10	Allenton Elementary		Regular School	No	Elementary	PK	05	2021	grade_1	64	64
2345076	WI	Milwaukee	school	5514040	5439	Public school	South Milwaukee	551404001826	10	Blakewood Elementary		Regular School	No	Elementary	PK	05	2021	grade_1	48	48
2346265	WI	Bayfield	school	5515540	6027	Public school	Washburn	551554002453	10	Washburn Elementary		Regular School	No	Elementary	PK	06	2021	grade_1	42	42
3078175	WI	La Crosse	school	5506540	2562	Public school	Holmen	550654002259	10	Evergreen Elementary		Regular School	No	Elementary	KG	05	2019	grade_1	57	57
3078250	WI	Outagamie	school	5506600	2583	Public school	Hortonville Area	550660002407	10	Greenville Elementary		Regular School	No	Elementary	PK	04	2019	grade_1	122	122
3078401	WI	Saint Croix	school	5506690	2611	Public school	Hudson	550669002332	10	Willow River Elementary		Regular School	No	Elementary	KG	05	2019	grade_1	38	38
3082619	WI	Green	school	5509840	3682	Public school	Monroe	550984002771	10	Abraham Lincoln Elementary		Regular School	No	Elementary	PK	05	2019	grade_1	29	29
3082660	WI	Marquette	school	5509870	3689	Public school	Montello	550987001302	10	Forest Lane Community School		Regular School	No	Elementary	PK	05	2019	grade_1	34	34
3083211	WI	Saint Croix	school	5510620	3962	Public school	New Richmond	551062000225	10	New Richmond Paperjack Elementary		Regular School	No	Elementary	KG	05	2019	grade_1	59	59
3083467	WI	Milwaukee	school	5510830	4018	Public school	Oak Creek-Franklin Joint	551083001406	10	Carollton Elementary		Regular School	No	Elementary	PK	05	2019	grade_1	61	61
3083979	WI	Jefferson	school	5511350	4221	Public school	Palmyra-Eagle Area	551135001513	10	Eagle Elementary		Regular School	No	Elementary	PK	06	2019	grade_1	11	11
3084134	WI	Vilas	school	5511710	4330	Public school	Phelps	551171001539	10	Phelps Elementary		Regular School	No	Elementary	PK	08	2019	grade_1	7	7
3084392	WI	Crawford	school	5512150	4543	Public school	Prairie du Chien Area	551215002508	10	BA Kennedy School		Regular School	No	Elementary	PK	01	2019	grade_1	74	74
3085720	WI	Washburn	school	5513710	5306	Public school	Shell Lake	551371000507	10	Shell Lake Primary (K-2)		Regular School	No	Elementary	PK	02	2019	grade_1	47	47
3085831	WI	Washington	school	5513950	5390	Public school	Slinger	551395001818	10	Allenton Elementary		Regular School	No	Elementary	PK	05	2019	grade_1	56	56
3085891	WI	Milwaukee	school	5514040	5439	Public school	South Milwaukee	551404001826	10	Blakewood Elementary		Regular School	No	Elementary	PK	05	2019	grade_1	45	45
3087039	WI	Bayfield	school	5515540	6027	Public school	Washburn	551554002453	10	Washburn Elementary		Regular School	No	Elementary	PK	06	2019	grade_1	25	25
3092948	WI	La Crosse	school	5506540	2562	Public school	Holmen	550654002259	10	Evergreen Elementary		Regular School	No	Elementary	KG	05	2018	grade_1	51	51
3093010	WI	Outagamie	school	5506600	2583	Public school	Hortonville Area	550660002407	10	Greenville Elementary		Regular School	No	Elementary	PK	04	2018	grade_1	131	131
3093159	WI	Saint Croix	school	5506690	2611	Public school	Hudson	550669002332	10	Willow River Elementary		Regular School	No	Elementary	KG	05	2018	grade_1	51	51
3097322	WI	Green	school	5509840	3682	Public school	Monroe	550984002771	10	Abraham Lincoln Elementary		Regular School	No	Elementary	PK	05	2018	grade_1	35	35
3097358	WI	Marquette	school	5509870	3689	Public school	Montello	550987001302	10	Forest Lane Community School		Regular School	No	Elementary	PK	05	2018	grade_1	46	46
3097914	WI	Saint Croix	school	5510620	3962	Public school	New Richmond	551062000225	10	New Richmond Paperjack Elementary		Regular School	No	Elementary	KG	05	2018	grade_1	56	56
3098168	WI	Milwaukee	school	5510830	4018	Public school	Oak Creek-Franklin Joint	551083001406	10	Carollton Elementary		Regular School	No	Elementary	PK	05	2018	grade_1	61	61
3098677	WI	Jefferson	school	5511350	4221	Public school	Palmyra-Eagle Area	551135001513	10	Eagle Elementary		Regular School	No	Elementary	PK	06	2018	grade_1	18	18
3098830	WI	Vilas	school	5511710	4330	Public school	Phelps	551171001539	10	Phelps Elementary		Regular School	No	Elementary	PK	08	2018	grade_1	11	11
3099086	WI	Crawford	school	5512150	4543	Public school	Prairie du Chien Area	551215002508	10	BA Kennedy School		Regular School	No	Elementary	PK	01	2018	grade_1	75	75
3100451	WI	Washburn	school	5513710	5306	Public school	Shell Lake	551371000507	10	Shell Lake Primary (K-2)		Regular School	No	Elementary	PK	02	2018	grade_1	42	42
3100560	WI	Washington	school	5513950	5390	Public school	Slinger	551395001818	10	Allenton Elementary		Regular School	No	Elementary	PK	05	2018	grade_1	58	58
3100619	WI	Milwaukee	school	5514040	5439	Public school	South Milwaukee	551404001826	10	Blakewood Elementary		Regular School	No	Elementary	PK	05	2018	grade_1	41	41
3101736	WI	Bayfield	school	5515540	6027	Public school	Washburn	551554002453	10	Washburn Elementary		Regular School	No	Elementary	PK	06	2018	grade_1	38	38
124873	WI	Racine	school	5515660	6113	Public school	Waterford Graded J1	551566002454	15	Evergreen Elementary		Regular School	No	1.0	PK	06	2015	grade_1	47	47