enrollments
Data source: Big Local News · About: Big Local
37,120 rows where state = "MO" and year = 2020 sorted by ell descending
This data as json, CSV (advanced)
grade ✖
- grade_1 2,320
- grade_10 2,320
- grade_11 2,320
- grade_12 2,320
- grade_2 2,320
- grade_3 2,320
- grade_4 2,320
- grade_5 2,320
- grade_6 2,320
- grade_7 2,320
- grade_8 2,320
- grade_9 2,320
- k_12_total 2,320
- kindergarten 2,320
- pk_12_total 2,320
- pre_kindergarten 2,320
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3309755 | 3309755 | MO | school | 2929280 | 115115 | ST. LOUIS CITY | 292928000798 | 5590 | MULLANPHY BOTANICAL GARDENS | Regular School | No | Elementary | PK | 05 | 2020 | k_12_total | 32 | 310 | 41 | * | 14 | * | * | 99 | * | 84 | 398 | 32 | 310 | 41 | 14 | 99 | 84 | 398 | ||||||||||||||||||||||||||||||||||||
3304689 | 3304689 | MO | school | 2921810 | 73108 | NEOSHO SCHOOL DISTRICT | 292181001209 | 1050 | NEOSHO HIGH | Regular School | No | High | 09 | 12 | 2020 | k_12_total | 909 | 16 | 208 | 45 | 14 | 74 | 38 | 94 | 524 | 111 | 1304 | 909 | 16 | 208 | 45 | 14 | 74 | 38 | 94 | 524 | 111 | 1304 | ||||||||||||||||||||||||||||||||
3302543 | 3302543 | MO | school | 2900590 | 48922 | FRONTIER SCHOOLS | 290059003232 | 1985 | FRONTIER STEM HIGH SCHOOL | Regular School | Yes | High | 09 | 12 | 2020 | k_12_total | 25 | 83 | 240 | * | * | * | * | 93 | * | 14 | 350 | 25 | 83 | 240 | 93 | 14 | 350 | |||||||||||||||||||||||||||||||||||||
3307379 | 3307379 | MO | school | 2920670 | 96094 | MEHLVILLE R-IX | 292067001114 | 3000 | MARGARET BUERKLE MIDDLE | Regular School | No | Middle | 06 | 08 | 2020 | k_12_total | 461 | 72 | 32 | 5 | 31 | * | 33 | 93 | 290 | 90 | 635 | 461 | 72 | 32 | 5 | 31 | 33 | 93 | 290 | 90 | 635 | |||||||||||||||||||||||||||||||||
3309480 | 3309480 | MO | school | 2929280 | 115115 | ST. LOUIS CITY | 292928000790 | 1730 | SOLDAN INTERNATIONAL STUDIES | Regular School | No | High | 09 | 12 | 2020 | k_12_total | 11 | 451 | 37 | * | 11 | * | * | 93 | * | 28 | 511 | 11 | 451 | 37 | 11 | 93 | 28 | 511 | ||||||||||||||||||||||||||||||||||||
3309725 | 3309725 | MO | school | 2929280 | 115115 | ST. LOUIS CITY | 292928001968 | 5260 | MANN ELEM. | Regular School | No | Elementary | PK | 06 | 2020 | k_12_total | 47 | 136 | 31 | * | 30 | * | * | 93 | * | 34 | 244 | 47 | 136 | 31 | 30 | 93 | 34 | 244 | ||||||||||||||||||||||||||||||||||||
3297623 | 3297623 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001648 | 1075 | CENTRAL HIGH | Regular School | No | High | 09 | 12 | 2020 | k_12_total | 1244 | 118 | 182 | 5 | 51 | 15 | 91 | 92 | 644 | 213 | 1706 | 1244 | 118 | 182 | 5 | 51 | 15 | 91 | 92 | 644 | 213 | 1706 | ||||||||||||||||||||||||||||||||
3300532 | 3300532 | MO | school | 2928860 | 39141 | SPRINGFIELD R-XII | 292886001786 | 1050 | CENTRAL HIGH | Regular School | No | High | 06 | 12 | 2020 | k_12_total | 1203 | 198 | 150 | 15 | 96 | 16 | 64 | 90 | 815 | 123 | 1742 | 1203 | 198 | 150 | 15 | 96 | 16 | 64 | 90 | 815 | 123 | 1742 | ||||||||||||||||||||||||||||||||
3297436 | 3297436 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100001946 | 3060 | JOHN B. LANGE MIDDLE | Regular School | No | Middle | 06 | 08 | 2020 | k_12_total | 284 | 206 | 46 | * | 18 | * | 65 | 9 | 382.3 | 76 | 626 | 284 | 206 | 46 | 18 | 65 | 9 | 76 | 626 | |||||||||||||||||||||||||||||||||||
3298166 | 3298166 | MO | school | 2915600 | 16090 | JACKSON R-II | 291560003265 | 4140 | EAST ELEMENTARY | Regular School | No | Elementary | PK | 04 | 2020 | k_12_total | 380 | 11 | 7 | * | * | * | 8 | 9 | 111 | 70 | 412 | 380 | 11 | 7 | 8 | 9 | 111 | 70 | 412 | |||||||||||||||||||||||||||||||||||
3298226 | 3298226 | MO | school | 2907120 | 16096 | CAPE GIRARDEAU 63 | 290712002722 | 4050 | BLANCHARD ELEM. | Regular School | No | Elementary | PK | 04 | 2020 | k_12_total | 149 | 119 | 13 | * | 5 | * | 42 | 9 | * | 40 | 328 | 149 | 119 | 13 | 5 | 42 | 9 | 40 | 328 | |||||||||||||||||||||||||||||||||||
3298376 | 3298376 | MO | school | 2923730 | 19142 | RAYMORE-PECULIAR R-II | 292373001424 | 1050 | RAYMORE-PECULIAR SR. HIGH | Regular School | No | High | 09 | 12 | 2020 | k_12_total | 1488 | 200 | 143 | 6 | 22 | * | 112 | 9 | 479.3 | 187 | 1971 | 1488 | 200 | 143 | 6 | 22 | 112 | 9 | 187 | 1971 | ||||||||||||||||||||||||||||||||||
3300114 | 3300114 | MO | school | 2930570 | 36131 | UNION R-XI | 293057002098 | 4040 | CENTRAL ELEM. | Regular School | No | Elementary | PK | 03 | 2020 | k_12_total | 655 | 9 | 26 | * | * | * | 32 | 9 | 404 | 97 | 724 | 655 | 9 | 26 | 32 | 9 | 404 | 97 | 724 | |||||||||||||||||||||||||||||||||||
3300392 | 3300392 | MO | school | 2932010 | 39133 | WILLARD R-II | 293201003354 | 4090 | WILLARD INTERMEDIATE-SOUTH | Regular School | No | Middle | 05 | 06 | 2020 | k_12_total | 261 | 16 | 48 | * | * | * | 20 | 9 | 184 | 54 | 353 | 261 | 16 | 48 | 20 | 9 | 184 | 54 | 353 | |||||||||||||||||||||||||||||||||||
3300742 | 3300742 | MO | school | 2928860 | 39141 | SPRINGFIELD R-XII | 292886001815 | 4510 | PLEASANT VIEW ELEM. | Regular School | No | Elementary | KG | 05 | 2020 | k_12_total | 174 | 10 | 9 | * | * | * | 11 | 9 | 108 | 19 | 207 | 174 | 10 | 9 | 11 | 9 | 108 | 19 | 207 | |||||||||||||||||||||||||||||||||||
3300784 | 3300784 | MO | school | 2928860 | 39141 | SPRINGFIELD R-XII | 292886002675 | 4710 | TRUMAN ELEM. | Regular School | No | Elementary | PK | 05 | 2020 | k_12_total | 232 | 8 | 11 | * | * | * | 20 | 9 | 111.3 | 58 | 274 | 232 | 8 | 11 | 20 | 9 | 58 | 274 | ||||||||||||||||||||||||||||||||||||
3300796 | 3300796 | MO | school | 2928860 | 39141 | SPRINGFIELD R-XII | 292886001832 | 4740 | WEAVER ELEM. | Regular School | No | Elementary | PK | 05 | 2020 | k_12_total | 138 | 36 | 13 | * | * | * | 19 | 9 | 190.2 | 39 | 214 | 138 | 36 | 13 | 19 | 9 | 39 | 214 | ||||||||||||||||||||||||||||||||||||
3300820 | 3300820 | MO | school | 2928860 | 39141 | SPRINGFIELD R-XII | 292886001837 | 4820 | WILLIAMS ELEM. | Regular School | No | Elementary | PK | 05 | 2020 | k_12_total | 187 | 25 | 15 | * | * | 7 | 19 | 9 | 236.4 | 50 | 253 | 187 | 25 | 15 | 7 | 19 | 9 | 50 | 253 | |||||||||||||||||||||||||||||||||||
3300826 | 3300826 | MO | school | 2928860 | 39141 | SPRINGFIELD R-XII | 292886002865 | 4830 | WILSON'S CREEK 5-6 INTER. CTR. | Regular School | No | Middle | 05 | 06 | 2020 | k_12_total | 384 | 16 | 24 | * | 23 | * | 21 | 9 | 127 | 40 | 473 | 384 | 16 | 24 | 23 | 21 | 9 | 127 | 40 | 473 | ||||||||||||||||||||||||||||||||||
3301511 | 3301511 | MO | school | 2905310 | 48068 | BLUE SPRINGS R-IV | 290531002737 | 5070 | SUNNY POINTE ELEM. | Regular School | No | Elementary | KG | 05 | 2020 | k_12_total | 390 | 63 | 35 | * | 18 | * | 39 | 9 | 204 | 70 | 552 | 390 | 63 | 35 | 18 | 39 | 9 | 204 | 70 | 552 | ||||||||||||||||||||||||||||||||||
3302034 | 3302034 | MO | school | 2915480 | 48077 | INDEPENDENCE 30 | 291548000708 | 4060 | BLACKBURN ELEM. | Regular School | No | Elementary | PK | 05 | 2020 | k_12_total | 220 | 64 | 39 | * | * | * | 28 | 9 | 179 | 32 | 358 | 220 | 64 | 39 | 28 | 9 | 179 | 32 | 358 | |||||||||||||||||||||||||||||||||||
3302747 | 3302747 | MO | school | 2931500 | 49144 | WEBB CITY R-VII | 293150000559 | 3000 | WEBB CITY MIDDLE | Regular School | No | Middle | 05 | 06 | 2020 | k_12_total | 646 | 15 | 53 | 5 | 9 | * | 49 | 9 | 371 | 124 | 781 | 646 | 15 | 53 | 5 | 9 | 49 | 9 | 371 | 124 | 781 | |||||||||||||||||||||||||||||||||
3303734 | 3303734 | MO | school | 2930450 | 57003 | TROY R-III | 293045002088 | 3000 | TROY MIDDLE | Regular School | No | Middle | 06 | 08 | 2020 | k_12_total | 654 | 12 | 40 | * | * | * | 36 | 9 | 291.3 | 109 | 746 | 654 | 12 | 40 | 36 | 9 | 109 | 746 | ||||||||||||||||||||||||||||||||||||
3304296 | 3304296 | MO | school | 2927630 | 66105 | SCHOOL OF THE OSAGE | 292763002479 | 3000 | OSAGE UPPER ELEM. | Regular School | No | Elementary | 03 | 05 | 2020 | k_12_total | 385 | 12 | 22 | * | * | * | 20 | 9 | 191 | 65 | 441 | 385 | 12 | 22 | 20 | 9 | 191 | 65 | 441 | |||||||||||||||||||||||||||||||||||
3304650 | 3304650 | MO | school | 2910800 | 73102 | DIAMOND R-IV | 291080000365 | 4020 | DIAMOND ELEM. | Regular School | No | Elementary | PK | 04 | 2020 | k_12_total | 192 | * | * | 5 | * | 5 | 11 | 9 | 133 | 46 | 217 | 192 | 5 | 5 | 11 | 9 | 133 | 46 | 217 | |||||||||||||||||||||||||||||||||||
3305069 | 3305069 | MO | school | 2924530 | 79077 | PERRY CO. 32 | 292453002387 | 1050 | PERRYVILLE SR. HIGH | Regular School | No | High | 09 | 12 | 2020 | k_12_total | 697 | * | 21 | * | * | * | 10 | 9 | 251.1 | 106 | 734 | 697 | 21 | 10 | 9 | 106 | 734 | |||||||||||||||||||||||||||||||||||||
3305238 | 3305238 | MO | school | 2926890 | 81096 | ROLLA 31 | 292689001636 | 1050 | ROLLA SR. HIGH | Regular School | No | High | 09 | 12 | 2020 | k_12_total | 1083 | 46 | 43 | 7 | 27 | * | 35 | 9 | 406 | 125 | 1242 | 1083 | 46 | 43 | 7 | 27 | 35 | 9 | 406 | 125 | 1242 | |||||||||||||||||||||||||||||||||
3306021 | 3306021 | MO | school | 2908370 | 92087 | FT. ZUMWALT R-II | 290837002490 | 1075 | FT. ZUMWALT SOUTH HIGH | Regular School | No | High | 09 | 12 | 2020 | k_12_total | 1087 | 85 | 66 | * | 72 | * | 57 | 9 | 151 | 144 | 1374 | 1087 | 85 | 66 | 72 | 57 | 9 | 151 | 144 | 1374 | ||||||||||||||||||||||||||||||||||
3306081 | 3306081 | MO | school | 2908370 | 92087 | FT. ZUMWALT R-II | 290837000237 | 4050 | MOUNT HOPE ELEM. | Regular School | No | Elementary | KG | 05 | 2020 | k_12_total | 347 | 15 | 18 | * | 5 | * | 18 | 9 | 58 | 60 | 403 | 347 | 15 | 18 | 5 | 18 | 9 | 58 | 60 | 403 | ||||||||||||||||||||||||||||||||||
3306147 | 3306147 | MO | school | 2908370 | 92087 | FT. ZUMWALT R-II | 290837002843 | 4170 | OSTMANN ELEM. | Regular School | No | Elementary | KG | 05 | 2020 | k_12_total | 306 | 15 | 20 | * | 12 | * | 12 | 9 | 29 | 169 | 366 | 306 | 15 | 20 | 12 | 12 | 9 | 29 | 169 | 366 | ||||||||||||||||||||||||||||||||||
3306456 | 3306456 | MO | school | 2923160 | 92091 | ORCHARD FARM R-V | 292316001331 | 1050 | Orchard Farm High School | Regular School | No | High | 09 | 12 | 2020 | k_12_total | 435 | 33 | 41 | * | 9 | * | 24 | 9 | 143 | 63 | 546 | 435 | 33 | 41 | 9 | 24 | 9 | 143 | 63 | 546 | ||||||||||||||||||||||||||||||||||
3306474 | 3306474 | MO | school | 2923160 | 92091 | ORCHARD FARM R-V | 292316003177 | 4030 | Discovery Elementary | Regular School | No | Elementary | PK | 05 | 2020 | k_12_total | 285 | 68 | 15 | * | * | * | 26 | 9 | 118 | 70 | 399 | 285 | 68 | 15 | 26 | 9 | 118 | 70 | 399 | |||||||||||||||||||||||||||||||||||
3306846 | 3306846 | MO | school | 2913830 | 96088 | HAZELWOOD | 291383000613 | 4320 | ARMSTRONG ELEM. | Regular School | No | Elementary | PK | 05 | 2020 | k_12_total | 64 | 284 | 14 | * | * | * | 19 | 9 | 269 | 54 | 383 | 64 | 284 | 14 | 19 | 9 | 269 | 54 | 383 | |||||||||||||||||||||||||||||||||||
3307706 | 3307706 | MO | school | 2909720 | 96102 | CLAYTON | 290972000275 | 1050 | CLAYTON HIGH | Regular School | No | High | 09 | 12 | 2020 | k_12_total | 575 | 140 | 47 | * | 102 | * | 41 | 9 | 70 | 91 | 906 | 575 | 140 | 47 | 102 | 41 | 9 | 70 | 91 | 906 | ||||||||||||||||||||||||||||||||||
3308079 | 3308079 | MO | school | 2930660 | 96112 | UNIVERSITY CITY | 293066002109 | 4140 | JACKSON PARK ELEM. | Regular School | No | Elementary | KG | 05 | 2020 | k_12_total | 36 | 214 | 10 | * | * | * | 20 | 9 | * | 44 | 282 | 36 | 214 | 10 | 20 | 9 | 44 | 282 | ||||||||||||||||||||||||||||||||||||
3308874 | 3308874 | MO | school | 2914550 | 106005 | HOLLISTER R-V | 291455001120 | 3000 | HOLLISTER MIDDLE | Regular School | No | Middle | 06 | 08 | 2020 | k_12_total | 233 | 5 | 30 | * | * | * | 7 | 9 | 204 | 22 | 280 | 233 | 5 | 30 | 7 | 9 | 204 | 22 | 280 | |||||||||||||||||||||||||||||||||||
3309821 | 3309821 | MO | school | 2929280 | 115115 | ST. LOUIS CITY | 292928002646 | 6030 | WILKINSON EARLY CHILDHOOD CTR. | Regular School | No | Elementary | PK | 02 | 2020 | k_12_total | 62 | 110 | * | * | * | * | * | 9 | * | 26 | 179 | 62 | 110 | 9 | 26 | 179 | ||||||||||||||||||||||||||||||||||||||
3302016 | 3302016 | MO | school | 2915480 | 48077 | INDEPENDENCE 30 | 291548003090 | 3060 | CLIFFORD H. NOWLIN MIDDLE | Regular School | No | Middle | 06 | 08 | 2020 | k_12_total | 429 | 120 | 290 | * | * | * | 63 | 88 | 766 | 115 | 909 | 429 | 120 | 290 | 63 | 88 | 766 | 115 | 909 | |||||||||||||||||||||||||||||||||||
3307967 | 3307967 | MO | school | 2926640 | 96110 | RITENOUR | 292664001575 | 4220 | WYLAND ELEM. | Regular School | No | Elementary | KG | 05 | 2020 | k_12_total | 137 | 188 | 122 | * | 15 | * | 36 | 87 | 69 | 85 | 501 | 137 | 188 | 122 | 15 | 36 | 87 | 69 | 85 | 501 | ||||||||||||||||||||||||||||||||||
3309510 | 3309510 | MO | school | 2929280 | 115115 | ST. LOUIS CITY | 292928002569 | 3050 | BUSCH MS CHARACTER & ATHLETICS | Regular School | No | Middle | 06 | 08 | 2020 | k_12_total | 92 | 230 | 67 | * | 19 | * | * | 87 | * | 73 | 408 | 92 | 230 | 67 | 19 | 87 | 73 | 408 | ||||||||||||||||||||||||||||||||||||
3309909 | 3309909 | MO | school | 2900586 | 115912 | ST. LOUIS LANG IMMERSION SCH | 290058603124 | 6961 | ST LOUIS LANG IMMERSION MARINE | Regular School | Yes | Elementary | KG | 08 | 2020 | k_12_total | 90 | 245 | 83 | * | 5 | * | 60 | 87 | 320 | 65 | 485 | 90 | 245 | 83 | 5 | 60 | 87 | 320 | 65 | 485 | ||||||||||||||||||||||||||||||||||
3299251 | 3299251 | MO | school | 2922800 | 24093 | NORTH KANSAS CITY 74 | 292280001274 | 4320 | GRACEMOR ELEMENTARY | Regular School | No | Elementary | PK | 05 | 2020 | k_12_total | 332 | 129 | 110 | * | 11 | 6 | 92 | 86 | 452 | 106 | 682 | 332 | 129 | 110 | 11 | 6 | 92 | 86 | 452 | 106 | 682 | |||||||||||||||||||||||||||||||||
3302549 | 3302549 | MO | school | 2900590 | 48922 | FRONTIER SCHOOLS | 290059003182 | 3935 | FRONTIER SCHL OF INNOVATION-M | Regular School | Yes | Middle | 06 | 08 | 2020 | k_12_total | 15 | 42 | 245 | * | * | * | * | 86 | * | 15 | 306 | 15 | 42 | 245 | 86 | 15 | 306 | |||||||||||||||||||||||||||||||||||||
3305160 | 3305160 | MO | school | 2927830 | 80125 | SEDALIA 200 | 292783003143 | 2000 | SMITH COTTON JUNIOR HIGH SCHL | Regular School | No | Middle | 06 | 08 | 2020 | k_12_total | 787 | 41 | 234 | 6 | 8 | * | 102 | 86 | 756.1 | 165 | 1182 | 787 | 41 | 234 | 6 | 8 | 102 | 86 | 165 | 1182 | ||||||||||||||||||||||||||||||||||
3307539 | 3307539 | MO | school | 2923580 | 96095 | PARKWAY C-2 | 292358001377 | 4035 | CARMAN TRAILS ELEM. | Regular School | No | Elementary | KG | 05 | 2020 | k_12_total | 225 | 54 | 52 | * | 52 | * | 24 | 86 | 154 | 75 | 408 | 225 | 54 | 52 | 52 | 24 | 86 | 154 | 75 | 408 | ||||||||||||||||||||||||||||||||||
3307563 | 3307563 | MO | school | 2923580 | 96095 | PARKWAY C-2 | 292358001386 | 4110 | HANNA WOODS ELEM. | Regular School | No | Elementary | KG | 05 | 2020 | k_12_total | 279 | 42 | 27 | * | 80 | * | 31 | 84 | 115 | 85 | 460 | 279 | 42 | 27 | 80 | 31 | 84 | 115 | 85 | 460 | ||||||||||||||||||||||||||||||||||
3307655 | 3307655 | MO | school | 2902910 | 96098 | AFFTON 101 | 290291000005 | 4080 | GOTSCH INTERMEDIATE SCH. | Regular School | No | Elementary | 03 | 05 | 2020 | k_12_total | 434 | 56 | 44 | * | 24 | * | 54 | 83 | 210 | 103 | 613 | 434 | 56 | 44 | 24 | 54 | 83 | 210 | 103 | 613 | ||||||||||||||||||||||||||||||||||
3307037 | 3307037 | MO | school | 2923700 | 96090 | PATTONVILLE R-III | 292370001412 | 4060 | BRIDGEWAY ELEM. | Regular School | No | Elementary | PK | 05 | 2020 | k_12_total | 188 | 127 | 88 | * | 9 | * | 36 | 82 | 215 | 73 | 450 | 188 | 127 | 88 | 9 | 36 | 82 | 215 | 73 | 450 | ||||||||||||||||||||||||||||||||||
3297430 | 3297430 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100001408 | 3040 | SMITHTON MIDDLE | Regular School | No | Middle | 06 | 08 | 2020 | k_12_total | 479 | 101 | 52 | * | 61 | * | 55 | 81 | 260 | 93 | 751 | 479 | 101 | 52 | 61 | 55 | 81 | 260 | 93 | 751 | ||||||||||||||||||||||||||||||||||
3305172 | 3305172 | MO | school | 2927830 | 80125 | SEDALIA 200 | 292783001703 | 4020 | HEBER HUNT ELEM. | Regular School | No | Elementary | KG | 04 | 2020 | k_12_total | 243 | 36 | 123 | * | * | * | 45 | 81 | 329.3 | 64 | 450 | 243 | 36 | 123 | 45 | 81 | 64 | 450 | ||||||||||||||||||||||||||||||||||||
3301762 | 3301762 | MO | school | 2914340 | 48072 | HICKMAN MILLS C-1 | 291434003162 | 3050 | SMITH-HALE MIDDLE | Regular School | No | Middle | 06 | 08 | 2020 | k_12_total | 100 | 841 | 174 | * | 25 | * | 57 | 80 | * | 163 | 1204 | 100 | 841 | 174 | 25 | 57 | 80 | 163 | 1204 | |||||||||||||||||||||||||||||||||||
3304701 | 3304701 | MO | school | 2921810 | 73108 | NEOSHO SCHOOL DISTRICT | 292181001207 | 3000 | MIDDLE SCH. | Regular School | No | Middle | 05 | 06 | 2020 | k_12_total | 491 | 7 | 117 | 17 | 7 | 51 | 48 | 80 | 460.1 | 118 | 738 | 491 | 7 | 117 | 17 | 7 | 51 | 48 | 80 | 118 | 738 | |||||||||||||||||||||||||||||||||
3296858 | 3296858 | MO | school | 2920810 | 4110 | MEXICO 59 | 292081001137 | 1050 | MEXICO HIGH | Regular School | No | High | 09 | 12 | 2020 | k_12_total | 529 | 46 | 68 | * | * | * | 60 | 8 | 249.3 | 62 | 709 | 529 | 46 | 68 | 60 | 8 | 62 | 709 | ||||||||||||||||||||||||||||||||||||
3298083 | 3298083 | MO | school | 2906990 | 15002 | CAMDENTON R-III | 290699002983 | 4050 | HAWTHORN ELEMENTARY | Regular School | No | Elementary | 03 | 04 | 2020 | k_12_total | 376 | 6 | 32 | * | * | * | 8 | 8 | 235 | 60 | 424 | 376 | 6 | 32 | 8 | 8 | 235 | 60 | 424 | |||||||||||||||||||||||||||||||||||
3299091 | 3299091 | MO | school | 2918540 | 24090 | LIBERTY 53 | 291854002804 | 4140 | SHOAL CREEK ELEM. | Regular School | No | Elementary | KG | 05 | 2020 | k_12_total | 766 | 30 | 30 | * | 29 | * | 60 | 8 | 64.3 | 67 | 915 | 766 | 30 | 30 | 29 | 60 | 8 | 67 | 915 | |||||||||||||||||||||||||||||||||||
3299503 | 3299503 | MO | school | 2916190 | 26006 | JEFFERSON CITY | 291619000757 | 5020 | THORPE J. GORDON ELEM. | Regular School | No | Elementary | KG | 05 | 2020 | k_12_total | 115 | 141 | 12 | * | * | * | 53 | 8 | * | 38 | 324 | 115 | 141 | 12 | 53 | 8 | 38 | 324 | ||||||||||||||||||||||||||||||||||||
3299947 | 3299947 | MO | school | 2914460 | 35094 | HOLCOMB R-III | 291446000677 | 4020 | HOLCOMB ELEM. | Regular School | No | Elementary | PK | 06 | 2020 | k_12_total | 209 | * | 31 | * | * | * | * | 8 | * | 44 | 242 | 209 | 31 | 8 | 44 | 242 | ||||||||||||||||||||||||||||||||||||||
3299953 | 3299953 | MO | school | 2909120 | 35097 | CLARKTON C-4 | 290912000269 | 1050 | CLARKTON HIGH | Regular School | No | High | 07 | 12 | 2020 | k_12_total | 105 | 10 | 28 | * | * | * | * | 8 | * | 23 | 148 | 105 | 10 | 28 | 8 | 23 | 148 | |||||||||||||||||||||||||||||||||||||
3300458 | 3300458 | MO | school | 2903270 | 39135 | ASH GROVE R-IV | 290327000027 | 4020 | ASH GROVE ELEM. | Regular School | No | Elementary | PK | 03 | 2020 | k_12_total | 187 | * | * | * | * | * | * | 8 | 121 | 34 | 199 | 187 | 8 | 121 | 34 | 199 | ||||||||||||||||||||||||||||||||||||||
3300986 | 3300986 | MO | school | 2932110 | 42111 | HENRY CO. R-I | 293211002254 | 4020 | WINDSOR ELEM. | Regular School | No | Elementary | PK | 06 | 2020 | k_12_total | 330 | * | 13 | * | * | * | 6 | 8 | 224 | 77 | 356 | 330 | 13 | 6 | 8 | 224 | 77 | 356 | ||||||||||||||||||||||||||||||||||||
3301360 | 3301360 | MO | school | 2912290 | 48066 | FORT OSAGE R-I | 291229000494 | 3000 | OSAGE TRAIL MIDDLE | Regular School | No | Middle | 07 | 08 | 2020 | k_12_total | 608 | 80 | 86 | 7 | 8 | 27 | 15 | 8 | 427 | 101 | 831 | 608 | 80 | 86 | 7 | 8 | 27 | 15 | 8 | 427 | 101 | 831 | ||||||||||||||||||||||||||||||||
3301366 | 3301366 | MO | school | 2912290 | 48066 | FORT OSAGE R-I | 291229000489 | 4020 | BLUE HILLS ELEM. | Regular School | No | Elementary | KG | 04 | 2020 | k_12_total | 235 | 32 | 47 | * | 5 | 5 | 19 | 8 | 169 | 40 | 345 | 235 | 32 | 47 | 5 | 5 | 19 | 8 | 169 | 40 | 345 | |||||||||||||||||||||||||||||||||
3301378 | 3301378 | MO | school | 2912290 | 48066 | FORT OSAGE R-I | 291229000491 | 4060 | CLER-MONT ELEM. | Regular School | No | Elementary | KG | 04 | 2020 | k_12_total | 271 | 30 | 43 | * | * | * | 12 | 8 | 201 | 41 | 360 | 271 | 30 | 43 | 12 | 8 | 201 | 41 | 360 | |||||||||||||||||||||||||||||||||||
3301481 | 3301481 | MO | school | 2905310 | 48068 | BLUE SPRINGS R-IV | 290531000083 | 4090 | JAMES WALKER ELEM. | Regular School | No | Elementary | KG | 05 | 2020 | k_12_total | 278 | 71 | 61 | * | 7 | * | 56 | 8 | 237 | 78 | 478 | 278 | 71 | 61 | 7 | 56 | 8 | 237 | 78 | 478 | ||||||||||||||||||||||||||||||||||
3301643 | 3301643 | MO | school | 2918300 | 48071 | LEE'S SUMMIT R-VII | 291830001971 | 4030 | CEDAR CREEK ELEM. | Regular School | No | Elementary | KG | 06 | 2020 | k_12_total | 419 | 37 | 8 | * | 28 | * | 32 | 8 | 36 | 56 | 528 | 419 | 37 | 8 | 28 | 32 | 8 | 36 | 56 | 528 | ||||||||||||||||||||||||||||||||||
3302364 | 3302364 | MO | school | 2908250 | 48080 | CENTER 58 | 290825000223 | 4020 | BOONE ELEM. | Regular School | No | Elementary | KG | 05 | 2020 | k_12_total | 110 | 129 | 20 | * | * | * | 37 | 8 | 179 | 54 | 300 | 110 | 129 | 20 | 37 | 8 | 179 | 54 | 300 | |||||||||||||||||||||||||||||||||||
3303122 | 3303122 | MO | school | 2912300 | 50012 | FOX C-6 | 291230000500 | 2050 | FOX MIDDLE | Regular School | No | Middle | 06 | 08 | 2020 | k_12_total | 608 | 16 | 27 | * | 9 | * | 27 | 8 | 220 | 122 | 687 | 608 | 16 | 27 | 9 | 27 | 8 | 220 | 122 | 687 | ||||||||||||||||||||||||||||||||||
3303200 | 3303200 | MO | school | 2912300 | 50012 | FOX C-6 | 291230000507 | 5000 | SHERWOOD ELEM. | Regular School | No | Elementary | KG | 05 | 2020 | k_12_total | 348 | 9 | 8 | * | * | * | 18 | 8 | 130 | 85 | 386 | 348 | 9 | 8 | 18 | 8 | 130 | 85 | 386 | |||||||||||||||||||||||||||||||||||
3303442 | 3303442 | MO | school | 2918270 | 53113 | LEBANON R-III | 291827000973 | 4060 | MAPLECREST ELEM. | Regular School | No | Elementary | 02 | 03 | 2020 | k_12_total | 540 | * | 26 | * | 6 | * | 32 | 8 | 392 | 111 | 608 | 540 | 26 | 6 | 32 | 8 | 392 | 111 | 608 | |||||||||||||||||||||||||||||||||||
3303466 | 3303466 | MO | school | 2910080 | 54037 | CONCORDIA R-II | 291008000321 | 4020 | CONCORDIA ELEM. | Regular School | No | Elementary | PK | 06 | 2020 | k_12_total | 195 | * | 13 | * | 7 | * | * | 8 | 117 | 30 | 221 | 195 | 13 | 7 | 8 | 117 | 30 | 221 | ||||||||||||||||||||||||||||||||||||
3303718 | 3303718 | MO | school | 2911400 | 57002 | ELSBERRY R-II | 291140000406 | 4020 | CLARENCE CANNON ELEM. | Regular School | No | Elementary | PK | 04 | 2020 | k_12_total | 285 | 9 | 13 | * | * | * | 17 | 8 | 167.4 | 45 | 325 | 285 | 9 | 13 | 17 | 8 | 45 | 325 | ||||||||||||||||||||||||||||||||||||
3303728 | 3303728 | MO | school | 2930450 | 57003 | TROY R-III | 293045002090 | 1050 | TROY BUCHANAN HIGH | Regular School | No | High | 09 | 12 | 2020 | k_12_total | 1707 | 48 | 98 | * | 14 | * | 81 | 8 | 469 | 244 | 1951 | 1707 | 48 | 98 | 14 | 81 | 8 | 469 | 244 | 1951 | ||||||||||||||||||||||||||||||||||
3303991 | 3303991 | MO | school | 2920610 | 60077 | MCDONALD CO. R-I | 292061001106 | 5020 | WHITE ROCK ELEM. | Regular School | No | Elementary | PK | 08 | 2020 | k_12_total | 352 | * | 10 | 6 | 9 | * | 8 | 8 | 268 | 63 | 386 | 352 | 10 | 6 | 9 | 8 | 8 | 268 | 63 | 386 | ||||||||||||||||||||||||||||||||||
3305530 | 3305530 | MO | school | 2905370 | 84001 | BOLIVAR R-I | 290537001535 | 4040 | BOLIVAR INTERMEDIATE SCH. | Regular School | No | Elementary | 03 | 05 | 2020 | k_12_total | 520 | 6 | 29 | * | 6 | * | 16 | 8 | 289 | 83 | 580 | 520 | 6 | 29 | 6 | 16 | 8 | 289 | 83 | 580 | ||||||||||||||||||||||||||||||||||
3306051 | 3306051 | MO | school | 2908370 | 92087 | FT. ZUMWALT R-II | 290837002427 | 3070 | FT. ZUMWALT SOUTH MIDDLE | Regular School | No | Middle | 06 | 08 | 2020 | k_12_total | 721 | 82 | 49 | * | 41 | * | 50 | 8 | 162 | 120 | 944 | 721 | 82 | 49 | 41 | 50 | 8 | 162 | 120 | 944 | ||||||||||||||||||||||||||||||||||
3306328 | 3306328 | MO | school | 2931650 | 92089 | WENTZVILLE R-IV | 293165002456 | 4030 | HERITAGE INTERMEDIATE | Regular School | No | Elementary | 03 | 06 | 2020 | k_12_total | 617 | 64 | 39 | * | 10 | * | 51 | 8 | 191 | 162 | 782 | 617 | 64 | 39 | 10 | 51 | 8 | 191 | 162 | 782 | ||||||||||||||||||||||||||||||||||
3306382 | 3306382 | MO | school | 2931650 | 92089 | WENTZVILLE R-IV | 293165003149 | 4120 | LAKEVIEW ELEMENTARY | Regular School | No | Elementary | KG | 06 | 2020 | k_12_total | 612 | 65 | 40 | * | 8 | * | 47 | 8 | 145 | 107 | 775 | 612 | 65 | 40 | 8 | 47 | 8 | 145 | 107 | 775 | ||||||||||||||||||||||||||||||||||
3306562 | 3306562 | MO | school | 2911910 | 94078 | FARMINGTON R-VII | 291191000442 | 4030 | WASHINGTON-FRANKLIN ELEM. | Regular School | No | Elementary | 01 | 04 | 2020 | k_12_total | 316 | * | * | * | 13 | * | 13 | 8 | 184 | 29 | 349 | 316 | 13 | 13 | 8 | 184 | 29 | 349 | ||||||||||||||||||||||||||||||||||||
3306720 | 3306720 | MO | school | 2913830 | 96088 | HAZELWOOD | 291383003004 | 2130 | NORTH MIDDLE | Regular School | No | Middle | 06 | 08 | 2020 | k_12_total | 80 | 719 | 13 | * | 9 | * | 12 | 8 | 423 | 126 | 837 | 80 | 719 | 13 | 9 | 12 | 8 | 423 | 126 | 837 | ||||||||||||||||||||||||||||||||||
3306948 | 3306948 | MO | school | 2912010 | 96089 | FERGUSON-FLORISSANT R-II | 291201000460 | 4140 | DUCHESNE ELEMENTARY | Regular School | No | Elementary | PK | 02 | 2020 | k_12_total | 52 | 207 | 13 | * | * | * | 25 | 8 | * | 50 | 299 | 52 | 207 | 13 | 25 | 8 | 50 | 299 | ||||||||||||||||||||||||||||||||||||
3307241 | 3307241 | MO | school | 2926850 | 96091 | ROCKWOOD R-VI | 292685002762 | 4170 | BLEVINS ELEM. | Regular School | No | Elementary | KG | 05 | 2020 | k_12_total | 415 | 23 | 13 | * | * | * | 13 | 8 | 63 | 78 | 464 | 415 | 23 | 13 | 13 | 8 | 63 | 78 | 464 | |||||||||||||||||||||||||||||||||||
3307454 | 3307454 | MO | school | 2920670 | 96094 | MEHLVILLE R-IX | 292067003320 | 5080 | MOSAIC ELEMENTARY | Regular School | No | Elementary | KG | 05 | 2020 | k_12_total | 220 | * | 11 | * | 8 | * | 12 | 8 | 28 | 40 | 254 | 220 | 11 | 8 | 12 | 8 | 28 | 40 | 254 | |||||||||||||||||||||||||||||||||||
3307581 | 3307581 | MO | school | 2923580 | 96095 | PARKWAY C-2 | 292358001390 | 4160 | MASON RIDGE ELEM. | Regular School | No | Elementary | KG | 05 | 2020 | k_12_total | 330 | 57 | 10 | * | 40 | * | 26 | 8 | 59 | 55 | 464 | 330 | 57 | 10 | 40 | 26 | 8 | 59 | 55 | 464 | ||||||||||||||||||||||||||||||||||
3307697 | 3307697 | MO | school | 2905880 | 96101 | BRENTWOOD | 290588000133 | 4060 | MCGRATH ELEM. | Regular School | No | Elementary | KG | 05 | 2020 | k_12_total | 139 | 19 | 9 | * | 12 | * | 18 | 8 | 31 | 25 | 197 | 139 | 19 | 9 | 12 | 18 | 8 | 31 | 25 | 197 | ||||||||||||||||||||||||||||||||||
3307820 | 3307820 | MO | school | 2917820 | 96106 | LADUE | 291782000942 | 4040 | CONWAY ELEM. | Regular School | No | Elementary | KG | 04 | 2020 | k_12_total | 233 | 22 | 14 | * | 52 | * | 25 | 8 | 14 | 48 | 347 | 233 | 22 | 14 | 52 | 25 | 8 | 14 | 48 | 347 | ||||||||||||||||||||||||||||||||||
3307873 | 3307873 | MO | school | 2922650 | 96109 | NORMANDY SCHOOLS COLLABORATIVE | 292265001248 | 1050 | NORMANDY HIGH | Regular School | No | High | 09 | 12 | 2020 | k_12_total | 18 | 621 | 9 | * | * | * | 9 | 8 | 626.2 | 85 | 659 | 18 | 621 | 9 | 9 | 8 | 85 | 659 | ||||||||||||||||||||||||||||||||||||
3307977 | 3307977 | MO | school | 2926670 | 96111 | RIVERVIEW GARDENS | 292667001586 | 1050 | RIVERVIEW GARDENS SR. HIGH | Regular School | No | High | 09 | 12 | 2020 | k_12_total | 6 | 1146 | 6 | * | * | * | * | 8 | * | 215 | 1159 | 6 | 1146 | 6 | 8 | 215 | 1159 | |||||||||||||||||||||||||||||||||||||
3308019 | 3308019 | MO | school | 2926670 | 96111 | RIVERVIEW GARDENS | 292667001582 | 5000 | LEMASTERS ELEM. | Regular School | No | Elementary | KG | 05 | 2020 | k_12_total | * | 301 | 6 | * | * | * | * | 8 | * | 44 | 308 | 301 | 6 | 8 | 44 | 308 | ||||||||||||||||||||||||||||||||||||||
3308073 | 3308073 | MO | school | 2930660 | 96112 | UNIVERSITY CITY | 293066002107 | 4100 | FLYNN PARK ELEM. | Regular School | No | Elementary | KG | 05 | 2020 | k_12_total | 108 | 144 | 13 | * | 12 | * | 23 | 8 | * | 49 | 301 | 108 | 144 | 13 | 12 | 23 | 8 | 49 | 301 | |||||||||||||||||||||||||||||||||||
3297659 | 3297659 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001649 | 4040 | EDISON ELEM. | Regular School | No | Elementary | PK | 06 | 2020 | k_12_total | 159 | 57 | 78 | * | * | 17 | 60 | 79 | * | 47 | 375 | 159 | 57 | 78 | 17 | 60 | 79 | 47 | 375 | |||||||||||||||||||||||||||||||||||
3299191 | 3299191 | MO | school | 2922800 | 24093 | NORTH KANSAS CITY 74 | 292280003115 | 4040 | BELL PRAIRIE ELEMENTARY | Regular School | No | Elementary | PK | 05 | 2020 | k_12_total | 441 | 77 | 74 | * | 31 | 6 | 39 | 79 | 132 | 57 | 670 | 441 | 77 | 74 | 31 | 6 | 39 | 79 | 132 | 57 | 670 | |||||||||||||||||||||||||||||||||
3307961 | 3307961 | MO | school | 2926640 | 96110 | RITENOUR | 292664001571 | 4160 | MARVIN ELEM. | Regular School | No | Elementary | KG | 05 | 2020 | k_12_total | 148 | 221 | 111 | * | 6 | * | 63 | 79 | 78.4 | 97 | 552 | 148 | 221 | 111 | 6 | 63 | 79 | 97 | 552 | |||||||||||||||||||||||||||||||||||
3307754 | 3307754 | MO | school | 2913620 | 96103 | HANCOCK PLACE | 291362000584 | 4020 | HANCOCK PLACE ELEM. | Regular School | No | Elementary | PK | 05 | 2020 | k_12_total | 380 | 133 | 43 | * | 9 | * | 64 | 78 | * | 113 | 629 | 380 | 133 | 43 | 9 | 64 | 78 | 113 | 629 | |||||||||||||||||||||||||||||||||||
3309827 | 3309827 | MO | school | 2929280 | 115115 | ST. LOUIS CITY | 292928002026 | 6120 | WOODWARD ELEM. | Regular School | No | Elementary | PK | 05 | 2020 | k_12_total | 26 | 180 | 24 | * | 7 | * | * | 78 | * | 35 | 237 | 26 | 180 | 24 | 7 | 78 | 35 | 237 | ||||||||||||||||||||||||||||||||||||
3297001 | 3297001 | MO | school | 2921120 | 5128 | MONETT R-I | 292112001595 | 4040 | MONETT INTERMEDIATE | Regular School | No | Middle | 05 | 06 | 2020 | k_12_total | 206 | * | 138 | * | 20 | * | 12 | 77 | 250 | 58 | 383 | 206 | 138 | 20 | 12 | 77 | 250 | 58 | 383 | |||||||||||||||||||||||||||||||||||
3304713 | 3304713 | MO | school | 2921810 | 73108 | NEOSHO SCHOOL DISTRICT | 292181001204 | 4040 | CENTRAL ELEM. | Regular School | No | Elementary | KG | 04 | 2020 | k_12_total | 85 | * | 56 | * | * | 43 | 14 | 77 | 168 | 42 | 201 | 85 | 56 | 43 | 14 | 77 | 168 | 42 | 201 | |||||||||||||||||||||||||||||||||||
3307049 | 3307049 | MO | school | 2923700 | 96090 | PATTONVILLE R-III | 292370002848 | 5060 | ROBERT DRUMMOND ELEM. | Regular School | No | Elementary | PK | 05 | 2020 | k_12_total | 209 | 319 | 92 | * | 14 | * | 76 | 77 | 469 | 85 | 713 | 209 | 319 | 92 | 14 | 76 | 77 | 469 | 85 | 713 | ||||||||||||||||||||||||||||||||||
3309979 | 3309979 | MO | school | 2900592 | 115916 | GATEWAY SCIENCE ACAD/ST LOUIS | 290059203241 | 6997 | GATEWAY SCIENCE ACAD-SOUTH ELE | Regular School | Yes | Elementary | KG | 05 | 2020 | k_12_total | 229 | 127 | 32 | * | 10 | * | 47 | 77 | 315 | 44 | 445 | 229 | 127 | 32 | 10 | 47 | 77 | 315 | 44 | 445 | ||||||||||||||||||||||||||||||||||
3299209 | 3299209 | MO | school | 2922800 | 24093 | NORTH KANSAS CITY 74 | 292280001263 | 4100 | CHOUTEAU ELEMENTARY | Regular School | No | Elementary | PK | 05 | 2020 | k_12_total | 130 | 80 | 59 | * | 7 | 7 | 52 | 76 | 272 | 34 | 335 | 130 | 80 | 59 | 7 | 7 | 52 | 76 | 272 | 34 | 335 | |||||||||||||||||||||||||||||||||
3302705 | 3302705 | MO | school | 2907460 | 49142 | CARTHAGE R-IX | 290746001980 | 4030 | STEADLEY ELEM. | Regular School | No | Elementary | KG | 04 | 2020 | k_12_total | 373 | * | 100 | * | 5 | * | 14 | 76 | 271 | 83 | 500 | 373 | 100 | 5 | 14 | 76 | 271 | 83 | 500 |
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]);