Data source: Big Local News · About: Big Local

1,275 rows where grade = "grade_1" and state = "NV" sorted by asian

View and edit SQL

year

grade

  • grade_1 · 1,275
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
1706889 NV     school 3200060 2   Clark 320006000801 2079 Keller ES   Regular School No Elementary PK 05 2020   grade_1 10.0 5.0 67.0               5.0   48.0 39.0                       87 10 5 67               5   48 39                 87
1706931 NV     school 3200060 2   Clark 320006000747 2085 Diaz ES   Regular School No Elementary PK 05 2020   grade_1 10.0 18.0 81.0               3.0   68.0 44.0                       112 10 18 81               3   68 44                 112
1706945 NV     school 3200060 2   Clark 320006000740 2087 Rainbow Dreams   Regular School Yes Elementary PK 05 2020   grade_1 1.0 21.0 4.0   1.0           4.0   17.0 14.0                       31 1 21 4   1           4   17 14                 31
1706951 NV     school 3200060 2   Clark 320006000744 2089 West Prep Acad ES   Regular School No Elementary PK 05 2020   grade_1 6.0 16.0 51.0               2.0   33.0 42.0                       75 6 16 51               2   33 42                 75
1706978 NV     school 3200060 2   Clark 320006000670 2093 One Hundred Acad ES   Regular School Yes Elementary PK 05 2020   grade_1 2.0 46.0 7.0               5.0   30.0 30.0                       60 2 46 7               5   30 30                 60
1706998 NV     school 3200060 2   Clark 320006000743 2096 Roundy   Regular School No Elementary PK 05 2020   grade_1 17.0 13.0 93.0             4.0 8.0   70.0 65.0                       135 17 13 93             4 8   70 65                 135
1707033 NV     school 3200060 2   Clark 320006000010 2101 Blue Diamond   Regular School No Elementary PK 05 2020   grade_1 2.0   1.0               1.0   3.0 1.0                       4 2   1               1   3 1                 4
1707045 NV     school 3200060 2   Clark 320006000080 2103 Lundy   Regular School No Elementary PK 05 2020   grade_1 3.0                         3.0                       3 3                         3                 3
1707051 NV     school 3200060 2   Clark 320006000099 2104 Reid ES   Regular School No Elementary PK 05 2020   grade_1 2.0                       1.0 1.0                       2 2                       1 1                 2
1707057 NV     school 3200060 2   Clark 320006000343 2105 King Martin   Regular School No Elementary PK 05 2020   grade_1 4.0 7.0 36.0               4.0   29.0 22.0                       51 4 7 36               4   29 22                 51
1707064 NV     school 3200060 2   Clark 320006000344 2106 Deskin   Regular School No Elementary PK 05 2020   grade_1 27.0 13.0 27.0   1.0           5.0   36.0 37.0                       73 27 13 27   1           5   36 37                 73
1707120 NV     school 3200060 2   Clark 320006000359 2114 Perkins Ute ES   Regular School No Elementary PK 05 2020   grade_1 13.0   5.0   1.0               14.0 5.0                       19 13   5   1               14 5                 19
1707127 NV     school 3200060 2   Clark 320006000371 2115 Lynch ES   Regular School No Elementary PK 05 2020   grade_1 5.0 26.0 52.0               1.0   41.0 43.0                       84 5 26 52               1   41 43                 84
1707225 NV     school 3200060 2   Clark 320006000397 2129 Herr ES   Regular School No Elementary PK 05 2020   grade_1 11.0 9.0 81.0             3.0 2.0   57.0 49.0                       106 11 9 81             3 2   57 49                 106
1707297 NV     school 3200060 2   Clark 320006000077 2140 Antonello   Regular School No Elementary PK 05 2020   grade_1 25.0 13.0 34.0             1.0 7.0   41.0 39.0                       80 25 13 34             1 7   41 39                 80
1707318 NV     school 3200060 2   Clark 320006000269 2143 Fitzgerald ES   Regular School No Elementary PK 05 2020   grade_1 1.0 27.0 25.0               2.0   33.0 22.0                       55 1 27 25               2   33 22                 55
1707325 NV     school 3200060 2   Clark 320006000270 2144 Lowman ES   Regular School No Elementary PK 05 2020   grade_1 7.0 55.0 57.0   1.0         1.0 9.0   70.0 60.0                       130 7 55 57   1         1 9   70 60                 130
1707346 NV     school 3200060 2   Clark 320006000417 2147 Bruner ES   Regular School No Elementary PK 05 2020   grade_1 8.0 16.0 47.0               3.0   34.0 40.0                       74 8 16 47               3   34 40                 74
1707402 NV     school 3200060 2   Clark 320006000441 2155 Cambeiro ES   Regular School No Elementary PK 05 2020   grade_1 6.0 16.0 55.0   1.0         1.0 3.0   47.0 35.0                       82 6 16 55   1         1 3   47 35                 82
1707430 NV     school 3200060 2   Clark 320006000456 2159 Bowler Joseph   Regular School No Elementary PK 05 2020   grade_1 27.0 1.0 41.0               2.0   41.0 30.0                       71 27 1 41               2   41 30                 71
1707451 NV     school 3200060 2   Clark 320006000459 2162 Morrow   Regular School No Elementary PK 05 2020   grade_1 55.0 1.0 20.0             1.0 7.0   43.0 41.0                       84 55 1 20             1 7   43 41                 84
1707472 NV     school 3200060 2   Clark 320006000471 2165 Cortez ES   Regular School No Elementary PK 05 2020   grade_1 3.0 23.0 71.0   1.0           4.0   49.0 53.0                       102 3 23 71   1           4   49 53                 102
1707596 NV     school 3200060 2   Clark 320006000552 2183 Walker ES   Regular School No Elementary PK 05 2020   grade_1 64.0 9.0 28.0             3.0 11.0   59.0 56.0                       115 64 9 28             3 11   59 56                 115
1707687 NV     school 3200060 2   Clark 320006000657 2196 Jeffers ES   Regular School No Elementary PK 05 2020   grade_1 4.0 11.0 108.0             1.0 1.0   66.0 59.0                       125 4 11 108             1 1   66 59                 125
1707722 NV     school 3200060 2   Clark 320006000008 2201 Ronzone ES   Regular School No Elementary PK 05 2020   grade_1 7.0 31.0 76.0   1.0           5.0   57.0 63.0                       120 7 31 76   1           5   57 63                 120
1707736 NV     school 3200060 2   Clark 320006000014 2203 Ronnow ES   Regular School No Elementary PK 05 2020   grade_1 1.0 8.0 86.0             1.0 1.0   53.0 44.0                       97 1 8 86             1 1   53 44                 97
1707743 NV     school 3200060 2   Clark 320006000015 2204 Squires ES   Regular School No Elementary PK 05 2020   grade_1 2.0 14.0 94.0   1.0           2.0   63.0 50.0                       113 2 14 94   1           2   63 50                 113
1707757 NV     school 3200060 2   Clark 320006000016 2206 Gilbert ES   Regular School No Elementary PK 05 2020   grade_1 13.0 19.0 46.0             1.0 3.0   39.0 43.0                       82 13 19 46             1 3   39 43                 82
1707792 NV     school 3200060 2   Clark 320006000063 2211 Booker ES   Regular School No Elementary PK 05 2020   grade_1 4.0 27.0 36.0               3.0   34.0 36.0                       70 4 27 36               3   34 36                 70
1707799 NV     school 3200060 2   Clark 320006000050 2212 Earl Ira ES   Regular School No Elementary PK 05 2020   grade_1 9.0 7.0 91.0               1.0   50.0 58.0                       108 9 7 91               1   50 58                 108
1707820 NV     school 3200060 2   Clark 320006000384 2215 Miller Sch   Special Education School No Other PK 12 2020   grade_1 1.0   2.0               1.0   3.0 1.0                       4 1   2               1   3 1                 4
1707877 NV     school 3200060 2   Clark 320006000068 2222 Lincoln   Regular School No Elementary PK 05 2020   grade_1 2.0 5.0 116.0   1.0           1.0   59.0 66.0                       125 2 5 116   1           1   59 66                 125
1707898 NV     school 3200060 2   Clark 320006000074 2225 Cahlan   Regular School No Elementary PK 05 2020   grade_1 6.0 10.0 90.0   1.0           1.0   56.0 52.0                       108 6 10 90   1           1   56 52                 108
1707913 NV     school 3200060 2   Clark 320006000079 2228 Mountain View ES   Regular School No Elementary PK 05 2020   grade_1 14.0 16.0 54.0   1.0           4.0   42.0 47.0                       89 14 16 54   1           4   42 47                 89
1707948 NV     school 3200060 2   Clark 320006000088 2234 McCall ES   Regular School No Elementary PK 05 2020   grade_1 1.0 18.0 35.0                   22.0 32.0                       54 1 18 35                   22 32                 54
1707997 NV     school 3200060 2   Clark 320006000104 2242 Tom Williams ES   Regular School No Elementary PK 05 2020   grade_1 3.0 1.0 97.0             1.0     58.0 44.0                       102 3 1 97             1     58 44                 102
1708004 NV     school 3200060 2   Clark 320006000105 2243 Twin Lakes ES   Regular School No Elementary PK 05 2020   grade_1 7.0 10.0 76.0             2.0 1.0   50.0 46.0                       96 7 10 76             2 1   50 46                 96
1708063 NV     school 3200060 2   Clark 320006000577 2252 Indian Springs   Regular School No Elementary PK 05 2020   grade_1 6.0 1.0 9.0               2.0   13.0 5.0                       18 6 1 9               2   13 5                 18
1708091 NV     school 3200060 2   Clark 320006000115 2256 Whitney   Regular School No Elementary PK 05 2020   grade_1 13.0 21.0 35.0             4.0 4.0   39.0 38.0                       77 13 21 35             4 4   39 38                 77
1708119 NV     school 3200060 2   Clark 320006000081 2260 Tate ES   Regular School No Elementary PK 05 2020   grade_1 13.0 27.0 82.0             2.0 6.0   56.0 74.0                       130 13 27 82             2 6   56 74                 130
1708126 NV     school 3200060 2   Clark 320006000040 2261 Harmon ES   Regular School No Elementary PK 05 2020   grade_1 9.0 2.0 68.0             1.0 2.0   39.0 43.0                       82 9 2 68             1 2   39 43                 82
1708189 NV     school 3200060 2   Clark 320006000113 2270 Long ES   Regular School No Elementary PK 05 2020   grade_1 9.0 20.0 101.0               1.0   62.0 69.0                       131 9 20 101               1   62 69                 131
1708210 NV     school 3200060 2   Clark 320006000587 2273 Hollingsworth ES   Regular School No Elementary PK 05 2020   grade_1 5.0 16.0 64.0               3.0   42.0 46.0                       88 5 16 64               3   42 46                 88
1708265 NV     school 3200060 2   Clark 320006000507 2281 Martinez ES   Regular School No Elementary PK 05 2020   grade_1 8.0 34.0 66.0   2.0         1.0 6.0   53.0 64.0                       117 8 34 66   2         1 6   53 64                 117
1708272 NV     school 3200060 2   Clark 320006000508 2282 Moore ES   Regular School No Elementary PK 05 2020   grade_1 6.0 23.0 75.0               2.0   47.0 59.0                       106 6 23 75               2   47 59                 106
1708321 NV     school 3200060 2   Clark 320006000303 2290 Tobler   Regular School No Elementary PK 05 2020   grade_1 16.0 18.0 39.0   1.0         1.0 4.0   41.0 38.0                       79 16 18 39   1         1 4   41 38                 79
1708328 NV     school 3200060 2   Clark 320006000612 2291 Sandy Valley   Regular School No Elementary PK 05 2020   grade_1 9.0 1.0 9.0               1.0   12.0 8.0                       20 9 1 9               1   12 8                 20
1708342 NV     school 3200060 2   Clark 320006000337 2293 Cox Clyde   Regular School No Elementary PK 05 2020   grade_1 8.0 30.0 87.0             1.0 3.0   62.0 67.0                       129 8 30 87             1 3   62 67                 129
1708390 NV     school 3200060 2   Clark 320006000489 2300 Detwiler ES   Regular School No Elementary PK 05 2020   grade_1 10.0 36.0 50.0   1.0         1.0 3.0   55.0 46.0                       101 10 36 50   1         1 3   55 46                 101
1708857 NV     school 3200060 2   Clark 320006000774 2910 Stewart Sch   Special Education School No Other PK 12 2020   grade_1     1.0                   1.0                         1     1                   1                   1
1708945 NV     school 3200060 2   Clark 320006000619 2935 Variety School ES   Special Education School No Elementary PK 05 2020   grade_1 1.0   1.0                   1.0 1.0                       2 1   1                   1 1                 2
1708969 NV     school 3200090 3   Douglas 320009000124 3202 Zephyr Cove   Regular School No Elementary PK 06 2020   grade_1 8.0                   2.0   2.0 8.0                       10 8                   2   2 8                 10
1709003 NV     school 3200090 3   Douglas 320009000448 3210 Minden ES   Regular School No Elementary PK 05 2020   grade_1 38.0   16.0               4.0   30.0 28.0                       58 38   16               4   30 28                 58
1709047 NV     school 3200120 4   Elko 320012000132 4105 Jackpot ES   Regular School No Elementary KG 06 2020   grade_1 4.0   7.0                   5.0 6.0                       11 4   7                   5 6                 11
1709054 NV     school 3200120 4   Elko 320012000134 4108 Mound Vly ES   Regular School No Elementary KG 08 2020   grade_1 1.0                         1.0                       1 1                         1                 1
1709061 NV     school 3200120 4   Elko 320012000139 4111 Ruby Vly ES   Regular School No Elementary KG 08 2020   grade_1 2.0                       2.0                         2 2                       2                   2
1709068 NV     school 3200120 4   Elko 320012000931 4120 Liberty Peak ES   Regular School No Elementary PK 05 2020   grade_1 114.0   9.0               1.0   63.0 61.0                       124 114   9               1   63 61                 124
1709081 NV     school 3200120 4   Elko 320012000135 4203 Northside ES   Regular School No Elementary PK 06 2020   grade_1 39.0 1.0 20.0   1.0           2.0   27.0 36.0                       63 39 1 20   1           2   27 36                 63
1709087 NV     school 3200120 4   Elko 320012000140 4204 Southside ES   Regular School No Elementary PK 06 2020   grade_1 38.0 5.0 71.0   1.0           4.0   65.0 54.0                       119 38 5 71   1           4   65 54                 119
1709100 NV     school 3200120 4   Elko 320012000727 4206 Owyhee ES   Regular School No Elementary PK 06 2020   grade_1 2.0       26.0           1.0   15.0 14.0                       29 2       26           1   15 14                 29
1709115 NV     school 3200120 4   Elko 320012000308 4208 West Wendover ES ES   Regular School No Elementary PK 06 2020   grade_1 10.0   46.0   2.0           2.0   31.0 29.0                       60 10   46   2           2   31 29                 60
1709129 NV     school 3200120 4   Elko 320012000350 4210 Spring Creek ES   Regular School No Elementary KG 05 2020   grade_1 60.0   6.0   2.0         1.0 5.0   40.0 34.0                       74 60   6   2         1 5   40 34                 74
1709135 NV     school 3200120 4   Elko 320012000385 4211 Sage ES   Regular School No Elementary PK 05 2020   grade_1 56.0 1.0 11.0   2.0         1.0 4.0   41.0 34.0                       75 56 1 11   2         1 4   41 34                 75
1709200 NV     school 3200150 5   Esmeralda 320015000143 5101 Dyer ES   Regular School No Elementary PK 08 2020   grade_1     3.0                   1.0 2.0                       3     3                   1 2                 3
1709209 NV     school 3200150 5   Esmeralda 320015000144 5102 Goldfield ES   Regular School No Elementary PK 08 2020   grade_1 3.0                   1.0   1.0 3.0                       4 3                   1   1 3                 4
1709218 NV     school 3200150 5   Esmeralda 320015000145 5103 Silver Peak ES   Regular School No Elementary PK 08 2020   grade_1 1.0                         1.0                       1 1                         1                 1
1709225 NV     school 3200180 6   Eureka 320018000146 6101 Crescent Vly   Regular School No Elementary PK 06 2020   grade_1 6.0                   1.0   4.0 3.0                       7 6                   1   4 3                 7
1709232 NV     school 3200180 6   Eureka 320018000147 6103 Eureka   Regular School No Elementary PK 06 2020   grade_1 22.0   4.0               2.0   15.0 13.0                       28 22   4               2   15 13                 28
1709251 NV     school 3200210 7   Humboldt 320021000151 7103 Kings River ES   Regular School No Elementary PK 08 2020   grade_1     2.0                     2.0                       2     2                     2                 2
1709257 NV     school 3200210 7   Humboldt 320021000155 7104 Orovada ES   Regular School No Elementary PK 08 2020   grade_1 3.0                       1.0 2.0                       3 3                       1 2                 3
1709265 NV     school 3200210 7   Humboldt 320021000156 7105 Paradise Vly ES   Regular School No Elementary PK 08 2020   grade_1 4.0   1.0                   3.0 2.0                       5 4   1                   3 2                 5
1709279 NV     school 3200210 7   Humboldt 320021000158 7202 Winnemucca GS   Regular School No Elementary PK 04 2020   grade_1 48.0   28.0   1.0           2.0   47.0 32.0                       79 48   28   1           2   47 32                 79
1709284 NV     school 3200210 7   Humboldt 320021000153 7203 McDermitt ES   Regular School No Elementary PK 06 2020   grade_1         4.0               2.0 2.0                       4         4               2 2                 4
1709313 NV     school 3200240 8   Lander 320024000165 8201 Battle Mtn ES   Regular School No Elementary PK 05 2020   grade_1 50.0   31.0               3.0   44.0 40.0                       84 50   31               3   44 40                 84
1709328 NV     school 3200240 8   Lander 320024000162 8602 Austin School   Regular School No Other PK 12 2020   grade_1 1.0                       1.0                         1 1                       1                   1
1709333 NV     school 3200270 9   Lincoln 320027000170 9102 Pahranagat Vly ES   Regular School No Elementary PK 05 2020   grade_1 21.0   1.0               1.0   11.0 12.0                       23 21   1               1   11 12                 23
1709340 NV     school 3200270 9   Lincoln 320027000166 9201 Caliente ES   Regular School No Elementary PK 06 2020   grade_1 11.0                       4.0 7.0                       11 11                       4 7                 11
1709348 NV     school 3200270 9   Lincoln 320027000172 9202 Panaca ES   Regular School No Elementary PK 06 2020   grade_1 19.0                       10.0 9.0                       19 19                       10 9                 19
1709356 NV     school 3200270 9   Lincoln 320027000173 9203 Pioche ES   Regular School No Elementary PK 06 2020   grade_1 6.0   1.0                   3.0 4.0                       7 6   1                   3 4                 7
1709403 NV     school 3200300 10   Lyon 320030000299 10205 SilverSprings ES   Regular School No Elementary PK 04 2020   grade_1 60.0 1.0 11.0               7.0   46.0 33.0                       79 60 1 11               7   46 33                 79
1709409 NV     school 3200300 10   Lyon 320030000704 10206 East Valley   Regular School No Elementary PK 04 2020   grade_1 78.0 1.0 30.0   1.0         1.0 14.0   70.0 55.0                       125 78 1 30   1         1 14   70 55                 125
1709423 NV     school 3200300 10   Lyon 320030000450 10210 Sutro   Regular School No Elementary PK 06 2020   grade_1 34.0   16.0               5.0   29.0 26.0                       55 34   16               5   29 26                 55
1709431 NV     school 3200300 10   Lyon 320030000746 10211 Riverview   Regular School No Elementary PK 06 2020   grade_1 37.0   13.0   1.0           3.0   33.0 21.0                       54 37   13   1           3   33 21                 54
1709458 NV     school 3200300 10   Lyon 320030000178 10602 Smith Valley Sch   Regular School No Other PK 12 2020   grade_1 5.0   1.0                   3.0 3.0                       6 5   1                   3 3                 6
1709491 NV     school 3200330 11   Mineral 320033000811 11201 Hawthorne E.S. ES   Regular School No Elementary PK 06 2020   grade_1 23.0   3.0   1.0         2.0 5.0   15.0 19.0                       34 23   3   1         2 5   15 19                 34
1709499 NV     school 3200330 11   Mineral 320033000184 11202 Schurz ES   Regular School No Elementary PK 06 2020   grade_1     2.0   8.0           1.0   6.0 5.0                       11     2   8           1   6 5                 11
1709515 NV     school 3200360 12   Nye 320036000188 12101 Duckwater ES   Regular School No Elementary PK 05 2020   grade_1         1.0           1.0     2.0                       2         1           1     2                 2
1709520 NV     school 3200360 12   Nye 320036000191 12102 Manse ES   Regular School No Elementary PK 05 2020   grade_1 42.0 5.0 25.0   1.0           7.0   46.0 34.0                       80 42 5 25   1           7   46 34                 80
1709526 NV     school 3200360 12   Nye 320036000193 12103 Round Mtn   Regular School No Elementary PK 05 2020   grade_1 22.0   3.0                   11.0 14.0                       25 22   3                   11 14                 25
1709532 NV     school 3200360 12   Nye 320036000189 12105 Gabbs ES   Regular School No Elementary PK 05 2020   grade_1 1.0   2.0   1.0           1.0   4.0 1.0                       5 1   2   1           1   4 1                 5
1709538 NV     school 3200360 12   Nye 320036000185 12106 Amargosa Vly ES   Regular School No Elementary PK 05 2020   grade_1 6.0   4.0                   6.0 4.0                       10 6   4                   6 4                 10
1709551 NV     school 3200360 12   Nye 320036000186 12201 Beatty   Regular School No Elementary PK 05 2020   grade_1 7.0   4.0               1.0   7.0 5.0                       12 7   4               1   7 5                 12
1709557 NV     school 3200360 12   Nye 320036000194 12202 Tonopah   Regular School No Elementary PK 05 2020   grade_1 19.0 1.0 4.0                   10.0 14.0                       24 19 1 4                   10 14                 24
1709571 NV     school 3200360 12   Nye 320036000752 12210 Floyd ES   Regular School No Elementary PK 05 2020   grade_1 43.0 3.0 16.0             1.0 8.0   33.0 38.0                       71 43 3 16             1 8   33 38                 71
1709577 NV     school 3200360 12   Nye 320036000871 12211 Warm Springs   Regular School No Elementary PK 08 2020   grade_1 2.0                         2.0                       2 2                         2                 2
1709665 NV     school 3200390 13   Carson 320039000364 13209 Empire ES   Regular School No Elementary PK 05 2020   grade_1 29.0 1.0 52.0   2.0           5.0   58.0 31.0                       89 29 1 52   2           5   58 31                 89
1709672 NV     school 3200390 13   Carson 320039000160 13211 Mark Twain ES   Regular School No Elementary PK 05 2020   grade_1 35.0   64.0               8.0   53.0 54.0                       107 35   64               8   53 54                 107
1709701 NV     school 3200420 14   Pershing 320042000196 14101 Imlay ES   Regular School No Elementary PK 05 2020   grade_1 4.0                       4.0                         4 4                       4                   4
1709707 NV     school 3200420 14   Pershing 320042000197 14201 Lovelock ES   Regular School No Elementary PK 05 2020   grade_1 26.0   18.0   5.0         1.0 8.0   31.0 27.0                       58 26   18   5         1 8   31 27                 58
1709722 NV     school 3200450 15   Storey 320045000200 15101 Gallagher ES   Regular School No Elementary PK 05 2020   grade_1 17.0 1.0 1.0               1.0   13.0 7.0                       20 17 1 1               1   13 7                 20

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