enrollments

Data source: Big Local News · About: Big Local

580 rows where grade = "grade_7" and state = "NV" sorted by multiracial

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 580 ✖
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
1708600 1708600 NV     school 3200060 2   Clark 320006000756 2364 100 Academy 6-8 MS   Regular School Yes Middle 06 08 2020   grade_7   39.0 9.0     1.0             17.0 32.0                       49   39 9     1             17 32                 49
1708871 1708871 NV     school 3200060 2   Clark 320006000108 2911 Variety School E SEC   Special Education School No High 06 12 2020   grade_7 2.0 3.0 6.0     2.0             12.0 1.0                       13 2 3 6     2             12 1                 13
1708883 1708883 NV     school 3200060 2   Clark 320006000101 2913 Spring Mtn JSHS   Alternative School No High 06 12 2020   grade_7 1.0   1.0                   2.0                         2 1   1                   2                   2
1708925 1708925 NV     school 3200060 2   Clark 320006000499 2928 South Cont JSHS   Alternative School No High 06 12 2020   grade_7 3.0 7.0 5.0                   14.0 1.0                       15 3 7 5                   14 1                 15
1708931 1708931 NV     school 3200060 2   Clark 320006000597 2932 Cowan Behavior   Alternative School No High 06 12 2020   grade_7   4.0 2.0                   4.0 2.0                       6   4 2                   4 2                 6
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
1709066 1709066 NV     school 3200120 4   Elko 320012000139 4111 Ruby Vly ES   Regular School No Elementary KG 08 2020   grade_7 4.0                       1.0 3.0                       4 4                       1 3                 4
1709147 1709147 NV     school 3200120 4   Elko 320012000685 4502 Wells MS JHS   Regular School No Middle 07 08 2020   grade_7 10.0   10.0   2.0 1.0             10.0 13.0                       23 10   10   2 1             10 13                 23
1709154 1709154 NV     school 3200120 4   Elko 320012000692 4505 Jackpot JHS   Regular School No Middle 07 08 2020   grade_7 4.0   10.0                   9.0 5.0                       14 4   10                   9 5                 14
1709156 1709156 NV     school 3200120 4   Elko 320012000684 4506 Owyhee JHS   Regular School No Middle 07 08 2020   grade_7     1.0   27.0               16.0 12.0                       28     1   27               16 12                 28
1709192 1709192 NV     school 3200120 4   Elko 320012000839 4610 NNVVirtual   Regular School No Other KG 12 2020   grade_7 3.0                         3.0                       3 3                         3                 3
1709206 1709206 NV     school 3200150 5   Esmeralda 320015000143 5101 Dyer ES   Regular School No Elementary PK 08 2020   grade_7 3.0   2.0   1.0               2.0 4.0                       6 3   2   1               2 4                 6
1709221 1709221 NV     school 3200150 5   Esmeralda 320015000145 5103 Silver Peak ES   Regular School No Elementary PK 08 2020   grade_7 1.0                         1.0                       1 1                         1                 1
1709240 1709240 NV     school 3200180 6   Eureka 320018000148 6601 Eureka Co   Regular School No High 07 12 2020   grade_7 22.0   4.0                   14.0 12.0                       26 22   4                   14 12                 26
1709248 1709248 NV     school 3200210 7   Humboldt 320021000150 7101 Denio ES   Regular School No Elementary PK 08 2020   grade_7 3.0                       3.0                         3 3                       3                   3
1709255 1709255 NV     school 3200210 7   Humboldt 320021000151 7103 Kings River ES   Regular School No Elementary PK 08 2020   grade_7 1.0   1.0                   2.0                         2 1   1                   2                   2
1709262 1709262 NV     school 3200210 7   Humboldt 320021000155 7104 Orovada ES   Regular School No Elementary PK 08 2020   grade_7 3.0                       2.0 1.0                       3 3                       2 1                 3
1709271 1709271 NV     school 3200210 7   Humboldt 320021000156 7105 Paradise Vly ES   Regular School No Elementary PK 08 2020   grade_7 3.0                       2.0 1.0                       3 3                       2 1                 3
1709301 1709301 NV     school 3200210 7   Humboldt 320021000708 7302 McDermitt JHS   Regular School No Middle 06 08 2020   grade_7 1.0       4.0               1.0 4.0                       5 1       4               1 4                 5
1709445 1709445 NV     school 3200300 10   Lyon 320030000311 10303 Fernley IS   Regular School No Middle 05 08 2020   grade_7 3.0   1.0                   3.0 1.0                       4 3   1                   3 1                 4
1709464 1709464 NV     school 3200300 10   Lyon 320030000178 10602 Smith Valley Sch   Regular School No Other PK 12 2020   grade_7 13.0   3.0                   12.0 4.0                       16 13   3                   12 4                 16
1709582 1709582 NV     school 3200360 12   Nye 320036000871 12211 Warm Springs   Regular School No Elementary PK 08 2020   grade_7 2.0                       2.0                         2 2                       2                   2
1709587 1709587 NV     school 3200360 12   Nye 320036000566 12311 Beatty   Regular School No Middle 06 08 2020   grade_7 3.0   7.0                   5.0 5.0                       10 3   7                   5 5                 10
1709593 1709593 NV     school 3200360 12   Nye 320036000611 12313 Round Mtn   Regular School No Middle 06 08 2020   grade_7 18.0   3.0   2.0 1.0             12.0 12.0                       24 18   3   2 1             12 12                 24
1709596 1709596 NV     school 3200360 12   Nye 320036000575 12315 Gabbs MS   Regular School No Middle 06 08 2020   grade_7 3.0       1.0               2.0 2.0                       4 3       1               2 2                 4
1709599 1709599 NV     school 3200360 12   Nye 320036000564 12316 Amargosa Vly MS   Regular School No Middle 06 08 2020   grade_7 1.0 1.0 7.0                   7.0 2.0                       9 1 1 7                   7 2                 9
1709602 1709602 NV     school 3200360 12   Nye 320036000729 12317 Duckwater MS   Regular School No Middle 06 08 2020   grade_7 1.0       1.0               1.0 1.0                       2 1       1               1 1                 2
1709715 1709715 NV     school 3200420 14   Pershing 320042000167 14301 Pershing MS   Regular School No Middle 06 08 2020   grade_7 27.0 1.0 15.0   6.0               25.0 24.0                       49 27 1 15   6               25 24                 49
1710237 1710237 NV     school 3200480 16   Washoe 320048000318 16309 Incline   Regular School No Middle 06 08 2020   grade_7 27.0   41.0     1.0             35.0 34.0                       69 27   41     1             35 34                 69
1710327 1710327 NV     school 3200480 16   Washoe 320048000217 16601 Gerlach K-12   Regular School No Other PK 12 2020   grade_7 2.0                         2.0                       2 2                         2                 2
1710382 1710382 NV     school 3200480 16   Washoe 320048000233 16911 Picollo Sch   Special Education School No Other PK 12 2020   grade_7 2.0   3.0     1.0             3.0 3.0                       6 2   3     1             3 3                 6
1710396 1710396 NV     school 3200480 16   Washoe 320048000766 16917 Turning Point   Alternative School No Other 02 12 2020   grade_7 1.0                       1.0                         1 1                       1                   1
1710450 1710450 NV     school 3200510 17   White Pine 320051000606 17601 Lund Jr S HS   Regular School No High 06 12 2020   grade_7 7.0                       5.0 2.0                       7 7                       5 2                 7
1710515 1710515 NV     school   46   Democracy Prep   46200 DP Agassi MS             2020   grade_7   70.0 43.0                   54.0 59.0                       113   70 43                   54 59                 113
1710529 1710529 NV     school 3200001 48   Equipo Academy 320000100856 48433 Equipo ACAD   Regular School Yes High 06 12 2020   grade_7 1.0 1.0 106.0     1.0             47.0 62.0                       109 1 1 106     1             47 62                 109
1710594 1710594 NV     school 3200001 54   Learning Bridge 320000100833 54428 Learning Bridge   Regular School Yes Elementary KG 08 2020   grade_7 12.0   7.0             1.0     7.0 13.0                       20 12   7             1     7 13                 20
1710788 1710788 NV     school 3200001 61   Discovery Charter 320000100818 61417 Discovery HillPt   Regular School Yes Elementary KG 08 2020   grade_7 13.0 1.0 2.0                   13.0 3.0                       16 13 1 2                   13 3                 16
1710819 1710819 NV     school 3200001 68   Elko Institute for Academic Achievement 320000100784 68410 EIAA   Regular School Yes Elementary KG 08 2020   grade_7 15.0   7.0                   13.0 9.0                       22 15   7                   13 9                 22
1710873 1710873 NV     school 3200001 86   Nevada Virtual Academy 320000100734 86404 Nevada Virtual ACAD   Regular School Yes Other KG 12 2020   grade_7 77.0 30.0 63.0   3.0 9.0       5.0     98.0 89.0                       187 77 30 63   3 9       5     98 89                 187
1710929 1710929 NV     school   102   NV Prep   102100 NV Prep             2020   grade_7 8.0 11.0 70.0             1.0     41.0 49.0                       90 8 11 70             1     41 49                 90
1876638 1876638 NV     school 3200060 2   Clark 320006000304 2320 Sandy Valley   Regular School No High 06 12 2019   grade_7 14.0 1.0 21.0     1.0       1.0     16.0 22.0                       38 14 1 21     1       1     16 22                 38
1876699 1876699 NV     school 3200060 2   Clark 320006000699 2336 Indian Springs   Regular School No Middle 06 08 2019   grade_7 18.0   10.0   1.0               15.0 14.0                       29 18   10   1               15 14                 29
1877044 1877044 NV     school 3200060 2   Clark 320006000774 2910 Stewart Sch   Special Education School No Other PK 12 2019   grade_7 1.0 1.0 6.0     1.0             6.0 3.0                       9 1 1 6     1             6 3                 9
1877052 1877052 NV     school 3200060 2   Clark 320006000108 2911 Variety School E SEC   Special Education School No High 06 12 2019   grade_7 2.0 3.0 4.0                   6.0 3.0                       9 2 3 4                   6 3                 9
1877060 1877060 NV     school 3200060 2   Clark 320006000020 2912 Juvenile Court   Alternative School No High 06 12 2019   grade_7 1.0   1.0                   2.0                         2 1   1                   2                   2
1877066 1877066 NV     school 3200060 2   Clark 320006000101 2913 Spring Mtn JSHS   Alternative School No High 06 12 2019   grade_7   1.0                     1.0                         1   1                     1                   1
1877099 1877099 NV     school 3200060 2   Clark 320006000683 2927 Desert Willow   Special Education School No High 06 12 2019   grade_7 1.0 2.0                     1.0 2.0                       3 1 2                     1 2                 3
1877118 1877118 NV     school 3200060 2   Clark 320006000598 2933 Peterson Behavior   Alternative School No High 06 12 2019   grade_7   3.0 1.0                   2.0 2.0                       4   3 1                   2 2                 4
1877205 1877205 NV     school 3200090 3   Douglas 320009000348 3503 Jacobsen HS   Alternative School No High 07 12 2019   grade_7 1.0   1.0                   1.0 1.0                       2 1   1                   1 1                 2
1877225 1877225 NV     school 3200120 4   Elko 320012000131 4104 Independence Vly ES   Regular School No Elementary KG 08 2019   grade_7 1.0                         1.0                       1 1                         1                 1
1877237 1877237 NV     school 3200120 4   Elko 320012000134 4108 Mound Vly ES   Regular School No Elementary KG 08 2019   grade_7 1.0                         1.0                       1 1                         1                 1
1877316 1877316 NV     school 3200120 4   Elko 320012000750 4213 Flagview Int Sch   Regular School No Middle 05 08 2019   grade_7 1.0                       1.0                         1 1                       1                   1
1877328 1877328 NV     school 3200120 4   Elko 320012000692 4505 Jackpot JHS   Regular School No Middle 07 08 2019   grade_7     7.0                   5.0 2.0                       7     7                   5 2                 7
1877330 1877330 NV     school 3200120 4   Elko 320012000684 4506 Owyhee JHS   Regular School No Middle 07 08 2019   grade_7     1.0   30.0               15.0 16.0                       31     1   30               15 16                 31
1877332 1877332 NV     school 3200120 4   Elko 320012000728 4507 West Wendover MS   Regular School No Middle 07 08 2019   grade_7 11.0 1.0 70.0   1.0         1.0     46.0 38.0                       84 11 1 70   1         1     46 38                 84
1877371 1877371 NV     school 3200120 4   Elko 320012000839 4610 NNVVirtual   Regular School No Other KG 12 2019   grade_7 5.0       1.0               2.0 4.0                       6 5       1               2 4                 6
1877386 1877386 NV     school 3200150 5   Esmeralda 320015000143 5101 Dyer ES   Regular School No Elementary PK 08 2019   grade_7 1.0   2.0                   3.0                         3 1   2                   3                   3
1877396 1877396 NV     school 3200150 5   Esmeralda 320015000144 5102 Goldfield ES   Regular School No Elementary PK 08 2019   grade_7 1.0                         1.0                       1 1                         1                 1
1877403 1877403 NV     school 3200150 5   Esmeralda 320015000145 5103 Silver Peak ES   Regular School No Elementary PK 08 2019   grade_7 1.0                         1.0                       1 1                         1                 1
1877438 1877438 NV     school 3200210 7   Humboldt 320021000151 7103 Kings River ES   Regular School No Elementary PK 08 2019   grade_7 1.0   2.0                   1.0 2.0                       3 1   2                   1 2                 3
1877446 1877446 NV     school 3200210 7   Humboldt 320021000155 7104 Orovada ES   Regular School No Elementary PK 08 2019   grade_7 1.0   1.0                     2.0                       2 1   1                     2                 2
1877455 1877455 NV     school 3200210 7   Humboldt 320021000156 7105 Paradise Vly ES   Regular School No Elementary PK 08 2019   grade_7 3.0   3.0                   3.0 3.0                       6 3   3                   3 3                 6
1877485 1877485 NV     school 3200210 7   Humboldt 320021000708 7302 McDermitt JHS   Regular School No Middle 06 08 2019   grade_7   1.0     10.0               7.0 4.0                       11   1     10               7 4                 11
1877515 1877515 NV     school 3200240 8   Lander 320024000162 8602 Austin School   Regular School No Other PK 12 2019   grade_7 2.0                       1.0 1.0                       2 2                       1 1                 2
1877552 1877552 NV     school 3200270 9   Lincoln 320027000423 9302 Pahranagat Vly MS   Regular School No Middle 06 08 2019   grade_7 22.0                       10.0 12.0                       22 22                       10 12                 22
1877562 1877562 NV     school 3200270 9   Lincoln 320027000169 9602 C O Bastian   Alternative School No High 07 12 2019   grade_7   1.0                     1.0                         1   1                     1                   1
1877648 1877648 NV     school 3200300 10   Lyon 320030000178 10602 Smith Valley Sch   Regular School No Other PK 12 2019   grade_7 14.0   3.0   1.0         1.0     11.0 8.0                       19 14   3   1         1     11 8                 19
1877777 1877777 NV     school 3200360 12   Nye 320036000566 12311 Beatty   Regular School No Middle 06 08 2019   grade_7 6.0   2.0                   4.0 4.0                       8 6   2                   4 4                 8
1877780 1877780 NV     school 3200360 12   Nye 320036000618 12312 Tonopah   Regular School No Middle 06 08 2019   grade_7 27.0   4.0                   15.0 16.0                       31 27   4                   15 16                 31
1877783 1877783 NV     school 3200360 12   Nye 320036000611 12313 Round Mtn   Regular School No Middle 06 08 2019   grade_7 17.0   6.0   3.0 1.0             16.0 11.0                       27 17   6   3 1             16 11                 27
1877786 1877786 NV     school 3200360 12   Nye 320036000575 12315 Gabbs MS   Regular School No Middle 06 08 2019   grade_7 3.0                         3.0                       3 3                         3                 3
1877789 1877789 NV     school 3200360 12   Nye 320036000564 12316 Amargosa Vly MS   Regular School No Middle 06 08 2019   grade_7 6.0 1.0 15.0                   11.0 11.0                       22 6 1 15                   11 11                 22
1877792 1877792 NV     school 3200360 12   Nye 320036000729 12317 Duckwater MS   Regular School No Middle 06 08 2019   grade_7         1.0               1.0                         1         1               1                   1
1878592 1878592 NV     school 3200480 16   Washoe 320048000233 16911 Picollo Sch   Special Education School No Other PK 12 2019   grade_7 1.0   3.0                   4.0                         4 1   3                   4                   4
1878606 1878606 NV     school 3200480 16   Washoe 320048000766 16917 Turning Point   Alternative School No Other 01 12 2019   grade_7 1.0                         1.0                       1 1                         1                 1
1878618 1878618 NV     school 3200480 16   Washoe 320048000844 16923 North Star   Alternative School No Other PK 12 2019   grade_7 8.0 1.0 2.0     3.0             4.0 10.0                       14 8 1 2     3             4 10                 14
1878659 1878659 NV     school 3200510 17   White Pine 320051000606 17601 Lund Jr S HS   Regular School No High 06 12 2019   grade_7 27.0 13.0 5.0     2.0       1.0     20.0 28.0                       48 27 13 5     2       1     20 28                 48
1878710 1878710 NV     school 3200001 48   Equipo Academy 320000100856 48433 Equipo ACAD   Regular School Yes High 06 12 2019   grade_7 3.0 1.0 109.0                   57.0 56.0                       113 3 1 109                   57 56                 113
1878774 1878774 NV     school 3200001 54   Learning Bridge 320000100833 54428 Learning Bridge   Regular School Yes Elementary KG 08 2019   grade_7 17.0   3.0   1.0               10.0 11.0                       21 17   3   1               10 11                 21
1879043 1879043 NV     school 3200001 86   Nevada Virtual Academy 320000100734 86404 Nevada Virtual ACAD   Regular School Yes Other KG 12 2019   grade_7 79.0 40.0 48.0   3.0 8.0       4.0     90.0 92.0                       182 79 40 48   3 8       4     90 92                 182
1879098 1879098 NV     school 3200021 84   University Schools 320002100680 19406 Davidson Acad   Regular School No High 05 12 2019   grade_7 16.0 1.0       8.0             10.0 15.0                       25 16 1       8             10 15                 25
1841099 1841099 NV     school 3200060 2   Clark County 320006000756 2364 100 Academy 6-8 MS   Regular School Yes Middle 06 08 2021   grade_7 2 34 22   2 0       1 0   35 26   0.0                   61 2 34 22   2 0       1 0   35 26   0             61
1841367 1841367 NV     school 3200060 2   Clark County 320006000774 2910 Stewart ES   Special Education School No Other PK 12 2021   grade_7 1 2 1   0 0       0 0   4 0   0.0                   4 1 2 1   0 0       0 0   4 0   0             4
1841430 1841430 NV     school 3200060 2   Clark County 320006000597 2932 Cowan Behavior   Alternative School No High 06 12 2021   grade_7 1 0 3   0 0       0 0   2 2   0.0                   4 1 0 3   0 0       0 0   2 2   0             4
1841436 1841436 NV     school 3200060 2   Clark County 320006000598 2933 Peterson Behavior   Alternative School No High 06 12 2021   grade_7 0 2 1   0 0       0 0   3 0   0.0                   3 0 2 1   0 0       0 0   3 0   0             3
1841570 1841570 NV     school 3200120 4   Elko 320012000134 4108 Mound Valley ES   Regular School No Elementary KG 07 2021   grade_7 2 0 0   0 0       0 0   0 2   0.0                   2 2 0 0   0 0       0 0   0 2   0             2
1841658 1841658 NV     school 3200120 4   Elko 320012000685 4502 Wells JHS   Regular School No Middle 07 08 2021   grade_7 15 1 7   1 0       0 0   11 13   0.0                   24 15 1 7   1 0       0 0   11 13   0             24
1841667 1841667 NV     school 3200120 4   Elko 320012000684 4506 Owyhee JHS   Regular School No Middle 07 08 2021   grade_7 0 0 0   18 0       0 0   11 7   0.0                   18 0 0 0   18 0       0 0   11 7   0             18
1841669 1841669 NV     school 3200120 4   Elko 320012000728 4507 W Wendover MS   Regular School No Middle 07 08 2021   grade_7 21 1 61   0 0       0 0   49 34   0.0                   83 21 1 61   0 0       0 0   49 34   0             83
1841721 1841721 NV     school 3200150 5   Esmeralda 320015000143 5101 Dyer ES   Regular School No Elementary PK 08 2021   grade_7 1 0 4   2 0       0 0   3 4   0.0                   7 1 0 4   2 0       0 0   3 4   0             7
1841730 1841730 NV     school 3200150 5   Esmeralda 320015000144 5102 Goldfield ES   Regular School No Elementary PK 08 2021   grade_7 5 0 0   0 0       0 0   3 2   0.0                   5 5 0 0   0 0       0 0   3 2   0             5
1841770 1841770 NV     school 3200210 7   Humboldt 320021000151 7103 Kings River ES   Regular School No Elementary PK 08 2021   grade_7 1 0 1   0 0       0 0   1 1   0.0                   2 1 0 1   0 0       0 0   1 1   0             2
1841787 1841787 NV     school 3200210 7   Humboldt 320021000156 7105 Paradise Valley ES   Regular School No Elementary PK 08 2021   grade_7 2 0 2   0 0       0 0   0 4   0.0                   4 2 0 2   0 0       0 0   0 4   0             4
1841817 1841817 NV     school 3200210 7   Humboldt 320021000708 7302 McDermitt JHS   Regular School No Middle 07 08 2021   grade_7 0 0 0   13 0       0 0   7 6   0.0                   13 0 0 0   13 0       0 0   7 6   0             13
1841847 1841847 NV     school 3200240 8   Lander 320024000162 8602 Austin Combined   Regular School No Other 01 12 2021   grade_7 0 0 1   0 0       0 0   0 1   0.0                   1 0 0 1   0 0       0 0   0 1   0             1
1841882 1841882 NV     school 3200270 9   Lincoln 320027000423 9302 Pahranagat Valley MS   Regular School No Middle 06 08 2021   grade_7 20 0 1   0 0       1 0   9 13   0.0                   22 20 0 1   0 0       1 0   9 13   0             22
1841976 1841976 NV     school 3200300 10   Lyon 320030000178 10602 Smith Valley Combined   Regular School No Other PK 12 2021   grade_7 16 0 3   0 0       0 0   12 7   0.0                   19 16 0 3   0 0       0 0   12 7   0             19
1842092 1842092 NV     school 3200360 12   Nye 320036000871 12211 Warm Springs Combined   Regular School No Elementary 01 08 2021   grade_7 1 0 0   0 0       0 0   1 0   0.0                   1 1 0 0   0 0       0 0   1 0   0             1
1842098 1842098 NV     school 3200360 12   Nye 320036000566 12311 Beatty MS   Regular School No Middle 06 08 2021   grade_7 6 0 4   0 0       0 0   4 6   0.0                   10 6 0 4   0 0       0 0   4 6   0             10
1842101 1842101 NV     school 3200360 12   Nye 320036000618 12312 Tonopah MS   Regular School No Middle 06 08 2021   grade_7 12 0 3   0 1       0 0   10 6   0.0                   16 12 0 3   0 1       0 0   10 6   0             16

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