enrollments
Data source: Big Local News · About: Big Local
127,680 rows where state = "AZ" sorted by ell descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
563830 | 563830 | AZ | school | 403420 | 4271 | Glendale Elementary District | 40342002121 | 79782 | Coyote Ridge | Regular School | No | Elementary | PK | 08 | 2018 | pk_12_total | 68 | 61 | 579 | * | 21 | * | 13 | 413 | 339 | 99 | 114 | 743 | 68 | 61 | 579 | 21 | 13 | 413 | 339 | 99 | 114 | 743 | ||||||||||||||||||||||||||||||||
564179 | 564179 | AZ | school | 404970 | 4235 | Mesa Unified District | 40497000384 | 4916 | Emerson Elementary School | Regular School | No | Elementary | KG | 06 | 2018 | pk_12_total | 241 | 69 | 433 | 46 | * | * | 21 | 414 | 409 | 99 | 106 | 822 | 241 | 69 | 433 | 46 | 21 | 414 | 409 | 99 | 106 | 822 | ||||||||||||||||||||||||||||||||
564591 | 564591 | AZ | school | 407080 | 4279 | Roosevelt Elementary District | 40708001324 | 5379 | Maxine O Bush Elementary School | Regular School | No | Elementary | PK | 08 | 2018 | pk_12_total | 17 | 32 | 354 | * | * | * | * | 221 | 200 | 99 | 43 | 421 | 17 | 32 | 354 | 221 | 200 | 99 | 43 | 421 | ||||||||||||||||||||||||||||||||||
564677 | 564677 | AZ | school | 407570 | 4240 | Scottsdale Unified District | 40757000662 | 5044 | Tavan Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | pk_12_total | 154 | 87 | 390 | 31 | * | * | 12 | 343 | 346 | 99 | 98 | 687 | 154 | 87 | 390 | 31 | 12 | 343 | 346 | 99 | 98 | 687 | ||||||||||||||||||||||||||||||||
593915 | 593915 | AZ | school | 405930 | 4241 | Paradise Valley Unified District | 40593000482 | 5086 | Indian Bend Elementary School | Regular School | No | Elementary | PK | 06 | 2019 | pk_12_total | 137 | 18 | 317 | * | 13 | * | 20 | 286 | 231 | 99 | 135 | 517 | 137 | 18 | 317 | 13 | 20 | 286 | 231 | 99 | 135 | 517 | ||||||||||||||||||||||||||||||||
594312 | 594312 | AZ | school | 408170 | 4407 | Sunnyside Unified District | 40817000727 | 5817 | Los Ninos Elementary School | Regular School | No | Elementary | PK | 06 | 2019 | pk_12_total | 38 | 47 | 351 | * | * | * | * | 226 | 231 | 99 | 44 | 457 | 38 | 47 | 351 | 226 | 231 | 99 | 44 | 457 | ||||||||||||||||||||||||||||||||||
594452 | 594452 | AZ | school | 408800 | 4403 | Tucson Unified District | 40880000871 | 5706 | Myers-Ganoung Elementary School | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 77 | 87 | 215 | * | 12 | * | * | 211 | 198 | 99 | 101 | 408 | 77 | 87 | 215 | 12 | 211 | 198 | 99 | 101 | 408 | |||||||||||||||||||||||||||||||||
164030 | 164030 | AZ | school | 400934 | 92381 | Self Development Academy-Phoenix | 40093403493 | 92890 | Self Development Academy-Phoenix | Regular School | Yes | Elementary | KG | 08 | 2020 | pk_12_total | 34 | 40 | 202 | * | * | * | 158 | 139 | 99 | * | 30 | 297 | 34 | 40 | 202 | 158 | 139 | 99 | 30 | 297 | ||||||||||||||||||||||||||||||||||
164159 | 164159 | AZ | school | 408310 | 4258 | Tempe School District | 40831000786 | 5214 | Flora Thew Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 34 | 86 | 345 | 35 | * | 26 | 263 | 278 | 99 | * | 71 | 541 | 34 | 86 | 345 | 35 | 26 | 263 | 278 | 99 | 71 | 541 | ||||||||||||||||||||||||||||||||
164296 | 164296 | AZ | school | 408800 | 4403 | Tucson Unified District | 40880001481 | 5683 | Raul Grijalva Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 23 | * | 480 | 20 | * | * | 291 | 256 | 99 | * | 65 | 547 | 23 | 480 | 20 | 291 | 256 | 99 | 65 | 547 | ||||||||||||||||||||||||||||||||||
97879 | 97879 | AZ | school | 404970 | 4235 | Mesa Unified District | 40497000389 | 4918 | Michael T. Hughes Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | pk_12_total | 92 | 30 | 306 | * | * | * | 18 | 235 | 222 | 99 | * | 103 | 456 | 92 | 30 | 306 | 18 | 235 | 222 | 99 | 103 | 456 | ||||||||||||||||||||||||||||||||
97900 | 97900 | AZ | school | 404970 | 4235 | Mesa Unified District | 40497000415 | 4939 | Stevenson Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | pk_12_total | 184 | 27 | 313 | * | * | * | 24 | 309 | 252 | 99 | * | 111 | 560 | 184 | 27 | 313 | 24 | 309 | 252 | 99 | 111 | 560 | ||||||||||||||||||||||||||||||||
563561 | 563561 | AZ | school | 407750 | 4246 | Deer Valley Unified District | 40775000675 | 5146 | Constitution Elementary School | Regular School | No | Elementary | PK | 06 | 2018 | pk_12_total | 169 | 53 | 343 | 16 | * | * | 20 | 322 | 290 | 98 | 94 | 612 | 169 | 53 | 343 | 16 | 20 | 322 | 290 | 98 | 94 | 612 | ||||||||||||||||||||||||||||||||
563758 | 563758 | AZ | school | 403060 | 4273 | Fowler Elementary District | 40306003085 | 80916 | Western Valley Middle School | Regular School | No | Middle | 06 | 08 | 2018 | pk_12_total | 44 | 61 | 628 | * | * | * | * | 379 | 372 | 98 | 87 | 751 | 44 | 61 | 628 | 379 | 372 | 98 | 87 | 751 | ||||||||||||||||||||||||||||||||||
564050 | 564050 | AZ | school | 404290 | 4276 | Laveen Elementary District | 40429003336 | 91310 | Rogers Ranch School | Regular School | No | Elementary | KG | 08 | 2018 | pk_12_total | 102 | 286 | 558 | 31 | 21 | * | 28 | 522 | 508 | 98 | 134 | 1030 | 102 | 286 | 558 | 31 | 21 | 28 | 522 | 508 | 98 | 134 | 1030 | |||||||||||||||||||||||||||||||
564737 | 564737 | AZ | school | 408130 | 4451 | Stanfield Elementary District | 40813000705 | 5946 | Stanfield Elementary School | Regular School | No | Elementary | PK | 08 | 2018 | pk_12_total | 83 | * | 311 | 74 | * | * | * | 271 | 219 | 98 | 64 | 490 | 83 | 311 | 74 | 271 | 219 | 98 | 64 | 490 | ||||||||||||||||||||||||||||||||||
593175 | 593175 | AZ | school | 402530 | 4174 | Douglas Unified District | 40253000193 | 4769 | Stevenson Elementary School | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | * | * | 424 | * | * | * | * | 216 | 215 | 98 | 22 | 431 | 424 | 216 | 215 | 98 | 22 | 431 | ||||||||||||||||||||||||||||||||||||
593736 | 593736 | AZ | school | 404970 | 4235 | Mesa Unified District | 40497000384 | 4916 | Emerson Elementary School | Regular School | No | Elementary | KG | 06 | 2019 | pk_12_total | 226 | 73 | 436 | 44 | * | 11 | 32 | 413 | 415 | 98 | 99 | 828 | 226 | 73 | 436 | 44 | 11 | 32 | 413 | 415 | 98 | 99 | 828 | |||||||||||||||||||||||||||||||
593760 | 593760 | AZ | school | 404970 | 4235 | Mesa Unified District | 40497001071 | 4940 | Keller Elementary School | Regular School | No | Elementary | PK | 06 | 2019 | pk_12_total | 149 | 27 | 452 | * | * | * | 17 | 361 | 304 | 98 | 184 | 665 | 149 | 27 | 452 | 17 | 361 | 304 | 98 | 184 | 665 | |||||||||||||||||||||||||||||||||
162928 | 162928 | AZ | school | 400877 | 91277 | Empower College Prep | 40087703354 | 91783 | Empower College Prep | Regular School | Yes | Middle | 03 | 08 | 2020 | pk_12_total | * | 49 | 330 | * | * | * | 214 | 198 | 98 | * | 49 | 412 | 49 | 330 | 214 | 198 | 98 | 49 | 412 | |||||||||||||||||||||||||||||||||||
163459 | 163459 | AZ | school | 400781 | 89852 | Math and Science Success Academy, Inc. | 40078102910 | 89853 | Math and Science Success Academy | Regular School | Yes | Elementary | KG | 08 | 2020 | pk_12_total | 32 | * | 626 | 41 | * | * | 359 | 352 | 98 | * | 28 | 711 | 32 | 626 | 41 | 359 | 352 | 98 | 28 | 711 | ||||||||||||||||||||||||||||||||||
163799 | 163799 | AZ | school | 406300 | 4256 | Phoenix Elementary District | 40630000530 | 5203 | Maie Bartlett Heard School | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 36 | 50 | 366 | 16 | 32 | 19 | 274 | 248 | 98 | 30 | 114 | 522 | 36 | 50 | 366 | 16 | 32 | 19 | 274 | 248 | 98 | 30 | 114 | 522 | ||||||||||||||||||||||||||||||
164201 | 164201 | AZ | school | 400863 | 91250 | The Paideia Academies, Inc | 40086303355 | 91775 | The Paideia Academy of South Phoenix | Regular School | Yes | Elementary | KG | 08 | 2020 | pk_12_total | 115 | 176 | 509 | * | 11 | 35 | 422 | 438 | 98 | * | 87 | 860 | 115 | 176 | 509 | 11 | 35 | 422 | 438 | 98 | 87 | 860 | ||||||||||||||||||||||||||||||||
97115 | 97115 | AZ | school | 402400 | 4501 | Crane Elementary District | 40240002779 | 89582 | Mesquite Elementary | Regular School | No | Elementary | PK | 06 | 2021 | pk_12_total | 102 | * | 446 | * | * | * | 11 | 294 | 285 | 98 | * | 47 | 578 | 102 | 446 | 11 | 294 | 285 | 98 | 47 | 578 | |||||||||||||||||||||||||||||||||
97890 | 97890 | AZ | school | 404970 | 4235 | Mesa Unified District | 40497000412 | 4974 | Rhodes Junior High School | Regular School | No | Middle | 07 | 09 | 2021 | pk_12_total | 163 | 59 | 491 | 54 | 11 | * | 30 | 435 | 381 | 98 | 12 | 124 | 816 | 163 | 59 | 491 | 54 | 11 | 30 | 435 | 381 | 98 | 12 | 124 | 816 | |||||||||||||||||||||||||||||
98122 | 98122 | AZ | school | 406210 | 4283 | Pendergast Elementary District | 40621002274 | 79800 | Rio Vista Elementary | Regular School | No | Elementary | KG | 08 | 2021 | pk_12_total | 57 | 94 | 445 | * | 15 | * | 45 | 361 | 306 | 98 | * | 119 | 666 | 57 | 94 | 445 | 15 | 45 | 361 | 306 | 98 | 119 | 666 | |||||||||||||||||||||||||||||||
98718 | 98718 | AZ | school | 408820 | 4277 | Union Elementary District | 40882002496 | 87523 | Hurley Ranch Elementary | Regular School | No | Middle | 03 | 08 | 2021 | pk_12_total | 47 | 99 | 500 | 15 | * | * | 38 | 371 | 335 | 98 | * | 78 | 706 | 47 | 99 | 500 | 15 | 38 | 371 | 335 | 98 | 78 | 706 | |||||||||||||||||||||||||||||||
563765 | 563765 | AZ | school | 400102 | 4303 | Friendly House, Inc. | 40010201582 | 6036 | Friendly House Academia Del Pueblo Elem | Regular School | Yes | Elementary | KG | 08 | 2018 | pk_12_total | * | * | 357 | * | * | * | * | 187 | 187 | 97 | 36 | 374 | 357 | 187 | 187 | 97 | 36 | 374 | ||||||||||||||||||||||||||||||||||||
564241 | 564241 | AZ | school | 404970 | 4235 | Mesa Unified District | 40497000420 | 4929 | Whitman Elementary School | Regular School | No | Elementary | PK | 06 | 2018 | pk_12_total | 90 | 31 | 418 | 101 | * | * | 15 | 340 | 323 | 97 | 120 | 663 | 90 | 31 | 418 | 101 | 15 | 340 | 323 | 97 | 120 | 663 | ||||||||||||||||||||||||||||||||
564871 | 564871 | AZ | school | 408800 | 4403 | Tucson Unified District | 40880000836 | 5673 | Dietz K-8 School | Regular School | No | Elementary | PK | 08 | 2018 | pk_12_total | 131 | 72 | 216 | * | 19 | * | 31 | 257 | 224 | 97 | 52 | 481 | 131 | 72 | 216 | 19 | 31 | 257 | 224 | 97 | 52 | 481 | ||||||||||||||||||||||||||||||||
592947 | 592947 | AZ | school | 401680 | 4282 | Cartwright Elementary District | 40168000092 | 5406 | Desert Sands Middle School | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 37 | 49 | 798 | 14 | 12 | * | * | 462 | 459 | 97 | 124 | 921 | 37 | 49 | 798 | 14 | 12 | 462 | 459 | 97 | 124 | 921 | ||||||||||||||||||||||||||||||||
594556 | 594556 | AZ | school | 409060 | 4260 | Washington Elementary School District | 40906000929 | 5256 | Manzanita Elementary School | Regular School | No | Elementary | PK | 06 | 2019 | pk_12_total | 150 | 43 | 430 | 19 | 30 | * | 31 | 397 | 306 | 97 | 142 | 701 | 150 | 43 | 430 | 19 | 30 | 31 | 397 | 306 | 97 | 142 | 701 | |||||||||||||||||||||||||||||||
163476 | 163476 | AZ | school | 404970 | 4235 | Mesa Unified District | 40497000384 | 4916 | Emerson Elementary School | Regular School | No | Elementary | PK | 06 | 2020 | pk_12_total | 259 | 64 | 435 | 40 | * | 34 | 430 | 422 | 97 | 13 | 119 | 852 | 259 | 64 | 435 | 40 | 34 | 430 | 422 | 97 | 13 | 119 | 852 | |||||||||||||||||||||||||||||||
163536 | 163536 | AZ | school | 404970 | 4235 | Mesa Unified District | 40497000418 | 4927 | Webster Elementary School | Regular School | No | Elementary | PK | 06 | 2020 | pk_12_total | 154 | 51 | 357 | 53 | * | 42 | 372 | 298 | 97 | 27 | 150 | 670 | 154 | 51 | 357 | 53 | 42 | 372 | 298 | 97 | 27 | 150 | 670 | |||||||||||||||||||||||||||||||
164213 | 164213 | AZ | school | 408520 | 4288 | Tolleson Union High School District | 40852001478 | 5453 | Westview High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 275 | 227 | 1549 | * | 74 | 98 | 1174 | 1068 | 97 | 45 | 246 | 2242 | 275 | 227 | 1549 | 74 | 98 | 1174 | 1068 | 97 | 45 | 246 | 2242 | |||||||||||||||||||||||||||||||
96605 | 96605 | AZ | school | 400891 | 90878 | Academy of Mathematics and Science South, Inc. | 40089103604 | 1000118 | Academy of Math and Science Peoria Advanced | Regular School | Yes | Elementary | KG | 08 | 2021 | pk_12_total | 216 | 127 | 350 | 15 | 18 | * | 59 | 389 | 398 | 97 | * | 54 | 787 | 216 | 127 | 350 | 15 | 18 | 59 | 389 | 398 | 97 | 54 | 787 | ||||||||||||||||||||||||||||||
96916 | 96916 | AZ | school | 401680 | 4282 | Cartwright Elementary District | 40168002904 | 89955 | Raul H. Castro Middle School | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 14 | 38 | 435 | * | * | * | * | 255 | 246 | 97 | * | 58 | 501 | 14 | 38 | 435 | 255 | 246 | 97 | 58 | 501 | |||||||||||||||||||||||||||||||||
97896 | 97896 | AZ | school | 404970 | 4235 | Mesa Unified District | 40497001830 | 78917 | Skyline High School | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 1051 | 100 | 1065 | 46 | 20 | * | 95 | 1198 | 1189 | 97 | 15 | 473 | 2387 | 1051 | 100 | 1065 | 46 | 20 | 95 | 1198 | 1189 | 97 | 15 | 473 | 2387 | |||||||||||||||||||||||||||||
97905 | 97905 | AZ | school | 404970 | 4235 | Mesa Unified District | 40497000418 | 4927 | Webster Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | pk_12_total | 100 | 47 | 329 | 50 | * | * | 35 | 303 | 271 | 97 | 12 | 129 | 569 | 100 | 47 | 329 | 50 | 35 | 303 | 271 | 97 | 12 | 129 | 569 | ||||||||||||||||||||||||||||||
97976 | 97976 | AZ | school | 405530 | 4457 | Nogales Unified District | 40553001470 | 5955 | Francisco Vasquez De Coronado Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 122 | * | 388 | * | * | * | * | 230 | 286 | 97 | 23 | 34 | 516 | 122 | 388 | 230 | 286 | 97 | 23 | 34 | 516 | |||||||||||||||||||||||||||||||||
98311 | 98311 | AZ | school | 407080 | 4279 | Roosevelt Elementary District | 40708002498 | 87883 | Bernard Black Elementary School | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 21 | 133 | 332 | 12 | 22 | * | 31 | 302 | 249 | 97 | * | 60 | 551 | 21 | 133 | 332 | 12 | 22 | 31 | 302 | 249 | 97 | 60 | 551 | ||||||||||||||||||||||||||||||
98516 | 98516 | AZ | school | 408170 | 4407 | Sunnyside Unified District | 40817001106 | 5814 | Esperanza Elementary School | Regular School | No | Elementary | KG | 06 | 2021 | pk_12_total | 68 | * | 433 | * | * | * | * | 282 | 244 | 97 | * | 83 | 526 | 68 | 433 | 282 | 244 | 97 | 83 | 526 | ||||||||||||||||||||||||||||||||||
564417 | 564417 | AZ | school | 406210 | 4283 | Pendergast Elementary District | 40621001573 | 5423 | Copper King Elementary | Regular School | No | Elementary | PK | 08 | 2018 | pk_12_total | 104 | 76 | 640 | * | 30 | * | 50 | 501 | 412 | 96 | 123 | 908 | 104 | 76 | 640 | 30 | 50 | 501 | 412 | 96 | 123 | 908 | ||||||||||||||||||||||||||||||||
592684 | 592684 | AZ | school | 400122 | 4325 | Acclaim Charter School | 40012201585 | 5496 | ACCLAIM Academy | Regular School | Yes | Elementary | KG | 08 | 2019 | pk_12_total | 73 | 11 | 286 | * | * | * | * | 209 | 161 | 96 | 37 | 370 | 73 | 11 | 286 | 209 | 161 | 96 | 37 | 370 | ||||||||||||||||||||||||||||||||||
593000 | 593000 | AZ | school | 401870 | 4242 | Chandler Unified District #80 | 40187000129 | 5114 | Hartford Sylvia Encinas Elementary | Regular School | No | Elementary | PK | 06 | 2019 | pk_12_total | 58 | 35 | 628 | * | * | * | * | 373 | 372 | 96 | 79 | 745 | 58 | 35 | 628 | 373 | 372 | 96 | 79 | 745 | ||||||||||||||||||||||||||||||||||
593251 | 593251 | AZ | school | 400877 | 91277 | Empower College Prep | 40087703522 | 92975 | Empower Collegiate Academy | Regular School | Yes | Secondary | 07 | 11 | 2019 | pk_12_total | 14 | 37 | 342 | * | * | * | * | 218 | 185 | 96 | 51 | 403 | 14 | 37 | 342 | 218 | 185 | 96 | 51 | 403 | ||||||||||||||||||||||||||||||||||
594147 | 594147 | AZ | school | 407080 | 4279 | Roosevelt Elementary District | 40708000607 | 5370 | Irene Lopez School | Regular School | No | Elementary | KG | 08 | 2019 | pk_12_total | * | 29 | 419 | * | * | * | * | 257 | 205 | 96 | 54 | 462 | 29 | 419 | 257 | 205 | 96 | 54 | 462 | |||||||||||||||||||||||||||||||||||
594318 | 594318 | AZ | school | 408170 | 4407 | Sunnyside Unified District | 40817001613 | 5824 | Challenger Middle School | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 21 | 26 | 669 | 49 | * | * | * | 400 | 367 | 96 | 87 | 767 | 21 | 26 | 669 | 49 | 400 | 367 | 96 | 87 | 767 | |||||||||||||||||||||||||||||||||
162314 | 162314 | AZ | school | 400680 | 4406 | Amphitheater Unified District | 40068000023 | 5796 | E C Nash School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 57 | 38 | 235 | 19 | * | * | 199 | 167 | 96 | * | 86 | 366 | 57 | 38 | 235 | 19 | 199 | 167 | 96 | 86 | 366 | |||||||||||||||||||||||||||||||||
163003 | 163003 | AZ | school | 403060 | 4273 | Fowler Elementary District | 40306003084 | 80915 | Western Valley Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 51 | 36 | 458 | * | * | 15 | 307 | 261 | 96 | * | 104 | 568 | 51 | 36 | 458 | 15 | 307 | 261 | 96 | 104 | 568 | |||||||||||||||||||||||||||||||||
163253 | 163253 | AZ | school | 400389 | 79882 | Kaizen Education Foundation dba Maya High School | 40038901737 | 10748 | Kaizen Education Foundation dba Maya High School | Alternative School | Yes | High | 09 | 12 | 2020 | pk_12_total | 54 | 63 | 261 | 17 | * | 19 | 240 | 181 | 96 | 104 | 46 | 421 | 54 | 63 | 261 | 17 | 19 | 240 | 181 | 96 | 104 | 46 | 421 | |||||||||||||||||||||||||||||||
163496 | 163496 | AZ | school | 404970 | 4235 | Mesa Unified District | 40497000229 | 4958 | Kerr Elementary School | Regular School | No | Elementary | KG | 06 | 2020 | pk_12_total | 75 | 48 | 334 | 72 | * | 33 | 273 | 294 | 96 | 14 | 104 | 567 | 75 | 48 | 334 | 72 | 33 | 273 | 294 | 96 | 14 | 104 | 567 | |||||||||||||||||||||||||||||||
163521 | 163521 | AZ | school | 404970 | 4235 | Mesa Unified District | 40497000412 | 4974 | Rhodes Junior High School | Regular School | No | Middle | 07 | 08 | 2020 | pk_12_total | 189 | 68 | 534 | 64 | 11 | 25 | 449 | 455 | 96 | 19 | 125 | 904 | 189 | 68 | 534 | 64 | 11 | 25 | 449 | 455 | 96 | 19 | 125 | 904 | ||||||||||||||||||||||||||||||
97449 | 97449 | AZ | school | 403420 | 4271 | Glendale Elementary District | 40342002121 | 79782 | Coyote Ridge | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 49 | 48 | 415 | * | 12 | * | * | 303 | 237 | 96 | * | 104 | 536 | 49 | 48 | 415 | 12 | 303 | 237 | 96 | 104 | 536 | ||||||||||||||||||||||||||||||||
97710 | 97710 | AZ | school | 400871 | 91763 | Legacy Traditional School – Laveen Village | 40087103310 | 91764 | Legacy Traditional School – Laveen Village | Regular School | Yes | Elementary | KG | 08 | 2021 | pk_12_total | 217 | 176 | 470 | 21 | 17 | * | 69 | 470 | 507 | 96 | * | 88 | 977 | 217 | 176 | 470 | 21 | 17 | 69 | 470 | 507 | 96 | 88 | 977 | ||||||||||||||||||||||||||||||
563535 | 563535 | AZ | school | 402400 | 4501 | Crane Elementary District | 40240000037 | 6175 | Valley Horizon Elementary School | Regular School | No | Elementary | KG | 06 | 2018 | pk_12_total | 27 | * | 489 | * | * | * | * | 292 | 244 | 95 | 80 | 533 | 27 | 489 | 292 | 244 | 95 | 80 | 533 | |||||||||||||||||||||||||||||||||||
564296 | 564296 | AZ | school | 405530 | 4457 | Nogales Unified District | 40553001238 | 5954 | Desert Shadows Middle School | Regular School | No | Middle | 06 | 08 | 2018 | pk_12_total | * | * | 724 | * | * | * | * | 364 | 366 | 95 | 86 | 730 | 724 | 364 | 366 | 95 | 86 | 730 | ||||||||||||||||||||||||||||||||||||
564787 | 564787 | AZ | school | 408310 | 4258 | Tempe School District | 40831000775 | 5230 | Gililland Middle School | Regular School | No | Middle | 06 | 08 | 2018 | pk_12_total | 79 | 149 | 528 | 53 | 16 | 24 | 23 | 434 | 439 | 95 | 125 | 873 | 79 | 149 | 528 | 53 | 16 | 24 | 23 | 434 | 439 | 95 | 125 | 873 | ||||||||||||||||||||||||||||||
593752 | 593752 | AZ | school | 404970 | 4235 | Mesa Unified District | 40497000383 | 4932 | Eisenhower Center for Innovation | Regular School | No | Elementary | PK | 06 | 2019 | pk_12_total | 52 | 52 | 333 | 27 | * | * | 22 | 253 | 237 | 95 | 87 | 490 | 52 | 52 | 333 | 27 | 22 | 253 | 237 | 95 | 87 | 490 | ||||||||||||||||||||||||||||||||
594351 | 594351 | AZ | school | 408310 | 4258 | Tempe School District | 40831000763 | 5226 | Aguilar School | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 47 | 50 | 357 | 63 | * | * | 12 | 250 | 288 | 95 | 67 | 538 | 47 | 50 | 357 | 63 | 12 | 250 | 288 | 95 | 67 | 538 | ||||||||||||||||||||||||||||||||
162644 | 162644 | AZ | school | 401870 | 4242 | Chandler Unified District #80 | 40187001677 | 6015 | Hamilton High School | Regular School | No | High | 08 | 12 | 2020 | pk_12_total | 1781 | 278 | 868 | 76 | 746 | 159 | 1995 | 1934 | 95 | 19 | 338 | 3929 | 1781 | 278 | 868 | 76 | 746 | 159 | 1995 | 1934 | 95 | 19 | 338 | 3929 | ||||||||||||||||||||||||||||||
163606 | 163606 | AZ | school | 405530 | 4457 | Nogales Unified District | 40553001470 | 5955 | Francisco Vasquez De Coronado Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 71 | * | 443 | * | * | * | 250 | 271 | 95 | 18 | 36 | 521 | 71 | 443 | 250 | 271 | 95 | 18 | 36 | 521 | ||||||||||||||||||||||||||||||||||
164462 | 164462 | AZ | school | 409600 | 4499 | Yuma Elementary District | 40960000983 | 6148 | George Washington Carver Elementary School | Regular School | No | Elementary | PK | 06 | 2020 | pk_12_total | 44 | * | 266 | * | * | * | 162 | 159 | 95 | * | 41 | 319 | 44 | 266 | 162 | 159 | 95 | 41 | 319 | |||||||||||||||||||||||||||||||||||
563480 | 563480 | AZ | school | 401940 | 4158 | Chinle Unified District | 40194000140 | 4734 | Many Farms Elementary School | Regular School | No | Elementary | PK | 08 | 2018 | pk_12_total | * | * | * | 476 | * | * | * | 259 | 223 | 94 | 47 | 482 | 476 | 259 | 223 | 94 | 47 | 482 | ||||||||||||||||||||||||||||||||||||
563532 | 563532 | AZ | school | 402400 | 4501 | Crane Elementary District | 40240001087 | 6169 | Rancho Viejo Elementary School | Regular School | No | Elementary | PK | 08 | 2018 | pk_12_total | 13 | * | 325 | * | * | * | * | 182 | 164 | 94 | 50 | 346 | 13 | 325 | 182 | 164 | 94 | 50 | 346 | |||||||||||||||||||||||||||||||||||
563688 | 563688 | AZ | school | 400895 | 92250 | Espiritu Community Development Corp. | 40089502450 | 85886 | Reyes Maria Ruiz Leadership Academy | Regular School | Yes | Elementary | KG | 06 | 2018 | pk_12_total | * | * | 324 | * | * | * | * | 270 | 296 | 94 | 23 | 566 | 324 | 270 | 296 | 94 | 23 | 566 | ||||||||||||||||||||||||||||||||||||
563827 | 563827 | AZ | school | 403420 | 4271 | Glendale Elementary District | 40342000263 | 5340 | Bicentennial North School | Regular School | No | Elementary | PK | 08 | 2018 | pk_12_total | 52 | 48 | 663 | * | * | * | 18 | 388 | 400 | 94 | 93 | 788 | 52 | 48 | 663 | 18 | 388 | 400 | 94 | 93 | 788 | |||||||||||||||||||||||||||||||||
564111 | 564111 | AZ | school | 404500 | 4270 | Madison Elementary District | 40450000678 | 5325 | Madison Camelview Elementary | Regular School | No | Elementary | PK | 04 | 2018 | pk_12_total | 95 | 43 | 364 | 38 | 11 | * | 23 | 320 | 254 | 94 | 55 | 575 | 95 | 43 | 364 | 38 | 11 | 23 | 320 | 254 | 94 | 55 | 575 | |||||||||||||||||||||||||||||||
564197 | 564197 | AZ | school | 404970 | 4235 | Mesa Unified District | 40497001070 | 4921 | Jefferson Elementary School | Regular School | No | Elementary | PK | 06 | 2018 | pk_12_total | 120 | 11 | 386 | * | * | * | * | 301 | 236 | 94 | 126 | 537 | 120 | 11 | 386 | 301 | 236 | 94 | 126 | 537 | ||||||||||||||||||||||||||||||||||
564593 | 564593 | AZ | school | 407080 | 4279 | Roosevelt Elementary District | 40708001325 | 5380 | Southwest Elementary School | Regular School | No | Elementary | KG | 08 | 2018 | pk_12_total | 36 | 19 | 430 | 14 | * | * | * | 263 | 244 | 94 | 50 | 507 | 36 | 19 | 430 | 14 | 263 | 244 | 94 | 50 | 507 | |||||||||||||||||||||||||||||||||
593765 | 593765 | AZ | school | 404970 | 4235 | Mesa Unified District | 40497001166 | 4946 | Robson Elementary School | Regular School | No | Elementary | KG | 06 | 2019 | pk_12_total | 133 | 31 | 391 | 18 | * | * | 11 | 289 | 304 | 94 | 95 | 593 | 133 | 31 | 391 | 18 | 11 | 289 | 304 | 94 | 95 | 593 | ||||||||||||||||||||||||||||||||
594158 | 594158 | AZ | school | 407080 | 4279 | Roosevelt Elementary District | 40708001879 | 79013 | Ed & Verma Pastor Elementary School | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 14 | 77 | 459 | * | * | * | * | 290 | 270 | 94 | 83 | 560 | 14 | 77 | 459 | 290 | 270 | 94 | 83 | 560 | ||||||||||||||||||||||||||||||||||
594597 | 594597 | AZ | school | 409390 | 4261 | Wilson Elementary District | 40939000964 | 5276 | Wilson Elementary School | Regular School | No | Middle | 04 | 08 | 2019 | pk_12_total | * | 51 | 579 | * | * | * | * | 310 | 335 | 94 | 55 | 645 | 51 | 579 | 310 | 335 | 94 | 55 | 645 | |||||||||||||||||||||||||||||||||||
163605 | 163605 | AZ | school | 405530 | 4457 | Nogales Unified District | 40553001238 | 5954 | Desert Shadows Middle School | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 17 | * | 763 | * | * | * | 398 | 390 | 94 | 20 | 88 | 788 | 17 | 763 | 398 | 390 | 94 | 20 | 88 | 788 | ||||||||||||||||||||||||||||||||||
164129 | 164129 | AZ | school | 408170 | 4407 | Sunnyside Unified District | 40817001177 | 5816 | Gallego Primary Fine Arts Magnet | Regular School | No | Elementary | KG | 03 | 2020 | pk_12_total | 80 | * | 439 | * | * | 11 | 290 | 260 | 94 | * | 35 | 550 | 80 | 439 | 11 | 290 | 260 | 94 | 35 | 550 | ||||||||||||||||||||||||||||||||||
97610 | 97610 | AZ | school | 400268 | 79064 | Juniper Tree Academy | 40026802092 | 79112 | Desert View Academy | Regular School | Yes | Elementary | KG | 06 | 2021 | pk_12_total | 184 | 17 | 629 | * | 23 | * | 11 | 453 | 419 | 94 | * | 84 | 872 | 184 | 17 | 629 | 23 | 11 | 453 | 419 | 94 | 84 | 872 | |||||||||||||||||||||||||||||||
97631 | 97631 | AZ | school | 404060 | 4396 | Kayenta Unified School District #27 | 40406000324 | 5644 | Monument Valley High School | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | * | * | 16 | 594 | * | * | 32 | 330 | 315 | 94 | * | 91 | 645 | 16 | 594 | 32 | 330 | 315 | 94 | 91 | 645 | |||||||||||||||||||||||||||||||||
97732 | 97732 | AZ | school | 404320 | 4266 | Liberty Elementary District | 40432002133 | 79652 | Rainbow Valley Elementary School | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 136 | * | 431 | * | * | * | * | 319 | 263 | 94 | * | 107 | 582 | 136 | 431 | 319 | 263 | 94 | 107 | 582 | ||||||||||||||||||||||||||||||||||
98024 | 98024 | AZ | school | 405670 | 4262 | Osborn Elementary District | 40567000464 | 5281 | Solano School | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 52 | 106 | 246 | 27 | 15 | * | 27 | 233 | 242 | 94 | * | 79 | 475 | 52 | 106 | 246 | 27 | 15 | 27 | 233 | 242 | 94 | 79 | 475 | ||||||||||||||||||||||||||||||
98116 | 98116 | AZ | school | 406210 | 4283 | Pendergast Elementary District | 40621002006 | 79265 | Canyon Breeze Elementary | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 82 | 46 | 459 | * | 22 | * | 21 | 326 | 311 | 94 | * | 66 | 637 | 82 | 46 | 459 | 22 | 21 | 326 | 311 | 94 | 66 | 637 | |||||||||||||||||||||||||||||||
563753 | 563753 | AZ | school | 403060 | 4273 | Fowler Elementary District | 40306000679 | 5353 | Santa Maria Middle School | Regular School | No | Middle | 06 | 08 | 2018 | pk_12_total | 58 | 78 | 600 | * | * | * | * | 375 | 391 | 93 | 82 | 766 | 58 | 78 | 600 | 375 | 391 | 93 | 82 | 766 | ||||||||||||||||||||||||||||||||||
564685 | 564685 | AZ | school | 400934 | 92381 | Self Development Academy-Phoenix | 40093403493 | 92890 | Self Development Academy-Phoenix | Regular School | Yes | Elementary | KG | 08 | 2018 | pk_12_total | 14 | 63 | 218 | * | 17 | * | * | 153 | 163 | 93 | 25 | 316 | 14 | 63 | 218 | 17 | 153 | 163 | 93 | 25 | 316 | |||||||||||||||||||||||||||||||||
565053 | 565053 | AZ | school | 409600 | 4499 | Yuma Elementary District | 40960001804 | 6159 | Desert Mesa Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | pk_12_total | 173 | * | 533 | * | * | * | * | 379 | 346 | 93 | 46 | 724 | 173 | 533 | 379 | 346 | 93 | 46 | 724 | |||||||||||||||||||||||||||||||||||
592746 | 592746 | AZ | school | 400680 | 4406 | Amphitheater Unified District | 40068000027 | 5797 | L M Prince School | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 70 | 103 | 342 | 22 | 18 | * | 19 | 267 | 307 | 93 | 92 | 574 | 70 | 103 | 342 | 22 | 18 | 19 | 267 | 307 | 93 | 92 | 574 | |||||||||||||||||||||||||||||||
594507 | 594507 | AZ | school | 408820 | 4277 | Union Elementary District | 40882002496 | 87523 | Hurley Ranch Elementary | Regular School | No | Middle | 03 | 08 | 2019 | pk_12_total | 46 | 109 | 591 | 12 | * | * | 24 | 416 | 378 | 93 | 87 | 794 | 46 | 109 | 591 | 12 | 24 | 416 | 378 | 93 | 87 | 794 | ||||||||||||||||||||||||||||||||
162656 | 162656 | AZ | school | 401870 | 4242 | Chandler Unified District #80 | 40187001675 | 6013 | Rudy G Bologna Elementary | Regular School | No | Elementary | PK | 06 | 2020 | pk_12_total | 164 | 44 | 315 | * | 20 | 12 | 305 | 265 | 93 | * | 157 | 570 | 164 | 44 | 315 | 20 | 12 | 305 | 265 | 93 | 157 | 570 | ||||||||||||||||||||||||||||||||
163206 | 163206 | AZ | school | 400754 | 89563 | Imagine Desert West Middle, Inc. | 40075402819 | 89564 | Imagine Desert West Middle | Regular School | Yes | Middle | 06 | 08 | 2020 | pk_12_total | * | 14 | 470 | * | * | * | 254 | 243 | 93 | * | 39 | 497 | 14 | 470 | 254 | 243 | 93 | 39 | 497 | |||||||||||||||||||||||||||||||||||
163538 | 163538 | AZ | school | 404970 | 4235 | Mesa Unified District | 40497000420 | 4929 | Whitman Elementary School | Regular School | No | Elementary | PK | 06 | 2020 | pk_12_total | 96 | 48 | 364 | 108 | * | 25 | 337 | 320 | 93 | * | 125 | 657 | 96 | 48 | 364 | 108 | 25 | 337 | 320 | 93 | 125 | 657 | ||||||||||||||||||||||||||||||||
164134 | 164134 | AZ | school | 408170 | 4407 | Sunnyside Unified District | 40817000751 | 5825 | Ocotillo Early Learning Elementary School | Regular School | No | Elementary | PK | 02 | 2020 | pk_12_total | 91 | 12 | 346 | * | * | * | 277 | 179 | 93 | * | 168 | 456 | 91 | 12 | 346 | 277 | 179 | 93 | 168 | 456 | ||||||||||||||||||||||||||||||||||
164136 | 164136 | AZ | school | 408170 | 4407 | Sunnyside Unified District | 40817000739 | 5822 | Santa Clara Elementary School | Regular School | No | Elementary | KG | 06 | 2020 | pk_12_total | 52 | * | 362 | 89 | * | * | 269 | 241 | 93 | * | 78 | 510 | 52 | 362 | 89 | 269 | 241 | 93 | 78 | 510 | ||||||||||||||||||||||||||||||||||
97149 | 97149 | AZ | school | 407750 | 4246 | Deer Valley Unified District | 40775002591 | 79414 | Deer Valley Online Learning Program | Regular School | No | Other | KG | 12 | 2021 | pk_12_total | 1123 | 121 | 507 | 26 | 131 | * | 157 | 1035 | 1036 | 93 | * | 241 | 2071 | 1123 | 121 | 507 | 26 | 131 | 157 | 1035 | 1036 | 93 | 241 | 2071 | ||||||||||||||||||||||||||||||
97865 | 97865 | AZ | school | 404970 | 4235 | Mesa Unified District | 40497000229 | 4958 | Kerr Elementary School | Regular School | No | Elementary | KG | 06 | 2021 | pk_12_total | 71 | 39 | 295 | 71 | * | * | 34 | 258 | 257 | 93 | 12 | 107 | 503 | 71 | 39 | 295 | 71 | 34 | 258 | 257 | 93 | 12 | 107 | 503 | ||||||||||||||||||||||||||||||
98890 | 98890 | AZ | school | 409600 | 4499 | Yuma Elementary District | 40960001804 | 6159 | Desert Mesa Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 206 | * | 457 | * | * | * | 13 | 350 | 339 | 93 | * | 97 | 689 | 206 | 457 | 13 | 350 | 339 | 93 | 97 | 689 | |||||||||||||||||||||||||||||||||
563190 | 563190 | AZ | school | 400680 | 4406 | Amphitheater Unified District | 40068000023 | 5796 | E C Nash School | Regular School | No | Elementary | KG | 05 | 2018 | pk_12_total | 45 | 14 | 294 | 16 | * | * | * | 193 | 193 | 92 | 92 | 386 | 45 | 14 | 294 | 16 | 193 | 193 | 92 | 92 | 386 | |||||||||||||||||||||||||||||||||
563256 | 563256 | AZ | school | 400960 | 4272 | Avondale Elementary District | 40096001154 | 5348 | Eliseo C. Felix School | Regular School | No | Elementary | 02 | 05 | 2018 | pk_12_total | 33 | 87 | 373 | * | * | * | * | 263 | 247 | 92 | 64 | 510 | 33 | 87 | 373 | 263 | 247 | 92 | 64 | 510 | ||||||||||||||||||||||||||||||||||
563451 | 563451 | AZ | school | 401870 | 4242 | Chandler Unified District #80 | 40187001058 | 5116 | Frye Elementary School | Regular School | No | Elementary | PK | 06 | 2018 | pk_12_total | 42 | 50 | 467 | * | 11 | * | 15 | 299 | 297 | 92 | 86 | 596 | 42 | 50 | 467 | 11 | 15 | 299 | 297 | 92 | 86 | 596 | ||||||||||||||||||||||||||||||||
563841 | 563841 | AZ | school | 403420 | 4271 | Glendale Elementary District | 40342000268 | 5335 | Melvin E Sine School | Regular School | No | Elementary | PK | 08 | 2018 | pk_12_total | 112 | 77 | 426 | 33 | 17 | * | 24 | 357 | 332 | 92 | 134 | 688 | 112 | 77 | 426 | 33 | 17 | 24 | 357 | 332 | 92 | 134 | 688 | |||||||||||||||||||||||||||||||
563927 | 563927 | AZ | school | 400766 | 89786 | Imagine Coolidge Elementary, Inc. | 40076602901 | 89787 | Imagine Coolidge Elementary | Regular School | Yes | Elementary | KG | 05 | 2018 | pk_12_total | 148 | 60 | 342 | 41 | * | * | 28 | 301 | 323 | 92 | 68 | 624 | 148 | 60 | 342 | 41 | 28 | 301 | 323 | 92 | 68 | 624 | ||||||||||||||||||||||||||||||||
564587 | 564587 | AZ | school | 407080 | 4279 | Roosevelt Elementary District | 40708001143 | 5377 | Ignacio Conchos School | Regular School | No | Elementary | PK | 08 | 2018 | pk_12_total | 13 | 44 | 330 | * | * | * | * | 219 | 183 | 92 | 105 | 402 | 13 | 44 | 330 | 219 | 183 | 92 | 105 | 402 | ||||||||||||||||||||||||||||||||||
592712 | 592712 | AZ | school | 400600 | 4280 | Alhambra Elementary District | 40060003599 | 1000042 | Valencia Newcomer School | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | * | 50 | 52 | * | * | * | * | 47 | 58 | 92 | * | 105 | 50 | 52 | 47 | 58 | 92 | 105 |
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]);