enrollments
Data source: Big Local News · About: Big Local
2,237 rows where grade = "pk_12_total", state = "WI" and year = 2017 sorted by total
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
325625 | 325625 | WI | Clark | school | 7 | Public Schools-Multidistrict Charters | Abbotsford | 9100 | Rural Virtual Academy | charter | 2017 | pk_12_total | 1.0 | 1.0 | * | * | 1 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||
330920 | 330920 | WI | Vernon | school | 5960 | Public Schools-Multidistrict Charters | Kickapoo Area | 9407 | Vernon County Area Better Futures High | charter | 2017 | pk_12_total | 1.0 | 1.0 | * | * | 1 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||
330922 | 330922 | WI | Manitowoc | school | 5507440 | 2828 | Public school | Kiel Area | 550744002554 | 405 | Kiel eSchool | charter | Regular School | Yes | High | 07 | 12 | 2017 | pk_12_total | 1.0 | 1.0 | * | * | 1 | 1 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||||
331160 | 331160 | WI | Vernon | school | 2863 | Public Schools-Multidistrict Charters | La Farge | 9407 | Vernon County Area Better Futures High | charter | 2017 | pk_12_total | 1.0 | 1.0 | * | * | 1 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||
331251 | 331251 | WI | Jefferson | school | 2898 | Public Schools-Multidistrict Charters | Lake Mills Area | 9803 | JEDI Virtual K-12 | charter | 2017 | pk_12_total | 1.0 | 1.0 | * | * | 1 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||
331601 | 331601 | WI | Dane | school | 5508520 | 3269 | Public school | Madison Metropolitan | 550852002909 | 220 | Innovative & Alternative Middle | Alternative School | No | Middle | 06 | 08 | 2017 | pk_12_total | 1.0 | 1.0 | * | * | 1 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||
331824 | 331824 | WI | Waupaca | school | 3276 | Public Schools-Multidistrict Charters | Manawa | 9408 | Waupaca County Charter | charter | 2017 | pk_12_total | 1.0 | 1.0 | * | * | 1 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||
339037 | 339037 | WI | Waupaca | school | 6195 | Public Schools-Multidistrict Charters | Waupaca | 9408 | Waupaca County Charter | charter | 2017 | pk_12_total | 1.0 | 1.0 | * | * | 1 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||
339619 | 339619 | WI | Washington | school | 5516290 | 6307 | Public school | West Bend | 551629002666 | 400 | Washington Street School | Alternative School | No | Other | 06 | 12 | 2017 | pk_12_total | 1.0 | 1.0 | * | * | 1 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||
339769 | 339769 | WI | Waupaca | school | 5516500 | 6384 | Public school | Weyauwega-Fremont | 551650002523 | 9408 | Waupaca County Charter | charter | Regular School | Yes | Other | 06 | 12 | 2017 | pk_12_total | 1.0 | 1.0 | * | * | 1 | 1 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||||
327364 | 327364 | WI | Barron | school | 1080 | Public Schools-Multidistrict Charters | Chetek-Weyerhaeuser Area | 9410 | North Star Academy | charter | 2017 | pk_12_total | 10.0 | 6.0 | 4.0 | * | 1 | 10 | 10 | 6 | 4 | 1 | 10 | |||||||||||||||||||||||||||||||||||||||||||||||
330352 | 330352 | WI | Rock | school | 5507020 | 2695 | Public school | Janesville | 550702002948 | 850 | Youth Services Center | Alternative School | No | Other | 04 | 12 | 2017 | pk_12_total | 3.0 | 6.0 | 1.0 | 9.0 | 1.0 | * | * | 10 | 3 | 6 | 1 | 9 | 1 | 10 | ||||||||||||||||||||||||||||||||||||||
338051 | 338051 | WI | Dane | school | 5656 | Public Schools-Multidistrict Charters | Sun Prairie Area | 9803 | JEDI Virtual K-12 | charter | 2017 | pk_12_total | 9.0 | 1.0 | 6.0 | 4.0 | 3 | 10 | 9 | 1 | 6 | 4 | 3 | 10 | ||||||||||||||||||||||||||||||||||||||||||||||
327658 | 327658 | WI | Marinette | school | 5502970 | 1232 | Public school | Crivitz | 550297000331 | 80 | Crivitz Middle | Regular School | No | Middle | 07 | 08 | 2017 | pk_12_total | 93.0 | 4.0 | 3.0 | 57.0 | 43.0 | 45 | 9 | 100 | 93 | 4 | 3 | 57 | 43 | 45 | 9 | 100 | ||||||||||||||||||||||||||||||||||||
331749 | 331749 | WI | Dane | school | 5508520 | 3269 | Public school | Madison Metropolitan | 550852002265 | 400 | Shabazz-City High | Alternative School | No | High | 09 | 12 | 2017 | pk_12_total | 68.0 | 6.0 | 13.0 | 13.0 | 42.0 | 58.0 | 28 | 17 | 100 | 68 | 6 | 13 | 13 | 42 | 58 | 28 | 17 | 100 | ||||||||||||||||||||||||||||||||||
340027 | 340027 | WI | Sauk | school | 5517040 | 6678 | Public school | Wisconsin Dells | 551704000551 | 50 | Neenah Creek Elementary | Regular School | No | Elementary | KG | 05 | 2017 | pk_12_total | 86.0 | 1.0 | 5.0 | 6.0 | 1.0 | 1.0 | 54.0 | 46.0 | 40 | 3 | 100 | 86 | 1 | 5 | 6 | 1 | 1 | 54 | 46 | 40 | 3 | 100 | ||||||||||||||||||||||||||||||
339148 | 339148 | WI | Marathon | school | 5515900 | 6223 | Public school | Wausau | 551590002054 | 200 | John Muir Middle | Regular School | No | Other | 06 | 09 | 2017 | pk_12_total | 682.0 | 14.0 | 60.0 | 9.0 | 198.0 | 1.0 | 36.0 | 526.0 | 474.0 | 415 | 117 | 1000 | 682 | 14 | 60 | 9 | 198 | 1 | 36 | 526 | 474 | 415 | 117 | 1000 | ||||||||||||||||||||||||||||
332301 | 332301 | WI | Winnebago | school | 5509030 | 3430 | Public school | Menasha Joint | 550903001059 | 100 | Menasha High | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 693.0 | 33.0 | 162.0 | 4.0 | 47.0 | 62.0 | 531.0 | 470.0 | 538 | 160 | 1001 | 693 | 33 | 162 | 4 | 47 | 62 | 531 | 470 | 538 | 160 | 1001 | ||||||||||||||||||||||||||||||
327870 | 327870 | WI | Dane | school | 5503180 | 1316 | Public school | De Forest Area | 550318000356 | 50 | De Forest Middle | Regular School | No | Middle | 05 | 08 | 2017 | pk_12_total | 833.0 | 37.0 | 54.0 | 2.0 | 39.0 | 1.0 | 39.0 | 504.0 | 501.0 | 175 | 96 | 1005 | 833 | 37 | 54 | 2 | 39 | 1 | 39 | 504 | 501 | 175 | 96 | 1005 | ||||||||||||||||||||||||||||
338940 | 338940 | WI | Waukesha | school | 5515780 | 6174 | Public school | Waukesha | 551578002025 | 460 | South High | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 515.0 | 90.0 | 336.0 | 3.0 | 30.0 | 32.0 | 502.0 | 504.0 | 460 | 175 | 1006 | 515 | 90 | 336 | 3 | 30 | 32 | 502 | 504 | 460 | 175 | 1006 | ||||||||||||||||||||||||||||||
336043 | 336043 | WI | Barron | school | 5512180 | 4557 | Public school | Prairie Farm Public | 551218001586 | 40 | Prairie Farm High | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 97.0 | 2.0 | 1.0 | 1.0 | 46.0 | 55.0 | 39 | 16 | 101 | 97 | 2 | 1 | 1 | 46 | 55 | 39 | 16 | 101 | ||||||||||||||||||||||||||||||||||
338070 | 338070 | WI | Dane | school | 5514640 | 5656 | Public school | Sun Prairie Area | 551464002625 | 410 | Prairie Phoenix Academy | Alternative School | No | Other | 06 | 12 | 2017 | pk_12_total | 43.0 | 33.0 | 11.0 | 14.0 | 61.0 | 40.0 | 60 | 17 | 101 | 43 | 33 | 11 | 14 | 61 | 40 | 60 | 17 | 101 | ||||||||||||||||||||||||||||||||||
335740 | 335740 | WI | Waukesha | school | 5511640 | 4312 | Public school | Pewaukee | 551164001536 | 60 | Pewaukee Lake Elementary | Regular School | No | Elementary | PK | 03 | 2017 | pk_12_total | 786.0 | 16.0 | 51.0 | 2.0 | 107.0 | 48.0 | 513.0 | 497.0 | 98 | 69 | 1010 | 786 | 16 | 51 | 2 | 107 | 48 | 513 | 497 | 98 | 69 | 1010 | ||||||||||||||||||||||||||||||
337970 | 337970 | WI | Dane | school | 5514550 | 5621 | Public school | Stoughton Area | 551455001886 | 140 | Stoughton High | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 894.0 | 26.0 | 44.0 | 1.0 | 15.0 | 2.0 | 28.0 | 504.0 | 506.0 | 187 | 106 | 1010 | 894 | 26 | 44 | 1 | 15 | 2 | 28 | 504 | 506 | 187 | 106 | 1010 | ||||||||||||||||||||||||||||
338485 | 338485 | WI | Racine | school | 5515150 | 5852 | Public school | Union Grove UHS | 551515001963 | 20 | Union Grove High | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 908.0 | 7.0 | 62.0 | 3.0 | 10.0 | 22.0 | 518.0 | 494.0 | 144 | 85 | 1012 | 908 | 7 | 62 | 3 | 10 | 22 | 518 | 494 | 144 | 85 | 1012 | ||||||||||||||||||||||||||||||
330423 | 330423 | WI | Green | school | 5507230 | 2737 | Public school | Juda | 550723000785 | 40 | Juda High | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 93.0 | 6.0 | 2.0 | 1.0 | 50.0 | 52.0 | 29 | 11 | 102 | 93 | 6 | 2 | 1 | 50 | 52 | 29 | 11 | 102 | ||||||||||||||||||||||||||||||||||
331996 | 331996 | WI | Green Lake | school | 5508760 | 3325 | Public school | Markesan | 550876002597 | 110 | Markesan Intermediate | Regular School | No | Elementary | 04 | 05 | 2017 | pk_12_total | 85.0 | 3.0 | 10.0 | 4.0 | 47.0 | 55.0 | 36 | 9 | 102 | 85 | 3 | 10 | 4 | 47 | 55 | 36 | 9 | 102 | ||||||||||||||||||||||||||||||||||
337308 | 337308 | WI | Sheboygan | school | 5513650 | 5271 | Public school | Sheboygan Area | 551365002899 | 250 | Mosaic School | charter | Regular School | Yes | Middle | 06 | 08 | 2017 | pk_12_total | 71.0 | 9.0 | 14.0 | 1.0 | 1.0 | 6.0 | 50.0 | 52.0 | 53 | 20 | 102 | 71 | 9 | 14 | 1 | 1 | 6 | 50 | 52 | 53 | 20 | 102 | |||||||||||||||||||||||||||||
338208 | 338208 | WI | Oneida | school | 5514850 | 5733 | Public school | Three Lakes | 551485001927 | 40 | Sugar Camp Elementary | Regular School | No | Elementary | PK | 06 | 2017 | pk_12_total | 101.0 | 1.0 | 45.0 | 57.0 | 35 | 14 | 102 | 101 | 1 | 45 | 57 | 35 | 14 | 102 | ||||||||||||||||||||||||||||||||||||||
340192 | 340192 | WI | Juneau | school | 5517130 | 6713 | Public school | Wonewoc-Union Center | 551713002225 | 80 | Wonewoc-Center High | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 91.0 | 2.0 | 3.0 | 3.0 | 1.0 | 2.0 | 51.0 | 51.0 | 48 | 22 | 102 | 91 | 2 | 3 | 3 | 1 | 2 | 51 | 51 | 48 | 22 | 102 | ||||||||||||||||||||||||||||||
329702 | 329702 | WI | Waukesha | school | 5506030 | 2420 | Public school | Hamilton | 550603000669 | 130 | Templeton Middle | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 840.0 | 29.0 | 41.0 | 3.0 | 73.0 | 35.0 | 531.0 | 490.0 | 134 | 92 | 1021 | 840 | 29 | 41 | 3 | 73 | 35 | 531 | 490 | 134 | 92 | 1021 | ||||||||||||||||||||||||||||||
330819 | 330819 | WI | Waukesha | school | 5503510 | 1376 | Public school | Kettle Moraine | 550351000376 | 120 | Kettle Moraine High | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 933.0 | 5.0 | 46.0 | 3.0 | 8.0 | 1.0 | 25.0 | 595.0 | 426.0 | 87 | 131 | 1021 | 933 | 5 | 46 | 3 | 8 | 1 | 25 | 595 | 426 | 87 | 131 | 1021 | ||||||||||||||||||||||||||||
339085 | 339085 | WI | Marathon | school | 5515900 | 6223 | Public school | Wausau | 551590002063 | 360 | East High | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 756.0 | 17.0 | 46.0 | 7.0 | 136.0 | 65.0 | 505.0 | 522.0 | 372 | 139 | 1027 | 756 | 17 | 46 | 7 | 136 | 65 | 505 | 522 | 372 | 139 | 1027 | ||||||||||||||||||||||||||||||
333536 | 333536 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001164 | 176 | Meir School | Regular School | No | Other | 03 | 11 | 2017 | pk_12_total | 204.0 | 630.0 | 105.0 | 8.0 | 46.0 | 3.0 | 33.0 | 492.0 | 537.0 | 527 | 55 | 1029 | 204 | 630 | 105 | 8 | 46 | 3 | 33 | 492 | 537 | 527 | 55 | 1029 | ||||||||||||||||||||||||||||
327865 | 327865 | WI | Dane | school | 5503180 | 1316 | Public school | De Forest Area | 550318000355 | 40 | De Forest High | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 863.0 | 44.0 | 55.0 | 3.0 | 36.0 | 32.0 | 526.0 | 507.0 | 166 | 77 | 1033 | 863 | 44 | 55 | 3 | 36 | 32 | 526 | 507 | 166 | 77 | 1033 | ||||||||||||||||||||||||||||||
327796 | 327796 | WI | Marathon | school | 5513170 | 4970 | Public school | D C Everest Area | 551317001738 | 60 | Hatley Elementary | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 92.0 | 8.0 | 3.0 | 1.0 | 43.0 | 61.0 | 20 | 7 | 104 | 92 | 8 | 3 | 1 | 43 | 61 | 20 | 7 | 104 | ||||||||||||||||||||||||||||||||||
329597 | 329597 | WI | Milwaukee | school | 5505910 | 2296 | Public school | Greendale | 550591003347 | 110 | Time 4 Learning Charter School | charter | Regular School | Yes | Elementary | PK | PK | 2017 | pk_12_total | 73.0 | 5.0 | 12.0 | 7.0 | 7.0 | 58.0 | 46.0 | 26 | 9 | 104 | 73 | 5 | 12 | 7 | 7 | 58 | 46 | 26 | 9 | 104 | |||||||||||||||||||||||||||||||
331318 | 331318 | WI | Oconto | school | 5507860 | 2961 | Public school | Lena | 550786000896 | 40 | Lena High | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 99.0 | 2.0 | 1.0 | 1.0 | 1.0 | 57.0 | 47.0 | 42 | 13 | 104 | 99 | 2 | 1 | 1 | 1 | 57 | 47 | 42 | 13 | 104 | ||||||||||||||||||||||||||||||||
334324 | 334324 | WI | Green | school | 5509900 | 3696 | Public school | Monticello | 550990001305 | 40 | Monticello High | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 97.0 | 2.0 | 5.0 | 54.0 | 50.0 | 32 | 13 | 104 | 97 | 2 | 5 | 54 | 50 | 32 | 13 | 104 | ||||||||||||||||||||||||||||||||||||
326196 | 326196 | WI | Brown | school | 5500540 | 182 | Public school | Ashwaubenon | 550054000081 | 20 | Ashwaubenon High | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 821.0 | 31.0 | 67.0 | 38.0 | 24.0 | 1.0 | 60.0 | 555.0 | 487.0 | 239 | 126 | 1042 | 821 | 31 | 67 | 38 | 24 | 1 | 60 | 555 | 487 | 239 | 126 | 1042 | ||||||||||||||||||||||||||||
337522 | 337522 | WI | Washington | school | 5513950 | 5390 | Public school | Slinger | 551395001821 | 80 | Slinger High | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 976.0 | 6.0 | 37.0 | 3.0 | 12.0 | 14.0 | 532.0 | 516.0 | 102 | 97 | 1048 | 976 | 6 | 37 | 3 | 12 | 14 | 532 | 516 | 102 | 97 | 1048 | ||||||||||||||||||||||||||||||
325677 | 325677 | WI | Green | school | 5500120 | 63 | Public school | Albany | 550012000014 | 40 | Albany High | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 98.0 | 2.0 | 2.0 | 1.0 | 2.0 | 51.0 | 54.0 | 28 | 12 | 105 | 98 | 2 | 2 | 1 | 2 | 51 | 54 | 28 | 12 | 105 | ||||||||||||||||||||||||||||||||
325952 | 325952 | WI | Outagamie | school | 5500390 | 147 | Public school | Appleton Area | 550039002724 | 450 | Fox Cities Leadership Academy | charter | Regular School | Yes | High | 09 | 12 | 2017 | pk_12_total | 91.0 | 3.0 | 3.0 | 4.0 | 4.0 | 40.0 | 65.0 | 17 | 8 | 105 | 91 | 3 | 3 | 4 | 4 | 40 | 65 | 17 | 8 | 105 | |||||||||||||||||||||||||||||||
326772 | 326772 | WI | Lafayette | school | 5505730 | 2240 | Public school | Black Hawk | 550573000605 | 20 | Black Hawk High | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 101.0 | 1.0 | 2.0 | 1.0 | 63.0 | 42.0 | 29 | 14 | 105 | 101 | 1 | 2 | 1 | 63 | 42 | 29 | 14 | 105 | ||||||||||||||||||||||||||||||||||
326899 | 326899 | WI | Dunn | school | 5501590 | 637 | Public school | Boyceville Community | 550159002460 | 200 | Boyceville Middle | Regular School | No | Middle | 07 | 08 | 2017 | pk_12_total | 102.0 | 3.0 | 64.0 | 41.0 | 41 | 28 | 105 | 102 | 3 | 64 | 41 | 41 | 28 | 105 | ||||||||||||||||||||||||||||||||||||||
327945 | 327945 | WI | Vernon | school | 5503240 | 1421 | Public school | De Soto Area | 550324000368 | 80 | Prairie View Elementary | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 99.0 | 2.0 | 1.0 | 3.0 | 55.0 | 50.0 | 68 | 17 | 105 | 99 | 2 | 1 | 3 | 55 | 50 | 68 | 17 | 105 | ||||||||||||||||||||||||||||||||||
335929 | 335929 | WI | Columbia | school | 5512060 | 4501 | Public school | Portage Community | 551206002280 | 100 | Lewiston Elementary | Regular School | No | Elementary | KG | 05 | 2017 | pk_12_total | 101.0 | 4.0 | 51.0 | 54.0 | 36 | 11 | 105 | 101 | 4 | 51 | 54 | 36 | 11 | 105 | ||||||||||||||||||||||||||||||||||||||
337907 | 337907 | WI | Calumet | school | 5514520 | 5614 | Public school | Stockbridge | 551452001882 | 20 | Stockbridge Elementary | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 102.0 | 1.0 | 2.0 | 55.0 | 50.0 | 21 | 8 | 105 | 102 | 1 | 2 | 55 | 50 | 21 | 8 | 105 | ||||||||||||||||||||||||||||||||||||
338759 | 338759 | WI | Jefferson | school | 5515720 | 6118 | Public school | Waterloo | 551572001943 | 300 | Waterloo Middle | Regular School | No | Middle | 07 | 08 | 2017 | pk_12_total | 71.0 | 1.0 | 28.0 | 1.0 | 4.0 | 57.0 | 48.0 | 35 | 15 | 105 | 71 | 1 | 28 | 1 | 4 | 57 | 48 | 35 | 15 | 105 | ||||||||||||||||||||||||||||||||
337348 | 337348 | WI | Sheboygan | school | 5513650 | 5271 | Public school | Sheboygan Area | 551365001797 | 340 | South High | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 572.0 | 48.0 | 229.0 | 1.0 | 182.0 | 1.0 | 19.0 | 571.0 | 481.0 | 453 | 187 | 1052 | 572 | 48 | 229 | 1 | 182 | 1 | 19 | 571 | 481 | 453 | 187 | 1052 | ||||||||||||||||||||||||||||
334095 | 334095 | WI | Milwaukee | school | 5500042 | 8106 | Non District Charter Schools | Milwaukee Academy of Science | 550004202234 | 1251 | Milwaukee Academy of Science | charter | Regular School | Yes | Other | PK | 12 | 2017 | pk_12_total | 2.0 | 1042.0 | 10.0 | 1.0 | 2.0 | 504.0 | 553.0 | 969 | 121 | 1057 | 2 | 1042 | 10 | 1 | 2 | 504 | 553 | 969 | 121 | 1057 | |||||||||||||||||||||||||||||||
328659 | 328659 | WI | Florence | school | 5504650 | 1855 | Public school | Florence County | 550465000490 | 60 | Florence High | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 100.0 | 3.0 | 1.0 | 2.0 | 64.0 | 42.0 | * | 18 | 106 | 100 | 3 | 1 | 2 | 64 | 42 | 18 | 106 | |||||||||||||||||||||||||||||||||||
327000 | 327000 | WI | Rusk | school | 5501830 | 735 | Public school | Bruce | 550183001222 | 210 | Bruce Middle | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 96.0 | 5.0 | 3.0 | 3.0 | 48.0 | 59.0 | * | 18 | 107 | 96 | 5 | 3 | 3 | 48 | 59 | 18 | 107 | |||||||||||||||||||||||||||||||||||
328072 | 328072 | WI | Racine | school | 5503750 | 1449 | Public school | Dover #1 | 550375000394 | 20 | Kansasville Elementary | Regular School | No | Elementary | PK | 08 | 2017 | pk_12_total | 88.0 | 5.0 | 8.0 | 2.0 | 4.0 | 51.0 | 56.0 | 20 | 10 | 107 | 88 | 5 | 8 | 2 | 4 | 51 | 56 | 20 | 10 | 107 | ||||||||||||||||||||||||||||||||
336821 | 336821 | WI | Sauk | school | 5514250 | 5523 | Public school | River Valley | 551425001851 | 20 | River Valley Arena Community Elementary | charter | Regular School | Yes | Elementary | PK | 05 | 2017 | pk_12_total | 96.0 | 4.0 | 2.0 | 5.0 | 56.0 | 51.0 | 41 | 23 | 107 | 96 | 4 | 2 | 5 | 56 | 51 | 41 | 23 | 107 | |||||||||||||||||||||||||||||||||
339384 | 339384 | WI | Milwaukee | school | 5515990 | 6244 | Public school | Wauwatosa | 551599002091 | 280 | West High | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 621.0 | 233.0 | 69.0 | 5.0 | 52.0 | 4.0 | 87.0 | 581.0 | 490.0 | 297 | 115 | 1071 | 621 | 233 | 69 | 5 | 52 | 4 | 87 | 581 | 490 | 297 | 115 | 1071 | ||||||||||||||||||||||||||||
329960 | 329960 | WI | Outagamie | school | 5506600 | 2583 | Public school | Hortonville Area | 550660000715 | 40 | Hortonville High | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 985.0 | 4.0 | 49.0 | 3.0 | 14.0 | 18.0 | 544.0 | 529.0 | 109 | 128 | 1073 | 985 | 4 | 49 | 3 | 14 | 18 | 544 | 529 | 109 | 128 | 1073 | ||||||||||||||||||||||||||||||
330654 | 330654 | WI | Kenosha | school | 5507320 | 2793 | Public school | Kenosha | 550732002538 | 215 | Mahone Middle | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 591.0 | 114.0 | 275.0 | 26.0 | 1.0 | 66.0 | 537.0 | 536.0 | 404 | 105 | 1073 | 591 | 114 | 275 | 26 | 1 | 66 | 537 | 536 | 404 | 105 | 1073 | ||||||||||||||||||||||||||||||
333986 | 333986 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002967 | 875 | Universal Academy for the College Bound | charter | Regular School | Yes | Other | PK | 12 | 2017 | pk_12_total | 11.0 | 1018.0 | 23.0 | 2.0 | 4.0 | 1.0 | 15.0 | 546.0 | 528.0 | 963 | 169 | 1074 | 11 | 1018 | 23 | 2 | 4 | 1 | 15 | 546 | 528 | 963 | 169 | 1074 | |||||||||||||||||||||||||||
334870 | 334870 | WI | Milwaukee | school | 5505490 | 2177 | Public school | Nicolet UHS | 550549000584 | 20 | Nicolet High | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 659.0 | 221.0 | 77.0 | 7.0 | 46.0 | 3.0 | 63.0 | 557.0 | 519.0 | 123 | 119 | 1076 | 659 | 221 | 77 | 7 | 46 | 3 | 63 | 557 | 519 | 123 | 119 | 1076 | ||||||||||||||||||||||||||||
328936 | 328936 | WI | Trempealeau | school | 5504960 | 2009 | Public school | Galesville-Ettrick-Trempealeau | 550496000535 | 20 | Ettrick Elementary | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 100.0 | 2.0 | 6.0 | 55.0 | 53.0 | 24 | 9 | 108 | 100 | 2 | 6 | 55 | 53 | 24 | 9 | 108 | ||||||||||||||||||||||||||||||||||||
331327 | 331327 | WI | Walworth | school | 5508040 | 3087 | Public school | Linn J4 | 550804000898 | 20 | Traver Elementary | Regular School | No | Elementary | PK | 08 | 2017 | pk_12_total | 73.0 | 5.0 | 28.0 | 1.0 | 1.0 | 56.0 | 52.0 | 46 | 8 | 108 | 73 | 5 | 28 | 1 | 1 | 56 | 52 | 46 | 8 | 108 | ||||||||||||||||||||||||||||||||
332696 | 332696 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960000792 | 1063 | ASSATA High | Alternative School | No | High | 09 | 12 | 2017 | pk_12_total | 2.0 | 106.0 | 51.0 | 57.0 | 89 | 17 | 108 | 2 | 106 | 51 | 57 | 89 | 17 | 108 | ||||||||||||||||||||||||||||||||||||||
338306 | 338306 | WI | Monroe | school | 5514910 | 5747 | Public school | Tomah Area | 551491001940 | 220 | Warrens Elementary | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 103.0 | 1.0 | 4.0 | 59.0 | 49.0 | 43 | 14 | 108 | 103 | 1 | 4 | 59 | 49 | 43 | 14 | 108 | ||||||||||||||||||||||||||||||||||||
326096 | 326096 | WI | Outagamie | school | 5500390 | 147 | Public school | Appleton Area | 550039000048 | 40 | West High | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 736.0 | 76.0 | 104.0 | 7.0 | 147.0 | 1.0 | 11.0 | 562.0 | 520.0 | 472 | 198 | 1082 | 736 | 76 | 104 | 7 | 147 | 1 | 11 | 562 | 520 | 472 | 198 | 1082 | ||||||||||||||||||||||||||||
338738 | 338738 | WI | Racine | school | 5515600 | 6083 | Public school | Waterford UHS | 551560001988 | 20 | Waterford High | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 1003.0 | 10.0 | 48.0 | 1.0 | 5.0 | 1.0 | 15.0 | 567.0 | 516.0 | 111 | 98 | 1083 | 1003 | 10 | 48 | 1 | 5 | 1 | 15 | 567 | 516 | 111 | 98 | 1083 | ||||||||||||||||||||||||||||
331010 | 331010 | WI | La Crosse | school | 5507530 | 2849 | Public school | La Crosse | 550753000854 | 20 | Central High | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 822.0 | 58.0 | 32.0 | 13.0 | 95.0 | 64.0 | 561.0 | 523.0 | 417 | 166 | 1084 | 822 | 58 | 32 | 13 | 95 | 64 | 561 | 523 | 417 | 166 | 1084 | ||||||||||||||||||||||||||||||
339978 | 339978 | WI | Kenosha | school | 5516770 | 6545 | Public school | Wilmot UHS | 551677002188 | 20 | Wilmot High | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 955.0 | 6.0 | 85.0 | 4.0 | 5.0 | 31.0 | 588.0 | 498.0 | 209 | 139 | 1086 | 955 | 6 | 85 | 4 | 5 | 31 | 588 | 498 | 209 | 139 | 1086 | ||||||||||||||||||||||||||||||
339271 | 339271 | WI | Milwaukee | school | 5515990 | 6244 | Public school | Wauwatosa | 551599002077 | 20 | East High | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 749.0 | 174.0 | 47.0 | 3.0 | 30.0 | 1.0 | 84.0 | 527.0 | 561.0 | 213 | 120 | 1088 | 749 | 174 | 47 | 3 | 30 | 1 | 84 | 527 | 561 | 213 | 120 | 1088 | ||||||||||||||||||||||||||||
330204 | 330204 | WI | Rock | school | 5507020 | 2695 | Public school | Janesville | 550702002991 | 860 | ARISE Virtual Academy | charter | Regular School | Yes | Other | KG | 12 | 2017 | pk_12_total | 89.0 | 3.0 | 7.0 | 1.0 | 2.0 | 7.0 | 42.0 | 67.0 | 40 | 14 | 109 | 89 | 3 | 7 | 1 | 2 | 7 | 42 | 67 | 40 | 14 | 109 | |||||||||||||||||||||||||||||
335670 | 335670 | WI | Rock | school | 5511130 | 4151 | Public school | Parkview | 551113001477 | 120 | Parkview Junior High | Regular School | No | Middle | 07 | 08 | 2017 | pk_12_total | 98.0 | 3.0 | 6.0 | 1.0 | 1.0 | 49.0 | 60.0 | 38 | 13 | 109 | 98 | 3 | 6 | 1 | 1 | 49 | 60 | 38 | 13 | 109 | ||||||||||||||||||||||||||||||||
339909 | 339909 | WI | Milwaukee | school | 5506000 | 6470 | Public school | Whitnall | 550600002673 | 130 | CORE4 Collaborating on Readiness Education for Four-Year-Olds | charter | Regular School | Yes | Elementary | PK | PK | 2017 | pk_12_total | 89.0 | 9.0 | 7.0 | 4.0 | 57.0 | 52.0 | 11 | 7 | 109 | 89 | 9 | 7 | 4 | 57 | 52 | 11 | 7 | 109 | |||||||||||||||||||||||||||||||||
326461 | 326461 | WI | Dodge | school | 5500960 | 336 | Public school | Beaver Dam Unified | 550096000123 | 40 | Beaver Dam High | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 857.0 | 24.0 | 182.0 | 6.0 | 6.0 | 15.0 | 560.0 | 530.0 | 441 | 140 | 1090 | 857 | 24 | 182 | 6 | 6 | 15 | 560 | 530 | 441 | 140 | 1090 | ||||||||||||||||||||||||||||||
327391 | 327391 | WI | Chippewa | school | 5502550 | 1092 | Public school | Chippewa Falls Area Unified | 550255000281 | 40 | Chippewa Falls Middle | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 997.0 | 19.0 | 24.0 | 7.0 | 24.0 | 1.0 | 24.0 | 569.0 | 527.0 | 424 | 150 | 1096 | 997 | 19 | 24 | 7 | 24 | 1 | 24 | 569 | 527 | 424 | 150 | 1096 | ||||||||||||||||||||||||||||
336155 | 336155 | WI | Brown | school | 5512330 | 4613 | Public school | Pulaski Community | 551233001600 | 100 | Pulaski High | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 989.0 | 9.0 | 34.0 | 26.0 | 13.0 | 27.0 | 566.0 | 532.0 | 192 | 130 | 1098 | 989 | 9 | 34 | 26 | 13 | 27 | 566 | 532 | 192 | 130 | 1098 | ||||||||||||||||||||||||||||||
326729 | 326729 | WI | Washburn | school | 5501170 | 441 | Public school | Birchwood | 550117002800 | 450 | Birchwood Blue Hills Charter School | charter | Regular School | Yes | High | 07 | 12 | 2017 | pk_12_total | 7.0 | 2.0 | 2.0 | 5.0 | 6.0 | * | 4 | 11 | 7 | 2 | 2 | 5 | 6 | 4 | 11 | ||||||||||||||||||||||||||||||||||||
327256 | 327256 | WI | Ozaukee | school | 5502460 | 1015 | Public school | Cedarburg | 550246002772 | 110 | Early Learning Center | Special Education School | No | Elementary | PK | PK | 2017 | pk_12_total | 10.0 | 1.0 | 7.0 | 4.0 | 1 | * | 11 | 10 | 1 | 7 | 4 | 1 | 11 | |||||||||||||||||||||||||||||||||||||||
327311 | 327311 | WI | Price | school | 5500058 | 1071 | Public school | Chequamegon | 550005802780 | 450 | Class ACT Charter | charter | Career and Technical School | Yes | High | 09 | 12 | 2017 | pk_12_total | 10.0 | 1.0 | 5.0 | 6.0 | 5 | 1 | 11 | 10 | 1 | 5 | 6 | 5 | 1 | 11 | |||||||||||||||||||||||||||||||||||||
329135 | 329135 | WI | Saint Croix | school | 5505520 | 2198 | Public school | Glenwood City | 550552002469 | 400 | Transitional Skills Center | charter | Regular School | Yes | High | 10 | 12 | 2017 | pk_12_total | 9.0 | 1.0 | 1.0 | 6.0 | 5.0 | * | 3 | 11 | 9 | 1 | 1 | 6 | 5 | 3 | 11 | ||||||||||||||||||||||||||||||||||||
339896 | 339896 | WI | Walworth | school | 5516680 | 6461 | Public school | Whitewater Unified | 551668002834 | 100 | Whitewater 4K | Regular School | No | Elementary | PK | PK | 2017 | pk_12_total | 8.0 | 1.0 | 1.0 | 1.0 | 5.0 | 6.0 | 5 | 11 | 8 | 1 | 1 | 1 | 5 | 6 | 5 | 11 | ||||||||||||||||||||||||||||||||||||
327449 | 327449 | WI | Polk | school | 5502580 | 1120 | Public school | Clayton | 550258000290 | 40 | Clayton High | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 109.0 | 1.0 | 53.0 | 57.0 | 48 | 19 | 110 | 109 | 1 | 53 | 57 | 48 | 19 | 110 | ||||||||||||||||||||||||||||||||||||||
327617 | 327617 | WI | Chippewa | school | 5502880 | 1204 | Public school | Cornell | 550288000324 | 40 | Cornell High | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 104.0 | 1.0 | 4.0 | 1.0 | 61.0 | 49.0 | 57 | 27 | 110 | 104 | 1 | 4 | 1 | 61 | 49 | 57 | 27 | 110 | ||||||||||||||||||||||||||||||||||
332367 | 332367 | WI | Dunn | school | 5509090 | 3444 | Public school | Menomonie Area | 550909001074 | 60 | Downsville Elementary | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 104.0 | 3.0 | 2.0 | 1.0 | 65.0 | 45.0 | 47 | 7 | 110 | 104 | 3 | 2 | 1 | 65 | 45 | 47 | 7 | 110 | ||||||||||||||||||||||||||||||||||
337046 | 337046 | WI | Sauk | school | 5513410 | 5100 | Public school | Sauk Prairie | 551341002663 | 100 | Merrimac Community | charter | Regular School | Yes | Elementary | PK | 05 | 2017 | pk_12_total | 104.0 | 1.0 | 3.0 | 2.0 | 66.0 | 44.0 | 36 | 19 | 110 | 104 | 1 | 3 | 2 | 66 | 44 | 36 | 19 | 110 | |||||||||||||||||||||||||||||||||
332633 | 332633 | WI | Rock | school | 5509570 | 3612 | Public school | Milton | 550957001118 | 100 | Milton High | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 997.0 | 11.0 | 53.0 | 24.0 | 19.0 | 573.0 | 531.0 | 190 | 110 | 1104 | 997 | 11 | 53 | 24 | 19 | 573 | 531 | 190 | 110 | 1104 | ||||||||||||||||||||||||||||||||
327976 | 327976 | WI | Dane | school | 5503270 | 1309 | Public school | Deerfield Community | 550327000372 | 60 | Deerfield Middle | Regular School | No | Middle | 07 | 08 | 2017 | pk_12_total | 91.0 | 5.0 | 11.0 | 4.0 | 64.0 | 47.0 | 26 | 26 | 111 | 91 | 5 | 11 | 4 | 64 | 47 | 26 | 26 | 111 | ||||||||||||||||||||||||||||||||||
328695 | 328695 | WI | Fond du Lac | school | 5504680 | 1862 | Public school | Fond du Lac | 550468002966 | 210 | Fond du Lac STEM Institute | charter | Regular School | Yes | Other | 06 | 09 | 2017 | pk_12_total | 99.0 | 5.0 | 3.0 | 1.0 | 3.0 | 70.0 | 41.0 | 34 | 15 | 111 | 99 | 5 | 3 | 1 | 3 | 70 | 41 | 34 | 15 | 111 | |||||||||||||||||||||||||||||||
329228 | 329228 | WI | Burnett | school | 5505670 | 2233 | Public school | Grantsburg | 550567000604 | 120 | Nelson Elementary | Regular School | No | Elementary | PK | KG | 2017 | pk_12_total | 97.0 | 1.0 | 3.0 | 1.0 | 9.0 | 51.0 | 60.0 | 48 | 21 | 111 | 97 | 1 | 3 | 1 | 9 | 51 | 60 | 48 | 21 | 111 | ||||||||||||||||||||||||||||||||
329883 | 329883 | WI | La Crosse | school | 5506540 | 2562 | Public school | Holmen | 550654000706 | 40 | Holmen High | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 971.0 | 13.0 | 16.0 | 7.0 | 84.0 | 5.0 | 15.0 | 596.0 | 515.0 | 272 | 163 | 1111 | 971 | 13 | 16 | 7 | 84 | 5 | 15 | 596 | 515 | 272 | 163 | 1111 | ||||||||||||||||||||||||||||
339574 | 339574 | WI | Washington | school | 5516290 | 6307 | Public school | West Bend | 551629002128 | 50 | East High | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 998.0 | 24.0 | 61.0 | 5.0 | 11.0 | 15.0 | 566.0 | 548.0 | 261 | 150 | 1114 | 998 | 24 | 61 | 5 | 11 | 15 | 566 | 548 | 261 | 150 | 1114 | ||||||||||||||||||||||||||||||
325957 | 325957 | WI | Outagamie | school | 5500390 | 147 | Public school | Appleton Area | 550039002582 | 135 | Fox River Academy | charter | Regular School | Yes | Elementary | KG | 08 | 2017 | pk_12_total | 99.0 | 4.0 | 4.0 | 1.0 | 3.0 | 1.0 | 62.0 | 50.0 | 36 | 12 | 112 | 99 | 4 | 4 | 1 | 3 | 1 | 62 | 50 | 36 | 12 | 112 | |||||||||||||||||||||||||||||
326529 | 326529 | WI | Marinette | school | 5511550 | 4263 | Public school | Beecher-Dunbar-Pembine | 551155001530 | 60 | Pembine High | Regular School | No | High | 07 | 12 | 2017 | pk_12_total | 110.0 | 1.0 | 1.0 | 62.0 | 50.0 | 59 | 16 | 112 | 110 | 1 | 1 | 62 | 50 | 59 | 16 | 112 | ||||||||||||||||||||||||||||||||||||
328317 | 328317 | WI | Rock | school | 5504110 | 1568 | Public school | Edgerton | 550411000446 | 160 | Yahara Elementary | Regular School | No | Elementary | 01 | 05 | 2017 | pk_12_total | 99.0 | 8.0 | 5.0 | 55.0 | 57.0 | 40 | 14 | 112 | 99 | 8 | 5 | 55 | 57 | 40 | 14 | 112 | ||||||||||||||||||||||||||||||||||||
335623 | 335623 | WI | Jefferson | school | 5511350 | 4221 | Public school | Palmyra-Eagle Area | 551135002418 | 30 | Palmyra-Eagle Middle | Regular School | No | Middle | 07 | 08 | 2017 | pk_12_total | 95.0 | 15.0 | 1.0 | 1.0 | 59.0 | 53.0 | 33 | 15 | 112 | 95 | 15 | 1 | 1 | 59 | 53 | 33 | 15 | 112 | ||||||||||||||||||||||||||||||||||
338244 | 338244 | WI | Shawano | school | 5514880 | 5740 | Public school | Tigerton | 551488001932 | 40 | Tigerton High | Regular School | No | Other | 06 | 12 | 2017 | pk_12_total | 105.0 | 1.0 | 1.0 | 5.0 | 50.0 | 62.0 | 60 | 18 | 112 | 105 | 1 | 1 | 5 | 50 | 62 | 60 | 18 | 112 | ||||||||||||||||||||||||||||||||||
330630 | 330630 | WI | Kenosha | school | 5507320 | 2793 | Public school | Kenosha | 550732002758 | 190 | Kenosha School of Technology Enhanced Curriculum | charter | Regular School | Yes | Elementary | PK | 08 | 2017 | pk_12_total | 736.0 | 80.0 | 218.0 | 6.0 | 39.0 | 41.0 | 612.0 | 508.0 | 335 | 87 | 1120 | 736 | 80 | 218 | 6 | 39 | 41 | 612 | 508 | 335 | 87 | 1120 | |||||||||||||||||||||||||||||
335370 | 335370 | WI | Dane | school | 5511100 | 4144 | Public school | Oregon | 551110001470 | 60 | Oregon High | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 998.0 | 22.0 | 56.0 | 20.0 | 2.0 | 24.0 | 541.0 | 581.0 | 167 | 109 | 1122 | 998 | 22 | 56 | 20 | 2 | 24 | 541 | 581 | 167 | 109 | 1122 | ||||||||||||||||||||||||||||||
338026 | 338026 | WI | Dane | school | 5514640 | 5656 | Public school | Sun Prairie Area | 551464002810 | 220 | Cardinal Heights Upper Middle | Regular School | No | Other | 08 | 09 | 2017 | pk_12_total | 761.0 | 95.0 | 104.0 | 70.0 | 1.0 | 91.0 | 583.0 | 539.0 | 288 | 124 | 1122 | 761 | 95 | 104 | 70 | 1 | 91 | 583 | 539 | 288 | 124 | 1122 | ||||||||||||||||||||||||||||||
330460 | 330460 | WI | Outagamie | school | 5507290 | 2758 | Public school | Kaukauna Area | 550729001700 | 200 | River View School | Regular School | No | Middle | 05 | 08 | 2017 | pk_12_total | 988.0 | 10.0 | 72.0 | 1.0 | 17.0 | 37.0 | 566.0 | 559.0 | 283 | 165 | 1125 | 988 | 10 | 72 | 1 | 17 | 37 | 566 | 559 | 283 | 165 | 1125 | ||||||||||||||||||||||||||||||
327251 | 327251 | WI | Ozaukee | school | 5502460 | 1015 | Public school | Cedarburg | 550246000270 | 20 | Cedarburg High | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 1038.0 | 10.0 | 25.0 | 3.0 | 28.0 | 22.0 | 531.0 | 595.0 | 64 | 93 | 1126 | 1038 | 10 | 25 | 3 | 28 | 22 | 531 | 595 | 64 | 93 | 1126 |
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]);