enrollments

Data source: Big Local News · About: Big Local

14,518 rows where state = "UT" and year = 2020 sorted by district_nces_id

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2020 · 14,518 ✖
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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
1192916 1192916 UT     school 4900008 86 Charter Pinnacle Canyon Academy 490000800629 100 Pinnacle Canyon Academy   Regular School Yes Other KG 12 2020   k_12_total 348.0 1.0 89.0 10.0   0.0       0.0 8.0   241.0 215.0     0.0   0.0   318.0     135.0   456 348 1 89 10   0       0 8   241 215     0 0 318   135   456
1193953 1193953 UT     school 4900008 86 Charter Pinnacle Canyon Academy 490000800629 100 Pinnacle Canyon Academy   Regular School Yes Other KG 12 2020   kindergarten                                                   23                                             23
1194990 1194990 UT     school 4900008 86 Charter Pinnacle Canyon Academy 490000800629 100 Pinnacle Canyon Academy   Regular School Yes Other KG 12 2020   grade_1                                                   26                                             26
1196027 1196027 UT     school 4900008 86 Charter Pinnacle Canyon Academy 490000800629 100 Pinnacle Canyon Academy   Regular School Yes Other KG 12 2020   grade_2                                                   39                                             39
1197064 1197064 UT     school 4900008 86 Charter Pinnacle Canyon Academy 490000800629 100 Pinnacle Canyon Academy   Regular School Yes Other KG 12 2020   grade_3                                                   27                                             27
1198101 1198101 UT     school 4900008 86 Charter Pinnacle Canyon Academy 490000800629 100 Pinnacle Canyon Academy   Regular School Yes Other KG 12 2020   grade_4                                                   28                                             28
1199138 1199138 UT     school 4900008 86 Charter Pinnacle Canyon Academy 490000800629 100 Pinnacle Canyon Academy   Regular School Yes Other KG 12 2020   grade_5                                                   38                                             38
1200175 1200175 UT     school 4900008 86 Charter Pinnacle Canyon Academy 490000800629 100 Pinnacle Canyon Academy   Regular School Yes Other KG 12 2020   grade_6                                                   40                                             40
1201212 1201212 UT     school 4900008 86 Charter Pinnacle Canyon Academy 490000800629 100 Pinnacle Canyon Academy   Regular School Yes Other KG 12 2020   grade_7                                                   46                                             46
1202249 1202249 UT     school 4900008 86 Charter Pinnacle Canyon Academy 490000800629 100 Pinnacle Canyon Academy   Regular School Yes Other KG 12 2020   grade_8                                                   30                                             30
1203286 1203286 UT     school 4900008 86 Charter Pinnacle Canyon Academy 490000800629 100 Pinnacle Canyon Academy   Regular School Yes Other KG 12 2020   grade_9                                                   45                                             45
1204323 1204323 UT     school 4900008 86 Charter Pinnacle Canyon Academy 490000800629 100 Pinnacle Canyon Academy   Regular School Yes Other KG 12 2020   grade_10                                                   39                                             39
1205360 1205360 UT     school 4900008 86 Charter Pinnacle Canyon Academy 490000800629 100 Pinnacle Canyon Academy   Regular School Yes Other KG 12 2020   grade_11                                                   37                                             37
1206397 1206397 UT     school 4900008 86 Charter Pinnacle Canyon Academy 490000800629 100 Pinnacle Canyon Academy   Regular School Yes Other KG 12 2020   grade_12                                                   38                                             38
1192860 1192860 UT     school 4900009 87 Charter City Academy 490000900742 700 City Academy   Regular School Yes High 07 12 2020   k_12_total 73.0 5.0 56.0 1.0   4.0       0.0 9.0   76.0 72.0     22.0   0.0   68.0     30.0   148 73 5 56 1   4       0 9   76 72     22 0 68   30   148
1193897 1193897 UT     school 4900009 87 Charter City Academy 490000900742 700 City Academy   Regular School Yes High 07 12 2020   kindergarten                                                   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]);