enrollments
Data source: Big Local News · About: Big Local
666 rows where grade = "grade_7", state = "WI" and year = 2016 sorted by ccd_school_low_grade
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
281941 | 281941 | WI | Langlade | school | 140 | Public Schools-Multidistrict Charters | Antigo Unified | 9100 | Rural Virtual Academy | charter | 2016 | grade_7 | 3 | 3 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
284915 | 284915 | WI | Jefferson | school | 1883 | Public Schools-Multidistrict Charters | Fort Atkinson | 9803 | JEDI Virtual K-12 | charter | 2016 | grade_7 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
286285 | 286285 | WI | Waupaca | school | 2639 | Public Schools-Multidistrict Charters | Iola-Scandinavia | 9408 | Waupaca County Charter | charter | 2016 | grade_7 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
286488 | 286488 | WI | Jefferson | school | 2702 | Public Schools-Multidistrict Charters | Jefferson | 9803 | JEDI Virtual K-12 | charter | 2016 | grade_7 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
290483 | 290483 | WI | Marathon | school | 3787 | Public Schools-Multidistrict Charters | Mosinee | 9100 | Rural Virtual Academy | charter | 2016 | grade_7 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
293203 | 293203 | WI | Milwaukee | school | 8121 | Non District Charter Schools | Seeds of Health Elementary Program | 100 | Seeds of Health Elementary Program | charter | 2016 | grade_7 | 44 | 44 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
294043 | 294043 | WI | Dane | school | 5621 | Public Schools-Multidistrict Charters | Stoughton Area | 9803 | JEDI Virtual K-12 | charter | 2016 | grade_7 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
294155 | 294155 | WI | Dane | school | 5656 | Public Schools-Multidistrict Charters | Sun Prairie Area | 9803 | JEDI Virtual K-12 | charter | 2016 | grade_7 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
282064 | 282064 | WI | Outagamie | school | 5500390 | 147 | Public school | Appleton Area | 550039002582 | 135 | Fox River Academy | charter | Regular School | Yes | 1.0 | 01 | 08 | 2016 | grade_7 | 5 | 5 | |||||||||||||||||||||||||||||||||||||||||||||||||
290016 | 290016 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002442 | 312 | Starms Discovery | Regular School | No | 1.0 | 01 | 08 | 2016 | grade_7 | 44 | 44 | ||||||||||||||||||||||||||||||||||||||||||||||||||
284608 | 284608 | WI | Waukesha | school | 5501770 | 714 | Public school | Elmbrook | 550177000221 | 160 | Fairview South | Special Education School | No | 4.0 | 02 | 12 | 2016 | grade_7 | 2 | 2 | ||||||||||||||||||||||||||||||||||||||||||||||||||
282160 | 282160 | WI | Outagamie | school | 5500390 | 147 | Public school | Appleton Area | 550039002277 | 210 | Odyssey-Magellan | charter | Regular School | Yes | 1.0 | 03 | 08 | 2016 | grade_7 | 28 | 28 | |||||||||||||||||||||||||||||||||||||||||||||||||
288060 | 288060 | WI | Milwaukee | school | 5504770 | 1897 | Public school | Maple Dale-Indian Hill | 550477000516 | 40 | Maple Dale Elementary | Regular School | No | 1.0 | 03 | 08 | 2016 | grade_7 | 51 | 51 | ||||||||||||||||||||||||||||||||||||||||||||||||||
288272 | 288272 | WI | Dodge | school | 5508880 | 3367 | Public school | Mayville | 550888001029 | 60 | Mayville Middle | Regular School | No | 1.0 | 03 | 08 | 2016 | grade_7 | 86 | 86 | ||||||||||||||||||||||||||||||||||||||||||||||||||
289668 | 289668 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001164 | 176 | Meir School | Regular School | No | 4.0 | 03 | 10 | 2016 | grade_7 | 135 | 135 | ||||||||||||||||||||||||||||||||||||||||||||||||||
292771 | 292771 | WI | Washington | school | 5512900 | 4820 | Public school | Richfield J1 | 551290001703 | 20 | Richfield Elementary | Regular School | No | 1.0 | 03 | 08 | 2016 | grade_7 | 49 | 49 | ||||||||||||||||||||||||||||||||||||||||||||||||||
282675 | 282675 | WI | Rock | school | 5501050 | 413 | Public school | Beloit | 550105000137 | 20 | Aldrich Intermediate | Regular School | No | 2.0 | 04 | 08 | 2016 | grade_7 | 102 | 102 | ||||||||||||||||||||||||||||||||||||||||||||||||||
282707 | 282707 | WI | Rock | school | 5501050 | 413 | Public school | Beloit | 550105000140 | 80 | Cunningham Intermediate | Regular School | No | 2.0 | 04 | 08 | 2016 | grade_7 | 123 | 123 | ||||||||||||||||||||||||||||||||||||||||||||||||||
282713 | 282713 | WI | Rock | school | 5501050 | 413 | Public school | Beloit | 550105003011 | 170 | Fran Fruzen Intermediate School | Regular School | No | 2.0 | 04 | 08 | 2016 | grade_7 | 120 | 120 | ||||||||||||||||||||||||||||||||||||||||||||||||||
282732 | 282732 | WI | Rock | school | 5501050 | 413 | Public school | Beloit | 550105002330 | 180 | McNeel Intermediate | Regular School | No | 2.0 | 04 | 08 | 2016 | grade_7 | 146 | 146 | ||||||||||||||||||||||||||||||||||||||||||||||||||
283698 | 283698 | WI | Columbia | school | 5502820 | 1183 | Public school | Columbus | 550282000319 | 20 | Columbus Middle | Regular School | No | 2.0 | 04 | 08 | 2016 | grade_7 | 84 | 84 | ||||||||||||||||||||||||||||||||||||||||||||||||||
285111 | 285111 | WI | Walworth | school | 5505130 | 2051 | Public school | Genoa City J2 | 550513002327 | 200 | Brookwood Middle | Regular School | No | 2.0 | 04 | 08 | 2016 | grade_7 | 57 | 57 | ||||||||||||||||||||||||||||||||||||||||||||||||||
285236 | 285236 | WI | Milwaukee | school | 5505460 | 2184 | Public school | Glendale-River Hills | 550546000575 | 10 | Glen Hills Middle | Regular School | No | 2.0 | 04 | 08 | 2016 | grade_7 | 118 | 118 | ||||||||||||||||||||||||||||||||||||||||||||||||||
285347 | 285347 | WI | Burnett | school | 5505670 | 2233 | Public school | Grantsburg | 550567000603 | 100 | Grantsburg Middle | Regular School | No | 2.0 | 04 | 08 | 2016 | grade_7 | 52 | 52 | ||||||||||||||||||||||||||||||||||||||||||||||||||
287817 | 287817 | WI | Dane | school | 5508520 | 3269 | Public school | Madison Metropolitan | 550852002670 | 820 | Metro School | Alternative Education School | No | 4.0 | 04 | 12 | 2016 | grade_7 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||
290475 | 290475 | WI | Marathon | school | 5509960 | 3787 | Public school | Mosinee | 550996001309 | 120 | Mosinee Middle | Regular School | No | 2.0 | 04 | 08 | 2016 | grade_7 | 155 | 155 | ||||||||||||||||||||||||||||||||||||||||||||||||||
290747 | 290747 | WI | Wood | school | 5510380 | 3906 | Public school | Nekoosa | 551038001358 | 20 | Alexander Middle | Regular School | No | 2.0 | 04 | 08 | 2016 | grade_7 | 59 | 59 | ||||||||||||||||||||||||||||||||||||||||||||||||||
290753 | 290753 | WI | Wood | school | 5510380 | 3906 | Public school | Nekoosa | 551038002957 | 100 | Central Wisconsin STEM Academy | charter | Regular School | Yes | 2.0 | 04 | 08 | 2016 | grade_7 | 23 | 23 | |||||||||||||||||||||||||||||||||||||||||||||||||
290771 | 290771 | WI | Wood | school | 5510380 | 3906 | Public school | Nekoosa | 551038002715 | 200 | Niikuusra Community School | charter | Alternative Education School | Yes | 2.0 | 04 | 08 | 2016 | grade_7 | 4 | 4 | |||||||||||||||||||||||||||||||||||||||||||||||||
291184 | 291184 | WI | Washburn | school | 5509720 | 3654 | Public school | Northwood | 550972002877 | 200 | NorthStar Community Charter School | charter | Regular School | Yes | 2.0 | 04 | 08 | 2016 | grade_7 | 6 | 6 | |||||||||||||||||||||||||||||||||||||||||||||||||
291546 | 291546 | WI | Winnebago | school | 5511190 | 4179 | Public school | Oshkosh Area | 551119003364 | 170 | Accelerated Advanced Learning Program | charter | Regular School | Yes | 2.0 | 04 | 08 | 2016 | grade_7 | 11 | 11 | |||||||||||||||||||||||||||||||||||||||||||||||||
291932 | 291932 | WI | Grant | school | 5511850 | 4389 | Public school | Platteville | 551185001554 | 80 | Platteville Middle | Regular School | No | 2.0 | 04 | 08 | 2016 | grade_7 | 110 | 110 | ||||||||||||||||||||||||||||||||||||||||||||||||||
293024 | 293024 | WI | Fond du Lac | school | 5513100 | 4956 | Public school | Rosendale-Brandon | 551310001731 | 80 | Rosendale Intermediate | Regular School | No | 2.0 | 04 | 08 | 2016 | grade_7 | 42 | 42 | ||||||||||||||||||||||||||||||||||||||||||||||||||
293130 | 293130 | WI | Milwaukee | school | 5513260 | 5026 | Public school | Saint Francis | 551326001747 | 20 | Deer Creek Intermediate School | Regular School | No | 2.0 | 04 | 08 | 2016 | grade_7 | 72 | 72 | ||||||||||||||||||||||||||||||||||||||||||||||||||
295324 | 295324 | WI | Waushara | school | 5515960 | 6237 | Public school | Wautoma Area | 551596002071 | 30 | Parkside School | Regular School | No | 2.0 | 04 | 08 | 2016 | grade_7 | 94 | 94 | ||||||||||||||||||||||||||||||||||||||||||||||||||
281768 | 281768 | WI | Green | school | 5500120 | 63 | Public school | Albany | 550012002357 | 60 | Albany Community Middle | charter | Regular School | Yes | 2.0 | 05 | 08 | 2016 | grade_7 | 15 | 15 | |||||||||||||||||||||||||||||||||||||||||||||||||
282401 | 282401 | WI | Saint Croix | school | 5500720 | 231 | Public school | Baldwin-Woodville Area | 550072000096 | 90 | Viking Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 117 | 117 | ||||||||||||||||||||||||||||||||||||||||||||||||||
282530 | 282530 | WI | Barron | school | 5500870 | 308 | Public school | Barron Area | 550087000118 | 140 | Riverview Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 97 | 97 | ||||||||||||||||||||||||||||||||||||||||||||||||||
282941 | 282941 | WI | Chippewa | school | 5501350 | 497 | Public school | Bloomer | 550135000185 | 60 | Bloomer Middle School | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 84 | 84 | ||||||||||||||||||||||||||||||||||||||||||||||||||
283261 | 283261 | WI | Barron | school | 5502130 | 903 | Public school | Cameron | 550213002286 | 200 | Cameron Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 66 | 66 | ||||||||||||||||||||||||||||||||||||||||||||||||||
283353 | 283353 | WI | Sheboygan | school | 5502430 | 1029 | Public school | Cedar Grove-Belgium Area | 550243001629 | 200 | Cedar Grove-Belgium Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 77 | 77 | ||||||||||||||||||||||||||||||||||||||||||||||||||
283477 | 283477 | WI | Calumet | school | 5502520 | 1085 | Public school | Chilton | 550252002430 | 30 | Chilton Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 85 | 85 | ||||||||||||||||||||||||||||||||||||||||||||||||||
283585 | 283585 | WI | Rock | school | 5502640 | 1134 | Public school | Clinton Community | 550264000297 | 80 | Clinton Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 86 | 86 | ||||||||||||||||||||||||||||||||||||||||||||||||||
283595 | 283595 | WI | Waupaca | school | 5502670 | 1141 | Public school | Clintonville | 550267000301 | 20 | Clintonville Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 86 | 86 | ||||||||||||||||||||||||||||||||||||||||||||||||||
283637 | 283637 | WI | Clark | school | 5502730 | 1162 | Public school | Colby | 550273001226 | 210 | Colby Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 70 | 70 | ||||||||||||||||||||||||||||||||||||||||||||||||||
283844 | 283844 | WI | Barron | school | 5503090 | 1260 | Public school | Cumberland | 550309000304 | 50 | Cumberland Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 76 | 76 | ||||||||||||||||||||||||||||||||||||||||||||||||||
283954 | 283954 | WI | Dane | school | 5503180 | 1316 | Public school | De Forest Area | 550318000356 | 50 | De Forest Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 248 | 248 | ||||||||||||||||||||||||||||||||||||||||||||||||||
284466 | 284466 | WI | Dunn | school | 5504230 | 1645 | Public school | Elk Mound Area | 550423000452 | 20 | Elk Mound Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 103 | 103 | ||||||||||||||||||||||||||||||||||||||||||||||||||
284555 | 284555 | WI | Pierce | school | 5504320 | 1659 | Public school | Ellsworth Community | 550432000463 | 20 | Ellsworth Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 121 | 121 | ||||||||||||||||||||||||||||||||||||||||||||||||||
284943 | 284943 | WI | Milwaukee | school | 5504800 | 1890 | Public school | Fox Point J2 | 550480000517 | 20 | Bayside Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 99 | 99 | ||||||||||||||||||||||||||||||||||||||||||||||||||
285230 | 285230 | WI | Buffalo | school | 5505370 | 2142 | Public school | Gilmanton | 550537002907 | 250 | Gilmanton Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 16 | 16 | ||||||||||||||||||||||||||||||||||||||||||||||||||
285976 | 285976 | WI | Calumet | school | 5506450 | 2534 | Public school | Hilbert | 550645001458 | 200 | Hilbert Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 32 | 32 | ||||||||||||||||||||||||||||||||||||||||||||||||||
286066 | 286066 | WI | Outagamie | school | 5506600 | 2583 | Public school | Hortonville Area | 550660002573 | 210 | Greenville Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 133 | 133 | ||||||||||||||||||||||||||||||||||||||||||||||||||
286086 | 286086 | WI | Outagamie | school | 5506600 | 2583 | Public school | Hortonville Area | 550660002408 | 30 | Hortonville Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 132 | 132 | ||||||||||||||||||||||||||||||||||||||||||||||||||
286153 | 286153 | WI | Sheboygan | school | 5506660 | 2605 | Public school | Howards Grove | 550666000563 | 125 | Howards Grove Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 74 | 74 | ||||||||||||||||||||||||||||||||||||||||||||||||||
286584 | 286584 | WI | Outagamie | school | 5507290 | 2758 | Public school | Kaukauna Area | 550729001700 | 200 | River View School | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 262 | 262 | ||||||||||||||||||||||||||||||||||||||||||||||||||
287049 | 287049 | WI | Manitowoc | school | 5507440 | 2828 | Public school | Kiel Area | 550744000845 | 60 | Kiel Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 96 | 96 | ||||||||||||||||||||||||||||||||||||||||||||||||||
287395 | 287395 | WI | Jefferson | school | 5507710 | 2898 | Public school | Lake Mills Area | 550771000888 | 60 | Lake Mills Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 123 | 123 | ||||||||||||||||||||||||||||||||||||||||||||||||||
288093 | 288093 | WI | Marinette | school | 5508700 | 3311 | Public school | Marinette | 550870000996 | 70 | Marinette Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 139 | 139 | ||||||||||||||||||||||||||||||||||||||||||||||||||
288332 | 288332 | WI | Taylor | school | 5508940 | 3409 | Public school | Medford Area Public | 550894001044 | 240 | Medford Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 132 | 132 | ||||||||||||||||||||||||||||||||||||||||||||||||||
288660 | 288660 | WI | Waukesha | school | 5509360 | 3528 | Public school | Merton Community | 550936002269 | 20 | Merton Intermediate | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 109 | 109 | ||||||||||||||||||||||||||||||||||||||||||||||||||
288697 | 288697 | WI | Dane | school | 5509510 | 3549 | Public school | Middleton-Cross Plains Area | 550951000754 | 50 | Glacier Creek Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 246 | 246 | ||||||||||||||||||||||||||||||||||||||||||||||||||
288702 | 288702 | WI | Dane | school | 5509510 | 3549 | Public school | Middleton-Cross Plains Area | 550951001104 | 30 | Kromrey Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 274 | 274 | ||||||||||||||||||||||||||||||||||||||||||||||||||
290349 | 290349 | WI | Dane | school | 5509810 | 3675 | Public school | Monona Grove | 550981001293 | 100 | Glacial Drumlin School | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 253 | 253 | ||||||||||||||||||||||||||||||||||||||||||||||||||
290572 | 290572 | WI | Waukesha | school | 5510170 | 3857 | Public school | Muskego-Norway | 551017001330 | 10 | Bay Lane Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 208 | 208 | ||||||||||||||||||||||||||||||||||||||||||||||||||
290585 | 290585 | WI | Waukesha | school | 5510170 | 3857 | Public school | Muskego-Norway | 551017001850 | 200 | Lake Denoon Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 200 | 200 | ||||||||||||||||||||||||||||||||||||||||||||||||||
290864 | 290864 | WI | Green | school | 5510500 | 3934 | Public school | New Glarus | 551050002929 | 250 | New Glarus Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 79 | 79 | ||||||||||||||||||||||||||||||||||||||||||||||||||
290924 | 290924 | WI | Waupaca | school | 5510590 | 3955 | Public school | New London | 551059001388 | 140 | New London Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 163 | 163 | ||||||||||||||||||||||||||||||||||||||||||||||||||
291178 | 291178 | WI | Vilas | school | 5503860 | 1526 | Public school | Northland Pines | 550386002938 | 250 | School of Options & Applied Research Middle | charter | Regular School | Yes | 2.0 | 05 | 08 | 2016 | grade_7 | 18 | 18 | |||||||||||||||||||||||||||||||||||||||||||||||||
291332 | 291332 | WI | Waukesha | school | 5510890 | 4060 | Public school | Oconomowoc Area | 551089002795 | 200 | Nature Hill Intermediate | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 219 | 219 | ||||||||||||||||||||||||||||||||||||||||||||||||||
291349 | 291349 | WI | Waukesha | school | 5510890 | 4060 | Public school | Oconomowoc Area | 551089001422 | 135 | Silver Lake Intermediate | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 175 | 175 | ||||||||||||||||||||||||||||||||||||||||||||||||||
291398 | 291398 | WI | Oconto | school | 5510920 | 4067 | Public school | Oconto Unified | 551092002977 | 200 | Bayshore Community Academy | charter | Regular School | Yes | 2.0 | 05 | 08 | 2016 | grade_7 | 17 | 17 | |||||||||||||||||||||||||||||||||||||||||||||||||
291416 | 291416 | WI | Oconto | school | 5510920 | 4067 | Public school | Oconto Unified | 551092001430 | 180 | Oconto Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 63 | 63 | ||||||||||||||||||||||||||||||||||||||||||||||||||
291773 | 291773 | WI | Columbia | school | 5511370 | 4228 | Public school | Pardeeville Area | 551137001519 | 100 | Pardeeville Middle School | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 55 | 55 | ||||||||||||||||||||||||||||||||||||||||||||||||||
291990 | 291990 | WI | Sheboygan | school | 5511940 | 4473 | Public school | Plymouth Joint | 551194001563 | 120 | Riverview Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 169 | 169 | ||||||||||||||||||||||||||||||||||||||||||||||||||
292039 | 292039 | WI | Ozaukee | school | 5512000 | 4515 | Public school | Port Washington-Saukville | 551200001570 | 140 | Thomas Jefferson Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 163 | 163 | ||||||||||||||||||||||||||||||||||||||||||||||||||
292196 | 292196 | WI | Price | school | 5512210 | 4571 | Public school | Prentice | 551221002767 | 200 | Prentice Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 37 | 37 | ||||||||||||||||||||||||||||||||||||||||||||||||||
292582 | 292582 | WI | Sheboygan | school | 5512450 | 4641 | Public school | Random Lake | 551245002421 | 20 | Random Lake Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 76 | 76 | ||||||||||||||||||||||||||||||||||||||||||||||||||
292750 | 292750 | WI | Barron | school | 5512810 | 4802 | Public school | Rice Lake Area | 551281001697 | 140 | Rice Lake Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 172 | 172 | ||||||||||||||||||||||||||||||||||||||||||||||||||
292988 | 292988 | WI | Grant | school | 5510140 | 3850 | Public school | Riverdale | 551014001064 | 160 | Riverdale Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 35 | 35 | ||||||||||||||||||||||||||||||||||||||||||||||||||
293105 | 293105 | WI | Saint Croix | school | 5506060 | 2422 | Public school | Saint Croix Central | 550606000673 | 80 | Saint Croix Central Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 108 | 108 | ||||||||||||||||||||||||||||||||||||||||||||||||||
293124 | 293124 | WI | Polk | school | 5513230 | 5019 | Public school | Saint Croix Falls | 551323002314 | 70 | Saint Croix Falls Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 79 | 79 | ||||||||||||||||||||||||||||||||||||||||||||||||||
293489 | 293489 | WI | Sheboygan | school | 5513680 | 5278 | Public school | Sheboygan Falls | 551368002289 | 60 | Sheboygan Falls Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 109 | 109 | ||||||||||||||||||||||||||||||||||||||||||||||||||
293671 | 293671 | WI | Saint Croix | school | 5514010 | 5432 | Public school | Somerset | 551401001108 | 60 | Somerset Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 123 | 123 | ||||||||||||||||||||||||||||||||||||||||||||||||||
293861 | 293861 | WI | Washburn | school | 5514220 | 5474 | Public school | Spooner Area | 551422001849 | 100 | Spooner Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 92 | 92 | ||||||||||||||||||||||||||||||||||||||||||||||||||
294456 | 294456 | WI | Portage | school | 5500330 | 126 | Public school | Tomorrow River | 550033000034 | 80 | Amherst Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 85 | 85 | ||||||||||||||||||||||||||||||||||||||||||||||||||
294495 | 294495 | WI | Waushara | school | 5511820 | 4375 | Public school | Tri-County Area | 551182002620 | 80 | Tri-County Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 42 | 42 | ||||||||||||||||||||||||||||||||||||||||||||||||||
294533 | 294533 | WI | Manitowoc | school | 5515120 | 5824 | Public school | Two Rivers Public | 551512001960 | 50 | Clarke Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 111 | 111 | ||||||||||||||||||||||||||||||||||||||||||||||||||
294590 | 294590 | WI | Polk | school | 5500750 | 238 | Public school | Unity | 550075000099 | 120 | Unity Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 78 | 78 | ||||||||||||||||||||||||||||||||||||||||||||||||||
294619 | 294619 | WI | Manitowoc | school | 5515210 | 5866 | Public school | Valders Area | 551521001968 | 80 | Valders Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 63 | 63 | ||||||||||||||||||||||||||||||||||||||||||||||||||
294732 | 294732 | WI | Vernon | school | 5515360 | 5985 | Public school | Viroqua Area | 551536001977 | 230 | Viroqua Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 84 | 84 | ||||||||||||||||||||||||||||||||||||||||||||||||||
295127 | 295127 | WI | Waupaca | school | 5515840 | 6195 | Public school | Waupaca | 551584002036 | 150 | Waupaca Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 156 | 156 | ||||||||||||||||||||||||||||||||||||||||||||||||||
295508 | 295508 | WI | Burnett | school | 5516230 | 6293 | Public school | Webster | 551623002100 | 100 | Webster Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 48 | 48 | ||||||||||||||||||||||||||||||||||||||||||||||||||
295778 | 295778 | WI | Vernon | school | 5516410 | 6321 | Public school | Westby Area | 551641001207 | 160 | Westby Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 81 | 81 | ||||||||||||||||||||||||||||||||||||||||||||||||||
296307 | 296307 | WI | Brown | school | 5517190 | 6734 | Public school | Wrightstown Community | 551719000280 | 30 | Wrightstown Middle | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 99 | 99 | ||||||||||||||||||||||||||||||||||||||||||||||||||
281728 | 281728 | WI | Clark | school | 5500030 | 7 | Public school | Abbotsford | 550003000002 | 40 | Abbotsford Middle/Senior High | Regular School | No | 4.0 | 06 | 12 | 2016 | grade_7 | 50 | 50 | ||||||||||||||||||||||||||||||||||||||||||||||||||
281747 | 281747 | WI | Adams | school | 5500060 | 14 | Public school | Adams-Friendship Area | 550006001454 | 210 | Adams-Friendship Middle | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 110 | 110 | ||||||||||||||||||||||||||||||||||||||||||||||||||
281844 | 281844 | WI | Portage | school | 5500240 | 105 | Public school | Almond-Bancroft | 550024000024 | 40 | Almond High | Regular School | No | 4.0 | 06 | 12 | 2016 | grade_7 | 22 | 22 | ||||||||||||||||||||||||||||||||||||||||||||||||||
281860 | 281860 | WI | Eau Claire | school | 5500270 | 112 | Public school | Altoona | 550027000027 | 60 | Altoona Middle | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 104 | 104 | ||||||||||||||||||||||||||||||||||||||||||||||||||
281880 | 281880 | WI | Polk | school | 5500300 | 119 | Public school | Amery | 550030000031 | 60 | Amery Middle | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 110 | 110 |
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]);