enrollments
Data source: Big Local News · About: Big Local
148 rows where grade = "grade_9", state = "NV" and year = 2021 sorted by admin_level
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1842210 | 1842210 | NV | school | 3200390 | 13 | Carson City | 320039000480 | 13903 | Pioneer HS | Alternative School | No | High | 09 | 12 | 2021 | grade_9 | 18 | 0 | 16 | 3 | 0 | 0 | 4 | 31 | 10 | 0.0 | 41 | 18 | 0 | 16 | 3 | 0 | 0 | 4 | 31 | 10 | 0 | 41 | ||||||||||||||||||||||||||||||||
1842230 | 1842230 | NV | school | 3200420 | 14 | Pershing | 320042000198 | 14601 | Pershing HS | Regular School | No | High | 09 | 12 | 2021 | grade_9 | 26 | 0 | 12 | 4 | 0 | 0 | 2 | 25 | 19 | 0.0 | 44 | 26 | 0 | 12 | 4 | 0 | 0 | 2 | 25 | 19 | 0 | 44 | ||||||||||||||||||||||||||||||||
1842253 | 1842253 | NV | school | 3200450 | 15 | Storey | 320045000199 | 15601 | Virginia City HS | Regular School | No | High | 09 | 12 | 2021 | grade_9 | 35 | 1 | 2 | 0 | 0 | 0 | 2 | 18 | 22 | 0.0 | 40 | 35 | 1 | 2 | 0 | 0 | 0 | 2 | 18 | 22 | 0 | 40 | ||||||||||||||||||||||||||||||||
1842748 | 1842748 | NV | school | 3200480 | 16 | Washoe County | 320048000525 | 16312 | Coral Acad HS | Regular School | Yes | High | 09 | 12 | 2021 | grade_9 | 47 | 5 | 31 | 0 | 28 | 1 | 5 | 58 | 59 | 0.0 | 117 | 47 | 5 | 31 | 0 | 28 | 1 | 5 | 58 | 59 | 0 | 117 | ||||||||||||||||||||||||||||||||
1842780 | 1842780 | NV | school | 3200480 | 16 | Washoe County | 320048000208 | 16501 | Wooster HS | Regular School | No | High | 09 | 12 | 2021 | grade_9 | 68 | 13 | 248 | 8 | 14 | 4 | 9 | 188 | 176 | 0.0 | 364 | 68 | 13 | 248 | 8 | 14 | 4 | 9 | 188 | 176 | 0 | 364 | ||||||||||||||||||||||||||||||||
1842785 | 1842785 | NV | school | 3200480 | 16 | Washoe County | 320048000239 | 16502 | Reno HS | Regular School | No | High | 09 | 12 | 2021 | grade_9 | 281 | 14 | 116 | 2 | 21 | 7 | 28 | 247 | 222 | 0.0 | 469 | 281 | 14 | 116 | 2 | 21 | 7 | 28 | 247 | 222 | 0 | 469 | ||||||||||||||||||||||||||||||||
1842790 | 1842790 | NV | school | 3200480 | 16 | Washoe County | 320048000246 | 16503 | Sparks HS | Regular School | No | High | 09 | 12 | 2021 | grade_9 | 47 | 12 | 240 | 3 | 15 | 5 | 6 | 174 | 154 | 0.0 | 328 | 47 | 12 | 240 | 3 | 15 | 5 | 6 | 174 | 154 | 0 | 328 | ||||||||||||||||||||||||||||||||
1842795 | 1842795 | NV | school | 3200480 | 16 | Washoe County | 320048000238 | 16504 | Hug HS | Regular School | No | High | 09 | 12 | 2021 | grade_9 | 70 | 15 | 312 | 3 | 11 | 13 | 12 | 220 | 216 | 0.0 | 436 | 70 | 15 | 312 | 3 | 11 | 13 | 12 | 220 | 216 | 0 | 436 | ||||||||||||||||||||||||||||||||
1842800 | 1842800 | NV | school | 3200480 | 16 | Washoe County | 320048000210 | 16505 | Reed HS | Regular School | No | High | 09 | 12 | 2021 | grade_9 | 242 | 21 | 221 | 14 | 35 | 8 | 31 | 284 | 288 | 0.0 | 572 | 242 | 21 | 221 | 14 | 35 | 8 | 31 | 284 | 288 | 0 | 572 | ||||||||||||||||||||||||||||||||
1842808 | 1842808 | NV | school | 3200480 | 16 | Washoe County | 320048000822 | 16507 | Inspire Academy | Alternative School | No | Other | 01 | 12 | 2021 | grade_9 | 7 | 1 | 7 | 2 | 0 | 0 | 0 | 13 | 4 | 0.0 | 17 | 7 | 1 | 7 | 2 | 0 | 0 | 0 | 13 | 4 | 0 | 17 | ||||||||||||||||||||||||||||||||
1842812 | 1842812 | NV | school | 3200480 | 16 | Washoe County | 320048000323 | 16508 | McQueen HS | Regular School | No | High | 09 | 12 | 2021 | grade_9 | 246 | 8 | 109 | 3 | 41 | 5 | 25 | 218 | 219 | 0.0 | 437 | 246 | 8 | 109 | 3 | 41 | 5 | 25 | 218 | 219 | 0 | 437 | ||||||||||||||||||||||||||||||||
1842817 | 1842817 | NV | school | 3200480 | 16 | Washoe County | 320048000257 | 16509 | Galena HS | Regular School | No | High | 09 | 12 | 2021 | grade_9 | 209 | 9 | 148 | 0 | 19 | 2 | 22 | 214 | 195 | 0.0 | 409 | 209 | 9 | 148 | 0 | 19 | 2 | 22 | 214 | 195 | 0 | 409 | ||||||||||||||||||||||||||||||||
1842822 | 1842822 | NV | school | 3200480 | 16 | Washoe County | 320048000869 | 16510 | Innovations HS | Alternative School | No | High | 09 | 12 | 2021 | grade_9 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0.0 | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 4 | ||||||||||||||||||||||||||||||||
1842836 | 1842836 | NV | school | 3200480 | 16 | Washoe County | 320048000225 | 16602 | Incline HS | Regular School | No | High | 09 | 12 | 2021 | grade_9 | 52 | 0 | 28 | 0 | 0 | 0 | 4 | 37 | 47 | 0.0 | 84 | 52 | 0 | 28 | 0 | 0 | 0 | 4 | 37 | 47 | 0 | 84 | ||||||||||||||||||||||||||||||||
1842852 | 1842852 | NV | school | 3200480 | 16 | Washoe County | 320048000503 | 16605 | Sierra NV Acad CS | Regular School | Yes | Other | KG | 09 | 2021 | grade_9 | 7 | 0 | 3 | 0 | 2 | 0 | 0 | 8 | 4 | 0.0 | 12 | 7 | 0 | 3 | 0 | 2 | 0 | 0 | 8 | 4 | 0 | 12 | ||||||||||||||||||||||||||||||||
1842854 | 1842854 | NV | school | 3200480 | 16 | Washoe County | 320048000545 | 16606 | Spanish Springs HS | Regular School | No | High | 09 | 12 | 2021 | grade_9 | 358 | 14 | 273 | 14 | 19 | 4 | 44 | 349 | 377 | 0.0 | 726 | 358 | 14 | 273 | 14 | 19 | 4 | 44 | 349 | 377 | 0 | 726 | ||||||||||||||||||||||||||||||||
1842859 | 1842859 | NV | school | 3200480 | 16 | Washoe County | 320048000546 | 16607 | North Valleys HS | Regular School | No | High | 09 | 12 | 2021 | grade_9 | 240 | 14 | 288 | 4 | 22 | 20 | 40 | 333 | 295 | 0.0 | 628 | 240 | 14 | 288 | 4 | 22 | 20 | 40 | 333 | 295 | 0 | 628 | ||||||||||||||||||||||||||||||||
1842864 | 1842864 | NV | school | 3200480 | 16 | Washoe County | 320048000562 | 16608 | ACE ACAD | Regular School | Yes | High | 09 | 12 | 2021 | grade_9 | 24 | 0 | 25 | 0 | 0 | 0 | 5 | 51 | 3 | 0.0 | 54 | 24 | 0 | 25 | 0 | 0 | 0 | 5 | 51 | 3 | 0 | 54 | ||||||||||||||||||||||||||||||||
1842868 | 1842868 | NV | school | 3200480 | 16 | Washoe County | 320048000602 | 16609 | Damonte Ranch HS | Regular School | No | High | 09 | 12 | 2021 | grade_9 | 267 | 11 | 118 | 3 | 31 | 4 | 29 | 223 | 240 | 0.0 | 463 | 267 | 11 | 118 | 3 | 31 | 4 | 29 | 223 | 240 | 0 | 463 | ||||||||||||||||||||||||||||||||
1842873 | 1842873 | NV | school | 3200480 | 16 | Washoe County | 320048000603 | 16610 | enCompass CS | Regular School | Yes | High | 09 | 12 | 2021 | grade_9 | 10 | 0 | 5 | 0 | 0 | 0 | 0 | 8 | 7 | 0.0 | 15 | 10 | 0 | 5 | 0 | 0 | 0 | 0 | 8 | 7 | 0 | 15 | ||||||||||||||||||||||||||||||||
1842877 | 1842877 | NV | school | 3200480 | 16 | Washoe County | 320048000664 | 16611 | Arts Careers Tech | Regular School | No | High | 09 | 12 | 2021 | grade_9 | 94 | 1 | 31 | 2 | 13 | 0 | 7 | 73 | 75 | 0.0 | 148 | 94 | 1 | 31 | 2 | 13 | 0 | 7 | 73 | 75 | 0 | 148 | ||||||||||||||||||||||||||||||||
1842890 | 1842890 | NV | school | 3200480 | 16 | Washoe County | 320048000233 | 16911 | Picollo K 12 | Special Education School | No | Other | PK | 12 | 2021 | grade_9 | 1 | 0 | 3 | 0 | 0 | 0 | 0 | 4 | 0 | 0.0 | 4 | 1 | 0 | 3 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 4 | ||||||||||||||||||||||||||||||||
1842903 | 1842903 | NV | school | 3200480 | 16 | Washoe County | 320048000766 | 16917 | Turning Point | Alternative School | No | Other | 02 | 12 | 2021 | grade_9 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 0.0 | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 4 | ||||||||||||||||||||||||||||||||
1842916 | 1842916 | NV | school | 3200480 | 16 | Washoe County | 320048000844 | 16923 | North Star Online | Alternative School | No | Other | KG | 12 | 2021 | grade_9 | 42 | 1 | 14 | 0 | 3 | 0 | 8 | 26 | 42 | 0.0 | 68 | 42 | 1 | 14 | 0 | 3 | 0 | 8 | 26 | 42 | 0 | 68 | ||||||||||||||||||||||||||||||||
1842949 | 1842949 | NV | school | 3200510 | 17 | White Pine | 320051000267 | 17502 | White Pine HS | Regular School | No | High | 09 | 12 | 2021 | grade_9 | 68 | 2 | 16 | 6 | 1 | 0 | 4 | 48 | 49 | 0.0 | 97 | 68 | 2 | 16 | 6 | 1 | 0 | 4 | 48 | 49 | 0 | 97 | ||||||||||||||||||||||||||||||||
1842957 | 1842957 | NV | school | 3200510 | 17 | White Pine | 320051000606 | 17601 | Lund JSHS | Regular School | No | High | 06 | 12 | 2021 | grade_9 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 5 | 0.0 | 11 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 5 | 0 | 11 | ||||||||||||||||||||||||||||||||
1842961 | 1842961 | NV | school | 3200510 | 17 | White Pine | 320051000483 | 17903 | Steptoe Valley HS | Alternative School | No | High | 09 | 12 | 2021 | grade_9 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0.0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | ||||||||||||||||||||||||||||||||
1843025 | 1843025 | NV | school | 3200001 | 46 | Democracy Prep | 320000100882 | 46300 | DP Agassi HS | Regular School | Yes | High | 09 | 12 | 2021 | grade_9 | 1 | 41 | 35 | 1 | 2 | 0 | 0 | 45 | 35 | 0.0 | 80 | 1 | 41 | 35 | 1 | 2 | 0 | 0 | 45 | 35 | 0 | 80 | ||||||||||||||||||||||||||||||||
1843032 | 1843032 | NV | school | 3200001 | 47 | Sports Leadership and Management Academy | 320000100870 | 47434 | SLAM | Regular School | Yes | High | 06 | 12 | 2021 | grade_9 | 27 | 18 | 87 | 0 | 3 | 3 | 12 | 94 | 56 | 0.0 | 150 | 27 | 18 | 87 | 0 | 3 | 3 | 12 | 94 | 56 | 0 | 150 | ||||||||||||||||||||||||||||||||
1843039 | 1843039 | NV | school | 3200001 | 48 | Equipo Academy | 320000100856 | 48433 | Equipo ACAD | Regular School | Yes | High | 06 | 12 | 2021 | grade_9 | 3 | 2 | 128 | 0 | 0 | 0 | 1 | 76 | 58 | 0.0 | 134 | 3 | 2 | 128 | 0 | 0 | 0 | 1 | 76 | 58 | 0 | 134 | ||||||||||||||||||||||||||||||||
1843071 | 1843071 | NV | school | 3200001 | 49 | Mater Academy of Nevada | 320000100955 | 49434 | Mater East | Regular School | Yes | Other | KG | 09 | 2021 | grade_9 | 10 | 21 | 144 | 0 | 1 | 0 | 2 | 98 | 80 | 0.0 | 178 | 10 | 21 | 144 | 0 | 1 | 0 | 2 | 98 | 80 | 0 | 178 | ||||||||||||||||||||||||||||||||
1843078 | 1843078 | NV | school | 3200001 | 50 | Amplus | 320000100848 | 50431 | Amplus Durango | Regular School | Yes | Other | 04 | 12 | 2021 | grade_9 | 52 | 18 | 24 | 0 | 42 | 6 | 12 | 64 | 90 | 0.0 | 154 | 52 | 18 | 24 | 0 | 42 | 6 | 12 | 64 | 90 | 0 | 154 | ||||||||||||||||||||||||||||||||
1843094 | 1843094 | NV | school | 3200001 | 51 | Founders Academy of Las Vegas | 320000100843 | 51430 | Founders ACAD | Regular School | Yes | Other | KG | 12 | 2021 | grade_9 | 23 | 0 | 22 | 0 | 3 | 0 | 3 | 29 | 22 | 0.0 | 51 | 23 | 0 | 22 | 0 | 3 | 0 | 3 | 29 | 22 | 0 | 51 | ||||||||||||||||||||||||||||||||
1843102 | 1843102 | NV | school | 3200001 | 52 | Leadership Academy of Nevada | 320000100886 | 52429 | Leadership ACAD | Regular School | Yes | High | 06 | 12 | 2021 | grade_9 | 33 | 2 | 5 | 0 | 3 | 0 | 3 | 21 | 25 | 0.0 | 46 | 33 | 2 | 5 | 0 | 3 | 0 | 3 | 21 | 25 | 0 | 46 | ||||||||||||||||||||||||||||||||
1843141 | 1843141 | NV | school | 3200001 | 55 | Doral Academy | 320000100830 | 55202 | Doral Red Rock | Regular School | Yes | Other | KG | 12 | 2021 | grade_9 | 138 | 19 | 58 | 0 | 20 | 6 | 30 | 145 | 126 | 0.0 | 271 | 138 | 19 | 58 | 0 | 20 | 6 | 30 | 145 | 126 | 0 | 271 | ||||||||||||||||||||||||||||||||
1843187 | 1843187 | NV | school | 3200001 | 58 | Pinecrest Academy of Nevada | 320000100825 | 58423 | Pinecrest Cadence | Regular School | Yes | Other | KG | 12 | 2021 | grade_9 | 80 | 19 | 52 | 2 | 14 | 4 | 13 | 95 | 89 | 0.0 | 184 | 80 | 19 | 52 | 2 | 14 | 4 | 13 | 95 | 89 | 0 | 184 | ||||||||||||||||||||||||||||||||
1843218 | 1843218 | NV | school | 3200001 | 58 | Pinecrest Academy of Nevada | 320000100941 | 58428 | Pinecrest Sloan | Regular School | Yes | Other | KG | 10 | 2021 | grade_9 | 64 | 13 | 35 | 2 | 22 | 5 | 22 | 77 | 86 | 0.0 | 163 | 64 | 13 | 35 | 2 | 22 | 5 | 22 | 77 | 86 | 0 | 163 | ||||||||||||||||||||||||||||||||
1843238 | 1843238 | NV | school | 3200001 | 59 | Somerset Academy of Las Vegas | 320000100898 | 59120 | Somerset Losee | Regular School | Yes | Other | KG | 12 | 2021 | grade_9 | 39 | 52 | 114 | 0 | 11 | 7 | 12 | 128 | 107 | 0.0 | 235 | 39 | 52 | 114 | 0 | 11 | 7 | 12 | 128 | 107 | 0 | 235 | ||||||||||||||||||||||||||||||||
1843260 | 1843260 | NV | school | 3200001 | 59 | Somerset Academy of Las Vegas | 320000100820 | 59122 | Somerset Sky Pointe | Regular School | Yes | Other | KG | 12 | 2021 | grade_9 | 104 | 31 | 99 | 1 | 9 | 4 | 22 | 137 | 133 | 0.0 | 270 | 104 | 31 | 99 | 1 | 9 | 4 | 22 | 137 | 133 | 0 | 270 | ||||||||||||||||||||||||||||||||
1843315 | 1843315 | NV | school | 3200001 | 65 | Oasis Academy | 320000100817 | 65414 | Oasis ACAD | Regular School | Yes | Other | KG | 12 | 2021 | grade_9 | 26 | 1 | 12 | 2 | 3 | 0 | 2 | 17 | 29 | 0.0 | 46 | 26 | 1 | 12 | 2 | 3 | 0 | 2 | 17 | 29 | 0 | 46 | ||||||||||||||||||||||||||||||||
1843354 | 1843354 | NV | school | 3200001 | 76 | Alpine Academy | 320000100800 | 76412 | Alpine Acad HS | Regular School | Yes | High | 09 | 12 | 2021 | grade_9 | 16 | 0 | 10 | 0 | 0 | 1 | 1 | 12 | 16 | 0.0 | 28 | 16 | 0 | 10 | 0 | 0 | 1 | 1 | 12 | 16 | 0 | 28 | ||||||||||||||||||||||||||||||||
1843379 | 1843379 | NV | school | 3200001 | 85 | Nevada Connections Academy | 320000100731 | 85405 | NV Connections ACAD | Regular School | Yes | High | 09 | 12 | 2021 | grade_9 | 175 | 30 | 109 | 2 | 6 | 4 | 37 | 179 | 184 | 0.0 | 363 | 175 | 30 | 109 | 2 | 6 | 4 | 37 | 179 | 184 | 0 | 363 | ||||||||||||||||||||||||||||||||
1843386 | 1843386 | NV | school | 3200001 | 86 | Nevada Virtual Academy | 320000100734 | 86404 | Nevada Virtual ACAD | Regular School | Yes | High | 06 | 12 | 2021 | grade_9 | 134 | 58 | 93 | 2 | 7 | 9 | 1 | 152 | 152 | 0.0 | 304 | 134 | 58 | 93 | 2 | 7 | 9 | 1 | 152 | 152 | 0 | 304 | ||||||||||||||||||||||||||||||||
1843410 | 1843410 | NV | school | 3200001 | 87 | Coral Academy of Science Las Vegas | 320000100742 | 87312 | CASLV Sandy Ridge | Regular School | Yes | High | 06 | 12 | 2021 | grade_9 | 67 | 15 | 39 | 2 | 44 | 3 | 21 | 106 | 85 | 0.0 | 191 | 67 | 15 | 39 | 2 | 44 | 3 | 21 | 106 | 85 | 0 | 191 | ||||||||||||||||||||||||||||||||
1843430 | 1843430 | NV | school | 3200001 | 89 | Beacon Academy of Nevada | 320000100751 | 89409 | Beacon ACAD | Regular School | Yes | High | 09 | 12 | 2021 | grade_9 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0.0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | ||||||||||||||||||||||||||||||||
1843467 | 1843467 | NV | school | 3200001 | 107 | Explore Academy | 320000100952 | 107101 | Explore ACAD | Regular School | Yes | Middle | 06 | 09 | 2021 | grade_9 | 14 | 1 | 4 | 0 | 0 | 1 | 0 | 15 | 5 | 0.0 | 20 | 14 | 1 | 4 | 0 | 0 | 1 | 0 | 15 | 5 | 0 | 20 | ||||||||||||||||||||||||||||||||
1843473 | 1843473 | NV | school | 3200021 | 84 | Davidson Academy | 320002100680 | 19406 | Davidson Acad | Regular School | No | High | 06 | 12 | 2021 | grade_9 | 24 | 1 | 0 | 0 | 18 | 0 | 5 | 22 | 26 | 0.0 | 48 | 24 | 1 | 0 | 0 | 18 | 0 | 5 | 22 | 26 | 0 | 48 | ||||||||||||||||||||||||||||||||
1843477 | 1843477 | NV | school | 3200023 | 79 | Independence HS | 320002300808 | 79903 | Independence HS | Alternative School | No | High | 06 | 12 | 2021 | grade_9 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 |
Advanced export
JSON shape: default, array, newline-delimited
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]);