enrollments

Data source: Big Local News · About: Big Local

237 rows where grade = "grade_11", state = "MS" and year = 2021

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 137 ✖

grade ✖

  • grade_11 · 137 ✖
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
2243036 2243036 MS     school 2802400 3700   LAMAR COUNTY SCHOOL DISTRICT 280240001172 3700014 PURVIS HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   *                                              
2243055 2243055 MS     school 2802400 3700   LAMAR COUNTY SCHOOL DISTRICT 280240001173 3700018 SUMRALL HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   159                                             159
2243098 2243098 MS     school 2802400 3700   LAMAR COUNTY SCHOOL DISTRICT 280240001484 3700026 LUMBERTON HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   40                                             40
2243113 2243113 MS     school 2802430 3800   LAUDERDALE CO SCHOOL DIST 280243001348 3800005 CLARKDALE HIGH SCHOOL   Regular School No High 07 12 2021   grade_11                                                   78                                             78
2243127 2243127 MS     school 2802430 3800   LAUDERDALE CO SCHOOL DIST 280243000469 3800008 NORTHEAST LAUDERDALE HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   137                                             137
2243149 2243149 MS     school 2802430 3800   LAUDERDALE CO SCHOOL DIST 280243000470 3800012 SOUTHEAST LAUDERDALE HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   *                                              
2243178 2243178 MS     school 2802430 3800   LAUDERDALE CO SCHOOL DIST 280243001344 3800020 WEST LAUDERDALE HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   149                                             149
2243202 2243202 MS     school 2802910 3820   MERIDIAN PUBLIC SCHOOL DIST 280291000567 3820036 MERIDIAN HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   317                                             317
2243272 2243272 MS     school 2802490 3900   LAWRENCE CO SCHOOL DIST 280249000482 3900012 LAWRENCE COUNTY HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   130                                             130
2243307 2243307 MS     school 2802520 4000   LEAKE CO SCHOOL DIST 280252000487 4000004 LEAKE CENTRAL HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   119                                             119
2243331 2243331 MS     school 2802520 4000   LEAKE CO SCHOOL DIST 280252000490 4000016 LEAKE COUNTY HIGH SCHOOL   Regular School No High 07 12 2021   grade_11                                                   34                                             34
2243346 2243346 MS     school 2802550 4100   LEE COUNTY SCHOOL DISTRICT 280255000494 4100008 MOOREVILLE HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   129                                             129
2243377 2243377 MS     school 2802550 4100   LEE COUNTY SCHOOL DISTRICT 280255000496 4100024 SALTILLO HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   227                                             227
2243393 2243393 MS     school 2802550 4100   LEE COUNTY SCHOOL DISTRICT 280255000497 4100028 SHANNON HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   120                                             120
2243411 2243411 MS     school 2803090 4111   NETTLETON SCHOOL DIST 280309000613 4111004 NETTLETON HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   96                                             96
2243478 2243478 MS     school 2804320 4120   TUPELO PUBLIC SCHOOL DIST 280432000819 4120040 TUPELO HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   500                                             500
2243498 2243498 MS     school 2800198 4211   GREENWOOD-LEFLORE CONSOLIDATED SD 280019801512 4211004 AMANDA ELZY HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   *                                              
2243522 2243522 MS     school 2800198 4211   GREENWOOD-LEFLORE CONSOLIDATED SD 280019801516 4211016 GREENWOOD HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   150                                             150
2243536 2243536 MS     school 2800198 4211   GREENWOOD-LEFLORE CONSOLIDATED SD 280019801518 4211020 LEFLORE COUNTY HIGH SCHOOL   Regular School No High 07 12 2021   grade_11                                                   37                                             37
2243577 2243577 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000512 4300004 BOGUE CHITTO SCHOOL   Regular School No Other PK 12 2021   grade_11                                                   44                                             44
2243591 2243591 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000513 4300008 ENTERPRISE SCHOOL   Regular School No Other KG 12 2021   grade_11                                                   57                                             57
2243606 2243606 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000515 4300016 LOYD STAR SCHOOL   Regular School No Other PK 12 2021   grade_11                                                   47                                             47
2243624 2243624 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000516 4300020 WEST LINCOLN SCHOOL   Regular School No Other PK 12 2021   grade_11                                                   44                                             44
2243627 2243627 MS     school 2800031 4306   MS SCHOOL FOR THE ARTS 280003101574 4306004 MS SCHOOL FOR THE ARTS   Regular School No High 11 12 2021   grade_11                                                   53                                             53
2243639 2243639 MS     school 2800840 4320   BROOKHAVEN SCHOOL DIST 280084000092 4320012 BROOKHAVEN HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   195                                             195
2243665 2243665 MS     school 2802730 4400   LOWNDES CO SCHOOL DIST 280273001125 4400004 CALEDONIA HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   158                                             158
2243679 2243679 MS     school 2802730 4400   LOWNDES CO SCHOOL DIST 280273000531 4400012 WEST LOWNDES HIGH SCHOOL   Regular School No High 07 12 2021   grade_11                                                   42                                             42
2243694 2243694 MS     school 2802730 4400   LOWNDES CO SCHOOL DIST 280273001127 4400016 NEW HOPE HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   166                                             166
2243713 2243713 MS     school 2801194 4406   MS SCH FOR MATH AND SC 280119401201 4406004 MS SCHOOL FOR MATH AND SCIENCE   Regular School No High 11 12 2021   grade_11                                                   115                                             115
2243728 2243728 MS     school 2801200 4420   COLUMBUS MUNICIPAL SCHOOL DIST 280120000154 4420016 COLUMBUS HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   238                                             238
2243804 2243804 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279000541 4500016 VELMA JACKSON HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   63                                             63
2243855 2243855 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279001220 4500036 MADISON CENTRAL HIGH SCHOOL   Regular School No High 10 12 2021   grade_11                                                   *                                              
2243871 2243871 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279001257 4500046 RIDGELAND HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   213                                             213
2243888 2243888 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279001381 4500066 GERMANTOWN HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   292                                             292
2243901 2243901 MS     school 2800900 4520   CANTON PUBLIC SCHOOL DIST 280090000101 4520008 CANTON PUBLIC HIGH SCHOOL   Regular School No High 10 12 2021   grade_11                                                   204                                             204
2243959 2243959 MS     school 2802820 4600   MARION CO SCHOOL DIST 280282000545 4600008 EAST MARION HIGH SCHOOL   Regular School No High 07 12 2021   grade_11                                                   60                                             60
2243971 2243971 MS     school 2802820 4600   MARION CO SCHOOL DIST 280282001247 4600014 WEST MARION HIGH SCHOOL   Regular School No High 07 12 2021   grade_11                                                   103                                             103
2243989 2243989 MS     school 2801170 4620   COLUMBIA SCHOOL DISTRICT 280117000149 4620008 COLUMBIA HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   129                                             129
2244003 2244003 MS     school 2802850 4700   MARSHALL CO SCHOOL DIST 280285000548 4700004 BYHALIA HIGH SCHOOL (9-12)   Regular School No High 09 12 2021   grade_11                                                   90                                             90
2244037 2244037 MS     school 2802850 4700   MARSHALL CO SCHOOL DIST 280285000551 4700016 POTTS CAMP HIGH SCHOOL (4-12)   Regular School No Other 04 12 2021   grade_11                                                   44                                             44
2244061 2244061 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_11                                                   38                                             38
2244067 2244067 MS     school 2801950 4720   HOLLY SPRINGS SCHOOL DIST 280195000335 4720004 HOLLY SPRINGS HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   *                                              
2244096 2244096 MS     school 2802940 4800   MONROE CO SCHOOL DIST 280294000580 4800012 HAMILTON HIGH SCHOOL   Regular School No Other PK 12 2021   grade_11                                                   41                                             41
2244112 2244112 MS     school 2802940 4800   MONROE CO SCHOOL DIST 280294000581 4800016 HATLEY HIGH SCHOOL   Regular School No Other PK 12 2021   grade_11                                                   78                                             78
2244127 2244127 MS     school 2802940 4800   MONROE CO SCHOOL DIST 280294000582 4800020 SMITHVILLE HIGH SCHOOL   Regular School No Other PK 12 2021   grade_11                                                   43                                             43
2244139 2244139 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036000009 4820008 ABERDEEN HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   100                                             100
2244158 2244158 MS     school 2800450 4821   AMORY SCHOOL DIST 280045000029 4821008 AMORY HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   110                                             110
2244188 2244188 MS     school 2800196 4911   WINONA-MONTGOMERY CONSOLIDATED SD 280019601485 4911006 WINONA SECONDARY SCHOOL   Regular School No High 07 12 2021   grade_11                                                   71                                             71
2244210 2244210 MS     school 2803060 5000   NESHOBA COUNTY SCHOOL DISTRICT 280306000612 5000008 NESHOBA CENTRAL HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   243                                             243
2244229 2244229 MS     school 2803600 5020   PHILADELPHIA PUBLIC SCHOOL DIST 280360000692 5020008 PHILADELPHIA HIGH SCHOOL   Regular School No High 07 12 2021   grade_11                                                   67                                             67
2244247 2244247 MS     school 2803150 5100   NEWTON COUNTY SCHOOL DISTRICT 280315001135 5100012 NEWTON COUNTY HIGH SCHOOL   Regular School No High 06 12 2021   grade_11                                                   117                                             117
2244265 2244265 MS     school 2803180 5130   NEWTON MUNICIPAL SCHOOL DISTRICT 280318000626 5130008 NEWTON HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   67                                             67
2244277 2244277 MS     school 2804380 5131   UNION PUBLIC SCHOOL DIST 280438000825 5131004 UNION HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   *                                              
2244305 2244305 MS     school 2803300 5200   NOXUBEE COUNTY SCHOOL DISTRICT 280330000642 5200012 NOXUBEE COUNTY HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   *                                              
2244327 2244327 MS     school 2800189 5321   STARKVILLE- OKTIBBEHA CONS SD 280018901451 5321016 STARKVILLE HIGH SCHOOL   Regular School No High 10 12 2021   grade_11                                                   314                                             314
2244362 2244362 MS     school 2803210 5411   NORTH PANOLA SCHOOLS 280321000630 5411016 NORTH PANOLA HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   107                                             107
2244393 2244393 MS     school 2804050 5412   SOUTH PANOLA SCHOOL DISTRICT 280405000766 5412016 SOUTH PANOLA HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   270                                             270
2244413 2244413 MS     school 2803540 5500   PEARL RIVER CO SCHOOL DIST 280354001070 5500012 PEARL RIVER CENTRAL HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   261                                             261
2244438 2244438 MS     school 2803630 5520   PICAYUNE SCHOOL DIST 280363000695 5520016 PICAYUNE MEMORIAL HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   181                                             181
2244477 2244477 MS     school 2803720 5530   POPLARVILLE SEPARATE SCHOOL DIST 280372000708 5530008 POPLARVILLE JR SR HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   136                                             136
2244510 2244510 MS     school 2803570 5600   PERRY CO SCHOOL DIST 280357001071 5600014 PERRY CENTRAL HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   70                                             70
2244525 2244525 MS     school 2803870 5620   RICHTON SCHOOL DIST 280387000744 5620004 RICHTON HIGH SCHOOL   Regular School No High 07 12 2021   grade_11                                                   38                                             38
2244554 2244554 MS     school 2803240 5711   NORTH PIKE SCHOOL DIST 280324000636 5711016 NORTH PIKE SENIOR HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   174                                             174
2244586 2244586 MS     school 2804080 5712   SOUTH PIKE SCHOOL DIST 280408000773 5712028 SOUTH PIKE SENIOR HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   125                                             125
2244618 2244618 MS     school 2802880 5720   MCCOMB SCHOOL DISTRICT 280288000556 5720012 MCCOMB HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   139                                             139
2244636 2244636 MS     school 2803660 5800   PONTOTOC CO SCHOOL DIST 280366000701 5800004 North Pontotoc High School   Regular School No High 09 12 2021   grade_11                                                   153                                             153
2244660 2244660 MS     school 2803660 5800   PONTOTOC CO SCHOOL DIST 280366000703 5800008 South Pontotoc High School   Regular School No High 09 12 2021   grade_11                                                   *                                              
2244684 2244684 MS     school 2803690 5820   PONTOTOC CITY SCHOOLS 280369000706 5820012 PONTOTOC HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   157                                             157
2244713 2244713 MS     school 2803750 5900   PRENTISS CO SCHOOL DIST 280375000717 5900020 JUMPERTOWN HIGH SCHOOL   Regular School No Other PK 12 2021   grade_11                                                   22                                             22
2244730 2244730 MS     school 2803750 5900   PRENTISS CO SCHOOL DIST 280375000719 5900028 NEW SITE HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   48                                             48
2244746 2244746 MS     school 2803750 5900   PRENTISS CO SCHOOL DIST 280375000721 5900032 THRASHER HIGH SCHOOL   Regular School No Other PK 12 2021   grade_11                                                   37                                             37
2244762 2244762 MS     school 2803750 5900   PRENTISS CO SCHOOL DIST 280375000722 5900036 WHEELER HIGH SCHOOL   Regular School No Other KG 12 2021   grade_11                                                   26                                             26
2244775 2244775 MS     school 2800540 5920   BALDWYN SCHOOL DISTRICT 280054000042 5920008 BALDWYN HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   49                                             49
2244794 2244794 MS     school 2800820 5921   BOONEVILLE SCHOOL DIST 280082001024 5921012 BOONEVILLE HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   *                                              
2244808 2244808 MS     school 2803810 6000   QUITMAN CO SCHOOL DIST 280381000730 6000020 M. S. PALMER HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   63                                             63
2244832 2244832 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383001074 6100008 BRANDON HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   379                                             379
2244866 2244866 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383001075 6100022 FLORENCE HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   171                                             171
2244897 2244897 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383000739 6100028 MCLAURIN ATTENDANCE CENTER   Regular School No High 07 12 2021   grade_11                                                   85                                             85
2244903 2244903 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383001076 6100032 NORTHWEST RANKIN HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   420                                             420
2244948 2244948 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383000740 6100044 PELAHATCHIE ATTENDANCE CENTER   Regular School No High 07 12 2021   grade_11                                                   68                                             68
2244976 2244976 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383001079 6100050 PISGAH HIGH SCHOOL   Regular School No High 07 12 2021   grade_11                                                   65                                             65
2244983 2244983 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383000742 6100052 PUCKETT ATTENDANCE CENTER   Regular School No High 07 12 2021   grade_11                                                   *                                              
2245001 2245001 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383000743 6100056 RICHLAND HIGH SCHOOL   Regular School No High 07 12 2021   grade_11                                                   124                                             124
2245029 2245029 MS     school 2803520 6120   PEARL PUBLIC SCHOOL DIST 280352000003 6120012 PEARL HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   243                                             243
2245063 2245063 MS     school 2803900 6200   SCOTT CO SCHOOL DIST 280390001184 6200012 MORTON HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   99                                             99
2245079 2245079 MS     school 2803900 6200   SCOTT CO SCHOOL DIST 280390000748 6200016 SCOTT CENTRAL ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_11                                                   67                                             67
2245095 2245095 MS     school 2803900 6200   SCOTT CO SCHOOL DIST 280390000749 6200020 SEBASTOPOL ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_11                                                   41                                             41
2245108 2245108 MS     school 2803900 6200   SCOTT CO SCHOOL DIST 280390001389 6200024 LAKE HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   68                                             68
2245122 2245122 MS     school 2801470 6220   FOREST MUNICIPAL SCHOOL DIST 280147000213 6220008 FOREST HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   99                                             99
2245144 2245144 MS     school 2803960 6312   SOUTH DELTA SCHOOL DISTRICT 280396000753 6312008 SOUTH DELTA HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   56                                             56
2245162 2245162 MS     school 2803990 6400   SIMPSON CO SCHOOL DIST 280399000755 6400008 MAGEE HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   94                                             94
2245179 2245179 MS     school 2803990 6400   SIMPSON CO SCHOOL DIST 280399001086 6400014 MENDENHALL HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   135                                             135
2245208 2245208 MS     school 2804020 6500   SMITH CO SCHOOL DIST 280402000758 6500004 MIZE ATTENDANCE CENTER   Regular School No Other PK 12 2021   grade_11                                                   59                                             59
2245216 2245216 MS     school 2804020 6500   SMITH CO SCHOOL DIST 280402000759 6500008 RALEIGH HIGH SCHOOL   Regular School No High 07 12 2021   grade_11                                                   85                                             85
2245242 2245242 MS     school 2804020 6500   SMITH CO SCHOOL DIST 280402000762 6500012 TAYLORSVILLE ATTENDANCE CENTER   Regular School No Other PK 12 2021   grade_11                                                   49                                             49
2245265 2245265 MS     school 2804170 6600   STONE CO SCHOOL DIST 280417000790 6600012 STONE HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   156                                             156
2245334 2245334 MS     school 2800187 6711   SUNFLOWER CO CONSOLIDATE SCH DIST 280018701425 6711026 GENTRY HIGH SCHOOL   Regular School No High 10 12 2021   grade_11                                                   161                                             161
2245349 2245349 MS     school 2800187 6711   SUNFLOWER CO CONSOLIDATE SCH DIST 280018701422 6711032 THOMAS E. EDWARDS, SR. HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   64                                             64
2245363 2245363 MS     school 2801410 6811   EAST TALLAHATCHIE CONSOL SCH DIST 280141000207 6811008 CHARLESTON HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   64                                             64
2245386 2245386 MS     school 2804650 6812   WEST TALLAHATCHIE SCHOOL DISTRICT 280465000873 6812036 WEST TALLAHATCHIE HIGH SCHOOL   Regular School No High 07 12 2021   grade_11                                                   41                                             41

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