Data source: Big Local News · About: Big Local

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

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
1706948 NV     school 3200060 2   Clark 320006000740 2087 Rainbow Dreams   Regular School Yes Elementary PK 05 2020   grade_4 1.0 23.0 6.0               6.0   22.0 14.0                       36 1 23 6               6   22 14                 36
1706954 NV     school 3200060 2   Clark 320006000744 2089 West Prep Acad ES   Regular School No Elementary PK 05 2020   grade_4   9.0 60.0             1.0 1.0   34.0 37.0                       71   9 60             1 1   34 37                 71
1706981 NV     school 3200060 2   Clark 320006000670 2093 One Hundred Acad ES   Regular School Yes Elementary PK 05 2020   grade_4   41.0 10.0               3.0   25.0 29.0                       54   41 10               3   25 29                 54
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
1707130 NV     school 3200060 2   Clark 320006000371 2115 Lynch ES   Regular School No Elementary PK 05 2020   grade_4 4.0 26.0 70.0             1.0 2.0   54.0 49.0                       103 4 26 70             1 2   54 49                 103
1707137 NV     school 3200060 2   Clark 320006000372 2116 Woolley ES   Regular School No Elementary PK 05 2020   grade_4 3.0 23.0 73.0               4.0   44.0 59.0                       103 3 23 73               4   44 59                 103
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
1707405 NV     school 3200060 2   Clark 320006000441 2155 Cambeiro ES   Regular School No Elementary PK 05 2020   grade_4 4.0 10.0 94.0   1.0         1.0 2.0   60.0 52.0                       112 4 10 94   1         1 2   60 52                 112
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
1707440 NV     school 3200060 2   Clark 320006000457 2160 Rhodes   Regular School No Elementary PK 05 2020   grade_4 44.0 16.0 28.0   1.0           6.0   52.0 43.0                       95 44 16 28   1           6   52 43                 95
1707725 NV     school 3200060 2   Clark 320006000008 2201 Ronzone ES   Regular School No Elementary PK 05 2020   grade_4 6.0 24.0 87.0               3.0   54.0 66.0                       120 6 24 87               3   54 66                 120
1707774 NV     school 3200060 2   Clark 320006000028 2208 Griffith   Regular School No Elementary PK 05 2020   grade_4 4.0 13.0 77.0               4.0   56.0 42.0                       98 4 13 77               4   56 42                 98
1707781 NV     school 3200060 2   Clark 320006000033 2209 Herron ES   Regular School No Elementary PK 05 2020   grade_4 2.0 4.0 107.0               1.0   70.0 44.0                       114 2 4 107               1   70 44                 114
1707795 NV     school 3200060 2   Clark 320006000063 2211 Booker ES   Regular School No Elementary PK 05 2020   grade_4   23.0 36.0               4.0   35.0 28.0                       63   23 36               4   35 28                 63
1707823 NV     school 3200060 2   Clark 320006000384 2215 Miller Sch   Special Education School No Other PK 12 2020   grade_4 3.0 1.0 5.0                   4.0 5.0                       9 3 1 5                   4 5                 9
1707852 NV     school 3200060 2   Clark 320006000055 2218 McWilliams ES   Regular School No Elementary PK 05 2020   grade_4 6.0 9.0 102.0             4.0 2.0   77.0 46.0                       123 6 9 102             4 2   77 46                 123
1707887 NV     school 3200060 2   Clark 320006000069 2223 Craig ES   Regular School No Elementary PK 05 2020   grade_4 2.0 33.0 64.0             2.0 6.0   47.0 60.0                       107 2 33 64             2 6   47 60                 107
1707894 NV     school 3200060 2   Clark 320006000073 2224 Williams Wendell ES   Regular School No Elementary PK 05 2020   grade_4 4.0 46.0 6.0               3.0   26.0 33.0                       59 4 46 6               3   26 33                 59
1707901 NV     school 3200060 2   Clark 320006000074 2225 Cahlan   Regular School No Elementary PK 05 2020   grade_4 5.0 9.0 106.0               1.0   64.0 57.0                       121 5 9 106               1   64 57                 121
1707908 NV     school 3200060 2   Clark 320006000075 2226 Kelly ES   Regular School No Elementary PK 05 2020   grade_4 1.0 41.0 3.0             1.0 4.0   30.0 20.0                       50 1 41 3             1 4   30 20                 50
1707951 NV     school 3200060 2   Clark 320006000088 2234 McCall ES   Regular School No Elementary PK 05 2020   grade_4 1.0 10.0 41.0   1.0           1.0   25.0 29.0                       54 1 10 41   1           1   25 29                 54
1708000 NV     school 3200060 2   Clark 320006000104 2242 Tom Williams ES   Regular School No Elementary PK 05 2020   grade_4 5.0 1.0 107.0                   46.0 67.0                       113 5 1 107                   46 67                 113
1708007 NV     school 3200060 2   Clark 320006000105 2243 Twin Lakes ES   Regular School No Elementary PK 05 2020   grade_4 2.0 6.0 73.0   1.0           3.0   47.0 38.0                       85 2 6 73   1           3   47 38                 85
1708014 NV     school 3200060 2   Clark 320006000106 2244 Pittman ES   Regular School No Elementary PK 05 2020   grade_4 9.0 22.0 36.0   1.0           3.0   34.0 37.0                       71 9 22 36   1           3   34 37                 71
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
1708213 NV     school 3200060 2   Clark 320006000587 2273 Hollingsworth ES   Regular School No Elementary PK 05 2020   grade_4 5.0 12.0 72.0               6.0   43.0 52.0                       95 5 12 72               6   43 52                 95
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
1708268 NV     school 3200060 2   Clark 320006000507 2281 Martinez ES   Regular School No Elementary PK 05 2020   grade_4 3.0 21.0 67.0             2.0 3.0   53.0 43.0                       96 3 21 67             2 3   53 43                 96
1708275 NV     school 3200060 2   Clark 320006000508 2282 Moore ES   Regular School No Elementary PK 05 2020   grade_4 4.0 18.0 77.0               2.0   53.0 48.0                       101 4 18 77               2   53 48                 101
1708345 NV     school 3200060 2   Clark 320006000337 2293 Cox Clyde   Regular School No Elementary PK 05 2020   grade_4 2.0 23.0 83.0             1.0 4.0   68.0 45.0                       113 2 23 83             1 4   68 45                 113
1708352 NV     school 3200060 2   Clark 320006000338 2294 Stanford ES   Regular School No Elementary PK 05 2020   grade_4 9.0 1.0 59.0             1.0 1.0   32.0 39.0                       71 9 1 59             1 1   32 39                 71
1708373 NV     school 3200060 2   Clark 320006000341 2297 Hinman   Regular School No Elementary PK 05 2020   grade_4 19.0 10.0 25.0               1.0   33.0 22.0                       55 19 10 25               1   33 22                 55
1708860 NV     school 3200060 2   Clark 320006000774 2910 Stewart Sch   Special Education School No Other PK 12 2020   grade_4 1.0 2.0 1.0                   4.0                         4 1 2 1                   4                   4
1708900 NV     school 3200060 2   Clark 320006000607 2917 Miley Achvmt ES   Special Education School No Elementary PK 05 2020   grade_4 3.0 7.0 2.0               2.0   13.0 1.0                       14 3 7 2               2   13 1                 14
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
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
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
1709084 NV     school 3200120 4   Elko 320012000135 4203 Northside ES   Regular School No Elementary PK 06 2020   grade_4 44.0 1.0 26.0   5.0           1.0   35.0 42.0                       77 44 1 26   5           1   35 42                 77
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
1709126 NV     school 3200120 4   Elko 320012000349 4209 Mountain View ES   Regular School No Elementary PK 06 2020   grade_4 76.0 1.0 41.0   2.0           4.0   66.0 58.0                       124 76 1 41   2           4   66 58                 124
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
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
1709294 NV     school 3200210 7   Humboldt 320021000325 7205 Grass Vly ES   Regular School No Elementary PK 04 2020   grade_4 50.0 1.0 14.0   1.0           1.0   33.0 34.0                       67 50 1 14   1           1   33 34                 67
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
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
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
1709523 NV     school 3200360 12   Nye 320036000191 12102 Manse ES   Regular School No Elementary PK 05 2020   grade_4 49.0 1.0 23.0               5.0   37.0 41.0                       78 49 1 23               5   37 41                 78
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
1709548 NV     school 3200360 12   Nye 320036000351 12108 Johnson ES   Regular School No Elementary PK 05 2020   grade_4 36.0 3.0 15.0   1.0         1.0 4.0   31.0 29.0                       60 36 3 15   1         1 4   31 29                 60
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
1709560 NV     school 3200360 12   Nye 320036000194 12202 Tonopah   Regular School No Elementary PK 05 2020   grade_4 21.0 1.0 3.0                   10.0 15.0                       25 21 1 3                   10 15                 25
1709568 NV     school 3200360 12   Nye 320036000543 12207 Hafen ES   Regular School No Elementary PK 05 2020   grade_4 42.0 2.0 24.0             1.0 4.0   28.0 45.0                       73 42 2 24             1 4   28 45                 73
1709632 NV     school 3200360 12   Nye 320036000852 12609 Pathways Elem ALT   Alternative School No Elementary 03 05 2020   grade_4 1.0 1.0 1.0                   2.0 1.0                       3 1 1 1                   2 1                 3
1709638 NV     school 3200390 13   Carson 320039000288 13201 Bordewich Bray ES   Regular School No Elementary PK 05 2020   grade_4 48.0 2.0 31.0   5.0           7.0   48.0 45.0                       93 48 2 31   5           7   48 45                 93
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
1709710 NV     school 3200420 14   Pershing 320042000197 14201 Lovelock ES   Regular School No Elementary PK 05 2020   grade_4 22.0 1.0 8.0   5.0           5.0   22.0 19.0                       41 22 1 8   5           5   22 19                 41
1709725 NV     school 3200450 15   Storey 320045000200 15101 Gallagher ES   Regular School No Elementary PK 05 2020   grade_4 19.0 1.0 1.0                   14.0 7.0                       21 19 1 1                   14 7                 21
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
1709754 NV     school 3200480 16   Washoe 320048000209 16202 Loder ES   Regular School No Elementary PK 06 2020   grade_4 12.0 3.0 53.0   2.0         1.0 3.0   42.0 32.0                       74 12 3 53   2         1 3   42 32                 74
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
1709944 NV     school 3200480 16   Washoe 320048000222 16230 Huffaker   Regular School No Elementary PK 06 2020   grade_4 31.0 1.0 8.0   1.0         1.0 5.0   27.0 20.0                       47 31 1 8   1         1 5   27 20                 47
1709952 NV     school 3200480 16   Washoe 320048000834 16231 Lemelson STEM ES   Regular School No Elementary PK 06 2020   grade_4 3.0 4.0 28.0               1.0   22.0 14.0                       36 3 4 28               1   22 14                 36
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
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
1710014 NV     school 3200480 16   Washoe 320048000723 16241 Hall   Regular School No Elementary PK 06 2020   grade_4 55.0 2.0 20.0   9.0           10.0   44.0 52.0                       96 55 2 20   9           10   44 52                 96
1710041 NV     school 3200480 16   Washoe 320048000322 16256 Gomes   Regular School No Elementary PK 04 2020   grade_4 94.0 3.0 30.0   1.0           14.0   78.0 64.0                       142 94 3 30   1           14   78 64                 142

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