enrollments
Data source: Big Local News · About: Big Local
1,763 rows where grade = "pk_12_total" and state = "MS" sorted by total
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2242919 | 2242919 | MS | school | 2801192 | 3475 | ELLISVILLE STATE SCHOOL ADM | 280119201198 | 3475004 | ELLISVILLE STATE SCHOOL | Regular School | No | Ungraded | UG | UG | 2021 | pk_12_total | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||||||
2036091 | 2036091 | MS | school | 2803480 | 3022 | PASCAGOULA GAUTIER SCHOOL DIST | 280348000667 | 3022008 | BEACH ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 04 | 2020 | pk_12_total | 61 | 24 | * | * | 49.0 | 51.0 | 100 | 61 | 24 | 49 | 51 | 100 | ||||||||||||||||||||||||||||||||||||||||||
2037525 | 2037525 | MS | school | 2802850 | 4700 | MARSHALL CO SCHOOL DIST | 280285000549 | 4700008 | GALENA ELEMENTARY SCHOOL (K-6) | Regular School | No | Elementary | KG | 06 | 2020 | pk_12_total | * | 87 | * | * | 48.0 | 52.0 | 100 | 87 | 48 | 52 | 100 | |||||||||||||||||||||||||||||||||||||||||||
2243629 | 2243629 | MS | school | 2800031 | 4306 | MS SCHOOL FOR THE ARTS | 280003101574 | 4306004 | MS SCHOOL FOR THE ARTS | Regular School | No | High | 11 | 12 | 2021 | pk_12_total | 55 | 38 | * | * | 20 | 80 | 100 | 55 | 38 | 20 | 80 | 100 | ||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
2035123 | 2035123 | MS | school | 2800630 | 2420 | BILOXI PUBLIC SCHOOL DIST | 280063001107 | 2420006 | BILOXI JUNIOR HIGH | Regular School | No | Middle | 07 | 08 | 2020 | pk_12_total | 430 | 347 | 160 | * | 32 | * | 41 | 522.0 | 493.0 | 1015 | 430 | 347 | 160 | 32 | 41 | 522 | 493 | 1015 | ||||||||||||||||||||||||||||||||||||
2034574 | 2034574 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132001289 | 1700072 | CENTER HILL HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 503 | 398 | 64 | * | 17 | * | 33 | 514.0 | 503.0 | 1017 | 503 | 398 | 64 | 17 | 33 | 514 | 503 | 1017 | ||||||||||||||||||||||||||||||||||||
2035133 | 2035133 | MS | school | 2800630 | 2420 | BILOXI PUBLIC SCHOOL DIST | 280063001478 | 2420010 | BILOXI UPPER ELEMENTARY | Regular School | No | Middle | 05 | 06 | 2020 | pk_12_total | 397 | 346 | 181 | * | 32 | * | 56 | 516.0 | 502.0 | 1018 | 397 | 346 | 181 | 32 | 56 | 516 | 502 | 1018 | ||||||||||||||||||||||||||||||||||||
2034737 | 2034737 | MS | school | 2803530 | 1821 | PETAL SCHOOL DIST | 280353001067 | 1821002 | PETAL PRIMARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2020 | pk_12_total | 769 | 151 | 42 | * | * | * | 51 | 535.0 | 486.0 | 1021 | 769 | 151 | 42 | 51 | 535 | 486 | 1021 | |||||||||||||||||||||||||||||||||||||
2034138 | 2034138 | MS | school | 2800191 | 1321 | WEST POINT CONSOLIDATED SCHOOL DIST | 280019101441 | 1321020 | WEST POINT HIGH SCHOOL | Regular School | No | High | 08 | 12 | 2020 | pk_12_total | 177 | 832 | 11 | * | * | 512.0 | 515.0 | 1027 | 177 | 832 | 11 | 512 | 515 | 1027 | ||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||
2035895 | 2035895 | MS | school | 2802100 | 2900 | ITAWAMBA CO SCHOOL DIST | 280210000358 | 2900012 | ITAWAMBA ATTENDANCE CENTER | Regular School | No | Elementary | KG | 08 | 2020 | pk_12_total | 877 | 91 | * | * | * | 47 | 543.0 | 485.0 | 1028 | 877 | 91 | 47 | 543 | 485 | 1028 | |||||||||||||||||||||||||||||||||||||||
2036323 | 2036323 | MS | school | 2802280 | 3400 | JONES CO SCHOOL DIST | 280228000443 | 3400024 | NORTHEAST JONES HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2020 | pk_12_total | 737 | 199 | 39 | 33 | * | * | 540.0 | 488.0 | 1028 | 737 | 199 | 39 | 33 | 540 | 488 | 1028 | ||||||||||||||||||||||||||||||||||||||
2037927 | 2037927 | MS | school | 2803540 | 5500 | PEARL RIVER CO SCHOOL DIST | 280354001070 | 5500012 | PEARL RIVER CENTRAL HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 913 | 36 | * | * | 54 | 558.0 | 471.0 | 1029 | 913 | 36 | 54 | 558 | 471 | 1029 | ||||||||||||||||||||||||||||||||||||||||
2245287 | 2245287 | MS | school | 2800187 | 6711 | SUNFLOWER CO CONSOLIDATE SCH DIST | 280018701418 | 6711008 | EAST SUNFLOWER SCHOOL | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 11 | 83 | * | * | 55 | 48 | 103 | 11 | 83 | 55 | 48 | 103 | ||||||||||||||||||||||||||||||||||||||||||
2035444 | 2035444 | MS | school | 2802190 | 2520 | JACKSON PUBLIC SCHOOL DIST | 280219000384 | 2520031 | FOREST HILL HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | * | 1005 | 12 | * | 506.0 | 524.0 | 1030 | 1005 | 12 | 506 | 524 | 1030 | ||||||||||||||||||||||||||||||||||||||||||
2034897 | 2034897 | MS | school | 2801680 | 2220 | GRENADA SCHOOL DIST | 280168000262 | 2220004 | GRENADA HIGH | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 491 | 505 | 10 | * | * | 23 | 502.0 | 532.0 | 1034 | 491 | 505 | 10 | 23 | 502 | 532 | 1034 | ||||||||||||||||||||||||||||||||||||||
2243797 | 2243797 | MS | school | 2802790 | 4500 | MADISON CO SCHOOL DIST | 280279000988 | 4500010 | CAMDEN ELEMENTARY | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | * | * | 47 | 57 | 104 | 47 | 57 | 104 | ||||||||||||||||||||||||||||||||||||||||||||||
2037343 | 2037343 | MS | school | 2802790 | 4500 | MADISON CO SCHOOL DIST | 280279000304 | 4500026 | MADISON STATION ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 727 | 154 | 22 | * | 117 | * | 526.0 | 515.0 | 1041 | 727 | 154 | 22 | 117 | 526 | 515 | 1041 | ||||||||||||||||||||||||||||||||||||||
2034430 | 2034430 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132000945 | 1700028 | HORN LAKE INTERMEDIATE SCHOOL | Regular School | No | Elementary | 03 | 05 | 2020 | pk_12_total | 179 | 698 | 52 | * | * | 105 | 542.0 | 500.0 | 1042 | 179 | 698 | 52 | 105 | 542 | 500 | 1042 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
2034396 | 2034396 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132000140 | 1700018 | HERNANDO MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 806 | 127 | 67 | * | 14 | * | 27 | 539.0 | 505.0 | 1044 | 806 | 127 | 67 | 14 | 27 | 539 | 505 | 1044 | ||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
2242423 | 2242423 | MS | school | 2802100 | 2900 | ITAWAMBA CO SCHOOL DIST | 280210000361 | 2900024 | MANTACHIE ATTENDANCE CENTER | Regular School | No | Other | KG | 12 | 2021 | pk_12_total | 1033 | * | * | * | * | 545 | 501 | 1046 | 1033 | 545 | 501 | 1046 | ||||||||||||||||||||||||||||||||||||||||||
2034818 | 2034818 | MS | school | 2801560 | 2000 | GEORGE CO SCHOOL DIST | 280156000228 | 2000012 | GEORGE COUNTY HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 900 | 79 | 34 | * | * | 32 | 548.0 | 505.0 | 1053 | 900 | 79 | 34 | 32 | 548 | 505 | 1053 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
2241027 | 2241027 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132001336 | 1700047 | SOUTHAVEN INTERMEDIATE SCHOOL | Regular School | No | Elementary | 03 | 05 | 2021 | pk_12_total | 288 | 522 | 82 | * | 17 | * | 140 | 595 | 460 | 1055 | 288 | 522 | 82 | 17 | 140 | 595 | 460 | 1055 | ||||||||||||||||||||||||||||||||||||
2035912 | 2035912 | MS | school | 2802100 | 2900 | ITAWAMBA CO SCHOOL DIST | 280210000361 | 2900024 | MANTACHIE ATTENDANCE CENTER | Regular School | No | Other | KG | 12 | 2020 | pk_12_total | 1039 | * | * | * | * | 571.0 | 485.0 | 1056 | 1039 | 571 | 485 | 1056 | ||||||||||||||||||||||||||||||||||||||||||
2245035 | 2245035 | MS | school | 2803520 | 6120 | PEARL PUBLIC SCHOOL DIST | 280352001354 | 6120016 | PEARL JUNIOR HIGH SCHOOL | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 495 | 410 | 85 | * | 13 | * | 52 | 536 | 522 | 1058 | 495 | 410 | 85 | 13 | 52 | 536 | 522 | 1058 | ||||||||||||||||||||||||||||||||||||
2241106 | 2241106 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132001289 | 1700072 | CENTER HILL HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 498 | 432 | 62 | * | * | 46 | 521 | 538 | 1059 | 498 | 432 | 62 | 46 | 521 | 538 | 1059 | ||||||||||||||||||||||||||||||||||||||
2240667 | 2240667 | MS | school | 2800191 | 1321 | WEST POINT CONSOLIDATED SCHOOL DIST | 280019101447 | 1321018 | WEST CLAY ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 06 | 2021 | pk_12_total | * | 86 | * | 56 | 50 | 106 | 86 | 56 | 50 | 106 | ||||||||||||||||||||||||||||||||||||||||||||
2037833 | 2037833 | MS | school | 2800189 | 5321 | STARKVILLE- OKTIBBEHA CONS SD | 280018901438 | 5321007 | HENDERSON/WARD-STEWART ELEMENTARY | Regular School | No | Elementary | 02 | 04 | 2020 | pk_12_total | 315 | 678 | 13 | * | 53 | * | 561.0 | 501.0 | 1062 | 315 | 678 | 13 | 53 | 561 | 501 | 1062 | ||||||||||||||||||||||||||||||||||||||
2036170 | 2036170 | MS | school | 2803480 | 3022 | PASCAGOULA GAUTIER SCHOOL DIST | 280348000678 | 3022052 | PASCAGOULA HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 327 | 488 | 225 | * | 14 | * | 510.0 | 553.0 | 1063 | 327 | 488 | 225 | 14 | 510 | 553 | 1063 | ||||||||||||||||||||||||||||||||||||||
2036985 | 2036985 | MS | school | 2804320 | 4120 | TUPELO PUBLIC SCHOOL DIST | 280432000293 | 4120042 | TUPELO MIDDLE SCHOOL | Regular School | No | Middle | 07 | 08 | 2020 | pk_12_total | 355 | 546 | 90 | * | * | 43 | 551.0 | 512.0 | 1063 | 355 | 546 | 90 | 43 | 551 | 512 | 1063 | ||||||||||||||||||||||||||||||||||||||
2244330 | 2244330 | MS | school | 2800189 | 5321 | STARKVILLE- OKTIBBEHA CONS SD | 280018901451 | 5321016 | STARKVILLE HIGH SCHOOL | Regular School | No | High | 10 | 12 | 2021 | pk_12_total | 334 | 686 | 12 | * | 30 | * | 532 | 532 | 1064 | 334 | 686 | 12 | 30 | 532 | 532 | 1064 | ||||||||||||||||||||||||||||||||||||||
2036157 | 2036157 | MS | school | 2803480 | 3022 | PASCAGOULA GAUTIER SCHOOL DIST | 280348000677 | 3022048 | LAKE ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 04 | 2020 | pk_12_total | 41 | 37 | 20 | * | * | 58.0 | 49.0 | 107 | 41 | 37 | 20 | 58 | 49 | 107 | ||||||||||||||||||||||||||||||||||||||||
2243691 | 2243691 | MS | school | 2802730 | 4400 | LOWNDES CO SCHOOL DIST | 280273000532 | 4400014 | NEW HOPE ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 606 | 440 | * | * | * | 12 | 558 | 513 | 1071 | 606 | 440 | 12 | 558 | 513 | 1071 | |||||||||||||||||||||||||||||||||||||||
2037327 | 2037327 | MS | school | 2802790 | 4500 | MADISON CO SCHOOL DIST | 280279001283 | 4500022 | GERMANTOWN MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 699 | 318 | 21 | * | * | 14 | 563.0 | 509.0 | 1072 | 699 | 318 | 21 | 14 | 563 | 509 | 1072 | ||||||||||||||||||||||||||||||||||||||
2034955 | 2034955 | MS | school | 2801740 | 2300 | HANCOCK CO SCHOOL DIST | 280174001232 | 2300009 | HANCOCK MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 906 | 94 | 23 | * | * | * | 42 | 526.0 | 548.0 | 1074 | 906 | 94 | 23 | 42 | 526 | 548 | 1074 | |||||||||||||||||||||||||||||||||||||
2241428 | 2241428 | MS | school | 2801680 | 2220 | GRENADA SCHOOL DIST | 280168000262 | 2220004 | GRENADA HIGH | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 507 | 530 | * | * | 26 | 539 | 536 | 1075 | 507 | 530 | 26 | 539 | 536 | 1075 | ||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
2038549 | 2038549 | MS | school | 2803520 | 6120 | PEARL PUBLIC SCHOOL DIST | 280352001354 | 6120016 | PEARL JUNIOR HIGH SCHOOL | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 545 | 387 | 83 | * | 10 | * | 49 | 559.0 | 520.0 | 1079 | 545 | 387 | 83 | 10 | 49 | 559 | 520 | 1079 | ||||||||||||||||||||||||||||||||||||
2037304 | 2037304 | MS | school | 2802790 | 4500 | MADISON CO SCHOOL DIST | 280279000988 | 4500010 | CAMDEN ELEMENTARY | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | * | * | 41.0 | 67.0 | 108 | 41 | 67 | 108 | ||||||||||||||||||||||||||||||||||||||||||||||
2034415 | 2034415 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132000191 | 1700024 | HORN LAKE MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 166 | 758 | 88 | * | * | 57 | 543.0 | 537.0 | 1080 | 166 | 758 | 88 | 57 | 543 | 537 | 1080 | ||||||||||||||||||||||||||||||||||||||
2037626 | 2037626 | MS | school | 2802940 | 4800 | MONROE CO SCHOOL DIST | 280294000581 | 4800016 | HATLEY HIGH SCHOOL | Regular School | No | Other | KG | 12 | 2020 | pk_12_total | 1021 | 57 | * | * | 543.0 | 544.0 | 1087 | 1021 | 57 | 543 | 544 | 1087 | ||||||||||||||||||||||||||||||||||||||||||
2036364 | 2036364 | MS | school | 2802280 | 3400 | JONES CO SCHOOL DIST | 280228001237 | 3400050 | WEST JONES ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 06 | 2020 | pk_12_total | 637 | 149 | 224 | * | * | 67 | 549.0 | 541.0 | 1090 | 637 | 149 | 224 | 67 | 549 | 541 | 1090 | ||||||||||||||||||||||||||||||||||||||
2036008 | 2036008 | MS | school | 2802160 | 3000 | JACKSON CO SCHOOL DIST | 280216000963 | 3000024 | ST. MARTIN MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 683 | 238 | 54 | * | 72 | * | 38 | 571.0 | 520.0 | 1091 | 683 | 238 | 54 | 72 | 38 | 571 | 520 | 1091 | ||||||||||||||||||||||||||||||||||||
2242677 | 2242677 | MS | school | 2803480 | 3022 | PASCAGOULA GAUTIER SCHOOL DIST | 280348000678 | 3022052 | PASCAGOULA HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 316 | 506 | 233 | * | * | 24 | 542 | 549 | 1091 | 316 | 506 | 233 | 24 | 542 | 549 | 1091 | ||||||||||||||||||||||||||||||||||||||
2240975 | 2240975 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132000193 | 1700032 | OLIVE BRANCH HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 445 | 520 | 57 | * | 17 | * | 53 | 553 | 544 | 1097 | 445 | 520 | 57 | 17 | 53 | 553 | 544 | 1097 | ||||||||||||||||||||||||||||||||||||
2035050 | 2035050 | MS | school | 2801770 | 2400 | HARRISON CO SCHOOL DIST | 280177001469 | 2400030 | NORTH GULFPORT MIDDLE SCHOOL | Regular School | No | Middle | 07 | 08 | 2020 | pk_12_total | 306 | 668 | 56 | * | * | 48 | 594.0 | 504.0 | 1098 | 306 | 668 | 56 | 48 | 594 | 504 | 1098 | ||||||||||||||||||||||||||||||||||||||
2240674 | 2240674 | MS | school | 2800191 | 1321 | WEST POINT CONSOLIDATED SCHOOL DIST | 280019101441 | 1321020 | WEST POINT HIGH SCHOOL | Regular School | No | High | 08 | 12 | 2021 | pk_12_total | 197 | 874 | 15 | * | * | * | 536 | 562 | 1098 | 197 | 874 | 15 | 536 | 562 | 1098 | |||||||||||||||||||||||||||||||||||||||
2037160 | 2037160 | MS | school | 2802730 | 4400 | LOWNDES CO SCHOOL DIST | 280273000528 | 4400002 | CALEDONIA ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 874 | 168 | 29 | * | * | 22 | 559.0 | 540.0 | 1099 | 874 | 168 | 29 | 22 | 559 | 540 | 1099 | ||||||||||||||||||||||||||||||||||||||
2245038 | 2245038 | MS | school | 2801196 | 6177 | HUDSPETH CENTER ADMINISTRATION | 280119601210 | 6177004 | C B NOBLIN SCHOOL | Regular School | No | Ungraded | UG | UG | 2021 | pk_12_total | * | * | * | * | 11 | 11 | ||||||||||||||||||||||||||||||||||||||||||||||||
2240721 | 2240721 | MS | school | 2801100 | 1402 | COAHOMA EARLY COLLEGE HIGH SCHOOL | 280110000137 | 1402004 | COAHOMA EARLY COLLEGE HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 110 | 37 | 73 | 110 | 110 | 37 | 73 | 110 | ||||||||||||||||||||||||||||||||||||||||||||||
2039241 | 2039241 | MS | school | 2803120 | 7320 | NEW ALBANY PUBLIC SCHOOLS | 280312001259 | 7320012 | NEW ALBANY ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 564 | 280 | 162 | * | * | 67 | 548.0 | 553.0 | 1101 | 564 | 280 | 162 | 67 | 548 | 553 | 1101 | ||||||||||||||||||||||||||||||||||||||
2241574 | 2241574 | MS | school | 2801770 | 2400 | HARRISON CO SCHOOL DIST | 280177001469 | 2400030 | NORTH GULFPORT MIDDLE SCHOOL | Regular School | No | Middle | 07 | 08 | 2021 | pk_12_total | 286 | 692 | 64 | * | 12 | * | 46 | 561 | 542 | 1103 | 286 | 692 | 64 | 12 | 46 | 561 | 542 | 1103 | ||||||||||||||||||||||||||||||||||||
2034494 | 2034494 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132001336 | 1700047 | SOUTHAVEN INTERMEDIATE SCHOOL | Regular School | No | Elementary | 03 | 05 | 2020 | pk_12_total | 332 | 546 | 76 | * | 12 | * | 133 | 612.0 | 492.0 | 1104 | 332 | 546 | 76 | 12 | 133 | 612 | 492 | 1104 | ||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||
2243486 | 2243486 | MS | school | 2804320 | 4120 | TUPELO PUBLIC SCHOOL DIST | 280432000293 | 4120042 | TUPELO MIDDLE SCHOOL | Regular School | No | Middle | 07 | 08 | 2021 | pk_12_total | 327 | 612 | 87 | 30 | 48 | 564 | 540 | 1104 | 327 | 612 | 87 | 30 | 48 | 564 | 540 | 1104 | ||||||||||||||||||||||||||||||||||||||
2240947 | 2240947 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132000191 | 1700024 | HORN LAKE MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 156 | 797 | 83 | * | * | * | 64 | 585 | 522 | 1107 | 156 | 797 | 83 | 64 | 585 | 522 | 1107 | |||||||||||||||||||||||||||||||||||||
2241066 | 2241066 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132001262 | 1700056 | PLEASANT HILL ELEMENTARY | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 520 | 387 | * | * | 24 | 163 | 602 | 505 | 1107 | 520 | 387 | 24 | 163 | 602 | 505 | 1107 | ||||||||||||||||||||||||||||||||||||||
2037125 | 2037125 | MS | school | 2800031 | 4306 | MS SCHOOL FOR THE ARTS | 280003101574 | 4306004 | MS SCHOOL FOR THE ARTS | Regular School | No | High | 11 | 12 | 2020 | pk_12_total | 57 | 46 | * | * | * | * | 26.0 | 85.0 | 111 | 57 | 46 | 26 | 85 | 111 | ||||||||||||||||||||||||||||||||||||||||
2035119 | 2035119 | MS | school | 2801770 | 2400 | HARRISON CO SCHOOL DIST | 280177001347 | 2400055 | WEST HARRISON HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 685 | 354 | 30 | * | 14 | * | 22 | 556.0 | 556.0 | 1112 | 685 | 354 | 30 | 14 | 22 | 556 | 556 | 1112 | ||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
2245031 | 2245031 | MS | school | 2803520 | 6120 | PEARL PUBLIC SCHOOL DIST | 280352000003 | 6120012 | PEARL HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 551 | 435 | 69 | * | 19 | * | 42 | 565 | 553 | 1118 | 551 | 435 | 69 | 19 | 42 | 565 | 553 | 1118 | ||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
2034444 | 2034444 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132000193 | 1700032 | OLIVE BRANCH HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 464 | 535 | 63 | * | 13 | * | 42 | 564.0 | 557.0 | 1121 | 464 | 535 | 63 | 13 | 42 | 564 | 557 | 1121 | ||||||||||||||||||||||||||||||||||||
2034534 | 2034534 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132001262 | 1700056 | PLEASANT HILL ELEMENTARY | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 583 | 379 | * | * | 22 | 129 | 622.0 | 509.0 | 1131 | 583 | 379 | 22 | 129 | 622 | 509 | 1131 | ||||||||||||||||||||||||||||||||||||||
2036346 | 2036346 | MS | school | 2802280 | 3400 | JONES CO SCHOOL DIST | 280228000986 | 3400034 | SOUTH JONES ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 06 | 2020 | pk_12_total | 803 | 196 | 80 | * | * | 590.0 | 546.0 | 1136 | 803 | 196 | 80 | 590 | 546 | 1136 | ||||||||||||||||||||||||||||||||||||||||
2037905 | 2037905 | MS | school | 2804050 | 5412 | SOUTH PANOLA SCHOOL DISTRICT | 280405000766 | 5412016 | SOUTH PANOLA HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 437 | 663 | 23 | * | * | * | 571.0 | 567.0 | 1138 | 437 | 663 | 23 | 571 | 567 | 1138 | |||||||||||||||||||||||||||||||||||||||
2035734 | 2035734 | MS | school | 2801090 | 2521 | CLINTON PUBLIC SCHOOL DIST | 280109000131 | 2521004 | CLINTON HIGH SCHOOL | Regular School | No | High | 10 | 12 | 2020 | pk_12_total | 387 | 662 | 22 | * | 56 | * | * | 554.0 | 585.0 | 1139 | 387 | 662 | 22 | 56 | 554 | 585 | 1139 | |||||||||||||||||||||||||||||||||||||
2242138 | 2242138 | MS | school | 2802190 | 2520 | JACKSON PUBLIC SCHOOL DIST | 280219000408 | 2520066 | POWER APAC SCHOOL | Regular School | No | Elementary | 04 | 05 | 2021 | pk_12_total | * | 103 | * | * | 40 | 74 | 114 | 103 | 40 | 74 | 114 | |||||||||||||||||||||||||||||||||||||||||||
2035291 | 2035291 | MS | school | 2801860 | 2500 | HINDS CO SCHOOL DIST | 280186000322 | 2500012 | CARVER MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 36 | 71 | * | * | * | 63.0 | 52.0 | 115 | 36 | 71 | 63 | 52 | 115 | |||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||
2242244 | 2242244 | MS | school | 2801090 | 2521 | CLINTON PUBLIC SCHOOL DIST | 280109000131 | 2521004 | CLINTON HIGH SCHOOL | Regular School | No | High | 10 | 12 | 2021 | pk_12_total | 379 | 673 | 37 | * | 55 | * | * | 575 | 579 | 1154 | 379 | 673 | 37 | 55 | 575 | 579 | 1154 | |||||||||||||||||||||||||||||||||||||
2034553 | 2034553 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132001288 | 1700062 | LEWISBURG HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 993 | 89 | 26 | * | 18 | * | 30 | 595.0 | 564.0 | 1159 | 993 | 89 | 26 | 18 | 30 | 595 | 564 | 1159 | ||||||||||||||||||||||||||||||||||||
2037194 | 2037194 | MS | school | 2802730 | 4400 | LOWNDES CO SCHOOL DIST | 280273000532 | 4400014 | NEW HOPE ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 656 | 479 | 11 | * | * | 14 | 588.0 | 578.0 | 1166 | 656 | 479 | 11 | 14 | 588 | 578 | 1166 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
2038809 | 2038809 | MS | school | 2800187 | 6711 | SUNFLOWER CO CONSOLIDATE SCH DIST | 280018701403 | 6711011 | DREW HUNTER MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | * | 103 | * | 56.0 | 61.0 | 117 | 103 | 56 | 61 | 117 | ||||||||||||||||||||||||||||||||||||||||||||
2038543 | 2038543 | MS | school | 2803520 | 6120 | PEARL PUBLIC SCHOOL DIST | 280352000003 | 6120012 | PEARL HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 570 | 459 | 85 | * | 18 | * | 40 | 602.0 | 573.0 | 1175 | 570 | 459 | 85 | 18 | 40 | 602 | 573 | 1175 | ||||||||||||||||||||||||||||||||||||
2240162 | 2240162 | MS | school | 2801260 | 220 | CORINTH SCHOOL DIST | 280126001368 | 220002 | CORINTH ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 04 | 2021 | pk_12_total | 593 | 334 | 137 | * | * | 96 | 609 | 566 | 1175 | 593 | 334 | 137 | 96 | 609 | 566 | 1175 | ||||||||||||||||||||||||||||||||||||||
2242395 | 2242395 | MS | school | 2802100 | 2900 | ITAWAMBA CO SCHOOL DIST | 280210000357 | 2900008 | FAIRVIEW ATTENDANCE CENTER | Regular School | No | Elementary | KG | 06 | 2021 | pk_12_total | 113 | * | * | 61 | 57 | 118 | 113 | 61 | 57 | 118 | ||||||||||||||||||||||||||||||||||||||||||||
2037847 | 2037847 | MS | school | 2800189 | 5321 | STARKVILLE- OKTIBBEHA CONS SD | 280018901453 | 5321020 | ARMSTRONG MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 300 | 820 | 22 | * | 41 | * | 607.0 | 580.0 | 1187 | 300 | 820 | 22 | 41 | 607 | 580 | 1187 | ||||||||||||||||||||||||||||||||||||||
2244395 | 2244395 | MS | school | 2804050 | 5412 | SOUTH PANOLA SCHOOL DISTRICT | 280405000766 | 5412016 | SOUTH PANOLA HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 458 | 681 | 25 | * | * | 19 | 586 | 602 | 1188 | 458 | 681 | 25 | 19 | 586 | 602 | 1188 | ||||||||||||||||||||||||||||||||||||||
2034748 | 2034748 | MS | school | 2803530 | 1821 | PETAL SCHOOL DIST | 280353001068 | 1821006 | PETAL HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 862 | 199 | 68 | * | * | 38 | 607.0 | 586.0 | 1193 | 862 | 199 | 68 | 38 | 607 | 586 | 1193 | ||||||||||||||||||||||||||||||||||||||
2245299 | 2245299 | MS | school | 2800187 | 6711 | SUNFLOWER CO CONSOLIDATE SCH DIST | 280018701403 | 6711011 | DREW HUNTER MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | * | 116 | * | 64 | 58 | 122 | 116 | 64 | 58 | 122 | ||||||||||||||||||||||||||||||||||||||||||||
2035319 | 2035319 | MS | school | 2801860 | 2500 | HINDS CO SCHOOL DIST | 280186000902 | 2500030 | TERRY HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 82 | 1115 | 10 | * | * | 610.0 | 612.0 | 1222 | 82 | 1115 | 10 | 610 | 612 | 1222 | ||||||||||||||||||||||||||||||||||||||||
2037366 | 2037366 | MS | school | 2802790 | 4500 | MADISON CO SCHOOL DIST | 280279001220 | 4500036 | MADISON CENTRAL HIGH SCHOOL | Regular School | No | High | 10 | 12 | 2020 | pk_12_total | 808 | 319 | 19 | 67 | 11 | 628.0 | 596.0 | 1224 | 808 | 319 | 19 | 67 | 11 | 628 | 596 | 1224 | ||||||||||||||||||||||||||||||||||||||
2241085 | 2241085 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132001288 | 1700062 | LEWISBURG HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 1029 | 110 | 32 | * | 21 | * | 32 | 631 | 596 | 1227 | 1029 | 110 | 32 | 21 | 32 | 631 | 596 | 1227 | ||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||
2240690 | 2240690 | MS | school | 2801110 | 1400 | COAHOMA COUNTY SCHOOL DISTRICT | 280111000141 | 1400016 | FRIARS POINT ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 06 | 2021 | pk_12_total | * | 119 | * | 54 | 69 | 123 | 119 | 54 | 69 | 123 | ||||||||||||||||||||||||||||||||||||||||||||
2243565 | 2243565 | MS | school | 2800199 | 4225 | LEFLORE LEGACY ACADEMY | 280019901531 | 4225004 | Leflore Legacy Academy | Regular School | Yes | Middle | 06 | 06 | 2021 | pk_12_total | * | * | 54 | 69 | 123 | 54 | 69 | 123 | ||||||||||||||||||||||||||||||||||||||||||||||
2245309 | 2245309 | MS | school | 2800187 | 6711 | SUNFLOWER CO CONSOLIDATE SCH DIST | 280018701430 | 6711012 | INVERNESS SCHOOL | Regular School | No | Elementary | KG | 08 | 2021 | pk_12_total | * | 118 | * | 59 | 64 | 123 | 118 | 59 | 64 | 123 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
2241824 | 2241824 | MS | school | 2801860 | 2500 | HINDS CO SCHOOL DIST | 280186000322 | 2500012 | CARVER MIDDLE SCHOOL | Regular School | No | Middle | 07 | 08 | 2021 | pk_12_total | * | 77 | * | 80 | 44 | 124 | 77 | 80 | 44 | 124 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
2240716 | 2240716 | MS | school | 2801110 | 1400 | COAHOMA COUNTY SCHOOL DISTRICT | 280111000145 | 1400048 | SHERARD ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 06 | 2021 | pk_12_total | 24 | 95 | * | * | 71 | 54 | 125 | 24 | 95 | 71 | 54 | 125 |
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]);