Data source: Big Local News · About: Big Local

673 rows where grade = "grade_6" and state = "NV" sorted by asian

View and edit SQL

year

grade

  • grade_6 · 673
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
1706767 NV     school 3200030 1   Churchill 320003000431 1207 Numa   Regular School No Elementary 03 06 2020   grade_6 1.0   1.0                   2.0                         2 1   1                   2                   2
1708439 NV     school 3200060 2   Clark 320006000025 2315 Robison MS   Regular School No Middle 06 08 2020   grade_6 16.0 47.0 367.0   5.0           9.0   218.0 226.0                       444 16 47 367   5           9   218 226                 444
1708454 NV     school 3200060 2   Clark 320006000304 2320 Sandy Valley   Regular School No High 06 12 2020   grade_6 6.0 4.0 18.0             1.0 3.0   19.0 13.0                       32 6 4 18             1 3   19 13                 32
1708491 NV     school 3200060 2   Clark 320006000275 2329 Lyon   Regular School No Middle 06 08 2020   grade_6 114.0   22.0   2.0           4.0   84.0 58.0                       142 114   22   2           4   84 58                 142
1708517 NV     school 3200060 2   Clark 320006000699 2336 Indian Springs   Regular School No Middle 06 08 2020   grade_6 10.0 1.0 5.0               2.0   9.0 9.0                       18 10 1 5               2   9 9                 18
1708592 NV     school 3200060 2   Clark 320006000749 2363 Innovations SEC   Regular School Yes High 06 12 2020   grade_6 7.0 8.0 58.0               2.0   45.0 30.0                       75 7 8 58               2   45 30                 75
1708599 NV     school 3200060 2   Clark 320006000756 2364 100 Academy 6-8 MS   Regular School Yes Middle 06 08 2020   grade_6 2.0 38.0 17.0   2.0         1.0     32.0 28.0                       60 2 38 17   2         1     32 28                 60
1708602 NV     school 3200060 2   Clark 320006000855 2367 RainbowDreamAC MS   Regular School Yes Middle 06 08 2020   grade_6 2.0 22.0 7.0               1.0   11.0 21.0                       32 2 22 7               1   11 21                 32
1708830 NV     school 3200060 2   Clark 320006000745 2621 Delta Charter   Regular School Yes High 06 12 2020   grade_6 8.0 6.0 12.0             2.0 3.0   14.0 17.0                       31 8 6 12             2 3   14 17                 31
1708862 NV     school 3200060 2   Clark 320006000774 2910 Stewart Sch   Special Education School No Other PK 12 2020   grade_6 1.0 2.0 1.0                   4.0                         4 1 2 1                   4                   4
1708890 NV     school 3200060 2   Clark 320006000694 2916 Miley Achvmt SEC   Special Education School No High 06 12 2020   grade_6 2.0 8.0 3.0               1.0   12.0 2.0                       14 2 8 3               1   12 2                 14
1708924 NV     school 3200060 2   Clark 320006000499 2928 South Cont JSHS   Alternative School No High 06 12 2020   grade_6 1.0 1.0 1.0                   2.0 1.0                       3 1 1 1                   2 1                 3
1708937 NV     school 3200060 2   Clark 320006000598 2933 Peterson Behavior   Alternative School No High 06 12 2020   grade_6   2.0                     2.0                         2   2                     2                   2
1708974 NV     school 3200090 3   Douglas 320009000124 3202 Zephyr Cove   Regular School No Elementary PK 06 2020   grade_6 13.0   4.0               1.0   13.0 5.0                       18 13   4               1   13 5                 18
1709013 NV     school 3200090 3   Douglas 320009000422 3302 Pau Wa Lu   Regular School No Middle 06 08 2020   grade_6 123.0   46.0   9.0         1.0 11.0   99.0 91.0                       190 123   46   9         1 11   99 91                 190
1709052 NV     school 3200120 4   Elko 320012000132 4105 Jackpot ES   Regular School No Elementary KG 06 2020   grade_6 3.0   9.0             1.0 1.0   7.0 7.0                       14 3   9             1 1   7 7                 14
1709058 NV     school 3200120 4   Elko 320012000134 4108 Mound Vly ES   Regular School No Elementary KG 08 2020   grade_6 3.0                         3.0                       3 3                         3                 3
1709098 NV     school 3200120 4   Elko 320012000125 4205 Carlin ES   Regular School No Elementary PK 06 2020   grade_6 30.0   3.0               2.0   22.0 13.0                       35 30   3               2   22 13                 35
1709105 NV     school 3200120 4   Elko 320012000727 4206 Owyhee ES   Regular School No Elementary PK 06 2020   grade_6         19.0               12.0 7.0                       19         19               12 7                 19
1709120 NV     school 3200120 4   Elko 320012000308 4208 West Wendover ES ES   Regular School No Elementary PK 06 2020   grade_6 20.0 1.0 65.0   1.0               49.0 38.0                       87 20 1 65   1               49 38                 87
1709191 NV     school 3200120 4   Elko 320012000839 4610 NNVVirtual   Regular School No Other KG 12 2020   grade_6 2.0                   1.0     3.0                       3 2                   1     3                 3
1709205 NV     school 3200150 5   Esmeralda 320015000143 5101 Dyer ES   Regular School No Elementary PK 08 2020   grade_6 1.0   4.0   2.0               3.0 4.0                       7 1   4   2               3 4                 7
1709213 NV     school 3200150 5   Esmeralda 320015000144 5102 Goldfield ES   Regular School No Elementary PK 08 2020   grade_6 4.0                       3.0 1.0                       4 4                       3 1                 4
1709229 NV     school 3200180 6   Eureka 320018000146 6101 Crescent Vly   Regular School No Elementary PK 06 2020   grade_6 3.0   2.0               1.0   3.0 3.0                       6 3   2               1   3 3                 6
1709237 NV     school 3200180 6   Eureka 320018000147 6103 Eureka   Regular School No Elementary PK 06 2020   grade_6 20.0   2.0               2.0   11.0 13.0                       24 20   2               2   11 13                 24
1709254 NV     school 3200210 7   Humboldt 320021000151 7103 Kings River ES   Regular School No Elementary PK 08 2020   grade_6 1.0   1.0                   1.0 1.0                       2 1   1                   1 1                 2
1709261 NV     school 3200210 7   Humboldt 320021000155 7104 Orovada ES   Regular School No Elementary PK 08 2020   grade_6 3.0                       2.0 1.0                       3 3                       2 1                 3
1709270 NV     school 3200210 7   Humboldt 320021000156 7105 Paradise Vly ES   Regular School No Elementary PK 08 2020   grade_6 1.0   1.0                     2.0                       2 1   1                     2                 2
1709289 NV     school 3200210 7   Humboldt 320021000153 7203 McDermitt ES   Regular School No Elementary PK 06 2020   grade_6         14.0               8.0 6.0                       14         14               8 6                 14
1709330 NV     school 3200240 8   Lander 320024000162 8602 Austin School   Regular School No Other PK 12 2020   grade_6     1.0                     1.0                       1     1                     1                 1
1709345 NV     school 3200270 9   Lincoln 320027000166 9201 Caliente ES   Regular School No Elementary PK 06 2020   grade_6 12.0   1.0               1.0   10.0 4.0                       14 12   1               1   10 4                 14
1709353 NV     school 3200270 9   Lincoln 320027000172 9202 Panaca ES   Regular School No Elementary PK 06 2020   grade_6 9.0   4.0                   7.0 6.0                       13 9   4                   7 6                 13
1709361 NV     school 3200270 9   Lincoln 320027000173 9203 Pioche ES   Regular School No Elementary PK 06 2020   grade_6 10.0                       1.0 9.0                       10 10                       1 9                 10
1709366 NV     school 3200270 9   Lincoln 320027000423 9302 Pahranagat Vly MS   Regular School No Middle 06 08 2020   grade_6 21.0   1.0                   9.0 13.0                       22 21   1                   9 13                 22
1709388 NV     school 3200300 10   Lyon 320030000174 10201 Dayton   Regular School No Elementary PK 06 2020   grade_6 45.0   13.0   2.0           1.0   38.0 23.0                       61 45   13   2           1   38 23                 61
1709428 NV     school 3200300 10   Lyon 320030000450 10210 Sutro   Regular School No Elementary PK 06 2020   grade_6 40.0   12.0   1.0           2.0   30.0 25.0                       55 40   12   1           2   30 25                 55
1709448 NV     school 3200300 10   Lyon 320030000424 10304 Silver Stage MS   Regular School No Middle 05 08 2020   grade_6 56.0 1.0 16.0   1.0           6.0   43.0 37.0                       80 56 1 16   1           6   43 37                 80
1709463 NV     school 3200300 10   Lyon 320030000178 10602 Smith Valley Sch   Regular School No Other PK 12 2020   grade_6 15.0   3.0                   12.0 6.0                       18 15   3                   12 6                 18
1709496 NV     school 3200330 11   Mineral 320033000811 11201 Hawthorne E.S. ES   Regular School No Elementary PK 06 2020   grade_6 18.0 2.0 8.0   2.0           2.0   19.0 13.0                       32 18 2 8   2           2   19 13                 32
1709504 NV     school 3200330 11   Mineral 320033000184 11202 Schurz ES   Regular School No Elementary PK 06 2020   grade_6     1.0   5.0               1.0 5.0                       6     1   5               1 5                 6
1709509 NV     school 3200330 11   Mineral 320033000183 11601 Mineral Co HS   Regular School No High 09 12 2020   grade_6 1.0                       1.0                         1 1                       1                   1
1709581 NV     school 3200360 12   Nye 320036000871 12211 Warm Springs   Regular School No Elementary PK 08 2020   grade_6 1.0                       1.0                         1 1                       1                   1
1709586 NV     school 3200360 12   Nye 320036000566 12311 Beatty   Regular School No Middle 06 08 2020   grade_6 6.0   4.0             1.0     6.0 5.0                       11 6   4             1     6 5                 11
1709592 NV     school 3200360 12   Nye 320036000611 12313 Round Mtn   Regular School No Middle 06 08 2020   grade_6 16.0   4.0                   10.0 10.0                       20 16   4                   10 10                 20
1709595 NV     school 3200360 12   Nye 320036000575 12315 Gabbs MS   Regular School No Middle 06 08 2020   grade_6 3.0       2.0               2.0 3.0                       5 3       2               2 3                 5
1709598 NV     school 3200360 12   Nye 320036000564 12316 Amargosa Vly MS   Regular School No Middle 06 08 2020   grade_6 3.0   8.0             1.0     7.0 5.0                       12 3   8             1     7 5                 12
1709601 NV     school 3200360 12   Nye 320036000729 12317 Duckwater MS   Regular School No Middle 06 08 2020   grade_6     1.0   1.0           1.0     3.0                       3     1   1           1     3                 3
1709628 NV     school 3200360 12   Nye 320036000556 12607 Pathways MS ALT   Alternative School No Middle 06 08 2020   grade_6 6.0 1.0                     6.0 1.0                       7 6 1                     6 1                 7
1709714 NV     school 3200420 14   Pershing 320042000167 14301 Pershing MS   Regular School No Middle 06 08 2020   grade_6 18.0   26.0   9.0           5.0   31.0 27.0                       58 18   26   9           5   31 27                 58
1709736 NV     school 3200450 15   Storey 320045000365 15301 Virginia City MS   Regular School No Middle 06 08 2020   grade_6 34.0 1.0 2.0               1.0   20.0 18.0                       38 34 1 2               1   20 18                 38
1709756 NV     school 3200480 16   Washoe 320048000209 16202 Loder ES   Regular School No Elementary PK 06 2020   grade_6 6.0 2.0 70.0   1.0         1.0 2.0   46.0 36.0                       82 6 2 70   1         1 2   46 36                 82
1709849 NV     school 3200480 16   Washoe 320048000242 16215 Corbett ES   Regular School No Elementary PK 06 2020   grade_6 4.0 1.0 53.0               1.0   37.0 22.0                       59 4 1 53               1   37 22                 59
1709857 NV     school 3200480 16   Washoe 320048000243 16216 Gomm   Regular School No Elementary PK 06 2020   grade_6 35.0   3.0               6.0   21.0 23.0                       44 35   3               6   21 23                 44
1710057 NV     school 3200480 16   Washoe 320048000316 16258 Dodson   Regular School No Elementary PK 06 2020   grade_6 16.0 2.0 41.0   1.0           1.0   41.0 20.0                       61 16 2 41   1           1   41 20                 61
1710157 NV     school 3200480 16   Washoe 320048000452 16272 Donner Spgs   Regular School No Elementary PK 06 2020   grade_6 15.0   46.0   2.0         1.0 8.0   43.0 29.0                       72 15   46   2         1 8   43 29                 72
1710236 NV     school 3200480 16   Washoe 320048000318 16309 Incline   Regular School No Middle 06 08 2020   grade_6 22.0   30.0   1.0               30.0 23.0                       53 22   30   1               30 23                 53
1710299 NV     school 3200480 16   Washoe 320048000822 16507 Inspire   Alternative School No Other PK 12 2020   grade_6   1.0                     1.0                         1   1                     1                   1
1710381 NV     school 3200480 16   Washoe 320048000233 16911 Picollo Sch   Special Education School No Other PK 12 2020   grade_6 3.0   1.0               1.0   5.0                         5 3   1               1   5                   5
1710395 NV     school 3200480 16   Washoe 320048000766 16917 Turning Point   Alternative School No Other 02 12 2020   grade_6 2.0 1.0 3.0                   6.0                         6 2 1 3                   6                   6
1710408 NV     school 3200480 16   Washoe 320048000844 16923 North Star   Alternative School No Other PK 12 2020   grade_6 9.0   3.0               1.0   6.0 7.0                       13 9   3               1   6 7                 13
1710449 NV     school 3200510 17   White Pine 320051000606 17601 Lund Jr S HS   Regular School No High 06 12 2020   grade_6 5.0                       3.0 2.0                       5 5                       3 2                 5
1710505 NV     school 3200001 44   Mater Academy Northern Nevada 320000100896 44437 Mater North NV   Regular School Yes Elementary KG 08 2020   grade_6 4.0 6.0 27.0   1.0           2.0   18.0 22.0                       40 4 6 27   1           2   18 22                 40
1710514 NV     school   46   Democracy Prep   46200 DP Agassi MS             2020   grade_6 3.0 73.0 37.0               3.0   53.0 63.0                       116 3 73 37               3   53 63                 116
1710528 NV     school 3200001 48   Equipo Academy 320000100856 48433 Equipo ACAD   Regular School Yes High 06 12 2020   grade_6 3.0 2.0 103.0                   52.0 56.0                       108 3 2 103                   52 56                 108
1710581 NV     school 3200001 52   Leadership Academy of Nevada 320000100886 52429 Leadership ACAD   Regular School Yes High 06 12 2020   grade_6 20.0 1.0 4.0               1.0   20.0 6.0                       26 20 1 4               1   20 6                 26
1710593 NV     school 3200001 54   Learning Bridge 320000100833 54428 Learning Bridge   Regular School Yes Elementary KG 08 2020   grade_6 13.0   6.0               1.0   12.0 8.0                       20 13   6               1   12 8                 20
1710651 NV     school 3200001 57   Honors Academy of Literature 320000100826 57424 Honors ACAD   Regular School Yes Elementary KG 08 2020   grade_6 22.0   3.0             1.0     15.0 11.0                       26 22   3             1     15 11                 26
1710751 NV     school 3200001 59   Somerset Academy 320000100910 59123 Somerset Steph   Regular School Yes Elementary KG 08 2020   grade_6 43.0 14.0 38.0   1.0         1.0 17.0   61.0 53.0                       114 43 14 38   1         1 17   61 53                 114
1710778 NV     school 3200001 61   Discovery Charter 320000100885 61415 Discovery Mesa   Regular School Yes Elementary KG 08 2020   grade_6 2.0 1.0 2.0               2.0   3.0 4.0                       7 2 1 2               2   3 4                 7
1710787 NV     school 3200001 61   Discovery Charter 320000100818 61417 Discovery HillPt   Regular School Yes Elementary KG 08 2020   grade_6 17.0 5.0 4.0   1.0         1.0 3.0   12.0 19.0                       31 17 5 4   1         1 3   12 19                 31
1710928 NV     school   102   NV Prep   102100 NV Prep             2020   grade_6 11.0 12.0 39.0                   24.0 38.0                       62 11 12 39                   24 38                 62
1710944 NV     school 3200021 84   University Schools 320002100680 19406 Davidson Acad   Regular School No High 05 12 2020   grade_6 4.0 1.0 2.0               2.0   6.0 3.0                       9 4 1 2               2   6 3                 9
1874962 NV     school 3200030 1   Churchill 320003000431 1207 Numa   Regular School No Elementary 02 06 2019   grade_6 1.0                         1.0                       1 1                         1                 1
1876592 NV     school 3200060 2   Clark 320006000051 2305 Smith MS   Regular School No Middle 06 08 2019   grade_6 6.0 31.0 276.0   2.0           3.0   154.0 164.0                       318 6 31 276   2           3   154 164                 318
1876644 NV     school 3200060 2   Clark 320006000408 2321 Laughlin JSHS   Regular School No High 06 12 2019   grade_6 25.0 2.0 20.0               8.0   29.0 26.0                       55 25 2 20               8   29 26                 55
1876672 NV     school 3200060 2   Clark 320006000275 2329 Lyon   Regular School No Middle 06 08 2019   grade_6 101.0 2.0 25.0   4.0           2.0   63.0 71.0                       134 101 2 25   4           2   63 71                 134
1876698 NV     school 3200060 2   Clark 320006000699 2336 Indian Springs   Regular School No Middle 06 08 2019   grade_6 13.0   3.0   1.0           2.0   10.0 9.0                       19 13   3   1           2   10 9                 19
1876773 NV     school 3200060 2   Clark 320006000749 2363 Innovations SEC   Regular School Yes High 06 12 2019   grade_6 6.0 12.0 45.0             2.0 5.0   32.0 38.0                       70 6 12 45             2 5   32 38                 70
1876783 NV     school 3200060 2   Clark 320006000855 2367 RainbowDreamAC MS   Regular School Yes Middle 06 08 2019   grade_6   27.0 4.0             1.0 4.0   15.0 21.0                       36   27 4             1 4   15 21                 36
1877011 NV     school 3200060 2   Clark 320006000745 2621 Delta Charter   Regular School Yes High 06 12 2019   grade_6 13.0 11.0 14.0               2.0   16.0 24.0                       40 13 11 14               2   16 24                 40
1877028 NV     school 3200060 2   Clark 320006000845 2625 NV LRN Academy   Regular School No High 06 12 2019   grade_6 2.0 4.0                 1.0   2.0 5.0                       7 2 4                 1   2 5                 7
1877043 NV     school 3200060 2   Clark 320006000774 2910 Stewart Sch   Special Education School No Other PK 12 2019   grade_6 4.0 2.0 2.0               1.0   5.0 4.0                       9 4 2 2               1   5 4                 9
1877059 NV     school 3200060 2   Clark 320006000020 2912 Juvenile Court   Alternative School No High 06 12 2019   grade_6 1.0                       1.0                         1 1                       1                   1
1877073 NV     school 3200060 2   Clark 320006000694 2916 Miley Achvmt SEC   Special Education School No High 06 12 2019   grade_6 4.0 5.0 1.0               2.0   10.0 2.0                       12 4 5 1               2   10 2                 12
1877104 NV     school 3200060 2   Clark 320006000499 2928 South Cont JSHS   Alternative School No High 06 12 2019   grade_6 1.0 5.0 2.0                   3.0 5.0                       8 1 5 2                   3 5                 8
1877111 NV     school 3200060 2   Clark 320006000597 2932 Cowan Behavior   Alternative School No High 06 12 2019   grade_6   1.0                       1.0                       1   1                       1                 1
1877191 NV     school 3200090 3   Douglas 320009000422 3302 Pau Wa Lu   Regular School No Middle 06 08 2019   grade_6 108.0   37.0   8.0           16.0   98.0 71.0                       169 108   37   8           16   98 71                 169
1877224 NV     school 3200120 4   Elko 320012000131 4104 Independence Vly ES   Regular School No Elementary KG 08 2019   grade_6 1.0   2.0                   2.0 1.0                       3 1   2                   2 1                 3
1877245 NV     school 3200120 4   Elko 320012000139 4111 Ruby Vly ES   Regular School No Elementary KG 08 2019   grade_6 4.0                       1.0 3.0                       4 4                       1 3                 4
1877270 NV     school 3200120 4   Elko 320012000125 4205 Carlin ES   Regular School No Elementary PK 06 2019   grade_6 20.0   3.0             1.0 1.0   10.0 15.0                       25 20   3             1 1   10 15                 25
1877277 NV     school 3200120 4   Elko 320012000727 4206 Owyhee ES   Regular School No Elementary PK 06 2019   grade_6 1.0   1.0   28.0               17.0 13.0                       30 1   1   28               17 13                 30
1877292 NV     school 3200120 4   Elko 320012000308 4208 West Wendover ES ES   Regular School No Elementary PK 06 2019   grade_6 20.0   55.0   1.0           1.0   35.0 42.0                       77 20   55   1           1   35 42                 77
1877305 NV     school 3200120 4   Elko 320012000350 4210 Spring Creek ES   Regular School No Elementary KG 06 2019   grade_6     1.0                     1.0                       1     1                     1                 1
1877322 NV     school 3200120 4   Elko 320012000326 4503 Adobe MS   Regular School No Middle 05 08 2019   grade_6     1.0                   1.0                         1     1                   1                   1
1877370 NV     school 3200120 4   Elko 320012000839 4610 NNVVirtual   Regular School No Other KG 12 2019   grade_6 4.0                       2.0 2.0                       4 4                       2 2                 4
1877385 NV     school 3200150 5   Esmeralda 320015000143 5101 Dyer ES   Regular School No Elementary PK 08 2019   grade_6 3.0   2.0   1.0               2.0 4.0                       6 3   2   1               2 4                 6
1877395 NV     school 3200150 5   Esmeralda 320015000144 5102 Goldfield ES   Regular School No Elementary PK 08 2019   grade_6 5.0                   1.0   2.0 4.0                       6 5                   1   2 4                 6
1877402 NV     school 3200150 5   Esmeralda 320015000145 5103 Silver Peak ES   Regular School No Elementary PK 08 2019   grade_6 1.0                         1.0                       1 1                         1                 1
1877412 NV     school 3200180 6   Eureka 320018000146 6101 Crescent Vly   Regular School No Elementary PK 06 2019   grade_6 6.0   1.0               1.0   6.0 2.0                       8 6   1               1   6 2                 8
1877420 NV     school 3200180 6   Eureka 320018000147 6103 Eureka   Regular School No Elementary PK 06 2019   grade_6 20.0   5.0                   13.0 12.0                       25 20   5                   13 12                 25

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