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_high_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2033685 | 2033685 | MS | school | 2802340 | 420 | KOSCIUSKO SCHOOL DISTRICT | 280234000458 | 420008 | KOSCIUSKO LOWER ELEM | Regular School | No | Elementary | PK | 01 | 2020 | pk_12_total | 188 | 257 | 12 | * | * | * | 234.0 | 234.0 | 468 | 188 | 257 | 12 | 234 | 234 | 468 | |||||||||||||||||||||||||||||||||||||||
2034375 | 2034375 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132000186 | 1700012 | HERNANDO ELEM | Regular School | No | Elementary | KG | 01 | 2020 | pk_12_total | 563 | 58 | * | * | 57 | 364.0 | 346.0 | 710 | 563 | 58 | 57 | 364 | 346 | 710 | ||||||||||||||||||||||||||||||||||||||||
2034437 | 2034437 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132000192 | 1700030 | OLIVE BRANCH ELEM | Regular School | No | Elementary | PK | 01 | 2020 | pk_12_total | 273 | 239 | * | * | 90 | 313.0 | 303.0 | 616 | 273 | 239 | 90 | 313 | 303 | 616 | ||||||||||||||||||||||||||||||||||||||||
2035156 | 2035156 | MS | school | 2800630 | 2420 | BILOXI PUBLIC SCHOOL DIST | 280063001263 | 2420042 | NICHOLS ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 01 | 2020 | pk_12_total | 67 | 151 | 87 | * | * | * | 28 | 167.0 | 173.0 | 340 | 67 | 151 | 87 | 28 | 167 | 173 | 340 | |||||||||||||||||||||||||||||||||||||
2035744 | 2035744 | MS | school | 2801090 | 2521 | CLINTON PUBLIC SCHOOL DIST | 280109000133 | 2521012 | CLINTON PARK ELEM SCHOOL | Regular School | No | Elementary | PK | 01 | 2020 | pk_12_total | 277 | 380 | 18 | * | 66 | * | 40 | 448.0 | 337.0 | 785 | 277 | 380 | 18 | 66 | 40 | 448 | 337 | 785 | ||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
2036464 | 2036464 | MS | school | 2803450 | 3620 | OXFORD SCHOOL DISTRICT | 280345000661 | 3620004 | BRAMLETT ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 01 | 2020 | pk_12_total | 292 | 170 | 56 | * | 37 | * | 39 | 291.0 | 306.0 | 597 | 292 | 170 | 56 | 37 | 39 | 291 | 306 | 597 | ||||||||||||||||||||||||||||||||||||
2036519 | 2036519 | MS | school | 2802400 | 3700 | LAMAR COUNTY SCHOOL DISTRICT | 280240001239 | 3700009 | OAK GROVE PRIMARY | Regular School | No | Elementary | PK | 01 | 2020 | pk_12_total | 342 | 300 | 46 | * | * | 45 | 382.0 | 369.0 | 751 | 342 | 300 | 46 | 45 | 382 | 369 | 751 | ||||||||||||||||||||||||||||||||||||||
2036929 | 2036929 | MS | school | 2804320 | 4120 | TUPELO PUBLIC SCHOOL DIST | 280432001001 | 4120007 | CARVER ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 01 | 2020 | pk_12_total | 72 | 166 | 12 | 11 | 19 | 141.0 | 139.0 | 280 | 72 | 166 | 12 | 11 | 19 | 141 | 139 | 280 | ||||||||||||||||||||||||||||||||||||||
2037030 | 2037030 | MS | school | 2800198 | 4211 | GREENWOOD-LEFLORE CONSOLIDATED SD | 280019801517 | 4211019 | THREADGILL PRIMARY SCHOOL | Regular School | No | Elementary | PK | 01 | 2020 | pk_12_total | * | 254 | * | 123.0 | 137.0 | 260 | 254 | 123 | 137 | 260 | ||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||
2037879 | 2037879 | MS | school | 2804050 | 5412 | SOUTH PANOLA SCHOOL DISTRICT | 280405000763 | 5412004 | BATESVILLE ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 01 | 2020 | pk_12_total | 245 | 374 | * | * | 25 | 364.0 | 299.0 | 663 | 245 | 374 | 25 | 364 | 299 | 663 | ||||||||||||||||||||||||||||||||||||||||
2038350 | 2038350 | MS | school | 2803830 | 6100 | RANKIN CO SCHOOL DIST | 280383000954 | 6100010 | ROUSE ELEMENTARY | Regular School | No | Elementary | KG | 01 | 2020 | pk_12_total | 515 | 211 | 10 | * | * | 29 | 399.0 | 379.0 | 778 | 515 | 211 | 10 | 29 | 399 | 379 | 778 | ||||||||||||||||||||||||||||||||||||||
2038534 | 2038534 | MS | school | 2803520 | 6120 | PEARL PUBLIC SCHOOL DIST | 280352000002 | 6120008 | PEARL LOWER ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 01 | 2020 | pk_12_total | 401 | 236 | 60 | * | * | * | 50 | 373.0 | 388.0 | 761 | 401 | 236 | 60 | 50 | 373 | 388 | 761 | |||||||||||||||||||||||||||||||||||||
2039797 | 2039797 | MS | school | 2804770 | 8220 | YAZOO CITY MUNICIPAL SCHOOL DIST | 280477000886 | 8220012 | WEBSTER STREET ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 01 | 2020 | pk_12_total | * | 384 | * | * | 174.0 | 220.0 | 394 | 384 | 174 | 220 | 394 | |||||||||||||||||||||||||||||||||||||||||||
2033772 | 2033772 | MS | school | 2800750 | 614 | CLEVELAND SCHOOL DIST | 280075000083 | 614024 | NAILOR ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2020 | pk_12_total | * | 320 | * | 160.0 | 170.0 | 330 | 320 | 160 | 170 | 330 | ||||||||||||||||||||||||||||||||||||||||||||
2033969 | 2033969 | MS | school | 2802010 | 920 | HOUSTON SCHOOL DIST | 280201000344 | 920004 | HOUSTON LOWER ELEMENTARY | Regular School | No | Elementary | PK | 02 | 2020 | pk_12_total | 207 | 178 | 39 | * | * | 246.0 | 190.0 | 436 | 207 | 178 | 39 | 246 | 190 | 436 | ||||||||||||||||||||||||||||||||||||||||
2034091 | 2034091 | MS | school | 2803780 | 1212 | QUITMAN SCHOOL DIST | 280378001142 | 1212006 | QUITMAN LOWER ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2020 | pk_12_total | 229 | 207 | * | * | * | 222.0 | 224.0 | 446 | 229 | 207 | 222 | 224 | 446 | |||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||
2034404 | 2034404 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132000189 | 1700020 | HORN LAKE ELEM | Regular School | No | Elementary | PK | 02 | 2020 | pk_12_total | 107 | 300 | * | * | 88 | 254.0 | 258.0 | 512 | 107 | 300 | 88 | 254 | 258 | 512 | ||||||||||||||||||||||||||||||||||||||||
2034456 | 2034456 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132001191 | 1700036 | SHADOW OAKS ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 02 | 2020 | pk_12_total | 94 | 285 | * | * | * | 58 | 218.0 | 230.0 | 448 | 94 | 285 | 58 | 218 | 230 | 448 | |||||||||||||||||||||||||||||||||||||||
2034482 | 2034482 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132000197 | 1700044 | HOPE SULLIVAN ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 02 | 2020 | pk_12_total | 187 | 265 | 58 | * | * | 78 | 316.0 | 280.0 | 596 | 187 | 265 | 58 | 78 | 316 | 280 | 596 | ||||||||||||||||||||||||||||||||||||||
2034489 | 2034489 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132000185 | 1700046 | GREENBROOK ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 02 | 2020 | pk_12_total | 197 | 223 | 23 | * | * | 89 | 280.0 | 265.0 | 545 | 197 | 223 | 23 | 89 | 280 | 265 | 545 | ||||||||||||||||||||||||||||||||||||||
2034511 | 2034511 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132001369 | 1700051 | DESOTO CENTRAL PRIMARY | Regular School | No | Elementary | KG | 02 | 2020 | pk_12_total | 372 | 221 | * | * | 33 | * | 110 | 385.0 | 357.0 | 742 | 372 | 221 | 33 | 110 | 385 | 357 | 742 | |||||||||||||||||||||||||||||||||||||
2034547 | 2034547 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132001373 | 1700061 | LEWISBURG PRIMARY | Regular School | No | Elementary | PK | 02 | 2020 | pk_12_total | 645 | 61 | * | 10 | * | 51 | 382.0 | 392.0 | 774 | 645 | 61 | 10 | 51 | 382 | 392 | 774 | ||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||
2034984 | 2034984 | MS | school | 2800570 | 2320 | BAY ST LOUIS WAVELAND SCHOOL DIST | 280057001376 | 2320016 | WAVELAND ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 02 | 2020 | pk_12_total | 271 | 102 | * | * | 21 | 200.0 | 198.0 | 398 | 271 | 102 | 21 | 200 | 198 | 398 | ||||||||||||||||||||||||||||||||||||||||
2035297 | 2035297 | MS | school | 2801860 | 2500 | HINDS CO SCHOOL DIST | 280186001036 | 2500020 | GARY ROAD ELEMENTARY | Regular School | No | Elementary | PK | 02 | 2020 | pk_12_total | 57 | 732 | * | * | * | 15 | 401.0 | 413.0 | 814 | 57 | 732 | 15 | 401 | 413 | 814 | |||||||||||||||||||||||||||||||||||||||
2035352 | 2035352 | MS | school | 2800193 | 2505 | JOEL E. SMILOW COLLEGIATE | 280019301502 | 2505004 | Joel E Smilow Collegiate | Regular School | Yes | Elementary | KG | 02 | 2020 | pk_12_total | 351 | * | * | * | 186.0 | 171.0 | 357 | 351 | 186 | 171 | 357 | |||||||||||||||||||||||||||||||||||||||||||
2036002 | 2036002 | MS | school | 2802160 | 3000 | JACKSON CO SCHOOL DIST | 280216000962 | 3000022 | EAST CENTRAL LOWER ELEMENTARY | Regular School | No | Elementary | PK | 02 | 2020 | pk_12_total | 514 | 15 | * | * | 10 | 296.0 | 252.0 | 548 | 514 | 15 | 10 | 296 | 252 | 548 | ||||||||||||||||||||||||||||||||||||||||
2036016 | 2036016 | MS | school | 2802160 | 3000 | JACKSON CO SCHOOL DIST | 280216000964 | 3000026 | VANCLEAVE LOWER ELEMENTARY | Regular School | No | Elementary | PK | 02 | 2020 | pk_12_total | 490 | 12 | 14 | * | * | * | 16 | 302.0 | 233.0 | 535 | 490 | 12 | 14 | 16 | 302 | 233 | 535 | |||||||||||||||||||||||||||||||||||||
2036035 | 2036035 | MS | school | 2803000 | 3020 | MOSS POINT SEPARATE SCHOOL DIST | 280300000591 | 3020020 | MOSS POINT KREOLE PRIMARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2020 | pk_12_total | 72 | 270 | 25 | * | * | 202.0 | 181.0 | 383 | 72 | 270 | 25 | 202 | 181 | 383 | ||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
2036543 | 2036543 | MS | school | 2802400 | 3700 | LAMAR COUNTY SCHOOL DISTRICT | 280240000968 | 3700015 | PURVIS LOWER ELEMENTARY | Regular School | No | Elementary | PK | 02 | 2020 | pk_12_total | 374 | 47 | * | * | * | 14 | 247.0 | 194.0 | 441 | 374 | 47 | 14 | 247 | 194 | 441 | |||||||||||||||||||||||||||||||||||||||
2036866 | 2036866 | MS | school | 2802550 | 4100 | LEE COUNTY SCHOOL DISTRICT | 280255001265 | 4100020 | SALTILLO PRIMARY SCHOOL | Regular School | No | Elementary | KG | 02 | 2020 | pk_12_total | 567 | 80 | 11 | 11 | 58 | 363.0 | 364.0 | 727 | 567 | 80 | 11 | 11 | 58 | 363 | 364 | 727 | ||||||||||||||||||||||||||||||||||||||
2036899 | 2036899 | MS | school | 2802550 | 4100 | LEE COUNTY SCHOOL DISTRICT | 280255001266 | 4100030 | SHANNON PRIMARY SCHOOL | Regular School | No | Elementary | KG | 02 | 2020 | pk_12_total | 103 | 116 | * | * | 127.0 | 110.0 | 237 | 103 | 116 | 127 | 110 | 237 | ||||||||||||||||||||||||||||||||||||||||||
2036935 | 2036935 | MS | school | 2804320 | 4120 | TUPELO PUBLIC SCHOOL DIST | 280432000813 | 4120016 | JOYNER ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 02 | 2020 | pk_12_total | 140 | 210 | 30 | * | 10 | * | 198.0 | 204.0 | 402 | 140 | 210 | 30 | 10 | 198 | 204 | 402 | ||||||||||||||||||||||||||||||||||||||
2036959 | 2036959 | MS | school | 2804320 | 4120 | TUPELO PUBLIC SCHOOL DIST | 280432001256 | 4120027 | PARKWAY ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 02 | 2020 | pk_12_total | 112 | 236 | 32 | * | * | 210.0 | 199.0 | 409 | 112 | 236 | 32 | 210 | 199 | 409 | ||||||||||||||||||||||||||||||||||||||||
2036974 | 2036974 | MS | school | 2804320 | 4120 | TUPELO PUBLIC SCHOOL DIST | 280432000818 | 4120036 | THOMAS STREET ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 02 | 2020 | pk_12_total | 128 | 210 | 30 | * | * | 179.0 | 210.0 | 389 | 128 | 210 | 30 | 179 | 210 | 389 | ||||||||||||||||||||||||||||||||||||||||
2037051 | 2037051 | MS | school | 2800198 | 4211 | GREENWOOD-LEFLORE CONSOLIDATED SD | 280019801520 | 4211022 | CLAUDINE F BROWN ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2020 | pk_12_total | * | 288 | 15 | * | 158.0 | 151.0 | 309 | 288 | 15 | 158 | 151 | 309 | ||||||||||||||||||||||||||||||||||||||||||
2037150 | 2037150 | MS | school | 2800840 | 4320 | BROOKHAVEN SCHOOL DIST | 280084000095 | 4320020 | MAMIE MARTIN ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2020 | pk_12_total | 248 | 441 | * | * | * | 37 | 371.0 | 365.0 | 736 | 248 | 441 | 37 | 371 | 365 | 736 | |||||||||||||||||||||||||||||||||||||||
2037334 | 2037334 | MS | school | 2802790 | 4500 | MADISON CO SCHOOL DIST | 280279001081 | 4500024 | ANN SMITH ELEMENTARY | Regular School | No | Elementary | PK | 02 | 2020 | pk_12_total | 90 | 437 | 165 | * | 41 | * | 384.0 | 373.0 | 757 | 90 | 437 | 165 | 41 | 384 | 373 | 757 | ||||||||||||||||||||||||||||||||||||||
2037356 | 2037356 | MS | school | 2802790 | 4500 | MADISON CO SCHOOL DIST | 280279001219 | 4500032 | MADISON AVENUE LOWER ELEMENTARY | Regular School | No | Elementary | KG | 02 | 2020 | pk_12_total | 354 | 66 | 11 | 26 | 13 | 219.0 | 251.0 | 470 | 354 | 66 | 11 | 26 | 13 | 219 | 251 | 470 | ||||||||||||||||||||||||||||||||||||||
2037388 | 2037388 | MS | school | 2802790 | 4500 | MADISON CO SCHOOL DIST | 280279001350 | 4500062 | MANNSDALE ELEMENTARY | Regular School | No | Elementary | KG | 02 | 2020 | pk_12_total | 484 | 110 | * | * | 30 | 13 | 332.0 | 317.0 | 649 | 484 | 110 | 30 | 13 | 332 | 317 | 649 | ||||||||||||||||||||||||||||||||||||||
2037506 | 2037506 | MS | school | 2801170 | 4620 | COLUMBIA SCHOOL DISTRICT | 280117000150 | 4620012 | COLUMBIA PRIMARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2020 | pk_12_total | 216 | 178 | 13 | * | * | 228.0 | 190.0 | 418 | 216 | 178 | 13 | 228 | 190 | 418 | ||||||||||||||||||||||||||||||||||||||||
2037682 | 2037682 | MS | school | 2800450 | 4821 | AMORY SCHOOL DIST | 280045000032 | 4821016 | WEST AMORY SCHOOL | Regular School | No | Elementary | KG | 02 | 2020 | pk_12_total | 232 | 142 | * | * | * | 192.0 | 197.0 | 389 | 232 | 142 | 192 | 197 | 389 | |||||||||||||||||||||||||||||||||||||||||
2037860 | 2037860 | MS | school | 2803210 | 5411 | NORTH PANOLA SCHOOLS | 280321000627 | 5411004 | COMO PRIMARY | Regular School | No | Elementary | PK | 02 | 2020 | pk_12_total | 12 | 357 | * | * | 197.0 | 178.0 | 375 | 12 | 357 | 197 | 178 | 375 | ||||||||||||||||||||||||||||||||||||||||||
2037977 | 2037977 | MS | school | 2803630 | 5520 | PICAYUNE SCHOOL DIST | 280363000632 | 5520026 | SOUTH SIDE LOWER ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2020 | pk_12_total | 167 | 102 | * | * | 17 | 153.0 | 135.0 | 288 | 167 | 102 | 17 | 153 | 135 | 288 | ||||||||||||||||||||||||||||||||||||||||
2038003 | 2038003 | MS | school | 2803720 | 5530 | POPLARVILLE SEPARATE SCHOOL DIST | 280372000709 | 5530012 | POPLARVILLE LOWER ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 02 | 2020 | pk_12_total | 348 | 48 | * | * | 29 | 223.0 | 205.0 | 428 | 348 | 48 | 29 | 223 | 205 | 428 | ||||||||||||||||||||||||||||||||||||||||
2038188 | 2038188 | MS | school | 2803690 | 5820 | PONTOTOC CITY SCHOOLS | 280369000705 | 5820008 | PONTOTOC ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 02 | 2020 | pk_12_total | 304 | 126 | 80 | * | * | 23 | 265.0 | 277.0 | 542 | 304 | 126 | 80 | 23 | 265 | 277 | 542 | ||||||||||||||||||||||||||||||||||||||
2038365 | 2038365 | MS | school | 2803830 | 6100 | RANKIN CO SCHOOL DIST | 280383001277 | 6100017 | STEEN'S CREEK ELEMENTARY | Regular School | No | Elementary | KG | 02 | 2020 | pk_12_total | 492 | 77 | * | * | * | 306.0 | 277.0 | 583 | 492 | 77 | 306 | 277 | 583 | |||||||||||||||||||||||||||||||||||||||||
2038527 | 2038527 | MS | school | 2803830 | 6100 | RANKIN CO SCHOOL DIST | 280383001143 | 6100058 | RICHLAND ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2020 | pk_12_total | 224 | 101 | 55 | 11 | 36 | 210.0 | 217.0 | 427 | 224 | 101 | 55 | 11 | 36 | 210 | 217 | 427 | ||||||||||||||||||||||||||||||||||||||
2039329 | 2039329 | MS | school | 2804470 | 7500 | VICKSBURG WARREN SCHOOL DIST | 280447000993 | 7500014 | DANA ROAD ELEMENTARY | Regular School | No | Elementary | PK | 02 | 2020 | pk_12_total | 56 | 376 | * | * | * | 16 | 249.0 | 207.0 | 456 | 56 | 376 | 16 | 249 | 207 | 456 | |||||||||||||||||||||||||||||||||||||||
2039676 | 2039676 | MS | school | 2802700 | 8020 | LOUISVILLE MUNICIPAL SCHOOL DIST | 280270001156 | 8020004 | FAIR ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2020 | pk_12_total | 52 | 301 | * | * | 11 | 194.0 | 174.0 | 368 | 52 | 301 | 11 | 194 | 174 | 368 | ||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||
2034235 | 2034235 | MS | school | 2800194 | 1425 | CLARKSDALE COLLEGIATE | 280019401492 | 1425004 | CLARKSDALE COLLEGIATE | Regular School | Yes | Elementary | KG | 03 | 2020 | pk_12_total | 16 | 227 | * | * | 104.0 | 143.0 | 247 | 16 | 227 | 104 | 143 | 247 | ||||||||||||||||||||||||||||||||||||||||||
2034248 | 2034248 | MS | school | 2801220 | 1500 | COPIAH CO SCHOOL DIST | 280122001189 | 1500006 | CRYSTAL SPRINGS ELEMENTARY | Regular School | No | Elementary | KG | 03 | 2020 | pk_12_total | 59 | 361 | 38 | * | * | 248.0 | 219.0 | 467 | 59 | 361 | 38 | 248 | 219 | 467 | ||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||
2034765 | 2034765 | MS | school | 2801530 | 1900 | FRANKLIN CO SCHOOL DIST | 280153000223 | 1900004 | FRANKLIN LOWER ELEMENTARY | Regular School | No | Elementary | PK | 03 | 2020 | pk_12_total | 234 | 177 | * | * | 15 | 220.0 | 212.0 | 432 | 234 | 177 | 15 | 220 | 212 | 432 | ||||||||||||||||||||||||||||||||||||||||
2034997 | 2034997 | MS | school | 2801770 | 2400 | HARRISON CO SCHOOL DIST | 280177000284 | 2400003 | DIBERVILLE ELEM | Regular School | No | Elementary | KG | 03 | 2020 | pk_12_total | 329 | 180 | 61 | * | 69 | * | 78 | 358.0 | 363.0 | 721 | 329 | 180 | 61 | 69 | 78 | 358 | 363 | 721 | ||||||||||||||||||||||||||||||||||||
2035021 | 2035021 | MS | school | 2801770 | 2400 | HARRISON CO SCHOOL DIST | 280177000287 | 2400012 | HARRISON CENTRAL ELEMENTARY | Regular School | No | Elementary | KG | 03 | 2020 | pk_12_total | 215 | 289 | 23 | * | * | * | 41 | 292.0 | 286.0 | 578 | 215 | 289 | 23 | 41 | 292 | 286 | 578 | |||||||||||||||||||||||||||||||||||||
2035237 | 2035237 | MS | school | 2802670 | 2422 | LONG BEACH SCHOOL DIST | 280267000518 | 2422008 | THOMAS L REEVES ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 03 | 2020 | pk_12_total | 285 | 61 | * | * | 68 | 206.0 | 221.0 | 427 | 285 | 61 | 68 | 206 | 221 | 427 | ||||||||||||||||||||||||||||||||||||||||
2035253 | 2035253 | MS | school | 2802670 | 2422 | LONG BEACH SCHOOL DIST | 280267000521 | 2422020 | WJ QUARLES ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 03 | 2020 | pk_12_total | 285 | 92 | * | * | 19 | * | 84 | 252.0 | 237.0 | 489 | 285 | 92 | 19 | 84 | 252 | 237 | 489 | |||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
2035960 | 2035960 | MS | school | 2802160 | 3000 | JACKSON CO SCHOOL DIST | 280216000366 | 3000010 | ST MARTIN N ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 03 | 2020 | pk_12_total | 377 | 109 | * | 34 | * | 44 | 334.0 | 261.0 | 595 | 377 | 109 | 34 | 44 | 334 | 261 | 595 | ||||||||||||||||||||||||||||||||||||||
2035978 | 2035978 | MS | school | 2802160 | 3000 | JACKSON CO SCHOOL DIST | 280216001048 | 3000014 | ST MARTIN EAST ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 03 | 2020 | pk_12_total | 457 | 105 | * | * | 36 | 54 | 351.0 | 332.0 | 683 | 457 | 105 | 36 | 54 | 351 | 332 | 683 | ||||||||||||||||||||||||||||||||||||||
2036048 | 2036048 | MS | school | 2803360 | 3021 | OCEAN SPRINGS SCHOOL DIST | 280336000647 | 3021004 | OAK PARK ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 03 | 2020 | pk_12_total | 437 | 61 | 23 | * | 19 | * | 10 | 297.0 | 257.0 | 554 | 437 | 61 | 23 | 19 | 10 | 297 | 257 | 554 | ||||||||||||||||||||||||||||||||||||
2036060 | 2036060 | MS | school | 2803360 | 3021 | OCEAN SPRINGS SCHOOL DIST | 280336000648 | 3021008 | MAGNOLIA PARK ELEMENTARY | Regular School | No | Elementary | KG | 03 | 2020 | pk_12_total | 517 | 92 | 40 | * | * | * | * | 336.0 | 334.0 | 670 | 517 | 92 | 40 | 336 | 334 | 670 | ||||||||||||||||||||||||||||||||||||||
2036077 | 2036077 | MS | school | 2803360 | 3021 | OCEAN SPRINGS SCHOOL DIST | 280336000652 | 3021024 | PECAN PARK ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 03 | 2020 | pk_12_total | 397 | 80 | 29 | * | 18 | * | 32 | 297.0 | 264.0 | 561 | 397 | 80 | 29 | 18 | 32 | 297 | 264 | 561 | ||||||||||||||||||||||||||||||||||||
2036395 | 2036395 | MS | school | 2802460 | 3420 | LAUREL SCHOOL DISTRICT | 280246000476 | 3420020 | MASON ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 03 | 2020 | pk_12_total | 24 | 290 | 66 | * | * | 13 | 216.0 | 183.0 | 399 | 24 | 290 | 66 | 13 | 216 | 183 | 399 | ||||||||||||||||||||||||||||||||||||||
2036401 | 2036401 | MS | school | 2802460 | 3420 | LAUREL SCHOOL DISTRICT | 280246000477 | 3420024 | OAK PARK ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 03 | 2020 | pk_12_total | 10 | 513 | 62 | * | * | 295.0 | 296.0 | 591 | 10 | 513 | 62 | 295 | 296 | 591 | ||||||||||||||||||||||||||||||||||||||||
2036443 | 2036443 | MS | school | 2802370 | 3600 | LAFAYETTE CO SCHOOL DIST | 280237000462 | 3600004 | LAFAYETTE ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 03 | 2020 | pk_12_total | 517 | 114 | * | * | 24 | 330.0 | 339.0 | 669 | 517 | 114 | 24 | 330 | 339 | 669 | ||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
2036921 | 2036921 | MS | school | 2803090 | 4111 | NETTLETON SCHOOL DIST | 280309000614 | 4111008 | NETTLETON PRIMARY SCHOOL | Regular School | No | Elementary | KG | 03 | 2020 | pk_12_total | 255 | 110 | * | * | 208.0 | 167.0 | 375 | 255 | 110 | 208 | 167 | 375 | ||||||||||||||||||||||||||||||||||||||||||
2037490 | 2037490 | MS | school | 2802820 | 4600 | MARION CO SCHOOL DIST | 280282001060 | 4600016 | WEST MARION PRIMARY SCHOOL | Regular School | No | Elementary | PK | 03 | 2020 | pk_12_total | 299 | 66 | 11 | 11 | 192.0 | 195.0 | 387 | 299 | 66 | 11 | 11 | 192 | 195 | 387 | ||||||||||||||||||||||||||||||||||||||||
2037594 | 2037594 | MS | school | 2801950 | 4720 | HOLLY SPRINGS SCHOOL DIST | 280195000337 | 4720012 | HOLLY SPRINGS PRIMARY SCHOOL | Regular School | No | Elementary | PK | 03 | 2020 | pk_12_total | 27 | 358 | * | * | * | 192.0 | 204.0 | 396 | 27 | 358 | 192 | 204 | 396 | |||||||||||||||||||||||||||||||||||||||||
2037647 | 2037647 | MS | school | 2800360 | 4820 | ABERDEEN SCHOOL DIST | 280036001372 | 4820006 | ABERDEEN ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 03 | 2020 | pk_12_total | * | 315 | * | * | 186.0 | 147.0 | 333 | 315 | 186 | 147 | 333 | |||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||
2038056 | 2038056 | MS | school | 2803240 | 5711 | NORTH PIKE SCHOOL DIST | 280324000634 | 5711010 | NORTH PIKE ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 03 | 2020 | pk_12_total | 405 | 300 | * | * | * | 28 | 376.0 | 366.0 | 742 | 405 | 300 | 28 | 376 | 366 | 742 | |||||||||||||||||||||||||||||||||||||||
2038078 | 2038078 | MS | school | 2804080 | 5712 | SOUTH PIKE SCHOOL DIST | 280408000768 | 5712008 | EVA GORDON ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 03 | 2020 | pk_12_total | 50 | 355 | * | * | 218.0 | 195.0 | 413 | 50 | 355 | 218 | 195 | 413 | ||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
2038858 | 2038858 | MS | school | 2800187 | 6711 | SUNFLOWER CO CONSOLIDATE SCH DIST | 280018701399 | 6711030 | LOCKARD ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 03 | 2020 | pk_12_total | 16 | 417 | * | * | 230.0 | 210.0 | 440 | 16 | 417 | 230 | 210 | 440 | ||||||||||||||||||||||||||||||||||||||||||
2039280 | 2039280 | MS | school | 2804440 | 7400 | WALTHALL CO SCHOOL DIST | 280444001148 | 7400010 | TYLERTOWN PRIMARY SCHOOL | Regular School | No | Elementary | KG | 03 | 2020 | pk_12_total | 63 | 298 | * | * | 11 | 206.0 | 177.0 | 383 | 63 | 298 | 11 | 206 | 177 | 383 | ||||||||||||||||||||||||||||||||||||||||
2039350 | 2039350 | MS | school | 2804470 | 7500 | VICKSBURG WARREN SCHOOL DIST | 280447000995 | 7500021 | SHERMAN AVE ELEMENTARY | Regular School | No | Elementary | PK | 03 | 2020 | pk_12_total | 29 | 316 | * | * | * | 171.0 | 191.0 | 362 | 29 | 316 | 171 | 191 | 362 | |||||||||||||||||||||||||||||||||||||||||
2033560 | 2033560 | MS | school | 2800390 | 200 | ALCORN SCHOOL DIST | 280039001150 | 200006 | ALCORN CENTRAL ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 04 | 2020 | pk_12_total | 481 | * | * | * | * | 16 | 265.0 | 247.0 | 512 | 481 | 16 | 265 | 247 | 512 | ||||||||||||||||||||||||||||||||||||||||
2033583 | 2033583 | MS | school | 2800390 | 200 | ALCORN SCHOOL DIST | 280039001151 | 200022 | KOSSUTH ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 04 | 2020 | pk_12_total | 565 | * | * | * | 296.0 | 284.0 | 580 | 565 | 296 | 284 | 580 | |||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
2033864 | 2033864 | MS | school | 2800185 | 618 | WEST BOLIVAR CONS SCHOOL DISTRICT | 280018501426 | 618020 | WEST BOLIVAR ELEM | Regular School | No | Elementary | KG | 04 | 2020 | pk_12_total | * | 199 | * | 111.0 | 95.0 | 206 | 199 | 111 | 95 | 206 | ||||||||||||||||||||||||||||||||||||||||||||
2033873 | 2033873 | MS | school | 2800870 | 700 | CALHOUN CO SCHOOL DIST | 280087001102 | 700002 | BRUCE ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 04 | 2020 | pk_12_total | 238 | 110 | 21 | * | * | 185.0 | 194.0 | 379 | 238 | 110 | 21 | 185 | 194 | 379 | ||||||||||||||||||||||||||||||||||||||||
2033894 | 2033894 | MS | school | 2800870 | 700 | CALHOUN CO SCHOOL DIST | 280087001104 | 700008 | CALHOUN CITY ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 04 | 2020 | pk_12_total | 113 | 154 | * | * | 27 | 168.0 | 148.0 | 316 | 113 | 154 | 27 | 168 | 148 | 316 | ||||||||||||||||||||||||||||||||||||||||
2034074 | 2034074 | MS | school | 2801440 | 1211 | ENTERPRISE SCHOOL DIST | 280144000210 | 1211004 | ENTERPRISE ELEMENTARY | Regular School | No | Elementary | PK | 04 | 2020 | pk_12_total | 333 | 21 | * | * | 166.0 | 192.0 | 358 | 333 | 21 | 166 | 192 | 358 | ||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||
2034201 | 2034201 | MS | school | 2801050 | 1420 | CLARKSDALE MUNICIPAL SCHOOL DIST | 280105000121 | 1420016 | HEIDELBERG SCHOOL MATH & SCIENCE | Regular School | No | Elementary | PK | 04 | 2020 | pk_12_total | * | 252 | * | * | 124.0 | 137.0 | 261 | 252 | 124 | 137 | 261 | |||||||||||||||||||||||||||||||||||||||||||
2034208 | 2034208 | MS | school | 2801050 | 1420 | CLARKSDALE MUNICIPAL SCHOOL DIST | 280105000122 | 1420020 | KIRKPATRICK HEALTH /WELLNESS | Regular School | No | Elementary | PK | 04 | 2020 | pk_12_total | 12 | 238 | * | * | 125.0 | 137.0 | 262 | 12 | 238 | 125 | 137 | 262 | ||||||||||||||||||||||||||||||||||||||||||
2034219 | 2034219 | MS | school | 2801050 | 1420 | CLARKSDALE MUNICIPAL SCHOOL DIST | 280105000124 | 1420028 | GEO H OLIVER VISUAL/PERF. ARTS | Regular School | No | Elementary | PK | 04 | 2020 | pk_12_total | * | 198 | * | * | 115.0 | 91.0 | 206 | 198 | 115 | 91 | 206 | |||||||||||||||||||||||||||||||||||||||||||
2034230 | 2034230 | MS | school | 2801050 | 1420 | CLARKSDALE MUNICIPAL SCHOOL DIST | 280105000128 | 1420040 | BOOKER T WASHINGTON INTERN. STUDIES | Regular School | No | Elementary | PK | 04 | 2020 | pk_12_total | * | * | 100.0 | 116.0 | 216 | 100 | 116 | 216 | ||||||||||||||||||||||||||||||||||||||||||||||
2034299 | 2034299 | MS | school | 2801290 | 1600 | COVINGTON CO SCHOOLS | 280129000176 | 1600004 | COLLINS ELEMENTARY | Regular School | No | Elementary | KG | 04 | 2020 | pk_12_total | 69 | 231 | 20 | * | * | 21 | 174.0 | 169.0 | 343 | 69 | 231 | 20 | 21 | 174 | 169 | 343 |
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]);