enrollments
Data source: Big Local News · About: Big Local
657 rows where grade = "grade_7", state = "WI" and year = 2018 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3096540 | 3096540 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002302 | 6 | Lincoln Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 229 | 229 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3092185 | 3092185 | WI | Milwaukee | school | 5505460 | 2184 | Public school | Glendale-River Hills | 550546000575 | 10 | Glen Hills Middle | Regular School | No | Middle | 04 | 08 | 2018 | grade_7 | 114 | 114 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3097524 | 3097524 | WI | Waukesha | school | 5510170 | 3857 | Public school | Muskego-Norway | 551017001330 | 10 | Bay Lane Middle | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 196 | 196 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3098836 | 3098836 | WI | Vilas | school | 5511710 | 4330 | Public school | Phelps | 551171001539 | 10 | Phelps Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 10 | 10 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3100868 | 3100868 | WI | Portage | school | 5514490 | 5607 | Public school | Stevens Point Area Public | 551449001868 | 10 | Benjamin Franklin Junior High | Regular School | No | Middle | 07 | 09 | 2018 | grade_7 | 274 | 274 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3101790 | 3101790 | WI | Racine | school | 5515660 | 6113 | Public school | Waterford Graded J1 | 551566001989 | 10 | Fox River Middle | Regular School | No | Middle | 07 | 08 | 2018 | grade_7 | 204 | 204 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3102643 | 3102643 | WI | Washington | school | 5516290 | 6307 | Public school | West Bend | 551629002125 | 10 | Badger Middle | Regular School | No | Middle | 07 | 08 | 2018 | grade_7 | 469 | 469 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3089859 | 3089859 | WI | Trempealeau | school | 5500016 | 485 | Public school | Blair-Taylor | 550001602378 | 11 | Blair-Taylor Middle/High | Regular School | No | High | 07 | 12 | 2018 | grade_7 | 54 | 54 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3088745 | 3088745 | WI | Buffalo | school | 5500180 | 84 | Public school | Alma | 550018000017 | 20 | Alma Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 17 | 17 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3089382 | 3089382 | WI | Sauk | school | 5500810 | 280 | Public school | Baraboo | 550081000102 | 20 | Jack Young Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 194 | 194 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3089498 | 3089498 | WI | Dodge | school | 5500960 | 336 | Public school | Beaver Dam Unified | 550096000122 | 20 | Beaver Dam Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 274 | 274 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3089605 | 3089605 | WI | Rock | school | 5501050 | 413 | Public school | Beloit | 550105000137 | 20 | Aldrich Intermediate | Regular School | No | Middle | 04 | 08 | 2018 | grade_7 | 112 | 112 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3089970 | 3089970 | WI | Kenosha | school | 5501650 | 657 | Public school | Brighton #1 | 550165000205 | 20 | Brighton Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 25 | 25 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3089999 | 3089999 | WI | Kenosha | school | 5501710 | 665 | Public school | Bristol #1 | 550171000209 | 20 | Bristol Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 76 | 76 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3090558 | 3090558 | WI | Waupaca | school | 5502670 | 1141 | Public school | Clintonville | 550267000301 | 20 | Clintonville Middle | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 84 | 84 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3090659 | 3090659 | WI | Columbia | school | 5502820 | 1183 | Public school | Columbus | 550282000319 | 20 | Columbus Middle | Regular School | No | Middle | 04 | 08 | 2018 | grade_7 | 103 | 103 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3090727 | 3090727 | WI | Grant | school | 5503030 | 1246 | Public school | Cuba City | 550303000332 | 20 | Cuba City Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 52 | 52 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3091143 | 3091143 | WI | Racine | school | 5503750 | 1449 | Public school | Dover #1 | 550375000394 | 20 | Kansasville Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 9 | 9 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3091430 | 3091430 | WI | Dunn | school | 5504230 | 1645 | Public school | Elk Mound Area | 550423000452 | 20 | Elk Mound Middle | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 80 | 80 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3091447 | 3091447 | WI | Sheboygan | school | 5504260 | 1631 | Public school | Elkhart Lake-Glenbeulah | 550426000455 | 20 | Elkhart Lake Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 30 | 30 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3091528 | 3091528 | WI | Pierce | school | 5504320 | 1659 | Public school | Ellsworth Community | 550432000463 | 20 | Ellsworth Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 141 | 141 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3091615 | 3091615 | WI | Washington | school | 5504410 | 1687 | Public school | Erin | 550441000476 | 20 | Erin Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 35 | 35 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3091851 | 3091851 | WI | Walworth | school | 5504720 | 1870 | Public school | Fontana J8 | 550472000508 | 20 | Fontana Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 28 | 28 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3091900 | 3091900 | WI | Milwaukee | school | 5504800 | 1890 | Public school | Fox Point J2 | 550480000517 | 20 | Bayside Middle | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 85 | 85 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3092006 | 3092006 | WI | Washington | school | 5512880 | 4843 | Public school | Friess Lake | 551288001701 | 20 | Friess Lake School | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 16 | 16 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3092051 | 3092051 | WI | Walworth | school | 5505100 | 2044 | Public school | Geneva J4 | 550510000546 | 20 | Woods Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 9 | 9 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3092315 | 3092315 | 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 | 2018 | grade_7 | 55 | 55 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3092791 | 3092791 | WI | Washington | school | 5506090 | 2443 | Public school | Hartford J1 | 550609000674 | 20 | Central Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 193 | 193 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3093240 | 3093240 | WI | Iowa | school | 5506870 | 2646 | Public school | Iowa-Grant | 550687000744 | 20 | Iowa-Grant Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 63 | 63 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3093483 | 3093483 | WI | Green | school | 5507230 | 2737 | Public school | Juda | 550723000784 | 20 | Juda Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 26 | 26 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3093984 | 3093984 | WI | Vernon | school | 5512540 | 5960 | Public school | Kickapoo Area | 551254001658 | 20 | Kickapoo High | Regular School | No | High | 06 | 12 | 2018 | grade_7 | 35 | 35 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3094238 | 3094238 | WI | Vilas | school | 5504620 | 1848 | Public school | Lac du Flambeau #1 | 550462000488 | 20 | Lac du Flambeau Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 39 | 39 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3094310 | 3094310 | WI | Chippewa | school | 5507680 | 2891 | Public school | Lake Holcombe | 550768000885 | 20 | Holcombe Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 25 | 25 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3094375 | 3094375 | WI | Forest | school | 5507830 | 2940 | Public school | Laona | 550783000893 | 20 | Laona High | Regular School | No | High | 07 | 12 | 2018 | grade_7 | 14 | 14 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3094411 | 3094411 | WI | Walworth | school | 5508040 | 3087 | Public school | Linn J4 | 550804000898 | 20 | Traver Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 10 | 10 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3094422 | 3094422 | WI | Walworth | school | 5508070 | 3094 | Public school | Linn J6 | 550807000899 | 20 | Reek Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 15 | 15 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3095197 | 3095197 | WI | Juneau | school | 5508850 | 3360 | Public school | Mauston | 550885001026 | 20 | Olson Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 89 | 89 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3095327 | 3095327 | WI | Jackson | school | 5509000 | 3428 | Public school | Melrose-Mindoro | 550900001050 | 20 | Melrose Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 56 | 56 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3095381 | 3095381 | WI | Winnebago | school | 5509030 | 3430 | Public school | Menasha Joint | 550903001053 | 20 | Maplewood Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 258 | 258 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3097242 | 3097242 | WI | Oneida | school | 5509690 | 3640 | Public school | Minocqua J1 | 550969001278 | 20 | Minocqua Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 57 | 57 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3097697 | 3097697 | WI | Wood | school | 5510380 | 3906 | Public school | Nekoosa | 551038001358 | 20 | Alexander Middle | Regular School | No | Middle | 04 | 08 | 2018 | grade_7 | 62 | 62 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3097955 | 3097955 | WI | Waukesha | school | 5510710 | 3976 | Public school | Norris | 551071001395 | 20 | Norris High | Regular School | No | High | 06 | 12 | 2018 | grade_7 | 2 | 2 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3097965 | 3097965 | WI | Racine | school | 5512510 | 4690 | Public school | North Cape | 551251001657 | 20 | North Cape Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 25 | 25 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3097989 | 3097989 | WI | Fond du Lac | school | 5510740 | 3983 | Public school | North Fond du Lac | 551074001396 | 20 | Bessie Allen Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 105 | 105 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3098013 | 3098013 | WI | Waukesha | school | 5509300 | 3514 | Public school | North Lake | 550930002268 | 20 | North Lake Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 47 | 47 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3098142 | 3098142 | WI | Monroe | school | 5510770 | 3990 | Public school | Norwalk-Ontario-Wilton | 551077001402 | 20 | Brookwood High | Regular School | No | High | 07 | 12 | 2018 | grade_7 | 61 | 61 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3098162 | 3098162 | WI | Racine | school | 5510800 | 4011 | Public school | Norway J7 | 551080001405 | 20 | Drought Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 12 | 12 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3098729 | 3098729 | WI | Kenosha | school | 5511400 | 4235 | Public school | Paris J1 | 551140001520 | 20 | Paris Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 29 | 29 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3098871 | 3098871 | WI | Wood | school | 5511790 | 4368 | Public school | Pittsville | 551179001546 | 20 | Pittsville Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 43 | 43 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3099503 | 3099503 | WI | Kenosha | school | 5512390 | 4627 | Public school | Randall J1 | 551239001649 | 20 | Randall Consolidated School | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 76 | 76 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3099515 | 3099515 | WI | Dodge | school | 5512420 | 4634 | Public school | Randolph | 551242001650 | 20 | Randolph Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 39 | 39 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3099541 | 3099541 | WI | Sheboygan | school | 5512450 | 4641 | Public school | Random Lake | 551245002421 | 20 | Random Lake Middle | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 66 | 66 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3099550 | 3099550 | WI | Racine | school | 5512480 | 4686 | Public school | Raymond #14 | 551248001656 | 20 | Raymond Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 46 | 46 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3099726 | 3099726 | WI | Washington | school | 5512900 | 4820 | Public school | Richfield J1 | 551290001703 | 20 | Richfield Elementary | Regular School | No | Middle | 03 | 08 | 2018 | grade_7 | 40 | 40 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3099769 | 3099769 | WI | Waukesha | school | 5508130 | 3122 | Public school | Richmond | 550813002262 | 20 | Richmond Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 35 | 35 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3100070 | 3100070 | WI | Milwaukee | school | 5513260 | 5026 | Public school | Saint Francis | 551326001747 | 20 | Deer Creek Intermediate | Regular School | No | Middle | 04 | 08 | 2018 | grade_7 | 74 | 74 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3100091 | 3100091 | WI | Kenosha | school | 5513350 | 5068 | Public school | Salem | 551335001753 | 20 | Salem Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 85 | 85 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3100201 | 3100201 | WI | Outagamie | school | 5513530 | 5138 | Public school | Seymour Community | 551353001769 | 20 | Black Creek Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 36 | 36 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3100230 | 3100230 | WI | Walworth | school | 5513560 | 5258 | Public school | Sharon J11 | 551356001774 | 20 | Sharon Community | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 26 | 26 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3100463 | 3100463 | WI | Outagamie | school | 5513770 | 5348 | Public school | Shiocton | 551377001807 | 20 | Shiocton Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 60 | 60 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3100529 | 3100529 | WI | Kenosha | school | 5513860 | 5369 | Public school | Silver Lake J1 | 551386001815 | 20 | Riverview Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 51 | 51 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3100985 | 3100985 | WI | Waukesha | school | 5509390 | 3542 | Public school | Stone Bank | 550939002270 | 20 | Stone Bank Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 39 | 39 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3101242 | 3101242 | WI | Waukesha | school | 5509240 | 3510 | Public school | Swallow | 550924002267 | 20 | Swallow Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 70 | 70 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3101254 | 3101254 | WI | Clark | school | 5514820 | 5726 | Public school | Thorp | 551482001925 | 20 | Thorp Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 38 | 38 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3101447 | 3101447 | WI | Kenosha | school | 5500052 | 5780 | Public school | Trevor-Wilmot Consolidated | 550005202644 | 20 | Trevor-Wilmot Grade | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 63 | 63 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3101499 | 3101499 | WI | Kenosha | school | 5515090 | 5817 | Public school | Twin Lakes #4 | 551509001957 | 20 | Lakewood Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 36 | 36 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3101551 | 3101551 | WI | Racine | school | 5515180 | 5859 | Public school | Union Grove J1 | 551518001964 | 20 | Union Grove Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 109 | 109 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3101731 | 3101731 | WI | Walworth | school | 5515450 | 6022 | Public school | Walworth J1 | 551545001981 | 20 | Walworth Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 51 | 51 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3101750 | 3101750 | WI | Bayfield | school | 5515540 | 6027 | Public school | Washburn | 551554001984 | 20 | Washburn Middle | Regular School | No | Middle | 07 | 08 | 2018 | grade_7 | 38 | 38 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3101758 | 3101758 | WI | Door | school | 5515570 | 6069 | Public school | Washington | 551557001986 | 20 | Washington Island Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 5 | 5 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3101774 | 3101774 | WI | Racine | school | 5515700 | 6104 | Public school | Washington-Caldwell | 551570001993 | 20 | Washington Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 21 | 21 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3102873 | 3102873 | WI | Kenosha | school | 5516560 | 6412 | Public school | Wheatland J1 | 551656002163 | 20 | Wheatland Center Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 57 | 57 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3102979 | 3102979 | WI | Walworth | school | 5516680 | 6461 | Public school | Whitewater Unified | 551668002178 | 20 | Whitewater Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 161 | 161 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3103236 | 3103236 | WI | Shawano | school | 5517100 | 6692 | Public school | Wittenberg-Birnamwood | 551710002218 | 20 | Birnamwood Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 33 | 33 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3103305 | 3103305 | WI | Vilas | school | 5517160 | 6720 | Public school | Woodruff J1 | 551716002227 | 20 | Arbor Vitae-Woodruff Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 57 | 57 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3103335 | 3103335 | WI | Racine | school | 5517220 | 6748 | Public school | Yorkville J2 | 551722002230 | 20 | Yorkville Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 72 | 72 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3089903 | 3089903 | WI | Shawano | school | 5501470 | 602 | Public school | Bonduel | 550147002383 | 21 | Bonduel Middle | Regular School | No | Middle | 07 | 08 | 2018 | grade_7 | 58 | 58 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3089990 | 3089990 | WI | Calumet | school | 5501680 | 658 | Public school | Brillion | 550168002384 | 21 | Brillion Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 76 | 76 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3090700 | 3090700 | WI | Forest | school | 5502910 | 1218 | Public school | Crandon | 550291002388 | 22 | Crandon Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 59 | 59 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3090744 | 3090744 | WI | Milwaukee | school | 5503060 | 1253 | Public school | Cudahy | 550306002389 | 22 | Cudahy Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 166 | 166 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3091361 | 3091361 | WI | Marathon | school | 5504080 | 1561 | Public school | Edgar | 550408002391 | 23 | Edgar Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 48 | 48 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3091108 | 3091108 | WI | Dodge | school | 5507260 | 2744 | Public school | Dodgeland | 550726002983 | 25 | Dodgeland Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 52 | 52 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3095068 | 3095068 | WI | Green Lake | school | 5508760 | 3325 | Public school | Markesan | 550876002414 | 25 | Markesan Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 65 | 65 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3098656 | 3098656 | WI | Trempealeau | school | 5511220 | 4186 | Public school | Osseo-Fairchild | 551122002398 | 26 | Osseo-Fairchild Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 81 | 81 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3100173 | 3100173 | WI | Crawford | school | 5513470 | 5124 | Public school | Seneca Area | 551347002399 | 28 | Seneca Junior High | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 25 | 25 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3100520 | 3100520 | WI | Lafayette | school | 5513830 | 5362 | Public school | Shullsburg | 551383002400 | 28 | Shullsburg Junior High | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 24 | 24 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3102924 | 3102924 | WI | Milwaukee | school | 5516620 | 6419 | Public school | Whitefish Bay | 551662002402 | 29 | Whitefish Bay Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 221 | 221 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3089200 | 3089200 | WI | Ashland | school | 5500510 | 170 | Public school | Ashland | 550051000074 | 30 | Ashland Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 128 | 128 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3089482 | 3089482 | WI | Bayfield | school | 5500900 | 315 | Public school | Bayfield | 550090000082 | 30 | Bayfield Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 30 | 30 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3090440 | 3090440 | WI | Calumet | school | 5502520 | 1085 | Public school | Chilton | 550252002430 | 30 | Chilton Middle | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 87 | 87 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3090963 | 3090963 | WI | Brown | school | 5503210 | 1414 | Public school | De Pere | 550321000362 | 30 | De Pere Middle | Regular School | No | Middle | 07 | 08 | 2018 | grade_7 | 315 | 315 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3091606 | 3091606 | WI | Pierce | school | 5504350 | 1666 | Public school | Elmwood | 550435000347 | 30 | Elmwood Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 31 | 31 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3093039 | 3093039 | WI | Outagamie | school | 5506600 | 2583 | Public school | Hortonville Area | 550660002408 | 30 | Hortonville Middle | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 84 | 84 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3093061 | 3093061 | WI | Brown | school | 5506630 | 2604 | Public school | Howard-Suamico | 550663000717 | 30 | Bay View Middle | Regular School | No | Middle | 07 | 08 | 2018 | grade_7 | 447 | 447 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3094268 | 3094268 | WI | Waukesha | school | 5500013 | 3862 | Public school | Lake Country | 550001300578 | 30 | Lake Country School | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 54 | 54 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3095644 | 3095644 | WI | Dane | school | 5509510 | 3549 | Public school | Middleton-Cross Plains Area | 550951001104 | 30 | Kromrey Middle | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 326 | 326 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3097407 | 3097407 | WI | Green | school | 5509900 | 3696 | Public school | Monticello | 550990000384 | 30 | Monticello Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 30 | 30 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3098702 | 3098702 | WI | Jefferson | school | 5511350 | 4221 | Public school | Palmyra-Eagle Area | 551135002418 | 30 | Palmyra-Eagle Middle | Regular School | No | Middle | 07 | 08 | 2018 | grade_7 | 72 | 72 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3099135 | 3099135 | WI | Barron | school | 5512180 | 4557 | Public school | Prairie Farm Public | 551218000445 | 30 | Prairie Farm Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 26 | 26 |
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]);