enrollments
Data source: Big Local News · About: Big Local
667 rows where grade = "grade_7", state = "WI" and year = 2017 sorted by non_binary_int
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 | |||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
325732 | 325732 | WI | Jackson | school | 5500210 | 91 | Public school | Alma Center | 550021000021 | 70 | Lincoln Junior High | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 38 | 38 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
325915 | 325915 | WI | Outagamie | school | 5500390 | 147 | Public school | Appleton Area | 550039001619 | 110 | Classical School | charter | Regular School | Yes | Elementary | KG | 08 | 2017 | grade_7 | 57 | 57 | |||||||||||||||||||||||||||||||||||||||||||||||||
325942 | 325942 | WI | Outagamie | school | 5500390 | 147 | Public school | Appleton Area | 550039000052 | 120 | Einstein Middle | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 276 | 276 | ||||||||||||||||||||||||||||||||||||||||||||||||||
325964 | 325964 | WI | Outagamie | school | 5500390 | 147 | Public school | Appleton Area | 550039002582 | 135 | Fox River Academy | charter | Regular School | Yes | Elementary | KG | 08 | 2017 | grade_7 | 9 | 9 | |||||||||||||||||||||||||||||||||||||||||||||||||
326028 | 326028 | WI | Outagamie | school | 5500390 | 147 | Public school | Appleton Area | 550039002759 | 250 | Kaleidoscope Academy | charter | Regular School | Yes | Middle | 06 | 08 | 2017 | grade_7 | 242 | 242 | |||||||||||||||||||||||||||||||||||||||||||||||||
326040 | 326040 | WI | Outagamie | school | 5500390 | 147 | Public school | Appleton Area | 550039000060 | 300 | Madison Middle | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 336 | 336 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326061 | 326061 | WI | Outagamie | school | 5500390 | 147 | Public school | Appleton Area | 550039002277 | 210 | Odyssey-Magellan | charter | Regular School | Yes | Elementary | 03 | 08 | 2017 | grade_7 | 28 | 28 | |||||||||||||||||||||||||||||||||||||||||||||||||
326093 | 326093 | WI | Outagamie | school | 5500390 | 147 | Public school | Appleton Area | 550039003341 | 460 | Valley New School | charter | Regular School | Yes | High | 07 | 12 | 2017 | grade_7 | 9 | 9 | |||||||||||||||||||||||||||||||||||||||||||||||||
326102 | 326102 | WI | Outagamie | school | 5500390 | 147 | Public school | Appleton Area | 550039000065 | 410 | Wilson Middle | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 191 | 191 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326114 | 326114 | WI | Outagamie | school | 5500390 | 147 | Public school | Appleton Area | 550039002825 | 850 | Wisconsin Connections Academy | charter | Regular School | Yes | Other | KG | 12 | 2017 | grade_7 | 49 | 49 | |||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326194 | 326194 | WI | Ashland | school | 5500510 | 170 | Public school | Ashland | 550051002986 | 250 | Oredocker Project School | charter | Regular School | Yes | Middle | 06 | 08 | 2017 | grade_7 | 20 | 20 | |||||||||||||||||||||||||||||||||||||||||||||||||
326207 | 326207 | WI | Brown | school | 5500540 | 182 | Public school | Ashwaubenon | 550054000083 | 45 | Parkview Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 251 | 251 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326259 | 326259 | WI | Wood | school | 203 | Public Schools-Multidistrict Charters | Auburndale | 9100 | Rural Virtual Academy | charter | 2017 | grade_7 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326284 | 326284 | WI | Eau Claire | school | 5500630 | 217 | Public school | Augusta | 550063002586 | 410 | Wildlands Charter School | charter | Regular School | Yes | High | 07 | 12 | 2017 | grade_7 | 13 | 13 | |||||||||||||||||||||||||||||||||||||||||||||||||
326303 | 326303 | WI | Saint Croix | school | 5500720 | 231 | Public school | Baldwin-Woodville Area | 550072000096 | 90 | Viking Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 122 | 122 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326347 | 326347 | WI | Sauk | school | 5500810 | 280 | Public school | Baraboo | 550081000102 | 20 | Jack Young Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 230 | 230 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||
326428 | 326428 | WI | Barron | school | 5500870 | 308 | Public school | Barron Area | 550087000118 | 140 | Riverview Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 94 | 94 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326533 | 326533 | WI | Marinette | school | 5511550 | 4263 | Public school | Beecher-Dunbar-Pembine | 551155001530 | 60 | Pembine High | Regular School | No | High | 07 | 12 | 2017 | grade_7 | 20 | 20 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326608 | 326608 | WI | Rock | school | 5501050 | 413 | Public school | Beloit | 550105000140 | 80 | Cunningham Intermediate | Regular School | No | Elementary | 04 | 08 | 2017 | grade_7 | 120 | 120 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326614 | 326614 | WI | Rock | school | 5501050 | 413 | Public school | Beloit | 550105003011 | 170 | Fran Fruzen Intermediate | Regular School | No | Elementary | 04 | 08 | 2017 | grade_7 | 123 | 123 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326634 | 326634 | WI | Rock | school | 5501050 | 413 | Public school | Beloit | 550105002330 | 180 | McNeel Intermediate | Regular School | No | Elementary | 04 | 08 | 2017 | grade_7 | 135 | 135 | ||||||||||||||||||||||||||||||||||||||||||||||||||
326658 | 326658 | WI | Rock | school | 5501050 | 413 | Public school | Beloit | 550105002705 | 410 | Roy Chapman Andrews Academy | charter | Regular School | Yes | Other | 06 | 12 | 2017 | grade_7 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
326684 | 326684 | WI | Rock | school | 5501080 | 422 | Public school | Beloit Turner | 550108000159 | 120 | Turner Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 121 | 121 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||
327040 | 327040 | WI | Racine | school | 5501890 | 777 | Public school | Burlington Area | 550189000238 | 40 | Nettie E Karcher School | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 223 | 223 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
327125 | 327125 | WI | Dane | school | 5502100 | 896 | Public school | Cambridge | 550210000298 | 60 | Nikolay Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 65 | 65 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
327276 | 327276 | WI | Ozaukee | school | 5502460 | 1015 | Public school | Cedarburg | 550246000273 | 100 | Webster Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 248 | 248 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||
327309 | 327309 | WI | Price | school | 5500058 | 1071 | Public school | Chequamegon | 550005802766 | 200 | Chequamegon Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 54 | 54 | ||||||||||||||||||||||||||||||||||||||||||||||||||
327338 | 327338 | WI | Barron | school | 5500061 | 1080 | Public school | Chetek-Weyerhaeuser Area | 550006102806 | 200 | Chetek-Weyerhaeuser Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 61 | 61 | ||||||||||||||||||||||||||||||||||||||||||||||||||
327359 | 327359 | WI | Barron | school | 5500061 | 1080 | Public school | Chetek-Weyerhaeuser Area | 550006102897 | 800 | Link2Learn Virtual Charter School | charter | Regular School | Yes | Other | PK | 12 | 2017 | grade_7 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
327384 | 327384 | WI | Calumet | school | 5502520 | 1085 | Public school | Chilton | 550252002430 | 30 | Chilton Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 93 | 93 | ||||||||||||||||||||||||||||||||||||||||||||||||||
327393 | 327393 | WI | Chippewa | school | 5502550 | 1092 | Public school | Chippewa Falls Area Unified | 550255000281 | 40 | Chippewa Falls Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 366 | 366 | ||||||||||||||||||||||||||||||||||||||||||||||||||
327456 | 327456 | WI | Polk | school | 5502580 | 1120 | Public school | Clayton | 550258000558 | 60 | Clayton Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 27 | 27 | ||||||||||||||||||||||||||||||||||||||||||||||||||
327464 | 327464 | WI | Polk | school | 5502610 | 1127 | Public school | Clear Lake | 550261000293 | 60 | Clear Lake Junior High | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 47 | 47 | ||||||||||||||||||||||||||||||||||||||||||||||||||
327492 | 327492 | WI | Rock | school | 5502640 | 1134 | Public school | Clinton Community | 550264000297 | 80 | Clinton Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 107 | 107 | ||||||||||||||||||||||||||||||||||||||||||||||||||
327502 | 327502 | WI | Waupaca | school | 5502670 | 1141 | Public school | Clintonville | 550267000301 | 20 | Clintonville Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 103 | 103 | ||||||||||||||||||||||||||||||||||||||||||||||||||
327526 | 327526 | WI | Buffalo | school | 5502700 | 1155 | Public school | Cochrane-Fountain City | 550270000307 | 40 | Cochrane-Fountain City High | Regular School | No | High | 07 | 12 | 2017 | grade_7 | 53 | 53 | ||||||||||||||||||||||||||||||||||||||||||||||||||
327543 | 327543 | WI | Clark | school | 5502730 | 1162 | Public school | Colby | 550273001226 | 210 | Colby Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 70 | 70 | ||||||||||||||||||||||||||||||||||||||||||||||||||
327550 | 327550 | WI | Clark | school | 1162 | Public Schools-Multidistrict Charters | Colby | 9100 | Rural Virtual Academy | charter | 2017 | grade_7 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
327566 | 327566 | WI | Marinette | school | 5502760 | 1169 | Public school | Coleman | 550276002847 | 200 | Coleman Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 53 | 53 | ||||||||||||||||||||||||||||||||||||||||||||||||||
327582 | 327582 | WI | Dunn | school | 5502790 | 1176 | Public school | Colfax | 550279000316 | 40 | Colfax High | Regular School | No | High | 07 | 12 | 2017 | grade_7 | 50 | 50 | ||||||||||||||||||||||||||||||||||||||||||||||||||
327601 | 327601 | WI | Columbia | school | 5502820 | 1183 | Public school | Columbus | 550282000319 | 20 | Columbus Middle | Regular School | No | Elementary | 04 | 08 | 2017 | grade_7 | 99 | 99 | ||||||||||||||||||||||||||||||||||||||||||||||||||
327624 | 327624 | WI | Chippewa | school | 5502880 | 1204 | Public school | Cornell | 550288002896 | 300 | Cornell Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 24 | 24 | ||||||||||||||||||||||||||||||||||||||||||||||||||
327641 | 327641 | WI | Forest | school | 5502910 | 1218 | Public school | Crandon | 550291002388 | 22 | Crandon Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 54 | 54 |
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]);