Data source: Big Local News · About: Big Local

323 rows where grade = "grade_6", state = "MS" and year = 2021

View and edit SQL

year

  • 2021 · 223

grade

  • grade_6 · 223
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
2241914 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000372 2520010 BLACKBURN MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6                                                   214                                             214
2241927 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000375 2520014 BRINKLEY MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6                                                   153                                             153
2241946 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000380 2520023 CHASTAIN MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6                                                   184                                             184
2242068 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219001155 2520052 NORTHWEST MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6                                                   94                                             94
2242082 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219001365 2520055 KIRKSEY MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6                                                   85                                             85
2242127 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000405 2520062 PEEPLES MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6                                                   *                                              
2242132 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000407 2520065 POWELL MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6                                                   *                                              
2242216 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219001370 2520085 CARDOZO MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6                                                   229                                             229
2242221 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000421 2520086 WHITTEN MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6                                                   131                                             131
2242259 MS     school 2801090 2521   CLINTON PUBLIC SCHOOL DIST 280109001028 2521015 LOVETT ELEM SCHOOL   Regular School No Middle 06 06 2021   grade_6                                                   *                                              
2242269 MS     school 2800190 2525   MIDTOWN PUBLIC CHARTER SCHOOL 280019001448 2525004 MIDTOWN PUBLIC CHARTER SCHOOL   Regular School Yes Middle 05 08 2021   grade_6                                                   76                                             76
2242275 MS     school 2800192 2535   SMILOW PREP 280019201471 2535004 JOEL E. SMILOW PREP   Regular School Yes Middle 05 08 2021   grade_6                                                   169                                             169
2242291 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   grade_6                                                   *                                              
2242303 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   grade_6                                                   *                                              
2242327 MS     school 2800195 2611   HOLMES CONSOLIDATE SCHOOL DIST 280019501491 2611006 WILLIAMS-SULLIVAN MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6                                                   99                                             99
2242343 MS     school 2800195 2611   HOLMES CONSOLIDATE SCHOOL DIST 280019501528 2611011 S V MARSHALL MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6                                                   122                                             122
2242369 MS     school 2802040 2700   HUMPHREYS CO SCHOOL DIST 280204001039 2700006 O M MC NAIR MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_6                                                   120                                             120
2242386 MS     school 2802100 2900   ITAWAMBA CO SCHOOL DIST 280210000356 2900004 DORSEY ATTENDANCE CENTER   Regular School No Elementary KG 06 2021   grade_6                                                   30                                             30
2242394 MS     school 2802100 2900   ITAWAMBA CO SCHOOL DIST 280210000357 2900008 FAIRVIEW ATTENDANCE CENTER   Regular School No Elementary KG 06 2021   grade_6                                                   22                                             22
2242404 MS     school 2802100 2900   ITAWAMBA CO SCHOOL DIST 280210000358 2900012 ITAWAMBA ATTENDANCE CENTER   Regular School No Elementary KG 08 2021   grade_6                                                   122                                             122
2242415 MS     school 2802100 2900   ITAWAMBA CO SCHOOL DIST 280210000361 2900024 MANTACHIE ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_6                                                   82                                             82
2242430 MS     school 2802100 2900   ITAWAMBA CO SCHOOL DIST 280210000362 2900028 TREMONT ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_6                                                   20                                             20
2242451 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216000364 3000004 EAST CENTRAL MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6                                                   203                                             203
2242496 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216001049 3000018 VANCLEAVE MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6                                                   163                                             163
2242515 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216000963 3000024 ST. MARTIN MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6                                                   313                                             313
2242545 MS     school 2803000 3020   MOSS POINT SEPARATE SCHOOL DIST 280300000592 3020028 MAGNOLIA MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6                                                   129                                             129
2242561 MS     school 2803360 3021   OCEAN SPRINGS SCHOOL DIST 280336001392 3021006 OCEAN SPRINGS UPPER ELEMENTARY SCHO   Regular School No Middle 04 06 2021   grade_6                                                   454                                             454
2242680 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348000679 3022056 TRENT LOTT ACADEMY   Regular School No Middle 05 06 2021   grade_6                                                   280                                             280
2242684 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348000680 3022058 SINGING RIVER ACADEMY   Regular School No Middle 05 06 2021   grade_6                                                   217                                             217
2242704 MS     school 2801380 3111   EAST JASPER CONSOLIDATED SCH DIST 280138000205 3111008 WILLIAM J BERRY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_6                                                   62                                             62
2242724 MS     school 2804590 3112   WEST JASPER CONSOLIDATED SCHOOLS 280459000899 3112010 BAY SPRINGS MIDDLE SCH   Regular School No Middle 06 08 2021   grade_6                                                   76                                             76
2242735 MS     school 2804590 3112   WEST JASPER CONSOLIDATED SCHOOLS 280459000859 3112012 STRINGER ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_6                                                   34                                             34
2242758 MS     school 2802220 3200   JEFFERSON CO SCHOOL DIST 280222000209 3200010 JEFFERSON COUNTY UPPER ELEMENTARY   Regular School No Middle 05 06 2021   grade_6                                                   75                                             75
2242770 MS     school 2802250 3300   JEFFERSON DAVIS CO SCHOOL DIST 280225000430 3300004 CARVER ELEMENTARY SCHOOL   Regular School No Elementary KG 08 2021   grade_6                                                   42                                             42
2242787 MS     school 2802250 3300   JEFFERSON DAVIS CO SCHOOL DIST 280225000432 3300012 J E JOHNSON ELEMENTARY   Regular School No Elementary KG 08 2021   grade_6                                                   60                                             60
2242801 MS     school 2802280 3400   JONES CO SCHOOL DIST 280228000439 3400012 GLADE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_6                                                   43                                             43
2242812 MS     school 2802280 3400   JONES CO SCHOOL DIST 280228000441 3400016 MOSELLE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_6                                                   73                                             73
2242824 MS     school 2802280 3400   JONES CO SCHOOL DIST 280228000985 3400022 EAST JONES ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_6                                                   129                                             129
2242844 MS     school 2802280 3400   JONES CO SCHOOL DIST 280228001326 3400026 NORTH JONES ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_6                                                   96                                             96
2242856 MS     school 2802280 3400   JONES CO SCHOOL DIST 280228000986 3400034 SOUTH JONES ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_6                                                   135                                             135
2242874 MS     school 2802280 3400   JONES CO SCHOOL DIST 280228001237 3400050 WEST JONES ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_6                                                   147                                             147
2242892 MS     school 2802460 3420   LAUREL SCHOOL DISTRICT 280246001345 3420006 LAUREL MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6                                                   212                                             212
2242931 MS     school 2802310 3500   KEMPER CO SCHOOL DIST 280231001530 3500013 KEMPER COUNTY UPPER ELEMENTARY   Regular School No Middle 04 08 2021   grade_6                                                   70                                             70
2242963 MS     school 2802370 3600   LAFAYETTE CO SCHOOL DIST 280237001280 3600016 LAFAYETTE UPPER ELEMENTARY SCHOOL   Regular School No Elementary 03 06 2021   grade_6                                                   217                                             217
2242979 MS     school 2803450 3620   OXFORD SCHOOL DISTRICT 280345001407 3620011 OXFORD INTERMEDIATE SCHOOL   Regular School No Middle 05 06 2021   grade_6                                                   344                                             344
2243000 MS     school 2802400 3700   LAMAR COUNTY SCHOOL DISTRICT 280240000464 3700004 BAXTERVILLE SCHOOL   Regular School No Elementary PK 08 2021   grade_6                                                   24                                             24
2243048 MS     school 2802400 3700   LAMAR COUNTY SCHOOL DISTRICT 280240001316 3700017 SUMRALL MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6                                                   181                                             181
2243070 MS     school 2802400 3700   LAMAR COUNTY SCHOOL DISTRICT 280240001253 3700021 OAK GROVE MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6                                                   456                                             456
2243075 MS     school 2802400 3700   LAMAR COUNTY SCHOOL DISTRICT 280240001254 3700022 PURVIS MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6                                                   125                                             125
2243092 MS     school 2802400 3700   LAMAR COUNTY SCHOOL DISTRICT 280240001507 3700025 LUMBERTON MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6                                                   37                                             37
2243107 MS     school 2802430 3800   LAUDERDALE CO SCHOOL DIST 280243001362 3800002 CLARKDALE ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_6                                                   74                                             74
2243133 MS     school 2802430 3800   LAUDERDALE CO SCHOOL DIST 280243000568 3800010 NORTHEAST LAUDERDALE MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_6                                                   134                                             134
2243155 MS     school 2802430 3800   LAUDERDALE CO SCHOOL DIST 280243001174 3800014 SOUTHEAST LAUDERDALE MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_6                                                   90                                             90
2243162 MS     school 2802430 3800   LAUDERDALE CO SCHOOL DIST 280243000471 3800016 WEST LAUDERDALE MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_6                                                   123                                             123
2243183 MS     school 2802910 3820   MERIDIAN PUBLIC SCHOOL DIST 280291000559 3820004 GEORGE WASHINGTON CARVER MIDDLE   Regular School No Middle 06 08 2021   grade_6                                                   116                                             116
2243196 MS     school 2802910 3820   MERIDIAN PUBLIC SCHOOL DIST 280291000564 3820024 MAGNOLIA MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6                                                   *                                              
2243207 MS     school 2802910 3820   MERIDIAN PUBLIC SCHOOL DIST 280291000569 3820044 NORTHWEST JUNIOR HIGH SCHOOL   Regular School No Middle 06 08 2021   grade_6                                                   *                                              
2243258 MS     school 2802490 3900   LAWRENCE CO SCHOOL DIST 280249000480 3900004 ROD PAIGE MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_6                                                   76                                             76
2243282 MS     school 2802490 3900   LAWRENCE CO SCHOOL DIST 280249000483 3900016 NEW HEBRON ATTENDANCE CENTER   Regular School No Elementary KG 08 2021   grade_6                                                   30                                             30
2243292 MS     school 2802490 3900   LAWRENCE CO SCHOOL DIST 280249000485 3900024 TOPEKA TILTON ATTENDANCE CENTER   Regular School No Elementary KG 08 2021   grade_6                                                   41                                             41
2243312 MS     school 2802520 4000   LEAKE CO SCHOOL DIST 280252001119 4000006 LEAKE CENTRAL JUNIOR HIGH   Regular School No Middle 06 08 2021   grade_6                                                   159                                             159
2243325 MS     school 2802520 4000   LEAKE CO SCHOOL DIST 280252001120 4000014 LEAKE COUNTY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_6                                                   74                                             74
2243335 MS     school 2802550 4100   LEE COUNTY SCHOOL DISTRICT 280255000492 4100004 GUNTOWN MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6                                                   235                                             235
2243339 MS     school 2802550 4100   LEE COUNTY SCHOOL DISTRICT 280255001276 4100007 MOOREVILLE MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6                                                   124                                             124
2243360 MS     school 2802550 4100   LEE COUNTY SCHOOL DISTRICT 280255000495 4100016 PLANTERSVILLE MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_6                                                   80                                             80
2243386 MS     school 2802550 4100   LEE COUNTY SCHOOL DISTRICT 280255001325 4100027 SHANNON MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6                                                   *                                              
2243424 MS     school 2803090 4111   NETTLETON SCHOOL DIST 280309001160 4111010 NETTLETON INTERMEDIATE SCHOOL   Regular School No Middle 04 08 2021   grade_6                                                   106                                             106
2243452 MS     school 2804320 4120   TUPELO PUBLIC SCHOOL DIST 280432001003 4120023 MILAM ELEMENTARY SCHOOL   Regular School No Middle 06 06 2021   grade_6                                                   563                                             563
2243465 MS     school 2804320 4120   TUPELO PUBLIC SCHOOL DIST 280432000816 4120028 PIERCE STREET ELEMENTARY SCHOOL   Regular School No Elementary 03 06 2021   grade_6                                                   *                                              
2243494 MS     school 2800198 4211   GREENWOOD-LEFLORE CONSOLIDATED SD 280019801511 4211003 BANKSTON ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_6                                                   *                                              
2243503 MS     school 2800198 4211   GREENWOOD-LEFLORE CONSOLIDATED SD 280019801513 4211005 AMANDA ELZY JUNIOR HIGH SCHOOL   Regular School No Middle 06 08 2021   grade_6                                                   *                                              
2243513 MS     school 2800198 4211   GREENWOOD-LEFLORE CONSOLIDATED SD 280019801514 4211008 DAVIS ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_6                                                   44                                             44
2243546 MS     school 2800198 4211   GREENWOOD-LEFLORE CONSOLIDATED SD 280019801519 4211021 LEFLORE COUNTY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_6                                                   54                                             54
2243558 MS     school 2800198 4211   GREENWOOD-LEFLORE CONSOLIDATED SD 280019801521 4211024 THREADGILL ELEMENTARY SCHOOL   Regular School No Elementary 02 06 2021   grade_6                                                   59                                             59
2243564 MS     school 2800199 4225   LEFLORE LEGACY ACADEMY 280019901531 4225004 Leflore Legacy Academy   Regular School Yes Middle 06 06 2021   grade_6                                                   123                                             123
2243572 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000512 4300004 BOGUE CHITTO SCHOOL   Regular School No Other PK 12 2021   grade_6                                                   50                                             50
2243586 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000513 4300008 ENTERPRISE SCHOOL   Regular School No Other KG 12 2021   grade_6                                                   51                                             51
2243601 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000515 4300016 LOYD STAR SCHOOL   Regular School No Other PK 12 2021   grade_6                                                   61                                             61
2243619 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000516 4300020 WEST LINCOLN SCHOOL   Regular School No Other PK 12 2021   grade_6                                                   56                                             56
2243646 MS     school 2800840 4320   BROOKHAVEN SCHOOL DIST 280084000094 4320016 LIPSEY SCHOOL   Regular School No Middle 05 06 2021   grade_6                                                   223                                             223
2243670 MS     school 2802730 4400   LOWNDES CO SCHOOL DIST 280273001126 4400006 CALEDONIA MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6                                                   *                                              
2243699 MS     school 2802730 4400   LOWNDES CO SCHOOL DIST 280273001128 4400018 NEW HOPE MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6                                                   208                                             208
2243711 MS     school 2802730 4400   LOWNDES CO SCHOOL DIST 280273001177 4400028 WEST LOWNDES ELEMENTARY   Regular School No Elementary PK 06 2021   grade_6                                                   31                                             31
2243731 MS     school 2801200 4420   COLUMBUS MUNICIPAL SCHOOL DIST 280120001380 4420018 COLUMBUS MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6                                                   267                                             267
2243798 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279000989 4500014 SHIRLEY D. SIMMONS MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6                                                   55                                             55
2243817 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279001283 4500022 GERMANTOWN MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6                                                   336                                             336
2243838 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279001082 4500028 MADISON MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6                                                   378                                             378
2243865 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279000938 4500040 OLD TOWN MIDDLE   Regular School No Middle 06 08 2021   grade_6                                                   239                                             239
2243918 MS     school 2800900 4520   CANTON PUBLIC SCHOOL DIST 280090000103 4520016 NICHOLS MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6                                                   145                                             145
2243923 MS     school 2800900 4520   CANTON PUBLIC SCHOOL DIST 280090001394 4520018 HUEY L. PORTER MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6                                                   *                                              
2243953 MS     school 2802820 4600   MARION CO SCHOOL DIST 280282001243 4600002 EAST MARION ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_6                                                   67                                             67
2243965 MS     school 2802820 4600   MARION CO SCHOOL DIST 280282001246 4600010 WEST MARION ELEMENTARY   Regular School No Middle 04 06 2021   grade_6                                                   92                                             92
2243997 MS     school 2801170 4620   COLUMBIA SCHOOL DISTRICT 280117000151 4620016 JEFFERSON MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6                                                   113                                             113
2244014 MS     school 2802850 4700   MARSHALL CO SCHOOL DIST 280285000549 4700008 GALENA ELEMENTARY SCHOOL (K-6)   Regular School No Elementary KG 06 2021   grade_6                                                   13                                             13
2244024 MS     school 2802850 4700   MARSHALL CO SCHOOL DIST 280285001291 4700013 BYHALIA MIDDLE SCHOOL (5-8)   Regular School No Middle 05 08 2021   grade_6                                                   103                                             103
2244032 MS     school 2802850 4700   MARSHALL CO SCHOOL DIST 280285000551 4700016 POTTS CAMP HIGH SCHOOL (4-12)   Regular School No Other 04 12 2021   grade_6                                                   53                                             53
2244056 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_6                                                   45                                             45
2244076 MS     school 2801950 4720   HOLLY SPRINGS SCHOOL DIST 280195000336 4720008 HOLLY SPRINGS INTERMEDIATE SCHOOL   Regular School No Middle 04 06 2021   grade_6                                                   77                                             77
2244091 MS     school 2802940 4800   MONROE CO SCHOOL DIST 280294000580 4800012 HAMILTON HIGH SCHOOL   Regular School No Other PK 12 2021   grade_6                                                   46                                             46
2244107 MS     school 2802940 4800   MONROE CO SCHOOL DIST 280294000581 4800016 HATLEY HIGH SCHOOL   Regular School No Other PK 12 2021   grade_6                                                   85                                             85

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