Data source: Big Local News · About: Big Local

14,658 rows where state = "UT" and year = 2021 sorted by ccd_school_type

View and edit SQL

grade

year

  • 2021 · 14,658
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
1350185 UT     school 4900030 01 District Alpine District 490003001435 782 Polaris High School   Alternative School No High 09 12 2021   k_12_total 69.0 0.0 36.0 1.0   0.0       3.0 4.0   57.0 56.0     17.0   2.0   44.0     32.0   113 69 0 36 1   0       3 4   57 56     17 2 44   32   113
1350201 UT     school 4900030 01 District Alpine District 490003000366 730 Summit High   Alternative School No High 07 12 2021   k_12_total 36.0 4.0 12.0 0.0   0.0       1.0 4.0   35.0 22.0     1.0   1.0   43.0     20.0   57 36 4 12 0   0       1 4   35 22     1 1 43   20   57
1350240 UT     school 4900090 03 District Box Elder District 490009000707 778 Sunrise High School   Alternative School No High 05 12 2021   k_12_total 95.0 1.0 17.0 1.0   0.0       1.0 4.0   76.0 43.0     2.0   1.0   62.0     45.0   119 95 1 17 1   0       1 4   76 43     2 1 62   45   119
1350245 UT     school 4900120 04 District Cache District 490012000041 710 Cache Alternative High   Alternative School No High 05 12 2021   k_12_total 93.0 1.0 47.0 0.0   0.0       1.0 3.0   86.0 59.0     5.0   1.0   87.0     58.0   145 93 1 47 0   0       1 3   86 59     5 1 87   58   145
1350285 UT     school 4900142 42 District Canyons District 490014201504 750 Diamond Ridge High School   Alternative School No High 09 12 2021   k_12_total 44.0 2.0 28.0 1.0   0.0       2.0 3.0   36.0 44.0     7.0   12.0   39.0     12.0   80 44 2 28 1   0       2 3   36 44     7 12 39   12   80
1350384 UT     school 4900210 07 District Davis District 490021000823 730 Mountain High   Alternative School No High 10 12 2021   k_12_total 130.0 2.0 49.0 2.0   2.0       0.0 10.0   105.0 90.0     16.0   21.0   76.0     24.0   195 130 2 49 2   2       0 10   105 90     16 21 76   24   195
1350396 UT     school 4900210 07 District Davis District 490021000306 733 Renaissance Academy   Alternative School No Other KG 12 2021   k_12_total 253.0 5.0 46.0 2.0   1.0       7.0 9.0   208.0 115.0     20.0   12.0   142.0     282.0   323 253 5 46 2   1       7 9   208 115     20 12 142   282   323
1350485 UT     school 4900360 12 District Granite District 490036000220 740 Granite Connection High   Alternative School No Other KG 12 2021   k_12_total 184.0 18.0 156.0 12.0   9.0       19.0 4.0   193.0 209.0     100.0   9.0   219.0     167.0   402 184 18 156 12   9       19 4   193 209     100 9 219   167   402
1350548 UT     school 4900360 12 District Granite District 490036001399 501 Youth Educational Support School   Alternative School No Other KG 12 2021   k_12_total 14.0 10.0 21.0 1.0   0.0       2.0 2.0   35.0 15.0     11.0   0.0   9.0     17.0   50 14 10 21 1   0       2 2   35 15     11 0 9   17   50
1350564 UT     school 4900390 13 District Iron District 490039000872 750 Southwest Educational Academy   Alternative School No Other KG 12 2021   k_12_total 1392.0 10.0 107.0 23.0   17.0       21.0 14.0   845.0 739.0     7.0   9.0   325.0     73.0   1584 1392 10 107 23   17       21 14   845 739     7 9 325   73   1584
1350621 UT     school 4900420 14 District Jordan District 490042000329 716 Valley High School   Alternative School No High 07 12 2021   k_12_total 258.0 9.0 124.0 1.0   5.0       9.0 24.0   201.0 229.0     35.0   40.0   163.0     41.0   430 258 9 124 1   5       9 24   201 229     35 40 163   41   430
1350695 UT     school 4900630 19 District Nebo District 490063000387 720 Landmark High   Alternative School No High 07 12 2021   k_12_total 168.0 6.0 60.0 0.0   1.0       3.0 8.0   156.0 90.0     2.0   14.0   122.0     40.0   246 168 6 60 0   1       3 8   156 90     2 14 122   40   246
1350734 UT     school 4900660 20 District North Sanpete District 490066001431 801 Pleasant Creek School   Alternative School No Other KG 12 2021   k_12_total 23.0 1.0 9.0 1.0   0.0       1.0 2.0   28.0 9.0     1.0   0.0   34.0     12.0   37 23 1 9 1   0       1 2   28 9     1 0 34   12   37
1350742 UT     school 4900720 37 District Ogden City District 490072001265 729 George Washington High   Alternative School No High 07 12 2021   k_12_total 85.0 6.0 114.0 4.0   1.0       2.0 5.0   130.0 87.0     34.0   10.0   216.0     82.0   217 85 6 114 4   1       2 5   130 87     34 10 216   82   217
1350749 UT     school 4900720 37 District Ogden City District 490072001550 731 Malan's Peak Secondary   Alternative School No High 07 12 2021   k_12_total 8.0 1.0 3.0 0.0   0.0       1.0 2.0   14.0 1.0     1.0   0.0   10.0     8.0   15 8 1 3 0   0       1 2   14 1     1 0 10   8   15
1350785 UT     school 4900810 38 District Provo District 490081000836 730 Independence High   Alternative School No High 05 12 2021   k_12_total 87.0 7.0 73.0 9.0   0.0       4.0 4.0   106.0 78.0     25.0   8.0   104.0     84.0   184 87 7 73 9   0       4 4   106 78     25 8 104   84   184
1350793 UT     school 4900810 38 District Provo District 490081000858 555 Slate Canyon   Alternative School No High 07 12 2021   k_12_total 5.0 1.0 2.0 0.0   0.0       0.0 0.0   8.0 0.0     0.0   0.0   0.0     3.0   8 5 1 2 0   0       0 0   8 0     0 0 0   3   8
1350824 UT     school 4900870 36 District Salt Lake District 490087000732 750 Horizonte Instruction & Training Center   Alternative School No High 07 12 2021   k_12_total 66.0 16.0 198.0 5.0   5.0       30.0 4.0   168.0 156.0     56.0   17.0   253.0     45.0   324 66 16 198 5   5       30 4   168 156     56 17 253   45   324
1350859 UT     school 4900930 26 District Sevier District 490093000900 716 Cedar Ridge High   Alternative School No High 06 12 2021   k_12_total 36.0 0.0 4.0 4.0   1.0       0.0 0.0   27.0 18.0     1.0   0.0   26.0     4.0   45 36 0 4 4   1       0 0   27 18     1 0 26   4   45
1350889 UT     school 4901050 30 District Tooele District 490105000698 740 Blue Peak High   Alternative School No Other KG 12 2021   k_12_total 8176.0 62.0 853.0 76.0   61.0       65.0 183.0   4946.0 4529.0     124.0   30.0   1426.0     609.0   9476 8176 62 853 76   61       65 183   4946 4529     124 30 1426   609   9476
1350914 UT     school 4901080 31 District Uintah District 490108001302 750 Ashley Valley Education Ctr.   Alternative School No High 08 12 2021   k_12_total 272.0 1.0 34.0 36.0   3.0       0.0 2.0   153.0 194.0     7.0   0.0   180.0     31.0   348 272 1 34 36   3       0 2   153 194     7 0 180   31   348
1350962 UT     school 4901140 33 District Washington District 490114000881 718 Millcreek High   Alternative School No High 07 12 2021   k_12_total 54.0 7.0 35.0 4.0   0.0       3.0 4.0   53.0 54.0     11.0   2.0   63.0     28.0   107 54 7 35 4   0       3 4   53 54     11 2 63   28   107
1351002 UT     school 4901200 35 District Weber District 490120001548 750 Horizon Academy   Alternative School No High 06 12 2021   k_12_total 41.0 0.0 13.0 1.0   0.0       0.0 3.0   38.0 20.0     1.0   3.0   30.0     6.0   58 41 0 13 1   0       0 3   38 20     1 3 30   6   58
1351027 UT     school 4901200 35 District Weber District 490120000972 730 Two Rivers High   Alternative School No High 07 12 2021   k_12_total 108.0 1.0 35.0 0.0   0.0       0.0 6.0   77.0 73.0     6.0   2.0   53.0     19.0   150 108 1 35 0   0       0 6   77 73     6 2 53   19   150
1351074 UT     school 4900019 98 Charter Fast Forward High 490001900906 700 Fast Forward High   Alternative School Yes High 09 12 2021   k_12_total 163.0 1.0 66.0 12.0   0.0       1.0 8.0   133.0 118.0     2.0   0.0   104.0     59.0   251 163 1 66 12   0       1 8   133 118     2 0 104   59   251
1351153 UT     school 4900013 92 Charter Uintah River High 490001300671 700 Uintah River High   Alternative School Yes High 09 12 2021   k_12_total 2.0 0.0 3.0 50.0   0.0       0.0 9.0   32.0 32.0     0.0   10.0   35.0     7.0   64 2 0 3 50   0       0 9   32 32     0 10 35   7   64
1351232 UT     school 4900030 01 District Alpine District 490003001435 782 Polaris High School   Alternative School No High 09 12 2021   kindergarten                                                   0                                             0
1351248 UT     school 4900030 01 District Alpine District 490003000366 730 Summit High   Alternative School No High 07 12 2021   kindergarten                                                   0                                             0
1351287 UT     school 4900090 03 District Box Elder District 490009000707 778 Sunrise High School   Alternative School No High 05 12 2021   kindergarten                                                   0                                             0
1351292 UT     school 4900120 04 District Cache District 490012000041 710 Cache Alternative High   Alternative School No High 05 12 2021   kindergarten                                                   0                                             0
1351332 UT     school 4900142 42 District Canyons District 490014201504 750 Diamond Ridge High School   Alternative School No High 09 12 2021   kindergarten                                                   0                                             0
1351431 UT     school 4900210 07 District Davis District 490021000823 730 Mountain High   Alternative School No High 10 12 2021   kindergarten                                                   0                                             0
1351443 UT     school 4900210 07 District Davis District 490021000306 733 Renaissance Academy   Alternative School No Other KG 12 2021   kindergarten                                                   2                                             2
1351532 UT     school 4900360 12 District Granite District 490036000220 740 Granite Connection High   Alternative School No Other KG 12 2021   kindergarten                                                   1                                             1
1351595 UT     school 4900360 12 District Granite District 490036001399 501 Youth Educational Support School   Alternative School No Other KG 12 2021   kindergarten                                                   0                                             0
1351611 UT     school 4900390 13 District Iron District 490039000872 750 Southwest Educational Academy   Alternative School No Other KG 12 2021   kindergarten                                                   158                                             158
1351668 UT     school 4900420 14 District Jordan District 490042000329 716 Valley High School   Alternative School No High 07 12 2021   kindergarten                                                   0                                             0
1351742 UT     school 4900630 19 District Nebo District 490063000387 720 Landmark High   Alternative School No High 07 12 2021   kindergarten                                                   0                                             0
1351781 UT     school 4900660 20 District North Sanpete District 490066001431 801 Pleasant Creek School   Alternative School No Other KG 12 2021   kindergarten                                                   0                                             0
1351789 UT     school 4900720 37 District Ogden City District 490072001265 729 George Washington High   Alternative School No High 07 12 2021   kindergarten                                                   0                                             0
1351796 UT     school 4900720 37 District Ogden City District 490072001550 731 Malan's Peak Secondary   Alternative School No High 07 12 2021   kindergarten                                                   0                                             0
1351832 UT     school 4900810 38 District Provo District 490081000836 730 Independence High   Alternative School No High 05 12 2021   kindergarten                                                   0                                             0
1351840 UT     school 4900810 38 District Provo District 490081000858 555 Slate Canyon   Alternative School No High 07 12 2021   kindergarten                                                   0                                             0
1351871 UT     school 4900870 36 District Salt Lake District 490087000732 750 Horizonte Instruction & Training Center   Alternative School No High 07 12 2021   kindergarten                                                   0                                             0
1351906 UT     school 4900930 26 District Sevier District 490093000900 716 Cedar Ridge High   Alternative School No High 06 12 2021   kindergarten                                                   0                                             0
1351936 UT     school 4901050 30 District Tooele District 490105000698 740 Blue Peak High   Alternative School No Other KG 12 2021   kindergarten                                                   798                                             798
1351961 UT     school 4901080 31 District Uintah District 490108001302 750 Ashley Valley Education Ctr.   Alternative School No High 08 12 2021   kindergarten                                                   0                                             0
1352009 UT     school 4901140 33 District Washington District 490114000881 718 Millcreek High   Alternative School No High 07 12 2021   kindergarten                                                   0                                             0
1352049 UT     school 4901200 35 District Weber District 490120001548 750 Horizon Academy   Alternative School No High 06 12 2021   kindergarten                                                   0                                             0
1352074 UT     school 4901200 35 District Weber District 490120000972 730 Two Rivers High   Alternative School No High 07 12 2021   kindergarten                                                   0                                             0
1352121 UT     school 4900019 98 Charter Fast Forward High 490001900906 700 Fast Forward High   Alternative School Yes High 09 12 2021   kindergarten                                                   0                                             0
1352200 UT     school 4900013 92 Charter Uintah River High 490001300671 700 Uintah River High   Alternative School Yes High 09 12 2021   kindergarten                                                   0                                             0
1352279 UT     school 4900030 01 District Alpine District 490003001435 782 Polaris High School   Alternative School No High 09 12 2021   grade_1                                                   0                                             0
1352295 UT     school 4900030 01 District Alpine District 490003000366 730 Summit High   Alternative School No High 07 12 2021   grade_1                                                   0                                             0
1352334 UT     school 4900090 03 District Box Elder District 490009000707 778 Sunrise High School   Alternative School No High 05 12 2021   grade_1                                                   0                                             0
1352339 UT     school 4900120 04 District Cache District 490012000041 710 Cache Alternative High   Alternative School No High 05 12 2021   grade_1                                                   0                                             0
1352379 UT     school 4900142 42 District Canyons District 490014201504 750 Diamond Ridge High School   Alternative School No High 09 12 2021   grade_1                                                   0                                             0
1352478 UT     school 4900210 07 District Davis District 490021000823 730 Mountain High   Alternative School No High 10 12 2021   grade_1                                                   0                                             0
1352490 UT     school 4900210 07 District Davis District 490021000306 733 Renaissance Academy   Alternative School No Other KG 12 2021   grade_1                                                   0                                             0
1352579 UT     school 4900360 12 District Granite District 490036000220 740 Granite Connection High   Alternative School No Other KG 12 2021   grade_1                                                   3                                             3
1352642 UT     school 4900360 12 District Granite District 490036001399 501 Youth Educational Support School   Alternative School No Other KG 12 2021   grade_1                                                   0                                             0
1352658 UT     school 4900390 13 District Iron District 490039000872 750 Southwest Educational Academy   Alternative School No Other KG 12 2021   grade_1                                                   145                                             145
1352715 UT     school 4900420 14 District Jordan District 490042000329 716 Valley High School   Alternative School No High 07 12 2021   grade_1                                                   0                                             0
1352789 UT     school 4900630 19 District Nebo District 490063000387 720 Landmark High   Alternative School No High 07 12 2021   grade_1                                                   0                                             0
1352828 UT     school 4900660 20 District North Sanpete District 490066001431 801 Pleasant Creek School   Alternative School No Other KG 12 2021   grade_1                                                   0                                             0
1352836 UT     school 4900720 37 District Ogden City District 490072001265 729 George Washington High   Alternative School No High 07 12 2021   grade_1                                                   0                                             0
1352843 UT     school 4900720 37 District Ogden City District 490072001550 731 Malan's Peak Secondary   Alternative School No High 07 12 2021   grade_1                                                   0                                             0
1352879 UT     school 4900810 38 District Provo District 490081000836 730 Independence High   Alternative School No High 05 12 2021   grade_1                                                   0                                             0
1352887 UT     school 4900810 38 District Provo District 490081000858 555 Slate Canyon   Alternative School No High 07 12 2021   grade_1                                                   0                                             0
1352918 UT     school 4900870 36 District Salt Lake District 490087000732 750 Horizonte Instruction & Training Center   Alternative School No High 07 12 2021   grade_1                                                   0                                             0
1352953 UT     school 4900930 26 District Sevier District 490093000900 716 Cedar Ridge High   Alternative School No High 06 12 2021   grade_1                                                   0                                             0
1352983 UT     school 4901050 30 District Tooele District 490105000698 740 Blue Peak High   Alternative School No Other KG 12 2021   grade_1                                                   1000                                             1000
1353008 UT     school 4901080 31 District Uintah District 490108001302 750 Ashley Valley Education Ctr.   Alternative School No High 08 12 2021   grade_1                                                   0                                             0
1353056 UT     school 4901140 33 District Washington District 490114000881 718 Millcreek High   Alternative School No High 07 12 2021   grade_1                                                   0                                             0
1353096 UT     school 4901200 35 District Weber District 490120001548 750 Horizon Academy   Alternative School No High 06 12 2021   grade_1                                                   0                                             0
1353121 UT     school 4901200 35 District Weber District 490120000972 730 Two Rivers High   Alternative School No High 07 12 2021   grade_1                                                   0                                             0
1353168 UT     school 4900019 98 Charter Fast Forward High 490001900906 700 Fast Forward High   Alternative School Yes High 09 12 2021   grade_1                                                   0                                             0
1353247 UT     school 4900013 92 Charter Uintah River High 490001300671 700 Uintah River High   Alternative School Yes High 09 12 2021   grade_1                                                   0                                             0
1353326 UT     school 4900030 01 District Alpine District 490003001435 782 Polaris High School   Alternative School No High 09 12 2021   grade_2                                                   0                                             0
1353342 UT     school 4900030 01 District Alpine District 490003000366 730 Summit High   Alternative School No High 07 12 2021   grade_2                                                   0                                             0
1353381 UT     school 4900090 03 District Box Elder District 490009000707 778 Sunrise High School   Alternative School No High 05 12 2021   grade_2                                                   0                                             0
1353386 UT     school 4900120 04 District Cache District 490012000041 710 Cache Alternative High   Alternative School No High 05 12 2021   grade_2                                                   0                                             0
1353426 UT     school 4900142 42 District Canyons District 490014201504 750 Diamond Ridge High School   Alternative School No High 09 12 2021   grade_2                                                   0                                             0
1353525 UT     school 4900210 07 District Davis District 490021000823 730 Mountain High   Alternative School No High 10 12 2021   grade_2                                                   0                                             0
1353537 UT     school 4900210 07 District Davis District 490021000306 733 Renaissance Academy   Alternative School No Other KG 12 2021   grade_2                                                   1                                             1
1353626 UT     school 4900360 12 District Granite District 490036000220 740 Granite Connection High   Alternative School No Other KG 12 2021   grade_2                                                   4                                             4
1353689 UT     school 4900360 12 District Granite District 490036001399 501 Youth Educational Support School   Alternative School No Other KG 12 2021   grade_2                                                   0                                             0
1353705 UT     school 4900390 13 District Iron District 490039000872 750 Southwest Educational Academy   Alternative School No Other KG 12 2021   grade_2                                                   155                                             155
1353762 UT     school 4900420 14 District Jordan District 490042000329 716 Valley High School   Alternative School No High 07 12 2021   grade_2                                                   0                                             0
1353836 UT     school 4900630 19 District Nebo District 490063000387 720 Landmark High   Alternative School No High 07 12 2021   grade_2                                                   0                                             0
1353875 UT     school 4900660 20 District North Sanpete District 490066001431 801 Pleasant Creek School   Alternative School No Other KG 12 2021   grade_2                                                   0                                             0
1353883 UT     school 4900720 37 District Ogden City District 490072001265 729 George Washington High   Alternative School No High 07 12 2021   grade_2                                                   0                                             0
1353890 UT     school 4900720 37 District Ogden City District 490072001550 731 Malan's Peak Secondary   Alternative School No High 07 12 2021   grade_2                                                   0                                             0
1353926 UT     school 4900810 38 District Provo District 490081000836 730 Independence High   Alternative School No High 05 12 2021   grade_2                                                   0                                             0
1353934 UT     school 4900810 38 District Provo District 490081000858 555 Slate Canyon   Alternative School No High 07 12 2021   grade_2                                                   0                                             0
1353965 UT     school 4900870 36 District Salt Lake District 490087000732 750 Horizonte Instruction & Training Center   Alternative School No High 07 12 2021   grade_2                                                   0                                             0
1354000 UT     school 4900930 26 District Sevier District 490093000900 716 Cedar Ridge High   Alternative School No High 06 12 2021   grade_2                                                   0                                             0
1354030 UT     school 4901050 30 District Tooele District 490105000698 740 Blue Peak High   Alternative School No Other KG 12 2021   grade_2                                                   933                                             933
1354055 UT     school 4901080 31 District Uintah District 490108001302 750 Ashley Valley Education Ctr.   Alternative School No High 08 12 2021   grade_2                                                   0                                             0
1354103 UT     school 4901140 33 District Washington District 490114000881 718 Millcreek High   Alternative School No High 07 12 2021   grade_2                                                   0                                             0

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