enrollments
Data source: Big Local News · About: Big Local
667 rows where grade = "grade_7", state = "WI" and year = 2017 sorted by ccd_school_type
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
326259 | 326259 | WI | Wood | school | 203 | Public Schools-Multidistrict Charters | Auburndale | 9100 | Rural Virtual Academy | charter | 2017 | grade_7 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
327550 | 327550 | WI | Clark | school | 1162 | Public Schools-Multidistrict Charters | Colby | 9100 | Rural Virtual Academy | charter | 2017 | grade_7 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
334355 | 334355 | WI | Marathon | school | 3787 | Public Schools-Multidistrict Charters | Mosinee | 9100 | Rural Virtual Academy | charter | 2017 | grade_7 | 2 | 2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
335803 | 335803 | WI | Wood | school | 4368 | Public Schools-Multidistrict Charters | Pittsville | 9100 | Rural Virtual Academy | charter | 2017 | grade_7 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
336079 | 336079 | WI | Price | school | 4571 | Public Schools-Multidistrict Charters | Prentice | 9100 | Rural Virtual Academy | charter | 2017 | grade_7 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
337724 | 337724 | WI | Marathon | school | 5467 | Public Schools-Multidistrict Charters | Spencer | 9100 | Rural Virtual Academy | charter | 2017 | grade_7 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
337946 | 337946 | WI | Dane | school | 5621 | Public Schools-Multidistrict Charters | Stoughton Area | 9803 | JEDI Virtual K-12 | charter | 2017 | grade_7 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
339038 | 339038 | WI | Waupaca | school | 6195 | Public Schools-Multidistrict Charters | Waupaca | 9408 | Waupaca County Charter | charter | 2017 | grade_7 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||
328210 | 328210 | WI | Eau Claire | school | 5504050 | 1554 | Public school | Eau Claire Area | 550405000705 | 580 | McKinley Charter School | charter | Alternative School | Yes | Other | 06 | 12 | 2017 | grade_7 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
329306 | 329306 | WI | Brown | school | 5505820 | 2289 | Public school | Green Bay Area Public | 550582003009 | 800 | Dr Rosa Minoka-Hill School | Alternative School | No | Other | PK | 12 | 2017 | grade_7 | 4 | 4 | ||||||||||||||||||||||||||||||||||||||||||||||||||
330588 | 330588 | WI | Kenosha | school | 5507320 | 2793 | Public school | Kenosha | 550732002317 | 280 | Hillcrest School | Alternative School | No | Other | 06 | 12 | 2017 | grade_7 | 5 | 5 | ||||||||||||||||||||||||||||||||||||||||||||||||||
331602 | 331602 | WI | Dane | school | 5508520 | 3269 | Public school | Madison Metropolitan | 550852002909 | 220 | Innovative & Alternative Middle | Alternative School | No | Middle | 06 | 08 | 2017 | grade_7 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||
333899 | 333899 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960000936 | 1086 | Southeastern | Alternative School | No | Middle | 06 | 08 | 2017 | grade_7 | 4 | 4 | ||||||||||||||||||||||||||||||||||||||||||||||||||
334643 | 334643 | WI | Wood | school | 5510380 | 3906 | Public school | Nekoosa | 551038002715 | 200 | Niikuusra Community School | charter | Alternative School | Yes | Elementary | 04 | 08 | 2017 | grade_7 | 4 | 4 | |||||||||||||||||||||||||||||||||||||||||||||||||
336341 | 336341 | WI | Racine | school | 5512360 | 4620 | Public school | Racine Unified | 551236003045 | 801 | Racine Alternative Learning | Alternative School | No | Other | KG | 12 | 2017 | grade_7 | 5 | 5 | ||||||||||||||||||||||||||||||||||||||||||||||||||
336412 | 336412 | WI | Racine | school | 5512360 | 4620 | Public school | Racine Unified | 551236001643 | 285 | Walden III Middle | Alternative School | No | Middle | 06 | 08 | 2017 | grade_7 | 81 | 81 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||
339095 | 339095 | WI | Marathon | school | 5515900 | 6223 | Public school | Wausau | 551590002747 | 400 | Enrich Excel Achieve Learning Academy | charter | Alternative School | Yes | Other | 06 | 12 | 2017 | grade_7 | 4 | 4 | |||||||||||||||||||||||||||||||||||||||||||||||||
339328 | 339328 | WI | Milwaukee | school | 5515990 | 6244 | Public school | Wauwatosa | 551599002349 | 190 | Plank Road Complex | Alternative School | No | Other | KG | 12 | 2017 | grade_7 | 4 | 4 | ||||||||||||||||||||||||||||||||||||||||||||||||||
339867 | 339867 | WI | Walworth | school | 5516680 | 6461 | Public school | Whitewater Unified | 551668002901 | 9803 | JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive | charter | Alternative School | Yes | Other | PK | 12 | 2017 | grade_7 | 3 | 3 | |||||||||||||||||||||||||||||||||||||||||||||||||
327753 | 327753 | WI | Barron | school | 5503090 | 1260 | Public school | Cumberland | 550309002962 | 420 | Island City Academy | charter | Career and Technical School | Yes | High | 07 | 12 | 2017 | grade_7 | 13 | 13 | |||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 |
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]);