enrollments
Data source: Big Local News · About: Big Local
696 rows where grade = "grade_7", state = "WI" and year = 2021 sorted by school
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2332933 | 2332933 | WI | Racine | school | 5500045 | 8110 | Non District Charter Schools | 21st Century Preparatory School | 550004502575 | 100 | 21st Century Preparatory School | charter | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_7 | 60 | 60 | |||||||||||||||||||||||||||||||||||||||||||||||||
2340189 | 2340189 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960003371 | 162 | ALBA - Academia de Lenguaje y Bellas Artes | charter | Regular School | Yes | Elementary | PK | 07 | 2021 | grade_7 | 12 | 12 | |||||||||||||||||||||||||||||||||||||||||||||||||
2337650 | 2337650 | WI | Rock | school | 5507020 | 2695 | Public school | Janesville | 550702002991 | 860 | ARISE Virtual Academy | charter | Regular School | Yes | Other | KG | 12 | 2021 | grade_7 | 15 | 15 | |||||||||||||||||||||||||||||||||||||||||||||||||
2332951 | 2332951 | WI | Clark | school | 5500030 | 7 | Public school | Abbotsford | 550003000002 | 40 | Abbotsford Middle/Senior High | Regular School | No | High | 06 | 12 | 2021 | grade_7 | 54 | 54 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2342956 | 2342956 | WI | Winnebago | school | 5511190 | 4179 | Public school | Oshkosh Area | 551119003364 | 170 | Accelerated Advanced Learning Program | charter | Regular School | Yes | Middle | 04 | 08 | 2021 | grade_7 | 14 | 14 | |||||||||||||||||||||||||||||||||||||||||||||||||
2332971 | 2332971 | WI | Adams | school | 5500060 | 14 | Public school | Adams-Friendship Area | 550006001454 | 210 | Adams-Friendship Middle | Regular School | No | Middle | 05 | 08 | 2021 | grade_7 | 117 | 117 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2333679 | 2333679 | WI | Barron | school | 5500870 | 308 | Public school | Barron Area | 550087002864 | 810 | Advanced Learning Academy of Wisconsin | charter | Regular School | Yes | Other | KG | 12 | 2021 | grade_7 | 10 | 10 | |||||||||||||||||||||||||||||||||||||||||||||||||
2332976 | 2332976 | WI | Green | school | 5500120 | 63 | Public school | Albany | 550012002357 | 60 | Albany Community Middle | Regular School | No | Middle | 05 | 08 | 2021 | grade_7 | 20 | 20 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2340200 | 2340200 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001121 | 75 | Alcott Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 33 | 33 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2336631 | 2336631 | WI | Brown | school | 5505820 | 2289 | Public school | Green Bay Area Public | 550582000610 | 20 | Aldo Leopold Community School K-8 | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 63 | 63 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2333849 | 2333849 | WI | Rock | school | 5501050 | 413 | Public school | Beloit | 550105000137 | 20 | Aldrich Intermediate | Regular School | No | Middle | 04 | 08 | 2021 | grade_7 | 95 | 95 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2342101 | 2342101 | WI | Wood | school | 5510380 | 3906 | Public school | Nekoosa | 551038001358 | 20 | Alexander Middle | Regular School | No | Middle | 04 | 08 | 2021 | grade_7 | 67 | 67 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2333005 | 2333005 | WI | Kewaunee | school | 5500150 | 70 | Public school | Algoma | 550015000016 | 40 | Algoma High | Regular School | No | High | 07 | 12 | 2021 | grade_7 | 54 | 54 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2333015 | 2333015 | WI | Buffalo | school | 5500180 | 84 | Public school | Alma | 550018000017 | 20 | Alma Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 19 | 19 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2333057 | 2333057 | WI | Portage | school | 5500240 | 105 | Public school | Almond-Bancroft | 550024003076 | 250 | Almond-Bancroft Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 24 | 24 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2333076 | 2333076 | WI | Eau Claire | school | 5500270 | 112 | Public school | Altoona | 550027000027 | 60 | Altoona Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 145 | 145 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2333089 | 2333089 | WI | Polk | school | 5500300 | 119 | Public school | Amery | 550030000031 | 60 | Amery Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 87 | 87 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2345933 | 2345933 | WI | Portage | school | 5500330 | 126 | Public school | Tomorrow River | 550033000034 | 80 | Amherst Middle | Regular School | No | Middle | 05 | 08 | 2021 | grade_7 | 69 | 69 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2340220 | 2340220 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960003123 | 215 | Andrew S Douglas Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 97 | 97 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2333108 | 2333108 | WI | Langlade | school | 5500360 | 140 | Public school | Antigo Unified | 550036000036 | 50 | Antigo Middle | Regular School | No | Middle | 04 | 07 | 2021 | grade_7 | 127 | 127 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2347898 | 2347898 | WI | Vilas | school | 5517160 | 6720 | Public school | Woodruff J1 | 551716002227 | 20 | Arbor Vitae-Woodruff Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 54 | 54 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2333417 | 2333417 | WI | Trempealeau | school | 5500420 | 154 | Public school | Arcadia | 550042003041 | 290 | Arcadia Middle | Regular School | No | Middle | 05 | 08 | 2021 | grade_7 | 85 | 85 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2333435 | 2333435 | WI | Lafayette | school | 5500450 | 161 | Public school | Argyle | 550045003073 | 250 | Argyle Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 22 | 22 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2343256 | 2343256 | WI | Waukesha | school | 5511640 | 4312 | Public school | Pewaukee | 551164001538 | 100 | Asa Clark Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 218 | 218 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2333449 | 2333449 | WI | Ashland | school | 5500510 | 170 | Public school | Ashland | 550051000074 | 30 | Ashland Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 161 | 161 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2333519 | 2333519 | WI | Marathon | school | 5500570 | 196 | Public school | Athens | 550057000088 | 60 | Athens Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 29 | 29 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2333535 | 2333535 | WI | Wood | school | 5500600 | 203 | Public school | Auburndale | 550060000091 | 60 | Auburndale High | Regular School | No | High | 06 | 12 | 2021 | grade_7 | 59 | 59 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2340234 | 2340234 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001123 | 41 | Audubon Technology and Communication Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 158 | 158 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2333565 | 2333565 | WI | Eau Claire | school | 5500630 | 217 | Public school | Augusta | 550063002585 | 200 | Augusta Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 36 | 36 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2347214 | 2347214 | WI | Washington | school | 5516290 | 6307 | Public school | West Bend | 551629002125 | 10 | Badger Middle | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 443 | 443 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2346131 | 2346131 | WI | Dane | school | 5515330 | 5901 | Public school | Verona Area | 551533001973 | 120 | Badger Ridge Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 183 | 183 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2338985 | 2338985 | WI | Dane | school | 5508520 | 3269 | Public school | Madison Metropolitan | 550852002866 | 200 | Badger Rock Middle | charter | Regular School | Yes | Middle | 06 | 08 | 2021 | grade_7 | 34 | 34 | |||||||||||||||||||||||||||||||||||||||||||||||||
2333606 | 2333606 | WI | La Crosse | school | 5500780 | 245 | Public school | Bangor | 550078000101 | 40 | Bangor Middle/High | Regular School | No | High | 06 | 12 | 2021 | grade_7 | 43 | 43 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2333666 | 2333666 | WI | Iowa | school | 5500840 | 287 | Public school | Barneveld | 550084000112 | 40 | Barneveld High | Regular School | No | High | 06 | 12 | 2021 | grade_7 | 39 | 39 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2337394 | 2337394 | WI | Brown | school | 5506630 | 2604 | Public school | Howard-Suamico | 550663000717 | 30 | Bay View Middle | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 444 | 444 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2340280 | 2340280 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002911 | 112 | Bay View Montessori School | Regular School | No | Elementary | PK | 07 | 2021 | grade_7 | 26 | 26 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2333737 | 2333737 | WI | Bayfield | school | 5500900 | 315 | Public school | Bayfield | 550090000082 | 30 | Bayfield Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 30 | 30 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2342790 | 2342790 | WI | Oconto | school | 5510920 | 4067 | Public school | Oconto Unified | 551092002977 | 200 | Bayshore Community Academy | charter | Regular School | Yes | Middle | 05 | 08 | 2021 | grade_7 | 18 | 18 | |||||||||||||||||||||||||||||||||||||||||||||||||
2336219 | 2336219 | WI | Milwaukee | school | 5504800 | 1890 | Public school | Fox Point J2 | 550480000517 | 20 | Bayside Middle | Regular School | No | Middle | 05 | 08 | 2021 | grade_7 | 100 | 100 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2333753 | 2333753 | WI | Dodge | school | 5500960 | 336 | Public school | Beaver Dam Unified | 550096000122 | 20 | Beaver Dam Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 241 | 241 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2333827 | 2333827 | WI | Dane | school | 5500990 | 350 | Public school | Belleville | 550099000133 | 60 | Belleville Middle | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 65 | 65 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2333842 | 2333842 | WI | Lafayette | school | 5501020 | 364 | Public school | Belmont Community | 550102000135 | 40 | Belmont High | Regular School | No | High | 07 | 12 | 2021 | grade_7 | 23 | 23 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2333858 | 2333858 | WI | Rock | school | 5501050 | 413 | Public school | Beloit | 550105002974 | 421 | Beloit Learning Academy | Alternative School | No | High | 06 | 12 | 2021 | grade_7 | 4 | 4 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2333871 | 2333871 | WI | Rock | school | 5501050 | 413 | Public school | Beloit | 550105002799 | 850 | Beloit Virtual School | Regular School | No | Other | PK | 12 | 2021 | grade_7 | 3 | 3 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2345324 | 2345324 | WI | Portage | school | 5514490 | 5607 | Public school | Stevens Point Area Public | 551449001868 | 10 | Benjamin Franklin Junior High | Regular School | No | Middle | 07 | 09 | 2021 | grade_7 | 283 | 283 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2333974 | 2333974 | WI | Lafayette | school | 5501110 | 427 | Public school | Benton | 550111003061 | 250 | Benton Middle | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 17 | 17 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2333983 | 2333983 | WI | Green Lake | school | 5501140 | 434 | Public school | Berlin Area | 550114000164 | 80 | Berlin Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 112 | 112 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2342411 | 2342411 | WI | Fond du Lac | school | 5510740 | 3983 | Public school | North Fond du Lac | 551074001396 | 20 | Bessie Allen Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 114 | 114 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2340291 | 2340291 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001256 | 356 | Bethune Academy | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 75 | 75 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2337310 | 2337310 | WI | Dodge | school | 2576 | Public Schools-Multidistrict Charters | Horicon | 800 | Between the Lakes Virtual Academy | charter | 2021 | grade_7 | 5 | 5 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2337525 | 2337525 | WI | Dodge | school | 2625 | Public Schools-Multidistrict Charters | Hustisford | 800 | Between the Lakes Virtual Academy | charter | 2021 | grade_7 | 3 | 3 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2338369 | 2338369 | WI | Manitowoc | school | 5507440 | 2828 | Public school | Kiel Area | 550744003130 | 800 | Between the Lakes Virtual Academy | charter | Regular School | Yes | Elementary | KG | 08 | 2021 | grade_7 | 14 | 14 | |||||||||||||||||||||||||||||||||||||||||||||||||
2334002 | 2334002 | WI | Washburn | school | 5501170 | 441 | Public school | Birchwood | 550117002800 | 450 | Birchwood Blue Hills Charter School | charter | Regular School | Yes | High | 07 | 12 | 2021 | grade_7 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
2334020 | 2334020 | WI | Washburn | school | 5501170 | 441 | Public school | Birchwood | 550117003374 | 210 | Birchwood Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 20 | 20 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2347811 | 2347811 | WI | Shawano | school | 5517100 | 6692 | Public school | Wittenberg-Birnamwood | 551710002218 | 20 | Birnamwood Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 46 | 46 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2344640 | 2344640 | WI | Outagamie | school | 5513530 | 5138 | Public school | Seymour Community | 551353001769 | 20 | Black Creek Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 35 | 35 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2334061 | 2334061 | WI | Lafayette | school | 5505730 | 2240 | Public school | Black Hawk | 550573000606 | 40 | Black Hawk Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 33 | 33 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2338989 | 2338989 | WI | Dane | school | 5508520 | 3269 | Public school | Madison Metropolitan | 550852000959 | 690 | Black Hawk Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 136 | 136 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2334070 | 2334070 | WI | Jackson | school | 5501260 | 476 | Public school | Black River Falls | 550126000174 | 60 | Black River Falls Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 130 | 130 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2334096 | 2334096 | WI | Trempealeau | school | 5500016 | 485 | Public school | Blair-Taylor | 550001602378 | 11 | Blair-Taylor Middle/High | Regular School | No | High | 07 | 12 | 2021 | grade_7 | 49 | 49 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2334115 | 2334115 | WI | Chippewa | school | 5501350 | 497 | Public school | Bloomer | 550135000185 | 60 | Bloomer Middle | Regular School | No | Middle | 05 | 08 | 2021 | grade_7 | 99 | 99 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2343553 | 2343553 | WI | Crawford | school | 5512150 | 4543 | Public school | Prairie du Chien Area | 551215002844 | 300 | Bluff View Junior High | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 66 | 66 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2334041 | 2334041 | WI | Washburn | school | 5501170 | 441 | Public school | Birchwood | 550117003020 | 800 | Bobcat Virtual Academy | charter | Regular School | Yes | Other | KG | 12 | 2021 | grade_7 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
2334133 | 2334133 | WI | Shawano | school | 5501470 | 602 | Public school | Bonduel | 550147002383 | 21 | Bonduel Middle | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 33 | 33 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2334151 | 2334151 | WI | Grant | school | 5501500 | 609 | Public school | Boscobel Area | 550150000194 | 60 | Boscobel Junior High | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 50 | 50 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2334166 | 2334166 | WI | Shawano | school | 5501560 | 623 | Public school | Bowler | 550156000200 | 40 | Bowler High | Regular School | No | High | 07 | 12 | 2021 | grade_7 | 26 | 26 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2334182 | 2334182 | WI | Dunn | school | 5501590 | 637 | Public school | Boyceville Community | 550159002460 | 200 | Boyceville Middle | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 64 | 64 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2344401 | 2344401 | WI | Fond du Lac | school | 5513100 | 4956 | Public school | Rosendale-Brandon | 551310001728 | 30 | Brandon Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 36 | 36 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2339994 | 2339994 | WI | Lincoln | school | 5509210 | 3500 | Public school | Merrill Area | 550921002927 | 800 | Bridges Virtual Academy | charter | Regular School | Yes | Other | PK | 12 | 2021 | grade_7 | 74 | 74 | |||||||||||||||||||||||||||||||||||||||||||||||||
2334201 | 2334201 | WI | Kenosha | school | 5501650 | 657 | Public school | Brighton #1 | 550165000205 | 20 | Brighton Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 21 | 21 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2334221 | 2334221 | WI | Calumet | school | 5501680 | 658 | Public school | Brillion | 550168002384 | 21 | Brillion Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 68 | 68 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2334230 | 2334230 | WI | Kenosha | school | 5501710 | 665 | Public school | Bristol #1 | 550171000209 | 20 | Bristol Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 82 | 82 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2334242 | 2334242 | WI | Green | school | 5501740 | 700 | Public school | Brodhead | 550174000213 | 60 | Brodhead Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 74 | 74 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2337940 | 2337940 | WI | Kenosha | school | 5507320 | 2793 | Public school | Kenosha | 550732001285 | 65 | Brompton School | charter | Regular School | Yes | Elementary | KG | 08 | 2021 | grade_7 | 26 | 26 | |||||||||||||||||||||||||||||||||||||||||||||||||
2342589 | 2342589 | WI | Monroe | school | 5510770 | 3990 | Public school | Norwalk-Ontario-Wilton | 551077001402 | 20 | Brookwood High | Regular School | No | High | 07 | 12 | 2021 | grade_7 | 45 | 45 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2336376 | 2336376 | WI | Walworth | school | 5505130 | 2051 | Public school | Genoa City J2 | 550513002327 | 200 | Brookwood Middle | Regular School | No | Middle | 04 | 08 | 2021 | grade_7 | 61 | 61 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2334266 | 2334266 | WI | Milwaukee | school | 5501800 | 721 | Public school | Brown Deer | 550180000230 | 40 | Brown Deer Middle/High | Regular School | No | High | 06 | 12 | 2021 | grade_7 | 109 | 109 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2334293 | 2334293 | WI | Milwaukee | school | 5500059 | 8123 | Non District Charter Schools | Bruce Guadalupe | 550005900772 | 100 | Bruce Guadalupe | charter | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_7 | 128 | 128 | |||||||||||||||||||||||||||||||||||||||||||||||||
2334283 | 2334283 | WI | Rusk | school | 5501830 | 735 | Public school | Bruce | 550183001222 | 210 | Bruce Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 34 | 34 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2337945 | 2337945 | WI | Kenosha | school | 5507320 | 2793 | Public school | Kenosha | 550732000802 | 70 | Bullen Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 274 | 274 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2340342 | 2340342 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001135 | 95 | Burbank Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 64 | 64 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2340353 | 2340353 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001136 | 98 | Burdick Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 75 | 75 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2346471 | 2346471 | WI | Waukesha | school | 5515780 | 6174 | Public school | Waukesha | 551578002008 | 100 | Butler Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 271 | 271 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2334369 | 2334369 | WI | Ashland | school | 5501920 | 840 | Public school | Butternut | 550192000246 | 40 | Butternut High | Regular School | No | High | 06 | 12 | 2021 | grade_7 | 18 | 18 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2334389 | 2334389 | WI | Chippewa | school | 5502040 | 870 | Public school | Cadott Community | 550204000249 | 60 | Cadott Junior High | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 58 | 58 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2334419 | 2334419 | WI | Columbia | school | 5502070 | 882 | Public school | Cambria-Friesland | 550207000250 | 40 | Cambria Friesland Middle/High | Regular School | No | High | 06 | 12 | 2021 | grade_7 | 27 | 27 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2334457 | 2334457 | WI | Barron | school | 5502130 | 903 | Public school | Cameron | 550213002851 | 800 | Cameron Academy of Virtual Education | charter | Alternative School | Yes | Other | PK | 12 | 2021 | grade_7 | 16 | 16 | |||||||||||||||||||||||||||||||||||||||||||||||||
2334478 | 2334478 | WI | Barron | school | 5502130 | 903 | Public school | Cameron | 550213002286 | 200 | Cameron Middle | Regular School | No | Middle | 05 | 08 | 2021 | grade_7 | 74 | 74 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2334499 | 2334499 | WI | Fond du Lac | school | 5502160 | 910 | Public school | Campbellsport | 550216002484 | 300 | Campbellsport Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 118 | 118 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2340369 | 2340369 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960003071 | 213 | Carmen Middle School of Science and Technology South Campus | charter | Regular School | Yes | Middle | 06 | 08 | 2021 | grade_7 | 71 | 71 | |||||||||||||||||||||||||||||||||||||||||||||||||
2340376 | 2340376 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002980 | 444 | Carmen Middle/High School of Science and Technology Northwest Campus | charter | Regular School | Yes | High | 06 | 12 | 2021 | grade_7 | 94 | 94 | |||||||||||||||||||||||||||||||||||||||||||||||||
2340386 | 2340386 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001829 | 108 | Carson Academy | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 40 | 40 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2340398 | 2340398 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002602 | 178 | Carver Academy | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 59 | 59 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2334524 | 2334524 | WI | Monroe | school | 5502340 | 980 | Public school | Cashton | 550234000263 | 40 | Cashton Middle/High | Regular School | No | High | 06 | 12 | 2021 | grade_7 | 46 | 46 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2340409 | 2340409 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001139 | 104 | Cass Street Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 35 | 35 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2334540 | 2334540 | WI | Grant | school | 5502400 | 994 | Public school | Cassville | 550240000265 | 40 | Cassville High | Regular School | No | High | 07 | 12 | 2021 | grade_7 | 11 | 11 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2344231 | 2344231 | WI | Fond du Lac | school | 5513020 | 4872 | Public school | Ripon Area | 551302002930 | 200 | Catalyst Charter Middle | charter | Regular School | Yes | Middle | 06 | 08 | 2021 | grade_7 | 30 | 30 | |||||||||||||||||||||||||||||||||||||||||||||||||
2334559 | 2334559 | WI | Sheboygan | school | 5502430 | 1029 | Public school | Cedar Grove-Belgium Area | 550243001629 | 200 | Cedar Grove-Belgium Middle | Regular School | No | Middle | 05 | 08 | 2021 | grade_7 | 65 | 65 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2334605 | 2334605 | WI | Milwaukee | school | 5500041 | 8105 | Non District Charter Schools | Central City Cyberschool | 550004102171 | 1211 | Central City Cyberschool | charter | Regular School | Yes | Other | PK | 11 | 2021 | grade_7 | 40 | 40 | |||||||||||||||||||||||||||||||||||||||||||||||||
2337104 | 2337104 | WI | Washington | school | 5506090 | 2443 | Public school | Hartford J1 | 550609000674 | 20 | Central Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 195 | 195 |
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]);