enrollments

Data source: Big Local News · About: Big Local

4,895 rows where state = "NV" and year = 2020 sorted by black

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 4,795 ✖
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
1708913 1708913 NV     school 3200060 2   Clark 320006000328 2923 Global Community   Alternative School No High 09 12 2020   grade_12     43.0     4.0             22.0 25.0                       47     43     4             22 25                 47
1708914 1708914 NV     school 3200060 2   Clark 320006000328 2923 Global Community   Alternative School No High 09 12 2020   ungraded 2.0   10.0                   9.0 3.0                       12 2   10                   9 3                 12
1708918 1708918 NV     school 3200060 2   Clark 320006000683 2927 Desert Willow   Special Education School No High 06 12 2020   grade_7                     2.0   1.0 1.0                       2                     2   1 1                 2
1708921 1708921 NV     school 3200060 2   Clark 320006000683 2927 Desert Willow   Special Education School No High 06 12 2020   grade_10     1.0               1.0   1.0 1.0                       2     1               1   1 1                 2
1708922 1708922 NV     school 3200060 2   Clark 320006000683 2927 Desert Willow   Special Education School No High 06 12 2020   grade_11 1.0                   1.0   1.0 1.0                       2 1                   1   1 1                 2
1708923 1708923 NV     school 3200060 2   Clark 320006000683 2927 Desert Willow   Special Education School No High 06 12 2020   grade_12 2.0                       2.0                         2 2                       2                   2
1708943 1708943 NV     school 3200060 2   Clark 320006000598 2933 Peterson Behavior   Alternative School No High 06 12 2020   grade_12 1.0   2.0     1.0         1.0   5.0                         5 1   2     1         1   5                   5
1708944 1708944 NV     school 3200060 2   Clark 320006000598 2933 Peterson Behavior   Alternative School No High 06 12 2020   ungraded     1.0                   1.0                         1     1                   1                   1
1708945 1708945 NV     school 3200060 2   Clark 320006000619 2935 Variety School ES   Special Education School No Elementary PK 05 2020   grade_1 1.0   1.0                   1.0 1.0                       2 1   1                   1 1                 2
1708947 1708947 NV     school 3200060 2   Clark 320006000619 2935 Variety School ES   Special Education School No Elementary PK 05 2020   grade_3 1.0                         1.0                       1 1                         1                 1
1708951 1708951 NV     school 3200060 2   Clark 320006000795 2941 Adult Ed   Alternative School No Adult Education AE AE 2020   grade_12     1.0                   1.0                         1     1                   1                   1
1708953 1708953 NV     school 3200060 2   Clark 320006000767 2955 Desert Rose ALT   Alternative School No High 09 12 2020   grade_9     1.0                   1.0                         1     1                   1                   1
1708957 1708957 NV     school 3200060 2   Clark 320006000878 2957 Mission HS   Alternative School No High 06 12 2020   grade_9 2.0   2.0                   2.0 2.0                       4 2   2                   2 2                 4
1708958 1708958 NV     school 3200060 2   Clark 320006000878 2957 Mission HS   Alternative School No High 06 12 2020   grade_10 3.0   2.0                   2.0 3.0                       5 3   2                   2 3                 5
1708961 1708961 NV     school 3200060 2   Clark 320006000878 2957 Mission HS   Alternative School No High 06 12 2020   ungraded     1.0                   1.0                         1     1                   1                   1
1708962 1708962 NV     school 3200090 3   Douglas 320009000121 3201 Gardnerville ES   Regular School No Elementary PK 05 2020   grade_1 44.0   15.0   1.0 1.0         3.0   21.0 43.0                       64 44   15   1 1         3   21 43                 64
1708963 1708963 NV     school 3200090 3   Douglas 320009000121 3201 Gardnerville ES   Regular School No Elementary PK 05 2020   grade_2 38.0   19.0   2.0 2.0         3.0   34.0 30.0                       64 38   19   2 2         3   34 30                 64
1708965 1708965 NV     school 3200090 3   Douglas 320009000121 3201 Gardnerville ES   Regular School No Elementary PK 05 2020   grade_4 40.0   16.0   1.0 2.0         3.0   25.0 37.0                       62 40   16   1 2         3   25 37                 62
1708966 1708966 NV     school 3200090 3   Douglas 320009000121 3201 Gardnerville ES   Regular School No Elementary PK 05 2020   grade_5 38.0   22.0     1.0         5.0   40.0 26.0                       66 38   22     1         5   40 26                 66
1708967 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
1708968 1708968 NV     school 3200090 3   Douglas 320009000121 3201 Gardnerville ES   Regular School No Elementary PK 05 2020   pre_kindergarten 9.0   5.0               2.0   12.0 4.0                       16 9   5               2   12 4                 16
1708969 1708969 NV     school 3200090 3   Douglas 320009000124 3202 Zephyr Cove   Regular School No Elementary PK 06 2020   grade_1 8.0                   2.0   2.0 8.0                       10 8                   2   2 8                 10
1708970 1708970 NV     school 3200090 3   Douglas 320009000124 3202 Zephyr Cove   Regular School No Elementary PK 06 2020   grade_2 13.0   4.0             1.0     10.0 8.0                       18 13   4             1     10 8                 18
1708971 1708971 NV     school 3200090 3   Douglas 320009000124 3202 Zephyr Cove   Regular School No Elementary PK 06 2020   grade_3 21.0   8.0               1.0   13.0 17.0                       30 21   8               1   13 17                 30
1708972 1708972 NV     school 3200090 3   Douglas 320009000124 3202 Zephyr Cove   Regular School No Elementary PK 06 2020   grade_4 11.0   5.0     1.0         2.0   8.0 11.0                       19 11   5     1         2   8 11                 19
1708973 1708973 NV     school 3200090 3   Douglas 320009000124 3202 Zephyr Cove   Regular School No Elementary PK 06 2020   grade_5 18.0   8.0               3.0   14.0 15.0                       29 18   8               3   14 15                 29
1708974 1708974 NV     school 3200090 3   Douglas 320009000124 3202 Zephyr Cove   Regular School No Elementary PK 06 2020   grade_6 13.0   4.0               1.0   13.0 5.0                       18 13   4               1   13 5                 18
1708976 1708976 NV     school 3200090 3   Douglas 320009000124 3202 Zephyr Cove   Regular School No Elementary PK 06 2020   pre_kindergarten 2.0                   1.0   2.0 1.0                       3 2                   1   2 1                 3
1708977 1708977 NV     school 3200090 3   Douglas 320009000293 3205 Meneley ES   Regular School No Elementary PK 05 2020   grade_1 33.0   9.0   4.0 1.0         6.0   24.0 29.0                       53 33   9   4 1         6   24 29                 53
1708978 1708978 NV     school 3200090 3   Douglas 320009000293 3205 Meneley ES   Regular School No Elementary PK 05 2020   grade_2 44.0   23.0   8.0           6.0   46.0 35.0                       81 44   23   8           6   46 35                 81
1708980 1708980 NV     school 3200090 3   Douglas 320009000293 3205 Meneley ES   Regular School No Elementary PK 05 2020   grade_4 48.0   21.0   14.0           3.0   44.0 42.0                       86 48   21   14           3   44 42                 86
1708981 1708981 NV     school 3200090 3   Douglas 320009000293 3205 Meneley ES   Regular School No Elementary PK 05 2020   grade_5 40.0   11.0   7.0           7.0   37.0 28.0                       65 40   11   7           7   37 28                 65
1708982 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
1708983 1708983 NV     school 3200090 3   Douglas 320009000293 3205 Meneley ES   Regular School No Elementary PK 05 2020   pre_kindergarten 35.0   8.0   3.0           3.0   27.0 22.0                       49 35   8   3           3   27 22                 49
1708984 1708984 NV     school 3200090 3   Douglas 320009000307 3206 Jacks Vly ES   Regular School No Elementary PK 05 2020   grade_1 30.0   23.0   1.0 3.0         4.0   32.0 29.0                       61 30   23   1 3         4   32 29                 61
1708985 1708985 NV     school 3200090 3   Douglas 320009000307 3206 Jacks Vly ES   Regular School No Elementary PK 05 2020   grade_2 31.0   15.0   1.0 2.0         9.0   30.0 28.0                       58 31   15   1 2         9   30 28                 58
1708986 1708986 NV     school 3200090 3   Douglas 320009000307 3206 Jacks Vly ES   Regular School No Elementary PK 05 2020   grade_3 36.0   21.0     2.0       1.0 2.0   30.0 32.0                       62 36   21     2       1 2   30 32                 62
1708987 1708987 NV     school 3200090 3   Douglas 320009000307 3206 Jacks Vly ES   Regular School No Elementary PK 05 2020   grade_4 44.0   25.0   3.0 1.0         5.0   43.0 35.0                       78 44   25   3 1         5   43 35                 78
1708988 1708988 NV     school 3200090 3   Douglas 320009000307 3206 Jacks Vly ES   Regular School No Elementary PK 05 2020   grade_5 36.0   23.0   1.0 2.0       1.0 5.0   30.0 38.0                       68 36   23   1 2       1 5   30 38                 68
1708989 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
1708990 1708990 NV     school 3200090 3   Douglas 320009000307 3206 Jacks Vly ES   Regular School No Elementary PK 05 2020   pre_kindergarten 36.0   7.0     1.0         5.0   28.0 21.0                       49 36   7     1         5   28 21                 49
1708991 1708991 NV     school 3200090 3   Douglas 320009000347 3207 Scarselli ES   Regular School No Elementary PK 05 2020   grade_1 49.0   15.0   1.0 1.0         6.0   35.0 37.0                       72 49   15   1 1         6   35 37                 72
1708992 1708992 NV     school 3200090 3   Douglas 320009000347 3207 Scarselli ES   Regular School No Elementary PK 05 2020   grade_2 49.0   18.0   1.0           7.0   47.0 28.0                       75 49   18   1           7   47 28                 75
1708994 1708994 NV     school 3200090 3   Douglas 320009000347 3207 Scarselli ES   Regular School No Elementary PK 05 2020   grade_4 46.0   16.0   2.0           6.0   37.0 33.0                       70 46   16   2           6   37 33                 70
1708995 1708995 NV     school 3200090 3   Douglas 320009000347 3207 Scarselli ES   Regular School No Elementary PK 05 2020   grade_5 53.0   11.0   2.0         1.0     41.0 26.0                       67 53   11   2         1     41 26                 67
1708996 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
1708997 1708997 NV     school 3200090 3   Douglas 320009000447 3209 Pinon Hills   Regular School No Elementary PK 05 2020   grade_1 39.0   7.0     1.0         1.0   27.0 21.0                       48 39   7     1         1   27 21                 48
1708998 1708998 NV     school 3200090 3   Douglas 320009000447 3209 Pinon Hills   Regular School No Elementary PK 05 2020   grade_2 35.0   5.0               2.0   19.0 23.0                       42 35   5               2   19 23                 42
1708999 1708999 NV     school 3200090 3   Douglas 320009000447 3209 Pinon Hills   Regular School No Elementary PK 05 2020   grade_3 35.0   10.0               1.0   22.0 24.0                       46 35   10               1   22 24                 46
1709000 1709000 NV     school 3200090 3   Douglas 320009000447 3209 Pinon Hills   Regular School No Elementary PK 05 2020   grade_4 37.0   1.0   1.0           5.0   22.0 22.0                       44 37   1   1           5   22 22                 44
1709002 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
1709003 1709003 NV     school 3200090 3   Douglas 320009000448 3210 Minden ES   Regular School No Elementary PK 05 2020   grade_1 38.0   16.0               4.0   30.0 28.0                       58 38   16               4   30 28                 58
1709004 1709004 NV     school 3200090 3   Douglas 320009000448 3210 Minden ES   Regular School No Elementary PK 05 2020   grade_2 51.0   6.0     1.0         4.0   40.0 22.0                       62 51   6     1         4   40 22                 62
1709005 1709005 NV     school 3200090 3   Douglas 320009000448 3210 Minden ES   Regular School No Elementary PK 05 2020   grade_3 40.0   5.0   1.0 1.0             28.0 19.0                       47 40   5   1 1             28 19                 47
1709006 1709006 NV     school 3200090 3   Douglas 320009000448 3210 Minden ES   Regular School No Elementary PK 05 2020   grade_4 60.0   13.0     1.0         2.0   33.0 43.0                       76 60   13     1         2   33 43                 76
1709007 1709007 NV     school 3200090 3   Douglas 320009000448 3210 Minden ES   Regular School No Elementary PK 05 2020   grade_5 58.0   18.0     1.0         1.0   44.0 34.0                       78 58   18     1         1   44 34                 78
1709008 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
1709009 1709009 NV     school 3200090 3   Douglas 320009000448 3210 Minden ES   Regular School No Elementary PK 05 2020   pre_kindergarten 1.0   17.0     2.0         1.0   8.0 13.0                       21 1   17     2         1   8 13                 21
1709013 1709013 NV     school 3200090 3   Douglas 320009000422 3302 Pau Wa Lu   Regular School No Middle 06 08 2020   grade_6 123.0   46.0   9.0         1.0 11.0   99.0 91.0                       190 123   46   9         1 11   99 91                 190
1709015 1709015 NV     school 3200090 3   Douglas 320009000422 3302 Pau Wa Lu   Regular School No Middle 06 08 2020   grade_8 120.0   55.0   12.0           13.0   108.0 92.0                       200 120   55   12           13   108 92                 200
1709017 1709017 NV     school 3200090 3   Douglas 320009000120 3501 Douglas HS   Regular School No High 09 12 2020   grade_10 276.0   97.0   12.0 6.0       1.0 34.0   232.0 194.0                       426 276   97   12 6       1 34   232 194                 426
1709020 1709020 NV     school 3200090 3   Douglas 320009000120 3501 Douglas HS   Regular School No High 09 12 2020   ungraded 6.0   2.0   1.0               6.0 3.0                       9 6   2   1               6 3                 9
1709021 1709021 NV     school 3200090 3   Douglas 320009000122 3502 Whittell   Regular School No High 07 12 2020   grade_7 17.0   6.0               2.0   12.0 13.0                       25 17   6               2   12 13                 25
1709022 1709022 NV     school 3200090 3   Douglas 320009000122 3502 Whittell   Regular School No High 07 12 2020   grade_8 15.0   5.0               2.0   13.0 9.0                       22 15   5               2   13 9                 22
1709023 1709023 NV     school 3200090 3   Douglas 320009000122 3502 Whittell   Regular School No High 07 12 2020   grade_9 21.0   5.0   1.0 1.0         1.0   13.0 16.0                       29 21   5   1 1         1   13 16                 29
1709024 1709024 NV     school 3200090 3   Douglas 320009000122 3502 Whittell   Regular School No High 07 12 2020   grade_10 12.0   2.0     1.0         3.0   12.0 6.0                       18 12   2     1         3   12 6                 18
1709026 1709026 NV     school 3200090 3   Douglas 320009000122 3502 Whittell   Regular School No High 07 12 2020   grade_12 16.0   7.0                   13.0 10.0                       23 16   7                   13 10                 23
1709027 1709027 NV     school 3200090 3   Douglas 320009000348 3503 Jacobsen HS   Alternative School No High 07 12 2020   grade_8     1.0                   1.0                         1     1                   1                   1
1709030 1709030 NV     school 3200090 3   Douglas 320009000348 3503 Jacobsen HS   Alternative School No High 07 12 2020   grade_11 4.0   3.0   1.0         2.0     9.0 1.0                       10 4   3   1         2     9 1                 10
1709031 1709031 NV     school 3200090 3   Douglas 320009000348 3503 Jacobsen HS   Alternative School No High 07 12 2020   grade_12 1.0   3.0   3.0               4.0 3.0                       7 1   3   3               4 3                 7
1709032 1709032 NV     school 3200090 3   Douglas 320009000832 3504 ASPIRE HS   Alternative School No High 09 12 2020   grade_9 4.0   1.0   1.0               4.0 2.0                       6 4   1   1               4 2                 6
1709033 1709033 NV     school 3200090 3   Douglas 320009000832 3504 ASPIRE HS   Alternative School No High 09 12 2020   grade_10 13.0   3.0   1.0 1.0         1.0   14.0 5.0                       19 13   3   1 1         1   14 5                 19
1709034 1709034 NV     school 3200090 3   Douglas 320009000832 3504 ASPIRE HS   Alternative School No High 09 12 2020   grade_11 22.0   7.0   3.0           1.0   22.0 11.0                       33 22   7   3           1   22 11                 33
1709035 1709035 NV     school 3200090 3   Douglas 320009000832 3504 ASPIRE HS   Alternative School No High 09 12 2020   grade_12 17.0   9.0   1.0           1.0   17.0 11.0                       28 17   9   1           1   17 11                 28
1709036 1709036 NV     school 3200090 3   Douglas 320009000764 3901 Douglas ALT ALT   Alternative School No Other 04 12 2020   grade_8 3.0                       2.0 1.0                       3 3                       2 1                 3
1709037 1709037 NV     school 3200090 3   Douglas 320009000764 3901 Douglas ALT ALT   Alternative School No Other 04 12 2020   grade_9     1.0                   1.0                         1     1                   1                   1
1709038 1709038 NV     school 3200090 3   Douglas 320009000764 3901 Douglas ALT ALT   Alternative School No Other 04 12 2020   grade_10 1.0                       1.0                         1 1                       1                   1
1709039 1709039 NV     school 3200090 3   Douglas 320009000764 3901 Douglas ALT ALT   Alternative School No Other 04 12 2020   grade_11 1.0                       1.0                         1 1                       1                   1
1709040 1709040 NV     school 3200090 3   Douglas 320009000861 3903 Douglas Adult   Alternative School No Adult Education AE AE 2020   adult 1.0                       1.0                         1 1                       1                   1
1709041 1709041 NV     school 3200120 4   Elko 320012000131 4104 Independence Vly ES   Regular School No Elementary KG 08 2020   grade_2 2.0                       2.0                         2 2                       2                   2
1709042 1709042 NV     school 3200120 4   Elko 320012000131 4104 Independence Vly ES   Regular School No Elementary KG 08 2020   grade_4 1.0                         1.0                       1 1                         1                 1
1709043 1709043 NV     school 3200120 4   Elko 320012000131 4104 Independence Vly ES   Regular School No Elementary KG 08 2020   grade_5     1.0                     1.0                       1     1                     1                 1
1709044 1709044 NV     school 3200120 4   Elko 320012000131 4104 Independence Vly ES   Regular School No Elementary KG 08 2020   grade_7 1.0   2.0                   2.0 1.0                       3 1   2                   2 1                 3
1709045 1709045 NV     school 3200120 4   Elko 320012000131 4104 Independence Vly ES   Regular School No Elementary KG 08 2020   grade_8 1.0                         1.0                       1 1                         1                 1
1709046 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
1709047 1709047 NV     school 3200120 4   Elko 320012000132 4105 Jackpot ES   Regular School No Elementary KG 06 2020   grade_1 4.0   7.0                   5.0 6.0                       11 4   7                   5 6                 11
1709048 1709048 NV     school 3200120 4   Elko 320012000132 4105 Jackpot ES   Regular School No Elementary KG 06 2020   grade_2 3.0   3.0                   4.0 2.0                       6 3   3                   4 2                 6
1709049 1709049 NV     school 3200120 4   Elko 320012000132 4105 Jackpot ES   Regular School No Elementary KG 06 2020   grade_3 2.0   4.0             1.0 3.0   5.0 5.0                       10 2   4             1 3   5 5                 10
1709050 1709050 NV     school 3200120 4   Elko 320012000132 4105 Jackpot ES   Regular School No Elementary KG 06 2020   grade_4 1.0   5.0                   5.0 1.0                       6 1   5                   5 1                 6
1709051 1709051 NV     school 3200120 4   Elko 320012000132 4105 Jackpot ES   Regular School No Elementary KG 06 2020   grade_5 6.0   7.0                   6.0 7.0                       13 6   7                   6 7                 13
1709052 1709052 NV     school 3200120 4   Elko 320012000132 4105 Jackpot ES   Regular School No Elementary KG 06 2020   grade_6 3.0   9.0             1.0 1.0   7.0 7.0                       14 3   9             1 1   7 7                 14
1709053 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
1709054 1709054 NV     school 3200120 4   Elko 320012000134 4108 Mound Vly ES   Regular School No Elementary KG 08 2020   grade_1 1.0                         1.0                       1 1                         1                 1
1709055 1709055 NV     school 3200120 4   Elko 320012000134 4108 Mound Vly ES   Regular School No Elementary KG 08 2020   grade_3 1.0   1.0                   2.0                         2 1   1                   2                   2
1709056 1709056 NV     school 3200120 4   Elko 320012000134 4108 Mound Vly ES   Regular School No Elementary KG 08 2020   grade_4 2.0                       2.0                         2 2                       2                   2
1709057 1709057 NV     school 3200120 4   Elko 320012000134 4108 Mound Vly ES   Regular School No Elementary KG 08 2020   grade_5 1.0                         1.0                       1 1                         1                 1
1709058 1709058 NV     school 3200120 4   Elko 320012000134 4108 Mound Vly ES   Regular School No Elementary KG 08 2020   grade_6 3.0                         3.0                       3 3                         3                 3
1709059 1709059 NV     school 3200120 4   Elko 320012000134 4108 Mound Vly ES   Regular School No Elementary KG 08 2020   grade_8 1.0                         1.0                       1 1                         1                 1
1709060 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
1709061 1709061 NV     school 3200120 4   Elko 320012000139 4111 Ruby Vly ES   Regular School No Elementary KG 08 2020   grade_1 2.0                       2.0                         2 2                       2                   2

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