enrollments
Data source: Big Local News · About: Big Local
12,592 rows where state = "MS" sorted by hispanic descending
This data as json, CSV (advanced)
grade ✖
- pk_12_total 1,663
- elementary_spec_ed 898
- grade_1 824
- grade_2 823
- grade_3 818
- grade_4 809
- kindergarten 807
- grade_5 785
- grade_6 648
- grade_8 549
- grade_7 548
- secondary_spec_ed 538
- grade_11 475
- grade_12 474
- grade_9 472
- grade_10 471
- pre_kindergarten 440
- pre_kindergarten_spec_ed 216
- kindergarten_spec_ed 205
- ged 29
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2035654 | 2035654 | MS | school | 2802190 | 2520 | JACKSON PUBLIC SCHOOL DIST | 280219000414 | 2520078 | SPANN ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | * | 385 | 66 | * | 14 | 253.0 | 225.0 | 478 | 385 | 66 | 14 | 253 | 225 | 478 | ||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
2241280 | 2241280 | MS | school | 2803530 | 1821 | PETAL SCHOOL DIST | 280353001068 | 1821006 | PETAL HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 836 | 203 | 65 | * | * | 45 | 579 | 588 | 1167 | 836 | 203 | 65 | 45 | 579 | 588 | 1167 | ||||||||||||||||||||||||||||||||||||||
2242214 | 2242214 | MS | school | 2802190 | 2520 | JACKSON PUBLIC SCHOOL DIST | 280219000420 | 2520084 | PECAN PARK ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | * | 438 | 65 | * | 261 | 246 | 507 | 438 | 65 | 261 | 246 | 507 | ||||||||||||||||||||||||||||||||||||||||||
2242476 | 2242476 | MS | school | 2802160 | 3000 | JACKSON CO SCHOOL DIST | 280216001046 | 3000011 | ST MARTIN HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 783 | 263 | 65 | * | 115 | * | 15 | 653 | 596 | 1249 | 783 | 263 | 65 | 115 | 15 | 653 | 596 | 1249 | ||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
2037539 | 2037539 | MS | school | 2802850 | 4700 | MARSHALL CO SCHOOL DIST | 280285001291 | 4700013 | BYHALIA MIDDLE SCHOOL (6-8) | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 113 | 180 | 64 | 16 | 190.0 | 183.0 | 373 | 113 | 180 | 64 | 16 | 190 | 183 | 373 | ||||||||||||||||||||||||||||||||||||||||
2241574 | 2241574 | MS | school | 2801770 | 2400 | HARRISON CO SCHOOL DIST | 280177001469 | 2400030 | NORTH GULFPORT MIDDLE SCHOOL | Regular School | No | Middle | 07 | 08 | 2021 | pk_12_total | 286 | 692 | 64 | * | 12 | * | 46 | 561 | 542 | 1103 | 286 | 692 | 64 | 12 | 46 | 561 | 542 | 1103 | ||||||||||||||||||||||||||||||||||||
2242579 | 2242579 | MS | school | 2803360 | 3021 | OCEAN SPRINGS SCHOOL DIST | 280336000934 | 3021022 | OCEAN SPRINGS MIDDLE SCHOOL | Regular School | No | Middle | 07 | 08 | 2021 | pk_12_total | 736 | 119 | 64 | * | 36 | * | 25 | 563 | 427 | 990 | 736 | 119 | 64 | 36 | 25 | 563 | 427 | 990 | ||||||||||||||||||||||||||||||||||||
2242658 | 2242658 | MS | school | 2803480 | 3022 | PASCAGOULA GAUTIER SCHOOL DIST | 280348000676 | 3022044 | JACKSON ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 04 | 2021 | pk_12_total | 13 | 140 | 64 | * | * | 12 | 113 | 120 | 233 | 13 | 140 | 64 | 12 | 113 | 120 | 233 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
2241521 | 2241521 | MS | school | 2801770 | 2400 | HARRISON CO SCHOOL DIST | 280177000284 | 2400003 | DIBERVILLE ELEM | Regular School | No | Elementary | KG | 03 | 2021 | pk_12_total | 271 | 155 | 63 | * | 68 | * | 72 | 315 | 318 | 633 | 271 | 155 | 63 | 68 | 72 | 315 | 318 | 633 | ||||||||||||||||||||||||||||||||||||
2245547 | 2245547 | MS | school | 2804110 | 7012 | SOUTH TIPPAH SCHOOL DIST | 280411000778 | 7012016 | RIPLEY HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 240 | 144 | 63 | * | * | 246 | 240 | 486 | 240 | 144 | 63 | 246 | 240 | 486 | ||||||||||||||||||||||||||||||||||||||||
2036303 | 2036303 | MS | school | 2802280 | 3400 | JONES CO SCHOOL DIST | 280228000441 | 3400016 | MOSELLE ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 06 | 2020 | pk_12_total | 431 | 45 | 62 | * | * | 295.0 | 276.0 | 571 | 431 | 45 | 62 | 295 | 276 | 571 | ||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||
2241106 | 2241106 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132001289 | 1700072 | CENTER HILL HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 498 | 432 | 62 | * | * | 46 | 521 | 538 | 1059 | 498 | 432 | 62 | 46 | 521 | 538 | 1059 | ||||||||||||||||||||||||||||||||||||||
2244681 | 2244681 | MS | school | 2803690 | 5820 | PONTOTOC CITY SCHOOLS | 280369001162 | 5820010 | PONTOTOC JUNIOR HIGH SCHOOL | Regular School | No | Middle | 07 | 08 | 2021 | pk_12_total | 174 | 106 | 62 | * | * | 178 | 185 | 363 | 174 | 106 | 62 | 178 | 185 | 363 | ||||||||||||||||||||||||||||||||||||||||
2245023 | 2245023 | MS | school | 2803520 | 6120 | PEARL PUBLIC SCHOOL DIST | 280352000002 | 6120008 | PEARL LOWER ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 01 | 2021 | pk_12_total | 345 | 206 | 62 | * | * | 52 | 340 | 333 | 673 | 345 | 206 | 62 | 52 | 340 | 333 | 673 | ||||||||||||||||||||||||||||||||||||||
2034703 | 2034703 | MS | school | 2801800 | 1820 | HATTIESBURG PUBLIC SCHOOL DIST | 280180001570 | 1820038 | HAWKINS ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | * | 209 | 61 | * | 135.0 | 156.0 | 291 | 209 | 61 | 135 | 156 | 291 | ||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
2039246 | 2039246 | MS | school | 2803120 | 7320 | NEW ALBANY PUBLIC SCHOOLS | 280312000618 | 7320016 | NEW ALBANY MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 272 | 137 | 61 | * | * | 33 | 268.0 | 246.0 | 514 | 272 | 137 | 61 | 33 | 268 | 246 | 514 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||
2242186 | 2242186 | MS | school | 2802190 | 2520 | JACKSON PUBLIC SCHOOL DIST | 280219000415 | 2520080 | SYKES ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | * | 231 | 60 | * | * | 157 | 144 | 301 | 231 | 60 | 157 | 144 | 301 | |||||||||||||||||||||||||||||||||||||||||
2242986 | 2242986 | MS | school | 2803450 | 3620 | OXFORD SCHOOL DISTRICT | 280345000663 | 3620012 | OXFORD HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 724 | 398 | 60 | * | * | 43 | 670 | 597 | 1267 | 724 | 398 | 60 | 43 | 670 | 597 | 1267 | ||||||||||||||||||||||||||||||||||||||
2240929 | 2240929 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132000140 | 1700018 | HERNANDO MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 850 | 126 | 59 | * | * | 59 | 562 | 550 | 1112 | 850 | 126 | 59 | 59 | 562 | 550 | 1112 | ||||||||||||||||||||||||||||||||||||||
2242917 | 2242917 | MS | school | 2802460 | 3420 | LAUREL SCHOOL DISTRICT | 280246000479 | 3420040 | LAUREL HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 20 | 620 | 59 | * | * | * | 359 | 351 | 710 | 20 | 620 | 59 | 359 | 351 | 710 | |||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
2037412 | 2037412 | MS | school | 2800900 | 4520 | CANTON PUBLIC SCHOOL DIST | 280090000101 | 4520008 | CANTON PUBLIC HIGH SCHOOL | Regular School | No | High | 10 | 12 | 2020 | pk_12_total | * | 530 | 58 | * | 296.0 | 296.0 | 592 | 530 | 58 | 296 | 296 | 592 | ||||||||||||||||||||||||||||||||||||||||||
2039059 | 2039059 | MS | school | 2804110 | 7012 | SOUTH TIPPAH SCHOOL DIST | 280411000778 | 7012016 | RIPLEY HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 229 | 140 | 58 | * | * | 230.0 | 235.0 | 465 | 229 | 140 | 58 | 230 | 235 | 465 | ||||||||||||||||||||||||||||||||||||||||
2241235 | 2241235 | MS | school | 2801800 | 1820 | HATTIESBURG PUBLIC SCHOOL DIST | 280180001570 | 1820038 | HAWKINS ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | * | 242 | 58 | * | 148 | 165 | 313 | 242 | 58 | 148 | 165 | 313 | ||||||||||||||||||||||||||||||||||||||||||
2242813 | 2242813 | MS | school | 2802280 | 3400 | JONES CO SCHOOL DIST | 280228000441 | 3400016 | MOSELLE ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 06 | 2021 | pk_12_total | 393 | 36 | 58 | * | * | 267 | 246 | 513 | 393 | 36 | 58 | 267 | 246 | 513 | ||||||||||||||||||||||||||||||||||||||||
2244667 | 2244667 | MS | school | 2803690 | 5820 | PONTOTOC CITY SCHOOLS | 280369000704 | 5820004 | D T COX ELEMENTARY SCHOOL | Regular School | No | Elementary | 03 | 04 | 2021 | pk_12_total | 181 | 83 | 58 | * | * | 167 | 184 | 351 | 181 | 83 | 58 | 167 | 184 | 351 | ||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
2240975 | 2240975 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132000193 | 1700032 | OLIVE BRANCH HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 445 | 520 | 57 | * | 17 | * | 53 | 553 | 544 | 1097 | 445 | 520 | 57 | 17 | 53 | 553 | 544 | 1097 | ||||||||||||||||||||||||||||||||||||
2242642 | 2242642 | MS | school | 2803480 | 3022 | PASCAGOULA GAUTIER SCHOOL DIST | 280348000674 | 3022036 | GAUTIER ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 04 | 2021 | pk_12_total | 114 | 167 | 57 | * | * | * | 29 | 200 | 175 | 375 | 114 | 167 | 57 | 29 | 200 | 175 | 375 | |||||||||||||||||||||||||||||||||||||
2242972 | 2242972 | MS | school | 2803450 | 3620 | OXFORD SCHOOL DISTRICT | 280345000662 | 3620008 | CENTRAL ELEMENTARY | Regular School | No | Elementary | 01 | 02 | 2021 | pk_12_total | 366 | 213 | 57 | * | 38 | * | 341 | 372 | 713 | 366 | 213 | 57 | 38 | 341 | 372 | 713 | ||||||||||||||||||||||||||||||||||||||
2243926 | 2243926 | MS | school | 2800900 | 4520 | CANTON PUBLIC SCHOOL DIST | 280090001394 | 4520018 | HUEY L. PORTER MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | * | 338 | 57 | * | * | 209 | 191 | 400 | 338 | 57 | 209 | 191 | 400 | |||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
2036151 | 2036151 | MS | school | 2803480 | 3022 | PASCAGOULA GAUTIER SCHOOL DIST | 280348000676 | 3022044 | JACKSON ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 04 | 2020 | pk_12_total | 15 | 143 | 56 | * | * | 10 | 107.0 | 119.0 | 226 | 15 | 143 | 56 | 10 | 107 | 119 | 226 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
2038193 | 2038193 | MS | school | 2803690 | 5820 | PONTOTOC CITY SCHOOLS | 280369001162 | 5820010 | PONTOTOC JUNIOR HIGH SCHOOL | Regular School | No | Middle | 07 | 08 | 2020 | pk_12_total | 186 | 104 | 56 | * | * | 164.0 | 196.0 | 360 | 186 | 104 | 56 | 164 | 196 | 360 | ||||||||||||||||||||||||||||||||||||||||
2243921 | 2243921 | MS | school | 2800900 | 4520 | CANTON PUBLIC SCHOOL DIST | 280090000103 | 4520016 | NICHOLS MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | * | 346 | 56 | * | * | * | 189 | 217 | 406 | 346 | 56 | 189 | 217 | 406 | ||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
2241050 | 2241050 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132001569 | 1700052 | DESOTO CENTRAL HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 919 | 728 | 55 | * | 67 | * | 68 | 901 | 940 | 1841 | 919 | 728 | 55 | 67 | 68 | 901 | 940 | 1841 | ||||||||||||||||||||||||||||||||||||
2242911 | 2242911 | MS | school | 2802460 | 3420 | LAUREL SCHOOL DISTRICT | 280246000477 | 3420024 | OAK PARK ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 03 | 2021 | pk_12_total | * | 408 | 55 | * | 11 | 237 | 242 | 479 | 408 | 55 | 11 | 237 | 242 | 479 | ||||||||||||||||||||||||||||||||||||||||
2245016 | 2245016 | MS | school | 2803830 | 6100 | RANKIN CO SCHOOL DIST | 280383001143 | 6100058 | RICHLAND ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2021 | pk_12_total | 210 | 90 | 55 | * | * | 205 | 188 | 393 | 210 | 90 | 55 | 205 | 188 | 393 | ||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
2036164 | 2036164 | MS | school | 2803480 | 3022 | PASCAGOULA GAUTIER SCHOOL DIST | 280348001236 | 3022050 | MARTIN BLUFF | Regular School | No | Elementary | PK | 04 | 2020 | pk_12_total | 176 | 152 | 54 | * | * | 23 | 194.0 | 217.0 | 411 | 176 | 152 | 54 | 23 | 194 | 217 | 411 | ||||||||||||||||||||||||||||||||||||||
2037432 | 2037432 | MS | school | 2800900 | 4520 | CANTON PUBLIC SCHOOL DIST | 280090001394 | 4520018 | HUEY L. PORTER MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | * | 352 | 54 | * | * | 209.0 | 203.0 | 412 | 352 | 54 | 209 | 203 | 412 | |||||||||||||||||||||||||||||||||||||||||
2241015 | 2241015 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132000197 | 1700044 | HOPE SULLIVAN ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 02 | 2021 | pk_12_total | 154 | 220 | 54 | * | * | 58 | 256 | 240 | 496 | 154 | 220 | 54 | 58 | 256 | 240 | 496 | ||||||||||||||||||||||||||||||||||||||
2241584 | 2241584 | MS | school | 2801770 | 2400 | HARRISON CO SCHOOL DIST | 280177000958 | 2400038 | NORTH WOOLMARKET ELEMENTARY AND MID | Regular School | No | Elementary | KG | 08 | 2021 | pk_12_total | 739 | 90 | 54 | * | * | * | 42 | 460 | 479 | 939 | 739 | 90 | 54 | 42 | 460 | 479 | 939 | |||||||||||||||||||||||||||||||||||||
2243033 | 2243033 | MS | school | 2802400 | 3700 | LAMAR COUNTY SCHOOL DISTRICT | 280240001240 | 3700011 | OAK GROVE UPPER ELEMENTARY | Regular School | No | Elementary | 04 | 05 | 2021 | pk_12_total | 257 | 266 | 54 | * | * | 34 | 329 | 305 | 634 | 257 | 266 | 54 | 34 | 329 | 305 | 634 | ||||||||||||||||||||||||||||||||||||||
2034449 | 2034449 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132000194 | 1700034 | OLIVE BRANCH MIDDLE | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 304 | 373 | 53 | * | * | 67 | 419.0 | 397.0 | 816 | 304 | 373 | 53 | 67 | 419 | 397 | 816 | ||||||||||||||||||||||||||||||||||||||
2035705 | 2035705 | MS | school | 2802190 | 2520 | JACKSON PUBLIC SCHOOL DIST | 280219000420 | 2520084 | PECAN PARK ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | * | 355 | 53 | * | * | 208.0 | 205.0 | 413 | 355 | 53 | 208 | 205 | 413 | |||||||||||||||||||||||||||||||||||||||||
2036106 | 2036106 | MS | school | 2803480 | 3022 | PASCAGOULA GAUTIER SCHOOL DIST | 280348000669 | 3022016 | CHEROKEE ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 04 | 2020 | pk_12_total | 60 | 71 | 53 | * | * | 109.0 | 92.0 | 201 | 60 | 71 | 53 | 109 | 92 | 201 | ||||||||||||||||||||||||||||||||||||||||
2036127 | 2036127 | MS | school | 2803480 | 3022 | PASCAGOULA GAUTIER SCHOOL DIST | 280348000672 | 3022028 | EASTLAWN ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 04 | 2020 | pk_12_total | 130 | 87 | 53 | * | * | 137.0 | 156.0 | 293 | 130 | 87 | 53 | 137 | 156 | 293 | ||||||||||||||||||||||||||||||||||||||||
2037452 | 2037452 | MS | school | 2800900 | 4520 | CANTON PUBLIC SCHOOL DIST | 280090001396 | 4520022 | JIMMIE M. GOODLOE ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | * | 365 | 53 | * | * | 229.0 | 195.0 | 424 | 365 | 53 | 229 | 195 | 424 | |||||||||||||||||||||||||||||||||||||||||
2241201 | 2241201 | MS | school | 2801490 | 1800 | FORREST COUNTY SCHOOL DISTRICT | 280149000221 | 1800036 | EARL TRAVILLION ATTENDANCE CENTER | Regular School | No | Elementary | KG | 08 | 2021 | pk_12_total | * | 221 | 53 | * | 149 | 151 | 300 | 221 | 53 | 149 | 151 | 300 | ||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
2036994 | 2036994 | MS | school | 2800198 | 4211 | GREENWOOD-LEFLORE CONSOLIDATED SD | 280019801511 | 4211003 | BANKSTON ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 06 | 2020 | pk_12_total | 59 | 255 | 52 | * | * | 187.0 | 192.0 | 379 | 59 | 255 | 52 | 187 | 192 | 379 | ||||||||||||||||||||||||||||||||||||||||
2034469 | 2034469 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132000195 | 1700040 | SOUTHAVEN ELEMENTARY | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 161 | 414 | 51 | * | * | 128 | 395.0 | 364.0 | 759 | 161 | 414 | 51 | 128 | 395 | 364 | 759 | ||||||||||||||||||||||||||||||||||||||
2242976 | 2242976 | MS | school | 2803450 | 3620 | OXFORD SCHOOL DISTRICT | 280345001312 | 3620010 | DELLA DAVIDSON ELEMENTARY | Regular School | No | Elementary | 03 | 04 | 2021 | pk_12_total | 312 | 219 | 51 | * | 29 | * | 342 | 303 | 645 | 312 | 219 | 51 | 29 | 342 | 303 | 645 | ||||||||||||||||||||||||||||||||||||||
2035670 | 2035670 | MS | school | 2802190 | 2520 | JACKSON PUBLIC SCHOOL DIST | 280219000415 | 2520080 | SYKES ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | * | 279 | 50 | * | * | 192.0 | 145.0 | 337 | 279 | 50 | 192 | 145 | 337 | |||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
2242170 | 2242170 | MS | school | 2802190 | 2520 | JACKSON PUBLIC SCHOOL DIST | 280219000414 | 2520078 | SPANN ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | * | 365 | 50 | * | * | 14 | 230 | 209 | 439 | 365 | 50 | 14 | 230 | 209 | 439 | |||||||||||||||||||||||||||||||||||||||
2244064 | 2244064 | MS | school | 2802850 | 4700 | MARSHALL CO SCHOOL DIST | 280285000553 | 4700024 | H. W. BYERS HIGH SCHOOL (5-12) | Regular School | No | High | 05 | 12 | 2021 | pk_12_total | 119 | 204 | 50 | 20 | 203 | 190 | 393 | 119 | 204 | 50 | 20 | 203 | 190 | 393 | ||||||||||||||||||||||||||||||||||||||||
2036070 | 2036070 | MS | school | 2803360 | 3021 | OCEAN SPRINGS SCHOOL DIST | 280336000934 | 3021022 | OCEAN SPRINGS MIDDLE SCHOOL | Regular School | No | Middle | 07 | 08 | 2020 | pk_12_total | 756 | 126 | 49 | * | 34 | * | 17 | 537.0 | 457.0 | 994 | 756 | 126 | 49 | 34 | 17 | 537 | 457 | 994 | ||||||||||||||||||||||||||||||||||||
2242624 | 2242624 | MS | school | 2803480 | 3022 | PASCAGOULA GAUTIER SCHOOL DIST | 280348000670 | 3022020 | COLLEGE PARK ELEM | Regular School | No | Elementary | PK | 04 | 2021 | pk_12_total | 117 | 123 | 49 | * | * | 186 | 122 | 308 | 117 | 123 | 49 | 186 | 122 | 308 | ||||||||||||||||||||||||||||||||||||||||
2242671 | 2242671 | MS | school | 2803480 | 3022 | PASCAGOULA GAUTIER SCHOOL DIST | 280348001236 | 3022050 | MARTIN BLUFF | Regular School | No | Elementary | PK | 04 | 2021 | pk_12_total | 156 | 144 | 49 | * | * | 25 | 177 | 199 | 376 | 156 | 144 | 49 | 25 | 177 | 199 | 376 | ||||||||||||||||||||||||||||||||||||||
2242898 | 2242898 | MS | school | 2802460 | 3420 | LAUREL SCHOOL DISTRICT | 280246001374 | 3420014 | LAUREL UPPER ELEMENTARY | Regular School | No | Elementary | 04 | 05 | 2021 | pk_12_total | * | 287 | 49 | * | 191 | 162 | 353 | 287 | 49 | 191 | 162 | 353 | ||||||||||||||||||||||||||||||||||||||||||
2245019 | 2245019 | MS | school | 2803520 | 6120 | PEARL PUBLIC SCHOOL DIST | 280352000001 | 6120004 | NORTHSIDE ELEMENTARY SCHOOL | Regular School | No | Elementary | 02 | 03 | 2021 | pk_12_total | 295 | 215 | 49 | * | * | * | 38 | 302 | 303 | 605 | 295 | 215 | 49 | 38 | 302 | 303 | 605 | |||||||||||||||||||||||||||||||||||||
2033986 | 2033986 | MS | school | 2802010 | 920 | HOUSTON SCHOOL DIST | 280201000040 | 920010 | HOUSTON MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 207 | 176 | 48 | * | * | 214.0 | 227.0 | 441 | 207 | 176 | 48 | 214 | 227 | 441 | ||||||||||||||||||||||||||||||||||||||||
2035011 | 2035011 | MS | school | 2801770 | 2400 | HARRISON CO SCHOOL DIST | 280177001351 | 2400005 | CROSSROADS ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 06 | 2020 | pk_12_total | 87 | 440 | 48 | * | * | 29 | 318.0 | 294.0 | 612 | 87 | 440 | 48 | 29 | 318 | 294 | 612 | ||||||||||||||||||||||||||||||||||||||
2035688 | 2035688 | MS | school | 2802190 | 2520 | JACKSON PUBLIC SCHOOL DIST | 280219000417 | 2520082 | VAN WINKLE ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | * | 263 | 48 | * | * | * | 185.0 | 142.0 | 327 | 263 | 48 | 185 | 142 | 327 | ||||||||||||||||||||||||||||||||||||||||
2241284 | 2241284 | MS | school | 2803530 | 1821 | PETAL SCHOOL DIST | 280353000007 | 1821012 | PETAL UPPER ELEMENTARY SCHOOL | Regular School | No | Middle | 05 | 06 | 2021 | pk_12_total | 470 | 121 | 48 | * | * | 349 | 332 | 681 | 470 | 121 | 48 | 349 | 332 | 681 | ||||||||||||||||||||||||||||||||||||||||
2242634 | 2242634 | MS | school | 2803480 | 3022 | PASCAGOULA GAUTIER SCHOOL DIST | 280348000672 | 3022028 | EASTLAWN ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 04 | 2021 | pk_12_total | 120 | 73 | 48 | * | * | 117 | 146 | 263 | 120 | 73 | 48 | 117 | 146 | 263 | ||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||
2034518 | 2034518 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132001569 | 1700052 | DESOTO CENTRAL HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 985 | 649 | 47 | * | 66 | * | 56 | 900.0 | 907.0 | 1807 | 985 | 649 | 47 | 66 | 56 | 900 | 907 | 1807 | ||||||||||||||||||||||||||||||||||||
2034669 | 2034669 | MS | school | 2801490 | 1800 | FORREST COUNTY SCHOOL DISTRICT | 280149000221 | 1800036 | EARL TRAVILLION ATTENDANCE CENTER | Regular School | No | Elementary | KG | 08 | 2020 | pk_12_total | * | 232 | 47 | * | 152.0 | 149.0 | 301 | 232 | 47 | 152 | 149 | 301 | ||||||||||||||||||||||||||||||||||||||||||
2036406 | 2036406 | MS | school | 2802460 | 3420 | LAUREL SCHOOL DISTRICT | 280246000479 | 3420040 | LAUREL HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 16 | 666 | 47 | * | * | 10 | 358.0 | 386.0 | 744 | 16 | 666 | 47 | 10 | 358 | 386 | 744 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
2240980 | 2240980 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132000194 | 1700034 | OLIVE BRANCH MIDDLE | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 286 | 384 | 47 | * | * | 72 | 425 | 382 | 807 | 286 | 384 | 47 | 72 | 425 | 382 | 807 | ||||||||||||||||||||||||||||||||||||||
2241269 | 2241269 | MS | school | 2803530 | 1821 | PETAL SCHOOL DIST | 280353001067 | 1821002 | PETAL PRIMARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2021 | pk_12_total | 724 | 152 | 47 | * | * | * | 69 | 533 | 465 | 998 | 724 | 152 | 47 | 69 | 533 | 465 | 998 | |||||||||||||||||||||||||||||||||||||
2243944 | 2243944 | MS | school | 2800900 | 4520 | CANTON PUBLIC SCHOOL DIST | 280090001396 | 4520022 | JIMMIE M. GOODLOE ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | * | 346 | 47 | * | 203 | 192 | 395 | 346 | 47 | 203 | 192 | 395 | ||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
2240780 | 2240780 | MS | school | 2801220 | 1500 | COPIAH CO SCHOOL DIST | 280122000167 | 1500004 | CRYSTAL SPRINGS MIDDLE SCHOOL | Regular School | No | Middle | 04 | 08 | 2021 | pk_12_total | 44 | 450 | 46 | * | * | * | 273 | 274 | 547 | 44 | 450 | 46 | 273 | 274 | 547 | |||||||||||||||||||||||||||||||||||||||
2240812 | 2240812 | MS | school | 2801830 | 1520 | HAZLEHURST CITY SCHOOL DISTRICT | 280183000316 | 1520004 | HAZLEHURST MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | * | 324 | 46 | * | * | 203 | 181 | 384 | 324 | 46 | 203 | 181 | 384 | |||||||||||||||||||||||||||||||||||||||||
2240962 | 2240962 | MS | school | 2801320 | 1700 | DESOTO CO SCHOOL DIST | 280132000945 | 1700028 | HORN LAKE INTERMEDIATE SCHOOL | Regular School | No | Elementary | 03 | 05 | 2021 | pk_12_total | 145 | 643 | 46 | * | * | * | 119 | 473 | 493 | 966 | 145 | 643 | 46 | 119 | 473 | 493 | 966 | |||||||||||||||||||||||||||||||||||||
2243023 | 2243023 | MS | school | 2802400 | 3700 | LAMAR COUNTY SCHOOL DISTRICT | 280240001239 | 3700009 | OAK GROVE PRIMARY | Regular School | No | Elementary | PK | 01 | 2021 | pk_12_total | 314 | 271 | 46 | * | 11 | * | 58 | 361 | 342 | 703 | 314 | 271 | 46 | 11 | 58 | 361 | 342 | 703 | ||||||||||||||||||||||||||||||||||||
2243495 | 2243495 | MS | school | 2800198 | 4211 | GREENWOOD-LEFLORE CONSOLIDATED SD | 280019801511 | 4211003 | BANKSTON ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 06 | 2021 | pk_12_total | 34 | 189 | 46 | * | * | 145 | 138 | 283 | 34 | 189 | 46 | 145 | 138 | 283 | ||||||||||||||||||||||||||||||||||||||||
2244906 | 2244906 | MS | school | 2803830 | 6100 | RANKIN CO SCHOOL DIST | 280383001076 | 6100032 | NORTHWEST RANKIN HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 1073 | 510 | 46 | * | 57 | * | 53 | 872 | 871 | 1743 | 1073 | 510 | 46 | 57 | 53 | 872 | 871 | 1743 | ||||||||||||||||||||||||||||||||||||
2245026 | 2245026 | MS | school | 2803520 | 6120 | PEARL PUBLIC SCHOOL DIST | 280352001181 | 6120010 | PEARL UPPER SCHOOL | Regular School | No | Elementary | 04 | 05 | 2021 | pk_12_total | 280 | 215 | 46 | * | * | 35 | 299 | 282 | 581 | 280 | 215 | 46 | 35 | 299 | 282 | 581 | ||||||||||||||||||||||||||||||||||||||
2035191 | 2035191 | MS | school | 2801710 | 2421 | GULFPORT SCHOOL DIST | 280171000271 | 2421014 | CENTRAL ELEM | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 86 | 331 | 45 | * | * | 252.0 | 231.0 | 483 | 86 | 331 | 45 | 252 | 231 | 483 | ||||||||||||||||||||||||||||||||||||||||
2038390 | 2038390 | MS | school | 2803830 | 6100 | RANKIN CO SCHOOL DIST | 280383000711 | 6100023 | FLOWOOD ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 06 | 2020 | pk_12_total | 322 | 179 | 45 | * | 45 | * | 328.0 | 305.0 | 633 | 322 | 179 | 45 | 45 | 328 | 305 | 633 |
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]);