enrollments
Data source: Big Local News · About: Big Local
667 rows where grade = "grade_7", state = "WI" and year = 2017 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
326259 | 326259 | WI | Wood | school | 203 | Public Schools-Multidistrict Charters | Auburndale | 9100 | Rural Virtual Academy | charter | 2017 | grade_7 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
327550 | 327550 | WI | Clark | school | 1162 | Public Schools-Multidistrict Charters | Colby | 9100 | Rural Virtual Academy | charter | 2017 | grade_7 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
334355 | 334355 | WI | Marathon | school | 3787 | Public Schools-Multidistrict Charters | Mosinee | 9100 | Rural Virtual Academy | charter | 2017 | grade_7 | 2 | 2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
335803 | 335803 | WI | Wood | school | 4368 | Public Schools-Multidistrict Charters | Pittsville | 9100 | Rural Virtual Academy | charter | 2017 | grade_7 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
336079 | 336079 | WI | Price | school | 4571 | Public Schools-Multidistrict Charters | Prentice | 9100 | Rural Virtual Academy | charter | 2017 | grade_7 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
337724 | 337724 | WI | Marathon | school | 5467 | Public Schools-Multidistrict Charters | Spencer | 9100 | Rural Virtual Academy | charter | 2017 | grade_7 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
337946 | 337946 | WI | Dane | school | 5621 | Public Schools-Multidistrict Charters | Stoughton Area | 9803 | JEDI Virtual K-12 | charter | 2017 | grade_7 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
339038 | 339038 | WI | Waupaca | school | 6195 | Public Schools-Multidistrict Charters | Waupaca | 9408 | Waupaca County Charter | charter | 2017 | grade_7 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
333908 | 333908 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002442 | 312 | Starms Discovery | Regular School | No | Elementary | 01 | 08 | 2017 | grade_7 | 17 | 17 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326061 | 326061 | WI | Outagamie | school | 5500390 | 147 | Public school | Appleton Area | 550039002277 | 210 | Odyssey-Magellan | charter | Regular School | Yes | Elementary | 03 | 08 | 2017 | grade_7 | 28 | 28 | |||||||||||||||||||||||||||||||||||||||||||||||||
331925 | 331925 | WI | Milwaukee | school | 5504770 | 1897 | Public school | Maple Dale-Indian Hill | 550477000516 | 40 | Maple Dale Elementary | Regular School | No | Elementary | 03 | 08 | 2017 | grade_7 | 59 | 59 | ||||||||||||||||||||||||||||||||||||||||||||||||||
332140 | 332140 | WI | Dodge | school | 5508880 | 3367 | Public school | Mayville | 550888001029 | 60 | Mayville Middle | Regular School | No | Elementary | 03 | 08 | 2017 | grade_7 | 83 | 83 | ||||||||||||||||||||||||||||||||||||||||||||||||||
333543 | 333543 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001164 | 176 | Meir School | Regular School | No | Other | 03 | 11 | 2017 | grade_7 | 126 | 126 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326608 | 326608 | WI | Rock | school | 5501050 | 413 | Public school | Beloit | 550105000140 | 80 | Cunningham Intermediate | Regular School | No | Elementary | 04 | 08 | 2017 | grade_7 | 120 | 120 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326614 | 326614 | WI | Rock | school | 5501050 | 413 | Public school | Beloit | 550105003011 | 170 | Fran Fruzen Intermediate | Regular School | No | Elementary | 04 | 08 | 2017 | grade_7 | 123 | 123 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326634 | 326634 | WI | Rock | school | 5501050 | 413 | Public school | Beloit | 550105002330 | 180 | McNeel Intermediate | Regular School | No | Elementary | 04 | 08 | 2017 | grade_7 | 135 | 135 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
328992 | 328992 | WI | Walworth | school | 5505130 | 2051 | Public school | Genoa City J2 | 550513002327 | 200 | Brookwood Middle | Regular School | No | Elementary | 04 | 08 | 2017 | grade_7 | 49 | 49 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
329218 | 329218 | WI | Burnett | school | 5505670 | 2233 | Public school | Grantsburg | 550567000603 | 100 | Grantsburg Middle | Regular School | No | Elementary | 04 | 08 | 2017 | grade_7 | 57 | 57 | ||||||||||||||||||||||||||||||||||||||||||||||||||
334349 | 334349 | WI | Marathon | school | 5509960 | 3787 | Public school | Mosinee | 550996001309 | 120 | Mosinee Middle | Regular School | No | Elementary | 04 | 08 | 2017 | grade_7 | 149 | 149 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
334627 | 334627 | WI | Wood | school | 5510380 | 3906 | Public school | Nekoosa | 551038002957 | 100 | Central Wisconsin STEM Academy | charter | Regular School | Yes | Elementary | 04 | 08 | 2017 | grade_7 | 8 | 8 | |||||||||||||||||||||||||||||||||||||||||||||||||
334643 | 334643 | WI | Wood | school | 5510380 | 3906 | Public school | Nekoosa | 551038002715 | 200 | Niikuusra Community School | charter | Alternative School | Yes | Elementary | 04 | 08 | 2017 | grade_7 | 4 | 4 | |||||||||||||||||||||||||||||||||||||||||||||||||
335038 | 335038 | WI | Washburn | school | 5509720 | 3654 | Public school | Northwood | 550972002877 | 200 | NorthStar Community Charter School | charter | Regular School | Yes | Elementary | 04 | 08 | 2017 | grade_7 | 4 | 4 | |||||||||||||||||||||||||||||||||||||||||||||||||
335412 | 335412 | WI | Winnebago | school | 5511190 | 4179 | Public school | Oshkosh Area | 551119003364 | 170 | Accelerated Advanced Learning Program | charter | Regular School | Yes | Elementary | 04 | 08 | 2017 | grade_7 | 15 | 15 | |||||||||||||||||||||||||||||||||||||||||||||||||
336912 | 336912 | WI | Fond du Lac | school | 5513100 | 4956 | Public school | Rosendale-Brandon | 551310001731 | 80 | Rosendale Intermediate | Regular School | No | Elementary | 04 | 08 | 2017 | grade_7 | 40 | 40 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326134 | 326134 | WI | Trempealeau | school | 5500420 | 154 | Public school | Arcadia | 550042003041 | 290 | Arcadia Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 89 | 89 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326428 | 326428 | WI | Barron | school | 5500870 | 308 | Public school | Barron Area | 550087000118 | 140 | Riverview Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 94 | 94 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326840 | 326840 | WI | Chippewa | school | 5501350 | 497 | Public school | Bloomer | 550135000185 | 60 | Bloomer Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 70 | 70 | ||||||||||||||||||||||||||||||||||||||||||||||||||
327156 | 327156 | WI | Barron | school | 5502130 | 903 | Public school | Cameron | 550213002286 | 200 | Cameron Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 72 | 72 | ||||||||||||||||||||||||||||||||||||||||||||||||||
327249 | 327249 | WI | Sheboygan | school | 5502430 | 1029 | Public school | Cedar Grove-Belgium Area | 550243001629 | 200 | Cedar Grove-Belgium Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 74 | 74 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
327492 | 327492 | WI | Rock | school | 5502640 | 1134 | Public school | Clinton Community | 550264000297 | 80 | Clinton Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 107 | 107 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
327747 | 327747 | WI | Barron | school | 5503090 | 1260 | Public school | Cumberland | 550309000304 | 50 | Cumberland Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 63 | 63 | ||||||||||||||||||||||||||||||||||||||||||||||||||
327873 | 327873 | WI | Dane | school | 5503180 | 1316 | Public school | De Forest Area | 550318000356 | 50 | De Forest Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 238 | 238 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
329102 | 329102 | WI | Buffalo | school | 5505370 | 2142 | Public school | Gilmanton | 550537002907 | 250 | Gilmanton Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 13 | 13 | ||||||||||||||||||||||||||||||||||||||||||||||||||
329822 | 329822 | WI | Dodge | school | 5500075 | 2525 | Public school | Herman-Neosho-Rubicon | 550007503034 | 150 | Honor Intermediate | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 36 | 36 | ||||||||||||||||||||||||||||||||||||||||||||||||||
329856 | 329856 | WI | Calumet | school | 5506450 | 2534 | Public school | Hilbert | 550645001458 | 200 | Hilbert Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 27 | 27 | ||||||||||||||||||||||||||||||||||||||||||||||||||
329948 | 329948 | WI | Outagamie | school | 5506600 | 2583 | Public school | Hortonville Area | 550660002573 | 210 | Greenville Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 147 | 147 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
330031 | 330031 | WI | Sheboygan | school | 5506660 | 2605 | Public school | Howards Grove | 550666000563 | 125 | Howards Grove Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 56 | 56 | ||||||||||||||||||||||||||||||||||||||||||||||||||
330408 | 330408 | WI | Jefferson | school | 5507170 | 2730 | Public school | Johnson Creek | 550717000783 | 40 | Johnson Creek Middle and High | Regular School | No | Other | 05 | 12 | 2017 | grade_7 | 47 | 47 | ||||||||||||||||||||||||||||||||||||||||||||||||||
330463 | 330463 | WI | Outagamie | school | 5507290 | 2758 | Public school | Kaukauna Area | 550729001700 | 200 | River View School | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 262 | 262 | ||||||||||||||||||||||||||||||||||||||||||||||||||
330932 | 330932 | WI | Manitowoc | school | 5507440 | 2828 | Public school | Kiel Area | 550744000845 | 60 | Kiel Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 82 | 82 | ||||||||||||||||||||||||||||||||||||||||||||||||||
331269 | 331269 | WI | Jefferson | school | 5507710 | 2898 | Public school | Lake Mills Area | 550771000888 | 60 | Lake Mills Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 126 | 126 | ||||||||||||||||||||||||||||||||||||||||||||||||||
331959 | 331959 | WI | Marinette | school | 5508700 | 3311 | Public school | Marinette | 550870000996 | 70 | Marinette Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 168 | 168 | ||||||||||||||||||||||||||||||||||||||||||||||||||
332205 | 332205 | WI | Taylor | school | 5508940 | 3409 | Public school | Medford Area Public | 550894001044 | 240 | Medford Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 162 | 162 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
332566 | 332566 | WI | Dane | school | 5509510 | 3549 | Public school | Middleton-Cross Plains Area | 550951000754 | 50 | Glacier Creek Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 228 | 228 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
334220 | 334220 | WI | Dane | school | 5509810 | 3675 | Public school | Monona Grove | 550981001293 | 100 | Glacial Drumlin School | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 272 | 272 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
334459 | 334459 | WI | Waukesha | school | 5510170 | 3857 | Public school | Muskego-Norway | 551017001850 | 200 | Lake Denoon Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 204 | 204 | ||||||||||||||||||||||||||||||||||||||||||||||||||
334728 | 334728 | WI | Green | school | 5510500 | 3934 | Public school | New Glarus | 551050002929 | 250 | New Glarus Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 89 | 89 | ||||||||||||||||||||||||||||||||||||||||||||||||||
334787 | 334787 | WI | Waupaca | school | 5510590 | 3955 | Public school | New London | 551059001388 | 140 | New London Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 185 | 185 | ||||||||||||||||||||||||||||||||||||||||||||||||||
335032 | 335032 | WI | Vilas | school | 5503860 | 1526 | Public school | Northland Pines | 550386002938 | 250 | School of Options & Applied Research Middle | charter | Regular School | Yes | Middle | 05 | 08 | 2017 | grade_7 | 11 | 11 | |||||||||||||||||||||||||||||||||||||||||||||||||
335198 | 335198 | WI | Waukesha | school | 5510890 | 4060 | Public school | Oconomowoc Area | 551089002795 | 200 | Nature Hill Intermediate | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 204 | 204 | ||||||||||||||||||||||||||||||||||||||||||||||||||
335216 | 335216 | WI | Waukesha | school | 5510890 | 4060 | Public school | Oconomowoc Area | 551089001422 | 135 | Silver Lake Intermediate | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 199 | 199 | ||||||||||||||||||||||||||||||||||||||||||||||||||
335262 | 335262 | WI | Oconto | school | 5510920 | 4067 | Public school | Oconto Unified | 551092002977 | 200 | Bayshore Community Academy | charter | Regular School | Yes | Middle | 05 | 08 | 2017 | grade_7 | 21 | 21 | |||||||||||||||||||||||||||||||||||||||||||||||||
335279 | 335279 | WI | Oconto | school | 5510920 | 4067 | Public school | Oconto Unified | 551092001430 | 180 | Oconto Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 71 | 71 | ||||||||||||||||||||||||||||||||||||||||||||||||||
335642 | 335642 | WI | Columbia | school | 5511370 | 4228 | Public school | Pardeeville Area | 551137001519 | 100 | Pardeeville Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 63 | 63 | ||||||||||||||||||||||||||||||||||||||||||||||||||
335813 | 335813 | WI | Grant | school | 5511850 | 4389 | Public school | Platteville | 551185001554 | 80 | Platteville Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 91 | 91 | ||||||||||||||||||||||||||||||||||||||||||||||||||
335871 | 335871 | WI | Sheboygan | school | 5511940 | 4473 | Public school | Plymouth Joint | 551194001563 | 120 | Riverview Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 144 | 144 | ||||||||||||||||||||||||||||||||||||||||||||||||||
335919 | 335919 | WI | Ozaukee | school | 5512000 | 4515 | Public school | Port Washington-Saukville | 551200001570 | 140 | Thomas Jefferson Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 192 | 192 | ||||||||||||||||||||||||||||||||||||||||||||||||||
336073 | 336073 | WI | Price | school | 5512210 | 4571 | Public school | Prentice | 551221002767 | 200 | Prentice Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 23 | 23 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
336538 | 336538 | WI | Manitowoc | school | 5512690 | 4760 | Public school | Reedsville | 551269001671 | 60 | Reedsville Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 37 | 37 | ||||||||||||||||||||||||||||||||||||||||||||||||||
336637 | 336637 | WI | Barron | school | 5512810 | 4802 | Public school | Rice Lake Area | 551281001697 | 140 | Rice Lake Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 149 | 149 | ||||||||||||||||||||||||||||||||||||||||||||||||||
336985 | 336985 | WI | Saint Croix | school | 5506060 | 2422 | Public school | Saint Croix Central | 550606000673 | 80 | Saint Croix Central Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 125 | 125 | ||||||||||||||||||||||||||||||||||||||||||||||||||
337004 | 337004 | WI | Polk | school | 5513230 | 5019 | Public school | Saint Croix Falls | 551323002314 | 70 | Saint Croix Falls Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 81 | 81 | ||||||||||||||||||||||||||||||||||||||||||||||||||
337380 | 337380 | WI | Sheboygan | school | 5513680 | 5278 | Public school | Sheboygan Falls | 551368002289 | 60 | Sheboygan Falls Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 123 | 123 | ||||||||||||||||||||||||||||||||||||||||||||||||||
337562 | 337562 | WI | Saint Croix | school | 5514010 | 5432 | Public school | Somerset | 551401001108 | 60 | Somerset Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 124 | 124 | ||||||||||||||||||||||||||||||||||||||||||||||||||
337760 | 337760 | WI | Washburn | school | 5514220 | 5474 | Public school | Spooner Area | 551422001849 | 100 | Spooner Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 85 | 85 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
325622 | 325622 | WI | Clark | school | 5500030 | 7 | Public school | Abbotsford | 550003000002 | 40 | Abbotsford Middle/Senior High | Regular School | No | Other | 06 | 12 | 2017 | grade_7 | 44 | 44 | ||||||||||||||||||||||||||||||||||||||||||||||||||
325644 | 325644 | WI | Adams | school | 5500060 | 14 | Public school | Adams-Friendship Area | 550006001454 | 210 | Adams-Friendship Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 123 | 123 | ||||||||||||||||||||||||||||||||||||||||||||||||||
325666 | 325666 | WI | Green | school | 5500120 | 63 | Public school | Albany | 550012002357 | 60 | Albany Community Middle | charter | Regular School | Yes | Middle | 06 | 08 | 2017 | grade_7 | 29 | 29 | |||||||||||||||||||||||||||||||||||||||||||||||||
325745 | 325745 | WI | Portage | school | 5500240 | 105 | Public school | Almond-Bancroft | 550024000024 | 40 | Almond High | Regular School | No | Other | 06 | 12 | 2017 | grade_7 | 41 | 41 | ||||||||||||||||||||||||||||||||||||||||||||||||||
325769 | 325769 | WI | Eau Claire | school | 5500270 | 112 | Public school | Altoona | 550027000027 | 60 | Altoona Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 117 | 117 | ||||||||||||||||||||||||||||||||||||||||||||||||||
325782 | 325782 | WI | Polk | school | 5500300 | 119 | Public school | Amery | 550030000031 | 60 | Amery Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 116 | 116 |
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]);