Data source: Big Local News · About: Big Local

14,695 rows where state = "NV" sorted by disability

View and edit SQL

grade

year

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
1709322 NV     school 3200240 8   Lander 320024000866 8302 Lemaire Jr High   Regular School No Middle 06 08 2020   grade_8 43.0 1.0 20.0   3.0           1.0   33.0 35.0                       68 43 1 20   3           1   33 35                 68
1709323 NV     school 3200240 8   Lander 320024000163 8601 Battle Mtn HS   Regular School No High 09 12 2020   grade_9 49.0   20.0   1.0               35.0 35.0                       70 49   20   1               35 35                 70
1709324 NV     school 3200240 8   Lander 320024000163 8601 Battle Mtn HS   Regular School No High 09 12 2020   grade_10 51.0   23.0   5.0         1.0 1.0   47.0 34.0                       81 51   23   5         1 1   47 34                 81
1709325 NV     school 3200240 8   Lander 320024000163 8601 Battle Mtn HS   Regular School No High 09 12 2020   grade_11 40.0 1.0 23.0   3.0           1.0   39.0 29.0                       68 40 1 23   3           1   39 29                 68
1709326 NV     school 3200240 8   Lander 320024000163 8601 Battle Mtn HS   Regular School No High 09 12 2020   grade_12 32.0   20.0   3.0               26.0 29.0                       55 32   20   3               26 29                 55
1709327 NV     school 3200240 8   Lander 320024000163 8601 Battle Mtn HS   Regular School No High 09 12 2020   ungraded 2.0                       2.0                         2 2                       2                   2
1709328 NV     school 3200240 8   Lander 320024000162 8602 Austin School   Regular School No Other PK 12 2020   grade_1 1.0                       1.0                         1 1                       1                   1
1709329 NV     school 3200240 8   Lander 320024000162 8602 Austin School   Regular School No Other PK 12 2020   grade_2 1.0                         1.0                       1 1                         1                 1
1709330 NV     school 3200240 8   Lander 320024000162 8602 Austin School   Regular School No Other PK 12 2020   grade_6     1.0                     1.0                       1     1                     1                 1
1709331 NV     school 3200240 8   Lander 320024000162 8602 Austin School   Regular School No Other PK 12 2020   grade_8 2.0                       1.0 1.0                       2 2                       1 1                 2
1709332 NV     school 3200240 8   Lander 320024000162 8602 Austin School   Regular School No Other PK 12 2020   grade_11     1.0                     1.0                       1     1                     1                 1
1709333 NV     school 3200270 9   Lincoln 320027000170 9102 Pahranagat Vly ES   Regular School No Elementary PK 05 2020   grade_1 21.0   1.0               1.0   11.0 12.0                       23 21   1               1   11 12                 23
1709334 NV     school 3200270 9   Lincoln 320027000170 9102 Pahranagat Vly ES   Regular School No Elementary PK 05 2020   grade_2 20.0   4.0                   13.0 11.0                       24 20   4                   13 11                 24
1709335 NV     school 3200270 9   Lincoln 320027000170 9102 Pahranagat Vly ES   Regular School No Elementary PK 05 2020   grade_3 13.0                   1.0   7.0 7.0                       14 13                   1   7 7                 14
1709336 NV     school 3200270 9   Lincoln 320027000170 9102 Pahranagat Vly ES   Regular School No Elementary PK 05 2020   grade_4 15.0                 1.0 1.0   11.0 6.0                       17 15                 1 1   11 6                 17
1709337 NV     school 3200270 9   Lincoln 320027000170 9102 Pahranagat Vly ES   Regular School No Elementary PK 05 2020   grade_5 21.0   2.0                   8.0 15.0                       23 21   2                   8 15                 23
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
1709339 NV     school 3200270 9   Lincoln 320027000170 9102 Pahranagat Vly ES   Regular School No Elementary PK 05 2020   pre_kindergarten 34.0   5.0                   18.0 21.0                       39 34   5                   18 21                 39
1709340 NV     school 3200270 9   Lincoln 320027000166 9201 Caliente ES   Regular School No Elementary PK 06 2020   grade_1 11.0                       4.0 7.0                       11 11                       4 7                 11
1709341 NV     school 3200270 9   Lincoln 320027000166 9201 Caliente ES   Regular School No Elementary PK 06 2020   grade_2 5.0   1.0                   5.0 1.0                       6 5   1                   5 1                 6
1709342 NV     school 3200270 9   Lincoln 320027000166 9201 Caliente ES   Regular School No Elementary PK 06 2020   grade_3 9.0   2.0                   4.0 7.0                       11 9   2                   4 7                 11
1709343 NV     school 3200270 9   Lincoln 320027000166 9201 Caliente ES   Regular School No Elementary PK 06 2020   grade_4 11.0   1.0               1.0   5.0 8.0                       13 11   1               1   5 8                 13
1709344 NV     school 3200270 9   Lincoln 320027000166 9201 Caliente ES   Regular School No Elementary PK 06 2020   grade_5 6.0   1.0   1.0               5.0 3.0                       8 6   1   1               5 3                 8
1709345 NV     school 3200270 9   Lincoln 320027000166 9201 Caliente ES   Regular School No Elementary PK 06 2020   grade_6 12.0   1.0               1.0   10.0 4.0                       14 12   1               1   10 4                 14
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
1709347 NV     school 3200270 9   Lincoln 320027000166 9201 Caliente ES   Regular School No Elementary PK 06 2020   pre_kindergarten 10.0   5.0                   8.0 7.0                       15 10   5                   8 7                 15
1709348 NV     school 3200270 9   Lincoln 320027000172 9202 Panaca ES   Regular School No Elementary PK 06 2020   grade_1 19.0                       10.0 9.0                       19 19                       10 9                 19
1709349 NV     school 3200270 9   Lincoln 320027000172 9202 Panaca ES   Regular School No Elementary PK 06 2020   grade_2 15.0   2.0               1.0   8.0 10.0                       18 15   2               1   8 10                 18
1709350 NV     school 3200270 9   Lincoln 320027000172 9202 Panaca ES   Regular School No Elementary PK 06 2020   grade_3 17.0   4.0                   13.0 8.0                       21 17   4                   13 8                 21
1709351 NV     school 3200270 9   Lincoln 320027000172 9202 Panaca ES   Regular School No Elementary PK 06 2020   grade_4 12.0   2.0               2.0   6.0 10.0                       16 12   2               2   6 10                 16
1709352 NV     school 3200270 9   Lincoln 320027000172 9202 Panaca ES   Regular School No Elementary PK 06 2020   grade_5 19.0   1.0               2.0   11.0 11.0                       22 19   1               2   11 11                 22
1709353 NV     school 3200270 9   Lincoln 320027000172 9202 Panaca ES   Regular School No Elementary PK 06 2020   grade_6 9.0   4.0                   7.0 6.0                       13 9   4                   7 6                 13
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
1709355 NV     school 3200270 9   Lincoln 320027000172 9202 Panaca ES   Regular School No Elementary PK 06 2020   pre_kindergarten 37.0   2.0               1.0   19.0 21.0                       40 37   2               1   19 21                 40
1709356 NV     school 3200270 9   Lincoln 320027000173 9203 Pioche ES   Regular School No Elementary PK 06 2020   grade_1 6.0   1.0                   3.0 4.0                       7 6   1                   3 4                 7
1709357 NV     school 3200270 9   Lincoln 320027000173 9203 Pioche ES   Regular School No Elementary PK 06 2020   grade_2 6.0   1.0                   3.0 4.0                       7 6   1                   3 4                 7
1709358 NV     school 3200270 9   Lincoln 320027000173 9203 Pioche ES   Regular School No Elementary PK 06 2020   grade_3 7.0   2.0                   6.0 3.0                       9 7   2                   6 3                 9
1709359 NV     school 3200270 9   Lincoln 320027000173 9203 Pioche ES   Regular School No Elementary PK 06 2020   grade_4 13.0   1.0                   3.0 11.0                       14 13   1                   3 11                 14
1709360 NV     school 3200270 9   Lincoln 320027000173 9203 Pioche ES   Regular School No Elementary PK 06 2020   grade_5 8.0                       3.0 5.0                       8 8                       3 5                 8
1709361 NV     school 3200270 9   Lincoln 320027000173 9203 Pioche ES   Regular School No Elementary PK 06 2020   grade_6 10.0                       1.0 9.0                       10 10                       1 9                 10
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
1709363 NV     school 3200270 9   Lincoln 320027000173 9203 Pioche ES   Regular School No Elementary PK 06 2020   pre_kindergarten 8.0                       4.0 4.0                       8 8                       4 4                 8
1709364 NV     school 3200270 9   Lincoln 320027000410 9301 Meadow Vly MS   Regular School No Middle 07 08 2020   grade_7 33.0 1.0 2.0               1.0   17.0 20.0                       37 33 1 2               1   17 20                 37
1709365 NV     school 3200270 9   Lincoln 320027000410 9301 Meadow Vly MS   Regular School No Middle 07 08 2020   grade_8 30.0   3.0               2.0   20.0 15.0                       35 30   3               2   20 15                 35
1709366 NV     school 3200270 9   Lincoln 320027000423 9302 Pahranagat Vly MS   Regular School No Middle 06 08 2020   grade_6 21.0   1.0                   9.0 13.0                       22 21   1                   9 13                 22
1709367 NV     school 3200270 9   Lincoln 320027000423 9302 Pahranagat Vly MS   Regular School No Middle 06 08 2020   grade_7 17.0   2.0               1.0   12.0 8.0                       20 17   2               1   12 8                 20
1709368 NV     school 3200270 9   Lincoln 320027000423 9302 Pahranagat Vly MS   Regular School No Middle 06 08 2020   grade_8 18.0   1.0                   9.0 10.0                       19 18   1                   9 10                 19
1709369 NV     school 3200270 9   Lincoln 320027000168 9501 Lincoln Co HS   Regular School No High 09 12 2020   grade_9 29.0 1.0 4.0   1.0               18.0 17.0                       35 29 1 4   1               18 17                 35
1709370 NV     school 3200270 9   Lincoln 320027000168 9501 Lincoln Co HS   Regular School No High 09 12 2020   grade_10 34.0   5.0   1.0 1.0             17.0 24.0                       41 34   5   1 1             17 24                 41
1709371 NV     school 3200270 9   Lincoln 320027000168 9501 Lincoln Co HS   Regular School No High 09 12 2020   grade_11 24.0   4.0     2.0         2.0   16.0 16.0                       32 24   4     2         2   16 16                 32
1709372 NV     school 3200270 9   Lincoln 320027000168 9501 Lincoln Co HS   Regular School No High 09 12 2020   grade_12 31.0   5.0                   22.0 14.0                       36 31   5                   22 14                 36
1709373 NV     school 3200270 9   Lincoln 320027000171 9601 Pahranagat Vly HS   Regular School No High 09 12 2020   grade_9 17.0 1.0 3.0             2.0     14.0 9.0                       23 17 1 3             2     14 9                 23
1709374 NV     school 3200270 9   Lincoln 320027000171 9601 Pahranagat Vly HS   Regular School No High 09 12 2020   grade_10 24.0   3.0             2.0     19.0 10.0                       29 24   3             2     19 10                 29
1709375 NV     school 3200270 9   Lincoln 320027000171 9601 Pahranagat Vly HS   Regular School No High 09 12 2020   grade_11 30.0   3.0     3.0             21.0 15.0                       36 30   3     3             21 15                 36
1709376 NV     school 3200270 9   Lincoln 320027000171 9601 Pahranagat Vly HS   Regular School No High 09 12 2020   grade_12 21.0                   1.0   10.0 12.0                       22 21                   1   10 12                 22
1709377 NV     school 3200270 9   Lincoln 320027000169 9602 C O Bastian   Alternative School No High 07 12 2020   grade_8   1.0                     1.0                         1   1                     1                   1
1709378 NV     school 3200270 9   Lincoln 320027000169 9602 C O Bastian   Alternative School No High 07 12 2020   grade_9   9.0 2.0             1.0     6.0 6.0                       12   9 2             1     6 6                 12
1709379 NV     school 3200270 9   Lincoln 320027000169 9602 C O Bastian   Alternative School No High 07 12 2020   grade_10 6.0 7.0 4.0                   14.0 3.0                       17 6 7 4                   14 3                 17
1709380 NV     school 3200270 9   Lincoln 320027000169 9602 C O Bastian   Alternative School No High 07 12 2020   grade_11 8.0 5.0 8.0               1.0   12.0 10.0                       22 8 5 8               1   12 10                 22
1709381 NV     school 3200270 9   Lincoln 320027000169 9602 C O Bastian   Alternative School No High 07 12 2020   grade_12 7.0 6.0 8.0     1.0         2.0   15.0 9.0                       24 7 6 8     1         2   15 9                 24
1709382 NV     school 3200270 9   Lincoln 320027000865 9603 Lincoln AD   Alternative School No Adult Education AE AE 2020   adult 20.0   6.0               1.0   12.0 15.0                       27 20   6               1   12 15                 27
1709383 NV     school 3200300 10   Lyon 320030000174 10201 Dayton   Regular School No Elementary PK 06 2020   grade_1 38.0   13.0     1.0       2.0 4.0   34.0 24.0                       58 38   13     1       2 4   34 24                 58
1709384 NV     school 3200300 10   Lyon 320030000174 10201 Dayton   Regular School No Elementary PK 06 2020   grade_2 49.0   17.0   1.0 1.0         4.0   42.0 30.0                       72 49   17   1 1         4   42 30                 72
1709385 NV     school 3200300 10   Lyon 320030000174 10201 Dayton   Regular School No Elementary PK 06 2020   grade_3 49.0   11.0   2.0 3.0         3.0   35.0 33.0                       68 49   11   2 3         3   35 33                 68
1709386 NV     school 3200300 10   Lyon 320030000174 10201 Dayton   Regular School No Elementary PK 06 2020   grade_4 36.0   17.0   2.0 3.0         4.0   33.0 29.0                       62 36   17   2 3         4   33 29                 62
1709387 NV     school 3200300 10   Lyon 320030000174 10201 Dayton   Regular School No Elementary PK 06 2020   grade_5 44.0 2.0 18.0   2.0           1.0   33.0 34.0                       67 44 2 18   2           1   33 34                 67
1709388 NV     school 3200300 10   Lyon 320030000174 10201 Dayton   Regular School No Elementary PK 06 2020   grade_6 45.0   13.0   2.0           1.0   38.0 23.0                       61 45   13   2           1   38 23                 61
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
1709390 NV     school 3200300 10   Lyon 320030000174 10201 Dayton   Regular School No Elementary PK 06 2020   pre_kindergarten 14.0   6.0     1.0             11.0 10.0                       21 14   6     1             11 10                 21
1709391 NV     school 3200300 10   Lyon 320030000179 10202 Yerington ES   Regular School No Elementary PK 04 2020   grade_1 48.0   31.0   1.0 1.0         7.0   46.0 42.0                       88 48   31   1 1         7   46 42                 88
1709392 NV     school 3200300 10   Lyon 320030000179 10202 Yerington ES   Regular School No Elementary PK 04 2020   grade_2 40.0   40.0   8.0           8.0   51.0 45.0                       96 40   40   8           8   51 45                 96
1709393 NV     school 3200300 10   Lyon 320030000179 10202 Yerington ES   Regular School No Elementary PK 04 2020   grade_3 42.0   34.0   12.0 1.0         5.0   49.0 45.0                       94 42   34   12 1         5   49 45                 94
1709394 NV     school 3200300 10   Lyon 320030000179 10202 Yerington ES   Regular School No Elementary PK 04 2020   grade_4 48.0   36.0   10.0           10.0   53.0 51.0                       104 48   36   10           10   53 51                 104
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
1709396 NV     school 3200300 10   Lyon 320030000179 10202 Yerington ES   Regular School No Elementary PK 04 2020   pre_kindergarten 28.0   29.0   4.0           4.0   36.0 29.0                       65 28   29   4           4   36 29                 65
1709397 NV     school 3200300 10   Lyon 320030000175 10203 Fernley   Regular School No Elementary PK 04 2020   grade_1 58.0 4.0 18.0   3.0 3.0         11.0   50.0 47.0                       97 58 4 18   3 3         11   50 47                 97
1709398 NV     school 3200300 10   Lyon 320030000175 10203 Fernley   Regular School No Elementary PK 04 2020   grade_2 58.0 1.0 19.0   4.0 2.0       3.0 7.0   50.0 44.0                       94 58 1 19   4 2       3 7   50 44                 94
1709399 NV     school 3200300 10   Lyon 320030000175 10203 Fernley   Regular School No Elementary PK 04 2020   grade_3 48.0 3.0 24.0   1.0         1.0 9.0   40.0 46.0                       86 48 3 24   1         1 9   40 46                 86
1709400 NV     school 3200300 10   Lyon 320030000175 10203 Fernley   Regular School No Elementary PK 04 2020   grade_4 53.0   32.0   2.0 1.0         7.0   52.0 43.0                       95 53   32   2 1         7   52 43                 95
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
1709402 NV     school 3200300 10   Lyon 320030000175 10203 Fernley   Regular School No Elementary PK 04 2020   pre_kindergarten 20.0   15.0     1.0         2.0   20.0 18.0                       38 20   15     1         2   20 18                 38
1709403 NV     school 3200300 10   Lyon 320030000299 10205 SilverSprings ES   Regular School No Elementary PK 04 2020   grade_1 60.0 1.0 11.0               7.0   46.0 33.0                       79 60 1 11               7   46 33                 79
1709404 NV     school 3200300 10   Lyon 320030000299 10205 SilverSprings ES   Regular School No Elementary PK 04 2020   grade_2 43.0 1.0 5.0             1.0 4.0   32.0 22.0                       54 43 1 5             1 4   32 22                 54
1709405 NV     school 3200300 10   Lyon 320030000299 10205 SilverSprings ES   Regular School No Elementary PK 04 2020   grade_3 59.0 3.0 12.0   1.0 1.0         4.0   34.0 46.0                       80 59 3 12   1 1         4   34 46                 80
1709406 NV     school 3200300 10   Lyon 320030000299 10205 SilverSprings ES   Regular School No Elementary PK 04 2020   grade_4 56.0   12.0   1.0         1.0 3.0   44.0 29.0                       73 56   12   1         1 3   44 29                 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
1709408 NV     school 3200300 10   Lyon 320030000299 10205 SilverSprings ES   Regular School No Elementary PK 04 2020   pre_kindergarten 23.0   1.0               2.0   17.0 9.0                       26 23   1               2   17 9                 26
1709409 NV     school 3200300 10   Lyon 320030000704 10206 East Valley   Regular School No Elementary PK 04 2020   grade_1 78.0 1.0 30.0   1.0         1.0 14.0   70.0 55.0                       125 78 1 30   1         1 14   70 55                 125
1709410 NV     school 3200300 10   Lyon 320030000704 10206 East Valley   Regular School No Elementary PK 04 2020   grade_2 61.0 1.0 16.0   2.0         1.0 10.0   48.0 43.0                       91 61 1 16   2         1 10   48 43                 91
1709411 NV     school 3200300 10   Lyon 320030000704 10206 East Valley   Regular School No Elementary PK 04 2020   grade_3 62.0   23.0   1.0 1.0       2.0 6.0   47.0 48.0                       95 62   23   1 1       2 6   47 48                 95
1709412 NV     school 3200300 10   Lyon 320030000704 10206 East Valley   Regular School No Elementary PK 04 2020   grade_4 68.0 2.0 18.0   1.0 1.0         8.0   50.0 48.0                       98 68 2 18   1 1         8   50 48                 98
1709413 NV     school 3200300 10   Lyon 320030000704 10206 East Valley   Regular School No Elementary PK 04 2020   kindergarten 65.0 1.0 20.0   3.0 1.0         7.0   41.0 56.0                       97 65 1 20   3 1         7   41 56                 97
1709414 NV     school 3200300 10   Lyon 320030000704 10206 East Valley   Regular School No Elementary PK 04 2020   pre_kindergarten 16.0   3.0               2.0   8.0 13.0                       21 16   3               2   8 13                 21
1709415 NV     school 3200300 10   Lyon 320030000386 10208 Dayton   Regular School No Middle 07 08 2020   grade_7 165.0 3.0 58.0   3.0         1.0 16.0   118.0 128.0                       246 165 3 58   3         1 16   118 128                 246
1709416 NV     school 3200300 10   Lyon 320030000386 10208 Dayton   Regular School No Middle 07 08 2020   grade_8 104.0 1.0 46.0   3.0 3.0       3.0 2.0   89.0 73.0                       162 104 1 46   3 3       3 2   89 73                 162
1709417 NV     school 3200300 10   Lyon 320030000387 10209 Cottonwood   Regular School No Elementary PK 04 2020   grade_1 82.0 1.0 28.0   3.0 1.0       1.0 7.0   65.0 58.0                       123 82 1 28   3 1       1 7   65 58                 123
1709418 NV     school 3200300 10   Lyon 320030000387 10209 Cottonwood   Regular School No Elementary PK 04 2020   grade_2 73.0 1.0 25.0   1.0 2.0         6.0   55.0 53.0                       108 73 1 25   1 2         6   55 53                 108
1709419 NV     school 3200300 10   Lyon 320030000387 10209 Cottonwood   Regular School No Elementary PK 04 2020   grade_3 74.0 1.0 50.0   5.0 3.0         7.0   66.0 74.0                       140 74 1 50   5 3         7   66 74                 140
1709420 NV     school 3200300 10   Lyon 320030000387 10209 Cottonwood   Regular School No Elementary PK 04 2020   grade_4 77.0 1.0 27.0   3.0 2.0         2.0   55.0 57.0                       112 77 1 27   3 2         2   55 57                 112
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

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