enrollments
Data source: Big Local News · About: Big Local
4,704 rows where grade = "grade_7" and state = "WI" sorted by total descending
This data as json, CSV (advanced)
Link | 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
116090 | 116090 | WI | Outagamie | school | 5506600 | 2583 | Public school | Hortonville Area | 550660002408 | 30 | Hortonville Middle | Regular School | No | 2.0 | 05 | 08 | 2015 | grade_7 | 99 | 99 | ||||||||||||||||||||||||||||||||||||||||||||||||||
123716 | 123716 | WI | Saint Croix | school | 5514010 | 5432 | Public school | Somerset | 551401001108 | 60 | Somerset Middle | Regular School | No | 2.0 | 05 | 08 | 2015 | grade_7 | 99 | 99 | ||||||||||||||||||||||||||||||||||||||||||||||||||
284943 | 284943 | WI | Milwaukee | school | 5504800 | 1890 | Public school | Fox Point J2 | 550480000517 | 20 | Bayside Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 99 | 99 | ||||||||||||||||||||||||||||||||||||||||||||||||||
287509 | 287509 | WI | Outagamie | school | 5508160 | 3129 | Public school | Little Chute Area | 550816000902 | 60 | Little Chute Middle | Regular School | No | 2.0 | 07 | 08 | 2016 | grade_7 | 99 | 99 | ||||||||||||||||||||||||||||||||||||||||||||||||||
289331 | 289331 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002979 | 880 | HAPA-Hmong Amer Peace Academy K3-12 | charter | Regular School | Yes | 4.0 | PK | 12 | 2016 | grade_7 | 99 | 99 | |||||||||||||||||||||||||||||||||||||||||||||||||
289828 | 289828 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001221 | 52 | Morse Marshall | Regular School | No | 4.0 | 06 | 12 | 2016 | grade_7 | 99 | 99 | ||||||||||||||||||||||||||||||||||||||||||||||||||
296307 | 296307 | WI | Brown | school | 5517190 | 6734 | Public school | Wrightstown Community | 551719000280 | 30 | Wrightstown Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 99 | 99 | ||||||||||||||||||||||||||||||||||||||||||||||||||
327601 | 327601 | WI | Columbia | school | 5502820 | 1183 | Public school | Columbus | 550282000319 | 20 | Columbus Middle | Regular School | No | Elementary | 04 | 08 | 2017 | grade_7 | 99 | 99 | ||||||||||||||||||||||||||||||||||||||||||||||||||
331381 | 331381 | WI | Outagamie | school | 5508160 | 3129 | Public school | Little Chute Area | 550816000902 | 60 | Little Chute Middle | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 99 | 99 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2334115 | 2334115 | WI | Chippewa | school | 5501350 | 497 | Public school | Bloomer | 550135000185 | 60 | Bloomer Middle | Regular School | No | Middle | 05 | 08 | 2021 | grade_7 | 99 | 99 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2335953 | 2335953 | WI | Rock | school | 5504440 | 1694 | Public school | Evansville Community | 550444000479 | 60 | J C McKenna Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 99 | 99 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3075235 | 3075235 | WI | Kenosha | school | 5501710 | 665 | Public school | Bristol #1 | 550171000209 | 20 | Bristol Elementary | Regular School | No | Elementary | PK | 08 | 2019 | grade_7 | 99 | 99 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3102331 | 3102331 | WI | Waushara | school | 5515960 | 6237 | Public school | Wautoma Area | 551596002071 | 30 | Parkside School | Regular School | No | Middle | 04 | 08 | 2018 | grade_7 | 99 | 99 | ||||||||||||||||||||||||||||||||||||||||||||||||||
119628 | 119628 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001209 | 256 | Longfellow Elementary | Regular School | No | 1.0 | PK | 08 | 2015 | grade_7 | 98 | 98 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2333886 | 2333886 | WI | Rock | school | 5501050 | 413 | Public school | Beloit | 550105000140 | 80 | Cunningham Intermediate | Regular School | No | Middle | 04 | 08 | 2021 | grade_7 | 98 | 98 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2346079 | 2346079 | WI | Racine | school | 5515180 | 5859 | Public school | Union Grove J1 | 551518001964 | 20 | Union Grove Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 98 | 98 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2347380 | 2347380 | WI | Marquette | school | 5516440 | 6335 | Public school | Westfield | 551644002535 | 200 | Westfield Area Middle | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 98 | 98 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3086698 | 3086698 | WI | Lincoln | school | 5514940 | 5754 | Public school | Tomahawk | 551494001948 | 220 | Tomahawk Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 98 | 98 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3100853 | 3100853 | WI | Chippewa | school | 5514430 | 5593 | Public school | Stanley-Boyd Area | 551443001866 | 100 | Stanley-Boyd Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 98 | 98 | ||||||||||||||||||||||||||||||||||||||||||||||||||
115881 | 115881 | WI | Waukesha | school | 5506140 | 2460 | Public school | Hartland-Lakeside J3 | 550614001282 | 100 | North Shore Middle | Regular School | No | 2.0 | 06 | 08 | 2015 | grade_7 | 97 | 97 | ||||||||||||||||||||||||||||||||||||||||||||||||||
282530 | 282530 | WI | Barron | school | 5500870 | 308 | Public school | Barron Area | 550087000118 | 140 | Riverview Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 97 | 97 | ||||||||||||||||||||||||||||||||||||||||||||||||||
294564 | 294564 | WI | Racine | school | 5515180 | 5859 | Public school | Union Grove J1 | 551518001964 | 20 | Union Grove Elementary | Regular School | No | 1.0 | PK | 08 | 2016 | grade_7 | 97 | 97 | ||||||||||||||||||||||||||||||||||||||||||||||||||
336858 | 336858 | WI | Sauk | school | 5514250 | 5523 | Public school | River Valley | 551425001856 | 100 | River Valley Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 97 | 97 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2323637 | 2323637 | WI | La Crosse | school | 5507530 | 2849 | Public school | La Crosse | 550753000863 | 180 | Lincoln Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 97 | 97 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2340220 | 2340220 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960003123 | 215 | Andrew S Douglas Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 97 | 97 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3087359 | 3087359 | WI | Waukesha | school | 5515780 | 6174 | Public school | Waukesha | 551578002023 | 400 | Waukesha STEM Academy | charter | Regular School | Yes | Elementary | PK | 08 | 2019 | grade_7 | 97 | 97 | |||||||||||||||||||||||||||||||||||||||||||||||||
112549 | 112549 | WI | Barron | school | 5500870 | 308 | Public school | Barron Area | 550087000118 | 140 | Riverview Middle | Regular School | No | 2.0 | 05 | 08 | 2015 | grade_7 | 96 | 96 | ||||||||||||||||||||||||||||||||||||||||||||||||||
124176 | 124176 | WI | Door | school | 5514610 | 5642 | Public school | Sturgeon Bay | 551461002322 | 80 | Walker Middle | Regular School | No | 2.0 | 06 | 08 | 2015 | grade_7 | 96 | 96 | ||||||||||||||||||||||||||||||||||||||||||||||||||
287049 | 287049 | WI | Manitowoc | school | 5507440 | 2828 | Public school | Kiel Area | 550744000845 | 60 | Kiel Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 96 | 96 | ||||||||||||||||||||||||||||||||||||||||||||||||||
291646 | 291646 | WI | Winnebago | school | 5511190 | 4179 | Public school | Oshkosh Area | 551119001497 | 320 | Tipler Middle | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 96 | 96 | ||||||||||||||||||||||||||||||||||||||||||||||||||
292797 | 292797 | WI | Richland | school | 5512960 | 4851 | Public school | Richland | 551296001708 | 280 | Richland Middle | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 96 | 96 | ||||||||||||||||||||||||||||||||||||||||||||||||||
333468 | 333468 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001209 | 256 | Longfellow Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 96 | 96 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2319685 | 2319685 | WI | Barron | school | 5502130 | 903 | Public school | Cameron | 550213002286 | 200 | Cameron Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 96 | 96 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3075484 | 3075484 | WI | Fond du Lac | school | 5502160 | 910 | Public school | Campbellsport | 550216002484 | 300 | Campbellsport Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 96 | 96 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3103326 | 3103326 | WI | Brown | school | 5517190 | 6734 | Public school | Wrightstown Community | 551719000280 | 30 | Wrightstown Middle | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 96 | 96 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2329607 | 2329607 | WI | Polk | school | 5513230 | 5019 | Public school | Saint Croix Falls | 551323002314 | 70 | Saint Croix Falls Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 95 | 95 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2333849 | 2333849 | WI | Rock | school | 5501050 | 413 | Public school | Beloit | 550105000137 | 20 | Aldrich Intermediate | Regular School | No | Middle | 04 | 08 | 2021 | grade_7 | 95 | 95 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2335482 | 2335482 | WI | Walworth | school | 5504020 | 1540 | Public school | East Troy Community | 550402000411 | 60 | East Troy Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 95 | 95 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2343640 | 2343640 | WI | Pierce | school | 5512240 | 4578 | Public school | Prescott | 551224001593 | 80 | Prescott Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 95 | 95 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3079722 | 3079722 | WI | Outagamie | school | 5508160 | 3129 | Public school | Little Chute Area | 550816000902 | 60 | Little Chute Middle | Regular School | No | Middle | 07 | 08 | 2019 | grade_7 | 95 | 95 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3088624 | 3088624 | WI | Brown | school | 5517190 | 6734 | Public school | Wrightstown Community | 551719000280 | 30 | Wrightstown Middle | Regular School | No | Middle | 05 | 08 | 2019 | grade_7 | 95 | 95 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3095603 | 3095603 | WI | Waukesha | school | 5509360 | 3528 | Public school | Merton Community | 550936002269 | 20 | Merton Intermediate | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 95 | 95 | ||||||||||||||||||||||||||||||||||||||||||||||||||
113300 | 113300 | WI | Fond du Lac | school | 5502160 | 910 | Public school | Campbellsport | 550216002484 | 300 | Campbellsport Middle | Regular School | No | 2.0 | 06 | 08 | 2015 | grade_7 | 94 | 94 | ||||||||||||||||||||||||||||||||||||||||||||||||||
117196 | 117196 | WI | La Crosse | school | 5507530 | 2849 | Public school | La Crosse | 550753000863 | 180 | Lincoln Middle | Regular School | No | 2.0 | 06 | 08 | 2015 | grade_7 | 94 | 94 | ||||||||||||||||||||||||||||||||||||||||||||||||||
123168 | 123168 | WI | Polk | school | 5513230 | 5019 | Public school | Saint Croix Falls | 551323002314 | 70 | Saint Croix Falls Middle | Regular School | No | 2.0 | 05 | 08 | 2015 | grade_7 | 94 | 94 | ||||||||||||||||||||||||||||||||||||||||||||||||||
295324 | 295324 | WI | Waushara | school | 5515960 | 6237 | Public school | Wautoma Area | 551596002071 | 30 | Parkside School | Regular School | No | 2.0 | 04 | 08 | 2016 | grade_7 | 94 | 94 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326428 | 326428 | WI | Barron | school | 5500870 | 308 | Public school | Barron Area | 550087000118 | 140 | Riverview Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 94 | 94 | ||||||||||||||||||||||||||||||||||||||||||||||||||
328825 | 328825 | WI | Milwaukee | school | 5504800 | 1890 | Public school | Fox Point J2 | 550480000517 | 20 | Bayside Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 94 | 94 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2323501 | 2323501 | WI | Manitowoc | school | 5507440 | 2828 | Public school | Kiel Area | 550744000845 | 60 | Kiel Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 94 | 94 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2330169 | 2330169 | WI | Saint Croix | school | 5514010 | 5432 | Public school | Somerset | 551401001108 | 60 | Somerset Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 94 | 94 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2340376 | 2340376 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002980 | 444 | Carmen Middle/High School of Science and Technology Northwest Campus | charter | Regular School | Yes | High | 06 | 12 | 2021 | grade_7 | 94 | 94 | |||||||||||||||||||||||||||||||||||||||||||||||||
2345915 | 2345915 | WI | Lincoln | school | 5514940 | 5754 | Public school | Tomahawk | 551494001948 | 220 | Tomahawk Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 94 | 94 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3086084 | 3086084 | WI | Washburn | school | 5514220 | 5474 | Public school | Spooner Area | 551422001849 | 100 | Spooner Middle | Regular School | No | Middle | 05 | 08 | 2019 | grade_7 | 94 | 94 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3090234 | 3090234 | WI | Fond du Lac | school | 5502160 | 910 | Public school | Campbellsport | 550216002484 | 300 | Campbellsport Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 94 | 94 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3094987 | 3094987 | WI | Douglas | school | 5508640 | 3297 | Public school | Maple | 550864000988 | 170 | Northwestern Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 94 | 94 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3096549 | 3096549 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001209 | 256 | Longfellow Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 94 | 94 | ||||||||||||||||||||||||||||||||||||||||||||||||||
115074 | 115074 | WI | Trempealeau | school | 5504960 | 2009 | Public school | Galesville-Ettrick-Trempealeau | 550496000537 | 50 | Galesville-Ettrick-Trempealeau Middle | Regular School | No | 2.0 | 06 | 08 | 2015 | grade_7 | 93 | 93 | ||||||||||||||||||||||||||||||||||||||||||||||||||
327384 | 327384 | WI | Calumet | school | 5502520 | 1085 | Public school | Chilton | 550252002430 | 30 | Chilton Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 93 | 93 | ||||||||||||||||||||||||||||||||||||||||||||||||||
334911 | 334911 | WI | Fond du Lac | school | 5510740 | 3983 | Public school | North Fond du Lac | 551074001396 | 20 | Bessie Allen Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 93 | 93 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2330370 | 2330370 | WI | Washburn | school | 5514220 | 5474 | Public school | Spooner Area | 551422001849 | 100 | Spooner Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 93 | 93 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331019 | 2331019 | WI | Portage | school | 5500330 | 126 | Public school | Tomorrow River | 550033000034 | 80 | Amherst Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 93 | 93 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2339640 | 2339640 | WI | Juneau | school | 5508850 | 3360 | Public school | Mauston | 550885001026 | 20 | Olson Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 93 | 93 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3075690 | 3075690 | WI | Calumet | school | 5502520 | 1085 | Public school | Chilton | 550252002430 | 30 | Chilton Middle | Regular School | No | Middle | 05 | 08 | 2019 | grade_7 | 93 | 93 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3085330 | 3085330 | WI | Polk | school | 5513230 | 5019 | Public school | Saint Croix Falls | 551323002314 | 70 | Saint Croix Falls Middle | Regular School | No | Middle | 05 | 08 | 2019 | grade_7 | 93 | 93 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3089458 | 3089458 | WI | Barron | school | 5500870 | 308 | Public school | Barron Area | 550087000118 | 140 | Riverview Middle | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 93 | 93 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3095215 | 3095215 | WI | Dodge | school | 5508880 | 3367 | Public school | Mayville | 550888001029 | 60 | Mayville Middle | Regular School | No | Middle | 03 | 08 | 2018 | grade_7 | 93 | 93 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3096184 | 3096184 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001169 | 185 | Gaenslen Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 93 | 93 | ||||||||||||||||||||||||||||||||||||||||||||||||||
285884 | 285884 | WI | Waukesha | school | 5506140 | 2460 | Public school | Hartland-Lakeside J3 | 550614001282 | 100 | North Shore Middle | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 92 | 92 | ||||||||||||||||||||||||||||||||||||||||||||||||||
288047 | 288047 | WI | Douglas | school | 5508640 | 3297 | Public school | Maple | 550864000988 | 170 | Northwestern Middle | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 92 | 92 | ||||||||||||||||||||||||||||||||||||||||||||||||||
289598 | 289598 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001209 | 256 | Longfellow Elementary | Regular School | No | 1.0 | PK | 08 | 2016 | grade_7 | 92 | 92 | ||||||||||||||||||||||||||||||||||||||||||||||||||
293861 | 293861 | WI | Washburn | school | 5514220 | 5474 | Public school | Spooner Area | 551422001849 | 100 | Spooner Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 92 | 92 | ||||||||||||||||||||||||||||||||||||||||||||||||||
331913 | 331913 | WI | Douglas | school | 5508640 | 3297 | Public school | Maple | 550864000988 | 170 | Northwestern Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 92 | 92 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2318927 | 2318927 | WI | Barron | school | 5500870 | 308 | Public school | Barron Area | 550087000118 | 140 | Riverview Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 92 | 92 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2320031 | 2320031 | WI | Waupaca | school | 5502670 | 1141 | Public school | Clintonville | 550267000301 | 20 | Clintonville Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 92 | 92 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2327355 | 2327355 | WI | Green | school | 5510500 | 3934 | Public school | New Glarus | 551050002929 | 250 | New Glarus Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 92 | 92 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332913 | 2332913 | WI | Brown | school | 5517190 | 6734 | Public school | Wrightstown Community | 551719000280 | 30 | Wrightstown Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 92 | 92 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2340981 | 2340981 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001209 | 256 | Longfellow Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 92 | 92 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3075798 | 3075798 | WI | Rock | school | 5502640 | 1134 | Public school | Clinton Community | 550264000297 | 80 | Clinton Middle | Regular School | No | Middle | 05 | 08 | 2019 | grade_7 | 92 | 92 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3077275 | 3077275 | WI | Trempealeau | school | 5504960 | 2009 | Public school | Galesville-Ettrick-Trempealeau | 550496000537 | 50 | Galesville-Ettrick-Trempealeau Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 92 | 92 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3085088 | 3085088 | WI | Fond du Lac | school | 5513020 | 4872 | Public school | Ripon Area | 551302001719 | 140 | Ripon Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 92 | 92 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3089885 | 3089885 | WI | Chippewa | school | 5501350 | 497 | Public school | Bloomer | 550135000185 | 60 | Bloomer Middle | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 92 | 92 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3098808 | 3098808 | WI | Marinette | school | 5511610 | 4305 | Public school | Peshtigo | 551161003026 | 200 | Peshtigo Middle | Regular School | No | Middle | 07 | 08 | 2018 | grade_7 | 92 | 92 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3099914 | 3099914 | WI | Sauk | school | 5514250 | 5523 | Public school | River Valley | 551425001856 | 100 | River Valley Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 92 | 92 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3102781 | 3102781 | WI | Vernon | school | 5516410 | 6321 | Public school | Westby Area | 551641001207 | 160 | Westby Middle | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 92 | 92 | ||||||||||||||||||||||||||||||||||||||||||||||||||
113499 | 113499 | WI | Calumet | school | 5502520 | 1085 | Public school | Chilton | 550252002430 | 30 | Chilton Middle | Regular School | No | 2.0 | 05 | 08 | 2015 | grade_7 | 91 | 91 | ||||||||||||||||||||||||||||||||||||||||||||||||||
121204 | 121204 | WI | Vilas | school | 5503860 | 1526 | Public school | Northland Pines | 550386000407 | 95 | Northland Pines Middle | Regular School | No | 2.0 | 06 | 08 | 2015 | grade_7 | 91 | 91 | ||||||||||||||||||||||||||||||||||||||||||||||||||
284165 | 284165 | WI | Iowa | school | 5503690 | 1428 | Public school | Dodgeville | 550369000391 | 50 | Dodgeville Middle | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 91 | 91 | ||||||||||||||||||||||||||||||||||||||||||||||||||
292123 | 292123 | WI | Columbia | school | 5512120 | 4536 | Public school | Poynette | 551212001581 | 100 | Poynette Middle | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 91 | 91 | ||||||||||||||||||||||||||||||||||||||||||||||||||
335813 | 335813 | WI | Grant | school | 5511850 | 4389 | Public school | Platteville | 551185001554 | 80 | Platteville Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 91 | 91 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2320138 | 2320138 | WI | Columbia | school | 5502820 | 1183 | Public school | Columbus | 550282000319 | 20 | Columbus Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 91 | 91 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2328663 | 2328663 | WI | Crawford | school | 5512150 | 4543 | Public school | Prairie du Chien Area | 551215002844 | 300 | Bluff View Junior High | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 91 | 91 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2329369 | 2329369 | WI | Fond du Lac | school | 5513020 | 4872 | Public school | Ripon Area | 551302001719 | 140 | Ripon Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 91 | 91 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331001 | 2331001 | WI | Lincoln | school | 5514940 | 5754 | Public school | Tomahawk | 551494001948 | 220 | Tomahawk Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 91 | 91 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2335743 | 2335743 | WI | Dunn | school | 5504230 | 1645 | Public school | Elk Mound Area | 550423000452 | 20 | Elk Mound Middle | Regular School | No | Middle | 05 | 08 | 2021 | grade_7 | 91 | 91 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3102053 | 3102053 | WI | Waukesha | school | 5515780 | 6174 | Public school | Waukesha | 551578002023 | 400 | Waukesha STEM Academy | charter | Regular School | Yes | Elementary | PK | 08 | 2018 | grade_7 | 91 | 91 | |||||||||||||||||||||||||||||||||||||||||||||||||
282176 | 282176 | WI | Outagamie | school | 5500390 | 147 | Public school | Appleton Area | 550039000063 | 360 | Roosevelt Middle | Regular School | No | 2.0 | 07 | 08 | 2016 | grade_7 | 90 | 90 | ||||||||||||||||||||||||||||||||||||||||||||||||||
291048 | 291048 | WI | Fond du Lac | school | 5510740 | 3983 | Public school | North Fond du Lac | 551074001396 | 20 | Bessie Allen Middle | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 90 | 90 | ||||||||||||||||||||||||||||||||||||||||||||||||||
293151 | 293151 | WI | Kenosha | school | 5513350 | 5068 | Public school | Salem | 551335001753 | 20 | Salem Elementary | Regular School | No | 1.0 | PK | 08 | 2016 | grade_7 | 90 | 90 | ||||||||||||||||||||||||||||||||||||||||||||||||||
338016 | 338016 | WI | Door | school | 5514610 | 5642 | Public school | Sturgeon Bay | 551461002322 | 80 | Walker Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 90 | 90 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2319331 | 2319331 | WI | Chippewa | school | 5501350 | 497 | Public school | Bloomer | 550135000185 | 60 | Bloomer Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 90 | 90 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "enrollments" ( [state] TEXT, [county] TEXT, [county_state_id] INTEGER, [admin_level] TEXT, [district_nces_id] INTEGER, [district_state_id] TEXT, [district_state_type] TEXT, [district] TEXT, [school_nces_id] INTEGER, [school_state_id] INTEGER, [school] TEXT, [school_state_type] TEXT, [ccd_school_type] TEXT, [ccd_charter_school] TEXT, [ccd_school_lvl] TEXT, [ccd_school_low_grade] TEXT, [ccd_school_high_grade] TEXT, [year] INTEGER, [term] TEXT, [grade] TEXT, [white] TEXT, [black] TEXT, [hispanic] TEXT, [native_american] TEXT, [native_american_alaskan_native] TEXT, [asian] TEXT, [native_hawaiian] TEXT, [asian_pacific_islander] TEXT, [native_hawaiian_pacific_islander] TEXT, [pacific_islander] TEXT, [multiracial] TEXT, [unknown_race] TEXT, [male] TEXT, [female] TEXT, [non_binary] TEXT, [unknown_gender] TEXT, [ell] TEXT, [ell_percent] TEXT, [homeless] TEXT, [homeless_percent] TEXT, [low_income] TEXT, [free_and_reduced] TEXT, [free_and_reduced_percent] TEXT, [disability] TEXT, [section_504] TEXT, [total] TEXT , [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER); CREATE INDEX [idx_enrollments_state_grade] ON [enrollments] ([state], [grade]); CREATE INDEX [idx_enrollments_grade] ON [enrollments] ([grade]); CREATE INDEX [idx_enrollments_year] ON [enrollments] ([year]); CREATE INDEX [idx_enrollments_state_year] ON [enrollments] ([state], [year]); CREATE INDEX [idx_enrollments_school_nces_id] ON [enrollments] ([school_nces_id]); CREATE INDEX [idx_enrollments_district_nces_id] ON [enrollments] ([district_nces_id]);