enrollments
Data source: Big Local News · About: Big Local
6,262 rows where state = "MS" and year = 2021 sorted by white descending
This data as json, CSV (advanced)
grade ✖
- pk_12_total 881
- elementary_spec_ed 442
- grade_2 410
- grade_1 409
- grade_3 407
- grade_4 403
- kindergarten 402
- grade_5 391
- grade_6 323
- grade_8 273
- grade_7 272
- secondary_spec_ed 272
- grade_11 237
- grade_10 236
- grade_12 236
- grade_9 236
- pre_kindergarten 217
- pre_kindergarten_spec_ed 107
- kindergarten_spec_ed 96
- ged 12
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2241333 | 2241333 | MS | school | 2801560 | 2000 | GEORGE CO SCHOOL DIST | 280156000981 | 2000006 | BENNDALE ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 06 | 2021 | pk_12_total | 98 | 32 | * | * | * | 65 | 73 | 138 | 98 | 32 | 65 | 73 | 138 | |||||||||||||||||||||||||||||||||||||||||
2241630 | 2241630 | MS | school | 2801770 | 2400 | HARRISON CO SCHOOL DIST | 280177000959 | 2400051 | WEST WORTHAM ELEMENTARY AND MIDDLE | Regular School | No | Elementary | KG | 08 | 2021 | pk_12_total | 975 | 76 | 42 | * | * | * | 43 | 574 | 580 | 1154 | 975 | 76 | 42 | 43 | 574 | 580 | 1154 | |||||||||||||||||||||||||||||||||||||
2242562 | 2242562 | MS | school | 2803360 | 3021 | OCEAN SPRINGS SCHOOL DIST | 280336001392 | 3021006 | OCEAN SPRINGS UPPER ELEMENTARY SCHO | Regular School | No | Middle | 04 | 06 | 2021 | pk_12_total | 965 | 173 | 78 | * | 54 | * | 40 | 670 | 645 | 1315 | 965 | 173 | 78 | 54 | 40 | 670 | 645 | 1315 | ||||||||||||||||||||||||||||||||||||
2240335 | 2240335 | MS | school | 2800750 | 614 | CLEVELAND SCHOOL DIST | 280075000084 | 614028 | PARKS ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 06 | 2021 | pk_12_total | 95 | 112 | * | * | 22 | 127 | 111 | 238 | 95 | 112 | 22 | 127 | 111 | 238 | ||||||||||||||||||||||||||||||||||||||||
2240565 | 2240565 | MS | school | 2800990 | 1000 | CHOCTAW CO SCHOOL DIST | 280099000113 | 1000012 | FRENCH CAMP ELEM SCHOOL | Regular School | No | Elementary | PK | 06 | 2021 | pk_12_total | 94 | * | * | 61 | 51 | 112 | 94 | 61 | 51 | 112 | ||||||||||||||||||||||||||||||||||||||||||||
2242407 | 2242407 | MS | school | 2802100 | 2900 | ITAWAMBA CO SCHOOL DIST | 280210000358 | 2900012 | ITAWAMBA ATTENDANCE CENTER | Regular School | No | Elementary | KG | 08 | 2021 | pk_12_total | 935 | 110 | * | * | * | 48 | 562 | 542 | 1104 | 935 | 110 | 48 | 562 | 542 | 1104 | |||||||||||||||||||||||||||||||||||||||
2243827 | 2243827 | MS | school | 2802790 | 4500 | MADISON CO SCHOOL DIST | 280279001081 | 4500024 | ANN SMITH ELEMENTARY | Regular School | No | Elementary | PK | 02 | 2021 | pk_12_total | 93 | 438 | 143 | * | 38 | * | 377 | 356 | 733 | 93 | 438 | 143 | 38 | 377 | 356 | 733 | ||||||||||||||||||||||||||||||||||||||
2244053 | 2244053 | MS | school | 2802850 | 4700 | MARSHALL CO SCHOOL DIST | 280285001268 | 4700023 | H. W. BYERS ELEMENTARY (K-4) | Regular School | No | Elementary | KG | 04 | 2021 | pk_12_total | 93 | 108 | 28 | * | * | 128 | 115 | 243 | 93 | 108 | 28 | 128 | 115 | 243 | ||||||||||||||||||||||||||||||||||||||||
2241444 | 2241444 | MS | school | 2801680 | 2220 | GRENADA SCHOOL DIST | 280168000900 | 2220032 | GRENADA ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 920 | 907 | * | * | * | 46 | 984 | 906 | 1890 | 920 | 907 | 46 | 984 | 906 | 1890 | |||||||||||||||||||||||||||||||||||||||
2245782 | 2245782 | MS | school | 2804440 | 7400 | WALTHALL CO SCHOOL DIST | 280444000836 | 7400016 | TYLERTOWN HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2021 | pk_12_total | 92 | 414 | 13 | * | * | 274 | 254 | 528 | 92 | 414 | 13 | 274 | 254 | 528 | ||||||||||||||||||||||||||||||||||||||||
2241050 | 2241050 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132001569 | 1700052 | DESOTO CENTRAL HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 919 | 728 | 55 | * | 67 | * | 68 | 901 | 940 | 1841 | 919 | 728 | 55 | 67 | 68 | 901 | 940 | 1841 | ||||||||||||||||||||||||||||||||||||
2242865 | 2242865 | MS | school | 2802280 | 3400 | JONES CO SCHOOL DIST | 280228000450 | 3400036 | SOUTH JONES HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2021 | pk_12_total | 914 | 209 | 99 | * | * | 624 | 635 | 1259 | 914 | 209 | 99 | 624 | 635 | 1259 | ||||||||||||||||||||||||||||||||||||||||
2244115 | 2244115 | MS | school | 2802940 | 4800 | MONROE CO SCHOOL DIST | 280294000581 | 4800016 | HATLEY HIGH SCHOOL | Regular School | No | Other | PK | 12 | 2021 | pk_12_total | 914 | 52 | * | * | 11 | 489 | 493 | 982 | 914 | 52 | 11 | 489 | 493 | 982 | ||||||||||||||||||||||||||||||||||||||||
2243962 | 2243962 | MS | school | 2802820 | 4600 | MARION CO SCHOOL DIST | 280282000545 | 4600008 | EAST MARION HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2021 | pk_12_total | 90 | 232 | * | * | 155 | 171 | 326 | 90 | 232 | 155 | 171 | 326 | ||||||||||||||||||||||||||||||||||||||||||
2244416 | 2244416 | MS | school | 2803540 | 5500 | PEARL RIVER CO SCHOOL DIST | 280354001070 | 5500012 | PEARL RIVER CENTRAL HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 897 | 24 | 16 | * | * | 56 | 512 | 486 | 998 | 897 | 24 | 16 | 56 | 512 | 486 | 998 | ||||||||||||||||||||||||||||||||||||||
2241351 | 2241351 | MS | school | 2801560 | 2000 | GEORGE CO SCHOOL DIST | 280156000228 | 2000012 | GEORGE COUNTY HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 890 | 85 | 36 | * | * | 32 | 540 | 513 | 1053 | 890 | 85 | 36 | 32 | 540 | 513 | 1053 | ||||||||||||||||||||||||||||||||||||||
2243100 | 2243100 | MS | school | 2802400 | 3700 | LAMAR COUNTY SCHOOL DISTRICT | 280240001484 | 3700026 | LUMBERTON HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 89 | 66 | * | * | 92 | 72 | 164 | 89 | 66 | 92 | 72 | 164 | ||||||||||||||||||||||||||||||||||||||||||
2240304 | 2240304 | MS | school | 2800750 | 614 | CLEVELAND SCHOOL DIST | 280075001475 | 614007 | CLEVELAND CENTRAL MIDDLE SCHOOL | Regular School | No | Middle | 07 | 08 | 2021 | pk_12_total | 88 | 379 | 16 | * | * | 23 | 252 | 258 | 510 | 88 | 379 | 16 | 23 | 252 | 258 | 510 | ||||||||||||||||||||||||||||||||||||||
2241596 | 2241596 | MS | school | 2801770 | 2400 | HARRISON CO SCHOOL DIST | 280177000296 | 2400044 | PINEVILLE ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 06 | 2021 | pk_12_total | 88 | 13 | * | * | * | * | 68 | 58 | 126 | 88 | 13 | 68 | 58 | 126 | ||||||||||||||||||||||||||||||||||||||||
2241733 | 2241733 | MS | school | 2801710 | 2421 | GULFPORT SCHOOL DIST | 280171000277 | 2421060 | PASS ROAD ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 88 | 345 | 45 | * | * | 38 | 263 | 257 | 520 | 88 | 345 | 45 | 38 | 263 | 257 | 520 | ||||||||||||||||||||||||||||||||||||||
2243326 | 2243326 | MS | school | 2802520 | 4000 | LEAKE CO SCHOOL DIST | 280252001120 | 4000014 | LEAKE COUNTY ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 06 | 2021 | pk_12_total | 88 | 283 | 16 | * | * | * | 195 | 200 | 395 | 88 | 283 | 16 | 195 | 200 | 395 | |||||||||||||||||||||||||||||||||||||||
2244006 | 2244006 | MS | school | 2802850 | 4700 | MARSHALL CO SCHOOL DIST | 280285000548 | 4700004 | BYHALIA HIGH SCHOOL (9-12) | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 88 | 201 | 74 | * | * | 206 | 178 | 384 | 88 | 201 | 74 | 206 | 178 | 384 | ||||||||||||||||||||||||||||||||||||||||
2243385 | 2243385 | MS | school | 2802550 | 4100 | LEE COUNTY SCHOOL DISTRICT | 280255001122 | 4100026 | SHANNON ELEMENTARY SCHOOL | Regular School | No | Elementary | 03 | 05 | 2021 | pk_12_total | 87 | 109 | * | * | 102 | 104 | 206 | 87 | 109 | 102 | 104 | 206 | ||||||||||||||||||||||||||||||||||||||||||
2243401 | 2243401 | MS | school | 2802550 | 4100 | LEE COUNTY SCHOOL DISTRICT | 280255001266 | 4100030 | SHANNON PRIMARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2021 | pk_12_total | 87 | 115 | * | * | 115 | 104 | 219 | 87 | 115 | 115 | 104 | 219 | ||||||||||||||||||||||||||||||||||||||||||
2241479 | 2241479 | MS | school | 2801740 | 2300 | HANCOCK CO SCHOOL DIST | 280174001232 | 2300009 | HANCOCK MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 867 | 85 | 18 | * | * | * | 46 | 520 | 507 | 1027 | 867 | 85 | 18 | 46 | 520 | 507 | 1027 | |||||||||||||||||||||||||||||||||||||
2243430 | 2243430 | MS | school | 2804320 | 4120 | TUPELO PUBLIC SCHOOL DIST | 280432001001 | 4120007 | CARVER ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 01 | 2021 | pk_12_total | 86 | 164 | * | * | 19 | 145 | 142 | 287 | 86 | 164 | 19 | 145 | 142 | 287 | ||||||||||||||||||||||||||||||||||||||||
2243029 | 2243029 | MS | school | 2802400 | 3700 | LAMAR COUNTY SCHOOL DISTRICT | 280240001171 | 3700010 | OAK GROVE HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 855 | 621 | 104 | 59 | * | * | 834 | 867 | 1701 | 855 | 621 | 104 | 59 | 834 | 867 | 1701 | ||||||||||||||||||||||||||||||||||||||
2240929 | 2240929 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132000140 | 1700018 | HERNANDO MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 850 | 126 | 59 | * | * | 59 | 562 | 550 | 1112 | 850 | 126 | 59 | 59 | 562 | 550 | 1112 | ||||||||||||||||||||||||||||||||||||||
2243316 | 2243316 | MS | school | 2802520 | 4000 | LEAKE CO SCHOOL DIST | 280252001119 | 4000006 | LEAKE CENTRAL JUNIOR HIGH | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 85 | 307 | 86 | * | * | * | 252 | 240 | 492 | 85 | 307 | 86 | 252 | 240 | 492 | |||||||||||||||||||||||||||||||||||||||
2246082 | 2246082 | MS | school | 2804530 | 7700 | WAYNE CO SCHOOL DIST | 280453000849 | 7700024 | WAYNE CENTRAL ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 08 | 2021 | pk_12_total | 85 | 333 | * | * | 216 | 208 | 424 | 85 | 333 | 216 | 208 | 424 | ||||||||||||||||||||||||||||||||||||||||||
2241280 | 2241280 | MS | school | 2803530 | 1821 | PETAL SCHOOL DIST | 280353001068 | 1821006 | PETAL HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 836 | 203 | 65 | * | * | 45 | 579 | 588 | 1167 | 836 | 203 | 65 | 45 | 579 | 588 | 1167 | ||||||||||||||||||||||||||||||||||||||
2243662 | 2243662 | MS | school | 2802730 | 4400 | LOWNDES CO SCHOOL DIST | 280273000528 | 4400002 | CALEDONIA ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 832 | 160 | 26 | * | * | 22 | 541 | 501 | 1042 | 832 | 160 | 26 | 22 | 541 | 501 | 1042 | ||||||||||||||||||||||||||||||||||||||
2240657 | 2240657 | MS | school | 2800191 | 1321 | WEST POINT CONSOLIDATED SCHOOL DIST | 280019101449 | 1321016 | SOUTH SIDE ELEMENTARY SCHOOL | Regular School | No | Elementary | 03 | 04 | 2021 | pk_12_total | 82 | 320 | * | * | * | 210 | 205 | 415 | 82 | 320 | 210 | 205 | 415 | |||||||||||||||||||||||||||||||||||||||||
2245868 | 2245868 | MS | school | 2804470 | 7500 | VICKSBURG WARREN SCHOOL DIST | 280447000831 | 7500026 | VICKSBURG JUNIOR HIGH SCHOOL | Regular School | No | Middle | 07 | 08 | 2021 | pk_12_total | 81 | 401 | 12 | * | * | 266 | 240 | 506 | 81 | 401 | 12 | 266 | 240 | 506 | ||||||||||||||||||||||||||||||||||||||||
2243858 | 2243858 | MS | school | 2802790 | 4500 | MADISON CO SCHOOL DIST | 280279001220 | 4500036 | MADISON CENTRAL HIGH SCHOOL | Regular School | No | High | 10 | 12 | 2021 | pk_12_total | 793 | 339 | 17 | 67 | 21 | 625 | 612 | 1237 | 793 | 339 | 17 | 67 | 21 | 625 | 612 | 1237 | ||||||||||||||||||||||||||||||||||||||
2242883 | 2242883 | MS | school | 2802280 | 3400 | JONES CO SCHOOL DIST | 280228000451 | 3400052 | WEST JONES HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2021 | pk_12_total | 791 | 362 | 276 | * | * | 40 | 750 | 737 | 1487 | 791 | 362 | 276 | 40 | 750 | 737 | 1487 | ||||||||||||||||||||||||||||||||||||||
2243390 | 2243390 | MS | school | 2802550 | 4100 | LEE COUNTY SCHOOL DISTRICT | 280255001325 | 4100027 | SHANNON MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 79 | 146 | * | * | 115 | 131 | 246 | 79 | 146 | 115 | 131 | 246 | ||||||||||||||||||||||||||||||||||||||||||
2244848 | 2244848 | MS | school | 2803830 | 6100 | RANKIN CO SCHOOL DIST | 280383000737 | 6100016 | BRANDON MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 784 | 430 | 12 | 15 | 36 | 671 | 606 | 1277 | 784 | 430 | 12 | 15 | 36 | 671 | 606 | 1277 | ||||||||||||||||||||||||||||||||||||||
2242476 | 2242476 | MS | school | 2802160 | 3000 | JACKSON CO SCHOOL DIST | 280216001046 | 3000011 | ST MARTIN HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 783 | 263 | 65 | * | 115 | * | 15 | 653 | 596 | 1249 | 783 | 263 | 65 | 115 | 15 | 653 | 596 | 1249 | ||||||||||||||||||||||||||||||||||||
2243380 | 2243380 | MS | school | 2802550 | 4100 | LEE COUNTY SCHOOL DISTRICT | 280255000496 | 4100024 | SALTILLO HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 782 | 107 | * | * | 17 | 464 | 464 | 928 | 782 | 107 | 17 | 464 | 464 | 928 | ||||||||||||||||||||||||||||||||||||||||
2243891 | 2243891 | MS | school | 2802790 | 4500 | MADISON CO SCHOOL DIST | 280279001381 | 4500066 | GERMANTOWN HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 781 | 448 | 24 | * | 26 | * | 667 | 622 | 1289 | 781 | 448 | 24 | 26 | 667 | 622 | 1289 | ||||||||||||||||||||||||||||||||||||||
2244202 | 2244202 | MS | school | 2803060 | 5000 | NESHOBA COUNTY SCHOOL DISTRICT | 280306000611 | 5000004 | NESHOBA CENTRAL ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 781 | 231 | * | 79 | * | 124 | 630 | 601 | 1231 | 781 | 231 | 79 | 124 | 630 | 601 | 1231 | ||||||||||||||||||||||||||||||||||||||
2243095 | 2243095 | MS | school | 2802400 | 3700 | LAMAR COUNTY SCHOOL DISTRICT | 280240001507 | 3700025 | LUMBERTON MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 78 | 49 | * | * | * | 74 | 62 | 136 | 78 | 49 | 74 | 62 | 136 | |||||||||||||||||||||||||||||||||||||||||
2243236 | 2243236 | MS | school | 2802910 | 3820 | MERIDIAN PUBLIC SCHOOL DIST | 280291000572 | 3820056 | POPLAR SPRINGS ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 77 | 337 | 20 | * | * | 259 | 188 | 447 | 77 | 337 | 20 | 259 | 188 | 447 | ||||||||||||||||||||||||||||||||||||||||
2241090 | 2241090 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132001343 | 1700064 | LEWISBURG MIDDLE | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 768 | 81 | 25 | * | * | 31 | 463 | 465 | 928 | 768 | 81 | 25 | 31 | 463 | 465 | 928 | ||||||||||||||||||||||||||||||||||||||
2245660 | 2245660 | MS | school | 2804350 | 7300 | UNION CO SCHOOL DIST | 280435000821 | 7300004 | EAST UNION ATTENDANCE CENTER | Regular School | No | Other | PK | 12 | 2021 | pk_12_total | 768 | 55 | * | * | 22 | 458 | 412 | 870 | 768 | 55 | 22 | 458 | 412 | 870 | ||||||||||||||||||||||||||||||||||||||||
2241540 | 2241540 | MS | school | 2801770 | 2400 | HARRISON CO SCHOOL DIST | 280177000285 | 2400008 | DIBERVILLE SENIOR HIGH SCH | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 763 | 292 | 87 | * | 89 | * | 46 | 688 | 596 | 1284 | 763 | 292 | 87 | 89 | 46 | 688 | 596 | 1284 | ||||||||||||||||||||||||||||||||||||
2243481 | 2243481 | MS | school | 2804320 | 4120 | TUPELO PUBLIC SCHOOL DIST | 280432000819 | 4120040 | TUPELO HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 761 | 921 | 134 | * | * | 78 | 969 | 968 | 1937 | 761 | 921 | 134 | 78 | 969 | 968 | 1937 | ||||||||||||||||||||||||||||||||||||||
2241535 | 2241535 | MS | school | 2801770 | 2400 | HARRISON CO SCHOOL DIST | 280177001351 | 2400005 | CROSSROADS ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 06 | 2021 | pk_12_total | 76 | 397 | 45 | * | * | 30 | 286 | 269 | 555 | 76 | 397 | 45 | 30 | 286 | 269 | 555 | ||||||||||||||||||||||||||||||||||||||
2242773 | 2242773 | MS | school | 2802250 | 3300 | JEFFERSON DAVIS CO SCHOOL DIST | 280225000430 | 3300004 | CARVER ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 08 | 2021 | pk_12_total | 76 | 313 | * | * | 199 | 198 | 397 | 76 | 313 | 199 | 198 | 397 | ||||||||||||||||||||||||||||||||||||||||||
2241653 | 2241653 | MS | school | 2800630 | 2420 | BILOXI PUBLIC SCHOOL DIST | 280063000053 | 2420008 | BILOXI HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 757 | 590 | 231 | * | 82 | * | 75 | 822 | 920 | 1742 | 757 | 590 | 231 | 82 | 75 | 822 | 920 | 1742 | ||||||||||||||||||||||||||||||||||||
2243068 | 2243068 | MS | school | 2802400 | 3700 | LAMAR COUNTY SCHOOL DISTRICT | 280240000969 | 3700019 | SUMRALL ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 757 | 70 | * | * | 33 | 445 | 431 | 876 | 757 | 70 | 33 | 445 | 431 | 876 | ||||||||||||||||||||||||||||||||||||||||
2243841 | 2243841 | MS | school | 2802790 | 4500 | MADISON CO SCHOOL DIST | 280279001082 | 4500028 | MADISON MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 756 | 343 | 30 | 86 | 26 | 626 | 615 | 1241 | 756 | 343 | 30 | 86 | 26 | 626 | 615 | 1241 | ||||||||||||||||||||||||||||||||||||||
2244410 | 2244410 | MS | school | 2803540 | 5500 | PEARL RIVER CO SCHOOL DIST | 280354001069 | 5500008 | PEARL RIVER CENTRAL JUNIOR HIGH | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 746 | 26 | 12 | * | * | 39 | 462 | 369 | 831 | 746 | 26 | 12 | 39 | 462 | 369 | 831 | ||||||||||||||||||||||||||||||||||||||
2240987 | 2240987 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132001191 | 1700036 | SHADOW OAKS ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 02 | 2021 | pk_12_total | 74 | 289 | * | * | * | 52 | 204 | 222 | 426 | 74 | 289 | 52 | 204 | 222 | 426 | |||||||||||||||||||||||||||||||||||||||
2242549 | 2242549 | MS | school | 2803000 | 3020 | MOSS POINT SEPARATE SCHOOL DIST | 280300000592 | 3020028 | MAGNOLIA MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 74 | 302 | * | * | 206 | 200 | 406 | 74 | 302 | 206 | 200 | 406 | ||||||||||||||||||||||||||||||||||||||||||
2241584 | 2241584 | MS | school | 2801770 | 2400 | HARRISON CO SCHOOL DIST | 280177000958 | 2400038 | NORTH WOOLMARKET ELEMENTARY AND MID | Regular School | No | Elementary | KG | 08 | 2021 | pk_12_total | 739 | 90 | 54 | * | * | * | 42 | 460 | 479 | 939 | 739 | 90 | 54 | 42 | 460 | 479 | 939 | |||||||||||||||||||||||||||||||||||||
2242579 | 2242579 | MS | school | 2803360 | 3021 | OCEAN SPRINGS SCHOOL DIST | 280336000934 | 3021022 | OCEAN SPRINGS MIDDLE SCHOOL | Regular School | No | Middle | 07 | 08 | 2021 | pk_12_total | 736 | 119 | 64 | * | 36 | * | 25 | 563 | 427 | 990 | 736 | 119 | 64 | 36 | 25 | 563 | 427 | 990 | ||||||||||||||||||||||||||||||||||||
2241725 | 2241725 | MS | school | 2801710 | 2421 | GULFPORT SCHOOL DIST | 280171000276 | 2421040 | GULFPORT HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 734 | 875 | 96 | * | 26 | * | 27 | 861 | 904 | 1765 | 734 | 875 | 96 | 26 | 27 | 861 | 904 | 1765 | ||||||||||||||||||||||||||||||||||||
2242461 | 2242461 | MS | school | 2802160 | 3000 | JACKSON CO SCHOOL DIST | 280216001045 | 3000006 | EAST CENTRAL HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 731 | 28 | * | * | * | * | * | 393 | 382 | 775 | 731 | 28 | 393 | 382 | 775 | |||||||||||||||||||||||||||||||||||||||
2241269 | 2241269 | MS | school | 2803530 | 1821 | PETAL SCHOOL DIST | 280353001067 | 1821002 | PETAL PRIMARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2021 | pk_12_total | 724 | 152 | 47 | * | * | * | 69 | 533 | 465 | 998 | 724 | 152 | 47 | 69 | 533 | 465 | 998 | |||||||||||||||||||||||||||||||||||||
2242986 | 2242986 | MS | school | 2803450 | 3620 | OXFORD SCHOOL DISTRICT | 280345000663 | 3620012 | OXFORD HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 724 | 398 | 60 | * | * | 43 | 670 | 597 | 1267 | 724 | 398 | 60 | 43 | 670 | 597 | 1267 | ||||||||||||||||||||||||||||||||||||||
2242103 | 2242103 | MS | school | 2802190 | 2520 | JACKSON PUBLIC SCHOOL DIST | 280219001242 | 2520057 | MCWILLIE ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 06 | 2021 | pk_12_total | 72 | 218 | * | * | * | 147 | 157 | 304 | 72 | 218 | 147 | 157 | 304 | |||||||||||||||||||||||||||||||||||||||||
2241742 | 2241742 | MS | school | 2801710 | 2421 | GULFPORT SCHOOL DIST | 280171000279 | 2421064 | WEST ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 71 | 443 | 38 | * | * | * | 22 | 290 | 291 | 581 | 71 | 443 | 38 | 22 | 290 | 291 | 581 | |||||||||||||||||||||||||||||||||||||
2242599 | 2242599 | MS | school | 2803480 | 3022 | PASCAGOULA GAUTIER SCHOOL DIST | 280348000667 | 3022008 | BEACH ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 04 | 2021 | pk_12_total | 71 | 16 | * | * | 54 | 44 | 98 | 71 | 16 | 54 | 44 | 98 | ||||||||||||||||||||||||||||||||||||||||||
2245567 | 2245567 | MS | school | 2804260 | 7100 | TISHOMINGO CO SP MUN SCH DIST | 280426000803 | 7100004 | BELMONT SCHOOL | Regular School | No | Other | KG | 12 | 2021 | pk_12_total | 703 | * | 83 | * | 15 | 424 | 390 | 814 | 703 | 83 | 15 | 424 | 390 | 814 | ||||||||||||||||||||||||||||||||||||||||
2241154 | 2241154 | MS | school | 2801490 | 1800 | FORREST COUNTY SCHOOL DISTRICT | 280149000217 | 1800010 | NORTH FORREST ATTENDANCE CENTER | Regular School | No | Elementary | KG | 06 | 2021 | pk_12_total | 70 | 142 | * | * | 21 | 127 | 113 | 240 | 70 | 142 | 21 | 127 | 113 | 240 | ||||||||||||||||||||||||||||||||||||||||
2243820 | 2243820 | MS | school | 2802790 | 4500 | MADISON CO SCHOOL DIST | 280279001283 | 4500022 | GERMANTOWN MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 699 | 321 | * | * | 24 | 16 | 570 | 507 | 1077 | 699 | 321 | 24 | 16 | 570 | 507 | 1077 | ||||||||||||||||||||||||||||||||||||||
2240807 | 2240807 | MS | school | 2801220 | 1500 | COPIAH CO SCHOOL DIST | 280122000169 | 1500012 | WESSON ATTENDANCE CENTER | Regular School | No | Other | KG | 12 | 2021 | pk_12_total | 692 | 143 | 32 | * | * | 448 | 441 | 889 | 692 | 143 | 32 | 448 | 441 | 889 | ||||||||||||||||||||||||||||||||||||||||
2243836 | 2243836 | MS | school | 2802790 | 4500 | MADISON CO SCHOOL DIST | 280279000304 | 4500026 | MADISON STATION ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 690 | 142 | 11 | * | 106 | * | 24 | 503 | 476 | 979 | 690 | 142 | 11 | 106 | 24 | 503 | 476 | 979 | ||||||||||||||||||||||||||||||||||||
2240047 | 2240047 | MS | school | 2803030 | 130 | NATCHEZ-ADAMS SCHOOL DIST | 280303000600 | 130020 | MC LAURIN ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 69 | 460 | * | * | * | 263 | 284 | 547 | 69 | 460 | 263 | 284 | 547 | |||||||||||||||||||||||||||||||||||||||||
2240835 | 2240835 | MS | school | 2801290 | 1600 | COVINGTON CO SCHOOLS | 280129000176 | 1600004 | COLLINS ELEMENTARY | Regular School | No | Elementary | KG | 04 | 2021 | pk_12_total | 69 | 213 | 27 | * | * | 22 | 168 | 166 | 334 | 69 | 213 | 27 | 22 | 168 | 166 | 334 | ||||||||||||||||||||||||||||||||||||||
2242533 | 2242533 | MS | school | 2803000 | 3020 | MOSS POINT SEPARATE SCHOOL DIST | 280300000587 | 3020004 | MOSS POINT HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 69 | 374 | 20 | * | * | 11 | 240 | 236 | 476 | 69 | 374 | 20 | 11 | 240 | 236 | 476 | ||||||||||||||||||||||||||||||||||||||
2242833 | 2242833 | MS | school | 2802280 | 3400 | JONES CO SCHOOL DIST | 280228000443 | 3400024 | NORTHEAST JONES HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2021 | pk_12_total | 685 | 190 | 40 | 31 | * | * | 500 | 469 | 969 | 685 | 190 | 40 | 31 | 500 | 469 | 969 | ||||||||||||||||||||||||||||||||||||||
2241719 | 2241719 | MS | school | 2801710 | 2421 | GULFPORT SCHOOL DIST | 280171000272 | 2421016 | GULFPORT CENTRAL MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 68 | 505 | 33 | * | * | 17 | 342 | 291 | 633 | 68 | 505 | 33 | 17 | 342 | 291 | 633 | ||||||||||||||||||||||||||||||||||||||
2241853 | 2241853 | MS | school | 2801860 | 2500 | HINDS CO SCHOOL DIST | 280186000902 | 2500030 | TERRY HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 68 | 1143 | * | * | * | 621 | 606 | 1227 | 68 | 1143 | 621 | 606 | 1227 | |||||||||||||||||||||||||||||||||||||||||
2245768 | 2245768 | MS | school | 2804440 | 7400 | WALTHALL CO SCHOOL DIST | 280444001148 | 7400010 | TYLERTOWN PRIMARY SCHOOL | Regular School | No | Elementary | PK | 03 | 2021 | pk_12_total | 68 | 275 | * | * | 13 | 181 | 186 | 367 | 68 | 275 | 13 | 181 | 186 | 367 | ||||||||||||||||||||||||||||||||||||||||
2242857 | 2242857 | MS | school | 2802280 | 3400 | JONES CO SCHOOL DIST | 280228000986 | 3400034 | SOUTH JONES ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 06 | 2021 | pk_12_total | 672 | 194 | 80 | * | * | 498 | 496 | 994 | 672 | 194 | 80 | 498 | 496 | 994 | ||||||||||||||||||||||||||||||||||||||||
2240642 | 2240642 | MS | school | 2800191 | 1321 | WEST POINT CONSOLIDATED SCHOOL DIST | 280019101455 | 1321006 | CHURCH HILL ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 02 | 2021 | pk_12_total | 67 | 287 | * | * | * | 200 | 164 | 364 | 67 | 287 | 200 | 164 | 364 | |||||||||||||||||||||||||||||||||||||||||
2241055 | 2241055 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132000979 | 1700054 | DESOTO CENTRAL MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 664 | 565 | * | * | 55 | 89 | 711 | 708 | 1419 | 664 | 565 | 55 | 89 | 711 | 708 | 1419 | ||||||||||||||||||||||||||||||||||||||
2241071 | 2241071 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132001275 | 1700060 | LEWISBURG ELEMENTARY SCHOOL | Regular School | No | Elementary | 03 | 05 | 2021 | pk_12_total | 657 | 64 | 14 | * | * | 59 | 388 | 420 | 808 | 657 | 64 | 14 | 59 | 388 | 420 | 808 | ||||||||||||||||||||||||||||||||||||||
2241079 | 2241079 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132001373 | 1700061 | LEWISBURG PRIMARY | Regular School | No | Elementary | PK | 02 | 2021 | pk_12_total | 657 | 55 | * | * | 58 | 403 | 385 | 788 | 657 | 55 | 58 | 403 | 385 | 788 | ||||||||||||||||||||||||||||||||||||||||
2241771 | 2241771 | MS | school | 2802670 | 2422 | LONG BEACH SCHOOL DIST | 280267000520 | 2422016 | LONG BEACH SENIOR HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 653 | 130 | 25 | * | 25 | * | 59 | 445 | 450 | 895 | 653 | 130 | 25 | 25 | 59 | 445 | 450 | 895 | ||||||||||||||||||||||||||||||||||||
2242506 | 2242506 | MS | school | 2802160 | 3000 | JACKSON CO SCHOOL DIST | 280216001050 | 3000020 | VANCLEAVE HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 649 | 29 | 26 | * | * | * | * | 361 | 357 | 718 | 649 | 29 | 26 | 361 | 357 | 718 | ||||||||||||||||||||||||||||||||||||||
2245534 | 2245534 | MS | school | 2804110 | 7012 | SOUTH TIPPAH SCHOOL DIST | 280411000776 | 7012008 | PINE GROVE HIGH SCHOOL | Regular School | No | Other | PK | 12 | 2021 | pk_12_total | 643 | * | * | * | * | 349 | 312 | 661 | 643 | 349 | 312 | 661 | ||||||||||||||||||||||||||||||||||||||||||
2245211 | 2245211 | MS | school | 2804020 | 6500 | SMITH CO SCHOOL DIST | 280402000758 | 6500004 | MIZE ATTENDANCE CENTER | Regular School | No | Other | PK | 12 | 2021 | pk_12_total | 640 | 95 | * | * | 18 | 391 | 367 | 758 | 640 | 95 | 18 | 391 | 367 | 758 | ||||||||||||||||||||||||||||||||||||||||
2241643 | 2241643 | MS | school | 2801770 | 2400 | HARRISON CO SCHOOL DIST | 280177001347 | 2400055 | WEST HARRISON HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 638 | 323 | 30 | * | 12 | * | 35 | 521 | 524 | 1045 | 638 | 323 | 30 | 12 | 35 | 521 | 524 | 1045 | ||||||||||||||||||||||||||||||||||||
2243074 | 2243074 | MS | school | 2802400 | 3700 | LAMAR COUNTY SCHOOL DISTRICT | 280240001253 | 3700021 | OAK GROVE MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 636 | 598 | 101 | * | * | 67 | 719 | 725 | 1444 | 636 | 598 | 101 | 67 | 719 | 725 | 1444 | ||||||||||||||||||||||||||||||||||||||
2244249 | 2244249 | MS | school | 2803150 | 5100 | NEWTON COUNTY SCHOOL DISTRICT | 280315001135 | 5100012 | NEWTON COUNTY HIGH SCHOOL | Regular School | No | High | 06 | 12 | 2021 | pk_12_total | 634 | 205 | 27 | 49 | * | * | 440 | 481 | 921 | 634 | 205 | 27 | 49 | 440 | 481 | 921 | ||||||||||||||||||||||||||||||||||||||
2242519 | 2242519 | MS | school | 2802160 | 3000 | JACKSON CO SCHOOL DIST | 280216000963 | 3000024 | ST. MARTIN MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 628 | 223 | * | * | 58 | 48 | 548 | 458 | 1006 | 628 | 223 | 58 | 48 | 548 | 458 | 1006 | ||||||||||||||||||||||||||||||||||||||
2245712 | 2245712 | MS | school | 2804350 | 7300 | UNION CO SCHOOL DIST | 280435000824 | 7300016 | WEST UNION ATTENDANCE CENTER | Regular School | No | Other | PK | 12 | 2021 | pk_12_total | 627 | * | 12 | * | 338 | 317 | 655 | 627 | 12 | 338 | 317 | 655 | ||||||||||||||||||||||||||||||||||||||||||
2244869 | 2244869 | MS | school | 2803830 | 6100 | RANKIN CO SCHOOL DIST | 280383001075 | 6100022 | FLORENCE HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 621 | 94 | * | * | * | 11 | 379 | 359 | 738 | 621 | 94 | 11 | 379 | 359 | 738 | |||||||||||||||||||||||||||||||||||||||
2244892 | 2244892 | MS | school | 2803830 | 6100 | RANKIN CO SCHOOL DIST | 280383000955 | 6100026 | NORTHWEST RANKIN MIDDLE SCHOOL | Regular School | No | Middle | 07 | 08 | 2021 | pk_12_total | 615 | 294 | 31 | * | 29 | * | 36 | 518 | 490 | 1008 | 615 | 294 | 31 | 29 | 36 | 518 | 490 | 1008 | ||||||||||||||||||||||||||||||||||||
2241714 | 2241714 | MS | school | 2801710 | 2421 | GULFPORT SCHOOL DIST | 280171000271 | 2421014 | CENTRAL ELEM | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 61 | 240 | 44 | * | * | * | 192 | 165 | 357 | 61 | 240 | 44 | 192 | 165 | 357 | |||||||||||||||||||||||||||||||||||||||
2243868 | 2243868 | MS | school | 2802790 | 4500 | MADISON CO SCHOOL DIST | 280279000938 | 4500040 | OLD TOWN MIDDLE | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 61 | 527 | 107 | 32 | 24 | 393 | 358 | 751 | 61 | 527 | 107 | 32 | 24 | 393 | 358 | 751 | ||||||||||||||||||||||||||||||||||||||
2244232 | 2244232 | MS | school | 2803600 | 5020 | PHILADELPHIA PUBLIC SCHOOL DIST | 280360000692 | 5020008 | PHILADELPHIA HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2021 | pk_12_total | 61 | 320 | * | * | * | 199 | 196 | 395 | 61 | 320 | 199 | 196 | 395 | |||||||||||||||||||||||||||||||||||||||||
2245119 | 2245119 | MS | school | 2801470 | 6220 | FOREST MUNICIPAL SCHOOL DIST | 280147000212 | 6220004 | FOREST ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 04 | 2021 | pk_12_total | 61 | 287 | 316 | * | * | 375 | 323 | 698 | 61 | 287 | 316 | 375 | 323 | 698 | ||||||||||||||||||||||||||||||||||||||||
2245132 | 2245132 | MS | school | 2801470 | 6220 | FOREST MUNICIPAL SCHOOL DIST | 280147000214 | 6220012 | HAWKINS MIDDLE SCHOOL | Regular School | No | Middle | 05 | 08 | 2021 | pk_12_total | 61 | 220 | 195 | * | * | 29 | 265 | 244 | 509 | 61 | 220 | 195 | 29 | 265 | 244 | 509 | ||||||||||||||||||||||||||||||||||||||
2245360 | 2245360 | MS | school | 2801410 | 6811 | EAST TALLAHATCHIE CONSOL SCH DIST | 280141000206 | 6811004 | CHARLESTON ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 04 | 2021 | pk_12_total | 61 | 306 | * | * | 195 | 191 | 386 | 61 | 306 | 195 | 191 | 386 | ||||||||||||||||||||||||||||||||||||||||||
2244213 | 2244213 | MS | school | 2803060 | 5000 | NESHOBA COUNTY SCHOOL DISTRICT | 280306000612 | 5000008 | NESHOBA CENTRAL HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 609 | 164 | * | 131 | * | 62 | 476 | 502 | 978 | 609 | 164 | 131 | 62 | 476 | 502 | 978 |
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]);