schools

Data source: Big Local News · About: Big Local

Custom SQL query returning 101 rows (hide)

Query parameters

rowidstatecountycounty_state_idadmin_leveldistrict_nces_iddistrict_state_iddistrict_state_typedistrictschool_nces_idschool_state_idschoolschool_state_typeccd_school_typeccd_charter_schoolccd_school_lvlccd_school_low_gradeccd_school_high_gradeyeartermgradewhiteblackhispanicnative_americannative_american_alaskan_nativeasiannative_hawaiianasian_pacific_islandernative_hawaiian_pacific_islanderpacific_islandermultiracialunknown_racemalefemalenon_binaryunknown_genderellell_percenthomelesshomeless_percentlow_incomefree_and_reducedfree_and_reduced_percentdisabilitysection_504totalwhite_intblack_inthispanic_intnative_american_intnative_american_alaskan_native_intasian_intnative_hawaiian_intasian_pacific_islander_intnative_hawaiian_pacific_islander_intpacific_islander_intmultiracial_intunknown_race_intmale_intfemale_intnon_binary_intunknown_gender_intell_inthomeless_intlow_income_intfree_and_reduced_intdisability_intsection_504_inttotal_int
2333174 WI Outagamie   school 5500390 147 Public school Appleton Area 550039003021 820 Appleview   Special Education School No Other PK 12 2021   pre_kindergarten                                                   30                                             30
2333208 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000050 80 Columbus Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   20                                             20
2333222 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000051 100 Edison Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   6                                             6
2333257 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000054 160 Franklin Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   6                                             6
2333266 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000055 180 Highlands Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   7                                             7
2333307 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000058 260 Johnston Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   15                                             15
2333331 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000061 320 McKinley Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   4                                             4
3074170 WI Outagamie   school 5500390 147 Public school Appleton Area 550039003021 820 Appleview   Special Education School No Other PK 12 2019   pre_kindergarten                                                   36                                             36
3074204 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000050 80 Columbus Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten                                                   7                                             7
3074218 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000051 100 Edison Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten                                                   8                                             8
3074253 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000054 160 Franklin Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten                                                   10                                             10
3074262 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000055 180 Highlands Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten                                                   10                                             10
3074303 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000058 260 Johnston Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten                                                   30                                             30
3074316 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000059 280 Lincoln Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten                                                   22                                             22
3074328 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000061 320 McKinley Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten                                                   12                                             12
3088926 WI Outagamie   school 5500390 147 Public school Appleton Area 550039003021 820 Appleview   Special Education School No Other PK 12 2018   pre_kindergarten                                                   28                                             28
3088960 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000050 80 Columbus Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten                                                   3                                             3
3088974 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000051 100 Edison Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten                                                   13                                             13
3089009 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000054 160 Franklin Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten                                                   11                                             11
3089018 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000055 180 Highlands Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten                                                   8                                             8
3089059 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000058 260 Johnston Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten                                                   10                                             10
3089072 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000059 280 Lincoln Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten                                                   6                                             6
3089084 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000061 320 McKinley Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten                                                   11                                             11
112257 WI Trempealeau   school 5500420 154 Public school Arcadia 550042000067 20 Arcadia El   Regular School No 1.0 PK 08 2015   pre_kindergarten                                                   9                                             9
282231 WI Trempealeau   school 5500420 154 Public school Arcadia 550042000067 20 Arcadia El   Regular School No 1.0 PK 08 2016   pre_kindergarten                                                   7                                             7
326125 WI Trempealeau   school 5500420 154 Public school Arcadia 550042003040 190 Arcadia Elementary   Regular School No Elementary PK 04 2017   pre_kindergarten                                                   7                                             7
2318614 WI Trempealeau   school 5500420 154 Public school Arcadia 550042003040 190 Arcadia Elementary   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   4                                             4
2333408 WI Trempealeau   school 5500420 154 Public school Arcadia 550042003040 190 Arcadia Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten                                                   4                                             4
3074403 WI Trempealeau   school 5500420 154 Public school Arcadia 550042003040 190 Arcadia Elementary   Regular School No Elementary PK 04 2019   pre_kindergarten                                                   4                                             4
3089159 WI Trempealeau   school 5500420 154 Public school Arcadia 550042003040 190 Arcadia Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   9                                             9
112271 WI Lafayette   school 5500450 161 Public school Argyle 550045000069 20 Argyle Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   2                                             2
282245 WI Lafayette   school 5500450 161 Public school Argyle 550045000069 20 Argyle Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   3                                             3
326144 WI Lafayette   school 5500450 161 Public school Argyle 550045000069 20 Argyle Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
2333427 WI Lafayette   school 5500450 161 Public school Argyle 550045000069 20 Argyle Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
3074422 WI Lafayette   school 5500450 161 Public school Argyle 550045000069 20 Argyle Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                                                   1                                             1
3089178 WI Lafayette   school 5500450 161 Public school Argyle 550045000069 20 Argyle Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
112306 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Primary   Regular School No 1.0 PK 02 2015   pre_kindergarten                                                   26                                             26
282285 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Primary   Regular School No 1.0 PK 02 2016   pre_kindergarten                                                   27                                             27
282293 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   2                                             2
326184 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Primary   Regular School No Elementary PK 02 2017   pre_kindergarten                                                   1                                             1
2318664 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   13                                             13
2333459 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   2                                             2
3074465 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Primary   Regular School No Elementary PK 02 2019   pre_kindergarten                                                   6                                             6
3089220 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Primary   Regular School No Elementary PK 02 2018   pre_kindergarten                                                   14                                             14
112326 WI Brown   school 5500540 182 Public school Ashwaubenon 550054000294 55 Cormier School and Early Learning Center   Regular School No 1.0 PK KG 2015   pre_kindergarten                                                   4                                             4
282306 WI Brown   school 5500540 182 Public school Ashwaubenon 550054000294 55 Cormier School and Early Learning Center   Regular School No 1.0 PK KG 2016   pre_kindergarten                                                   10                                             10
326204 WI Brown   school 5500540 182 Public school Ashwaubenon 550054000294 55 Cormier School and Early Learning Center   Regular School No Elementary PK KG 2017   pre_kindergarten                                                   13                                             13
2318702 WI Brown   school 5500540 182 Public school Ashwaubenon 550054000294 55 Cormier School and Early Learning Center   Regular School No Elementary PK KG 2020   pre_kindergarten                                                   19                                             19
2333485 WI Brown   school 5500540 182 Public school Ashwaubenon 550054000294 55 Cormier School and Early Learning Center   Regular School No Elementary PK KG 2021   pre_kindergarten                                                   11                                             11
3074484 WI Brown   school 5500540 182 Public school Ashwaubenon 550054000294 55 Cormier School and Early Learning Center   Regular School No Elementary PK KG 2019   pre_kindergarten                                                   16                                             16
3089240 WI Brown   school 5500540 182 Public school Ashwaubenon 550054000294 55 Cormier School and Early Learning Center   Regular School No Elementary PK KG 2018   pre_kindergarten                                                   16                                             16
112352 WI Marathon   school 5500570 196 Public school Athens 550057000086 20 Athens Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   6                                             6
282332 WI Marathon   school 5500570 196 Public school Athens 550057000086 20 Athens Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   5                                             5
326230 WI Marathon   school 5500570 196 Public school Athens 550057000086 20 Athens Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   34                                             34
2318728 WI Marathon   school 5500570 196 Public school Athens 550057000086 20 Athens Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   16                                             16
2333511 WI Marathon   school 5500570 196 Public school Athens 550057000086 20 Athens Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   24                                             24
3074510 WI Marathon   school 5500570 196 Public school Athens 550057000086 20 Athens Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                                                   40                                             40
3089266 WI Marathon   school 5500570 196 Public school Athens 550057000086 20 Athens Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   26                                             26
2318746 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   3                                             3
2333529 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   4                                             4
3074528 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                                                   2                                             2
112388 WI Eau Claire   school 5500630 217 Public school Augusta 550063000092 20 Augusta Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   5                                             5
282368 WI Eau Claire   school 5500630 217 Public school Augusta 550063000092 20 Augusta Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   11                                             11
326270 WI Eau Claire   school 5500630 217 Public school Augusta 550063000092 20 Augusta Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   4                                             4
2318775 WI Eau Claire   school 5500630 217 Public school Augusta 550063000092 20 Augusta Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   3                                             3
2333557 WI Eau Claire   school 5500630 217 Public school Augusta 550063000092 20 Augusta Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   2                                             2
3074549 WI Eau Claire   school 5500630 217 Public school Augusta 550063000092 20 Augusta Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                                                   1                                             1
3089304 WI Eau Claire   school 5500630 217 Public school Augusta 550063000092 20 Augusta Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   7                                             7
112417 WI Saint Croix   school 5500720 231 Public school Baldwin-Woodville Area 550072000095 70 Greenfield Elementary   Regular School No 1.0 PK 04 2015   pre_kindergarten                                                   11                                             11
282397 WI Saint Croix   school 5500720 231 Public school Baldwin-Woodville Area 550072000095 70 Greenfield Elementary   Regular School No 1.0 PK 04 2016   pre_kindergarten                                                   9                                             9
326300 WI Saint Croix   school 5500720 231 Public school Baldwin-Woodville Area 550072000095 70 Greenfield Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   10                                             10
2318805 WI Saint Croix   school 5500720 231 Public school Baldwin-Woodville Area 550072000095 70 Greenfield Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   8                                             8
2333587 WI Saint Croix   school 5500720 231 Public school Baldwin-Woodville Area 550072000095 70 Greenfield Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   4                                             4
3074579 WI Saint Croix   school 5500720 231 Public school Baldwin-Woodville Area 550072000095 70 Greenfield Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                                                   10                                             10
3089334 WI Saint Croix   school 5500720 231 Public school Baldwin-Woodville Area 550072000095 70 Greenfield Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   9                                             9
112431 WI La Crosse   school 5500780 245 Public school Bangor 550078000100 20 Bangor Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   3                                             3
282411 WI La Crosse   school 5500780 245 Public school Bangor 550078000100 20 Bangor Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   2                                             2
2318819 WI La Crosse   school 5500780 245 Public school Bangor 550078000100 20 Bangor Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2333600 WI La Crosse   school 5500780 245 Public school Bangor 550078000100 20 Bangor Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
3089347 WI La Crosse   school 5500780 245 Public school Bangor 550078000100 20 Bangor Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   2                                             2
112447 WI Sauk   school 5500810 280 Public school Baraboo 550081000109 180 Al Behrman Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   1                                             1
112464 WI Sauk   school 5500810 280 Public school Baraboo 550081000104 60 East Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   6                                             6
112478 WI Sauk   school 5500810 280 Public school Baraboo 550081002587 120 West Elementary-Kindergarten Center   Regular School No 1.0 PK KG 2015   pre_kindergarten                                                   12                                             12
282427 WI Sauk   school 5500810 280 Public school Baraboo 550081000109 180 Al Behrman Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
282444 WI Sauk   school 5500810 280 Public school Baraboo 550081000104 60 East Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   8                                             8
282458 WI Sauk   school 5500810 280 Public school Baraboo 550081002587 120 West Elementary-Kindergarten Center   Regular School No 1.0 PK KG 2016   pre_kindergarten                                                   10                                             10
282466 WI Sauk   school 5500810 280 Public school Baraboo 550081000106 110 Willson Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
326344 WI Sauk   school 5500810 280 Public school Baraboo 550081000104 60 East Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   10                                             10
326358 WI Sauk   school 5500810 280 Public school Baraboo 550081002587 120 West Elementary-Kindergarten Center   Regular School No Elementary PK KG 2017   pre_kindergarten                                                   3                                             3
2318851 WI Sauk   school 5500810 280 Public school Baraboo 550081000104 60 East Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   6                                             6
2318865 WI Sauk   school 5500810 280 Public school Baraboo 550081002587 120 West Elementary-Kindergarten Center   Regular School No Elementary PK KG 2020   pre_kindergarten                                                   18                                             18
2333645 WI Sauk   school 5500810 280 Public school Baraboo 550081002587 120 West Elementary-Kindergarten Center   Regular School No Elementary PK KG 2021   pre_kindergarten                                                   6                                             6
3074623 WI Sauk   school 5500810 280 Public school Baraboo 550081000104 60 East Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                                                   6                                             6
3074637 WI Sauk   school 5500810 280 Public school Baraboo 550081002587 120 West Elementary-Kindergarten Center   Regular School No Elementary PK KG 2019   pre_kindergarten                                                   21                                             21
3089379 WI Sauk   school 5500810 280 Public school Baraboo 550081000104 60 East Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   8                                             8
3089393 WI Sauk   school 5500810 280 Public school Baraboo 550081002587 120 West Elementary-Kindergarten Center   Regular School No Elementary PK KG 2018   pre_kindergarten                                                   9                                             9
112494 WI Iowa   school 5500840 287 Public school Barneveld 550084000111 20 Barneveld Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   1                                             1
3074653 WI Iowa   school 5500840 287 Public school Barneveld 550084000111 20 Barneveld Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                                                   1                                             1
3089409 WI Iowa   school 5500840 287 Public school Barneveld 550084000111 20 Barneveld Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
112558 WI Barron   school 5500870 308 Public school Barron Area 550087000119 160 Woodland Elementary   Regular School No 1.0 PK 04 2015   pre_kindergarten                                                   6                                             6
282539 WI Barron   school 5500870 308 Public school Barron Area 550087000119 160 Woodland Elementary   Regular School No 1.0 PK 04 2016   pre_kindergarten                                                   8                                             8