Data source: Big Local News · About: Big Local

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

View and edit SQL

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
3296833 MO     school 2910020 4106   COMMUNITY R-VI 291002000319 1050 COMMUNITY HIGH   Regular School No High 06 12 2019   k_12_total 165 * * *   *       * *           *         82   22   169 165                                     82 22   169
3296834 MO     school 2910020 4106   COMMUNITY R-VI 291002000319 1050 COMMUNITY HIGH   Regular School No High 06 12 2020   k_12_total 162 * * *   *       * *           *         77   20   164 162                                     77 20   164
3296835 MO     school 2910020 4106   COMMUNITY R-VI 291002000318 4020 COMMUNITY ELEM.   Regular School No 1 PK 05 2015   k_12_total 111 * * *   *       * *           *         75   16   116 111                                     75 16   116
3296836 MO     school 2910020 4106   COMMUNITY R-VI 291002000318 4020 COMMUNITY ELEM.   Regular School No 1 PK 05 2016   k_12_total 105 * * *   *       * *           *         69   21   110 105                                     69 21   110
3296837 MO     school 2910020 4106   COMMUNITY R-VI 291002000318 4020 COMMUNITY ELEM.   Regular School No Elementary PK 05 2017   k_12_total 115 * * *   *       * 6           *         75   25   122 115                   6                 75 25   122
3296838 MO     school 2910020 4106   COMMUNITY R-VI 291002000318 4020 COMMUNITY ELEM.   Regular School No Elementary PK 05 2018   k_12_total 114 * * *   *       * 6           *         83   33   123 114                   6                 83 33   123
3296839 MO     school 2910020 4106   COMMUNITY R-VI 291002000318 4020 COMMUNITY ELEM.   Regular School No Elementary PK 05 2019   k_12_total 117 * * *   *       * 5           *         82   24   123 117                   5                 82 24   123
3296840 MO     school 2910020 4106   COMMUNITY R-VI 291002000318 4020 COMMUNITY ELEM.   Regular School No Elementary PK 05 2020   k_12_total 127 * * *   *       * *           *         83   32   131 127                                     83 32   131
3296879 MO     school 2920810 4110   MEXICO 59 292081001134 4080 MCMILLAN ELEM.   Regular School No Elementary PK 05 2017   k_12_total 181 10 * *   *       * 19           *         *   23   214 181 10                 19                   23   214
3296913 MO     school 2911670 5122   EXETER R-VI 291167000427 1050 EXETER HIGH   Regular School No 3 09 12 2015   k_12_total 106 * * *   *       * *           *         75   *   109 106                                     75     109
3296914 MO     school 2911670 5122   EXETER R-VI 291167000427 1050 EXETER HIGH   Regular School No 3 09 12 2016   k_12_total 100 * * *   *       * *           *         81   *   106 100                                     81     106
3296915 MO     school 2911670 5122   EXETER R-VI 291167000427 1050 EXETER HIGH   Regular School No High 09 12 2017   k_12_total 87 * * *   *       * *           *         66   7   92 87                                     66 7   92
3296917 MO     school 2911670 5122   EXETER R-VI 291167000427 1050 EXETER HIGH   Regular School No High 09 12 2019   k_12_total 94 * * *   9       * *           *         74   11   109 94         9                           74 11   109
3296918 MO     school 2911670 5122   EXETER R-VI 291167000427 1050 EXETER HIGH   Regular School No High 09 12 2020   k_12_total 71 * * *   9       * *           *         52   13   86 71         9                           52 13   86
3296951 MO     school 2925620 5124   PURDY R-II 292562001502 1050 PURDY HIGH   Regular School No High 09 12 2017   k_12_total 126 * * *   5       54 *           12         92   15   191 126         5       54             12     92 15   191
3296957 MO     school 2925620 5124   PURDY R-II 292562002221 3000 PURDY MIDDLE   Regular School No Middle 05 08 2017   k_12_total 149 * * *   7       44 *           12         136.3   25   206 149         7       44             12       25   206
3296965 MO     school 2928200 5127   SHELL KNOB 78 292820003350 1010 TRI-LAKES SPECL. EDUC. COOP.   Regular School No Other PK 12 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3296966 MO     school 2928200 5127   SHELL KNOB 78 292820001735 4020 SHELL KNOB ELEM.   Regular School No 1 PK 08 2015   k_12_total 112 * * *   *       * 5           *         *   20   122 112                   5                   20   122
3296967 MO     school 2928200 5127   SHELL KNOB 78 292820001735 4020 SHELL KNOB ELEM.   Regular School No 1 PK 08 2016   k_12_total 111 * * *   *       * 7           *         *   19   121 111                   7                   19   121
3296968 MO     school 2928200 5127   SHELL KNOB 78 292820001735 4020 SHELL KNOB ELEM.   Regular School No Elementary PK 08 2017   k_12_total 112 * * *   *       * 8           *         *   22   123 112                   8                   22   123
3296969 MO     school 2928200 5127   SHELL KNOB 78 292820001735 4020 SHELL KNOB ELEM.   Regular School No Elementary PK 08 2018   k_12_total 117 * * *   *       * 8           *         *   21   131 117                   8                   21   131
3296970 MO     school 2928200 5127   SHELL KNOB 78 292820001735 4020 SHELL KNOB ELEM.   Regular School No Elementary PK 08 2019   k_12_total 113 * * *   *       * *           *         *   14   120 113                                       14   120
3296971 MO     school 2928200 5127   SHELL KNOB 78 292820001735 4020 SHELL KNOB ELEM.   Regular School No Elementary PK 08 2020   k_12_total 72 * * *   *       * 60           *         *   21   133 72                   60                   21   133
3297002 MO     school 2918510 6101   LIBERAL R-II 291851001003 1050 LIBERAL HIGH   Regular School No 3 09 12 2015   k_12_total 142 * * *   *       * *           *         69   19   148 142                                     69 19   148
3297003 MO     school 2918510 6101   LIBERAL R-II 291851001003 1050 LIBERAL HIGH   Regular School No 3 09 12 2016   k_12_total 142 * * *   *       * *           *         64.2   27   148 142                                       27   148
3297009 MO     school 2918510 6101   LIBERAL R-II 291851002719 3000 LIBERAL MIDDLE   Regular School No 2 06 08 2016   k_12_total 91 * * *   *       * *           *         55   10   97 91                                     55 10   97
3297010 MO     school 2918510 6101   LIBERAL R-II 291851002719 3000 LIBERAL MIDDLE   Regular School No Middle 06 08 2017   k_12_total 85 * * *   *       * *           *         53   8   90 85                                     53 8   90
3297011 MO     school 2918510 6101   LIBERAL R-II 291851002719 3000 LIBERAL MIDDLE   Regular School No Middle 06 08 2018   k_12_total 86 * * *   *       * *           *         52   5   90 86                                     52 5   90
3297012 MO     school 2918510 6101   LIBERAL R-II 291851002719 3000 LIBERAL MIDDLE   Regular School No Middle 06 08 2019   k_12_total 87 * * *   *       * *           *         51   7   92 87                                     51 7   92
3297013 MO     school 2918510 6101   LIBERAL R-II 291851002719 3000 LIBERAL MIDDLE   Regular School No Middle 06 08 2020   k_12_total 94 * * *   *       * *           *         51   15   100 94                                     51 15   100
3297014 MO     school 2918510 6101   LIBERAL R-II 291851001002 4020 LIBERAL ELEM.   Regular School No 1 PK 05 2015   k_12_total 177 6 * *   *       * *           *         125   20   188 177 6                                   125 20   188
3297015 MO     school 2918510 6101   LIBERAL R-II 291851001002 4020 LIBERAL ELEM.   Regular School No 1 PK 05 2016   k_12_total 165 5 * *   *       * *           *         114   21   174 165 5                                   114 21   174
3297016 MO     school 2918510 6101   LIBERAL R-II 291851001002 4020 LIBERAL ELEM.   Regular School No Elementary PK 05 2017   k_12_total 166 7 * *   *       * *           *         104   22   181 166 7                                   104 22   181
3297017 MO     school 2918510 6101   LIBERAL R-II 291851001002 4020 LIBERAL ELEM.   Regular School No Elementary PK 05 2018   k_12_total 153 * * *   *       * *           *         94   20   165 153                                     94 20   165
3297019 MO     school 2918510 6101   LIBERAL R-II 291851001002 4020 LIBERAL ELEM.   Regular School No Elementary PK 05 2020   k_12_total 137 * * *   *       * 8           *         72   21   150 137                   8                 72 21   150
3297020 MO     school 2912930 6103   GOLDEN CITY R-III 291293000542 1050 GOLDEN CITY HIGH   Regular School No 3 07 12 2015   k_12_total 84 * * *   *       * 5           *         57   15   95 84                   5                 57 15   95
3297021 MO     school 2912930 6103   GOLDEN CITY R-III 291293000542 1050 GOLDEN CITY HIGH   Regular School No 3 07 12 2016   k_12_total 81 * * *   *       * 5           *         65   15   91 81                   5                 65 15   91
3297023 MO     school 2912930 6103   GOLDEN CITY R-III 291293000542 1050 GOLDEN CITY HIGH   Regular School No High 07 12 2018   k_12_total 84 * * *   *       * 8           *         62   16   97 84                   8                 62 16   97
3297024 MO     school 2912930 6103   GOLDEN CITY R-III 291293000542 1050 GOLDEN CITY HIGH   Regular School No High 07 12 2019   k_12_total 75 * * *   *       * 6           *         56   13   85 75                   6                 56 13   85
3297026 MO     school 2912930 6103   GOLDEN CITY R-III 291293000541 4020 GOLDEN CITY ELEM.   Regular School No 1 KG 06 2015   k_12_total 106 * * *   *       * 8           *         83   20   115 106                   8                 83 20   115
3297027 MO     school 2912930 6103   GOLDEN CITY R-III 291293000541 4020 GOLDEN CITY ELEM.   Regular School No 1 KG 06 2016   k_12_total 106 * * *   *       * 9           *         82.4   18   116 106                   9                   18   116
3297028 MO     school 2912930 6103   GOLDEN CITY R-III 291293000541 4020 GOLDEN CITY ELEM.   Regular School No Elementary KG 06 2017   k_12_total 90 * * *   *       * 12           *         70   14   102 90                   12                 70 14   102
3297029 MO     school 2912930 6103   GOLDEN CITY R-III 291293000541 4020 GOLDEN CITY ELEM.   Regular School No Elementary KG 06 2018   k_12_total 85 * * *   *       * 10           *         62   14   96 85                   10                 62 14   96
3297030 MO     school 2912930 6103   GOLDEN CITY R-III 291293000541 4020 GOLDEN CITY ELEM.   Regular School No Elementary KG 06 2019   k_12_total 84 * * *   *       * 7           *         61   17   93 84                   7                 61 17   93
3297031 MO     school 2912930 6103   GOLDEN CITY R-III 291293000541 4020 GOLDEN CITY ELEM.   Regular School No Elementary KG 06 2020   k_12_total 81 * * *   *       * 11           *         73   9   95 81                   11                 73 9   95
3297032 MO     school 2917850 6104   LAMAR R-I 291785001487 1010 LOCKWOOD SPECL. EDUC. COOP.   Special Education School No 4 PK 12 2015   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297033 MO     school 2917850 6104   LAMAR R-I 291785001487 1010 LOCKWOOD SPECL. EDUC. COOP.   Special Education School No 4 PK 12 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297034 MO     school 2917850 6104   LAMAR R-I 291785001487 1010 LOCKWOOD SPECL. EDUC. COOP.   Special Education School No Other PK 12 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297035 MO     school 2917850 6104   LAMAR R-I 291785001487 1010 LOCKWOOD SPECL. EDUC. COOP.   Special Education School No Other PK 12 2018   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297036 MO     school 2917850 6104   LAMAR R-I 291785001487 1010 LOCKWOOD SPECL. EDUC. COOP.   Special Education School No Other PK 12 2019   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297037 MO     school 2917850 6104   LAMAR R-I 291785001487 1010 LOCKWOOD SPECL. EDUC. COOP.   Special Education School No Other PK 12 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297062 MO     school 2920820 7121   MIAMI R-I 292082001139 1050 MIAMI HIGH   Regular School No 3 07 12 2015   k_12_total 65 * * 6   *       * *           *         39   7   74 65     6                               39 7   74
3297063 MO     school 2920820 7121   MIAMI R-I 292082001139 1050 MIAMI HIGH   Regular School No 3 07 12 2016   k_12_total 79 * * 7   *       * *           *         42   7   92 79     7                               42 7   92
3297071 MO     school 2920820 7121   MIAMI R-I 292082001138 4020 MIAMI ELEM.   Regular School No Elementary PK 06 2018   k_12_total 59 * * *   *       * *           *         47   12   67 59                                     47 12   67
3297072 MO     school 2920820 7121   MIAMI R-I 292082001138 4020 MIAMI ELEM.   Regular School No Elementary PK 06 2019   k_12_total 67 * * *   *       * *           *         43   10   74 67                                     43 10   74
3297073 MO     school 2920820 7121   MIAMI R-I 292082001138 4020 MIAMI ELEM.   Regular School No Elementary PK 06 2020   k_12_total 77 * * *   *       * 10           *         36   7   90 77                   10                 36 7   90
3297074 MO     school 2904170 7122   BALLARD R-II 290417000042 1050 BALLARD HIGH   Regular School No 3 07 12 2015   k_12_total 65 * * *   *       * *           *         27   10   67 65                                     27 10   67
3297075 MO     school 2904170 7122   BALLARD R-II 290417000042 1050 BALLARD HIGH   Regular School No 3 07 12 2016   k_12_total 57 * * *   *       * *           *         28   9   60 57                                     28 9   60
3297076 MO     school 2904170 7122   BALLARD R-II 290417000042 1050 BALLARD HIGH   Regular School No High 07 12 2017   k_12_total 52 * * *   *       * *           *         22.3   9   56 52                                       9   56
3297077 MO     school 2904170 7122   BALLARD R-II 290417000042 1050 BALLARD HIGH   Regular School No High 07 12 2018   k_12_total 53 * * *   *       * *           *         28   11   56 53                                     28 11   56
3297078 MO     school 2904170 7122   BALLARD R-II 290417000042 1050 BALLARD HIGH   Regular School No High 07 12 2019   k_12_total 48 * * *   *       * *           *         30   8   51 48                                     30 8   51
3297079 MO     school 2904170 7122   BALLARD R-II 290417000042 1050 BALLARD HIGH   Regular School No High 07 12 2020   k_12_total 42 * * *   *       * *           *         22   7   46 42                                     22 7   46
3297082 MO     school 2904170 7122   BALLARD R-II 290417000041 4020 BALLARD ELEM.   Regular School No Elementary PK 06 2017   k_12_total 66 * * *   *       * *           *         43   14   72 66                                     43 14   72
3297083 MO     school 2904170 7122   BALLARD R-II 290417000041 4020 BALLARD ELEM.   Regular School No Elementary KG 06 2018   k_12_total 64 * * *   *       * *           *         41   12   70 64                                     41 12   70
3297084 MO     school 2904170 7122   BALLARD R-II 290417000041 4020 BALLARD ELEM.   Regular School No Elementary KG 06 2019   k_12_total 59 * * *   *       * *           *         36   12   64 59                                     36 12   64
3297085 MO     school 2904170 7122   BALLARD R-II 290417000041 4020 BALLARD ELEM.   Regular School No Elementary KG 06 2020   k_12_total 60 * * *   *       * *           *         29   13   67 60                                     29 13   67
3297086 MO     school 2902850 7123   ADRIAN R-III 290285000002 1050 ADRIAN SR. HIGH   Regular School No 4 06 12 2015   k_12_total 384 8 * *   *       * *           *         151   34   396 384 8                                   151 34   396
3297087 MO     school 2902850 7123   ADRIAN R-III 290285000002 1050 ADRIAN SR. HIGH   Regular School No 4 06 12 2016   k_12_total 373 8 * *   *       * *           *         140   36   385 373 8                                   140 36   385
3297088 MO     school 2902850 7123   ADRIAN R-III 290285000002 1050 ADRIAN SR. HIGH   Regular School No Other 06 12 2017   k_12_total 346 * * *   *       * *           *         107   33   353 346                                     107 33   353
3297089 MO     school 2902850 7123   ADRIAN R-III 290285000002 1050 ADRIAN SR. HIGH   Regular School No High 06 12 2018   k_12_total 348 * * *   *       * *           *         122   24   357 348                                     122 24   357
3297092 MO     school 2902850 7123   ADRIAN R-III 290285000001 4020 ADRIAN ELEM.   Regular School No 1 PK 05 2015   k_12_total 319 * * *   *       * *           *         146   31   322 319                                     146 31   322
3297093 MO     school 2902850 7123   ADRIAN R-III 290285000001 4020 ADRIAN ELEM.   Regular School No 1 PK 05 2016   k_12_total 309 * * *   *       * *           *         128   36   313 309                                     128 36   313
3297094 MO     school 2902850 7123   ADRIAN R-III 290285000001 4020 ADRIAN ELEM.   Regular School No Elementary PK 05 2017   k_12_total 325 * * *   *       * *           *         145   36   328 325                                     145 36   328
3297095 MO     school 2902850 7123   ADRIAN R-III 290285000001 4020 ADRIAN ELEM.   Regular School No Elementary PK 05 2018   k_12_total 303 * * *   *       * *           *         139   38   306 303                                     139 38   306
3297098 MO     school 2926310 7124   RICH HILL R-IV 292631001544 1050 RICH HILL HIGH   Regular School No 3 07 12 2015   k_12_total 186 * * *   *       * *           *         106   16   193 186                                     106 16   193
3297099 MO     school 2926310 7124   RICH HILL R-IV 292631001544 1050 RICH HILL HIGH   Regular School No 3 07 12 2016   k_12_total 170 * * *   *       * *           *         103   18   174 170                                     103 18   174
3297100 MO     school 2926310 7124   RICH HILL R-IV 292631001544 1050 RICH HILL HIGH   Regular School No High 07 12 2017   k_12_total 156 * * *   *       * *           *         99   19   158 156                                     99 19   158
3297101 MO     school 2926310 7124   RICH HILL R-IV 292631001544 1050 RICH HILL HIGH   Regular School No High 07 12 2018   k_12_total 149 * * *   *       * *           *         96.3   22   153 149                                       22   153
3297102 MO     school 2926310 7124   RICH HILL R-IV 292631001544 1050 RICH HILL HIGH   Regular School No High 07 12 2019   k_12_total 142 * * *   *       * *           *         93   15   148 142                                     93 15   148
3297103 MO     school 2926310 7124   RICH HILL R-IV 292631001544 1050 RICH HILL HIGH   Regular School No High 07 12 2020   k_12_total 144 * * *   *       * *           *         94   16   150 144                                     94 16   150
3297104 MO     school 2926310 7124   RICH HILL R-IV 292631001545 4020 RICH HILL ELEM.   Regular School No 1 PK 06 2015   k_12_total 184 * * *   *       * *           *         *   25   190 184                                       25   190
3297105 MO     school 2926310 7124   RICH HILL R-IV 292631001545 4020 RICH HILL ELEM.   Regular School No 1 PK 06 2016   k_12_total 176 * * *   *       * 8           *         *   23   188 176                   8                   23   188
3297106 MO     school 2926310 7124   RICH HILL R-IV 292631001545 4020 RICH HILL ELEM.   Regular School No Elementary PK 06 2017   k_12_total 150 * * *   *       * 7           *         *   23   161 150                   7                   23   161
3297107 MO     school 2926310 7124   RICH HILL R-IV 292631001545 4020 RICH HILL ELEM.   Regular School No Elementary KG 06 2018   k_12_total 150 * * *   *       6 8           *         *   26   170 150                 6 8                   26   170
3297108 MO     school 2926310 7124   RICH HILL R-IV 292631001545 4020 RICH HILL ELEM.   Regular School No Elementary PK 06 2019   k_12_total 144 10 * *   *       * *           *         99   27   162 144 10                                   99 27   162
3297109 MO     school 2926310 7124   RICH HILL R-IV 292631001545 4020 RICH HILL ELEM.   Regular School No Elementary PK 06 2020   k_12_total 159 7 * *   *       * *           *         111.1   25   176 159 7                                     25   176
3297110 MO     school 2915330 7125   HUME R-VIII 291533000699 1050 HUME HIGH   Regular School No 3 07 12 2015   k_12_total 67 * * *   *       * *           *         41   7   69 67                                     41 7   69
3297111 MO     school 2915330 7125   HUME R-VIII 291533000699 1050 HUME HIGH   Regular School No 3 07 12 2016   k_12_total 60 * * *   *       * *           *         41   7   61 60                                     41 7   61
3297112 MO     school 2915330 7125   HUME R-VIII 291533000699 1050 HUME HIGH   Regular School No High 07 12 2017   k_12_total 59 * * *   *       * *           *         31   5   60 59                                     31 5   60
3297113 MO     school 2915330 7125   HUME R-VIII 291533000699 1050 HUME HIGH   Regular School No High 07 12 2018   k_12_total 65 * * *   *       * *           *         26   5   66 65                                     26 5   66
3297114 MO     school 2915330 7125   HUME R-VIII 291533000699 1050 HUME HIGH   Regular School No High 07 12 2019   k_12_total 64 * * *   *       * *           *         31   *   66 64                                     31     66
3297115 MO     school 2915330 7125   HUME R-VIII 291533000699 1050 HUME HIGH   Regular School No High 07 12 2020   k_12_total 60 * * *   *       * 5           *         24   *   65 60                   5                 24     65
3297116 MO     school 2915330 7125   HUME R-VIII 291533000698 4020 HUME ELEM.   Regular School No 1 PK 06 2015   k_12_total 96 * * *   *       * *           *         64   14   97 96                                     64 14   97
3297117 MO     school 2915330 7125   HUME R-VIII 291533000698 4020 HUME ELEM.   Regular School No 1 PK 06 2016   k_12_total 86 * * *   *       * *           *         56   13   88 86                                     56 13   88
3297118 MO     school 2915330 7125   HUME R-VIII 291533000698 4020 HUME ELEM.   Regular School No Elementary PK 06 2017   k_12_total 82 * * *   *       * *           *         62   13   85 82                                     62 13   85
3297119 MO     school 2915330 7125   HUME R-VIII 291533000698 4020 HUME ELEM.   Regular School No Elementary PK 06 2018   k_12_total 75 * * *   *       * *           *         44   14   77 75                                     44 14   77
3297120 MO     school 2915330 7125   HUME R-VIII 291533000698 4020 HUME ELEM.   Regular School No Elementary PK 06 2019   k_12_total 61 * * *   *       * *           *         52   13   68 61                                     52 13   68
3297121 MO     school 2915330 7125   HUME R-VIII 291533000698 4020 HUME ELEM.   Regular School No Elementary PK 06 2020   k_12_total 61 * * *   *       * *           *         39   8   67 61                                     39 8   67
3297122 MO     school 2915240 7126   HUDSON R-IX 291524000693 4020 HUDSON ELEM.   Regular School No 1 PK 08 2015   k_12_total 36 * * *   *       * *           *         8   *   38 36                                     8     38
3297123 MO     school 2915240 7126   HUDSON R-IX 291524000693 4020 HUDSON ELEM.   Regular School No 1 PK 08 2016   k_12_total 42 * * *   *       * *           *         6   5   42 42                                     6 5   42

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