enrollments
Data source: Big Local News · About: Big Local
667 rows where grade = "grade_7", state = "WI" and year = 2017 sorted by total
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
325689 | 325689 | WI | Kewaunee | school | 5500150 | 70 | Public school | Algoma | 550015000015 | 20 | Algoma Elementary | Regular School | No | Elementary | PK | 06 | 2017 | grade_7 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326259 | 326259 | WI | Wood | school | 203 | Public Schools-Multidistrict Charters | Auburndale | 9100 | Rural Virtual Academy | charter | 2017 | grade_7 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
326595 | 326595 | WI | Rock | school | 5501050 | 413 | Public school | Beloit | 550105002799 | 850 | Beloit Virtual School | Regular School | No | Other | PK | 12 | 2017 | grade_7 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326658 | 326658 | WI | Rock | school | 5501050 | 413 | Public school | Beloit | 550105002705 | 410 | Roy Chapman Andrews Academy | charter | Regular School | Yes | Other | 06 | 12 | 2017 | grade_7 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
326733 | 326733 | WI | Washburn | school | 5501170 | 441 | Public school | Birchwood | 550117002800 | 450 | Birchwood Blue Hills Charter School | charter | Regular School | Yes | High | 07 | 12 | 2017 | grade_7 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
327359 | 327359 | WI | Barron | school | 5500061 | 1080 | Public school | Chetek-Weyerhaeuser Area | 550006102897 | 800 | Link2Learn Virtual Charter School | charter | Regular School | Yes | Other | PK | 12 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
327943 | 327943 | WI | Vernon | school | 5503240 | 1421 | Public school | De Soto Area | 550324003022 | 810 | De Soto Virtual School | charter | Regular School | Yes | Other | KG | 12 | 2017 | grade_7 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
328210 | 328210 | WI | Eau Claire | school | 5504050 | 1554 | Public school | Eau Claire Area | 550405000705 | 580 | McKinley Charter School | charter | Alternative School | Yes | Other | 06 | 12 | 2017 | grade_7 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
329864 | 329864 | WI | Vernon | school | 5506480 | 2541 | Public school | Hillsboro | 550648000702 | 20 | Hillsboro Elementary | Regular School | No | Elementary | PK | 05 | 2017 | grade_7 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||
331602 | 331602 | WI | Dane | school | 5508520 | 3269 | Public school | Madison Metropolitan | 550852002909 | 220 | Innovative & Alternative Middle | Alternative School | No | Middle | 06 | 08 | 2017 | grade_7 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||
332744 | 332744 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001126 | 81 | Barton Elementary | Regular School | No | Elementary | PK | 06 | 2017 | grade_7 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||
335803 | 335803 | WI | Wood | school | 4368 | Public Schools-Multidistrict Charters | Pittsville | 9100 | Rural Virtual Academy | charter | 2017 | grade_7 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
335998 | 335998 | WI | Columbia | school | 5512120 | 4536 | Public school | Poynette | 551212001580 | 80 | Poynette High | Regular School | No | High | 09 | 12 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
336690 | 336690 | WI | Richland | school | 5512960 | 4851 | Public school | Richland | 551296002998 | 450 | Richland Online Academy | charter | Regular School | Yes | Other | 06 | 12 | 2017 | grade_7 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
336965 | 336965 | WI | Saint Croix | school | 5506060 | 2422 | Public school | Saint Croix Central | 550606002989 | 850 | Saint Croix Academy of Virtual Education | charter | Regular School | Yes | Other | KG | 12 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
328079 | 328079 | WI | Racine | school | 5503750 | 1449 | Public school | Dover #1 | 550375000394 | 20 | Kansasville Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 10 | 10 | ||||||||||||||||||||||||||||||||||||||||||||||||||
331022 | 331022 | WI | La Crosse | school | 5507530 | 2849 | Public school | La Crosse | 550753001463 | 140 | Coulee Montessori Charter School | charter | Regular School | Yes | Elementary | PK | 08 | 2017 | grade_7 | 10 | 10 | |||||||||||||||||||||||||||||||||||||||||||||||||
331334 | 331334 | WI | Walworth | school | 5508040 | 3087 | Public school | Linn J4 | 550804000898 | 20 | Traver Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 10 | 10 | ||||||||||||||||||||||||||||||||||||||||||||||||||
335080 | 335080 | WI | Racine | school | 5510800 | 4011 | Public school | Norway J7 | 551080001405 | 20 | Drought Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 10 | 10 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
333201 | 333201 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002979 | 880 | HAPA-Hmong American Peace Academy K3-12 | charter | Regular School | Yes | Other | PK | 12 | 2017 | grade_7 | 100 | 100 | |||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
335726 | 335726 | WI | Marinette | school | 5511610 | 4305 | Public school | Peshtigo | 551161003026 | 200 | Peshtigo Middle | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 101 | 101 | ||||||||||||||||||||||||||||||||||||||||||||||||||
329763 | 329763 | WI | Waukesha | school | 5506140 | 2460 | Public school | Hartland-Lakeside J3 | 550614001282 | 100 | North Shore Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 102 | 102 | ||||||||||||||||||||||||||||||||||||||||||||||||||
331065 | 331065 | WI | La Crosse | school | 5507530 | 2849 | Public school | La Crosse | 550753000863 | 180 | Lincoln Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 102 | 102 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
332122 | 332122 | WI | Juneau | school | 5508850 | 3360 | Public school | Mauston | 550885001026 | 20 | Olson Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 103 | 103 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
331396 | 331396 | WI | Columbia | school | 5508190 | 3150 | Public school | Lodi | 550819000906 | 100 | Lodi Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 104 | 104 | ||||||||||||||||||||||||||||||||||||||||||||||||||
328960 | 328960 | WI | Trempealeau | school | 5504960 | 2009 | Public school | Galesville-Ettrick-Trempealeau | 550496000537 | 50 | Galesville-Ettrick-Trempealeau Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 106 | 106 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
327011 | 327011 | WI | Milwaukee | school | 5500059 | 8123 | Non District Charter Schools | Bruce Guadalupe | 550005900772 | 100 | Bruce Guadalupe | charter | Regular School | Yes | Elementary | PK | 08 | 2017 | grade_7 | 108 | 108 | |||||||||||||||||||||||||||||||||||||||||||||||||
333865 | 333865 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001238 | 59 | Roosevelt Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 108 | 108 | ||||||||||||||||||||||||||||||||||||||||||||||||||
329808 | 329808 | WI | Sawyer | school | 5506270 | 2478 | Public school | Hayward Community | 550627002867 | 250 | Northern Waters Environmental School | charter | Regular School | Yes | Other | 06 | 12 | 2017 | grade_7 | 11 | 11 | |||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||
336206 | 336206 | WI | Racine | school | 5512360 | 4620 | Public school | Racine Unified | 551236002311 | 119 | Gifford Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 110 | 110 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||
328315 | 328315 | WI | Rock | school | 5504110 | 1568 | Public school | Edgerton | 550411000444 | 60 | Edgerton Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 112 | 112 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326710 | 326710 | WI | Green Lake | school | 5501140 | 434 | Public school | Berlin Area | 550114000164 | 80 | Berlin Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 113 | 113 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
335257 | 335257 | WI | Oconto | school | 5510950 | 4074 | Public school | Oconto Falls Public | 551095001438 | 260 | Washington Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 113 | 113 | ||||||||||||||||||||||||||||||||||||||||||||||||||
335515 | 335515 | WI | Winnebago | school | 5511190 | 4179 | Public school | Oshkosh Area | 551119001497 | 320 | Tipler Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 113 | 113 | ||||||||||||||||||||||||||||||||||||||||||||||||||
333994 | 333994 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002967 | 875 | Universal Academy for the College Bound | charter | Regular School | Yes | Other | PK | 12 | 2017 | grade_7 | 114 | 114 | |||||||||||||||||||||||||||||||||||||||||||||||||
335406 | 335406 | WI | Polk | school | 5511160 | 4165 | Public school | Osceola | 551116002319 | 80 | Osceola Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 114 | 114 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
328026 | 328026 | WI | Brown | school | 5503660 | 1407 | Public school | Denmark | 550366000389 | 100 | Denmark Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 116 | 116 | ||||||||||||||||||||||||||||||||||||||||||||||||||
337031 | 337031 | WI | Kenosha | school | 5513350 | 5068 | Public school | Salem | 551335001753 | 20 | Salem Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 116 | 116 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
336099 | 336099 | WI | Pierce | school | 5512240 | 4578 | Public school | Prescott | 551224001593 | 80 | Prescott Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 118 | 118 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326983 | 326983 | WI | Milwaukee | school | 5501800 | 721 | Public school | Brown Deer | 550180000230 | 40 | Brown Deer Middle/High | Regular School | No | High | 07 | 12 | 2017 | grade_7 | 119 | 119 | ||||||||||||||||||||||||||||||||||||||||||||||||||
327177 | 327177 | WI | Fond du Lac | school | 5502160 | 910 | Public school | Campbellsport | 550216002484 | 300 | Campbellsport Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 119 | 119 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
336684 | 336684 | WI | Richland | school | 5512960 | 4851 | Public school | Richland | 551296001708 | 280 | Richland Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 119 | 119 | ||||||||||||||||||||||||||||||||||||||||||||||||||
327230 | 327230 | WI | Grant | school | 5502400 | 994 | Public school | Cassville | 550240000265 | 40 | Cassville High | Regular School | No | High | 07 | 12 | 2017 | grade_7 | 12 | 12 | ||||||||||||||||||||||||||||||||||||||||||||||||||
329142 | 329142 | WI | Marinette | school | 5505580 | 2212 | Public school | Goodman-Armstrong Creek | 550558000592 | 40 | Goodman High | Regular School | No | High | 07 | 12 | 2017 | grade_7 | 12 | 12 | ||||||||||||||||||||||||||||||||||||||||||||||||||
332465 | 332465 | WI | Iron | school | 5509150 | 3484 | Public school | Mercer | 550915001092 | 40 | Mercer School | Regular School | No | Other | PK | 12 | 2017 | grade_7 | 12 | 12 | ||||||||||||||||||||||||||||||||||||||||||||||||||
337541 | 337541 | WI | Douglas | school | 5513980 | 5397 | Public school | Solon Springs | 551398001911 | 800 | Solon Springs School | Regular School | No | Other | PK | 12 | 2017 | grade_7 | 12 | 12 | ||||||||||||||||||||||||||||||||||||||||||||||||||
337620 | 337620 | WI | Bayfield | school | 5512030 | 4522 | Public school | South Shore | 551203001574 | 100 | South Shore Jr/Sr High | Regular School | No | High | 07 | 12 | 2017 | grade_7 | 12 | 12 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326684 | 326684 | WI | Rock | school | 5501080 | 422 | Public school | Beloit Turner | 550108000159 | 120 | Turner Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 121 | 121 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326174 | 326174 | WI | Ashland | school | 5500510 | 170 | Public school | Ashland | 550051000074 | 30 | Ashland Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 122 | 122 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326303 | 326303 | WI | Saint Croix | school | 5500720 | 231 | Public school | Baldwin-Woodville Area | 550072000096 | 90 | Viking Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 122 | 122 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
328142 | 328142 | WI | Walworth | school | 5504020 | 1540 | Public school | East Troy Community | 550402000411 | 60 | East Troy Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 123 | 123 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326788 | 326788 | WI | Jackson | school | 5501260 | 476 | Public school | Black River Falls | 550126000174 | 60 | Black River Falls Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 125 | 125 | ||||||||||||||||||||||||||||||||||||||||||||||||||
330883 | 330883 | WI | Washington | school | 5507380 | 2800 | Public school | Kewaskum | 550738000838 | 90 | Kewaskum Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 125 | 125 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
331503 | 331503 | WI | Dane | school | 5508520 | 3269 | Public school | Madison Metropolitan | 550852000959 | 690 | Black Hawk Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 127 | 127 | ||||||||||||||||||||||||||||||||||||||||||||||||||
335548 | 335548 | WI | Winnebago | school | 5511190 | 4179 | Public school | Oshkosh Area | 551119001504 | 500 | Webster Stanley Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 127 | 127 | ||||||||||||||||||||||||||||||||||||||||||||||||||
329797 | 329797 | WI | Sawyer | school | 5506270 | 2478 | Public school | Hayward Community | 550627000691 | 60 | Hayward Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 129 | 129 | ||||||||||||||||||||||||||||||||||||||||||||||||||
330377 | 330377 | WI | Jefferson | school | 5507050 | 2702 | Public school | Jefferson | 550705000779 | 60 | Jefferson Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 129 | 129 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326284 | 326284 | WI | Eau Claire | school | 5500630 | 217 | Public school | Augusta | 550063002586 | 410 | Wildlands Charter School | charter | Regular School | Yes | High | 07 | 12 | 2017 | grade_7 | 13 | 13 | |||||||||||||||||||||||||||||||||||||||||||||||||
327753 | 327753 | WI | Barron | school | 5503090 | 1260 | Public school | Cumberland | 550309002962 | 420 | Island City Academy | charter | Career and Technical School | Yes | High | 07 | 12 | 2017 | grade_7 | 13 | 13 | |||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
331106 | 331106 | WI | La Crosse | school | 5507530 | 2849 | Public school | La Crosse | 550753001295 | 204 | School of Technology and Arts II | charter | Regular School | Yes | Middle | 06 | 08 | 2017 | grade_7 | 13 | 13 | |||||||||||||||||||||||||||||||||||||||||||||||||
331345 | 331345 | WI | Walworth | school | 5508070 | 3094 | Public school | Linn J6 | 550807000899 | 20 | Reek Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 13 | 13 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
331756 | 331756 | WI | Dane | school | 5508520 | 3269 | Public school | Madison Metropolitan | 550852002435 | 710 | Sherman Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 131 | 131 | ||||||||||||||||||||||||||||||||||||||||||||||||||
328923 | 328923 | WI | Outagamie | school | 5504920 | 1953 | Public school | Freedom Area | 550492000534 | 40 | Freedom Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 132 | 132 | ||||||||||||||||||||||||||||||||||||||||||||||||||
332430 | 332430 | WI | Ozaukee | school | 5509130 | 3479 | Public school | Mequon-Thiensville | 550913001086 | 80 | Lake Shore Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 132 | 132 | ||||||||||||||||||||||||||||||||||||||||||||||||||
337162 | 337162 | WI | Outagamie | school | 5513530 | 5138 | Public school | Seymour Community | 551353001772 | 80 | Seymour Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 132 | 132 |
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]);