enrollments
Data source: Big Local News · About: Big Local
667 rows where grade = "grade_7", state = "WI" and year = 2017 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
325604 | 325604 | 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 | 2017 | grade_7 | 57 | 57 | |||||||||||||||||||||||||||||||||||||||||||||||||
332548 | 332548 | WI | Dane | school | 5509510 | 3549 | Public school | Middleton-Cross Plains Area | 550951002818 | 800 | 21st Century eSchool | charter | Regular School | Yes | Other | KG | 12 | 2017 | grade_7 | 7 | 7 | |||||||||||||||||||||||||||||||||||||||||||||||||
330214 | 330214 | WI | Rock | school | 5507020 | 2695 | Public school | Janesville | 550702002991 | 860 | ARISE Virtual Academy | charter | Regular School | Yes | Other | KG | 12 | 2017 | grade_7 | 9 | 9 | |||||||||||||||||||||||||||||||||||||||||||||||||
325622 | 325622 | WI | Clark | school | 5500030 | 7 | Public school | Abbotsford | 550003000002 | 40 | Abbotsford Middle/Senior High | Regular School | No | Other | 06 | 12 | 2017 | grade_7 | 44 | 44 | ||||||||||||||||||||||||||||||||||||||||||||||||||
335412 | 335412 | WI | Winnebago | school | 5511190 | 4179 | Public school | Oshkosh Area | 551119003364 | 170 | Accelerated Advanced Learning Program | charter | Regular School | Yes | Elementary | 04 | 08 | 2017 | grade_7 | 15 | 15 | |||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326392 | 326392 | WI | Barron | school | 5500870 | 308 | Public school | Barron Area | 550087002864 | 810 | Advanced Learning Academy of Wisconsin | charter | Regular School | Yes | Other | KG | 12 | 2017 | grade_7 | 4 | 4 | |||||||||||||||||||||||||||||||||||||||||||||||||
325666 | 325666 | WI | Green | school | 5500120 | 63 | Public school | Albany | 550012002357 | 60 | Albany Community Middle | charter | Regular School | Yes | Middle | 06 | 08 | 2017 | grade_7 | 29 | 29 | |||||||||||||||||||||||||||||||||||||||||||||||||
332677 | 332677 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001121 | 75 | Alcott Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 30 | 30 | ||||||||||||||||||||||||||||||||||||||||||||||||||
329239 | 329239 | 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 | 2017 | grade_7 | 52 | 52 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
334621 | 334621 | WI | Wood | school | 5510380 | 3906 | Public school | Nekoosa | 551038001358 | 20 | Alexander Middle | Regular School | No | Elementary | 04 | 08 | 2017 | grade_7 | 79 | 79 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
325697 | 325697 | WI | Kewaunee | school | 5500150 | 70 | Public school | Algoma | 550015000016 | 40 | Algoma High | Regular School | No | High | 07 | 12 | 2017 | grade_7 | 47 | 47 | ||||||||||||||||||||||||||||||||||||||||||||||||||
325707 | 325707 | WI | Buffalo | school | 5500180 | 84 | Public school | Alma | 550018000017 | 20 | Alma Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 21 | 21 | ||||||||||||||||||||||||||||||||||||||||||||||||||
325745 | 325745 | WI | Portage | school | 5500240 | 105 | Public school | Almond-Bancroft | 550024000024 | 40 | Almond High | Regular School | No | Other | 06 | 12 | 2017 | grade_7 | 41 | 41 | ||||||||||||||||||||||||||||||||||||||||||||||||||
325769 | 325769 | WI | Eau Claire | school | 5500270 | 112 | Public school | Altoona | 550027000027 | 60 | Altoona Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 117 | 117 | ||||||||||||||||||||||||||||||||||||||||||||||||||
325782 | 325782 | WI | Polk | school | 5500300 | 119 | Public school | Amery | 550030000031 | 60 | Amery Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 116 | 116 | ||||||||||||||||||||||||||||||||||||||||||||||||||
338355 | 338355 | WI | Portage | school | 5500330 | 126 | Public school | Tomorrow River | 550033000034 | 80 | Amherst Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 74 | 74 | ||||||||||||||||||||||||||||||||||||||||||||||||||
325797 | 325797 | WI | Langlade | school | 5500360 | 140 | Public school | Antigo Unified | 550036000036 | 50 | Antigo Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 178 | 178 | ||||||||||||||||||||||||||||||||||||||||||||||||||
340227 | 340227 | WI | Vilas | school | 5517160 | 6720 | Public school | Woodruff J1 | 551716002227 | 20 | Arbor Vitae-Woodruff Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 59 | 59 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326134 | 326134 | WI | Trempealeau | school | 5500420 | 154 | Public school | Arcadia | 550042003041 | 290 | Arcadia Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 89 | 89 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326150 | 326150 | WI | Lafayette | school | 5500450 | 161 | Public school | Argyle | 550045000070 | 40 | Argyle High | Regular School | No | Other | 06 | 12 | 2017 | grade_7 | 29 | 29 | ||||||||||||||||||||||||||||||||||||||||||||||||||
335729 | 335729 | WI | Waukesha | school | 5511640 | 4312 | Public school | Pewaukee | 551164001538 | 100 | Asa Clark Middle | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 201 | 201 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326238 | 326238 | WI | Marathon | school | 5500570 | 196 | Public school | Athens | 550057000088 | 60 | Athens Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 16 | 16 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326253 | 326253 | WI | Wood | school | 5500600 | 203 | Public school | Auburndale | 550060000091 | 60 | Auburndale High | Regular School | No | Other | 06 | 12 | 2017 | grade_7 | 61 | 61 | ||||||||||||||||||||||||||||||||||||||||||||||||||
332708 | 332708 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001123 | 41 | Audubon Technology and Communication Middle School | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 184 | 184 | ||||||||||||||||||||||||||||||||||||||||||||||||||
332717 | 332717 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001124 | 77 | Auer Avenue Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 22 | 22 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326278 | 326278 | WI | Eau Claire | school | 5500630 | 217 | Public school | Augusta | 550063002585 | 200 | Augusta Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 36 | 36 | ||||||||||||||||||||||||||||||||||||||||||||||||||
339566 | 339566 | WI | Washington | school | 5516290 | 6307 | Public school | West Bend | 551629002125 | 10 | Badger Middle | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 500 | 500 | ||||||||||||||||||||||||||||||||||||||||||||||||||
338530 | 338530 | WI | Dane | school | 5515330 | 5901 | Public school | Verona Area | 551533001973 | 120 | Badger Ridge Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 176 | 176 | ||||||||||||||||||||||||||||||||||||||||||||||||||
331499 | 331499 | WI | Dane | school | 5508520 | 3269 | Public school | Madison Metropolitan | 550852002866 | 200 | Badger Rock Middle | charter | Regular School | Yes | Middle | 06 | 08 | 2017 | grade_7 | 36 | 36 | |||||||||||||||||||||||||||||||||||||||||||||||||
326318 | 326318 | WI | La Crosse | school | 5500780 | 245 | Public school | Bangor | 550078000101 | 40 | Bangor Middle/High | Regular School | No | Other | 06 | 12 | 2017 | grade_7 | 53 | 53 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326379 | 326379 | WI | Iowa | school | 5500840 | 287 | Public school | Barneveld | 550084000112 | 40 | Barneveld High | Regular School | No | Other | 06 | 12 | 2017 | grade_7 | 25 | 25 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
334446 | 334446 | WI | Waukesha | school | 5510170 | 3857 | Public school | Muskego-Norway | 551017001330 | 10 | Bay Lane Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 174 | 174 | ||||||||||||||||||||||||||||||||||||||||||||||||||
329991 | 329991 | WI | Brown | school | 5506630 | 2604 | Public school | Howard-Suamico | 550663000717 | 30 | Bay View Middle | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 455 | 455 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326453 | 326453 | WI | Bayfield | school | 5500900 | 315 | Public school | Bayfield | 550090000082 | 30 | Bayfield Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 26 | 26 | ||||||||||||||||||||||||||||||||||||||||||||||||||
335262 | 335262 | WI | Oconto | school | 5510920 | 4067 | Public school | Oconto Unified | 551092002977 | 200 | Bayshore Community Academy | charter | Regular School | Yes | Middle | 05 | 08 | 2017 | grade_7 | 21 | 21 | |||||||||||||||||||||||||||||||||||||||||||||||||
328825 | 328825 | WI | Milwaukee | school | 5504800 | 1890 | Public school | Fox Point J2 | 550480000517 | 20 | Bayside Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 94 | 94 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326468 | 326468 | WI | Dodge | school | 5500960 | 336 | Public school | Beaver Dam Unified | 550096000122 | 20 | Beaver Dam Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 235 | 235 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326554 | 326554 | WI | Dane | school | 5500990 | 350 | Public school | Belleville | 550099000133 | 60 | Belleville Middle | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 68 | 68 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326570 | 326570 | WI | Lafayette | school | 5501020 | 364 | Public school | Belmont Community | 550102000135 | 40 | Belmont High | Regular School | No | Other | 06 | 12 | 2017 | grade_7 | 33 | 33 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326586 | 326586 | WI | Rock | school | 5501050 | 413 | Public school | Beloit | 550105002974 | 421 | Beloit Learning Academy | Alternative School | No | Other | 06 | 12 | 2017 | grade_7 | 3 | 3 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
337812 | 337812 | WI | Portage | school | 5514490 | 5607 | Public school | Stevens Point Area Public | 551449001868 | 10 | Benjamin Franklin Junior High | Regular School | No | Other | 07 | 09 | 2017 | grade_7 | 277 | 277 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326700 | 326700 | WI | Lafayette | school | 5501110 | 427 | Public school | Benton | 550111000161 | 40 | Benton High | Regular School | No | High | 07 | 12 | 2017 | grade_7 | 15 | 15 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
334911 | 334911 | WI | Fond du Lac | school | 5510740 | 3983 | Public school | North Fond du Lac | 551074001396 | 20 | Bessie Allen Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 93 | 93 | ||||||||||||||||||||||||||||||||||||||||||||||||||
332759 | 332759 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001256 | 356 | Bethune Academy | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 60 | 60 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||
326752 | 326752 | WI | Washburn | school | 5501170 | 441 | Public school | Birchwood | 550117003374 | 210 | Birchwood Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 30 | 30 | ||||||||||||||||||||||||||||||||||||||||||||||||||
340162 | 340162 | WI | Shawano | school | 5517100 | 6692 | Public school | Wittenberg-Birnamwood | 551710002218 | 20 | Birnamwood Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 42 | 42 | ||||||||||||||||||||||||||||||||||||||||||||||||||
337142 | 337142 | WI | Outagamie | school | 5513530 | 5138 | Public school | Seymour Community | 551353001769 | 20 | Black Creek Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 34 | 34 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326779 | 326779 | WI | Lafayette | school | 5505730 | 2240 | Public school | Black Hawk | 550573000606 | 40 | Black Hawk Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 18 | 18 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326814 | 326814 | WI | Trempealeau | school | 5500016 | 485 | Public school | Blair-Taylor | 550001602378 | 11 | Blair-Taylor Middle/High | Regular School | No | High | 07 | 12 | 2017 | grade_7 | 40 | 40 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326840 | 326840 | WI | Chippewa | school | 5501350 | 497 | Public school | Bloomer | 550135000185 | 60 | Bloomer Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 70 | 70 | ||||||||||||||||||||||||||||||||||||||||||||||||||
336014 | 336014 | WI | Crawford | school | 5512150 | 4543 | Public school | Prairie du Chien Area | 551215002844 | 300 | Bluff View Junior High | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 85 | 85 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326858 | 326858 | WI | Shawano | school | 5501470 | 602 | Public school | Bonduel | 550147002383 | 21 | Bonduel Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 52 | 52 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326876 | 326876 | WI | Grant | school | 5501500 | 609 | Public school | Boscobel Area | 550150000194 | 60 | Boscobel Junior High | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 55 | 55 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326891 | 326891 | WI | Shawano | school | 5501560 | 623 | Public school | Bowler | 550156000200 | 40 | Bowler High | Regular School | No | High | 07 | 12 | 2017 | grade_7 | 23 | 23 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326900 | 326900 | WI | Dunn | school | 5501590 | 637 | Public school | Boyceville Community | 550159002460 | 200 | Boyceville Middle | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 52 | 52 | ||||||||||||||||||||||||||||||||||||||||||||||||||
336896 | 336896 | WI | Fond du Lac | school | 5513100 | 4956 | Public school | Rosendale-Brandon | 551310001728 | 30 | Brandon Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 29 | 29 | ||||||||||||||||||||||||||||||||||||||||||||||||||
332480 | 332480 | WI | Lincoln | school | 5509210 | 3500 | Public school | Merrill Area | 550921002927 | 800 | Bridges Virtual Academy | charter | Regular School | Yes | Other | PK | 12 | 2017 | grade_7 | 61 | 61 | |||||||||||||||||||||||||||||||||||||||||||||||||
326919 | 326919 | WI | Kenosha | school | 5501650 | 657 | Public school | Brighton #1 | 550165000205 | 20 | Brighton Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 23 | 23 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326937 | 326937 | WI | Calumet | school | 5501680 | 658 | Public school | Brillion | 550168002384 | 21 | Brillion Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 70 | 70 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326946 | 326946 | WI | Kenosha | school | 5501710 | 665 | Public school | Bristol #1 | 550171000209 | 20 | Bristol Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 74 | 74 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326958 | 326958 | WI | Green | school | 5501740 | 700 | Public school | Brodhead | 550174000213 | 60 | Brodhead Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 86 | 86 | ||||||||||||||||||||||||||||||||||||||||||||||||||
330495 | 330495 | WI | Kenosha | school | 5507320 | 2793 | Public school | Kenosha | 550732001285 | 65 | Brompton School | charter | Regular School | Yes | Elementary | KG | 08 | 2017 | grade_7 | 27 | 27 | |||||||||||||||||||||||||||||||||||||||||||||||||
335061 | 335061 | WI | Monroe | school | 5510770 | 3990 | Public school | Norwalk-Ontario-Wilton | 551077001402 | 20 | Brookwood High | Regular School | No | High | 07 | 12 | 2017 | grade_7 | 48 | 48 | ||||||||||||||||||||||||||||||||||||||||||||||||||
328992 | 328992 | WI | Walworth | school | 5505130 | 2051 | Public school | Genoa City J2 | 550513002327 | 200 | Brookwood Middle | Regular School | No | Elementary | 04 | 08 | 2017 | grade_7 | 49 | 49 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||
327002 | 327002 | WI | Rusk | school | 5501830 | 735 | Public school | Bruce | 550183001222 | 210 | Bruce Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 35 | 35 | ||||||||||||||||||||||||||||||||||||||||||||||||||
330500 | 330500 | WI | Kenosha | school | 5507320 | 2793 | Public school | Kenosha | 550732000802 | 70 | Bullen Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 227 | 227 | ||||||||||||||||||||||||||||||||||||||||||||||||||
332812 | 332812 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001135 | 95 | Burbank Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 64 | 64 | ||||||||||||||||||||||||||||||||||||||||||||||||||
332824 | 332824 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001136 | 98 | Burdick Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 60 | 60 | ||||||||||||||||||||||||||||||||||||||||||||||||||
332836 | 332836 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002498 | 109 | Business and Economics Academy of Milwaukee | charter | Regular School | Yes | Elementary | PK | 08 | 2017 | grade_7 | 66 | 66 | |||||||||||||||||||||||||||||||||||||||||||||||||
338840 | 338840 | WI | Waukesha | school | 5515780 | 6174 | Public school | Waukesha | 551578002008 | 100 | Butler Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 305 | 305 | ||||||||||||||||||||||||||||||||||||||||||||||||||
327071 | 327071 | WI | Ashland | school | 5501920 | 840 | Public school | Butternut | 550192000246 | 40 | Butternut High | Regular School | No | Other | 06 | 12 | 2017 | grade_7 | 15 | 15 | ||||||||||||||||||||||||||||||||||||||||||||||||||
337816 | 337816 | WI | Portage | school | 5514490 | 5607 | Public school | Stevens Point Area Public | 551449002210 | 360 | CARE Concerned About Reaching Everyone | charter | Alternative School | Yes | Other | 07 | 09 | 2017 | grade_7 | 6 | 6 | |||||||||||||||||||||||||||||||||||||||||||||||||
327090 | 327090 | WI | Chippewa | school | 5502040 | 870 | Public school | Cadott Community | 550204000249 | 60 | Cadott Junior High | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 60 | 60 | ||||||||||||||||||||||||||||||||||||||||||||||||||
327106 | 327106 | WI | Columbia | school | 5502070 | 882 | Public school | Cambria-Friesland | 550207000250 | 40 | Cambria Friesland Middle/High | Regular School | No | Other | 06 | 12 | 2017 | grade_7 | 34 | 34 | ||||||||||||||||||||||||||||||||||||||||||||||||||
327137 | 327137 | WI | Barron | school | 5502130 | 903 | Public school | Cameron | 550213002851 | 800 | Cameron Academy of Virtual Education | charter | Alternative School | Yes | Other | KG | 12 | 2017 | grade_7 | 5 | 5 | |||||||||||||||||||||||||||||||||||||||||||||||||
327156 | 327156 | WI | Barron | school | 5502130 | 903 | Public school | Cameron | 550213002286 | 200 | Cameron Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 72 | 72 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
327195 | 327195 | WI | Milwaukee | school | 5500114 | 8114 | Non District Charter Schools | Capitol West Academy | 550011403355 | 100 | Capitol West Academy | charter | Regular School | Yes | Elementary | PK | 08 | 2017 | grade_7 | 25 | 25 | |||||||||||||||||||||||||||||||||||||||||||||||||
332852 | 332852 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002980 | 444 | Carmen Middle/High School of Science and Technology Northwest Campus | charter | Regular School | Yes | Other | 06 | 12 | 2017 | grade_7 | 70 | 70 | |||||||||||||||||||||||||||||||||||||||||||||||||
332862 | 332862 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001829 | 108 | Carson Academy | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 47 | 47 | ||||||||||||||||||||||||||||||||||||||||||||||||||
332874 | 332874 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002602 | 178 | Carver Academy | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 53 | 53 | ||||||||||||||||||||||||||||||||||||||||||||||||||
327213 | 327213 | WI | Monroe | school | 5502340 | 980 | Public school | Cashton | 550234000263 | 40 | Cashton Middle/High | Regular School | No | Other | 06 | 12 | 2017 | grade_7 | 41 | 41 | ||||||||||||||||||||||||||||||||||||||||||||||||||
332886 | 332886 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001139 | 104 | Cass Street Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 42 | 42 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
336729 | 336729 | WI | Fond du Lac | school | 5513020 | 4872 | Public school | Ripon Area | 551302002930 | 200 | Catalyst Charter Middle | charter | Regular School | Yes | Middle | 06 | 08 | 2017 | grade_7 | 41 | 41 | |||||||||||||||||||||||||||||||||||||||||||||||||
327249 | 327249 | WI | Sheboygan | school | 5502430 | 1029 | Public school | Cedar Grove-Belgium Area | 550243001629 | 200 | Cedar Grove-Belgium Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 74 | 74 | ||||||||||||||||||||||||||||||||||||||||||||||||||
327293 | 327293 | WI | Milwaukee | school | 5500041 | 8105 | Non District Charter Schools | Central City Cyberschool | 550004102171 | 1211 | Central City Cyberschool | charter | Regular School | Yes | Elementary | PK | 08 | 2017 | grade_7 | 49 | 49 | |||||||||||||||||||||||||||||||||||||||||||||||||
329718 | 329718 | WI | Washington | school | 5506090 | 2443 | Public school | Hartford J1 | 550609000674 | 20 | Central Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 182 | 182 |
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]);