Data source: Big Local News · About: Big Local

583 rows where grade = "grade_8" and state = "NV" sorted by hispanic

View and edit SQL

year

grade

  • grade_8 · 583
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
1708892 NV     school 3200060 2   Clark 320006000694 2916 Miley Achvmt SEC   Special Education School No High 06 12 2020   grade_8 1.0 7.0                 1.0   8.0 1.0                       9 1 7                 1   8 1                 9
1708919 NV     school 3200060 2   Clark 320006000683 2927 Desert Willow   Special Education School No High 06 12 2020   grade_8 2.0 1.0                     3.0                         3 2 1                     3                   3
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
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
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
1709144 NV     school 3200120 4   Elko 320012000750 4213 Flagview Int Sch   Regular School No Middle 05 08 2020   grade_8 1.0                       1.0                         1 1                       1                   1
1709215 NV     school 3200150 5   Esmeralda 320015000144 5102 Goldfield ES   Regular School No Elementary PK 08 2020   grade_8 2.0                         2.0                       2 2                         2                 2
1709222 NV     school 3200150 5   Esmeralda 320015000145 5103 Silver Peak ES   Regular School No Elementary PK 08 2020   grade_8 1.0                         1.0                       1 1                         1                 1
1709249 NV     school 3200210 7   Humboldt 320021000150 7101 Denio ES   Regular School No Elementary PK 08 2020   grade_8 1.0                       1.0                         1 1                       1                   1
1709302 NV     school 3200210 7   Humboldt 320021000708 7302 McDermitt JHS   Regular School No Middle 06 08 2020   grade_8         11.0               7.0 4.0                       11         11               7 4                 11
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
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
1709446 NV     school 3200300 10   Lyon 320030000311 10303 Fernley IS   Regular School No Middle 05 08 2020   grade_8 2.0                       2.0                         2 2                       2                   2
1709597 NV     school 3200360 12   Nye 320036000575 12315 Gabbs MS   Regular School No Middle 06 08 2020   grade_8 2.0                   1.0     3.0                       3 2                   1     3                 3
1709603 NV     school 3200360 12   Nye 320036000729 12317 Duckwater MS   Regular School No Middle 06 08 2020   grade_8         1.0               1.0                         1         1               1                   1
1710451 NV     school 3200510 17   White Pine 320051000606 17601 Lund Jr S HS   Regular School No High 06 12 2020   grade_8 10.0                       5.0 5.0                       10 10                       5 5                 10
1710946 NV     school 3200021 84   University Schools 320002100680 19406 Davidson Acad   Regular School No High 05 12 2020   grade_8 16.0 1.0       9.0         4.0   12.0 18.0                       30 16 1       9         4   12 18                 30
1877061 NV     school 3200060 2   Clark 320006000020 2912 Juvenile Court   Alternative School No High 06 12 2019   grade_8 1.0 2.0                     3.0                         3 1 2                     3                   3
1877216 NV     school 3200090 3   Douglas 320009000764 3901 Douglas ALT ALT   Alternative School No Other 04 12 2019   grade_8 2.0                         2.0                       2 2                         2                 2
1877317 NV     school 3200120 4   Elko 320012000750 4213 Flagview Int Sch   Regular School No Middle 05 08 2019   grade_8 1.0                         1.0                       1 1                         1                 1
1877331 NV     school 3200120 4   Elko 320012000684 4506 Owyhee JHS   Regular School No Middle 07 08 2019   grade_8         23.0               12.0 11.0                       23         23               12 11                 23
1877372 NV     school 3200120 4   Elko 320012000839 4610 NNVVirtual   Regular School No Other KG 12 2019   grade_8 3.0                       3.0                         3 3                       3                   3
1877397 NV     school 3200150 5   Esmeralda 320015000144 5102 Goldfield ES   Regular School No Elementary PK 08 2019   grade_8 2.0                 1.0     1.0 2.0                       3 2                 1     1 2                 3
1877404 NV     school 3200150 5   Esmeralda 320015000145 5103 Silver Peak ES   Regular School No Elementary PK 08 2019   grade_8 1.0                       1.0                         1 1                       1                   1
1877433 NV     school 3200210 7   Humboldt 320021000150 7101 Denio ES   Regular School No Elementary PK 08 2019   grade_8 2.0                       1.0 1.0                       2 2                       1 1                 2
1877439 NV     school 3200210 7   Humboldt 320021000151 7103 Kings River ES   Regular School No Elementary PK 08 2019   grade_8 1.0                         1.0                       1 1                         1                 1
1877456 NV     school 3200210 7   Humboldt 320021000156 7105 Paradise Vly ES   Regular School No Elementary PK 08 2019   grade_8 1.0                       1.0                         1 1                       1                   1
1877486 NV     school 3200210 7   Humboldt 320021000708 7302 McDermitt JHS   Regular School No Middle 06 08 2019   grade_8 1.0       4.0               2.0 3.0                       5 1       4               2 3                 5
1877516 NV     school 3200240 8   Lander 320024000162 8602 Austin School   Regular School No Other PK 12 2019   grade_8 1.0                       1.0                         1 1                       1                   1
1877694 NV     school 3200330 11   Mineral 320033000183 11601 Mineral Co HS   Regular School No High 08 12 2019   grade_8 1.0                       1.0                         1 1                       1                   1
1877787 NV     school 3200360 12   Nye 320036000575 12315 Gabbs MS   Regular School No Middle 06 08 2019   grade_8         1.0                 1.0                       1         1                 1                 1
1878607 NV     school 3200480 16   Washoe 320048000766 16917 Turning Point   Alternative School No Other 01 12 2019   grade_8 3.0                   1.0   3.0 1.0                       4 3                   1   3 1                 4
1879099 NV     school 3200021 84   University Schools 320002100680 19406 Davidson Acad   Regular School No High 05 12 2019   grade_8 15.0         10.0             13.0 12.0                       25 15         10             13 12                 25
1841383 NV     school 3200060 2   Clark County 320006000020 2912 Juvenile Court   Alternative School No High 06 12 2021   grade_8 0 1 0   0 0       0 0   1 0   0.0                   1 0 1 0   0 0       0 0   1 0   0             1
1841388 NV     school 3200060 2   Clark County 320006000101 2913 Spring Mtn JSHS   Alternative School No High 06 12 2021   grade_8 0 1 0   0 0       0 1   2 0   0.0                   2 0 1 0   0 0       0 1   2 0   0             2
1841547 NV     school 3200090 3   Douglas 320009000764 3901 Douglas Alternative   Alternative School No Other 04 12 2021   grade_8 1 0 0   1 0       0 1   2 1   0.0                   3 1 0 0   1 0       0 1   2 1   0             3
1841578 NV     school 3200120 4   Elko 320012000139 4111 Ruby Valley ES   Regular School No Elementary 01 08 2021   grade_8 5 0 0   0 0       0 0   1 4   0.0                   5 5 0 0   0 0       0 0   1 4   0             5
1841731 NV     school 3200150 5   Esmeralda 320015000144 5102 Goldfield ES   Regular School No Elementary PK 08 2021   grade_8 4 0 0   0 0       0 1   2 3   0.0                   5 4 0 0   0 0       0 1   2 3   0             5
1841737 NV     school 3200150 5   Esmeralda 320015000145 5103 Silver Peak ES   Regular School No Elementary PK 08 2021   grade_8 1 0 0   0 0       0 0   0 1   0.0                   1 1 0 0   0 0       0 0   0 1   0             1
1841766 NV     school 3200210 7   Humboldt 320021000150 7101 Denio ES   Regular School No Elementary PK 08 2021   grade_8 1 0 0   0 0       0 0   1 0   0.0                   1 1 0 0   0 0       0 0   1 0   0             1
1841780 NV     school 3200210 7   Humboldt 320021000155 7104 Orovada ES   Regular School No Elementary PK 08 2021   grade_8 3 0 0   0 0       0 0   2 1   0.0                   3 3 0 0   0 0       0 0   2 1   0             3
1841788 NV     school 3200210 7   Humboldt 320021000156 7105 Paradise Valley ES   Regular School No Elementary PK 08 2021   grade_8 2 0 0   0 0       0 0   1 1   0.0                   2 2 0 0   0 0       0 0   1 1   0             2
1841818 NV     school 3200210 7   Humboldt 320021000708 7302 McDermitt JHS   Regular School No Middle 07 08 2021   grade_8 0 0 0   4 0       0 0   0 4   0.0                   4 0 0 0   4 0       0 0   0 4   0             4
1841892 NV     school 3200270 9   Lincoln 320027000169 9602 C O Bastian   Alternative School No High 07 12 2021   grade_8 1 0 0   0 0       0 0   0 1   0.0                   1 1 0 0   0 0       0 0   0 1   0             1
1841997 NV     school 3200300 10   Lyon 320030000768 10902 Eagle Ridge HS   Alternative School No High 07 12 2021   grade_8 0 1 0   0 0       0 0   1 0   0.0                   1 0 1 0   0 0       0 0   1 0   0             1
1842093 NV     school 3200360 12   Nye 320036000871 12211 Warm Springs Combined   Regular School No Elementary 01 08 2021   grade_8 2 0 0   0 0       0 0   2 0   0.0                   2 2 0 0   0 0       0 0   2 0   0             2
1842108 NV     school 3200360 12   Nye 320036000575 12315 Gabbs MS   Regular School No Middle 06 08 2021   grade_8 1 0 0   0 0       0 1   1 1   0.0                   2 1 0 0   0 0       0 1   1 1   0             2
1842114 NV     school 3200360 12   Nye 320036000729 12317 Duckwater MS   Regular School No Middle 06 08 2021   grade_8 0 0 0   2 0       0 0   1 1   0.0                   2 0 0 0   2 0       0 0   1 1   0             2
1842831 NV     school 3200480 16   Washoe County 320048000217 16601 Gerlach K 12   Regular School No Other PK 12 2021   grade_8 2 0 0   0 0       0 0   0 2   0.0                   2 2 0 0   0 0       0 0   0 2   0             2
1842902 NV     school 3200480 16   Washoe County 320048000766 16917 Turning Point   Alternative School No Other 02 12 2021   grade_8 1 0 0   0 0       0 0   1 0   0.0                   1 1 0 0   0 0       0 0   1 0   0             1
1842956 NV     school 3200510 17   White Pine 320051000606 17601 Lund JSHS   Regular School No High 06 12 2021   grade_8 8 0 0   0 0       0 0   6 2   0.0                   8 8 0 0   0 0       0 0   6 2   0             8
1843472 NV     school 3200021 84   Davidson Academy 320002100680 19406 Davidson Acad   Regular School No High 06 12 2021   grade_8 20 0 0   0 18       0 10   31 17   0.0                   48 20 0 0   0 18       0 10   31 17   0             48
1841425 NV     school 3200060 2   Clark County 320006000499 2928 South Cont JSHS   Alternative School No High 06 12 2021   grade_8 2 7 1   0 0       0 0   8 2   0.0                   10 2 7 1   0 0       0 0   8 2   0             10
1841437 NV     school 3200060 2   Clark County 320006000598 2933 Peterson Behavior   Alternative School No High 06 12 2021   grade_8 0 5 1   0 0       0 0   4 2   0.0                   6 0 5 1   0 0       0 0   4 2   0             6
1841523 NV     school 3200090 3   Douglas 320009000348 3503 Jacobsen HS   Alternative School No High 07 12 2021   grade_8 2 0 1   0 0       0 0   1 2   0.0                   3 2 0 1   0 0       0 0   1 2   0             3
1841668 NV     school 3200120 4   Elko 320012000684 4506 Owyhee JHS   Regular School No Middle 07 08 2021   grade_8 0 0 1   29 0       0 0   18 12   0.0                   30 0 0 1   29 0       0 0   18 12   0             30
1841771 NV     school 3200210 7   Humboldt 320021000151 7103 Kings River ES   Regular School No Elementary PK 08 2021   grade_8 2 0 1   0 0       0 0   3 0   0.0                   3 2 0 1   0 0       0 0   3 0   0             3
1708878 NV     school 3200060 2   Clark 320006000020 2912 Juvenile Court   Alternative School No High 06 12 2020   grade_8 1.0 2.0 1.0                   3.0 1.0                       4 1 2 1                   3 1                 4
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
1709157 NV     school 3200120 4   Elko 320012000684 4506 Owyhee JHS   Regular School No Middle 07 08 2020   grade_8     1.0   28.0               13.0 16.0                       29     1   28               13 16                 29
1709193 NV     school 3200120 4   Elko 320012000839 4610 NNVVirtual   Regular School No Other KG 12 2020   grade_8 4.0   1.0                   1.0 4.0                       5 4   1                   1 4                 5
1709256 NV     school 3200210 7   Humboldt 320021000151 7103 Kings River ES   Regular School No Elementary PK 08 2020   grade_8     1.0                     1.0                       1     1                     1                 1
1709263 NV     school 3200210 7   Humboldt 320021000155 7104 Orovada ES   Regular School No Elementary PK 08 2020   grade_8 1.0   1.0                     2.0                       2 1   1                     2                 2
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
1710397 NV     school 3200480 16   Washoe 320048000766 16917 Turning Point   Alternative School No Other 02 12 2020   grade_8 2.0 1.0 1.0                   3.0 1.0                       4 2 1 1                   3 1                 4
1710410 NV     school 3200480 16   Washoe 320048000844 16923 North Star   Alternative School No Other PK 12 2020   grade_8 13.0   1.0     3.0             4.0 13.0                       17 13   1     3             4 13                 17
1710653 NV     school 3200001 57   Honors Academy of Literature 320000100826 57424 Honors ACAD   Regular School Yes Elementary KG 08 2020   grade_8 16.0   1.0     1.0         2.0   8.0 12.0                       20 16   1     1         2   8 12                 20
1876009 NV     school 3200060 2   Clark 320006000384 2215 Miller Sch   Special Education School No Other PK 12 2019   grade_8 1.0   1.0             1.0 2.0   4.0 1.0                       5 1   1             1 2   4 1                 5
1877075 NV     school 3200060 2   Clark 320006000694 2916 Miley Achvmt SEC   Special Education School No High 06 12 2019   grade_8 5.0 7.0 1.0               1.0   11.0 3.0                       14 5 7 1               1   11 3                 14
1877238 NV     school 3200120 4   Elko 320012000134 4108 Mound Vly ES   Regular School No Elementary KG 08 2019   grade_8 2.0   1.0                   2.0 1.0                       3 2   1                   2 1                 3
1878947 NV     school 3200001 61   Discovery Charter 320000100885 61415 Discovery Mesa   Regular School Yes Elementary KG 08 2019   grade_8 1.0 2.0 1.0             2.0 1.0   6.0 1.0                       7 1 2 1             2 1   6 1                 7
1841659 NV     school 3200120 4   Elko 320012000685 4502 Wells JHS   Regular School No Middle 07 08 2021   grade_8 11 0 10   2 1       0 1   12 13   0.0                   25 11 0 10   2 1       0 1   12 13   0             25
1841666 NV     school 3200120 4   Elko 320012000692 4505 Jackpot JHS   Regular School No Middle 07 08 2021   grade_8 4 0 10   0 0       0 0   9 5   0.0                   14 4 0 10   0 0       0 0   9 5   0             14
1842915 NV     school 3200480 16   Washoe County 320048000844 16923 North Star Online   Alternative School No Other KG 12 2021   grade_8 53 0 10   1 4       0 4   41 31   0.0                   72 53 0 10   1 4       0 4   41 31   0             72
1708519 NV     school 3200060 2   Clark 320006000699 2336 Indian Springs   Regular School No Middle 06 08 2020   grade_8 20.0 1.0 10.0   1.0               15.0 17.0                       32 20 1 10   1               15 17                 32
1708601 NV     school 3200060 2   Clark 320006000756 2364 100 Academy 6-8 MS   Regular School Yes Middle 06 08 2020   grade_8   29.0 10.0     1.0         2.0   16.0 26.0                       42   29 10     1         2   16 26                 42
1709148 NV     school 3200120 4   Elko 320012000685 4502 Wells MS JHS   Regular School No Middle 07 08 2020   grade_8 19.0   10.0               2.0   19.0 12.0                       31 19   10               2   19 12                 31
1710820 NV     school 3200001 68   Elko Institute for Academic Achievement 320000100784 68410 EIAA   Regular School Yes Elementary KG 08 2020   grade_8 11.0   10.0               1.0   9.0 13.0                       22 11   10               1   9 13                 22
1877119 NV     school 3200060 2   Clark 320006000598 2933 Peterson Behavior   Alternative School No High 06 12 2019   grade_8 3.0 13.0 10.0             1.0 1.0   22.0 6.0                       28 3 13 10             1 1   22 6                 28
1877634 NV     school 3200300 10   Lyon 320030000424 10304 Silver Stage MS   Regular School No Middle 05 08 2019   grade_8 57.0   10.0     3.0       2.0 5.0   48.0 29.0                       77 57   10     3       2 5   48 29                 77
1878823 NV     school 3200001 55   Doral Academy 320000100892 55204 Doral W Pebble ACAD   Regular School Yes Elementary KG 08 2019   grade_8 21.0 7.0 10.0   1.0 3.0       2.0 3.0   21.0 26.0                       47 21 7 10   1 3       2 3   21 26                 47
1878995 NV     school 3200001 72   Quest Academy 320000100759 72416 Quest Northwest   Regular School Yes Elementary KG 08 2019   grade_8 8.0 19.0 10.0     1.0       3.0 3.0   24.0 20.0                       44 8 19 10     1       3 3   24 20                 44
1841057 NV     school 3200060 2   Clark County 320006000592 2350 Hughes MS   Regular School No Middle 06 08 2021   grade_8 72 2 100   2 2       1 6   102 83   0.0                   185 72 2 100   2 2       1 6   102 83   0             185
1708558 NV     school 3200060 2   Clark 320006000592 2350 Hughes   Regular School No Middle 06 08 2020   grade_8 91.0 2.0 100.0   1.0 3.0         10.0   109.0 98.0                       207 91 2 100   1 3         10   109 98                 207
1709300 NV     school 3200210 7   Humboldt 320021000159 7301 Winnemucca JHS   Regular School No Middle 05 08 2020   grade_8 149.0 1.0 100.0   2.0           11.0   133.0 130.0                       263 149 1 100   2           11   133 130                 263
1710266 NV     school 3200480 16   Washoe 320048000913 16319 Sky Ranch MS   Regular School No Middle 06 08 2020   grade_8 232.0 9.0 100.0   3.0 27.0       1.0 21.0   210.0 183.0                       393 232 9 100   3 27       1 21   210 183                 393
1878461 NV     school 3200480 16   Washoe 320048000624 16316 Shaw   Regular School No Middle 07 08 2019   grade_8 302.0 8.0 100.0   22.0 9.0       3.0 38.0   272.0 210.0                       482 302 8 100   22 9       3 38   272 210                 482
1843060 NV     school 3200001 49   Mater Academy of Nevada 320000100902 49433 Mater Bonanza   Regular School Yes Elementary PK 08 2021   grade_8 8 9 101   1 0       1 2   57 65   0.0                   122 8 9 101   1 0       1 2   57 65   0             122
1710542 NV     school 3200001 49   Mater Academy 320000100851 49432 Mater MT Vista ACAD   Regular School Yes Elementary PK 08 2020   grade_8 5.0 10.0 101.0     1.0         4.0   69.0 52.0                       121 5 10 101     1         4   69 52                 121
1878723 NV     school 3200001 49   Mater Academy 320000100851 49432 Mater MT Vista ACAD   Regular School Yes Elementary PK 08 2019   grade_8 11.0 6.0 101.0               5.0   67.0 56.0                       123 11 6 101               5   67 56                 123
1843038 NV     school 3200001 48   Equipo Academy 320000100856 48433 Equipo ACAD   Regular School Yes High 06 12 2021   grade_8 1 1 102   0 1       0 0   45 60   0.0                   105 1 1 102   0 1       0 0   45 60   0             105
1843050 NV     school 3200001 49   Mater Academy of Nevada 320000100851 49432 Mater Mtn Vista   Regular School Yes Elementary PK 08 2021   grade_8 8 11 102   0 0       0 3   65 59   0.0                   124 8 11 102   0 0       0 3   65 59   0             124
1841063 NV     school 3200060 2   Clark County 320006000578 2353 Mannion MS   Regular School No Middle 06 08 2021   grade_8 325 25 104   2 20       6 54   274 262   0.0                   536 325 25 104   2 20       6 54   274 262   0             536
1876636 NV     school 3200060 2   Clark 320006000301 2319 Brown JHS   Regular School No Middle 06 08 2019   grade_8 137.0 53.0 104.0   2.0 10.0       2.0 37.0   192.0 153.0                       345 137 53 104   2 10       2 37   192 153                 345
1843385 NV     school 3200001 86   Nevada Virtual Academy 320000100734 86404 Nevada Virtual ACAD   Regular School Yes High 06 12 2021   grade_8 171 97 105   4 24       7 19   217 210   0.0                   427 171 97 105   4 24       7 19   217 210   0             427
1709585 NV     school 3200360 12   Nye 320036000412 12301 Clarke   Regular School No Middle 06 08 2020   grade_8 208.0 18.0 105.0   5.0 4.0       3.0 21.0   190.0 174.0                       364 208 18 105   5 4       3 21   190 174                 364
1841087 NV     school 3200060 2   Clark County 320006000739 2361 Escobedo MS   Regular School No Middle 06 08 2021   grade_8 112 60 106   2 18       5 46   178 171   0.0                   349 112 60 106   2 18       5 46   178 171   0             349
1708528 NV     school 3200060 2   Clark 320006000515 2339 Rogich   Regular School No Middle 06 08 2020   grade_8 371.0 41.0 107.0   2.0 75.0       7.0 60.0   353.0 310.0                       663 371 41 107   2 75       7 60   353 310                 663
1710530 NV     school 3200001 48   Equipo Academy 320000100856 48433 Equipo ACAD   Regular School Yes High 06 12 2020   grade_8 3.0 1.0 107.0                   59.0 52.0                       111 3 1 107                   59 52                 111
1879031 NV     school 3200001 85   Nevada Connections Academy 320000100731 85405 NV Connections ACAD   Regular School Yes Other KG 12 2019   grade_8 210.0 56.0 107.0   3.0 12.0       5.0 54.0   222.0 225.0                       447 210 56 107   3 12       5 54   222 225                 447

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