enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
3105643 3105643 MO     school 2911650 24089   EXCELSIOR SPRINGS 40 291165000071 1080 EXCELSIOR SPRINGS TECH. HIGH   Vocational Education School No 3 10 12 2015   pre_kindergarten                                                   0                                             0
3108810 3108810 MO     school 2916400 48078   KANSAS CITY 33 291640000840 1200 CENTRAL ACADEMY OF EXCELLENCE   Vocational Education School No 3 08 12 2015   pre_kindergarten                                                   0                                             0
3114854 3114854 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001604 1100 NORTH TECHNICAL   Vocational Education School No 3 09 12 2015   pre_kindergarten                                                   0                                             0
3114860 3114860 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001607 1150 SOUTH TECHNICAL   Vocational Education School No 3 10 12 2015   pre_kindergarten                                                   0                                             0
3115239 3115239 MO     school 2925650 103130   PUXICO R-VIII 292565002704 1080 MINGO PUXICO TECHNICAL HIGH   Vocational Education School No 3 12 12 2015   pre_kindergarten                                                   0                                             0
3116068 3116068 MO     school 2929280 115115   ST. LOUIS CITY 292928002767 1100 MILLER CAREER ACADEMY   Vocational Education School No 3 09 12 2015   pre_kindergarten                                                   0                                             0
3116506 3116506 MO     school 2900583 115901   CONSTRUCTION CAREERS CENTER 290058302788 1910 CONSTRUCTION CAREERS CENTER   Vocational Education School Yes 3 09 12 2015   pre_kindergarten                                                   0                                             0
3119453 3119453 MO     school 2911650 24089   EXCELSIOR SPRINGS 40 291165000071 1080 EXCELSIOR SPRINGS TECH. HIGH   Vocational Education School No 3 10 12 2015   kindergarten                                                   0                                             0
3122620 3122620 MO     school 2916400 48078   KANSAS CITY 33 291640000840 1200 CENTRAL ACADEMY OF EXCELLENCE   Vocational Education School No 3 08 12 2015   kindergarten                                                   0                                             0
3128664 3128664 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001604 1100 NORTH TECHNICAL   Vocational Education School No 3 09 12 2015   kindergarten                                                   0                                             0
3128670 3128670 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001607 1150 SOUTH TECHNICAL   Vocational Education School No 3 10 12 2015   kindergarten                                                   0                                             0
3129049 3129049 MO     school 2925650 103130   PUXICO R-VIII 292565002704 1080 MINGO PUXICO TECHNICAL HIGH   Vocational Education School No 3 12 12 2015   kindergarten                                                   0                                             0
3129878 3129878 MO     school 2929280 115115   ST. LOUIS CITY 292928002767 1100 MILLER CAREER ACADEMY   Vocational Education School No 3 09 12 2015   kindergarten                                                   0                                             0
3130316 3130316 MO     school 2900583 115901   CONSTRUCTION CAREERS CENTER 290058302788 1910 CONSTRUCTION CAREERS CENTER   Vocational Education School Yes 3 09 12 2015   kindergarten                                                   0                                             0
3133263 3133263 MO     school 2911650 24089   EXCELSIOR SPRINGS 40 291165000071 1080 EXCELSIOR SPRINGS TECH. HIGH   Vocational Education School No 3 10 12 2015   grade_1                                                   0                                             0
3136430 3136430 MO     school 2916400 48078   KANSAS CITY 33 291640000840 1200 CENTRAL ACADEMY OF EXCELLENCE   Vocational Education School No 3 08 12 2015   grade_1                                                   0                                             0
3142474 3142474 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001604 1100 NORTH TECHNICAL   Vocational Education School No 3 09 12 2015   grade_1                                                   0                                             0
3142480 3142480 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001607 1150 SOUTH TECHNICAL   Vocational Education School No 3 10 12 2015   grade_1                                                   0                                             0
3142859 3142859 MO     school 2925650 103130   PUXICO R-VIII 292565002704 1080 MINGO PUXICO TECHNICAL HIGH   Vocational Education School No 3 12 12 2015   grade_1                                                   0                                             0
3143688 3143688 MO     school 2929280 115115   ST. LOUIS CITY 292928002767 1100 MILLER CAREER ACADEMY   Vocational Education School No 3 09 12 2015   grade_1                                                   0                                             0
3144126 3144126 MO     school 2900583 115901   CONSTRUCTION CAREERS CENTER 290058302788 1910 CONSTRUCTION CAREERS CENTER   Vocational Education School Yes 3 09 12 2015   grade_1                                                   0                                             0
3147073 3147073 MO     school 2911650 24089   EXCELSIOR SPRINGS 40 291165000071 1080 EXCELSIOR SPRINGS TECH. HIGH   Vocational Education School No 3 10 12 2015   grade_2                                                   0                                             0
3150240 3150240 MO     school 2916400 48078   KANSAS CITY 33 291640000840 1200 CENTRAL ACADEMY OF EXCELLENCE   Vocational Education School No 3 08 12 2015   grade_2                                                   0                                             0
3156284 3156284 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001604 1100 NORTH TECHNICAL   Vocational Education School No 3 09 12 2015   grade_2                                                   0                                             0
3156290 3156290 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001607 1150 SOUTH TECHNICAL   Vocational Education School No 3 10 12 2015   grade_2                                                   0                                             0
3156669 3156669 MO     school 2925650 103130   PUXICO R-VIII 292565002704 1080 MINGO PUXICO TECHNICAL HIGH   Vocational Education School No 3 12 12 2015   grade_2                                                   0                                             0
3157498 3157498 MO     school 2929280 115115   ST. LOUIS CITY 292928002767 1100 MILLER CAREER ACADEMY   Vocational Education School No 3 09 12 2015   grade_2                                                   0                                             0
3157936 3157936 MO     school 2900583 115901   CONSTRUCTION CAREERS CENTER 290058302788 1910 CONSTRUCTION CAREERS CENTER   Vocational Education School Yes 3 09 12 2015   grade_2                                                   0                                             0
3160883 3160883 MO     school 2911650 24089   EXCELSIOR SPRINGS 40 291165000071 1080 EXCELSIOR SPRINGS TECH. HIGH   Vocational Education School No 3 10 12 2015   grade_3                                                   0                                             0
3164050 3164050 MO     school 2916400 48078   KANSAS CITY 33 291640000840 1200 CENTRAL ACADEMY OF EXCELLENCE   Vocational Education School No 3 08 12 2015   grade_3                                                   0                                             0
3170094 3170094 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001604 1100 NORTH TECHNICAL   Vocational Education School No 3 09 12 2015   grade_3                                                   0                                             0
3170100 3170100 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001607 1150 SOUTH TECHNICAL   Vocational Education School No 3 10 12 2015   grade_3                                                   0                                             0
3170479 3170479 MO     school 2925650 103130   PUXICO R-VIII 292565002704 1080 MINGO PUXICO TECHNICAL HIGH   Vocational Education School No 3 12 12 2015   grade_3                                                   0                                             0
3171308 3171308 MO     school 2929280 115115   ST. LOUIS CITY 292928002767 1100 MILLER CAREER ACADEMY   Vocational Education School No 3 09 12 2015   grade_3                                                   0                                             0
3171746 3171746 MO     school 2900583 115901   CONSTRUCTION CAREERS CENTER 290058302788 1910 CONSTRUCTION CAREERS CENTER   Vocational Education School Yes 3 09 12 2015   grade_3                                                   0                                             0
3174693 3174693 MO     school 2911650 24089   EXCELSIOR SPRINGS 40 291165000071 1080 EXCELSIOR SPRINGS TECH. HIGH   Vocational Education School No 3 10 12 2015   grade_4                                                   0                                             0
3177860 3177860 MO     school 2916400 48078   KANSAS CITY 33 291640000840 1200 CENTRAL ACADEMY OF EXCELLENCE   Vocational Education School No 3 08 12 2015   grade_4                                                   0                                             0
3183904 3183904 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001604 1100 NORTH TECHNICAL   Vocational Education School No 3 09 12 2015   grade_4                                                   0                                             0
3183910 3183910 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001607 1150 SOUTH TECHNICAL   Vocational Education School No 3 10 12 2015   grade_4                                                   0                                             0
3184289 3184289 MO     school 2925650 103130   PUXICO R-VIII 292565002704 1080 MINGO PUXICO TECHNICAL HIGH   Vocational Education School No 3 12 12 2015   grade_4                                                   0                                             0
3185118 3185118 MO     school 2929280 115115   ST. LOUIS CITY 292928002767 1100 MILLER CAREER ACADEMY   Vocational Education School No 3 09 12 2015   grade_4                                                   0                                             0
3185556 3185556 MO     school 2900583 115901   CONSTRUCTION CAREERS CENTER 290058302788 1910 CONSTRUCTION CAREERS CENTER   Vocational Education School Yes 3 09 12 2015   grade_4                                                   0                                             0
3188503 3188503 MO     school 2911650 24089   EXCELSIOR SPRINGS 40 291165000071 1080 EXCELSIOR SPRINGS TECH. HIGH   Vocational Education School No 3 10 12 2015   grade_5                                                   0                                             0
3191670 3191670 MO     school 2916400 48078   KANSAS CITY 33 291640000840 1200 CENTRAL ACADEMY OF EXCELLENCE   Vocational Education School No 3 08 12 2015   grade_5                                                   0                                             0
3197714 3197714 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001604 1100 NORTH TECHNICAL   Vocational Education School No 3 09 12 2015   grade_5                                                   0                                             0
3197720 3197720 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001607 1150 SOUTH TECHNICAL   Vocational Education School No 3 10 12 2015   grade_5                                                   0                                             0
3198099 3198099 MO     school 2925650 103130   PUXICO R-VIII 292565002704 1080 MINGO PUXICO TECHNICAL HIGH   Vocational Education School No 3 12 12 2015   grade_5                                                   0                                             0
3198928 3198928 MO     school 2929280 115115   ST. LOUIS CITY 292928002767 1100 MILLER CAREER ACADEMY   Vocational Education School No 3 09 12 2015   grade_5                                                   0                                             0
3199366 3199366 MO     school 2900583 115901   CONSTRUCTION CAREERS CENTER 290058302788 1910 CONSTRUCTION CAREERS CENTER   Vocational Education School Yes 3 09 12 2015   grade_5                                                   0                                             0
3202313 3202313 MO     school 2911650 24089   EXCELSIOR SPRINGS 40 291165000071 1080 EXCELSIOR SPRINGS TECH. HIGH   Vocational Education School No 3 10 12 2015   grade_6                                                   0                                             0
3205480 3205480 MO     school 2916400 48078   KANSAS CITY 33 291640000840 1200 CENTRAL ACADEMY OF EXCELLENCE   Vocational Education School No 3 08 12 2015   grade_6                                                   0                                             0
3211524 3211524 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001604 1100 NORTH TECHNICAL   Vocational Education School No 3 09 12 2015   grade_6                                                   0                                             0
3211530 3211530 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001607 1150 SOUTH TECHNICAL   Vocational Education School No 3 10 12 2015   grade_6                                                   0                                             0
3211909 3211909 MO     school 2925650 103130   PUXICO R-VIII 292565002704 1080 MINGO PUXICO TECHNICAL HIGH   Vocational Education School No 3 12 12 2015   grade_6                                                   0                                             0
3212738 3212738 MO     school 2929280 115115   ST. LOUIS CITY 292928002767 1100 MILLER CAREER ACADEMY   Vocational Education School No 3 09 12 2015   grade_6                                                   0                                             0
3213176 3213176 MO     school 2900583 115901   CONSTRUCTION CAREERS CENTER 290058302788 1910 CONSTRUCTION CAREERS CENTER   Vocational Education School Yes 3 09 12 2015   grade_6                                                   0                                             0
3216123 3216123 MO     school 2911650 24089   EXCELSIOR SPRINGS 40 291165000071 1080 EXCELSIOR SPRINGS TECH. HIGH   Vocational Education School No 3 10 12 2015   grade_7                                                   0                                             0
3219290 3219290 MO     school 2916400 48078   KANSAS CITY 33 291640000840 1200 CENTRAL ACADEMY OF EXCELLENCE   Vocational Education School No 3 08 12 2015   grade_7                                                   0                                             0
3225334 3225334 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001604 1100 NORTH TECHNICAL   Vocational Education School No 3 09 12 2015   grade_7                                                   0                                             0
3225340 3225340 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001607 1150 SOUTH TECHNICAL   Vocational Education School No 3 10 12 2015   grade_7                                                   0                                             0
3225719 3225719 MO     school 2925650 103130   PUXICO R-VIII 292565002704 1080 MINGO PUXICO TECHNICAL HIGH   Vocational Education School No 3 12 12 2015   grade_7                                                   0                                             0
3226548 3226548 MO     school 2929280 115115   ST. LOUIS CITY 292928002767 1100 MILLER CAREER ACADEMY   Vocational Education School No 3 09 12 2015   grade_7                                                   0                                             0
3226986 3226986 MO     school 2900583 115901   CONSTRUCTION CAREERS CENTER 290058302788 1910 CONSTRUCTION CAREERS CENTER   Vocational Education School Yes 3 09 12 2015   grade_7                                                   0                                             0
3229933 3229933 MO     school 2911650 24089   EXCELSIOR SPRINGS 40 291165000071 1080 EXCELSIOR SPRINGS TECH. HIGH   Vocational Education School No 3 10 12 2015   grade_8                                                   0                                             0
3233100 3233100 MO     school 2916400 48078   KANSAS CITY 33 291640000840 1200 CENTRAL ACADEMY OF EXCELLENCE   Vocational Education School No 3 08 12 2015   grade_8                                                   157                                             157
3239144 3239144 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001604 1100 NORTH TECHNICAL   Vocational Education School No 3 09 12 2015   grade_8                                                   0                                             0
3239150 3239150 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001607 1150 SOUTH TECHNICAL   Vocational Education School No 3 10 12 2015   grade_8                                                   0                                             0
3239529 3239529 MO     school 2925650 103130   PUXICO R-VIII 292565002704 1080 MINGO PUXICO TECHNICAL HIGH   Vocational Education School No 3 12 12 2015   grade_8                                                   0                                             0
3240358 3240358 MO     school 2929280 115115   ST. LOUIS CITY 292928002767 1100 MILLER CAREER ACADEMY   Vocational Education School No 3 09 12 2015   grade_8                                                   0                                             0
3240796 3240796 MO     school 2900583 115901   CONSTRUCTION CAREERS CENTER 290058302788 1910 CONSTRUCTION CAREERS CENTER   Vocational Education School Yes 3 09 12 2015   grade_8                                                   0                                             0
3243743 3243743 MO     school 2911650 24089   EXCELSIOR SPRINGS 40 291165000071 1080 EXCELSIOR SPRINGS TECH. HIGH   Vocational Education School No 3 10 12 2015   grade_9                                                   0                                             0
3246910 3246910 MO     school 2916400 48078   KANSAS CITY 33 291640000840 1200 CENTRAL ACADEMY OF EXCELLENCE   Vocational Education School No 3 08 12 2015   grade_9                                                   225                                             225
3252954 3252954 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001604 1100 NORTH TECHNICAL   Vocational Education School No 3 09 12 2015   grade_9                                                   0                                             0
3252960 3252960 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001607 1150 SOUTH TECHNICAL   Vocational Education School No 3 10 12 2015   grade_9                                                   0                                             0
3253339 3253339 MO     school 2925650 103130   PUXICO R-VIII 292565002704 1080 MINGO PUXICO TECHNICAL HIGH   Vocational Education School No 3 12 12 2015   grade_9                                                   0                                             0
3254168 3254168 MO     school 2929280 115115   ST. LOUIS CITY 292928002767 1100 MILLER CAREER ACADEMY   Vocational Education School No 3 09 12 2015   grade_9                                                   186                                             186
3254606 3254606 MO     school 2900583 115901   CONSTRUCTION CAREERS CENTER 290058302788 1910 CONSTRUCTION CAREERS CENTER   Vocational Education School Yes 3 09 12 2015   grade_9                                                   61                                             61
3257553 3257553 MO     school 2911650 24089   EXCELSIOR SPRINGS 40 291165000071 1080 EXCELSIOR SPRINGS TECH. HIGH   Vocational Education School No 3 10 12 2015   grade_10                                                   104                                             104
3260720 3260720 MO     school 2916400 48078   KANSAS CITY 33 291640000840 1200 CENTRAL ACADEMY OF EXCELLENCE   Vocational Education School No 3 08 12 2015   grade_10                                                   122                                             122
3266764 3266764 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001604 1100 NORTH TECHNICAL   Vocational Education School No 3 09 12 2015   grade_10                                                   246                                             246
3266770 3266770 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001607 1150 SOUTH TECHNICAL   Vocational Education School No 3 10 12 2015   grade_10                                                   0                                             0
3267149 3267149 MO     school 2925650 103130   PUXICO R-VIII 292565002704 1080 MINGO PUXICO TECHNICAL HIGH   Vocational Education School No 3 12 12 2015   grade_10                                                   0                                             0
3267978 3267978 MO     school 2929280 115115   ST. LOUIS CITY 292928002767 1100 MILLER CAREER ACADEMY   Vocational Education School No 3 09 12 2015   grade_10                                                   130                                             130
3268416 3268416 MO     school 2900583 115901   CONSTRUCTION CAREERS CENTER 290058302788 1910 CONSTRUCTION CAREERS CENTER   Vocational Education School Yes 3 09 12 2015   grade_10                                                   31                                             31
3271363 3271363 MO     school 2911650 24089   EXCELSIOR SPRINGS 40 291165000071 1080 EXCELSIOR SPRINGS TECH. HIGH   Vocational Education School No 3 10 12 2015   grade_11                                                   40                                             40
3274530 3274530 MO     school 2916400 48078   KANSAS CITY 33 291640000840 1200 CENTRAL ACADEMY OF EXCELLENCE   Vocational Education School No 3 08 12 2015   grade_11                                                   110                                             110
3280574 3280574 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001604 1100 NORTH TECHNICAL   Vocational Education School No 3 09 12 2015   grade_11                                                   414                                             414
3280580 3280580 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001607 1150 SOUTH TECHNICAL   Vocational Education School No 3 10 12 2015   grade_11                                                   415                                             415
3280959 3280959 MO     school 2925650 103130   PUXICO R-VIII 292565002704 1080 MINGO PUXICO TECHNICAL HIGH   Vocational Education School No 3 12 12 2015   grade_11                                                   0                                             0
3281788 3281788 MO     school 2929280 115115   ST. LOUIS CITY 292928002767 1100 MILLER CAREER ACADEMY   Vocational Education School No 3 09 12 2015   grade_11                                                   174                                             174
3282226 3282226 MO     school 2900583 115901   CONSTRUCTION CAREERS CENTER 290058302788 1910 CONSTRUCTION CAREERS CENTER   Vocational Education School Yes 3 09 12 2015   grade_11                                                   44                                             44
3285173 3285173 MO     school 2911650 24089   EXCELSIOR SPRINGS 40 291165000071 1080 EXCELSIOR SPRINGS TECH. HIGH   Vocational Education School No 3 10 12 2015   grade_12                                                   0                                             0
3288340 3288340 MO     school 2916400 48078   KANSAS CITY 33 291640000840 1200 CENTRAL ACADEMY OF EXCELLENCE   Vocational Education School No 3 08 12 2015   grade_12                                                   120                                             120
3294384 3294384 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001604 1100 NORTH TECHNICAL   Vocational Education School No 3 09 12 2015   grade_12                                                   372                                             372
3294390 3294390 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001607 1150 SOUTH TECHNICAL   Vocational Education School No 3 10 12 2015   grade_12                                                   356                                             356
3294769 3294769 MO     school 2925650 103130   PUXICO R-VIII 292565002704 1080 MINGO PUXICO TECHNICAL HIGH   Vocational Education School No 3 12 12 2015   grade_12                                                   67                                             67
3295598 3295598 MO     school 2929280 115115   ST. LOUIS CITY 292928002767 1100 MILLER CAREER ACADEMY   Vocational Education School No 3 09 12 2015   grade_12                                                   195                                             195
3296036 3296036 MO     school 2900583 115901   CONSTRUCTION CAREERS CENTER 290058302788 1910 CONSTRUCTION CAREERS CENTER   Vocational Education School Yes 3 09 12 2015   grade_12                                                   26                                             26
3298983 3298983 MO     school 2911650 24089   EXCELSIOR SPRINGS 40 291165000071 1080 EXCELSIOR SPRINGS TECH. HIGH   Vocational Education School No 3 10 12 2015   k_12_total 45 81 13 *   *       * 6           *         *   *   147 45 81 13               6                       147
3302150 3302150 MO     school 2916400 48078   KANSAS CITY 33 291640000840 1200 CENTRAL ACADEMY OF EXCELLENCE   Vocational Education School No 3 08 12 2015   k_12_total 14 692 17 *   *       * 7           6         *   131   734 14 692 17               7           6       131   734

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