enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2021 · 14,658 ✖
Link rowid state county county_state_id admin_level district_nces_id ▼ district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
1351042 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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
1353140 1353140 UT     school 4900005 74 Charter American Preparatory Academy 490000501520 140 American Preparatory Academy - Salem   Regular School Yes Other KG 10 2021   grade_1                                                   53                                             53
1353141 1353141 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   grade_1                                                   84                                             84
1354183 1354183 UT     school 4900005 74 Charter American Preparatory Academy 490000501404 110 American Preparatory Academy - Accelerated School   Regular School Yes Other KG 12 2021   grade_2                                                   84                                             84
1354184 1354184 UT     school 4900005 74 Charter American Preparatory Academy 490000500801 100 American Preparatory Academy   Regular School Yes Elementary KG 06 2021   grade_2                                                   114                                             114
1354185 1354185 UT     school 4900005 74 Charter American Preparatory Academy 490000501446 130 American Preparatory Academy - Draper #2   Regular School Yes Elementary KG 06 2021   grade_2                                                   176                                             176
1354186 1354186 UT     school 4900005 74 Charter American Preparatory Academy 490000501471 700 American Preparatory Academy - Draper #3   Regular School Yes High 07 12 2021   grade_2                                                   0                                             0
1354187 1354187 UT     school 4900005 74 Charter American Preparatory Academy 490000501520 140 American Preparatory Academy - Salem   Regular School Yes Other KG 10 2021   grade_2                                                   61                                             61
1354188 1354188 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   grade_2                                                   89                                             89
1355230 1355230 UT     school 4900005 74 Charter American Preparatory Academy 490000501404 110 American Preparatory Academy - Accelerated School   Regular School Yes Other KG 12 2021   grade_3                                                   93                                             93
1355231 1355231 UT     school 4900005 74 Charter American Preparatory Academy 490000500801 100 American Preparatory Academy   Regular School Yes Elementary KG 06 2021   grade_3                                                   112                                             112
1355232 1355232 UT     school 4900005 74 Charter American Preparatory Academy 490000501446 130 American Preparatory Academy - Draper #2   Regular School Yes Elementary KG 06 2021   grade_3                                                   178                                             178
1355233 1355233 UT     school 4900005 74 Charter American Preparatory Academy 490000501471 700 American Preparatory Academy - Draper #3   Regular School Yes High 07 12 2021   grade_3                                                   0                                             0
1355234 1355234 UT     school 4900005 74 Charter American Preparatory Academy 490000501520 140 American Preparatory Academy - Salem   Regular School Yes Other KG 10 2021   grade_3                                                   46                                             46
1355235 1355235 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   grade_3                                                   96                                             96
1356277 1356277 UT     school 4900005 74 Charter American Preparatory Academy 490000501404 110 American Preparatory Academy - Accelerated School   Regular School Yes Other KG 12 2021   grade_4                                                   133                                             133
1356278 1356278 UT     school 4900005 74 Charter American Preparatory Academy 490000500801 100 American Preparatory Academy   Regular School Yes Elementary KG 06 2021   grade_4                                                   93                                             93
1356279 1356279 UT     school 4900005 74 Charter American Preparatory Academy 490000501446 130 American Preparatory Academy - Draper #2   Regular School Yes Elementary KG 06 2021   grade_4                                                   165                                             165
1356280 1356280 UT     school 4900005 74 Charter American Preparatory Academy 490000501471 700 American Preparatory Academy - Draper #3   Regular School Yes High 07 12 2021   grade_4                                                   0                                             0
1356281 1356281 UT     school 4900005 74 Charter American Preparatory Academy 490000501520 140 American Preparatory Academy - Salem   Regular School Yes Other KG 10 2021   grade_4                                                   52                                             52
1356282 1356282 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   grade_4                                                   76                                             76
1357324 1357324 UT     school 4900005 74 Charter American Preparatory Academy 490000501404 110 American Preparatory Academy - Accelerated School   Regular School Yes Other KG 12 2021   grade_5                                                   131                                             131
1357325 1357325 UT     school 4900005 74 Charter American Preparatory Academy 490000500801 100 American Preparatory Academy   Regular School Yes Elementary KG 06 2021   grade_5                                                   89                                             89
1357326 1357326 UT     school 4900005 74 Charter American Preparatory Academy 490000501446 130 American Preparatory Academy - Draper #2   Regular School Yes Elementary KG 06 2021   grade_5                                                   200                                             200
1357327 1357327 UT     school 4900005 74 Charter American Preparatory Academy 490000501471 700 American Preparatory Academy - Draper #3   Regular School Yes High 07 12 2021   grade_5                                                   0                                             0
1357328 1357328 UT     school 4900005 74 Charter American Preparatory Academy 490000501520 140 American Preparatory Academy - Salem   Regular School Yes Other KG 10 2021   grade_5                                                   44                                             44
1357329 1357329 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   grade_5                                                   81                                             81
1358371 1358371 UT     school 4900005 74 Charter American Preparatory Academy 490000501404 110 American Preparatory Academy - Accelerated School   Regular School Yes Other KG 12 2021   grade_6                                                   131                                             131
1358372 1358372 UT     school 4900005 74 Charter American Preparatory Academy 490000500801 100 American Preparatory Academy   Regular School Yes Elementary KG 06 2021   grade_6                                                   67                                             67
1358373 1358373 UT     school 4900005 74 Charter American Preparatory Academy 490000501446 130 American Preparatory Academy - Draper #2   Regular School Yes Elementary KG 06 2021   grade_6                                                   166                                             166
1358374 1358374 UT     school 4900005 74 Charter American Preparatory Academy 490000501471 700 American Preparatory Academy - Draper #3   Regular School Yes High 07 12 2021   grade_6                                                   0                                             0
1358375 1358375 UT     school 4900005 74 Charter American Preparatory Academy 490000501520 140 American Preparatory Academy - Salem   Regular School Yes Other KG 10 2021   grade_6                                                   44                                             44
1358376 1358376 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   grade_6                                                   90                                             90
1359418 1359418 UT     school 4900005 74 Charter American Preparatory Academy 490000501404 110 American Preparatory Academy - Accelerated School   Regular School Yes Other KG 12 2021   grade_7                                                   216                                             216
1359419 1359419 UT     school 4900005 74 Charter American Preparatory Academy 490000500801 100 American Preparatory Academy   Regular School Yes Elementary KG 06 2021   grade_7                                                   0                                             0
1359420 1359420 UT     school 4900005 74 Charter American Preparatory Academy 490000501446 130 American Preparatory Academy - Draper #2   Regular School Yes Elementary KG 06 2021   grade_7                                                   0                                             0
1359421 1359421 UT     school 4900005 74 Charter American Preparatory Academy 490000501471 700 American Preparatory Academy - Draper #3   Regular School Yes High 07 12 2021   grade_7                                                   238                                             238
1359422 1359422 UT     school 4900005 74 Charter American Preparatory Academy 490000501520 140 American Preparatory Academy - Salem   Regular School Yes Other KG 10 2021   grade_7                                                   44                                             44
1359423 1359423 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   grade_7                                                   0                                             0
1360465 1360465 UT     school 4900005 74 Charter American Preparatory Academy 490000501404 110 American Preparatory Academy - Accelerated School   Regular School Yes Other KG 12 2021   grade_8                                                   205                                             205
1360466 1360466 UT     school 4900005 74 Charter American Preparatory Academy 490000500801 100 American Preparatory Academy   Regular School Yes Elementary KG 06 2021   grade_8                                                   0                                             0
1360467 1360467 UT     school 4900005 74 Charter American Preparatory Academy 490000501446 130 American Preparatory Academy - Draper #2   Regular School Yes Elementary KG 06 2021   grade_8                                                   0                                             0
1360468 1360468 UT     school 4900005 74 Charter American Preparatory Academy 490000501471 700 American Preparatory Academy - Draper #3   Regular School Yes High 07 12 2021   grade_8                                                   200                                             200
1360469 1360469 UT     school 4900005 74 Charter American Preparatory Academy 490000501520 140 American Preparatory Academy - Salem   Regular School Yes Other KG 10 2021   grade_8                                                   31                                             31
1360470 1360470 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   grade_8                                                   0                                             0
1361512 1361512 UT     school 4900005 74 Charter American Preparatory Academy 490000501404 110 American Preparatory Academy - Accelerated School   Regular School Yes Other KG 12 2021   grade_9                                                   171                                             171
1361513 1361513 UT     school 4900005 74 Charter American Preparatory Academy 490000500801 100 American Preparatory Academy   Regular School Yes Elementary KG 06 2021   grade_9                                                   0                                             0
1361514 1361514 UT     school 4900005 74 Charter American Preparatory Academy 490000501446 130 American Preparatory Academy - Draper #2   Regular School Yes Elementary KG 06 2021   grade_9                                                   0                                             0
1361515 1361515 UT     school 4900005 74 Charter American Preparatory Academy 490000501471 700 American Preparatory Academy - Draper #3   Regular School Yes High 07 12 2021   grade_9                                                   111                                             111
1361516 1361516 UT     school 4900005 74 Charter American Preparatory Academy 490000501520 140 American Preparatory Academy - Salem   Regular School Yes Other KG 10 2021   grade_9                                                   26                                             26
1361517 1361517 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   grade_9                                                   0                                             0
1362559 1362559 UT     school 4900005 74 Charter American Preparatory Academy 490000501404 110 American Preparatory Academy - Accelerated School   Regular School Yes Other KG 12 2021   grade_10                                                   127                                             127
1362560 1362560 UT     school 4900005 74 Charter American Preparatory Academy 490000500801 100 American Preparatory Academy   Regular School Yes Elementary KG 06 2021   grade_10                                                   0                                             0
1362561 1362561 UT     school 4900005 74 Charter American Preparatory Academy 490000501446 130 American Preparatory Academy - Draper #2   Regular School Yes Elementary KG 06 2021   grade_10                                                   0                                             0
1362562 1362562 UT     school 4900005 74 Charter American Preparatory Academy 490000501471 700 American Preparatory Academy - Draper #3   Regular School Yes High 07 12 2021   grade_10                                                   80                                             80
1362563 1362563 UT     school 4900005 74 Charter American Preparatory Academy 490000501520 140 American Preparatory Academy - Salem   Regular School Yes Other KG 10 2021   grade_10                                                   0                                             0
1362564 1362564 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   grade_10                                                   0                                             0
1363606 1363606 UT     school 4900005 74 Charter American Preparatory Academy 490000501404 110 American Preparatory Academy - Accelerated School   Regular School Yes Other KG 12 2021   grade_11                                                   104                                             104
1363607 1363607 UT     school 4900005 74 Charter American Preparatory Academy 490000500801 100 American Preparatory Academy   Regular School Yes Elementary KG 06 2021   grade_11                                                   0                                             0
1363608 1363608 UT     school 4900005 74 Charter American Preparatory Academy 490000501446 130 American Preparatory Academy - Draper #2   Regular School Yes Elementary KG 06 2021   grade_11                                                   0                                             0
1363609 1363609 UT     school 4900005 74 Charter American Preparatory Academy 490000501471 700 American Preparatory Academy - Draper #3   Regular School Yes High 07 12 2021   grade_11                                                   65                                             65
1363610 1363610 UT     school 4900005 74 Charter American Preparatory Academy 490000501520 140 American Preparatory Academy - Salem   Regular School Yes Other KG 10 2021   grade_11                                                   0                                             0
1363611 1363611 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   grade_11                                                   0                                             0
1364653 1364653 UT     school 4900005 74 Charter American Preparatory Academy 490000501404 110 American Preparatory Academy - Accelerated School   Regular School Yes Other KG 12 2021   grade_12                                                   90                                             90
1364654 1364654 UT     school 4900005 74 Charter American Preparatory Academy 490000500801 100 American Preparatory Academy   Regular School Yes Elementary KG 06 2021   grade_12                                                   0                                             0
1364655 1364655 UT     school 4900005 74 Charter American Preparatory Academy 490000501446 130 American Preparatory Academy - Draper #2   Regular School Yes Elementary KG 06 2021   grade_12                                                   0                                             0
1364656 1364656 UT     school 4900005 74 Charter American Preparatory Academy 490000501471 700 American Preparatory Academy - Draper #3   Regular School Yes High 07 12 2021   grade_12                                                   55                                             55
1364657 1364657 UT     school 4900005 74 Charter American Preparatory Academy 490000501520 140 American Preparatory Academy - Salem   Regular School Yes Other KG 10 2021   grade_12                                                   0                                             0
1364658 1364658 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   grade_12                                                   0                                             0
1351120 1351120 UT     school 4900008 86 Charter Pinnacle Canyon Academy 490000800629 100 Pinnacle Canyon Academy   Regular School Yes Other PK 12 2021   k_12_total 293.0 1.0 84.0 8.0   0.0       1.0 8.0   209.0 186.0     0.0   0.0   236.0     146.0   395 293 1 84 8   0       1 8   209 186     0 0 236   146   395
1352167 1352167 UT     school 4900008 86 Charter Pinnacle Canyon Academy 490000800629 100 Pinnacle Canyon Academy   Regular School Yes Other PK 12 2021   kindergarten                                                   13                                             13
1353214 1353214 UT     school 4900008 86 Charter Pinnacle Canyon Academy 490000800629 100 Pinnacle Canyon Academy   Regular School Yes Other PK 12 2021   grade_1                                                   23                                             23
1354261 1354261 UT     school 4900008 86 Charter Pinnacle Canyon Academy 490000800629 100 Pinnacle Canyon Academy   Regular School Yes Other PK 12 2021   grade_2                                                   27                                             27
1355308 1355308 UT     school 4900008 86 Charter Pinnacle Canyon Academy 490000800629 100 Pinnacle Canyon Academy   Regular School Yes Other PK 12 2021   grade_3                                                   31                                             31
1356355 1356355 UT     school 4900008 86 Charter Pinnacle Canyon Academy 490000800629 100 Pinnacle Canyon Academy   Regular School Yes Other PK 12 2021   grade_4                                                   25                                             25
1357402 1357402 UT     school 4900008 86 Charter Pinnacle Canyon Academy 490000800629 100 Pinnacle Canyon Academy   Regular School Yes Other PK 12 2021   grade_5                                                   22                                             22
1358449 1358449 UT     school 4900008 86 Charter Pinnacle Canyon Academy 490000800629 100 Pinnacle Canyon Academy   Regular School Yes Other PK 12 2021   grade_6                                                   36                                             36
1359496 1359496 UT     school 4900008 86 Charter Pinnacle Canyon Academy 490000800629 100 Pinnacle Canyon Academy   Regular School Yes Other PK 12 2021   grade_7                                                   37                                             37
1360543 1360543 UT     school 4900008 86 Charter Pinnacle Canyon Academy 490000800629 100 Pinnacle Canyon Academy   Regular School Yes Other PK 12 2021   grade_8                                                   40                                             40
1361590 1361590 UT     school 4900008 86 Charter Pinnacle Canyon Academy 490000800629 100 Pinnacle Canyon Academy   Regular School Yes Other PK 12 2021   grade_9                                                   37                                             37
1362637 1362637 UT     school 4900008 86 Charter Pinnacle Canyon Academy 490000800629 100 Pinnacle Canyon Academy   Regular School Yes Other PK 12 2021   grade_10                                                   43                                             43
1363684 1363684 UT     school 4900008 86 Charter Pinnacle Canyon Academy 490000800629 100 Pinnacle Canyon Academy   Regular School Yes Other PK 12 2021   grade_11                                                   32                                             32
1364731 1364731 UT     school 4900008 86 Charter Pinnacle Canyon Academy 490000800629 100 Pinnacle Canyon Academy   Regular School Yes Other PK 12 2021   grade_12                                                   29                                             29
1351062 1351062 UT     school 4900009 87 Charter City Academy 490000900742 700 City Academy   Regular School Yes High 07 12 2021   k_12_total 69.0 2.0 58.0 0.0   2.0       0.0 5.0   68.0 68.0     14.0   0.0   64.0     33.0   136 69 2 58 0   2       0 5   68 68     14 0 64   33   136
1352109 1352109 UT     school 4900009 87 Charter City Academy 490000900742 700 City Academy   Regular School Yes High 07 12 2021   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]);