enrollments
Data source: Big Local News · About: Big Local
6,262 rows where state = "MS" and year = 2021 sorted by female descending
This data as json, CSV (advanced)
grade ✖
- pk_12_total 781
- 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||||||||||||||||||||||||||||||
2245991 | 2245991 | MS | school | 2801620 | 7620 | GREENVILLE PUBLIC SCHOOLS | 280162000244 | 7620032 | GREENVILLE HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | * | 946 | * | * | 424 | 529 | 953 | 946 | 424 | 529 | 953 | |||||||||||||||||||||||||||||||||||||||||||
2241995 | 2241995 | MS | school | 2802190 | 2520 | JACKSON PUBLIC SCHOOL DIST | 280219000390 | 2520039 | JIM HILL HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | * | 913 | * | * | 407 | 527 | 934 | 913 | 407 | 527 | 934 | |||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
2245728 | 2245728 | MS | school | 2803120 | 7320 | NEW ALBANY PUBLIC SCHOOLS | 280312001259 | 7320012 | NEW ALBANY ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 507 | 260 | 142 | 28 | 57 | 478 | 516 | 994 | 507 | 260 | 142 | 28 | 57 | 478 | 516 | 994 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||
2240962 | 2240962 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132000945 | 1700028 | HORN LAKE INTERMEDIATE SCHOOL | Regular School | No | Elementary | 03 | 05 | 2021 | pk_12_total | 145 | 643 | 46 | * | * | * | 119 | 473 | 493 | 966 | 145 | 643 | 46 | 119 | 473 | 493 | 966 | |||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
2244015 | 2244015 | MS | school | 2802850 | 4700 | MARSHALL CO SCHOOL DIST | 280285000549 | 4700008 | GALENA ELEMENTARY SCHOOL (K-6) | Regular School | No | Elementary | KG | 06 | 2021 | pk_12_total | * | 76 | * | * | 39 | 49 | 88 | 76 | 39 | 49 | 88 | |||||||||||||||||||||||||||||||||||||||||||
2245994 | 2245994 | MS | school | 2801620 | 7620 | GREENVILLE PUBLIC SCHOOLS | 280162000247 | 7620044 | MC BRIDE PRE-K ACADEMY | Regular School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | * | * | 36 | 49 | 85 | 36 | 49 | 85 | ||||||||||||||||||||||||||||||||||||||||||||||
2241647 | 2241647 | MS | school | 2800630 | 2420 | BILOXI PUBLIC SCHOOL DIST | 280063001107 | 2420006 | BILOXI JUNIOR HIGH | Regular School | No | Middle | 07 | 08 | 2021 | pk_12_total | 396 | 349 | 154 | * | 31 | * | 56 | 506 | 487 | 993 | 396 | 349 | 154 | 31 | 56 | 506 | 487 | 993 | ||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
2241527 | 2241527 | MS | school | 2801770 | 2400 | HARRISON CO SCHOOL DIST | 280177000286 | 2400004 | DIBERVILLE MIDDLE SCHOOL | Regular School | No | Middle | 04 | 08 | 2021 | pk_12_total | 460 | 276 | 75 | * | 79 | * | 53 | 467 | 485 | 952 | 460 | 276 | 75 | 79 | 53 | 467 | 485 | 952 | ||||||||||||||||||||||||||||||||||||
2241972 | 2241972 | MS | school | 2802190 | 2520 | JACKSON PUBLIC SCHOOL DIST | 280219000384 | 2520031 | FOREST HILL HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | * | 924 | 13 | * | * | 466 | 485 | 951 | 924 | 13 | 466 | 485 | 951 | |||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
2242249 | 2242249 | MS | school | 2801090 | 2521 | CLINTON PUBLIC SCHOOL DIST | 280109000132 | 2521008 | CLINTON JR HI SCHOOL | Regular School | No | Middle | 07 | 08 | 2021 | pk_12_total | 329 | 512 | * | 46 | * | 446 | 474 | 920 | 329 | 512 | 46 | 446 | 474 | 920 | ||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
2244322 | 2244322 | MS | school | 2800189 | 5321 | STARKVILLE- OKTIBBEHA CONS SD | 280018901438 | 5321007 | HENDERSON/WARD-STEWART ELEMENTARY | Regular School | No | Elementary | 02 | 04 | 2021 | pk_12_total | 284 | 648 | 11 | * | 43 | * | 522 | 466 | 988 | 284 | 648 | 11 | 43 | 522 | 466 | 988 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||
2241127 | 2241127 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132001357 | 1700082 | LAKE CORMORANT HIGH | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 386 | 414 | 91 | * | * | 31 | 469 | 461 | 930 | 386 | 414 | 91 | 31 | 469 | 461 | 930 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
2245744 | 2245744 | MS | school | 2804440 | 7400 | WALTHALL CO SCHOOL DIST | 280444000833 | 7400004 | DEXTER ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 08 | 2021 | pk_12_total | 37 | 35 | * | * | 33 | 46 | 79 | 37 | 35 | 33 | 46 | 79 | ||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
2243730 | 2243730 | MS | school | 2801200 | 4420 | COLUMBUS MUNICIPAL SCHOOL DIST | 280120000154 | 4420016 | COLUMBUS HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 44 | 867 | 18 | * | * | 488 | 457 | 945 | 44 | 867 | 18 | 488 | 457 | 945 | ||||||||||||||||||||||||||||||||||||||||
2241936 | 2241936 | MS | school | 2802190 | 2520 | JACKSON PUBLIC SCHOOL DIST | 280219000377 | 2520018 | CALLAWAY HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | * | 897 | 28 | * | 11 | 486 | 455 | 941 | 897 | 28 | 11 | 486 | 455 | 941 | ||||||||||||||||||||||||||||||||||||||||
2241434 | 2241434 | MS | school | 2801680 | 2220 | GRENADA SCHOOL DIST | 280168000264 | 2220012 | GRENADA MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 424 | 484 | * | * | * | * | 21 | 487 | 452 | 939 | 424 | 484 | 21 | 487 | 452 | 939 | ||||||||||||||||||||||||||||||||||||||
2242875 | 2242875 | MS | school | 2802280 | 3400 | JONES CO SCHOOL DIST | 280228001237 | 3400050 | WEST JONES ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 06 | 2021 | pk_12_total | 508 | 153 | 211 | * | * | 485 | 452 | 937 | 508 | 153 | 211 | 485 | 452 | 937 | ||||||||||||||||||||||||||||||||||||||||
2241213 | 2241213 | MS | school | 2801800 | 1820 | HATTIESBURG PUBLIC SCHOOL DIST | 280180000310 | 1820008 | HATTIESBURG HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 26 | 857 | 40 | * | * | * | 485 | 451 | 936 | 26 | 857 | 40 | 485 | 451 | 936 | |||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
2243304 | 2243304 | MS | school | 2802520 | 4000 | LEAKE CO SCHOOL DIST | 280252001118 | 4000002 | LEAKE CENTRAL ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 178 | 517 | 173 | * | * | 28 | 458 | 447 | 905 | 178 | 517 | 173 | 28 | 458 | 447 | 905 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||
2241111 | 2241111 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132001358 | 1700074 | CENTER HILL MIDDLE | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 320 | 413 | 28 | * | * | 70 | 410 | 437 | 847 | 320 | 413 | 28 | 70 | 410 | 437 | 847 | ||||||||||||||||||||||||||||||||||||||
2242144 | 2242144 | MS | school | 2802190 | 2520 | JACKSON PUBLIC SCHOOL DIST | 280219000409 | 2520068 | PROVINE HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | * | 834 | 12 | * | 428 | 431 | 859 | 834 | 12 | 428 | 431 | 859 | ||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||
2243874 | 2243874 | MS | school | 2802790 | 4500 | MADISON CO SCHOOL DIST | 280279001257 | 4500046 | RIDGELAND HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 106 | 598 | 118 | * | * | 438 | 429 | 867 | 106 | 598 | 118 | 438 | 429 | 867 | ||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
2242954 | 2242954 | MS | school | 2802370 | 3600 | LAFAYETTE CO SCHOOL DIST | 280237000463 | 3600008 | LAFAYETTE HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 565 | 232 | 22 | * | * | 402 | 425 | 827 | 565 | 232 | 22 | 402 | 425 | 827 | ||||||||||||||||||||||||||||||||||||||||
2241657 | 2241657 | MS | school | 2800630 | 2420 | BILOXI PUBLIC SCHOOL DIST | 280063001478 | 2420010 | BILOXI UPPER ELEMENTARY | Regular School | No | Middle | 05 | 06 | 2021 | pk_12_total | 334 | 294 | 157 | * | 33 | * | 69 | 466 | 424 | 890 | 334 | 294 | 157 | 33 | 69 | 466 | 424 | 890 | ||||||||||||||||||||||||||||||||||||
2241706 | 2241706 | MS | school | 2801710 | 2421 | GULFPORT SCHOOL DIST | 280171000270 | 2421012 | BAYOU VIEW MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 435 | 322 | 93 | * | * | 29 | 473 | 424 | 897 | 435 | 322 | 93 | 29 | 473 | 424 | 897 | ||||||||||||||||||||||||||||||||||||||
2242652 | 2242652 | MS | school | 2803480 | 3022 | PASCAGOULA GAUTIER SCHOOL DIST | 280348000935 | 3022042 | GAUTIER HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 296 | 387 | 134 | * | 14 | * | 43 | 453 | 424 | 877 | 296 | 387 | 134 | 14 | 43 | 453 | 424 | 877 | ||||||||||||||||||||||||||||||||||||
2240310 | 2240310 | MS | school | 2800750 | 614 | CLEVELAND SCHOOL DIST | 280075001477 | 614009 | CLEVELAND CENTRAL HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 131 | 624 | * | * | 27 | 377 | 421 | 798 | 131 | 624 | 27 | 377 | 421 | 798 | ||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
2244441 | 2244441 | MS | school | 2803630 | 5520 | PICAYUNE SCHOOL DIST | 280363000695 | 5520016 | PICAYUNE MEMORIAL HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 517 | 266 | 27 | * | * | 32 | 431 | 420 | 851 | 517 | 266 | 27 | 32 | 431 | 420 | 851 | ||||||||||||||||||||||||||||||||||||||
2241820 | 2241820 | MS | school | 2801860 | 2500 | HINDS CO SCHOOL DIST | 280186000321 | 2500008 | BYRAM MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 49 | 839 | * | * | * | 486 | 415 | 901 | 49 | 839 | 486 | 415 | 901 | |||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||
2245864 | 2245864 | MS | school | 2804470 | 7500 | VICKSBURG WARREN SCHOOL DIST | 280447000830 | 7500025 | VICKSBURG HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 108 | 684 | 14 | * | * | * | 415 | 408 | 823 | 108 | 684 | 14 | 415 | 408 | 823 | |||||||||||||||||||||||||||||||||||||||
2244380 | 2244380 | MS | school | 2804050 | 5412 | SOUTH PANOLA SCHOOL DISTRICT | 280405000764 | 5412008 | BATESVILLE JUNIOR HIGH SCHOOL | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 261 | 543 | * | * | 35 | 456 | 406 | 862 | 261 | 543 | 35 | 456 | 406 | 862 | ||||||||||||||||||||||||||||||||||||||||
2246088 | 2246088 | MS | school | 2804530 | 7700 | WAYNE CO SCHOOL DIST | 280453000850 | 7700026 | WAYNE COUNTY HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 335 | 490 | 18 | * | * | * | 447 | 403 | 850 | 335 | 490 | 18 | 447 | 403 | 850 | |||||||||||||||||||||||||||||||||||||||
2241835 | 2241835 | MS | school | 2801860 | 2500 | HINDS CO SCHOOL DIST | 280186000983 | 2500024 | GARY ROAD INTERMEDIATE SCHOOL | Regular School | No | Elementary | 03 | 05 | 2021 | pk_12_total | 55 | 749 | * | * | 416 | 402 | 818 | 55 | 749 | 416 | 402 | 818 | ||||||||||||||||||||||||||||||||||||||||||
2242964 | 2242964 | MS | school | 2802370 | 3600 | LAFAYETTE CO SCHOOL DIST | 280237001280 | 3600016 | LAFAYETTE UPPER ELEMENTARY SCHOOL | Regular School | No | Elementary | 03 | 06 | 2021 | pk_12_total | 595 | 179 | 23 | * | * | 17 | 420 | 400 | 820 | 595 | 179 | 23 | 17 | 420 | 400 | 820 | ||||||||||||||||||||||||||||||||||||||
2243643 | 2243643 | MS | school | 2800840 | 4320 | BROOKHAVEN SCHOOL DIST | 280084000092 | 4320012 | BROOKHAVEN HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 244 | 483 | * | * | 21 | 369 | 395 | 764 | 244 | 483 | 21 | 369 | 395 | 764 | ||||||||||||||||||||||||||||||||||||||||
2241132 | 2241132 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132001282 | 1700084 | LAKE CORMORANT MIDDLE | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 296 | 331 | 80 | * | * | 47 | 364 | 394 | 758 | 296 | 331 | 80 | 47 | 364 | 394 | 758 | ||||||||||||||||||||||||||||||||||||||
2245082 | 2245082 | MS | school | 2803900 | 6200 | SCOTT CO SCHOOL DIST | 280390000748 | 6200016 | SCOTT CENTRAL ATTENDANCE CENTER | Regular School | No | Other | KG | 12 | 2021 | pk_12_total | 285 | 469 | 43 | * | * | 441 | 393 | 834 | 285 | 469 | 43 | 441 | 393 | 834 | ||||||||||||||||||||||||||||||||||||||||
2244341 | 2244341 | MS | school | 2800189 | 5321 | STARKVILLE- OKTIBBEHA CONS SD | 280018901440 | 5321024 | SUDDUTH ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 01 | 2021 | pk_12_total | 265 | 506 | * | * | 33 | * | 421 | 392 | 813 | 265 | 506 | 33 | 421 | 392 | 813 | |||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||
2242257 | 2242257 | MS | school | 2801090 | 2521 | CLINTON PUBLIC SCHOOL DIST | 280109000135 | 2521014 | EASTSIDE ELEM | Regular School | No | Elementary | 04 | 05 | 2021 | pk_12_total | 316 | 422 | 13 | * | 43 | * | * | 429 | 383 | 812 | 316 | 422 | 13 | 43 | 429 | 383 | 812 | |||||||||||||||||||||||||||||||||||||
2240980 | 2240980 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132000194 | 1700034 | OLIVE BRANCH MIDDLE | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 286 | 384 | 47 | * | * | 72 | 425 | 382 | 807 | 286 | 384 | 47 | 72 | 425 | 382 | 807 | ||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||
2242664 | 2242664 | MS | school | 2803480 | 3022 | PASCAGOULA GAUTIER SCHOOL DIST | 280348000677 | 3022048 | LAKE ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 04 | 2021 | pk_12_total | 35 | 24 | * | * | 45 | 38 | 83 | 35 | 24 | 45 | 38 | 83 | ||||||||||||||||||||||||||||||||||||||||||
2245447 | 2245447 | MS | school | 2803930 | 6920 | SENATOBIA MUNICIPAL SCHOOL DIST | 280393000750 | 6920004 | SENATOBIA ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 359 | 414 | * | * | 417 | 379 | 796 | 359 | 414 | 417 | 379 | 796 | ||||||||||||||||||||||||||||||||||||||||||
2244345 | 2244345 | MS | school | 2800189 | 5321 | STARKVILLE- OKTIBBEHA CONS SD | 280018901532 | 5321030 | SOCSD/MSU PARTNERSHIP MIDDLE SCHOOL | Regular School | No | Middle | 06 | 07 | 2021 | pk_12_total | 201 | 534 | * | * | 26 | 392 | 378 | 770 | 201 | 534 | 26 | 392 | 378 | 770 | ||||||||||||||||||||||||||||||||||||||||
2243697 | 2243697 | MS | school | 2802730 | 4400 | LOWNDES CO SCHOOL DIST | 280273001127 | 4400016 | NEW HOPE HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 404 | 339 | 13 | * | * | * | 13 | 400 | 377 | 777 | 404 | 339 | 13 | 13 | 400 | 377 | 777 | |||||||||||||||||||||||||||||||||||||
2240175 | 2240175 | MS | school | 2801260 | 220 | CORINTH SCHOOL DIST | 280126000006 | 220006 | CORINTH MIDDLE SCHOOL | Regular School | No | Middle | 05 | 08 | 2021 | pk_12_total | 416 | 206 | 82 | * | * | 377 | 373 | 750 | 416 | 206 | 82 | 377 | 373 | 750 | ||||||||||||||||||||||||||||||||||||||||
2244334 | 2244334 | MS | school | 2800189 | 5321 | STARKVILLE- OKTIBBEHA CONS SD | 280018901453 | 5321020 | ARMSTRONG JUNIOR HIGH SCHOOL | Regular School | No | Secondary | 08 | 09 | 2021 | pk_12_total | 194 | 523 | 17 | * | 28 | * | 391 | 373 | 764 | 194 | 523 | 17 | 28 | 391 | 373 | 764 | ||||||||||||||||||||||||||||||||||||||
2242972 | 2242972 | MS | school | 2803450 | 3620 | OXFORD SCHOOL DISTRICT | 280345000662 | 3620008 | CENTRAL ELEMENTARY | Regular School | No | Elementary | 01 | 02 | 2021 | pk_12_total | 366 | 213 | 57 | * | 38 | * | 341 | 372 | 713 | 366 | 213 | 57 | 38 | 341 | 372 | 713 | ||||||||||||||||||||||||||||||||||||||
2243734 | 2243734 | MS | school | 2801200 | 4420 | COLUMBUS MUNICIPAL SCHOOL DIST | 280120001380 | 4420018 | COLUMBUS MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 31 | 752 | 14 | * | * | 435 | 371 | 806 | 31 | 752 | 14 | 435 | 371 | 806 | ||||||||||||||||||||||||||||||||||||||||
2242298 | 2242298 | MS | school | 2801189 | 2560 | MS SCH FOR THE BLIND AND DEAF | 280118901504 | 2560002 | MS SCHOOL FOR THE DEAF | Special Education School | No | Other | PK | 12 | 2021 | pk_12_total | 12 | 54 | * | * | * | 37 | 37 | 74 | 12 | 54 | 37 | 37 | 74 | |||||||||||||||||||||||||||||||||||||||||
2240904 | 2240904 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132001018 | 1700010 | CENTER HILL ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 409 | 271 | 16 | 19 | 67 | 413 | 369 | 782 | 409 | 271 | 16 | 19 | 67 | 413 | 369 | 782 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
2242264 | 2242264 | MS | school | 2801090 | 2521 | CLINTON PUBLIC SCHOOL DIST | 280109000136 | 2521016 | NORTHSIDE ELEM | Regular School | No | Elementary | 02 | 03 | 2021 | pk_12_total | 232 | 410 | * | 60 | * | 17 | 365 | 368 | 733 | 232 | 410 | 60 | 17 | 365 | 368 | 733 | ||||||||||||||||||||||||||||||||||||||
2241037 | 2241037 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132000998 | 1700050 | DESOTO CENTRAL ELEMENTARY SCHOOL | Regular School | No | Elementary | 03 | 05 | 2021 | pk_12_total | 351 | 274 | 18 | 34 | 78 | 388 | 367 | 755 | 351 | 274 | 18 | 34 | 78 | 388 | 367 | 755 | ||||||||||||||||||||||||||||||||||||||
2244241 | 2244241 | MS | school | 2803150 | 5100 | NEWTON COUNTY SCHOOL DISTRICT | 280315001222 | 5100006 | NEWTON COUNTY ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 476 | 142 | 12 | 25 | 14 | * | * | 310 | 367 | 677 | 476 | 142 | 12 | 25 | 14 | 310 | 367 | 677 | ||||||||||||||||||||||||||||||||||||
2245004 | 2245004 | MS | school | 2803830 | 6100 | RANKIN CO SCHOOL DIST | 280383000743 | 6100056 | RICHLAND HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2021 | pk_12_total | 447 | 233 | 92 | * | * | 431 | 367 | 798 | 447 | 233 | 92 | 431 | 367 | 798 | ||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||
2241830 | 2241830 | MS | school | 2801860 | 2500 | HINDS CO SCHOOL DIST | 280186001036 | 2500020 | GARY ROAD ELEMENTARY | Regular School | No | Elementary | PK | 02 | 2021 | pk_12_total | 48 | 613 | * | * | * | 12 | 316 | 365 | 681 | 48 | 613 | 12 | 316 | 365 | 681 | |||||||||||||||||||||||||||||||||||||||
2242825 | 2242825 | MS | school | 2802280 | 3400 | JONES CO SCHOOL DIST | 280228000985 | 3400022 | EAST JONES ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 06 | 2021 | pk_12_total | 521 | 114 | * | 44 | * | 53 | 401 | 362 | 763 | 521 | 114 | 44 | 53 | 401 | 362 | 763 | ||||||||||||||||||||||||||||||||||||||
2242845 | 2242845 | MS | school | 2802280 | 3400 | JONES CO SCHOOL DIST | 280228001326 | 3400026 | NORTH JONES ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 06 | 2021 | pk_12_total | 305 | 266 | 155 | * | * | 32 | 403 | 362 | 765 | 305 | 266 | 155 | 32 | 403 | 362 | 765 | ||||||||||||||||||||||||||||||||||||||
2243338 | 2243338 | MS | school | 2802550 | 4100 | LEE COUNTY SCHOOL DISTRICT | 280255000492 | 4100004 | GUNTOWN MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 585 | 137 | * | * | * | 27 | 403 | 362 | 765 | 585 | 137 | 27 | 403 | 362 | 765 | |||||||||||||||||||||||||||||||||||||||
2244829 | 2244829 | MS | school | 2803830 | 6100 | RANKIN CO SCHOOL DIST | 280383000736 | 6100006 | BRANDON ELEMENTARY SCHOOL | Regular School | No | Elementary | 04 | 05 | 2021 | pk_12_total | 463 | 234 | 14 | * | * | 22 | 380 | 362 | 742 | 463 | 234 | 14 | 22 | 380 | 362 | 742 |
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]);