enrollments
Data source: Big Local News · About: Big Local
1,763 rows where grade = "pk_12_total" and state = "MS" sorted by total descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2039497 | 2039497 | MS | school | 2801620 | 7620 | GREENVILLE PUBLIC SCHOOLS | 280162000244 | 7620032 | GREENVILLE HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | * | 993 | * | * | 461.0 | 538.0 | 999 | 993 | 461 | 538 | 999 | |||||||||||||||||||||||||||||||||||||||||||
2034903 | 2034903 | MS | school | 2801680 | 2220 | GRENADA SCHOOL DIST | 280168000264 | 2220012 | GRENADA MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 451 | 516 | * | * | * | * | 19 | 515.0 | 483.0 | 998 | 451 | 516 | 19 | 515 | 483 | 998 | ||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
2036070 | 2036070 | MS | school | 2803360 | 3021 | OCEAN SPRINGS SCHOOL DIST | 280336000934 | 3021022 | OCEAN SPRINGS MIDDLE SCHOOL | Regular School | No | Middle | 07 | 08 | 2020 | pk_12_total | 756 | 126 | 49 | * | 34 | * | 17 | 537.0 | 457.0 | 994 | 756 | 126 | 49 | 34 | 17 | 537 | 457 | 994 | ||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
2035060 | 2035060 | MS | school | 2801770 | 2400 | HARRISON CO SCHOOL DIST | 280177000958 | 2400038 | NORTH WOOLMARKET ELEMENTARY AND MID | Regular School | No | Elementary | KG | 08 | 2020 | pk_12_total | 765 | 102 | 68 | * | 10 | * | 39 | 490.0 | 499.0 | 989 | 765 | 102 | 68 | 10 | 39 | 490 | 499 | 989 | ||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||
2037723 | 2037723 | MS | school | 2803060 | 5000 | NESHOBA COUNTY SCHOOL DISTRICT | 280306000612 | 5000008 | NESHOBA CENTRAL HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 640 | 161 | * | 131 | * | 35 | 492.0 | 489.0 | 981 | 640 | 161 | 131 | 35 | 492 | 489 | 981 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
2036801 | 2036801 | MS | school | 2802520 | 4000 | LEAKE CO SCHOOL DIST | 280252001118 | 4000002 | LEAKE CENTRAL ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 220 | 541 | 172 | * | * | 25 | 487.0 | 486.0 | 973 | 220 | 541 | 172 | 25 | 487 | 486 | 973 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||
2035408 | 2035408 | MS | school | 2802190 | 2520 | JACKSON PUBLIC SCHOOL DIST | 280219000377 | 2520018 | CALLAWAY HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | * | 930 | 27 | * | * | 483.0 | 482.0 | 965 | 930 | 27 | 483 | 482 | 965 | |||||||||||||||||||||||||||||||||||||||||
2035003 | 2035003 | MS | school | 2801770 | 2400 | HARRISON CO SCHOOL DIST | 280177000286 | 2400004 | DIBERVILLE MIDDLE SCHOOL | Regular School | No | Middle | 04 | 08 | 2020 | pk_12_total | 480 | 273 | 75 | * | 79 | * | 50 | 478.0 | 486.0 | 964 | 480 | 273 | 75 | 79 | 50 | 478 | 486 | 964 | ||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
2037759 | 2037759 | MS | school | 2803150 | 5100 | NEWTON COUNTY SCHOOL DISTRICT | 280315001135 | 5100012 | NEWTON COUNTY HIGH SCHOOL | Regular School | No | Other | 01 | 12 | 2020 | pk_12_total | 647 | 217 | * | 54 | * | 456.0 | 495.0 | 951 | 647 | 217 | 54 | 456 | 495 | 951 | ||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||
2035624 | 2035624 | MS | school | 2802190 | 2520 | JACKSON PUBLIC SCHOOL DIST | 280219000409 | 2520068 | PROVINE HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | * | 928 | 10 | * | 494.0 | 451.0 | 945 | 928 | 10 | 494 | 451 | 945 | ||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||
2038404 | 2038404 | MS | school | 2803830 | 6100 | RANKIN CO SCHOOL DIST | 280383000955 | 6100026 | NORTHWEST RANKIN MIDDLE SCHOOL | Regular School | No | Middle | 07 | 08 | 2020 | pk_12_total | 589 | 246 | 33 | * | 35 | * | 38 | 483.0 | 461.0 | 944 | 589 | 246 | 33 | 35 | 38 | 483 | 461 | 944 | ||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||
2034270 | 2034270 | MS | school | 2801220 | 1500 | COPIAH CO SCHOOL DIST | 280122000169 | 1500012 | WESSON ATTENDANCE CENTER | Regular School | No | Other | KG | 12 | 2020 | pk_12_total | 743 | 140 | 37 | * | * | 474.0 | 466.0 | 940 | 743 | 140 | 37 | 474 | 466 | 940 | ||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||
2034558 | 2034558 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132001343 | 1700064 | LEWISBURG MIDDLE | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 782 | 80 | 23 | * | * | 23 | 460.0 | 471.0 | 931 | 782 | 80 | 23 | 23 | 460 | 471 | 931 | ||||||||||||||||||||||||||||||||||||||
2036565 | 2036565 | MS | school | 2802400 | 3700 | LAMAR COUNTY SCHOOL DISTRICT | 280240000969 | 3700019 | SUMRALL ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 800 | 73 | * | * | 32 | 471.0 | 460.0 | 931 | 800 | 73 | 32 | 471 | 460 | 931 | ||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||
2035247 | 2035247 | MS | school | 2802670 | 2422 | LONG BEACH SCHOOL DIST | 280267000520 | 2422016 | LONG BEACH SENIOR HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 654 | 155 | 28 | * | 25 | * | 59 | 459.0 | 464.0 | 923 | 654 | 155 | 28 | 25 | 59 | 459 | 464 | 923 | ||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||
2039257 | 2039257 | MS | school | 2804440 | 7400 | WALTHALL CO SCHOOL DIST | 280444000833 | 7400004 | DEXTER ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 08 | 2020 | pk_12_total | 42 | 41 | * | * | * | 49.0 | 43.0 | 92 | 42 | 41 | 49 | 43 | 92 | |||||||||||||||||||||||||||||||||||||||||
2037234 | 2037234 | MS | school | 2801200 | 4420 | COLUMBUS MUNICIPAL SCHOOL DIST | 280120000154 | 4420016 | COLUMBUS HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 31 | 856 | 17 | * | * | 466.0 | 453.0 | 919 | 31 | 856 | 17 | 466 | 453 | 919 | ||||||||||||||||||||||||||||||||||||||||
2038593 | 2038593 | MS | school | 2803900 | 6200 | SCOTT CO SCHOOL DIST | 280390000748 | 6200016 | SCOTT CENTRAL ATTENDANCE CENTER | Regular School | No | Other | KG | 12 | 2020 | pk_12_total | 354 | 487 | 41 | * | * | 29 | 491.0 | 427.0 | 918 | 354 | 487 | 41 | 29 | 491 | 427 | 918 | ||||||||||||||||||||||||||||||||||||||
2034595 | 2034595 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132001357 | 1700082 | LAKE CORMORANT HIGH | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 381 | 403 | 79 | * | * | 45 | 463.0 | 453.0 | 916 | 381 | 403 | 79 | 45 | 463 | 453 | 916 | ||||||||||||||||||||||||||||||||||||||
2036145 | 2036145 | MS | school | 2803480 | 3022 | PASCAGOULA GAUTIER SCHOOL DIST | 280348000935 | 3022042 | GAUTIER HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 315 | 405 | 126 | * | * | 50 | 457.0 | 454.0 | 911 | 315 | 405 | 126 | 50 | 457 | 454 | 911 | ||||||||||||||||||||||||||||||||||||||
2036877 | 2036877 | MS | school | 2802550 | 4100 | LEE COUNTY SCHOOL DISTRICT | 280255000496 | 4100024 | SALTILLO HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 772 | 101 | * | * | 14 | 455.0 | 453.0 | 908 | 772 | 101 | 14 | 455 | 453 | 908 | ||||||||||||||||||||||||||||||||||||||||
2035183 | 2035183 | MS | school | 2801710 | 2421 | GULFPORT SCHOOL DIST | 280171000270 | 2421012 | BAYOU VIEW MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 448 | 329 | 78 | * | 15 | * | 30 | 446.0 | 461.0 | 907 | 448 | 329 | 78 | 15 | 30 | 446 | 461 | 907 | ||||||||||||||||||||||||||||||||||||
2035287 | 2035287 | MS | school | 2801860 | 2500 | HINDS CO SCHOOL DIST | 280186000321 | 2500008 | BYRAM MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 45 | 842 | 10 | * | * | * | 489.0 | 417.0 | 906 | 45 | 842 | 10 | 489 | 417 | 906 | |||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
2035472 | 2035472 | MS | school | 2802190 | 2520 | JACKSON PUBLIC SCHOOL DIST | 280219000390 | 2520039 | JIM HILL HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | * | 879 | * | * | * | 404.0 | 498.0 | 902 | 879 | 404 | 498 | 902 | ||||||||||||||||||||||||||||||||||||||||||
2036315 | 2036315 | MS | school | 2802280 | 3400 | JONES CO SCHOOL DIST | 280228000985 | 3400022 | EAST JONES ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 06 | 2020 | pk_12_total | 625 | 152 | * | 43 | * | 51 | 471.0 | 430.0 | 901 | 625 | 152 | 43 | 51 | 471 | 430 | 901 | ||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
2039172 | 2039172 | MS | school | 2804350 | 7300 | UNION CO SCHOOL DIST | 280435000821 | 7300004 | EAST UNION ATTENDANCE CENTER | Regular School | No | Other | PK | 12 | 2020 | pk_12_total | 782 | 64 | * | * | 25 | 459.0 | 436.0 | 895 | 782 | 64 | 25 | 459 | 436 | 895 | ||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
2034681 | 2034681 | MS | school | 2801800 | 1820 | HATTIESBURG PUBLIC SCHOOL DIST | 280180000310 | 1820008 | HATTIESBURG HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 18 | 836 | 25 | * | * | 10 | 445.0 | 448.0 | 893 | 18 | 836 | 25 | 10 | 445 | 448 | 893 | ||||||||||||||||||||||||||||||||||||||
2037953 | 2037953 | MS | school | 2803630 | 5520 | PICAYUNE SCHOOL DIST | 280363000695 | 5520016 | PICAYUNE MEMORIAL HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 526 | 290 | 34 | * | * | 30 | 445.0 | 445.0 | 890 | 526 | 290 | 34 | 30 | 445 | 445 | 890 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||
2039080 | 2039080 | MS | school | 2804260 | 7100 | TISHOMINGO CO SP MUN SCH DIST | 280426000803 | 7100004 | BELMONT SCHOOL | Regular School | No | Other | KG | 12 | 2020 | pk_12_total | 762 | * | 89 | * | 14 | 450.0 | 428.0 | 878 | 762 | 89 | 14 | 450 | 428 | 878 | ||||||||||||||||||||||||||||||||||||||||
2035748 | 2035748 | MS | school | 2801090 | 2521 | CLINTON PUBLIC SCHOOL DIST | 280109000135 | 2521014 | EASTSIDE ELEM | Regular School | No | Elementary | 04 | 05 | 2020 | pk_12_total | 311 | 481 | 15 | * | 58 | * | * | 446.0 | 431.0 | 877 | 311 | 481 | 15 | 58 | 446 | 431 | 877 | |||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||
2035739 | 2035739 | MS | school | 2801090 | 2521 | CLINTON PUBLIC SCHOOL DIST | 280109000132 | 2521008 | CLINTON JR HI SCHOOL | Regular School | No | Middle | 07 | 08 | 2020 | pk_12_total | 317 | 487 | 22 | * | 41 | * | * | 433.0 | 439.0 | 872 | 317 | 487 | 22 | 41 | 433 | 439 | 872 | |||||||||||||||||||||||||||||||||||||
2037890 | 2037890 | MS | school | 2804050 | 5412 | SOUTH PANOLA SCHOOL DISTRICT | 280405000764 | 5412008 | BATESVILLE JUNIOR HIGH SCHOOL | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 272 | 552 | 18 | * | * | 25 | 466.0 | 405.0 | 871 | 272 | 552 | 18 | 25 | 466 | 405 | 871 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||
2036334 | 2036334 | MS | school | 2802280 | 3400 | JONES CO SCHOOL DIST | 280228001326 | 3400026 | NORTH JONES ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 06 | 2020 | pk_12_total | 365 | 295 | 165 | * | * | 464.0 | 405.0 | 869 | 365 | 295 | 165 | 464 | 405 | 869 | ||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||
2037382 | 2037382 | MS | school | 2802790 | 4500 | MADISON CO SCHOOL DIST | 280279001257 | 4500046 | RIDGELAND HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 117 | 589 | 119 | * | * | 434.0 | 430.0 | 864 | 117 | 589 | 119 | 434 | 430 | 864 | ||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||
2035786 | 2035786 | MS | school | 2801189 | 2560 | MS SCH FOR THE BLIND AND DEAF | 280118901504 | 2560002 | MS SCHOOL FOR THE DEAF | Special Education School | No | Other | KG | 12 | 2020 | pk_12_total | 13 | 63 | * | * | * | 43.0 | 43.0 | 86 | 13 | 63 | 43 | 43 | 86 | |||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||
2039599 | 2039599 | MS | school | 2804530 | 7700 | WAYNE CO SCHOOL DIST | 280453000850 | 7700026 | WAYNE COUNTY HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 327 | 505 | 18 | * | * | * | 424.0 | 434.0 | 858 | 327 | 505 | 18 | 424 | 434 | 858 | |||||||||||||||||||||||||||||||||||||||
2034539 | 2034539 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132001275 | 1700060 | LEWISBURG ELEMENTARY SCHOOL | Regular School | No | Elementary | 03 | 05 | 2020 | pk_12_total | 705 | 67 | 19 | 16 | 48 | 434.0 | 421.0 | 855 | 705 | 67 | 19 | 16 | 48 | 434 | 421 | 855 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
2033757 | 2033757 | MS | school | 2800750 | 614 | CLEVELAND SCHOOL DIST | 280075001477 | 614009 | CLEVELAND CENTRAL HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 147 | 663 | * | * | 17 | 415.0 | 431.0 | 846 | 147 | 663 | 17 | 415 | 431 | 846 | ||||||||||||||||||||||||||||||||||||||||
2036449 | 2036449 | MS | school | 2802370 | 3600 | LAFAYETTE CO SCHOOL DIST | 280237000463 | 3600008 | LAFAYETTE HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 572 | 236 | 24 | * | * | 413.0 | 430.0 | 843 | 572 | 236 | 24 | 413 | 430 | 843 | ||||||||||||||||||||||||||||||||||||||||
2038723 | 2038723 | MS | school | 2804020 | 6500 | SMITH CO SCHOOL DIST | 280402000758 | 6500004 | MIZE ATTENDANCE CENTER | Regular School | No | Other | KG | 12 | 2020 | pk_12_total | 713 | 106 | * | * | * | 15 | 437.0 | 406.0 | 843 | 713 | 106 | 15 | 437 | 406 | 843 | |||||||||||||||||||||||||||||||||||||||
2037240 | 2037240 | MS | school | 2801200 | 4420 | COLUMBUS MUNICIPAL SCHOOL DIST | 280120001380 | 4420018 | COLUMBUS MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 37 | 783 | 11 | * | * | 443.0 | 399.0 | 842 | 37 | 783 | 11 | 443 | 399 | 842 | ||||||||||||||||||||||||||||||||||||||||
2037717 | 2037717 | MS | school | 2803060 | 5000 | NESHOBA COUNTY SCHOOL DISTRICT | 280306000990 | 5000006 | NESHOBA CENTRAL MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 508 | 144 | * | 102 | * | 76 | 400.0 | 440.0 | 840 | 508 | 144 | 102 | 76 | 400 | 440 | 840 | ||||||||||||||||||||||||||||||||||||||
2037854 | 2037854 | MS | school | 2800189 | 5321 | STARKVILLE- OKTIBBEHA CONS SD | 280018901440 | 5321024 | SUDDUTH ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 01 | 2020 | pk_12_total | 265 | 521 | * | * | 40 | * | 435.0 | 403.0 | 838 | 265 | 521 | 40 | 435 | 403 | 838 | |||||||||||||||||||||||||||||||||||||||
2034579 | 2034579 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132001358 | 1700074 | CENTER HILL MIDDLE | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 351 | 376 | 38 | 18 | 54 | 419.0 | 418.0 | 837 | 351 | 376 | 38 | 18 | 54 | 419 | 418 | 837 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||
2039372 | 2039372 | MS | school | 2804470 | 7500 | VICKSBURG WARREN SCHOOL DIST | 280447000830 | 7500025 | VICKSBURG HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 126 | 678 | 11 | * | * | * | 411.0 | 420.0 | 831 | 126 | 678 | 11 | 411 | 420 | 831 | |||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
2035823 | 2035823 | MS | school | 2800195 | 2611 | HOLMES CONSOLIDATE SCHOOL DIST | 280019501488 | 2611010 | HOLMES COUNTY CENTRAL HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | * | * | 442.0 | 388.0 | 830 | 442 | 388 | 830 | ||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||
2038515 | 2038515 | MS | school | 2803830 | 6100 | RANKIN CO SCHOOL DIST | 280383000743 | 6100056 | RICHLAND HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2020 | pk_12_total | 465 | 236 | 93 | 10 | 18 | 436.0 | 386.0 | 822 | 465 | 236 | 93 | 10 | 18 | 436 | 386 | 822 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||
2034449 | 2034449 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132000194 | 1700034 | OLIVE BRANCH MIDDLE | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 304 | 373 | 53 | * | * | 67 | 419.0 | 397.0 | 816 | 304 | 373 | 53 | 67 | 419 | 397 | 816 |
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]);