enrollments
Data source: Big Local News · About: Big Local
882 rows where grade = "pk_12_total", state = "MS" and year = 2020 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
2033606 | 2033606 | MS | school | 2801260 | 220 | CORINTH SCHOOL DIST | 280126001368 | 220002 | CORINTH ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 04 | 2020 | pk_12_total | 666 | 359 | 125 | 11 | 100 | 646.0 | 615.0 | 1261 | 666 | 359 | 125 | 11 | 100 | 646 | 615 | 1261 | ||||||||||||||||||||||||||||||||||||||
2037348 | 2037348 | MS | school | 2802790 | 4500 | MADISON CO SCHOOL DIST | 280279001082 | 4500028 | MADISON MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 817 | 330 | 18 | 77 | 19 | 636.0 | 625.0 | 1261 | 817 | 330 | 18 | 77 | 19 | 636 | 625 | 1261 | ||||||||||||||||||||||||||||||||||||||
2037399 | 2037399 | MS | school | 2802790 | 4500 | MADISON CO SCHOOL DIST | 280279001381 | 4500066 | GERMANTOWN HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 802 | 415 | * | 21 | * | 653.0 | 612.0 | 1265 | 802 | 415 | 21 | 653 | 612 | 1265 | ||||||||||||||||||||||||||||||||||||||||
2034131 | 2034131 | MS | school | 2800191 | 1321 | WEST POINT CONSOLIDATED SCHOOL DIST | 280019101447 | 1321018 | WEST CLAY ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 06 | 2020 | pk_12_total | * | 106 | * | 70.0 | 57.0 | 127 | 106 | 70 | 57 | 127 | ||||||||||||||||||||||||||||||||||||||||||||
2035106 | 2035106 | MS | school | 2801770 | 2400 | HARRISON CO SCHOOL DIST | 280177000959 | 2400051 | WEST WORTHAM ELEMENTARY AND MIDDLE | Regular School | No | Elementary | KG | 08 | 2020 | pk_12_total | 1115 | 57 | 34 | * | * | * | 51 | 644.0 | 626.0 | 1270 | 1115 | 57 | 34 | 51 | 644 | 626 | 1270 | |||||||||||||||||||||||||||||||||||||
2034410 | 2034410 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132000190 | 1700022 | HORN LAKE HIGH | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 225 | 898 | 99 | * | * | 33 | 680.0 | 591.0 | 1271 | 225 | 898 | 99 | 33 | 680 | 591 | 1271 | ||||||||||||||||||||||||||||||||||||||
2033857 | 2033857 | MS | school | 2800185 | 618 | WEST BOLIVAR CONS SCHOOL DISTRICT | 280018501419 | 618018 | SHAW HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | * | 125 | * | 63.0 | 65.0 | 128 | 125 | 63 | 65 | 128 | ||||||||||||||||||||||||||||||||||||||||||||
2039382 | 2039382 | MS | school | 2804470 | 7500 | VICKSBURG WARREN SCHOOL DIST | 280447000842 | 7500028 | WARREN CENTRAL HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 601 | 652 | * | * | 15 | * | 659.0 | 621.0 | 1280 | 601 | 652 | 15 | 659 | 621 | 1280 | |||||||||||||||||||||||||||||||||||||||
2038359 | 2038359 | MS | school | 2803830 | 6100 | RANKIN CO SCHOOL DIST | 280383000737 | 6100016 | BRANDON MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 817 | 398 | * | * | 15 | 37 | 655.0 | 628.0 | 1283 | 817 | 398 | 15 | 37 | 655 | 628 | 1283 | ||||||||||||||||||||||||||||||||||||||
2035966 | 2035966 | MS | school | 2802160 | 3000 | JACKSON CO SCHOOL DIST | 280216001046 | 3000011 | ST MARTIN HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 819 | 278 | 55 | * | 111 | * | 14 | 678.0 | 606.0 | 1284 | 819 | 278 | 55 | 111 | 14 | 678 | 606 | 1284 | ||||||||||||||||||||||||||||||||||||
2036354 | 2036354 | MS | school | 2802280 | 3400 | JONES CO SCHOOL DIST | 280228000450 | 3400036 | SOUTH JONES HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2020 | pk_12_total | 940 | 222 | 88 | * | * | 27 | 636.0 | 653.0 | 1289 | 940 | 222 | 88 | 27 | 636 | 653 | 1289 | ||||||||||||||||||||||||||||||||||||||
2035016 | 2035016 | MS | school | 2801770 | 2400 | HARRISON CO SCHOOL DIST | 280177000285 | 2400008 | DIBERVILLE SENIOR HIGH SCH | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 790 | 269 | 85 | * | 92 | * | 47 | 695.0 | 595.0 | 1290 | 790 | 269 | 85 | 92 | 47 | 695 | 595 | 1290 | ||||||||||||||||||||||||||||||||||||
2036704 | 2036704 | MS | school | 2802910 | 3820 | MERIDIAN PUBLIC SCHOOL DIST | 280291000567 | 3820036 | MERIDIAN HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 57 | 1200 | 23 | * | * | * | 598.0 | 693.0 | 1291 | 57 | 1200 | 23 | 598 | 693 | 1291 | |||||||||||||||||||||||||||||||||||||||
2034382 | 2034382 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132000187 | 1700014 | HERNANDO HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 1015 | 159 | 73 | * | * | 34 | 689.0 | 609.0 | 1298 | 1015 | 159 | 73 | 34 | 689 | 609 | 1298 | ||||||||||||||||||||||||||||||||||||||
2036482 | 2036482 | MS | school | 2803450 | 3620 | OXFORD SCHOOL DISTRICT | 280345000663 | 3620012 | OXFORD HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 708 | 462 | 61 | * | 39 | * | 681.0 | 621.0 | 1302 | 708 | 462 | 61 | 39 | 681 | 621 | 1302 | ||||||||||||||||||||||||||||||||||||||
2034949 | 2034949 | MS | school | 2801740 | 2300 | HANCOCK CO SCHOOL DIST | 280174001153 | 2300008 | HANCOCK HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 1138 | 96 | 30 | * | 11 | * | 50 | 672.0 | 659.0 | 1331 | 1138 | 96 | 30 | 11 | 50 | 672 | 659 | 1331 | ||||||||||||||||||||||||||||||||||||
2034029 | 2034029 | MS | school | 2800990 | 1000 | CHOCTAW CO SCHOOL DIST | 280099000113 | 1000012 | FRENCH CAMP ELEM SCHOOL | Regular School | No | Elementary | PK | 06 | 2020 | pk_12_total | 105 | * | * | 70.0 | 64.0 | 134 | 105 | 70 | 64 | 134 | ||||||||||||||||||||||||||||||||||||||||||||
2035771 | 2035771 | MS | school | 2800197 | 2545 | AMBITION PREPARATORY | 280019701510 | 2545004 | Ambition Preparatory Charter School | Regular School | Yes | Elementary | KG | 01 | 2020 | pk_12_total | * | 132 | * | 74.0 | 61.0 | 135 | 132 | 74 | 61 | 135 | ||||||||||||||||||||||||||||||||||||||||||||
2036198 | 2036198 | MS | school | 2801380 | 3111 | EAST JASPER CONSOLIDATED SCH DIST | 280138001315 | 3111010 | HEIDELBERG JUNIOR HIGH SCHOOL | Regular School | No | Middle | 07 | 08 | 2020 | pk_12_total | * | * | 73.0 | 63.0 | 136 | 73 | 63 | 136 | ||||||||||||||||||||||||||||||||||||||||||||||
2034154 | 2034154 | MS | school | 2801110 | 1400 | COAHOMA COUNTY SCHOOL DISTRICT | 280111000141 | 1400016 | FRIARS POINT ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 06 | 2020 | pk_12_total | * | 128 | * | 67.0 | 71.0 | 138 | 128 | 67 | 71 | 138 | ||||||||||||||||||||||||||||||||||||||||||||
2038797 | 2038797 | MS | school | 2800187 | 6711 | SUNFLOWER CO CONSOLIDATE SCH DIST | 280018701418 | 6711008 | EAST SUNFLOWER SCHOOL | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 19 | 109 | * | * | 77.0 | 62.0 | 139 | 19 | 109 | 77 | 62 | 139 | ||||||||||||||||||||||||||||||||||||||||||
2036053 | 2036053 | MS | school | 2803360 | 3021 | OCEAN SPRINGS SCHOOL DIST | 280336001392 | 3021006 | OCEAN SPRINGS UPPER ELEMENTARY SCHO | Regular School | No | Middle | 04 | 06 | 2020 | pk_12_total | 1032 | 183 | 82 | * | 60 | * | 33 | 730.0 | 668.0 | 1398 | 1032 | 183 | 82 | 60 | 33 | 730 | 668 | 1398 | ||||||||||||||||||||||||||||||||||||
2034002 | 2034002 | MS | school | 2803390 | 921 | OKOLONA SEPARATE SCHOOL DIST | 280339001482 | 921012 | OKOLONA MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | * | 131 | * | * | 78.0 | 62.0 | 140 | 131 | 78 | 62 | 140 | |||||||||||||||||||||||||||||||||||||||||||
2035598 | 2035598 | MS | school | 2802190 | 2520 | JACKSON PUBLIC SCHOOL DIST | 280219000403 | 2520060 | MURRAH HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 31 | 1342 | 26 | * | * | 659.0 | 754.0 | 1413 | 31 | 1342 | 26 | 659 | 754 | 1413 | ||||||||||||||||||||||||||||||||||||||||
2034523 | 2034523 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132000979 | 1700054 | DESOTO CENTRAL MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 693 | 544 | * | * | 52 | 76 | 697.0 | 717.0 | 1414 | 693 | 544 | 52 | 76 | 697 | 717 | 1414 | ||||||||||||||||||||||||||||||||||||||
2037842 | 2037842 | MS | school | 2800189 | 5321 | STARKVILLE- OKTIBBEHA CONS SD | 280018901451 | 5321016 | STARKVILLE HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 440 | 934 | * | 43 | * | 729.0 | 704.0 | 1433 | 440 | 934 | 43 | 729 | 704 | 1433 | ||||||||||||||||||||||||||||||||||||||||
2037712 | 2037712 | MS | school | 2803060 | 5000 | NESHOBA COUNTY SCHOOL DISTRICT | 280306000611 | 5000004 | NESHOBA CENTRAL ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 910 | 261 | 11 | 114 | 13 | 131 | 742.0 | 698.0 | 1440 | 910 | 261 | 11 | 114 | 13 | 131 | 742 | 698 | 1440 | ||||||||||||||||||||||||||||||||||||
2034499 | 2034499 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132000933 | 1700048 | SOUTHAVEN MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 394 | 789 | 144 | * | 25 | * | 98 | 765.0 | 687.0 | 1452 | 394 | 789 | 144 | 25 | 98 | 765 | 687 | 1452 | ||||||||||||||||||||||||||||||||||||
2036571 | 2036571 | MS | school | 2802400 | 3700 | LAMAR COUNTY SCHOOL DISTRICT | 280240001253 | 3700021 | OAK GROVE MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 657 | 583 | 97 | * | * | 73 | 706.0 | 746.0 | 1452 | 657 | 583 | 97 | 73 | 706 | 746 | 1452 | ||||||||||||||||||||||||||||||||||||||
2037915 | 2037915 | MS | school | 2803540 | 5500 | PEARL RIVER CO SCHOOL DIST | 280354000686 | 5500004 | PEARL RIVER CENTRAL ELEMENTAR | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 1293 | 54 | 21 | * | * | 98 | 771.0 | 705.0 | 1476 | 1293 | 54 | 21 | 98 | 771 | 705 | 1476 | ||||||||||||||||||||||||||||||||||||||
2035072 | 2035072 | MS | school | 2801770 | 2400 | HARRISON CO SCHOOL DIST | 280177000296 | 2400044 | PINEVILLE ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 06 | 2020 | pk_12_total | 104 | 17 | 10 | * | * | * | 77.0 | 71.0 | 148 | 104 | 17 | 10 | 77 | 71 | 148 | |||||||||||||||||||||||||||||||||||||||
2036598 | 2036598 | MS | school | 2802400 | 3700 | LAMAR COUNTY SCHOOL DISTRICT | 280240001484 | 3700026 | LUMBERTON HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 78 | 64 | * | * | 85.0 | 65.0 | 150 | 78 | 64 | 85 | 65 | 150 | ||||||||||||||||||||||||||||||||||||||||||
2036372 | 2036372 | MS | school | 2802280 | 3400 | JONES CO SCHOOL DIST | 280228000451 | 3400052 | WEST JONES HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2020 | pk_12_total | 857 | 371 | 229 | * | * | 36 | 751.0 | 758.0 | 1509 | 857 | 371 | 229 | 36 | 751 | 758 | 1509 | ||||||||||||||||||||||||||||||||||||||
2036593 | 2036593 | MS | school | 2802400 | 3700 | LAMAR COUNTY SCHOOL DISTRICT | 280240001507 | 3700025 | LUMBERTON MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 93 | 54 | * | * | 86.0 | 66.0 | 152 | 93 | 54 | 86 | 66 | 152 | ||||||||||||||||||||||||||||||||||||||||||
2039155 | 2039155 | MS | school | 2804290 | 7200 | TUNICA COUNTY SCHOOL DISTRICT | 280429000974 | 7200014 | DUNDEE ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 146 | * | * | 80.0 | 73.0 | 153 | 146 | 80 | 73 | 153 | ||||||||||||||||||||||||||||||||||||||||||||
2037308 | 2037308 | MS | school | 2802790 | 4500 | MADISON CO SCHOOL DIST | 280279000989 | 4500014 | SHIRLEY D. SIMMONS MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | * | 152 | * | 76.0 | 78.0 | 154 | 152 | 76 | 78 | 154 | ||||||||||||||||||||||||||||||||||||||||||||
2035026 | 2035026 | MS | school | 2801770 | 2400 | HARRISON CO SCHOOL DIST | 280177000288 | 2400016 | HARRISON CENTRAL HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 654 | 771 | 69 | * | 19 | * | 30 | 795.0 | 754.0 | 1549 | 654 | 771 | 69 | 19 | 30 | 795 | 754 | 1549 | ||||||||||||||||||||||||||||||||||||
2034801 | 2034801 | MS | school | 2801560 | 2000 | GEORGE CO SCHOOL DIST | 280156000981 | 2000006 | BENNDALE ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 06 | 2020 | pk_12_total | 117 | 37 | * | * | * | 76.0 | 84.0 | 160 | 117 | 37 | 76 | 84 | 160 | |||||||||||||||||||||||||||||||||||||||||
2036415 | 2036415 | MS | school | 2802310 | 3500 | KEMPER CO SCHOOL DIST | 280231000452 | 3500004 | EAST KEMPER ATTENDANCE CENTER | Regular School | No | Elementary | PK | 06 | 2020 | pk_12_total | * | 156 | * | 81.0 | 79.0 | 160 | 156 | 81 | 79 | 160 | ||||||||||||||||||||||||||||||||||||||||||||
2039500 | 2039500 | MS | school | 2801620 | 7620 | GREENVILLE PUBLIC SCHOOLS | 280162000247 | 7620044 | MC BRIDE PRE-K ACADEMY | Regular School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | * | 156 | * | * | 71.0 | 89.0 | 160 | 156 | 71 | 89 | 160 | |||||||||||||||||||||||||||||||||||||||||||
2033841 | 2033841 | MS | school | 2800185 | 618 | WEST BOLIVAR CONS SCHOOL DISTRICT | 280018501402 | 618010 | RAY BROOKS SCHOOL | Regular School | No | Other | KG | 12 | 2020 | pk_12_total | * | 157 | * | 87.0 | 74.0 | 161 | 157 | 87 | 74 | 161 | ||||||||||||||||||||||||||||||||||||||||||||
2035618 | 2035618 | MS | school | 2802190 | 2520 | JACKSON PUBLIC SCHOOL DIST | 280219000408 | 2520066 | POWER APAC SCHOOL | Regular School | No | Other | 04 | 12 | 2020 | pk_12_total | * | 150 | * | * | 59.0 | 103.0 | 162 | 150 | 59 | 103 | 162 | |||||||||||||||||||||||||||||||||||||||||||
2034221 | 2034221 | MS | school | 2801050 | 1420 | CLARKSDALE MUNICIPAL SCHOOL DIST | 280105000126 | 1420036 | JEROME W. STAMPLEY 9TH GRADE ACADEM | Regular School | No | Secondary | 09 | 09 | 2020 | pk_12_total | * | 156 | * | 73.0 | 90.0 | 163 | 156 | 73 | 90 | 163 | ||||||||||||||||||||||||||||||||||||||||||||
2034873 | 2034873 | MS | school | 2801590 | 2100 | GREENE COUNTY SCHOOL DISTRICT | 280159000233 | 2100008 | MC LAIN ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 08 | 2020 | pk_12_total | 104 | * | * | 86.0 | 78.0 | 164 | 104 | 86 | 78 | 164 | ||||||||||||||||||||||||||||||||||||||||||||
2033820 | 2033820 | MS | school | 2800185 | 618 | WEST BOLIVAR CONS SCHOOL DISTRICT | 280018501401 | 618004 | WEST BOLIVAR DIST HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | * | 153 | * | 75.0 | 90.0 | 165 | 153 | 75 | 90 | 165 | ||||||||||||||||||||||||||||||||||||||||||||
2038820 | 2038820 | MS | school | 2800187 | 6711 | SUNFLOWER CO CONSOLIDATE SCH DIST | 280018701430 | 6711012 | INVERNESS SCHOOL | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | * | 157 | * | 82.0 | 83.0 | 165 | 157 | 82 | 83 | 165 | ||||||||||||||||||||||||||||||||||||||||||||
2034181 | 2034181 | MS | school | 2801110 | 1400 | COAHOMA COUNTY SCHOOL DISTRICT | 280111000145 | 1400048 | SHERARD ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 06 | 2020 | pk_12_total | 37 | 122 | * | * | 90.0 | 76.0 | 166 | 37 | 122 | 90 | 76 | 166 | ||||||||||||||||||||||||||||||||||||||||||
2035385 | 2035385 | MS | school | 2802190 | 2520 | JACKSON PUBLIC SCHOOL DIST | 280219000371 | 2520008 | BARR ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | * | * | 84.0 | 82.0 | 166 | 84 | 82 | 166 | ||||||||||||||||||||||||||||||||||||||||||||||
2038345 | 2038345 | MS | school | 2803830 | 6100 | RANKIN CO SCHOOL DIST | 280383001074 | 6100008 | BRANDON HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 1084 | 489 | 34 | * | * | 40 | 843.0 | 825.0 | 1668 | 1084 | 489 | 34 | 40 | 843 | 825 | 1668 | ||||||||||||||||||||||||||||||||||||||
2038664 | 2038664 | MS | school | 2803960 | 6312 | SOUTH DELTA SCHOOL DISTRICT | 280396000383 | 6312010 | SOUTH DELTA MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | * | 162 | * | * | * | 91.0 | 78.0 | 169 | 162 | 91 | 78 | 169 | ||||||||||||||||||||||||||||||||||||||||||
2038934 | 2038934 | MS | school | 2804230 | 6900 | TATE CO SCHOOL DIST | 280423001508 | 6900014 | COLDWATER HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2020 | pk_12_total | 45 | 107 | * | * | 82.0 | 87.0 | 169 | 45 | 107 | 82 | 87 | 169 |
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]);