enrollments
Data source: Big Local News · About: Big Local
667 rows where grade = "grade_7", state = "WI" and year = 2017 sorted by rowid descending
This data as json, CSV (advanced)
Link | rowid ▲ | state | county | county_state_id | admin_level | district_nces_id | district_state_id | district_state_type | district | school_nces_id | school_state_id | school | school_state_type | ccd_school_type | ccd_charter_school | ccd_school_lvl | ccd_school_low_grade | ccd_school_high_grade | year | term | grade | white | black | hispanic | native_american | native_american_alaskan_native | asian | native_hawaiian | asian_pacific_islander | native_hawaiian_pacific_islander | pacific_islander | multiracial | unknown_race | male | female | non_binary | unknown_gender | ell | ell_percent | homeless | homeless_percent | low_income | free_and_reduced | free_and_reduced_percent | disability | section_504 | total | white_int | black_int | hispanic_int | native_american_int | native_american_alaskan_native_int | asian_int | native_hawaiian_int | asian_pacific_islander_int | native_hawaiian_pacific_islander_int | pacific_islander_int | multiracial_int | unknown_race_int | male_int | female_int | non_binary_int | unknown_gender_int | ell_int | homeless_int | low_income_int | free_and_reduced_int | disability_int | section_504_int | total_int |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
340248 | 340248 | WI | Brown | school | 5517190 | 6734 | Public school | Wrightstown Community | 551719000280 | 30 | Wrightstown Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 88 | 88 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
340208 | 340208 | WI | Milwaukee | school | 5500113 | 8113 | Non District Charter Schools | Woodlands School | 550011303353 | 8728 | Woodlands School | charter | Regular School | Yes | Elementary | PK | 08 | 2017 | grade_7 | 35 | 35 | |||||||||||||||||||||||||||||||||||||||||||||||||
340199 | 340199 | WI | Juneau | school | 5517130 | 6713 | Public school | Wonewoc-Union Center | 551713002226 | 100 | Wonewoc-Center Junior High | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 23 | 23 | ||||||||||||||||||||||||||||||||||||||||||||||||||
340173 | 340173 | WI | Shawano | school | 5517100 | 6692 | Public school | Wittenberg-Birnamwood | 551710002223 | 120 | Wittenberg Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 49 | 49 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
340142 | 340142 | WI | Wood | school | 5517070 | 6685 | Public school | Wisconsin Rapids | 551707002216 | 290 | Wisconsin Rapids Area Middle | Regular School | No | Middle | 06 | 07 | 2017 | grade_7 | 360 | 360 | ||||||||||||||||||||||||||||||||||||||||||||||||||
340069 | 340069 | WI | Dane | school | 5501230 | 469 | Public school | Wisconsin Heights | 550123000609 | 80 | Wisconsin Heights Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 48 | 48 | ||||||||||||||||||||||||||||||||||||||||||||||||||
340045 | 340045 | WI | Sauk | school | 5517040 | 6678 | Public school | Wisconsin Dells | 551704002271 | 200 | Spring Hill Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 136 | 136 | ||||||||||||||||||||||||||||||||||||||||||||||||||
340017 | 340017 | WI | Sawyer | school | 5516860 | 6615 | Public school | Winter | 551686002315 | 100 | Winter Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 13 | 13 | ||||||||||||||||||||||||||||||||||||||||||||||||||
339999 | 339999 | WI | Winnebago | school | 5516830 | 6608 | Public school | Winneconne Community | 551683002192 | 80 | Winneconne Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 115 | 115 | ||||||||||||||||||||||||||||||||||||||||||||||||||
339976 | 339976 | WI | Walworth | school | 5516740 | 6482 | Public school | Williams Bay | 551674000277 | 30 | Williams Bay Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 55 | 55 | ||||||||||||||||||||||||||||||||||||||||||||||||||
339957 | 339957 | WI | Waushara | school | 5516710 | 6475 | Public school | Wild Rose | 551671002185 | 60 | Wild Rose High | Regular School | No | Other | 06 | 12 | 2017 | grade_7 | 49 | 49 | ||||||||||||||||||||||||||||||||||||||||||||||||||
339934 | 339934 | WI | Milwaukee | school | 5506000 | 6470 | Public school | Whitnall | 550600000662 | 120 | Whitnall Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 193 | 193 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
339867 | 339867 | WI | Walworth | school | 5516680 | 6461 | Public school | Whitewater Unified | 551668002901 | 9803 | JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive | charter | Alternative School | Yes | Other | PK | 12 | 2017 | grade_7 | 3 | 3 | |||||||||||||||||||||||||||||||||||||||||||||||||
339856 | 339856 | WI | Trempealeau | school | 5516650 | 6426 | Public school | Whitehall | 551665002176 | 120 | Whitehall Memorial Junior/Senior High | Regular School | No | High | 07 | 12 | 2017 | grade_7 | 64 | 64 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
339812 | 339812 | WI | Langlade | school | 5516590 | 6440 | Public school | White Lake | 551659002165 | 40 | White Lake High | Regular School | No | High | 07 | 12 | 2017 | grade_7 | 10 | 10 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
339785 | 339785 | WI | Waupaca | school | 5516500 | 6384 | Public school | Weyauwega-Fremont | 551650002160 | 120 | Weyauwega Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 58 | 58 | ||||||||||||||||||||||||||||||||||||||||||||||||||
339758 | 339758 | WI | Sauk | school | 5516470 | 6354 | Public school | Weston | 551647002156 | 120 | Weston Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 21 | 21 | ||||||||||||||||||||||||||||||||||||||||||||||||||
339731 | 339731 | WI | Marquette | school | 5516440 | 6335 | Public school | Westfield | 551644002535 | 200 | Westfield Area Middle | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 67 | 67 | ||||||||||||||||||||||||||||||||||||||||||||||||||
339704 | 339704 | WI | Vernon | school | 5516410 | 6321 | Public school | Westby Area | 551641001207 | 160 | Westby Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 79 | 79 | ||||||||||||||||||||||||||||||||||||||||||||||||||
339676 | 339676 | WI | La Crosse | school | 5516350 | 6370 | Public school | West Salem | 551635002324 | 100 | West Salem Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 130 | 130 | ||||||||||||||||||||||||||||||||||||||||||||||||||
339649 | 339649 | WI | Brown | school | 5516320 | 6328 | Public school | West De Pere | 551632000545 | 110 | West De Pere Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 250 | 250 | ||||||||||||||||||||||||||||||||||||||||||||||||||
339607 | 339607 | WI | Washington | school | 5516290 | 6307 | Public school | West Bend | 551629002953 | 430 | Pathways | charter | Regular School | Yes | High | 07 | 12 | 2017 | grade_7 | 8 | 8 | |||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
339555 | 339555 | WI | Milwaukee | school | 5516260 | 6300 | Public school | West Allis-West Milwaukee | 551626002106 | 120 | West Milwaukee Intermediate | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 136 | 136 | ||||||||||||||||||||||||||||||||||||||||||||||||||
339496 | 339496 | WI | Milwaukee | school | 5516260 | 6300 | Public school | West Allis-West Milwaukee | 551626002793 | 200 | Lincoln Intermediate | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 85 | 85 | ||||||||||||||||||||||||||||||||||||||||||||||||||
339492 | 339492 | WI | Milwaukee | school | 5516260 | 6300 | Public school | West Allis-West Milwaukee | 551626003004 | 220 | Lane Intermediate | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 194 | 194 | ||||||||||||||||||||||||||||||||||||||||||||||||||
339444 | 339444 | WI | Milwaukee | school | 5516260 | 6300 | Public school | West Allis-West Milwaukee | 551626002102 | 40 | Frank Lloyd Wright Intermediate | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 222 | 222 | ||||||||||||||||||||||||||||||||||||||||||||||||||
339435 | 339435 | WI | Burnett | school | 5516230 | 6293 | Public school | Webster | 551623002100 | 100 | Webster Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 38 | 38 | ||||||||||||||||||||||||||||||||||||||||||||||||||
339417 | 339417 | WI | Crawford | school | 5516020 | 6251 | Public school | Wauzeka-Steuben | 551602002738 | 250 | Wauzeka Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 25 | 25 | ||||||||||||||||||||||||||||||||||||||||||||||||||
339391 | 339391 | WI | Milwaukee | school | 5515990 | 6244 | Public school | Wauwatosa | 551599002092 | 290 | Whitman Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 266 | 266 | ||||||||||||||||||||||||||||||||||||||||||||||||||
339381 | 339381 | WI | Milwaukee | school | 5515990 | 6244 | Public school | Wauwatosa | 551599002921 | 430 | Wauwatosa Virtual Academy | charter | Regular School | Yes | Other | 06 | 12 | 2017 | grade_7 | 3 | 3 | |||||||||||||||||||||||||||||||||||||||||||||||||
339365 | 339365 | WI | Milwaukee | school | 5515990 | 6244 | Public school | Wauwatosa | 551599002884 | 110 | Wauwatosa Montessori School | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 7 | 7 | ||||||||||||||||||||||||||||||||||||||||||||||||||
339328 | 339328 | WI | Milwaukee | school | 5515990 | 6244 | Public school | Wauwatosa | 551599002349 | 190 | Plank Road Complex | Alternative School | No | Other | KG | 12 | 2017 | grade_7 | 4 | 4 | ||||||||||||||||||||||||||||||||||||||||||||||||||
339304 | 339304 | WI | Milwaukee | school | 5515990 | 6244 | Public school | Wauwatosa | 551599002083 | 140 | Longfellow Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 288 | 288 | ||||||||||||||||||||||||||||||||||||||||||||||||||
339250 | 339250 | WI | Waushara | school | 5515960 | 6237 | Public school | Wautoma Area | 551596002071 | 30 | Parkside School | Regular School | No | Elementary | 04 | 08 | 2017 | grade_7 | 100 | 100 | ||||||||||||||||||||||||||||||||||||||||||||||||||
339244 | 339244 | WI | Marinette | school | 5515930 | 6230 | Public school | Wausaukee | 551593002069 | 120 | Wausaukee Junior High | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 36 | 36 | ||||||||||||||||||||||||||||||||||||||||||||||||||
339216 | 339216 | WI | Marathon | school | 5515900 | 6223 | Public school | Wausau | 551590003027 | 800 | Wausau Area Virtual Education | Regular School | No | Other | 06 | 12 | 2017 | grade_7 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||
339150 | 339150 | WI | Marathon | school | 5515900 | 6223 | Public school | Wausau | 551590002054 | 200 | John Muir Middle | Regular School | No | Other | 06 | 09 | 2017 | grade_7 | 337 | 337 | ||||||||||||||||||||||||||||||||||||||||||||||||||
339139 | 339139 | WI | Marathon | school | 5515900 | 6223 | Public school | Wausau | 551590000544 | 205 | Horace Mann Middle | Regular School | No | Other | 06 | 10 | 2017 | grade_7 | 258 | 258 | ||||||||||||||||||||||||||||||||||||||||||||||||||
339095 | 339095 | WI | Marathon | school | 5515900 | 6223 | Public school | Wausau | 551590002747 | 400 | Enrich Excel Achieve Learning Academy | charter | Alternative School | Yes | Other | 06 | 12 | 2017 | grade_7 | 4 | 4 | |||||||||||||||||||||||||||||||||||||||||||||||||
339078 | 339078 | WI | Fond du Lac | school | 5515870 | 6216 | Public school | Waupun | 551587002808 | 300 | Waupun Area Junior High | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 125 | 125 | ||||||||||||||||||||||||||||||||||||||||||||||||||
339074 | 339074 | WI | Fond du Lac | school | 5515870 | 6216 | Public school | Waupun | 551587002903 | 150 | School for Agricultural and Environmental Studies | charter | Regular School | Yes | Elementary | PK | 08 | 2017 | grade_7 | 5 | 5 | |||||||||||||||||||||||||||||||||||||||||||||||||
339054 | 339054 | WI | Waupaca | school | 5515840 | 6195 | Public school | Waupaca | 551584002036 | 150 | Waupaca Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 156 | 156 | ||||||||||||||||||||||||||||||||||||||||||||||||||
339038 | 339038 | WI | Waupaca | school | 6195 | Public Schools-Multidistrict Charters | Waupaca | 9408 | Waupaca County Charter | charter | 2017 | grade_7 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
339023 | 339023 | WI | Dane | school | 5515810 | 6181 | Public school | Waunakee Community | 551581002031 | 60 | Waunakee Middle | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 328 | 328 | ||||||||||||||||||||||||||||||||||||||||||||||||||
338975 | 338975 | WI | Waukesha | school | 5515780 | 6174 | Public school | Waukesha | 551578002023 | 400 | Waukesha STEM Academy | charter | Regular School | Yes | Elementary | PK | 08 | 2017 | grade_7 | 111 | 111 | |||||||||||||||||||||||||||||||||||||||||||||||||
338898 | 338898 | WI | Waukesha | school | 5515780 | 6174 | Public school | Waukesha | 551578002009 | 120 | Les Paul Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 220 | 220 | ||||||||||||||||||||||||||||||||||||||||||||||||||
338894 | 338894 | WI | Waukesha | school | 5515780 | 6174 | Public school | Waukesha | 551578002015 | 210 | Horning Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 261 | 261 | ||||||||||||||||||||||||||||||||||||||||||||||||||
338847 | 338847 | WI | Waukesha | school | 5515780 | 6174 | Public school | Waukesha | 551578003380 | 470 | eAchieve Academy - Wisconsin | charter | Regular School | Yes | Other | 06 | 12 | 2017 | grade_7 | 56 | 56 | |||||||||||||||||||||||||||||||||||||||||||||||||
338840 | 338840 | WI | Waukesha | school | 5515780 | 6174 | Public school | Waukesha | 551578002008 | 100 | Butler Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 305 | 305 | ||||||||||||||||||||||||||||||||||||||||||||||||||
338787 | 338787 | WI | Jefferson | school | 5515750 | 6125 | Public school | Watertown Unified | 551575002000 | 90 | Riverside Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 280 | 280 | ||||||||||||||||||||||||||||||||||||||||||||||||||
338760 | 338760 | WI | Jefferson | school | 5515720 | 6118 | Public school | Waterloo | 551572001943 | 300 | Waterloo Middle | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 55 | 55 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
338651 | 338651 | WI | Forest | school | 5515390 | 5992 | Public school | Wabeno Area | 551539001979 | 80 | Wabeno High | Regular School | No | High | 07 | 12 | 2017 | grade_7 | 30 | 30 | ||||||||||||||||||||||||||||||||||||||||||||||||||
338635 | 338635 | WI | Vernon | school | 5515360 | 5985 | Public school | Viroqua Area | 551536001977 | 230 | Viroqua Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 86 | 86 | ||||||||||||||||||||||||||||||||||||||||||||||||||
338572 | 338572 | WI | Dane | school | 5515330 | 5901 | Public school | Verona Area | 551533001149 | 50 | Savanna Oaks Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 166 | 166 | ||||||||||||||||||||||||||||||||||||||||||||||||||
338539 | 338539 | WI | Dane | school | 5515330 | 5901 | Public school | Verona Area | 551533001153 | 70 | Core Knowledge Charter School | charter | Regular School | Yes | Elementary | KG | 08 | 2017 | grade_7 | 54 | 54 | |||||||||||||||||||||||||||||||||||||||||||||||||
338530 | 338530 | WI | Dane | school | 5515330 | 5901 | Public school | Verona Area | 551533001973 | 120 | Badger Ridge Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 176 | 176 | ||||||||||||||||||||||||||||||||||||||||||||||||||
338526 | 338526 | WI | Manitowoc | school | 5515210 | 5866 | Public school | Valders Area | 551521001968 | 80 | Valders Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 70 | 70 | ||||||||||||||||||||||||||||||||||||||||||||||||||
338508 | 338508 | WI | Polk | school | 5500750 | 238 | Public school | Unity | 550075000099 | 120 | Unity Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 67 | 67 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
338457 | 338457 | WI | Manitowoc | school | 5515120 | 5824 | Public school | Two Rivers Public | 551512003037 | 810 | Lighthouse Learning Academy | charter | Regular School | Yes | Other | PK | 12 | 2017 | grade_7 | 4 | 4 | |||||||||||||||||||||||||||||||||||||||||||||||||
338437 | 338437 | WI | Manitowoc | school | 5515120 | 5824 | Public school | Two Rivers Public | 551512001960 | 50 | Clarke Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 129 | 129 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
338393 | 338393 | WI | Waushara | school | 5511820 | 4375 | Public school | Tri-County Area | 551182002620 | 80 | Tri-County Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 54 | 54 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
338355 | 338355 | WI | Portage | school | 5500330 | 126 | Public school | Tomorrow River | 550033000034 | 80 | Amherst Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 74 | 74 | ||||||||||||||||||||||||||||||||||||||||||||||||||
338337 | 338337 | WI | Lincoln | school | 5514940 | 5754 | Public school | Tomahawk | 551494001948 | 220 | Tomahawk Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 103 | 103 | ||||||||||||||||||||||||||||||||||||||||||||||||||
338304 | 338304 | WI | Monroe | school | 5514910 | 5747 | Public school | Tomah Area | 551491001938 | 160 | Tomah Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 227 | 227 | ||||||||||||||||||||||||||||||||||||||||||||||||||
338249 | 338249 | WI | Shawano | school | 5514880 | 5740 | Public school | Tigerton | 551488001932 | 40 | Tigerton High | Regular School | No | Other | 06 | 12 | 2017 | grade_7 | 13 | 13 | ||||||||||||||||||||||||||||||||||||||||||||||||||
338233 | 338233 | WI | Oneida | school | 5514850 | 5733 | Public school | Three Lakes | 551485002954 | 300 | Three Lakes Junior High | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 42 | 42 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
338171 | 338171 | WI | Oconto | school | 5514700 | 5670 | Public school | Suring Public | 551470001921 | 60 | Suring Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 37 | 37 | ||||||||||||||||||||||||||||||||||||||||||||||||||
338162 | 338162 | WI | Douglas | school | 5514670 | 5663 | Public school | Superior | 551467001907 | 60 | Superior Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 328 | 328 | ||||||||||||||||||||||||||||||||||||||||||||||||||
338077 | 338077 | WI | Dane | school | 5514640 | 5656 | Public school | Sun Prairie Area | 551464001400 | 200 | Prairie View Middle | Regular School | No | Middle | 05 | 07 | 2017 | grade_7 | 259 | 259 | ||||||||||||||||||||||||||||||||||||||||||||||||||
338069 | 338069 | WI | Dane | school | 5514640 | 5656 | Public school | Sun Prairie Area | 551464001401 | 210 | Patrick Marsh Middle | Regular School | No | Middle | 05 | 07 | 2017 | grade_7 | 290 | 290 | ||||||||||||||||||||||||||||||||||||||||||||||||||
338016 | 338016 | WI | Door | school | 5514610 | 5642 | Public school | Sturgeon Bay | 551461002322 | 80 | Walker Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 90 | 90 | ||||||||||||||||||||||||||||||||||||||||||||||||||
337996 | 337996 | WI | Marathon | school | 5514580 | 5628 | Public school | Stratford | 551458002939 | 230 | Stratford Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 65 | 65 | ||||||||||||||||||||||||||||||||||||||||||||||||||
337959 | 337959 | WI | Dane | school | 5514550 | 5621 | Public school | Stoughton Area | 551455001887 | 120 | River Bluff Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 224 | 224 | ||||||||||||||||||||||||||||||||||||||||||||||||||
337946 | 337946 | WI | Dane | school | 5621 | Public Schools-Multidistrict Charters | Stoughton Area | 9803 | JEDI Virtual K-12 | charter | 2017 | grade_7 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
337922 | 337922 | WI | Calumet | school | 5514520 | 5614 | Public school | Stockbridge | 551452002499 | 200 | Stockbridge Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 6 | 6 | ||||||||||||||||||||||||||||||||||||||||||||||||||
337883 | 337883 | WI | Portage | school | 5514490 | 5607 | Public school | Stevens Point Area Public | 551449003019 | 290 | Point of Discovery School | charter | Regular School | Yes | Middle | 06 | 08 | 2017 | grade_7 | 44 | 44 | |||||||||||||||||||||||||||||||||||||||||||||||||
337868 | 337868 | WI | Portage | school | 5514490 | 5607 | Public school | Stevens Point Area Public | 551449001877 | 240 | P J Jacobs Junior High | Regular School | No | Other | 07 | 09 | 2017 | grade_7 | 203 | 203 | ||||||||||||||||||||||||||||||||||||||||||||||||||
337816 | 337816 | WI | Portage | school | 5514490 | 5607 | Public school | Stevens Point Area Public | 551449002210 | 360 | CARE Concerned About Reaching Everyone | charter | Alternative School | Yes | Other | 07 | 09 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
337797 | 337797 | WI | Chippewa | school | 5514430 | 5593 | Public school | Stanley-Boyd Area | 551443001866 | 100 | Stanley-Boyd Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 68 | 68 | ||||||||||||||||||||||||||||||||||||||||||||||||||
337778 | 337778 | WI | Pierce | school | 5514340 | 5586 | Public school | Spring Valley | 551434000511 | 70 | Spring Valley Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 70 | 70 |
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]);