enrollments
Data source: Big Local News · About: Big Local
2,237 rows where grade = "pk_12_total", state = "WI" and year = 2017 sorted by asian
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
325608 | 325608 | WI | Clark | school | 5500030 | 7 | Public school | Abbotsford | 550003000001 | 20 | Abbotsford Elementary | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 170.0 | 7.0 | 197.0 | 1.0 | 2.0 | 201.0 | 176.0 | 197 | 44 | 377 | 170 | 7 | 197 | 1 | 2 | 201 | 176 | 197 | 44 | 377 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
325641 | 325641 | WI | Adams | school | 5500060 | 14 | Public school | Adams-Friendship Area | 550006001454 | 210 | Adams-Friendship Middle | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 309.0 | 4.0 | 14.0 | 3.0 | 1.0 | 2.0 | 169.0 | 164.0 | 218 | 66 | 333 | 309 | 4 | 14 | 3 | 1 | 2 | 169 | 164 | 218 | 66 | 333 | ||||||||||||||||||||||||||||||
325646 | 325646 | WI | Adams | school | 5500060 | 14 | Public school | Adams-Friendship Area | 550006000010 | 140 | Grand Marsh Elementary | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 129.0 | 5.0 | 23.0 | 1.0 | 3.0 | 100.0 | 61.0 | 126 | 44 | 161 | 129 | 5 | 23 | 1 | 3 | 100 | 61 | 126 | 44 | 161 | ||||||||||||||||||||||||||||||||
325655 | 325655 | WI | Adams | school | 5500060 | 14 | Public school | Adams-Friendship Area | 550006000012 | 200 | Roche-A-Cri Elementary | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 129.0 | 6.0 | 1.0 | 65.0 | 71.0 | 100 | 29 | 136 | 129 | 6 | 1 | 65 | 71 | 100 | 29 | 136 | ||||||||||||||||||||||||||||||||||||
325668 | 325668 | WI | Green | school | 5500120 | 63 | Public school | Albany | 550012000013 | 20 | Albany Elementary | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 143.0 | 1.0 | 8.0 | 4.0 | 76.0 | 80.0 | 68 | 22 | 156 | 143 | 1 | 8 | 4 | 76 | 80 | 68 | 22 | 156 | ||||||||||||||||||||||||||||||||||
325716 | 325716 | WI | Jackson | school | 5500210 | 91 | Public school | Alma Center | 550021000022 | 80 | Lincoln Elementary | Regular School | No | Elementary | PK | 06 | 2017 | pk_12_total | 280.0 | 4.0 | 58.0 | 5.0 | 2.0 | 4.0 | 172.0 | 181.0 | 218 | 60 | 353 | 280 | 4 | 58 | 5 | 2 | 4 | 172 | 181 | 218 | 60 | 353 | ||||||||||||||||||||||||||||||
325726 | 325726 | WI | Jackson | school | 5500210 | 91 | Public school | Alma Center | 550021000020 | 60 | Lincoln High | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 143.0 | 2.0 | 22.0 | 4.0 | 98.0 | 73.0 | 80 | 24 | 171 | 143 | 2 | 22 | 4 | 98 | 73 | 80 | 24 | 171 | ||||||||||||||||||||||||||||||||||
325734 | 325734 | WI | Portage | school | 5500240 | 105 | Public school | Almond-Bancroft | 550024000023 | 20 | Almond Elementary | Regular School | No | Elementary | 01 | 05 | 2017 | pk_12_total | 96.0 | 42.0 | 1.0 | 77.0 | 62.0 | 65 | 23 | 139 | 96 | 42 | 1 | 77 | 62 | 65 | 23 | 139 | ||||||||||||||||||||||||||||||||||||
325740 | 325740 | WI | Portage | school | 5500240 | 105 | Public school | Almond-Bancroft | 550024000024 | 40 | Almond High | Regular School | No | Other | 06 | 12 | 2017 | pk_12_total | 162.0 | 1.0 | 46.0 | 1.0 | 123.0 | 87.0 | 89 | 33 | 210 | 162 | 1 | 46 | 1 | 123 | 87 | 89 | 33 | 210 | ||||||||||||||||||||||||||||||||||
325748 | 325748 | WI | Portage | school | 5500240 | 105 | Public school | Almond-Bancroft | 550024000025 | 60 | Bancroft Elementary | Regular School | No | Elementary | PK | KG | 2017 | pk_12_total | 46.0 | 13.0 | 1.0 | 32.0 | 28.0 | 22 | 6 | 60 | 46 | 13 | 1 | 32 | 28 | 22 | 6 | 60 | ||||||||||||||||||||||||||||||||||||
325806 | 325806 | WI | Langlade | school | 5500360 | 140 | Public school | Antigo Unified | 550036000039 | 100 | East Elementary | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 130.0 | 3.0 | 1.0 | 3.0 | 7.0 | 89.0 | 55.0 | 85 | 35 | 144 | 130 | 3 | 1 | 3 | 7 | 89 | 55 | 85 | 35 | 144 | ||||||||||||||||||||||||||||||||
325814 | 325814 | WI | Langlade | school | 5500360 | 140 | Public school | Antigo Unified | 550036000042 | 180 | North Elementary | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 129.0 | 2.0 | 11.0 | 2.0 | 10.0 | 91.0 | 63.0 | 118 | 27 | 154 | 129 | 2 | 11 | 2 | 10 | 91 | 63 | 118 | 27 | 154 | ||||||||||||||||||||||||||||||||
325829 | 325829 | WI | Langlade | school | 140 | Public Schools-Multidistrict Charters | Antigo Unified | 9100 | Rural Virtual Academy | charter | 2017 | pk_12_total | 13.0 | 1.0 | 8.0 | 6.0 | 6 | 3 | 14 | 13 | 1 | 8 | 6 | 6 | 3 | 14 | ||||||||||||||||||||||||||||||||||||||||||||
325837 | 325837 | WI | Langlade | school | 5500360 | 140 | Public school | Antigo Unified | 550036000045 | 260 | Spring Valley Elementary | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 113.0 | 2.0 | 5.0 | 1.0 | 64.0 | 57.0 | 67 | 13 | 121 | 113 | 2 | 5 | 1 | 64 | 57 | 67 | 13 | 121 | ||||||||||||||||||||||||||||||||||
325851 | 325851 | WI | Outagamie | school | 5500390 | 147 | Public school | Appleton Area | 550039002880 | 155 | Appleton Bilingual School | charter | Regular School | Yes | Elementary | KG | 06 | 2017 | pk_12_total | 44.0 | 114.0 | 7.0 | 78.0 | 87.0 | 79 | 11 | 165 | 44 | 114 | 7 | 78 | 87 | 79 | 11 | 165 | |||||||||||||||||||||||||||||||||||
325861 | 325861 | WI | Outagamie | school | 5500390 | 147 | Public school | Appleton Area | 550039002679 | 800 | Appleton Cooperative Educational Center | Alternative School | No | Other | 04 | 12 | 2017 | pk_12_total | 1.0 | 1.0 | 1.0 | 2.0 | 1.0 | * | * | 3 | 1 | 1 | 1 | 2 | 1 | 3 | ||||||||||||||||||||||||||||||||||||||
325863 | 325863 | WI | Outagamie | school | 5500390 | 147 | Public school | Appleton Area | 550039002549 | 440 | Appleton eSchool | charter | Regular School | Yes | High | 07 | 12 | 2017 | pk_12_total | 15.0 | 5.0 | 10.0 | 5 | 15 | 15 | 5 | 10 | 5 | 15 | |||||||||||||||||||||||||||||||||||||||||
325882 | 325882 | WI | Outagamie | school | 5500390 | 147 | Public school | Appleton Area | 550039003021 | 820 | Appleview | Special Education School | No | Other | PK | 12 | 2017 | pk_12_total | 41.0 | 2.0 | 22.0 | 21.0 | 7 | * | 43 | 41 | 2 | 22 | 21 | 7 | 43 | |||||||||||||||||||||||||||||||||||||||
326126 | 326126 | WI | Trempealeau | school | 5500420 | 154 | Public school | Arcadia | 550042000068 | 40 | Arcadia High | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 228.0 | 2.0 | 125.0 | 1.0 | 186.0 | 170.0 | 172 | 37 | 356 | 228 | 2 | 125 | 1 | 186 | 170 | 172 | 37 | 356 | ||||||||||||||||||||||||||||||||||
326131 | 326131 | WI | Trempealeau | school | 5500420 | 154 | Public school | Arcadia | 550042003041 | 290 | Arcadia Middle | Regular School | No | Middle | 05 | 08 | 2017 | pk_12_total | 144.0 | 3.0 | 203.0 | 184.0 | 166.0 | 232 | 42 | 350 | 144 | 3 | 203 | 184 | 166 | 232 | 42 | 350 | ||||||||||||||||||||||||||||||||||||
326136 | 326136 | WI | Lafayette | school | 5500450 | 161 | Public school | Argyle | 550045000069 | 20 | Argyle Elementary | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 136.0 | 2.0 | 1.0 | 64.0 | 75.0 | 44 | 27 | 139 | 136 | 2 | 1 | 64 | 75 | 44 | 27 | 139 | ||||||||||||||||||||||||||||||||||||
326158 | 326158 | WI | Ashland | school | 5500510 | 170 | Public school | Ashland | 550051003017 | 400 | Ashland Charter High School | charter | Regular School | Yes | High | 09 | 12 | 2017 | pk_12_total | 20.0 | 4.0 | 13.0 | 11.0 | 10 | 4 | 24 | 20 | 4 | 13 | 11 | 10 | 4 | 24 | |||||||||||||||||||||||||||||||||||||
326180 | 326180 | WI | Ashland | school | 5500510 | 170 | Public school | Ashland | 550051000077 | 80 | Lake Superior Primary | Regular School | No | Elementary | PK | 02 | 2017 | pk_12_total | 218.0 | 93.0 | 1.0 | 26.0 | 171.0 | 167.0 | 213 | 65 | 338 | 218 | 93 | 1 | 26 | 171 | 167 | 213 | 65 | 338 | ||||||||||||||||||||||||||||||||||
326185 | 326185 | WI | Ashland | school | 5500510 | 170 | Public school | Ashland | 550051000079 | 120 | Marengo Valley Elementary | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 172.0 | 1.0 | 2.0 | 93.0 | 82.0 | 140 | 10 | 175 | 172 | 1 | 2 | 93 | 82 | 140 | 10 | 175 | ||||||||||||||||||||||||||||||||||||
326192 | 326192 | WI | Ashland | school | 5500510 | 170 | Public school | Ashland | 550051002986 | 250 | Oredocker Project School | charter | Regular School | Yes | Middle | 06 | 08 | 2017 | pk_12_total | 48.0 | 1.0 | 6.0 | 2.0 | 36.0 | 21.0 | 31 | 8 | 57 | 48 | 1 | 6 | 2 | 36 | 21 | 31 | 8 | 57 | |||||||||||||||||||||||||||||||||
326223 | 326223 | WI | Marathon | school | 5500570 | 196 | Public school | Athens | 550057000086 | 20 | Athens Elementary | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 151.0 | 20.0 | 1.0 | 86.0 | 86.0 | 73 | 18 | 172 | 151 | 20 | 1 | 86 | 86 | 73 | 18 | 172 | ||||||||||||||||||||||||||||||||||||
326236 | 326236 | WI | Marathon | school | 5500570 | 196 | Public school | Athens | 550057000088 | 60 | Athens Middle | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 60.0 | 1.0 | 35.0 | 26.0 | 22 | 14 | 61 | 60 | 1 | 35 | 26 | 22 | 14 | 61 | ||||||||||||||||||||||||||||||||||||||
326240 | 326240 | WI | Wood | school | 5500600 | 203 | Public school | Auburndale | 550060000090 | 40 | Auburndale Elementary | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 371.0 | 2.0 | 21.0 | 1.0 | 8.0 | 208.0 | 195.0 | 119 | 42 | 403 | 371 | 2 | 21 | 1 | 8 | 208 | 195 | 119 | 42 | 403 | ||||||||||||||||||||||||||||||||
326248 | 326248 | WI | Wood | school | 5500600 | 203 | Public school | Auburndale | 550060000091 | 60 | Auburndale High | Regular School | No | Other | 06 | 12 | 2017 | pk_12_total | 410.0 | 2.0 | 8.0 | 1.0 | 5.0 | 212.0 | 214.0 | 106 | 45 | 426 | 410 | 2 | 8 | 1 | 5 | 212 | 214 | 106 | 45 | 426 | ||||||||||||||||||||||||||||||||
326256 | 326256 | WI | Wood | school | 203 | Public Schools-Multidistrict Charters | Auburndale | 9100 | Rural Virtual Academy | charter | 2017 | pk_12_total | 5.0 | 2.0 | 3.0 | * | * | 5 | 5 | 2 | 3 | 5 | ||||||||||||||||||||||||||||||||||||||||||||||||
326262 | 326262 | WI | Eau Claire | school | 5500630 | 217 | Public school | Augusta | 550063000092 | 20 | Augusta Elementary | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 250.0 | 8.0 | 2.0 | 11.0 | 142.0 | 129.0 | 145 | 44 | 271 | 250 | 8 | 2 | 11 | 142 | 129 | 145 | 44 | 271 | ||||||||||||||||||||||||||||||||||
326280 | 326280 | WI | Eau Claire | school | 5500630 | 217 | Public school | Augusta | 550063002586 | 410 | Wildlands Charter School | charter | Regular School | Yes | High | 07 | 12 | 2017 | pk_12_total | 69.0 | 1.0 | 29.0 | 41.0 | 13 | 3 | 70 | 69 | 1 | 29 | 41 | 13 | 3 | 70 | |||||||||||||||||||||||||||||||||||||
326305 | 326305 | WI | La Crosse | school | 5500780 | 245 | Public school | Bangor | 550078000100 | 20 | Bangor Elementary | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 266.0 | 2.0 | 8.0 | 3.0 | 153.0 | 126.0 | 91 | 25 | 279 | 266 | 2 | 8 | 3 | 153 | 126 | 91 | 25 | 279 | ||||||||||||||||||||||||||||||||||
326349 | 326349 | WI | Sauk | school | 5500810 | 280 | Public school | Baraboo | 550081000107 | 140 | North Freedom Elementary | Regular School | No | Elementary | KG | 05 | 2017 | pk_12_total | 118.0 | 5.0 | 1.0 | 1.0 | 62.0 | 63.0 | 50 | 6 | 125 | 118 | 5 | 1 | 1 | 62 | 63 | 50 | 6 | 125 | ||||||||||||||||||||||||||||||||||
326382 | 326382 | WI | Barron | school | 5500870 | 308 | Public school | Barron Area | 550087002864 | 810 | Advanced Learning Academy of Wisconsin | charter | Regular School | Yes | Other | KG | 12 | 2017 | pk_12_total | 42.0 | 14.0 | 1.0 | 1.0 | 29.0 | 29.0 | 30 | 2 | 58 | 42 | 14 | 1 | 1 | 29 | 29 | 30 | 2 | 58 | |||||||||||||||||||||||||||||||||
326396 | 326396 | WI | Barron | school | 5500870 | 308 | Public school | Barron Area | 550087000113 | 20 | Almena Elementary | Regular School | No | Elementary | PK | 04 | 2017 | pk_12_total | 67.0 | 5.0 | 42.0 | 30.0 | 45 | 3 | 72 | 67 | 5 | 42 | 30 | 45 | 3 | 72 | ||||||||||||||||||||||||||||||||||||||
326404 | 326404 | WI | Barron | school | 5500870 | 308 | Public school | Barron Area | 550087002717 | 100 | Barron Area Montessori School | charter | Regular School | Yes | Elementary | PK | 03 | 2017 | pk_12_total | 51.0 | 5.0 | 1.0 | 4.0 | 32.0 | 29.0 | 28 | 4 | 61 | 51 | 5 | 1 | 4 | 32 | 29 | 28 | 4 | 61 | |||||||||||||||||||||||||||||||||
326415 | 326415 | WI | Barron | school | 308 | Public Schools-Multidistrict Charters | Barron Area | 9410 | North Star Academy | charter | 2017 | pk_12_total | 14.0 | 1.0 | 10.0 | 5.0 | 2 | 2 | 15 | 14 | 1 | 10 | 5 | 2 | 2 | 15 | ||||||||||||||||||||||||||||||||||||||||||||
326418 | 326418 | WI | Barron | school | 5500870 | 308 | Public school | Barron Area | 550087000117 | 120 | Ridgeland-Dallas Elementary | Regular School | No | Elementary | PK | 04 | 2017 | pk_12_total | 69.0 | 1.0 | 1.0 | 26.0 | 45.0 | 38 | 2 | 71 | 69 | 1 | 1 | 26 | 45 | 38 | 2 | 71 | ||||||||||||||||||||||||||||||||||||
326451 | 326451 | WI | Bayfield | school | 5500900 | 315 | Public school | Bayfield | 550090000082 | 30 | Bayfield Middle | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 13.0 | 3.0 | 1.0 | 60.0 | 48.0 | 29.0 | 51 | 20 | 77 | 13 | 3 | 1 | 60 | 48 | 29 | 51 | 20 | 77 | ||||||||||||||||||||||||||||||||||
326455 | 326455 | WI | Bayfield | school | 5500900 | 315 | Public school | Bayfield | 550090002358 | 60 | La Pointe Elementary | Regular School | No | Elementary | PK | 06 | 2017 | pk_12_total | 8.0 | 3.0 | 2.0 | 3.0 | 10.0 | 7 | 13 | 8 | 3 | 2 | 3 | 10 | 7 | 13 | ||||||||||||||||||||||||||||||||||||||
326470 | 326470 | WI | Dodge | school | 5500960 | 336 | Public school | Beaver Dam Unified | 550096002815 | 850 | Don Smith Learning Academy | Alternative School | No | Other | 06 | 12 | 2017 | pk_12_total | 45.0 | 2.0 | 7.0 | 2.0 | 4.0 | 33.0 | 27.0 | 39 | 10 | 60 | 45 | 2 | 7 | 2 | 4 | 33 | 27 | 39 | 10 | 60 | ||||||||||||||||||||||||||||||||
326481 | 326481 | WI | Dodge | school | 5500960 | 336 | Public school | Beaver Dam Unified | 550096000126 | 100 | Lincoln Elementary | Regular School | No | Elementary | KG | 05 | 2017 | pk_12_total | 147.0 | 15.0 | 40.0 | 1.0 | 10.0 | 122.0 | 91.0 | 138 | 26 | 213 | 147 | 15 | 40 | 1 | 10 | 122 | 91 | 138 | 26 | 213 | ||||||||||||||||||||||||||||||||
326497 | 326497 | WI | Dodge | school | 5500960 | 336 | Public school | Beaver Dam Unified | 550096000127 | 120 | South Beaver Dam Elementary | Regular School | No | Elementary | KG | 05 | 2017 | pk_12_total | 90.0 | 4.0 | 33.0 | 5.0 | 75.0 | 57.0 | 72 | 7 | 132 | 90 | 4 | 33 | 5 | 75 | 57 | 72 | 7 | 132 | ||||||||||||||||||||||||||||||||||
326504 | 326504 | WI | Dodge | school | 5500960 | 336 | Public school | Beaver Dam Unified | 550096000129 | 160 | Washington Elementary | Regular School | No | Elementary | KG | 05 | 2017 | pk_12_total | 197.0 | 1.0 | 30.0 | 7.0 | 131.0 | 104.0 | 97 | 24 | 235 | 197 | 1 | 30 | 7 | 131 | 104 | 97 | 24 | 235 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
326536 | 326536 | WI | Dane | school | 5500990 | 350 | Public school | Belleville | 550099000131 | 20 | Belleville Elementary | Regular School | No | Elementary | PK | 01 | 2017 | pk_12_total | 144.0 | 1.0 | 10.0 | 11.0 | 93.0 | 73.0 | 33 | 18 | 166 | 144 | 1 | 10 | 11 | 93 | 73 | 33 | 18 | 166 | ||||||||||||||||||||||||||||||||||
326541 | 326541 | WI | Dane | school | 5500990 | 350 | Public school | Belleville | 550099000132 | 40 | Belleville High | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 230.0 | 1.0 | 20.0 | 9.0 | 131.0 | 129.0 | 50 | 19 | 260 | 230 | 1 | 20 | 9 | 131 | 129 | 50 | 19 | 260 | ||||||||||||||||||||||||||||||||||
326556 | 326556 | WI | Lafayette | school | 5501020 | 364 | Public school | Belmont Community | 550102000134 | 20 | Belmont Elementary | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 189.0 | 3.0 | 12.0 | 5.0 | 105.0 | 104.0 | 67 | 27 | 209 | 189 | 3 | 12 | 5 | 105 | 104 | 67 | 27 | 209 | ||||||||||||||||||||||||||||||||||
326579 | 326579 | WI | Rock | school | 5501050 | 413 | Public school | Beloit | 550105002855 | 150 | Beloit Early Learning | Regular School | No | Elementary | PK | PK | 2017 | pk_12_total | 18.0 | 18.0 | 31.0 | 5.0 | 39.0 | 33.0 | 62 | 15 | 72 | 18 | 18 | 31 | 5 | 39 | 33 | 62 | 15 | 72 | ||||||||||||||||||||||||||||||||||
326582 | 326582 | WI | Rock | school | 5501050 | 413 | Public school | Beloit | 550105002974 | 421 | Beloit Learning Academy | Alternative School | No | Other | 06 | 12 | 2017 | pk_12_total | 59.0 | 45.0 | 47.0 | 6.0 | 82.0 | 75.0 | 115 | 45 | 157 | 59 | 45 | 47 | 6 | 82 | 75 | 115 | 45 | 157 | ||||||||||||||||||||||||||||||||||
326604 | 326604 | WI | Rock | school | 5501050 | 413 | Public school | Beloit | 550105000140 | 80 | Cunningham Intermediate | Regular School | No | Elementary | 04 | 08 | 2017 | pk_12_total | 254.0 | 157.0 | 210.0 | 4.0 | 41.0 | 330.0 | 336.0 | 531 | 80 | 666 | 254 | 157 | 210 | 4 | 41 | 330 | 336 | 531 | 80 | 666 | ||||||||||||||||||||||||||||||||
326616 | 326616 | WI | Rock | school | 5501050 | 413 | Public school | Beloit | 550105000141 | 110 | Gaston Elementary | Regular School | No | Elementary | PK | 03 | 2017 | pk_12_total | 189.0 | 68.0 | 67.0 | 5.0 | 1.0 | 38.0 | 195.0 | 173.0 | 276 | 50 | 368 | 189 | 68 | 67 | 5 | 1 | 38 | 195 | 173 | 276 | 50 | 368 | ||||||||||||||||||||||||||||||
326641 | 326641 | WI | Rock | school | 5501050 | 413 | Public school | Beloit | 550105000147 | 210 | Merrill Elementary | Regular School | No | Elementary | PK | 03 | 2017 | pk_12_total | 43.0 | 113.0 | 83.0 | 1.0 | 16.0 | 137.0 | 119.0 | 243 | 34 | 256 | 43 | 113 | 83 | 1 | 16 | 137 | 119 | 243 | 34 | 256 | ||||||||||||||||||||||||||||||||
326653 | 326653 | WI | Rock | school | 5501050 | 413 | Public school | Beloit | 550105002705 | 410 | Roy Chapman Andrews Academy | charter | Regular School | Yes | Other | 06 | 12 | 2017 | pk_12_total | 19.0 | 8.0 | 5.0 | 1.0 | 14.0 | 19.0 | 23 | 1 | 33 | 19 | 8 | 5 | 1 | 14 | 19 | 23 | 1 | 33 | |||||||||||||||||||||||||||||||||
326686 | 326686 | WI | Lafayette | school | 5501110 | 427 | Public school | Benton | 550111000160 | 20 | Benton Elementary | Regular School | No | Elementary | PK | 06 | 2017 | pk_12_total | 113.0 | 3.0 | 1.0 | 2.0 | 61.0 | 58.0 | 39 | 16 | 119 | 113 | 3 | 1 | 2 | 61 | 58 | 39 | 16 | 119 | ||||||||||||||||||||||||||||||||||
326696 | 326696 | WI | Lafayette | school | 5501110 | 427 | Public school | Benton | 550111000161 | 40 | Benton High | Regular School | No | High | 07 | 12 | 2017 | pk_12_total | 107.0 | 1.0 | 4.0 | 5.0 | 67.0 | 50.0 | 27 | 13 | 117 | 107 | 1 | 4 | 5 | 67 | 50 | 27 | 13 | 117 | ||||||||||||||||||||||||||||||||||
326726 | 326726 | WI | Walworth | school | 6013 | Public Schools-Multidistrict Charters | Big Foot UHS | 9401 | Walworth Co Educ Alt High | charter | 2017 | pk_12_total | 4.0 | 2.0 | 2.0 | 4.0 | * | * | 6 | 4 | 2 | 2 | 4 | 6 | ||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
326736 | 326736 | WI | Washburn | school | 5501170 | 441 | Public school | Birchwood | 550117000168 | 20 | Birchwood Elementary | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 112.0 | 2.0 | 2.0 | 2.0 | 54.0 | 64.0 | 61 | 25 | 118 | 112 | 2 | 2 | 2 | 54 | 64 | 61 | 25 | 118 | ||||||||||||||||||||||||||||||||||
326754 | 326754 | WI | Washburn | school | 5501170 | 441 | Public school | Birchwood | 550117002937 | 130 | Birchwood Public Montessori | charter | Regular School | Yes | Elementary | PK | 06 | 2017 | pk_12_total | 42.0 | 4.0 | 1.0 | 25.0 | 22.0 | 36 | 5 | 47 | 42 | 4 | 1 | 25 | 22 | 36 | 5 | 47 | |||||||||||||||||||||||||||||||||||
326763 | 326763 | WI | Lafayette | school | 5505730 | 2240 | Public school | Black Hawk | 550573000608 | 160 | Black Hawk Elementary | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 194.0 | 2.0 | 4.0 | 3.0 | 107.0 | 96.0 | 82 | 36 | 203 | 194 | 2 | 4 | 3 | 107 | 96 | 82 | 36 | 203 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
326777 | 326777 | WI | Lafayette | school | 5505730 | 2240 | Public school | Black Hawk | 550573000606 | 40 | Black Hawk Middle | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 64.0 | 4.0 | 35.0 | 33.0 | 28 | 8 | 68 | 64 | 4 | 35 | 33 | 28 | 8 | 68 | ||||||||||||||||||||||||||||||||||||||
326790 | 326790 | WI | Jackson | school | 5501260 | 476 | Public school | Black River Falls | 550126000176 | 80 | Forrest Street Early Learning Center | Regular School | No | Elementary | PK | 01 | 2017 | pk_12_total | 231.0 | 9.0 | 7.0 | 100.0 | 3.0 | 202.0 | 148.0 | 166 | 58 | 350 | 231 | 9 | 7 | 100 | 3 | 202 | 148 | 166 | 58 | 350 | ||||||||||||||||||||||||||||||||
326817 | 326817 | WI | Trempealeau | school | 5500016 | 485 | Public school | Blair-Taylor | 550001603359 | 120 | SoSET Charter School | charter | Regular School | Yes | Elementary | KG | 06 | 2017 | pk_12_total | 57.0 | 34.0 | 23.0 | 14 | 4 | 57 | 57 | 34 | 23 | 14 | 4 | 57 | |||||||||||||||||||||||||||||||||||||||
326824 | 326824 | WI | Chippewa | school | 5501350 | 497 | Public school | Bloomer | 550135000183 | 20 | Bloomer Elementary | Regular School | No | Elementary | PK | 04 | 2017 | pk_12_total | 500.0 | 8.0 | 6.0 | 1.0 | 2.0 | 3.0 | 267.0 | 253.0 | 159 | 62 | 520 | 500 | 8 | 6 | 1 | 2 | 3 | 267 | 253 | 159 | 62 | 520 | ||||||||||||||||||||||||||||||
326837 | 326837 | WI | Chippewa | school | 5501350 | 497 | Public school | Bloomer | 550135000185 | 60 | Bloomer Middle | Regular School | No | Middle | 05 | 08 | 2017 | pk_12_total | 304.0 | 4.0 | 4.0 | 5.0 | 3.0 | 166.0 | 154.0 | 118 | 29 | 320 | 304 | 4 | 4 | 5 | 3 | 166 | 154 | 118 | 29 | 320 | ||||||||||||||||||||||||||||||||
326856 | 326856 | WI | Shawano | school | 5501470 | 602 | Public school | Bonduel | 550147002383 | 21 | Bonduel Middle | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 151.0 | 2.0 | 10.0 | 7.0 | 1.0 | 100.0 | 71.0 | 53 | 31 | 171 | 151 | 2 | 10 | 7 | 1 | 100 | 71 | 53 | 31 | 171 | ||||||||||||||||||||||||||||||||
326878 | 326878 | WI | Shawano | school | 5501560 | 623 | Public school | Bowler | 550156000199 | 20 | Bowler Elementary | Regular School | No | Elementary | PK | 06 | 2017 | pk_12_total | 92.0 | 12.0 | 74.0 | 1.0 | 20.0 | 102.0 | 97.0 | 100 | 46 | 199 | 92 | 12 | 74 | 1 | 20 | 102 | 97 | 100 | 46 | 199 | ||||||||||||||||||||||||||||||||
326887 | 326887 | WI | Shawano | school | 5501560 | 623 | Public school | Bowler | 550156000200 | 40 | Bowler High | Regular School | No | High | 07 | 12 | 2017 | pk_12_total | 63.0 | 3.0 | 47.0 | 1.0 | 19.0 | 68.0 | 65.0 | 61 | 31 | 133 | 63 | 3 | 47 | 1 | 19 | 68 | 65 | 61 | 31 | 133 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
326902 | 326902 | WI | Dunn | school | 5501590 | 637 | Public school | Boyceville Community | 550159000201 | 20 | Tiffany Creek Elementary | Regular School | No | Elementary | PK | 06 | 2017 | pk_12_total | 390.0 | 4.0 | 11.0 | 8.0 | 221.0 | 192.0 | 187 | 59 | 413 | 390 | 4 | 11 | 8 | 221 | 192 | 187 | 59 | 413 | ||||||||||||||||||||||||||||||||||
326960 | 326960 | WI | Green | school | 5501740 | 700 | Public school | Brodhead | 550174000211 | 20 | Ronald R Albrecht Elementary | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 417.0 | 9.0 | 31.0 | 3.0 | 5.0 | 233.0 | 232.0 | 192 | 59 | 465 | 417 | 9 | 31 | 3 | 5 | 233 | 232 | 192 | 59 | 465 | ||||||||||||||||||||||||||||||||
326986 | 326986 | WI | Rusk | school | 5501830 | 735 | Public school | Bruce | 550183000234 | 20 | Bruce Elementary | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 151.0 | 2.0 | 10.0 | 1.0 | 3.0 | 91.0 | 76.0 | * | 23 | 167 | 151 | 2 | 10 | 1 | 3 | 91 | 76 | 23 | 167 | |||||||||||||||||||||||||||||||||
326995 | 326995 | WI | Rusk | school | 5501830 | 735 | Public school | Bruce | 550183000235 | 40 | Bruce High | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 124.0 | 1.0 | 5.0 | 3.0 | 3.0 | 75.0 | 61.0 | 62 | 22 | 136 | 124 | 1 | 5 | 3 | 3 | 75 | 61 | 62 | 22 | 136 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||
327015 | 327015 | WI | Racine | school | 5501890 | 777 | Public school | Burlington Area | 550189002987 | 150 | 4K Community School | Regular School | No | Elementary | PK | PK | 2017 | pk_12_total | 29.0 | 8.0 | 1.0 | 21.0 | 17.0 | 17 | 3 | 38 | 29 | 8 | 1 | 21 | 17 | 17 | 3 | 38 | ||||||||||||||||||||||||||||||||||||
327034 | 327034 | WI | Racine | school | 5501890 | 777 | Public school | Burlington Area | 550189000635 | 120 | Lyons Center | Regular School | No | Elementary | PK | 04 | 2017 | pk_12_total | 60.0 | 11.0 | 1.0 | 32.0 | 40.0 | 23 | 6 | 72 | 60 | 11 | 1 | 32 | 40 | 23 | 6 | 72 | ||||||||||||||||||||||||||||||||||||
327050 | 327050 | WI | Racine | school | 5501890 | 777 | Public school | Burlington Area | 550189000244 | 160 | Winkler Elementary | Regular School | No | Elementary | PK | 04 | 2017 | pk_12_total | 128.0 | 1.0 | 8.0 | 2.0 | 75.0 | 64.0 | 29 | 32 | 139 | 128 | 1 | 8 | 2 | 75 | 64 | 29 | 32 | 139 | ||||||||||||||||||||||||||||||||||
327057 | 327057 | WI | Ashland | school | 5501920 | 840 | Public school | Butternut | 550192000245 | 20 | Butternut Elementary | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 85.0 | 1.0 | 34.0 | 52.0 | 55 | 12 | 86 | 85 | 1 | 34 | 52 | 55 | 12 | 86 | ||||||||||||||||||||||||||||||||||||||
327066 | 327066 | WI | Ashland | school | 5501920 | 840 | Public school | Butternut | 550192000246 | 40 | Butternut High | Regular School | No | Other | 06 | 12 | 2017 | pk_12_total | 93.0 | 1.0 | 50.0 | 44.0 | 46 | 21 | 94 | 93 | 1 | 50 | 44 | 46 | 21 | 94 | ||||||||||||||||||||||||||||||||||||||
327074 | 327074 | WI | Chippewa | school | 5502040 | 870 | Public school | Cadott Community | 550204000247 | 20 | Cadott Elementary | Regular School | No | Elementary | PK | 06 | 2017 | pk_12_total | 454.0 | 1.0 | 7.0 | 5.0 | 7.0 | 250.0 | 224.0 | 198 | 86 | 474 | 454 | 1 | 7 | 5 | 7 | 250 | 224 | 198 | 86 | 474 | ||||||||||||||||||||||||||||||||
327084 | 327084 | WI | Chippewa | school | 5502040 | 870 | Public school | Cadott Community | 550204000248 | 40 | Cadott High | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 232.0 | 1.0 | 5.0 | 4.0 | 127.0 | 115.0 | 84 | 43 | 242 | 232 | 1 | 5 | 4 | 127 | 115 | 84 | 43 | 242 | ||||||||||||||||||||||||||||||||||
327089 | 327089 | WI | Chippewa | school | 5502040 | 870 | Public school | Cadott Community | 550204000249 | 60 | Cadott Junior High | Regular School | No | Middle | 07 | 08 | 2017 | pk_12_total | 114.0 | 2.0 | 1.0 | 1.0 | 58.0 | 60.0 | 54 | 28 | 118 | 114 | 2 | 1 | 1 | 58 | 60 | 54 | 28 | 118 | ||||||||||||||||||||||||||||||||||
327092 | 327092 | WI | Columbia | school | 5502070 | 882 | Public school | Cambria-Friesland | 550207000253 | 60 | Cambria Friesland Elementary | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 156.0 | 2.0 | 21.0 | 3.0 | 90.0 | 92.0 | 82 | 27 | 182 | 156 | 2 | 21 | 3 | 90 | 92 | 82 | 27 | 182 | ||||||||||||||||||||||||||||||||||
327127 | 327127 | WI | Barron | school | 5502130 | 903 | Public school | Cameron | 550213002851 | 800 | Cameron Academy of Virtual Education | charter | Alternative School | Yes | Other | KG | 12 | 2017 | pk_12_total | 61.0 | 1.0 | 27.0 | 35.0 | 5 | 2 | 62 | 61 | 1 | 27 | 35 | 5 | 2 | 62 | |||||||||||||||||||||||||||||||||||||
327153 | 327153 | WI | Barron | school | 5502130 | 903 | Public school | Cameron | 550213002286 | 200 | Cameron Middle | Regular School | No | Middle | 05 | 08 | 2017 | pk_12_total | 264.0 | 2.0 | 7.0 | 136.0 | 137.0 | 88 | 25 | 273 | 264 | 2 | 7 | 136 | 137 | 88 | 25 | 273 | ||||||||||||||||||||||||||||||||||||
327158 | 327158 | WI | Barron | school | 5502130 | 903 | Public school | Cameron | 550213002500 | 9410 | North Star Academy | charter | Alternative School | Yes | High | 09 | 12 | 2017 | pk_12_total | 8.0 | 3.0 | 1.0 | 10.0 | 2.0 | * | 12 | 8 | 3 | 1 | 10 | 2 | 12 | ||||||||||||||||||||||||||||||||||||||
327199 | 327199 | WI | Monroe | school | 5502340 | 980 | Public school | Cashton | 550234000262 | 20 | Cashton Elementary | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 260.0 | 1.0 | 38.0 | 3.0 | 152.0 | 150.0 | 126 | 46 | 302 | 260 | 1 | 38 | 3 | 152 | 150 | 126 | 46 | 302 | ||||||||||||||||||||||||||||||||||
327208 | 327208 | WI | Monroe | school | 5502340 | 980 | Public school | Cashton | 550234000263 | 40 | Cashton Middle/High | Regular School | No | Other | 06 | 12 | 2017 | pk_12_total | 265.0 | 3.0 | 35.0 | 2.0 | 1.0 | 4.0 | 142.0 | 168.0 | 111 | 46 | 310 | 265 | 3 | 35 | 2 | 1 | 4 | 142 | 168 | 111 | 46 | 310 | ||||||||||||||||||||||||||||||
327216 | 327216 | WI | Grant | school | 5502400 | 994 | Public school | Cassville | 550240000264 | 20 | Cassville Elementary | Regular School | No | Elementary | PK | 06 | 2017 | pk_12_total | 96.0 | 51.0 | 45.0 | 54 | 10 | 96 | 96 | 51 | 45 | 54 | 10 | 96 | ||||||||||||||||||||||||||||||||||||||||
327226 | 327226 | WI | Grant | school | 5502400 | 994 | Public school | Cassville | 550240000265 | 40 | Cassville High | Regular School | No | High | 07 | 12 | 2017 | pk_12_total | 93.0 | 44.0 | 49.0 | 40 | 9 | 93 | 93 | 44 | 49 | 40 | 9 | 93 | ||||||||||||||||||||||||||||||||||||||||
327286 | 327286 | 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 | pk_12_total | 412.0 | 6.0 | 1.0 | 200.0 | 219.0 | 403 | 30 | 419 | 412 | 6 | 1 | 200 | 219 | 403 | 30 | 419 | |||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||
327316 | 327316 | WI | Price | school | 5500058 | 1071 | Public school | Chequamegon | 550005800590 | 100 | Glidden Elementary | Regular School | No | Elementary | PK | 03 | 2017 | pk_12_total | 35.0 | 1.0 | 2.0 | 29.0 | 9.0 | * | 4 | 38 | 35 | 1 | 2 | 29 | 9 | 4 | 38 | |||||||||||||||||||||||||||||||||||||
327340 | 327340 | WI | Barron | school | 5500061 | 1080 | Public school | Chetek-Weyerhaeuser Area | 550006102805 | 100 | Chetek-Weyerhaeuser Roselawn Elementary | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 452.0 | 8.0 | 6.0 | 6.0 | 19.0 | 253.0 | 238.0 | 216 | 48 | 491 | 452 | 8 | 6 | 6 | 19 | 253 | 238 | 216 | 48 | 491 | ||||||||||||||||||||||||||||||||
327349 | 327349 | WI | Barron | school | 5500061 | 1080 | Public school | Chetek-Weyerhaeuser Area | 550006102897 | 800 | Link2Learn Virtual Charter School | charter | Regular School | Yes | Other | PK | 12 | 2017 | pk_12_total | 37.0 | 1.0 | 7.0 | 1.0 | 22.0 | 24.0 | 13 | 46 | 37 | 1 | 7 | 1 | 22 | 24 | 13 | 46 | |||||||||||||||||||||||||||||||||||
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 |
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]);