Data source: Big Local News · About: Big Local

538 rows where grade = "secondary_spec_ed" and state = "MS" sorted by rowid descending

View and edit SQL

year

grade

  • secondary_spec_ed · 438
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
2244154 MS     school 2800450 4821   AMORY SCHOOL DIST 280045000028 4821004 EAST AMORY SCHOOL   Regular School No Elementary 03 05 2021   secondary_spec_ed                                                   *                                              
2244141 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036000009 4820008 ABERDEEN HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   *                                              
2244129 MS     school 2802940 4800   MONROE CO SCHOOL DIST 280294000582 4800020 SMITHVILLE HIGH SCHOOL   Regular School No Other PK 12 2021   secondary_spec_ed                                                   *                                              
2244114 MS     school 2802940 4800   MONROE CO SCHOOL DIST 280294000581 4800016 HATLEY HIGH SCHOOL   Regular School No Other PK 12 2021   secondary_spec_ed                                                   *                                              
2244098 MS     school 2802940 4800   MONROE CO SCHOOL DIST 280294000580 4800012 HAMILTON HIGH SCHOOL   Regular School No Other PK 12 2021   secondary_spec_ed                                                   *                                              
2244069 MS     school 2801950 4720   HOLLY SPRINGS SCHOOL DIST 280195000335 4720004 HOLLY SPRINGS HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   *                                              
2244063 MS     school 2802850 4700   MARSHALL CO SCHOOL DIST 280285000553 4700024 H. W. BYERS HIGH SCHOOL (5-12)   Regular School No High 05 12 2021   secondary_spec_ed                                                   *                                              
2244039 MS     school 2802850 4700   MARSHALL CO SCHOOL DIST 280285000551 4700016 POTTS CAMP HIGH SCHOOL (4-12)   Regular School No Other 04 12 2021   secondary_spec_ed                                                   *                                              
2244027 MS     school 2802850 4700   MARSHALL CO SCHOOL DIST 280285001291 4700013 BYHALIA MIDDLE SCHOOL (5-8)   Regular School No Middle 05 08 2021   secondary_spec_ed                                                   *                                              
2244005 MS     school 2802850 4700   MARSHALL CO SCHOOL DIST 280285000548 4700004 BYHALIA HIGH SCHOOL (9-12)   Regular School No High 09 12 2021   secondary_spec_ed                                                   *                                              
2243973 MS     school 2802820 4600   MARION CO SCHOOL DIST 280282001247 4600014 WEST MARION HIGH SCHOOL   Regular School No High 07 12 2021   secondary_spec_ed                                                   11                                             11
2243961 MS     school 2802820 4600   MARION CO SCHOOL DIST 280282000545 4600008 EAST MARION HIGH SCHOOL   Regular School No High 07 12 2021   secondary_spec_ed                                                   *                                              
2243906 MS     school 2800900 4520   CANTON PUBLIC SCHOOL DIST 280090001465 4520009 CANTON PUBLIC 9TH GRADE SCHOOL   Regular School No Secondary 09 09 2021   secondary_spec_ed                                                   *                                              
2243903 MS     school 2800900 4520   CANTON PUBLIC SCHOOL DIST 280090000101 4520008 CANTON PUBLIC HIGH SCHOOL   Regular School No High 10 12 2021   secondary_spec_ed                                                   15                                             15
2243890 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279001381 4500066 GERMANTOWN HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   18                                             18
2243873 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279001257 4500046 RIDGELAND HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   *                                              
2243857 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279001220 4500036 MADISON CENTRAL HIGH SCHOOL   Regular School No High 10 12 2021   secondary_spec_ed                                                   *                                              
2243702 MS     school 2802730 4400   LOWNDES CO SCHOOL DIST 280273001128 4400018 NEW HOPE MIDDLE SCHOOL   Regular School No Middle 06 08 2021   secondary_spec_ed                                                   *                                              
2243696 MS     school 2802730 4400   LOWNDES CO SCHOOL DIST 280273001127 4400016 NEW HOPE HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   11                                             11
2243681 MS     school 2802730 4400   LOWNDES CO SCHOOL DIST 280273000531 4400012 WEST LOWNDES HIGH SCHOOL   Regular School No High 07 12 2021   secondary_spec_ed                                                   *                                              
2243667 MS     school 2802730 4400   LOWNDES CO SCHOOL DIST 280273001125 4400004 CALEDONIA HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   *                                              
2243641 MS     school 2800840 4320   BROOKHAVEN SCHOOL DIST 280084000092 4320012 BROOKHAVEN HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   *                                              
2243608 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000515 4300016 LOYD STAR SCHOOL   Regular School No Other PK 12 2021   secondary_spec_ed                                                   *                                              
2243562 MS     school 2800198 4211   GREENWOOD-LEFLORE CONSOLIDATED SD 280019801522 4211032 GREENWOOD MIDDLE SCHOOL   Regular School No Middle 07 08 2021   secondary_spec_ed                                                   13                                             13
2243524 MS     school 2800198 4211   GREENWOOD-LEFLORE CONSOLIDATED SD 280019801516 4211016 GREENWOOD HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   14                                             14
2243500 MS     school 2800198 4211   GREENWOOD-LEFLORE CONSOLIDATED SD 280019801512 4211004 AMANDA ELZY HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   *                                              
2243485 MS     school 2804320 4120   TUPELO PUBLIC SCHOOL DIST 280432000293 4120042 TUPELO MIDDLE SCHOOL   Regular School No Middle 07 08 2021   secondary_spec_ed                                                   *                                              
2243480 MS     school 2804320 4120   TUPELO PUBLIC SCHOOL DIST 280432000819 4120040 TUPELO HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   30                                             30
2243453 MS     school 2804320 4120   TUPELO PUBLIC SCHOOL DIST 280432001003 4120023 MILAM ELEMENTARY SCHOOL   Regular School No Middle 06 06 2021   secondary_spec_ed                                                   *                                              
2243413 MS     school 2803090 4111   NETTLETON SCHOOL DIST 280309000613 4111004 NETTLETON HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   *                                              
2243395 MS     school 2802550 4100   LEE COUNTY SCHOOL DISTRICT 280255000497 4100028 SHANNON HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   13                                             13
2243389 MS     school 2802550 4100   LEE COUNTY SCHOOL DISTRICT 280255001325 4100027 SHANNON MIDDLE SCHOOL   Regular School No Middle 06 08 2021   secondary_spec_ed                                                   *                                              
2243379 MS     school 2802550 4100   LEE COUNTY SCHOOL DISTRICT 280255000496 4100024 SALTILLO HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   14                                             14
2243363 MS     school 2802550 4100   LEE COUNTY SCHOOL DISTRICT 280255000495 4100016 PLANTERSVILLE MIDDLE SCHOOL   Regular School No Middle 05 08 2021   secondary_spec_ed                                                   *                                              
2243348 MS     school 2802550 4100   LEE COUNTY SCHOOL DISTRICT 280255000494 4100008 MOOREVILLE HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   *                                              
2243342 MS     school 2802550 4100   LEE COUNTY SCHOOL DISTRICT 280255001276 4100007 MOOREVILLE MIDDLE SCHOOL   Regular School No Middle 06 08 2021   secondary_spec_ed                                                   *                                              
2243315 MS     school 2802520 4000   LEAKE CO SCHOOL DIST 280252001119 4000006 LEAKE CENTRAL JUNIOR HIGH   Regular School No Middle 06 08 2021   secondary_spec_ed                                                   *                                              
2243309 MS     school 2802520 4000   LEAKE CO SCHOOL DIST 280252000487 4000004 LEAKE CENTRAL HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   21                                             21
2243274 MS     school 2802490 3900   LAWRENCE CO SCHOOL DIST 280249000482 3900012 LAWRENCE COUNTY HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   *                                              
2243261 MS     school 2802490 3900   LAWRENCE CO SCHOOL DIST 280249000480 3900004 ROD PAIGE MIDDLE SCHOOL   Regular School No Middle 05 08 2021   secondary_spec_ed                                                   *                                              
2243204 MS     school 2802910 3820   MERIDIAN PUBLIC SCHOOL DIST 280291000567 3820036 MERIDIAN HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   17                                             17
2243180 MS     school 2802430 3800   LAUDERDALE CO SCHOOL DIST 280243001344 3800020 WEST LAUDERDALE HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   *                                              
2243165 MS     school 2802430 3800   LAUDERDALE CO SCHOOL DIST 280243000471 3800016 WEST LAUDERDALE MIDDLE SCHOOL   Regular School No Middle 05 08 2021   secondary_spec_ed                                                   *                                              
2243158 MS     school 2802430 3800   LAUDERDALE CO SCHOOL DIST 280243001174 3800014 SOUTHEAST LAUDERDALE MIDDLE SCHOOL   Regular School No Middle 05 08 2021   secondary_spec_ed                                                   *                                              
2243151 MS     school 2802430 3800   LAUDERDALE CO SCHOOL DIST 280243000470 3800012 SOUTHEAST LAUDERDALE HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   *                                              
2243136 MS     school 2802430 3800   LAUDERDALE CO SCHOOL DIST 280243000568 3800010 NORTHEAST LAUDERDALE MIDDLE SCHOOL   Regular School No Middle 05 08 2021   secondary_spec_ed                                                   *                                              
2243129 MS     school 2802430 3800   LAUDERDALE CO SCHOOL DIST 280243000469 3800008 NORTHEAST LAUDERDALE HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   19                                             19
2243115 MS     school 2802430 3800   LAUDERDALE CO SCHOOL DIST 280243001348 3800005 CLARKDALE HIGH SCHOOL   Regular School No High 07 12 2021   secondary_spec_ed                                                   *                                              
2243073 MS     school 2802400 3700   LAMAR COUNTY SCHOOL DISTRICT 280240001253 3700021 OAK GROVE MIDDLE SCHOOL   Regular School No Middle 06 08 2021   secondary_spec_ed                                                   *                                              
2243057 MS     school 2802400 3700   LAMAR COUNTY SCHOOL DISTRICT 280240001173 3700018 SUMRALL HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   *                                              
2243051 MS     school 2802400 3700   LAMAR COUNTY SCHOOL DISTRICT 280240001316 3700017 SUMRALL MIDDLE SCHOOL   Regular School No Middle 06 08 2021   secondary_spec_ed                                                   *                                              
2243038 MS     school 2802400 3700   LAMAR COUNTY SCHOOL DISTRICT 280240001172 3700014 PURVIS HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   *                                              
2243028 MS     school 2802400 3700   LAMAR COUNTY SCHOOL DISTRICT 280240001171 3700010 OAK GROVE HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   29                                             29
2242990 MS     school 2803450 3620   OXFORD SCHOOL DISTRICT 280345000664 3620016 OXFORD MIDDLE SCHOOL   Regular School No Middle 07 08 2021   secondary_spec_ed                                                   *                                              
2242985 MS     school 2803450 3620   OXFORD SCHOOL DISTRICT 280345000663 3620012 OXFORD HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   20                                             20
2242957 MS     school 2802370 3600   LAFAYETTE CO SCHOOL DIST 280237000967 3600012 LAFAYETTE MIDDLE SCHOOL   Regular School No Middle 07 08 2021   secondary_spec_ed                                                   *                                              
2242953 MS     school 2802370 3600   LAFAYETTE CO SCHOOL DIST 280237000463 3600008 LAFAYETTE HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   *                                              
2242940 MS     school 2802310 3500   KEMPER CO SCHOOL DIST 280231001116 3500016 KEMPER COUNTY HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   *                                              
2242918 MS     school 2801192 3475   ELLISVILLE STATE SCHOOL ADM 280119201198 3475004 ELLISVILLE STATE SCHOOL   Regular School No Ungraded UG UG 2021   secondary_spec_ed                                                   *                                              
2242916 MS     school 2802460 3420   LAUREL SCHOOL DISTRICT 280246000479 3420040 LAUREL HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   *                                              
2242882 MS     school 2802280 3400   JONES CO SCHOOL DIST 280228000451 3400052 WEST JONES HIGH SCHOOL   Regular School No High 07 12 2021   secondary_spec_ed                                                   29                                             29
2242864 MS     school 2802280 3400   JONES CO SCHOOL DIST 280228000450 3400036 SOUTH JONES HIGH SCHOOL   Regular School No High 07 12 2021   secondary_spec_ed                                                   14                                             14
2242832 MS     school 2802280 3400   JONES CO SCHOOL DIST 280228000443 3400024 NORTHEAST JONES HIGH SCHOOL   Regular School No High 07 12 2021   secondary_spec_ed                                                   18                                             18
2242778 MS     school 2802250 3300   JEFFERSON DAVIS CO SCHOOL DIST 280225000429 3300008 JDC HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   *                                              
2242755 MS     school 2802220 3200   JEFFERSON CO SCHOOL DIST 280222000427 3200008 JEFFERSON CO HIGH   Regular School No High 09 12 2021   secondary_spec_ed                                                   *                                              
2242727 MS     school 2804590 3112   WEST JASPER CONSOLIDATED SCHOOLS 280459000899 3112010 BAY SPRINGS MIDDLE SCH   Regular School No Middle 06 08 2021   secondary_spec_ed                                                   *                                              
2242721 MS     school 2804590 3112   WEST JASPER CONSOLIDATED SCHOOLS 280459000857 3112008 BAY SPRINGS HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   *                                              
2242694 MS     school 2801380 3111   EAST JASPER CONSOLIDATED SCH DIST 280138000204 3111004 HEIDELBERG HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   *                                              
2242688 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348001161 3022062 EXCEPTIONAL SCHOOL   Regular School No Ungraded UG UG 2021   secondary_spec_ed                                                   18                                             18
2242676 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348000678 3022052 PASCAGOULA HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   16                                             16
2242651 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348000935 3022042 GAUTIER HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   12                                             12
2242578 MS     school 2803360 3021   OCEAN SPRINGS SCHOOL DIST 280336000934 3021022 OCEAN SPRINGS MIDDLE SCHOOL   Regular School No Middle 07 08 2021   secondary_spec_ed                                                   16                                             16
2242574 MS     school 2803360 3021   OCEAN SPRINGS SCHOOL DIST 280336000650 3021016 OCEAN SPRINGS HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   22                                             22
2242548 MS     school 2803000 3020   MOSS POINT SEPARATE SCHOOL DIST 280300000592 3020028 MAGNOLIA MIDDLE SCHOOL   Regular School No Middle 06 08 2021   secondary_spec_ed                                                   *                                              
2242532 MS     school 2803000 3020   MOSS POINT SEPARATE SCHOOL DIST 280300000587 3020004 MOSS POINT HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   12                                             12
2242518 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216000963 3000024 ST. MARTIN MIDDLE SCHOOL   Regular School No Middle 06 08 2021   secondary_spec_ed                                                   *                                              
2242505 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216001050 3000020 VANCLEAVE HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   *                                              
2242499 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216001049 3000018 VANCLEAVE MIDDLE SCHOOL   Regular School No Middle 06 08 2021   secondary_spec_ed                                                   *                                              
2242475 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216001046 3000011 ST MARTIN HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   26                                             26
2242460 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216001045 3000006 EAST CENTRAL HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   *                                              
2242454 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216000364 3000004 EAST CENTRAL MIDDLE SCHOOL   Regular School No Middle 06 08 2021   secondary_spec_ed                                                   *                                              
2242443 MS     school 2802100 2900   ITAWAMBA CO SCHOOL DIST 280210000949 2900030 ITAWAMBA AGRICULTURAL HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   *                                              
2242422 MS     school 2802100 2900   ITAWAMBA CO SCHOOL DIST 280210000361 2900024 MANTACHIE ATTENDANCE CENTER   Regular School No Other KG 12 2021   secondary_spec_ed                                                   *                                              
2242377 MS     school 2802040 2700   HUMPHREYS CO SCHOOL DIST 280204001041 2700010 HUMPHREYS COUNTY HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   15                                             15
2242310 MS     school 2801189 2560   MS SCH FOR THE BLIND AND DEAF 280118901194 2560004 MS SCHOOL FOR THE BLIND   Special Education School No Other 01 12 2021   secondary_spec_ed                                                   *                                              
2242297 MS     school 2801189 2560   MS SCH FOR THE BLIND AND DEAF 280118901504 2560002 MS SCHOOL FOR THE DEAF   Special Education School No Other PK 12 2021   secondary_spec_ed                                                   *                                              
2242266 MS     school 2801090 2521   CLINTON PUBLIC SCHOOL DIST 280109001029 2521018 SUMNER HILL JR HI SCHOOL   Regular School No Secondary 09 09 2021   secondary_spec_ed                                                   *                                              
2242248 MS     school 2801090 2521   CLINTON PUBLIC SCHOOL DIST 280109000132 2521008 CLINTON JR HI SCHOOL   Regular School No Middle 07 08 2021   secondary_spec_ed                                                   *                                              
2242243 MS     school 2801090 2521   CLINTON PUBLIC SCHOOL DIST 280109000131 2521004 CLINTON HIGH SCHOOL   Regular School No High 10 12 2021   secondary_spec_ed                                                   11                                             11
2242238 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000423 2520089 WINGFIELD HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   *                                              
2242143 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000409 2520068 PROVINE HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   18                                             18
2242117 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000403 2520060 MURRAH HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   22                                             22
2242051 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000396 2520048 LANIER HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   11                                             11
2241994 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000390 2520039 JIM HILL HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   *                                              
2241971 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000384 2520031 FOREST HILL HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   28                                             28
2241935 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000377 2520018 CALLAWAY HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   15                                             15
2241858 MS     school 2801860 2500   HINDS CO SCHOOL DIST 280186000328 2500040 RAYMOND HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   13                                             13
2241852 MS     school 2801860 2500   HINDS CO SCHOOL DIST 280186000902 2500030 TERRY HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   *                                              
2241800 MS     school 2803510 2423   PASS CHRISTIAN PUBLIC SCHOOL DIST 280351000684 2423012 PASS CHRISTIAN HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   *                                              
2241770 MS     school 2802670 2422   LONG BEACH SCHOOL DIST 280267000520 2422016 LONG BEACH SENIOR HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   *                                              

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