enrollments

Data source: Big Local News · About: Big Local

16,123 rows where grade = "k_12_total" and state = "MO" sorted by ccd_school_type

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • k_12_total · 16,023 ✖
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
3310484 3310484 MO     school 2900607 401401   MO VIRTUAL INSTRUCTION PROGRAM 290060703228 1050 MOCAP HIGH SCHOOL   Alternative School No High 06 12 2019   k_12_total 48 * * *   *       * *           *         *   *   52 48                                           52
3310487 3310487 MO     school 2900607 401401   MO VIRTUAL INSTRUCTION PROGRAM 290060703225 4020 MOVIP ELEM. SCHOOL   Alternative School No Elementary KG 05 2017   k_12_total * * * *   *       * *           *         *   *   7                                             7
3310488 3310488 MO     school 2900607 401401   MO VIRTUAL INSTRUCTION PROGRAM 290060703225 4020 MOVIP ELEM. SCHOOL   Alternative School No Elementary KG 05 2018   k_12_total * * * *   *       * *           *         *   *   0                                             0
3069648 3069648 MO     school 2911650 24089   EXCELSIOR SPRINGS 40 291165000071 1080 EXCELSIOR SPRINGS TECH. HIGH   Career and Technical School No High 10 12 2021   k_12_total                                                   140                                             140
3071203 3071203 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001604 1100 NORTH TECHNICAL   Career and Technical School No High 09 12 2021   k_12_total                                                   777                                             777
3071204 3071204 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001607 1150 SOUTH TECHNICAL   Career and Technical School No High 10 12 2021   k_12_total                                                   830                                             830
3071266 3071266 MO     school 2925650 103130   PUXICO R-VIII 292565002704 1080 MINGO PUXICO TECHNICAL HIGH   Career and Technical School No High 12 12 2021   k_12_total                                                   37                                             37
3071406 3071406 MO     school 2929280 115115   ST. LOUIS CITY 292928002767 1100 MILLER CAREER ACADEMY   Career and Technical School No High 09 12 2021   k_12_total                                                   471                                             471
3298985 3298985 MO     school 2911650 24089   EXCELSIOR SPRINGS 40 291165000071 1080 EXCELSIOR SPRINGS TECH. HIGH   Career and Technical School No High 10 12 2017   k_12_total 54 119 13 *   *       * 9           *         *   *   196 54 119 13               9                       196
3298986 3298986 MO     school 2911650 24089   EXCELSIOR SPRINGS 40 291165000071 1080 EXCELSIOR SPRINGS TECH. HIGH   Career and Technical School No High 10 12 2018   k_12_total 46 80 9 *   *       * 6           *         *   *   142 46 80 9               6                       142
3298987 3298987 MO     school 2911650 24089   EXCELSIOR SPRINGS 40 291165000071 1080 EXCELSIOR SPRINGS TECH. HIGH   Career and Technical School No High 10 12 2019   k_12_total 57 98 10 *   *       * 12           *         156   *   178 57 98 10               12                 156     178
3298988 3298988 MO     school 2911650 24089   EXCELSIOR SPRINGS 40 291165000071 1080 EXCELSIOR SPRINGS TECH. HIGH   Career and Technical School No High 10 12 2020   k_12_total 78 67 10 *   *       * 12           *         *   *   168 78 67 10               12                       168
3302152 3302152 MO     school 2916400 48078   KANSAS CITY 33 291640000840 1200 CENTRAL ACADEMY OF EXCELLENCE   Career and Technical School No High 09 12 2017   k_12_total 19 449 12 *   *       * 7           *         *   110   490 19 449 12               7                   110   490
3302153 3302153 MO     school 2916400 48078   KANSAS CITY 33 291640000840 1200 CENTRAL ACADEMY OF EXCELLENCE   Career and Technical School No High 09 12 2018   k_12_total 23 451 19 *   *       * 6           7         *   93   501 23 451 19               6           7       93   501
3302154 3302154 MO     school 2916400 48078   KANSAS CITY 33 291640000840 1200 CENTRAL ACADEMY OF EXCELLENCE   Career and Technical School No High 09 12 2019   k_12_total 25 463 25 *   *       * 6           7         *   112   521 25 463 25               6           7       112   521
3308196 3308196 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001604 1100 NORTH TECHNICAL   Career and Technical School No High 09 12 2017   k_12_total 96 635 8 *   7       * *           *         *   20   751 96 635 8     7                             20   751
3308197 3308197 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001604 1100 NORTH TECHNICAL   Career and Technical School No High 09 12 2018   k_12_total 101 638 24 *   *       * *           *         *   35   774 101 638 24                                   35   774
3308198 3308198 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001604 1100 NORTH TECHNICAL   Career and Technical School No High 09 12 2019   k_12_total 88 615 35 9   7       * 8           *         *   22   764 88 615 35 9   7         8                   22   764
3308199 3308199 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001604 1100 NORTH TECHNICAL   Career and Technical School No High 09 12 2020   k_12_total 115 652 48 11   12       * 8           *         539.1   22   848 115 652 48 11   12         8                   22   848
3308202 3308202 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001607 1150 SOUTH TECHNICAL   Career and Technical School No High 10 12 2017   k_12_total 587 168 15 *   26       * *           *         107   *   801 587 168 15     26                           107     801
3308203 3308203 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001607 1150 SOUTH TECHNICAL   Career and Technical School No High 10 12 2018   k_12_total 555 162 20 8   25       * 5           *         102.1   *   776 555 162 20 8   25         5                       776
3308204 3308204 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001607 1150 SOUTH TECHNICAL   Career and Technical School No High 10 12 2019   k_12_total 534 147 27 8   51       * 15           *         97   *   785 534 147 27 8   51         15                 97     785
3308205 3308205 MO     school 2926760 96119   SPECL. SCH. DST. ST. LOUIS CO. 292676001607 1150 SOUTH TECHNICAL   Career and Technical School No High 10 12 2020   k_12_total 535 138 32 8   44       * 12           *         45.2   *   772 535 138 32 8   44         12                       772
3308581 3308581 MO     school 2925650 103130   PUXICO R-VIII 292565002704 1080 MINGO PUXICO TECHNICAL HIGH   Career and Technical School No High 12 12 2017   k_12_total 50 6 * *   *       * *           *         52   *   59 50 6                                   52     59
3308582 3308582 MO     school 2925650 103130   PUXICO R-VIII 292565002704 1080 MINGO PUXICO TECHNICAL HIGH   Career and Technical School No High 12 12 2018   k_12_total 52 8 * *   *       * *           *         *   *   61 52 8                                         61
3308583 3308583 MO     school 2925650 103130   PUXICO R-VIII 292565002704 1080 MINGO PUXICO TECHNICAL HIGH   Career and Technical School No High 12 12 2019   k_12_total 43 14 * *   *       * *           *         39   *   64 43 14                                   39     64
3308584 3308584 MO     school 2925650 103130   PUXICO R-VIII 292565002704 1080 MINGO PUXICO TECHNICAL HIGH   Career and Technical School No High 12 12 2020   k_12_total 28 7 * *   *       * *           *         *   *   38 28 7                                         38
3309410 3309410 MO     school 2929280 115115   ST. LOUIS CITY 292928002767 1100 MILLER CAREER ACADEMY   Career and Technical School No High 09 12 2017   k_12_total 16 570 5 *   *       * *           *         *   47   593 16 570 5                                   47   593
3309411 3309411 MO     school 2929280 115115   ST. LOUIS CITY 292928002767 1100 MILLER CAREER ACADEMY   Career and Technical School No High 09 12 2018   k_12_total 10 585 5 *   *       * *           7         *   45   602 10 585 5                           7       45   602
3309412 3309412 MO     school 2929280 115115   ST. LOUIS CITY 292928002767 1100 MILLER CAREER ACADEMY   Career and Technical School No High 09 12 2019   k_12_total 7 530 5 *   *       * *           8         *   39   543 7 530 5                           8       39   543
3309413 3309413 MO     school 2929280 115115   ST. LOUIS CITY 292928002767 1100 MILLER CAREER ACADEMY   Career and Technical School No High 09 12 2020   k_12_total 8 478 6 *   *       * *           11         *   27   494 8 478 6                           11       27   494
3069262 3069262 MO     school 2922980 1090   ADAIR CO. R-I 292298001315 1050 ADAIR CO. HIGH   Regular School No High 07 12 2021   k_12_total                                                   111                                             111
3069263 3069263 MO     school 2922980 1090   ADAIR CO. R-I 292298001314 4020 ADAIR CO. ELEM.   Regular School No Elementary PK 06 2021   k_12_total                                                   97                                             97
3069264 3069264 MO     school 2916740 1091   KIRKSVILLE R-III 291674000916 1050 KIRKSVILLE SR. HIGH   Regular School No High 09 12 2021   k_12_total                                                   735                                             735
3069265 3069265 MO     school 2916740 1091   KIRKSVILLE R-III 291674002611 3000 WILLIAM MATTHEW MIDDLE SCHOOL   Regular School No Middle 06 08 2021   k_12_total                                                   545                                             545
3069266 3069266 MO     school 2916740 1091   KIRKSVILLE R-III 291674002219 4030 KIRKSVILLE PRIMARY   Regular School No Elementary PK 02 2021   k_12_total                                                   486                                             486
3069267 3069267 MO     school 2916740 1091   KIRKSVILLE R-III 291674000917 4050 RAY MILLER ELEM.   Regular School No Elementary 03 05 2021   k_12_total                                                   527                                             527
3069268 3069268 MO     school 2905790 1092   ADAIR CO. R-II 290579000125 1050 ADAIR CO. HIGH   Regular School No High 07 12 2021   k_12_total                                                   74                                             74
3069269 3069269 MO     school 2905790 1092   ADAIR CO. R-II 290579000124 4020 ADAIR CO. ELEM.   Regular School No Elementary KG 06 2021   k_12_total                                                   71                                             71
3069270 3069270 MO     school 2922710 2089   NORTH ANDREW CO. R-VI 292271001251 1050 NORTH ANDREW HIGH   Regular School No High 09 12 2021   k_12_total                                                   126                                             126
3069271 3069271 MO     school 2922710 2089   NORTH ANDREW CO. R-VI 292271000006 3000 NORTH ANDREW MIDDLE   Regular School No Middle 06 08 2021   k_12_total                                                   66                                             66
3069272 3069272 MO     school 2922710 2089   NORTH ANDREW CO. R-VI 292271001250 4020 NORTH ANDREW ELEM.   Regular School No Elementary PK 05 2021   k_12_total                                                   140                                             140
3069273 3069273 MO     school 2904080 2090   AVENUE CITY R-IX 290408000037 4020 AVENUE CITY ELEM.   Regular School No Elementary PK 08 2021   k_12_total                                                   167                                             167
3069274 3069274 MO     school 2927570 2097   SAVANNAH R-III 292757001693 1050 SAVANNAH HIGH   Regular School No High 09 12 2021   k_12_total                                                   682                                             682
3069275 3069275 MO     school 2927570 2097   SAVANNAH R-III 292757001691 3000 SAVANNAH MIDDLE   Regular School No Middle 06 08 2021   k_12_total                                                   543                                             543
3069276 3069276 MO     school 2927570 2097   SAVANNAH R-III 292757001688 4010 AMAZONIA ELEM.   Regular School No Elementary KG 05 2021   k_12_total                                                   88                                             88
3069277 3069277 MO     school 2927570 2097   SAVANNAH R-III 292757001689 4015 HELENA ELEM.   Regular School No Elementary KG 05 2021   k_12_total                                                   77                                             77
3069278 3069278 MO     school 2927570 2097   SAVANNAH R-III 292757001690 4020 JOHN GLENN ELEM.   Regular School No Elementary KG 05 2021   k_12_total                                                   234                                             234
3069279 3069279 MO     school 2927570 2097   SAVANNAH R-III 292757001692 4040 MINNIE CLINE ELEM.   Regular School No Elementary KG 05 2021   k_12_total                                                   627                                             627
3069280 3069280 MO     school 2927570 2097   SAVANNAH R-III 292757003186 7500 EARLY CHILDHOOD LEARNING CTR   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3069281 3069281 MO     school 2929940 3031   TARKIO R-I 292994002067 1050 TARKIO HIGH   Regular School No High 06 12 2021   k_12_total                                                   173                                             173
3069282 3069282 MO     school 2929940 3031   TARKIO R-I 292994002066 4020 TARKIO ELEM.   Regular School No Elementary PK 05 2021   k_12_total                                                   151                                             151
3069283 3069283 MO     school 2926790 3032   ROCK PORT R-II 292679001613 1050 ROCK PORT HIGH   Regular School No High 07 12 2021   k_12_total                                                   153                                             153
3069284 3069284 MO     school 2926790 3032   ROCK PORT R-II 292679001612 4020 ROCK PORT ELEM.   Regular School No Elementary PK 06 2021   k_12_total                                                   177                                             177
3069285 3069285 MO     school 2911760 3033   FAIRFAX R-III 291176000433 1050 FAIRFAX HIGH   Regular School No High 07 12 2021   k_12_total                                                   64                                             64
3069286 3069286 MO     school 2911760 3033   FAIRFAX R-III 291176000432 4020 FAIRFAX ELEM.   Regular School No Elementary PK 06 2021   k_12_total                                                   71                                             71
3069287 3069287 MO     school 2910020 4106   COMMUNITY R-VI 291002000319 1050 COMMUNITY HIGH   Regular School No High 06 12 2021   k_12_total                                                   183                                             183
3069288 3069288 MO     school 2910020 4106   COMMUNITY R-VI 291002000318 4020 COMMUNITY ELEM.   Regular School No Elementary PK 05 2021   k_12_total                                                   129                                             129
3069289 3069289 MO     school 2930780 4109   VAN-FAR R-I 293078002124 1050 VAN-FAR JR./SR. HIGH   Regular School No High 07 12 2021   k_12_total                                                   278                                             278
3069290 3069290 MO     school 2930780 4109   VAN-FAR R-I 293078002125 4020 VAN-FAR ELEM.   Regular School No Elementary PK 06 2021   k_12_total                                                   279                                             279
3069291 3069291 MO     school 2920810 4110   MEXICO 59 292081001137 1050 MEXICO HIGH   Regular School No High 09 12 2021   k_12_total                                                   703                                             703
3069292 3069292 MO     school 2920810 4110   MEXICO 59 292081001136 2050 MEXICO MIDDLE   Regular School No Middle 06 08 2021   k_12_total                                                   554                                             554
3069293 3069293 MO     school 2920810 4110   MEXICO 59 292081001132 4020 EUGENE FIELD ELEM.   Regular School No Elementary 01 05 2021   k_12_total                                                   377                                             377
3069294 3069294 MO     school 2920810 4110   MEXICO 59 292081001133 4060 HAWTHORNE ELEM.   Regular School No Elementary 01 05 2021   k_12_total                                                   420                                             420
3069295 3069295 MO     school 2920810 4110   MEXICO 59 292081001134 4080 MCMILLAN EARLY LEARNING CENTER   Regular School No Elementary PK KG 2021   k_12_total                                                   177                                             177
3069296 3069296 MO     school 2931950 5120   WHEATON R-III 293195002237 1050 WHEATON HIGH   Regular School No High 07 12 2021   k_12_total                                                   190                                             190
3069297 3069297 MO     school 2931950 5120   WHEATON R-III 293195002236 4020 WHEATON ELEM.   Regular School No Elementary PK 06 2021   k_12_total                                                   239                                             239
3069298 3069298 MO     school 2928710 5121   SOUTHWEST R-V 292871001774 1050 SOUTHWEST HIGH   Regular School No High 09 12 2021   k_12_total                                                   236                                             236
3069299 3069299 MO     school 2928710 5121   SOUTHWEST R-V 292871002801 3000 SOUTHWEST MIDDLE   Regular School No Middle 05 08 2021   k_12_total                                                   247                                             247
3069300 3069300 MO     school 2928710 5121   SOUTHWEST R-V 292871001773 4020 SOUTHWEST ELEM.   Regular School No Elementary PK 04 2021   k_12_total                                                   217                                             217
3069301 3069301 MO     school 2911670 5122   EXETER R-VI 291167000427 1050 EXETER HIGH   Regular School No High 09 12 2021   k_12_total                                                   91                                             91
3069302 3069302 MO     school 2911670 5122   EXETER R-VI 291167000426 4020 EXETER ELEM.   Regular School No Elementary PK 08 2021   k_12_total                                                   193                                             193
3069303 3069303 MO     school 2908170 5123   CASSVILLE R-IV 290817000219 1050 CASSVILLE HIGH   Regular School No High 09 12 2021   k_12_total                                                   568                                             568
3069304 3069304 MO     school 2908170 5123   CASSVILLE R-IV 290817002425 3000 CASSVILLE MIDDLE   Regular School No Middle 06 08 2021   k_12_total                                                   429                                             429
3069305 3069305 MO     school 2908170 5123   CASSVILLE R-IV 290817000217 4020 EUNICE THOMAS ELEM.   Regular School No Elementary PK 02 2021   k_12_total                                                   392                                             392
3069306 3069306 MO     school 2908170 5123   CASSVILLE R-IV 290817002718 4030 CASSVILLE INTERMEDIATE   Regular School No Elementary 03 05 2021   k_12_total                                                   387                                             387
3069307 3069307 MO     school 2925620 5124   PURDY R-II 292562001502 1050 PURDY HIGH   Regular School No High 07 12 2021   k_12_total                                                   289                                             289
3069308 3069308 MO     school 2925620 5124   PURDY R-II 292562001501 4020 PURDY ELEM.   Regular School No Elementary PK 06 2021   k_12_total                                                   315                                             315
3069309 3069309 MO     school 2928200 5127   SHELL KNOB 78 292820001735 4020 SHELL KNOB ELEM.   Regular School No Elementary PK 08 2021   k_12_total                                                   111                                             111
3069310 3069310 MO     school 2921120 5128   MONETT R-I 292112001162 1050 MONETT HIGH   Regular School No High 09 12 2021   k_12_total                                                   764                                             764
3069311 3069311 MO     school 2921120 5128   MONETT R-I 292112000183 3000 MONETT MIDDLE   Regular School No Middle 07 08 2021   k_12_total                                                   387                                             387
3069312 3069312 MO     school 2921120 5128   MONETT R-I 292112003089 4000 CENTRAL PARK ELEM.   Regular School No Elementary 03 04 2021   k_12_total                                                   339                                             339
3069313 3069313 MO     school 2921120 5128   MONETT R-I 292112001160 4020 MONETT ELEM.   Regular School No Elementary PK 02 2021   k_12_total                                                   453                                             453
3069314 3069314 MO     school 2921120 5128   MONETT R-I 292112001595 4040 MONETT INTERMEDIATE   Regular School No Middle 05 06 2021   k_12_total                                                   337                                             337
3069315 3069315 MO     school 2918510 6101   LIBERAL R-II 291851001003 1050 LIBERAL HIGH   Regular School No High 09 12 2021   k_12_total                                                   112                                             112
3069316 3069316 MO     school 2918510 6101   LIBERAL R-II 291851002719 3000 LIBERAL MIDDLE   Regular School No Middle 06 08 2021   k_12_total                                                   88                                             88
3069317 3069317 MO     school 2918510 6101   LIBERAL R-II 291851001002 4020 LIBERAL ELEM.   Regular School No Elementary PK 05 2021   k_12_total                                                   118                                             118
3069318 3069318 MO     school 2912930 6103   GOLDEN CITY R-III 291293000542 1050 GOLDEN CITY HIGH   Regular School No High 07 12 2021   k_12_total                                                   94                                             94
3069319 3069319 MO     school 2912930 6103   GOLDEN CITY R-III 291293000541 4020 GOLDEN CITY ELEM.   Regular School No Elementary KG 06 2021   k_12_total                                                   88                                             88
3069321 3069321 MO     school 2917850 6104   LAMAR R-I 291785000954 1050 LAMAR HIGH   Regular School No High 09 12 2021   k_12_total                                                   391                                             391
3069322 3069322 MO     school 2917850 6104   LAMAR R-I 291785002467 3000 LAMAR MIDDLE   Regular School No Middle 06 08 2021   k_12_total                                                   300                                             300
3069323 3069323 MO     school 2917850 6104   LAMAR R-I 291785000953 4020 LAMAR ELEM.   Regular School No Elementary 03 05 2021   k_12_total                                                   252                                             252
3069324 3069324 MO     school 2917850 6104   LAMAR R-I 291785002720 4040 EAST ELEM.   Regular School No Elementary PK 02 2021   k_12_total                                                   234                                             234
3069325 3069325 MO     school 2920820 7121   MIAMI R-I 292082001139 1050 MIAMI HIGH   Regular School No High 07 12 2021   k_12_total                                                   85                                             85
3069326 3069326 MO     school 2920820 7121   MIAMI R-I 292082001138 4020 MIAMI ELEM.   Regular School No Elementary PK 06 2021   k_12_total                                                   81                                             81
3069327 3069327 MO     school 2904170 7122   BALLARD R-II 290417000042 1050 BALLARD HIGH   Regular School No High 07 12 2021   k_12_total                                                   51                                             51
3069328 3069328 MO     school 2904170 7122   BALLARD R-II 290417000041 4020 BALLARD ELEM.   Regular School No Elementary KG 06 2021   k_12_total                                                   67                                             67
3069329 3069329 MO     school 2902850 7123   ADRIAN R-III 290285000002 1050 ADRIAN SR. HIGH   Regular School No High 06 12 2021   k_12_total                                                   382                                             382
3069330 3069330 MO     school 2902850 7123   ADRIAN R-III 290285000001 4020 ADRIAN ELEM.   Regular School No Elementary PK 05 2021   k_12_total                                                   300                                             300
3069331 3069331 MO     school 2926310 7124   RICH HILL R-IV 292631001544 1050 RICH HILL HIGH   Regular School No High 06 12 2021   k_12_total                                                   171                                             171

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