Data source: Big Local News · About: Big Local

420 rows where grade = "kindergarten", state = "NV" and year = 2019 sorted by black

View and edit SQL

year

  • 2019 · 420

grade

  • kindergarten · 420
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
1875144 NV     school 3200060 2   Clark 320006000732 2090 Smalley   Regular School No Elementary PK 05 2019   kindergarten 103.0   17.0     1.0         12.0   64.0 69.0                       133 103   17     1         12   64 69                 133
1875219 NV     school 3200060 2   Clark 320006000010 2101 Blue Diamond   Regular School No Elementary PK 05 2019   kindergarten 2.0   1.0               1.0   3.0 1.0                       4 2   1               1   3 1                 4
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
1875237 NV     school 3200060 2   Clark 320006000099 2104 Reid ES   Regular School No Elementary PK 05 2019   kindergarten 2.0                   1.0   1.0 2.0                       3 2                   1   1 2                 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
1876014 NV     school 3200060 2   Clark 320006000384 2215 Miller Sch   Special Education School No Other PK 12 2019   kindergarten 1.0   4.0               1.0   5.0 1.0                       6 1   4               1   5 1                 6
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
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
1876237 NV     school 3200060 2   Clark 320006000012 2250 Mitchell ES   Regular School No Elementary PK 05 2019   kindergarten 96.0   12.0     4.0         6.0   67.0 51.0                       118 96   12     4         6   67 51                 118
1876251 NV     school 3200060 2   Clark 320006000577 2252 Indian Springs   Regular School No Elementary PK 05 2019   kindergarten 5.0   7.0               3.0   11.0 4.0                       15 5   7               3   11 4                 15
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
1877144 NV     school 3200090 3   Douglas 320009000121 3201 Gardnerville ES   Regular School No Elementary PK 05 2019   kindergarten 37.0   14.0   1.0           1.0   17.0 36.0                       53 37   14   1           1   17 36                 53
1877159 NV     school 3200090 3   Douglas 320009000293 3205 Meneley ES   Regular School No Elementary PK 05 2019   kindergarten 34.0   8.0   4.0 1.0         5.0   24.0 28.0                       52 34   8   4 1         5   24 28                 52
1877166 NV     school 3200090 3   Douglas 320009000307 3206 Jacks Vly ES   Regular School No Elementary PK 05 2019   kindergarten 26.0   19.0   1.0 3.0         3.0   24.0 28.0                       52 26   19   1 3         3   24 28                 52
1877173 NV     school 3200090 3   Douglas 320009000347 3207 Scarselli ES   Regular School No Elementary PK 05 2019   kindergarten 55.0   13.0   1.0 1.0         7.0   38.0 39.0                       77 55   13   1 1         7   38 39                 77
1877179 NV     school 3200090 3   Douglas 320009000447 3209 Pinon Hills   Regular School No Elementary PK 05 2019   kindergarten 41.0   9.0     1.0         1.0   35.0 17.0                       52 41   9     1         1   35 17                 52
1877186 NV     school 3200090 3   Douglas 320009000448 3210 Minden ES   Regular School No Elementary PK 05 2019   kindergarten 51.0   17.0               4.0   34.0 38.0                       72 51   17               4   34 38                 72
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
1877251 NV     school 3200120 4   Elko 320012000129 4202 Elko Grammar #2 ES   Regular School No Elementary PK 06 2019   kindergarten 37.0   21.0   12.0 3.0         2.0   41.0 34.0                       75 37   21   12 3         2   41 34                 75
1877271 NV     school 3200120 4   Elko 320012000125 4205 Carlin ES   Regular School No Elementary PK 06 2019   kindergarten 30.0   4.0               1.0   16.0 19.0                       35 30   4               1   16 19                 35
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
1877286 NV     school 3200120 4   Elko 320012000141 4207 Wells ES   Regular School No Elementary PK 06 2019   kindergarten 15.0   7.0   2.0 1.0       1.0 2.0   16.0 12.0                       28 15   7   2 1       1 2   16 12                 28
1877293 NV     school 3200120 4   Elko 320012000308 4208 West Wendover ES ES   Regular School No Elementary PK 06 2019   kindergarten 11.0   47.0   1.0           2.0   34.0 27.0                       61 11   47   1           2   34 27                 61
1877306 NV     school 3200120 4   Elko 320012000350 4210 Spring Creek ES   Regular School No Elementary KG 06 2019   kindergarten 136.0   11.0   2.0         1.0 4.0   81.0 73.0                       154 136   11   2         1 4   81 73                 154
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
1877398 NV     school 3200150 5   Esmeralda 320015000144 5102 Goldfield ES   Regular School No Elementary PK 08 2019   kindergarten 2.0                   1.0     3.0                       3 2                   1     3                 3
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
1877413 NV     school 3200180 6   Eureka 320018000146 6101 Crescent Vly   Regular School No Elementary PK 06 2019   kindergarten 6.0                   1.0   2.0 5.0                       7 6                   1   2 5                 7
1877421 NV     school 3200180 6   Eureka 320018000147 6103 Eureka   Regular School No Elementary PK 06 2019   kindergarten 20.0   2.0               1.0   11.0 12.0                       23 20   2               1   11 12                 23
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
1877462 NV     school 3200210 7   Humboldt 320021000157 7201 Sonoma Heights ES   Regular School No Elementary PK 06 2019   kindergarten 57.0   43.0   1.0 1.0       1.0 3.0   59.0 47.0                       106 57   43   1 1       1 3   59 47                 106
1877467 NV     school 3200210 7   Humboldt 320021000158 7202 Winnemucca GS   Regular School No Elementary PK 04 2019   kindergarten 42.0   22.0   1.0           1.0   36.0 30.0                       66 42   22   1           1   36 30                 66
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
1877478 NV     school 3200210 7   Humboldt 320021000325 7205 Grass Vly ES   Regular School No Elementary PK 04 2019   kindergarten 55.0   28.0   2.0 1.0       1.0 2.0   51.0 38.0                       89 55   28   2 1       1 2   51 38                 89
1877502 NV     school 3200240 8   Lander 320024000165 8201 Battle Mtn ES   Regular School No Elementary PK 05 2019   kindergarten 56.0   29.0   1.0           3.0   51.0 38.0                       89 56   29   1           3   51 38                 89
1877523 NV     school 3200270 9   Lincoln 320027000170 9102 Pahranagat Vly ES   Regular School No Elementary PK 05 2019   kindergarten 23.0                   1.0   10.0 14.0                       24 23                   1   10 14                 24
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
1877581 NV     school 3200300 10   Lyon 320030000179 10202 Yerington ES   Regular School No Elementary PK 04 2019   kindergarten 55.0   34.0   1.0 2.0         7.0   52.0 47.0                       99 55   34   1 2         7   52 47                 99
1877593 NV     school 3200300 10   Lyon 320030000299 10205 SilverSprings ES   Regular School No Elementary PK 04 2019   kindergarten 53.0   7.0               3.0   37.0 26.0                       63 53   7               3   37 26                 63
1877607 NV     school 3200300 10   Lyon 320030000387 10209 Cottonwood   Regular School No Elementary PK 04 2019   kindergarten 75.0   29.0   3.0 1.0       2.0 7.0   58.0 59.0                       117 75   29   3 1       2 7   58 59                 117
1877615 NV     school 3200300 10   Lyon 320030000450 10210 Sutro   Regular School No Elementary PK 06 2019   kindergarten 37.0   16.0               5.0   32.0 26.0                       58 37   16               5   32 26                 58
1877623 NV     school 3200300 10   Lyon 320030000746 10211 Riverview   Regular School No Elementary PK 06 2019   kindergarten 34.0   15.0   1.0           4.0   32.0 22.0                       54 34   15   1           4   32 22                 54
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
1877682 NV     school 3200330 11   Mineral 320033000811 11201 Hawthorne E.S. ES   Regular School No Elementary PK 06 2019   kindergarten 28.0   3.0   1.0         2.0 6.0   19.0 21.0                       40 28   3   1         2 6   19 21                 40
1877690 NV     school 3200330 11   Mineral 320033000184 11202 Schurz ES   Regular School No Elementary PK 06 2019   kindergarten     2.0   8.0           2.0   7.0 5.0                       12     2   8           2   7 5                 12
1877704 NV     school 3200360 12   Nye 320036000188 12101 Duckwater ES   Regular School No Elementary PK 05 2019   kindergarten                     1.0     1.0                       1                     1     1                 1
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
1877725 NV     school 3200360 12   Nye 320036000189 12105 Gabbs ES   Regular School No Elementary PK 05 2019   kindergarten 1.0   1.0               1.0   3.0                         3 1   1               1   3                   3
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
1877751 NV     school 3200360 12   Nye 320036000194 12202 Tonopah   Regular School No Elementary PK 05 2019   kindergarten 21.0   5.0             1.0 1.0   11.0 17.0                       28 21   5             1 1   11 17                 28
1877758 NV     school 3200360 12   Nye 320036000543 12207 Hafen ES   Regular School No Elementary PK 05 2019   kindergarten 32.0   19.0               3.0   33.0 21.0                       54 32   19               3   33 21                 54
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
1877843 NV     school 3200390 13   Carson 320039000285 13204 Fremont ES   Regular School No Elementary PK 05 2019   kindergarten 39.0   36.0   1.0         1.0 3.0   36.0 44.0                       80 39   36   1         1 3   36 44                 80
1877873 NV     school 3200390 13   Carson 320039000569 13212 Carson Montessori   Regular School Yes Elementary KG 06 2019   kindergarten 40.0   15.0   1.0 2.0         3.0   28.0 33.0                       61 40   15   1 2         3   28 33                 61
1877895 NV     school 3200420 14   Pershing 320042000196 14101 Imlay ES   Regular School No Elementary PK 05 2019   kindergarten 4.0   1.0               1.0   5.0 1.0                       6 4   1               1   5 1                 6
1877901 NV     school 3200420 14   Pershing 320042000197 14201 Lovelock ES   Regular School No Elementary PK 05 2019   kindergarten 18.0   14.0   4.0           6.0   22.0 20.0                       42 18   14   4           6   22 20                 42
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
1877953 NV     school 3200480 16   Washoe 320048000212 16203 Elmcrest   Regular School No Elementary PK 06 2019   kindergarten 27.0   25.0   1.0 1.0       1.0 6.0   31.0 30.0                       61 27   25   1 1       1 6   31 30                 61
1878005 NV     school 3200480 16   Washoe 320048000558 16210 Melton   Regular School No Elementary PK 05 2019   kindergarten 65.0   10.0     5.0         10.0   54.0 36.0                       90 65   10     5         10   54 36                 90
1878051 NV     school 3200480 16   Washoe 320048000243 16216 Gomm   Regular School No Elementary PK 06 2019   kindergarten 47.0   5.0     2.0       1.0 5.0   29.0 31.0                       60 47   5     2       1 5   29 31                 60
1878065 NV     school 3200480 16   Washoe 320048000248 16219 Stead   Regular School No Elementary PK 06 2019   kindergarten 37.0   43.0     1.0       5.0 3.0   46.0 43.0                       89 37   43     1       5 3   46 43                 89
1878095 NV     school 3200480 16   Washoe 320048000214 16223 Drake   Regular School No Elementary PK 06 2019   kindergarten 10.0   25.0             1.0 1.0   20.0 17.0                       37 10   25             1 1   20 17                 37
1878160 NV     school 3200480 16   Washoe 320048000228 16232 Lemmon Vly ES   Regular School No Elementary PK 05 2019   kindergarten 48.0   35.0     3.0       1.0 3.0   48.0 42.0                       90 48   35     3       1 3   48 42                 90
1878167 NV     school 3200480 16   Washoe 320048000237 16233 Pleasant Vly   Regular School No Elementary PK 05 2019   kindergarten 50.0   8.0               3.0   29.0 32.0                       61 50   8               3   29 32                 61
1878189 NV     school 3200480 16   Washoe 320048000234 16237 Natchez ES   Regular School No Elementary PK 06 2019   kindergarten     1.0   11.0           2.0   5.0 9.0                       14     1   11           2   5 9                 14
1878197 NV     school 3200480 16   Washoe 320048000320 16238 Diedrichsen   Regular School No Elementary PK 06 2019   kindergarten 32.0   18.0   1.0 3.0       1.0 6.0   29.0 32.0                       61 32   18   1 3       1 6   29 32                 61
1878221 NV     school 3200480 16   Washoe 320048000723 16241 Hall   Regular School No Elementary PK 06 2019   kindergarten 33.0   16.0   13.0           4.0   43.0 23.0                       66 33   16   13           4   43 23                 66
1878236 NV     school 3200480 16   Washoe 320048000224 16251 Incline ES   Regular School No Elementary PK 05 2019   kindergarten 22.0   41.0               1.0   33.0 31.0                       64 22   41               1   33 31                 64
1878242 NV     school 3200480 16   Washoe 320048000322 16256 Gomes   Regular School No Elementary PK 04 2019   kindergarten 64.0   31.0               12.0   42.0 65.0                       107 64   31               12   42 65                 107
1878250 NV     school 3200480 16   Washoe 320048000317 16257 Lenz   Regular School No Elementary PK 06 2019   kindergarten 59.0   6.0     7.0         4.0   37.0 39.0                       76 59   6     7         4   37 39                 76
1878282 NV     school 3200480 16   Washoe 320048000389 16261 Caughlin Ranch   Regular School No Elementary PK 06 2019   kindergarten 53.0   11.0     4.0         5.0   33.0 40.0                       73 53   11     4         5   33 40                 73
1878290 NV     school 3200480 16   Washoe 320048000366 16262 Hidden Vly   Regular School No Elementary PK 06 2019   kindergarten 29.0   15.0   7.0 2.0       1.0 11.0   34.0 31.0                       65 29   15   7 2       1 11   34 31                 65
1878318 NV     school 3200480 16   Washoe 320048000414 16266 Allen ES   Regular School No Elementary PK 06 2019   kindergarten 19.0   43.0     2.0       4.0 3.0   45.0 26.0                       71 19   43     2       4 3   45 26                 71
1878381 NV     school 3200480 16   Washoe 320048000467 16274 Hunsberger   Regular School No Elementary PK 06 2019   kindergarten 68.0   5.0     4.0         10.0   47.0 40.0                       87 68   5     4         10   47 40                 87
1878388 NV     school 3200480 16   Washoe 320048000481 16275 Bennett ES   Regular School No Elementary PK 06 2019   kindergarten 23.0   42.0   1.0           2.0   31.0 37.0                       68 23   42   1           2   31 37                 68
1878410 NV     school 3200480 16   Washoe 320048000560 16281 Mariposa Acad   Regular School Yes Elementary PK 05 2019   kindergarten 1.0   40.0               1.0   22.0 20.0                       42 1   40               1   22 20                 42
1878420 NV     school 3200480 16   Washoe 320048000561 16282 High Desert Monte   Regular School Yes Other PK 09 2019   kindergarten 31.0   9.0   2.0 1.0         8.0   27.0 24.0                       51 31   9   2 1         8   27 24                 51
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
1878556 NV     school 3200480 16   Washoe 320048000503 16605 Sierra NV Acad   Regular School Yes Elementary KG 08 2019   kindergarten 25.0   18.0     5.0       1.0 8.0   40.0 17.0                       57 25   18     5       1 8   40 17                 57
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
1878624 NV     school 3200480 16   Washoe 320048000844 16923 North Star   Alternative School No Other PK 12 2019   kindergarten 1.0   1.0               1.0   1.0 2.0                       3 1   1               1   1 2                 3
1878631 NV     school 3200510 17   White Pine 320051000720 17101 Lund ES   Regular School No Elementary KG 05 2019   kindergarten 4.0   1.0               2.0   5.0 2.0                       7 4   1               2   5 2                 7
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
1878776 NV     school 3200001 54   Learning Bridge 320000100833 54428 Learning Bridge   Regular School Yes Elementary KG 08 2019   kindergarten 15.0   3.0   1.0           1.0   10.0 10.0                       20 15   3   1           1   10 10                 20
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
1878970 NV     school 3200001 65   Oasis Academy 320000100817 65414 Oasis ACAD   Regular School Yes Other KG 12 2019   kindergarten 51.0   11.0   2.0 1.0         7.0   29.0 43.0                       72 51   11   2 1         7   29 43                 72
1875225 NV     school 3200060 2   Clark 320006000037 2102 Goodsprings   Regular School No Elementary PK 05 2019   kindergarten 4.0 1.0 1.0     1.0         1.0   6.0 2.0                       8 4 1 1     1         1   6 2                 8
1875285 NV     school 3200060 2   Clark 320006000356 2111 Dooley ES   Regular School No Elementary PK 05 2019   kindergarten 45.0 1.0 14.0               1.0   31.0 30.0                       61 45 1 14               1   31 30                 61
1875616 NV     school 3200060 2   Clark 320006000456 2159 Bowler Joseph   Regular School No Elementary PK 05 2019   kindergarten 37.0 1.0 43.0             1.0 2.0   49.0 35.0                       84 37 1 43             1 2   49 35                 84
1876213 NV     school 3200060 2   Clark 320006000112 2246 Bracken   Regular School No Elementary PK 05 2019   kindergarten 2.0 1.0 35.0     1.0         1.0   21.0 19.0                       40 2 1 35     1         1   21 19                 40
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

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