enrollments

Data source: Big Local News · About: Big Local

549 rows where grade = "grade_8" and state = "MS" sorted by ccd_school_lvl descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_8 · 549 ✖
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
2241810 2241810 MS     school 2800183 2480   ROGER AMOS MCMURTRY ADM 280018301317 2480004 ROGER AMOS MCMURTRY SCHOOL   Regular School No Secondary 06 11 2021   grade_8                                                   *                                              
2244331 2244331 MS     school 2800189 5321   STARKVILLE- OKTIBBEHA CONS SD 280018901453 5321020 ARMSTRONG JUNIOR HIGH SCHOOL   Regular School No Secondary 08 09 2021   grade_8                                                   378                                             378
2033727 2033727 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000050 500008 HICKORY FLAT ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_8                                                   38                                             38
2033835 2033835 MS     school 2800185 618   WEST BOLIVAR CONS SCHOOL DISTRICT 280018501402 618010 RAY BROOKS SCHOOL   Regular School No Other KG 12 2020   grade_8                                                   12                                             12
2033955 2033955 MS     school 2800960 900   CHICKASAW CO SCHOOL DIST 280096000108 900004 HOULKA ATTENDANCE CENTER   Regular School No Other PK 12 2020   grade_8                                                   38                                             38
2034264 2034264 MS     school 2801220 1500   COPIAH CO SCHOOL DIST 280122000169 1500012 WESSON ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_8                                                   78                                             78
2034331 2034331 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000181 1600020 MOUNT OLIVE ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_8                                                   35                                             35
2035781 2035781 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_8                                                   *                                              
2035794 2035794 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_8                                                   *                                              
2035905 2035905 MS     school 2802100 2900   ITAWAMBA CO SCHOOL DIST 280210000361 2900024 MANTACHIE ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_8                                                   88                                             88
2035921 2035921 MS     school 2802100 2900   ITAWAMBA CO SCHOOL DIST 280210000362 2900028 TREMONT ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_8                                                   33                                             33
2036226 2036226 MS     school 2804590 3112   WEST JASPER CONSOLIDATED SCHOOLS 280459000859 3112012 STRINGER ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_8                                                   62                                             62
2037071 2037071 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000512 4300004 BOGUE CHITTO SCHOOL   Regular School No Other KG 12 2020   grade_8                                                   58                                             58
2037085 2037085 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000513 4300008 ENTERPRISE SCHOOL   Regular School No Other KG 12 2020   grade_8                                                   47                                             47
2037100 2037100 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000515 4300016 LOYD STAR SCHOOL   Regular School No Other KG 12 2020   grade_8                                                   64                                             64
2037117 2037117 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000516 4300020 WEST LINCOLN SCHOOL   Regular School No Other KG 12 2020   grade_8                                                   58                                             58
2037604 2037604 MS     school 2802940 4800   MONROE CO SCHOOL DIST 280294000580 4800012 HAMILTON HIGH SCHOOL   Regular School No Other KG 12 2020   grade_8                                                   52                                             52
2037620 2037620 MS     school 2802940 4800   MONROE CO SCHOOL DIST 280294000581 4800016 HATLEY HIGH SCHOOL   Regular School No Other KG 12 2020   grade_8                                                   76                                             76
2037635 2037635 MS     school 2802940 4800   MONROE CO SCHOOL DIST 280294000582 4800020 SMITHVILLE HIGH SCHOOL   Regular School No Other KG 12 2020   grade_8                                                   51                                             51
2037754 2037754 MS     school 2803150 5100   NEWTON COUNTY SCHOOL DISTRICT 280315001135 5100012 NEWTON COUNTY HIGH SCHOOL   Regular School No Other 01 12 2020   grade_8                                                   139                                             139
2038222 2038222 MS     school 2803750 5900   PRENTISS CO SCHOOL DIST 280375000717 5900020 JUMPERTOWN HIGH SCHOOL   Regular School No Other PK 12 2020   grade_8                                                   21                                             21
2038256 2038256 MS     school 2803750 5900   PRENTISS CO SCHOOL DIST 280375000721 5900032 THRASHER HIGH SCHOOL   Regular School No Other PK 12 2020   grade_8                                                   23                                             23
2038272 2038272 MS     school 2803750 5900   PRENTISS CO SCHOOL DIST 280375000722 5900036 WHEELER HIGH SCHOOL   Regular School No Other KG 12 2020   grade_8                                                   44                                             44
2038587 2038587 MS     school 2803900 6200   SCOTT CO SCHOOL DIST 280390000748 6200016 SCOTT CENTRAL ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_8                                                   72                                             72
2038603 2038603 MS     school 2803900 6200   SCOTT CO SCHOOL DIST 280390000749 6200020 SEBASTOPOL ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_8                                                   48                                             48
2038717 2038717 MS     school 2804020 6500   SMITH CO SCHOOL DIST 280402000758 6500004 MIZE ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_8                                                   59                                             59
2038751 2038751 MS     school 2804020 6500   SMITH CO SCHOOL DIST 280402000762 6500012 TAYLORSVILLE ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_8                                                   45                                             45
2039009 2039009 MS     school 2803270 7011   NORTH TIPPAH SCHOOL DIST 280327000640 7011012 WALNUT ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_8                                                   *                                              
2039026 2039026 MS     school 2804110 7012   SOUTH TIPPAH SCHOOL DIST 280411000775 7012004 BLUE MOUNTAIN HIGH SCHOOL   Regular School No Other PK 12 2020   grade_8                                                   31                                             31
2039041 2039041 MS     school 2804110 7012   SOUTH TIPPAH SCHOOL DIST 280411000776 7012008 PINE GROVE HIGH SCHOOL   Regular School No Other PK 12 2020   grade_8                                                   63                                             63
2039074 2039074 MS     school 2804260 7100   TISHOMINGO CO SP MUN SCH DIST 280426000803 7100004 BELMONT SCHOOL   Regular School No Other KG 12 2020   grade_8                                                   57                                             57
2039166 2039166 MS     school 2804350 7300   UNION CO SCHOOL DIST 280435000821 7300004 EAST UNION ATTENDANCE CENTER   Regular School No Other PK 12 2020   grade_8                                                   58                                             58
2039183 2039183 MS     school 2804350 7300   UNION CO SCHOOL DIST 280435000822 7300008 INGOMAR ATTENDANCE CENTER   Regular School No Other PK 12 2020   grade_8                                                   52                                             52
2039201 2039201 MS     school 2804350 7300   UNION CO SCHOOL DIST 280435000823 7300012 MYRTLE ATTENDANCE CENTER   Regular School No Other PK 12 2020   grade_8                                                   56                                             56
2039218 2039218 MS     school 2804350 7300   UNION CO SCHOOL DIST 280435000824 7300016 WEST UNION ATTENDANCE CENTER   Regular School No Other PK 12 2020   grade_8                                                   49                                             49
2039267 2039267 MS     school 2804440 7400   WALTHALL CO SCHOOL DIST 280444000834 7400008 SALEM ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_8                                                   50                                             50
2039701 2039701 MS     school 2802700 8020   LOUISVILLE MUNICIPAL SCHOOL DIST 280270000526 8020016 NANIH WAIYA ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_8                                                   42                                             42
2039716 2039716 MS     school 2802700 8020   LOUISVILLE MUNICIPAL SCHOOL DIST 280270000527 8020020 NOXAPATER ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_8                                                   22                                             22
2240279 2240279 MS     school 2800600 500   BENTON CO SCHOOL DIST 280060000050 500008 HICKORY FLAT ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_8                                                   45                                             45
2240385 2240385 MS     school 2800185 618   WEST BOLIVAR CONS SCHOOL DISTRICT 280018501527 618015 MCEVANS SCHOOL   Regular School No Other KG 12 2021   grade_8                                                   36                                             36
2240490 2240490 MS     school 2800960 900   CHICKASAW CO SCHOOL DIST 280096000108 900004 HOULKA ATTENDANCE CENTER   Regular School No Other PK 12 2021   grade_8                                                   51                                             51
2240802 2240802 MS     school 2801220 1500   COPIAH CO SCHOOL DIST 280122000169 1500012 WESSON ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_8                                                   81                                             81
2240866 2240866 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000181 1600020 MOUNT OLIVE ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_8                                                   29                                             29
2242293 2242293 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_8                                                   *                                              
2242305 2242305 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 2021   grade_8                                                   *                                              
2242314 2242314 MS     school 2801191 2562   MDHS DIVISION OF YOUTH SERVICES 280119101197 2562008 WILLIAMS SCHOOL   Regular School No Other 04 12 2021   grade_8                                                   *                                              
2242417 2242417 MS     school 2802100 2900   ITAWAMBA CO SCHOOL DIST 280210000361 2900024 MANTACHIE ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_8                                                   100                                             100
2242432 2242432 MS     school 2802100 2900   ITAWAMBA CO SCHOOL DIST 280210000362 2900028 TREMONT ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_8                                                   40                                             40
2242737 2242737 MS     school 2804590 3112   WEST JASPER CONSOLIDATED SCHOOLS 280459000859 3112012 STRINGER ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_8                                                   39                                             39
2243574 2243574 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000512 4300004 BOGUE CHITTO SCHOOL   Regular School No Other PK 12 2021   grade_8                                                   60                                             60
2243588 2243588 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000513 4300008 ENTERPRISE SCHOOL   Regular School No Other KG 12 2021   grade_8                                                   60                                             60
2243603 2243603 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000515 4300016 LOYD STAR SCHOOL   Regular School No Other PK 12 2021   grade_8                                                   62                                             62
2243621 2243621 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000516 4300020 WEST LINCOLN SCHOOL   Regular School No Other PK 12 2021   grade_8                                                   66                                             66
2244034 2244034 MS     school 2802850 4700   MARSHALL CO SCHOOL DIST 280285000551 4700016 POTTS CAMP HIGH SCHOOL (4-12)   Regular School No Other 04 12 2021   grade_8                                                   49                                             49
2244093 2244093 MS     school 2802940 4800   MONROE CO SCHOOL DIST 280294000580 4800012 HAMILTON HIGH SCHOOL   Regular School No Other PK 12 2021   grade_8                                                   50                                             50
2244109 2244109 MS     school 2802940 4800   MONROE CO SCHOOL DIST 280294000581 4800016 HATLEY HIGH SCHOOL   Regular School No Other PK 12 2021   grade_8                                                   94                                             94
2244124 2244124 MS     school 2802940 4800   MONROE CO SCHOOL DIST 280294000582 4800020 SMITHVILLE HIGH SCHOOL   Regular School No Other PK 12 2021   grade_8                                                   47                                             47
2244710 2244710 MS     school 2803750 5900   PRENTISS CO SCHOOL DIST 280375000717 5900020 JUMPERTOWN HIGH SCHOOL   Regular School No Other PK 12 2021   grade_8                                                   33                                             33
2244743 2244743 MS     school 2803750 5900   PRENTISS CO SCHOOL DIST 280375000721 5900032 THRASHER HIGH SCHOOL   Regular School No Other PK 12 2021   grade_8                                                   40                                             40
2244759 2244759 MS     school 2803750 5900   PRENTISS CO SCHOOL DIST 280375000722 5900036 WHEELER HIGH SCHOOL   Regular School No Other KG 12 2021   grade_8                                                   45                                             45
2245076 2245076 MS     school 2803900 6200   SCOTT CO SCHOOL DIST 280390000748 6200016 SCOTT CENTRAL ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_8                                                   72                                             72
2245092 2245092 MS     school 2803900 6200   SCOTT CO SCHOOL DIST 280390000749 6200020 SEBASTOPOL ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_8                                                   58                                             58
2245205 2245205 MS     school 2804020 6500   SMITH CO SCHOOL DIST 280402000758 6500004 MIZE ATTENDANCE CENTER   Regular School No Other PK 12 2021   grade_8                                                   73                                             73
2245239 2245239 MS     school 2804020 6500   SMITH CO SCHOOL DIST 280402000762 6500012 TAYLORSVILLE ATTENDANCE CENTER   Regular School No Other PK 12 2021   grade_8                                                   58                                             58
2245481 2245481 MS     school 2803270 7011   NORTH TIPPAH SCHOOL DIST 280327001534 7011007 FALKNER ATTENDANCE CENTER   Regular School No Other PK 12 2021   grade_8                                                   41                                             41
2245497 2245497 MS     school 2803270 7011   NORTH TIPPAH SCHOOL DIST 280327000640 7011012 WALNUT ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_8                                                   34                                             34
2245514 2245514 MS     school 2804110 7012   SOUTH TIPPAH SCHOOL DIST 280411000775 7012004 BLUE MOUNTAIN HIGH SCHOOL   Regular School No Other PK 12 2021   grade_8                                                   22                                             22
2245529 2245529 MS     school 2804110 7012   SOUTH TIPPAH SCHOOL DIST 280411000776 7012008 PINE GROVE HIGH SCHOOL   Regular School No Other PK 12 2021   grade_8                                                   51                                             51
2245561 2245561 MS     school 2804260 7100   TISHOMINGO CO SP MUN SCH DIST 280426000803 7100004 BELMONT SCHOOL   Regular School No Other KG 12 2021   grade_8                                                   73                                             73
2245654 2245654 MS     school 2804350 7300   UNION CO SCHOOL DIST 280435000821 7300004 EAST UNION ATTENDANCE CENTER   Regular School No Other PK 12 2021   grade_8                                                   72                                             72
2245672 2245672 MS     school 2804350 7300   UNION CO SCHOOL DIST 280435000822 7300008 INGOMAR ATTENDANCE CENTER   Regular School No Other PK 12 2021   grade_8                                                   71                                             71
2245689 2245689 MS     school 2804350 7300   UNION CO SCHOOL DIST 280435000823 7300012 MYRTLE ATTENDANCE CENTER   Regular School No Other PK 12 2021   grade_8                                                   56                                             56
2245706 2245706 MS     school 2804350 7300   UNION CO SCHOOL DIST 280435000824 7300016 WEST UNION ATTENDANCE CENTER   Regular School No Other PK 12 2021   grade_8                                                   51                                             51
2245754 2245754 MS     school 2804440 7400   WALTHALL CO SCHOOL DIST 280444000834 7400008 SALEM ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_8                                                   35                                             35
2246191 2246191 MS     school 2802700 8020   LOUISVILLE MUNICIPAL SCHOOL DIST 280270000526 8020016 NANIH WAIYA ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_8                                                   47                                             47
2246207 2246207 MS     school 2802700 8020   LOUISVILLE MUNICIPAL SCHOOL DIST 280270000527 8020020 NOXAPATER ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_8                                                   48                                             48
2033494 2033494 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000602 130028 MORGANTOWN MIDDLE   Regular School No Middle 06 08 2020   grade_8                                                   127                                             127
2033500 2033500 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000604 130036 ROBERT LEWIS MAGNET SCHOOL   Regular School No Middle 06 08 2020   grade_8                                                   119                                             119
2033571 2033571 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001188 200010 ALCORN CENTRAL MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_8                                                   109                                             109
2033588 2033588 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001566 200023 KOSSUTH MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_8                                                   122                                             122
2033617 2033617 MS     school 2801260 220   CORINTH SCHOOL DIST 280126000006 220006 CORINTH MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_8                                                   187                                             187
2033677 2033677 MS     school 2802340 420   KOSCIUSKO SCHOOL DISTRICT 280234000457 420004 KOSCIUSKO JUNIOR HIGH SCHOOL   Regular School No Middle 06 08 2020   grade_8                                                   180                                             180
2033749 2033749 MS     school 2800750 614   CLEVELAND SCHOOL DIST 280075001475 614007 CLEVELAND CENTRAL MIDDLE SCHOOL   Regular School No Middle 07 08 2020   grade_8                                                   265                                             265
2033824 2033824 MS     school 2800185 618   WEST BOLIVAR CONS SCHOOL DISTRICT 280018501432 618008 WEST BOLIVAR DISTRICT MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_8                                                   40                                             40
2033984 2033984 MS     school 2802010 920   HOUSTON SCHOOL DIST 280201000040 920010 HOUSTON MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_8                                                   132                                             132
2034001 2034001 MS     school 2803390 921   OKOLONA SEPARATE SCHOOL DIST 280339001482 921012 OKOLONA MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_8                                                   48                                             48
2034051 2034051 MS     school 2801020 1100   CLAIBORNE CO SCHOOL DIST 280102000115 1100004 PORT GIBSON MIDDLE SCHOOL   Regular School No Middle 07 08 2020   grade_8                                                   *                                              
2034063 2034063 MS     school 2801440 1211   ENTERPRISE SCHOOL DIST 280144000977 1211002 ENTERPRISE MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_8                                                   *                                              
2034084 2034084 MS     school 2803780 1212   QUITMAN SCHOOL DIST 280378000723 1212004 QUITMAN JR HIGH SCHOOL   Regular School No Middle 06 08 2020   grade_8                                                   128                                             128
2034193 2034193 MS     school 2801050 1420   CLARKSDALE MUNICIPAL SCHOOL DIST 280105000119 1420008 W.A. HIGGINS MIDDLE SCHOOL ACADEMY   Regular School No Middle 07 08 2020   grade_8                                                   169                                             169
2034241 2034241 MS     school 2801220 1500   COPIAH CO SCHOOL DIST 280122000167 1500004 CRYSTAL SPRINGS MIDDLE SCHOOL   Regular School No Middle 04 08 2020   grade_8                                                   *                                              
2034274 2034274 MS     school 2801830 1520   HAZLEHURST CITY SCHOOL DISTRICT 280183000316 1520004 HAZLEHURST MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_8                                                   *                                              
2034310 2034310 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000178 1600012 CARVER MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_8                                                   77                                             77
2034353 2034353 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129001337 1600026 SEMINARY MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_8                                                   115                                             115
2034395 2034395 MS     school 2801320 1700   DESOTO CO SCHOOL DIST 280132000140 1700018 HERNANDO MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_8                                                   321                                             321
2034414 2034414 MS     school 2801320 1700   DESOTO CO SCHOOL DIST 280132000191 1700024 HORN LAKE MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_8                                                   330                                             330
2034448 2034448 MS     school 2801320 1700   DESOTO CO SCHOOL DIST 280132000194 1700034 OLIVE BRANCH MIDDLE   Regular School No Middle 06 08 2020   grade_8                                                   254                                             254
2034498 2034498 MS     school 2801320 1700   DESOTO CO SCHOOL DIST 280132000933 1700048 SOUTHAVEN MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_8                                                   468                                             468
2034522 2034522 MS     school 2801320 1700   DESOTO CO SCHOOL DIST 280132000979 1700054 DESOTO CENTRAL MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_8                                                   479                                             479
2034557 2034557 MS     school 2801320 1700   DESOTO CO SCHOOL DIST 280132001343 1700064 LEWISBURG MIDDLE   Regular School No Middle 06 08 2020   grade_8                                                   320                                             320

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