Data source: Big Local News · About: Big Local

336 rows where grade = "pre_kindergarten", state = "NV" and year = 2019 sorted by female

View and edit SQL

year

  • 2019 · 336

grade

  • pre_kindergarten · 336
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
1875335 NV     school 3200060 2   Clark 320006000260 2118 Eisenberg   Regular School No Elementary PK 05 2019   pre_kindergarten 5.0                   1.0   6.0                         6 5                   1   6                   6
1875426 NV     school 3200060 2   Clark 320006000395 2131 Adams   Regular School No Elementary PK 05 2019   pre_kindergarten           1.0             1.0                         1           1             1                   1
1877180 NV     school 3200090 3   Douglas 320009000447 3209 Pinon Hills   Regular School No Elementary PK 05 2019   pre_kindergarten 1.0                       1.0                         1 1                       1                   1
1877655 NV     school 3200300 10   Lyon 320030000178 10602 Smith Valley Sch   Regular School No Other PK 12 2019   pre_kindergarten 1.0                       1.0                         1 1                       1                   1
1877705 NV     school 3200360 12   Nye 320036000188 12101 Duckwater ES   Regular School No Elementary PK 05 2019   pre_kindergarten                     1.0   1.0                         1                     1   1                   1
1877719 NV     school 3200360 12   Nye 320036000193 12103 Round Mtn   Regular School No Elementary PK 05 2019   pre_kindergarten 1.0                       1.0                         1 1                       1                   1
1877829 NV     school 3200390 13   Carson 320039000288 13201 Bordewich Bray ES   Regular School No Elementary PK 05 2019   pre_kindergarten 1.0                       1.0                         1 1                       1                   1
1877837 NV     school 3200390 13   Carson 320039000286 13203 Fritsch ES   Regular School No Elementary PK 05 2019   pre_kindergarten 1.0                       1.0                         1 1                       1                   1
1877852 NV     school 3200390 13   Carson 320039000282 13207 Seeliger ES   Regular School No Elementary PK 05 2019   pre_kindergarten 1.0                       1.0                         1 1                       1                   1
1877924 NV     school 3200450 15   Storey 320045000413 15102 Hillside ES   Regular School No Elementary PK 05 2019   pre_kindergarten 1.0                 1.0     2.0                         2 1                 1     2                   2
1877976 NV     school 3200480 16   Washoe 320048000223 16206 Hunter Lake   Regular School No Elementary PK 06 2019   pre_kindergarten     1.0               1.0   2.0                         2     1               1   2                   2
1877984 NV     school 3200480 16   Washoe 320048000226 16207 Beck ES   Regular School No Elementary PK 06 2019   pre_kindergarten 1.0                       1.0                         1 1                       1                   1
1877999 NV     school 3200480 16   Washoe 320048000232 16209 Towles ES   Regular School No Elementary PK 06 2019   pre_kindergarten 1.0                       1.0                         1 1                       1                   1
1878006 NV     school 3200480 16   Washoe 320048000558 16210 Melton   Regular School No Elementary PK 05 2019   pre_kindergarten 1.0                       1.0                         1 1                       1                   1
1878016 NV     school 3200480 16   Washoe 320048000321 16211 Mount Rose ES   Regular School No Elementary PK 08 2019   pre_kindergarten     1.0                   1.0                         1     1                   1                   1
1878096 NV     school 3200480 16   Washoe 320048000214 16223 Drake   Regular School No Elementary PK 06 2019   pre_kindergarten     1.0                   1.0                         1     1                   1                   1
1878190 NV     school 3200480 16   Washoe 320048000234 16237 Natchez ES   Regular School No Elementary PK 06 2019   pre_kindergarten         2.0               2.0                         2         2               2                   2
1878198 NV     school 3200480 16   Washoe 320048000320 16238 Diedrichsen   Regular School No Elementary PK 06 2019   pre_kindergarten 1.0                       1.0                         1 1                       1                   1
1878214 NV     school 3200480 16   Washoe 320048000324 16240 Palmer ES   Regular School No Elementary PK 06 2019   pre_kindergarten     2.0                   2.0                         2     2                   2                   2
1878222 NV     school 3200480 16   Washoe 320048000723 16241 Hall   Regular School No Elementary PK 06 2019   pre_kindergarten 1.0                       1.0                         1 1                       1                   1
1878230 NV     school 3200480 16   Washoe 320048000706 16242 Sepulveda   Regular School No Elementary PK 06 2019   pre_kindergarten 2.0                       2.0                         2 2                       2                   2
1878243 NV     school 3200480 16   Washoe 320048000322 16256 Gomes   Regular School No Elementary PK 04 2019   pre_kindergarten 2.0                       2.0                         2 2                       2                   2
1878267 NV     school 3200480 16   Washoe 320048000336 16259 Whitehead   Regular School No Elementary PK 06 2019   pre_kindergarten     1.0                   1.0                         1     1                   1                   1
1875069 NV     school 3200060 2   Clark 320006000816 2078 Stuckey ES   Regular School No Elementary PK 05 2019   pre_kindergarten 3.0 1.0       1.0         1.0   5.0 1.0                       6 3 1       1         1   5 1                 6
1875638 NV     school 3200060 2   Clark 320006000459 2162 Morrow   Regular School No Elementary PK 05 2019   pre_kindergarten 5.0   4.0             1.0 3.0   12.0 1.0                       13 5   4             1 3   12 1                 13
1876030 NV     school 3200060 2   Clark 320006000058 2217 Mackey   Regular School No Elementary PK 05 2019   pre_kindergarten   2.0 3.0                   4.0 1.0                       5   2 3                   4 1                 5
1877145 NV     school 3200090 3   Douglas 320009000121 3201 Gardnerville ES   Regular School No Elementary PK 05 2019   pre_kindergarten 1.0                         1.0                       1 1                         1                 1
1877313 NV     school 3200120 4   Elko 320012000385 4211 Sage ES   Regular School No Elementary PK 05 2019   pre_kindergarten 2.0                   1.0   2.0 1.0                       3 2                   1   2 1                 3
1877406 NV     school 3200150 5   Esmeralda 320015000145 5103 Silver Peak ES   Regular School No Elementary PK 08 2019   pre_kindergarten 1.0                         1.0                       1 1                         1                 1
1877691 NV     school 3200330 11   Mineral 320033000184 11202 Schurz ES   Regular School No Elementary PK 06 2019   pre_kindergarten         1.0                 1.0                       1         1                 1                 1
1878023 NV     school 3200480 16   Washoe 320048000559 16212 Double Diamond ES   Regular School No Elementary PK 05 2019   pre_kindergarten 3.0   2.0                   4.0 1.0                       5 3   2                   4 1                 5
1878066 NV     school 3200480 16   Washoe 320048000248 16219 Stead   Regular School No Elementary PK 06 2019   pre_kindergarten 1.0                         1.0                       1 1                         1                 1
1878131 NV     school 3200480 16   Washoe 320048000241 16228 Mitchell ES   Regular School No Elementary PK 05 2019   pre_kindergarten 1.0   1.0                   1.0 1.0                       2 1   1                   1 1                 2
1878251 NV     school 3200480 16   Washoe 320048000317 16257 Lenz   Regular School No Elementary PK 06 2019   pre_kindergarten 3.0   2.0               2.0   6.0 1.0                       7 3   2               2   6 1                 7
1878259 NV     school 3200480 16   Washoe 320048000316 16258 Dodson   Regular School No Elementary PK 06 2019   pre_kindergarten 4.0   2.0               2.0   7.0 1.0                       8 4   2               2   7 1                 8
1878291 NV     school 3200480 16   Washoe 320048000366 16262 Hidden Vly   Regular School No Elementary PK 06 2019   pre_kindergarten 5.0   2.0                   6.0 1.0                       7 5   2                   6 1                 7
1878297 NV     school 3200480 16   Washoe 320048000367 16263 Silver Lake ES   Regular School No Elementary PK 04 2019   pre_kindergarten 1.0                         1.0                       1 1                         1                 1
1878524 NV     school 3200480 16   Washoe 320048000869 16510 Innovations   Alternative School No High 09 12 2019   pre_kindergarten 2.0   1.0                   2.0 1.0                       3 2   1                   2 1                 3
1875171 NV     school 3200060 2   Clark 320006000741 2094 Dickens   Regular School No Elementary PK 05 2019   pre_kindergarten 4.0 7.0 11.0     1.0         2.0   15.0 10.0                       25 4 7 11     1         2   15 10                 25
1875286 NV     school 3200060 2   Clark 320006000356 2111 Dooley ES   Regular School No Elementary PK 05 2019   pre_kindergarten 15.0   8.0                   13.0 10.0                       23 15   8                   13 10                 23
1875680 NV     school 3200060 2   Clark 320006000485 2168 Hayes   Regular School No Elementary PK 05 2019   pre_kindergarten 8.0 5.0 7.0     3.0         2.0   15.0 10.0                       25 8 5 7     3         2   15 10                 25
1875722 NV     school 3200060 2   Clark 320006000529 2174 Rogers ES   Regular School No Elementary PK 05 2019   pre_kindergarten 7.0 4.0 6.0     3.0         2.0   12.0 10.0                       22 7 4 6     3         2   12 10                 22
1876044 NV     school 3200060 2   Clark 320006000064 2219 Carson   Regular School No Elementary PK 05 2019   pre_kindergarten   13.0 12.0                   15.0 10.0                       25   13 12                   15 10                 25
1876252 NV     school 3200060 2   Clark 320006000577 2252 Indian Springs   Regular School No Elementary PK 05 2019   pre_kindergarten 11.0 1.0 2.0               3.0   7.0 10.0                       17 11 1 2               3   7 10                 17
1876385 NV     school 3200060 2   Clark 320006000585 2271 Bilbray   Regular School No Elementary PK 05 2019   pre_kindergarten 19.0 1.0 7.0     2.0         1.0   20.0 10.0                       30 19 1 7     2         1   20 10                 30
1878161 NV     school 3200480 16   Washoe 320048000228 16232 Lemmon Vly ES   Regular School No Elementary PK 05 2019   pre_kindergarten 9.0   10.0     2.0             11.0 10.0                       21 9   10     2             11 10                 21
1878648 NV     school 3200510 17   White Pine 320051000263 17203 McGill ES   Regular School No Elementary PK 05 2019   pre_kindergarten 14.0 1.0 2.0                   7.0 10.0                       17 14 1 2                   7 10                 17
1875192 NV     school 3200060 2   Clark 320006000737 2097 Forbuss ES   Regular School No Elementary PK 05 2019   pre_kindergarten 14.0 2.0 8.0     5.0         4.0   22.0 11.0                       33 14 2 8     5         4   22 11                 33
1875562 NV     school 3200060 2   Clark 320006000437 2151 Allen   Regular School No Elementary PK 05 2019   pre_kindergarten 14.0 1.0 7.0               3.0   14.0 11.0                       25 14 1 7               3   14 11                 25
1875708 NV     school 3200060 2   Clark 320006000527 2172 Darnell   Regular School No Elementary PK 05 2019   pre_kindergarten 18.0 1.0 9.0               3.0   20.0 11.0                       31 18 1 9               3   20 11                 31
1877422 NV     school 3200180 6   Eureka 320018000147 6103 Eureka   Regular School No Elementary PK 06 2019   pre_kindergarten 16.0   3.0               2.0   10.0 11.0                       21 16   3               2   10 11                 21
1877759 NV     school 3200360 12   Nye 320036000543 12207 Hafen ES   Regular School No Elementary PK 05 2019   pre_kindergarten 13.0   6.0   1.0           1.0   10.0 11.0                       21 13   6   1           1   10 11                 21
1878138 NV     school 3200480 16   Washoe 320048000205 16229 Brown   Regular School No Elementary PK 05 2019   pre_kindergarten 13.0   3.0   1.0 3.0         3.0   12.0 11.0                       23 13   3   1 3         3   12 11                 23
1878509 NV     school 3200480 16   Washoe 320048000822 16507 Inspire   Alternative School No Other PK 12 2019   pre_kindergarten 9.0 2.0 20.0   2.0           2.0   24.0 11.0                       35 9 2 20   2           2   24 11                 35
1875770 NV     school 3200060 2   Clark 320006000550 2181 Gehring ACAD   Regular School No Elementary PK 05 2019   pre_kindergarten 9.0 3.0 12.0     12.0         5.0   29.0 12.0                       41 9 3 12     12         5   29 12                 41
1877279 NV     school 3200120 4   Elko 320012000727 4206 Owyhee ES   Regular School No Elementary PK 06 2019   pre_kindergarten     1.0   19.0               8.0 12.0                       20     1   19               8 12                 20
1875694 NV     school 3200060 2   Clark 320006000487 2170 Neal   Regular School No Elementary PK 05 2019   pre_kindergarten 15.0 2.0 7.0               3.0   14.0 13.0                       27 15 2 7               3   14 13                 27
1876095 NV     school 3200060 2   Clark 320006000797 2227 Early Childhood   Special Education School No Elementary PK KG 2019   pre_kindergarten 10.0 9.0 18.0             1.0     25.0 13.0                       38 10 9 18             1     25 13                 38
1876405 NV     school 3200060 2   Clark 320006000588 2274 Miller Sandy   Regular School No Elementary PK 05 2019   pre_kindergarten 4.0 2.0 15.0               1.0   9.0 13.0                       22 4 2 15               1   9 13                 22
1877594 NV     school 3200300 10   Lyon 320030000299 10205 SilverSprings ES   Regular School No Elementary PK 04 2019   pre_kindergarten 36.0   2.0     1.0             26.0 13.0                       39 36   2     1             26 13                 39
1877624 NV     school 3200300 10   Lyon 320030000746 10211 Riverview   Regular School No Elementary PK 06 2019   pre_kindergarten 19.0   5.0               4.0   15.0 13.0                       28 19   5               4   15 13                 28
1878146 NV     school 3200480 16   Washoe 320048000222 16230 Huffaker   Regular School No Elementary PK 06 2019   pre_kindergarten 13.0 2.0 10.0     2.0         2.0   16.0 13.0                       29 13 2 10     2         2   16 13                 29
1878389 NV     school 3200480 16   Washoe 320048000481 16275 Bennett ES   Regular School No Elementary PK 06 2019   pre_kindergarten 11.0   20.0     1.0       1.0     20.0 13.0                       33 11   20     1       1     20 13                 33
1878585 NV     school 3200480 16   Washoe 320048000838 16902 Kendyl Dep PreK   Regular School No Elementary PK KG 2019   pre_kindergarten 15.0 1.0 9.0   1.0 3.0             16.0 13.0                       29 15 1 9   1 3             16 13                 29
1875342 NV     school 3200060 2   Clark 320006000375 2119 Fong   Regular School No Elementary PK 05 2019   pre_kindergarten 5.0 13.0 14.0                   18.0 14.0                       32 5 13 14                   18 14                 32
1876496 NV     school 3200060 2   Clark 320006000513 2287 Wolff   Regular School No Elementary PK 05 2019   pre_kindergarten 22.0 1.0 8.0     6.0         6.0   29.0 14.0                       43 22 1 8     6         6   29 14                 43
1877576 NV     school 3200300 10   Lyon 320030000174 10201 Dayton   Regular School No Elementary PK 06 2019   pre_kindergarten 19.0   11.0               1.0   17.0 14.0                       31 19   11               1   17 14                 31
1877616 NV     school 3200300 10   Lyon 320030000450 10210 Sutro   Regular School No Elementary PK 06 2019   pre_kindergarten 14.0 1.0 18.0     1.0         1.0   21.0 14.0                       35 14 1 18     1         1   21 14                 35
1875265 NV     school 3200060 2   Clark 320006000346 2108 Beatty   Regular School No Elementary PK 05 2019   pre_kindergarten 21.0 2.0 11.0     1.0         1.0   21.0 15.0                       36 21 2 11     1         1   21 15                 36
1875624 NV     school 3200060 2   Clark 320006000457 2160 Rhodes   Regular School No Elementary PK 05 2019   pre_kindergarten 16.0 5.0 7.0     2.0       1.0 8.0   24.0 15.0                       39 16 5 7     2       1 8   24 15                 39
1875805 NV     school 3200060 2   Clark 320006000581 2186 Goolsby   Regular School No Elementary PK 05 2019   pre_kindergarten 25.0 2.0 6.0     5.0         1.0   24.0 15.0                       39 25 2 6     5         1   24 15                 39
1876220 NV     school 3200060 2   Clark 320006000046 2247 Wasden   Regular School No Elementary PK 05 2019   pre_kindergarten 6.0 2.0 16.0               3.0   12.0 15.0                       27 6 2 16               3   12 15                 27
1876322 NV     school 3200060 2   Clark 320006000036 2262 Harris   Regular School No Elementary PK 05 2019   pre_kindergarten 5.0 9.0 20.0     1.0             20.0 15.0                       35 5 9 20     1             20 15                 35
1877187 NV     school 3200090 3   Douglas 320009000448 3210 Minden ES   Regular School No Elementary PK 05 2019   pre_kindergarten 3.0   19.0     1.0         1.0   9.0 15.0                       24 3   19     1         1   9 15                 24
1877252 NV     school 3200120 4   Elko 320012000129 4202 Elko Grammar #2 ES   Regular School No Elementary PK 06 2019   pre_kindergarten 18.0 1.0 11.0               1.0   16.0 15.0                       31 18 1 11               1   16 15                 31
1874978 NV     school 3200060 2   Clark 320006000930 2064 Ellis   Regular School No Elementary PK 05 2019   pre_kindergarten 18.0 2.0 9.0     4.0         7.0   24.0 16.0                       40 18 2 9     4         7   24 16                 40
1875398 NV     school 3200060 2   Clark 320006000383 2127 Treem ES   Regular School No Elementary PK 05 2019   pre_kindergarten 14.0   10.0     1.0         4.0   13.0 16.0                       29 14   10     1         4   13 16                 29
1875701 NV     school 3200060 2   Clark 320006000526 2171 Carl ES   Regular School No Elementary PK 05 2019   pre_kindergarten 27.0 5.0 14.0               4.0   34.0 16.0                       50 27 5 14               4   34 16                 50
1875055 NV     school 3200060 2   Clark 320006000805 2076 Duncan ES   Regular School No Elementary PK 05 2019   pre_kindergarten 15.0 13.0 11.0   1.0           6.0   29.0 17.0                       46 15 13 11   1           6   29 17                 46
1875076 NV     school 3200060 2   Clark 320006000801 2079 Keller ES   Regular School No Elementary PK 05 2019   pre_kindergarten 3.0 6.0 36.0               2.0   30.0 17.0                       47 3 6 36               2   30 17                 47
1875104 NV     school 3200060 2   Clark 320006000758 2083 ORoarke ES   Regular School No Elementary PK 05 2019   pre_kindergarten 32.0 2.0 5.0     1.0         3.0   26.0 17.0                       43 32 2 5     1         3   26 17                 43
1875199 NV     school 3200060 2   Clark 320006000722 2098 Steele ES   Regular School No Elementary PK 05 2019   pre_kindergarten 20.0 8.0 5.0     10.0       1.0 10.0   37.0 17.0                       54 20 8 5     10       1 10   37 17                 54
1875405 NV     school 3200060 2   Clark 320006000401 2128 Rundle   Regular School No Elementary PK 05 2019   pre_kindergarten 4.0 4.0 19.0     1.0             11.0 17.0                       28 4 4 19     1             11 17                 28
1875478 NV     school 3200060 2   Clark 320006000076 2139 Thorpe ES   Regular School No Elementary PK 05 2019   pre_kindergarten 8.0 6.0 16.0     1.0         7.0   21.0 17.0                       38 8 6 16     1         7   21 17                 38
1875499 NV     school 3200060 2   Clark 320006000268 2142 Wiener   Regular School No Elementary PK 05 2019   pre_kindergarten 16.0 1.0 13.0     3.0         2.0   18.0 17.0                       35 16 1 13     3         2   18 17                 35
1875527 NV     school 3200060 2   Clark 320006000272 2146 Newton   Regular School No Elementary PK 05 2019   pre_kindergarten 26.0 3.0 7.0     3.0             22.0 17.0                       39 26 3 7     3             22 17                 39
1876399 NV     school 3200060 2   Clark 320006000587 2273 Hollingsworth ES   Regular School No Elementary PK 05 2019   pre_kindergarten 7.0 5.0 28.0               3.0   26.0 17.0                       43 7 5 28               3   26 17                 43
1876475 NV     school 3200060 2   Clark 320006000510 2284 Smith Hal ES   Regular School No Elementary PK 05 2019   pre_kindergarten 3.0 10.0 18.0     2.0       1.0 5.0   22.0 17.0                       39 3 10 18     2       1 5   22 17                 39
1876482 NV     school 3200060 2   Clark 320006000511 2285 Tarr   Regular School No Elementary PK 05 2019   pre_kindergarten 25.0 1.0 9.0     6.0       1.0 4.0   29.0 17.0                       46 25 1 9     6       1 4   29 17                 46
1876489 NV     school 3200060 2   Clark 320006000512 2286 Staton ES   Regular School No Elementary PK 05 2019   pre_kindergarten 21.0 1.0 11.0   1.0 2.0         5.0   24.0 17.0                       41 21 1 11   1 2         5   24 17                 41
1877524 NV     school 3200270 9   Lincoln 320027000170 9102 Pahranagat Vly ES   Regular School No Elementary PK 05 2019   pre_kindergarten 33.0   1.0                   17.0 17.0                       34 33   1                   17 17                 34
1877600 NV     school 3200300 10   Lyon 320030000704 10206 East Valley   Regular School No Elementary PK 04 2019   pre_kindergarten 16.0   5.0   1.0           4.0   9.0 17.0                       26 16   5   1           4   9 17                 26
1877608 NV     school 3200300 10   Lyon 320030000387 10209 Cottonwood   Regular School No Elementary PK 04 2019   pre_kindergarten 29.0   9.0               3.0   24.0 17.0                       41 29   9               3   24 17                 41
1875034 NV     school 3200060 2   Clark 320006000876 2072 Mathis ES   Regular School No Elementary PK 05 2019   pre_kindergarten 22.0 9.0 8.0   1.0 4.0       1.0 8.0   35.0 18.0                       53 22 9 8   1 4       1 8   35 18                 53
1875185 NV     school 3200060 2   Clark 320006000743 2096 Roundy   Regular School No Elementary PK 05 2019   pre_kindergarten 6.0 6.0 31.0     1.0         1.0   27.0 18.0                       45 6 6 31     1         1   27 18                 45
1875784 NV     school 3200060 2   Clark 320006000552 2183 Walker ES   Regular School No Elementary PK 05 2019   pre_kindergarten 21.0 2.0 12.0               5.0   22.0 18.0                       40 21 2 12               5   22 18                 40
1876179 NV     school 3200060 2   Clark 320006000102 2241 Sunrise Acres ES   Regular School No Elementary PK 05 2019   pre_kindergarten 6.0 9.0 34.0               1.0   32.0 18.0                       50 6 9 34               1   32 18                 50
1876193 NV     school 3200060 2   Clark 320006000105 2243 Twin Lakes ES   Regular School No Elementary PK 05 2019   pre_kindergarten 8.0 6.0 38.0     1.0         1.0   36.0 18.0                       54 8 6 38     1         1   36 18                 54
1876245 NV     school 3200060 2   Clark 320006000019 2251 Sewell   Regular School No Elementary PK 05 2019   pre_kindergarten 17.0 3.0 16.0   1.0           1.0   20.0 18.0                       38 17 3 16   1           1   20 18                 38
1876468 NV     school 3200060 2   Clark 320006000509 2283 Ober   Regular School No Elementary PK 05 2019   pre_kindergarten 28.0 4.0 14.0     5.0         4.0   37.0 18.0                       55 28 4 14     5         4   37 18                 55

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