enrollments

Data source: Big Local News · About: Big Local

8,512 rows where grade = "pk_12_total" and state = "AZ" sorted by disability

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • pk_12_total · 8,412 ✖
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
96980 96980 AZ     school 401870 4242   Chandler Unified District #80 40187002995 90302 Arizona College Prep Oakland Campus   Regular School No Middle 06 08 2021   pk_12_total 233 18 87   * 331     *   72   356 387     *   *         *   743 233 18 87     331         72   356 387                 743
97021 97021 AZ     school   7927   Child-Parent Centers, Inc.   84192 Ajo Headstart             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97022 97022 AZ     school   7927   Child-Parent Centers, Inc.   85921 Laguna Head Start             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97023 97023 AZ     school   7927   Child-Parent Centers, Inc.   7936 LIBERTY HEAD START             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97024 97024 AZ     school   7927   Child-Parent Centers, Inc.   7938 LOS NINOS SUNNYSIDE HEAD START             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97025 97025 AZ     school   7927   Child-Parent Centers, Inc.   7942 MISSION MANOR HEAD START             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97026 97026 AZ     school   7927   Child-Parent Centers, Inc.   10901 SANTA CLARA HEADSTART             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97027 97027 AZ     school   7927   Child-Parent Centers, Inc.   80623 Summitt View Head Start             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97028 97028 AZ     school   7927   Child-Parent Centers, Inc.   7952 SUNNYSIDE HEAD START             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97042 97042 AZ     school 400805 90138   Choice Academies, Inc. 40080503444 92636 Jefferson Preparatory High School   Regular School Yes High 07 12 2021   pk_12_total 39 * *   * *     *   *   31 33     *   *         *   64 39                       31 33                 64
97048 97048 AZ     school 400407 85448   CITY Center for Collaborative Learning 40040703448 92561 Paulo Freire Freedom School - Downtown   Regular School Yes Middle 06 08 2021   pk_12_total 37 * 25   * *     *   *   30 39     *   *         *   69 37   25                   30 39                 69
97051 97051 AZ     school   89418   City of Phoenix Roosevelt School District Head Start   89420 Bernard Black Headstart             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   18                                             18
97052 97052 AZ     school   89418   City of Phoenix Roosevelt School District Head Start   89423 Cesar Chavez Headstart             2021   pk_12_total 11 * 34   * *     *   *   26 26     *   *         *   52 11   34                   26 26                 52
97053 97053 AZ     school   89418   City of Phoenix Roosevelt School District Head Start   89426 J.F. Kennedy Headstart             2021   pk_12_total * * 11   * *     *   *   * *     *   *         *   14     11                                       14
97054 97054 AZ     school   89418   City of Phoenix Roosevelt School District Head Start   89424 J.R. Davis Headstart             2021   pk_12_total * * 17   * *     *   *   * *     *   *         *   20     17                                       20
97055 97055 AZ     school   89418   City of Phoenix Roosevelt School District Head Start   89427 M.L. King Headstart             2021   pk_12_total * 16 31   * *     *   *   24 25     *   *         *   49   16 31                   24 25                 49
97056 97056 AZ     school   89418   City of Phoenix Roosevelt School District Head Start   89422 Maxine O. Bush Headstart             2021   pk_12_total * * 27   * *     *   *   23 19     *   *         *   42     27                   23 19                 42
97057 97057 AZ     school   89418   City of Phoenix Roosevelt School District Head Start   1000383 R.E.S.D.#66 - Campbell School             2021   pk_12_total * * 16   * *     *   *   * *     *   *         *   22     16                                       22
97058 97058 AZ     school   89418   City of Phoenix Roosevelt School District Head Start   1000384 R.E.S.D.#66 - Ed Pastor School             2021   pk_12_total * * 14   * *     *   *   * *     *   *         *   17     14                                       17
97059 97059 AZ     school   89418   City of Phoenix Roosevelt School District Head Start   475946 Southwest Headstart             2021   pk_12_total * * 13   * *     *   *   * *     *   *         *   19     13                                       19
97060 97060 AZ     school   89418   City of Phoenix Roosevelt School District Head Start   89419 T.G. Barr Headstart             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   12                                             12
97062 97062 AZ     school 400316 79391   Cobre Valley Institute of Technology District 40031602979 90402 CVIT - Central Campus EAC Gila Pueblo   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97063 97063 AZ     school 400316 79391   Cobre Valley Institute of Technology District 40031602940 90103 CVIT - Globe High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97064 97064 AZ     school 400316 79391   Cobre Valley Institute of Technology District 40031602103 79791 CVIT - Superior High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97067 97067 AZ     school 400345 79403   Cochise Technology District 40034502261 79680 CTD - Benson High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97068 97068 AZ     school 400345 79403   Cochise Technology District 40034503589 1000115 CTD - Cochise College   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97069 97069 AZ     school 400345 79403   Cochise Technology District 40034502577 79404 CTD - Cochise Technology School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97070 97070 AZ     school 400345 79403   Cochise Technology District 40034502260 79679 CTD - Tombstone High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97071 97071 AZ     school 400345 79403   Cochise Technology District 40034502257 79676 CTD - Valley Union High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97072 97072 AZ     school 400347 79381   Coconino Association for Vocation Industry and Technology 40034702944 89913 CAVIAT - CCC Central Campus   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97073 97073 AZ     school 400347 79381   Coconino Association for Vocation Industry and Technology 40034702470 87467 CAVIAT - Coconino High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97074 97074 AZ     school 400347 79381   Coconino Association for Vocation Industry and Technology 40034703425 92660 CAVIAT - Flagstaff Central Campus   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97075 97075 AZ     school 400347 79381   Coconino Association for Vocation Industry and Technology 40034702471 87468 CAVIAT - Flagstaff High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97076 97076 AZ     school 400347 79381   Coconino Association for Vocation Industry and Technology 40034702269 79784 CAVIAT - Page High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97077 97077 AZ     school 400347 79381   Coconino Association for Vocation Industry and Technology 40034702271 79786 CAVIAT - Williams High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97078 97078 AZ     school 400163 10386   Coconino County Accommodation School District 40016303711 1001242 CCASD Online Instruction   Regular School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97079 97079 AZ     school   10386   Coconino County Accommodation School District   79010 Jail - Coconino County Accommodation School District             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97080 97080 AZ     school 400163 10386   Coconino County Accommodation School District 40016302429 85842 Ponderosa High School   Alternative School No High 09 12 2021   pk_12_total * * 16   16 *     *   *   22 19     *   *         *   41     16   16               22 19                 41
97081 97081 AZ     school 400163 10386   Coconino County Accommodation School District 40016303138 81127 Tse'yaato' High School   Alternative School No High 09 12 2021   pk_12_total * * *   23 *     *   *   11 19     *   *         *   30         23               11 19                 30
97085 97085 AZ     school 400082 4381   Colorado River Union High School District 40008203225 90858 CRUHSD Academy   Regular School No High 09 12 2021   pk_12_total 72 * 67   * *     *   *   82 74     *   *         *   156 72   67                   82 74                 156
97107 97107 AZ     school 400814 90331   CPLC Community Schools dba Hiaki High School 40081402554 87412 Envision High School   Alternative School Yes High 09 12 2021   pk_12_total * * 60   * *     *   *   42 31     *   *         *   73     60                   42 31                 73
97110 97110 AZ     school 402400 4501   Crane Elementary District 40240003521 778305 Crane iLearning Academy   Regular School No Elementary PK 08 2021   pk_12_total 14 * 45   * *     *   *   37 27     *   *         *   64 14   45                   37 27                 64
97130 97130 AZ     school 402460 4483   Crown King Elementary District 40246000182 6118 Crown King Elementary School   Regular School No Elementary KG 08 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97131 97131 AZ     school   60691   Cupertino Power Learning Center, Inc.   733509 Cupertino Power Learning Center             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97138 97138 AZ     school 400278 79496   Deer Valley Charter Schools, Inc. 40027802168 79506 Deer Valley Academy   Regular School Yes High 09 12 2021   pk_12_total 15 * *   * *     *   *   * *     *   *         *   21 15                                           21
97180 97180 AZ     school   88618   Desert Choice Schools LLC   147909 Desert Choice Schools - Casa Grande Middle School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97181 97181 AZ     school   88618   Desert Choice Schools LLC   812691 Desert Choice Schools - Dos Rios Elementary School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97184 97184 AZ     school   88618   Desert Choice Schools LLC   657386 Desert Choice Schools - Newell Barney Junior High School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97185 97185 AZ     school   88618   Desert Choice Schools LLC   1000049 Desert Choice Schools - Palo Verde Elementary School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97189 97189 AZ     school   88618   Desert Choice Schools LLC   88619 Desert Choice Schools - Sheely Farms Elementary School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97190 97190 AZ     school   88618   Desert Choice Schools LLC   1000142 Desert Choice Schools - Yuma High School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97193 97193 AZ     school 400448 88308   Desert Sky Community School, Inc. 40044802638 88309 Desert Sky Community School   Regular School Yes Elementary KG 05 2021   pk_12_total 33 * 17   * *     *   *   19 31     *   *         *   50 33   17                   19 31                 50
97196 97196 AZ     school   7301   Desert Voices Oral Learning Center   7302 Desert Voices Oral Learning Center             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97199 97199 AZ     school 402490 4179   Double Adobe Elementary District 40249000183 4787 Double Adobe Elementary School   Regular School No Elementary PK 08 2021   pk_12_total 28 * *   * *     *   *   17 17     *   *         *   34 28                       17 17                 34
97241 97241 AZ     school 409731 4516   East Valley Institute of Technology 40973103081 80662 EVIT - Basha High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97242 97242 AZ     school 409731 4516   East Valley Institute of Technology 40973103487 92840 EVIT - Casteel High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97243 97243 AZ     school 409731 4516   East Valley Institute of Technology 40973101515 7284 EVIT - Chandler High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97244 97244 AZ     school 409731 4516   East Valley Institute of Technology 40973103224 90912 EVIT - East Campus   Career and Technical School No High 10 12 2021   pk_12_total 186 * 64   * *     *   12   58 220     *   *         *   278 186   64               12   58 220                 278
97245 97245 AZ     school 409731 4516   East Valley Institute of Technology 40973101514 7282 EVIT - East Valley Institute of Technology   Career and Technical School No High 09 12 2021   pk_12_total 309 * 157   * *     *   19   220 288     *   *         *   508 309   157               19   220 288                 508
97246 97246 AZ     school 409731 4516   East Valley Institute of Technology 40973102234 7287 EVIT - Gilbert High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97247 97247 AZ     school 409731 4516   East Valley Institute of Technology 40973102935 89939 EVIT - Mesquite High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97248 97248 AZ     school 409731 4516   East Valley Institute of Technology 40973102821 89632 EVIT - Perry High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97249 97249 AZ     school 409731 4516   East Valley Institute of Technology 40973103549 25790 EVIT East Apache Junction   Career and Technical School No High 10 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97250 97250 AZ     school 409731 4516   East Valley Institute of Technology 40973103544 165668 EVIT North Fountain Hills   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97252 97252 AZ     school 400817 90506   Ed Ahead 40081703191 90507 Academy Adventures Midtown   Regular School Yes Elementary KG 05 2021   pk_12_total * * 13   * *     *   *   16 14     *   *         *   30     13                   16 14                 30
97256 97256 AZ     school 400130 6365   Edkey Inc. dba American Heritage Academy 40013002569 88201 American Heritage Academy - Camp Verde   Regular School Yes Elementary KG 08 2021   pk_12_total 47 * 23   20 *     *   *   46 53     *   *         *   99 47   23   20               46 53                 99
97276 97276 AZ     school 401001 1000167   Educational Models for Learning, Inc. 40100103718 1001129 Educational Models for Learning – Arizona   Regular School Yes High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97278 97278 AZ     school 400816 90201   Educational Options Foundation 40081602998 90202 EdOptions Preparatory Academy   Alternative School Yes High 07 12 2021   pk_12_total * * 99   * *     *   *   65 35     *   *         *   100     99                   65 35                 100
97279 97279 AZ     school 400055 4341   EduPreneurship, Inc. 40005501731 10752 EduPreneurship Student Center (ESC) Phoenix   Regular School Yes Elementary KG 08 2021   pk_12_total * * 16   * *     *   *   15 18     *   *         *   33     16                   15 18                 33
97282 97282 AZ     school 400311 79059   E-Institute Charter Schools, Inc. 40031103292 91199 E-Institute at Avondale   Alternative School Yes High 09 12 2021   pk_12_total * * 34   * *     *   *   25 23     *   *         *   48     34                   25 23                 48
97283 97283 AZ     school 400311 79059   E-Institute Charter Schools, Inc. 40031103186 90768 E-Institute at Buckeye   Alternative School Yes High 09 12 2021   pk_12_total * * 33   * *     *   *   22 22     *   *         *   44     33                   22 22                 44
97284 97284 AZ     school 400311 79059   E-Institute Charter Schools, Inc. 40031103001 90389 E-Institute at Grovers   Alternative School Yes High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97285 97285 AZ     school 400311 79059   E-Institute Charter Schools, Inc. 40031102919 90075 E-Institute at Metro   Alternative School Yes High 09 12 2021   pk_12_total * * 11   * *     *   *   * *     *   *         *   25     11                                       25
97288 97288 AZ     school 400311 79059   E-Institute Charter Schools, Inc. 40031102151 79117 E-Institute at Union Hills   Alternative School Yes High 09 12 2021   pk_12_total * * 51   * *     *   *   31 30     *   *         *   61     51                   31 30                 61
97289 97289 AZ     school   1000037   Eleutheria LLC   1000038 Estrella Day School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97299 97299 AZ     school 400939 92902   Espiritu Schools 40093903495 92903 AIM Higher College Prep Academy   Regular School Yes High 07 12 2021   pk_12_total * * 44   * *     *   *   27 19     14   *         *   46     44                   27 19     14           46
97300 97300 AZ     school 400955 92988   Estrella Educational Foundation 40095503519 181823 Maricopa Institute of Technology   Regular School Yes High 09 12 2021   pk_12_total 25 24 215   * 11     *   11   177 109     *   *         *   286 25 24 215     11         11   177 109                 286
97331 97331 AZ     school 402920 4437   Florence Unified School District 40292003195 90781 Florence Virtual Academy   Regular School No Other KG 12 2021   pk_12_total 15 * 13   * *     *   *   * *     *   *         *   30 15   13                                       30
97342 97342 AZ     school 403010 4405   Flowing Wells Unified District 40301003331 91832 Flowing Wells Digital Campus   Regular School No Other KG 12 2021   pk_12_total 127 * 203   * *     *   12   180 171     17   *         *   351 127   203               12   180 171     17           351
97355 97355 AZ     school 403200 4221   Fort Thomas Unified District 40320002946 90064 Mt. Turnbull Academy   Alternative School No Other PK 12 2021   pk_12_total * * *   23 *     *   *   * *     *   *         *   23         23                                   23
97358 97358 AZ     school 400113 4356   Fountain Hills Charter School 40011301601 5539 Fountain Hills Charter School   Regular School Yes Elementary KG 08 2021   pk_12_total 34 * *   * *     *   *   27 21     *   *         *   48 34                       27 21                 48
97393 97393 AZ     school   87275   Gateway Academy   87276 Gateway Academy             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97394 97394 AZ     school 400145 6372   Gem Charter School, Inc. 40014501750 6045 Gem Charter School   Regular School Yes Elementary KG 06 2021   pk_12_total 54 * 22   * *     *   *   33 47     *   *         *   80 54   22                   33 47                 80
97395 97395 AZ     school 400124 4332   Genesis Program, Inc. 40012401589 5504 Genesis Academy   Alternative School Yes High 09 12 2021   pk_12_total * * 40   * *     *   *   21 27     *   *         *   48     40                   21 27                 48
97399 97399 AZ     school 400419 87600   Gila County Regional School District 40041902897 90038 Biyaagozhoo Center   Regular School No Other 03 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97400 97400 AZ     school 400349 79387   Gila Institute for Technology 40034902254 79650 GIFT - Ft. Thomas High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97401 97401 AZ     school 400349 79387   Gila Institute for Technology 40034902242 79388 GIFT - Gila Institute for Technology   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97402 97402 AZ     school 400349 79387   Gila Institute for Technology 40034902253 79649 GIFT - Pima High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97403 97403 AZ     school 400349 79387   Gila Institute for Technology 40034902252 79647 GIFT - Safford High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97404 97404 AZ     school 400349 79387   Gila Institute for Technology 40034903239 90892 GIFT-Morenci High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97405 97405 AZ     school   8059   GILA RIVER HEAD START   8062 SACATON HEAD START             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97406 97406 AZ     school   8059   GILA RIVER HEAD START   8063 SANTAN HEAD START             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97479 97479 AZ     school   7317   Gompers   7318 Gompers Private School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97484 97484 AZ     school 400343 79500   Griffin Foundation, Inc. The 40034302246 79512 Children Reaching for the Sky Preparatory   Regular School Yes Elementary KG 05 2021   pk_12_total * * 88   * *     *   *   45 69     12   *         *   114     88                   45 69     12           114
97487 97487 AZ     school 403660 4371   Hackberry School District 40366000065 5570 Cedar Hills School   Regular School No Elementary KG 08 2021   pk_12_total 34 * 13   * *     *   *   28 19     *   *         *   47 34   13                   28 19                 47
97492 97492 AZ     school 400782 89951   Haven Montessori Children's House, Inc. 40078202954 89952 Haven Montessori Charter School   Regular School Yes Elementary KG 06 2021   pk_12_total 57 * *   * *     *   *   39 30     *   *         *   69 57                       39 30                 69
97495 97495 AZ     school   89760   Head Start Washington Elementary School District   89761 Head Start Acacia School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   17                                             17
97496 97496 AZ     school   89760   Head Start Washington Elementary School District   89762 Head Start Alta Vista School             2021   pk_12_total * * 12   * *     *   *   * *     *   *         *   18     12                                       18
97497 97497 AZ     school   89760   Head Start Washington Elementary School District   90756 Head Start Arroyo School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97498 97498 AZ     school   89760   Head Start Washington Elementary School District   1000292 Head Start Cactus Wren             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   14                                             14

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