enrollments
Data source: Big Local News · About: Big Local
680 rows where grade = "grade_7", state = "WI" and year = 2020 sorted by school_state_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2326078 | 2326078 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002302 | 6 | Lincoln Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 216 | 216 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2321662 | 2321662 | WI | Milwaukee | school | 5505460 | 2184 | Public school | Glendale-River Hills | 550546000575 | 10 | Glen Hills Middle | Regular School | No | Middle | 04 | 08 | 2020 | grade_7 | 85 | 85 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2327091 | 2327091 | WI | Waukesha | school | 5510170 | 3857 | Public school | Muskego-Norway | 551017001330 | 10 | Muskego Lakes Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 173 | 173 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2328390 | 2328390 | WI | Vilas | school | 5511710 | 4330 | Public school | Phelps | 551171001539 | 10 | Phelps Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 5 | 5 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2330428 | 2330428 | WI | Portage | school | 5514490 | 5607 | Public school | Stevens Point Area Public | 551449001868 | 10 | Benjamin Franklin Junior High | Regular School | No | Middle | 07 | 09 | 2020 | grade_7 | 267 | 267 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331395 | 2331395 | WI | Racine | school | 5515660 | 6113 | Public school | Waterford Graded J1 | 551566001989 | 10 | Fox River Middle | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 164 | 164 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332243 | 2332243 | WI | Washington | school | 5516290 | 6307 | Public school | West Bend | 551629002125 | 10 | Badger Middle | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 475 | 475 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2319312 | 2319312 | WI | Trempealeau | school | 5500016 | 485 | Public school | Blair-Taylor | 550001602378 | 11 | Blair-Taylor Middle/High | Regular School | No | High | 07 | 12 | 2020 | grade_7 | 55 | 55 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2318217 | 2318217 | WI | Buffalo | school | 5500180 | 84 | Public school | Alma | 550018000017 | 20 | Alma Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 19 | 19 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2318854 | 2318854 | WI | Sauk | school | 5500810 | 280 | Public school | Baraboo | 550081000102 | 20 | Jack Young Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 217 | 217 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2318970 | 2318970 | WI | Dodge | school | 5500960 | 336 | Public school | Beaver Dam Unified | 550096000122 | 20 | Beaver Dam Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 266 | 266 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2319075 | 2319075 | WI | Rock | school | 5501050 | 413 | Public school | Beloit | 550105000137 | 20 | Aldrich Intermediate | Regular School | No | Middle | 04 | 08 | 2020 | grade_7 | 89 | 89 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2319420 | 2319420 | WI | Kenosha | school | 5501650 | 657 | Public school | Brighton #1 | 550165000205 | 20 | Brighton Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 27 | 27 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2319449 | 2319449 | WI | Kenosha | school | 5501710 | 665 | Public school | Bristol #1 | 550171000209 | 20 | Bristol Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 83 | 83 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2320619 | 2320619 | WI | Racine | school | 5503750 | 1449 | Public school | Dover #1 | 550375000394 | 20 | Kansasville Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 9 | 9 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2320923 | 2320923 | WI | Dunn | school | 5504230 | 1645 | Public school | Elk Mound Area | 550423000452 | 20 | Elk Mound Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 76 | 76 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2320940 | 2320940 | WI | Sheboygan | school | 5504260 | 1631 | Public school | Elkhart Lake-Glenbeulah | 550426000455 | 20 | Elkhart Lake Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 29 | 29 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2321021 | 2321021 | WI | Pierce | school | 5504320 | 1659 | Public school | Ellsworth Community | 550432000463 | 20 | Ellsworth Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 150 | 150 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2321108 | 2321108 | WI | Washington | school | 5504410 | 1687 | Public school | Erin | 550441000476 | 20 | Erin Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 47 | 47 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2321341 | 2321341 | WI | Walworth | school | 5504720 | 1870 | Public school | Fontana J8 | 550472000508 | 20 | Fontana Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 25 | 25 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2321390 | 2321390 | WI | Milwaukee | school | 5504800 | 1890 | Public school | Fox Point J2 | 550480000517 | 20 | Bayside Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 89 | 89 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2321531 | 2321531 | WI | Walworth | school | 5505100 | 2044 | Public school | Geneva J4 | 550510000546 | 20 | Woods Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 16 | 16 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2321783 | 2321783 | WI | Brown | school | 5505820 | 2289 | Public school | Green Bay Area Public | 550582000610 | 20 | Aldo Leopold Community School K-8 | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 66 | 66 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2322264 | 2322264 | WI | Washington | school | 5506090 | 2443 | Public school | Hartford J1 | 550609000674 | 20 | Central Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 181 | 181 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2322732 | 2322732 | WI | Iowa | school | 5506870 | 2646 | Public school | Iowa-Grant | 550687000744 | 20 | Iowa-Grant Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 62 | 62 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2322991 | 2322991 | WI | Green | school | 5507230 | 2737 | Public school | Juda | 550723000784 | 20 | Juda Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 25 | 25 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2323485 | 2323485 | WI | Vernon | school | 5512540 | 5960 | Public school | Kickapoo Area | 551254001658 | 20 | Kickapoo High | Regular School | No | High | 06 | 12 | 2020 | grade_7 | 46 | 46 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2323745 | 2323745 | WI | Vilas | school | 5504620 | 1848 | Public school | Lac du Flambeau #1 | 550462000488 | 20 | Lac du Flambeau Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 50 | 50 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2323835 | 2323835 | WI | Chippewa | school | 5507680 | 2891 | Public school | Lake Holcombe | 550768000885 | 20 | Holcombe Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 23 | 23 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2323907 | 2323907 | WI | Forest | school | 5507830 | 2940 | Public school | Laona | 550783000893 | 20 | Laona High | Regular School | No | High | 07 | 12 | 2020 | grade_7 | 15 | 15 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2323945 | 2323945 | WI | Walworth | school | 5508040 | 3087 | Public school | Linn J4 | 550804000898 | 20 | Traver Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 9 | 9 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2323957 | 2323957 | WI | Walworth | school | 5508070 | 3094 | Public school | Linn J6 | 550807000899 | 20 | Reek Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 11 | 11 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2324753 | 2324753 | WI | Juneau | school | 5508850 | 3360 | Public school | Mauston | 550885001026 | 20 | Olson Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 104 | 104 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2324935 | 2324935 | WI | Winnebago | school | 5509030 | 3430 | Public school | Menasha Joint | 550903001053 | 20 | Maplewood Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 263 | 263 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2325161 | 2325161 | WI | Waukesha | school | 5509360 | 3528 | Public school | Merton Community | 550936002269 | 20 | Merton Intermediate | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 111 | 111 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2326769 | 2326769 | WI | Oneida | school | 5509690 | 3640 | Public school | Minocqua J1 | 550969001278 | 20 | Minocqua Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 66 | 66 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2327231 | 2327231 | WI | Wood | school | 5510380 | 3906 | Public school | Nekoosa | 551038001358 | 20 | Alexander Middle | Regular School | No | Middle | 04 | 08 | 2020 | grade_7 | 71 | 71 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2327513 | 2327513 | WI | Racine | school | 5512510 | 4690 | Public school | North Cape | 551251001657 | 20 | North Cape Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 13 | 13 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2327537 | 2327537 | WI | Fond du Lac | school | 5510740 | 3983 | Public school | North Fond du Lac | 551074001396 | 20 | Bessie Allen Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 111 | 111 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2327570 | 2327570 | WI | Waukesha | school | 5509300 | 3514 | Public school | North Lake | 550930002268 | 20 | North Lake Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 29 | 29 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2327704 | 2327704 | WI | Monroe | school | 5510770 | 3990 | Public school | Norwalk-Ontario-Wilton | 551077001402 | 20 | Brookwood High | Regular School | No | High | 07 | 12 | 2020 | grade_7 | 41 | 41 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2327724 | 2327724 | WI | Racine | school | 5510800 | 4011 | Public school | Norway J7 | 551080001405 | 20 | Drought Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 8 | 8 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2328279 | 2328279 | WI | Kenosha | school | 5511400 | 4235 | Public school | Paris J1 | 551140001520 | 20 | Paris Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 32 | 32 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2328434 | 2328434 | WI | Wood | school | 5511790 | 4368 | Public school | Pittsville | 551179001546 | 20 | Pittsville Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 46 | 46 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2329049 | 2329049 | WI | Kenosha | school | 5512390 | 4627 | Public school | Randall J1 | 551239001649 | 20 | Randall Consolidated School | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 71 | 71 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2329061 | 2329061 | WI | Dodge | school | 5512420 | 4634 | Public school | Randolph | 551242001650 | 20 | Randolph Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 49 | 49 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2329087 | 2329087 | WI | Sheboygan | school | 5512450 | 4641 | Public school | Random Lake | 551245002421 | 20 | Random Lake Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 57 | 57 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2329096 | 2329096 | WI | Racine | school | 5512480 | 4686 | Public school | Raymond #14 | 551248001656 | 20 | Raymond Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 43 | 43 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2329302 | 2329302 | WI | Waukesha | school | 5508130 | 3122 | Public school | Richmond | 550813002262 | 20 | Richmond Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 50 | 50 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2329613 | 2329613 | WI | Milwaukee | school | 5513260 | 5026 | Public school | Saint Francis | 551326001747 | 20 | Deer Creek Intermediate | Regular School | No | Middle | 04 | 08 | 2020 | grade_7 | 70 | 70 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2329634 | 2329634 | WI | Kenosha | school | 5513350 | 5068 | Public school | Salem | 551335001753 | 20 | Salem Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 101 | 101 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2329740 | 2329740 | WI | Outagamie | school | 5513530 | 5138 | Public school | Seymour Community | 551353001769 | 20 | Black Creek Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 49 | 49 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2329769 | 2329769 | WI | Walworth | school | 5513560 | 5258 | Public school | Sharon J11 | 551356001774 | 20 | Sharon Community | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 32 | 32 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2330002 | 2330002 | WI | Outagamie | school | 5513770 | 5348 | Public school | Shiocton | 551377001807 | 20 | Shiocton Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 49 | 49 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2330067 | 2330067 | WI | Kenosha | school | 5513860 | 5369 | Public school | Silver Lake J1 | 551386001815 | 20 | Riverview Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 34 | 34 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2330547 | 2330547 | WI | Waukesha | school | 5509390 | 3542 | Public school | Stone Bank | 550939002270 | 20 | Stone Bank Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 40 | 40 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2330828 | 2330828 | WI | Waukesha | school | 5509240 | 3510 | Public school | Swallow | 550924002267 | 20 | Swallow Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 65 | 65 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2330847 | 2330847 | WI | Clark | school | 5514820 | 5726 | Public school | Thorp | 551482001925 | 20 | Thorp Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 42 | 42 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331047 | 2331047 | WI | Kenosha | school | 5500052 | 5780 | Public school | Trevor-Wilmot Consolidated | 550005202644 | 20 | Trevor-Wilmot Grade | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 67 | 67 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331100 | 2331100 | WI | Kenosha | school | 5515090 | 5817 | Public school | Twin Lakes #4 | 551509001957 | 20 | Lakewood Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 26 | 26 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331152 | 2331152 | WI | Racine | school | 5515180 | 5859 | Public school | Union Grove J1 | 551518001964 | 20 | Union Grove Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 88 | 88 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331336 | 2331336 | WI | Walworth | school | 5515450 | 6022 | Public school | Walworth J1 | 551545001981 | 20 | Walworth Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 56 | 56 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331356 | 2331356 | WI | Bayfield | school | 5515540 | 6027 | Public school | Washburn | 551554001984 | 20 | Washburn Middle | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 42 | 42 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331365 | 2331365 | WI | Door | school | 5515570 | 6069 | Public school | Washington | 551557001986 | 20 | Washington Island Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 7 | 7 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331380 | 2331380 | WI | Racine | school | 5515700 | 6104 | Public school | Washington-Caldwell | 551570001993 | 20 | Washington Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 10 | 10 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332461 | 2332461 | WI | Kenosha | school | 5516560 | 6412 | Public school | Wheatland J1 | 551656002163 | 20 | Wheatland Center Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 54 | 54 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332572 | 2332572 | WI | Walworth | school | 5516680 | 6461 | Public school | Whitewater Unified | 551668002178 | 20 | Whitewater Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 140 | 140 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332821 | 2332821 | WI | Shawano | school | 5517100 | 6692 | Public school | Wittenberg-Birnamwood | 551710002218 | 20 | Birnamwood Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 44 | 44 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332891 | 2332891 | WI | Vilas | school | 5517160 | 6720 | Public school | Woodruff J1 | 551716002227 | 20 | Arbor Vitae-Woodruff Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 55 | 55 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332922 | 2332922 | WI | Racine | school | 5517220 | 6748 | Public school | Yorkville J2 | 551722002230 | 20 | Yorkville Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 56 | 56 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2319349 | 2319349 | WI | Shawano | school | 5501470 | 602 | Public school | Bonduel | 550147002383 | 21 | Bonduel Middle | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 64 | 64 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2319440 | 2319440 | WI | Calumet | school | 5501680 | 658 | Public school | Brillion | 550168002384 | 21 | Brillion Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 67 | 67 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2320179 | 2320179 | WI | Forest | school | 5502910 | 1218 | Public school | Crandon | 550291002388 | 22 | Crandon Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 58 | 58 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2320224 | 2320224 | WI | Milwaukee | school | 5503060 | 1253 | Public school | Cudahy | 550306002389 | 22 | Cudahy Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 176 | 176 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2320852 | 2320852 | WI | Marathon | school | 5504080 | 1561 | Public school | Edgar | 550408002391 | 23 | Edgar Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 48 | 48 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2320584 | 2320584 | WI | Dodge | school | 5507260 | 2744 | Public school | Dodgeland | 550726002983 | 25 | Dodgeland Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 50 | 50 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2324622 | 2324622 | WI | Green Lake | school | 5508760 | 3325 | Public school | Markesan | 550876002414 | 25 | Markesan Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 49 | 49 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2328203 | 2328203 | WI | Trempealeau | school | 5511220 | 4186 | Public school | Osseo-Fairchild | 551122002398 | 26 | Osseo-Fairchild Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 59 | 59 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2329712 | 2329712 | WI | Crawford | school | 5513470 | 5124 | Public school | Seneca Area | 551347002399 | 28 | Seneca Junior High | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 32 | 32 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2330058 | 2330058 | WI | Lafayette | school | 5513830 | 5362 | Public school | Shullsburg | 551383002400 | 28 | Shullsburg Junior High | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 30 | 30 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332512 | 2332512 | WI | Milwaukee | school | 5516620 | 6419 | Public school | Whitefish Bay | 551662002402 | 29 | Whitefish Bay Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 202 | 202 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2318654 | 2318654 | WI | Ashland | school | 5500510 | 170 | Public school | Ashland | 550051000074 | 30 | Ashland Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 154 | 154 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2318952 | 2318952 | WI | Bayfield | school | 5500900 | 315 | Public school | Bayfield | 550090000082 | 30 | Bayfield Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 31 | 31 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2319914 | 2319914 | WI | Calumet | school | 5502520 | 1085 | Public school | Chilton | 550252002430 | 30 | Chilton Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 100 | 100 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2320215 | 2320215 | WI | Grant | school | 5503030 | 1246 | Public school | Cuba City | 550303003103 | 30 | Cuba City Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 42 | 42 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2320446 | 2320446 | WI | Brown | school | 5503210 | 1414 | Public school | De Pere | 550321000362 | 30 | De Pere Middle | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 336 | 336 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2321098 | 2321098 | WI | Pierce | school | 5504350 | 1666 | Public school | Elmwood | 550435000347 | 30 | Elmwood Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 22 | 22 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2322528 | 2322528 | WI | Outagamie | school | 5506600 | 2583 | Public school | Hortonville Area | 550660002408 | 30 | Hortonville Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 133 | 133 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2322552 | 2322552 | WI | Brown | school | 5506630 | 2604 | Public school | Howard-Suamico | 550663000717 | 30 | Bay View Middle | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 470 | 470 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2323775 | 2323775 | WI | Waukesha | school | 5500013 | 3862 | Public school | Lake Country | 550001300578 | 30 | Lake Country School | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 65 | 65 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2325196 | 2325196 | WI | Dane | school | 5509510 | 3549 | Public school | Middleton-Cross Plains Area | 550951001104 | 30 | Kromrey Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 317 | 317 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2326938 | 2326938 | WI | Green | school | 5509900 | 3696 | Public school | Monticello | 550990000384 | 30 | Monticello Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 28 | 28 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2327225 | 2327225 | WI | Clark | school | 5510350 | 3899 | Public school | Neillsville | 551035002326 | 30 | Neillsville Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 62 | 62 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2328252 | 2328252 | WI | Jefferson | school | 5511350 | 4221 | Public school | Palmyra-Eagle Area | 551135002418 | 30 | Palmyra-Eagle Middle | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 37 | 37 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2328702 | 2328702 | WI | Barron | school | 5512180 | 4557 | Public school | Prairie Farm Public | 551218000445 | 30 | Prairie Farm Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 44 | 44 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2329503 | 2329503 | WI | Fond du Lac | school | 5513100 | 4956 | Public school | Rosendale-Brandon | 551310001728 | 30 | Brandon Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 36 | 36 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2329728 | 2329728 | WI | Door | school | 5513500 | 5130 | Public school | Sevastopol | 551350000496 | 30 | Sevastopol Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 38 | 38 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331091 | 2331091 | WI | Barron | school | 5515060 | 5810 | Public school | Turtle Lake | 551506003068 | 30 | Turtle Lake Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 30 | 30 |
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]);