Data source: Big Local News · About: Big Local

1,270 rows where grade = "kindergarten" and state = "NV" sorted by multiracial_int descending

View and edit SQL

year

grade

  • kindergarten · 1,270
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
1706867 NV     school 3200060 2   Clark 320006000814 2075 Northwest CTA ES   Regular School No Elementary KG KG 2020   kindergarten 16.0         1.0             9.0 8.0                       17 16         1             9 8                 17
1707050 NV     school 3200060 2   Clark 320006000080 2103 Lundy   Regular School No Elementary PK 05 2020   kindergarten 1.0   1.0                   2.0                         2 1   1                   2                   2
1707056 NV     school 3200060 2   Clark 320006000099 2104 Reid ES   Regular School No Elementary PK 05 2020   kindergarten 5.0                       1.0 4.0                       5 5                       1 4                 5
1707741 NV     school 3200060 2   Clark 320006000014 2203 Ronnow ES   Regular School No Elementary PK 05 2020   kindergarten 6.0 11.0 84.0                   50.0 51.0                       101 6 11 84                   50 51                 101
1707762 NV     school 3200060 2   Clark 320006000016 2206 Gilbert ES   Regular School No Elementary PK 05 2020   kindergarten 5.0 2.0 11.0                   9.0 9.0                       18 5 2 11                   9 9                 18
1707783 NV     school 3200060 2   Clark 320006000033 2209 Herron ES   Regular School No Elementary PK 05 2020   kindergarten 8.0 6.0 97.0                   53.0 58.0                       111 8 6 97                   53 58                 111
1707832 NV     school 3200060 2   Clark 320006000384 2215 Miller Sch   Special Education School No Other PK 12 2020   kindergarten 1.0   3.0                   2.0 2.0                       4 1   3                   2 2                 4
1707847 NV     school 3200060 2   Clark 320006000058 2217 Mackey   Regular School No Elementary PK 05 2020   kindergarten 7.0 25.0 26.0     1.0       2.0     34.0 27.0                       61 7 25 26     1       2     34 27                 61
1707861 NV     school 3200060 2   Clark 320006000064 2219 Carson   Regular School No Elementary PK 05 2020   kindergarten 2.0 12.0 16.0     1.0             19.0 12.0                       31 2 12 16     1             19 12                 31
1708030 NV     school 3200060 2   Clark 320006000112 2246 Bracken   Regular School No Elementary PK 05 2020   kindergarten 7.0 3.0 31.0     1.0             23.0 19.0                       42 7 3 31     1             23 19                 42
1708333 NV     school 3200060 2   Clark 320006000612 2291 Sandy Valley   Regular School No Elementary PK 05 2020   kindergarten 6.0   11.0     1.0             10.0 8.0                       18 6   11     1             10 8                 18
1708975 NV     school 3200090 3   Douglas 320009000124 3202 Zephyr Cove   Regular School No Elementary PK 06 2020   kindergarten 14.0 1.0 3.0     2.0       1.0     10.0 11.0                       21 14 1 3     2       1     10 11                 21
1709046 NV     school 3200120 4   Elko 320012000131 4104 Independence Vly ES   Regular School No Elementary KG 08 2020   kindergarten 2.0                       1.0 1.0                       2 2                       1 1                 2
1709060 NV     school 3200120 4   Elko 320012000134 4108 Mound Vly ES   Regular School No Elementary KG 08 2020   kindergarten 1.0                       1.0                         1 1                       1                   1
1709091 NV     school 3200120 4   Elko 320012000140 4204 Southside ES   Regular School No Elementary PK 06 2020   kindergarten 40.0 4.0 96.0   2.0         2.0     73.0 71.0                       144 40 4 96   2         2     73 71                 144
1709106 NV     school 3200120 4   Elko 320012000727 4206 Owyhee ES   Regular School No Elementary PK 06 2020   kindergarten     2.0   25.0               13.0 14.0                       27     2   25               13 14                 27
1709223 NV     school 3200150 5   Esmeralda 320015000145 5103 Silver Peak ES   Regular School No Elementary PK 08 2020   kindergarten 1.0                         1.0                       1 1                         1                 1
1709230 NV     school 3200180 6   Eureka 320018000146 6101 Crescent Vly   Regular School No Elementary PK 06 2020   kindergarten 1.0   1.0                   1.0 1.0                       2 1   1                   1 1                 2
1709250 NV     school 3200210 7   Humboldt 320021000150 7101 Denio ES   Regular School No Elementary PK 08 2020   kindergarten 1.0                       1.0                         1 1                       1                   1
1709264 NV     school 3200210 7   Humboldt 320021000155 7104 Orovada ES   Regular School No Elementary PK 08 2020   kindergarten 3.0   2.0                   4.0 1.0                       5 3   2                   4 1                 5
1709273 NV     school 3200210 7   Humboldt 320021000156 7105 Paradise Vly ES   Regular School No Elementary PK 08 2020   kindergarten 1.0                       1.0                         1 1                       1                   1
1709290 NV     school 3200210 7   Humboldt 320021000153 7203 McDermitt ES   Regular School No Elementary PK 06 2020   kindergarten 1.0       3.0               4.0                         4 1       3               4                   4
1709338 NV     school 3200270 9   Lincoln 320027000170 9102 Pahranagat Vly ES   Regular School No Elementary PK 05 2020   kindergarten 19.0   1.0                   12.0 8.0                       20 19   1                   12 8                 20
1709346 NV     school 3200270 9   Lincoln 320027000166 9201 Caliente ES   Regular School No Elementary PK 06 2020   kindergarten 8.0                       5.0 3.0                       8 8                       5 3                 8
1709362 NV     school 3200270 9   Lincoln 320027000173 9203 Pioche ES   Regular School No Elementary PK 06 2020   kindergarten 6.0   2.0                   8.0                         8 6   2                   8                   8
1709407 NV     school 3200300 10   Lyon 320030000299 10205 SilverSprings ES   Regular School No Elementary PK 04 2020   kindergarten 39.0   2.0   1.0 1.0             22.0 21.0                       43 39   2   1 1             22 21                 43
1709470 NV     school 3200300 10   Lyon 320030000178 10602 Smith Valley Sch   Regular School No Other PK 12 2020   kindergarten 18.0   2.0                   10.0 10.0                       20 18   2                   10 10                 20
1709505 NV     school 3200330 11   Mineral 320033000184 11202 Schurz ES   Regular School No Elementary PK 06 2020   kindergarten     2.0   6.0               6.0 2.0                       8     2   6               6 2                 8
1709537 NV     school 3200360 12   Nye 320036000189 12105 Gabbs ES   Regular School No Elementary PK 05 2020   kindergarten 3.0                       2.0 1.0                       3 3                       2 1                 3
1709734 NV     school 3200450 15   Storey 320045000413 15102 Hillside ES   Regular School No Elementary PK 05 2020   kindergarten 3.0   1.0                   3.0 1.0                       4 3   1                   3 1                 4
1710180 NV     school 3200480 16   Washoe 320048000481 16275 Bennett ES   Regular School No Elementary PK 06 2020   kindergarten 19.0   46.0                   31.0 34.0                       65 19   46                   31 34                 65
1710195 NV     school 3200480 16   Washoe 320048000544 16278 Bailey ES   Regular School Yes Elementary KG 06 2020   kindergarten 5.0 1.0 21.0     1.0             15.0 13.0                       28 5 1 21     1             15 13                 28
1710201 NV     school 3200480 16   Washoe 320048000560 16281 Mariposa Acad   Regular School Yes Elementary PK 05 2020   kindergarten     25.0                   11.0 14.0                       25     25                   11 14                 25
1710332 NV     school 3200480 16   Washoe 320048000217 16601 Gerlach K-12   Regular School No Other PK 12 2020   kindergarten     1.0                   1.0                         1     1                   1                   1
1710388 NV     school 3200480 16   Washoe 320048000233 16911 Picollo Sch   Special Education School No Other PK 12 2020   kindergarten     4.0     1.0             3.0 2.0                       5     4     1             3 2                 5
1710415 NV     school 3200480 16   Washoe 320048000844 16923 North Star   Alternative School No Other PK 12 2020   kindergarten 2.0                       1.0 1.0                       2 2                       1 1                 2
1710438 NV     school 3200510 17   White Pine 320051000263 17203 McGill ES   Regular School No Elementary PK 05 2020   kindergarten 16.0 1.0 2.0   2.0               9.0 12.0                       21 16 1 2   2               9 12                 21
1710553 NV     school 3200001 49   Mater Academy 320000100902 49433 Mater Bonanza ACAD   Regular School Yes Elementary PK 08 2020   kindergarten 5.0 10.0 84.0             1.0     53.0 47.0                       100 5 10 84             1     53 47                 100
1875158 NV     school 3200060 2   Clark 320006000717 2092 Innovations ES   Regular School Yes Elementary PK 05 2019   kindergarten 6.0 16.0 38.0     1.0       2.0     33.0 30.0                       63 6 16 38     1       2     33 30                 63
1875231 NV     school 3200060 2   Clark 320006000080 2103 Lundy   Regular School No Elementary PK 05 2019   kindergarten 3.0                         3.0                       3 3                         3                 3
1875306 NV     school 3200060 2   Clark 320006000359 2114 Perkins Ute ES   Regular School No Elementary PK 05 2019   kindergarten 13.0   6.0   4.0               16.0 7.0                       23 13   6   4               16 7                 23
1875944 NV     school 3200060 2   Clark 320006000016 2206 Gilbert ES   Regular School No Elementary PK 05 2019   kindergarten 2.0 4.0 13.0                   9.0 10.0                       19 2 4 13                   9 10                 19
1875965 NV     school 3200060 2   Clark 320006000033 2209 Herron ES   Regular School No Elementary PK 05 2019   kindergarten 9.0 7.0 98.0   1.0 1.0             61.0 55.0                       116 9 7 98   1 1             61 55                 116
1876043 NV     school 3200060 2   Clark 320006000064 2219 Carson   Regular School No Elementary PK 05 2019   kindergarten 3.0 22.0 25.0                   24.0 26.0                       50 3 22 25                   24 26                 50
1876094 NV     school 3200060 2   Clark 320006000797 2227 Early Childhood   Special Education School No Elementary PK KG 2019   kindergarten           1.0             1.0                         1           1             1                   1
1876136 NV     school 3200060 2   Clark 320006000088 2234 McCall ES   Regular School No Elementary PK 05 2019   kindergarten 2.0 11.0 31.0                   16.0 28.0                       44 2 11 31                   16 28                 44
1876185 NV     school 3200060 2   Clark 320006000104 2242 Tom Williams ES   Regular School No Elementary PK 05 2019   kindergarten 13.0   91.0     1.0       1.0     65.0 41.0                       106 13   91     1       1     65 41                 106
1876439 NV     school 3200060 2   Clark 320006000302 2279 Bowler Grant   Regular School No Elementary PK 05 2019   kindergarten 83.0 1.0 11.0     2.0             37.0 60.0                       97 83 1 11     2             37 60                 97
1876460 NV     school 3200060 2   Clark 320006000508 2282 Moore ES   Regular School No Elementary PK 05 2019   kindergarten 7.0 22.0 77.0     1.0             52.0 55.0                       107 7 22 77     1             52 55                 107
1876516 NV     school 3200060 2   Clark 320006000612 2291 Sandy Valley   Regular School No Elementary PK 05 2019   kindergarten 9.0   7.0                   9.0 7.0                       16 9   7                   9 7                 16
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
1877152 NV     school 3200090 3   Douglas 320009000124 3202 Zephyr Cove   Regular School No Elementary PK 06 2019   kindergarten 8.0 1.0                     2.0 7.0                       9 8 1                     2 7                 9
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
1877239 NV     school 3200120 4   Elko 320012000134 4108 Mound Vly ES   Regular School No Elementary KG 08 2019   kindergarten 2.0                         2.0                       2 2                         2                 2
1877246 NV     school 3200120 4   Elko 320012000139 4111 Ruby Vly ES   Regular School No Elementary KG 08 2019   kindergarten 2.0                       2.0                         2 2                       2                   2
1877278 NV     school 3200120 4   Elko 320012000727 4206 Owyhee ES   Regular School No Elementary PK 06 2019   kindergarten 2.0       31.0 1.0             15.0 19.0                       34 2       31 1             15 19                 34
1877377 NV     school 3200120 4   Elko 320012000839 4610 NNVVirtual   Regular School No Other KG 12 2019   kindergarten 2.0                       1.0 1.0                       2 2                       1 1                 2
1877388 NV     school 3200150 5   Esmeralda 320015000143 5101 Dyer ES   Regular School No Elementary PK 08 2019   kindergarten 1.0   4.0                   1.0 4.0                       5 1   4                   1 4                 5
1877405 NV     school 3200150 5   Esmeralda 320015000145 5103 Silver Peak ES   Regular School No Elementary PK 08 2019   kindergarten 1.0                         1.0                       1 1                         1                 1
1877440 NV     school 3200210 7   Humboldt 320021000151 7103 Kings River ES   Regular School No Elementary PK 08 2019   kindergarten     2.0                   1.0 1.0                       2     2                   1 1                 2
1877448 NV     school 3200210 7   Humboldt 320021000155 7104 Orovada ES   Regular School No Elementary PK 08 2019   kindergarten 2.0   2.0                   1.0 3.0                       4 2   2                   1 3                 4
1877457 NV     school 3200210 7   Humboldt 320021000156 7105 Paradise Vly ES   Regular School No Elementary PK 08 2019   kindergarten 5.0   3.0                   5.0 3.0                       8 5   3                   5 3                 8
1877473 NV     school 3200210 7   Humboldt 320021000153 7203 McDermitt ES   Regular School No Elementary PK 05 2019   kindergarten 1.0       4.0               2.0 3.0                       5 1       4               2 3                 5
1877531 NV     school 3200270 9   Lincoln 320027000166 9201 Caliente ES   Regular School No Elementary PK 06 2019   kindergarten 14.0                       6.0 8.0                       14 14                       6 8                 14
1877539 NV     school 3200270 9   Lincoln 320027000172 9202 Panaca ES   Regular School No Elementary PK 06 2019   kindergarten 20.0                       10.0 10.0                       20 20                       10 10                 20
1877547 NV     school 3200270 9   Lincoln 320027000173 9203 Pioche ES   Regular School No Elementary PK 06 2019   kindergarten 9.0                       5.0 4.0                       9 9                       5 4                 9
1877654 NV     school 3200300 10   Lyon 320030000178 10602 Smith Valley Sch   Regular School No Other PK 12 2019   kindergarten 5.0   1.0                   3.0 3.0                       6 5   1                   3 3                 6
1877718 NV     school 3200360 12   Nye 320036000193 12103 Round Mtn   Regular School No Elementary PK 05 2019   kindergarten 22.0   3.0                   10.0 15.0                       25 22   3                   10 15                 25
1877731 NV     school 3200360 12   Nye 320036000185 12106 Amargosa Vly ES   Regular School No Elementary PK 05 2019   kindergarten 7.0   5.0                   7.0 5.0                       12 7   5                   7 5                 12
1877745 NV     school 3200360 12   Nye 320036000186 12201 Beatty   Regular School No Elementary PK 05 2019   kindergarten 8.0   5.0                   8.0 5.0                       13 8   5                   8 5                 13
1877772 NV     school 3200360 12   Nye 320036000871 12211 Warm Springs   Regular School No Elementary PK 08 2019   kindergarten 1.0                         1.0                       1 1                         1                 1
1877923 NV     school 3200450 15   Storey 320045000413 15102 Hillside ES   Regular School No Elementary PK 05 2019   kindergarten 8.0   3.0                   4.0 7.0                       11 8   3                   4 7                 11
1878080 NV     school 3200480 16   Washoe 320048000201 16221 Risley ES   Regular School No Elementary PK 06 2019   kindergarten 8.0 2.0 57.0     3.0       1.0     37.0 34.0                       71 8 2 57     3       1     37 34                 71
1878103 NV     school 3200480 16   Washoe 320048000220 16224 Greenbrae ES   Regular School No Elementary PK 06 2019   kindergarten 12.0 1.0 38.0     1.0       1.0     26.0 27.0                       53 12 1 38     1       1     26 27                 53
1878175 NV     school 3200480 16   Washoe 320048000249 16234 Sun Valley ES   Regular School No Elementary PK 06 2019   kindergarten 12.0 1.0 67.0     1.0             47.0 34.0                       81 12 1 67     1             47 34                 81
1878536 NV     school 3200480 16   Washoe 320048000217 16601 Gerlach K-12   Regular School No Other PK 12 2019   kindergarten 4.0                       4.0                         4 4                       4                   4
1878598 NV     school 3200480 16   Washoe 320048000233 16911 Picollo Sch   Special Education School No Other PK 12 2019   kindergarten 2.0   1.0                   2.0 1.0                       3 2   1                   2 1                 3
1878647 NV     school 3200510 17   White Pine 320051000263 17203 McGill ES   Regular School No Elementary PK 05 2019   kindergarten 14.0   3.0   1.0         1.0     8.0 11.0                       19 14   3   1         1     8 11                 19
1878987 NV     school 3200001 68   Elko Institute for Academic Achievement 320000100784 68410 EIAA   Regular School Yes Elementary KG 08 2019   kindergarten 18.0 1.0 1.0   1.0 1.0             10.0 12.0                       22 18 1 1   1 1             10 12                 22
1879049 NV     school 3200001 86   Nevada Virtual Academy 320000100734 86404 Nevada Virtual ACAD   Regular School Yes Other KG 12 2019   kindergarten 24.0 15.0 21.0   1.0 3.0       3.0     31.0 36.0                       67 24 15 21   1 3       3     31 36                 67
1878939 NV     school 3200001 59   Somerset Academy 320000100911 59125 Somerset Skye   Regular School Yes Elementary KG 08 2019   kindergarten 10.0   19.0               69.0   45.0 53.0                       98 10   19               69   45 53                 98
1707720 NV     school 3200060 2   Clark 320006000716 2200 Wright ES   Regular School No Elementary PK 05 2020   kindergarten 56.0 13.0 49.0   2.0 19.0       1.0 33.0   85.0 88.0                       173 56 13 49   2 19       1 33   85 88                 173
1706817 NV     school 3200060 2   Clark 320006000927 2067 Divich   Regular School No Elementary PK 05 2020   kindergarten 79.0 18.0 37.0   1.0 4.0       4.0 27.0   85.0 85.0                       170 79 18 37   1 4       4 27   85 85                 170
1710701 NV     school 3200001 58   Pinecrest Academy of Nevada 320000100941 58428 Pinecrest Sloan Canyon   Regular School Yes Other KG 09 2020   kindergarten 56.0 5.0 29.0   1.0 25.0       4.0 27.0   77.0 70.0                       147 56 5 29   1 25       4 27   77 70                 147
1843154 NV     school 3200001 55   Doral Academy 320000100906 55203 Doral Saddle   Regular School Yes Elementary KG 08 2021   kindergarten 28 6 21   0 17       0 27   45 54   0.0                   99 28 6 21   0 17       0 27   45 54   0             99
1839327 NV     school 3200060 2   Clark County 320006000874 2068 Jones Blackhurst ES   Regular School No Elementary PK 05 2021   kindergarten 57 5 32   0 16       2 26   77 61   0.0                   138 57 5 32   0 16       2 26   77 61   0             138
1843001 NV     school 3200001 39   Legacy Traditional School 320000100934 39440 Legacy SW   Regular School Yes Elementary KG 08 2021   kindergarten 39 22 27   0 45       6 26   67 98   0.0                   165 39 22 27   0 45       6 26   67 98   0             165
1875019 NV     school 3200060 2   Clark 320006000873 2070 Berkley ES   Regular School No Elementary PK 05 2019   kindergarten 52.0 22.0 26.0     19.0       1.0 26.0   72.0 74.0                       146 52 22 26     19       1 26   72 74                 146
1875089 NV     school 3200060 2   Clark 320006000786 2081 Bozarth ES   Regular School No Elementary PK 05 2019   kindergarten 85.0 12.0 32.0   1.0 9.0       2.0 26.0   91.0 76.0                       167 85 12 32   1 9       2 26   91 76                 167
1875610 NV     school 3200060 2   Clark 320006000455 2158 Cartwright   Regular School No Elementary PK 05 2019   kindergarten 40.0 8.0 47.0     15.0       2.0 26.0   68.0 70.0                       138 40 8 47     15       2 26   68 70                 138
1707017 NV     school 3200060 2   Clark 320006000722 2098 Steele ES   Regular School No Elementary PK 05 2020   kindergarten 35.0 12.0 21.0     24.0       5.0 25.0   72.0 50.0                       122 35 12 21     24       5 25   72 50                 122
1710871 NV     school 3200001 85   Nevada Connections Academy 320000100731 85405 NV Connections ACAD   Regular School Yes Other KG 12 2020   kindergarten 56.0 16.0 38.0     3.0       1.0 25.0   63.0 76.0                       139 56 16 38     3       1 25   63 76                 139
1839306 NV     school 3200060 2   Clark County 320006000915 2065 Ortwein ES   Regular School No Elementary PK 05 2021   kindergarten 26 18 30   0 10       2 25   62 49   0.0                   111 26 18 30   0 10       2 25   62 49   0             111
1843220 NV     school 3200001 58   Pinecrest Academy of Nevada 320000100941 58428 Pinecrest Sloan   Regular School Yes Other KG 10 2021   kindergarten 45 1 34   0 15       3 25   64 59   0.0                   123 45 1 34   0 15       3 25   64 59   0             123
1875463 NV     school 3200060 2   Clark 320006000045 2137 Bartlett   Regular School No Elementary PK 05 2019   kindergarten 54.0 5.0 23.0     8.0       4.0 25.0   66.0 53.0                       119 54 5 23     8       4 25   66 53                 119
1706824 NV     school 3200060 2   Clark 320006000874 2068 Blackhurst ES   Regular School No Elementary PK 05 2020   kindergarten 59.0 10.0 43.0     23.0       5.0 24.0   86.0 78.0                       164 59 10 43     23       5 24   86 78                 164
1875853 NV     school 3200060 2   Clark 320006000654 2193 Batterman   Regular School No Elementary PK 05 2019   kindergarten 59.0 9.0 29.0     24.0       3.0 24.0   80.0 68.0                       148 59 9 29     24       3 24   80 68                 148
1875902 NV     school 3200060 2   Clark 320006000716 2200 Wright ES   Regular School No Elementary PK 05 2019   kindergarten 70.0 18.0 55.0   1.0 32.0       2.0 24.0   102.0 100.0                       202 70 18 55   1 32       2 24   102 100                 202
1706803 NV     school 3200060 2   Clark 320006000915 2065 Ortwein   Regular School No Elementary PK 05 2020   kindergarten 34.0 8.0 35.0     15.0       6.0 23.0   65.0 56.0                       121 34 8 35     15       6 23   65 56                 121
1710495 NV     school 3200001 39   Legacy Traditional School 320000100934 39440 Legacy Southwest   Regular School Yes Elementary KG 08 2020   kindergarten 47.0 18.0 36.0   1.0 54.0       3.0 23.0   86.0 96.0                       182 47 18 36   1 54       3 23   86 96                 182

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