enrollments
Data source: Big Local News · About: Big Local
36,896 rows where state = "MO" and year = 2018 sorted by ell descending
This data as json, CSV (advanced)
grade ✖
- grade_1 2,306
- grade_10 2,306
- grade_11 2,306
- grade_12 2,306
- grade_2 2,306
- grade_3 2,306
- grade_4 2,306
- grade_5 2,306
- grade_6 2,306
- grade_7 2,306
- grade_8 2,306
- grade_9 2,306
- k_12_total 2,306
- kindergarten 2,306
- pk_12_total 2,306
- pre_kindergarten 2,306
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||
3296952 | 3296952 | MO | school | 2925620 | 5124 | PURDY R-II | 292562001502 | 1050 | PURDY HIGH | Regular School | No | High | 09 | 12 | 2018 | k_12_total | 131 | * | 24 | * | * | 20 | * | 9 | 87 | 6 | 180 | 131 | 24 | 20 | 9 | 87 | 6 | 180 | ||||||||||||||||||||||||||||||||||||
3297199 | 3297199 | MO | school | 2909900 | 8111 | COLE CAMP R-I | 290990000292 | 4020 | COLE CAMP ELEM. | Regular School | No | Elementary | KG | 04 | 2018 | k_12_total | 238 | * | 10 | * | * | * | 5 | 9 | 151 | 41 | 253 | 238 | 10 | 5 | 9 | 151 | 41 | 253 | ||||||||||||||||||||||||||||||||||||
3297446 | 3297446 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100003152 | 4030 | ALPHA HART LEWIS | Regular School | No | Elementary | PK | 05 | 2018 | k_12_total | 180 | 150 | 22 | * | * | * | 59 | 9 | * | 66 | 419 | 180 | 150 | 22 | 59 | 9 | 66 | 419 | ||||||||||||||||||||||||||||||||||||
3297731 | 3297731 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001668 | 4400 | PERSHING ELEM. | Regular School | No | Elementary | KG | 06 | 2018 | k_12_total | 274 | * | 14 | * | * | * | 26 | 9 | 183 | 37 | 319 | 274 | 14 | 26 | 9 | 183 | 37 | 319 | ||||||||||||||||||||||||||||||||||||
3298051 | 3298051 | MO | school | 2906990 | 15002 | CAMDENTON R-III | 290699000175 | 1050 | CAMDENTON HIGH | Regular School | No | High | 09 | 12 | 2018 | k_12_total | 1215 | 23 | 56 | 8 | 15 | * | 15 | 9 | 609 | 177 | 1336 | 1215 | 23 | 56 | 8 | 15 | 15 | 9 | 609 | 177 | 1336 | |||||||||||||||||||||||||||||||||
3299435 | 3299435 | MO | school | 2916190 | 26006 | JEFFERSON CITY | 291619000476 | 3000 | LEWIS AND CLARK MIDDLE | Regular School | No | Middle | 06 | 08 | 2018 | k_12_total | 632 | 164 | 57 | * | 10 | * | 82 | 9 | 526 | 113 | 949 | 632 | 164 | 57 | 10 | 82 | 9 | 526 | 113 | 949 | ||||||||||||||||||||||||||||||||||
3299459 | 3299459 | MO | school | 2916190 | 26006 | JEFFERSON CITY | 291619000747 | 4030 | CEDAR HILL ELEM. | Regular School | No | Elementary | KG | 05 | 2018 | k_12_total | 271 | 42 | 24 | * | 13 | * | 39 | 9 | 166 | 44 | 392 | 271 | 42 | 24 | 13 | 39 | 9 | 166 | 44 | 392 | ||||||||||||||||||||||||||||||||||
3299951 | 3299951 | MO | school | 2909120 | 35097 | CLARKTON C-4 | 290912000269 | 1050 | CLARKTON HIGH | Regular School | No | High | 07 | 12 | 2018 | k_12_total | 103 | 11 | 19 | * | * | * | * | 9 | * | 19 | 136 | 103 | 11 | 19 | 9 | 19 | 136 | |||||||||||||||||||||||||||||||||||||
3300518 | 3300518 | MO | school | 2919170 | 39139 | LOGAN-ROGERSVILLE R-VIII | 291917003128 | 4030 | LOGAN-ROGERSVILLE ELEMENTARY | Regular School | No | Elementary | 02 | 03 | 2018 | k_12_total | 329 | * | 7 | * | * | * | 9 | 9 | 138 | 30 | 350 | 329 | 7 | 9 | 9 | 138 | 30 | 350 | ||||||||||||||||||||||||||||||||||||
3300548 | 3300548 | MO | school | 2928860 | 39141 | SPRINGFIELD R-XII | 292886001804 | 1085 | KICKAPOO HIGH | Regular School | No | High | 09 | 12 | 2018 | k_12_total | 1545 | 83 | 81 | 9 | 52 | * | 36 | 9 | 435 | 123 | 1809 | 1545 | 83 | 81 | 9 | 52 | 36 | 9 | 435 | 123 | 1809 | |||||||||||||||||||||||||||||||||
3300614 | 3300614 | MO | school | 2928860 | 39141 | SPRINGFIELD R-XII | 292886001781 | 4040 | BINGHAM ELEM. | Regular School | No | Elementary | KG | 05 | 2018 | k_12_total | 338 | 26 | 26 | * | * | * | 41 | 9 | 322 | 69 | 436 | 338 | 26 | 26 | 41 | 9 | 322 | 69 | 436 | |||||||||||||||||||||||||||||||||||
3300734 | 3300734 | MO | school | 2928860 | 39141 | SPRINGFIELD R-XII | 292886001814 | 4500 | PITTMAN ELEM. | Regular School | No | Elementary | KG | 05 | 2018 | k_12_total | 239 | 23 | 19 | * | * | * | 30 | 9 | 220.1 | 51 | 315 | 239 | 23 | 19 | 30 | 9 | 51 | 315 | ||||||||||||||||||||||||||||||||||||
3300776 | 3300776 | MO | school | 2928860 | 39141 | SPRINGFIELD R-XII | 292886001828 | 4680 | SUNSHINE ELEM. | Regular School | No | Elementary | KG | 05 | 2018 | k_12_total | 155 | 8 | 12 | * | 5 | * | 14 | 9 | 110 | 17 | 199 | 155 | 8 | 12 | 5 | 14 | 9 | 110 | 17 | 199 | ||||||||||||||||||||||||||||||||||
3301388 | 3301388 | MO | school | 2912290 | 48066 | FORT OSAGE R-I | 291229002284 | 4110 | FIRE PRAIRIE MIDDLE | Regular School | No | Middle | 05 | 06 | 2018 | k_12_total | 593 | 65 | 75 | 6 | 9 | 17 | 28 | 9 | 426 | 99 | 793 | 593 | 65 | 75 | 6 | 9 | 17 | 28 | 9 | 426 | 99 | 793 | ||||||||||||||||||||||||||||||||
3301485 | 3301485 | MO | school | 2905310 | 48068 | BLUE SPRINGS R-IV | 290531000084 | 5000 | JOHN NOWLIN ELEM. | Regular School | No | Elementary | PK | 05 | 2018 | k_12_total | 318 | 34 | 41 | * | 6 | * | 29 | 9 | 139 | 54 | 434 | 318 | 34 | 41 | 6 | 29 | 9 | 139 | 54 | 434 | ||||||||||||||||||||||||||||||||||
3301683 | 3301683 | MO | school | 2918300 | 48071 | LEE'S SUMMIT R-VII | 291830000984 | 5020 | WESTVIEW ELEM. | Regular School | No | Elementary | KG | 06 | 2018 | k_12_total | 287 | 48 | 24 | * | * | * | 35 | 9 | 192 | 45 | 396 | 287 | 48 | 24 | 35 | 9 | 192 | 45 | 396 | |||||||||||||||||||||||||||||||||||
3301713 | 3301713 | MO | school | 2918300 | 48071 | LEE'S SUMMIT R-VII | 291830003134 | 5045 | SUNSET VALLEY ELEM. | Regular School | No | Elementary | KG | 08 | 2018 | k_12_total | 354 | 70 | 12 | * | 7 | * | 24 | 9 | 100 | 48 | 467 | 354 | 70 | 12 | 7 | 24 | 9 | 100 | 48 | 467 | ||||||||||||||||||||||||||||||||||
3302191 | 3302191 | MO | school | 2916400 | 48078 | KANSAS CITY 33 | 291640003251 | 3090 | CENTRAL MIDDLE SCHOOL | Regular School | No | Middle | 07 | 08 | 2018 | k_12_total | 17 | 352 | 24 | * | * | * | * | 9 | * | 107 | 400 | 17 | 352 | 24 | 9 | 107 | 400 | |||||||||||||||||||||||||||||||||||||
3302570 | 3302570 | MO | school | 2900597 | 48924 | EWING MARION KAUFFMAN SCHOOL | 290059703277 | 1910 | EWING MARION KAUFFMAN HIGH | Regular School | Yes | Secondary | 09 | 11 | 2018 | k_12_total | 6 | 159 | 29 | * | 6 | * | * | 9 | 164 | 12 | 203 | 6 | 159 | 29 | 6 | 9 | 164 | 12 | 203 | |||||||||||||||||||||||||||||||||||
3302745 | 3302745 | MO | school | 2931500 | 49144 | WEBB CITY R-VII | 293150000559 | 3000 | WEBB CITY MIDDLE | Regular School | No | Middle | 05 | 06 | 2018 | k_12_total | 554 | 10 | 37 | 11 | 12 | * | 29 | 9 | 301 | 82 | 654 | 554 | 10 | 37 | 11 | 12 | 29 | 9 | 301 | 82 | 654 | |||||||||||||||||||||||||||||||||
3302849 | 3302849 | MO | school | 2916350 | 49148 | JOPLIN SCHOOLS | 291635000779 | 4180 | JEFFERSON ELEM. | Regular School | No | Elementary | KG | 05 | 2018 | k_12_total | 200 | * | 19 | 5 | * | * | 11 | 9 | 166 | 55 | 242 | 200 | 19 | 5 | 11 | 9 | 166 | 55 | 242 | |||||||||||||||||||||||||||||||||||
3303518 | 3303518 | MO | school | 2903000 | 54042 | SANTA FE R-X | 290300000012 | 4040 | SANTA FE ELEM. | Regular School | No | Elementary | PK | 06 | 2018 | k_12_total | 139 | * | 14 | * | * | * | * | 9 | 68 | 16 | 154 | 139 | 14 | 9 | 68 | 16 | 154 | |||||||||||||||||||||||||||||||||||||
3303632 | 3303632 | MO | school | 2904020 | 55110 | AURORA R-VIII | 290402001517 | 2050 | AURORA JR. HIGH | Regular School | No | Middle | 07 | 08 | 2018 | k_12_total | 266 | 6 | 42 | 6 | * | * | * | 9 | 199.3 | 52 | 322 | 266 | 6 | 42 | 6 | 9 | 52 | 322 | ||||||||||||||||||||||||||||||||||||
3303716 | 3303716 | MO | school | 2911400 | 57002 | ELSBERRY R-II | 291140000406 | 4020 | CLARENCE CANNON ELEM. | Regular School | No | Elementary | PK | 04 | 2018 | k_12_total | 260 | 8 | 14 | * | * | * | 17 | 9 | 166 | 41 | 300 | 260 | 8 | 14 | 17 | 9 | 166 | 41 | 300 | |||||||||||||||||||||||||||||||||||
3303941 | 3303941 | MO | school | 2920610 | 60077 | MCDONALD CO. R-I | 292061003007 | 3000 | ANDERSON MIDDLE | Regular School | No | Middle | 06 | 08 | 2018 | k_12_total | 218 | * | 25 | 6 | * | * | 6 | 9 | 156 | 54 | 260 | 218 | 25 | 6 | 6 | 9 | 156 | 54 | 260 | |||||||||||||||||||||||||||||||||||
3304228 | 3304228 | MO | school | 2925590 | 65098 | PRINCETON R-V | 292559002299 | 4020 | PRINCETON R-V ELEM. | Regular School | No | Elementary | PK | 06 | 2018 | k_12_total | 168 | * | 13 | * | * | * | * | 9 | 81 | 16 | 184 | 168 | 13 | 9 | 81 | 16 | 184 | |||||||||||||||||||||||||||||||||||||
3305067 | 3305067 | MO | school | 2924530 | 79077 | PERRY CO. 32 | 292453002387 | 1050 | PERRYVILLE SR. HIGH | Regular School | No | High | 09 | 12 | 2018 | k_12_total | 727 | * | 21 | * | 5 | * | 13 | 9 | 272.1 | 132 | 769 | 727 | 21 | 5 | 13 | 9 | 132 | 769 | ||||||||||||||||||||||||||||||||||||
3305398 | 3305398 | MO | school | 2925230 | 83003 | PLATTE CO. R-III | 292523002024 | 4030 | DONALD D. SIEGRIST ELEM. | Regular School | No | Elementary | PK | 05 | 2018 | k_12_total | 511 | 30 | 34 | * | 8 | * | 27 | 9 | 143 | 55 | 613 | 511 | 30 | 34 | 8 | 27 | 9 | 143 | 55 | 613 | ||||||||||||||||||||||||||||||||||
3305406 | 3305406 | MO | school | 2925230 | 83003 | PLATTE CO. R-III | 292523003288 | 4060 | COMPASS ELEMENTARY | Regular School | No | Elementary | PK | 05 | 2018 | k_12_total | 487 | 13 | 40 | * | * | 6 | 36 | 9 | 162 | 57 | 586 | 487 | 13 | 40 | 6 | 36 | 9 | 162 | 57 | 586 | ||||||||||||||||||||||||||||||||||
3306049 | 3306049 | MO | school | 2908370 | 92087 | FT. ZUMWALT R-II | 290837002427 | 3070 | FT. ZUMWALT SOUTH MIDDLE | Regular School | No | Middle | 06 | 08 | 2018 | k_12_total | 827 | 77 | 47 | * | 46 | * | 47 | 9 | 166 | 116 | 1048 | 827 | 77 | 47 | 46 | 47 | 9 | 166 | 116 | 1048 | ||||||||||||||||||||||||||||||||||
3306454 | 3306454 | MO | school | 2923160 | 92091 | ORCHARD FARM R-V | 292316001331 | 1050 | Orchard Farm High School | Regular School | No | High | 09 | 12 | 2018 | k_12_total | 456 | 41 | 32 | * | 6 | * | 17 | 9 | 118.1 | 65 | 556 | 456 | 41 | 32 | 6 | 17 | 9 | 65 | 556 | |||||||||||||||||||||||||||||||||||
3307119 | 3307119 | MO | school | 2926850 | 96091 | ROCKWOOD R-VI | 292685002785 | 3050 | WILDWOOD MIDDLE | Regular School | No | Middle | 06 | 08 | 2018 | k_12_total | 489 | 56 | 16 | * | 44 | * | 20 | 9 | 79 | 109 | 628 | 489 | 56 | 16 | 44 | 20 | 9 | 79 | 109 | 628 | ||||||||||||||||||||||||||||||||||
3307125 | 3307125 | MO | school | 2926850 | 96091 | ROCKWOOD R-VI | 292685000706 | 3060 | ROCKWOOD SOUTH MIDDLE | Regular School | No | Middle | 06 | 08 | 2018 | k_12_total | 788 | 91 | 21 | * | 38 | * | 21 | 9 | 160 | 125 | 960 | 788 | 91 | 21 | 38 | 21 | 9 | 160 | 125 | 960 | ||||||||||||||||||||||||||||||||||
3307263 | 3307263 | MO | school | 2916770 | 96092 | KIRKWOOD R-VII | 291677000923 | 3000 | NIPHER MIDDLE | Regular School | No | Middle | 06 | 08 | 2018 | k_12_total | 538 | 88 | 21 | * | 9 | * | 30 | 9 | 100 | 83 | 686 | 538 | 88 | 21 | 9 | 30 | 9 | 100 | 83 | 686 | ||||||||||||||||||||||||||||||||||
3307281 | 3307281 | MO | school | 2916770 | 96092 | KIRKWOOD R-VII | 291677000924 | 5020 | NORTH GLENDALE ELEM. | Regular School | No | Elementary | KG | 05 | 2018 | k_12_total | 464 | 57 | 18 | * | 9 | * | 25 | 9 | 64 | 84 | 573 | 464 | 57 | 18 | 9 | 25 | 9 | 64 | 84 | 573 | ||||||||||||||||||||||||||||||||||
3307695 | 3307695 | MO | school | 2905880 | 96101 | BRENTWOOD | 290588000133 | 4060 | MCGRATH ELEM. | Regular School | No | Elementary | KG | 05 | 2018 | k_12_total | 120 | 33 | 14 | * | 8 | * | 17 | 9 | 37 | 23 | 193 | 120 | 33 | 14 | 8 | 17 | 9 | 37 | 23 | 193 | ||||||||||||||||||||||||||||||||||
3308053 | 3308053 | MO | school | 2930660 | 96112 | UNIVERSITY CITY | 293066002113 | 1050 | UNIVERSITY CITY SR. HIGH | Regular School | No | High | 09 | 12 | 2018 | k_12_total | 70 | 652 | 23 | * | 7 | * | 23 | 9 | * | 102 | 775 | 70 | 652 | 23 | 7 | 23 | 9 | 102 | 775 | |||||||||||||||||||||||||||||||||||
3308872 | 3308872 | MO | school | 2914550 | 106005 | HOLLISTER R-V | 291455001120 | 3000 | HOLLISTER MIDDLE | Regular School | No | Middle | 06 | 08 | 2018 | k_12_total | 263 | 5 | 26 | * | * | * | 11 | 9 | 207 | 18 | 307 | 263 | 5 | 26 | 11 | 9 | 207 | 18 | 307 | |||||||||||||||||||||||||||||||||||
3299207 | 3299207 | MO | school | 2922800 | 24093 | NORTH KANSAS CITY 74 | 292280001263 | 4100 | CHOUTEAU ELEM. | Regular School | No | Elementary | PK | 05 | 2018 | k_12_total | 169 | 101 | 60 | * | 12 | * | 44 | 89 | 307 | 50 | 388 | 169 | 101 | 60 | 12 | 44 | 89 | 307 | 50 | 388 | ||||||||||||||||||||||||||||||||||
3296999 | 3296999 | MO | school | 2921120 | 5128 | MONETT R-I | 292112001595 | 4040 | MONETT INTERMEDIATE | Regular School | No | Middle | 05 | 06 | 2018 | k_12_total | 188 | * | 154 | * | 6 | 5 | * | 88 | 252 | 86 | 362 | 188 | 154 | 6 | 5 | 88 | 252 | 86 | 362 | |||||||||||||||||||||||||||||||||||
3302069 | 3302069 | MO | school | 2915480 | 48077 | INDEPENDENCE 30 | 291548003107 | 5100 | KORTE ELEM. | Regular School | No | Elementary | PK | 05 | 2018 | k_12_total | 272 | 76 | 183 | * | * | * | 58 | 88 | 520 | 51 | 597 | 272 | 76 | 183 | 58 | 88 | 520 | 51 | 597 | |||||||||||||||||||||||||||||||||||
3307959 | 3307959 | MO | school | 2926640 | 96110 | RITENOUR | 292664001571 | 4160 | MARVIN ELEM. | Regular School | No | Elementary | KG | 05 | 2018 | k_12_total | 144 | 243 | 109 | * | 7 | * | 45 | 88 | * | 86 | 549 | 144 | 243 | 109 | 7 | 45 | 88 | 86 | 549 | |||||||||||||||||||||||||||||||||||
3299167 | 3299167 | MO | school | 2922800 | 24093 | NORTH KANSAS CITY 74 | 292280001278 | 3150 | MAPLE PARK MIDDLE | Regular School | No | Middle | 06 | 08 | 2018 | k_12_total | 405 | 156 | 148 | * | 25 | 9 | 69 | 86 | 541 | 124 | 816 | 405 | 156 | 148 | 25 | 9 | 69 | 86 | 541 | 124 | 816 | |||||||||||||||||||||||||||||||||
3302715 | 3302715 | MO | school | 2907460 | 49142 | CARTHAGE R-IX | 290746000209 | 5000 | MARK TWAIN ELEM. | Regular School | No | Elementary | KG | 04 | 2018 | k_12_total | 197 | * | 92 | * | * | * | 10 | 86 | 179 | 32 | 305 | 197 | 92 | 10 | 86 | 179 | 32 | 305 | ||||||||||||||||||||||||||||||||||||
3305170 | 3305170 | MO | school | 2927830 | 80125 | SEDALIA 200 | 292783001703 | 4020 | HEBER HUNT ELEM. | Regular School | No | Elementary | KG | 04 | 2018 | k_12_total | 262 | 42 | 115 | * | * | * | 40 | 86 | 359.2 | 76 | 462 | 262 | 42 | 115 | 40 | 86 | 76 | 462 | ||||||||||||||||||||||||||||||||||||
3296975 | 3296975 | MO | school | 2921120 | 5128 | MONETT R-I | 292112001162 | 1050 | MONETT HIGH | Regular School | No | High | 09 | 12 | 2018 | k_12_total | 435 | 7 | 280 | 5 | 15 | * | 17 | 85 | 381.2 | 90 | 763 | 435 | 7 | 280 | 5 | 15 | 17 | 85 | 90 | 763 | ||||||||||||||||||||||||||||||||||
3297621 | 3297621 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001648 | 1075 | CENTRAL HIGH | Regular School | No | High | 09 | 12 | 2018 | k_12_total | 1270 | 126 | 155 | * | 64 | 8 | 75 | 85 | 640 | 227 | 1701 | 1270 | 126 | 155 | 64 | 8 | 75 | 85 | 640 | 227 | 1701 | |||||||||||||||||||||||||||||||||
3302524 | 3302524 | MO | school | 2900031 | 48918 | KIPP: ENDEAVOR ACADEMY | 290003103013 | 3920 | KIPP ENDEAVOR ACADEMY | Regular School | Yes | Elementary | KG | 08 | 2018 | k_12_total | 50 | 364 | 123 | * | 6 | * | * | 85 | * | 67 | 548 | 50 | 364 | 123 | 6 | 85 | 67 | 548 | ||||||||||||||||||||||||||||||||||||
3302547 | 3302547 | MO | school | 2900590 | 48922 | FRONTIER SCHOOLS | 290059003182 | 3935 | FRONTIER SCHL OF INNOVATION-M | Regular School | Yes | Middle | 06 | 08 | 2018 | k_12_total | 20 | 49 | 240 | * | * | * | * | 85 | * | 14 | 311 | 20 | 49 | 240 | 85 | 14 | 311 | |||||||||||||||||||||||||||||||||||||
3309753 | 3309753 | MO | school | 2929280 | 115115 | ST. LOUIS CITY | 292928000798 | 5590 | MULLANPHY BOTANICAL GARDENS | Regular School | No | Elementary | PK | 05 | 2018 | k_12_total | 34 | 305 | 42 | * | 20 | * | * | 84 | * | 69 | 401 | 34 | 305 | 42 | 20 | 84 | 69 | 401 | ||||||||||||||||||||||||||||||||||||
3297687 | 3297687 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001654 | 4140 | COLEMAN ELEM. | Regular School | No | Elementary | PK | 06 | 2018 | k_12_total | 181 | 66 | 41 | * | 31 | 40 | 31 | 83 | * | 28 | 390 | 181 | 66 | 41 | 31 | 40 | 31 | 83 | 28 | 390 | ||||||||||||||||||||||||||||||||||
3307413 | 3307413 | MO | school | 2920670 | 96094 | MEHLVILLE R-IX | 292067001112 | 4070 | BLADES ELEM. | Regular School | No | Elementary | KG | 05 | 2018 | k_12_total | 412 | 38 | 26 | * | 6 | * | 15 | 83 | 138 | 92 | 497 | 412 | 38 | 26 | 6 | 15 | 83 | 138 | 92 | 497 | ||||||||||||||||||||||||||||||||||
3307561 | 3307561 | MO | school | 2923580 | 96095 | PARKWAY C-2 | 292358001386 | 4110 | HANNA WOODS ELEM. | Regular School | No | Elementary | KG | 05 | 2018 | k_12_total | 271 | 60 | 29 | * | 57 | * | 32 | 83 | 142 | 74 | 450 | 271 | 60 | 29 | 57 | 32 | 83 | 142 | 74 | 450 | ||||||||||||||||||||||||||||||||||
3302317 | 3302317 | MO | school | 2916400 | 48078 | KANSAS CITY 33 | 291640002530 | 5630 | PRIMITIVO GARCIA ELEM. | Regular School | No | Elementary | PK | 06 | 2018 | k_12_total | 29 | 144 | 86 | * | 8 | * | 11 | 82 | * | 40 | 279 | 29 | 144 | 86 | 8 | 11 | 82 | 40 | 279 | |||||||||||||||||||||||||||||||||||
3301695 | 3301695 | MO | school | 2918300 | 48071 | LEE'S SUMMIT R-VII | 291830002291 | 5030 | PRAIRIE VIEW ELEM. | Regular School | No | Elementary | KG | 06 | 2018 | k_12_total | 584 | 118 | 68 | * | 29 | * | 91 | 81 | 391 | 102 | 895 | 584 | 118 | 68 | 29 | 91 | 81 | 391 | 102 | 895 | ||||||||||||||||||||||||||||||||||
3302285 | 3302285 | MO | school | 2916400 | 48078 | KANSAS CITY 33 | 291640000864 | 5240 | PITCHER ELEM. | Regular School | No | Elementary | PK | 06 | 2018 | k_12_total | 63 | 147 | 99 | * | * | * | 11 | 80 | * | 36 | 323 | 63 | 147 | 99 | 11 | 80 | 36 | 323 | ||||||||||||||||||||||||||||||||||||
3296856 | 3296856 | MO | school | 2920810 | 4110 | MEXICO 59 | 292081001137 | 1050 | MEXICO HIGH | Regular School | No | High | 09 | 12 | 2018 | k_12_total | 544 | 56 | 43 | * | 6 | * | 50 | 8 | 270.3 | 67 | 700 | 544 | 56 | 43 | 6 | 50 | 8 | 67 | 700 | |||||||||||||||||||||||||||||||||||
3297041 | 3297041 | MO | school | 2917850 | 6104 | LAMAR R-I | 291785000954 | 1050 | LAMAR HIGH | Regular School | No | High | 09 | 12 | 2018 | k_12_total | 362 | * | 19 | * | * | * | 23 | 8 | 175 | 45 | 407 | 362 | 19 | 23 | 8 | 175 | 45 | 407 | ||||||||||||||||||||||||||||||||||||
3297053 | 3297053 | MO | school | 2917850 | 6104 | LAMAR R-I | 291785000953 | 4020 | LAMAR ELEM. | Regular School | No | Elementary | 03 | 05 | 2018 | k_12_total | 253 | * | 14 | * | * | * | 16 | 8 | 167 | 60 | 288 | 253 | 14 | 16 | 8 | 167 | 60 | 288 | ||||||||||||||||||||||||||||||||||||
3297663 | 3297663 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001650 | 4060 | ELLISON ELEM. | Regular School | No | Elementary | KG | 06 | 2018 | k_12_total | 267 | 22 | 15 | * | 6 | * | 29 | 8 | 141 | 35 | 341 | 267 | 22 | 15 | 6 | 29 | 8 | 141 | 35 | 341 | ||||||||||||||||||||||||||||||||||
3298744 | 3298744 | MO | school | 2922530 | 22089 | Nixa Public Schools | 292253002799 | 4080 | SUMMIT INTERMEDIATE SCHOOL | Regular School | No | Middle | 04 | 06 | 2018 | k_12_total | 467 | 8 | 25 | * | * | * | 34 | 8 | 204 | 72 | 540 | 467 | 8 | 25 | 34 | 8 | 204 | 72 | 540 | |||||||||||||||||||||||||||||||||||
3298756 | 3298756 | MO | school | 2922530 | 22089 | Nixa Public Schools | 292253003202 | 4100 | JOHN THOMAS SCHOOL OF DISCOVER | Regular School | No | Elementary | KG | 06 | 2018 | k_12_total | 447 | * | 20 | * | * | * | 24 | 8 | 117 | 63 | 496 | 447 | 20 | 24 | 8 | 117 | 63 | 496 | ||||||||||||||||||||||||||||||||||||
3298810 | 3298810 | MO | school | 2909780 | 22092 | CLEVER R-V | 290978000281 | 4020 | CLEVER ELEM. | Regular School | No | Elementary | PK | 08 | 2018 | k_12_total | 750 | 13 | 19 | * | * | * | 18 | 8 | 350 | 79 | 806 | 750 | 13 | 19 | 18 | 8 | 350 | 79 | 806 | |||||||||||||||||||||||||||||||||||
3298816 | 3298816 | MO | school | 2923430 | 22093 | OZARK R-VI | 292343001351 | 1050 | OZARK HIGH | Regular School | No | High | 10 | 12 | 2018 | k_12_total | 1163 | 10 | 57 | 13 | 13 | * | 49 | 8 | 340 | 119 | 1307 | 1163 | 10 | 57 | 13 | 13 | 49 | 8 | 340 | 119 | 1307 | |||||||||||||||||||||||||||||||||
3299501 | 3299501 | MO | school | 2916190 | 26006 | JEFFERSON CITY | 291619000757 | 5020 | THORPE J. GORDON ELEM. | Regular School | No | Elementary | KG | 05 | 2018 | k_12_total | 113 | 157 | 23 | * | * | * | 45 | 8 | * | 39 | 339 | 113 | 157 | 23 | 45 | 8 | 39 | 339 | ||||||||||||||||||||||||||||||||||||
3300035 | 3300035 | MO | school | 2923460 | 36126 | MERAMEC VALLEY R-III | 292346001355 | 3000 | MERAMEC VALLEY MIDDLE | Regular School | No | Middle | 06 | 07 | 2018 | k_12_total | 444 | 11 | 20 | * | 5 | * | 16 | 8 | 261 | 110 | 499 | 444 | 11 | 20 | 5 | 16 | 8 | 261 | 110 | 499 | ||||||||||||||||||||||||||||||||||
3300359 | 3300359 | MO | school | 2932010 | 39133 | WILLARD R-II | 293201002242 | 3050 | WILLARD MIDDLE | Regular School | No | Middle | 07 | 08 | 2018 | k_12_total | 613 | 13 | 26 | * | 6 | * | 16 | 8 | 273.4 | 90 | 677 | 613 | 13 | 26 | 6 | 16 | 8 | 90 | 677 | |||||||||||||||||||||||||||||||||||
3300383 | 3300383 | MO | school | 2932010 | 39133 | WILLARD R-II | 293201002773 | 4060 | WILLARD EAST ELEM. | Regular School | No | Elementary | PK | 04 | 2018 | k_12_total | 326 | 5 | 12 | * | * | * | 5 | 8 | 120 | 54 | 349 | 326 | 5 | 12 | 5 | 8 | 120 | 54 | 349 | |||||||||||||||||||||||||||||||||||
3300818 | 3300818 | MO | school | 2928860 | 39141 | SPRINGFIELD R-XII | 292886001837 | 4820 | WILLIAMS ELEM. | Regular School | No | Elementary | PK | 05 | 2018 | k_12_total | 194 | 43 | 25 | * | * | 5 | 31 | 8 | 258.4 | 56 | 298 | 194 | 43 | 25 | 5 | 31 | 8 | 56 | 298 | |||||||||||||||||||||||||||||||||||
3300830 | 3300830 | MO | school | 2928860 | 39141 | SPRINGFIELD R-XII | 292886001838 | 4840 | YORK ELEM. | Regular School | No | Elementary | PK | 05 | 2018 | k_12_total | 174 | 20 | 12 | * | * | * | 19 | 8 | 202 | 33 | 232 | 174 | 20 | 12 | 19 | 8 | 202 | 33 | 232 | |||||||||||||||||||||||||||||||||||
3301429 | 3301429 | MO | school | 2905310 | 48068 | BLUE SPRINGS R-IV | 290531002736 | 3080 | DELTA WOODS MIDDLE | Regular School | No | Middle | 06 | 08 | 2018 | k_12_total | 585 | 100 | 68 | 8 | 40 | * | 48 | 8 | 179 | 72 | 852 | 585 | 100 | 68 | 8 | 40 | 48 | 8 | 179 | 72 | 852 | |||||||||||||||||||||||||||||||||
3301539 | 3301539 | MO | school | 2913080 | 48069 | GRAIN VALLEY R-V | 291308000547 | 4040 | MATTHEWS ELEM. | Regular School | No | Elementary | KG | 05 | 2018 | k_12_total | 411 | 16 | 39 | * | * | * | 29 | 8 | 179 | 51 | 502 | 411 | 16 | 39 | 29 | 8 | 179 | 51 | 502 | |||||||||||||||||||||||||||||||||||
3302032 | 3302032 | MO | school | 2915480 | 48077 | INDEPENDENCE 30 | 291548000708 | 4060 | BLACKBURN ELEM. | Regular School | No | Elementary | PK | 05 | 2018 | k_12_total | 252 | 57 | 44 | * | * | * | 26 | 8 | 177 | 34 | 384 | 252 | 57 | 44 | 26 | 8 | 177 | 34 | 384 | |||||||||||||||||||||||||||||||||||
3302356 | 3302356 | MO | school | 2908250 | 48080 | CENTER 58 | 290825000230 | 2100 | CENTER MIDDLE | Regular School | No | Middle | 06 | 08 | 2018 | k_12_total | 98 | 354 | 50 | * | * | * | 32 | 8 | 374 | 101 | 540 | 98 | 354 | 50 | 32 | 8 | 374 | 101 | 540 | |||||||||||||||||||||||||||||||||||
3302873 | 3302873 | MO | school | 2916350 | 49148 | JOPLIN SCHOOLS | 291635000791 | 4320 | STAPLETON ELEM. | Regular School | No | Elementary | KG | 05 | 2018 | k_12_total | 341 | 13 | 25 | 9 | * | * | 20 | 8 | 193 | 65 | 414 | 341 | 13 | 25 | 9 | 20 | 8 | 193 | 65 | 414 | ||||||||||||||||||||||||||||||||||
3303090 | 3303090 | MO | school | 2932100 | 50010 | WINDSOR C-1 | 293210002250 | 4020 | WINDSOR INTERMEDIATE | Regular School | No | Elementary | 03 | 05 | 2018 | k_12_total | 657 | 15 | 14 | * | * | * | 5 | 8 | 262 | 102 | 696 | 657 | 15 | 14 | 5 | 8 | 262 | 102 | 696 | |||||||||||||||||||||||||||||||||||
3303281 | 3303281 | MO | school | 2914490 | 51152 | HOLDEN R-III | 291449000681 | 4040 | HOLDEN ELEM. | Regular School | No | Elementary | PK | 05 | 2018 | k_12_total | 443 | 5 | 14 | * | * | * | 30 | 8 | 224 | 81 | 496 | 443 | 5 | 14 | 30 | 8 | 224 | 81 | 496 | |||||||||||||||||||||||||||||||||||
3306079 | 3306079 | MO | school | 2908370 | 92087 | FT. ZUMWALT R-II | 290837000237 | 4050 | MOUNT HOPE ELEM. | Regular School | No | Elementary | KG | 05 | 2018 | k_12_total | 363 | 8 | 19 | * | * | * | 15 | 8 | 66 | 58 | 405 | 363 | 8 | 19 | 15 | 8 | 66 | 58 | 405 | |||||||||||||||||||||||||||||||||||
3306149 | 3306149 | MO | school | 2908370 | 92087 | FT. ZUMWALT R-II | 290837003289 | 4180 | FLINT HILL ELEMENTARY | Regular School | No | Elementary | KG | 05 | 2018 | k_12_total | 264 | 11 | 11 | * | * | * | 13 | 8 | 55 | 40 | 302 | 264 | 11 | 11 | 13 | 8 | 55 | 40 | 302 | |||||||||||||||||||||||||||||||||||
3306368 | 3306368 | MO | school | 2931650 | 92089 | WENTZVILLE R-IV | 293165002903 | 4100 | PEINE RIDGE ELEM. | Regular School | No | Elementary | KG | 06 | 2018 | k_12_total | 537 | 77 | 20 | * | 9 | * | 33 | 8 | 179 | 100 | 677 | 537 | 77 | 20 | 9 | 33 | 8 | 179 | 100 | 677 | ||||||||||||||||||||||||||||||||||
3307113 | 3307113 | MO | school | 2926850 | 96091 | ROCKWOOD R-VI | 292685000671 | 3040 | LASALLE SPRINGS MIDDLE | Regular School | No | Middle | 06 | 08 | 2018 | k_12_total | 752 | 66 | 28 | * | 13 | * | 16 | 8 | 109 | 127 | 881 | 752 | 66 | 28 | 13 | 16 | 8 | 109 | 127 | 881 | ||||||||||||||||||||||||||||||||||
3307573 | 3307573 | MO | school | 2923580 | 96095 | PARKWAY C-2 | 292358001388 | 4130 | HIGHCROFT RIDGE ELEM. | Regular School | No | Elementary | KG | 05 | 2018 | k_12_total | 239 | 53 | 7 | * | 31 | * | 24 | 8 | 51 | 60 | 356 | 239 | 53 | 7 | 31 | 24 | 8 | 51 | 60 | 356 | ||||||||||||||||||||||||||||||||||
3307911 | 3307911 | MO | school | 2922650 | 96109 | NORMANDY SCHOOLS COLLABORATIVE | 292265003269 | 5020 | NORMANDY KINDERGARTEN CENTER | Regular School | No | Elementary | KG | KG | 2018 | k_12_total | * | 269 | 8 | * | * | * | 9 | 8 | 279.4 | 37 | 289 | 269 | 8 | 9 | 8 | 37 | 289 | |||||||||||||||||||||||||||||||||||||
3308448 | 3308448 | MO | school | 2928260 | 100063 | SIKESTON R-6 | 292826001566 | 4050 | MATTHEWS ELEM. | Regular School | No | Elementary | 01 | 04 | 2018 | k_12_total | 158 | 149 | 24 | * | * | * | 22 | 8 | 271.2 | 48 | 356 | 158 | 149 | 24 | 22 | 8 | 48 | 356 | ||||||||||||||||||||||||||||||||||||
3308636 | 3308636 | MO | school | 2910770 | 103132 | DEXTER R-XI | 291077000361 | 4020 | CENTRAL ELEM. | Regular School | No | Elementary | 03 | 05 | 2018 | k_12_total | 459 | 10 | 13 | * | * | * | * | 8 | 272 | 93 | 489 | 459 | 10 | 13 | 8 | 272 | 93 | 489 | ||||||||||||||||||||||||||||||||||||
3308866 | 3308866 | MO | school | 2914550 | 106005 | HOLLISTER R-V | 291455000684 | 1050 | HOLLISTER HIGH | Regular School | No | High | 09 | 12 | 2018 | k_12_total | 435 | 5 | 28 | * | 5 | * | 13 | 8 | 235 | 34 | 489 | 435 | 5 | 28 | 5 | 13 | 8 | 235 | 34 | 489 | ||||||||||||||||||||||||||||||||||
3309693 | 3309693 | MO | school | 2929280 | 115115 | ST. LOUIS CITY | 292928002645 | 5030 | KENNARD/CLASSICAL JR. ACAD. | Regular School | No | Elementary | PK | 05 | 2018 | k_12_total | 205 | 79 | 10 | * | 30 | * | * | 8 | * | 16 | 324 | 205 | 79 | 10 | 30 | 8 | 16 | 324 | ||||||||||||||||||||||||||||||||||||
3310013 | 3310013 | MO | school | 2900605 | 115923 | EAGLE COLLEGE PREP ENDEAVOR | 290060503272 | 6996 | EAGLE FOX PARK | Regular School | Yes | Elementary | KG | 04 | 2018 | k_12_total | * | 143 | * | * | * | * | * | 8 | * | 24 | 154 | 143 | 8 | 24 | 154 | |||||||||||||||||||||||||||||||||||||||
3309977 | 3309977 | MO | school | 2900592 | 115916 | GATEWAY SCIENCE ACAD/ST LOUIS | 290059203241 | 6997 | GATEWAY SCIENCE ACAD-SOUTH ELE | Regular School | Yes | Elementary | KG | 05 | 2018 | k_12_total | 248 | 97 | 29 | * | 11 | * | 37 | 79 | 283 | 47 | 423 | 248 | 97 | 29 | 11 | 37 | 79 | 283 | 47 | 423 | ||||||||||||||||||||||||||||||||||
3297464 | 3297464 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100002665 | 4055 | DERBY RIDGE ELEM. | Regular School | No | Elementary | PK | 05 | 2018 | k_12_total | 168 | 162 | 38 | * | 39 | * | 45 | 78 | * | 73 | 456 | 168 | 162 | 38 | 39 | 45 | 78 | 73 | 456 |
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]);