Data source: Big Local News · About: Big Local

257,968 rows where state = "MO" sorted by ccd_school_lvl descending

View and edit SQL

grade

year

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
3257392 MO     school 2923430 22093   OZARK R-VI 292343002438 2050 OZARK JR. HIGH   Regular School No Secondary 08 09 2018   grade_10                                                   0                                             0
3257393 MO     school 2923430 22093   OZARK R-VI 292343002438 2050 OZARK JR. HIGH   Regular School No Secondary 08 09 2019   grade_10                                                   0                                             0
3257394 MO     school 2923430 22093   OZARK R-VI 292343002438 2050 OZARK JR. HIGH   Regular School No Secondary 08 09 2020   grade_10                                                   0                                             0
3257485 MO     school 2916450 24086   KEARNEY R-I 291645002531 2050 KEARNEY JR. HIGH   Regular School No Secondary 08 09 2018   grade_10                                                   0                                             0
3257486 MO     school 2916450 24086   KEARNEY R-I 291645002531 2050 KEARNEY JR. HIGH   Regular School No Secondary 08 09 2019   grade_10                                                   0                                             0
3257487 MO     school 2916450 24086   KEARNEY R-I 291645002531 2050 KEARNEY JR. HIGH   Regular School No Secondary 08 09 2020   grade_10                                                   0                                             0
3258001 MO     school 2916190 26006   JEFFERSON CITY 291619003346 1060 CAPITAL CITY HIGH SCHOOL   Regular School No Secondary 09 10 2020   grade_10                                                   321                                             321
3260325 MO     school 2914340 48072   HICKMAN MILLS C-1 291434003249 1060 HICKMAN MILLS FRESHMAN CENTER   Regular School No Secondary 09 09 2018   grade_10                                                   0                                             0
3260326 MO     school 2914340 48072   HICKMAN MILLS C-1 291434003249 1060 HICKMAN MILLS FRESHMAN CENTER   Regular School No Secondary 09 09 2019   grade_10                                                   0                                             0
3261140 MO     school 2900597 48924   EWING MARION KAUFFMAN SCHOOL 290059703277 1910 EWING MARION KAUFFMAN HIGH   Regular School Yes Secondary 09 11 2018   grade_10                                                   46                                             46
3261155 MO     school 2900603 48926   CROSSROADS CHARTER SCHOOLS 290060303311 1905 CROSSROADS HIGH SCHOOL   Regular School Yes Secondary 09 09 2018   grade_10                                                   0                                             0
3261156 MO     school 2900603 48926   CROSSROADS CHARTER SCHOOLS 290060303311 1905 CROSSROADS HIGH SCHOOL   Regular School Yes Secondary 07 10 2019   grade_10                                                   43                                             43
3261157 MO     school 2900603 48926   CROSSROADS CHARTER SCHOOLS 290060303311 1905 CROSSROADS HIGH SCHOOL   Regular School Yes Secondary 07 11 2020   grade_10                                                   47                                             47
3265452 MO     school 2912010 96089   FERGUSON-FLORISSANT R-II 291201002691 1060 STEAM ACADEMY AT MSB HIGH SCHO   Regular School No Secondary 09 11 2020   grade_10                                                   49                                             49
3265459 MO     school 2912010 96089   FERGUSON-FLORISSANT R-II 291201003371 1080 THE INNOVATION SCHOOL AT CV   Regular School No Secondary 09 09 2020   grade_10                                                   0                                             0
3268494 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103314 1905 KIPP ST. LOUIS HIGH   Regular School Yes Secondary 09 09 2018   grade_10                                                   0                                             0
3268495 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103314 1905 KIPP ST. LOUIS HIGH   Regular School Yes Secondary 09 10 2019   grade_10                                                   86                                             86
3268496 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103314 1905 KIPP ST. LOUIS HIGH   Regular School Yes Secondary 09 11 2020   grade_10                                                   102                                             102
3268564 MO     school 2900600 115920   ST. LOUIS COLLEGE PREP 290060003264 1910 St. Louis College Prep High   Regular School Yes Secondary 09 11 2018   grade_10                                                   73                                             73
3268599 MO     school 2900608 115925   HAWTHORN LEADERSHIP SCHL GIRLS 290060803317 1905 Hawthorn High School   Regular School Yes Secondary 09 09 2018   grade_10                                                   0                                             0
3268600 MO     school 2900608 115925   HAWTHORN LEADERSHIP SCHL GIRLS 290060803317 1905 Hawthorn High School   Regular School Yes Secondary 09 10 2019   grade_10                                                   32                                             32
3268601 MO     school 2900608 115925   HAWTHORN LEADERSHIP SCHL GIRLS 290060803317 1905 Hawthorn High School   Regular School Yes Secondary 09 11 2020   grade_10                                                   15                                             15
3270503 MO     school 2915600 16090   JACKSON R-II 291560000737 2050 RUSSELL HAWKINS JR. HIGH   Regular School No Secondary 08 09 2018   grade_11                                                   0                                             0
3271202 MO     school 2923430 22093   OZARK R-VI 292343002438 2050 OZARK JR. HIGH   Regular School No Secondary 08 09 2018   grade_11                                                   0                                             0
3271203 MO     school 2923430 22093   OZARK R-VI 292343002438 2050 OZARK JR. HIGH   Regular School No Secondary 08 09 2019   grade_11                                                   0                                             0
3271204 MO     school 2923430 22093   OZARK R-VI 292343002438 2050 OZARK JR. HIGH   Regular School No Secondary 08 09 2020   grade_11                                                   0                                             0
3271295 MO     school 2916450 24086   KEARNEY R-I 291645002531 2050 KEARNEY JR. HIGH   Regular School No Secondary 08 09 2018   grade_11                                                   0                                             0
3271296 MO     school 2916450 24086   KEARNEY R-I 291645002531 2050 KEARNEY JR. HIGH   Regular School No Secondary 08 09 2019   grade_11                                                   0                                             0
3271297 MO     school 2916450 24086   KEARNEY R-I 291645002531 2050 KEARNEY JR. HIGH   Regular School No Secondary 08 09 2020   grade_11                                                   0                                             0
3271811 MO     school 2916190 26006   JEFFERSON CITY 291619003346 1060 CAPITAL CITY HIGH SCHOOL   Regular School No Secondary 09 10 2020   grade_11                                                   0                                             0
3274135 MO     school 2914340 48072   HICKMAN MILLS C-1 291434003249 1060 HICKMAN MILLS FRESHMAN CENTER   Regular School No Secondary 09 09 2018   grade_11                                                   0                                             0
3274136 MO     school 2914340 48072   HICKMAN MILLS C-1 291434003249 1060 HICKMAN MILLS FRESHMAN CENTER   Regular School No Secondary 09 09 2019   grade_11                                                   0                                             0
3274950 MO     school 2900597 48924   EWING MARION KAUFFMAN SCHOOL 290059703277 1910 EWING MARION KAUFFMAN HIGH   Regular School Yes Secondary 09 11 2018   grade_11                                                   41                                             41
3274965 MO     school 2900603 48926   CROSSROADS CHARTER SCHOOLS 290060303311 1905 CROSSROADS HIGH SCHOOL   Regular School Yes Secondary 09 09 2018   grade_11                                                   0                                             0
3274966 MO     school 2900603 48926   CROSSROADS CHARTER SCHOOLS 290060303311 1905 CROSSROADS HIGH SCHOOL   Regular School Yes Secondary 07 10 2019   grade_11                                                   0                                             0
3274967 MO     school 2900603 48926   CROSSROADS CHARTER SCHOOLS 290060303311 1905 CROSSROADS HIGH SCHOOL   Regular School Yes Secondary 07 11 2020   grade_11                                                   44                                             44
3279262 MO     school 2912010 96089   FERGUSON-FLORISSANT R-II 291201002691 1060 STEAM ACADEMY AT MSB HIGH SCHO   Regular School No Secondary 09 11 2020   grade_11                                                   52                                             52
3279269 MO     school 2912010 96089   FERGUSON-FLORISSANT R-II 291201003371 1080 THE INNOVATION SCHOOL AT CV   Regular School No Secondary 09 09 2020   grade_11                                                   0                                             0
3282304 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103314 1905 KIPP ST. LOUIS HIGH   Regular School Yes Secondary 09 09 2018   grade_11                                                   0                                             0
3282305 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103314 1905 KIPP ST. LOUIS HIGH   Regular School Yes Secondary 09 10 2019   grade_11                                                   0                                             0
3282306 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103314 1905 KIPP ST. LOUIS HIGH   Regular School Yes Secondary 09 11 2020   grade_11                                                   62                                             62
3282374 MO     school 2900600 115920   ST. LOUIS COLLEGE PREP 290060003264 1910 St. Louis College Prep High   Regular School Yes Secondary 09 11 2018   grade_11                                                   33                                             33
3282409 MO     school 2900608 115925   HAWTHORN LEADERSHIP SCHL GIRLS 290060803317 1905 Hawthorn High School   Regular School Yes Secondary 09 09 2018   grade_11                                                   0                                             0
3282410 MO     school 2900608 115925   HAWTHORN LEADERSHIP SCHL GIRLS 290060803317 1905 Hawthorn High School   Regular School Yes Secondary 09 10 2019   grade_11                                                   0                                             0
3282411 MO     school 2900608 115925   HAWTHORN LEADERSHIP SCHL GIRLS 290060803317 1905 Hawthorn High School   Regular School Yes Secondary 09 11 2020   grade_11                                                   11                                             11
3284313 MO     school 2915600 16090   JACKSON R-II 291560000737 2050 RUSSELL HAWKINS JR. HIGH   Regular School No Secondary 08 09 2018   grade_12                                                   0                                             0
3285012 MO     school 2923430 22093   OZARK R-VI 292343002438 2050 OZARK JR. HIGH   Regular School No Secondary 08 09 2018   grade_12                                                   0                                             0
3285013 MO     school 2923430 22093   OZARK R-VI 292343002438 2050 OZARK JR. HIGH   Regular School No Secondary 08 09 2019   grade_12                                                   0                                             0
3285014 MO     school 2923430 22093   OZARK R-VI 292343002438 2050 OZARK JR. HIGH   Regular School No Secondary 08 09 2020   grade_12                                                   0                                             0
3285105 MO     school 2916450 24086   KEARNEY R-I 291645002531 2050 KEARNEY JR. HIGH   Regular School No Secondary 08 09 2018   grade_12                                                   0                                             0
3285106 MO     school 2916450 24086   KEARNEY R-I 291645002531 2050 KEARNEY JR. HIGH   Regular School No Secondary 08 09 2019   grade_12                                                   0                                             0
3285107 MO     school 2916450 24086   KEARNEY R-I 291645002531 2050 KEARNEY JR. HIGH   Regular School No Secondary 08 09 2020   grade_12                                                   0                                             0
3285621 MO     school 2916190 26006   JEFFERSON CITY 291619003346 1060 CAPITAL CITY HIGH SCHOOL   Regular School No Secondary 09 10 2020   grade_12                                                   0                                             0
3287945 MO     school 2914340 48072   HICKMAN MILLS C-1 291434003249 1060 HICKMAN MILLS FRESHMAN CENTER   Regular School No Secondary 09 09 2018   grade_12                                                   0                                             0
3287946 MO     school 2914340 48072   HICKMAN MILLS C-1 291434003249 1060 HICKMAN MILLS FRESHMAN CENTER   Regular School No Secondary 09 09 2019   grade_12                                                   0                                             0
3288760 MO     school 2900597 48924   EWING MARION KAUFFMAN SCHOOL 290059703277 1910 EWING MARION KAUFFMAN HIGH   Regular School Yes Secondary 09 11 2018   grade_12                                                   0                                             0
3288775 MO     school 2900603 48926   CROSSROADS CHARTER SCHOOLS 290060303311 1905 CROSSROADS HIGH SCHOOL   Regular School Yes Secondary 09 09 2018   grade_12                                                   0                                             0
3288776 MO     school 2900603 48926   CROSSROADS CHARTER SCHOOLS 290060303311 1905 CROSSROADS HIGH SCHOOL   Regular School Yes Secondary 07 10 2019   grade_12                                                   0                                             0
3288777 MO     school 2900603 48926   CROSSROADS CHARTER SCHOOLS 290060303311 1905 CROSSROADS HIGH SCHOOL   Regular School Yes Secondary 07 11 2020   grade_12                                                   0                                             0
3293072 MO     school 2912010 96089   FERGUSON-FLORISSANT R-II 291201002691 1060 STEAM ACADEMY AT MSB HIGH SCHO   Regular School No Secondary 09 11 2020   grade_12                                                   0                                             0
3293079 MO     school 2912010 96089   FERGUSON-FLORISSANT R-II 291201003371 1080 THE INNOVATION SCHOOL AT CV   Regular School No Secondary 09 09 2020   grade_12                                                   0                                             0
3296114 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103314 1905 KIPP ST. LOUIS HIGH   Regular School Yes Secondary 09 09 2018   grade_12                                                   0                                             0
3296115 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103314 1905 KIPP ST. LOUIS HIGH   Regular School Yes Secondary 09 10 2019   grade_12                                                   0                                             0
3296116 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103314 1905 KIPP ST. LOUIS HIGH   Regular School Yes Secondary 09 11 2020   grade_12                                                   0                                             0
3296184 MO     school 2900600 115920   ST. LOUIS COLLEGE PREP 290060003264 1910 St. Louis College Prep High   Regular School Yes Secondary 09 11 2018   grade_12                                                   0                                             0
3296219 MO     school 2900608 115925   HAWTHORN LEADERSHIP SCHL GIRLS 290060803317 1905 Hawthorn High School   Regular School Yes Secondary 09 09 2018   grade_12                                                   0                                             0
3296220 MO     school 2900608 115925   HAWTHORN LEADERSHIP SCHL GIRLS 290060803317 1905 Hawthorn High School   Regular School Yes Secondary 09 10 2019   grade_12                                                   0                                             0
3296221 MO     school 2900608 115925   HAWTHORN LEADERSHIP SCHL GIRLS 290060803317 1905 Hawthorn High School   Regular School Yes Secondary 09 11 2020   grade_12                                                   0                                             0
3298123 MO     school 2915600 16090   JACKSON R-II 291560000737 2050 RUSSELL HAWKINS JR. HIGH   Regular School No Secondary 08 09 2018   k_12_total 725 15 21 *   6       * 31           *         252   64   801 725 15 21     6         31                 252 64   801
3298822 MO     school 2923430 22093   OZARK R-VI 292343002438 2050 OZARK JR. HIGH   Regular School No Secondary 08 09 2018   k_12_total 764 5 45 8   *       * 28           18         275   85   854 764 5 45 8             28           18     275 85   854
3298823 MO     school 2923430 22093   OZARK R-VI 292343002438 2050 OZARK JR. HIGH   Regular School No Secondary 08 09 2019   k_12_total 779 8 50 6   *       * 38           18         298   100   884 779 8 50 6             38           18     298 100   884
3298824 MO     school 2923430 22093   OZARK R-VI 292343002438 2050 OZARK JR. HIGH   Regular School No Secondary 08 09 2020   k_12_total 858 6 41 5   *       * 41           25         338.1   123   954 858 6 41 5             41           25       123   954
3298915 MO     school 2916450 24086   KEARNEY R-I 291645002531 2050 KEARNEY JR. HIGH   Regular School No Secondary 08 09 2018   k_12_total 526 5 19 *   *       * 15           *         77   54   569 526 5 19               15                 77 54   569
3298916 MO     school 2916450 24086   KEARNEY R-I 291645002531 2050 KEARNEY JR. HIGH   Regular School No Secondary 08 09 2019   k_12_total 534 6 17 *   *       * 15           *         77   55   574 534 6 17               15                 77 55   574
3298917 MO     school 2916450 24086   KEARNEY R-I 291645002531 2050 KEARNEY JR. HIGH   Regular School No Secondary 08 09 2020   k_12_total 507 * 14 *   *       * 15           *         63   56   542 507   14               15                 63 56   542
3299431 MO     school 2916190 26006   JEFFERSON CITY 291619003346 1060 CAPITAL CITY HIGH SCHOOL   Regular School No Secondary 09 10 2020   k_12_total 481 130 68 *   10       * 56           20         338   87   746 481 130 68     10         56           20     338 87   746
3301755 MO     school 2914340 48072   HICKMAN MILLS C-1 291434003249 1060 HICKMAN MILLS FRESHMAN CENTER   Regular School No Secondary 09 09 2018   k_12_total 41 278 35 *   5       * 13           16         *   64   373 41 278 35     5         13           16       64   373
3301756 MO     school 2914340 48072   HICKMAN MILLS C-1 291434003249 1060 HICKMAN MILLS FRESHMAN CENTER   Regular School No Secondary 09 09 2019   k_12_total 40 221 38 *   5       * 18           14         *   47   322 40 221 38     5         18           14       47   322
3302570 MO     school 2900597 48924   EWING MARION KAUFFMAN SCHOOL 290059703277 1910 EWING MARION KAUFFMAN HIGH   Regular School Yes Secondary 09 11 2018   k_12_total 6 159 29 *   6       * *           9         164   12   203 6 159 29     6                     9     164 12   203
3302585 MO     school 2900603 48926   CROSSROADS CHARTER SCHOOLS 290060303311 1905 CROSSROADS HIGH SCHOOL   Regular School Yes Secondary 09 09 2018   k_12_total 7 15 7 *   *       * *           *         28   *   32 7 15 7                                 28     32
3302586 MO     school 2900603 48926   CROSSROADS CHARTER SCHOOLS 290060303311 1905 CROSSROADS HIGH SCHOOL   Regular School Yes Secondary 07 10 2019   k_12_total 45 74 45 *   *       * 18           22         125   19   189 45 74 45               18           22     125 19   189
3302587 MO     school 2900603 48926   CROSSROADS CHARTER SCHOOLS 290060303311 1905 CROSSROADS HIGH SCHOOL   Regular School Yes Secondary 07 11 2020   k_12_total 48 110 61 5   *       * 13           27         161   30   241 48 110 61 5             13           27     161 30   241
3306882 MO     school 2912010 96089   FERGUSON-FLORISSANT R-II 291201002691 1060 STEAM ACADEMY AT MSB HIGH SCHO   Regular School No Secondary 09 11 2020   k_12_total 26 185 13 *   *       * 18           *         *   14   242 26 185 13               18                   14   242
3306889 MO     school 2912010 96089   FERGUSON-FLORISSANT R-II 291201003371 1080 THE INNOVATION SCHOOL AT CV   Regular School No Secondary 09 09 2020   k_12_total * 56 * *   *       * *           *         *   8   59   56                                     8   59
3309924 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103314 1905 KIPP ST. LOUIS HIGH   Regular School Yes Secondary 09 09 2018   k_12_total * 106 * *   *       * *           *         *   20   111   106                                     20   111
3309925 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103314 1905 KIPP ST. LOUIS HIGH   Regular School Yes Secondary 09 10 2019   k_12_total * 202 9 *   *       * *           9         *   33   214   202 9                           9       33   214
3309926 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103314 1905 KIPP ST. LOUIS HIGH   Regular School Yes Secondary 09 11 2020   k_12_total * 312 9 *   *       * *           7         *   53   326   312 9                           7       53   326
3309994 MO     school 2900600 115920   ST. LOUIS COLLEGE PREP 290060003264 1910 St. Louis College Prep High   Regular School Yes Secondary 09 11 2018   k_12_total 6 160 5 *   *       * *           *         *   45   175 6 160 5                                   45   175
3310029 MO     school 2900608 115925   HAWTHORN LEADERSHIP SCHL GIRLS 290060803317 1905 Hawthorn High School   Regular School Yes Secondary 09 09 2018   k_12_total * 41 * *   *       * *           *         *   5   43   41                                     5   43
3310030 MO     school 2900608 115925   HAWTHORN LEADERSHIP SCHL GIRLS 290060803317 1905 Hawthorn High School   Regular School Yes Secondary 09 10 2019   k_12_total * 53 * *   *       * *           *         *   11   60   53                                     11   60
3310031 MO     school 2900608 115925   HAWTHORN LEADERSHIP SCHL GIRLS 290060803317 1905 Hawthorn High School   Regular School Yes Secondary 09 11 2020   k_12_total * 38 * *   *       * *           *         *   8   43   38                                     8   43
3311933 MO     school 2915600 16090   JACKSON R-II 291560000737 2050 RUSSELL HAWKINS JR. HIGH   Regular School No Secondary 08 09 2018   pk_12_total                                                   801                                             801
3312632 MO     school 2923430 22093   OZARK R-VI 292343002438 2050 OZARK JR. HIGH   Regular School No Secondary 08 09 2018   pk_12_total                                                   854                                             854
3312633 MO     school 2923430 22093   OZARK R-VI 292343002438 2050 OZARK JR. HIGH   Regular School No Secondary 08 09 2019   pk_12_total                                                   884                                             884
3312634 MO     school 2923430 22093   OZARK R-VI 292343002438 2050 OZARK JR. HIGH   Regular School No Secondary 08 09 2020   pk_12_total                                                   954                                             954
3312725 MO     school 2916450 24086   KEARNEY R-I 291645002531 2050 KEARNEY JR. HIGH   Regular School No Secondary 08 09 2018   pk_12_total                                                   569                                             569
3312726 MO     school 2916450 24086   KEARNEY R-I 291645002531 2050 KEARNEY JR. HIGH   Regular School No Secondary 08 09 2019   pk_12_total                                                   574                                             574
3312727 MO     school 2916450 24086   KEARNEY R-I 291645002531 2050 KEARNEY JR. HIGH   Regular School No Secondary 08 09 2020   pk_12_total                                                   542                                             542
3313241 MO     school 2916190 26006   JEFFERSON CITY 291619003346 1060 CAPITAL CITY HIGH SCHOOL   Regular School No Secondary 09 10 2020   pk_12_total                                                   746                                             746
3315565 MO     school 2914340 48072   HICKMAN MILLS C-1 291434003249 1060 HICKMAN MILLS FRESHMAN CENTER   Regular School No Secondary 09 09 2018   pk_12_total                                                   373                                             373

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