enrollments
Data source: Big Local News · About: Big Local
680 rows where grade = "grade_7", state = "WI" and year = 2020 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2318168 | 2318168 | WI | Adams | school | 5500060 | 14 | Public school | Adams-Friendship Area | 550006001454 | 210 | Adams-Friendship Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 112 | 112 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2318654 | 2318654 | WI | Ashland | school | 5500510 | 170 | Public school | Ashland | 550051000074 | 30 | Ashland Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 154 | 154 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2318683 | 2318683 | WI | Ashland | school | 5500510 | 170 | Public school | Ashland | 550051002986 | 250 | Oredocker Project School | charter | Regular School | Yes | Middle | 06 | 08 | 2020 | grade_7 | 6 | 6 | |||||||||||||||||||||||||||||||||||||||||||||||||
2318690 | 2318690 | WI | Ashland | school | 170 | Public Schools-Multidistrict Charters | Ashland | 9100 | Rural Virtual Academy | 2020 | grade_7 | 2 | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2319588 | 2319588 | WI | Ashland | school | 5501920 | 840 | Public school | Butternut | 550192000246 | 40 | Butternut High | Regular School | No | High | 06 | 12 | 2020 | grade_7 | 10 | 10 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2324874 | 2324874 | WI | Ashland | school | 5508970 | 3427 | Public school | Mellen | 550897002941 | 800 | Mellen Public School | Regular School | No | Other | PK | 12 | 2020 | grade_7 | 19 | 19 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2318895 | 2318895 | WI | Barron | school | 5500870 | 308 | Public school | Barron Area | 550087002864 | 810 | Advanced Learning Academy of Wisconsin | charter | Regular School | Yes | Other | KG | 12 | 2020 | grade_7 | 2 | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||
2318927 | 2318927 | WI | Barron | school | 5500870 | 308 | Public school | Barron Area | 550087000118 | 140 | Riverview Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 92 | 92 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2319664 | 2319664 | WI | Barron | school | 5502130 | 903 | Public school | Cameron | 550213002851 | 800 | Cameron Academy of Virtual Education | charter | Alternative School | Yes | Other | PK | 12 | 2020 | grade_7 | 2 | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||
2319685 | 2319685 | WI | Barron | school | 5502130 | 903 | Public school | Cameron | 550213002286 | 200 | Cameron Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 96 | 96 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2319869 | 2319869 | WI | Barron | school | 5500061 | 1080 | Public school | Chetek-Weyerhaeuser Area | 550006102806 | 200 | Chetek-Weyerhaeuser Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 73 | 73 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2319890 | 2319890 | WI | Barron | school | 5500061 | 1080 | Public school | Chetek-Weyerhaeuser Area | 550006102897 | 800 | Link2Learn Virtual Charter School | charter | Regular School | Yes | Other | PK | 12 | 2020 | grade_7 | 3 | 3 | |||||||||||||||||||||||||||||||||||||||||||||||||
2320285 | 2320285 | WI | Barron | school | 5503090 | 1260 | Public school | Cumberland | 550309000304 | 50 | Cumberland Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 70 | 70 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2320301 | 2320301 | WI | Barron | school | 5503090 | 1260 | Public school | Cumberland | 550309002871 | 800 | Island City Virtual Academy | charter | Regular School | Yes | Other | PK | 12 | 2020 | grade_7 | 3 | 3 | |||||||||||||||||||||||||||||||||||||||||||||||||
2328702 | 2328702 | WI | Barron | school | 5512180 | 4557 | Public school | Prairie Farm Public | 551218000445 | 30 | Prairie Farm Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 44 | 44 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2329253 | 2329253 | WI | Barron | school | 5512810 | 4802 | Public school | Rice Lake Area | 551281001697 | 140 | Rice Lake Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 176 | 176 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331091 | 2331091 | WI | Barron | school | 5515060 | 5810 | Public school | Turtle Lake | 551506003068 | 30 | Turtle Lake Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 30 | 30 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2318952 | 2318952 | WI | Bayfield | school | 5500900 | 315 | Public school | Bayfield | 550090000082 | 30 | Bayfield Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 31 | 31 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2320656 | 2320656 | WI | Bayfield | school | 5503810 | 1491 | Public school | Drummond Area | 550381000397 | 50 | Drummond Junior High | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 23 | 23 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2330227 | 2330227 | WI | Bayfield | school | 5512030 | 4522 | Public school | South Shore | 551203001574 | 100 | South Shore Jr/Sr High | Regular School | No | High | 07 | 12 | 2020 | grade_7 | 18 | 18 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2331356 | 2331356 | WI | Bayfield | school | 5515540 | 6027 | Public school | Washburn | 551554001984 | 20 | Washburn Middle | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 42 | 42 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2318705 | 2318705 | WI | Brown | school | 5500540 | 182 | Public school | Ashwaubenon | 550054000083 | 45 | Parkview Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 262 | 262 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2320446 | 2320446 | WI | Brown | school | 5503210 | 1414 | Public school | De Pere | 550321000362 | 30 | De Pere Middle | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 336 | 336 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2320547 | 2320547 | WI | Brown | school | 5503660 | 1407 | Public school | Denmark | 550366002936 | 450 | Denmark Community School | charter | Regular School | Yes | High | 06 | 12 | 2020 | grade_7 | 2 | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||
2320566 | 2320566 | WI | Brown | school | 5503660 | 1407 | Public school | Denmark | 550366000389 | 100 | Denmark Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 116 | 116 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2321783 | 2321783 | 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 | 2020 | grade_7 | 66 | 66 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2321802 | 2321802 | WI | Brown | school | 5505820 | 2289 | Public school | Green Bay Area Public | 550582000612 | 40 | Bay View | Alternative School | No | Other | PK | 12 | 2020 | grade_7 | 3 | 3 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2321851 | 2321851 | WI | Brown | school | 5505820 | 2289 | Public school | Green Bay Area Public | 550582003009 | 800 | Dr Rosa Minoka-Hill School | Alternative School | No | Other | KG | 12 | 2020 | grade_7 | 6 | 6 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2321861 | 2321861 | WI | Brown | school | 5505820 | 2289 | Public school | Green Bay Area Public | 550582000619 | 190 | Edison Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 402 | 402 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2321891 | 2321891 | WI | Brown | school | 5505820 | 2289 | Public school | Green Bay Area Public | 550582000623 | 300 | Franklin Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 249 | 249 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2321929 | 2321929 | WI | Brown | school | 5505820 | 2289 | Public school | Green Bay Area Public | 550582002857 | 445 | John Dewey Academy of Learning | charter | Regular School | Yes | High | 06 | 12 | 2020 | grade_7 | 6 | 6 | |||||||||||||||||||||||||||||||||||||||||||||||||
2321975 | 2321975 | 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 | 2020 | grade_7 | 47 | 47 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2321988 | 2321988 | WI | Brown | school | 5505820 | 2289 | Public school | Green Bay Area Public | 550582000631 | 425 | Lombardi Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 265 | 265 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2322024 | 2322024 | WI | Brown | school | 5505820 | 2289 | Public school | Green Bay Area Public | 550582003105 | 450 | Northeast Wisconsin School of Innovation | charter | Regular School | Yes | High | 07 | 12 | 2020 | grade_7 | 14 | 14 | |||||||||||||||||||||||||||||||||||||||||||||||||
2322039 | 2322039 | WI | Brown | school | 5505820 | 2289 | Public school | Green Bay Area Public | 550582001672 | 160 | Red Smith K-8 | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 174 | 174 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2322067 | 2322067 | WI | Brown | school | 5505820 | 2289 | Public school | Green Bay Area Public | 550582000641 | 660 | Washington Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 250 | 250 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2322552 | 2322552 | WI | Brown | school | 5506630 | 2604 | Public school | Howard-Suamico | 550663000717 | 30 | Bay View Middle | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 470 | 470 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2328802 | 2328802 | WI | Brown | school | 5512330 | 4613 | Public school | Pulaski Community | 551233001888 | 200 | Pulaski Community Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 319 | 319 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332317 | 2332317 | WI | Brown | school | 5516320 | 6328 | Public school | West De Pere | 551632000545 | 110 | West De Pere Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 264 | 264 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332913 | 2332913 | WI | Brown | school | 5517190 | 6734 | Public school | Wrightstown Community | 551719000280 | 30 | Wrightstown Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 92 | 92 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2318217 | 2318217 | WI | Buffalo | school | 5500180 | 84 | Public school | Alma | 550018000017 | 20 | Alma Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 19 | 19 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2320056 | 2320056 | WI | Buffalo | school | 5502700 | 1155 | Public school | Cochrane-Fountain City | 550270000307 | 40 | Cochrane-Fountain City High | Regular School | No | High | 07 | 12 | 2020 | grade_7 | 41 | 41 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2321656 | 2321656 | WI | Buffalo | school | 5505370 | 2142 | Public school | Gilmanton | 550537002907 | 250 | Gilmanton Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 7 | 7 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2326812 | 2326812 | WI | Buffalo | school | 5509780 | 3668 | Public school | Mondovi | 550978000383 | 120 | Mondovi Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 73 | 73 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2321762 | 2321762 | WI | Burnett | school | 5505670 | 2233 | Public school | Grantsburg | 550567000603 | 100 | Grantsburg Middle | Regular School | No | Middle | 04 | 08 | 2020 | grade_7 | 60 | 60 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2321769 | 2321769 | WI | Burnett | school | 5505670 | 2233 | Public school | Grantsburg | 550567002704 | 400 | iForward | charter | Regular School | Yes | High | 06 | 12 | 2020 | grade_7 | 26 | 26 | |||||||||||||||||||||||||||||||||||||||||||||||||
2330086 | 2330086 | WI | Burnett | school | 5513890 | 5376 | Public school | Siren | 551389001817 | 40 | Siren High | Regular School | No | High | 06 | 12 | 2020 | grade_7 | 30 | 30 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332114 | 2332114 | WI | Burnett | school | 5516230 | 6293 | Public school | Webster | 551623002100 | 100 | Webster Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 56 | 56 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2319440 | 2319440 | WI | Calumet | school | 5501680 | 658 | Public school | Brillion | 550168002384 | 21 | Brillion Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 67 | 67 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2319914 | 2319914 | WI | Calumet | school | 5502520 | 1085 | Public school | Chilton | 550252002430 | 30 | Chilton Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 100 | 100 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2322404 | 2322404 | WI | Calumet | school | 5506450 | 2534 | Public school | Hilbert | 550645001458 | 200 | Hilbert Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 32 | 32 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2327373 | 2327373 | WI | Calumet | school | 5510530 | 3941 | Public school | New Holstein | 551053002550 | 200 | New Holstein Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 77 | 77 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2330538 | 2330538 | WI | Calumet | school | 5514520 | 5614 | Public school | Stockbridge | 551452002499 | 200 | Stockbridge Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 20 | 20 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2319331 | 2319331 | WI | Chippewa | school | 5501350 | 497 | Public school | Bloomer | 550135000185 | 60 | Bloomer Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 90 | 90 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2319610 | 2319610 | WI | Chippewa | school | 5502040 | 870 | Public school | Cadott Community | 550204000249 | 60 | Cadott Junior High | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 72 | 72 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2319923 | 2319923 | WI | Chippewa | school | 5502550 | 1092 | Public school | Chippewa Falls Area Unified | 550255000281 | 40 | Chippewa Falls Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 378 | 378 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2320161 | 2320161 | WI | Chippewa | school | 5502880 | 1204 | Public school | Cornell | 550288002896 | 300 | Cornell Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 23 | 23 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2323835 | 2323835 | WI | Chippewa | school | 5507680 | 2891 | Public school | Lake Holcombe | 550768000885 | 20 | Holcombe Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 23 | 23 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2327287 | 2327287 | WI | Chippewa | school | 5510440 | 3920 | Public school | New Auburn | 551044003117 | 250 | New Auburn Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 24 | 24 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2330410 | 2330410 | WI | Chippewa | school | 5514430 | 5593 | Public school | Stanley-Boyd Area | 551443001866 | 100 | Stanley-Boyd Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 86 | 86 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2318145 | 2318145 | WI | Clark | school | 5500030 | 7 | Public school | Abbotsford | 550003000002 | 40 | Abbotsford Middle/Senior High | Regular School | No | High | 06 | 12 | 2020 | grade_7 | 67 | 67 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2320073 | 2320073 | WI | Clark | school | 5502730 | 1162 | Public school | Colby | 550273001226 | 210 | Colby Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 67 | 67 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2320084 | 2320084 | WI | Clark | school | 1162 | Public Schools-Multidistrict Charters | Colby | 9100 | Rural Virtual Academy | charter | 2020 | grade_7 | 2 | 2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2321746 | 2321746 | WI | Clark | school | 5505640 | 2226 | Public school | Granton Area | 550564000600 | 40 | Granton High | Regular School | No | High | 06 | 12 | 2020 | grade_7 | 16 | 16 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2322204 | 2322204 | WI | Clark | school | 5505970 | 2394 | Public school | Greenwood | 550597000657 | 60 | Greenwood High | Regular School | No | High | 07 | 12 | 2020 | grade_7 | 27 | 27 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2324060 | 2324060 | WI | Clark | school | 5508250 | 3206 | Public school | Loyal | 550825000913 | 40 | Loyal Junior High | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 38 | 38 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2327225 | 2327225 | WI | Clark | school | 5510350 | 3899 | Public school | Neillsville | 551035002326 | 30 | Neillsville Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 62 | 62 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2328221 | 2328221 | WI | Clark | school | 5511310 | 4207 | Public school | Owen-Withee | 551131001511 | 40 | Owen-Withee Junior High | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 41 | 41 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2330847 | 2330847 | WI | Clark | school | 5514820 | 5726 | Public school | Thorp | 551482001925 | 20 | Thorp Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 42 | 42 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2319627 | 2319627 | WI | Columbia | school | 5502070 | 882 | Public school | Cambria-Friesland | 550207000250 | 40 | Cambria Friesland Middle/High | Regular School | No | High | 06 | 12 | 2020 | grade_7 | 25 | 25 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2320138 | 2320138 | WI | Columbia | school | 5502820 | 1183 | Public school | Columbus | 550282000319 | 20 | Columbus Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 91 | 91 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2321171 | 2321171 | WI | Columbia | school | 5504530 | 1736 | Public school | Fall River | 550453000484 | 40 | Fall River High | Regular School | No | High | 06 | 12 | 2020 | grade_7 | 46 | 46 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2324007 | 2324007 | WI | Columbia | school | 5508190 | 3150 | Public school | Lodi | 550819000906 | 100 | Lodi Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 113 | 113 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2328270 | 2328270 | WI | Columbia | school | 5511370 | 4228 | Public school | Pardeeville Area | 551137001519 | 100 | Pardeeville Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 80 | 80 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2328611 | 2328611 | WI | Columbia | school | 5512060 | 4501 | Public school | Portage Community | 551206002283 | 160 | Wayne Bartels Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 153 | 153 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2328651 | 2328651 | WI | Columbia | school | 5512120 | 4536 | Public school | Poynette | 551212001581 | 100 | Poynette Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 81 | 81 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2329321 | 2329321 | WI | Columbia | school | 5512990 | 4865 | Public school | Rio Community | 551299001713 | 40 | Rio Middle/High | Regular School | No | High | 06 | 12 | 2020 | grade_7 | 27 | 27 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2327525 | 2327525 | WI | Crawford | school | 5504980 | 2016 | Public school | North Crawford | 550498002244 | 110 | North Crawford Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 35 | 35 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2328663 | 2328663 | WI | Crawford | school | 5512150 | 4543 | Public school | Prairie du Chien Area | 551215002844 | 300 | Bluff View Junior High | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 91 | 91 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2328678 | 2328678 | 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 | 2020 | grade_7 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
2329712 | 2329712 | WI | Crawford | school | 5513470 | 5124 | Public school | Seneca Area | 551347002399 | 28 | Seneca Junior High | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 32 | 32 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332096 | 2332096 | WI | Crawford | school | 5516020 | 6251 | Public school | Wauzeka-Steuben | 551602002738 | 250 | Wauzeka Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 13 | 13 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2319052 | 2319052 | WI | Dane | school | 5500990 | 350 | Public school | Belleville | 550099000133 | 60 | Belleville Middle | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 67 | 67 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2319647 | 2319647 | WI | Dane | school | 5502100 | 896 | Public school | Cambridge | 550210003093 | 400 | Koshkonong Trails School | charter | Regular School | Yes | High | 07 | 12 | 2020 | grade_7 | 4 | 4 | |||||||||||||||||||||||||||||||||||||||||||||||||
2319652 | 2319652 | WI | Dane | school | 5502100 | 896 | Public school | Cambridge | 550210000298 | 60 | Nikolay Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 66 | 66 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2320417 | 2320417 | WI | Dane | school | 5503180 | 1316 | Public school | De Forest Area | 550318000356 | 50 | De Forest Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 278 | 278 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2320521 | 2320521 | WI | Dane | school | 5503270 | 1309 | Public school | Deerfield Community | 550327000372 | 60 | Deerfield Middle | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 63 | 63 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2322750 | 2322750 | WI | Dane | school | 5500082 | 8141 | Non District Charter Schools | Isthmus Montessori Academy Public | 550008203085 | 8141 | Isthmus Montessori Academy Public | charter | Regular School | Yes | Other | PK | 12 | 2020 | grade_7 | 15 | 15 | |||||||||||||||||||||||||||||||||||||||||||||||||
2324116 | 2324116 | WI | Dane | school | 5508520 | 3269 | Public school | Madison Metropolitan | 550852002866 | 200 | Badger Rock Middle | charter | Regular School | Yes | Middle | 06 | 08 | 2020 | grade_7 | 35 | 35 | |||||||||||||||||||||||||||||||||||||||||||||||||
2324120 | 2324120 | WI | Dane | school | 5508520 | 3269 | Public school | Madison Metropolitan | 550852000959 | 690 | Black Hawk Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 134 | 134 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2324137 | 2324137 | WI | Dane | school | 5508520 | 3269 | Public school | Madison Metropolitan | 550852000922 | 90 | Cherokee Heights Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 167 | 167 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2324200 | 2324200 | WI | Dane | school | 5508520 | 3269 | Public school | Madison Metropolitan | 550852000966 | 810 | Hamilton Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 270 | 270 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2324226 | 2324226 | WI | Dane | school | 5508520 | 3269 | Public school | Madison Metropolitan | 550852000373 | 440 | James Wright Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 82 | 82 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2324230 | 2324230 | WI | Dane | school | 5508520 | 3269 | Public school | Madison Metropolitan | 550852000938 | 370 | Jefferson Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 200 | 200 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2324331 | 2324331 | WI | Dane | school | 5508520 | 3269 | Public school | Madison Metropolitan | 550852000949 | 540 | O'Keeffe Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 149 | 149 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2324370 | 2324370 | WI | Dane | school | 5508520 | 3269 | Public school | Madison Metropolitan | 550852000955 | 665 | Sennett Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 218 | 218 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2324379 | 2324379 | WI | Dane | school | 5508520 | 3269 | Public school | Madison Metropolitan | 550852002435 | 710 | Sherman Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 129 | 129 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2324391 | 2324391 | WI | Dane | school | 5508520 | 3269 | Public school | Madison Metropolitan | 550852000649 | 850 | Spring Harbor Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 88 | 88 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2324411 | 2324411 | WI | Dane | school | 5508520 | 3269 | Public school | Madison Metropolitan | 550852000953 | 620 | Toki Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 211 | 211 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2324427 | 2324427 | WI | Dane | school | 5508520 | 3269 | Public school | Madison Metropolitan | 550852000934 | 315 | Whitehorse Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 171 | 171 |
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]);