Data source: Big Local News · About: Big Local

409 rows where grade = "grade_1", state = "MS" and year = 2021

View and edit SQL

year

  • 2021 · 309

grade

  • grade_1 · 309
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
2241590 MS     school 2801770 2400   HARRISON CO SCHOOL DIST 280177000296 2400044 PINEVILLE ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_1                                                   19                                             19
2241598 MS     school 2801770 2400   HARRISON CO SCHOOL DIST 280177001431 2400046 RIVER OAKS ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_1                                                   70                                             70
2241606 MS     school 2801770 2400   HARRISON CO SCHOOL DIST 280177000297 2400048 SAUCIER ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_1                                                   50                                             50
2241614 MS     school 2801770 2400   HARRISON CO SCHOOL DIST 280177000913 2400050 THREE RIVERS ELEMENTARY   Regular School No Elementary KG 06 2021   grade_1                                                   78                                             78
2241622 MS     school 2801770 2400   HARRISON CO SCHOOL DIST 280177000959 2400051 WEST WORTHAM ELEMENTARY AND MIDDLE   Regular School No Elementary KG 08 2021   grade_1                                                   105                                             105
2241632 MS     school 2801770 2400   HARRISON CO SCHOOL DIST 280177000298 2400052 WOOLMARKET ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_1                                                   59                                             59
2241659 MS     school 2800630 2420   BILOXI PUBLIC SCHOOL DIST 280063001234 2420014 NORTH BAY ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2021   grade_1                                                   161                                             161
2241665 MS     school 2800630 2420   BILOXI PUBLIC SCHOOL DIST 280063000055 2420016 JEFF DAVIS ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2021   grade_1                                                   105                                             105
2241679 MS     school 2800630 2420   BILOXI PUBLIC SCHOOL DIST 280063001263 2420042 NICHOLS ELEMENTARY SCHOOL   Regular School No Elementary PK 01 2021   grade_1                                                   106                                             106
2241683 MS     school 2800630 2420   BILOXI PUBLIC SCHOOL DIST 280063000063 2420044 POPPS FERRY ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2021   grade_1                                                   117                                             117
2241689 MS     school 2801710 2421   GULFPORT SCHOOL DIST 280171000268 2421004 ANNISTON AVENUE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_1                                                   109                                             109
2241697 MS     school 2801710 2421   GULFPORT SCHOOL DIST 280171000269 2421008 BAYOU VIEW ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_1                                                   106                                             106
2241709 MS     school 2801710 2421   GULFPORT SCHOOL DIST 280171000271 2421014 CENTRAL ELEM   Regular School No Elementary PK 05 2021   grade_1                                                   61                                             61
2241728 MS     school 2801710 2421   GULFPORT SCHOOL DIST 280171000277 2421060 PASS ROAD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_1                                                   95                                             95
2241737 MS     school 2801710 2421   GULFPORT SCHOOL DIST 280171000279 2421064 WEST ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_1                                                   89                                             89
2241745 MS     school 2801710 2421   GULFPORT SCHOOL DIST 280171001349 2421072 TWENTY EIGHTH ST ELEM   Regular School No Elementary PK 05 2021   grade_1                                                   46                                             46
2241758 MS     school 2802670 2422   LONG BEACH SCHOOL DIST 280267000518 2422008 THOMAS L REEVES ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2021   grade_1                                                   92                                             92
2241774 MS     school 2802670 2422   LONG BEACH SCHOOL DIST 280267000521 2422020 WJ QUARLES ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2021   grade_1                                                   114                                             114
2241781 MS     school 2803510 2423   PASS CHRISTIAN PUBLIC SCHOOL DIST 280351000682 2423004 DELISLE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_1                                                   72                                             72
2241790 MS     school 2803510 2423   PASS CHRISTIAN PUBLIC SCHOOL DIST 280351000683 2423008 PASS CHRISTIAN ELEM   Regular School No Elementary PK 05 2021   grade_1                                                   66                                             66
2241828 MS     school 2801860 2500   HINDS CO SCHOOL DIST 280186001036 2500020 GARY ROAD ELEMENTARY   Regular School No Elementary PK 02 2021   grade_1                                                   223                                             223
2241839 MS     school 2801860 2500   HINDS CO SCHOOL DIST 280186000326 2500028 UTICA ELEM. / MIDDLE SCHOOL   Regular School No Elementary PK 08 2021   grade_1                                                   45                                             45
2241864 MS     school 2801860 2500   HINDS CO SCHOOL DIST 280186000961 2500042 RAYMOND ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_1                                                   47                                             47
2241874 MS     school 2801860 2500   HINDS CO SCHOOL DIST 280186000984 2500044 BOLTON-EDWARDS ELEM./MIDDLE SCHOOL   Regular School No Elementary PK 08 2021   grade_1                                                   32                                             32
2241884 MS     school 2800193 2505   JOEL E. SMILOW COLLEGIATE 280019301502 2505004 Joel E Smilow Collegiate   Regular School Yes Elementary KG 03 2021   grade_1                                                   126                                             126
2241895 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219001052 2520004 BARACK H OBAMA ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_1                                                   43                                             43
2241907 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000370 2520007 BAKER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_1                                                   33                                             33
2241920 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000373 2520011 BOYD ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_1                                                   66                                             66
2241939 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000379 2520020 CASEY ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_1                                                   60                                             60
2241953 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000381 2520024 CLAUSELL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_1                                                   59                                             59
2241961 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000382 2520027 DAWSON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_1                                                   51                                             51
2241976 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000386 2520033 GALLOWAY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_1                                                   58                                             58
2241984 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000388 2520036 GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_1                                                   44                                             44
2242000 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000392 2520040 JOHN HOPKINS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_1                                                   37                                             37
2242008 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000391 2520041 ISABLE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_1                                                   58                                             58
2242017 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000393 2520042 JOHNSON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_1                                                   57                                             57
2242025 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219001364 2520043 BATES ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_1                                                   66                                             66
2242033 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000394 2520045 KEY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_1                                                   48                                             48
2242041 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000395 2520047 LAKE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_1                                                   40                                             40
2242055 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000397 2520050 LEE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_1                                                   39                                             39
2242062 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000398 2520051 LESTER ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_1                                                   37                                             37
2242075 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000399 2520053 MARSHALL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_1                                                   27                                             27
2242090 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000400 2520056 MC LEOD ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_1                                                   73                                             73
2242098 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219001242 2520057 MCWILLIE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_1                                                   41                                             41
2242107 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219001054 2520058 NORTH JACKSON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_1                                                   59                                             59
2242120 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000404 2520061 OAK FOREST ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_1                                                   63                                             63
2242148 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000410 2520069 RAINES ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_1                                                   35                                             35
2242157 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000413 2520077 SMITH ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_1                                                   48                                             48
2242165 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000414 2520078 SPANN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_1                                                   74                                             74
2242173 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000416 2520079 TIMBERLAWN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_1                                                   65                                             65
2242181 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000415 2520080 SYKES ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_1                                                   42                                             42
2242190 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000418 2520081 WALTON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_1                                                   34                                             34
2242200 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000419 2520083 WATKINS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_1                                                   35                                             35
2242209 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000420 2520084 PECAN PARK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_1                                                   79                                             79
2242228 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000422 2520087 WILKINS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_1                                                   43                                             43
2242252 MS     school 2801090 2521   CLINTON PUBLIC SCHOOL DIST 280109000133 2521012 CLINTON PARK ELEM SCHOOL   Regular School No Elementary PK 01 2021   grade_1                                                   332                                             332
2242280 MS     school 2800197 2545   AMBITION PREPARATORY 280019701510 2545004 Ambition Preparatory Charter School   Regular School Yes Elementary KG 02 2021   grade_1                                                   85                                             85
2242286 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_1                                                   *                                              
2242321 MS     school 2800195 2611   HOLMES CONSOLIDATE SCHOOL DIST 280019501495 2611004 DURANT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_1                                                   39                                             39
2242332 MS     school 2800195 2611   HOLMES CONSOLIDATE SCHOOL DIST 280019501503 2611008 GOODMAN PICKENS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_1                                                   30                                             30
2242348 MS     school 2800195 2611   HOLMES CONSOLIDATE SCHOOL DIST 280019501496 2611018 WILLIAM DEAN JR. ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_1                                                   81                                             81
2242355 MS     school 2800195 2611   HOLMES CONSOLIDATE SCHOOL DIST 280019501486 2611024 S V MARSHALL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_1                                                   27                                             27
2242362 MS     school 2802040 2700   HUMPHREYS CO SCHOOL DIST 280204000349 2700004 IDA GREENE LOWER ELEMENTARY   Regular School No Elementary KG 04 2021   grade_1                                                   80                                             80
2242381 MS     school 2802100 2900   ITAWAMBA CO SCHOOL DIST 280210000356 2900004 DORSEY ATTENDANCE CENTER   Regular School No Elementary KG 06 2021   grade_1                                                   *                                              
2242389 MS     school 2802100 2900   ITAWAMBA CO SCHOOL DIST 280210000357 2900008 FAIRVIEW ATTENDANCE CENTER   Regular School No Elementary KG 06 2021   grade_1                                                   *                                              
2242399 MS     school 2802100 2900   ITAWAMBA CO SCHOOL DIST 280210000358 2900012 ITAWAMBA ATTENDANCE CENTER   Regular School No Elementary KG 08 2021   grade_1                                                   114                                             114
2242410 MS     school 2802100 2900   ITAWAMBA CO SCHOOL DIST 280210000361 2900024 MANTACHIE ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_1                                                   71                                             71
2242425 MS     school 2802100 2900   ITAWAMBA CO SCHOOL DIST 280210000362 2900028 TREMONT ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_1                                                   26                                             26
2242467 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216000366 3000010 ST MARTIN N ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2021   grade_1                                                   124                                             124
2242486 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216001048 3000014 ST MARTIN EAST ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2021   grade_1                                                   145                                             145
2242511 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216000962 3000022 EAST CENTRAL LOWER ELEMENTARY   Regular School No Elementary PK 02 2021   grade_1                                                   171                                             171
2242525 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216000964 3000026 VANCLEAVE LOWER ELEMENTARY   Regular School No Elementary PK 02 2021   grade_1                                                   178                                             178
2242542 MS     school 2803000 3020   MOSS POINT SEPARATE SCHOOL DIST 280300000591 3020020 MOSS POINT KREOLE PRIMARY SCHOOL   Regular School No Elementary PK 02 2021   grade_1                                                   98                                             98
2242554 MS     school 2803360 3021   OCEAN SPRINGS SCHOOL DIST 280336000647 3021004 OAK PARK ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2021   grade_1                                                   129                                             129
2242566 MS     school 2803360 3021   OCEAN SPRINGS SCHOOL DIST 280336000648 3021008 MAGNOLIA PARK ELEMENTARY   Regular School No Elementary KG 03 2021   grade_1                                                   169                                             169
2242583 MS     school 2803360 3021   OCEAN SPRINGS SCHOOL DIST 280336000652 3021024 PECAN PARK ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2021   grade_1                                                   138                                             138
2242589 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348000666 3022004 ARLINGTON HEIGHTS ELEM SCHOOL   Regular School No Elementary PK 04 2021   grade_1                                                   56                                             56
2242595 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348000667 3022008 BEACH ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2021   grade_1                                                   19                                             19
2242604 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348000668 3022012 CENTRAL ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2021   grade_1                                                   30                                             30
2242610 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348000669 3022016 CHEROKEE ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2021   grade_1                                                   42                                             42
2242620 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348000670 3022020 COLLEGE PARK ELEM   Regular School No Elementary PK 04 2021   grade_1                                                   54                                             54
2242630 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348000672 3022028 EASTLAWN ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2021   grade_1                                                   57                                             57
2242638 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348000674 3022036 GAUTIER ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2021   grade_1                                                   73                                             73
2242654 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348000676 3022044 JACKSON ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2021   grade_1                                                   43                                             43
2242660 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348000677 3022048 LAKE ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2021   grade_1                                                   14                                             14
2242667 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348001236 3022050 MARTIN BLUFF   Regular School No Elementary PK 04 2021   grade_1                                                   71                                             71
2242699 MS     school 2801380 3111   EAST JASPER CONSOLIDATED SCH DIST 280138000205 3111008 WILLIAM J BERRY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_1                                                   61                                             61
2242711 MS     school 2804590 3112   WEST JASPER CONSOLIDATED SCHOOLS 280459000858 3112004 BAY SPRINGS ELEM SCH   Regular School No Elementary KG 05 2021   grade_1                                                   65                                             65
2242730 MS     school 2804590 3112   WEST JASPER CONSOLIDATED SCHOOLS 280459000859 3112012 STRINGER ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_1                                                   40                                             40
2242746 MS     school 2802220 3200   JEFFERSON CO SCHOOL DIST 280222000426 3200004 JEFFERSON CO ELEM SCHOOL   Regular School No Elementary PK 04 2021   grade_1                                                   73                                             73
2242765 MS     school 2802250 3300   JEFFERSON DAVIS CO SCHOOL DIST 280225000430 3300004 CARVER ELEMENTARY SCHOOL   Regular School No Elementary KG 08 2021   grade_1                                                   40                                             40
2242782 MS     school 2802250 3300   JEFFERSON DAVIS CO SCHOOL DIST 280225000432 3300012 J E JOHNSON ELEMENTARY   Regular School No Elementary KG 08 2021   grade_1                                                   48                                             48
2242796 MS     school 2802280 3400   JONES CO SCHOOL DIST 280228000439 3400012 GLADE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_1                                                   59                                             59
2242807 MS     school 2802280 3400   JONES CO SCHOOL DIST 280228000441 3400016 MOSELLE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_1                                                   60                                             60
2242819 MS     school 2802280 3400   JONES CO SCHOOL DIST 280228000985 3400022 EAST JONES ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_1                                                   97                                             97
2242839 MS     school 2802280 3400   JONES CO SCHOOL DIST 280228001326 3400026 NORTH JONES ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_1                                                   110                                             110
2242851 MS     school 2802280 3400   JONES CO SCHOOL DIST 280228000986 3400034 SOUTH JONES ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_1                                                   134                                             134
2242869 MS     school 2802280 3400   JONES CO SCHOOL DIST 280228001237 3400050 WEST JONES ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_1                                                   126                                             126
2242886 MS     school 2802460 3420   LAUREL SCHOOL DISTRICT 280246000472 3420004 LAUREL MAGNET SCHOOL OF THE ARTS   Regular School No Elementary PK 05 2021   grade_1                                                   43                                             43
2242902 MS     school 2802460 3420   LAUREL SCHOOL DISTRICT 280246000476 3420020 MASON ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2021   grade_1                                                   76                                             76

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