Data source: Big Local News · About: Big Local

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

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
1192840 UT     school 4900005 74 Charter American Preparatory Academy 490000501404 110 American Preparatory Academy - Accelerated School   Regular School Yes Other KG 12 2020   k_12_total 324.0 114.0 985.0 0.0   142.0       43.0 25.0   791.0 842.0     373.0   0.0   873.0     147.0   1633 324 114 985 0   142       43 25   791 842     373 0 873   147   1633
1192841 UT     school 4900005 74 Charter American Preparatory Academy 490000500801 100 American Preparatory Academy   Regular School Yes Elementary KG 06 2020   k_12_total 345.0 12.0 77.0 1.0   173.0       10.0 14.0   300.0 332.0     59.0   0.0   99.0     52.0   632 345 12 77 1   173       10 14   300 332     59 0 99   52   632
1192842 UT     school 4900005 74 Charter American Preparatory Academy 490000501446 130 American Preparatory Academy - Draper #2   Regular School Yes Elementary KG 06 2020   k_12_total 607.0 24.0 211.0 3.0   347.0       10.0 26.0   601.0 627.0     188.0   0.0   207.0     118.0   1228 607 24 211 3   347       10 26   601 627     188 0 207   118   1228
1192843 UT     school 4900005 74 Charter American Preparatory Academy 490000501471 700 American Preparatory Academy - Draper #3   Regular School Yes High 07 12 2020   k_12_total 388.0 7.0 179.0 4.0   108.0       8.0 20.0   346.0 368.0     75.0   0.0   130.0     82.0   714 388 7 179 4   108       8 20   346 368     75 0 130   82   714
1192844 UT     school 4900005 74 Charter American Preparatory Academy 490000501520 140 American Preparatory Academy - Salem   Regular School Yes Other KG 09 2020   k_12_total 461.0 5.0 44.0 1.0   6.0       10.0 8.0   272.0 263.0     19.0   0.0   154.0     62.0   535 461 5 44 1   6       10 8   272 263     19 0 154   62   535
1192845 UT     school 4900005 74 Charter American Preparatory Academy 490000501372 120 American Preparatory Academy - The School for New Americans   Regular School Yes Elementary KG 06 2020   k_12_total 115.0 42.0 370.0 0.0   33.0       37.0 18.0   294.0 321.0     271.0   0.0   400.0     55.0   615 115 42 370 0   33       37 18   294 321     271 0 400   55   615
1193877 UT     school 4900005 74 Charter American Preparatory Academy 490000501404 110 American Preparatory Academy - Accelerated School   Regular School Yes Other KG 12 2020   kindergarten                                                   85                                             85
1193878 UT     school 4900005 74 Charter American Preparatory Academy 490000500801 100 American Preparatory Academy   Regular School Yes Elementary KG 06 2020   kindergarten                                                   101                                             101
1193879 UT     school 4900005 74 Charter American Preparatory Academy 490000501446 130 American Preparatory Academy - Draper #2   Regular School Yes Elementary KG 06 2020   kindergarten                                                   151                                             151
1193880 UT     school 4900005 74 Charter American Preparatory Academy 490000501471 700 American Preparatory Academy - Draper #3   Regular School Yes High 07 12 2020   kindergarten                                                   0                                             0
1193881 UT     school 4900005 74 Charter American Preparatory Academy 490000501520 140 American Preparatory Academy - Salem   Regular School Yes Other KG 09 2020   kindergarten                                                   67                                             67
1193882 UT     school 4900005 74 Charter American Preparatory Academy 490000501372 120 American Preparatory Academy - The School for New Americans   Regular School Yes Elementary KG 06 2020   kindergarten                                                   85                                             85
1194914 UT     school 4900005 74 Charter American Preparatory Academy 490000501404 110 American Preparatory Academy - Accelerated School   Regular School Yes Other KG 12 2020   grade_1                                                   90                                             90
1194915 UT     school 4900005 74 Charter American Preparatory Academy 490000500801 100 American Preparatory Academy   Regular School Yes Elementary KG 06 2020   grade_1                                                   117                                             117
1194916 UT     school 4900005 74 Charter American Preparatory Academy 490000501446 130 American Preparatory Academy - Draper #2   Regular School Yes Elementary KG 06 2020   grade_1                                                   168                                             168
1194917 UT     school 4900005 74 Charter American Preparatory Academy 490000501471 700 American Preparatory Academy - Draper #3   Regular School Yes High 07 12 2020   grade_1                                                   0                                             0
1194918 UT     school 4900005 74 Charter American Preparatory Academy 490000501520 140 American Preparatory Academy - Salem   Regular School Yes Other KG 09 2020   grade_1                                                   71                                             71
1194919 UT     school 4900005 74 Charter American Preparatory Academy 490000501372 120 American Preparatory Academy - The School for New Americans   Regular School Yes Elementary KG 06 2020   grade_1                                                   83                                             83
1195951 UT     school 4900005 74 Charter American Preparatory Academy 490000501404 110 American Preparatory Academy - Accelerated School   Regular School Yes Other KG 12 2020   grade_2                                                   88                                             88
1195952 UT     school 4900005 74 Charter American Preparatory Academy 490000500801 100 American Preparatory Academy   Regular School Yes Elementary KG 06 2020   grade_2                                                   110                                             110
1195953 UT     school 4900005 74 Charter American Preparatory Academy 490000501446 130 American Preparatory Academy - Draper #2   Regular School Yes Elementary KG 06 2020   grade_2                                                   173                                             173
1195954 UT     school 4900005 74 Charter American Preparatory Academy 490000501471 700 American Preparatory Academy - Draper #3   Regular School Yes High 07 12 2020   grade_2                                                   0                                             0
1195955 UT     school 4900005 74 Charter American Preparatory Academy 490000501520 140 American Preparatory Academy - Salem   Regular School Yes Other KG 09 2020   grade_2                                                   62                                             62
1195956 UT     school 4900005 74 Charter American Preparatory Academy 490000501372 120 American Preparatory Academy - The School for New Americans   Regular School Yes Elementary KG 06 2020   grade_2                                                   85                                             85
1196988 UT     school 4900005 74 Charter American Preparatory Academy 490000501404 110 American Preparatory Academy - Accelerated School   Regular School Yes Other KG 12 2020   grade_3                                                   93                                             93
1196989 UT     school 4900005 74 Charter American Preparatory Academy 490000500801 100 American Preparatory Academy   Regular School Yes Elementary KG 06 2020   grade_3                                                   87                                             87
1196990 UT     school 4900005 74 Charter American Preparatory Academy 490000501446 130 American Preparatory Academy - Draper #2   Regular School Yes Elementary KG 06 2020   grade_3                                                   165                                             165
1196991 UT     school 4900005 74 Charter American Preparatory Academy 490000501471 700 American Preparatory Academy - Draper #3   Regular School Yes High 07 12 2020   grade_3                                                   0                                             0
1196992 UT     school 4900005 74 Charter American Preparatory Academy 490000501520 140 American Preparatory Academy - Salem   Regular School Yes Other KG 09 2020   grade_3                                                   60                                             60
1196993 UT     school 4900005 74 Charter American Preparatory Academy 490000501372 120 American Preparatory Academy - The School for New Americans   Regular School Yes Elementary KG 06 2020   grade_3                                                   90                                             90
1198025 UT     school 4900005 74 Charter American Preparatory Academy 490000501404 110 American Preparatory Academy - Accelerated School   Regular School Yes Other KG 12 2020   grade_4                                                   125                                             125
1198026 UT     school 4900005 74 Charter American Preparatory Academy 490000500801 100 American Preparatory Academy   Regular School Yes Elementary KG 06 2020   grade_4                                                   92                                             92
1198027 UT     school 4900005 74 Charter American Preparatory Academy 490000501446 130 American Preparatory Academy - Draper #2   Regular School Yes Elementary KG 06 2020   grade_4                                                   198                                             198
1198028 UT     school 4900005 74 Charter American Preparatory Academy 490000501471 700 American Preparatory Academy - Draper #3   Regular School Yes High 07 12 2020   grade_4                                                   0                                             0
1198029 UT     school 4900005 74 Charter American Preparatory Academy 490000501520 140 American Preparatory Academy - Salem   Regular School Yes Other KG 09 2020   grade_4                                                   44                                             44
1198030 UT     school 4900005 74 Charter American Preparatory Academy 490000501372 120 American Preparatory Academy - The School for New Americans   Regular School Yes Elementary KG 06 2020   grade_4                                                   88                                             88
1199062 UT     school 4900005 74 Charter American Preparatory Academy 490000501404 110 American Preparatory Academy - Accelerated School   Regular School Yes Other KG 12 2020   grade_5                                                   128                                             128
1199063 UT     school 4900005 74 Charter American Preparatory Academy 490000500801 100 American Preparatory Academy   Regular School Yes Elementary KG 06 2020   grade_5                                                   65                                             65
1199064 UT     school 4900005 74 Charter American Preparatory Academy 490000501446 130 American Preparatory Academy - Draper #2   Regular School Yes Elementary KG 06 2020   grade_5                                                   185                                             185
1199065 UT     school 4900005 74 Charter American Preparatory Academy 490000501471 700 American Preparatory Academy - Draper #3   Regular School Yes High 07 12 2020   grade_5                                                   0                                             0
1199066 UT     school 4900005 74 Charter American Preparatory Academy 490000501520 140 American Preparatory Academy - Salem   Regular School Yes Other KG 09 2020   grade_5                                                   52                                             52
1199067 UT     school 4900005 74 Charter American Preparatory Academy 490000501372 120 American Preparatory Academy - The School for New Americans   Regular School Yes Elementary KG 06 2020   grade_5                                                   88                                             88
1200099 UT     school 4900005 74 Charter American Preparatory Academy 490000501404 110 American Preparatory Academy - Accelerated School   Regular School Yes Other KG 12 2020   grade_6                                                   129                                             129
1200100 UT     school 4900005 74 Charter American Preparatory Academy 490000500801 100 American Preparatory Academy   Regular School Yes Elementary KG 06 2020   grade_6                                                   60                                             60
1200101 UT     school 4900005 74 Charter American Preparatory Academy 490000501446 130 American Preparatory Academy - Draper #2   Regular School Yes Elementary KG 06 2020   grade_6                                                   188                                             188
1200102 UT     school 4900005 74 Charter American Preparatory Academy 490000501471 700 American Preparatory Academy - Draper #3   Regular School Yes High 07 12 2020   grade_6                                                   0                                             0
1200103 UT     school 4900005 74 Charter American Preparatory Academy 490000501520 140 American Preparatory Academy - Salem   Regular School Yes Other KG 09 2020   grade_6                                                   53                                             53
1200104 UT     school 4900005 74 Charter American Preparatory Academy 490000501372 120 American Preparatory Academy - The School for New Americans   Regular School Yes Elementary KG 06 2020   grade_6                                                   96                                             96
1201136 UT     school 4900005 74 Charter American Preparatory Academy 490000501404 110 American Preparatory Academy - Accelerated School   Regular School Yes Other KG 12 2020   grade_7                                                   216                                             216
1201137 UT     school 4900005 74 Charter American Preparatory Academy 490000500801 100 American Preparatory Academy   Regular School Yes Elementary KG 06 2020   grade_7                                                   0                                             0
1201138 UT     school 4900005 74 Charter American Preparatory Academy 490000501446 130 American Preparatory Academy - Draper #2   Regular School Yes Elementary KG 06 2020   grade_7                                                   0                                             0
1201139 UT     school 4900005 74 Charter American Preparatory Academy 490000501471 700 American Preparatory Academy - Draper #3   Regular School Yes High 07 12 2020   grade_7                                                   226                                             226
1201140 UT     school 4900005 74 Charter American Preparatory Academy 490000501520 140 American Preparatory Academy - Salem   Regular School Yes Other KG 09 2020   grade_7                                                   50                                             50
1201141 UT     school 4900005 74 Charter American Preparatory Academy 490000501372 120 American Preparatory Academy - The School for New Americans   Regular School Yes Elementary KG 06 2020   grade_7                                                   0                                             0
1202173 UT     school 4900005 74 Charter American Preparatory Academy 490000501404 110 American Preparatory Academy - Accelerated School   Regular School Yes Other KG 12 2020   grade_8                                                   206                                             206
1202174 UT     school 4900005 74 Charter American Preparatory Academy 490000500801 100 American Preparatory Academy   Regular School Yes Elementary KG 06 2020   grade_8                                                   0                                             0
1202175 UT     school 4900005 74 Charter American Preparatory Academy 490000501446 130 American Preparatory Academy - Draper #2   Regular School Yes Elementary KG 06 2020   grade_8                                                   0                                             0
1202176 UT     school 4900005 74 Charter American Preparatory Academy 490000501471 700 American Preparatory Academy - Draper #3   Regular School Yes High 07 12 2020   grade_8                                                   200                                             200
1202177 UT     school 4900005 74 Charter American Preparatory Academy 490000501520 140 American Preparatory Academy - Salem   Regular School Yes Other KG 09 2020   grade_8                                                   42                                             42
1202178 UT     school 4900005 74 Charter American Preparatory Academy 490000501372 120 American Preparatory Academy - The School for New Americans   Regular School Yes Elementary KG 06 2020   grade_8                                                   0                                             0
1203210 UT     school 4900005 74 Charter American Preparatory Academy 490000501404 110 American Preparatory Academy - Accelerated School   Regular School Yes Other KG 12 2020   grade_9                                                   170                                             170
1203211 UT     school 4900005 74 Charter American Preparatory Academy 490000500801 100 American Preparatory Academy   Regular School Yes Elementary KG 06 2020   grade_9                                                   0                                             0
1203212 UT     school 4900005 74 Charter American Preparatory Academy 490000501446 130 American Preparatory Academy - Draper #2   Regular School Yes Elementary KG 06 2020   grade_9                                                   0                                             0
1203213 UT     school 4900005 74 Charter American Preparatory Academy 490000501471 700 American Preparatory Academy - Draper #3   Regular School Yes High 07 12 2020   grade_9                                                   100                                             100
1203214 UT     school 4900005 74 Charter American Preparatory Academy 490000501520 140 American Preparatory Academy - Salem   Regular School Yes Other KG 09 2020   grade_9                                                   34                                             34
1203215 UT     school 4900005 74 Charter American Preparatory Academy 490000501372 120 American Preparatory Academy - The School for New Americans   Regular School Yes Elementary KG 06 2020   grade_9                                                   0                                             0
1204247 UT     school 4900005 74 Charter American Preparatory Academy 490000501404 110 American Preparatory Academy - Accelerated School   Regular School Yes Other KG 12 2020   grade_10                                                   123                                             123
1204248 UT     school 4900005 74 Charter American Preparatory Academy 490000500801 100 American Preparatory Academy   Regular School Yes Elementary KG 06 2020   grade_10                                                   0                                             0
1204249 UT     school 4900005 74 Charter American Preparatory Academy 490000501446 130 American Preparatory Academy - Draper #2   Regular School Yes Elementary KG 06 2020   grade_10                                                   0                                             0
1204250 UT     school 4900005 74 Charter American Preparatory Academy 490000501471 700 American Preparatory Academy - Draper #3   Regular School Yes High 07 12 2020   grade_10                                                   87                                             87
1204251 UT     school 4900005 74 Charter American Preparatory Academy 490000501520 140 American Preparatory Academy - Salem   Regular School Yes Other KG 09 2020   grade_10                                                   0                                             0
1204252 UT     school 4900005 74 Charter American Preparatory Academy 490000501372 120 American Preparatory Academy - The School for New Americans   Regular School Yes Elementary KG 06 2020   grade_10                                                   0                                             0
1205284 UT     school 4900005 74 Charter American Preparatory Academy 490000501404 110 American Preparatory Academy - Accelerated School   Regular School Yes Other KG 12 2020   grade_11                                                   97                                             97
1205285 UT     school 4900005 74 Charter American Preparatory Academy 490000500801 100 American Preparatory Academy   Regular School Yes Elementary KG 06 2020   grade_11                                                   0                                             0
1205286 UT     school 4900005 74 Charter American Preparatory Academy 490000501446 130 American Preparatory Academy - Draper #2   Regular School Yes Elementary KG 06 2020   grade_11                                                   0                                             0
1205287 UT     school 4900005 74 Charter American Preparatory Academy 490000501471 700 American Preparatory Academy - Draper #3   Regular School Yes High 07 12 2020   grade_11                                                   65                                             65
1205288 UT     school 4900005 74 Charter American Preparatory Academy 490000501520 140 American Preparatory Academy - Salem   Regular School Yes Other KG 09 2020   grade_11                                                   0                                             0
1205289 UT     school 4900005 74 Charter American Preparatory Academy 490000501372 120 American Preparatory Academy - The School for New Americans   Regular School Yes Elementary KG 06 2020   grade_11                                                   0                                             0
1206321 UT     school 4900005 74 Charter American Preparatory Academy 490000501404 110 American Preparatory Academy - Accelerated School   Regular School Yes Other KG 12 2020   grade_12                                                   83                                             83
1206322 UT     school 4900005 74 Charter American Preparatory Academy 490000500801 100 American Preparatory Academy   Regular School Yes Elementary KG 06 2020   grade_12                                                   0                                             0
1206323 UT     school 4900005 74 Charter American Preparatory Academy 490000501446 130 American Preparatory Academy - Draper #2   Regular School Yes Elementary KG 06 2020   grade_12                                                   0                                             0
1206324 UT     school 4900005 74 Charter American Preparatory Academy 490000501471 700 American Preparatory Academy - Draper #3   Regular School Yes High 07 12 2020   grade_12                                                   36                                             36
1206325 UT     school 4900005 74 Charter American Preparatory Academy 490000501520 140 American Preparatory Academy - Salem   Regular School Yes Other KG 09 2020   grade_12                                                   0                                             0
1206326 UT     school 4900005 74 Charter American Preparatory Academy 490000501372 120 American Preparatory Academy - The School for New Americans   Regular School Yes Elementary KG 06 2020   grade_12                                                   0                                             0
1351042 UT     school 4900005 74 Charter American Preparatory Academy 490000501404 110 American Preparatory Academy - Accelerated School   Regular School Yes Other KG 12 2021   k_12_total 302.0 107.0 1042.0 1.0   148.0       37.0 27.0   806.0 858.0     451.0   0.0   853.0     150.0   1664 302 107 1042 1   148       37 27   806 858     451 0 853   150   1664
1351043 UT     school 4900005 74 Charter American Preparatory Academy 490000500801 100 American Preparatory Academy   Regular School Yes Elementary KG 06 2021   k_12_total 325.0 18.0 103.0 1.0   187.0       9.0 13.0   307.0 349.0     54.0   0.0   124.0     50.0   656 325 18 103 1   187       9 13   307 349     54 0 124   50   656
1351044 UT     school 4900005 74 Charter American Preparatory Academy 490000501446 130 American Preparatory Academy - Draper #2   Regular School Yes Elementary KG 06 2021   k_12_total 551.0 23.0 215.0 6.0   399.0       11.0 20.0   585.0 640.0     225.0   0.0   223.0     115.0   1225 551 23 215 6   399       11 20   585 640     225 0 223   115   1225
1351045 UT     school 4900005 74 Charter American Preparatory Academy 490000501471 700 American Preparatory Academy - Draper #3   Regular School Yes High 07 12 2021   k_12_total 363.0 12.0 211.0 3.0   132.0       5.0 23.0   363.0 386.0     106.0   0.0   185.0     80.0   749 363 12 211 3   132       5 23   363 386     106 0 185   80   749
1351046 UT     school 4900005 74 Charter American Preparatory Academy 490000501520 140 American Preparatory Academy - Salem   Regular School Yes Other KG 10 2021   k_12_total 381.0 5.0 49.0 1.0   9.0       5.0 9.0   222.0 237.0     29.0   0.0   145.0     43.0   459 381 5 49 1   9       5 9   222 237     29 0 145   43   459
1351047 UT     school 4900005 74 Charter American Preparatory Academy 490000501372 120 American Preparatory Academy - The School for New Americans   Regular School Yes Other KG 09 2021   k_12_total 127.0 44.0 351.0 0.0   46.0       26.0 12.0   285.0 321.0     214.0   0.0   392.0     54.0   606 127 44 351 0   46       26 12   285 321     214 0 392   54   606
1352089 UT     school 4900005 74 Charter American Preparatory Academy 490000501404 110 American Preparatory Academy - Accelerated School   Regular School Yes Other KG 12 2021   kindergarten                                                   88                                             88
1352090 UT     school 4900005 74 Charter American Preparatory Academy 490000500801 100 American Preparatory Academy   Regular School Yes Elementary KG 06 2021   kindergarten                                                   90                                             90
1352091 UT     school 4900005 74 Charter American Preparatory Academy 490000501446 130 American Preparatory Academy - Draper #2   Regular School Yes Elementary KG 06 2021   kindergarten                                                   168                                             168
1352092 UT     school 4900005 74 Charter American Preparatory Academy 490000501471 700 American Preparatory Academy - Draper #3   Regular School Yes High 07 12 2021   kindergarten                                                   0                                             0
1352093 UT     school 4900005 74 Charter American Preparatory Academy 490000501520 140 American Preparatory Academy - Salem   Regular School Yes Other KG 10 2021   kindergarten                                                   58                                             58
1352094 UT     school 4900005 74 Charter American Preparatory Academy 490000501372 120 American Preparatory Academy - The School for New Americans   Regular School Yes Other KG 09 2021   kindergarten                                                   90                                             90
1353136 UT     school 4900005 74 Charter American Preparatory Academy 490000501404 110 American Preparatory Academy - Accelerated School   Regular School Yes Other KG 12 2021   grade_1                                                   91                                             91
1353137 UT     school 4900005 74 Charter American Preparatory Academy 490000500801 100 American Preparatory Academy   Regular School Yes Elementary KG 06 2021   grade_1                                                   91                                             91
1353138 UT     school 4900005 74 Charter American Preparatory Academy 490000501446 130 American Preparatory Academy - Draper #2   Regular School Yes Elementary KG 06 2021   grade_1                                                   172                                             172
1353139 UT     school 4900005 74 Charter American Preparatory Academy 490000501471 700 American Preparatory Academy - Draper #3   Regular School Yes High 07 12 2021   grade_1                                                   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]);