enrollments
Data source: Big Local News · About: Big Local
657 rows where grade = "grade_7", state = "WI" and year = 2018 sorted by county
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3088685 | 3088685 | WI | Adams | school | 5500060 | 14 | Public school | Adams-Friendship Area | 550006001454 | 210 | Adams-Friendship Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 106 | 106 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3089200 | 3089200 | WI | Ashland | school | 5500510 | 170 | Public school | Ashland | 550051000074 | 30 | Ashland Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 128 | 128 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3089230 | 3089230 | WI | Ashland | school | 5500510 | 170 | Public school | Ashland | 550051002986 | 250 | Oredocker Project School | charter | Regular School | Yes | Middle | 06 | 08 | 2018 | grade_7 | 20 | 20 | |||||||||||||||||||||||||||||||||||||||||||||||||
3090124 | 3090124 | WI | Ashland | school | 5501920 | 840 | Public school | Butternut | 550192000246 | 40 | Butternut High | Regular School | No | High | 06 | 12 | 2018 | grade_7 | 13 | 13 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3095318 | 3095318 | WI | Ashland | school | 5508970 | 3427 | Public school | Mellen | 550897002941 | 800 | Mellen Public School | Regular School | No | Other | PK | 12 | 2018 | grade_7 | 29 | 29 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3089426 | 3089426 | WI | Barron | school | 5500870 | 308 | Public school | Barron Area | 550087002864 | 810 | Advanced Learning Academy of Wisconsin | charter | Regular School | Yes | Other | KG | 12 | 2018 | grade_7 | 2 | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||
3089458 | 3089458 | WI | Barron | school | 5500870 | 308 | Public school | Barron Area | 550087000118 | 140 | Riverview Middle | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 93 | 93 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3090193 | 3090193 | WI | Barron | school | 5502130 | 903 | Public school | Cameron | 550213002851 | 800 | Cameron Academy of Virtual Education | charter | Alternative School | Yes | Other | PK | 12 | 2018 | grade_7 | 3 | 3 | |||||||||||||||||||||||||||||||||||||||||||||||||
3090213 | 3090213 | WI | Barron | school | 5502130 | 903 | Public school | Cameron | 550213002286 | 200 | Cameron Middle | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 71 | 71 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3090396 | 3090396 | WI | Barron | school | 5500061 | 1080 | Public school | Chetek-Weyerhaeuser Area | 550006102806 | 200 | Chetek-Weyerhaeuser Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 62 | 62 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3090417 | 3090417 | WI | Barron | school | 5500061 | 1080 | Public school | Chetek-Weyerhaeuser Area | 550006102897 | 800 | Link2Learn Virtual Charter School | charter | Regular School | Yes | Other | PK | 12 | 2018 | grade_7 | 2 | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||
3090804 | 3090804 | WI | Barron | school | 5503090 | 1260 | Public school | Cumberland | 550309000304 | 50 | Cumberland Middle | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 54 | 54 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3090810 | 3090810 | WI | Barron | school | 5503090 | 1260 | Public school | Cumberland | 550309002962 | 420 | Island City Academy | charter | Career and Technical School | Yes | High | 07 | 12 | 2018 | grade_7 | 7 | 7 | |||||||||||||||||||||||||||||||||||||||||||||||||
3099135 | 3099135 | WI | Barron | school | 5512180 | 4557 | Public school | Prairie Farm Public | 551218000445 | 30 | Prairie Farm Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 26 | 26 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3099705 | 3099705 | WI | Barron | school | 5512810 | 4802 | Public school | Rice Lake Area | 551281001697 | 140 | Rice Lake Middle | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 150 | 150 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3101490 | 3101490 | WI | Barron | school | 5515060 | 5810 | Public school | Turtle Lake | 551506003068 | 30 | Turtle Lake Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 30 | 30 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3089482 | 3089482 | WI | Bayfield | school | 5500900 | 315 | Public school | Bayfield | 550090000082 | 30 | Bayfield Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 30 | 30 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3091174 | 3091174 | WI | Bayfield | school | 5503810 | 1491 | Public school | Drummond Area | 550381000397 | 50 | Drummond Junior High | Regular School | No | Middle | 07 | 08 | 2018 | grade_7 | 30 | 30 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3100676 | 3100676 | WI | Bayfield | school | 5512030 | 4522 | Public school | South Shore | 551203001574 | 100 | South Shore Jr/Sr High | Regular School | No | High | 07 | 12 | 2018 | grade_7 | 16 | 16 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3101750 | 3101750 | WI | Bayfield | school | 5515540 | 6027 | Public school | Washburn | 551554001984 | 20 | Washburn Middle | Regular School | No | Middle | 07 | 08 | 2018 | grade_7 | 38 | 38 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3089243 | 3089243 | WI | Brown | school | 5500540 | 182 | Public school | Ashwaubenon | 550054000083 | 45 | Parkview Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 244 | 244 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3090963 | 3090963 | WI | Brown | school | 5503210 | 1414 | Public school | De Pere | 550321000362 | 30 | De Pere Middle | Regular School | No | Middle | 07 | 08 | 2018 | grade_7 | 315 | 315 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3091070 | 3091070 | WI | Brown | school | 5503660 | 1407 | Public school | Denmark | 550366002936 | 450 | Denmark Community School | charter | Regular School | Yes | High | 07 | 12 | 2018 | grade_7 | 4 | 4 | |||||||||||||||||||||||||||||||||||||||||||||||||
3091090 | 3091090 | WI | Brown | school | 5503660 | 1407 | Public school | Denmark | 550366000389 | 100 | Denmark Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 126 | 126 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3092315 | 3092315 | 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 | 2018 | grade_7 | 55 | 55 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3092381 | 3092381 | WI | Brown | school | 5505820 | 2289 | Public school | Green Bay Area Public | 550582003009 | 800 | Dr Rosa Minoka-Hill School | Alternative School | No | Other | PK | 12 | 2018 | grade_7 | 2 | 2 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3092395 | 3092395 | WI | Brown | school | 5505820 | 2289 | Public school | Green Bay Area Public | 550582000619 | 190 | Edison Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 399 | 399 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3092421 | 3092421 | WI | Brown | school | 5505820 | 2289 | Public school | Green Bay Area Public | 550582000623 | 300 | Franklin Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 210 | 210 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3092504 | 3092504 | WI | Brown | school | 5505820 | 2289 | Public school | Green Bay Area Public | 550582002955 | 150 | Leonardo da Vinci School for Gifted Learners | Regular School | No | Elementary | KG | 08 | 2018 | grade_7 | 39 | 39 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3092517 | 3092517 | WI | Brown | school | 5505820 | 2289 | Public school | Green Bay Area Public | 550582000631 | 425 | Lombardi Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 263 | 263 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3092564 | 3092564 | WI | Brown | school | 5505820 | 2289 | Public school | Green Bay Area Public | 550582001672 | 160 | Red Smith K-8 | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 157 | 157 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3092591 | 3092591 | WI | Brown | school | 5505820 | 2289 | Public school | Green Bay Area Public | 550582000641 | 660 | Washington Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 235 | 235 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3093061 | 3093061 | WI | Brown | school | 5506630 | 2604 | Public school | Howard-Suamico | 550663000717 | 30 | Bay View Middle | Regular School | No | Middle | 07 | 08 | 2018 | grade_7 | 447 | 447 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3099236 | 3099236 | WI | Brown | school | 5512330 | 4613 | Public school | Pulaski Community | 551233001888 | 200 | Pulaski Community Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 291 | 291 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3102717 | 3102717 | WI | Brown | school | 5516320 | 6328 | Public school | West De Pere | 551632002752 | 400 | Phantom Knight School of Opportunity | charter | Regular School | Yes | High | 07 | 12 | 2018 | grade_7 | 2 | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||
3102727 | 3102727 | WI | Brown | school | 5516320 | 6328 | Public school | West De Pere | 551632000545 | 110 | West De Pere Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 244 | 244 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3103326 | 3103326 | WI | Brown | school | 5517190 | 6734 | Public school | Wrightstown Community | 551719000280 | 30 | Wrightstown Middle | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 96 | 96 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3088745 | 3088745 | WI | Buffalo | school | 5500180 | 84 | Public school | Alma | 550018000017 | 20 | Alma Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 17 | 17 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3090583 | 3090583 | WI | Buffalo | school | 5502700 | 1155 | Public school | Cochrane-Fountain City | 550270000307 | 40 | Cochrane-Fountain City High | Regular School | No | High | 07 | 12 | 2018 | grade_7 | 42 | 42 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3092179 | 3092179 | WI | Buffalo | school | 5505370 | 2142 | Public school | Gilmanton | 550537002907 | 250 | Gilmanton Middle | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 11 | 11 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3097284 | 3097284 | WI | Buffalo | school | 5509780 | 3668 | Public school | Mondovi | 550978000383 | 120 | Mondovi Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 82 | 82 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3092294 | 3092294 | WI | Burnett | school | 5505670 | 2233 | Public school | Grantsburg | 550567000603 | 100 | Grantsburg Middle | Regular School | No | Middle | 04 | 08 | 2018 | grade_7 | 66 | 66 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3092301 | 3092301 | WI | Burnett | school | 5505670 | 2233 | Public school | Grantsburg | 550567002704 | 400 | iForward | charter | Regular School | Yes | High | 06 | 12 | 2018 | grade_7 | 26 | 26 | |||||||||||||||||||||||||||||||||||||||||||||||||
3100547 | 3100547 | WI | Burnett | school | 5513890 | 5376 | Public school | Siren | 551389001817 | 40 | Siren High | Regular School | No | High | 06 | 12 | 2018 | grade_7 | 35 | 35 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3102515 | 3102515 | WI | Burnett | school | 5516230 | 6293 | Public school | Webster | 551623002100 | 100 | Webster Middle | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 57 | 57 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3089990 | 3089990 | WI | Calumet | school | 5501680 | 658 | Public school | Brillion | 550168002384 | 21 | Brillion Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 76 | 76 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3090440 | 3090440 | WI | Calumet | school | 5502520 | 1085 | Public school | Chilton | 550252002430 | 30 | Chilton Middle | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 87 | 87 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3092928 | 3092928 | WI | Calumet | school | 5506450 | 2534 | Public school | Hilbert | 550645001458 | 200 | Hilbert Middle | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 46 | 46 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3097822 | 3097822 | WI | Calumet | school | 5510530 | 3941 | Public school | New Holstein | 551053002550 | 200 | New Holstein Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 82 | 82 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3100976 | 3100976 | WI | Calumet | school | 5514520 | 5614 | Public school | Stockbridge | 551452002499 | 200 | Stockbridge Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 15 | 15 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3089885 | 3089885 | WI | Chippewa | school | 5501350 | 497 | Public school | Bloomer | 550135000185 | 60 | Bloomer Middle | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 92 | 92 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3090146 | 3090146 | WI | Chippewa | school | 5502040 | 870 | Public school | Cadott Community | 550204000249 | 60 | Cadott Junior High | Regular School | No | Middle | 07 | 08 | 2018 | grade_7 | 61 | 61 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3090449 | 3090449 | WI | Chippewa | school | 5502550 | 1092 | Public school | Chippewa Falls Area Unified | 550255000281 | 40 | Chippewa Falls Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 356 | 356 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3090682 | 3090682 | WI | Chippewa | school | 5502880 | 1204 | Public school | Cornell | 550288002896 | 300 | Cornell Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 30 | 30 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3094310 | 3094310 | WI | Chippewa | school | 5507680 | 2891 | Public school | Lake Holcombe | 550768000885 | 20 | Holcombe Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 25 | 25 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3097735 | 3097735 | WI | Chippewa | school | 5510440 | 3920 | Public school | New Auburn | 551044001363 | 40 | New Auburn Jr-Sr High | Regular School | No | High | 07 | 12 | 2018 | grade_7 | 28 | 28 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3100853 | 3100853 | WI | Chippewa | school | 5514430 | 5593 | Public school | Stanley-Boyd Area | 551443001866 | 100 | Stanley-Boyd Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 98 | 98 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3088662 | 3088662 | WI | Clark | school | 5500030 | 7 | Public school | Abbotsford | 550003000002 | 40 | Abbotsford Middle/Senior High | Regular School | No | High | 06 | 12 | 2018 | grade_7 | 58 | 58 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3090600 | 3090600 | WI | Clark | school | 5502730 | 1162 | Public school | Colby | 550273001226 | 210 | Colby Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 69 | 69 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3092278 | 3092278 | WI | Clark | school | 5505640 | 2226 | Public school | Granton Area | 550564000600 | 40 | Granton High | Regular School | No | High | 06 | 12 | 2018 | grade_7 | 15 | 15 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3092729 | 3092729 | WI | Clark | school | 5505970 | 2394 | Public school | Greenwood | 550597000657 | 60 | Greenwood High | Regular School | No | High | 07 | 12 | 2018 | grade_7 | 39 | 39 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3094526 | 3094526 | WI | Clark | school | 5508250 | 3206 | Public school | Loyal | 550825000913 | 40 | Loyal Junior High | Regular School | No | Middle | 07 | 08 | 2018 | grade_7 | 39 | 39 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3097690 | 3097690 | WI | Clark | school | 5510350 | 3899 | Public school | Neillsville | 551035001357 | 40 | Neillsville Middle/High | Regular School | No | High | 07 | 12 | 2018 | grade_7 | 79 | 79 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3098674 | 3098674 | WI | Clark | school | 5511310 | 4207 | Public school | Owen-Withee | 551131001511 | 40 | Owen-Withee Junior High | Regular School | No | Middle | 07 | 08 | 2018 | grade_7 | 33 | 33 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3101254 | 3101254 | WI | Clark | school | 5514820 | 5726 | Public school | Thorp | 551482001925 | 20 | Thorp Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 38 | 38 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3090162 | 3090162 | WI | Columbia | school | 5502070 | 882 | Public school | Cambria-Friesland | 550207000250 | 40 | Cambria Friesland Middle/High | Regular School | No | High | 06 | 12 | 2018 | grade_7 | 22 | 22 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3090659 | 3090659 | WI | Columbia | school | 5502820 | 1183 | Public school | Columbus | 550282000319 | 20 | Columbus Middle | Regular School | No | Middle | 04 | 08 | 2018 | grade_7 | 103 | 103 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3091686 | 3091686 | WI | Columbia | school | 5504530 | 1736 | Public school | Fall River | 550453000484 | 40 | Fall River High | Regular School | No | High | 06 | 12 | 2018 | grade_7 | 38 | 38 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3094474 | 3094474 | WI | Columbia | school | 5508190 | 3150 | Public school | Lodi | 550819000906 | 100 | Lodi Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 108 | 108 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3098720 | 3098720 | WI | Columbia | school | 5511370 | 4228 | Public school | Pardeeville Area | 551137001519 | 100 | Pardeeville Middle | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 61 | 61 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3099044 | 3099044 | WI | Columbia | school | 5512060 | 4501 | Public school | Portage Community | 551206002283 | 160 | Wayne Bartels Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 179 | 179 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3099083 | 3099083 | WI | Columbia | school | 5512120 | 4536 | Public school | Poynette | 551212001581 | 100 | Poynette Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 77 | 77 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3099788 | 3099788 | WI | Columbia | school | 5512990 | 4865 | Public school | Rio Community | 551299001713 | 40 | Rio Middle/High | Regular School | No | High | 06 | 12 | 2018 | grade_7 | 32 | 32 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3097977 | 3097977 | WI | Crawford | school | 5504980 | 2016 | Public school | North Crawford | 550498002244 | 110 | North Crawford Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 24 | 24 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3099095 | 3099095 | WI | Crawford | school | 5512150 | 4543 | Public school | Prairie du Chien Area | 551215002844 | 300 | Bluff View Junior High | Regular School | No | Middle | 07 | 08 | 2018 | grade_7 | 79 | 79 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3099110 | 3099110 | WI | Crawford | school | 5512150 | 4543 | Public school | Prairie du Chien Area | 551215002944 | 800 | Mighty River Academy of Virtual Education | charter | Regular School | Yes | Other | KG | 12 | 2018 | grade_7 | 2 | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||
3100173 | 3100173 | WI | Crawford | school | 5513470 | 5124 | Public school | Seneca Area | 551347002399 | 28 | Seneca Junior High | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 25 | 25 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3102497 | 3102497 | WI | Crawford | school | 5516020 | 6251 | Public school | Wauzeka-Steuben | 551602002738 | 250 | Wauzeka Middle | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 17 | 17 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3089583 | 3089583 | WI | Dane | school | 5500990 | 350 | Public school | Belleville | 550099000133 | 60 | Belleville Middle | Regular School | No | Middle | 07 | 08 | 2018 | grade_7 | 68 | 68 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3090181 | 3090181 | WI | Dane | school | 5502100 | 896 | Public school | Cambridge | 550210000298 | 60 | Nikolay Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 66 | 66 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3090934 | 3090934 | WI | Dane | school | 5503180 | 1316 | Public school | De Forest Area | 550318000356 | 50 | De Forest Middle | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 252 | 252 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3091041 | 3091041 | WI | Dane | school | 5503270 | 1309 | Public school | Deerfield Community | 550327000372 | 60 | Deerfield Middle | Regular School | No | Middle | 07 | 08 | 2018 | grade_7 | 71 | 71 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3094575 | 3094575 | WI | Dane | school | 5508520 | 3269 | Public school | Madison Metropolitan | 550852002866 | 200 | Badger Rock Middle | charter | Regular School | Yes | Middle | 06 | 08 | 2018 | grade_7 | 21 | 21 | |||||||||||||||||||||||||||||||||||||||||||||||||
3094579 | 3094579 | WI | Dane | school | 5508520 | 3269 | Public school | Madison Metropolitan | 550852000959 | 690 | Black Hawk Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 125 | 125 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3094591 | 3094591 | WI | Dane | school | 5508520 | 3269 | Public school | Madison Metropolitan | 550852000922 | 90 | Cherokee Heights Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 184 | 184 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3094654 | 3094654 | WI | Dane | school | 5508520 | 3269 | Public school | Madison Metropolitan | 550852000966 | 810 | Hamilton Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 239 | 239 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3094680 | 3094680 | WI | Dane | school | 5508520 | 3269 | Public school | Madison Metropolitan | 550852000373 | 440 | James Wright Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 81 | 81 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3094684 | 3094684 | WI | Dane | school | 5508520 | 3269 | Public school | Madison Metropolitan | 550852000938 | 370 | Jefferson Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 171 | 171 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3094785 | 3094785 | WI | Dane | school | 5508520 | 3269 | Public school | Madison Metropolitan | 550852000949 | 540 | O'Keeffe Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 160 | 160 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3094824 | 3094824 | WI | Dane | school | 5508520 | 3269 | Public school | Madison Metropolitan | 550852000955 | 665 | Sennett Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 247 | 247 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3094833 | 3094833 | WI | Dane | school | 5508520 | 3269 | Public school | Madison Metropolitan | 550852002435 | 710 | Sherman Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 174 | 174 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3094845 | 3094845 | WI | Dane | school | 5508520 | 3269 | Public school | Madison Metropolitan | 550852000649 | 850 | Spring Harbor Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 90 | 90 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3094865 | 3094865 | WI | Dane | school | 5508520 | 3269 | Public school | Madison Metropolitan | 550852000953 | 620 | Toki Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 177 | 177 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3094881 | 3094881 | WI | Dane | school | 5508520 | 3269 | Public school | Madison Metropolitan | 550852000934 | 315 | Whitehorse Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 167 | 167 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3095099 | 3095099 | WI | Dane | school | 5508790 | 3332 | Public school | Marshall | 550879001014 | 60 | Marshall Middle | Regular School | No | Middle | 07 | 08 | 2018 | grade_7 | 84 | 84 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3095235 | 3095235 | WI | Dane | school | 5508910 | 3381 | Public school | McFarland | 550891001036 | 60 | Indian Mound Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 190 | 190 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3095265 | 3095265 | WI | Dane | school | 5508910 | 3381 | Public school | McFarland | 550891002973 | 160 | Wisconsin Virtual Academy K-8 (WIVA) | charter | Regular School | Yes | Elementary | KG | 08 | 2018 | grade_7 | 135 | 135 | |||||||||||||||||||||||||||||||||||||||||||||||||
3095621 | 3095621 | WI | Dane | school | 5509510 | 3549 | Public school | Middleton-Cross Plains Area | 550951002818 | 800 | 21st Century eSchool | charter | Regular School | Yes | Other | KG | 12 | 2018 | grade_7 | 4 | 4 | |||||||||||||||||||||||||||||||||||||||||||||||||
3095639 | 3095639 | WI | Dane | school | 5509510 | 3549 | Public school | Middleton-Cross Plains Area | 550951000754 | 50 | Glacier Creek Middle | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 267 | 267 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3095644 | 3095644 | WI | Dane | school | 5509510 | 3549 | Public school | Middleton-Cross Plains Area | 550951001104 | 30 | Kromrey Middle | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 326 | 326 |
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]);