enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
1708410 1708410 NV     school 3200060 2   Clark 320006000051 2305 Smith MS   Regular School No Middle 06 08 2020   grade_7 8.0 20.0 278.0   2.0           2.0   147.0 163.0                       310 8 20 278   2           2   147 163                 310
1708492 1708492 NV     school 3200060 2   Clark 320006000275 2329 Lyon   Regular School No Middle 06 08 2020   grade_7 95.0 2.0 27.0   4.0           2.0   61.0 69.0                       130 95 2 27   4           2   61 69                 130
1708518 1708518 NV     school 3200060 2   Clark 320006000699 2336 Indian Springs   Regular School No Middle 06 08 2020   grade_7 16.0   3.0   1.0           1.0   10.0 11.0                       21 16   3   1           1   10 11                 21
1708593 1708593 NV     school 3200060 2   Clark 320006000749 2363 Innovations SEC   Regular School Yes High 06 12 2020   grade_7 6.0 8.0 54.0             1.0 5.0   38.0 36.0                       74 6 8 54             1 5   38 36                 74
1708603 1708603 NV     school 3200060 2   Clark 320006000855 2367 RainbowDreamAC MS   Regular School Yes Middle 06 08 2020   grade_7   29.0 6.0             1.0 4.0   13.0 27.0                       40   29 6             1 4   13 27                 40
1708831 1708831 NV     school 3200060 2   Clark 320006000745 2621 Delta Charter   Regular School Yes High 06 12 2020   grade_7 4.0 23.0 12.0   1.0         1.0 3.0   24.0 20.0                       44 4 23 12   1         1 3   24 20                 44
1708848 1708848 NV     school 3200060 2   Clark 320006000845 2625 NV LRN Academy   Regular School No High 06 12 2020   grade_7 4.0 3.0 2.0             1.0 2.0   6.0 6.0                       12 4 3 2             1 2   6 6                 12
1708863 1708863 NV     school 3200060 2   Clark 320006000774 2910 Stewart Sch   Special Education School No Other PK 12 2020   grade_7 5.0 2.0 3.0               1.0   6.0 5.0                       11 5 2 3               1   6 5                 11
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
1708891 1708891 NV     school 3200060 2   Clark 320006000694 2916 Miley Achvmt SEC   Special Education School No High 06 12 2020   grade_7 4.0 3.0 2.0               1.0   9.0 1.0                       10 4 3 2               1   9 1                 10
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
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
1708938 1708938 NV     school 3200060 2   Clark 320006000598 2933 Peterson Behavior   Alternative School No High 06 12 2020   grade_7 1.0 3.0                 1.0   5.0                         5 1 3                 1   5                   5
1709014 1709014 NV     school 3200090 3   Douglas 320009000422 3302 Pau Wa Lu   Regular School No Middle 06 08 2020   grade_7 110.0 1.0 36.0   8.0           16.0   93.0 78.0                       171 110 1 36   8           16   93 78                 171
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
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
1709145 1709145 NV     school 3200120 4   Elko 320012000674 4501 Carlin JHS   Regular School No Middle 07 08 2020   grade_7 23.0   3.0   1.0         1.0 1.0   13.0 16.0                       29 23   3   1         1 1   13 16                 29
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
1709158 1709158 NV     school 3200120 4   Elko 320012000728 4507 West Wendover MS   Regular School No Middle 07 08 2020   grade_7 20.0   54.0   2.0           2.0   35.0 43.0                       78 20   54   2           2   35 43                 78
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
1709214 1709214 NV     school 3200150 5   Esmeralda 320015000144 5102 Goldfield ES   Regular School No Elementary PK 08 2020   grade_7 6.0                   1.0   3.0 4.0                       7 6                   1   3 4                 7
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
1709321 1709321 NV     school 3200240 8   Lander 320024000866 8302 Lemaire Jr High   Regular School No Middle 06 08 2020   grade_7 38.0   30.0   4.0           1.0   35.0 38.0                       73 38   30   4           1   35 38                 73
1709364 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
1709367 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
1709415 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
1709441 1709441 NV     school 3200300 10   Lyon 320030000312 10302 Yerington   Regular School No Middle 05 08 2020   grade_7 47.0 1.0 45.0   8.0         1.0 7.0   51.0 58.0                       109 47 1 45   8         1 7   51 58                 109
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
1709449 1709449 NV     school 3200300 10   Lyon 320030000424 10304 Silver Stage MS   Regular School No Middle 05 08 2020   grade_7 56.0 1.0 9.0               8.0   41.0 33.0                       74 56 1 9               8   41 33                 74
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
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
1709629 1709629 NV     school 3200360 12   Nye 320036000556 12607 Pathways MS ALT   Alternative School No Middle 06 08 2020   grade_7 3.0 2.0 6.0   2.0         1.0 1.0   8.0 7.0                       15 3 2 6   2         1 1   8 7                 15
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
1709737 1709737 NV     school 3200450 15   Storey 320045000365 15301 Virginia City MS   Regular School No Middle 06 08 2020   grade_7 29.0   6.0             1.0 3.0   17.0 22.0                       39 29   6             1 3   17 22                 39
1710300 1710300 NV     school 3200480 16   Washoe 320048000822 16507 Inspire   Alternative School No Other PK 12 2020   grade_7 1.0                   1.0   1.0 1.0                       2 1                   1   1 1                 2
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
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
1710442 1710442 NV     school 3200510 17   White Pine 320051000256 17301 White Pine MS   Regular School No Middle 06 08 2020   grade_7 67.0 1.0 18.0   2.0           6.0   49.0 45.0                       94 67 1 18   2           6   49 45                 94
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
1710506 1710506 NV     school 3200001 44   Mater Academy Northern Nevada 320000100896 44437 Mater North NV   Regular School Yes Elementary KG 08 2020   grade_7 1.0 4.0 15.0               1.0   9.0 12.0                       21 1 4 15               1   9 12                 21
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
1710541 1710541 NV     school 3200001 49   Mater Academy 320000100851 49432 Mater MT Vista ACAD   Regular School Yes Elementary PK 08 2020   grade_7 7.0 9.0 109.0               2.0   65.0 62.0                       127 7 9 109               2   65 62                 127
1710551 1710551 NV     school 3200001 49   Mater Academy 320000100902 49433 Mater Bonanza ACAD   Regular School Yes Elementary PK 08 2020   grade_7 11.0 14.0 96.0             1.0 2.0   65.0 59.0                       124 11 14 96             1 2   65 59                 124
1710582 1710582 NV     school 3200001 52   Leadership Academy of Nevada 320000100886 52429 Leadership ACAD   Regular School Yes High 06 12 2020   grade_7 24.0 4.0 15.0               2.0   20.0 25.0                       45 24 4 15               2   20 25                 45
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
1710652 1710652 NV     school 3200001 57   Honors Academy of Literature 320000100826 57424 Honors ACAD   Regular School Yes Elementary KG 08 2020   grade_7 17.0 1.0 2.0             1.0 1.0   13.0 9.0                       22 17 1 2             1 1   13 9                 22
1710779 1710779 NV     school 3200001 61   Discovery Charter 320000100885 61415 Discovery Mesa   Regular School Yes Elementary KG 08 2020   grade_7 1.0 1.0 3.0             1.0 1.0   5.0 2.0                       7 1 1 3             1 1   5 2                 7
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
1710797 1710797 NV     school 3200001 65   Oasis Academy 320000100817 65414 Oasis ACAD   Regular School Yes Other KG 12 2020   grade_7 41.0   4.0   2.0           1.0   28.0 20.0                       48 41   4   2           1   28 20                 48
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
1710828 1710828 NV     school 3200001 72   Quest Academy 320000100759 72416 Quest Northwest   Regular School Yes Elementary KG 08 2020   grade_7 3.0 24.0 14.0               2.0   21.0 22.0                       43 3 24 14               2   21 22                 43
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
1876008 1876008 NV     school 3200060 2   Clark 320006000384 2215 Miller Sch   Special Education School No Other PK 12 2019   grade_7 1.0 1.0 3.0               1.0   3.0 3.0                       6 1 1 3               1   3 3                 6
1876645 1876645 NV     school 3200060 2   Clark 320006000408 2321 Laughlin JSHS   Regular School No High 06 12 2019   grade_7 28.0 6.0 31.0               3.0   34.0 34.0                       68 28 6 31               3   34 34                 68
1876673 1876673 NV     school 3200060 2   Clark 320006000275 2329 Lyon   Regular School No Middle 06 08 2019   grade_7 109.0   25.0   3.0         1.0 3.0   67.0 74.0                       141 109   25   3         1 3   67 74                 141
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
1876781 1876781 NV     school 3200060 2   Clark 320006000756 2364 100 Academy 6-8 MS   Regular School Yes Middle 06 08 2019   grade_7 1.0 37.0 10.0               3.0   25.0 26.0                       51 1 37 10               3   25 26                 51
1876784 1876784 NV     school 3200060 2   Clark 320006000855 2367 RainbowDreamAC MS   Regular School Yes Middle 06 08 2019   grade_7   13.0 4.0               2.0   10.0 9.0                       19   13 4               2   10 9                 19
1877012 1877012 NV     school 3200060 2   Clark 320006000745 2621 Delta Charter   Regular School Yes High 06 12 2019   grade_7 9.0 16.0 15.0               4.0   24.0 20.0                       44 9 16 15               4   24 20                 44
1877029 1877029 NV     school 3200060 2   Clark 320006000845 2625 NV LRN Academy   Regular School No High 06 12 2019   grade_7 3.0 1.0 6.0               2.0   7.0 5.0                       12 3 1 6               2   7 5                 12
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
1877074 1877074 NV     school 3200060 2   Clark 320006000694 2916 Miley Achvmt SEC   Special Education School No High 06 12 2019   grade_7 2.0 9.0 1.0               1.0   13.0                         13 2 9 1               1   13                   13
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
1877105 1877105 NV     school 3200060 2   Clark 320006000499 2928 South Cont JSHS   Alternative School No High 06 12 2019   grade_7   6.0 4.0               1.0   9.0 2.0                       11   6 4               1   9 2                 11
1877112 1877112 NV     school 3200060 2   Clark 320006000597 2932 Cowan Behavior   Alternative School No High 06 12 2019   grade_7   2.0 6.0               1.0   7.0 2.0                       9   2 6               1   7 2                 9
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
1877192 1877192 NV     school 3200090 3   Douglas 320009000422 3302 Pau Wa Lu   Regular School No Middle 06 08 2019   grade_7 124.0   50.0   12.0           11.0   111.0 86.0                       197 124   50   12           11   111 86                 197
1877199 1877199 NV     school 3200090 3   Douglas 320009000122 3502 Whittell   Regular School No High 07 12 2019   grade_7 16.0 1.0 7.0               1.0   16.0 9.0                       25 16 1 7               1   16 9                 25
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
1877318 1877318 NV     school 3200120 4   Elko 320012000674 4501 Carlin JHS   Regular School No Middle 07 08 2019   grade_7 10.0   4.0               1.0   8.0 7.0                       15 10   4               1   8 7                 15
1877320 1877320 NV     school 3200120 4   Elko 320012000685 4502 Wells MS JHS   Regular School No Middle 07 08 2019   grade_7 18.0   8.0               2.0   16.0 12.0                       28 18   8               2   16 12                 28
1877323 1877323 NV     school 3200120 4   Elko 320012000326 4503 Adobe MS   Regular School No Middle 05 08 2019   grade_7 192.0 5.0 151.0   17.0         1.0 6.0   179.0 193.0                       372 192 5 151   17         1 6   179 193                 372
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
1877423 1877423 NV     school 3200180 6   Eureka 320018000148 6601 Eureka Co   Regular School No High 07 12 2019   grade_7 16.0   2.0   1.0           3.0   16.0 6.0                       22 16   2   1           3   16 6                 22
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

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