enrollments

Data source: Big Local News · About: Big Local

549 rows where grade = "grade_8" and state = "MS" sorted by ccd_school_high_grade descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_8 · 549 ✖
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
2033544 2033544 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001152 200004 BIGGERSVILLE HIGH SCHOOL   Regular School No High 07 12 2020   grade_8                                                   29                                             29
2033621 2033621 MS     school 2800420 300   AMITE CO SCHOOL DIST 280042000027 300008 AMITE COUNTY HIGH SCHOOL   Regular School No High 07 12 2020   grade_8                                                   65                                             65
2033639 2033639 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000036 400008 ETHEL ATTENDANCE CENTER   Regular School No High 07 12 2020   grade_8                                                   48                                             48
2033667 2033667 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000039 400020 MCADAMS ATTENDANCE CENTER   Regular School No High 07 12 2020   grade_8                                                   35                                             35
2033711 2033711 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000049 500006 ASHLAND MIDDLE-HIGH SCHOOL   Regular School No High 07 12 2020   grade_8                                                   39                                             39
2033727 2033727 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000050 500008 HICKORY FLAT ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_8                                                   38                                             38
2033799 2033799 MS     school 2800186 617   NORTH BOLIVAR CONS SCH 280018601411 617010 NORTHSIDE HIGH SCHOOL   Regular School No High 07 12 2020   grade_8                                                   *                                              
2033835 2033835 MS     school 2800185 618   WEST BOLIVAR CONS SCHOOL DISTRICT 280018501402 618010 RAY BROOKS SCHOOL   Regular School No Other KG 12 2020   grade_8                                                   12                                             12
2033878 2033878 MS     school 2800870 700   CALHOUN CO SCHOOL DIST 280087000097 700006 BRUCE HIGH SCHOOL   Regular School No High 05 12 2020   grade_8                                                   70                                             70
2033899 2033899 MS     school 2800870 700   CALHOUN CO SCHOOL DIST 280087000098 700010 CALHOUN CITY HIGH SCHOOL   Regular School No High 05 12 2020   grade_8                                                   57                                             57
2033917 2033917 MS     school 2800870 700   CALHOUN CO SCHOOL DIST 280087000099 700014 VARDAMAN HIGH SCHOOL   Regular School No High 07 12 2020   grade_8                                                   46                                             46
2033927 2033927 MS     school 2800930 800   CARROLL COUNTY SCHOOL DIST 280093000104 800004 J Z GEORGE HIGH SCHOOL   Regular School No High 06 12 2020   grade_8                                                   69                                             69
2033955 2033955 MS     school 2800960 900   CHICKASAW CO SCHOOL DIST 280096000108 900004 HOULKA ATTENDANCE CENTER   Regular School No Other PK 12 2020   grade_8                                                   38                                             38
2034014 2034014 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000111 1000008 CHOCTAW COUNTY HIGH SCHOOL   Regular School No High 07 12 2020   grade_8                                                   79                                             79
2034132 2034132 MS     school 2800191 1321   WEST POINT CONSOLIDATED SCHOOL DIST 280019101441 1321020 WEST POINT HIGH SCHOOL   Regular School No High 08 12 2020   grade_8                                                   241                                             241
2034140 2034140 MS     school 2801110 1400   COAHOMA COUNTY SCHOOL DISTRICT 280111000139 1400004 COAHOMA COUNTY JR/SR HIGH SCHOOL   Regular School No High 07 12 2020   grade_8                                                   101                                             101
2034264 2034264 MS     school 2801220 1500   COPIAH CO SCHOOL DIST 280122000169 1500012 WESSON ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_8                                                   78                                             78
2034331 2034331 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000181 1600020 MOUNT OLIVE ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_8                                                   35                                             35
2034625 2034625 MS     school 2801490 1800   FORREST COUNTY SCHOOL DISTRICT 280149000218 1800012 NORTH FORREST HIGH SCHOOL   Regular School No High 07 12 2020   grade_8                                                   64                                             64
2035781 2035781 MS     school 2801189 2560   MS SCH FOR THE BLIND AND DEAF 280118901504 2560002 MS SCHOOL FOR THE DEAF   Special Education School No Other KG 12 2020   grade_8                                                   *                                              
2035794 2035794 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_8                                                   *                                              
2035905 2035905 MS     school 2802100 2900   ITAWAMBA CO SCHOOL DIST 280210000361 2900024 MANTACHIE ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_8                                                   88                                             88
2035921 2035921 MS     school 2802100 2900   ITAWAMBA CO SCHOOL DIST 280210000362 2900028 TREMONT ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_8                                                   33                                             33
2036226 2036226 MS     school 2804590 3112   WEST JASPER CONSOLIDATED SCHOOLS 280459000859 3112012 STRINGER ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_8                                                   62                                             62
2036317 2036317 MS     school 2802280 3400   JONES CO SCHOOL DIST 280228000443 3400024 NORTHEAST JONES HIGH SCHOOL   Regular School No High 07 12 2020   grade_8                                                   167                                             167
2036348 2036348 MS     school 2802280 3400   JONES CO SCHOOL DIST 280228000450 3400036 SOUTH JONES HIGH SCHOOL   Regular School No High 07 12 2020   grade_8                                                   231                                             231
2036366 2036366 MS     school 2802280 3400   JONES CO SCHOOL DIST 280228000451 3400052 WEST JONES HIGH SCHOOL   Regular School No High 07 12 2020   grade_8                                                   246                                             246
2036825 2036825 MS     school 2802520 4000   LEAKE CO SCHOOL DIST 280252000490 4000016 LEAKE COUNTY HIGH SCHOOL   Regular School No High 07 12 2020   grade_8                                                   43                                             43
2037032 2037032 MS     school 2800198 4211   GREENWOOD-LEFLORE CONSOLIDATED SD 280019801518 4211020 LEFLORE COUNTY HIGH SCHOOL   Regular School No High 07 12 2020   grade_8                                                   71                                             71
2037071 2037071 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000512 4300004 BOGUE CHITTO SCHOOL   Regular School No Other KG 12 2020   grade_8                                                   58                                             58
2037085 2037085 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000513 4300008 ENTERPRISE SCHOOL   Regular School No Other KG 12 2020   grade_8                                                   47                                             47
2037100 2037100 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000515 4300016 LOYD STAR SCHOOL   Regular School No Other KG 12 2020   grade_8                                                   64                                             64
2037117 2037117 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000516 4300020 WEST LINCOLN SCHOOL   Regular School No Other KG 12 2020   grade_8                                                   58                                             58
2037179 2037179 MS     school 2802730 4400   LOWNDES CO SCHOOL DIST 280273000531 4400012 WEST LOWNDES HIGH SCHOOL   Regular School No High 07 12 2020   grade_8                                                   35                                             35
2037464 2037464 MS     school 2802820 4600   MARION CO SCHOOL DIST 280282000545 4600008 EAST MARION HIGH SCHOOL   Regular School No High 07 12 2020   grade_8                                                   46                                             46
2037477 2037477 MS     school 2802820 4600   MARION CO SCHOOL DIST 280282001247 4600014 WEST MARION HIGH SCHOOL   Regular School No High 07 12 2020   grade_8                                                   94                                             94
2037542 2037542 MS     school 2802850 4700   MARSHALL CO SCHOOL DIST 280285000551 4700016 POTTS CAMP HIGH SCHOOL (7-12)   Regular School No High 07 12 2020   grade_8                                                   65                                             65
2037568 2037568 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_8                                                   49                                             49
2037604 2037604 MS     school 2802940 4800   MONROE CO SCHOOL DIST 280294000580 4800012 HAMILTON HIGH SCHOOL   Regular School No Other KG 12 2020   grade_8                                                   52                                             52
2037620 2037620 MS     school 2802940 4800   MONROE CO SCHOOL DIST 280294000581 4800016 HATLEY HIGH SCHOOL   Regular School No Other KG 12 2020   grade_8                                                   76                                             76
2037635 2037635 MS     school 2802940 4800   MONROE CO SCHOOL DIST 280294000582 4800020 SMITHVILLE HIGH SCHOOL   Regular School No Other KG 12 2020   grade_8                                                   51                                             51
2037695 2037695 MS     school 2800196 4911   WINONA-MONTGOMERY CONSOLIDATED SD 280019601485 4911006 WINONA SECONDARY SCHOOL   Regular School No High 07 12 2020   grade_8                                                   91                                             91
2037736 2037736 MS     school 2803600 5020   PHILADELPHIA PUBLIC SCHOOL DIST 280360000692 5020008 PHILADELPHIA HIGH SCHOOL   Regular School No High 07 12 2020   grade_8                                                   73                                             73
2037754 2037754 MS     school 2803150 5100   NEWTON COUNTY SCHOOL DISTRICT 280315001135 5100012 NEWTON COUNTY HIGH SCHOOL   Regular School No Other 01 12 2020   grade_8                                                   139                                             139
2038036 2038036 MS     school 2803870 5620   RICHTON SCHOOL DIST 280387000744 5620004 RICHTON HIGH SCHOOL   Regular School No High 07 12 2020   grade_8                                                   56                                             56
2038222 2038222 MS     school 2803750 5900   PRENTISS CO SCHOOL DIST 280375000717 5900020 JUMPERTOWN HIGH SCHOOL   Regular School No Other PK 12 2020   grade_8                                                   21                                             21
2038256 2038256 MS     school 2803750 5900   PRENTISS CO SCHOOL DIST 280375000721 5900032 THRASHER HIGH SCHOOL   Regular School No Other PK 12 2020   grade_8                                                   23                                             23
2038272 2038272 MS     school 2803750 5900   PRENTISS CO SCHOOL DIST 280375000722 5900036 WHEELER HIGH SCHOOL   Regular School No Other KG 12 2020   grade_8                                                   44                                             44
2038289 2038289 MS     school 2800540 5920   BALDWYN SCHOOL DISTRICT 280054000042 5920008 BALDWYN HIGH SCHOOL   Regular School No High 05 12 2020   grade_8                                                   56                                             56
2038406 2038406 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383000739 6100028 MCLAURIN ATTENDANCE CENTER   Regular School No High 07 12 2020   grade_8                                                   94                                             94
2038457 2038457 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383000740 6100044 PELAHATCHIE ATTENDANCE CENTER   Regular School No High 07 12 2020   grade_8                                                   71                                             71
2038485 2038485 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383001079 6100050 PISGAH HIGH SCHOOL   Regular School No High 07 12 2020   grade_8                                                   69                                             69
2038492 2038492 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383000742 6100052 PUCKETT ATTENDANCE CENTER   Regular School No High 07 12 2020   grade_8                                                   60                                             60
2038509 2038509 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383000743 6100056 RICHLAND HIGH SCHOOL   Regular School No High 07 12 2020   grade_8                                                   141                                             141
2038587 2038587 MS     school 2803900 6200   SCOTT CO SCHOOL DIST 280390000748 6200016 SCOTT CENTRAL ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_8                                                   72                                             72
2038603 2038603 MS     school 2803900 6200   SCOTT CO SCHOOL DIST 280390000749 6200020 SEBASTOPOL ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_8                                                   48                                             48
2038717 2038717 MS     school 2804020 6500   SMITH CO SCHOOL DIST 280402000758 6500004 MIZE ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_8                                                   59                                             59
2038725 2038725 MS     school 2804020 6500   SMITH CO SCHOOL DIST 280402000759 6500008 RALEIGH HIGH SCHOOL   Regular School No High 07 12 2020   grade_8                                                   67                                             67
2038751 2038751 MS     school 2804020 6500   SMITH CO SCHOOL DIST 280402000762 6500012 TAYLORSVILLE ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_8                                                   45                                             45
2038896 2038896 MS     school 2804650 6812   WEST TALLAHATCHIE SCHOOL DISTRICT 280465000873 6812036 WEST TALLAHATCHIE HIGH SCHOOL   Regular School No High 07 12 2020   grade_8                                                   41                                             41
2038921 2038921 MS     school 2804230 6900   TATE CO SCHOOL DIST 280423000800 6900012 INDEPENDENCE HIGH SCHOOL   Regular School No High 07 12 2020   grade_8                                                   98                                             98
2038928 2038928 MS     school 2804230 6900   TATE CO SCHOOL DIST 280423001508 6900014 COLDWATER HIGH SCHOOL   Regular School No High 07 12 2020   grade_8                                                   25                                             25
2038944 2038944 MS     school 2804230 6900   TATE CO SCHOOL DIST 280423001295 6900024 STRAYHORN HIGH SCHOOL   Regular School No High 07 12 2020   grade_8                                                   67                                             67
2038994 2038994 MS     school 2803270 7011   NORTH TIPPAH SCHOOL DIST 280327000638 7011008 FALKNER HIGH SCHOOL   Regular School No High 07 12 2020   grade_8                                                   44                                             44
2039009 2039009 MS     school 2803270 7011   NORTH TIPPAH SCHOOL DIST 280327000640 7011012 WALNUT ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_8                                                   *                                              
2039026 2039026 MS     school 2804110 7012   SOUTH TIPPAH SCHOOL DIST 280411000775 7012004 BLUE MOUNTAIN HIGH SCHOOL   Regular School No Other PK 12 2020   grade_8                                                   31                                             31
2039041 2039041 MS     school 2804110 7012   SOUTH TIPPAH SCHOOL DIST 280411000776 7012008 PINE GROVE HIGH SCHOOL   Regular School No Other PK 12 2020   grade_8                                                   63                                             63
2039074 2039074 MS     school 2804260 7100   TISHOMINGO CO SP MUN SCH DIST 280426000803 7100004 BELMONT SCHOOL   Regular School No Other KG 12 2020   grade_8                                                   57                                             57
2039166 2039166 MS     school 2804350 7300   UNION CO SCHOOL DIST 280435000821 7300004 EAST UNION ATTENDANCE CENTER   Regular School No Other PK 12 2020   grade_8                                                   58                                             58
2039183 2039183 MS     school 2804350 7300   UNION CO SCHOOL DIST 280435000822 7300008 INGOMAR ATTENDANCE CENTER   Regular School No Other PK 12 2020   grade_8                                                   52                                             52
2039201 2039201 MS     school 2804350 7300   UNION CO SCHOOL DIST 280435000823 7300012 MYRTLE ATTENDANCE CENTER   Regular School No Other PK 12 2020   grade_8                                                   56                                             56
2039218 2039218 MS     school 2804350 7300   UNION CO SCHOOL DIST 280435000824 7300016 WEST UNION ATTENDANCE CENTER   Regular School No Other PK 12 2020   grade_8                                                   49                                             49
2039267 2039267 MS     school 2804440 7400   WALTHALL CO SCHOOL DIST 280444000834 7400008 SALEM ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_8                                                   50                                             50
2039287 2039287 MS     school 2804440 7400   WALTHALL CO SCHOOL DIST 280444000836 7400016 TYLERTOWN HIGH SCHOOL   Regular School No High 07 12 2020   grade_8                                                   105                                             105
2039407 2039407 MS     school 2801890 7611   HOLLANDALE SCHOOL DIST 280189001037 7611012 SIMMONS HIGH SCHOOL   Regular School No High 07 12 2020   grade_8                                                   46                                             46
2039455 2039455 MS     school 2804680 7613   WESTERN LINE SCHOOL DISTRICT 280468000975 7613016 O'BANNON HIGH SCHOOL   Regular School No High 07 12 2020   grade_8                                                   77                                             77
2039463 2039463 MS     school 2804680 7613   WESTERN LINE SCHOOL DISTRICT 280468000976 7613020 RIVERSIDE HIGH SCHOOL   Regular School No High 07 12 2020   grade_8                                                   82                                             82
2039602 2039602 MS     school 2804560 7800   WEBSTER CO SCHOOL DIST 280456000852 7800004 EAST WEBSTER HIGH SCHOOL   Regular School No High 06 12 2020   grade_8                                                   80                                             80
2039621 2039621 MS     school 2804560 7800   WEBSTER CO SCHOOL DIST 280456001097 7800010 EUPORA HIGH SCHOOL   Regular School No High 06 12 2020   grade_8                                                   90                                             90
2039701 2039701 MS     school 2802700 8020   LOUISVILLE MUNICIPAL SCHOOL DIST 280270000526 8020016 NANIH WAIYA ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_8                                                   42                                             42
2039716 2039716 MS     school 2802700 8020   LOUISVILLE MUNICIPAL SCHOOL DIST 280270000527 8020020 NOXAPATER ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_8                                                   22                                             22
2039734 2039734 MS     school 2801140 8111   COFFEEVILLE SCHOOL DIST 280114000146 8111006 COFFEEVILLE HIGH SCHOOL   Regular School No High 08 12 2020   grade_8                                                   44                                             44
2039742 2039742 MS     school 2804500 8113   WATER VALLEY SCHOOL DISTRICT 280450000845 8113004 WATER VALLEY HIGH SCHOOL   Regular School No High 07 12 2020   grade_8                                                   80                                             80
2240101 2240101 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001152 200004 BIGGERSVILLE HIGH SCHOOL   Regular School No High 07 12 2021   grade_8                                                   43                                             43
2240177 2240177 MS     school 2800420 300   AMITE CO SCHOOL DIST 280042000027 300008 AMITE COUNTY HIGH SCHOOL   Regular School No High 07 12 2021   grade_8                                                   84                                             84
2240195 2240195 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000036 400008 ETHEL ATTENDANCE CENTER   Regular School No High 07 12 2021   grade_8                                                   49                                             49
2240223 2240223 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000039 400020 MCADAMS ATTENDANCE CENTER   Regular School No High 07 12 2021   grade_8                                                   29                                             29
2240263 2240263 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000049 500006 ASHLAND MIDDLE-HIGH SCHOOL   Regular School No High 07 12 2021   grade_8                                                   35                                             35
2240279 2240279 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000050 500008 HICKORY FLAT ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_8                                                   45                                             45
2240352 2240352 MS     school 2800186 617   NORTH BOLIVAR CONS SCH 280018601411 617010 NORTHSIDE HIGH SCHOOL   Regular School No High 07 12 2021   grade_8                                                   69                                             69
2240369 2240369 MS     school 2800185 618   WEST BOLIVAR CONS SCHOOL DISTRICT 280018501526 618009 WEST BOLIVAR HIGH SCHOOL   Regular School No High 07 12 2021   grade_8                                                   36                                             36
2240385 2240385 MS     school 2800185 618   WEST BOLIVAR CONS SCHOOL DISTRICT 280018501527 618015 MCEVANS SCHOOL   Regular School No Other KG 12 2021   grade_8                                                   36                                             36
2240415 2240415 MS     school 2800870 700   CALHOUN CO SCHOOL DIST 280087000097 700006 BRUCE HIGH SCHOOL   Regular School No High 05 12 2021   grade_8                                                   74                                             74
2240435 2240435 MS     school 2800870 700   CALHOUN CO SCHOOL DIST 280087000098 700010 CALHOUN CITY HIGH SCHOOL   Regular School No High 05 12 2021   grade_8                                                   62                                             62
2240453 2240453 MS     school 2800870 700   CALHOUN CO SCHOOL DIST 280087000099 700014 VARDAMAN HIGH SCHOOL   Regular School No High 07 12 2021   grade_8                                                   49                                             49
2240462 2240462 MS     school 2800930 800   CARROLL COUNTY SCHOOL DIST 280093000104 800004 J Z GEORGE HIGH SCHOOL   Regular School No High 06 12 2021   grade_8                                                   68                                             68
2240490 2240490 MS     school 2800960 900   CHICKASAW CO SCHOOL DIST 280096000108 900004 HOULKA ATTENDANCE CENTER   Regular School No Other PK 12 2021   grade_8                                                   51                                             51
2240550 2240550 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000111 1000008 CHOCTAW COUNTY HIGH SCHOOL   Regular School No High 07 12 2021   grade_8                                                   97                                             97
2240668 2240668 MS     school 2800191 1321   WEST POINT CONSOLIDATED SCHOOL DIST 280019101441 1321020 WEST POINT HIGH SCHOOL   Regular School No High 08 12 2021   grade_8                                                   261                                             261
2240676 2240676 MS     school 2801110 1400   COAHOMA COUNTY SCHOOL DISTRICT 280111000139 1400004 COAHOMA COUNTY JR/SR HIGH SCHOOL   Regular School No High 07 12 2021   grade_8                                                   94                                             94

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