Data source: Big Local News · About: Big Local

402 rows where grade = "kindergarten", state = "MS" and year = 2021 sorted by school

View and edit SQL

year

  • 2021 · 402

grade

  • kindergarten · 402
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
2245289 MS     school 2800187 6711   SUNFLOWER CO CONSOLIDATE SCH DIST 280018701410 6711010 A W JAMES ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   kindergarten                                                   34                                             34
2240576 MS     school 2801020 1100   CLAIBORNE CO SCHOOL DIST 280102001213 1100002 A. W. WATSON ELEMENTARY   Regular School No Elementary PK 05 2021   kindergarten                                                   85                                             85
2244131 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036001372 4820006 ABERDEEN ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2021   kindergarten                                                   *                                              
2240540 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000110 1000004 ACKERMAN ELEM   Regular School No Elementary PK 06 2021   kindergarten                                                   63                                             63
2241314 MS     school 2801560 2000   GEORGE CO SCHOOL DIST 280156000226 2000004 AGRICOLA ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   kindergarten                                                   75                                             75
2240109 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001150 200006 ALCORN CENTRAL ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2021   kindergarten                                                   87                                             87
2240185 MS     school 2800420 300   AMITE CO SCHOOL DIST 280042001375 300014 AMITE COUNTY ELEMENTARY   Regular School No Elementary KG 06 2021   kindergarten                                                   49                                             49
2244799 MS     school 2800820 5921   BOONEVILLE SCHOOL DIST 280082001025 5921016 ANDERSON ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2021   kindergarten                                                   95                                             95
2243822 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279001081 4500024 ANN SMITH ELEMENTARY   Regular School No Elementary PK 02 2021   kindergarten                                                   211                                             211
2241688 MS     school 2801710 2421   GULFPORT SCHOOL DIST 280171000268 2421004 ANNISTON AVENUE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   kindergarten                                                   89                                             89
2242588 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348000666 3022004 ARLINGTON HEIGHTS ELEM SCHOOL   Regular School No Elementary PK 04 2021   kindergarten                                                   43                                             43
2240253 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000048 500004 ASHLAND ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   kindergarten                                                   41                                             41
2242279 MS     school 2800197 2545   AMBITION PREPARATORY 280019701510 2545004 Ambition Preparatory Charter School   Regular School Yes Elementary KG 02 2021   kindergarten                                                   82                                             82
2241906 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000370 2520007 BAKER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   kindergarten                                                   35                                             35
2244766 MS     school 2800540 5920   BALDWYN SCHOOL DISTRICT 280054000041 5920004 BALDWYN ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2021   kindergarten                                                   64                                             64
2243487 MS     school 2800198 4211   GREENWOOD-LEFLORE CONSOLIDATED SD 280019801511 4211003 BANKSTON ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   kindergarten                                                   29                                             29
2241894 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219001052 2520004 BARACK H OBAMA ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   kindergarten                                                   41                                             41
2242023 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219001364 2520043 BATES ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   kindergarten                                                   52                                             52
2244367 MS     school 2804050 5412   SOUTH PANOLA SCHOOL DISTRICT 280405000763 5412004 BATESVILLE ELEMENTARY SCHOOL   Regular School No Elementary PK 01 2021   kindergarten                                                   273                                             273
2242993 MS     school 2802400 3700   LAMAR COUNTY SCHOOL DISTRICT 280240000464 3700004 BAXTERVILLE SCHOOL   Regular School No Elementary PK 08 2021   kindergarten                                                   29                                             29
2242709 MS     school 2804590 3112   WEST JASPER CONSOLIDATED SCHOOLS 280459000858 3112004 BAY SPRINGS ELEM SCH   Regular School No Elementary KG 05 2021   kindergarten                                                   67                                             67
2241695 MS     school 2801710 2421   GULFPORT SCHOOL DIST 280171000269 2421008 BAYOU VIEW ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   kindergarten                                                   120                                             120
2242594 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348000667 3022008 BEACH ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2021   kindergarten                                                   21                                             21
2246023 MS     school 2804530 7700   WAYNE CO SCHOOL DIST 280453000846 7700004 BEAT FOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 08 2021   kindergarten                                                   41                                             41
2245803 MS     school 2804470 7500   VICKSBURG WARREN SCHOOL DIST 280447001186 7500006 BEECHWOOD ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   kindergarten                                                   66                                             66
2241509 MS     school 2801770 2400   HARRISON CO SCHOOL DIST 280177000283 2400002 BEL AIRE ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   kindergarten                                                   67                                             67
2240293 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000075 614004 BELL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   kindergarten                                                   47                                             47
2245553 MS     school 2804260 7100   TISHOMINGO CO SP MUN SCH DIST 280426000803 7100004 BELMONT SCHOOL   Regular School No Other KG 12 2021   kindergarten                                                   70                                             70
2241324 MS     school 2801560 2000   GEORGE CO SCHOOL DIST 280156000981 2000006 BENNDALE ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   kindergarten                                                   20                                             20
2246262 MS     school 2804800 8200   YAZOO CO SCHOOL DIST 280480000891 8200008 BENTONIA GIBBS SCHOOL   Regular School No Elementary PK 05 2021   kindergarten                                                   52                                             52
2240090 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000017 200002 BIGGERSVILLE ELEMENTARY   Regular School No Elementary PK 06 2021   kindergarten                                                   44                                             44
2245506 MS     school 2804110 7012   SOUTH TIPPAH SCHOOL DIST 280411000775 7012004 BLUE MOUNTAIN HIGH SCHOOL   Regular School No Other PK 12 2021   kindergarten                                                   28                                             28
2243566 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000512 4300004 BOGUE CHITTO SCHOOL   Regular School No Other PK 12 2021   kindergarten                                                   46                                             46
2241872 MS     school 2801860 2500   HINDS CO SCHOOL DIST 280186000984 2500044 BOLTON-EDWARDS ELEM./MIDDLE SCHOOL   Regular School No Elementary PK 08 2021   kindergarten                                                   33                                             33
2240760 MS     school 2801050 1420   CLARKSDALE MUNICIPAL SCHOOL DIST 280105000128 1420040 BOOKER T WASHINGTON INTERN. STUDIES   Regular School No Elementary PK 04 2021   kindergarten                                                   29                                             29
2245784 MS     school 2804470 7500   VICKSBURG WARREN SCHOOL DIST 280447001332 7500002 BOVINA ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   kindergarten                                                   57                                             57
2245792 MS     school 2804470 7500   VICKSBURG WARREN SCHOOL DIST 280447000826 7500004 BOWMAR AVENUE SCHOOL   Regular School No Elementary KG 06 2021   kindergarten                                                   47                                             47
2241918 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000373 2520011 BOYD ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   kindergarten                                                   *                                              
2242967 MS     school 2803450 3620   OXFORD SCHOOL DISTRICT 280345000661 3620004 BRAMLETT ELEMENTARY SCHOOL   Regular School No Elementary PK KG 2021   kindergarten                                                   337                                             337
2240359 MS     school 2800186 617   NORTH BOLIVAR CONS SCH 280018601404 617014 BROOKS ELEM SCHOOL   Regular School No Elementary KG 06 2021   kindergarten                                                   *                                              
2240403 MS     school 2800870 700   CALHOUN CO SCHOOL DIST 280087001102 700002 BRUCE ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2021   kindergarten                                                   63                                             63
2246035 MS     school 2804530 7700   WAYNE CO SCHOOL DIST 280453000898 7700012 BUCKATUNNA ELEMENTARY SCHOOL   Regular School No Elementary KG 08 2021   kindergarten                                                   *                                              
2245568 MS     school 2804260 7100   TISHOMINGO CO SP MUN SCH DIST 280426000804 7100008 BURNSVILLE ELEMENTARY   Regular School No Elementary KG 08 2021   kindergarten                                                   59                                             59
2244016 MS     school 2802850 4700   MARSHALL CO SCHOOL DIST 280285000550 4700012 BYHALIA ELEMENTARY SCHOOL (K-4)   Regular School No Elementary KG 04 2021   kindergarten                                                   90                                             90
2243655 MS     school 2802730 4400   LOWNDES CO SCHOOL DIST 280273000528 4400002 CALEDONIA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   kindergarten                                                   157                                             157
2240424 MS     school 2800870 700   CALHOUN CO SCHOOL DIST 280087001104 700008 CALHOUN CITY ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2021   kindergarten                                                   48                                             48
2243791 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279000988 4500010 CAMDEN ELEMENTARY   Regular School No Elementary PK 05 2021   kindergarten                                                   23                                             23
2243892 MS     school 2800900 4520   CANTON PUBLIC SCHOOL DIST 280090000100 4520004 CANTON ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   kindergarten                                                   65                                             65
2242764 MS     school 2802250 3300   JEFFERSON DAVIS CO SCHOOL DIST 280225000430 3300004 CARVER ELEMENTARY SCHOOL   Regular School No Elementary KG 08 2021   kindergarten                                                   41                                             41
2243428 MS     school 2804320 4120   TUPELO PUBLIC SCHOOL DIST 280432001001 4120007 CARVER ELEMENTARY SCHOOL   Regular School No Elementary KG 01 2021   kindergarten                                                   142                                             142
2241937 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000379 2520020 CASEY ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   kindergarten                                                   *                                              
2240896 MS     school 2801320 1700   DESOTO CO SCHOOL DIST 280132001018 1700010 CENTER HILL ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   kindergarten                                                   111                                             111
2241708 MS     school 2801710 2421   GULFPORT SCHOOL DIST 280171000271 2421014 CENTRAL ELEM   Regular School No Elementary PK 05 2021   kindergarten                                                   70                                             70
2241336 MS     school 2801560 2000   GEORGE CO SCHOOL DIST 280156000227 2000008 CENTRAL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   kindergarten                                                   76                                             76
2242602 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348000668 3022012 CENTRAL ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2021   kindergarten                                                   25                                             25
2245460 MS     school 2803270 7011   NORTH TIPPAH SCHOOL DIST 280327000637 7011004 CHALYBEATE ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2021   kindergarten                                                   33                                             33
2245354 MS     school 2801410 6811   EAST TALLAHATCHIE CONSOL SCH DIST 280141000206 6811004 CHARLESTON ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2021   kindergarten                                                   63                                             63
2242609 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348000669 3022016 CHEROKEE ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2021   kindergarten                                                   37                                             37
2246047 MS     school 2804530 7700   WAYNE CO SCHOOL DIST 280453000848 7700016 CLARA ELEMENTARY SCHOOL   Regular School No Elementary KG 08 2021   kindergarten                                                   54                                             54
2243101 MS     school 2802430 3800   LAUDERDALE CO SCHOOL DIST 280243001362 3800002 CLARKDALE ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   kindergarten                                                   66                                             66
2240768 MS     school 2800194 1425   CLARKSDALE COLLEGIATE 280019401492 1425004 CLARKSDALE COLLEGIATE   Regular School Yes Elementary KG 04 2021   kindergarten                                                   77                                             77
2243549 MS     school 2800198 4211   GREENWOOD-LEFLORE CONSOLIDATED SD 280019801520 4211022 CLAUDINE F BROWN ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2021   kindergarten                                                   75                                             75
2241951 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000381 2520024 CLAUSELL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   kindergarten                                                   38                                             38
2242251 MS     school 2801090 2521   CLINTON PUBLIC SCHOOL DIST 280109000133 2521012 CLINTON PARK ELEM SCHOOL   Regular School No Elementary PK 01 2021   kindergarten                                                   362                                             362
2246215 MS     school 2801140 8111   COFFEEVILLE SCHOOL DIST 280114001108 8111004 COFFEEVILLE ELEMENTARY SCHOOL   Regular School No Elementary PK 07 2021   kindergarten                                                   27                                             27
2245390 MS     school 2804230 6900   TATE CO SCHOOL DIST 280423001499 6900003 COLDWATER ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   kindergarten                                                   *                                              
2242617 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348000670 3022020 COLLEGE PARK ELEM   Regular School No Elementary PK 04 2021   kindergarten                                                   48                                             48
2240828 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000176 1600004 COLLINS ELEMENTARY   Regular School No Elementary KG 04 2021   kindergarten                                                   68                                             68
2243993 MS     school 2801170 4620   COLUMBIA SCHOOL DISTRICT 280117000150 4620012 COLUMBIA PRIMARY SCHOOL   Regular School No Elementary PK 02 2021   kindergarten                                                   122                                             122
2244348 MS     school 2803210 5411   NORTH PANOLA SCHOOLS 280321000627 5411004 COMO PRIMARY   Regular School No Elementary PK 02 2021   kindergarten                                                   74                                             74
2243736 MS     school 2801200 4420   COLUMBUS MUNICIPAL SCHOOL DIST 280120000156 4420024 COOK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   kindergarten                                                   59                                             59
2240155 MS     school 2801260 220   CORINTH SCHOOL DIST 280126001368 220002 CORINTH ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2021   kindergarten                                                   183                                             183
2243188 MS     school 2802910 3820   MERIDIAN PUBLIC SCHOOL DIST 280291000560 3820008 CRESTWOOD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   kindergarten                                                   44                                             44
2241528 MS     school 2801770 2400   HARRISON CO SCHOOL DIST 280177001351 2400005 CROSSROADS ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   kindergarten                                                   72                                             72
2240781 MS     school 2801220 1500   COPIAH CO SCHOOL DIST 280122001189 1500006 CRYSTAL SPRINGS ELEMENTARY   Regular School No Elementary PK 03 2021   kindergarten                                                   107                                             107
2245815 MS     school 2804470 7500   VICKSBURG WARREN SCHOOL DIST 280447000993 7500014 DANA ROAD ELEMENTARY   Regular School No Elementary PK 02 2021   kindergarten                                                   110                                             110
2246241 MS     school 2804500 8113   WATER VALLEY SCHOOL DISTRICT 280450001095 8113008 DAVIDSON ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   kindergarten                                                   86                                             86
2243507 MS     school 2800198 4211   GREENWOOD-LEFLORE CONSOLIDATED SD 280019801514 4211008 DAVIS ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   kindergarten                                                   46                                             46
2241960 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000382 2520027 DAWSON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   kindergarten                                                   19                                             19
2241779 MS     school 2803510 2423   PASS CHRISTIAN PUBLIC SCHOOL DIST 280351000682 2423004 DELISLE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   kindergarten                                                   84                                             84
2241039 MS     school 2801320 1700   DESOTO CO SCHOOL DIST 280132001369 1700051 DESOTO CENTRAL PRIMARY   Regular School No Elementary KG 02 2021   kindergarten                                                   222                                             222
2245734 MS     school 2804440 7400   WALTHALL CO SCHOOL DIST 280444000833 7400004 DEXTER ELEMENTARY SCHOOL   Regular School No Elementary KG 08 2021   kindergarten                                                   11                                             11
2241517 MS     school 2801770 2400   HARRISON CO SCHOOL DIST 280177000284 2400003 DIBERVILLE ELEM   Regular School No Elementary KG 03 2021   kindergarten                                                   139                                             139
2241133 MS     school 2801490 1800   FORREST COUNTY SCHOOL DISTRICT 280149000216 1800008 DIXIE ATTENDANCE CENTER   Regular School No Elementary KG 08 2021   kindergarten                                                   47                                             47
2242380 MS     school 2802100 2900   ITAWAMBA CO SCHOOL DIST 280210000356 2900004 DORSEY ATTENDANCE CENTER   Regular School No Elementary KG 06 2021   kindergarten                                                   34                                             34
2245635 MS     school 2804290 7200   TUNICA COUNTY SCHOOL DISTRICT 280429000974 7200014 DUNDEE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   kindergarten                                                   19                                             19
2242320 MS     school 2800195 2611   HOLMES CONSOLIDATE SCHOOL DIST 280019501495 2611004 DURANT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   kindergarten                                                   45                                             45
2244290 MS     school 2803300 5200   NOXUBEE COUNTY SCHOOL DISTRICT 280330000641 5200008 EARL NASH ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   kindergarten                                                   85                                             85
2241190 MS     school 2801490 1800   FORREST COUNTY SCHOOL DISTRICT 280149000221 1800036 EARL TRAVILLION ATTENDANCE CENTER   Regular School No Elementary KG 08 2021   kindergarten                                                   33                                             33
2242508 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216000962 3000022 EAST CENTRAL LOWER ELEMENTARY   Regular School No Elementary PK 02 2021   kindergarten                                                   160                                             160
2243782 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279001006 4500006 EAST FLORA ELEMENTARY   Regular School No Elementary PK 05 2021   kindergarten                                                   39                                             39
2241455 MS     school 2801740 2300   HANCOCK CO SCHOOL DIST 280174000982 2300005 EAST HANCOCK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   kindergarten                                                   102                                             102
2242816 MS     school 2802280 3400   JONES CO SCHOOL DIST 280228000985 3400022 EAST JONES ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   kindergarten                                                   116                                             116
2243946 MS     school 2802820 4600   MARION CO SCHOOL DIST 280282001243 4600002 EAST MARION ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   kindergarten                                                   35                                             35
2240645 MS     school 2800191 1321   WEST POINT CONSOLIDATED SCHOOL DIST 280019101443 1321008 EAST SIDE ELEMENTARY SCHOOL   Regular School No Elementary PK KG 2021   kindergarten                                                   165                                             165
2245281 MS     school 2800187 6711   SUNFLOWER CO CONSOLIDATE SCH DIST 280018701418 6711008 EAST SUNFLOWER SCHOOL   Regular School No Elementary KG 05 2021   kindergarten                                                   17                                             17
2245399 MS     school 2804230 6900   TATE CO SCHOOL DIST 280423000799 6900008 EAST TATE ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   kindergarten                                                   71                                             71
2245644 MS     school 2804350 7300   UNION CO SCHOOL DIST 280435000821 7300004 EAST UNION ATTENDANCE CENTER   Regular School No Other PK 12 2021   kindergarten                                                   83                                             83
2246119 MS     school 2804560 7800   WEBSTER CO SCHOOL DIST 280456000855 7800016 EAST WEBSTER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   kindergarten                                                   66                                             66
2242629 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348000672 3022028 EASTLAWN ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2021   kindergarten                                                   45                                             45

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