enrollments

Data source: Big Local News · About: Big Local

4,865 rows where state = "NV" and year = 2019 sorted by ccd_school_type

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 4,865 ✖
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
1874971 1874971 NV     school 3200030 1   Churchill 320003000868 1902 Churchill Adult   Alternative School No Adult Education AE AE 2019   adult 46.0 1.0 10.0   5.0 2.0         6.0   26.0 44.0                       70 46 1 10   5 2         6   26 44                 70
1876816 1876816 NV     school 3200060 2   Clark 320006000103 2408 Morris Sunset   Alternative School No High 09 12 2019   grade_9 1.0   2.0                   2.0 1.0                       3 1   2                   2 1                 3
1876817 1876817 NV     school 3200060 2   Clark 320006000103 2408 Morris Sunset   Alternative School No High 09 12 2019   grade_10   3.0 4.0             1.0     3.0 5.0                       8   3 4             1     3 5                 8
1876818 1876818 NV     school 3200060 2   Clark 320006000103 2408 Morris Sunset   Alternative School No High 09 12 2019   grade_11 2.0 5.0 10.0               1.0   10.0 8.0                       18 2 5 10               1   10 8                 18
1876819 1876819 NV     school 3200060 2   Clark 320006000103 2408 Morris Sunset   Alternative School No High 09 12 2019   grade_12 2.0 4.0 29.0               2.0   17.0 20.0                       37 2 4 29               2   17 20                 37
1877035 1877035 NV     school 3200060 2   Clark 320006000294 2777 CC Detention   Alternative School No High 06 12 2019   grade_10 1.0 3.0 2.0                   5.0 1.0                       6 1 3 2                   5 1                 6
1877036 1877036 NV     school 3200060 2   Clark 320006000294 2777 CC Detention   Alternative School No High 06 12 2019   grade_11 1.0 7.0 6.0                   12.0 2.0                       14 1 7 6                   12 2                 14
1877037 1877037 NV     school 3200060 2   Clark 320006000294 2777 CC Detention   Alternative School No High 06 12 2019   grade_12 4.0 16.0 5.0             1.0 3.0   28.0 1.0                       29 4 16 5             1 3   28 1                 29
1877059 1877059 NV     school 3200060 2   Clark 320006000020 2912 Juvenile Court   Alternative School No High 06 12 2019   grade_6 1.0                       1.0                         1 1                       1                   1
1877060 1877060 NV     school 3200060 2   Clark 320006000020 2912 Juvenile Court   Alternative School No High 06 12 2019   grade_7 1.0   1.0                   2.0                         2 1   1                   2                   2
1877061 1877061 NV     school 3200060 2   Clark 320006000020 2912 Juvenile Court   Alternative School No High 06 12 2019   grade_8 1.0 2.0                     3.0                         3 1 2                     3                   3
1877062 1877062 NV     school 3200060 2   Clark 320006000020 2912 Juvenile Court   Alternative School No High 06 12 2019   grade_9 2.0   3.0                   4.0 1.0                       5 2   3                   4 1                 5
1877063 1877063 NV     school 3200060 2   Clark 320006000020 2912 Juvenile Court   Alternative School No High 06 12 2019   grade_10 3.0 4.0 8.0                   12.0 3.0                       15 3 4 8                   12 3                 15
1877064 1877064 NV     school 3200060 2   Clark 320006000020 2912 Juvenile Court   Alternative School No High 06 12 2019   grade_11 2.0 8.0 6.0                   11.0 5.0                       16 2 8 6                   11 5                 16
1877065 1877065 NV     school 3200060 2   Clark 320006000020 2912 Juvenile Court   Alternative School No High 06 12 2019   grade_12 4.0 6.0 5.0               1.0   12.0 4.0                       16 4 6 5               1   12 4                 16
1877066 1877066 NV     school 3200060 2   Clark 320006000101 2913 Spring Mtn JSHS   Alternative School No High 06 12 2019   grade_7   1.0                     1.0                         1   1                     1                   1
1877067 1877067 NV     school 3200060 2   Clark 320006000101 2913 Spring Mtn JSHS   Alternative School No High 06 12 2019   grade_8   3.0 2.0                   5.0                         5   3 2                   5                   5
1877068 1877068 NV     school 3200060 2   Clark 320006000101 2913 Spring Mtn JSHS   Alternative School No High 06 12 2019   grade_9   8.0 3.0                   11.0                         11   8 3                   11                   11
1877069 1877069 NV     school 3200060 2   Clark 320006000101 2913 Spring Mtn JSHS   Alternative School No High 06 12 2019   grade_10 3.0 8.0 2.0               1.0   14.0                         14 3 8 2               1   14                   14
1877070 1877070 NV     school 3200060 2   Clark 320006000101 2913 Spring Mtn JSHS   Alternative School No High 06 12 2019   grade_11 6.0 14.0 10.0     1.0         2.0   33.0                         33 6 14 10     1         2   33                   33
1877071 1877071 NV     school 3200060 2   Clark 320006000101 2913 Spring Mtn JSHS   Alternative School No High 06 12 2019   grade_12   17.0 4.0     1.0         1.0   23.0                         23   17 4     1         1   23                   23
1877072 1877072 NV     school 3200060 2   Clark 320006000101 2913 Spring Mtn JSHS   Alternative School No High 06 12 2019   ungraded 1.0                       1.0                         1 1                       1                   1
1877084 1877084 NV     school 3200060 2   Clark 320006000518 2919 Summit View JSHS   Alternative School No High 06 12 2019   grade_9     2.0                   2.0                         2     2                   2                   2
1877085 1877085 NV     school 3200060 2   Clark 320006000518 2919 Summit View JSHS   Alternative School No High 06 12 2019   grade_10 1.0 6.0 2.0                   9.0                         9 1 6 2                   9                   9
1877086 1877086 NV     school 3200060 2   Clark 320006000518 2919 Summit View JSHS   Alternative School No High 06 12 2019   grade_11 2.0 7.0 3.0                   12.0                         12 2 7 3                   12                   12
1877087 1877087 NV     school 3200060 2   Clark 320006000518 2919 Summit View JSHS   Alternative School No High 06 12 2019   grade_12 1.0 5.0 9.0                   15.0                         15 1 5 9                   15                   15
1877088 1877088 NV     school 3200060 2   Clark 320006000313 2922 Burk Horizon SW   Alternative School No High 09 12 2019   grade_9 1.0   1.0                   1.0 1.0                       2 1   1                   1 1                 2
1877089 1877089 NV     school 3200060 2   Clark 320006000313 2922 Burk Horizon SW   Alternative School No High 09 12 2019   grade_10 1.0 2.0 2.0                   2.0 3.0                       5 1 2 2                   2 3                 5
1877090 1877090 NV     school 3200060 2   Clark 320006000313 2922 Burk Horizon SW   Alternative School No High 09 12 2019   grade_11 3.0   3.0     1.0             5.0 2.0                       7 3   3     1             5 2                 7
1877091 1877091 NV     school 3200060 2   Clark 320006000313 2922 Burk Horizon SW   Alternative School No High 09 12 2019   grade_12 3.0 2.0 19.0     3.0       1.0 1.0   19.0 10.0                       29 3 2 19     3       1 1   19 10                 29
1877092 1877092 NV     school 3200060 2   Clark 320006000328 2923 Global Community   Alternative School No High 08 12 2019   grade_9     30.0     2.0             14.0 18.0                       32     30     2             14 18                 32
1877093 1877093 NV     school 3200060 2   Clark 320006000328 2923 Global Community   Alternative School No High 08 12 2019   grade_10 1.0   41.0     2.0       1.0     25.0 20.0                       45 1   41     2       1     25 20                 45
1877094 1877094 NV     school 3200060 2   Clark 320006000328 2923 Global Community   Alternative School No High 08 12 2019   grade_11     33.0     3.0             14.0 22.0                       36     33     3             14 22                 36
1877095 1877095 NV     school 3200060 2   Clark 320006000328 2923 Global Community   Alternative School No High 08 12 2019   grade_12   1.0 33.0     2.0             17.0 19.0                       36   1 33     2             17 19                 36
1877096 1877096 NV     school 3200060 2   Clark 320006000328 2923 Global Community   Alternative School No High 08 12 2019   ungraded 1.0   7.0                   6.0 2.0                       8 1   7                   6 2                 8
1877097 1877097 NV     school 3200060 2   Clark 320006000329 2924 Cowan Sunset SE   Alternative School No High 08 12 2019   grade_11 5.0 1.0 6.0                   7.0 5.0                       12 5 1 6                   7 5                 12
1877098 1877098 NV     school 3200060 2   Clark 320006000329 2924 Cowan Sunset SE   Alternative School No High 08 12 2019   grade_12 3.0 1.0 10.0     1.0         2.0   6.0 11.0                       17 3 1 10     1         2   6 11                 17
1877104 1877104 NV     school 3200060 2   Clark 320006000499 2928 South Cont JSHS   Alternative School No High 06 12 2019   grade_6 1.0 5.0 2.0                   3.0 5.0                       8 1 5 2                   3 5                 8
1877105 1877105 NV     school 3200060 2   Clark 320006000499 2928 South Cont JSHS   Alternative School No High 06 12 2019   grade_7   6.0 4.0               1.0   9.0 2.0                       11   6 4               1   9 2                 11
1877106 1877106 NV     school 3200060 2   Clark 320006000499 2928 South Cont JSHS   Alternative School No High 06 12 2019   grade_8 3.0 15.0 5.0                   10.0 13.0                       23 3 15 5                   10 13                 23
1877107 1877107 NV     school 3200060 2   Clark 320006000499 2928 South Cont JSHS   Alternative School No High 06 12 2019   grade_9 3.0 2.0 6.0             1.0 1.0   9.0 4.0                       13 3 2 6             1 1   9 4                 13
1877108 1877108 NV     school 3200060 2   Clark 320006000499 2928 South Cont JSHS   Alternative School No High 06 12 2019   grade_10 1.0 10.0 4.0     1.0             8.0 8.0                       16 1 10 4     1             8 8                 16
1877109 1877109 NV     school 3200060 2   Clark 320006000499 2928 South Cont JSHS   Alternative School No High 06 12 2019   grade_11 2.0 4.0 1.0                   3.0 4.0                       7 2 4 1                   3 4                 7
1877110 1877110 NV     school 3200060 2   Clark 320006000499 2928 South Cont JSHS   Alternative School No High 06 12 2019   grade_12   2.0 2.0               1.0   4.0 1.0                       5   2 2               1   4 1                 5
1877111 1877111 NV     school 3200060 2   Clark 320006000597 2932 Cowan Behavior   Alternative School No High 06 12 2019   grade_6   1.0                       1.0                       1   1                       1                 1
1877112 1877112 NV     school 3200060 2   Clark 320006000597 2932 Cowan Behavior   Alternative School No High 06 12 2019   grade_7   2.0 6.0               1.0   7.0 2.0                       9   2 6               1   7 2                 9
1877113 1877113 NV     school 3200060 2   Clark 320006000597 2932 Cowan Behavior   Alternative School No High 06 12 2019   grade_8 3.0 9.0 9.0             1.0 1.0   13.0 10.0                       23 3 9 9             1 1   13 10                 23
1877114 1877114 NV     school 3200060 2   Clark 320006000597 2932 Cowan Behavior   Alternative School No High 06 12 2019   grade_9 3.0 7.0 14.0               2.0   19.0 7.0                       26 3 7 14               2   19 7                 26
1877115 1877115 NV     school 3200060 2   Clark 320006000597 2932 Cowan Behavior   Alternative School No High 06 12 2019   grade_10 2.0 7.0 8.0               1.0   12.0 6.0                       18 2 7 8               1   12 6                 18
1877116 1877116 NV     school 3200060 2   Clark 320006000597 2932 Cowan Behavior   Alternative School No High 06 12 2019   grade_11 1.0 2.0 7.0   2.0 1.0             10.0 3.0                       13 1 2 7   2 1             10 3                 13
1877117 1877117 NV     school 3200060 2   Clark 320006000597 2932 Cowan Behavior   Alternative School No High 06 12 2019   grade_12 3.0 2.0 3.0                   7.0 1.0                       8 3 2 3                   7 1                 8
1877118 1877118 NV     school 3200060 2   Clark 320006000598 2933 Peterson Behavior   Alternative School No High 06 12 2019   grade_7   3.0 1.0                   2.0 2.0                       4   3 1                   2 2                 4
1877119 1877119 NV     school 3200060 2   Clark 320006000598 2933 Peterson Behavior   Alternative School No High 06 12 2019   grade_8 3.0 13.0 10.0             1.0 1.0   22.0 6.0                       28 3 13 10             1 1   22 6                 28
1877120 1877120 NV     school 3200060 2   Clark 320006000598 2933 Peterson Behavior   Alternative School No High 06 12 2019   grade_9 1.0 7.0 6.0                   13.0 1.0                       14 1 7 6                   13 1                 14
1877121 1877121 NV     school 3200060 2   Clark 320006000598 2933 Peterson Behavior   Alternative School No High 06 12 2019   grade_10 1.0 5.0 8.0               1.0   11.0 4.0                       15 1 5 8               1   11 4                 15
1877122 1877122 NV     school 3200060 2   Clark 320006000598 2933 Peterson Behavior   Alternative School No High 06 12 2019   grade_11 1.0 9.0 4.0               2.0   10.0 6.0                       16 1 9 4               2   10 6                 16
1877123 1877123 NV     school 3200060 2   Clark 320006000598 2933 Peterson Behavior   Alternative School No High 06 12 2019   grade_12 1.0 2.0 5.0               1.0   8.0 1.0                       9 1 2 5               1   8 1                 9
1877129 1877129 NV     school 3200060 2   Clark 320006000795 2941 Adult Ed   Alternative School No High 12 12 2019   grade_12     2.0                   1.0 1.0                       2     2                   1 1                 2
1877130 1877130 NV     school 3200060 2   Clark 320006000795 2941 Adult Ed   Alternative School No High 12 12 2019   adult 553.0 1035.0 3225.0   32.0 117.0       42.0 102.0   2120.0 2986.0                       5106 553 1035 3225   32 117       42 102   2120 2986                 5106
1877131 1877131 NV     school 3200060 2   Clark 320006000767 2955 Desert Rose ALT   Alternative School No High 09 12 2019   grade_9   1.0 1.0                     2.0                       2   1 1                     2                 2
1877132 1877132 NV     school 3200060 2   Clark 320006000767 2955 Desert Rose ALT   Alternative School No High 09 12 2019   grade_10   3.0 4.0             1.0     3.0 5.0                       8   3 4             1     3 5                 8
1877133 1877133 NV     school 3200060 2   Clark 320006000767 2955 Desert Rose ALT   Alternative School No High 09 12 2019   grade_11 10.0 45.0 52.0             1.0     58.0 50.0                       108 10 45 52             1     58 50                 108
1877134 1877134 NV     school 3200060 2   Clark 320006000767 2955 Desert Rose ALT   Alternative School No High 09 12 2019   grade_12 11.0 105.0 133.0   3.0 3.0       2.0 8.0   140.0 125.0                       265 11 105 133   3 3       2 8   140 125                 265
1877135 1877135 NV     school 3200060 2   Clark 320006000878 2957 Mission HS   Alternative School No High 06 12 2019   grade_9     2.0                   2.0                         2     2                   2                   2
1877136 1877136 NV     school 3200060 2   Clark 320006000878 2957 Mission HS   Alternative School No High 06 12 2019   grade_10 3.0 1.0 2.0     1.0         2.0   4.0 5.0                       9 3 1 2     1         2   4 5                 9
1877137 1877137 NV     school 3200060 2   Clark 320006000878 2957 Mission HS   Alternative School No High 06 12 2019   grade_11 4.0 3.0 7.0               1.0   5.0 10.0                       15 4 3 7               1   5 10                 15
1877138 1877138 NV     school 3200060 2   Clark 320006000878 2957 Mission HS   Alternative School No High 06 12 2019   grade_12 2.0 3.0 5.0             1.0 1.0   5.0 7.0                       12 2 3 5             1 1   5 7                 12
1877205 1877205 NV     school 3200090 3   Douglas 320009000348 3503 Jacobsen HS   Alternative School No High 07 12 2019   grade_7 1.0   1.0                   1.0 1.0                       2 1   1                   1 1                 2
1877206 1877206 NV     school 3200090 3   Douglas 320009000348 3503 Jacobsen HS   Alternative School No High 07 12 2019   grade_8 3.0   3.0                   5.0 1.0                       6 3   3                   5 1                 6
1877207 1877207 NV     school 3200090 3   Douglas 320009000348 3503 Jacobsen HS   Alternative School No High 07 12 2019   grade_9 4.0                       4.0                         4 4                       4                   4
1877208 1877208 NV     school 3200090 3   Douglas 320009000348 3503 Jacobsen HS   Alternative School No High 07 12 2019   grade_10 7.0   4.0                   9.0 2.0                       11 7   4                   9 2                 11
1877209 1877209 NV     school 3200090 3   Douglas 320009000348 3503 Jacobsen HS   Alternative School No High 07 12 2019   grade_11 5.0 1.0 4.0               1.0   8.0 3.0                       11 5 1 4               1   8 3                 11
1877210 1877210 NV     school 3200090 3   Douglas 320009000348 3503 Jacobsen HS   Alternative School No High 07 12 2019   grade_12 5.0   4.0               1.0   7.0 3.0                       10 5   4               1   7 3                 10
1877211 1877211 NV     school 3200090 3   Douglas 320009000832 3504 ASPIRE HS   Alternative School No High 09 12 2019   grade_9 3.0   3.0     1.0             6.0 1.0                       7 3   3     1             6 1                 7
1877212 1877212 NV     school 3200090 3   Douglas 320009000832 3504 ASPIRE HS   Alternative School No High 09 12 2019   grade_10 14.0   1.0   2.0               11.0 6.0                       17 14   1   2               11 6                 17
1877213 1877213 NV     school 3200090 3   Douglas 320009000832 3504 ASPIRE HS   Alternative School No High 09 12 2019   grade_11 11.0   3.0               2.0   6.0 10.0                       16 11   3               2   6 10                 16
1877214 1877214 NV     school 3200090 3   Douglas 320009000832 3504 ASPIRE HS   Alternative School No High 09 12 2019   grade_12 24.0 1.0 6.0   2.0           2.0   22.0 13.0                       35 24 1 6   2           2   22 13                 35
1877215 1877215 NV     school 3200090 3   Douglas 320009000832 3504 ASPIRE HS   Alternative School No High 09 12 2019   ungraded 2.0                       2.0                         2 2                       2                   2
1877216 1877216 NV     school 3200090 3   Douglas 320009000764 3901 Douglas ALT ALT   Alternative School No Other 04 12 2019   grade_8 2.0                         2.0                       2 2                         2                 2
1877217 1877217 NV     school 3200090 3   Douglas 320009000764 3901 Douglas ALT ALT   Alternative School No Other 04 12 2019   grade_9 1.0                       1.0                         1 1                       1                   1
1877218 1877218 NV     school 3200090 3   Douglas 320009000764 3901 Douglas ALT ALT   Alternative School No Other 04 12 2019   grade_10         1.0           1.0     2.0                       2         1           1     2                 2
1877219 1877219 NV     school 3200090 3   Douglas 320009000861 3903 Douglas Adult   Alternative School No Adult Education AE AE 2019   adult 16.0 1.0 4.0   1.0               8.0 14.0                       22 16 1 4   1               8 14                 22
1877378 1877378 NV     school 3200120 4   Elko 320012000854 4902 Elko Adult   Alternative School No Ungraded UG UG 2019   ungraded     2.0                     2.0                       2     2                     2                 2
1877496 1877496 NV     school 3200210 7   Humboldt 320021000858 7903 Humboldt AD   Alternative School No Adult Education AE AE 2019   adult 5.0   5.0     1.0             4.0 7.0                       11 5   5     1             4 7                 11
1877562 1877562 NV     school 3200270 9   Lincoln 320027000169 9602 C O Bastian   Alternative School No High 07 12 2019   grade_7   1.0                     1.0                         1   1                     1                   1
1877563 1877563 NV     school 3200270 9   Lincoln 320027000169 9602 C O Bastian   Alternative School No High 07 12 2019   grade_8 1.0 5.0 3.0                   7.0 2.0                       9 1 5 3                   7 2                 9
1877564 1877564 NV     school 3200270 9   Lincoln 320027000169 9602 C O Bastian   Alternative School No High 07 12 2019   grade_9 2.0 7.0 4.0   1.0         1.0     13.0 2.0                       15 2 7 4   1         1     13 2                 15
1877565 1877565 NV     school 3200270 9   Lincoln 320027000169 9602 C O Bastian   Alternative School No High 07 12 2019   grade_10 5.0 8.0 6.0             1.0     10.0 10.0                       20 5 8 6             1     10 10                 20
1877566 1877566 NV     school 3200270 9   Lincoln 320027000169 9602 C O Bastian   Alternative School No High 07 12 2019   grade_11 5.0 16.0 11.0             1.0     16.0 17.0                       33 5 16 11             1     16 17                 33
1877567 1877567 NV     school 3200270 9   Lincoln 320027000169 9602 C O Bastian   Alternative School No High 07 12 2019   grade_12 6.0 8.0 13.0   2.0               16.0 13.0                       29 6 8 13   2               16 13                 29
1877568 1877568 NV     school 3200270 9   Lincoln 320027000865 9603 Lincoln AD   Alternative School No Adult Education AE AE 2019   adult 18.0   2.0             1.0 1.0   10.0 12.0                       22 18   2             1 1   10 12                 22
1877671 1877671 NV     school 3200300 10   Lyon 320030000768 10902 Western NV Yth Ct   Alternative School No High 07 12 2019   grade_9 1.0   1.0                   2.0                         2 1   1                   2                   2
1877672 1877672 NV     school 3200300 10   Lyon 320030000768 10902 Western NV Yth Ct   Alternative School No High 07 12 2019   grade_10 3.0   1.0   1.0               4.0 1.0                       5 3   1   1               4 1                 5
1877673 1877673 NV     school 3200300 10   Lyon 320030000768 10902 Western NV Yth Ct   Alternative School No High 07 12 2019   grade_11 1.0                   1.0   2.0                         2 1                   1   2                   2
1877674 1877674 NV     school 3200300 10   Lyon 320030000768 10902 Western NV Yth Ct   Alternative School No High 07 12 2019   grade_12 1.0       1.0               1.0 1.0                       2 1       1               1 1                 2
1877675 1877675 NV     school 3200300 10   Lyon 320030000860 10907 Lyon Adult Ed   Alternative School No Adult Education AE AE 2019   adult 27.0 1.0 8.0   1.0         1.0 1.0   18.0 21.0                       39 27 1 8   1         1 1   18 21                 39
1877700 1877700 NV     school 3200330 11   Mineral 320033000859 11925 MCAE   Alternative School No Adult Education AE AE 2019   adult 15.0   1.0   4.0               8.0 12.0                       20 15   1   4               8 12                 20
1877814 1877814 NV     school 3200360 12   Nye 320036000557 12606 Pathways HS ALT   Alternative School No High 09 12 2019   grade_9 13.0   4.0               2.0   7.0 12.0                       19 13   4               2   7 12                 19
1877815 1877815 NV     school 3200360 12   Nye 320036000557 12606 Pathways HS ALT   Alternative School No High 09 12 2019   grade_10 21.0   3.0   1.0           2.0   18.0 9.0                       27 21   3   1           2   18 9                 27
1877816 1877816 NV     school 3200360 12   Nye 320036000557 12606 Pathways HS ALT   Alternative School No High 09 12 2019   grade_11 39.0 2.0 18.0     1.0       1.0 1.0   28.0 34.0                       62 39 2 18     1       1 1   28 34                 62

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