enrollments

Data source: Big Local News · About: Big Local

4,865 rows where state = "NV" and year = 2019 sorted by hispanic_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 4,765 ✖
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
1877700 1877700 NV     school 3200330 11   Mineral 320033000859 11925 MCAE   Alternative School No Adult Education AE AE 2019   adult 15.0   1.0   4.0               8.0 12.0                       20 15   1   4               8 12                 20
1877701 1877701 NV     school 3200360 12   Nye 320036000188 12101 Duckwater ES   Regular School No Elementary PK 05 2019   grade_2 1.0   1.0                   1.0 1.0                       2 1   1                   1 1                 2
1877702 1877702 NV     school 3200360 12   Nye 320036000188 12101 Duckwater ES   Regular School No Elementary PK 05 2019   grade_4     1.0               1.0     2.0                       2     1               1     2                 2
1877703 1877703 NV     school 3200360 12   Nye 320036000188 12101 Duckwater ES   Regular School No Elementary PK 05 2019   grade_5     1.0   1.0           2.0   1.0 3.0                       4     1   1           2   1 3                 4
1877716 1877716 NV     school 3200360 12   Nye 320036000193 12103 Round Mtn   Regular School No Elementary PK 05 2019   grade_4 18.0   1.0   4.0               10.0 13.0                       23 18   1   4               10 13                 23
1877720 1877720 NV     school 3200360 12   Nye 320036000189 12105 Gabbs ES   Regular School No Elementary PK 05 2019   grade_1     1.0             1.0     1.0 1.0                       2     1             1     1 1                 2
1877722 1877722 NV     school 3200360 12   Nye 320036000189 12105 Gabbs ES   Regular School No Elementary PK 05 2019   grade_3 1.0   1.0               1.0   1.0 2.0                       3 1   1               1   1 2                 3
1877725 1877725 NV     school 3200360 12   Nye 320036000189 12105 Gabbs ES   Regular School No Elementary PK 05 2019   kindergarten 1.0   1.0               1.0   3.0                         3 1   1               1   3                   3
1877743 1877743 NV     school 3200360 12   Nye 320036000186 12201 Beatty   Regular School No Elementary PK 05 2019   grade_4 6.0 1.0 1.0               1.0   4.0 5.0                       9 6 1 1               1   4 5                 9
1877752 1877752 NV     school 3200360 12   Nye 320036000194 12202 Tonopah   Regular School No Elementary PK 05 2019   pre_kindergarten 11.0   1.0               1.0   5.0 8.0                       13 11   1               1   5 8                 13
1877800 1877800 NV     school 3200360 12   Nye 320036000190 12602 Gabbs HS   Regular School No High 09 12 2019   grade_12 1.0   1.0                   1.0 1.0                       2 1   1                   1 1                 2
1877891 1877891 NV     school 3200420 14   Pershing 320042000196 14101 Imlay ES   Regular School No Elementary PK 05 2019   grade_2 1.0   1.0                   1.0 1.0                       2 1   1                   1 1                 2
1877892 1877892 NV     school 3200420 14   Pershing 320042000196 14101 Imlay ES   Regular School No Elementary PK 05 2019   grade_3 4.0   1.0               1.0   2.0 4.0                       6 4   1               1   2 4                 6
1877894 1877894 NV     school 3200420 14   Pershing 320042000196 14101 Imlay ES   Regular School No Elementary PK 05 2019   grade_5     1.0                   1.0                         1     1                   1                   1
1877895 1877895 NV     school 3200420 14   Pershing 320042000196 14101 Imlay ES   Regular School No Elementary PK 05 2019   kindergarten 4.0   1.0               1.0   5.0 1.0                       6 4   1               1   5 1                 6
1877916 1877916 NV     school 3200450 15   Storey 320045000200 15101 Gallagher ES   Regular School No Elementary PK 05 2019   kindergarten 18.0 1.0 1.0               1.0   13.0 8.0                       21 18 1 1               1   13 8                 21
1877917 1877917 NV     school 3200450 15   Storey 320045000200 15101 Gallagher ES   Regular School No Elementary PK 05 2019   pre_kindergarten 10.0   1.0                   6.0 5.0                       11 10   1                   6 5                 11
1877918 1877918 NV     school 3200450 15   Storey 320045000413 15102 Hillside ES   Regular School No Elementary PK 05 2019   grade_1 5.0   1.0                   4.0 2.0                       6 5   1                   4 2                 6
1877919 1877919 NV     school 3200450 15   Storey 320045000413 15102 Hillside ES   Regular School No Elementary PK 05 2019   grade_2 4.0   1.0                   2.0 3.0                       5 4   1                   2 3                 5
1877921 1877921 NV     school 3200450 15   Storey 320045000413 15102 Hillside ES   Regular School No Elementary PK 05 2019   grade_4 6.0   1.0                     7.0                       7 6   1                     7                 7
1877922 1877922 NV     school 3200450 15   Storey 320045000413 15102 Hillside ES   Regular School No Elementary PK 05 2019   grade_5 4.0   1.0                   4.0 1.0                       5 4   1                   4 1                 5
1877976 1877976 NV     school 3200480 16   Washoe 320048000223 16206 Hunter Lake   Regular School No Elementary PK 06 2019   pre_kindergarten     1.0               1.0   2.0                         2     1               1   2                   2
1878016 1878016 NV     school 3200480 16   Washoe 320048000321 16211 Mount Rose ES   Regular School No Elementary PK 08 2019   pre_kindergarten     1.0                   1.0                         1     1                   1                   1
1878096 1878096 NV     school 3200480 16   Washoe 320048000214 16223 Drake   Regular School No Elementary PK 06 2019   pre_kindergarten     1.0                   1.0                         1     1                   1                   1
1878131 1878131 NV     school 3200480 16   Washoe 320048000241 16228 Mitchell ES   Regular School No Elementary PK 05 2019   pre_kindergarten 1.0   1.0                   1.0 1.0                       2 1   1                   1 1                 2
1878185 1878185 NV     school 3200480 16   Washoe 320048000234 16237 Natchez ES   Regular School No Elementary PK 06 2019   grade_3 2.0   1.0   15.0               11.0 7.0                       18 2   1   15               11 7                 18
1878189 1878189 NV     school 3200480 16   Washoe 320048000234 16237 Natchez ES   Regular School No Elementary PK 06 2019   kindergarten     1.0   11.0           2.0   5.0 9.0                       14     1   11           2   5 9                 14
1878237 1878237 NV     school 3200480 16   Washoe 320048000224 16251 Incline ES   Regular School No Elementary PK 05 2019   pre_kindergarten 3.0   1.0                   2.0 2.0                       4 3   1                   2 2                 4
1878267 1878267 NV     school 3200480 16   Washoe 320048000336 16259 Whitehead   Regular School No Elementary PK 06 2019   pre_kindergarten     1.0                   1.0                         1     1                   1                   1
1878479 1878479 NV     school 3200480 16   Washoe 320048000208 16501 Wooster   Regular School No High 09 12 2019   ungraded 1.0   1.0                   1.0 1.0                       2 1   1                   1 1                 2
1878500 1878500 NV     school 3200480 16   Washoe 320048000822 16507 Inspire   Alternative School No Other PK 12 2019   grade_2     1.0                   1.0                         1     1                   1                   1
1878501 1878501 NV     school 3200480 16   Washoe 320048000822 16507 Inspire   Alternative School No Other PK 12 2019   grade_5     1.0                   1.0                         1     1                   1                   1
1878502 1878502 NV     school 3200480 16   Washoe 320048000822 16507 Inspire   Alternative School No Other PK 12 2019   grade_6 1.0   1.0                   2.0                         2 1   1                   2                   2
1878503 1878503 NV     school 3200480 16   Washoe 320048000822 16507 Inspire   Alternative School No Other PK 12 2019   grade_7 1.0   1.0               1.0   2.0 1.0                       3 1   1               1   2 1                 3
1878524 1878524 NV     school 3200480 16   Washoe 320048000869 16510 Innovations   Alternative School No High 09 12 2019   pre_kindergarten 2.0   1.0                   2.0 1.0                       3 2   1                   2 1                 3
1878526 1878526 NV     school 3200480 16   Washoe 320048000217 16601 Gerlach K-12   Regular School No Other PK 12 2019   grade_2     1.0                     1.0                       1     1                     1                 1
1878529 1878529 NV     school 3200480 16   Washoe 320048000217 16601 Gerlach K-12   Regular School No Other PK 12 2019   grade_5     1.0                     1.0                       1     1                     1                 1
1878530 1878530 NV     school 3200480 16   Washoe 320048000217 16601 Gerlach K-12   Regular School No Other PK 12 2019   grade_6 2.0   1.0                   1.0 2.0                       3 2   1                   1 2                 3
1878532 1878532 NV     school 3200480 16   Washoe 320048000217 16601 Gerlach K-12   Regular School No Other PK 12 2019   grade_9 1.0   1.0                   2.0                         2 1   1                   2                   2
1878535 1878535 NV     school 3200480 16   Washoe 320048000217 16601 Gerlach K-12   Regular School No Other PK 12 2019   grade_12 3.0   1.0                   3.0 1.0                       4 3   1                   3 1                 4
1878575 1878575 NV     school 3200480 16   Washoe 320048000602 16609 Damonte Ranch HS   Regular School No High 09 12 2019   ungraded 1.0   1.0                   1.0 1.0                       2 1   1                   1 1                 2
1878589 1878589 NV     school 3200480 16   Washoe 320048000233 16911 Picollo Sch   Special Education School No Other PK 12 2019   grade_4 6.0   1.0   1.0         2.0     7.0 3.0                       10 6   1   1         2     7 3                 10
1878598 1878598 NV     school 3200480 16   Washoe 320048000233 16911 Picollo Sch   Special Education School No Other PK 12 2019   kindergarten 2.0   1.0                   2.0 1.0                       3 2   1                   2 1                 3
1878601 1878601 NV     school 3200480 16   Washoe 320048000766 16917 Turning Point   Alternative School No Other 01 12 2019   grade_1   1.0 1.0                   2.0                         2   1 1                   2                   2
1878602 1878602 NV     school 3200480 16   Washoe 320048000766 16917 Turning Point   Alternative School No Other 01 12 2019   grade_3 1.0   1.0                   2.0                         2 1   1                   2                   2
1878609 1878609 NV     school 3200480 16   Washoe 320048000766 16917 Turning Point   Alternative School No Other 01 12 2019   grade_10 1.0   1.0                   1.0 1.0                       2 1   1                   1 1                 2
1878615 1878615 NV     school 3200480 16   Washoe 320048000844 16923 North Star   Alternative School No Other PK 12 2019   grade_4 2.0   1.0                   3.0                         3 2   1                   3                   3
1878616 1878616 NV     school 3200480 16   Washoe 320048000844 16923 North Star   Alternative School No Other PK 12 2019   grade_5 4.0   1.0     1.0             2.0 4.0                       6 4   1     1             2 4                 6
1878617 1878617 NV     school 3200480 16   Washoe 320048000844 16923 North Star   Alternative School No Other PK 12 2019   grade_6 7.0   1.0     2.0             5.0 5.0                       10 7   1     2             5 5                 10
1878624 1878624 NV     school 3200480 16   Washoe 320048000844 16923 North Star   Alternative School No Other PK 12 2019   kindergarten 1.0   1.0               1.0   1.0 2.0                       3 1   1               1   1 2                 3
1878628 1878628 NV     school 3200510 17   White Pine 320051000720 17101 Lund ES   Regular School No Elementary KG 05 2019   grade_3 16.0 4.0 1.0     1.0             14.0 8.0                       22 16 4 1     1             14 8                 22
1878630 1878630 NV     school 3200510 17   White Pine 320051000720 17101 Lund ES   Regular School No Elementary KG 05 2019   grade_5 16.0 8.0 1.0   1.0         2.0     17.0 11.0                       28 16 8 1   1         2     17 11                 28
1878631 1878631 NV     school 3200510 17   White Pine 320051000720 17101 Lund ES   Regular School No Elementary KG 05 2019   kindergarten 4.0   1.0               2.0   5.0 2.0                       7 4   1               2   5 2                 7
1878633 1878633 NV     school 3200510 17   White Pine 320051000254 17103 Baker ES   Regular School No Elementary 03 06 2019   grade_4 2.0   1.0                   1.0 2.0                       3 2   1                   1 2                 3
1878646 1878646 NV     school 3200510 17   White Pine 320051000263 17203 McGill ES   Regular School No Elementary PK 05 2019   grade_5 11.0   1.0   1.0           1.0   6.0 8.0                       14 11   1   1           1   6 8                 14
1878771 1878771 NV     school 3200001 54   Learning Bridge 320000100833 54428 Learning Bridge   Regular School Yes Elementary KG 08 2019   grade_4 16.0   1.0   2.0           1.0   7.0 13.0                       20 16   1   2           1   7 13                 20
1878831 1878831 NV     school 3200001 57   Honors Academy of Literature 320000100826 57424 Honors ACAD   Regular School Yes Elementary KG 08 2019   grade_7 20.0   1.0             1.0 1.0   12.0 11.0                       23 20   1             1 1   12 11                 23
1878947 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
1878961 1878961 NV     school 3200001 65   Oasis Academy 320000100817 65414 Oasis ACAD   Regular School Yes Other KG 12 2019   grade_4 44.0   1.0   1.0 2.0             23.0 25.0                       48 44   1   1 2             23 25                 48
1878987 1878987 NV     school 3200001 68   Elko Institute for Academic Achievement 320000100784 68410 EIAA   Regular School Yes Elementary KG 08 2019   kindergarten 18.0 1.0 1.0   1.0 1.0             10.0 12.0                       22 18 1 1   1 1             10 12                 22
1879088 1879088 NV     school 3200001 89   Beacon Academy of Nevada 320000100751 89409 Beacon ACAD   Regular School Yes High 09 12 2019   grade_9 3.0   1.0               1.0   3.0 2.0                       5 3   1               1   3 2                 5
1879100 1879100 NV     school 3200021 84   University Schools 320002100680 19406 Davidson Acad   Regular School No High 05 12 2019   grade_9 21.0   1.0   1.0 9.0             12.0 20.0                       32 21   1   1 9             12 20                 32
1879103 1879103 NV     school 3200021 84   University Schools 320002100680 19406 Davidson Acad   Regular School No High 05 12 2019   grade_12 14.0   1.0     8.0             14.0 9.0                       23 14   1     8             14 9                 23
1879521 1879521 NV     school 3200120 4   Elko 320012000727 4206 Owyhee ES   Regular School No Elementary PK 06 2019   k_12_total 6.0 0.0 1.0   170.0 3.0       0.0 2.0   93.0 89.0                       182 6 0 1   170 3       0 2   93 89                 182
1879533 1879533 NV     school 3200120 4   Elko 320012000684 4506 Owyhee JHS   Regular School No Middle 07 08 2019   k_12_total 0.0 0.0 1.0   53.0 0.0       0.0 0.0   27.0 27.0                       54 0 0 1   53 0       0 0   27 27                 54
1879566 1879566 NV     school 3200240 8   Lander 320024000162 8602 Austin School   Regular School No Other PK 12 2019   k_12_total 8.0 0.0 1.0   0.0 0.0       0.0 0.0   4.0 5.0                       9 8 0 1   0 0       0 0   4 5                 9
1879618 1879618 NV     school 3200360 12   Nye 320036000190 12602 Gabbs HS   Regular School No High 09 12 2019   k_12_total 4.0 0.0 1.0   4.0 0.0       0.0 2.0   7.0 4.0                       11 4 0 1   4 0       0 2   7 4                 11
1875013 1875013 NV     school 3200060 2   Clark 320006000877 2069 Vassiliadis ES   Regular School No Elementary PK 05 2019   pre_kindergarten 18.0 1.0 2.0     3.0         3.0   19.0 8.0                       27 18 1 2     3         3   19 8                 27
1875048 1875048 NV     school 3200060 2   Clark 320006000814 2075 Northwest CTA ES   Regular School No Elementary KG KG 2019   kindergarten 6.0 6.0 2.0     2.0         4.0   8.0 12.0                       20 6 6 2     2         4   8 12                 20
1875129 1875129 NV     school 3200060 2   Clark 320006000740 2087 Rainbow Dreams   Regular School Yes Elementary PK 05 2019   grade_4   23.0 2.0     1.0         2.0   16.0 12.0                       28   23 2     1         2   16 12                 28
1875145 1875145 NV     school 3200060 2   Clark 320006000732 2090 Smalley   Regular School No Elementary PK 05 2019   pre_kindergarten 15.0 1.0 2.0                   16.0 2.0                       18 15 1 2                   16 2                 18
1875233 1875233 NV     school 3200060 2   Clark 320006000099 2104 Reid ES   Regular School No Elementary PK 05 2019   grade_2 7.0   2.0                   6.0 3.0                       9 7   2                   6 3                 9
1875304 1875304 NV     school 3200060 2   Clark 320006000359 2114 Perkins Ute ES   Regular School No Elementary PK 05 2019   grade_4 13.0   2.0   5.0           2.0   15.0 7.0                       22 13   2   5           2   15 7                 22
1875433 1875433 NV     school 3200060 2   Clark 320006000400 2132 May   Regular School No Elementary PK 05 2019   pre_kindergarten 2.0 2.0 2.0               1.0   4.0 3.0                       7 2 2 2               1   4 3                 7
1875666 1875666 NV     school 3200060 2   Clark 320006000472 2166 Lamping   Regular School No Elementary PK 05 2019   pre_kindergarten 28.0 2.0 2.0     3.0         5.0   20.0 20.0                       40 28 2 2     3         5   20 20                 40
1875736 1875736 NV     school 3200060 2   Clark 320006000531 2176 Twitchell ES   Regular School No Elementary PK 05 2019   pre_kindergarten 2.0   2.0     1.0         1.0   3.0 3.0                       6 2   2     1         1   3 3                 6
1875777 1875777 NV     school 3200060 2   Clark 320006000551 2182 Iverson   Regular School No Elementary PK 05 2019   pre_kindergarten 1.0 1.0 2.0     1.0             3.0 2.0                       5 1 1 2     1             3 2                 5
1875798 1875798 NV     school 3200060 2   Clark 320006000605 2185 Givens   Regular School No Elementary PK 05 2019   pre_kindergarten 4.0   2.0     1.0         1.0   6.0 2.0                       8 4   2     1         1   6 2                 8
1875854 1875854 NV     school 3200060 2   Clark 320006000654 2193 Batterman   Regular School No Elementary PK 05 2019   pre_kindergarten 4.0 2.0 2.0     1.0         2.0   9.0 2.0                       11 4 2 2     1         2   9 2                 11
1876002 1876002 NV     school 3200060 2   Clark 320006000384 2215 Miller Sch   Special Education School No Other PK 12 2019   grade_1   2.0 2.0     1.0         2.0   4.0 3.0                       7   2 2     1         2   4 3                 7
1876011 1876011 NV     school 3200060 2   Clark 320006000384 2215 Miller Sch   Special Education School No Other PK 12 2019   grade_10 3.0 4.0 2.0                   4.0 5.0                       9 3 4 2                   4 5                 9
1876015 1876015 NV     school 3200060 2   Clark 320006000384 2215 Miller Sch   Special Education School No Other PK 12 2019   pre_kindergarten 5.0   2.0                   3.0 4.0                       7 5   2                   3 4                 7
1876238 1876238 NV     school 3200060 2   Clark 320006000012 2250 Mitchell ES   Regular School No Elementary PK 05 2019   pre_kindergarten 14.0   2.0                   8.0 8.0                       16 14   2                   8 8                 16
1876246 1876246 NV     school 3200060 2   Clark 320006000577 2252 Indian Springs   Regular School No Elementary PK 05 2019   grade_1 12.0   2.0               1.0   5.0 10.0                       15 12   2               1   5 10                 15
1876247 1876247 NV     school 3200060 2   Clark 320006000577 2252 Indian Springs   Regular School No Elementary PK 05 2019   grade_2 7.0   2.0               1.0   3.0 7.0                       10 7   2               1   3 7                 10
1876249 1876249 NV     school 3200060 2   Clark 320006000577 2252 Indian Springs   Regular School No Elementary PK 05 2019   grade_4 15.0   2.0                   6.0 11.0                       17 15   2                   6 11                 17
1876252 1876252 NV     school 3200060 2   Clark 320006000577 2252 Indian Springs   Regular School No Elementary PK 05 2019   pre_kindergarten 11.0 1.0 2.0               3.0   7.0 10.0                       17 11 1 2               3   7 10                 17
1876273 1876273 NV     school 3200060 2   Clark 320006000110 2255 Virgin Valley   Regular School No Elementary PK 05 2019   pre_kindergarten 5.0   2.0               1.0   6.0 2.0                       8 5   2               1   6 2                 8
1876552 1876552 NV     school 3200060 2   Clark 320006000340 2296 Earl Marion   Regular School No Elementary PK 05 2019   pre_kindergarten 1.0 3.0 2.0     2.0         2.0   6.0 4.0                       10 1 3 2     2         2   6 4                 10
1876682 1876682 NV     school 3200060 2   Clark 320006000460 2330 West Prep Sec SEC   Regular School No High 06 12 2019   ungraded 3.0   2.0                   3.0 2.0                       5 3   2                   3 2                 5
1876785 1876785 NV     school 3200060 2   Clark 320006000855 2367 RainbowDreamAC MS   Regular School Yes Middle 06 08 2019   grade_8   28.0 2.0               1.0   21.0 10.0                       31   28 2               1   21 10                 31
1876815 1876815 NV     school 3200060 2   Clark 320006000007 2406 Basic   Regular School No High 09 12 2019   ungraded 4.0 4.0 2.0     1.0             7.0 4.0                       11 4 4 2     1             7 4                 11
1876816 1876816 NV     school 3200060 2   Clark 320006000103 2408 Morris Sunset   Alternative School No High 09 12 2019   grade_9 1.0   2.0                   2.0 1.0                       3 1   2                   2 1                 3
1876949 1876949 NV     school 3200060 2   Clark 320006000111 2603 Virgin Valley   Regular School No High 09 12 2019   ungraded 1.0   2.0               1.0   2.0 2.0                       4 1   2               1   2 2                 4
1876951 1876951 NV     school 3200060 2   Clark 320006000686 2604 Indian Springs HS   Regular School No High 09 12 2019   grade_10 11.0   2.0               2.0   10.0 5.0                       15 11   2               2   10 5                 15
1876953 1876953 NV     school 3200060 2   Clark 320006000686 2604 Indian Springs HS   Regular School No High 09 12 2019   grade_12 14.0   2.0   2.0               12.0 6.0                       18 14   2   2               12 6                 18
1876963 1876963 NV     school 3200060 2   Clark 320006000494 2608 Foothill HS   Regular School No High 09 12 2019   ungraded 12.0 2.0 2.0     1.0             10.0 7.0                       17 12 2 2     1             10 7                 17
1877000 1877000 NV     school 3200060 2   Clark 320006000661 2618 Arbor View   Regular School No High 09 12 2019   ungraded 8.0 1.0 2.0     1.0             9.0 3.0                       12 8 1 2     1             9 3                 12
1877035 1877035 NV     school 3200060 2   Clark 320006000294 2777 CC Detention   Alternative School No High 06 12 2019   grade_10 1.0 3.0 2.0                   5.0 1.0                       6 1 3 2                   5 1                 6
1877041 1877041 NV     school 3200060 2   Clark 320006000774 2910 Stewart Sch   Special Education School No Other PK 12 2019   grade_4 1.0 2.0 2.0     2.0       1.0     8.0                         8 1 2 2     2       1     8                   8

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