enrollments

Data source: Big Local News · About: Big Local

37,152 rows where state = "MO" and year = 2019 sorted by ccd_school_lvl descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2019 · 37,152 ✖
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
3105483 3105483 MO     school 2923430 22093   OZARK R-VI 292343002438 2050 OZARK JR. HIGH   Regular School No Secondary 08 09 2019   pre_kindergarten                                                   0                                             0
3105576 3105576 MO     school 2916450 24086   KEARNEY R-I 291645002531 2050 KEARNEY JR. HIGH   Regular School No Secondary 08 09 2019   pre_kindergarten                                                   0                                             0
3108416 3108416 MO     school 2914340 48072   HICKMAN MILLS C-1 291434003249 1060 HICKMAN MILLS FRESHMAN CENTER   Regular School No Secondary 09 09 2019   pre_kindergarten                                                   0                                             0
3109246 3109246 MO     school 2900603 48926   CROSSROADS CHARTER SCHOOLS 290060303311 1905 CROSSROADS HIGH SCHOOL   Regular School Yes Secondary 07 10 2019   pre_kindergarten                                                   0                                             0
3116585 3116585 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103314 1905 KIPP ST. LOUIS HIGH   Regular School Yes Secondary 09 10 2019   pre_kindergarten                                                   0                                             0
3116690 3116690 MO     school 2900608 115925   HAWTHORN LEADERSHIP SCHL GIRLS 290060803317 1905 Hawthorn High School   Regular School Yes Secondary 09 10 2019   pre_kindergarten                                                   0                                             0
3119293 3119293 MO     school 2923430 22093   OZARK R-VI 292343002438 2050 OZARK JR. HIGH   Regular School No Secondary 08 09 2019   kindergarten                                                   0                                             0
3119386 3119386 MO     school 2916450 24086   KEARNEY R-I 291645002531 2050 KEARNEY JR. HIGH   Regular School No Secondary 08 09 2019   kindergarten                                                   0                                             0
3122226 3122226 MO     school 2914340 48072   HICKMAN MILLS C-1 291434003249 1060 HICKMAN MILLS FRESHMAN CENTER   Regular School No Secondary 09 09 2019   kindergarten                                                   0                                             0
3123056 3123056 MO     school 2900603 48926   CROSSROADS CHARTER SCHOOLS 290060303311 1905 CROSSROADS HIGH SCHOOL   Regular School Yes Secondary 07 10 2019   kindergarten                                                   0                                             0
3130395 3130395 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103314 1905 KIPP ST. LOUIS HIGH   Regular School Yes Secondary 09 10 2019   kindergarten                                                   0                                             0
3130500 3130500 MO     school 2900608 115925   HAWTHORN LEADERSHIP SCHL GIRLS 290060803317 1905 Hawthorn High School   Regular School Yes Secondary 09 10 2019   kindergarten                                                   0                                             0
3133103 3133103 MO     school 2923430 22093   OZARK R-VI 292343002438 2050 OZARK JR. HIGH   Regular School No Secondary 08 09 2019   grade_1                                                   0                                             0
3133196 3133196 MO     school 2916450 24086   KEARNEY R-I 291645002531 2050 KEARNEY JR. HIGH   Regular School No Secondary 08 09 2019   grade_1                                                   0                                             0
3136036 3136036 MO     school 2914340 48072   HICKMAN MILLS C-1 291434003249 1060 HICKMAN MILLS FRESHMAN CENTER   Regular School No Secondary 09 09 2019   grade_1                                                   0                                             0
3136866 3136866 MO     school 2900603 48926   CROSSROADS CHARTER SCHOOLS 290060303311 1905 CROSSROADS HIGH SCHOOL   Regular School Yes Secondary 07 10 2019   grade_1                                                   0                                             0
3144205 3144205 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103314 1905 KIPP ST. LOUIS HIGH   Regular School Yes Secondary 09 10 2019   grade_1                                                   0                                             0
3144310 3144310 MO     school 2900608 115925   HAWTHORN LEADERSHIP SCHL GIRLS 290060803317 1905 Hawthorn High School   Regular School Yes Secondary 09 10 2019   grade_1                                                   0                                             0
3146913 3146913 MO     school 2923430 22093   OZARK R-VI 292343002438 2050 OZARK JR. HIGH   Regular School No Secondary 08 09 2019   grade_2                                                   0                                             0
3147006 3147006 MO     school 2916450 24086   KEARNEY R-I 291645002531 2050 KEARNEY JR. HIGH   Regular School No Secondary 08 09 2019   grade_2                                                   0                                             0
3149846 3149846 MO     school 2914340 48072   HICKMAN MILLS C-1 291434003249 1060 HICKMAN MILLS FRESHMAN CENTER   Regular School No Secondary 09 09 2019   grade_2                                                   0                                             0
3150676 3150676 MO     school 2900603 48926   CROSSROADS CHARTER SCHOOLS 290060303311 1905 CROSSROADS HIGH SCHOOL   Regular School Yes Secondary 07 10 2019   grade_2                                                   0                                             0
3158015 3158015 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103314 1905 KIPP ST. LOUIS HIGH   Regular School Yes Secondary 09 10 2019   grade_2                                                   0                                             0
3158120 3158120 MO     school 2900608 115925   HAWTHORN LEADERSHIP SCHL GIRLS 290060803317 1905 Hawthorn High School   Regular School Yes Secondary 09 10 2019   grade_2                                                   0                                             0
3160723 3160723 MO     school 2923430 22093   OZARK R-VI 292343002438 2050 OZARK JR. HIGH   Regular School No Secondary 08 09 2019   grade_3                                                   0                                             0
3160816 3160816 MO     school 2916450 24086   KEARNEY R-I 291645002531 2050 KEARNEY JR. HIGH   Regular School No Secondary 08 09 2019   grade_3                                                   0                                             0
3163656 3163656 MO     school 2914340 48072   HICKMAN MILLS C-1 291434003249 1060 HICKMAN MILLS FRESHMAN CENTER   Regular School No Secondary 09 09 2019   grade_3                                                   0                                             0
3164486 3164486 MO     school 2900603 48926   CROSSROADS CHARTER SCHOOLS 290060303311 1905 CROSSROADS HIGH SCHOOL   Regular School Yes Secondary 07 10 2019   grade_3                                                   0                                             0
3171825 3171825 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103314 1905 KIPP ST. LOUIS HIGH   Regular School Yes Secondary 09 10 2019   grade_3                                                   0                                             0
3171930 3171930 MO     school 2900608 115925   HAWTHORN LEADERSHIP SCHL GIRLS 290060803317 1905 Hawthorn High School   Regular School Yes Secondary 09 10 2019   grade_3                                                   0                                             0
3174533 3174533 MO     school 2923430 22093   OZARK R-VI 292343002438 2050 OZARK JR. HIGH   Regular School No Secondary 08 09 2019   grade_4                                                   0                                             0
3174626 3174626 MO     school 2916450 24086   KEARNEY R-I 291645002531 2050 KEARNEY JR. HIGH   Regular School No Secondary 08 09 2019   grade_4                                                   0                                             0
3177466 3177466 MO     school 2914340 48072   HICKMAN MILLS C-1 291434003249 1060 HICKMAN MILLS FRESHMAN CENTER   Regular School No Secondary 09 09 2019   grade_4                                                   0                                             0
3178296 3178296 MO     school 2900603 48926   CROSSROADS CHARTER SCHOOLS 290060303311 1905 CROSSROADS HIGH SCHOOL   Regular School Yes Secondary 07 10 2019   grade_4                                                   0                                             0
3185635 3185635 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103314 1905 KIPP ST. LOUIS HIGH   Regular School Yes Secondary 09 10 2019   grade_4                                                   0                                             0
3185740 3185740 MO     school 2900608 115925   HAWTHORN LEADERSHIP SCHL GIRLS 290060803317 1905 Hawthorn High School   Regular School Yes Secondary 09 10 2019   grade_4                                                   0                                             0
3188343 3188343 MO     school 2923430 22093   OZARK R-VI 292343002438 2050 OZARK JR. HIGH   Regular School No Secondary 08 09 2019   grade_5                                                   0                                             0
3188436 3188436 MO     school 2916450 24086   KEARNEY R-I 291645002531 2050 KEARNEY JR. HIGH   Regular School No Secondary 08 09 2019   grade_5                                                   0                                             0
3191276 3191276 MO     school 2914340 48072   HICKMAN MILLS C-1 291434003249 1060 HICKMAN MILLS FRESHMAN CENTER   Regular School No Secondary 09 09 2019   grade_5                                                   0                                             0
3192106 3192106 MO     school 2900603 48926   CROSSROADS CHARTER SCHOOLS 290060303311 1905 CROSSROADS HIGH SCHOOL   Regular School Yes Secondary 07 10 2019   grade_5                                                   0                                             0
3199445 3199445 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103314 1905 KIPP ST. LOUIS HIGH   Regular School Yes Secondary 09 10 2019   grade_5                                                   0                                             0
3199550 3199550 MO     school 2900608 115925   HAWTHORN LEADERSHIP SCHL GIRLS 290060803317 1905 Hawthorn High School   Regular School Yes Secondary 09 10 2019   grade_5                                                   0                                             0
3202153 3202153 MO     school 2923430 22093   OZARK R-VI 292343002438 2050 OZARK JR. HIGH   Regular School No Secondary 08 09 2019   grade_6                                                   0                                             0
3202246 3202246 MO     school 2916450 24086   KEARNEY R-I 291645002531 2050 KEARNEY JR. HIGH   Regular School No Secondary 08 09 2019   grade_6                                                   0                                             0
3205086 3205086 MO     school 2914340 48072   HICKMAN MILLS C-1 291434003249 1060 HICKMAN MILLS FRESHMAN CENTER   Regular School No Secondary 09 09 2019   grade_6                                                   0                                             0
3205916 3205916 MO     school 2900603 48926   CROSSROADS CHARTER SCHOOLS 290060303311 1905 CROSSROADS HIGH SCHOOL   Regular School Yes Secondary 07 10 2019   grade_6                                                   0                                             0
3213255 3213255 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103314 1905 KIPP ST. LOUIS HIGH   Regular School Yes Secondary 09 10 2019   grade_6                                                   0                                             0
3213360 3213360 MO     school 2900608 115925   HAWTHORN LEADERSHIP SCHL GIRLS 290060803317 1905 Hawthorn High School   Regular School Yes Secondary 09 10 2019   grade_6                                                   0                                             0
3215963 3215963 MO     school 2923430 22093   OZARK R-VI 292343002438 2050 OZARK JR. HIGH   Regular School No Secondary 08 09 2019   grade_7                                                   0                                             0
3216056 3216056 MO     school 2916450 24086   KEARNEY R-I 291645002531 2050 KEARNEY JR. HIGH   Regular School No Secondary 08 09 2019   grade_7                                                   0                                             0
3218896 3218896 MO     school 2914340 48072   HICKMAN MILLS C-1 291434003249 1060 HICKMAN MILLS FRESHMAN CENTER   Regular School No Secondary 09 09 2019   grade_7                                                   0                                             0
3219726 3219726 MO     school 2900603 48926   CROSSROADS CHARTER SCHOOLS 290060303311 1905 CROSSROADS HIGH SCHOOL   Regular School Yes Secondary 07 10 2019   grade_7                                                   48                                             48
3227065 3227065 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103314 1905 KIPP ST. LOUIS HIGH   Regular School Yes Secondary 09 10 2019   grade_7                                                   0                                             0
3227170 3227170 MO     school 2900608 115925   HAWTHORN LEADERSHIP SCHL GIRLS 290060803317 1905 Hawthorn High School   Regular School Yes Secondary 09 10 2019   grade_7                                                   0                                             0
3229773 3229773 MO     school 2923430 22093   OZARK R-VI 292343002438 2050 OZARK JR. HIGH   Regular School No Secondary 08 09 2019   grade_8                                                   459                                             459
3229866 3229866 MO     school 2916450 24086   KEARNEY R-I 291645002531 2050 KEARNEY JR. HIGH   Regular School No Secondary 08 09 2019   grade_8                                                   279                                             279
3232706 3232706 MO     school 2914340 48072   HICKMAN MILLS C-1 291434003249 1060 HICKMAN MILLS FRESHMAN CENTER   Regular School No Secondary 09 09 2019   grade_8                                                   0                                             0
3233536 3233536 MO     school 2900603 48926   CROSSROADS CHARTER SCHOOLS 290060303311 1905 CROSSROADS HIGH SCHOOL   Regular School Yes Secondary 07 10 2019   grade_8                                                   50                                             50
3240875 3240875 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103314 1905 KIPP ST. LOUIS HIGH   Regular School Yes Secondary 09 10 2019   grade_8                                                   0                                             0
3240980 3240980 MO     school 2900608 115925   HAWTHORN LEADERSHIP SCHL GIRLS 290060803317 1905 Hawthorn High School   Regular School Yes Secondary 09 10 2019   grade_8                                                   0                                             0
3243583 3243583 MO     school 2923430 22093   OZARK R-VI 292343002438 2050 OZARK JR. HIGH   Regular School No Secondary 08 09 2019   grade_9                                                   425                                             425
3243676 3243676 MO     school 2916450 24086   KEARNEY R-I 291645002531 2050 KEARNEY JR. HIGH   Regular School No Secondary 08 09 2019   grade_9                                                   295                                             295
3246516 3246516 MO     school 2914340 48072   HICKMAN MILLS C-1 291434003249 1060 HICKMAN MILLS FRESHMAN CENTER   Regular School No Secondary 09 09 2019   grade_9                                                   322                                             322
3247346 3247346 MO     school 2900603 48926   CROSSROADS CHARTER SCHOOLS 290060303311 1905 CROSSROADS HIGH SCHOOL   Regular School Yes Secondary 07 10 2019   grade_9                                                   48                                             48
3254685 3254685 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103314 1905 KIPP ST. LOUIS HIGH   Regular School Yes Secondary 09 10 2019   grade_9                                                   128                                             128
3254790 3254790 MO     school 2900608 115925   HAWTHORN LEADERSHIP SCHL GIRLS 290060803317 1905 Hawthorn High School   Regular School Yes Secondary 09 10 2019   grade_9                                                   28                                             28
3257393 3257393 MO     school 2923430 22093   OZARK R-VI 292343002438 2050 OZARK JR. HIGH   Regular School No Secondary 08 09 2019   grade_10                                                   0                                             0
3257486 3257486 MO     school 2916450 24086   KEARNEY R-I 291645002531 2050 KEARNEY JR. HIGH   Regular School No Secondary 08 09 2019   grade_10                                                   0                                             0
3260326 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
3261156 3261156 MO     school 2900603 48926   CROSSROADS CHARTER SCHOOLS 290060303311 1905 CROSSROADS HIGH SCHOOL   Regular School Yes Secondary 07 10 2019   grade_10                                                   43                                             43
3268495 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
3268600 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
3271203 3271203 MO     school 2923430 22093   OZARK R-VI 292343002438 2050 OZARK JR. HIGH   Regular School No Secondary 08 09 2019   grade_11                                                   0                                             0
3271296 3271296 MO     school 2916450 24086   KEARNEY R-I 291645002531 2050 KEARNEY JR. HIGH   Regular School No Secondary 08 09 2019   grade_11                                                   0                                             0
3274136 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
3274966 3274966 MO     school 2900603 48926   CROSSROADS CHARTER SCHOOLS 290060303311 1905 CROSSROADS HIGH SCHOOL   Regular School Yes Secondary 07 10 2019   grade_11                                                   0                                             0
3282305 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
3282410 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
3285013 3285013 MO     school 2923430 22093   OZARK R-VI 292343002438 2050 OZARK JR. HIGH   Regular School No Secondary 08 09 2019   grade_12                                                   0                                             0
3285106 3285106 MO     school 2916450 24086   KEARNEY R-I 291645002531 2050 KEARNEY JR. HIGH   Regular School No Secondary 08 09 2019   grade_12                                                   0                                             0
3287946 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
3288776 3288776 MO     school 2900603 48926   CROSSROADS CHARTER SCHOOLS 290060303311 1905 CROSSROADS HIGH SCHOOL   Regular School Yes Secondary 07 10 2019   grade_12                                                   0                                             0
3296115 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
3296220 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
3298823 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
3298916 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
3301756 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
3302586 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
3309925 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
3310030 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
3312633 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
3312726 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
3315566 3315566 MO     school 2914340 48072   HICKMAN MILLS C-1 291434003249 1060 HICKMAN MILLS FRESHMAN CENTER   Regular School No Secondary 09 09 2019   pk_12_total                                                   322                                             322
3316396 3316396 MO     school 2900603 48926   CROSSROADS CHARTER SCHOOLS 290060303311 1905 CROSSROADS HIGH SCHOOL   Regular School Yes Secondary 07 10 2019   pk_12_total                                                   189                                             189
3323735 3323735 MO     school 2900591 115914   KIPP ST LOUIS PUBLIC SCHOOLS 290059103314 1905 KIPP ST. LOUIS HIGH   Regular School Yes Secondary 09 10 2019   pk_12_total                                                   214                                             214
3323840 3323840 MO     school 2900608 115925   HAWTHORN LEADERSHIP SCHL GIRLS 290060803317 1905 Hawthorn High School   Regular School Yes Secondary 09 10 2019   pk_12_total                                                   60                                             60
3103451 3103451 MO     school 2927570 2097   SAVANNAH R-III 292757003186 7500 EARLY CHILDHOOD LEARNING CTR   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   48                                             48
3103801 3103801 MO     school 2906360 7129   BUTLER R-V 290636003308 7500 BUTLER EARLY CHILDHOOD   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   77                                             77
3103865 3103865 MO     school 2909900 8111   COLE CAMP R-I 290990003248 7500 COLE CAMP PRESCHOOL   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   23                                             23
3104228 3104228 MO     school 2901000 10093   COLUMBIA 93 290100003287 7500 CENTER FOR EARLY LRNING-NORTH   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   364                                             364

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