Data source: Big Local News · About: Big Local

823 rows where grade = "grade_2" and state = "MS" sorted by ccd_school_high_grade

View and edit SQL

year

grade

  • grade_2 · 823
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
2033771 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000083 614024 NAILOR ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2020   grade_2                                                   100                                             100
2033968 MS     school 2802010 920   HOUSTON SCHOOL DIST 280201000344 920004 HOUSTON LOWER ELEMENTARY   Regular School No Elementary PK 02 2020   grade_2                                                   116                                             116
2034090 MS     school 2803780 1212   QUITMAN SCHOOL DIST 280378001142 1212006 QUITMAN LOWER ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2020   grade_2                                                   112                                             112
2034105 MS     school 2800191 1321   WEST POINT CONSOLIDATED SCHOOL DIST 280019101455 1321006 CHURCH HILL ELEMENTARY SCHOOL   Regular School No Elementary 01 02 2020   grade_2                                                   197                                             197
2034403 MS     school 2801320 1700   DESOTO CO SCHOOL DIST 280132000189 1700020 HORN LAKE ELEM   Regular School No Elementary PK 02 2020   grade_2                                                   159                                             159
2034455 MS     school 2801320 1700   DESOTO CO SCHOOL DIST 280132001191 1700036 SHADOW OAKS ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2020   grade_2                                                   128                                             128
2034481 MS     school 2801320 1700   DESOTO CO SCHOOL DIST 280132000197 1700044 HOPE SULLIVAN ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2020   grade_2                                                   214                                             214
2034488 MS     school 2801320 1700   DESOTO CO SCHOOL DIST 280132000185 1700046 GREENBROOK ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2020   grade_2                                                   181                                             181
2034510 MS     school 2801320 1700   DESOTO CO SCHOOL DIST 280132001369 1700051 DESOTO CENTRAL PRIMARY   Regular School No Elementary KG 02 2020   grade_2                                                   247                                             247
2034546 MS     school 2801320 1700   DESOTO CO SCHOOL DIST 280132001373 1700061 LEWISBURG PRIMARY   Regular School No Elementary PK 02 2020   grade_2                                                   226                                             226
2034736 MS     school 2803530 1821   PETAL SCHOOL DIST 280353001067 1821002 PETAL PRIMARY SCHOOL   Regular School No Elementary PK 02 2020   grade_2                                                   311                                             311
2034983 MS     school 2800570 2320   BAY ST LOUIS WAVELAND SCHOOL DIST 280057001376 2320016 WAVELAND ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2020   grade_2                                                   *                                              
2035296 MS     school 2801860 2500   HINDS CO SCHOOL DIST 280186001036 2500020 GARY ROAD ELEMENTARY   Regular School No Elementary PK 02 2020   grade_2                                                   301                                             301
2035351 MS     school 2800193 2505   JOEL E. SMILOW COLLEGIATE 280019301502 2505004 Joel E Smilow Collegiate   Regular School Yes Elementary KG 02 2020   grade_2                                                   120                                             120
2036001 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216000962 3000022 EAST CENTRAL LOWER ELEMENTARY   Regular School No Elementary PK 02 2020   grade_2                                                   164                                             164
2036015 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216000964 3000026 VANCLEAVE LOWER ELEMENTARY   Regular School No Elementary PK 02 2020   grade_2                                                   169                                             169
2036034 MS     school 2803000 3020   MOSS POINT SEPARATE SCHOOL DIST 280300000591 3020020 MOSS POINT KREOLE PRIMARY SCHOOL   Regular School No Elementary PK 02 2020   grade_2                                                   135                                             135
2036467 MS     school 2803450 3620   OXFORD SCHOOL DISTRICT 280345000662 3620008 OXFORD ELEMENTARY SCHOOL   Regular School No Elementary 01 02 2020   grade_2                                                   330                                             330
2036542 MS     school 2802400 3700   LAMAR COUNTY SCHOOL DISTRICT 280240000968 3700015 PURVIS LOWER ELEMENTARY   Regular School No Elementary PK 02 2020   grade_2                                                   110                                             110
2036865 MS     school 2802550 4100   LEE COUNTY SCHOOL DISTRICT 280255001265 4100020 SALTILLO PRIMARY SCHOOL   Regular School No Elementary KG 02 2020   grade_2                                                   *                                              
2036898 MS     school 2802550 4100   LEE COUNTY SCHOOL DISTRICT 280255001266 4100030 SHANNON PRIMARY SCHOOL   Regular School No Elementary KG 02 2020   grade_2                                                   *                                              
2036934 MS     school 2804320 4120   TUPELO PUBLIC SCHOOL DIST 280432000813 4120016 JOYNER ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2020   grade_2                                                   141                                             141
2036958 MS     school 2804320 4120   TUPELO PUBLIC SCHOOL DIST 280432001256 4120027 PARKWAY ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2020   grade_2                                                   139                                             139
2036973 MS     school 2804320 4120   TUPELO PUBLIC SCHOOL DIST 280432000818 4120036 THOMAS STREET ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2020   grade_2                                                   108                                             108
2037050 MS     school 2800198 4211   GREENWOOD-LEFLORE CONSOLIDATED SD 280019801520 4211022 CLAUDINE F BROWN ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2020   grade_2                                                   114                                             114
2037149 MS     school 2800840 4320   BROOKHAVEN SCHOOL DIST 280084000095 4320020 MAMIE MARTIN ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2020   grade_2                                                   197                                             197
2037333 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279001081 4500024 ANN SMITH ELEMENTARY   Regular School No Elementary PK 02 2020   grade_2                                                   227                                             227
2037355 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279001219 4500032 MADISON AVENUE LOWER ELEMENTARY   Regular School No Elementary KG 02 2020   grade_2                                                   159                                             159
2037387 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279001350 4500062 MANNSDALE ELEMENTARY   Regular School No Elementary KG 02 2020   grade_2                                                   228                                             228
2037505 MS     school 2801170 4620   COLUMBIA SCHOOL DISTRICT 280117000150 4620012 COLUMBIA PRIMARY SCHOOL   Regular School No Elementary PK 02 2020   grade_2                                                   95                                             95
2037681 MS     school 2800450 4821   AMORY SCHOOL DIST 280045000032 4821016 WEST AMORY SCHOOL   Regular School No Elementary KG 02 2020   grade_2                                                   *                                              
2037859 MS     school 2803210 5411   NORTH PANOLA SCHOOLS 280321000627 5411004 COMO PRIMARY   Regular School No Elementary PK 02 2020   grade_2                                                   112                                             112
2037976 MS     school 2803630 5520   PICAYUNE SCHOOL DIST 280363000632 5520026 SOUTH SIDE LOWER ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2020   grade_2                                                   55                                             55
2038002 MS     school 2803720 5530   POPLARVILLE SEPARATE SCHOOL DIST 280372000709 5530012 POPLARVILLE LOWER ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2020   grade_2                                                   152                                             152
2038187 MS     school 2803690 5820   PONTOTOC CITY SCHOOLS 280369000705 5820008 PONTOTOC ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2020   grade_2                                                   181                                             181
2038364 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383001277 6100017 STEEN'S CREEK ELEMENTARY   Regular School No Elementary KG 02 2020   grade_2                                                   195                                             195
2038526 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383001143 6100058 RICHLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2020   grade_2                                                   135                                             135
2039328 MS     school 2804470 7500   VICKSBURG WARREN SCHOOL DIST 280447000993 7500014 DANA ROAD ELEMENTARY   Regular School No Elementary PK 02 2020   grade_2                                                   116                                             116
2039675 MS     school 2802700 8020   LOUISVILLE MUNICIPAL SCHOOL DIST 280270001156 8020004 FAIR ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2020   grade_2                                                   112                                             112
2240324 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000083 614024 NAILOR ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2021   grade_2                                                   80                                             80
2240503 MS     school 2802010 920   HOUSTON SCHOOL DIST 280201000344 920004 HOUSTON LOWER ELEMENTARY   Regular School No Elementary PK 02 2021   grade_2                                                   128                                             128
2240626 MS     school 2803780 1212   QUITMAN SCHOOL DIST 280378001142 1212006 QUITMAN LOWER ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2021   grade_2                                                   102                                             102
2240641 MS     school 2800191 1321   WEST POINT CONSOLIDATED SCHOOL DIST 280019101455 1321006 CHURCH HILL ELEMENTARY SCHOOL   Regular School No Elementary 01 02 2021   grade_2                                                   170                                             170
2240935 MS     school 2801320 1700   DESOTO CO SCHOOL DIST 280132000189 1700020 HORN LAKE ELEM   Regular School No Elementary PK 02 2021   grade_2                                                   160                                             160
2240986 MS     school 2801320 1700   DESOTO CO SCHOOL DIST 280132001191 1700036 SHADOW OAKS ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2021   grade_2                                                   157                                             157
2241014 MS     school 2801320 1700   DESOTO CO SCHOOL DIST 280132000197 1700044 HOPE SULLIVAN ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2021   grade_2                                                   157                                             157
2241021 MS     school 2801320 1700   DESOTO CO SCHOOL DIST 280132000185 1700046 GREENBROOK ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2021   grade_2                                                   166                                             166
2241043 MS     school 2801320 1700   DESOTO CO SCHOOL DIST 280132001369 1700051 DESOTO CENTRAL PRIMARY   Regular School No Elementary KG 02 2021   grade_2                                                   251                                             251
2241078 MS     school 2801320 1700   DESOTO CO SCHOOL DIST 280132001373 1700061 LEWISBURG PRIMARY   Regular School No Elementary PK 02 2021   grade_2                                                   249                                             249
2241268 MS     school 2803530 1821   PETAL SCHOOL DIST 280353001067 1821002 PETAL PRIMARY SCHOOL   Regular School No Elementary PK 02 2021   grade_2                                                   313                                             313
2241362 MS     school 2801560 2000   GEORGE CO SCHOOL DIST 280156000229 2000016 LC HATCHER ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2021   grade_2                                                   64                                             64
2241507 MS     school 2800570 2320   BAY ST LOUIS WAVELAND SCHOOL DIST 280057001376 2320016 WAVELAND ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2021   grade_2                                                   116                                             116
2241829 MS     school 2801860 2500   HINDS CO SCHOOL DIST 280186001036 2500020 GARY ROAD ELEMENTARY   Regular School No Elementary PK 02 2021   grade_2                                                   213                                             213
2242281 MS     school 2800197 2545   AMBITION PREPARATORY 280019701510 2545004 Ambition Preparatory Charter School   Regular School Yes Elementary KG 02 2021   grade_2                                                   72                                             72
2242512 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216000962 3000022 EAST CENTRAL LOWER ELEMENTARY   Regular School No Elementary PK 02 2021   grade_2                                                   167                                             167
2242526 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216000964 3000026 VANCLEAVE LOWER ELEMENTARY   Regular School No Elementary PK 02 2021   grade_2                                                   174                                             174
2242543 MS     school 2803000 3020   MOSS POINT SEPARATE SCHOOL DIST 280300000591 3020020 MOSS POINT KREOLE PRIMARY SCHOOL   Regular School No Elementary PK 02 2021   grade_2                                                   104                                             104
2242947 MS     school 2802370 3600   LAFAYETTE CO SCHOOL DIST 280237000462 3600004 LAFAYETTE ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2021   grade_2                                                   176                                             176
2242971 MS     school 2803450 3620   OXFORD SCHOOL DISTRICT 280345000662 3620008 CENTRAL ELEMENTARY   Regular School No Elementary 01 02 2021   grade_2                                                   366                                             366
2243046 MS     school 2802400 3700   LAMAR COUNTY SCHOOL DISTRICT 280240000968 3700015 PURVIS LOWER ELEMENTARY   Regular School No Elementary PK 02 2021   grade_2                                                   129                                             129
2243368 MS     school 2802550 4100   LEE COUNTY SCHOOL DISTRICT 280255001265 4100020 SALTILLO PRIMARY SCHOOL   Regular School No Elementary KG 02 2021   grade_2                                                   242                                             242
2243400 MS     school 2802550 4100   LEE COUNTY SCHOOL DISTRICT 280255001266 4100030 SHANNON PRIMARY SCHOOL   Regular School No Elementary PK 02 2021   grade_2                                                   *                                              
2243435 MS     school 2804320 4120   TUPELO PUBLIC SCHOOL DIST 280432000813 4120016 JOYNER ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2021   grade_2                                                   136                                             136
2243459 MS     school 2804320 4120   TUPELO PUBLIC SCHOOL DIST 280432001256 4120027 PARKWAY ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2021   grade_2                                                   116                                             116
2243474 MS     school 2804320 4120   TUPELO PUBLIC SCHOOL DIST 280432000818 4120036 THOMAS STREET ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2021   grade_2                                                   146                                             146
2243551 MS     school 2800198 4211   GREENWOOD-LEFLORE CONSOLIDATED SD 280019801520 4211022 CLAUDINE F BROWN ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2021   grade_2                                                   83                                             83
2243652 MS     school 2800840 4320   BROOKHAVEN SCHOOL DIST 280084000095 4320020 MAMIE MARTIN ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2021   grade_2                                                   201                                             201
2243826 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279001081 4500024 ANN SMITH ELEMENTARY   Regular School No Elementary PK 02 2021   grade_2                                                   232                                             232
2243847 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279001219 4500032 MADISON AVENUE LOWER ELEMENTARY   Regular School No Elementary KG 02 2021   grade_2                                                   *                                              
2243879 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279001350 4500062 MANNSDALE ELEMENTARY   Regular School No Elementary KG 02 2021   grade_2                                                   186                                             186
2243995 MS     school 2801170 4620   COLUMBIA SCHOOL DISTRICT 280117000150 4620012 COLUMBIA PRIMARY SCHOOL   Regular School No Elementary PK 02 2021   grade_2                                                   108                                             108
2244171 MS     school 2800450 4821   AMORY SCHOOL DIST 280045000032 4821016 WEST AMORY SCHOOL   Regular School No Elementary PK 02 2021   grade_2                                                   132                                             132
2244350 MS     school 2803210 5411   NORTH PANOLA SCHOOLS 280321000627 5411004 COMO PRIMARY   Regular School No Elementary PK 02 2021   grade_2                                                   118                                             118
2244463 MS     school 2803630 5520   PICAYUNE SCHOOL DIST 280363000632 5520026 SOUTH SIDE LOWER ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2021   grade_2                                                   79                                             79
2244490 MS     school 2803720 5530   POPLARVILLE SEPARATE SCHOOL DIST 280372000709 5530012 POPLARVILLE LOWER ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2021   grade_2                                                   117                                             117
2244675 MS     school 2803690 5820   PONTOTOC CITY SCHOOLS 280369000705 5820008 PONTOTOC ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2021   grade_2                                                   156                                             156
2244852 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383001277 6100017 STEEN'S CREEK ELEMENTARY   Regular School No Elementary KG 02 2021   grade_2                                                   164                                             164
2245015 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383001143 6100058 RICHLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2021   grade_2                                                   129                                             129
2245819 MS     school 2804470 7500   VICKSBURG WARREN SCHOOL DIST 280447000993 7500014 DANA ROAD ELEMENTARY   Regular School No Elementary PK 02 2021   grade_2                                                   117                                             117
2245841 MS     school 2804470 7500   VICKSBURG WARREN SCHOOL DIST 280447000995 7500021 SHERMAN AVE ELEMENTARY   Regular School No Elementary PK 02 2021   grade_2                                                   96                                             96
2246164 MS     school 2802700 8020   LOUISVILLE MUNICIPAL SCHOOL DIST 280270001156 8020004 FAIR ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2021   grade_2                                                   108                                             108
2033687 MS     school 2802340 420   KOSCIUSKO SCHOOL DISTRICT 280234000459 420012 KOSCIUSKO MIDDLE   Regular School No Elementary 02 03 2020   grade_2                                                   172                                             172
2034233 MS     school 2800194 1425   CLARKSDALE COLLEGIATE 280019401492 1425004 CLARKSDALE COLLEGIATE   Regular School Yes Elementary KG 03 2020   grade_2                                                   48                                             48
2034246 MS     school 2801220 1500   COPIAH CO SCHOOL DIST 280122001189 1500006 CRYSTAL SPRINGS ELEMENTARY   Regular School No Elementary KG 03 2020   grade_2                                                   107                                             107
2034357 MS     school 2801320 1700   DESOTO CO SCHOOL DIST 280132001190 1700008 CHICKASAW ELEMENTARY SCHOOL   Regular School No Elementary 02 03 2020   grade_2                                                   277                                             277
2034384 MS     school 2801320 1700   DESOTO CO SCHOOL DIST 280132001287 1700015 HERNANDO HILLS ELEMENTARY   Regular School No Elementary 02 03 2020   grade_2                                                   343                                             343
2034763 MS     school 2801530 1900   FRANKLIN CO SCHOOL DIST 280153000223 1900004 FRANKLIN LOWER ELEMENTARY   Regular School No Elementary PK 03 2020   grade_2                                                   89                                             89
2034995 MS     school 2801770 2400   HARRISON CO SCHOOL DIST 280177000284 2400003 DIBERVILLE ELEM   Regular School No Elementary KG 03 2020   grade_2                                                   170                                             170
2035019 MS     school 2801770 2400   HARRISON CO SCHOOL DIST 280177000287 2400012 HARRISON CENTRAL ELEMENTARY   Regular School No Elementary KG 03 2020   grade_2                                                   144                                             144
2035235 MS     school 2802670 2422   LONG BEACH SCHOOL DIST 280267000518 2422008 THOMAS L REEVES ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2020   grade_2                                                   110                                             110
2035251 MS     school 2802670 2422   LONG BEACH SCHOOL DIST 280267000521 2422020 WJ QUARLES ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2020   grade_2                                                   125                                             125
2035753 MS     school 2801090 2521   CLINTON PUBLIC SCHOOL DIST 280109000136 2521016 NORTHSIDE ELEM   Regular School No Elementary 02 03 2020   grade_2                                                   *                                              
2035958 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216000366 3000010 ST MARTIN N ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2020   grade_2                                                   125                                             125
2035976 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216001048 3000014 ST MARTIN EAST ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2020   grade_2                                                   168                                             168
2036046 MS     school 2803360 3021   OCEAN SPRINGS SCHOOL DIST 280336000647 3021004 OAK PARK ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2020   grade_2                                                   103                                             103
2036058 MS     school 2803360 3021   OCEAN SPRINGS SCHOOL DIST 280336000648 3021008 MAGNOLIA PARK ELEMENTARY   Regular School No Elementary KG 03 2020   grade_2                                                   175                                             175
2036075 MS     school 2803360 3021   OCEAN SPRINGS SCHOOL DIST 280336000652 3021024 PECAN PARK ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2020   grade_2                                                   133                                             133
2036393 MS     school 2802460 3420   LAUREL SCHOOL DISTRICT 280246000476 3420020 MASON ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2020   grade_2                                                   108                                             108
2036399 MS     school 2802460 3420   LAUREL SCHOOL DISTRICT 280246000477 3420024 OAK PARK ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2020   grade_2                                                   122                                             122
2036442 MS     school 2802370 3600   LAFAYETTE CO SCHOOL DIST 280237000462 3600004 LAFAYETTE ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2020   grade_2                                                   203                                             203

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