enrollments

Data source: Big Local News · About: Big Local

236 rows where grade = "grade_12", state = "MS" and year = 2021

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 136 ✖

grade ✖

  • grade_12 · 136 ✖
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
2243056 2243056 MS     school 2802400 3700   LAMAR COUNTY SCHOOL DISTRICT 280240001173 3700018 SUMRALL HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   *                                              
2243099 2243099 MS     school 2802400 3700   LAMAR COUNTY SCHOOL DISTRICT 280240001484 3700026 LUMBERTON HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   34                                             34
2243114 2243114 MS     school 2802430 3800   LAUDERDALE CO SCHOOL DIST 280243001348 3800005 CLARKDALE HIGH SCHOOL   Regular School No High 07 12 2021   grade_12                                                   71                                             71
2243128 2243128 MS     school 2802430 3800   LAUDERDALE CO SCHOOL DIST 280243000469 3800008 NORTHEAST LAUDERDALE HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   129                                             129
2243150 2243150 MS     school 2802430 3800   LAUDERDALE CO SCHOOL DIST 280243000470 3800012 SOUTHEAST LAUDERDALE HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   96                                             96
2243179 2243179 MS     school 2802430 3800   LAUDERDALE CO SCHOOL DIST 280243001344 3800020 WEST LAUDERDALE HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   *                                              
2243203 2243203 MS     school 2802910 3820   MERIDIAN PUBLIC SCHOOL DIST 280291000567 3820036 MERIDIAN HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   263                                             263
2243273 2243273 MS     school 2802490 3900   LAWRENCE CO SCHOOL DIST 280249000482 3900012 LAWRENCE COUNTY HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   *                                              
2243308 2243308 MS     school 2802520 4000   LEAKE CO SCHOOL DIST 280252000487 4000004 LEAKE CENTRAL HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   105                                             105
2243332 2243332 MS     school 2802520 4000   LEAKE CO SCHOOL DIST 280252000490 4000016 LEAKE COUNTY HIGH SCHOOL   Regular School No High 07 12 2021   grade_12                                                   38                                             38
2243347 2243347 MS     school 2802550 4100   LEE COUNTY SCHOOL DISTRICT 280255000494 4100008 MOOREVILLE HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   *                                              
2243378 2243378 MS     school 2802550 4100   LEE COUNTY SCHOOL DISTRICT 280255000496 4100024 SALTILLO HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   194                                             194
2243394 2243394 MS     school 2802550 4100   LEE COUNTY SCHOOL DISTRICT 280255000497 4100028 SHANNON HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   112                                             112
2243412 2243412 MS     school 2803090 4111   NETTLETON SCHOOL DIST 280309000613 4111004 NETTLETON HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   *                                              
2243479 2243479 MS     school 2804320 4120   TUPELO PUBLIC SCHOOL DIST 280432000819 4120040 TUPELO HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   391                                             391
2243499 2243499 MS     school 2800198 4211   GREENWOOD-LEFLORE CONSOLIDATED SD 280019801512 4211004 AMANDA ELZY HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   92                                             92
2243523 2243523 MS     school 2800198 4211   GREENWOOD-LEFLORE CONSOLIDATED SD 280019801516 4211016 GREENWOOD HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   144                                             144
2243537 2243537 MS     school 2800198 4211   GREENWOOD-LEFLORE CONSOLIDATED SD 280019801518 4211020 LEFLORE COUNTY HIGH SCHOOL   Regular School No High 07 12 2021   grade_12                                                   48                                             48
2243578 2243578 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000512 4300004 BOGUE CHITTO SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   57                                             57
2243592 2243592 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000513 4300008 ENTERPRISE SCHOOL   Regular School No Other KG 12 2021   grade_12                                                   42                                             42
2243607 2243607 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000515 4300016 LOYD STAR SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   51                                             51
2243625 2243625 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000516 4300020 WEST LINCOLN SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   61                                             61
2243628 2243628 MS     school 2800031 4306   MS SCHOOL FOR THE ARTS 280003101574 4306004 MS SCHOOL FOR THE ARTS   Regular School No High 11 12 2021   grade_12                                                   47                                             47
2243640 2243640 MS     school 2800840 4320   BROOKHAVEN SCHOOL DIST 280084000092 4320012 BROOKHAVEN HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   138                                             138
2243666 2243666 MS     school 2802730 4400   LOWNDES CO SCHOOL DIST 280273001125 4400004 CALEDONIA HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   *                                              
2243680 2243680 MS     school 2802730 4400   LOWNDES CO SCHOOL DIST 280273000531 4400012 WEST LOWNDES HIGH SCHOOL   Regular School No High 07 12 2021   grade_12                                                   39                                             39
2243695 2243695 MS     school 2802730 4400   LOWNDES CO SCHOOL DIST 280273001127 4400016 NEW HOPE HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   175                                             175
2243714 2243714 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_12                                                   124                                             124
2243729 2243729 MS     school 2801200 4420   COLUMBUS MUNICIPAL SCHOOL DIST 280120000154 4420016 COLUMBUS HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   196                                             196
2243805 2243805 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279000541 4500016 VELMA JACKSON HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   65                                             65
2243856 2243856 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279001220 4500036 MADISON CENTRAL HIGH SCHOOL   Regular School No High 10 12 2021   grade_12                                                   417                                             417
2243872 2243872 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279001257 4500046 RIDGELAND HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   *                                              
2243889 2243889 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279001381 4500066 GERMANTOWN HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   288                                             288
2243902 2243902 MS     school 2800900 4520   CANTON PUBLIC SCHOOL DIST 280090000101 4520008 CANTON PUBLIC HIGH SCHOOL   Regular School No High 10 12 2021   grade_12                                                   152                                             152
2243960 2243960 MS     school 2802820 4600   MARION CO SCHOOL DIST 280282000545 4600008 EAST MARION HIGH SCHOOL   Regular School No High 07 12 2021   grade_12                                                   *                                              
2243972 2243972 MS     school 2802820 4600   MARION CO SCHOOL DIST 280282001247 4600014 WEST MARION HIGH SCHOOL   Regular School No High 07 12 2021   grade_12                                                   94                                             94
2243990 2243990 MS     school 2801170 4620   COLUMBIA SCHOOL DISTRICT 280117000149 4620008 COLUMBIA HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   102                                             102
2244004 2244004 MS     school 2802850 4700   MARSHALL CO SCHOOL DIST 280285000548 4700004 BYHALIA HIGH SCHOOL (9-12)   Regular School No High 09 12 2021   grade_12                                                   *                                              
2244038 2244038 MS     school 2802850 4700   MARSHALL CO SCHOOL DIST 280285000551 4700016 POTTS CAMP HIGH SCHOOL (4-12)   Regular School No Other 04 12 2021   grade_12                                                   39                                             39
2244062 2244062 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_12                                                   30                                             30
2244068 2244068 MS     school 2801950 4720   HOLLY SPRINGS SCHOOL DIST 280195000335 4720004 HOLLY SPRINGS HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   74                                             74
2244097 2244097 MS     school 2802940 4800   MONROE CO SCHOOL DIST 280294000580 4800012 HAMILTON HIGH SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   41                                             41
2244113 2244113 MS     school 2802940 4800   MONROE CO SCHOOL DIST 280294000581 4800016 HATLEY HIGH SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   57                                             57
2244128 2244128 MS     school 2802940 4800   MONROE CO SCHOOL DIST 280294000582 4800020 SMITHVILLE HIGH SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   *                                              
2244140 2244140 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036000009 4820008 ABERDEEN HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   *                                              
2244159 2244159 MS     school 2800450 4821   AMORY SCHOOL DIST 280045000029 4821008 AMORY HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   95                                             95
2244189 2244189 MS     school 2800196 4911   WINONA-MONTGOMERY CONSOLIDATED SD 280019601485 4911006 WINONA SECONDARY SCHOOL   Regular School No High 07 12 2021   grade_12                                                   64                                             64
2244211 2244211 MS     school 2803060 5000   NESHOBA COUNTY SCHOOL DISTRICT 280306000612 5000008 NESHOBA CENTRAL HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   232                                             232
2244230 2244230 MS     school 2803600 5020   PHILADELPHIA PUBLIC SCHOOL DIST 280360000692 5020008 PHILADELPHIA HIGH SCHOOL   Regular School No High 07 12 2021   grade_12                                                   64                                             64
2244248 2244248 MS     school 2803150 5100   NEWTON COUNTY SCHOOL DISTRICT 280315001135 5100012 NEWTON COUNTY HIGH SCHOOL   Regular School No High 06 12 2021   grade_12                                                   114                                             114
2244266 2244266 MS     school 2803180 5130   NEWTON MUNICIPAL SCHOOL DISTRICT 280318000626 5130008 NEWTON HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   58                                             58
2244278 2244278 MS     school 2804380 5131   UNION PUBLIC SCHOOL DIST 280438000825 5131004 UNION HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   73                                             73
2244306 2244306 MS     school 2803300 5200   NOXUBEE COUNTY SCHOOL DISTRICT 280330000642 5200012 NOXUBEE COUNTY HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   94                                             94
2244328 2244328 MS     school 2800189 5321   STARKVILLE- OKTIBBEHA CONS SD 280018901451 5321016 STARKVILLE HIGH SCHOOL   Regular School No High 10 12 2021   grade_12                                                   282                                             282
2244363 2244363 MS     school 2803210 5411   NORTH PANOLA SCHOOLS 280321000630 5411016 NORTH PANOLA HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   72                                             72
2244394 2244394 MS     school 2804050 5412   SOUTH PANOLA SCHOOL DISTRICT 280405000766 5412016 SOUTH PANOLA HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   237                                             237
2244414 2244414 MS     school 2803540 5500   PEARL RIVER CO SCHOOL DIST 280354001070 5500012 PEARL RIVER CENTRAL HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   *                                              
2244439 2244439 MS     school 2803630 5520   PICAYUNE SCHOOL DIST 280363000695 5520016 PICAYUNE MEMORIAL HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   178                                             178
2244478 2244478 MS     school 2803720 5530   POPLARVILLE SEPARATE SCHOOL DIST 280372000708 5530008 POPLARVILLE JR SR HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   *                                              
2244511 2244511 MS     school 2803570 5600   PERRY CO SCHOOL DIST 280357001071 5600014 PERRY CENTRAL HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   *                                              
2244526 2244526 MS     school 2803870 5620   RICHTON SCHOOL DIST 280387000744 5620004 RICHTON HIGH SCHOOL   Regular School No High 07 12 2021   grade_12                                                   39                                             39
2244555 2244555 MS     school 2803240 5711   NORTH PIKE SCHOOL DIST 280324000636 5711016 NORTH PIKE SENIOR HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   *                                              
2244587 2244587 MS     school 2804080 5712   SOUTH PIKE SCHOOL DIST 280408000773 5712028 SOUTH PIKE SENIOR HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   102                                             102
2244619 2244619 MS     school 2802880 5720   MCCOMB SCHOOL DISTRICT 280288000556 5720012 MCCOMB HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   124                                             124
2244637 2244637 MS     school 2803660 5800   PONTOTOC CO SCHOOL DIST 280366000701 5800004 North Pontotoc High School   Regular School No High 09 12 2021   grade_12                                                   127                                             127
2244661 2244661 MS     school 2803660 5800   PONTOTOC CO SCHOOL DIST 280366000703 5800008 South Pontotoc High School   Regular School No High 09 12 2021   grade_12                                                   116                                             116
2244685 2244685 MS     school 2803690 5820   PONTOTOC CITY SCHOOLS 280369000706 5820012 PONTOTOC HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   119                                             119
2244714 2244714 MS     school 2803750 5900   PRENTISS CO SCHOOL DIST 280375000717 5900020 JUMPERTOWN HIGH SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   16                                             16
2244731 2244731 MS     school 2803750 5900   PRENTISS CO SCHOOL DIST 280375000719 5900028 NEW SITE HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   *                                              
2244747 2244747 MS     school 2803750 5900   PRENTISS CO SCHOOL DIST 280375000721 5900032 THRASHER HIGH SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   26                                             26
2244763 2244763 MS     school 2803750 5900   PRENTISS CO SCHOOL DIST 280375000722 5900036 WHEELER HIGH SCHOOL   Regular School No Other KG 12 2021   grade_12                                                   29                                             29
2244776 2244776 MS     school 2800540 5920   BALDWYN SCHOOL DISTRICT 280054000042 5920008 BALDWYN HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   *                                              
2244795 2244795 MS     school 2800820 5921   BOONEVILLE SCHOOL DIST 280082001024 5921012 BOONEVILLE HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   93                                             93
2244809 2244809 MS     school 2803810 6000   QUITMAN CO SCHOOL DIST 280381000730 6000020 M. S. PALMER HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   64                                             64
2244833 2244833 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383001074 6100008 BRANDON HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   400                                             400
2244867 2244867 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383001075 6100022 FLORENCE HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   *                                              
2244898 2244898 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383000739 6100028 MCLAURIN ATTENDANCE CENTER   Regular School No High 07 12 2021   grade_12                                                   *                                              
2244904 2244904 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383001076 6100032 NORTHWEST RANKIN HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   372                                             372
2244949 2244949 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383000740 6100044 PELAHATCHIE ATTENDANCE CENTER   Regular School No High 07 12 2021   grade_12                                                   *                                              
2244977 2244977 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383001079 6100050 PISGAH HIGH SCHOOL   Regular School No High 07 12 2021   grade_12                                                   61                                             61
2244984 2244984 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383000742 6100052 PUCKETT ATTENDANCE CENTER   Regular School No High 07 12 2021   grade_12                                                   56                                             56
2245002 2245002 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383000743 6100056 RICHLAND HIGH SCHOOL   Regular School No High 07 12 2021   grade_12                                                   118                                             118
2245030 2245030 MS     school 2803520 6120   PEARL PUBLIC SCHOOL DIST 280352000003 6120012 PEARL HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   278                                             278
2245064 2245064 MS     school 2803900 6200   SCOTT CO SCHOOL DIST 280390001184 6200012 MORTON HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   83                                             83
2245080 2245080 MS     school 2803900 6200   SCOTT CO SCHOOL DIST 280390000748 6200016 SCOTT CENTRAL ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_12                                                   43                                             43
2245096 2245096 MS     school 2803900 6200   SCOTT CO SCHOOL DIST 280390000749 6200020 SEBASTOPOL ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_12                                                   34                                             34
2245109 2245109 MS     school 2803900 6200   SCOTT CO SCHOOL DIST 280390001389 6200024 LAKE HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   42                                             42
2245123 2245123 MS     school 2801470 6220   FOREST MUNICIPAL SCHOOL DIST 280147000213 6220008 FOREST HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   *                                              
2245145 2245145 MS     school 2803960 6312   SOUTH DELTA SCHOOL DISTRICT 280396000753 6312008 SOUTH DELTA HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   *                                              
2245163 2245163 MS     school 2803990 6400   SIMPSON CO SCHOOL DIST 280399000755 6400008 MAGEE HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   *                                              
2245180 2245180 MS     school 2803990 6400   SIMPSON CO SCHOOL DIST 280399001086 6400014 MENDENHALL HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   132                                             132
2245209 2245209 MS     school 2804020 6500   SMITH CO SCHOOL DIST 280402000758 6500004 MIZE ATTENDANCE CENTER   Regular School No Other PK 12 2021   grade_12                                                   *                                              
2245217 2245217 MS     school 2804020 6500   SMITH CO SCHOOL DIST 280402000759 6500008 RALEIGH HIGH SCHOOL   Regular School No High 07 12 2021   grade_12                                                   74                                             74
2245243 2245243 MS     school 2804020 6500   SMITH CO SCHOOL DIST 280402000762 6500012 TAYLORSVILLE ATTENDANCE CENTER   Regular School No Other PK 12 2021   grade_12                                                   40                                             40
2245266 2245266 MS     school 2804170 6600   STONE CO SCHOOL DIST 280417000790 6600012 STONE HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   *                                              
2245335 2245335 MS     school 2800187 6711   SUNFLOWER CO CONSOLIDATE SCH DIST 280018701425 6711026 GENTRY HIGH SCHOOL   Regular School No High 10 12 2021   grade_12                                                   *                                              
2245350 2245350 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_12                                                   81                                             81
2245364 2245364 MS     school 2801410 6811   EAST TALLAHATCHIE CONSOL SCH DIST 280141000207 6811008 CHARLESTON HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   38                                             38
2245387 2245387 MS     school 2804650 6812   WEST TALLAHATCHIE SCHOOL DISTRICT 280465000873 6812036 WEST TALLAHATCHIE HIGH SCHOOL   Regular School No High 07 12 2021   grade_12                                                   42                                             42
2245412 2245412 MS     school 2804230 6900   TATE CO SCHOOL DIST 280423000800 6900012 INDEPENDENCE HIGH SCHOOL   Regular School No High 07 12 2021   grade_12                                                   66                                             66

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