enrollments
Data source: Big Local News · About: Big Local
882 rows where grade = "pk_12_total", state = "MS" and year = 2020 sorted by ccd_school_low_grade
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2033789 | 2033789 | MS | school | 2800750 | 614 | CLEVELAND SCHOOL DIST | 280075000085 | 614032 | PEARMAN ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 06 | 2020 | pk_12_total | 59 | 178 | 24 | * | * | 140.0 | 130.0 | 270 | 59 | 178 | 24 | 140 | 130 | 270 | ||||||||||||||||||||||||||||||||||||||||
2034106 | 2034106 | MS | school | 2800191 | 1321 | WEST POINT CONSOLIDATED SCHOOL DIST | 280019101455 | 1321006 | CHURCH HILL ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 02 | 2020 | pk_12_total | 83 | 298 | * | * | 215.0 | 176.0 | 391 | 83 | 298 | 215 | 176 | 391 | ||||||||||||||||||||||||||||||||||||||||||
2035397 | 2035397 | MS | school | 2802190 | 2520 | JACKSON PUBLIC SCHOOL DIST | 280219000373 | 2520011 | BOYD ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2020 | pk_12_total | * | 415 | 21 | * | 233.0 | 208.0 | 441 | 415 | 21 | 233 | 208 | 441 | ||||||||||||||||||||||||||||||||||||||||||
2035799 | 2035799 | MS | school | 2801189 | 2560 | MS SCH FOR THE BLIND AND DEAF | 280118901194 | 2560004 | MS SCHOOL FOR THE BLIND | Special Education School | No | Other | 01 | 12 | 2020 | pk_12_total | 11 | 29 | * | * | * | * | 20.0 | 25.0 | 45 | 11 | 29 | 20 | 25 | 45 | ||||||||||||||||||||||||||||||||||||||||
2036468 | 2036468 | MS | school | 2803450 | 3620 | OXFORD SCHOOL DISTRICT | 280345000662 | 3620008 | OXFORD ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 02 | 2020 | pk_12_total | 318 | 185 | 40 | * | 26 | * | 296.0 | 298.0 | 594 | 318 | 185 | 40 | 26 | 296 | 298 | 594 | ||||||||||||||||||||||||||||||||||||||
2037018 | 2037018 | MS | school | 2800198 | 4211 | GREENWOOD-LEFLORE CONSOLIDATED SD | 280019801515 | 4211012 | EAST ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2020 | pk_12_total | * | 324 | * | 180.0 | 163.0 | 343 | 324 | 180 | 163 | 343 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||
2038120 | 2038120 | MS | school | 2802880 | 5720 | MCCOMB SCHOOL DISTRICT | 280288001456 | 5720006 | SUMMIT ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 06 | 2020 | pk_12_total | 11 | 232 | * | * | 14 | 118.0 | 151.0 | 269 | 11 | 232 | 14 | 118 | 151 | 269 | ||||||||||||||||||||||||||||||||||||||||
2038125 | 2038125 | MS | school | 2802880 | 5720 | MCCOMB SCHOOL DISTRICT | 280288000555 | 5720008 | OTKEN ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 03 | 2020 | pk_12_total | 31 | 424 | * | * | 20 | 242.0 | 245.0 | 487 | 31 | 424 | 20 | 242 | 245 | 487 | ||||||||||||||||||||||||||||||||||||||||
2039420 | 2039420 | MS | school | 2802610 | 7612 | LELAND SCHOOL DIST | 280261000509 | 7612004 | EDNA M SCOTT ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2020 | pk_12_total | 14 | 282 | * | * | * | * | * | 142.0 | 167.0 | 309 | 14 | 282 | 142 | 167 | 309 | |||||||||||||||||||||||||||||||||||||||
2039475 | 2039475 | MS | school | 2801620 | 7620 | GREENVILLE PUBLIC SCHOOLS | 280162000236 | 7620004 | AKIN ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2020 | pk_12_total | 13 | 376 | * | * | * | * | 225.0 | 171.0 | 396 | 13 | 376 | 225 | 171 | 396 | ||||||||||||||||||||||||||||||||||||||||
2039481 | 2039481 | MS | school | 2801620 | 7620 | GREENVILLE PUBLIC SCHOOLS | 280162000237 | 7620008 | ARMSTRONG ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2020 | pk_12_total | 169 | 109.0 | 60.0 | 169 | 169 | 109 | 60 | 169 | ||||||||||||||||||||||||||||||||||||||||||||||
2039487 | 2039487 | MS | school | 2801620 | 7620 | GREENVILLE PUBLIC SCHOOLS | 280162000239 | 7620016 | BOYD ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2020 | pk_12_total | * | 355 | * | * | 190.0 | 177.0 | 367 | 355 | 190 | 177 | 367 | |||||||||||||||||||||||||||||||||||||||||||
2039507 | 2039507 | MS | school | 2801620 | 7620 | GREENVILLE PUBLIC SCHOOLS | 280162000249 | 7620052 | STERN ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2020 | pk_12_total | * | * | 128.0 | 126.0 | 254 | 128 | 126 | 254 | ||||||||||||||||||||||||||||||||||||||||||||||
2039514 | 2039514 | MS | school | 2801620 | 7620 | GREENVILLE PUBLIC SCHOOLS | 280162000250 | 7620056 | TRIGG ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2020 | pk_12_total | * | 262 | * | * | 156.0 | 112.0 | 268 | 262 | 156 | 112 | 268 | |||||||||||||||||||||||||||||||||||||||||||
2039523 | 2039523 | MS | school | 2801620 | 7620 | GREENVILLE PUBLIC SCHOOLS | 280162000252 | 7620064 | WEDDINGTON ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2020 | pk_12_total | * | * | 158.0 | 156.0 | 314 | 158 | 156 | 314 | ||||||||||||||||||||||||||||||||||||||||||||||
2033689 | 2033689 | MS | school | 2802340 | 420 | KOSCIUSKO SCHOOL DISTRICT | 280234000459 | 420012 | KOSCIUSKO MIDDLE | Regular School | No | Elementary | 02 | 03 | 2020 | pk_12_total | 120 | 206 | * | * | * | * | 175.0 | 166.0 | 341 | 120 | 206 | 175 | 166 | 341 | ||||||||||||||||||||||||||||||||||||||||
2034359 | 2034359 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132001190 | 1700008 | CHICKASAW ELEMENTARY SCHOOL | Regular School | No | Elementary | 02 | 03 | 2020 | pk_12_total | 197 | 221 | 11 | 10 | 76 | 256.0 | 259.0 | 515 | 197 | 221 | 11 | 10 | 76 | 256 | 259 | 515 | ||||||||||||||||||||||||||||||||||||||
2034386 | 2034386 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132001287 | 1700015 | HERNANDO HILLS ELEMENTARY | Regular School | No | Elementary | 02 | 03 | 2020 | pk_12_total | 521 | 69 | * | * | 63 | 343.0 | 325.0 | 668 | 521 | 69 | 63 | 343 | 325 | 668 | ||||||||||||||||||||||||||||||||||||||||
2035150 | 2035150 | MS | school | 2800630 | 2420 | BILOXI PUBLIC SCHOOL DIST | 280063000058 | 2420024 | GORENFLO ELEMENTARY SCHOOL | Regular School | No | Elementary | 02 | 04 | 2020 | pk_12_total | 35 | 149 | 69 | * | 12 | * | 145.0 | 131.0 | 276 | 35 | 149 | 69 | 12 | 145 | 131 | 276 | ||||||||||||||||||||||||||||||||||||||
2035755 | 2035755 | MS | school | 2801090 | 2521 | CLINTON PUBLIC SCHOOL DIST | 280109000136 | 2521016 | NORTHSIDE ELEM | Regular School | No | Elementary | 02 | 03 | 2020 | pk_12_total | 311 | 404 | 12 | * | 39 | * | 10 | 385.0 | 397.0 | 782 | 311 | 404 | 12 | 39 | 10 | 385 | 397 | 782 | ||||||||||||||||||||||||||||||||||||
2036503 | 2036503 | MS | school | 2802400 | 3700 | LAMAR COUNTY SCHOOL DISTRICT | 280240001314 | 3700007 | OAK GROVE LOWER ELEMENTARY | Regular School | No | Elementary | 02 | 03 | 2020 | pk_12_total | 290 | 273 | 57 | * | 19 | * | 37 | 349.0 | 330.0 | 679 | 290 | 273 | 57 | 19 | 37 | 349 | 330 | 679 | ||||||||||||||||||||||||||||||||||||
2036944 | 2036944 | MS | school | 2804320 | 4120 | TUPELO PUBLIC SCHOOL DIST | 280432000814 | 4120020 | LAWHON ELEMENTARY SCHOOL | Regular School | No | Elementary | 02 | 05 | 2020 | pk_12_total | 190 | 288 | 32 | 25 | 28 | 296.0 | 267.0 | 563 | 190 | 288 | 32 | 25 | 28 | 296 | 267 | 563 | ||||||||||||||||||||||||||||||||||||||
2037058 | 2037058 | MS | school | 2800198 | 4211 | GREENWOOD-LEFLORE CONSOLIDATED SD | 280019801521 | 4211024 | THREADGILL ELEMENTARY SCHOOL | Regular School | No | Elementary | 02 | 06 | 2020 | pk_12_total | * | * | 245.0 | 219.0 | 464 | 245 | 219 | 464 | ||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
2037883 | 2037883 | MS | school | 2804050 | 5412 | SOUTH PANOLA SCHOOL DISTRICT | 280405001089 | 5412006 | BATESVILLE INTERMEDIATE SCHOOL | Regular School | No | Elementary | 02 | 03 | 2020 | pk_12_total | 149 | 367 | * | * | 23 | 311.0 | 248.0 | 559 | 149 | 367 | 23 | 311 | 248 | 559 | ||||||||||||||||||||||||||||||||||||||||
2038354 | 2038354 | MS | school | 2803830 | 6100 | RANKIN CO SCHOOL DIST | 280383001353 | 6100012 | STONEBRIDGE ELEMENTARY | Regular School | No | Elementary | 02 | 03 | 2020 | pk_12_total | 517 | 197 | * | * | 22 | 408.0 | 355.0 | 763 | 517 | 197 | 22 | 408 | 355 | 763 | ||||||||||||||||||||||||||||||||||||||||
2038530 | 2038530 | MS | school | 2803520 | 6120 | PEARL PUBLIC SCHOOL DIST | 280352000001 | 6120004 | NORTHSIDE ELEMENTARY SCHOOL | Regular School | No | Elementary | 02 | 03 | 2020 | pk_12_total | 319 | 250 | 45 | * | * | 57 | 340.0 | 336.0 | 676 | 319 | 250 | 45 | 57 | 340 | 336 | 676 | ||||||||||||||||||||||||||||||||||||||
2039792 | 2039792 | MS | school | 2804770 | 8220 | YAZOO CITY MUNICIPAL SCHOOL DIST | 280477001260 | 8220006 | MCCOY ELEMENTARY SCHOOL | Regular School | No | Elementary | 02 | 05 | 2020 | pk_12_total | * | 782 | * | * | * | 10 | 410.0 | 393.0 | 803 | 782 | 10 | 410 | 393 | 803 | ||||||||||||||||||||||||||||||||||||||||
2033737 | 2033737 | MS | school | 2800750 | 614 | CLEVELAND SCHOOL DIST | 280075001476 | 614003 | D.M. SMITH ELEMENTARY | Regular School | No | Elementary | 03 | 06 | 2020 | pk_12_total | * | 361 | * | 199.0 | 174.0 | 373 | 361 | 199 | 174 | 373 | ||||||||||||||||||||||||||||||||||||||||||||
2033980 | 2033980 | MS | school | 2802010 | 920 | HOUSTON SCHOOL DIST | 280201000346 | 920008 | HOUSTON UPPER ELEMENTARY | Regular School | No | Elementary | 03 | 05 | 2020 | pk_12_total | 198 | 173 | 30 | * | * | 219.0 | 203.0 | 422 | 198 | 173 | 30 | 219 | 203 | 422 | ||||||||||||||||||||||||||||||||||||||||
2034096 | 2034096 | MS | school | 2803780 | 1212 | QUITMAN SCHOOL DIST | 280378000724 | 1212008 | QUITMAN UPPER ELEMENTARY SCHOOL | Regular School | No | Elementary | 03 | 05 | 2020 | pk_12_total | 175 | 190 | * | * | 193.0 | 184.0 | 377 | 175 | 190 | 193 | 184 | 377 | ||||||||||||||||||||||||||||||||||||||||||
2034121 | 2034121 | MS | school | 2800191 | 1321 | WEST POINT CONSOLIDATED SCHOOL DIST | 280019101449 | 1321016 | SOUTH SIDE ELEMENTARY SCHOOL | Regular School | No | Elementary | 03 | 04 | 2020 | pk_12_total | 85 | 321 | * | * | * | 10 | 199.0 | 225.0 | 424 | 85 | 321 | 10 | 199 | 225 | 424 | |||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
2034504 | 2034504 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132000998 | 1700050 | DESOTO CENTRAL ELEMENTARY SCHOOL | Regular School | No | Elementary | 03 | 05 | 2020 | pk_12_total | 407 | 266 | * | * | 31 | 82 | 425.0 | 383.0 | 808 | 407 | 266 | 31 | 82 | 425 | 383 | 808 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
2034756 | 2034756 | MS | school | 2803530 | 1821 | PETAL SCHOOL DIST | 280353001330 | 1821014 | PETAL ELEMENTARY | Regular School | No | Elementary | 03 | 04 | 2020 | pk_12_total | 444 | 98 | 34 | 29 | 316.0 | 289.0 | 605 | 444 | 98 | 34 | 29 | 316 | 289 | 605 | ||||||||||||||||||||||||||||||||||||||||
2034838 | 2034838 | MS | school | 2801560 | 2000 | GEORGE CO SCHOOL DIST | 280156000870 | 2000018 | LT TAYLOR INTERMEDIATE SCHOOL | Regular School | No | Middle | 03 | 07 | 2020 | pk_12_total | 182 | 72 | * | * | 13 | 147.0 | 134.0 | 281 | 182 | 72 | 13 | 147 | 134 | 281 | ||||||||||||||||||||||||||||||||||||||||
2034979 | 2034979 | MS | school | 2800570 | 2320 | BAY ST LOUIS WAVELAND SCHOOL DIST | 280057000046 | 2320012 | NORTH BAY ELEMENTARY SCHOOL | Regular School | No | Elementary | 03 | 05 | 2020 | pk_12_total | 265 | 113 | * | * | * | * | 31 | 226.0 | 192.0 | 418 | 265 | 113 | 31 | 226 | 192 | 418 | ||||||||||||||||||||||||||||||||||||||
2035302 | 2035302 | MS | school | 2801860 | 2500 | HINDS CO SCHOOL DIST | 280186000983 | 2500024 | GARY ROAD INTERMEDIATE SCHOOL | Regular School | No | Elementary | 03 | 05 | 2020 | pk_12_total | 55 | 742 | * | * | * | 421.0 | 385.0 | 806 | 55 | 742 | 421 | 385 | 806 | |||||||||||||||||||||||||||||||||||||||||
2035939 | 2035939 | MS | school | 2802160 | 3000 | JACKSON CO SCHOOL DIST | 280216001044 | 3000002 | EAST CENTRAL UPPER ELEMENTARY | Regular School | No | Elementary | 03 | 05 | 2020 | pk_12_total | 538 | 21 | * | * | * | 298.0 | 271.0 | 569 | 538 | 21 | 298 | 271 | 569 | |||||||||||||||||||||||||||||||||||||||||
2035983 | 2035983 | MS | school | 2802160 | 3000 | JACKSON CO SCHOOL DIST | 280216000368 | 3000016 | VANCLEAVE UPPER ELEMENTARY | Regular School | No | Elementary | 03 | 05 | 2020 | pk_12_total | 456 | 14 | 17 | * | * | 12 | 268.0 | 236.0 | 504 | 456 | 14 | 17 | 12 | 268 | 236 | 504 | ||||||||||||||||||||||||||||||||||||||
2036027 | 2036027 | MS | school | 2803000 | 3020 | MOSS POINT SEPARATE SCHOOL DIST | 280300000589 | 3020012 | MOSS POINT ESCATAWPA UPPER ELEM | Regular School | No | Elementary | 03 | 05 | 2020 | pk_12_total | 88 | 272 | * | * | 207.0 | 180.0 | 387 | 88 | 272 | 207 | 180 | 387 | ||||||||||||||||||||||||||||||||||||||||||
2036460 | 2036460 | MS | school | 2802370 | 3600 | LAFAYETTE CO SCHOOL DIST | 280237001280 | 3600016 | LAFAYETTE UPPER ELEMENTARY SCHOOL | Regular School | No | Elementary | 03 | 05 | 2020 | pk_12_total | 478 | 132 | 14 | * | * | 16 | 330.0 | 317.0 | 647 | 478 | 132 | 14 | 16 | 330 | 317 | 647 | ||||||||||||||||||||||||||||||||||||||
2036472 | 2036472 | MS | school | 2803450 | 3620 | OXFORD SCHOOL DISTRICT | 280345001312 | 3620010 | DELLA DAVIDSON ELEMENTARY | Regular School | No | Elementary | 03 | 04 | 2020 | pk_12_total | 327 | 199 | 50 | * | 29 | * | 338.0 | 295.0 | 633 | 327 | 199 | 50 | 29 | 338 | 295 | 633 | ||||||||||||||||||||||||||||||||||||||
2036579 | 2036579 | MS | school | 2802400 | 3700 | LAMAR COUNTY SCHOOL DISTRICT | 280240001322 | 3700023 | PURVIS UPPER ELEMENTARY | Regular School | No | Elementary | 03 | 05 | 2020 | pk_12_total | 310 | 42 | * | * | * | * | 184.0 | 180.0 | 364 | 310 | 42 | 184 | 180 | 364 | ||||||||||||||||||||||||||||||||||||||||
2036871 | 2036871 | MS | school | 2802550 | 4100 | LEE COUNTY SCHOOL DISTRICT | 280255000920 | 4100022 | SALTILLO ELEMENTARY SCHOOL | Regular School | No | Elementary | 03 | 05 | 2020 | pk_12_total | 577 | 119 | 15 | * | * | 30 | 372.0 | 379.0 | 751 | 577 | 119 | 15 | 30 | 372 | 379 | 751 | ||||||||||||||||||||||||||||||||||||||
2036882 | 2036882 | MS | school | 2802550 | 4100 | LEE COUNTY SCHOOL DISTRICT | 280255001122 | 4100026 | SHANNON ELEMENTARY SCHOOL | Regular School | No | Elementary | 03 | 05 | 2020 | pk_12_total | * | 117 | * | 113.0 | 109.0 | 222 | 117 | 113 | 109 | 222 | ||||||||||||||||||||||||||||||||||||||||||||
2036949 | 2036949 | MS | school | 2804320 | 4120 | TUPELO PUBLIC SCHOOL DIST | 280432001002 | 4120021 | LAWNDALE ELEMENTARY SCHOOL | Regular School | No | Elementary | 03 | 05 | 2020 | pk_12_total | 138 | 246 | 32 | * | * | 233.0 | 213.0 | 446 | 138 | 246 | 32 | 233 | 213 | 446 | ||||||||||||||||||||||||||||||||||||||||
2036964 | 2036964 | MS | school | 2804320 | 4120 | TUPELO PUBLIC SCHOOL DIST | 280432000816 | 4120028 | PIERCE STREET ELEMENTARY SCHOOL | Regular School | No | Elementary | 03 | 05 | 2020 | pk_12_total | 126 | 167 | * | * | 24 | 178.0 | 159.0 | 337 | 126 | 167 | 24 | 178 | 159 | 337 | ||||||||||||||||||||||||||||||||||||||||
2036968 | 2036968 | MS | school | 2804320 | 4120 | TUPELO PUBLIC SCHOOL DIST | 280432000817 | 4120032 | RANKIN ELEMENTARY SCHOOL | Regular School | No | Elementary | 03 | 05 | 2020 | pk_12_total | 130 | 187 | 27 | 10 | 22 | 192.0 | 184.0 | 376 | 130 | 187 | 27 | 10 | 22 | 192 | 184 | 376 | ||||||||||||||||||||||||||||||||||||||
2037133 | 2037133 | MS | school | 2800840 | 4320 | BROOKHAVEN SCHOOL DIST | 280084000091 | 4320008 | BROOKHAVEN ELEMENTARY SCHOOL | Regular School | No | Elementary | 03 | 04 | 2020 | pk_12_total | 130 | 248 | * | * | 11 | 202.0 | 195.0 | 397 | 130 | 248 | 11 | 202 | 195 | 397 | ||||||||||||||||||||||||||||||||||||||||
2037361 | 2037361 | MS | school | 2802790 | 4500 | MADISON CO SCHOOL DIST | 280279001007 | 4500034 | MADISON AVENUE UPPER ELEMENTARY | Regular School | No | Elementary | 03 | 05 | 2020 | pk_12_total | 345 | 78 | 14 | * | 35 | * | 246.0 | 238.0 | 484 | 345 | 78 | 14 | 35 | 246 | 238 | 484 | ||||||||||||||||||||||||||||||||||||||
2037371 | 2037371 | MS | school | 2802790 | 4500 | MADISON CO SCHOOL DIST | 280279000937 | 4500038 | HIGHLAND ELEMENTARY | Regular School | No | Elementary | 03 | 05 | 2020 | pk_12_total | 74 | 447 | 118 | 29 | * | * | 335.0 | 353.0 | 688 | 74 | 447 | 118 | 29 | 335 | 353 | 688 | ||||||||||||||||||||||||||||||||||||||
2037393 | 2037393 | MS | school | 2802790 | 4500 | MADISON CO SCHOOL DIST | 280279001439 | 4500064 | MANNSDALE UPPER ELEMENTARY | Regular School | No | Elementary | 03 | 05 | 2020 | pk_12_total | 466 | 128 | * | 27 | * | 15 | 343.0 | 305.0 | 648 | 466 | 128 | 27 | 15 | 343 | 305 | 648 | ||||||||||||||||||||||||||||||||||||||
2037495 | 2037495 | MS | school | 2801170 | 4620 | COLUMBIA SCHOOL DISTRICT | 280117000148 | 4620004 | COLUMBIA ELEMENTARY SCHOOL | Regular School | No | Elementary | 03 | 05 | 2020 | pk_12_total | 175 | 195 | * | * | * | 190.0 | 188.0 | 378 | 175 | 195 | 190 | 188 | 378 | |||||||||||||||||||||||||||||||||||||||||
2037666 | 2037666 | MS | school | 2800450 | 4821 | AMORY SCHOOL DIST | 280045000028 | 4821004 | EAST AMORY SCHOOL | Regular School | No | Elementary | 03 | 05 | 2020 | pk_12_total | 222 | 120 | * | * | * | 203.0 | 155.0 | 358 | 222 | 120 | 203 | 155 | 358 | |||||||||||||||||||||||||||||||||||||||||
2037868 | 2037868 | MS | school | 2803210 | 5411 | NORTH PANOLA SCHOOLS | 280321000629 | 5411012 | Regular School | No | Elementary | 03 | 05 | 2020 | pk_12_total | 307 | 307 | |||||||||||||||||||||||||||||||||||||||||||||||||||||
2037969 | 2037969 | MS | school | 2803630 | 5520 | PICAYUNE SCHOOL DIST | 280363000699 | 5520024 | SOUTH SIDE ELEMENTARY SCHOOL | Regular School | No | Elementary | 03 | 06 | 2020 | pk_12_total | 153 | 121 | * | * | 128.0 | 159.0 | 287 | 153 | 121 | 128 | 159 | 287 | ||||||||||||||||||||||||||||||||||||||||||
2038008 | 2038008 | MS | school | 2803720 | 5530 | POPLARVILLE SEPARATE SCHOOL DIST | 280372000710 | 5530016 | POPLARVILLE UPPER ELEMENTARY SCH | Regular School | No | Elementary | 03 | 05 | 2020 | pk_12_total | 352 | 45 | * | * | 23 | 222.0 | 200.0 | 422 | 352 | 45 | 23 | 222 | 200 | 422 | ||||||||||||||||||||||||||||||||||||||||
2038181 | 2038181 | MS | school | 2803690 | 5820 | PONTOTOC CITY SCHOOLS | 280369000704 | 5820004 | D T COX ELEMENTARY SCHOOL | Regular School | No | Elementary | 03 | 04 | 2020 | pk_12_total | 180 | 88 | 62 | * | * | 166.0 | 189.0 | 355 | 180 | 88 | 62 | 166 | 189 | 355 | ||||||||||||||||||||||||||||||||||||||||
2038370 | 2038370 | MS | school | 2803830 | 6100 | RANKIN CO SCHOOL DIST | 280383001163 | 6100018 | FLORENCE ELEMENTARY SCHOOL | Regular School | No | Elementary | 03 | 05 | 2020 | pk_12_total | 520 | 74 | * | * | * | * | * | 317.0 | 291.0 | 608 | 520 | 74 | 317 | 291 | 608 | |||||||||||||||||||||||||||||||||||||||
2038521 | 2038521 | MS | school | 2803830 | 6100 | RANKIN CO SCHOOL DIST | 280383001223 | 6100057 | RICHLAND UPPER ELEMENTARY | Regular School | No | Elementary | 03 | 06 | 2020 | pk_12_total | 318 | 153 | 60 | * | * | 294.0 | 268.0 | 562 | 318 | 153 | 60 | 294 | 268 | 562 | ||||||||||||||||||||||||||||||||||||||||
2039335 | 2039335 | MS | school | 2804470 | 7500 | VICKSBURG WARREN SCHOOL DIST | 280447000994 | 7500015 | VICKSBURG INTERMEDIATE | Regular School | No | Elementary | 03 | 06 | 2020 | pk_12_total | 61 | 429 | 13 | 10 | 276.0 | 237.0 | 513 | 61 | 429 | 13 | 10 | 276 | 237 | 513 | ||||||||||||||||||||||||||||||||||||||||
2039356 | 2039356 | MS | school | 2804470 | 7500 | VICKSBURG WARREN SCHOOL DIST | 280447000996 | 7500022 | WARREN CENTRAL INTERMEDIATE | Regular School | No | Elementary | 03 | 06 | 2020 | pk_12_total | 37 | 408 | * | * | 10 | * | 229.0 | 238.0 | 467 | 37 | 408 | 10 | 229 | 238 | 467 | |||||||||||||||||||||||||||||||||||||||
2039681 | 2039681 | MS | school | 2802700 | 8020 | LOUISVILLE MUNICIPAL SCHOOL DIST | 280270000522 | 8020006 | LOUISVILLE ELEMENTARY SCHOOL | Regular School | No | Elementary | 03 | 05 | 2020 | pk_12_total | 48 | 367 | * | * | 10 | 212.0 | 218.0 | 430 | 48 | 367 | 10 | 212 | 218 | 430 | ||||||||||||||||||||||||||||||||||||||||
2033699 | 2033699 | MS | school | 2802340 | 420 | KOSCIUSKO SCHOOL DISTRICT | 280234000461 | 420020 | KOSCIUSKO UPPER ELEM | Regular School | No | Elementary | 04 | 05 | 2020 | pk_12_total | 129 | 174 | 13 | * | * | * | 162.0 | 162.0 | 324 | 129 | 174 | 13 | 162 | 162 | 324 | |||||||||||||||||||||||||||||||||||||||
2034242 | 2034242 | MS | school | 2801220 | 1500 | COPIAH CO SCHOOL DIST | 280122000167 | 1500004 | CRYSTAL SPRINGS MIDDLE SCHOOL | Regular School | No | Middle | 04 | 08 | 2020 | pk_12_total | 52 | 506 | 47 | * | * | * | 303.0 | 310.0 | 613 | 52 | 506 | 47 | 303 | 310 | 613 | |||||||||||||||||||||||||||||||||||||||
2034391 | 2034391 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132000188 | 1700016 | OAK GROVE CENTRAL ELEMENTARY | Regular School | No | Elementary | 04 | 05 | 2020 | pk_12_total | 536 | 74 | 31 | * | * | 75 | 368.0 | 360.0 | 728 | 536 | 74 | 31 | 75 | 368 | 360 | 728 | ||||||||||||||||||||||||||||||||||||||
2034460 | 2034460 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132000932 | 1700038 | OLIVE BRANCH INTERMEDIATE SCHOOL | Regular School | No | Elementary | 04 | 05 | 2020 | pk_12_total | 215 | 222 | 18 | * | * | 60 | 280.0 | 241.0 | 521 | 215 | 222 | 18 | 60 | 280 | 241 | 521 | ||||||||||||||||||||||||||||||||||||||
2034770 | 2034770 | MS | school | 2801530 | 1900 | FRANKLIN CO SCHOOL DIST | 280153001110 | 1900006 | FRANKLIN UPPER ELEMENTARY | Regular School | No | Middle | 04 | 06 | 2020 | pk_12_total | 148 | 146 | * | * | * | 169.0 | 132.0 | 301 | 148 | 146 | 169 | 132 | 301 | |||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
2035064 | 2035064 | MS | school | 2801770 | 2400 | HARRISON CO SCHOOL DIST | 280177000295 | 2400040 | ORANGE GROVE ELEMENTARY | Regular School | No | Middle | 04 | 06 | 2020 | pk_12_total | 155 | 248 | 16 | * | * | * | 26 | 233.0 | 222.0 | 455 | 155 | 248 | 16 | 26 | 233 | 222 | 455 | |||||||||||||||||||||||||||||||||||||
2035231 | 2035231 | MS | school | 2802670 | 2422 | LONG BEACH SCHOOL DIST | 280267000517 | 2422004 | HARPER MC CAUGHAN ELEM SCHOOL | Regular School | No | Middle | 04 | 06 | 2020 | pk_12_total | 492 | 126 | 17 | * | * | 93 | 378.0 | 365.0 | 743 | 492 | 126 | 17 | 93 | 378 | 365 | 743 | ||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||
2035970 | 2035970 | MS | school | 2802160 | 3000 | JACKSON CO SCHOOL DIST | 280216001047 | 3000013 | ST MARTIN UPPER ELEMENTARY | Regular School | No | Elementary | 04 | 05 | 2020 | pk_12_total | 434 | 122 | 25 | * | 39 | * | 41 | 348.0 | 316.0 | 664 | 434 | 122 | 25 | 39 | 41 | 348 | 316 | 664 | ||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
2036387 | 2036387 | MS | school | 2802460 | 3420 | LAUREL SCHOOL DISTRICT | 280246001374 | 3420014 | LAUREL UPPER ELEMENTARY | Regular School | No | Elementary | 04 | 05 | 2020 | pk_12_total | * | 295 | 50 | * | * | * | 178.0 | 182.0 | 360 | 295 | 50 | 178 | 182 | 360 | ||||||||||||||||||||||||||||||||||||||||
2036529 | 2036529 | MS | school | 2802400 | 3700 | LAMAR COUNTY SCHOOL DISTRICT | 280240001240 | 3700011 | OAK GROVE UPPER ELEMENTARY | Regular School | No | Elementary | 04 | 05 | 2020 | pk_12_total | 316 | 252 | 47 | * | * | 23 | 353.0 | 310.0 | 663 | 316 | 252 | 47 | 23 | 353 | 310 | 663 | ||||||||||||||||||||||||||||||||||||||
2036926 | 2036926 | MS | school | 2803090 | 4111 | NETTLETON SCHOOL DIST | 280309001160 | 4111010 | NETTLETON UPPER ELEMENTARY SCHOOL | Regular School | No | Middle | 04 | 06 | 2020 | pk_12_total | 215 | 96 | * | * | 147.0 | 173.0 | 320 | 215 | 96 | 147 | 173 | 320 | ||||||||||||||||||||||||||||||||||||||||||
2037475 | 2037475 | MS | school | 2802820 | 4600 | MARION CO SCHOOL DIST | 280282001246 | 4600010 | WEST MARION ELEMENTARY | Regular School | No | Middle | 04 | 06 | 2020 | pk_12_total | 223 | 71 | * | * | 138.0 | 162.0 | 300 | 223 | 71 | 138 | 162 | 300 | ||||||||||||||||||||||||||||||||||||||||||
2037588 | 2037588 | MS | school | 2801950 | 4720 | HOLLY SPRINGS SCHOOL DIST | 280195000336 | 4720008 | HOLLY SPRINGS INTERMEDIATE SCHOOL | Regular School | No | Middle | 04 | 06 | 2020 | pk_12_total | 11 | 239 | * | * | 125.0 | 134.0 | 259 | 11 | 239 | 125 | 134 | 259 | ||||||||||||||||||||||||||||||||||||||||||
2037660 | 2037660 | MS | school | 2800360 | 4820 | ABERDEEN SCHOOL DIST | 280036001467 | 4820032 | BELLE SHIVERS MIDDLE SCHOOL | Regular School | No | Middle | 04 | 08 | 2020 | pk_12_total | 14 | 450 | * | * | 232.0 | 242.0 | 474 | 14 | 450 | 232 | 242 | 474 | ||||||||||||||||||||||||||||||||||||||||||
2037886 | 2037886 | MS | school | 2804050 | 5412 | SOUTH PANOLA SCHOOL DISTRICT | 280405001250 | 5412007 | BATESVILLE MIDDLE SCHOOL | Regular School | No | Elementary | 04 | 05 | 2020 | pk_12_total | 184 | 323 | * | * | 24 | 284.0 | 268.0 | 552 | 184 | 323 | 24 | 284 | 268 | 552 | ||||||||||||||||||||||||||||||||||||||||
2038060 | 2038060 | MS | school | 2803240 | 5711 | NORTH PIKE SCHOOL DIST | 280324001509 | 5711011 | NORTH PIKE UPPER ELEMENTARY SCHOOL | Regular School | No | Elementary | 04 | 05 | 2020 | pk_12_total | 220 | 135 | * | * | * | 195.0 | 173.0 | 368 | 220 | 135 | 195 | 173 | 368 | |||||||||||||||||||||||||||||||||||||||||
2038083 | 2038083 | MS | school | 2804080 | 5712 | SOUTH PIKE SCHOOL DIST | 280408000769 | 5712012 | EVA GORDON UPPER ELEMENTARY SCHOOL | Regular School | No | Middle | 04 | 06 | 2020 | pk_12_total | 27 | 265 | * | * | * | 154.0 | 149.0 | 303 | 27 | 265 | 154 | 149 | 303 | |||||||||||||||||||||||||||||||||||||||||
2038113 | 2038113 | MS | school | 2802880 | 5720 | MCCOMB SCHOOL DISTRICT | 280288000554 | 5720004 | MCCOMB MIDDLE SCHOOL | Regular School | No | Middle | 04 | 06 | 2020 | pk_12_total | 19 | 386 | * | * | 16 | 233.0 | 200.0 | 433 | 19 | 386 | 16 | 233 | 200 | 433 | ||||||||||||||||||||||||||||||||||||||||
2038339 | 2038339 | MS | school | 2803830 | 6100 | RANKIN CO SCHOOL DIST | 280383000736 | 6100006 | BRANDON ELEMENTARY SCHOOL | Regular School | No | Elementary | 04 | 05 | 2020 | pk_12_total | 510 | 250 | 10 | * | * | 23 | 412.0 | 389.0 | 801 | 510 | 250 | 10 | 23 | 412 | 389 | 801 | ||||||||||||||||||||||||||||||||||||||
2038537 | 2038537 | MS | school | 2803520 | 6120 | PEARL PUBLIC SCHOOL DIST | 280352001181 | 6120010 | PEARL UPPER SCHOOL | Regular School | No | Elementary | 04 | 05 | 2020 | pk_12_total | 305 | 275 | 46 | * | * | 37 | 348.0 | 327.0 | 675 | 305 | 275 | 46 | 37 | 348 | 327 | 675 | ||||||||||||||||||||||||||||||||||||||
2038789 | 2038789 | MS | school | 2800187 | 6711 | SUNFLOWER CO CONSOLIDATE SCH DIST | 280018701433 | 6711006 | CARVER ELEMENTARY SCHOOL | Regular School | No | Middle | 04 | 06 | 2020 | pk_12_total | * | 382 | * | * | 195.0 | 203.0 | 398 | 382 | 195 | 203 | 398 | |||||||||||||||||||||||||||||||||||||||||||
2039285 | 2039285 | MS | school | 2804440 | 7400 | WALTHALL CO SCHOOL DIST | 280444000835 | 7400012 | TYLERTOWN ELEMENTARY SCHOOL | Regular School | No | Middle | 04 | 06 | 2020 | pk_12_total | 47 | 211 | * | * | 140.0 | 134.0 | 274 | 47 | 211 | 140 | 134 | 274 | ||||||||||||||||||||||||||||||||||||||||||
2033573 | 2033573 | MS | school | 2800390 | 200 | ALCORN SCHOOL DIST | 280039001188 | 200010 | ALCORN CENTRAL MIDDLE SCHOOL | Regular School | No | Middle | 05 | 08 | 2020 | pk_12_total | 377 | * | * | * | 12 | 226.0 | 175.0 | 401 | 377 | 12 | 226 | 175 | 401 | |||||||||||||||||||||||||||||||||||||||||
2033590 | 2033590 | MS | school | 2800390 | 200 | ALCORN SCHOOL DIST | 280039001566 | 200023 | KOSSUTH MIDDLE SCHOOL | Regular School | No | Middle | 05 | 08 | 2020 | pk_12_total | 428 | * | * | * | 207.0 | 236.0 | 443 | 428 | 207 | 236 | 443 | |||||||||||||||||||||||||||||||||||||||||||
2033619 | 2033619 | MS | school | 2801260 | 220 | CORINTH SCHOOL DIST | 280126000006 | 220006 | CORINTH MIDDLE SCHOOL | Regular School | No | Middle | 05 | 08 | 2020 | pk_12_total | 423 | 236 | 88 | 11 | 42 | 405.0 | 395.0 | 800 | 423 | 236 | 88 | 11 | 42 | 405 | 395 | 800 | ||||||||||||||||||||||||||||||||||||||
2033825 | 2033825 | MS | school | 2800185 | 618 | WEST BOLIVAR CONS SCHOOL DISTRICT | 280018501432 | 618008 | WEST BOLIVAR DISTRICT MIDDLE SCHOOL | Regular School | No | Middle | 05 | 08 | 2020 | pk_12_total | * | 167 | * | * | 94.0 | 82.0 | 176 | 167 | 94 | 82 | 176 | |||||||||||||||||||||||||||||||||||||||||||
2033884 | 2033884 | MS | school | 2800870 | 700 | CALHOUN CO SCHOOL DIST | 280087000097 | 700006 | BRUCE HIGH SCHOOL | Regular School | No | High | 05 | 12 | 2020 | pk_12_total | 330 | 167 | 19 | * | * | 265.0 | 260.0 | 525 | 330 | 167 | 19 | 265 | 260 | 525 | ||||||||||||||||||||||||||||||||||||||||
2033905 | 2033905 | MS | school | 2800870 | 700 | CALHOUN CO SCHOOL DIST | 280087000098 | 700010 | CALHOUN CITY HIGH SCHOOL | Regular School | No | High | 05 | 12 | 2020 | pk_12_total | 214 | 239 | * | * | 24 | 283.0 | 211.0 | 494 | 214 | 239 | 24 | 283 | 211 | 494 | ||||||||||||||||||||||||||||||||||||||||
2034064 | 2034064 | MS | school | 2801440 | 1211 | ENTERPRISE SCHOOL DIST | 280144000977 | 1211002 | ENTERPRISE MIDDLE SCHOOL | Regular School | No | Middle | 05 | 08 | 2020 | pk_12_total | 252 | 29 | * | * | * | * | 143.0 | 147.0 | 290 | 252 | 29 | 143 | 147 | 290 |
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]);