enrollments

Data source: Big Local News · About: Big Local

238 rows where grade = "grade_11", state = "MS" and year = 2020 sorted by total_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 138 ✖

grade ✖

  • grade_11 · 138 ✖
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 ▼
2034184 2034184 MS     school 2801100 1402   COAHOMA EARLY COLLEGE HIGH SCHOOL 280110000137 1402004 COAHOMA EARLY COLLEGE HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   70                                             70
2037311 2037311 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279000541 4500016 VELMA JACKSON HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   71                                             71
2039466 2039466 MS     school 2804680 7613   WESTERN LINE SCHOOL DISTRICT 280468000976 7613020 RIVERSIDE HIGH SCHOOL   Regular School No High 07 12 2020   grade_11                                                   71                                             71
2037698 2037698 MS     school 2800196 4911   WINONA-MONTGOMERY CONSOLIDATED SD 280019601485 4911006 WINONA SECONDARY SCHOOL   Regular School No High 07 12 2020   grade_11                                                   72                                             72
2037787 2037787 MS     school 2804380 5131   UNION PUBLIC SCHOOL DIST 280438000825 5131004 UNION HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   72                                             72
2037871 2037871 MS     school 2803210 5411   NORTH PANOLA SCHOOLS 280321000630 5411016 NORTH PANOLA HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   72                                             72
2039661 2039661 MS     school 2804710 7900   WILKINSON CO SCHOOL DIST 280471000879 7900008 WILKINSON COUNTY HIGH   Regular School No High 09 12 2020   grade_11                                                   72                                             72
2037739 2037739 MS     school 2803600 5020   PHILADELPHIA PUBLIC SCHOOL DIST 280360000692 5020008 PHILADELPHIA HIGH SCHOOL   Regular School No High 07 12 2020   grade_11                                                   73                                             73
2037577 2037577 MS     school 2801950 4720   HOLLY SPRINGS SCHOOL DIST 280195000335 4720004 HOLLY SPRINGS HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   74                                             74
2034077 2034077 MS     school 2801440 1211   ENTERPRISE SCHOOL DIST 280144000211 1211008 ENTERPRISE HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   76                                             76
2038924 2038924 MS     school 2804230 6900   TATE CO SCHOOL DIST 280423000800 6900012 INDEPENDENCE HIGH SCHOOL   Regular School No High 07 12 2020   grade_11                                                   80                                             80
2039077 2039077 MS     school 2804260 7100   TISHOMINGO CO SP MUN SCH DIST 280426000803 7100004 BELMONT SCHOOL   Regular School No Other KG 12 2020   grade_11                                                   80                                             80
2038728 2038728 MS     school 2804020 6500   SMITH CO SCHOOL DIST 280402000759 6500008 RALEIGH HIGH SCHOOL   Regular School No High 07 12 2020   grade_11                                                   82                                             82
2039290 2039290 MS     school 2804440 7400   WALTHALL CO SCHOOL DIST 280444000836 7400016 TYLERTOWN HIGH SCHOOL   Regular School No High 07 12 2020   grade_11                                                   82                                             82
2034055 2034055 MS     school 2801020 1100   CLAIBORNE CO SCHOOL DIST 280102000116 1100008 PORT GIBSON HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   83                                             83
2038304 2038304 MS     school 2800820 5921   BOONEVILLE SCHOOL DIST 280082001024 5921012 BOONEVILLE HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   85                                             85
2038634 2038634 MS     school 2801470 6220   FOREST MUNICIPAL SCHOOL DIST 280147000213 6220008 FOREST HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   85                                             85
2038409 2038409 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383000739 6100028 MCLAURIN ATTENDANCE CENTER   Regular School No High 07 12 2020   grade_11                                                   86                                             86
2034777 2034777 MS     school 2801530 1900   FRANKLIN CO SCHOOL DIST 280153000224 1900010 FRANKLIN HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   88                                             88
2038673 2038673 MS     school 2803990 6400   SIMPSON CO SCHOOL DIST 280399000755 6400008 MAGEE HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   89                                             89
2038861 2038861 MS     school 2800187 6711   SUNFLOWER CO CONSOLIDATE SCH DIST 280018701422 6711032 THOMAS E. EDWARDS, SR. HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   90                                             90
2034340 2034340 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000182 1600024 SEMINARY HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   93                                             93
2037816 2037816 MS     school 2803300 5200   NOXUBEE COUNTY SCHOOL DISTRICT 280330000642 5200012 NOXUBEE COUNTY HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   93                                             93
2036242 2036242 MS     school 2802220 3200   JEFFERSON CO SCHOOL DIST 280222000427 3200008 JEFFERSON CO HIGH   Regular School No High 09 12 2020   grade_11                                                   95                                             95
2036909 2036909 MS     school 2803090 4111   NETTLETON SCHOOL DIST 280309000613 4111004 NETTLETON HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   95                                             95
2033563 2033563 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000018 200008 ALCORN CENTRAL HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   99                                             99
2037480 2037480 MS     school 2802820 4600   MARION CO SCHOOL DIST 280282001247 4600014 WEST MARION HIGH SCHOOL   Regular School No High 07 12 2020   grade_11                                                   99                                             99
2036649 2036649 MS     school 2802430 3800   LAUDERDALE CO SCHOOL DIST 280243000470 3800012 SOUTHEAST LAUDERDALE HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   101                                             101
2036997 2036997 MS     school 2800198 4211   GREENWOOD-LEFLORE CONSOLIDATED SD 280019801512 4211004 AMANDA ELZY HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   101                                             101
2037669 2037669 MS     school 2800450 4821   AMORY SCHOOL DIST 280045000029 4821008 AMORY HIGH SCHOOL   Regular School No High 08 12 2020   grade_11                                                   101                                             101
2038574 2038574 MS     school 2803900 6200   SCOTT CO SCHOOL DIST 280390001184 6200012 MORTON HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   103                                             103
2033593 2033593 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000020 200024 KOSSUTH HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   104                                             104
2034251 2034251 MS     school 2801220 1500   COPIAH CO SCHOOL DIST 280122000168 1500008 CRYSTAL SPRINGS HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   105                                             105
2035858 2035858 MS     school 2802040 2700   HUMPHREYS CO SCHOOL DIST 280204001041 2700010 HUMPHREYS COUNTY HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   105                                             105
2039138 2039138 MS     school 2804290 7200   TUNICA COUNTY SCHOOL DISTRICT 280429000808 7200008 ROSA FORT HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   108                                             108
2038099 2038099 MS     school 2804080 5712   SOUTH PIKE SCHOOL DIST 280408000773 5712028 SOUTH PIKE SENIOR HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   109                                             109
2037498 2037498 MS     school 2801170 4620   COLUMBIA SCHOOL DISTRICT 280117000149 4620008 COLUMBIA HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   110                                             110
2036844 2036844 MS     school 2802550 4100   LEE COUNTY SCHOOL DISTRICT 280255000494 4100008 MOOREVILLE HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   112                                             112
2037757 2037757 MS     school 2803150 5100   NEWTON COUNTY SCHOOL DISTRICT 280315001135 5100012 NEWTON COUNTY HIGH SCHOOL   Regular School No Other 01 12 2020   grade_11                                                   113                                             113
2036019 2036019 MS     school 2803000 3020   MOSS POINT SEPARATE SCHOOL DIST 280300000587 3020004 MOSS POINT HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   115                                             115
2039056 2039056 MS     school 2804110 7012   SOUTH TIPPAH SCHOOL DIST 280411000778 7012016 RIPLEY HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   115                                             115
2034887 2034887 MS     school 2801590 2100   GREENE COUNTY SCHOOL DISTRICT 280159000232 2100014 GREENE COUNTY HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   116                                             116
2033972 2033972 MS     school 2802010 920   HOUSTON SCHOOL DIST 280201000345 920006 HOUSTON HIGH SCHOOL   Regular School No High 06 12 2020   grade_11                                                   117                                             117
2036804 2036804 MS     school 2802520 4000   LEAKE CO SCHOOL DIST 280252000487 4000004 LEAKE CENTRAL HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   117                                             117
2038512 2038512 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383000743 6100056 RICHLAND HIGH SCHOOL   Regular School No High 07 12 2020   grade_11                                                   118                                             118
2039761 2039761 MS     school 2804800 8200   YAZOO CO SCHOOL DIST 280480000890 8200004 YAZOO COUNTY HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   122                                             122
2038963 2038963 MS     school 2803930 6920   SENATOBIA MUNICIPAL SCHOOL DIST 280393000751 6920008 SENATOBIA HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   124                                             124
2038174 2038174 MS     school 2803660 5800   PONTOTOC CO SCHOOL DIST 280366000703 5800008 South Pontotoc High School   Regular School No High 09 12 2020   grade_11                                                   127                                             127
2035322 2035322 MS     school 2801860 2500   HINDS CO SCHOOL DIST 280186000328 2500040 RAYMOND HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   128                                             128
2037216 2037216 MS     school 2801194 4406   MS SCH FOR MATH AND SC 280119401201 4406004 MS SCHOOL FOR MATH AND SCIENCE   Regular School No High 11 12 2020   grade_11                                                   128                                             128
2039805 2039805 MS     school 2804770 8220   YAZOO CITY MUNICIPAL SCHOOL DIST 280477000888 8220020 YAZOO CITY HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   129                                             129
2034099 2034099 MS     school 2803780 1212   QUITMAN SCHOOL DIST 280378000725 1212012 QUITMAN HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   130                                             130
2034672 2034672 MS     school 2801510 1802   FORREST COUNTY AG HIGH SCHOOL 280151000222 1802004 FORREST COUNTY AGRICULTURAL HI SCH   Regular School No High 09 12 2020   grade_11                                                   130                                             130
2033609 2033609 MS     school 2801260 220   CORINTH SCHOOL DIST 280126000171 220004 CORINTH HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   133                                             133
2037989 2037989 MS     school 2803720 5530   POPLARVILLE SEPARATE SCHOOL DIST 280372000708 5530008 POPLARVILLE JR SR HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   133                                             133
2036891 2036891 MS     school 2802550 4100   LEE COUNTY SCHOOL DISTRICT 280255000497 4100028 SHANNON HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   134                                             134
2035931 2035931 MS     school 2802100 2900   ITAWAMBA CO SCHOOL DIST 280210000949 2900030 ITAWAMBA AGRICULTURAL HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   136                                             136
2038132 2038132 MS     school 2802880 5720   MCCOMB SCHOOL DISTRICT 280288000556 5720012 MCCOMB HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   139                                             139
2038691 2038691 MS     school 2803990 6400   SIMPSON CO SCHOOL DIST 280399001086 6400014 MENDENHALL HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   140                                             140
2038846 2038846 MS     school 2800187 6711   SUNFLOWER CO CONSOLIDATE SCH DIST 280018701425 6711026 GENTRY HIGH SCHOOL   Regular School No High 10 12 2020   grade_11                                                   141                                             141
2036627 2036627 MS     school 2802430 3800   LAUDERDALE CO SCHOOL DIST 280243000469 3800008 NORTHEAST LAUDERDALE HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   145                                             145
2036677 2036677 MS     school 2802430 3800   LAUDERDALE CO SCHOOL DIST 280243001344 3800020 WEST LAUDERDALE HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   145                                             145
2037197 2037197 MS     school 2802730 4400   LOWNDES CO SCHOOL DIST 280273001127 4400016 NEW HOPE HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   146                                             146
2038150 2038150 MS     school 2803660 5800   PONTOTOC CO SCHOOL DIST 280366000701 5800004 North Pontotoc High School   Regular School No High 09 12 2020   grade_11                                                   147                                             147
2039227 2039227 MS     school 2803120 7320   NEW ALBANY PUBLIC SCHOOLS 280312000615 7320008 NEW ALBANY HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   147                                             147
2039114 2039114 MS     school 2804260 7100   TISHOMINGO CO SP MUN SCH DIST 280426001227 7100024 TISHOMINGO COUNTY HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   148                                             148
2035274 2035274 MS     school 2803510 2423   PASS CHRISTIAN PUBLIC SCHOOL DIST 280351000684 2423012 PASS CHRISTIAN HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   149                                             149
2036532 2036532 MS     school 2802400 3700   LAMAR COUNTY SCHOOL DISTRICT 280240001172 3700014 PURVIS HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   151                                             151
2037021 2037021 MS     school 2800198 4211   GREENWOOD-LEFLORE CONSOLIDATED SD 280019801516 4211016 GREENWOOD HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   152                                             152
2038196 2038196 MS     school 2803690 5820   PONTOTOC CITY SCHOOLS 280369000706 5820012 PONTOTOC HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   152                                             152
2034188 2034188 MS     school 2801050 1420   CLARKSDALE MUNICIPAL SCHOOL DIST 280105000118 1420004 CLARKSDALE HIGH SCHOOL   Regular School No High 10 12 2020   grade_11                                                   154                                             154
2037136 2037136 MS     school 2800840 4320   BROOKHAVEN SCHOOL DIST 280084000092 4320012 BROOKHAVEN HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   157                                             157
2036320 2036320 MS     school 2802280 3400   JONES CO SCHOOL DIST 280228000443 3400024 NORTHEAST JONES HIGH SCHOOL   Regular School No High 07 12 2020   grade_11                                                   158                                             158
2035529 2035529 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000396 2520048 LANIER HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   160                                             160
2038068 2038068 MS     school 2803240 5711   NORTH PIKE SCHOOL DIST 280324000636 5711016 NORTH PIKE SENIOR HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   163                                             163
2036446 2036446 MS     school 2802370 3600   LAFAYETTE CO SCHOOL DIST 280237000463 3600008 LAFAYETTE HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   168                                             168
2033517 2033517 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000608 130044 NATCHEZ HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   171                                             171
2036404 2036404 MS     school 2802460 3420   LAUREL SCHOOL DISTRICT 280246000479 3420040 LAUREL HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   171                                             171
2038378 2038378 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383001075 6100022 FLORENCE HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   171                                             171
2038776 2038776 MS     school 2804170 6600   STONE CO SCHOOL DIST 280417000790 6600012 STONE HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   175                                             175
2034135 2034135 MS     school 2800191 1321   WEST POINT CONSOLIDATED SCHOOL DIST 280019101441 1321020 WEST POINT HIGH SCHOOL   Regular School No High 08 12 2020   grade_11                                                   180                                             180
2035992 2035992 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216001050 3000020 VANCLEAVE HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   180                                             180
2036874 2036874 MS     school 2802550 4100   LEE COUNTY SCHOOL DISTRICT 280255000496 4100024 SALTILLO HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   184                                             184
2036369 2036369 MS     school 2802280 3400   JONES CO SCHOOL DIST 280228000451 3400052 WEST JONES HIGH SCHOOL   Regular School No High 07 12 2020   grade_11                                                   185                                             185
2036351 2036351 MS     school 2802280 3400   JONES CO SCHOOL DIST 280228000450 3400036 SOUTH JONES HIGH SCHOOL   Regular School No High 07 12 2020   grade_11                                                   186                                             186
2037409 2037409 MS     school 2800900 4520   CANTON PUBLIC SCHOOL DIST 280090000101 4520008 CANTON PUBLIC HIGH SCHOOL   Regular School No High 10 12 2020   grade_11                                                   187                                             187
2033754 2033754 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075001477 614009 CLEVELAND CENTRAL HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   192                                             192
2039369 2039369 MS     school 2804470 7500   VICKSBURG WARREN SCHOOL DIST 280447000830 7500025 VICKSBURG HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   192                                             192
2035821 2035821 MS     school 2800195 2611   HOLMES CONSOLIDATE SCHOOL DIST 280019501488 2611010 HOLMES COUNTY CENTRAL HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   196                                             196
2035726 2035726 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000423 2520089 WINGFIELD HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   204                                             204
2035469 2035469 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000390 2520039 JIM HILL HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   206                                             206
2037379 2037379 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279001257 4500046 RIDGELAND HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   206                                             206
2035244 2035244 MS     school 2802670 2422   LONG BEACH SCHOOL DIST 280267000520 2422016 LONG BEACH SENIOR HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   208                                             208
2034678 2034678 MS     school 2801800 1820   HATTIESBURG PUBLIC SCHOOL DIST 280180000310 1820008 HATTIESBURG HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   214                                             214
2036142 2036142 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348000935 3022042 GAUTIER HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   214                                             214
2035621 2035621 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000409 2520068 PROVINE HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   215                                             215
2037231 2037231 MS     school 2801200 4420   COLUMBUS MUNICIPAL SCHOOL DIST 280120000154 4420016 COLUMBUS HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   215                                             215
2037949 2037949 MS     school 2803630 5520   PICAYUNE SCHOOL DIST 280363000695 5520016 PICAYUNE MEMORIAL HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   217                                             217
2034592 2034592 MS     school 2801320 1700   DESOTO CO SCHOOL DIST 280132001357 1700082 LAKE CORMORANT HIGH   Regular School No High 09 12 2020   grade_11                                                   218                                             218
2035405 2035405 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000377 2520018 CALLAWAY HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   222                                             222

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