enrollments
Data source: Big Local News · About: Big Local
37,152 rows where state = "MO" and year = 2019 sorted by ell descending
This data as json, CSV (advanced)
grade ✖
- grade_1 2,322
- grade_10 2,322
- grade_11 2,322
- grade_12 2,322
- grade_2 2,322
- grade_3 2,322
- grade_4 2,322
- grade_5 2,322
- grade_6 2,322
- grade_7 2,322
- grade_8 2,322
- grade_9 2,322
- k_12_total 2,322
- kindergarten 2,322
- pk_12_total 2,322
- pre_kindergarten 2,322
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
3297303 | 3297303 | MO | school | 2913560 | 10089 | HALLSVILLE R-IV | 291356000577 | 4020 | HALLSVILLE INTERMEDIATE | Regular School | No | Elementary | 02 | 05 | 2019 | k_12_total | 384 | 10 | 10 | * | 12 | * | 31 | 9 | 158 | 47 | 449 | 384 | 10 | 10 | 12 | 31 | 9 | 158 | 47 | 449 | ||||||||||||||||||||||||||||||||||
3298052 | 3298052 | MO | school | 2906990 | 15002 | CAMDENTON R-III | 290699000175 | 1050 | CAMDENTON HIGH | Regular School | No | High | 09 | 12 | 2019 | k_12_total | 1165 | 24 | 75 | 7 | 15 | * | 32 | 9 | 582.1 | 171 | 1320 | 1165 | 24 | 75 | 7 | 15 | 32 | 9 | 171 | 1320 | ||||||||||||||||||||||||||||||||||
3298082 | 3298082 | MO | school | 2906990 | 15002 | CAMDENTON R-III | 290699002983 | 4050 | HAWTHORN ELEM. | Regular School | No | Elementary | 03 | 04 | 2019 | k_12_total | 397 | 5 | 31 | * | * | * | 6 | 9 | 243.1 | 60 | 443 | 397 | 5 | 31 | 6 | 9 | 60 | 443 | ||||||||||||||||||||||||||||||||||||
3298575 | 3298575 | MO | school | 2904620 | 19152 | BELTON 124 | 290462000054 | 4050 | SCOTT ELEM. | Regular School | No | Elementary | KG | 04 | 2019 | k_12_total | 149 | 34 | 23 | * | * | * | 25 | 9 | 149 | 37 | 238 | 149 | 34 | 23 | 25 | 9 | 149 | 37 | 238 | |||||||||||||||||||||||||||||||||||
3299508 | 3299508 | MO | school | 2916190 | 26006 | JEFFERSON CITY | 291619000758 | 5040 | WEST ELEM. | Regular School | No | Elementary | KG | 05 | 2019 | k_12_total | 211 | 64 | 14 | * | * | * | 30 | 9 | 209.2 | 29 | 324 | 211 | 64 | 14 | 30 | 9 | 29 | 324 | ||||||||||||||||||||||||||||||||||||
3300735 | 3300735 | MO | school | 2928860 | 39141 | SPRINGFIELD R-XII | 292886001814 | 4500 | PITTMAN ELEM. | Regular School | No | Elementary | KG | 05 | 2019 | k_12_total | 210 | 21 | 22 | * | * | * | 27 | 9 | 190 | 48 | 287 | 210 | 21 | 22 | 27 | 9 | 190 | 48 | 287 | |||||||||||||||||||||||||||||||||||
3300747 | 3300747 | MO | school | 2928860 | 39141 | SPRINGFIELD R-XII | 292886001817 | 4520 | PORTLAND ELEM. | Regular School | No | Elementary | KG | 05 | 2019 | k_12_total | 167 | 24 | 23 | 5 | * | * | 33 | 9 | 185.1 | 30 | 254 | 167 | 24 | 23 | 5 | 33 | 9 | 30 | 254 | |||||||||||||||||||||||||||||||||||
3300985 | 3300985 | MO | school | 2932110 | 42111 | HENRY CO. R-I | 293211002254 | 4020 | WINDSOR ELEM. | Regular School | No | Elementary | PK | 06 | 2019 | k_12_total | 355 | * | 12 | * | 5 | * | * | 9 | 233.3 | 72 | 380 | 355 | 12 | 5 | 9 | 72 | 380 | |||||||||||||||||||||||||||||||||||||
3301359 | 3301359 | MO | school | 2912290 | 48066 | FORT OSAGE R-I | 291229000494 | 3000 | OSAGE TRAIL MIDDLE | Regular School | No | Middle | 07 | 08 | 2019 | k_12_total | 598 | 80 | 85 | 7 | 7 | 15 | 17 | 9 | 427 | 109 | 809 | 598 | 80 | 85 | 7 | 7 | 15 | 17 | 9 | 427 | 109 | 809 | ||||||||||||||||||||||||||||||||
3301450 | 3301450 | MO | school | 2905310 | 48068 | BLUE SPRINGS R-IV | 290531000080 | 4040 | FRANKLIN SMITH ELEM. | Regular School | No | Elementary | PK | 05 | 2019 | k_12_total | 317 | 44 | 50 | * | 8 | * | 55 | 9 | 231 | 62 | 478 | 317 | 44 | 50 | 8 | 55 | 9 | 231 | 62 | 478 | ||||||||||||||||||||||||||||||||||
3301618 | 3301618 | MO | school | 2918300 | 48071 | LEE'S SUMMIT R-VII | 291830000222 | 3000 | BERNARD C. CAMPBELL MIDDLE | Regular School | No | Middle | 05 | 08 | 2019 | k_12_total | 653 | 148 | 54 | * | 15 | * | 66 | 9 | 238 | 91 | 942 | 653 | 148 | 54 | 15 | 66 | 9 | 238 | 91 | 942 | ||||||||||||||||||||||||||||||||||
3302130 | 3302130 | MO | school | 2915480 | 48077 | INDEPENDENCE 30 | 291548003213 | 6120 | LITTLE BLUE ELEMENTARY | Regular School | No | Elementary | PK | 05 | 2019 | k_12_total | 195 | 31 | 27 | * | * | * | 38 | 9 | 152 | 43 | 296 | 195 | 31 | 27 | 38 | 9 | 152 | 43 | 296 | |||||||||||||||||||||||||||||||||||
3302513 | 3302513 | MO | school | 2900024 | 48916 | BROOKSIDE CHARTER SCH. | 290002403184 | 3950 | BROOKSIDE CHARTER MIDDLE SCHL | Regular School | Yes | Middle | 06 | 08 | 2019 | k_12_total | * | 181 | 9 | * | * | * | 5 | 9 | * | 24 | 200 | 181 | 9 | 5 | 9 | 24 | 200 | |||||||||||||||||||||||||||||||||||||
3302740 | 3302740 | MO | school | 2931500 | 49144 | WEBB CITY R-VII | 293150002756 | 2050 | WEBB CITY JR. HIGH | Regular School | No | Middle | 07 | 08 | 2019 | k_12_total | 558 | 9 | 49 | 10 | 9 | * | 36 | 9 | 287 | 88 | 674 | 558 | 9 | 49 | 10 | 9 | 36 | 9 | 287 | 88 | 674 | |||||||||||||||||||||||||||||||||
3302758 | 3302758 | MO | school | 2931500 | 49144 | WEBB CITY R-VII | 293150002185 | 4040 | MADGE T. JAMES KIND. CTR. | Regular School | No | Elementary | KG | KG | 2019 | k_12_total | 145 | 9 | 15 | * | * | * | 20 | 9 | 109 | 19 | 195 | 145 | 9 | 15 | 20 | 9 | 109 | 19 | 195 | |||||||||||||||||||||||||||||||||||
3302890 | 3302890 | MO | school | 2922890 | 50001 | NORTHWEST R-I | 292289001309 | 1050 | NORTHWEST HIGH | Regular School | No | High | 09 | 12 | 2019 | k_12_total | 1690 | 18 | 51 | * | 14 | * | 38 | 9 | 627 | 239 | 1815 | 1690 | 18 | 51 | 14 | 38 | 9 | 627 | 239 | 1815 | ||||||||||||||||||||||||||||||||||
3303109 | 3303109 | MO | school | 2912300 | 50012 | FOX C-6 | 291230000506 | 1050 | FOX SR. HIGH | Regular School | No | High | 09 | 12 | 2019 | k_12_total | 1550 | 30 | 57 | 6 | 33 | * | 41 | 9 | 487 | 306 | 1717 | 1550 | 30 | 57 | 6 | 33 | 41 | 9 | 487 | 306 | 1717 | |||||||||||||||||||||||||||||||||
3303199 | 3303199 | MO | school | 2912300 | 50012 | FOX C-6 | 291230000507 | 5000 | SHERWOOD ELEM. | Regular School | No | Elementary | KG | 05 | 2019 | k_12_total | 359 | 11 | 19 | * | 5 | * | 19 | 9 | 171 | 84 | 413 | 359 | 11 | 19 | 5 | 19 | 9 | 171 | 84 | 413 | ||||||||||||||||||||||||||||||||||
3303330 | 3303330 | MO | school | 2916830 | 51155 | KNOB NOSTER R-VIII | 291683000933 | 4040 | WHITEMAN A.F.B. ELEM. | Regular School | No | Elementary | PK | 04 | 2019 | k_12_total | 262 | 23 | 51 | * | 6 | * | 23 | 9 | 149 | 55 | 367 | 262 | 23 | 51 | 6 | 23 | 9 | 149 | 55 | 367 | ||||||||||||||||||||||||||||||||||
3303427 | 3303427 | MO | school | 2918270 | 53113 | LEBANON R-III | 291827000971 | 2050 | LEBANON MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2019 | k_12_total | 943 | 16 | 47 | * | 9 | * | 42 | 9 | 582 | 166 | 1058 | 943 | 16 | 47 | 9 | 42 | 9 | 582 | 166 | 1058 | ||||||||||||||||||||||||||||||||||
3303633 | 3303633 | MO | school | 2904020 | 55110 | AURORA R-VIII | 290402001517 | 2050 | AURORA JR. HIGH | Regular School | No | Middle | 07 | 08 | 2019 | k_12_total | 217 | * | 43 | 7 | * | * | 6 | 9 | 165 | 41 | 279 | 217 | 43 | 7 | 6 | 9 | 165 | 41 | 279 | |||||||||||||||||||||||||||||||||||
3303923 | 3303923 | MO | school | 2908760 | 59117 | CHILLICOTHE R-II | 290876000261 | 4040 | CHILLICOTHE ELEM | Regular School | No | Elementary | PK | 01 | 2019 | k_12_total | 213 | 6 | 11 | * | 6 | * | 20 | 9 | 138 | 36 | 256 | 213 | 6 | 11 | 6 | 20 | 9 | 138 | 36 | 256 | ||||||||||||||||||||||||||||||||||
3305068 | 3305068 | MO | school | 2924530 | 79077 | PERRY CO. 32 | 292453002387 | 1050 | PERRYVILLE SR. HIGH | Regular School | No | High | 09 | 12 | 2019 | k_12_total | 713 | * | 21 | * | 6 | * | 9 | 9 | 254 | 119 | 755 | 713 | 21 | 6 | 9 | 9 | 254 | 119 | 755 | |||||||||||||||||||||||||||||||||||
3306146 | 3306146 | MO | school | 2908370 | 92087 | FT. ZUMWALT R-II | 290837002843 | 4170 | OSTMANN ELEM. | Regular School | No | Elementary | KG | 05 | 2019 | k_12_total | 305 | 11 | 14 | * | 18 | * | 16 | 9 | 25 | 151 | 365 | 305 | 11 | 14 | 18 | 16 | 9 | 25 | 151 | 365 | ||||||||||||||||||||||||||||||||||
3306839 | 3306839 | MO | school | 2913830 | 96088 | HAZELWOOD | 291383000627 | 4300 | JANA ELEM. | Regular School | No | Elementary | KG | 05 | 2019 | k_12_total | 46 | 270 | 5 | * | * | * | * | 9 | 166 | 56 | 329 | 46 | 270 | 5 | 9 | 166 | 56 | 329 | ||||||||||||||||||||||||||||||||||||
3307258 | 3307258 | MO | school | 2916770 | 96092 | KIRKWOOD R-VII | 291677000926 | 1050 | KIRKWOOD SR. HIGH | Regular School | No | High | 09 | 12 | 2019 | k_12_total | 1339 | 225 | 71 | * | 41 | * | 68 | 9 | 207.3 | 242 | 1747 | 1339 | 225 | 71 | 41 | 68 | 9 | 242 | 1747 | |||||||||||||||||||||||||||||||||||
3307483 | 3307483 | MO | school | 2923580 | 96095 | PARKWAY C-2 | 292358001404 | 1080 | WEST HIGH | Regular School | No | High | 09 | 12 | 2019 | k_12_total | 988 | 146 | 53 | * | 173 | * | 46 | 9 | 168.1 | 229 | 1407 | 988 | 146 | 53 | 173 | 46 | 9 | 229 | 1407 | |||||||||||||||||||||||||||||||||||
3307592 | 3307592 | MO | school | 2923580 | 96095 | PARKWAY C-2 | 292358002626 | 4190 | OAK BROOK ELEM. | Regular School | No | Elementary | PK | 05 | 2019 | k_12_total | 350 | 23 | 13 | * | 64 | * | 39 | 9 | 59 | 64 | 492 | 350 | 23 | 13 | 64 | 39 | 9 | 59 | 64 | 492 | ||||||||||||||||||||||||||||||||||
3307705 | 3307705 | MO | school | 2909720 | 96102 | CLAYTON | 290972000275 | 1050 | CLAYTON HIGH | Regular School | No | High | 09 | 12 | 2019 | k_12_total | 552 | 162 | 39 | * | 109 | * | 38 | 9 | 80 | 93 | 900 | 552 | 162 | 39 | 109 | 38 | 9 | 80 | 93 | 900 | ||||||||||||||||||||||||||||||||||
3309820 | 3309820 | MO | school | 2929280 | 115115 | ST. LOUIS CITY | 292928002646 | 6030 | WILKINSON EARLY CHILDHOOD CTR. | Regular School | No | Elementary | PK | 02 | 2019 | k_12_total | 47 | 107 | 8 | * | * | * | * | 9 | * | 28 | 165 | 47 | 107 | 8 | 9 | 28 | 165 | |||||||||||||||||||||||||||||||||||||
3309925 | 3309925 | MO | school | 2900591 | 115914 | KIPP ST LOUIS PUBLIC SCHOOLS | 290059103314 | 1905 | KIPP ST. LOUIS HIGH | Regular School | Yes | Secondary | 09 | 10 | 2019 | k_12_total | * | 202 | 9 | * | * | * | * | 9 | * | 33 | 214 | 202 | 9 | 9 | 33 | 214 | ||||||||||||||||||||||||||||||||||||||
3309724 | 3309724 | MO | school | 2929280 | 115115 | ST. LOUIS CITY | 292928001968 | 5260 | MANN ELEM. | Regular School | No | Elementary | PK | 06 | 2019 | k_12_total | 47 | 144 | 36 | * | 26 | * | * | 89 | * | 43 | 253 | 47 | 144 | 36 | 26 | 89 | 43 | 253 | ||||||||||||||||||||||||||||||||||||
3307562 | 3307562 | MO | school | 2923580 | 96095 | PARKWAY C-2 | 292358001386 | 4110 | HANNA WOODS ELEM. | Regular School | No | Elementary | PK | 05 | 2019 | k_12_total | 274 | 50 | 25 | * | 75 | * | 33 | 88 | 121 | 79 | 458 | 274 | 50 | 25 | 75 | 33 | 88 | 121 | 79 | 458 | ||||||||||||||||||||||||||||||||||
3307924 | 3307924 | MO | school | 2926640 | 96110 | RITENOUR | 292664001567 | 3000 | HOECH MIDDLE | Regular School | No | Middle | 06 | 08 | 2019 | k_12_total | 205 | 322 | 166 | * | 15 | * | 65 | 88 | * | 143 | 774 | 205 | 322 | 166 | 15 | 65 | 88 | 143 | 774 | |||||||||||||||||||||||||||||||||||
3309473 | 3309473 | MO | school | 2929280 | 115115 | ST. LOUIS CITY | 292928001994 | 1680 | ROOSEVELT HIGH | Regular School | No | High | 09 | 12 | 2019 | k_12_total | 54 | 343 | 38 | * | 9 | * | * | 88 | * | 92 | 444 | 54 | 343 | 38 | 9 | 88 | 92 | 444 | ||||||||||||||||||||||||||||||||||||
3309430 | 3309430 | MO | school | 2929280 | 115115 | ST. LOUIS CITY | 292928001882 | 1250 | BEAUMONT CTE HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2019 | k_12_total | 37 | 323 | 37 | * | 15 | * | * | 86 | * | 32 | 412 | 37 | 323 | 37 | 15 | 86 | 32 | 412 | ||||||||||||||||||||||||||||||||||||
3296982 | 3296982 | MO | school | 2921120 | 5128 | MONETT R-I | 292112000183 | 3000 | MONETT MIDDLE | Regular School | No | Middle | 07 | 08 | 2019 | k_12_total | 211 | * | 159 | * | 14 | * | 7 | 85 | 270 | 83 | 400 | 211 | 159 | 14 | 7 | 85 | 270 | 83 | 400 | |||||||||||||||||||||||||||||||||||
3297622 | 3297622 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001648 | 1075 | CENTRAL HIGH | Regular School | No | High | 09 | 12 | 2019 | k_12_total | 1245 | 118 | 160 | * | 55 | 15 | 84 | 84 | 634.3 | 232 | 1681 | 1245 | 118 | 160 | 55 | 15 | 84 | 84 | 232 | 1681 | ||||||||||||||||||||||||||||||||||
3302716 | 3302716 | MO | school | 2907460 | 49142 | CARTHAGE R-IX | 290746000209 | 5000 | MARK TWAIN ELEM. | Regular School | No | Elementary | KG | 04 | 2019 | k_12_total | 192 | 5 | 90 | * | * | * | 8 | 84 | 189 | 30 | 303 | 192 | 5 | 90 | 8 | 84 | 189 | 30 | 303 | |||||||||||||||||||||||||||||||||||
3296976 | 3296976 | MO | school | 2921120 | 5128 | MONETT R-I | 292112001162 | 1050 | MONETT HIGH | Regular School | No | High | 09 | 12 | 2019 | k_12_total | 419 | 9 | 276 | * | 24 | * | 15 | 83 | 377 | 90 | 745 | 419 | 9 | 276 | 24 | 15 | 83 | 377 | 90 | 745 | ||||||||||||||||||||||||||||||||||
3301997 | 3301997 | MO | school | 2915480 | 48077 | INDEPENDENCE 30 | 291548003096 | 1090 | VAN HORN HIGH | Regular School | No | High | 09 | 12 | 2019 | k_12_total | 491 | 135 | 319 | 5 | 7 | 6 | 73 | 83 | 751 | 103 | 1036 | 491 | 135 | 319 | 5 | 7 | 6 | 73 | 83 | 751 | 103 | 1036 | ||||||||||||||||||||||||||||||||
3307048 | 3307048 | MO | school | 2923700 | 96090 | PATTONVILLE R-III | 292370002848 | 5060 | ROBERT DRUMMOND ELEM. | Regular School | No | Elementary | PK | 05 | 2019 | k_12_total | 225 | 343 | 93 | * | 13 | * | 68 | 83 | 494 | 109 | 746 | 225 | 343 | 93 | 13 | 68 | 83 | 494 | 109 | 746 | ||||||||||||||||||||||||||||||||||
3309754 | 3309754 | MO | school | 2929280 | 115115 | ST. LOUIS CITY | 292928000798 | 5590 | MULLANPHY BOTANICAL GARDENS | Regular School | No | Elementary | PK | 05 | 2019 | k_12_total | 33 | 294 | 40 | * | 14 | * | * | 83 | * | 69 | 381 | 33 | 294 | 40 | 14 | 83 | 69 | 381 | ||||||||||||||||||||||||||||||||||||
3309978 | 3309978 | MO | school | 2900592 | 115916 | GATEWAY SCIENCE ACAD/ST LOUIS | 290059203241 | 6997 | GATEWAY SCIENCE ACAD-SOUTH ELE | Regular School | Yes | Elementary | KG | 05 | 2019 | k_12_total | 256 | 115 | 30 | * | 17 | * | 42 | 83 | 285 | 60 | 460 | 256 | 115 | 30 | 17 | 42 | 83 | 285 | 60 | 460 | ||||||||||||||||||||||||||||||||||
3304688 | 3304688 | MO | school | 2921810 | 73108 | NEOSHO SCHOOL DISTRICT | 292181001209 | 1050 | NEOSHO HIGH | Regular School | No | High | 09 | 12 | 2019 | k_12_total | 902 | 15 | 180 | 42 | 17 | 68 | 52 | 82 | 557.1 | 113 | 1276 | 902 | 15 | 180 | 42 | 17 | 68 | 52 | 82 | 113 | 1276 | |||||||||||||||||||||||||||||||||
3299182 | 3299182 | MO | school | 2922800 | 24093 | NORTH KANSAS CITY 74 | 292280002730 | 3200 | NORTHGATE MIDDLE | Regular School | No | Middle | 07 | 08 | 2019 | k_12_total | 233 | 103 | 131 | * | 47 | 24 | 73 | 81 | 423.4 | 67 | 613 | 233 | 103 | 131 | 47 | 24 | 73 | 81 | 67 | 613 | ||||||||||||||||||||||||||||||||||
3304712 | 3304712 | MO | school | 2921810 | 73108 | NEOSHO SCHOOL DISTRICT | 292181001204 | 4040 | CENTRAL ELEM. | Regular School | No | Elementary | KG | 04 | 2019 | k_12_total | 92 | * | 68 | * | * | 40 | 21 | 81 | 185 | 43 | 222 | 92 | 68 | 40 | 21 | 81 | 185 | 43 | 222 | |||||||||||||||||||||||||||||||||||
3299190 | 3299190 | MO | school | 2922800 | 24093 | NORTH KANSAS CITY 74 | 292280003115 | 4040 | BELL PRAIRIE ELEMENTARY | Regular School | No | Elementary | PK | 05 | 2019 | k_12_total | 426 | 66 | 75 | * | 29 | 10 | 49 | 80 | 144 | 43 | 658 | 426 | 66 | 75 | 29 | 10 | 49 | 80 | 144 | 43 | 658 | |||||||||||||||||||||||||||||||||
3302124 | 3302124 | MO | school | 2915480 | 48077 | INDEPENDENCE 30 | 291548003091 | 6100 | THREE TRAILS ELEM. | Regular School | No | Elementary | PK | 05 | 2019 | k_12_total | 189 | 65 | 138 | * | * | * | 27 | 80 | 342 | 34 | 424 | 189 | 65 | 138 | 27 | 80 | 342 | 34 | 424 | |||||||||||||||||||||||||||||||||||
3297054 | 3297054 | MO | school | 2917850 | 6104 | LAMAR R-I | 291785000953 | 4020 | LAMAR ELEM. | Regular School | No | Elementary | 03 | 05 | 2019 | k_12_total | 216 | * | 14 | 5 | * | * | 16 | 8 | 156 | 50 | 254 | 216 | 14 | 5 | 16 | 8 | 156 | 50 | 254 | |||||||||||||||||||||||||||||||||||
3297200 | 3297200 | MO | school | 2909900 | 8111 | COLE CAMP R-I | 290990000292 | 4020 | COLE CAMP ELEM. | Regular School | No | Elementary | KG | 04 | 2019 | k_12_total | 245 | * | 10 | * | * | * | 8 | 8 | 158 | 49 | 263 | 245 | 10 | 8 | 8 | 158 | 49 | 263 | ||||||||||||||||||||||||||||||||||||
3297435 | 3297435 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100001946 | 3060 | JOHN B. LANGE MIDDLE | Regular School | No | Middle | 06 | 08 | 2019 | k_12_total | 285 | 222 | 45 | * | 17 | * | 65 | 8 | 398 | 66 | 640 | 285 | 222 | 45 | 17 | 65 | 8 | 398 | 66 | 640 | ||||||||||||||||||||||||||||||||||
3297664 | 3297664 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001650 | 4060 | ELLISON ELEM. | Regular School | No | Elementary | KG | 06 | 2019 | k_12_total | 271 | 21 | 11 | * | 7 | * | 24 | 8 | 146 | 30 | 335 | 271 | 21 | 11 | 7 | 24 | 8 | 146 | 30 | 335 | ||||||||||||||||||||||||||||||||||
3298811 | 3298811 | MO | school | 2909780 | 22092 | CLEVER R-V | 290978000281 | 4020 | CLEVER ELEM. | Regular School | No | Elementary | PK | 08 | 2019 | k_12_total | 762 | 11 | 21 | * | * | * | 16 | 8 | 372 | 84 | 815 | 762 | 11 | 21 | 16 | 8 | 372 | 84 | 815 | |||||||||||||||||||||||||||||||||||
3299090 | 3299090 | MO | school | 2918540 | 24090 | LIBERTY 53 | 291854002804 | 4140 | SHOAL CREEK ELEM. | Regular School | No | Elementary | KG | 05 | 2019 | k_12_total | 783 | 27 | 32 | * | 27 | * | 44 | 8 | 62 | 53 | 914 | 783 | 27 | 32 | 27 | 44 | 8 | 62 | 53 | 914 | ||||||||||||||||||||||||||||||||||
3299176 | 3299176 | MO | school | 2922800 | 24093 | NORTH KANSAS CITY 74 | 292280001282 | 3180 | NEW MARK MIDDLE | Regular School | No | Middle | 07 | 08 | 2019 | k_12_total | 576 | 83 | 76 | * | 17 | * | 78 | 8 | 198.1 | 58 | 833 | 576 | 83 | 76 | 17 | 78 | 8 | 58 | 833 | |||||||||||||||||||||||||||||||||||
3299238 | 3299238 | MO | school | 2922800 | 24093 | NORTH KANSAS CITY 74 | 292280002621 | 4200 | FOX HILL ELEM. | Regular School | No | Elementary | KG | 05 | 2019 | k_12_total | 414 | 75 | 67 | * | 6 | * | 87 | 8 | 229 | 64 | 653 | 414 | 75 | 67 | 6 | 87 | 8 | 229 | 64 | 653 | ||||||||||||||||||||||||||||||||||
3299952 | 3299952 | MO | school | 2909120 | 35097 | CLARKTON C-4 | 290912000269 | 1050 | CLARKTON HIGH | Regular School | No | High | 06 | 12 | 2019 | k_12_total | 121 | 15 | 30 | * | * | * | 5 | 8 | * | 24 | 172 | 121 | 15 | 30 | 5 | 8 | 24 | 172 | ||||||||||||||||||||||||||||||||||||
3300384 | 3300384 | MO | school | 2932010 | 39133 | WILLARD R-II | 293201002773 | 4060 | WILLARD EAST ELEM. | Regular School | No | Elementary | PK | 04 | 2019 | k_12_total | 304 | 6 | 7 | * | * | * | 7 | 8 | 124 | 39 | 326 | 304 | 6 | 7 | 7 | 8 | 124 | 39 | 326 | |||||||||||||||||||||||||||||||||||
3300597 | 3300597 | MO | school | 2928860 | 39141 | SPRINGFIELD R-XII | 292886002680 | 3120 | PLEASANT VIEW MIDDLE | Regular School | No | Middle | 06 | 08 | 2019 | k_12_total | 267 | 18 | 20 | * | * | * | 18 | 8 | 179 | 42 | 327 | 267 | 18 | 20 | 18 | 8 | 179 | 42 | 327 | |||||||||||||||||||||||||||||||||||
3300759 | 3300759 | MO | school | 2928860 | 39141 | SPRINGFIELD R-XII | 292886001821 | 4580 | ROUNTREE ELEM. | Regular School | No | Elementary | KG | 05 | 2019 | k_12_total | 205 | 17 | 9 | * | 9 | * | 17 | 8 | 121 | 28 | 257 | 205 | 17 | 9 | 9 | 17 | 8 | 121 | 28 | 257 | ||||||||||||||||||||||||||||||||||
3300831 | 3300831 | MO | school | 2928860 | 39141 | SPRINGFIELD R-XII | 292886001838 | 4840 | YORK ELEM. | Regular School | No | Elementary | PK | 05 | 2019 | k_12_total | 176 | 17 | 11 | * | * | * | 21 | 8 | 187 | 23 | 230 | 176 | 17 | 11 | 21 | 8 | 187 | 23 | 230 | |||||||||||||||||||||||||||||||||||
3301666 | 3301666 | MO | school | 2918300 | 48071 | LEE'S SUMMIT R-VII | 291830000979 | 4080 | MASON ELEM. | Regular School | No | Elementary | KG | 06 | 2019 | k_12_total | 424 | 30 | 10 | * | 8 | * | 18 | 8 | 72 | 52 | 490 | 424 | 30 | 10 | 8 | 18 | 8 | 72 | 52 | 490 | ||||||||||||||||||||||||||||||||||
3301702 | 3301702 | MO | school | 2918300 | 48071 | LEE'S SUMMIT R-VII | 291830000544 | 5035 | TRAILRIDGE ELEM. | Regular School | No | Elementary | KG | 06 | 2019 | k_12_total | 375 | 67 | 9 | * | 13 | * | 19 | 8 | 70 | 45 | 488 | 375 | 67 | 9 | 13 | 19 | 8 | 70 | 45 | 488 | ||||||||||||||||||||||||||||||||||
3302186 | 3302186 | MO | school | 2916400 | 48078 | KANSAS CITY 33 | 291640003322 | 3050 | LINCOLN COLLEGE ACADEMY MIDDLE | Regular School | No | Middle | 06 | 08 | 2019 | k_12_total | 75 | 121 | 122 | * | 30 | 9 | 8 | 8 | * | 5 | 367 | 75 | 121 | 122 | 30 | 9 | 8 | 8 | 5 | 367 | ||||||||||||||||||||||||||||||||||
3302495 | 3302495 | MO | school | 2900017 | 48914 | ACADEMIE LAFAYETTE | 290001702753 | 6940 | ACADEMIE LAFAYETTE-OAK | Regular School | Yes | Elementary | KG | 05 | 2019 | k_12_total | 287 | 109 | 13 | * | * | * | 46 | 8 | 101 | 32 | 461 | 287 | 109 | 13 | 46 | 8 | 101 | 32 | 461 | |||||||||||||||||||||||||||||||||||
3303097 | 3303097 | MO | school | 2932100 | 50010 | WINDSOR C-1 | 293210002868 | 4030 | WINDSOR ELEM. | Regular School | No | Elementary | KG | 02 | 2019 | k_12_total | 376 | 10 | 5 | * | * | * | * | 8 | 140 | 55 | 392 | 376 | 10 | 5 | 8 | 140 | 55 | 392 | ||||||||||||||||||||||||||||||||||||
3303121 | 3303121 | MO | school | 2912300 | 50012 | FOX C-6 | 291230000500 | 2050 | FOX MIDDLE | Regular School | No | Middle | 06 | 08 | 2019 | k_12_total | 638 | 13 | 21 | * | 7 | * | 27 | 8 | 249 | 141 | 706 | 638 | 13 | 21 | 7 | 27 | 8 | 249 | 141 | 706 | ||||||||||||||||||||||||||||||||||
3303324 | 3303324 | MO | school | 2916830 | 51155 | KNOB NOSTER R-VIII | 291683000931 | 4020 | KNOB NOSTER ELEM. | Regular School | No | Elementary | KG | 04 | 2019 | k_12_total | 293 | 20 | 13 | * | * | * | 16 | 8 | 144 | 45 | 352 | 293 | 20 | 13 | 16 | 8 | 144 | 45 | 352 | |||||||||||||||||||||||||||||||||||
3303433 | 3303433 | MO | school | 2918270 | 53113 | LEBANON R-III | 291827000975 | 4020 | JOE D. ESTHER ELEM. | Regular School | No | Elementary | PK | 01 | 2019 | k_12_total | 546 | 8 | 11 | * | * | * | 25 | 8 | 390 | 102 | 594 | 546 | 8 | 11 | 25 | 8 | 390 | 102 | 594 | |||||||||||||||||||||||||||||||||||
3303513 | 3303513 | MO | school | 2903000 | 54042 | SANTA FE R-X | 290300000013 | 1050 | SANTA FE HIGH | Regular School | No | High | 07 | 12 | 2019 | k_12_total | 143 | * | 19 | * | * | * | * | 8 | 58 | 13 | 162 | 143 | 19 | 8 | 58 | 13 | 162 | |||||||||||||||||||||||||||||||||||||
3304301 | 3304301 | MO | school | 2927630 | 66105 | SCHOOL OF THE OSAGE | 292763001696 | 4020 | HERITAGE ELEMENTARY | Regular School | No | Elementary | PK | 02 | 2019 | k_12_total | 379 | 5 | 16 | * | * | * | 23 | 8 | 217 | 82 | 430 | 379 | 5 | 16 | 23 | 8 | 217 | 82 | 430 | |||||||||||||||||||||||||||||||||||
3305407 | 3305407 | MO | school | 2925230 | 83003 | PLATTE CO. R-III | 292523003288 | 4060 | COMPASS ELEMENTARY | Regular School | No | Elementary | PK | 05 | 2019 | k_12_total | 521 | 17 | 46 | * | * | 11 | 35 | 8 | 151 | 67 | 632 | 521 | 17 | 46 | 11 | 35 | 8 | 151 | 67 | 632 | ||||||||||||||||||||||||||||||||||
3305594 | 3305594 | MO | school | 2920160 | 84005 | MARION C. EARLY R-V | 292016001072 | 4020 | MARION C. EARLY ELEM. | Regular School | No | Elementary | PK | 05 | 2019 | k_12_total | 245 | * | * | * | * | * | 6 | 8 | 156 | 30 | 256 | 245 | 6 | 8 | 156 | 30 | 256 | |||||||||||||||||||||||||||||||||||||
3306195 | 3306195 | MO | school | 2928950 | 92088 | FRANCIS HOWELL R-III | 292895001884 | 3300 | SAEGER MIDDLE | Regular School | No | Middle | 06 | 08 | 2019 | k_12_total | 602 | 53 | 28 | * | 12 | * | 24 | 8 | 143 | 95 | 719 | 602 | 53 | 28 | 12 | 24 | 8 | 143 | 95 | 719 | ||||||||||||||||||||||||||||||||||
3306369 | 3306369 | MO | school | 2931650 | 92089 | WENTZVILLE R-IV | 293165002903 | 4100 | PEINE RIDGE ELEM. | Regular School | No | Elementary | KG | 06 | 2019 | k_12_total | 520 | 85 | 17 | * | 8 | * | 35 | 8 | 128 | 94 | 665 | 520 | 85 | 17 | 8 | 35 | 8 | 128 | 94 | 665 | ||||||||||||||||||||||||||||||||||
3306579 | 3306579 | MO | school | 2911910 | 94078 | FARMINGTON R-VII | 291191002847 | 4060 | ROOSEVELT ELEM. | Regular School | No | Elementary | 01 | 04 | 2019 | k_12_total | 413 | 10 | 13 | * | * | * | 9 | 8 | 252 | 44 | 449 | 413 | 10 | 13 | 9 | 8 | 252 | 44 | 449 | |||||||||||||||||||||||||||||||||||
3306827 | 3306827 | MO | school | 2913830 | 96088 | HAZELWOOD | 291383000636 | 4260 | TWILLMAN ELEM. | Regular School | No | Elementary | PK | 05 | 2019 | k_12_total | * | 386 | 5 | * | * | * | * | 8 | * | 77 | 394 | 386 | 5 | 8 | 77 | 394 | ||||||||||||||||||||||||||||||||||||||
3306845 | 3306845 | MO | school | 2913830 | 96088 | HAZELWOOD | 291383000613 | 4320 | ARMSTRONG ELEM. | Regular School | No | Elementary | KG | 05 | 2019 | k_12_total | 67 | 303 | 14 | * | * | * | 16 | 8 | 292 | 53 | 402 | 67 | 303 | 14 | 16 | 8 | 292 | 53 | 402 | |||||||||||||||||||||||||||||||||||
3307168 | 3307168 | MO | school | 2926850 | 96091 | ROCKWOOD R-VI | 292685001619 | 4100 | EUREKA ELEM. | Regular School | No | Elementary | KG | 05 | 2019 | k_12_total | 353 | 24 | 9 | * | 5 | * | 9 | 8 | 52 | 67 | 401 | 353 | 24 | 9 | 5 | 9 | 8 | 52 | 67 | 401 | ||||||||||||||||||||||||||||||||||
3307300 | 3307300 | MO | school | 2916770 | 96092 | KIRKWOOD R-VII | 291677000928 | 6020 | WESTCHESTER ELEM. | Regular School | No | Elementary | KG | 05 | 2019 | k_12_total | 425 | 31 | 24 | * | 9 | * | 29 | 8 | 40 | 78 | 521 | 425 | 31 | 24 | 9 | 29 | 8 | 40 | 78 | 521 | ||||||||||||||||||||||||||||||||||
3307453 | 3307453 | MO | school | 2920670 | 96094 | MEHLVILLE R-IX | 292067003320 | 5080 | MOSAIC ELEMENTARY | Regular School | No | Elementary | KG | 05 | 2019 | k_12_total | 220 | * | 6 | * | 7 | * | 16 | 8 | 36 | 33 | 253 | 220 | 6 | 7 | 16 | 8 | 36 | 33 | 253 | |||||||||||||||||||||||||||||||||||
3307544 | 3307544 | MO | school | 2923580 | 96095 | PARKWAY C-2 | 292358001380 | 4040 | CLAYMONT ELEM. | Regular School | No | Elementary | PK | 05 | 2019 | k_12_total | 395 | 60 | 11 | * | 19 | * | 20 | 8 | 68 | 88 | 505 | 395 | 60 | 11 | 19 | 20 | 8 | 68 | 88 | 505 | ||||||||||||||||||||||||||||||||||
3307684 | 3307684 | MO | school | 2905880 | 96101 | BRENTWOOD | 290588001113 | 3000 | BRENTWOOD MIDDLE | Regular School | No | Middle | 06 | 08 | 2019 | k_12_total | 106 | 41 | 12 | * | 8 | * | 11 | 8 | 51 | 23 | 178 | 106 | 41 | 12 | 8 | 11 | 8 | 51 | 23 | 178 | ||||||||||||||||||||||||||||||||||
3307711 | 3307711 | MO | school | 2909720 | 96102 | CLAYTON | 290972002584 | 3000 | WYDOWN MIDDLE | Regular School | No | Middle | 06 | 08 | 2019 | k_12_total | 417 | 102 | 29 | * | 81 | * | 41 | 8 | 52 | 78 | 671 | 417 | 102 | 29 | 81 | 41 | 8 | 52 | 78 | 671 | ||||||||||||||||||||||||||||||||||
3307878 | 3307878 | MO | school | 2922650 | 96109 | NORMANDY SCHOOLS COLLABORATIVE | 292265001244 | 3000 | 7th and 8th Grade Center | Regular School | No | Middle | 07 | 08 | 2019 | k_12_total | 8 | 422 | 9 | * | * | * | 5 | 8 | 461 | 59 | 446 | 8 | 422 | 9 | 5 | 8 | 461 | 59 | 446 | |||||||||||||||||||||||||||||||||||
3307976 | 3307976 | MO | school | 2926670 | 96111 | RIVERVIEW GARDENS | 292667001586 | 1050 | RIVERVIEW GARDENS SR. HIGH | Regular School | No | High | 09 | 12 | 2019 | k_12_total | 9 | 1153 | 5 | * | * | * | * | 8 | 1114.2 | 211 | 1171 | 9 | 1153 | 5 | 8 | 211 | 1171 | |||||||||||||||||||||||||||||||||||||
3307994 | 3307994 | MO | school | 2926670 | 96111 | RIVERVIEW GARDENS | 292667002687 | 4040 | WESTVIEW MIDDLE | Regular School | No | Middle | 06 | 08 | 2019 | k_12_total | * | 536 | 5 | * | * | * | * | 8 | * | 105 | 546 | 536 | 5 | 8 | 105 | 546 | ||||||||||||||||||||||||||||||||||||||
3308114 | 3308114 | MO | school | 2931530 | 96114 | WEBSTER GROVES | 293153002197 | 1050 | WEBSTER GROVES HIGH | Regular School | No | High | 09 | 12 | 2019 | k_12_total | 1027 | 252 | 54 | * | 32 | * | 47 | 8 | 215 | 200 | 1414 | 1027 | 252 | 54 | 32 | 47 | 8 | 215 | 200 | 1414 | ||||||||||||||||||||||||||||||||||
3308715 | 3308715 | MO | school | 2926160 | 104044 | REEDS SPRING R-IV | 292616003034 | 4030 | REEDS SPRING ELEM. | Regular School | No | Elementary | 02 | 04 | 2019 | k_12_total | 364 | * | 18 | * | * | * | 13 | 8 | 255 | 65 | 397 | 364 | 18 | 13 | 8 | 255 | 65 | 397 |
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]);