Data source: Big Local News · About: Big Local

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

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
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
1707435 NV     school 3200060 2   Clark 320006000456 2159 Bowler Joseph   Regular School No Elementary PK 05 2020   kindergarten 33.0   46.0     2.0         3.0   44.0 40.0                       84 33   46     2         3   44 40                 84
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
1708256 NV     school 3200060 2   Clark 320006000302 2279 Bowler Grant   Regular School No Elementary PK 05 2020   kindergarten 97.0   7.0               1.0   51.0 54.0                       105 97   7               1   51 54                 105
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
1708967 NV     school 3200090 3   Douglas 320009000121 3201 Gardnerville ES   Regular School No Elementary PK 05 2020   kindergarten 35.0   10.0   1.0 1.0         2.0   28.0 21.0                       49 35   10   1 1         2   28 21                 49
1708982 NV     school 3200090 3   Douglas 320009000293 3205 Meneley ES   Regular School No Elementary PK 05 2020   kindergarten 50.0   11.0   5.0           2.0   39.0 29.0                       68 50   11   5           2   39 29                 68
1708989 NV     school 3200090 3   Douglas 320009000307 3206 Jacks Vly ES   Regular School No Elementary PK 05 2020   kindergarten 37.0   22.0   2.0 1.0         3.0   36.0 29.0                       65 37   22   2 1         3   36 29                 65
1708996 NV     school 3200090 3   Douglas 320009000347 3207 Scarselli ES   Regular School No Elementary PK 05 2020   kindergarten 39.0   7.0               4.0   29.0 21.0                       50 39   7               4   29 21                 50
1709002 NV     school 3200090 3   Douglas 320009000447 3209 Pinon Hills   Regular School No Elementary PK 05 2020   kindergarten 43.0   12.0     1.0         2.0   33.0 25.0                       58 43   12     1         2   33 25                 58
1709008 NV     school 3200090 3   Douglas 320009000448 3210 Minden ES   Regular School No Elementary PK 05 2020   kindergarten 56.0   16.0               3.0   33.0 42.0                       75 56   16               3   33 42                 75
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
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
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
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
1709073 NV     school 3200120 4   Elko 320012000931 4120 Liberty Peak ES   Regular School No Elementary PK 05 2020   kindergarten 75.0   11.0     1.0       1.0 3.0   41.0 50.0                       91 75   11     1       1 3   41 50                 91
1709099 NV     school 3200120 4   Elko 320012000125 4205 Carlin ES   Regular School No Elementary PK 06 2020   kindergarten 24.0   7.0               1.0   17.0 15.0                       32 24   7               1   17 15                 32
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
1709114 NV     school 3200120 4   Elko 320012000141 4207 Wells ES   Regular School No Elementary PK 06 2020   kindergarten 11.0   7.0   1.0         1.0 4.0   12.0 12.0                       24 11   7   1         1 4   12 12                 24
1709121 NV     school 3200120 4   Elko 320012000308 4208 West Wendover ES ES   Regular School No Elementary PK 06 2020   kindergarten 8.0   56.0   1.0           3.0   34.0 34.0                       68 8   56   1           3   34 34                 68
1709134 NV     school 3200120 4   Elko 320012000350 4210 Spring Creek ES   Regular School No Elementary KG 05 2020   kindergarten 47.0   11.0               3.0   31.0 30.0                       61 47   11               3   31 30                 61
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
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
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
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
1709283 NV     school 3200210 7   Humboldt 320021000158 7202 Winnemucca GS   Regular School No Elementary PK 04 2020   kindergarten 36.0   21.0     2.0         2.0   32.0 29.0                       61 36   21     2         2   32 29                 61
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
1709295 NV     school 3200210 7   Humboldt 320021000325 7205 Grass Vly ES   Regular School No Elementary PK 04 2020   kindergarten 50.0   15.0   1.0           2.0   34.0 34.0                       68 50   15   1           2   34 34                 68
1709318 NV     school 3200240 8   Lander 320024000165 8201 Battle Mtn ES   Regular School No Elementary PK 05 2020   kindergarten 62.0   24.0   4.0           4.0   49.0 45.0                       94 62   24   4           4   49 45                 94
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
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
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
1709389 NV     school 3200300 10   Lyon 320030000174 10201 Dayton   Regular School No Elementary PK 06 2020   kindergarten 43.0   20.0     1.0         5.0   37.0 32.0                       69 43   20     1         5   37 32                 69
1709395 NV     school 3200300 10   Lyon 320030000179 10202 Yerington ES   Regular School No Elementary PK 04 2020   kindergarten 37.0   44.0   10.0           10.0   51.0 50.0                       101 37   44   10           10   51 50                 101
1709401 NV     school 3200300 10   Lyon 320030000175 10203 Fernley   Regular School No Elementary PK 04 2020   kindergarten 43.0   17.0   3.0 2.0       2.0 6.0   35.0 38.0                       73 43   17   3 2       2 6   35 38                 73
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
1709421 NV     school 3200300 10   Lyon 320030000387 10209 Cottonwood   Regular School No Elementary PK 04 2020   kindergarten 82.0   24.0   2.0         1.0 10.0   57.0 62.0                       119 82   24   2         1 10   57 62                 119
1709429 NV     school 3200300 10   Lyon 320030000450 10210 Sutro   Regular School No Elementary PK 06 2020   kindergarten 21.0   20.0     1.0         2.0   24.0 20.0                       44 21   20     1         2   24 20                 44
1709437 NV     school 3200300 10   Lyon 320030000746 10211 Riverview   Regular School No Elementary PK 06 2020   kindergarten 40.0   20.0               2.0   27.0 35.0                       62 40   20               2   27 35                 62
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
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
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
1709640 NV     school 3200390 13   Carson 320039000288 13201 Bordewich Bray ES   Regular School No Elementary PK 05 2020   kindergarten 61.0   29.0   6.0         1.0 4.0   53.0 48.0                       101 61   29   6         1 4   53 48                 101
1709655 NV     school 3200390 13   Carson 320039000285 13204 Fremont ES   Regular School No Elementary PK 05 2020   kindergarten 37.0   50.0   1.0           3.0   45.0 46.0                       91 37   50   1           3   45 46                 91
1709677 NV     school 3200390 13   Carson 320039000160 13211 Mark Twain ES   Regular School No Elementary PK 05 2020   kindergarten 35.0   41.0   1.0 1.0         3.0   46.0 35.0                       81 35   41   1 1         3   46 35                 81
1709685 NV     school 3200390 13   Carson 320039000569 13212 Carson Montessori   Regular School Yes Elementary KG 06 2020   kindergarten 38.0   8.0   1.0 3.0         4.0   17.0 37.0                       54 38   8   1 3         4   17 37                 54
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
1709712 NV     school 3200420 14   Pershing 320042000197 14201 Lovelock ES   Regular School No Elementary PK 05 2020   kindergarten 25.0   18.0   5.0           6.0   28.0 26.0                       54 25   18   5           6   28 26                 54
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
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
1709807 NV     school 3200480 16   Washoe 320048000232 16209 Towles ES   Regular School No Elementary PK 06 2020   kindergarten 28.0   16.0     5.0       4.0 5.0   32.0 26.0                       58 28   16     5       4 5   32 26                 58
1709814 NV     school 3200480 16   Washoe 320048000558 16210 Melton   Regular School No Elementary PK 05 2020   kindergarten 49.0   11.0     8.0       1.0 8.0   40.0 37.0                       77 49   11     8       1 8   40 37                 77
1709858 NV     school 3200480 16   Washoe 320048000243 16216 Gomm   Regular School No Elementary PK 06 2020   kindergarten 46.0   5.0     3.0         10.0   41.0 23.0                       64 46   5     3         10   41 23                 64
1709886 NV     school 3200480 16   Washoe 320048000201 16221 Risley ES   Regular School No Elementary PK 06 2020   kindergarten 8.0   64.0     3.0       3.0 2.0   39.0 41.0                       80 8   64     3       3 2   39 41                 80
1709892 NV     school 3200480 16   Washoe 320048000202 16222 Maxwell ES   Regular School No Elementary PK 06 2020   kindergarten 17.0   50.0     1.0         1.0   28.0 41.0                       69 17   50     1         1   28 41                 69
1709899 NV     school 3200480 16   Washoe 320048000214 16223 Drake   Regular School No Elementary PK 06 2020   kindergarten 14.0   22.0               2.0   21.0 17.0                       38 14   22               2   21 17                 38
1709913 NV     school 3200480 16   Washoe 320048000227 16225 Smith Kate ES   Regular School No Elementary PK 05 2020   kindergarten 5.0   25.0   1.0         2.0 1.0   12.0 22.0                       34 5   25   1         2 1   12 22                 34
1709982 NV     school 3200480 16   Washoe 320048000250 16235 Verdi   Regular School No Elementary PK 06 2020   kindergarten 36.0   7.0               3.0   25.0 21.0                       46 36   7               3   25 21                 46
1709989 NV     school 3200480 16   Washoe 320048000234 16237 Natchez ES   Regular School No Elementary PK 06 2020   kindergarten 1.0       21.0           3.0   16.0 9.0                       25 1       21           3   16 9                 25
1710030 NV     school 3200480 16   Washoe 320048000936 16243 Poulakidas ES   Regular School No Elementary PK 06 2020   kindergarten 103.0   23.0   2.0 28.0       1.0 16.0   87.0 86.0                       173 103   23   2 28       1 16   87 86                 173
1710036 NV     school 3200480 16   Washoe 320048000224 16251 Incline ES   Regular School No Elementary PK 05 2020   kindergarten 22.0   20.0   1.0           2.0   27.0 18.0                       45 22   20   1           2   27 18                 45
1710080 NV     school 3200480 16   Washoe 320048000389 16261 Caughlin Ranch   Regular School No Elementary PK 06 2020   kindergarten 58.0   9.0     7.0         5.0   40.0 39.0                       79 58   9     7         5   40 39                 79
1710114 NV     school 3200480 16   Washoe 320048000414 16266 Allen ES   Regular School No Elementary PK 06 2020   kindergarten 26.0   44.0     1.0         4.0   34.0 41.0                       75 26   44     1         4   34 41                 75
1710121 NV     school 3200480 16   Washoe 320048000221 16267 Moss   Regular School No Elementary PK 06 2020   kindergarten 30.0   23.0   1.0 2.0         5.0   32.0 29.0                       61 30   23   1 2         5   32 29                 61
1710136 NV     school 3200480 16   Washoe 320048000427 16269 Spanish Spgs ES   Regular School No Elementary PK 06 2020   kindergarten 84.0   17.0   2.0 2.0         3.0   65.0 43.0                       108 84   17   2 2         3   65 43                 108
1710173 NV     school 3200480 16   Washoe 320048000467 16274 Hunsberger   Regular School No Elementary PK 06 2020   kindergarten 76.0   3.0   1.0 8.0         5.0   48.0 45.0                       93 76   3   1 8         5   48 45                 93
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
1710187 NV     school 3200480 16   Washoe 320048000523 16276 Van Gorder   Regular School No Elementary PK 06 2020   kindergarten 77.0   20.0   1.0 2.0         11.0   57.0 54.0                       111 77   20   1 2         11   57 54                 111
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
1710211 NV     school 3200480 16   Washoe 320048000561 16282 High Desert Monte   Regular School Yes Elementary PK 08 2020   kindergarten 35.0   12.0   2.0 2.0         3.0   25.0 29.0                       54 35   12   2 2         3   25 29                 54
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
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
1710431 NV     school 3200510 17   White Pine 320051000255 17201 Norman ES   Regular School No Elementary PK 05 2020   kindergarten 37.0   16.0   5.0           6.0   28.0 36.0                       64 37   16   5           6   28 36                 64
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
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
1710812 NV     school 3200001 66   Doral Academy Northern Nevada 320000100891 66436 Doral North NV   Regular School Yes Elementary KG 08 2020   kindergarten 69.0   15.0   1.0 2.0         10.0   47.0 50.0                       97 69   15   1 2         10   47 50                 97
1710821 NV     school 3200001 68   Elko Institute for Academic Achievement 320000100784 68410 EIAA   Regular School Yes Elementary KG 08 2020   kindergarten 17.0   3.0               2.0   14.0 8.0                       22 17   3               2   14 8                 22
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

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