Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • kindergarten · 1,248
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
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
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
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
1707044 NV     school 3200060 2   Clark 320006000037 2102 Goodsprings   Regular School No Elementary PK 05 2020   kindergarten 3.0 1.0                 1.0   2.0 3.0                       5 3 1                 1   2 3                 5
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
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
1709067 NV     school 3200120 4   Elko 320012000139 4111 Ruby Vly ES   Regular School No Elementary KG 08 2020   kindergarten 2.0                   1.0   2.0 1.0                       3 2                   1   2 1                 3
1709518 NV     school 3200360 12   Nye 320036000188 12101 Duckwater ES   Regular School No Elementary PK 05 2020   kindergarten 1.0                   1.0   2.0                         2 1                   1   2                   2
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
1839538 NV     school 3200060 2   Clark County 320006000010 2101 Blue Diamond ES   Regular School No Elementary PK 05 2021   kindergarten 5 0 0   0 0       0 0   2 3   0.0                   5 5 0 0   0 0       0 0   2 3   0             5
1841723 NV     school 3200150 5   Esmeralda 320015000143 5101 Dyer ES   Regular School No Elementary PK 08 2021   kindergarten 1 0 8   0 0       0 1   2 8   0.0                   10 1 0 8   0 0       0 1   2 8   0             10
1842926 NV     school 3200510 17   White Pine 320051000720 17101 Lund ES   Regular School No Elementary KG 05 2021   kindergarten 8 0 0   0 0       0 0   2 6   0.0                   8 8 0 0   0 0       0 0   2 6   0             8
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
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
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
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
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
1707038 NV     school 3200060 2   Clark 320006000010 2101 Blue Diamond   Regular School No Elementary PK 05 2020   kindergarten 3.0 1.0 1.0               1.0   3.0 3.0                       6 3 1 1               1   3 3                 6
1709053 NV     school 3200120 4   Elko 320012000132 4105 Jackpot ES   Regular School No Elementary KG 06 2020   kindergarten 2.0   7.0               1.0   3.0 7.0                       10 2   7               1   3 7                 10
1709216 NV     school 3200150 5   Esmeralda 320015000144 5102 Goldfield ES   Regular School No Elementary PK 08 2020   kindergarten 3.0                   1.0   3.0 1.0                       4 3                   1   3 1                 4
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
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
1840332 NV     school 3200060 2   Clark County 320006000384 2215 Miller John ES   Special Education School No Other PK 12 2021   kindergarten 4 0 0   0 0       0 0   3 1   0.0                   4 4 0 0   0 0       0 0   3 1   0             4
1841781 NV     school 3200210 7   Humboldt 320021000155 7104 Orovada ES   Regular School No Elementary PK 08 2021   kindergarten 5 0 2   0 0       0 0   3 4   0.0                   7 5 0 2   0 0       0 0   3 4   0             7
1841789 NV     school 3200210 7   Humboldt 320021000156 7105 Paradise Valley ES   Regular School No Elementary PK 08 2021   kindergarten 2 0 1   0 0       0 0   3 0   0.0                   3 2 0 1   0 0       0 0   3 0   0             3
1841877 NV     school 3200270 9   Lincoln 320027000173 9203 Pioche ES   Regular School No Elementary PK 06 2021   kindergarten 7 0 0   0 0       0 0   3 4   0.0                   7 7 0 0   0 0       0 0   3 4   0             7
1842017 NV     school 3200330 11   Mineral 320033000184 11202 Schurz ES   Regular School No Elementary PK 06 2021   kindergarten 0 0 0   14 0       0 1   3 12   0.0                   15 0 0 0   14 0       0 1   3 12   0             15
1842219 NV     school 3200420 14   Pershing 320042000196 14101 Imlay ES   Regular School No Elementary PK 05 2021   kindergarten 2 0 0   0 0       0 2   3 1   0.0                   4 2 0 0   0 0       0 2   3 1   0             4
1842249 NV     school 3200450 15   Storey 320045000413 15102 Hillside ES   Regular School No Elementary PK 05 2021   kindergarten 6 0 2   0 0       0 0   3 5   0.0                   8 6 0 2   0 0       0 0   3 5   0             8
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
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
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
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
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
1709556 NV     school 3200360 12   Nye 320036000186 12201 Beatty   Regular School No Elementary PK 05 2020   kindergarten 6.0   1.0   2.0           1.0   4.0 6.0                       10 6   1   2           1   4 6                 10
1709706 NV     school 3200420 14   Pershing 320042000196 14101 Imlay ES   Regular School No Elementary PK 05 2020   kindergarten 7.0   1.0               1.0   4.0 5.0                       9 7   1               1   4 5                 9
1839553 NV     school 3200060 2   Clark County 320006000099 2104 Reid ES   Regular School No Elementary PK 05 2021   kindergarten 3 0 2   0 0       0 1   4 2   0.0                   6 3 0 2   0 0       0 1   4 2   0             6
1841748 NV     school 3200180 6   Eureka 320018000146 6101 Crescent Valley ES   Regular School No Elementary PK 06 2021   kindergarten 8 0 0   0 0       0 0   4 4   0.0                   8 8 0 0   0 0       0 0   4 4   0             8
1841861 NV     school 3200270 9   Lincoln 320027000166 9201 Caliente ES   Regular School No Elementary PK 06 2021   kindergarten 6 0 2   0 0       0 0   4 4   0.0                   8 6 0 2   0 0       0 0   4 4   0             8
1842065 NV     school 3200360 12   Nye 320036000186 12201 Beatty ES   Regular School No Elementary PK 05 2021   kindergarten 4 0 3   1 0       0 3   4 7   0.0                   11 4 0 3   1 0       0 3   4 7   0             11
1842494 NV     school 3200480 16   Washoe County 320048000234 16237 Natchez ES   Regular School No Elementary PK 06 2021   kindergarten 1 0 0   12 0       0 1   4 10   0.0                   14 1 0 0   12 0       0 1   4 10   0             14
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
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
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
1710422 NV     school 3200510 17   White Pine 320051000720 17101 Lund ES   Regular School No Elementary KG 05 2020   kindergarten 10.0   2.0               1.0   5.0 8.0                       13 10   2               1   5 8                 13
1840568 NV     school 3200060 2   Clark County 320006000577 2252 Indian Springs ES   Regular School No Elementary PK 05 2021   kindergarten 7 0 3   0 0       0 1   5 6   0.0                   11 7 0 3   0 0       0 1   5 6   0             11
1841564 NV     school 3200120 4   Elko 320012000132 4105 Jackpot ES   Regular School No Elementary KG 06 2021   kindergarten 6 0 4   0 0       0 0   5 5   0.0                   10 6 0 4   0 0       0 0   5 5   0             10
1841618 NV     school 3200120 4   Elko 320012000727 4206 Owyhee ES   Regular School No Elementary PK 06 2021   kindergarten 0 0 0   11 0       0 0   5 6   0.0                   11 0 0 0   11 0       0 0   5 6   0             11
1842040 NV     school 3200360 12   Nye 320036000193 12103 Round Mtn ES   Regular School No Elementary PK 05 2021   kindergarten 9 1 3   0 0       0 1   5 9   0.0                   14 9 1 3   0 0       0 1   5 9   0             14
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
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
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
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
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
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
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
1708068 NV     school 3200060 2   Clark 320006000577 2252 Indian Springs   Regular School No Elementary PK 05 2020   kindergarten 6.0 1.0 3.0               2.0   6.0 6.0                       12 6 1 3               2   6 6                 12
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
1840833 NV     school 3200060 2   Clark County 320006000612 2291 Sandy Valley ES   Regular School No Elementary PK 05 2021   kindergarten 4 1 5   1 1       1 0   6 7   0.0                   13 4 1 5   1 1       1 0   6 7   0             13
1841853 NV     school 3200270 9   Lincoln 320027000170 9102 Pahranagat Valley ES   Regular School No Elementary PK 05 2021   kindergarten 13 0 2   0 0       0 1   6 10   0.0                   16 13 0 2   0 0       0 1   6 10   0             16
1841982 NV     school 3200300 10   Lyon 320030000178 10602 Smith Valley Combined   Regular School No Other PK 12 2021   kindergarten 12 0 1   0 0       0 0   6 7   0.0                   13 12 0 1   0 0       0 0   6 7   0             13
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
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
1841806 NV     school 3200210 7   Humboldt 320021000153 7203 McDermitt ES   Regular School No Elementary PK 06 2021   kindergarten 1 0 1   6 0       0 0   7 1   0.0                   8 1 0 1   6 0       0 0   7 1   0             8
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
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
1707125 NV     school 3200060 2   Clark 320006000359 2114 Perkins Ute ES   Regular School No Elementary PK 05 2020   kindergarten 13.0   4.0   5.0           2.0   8.0 16.0                       24 13   4   5           2   8 16                 24
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
1710781 NV     school 3200001 61   Discovery Charter 320000100885 61415 Discovery Mesa   Regular School Yes Elementary KG 08 2020   kindergarten 4.0 2.0 11.0     1.0         1.0   8.0 11.0                       19 4 2 11     1         1   8 11                 19
1842943 NV     school 3200510 17   White Pine 320051000263 17203 McGill ES   Regular School No Elementary PK 05 2021   kindergarten 13 0 0   0 0       1 2   8 8   0.0                   16 13 0 0   0 0       1 2   8 8   0             16
1875048 NV     school 3200060 2   Clark 320006000814 2075 Northwest CTA ES   Regular School No Elementary KG KG 2019   kindergarten 6.0 6.0 2.0     2.0         4.0   8.0 12.0                       20 6 6 2     2         4   8 12                 20
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
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
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
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
1709543 NV     school 3200360 12   Nye 320036000185 12106 Amargosa Vly ES   Regular School No Elementary PK 05 2020   kindergarten 3.0 1.0 13.0               1.0   9.0 9.0                       18 3 1 13               1   9 9                 18
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
1843114 NV     school 3200001 54   Learning Bridge 320000100833 54428 Learning Bridge   Regular School Yes Elementary KG 08 2021   kindergarten 17 0 3   0 0       0 1   9 12   0.0                   21 17 0 3   0 0       0 1   9 12   0             21
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
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
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
1709238 NV     school 3200180 6   Eureka 320018000147 6103 Eureka   Regular School No Elementary PK 06 2020   kindergarten 19.0   3.0               3.0   10.0 15.0                       25 19   3               3   10 15                 25
1709354 NV     school 3200270 9   Lincoln 320027000172 9202 Panaca ES   Regular School No Elementary PK 06 2020   kindergarten 19.0   1.0               2.0   10.0 12.0                       22 19   1               2   10 12                 22
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
1709727 NV     school 3200450 15   Storey 320045000200 15101 Gallagher ES   Regular School No Elementary PK 05 2020   kindergarten 26.0   1.0   1.0           1.0   10.0 19.0                       29 26   1   1           1   10 19                 29
1710596 NV     school 3200001 54   Learning Bridge 320000100833 54428 Learning Bridge   Regular School Yes Elementary KG 08 2020   kindergarten 13.0   5.0               2.0   10.0 10.0                       20 13   5               2   10 10                 20
1841869 NV     school 3200270 9   Lincoln 320027000172 9202 Panaca ES   Regular School No Elementary PK 06 2021   kindergarten 17 0 1   0 0       0 2   10 10   0.0                   20 17 0 1   0 0       0 2   10 10   0             20
1842697 NV     school 3200480 16   Washoe County 320048000544 16278 Bailey CH ES   Regular School Yes Elementary KG 06 2021   kindergarten 1 1 19   0 1       1 0   10 13   0.0                   23 1 1 19   0 1       1 0   10 13   0             23
1843172 NV     school 3200001 57   Honors Academy of Literature 320000100826 57424 Honors ACAD   Regular School Yes Elementary KG 08 2021   kindergarten 14 1 7   0 0       0 0   10 12   0.0                   22 14 1 7   0 0       0 0   10 12   0             22
1843337 NV     school 3200001 68   Elko Institute for Academic Achievement 320000100784 68410 Elko Institute   Regular School Yes Elementary KG 08 2021   kindergarten 17 0 3   1 1       0 1   10 13   0.0                   23 17 0 3   1 1       0 1   10 13   0             23
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
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
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
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
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
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
1710654 NV     school 3200001 57   Honors Academy of Literature 320000100826 57424 Honors ACAD   Regular School Yes Elementary KG 08 2020   kindergarten 14.0   6.0     1.0         2.0   11.0 12.0                       23 14   6     1         2   11 12                 23

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