enrollments

Data source: Big Local News · About: Big Local

472 rows where grade = "grade_9" and state = "MS" sorted by ccd_school_low_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_9 · 472 ✖
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
2035795 2035795 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   grade_9                                                   *                                              
2037755 2037755 MS     school 2803150 5100   NEWTON COUNTY SCHOOL DISTRICT 280315001135 5100012 NEWTON COUNTY HIGH SCHOOL   Regular School No Other 01 12 2020   grade_9                                                   159                                             159
2242306 2242306 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 2021   grade_9                                                   *                                              
2242315 2242315 MS     school 2801191 2562   MDHS DIVISION OF YOUTH SERVICES 280119101197 2562008 WILLIAMS SCHOOL   Regular School No Other 04 12 2021   grade_9                                                   *                                              
2244035 2244035 MS     school 2802850 4700   MARSHALL CO SCHOOL DIST 280285000551 4700016 POTTS CAMP HIGH SCHOOL (4-12)   Regular School No Other 04 12 2021   grade_9                                                   58                                             58
2033879 2033879 MS     school 2800870 700   CALHOUN CO SCHOOL DIST 280087000097 700006 BRUCE HIGH SCHOOL   Regular School No High 05 12 2020   grade_9                                                   59                                             59
2033900 2033900 MS     school 2800870 700   CALHOUN CO SCHOOL DIST 280087000098 700010 CALHOUN CITY HIGH SCHOOL   Regular School No High 05 12 2020   grade_9                                                   57                                             57
2038290 2038290 MS     school 2800540 5920   BALDWYN SCHOOL DISTRICT 280054000042 5920008 BALDWYN HIGH SCHOOL   Regular School No High 05 12 2020   grade_9                                                   *                                              
2240416 2240416 MS     school 2800870 700   CALHOUN CO SCHOOL DIST 280087000097 700006 BRUCE HIGH SCHOOL   Regular School No High 05 12 2021   grade_9                                                   67                                             67
2240436 2240436 MS     school 2800870 700   CALHOUN CO SCHOOL DIST 280087000098 700010 CALHOUN CITY HIGH SCHOOL   Regular School No High 05 12 2021   grade_9                                                   55                                             55
2244059 2244059 MS     school 2802850 4700   MARSHALL CO SCHOOL DIST 280285000553 4700024 H. W. BYERS HIGH SCHOOL (5-12)   Regular School No High 05 12 2021   grade_9                                                   58                                             58
2033928 2033928 MS     school 2800930 800   CARROLL COUNTY SCHOOL DIST 280093000104 800004 J Z GEORGE HIGH SCHOOL   Regular School No High 06 12 2020   grade_9                                                   75                                             75
2033970 2033970 MS     school 2802010 920   HOUSTON SCHOOL DIST 280201000345 920006 HOUSTON HIGH SCHOOL   Regular School No High 06 12 2020   grade_9                                                   125                                             125
2039603 2039603 MS     school 2804560 7800   WEBSTER CO SCHOOL DIST 280456000852 7800004 EAST WEBSTER HIGH SCHOOL   Regular School No High 06 12 2020   grade_9                                                   *                                              
2039622 2039622 MS     school 2804560 7800   WEBSTER CO SCHOOL DIST 280456001097 7800010 EUPORA HIGH SCHOOL   Regular School No High 06 12 2020   grade_9                                                   56                                             56
2240463 2240463 MS     school 2800930 800   CARROLL COUNTY SCHOOL DIST 280093000104 800004 J Z GEORGE HIGH SCHOOL   Regular School No High 06 12 2021   grade_9                                                   58                                             58
2241811 2241811 MS     school 2800183 2480   ROGER AMOS MCMURTRY ADM 280018301317 2480004 ROGER AMOS MCMURTRY SCHOOL   Regular School No Secondary 06 11 2021   grade_9                                                   *                                              
2244245 2244245 MS     school 2803150 5100   NEWTON COUNTY SCHOOL DISTRICT 280315001135 5100012 NEWTON COUNTY HIGH SCHOOL   Regular School No High 06 12 2021   grade_9                                                   130                                             130
2246092 2246092 MS     school 2804560 7800   WEBSTER CO SCHOOL DIST 280456000852 7800004 EAST WEBSTER HIGH SCHOOL   Regular School No High 06 12 2021   grade_9                                                   79                                             79
2246111 2246111 MS     school 2804560 7800   WEBSTER CO SCHOOL DIST 280456001097 7800010 EUPORA HIGH SCHOOL   Regular School No High 06 12 2021   grade_9                                                   79                                             79
2033545 2033545 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001152 200004 BIGGERSVILLE HIGH SCHOOL   Regular School No High 07 12 2020   grade_9                                                   41                                             41
2033622 2033622 MS     school 2800420 300   AMITE CO SCHOOL DIST 280042000027 300008 AMITE COUNTY HIGH SCHOOL   Regular School No High 07 12 2020   grade_9                                                   76                                             76
2033640 2033640 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000036 400008 ETHEL ATTENDANCE CENTER   Regular School No High 07 12 2020   grade_9                                                   49                                             49
2033668 2033668 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000039 400020 MCADAMS ATTENDANCE CENTER   Regular School No High 07 12 2020   grade_9                                                   34                                             34
2033712 2033712 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000049 500006 ASHLAND MIDDLE-HIGH SCHOOL   Regular School No High 07 12 2020   grade_9                                                   35                                             35
2033800 2033800 MS     school 2800186 617   NORTH BOLIVAR CONS SCH 280018601411 617010 NORTHSIDE HIGH SCHOOL   Regular School No High 07 12 2020   grade_9                                                   62                                             62
2033918 2033918 MS     school 2800870 700   CALHOUN CO SCHOOL DIST 280087000099 700014 VARDAMAN HIGH SCHOOL   Regular School No High 07 12 2020   grade_9                                                   48                                             48
2034015 2034015 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000111 1000008 CHOCTAW COUNTY HIGH SCHOOL   Regular School No High 07 12 2020   grade_9                                                   82                                             82
2034141 2034141 MS     school 2801110 1400   COAHOMA COUNTY SCHOOL DISTRICT 280111000139 1400004 COAHOMA COUNTY JR/SR HIGH SCHOOL   Regular School No High 07 12 2020   grade_9                                                   52                                             52
2034626 2034626 MS     school 2801490 1800   FORREST COUNTY SCHOOL DISTRICT 280149000218 1800012 NORTH FORREST HIGH SCHOOL   Regular School No High 07 12 2020   grade_9                                                   49                                             49
2036318 2036318 MS     school 2802280 3400   JONES CO SCHOOL DIST 280228000443 3400024 NORTHEAST JONES HIGH SCHOOL   Regular School No High 07 12 2020   grade_9                                                   166                                             166
2036349 2036349 MS     school 2802280 3400   JONES CO SCHOOL DIST 280228000450 3400036 SOUTH JONES HIGH SCHOOL   Regular School No High 07 12 2020   grade_9                                                   222                                             222
2036367 2036367 MS     school 2802280 3400   JONES CO SCHOOL DIST 280228000451 3400052 WEST JONES HIGH SCHOOL   Regular School No High 07 12 2020   grade_9                                                   263                                             263
2036826 2036826 MS     school 2802520 4000   LEAKE CO SCHOOL DIST 280252000490 4000016 LEAKE COUNTY HIGH SCHOOL   Regular School No High 07 12 2020   grade_9                                                   45                                             45
2037033 2037033 MS     school 2800198 4211   GREENWOOD-LEFLORE CONSOLIDATED SD 280019801518 4211020 LEFLORE COUNTY HIGH SCHOOL   Regular School No High 07 12 2020   grade_9                                                   63                                             63
2037180 2037180 MS     school 2802730 4400   LOWNDES CO SCHOOL DIST 280273000531 4400012 WEST LOWNDES HIGH SCHOOL   Regular School No High 07 12 2020   grade_9                                                   50                                             50
2037465 2037465 MS     school 2802820 4600   MARION CO SCHOOL DIST 280282000545 4600008 EAST MARION HIGH SCHOOL   Regular School No High 07 12 2020   grade_9                                                   57                                             57
2037478 2037478 MS     school 2802820 4600   MARION CO SCHOOL DIST 280282001247 4600014 WEST MARION HIGH SCHOOL   Regular School No High 07 12 2020   grade_9                                                   99                                             99
2037543 2037543 MS     school 2802850 4700   MARSHALL CO SCHOOL DIST 280285000551 4700016 POTTS CAMP HIGH SCHOOL (7-12)   Regular School No High 07 12 2020   grade_9                                                   58                                             58
2037569 2037569 MS     school 2802850 4700   MARSHALL CO SCHOOL DIST 280285000553 4700024 H. W. BYERS HIGH SCHOOL (7-12)   Regular School No High 07 12 2020   grade_9                                                   51                                             51
2037696 2037696 MS     school 2800196 4911   WINONA-MONTGOMERY CONSOLIDATED SD 280019601485 4911006 WINONA SECONDARY SCHOOL   Regular School No High 07 12 2020   grade_9                                                   95                                             95
2037737 2037737 MS     school 2803600 5020   PHILADELPHIA PUBLIC SCHOOL DIST 280360000692 5020008 PHILADELPHIA HIGH SCHOOL   Regular School No High 07 12 2020   grade_9                                                   61                                             61
2038037 2038037 MS     school 2803870 5620   RICHTON SCHOOL DIST 280387000744 5620004 RICHTON HIGH SCHOOL   Regular School No High 07 12 2020   grade_9                                                   51                                             51
2038407 2038407 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383000739 6100028 MCLAURIN ATTENDANCE CENTER   Regular School No High 07 12 2020   grade_9                                                   89                                             89
2038458 2038458 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383000740 6100044 PELAHATCHIE ATTENDANCE CENTER   Regular School No High 07 12 2020   grade_9                                                   61                                             61
2038486 2038486 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383001079 6100050 PISGAH HIGH SCHOOL   Regular School No High 07 12 2020   grade_9                                                   63                                             63
2038493 2038493 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383000742 6100052 PUCKETT ATTENDANCE CENTER   Regular School No High 07 12 2020   grade_9                                                   57                                             57
2038510 2038510 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383000743 6100056 RICHLAND HIGH SCHOOL   Regular School No High 07 12 2020   grade_9                                                   133                                             133
2038726 2038726 MS     school 2804020 6500   SMITH CO SCHOOL DIST 280402000759 6500008 RALEIGH HIGH SCHOOL   Regular School No High 07 12 2020   grade_9                                                   86                                             86
2038823 2038823 MS     school 2800187 6711   SUNFLOWER CO CONSOLIDATE SCH DIST 280018701421 6711014 ROBERT L MERRITT JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2020   grade_9                                                   170                                             170
2038897 2038897 MS     school 2804650 6812   WEST TALLAHATCHIE SCHOOL DISTRICT 280465000873 6812036 WEST TALLAHATCHIE HIGH SCHOOL   Regular School No High 07 12 2020   grade_9                                                   51                                             51
2038922 2038922 MS     school 2804230 6900   TATE CO SCHOOL DIST 280423000800 6900012 INDEPENDENCE HIGH SCHOOL   Regular School No High 07 12 2020   grade_9                                                   64                                             64
2038929 2038929 MS     school 2804230 6900   TATE CO SCHOOL DIST 280423001508 6900014 COLDWATER HIGH SCHOOL   Regular School No High 07 12 2020   grade_9                                                   28                                             28
2038945 2038945 MS     school 2804230 6900   TATE CO SCHOOL DIST 280423001295 6900024 STRAYHORN HIGH SCHOOL   Regular School No High 07 12 2020   grade_9                                                   58                                             58
2038995 2038995 MS     school 2803270 7011   NORTH TIPPAH SCHOOL DIST 280327000638 7011008 FALKNER HIGH SCHOOL   Regular School No High 07 12 2020   grade_9                                                   38                                             38
2039288 2039288 MS     school 2804440 7400   WALTHALL CO SCHOOL DIST 280444000836 7400016 TYLERTOWN HIGH SCHOOL   Regular School No High 07 12 2020   grade_9                                                   77                                             77
2039408 2039408 MS     school 2801890 7611   HOLLANDALE SCHOOL DIST 280189001037 7611012 SIMMONS HIGH SCHOOL   Regular School No High 07 12 2020   grade_9                                                   34                                             34
2039456 2039456 MS     school 2804680 7613   WESTERN LINE SCHOOL DISTRICT 280468000975 7613016 O'BANNON HIGH SCHOOL   Regular School No High 07 12 2020   grade_9                                                   64                                             64
2039464 2039464 MS     school 2804680 7613   WESTERN LINE SCHOOL DISTRICT 280468000976 7613020 RIVERSIDE HIGH SCHOOL   Regular School No High 07 12 2020   grade_9                                                   58                                             58
2039743 2039743 MS     school 2804500 8113   WATER VALLEY SCHOOL DISTRICT 280450000845 8113004 WATER VALLEY HIGH SCHOOL   Regular School No High 07 12 2020   grade_9                                                   72                                             72
2240102 2240102 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001152 200004 BIGGERSVILLE HIGH SCHOOL   Regular School No High 07 12 2021   grade_9                                                   34                                             34
2240178 2240178 MS     school 2800420 300   AMITE CO SCHOOL DIST 280042000027 300008 AMITE COUNTY HIGH SCHOOL   Regular School No High 07 12 2021   grade_9                                                   64                                             64
2240196 2240196 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000036 400008 ETHEL ATTENDANCE CENTER   Regular School No High 07 12 2021   grade_9                                                   52                                             52
2240224 2240224 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000039 400020 MCADAMS ATTENDANCE CENTER   Regular School No High 07 12 2021   grade_9                                                   36                                             36
2240264 2240264 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000049 500006 ASHLAND MIDDLE-HIGH SCHOOL   Regular School No High 07 12 2021   grade_9                                                   36                                             36
2240353 2240353 MS     school 2800186 617   NORTH BOLIVAR CONS SCH 280018601411 617010 NORTHSIDE HIGH SCHOOL   Regular School No High 07 12 2021   grade_9                                                   *                                              
2240370 2240370 MS     school 2800185 618   WEST BOLIVAR CONS SCHOOL DISTRICT 280018501526 618009 WEST BOLIVAR HIGH SCHOOL   Regular School No High 07 12 2021   grade_9                                                   40                                             40
2240454 2240454 MS     school 2800870 700   CALHOUN CO SCHOOL DIST 280087000099 700014 VARDAMAN HIGH SCHOOL   Regular School No High 07 12 2021   grade_9                                                   43                                             43
2240551 2240551 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000111 1000008 CHOCTAW COUNTY HIGH SCHOOL   Regular School No High 07 12 2021   grade_9                                                   75                                             75
2240677 2240677 MS     school 2801110 1400   COAHOMA COUNTY SCHOOL DISTRICT 280111000139 1400004 COAHOMA COUNTY JR/SR HIGH SCHOOL   Regular School No High 07 12 2021   grade_9                                                   78                                             78
2241157 2241157 MS     school 2801490 1800   FORREST COUNTY SCHOOL DISTRICT 280149000218 1800012 NORTH FORREST HIGH SCHOOL   Regular School No High 07 12 2021   grade_9                                                   62                                             62
2242828 2242828 MS     school 2802280 3400   JONES CO SCHOOL DIST 280228000443 3400024 NORTHEAST JONES HIGH SCHOOL   Regular School No High 07 12 2021   grade_9                                                   162                                             162
2242860 2242860 MS     school 2802280 3400   JONES CO SCHOOL DIST 280228000450 3400036 SOUTH JONES HIGH SCHOOL   Regular School No High 07 12 2021   grade_9                                                   226                                             226
2242878 2242878 MS     school 2802280 3400   JONES CO SCHOOL DIST 280228000451 3400052 WEST JONES HIGH SCHOOL   Regular School No High 07 12 2021   grade_9                                                   245                                             245
2243111 2243111 MS     school 2802430 3800   LAUDERDALE CO SCHOOL DIST 280243001348 3800005 CLARKDALE HIGH SCHOOL   Regular School No High 07 12 2021   grade_9                                                   66                                             66
2243329 2243329 MS     school 2802520 4000   LEAKE CO SCHOOL DIST 280252000490 4000016 LEAKE COUNTY HIGH SCHOOL   Regular School No High 07 12 2021   grade_9                                                   36                                             36
2243534 2243534 MS     school 2800198 4211   GREENWOOD-LEFLORE CONSOLIDATED SD 280019801518 4211020 LEFLORE COUNTY HIGH SCHOOL   Regular School No High 07 12 2021   grade_9                                                   66                                             66
2243677 2243677 MS     school 2802730 4400   LOWNDES CO SCHOOL DIST 280273000531 4400012 WEST LOWNDES HIGH SCHOOL   Regular School No High 07 12 2021   grade_9                                                   37                                             37
2243957 2243957 MS     school 2802820 4600   MARION CO SCHOOL DIST 280282000545 4600008 EAST MARION HIGH SCHOOL   Regular School No High 07 12 2021   grade_9                                                   46                                             46
2243969 2243969 MS     school 2802820 4600   MARION CO SCHOOL DIST 280282001247 4600014 WEST MARION HIGH SCHOOL   Regular School No High 07 12 2021   grade_9                                                   86                                             86
2244186 2244186 MS     school 2800196 4911   WINONA-MONTGOMERY CONSOLIDATED SD 280019601485 4911006 WINONA SECONDARY SCHOOL   Regular School No High 07 12 2021   grade_9                                                   89                                             89
2244227 2244227 MS     school 2803600 5020   PHILADELPHIA PUBLIC SCHOOL DIST 280360000692 5020008 PHILADELPHIA HIGH SCHOOL   Regular School No High 07 12 2021   grade_9                                                   70                                             70
2244523 2244523 MS     school 2803870 5620   RICHTON SCHOOL DIST 280387000744 5620004 RICHTON HIGH SCHOOL   Regular School No High 07 12 2021   grade_9                                                   45                                             45
2244895 2244895 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383000739 6100028 MCLAURIN ATTENDANCE CENTER   Regular School No High 07 12 2021   grade_9                                                   95                                             95
2244946 2244946 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383000740 6100044 PELAHATCHIE ATTENDANCE CENTER   Regular School No High 07 12 2021   grade_9                                                   69                                             69
2244974 2244974 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383001079 6100050 PISGAH HIGH SCHOOL   Regular School No High 07 12 2021   grade_9                                                   70                                             70
2244981 2244981 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383000742 6100052 PUCKETT ATTENDANCE CENTER   Regular School No High 07 12 2021   grade_9                                                   55                                             55
2244999 2244999 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383000743 6100056 RICHLAND HIGH SCHOOL   Regular School No High 07 12 2021   grade_9                                                   134                                             134
2245214 2245214 MS     school 2804020 6500   SMITH CO SCHOOL DIST 280402000759 6500008 RALEIGH HIGH SCHOOL   Regular School No High 07 12 2021   grade_9                                                   *                                              
2245312 2245312 MS     school 2800187 6711   SUNFLOWER CO CONSOLIDATE SCH DIST 280018701421 6711014 ROBERT L MERRITT JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2021   grade_9                                                   175                                             175
2245384 2245384 MS     school 2804650 6812   WEST TALLAHATCHIE SCHOOL DISTRICT 280465000873 6812036 WEST TALLAHATCHIE HIGH SCHOOL   Regular School No High 07 12 2021   grade_9                                                   43                                             43
2245409 2245409 MS     school 2804230 6900   TATE CO SCHOOL DIST 280423000800 6900012 INDEPENDENCE HIGH SCHOOL   Regular School No High 07 12 2021   grade_9                                                   91                                             91
2245416 2245416 MS     school 2804230 6900   TATE CO SCHOOL DIST 280423001508 6900014 COLDWATER HIGH SCHOOL   Regular School No High 07 12 2021   grade_9                                                   24                                             24
2245433 2245433 MS     school 2804230 6900   TATE CO SCHOOL DIST 280423001295 6900024 STRAYHORN HIGH SCHOOL   Regular School No High 07 12 2021   grade_9                                                   69                                             69
2245776 2245776 MS     school 2804440 7400   WALTHALL CO SCHOOL DIST 280444000836 7400016 TYLERTOWN HIGH SCHOOL   Regular School No High 07 12 2021   grade_9                                                   96                                             96
2245902 2245902 MS     school 2801890 7611   HOLLANDALE SCHOOL DIST 280189001037 7611012 SIMMONS HIGH SCHOOL   Regular School No High 07 12 2021   grade_9                                                   36                                             36
2245950 2245950 MS     school 2804680 7613   WESTERN LINE SCHOOL DISTRICT 280468000975 7613016 O'BANNON HIGH SCHOOL   Regular School No High 07 12 2021   grade_9                                                   74                                             74
2245958 2245958 MS     school 2804680 7613   WESTERN LINE SCHOOL DISTRICT 280468000976 7613020 RIVERSIDE HIGH SCHOOL   Regular School No High 07 12 2021   grade_9                                                   73                                             73
2246234 2246234 MS     school 2804500 8113   WATER VALLEY SCHOOL DISTRICT 280450000845 8113004 WATER VALLEY HIGH SCHOOL   Regular School No High 07 12 2021   grade_9                                                   79                                             79
2033521 2033521 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303001397 130045 NATCHEZ FRESHMAN ACADEMY   Regular School No Secondary 08 09 2020   grade_9                                                   *                                              

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);