enrollments

Data source: Big Local News · About: Big Local

14,695 rows where state = "NV" sorted by black

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black ▼ hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
1876943 1876943 NV     school 3200060 2   Clark 320006000078 2602 Moapa Valley   Regular School No High 09 12 2019   grade_12 99.0   21.0   6.0         1.0 1.0   66.0 62.0                       128 99   21   6         1 1   66 62                 128
1876944 1876944 NV     school 3200060 2   Clark 320006000078 2602 Moapa Valley   Regular School No High 09 12 2019   ungraded 1.0                         1.0                       1 1                         1                 1
1876949 1876949 NV     school 3200060 2   Clark 320006000111 2603 Virgin Valley   Regular School No High 09 12 2019   ungraded 1.0   2.0               1.0   2.0 2.0                       4 1   2               1   2 2                 4
1876950 1876950 NV     school 3200060 2   Clark 320006000686 2604 Indian Springs HS   Regular School No High 09 12 2019   grade_9 12.0   7.0   2.0               12.0 9.0                       21 12   7   2               12 9                 21
1876951 1876951 NV     school 3200060 2   Clark 320006000686 2604 Indian Springs HS   Regular School No High 09 12 2019   grade_10 11.0   2.0               2.0   10.0 5.0                       15 11   2               2   10 5                 15
1876952 1876952 NV     school 3200060 2   Clark 320006000686 2604 Indian Springs HS   Regular School No High 09 12 2019   grade_11 10.0   1.0   2.0               7.0 6.0                       13 10   1   2               7 6                 13
1876953 1876953 NV     school 3200060 2   Clark 320006000686 2604 Indian Springs HS   Regular School No High 09 12 2019   grade_12 14.0   2.0   2.0               12.0 6.0                       18 14   2   2               12 6                 18
1877038 1877038 NV     school 3200060 2   Clark 320006000774 2910 Stewart Sch   Special Education School No Other PK 12 2019   grade_1     1.0                   1.0                         1     1                   1                   1
1877039 1877039 NV     school 3200060 2   Clark 320006000774 2910 Stewart Sch   Special Education School No Other PK 12 2019   grade_2     1.0     1.0             2.0                         2     1     1             2                   2
1877056 1877056 NV     school 3200060 2   Clark 320006000108 2911 Variety School E SEC   Special Education School No High 06 12 2019   grade_11 4.0   3.0               1.0   6.0 2.0                       8 4   3               1   6 2                 8
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
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
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
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
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
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
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
1877101 1877101 NV     school 3200060 2   Clark 320006000683 2927 Desert Willow   Special Education School No High 06 12 2019   grade_9     1.0                   1.0                         1     1                   1                   1
1877102 1877102 NV     school 3200060 2   Clark 320006000683 2927 Desert Willow   Special Education School No High 06 12 2019   grade_10 1.0         1.0             1.0 1.0                       2 1         1             1 1                 2
1877124 1877124 NV     school 3200060 2   Clark 320006000619 2935 Variety School ES   Special Education School No Elementary PK 05 2019   grade_2 1.0                         1.0                       1 1                         1                 1
1877127 1877127 NV     school 3200060 2   Clark 320006000619 2935 Variety School ES   Special Education School No Elementary PK 05 2019   grade_5 2.0   3.0     1.0             5.0 1.0                       6 2   3     1             5 1                 6
1877128 1877128 NV     school 3200060 2   Clark 320006000619 2935 Variety School ES   Special Education School No Elementary PK 05 2019   kindergarten 1.0                       1.0                         1 1                       1                   1
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
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
1877139 1877139 NV     school 3200090 3   Douglas 320009000121 3201 Gardnerville ES   Regular School No Elementary PK 05 2019   grade_1 36.0   20.0   1.0 1.0         3.0   33.0 28.0                       61 36   20   1 1         3   33 28                 61
1877141 1877141 NV     school 3200090 3   Douglas 320009000121 3201 Gardnerville ES   Regular School No Elementary PK 05 2019   grade_3 45.0   17.0     2.0         3.0   30.0 37.0                       67 45   17     2         3   30 37                 67
1877142 1877142 NV     school 3200090 3   Douglas 320009000121 3201 Gardnerville ES   Regular School No Elementary PK 05 2019   grade_4 34.0   17.0     1.0         5.0   30.0 27.0                       57 34   17     1         5   30 27                 57
1877144 1877144 NV     school 3200090 3   Douglas 320009000121 3201 Gardnerville ES   Regular School No Elementary PK 05 2019   kindergarten 37.0   14.0   1.0           1.0   17.0 36.0                       53 37   14   1           1   17 36                 53
1877145 1877145 NV     school 3200090 3   Douglas 320009000121 3201 Gardnerville ES   Regular School No Elementary PK 05 2019   pre_kindergarten 1.0                         1.0                       1 1                         1                 1
1877146 1877146 NV     school 3200090 3   Douglas 320009000124 3202 Zephyr Cove   Regular School No Elementary PK 06 2019   grade_1 10.0   4.0   1.0 1.0         1.0   10.0 7.0                       17 10   4   1 1         1   10 7                 17
1877147 1877147 NV     school 3200090 3   Douglas 320009000124 3202 Zephyr Cove   Regular School No Elementary PK 06 2019   grade_2 22.0   5.0               3.0   16.0 14.0                       30 22   5               3   16 14                 30
1877149 1877149 NV     school 3200090 3   Douglas 320009000124 3202 Zephyr Cove   Regular School No Elementary PK 06 2019   grade_4 16.0   7.0               3.0   13.0 13.0                       26 16   7               3   13 13                 26
1877151 1877151 NV     school 3200090 3   Douglas 320009000124 3202 Zephyr Cove   Regular School No Elementary PK 06 2019   grade_6 16.0   6.0     1.0         2.0   11.0 14.0                       25 16   6     1         2   11 14                 25
1877153 1877153 NV     school 3200090 3   Douglas 320009000124 3202 Zephyr Cove   Regular School No Elementary PK 06 2019   pre_kindergarten 2.0                   1.0   1.0 2.0                       3 2                   1   1 2                 3
1877154 1877154 NV     school 3200090 3   Douglas 320009000293 3205 Meneley ES   Regular School No Elementary PK 05 2019   grade_1 46.0   26.0   10.0           7.0   49.0 40.0                       89 46   26   10           7   49 40                 89
1877156 1877156 NV     school 3200090 3   Douglas 320009000293 3205 Meneley ES   Regular School No Elementary PK 05 2019   grade_3 48.0   19.0   14.0           2.0   41.0 42.0                       83 48   19   14           2   41 42                 83
1877157 1877157 NV     school 3200090 3   Douglas 320009000293 3205 Meneley ES   Regular School No Elementary PK 05 2019   grade_4 41.0   16.0   7.0           6.0   37.0 33.0                       70 41   16   7           6   37 33                 70
1877158 1877158 NV     school 3200090 3   Douglas 320009000293 3205 Meneley ES   Regular School No Elementary PK 05 2019   grade_5 45.0   21.0   8.0           5.0   39.0 40.0                       79 45   21   8           5   39 40                 79
1877159 1877159 NV     school 3200090 3   Douglas 320009000293 3205 Meneley ES   Regular School No Elementary PK 05 2019   kindergarten 34.0   8.0   4.0 1.0         5.0   24.0 28.0                       52 34   8   4 1         5   24 28                 52
1877160 1877160 NV     school 3200090 3   Douglas 320009000293 3205 Meneley ES   Regular School No Elementary PK 05 2019   pre_kindergarten 46.0   9.0   2.0           2.0   32.0 27.0                       59 46   9   2           2   32 27                 59
1877161 1877161 NV     school 3200090 3   Douglas 320009000307 3206 Jacks Vly ES   Regular School No Elementary PK 05 2019   grade_1 35.0   15.0   1.0 1.0         11.0   32.0 31.0                       63 35   15   1 1         11   32 31                 63
1877162 1877162 NV     school 3200090 3   Douglas 320009000307 3206 Jacks Vly ES   Regular School No Elementary PK 05 2019   grade_2 31.0   15.0   1.0 1.0       2.0 2.0   24.0 28.0                       52 31   15   1 1       2 2   24 28                 52
1877163 1877163 NV     school 3200090 3   Douglas 320009000307 3206 Jacks Vly ES   Regular School No Elementary PK 05 2019   grade_3 44.0   25.0   2.0 1.0         6.0   44.0 34.0                       78 44   25   2 1         6   44 34                 78
1877164 1877164 NV     school 3200090 3   Douglas 320009000307 3206 Jacks Vly ES   Regular School No Elementary PK 05 2019   grade_4 38.0   19.0   1.0 2.0       1.0 4.0   31.0 34.0                       65 38   19   1 2       1 4   31 34                 65
1877165 1877165 NV     school 3200090 3   Douglas 320009000307 3206 Jacks Vly ES   Regular School No Elementary PK 05 2019   grade_5 30.0   25.0   2.0         1.0 6.0   30.0 34.0                       64 30   25   2         1 6   30 34                 64
1877166 1877166 NV     school 3200090 3   Douglas 320009000307 3206 Jacks Vly ES   Regular School No Elementary PK 05 2019   kindergarten 26.0   19.0   1.0 3.0         3.0   24.0 28.0                       52 26   19   1 3         3   24 28                 52
1877167 1877167 NV     school 3200090 3   Douglas 320009000307 3206 Jacks Vly ES   Regular School No Elementary PK 05 2019   pre_kindergarten 32.0   16.0               6.0   34.0 20.0                       54 32   16               6   34 20                 54
1877168 1877168 NV     school 3200090 3   Douglas 320009000347 3207 Scarselli ES   Regular School No Elementary PK 05 2019   grade_1 47.0   16.0               9.0   40.0 32.0                       72 47   16               9   40 32                 72
1877170 1877170 NV     school 3200090 3   Douglas 320009000347 3207 Scarselli ES   Regular School No Elementary PK 05 2019   grade_3 48.0   15.0   2.0           8.0   40.0 33.0                       73 48   15   2           8   40 33                 73
1877171 1877171 NV     school 3200090 3   Douglas 320009000347 3207 Scarselli ES   Regular School No Elementary PK 05 2019   grade_4 51.0   11.0   2.0         1.0     40.0 25.0                       65 51   11   2         1     40 25                 65
1877172 1877172 NV     school 3200090 3   Douglas 320009000347 3207 Scarselli ES   Regular School No Elementary PK 05 2019   grade_5 53.0   13.0               7.0   42.0 31.0                       73 53   13               7   42 31                 73
1877173 1877173 NV     school 3200090 3   Douglas 320009000347 3207 Scarselli ES   Regular School No Elementary PK 05 2019   kindergarten 55.0   13.0   1.0 1.0         7.0   38.0 39.0                       77 55   13   1 1         7   38 39                 77
1877174 1877174 NV     school 3200090 3   Douglas 320009000447 3209 Pinon Hills   Regular School No Elementary PK 05 2019   grade_1 35.0   5.0               3.0   19.0 24.0                       43 35   5               3   19 24                 43
1877175 1877175 NV     school 3200090 3   Douglas 320009000447 3209 Pinon Hills   Regular School No Elementary PK 05 2019   grade_2 38.0   10.0               2.0   23.0 27.0                       50 38   10               2   23 27                 50
1877176 1877176 NV     school 3200090 3   Douglas 320009000447 3209 Pinon Hills   Regular School No Elementary PK 05 2019   grade_3 36.0   1.0   1.0           4.0   22.0 20.0                       42 36   1   1           4   22 20                 42
1877178 1877178 NV     school 3200090 3   Douglas 320009000447 3209 Pinon Hills   Regular School No Elementary PK 05 2019   grade_5 61.0   8.0     2.0         1.0   37.0 35.0                       72 61   8     2         1   37 35                 72
1877179 1877179 NV     school 3200090 3   Douglas 320009000447 3209 Pinon Hills   Regular School No Elementary PK 05 2019   kindergarten 41.0   9.0     1.0         1.0   35.0 17.0                       52 41   9     1         1   35 17                 52
1877180 1877180 NV     school 3200090 3   Douglas 320009000447 3209 Pinon Hills   Regular School No Elementary PK 05 2019   pre_kindergarten 1.0                       1.0                         1 1                       1                   1
1877181 1877181 NV     school 3200090 3   Douglas 320009000448 3210 Minden ES   Regular School No Elementary PK 05 2019   grade_1 48.0   7.0     1.0         2.0   38.0 20.0                       58 48   7     1         2   38 20                 58
1877182 1877182 NV     school 3200090 3   Douglas 320009000448 3210 Minden ES   Regular School No Elementary PK 05 2019   grade_2 43.0   6.0   2.0           1.0   29.0 23.0                       52 43   6   2           1   29 23                 52
1877183 1877183 NV     school 3200090 3   Douglas 320009000448 3210 Minden ES   Regular School No Elementary PK 05 2019   grade_3 52.0   13.0     1.0         2.0   31.0 37.0                       68 52   13     1         2   31 37                 68
1877184 1877184 NV     school 3200090 3   Douglas 320009000448 3210 Minden ES   Regular School No Elementary PK 05 2019   grade_4 61.0   15.0     1.0             44.0 33.0                       77 61   15     1             44 33                 77
1877185 1877185 NV     school 3200090 3   Douglas 320009000448 3210 Minden ES   Regular School No Elementary PK 05 2019   grade_5 52.0   10.0               2.0   37.0 27.0                       64 52   10               2   37 27                 64
1877186 1877186 NV     school 3200090 3   Douglas 320009000448 3210 Minden ES   Regular School No Elementary PK 05 2019   kindergarten 51.0   17.0               4.0   34.0 38.0                       72 51   17               4   34 38                 72
1877187 1877187 NV     school 3200090 3   Douglas 320009000448 3210 Minden ES   Regular School No Elementary PK 05 2019   pre_kindergarten 3.0   19.0     1.0         1.0   9.0 15.0                       24 3   19     1         1   9 15                 24
1877191 1877191 NV     school 3200090 3   Douglas 320009000422 3302 Pau Wa Lu   Regular School No Middle 06 08 2019   grade_6 108.0   37.0   8.0           16.0   98.0 71.0                       169 108   37   8           16   98 71                 169
1877192 1877192 NV     school 3200090 3   Douglas 320009000422 3302 Pau Wa Lu   Regular School No Middle 06 08 2019   grade_7 124.0   50.0   12.0           11.0   111.0 86.0                       197 124   50   12           11   111 86                 197
1877193 1877193 NV     school 3200090 3   Douglas 320009000422 3302 Pau Wa Lu   Regular School No Middle 06 08 2019   grade_8 124.0   33.0   9.0 1.0       1.0 12.0   98.0 82.0                       180 124   33   9 1       1 12   98 82                 180
1877198 1877198 NV     school 3200090 3   Douglas 320009000120 3501 Douglas HS   Regular School No High 09 12 2019   ungraded 5.0   2.0   1.0               5.0 3.0                       8 5   2   1               5 3                 8
1877200 1877200 NV     school 3200090 3   Douglas 320009000122 3502 Whittell   Regular School No High 07 12 2019   grade_8 24.0   4.0   2.0 1.0         2.0   15.0 18.0                       33 24   4   2 1         2   15 18                 33
1877203 1877203 NV     school 3200090 3   Douglas 320009000122 3502 Whittell   Regular School No High 07 12 2019   grade_11 17.0   9.0                   15.0 11.0                       26 17   9                   15 11                 26
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
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
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
1877220 1877220 NV     school 3200120 4   Elko 320012000131 4104 Independence Vly ES   Regular School No Elementary KG 08 2019   grade_1 2.0                       2.0                         2 2                       2                   2
1877221 1877221 NV     school 3200120 4   Elko 320012000131 4104 Independence Vly ES   Regular School No Elementary KG 08 2019   grade_2 1.0                         1.0                       1 1                         1                 1
1877222 1877222 NV     school 3200120 4   Elko 320012000131 4104 Independence Vly ES   Regular School No Elementary KG 08 2019   grade_3 1.0                         1.0                       1 1                         1                 1
1877223 1877223 NV     school 3200120 4   Elko 320012000131 4104 Independence Vly ES   Regular School No Elementary KG 08 2019   grade_4     1.0                     1.0                       1     1                     1                 1
1877224 1877224 NV     school 3200120 4   Elko 320012000131 4104 Independence Vly ES   Regular School No Elementary KG 08 2019   grade_6 1.0   2.0                   2.0 1.0                       3 1   2                   2 1                 3
1877225 1877225 NV     school 3200120 4   Elko 320012000131 4104 Independence Vly ES   Regular School No Elementary KG 08 2019   grade_7 1.0                         1.0                       1 1                         1                 1
1877226 1877226 NV     school 3200120 4   Elko 320012000132 4105 Jackpot ES   Regular School No Elementary KG 06 2019   grade_1 4.0   4.0                   5.0 3.0                       8 4   4                   5 3                 8
1877227 1877227 NV     school 3200120 4   Elko 320012000132 4105 Jackpot ES   Regular School No Elementary KG 06 2019   grade_2 2.0   6.0               1.0   4.0 5.0                       9 2   6               1   4 5                 9
1877228 1877228 NV     school 3200120 4   Elko 320012000132 4105 Jackpot ES   Regular School No Elementary KG 06 2019   grade_3     7.0                   5.0 2.0                       7     7                   5 2                 7
1877229 1877229 NV     school 3200120 4   Elko 320012000132 4105 Jackpot ES   Regular School No Elementary KG 06 2019   grade_4 6.0   5.0                   5.0 6.0                       11 6   5                   5 6                 11
1877230 1877230 NV     school 3200120 4   Elko 320012000132 4105 Jackpot ES   Regular School No Elementary KG 06 2019   grade_5 2.0   9.0               1.0   5.0 7.0                       12 2   9               1   5 7                 12
1877231 1877231 NV     school 3200120 4   Elko 320012000132 4105 Jackpot ES   Regular School No Elementary KG 06 2019   grade_6 4.0   10.0     1.0             9.0 6.0                       15 4   10     1             9 6                 15
1877232 1877232 NV     school 3200120 4   Elko 320012000132 4105 Jackpot ES   Regular School No Elementary KG 06 2019   kindergarten 6.0   6.0                   5.0 7.0                       12 6   6                   5 7                 12

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