enrollments
Data source: Big Local News · About: Big Local
680 rows where grade = "grade_7", state = "WI" and year = 2020 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2332922 | 2332922 | WI | Racine | school | 5517220 | 6748 | Public school | Yorkville J2 | 551722002230 | 20 | Yorkville Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 56 | 56 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332913 | 2332913 | WI | Brown | school | 5517190 | 6734 | Public school | Wrightstown Community | 551719000280 | 30 | Wrightstown Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 92 | 92 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332891 | 2332891 | WI | Vilas | school | 5517160 | 6720 | Public school | Woodruff J1 | 551716002227 | 20 | Arbor Vitae-Woodruff Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 55 | 55 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332880 | 2332880 | WI | Milwaukee | school | 5500070 | 8132 | Non District Charter Schools | Woodlands School - State Street Campus | 550007002942 | 100 | Woodlands School - State Street Campus | charter | Regular School | Yes | Elementary | PK | 08 | 2020 | grade_7 | 38 | 38 | |||||||||||||||||||||||||||||||||||||||||||||||||
2332869 | 2332869 | WI | Milwaukee | school | 5500113 | 8113 | Non District Charter Schools | Woodlands School | 550011303353 | 8728 | Woodlands School | charter | Regular School | Yes | Elementary | PK | 08 | 2020 | grade_7 | 33 | 33 | |||||||||||||||||||||||||||||||||||||||||||||||||
2332858 | 2332858 | WI | Juneau | school | 5517130 | 6713 | Public school | Wonewoc-Union Center | 551713002226 | 100 | Wonewoc-Center Junior High | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 26 | 26 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332832 | 2332832 | WI | Shawano | school | 5517100 | 6692 | Public school | Wittenberg-Birnamwood | 551710002223 | 120 | Wittenberg Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 45 | 45 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332821 | 2332821 | WI | Shawano | school | 5517100 | 6692 | Public school | Wittenberg-Birnamwood | 551710002218 | 20 | Birnamwood Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 44 | 44 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332800 | 2332800 | WI | Wood | school | 5517070 | 6685 | Public school | Wisconsin Rapids | 551707002216 | 290 | Wisconsin Rapids Area Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 363 | 363 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332736 | 2332736 | WI | Wood | school | 5517070 | 6685 | Public school | Wisconsin Rapids | 551707003088 | 190 | Central Oaks Academy | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 14 | 14 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332727 | 2332727 | WI | Dane | school | 5501230 | 469 | Public school | Wisconsin Heights | 550123000609 | 80 | Wisconsin Heights Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 51 | 51 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332703 | 2332703 | WI | Sauk | school | 5517040 | 6678 | Public school | Wisconsin Dells | 551704002271 | 200 | Spring Hill Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 130 | 130 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332675 | 2332675 | WI | Sawyer | school | 5516860 | 6615 | Public school | Winter | 551686002315 | 100 | Winter Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 21 | 21 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332658 | 2332658 | WI | Winnebago | school | 5516830 | 6608 | Public school | Winneconne Community | 551683002192 | 80 | Winneconne Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 123 | 123 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332635 | 2332635 | WI | Walworth | school | 5516740 | 6482 | Public school | Williams Bay | 551674000277 | 30 | Williams Bay Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 49 | 49 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332615 | 2332615 | WI | Waushara | school | 5516710 | 6475 | Public school | Wild Rose | 551671002185 | 60 | Wild Rose High | Regular School | No | High | 06 | 12 | 2020 | grade_7 | 51 | 51 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332599 | 2332599 | WI | Milwaukee | school | 5506000 | 6470 | Public school | Whitnall | 550600000662 | 120 | Whitnall Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 196 | 196 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332572 | 2332572 | WI | Walworth | school | 5516680 | 6461 | Public school | Whitewater Unified | 551668002178 | 20 | Whitewater Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 140 | 140 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332534 | 2332534 | WI | Walworth | school | 6461 | Public Schools-Multidistrict Charters | Whitewater Unified | 9803 | JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive | charter | 2020 | grade_7 | 2 | 2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2332528 | 2332528 | WI | Trempealeau | school | 5516650 | 6426 | Public school | Whitehall | 551665002176 | 120 | Whitehall Memorial Junior/Senior High | Regular School | No | High | 07 | 12 | 2020 | grade_7 | 54 | 54 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332512 | 2332512 | WI | Milwaukee | school | 5516620 | 6419 | Public school | Whitefish Bay | 551662002402 | 29 | Whitefish Bay Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 202 | 202 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332485 | 2332485 | WI | Langlade | school | 5516590 | 6440 | Public school | White Lake | 551659003108 | 250 | White Lake Middle | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 7 | 7 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332461 | 2332461 | WI | Kenosha | school | 5516560 | 6412 | Public school | Wheatland J1 | 551656002163 | 20 | Wheatland Center Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 54 | 54 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332452 | 2332452 | WI | Waupaca | school | 5516500 | 6384 | Public school | Weyauwega-Fremont | 551650002160 | 120 | Weyauwega Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 64 | 64 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332427 | 2332427 | WI | Sauk | school | 5516470 | 6354 | Public school | Weston | 551647002156 | 120 | Weston Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 21 | 21 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332400 | 2332400 | WI | Marquette | school | 5516440 | 6335 | Public school | Westfield | 551644002535 | 200 | Westfield Area Middle | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 88 | 88 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332373 | 2332373 | WI | Vernon | school | 5516410 | 6321 | Public school | Westby Area | 551641001207 | 160 | Westby Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 80 | 80 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332344 | 2332344 | WI | La Crosse | school | 5516350 | 6370 | Public school | West Salem | 551635002324 | 100 | West Salem Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 161 | 161 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332317 | 2332317 | WI | Brown | school | 5516320 | 6328 | Public school | West De Pere | 551632000545 | 110 | West De Pere Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 264 | 264 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332243 | 2332243 | WI | Washington | school | 5516290 | 6307 | Public school | West Bend | 551629002125 | 10 | Badger Middle | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 475 | 475 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332231 | 2332231 | WI | Milwaukee | school | 5516260 | 6300 | Public school | West Allis-West Milwaukee | 551626002106 | 120 | West Milwaukee Intermediate | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 124 | 124 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332175 | 2332175 | WI | Milwaukee | school | 5516260 | 6300 | Public school | West Allis-West Milwaukee | 551626003004 | 220 | Lane Intermediate | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 156 | 156 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332123 | 2332123 | WI | Milwaukee | school | 5516260 | 6300 | Public school | West Allis-West Milwaukee | 551626002102 | 40 | Frank Lloyd Wright Intermediate | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 311 | 311 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332114 | 2332114 | WI | Burnett | school | 5516230 | 6293 | Public school | Webster | 551623002100 | 100 | Webster Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 56 | 56 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332096 | 2332096 | WI | Crawford | school | 5516020 | 6251 | Public school | Wauzeka-Steuben | 551602002738 | 250 | Wauzeka Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 13 | 13 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332070 | 2332070 | WI | Milwaukee | school | 5515990 | 6244 | Public school | Wauwatosa | 551599002092 | 290 | Whitman Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 235 | 235 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332060 | 2332060 | WI | Milwaukee | school | 5515990 | 6244 | Public school | Wauwatosa | 551599002921 | 430 | Wauwatosa Virtual Academy | charter | Regular School | Yes | High | 06 | 12 | 2020 | grade_7 | 6 | 6 | |||||||||||||||||||||||||||||||||||||||||||||||||
2332044 | 2332044 | WI | Milwaukee | school | 5515990 | 6244 | Public school | Wauwatosa | 551599002884 | 110 | Wauwatosa Montessori School | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 15 | 15 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331988 | 2331988 | WI | Milwaukee | school | 5515990 | 6244 | Public school | Wauwatosa | 551599002083 | 140 | Longfellow Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 266 | 266 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331933 | 2331933 | WI | Waushara | school | 5515960 | 6237 | Public school | Wautoma Area | 551596002071 | 30 | Parkside School | Regular School | No | Middle | 04 | 08 | 2020 | grade_7 | 105 | 105 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331927 | 2331927 | WI | Marinette | school | 5515930 | 6230 | Public school | Wausaukee | 551593002069 | 120 | Wausaukee Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 31 | 31 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331841 | 2331841 | WI | Marathon | school | 5515900 | 6223 | Public school | Wausau | 551590002054 | 200 | John Muir Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 379 | 379 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331830 | 2331830 | WI | Marathon | school | 5515900 | 6223 | Public school | Wausau | 551590000544 | 205 | Horace Mann Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 238 | 238 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331786 | 2331786 | WI | Marathon | school | 5515900 | 6223 | Public school | Wausau | 551590002747 | 400 | Enrich Excel Achieve Learning Academy | charter | Alternative School | Yes | High | 06 | 12 | 2020 | grade_7 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
2331770 | 2331770 | WI | Fond du Lac | school | 5515870 | 6216 | Public school | Waupun | 551587002808 | 300 | Waupun Area Junior High | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 157 | 157 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331747 | 2331747 | WI | Waupaca | school | 5515840 | 6195 | Public school | Waupaca | 551584002036 | 150 | Waupaca Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 164 | 164 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331713 | 2331713 | WI | Dane | school | 5515810 | 6181 | Public school | Waunakee Community | 551581002031 | 60 | Waunakee Middle | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 304 | 304 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331676 | 2331676 | WI | Waukesha | school | 5515780 | 6174 | Public school | Waukesha | 551578002027 | 520 | White Rock School | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 5 | 5 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331656 | 2331656 | WI | Waukesha | school | 5515780 | 6174 | Public school | Waukesha | 551578002023 | 400 | Waukesha STEM Academy | charter | Regular School | Yes | Elementary | PK | 08 | 2020 | grade_7 | 116 | 116 | |||||||||||||||||||||||||||||||||||||||||||||||||
2331642 | 2331642 | WI | Waukesha | school | 5515780 | 6174 | Public school | Waukesha | 551578002502 | 490 | Waukesha East Alternative School | charter | Alternative School | Yes | High | 06 | 12 | 2020 | grade_7 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
2331575 | 2331575 | WI | Waukesha | school | 5515780 | 6174 | Public school | Waukesha | 551578002009 | 120 | Les Paul Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 202 | 202 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331571 | 2331571 | WI | Waukesha | school | 5515780 | 6174 | Public school | Waukesha | 551578002015 | 210 | Horning Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 207 | 207 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331523 | 2331523 | WI | Waukesha | school | 5515780 | 6174 | Public school | Waukesha | 551578003380 | 470 | eAchieve Academy - Wisconsin | charter | Regular School | Yes | High | 06 | 12 | 2020 | grade_7 | 55 | 55 | |||||||||||||||||||||||||||||||||||||||||||||||||
2331516 | 2331516 | WI | Waukesha | school | 5515780 | 6174 | Public school | Waukesha | 551578002008 | 100 | Butler Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 310 | 310 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331472 | 2331472 | WI | Jefferson | school | 5515750 | 6125 | Public school | Watertown Unified | 551575002000 | 90 | Riverside Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 257 | 257 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331441 | 2331441 | WI | Jefferson | school | 5515720 | 6118 | Public school | Waterloo | 551572001943 | 300 | Waterloo Middle | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 53 | 53 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331422 | 2331422 | WI | Jefferson | school | 6118 | Public Schools-Multidistrict Charters | Waterloo | 9803 | JEDI Virtual K-12 | charter | 2020 | grade_7 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2331395 | 2331395 | WI | Racine | school | 5515660 | 6113 | Public school | Waterford Graded J1 | 551566001989 | 10 | Fox River Middle | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 164 | 164 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331380 | 2331380 | WI | Racine | school | 5515700 | 6104 | Public school | Washington-Caldwell | 551570001993 | 20 | Washington Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 10 | 10 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331365 | 2331365 | WI | Door | school | 5515570 | 6069 | Public school | Washington | 551557001986 | 20 | Washington Island Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 7 | 7 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331356 | 2331356 | WI | Bayfield | school | 5515540 | 6027 | Public school | Washburn | 551554001984 | 20 | Washburn Middle | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 42 | 42 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331336 | 2331336 | WI | Walworth | school | 5515450 | 6022 | Public school | Walworth J1 | 551545001981 | 20 | Walworth Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 56 | 56 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331326 | 2331326 | WI | Forest | school | 5515390 | 5992 | Public school | Wabeno Area | 551539001979 | 80 | Wabeno High | Regular School | No | High | 07 | 12 | 2020 | grade_7 | 32 | 32 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331311 | 2331311 | WI | Vernon | school | 5515360 | 5985 | Public school | Viroqua Area | 551536001977 | 230 | Viroqua Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 89 | 89 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331280 | 2331280 | WI | Vernon | school | 5515360 | 5985 | Public school | Viroqua Area | 551536003122 | 240 | Trillium Middle | charter | Regular School | Yes | Middle | 07 | 08 | 2020 | grade_7 | 9 | 9 | |||||||||||||||||||||||||||||||||||||||||||||||||
2331244 | 2331244 | WI | Dane | school | 5515330 | 5901 | Public school | Verona Area | 551533001149 | 50 | Savanna Oaks Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 196 | 196 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331213 | 2331213 | WI | Dane | school | 5515330 | 5901 | Public school | Verona Area | 551533001153 | 70 | Core Knowledge Charter School | charter | Regular School | Yes | Elementary | KG | 08 | 2020 | grade_7 | 53 | 53 | |||||||||||||||||||||||||||||||||||||||||||||||||
2331204 | 2331204 | WI | Dane | school | 5515330 | 5901 | Public school | Verona Area | 551533001973 | 120 | Badger Ridge Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 152 | 152 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331200 | 2331200 | WI | Manitowoc | school | 5515210 | 5866 | Public school | Valders Area | 551521001968 | 80 | Valders Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 75 | 75 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331182 | 2331182 | WI | Polk | school | 5500750 | 238 | Public school | Unity | 550075000099 | 120 | Unity Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 70 | 70 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331164 | 2331164 | WI | Milwaukee | school | 5500077 | 8137 | Non District Charter Schools | United Community Center Acosta Middle | 550007703047 | 8137 | United Community Center Acosta Middle School | charter | Regular School | Yes | Middle | 06 | 08 | 2020 | grade_7 | 56 | 56 | |||||||||||||||||||||||||||||||||||||||||||||||||
2331152 | 2331152 | WI | Racine | school | 5515180 | 5859 | Public school | Union Grove J1 | 551518001964 | 20 | Union Grove Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 88 | 88 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331128 | 2331128 | WI | Manitowoc | school | 5515120 | 5824 | Public school | Two Rivers Public | 551512003037 | 810 | Lighthouse Learning Academy | charter | Regular School | Yes | Other | PK | 12 | 2020 | grade_7 | 5 | 5 | |||||||||||||||||||||||||||||||||||||||||||||||||
2331108 | 2331108 | WI | Manitowoc | school | 5515120 | 5824 | Public school | Two Rivers Public | 551512001960 | 50 | Clarke Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 121 | 121 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331100 | 2331100 | WI | Kenosha | school | 5515090 | 5817 | Public school | Twin Lakes #4 | 551509001957 | 20 | Lakewood Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 26 | 26 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331091 | 2331091 | WI | Barron | school | 5515060 | 5810 | Public school | Turtle Lake | 551506003068 | 30 | Turtle Lake Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 30 | 30 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331068 | 2331068 | WI | Waushara | school | 5511820 | 4375 | Public school | Tri-County Area | 551182002620 | 80 | Tri-County Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 48 | 48 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331047 | 2331047 | WI | Kenosha | school | 5500052 | 5780 | Public school | Trevor-Wilmot Consolidated | 550005202644 | 20 | Trevor-Wilmot Grade | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 67 | 67 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331019 | 2331019 | WI | Portage | school | 5500330 | 126 | Public school | Tomorrow River | 550033000034 | 80 | Amherst Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 93 | 93 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331001 | 2331001 | WI | Lincoln | school | 5514940 | 5754 | Public school | Tomahawk | 551494001948 | 220 | Tomahawk Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 91 | 91 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2330968 | 2330968 | WI | Monroe | school | 5514910 | 5747 | Public school | Tomah Area | 551491001938 | 160 | Tomah Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 236 | 236 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2330948 | 2330948 | WI | Monroe | school | 5747 | Public Schools-Multidistrict Charters | Tomah Area | 9100 | Rural Virtual Academy | charter | 2020 | grade_7 | 5 | 5 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2330898 | 2330898 | WI | Shawano | school | 5514880 | 5740 | Public school | Tigerton | 551488001932 | 40 | Tigerton High | Regular School | No | High | 06 | 12 | 2020 | grade_7 | 24 | 24 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2330882 | 2330882 | WI | Oneida | school | 5514850 | 5733 | Public school | Three Lakes | 551485002954 | 300 | Three Lakes Junior High | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 39 | 39 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2330847 | 2330847 | WI | Clark | school | 5514820 | 5726 | Public school | Thorp | 551482001925 | 20 | Thorp Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 42 | 42 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2330828 | 2330828 | WI | Waukesha | school | 5509240 | 3510 | Public school | Swallow | 550924002267 | 20 | Swallow Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 65 | 65 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2330811 | 2330811 | WI | Oconto | school | 5514700 | 5670 | Public school | Suring Public | 551470001921 | 60 | Suring Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 34 | 34 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2330802 | 2330802 | WI | Douglas | school | 5514670 | 5663 | Public school | Superior | 551467001907 | 60 | Superior Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 309 | 309 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2330708 | 2330708 | WI | Dane | school | 5514640 | 5656 | Public school | Sun Prairie Area | 551464001400 | 200 | Prairie View Middle | Regular School | No | Middle | 06 | 07 | 2020 | grade_7 | 279 | 279 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2330701 | 2330701 | WI | Dane | school | 5514640 | 5656 | Public school | Sun Prairie Area | 551464001401 | 210 | Patrick Marsh Middle | Regular School | No | Middle | 06 | 07 | 2020 | grade_7 | 335 | 335 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2330680 | 2330680 | WI | Dane | school | 5656 | Public Schools-Multidistrict Charters | Sun Prairie Area | 9803 | JEDI Virtual K-12 | charter | 2020 | grade_7 | 4 | 4 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2330637 | 2330637 | WI | Door | school | 5514610 | 5642 | Public school | Sturgeon Bay | 551461002322 | 80 | Walker Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 86 | 86 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2330617 | 2330617 | WI | Marathon | school | 5514580 | 5628 | Public school | Stratford | 551458002939 | 230 | Stratford Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 60 | 60 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2330597 | 2330597 | WI | Marathon | school | 5628 | Public Schools-Multidistrict Charters | Stratford | 9100 | Rural Virtual Academy | charter | 2020 | grade_7 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2330577 | 2330577 | WI | Dane | school | 5514550 | 5621 | Public school | Stoughton Area | 551455001887 | 120 | River Bluff Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 207 | 207 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2330565 | 2330565 | WI | Dane | school | 5621 | Public Schools-Multidistrict Charters | Stoughton Area | 9803 | JEDI Virtual K-12 | charter | 2020 | grade_7 | 3 | 3 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2330547 | 2330547 | WI | Waukesha | school | 5509390 | 3542 | Public school | Stone Bank | 550939002270 | 20 | Stone Bank Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 40 | 40 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2330538 | 2330538 | WI | Calumet | school | 5514520 | 5614 | Public school | Stockbridge | 551452002499 | 200 | Stockbridge Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 20 | 20 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2330498 | 2330498 | WI | Portage | school | 5514490 | 5607 | Public school | Stevens Point Area Public | 551449003019 | 290 | Point of Discovery School | charter | Regular School | Yes | Middle | 06 | 09 | 2020 | grade_7 | 21 | 21 | |||||||||||||||||||||||||||||||||||||||||||||||||
2330483 | 2330483 | WI | Portage | school | 5514490 | 5607 | Public school | Stevens Point Area Public | 551449001877 | 240 | P J Jacobs Junior High | Regular School | No | Middle | 07 | 09 | 2020 | grade_7 | 208 | 208 |
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]);