enrollments
Data source: Big Local News · About: Big Local
667 rows where grade = "grade_7", state = "WI" and year = 2017 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
333459 | 333459 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002302 | 6 | Lincoln Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 239 | 239 | ||||||||||||||||||||||||||||||||||||||||||||||||||
329108 | 329108 | WI | Milwaukee | school | 5505460 | 2184 | Public school | Glendale-River Hills | 550546000575 | 10 | Glen Hills Middle | Regular School | No | Elementary | 04 | 08 | 2017 | grade_7 | 106 | 106 | ||||||||||||||||||||||||||||||||||||||||||||||||||
334446 | 334446 | WI | Waukesha | school | 5510170 | 3857 | Public school | Muskego-Norway | 551017001330 | 10 | Bay Lane Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 174 | 174 | ||||||||||||||||||||||||||||||||||||||||||||||||||
335754 | 335754 | WI | Vilas | school | 5511710 | 4330 | Public school | Phelps | 551171001539 | 10 | Phelps Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 6 | 6 | ||||||||||||||||||||||||||||||||||||||||||||||||||
337812 | 337812 | WI | Portage | school | 5514490 | 5607 | Public school | Stevens Point Area Public | 551449001868 | 10 | Benjamin Franklin Junior High | Regular School | No | Other | 07 | 09 | 2017 | grade_7 | 277 | 277 | ||||||||||||||||||||||||||||||||||||||||||||||||||
338718 | 338718 | WI | Racine | school | 5515660 | 6113 | Public school | Waterford Graded J1 | 551566001989 | 10 | Fox River Middle | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 154 | 154 | ||||||||||||||||||||||||||||||||||||||||||||||||||
339566 | 339566 | WI | Washington | school | 5516290 | 6307 | Public school | West Bend | 551629002125 | 10 | Badger Middle | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 500 | 500 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326814 | 326814 | WI | Trempealeau | school | 5500016 | 485 | Public school | Blair-Taylor | 550001602378 | 11 | Blair-Taylor Middle/High | Regular School | No | High | 07 | 12 | 2017 | grade_7 | 40 | 40 | ||||||||||||||||||||||||||||||||||||||||||||||||||
325689 | 325689 | WI | Kewaunee | school | 5500150 | 70 | Public school | Algoma | 550015000015 | 20 | Algoma Elementary | Regular School | No | Elementary | PK | 06 | 2017 | grade_7 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||
325707 | 325707 | WI | Buffalo | school | 5500180 | 84 | Public school | Alma | 550018000017 | 20 | Alma Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 21 | 21 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326347 | 326347 | WI | Sauk | school | 5500810 | 280 | Public school | Baraboo | 550081000102 | 20 | Jack Young Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 230 | 230 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326468 | 326468 | WI | Dodge | school | 5500960 | 336 | Public school | Beaver Dam Unified | 550096000122 | 20 | Beaver Dam Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 235 | 235 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326577 | 326577 | WI | Rock | school | 5501050 | 413 | Public school | Beloit | 550105000137 | 20 | Aldrich Intermediate | Regular School | No | Elementary | 04 | 08 | 2017 | grade_7 | 104 | 104 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326919 | 326919 | WI | Kenosha | school | 5501650 | 657 | Public school | Brighton #1 | 550165000205 | 20 | Brighton Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 23 | 23 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326946 | 326946 | WI | Kenosha | school | 5501710 | 665 | Public school | Bristol #1 | 550171000209 | 20 | Bristol Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 74 | 74 | ||||||||||||||||||||||||||||||||||||||||||||||||||
327502 | 327502 | WI | Waupaca | school | 5502670 | 1141 | Public school | Clintonville | 550267000301 | 20 | Clintonville Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 103 | 103 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
327668 | 327668 | WI | Grant | school | 5503030 | 1246 | Public school | Cuba City | 550303000332 | 20 | Cuba City Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 48 | 48 | ||||||||||||||||||||||||||||||||||||||||||||||||||
328079 | 328079 | WI | Racine | school | 5503750 | 1449 | Public school | Dover #1 | 550375000394 | 20 | Kansasville Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 10 | 10 | ||||||||||||||||||||||||||||||||||||||||||||||||||
328366 | 328366 | WI | Dunn | school | 5504230 | 1645 | Public school | Elk Mound Area | 550423000452 | 20 | Elk Mound Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 86 | 86 | ||||||||||||||||||||||||||||||||||||||||||||||||||
328383 | 328383 | WI | Sheboygan | school | 5504260 | 1631 | Public school | Elkhart Lake-Glenbeulah | 550426000455 | 20 | Elkhart Lake Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 38 | 38 | ||||||||||||||||||||||||||||||||||||||||||||||||||
328454 | 328454 | WI | Pierce | school | 5504320 | 1659 | Public school | Ellsworth Community | 550432000463 | 20 | Ellsworth Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 139 | 139 | ||||||||||||||||||||||||||||||||||||||||||||||||||
328549 | 328549 | WI | Washington | school | 5504410 | 1687 | Public school | Erin | 550441000476 | 20 | Erin Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 41 | 41 | ||||||||||||||||||||||||||||||||||||||||||||||||||
328776 | 328776 | WI | Walworth | school | 5504720 | 1870 | Public school | Fontana J8 | 550472000508 | 20 | Fontana Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 29 | 29 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
328932 | 328932 | WI | Washington | school | 5512880 | 4843 | Public school | Friess Lake | 551288001701 | 20 | Friess Lake School | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 18 | 18 | ||||||||||||||||||||||||||||||||||||||||||||||||||
328977 | 328977 | WI | Walworth | school | 5505100 | 2044 | Public school | Geneva J4 | 550510000546 | 20 | Woods Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 17 | 17 | ||||||||||||||||||||||||||||||||||||||||||||||||||
329239 | 329239 | 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 | 2017 | grade_7 | 52 | 52 | ||||||||||||||||||||||||||||||||||||||||||||||||||
329718 | 329718 | WI | Washington | school | 5506090 | 2443 | Public school | Hartford J1 | 550609000674 | 20 | Central Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 182 | 182 | ||||||||||||||||||||||||||||||||||||||||||||||||||
329864 | 329864 | WI | Vernon | school | 5506480 | 2541 | Public school | Hillsboro | 550648000702 | 20 | Hillsboro Elementary | Regular School | No | Elementary | PK | 05 | 2017 | grade_7 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||
330168 | 330168 | WI | Iowa | school | 5506870 | 2646 | Public school | Iowa-Grant | 550687000744 | 20 | Iowa-Grant Elementary/Middle | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 46 | 46 | ||||||||||||||||||||||||||||||||||||||||||||||||||
330418 | 330418 | WI | Green | school | 5507230 | 2737 | Public school | Juda | 550723000784 | 20 | Juda Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 21 | 21 | ||||||||||||||||||||||||||||||||||||||||||||||||||
330917 | 330917 | WI | Vernon | school | 5512540 | 5960 | Public school | Kickapoo Area | 551254001658 | 20 | Kickapoo High | Regular School | No | Other | 06 | 12 | 2017 | grade_7 | 46 | 46 | ||||||||||||||||||||||||||||||||||||||||||||||||||
331169 | 331169 | WI | Vilas | school | 5504620 | 1848 | Public school | Lac du Flambeau #1 | 550462000488 | 20 | Lac du Flambeau Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 39 | 39 | ||||||||||||||||||||||||||||||||||||||||||||||||||
331241 | 331241 | WI | Chippewa | school | 5507680 | 2891 | Public school | Lake Holcombe | 550768000885 | 20 | Holcombe Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 19 | 19 | ||||||||||||||||||||||||||||||||||||||||||||||||||
331298 | 331298 | WI | Forest | school | 5507830 | 2940 | Public school | Laona | 550783000893 | 20 | Laona High | Regular School | No | High | 07 | 12 | 2017 | grade_7 | 15 | 15 | ||||||||||||||||||||||||||||||||||||||||||||||||||
331334 | 331334 | WI | Walworth | school | 5508040 | 3087 | Public school | Linn J4 | 550804000898 | 20 | Traver Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 10 | 10 | ||||||||||||||||||||||||||||||||||||||||||||||||||
331345 | 331345 | WI | Walworth | school | 5508070 | 3094 | Public school | Linn J6 | 550807000899 | 20 | Reek Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 13 | 13 | ||||||||||||||||||||||||||||||||||||||||||||||||||
332122 | 332122 | WI | Juneau | school | 5508850 | 3360 | Public school | Mauston | 550885001026 | 20 | Olson Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 103 | 103 | ||||||||||||||||||||||||||||||||||||||||||||||||||
332247 | 332247 | WI | Jackson | school | 5509000 | 3428 | Public school | Melrose-Mindoro | 550900001050 | 20 | Melrose Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 61 | 61 | ||||||||||||||||||||||||||||||||||||||||||||||||||
332299 | 332299 | WI | Winnebago | school | 5509030 | 3430 | Public school | Menasha Joint | 550903001053 | 20 | Maplewood Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 234 | 234 | ||||||||||||||||||||||||||||||||||||||||||||||||||
332531 | 332531 | WI | Waukesha | school | 5509360 | 3528 | Public school | Merton Community | 550936002269 | 20 | Merton Intermediate | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 113 | 113 | ||||||||||||||||||||||||||||||||||||||||||||||||||
334167 | 334167 | WI | Oneida | school | 5509690 | 3640 | Public school | Minocqua J1 | 550969001278 | 20 | Minocqua Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 46 | 46 | ||||||||||||||||||||||||||||||||||||||||||||||||||
334621 | 334621 | WI | Wood | school | 5510380 | 3906 | Public school | Nekoosa | 551038001358 | 20 | Alexander Middle | Regular School | No | Elementary | 04 | 08 | 2017 | grade_7 | 79 | 79 | ||||||||||||||||||||||||||||||||||||||||||||||||||
334887 | 334887 | WI | Racine | school | 5512510 | 4690 | Public school | North Cape | 551251001657 | 20 | North Cape Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 14 | 14 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
334935 | 334935 | WI | Waukesha | school | 5509300 | 3514 | Public school | North Lake | 550930002268 | 20 | North Lake Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 44 | 44 | ||||||||||||||||||||||||||||||||||||||||||||||||||
335061 | 335061 | WI | Monroe | school | 5510770 | 3990 | Public school | Norwalk-Ontario-Wilton | 551077001402 | 20 | Brookwood High | Regular School | No | High | 07 | 12 | 2017 | grade_7 | 48 | 48 | ||||||||||||||||||||||||||||||||||||||||||||||||||
335080 | 335080 | WI | Racine | school | 5510800 | 4011 | Public school | Norway J7 | 551080001405 | 20 | Drought Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 10 | 10 | ||||||||||||||||||||||||||||||||||||||||||||||||||
335651 | 335651 | WI | Kenosha | school | 5511400 | 4235 | Public school | Paris J1 | 551140001520 | 20 | Paris Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 34 | 34 | ||||||||||||||||||||||||||||||||||||||||||||||||||
335788 | 335788 | WI | Wood | school | 5511790 | 4368 | Public school | Pittsville | 551179001546 | 20 | Pittsville Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 38 | 38 | ||||||||||||||||||||||||||||||||||||||||||||||||||
336430 | 336430 | WI | Kenosha | school | 5512390 | 4627 | Public school | Randall J1 | 551239001649 | 20 | Randall Consolidated School | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 61 | 61 | ||||||||||||||||||||||||||||||||||||||||||||||||||
336442 | 336442 | WI | Columbia | school | 5512420 | 4634 | Public school | Randolph | 551242001650 | 20 | Randolph Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 35 | 35 | ||||||||||||||||||||||||||||||||||||||||||||||||||
336468 | 336468 | WI | Sheboygan | school | 5512450 | 4641 | Public school | Random Lake | 551245002421 | 20 | Random Lake Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 60 | 60 | ||||||||||||||||||||||||||||||||||||||||||||||||||
336477 | 336477 | WI | Racine | school | 5512480 | 4686 | Public school | Raymond #14 | 551248001656 | 20 | Raymond Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 37 | 37 | ||||||||||||||||||||||||||||||||||||||||||||||||||
336658 | 336658 | WI | Washington | school | 5512900 | 4820 | Public school | Richfield J1 | 551290001703 | 20 | Richfield Elementary | Regular School | No | Elementary | 03 | 08 | 2017 | grade_7 | 43 | 43 | ||||||||||||||||||||||||||||||||||||||||||||||||||
336700 | 336700 | WI | Waukesha | school | 5508130 | 3122 | Public school | Richmond | 550813002262 | 20 | Richmond Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 59 | 59 | ||||||||||||||||||||||||||||||||||||||||||||||||||
337010 | 337010 | WI | Milwaukee | school | 5513260 | 5026 | Public school | Saint Francis | 551326001747 | 20 | Deer Creek Intermediate | Regular School | No | Elementary | 04 | 08 | 2017 | grade_7 | 59 | 59 | ||||||||||||||||||||||||||||||||||||||||||||||||||
337031 | 337031 | WI | Kenosha | school | 5513350 | 5068 | Public school | Salem | 551335001753 | 20 | Salem Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 116 | 116 | ||||||||||||||||||||||||||||||||||||||||||||||||||
337142 | 337142 | WI | Outagamie | school | 5513530 | 5138 | Public school | Seymour Community | 551353001769 | 20 | Black Creek Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 34 | 34 | ||||||||||||||||||||||||||||||||||||||||||||||||||
337171 | 337171 | WI | Walworth | school | 5513560 | 5258 | Public school | Sharon J11 | 551356001774 | 20 | Sharon Community | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 27 | 27 | ||||||||||||||||||||||||||||||||||||||||||||||||||
337406 | 337406 | WI | Outagamie | school | 5513770 | 5348 | Public school | Shiocton | 551377001807 | 20 | Shiocton Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 43 | 43 | ||||||||||||||||||||||||||||||||||||||||||||||||||
337473 | 337473 | WI | Kenosha | school | 5513860 | 5369 | Public school | Silver Lake J1 | 551386001815 | 20 | Riverview Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 54 | 54 | ||||||||||||||||||||||||||||||||||||||||||||||||||
337931 | 337931 | WI | Waukesha | school | 5509390 | 3542 | Public school | Stone Bank | 550939002270 | 20 | Stone Bank Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 36 | 36 | ||||||||||||||||||||||||||||||||||||||||||||||||||
338188 | 338188 | WI | Waukesha | school | 5509240 | 3510 | Public school | Swallow | 550924002267 | 20 | Swallow Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 79 | 79 | ||||||||||||||||||||||||||||||||||||||||||||||||||
338199 | 338199 | WI | Clark | school | 5514820 | 5726 | Public school | Thorp | 551482001925 | 20 | Thorp Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 42 | 42 | ||||||||||||||||||||||||||||||||||||||||||||||||||
338372 | 338372 | WI | Kenosha | school | 5500052 | 5780 | Public school | Trevor-Wilmot Consolidated | 550005202644 | 20 | Trevor-Wilmot Grade | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 42 | 42 | ||||||||||||||||||||||||||||||||||||||||||||||||||
338412 | 338412 | WI | Barron | school | 5515060 | 5810 | Public school | Turtle Lake | 551506001955 | 20 | Turtle Lake Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 31 | 31 | ||||||||||||||||||||||||||||||||||||||||||||||||||
338429 | 338429 | WI | Kenosha | school | 5515090 | 5817 | Public school | Twin Lakes #4 | 551509001957 | 20 | Lakewood Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 39 | 39 | ||||||||||||||||||||||||||||||||||||||||||||||||||
338481 | 338481 | WI | Racine | school | 5515180 | 5859 | Public school | Union Grove J1 | 551518001964 | 20 | Union Grove Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 100 | 100 | ||||||||||||||||||||||||||||||||||||||||||||||||||
338661 | 338661 | WI | Walworth | school | 5515450 | 6022 | Public school | Walworth J1 | 551545001981 | 20 | Walworth Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 62 | 62 | ||||||||||||||||||||||||||||||||||||||||||||||||||
338680 | 338680 | WI | Bayfield | school | 5515540 | 6027 | Public school | Washburn | 551554001984 | 20 | Washburn Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 46 | 46 | ||||||||||||||||||||||||||||||||||||||||||||||||||
338688 | 338688 | WI | Door | school | 5515570 | 6069 | Public school | Washington | 551557001986 | 20 | Washington Island Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 4 | 4 | ||||||||||||||||||||||||||||||||||||||||||||||||||
338704 | 338704 | WI | Racine | school | 5515700 | 6104 | Public school | Washington-Caldwell | 551570001993 | 20 | Washington Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 26 | 26 | ||||||||||||||||||||||||||||||||||||||||||||||||||
339794 | 339794 | WI | Kenosha | school | 5516560 | 6412 | Public school | Wheatland J1 | 551656002163 | 20 | Wheatland Center Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 67 | 67 | ||||||||||||||||||||||||||||||||||||||||||||||||||
339907 | 339907 | WI | Walworth | school | 5516680 | 6461 | Public school | Whitewater Unified | 551668002178 | 20 | Whitewater Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 150 | 150 | ||||||||||||||||||||||||||||||||||||||||||||||||||
340162 | 340162 | WI | Shawano | school | 5517100 | 6692 | Public school | Wittenberg-Birnamwood | 551710002218 | 20 | Birnamwood Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 42 | 42 | ||||||||||||||||||||||||||||||||||||||||||||||||||
340227 | 340227 | WI | Vilas | school | 5517160 | 6720 | Public school | Woodruff J1 | 551716002227 | 20 | Arbor Vitae-Woodruff Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 59 | 59 | ||||||||||||||||||||||||||||||||||||||||||||||||||
340257 | 340257 | WI | Racine | school | 5517220 | 6748 | Public school | Yorkville J2 | 551722002230 | 20 | Yorkville Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 62 | 62 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326858 | 326858 | WI | Shawano | school | 5501470 | 602 | Public school | Bonduel | 550147002383 | 21 | Bonduel Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 52 | 52 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326937 | 326937 | WI | Calumet | school | 5501680 | 658 | Public school | Brillion | 550168002384 | 21 | Brillion Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 70 | 70 | ||||||||||||||||||||||||||||||||||||||||||||||||||
327641 | 327641 | WI | Forest | school | 5502910 | 1218 | Public school | Crandon | 550291002388 | 22 | Crandon Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 54 | 54 | ||||||||||||||||||||||||||||||||||||||||||||||||||
327685 | 327685 | WI | Milwaukee | school | 5503060 | 1253 | Public school | Cudahy | 550306002389 | 22 | Cudahy Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 182 | 182 | ||||||||||||||||||||||||||||||||||||||||||||||||||
328297 | 328297 | WI | Marathon | school | 5504080 | 1561 | Public school | Edgar | 550408002391 | 23 | Edgar Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 46 | 46 | ||||||||||||||||||||||||||||||||||||||||||||||||||
328044 | 328044 | WI | Dodge | school | 5507260 | 2744 | Public school | Dodgeland | 550726002983 | 25 | Dodgeland Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 57 | 57 | ||||||||||||||||||||||||||||||||||||||||||||||||||
332001 | 332001 | WI | Green Lake | school | 5508760 | 3325 | Public school | Markesan | 550876002414 | 25 | Markesan Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 71 | 71 | ||||||||||||||||||||||||||||||||||||||||||||||||||
335574 | 335574 | WI | Trempealeau | school | 5511220 | 4186 | Public school | Osseo-Fairchild | 551122002398 | 26 | Osseo Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 75 | 75 | ||||||||||||||||||||||||||||||||||||||||||||||||||
337114 | 337114 | WI | Crawford | school | 5513470 | 5124 | Public school | Seneca Area | 551347002399 | 28 | Seneca Junior High | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 14 | 14 | ||||||||||||||||||||||||||||||||||||||||||||||||||
337464 | 337464 | WI | Lafayette | school | 5513830 | 5362 | Public school | Shullsburg | 551383002400 | 28 | Shullsburg Junior High | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 24 | 24 | ||||||||||||||||||||||||||||||||||||||||||||||||||
339840 | 339840 | WI | Milwaukee | school | 5516620 | 6419 | Public school | Whitefish Bay | 551662002402 | 29 | Whitefish Bay Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 240 | 240 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326174 | 326174 | WI | Ashland | school | 5500510 | 170 | Public school | Ashland | 550051000074 | 30 | Ashland Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 122 | 122 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326453 | 326453 | WI | Bayfield | school | 5500900 | 315 | Public school | Bayfield | 550090000082 | 30 | Bayfield Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 26 | 26 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
327903 | 327903 | WI | Brown | school | 5503210 | 1414 | Public school | De Pere | 550321000362 | 30 | De Pere Middle | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 317 | 317 | ||||||||||||||||||||||||||||||||||||||||||||||||||
328540 | 328540 | WI | Pierce | school | 5504350 | 1666 | Public school | Elmwood | 550435000347 | 30 | Elmwood Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 22 | 22 | ||||||||||||||||||||||||||||||||||||||||||||||||||
329968 | 329968 | WI | Outagamie | school | 5506600 | 2583 | Public school | Hortonville Area | 550660002408 | 30 | Hortonville Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 119 | 119 | ||||||||||||||||||||||||||||||||||||||||||||||||||
329991 | 329991 | WI | Brown | school | 5506630 | 2604 | Public school | Howard-Suamico | 550663000717 | 30 | Bay View Middle | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 455 | 455 | ||||||||||||||||||||||||||||||||||||||||||||||||||
331199 | 331199 | WI | Waukesha | school | 5500013 | 3862 | Public school | Lake Country | 550001300578 | 30 | Lake Country School | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 71 | 71 | ||||||||||||||||||||||||||||||||||||||||||||||||||
332571 | 332571 | WI | Dane | school | 5509510 | 3549 | Public school | Middleton-Cross Plains Area | 550951001104 | 30 | Kromrey Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 285 | 285 | ||||||||||||||||||||||||||||||||||||||||||||||||||
334331 | 334331 | WI | Green | school | 5509900 | 3696 | Public school | Monticello | 550990000384 | 30 | Monticello Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 24 | 24 |
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]);