Data source: Big Local News · About: Big Local

1,283 rows where grade = "grade_4" and state = "NV" sorted by black

View and edit SQL

year

grade

  • grade_4 · 1,283
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
1707036 NV     school 3200060 2   Clark 320006000010 2101 Blue Diamond   Regular School No Elementary PK 05 2020   grade_4 5.0   1.0               1.0   5.0 2.0                       7 5   1               1   5 2                 7
1707048 NV     school 3200060 2   Clark 320006000080 2103 Lundy   Regular School No Elementary PK 05 2020   grade_4 3.0   1.0                   4.0                         4 3   1                   4                   4
1707054 NV     school 3200060 2   Clark 320006000099 2104 Reid ES   Regular School No Elementary PK 05 2020   grade_4 3.0                       2.0 1.0                       3 3                       2 1                 3
1707123 NV     school 3200060 2   Clark 320006000359 2114 Perkins Ute ES   Regular School No Elementary PK 05 2020   grade_4 16.0   8.0   1.0           1.0   15.0 11.0                       26 16   8   1           1   15 11                 26
1707274 NV     school 3200060 2   Clark 320006000399 2136 King Martha   Regular School No Elementary PK 05 2020   grade_4 86.0   16.0               3.0   57.0 48.0                       105 86   16               3   57 48                 105
1707433 NV     school 3200060 2   Clark 320006000456 2159 Bowler Joseph   Regular School No Elementary PK 05 2020   grade_4 30.0   43.0                   31.0 42.0                       73 30   43                   31 42                 73
1708066 NV     school 3200060 2   Clark 320006000577 2252 Indian Springs   Regular School No Elementary PK 05 2020   grade_4 10.0   4.0               1.0   9.0 6.0                       15 10   4               1   9 6                 15
1708087 NV     school 3200060 2   Clark 320006000110 2255 Virgin Valley   Regular School No Elementary PK 05 2020   grade_4 50.0   56.0     1.0         3.0   55.0 55.0                       110 50   56     1         3   55 55                 110
1708254 NV     school 3200060 2   Clark 320006000302 2279 Bowler Grant   Regular School No Elementary PK 05 2020   grade_4 94.0   9.0               2.0   45.0 60.0                       105 94   9               2   45 60                 105
1708331 NV     school 3200060 2   Clark 320006000612 2291 Sandy Valley   Regular School No Elementary PK 05 2020   grade_4 12.0   11.0     1.0             9.0 15.0                       24 12   11     1             9 15                 24
1708965 NV     school 3200090 3   Douglas 320009000121 3201 Gardnerville ES   Regular School No Elementary PK 05 2020   grade_4 40.0   16.0   1.0 2.0         3.0   25.0 37.0                       62 40   16   1 2         3   25 37                 62
1708972 NV     school 3200090 3   Douglas 320009000124 3202 Zephyr Cove   Regular School No Elementary PK 06 2020   grade_4 11.0   5.0     1.0         2.0   8.0 11.0                       19 11   5     1         2   8 11                 19
1708980 NV     school 3200090 3   Douglas 320009000293 3205 Meneley ES   Regular School No Elementary PK 05 2020   grade_4 48.0   21.0   14.0           3.0   44.0 42.0                       86 48   21   14           3   44 42                 86
1708987 NV     school 3200090 3   Douglas 320009000307 3206 Jacks Vly ES   Regular School No Elementary PK 05 2020   grade_4 44.0   25.0   3.0 1.0         5.0   43.0 35.0                       78 44   25   3 1         5   43 35                 78
1708994 NV     school 3200090 3   Douglas 320009000347 3207 Scarselli ES   Regular School No Elementary PK 05 2020   grade_4 46.0   16.0   2.0           6.0   37.0 33.0                       70 46   16   2           6   37 33                 70
1709000 NV     school 3200090 3   Douglas 320009000447 3209 Pinon Hills   Regular School No Elementary PK 05 2020   grade_4 37.0   1.0   1.0           5.0   22.0 22.0                       44 37   1   1           5   22 22                 44
1709006 NV     school 3200090 3   Douglas 320009000448 3210 Minden ES   Regular School No Elementary PK 05 2020   grade_4 60.0   13.0     1.0         2.0   33.0 43.0                       76 60   13     1         2   33 43                 76
1709042 NV     school 3200120 4   Elko 320012000131 4104 Independence Vly ES   Regular School No Elementary KG 08 2020   grade_4 1.0                         1.0                       1 1                         1                 1
1709050 NV     school 3200120 4   Elko 320012000132 4105 Jackpot ES   Regular School No Elementary KG 06 2020   grade_4 1.0   5.0                   5.0 1.0                       6 1   5                   5 1                 6
1709056 NV     school 3200120 4   Elko 320012000134 4108 Mound Vly ES   Regular School No Elementary KG 08 2020   grade_4 2.0                       2.0                         2 2                       2                   2
1709064 NV     school 3200120 4   Elko 320012000139 4111 Ruby Vly ES   Regular School No Elementary KG 08 2020   grade_4 3.0                       3.0                         3 3                       3                   3
1709071 NV     school 3200120 4   Elko 320012000931 4120 Liberty Peak ES   Regular School No Elementary PK 05 2020   grade_4 92.0   6.0   1.0           2.0   48.0 53.0                       101 92   6   1           2   48 53                 101
1709078 NV     school 3200120 4   Elko 320012000129 4202 Elko Grammar #2 ES   Regular School No Elementary PK 06 2020   grade_4 41.0   11.0   9.0         1.0 2.0   34.0 30.0                       64 41   11   9         1 2   34 30                 64
1709090 NV     school 3200120 4   Elko 320012000140 4204 Southside ES   Regular School No Elementary PK 06 2020   grade_4 34.0   71.0   2.0           2.0   51.0 58.0                       109 34   71   2           2   51 58                 109
1709096 NV     school 3200120 4   Elko 320012000125 4205 Carlin ES   Regular School No Elementary PK 06 2020   grade_4 23.0       1.0         1.0     14.0 11.0                       25 23       1         1     14 11                 25
1709103 NV     school 3200120 4   Elko 320012000727 4206 Owyhee ES   Regular School No Elementary PK 06 2020   grade_4 1.0       35.0               18.0 18.0                       36 1       35               18 18                 36
1709111 NV     school 3200120 4   Elko 320012000141 4207 Wells ES   Regular School No Elementary PK 06 2020   grade_4 16.0   8.0               2.0   14.0 12.0                       26 16   8               2   14 12                 26
1709118 NV     school 3200120 4   Elko 320012000308 4208 West Wendover ES ES   Regular School No Elementary PK 06 2020   grade_4 11.0   64.0                   39.0 36.0                       75 11   64                   39 36                 75
1709132 NV     school 3200120 4   Elko 320012000350 4210 Spring Creek ES   Regular School No Elementary KG 05 2020   grade_4 61.0   3.0                   31.0 33.0                       64 61   3                   31 33                 64
1709138 NV     school 3200120 4   Elko 320012000385 4211 Sage ES   Regular School No Elementary PK 05 2020   grade_4 67.0   11.0               3.0   36.0 45.0                       81 67   11               3   36 45                 81
1709203 NV     school 3200150 5   Esmeralda 320015000143 5101 Dyer ES   Regular School No Elementary PK 08 2020   grade_4 3.0   2.0                   5.0                         5 3   2                   5                   5
1709212 NV     school 3200150 5   Esmeralda 320015000144 5102 Goldfield ES   Regular School No Elementary PK 08 2020   grade_4 3.0                         3.0                       3 3                         3                 3
1709220 NV     school 3200150 5   Esmeralda 320015000145 5103 Silver Peak ES   Regular School No Elementary PK 08 2020   grade_4 1.0                       1.0                         1 1                       1                   1
1709227 NV     school 3200180 6   Eureka 320018000146 6101 Crescent Vly   Regular School No Elementary PK 06 2020   grade_4 4.0   1.0   2.0           1.0   3.0 5.0                       8 4   1   2           1   3 5                 8
1709235 NV     school 3200180 6   Eureka 320018000147 6103 Eureka   Regular School No Elementary PK 06 2020   grade_4 22.0   3.0               3.0   16.0 12.0                       28 22   3               3   16 12                 28
1709253 NV     school 3200210 7   Humboldt 320021000151 7103 Kings River ES   Regular School No Elementary PK 08 2020   grade_4 1.0   1.0                   2.0                         2 1   1                   2                   2
1709268 NV     school 3200210 7   Humboldt 320021000156 7105 Paradise Vly ES   Regular School No Elementary PK 08 2020   grade_4 4.0   1.0                   4.0 1.0                       5 4   1                   4 1                 5
1709277 NV     school 3200210 7   Humboldt 320021000157 7201 Sonoma Heights ES   Regular School No Elementary PK 06 2020   grade_4 53.0   60.0               5.0   53.0 65.0                       118 53   60               5   53 65                 118
1709282 NV     school 3200210 7   Humboldt 320021000158 7202 Winnemucca GS   Regular School No Elementary PK 04 2020   grade_4 38.0   18.0     2.0         5.0   31.0 32.0                       63 38   18     2         5   31 32                 63
1709287 NV     school 3200210 7   Humboldt 320021000153 7203 McDermitt ES   Regular School No Elementary PK 06 2020   grade_4         13.0               8.0 5.0                       13         13               8 5                 13
1709316 NV     school 3200240 8   Lander 320024000165 8201 Battle Mtn ES   Regular School No Elementary PK 05 2020   grade_4 40.0   26.0   1.0 1.0         1.0   35.0 34.0                       69 40   26   1 1         1   35 34                 69
1709336 NV     school 3200270 9   Lincoln 320027000170 9102 Pahranagat Vly ES   Regular School No Elementary PK 05 2020   grade_4 15.0                 1.0 1.0   11.0 6.0                       17 15                 1 1   11 6                 17
1709343 NV     school 3200270 9   Lincoln 320027000166 9201 Caliente ES   Regular School No Elementary PK 06 2020   grade_4 11.0   1.0               1.0   5.0 8.0                       13 11   1               1   5 8                 13
1709351 NV     school 3200270 9   Lincoln 320027000172 9202 Panaca ES   Regular School No Elementary PK 06 2020   grade_4 12.0   2.0               2.0   6.0 10.0                       16 12   2               2   6 10                 16
1709359 NV     school 3200270 9   Lincoln 320027000173 9203 Pioche ES   Regular School No Elementary PK 06 2020   grade_4 13.0   1.0                   3.0 11.0                       14 13   1                   3 11                 14
1709386 NV     school 3200300 10   Lyon 320030000174 10201 Dayton   Regular School No Elementary PK 06 2020   grade_4 36.0   17.0   2.0 3.0         4.0   33.0 29.0                       62 36   17   2 3         4   33 29                 62
1709394 NV     school 3200300 10   Lyon 320030000179 10202 Yerington ES   Regular School No Elementary PK 04 2020   grade_4 48.0   36.0   10.0           10.0   53.0 51.0                       104 48   36   10           10   53 51                 104
1709400 NV     school 3200300 10   Lyon 320030000175 10203 Fernley   Regular School No Elementary PK 04 2020   grade_4 53.0   32.0   2.0 1.0         7.0   52.0 43.0                       95 53   32   2 1         7   52 43                 95
1709406 NV     school 3200300 10   Lyon 320030000299 10205 SilverSprings ES   Regular School No Elementary PK 04 2020   grade_4 56.0   12.0   1.0         1.0 3.0   44.0 29.0                       73 56   12   1         1 3   44 29                 73
1709426 NV     school 3200300 10   Lyon 320030000450 10210 Sutro   Regular School No Elementary PK 06 2020   grade_4 37.0   14.0               2.0   27.0 26.0                       53 37   14               2   27 26                 53
1709434 NV     school 3200300 10   Lyon 320030000746 10211 Riverview   Regular School No Elementary PK 06 2020   grade_4 53.0   14.0               2.0   40.0 29.0                       69 53   14               2   40 29                 69
1709461 NV     school 3200300 10   Lyon 320030000178 10602 Smith Valley Sch   Regular School No Other PK 12 2020   grade_4 11.0   4.0                   4.0 11.0                       15 11   4                   4 11                 15
1709494 NV     school 3200330 11   Mineral 320033000811 11201 Hawthorne E.S. ES   Regular School No Elementary PK 06 2020   grade_4 23.0   6.0   4.0           4.0   19.0 18.0                       37 23   6   4           4   19 18                 37
1709502 NV     school 3200330 11   Mineral 320033000184 11202 Schurz ES   Regular School No Elementary PK 06 2020   grade_4     2.0   6.0           1.0   5.0 4.0                       9     2   6           1   5 4                 9
1709529 NV     school 3200360 12   Nye 320036000193 12103 Round Mtn   Regular School No Elementary PK 05 2020   grade_4 19.0   3.0   2.0               11.0 13.0                       24 19   3   2               11 13                 24
1709535 NV     school 3200360 12   Nye 320036000189 12105 Gabbs ES   Regular School No Elementary PK 05 2020   grade_4 3.0   1.0   1.0           1.0   1.0 5.0                       6 3   1   1           1   1 5                 6
1709541 NV     school 3200360 12   Nye 320036000185 12106 Amargosa Vly ES   Regular School No Elementary PK 05 2020   grade_4 4.0   14.0                   8.0 10.0                       18 4   14                   8 10                 18
1709554 NV     school 3200360 12   Nye 320036000186 12201 Beatty   Regular School No Elementary PK 05 2020   grade_4 2.0   3.0               1.0   3.0 3.0                       6 2   3               1   3 3                 6
1709646 NV     school 3200390 13   Carson 320039000286 13203 Fritsch ES   Regular School No Elementary PK 05 2020   grade_4 69.0   22.0   1.0 4.0         9.0   58.0 47.0                       105 69   22   1 4         9   58 47                 105
1709668 NV     school 3200390 13   Carson 320039000364 13209 Empire ES   Regular School No Elementary PK 05 2020   grade_4 18.0   52.0   2.0 2.0         5.0   41.0 38.0                       79 18   52   2 2         5   41 38                 79
1709682 NV     school 3200390 13   Carson 320039000569 13212 Carson Montessori   Regular School Yes Elementary KG 06 2020   grade_4 26.0   3.0     1.0       1.0 1.0   16.0 16.0                       32 26   3     1       1 1   16 16                 32
1709704 NV     school 3200420 14   Pershing 320042000196 14101 Imlay ES   Regular School No Elementary PK 05 2020   grade_4 3.0                   1.0     4.0                       4 3                   1     4                 4
1709732 NV     school 3200450 15   Storey 320045000413 15102 Hillside ES   Regular School No Elementary PK 05 2020   grade_4 11.0                   2.0   8.0 5.0                       13 11                   2   8 5                 13
1709818 NV     school 3200480 16   Washoe 320048000321 16211 Mount Rose ES   Regular School No Elementary PK 08 2020   grade_4 32.0   23.0     2.0         5.0   25.0 37.0                       62 32   23     2         5   25 37                 62
1709847 NV     school 3200480 16   Washoe 320048000242 16215 Corbett ES   Regular School No Elementary PK 06 2020   grade_4 6.0   63.0     1.0       1.0 1.0   30.0 42.0                       72 6   63     1       1 1   30 42                 72
1709855 NV     school 3200480 16   Washoe 320048000243 16216 Gomm   Regular School No Elementary PK 06 2020   grade_4 63.0   4.0     4.0         5.0   32.0 44.0                       76 63   4     4         5   32 44                 76
1709897 NV     school 3200480 16   Washoe 320048000214 16223 Drake   Regular School No Elementary PK 06 2020   grade_4 10.0   24.0             1.0 2.0   21.0 16.0                       37 10   24             1 2   21 16                 37
1709911 NV     school 3200480 16   Washoe 320048000227 16225 Smith Kate ES   Regular School No Elementary PK 05 2020   grade_4 4.0   31.0   1.0         2.0     20.0 18.0                       38 4   31   1         2     20 18                 38
1709937 NV     school 3200480 16   Washoe 320048000205 16229 Brown   Regular School No Elementary PK 05 2020   grade_4 68.0   18.0     5.0         10.0   45.0 56.0                       101 68   18     5         10   45 56                 101
1709959 NV     school 3200480 16   Washoe 320048000228 16232 Lemmon Vly ES   Regular School No Elementary PK 05 2020   grade_4 45.0   46.0     5.0       1.0 10.0   58.0 49.0                       107 45   46     5       1 10   58 49                 107
1709966 NV     school 3200480 16   Washoe 320048000237 16233 Pleasant Vly   Regular School No Elementary PK 05 2020   grade_4 53.0   8.0   1.0           5.0   32.0 35.0                       67 53   8   1           5   32 35                 67
1709973 NV     school 3200480 16   Washoe 320048000249 16234 Sun Valley ES   Regular School No Elementary PK 06 2020   grade_4 9.0   66.0     1.0         2.0   42.0 36.0                       78 9   66     1         2   42 36                 78
1709980 NV     school 3200480 16   Washoe 320048000250 16235 Verdi   Regular School No Elementary PK 06 2020   grade_4 30.0   5.0     1.0         2.0   20.0 18.0                       38 30   5     1         2   20 18                 38
1709987 NV     school 3200480 16   Washoe 320048000234 16237 Natchez ES   Regular School No Elementary PK 06 2020   grade_4 2.0   3.0   13.0               14.0 4.0                       18 2   3   13               14 4                 18
1710007 NV     school 3200480 16   Washoe 320048000324 16240 Palmer ES   Regular School No Elementary PK 06 2020   grade_4 21.0   45.0   3.0         2.0 4.0   34.0 41.0                       75 21   45   3         2 4   34 41                 75
1710034 NV     school 3200480 16   Washoe 320048000224 16251 Incline ES   Regular School No Elementary PK 05 2020   grade_4 26.0   27.0     1.0         3.0   30.0 27.0                       57 26   27     1         3   30 27                 57
1710063 NV     school 3200480 16   Washoe 320048000336 16259 Whitehead   Regular School No Elementary PK 06 2020   grade_4 27.0   18.0   1.0 2.0       1.0 7.0   30.0 26.0                       56 27   18   1 2       1 7   30 26                 56
1710077 NV     school 3200480 16   Washoe 320048000389 16261 Caughlin Ranch   Regular School No Elementary PK 06 2020   grade_4 48.0   9.0     12.0         10.0   42.0 37.0                       79 48   9     12         10   42 37                 79
1710085 NV     school 3200480 16   Washoe 320048000366 16262 Hidden Vly   Regular School No Elementary PK 06 2020   grade_4 19.0   22.0   3.0 2.0         5.0   25.0 26.0                       51 19   22   3 2         5   25 26                 51
1710093 NV     school 3200480 16   Washoe 320048000367 16263 Silver Lake ES   Regular School No Elementary PK 04 2020   grade_4 56.0   40.0     2.0       1.0 6.0   64.0 41.0                       105 56   40     2       1 6   64 41                 105
1710098 NV     school 3200480 16   Washoe 320048000368 16264 Westergard   Regular School No Elementary PK 05 2020   grade_4 58.0   18.0     3.0       2.0 11.0   50.0 42.0                       92 58   18     3       2 11   50 42                 92
1710192 NV     school 3200480 16   Washoe 320048000544 16278 Bailey ES   Regular School Yes Elementary KG 06 2020   grade_4 3.0   39.0   1.0 1.0       2.0     22.0 24.0                       46 3   39   1 1       2     22 24                 46
1710199 NV     school 3200480 16   Washoe 320048000560 16281 Mariposa Acad   Regular School Yes Elementary PK 05 2020   grade_4 1.0   18.0                   8.0 11.0                       19 1   18                   8 11                 19
1710206 NV     school 3200480 16   Washoe 320048000561 16282 High Desert Monte   Regular School Yes Elementary PK 08 2020   grade_4 19.0   10.0             1.0 1.0   17.0 14.0                       31 19   10             1 1   17 14                 31
1710325 NV     school 3200480 16   Washoe 320048000217 16601 Gerlach K-12   Regular School No Other PK 12 2020   grade_4 2.0   1.0                   3.0                         3 2   1                   3                   3
1710379 NV     school 3200480 16   Washoe 320048000233 16911 Picollo Sch   Special Education School No Other PK 12 2020   grade_4 2.0   3.0     1.0             5.0 1.0                       6 2   3     1             5 1                 6
1710393 NV     school 3200480 16   Washoe 320048000766 16917 Turning Point   Alternative School No Other 02 12 2020   grade_4 1.0   1.0               1.0   3.0                         3 1   1               1   3                   3
1710406 NV     school 3200480 16   Washoe 320048000844 16923 North Star   Alternative School No Other PK 12 2020   grade_4 5.0   1.0                   1.0 5.0                       6 5   1                   1 5                 6
1710420 NV     school 3200510 17   White Pine 320051000720 17101 Lund ES   Regular School No Elementary KG 05 2020   grade_4 7.0                       3.0 4.0                       7 7                       3 4                 7
1710424 NV     school 3200510 17   White Pine 320051000254 17103 Baker ES   Regular School No Elementary 03 06 2020   grade_4 4.0   2.0                   5.0 1.0                       6 4   2                   5 1                 6
1710429 NV     school 3200510 17   White Pine 320051000255 17201 Norman ES   Regular School No Elementary PK 05 2020   grade_4 40.0   13.0   4.0           2.0   32.0 27.0                       59 40   13   4           2   32 27                 59
1710436 NV     school 3200510 17   White Pine 320051000263 17203 McGill ES   Regular School No Elementary PK 05 2020   grade_4 13.0   1.0             1.0 3.0   14.0 4.0                       18 13   1             1 3   14 4                 18
1710591 NV     school 3200001 54   Learning Bridge 320000100833 54428 Learning Bridge   Regular School Yes Elementary KG 08 2020   grade_4 11.0   7.0   1.0 1.0             10.0 10.0                       20 11   7   1 1             10 10                 20
1710649 NV     school 3200001 57   Honors Academy of Literature 320000100826 57424 Honors ACAD   Regular School Yes Elementary KG 08 2020   grade_4 18.0   6.0             1.0 2.0   12.0 15.0                       27 18   6             1 2   12 15                 27
1710807 NV     school 3200001 66   Doral Academy Northern Nevada 320000100891 66436 Doral North NV   Regular School Yes Elementary KG 08 2020   grade_4 73.0   15.0   1.0 5.0         8.0   50.0 52.0                       102 73   15   1 5         8   50 52                 102
1710816 NV     school 3200001 68   Elko Institute for Academic Achievement 320000100784 68410 EIAA   Regular School Yes Elementary KG 08 2020   grade_4 13.0   6.0   1.0           2.0   13.0 9.0                       22 13   6   1           2   13 9                 22
1875229 NV     school 3200060 2   Clark 320006000080 2103 Lundy   Regular School No Elementary PK 05 2019   grade_4 2.0                       1.0 1.0                       2 2                       1 1                 2
1875235 NV     school 3200060 2   Clark 320006000099 2104 Reid ES   Regular School No Elementary PK 05 2019   grade_4 6.0   1.0               1.0   6.0 2.0                       8 6   1               1   6 2                 8
1875304 NV     school 3200060 2   Clark 320006000359 2114 Perkins Ute ES   Regular School No Elementary PK 05 2019   grade_4 13.0   2.0   5.0           2.0   15.0 7.0                       22 13   2   5           2   15 7                 22
1875795 NV     school 3200060 2   Clark 320006000605 2185 Givens   Regular School No Elementary PK 05 2019   grade_4 67.0   16.0     17.0         19.0   64.0 55.0                       119 67   16     17         19   64 55                 119

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