enrollments
Data source: Big Local News · About: Big Local
257,968 rows where state = "MO" sorted by ell descending
This data as json, CSV (advanced)
grade ✖
- grade_1 16,123
- grade_10 16,123
- grade_11 16,123
- grade_12 16,123
- grade_2 16,123
- grade_3 16,123
- grade_4 16,123
- grade_5 16,123
- grade_6 16,123
- grade_7 16,123
- grade_8 16,123
- grade_9 16,123
- k_12_total 16,123
- kindergarten 16,123
- pk_12_total 16,123
- pre_kindergarten 16,123
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3307231 | 3307231 | MO | school | 2926850 | 96091 | ROCKWOOD R-VI | 292685002700 | 4165 | WILD HORSE ELEM. | Regular School | No | 1 | KG | 05 | 2016 | k_12_total | 266 | 51 | 49 | * | 174 | * | 7 | 99 | 116 | 68 | 550 | 266 | 51 | 49 | 174 | 7 | 99 | 116 | 68 | 550 | ||||||||||||||||||||||||||||||||||
3307232 | 3307232 | MO | school | 2926850 | 96091 | ROCKWOOD R-VI | 292685002700 | 4165 | WILD HORSE ELEM. | Regular School | No | Elementary | KG | 05 | 2017 | k_12_total | 228 | 46 | 47 | * | 205 | * | 9 | 99 | 99 | 61 | 538 | 228 | 46 | 47 | 205 | 9 | 99 | 99 | 61 | 538 | ||||||||||||||||||||||||||||||||||
3307349 | 3307349 | MO | school | 2918690 | 96093 | LINDBERGH SCHOOLS | 291869001025 | 5060 | SAPPINGTON ELEM. | Regular School | No | Elementary | KG | 05 | 2017 | k_12_total | 636 | 8 | 41 | * | 41 | * | 43 | 99 | 173 | 108 | 771 | 636 | 8 | 41 | 41 | 43 | 99 | 173 | 108 | 771 | ||||||||||||||||||||||||||||||||||
3307536 | 3307536 | MO | school | 2923580 | 96095 | PARKWAY C-2 | 292358001377 | 4035 | CARMAN TRAILS ELEM. | Regular School | No | Elementary | PK | 05 | 2017 | k_12_total | 232 | 59 | 87 | * | 44 | * | 30 | 99 | 191 | 62 | 453 | 232 | 59 | 87 | 44 | 30 | 99 | 191 | 62 | 453 | ||||||||||||||||||||||||||||||||||
3302014 | 3302014 | MO | school | 2915480 | 48077 | INDEPENDENCE 30 | 291548003090 | 3060 | CLIFFORD H. NOWLIN MIDDLE | Regular School | No | Middle | 06 | 08 | 2018 | k_12_total | 468 | 111 | 290 | * | * | * | 68 | 99 | 814 | 125 | 945 | 468 | 111 | 290 | 68 | 99 | 814 | 125 | 945 | |||||||||||||||||||||||||||||||||||
3307947 | 3307947 | MO | school | 2926640 | 96110 | RITENOUR | 292664001569 | 4120 | KRATZ ELEM. | Regular School | No | Elementary | KG | 05 | 2018 | k_12_total | 107 | 246 | 112 | * | * | * | 54 | 99 | * | 88 | 524 | 107 | 246 | 112 | 54 | 99 | 88 | 524 | ||||||||||||||||||||||||||||||||||||
3309729 | 3309729 | MO | school | 2929280 | 115115 | ST. LOUIS CITY | 292928001930 | 5340 | MASON ELEM. | Regular School | No | Elementary | PK | 06 | 2018 | k_12_total | 126 | 143 | 57 | * | 15 | * | * | 99 | * | 72 | 343 | 126 | 143 | 57 | 15 | 99 | 72 | 343 | ||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
3300528 | 3300528 | MO | school | 2928860 | 39141 | SPRINGFIELD R-XII | 292886001786 | 1050 | CENTRAL HIGH | Regular School | No | 4 | 06 | 12 | 2016 | k_12_total | 1258 | 188 | 135 | 11 | 110 | 9 | 37 | 98 | 854 | 95 | 1748 | 1258 | 188 | 135 | 11 | 110 | 9 | 37 | 98 | 854 | 95 | 1748 | ||||||||||||||||||||||||||||||||
3301982 | 3301982 | MO | school | 2915480 | 48077 | INDEPENDENCE 30 | 291548000722 | 1050 | TRUMAN HIGH | Regular School | No | 3 | 09 | 12 | 2016 | k_12_total | 1014 | 177 | 266 | * | 33 | 19 | 92 | 98 | 776.1 | 126 | 1605 | 1014 | 177 | 266 | 33 | 19 | 92 | 98 | 126 | 1605 | ||||||||||||||||||||||||||||||||||
3302067 | 3302067 | MO | school | 2915480 | 48077 | INDEPENDENCE 30 | 291548003107 | 5100 | KORTE ELEM. | Regular School | No | 1 | PK | 05 | 2016 | k_12_total | 291 | 58 | 177 | * | * | * | 50 | 98 | 521 | 40 | 585 | 291 | 58 | 177 | 50 | 98 | 521 | 40 | 585 | |||||||||||||||||||||||||||||||||||
3307418 | 3307418 | MO | school | 2920670 | 96094 | MEHLVILLE R-IX | 292067002420 | 4080 | FORDER ELEM. | Regular School | No | Elementary | KG | 05 | 2017 | k_12_total | 338 | 29 | 14 | * | 16 | * | 29 | 98 | 208 | 72 | 428 | 338 | 29 | 14 | 16 | 29 | 98 | 208 | 72 | 428 | ||||||||||||||||||||||||||||||||||
3307047 | 3307047 | MO | school | 2923700 | 96090 | PATTONVILLE R-III | 292370002848 | 5060 | ROBERT DRUMMOND ELEM. | Regular School | No | Elementary | PK | 05 | 2018 | k_12_total | 239 | 310 | 90 | * | 19 | * | 61 | 98 | 510 | 113 | 722 | 239 | 310 | 90 | 19 | 61 | 98 | 510 | 113 | 722 | ||||||||||||||||||||||||||||||||||
3302542 | 3302542 | MO | school | 2900590 | 48922 | FRONTIER SCHOOLS | 290059003232 | 1985 | FRONTIER STEM HIGH SCHOOL | Regular School | Yes | High | 09 | 12 | 2019 | k_12_total | 23 | 96 | 221 | * | 5 | * | * | 98 | * | 16 | 345 | 23 | 96 | 221 | 5 | 98 | 16 | 345 | ||||||||||||||||||||||||||||||||||||
3309730 | 3309730 | MO | school | 2929280 | 115115 | ST. LOUIS CITY | 292928001930 | 5340 | MASON ELEM. | Regular School | No | Elementary | PK | 06 | 2019 | k_12_total | 163 | 141 | 58 | * | 13 | * | * | 98 | * | 81 | 378 | 163 | 141 | 58 | 13 | 98 | 81 | 378 | ||||||||||||||||||||||||||||||||||||
3304702 | 3304702 | MO | school | 2921810 | 73108 | NEOSHO R-V | 292181001203 | 4020 | BENTON ELEM. | Regular School | No | 1 | KG | 04 | 2015 | k_12_total | 304 | * | 108 | 11 | * | 29 | 22 | 97 | 353.4 | 58 | 478 | 304 | 108 | 11 | 29 | 22 | 97 | 58 | 478 | |||||||||||||||||||||||||||||||||||
3307416 | 3307416 | MO | school | 2920670 | 96094 | MEHLVILLE R-IX | 292067002420 | 4080 | FORDER ELEM. | Regular School | No | 1 | KG | 05 | 2015 | k_12_total | 371 | 30 | 19 | * | 10 | * | 29 | 97 | 220 | 65 | 462 | 371 | 30 | 19 | 10 | 29 | 97 | 220 | 65 | 462 | ||||||||||||||||||||||||||||||||||
3299187 | 3299187 | MO | school | 2922800 | 24093 | NORTH KANSAS CITY 74 | 292280003115 | 4040 | BELL PRAIRIE ELEMENTARY | Regular School | No | 1 | PK | 05 | 2016 | k_12_total | 447 | 61 | 67 | * | 25 | * | 23 | 97 | 190 | 51 | 627 | 447 | 61 | 67 | 25 | 23 | 97 | 190 | 51 | 627 | ||||||||||||||||||||||||||||||||||
3307417 | 3307417 | MO | school | 2920670 | 96094 | MEHLVILLE R-IX | 292067002420 | 4080 | FORDER ELEM. | Regular School | No | 1 | KG | 05 | 2016 | k_12_total | 351 | 30 | 16 | * | 16 | * | 24 | 97 | 212 | 66 | 439 | 351 | 30 | 16 | 16 | 24 | 97 | 212 | 66 | 439 | ||||||||||||||||||||||||||||||||||
3302548 | 3302548 | MO | school | 2900590 | 48922 | FRONTIER SCHOOLS | 290059003182 | 3935 | FRONTIER SCHL OF INNOVATION-M | Regular School | Yes | Middle | 06 | 08 | 2019 | k_12_total | 11 | 51 | 242 | * | * | * | * | 97 | * | 16 | 308 | 11 | 51 | 242 | 97 | 16 | 308 | |||||||||||||||||||||||||||||||||||||
3307915 | 3307915 | MO | school | 2926640 | 96110 | RITENOUR | 292664001573 | 1050 | RITENOUR SR. HIGH | Regular School | No | 3 | 09 | 12 | 2016 | k_12_total | 635 | 795 | 283 | 5 | 36 | * | 75 | 96 | 1204 | 261 | 1830 | 635 | 795 | 283 | 5 | 36 | 75 | 96 | 1204 | 261 | 1830 | |||||||||||||||||||||||||||||||||
3309721 | 3309721 | MO | school | 2929280 | 115115 | ST. LOUIS CITY | 292928001968 | 5260 | MANN ELEM. | Regular School | No | 1 | PK | 06 | 2016 | k_12_total | 35 | 143 | 37 | * | 27 | * | * | 96 | * | 40 | 242 | 35 | 143 | 37 | 27 | 96 | 40 | 242 | ||||||||||||||||||||||||||||||||||||
3302541 | 3302541 | MO | school | 2900590 | 48922 | FRONTIER SCHOOLS | 290059003232 | 1985 | FRONTIER STEM HIGH SCHOOL | Regular School | Yes | High | 09 | 12 | 2018 | k_12_total | 19 | 86 | 213 | * | 6 | * | * | 96 | * | 16 | 324 | 19 | 86 | 213 | 6 | 96 | 16 | 324 | ||||||||||||||||||||||||||||||||||||
3304711 | 3304711 | MO | school | 2921810 | 73108 | NEOSHO SCHOOL DISTRICT | 292181001204 | 4040 | CENTRAL ELEM. | Regular School | No | Elementary | KG | 04 | 2018 | k_12_total | 106 | * | 70 | * | * | 45 | 13 | 96 | 175 | 41 | 238 | 106 | 70 | 45 | 13 | 96 | 175 | 41 | 238 | |||||||||||||||||||||||||||||||||||
3307420 | 3307420 | MO | school | 2920670 | 96094 | MEHLVILLE R-IX | 292067002420 | 4080 | FORDER ELEM. | Regular School | No | Elementary | KG | 05 | 2019 | k_12_total | 277 | 19 | 13 | * | 21 | * | 16 | 96 | 165 | 50 | 347 | 277 | 19 | 13 | 21 | 16 | 96 | 165 | 50 | 347 | ||||||||||||||||||||||||||||||||||
3302481 | 3302481 | MO | school | 2900013 | 48912 | DELLA LAMB ELEM. | 290001303275 | 6931 | DELLA LAMB @ WOODLAND | Regular School | Yes | 1 | KG | 01 | 2016 | k_12_total | * | 89 | 22 | * | 13 | * | * | 95 | * | * | 131 | 89 | 22 | 13 | 95 | 131 | ||||||||||||||||||||||||||||||||||||||
3303936 | 3303936 | MO | school | 2920610 | 60077 | MCDONALD CO. R-I | 292061001104 | 1050 | MCDONALD COUNTY HIGH | Regular School | No | High | 09 | 12 | 2019 | k_12_total | 747 | 12 | 237 | 31 | 19 | 33 | 17 | 95 | 640 | 180 | 1096 | 747 | 12 | 237 | 31 | 19 | 33 | 17 | 95 | 640 | 180 | 1096 | ||||||||||||||||||||||||||||||||
3305682 | 3305682 | MO | school | 2931440 | 85046 | WAYNESVILLE R-VI | 293144002898 | 4050 | FREEDOM ELEM. | Regular School | No | Elementary | KG | 05 | 2019 | k_12_total | 604 | 142 | 126 | 10 | 24 | 15 | 168 | 95 | 476.2 | 164 | 1089 | 604 | 142 | 126 | 10 | 24 | 15 | 168 | 95 | 164 | 1089 | |||||||||||||||||||||||||||||||||
3299128 | 3299128 | MO | school | 2922800 | 24093 | NORTH KANSAS CITY 74 | 292280001284 | 1050 | NORTH KANSAS CITY HIGH | Regular School | No | 3 | 09 | 12 | 2015 | k_12_total | 776 | 281 | 259 | 7 | 105 | 13 | 114 | 94 | 804.1 | 128 | 1555 | 776 | 281 | 259 | 7 | 105 | 13 | 114 | 94 | 128 | 1555 | |||||||||||||||||||||||||||||||||
3297620 | 3297620 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001648 | 1075 | CENTRAL HIGH | Regular School | No | High | 09 | 12 | 2017 | k_12_total | 1263 | 126 | 152 | 6 | 57 | 10 | 76 | 94 | 654 | 202 | 1690 | 1263 | 126 | 152 | 6 | 57 | 10 | 76 | 94 | 654 | 202 | 1690 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
3307944 | 3307944 | MO | school | 2926640 | 96110 | RITENOUR | 292664001569 | 4120 | KRATZ ELEM. | Regular School | No | 1 | KG | 05 | 2015 | k_12_total | 110 | 263 | 107 | * | 5 | * | 64 | 93 | * | 65 | 550 | 110 | 263 | 107 | 5 | 64 | 93 | 65 | 550 | |||||||||||||||||||||||||||||||||||
3297685 | 3297685 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001654 | 4140 | COLEMAN ELEM. | Regular School | No | 1 | PK | 06 | 2016 | k_12_total | 186 | 69 | 49 | * | 33 | 5 | 36 | 93 | 326 | 61 | 378 | 186 | 69 | 49 | 33 | 5 | 36 | 93 | 326 | 61 | 378 | |||||||||||||||||||||||||||||||||
3307535 | 3307535 | MO | school | 2923580 | 96095 | PARKWAY C-2 | 292358001377 | 4035 | CARMAN TRAILS ELEM. | Regular School | No | 1 | PK | 05 | 2016 | k_12_total | 246 | 63 | 81 | * | 44 | * | 22 | 93 | 180.2 | 56 | 458 | 246 | 63 | 81 | 44 | 22 | 93 | 56 | 458 | |||||||||||||||||||||||||||||||||||
3305169 | 3305169 | MO | school | 2927830 | 80125 | SEDALIA 200 | 292783001703 | 4020 | HEBER HUNT ELEM. | Regular School | No | Elementary | KG | 04 | 2017 | k_12_total | 278 | 45 | 122 | * | * | * | 31 | 93 | * | 85 | 482 | 278 | 45 | 122 | 31 | 93 | 85 | 482 | ||||||||||||||||||||||||||||||||||||
3307066 | 3307066 | MO | school | 2923700 | 96090 | PATTONVILLE R-III | 292370001423 | 6060 | WILLOW BROOK ELEM. | Regular School | No | Elementary | PK | 05 | 2019 | k_12_total | 159 | 154 | 94 | * | 38 | * | 44 | 93 | 190 | 70 | 491 | 159 | 154 | 94 | 38 | 44 | 93 | 190 | 70 | 491 | ||||||||||||||||||||||||||||||||||
3307948 | 3307948 | MO | school | 2926640 | 96110 | RITENOUR | 292664001569 | 4120 | KRATZ ELEM. | Regular School | No | Elementary | KG | 05 | 2019 | k_12_total | 89 | 251 | 117 | * | * | * | 53 | 93 | * | 73 | 517 | 89 | 251 | 117 | 53 | 93 | 73 | 517 | ||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
3297450 | 3297450 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100000298 | 4040 | BLUE RIDGE ELEM. | Regular School | No | 1 | PK | 05 | 2016 | k_12_total | 142 | 143 | 101 | * | 21 | * | 46 | 92 | * | 53 | 456 | 142 | 143 | 101 | 21 | 46 | 92 | 53 | 456 | |||||||||||||||||||||||||||||||||||
3309477 | 3309477 | MO | school | 2929280 | 115115 | ST. LOUIS CITY | 292928000790 | 1730 | SOLDAN INTERNATIONAL STUDIES | Regular School | No | High | 09 | 12 | 2017 | k_12_total | 16 | 496 | 36 | * | 25 | * | * | 92 | * | 19 | 574 | 16 | 496 | 36 | 25 | 92 | 19 | 574 | ||||||||||||||||||||||||||||||||||||
3309722 | 3309722 | MO | school | 2929280 | 115115 | ST. LOUIS CITY | 292928001968 | 5260 | MANN ELEM. | Regular School | No | Elementary | PK | 06 | 2017 | k_12_total | 40 | 149 | 37 | * | 28 | * | * | 92 | * | 39 | 254 | 40 | 149 | 37 | 28 | 92 | 39 | 254 | ||||||||||||||||||||||||||||||||||||
3305497 | 3305497 | MO | school | 2923550 | 83005 | PARK HILL | 292355003221 | 5090 | TIFFANY RIDGE ELEMENTARY SCHL | Regular School | No | Elementary | KG | 05 | 2018 | k_12_total | 374 | 120 | 74 | * | 38 | * | 46 | 92 | 196 | 41 | 656 | 374 | 120 | 74 | 38 | 46 | 92 | 196 | 41 | 656 | ||||||||||||||||||||||||||||||||||
3307035 | 3307035 | MO | school | 2923700 | 96090 | PATTONVILLE R-III | 292370001412 | 4060 | BRIDGEWAY ELEM. | Regular School | No | Elementary | PK | 05 | 2018 | k_12_total | 164 | 139 | 96 | * | 10 | * | 33 | 92 | 249 | 65 | 443 | 164 | 139 | 96 | 10 | 33 | 92 | 249 | 65 | 443 | ||||||||||||||||||||||||||||||||||
3307954 | 3307954 | MO | school | 2926640 | 96110 | RITENOUR | 292664001570 | 4140 | MARION ELEM. | Regular School | No | Elementary | KG | 05 | 2019 | k_12_total | 117 | 185 | 137 | * | 5 | * | 57 | 92 | * | 86 | 501 | 117 | 185 | 137 | 5 | 57 | 92 | 86 | 501 | |||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
3305167 | 3305167 | MO | school | 2927830 | 80125 | SEDALIA 200 | 292783001703 | 4020 | HEBER HUNT ELEM. | Regular School | No | 1 | KG | 04 | 2015 | k_12_total | 267 | 42 | 125 | 5 | * | * | 34 | 91 | * | 67 | 475 | 267 | 42 | 125 | 5 | 34 | 91 | 67 | 475 | |||||||||||||||||||||||||||||||||||
3307582 | 3307582 | MO | school | 2923580 | 96095 | PARKWAY C-2 | 292358001391 | 4180 | MCKELVEY ELEM. | Regular School | No | 1 | KG | 05 | 2015 | k_12_total | 201 | 78 | 23 | * | 172 | * | 36 | 91 | 107 | 72 | 510 | 201 | 78 | 23 | 172 | 36 | 91 | 107 | 72 | 510 | ||||||||||||||||||||||||||||||||||
3304709 | 3304709 | MO | school | 2921810 | 73108 | NEOSHO R-V | 292181001204 | 4040 | CENTRAL ELEM. | Regular School | No | 1 | KG | 04 | 2016 | k_12_total | 138 | * | 76 | * | * | 31 | 15 | 91 | 210 | 49 | 261 | 138 | 76 | 31 | 15 | 91 | 210 | 49 | 261 | |||||||||||||||||||||||||||||||||||
3299166 | 3299166 | MO | school | 2922800 | 24093 | NORTH KANSAS CITY 74 | 292280001278 | 3150 | MAPLE PARK MIDDLE | Regular School | No | Middle | 06 | 08 | 2017 | k_12_total | 429 | 150 | 137 | 8 | 27 | * | 44 | 91 | 540 | 130 | 798 | 429 | 150 | 137 | 8 | 27 | 44 | 91 | 540 | 130 | 798 | |||||||||||||||||||||||||||||||||
3307946 | 3307946 | MO | school | 2926640 | 96110 | RITENOUR | 292664001569 | 4120 | KRATZ ELEM. | Regular School | No | Elementary | KG | 05 | 2017 | k_12_total | 109 | 255 | 107 | * | * | * | 53 | 91 | * | 76 | 529 | 109 | 255 | 107 | 53 | 91 | 76 | 529 | ||||||||||||||||||||||||||||||||||||
3309825 | 3309825 | MO | school | 2929280 | 115115 | ST. LOUIS CITY | 292928002026 | 6120 | WOODWARD ELEM. | Regular School | No | Elementary | PK | 05 | 2018 | k_12_total | 23 | 218 | 29 | * | 11 | * | * | 91 | * | 34 | 281 | 23 | 218 | 29 | 11 | 91 | 34 | 281 | ||||||||||||||||||||||||||||||||||||
3307378 | 3307378 | MO | school | 2920670 | 96094 | MEHLVILLE R-IX | 292067001114 | 3000 | MARGARET BUERKLE MIDDLE | Regular School | No | Middle | 06 | 08 | 2019 | k_12_total | 478 | 63 | 37 | 5 | 31 | * | 32 | 91 | 277 | 91 | 647 | 478 | 63 | 37 | 5 | 31 | 32 | 91 | 277 | 91 | 647 | |||||||||||||||||||||||||||||||||
3305168 | 3305168 | MO | school | 2927830 | 80125 | SEDALIA 200 | 292783001703 | 4020 | HEBER HUNT ELEM. | Regular School | No | 1 | KG | 04 | 2016 | k_12_total | 277 | 38 | 116 | * | * | * | 35 | 90 | * | 80 | 473 | 277 | 38 | 116 | 35 | 90 | 80 | 473 | ||||||||||||||||||||||||||||||||||||
3309907 | 3309907 | MO | school | 2900586 | 115912 | ST. LOUIS LANG IMMERSION SCH | 290058603124 | 6961 | ST LOUIS LANG IMMERSION MARINE | Regular School | Yes | Elementary | KG | 08 | 2018 | k_12_total | 186 | 368 | 92 | * | 14 | * | 49 | 90 | 400.2 | 71 | 709 | 186 | 368 | 92 | 14 | 49 | 90 | 71 | 709 | |||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
3296853 | 3296853 | MO | school | 2920810 | 4110 | MEXICO 59 | 292081001137 | 1050 | MEXICO HIGH | Regular School | No | 3 | 09 | 12 | 2015 | k_12_total | 561 | 55 | 26 | * | * | * | 29 | 9 | 262 | 65 | 675 | 561 | 55 | 26 | 29 | 9 | 262 | 65 | 675 | |||||||||||||||||||||||||||||||||||
3297722 | 3297722 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001667 | 4390 | PARKWAY ELEM. | Regular School | No | 1 | PK | 06 | 2015 | k_12_total | 367 | 30 | 20 | * | * | * | 17 | 9 | 293 | 69 | 440 | 367 | 30 | 20 | 17 | 9 | 293 | 69 | 440 | |||||||||||||||||||||||||||||||||||
3298066 | 3298066 | MO | school | 2906990 | 15002 | CAMDENTON R-III | 290699002580 | 4030 | OAK RIDGE INTERMEDIATE | Regular School | No | 2 | 05 | 06 | 2015 | k_12_total | 557 | 11 | 28 | 5 | 6 | * | * | 9 | 352 | 76 | 609 | 557 | 11 | 28 | 5 | 6 | 9 | 352 | 76 | 609 | ||||||||||||||||||||||||||||||||||
3298831 | 3298831 | MO | school | 2923430 | 22093 | OZARK R-VI | 292343000470 | 4060 | UPPER ELEM. | Regular School | No | 2 | 05 | 06 | 2015 | k_12_total | 745 | 8 | 39 | 8 | * | * | 25 | 9 | 300 | 75 | 830 | 745 | 8 | 39 | 8 | 25 | 9 | 300 | 75 | 830 | ||||||||||||||||||||||||||||||||||
3299044 | 3299044 | MO | school | 2918540 | 24090 | LIBERTY 53 | 291854003238 | 3090 | HERITAGE MIDDLE SCHOOL | Regular School | No | 2 | 06 | 08 | 2015 | k_12_total | 567 | 39 | 35 | * | 24 | * | 12 | 9 | 161 | 66 | 685 | 567 | 39 | 35 | 24 | 12 | 9 | 161 | 66 | 685 | ||||||||||||||||||||||||||||||||||
3299086 | 3299086 | MO | school | 2918540 | 24090 | LIBERTY 53 | 291854002804 | 4140 | SHOAL CREEK ELEM. | Regular School | No | 1 | KG | 05 | 2015 | k_12_total | 719 | 26 | 21 | * | 29 | * | 14 | 9 | 37 | 64 | 812 | 719 | 26 | 21 | 29 | 14 | 9 | 37 | 64 | 812 | ||||||||||||||||||||||||||||||||||
3299210 | 3299210 | MO | school | 2922800 | 24093 | NORTH KANSAS CITY 74 | 292280002731 | 4110 | NORTHVIEW ELEM. | Regular School | No | 1 | KG | 05 | 2015 | k_12_total | 577 | 70 | 50 | * | 16 | * | 63 | 9 | 143 | 76 | 779 | 577 | 70 | 50 | 16 | 63 | 9 | 143 | 76 | 779 | ||||||||||||||||||||||||||||||||||
3300109 | 3300109 | MO | school | 2930570 | 36131 | UNION R-XI | 293057002098 | 4040 | CENTRAL ELEM. | Regular School | No | 1 | PK | 03 | 2015 | k_12_total | 739 | 12 | 23 | * | * | * | 35 | 9 | 461 | 62 | 810 | 739 | 12 | 23 | 35 | 9 | 461 | 62 | 810 | |||||||||||||||||||||||||||||||||||
3300701 | 3300701 | MO | school | 2928860 | 39141 | SPRINGFIELD R-XII | 292886001830 | 4340 | WALT DISNEY ELEM. | Regular School | No | 1 | KG | 05 | 2015 | k_12_total | 455 | 17 | 19 | * | 18 | * | 27 | 9 | 161 | 45 | 541 | 455 | 17 | 19 | 18 | 27 | 9 | 161 | 45 | 541 | ||||||||||||||||||||||||||||||||||
3300767 | 3300767 | MO | school | 2928860 | 39141 | SPRINGFIELD R-XII | 292886001824 | 4640 | SHERWOOD ELEM. | Regular School | No | 1 | KG | 05 | 2015 | k_12_total | 206 | 19 | 18 | * | 6 | * | 25 | 9 | 153.2 | 32 | 275 | 206 | 19 | 18 | 6 | 25 | 9 | 32 | 275 | |||||||||||||||||||||||||||||||||||
3300803 | 3300803 | MO | school | 2928860 | 39141 | SPRINGFIELD R-XII | 292886001834 | 4780 | WESTPORT ELEM. | Regular School | No | 1 | KG | 05 | 2015 | k_12_total | 393 | 31 | 19 | * | * | * | 24 | 9 | 402.4 | 58 | 469 | 393 | 31 | 19 | 24 | 9 | 58 | 469 | ||||||||||||||||||||||||||||||||||||
3301379 | 3301379 | MO | school | 2912290 | 48066 | FORT OSAGE R-I | 291229000493 | 4080 | ELM GROVE ELEM. | Regular School | No | 1 | KG | 04 | 2015 | k_12_total | 261 | 36 | 32 | * | * | 11 | 18 | 9 | 271 | 40 | 362 | 261 | 36 | 32 | 11 | 18 | 9 | 271 | 40 | 362 | ||||||||||||||||||||||||||||||||||
3301446 | 3301446 | MO | school | 2905310 | 48068 | BLUE SPRINGS R-IV | 290531000080 | 4040 | FRANKLIN SMITH ELEM. | Regular School | No | 1 | PK | 05 | 2015 | k_12_total | 328 | 40 | 24 | * | 6 | * | 62 | 9 | 256 | 59 | 461 | 328 | 40 | 24 | 6 | 62 | 9 | 256 | 59 | 461 | ||||||||||||||||||||||||||||||||||
3302718 | 3302718 | MO | school | 2907460 | 49142 | CARTHAGE R-IX | 290746000210 | 5020 | PLEASANT VALLEY ELEM. | Regular School | No | 1 | KG | 04 | 2015 | k_12_total | 145 | * | 19 | * | * | * | 5 | 9 | 83 | 20 | 169 | 145 | 19 | 5 | 9 | 83 | 20 | 169 | ||||||||||||||||||||||||||||||||||||
3302742 | 3302742 | MO | school | 2931500 | 49144 | WEBB CITY R-VII | 293150000559 | 3000 | WEBB CITY MIDDLE | Regular School | No | 2 | 05 | 06 | 2015 | k_12_total | 580 | 17 | 36 | 8 | 5 | * | 10 | 9 | 338 | 95 | 658 | 580 | 17 | 36 | 8 | 5 | 10 | 9 | 338 | 95 | 658 | |||||||||||||||||||||||||||||||||
3302754 | 3302754 | MO | school | 2931500 | 49144 | WEBB CITY R-VII | 293150002185 | 4040 | MADGE T. JAMES KIND. CTR. | Regular School | No | 1 | PK | KG | 2015 | k_12_total | 161 | 11 | 12 | * | * | * | * | 9 | 105 | 18 | 189 | 161 | 11 | 12 | 9 | 105 | 18 | 189 | ||||||||||||||||||||||||||||||||||||
3302898 | 3302898 | MO | school | 2922890 | 50001 | NORTHWEST R-I | 292289003191 | 3080 | WOOD RIDGE MIDDLE SCHOOL | Regular School | No | 2 | 06 | 08 | 2015 | k_12_total | 553 | 11 | 19 | * | 7 | * | 6 | 9 | 274 | 65 | 596 | 553 | 11 | 19 | 7 | 6 | 9 | 274 | 65 | 596 | ||||||||||||||||||||||||||||||||||
3303171 | 3303171 | MO | school | 2912300 | 50012 | FOX C-6 | 291230000501 | 4060 | MERAMEC HEIGHTS ELEM. | Regular School | No | 1 | KG | 06 | 2015 | k_12_total | 592 | 9 | 22 | * | 9 | * | 10 | 9 | 301 | 111 | 643 | 592 | 9 | 22 | 9 | 10 | 9 | 301 | 111 | 643 | ||||||||||||||||||||||||||||||||||
3303723 | 3303723 | MO | school | 2930450 | 57003 | TROY R-III | 293045002090 | 1050 | TROY BUCHANAN HIGH | Regular School | No | 3 | 09 | 12 | 2015 | k_12_total | 1762 | 60 | 60 | * | 15 | * | 57 | 9 | 640 | 181 | 1958 | 1762 | 60 | 60 | 15 | 57 | 9 | 640 | 181 | 1958 | ||||||||||||||||||||||||||||||||||
3305064 | 3305064 | MO | school | 2924530 | 79077 | PERRY CO. 32 | 292453002387 | 1050 | PERRYVILLE SR. HIGH | Regular School | No | 3 | 09 | 12 | 2015 | k_12_total | 720 | * | 23 | * | * | * | 7 | 9 | 267.3 | 119 | 758 | 720 | 23 | 7 | 9 | 119 | 758 | |||||||||||||||||||||||||||||||||||||
3305094 | 3305094 | MO | school | 2915270 | 80116 | PETTIS CO. R-V | 291527000695 | 1050 | NORTHWEST HIGH | Regular School | No | 3 | 07 | 12 | 2015 | k_12_total | 153 | * | * | * | * | * | * | 9 | 71 | 17 | 153 | 153 | 9 | 71 | 17 | 153 | ||||||||||||||||||||||||||||||||||||||
3305118 | 3305118 | MO | school | 2928380 | 80119 | SMITHTON R-VI | 292838001752 | 1050 | SMITHTON HIGH | Regular School | No | 3 | 07 | 12 | 2015 | k_12_total | 249 | * | 9 | * | * | * | 10 | 9 | 114 | 38 | 269 | 249 | 9 | 10 | 9 | 114 | 38 | 269 | ||||||||||||||||||||||||||||||||||||
3305525 | 3305525 | MO | school | 2905370 | 84001 | BOLIVAR R-I | 290537001535 | 4040 | BOLIVAR INTERMEDIATE SCH. | Regular School | No | 1 | 03 | 05 | 2015 | k_12_total | 548 | * | 14 | 9 | * | * | 19 | 9 | 373 | 67 | 595 | 548 | 14 | 9 | 19 | 9 | 373 | 67 | 595 | |||||||||||||||||||||||||||||||||||
3305608 | 3305608 | MO | school | 2925350 | 84006 | PLEASANT HOPE R-VI | 292535001462 | 4020 | PLEASANT HOPE ELEM. | Regular School | No | 1 | PK | 04 | 2015 | k_12_total | 275 | * | * | * | * | * | * | 9 | 178 | 38 | 280 | 275 | 9 | 178 | 38 | 280 | ||||||||||||||||||||||||||||||||||||||
3307110 | 3307110 | MO | school | 2926850 | 96091 | ROCKWOOD R-VI | 292685000671 | 3040 | LASALLE SPRINGS MIDDLE | Regular School | No | 2 | 06 | 08 | 2015 | k_12_total | 754 | 92 | 19 | * | 21 | * | 13 | 9 | 143 | 169 | 907 | 754 | 92 | 19 | 21 | 13 | 9 | 143 | 169 | 907 | ||||||||||||||||||||||||||||||||||
3307128 | 3307128 | MO | school | 2926850 | 96091 | ROCKWOOD R-VI | 292685000712 | 3080 | SELVIDGE MIDDLE | Regular School | No | 2 | 06 | 08 | 2015 | k_12_total | 537 | 66 | 17 | * | 68 | * | 13 | 9 | 123 | 100 | 701 | 537 | 66 | 17 | 68 | 13 | 9 | 123 | 100 | 701 | ||||||||||||||||||||||||||||||||||
3307140 | 3307140 | MO | school | 2926850 | 96091 | ROCKWOOD R-VI | 292685001615 | 4040 | BOWLES ELEM. | Regular School | No | 1 | KG | 05 | 2015 | k_12_total | 250 | 37 | 5 | * | * | * | 11 | 9 | 86 | 45 | 307 | 250 | 37 | 5 | 11 | 9 | 86 | 45 | 307 | |||||||||||||||||||||||||||||||||||
3307194 | 3307194 | MO | school | 2926850 | 96091 | ROCKWOOD R-VI | 292685001627 | 4135 | STANTON ELEM. | Regular School | No | 1 | KG | 05 | 2015 | k_12_total | 459 | 45 | 11 | * | 19 | * | 17 | 9 | 60 | 91 | 552 | 459 | 45 | 11 | 19 | 17 | 9 | 60 | 91 | 552 | ||||||||||||||||||||||||||||||||||
3307272 | 3307272 | MO | school | 2916770 | 96092 | KIRKWOOD R-VII | 291677000927 | 5000 | W. W. KEYSOR ELEM. | Regular School | No | 1 | KG | 05 | 2015 | k_12_total | 443 | 43 | 20 | * | * | * | 32 | 9 | 87 | 62 | 543 | 443 | 43 | 20 | 32 | 9 | 87 | 62 | 543 | |||||||||||||||||||||||||||||||||||
3307296 | 3307296 | MO | school | 2916770 | 96092 | KIRKWOOD R-VII | 291677000928 | 6020 | WESTCHESTER ELEM. | Regular School | No | 1 | KG | 05 | 2015 | k_12_total | 372 | 39 | 19 | * | 9 | * | 24 | 9 | 51 | 66 | 464 | 372 | 39 | 19 | 9 | 24 | 9 | 51 | 66 | 464 | ||||||||||||||||||||||||||||||||||
3307522 | 3307522 | MO | school | 2923580 | 96095 | PARKWAY C-2 | 292358001375 | 4020 | BARRETTS ELEM. | Regular School | No | 1 | KG | 05 | 2015 | k_12_total | 283 | 40 | 13 | * | 28 | * | 15 | 9 | 51 | 80 | 380 | 283 | 40 | 13 | 28 | 15 | 9 | 51 | 80 | 380 | ||||||||||||||||||||||||||||||||||
3307612 | 3307612 | MO | school | 2923580 | 96095 | PARKWAY C-2 | 292358001400 | 4235 | SORRENTO SPRINGS ELEM. | Regular School | No | 1 | KG | 05 | 2015 | k_12_total | 243 | 45 | 13 | * | 14 | * | 29 | 9 | 105 | 68 | 345 | 243 | 45 | 13 | 14 | 29 | 9 | 105 | 68 | 345 | ||||||||||||||||||||||||||||||||||
3307624 | 3307624 | MO | school | 2923580 | 96095 | PARKWAY C-2 | 292358001405 | 4260 | WREN HOLLOW ELEM. | Regular School | No | 1 | KG | 05 | 2015 | k_12_total | 316 | 37 | 18 | * | 31 | * | 17 | 9 | 71 | 76 | 421 | 316 | 37 | 18 | 31 | 17 | 9 | 71 | 76 | 421 | ||||||||||||||||||||||||||||||||||
3307692 | 3307692 | MO | school | 2905880 | 96101 | BRENTWOOD | 290588000133 | 4060 | MCGRATH ELEM. | Regular School | No | 1 | KG | 05 | 2015 | k_12_total | 101 | 44 | 11 | * | 10 | * | 19 | 9 | 55 | 29 | 186 | 101 | 44 | 11 | 10 | 19 | 9 | 55 | 29 | 186 | ||||||||||||||||||||||||||||||||||
3308074 | 3308074 | MO | school | 2930660 | 96112 | UNIVERSITY CITY | 293066002109 | 4140 | JACKSON PARK ELEM. | Regular School | No | 1 | KG | 05 | 2015 | k_12_total | 48 | 306 | 9 | * | * | * | 7 | 9 | 240 | 32 | 373 | 48 | 306 | 9 | 7 | 9 | 240 | 32 | 373 | |||||||||||||||||||||||||||||||||||
3308881 | 3308881 | MO | school | 2914550 | 106005 | HOLLISTER R-V | 291455000683 | 4020 | HOLLISTER ELEM. | Regular School | No | 1 | 02 | 05 | 2015 | k_12_total | 318 | 5 | 29 | 5 | * | * | * | 9 | 293 | 49 | 362 | 318 | 5 | 29 | 5 | 9 | 293 | 49 | 362 | |||||||||||||||||||||||||||||||||||
3309487 | 3309487 | MO | school | 2929280 | 115115 | ST. LOUIS CITY | 292928002011 | 1830 | VASHON HIGH | Regular School | No | 3 | 09 | 12 | 2015 | k_12_total | * | 642 | * | * | * | * | * | 9 | * | 126 | 645 | 642 | 9 | 126 | 645 | |||||||||||||||||||||||||||||||||||||||
3296698 | 3296698 | MO | school | 2916740 | 1091 | KIRKSVILLE R-III | 291674002611 | 3000 | WILLIAM MATTHEW MIDDLE SCHOOL | Regular School | No | 2 | 06 | 08 | 2016 | k_12_total | 478 | 20 | 8 | * | 10 | * | 8 | 9 | 279 | 73 | 525 | 478 | 20 | 8 | 10 | 8 | 9 | 279 | 73 | 525 | ||||||||||||||||||||||||||||||||||
3297661 | 3297661 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001650 | 4060 | ELLISON ELEM. | Regular School | No | 1 | KG | 06 | 2016 | k_12_total | 292 | 17 | 15 | * | 6 | * | 23 | 9 | 145 | 36 | 359 | 292 | 17 | 15 | 6 | 23 | 9 | 145 | 36 | 359 | ||||||||||||||||||||||||||||||||||
3298079 | 3298079 | MO | school | 2906990 | 15002 | CAMDENTON R-III | 290699002983 | 4050 | HAWTHORN ELEM. | Regular School | No | 1 | 03 | 04 | 2016 | k_12_total | 448 | 14 | 24 | 12 | * | * | * | 9 | 321.2 | 80 | 503 | 448 | 14 | 24 | 12 | 9 | 80 | 503 | ||||||||||||||||||||||||||||||||||||
3298234 | 3298234 | MO | school | 2907120 | 16096 | CAPE GIRARDEAU 63 | 290712000189 | 4080 | JEFFERSON ELEM. | Regular School | No | 1 | PK | 04 | 2016 | k_12_total | 92 | 147 | 20 | * | * | * | 50 | 9 | 288 | 55 | 309 | 92 | 147 | 20 | 50 | 9 | 288 | 55 | 309 | |||||||||||||||||||||||||||||||||||
3298500 | 3298500 | MO | school | 2913760 | 19149 | HARRISONVILLE R-IX | 291376002659 | 3000 | HARRISONVILLE MIDDLE | Regular School | No | 2 | 06 | 08 | 2016 | k_12_total | 494 | 10 | 18 | 8 | * | * | 5 | 9 | 227 | 46 | 540 | 494 | 10 | 18 | 8 | 5 | 9 | 227 | 46 | 540 |
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]);