enrollments

Data source: Big Local News · About: Big Local

824 rows where grade = "grade_1" and state = "MS" sorted by ccd_school_high_grade descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_1 · 824 ✖
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
2033720 2033720 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000050 500008 HICKORY FLAT ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_1                                                   43                                             43
2033828 2033828 MS     school 2800185 618   WEST BOLIVAR CONS SCHOOL DISTRICT 280018501402 618010 RAY BROOKS SCHOOL   Regular School No Other KG 12 2020   grade_1                                                   12                                             12
2033948 2033948 MS     school 2800960 900   CHICKASAW CO SCHOOL DIST 280096000108 900004 HOULKA ATTENDANCE CENTER   Regular School No Other PK 12 2020   grade_1                                                   38                                             38
2034257 2034257 MS     school 2801220 1500   COPIAH CO SCHOOL DIST 280122000169 1500012 WESSON ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_1                                                   54                                             54
2034324 2034324 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000181 1600020 MOUNT OLIVE ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_1                                                   29                                             29
2035774 2035774 MS     school 2801189 2560   MS SCH FOR THE BLIND AND DEAF 280118901504 2560002 MS SCHOOL FOR THE DEAF   Special Education School No Other KG 12 2020   grade_1                                                   *                                              
2035787 2035787 MS     school 2801189 2560   MS SCH FOR THE BLIND AND DEAF 280118901194 2560004 MS SCHOOL FOR THE BLIND   Special Education School No Other 01 12 2020   grade_1                                                   *                                              
2035898 2035898 MS     school 2802100 2900   ITAWAMBA CO SCHOOL DIST 280210000361 2900024 MANTACHIE ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_1                                                   90                                             90
2035914 2035914 MS     school 2802100 2900   ITAWAMBA CO SCHOOL DIST 280210000362 2900028 TREMONT ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_1                                                   16                                             16
2036219 2036219 MS     school 2804590 3112   WEST JASPER CONSOLIDATED SCHOOLS 280459000859 3112012 STRINGER ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_1                                                   44                                             44
2037064 2037064 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000512 4300004 BOGUE CHITTO SCHOOL   Regular School No Other KG 12 2020   grade_1                                                   46                                             46
2037078 2037078 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000513 4300008 ENTERPRISE SCHOOL   Regular School No Other KG 12 2020   grade_1                                                   55                                             55
2037093 2037093 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000515 4300016 LOYD STAR SCHOOL   Regular School No Other KG 12 2020   grade_1                                                   66                                             66
2037110 2037110 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000516 4300020 WEST LINCOLN SCHOOL   Regular School No Other KG 12 2020   grade_1                                                   52                                             52
2037597 2037597 MS     school 2802940 4800   MONROE CO SCHOOL DIST 280294000580 4800012 HAMILTON HIGH SCHOOL   Regular School No Other KG 12 2020   grade_1                                                   41                                             41
2037613 2037613 MS     school 2802940 4800   MONROE CO SCHOOL DIST 280294000581 4800016 HATLEY HIGH SCHOOL   Regular School No Other KG 12 2020   grade_1                                                   101                                             101
2037628 2037628 MS     school 2802940 4800   MONROE CO SCHOOL DIST 280294000582 4800020 SMITHVILLE HIGH SCHOOL   Regular School No Other KG 12 2020   grade_1                                                   41                                             41
2038215 2038215 MS     school 2803750 5900   PRENTISS CO SCHOOL DIST 280375000717 5900020 JUMPERTOWN HIGH SCHOOL   Regular School No Other PK 12 2020   grade_1                                                   19                                             19
2038249 2038249 MS     school 2803750 5900   PRENTISS CO SCHOOL DIST 280375000721 5900032 THRASHER HIGH SCHOOL   Regular School No Other PK 12 2020   grade_1                                                   40                                             40
2038265 2038265 MS     school 2803750 5900   PRENTISS CO SCHOOL DIST 280375000722 5900036 WHEELER HIGH SCHOOL   Regular School No Other KG 12 2020   grade_1                                                   39                                             39
2038580 2038580 MS     school 2803900 6200   SCOTT CO SCHOOL DIST 280390000748 6200016 SCOTT CENTRAL ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_1                                                   62                                             62
2038596 2038596 MS     school 2803900 6200   SCOTT CO SCHOOL DIST 280390000749 6200020 SEBASTOPOL ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_1                                                   51                                             51
2038710 2038710 MS     school 2804020 6500   SMITH CO SCHOOL DIST 280402000758 6500004 MIZE ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_1                                                   57                                             57
2038744 2038744 MS     school 2804020 6500   SMITH CO SCHOOL DIST 280402000762 6500012 TAYLORSVILLE ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_1                                                   57                                             57
2039002 2039002 MS     school 2803270 7011   NORTH TIPPAH SCHOOL DIST 280327000640 7011012 WALNUT ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_1                                                   44                                             44
2039019 2039019 MS     school 2804110 7012   SOUTH TIPPAH SCHOOL DIST 280411000775 7012004 BLUE MOUNTAIN HIGH SCHOOL   Regular School No Other PK 12 2020   grade_1                                                   23                                             23
2039034 2039034 MS     school 2804110 7012   SOUTH TIPPAH SCHOOL DIST 280411000776 7012008 PINE GROVE HIGH SCHOOL   Regular School No Other PK 12 2020   grade_1                                                   43                                             43
2039067 2039067 MS     school 2804260 7100   TISHOMINGO CO SP MUN SCH DIST 280426000803 7100004 BELMONT SCHOOL   Regular School No Other KG 12 2020   grade_1                                                   57                                             57
2039159 2039159 MS     school 2804350 7300   UNION CO SCHOOL DIST 280435000821 7300004 EAST UNION ATTENDANCE CENTER   Regular School No Other PK 12 2020   grade_1                                                   73                                             73
2039176 2039176 MS     school 2804350 7300   UNION CO SCHOOL DIST 280435000822 7300008 INGOMAR ATTENDANCE CENTER   Regular School No Other PK 12 2020   grade_1                                                   58                                             58
2039194 2039194 MS     school 2804350 7300   UNION CO SCHOOL DIST 280435000823 7300012 MYRTLE ATTENDANCE CENTER   Regular School No Other PK 12 2020   grade_1                                                   52                                             52
2039211 2039211 MS     school 2804350 7300   UNION CO SCHOOL DIST 280435000824 7300016 WEST UNION ATTENDANCE CENTER   Regular School No Other PK 12 2020   grade_1                                                   58                                             58
2039260 2039260 MS     school 2804440 7400   WALTHALL CO SCHOOL DIST 280444000834 7400008 SALEM ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_1                                                   31                                             31
2039694 2039694 MS     school 2802700 8020   LOUISVILLE MUNICIPAL SCHOOL DIST 280270000526 8020016 NANIH WAIYA ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_1                                                   36                                             36
2039709 2039709 MS     school 2802700 8020   LOUISVILLE MUNICIPAL SCHOOL DIST 280270000527 8020020 NOXAPATER ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_1                                                   22                                             22
2240272 2240272 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000050 500008 HICKORY FLAT ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_1                                                   35                                             35
2240378 2240378 MS     school 2800185 618   WEST BOLIVAR CONS SCHOOL DISTRICT 280018501527 618015 MCEVANS SCHOOL   Regular School No Other KG 12 2021   grade_1                                                   31                                             31
2240483 2240483 MS     school 2800960 900   CHICKASAW CO SCHOOL DIST 280096000108 900004 HOULKA ATTENDANCE CENTER   Regular School No Other PK 12 2021   grade_1                                                   34                                             34
2240795 2240795 MS     school 2801220 1500   COPIAH CO SCHOOL DIST 280122000169 1500012 WESSON ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_1                                                   52                                             52
2240859 2240859 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000181 1600020 MOUNT OLIVE ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_1                                                   24                                             24
2242286 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                                                   *                                              
2242410 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 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
2242730 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
2243567 2243567 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000512 4300004 BOGUE CHITTO SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   55                                             55
2243581 2243581 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000513 4300008 ENTERPRISE SCHOOL   Regular School No Other KG 12 2021   grade_1                                                   41                                             41
2243596 2243596 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000515 4300016 LOYD STAR SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   46                                             46
2243614 2243614 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000516 4300020 WEST LINCOLN SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   49                                             49
2244086 2244086 MS     school 2802940 4800   MONROE CO SCHOOL DIST 280294000580 4800012 HAMILTON HIGH SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   39                                             39
2244102 2244102 MS     school 2802940 4800   MONROE CO SCHOOL DIST 280294000581 4800016 HATLEY HIGH SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   65                                             65
2244117 2244117 MS     school 2802940 4800   MONROE CO SCHOOL DIST 280294000582 4800020 SMITHVILLE HIGH SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   33                                             33
2244703 2244703 MS     school 2803750 5900   PRENTISS CO SCHOOL DIST 280375000717 5900020 JUMPERTOWN HIGH SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   27                                             27
2244736 2244736 MS     school 2803750 5900   PRENTISS CO SCHOOL DIST 280375000721 5900032 THRASHER HIGH SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   28                                             28
2244752 2244752 MS     school 2803750 5900   PRENTISS CO SCHOOL DIST 280375000722 5900036 WHEELER HIGH SCHOOL   Regular School No Other KG 12 2021   grade_1                                                   36                                             36
2245069 2245069 MS     school 2803900 6200   SCOTT CO SCHOOL DIST 280390000748 6200016 SCOTT CENTRAL ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_1                                                   46                                             46
2245085 2245085 MS     school 2803900 6200   SCOTT CO SCHOOL DIST 280390000749 6200020 SEBASTOPOL ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_1                                                   34                                             34
2245198 2245198 MS     school 2804020 6500   SMITH CO SCHOOL DIST 280402000758 6500004 MIZE ATTENDANCE CENTER   Regular School No Other PK 12 2021   grade_1                                                   46                                             46
2245232 2245232 MS     school 2804020 6500   SMITH CO SCHOOL DIST 280402000762 6500012 TAYLORSVILLE ATTENDANCE CENTER   Regular School No Other PK 12 2021   grade_1                                                   58                                             58
2245474 2245474 MS     school 2803270 7011   NORTH TIPPAH SCHOOL DIST 280327001534 7011007 FALKNER ATTENDANCE CENTER   Regular School No Other PK 12 2021   grade_1                                                   45                                             45
2245490 2245490 MS     school 2803270 7011   NORTH TIPPAH SCHOOL DIST 280327000640 7011012 WALNUT ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_1                                                   25                                             25
2245507 2245507 MS     school 2804110 7012   SOUTH TIPPAH SCHOOL DIST 280411000775 7012004 BLUE MOUNTAIN HIGH SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   21                                             21
2245522 2245522 MS     school 2804110 7012   SOUTH TIPPAH SCHOOL DIST 280411000776 7012008 PINE GROVE HIGH SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   48                                             48
2245554 2245554 MS     school 2804260 7100   TISHOMINGO CO SP MUN SCH DIST 280426000803 7100004 BELMONT SCHOOL   Regular School No Other KG 12 2021   grade_1                                                   51                                             51
2245647 2245647 MS     school 2804350 7300   UNION CO SCHOOL DIST 280435000821 7300004 EAST UNION ATTENDANCE CENTER   Regular School No Other PK 12 2021   grade_1                                                   70                                             70
2245665 2245665 MS     school 2804350 7300   UNION CO SCHOOL DIST 280435000822 7300008 INGOMAR ATTENDANCE CENTER   Regular School No Other PK 12 2021   grade_1                                                   57                                             57
2245682 2245682 MS     school 2804350 7300   UNION CO SCHOOL DIST 280435000823 7300012 MYRTLE ATTENDANCE CENTER   Regular School No Other PK 12 2021   grade_1                                                   57                                             57
2245699 2245699 MS     school 2804350 7300   UNION CO SCHOOL DIST 280435000824 7300016 WEST UNION ATTENDANCE CENTER   Regular School No Other PK 12 2021   grade_1                                                   61                                             61
2245747 2245747 MS     school 2804440 7400   WALTHALL CO SCHOOL DIST 280444000834 7400008 SALEM ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_1                                                   25                                             25
2246184 2246184 MS     school 2802700 8020   LOUISVILLE MUNICIPAL SCHOOL DIST 280270000526 8020016 NANIH WAIYA ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_1                                                   37                                             37
2246200 2246200 MS     school 2802700 8020   LOUISVILLE MUNICIPAL SCHOOL DIST 280270000527 8020020 NOXAPATER ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_1                                                   24                                             24
2033844 2033844 MS     school 2800185 618   WEST BOLIVAR CONS SCHOOL DISTRICT 280018501409 618014 MCEVANS SCHOOL   Regular School No Elementary KG 08 2020   grade_1                                                   35                                             35
2034604 2034604 MS     school 2801490 1800   FORREST COUNTY SCHOOL DISTRICT 280149000216 1800008 DIXIE ATTENDANCE CENTER   Regular School No Elementary KG 08 2020   grade_1                                                   48                                             48
2034647 2034647 MS     school 2801490 1800   FORREST COUNTY SCHOOL DISTRICT 280149000220 1800028 SOUTH FORREST ATTENDANCE CENTER   Regular School No Elementary PK 08 2020   grade_1                                                   62                                             62
2034660 2034660 MS     school 2801490 1800   FORREST COUNTY SCHOOL DISTRICT 280149000221 1800036 EARL TRAVILLION ATTENDANCE CENTER   Regular School No Elementary KG 08 2020   grade_1                                                   31                                             31
2034865 2034865 MS     school 2801590 2100   GREENE COUNTY SCHOOL DISTRICT 280159000233 2100008 MC LAIN ELEMENTARY SCHOOL   Regular School No Elementary KG 08 2020   grade_1                                                   20                                             20
2034876 2034876 MS     school 2801590 2100   GREENE COUNTY SCHOOL DISTRICT 280159000234 2100012 SAND HILL ELEMENTARY SCHOOL   Regular School No Elementary KG 08 2020   grade_1                                                   32                                             32
2035052 2035052 MS     school 2801770 2400   HARRISON CO SCHOOL DIST 280177000958 2400038 NORTH WOOLMARKET ELEMENTARY AND MID   Regular School No Elementary KG 08 2020   grade_1                                                   72                                             72
2035098 2035098 MS     school 2801770 2400   HARRISON CO SCHOOL DIST 280177000959 2400051 WEST WORTHAM ELEMENTARY AND MIDDLE   Regular School No Elementary KG 08 2020   grade_1                                                   98                                             98
2035306 2035306 MS     school 2801860 2500   HINDS CO SCHOOL DIST 280186000326 2500028 UTICA ELEM. / MIDDLE SCHOOL   Regular School No Elementary PK 08 2020   grade_1                                                   31                                             31
2035340 2035340 MS     school 2801860 2500   HINDS CO SCHOOL DIST 280186000984 2500044 BOLTON-EDWARDS ELEM./MIDDLE SCHOOL   Regular School No Elementary PK 08 2020   grade_1                                                   41                                             41
2035834 2035834 MS     school 2800195 2611   HOLMES CONSOLIDATE SCHOOL DIST 280019501486 2611024 S V MARSHALL ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2020   grade_1                                                   48                                             48
2035865 2035865 MS     school 2802100 2900   ITAWAMBA CO SCHOOL DIST 280210000356 2900004 DORSEY ATTENDANCE CENTER   Regular School No Elementary KG 08 2020   grade_1                                                   36                                             36
2035875 2035875 MS     school 2802100 2900   ITAWAMBA CO SCHOOL DIST 280210000357 2900008 FAIRVIEW ATTENDANCE CENTER   Regular School No Elementary KG 08 2020   grade_1                                                   17                                             17
2035887 2035887 MS     school 2802100 2900   ITAWAMBA CO SCHOOL DIST 280210000358 2900012 ITAWAMBA ATTENDANCE CENTER   Regular School No Elementary KG 08 2020   grade_1                                                   100                                             100
2036254 2036254 MS     school 2802250 3300   JEFFERSON DAVIS CO SCHOOL DIST 280225000430 3300004 CARVER ELEMENTARY SCHOOL   Regular School No Elementary KG 08 2020   grade_1                                                   55                                             55
2036271 2036271 MS     school 2802250 3300   JEFFERSON DAVIS CO SCHOOL DIST 280225000432 3300012 J E JOHNSON ELEMENTARY   Regular School No Elementary KG 08 2020   grade_1                                                   63                                             63
2036491 2036491 MS     school 2802400 3700   LAMAR COUNTY SCHOOL DISTRICT 280240000464 3700004 BAXTERVILLE SCHOOL   Regular School No Elementary PK 08 2020   grade_1                                                   37                                             37
2036774 2036774 MS     school 2802490 3900   LAWRENCE CO SCHOOL DIST 280249000483 3900016 NEW HEBRON ATTENDANCE CENTER   Regular School No Elementary KG 08 2020   grade_1                                                   34                                             34
2036784 2036784 MS     school 2802490 3900   LAWRENCE CO SCHOOL DIST 280249000485 3900024 TOPEKA TILTON ATTENDANCE CENTER   Regular School No Elementary KG 08 2020   grade_1                                                   42                                             42
2037892 2037892 MS     school 2804050 5412   SOUTH PANOLA SCHOOL DISTRICT 280405000765 5412012 POPE ELEMENTARY SCHOOL   Regular School No Elementary KG 08 2020   grade_1                                                   55                                             55
2038203 2038203 MS     school 2803750 5900   PRENTISS CO SCHOOL DIST 280375000716 5900016 HILLS CHAPEL SCHOOL   Regular School No Elementary PK 08 2020   grade_1                                                   52                                             52
2038232 2038232 MS     school 2803750 5900   PRENTISS CO SCHOOL DIST 280375000718 5900024 MARIETTA ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2020   grade_1                                                   32                                             32
2038700 2038700 MS     school 2803990 6400   SIMPSON CO SCHOOL DIST 280399000757 6400020 SIMPSON CENTRAL SCHOOL   Regular School No Elementary KG 08 2020   grade_1                                                   67                                             67
2038812 2038812 MS     school 2800187 6711   SUNFLOWER CO CONSOLIDATE SCH DIST 280018701430 6711012 INVERNESS SCHOOL   Regular School No Elementary PK 08 2020   grade_1                                                   16                                             16
2038829 2038829 MS     school 2800187 6711   SUNFLOWER CO CONSOLIDATE SCH DIST 280018701498 6711018 MOORHEAD CENTRAL SCHOOL   Regular School No Elementary PK 08 2020   grade_1                                                   17                                             17
2038974 2038974 MS     school 2803270 7011   NORTH TIPPAH SCHOOL DIST 280327000637 7011004 CHALYBEATE ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2020   grade_1                                                   15                                             15
2039082 2039082 MS     school 2804260 7100   TISHOMINGO CO SP MUN SCH DIST 280426000804 7100008 BURNSVILLE ELEMENTARY   Regular School No Elementary KG 08 2020   grade_1                                                   45                                             45
2039092 2039092 MS     school 2804260 7100   TISHOMINGO CO SP MUN SCH DIST 280426000805 7100012 TISHOMINGO ELEMENTARY   Regular School No Elementary KG 08 2020   grade_1                                                   30                                             30
2039249 2039249 MS     school 2804440 7400   WALTHALL CO SCHOOL DIST 280444000833 7400004 DEXTER ELEMENTARY SCHOOL   Regular School No Elementary KG 08 2020   grade_1                                                   *                                              
2039533 2039533 MS     school 2804530 7700   WAYNE CO SCHOOL DIST 280453000846 7700004 BEAT FOUR ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2020   grade_1                                                   58                                             58

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