enrollments

Data source: Big Local News · About: Big Local

824 rows where grade = "grade_1" and state = "MS" sorted by ccd_school_lvl 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
2033485 2033485 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000600 130020 MC LAURIN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_1                                                   100                                             100
2033505 2033505 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000606 130040 JOSEPH L FRAZIER ELEMENTARY   Regular School No Elementary KG 05 2020   grade_1                                                   77                                             77
2033526 2033526 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000610 130056 SUSIE B WEST ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_1                                                   61                                             61
2033536 2033536 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000017 200002 BIGGERSVILLE ELEMENTARY   Regular School No Elementary PK 06 2020   grade_1                                                   44                                             44
2033556 2033556 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001150 200006 ALCORN CENTRAL ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   grade_1                                                   93                                             93
2033579 2033579 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001151 200022 KOSSUTH ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   grade_1                                                   104                                             104
2033602 2033602 MS     school 2801260 220   CORINTH SCHOOL DIST 280126001368 220002 CORINTH ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   grade_1                                                   221                                             221
2033631 2033631 MS     school 2800420 300   AMITE CO SCHOOL DIST 280042001375 300014 AMITE COUNTY ELEMENTARY   Regular School No Elementary KG 06 2020   grade_1                                                   72                                             72
2033649 2033649 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000037 400012 GREENLEE ATTENDANCE CENTER   Regular School No Elementary PK 06 2020   grade_1                                                   43                                             43
2033659 2033659 MS     school 2800510 400   ATTALA CO SCHOOL DIST 280051000038 400016 LONG CREEK ATTENDANCE CENTER   Regular School No Elementary PK 06 2020   grade_1                                                   33                                             33
2033684 2033684 MS     school 2802340 420   KOSCIUSKO SCHOOL DISTRICT 280234000458 420008 KOSCIUSKO LOWER ELEM   Regular School No Elementary PK 01 2020   grade_1                                                   159                                             159
2033702 2033702 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000048 500004 ASHLAND ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_1                                                   38                                             38
2033741 2033741 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000075 614004 BELL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_1                                                   47                                             47
2033760 2033760 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075001212 614020 HAYES COOPER CENTER FOR MATH SC TEC   Regular School No Elementary PK 06 2020   grade_1                                                   46                                             46
2033770 2033770 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000083 614024 NAILOR ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2020   grade_1                                                   101                                             101
2033776 2033776 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000084 614028 PARKS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_1                                                   28                                             28
2033783 2033783 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075000085 614032 PEARMAN ELEMENTARY SCHOOL   Regular School No Elementary 01 06 2020   grade_1                                                   26                                             26
2033791 2033791 MS     school 2800186 617   NORTH BOLIVAR CONS SCH 280018601416 617008 I T MONTGOMERY ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_1                                                   39                                             39
2033808 2033808 MS     school 2800186 617   NORTH BOLIVAR CONS SCH 280018601404 617014 BROOKS ELEM SCHOOL   Regular School No Elementary KG 06 2020   grade_1                                                   42                                             42
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
2033860 2033860 MS     school 2800185 618   WEST BOLIVAR CONS SCHOOL DISTRICT 280018501426 618020 WEST BOLIVAR ELEM   Regular School No Elementary KG 04 2020   grade_1                                                   33                                             33
2033869 2033869 MS     school 2800870 700   CALHOUN CO SCHOOL DIST 280087001102 700002 BRUCE ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   grade_1                                                   66                                             66
2033890 2033890 MS     school 2800870 700   CALHOUN CO SCHOOL DIST 280087001104 700008 CALHOUN CITY ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   grade_1                                                   58                                             58
2033909 2033909 MS     school 2800870 700   CALHOUN CO SCHOOL DIST 280087001106 700012 VARDAMAN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_1                                                   59                                             59
2033939 2033939 MS     school 2800930 800   CARROLL COUNTY SCHOOL DIST 280093000105 800008 MARSHALL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_1                                                   59                                             59
2033967 2033967 MS     school 2802010 920   HOUSTON SCHOOL DIST 280201000344 920004 HOUSTON LOWER ELEMENTARY   Regular School No Elementary PK 02 2020   grade_1                                                   138                                             138
2033988 2033988 MS     school 2803390 921   OKOLONA SEPARATE SCHOOL DIST 280339000653 921004 OKOLONA ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_1                                                   41                                             41
2034006 2034006 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000110 1000004 ACKERMAN ELEM   Regular School No Elementary PK 06 2020   grade_1                                                   52                                             52
2034023 2034023 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000113 1000012 FRENCH CAMP ELEM SCHOOL   Regular School No Elementary PK 06 2020   grade_1                                                   19                                             19
2034032 2034032 MS     school 2800990 1000   CHOCTAW CO SCHOOL DIST 280099000114 1000016 WEIR ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_1                                                   14                                             14

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