Data source: Big Local News · About: Big Local

272 rows where grade = "grade_7", state = "MS" and year = 2021 sorted by school

View and edit SQL

year

  • 2021 · 172

grade

  • grade_7 · 172
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
2242405 MS     school 2802100 2900   ITAWAMBA CO SCHOOL DIST 280210000358 2900012 ITAWAMBA ATTENDANCE CENTER   Regular School No Elementary KG 08 2021   grade_7                                                   154                                             154
2245596 MS     school 2804260 7100   TISHOMINGO CO SP MUN SCH DIST 280426001226 7100020 IUKA MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_7                                                   100                                             100
2242788 MS     school 2802250 3300   JEFFERSON DAVIS CO SCHOOL DIST 280225000432 3300012 J E JOHNSON ELEMENTARY   Regular School No Elementary KG 08 2021   grade_7                                                   58                                             58
2240461 MS     school 2800930 800   CARROLL COUNTY SCHOOL DIST 280093000104 800004 J Z GEORGE HIGH SCHOOL   Regular School No High 06 12 2021   grade_7                                                   88                                             88
2242761 MS     school 2802220 3200   JEFFERSON CO SCHOOL DIST 280222001292 3200012 JEFFERSON CO JR HI   Regular School No Middle 07 08 2021   grade_7                                                   103                                             103
2243998 MS     school 2801170 4620   COLUMBIA SCHOOL DISTRICT 280117000151 4620016 JEFFERSON MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   119                                             119
2242276 MS     school 2800192 2535   SMILOW PREP 280019201471 2535004 JOEL E. SMILOW PREP   Regular School Yes Middle 05 08 2021   grade_7                                                   170                                             170
2244709 MS     school 2803750 5900   PRENTISS CO SCHOOL DIST 280375000717 5900020 JUMPERTOWN HIGH SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   24                                             24
2242933 MS     school 2802310 3500   KEMPER CO SCHOOL DIST 280231001489 3500014 KEMPER COUNTY MIDDLE SCHOOL   Regular School No Middle 07 08 2021   grade_7                                                   78                                             78
2242083 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219001365 2520055 KIRKSEY MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   104                                             104
2240232 MS     school 2802340 420   KOSCIUSKO SCHOOL DISTRICT 280234000457 420004 KOSCIUSKO JUNIOR HIGH SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   197                                             197
2240143 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001566 200023 KOSSUTH MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_7                                                   98                                             98
2242955 MS     school 2802370 3600   LAFAYETTE CO SCHOOL DIST 280237000967 3600012 LAFAYETTE MIDDLE SCHOOL   Regular School No Middle 07 08 2021   grade_7                                                   *                                              
2241130 MS     school 2801320 1700   DESOTO CO SCHOOL DIST 280132001282 1700084 LAKE CORMORANT MIDDLE   Regular School No Middle 06 08 2021   grade_7                                                   262                                             262
2245042 MS     school 2803900 6200   SCOTT CO SCHOOL DIST 280390001144 6200006 LAKE MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_7                                                   55                                             55
2242893 MS     school 2802460 3420   LAUREL SCHOOL DISTRICT 280246001345 3420006 LAUREL MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   222                                             222
2243313 MS     school 2802520 4000   LEAKE CO SCHOOL DIST 280252001119 4000006 LEAKE CENTRAL JUNIOR HIGH   Regular School No Middle 06 08 2021   grade_7                                                   163                                             163
2243327 MS     school 2802520 4000   LEAKE CO SCHOOL DIST 280252000490 4000016 LEAKE COUNTY HIGH SCHOOL   Regular School No High 07 12 2021   grade_7                                                   68                                             68
2241392 MS     school 2801590 2100   GREENE COUNTY SCHOOL DISTRICT 280159001134 2100004 LEAKESVILLE JR HIGH SCHOOL   Regular School No Middle 05 08 2021   grade_7                                                   96                                             96
2243532 MS     school 2800198 4211   GREENWOOD-LEFLORE CONSOLIDATED SD 280019801518 4211020 LEFLORE COUNTY HIGH SCHOOL   Regular School No High 07 12 2021   grade_7                                                   54                                             54
2245919 MS     school 2802610 7612   LELAND SCHOOL DIST 280261001472 7612008 LELAND SCHOOL PARK   Regular School No Middle 06 08 2021   grade_7                                                   68                                             68
2241088 MS     school 2801320 1700   DESOTO CO SCHOOL DIST 280132001343 1700064 LEWISBURG MIDDLE   Regular School No Middle 06 08 2021   grade_7                                                   310                                             310
2241763 MS     school 2802670 2422   LONG BEACH SCHOOL DIST 280267000519 2422012 LONG BEACH MIDDLE SCHOOL   Regular School No Middle 07 08 2021   grade_7                                                   *                                              
2243602 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000515 4300016 LOYD STAR SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   63                                             63
2243093 MS     school 2802400 3700   LAMAR COUNTY SCHOOL DISTRICT 280240001507 3700025 LUMBERTON MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   51                                             51
2243839 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279001082 4500028 MADISON MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   407                                             407
2245167 MS     school 2803990 6400   SIMPSON CO SCHOOL DIST 280399001085 6400010 MAGEE MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   99                                             99
2242546 MS     school 2803000 3020   MOSS POINT SEPARATE SCHOOL DIST 280300000592 3020028 MAGNOLIA MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   *                                              
2243197 MS     school 2802910 3820   MERIDIAN PUBLIC SCHOOL DIST 280291000564 3820024 MAGNOLIA MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   124                                             124
2242416 MS     school 2802100 2900   ITAWAMBA CO SCHOOL DIST 280210000361 2900024 MANTACHIE ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_7                                                   96                                             96
2244725 MS     school 2803750 5900   PRENTISS CO SCHOOL DIST 280375000718 5900024 MARIETTA ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2021   grade_7                                                   34                                             34
2241402 MS     school 2801590 2100   GREENE COUNTY SCHOOL DISTRICT 280159000233 2100008 MC LAIN ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2021   grade_7                                                   20                                             20
2240222 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000039 400020 MCADAMS ATTENDANCE CENTER   Regular School No High 07 12 2021   grade_7                                                   29                                             29
2240384 MS     school 2800185 618   WEST BOLIVAR CONS SCHOOL DISTRICT 280018501527 618015 MCEVANS SCHOOL   Regular School No Other KG 12 2021   grade_7                                                   53                                             53
2244893 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383000739 6100028 MCLAURIN ATTENDANCE CENTER   Regular School No High 07 12 2021   grade_7                                                   87                                             87
2245184 MS     school 2803990 6400   SIMPSON CO SCHOOL DIST 280399001087 6400016 MENDENHALL JUNIOR HIGH SCHOOL   Regular School No Middle 05 08 2021   grade_7                                                   102                                             102
2244483 MS     school 2803720 5530   POPLARVILLE SEPARATE SCHOOL DIST 280372000992 5530009 MIDDLE SCHOOL OF POPLARVILLE   Regular School No Middle 06 08 2021   grade_7                                                   *                                              
2242270 MS     school 2800190 2525   MIDTOWN PUBLIC CHARTER SCHOOL 280019001448 2525004 MIDTOWN PUBLIC CHARTER SCHOOL   Regular School Yes Middle 05 08 2021   grade_7                                                   72                                             72
2245204 MS     school 2804020 6500   SMITH CO SCHOOL DIST 280402000758 6500004 MIZE ATTENDANCE CENTER   Regular School No Other PK 12 2021   grade_7                                                   65                                             65
2243340 MS     school 2802550 4100   LEE COUNTY SCHOOL DISTRICT 280255001276 4100007 MOOREVILLE MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   *                                              
2245323 MS     school 2800187 6711   SUNFLOWER CO CONSOLIDATE SCH DIST 280018701498 6711018 MOORHEAD CENTRAL SCHOOL   Regular School No Elementary KG 08 2021   grade_7                                                   27                                             27
2240050 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000602 130028 MORGANTOWN MIDDLE   Regular School No Middle 06 08 2021   grade_7                                                   100                                             100
2240865 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000181 1600020 MOUNT OLIVE ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_7                                                   28                                             28
2242304 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_7                                                   *                                              
2242292 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_7                                                   *                                              
2245688 MS     school 2804350 7300   UNION CO SCHOOL DIST 280435000823 7300012 MYRTLE ATTENDANCE CENTER   Regular School No Other PK 12 2021   grade_7                                                   49                                             49
2244260 MS     school 2803180 5130   NEWTON MUNICIPAL SCHOOL DISTRICT 280318001179 5130006 N H PILATE MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   78                                             78
2241224 MS     school 2801800 1820   HATTIESBURG PUBLIC SCHOOL DIST 280180000980 1820030 N R BURGER MIDDLE SCHOOL   Regular School No Middle 07 08 2021   grade_7                                                   288                                             288
2246190 MS     school 2802700 8020   LOUISVILLE MUNICIPAL SCHOOL DIST 280270000526 8020016 NANIH WAIYA ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_7                                                   46                                             46
2244205 MS     school 2803060 5000   NESHOBA COUNTY SCHOOL DISTRICT 280306000990 5000006 NESHOBA CENTRAL MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   264                                             264
2243425 MS     school 2803090 4111   NETTLETON SCHOOL DIST 280309001160 4111010 NETTLETON INTERMEDIATE SCHOOL   Regular School No Middle 04 08 2021   grade_7                                                   104                                             104
2245731 MS     school 2803120 7320   NEW ALBANY PUBLIC SCHOOLS 280312000618 7320016 NEW ALBANY MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   *                                              
2243283 MS     school 2802490 3900   LAWRENCE CO SCHOOL DIST 280249000483 3900016 NEW HEBRON ATTENDANCE CENTER   Regular School No Elementary KG 08 2021   grade_7                                                   52                                             52
2243700 MS     school 2802730 4400   LOWNDES CO SCHOOL DIST 280273001128 4400018 NEW HOPE MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   224                                             224
2244243 MS     school 2803150 5100   NEWTON COUNTY SCHOOL DISTRICT 280315001135 5100012 NEWTON COUNTY HIGH SCHOOL   Regular School No High 06 12 2021   grade_7                                                   152                                             152
2243919 MS     school 2800900 4520   CANTON PUBLIC SCHOOL DIST 280090000103 4520016 NICHOLS MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   131                                             131
2241155 MS     school 2801490 1800   FORREST COUNTY SCHOOL DISTRICT 280149000218 1800012 NORTH FORREST HIGH SCHOOL   Regular School No High 07 12 2021   grade_7                                                   71                                             71
2241572 MS     school 2801770 2400   HARRISON CO SCHOOL DIST 280177001469 2400030 NORTH GULFPORT MIDDLE SCHOOL   Regular School No Middle 07 08 2021   grade_7                                                   569                                             569
2244353 MS     school 2803210 5411   NORTH PANOLA SCHOOLS 280321001339 5411006 NORTH PANOLA MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   136                                             136
2244549 MS     school 2803240 5711   NORTH PIKE SCHOOL DIST 280324000635 5711012 NORTH PIKE MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   *                                              
2241582 MS     school 2801770 2400   HARRISON CO SCHOOL DIST 280177000958 2400038 NORTH WOOLMARKET ELEMENTARY AND MID   Regular School No Elementary KG 08 2021   grade_7                                                   174                                             174
2242826 MS     school 2802280 3400   JONES CO SCHOOL DIST 280228000443 3400024 NORTHEAST JONES HIGH SCHOOL   Regular School No High 07 12 2021   grade_7                                                   150                                             150
2243134 MS     school 2802430 3800   LAUDERDALE CO SCHOOL DIST 280243000568 3800010 NORTHEAST LAUDERDALE MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_7                                                   151                                             151
2240351 MS     school 2800186 617   NORTH BOLIVAR CONS SCH 280018601411 617010 NORTHSIDE HIGH SCHOOL   Regular School No High 07 12 2021   grade_7                                                   83                                             83
2243208 MS     school 2802910 3820   MERIDIAN PUBLIC SCHOOL DIST 280291000569 3820044 NORTHWEST JUNIOR HIGH SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   170                                             170
2242069 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219001155 2520052 NORTHWEST MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   110                                             110
2244889 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383000955 6100026 NORTHWEST RANKIN MIDDLE SCHOOL   Regular School No Middle 07 08 2021   grade_7                                                   514                                             514
2246206 MS     school 2802700 8020   LOUISVILLE MUNICIPAL SCHOOL DIST 280270000527 8020020 NOXAPATER ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_7                                                   35                                             35
2244630 MS     school 2803660 5800   PONTOTOC CO SCHOOL DIST 280366001009 5800003 North Pontotoc Middle School   Regular School No Middle 07 08 2021   grade_7                                                   *                                              
2242370 MS     school 2802040 2700   HUMPHREYS CO SCHOOL DIST 280204001039 2700006 O M MC NAIR MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_7                                                   133                                             133
2245948 MS     school 2804680 7613   WESTERN LINE SCHOOL DISTRICT 280468000975 7613016 O'BANNON HIGH SCHOOL   Regular School No High 07 12 2021   grade_7                                                   74                                             74
2243071 MS     school 2802400 3700   LAMAR COUNTY SCHOOL DISTRICT 280240001253 3700021 OAK GROVE MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   461                                             461
2242576 MS     school 2803360 3021   OCEAN SPRINGS SCHOOL DIST 280336000934 3021022 OCEAN SPRINGS MIDDLE SCHOOL   Regular School No Middle 07 08 2021   grade_7                                                   474                                             474
2240536 MS     school 2803390 921   OKOLONA SEPARATE SCHOOL DIST 280339001482 921012 OKOLONA MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   52                                             52
2243866 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279000938 4500040 OLD TOWN MIDDLE   Regular School No Middle 06 08 2021   grade_7                                                   247                                             247
2240978 MS     school 2801320 1700   DESOTO CO SCHOOL DIST 280132000194 1700034 OLIVE BRANCH MIDDLE   Regular School No Middle 06 08 2021   grade_7                                                   *                                              
2242988 MS     school 2803450 3620   OXFORD SCHOOL DISTRICT 280345000664 3620016 OXFORD MIDDLE SCHOOL   Regular School No Middle 07 08 2021   grade_7                                                   307                                             307
2241805 MS     school 2803510 2423   PASS CHRISTIAN PUBLIC SCHOOL DIST 280351000685 2423016 PASS CHRISTIAN MIDDLE   Regular School No Middle 06 08 2021   grade_7                                                   *                                              
2245033 MS     school 2803520 6120   PEARL PUBLIC SCHOOL DIST 280352001354 6120016 PEARL JUNIOR HIGH SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   352                                             352
2244407 MS     school 2803540 5500   PEARL RIVER CO SCHOOL DIST 280354001069 5500008 PEARL RIVER CENTRAL JUNIOR HIGH   Regular School No Middle 06 08 2021   grade_7                                                   275                                             275
2242128 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000405 2520062 PEEPLES MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   122                                             122
2244944 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383000740 6100044 PELAHATCHIE ATTENDANCE CENTER   Regular School No High 07 12 2021   grade_7                                                   56                                             56
2244505 MS     school 2803570 5600   PERRY CO SCHOOL DIST 280357000689 5600012 PERRY CENTRAL MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   70                                             70
2241271 MS     school 2803530 1821   PETAL SCHOOL DIST 280353000005 1821004 PETAL MIDDLE SCHOOL   Regular School No Middle 07 08 2021   grade_7                                                   368                                             368
2244225 MS     school 2803600 5020   PHILADELPHIA PUBLIC SCHOOL DIST 280360000692 5020008 PHILADELPHIA HIGH SCHOOL   Regular School No High 07 12 2021   grade_7                                                   71                                             71
2244431 MS     school 2803630 5520   PICAYUNE SCHOOL DIST 280363000697 5520012 PICAYUNE JUNIOR HIGH SCHOOL   Regular School No Middle 07 08 2021   grade_7                                                   241                                             241
2245528 MS     school 2804110 7012   SOUTH TIPPAH SCHOOL DIST 280411000776 7012008 PINE GROVE HIGH SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   61                                             61
2244972 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383001079 6100050 PISGAH HIGH SCHOOL   Regular School No High 07 12 2021   grade_7                                                   64                                             64
2243361 MS     school 2802550 4100   LEE COUNTY SCHOOL DISTRICT 280255000495 4100016 PLANTERSVILLE MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_7                                                   67                                             67
2244678 MS     school 2803690 5820   PONTOTOC CITY SCHOOLS 280369001162 5820010 PONTOTOC JUNIOR HIGH SCHOOL   Regular School No Middle 07 08 2021   grade_7                                                   176                                             176
2244388 MS     school 2804050 5412   SOUTH PANOLA SCHOOL DISTRICT 280405000765 5412012 POPE ELEMENTARY SCHOOL   Regular School No Elementary KG 08 2021   grade_7                                                   61                                             61
2240586 MS     school 2801020 1100   CLAIBORNE CO SCHOOL DIST 280102000115 1100004 PORT GIBSON MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   106                                             106
2244033 MS     school 2802850 4700   MARSHALL CO SCHOOL DIST 280285000551 4700016 POTTS CAMP HIGH SCHOOL (4-12)   Regular School No Other 04 12 2021   grade_7                                                   55                                             55
2242133 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000407 2520065 POWELL MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   152                                             152
2244979 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383000742 6100052 PUCKETT ATTENDANCE CENTER   Regular School No High 07 12 2021   grade_7                                                   63                                             63
2243076 MS     school 2802400 3700   LAMAR COUNTY SCHOOL DISTRICT 280240001254 3700022 PURVIS MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   143                                             143
2244823 MS     school 2803810 6000   QUITMAN CO SCHOOL DIST 280381000734 6000032 QUITMAN COUNTY MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_7                                                   67                                             67
2240619 MS     school 2803780 1212   QUITMAN SCHOOL DIST 280378000723 1212004 QUITMAN JR HIGH SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   153                                             153
2244789 MS     school 2800820 5921   BOONEVILLE SCHOOL DIST 280082001329 5921004 R.H. LONG BOONEVILLE MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_7                                                   *                                              
2245212 MS     school 2804020 6500   SMITH CO SCHOOL DIST 280402000759 6500008 RALEIGH HIGH SCHOOL   Regular School No High 07 12 2021   grade_7                                                   82                                             82

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