Data source: Big Local News · About: Big Local

475 rows where grade = "grade_12" and state = "NV" sorted by female_int

View and edit SQL

year

grade

  • grade_12 · 475
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
1841381 NV     school 3200060 2   Clark County 320006000108 2911 Variety JSHS   Special Education School No High 06 12 2021   grade_12 1 2 2   0 2       0 1   8 0   0.0                   8 1 2 2   0 2       0 1   8 0   0             8
1841392 NV     school 3200060 2   Clark County 320006000101 2913 Spring Mtn JSHS   Alternative School No High 06 12 2021   grade_12 2 3 5   0 0       0 1   11 0   0.0                   11 2 3 5   0 0       0 1   11 0   0             11
1841406 NV     school 3200060 2   Clark County 320006000518 2919 Summit View JSHS   Alternative School No High 06 12 2021   grade_12 6 4 6   0 0       0 1   17 0   0.0                   17 6 4 6   0 0       0 1   17 0   0             17
1841423 NV     school 3200060 2   Clark County 320006000683 2927 Desert Willow JSHS   Special Education School No High 06 12 2021   grade_12 0 0 0   0 0       0 1   1 0   0.0                   1 0 0 0   0 0       0 1   1 0   0             1
1841429 NV     school 3200060 2   Clark County 320006000499 2928 South Cont JSHS   Alternative School No High 06 12 2021   grade_12 0 2 2   0 0       0 0   4 0   0.0                   4 0 2 2   0 0       0 0   4 0   0             4
1841742 NV     school 3200150 5   Esmeralda 320015000943 5501 Esmeralda Virtual HS   Alternative School No High 09 12 2021   grade_12 0 0 1   0 0       0 0   1 0   0.0                   1 0 0 1   0 0       0 0   1 0   0             1
1842001 NV     school 3200300 10   Lyon 320030000768 10902 Eagle Ridge HS   Alternative School No High 07 12 2021   grade_12 0 0 2   0 0       0 0   2 0   0.0                   2 0 0 2   0 0       0 0   2 0   0             2
1842960 NV     school 3200510 17   White Pine 320051000606 17601 Lund JSHS   Regular School No High 06 12 2021   grade_12 2 0 0   0 0       0 1   3 0   0.0                   3 2 0 0   0 0       0 1   3 0   0             3
1843480 NV     school 3200023 79   Independence HS 320002300808 79903 Independence HS   Alternative School No High 06 12 2021   grade_12 2 5 4   1 0       0 0   12 0   0.0                   12 2 5 4   1 0       0 0   12 0   0             12
1708856 NV     school 3200060 2   Clark 320006000294 2777 CC Detention   Alternative School No High 06 12 2020   grade_12 3.0 20.0 10.0               1.0   33.0 1.0                       34 3 20 10               1   33 1                 34
1708930 NV     school 3200060 2   Clark 320006000499 2928 South Cont JSHS   Alternative School No High 06 12 2020   grade_12   2.0 1.0                   2.0 1.0                       3   2 1                   2 1                 3
1708936 NV     school 3200060 2   Clark 320006000597 2932 Cowan Behavior   Alternative School No High 06 12 2020   grade_12 2.0 2.0 1.0   1.0               5.0 1.0                       6 2 2 1   1               5 1                 6
1709610 NV     school 3200360 12   Nye 320036000190 12602 Gabbs HS   Regular School No High 09 12 2020   grade_12 1.0                   1.0   1.0 1.0                       2 1                   1   1 1                 2
1710401 NV     school 3200480 16   Washoe 320048000766 16917 Turning Point   Alternative School No Other 02 12 2020   grade_12 3.0         1.0         1.0   4.0 1.0                       5 3         1         1   4 1                 5
1710455 NV     school 3200510 17   White Pine 320051000606 17601 Lund Jr S HS   Regular School No High 06 12 2020   grade_12 1.0                         1.0                       1 1                         1                 1
1841361 NV     school 3200060 2   Clark County 320006000294 2777 CC Detention JSHS   Alternative School No High 06 12 2021   grade_12 3 10 6   0 0       0 1   19 1   0.0                   20 3 10 6   0 0       0 1   19 1   0             20
1841387 NV     school 3200060 2   Clark County 320006000020 2912 Juvenile Court   Alternative School No High 06 12 2021   grade_12 2 5 2   0 0       0 2   10 1   0.0                   11 2 5 2   0 0       0 2   10 1   0             11
1841399 NV     school 3200060 2   Clark County 320006000694 2916 Miley Achvmt SEC   Special Education School No High 06 12 2021   grade_12 4 1 2   0 0       0 0   6 1   0.0                   7 4 1 2   0 0       0 0   6 1   0             7
1841435 NV     school 3200060 2   Clark County 320006000597 2932 Cowan Behavior   Alternative School No High 06 12 2021   grade_12 0 1 1   1 0       0 0   2 1   0.0                   3 0 1 1   1 0       0 0   2 1   0             3
1841441 NV     school 3200060 2   Clark County 320006000598 2933 Peterson Behavior   Alternative School No High 06 12 2021   grade_12 0 3 2   0 1       0 0   5 1   0.0                   6 0 3 2   0 1       0 0   5 1   0             6
1841447 NV     school 3200060 2   Clark County 320006000795 2941 Adult Ed   Alternative School No High 12 12 2021   grade_12 0 0 1   0 0       0 0   0 1   0.0                   1 0 0 1   0 0       0 0   0 1   0             1
1841527 NV     school 3200090 3   Douglas 320009000348 3503 Jacobsen HS   Alternative School No High 07 12 2021   grade_12 3 0 2   0 0       1 1   6 1   0.0                   7 3 0 2   0 0       1 1   6 1   0             7
1877037 NV     school 3200060 2   Clark 320006000294 2777 CC Detention   Alternative School No High 06 12 2019   grade_12 4.0 16.0 5.0             1.0 3.0   28.0 1.0                       29 4 16 5             1 3   28 1                 29
1877110 NV     school 3200060 2   Clark 320006000499 2928 South Cont JSHS   Alternative School No High 06 12 2019   grade_12   2.0 2.0               1.0   4.0 1.0                       5   2 2               1   4 1                 5
1877117 NV     school 3200060 2   Clark 320006000597 2932 Cowan Behavior   Alternative School No High 06 12 2019   grade_12 3.0 2.0 3.0                   7.0 1.0                       8 3 2 3                   7 1                 8
1877123 NV     school 3200060 2   Clark 320006000598 2933 Peterson Behavior   Alternative School No High 06 12 2019   grade_12 1.0 2.0 5.0               1.0   8.0 1.0                       9 1 2 5               1   8 1                 9
1877129 NV     school 3200060 2   Clark 320006000795 2941 Adult Ed   Alternative School No High 12 12 2019   grade_12     2.0                   1.0 1.0                       2     2                   1 1                 2
1877674 NV     school 3200300 10   Lyon 320030000768 10902 Western NV Yth Ct   Alternative School No High 07 12 2019   grade_12 1.0       1.0               1.0 1.0                       2 1       1               1 1                 2
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
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
1708882 NV     school 3200060 2   Clark 320006000020 2912 Juvenile Court   Alternative School No High 06 12 2020   grade_12 4.0 2.0 3.0                   7.0 2.0                       9 4 2 3                   7 2                 9
1708896 NV     school 3200060 2   Clark 320006000694 2916 Miley Achvmt SEC   Special Education School No High 06 12 2020   grade_12 2.0 3.0 2.0                   5.0 2.0                       7 2 3 2                   5 2                 7
1709489 NV     school 3200300 10   Lyon 320030000768 10902 Western NV Yth Ct   Alternative School No High 07 12 2020   grade_12 3.0                       1.0 2.0                       3 3                       1 2                 3
1710387 NV     school 3200480 16   Washoe 320048000233 16911 Picollo Sch   Special Education School No Other PK 12 2020   grade_12 2.0 2.0 5.0                   7.0 2.0                       9 2 2 5                   7 2                 9
1841455 NV     school 3200060 2   Clark County 320006000878 2957 Mission HS   Alternative School No High 06 12 2021   grade_12 5 0 6   0 0       0 0   9 2   0.0                   11 5 0 6   0 0       0 0   9 2   0             11
1841691 NV     school 3200120 4   Elko 320012000579 4605 Jackpot HS   Regular School No High 09 12 2021   grade_12 2 0 8   0 0       0 0   8 2   0.0                   10 2 0 8   0 0       0 0   8 2   0             10
1842123 NV     school 3200360 12   Nye 320036000190 12602 Gabbs HS   Regular School No High 09 12 2021   grade_12 0 0 0   2 0       0 0   0 2   0.0                   2 0 0 0   2 0       0 0   0 2   0             2
1842834 NV     school 3200480 16   Washoe County 320048000217 16601 Gerlach K 12   Regular School No Other PK 12 2021   grade_12 1 0 1   0 0       0 0   0 2   0.0                   2 1 0 1   0 0       0 0   0 2   0             2
1842906 NV     school 3200480 16   Washoe County 320048000766 16917 Turning Point   Alternative School No Other 02 12 2021   grade_12 5 0 1   0 0       0 0   4 2   0.0                   6 5 0 1   0 0       0 0   4 2   0             6
1877057 NV     school 3200060 2   Clark 320006000108 2911 Variety School E SEC   Special Education School No High 06 12 2019   grade_12 8.0 1.0 3.0     4.0         1.0   15.0 2.0                       17 8 1 3     4         1   15 2                 17
1877079 NV     school 3200060 2   Clark 320006000694 2916 Miley Achvmt SEC   Special Education School No High 06 12 2019   grade_12 1.0 4.0 2.0     1.0             6.0 2.0                       8 1 4 2     1             6 2                 8
1877495 NV     school 3200210 7   Humboldt 320021000154 7601 McDermitt HS   Regular School No High 09 12 2019   grade_12 1.0   3.0   3.0               5.0 2.0                       7 1   3   3               5 2                 7
1708876 NV     school 3200060 2   Clark 320006000108 2911 Variety School E SEC   Special Education School No High 06 12 2020   grade_12 2.0 1.0 5.0     1.0         1.0   7.0 3.0                       10 2 1 5     1         1   7 3                 10
1709031 NV     school 3200090 3   Douglas 320009000348 3503 Jacobsen HS   Alternative School No High 07 12 2020   grade_12 1.0   3.0   3.0               4.0 3.0                       7 1   3   3               4 3                 7
1709197 NV     school 3200120 4   Elko 320012000839 4610 NNVVirtual   Regular School No Other KG 12 2020   grade_12 10.0   1.0                   8.0 3.0                       11 10   1                   8 3                 11
1709311 NV     school 3200210 7   Humboldt 320021000154 7601 McDermitt HS   Regular School No High 09 12 2020   grade_12 1.0       4.0               2.0 3.0                       5 1       4               2 3                 5
1710362 NV     school 3200480 16   Washoe 320048000562 16608 Acad for Career E   Regular School Yes High 09 12 2020   grade_12 26.0   21.0             1.0 4.0   49.0 3.0                       52 26   21             1 4   49 3                 52
1840331 NV     school 3200060 2   Clark County 320006000384 2215 Miller John ES   Special Education School No Other PK 12 2021   grade_12 2 3 2   0 0       0 0   4 3   0.0                   7 2 3 2   0 0       0 0   4 3   0             7
1842893 NV     school 3200480 16   Washoe County 320048000233 16911 Picollo K 12   Special Education School No Other PK 12 2021   grade_12 4 1 4   0 1       0 0   7 3   0.0                   10 4 1 4   0 1       0 0   7 3   0             10
1877210 NV     school 3200090 3   Douglas 320009000348 3503 Jacobsen HS   Alternative School No High 07 12 2019   grade_12 5.0   4.0               1.0   7.0 3.0                       10 5   4               1   7 3                 10
1878611 NV     school 3200480 16   Washoe 320048000766 16917 Turning Point   Alternative School No Other 01 12 2019   grade_12 7.0   3.0     1.0             8.0 3.0                       11 7   3     1             8 3                 11
1707831 NV     school 3200060 2   Clark 320006000384 2215 Miller Sch   Special Education School No Other PK 12 2020   grade_12     4.0     1.0             1.0 4.0                       5     4     1             1 4                 5
1708772 NV     school 3200060 2   Clark 320006000686 2604 Indian Springs HS   Regular School No High 09 12 2020   grade_12 9.0   1.0   1.0               7.0 4.0                       11 9   1   1               7 4                 11
1708868 NV     school 3200060 2   Clark 320006000774 2910 Stewart Sch   Special Education School No Other PK 12 2020   grade_12 3.0 3.0 3.0     2.0         1.0   8.0 4.0                       12 3 3 3     2         1   8 4                 12
1710458 NV     school 3200510 17   White Pine 320051000483 17903 Steptoe Vly HS   Alternative School No High 09 12 2020   grade_12 8.0 1.0 2.0                   7.0 4.0                       11 8 1 2                   7 4                 11
1710950 NV     school 3200021 84   University Schools 320002100680 19406 Davidson Acad   Regular School No High 05 12 2020   grade_12 12.0   2.0     7.0             17.0 4.0                       21 12   2     7             17 4                 21
1841269 NV     school 3200060 2   Clark County 320006000686 2604 Indian Springs HS   Regular School No High 09 12 2021   grade_12 9 0 2   0 0       0 2   9 4   0.0                   13 9 0 2   0 0       0 2   9 4   0             13
1841826 NV     school 3200210 7   Humboldt 320021000154 7601 McDermitt HS   Regular School No High 09 12 2021   grade_12 0 0 2   5 0       0 0   3 4   0.0                   7 0 0 2   5 0       0 0   3 4   0             7
1877065 NV     school 3200060 2   Clark 320006000020 2912 Juvenile Court   Alternative School No High 06 12 2019   grade_12 4.0 6.0 5.0               1.0   12.0 4.0                       16 4 6 5               1   12 4                 16
1877376 NV     school 3200120 4   Elko 320012000839 4610 NNVVirtual   Regular School No Other KG 12 2019   grade_12 3.0   2.0                   1.0 4.0                       5 3   2                   1 4                 5
1879095 NV     school 3200001 104   NV State HS II 320000100924 104101 NSHS Meadowood   Regular School Yes High 11 12 2019   grade_12 7.0         1.0       1.0     5.0 4.0                       9 7         1       1     5 4                 9
1841097 NV     school 3200060 2   Clark County 320006000749 2363 Innovations SEC   Regular School Yes High 06 12 2021   grade_12 2 1 17   0 1       0 1   17 5   0.0                   22 2 1 17   0 1       0 1   17 5   0             22
1841311 NV     school 3200060 2   Clark County 320006000707 2616 Expl Knowledge SEC   Regular School Yes High 06 12 2021   grade_12 5 0 6   0 2       0 2   10 5   0.0                   15 5 0 6   0 2       0 2   10 5   0             15
1841372 NV     school 3200060 2   Clark County 320006000774 2910 Stewart ES   Special Education School No Other PK 12 2021   grade_12 3 10 1   0 0       1 2   12 5   0.0                   17 3 10 1   0 0       1 2   12 5   0             17
1841674 NV     school 3200120 4   Elko 320012000568 4601 Carlin HS   Regular School No High 09 12 2021   grade_12 11 0 2   1 0       0 0   9 5   0.0                   14 11 0 2   1 0       0 0   9 5   0             14
1842964 NV     school 3200510 17   White Pine 320051000483 17903 Steptoe Valley HS   Alternative School No High 09 12 2021   grade_12 8 1 2   2 0       0 0   8 5   0.0                   13 8 1 2   2 0       0 0   8 5   0             13
1876013 NV     school 3200060 2   Clark 320006000384 2215 Miller Sch   Special Education School No Other PK 12 2019   grade_12 2.0   5.0     1.0             3.0 5.0                       8 2   5     1             3 5                 8
1877355 NV     school 3200120 4   Elko 320012000579 4605 Jackpot HS   Regular School No High 09 12 2019   grade_12 2.0   8.0                   5.0 5.0                       10 2   8                   5 5                 10
1709163 NV     school 3200120 4   Elko 320012000568 4601 Carlin HS   Regular School No High 09 12 2020   grade_12 10.0   2.0   1.0               7.0 6.0                       13 10   2   1               7 6                 13
1709180 NV     school 3200120 4   Elko 320012000579 4605 Jackpot HS   Regular School No High 09 12 2020   grade_12 1.0   12.0               1.0   8.0 6.0                       14 1   12               1   8 6                 14
1709245 NV     school 3200180 6   Eureka 320018000148 6601 Eureka Co   Regular School No High 07 12 2020   grade_12 13.0   1.0                   8.0 6.0                       14 13   1                   8 6                 14
1842867 NV     school 3200480 16   Washoe County 320048000562 16608 ACE ACAD   Regular School Yes High 09 12 2021   grade_12 28 0 15   0 1       0 1   39 6   0.0                   45 28 0 15   0 1       0 1   39 6   0             45
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
1877049 NV     school 3200060 2   Clark 320006000774 2910 Stewart Sch   Special Education School No Other PK 12 2019   grade_12 5.0 1.0 4.0     3.0             7.0 6.0                       13 5 1 4     3             7 6                 13
1877342 NV     school 3200120 4   Elko 320012000622 4602 Wells HS HS   Regular School No High 09 12 2019   grade_12 9.0   6.0   1.0               10.0 6.0                       16 9   6   1               10 6                 16
1877813 NV     school 3200360 12   Nye 320036000363 12605 Round Mtn   Regular School No High 09 12 2019   grade_12 10.0   4.0                   8.0 6.0                       14 10   4                   8 6                 14
1709623 NV     school 3200360 12   Nye 320036000363 12605 Round Mtn   Regular School No High 09 12 2020   grade_12 9.0   4.0   2.0               8.0 7.0                       15 9   4   2               8 7                 15
1710579 NV     school 3200001 51   Founders Academy of Nevada 320000100843 51430 Founders ACAD   Regular School Yes Other KG 12 2020   grade_12 7.0 1.0 8.0                   9.0 7.0                       16 7 1 8                   9 7                 16
1841417 NV     school 3200060 2   Clark County 320006000329 2924 Cowan Sunset SE   Alternative School No High 09 12 2021   grade_12 5 1 4   0 0       0 3   6 7   0.0                   13 5 1 4   0 0       0 3   6 7   0             13
1841531 NV     school 3200090 3   Douglas 320009000832 3504 ASPIRE HS   Alternative School No High 09 12 2021   grade_12 17 0 3   1 0       0 0   14 7   0.0                   21 17 0 3   1 0       0 0   14 7   0             21
1841687 NV     school 3200120 4   Elko 320012000610 4604 Owyhee HS   Regular School No High 09 12 2021   grade_12 1 0 0   15 1       0 0   10 7   0.0                   17 1 0 0   15 1       0 0   10 7   0             17
1841896 NV     school 3200270 9   Lincoln 320027000169 9602 C O Bastian   Alternative School No High 07 12 2021   grade_12 7 3 3   0 1       0 0   7 7   0.0                   14 7 3 3   0 1       0 0   7 7   0             14
1841981 NV     school 3200300 10   Lyon 320030000178 10602 Smith Valley Combined   Regular School No Other PK 12 2021   grade_12 20 0 5   0 0       1 1   20 7   0.0                   27 20 0 5   0 0       1 1   20 7   0             27
1876643 NV     school 3200060 2   Clark 320006000304 2320 Sandy Valley   Regular School No High 06 12 2019   grade_12 8.0 1.0 5.0     1.0             8.0 7.0                       15 8 1 5     1             8 7                 15
1877138 NV     school 3200060 2   Clark 320006000878 2957 Mission HS   Alternative School No High 06 12 2019   grade_12 2.0 3.0 5.0             1.0 1.0   5.0 7.0                       12 2 3 5             1 1   5 7                 12
1877428 NV     school 3200180 6   Eureka 320018000148 6601 Eureka Co   Regular School No High 07 12 2019   grade_12 9.0   1.0   4.0               7.0 7.0                       14 9   1   4               7 7                 14
1878570 NV     school 3200480 16   Washoe 320048000562 16608 Acad for Career E   Regular School Yes High 09 12 2019   grade_12 21.0 2.0 21.0               3.0   40.0 7.0                       47 21 2 21               3   40 7                 47
1841763 NV     school 3200180 6   Eureka 320018000148 6601 Eureka HS   Regular School No High 07 12 2021   grade_12 11 0 0   3 0       0 0   6 8   0.0                   14 11 0 0   3 0       0 0   6 8   0             14
1842136 NV     school 3200360 12   Nye 320036000363 12605 Round Mtn HS   Regular School No High 09 12 2021   grade_12 14 0 2   1 0       0 1   10 8   0.0                   18 14 0 2   1 0       0 1   10 8   0             18
1877337 NV     school 3200120 4   Elko 320012000568 4601 Carlin HS   Regular School No High 09 12 2019   grade_12 18.0   3.0   1.0               14.0 8.0                       22 18   3   1               14 8                 22
1877351 NV     school 3200120 4   Elko 320012000610 4604 Owyhee HS   Regular School No High 09 12 2019   grade_12         14.0               6.0 8.0                       14         14               6 8                 14
1877653 NV     school 3200300 10   Lyon 320030000178 10602 Smith Valley Sch   Regular School No Other PK 12 2019   grade_12 12.0   5.0                   9.0 8.0                       17 12   5                   9 8                 17
1708460 NV     school 3200060 2   Clark 320006000304 2320 Sandy Valley   Regular School No High 06 12 2020   grade_12 5.0 1.0 11.0             1.0     9.0 9.0                       18 5 1 11             1     9 9                 18
1709176 NV     school 3200120 4   Elko 320012000610 4604 Owyhee HS   Regular School No High 09 12 2020   grade_12 1.0       14.0         1.0     7.0 9.0                       16 1       14         1     7 9                 16
1709381 NV     school 3200270 9   Lincoln 320027000169 9602 C O Bastian   Alternative School No High 07 12 2020   grade_12 7.0 6.0 8.0     1.0         2.0   15.0 9.0                       24 7 6 8     1         2   15 9                 24
1709742 NV     school 3200450 15   Storey 320045000199 15601 Virginia City HS   Regular School No High 09 12 2020   grade_12 14.0   3.0               2.0   10.0 9.0                       19 14   3               2   10 9                 19
1841409 NV     school 3200060 2   Clark County 320006000313 2922 Burk Horizon SW HS   Alternative School No High 09 12 2021   grade_12 3 6 13   0 2       0 0   15 9   0.0                   24 3 6 13   0 2       0 0   15 9   0             24
1841522 NV     school 3200090 3   Douglas 320009000122 3502 Whittell HS   Regular School No High 07 12 2021   grade_12 13 1 6   0 0       0 1   12 9   0.0                   21 13 1 6   0 0       0 1   12 9   0             21
1843097 NV     school 3200001 51   Founders Academy of Las Vegas 320000100843 51430 Founders ACAD   Regular School Yes Other KG 12 2021   grade_12 10 0 8   0 0       0 1   10 9   0.0                   19 10 0 8   0 0       0 1   10 9   0             19
1877931 NV     school 3200450 15   Storey 320045000199 15601 Virginia City HS   Regular School No High 09 12 2019   grade_12 24.0   2.0     1.0       1.0     19.0 9.0                       28 24   2     1       1     19 9                 28

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