Data source: Big Local News · About: Big Local

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

View and edit SQL

grade

year

Link rowid state county county_state_id admin_level district_nces_id ▲ district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
1192806 UT     school 4901200 35 District Weber District 490120000818 123 Midland School   Regular School No Elementary PK 06 2020   k_12_total 423.0 10.0 80.0 1.0   9.0       3.0 24.0   301.0 249.0     35.0   2.0   180.0     85.0   550 423 10 80 1   9       3 24   301 249     35 2 180   85   550
1192807 UT     school 4901200 35 District Weber District 490120000624 124 Municipal School   Regular School No Elementary KG 06 2020   k_12_total 257.0 3.0 85.0 3.0   3.0       2.0 4.0   160.0 197.0     32.0   0.0   181.0     58.0   357 257 3 85 3   3       2 4   160 197     32 0 181   58   357
1192808 UT     school 4901200 35 District Weber District 490120000625 402 North Ogden Jr High   Regular School No Middle 07 09 2020   k_12_total 787.0 3.0 80.0 5.0   12.0       3.0 23.0   445.0 468.0     15.0   5.0   230.0     124.0   913 787 3 80 5   12       3 23   445 468     15 5 230   124   913
1192809 UT     school 4901200 35 District Weber District 490120000626 128 North Ogden School   Regular School No Elementary KG 06 2020   k_12_total 484.0 3.0 49.0 2.0   2.0       0.0 14.0   273.0 281.0     22.0   4.0   157.0     69.0   554 484 3 49 2   2       0 14   273 281     22 4 157   69   554
1192810 UT     school 4901200 35 District Weber District 490120000627 132 North Park School   Regular School No Elementary KG 06 2020   k_12_total 352.0 2.0 103.0 5.0   13.0       6.0 26.0   253.0 254.0     24.0   4.0   276.0     103.0   507 352 2 103 5   13       6 26   253 254     24 4 276   103   507
1192811 UT     school 4901200 35 District Weber District 490120001546 142 Orchard Springs   Regular School No Elementary KG 06 2020   k_12_total 324.0 2.0 59.0 0.0   10.0       2.0 7.0   194.0 210.0     27.0   1.0   147.0     36.0   404 324 2 59 0   10       2 7   194 210     27 1 147   36   404
1192812 UT     school 4901200 35 District Weber District 490120000967 405 Orion Jr High   Regular School No Middle 07 09 2020   k_12_total 868.0 2.0 125.0 3.0   12.0       2.0 40.0   505.0 547.0     27.0   6.0   256.0     119.0   1052 868 2 125 3   12       2 40   505 547     27 6 256   119   1052
1192813 UT     school 4901200 35 District Weber District 490120000630 138 Pioneer School   Regular School No Elementary KG 06 2020   k_12_total 377.0 1.0 42.0 1.0   4.0       4.0 10.0   237.0 202.0     13.0   0.0   106.0     95.0   439 377 1 42 1   4       4 10   237 202     13 0 106   95   439
1192814 UT     school 4901200 35 District Weber District 490120000631 140 Plain City School   Regular School No Elementary KG 06 2020   k_12_total 675.0 2.0 11.0 1.0   3.0       2.0 2.0   344.0 352.0     3.0   0.0   105.0     93.0   696 675 2 11 1   3       2 2   344 352     3 0 105   93   696
1192815 UT     school 4901200 35 District Weber District 490120000632 144 Riverdale School   Regular School No Elementary KG 06 2020   k_12_total 309.0 1.0 121.0 1.0   9.0       4.0 11.0   241.0 215.0     61.0   0.0   199.0     54.0   456 309 1 121 1   9       4 11   241 215     61 0 199   54   456
1192816 UT     school 4901200 35 District Weber District 490120000212 403 Rocky Mountain Jr High   Regular School No Middle 07 09 2020   k_12_total 959.0 10.0 82.0 2.0   6.0       1.0 18.0   537.0 541.0     12.0   6.0   185.0     121.0   1078 959 10 82 2   6       1 18   537 541     12 6 185   121   1078
1192817 UT     school 4901200 35 District Weber District 490120000633 148 Roosevelt School   Regular School No Elementary KG 06 2020   k_12_total 305.0 14.0 126.0 3.0   3.0       14.0 21.0   242.0 244.0     60.0   3.0   247.0     84.0   486 305 14 126 3   3       14 21   242 244     60 3 247   84   486
1192818 UT     school 4901200 35 District Weber District 490120000634 708 Roy High   Regular School No High 10 12 2020   k_12_total 1339.0 17.0 347.0 11.0   26.0       20.0 75.0   913.0 922.0     59.0   3.0   560.0     300.0   1835 1339 17 347 11   26       20 75   913 922     59 3 560   300   1835
1192819 UT     school 4901200 35 District Weber District 490120000635 404 Roy Jr High   Regular School No Middle 07 09 2020   k_12_total 686.0 7.0 193.0 7.0   9.0       11.0 33.0   478.0 468.0     31.0   3.0   365.0     133.0   946 686 7 193 7   9       11 33   478 468     31 3 365   133   946
1192820 UT     school 4901200 35 District Weber District 490120000636 152 Roy School   Regular School No Elementary KG 06 2020   k_12_total 355.0 1.0 135.0 2.0   5.0       13.0 22.0   278.0 255.0     31.0   1.0   308.0     82.0   533 355 1 135 2   5       13 22   278 255     31 1 308   82   533
1192821 UT     school 4901200 35 District Weber District 490120000637 406 Sand Ridge Jr High   Regular School No Middle 07 09 2020   k_12_total 583.0 12.0 185.0 9.0   13.0       7.0 37.0   429.0 417.0     40.0   6.0   350.0     152.0   846 583 12 185 9   13       7 37   429 417     40 6 350   152   846
1192822 UT     school 4901200 35 District Weber District 490120001552 141 Silver Ridge Elementary   Regular School No Elementary KG 06 2020   k_12_total 525.0 6.0 23.0 0.0   1.0       0.0 7.0   292.0 270.0     10.0   2.0   83.0     99.0   562 525 6 23 0   1       0 7   292 270     10 2 83   99   562
1192823 UT     school 4901200 35 District Weber District 490120000669 412 Snowcrest Jr High   Regular School No Middle 07 09 2020   k_12_total 289.0 1.0 9.0 2.0   1.0       0.0 7.0   176.0 133.0     0.0   0.0   29.0     25.0   309 289 1 9 2   1       0 7   176 133     0 0 29   25   309
1192824 UT     school 4901200 35 District Weber District 490120000638 408 South Ogden Jr High   Regular School No Middle 07 09 2020   k_12_total 642.0 13.0 149.0 6.0   11.0       12.0 23.0   401.0 455.0     32.0   4.0   280.0     87.0   856 642 13 149 6   11       12 23   401 455     32 4 280   87   856
1192825 UT     school 4901200 35 District Weber District 490120000639 410 T.H. Bell Jr High   Regular School No Middle 07 09 2020   k_12_total 425.0 6.0 170.0 5.0   7.0       10.0 28.0   349.0 302.0     49.0   11.0   307.0     92.0   651 425 6 170 5   7       10 28   349 302     49 11 307   92   651
1192826 UT     school 4901200 35 District Weber District 490120000972 730 Two Rivers High   Alternative School No High 09 12 2020   k_12_total 126.0 3.0 38.0 4.0   0.0       0.0 2.0   95.0 78.0     7.0   7.0   73.0     25.0   173 126 3 38 4   0       0 2   95 78     7 7 73   25   173
1192827 UT     school 4901200 35 District Weber District 490120000640 154 Uintah School   Regular School No Elementary KG 06 2020   k_12_total 624.0 5.0 57.0 3.0   8.0       3.0 27.0   366.0 361.0     22.0   2.0   186.0     85.0   727 624 5 57 3   8       3 27   366 361     22 2 186   85   727
1192828 UT     school 4901200 35 District Weber District 490120000641 156 Valley School   Regular School No Elementary KG 06 2020   k_12_total 552.0 2.0 11.0 3.0   0.0       0.0 3.0   282.0 289.0     0.0   0.0   61.0     77.0   571 552 2 11 3   0       0 3   282 289     0 0 61   77   571
1192829 UT     school 4901200 35 District Weber District 490120000642 158 Valley View School   Regular School No Elementary KG 06 2020   k_12_total 299.0 1.0 116.0 0.0   4.0       3.0 18.0   234.0 207.0     63.0   2.0   208.0     65.0   441 299 1 116 0   4       3 18   234 207     63 2 208   65   441
1192830 UT     school 4901200 35 District Weber District 490120000643 416 Wahlquist Jr High   Regular School No Middle 07 09 2020   k_12_total 1067.0 3.0 64.0 0.0   2.0       6.0 23.0   635.0 530.0     13.0   4.0   159.0     122.0   1165 1067 3 64 0   2       6 23   635 530     13 4 159   122   1165
1192831 UT     school 4901200 35 District Weber District 490120000644 160 Washington Terrace School   Regular School No Elementary KG 06 2020   k_12_total 383.0 5.0 120.0 4.0   4.0       6.0 12.0   280.0 254.0     59.0   13.0   288.0     81.0   534 383 5 120 4   4       6 12   280 254     59 13 288   81   534
1192832 UT     school 4901200 35 District Weber District 490120000645 704 Weber High   Regular School No High 10 12 2020   k_12_total 1807.0 11.0 181.0 8.0   15.0       7.0 48.0   1059.0 1018.0     13.0   6.0   334.0     217.0   2077 1807 11 181 8   15       7 48   1059 1018     13 6 334   217   2077
1192833 UT     school 4901200 35 District Weber District 490120001482 725 Weber Innovation High School   Regular School No High 09 12 2020   k_12_total 206.0 0.0 19.0 1.0   5.0       0.0 4.0   107.0 128.0     1.0   1.0   32.0     6.0   235 206 0 19 1   5       0 4   107 128     1 1 32   6   235
1192834 UT     school 4901200 35 District Weber District 490120001414 199 Weber Online K-6   Regular School No Elementary 02 06 2020   k_12_total 6.0 0.0 1.0 0.0   0.0       0.0 0.0   2.0 5.0     1.0   0.0   0.0     0.0   7 6 0 1 0   0       0 0   2 5     1 0 0   0   7
1192835 UT     school 4901200 35 District Weber District 490120001108 162 West Haven School   Regular School No Elementary KG 06 2020   k_12_total 454.0 16.0 92.0 0.0   9.0       5.0 35.0   313.0 298.0     35.0   14.0   241.0     109.0   611 454 16 92 0   9       5 35   313 298     35 14 241   109   611
1192836 UT     school 4901200 35 District Weber District 490120000646 164 West Weber School   Regular School No Elementary KG 06 2020   k_12_total 505.0 3.0 19.0 0.0   2.0       2.0 7.0   270.0 268.0     11.0   1.0   111.0     82.0   538 505 3 19 0   2       2 7   270 268     11 1 111   82   538
1193827 UT     school 4901200 35 District Weber District 490120000612 100 Bates School   Regular School No Elementary KG 06 2020   kindergarten                                                   86                                             86
1193828 UT     school 4901200 35 District Weber District 490120000613 701 Bonneville High   Regular School No High 10 12 2020   kindergarten                                                   0                                             0
1193829 UT     school 4901200 35 District Weber District 490120001484 105 Burch Creek School   Regular School No Elementary KG 06 2020   kindergarten                                                   93                                             93
1193830 UT     school 4901200 35 District Weber District 490120001249 179 Canyon View Preschool   Special Education School No Prekindergarten PK PK 2020   kindergarten                                                   0                                             0
1193831 UT     school 4901200 35 District Weber District 490120000703 109 Country View School   Regular School No Elementary KG 06 2020   kindergarten                                                   91                                             91
1193832 UT     school 4901200 35 District Weber District 490120000817 113 Farr West School   Regular School No Elementary KG 06 2020   kindergarten                                                   113                                             113
1193833 UT     school 4901200 35 District Weber District 490120000781 115 Freedom School   Regular School No Elementary KG 06 2020   kindergarten                                                   105                                             105
1193834 UT     school 4901200 35 District Weber District 490120000221 706 Fremont High   Regular School No High 10 12 2020   kindergarten                                                   0                                             0
1193835 UT     school 4901200 35 District Weber District 490120000616 111 Green Acres School   Regular School No Elementary KG 06 2020   kindergarten                                                   80                                             80
1193836 UT     school 4901200 35 District Weber District 490120000617 110 H Guy Child School   Regular School No Elementary KG 06 2020   kindergarten                                                   44                                             44
1193837 UT     school 4901200 35 District Weber District 490120000618 112 Hooper School   Regular School No Elementary KG 06 2020   kindergarten                                                   75                                             75
1193838 UT     school 4901200 35 District Weber District 490120001548 750 Horizon Academy   Alternative School No High 08 12 2020   kindergarten                                                   0                                             0
1193839 UT     school 4901200 35 District Weber District 490120000619 114 Kanesville School   Regular School No Elementary KG 06 2020   kindergarten                                                   107                                             107
1193840 UT     school 4901200 35 District Weber District 490120000620 116 Lakeview School   Regular School No Elementary KG 06 2020   kindergarten                                                   66                                             66
1193841 UT     school 4901200 35 District Weber District 490120000621 120 Lomond View School   Regular School No Elementary KG 06 2020   kindergarten                                                   49                                             49
1193842 UT     school 4901200 35 District Weber District 490120000573 121 Majestic School   Regular School No Elementary KG 06 2020   kindergarten                                                   93                                             93
1193843 UT     school 4901200 35 District Weber District 490120000818 123 Midland School   Regular School No Elementary PK 06 2020   kindergarten                                                   74                                             74
1193844 UT     school 4901200 35 District Weber District 490120000624 124 Municipal School   Regular School No Elementary KG 06 2020   kindergarten                                                   62                                             62
1193845 UT     school 4901200 35 District Weber District 490120000625 402 North Ogden Jr High   Regular School No Middle 07 09 2020   kindergarten                                                   0                                             0
1193846 UT     school 4901200 35 District Weber District 490120000626 128 North Ogden School   Regular School No Elementary KG 06 2020   kindergarten                                                   64                                             64
1193847 UT     school 4901200 35 District Weber District 490120000627 132 North Park School   Regular School No Elementary KG 06 2020   kindergarten                                                   61                                             61
1193848 UT     school 4901200 35 District Weber District 490120001546 142 Orchard Springs   Regular School No Elementary KG 06 2020   kindergarten                                                   65                                             65
1193849 UT     school 4901200 35 District Weber District 490120000967 405 Orion Jr High   Regular School No Middle 07 09 2020   kindergarten                                                   0                                             0
1193850 UT     school 4901200 35 District Weber District 490120000630 138 Pioneer School   Regular School No Elementary KG 06 2020   kindergarten                                                   67                                             67
1193851 UT     school 4901200 35 District Weber District 490120000631 140 Plain City School   Regular School No Elementary KG 06 2020   kindergarten                                                   88                                             88
1193852 UT     school 4901200 35 District Weber District 490120000632 144 Riverdale School   Regular School No Elementary KG 06 2020   kindergarten                                                   49                                             49
1193853 UT     school 4901200 35 District Weber District 490120000212 403 Rocky Mountain Jr High   Regular School No Middle 07 09 2020   kindergarten                                                   0                                             0
1193854 UT     school 4901200 35 District Weber District 490120000633 148 Roosevelt School   Regular School No Elementary KG 06 2020   kindergarten                                                   82                                             82
1193855 UT     school 4901200 35 District Weber District 490120000634 708 Roy High   Regular School No High 10 12 2020   kindergarten                                                   0                                             0
1193856 UT     school 4901200 35 District Weber District 490120000635 404 Roy Jr High   Regular School No Middle 07 09 2020   kindergarten                                                   0                                             0
1193857 UT     school 4901200 35 District Weber District 490120000636 152 Roy School   Regular School No Elementary KG 06 2020   kindergarten                                                   84                                             84
1193858 UT     school 4901200 35 District Weber District 490120000637 406 Sand Ridge Jr High   Regular School No Middle 07 09 2020   kindergarten                                                   0                                             0
1193859 UT     school 4901200 35 District Weber District 490120001552 141 Silver Ridge Elementary   Regular School No Elementary KG 06 2020   kindergarten                                                   71                                             71
1193860 UT     school 4901200 35 District Weber District 490120000669 412 Snowcrest Jr High   Regular School No Middle 07 09 2020   kindergarten                                                   0                                             0
1193861 UT     school 4901200 35 District Weber District 490120000638 408 South Ogden Jr High   Regular School No Middle 07 09 2020   kindergarten                                                   0                                             0
1193862 UT     school 4901200 35 District Weber District 490120000639 410 T.H. Bell Jr High   Regular School No Middle 07 09 2020   kindergarten                                                   0                                             0
1193863 UT     school 4901200 35 District Weber District 490120000972 730 Two Rivers High   Alternative School No High 09 12 2020   kindergarten                                                   0                                             0
1193864 UT     school 4901200 35 District Weber District 490120000640 154 Uintah School   Regular School No Elementary KG 06 2020   kindergarten                                                   86                                             86
1193865 UT     school 4901200 35 District Weber District 490120000641 156 Valley School   Regular School No Elementary KG 06 2020   kindergarten                                                   66                                             66
1193866 UT     school 4901200 35 District Weber District 490120000642 158 Valley View School   Regular School No Elementary KG 06 2020   kindergarten                                                   68                                             68
1193867 UT     school 4901200 35 District Weber District 490120000643 416 Wahlquist Jr High   Regular School No Middle 07 09 2020   kindergarten                                                   0                                             0
1193868 UT     school 4901200 35 District Weber District 490120000644 160 Washington Terrace School   Regular School No Elementary KG 06 2020   kindergarten                                                   84                                             84
1193869 UT     school 4901200 35 District Weber District 490120000645 704 Weber High   Regular School No High 10 12 2020   kindergarten                                                   0                                             0
1193870 UT     school 4901200 35 District Weber District 490120001482 725 Weber Innovation High School   Regular School No High 09 12 2020   kindergarten                                                   0                                             0
1193871 UT     school 4901200 35 District Weber District 490120001414 199 Weber Online K-6   Regular School No Elementary 02 06 2020   kindergarten                                                   2                                             2
1193872 UT     school 4901200 35 District Weber District 490120001108 162 West Haven School   Regular School No Elementary KG 06 2020   kindergarten                                                   67                                             67
1193873 UT     school 4901200 35 District Weber District 490120000646 164 West Weber School   Regular School No Elementary KG 06 2020   kindergarten                                                   67                                             67
1194864 UT     school 4901200 35 District Weber District 490120000612 100 Bates School   Regular School No Elementary KG 06 2020   grade_1                                                   102                                             102
1194865 UT     school 4901200 35 District Weber District 490120000613 701 Bonneville High   Regular School No High 10 12 2020   grade_1                                                   0                                             0
1194866 UT     school 4901200 35 District Weber District 490120001484 105 Burch Creek School   Regular School No Elementary KG 06 2020   grade_1                                                   92                                             92
1194867 UT     school 4901200 35 District Weber District 490120001249 179 Canyon View Preschool   Special Education School No Prekindergarten PK PK 2020   grade_1                                                   0                                             0
1194868 UT     school 4901200 35 District Weber District 490120000703 109 Country View School   Regular School No Elementary KG 06 2020   grade_1                                                   91                                             91
1194869 UT     school 4901200 35 District Weber District 490120000817 113 Farr West School   Regular School No Elementary KG 06 2020   grade_1                                                   94                                             94
1194870 UT     school 4901200 35 District Weber District 490120000781 115 Freedom School   Regular School No Elementary KG 06 2020   grade_1                                                   118                                             118
1194871 UT     school 4901200 35 District Weber District 490120000221 706 Fremont High   Regular School No High 10 12 2020   grade_1                                                   0                                             0
1194872 UT     school 4901200 35 District Weber District 490120000616 111 Green Acres School   Regular School No Elementary KG 06 2020   grade_1                                                   65                                             65
1194873 UT     school 4901200 35 District Weber District 490120000617 110 H Guy Child School   Regular School No Elementary KG 06 2020   grade_1                                                   64                                             64
1194874 UT     school 4901200 35 District Weber District 490120000618 112 Hooper School   Regular School No Elementary KG 06 2020   grade_1                                                   107                                             107
1194875 UT     school 4901200 35 District Weber District 490120001548 750 Horizon Academy   Alternative School No High 08 12 2020   grade_1                                                   0                                             0
1194876 UT     school 4901200 35 District Weber District 490120000619 114 Kanesville School   Regular School No Elementary KG 06 2020   grade_1                                                   117                                             117
1194877 UT     school 4901200 35 District Weber District 490120000620 116 Lakeview School   Regular School No Elementary KG 06 2020   grade_1                                                   69                                             69
1194878 UT     school 4901200 35 District Weber District 490120000621 120 Lomond View School   Regular School No Elementary KG 06 2020   grade_1                                                   59                                             59
1194879 UT     school 4901200 35 District Weber District 490120000573 121 Majestic School   Regular School No Elementary KG 06 2020   grade_1                                                   115                                             115
1194880 UT     school 4901200 35 District Weber District 490120000818 123 Midland School   Regular School No Elementary PK 06 2020   grade_1                                                   67                                             67
1194881 UT     school 4901200 35 District Weber District 490120000624 124 Municipal School   Regular School No Elementary KG 06 2020   grade_1                                                   44                                             44
1194882 UT     school 4901200 35 District Weber District 490120000625 402 North Ogden Jr High   Regular School No Middle 07 09 2020   grade_1                                                   0                                             0
1194883 UT     school 4901200 35 District Weber District 490120000626 128 North Ogden School   Regular School No Elementary KG 06 2020   grade_1                                                   85                                             85
1194884 UT     school 4901200 35 District Weber District 490120000627 132 North Park School   Regular School No Elementary KG 06 2020   grade_1                                                   71                                             71
1194885 UT     school 4901200 35 District Weber District 490120001546 142 Orchard Springs   Regular School No Elementary KG 06 2020   grade_1                                                   55                                             55

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