Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_2 · 623
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 ▼
2039477 MS     school 2801620 7620   GREENVILLE PUBLIC SCHOOLS 280162000237 7620008 ARMSTRONG ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   grade_2                                                   40                                             40
2240525 MS     school 2803390 921   OKOLONA SEPARATE SCHOOL DIST 280339000653 921004 OKOLONA ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2                                                   40                                             40
2242042 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000395 2520047 LAKE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2                                                   40                                             40
2244087 MS     school 2802940 4800   MONROE CO SCHOOL DIST 280294000580 4800012 HAMILTON HIGH SCHOOL   Regular School No Other PK 12 2021   grade_2                                                   40                                             40
2244499 MS     school 2803570 5600   PERRY CO SCHOOL DIST 280357000687 5600004 SOUTH PERRY ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2                                                   40                                             40
2035692 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000419 2520083 WATKINS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2                                                   41                                             41
2036097 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348000668 3022012 CENTRAL ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   grade_2                                                   41                                             41
2036220 MS     school 2804590 3112   WEST JASPER CONSOLIDATED SCHOOLS 280459000859 3112012 STRINGER ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_2                                                   41                                             41
2037292 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279001006 4500006 EAST FLORA ELEMENTARY   Regular School No Elementary PK 05 2020   grade_2                                                   41                                             41
2240379 MS     school 2800185 618   WEST BOLIVAR CONS SCHOOL DISTRICT 280018501527 618015 MCEVANS SCHOOL   Regular School No Other KG 12 2021   grade_2                                                   41                                             41
2241896 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219001052 2520004 BARACK H OBAMA ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2                                                   41                                             41
2242158 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000413 2520077 SMITH ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2                                                   41                                             41
2243764 MS     school 2801200 4420   COLUMBUS MUNICIPAL SCHOOL DIST 280120000164 4420056 SALE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2                                                   41                                             41
2245997 MS     school 2801620 7620   GREENVILLE PUBLIC SCHOOLS 280162000249 7620052 STERN ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2021   grade_2                                                   41                                             41
2246038 MS     school 2804530 7700   WAYNE CO SCHOOL DIST 280453000898 7700012 BUCKATUNNA ELEMENTARY SCHOOL   Regular School No Elementary KG 08 2021   grade_2                                                   41                                             41
2246143 MS     school 2804710 7900   WILKINSON CO SCHOOL DIST 280471001149 7900006 WILKINSON COUNTY ELEMENTARY   Regular School No Elementary PK 05 2021   grade_2                                                   41                                             41
2033784 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000085 614032 PEARMAN ELEMENTARY SCHOOL   Regular School No Elementary 01 06 2020   grade_2                                                   42                                             42
2036255 MS     school 2802250 3300   JEFFERSON DAVIS CO SCHOOL DIST 280225000430 3300004 CARVER ELEMENTARY SCHOOL   Regular School No Elementary KG 08 2020   grade_2                                                   42                                             42
2037270 MS     school 2801200 4420   COLUMBUS MUNICIPAL SCHOOL DIST 280120000164 4420056 SALE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2                                                   42                                             42
2039035 MS     school 2804110 7012   SOUTH TIPPAH SCHOOL DIST 280411000776 7012008 PINE GROVE HIGH SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   42                                             42
2244118 MS     school 2802940 4800   MONROE CO SCHOOL DIST 280294000582 4800020 SMITHVILLE HIGH SCHOOL   Regular School No Other PK 12 2021   grade_2                                                   42                                             42
2244421 MS     school 2803630 5520   PICAYUNE SCHOOL DIST 280363000694 5520008 NICHOLSON ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_2                                                   42                                             42
2244601 MS     school 2802880 5720   MCCOMB SCHOOL DISTRICT 280288001456 5720006 SUMMIT ELEMENTARY SCHOOL   Regular School No Elementary 01 06 2021   grade_2                                                   42                                             42
2245328 MS     school 2800187 6711   SUNFLOWER CO CONSOLIDATE SCH DIST 280018701428 6711024 RULEVILLE CENTRAL ELEM SCHOOL   Regular School No Elementary KG 05 2021   grade_2                                                   42                                             42
2246051 MS     school 2804530 7700   WAYNE CO SCHOOL DIST 280453000848 7700016 CLARA ELEMENTARY SCHOOL   Regular School No Elementary KG 08 2021   grade_2                                                   42                                             42
2035578 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219001242 2520057 MCWILLIE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2                                                   43                                             43
2039534 MS     school 2804530 7700   WAYNE CO SCHOOL DIST 280453000846 7700004 BEAT FOUR ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2020   grade_2                                                   43                                             43
2039643 MS     school 2804710 7900   WILKINSON CO SCHOOL DIST 280471000877 7900004 FINCH ELEMENTARY   Regular School No Elementary PK 05 2020   grade_2                                                   43                                             43
2039695 MS     school 2802700 8020   LOUISVILLE MUNICIPAL SCHOOL DIST 280270000526 8020016 NANIH WAIYA ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_2                                                   43                                             43
2241231 MS     school 2801800 1820   HATTIESBURG PUBLIC SCHOOL DIST 280180001570 1820038 HAWKINS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2                                                   43                                             43
2241985 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000388 2520036 GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2                                                   43                                             43
2242076 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000399 2520053 MARSHALL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2                                                   43                                             43
2243707 MS     school 2802730 4400   LOWNDES CO SCHOOL DIST 280273001177 4400028 WEST LOWNDES ELEMENTARY   Regular School No Elementary PK 06 2021   grade_2                                                   43                                             43
2243756 MS     school 2801200 4420   COLUMBUS MUNICIPAL SCHOOL DIST 280120000159 4420036 FRANKLIN ACADEMY   Regular School No Elementary PK 05 2021   grade_2                                                   43                                             43
2244050 MS     school 2802850 4700   MARSHALL CO SCHOOL DIST 280285001268 4700023 H. W. BYERS ELEMENTARY (K-4)   Regular School No Elementary KG 04 2021   grade_2                                                   43                                             43
2246075 MS     school 2804530 7700   WAYNE CO SCHOOL DIST 280453000849 7700024 WAYNE CENTRAL ELEMENTARY SCHOOL   Regular School No Elementary KG 08 2021   grade_2                                                   43                                             43
2035536 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000397 2520050 LEE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2                                                   44                                             44
2036113 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348000670 3022020 COLLEGE PARK ELEM   Regular School No Elementary PK 04 2020   grade_2                                                   44                                             44
2036585 MS     school 2802400 3700   LAMAR COUNTY SCHOOL DISTRICT 280240001487 3700024 LUMBERTON ELEMENTARY   Regular School No Elementary PK 05 2020   grade_2                                                   44                                             44
2037041 MS     school 2800198 4211   GREENWOOD-LEFLORE CONSOLIDATED SD 280019801519 4211021 LEFLORE COUNTY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2                                                   44                                             44
2038250 MS     school 2803750 5900   PRENTISS CO SCHOOL DIST 280375000721 5900032 THRASHER HIGH SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   44                                             44
2039400 MS     school 2801890 7611   HOLLANDALE SCHOOL DIST 280189000333 7611008 SANDERS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2                                                   44                                             44
2039654 MS     school 2804710 7900   WILKINSON CO SCHOOL DIST 280471001149 7900006 WILKINSON COUNTY ELEMENTARY   Regular School No Elementary PK 05 2020   grade_2                                                   44                                             44
2240295 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000075 614004 BELL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2                                                   44                                             44
2242018 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000393 2520042 JOHNSON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2                                                   44                                             44
2243615 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000516 4300020 WEST LINCOLN SCHOOL   Regular School No Other PK 12 2021   grade_2                                                   44                                             44
2245491 MS     school 2803270 7011   NORTH TIPPAH SCHOOL DIST 280327000640 7011012 WALNUT ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_2                                                   44                                             44
2245666 MS     school 2804350 7300   UNION CO SCHOOL DIST 280435000822 7300008 INGOMAR ATTENDANCE CENTER   Regular School No Other PK 12 2021   grade_2                                                   44                                             44
2245830 MS     school 2804470 7500   VICKSBURG WARREN SCHOOL DIST 280447000841 7500020 REDWOOD ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2                                                   44                                             44
2034198 MS     school 2801050 1420   CLARKSDALE MUNICIPAL SCHOOL DIST 280105000121 1420016 HEIDELBERG SCHOOL MATH & SCIENCE   Regular School No Elementary PK 04 2020   grade_2                                                   45                                             45
2035675 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000418 2520081 WALTON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2                                                   45                                             45
2242034 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000394 2520045 KEY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2                                                   45                                             45
2242887 MS     school 2802460 3420   LAUREL SCHOOL DISTRICT 280246000472 3420004 LAUREL MAGNET SCHOOL OF THE ARTS   Regular School No Elementary PK 05 2021   grade_2                                                   45                                             45
2245137 MS     school 2803960 6312   SOUTH DELTA SCHOOL DISTRICT 280396000752 6312004 SOUTH DELTA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2                                                   45                                             45
2245570 MS     school 2804260 7100   TISHOMINGO CO SP MUN SCH DIST 280426000804 7100008 BURNSVILLE ELEMENTARY   Regular School No Elementary KG 08 2021   grade_2                                                   45                                             45
2245683 MS     school 2804350 7300   UNION CO SCHOOL DIST 280435000823 7300012 MYRTLE ATTENDANCE CENTER   Regular School No Other PK 12 2021   grade_2                                                   45                                             45
2246004 MS     school 2801620 7620   GREENVILLE PUBLIC SCHOOLS 280162000250 7620056 TRIGG ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2021   grade_2                                                   45                                             45
2033761 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075001212 614020 HAYES COOPER CENTER FOR MATH SC TEC   Regular School No Elementary PK 06 2020   grade_2                                                   46                                             46
2035434 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000382 2520027 DAWSON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2                                                   46                                             46
2036148 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348000676 3022044 JACKSON ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2020   grade_2                                                   46                                             46
2038115 MS     school 2802880 5720   MCCOMB SCHOOL DISTRICT 280288001456 5720006 SUMMIT ELEMENTARY SCHOOL   Regular School No Elementary 01 06 2020   grade_2                                                   46                                             46
2039510 MS     school 2801620 7620   GREENVILLE PUBLIC SCHOOLS 280162000250 7620056 TRIGG ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   grade_2                                                   46                                             46
2240094 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000017 200002 BIGGERSVILLE ELEMENTARY   Regular School No Elementary PK 06 2021   grade_2                                                   46                                             46
2241607 MS     school 2801770 2400   HARRISON CO SCHOOL DIST 280177000297 2400048 SAUCIER ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_2                                                   46                                             46
2245376 MS     school 2804650 6812   WEST TALLAHATCHIE SCHOOL DISTRICT 280465000872 6812032 R H BEARDEN ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_2                                                   46                                             46
2245786 MS     school 2804470 7500   VICKSBURG WARREN SCHOOL DIST 280447001332 7500002 BOVINA ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2                                                   46                                             46
2246062 MS     school 2804530 7700   WAYNE CO SCHOOL DIST 280453000851 7700020 WAYNESBORO RIVERVIEW ELE SCHOOL   Regular School No Elementary KG 08 2021   grade_2                                                   46                                             46
2033742 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000075 614004 BELL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2                                                   47                                             47
2035457 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000388 2520036 GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2                                                   47                                             47
2035522 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000395 2520047 LAKE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2                                                   47                                             47
2038044 MS     school 2803870 5620   RICHTON SCHOOL DIST 280387001164 5620006 RICHTON ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_2                                                   47                                             47
2039083 MS     school 2804260 7100   TISHOMINGO CO SP MUN SCH DIST 280426000804 7100008 BURNSVILLE ELEMENTARY   Regular School No Elementary KG 08 2020   grade_2                                                   47                                             47
2039586 MS     school 2804530 7700   WAYNE CO SCHOOL DIST 280453000849 7700024 WAYNE CENTRAL ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2020   grade_2                                                   47                                             47
2241482 MS     school 2801740 2300   HANCOCK CO SCHOOL DIST 280174001338 2300014 WEST HANCOCK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2                                                   47                                             47
2242356 MS     school 2800195 2611   HOLMES CONSOLIDATE SCHOOL DIST 280019501486 2611024 S V MARSHALL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2                                                   47                                             47
2243190 MS     school 2802910 3820   MERIDIAN PUBLIC SCHOOL DIST 280291000560 3820008 CRESTWOOD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2                                                   47                                             47
2243568 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000512 4300004 BOGUE CHITTO SCHOOL   Regular School No Other PK 12 2021   grade_2                                                   47                                             47
2244469 MS     school 2803630 5520   PICAYUNE SCHOOL DIST 280363000700 5520028 WEST SIDE ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_2                                                   47                                             47
2244991 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383001424 6100054 PUCKETT ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2                                                   47                                             47
2034233 MS     school 2800194 1425   CLARKSDALE COLLEGIATE 280019401492 1425004 CLARKSDALE COLLEGIATE   Regular School Yes Elementary KG 03 2020   grade_2                                                   48                                             48
2034605 MS     school 2801490 1800   FORREST COUNTY SCHOOL DISTRICT 280149000216 1800008 DIXIE ATTENDANCE CENTER   Regular School No Elementary KG 08 2020   grade_2                                                   48                                             48
2035425 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000381 2520024 CLAUSELL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2                                                   48                                             48
2035835 MS     school 2800195 2611   HOLMES CONSOLIDATE SCHOOL DIST 280019501486 2611024 S V MARSHALL ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2020   grade_2                                                   48                                             48
2037111 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000516 4300020 WEST LINCOLN SCHOOL   Regular School No Other KG 12 2020   grade_2                                                   48                                             48
2038889 MS     school 2804650 6812   WEST TALLAHATCHIE SCHOOL DISTRICT 280465000872 6812032 R H BEARDEN ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_2                                                   48                                             48
2039361 MS     school 2804470 7500   VICKSBURG WARREN SCHOOL DIST 280447001094 7500024 SOUTH PARK ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2                                                   48                                             48
2242001 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000392 2520040 JOHN HOPKINS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2                                                   48                                             48
2242121 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000404 2520061 OAK FOREST ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2                                                   48                                             48
2244383 MS     school 2804050 5412   SOUTH PANOLA SCHOOL DISTRICT 280405000765 5412012 POPE ELEMENTARY SCHOOL   Regular School No Elementary KG 08 2021   grade_2                                                   48                                             48
2033989 MS     school 2803390 921   OKOLONA SEPARATE SCHOOL DIST 280339000653 921004 OKOLONA ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_2                                                   49                                             49
2037981 MS     school 2803630 5520   PICAYUNE SCHOOL DIST 280363000700 5520028 WEST SIDE ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_2                                                   49                                             49
2038204 MS     school 2803750 5900   PRENTISS CO SCHOOL DIST 280375000716 5900016 HILLS CHAPEL SCHOOL   Regular School No Elementary PK 08 2020   grade_2                                                   49                                             49
2240084 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000610 130056 SUSIE B WEST ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2                                                   49                                             49
2240741 MS     school 2801050 1420   CLARKSDALE MUNICIPAL SCHOOL DIST 280105000122 1420020 KIRKPATRICK HEALTH /WELLNESS   Regular School No Elementary PK 04 2021   grade_2                                                   49                                             49
2241219 MS     school 2801800 1820   HATTIESBURG PUBLIC SCHOOL DIST 280180000302 1820020 GRACE CHRISTIAN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2                                                   49                                             49
2241710 MS     school 2801710 2421   GULFPORT SCHOOL DIST 280171000271 2421014 CENTRAL ELEM   Regular School No Elementary PK 05 2021   grade_2                                                   49                                             49
2245853 MS     school 2804470 7500   VICKSBURG WARREN SCHOOL DIST 280447001094 7500024 SOUTH PARK ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2                                                   49                                             49
2245884 MS     school 2804470 7500   VICKSBURG WARREN SCHOOL DIST 280447000844 7500032 WARRENTON ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2                                                   49                                             49
2035628 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000410 2520069 RAINES ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2                                                   50                                             50
2036124 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348000672 3022028 EASTLAWN ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   grade_2                                                   50                                             50

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