enrollments

Data source: Big Local News · About: Big Local

29,176 rows where state = "UT" sorted by district descending

✎ View and edit SQL

This data as json, CSV (advanced)

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
1192968 1192968 UT     school 4900168 8I Charter Winter Sports School 490016801444 700 Winter Sports School   Regular School Yes High 09 12 2020   k_12_total 101.0 0.0 3.0 0.0   1.0       0.0 4.0   62.0 47.0     0.0   0.0   0.0     0.0   109 101 0 3 0   1       0 4   62 47     0 0 0   0   109
1194005 1194005 UT     school 4900168 8I Charter Winter Sports School 490016801444 700 Winter Sports School   Regular School Yes High 09 12 2020   kindergarten                                                   0                                             0
1195042 1195042 UT     school 4900168 8I Charter Winter Sports School 490016801444 700 Winter Sports School   Regular School Yes High 09 12 2020   grade_1                                                   0                                             0
1196079 1196079 UT     school 4900168 8I Charter Winter Sports School 490016801444 700 Winter Sports School   Regular School Yes High 09 12 2020   grade_2                                                   0                                             0
1197116 1197116 UT     school 4900168 8I Charter Winter Sports School 490016801444 700 Winter Sports School   Regular School Yes High 09 12 2020   grade_3                                                   0                                             0
1198153 1198153 UT     school 4900168 8I Charter Winter Sports School 490016801444 700 Winter Sports School   Regular School Yes High 09 12 2020   grade_4                                                   0                                             0
1199190 1199190 UT     school 4900168 8I Charter Winter Sports School 490016801444 700 Winter Sports School   Regular School Yes High 09 12 2020   grade_5                                                   0                                             0
1200227 1200227 UT     school 4900168 8I Charter Winter Sports School 490016801444 700 Winter Sports School   Regular School Yes High 09 12 2020   grade_6                                                   0                                             0
1201264 1201264 UT     school 4900168 8I Charter Winter Sports School 490016801444 700 Winter Sports School   Regular School Yes High 09 12 2020   grade_7                                                   0                                             0
1202301 1202301 UT     school 4900168 8I Charter Winter Sports School 490016801444 700 Winter Sports School   Regular School Yes High 09 12 2020   grade_8                                                   0                                             0
1203338 1203338 UT     school 4900168 8I Charter Winter Sports School 490016801444 700 Winter Sports School   Regular School Yes High 09 12 2020   grade_9                                                   25                                             25
1204375 1204375 UT     school 4900168 8I Charter Winter Sports School 490016801444 700 Winter Sports School   Regular School Yes High 09 12 2020   grade_10                                                   29                                             29
1205412 1205412 UT     school 4900168 8I Charter Winter Sports School 490016801444 700 Winter Sports School   Regular School Yes High 09 12 2020   grade_11                                                   28                                             28
1206449 1206449 UT     school 4900168 8I Charter Winter Sports School 490016801444 700 Winter Sports School   Regular School Yes High 09 12 2020   grade_12                                                   27                                             27
1351172 1351172 UT     school 4900168 8I Charter Winter Sports School 490016801444 700 Winter Sports School   Regular School Yes High 09 12 2021   k_12_total 102.0 0.0 3.0 0.0   2.0       0.0 2.0   62.0 47.0     0.0   0.0   0.0     0.0   109 102 0 3 0   2       0 2   62 47     0 0 0   0   109
1352219 1352219 UT     school 4900168 8I Charter Winter Sports School 490016801444 700 Winter Sports School   Regular School Yes High 09 12 2021   kindergarten                                                   0                                             0
1353266 1353266 UT     school 4900168 8I Charter Winter Sports School 490016801444 700 Winter Sports School   Regular School Yes High 09 12 2021   grade_1                                                   0                                             0
1354313 1354313 UT     school 4900168 8I Charter Winter Sports School 490016801444 700 Winter Sports School   Regular School Yes High 09 12 2021   grade_2                                                   0                                             0
1355360 1355360 UT     school 4900168 8I Charter Winter Sports School 490016801444 700 Winter Sports School   Regular School Yes High 09 12 2021   grade_3                                                   0                                             0
1356407 1356407 UT     school 4900168 8I Charter Winter Sports School 490016801444 700 Winter Sports School   Regular School Yes High 09 12 2021   grade_4                                                   0                                             0
1357454 1357454 UT     school 4900168 8I Charter Winter Sports School 490016801444 700 Winter Sports School   Regular School Yes High 09 12 2021   grade_5                                                   0                                             0
1358501 1358501 UT     school 4900168 8I Charter Winter Sports School 490016801444 700 Winter Sports School   Regular School Yes High 09 12 2021   grade_6                                                   0                                             0
1359548 1359548 UT     school 4900168 8I Charter Winter Sports School 490016801444 700 Winter Sports School   Regular School Yes High 09 12 2021   grade_7                                                   0                                             0
1360595 1360595 UT     school 4900168 8I Charter Winter Sports School 490016801444 700 Winter Sports School   Regular School Yes High 09 12 2021   grade_8                                                   0                                             0
1361642 1361642 UT     school 4900168 8I Charter Winter Sports School 490016801444 700 Winter Sports School   Regular School Yes High 09 12 2021   grade_9                                                   29                                             29
1362689 1362689 UT     school 4900168 8I Charter Winter Sports School 490016801444 700 Winter Sports School   Regular School Yes High 09 12 2021   grade_10                                                   27                                             27
1363736 1363736 UT     school 4900168 8I Charter Winter Sports School 490016801444 700 Winter Sports School   Regular School Yes High 09 12 2021   grade_11                                                   27                                             27
1364783 1364783 UT     school 4900168 8I Charter Winter Sports School 490016801444 700 Winter Sports School   Regular School Yes High 09 12 2021   grade_12                                                   26                                             26
1192967 1192967 UT     school 4900145 6G Charter Weilenmann School of Discovery 490014501378 100 Weilenmann School of Discovery   Regular School Yes Elementary KG 08 2020   k_12_total 502.0 8.0 27.0 1.0   16.0       1.0 8.0   297.0 266.0     10.0   0.0   36.0     31.0   563 502 8 27 1   16       1 8   297 266     10 0 36   31   563
1194004 1194004 UT     school 4900145 6G Charter Weilenmann School of Discovery 490014501378 100 Weilenmann School of Discovery   Regular School Yes Elementary KG 08 2020   kindergarten                                                   35                                             35
1195041 1195041 UT     school 4900145 6G Charter Weilenmann School of Discovery 490014501378 100 Weilenmann School of Discovery   Regular School Yes Elementary KG 08 2020   grade_1                                                   74                                             74
1196078 1196078 UT     school 4900145 6G Charter Weilenmann School of Discovery 490014501378 100 Weilenmann School of Discovery   Regular School Yes Elementary KG 08 2020   grade_2                                                   69                                             69
1197115 1197115 UT     school 4900145 6G Charter Weilenmann School of Discovery 490014501378 100 Weilenmann School of Discovery   Regular School Yes Elementary KG 08 2020   grade_3                                                   71                                             71
1198152 1198152 UT     school 4900145 6G Charter Weilenmann School of Discovery 490014501378 100 Weilenmann School of Discovery   Regular School Yes Elementary KG 08 2020   grade_4                                                   49                                             49
1199189 1199189 UT     school 4900145 6G Charter Weilenmann School of Discovery 490014501378 100 Weilenmann School of Discovery   Regular School Yes Elementary KG 08 2020   grade_5                                                   83                                             83
1200226 1200226 UT     school 4900145 6G Charter Weilenmann School of Discovery 490014501378 100 Weilenmann School of Discovery   Regular School Yes Elementary KG 08 2020   grade_6                                                   58                                             58
1201263 1201263 UT     school 4900145 6G Charter Weilenmann School of Discovery 490014501378 100 Weilenmann School of Discovery   Regular School Yes Elementary KG 08 2020   grade_7                                                   73                                             73
1202300 1202300 UT     school 4900145 6G Charter Weilenmann School of Discovery 490014501378 100 Weilenmann School of Discovery   Regular School Yes Elementary KG 08 2020   grade_8                                                   51                                             51
1203337 1203337 UT     school 4900145 6G Charter Weilenmann School of Discovery 490014501378 100 Weilenmann School of Discovery   Regular School Yes Elementary KG 08 2020   grade_9                                                   0                                             0
1204374 1204374 UT     school 4900145 6G Charter Weilenmann School of Discovery 490014501378 100 Weilenmann School of Discovery   Regular School Yes Elementary KG 08 2020   grade_10                                                   0                                             0
1205411 1205411 UT     school 4900145 6G Charter Weilenmann School of Discovery 490014501378 100 Weilenmann School of Discovery   Regular School Yes Elementary KG 08 2020   grade_11                                                   0                                             0
1206448 1206448 UT     school 4900145 6G Charter Weilenmann School of Discovery 490014501378 100 Weilenmann School of Discovery   Regular School Yes Elementary KG 08 2020   grade_12                                                   0                                             0
1351171 1351171 UT     school 4900145 6G Charter Weilenmann School of Discovery 490014501378 100 Weilenmann School of Discovery   Regular School Yes Elementary KG 08 2021   k_12_total 520.0 4.0 31.0 1.0   12.0       1.0 12.0   324.0 257.0     8.0   0.0   27.0     48.0   581 520 4 31 1   12       1 12   324 257     8 0 27   48   581
1352218 1352218 UT     school 4900145 6G Charter Weilenmann School of Discovery 490014501378 100 Weilenmann School of Discovery   Regular School Yes Elementary KG 08 2021   kindergarten                                                   64                                             64
1353265 1353265 UT     school 4900145 6G Charter Weilenmann School of Discovery 490014501378 100 Weilenmann School of Discovery   Regular School Yes Elementary KG 08 2021   grade_1                                                   47                                             47
1354312 1354312 UT     school 4900145 6G Charter Weilenmann School of Discovery 490014501378 100 Weilenmann School of Discovery   Regular School Yes Elementary KG 08 2021   grade_2                                                   69                                             69
1355359 1355359 UT     school 4900145 6G Charter Weilenmann School of Discovery 490014501378 100 Weilenmann School of Discovery   Regular School Yes Elementary KG 08 2021   grade_3                                                   71                                             71
1356406 1356406 UT     school 4900145 6G Charter Weilenmann School of Discovery 490014501378 100 Weilenmann School of Discovery   Regular School Yes Elementary KG 08 2021   grade_4                                                   71                                             71
1357453 1357453 UT     school 4900145 6G Charter Weilenmann School of Discovery 490014501378 100 Weilenmann School of Discovery   Regular School Yes Elementary KG 08 2021   grade_5                                                   52                                             52
1358500 1358500 UT     school 4900145 6G Charter Weilenmann School of Discovery 490014501378 100 Weilenmann School of Discovery   Regular School Yes Elementary KG 08 2021   grade_6                                                   81                                             81
1359547 1359547 UT     school 4900145 6G Charter Weilenmann School of Discovery 490014501378 100 Weilenmann School of Discovery   Regular School Yes Elementary KG 08 2021   grade_7                                                   58                                             58
1360594 1360594 UT     school 4900145 6G Charter Weilenmann School of Discovery 490014501378 100 Weilenmann School of Discovery   Regular School Yes Elementary KG 08 2021   grade_8                                                   68                                             68
1361641 1361641 UT     school 4900145 6G Charter Weilenmann School of Discovery 490014501378 100 Weilenmann School of Discovery   Regular School Yes Elementary KG 08 2021   grade_9                                                   0                                             0
1362688 1362688 UT     school 4900145 6G Charter Weilenmann School of Discovery 490014501378 100 Weilenmann School of Discovery   Regular School Yes Elementary KG 08 2021   grade_10                                                   0                                             0
1363735 1363735 UT     school 4900145 6G Charter Weilenmann School of Discovery 490014501378 100 Weilenmann School of Discovery   Regular School Yes Elementary KG 08 2021   grade_11                                                   0                                             0
1364782 1364782 UT     school 4900145 6G Charter Weilenmann School of Discovery 490014501378 100 Weilenmann School of Discovery   Regular School Yes Elementary KG 08 2021   grade_12                                                   0                                             0
1192966 1192966 UT     school 4900167 7I Charter Weber State University Charter Academy 490016701447 100 Weber State University Charter Academy   Regular School Yes Elementary KG KG 2020   k_12_total 26.0 1.0 1.0 0.0   2.0       0.0 3.0   13.0 20.0     0.0   0.0   10.0     0.0   33 26 1 1 0   2       0 3   13 20     0 0 10   0   33
1194003 1194003 UT     school 4900167 7I Charter Weber State University Charter Academy 490016701447 100 Weber State University Charter Academy   Regular School Yes Elementary KG KG 2020   kindergarten                                                   33                                             33
1195040 1195040 UT     school 4900167 7I Charter Weber State University Charter Academy 490016701447 100 Weber State University Charter Academy   Regular School Yes Elementary KG KG 2020   grade_1                                                   0                                             0
1196077 1196077 UT     school 4900167 7I Charter Weber State University Charter Academy 490016701447 100 Weber State University Charter Academy   Regular School Yes Elementary KG KG 2020   grade_2                                                   0                                             0
1197114 1197114 UT     school 4900167 7I Charter Weber State University Charter Academy 490016701447 100 Weber State University Charter Academy   Regular School Yes Elementary KG KG 2020   grade_3                                                   0                                             0
1198151 1198151 UT     school 4900167 7I Charter Weber State University Charter Academy 490016701447 100 Weber State University Charter Academy   Regular School Yes Elementary KG KG 2020   grade_4                                                   0                                             0
1199188 1199188 UT     school 4900167 7I Charter Weber State University Charter Academy 490016701447 100 Weber State University Charter Academy   Regular School Yes Elementary KG KG 2020   grade_5                                                   0                                             0
1200225 1200225 UT     school 4900167 7I Charter Weber State University Charter Academy 490016701447 100 Weber State University Charter Academy   Regular School Yes Elementary KG KG 2020   grade_6                                                   0                                             0
1201262 1201262 UT     school 4900167 7I Charter Weber State University Charter Academy 490016701447 100 Weber State University Charter Academy   Regular School Yes Elementary KG KG 2020   grade_7                                                   0                                             0
1202299 1202299 UT     school 4900167 7I Charter Weber State University Charter Academy 490016701447 100 Weber State University Charter Academy   Regular School Yes Elementary KG KG 2020   grade_8                                                   0                                             0
1203336 1203336 UT     school 4900167 7I Charter Weber State University Charter Academy 490016701447 100 Weber State University Charter Academy   Regular School Yes Elementary KG KG 2020   grade_9                                                   0                                             0
1204373 1204373 UT     school 4900167 7I Charter Weber State University Charter Academy 490016701447 100 Weber State University Charter Academy   Regular School Yes Elementary KG KG 2020   grade_10                                                   0                                             0
1205410 1205410 UT     school 4900167 7I Charter Weber State University Charter Academy 490016701447 100 Weber State University Charter Academy   Regular School Yes Elementary KG KG 2020   grade_11                                                   0                                             0
1206447 1206447 UT     school 4900167 7I Charter Weber State University Charter Academy 490016701447 100 Weber State University Charter Academy   Regular School Yes Elementary KG KG 2020   grade_12                                                   0                                             0
1351170 1351170 UT     school 4900167 7I Charter Weber State University Charter Academy 490016701447 100 Weber State University Charter Academy   Regular School Yes Elementary KG KG 2021   k_12_total 27.0 0.0 4.0 0.0   0.0       0.0 1.0   13.0 19.0     0.0   0.0   9.0     9.0   32 27 0 4 0   0       0 1   13 19     0 0 9   9   32
1352217 1352217 UT     school 4900167 7I Charter Weber State University Charter Academy 490016701447 100 Weber State University Charter Academy   Regular School Yes Elementary KG KG 2021   kindergarten                                                   32                                             32
1353264 1353264 UT     school 4900167 7I Charter Weber State University Charter Academy 490016701447 100 Weber State University Charter Academy   Regular School Yes Elementary KG KG 2021   grade_1                                                   0                                             0
1354311 1354311 UT     school 4900167 7I Charter Weber State University Charter Academy 490016701447 100 Weber State University Charter Academy   Regular School Yes Elementary KG KG 2021   grade_2                                                   0                                             0
1355358 1355358 UT     school 4900167 7I Charter Weber State University Charter Academy 490016701447 100 Weber State University Charter Academy   Regular School Yes Elementary KG KG 2021   grade_3                                                   0                                             0
1356405 1356405 UT     school 4900167 7I Charter Weber State University Charter Academy 490016701447 100 Weber State University Charter Academy   Regular School Yes Elementary KG KG 2021   grade_4                                                   0                                             0
1357452 1357452 UT     school 4900167 7I Charter Weber State University Charter Academy 490016701447 100 Weber State University Charter Academy   Regular School Yes Elementary KG KG 2021   grade_5                                                   0                                             0
1358499 1358499 UT     school 4900167 7I Charter Weber State University Charter Academy 490016701447 100 Weber State University Charter Academy   Regular School Yes Elementary KG KG 2021   grade_6                                                   0                                             0
1359546 1359546 UT     school 4900167 7I Charter Weber State University Charter Academy 490016701447 100 Weber State University Charter Academy   Regular School Yes Elementary KG KG 2021   grade_7                                                   0                                             0
1360593 1360593 UT     school 4900167 7I Charter Weber State University Charter Academy 490016701447 100 Weber State University Charter Academy   Regular School Yes Elementary KG KG 2021   grade_8                                                   0                                             0
1361640 1361640 UT     school 4900167 7I Charter Weber State University Charter Academy 490016701447 100 Weber State University Charter Academy   Regular School Yes Elementary KG KG 2021   grade_9                                                   0                                             0
1362687 1362687 UT     school 4900167 7I Charter Weber State University Charter Academy 490016701447 100 Weber State University Charter Academy   Regular School Yes Elementary KG KG 2021   grade_10                                                   0                                             0
1363734 1363734 UT     school 4900167 7I Charter Weber State University Charter Academy 490016701447 100 Weber State University Charter Academy   Regular School Yes Elementary KG KG 2021   grade_11                                                   0                                             0
1364781 1364781 UT     school 4900167 7I Charter Weber State University Charter Academy 490016701447 100 Weber State University Charter Academy   Regular School Yes Elementary KG KG 2021   grade_12                                                   0                                             0
1192790 1192790 UT     school 4901200 35 District Weber District 490120000612 100 Bates School   Regular School No Elementary KG 06 2020   k_12_total 679.0 4.0 65.0 0.0   15.0       1.0 25.0   382.0 407.0     28.0   6.0   152.0     101.0   789 679 4 65 0   15       1 25   382 407     28 6 152   101   789
1192791 1192791 UT     school 4901200 35 District Weber District 490120000613 701 Bonneville High   Regular School No High 10 12 2020   k_12_total 1025.0 29.0 253.0 7.0   6.0       14.0 47.0   682.0 699.0     56.0   6.0   467.0     173.0   1381 1025 29 253 7   6       14 47   682 699     56 6 467   173   1381
1192792 1192792 UT     school 4901200 35 District Weber District 490120001484 105 Burch Creek School   Regular School No Elementary KG 06 2020   k_12_total 415.0 20.0 145.0 0.0   6.0       6.0 13.0   299.0 306.0     72.0   5.0   290.0     94.0   605 415 20 145 0   6       6 13   299 306     72 5 290   94   605
1192793 1192793 UT     school 4901200 35 District Weber District 490120001249 179 Canyon View Preschool   Special Education School No Prekindergarten PK PK 2020   k_12_total                                                   0                                             0
1192794 1192794 UT     school 4901200 35 District Weber District 490120000703 109 Country View School   Regular School No Elementary KG 06 2020   k_12_total 588.0 11.0 61.0 2.0   9.0       3.0 17.0   355.0 336.0     38.0   5.0   147.0     80.0   691 588 11 61 2   9       3 17   355 336     38 5 147   80   691
1192795 1192795 UT     school 4901200 35 District Weber District 490120000817 113 Farr West School   Regular School No Elementary KG 06 2020   k_12_total 702.0 0.0 45.0 0.0   1.0       0.0 19.0   362.0 405.0     9.0   3.0   114.0     80.0   767 702 0 45 0   1       0 19   362 405     9 3 114   80   767
1192796 1192796 UT     school 4901200 35 District Weber District 490120000781 115 Freedom School   Regular School No Elementary KG 06 2020   k_12_total 648.0 4.0 142.0 1.0   8.0       7.0 32.0   412.0 430.0     21.0   3.0   207.0     118.0   842 648 4 142 1   8       7 32   412 430     21 3 207   118   842
1192797 1192797 UT     school 4901200 35 District Weber District 490120000221 706 Fremont High   Regular School No High 10 12 2020   k_12_total 1795.0 12.0 136.0 4.0   11.0       16.0 46.0   1027.0 993.0     15.0   4.0   261.0     250.0   2020 1795 12 136 4   11       16 46   1027 993     15 4 261   250   2020
1192798 1192798 UT     school 4901200 35 District Weber District 490120000616 111 Green Acres School   Regular School No Elementary KG 06 2020   k_12_total 447.0 2.0 53.0 1.0   3.0       4.0 5.0   273.0 242.0     16.0   0.0   164.0     99.0   515 447 2 53 1   3       4 5   273 242     16 0 164   99   515
1192799 1192799 UT     school 4901200 35 District Weber District 490120000617 110 H Guy Child School   Regular School No Elementary KG 06 2020   k_12_total 400.0 3.0 36.0 2.0   4.0       10.0 14.0   255.0 214.0     17.0   0.0   121.0     72.0   469 400 3 36 2   4       10 14   255 214     17 0 121   72   469
1192800 1192800 UT     school 4901200 35 District Weber District 490120000618 112 Hooper School   Regular School No Elementary KG 06 2020   k_12_total 621.0 0.0 32.0 3.0   0.0       1.0 11.0   353.0 315.0     2.0   5.0   105.0     83.0   668 621 0 32 3   0       1 11   353 315     2 5 105   83   668
1192801 1192801 UT     school 4901200 35 District Weber District 490120001548 750 Horizon Academy   Alternative School No High 08 12 2020   k_12_total 44.0 3.0 31.0 1.0   1.0       0.0 6.0   59.0 27.0     7.0   3.0   53.0     3.0   86 44 3 31 1   1       0 6   59 27     7 3 53   3   86
1192802 1192802 UT     school 4901200 35 District Weber District 490120000619 114 Kanesville School   Regular School No Elementary KG 06 2020   k_12_total 761.0 6.0 76.0 0.0   4.0       5.0 13.0   407.0 458.0     22.0   1.0   127.0     125.0   865 761 6 76 0   4       5 13   407 458     22 1 127   125   865
1192803 1192803 UT     school 4901200 35 District Weber District 490120000620 116 Lakeview School   Regular School No Elementary KG 06 2020   k_12_total 332.0 6.0 80.0 1.0   7.0       11.0 11.0   231.0 217.0     41.0   2.0   244.0     56.0   448 332 6 80 1   7       11 11   231 217     41 2 244   56   448
1192804 1192804 UT     school 4901200 35 District Weber District 490120000621 120 Lomond View School   Regular School No Elementary KG 06 2020   k_12_total 447.0 3.0 14.0 1.0   4.0       0.0 4.0   248.0 225.0     0.0   0.0   62.0     52.0   473 447 3 14 1   4       0 4   248 225     0 0 62   52   473
1192805 1192805 UT     school 4901200 35 District Weber District 490120000573 121 Majestic School   Regular School No Elementary KG 06 2020   k_12_total 692.0 3.0 131.0 1.0   11.0       1.0 21.0   442.0 418.0     46.0   9.0   213.0     90.0   860 692 3 131 1   11       1 21   442 418     46 9 213   90   860

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