enrollments
Data source: Big Local News · About: Big Local
696 rows where grade = "grade_7", state = "WI" and year = 2021 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2340972 | 2340972 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002302 | 6 | Lincoln Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 168 | 168 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2336505 | 2336505 | WI | Milwaukee | school | 5505460 | 2184 | Public school | Glendale-River Hills | 550546000575 | 10 | Glen Hills Middle | Regular School | No | Middle | 04 | 08 | 2021 | grade_7 | 129 | 129 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2341961 | 2341961 | WI | Waukesha | school | 5510170 | 3857 | Public school | Muskego-Norway | 551017001330 | 10 | Muskego Lakes Middle | Regular School | No | Middle | 05 | 08 | 2021 | grade_7 | 180 | 180 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2343280 | 2343280 | WI | Vilas | school | 5511710 | 4330 | Public school | Phelps | 551171001539 | 10 | Phelps Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 10 | 10 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2345324 | 2345324 | WI | Portage | school | 5514490 | 5607 | Public school | Stevens Point Area Public | 551449001868 | 10 | Benjamin Franklin Junior High | Regular School | No | Middle | 07 | 09 | 2021 | grade_7 | 283 | 283 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2346318 | 2346318 | WI | Racine | school | 5515660 | 6113 | Public school | Waterford Graded J1 | 551566001989 | 10 | Fox River Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 159 | 159 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2347214 | 2347214 | WI | Washington | school | 5516290 | 6307 | Public school | West Bend | 551629002125 | 10 | Badger Middle | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 443 | 443 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2334096 | 2334096 | WI | Trempealeau | school | 5500016 | 485 | Public school | Blair-Taylor | 550001602378 | 11 | Blair-Taylor Middle/High | Regular School | No | High | 07 | 12 | 2021 | grade_7 | 49 | 49 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2333015 | 2333015 | WI | Buffalo | school | 5500180 | 84 | Public school | Alma | 550018000017 | 20 | Alma Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 19 | 19 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2333634 | 2333634 | WI | Sauk | school | 5500810 | 280 | Public school | Baraboo | 550081000102 | 20 | Jack Young Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 208 | 208 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2333753 | 2333753 | WI | Dodge | school | 5500960 | 336 | Public school | Beaver Dam Unified | 550096000122 | 20 | Beaver Dam Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 241 | 241 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2334201 | 2334201 | WI | Kenosha | school | 5501650 | 657 | Public school | Brighton #1 | 550165000205 | 20 | Brighton Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 21 | 21 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2334230 | 2334230 | WI | Kenosha | school | 5501710 | 665 | Public school | Bristol #1 | 550171000209 | 20 | Bristol Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 82 | 82 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2334816 | 2334816 | WI | Waupaca | school | 5502670 | 1141 | Public school | Clintonville | 550267000301 | 20 | Clintonville Middle | Regular School | No | Middle | 05 | 08 | 2021 | grade_7 | 74 | 74 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2334922 | 2334922 | WI | Columbia | school | 5502820 | 1183 | Public school | Columbus | 550282000319 | 20 | Columbus Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 81 | 81 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2335420 | 2335420 | WI | Racine | school | 5503750 | 1449 | Public school | Dover #1 | 550375000394 | 20 | Kansasville Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 11 | 11 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2335760 | 2335760 | WI | Sheboygan | school | 5504260 | 1631 | Public school | Elkhart Lake-Glenbeulah | 550426000455 | 20 | Elkhart Lake Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 42 | 42 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2335841 | 2335841 | WI | Pierce | school | 5504320 | 1659 | Public school | Ellsworth Community | 550432000463 | 20 | Ellsworth Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 126 | 126 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2335936 | 2335936 | WI | Washington | school | 5504410 | 1687 | Public school | Erin | 550441000476 | 20 | Erin Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 43 | 43 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2336170 | 2336170 | WI | Walworth | school | 5504720 | 1870 | Public school | Fontana J8 | 550472000508 | 20 | Fontana Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 23 | 23 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2336219 | 2336219 | WI | Milwaukee | school | 5504800 | 1890 | Public school | Fox Point J2 | 550480000517 | 20 | Bayside Middle | Regular School | No | Middle | 05 | 08 | 2021 | grade_7 | 100 | 100 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2336361 | 2336361 | WI | Walworth | school | 5505100 | 2044 | Public school | Geneva J4 | 550510000546 | 20 | Woods Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 20 | 20 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2336631 | 2336631 | 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 | 2021 | grade_7 | 63 | 63 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2337104 | 2337104 | WI | Washington | school | 5506090 | 2443 | Public school | Hartford J1 | 550609000674 | 20 | Central Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 195 | 195 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2337590 | 2337590 | WI | Iowa | school | 5506870 | 2646 | Public school | Iowa-Grant | 550687000744 | 20 | Iowa-Grant Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 54 | 54 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2337860 | 2337860 | WI | Green | school | 5507230 | 2737 | Public school | Juda | 550723000784 | 20 | Juda Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 23 | 23 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2338358 | 2338358 | WI | Vernon | school | 5512540 | 5960 | Public school | Kickapoo Area | 551254001658 | 20 | Kickapoo High | Regular School | No | High | 06 | 12 | 2021 | grade_7 | 40 | 40 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2338624 | 2338624 | WI | Vilas | school | 5504620 | 1848 | Public school | Lac du Flambeau #1 | 550462000488 | 20 | Lac du Flambeau Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 43 | 43 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2338711 | 2338711 | WI | Chippewa | school | 5507680 | 2891 | Public school | Lake Holcombe | 550768000885 | 20 | Holcombe Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 14 | 14 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2338778 | 2338778 | WI | Forest | school | 5507830 | 2940 | Public school | Laona | 550783000893 | 20 | Laona High | Regular School | No | High | 07 | 12 | 2021 | grade_7 | 22 | 22 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2338815 | 2338815 | WI | Walworth | school | 5508040 | 3087 | Public school | Linn J4 | 550804000898 | 20 | Traver Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 15 | 15 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2338826 | 2338826 | WI | Walworth | school | 5508070 | 3094 | Public school | Linn J6 | 550807000899 | 20 | Reek Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 17 | 17 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2339822 | 2339822 | WI | Winnebago | school | 5509030 | 3430 | Public school | Menasha Joint | 550903001053 | 20 | Maplewood Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 253 | 253 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2340045 | 2340045 | WI | Waukesha | school | 5509360 | 3528 | Public school | Merton Community | 550936002269 | 20 | Merton Intermediate | Regular School | No | Middle | 05 | 08 | 2021 | grade_7 | 85 | 85 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2341637 | 2341637 | WI | Oneida | school | 5509690 | 3640 | Public school | Minocqua J1 | 550969001278 | 20 | Minocqua Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 62 | 62 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2342101 | 2342101 | WI | Wood | school | 5510380 | 3906 | Public school | Nekoosa | 551038001358 | 20 | Alexander Middle | Regular School | No | Middle | 04 | 08 | 2021 | grade_7 | 67 | 67 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2342388 | 2342388 | WI | Racine | school | 5512510 | 4690 | Public school | North Cape | 551251001657 | 20 | North Cape Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 19 | 19 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2342411 | 2342411 | WI | Fond du Lac | school | 5510740 | 3983 | Public school | North Fond du Lac | 551074001396 | 20 | Bessie Allen Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 114 | 114 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2342444 | 2342444 | WI | Waukesha | school | 5509300 | 3514 | Public school | North Lake | 550930002268 | 20 | North Lake Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 37 | 37 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2342589 | 2342589 | WI | Monroe | school | 5510770 | 3990 | Public school | Norwalk-Ontario-Wilton | 551077001402 | 20 | Brookwood High | Regular School | No | High | 07 | 12 | 2021 | grade_7 | 45 | 45 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2342609 | 2342609 | WI | Racine | school | 5510800 | 4011 | Public school | Norway J7 | 551080001405 | 20 | Drought Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 14 | 14 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2343168 | 2343168 | WI | Kenosha | school | 5511400 | 4235 | Public school | Paris J1 | 551140001520 | 20 | Paris Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 36 | 36 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2343327 | 2343327 | WI | Wood | school | 5511790 | 4368 | Public school | Pittsville | 551179001546 | 20 | Pittsville Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 33 | 33 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2343942 | 2343942 | WI | Kenosha | school | 5512390 | 4627 | Public school | Randall J1 | 551239001649 | 20 | Randall Consolidated School | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 82 | 82 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2343958 | 2343958 | WI | Dodge | school | 5512420 | 4634 | Public school | Randolph | 551242001650 | 20 | Randolph Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 53 | 53 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2343984 | 2343984 | WI | Sheboygan | school | 5512450 | 4641 | Public school | Random Lake | 551245002421 | 20 | Random Lake Middle | Regular School | No | Middle | 05 | 08 | 2021 | grade_7 | 53 | 53 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2343993 | 2343993 | WI | Racine | school | 5512480 | 4686 | Public school | Raymond #14 | 551248001656 | 20 | Raymond Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 53 | 53 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2344198 | 2344198 | WI | Waukesha | school | 5508130 | 3122 | Public school | Richmond | 550813002262 | 20 | Richmond Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 53 | 53 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2344513 | 2344513 | WI | Milwaukee | school | 5513260 | 5026 | Public school | Saint Francis | 551326001747 | 20 | Deer Creek Intermediate | Regular School | No | Middle | 04 | 08 | 2021 | grade_7 | 73 | 73 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2344534 | 2344534 | WI | Kenosha | school | 5513350 | 5068 | Public school | Salem | 551335001753 | 20 | Salem Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 107 | 107 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2344640 | 2344640 | WI | Outagamie | school | 5513530 | 5138 | Public school | Seymour Community | 551353001769 | 20 | Black Creek Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 35 | 35 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2344669 | 2344669 | WI | Walworth | school | 5513560 | 5258 | Public school | Sharon J11 | 551356001774 | 20 | Sharon Community | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 25 | 25 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2344897 | 2344897 | WI | Outagamie | school | 5513770 | 5348 | Public school | Shiocton | 551377001807 | 20 | Shiocton Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 54 | 54 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2344964 | 2344964 | WI | Kenosha | school | 5513860 | 5369 | Public school | Silver Lake J1 | 551386001815 | 20 | Riverview Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 71 | 71 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2345454 | 2345454 | WI | Waukesha | school | 5509390 | 3542 | Public school | Stone Bank | 550939002270 | 20 | Stone Bank Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 44 | 44 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2345738 | 2345738 | WI | Waukesha | school | 5509240 | 3510 | Public school | Swallow | 550924002267 | 20 | Swallow Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 58 | 58 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2345762 | 2345762 | WI | Clark | school | 5514820 | 5726 | Public school | Thorp | 551482001925 | 20 | Thorp Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 42 | 42 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2345964 | 2345964 | WI | Kenosha | school | 5500052 | 5780 | Public school | Trevor-Wilmot Consolidated | 550005202644 | 20 | Trevor-Wilmot Grade | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 52 | 52 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2346028 | 2346028 | WI | Kenosha | school | 5515090 | 5817 | Public school | Twin Lakes #4 | 551509001957 | 20 | Lakewood Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 34 | 34 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2346259 | 2346259 | WI | Walworth | school | 5515450 | 6022 | Public school | Walworth J1 | 551545001981 | 20 | Walworth Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 53 | 53 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2346279 | 2346279 | WI | Bayfield | school | 5515540 | 6027 | Public school | Washburn | 551554001984 | 20 | Washburn Middle | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 51 | 51 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2346287 | 2346287 | WI | Door | school | 5515570 | 6069 | Public school | Washington | 551557001986 | 20 | Washington Island Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 4 | 4 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2346303 | 2346303 | WI | Racine | school | 5515700 | 6104 | Public school | Washington-Caldwell | 551570001993 | 20 | Washington Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 16 | 16 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2347441 | 2347441 | WI | Kenosha | school | 5516560 | 6412 | Public school | Wheatland J1 | 551656002163 | 20 | Wheatland Center Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 59 | 59 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2347560 | 2347560 | WI | Walworth | school | 5516680 | 6461 | Public school | Whitewater Unified | 551668002178 | 20 | Whitewater Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 132 | 132 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2347811 | 2347811 | WI | Shawano | school | 5517100 | 6692 | Public school | Wittenberg-Birnamwood | 551710002218 | 20 | Birnamwood Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 46 | 46 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2347898 | 2347898 | WI | Vilas | school | 5517160 | 6720 | Public school | Woodruff J1 | 551716002227 | 20 | Arbor Vitae-Woodruff Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 54 | 54 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2347928 | 2347928 | WI | Racine | school | 5517220 | 6748 | Public school | Yorkville J2 | 551722002230 | 20 | Yorkville Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 51 | 51 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2334133 | 2334133 | WI | Shawano | school | 5501470 | 602 | Public school | Bonduel | 550147002383 | 21 | Bonduel Middle | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 33 | 33 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2334221 | 2334221 | WI | Calumet | school | 5501680 | 658 | Public school | Brillion | 550168002384 | 21 | Brillion Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 68 | 68 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2334976 | 2334976 | WI | Forest | school | 5502910 | 1218 | Public school | Crandon | 550291002388 | 22 | Crandon Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 56 | 56 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2335021 | 2335021 | WI | Milwaukee | school | 5503060 | 1253 | Public school | Cudahy | 550306002389 | 22 | Cudahy Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 184 | 184 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2335652 | 2335652 | WI | Marathon | school | 5504080 | 1561 | Public school | Edgar | 550408002391 | 23 | Edgar Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 44 | 44 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2335392 | 2335392 | WI | Dodge | school | 5507260 | 2744 | Public school | Dodgeland | 550726002983 | 25 | Dodgeland Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 74 | 74 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2339499 | 2339499 | WI | Green Lake | school | 5508760 | 3325 | Public school | Markesan | 550876002414 | 25 | Markesan Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 60 | 60 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2343098 | 2343098 | WI | Trempealeau | school | 5511220 | 4186 | Public school | Osseo-Fairchild | 551122002398 | 26 | Osseo-Fairchild Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 52 | 52 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2344612 | 2344612 | WI | Crawford | school | 5513470 | 5124 | Public school | Seneca Area | 551347002399 | 28 | Seneca Junior High | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 17 | 17 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2344955 | 2344955 | WI | Lafayette | school | 5513830 | 5362 | Public school | Shullsburg | 551383002400 | 28 | Shullsburg Junior High | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 19 | 19 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2347497 | 2347497 | WI | Milwaukee | school | 5516620 | 6419 | Public school | Whitefish Bay | 551662002402 | 29 | Whitefish Bay Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 207 | 207 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2333449 | 2333449 | WI | Ashland | school | 5500510 | 170 | Public school | Ashland | 550051000074 | 30 | Ashland Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 161 | 161 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2333737 | 2333737 | WI | Bayfield | school | 5500900 | 315 | Public school | Bayfield | 550090000082 | 30 | Bayfield Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 30 | 30 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2334699 | 2334699 | WI | Calumet | school | 5502520 | 1085 | Public school | Chilton | 550252002430 | 30 | Chilton Middle | Regular School | No | Middle | 05 | 08 | 2021 | grade_7 | 81 | 81 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2335012 | 2335012 | WI | Grant | school | 5503030 | 1246 | Public school | Cuba City | 550303003103 | 30 | Cuba City Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 54 | 54 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2335243 | 2335243 | WI | Brown | school | 5503210 | 1414 | Public school | De Pere | 550321000362 | 30 | De Pere Middle | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 346 | 346 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2335919 | 2335919 | WI | Pierce | school | 5504350 | 1666 | Public school | Elmwood | 550435000347 | 30 | Elmwood Middle | Regular School | No | Middle | 05 | 08 | 2021 | grade_7 | 22 | 22 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2337371 | 2337371 | WI | Outagamie | school | 5506600 | 2583 | Public school | Hortonville Area | 550660002408 | 30 | Hortonville Middle | Regular School | No | Middle | 05 | 08 | 2021 | grade_7 | 117 | 117 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2337394 | 2337394 | WI | Brown | school | 5506630 | 2604 | Public school | Howard-Suamico | 550663000717 | 30 | Bay View Middle | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 444 | 444 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2338655 | 2338655 | WI | Waukesha | school | 5500013 | 3862 | Public school | Lake Country | 550001300578 | 30 | Lake Country School | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 64 | 64 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2340075 | 2340075 | WI | Dane | school | 5509510 | 3549 | Public school | Middleton-Cross Plains Area | 550951001104 | 30 | Kromrey Middle | Regular School | No | Middle | 05 | 08 | 2021 | grade_7 | 310 | 310 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2341813 | 2341813 | WI | Green | school | 5509900 | 3696 | Public school | Monticello | 550990000384 | 30 | Monticello Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 22 | 22 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2342094 | 2342094 | WI | Clark | school | 5510350 | 3899 | Public school | Neillsville | 551035002326 | 30 | Neillsville Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 62 | 62 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2343141 | 2343141 | WI | Jefferson | school | 5511350 | 4221 | Public school | Palmyra-Eagle Area | 551135002418 | 30 | Palmyra-Eagle Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 49 | 49 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2343592 | 2343592 | WI | Barron | school | 5512180 | 4557 | Public school | Prairie Farm Public | 551218000445 | 30 | Prairie Farm Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 28 | 28 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2344401 | 2344401 | WI | Fond du Lac | school | 5513100 | 4956 | Public school | Rosendale-Brandon | 551310001728 | 30 | Brandon Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 36 | 36 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2344628 | 2344628 | WI | Door | school | 5513500 | 5130 | Public school | Sevastopol | 551350000496 | 30 | Sevastopol Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 39 | 39 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2346019 | 2346019 | WI | Barron | school | 5515060 | 5810 | Public school | Turtle Lake | 551506003068 | 30 | Turtle Lake Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 40 | 40 |
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]);