Data source: Big Local News · About: Big Local

29,565 rows where state = "AZ" and year = 2019 sorted by male_int

View and edit SQL

grade

year

  • 2019 · 29,565
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
592694 AZ     school 400970 449790   AIBT Non-Profit Charter High School, Inc. 40097003546 742847 RCB College Preparatory Academy   Regular School Yes High 09 12 2019   pk_12_total * * *   * *     *   *   * *     *             *   14                                             14
592697 AZ     school 400403 5978   Akimel O Otham Pee Posh Charter School, Inc. 40040301989 10797 Akimel O'Otham Pee Posh (K-2)   Regular School Yes Elementary KG 02 2019   pk_12_total * * *   15 *     *   *   * *     *             *   16         15                                   16
592698 AZ     school 400404 78966   Akimel O'Otham Pee Posh Charter School, Inc. 40040401993 78967 Akimel O'Otham Pee Posh (3-5)   Regular School Yes Elementary 03 05 2019   pk_12_total * * *   * *     *   *   * *     *                 12                                             12
592764 AZ     school 400720 4506   Antelope Union High School District 40072003466 92739 AUHS Online Acadamy   Regular School No High 09 12 2019   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
592766 AZ     school 400750 4178   Apache Elementary District 40075000039 4786 Apache Elementary School   Regular School No Elementary KG 08 2019   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
592804 AZ     school 400870 4187   Ash Creek Elementary District 40087000046 4797 Ash Creek Elementary   Regular School No Elementary PK 08 2019   pk_12_total 14 * *   * *     *   *   * *     *             *   16 14                                           16
592880 AZ     school 400212 79226   Benson Unified School District 40021203232 90775 San Pedro Valley Online Academy   Regular School No High 05 12 2019   pk_12_total * * *   * *     *   *   * *     *             *   11                                             11
592886 AZ     school 401230 4231   Blue Elementary District 40123000069 4908 Blue Elementary School   Regular School No Other KG 12 2019   pk_12_total * * *   * *     *   *   * *     *                 *                                              
592890 AZ     school 406580 4397   Blue Ridge Unified School District No. 32 40658003564 456092 Blue Ridge High School Online   Regular School No High 09 12 2019   pk_12_total * * *   * *     *   *   * *     *                 *                                              
592938 AZ     school 400381 80001   Carpe Diem Collegiate High School 40038102866 89656 Desert View Online School   Regular School Yes High 07 12 2019   pk_12_total * * *   * *     *   *   * *     *                 *                                              
593059 AZ     school   1000098   City School District of Albany   1000099 William S. Hackett Middle School             2019   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
593064 AZ     school 400163 10386   Coconino County Accommodation School District 40016301821 79010 Jail - Coconino County Accommodation School District   Regular School No High 07 12 2019   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
593102 AZ     school 402400 4501   Crane Elementary District 40240003521 778305 Crane iLearning Academy   Regular School No Elementary PK 08 2019   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
593114 AZ     school 402460 4483   Crown King Elementary District 40246000182 6118 Crown King Elementary School   Regular School No Elementary KG 08 2019   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
593121 AZ     school 400278 79496   Deer Valley Charter Schools, Inc. 40027802168 79506 Deer Valley Academy   Regular School Yes High 09 12 2019   pk_12_total * * *   * *     *   *   * *     *             *   18                                             18
593210 AZ     school 400189 10971   East Valley Academy 40018901907 78806 East Valley Academy   Regular School Yes Elementary KG 06 2019   pk_12_total * * *   * *     *   *   * *     *                 13                                             13
593280 AZ     school 400144 4300   Florence Crittenton Services of Arizona, Inc. 40014401717 5466 Girls Leadership Academy of Arizona   Regular School Yes High 09 12 2019   pk_12_total 13 15 96   * *     *   *   * 131     17             16   131 13 15 96                     131     17       16   131
593306 AZ     school 400036 4309   Foothills Academy 40003603421 92407 Foothills Academy Connected   Regular School Yes High 07 12 2019   pk_12_total 12 * *   * *     *   *   * *     *             *   13 12                                           13
593318 AZ     school 403040 4247   Fountain Hills Unified District 40304003240 90932 Fountain.Hills Online   Regular School No High 09 12 2019   pk_12_total 12 * *   * *     *   *   * *     *             *   17 12                                           17
593351 AZ     school 400419 87600   Gila County Regional School District 40041902897 90038 Biyaagozhoo Center   Regular School No Other 03 12 2019   pk_12_total * * *   11 *     *   *   * *     *             *   11         11                                   11
593465 AZ     school 408460 4482   Hillside Elementary District 40846000800 6117 Hillside Elementary School   Regular School No Elementary PK 08 2019   pk_12_total * * *   * *     *   *   * *     *                 *                                              
593475 AZ     school 400108 4337   Humanities and Sciences Academy of the United States, Inc. 40010802146 79623 Humanities and Science High School - Tempe   Regular School Yes High 09 12 2019   pk_12_total * * *   * *     *   *   * *     *                 *                                              
593504 AZ     school 400107 4334   International Commerce Secondary Schools, Inc. 40010701590 5506 Humanities and Sciences High School - Phoenix   Regular School Yes High 09 12 2019   pk_12_total * * *   * *     *   *   * *     *                 *                                              
593688 AZ     school 404630 4404   Marana Unified District 40463000999 5768 A. C. E.   Regular School No High 07 12 2019   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
593710 AZ     school 403860 4234   Maricopa County Regional School District 40386002365 80410 Continued Hope High Schools   Regular School No High 09 12 2019   pk_12_total * * 13   * *     *   *   * *     *             *   18     13                                       18
593820 AZ     school 405100 4253   Mobile Elementary District 40510000431 5191 Mobile Elementary School   Regular School No Elementary KG 08 2019   pk_12_total * * *   * *     *   *   * *     *             *   16                                             16
593834 AZ     school 400126 4428   Montessori Schoolhouse of Tucson, Inc. 40012601620 5869 Montessori Schoolhouse   Regular School Yes Elementary KG KG 2019   pk_12_total 12 * *   * *     *   *   * 14     *                 24 12                         14                 24
593887 AZ     school 405730 4373   Owens School District No.6 40573000466 5578 Owens Elementary School   Regular School No Elementary KG 08 2019   pk_12_total 17 * *   * *     *   *   * 12     *             *   20 17                         12                 20
593966 AZ     school 400344 78890   Pathways KM Charter Schools, Inc 40034403467 92883 Bella Vista Academy   Regular School Yes Middle 06 08 2019   pk_12_total * * *   * *     *   *   * *     *                 *                                              
593972 AZ     school 406070 4209   Payson Unified District 40607003305 91196 Payson Center for Success - Online   Regular School No High 07 12 2019   pk_12_total 19 * *   * *     *   *   * 16     *             *   21 19                         16                 21
594024 AZ     school 406250 4237   Peoria Unified School District 40625002396 81207 Peoria eCampus   Regular School No Other KG 12 2019   pk_12_total 15 * *   * *     *   *   * 15     *                 18 15                         15                 18
594066 AZ     school 400420 87334   Pillar Charter School 40042002522 87335 Pillar Academy of Business & Finance   Regular School Yes High 09 12 2019   pk_12_total * * *   * *     *   *   * *     *             *   12                                             12
594067 AZ     school 400420 87334   Pillar Charter School 40042003277 91213 Pillar Academy Online   Regular School Yes High 09 12 2019   pk_12_total * * 24   * *     *   *   * 22     *             *   30     24                     22                 30
594079 AZ     school 406440 4220   Pima Unified District 40644003362 92296 Gila Valley Learning Center   Regular School No High 09 12 2019   pk_12_total * * *   * *     *   *   * *     *             *   14                                             14
594086 AZ     school 400321 79439   Pinnacle Education-WMCB, Inc. 40032102155 79619 Pinnacle Charter High School   Regular School Yes High 09 12 2019   pk_12_total * * *   * *     *   *   * 12     *             *   22                           12                 22
594123 AZ     school 406810 4245   Queen Creek Unified District 40681003438 92628 Queen Creek Virtual Academy   Regular School No High 06 12 2019   pk_12_total 18 * *   * *     *   *   * 11     *             *   20 18                         11                 20
594164 AZ     school 407130 4155   Round Valley Unified District 40713003442 92686 White Mountain Academy   Regular School No High 09 12 2019   pk_12_total * * *   * *     *   *   * 11     *                 16                           11                 16
594177 AZ     school 407240 4218   Safford Unified District 40724003507 216045 Henry Dunkerson Pathways Academy   Regular School No High 09 12 2019   pk_12_total 15 * 27   * *     *   *   * 33     *             *   42 15   27                     33                 42
594195 AZ     school 407380 4414   San Fernando Elementary District 40738000630 5853 San Fernando Elementary School   Regular School No Elementary KG 08 2019   pk_12_total * * *   * *     *   *   * *     *                 *                                              
594247 AZ     school 409733 4467   Sedona-Oak Creek JUSD #9 40973303188 90826 Red Rock Academy   Regular School No High 09 12 2019   pk_12_total 13 * *   * *     *   *   * 12     *             *   20 13                         12                 20
594260 AZ     school 407700 4393   Show Low Unified District 40770003276 91203 WMI ON LINE   Regular School No High 09 12 2019   pk_12_total 13 * *   * *     *   *   * *     *                 19 13                                           19
594269 AZ     school 401460 4175   Sierra Vista Unified District 40146003524 440989 Sierra Vista Online   Regular School No High 09 12 2019   pk_12_total * * *   * *     *   *   * *     *                 14                                             14
594270 AZ     school 407770 4478   Skull Valley Elementary District 40777000390 6113 Skull Valley Elementary School   Regular School No Elementary KG 08 2019   pk_12_total 16 * *   * *     *   *   * 12     *             *   20 16                         12                 20
594291 AZ     school 400254 79000   Southern Arizona Community Academy, Inc. 40025403420 92518 SACA Online   Regular School Yes High 09 12 2019   pk_12_total * * *   * *     *   *   * *     *                 *                                              
594325 AZ     school 408170 4407   Sunnyside Unified District 40817003316 91829 Sunnyside Online Success Academy   Regular School No Other KG 12 2019   pk_12_total * * 12   * *     *   *   * *     *             *   14     12                                       14
594330 AZ     school 400923 91933   SySTEM Schools 40092303453 92594 SySTEM Phoenix   Regular School Yes High 06 12 2019   pk_12_total * * *   * *     *   *   * *     *                 *                                              
594409 AZ     school 408680 4197   Tuba City Unified School District #15 40868001822 78916 Nizhoni Accelerated Academy   Alternative School No High 09 12 2019   pk_12_total * * *   19 *     *   *   * *     *             *   19         19                                   19
594496 AZ     school 408800 4403   Tucson Unified District 40880001509 6272 Teenage Parent Program - TAPP   Alternative School No High 06 12 2019   pk_12_total 11 * 36   * *     *   *   * 46     *             11   54 11   36                     46             11   54
594538 AZ     school 400067 4358   Victory High School, Inc. 40006701901 78822 Victory High School - Campus   Regular School Yes High 09 12 2019   pk_12_total * * 26   * *     *   *   * 18     *             *   28     26                     18                 28
594541 AZ     school 400391 79907   Vista Charter School 40039103074 80385 Midtown High School   Regular School Yes High 09 12 2019   pk_12_total * * 12   * *     *   *   * *     *                 12     12                                       12
594632 AZ     school 409600 4499   Yuma Elementary District 40960003430 92641 Yuma District One Digital Learning Academy   Regular School No Elementary KG 08 2019   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
594640 AZ     school 409630 4507   Yuma Union High School District 40963003280 91316 Yuma Online Distance Academy   Regular School No High 09 12 2019   pk_12_total * * *   * *     *   *   * *     *                 *                                              
592835 AZ     school 403950 4412   Baboquivari Unified School District #40 40395003210 90821 Alternative Middle School (Indian Oasis Middle School)   Regular School No Middle 06 08 2019   pk_12_total * * *   14 *     *   *   11 *     *             *   16         14               11                   16
592896 AZ     school 401330 4171   Bowie Unified District 40133000073 4759 Bowie High School   Regular School No High 09 12 2019   pk_12_total * * *   * *     *   *   11 *     *             *   18                         11                   18
593063 AZ     school 400163 10386   Coconino County Accommodation School District 40016301820 78915 Juvenile Detention   Regular School No Other 04 12 2019   pk_12_total * * *   * *     *   *   11 *     *             *   16                         11                   16
593647 AZ     school 400393 79926   Lifelong Learning Research Institute, Inc. 40039302297 79927 Lifelong Learning Academy   Regular School Yes Elementary KG 08 2019   pk_12_total * * *   * *     11   *   11 11     *             *   22                 11       11 11                 22
594087 AZ     school 400321 79439   Pinnacle Education-WMCB, Inc. 40032103565 289884 Pinnacle Online - WMCB   Regular School Yes High 09 12 2019   pk_12_total * * *   * *     *   *   11 *     *             *   14                         11                   14
594614 AZ     school 409570 4377   Yucca Elementary District 40957000323 5582 Yucca Elementary School   Regular School No Elementary KG 08 2019   pk_12_total 18 * *   * *     *   *   11 16     *             *   27 18                       11 16                 27
593431 AZ     school 403660 4371   Hackberry School District 40366000065 5570 Cedar Hills School   Regular School No Elementary KG 06 2019   pk_12_total 17 * *   * *     *   *   12 15     *             *   27 17                       12 15                 27
594031 AZ     school 406250 4237   Peoria Unified School District 40625003447 92645 Sunflower School   Regular School No Other PK 12 2019   pk_12_total * * 18   * *     *   *   12 22     *             34   34     18                   12 22             34   34
594509 AZ     school   8286   Utah Elem   8287 Utah             2019   pk_12_total 36 * *   * *     *   *   12 25     *                 37 36                       12 25                 37
592925 AZ     school 401600 4470   Camp Verde Unified District 40160003173 84659 Camp Verde Accommodation School   Alternative School No High 06 12 2019   pk_12_total * * 12   * *     *   *   13 11     *             *   24     12                   13 11                 24
593312 AZ     school 403200 4221   Fort Thomas Unified District 40320002946 90064 Mt. Turnbull Academy   Regular School No Other PK 12 2019   pk_12_total * * *   28 *     *   *   13 15     *             *   28         28               13 15                 28
592895 AZ     school 401330 4171   Bowie Unified District 40133000072 4758 Bowie Elementary School   Regular School No Elementary PK 08 2019   pk_12_total * * 25   * *     *   *   14 17     *             *   31     25                   14 17                 31
593485 AZ     school 403870 4469   Humboldt Unified District 40387002564 87536 Bradshaw Mountain Online Academy   Regular School No High 09 12 2019   pk_12_total 19 * *   * *     *   *   14 11     *             *   25 19                       14 11                 25
593648 AZ     school 400826 90754   Lifelong Learning Research Institute, Inc. 40082603207 90755 Jack Thoman Air and Space Academy and Performing Arts Studio   Regular School Yes Elementary KG 08 2019   pk_12_total 14 * 15   * *     *   *   14 15     *             *   29 14   15                   14 15                 29
593851 AZ     school 405500 4386   Navajo County Accommodation District #99 40550001237 7654 Navajo County Instruction for Success (NCIS)   Special Education School No High 09 12 2019   pk_12_total * * *   14 *     *   *   14 13     *             *   27         14               14 13                 27
594141 AZ     school 407020 4257   Riverside Elementary District 40702003485 92961 Maricopa Institute of Technology (MIT)   Regular School No Middle 07 08 2019   pk_12_total * * 16   * *     *   *   14 12     *                 26     16                   14 12                 26
594206 AZ     school 407520 4458   Santa Cruz Valley Unified District 40752002768 89775 Coatimundi Middle School   Regular School No Middle 06 08 2019   pk_12_total * * 34   * *     *   *   14 22     *             *   36     34                   14 22                 36
594540 AZ     school 400160 4430   Vision Charter School, Inc. 40016001779 5871 Vision Charter School   Regular School Yes High 09 12 2019   pk_12_total * * 23   * *     *   *   14 16     *             *   30     23                   14 16                 30
594203 AZ     school 407520 4458   Santa Cruz Valley Unified District 40752000635 5964 Mountain View School   Regular School No Elementary KG 05 2019   pk_12_total * * 34   * *     *   *   15 20     16             *   35     34                   15 20     16           35
594259 AZ     school 407700 4393   Show Low Unified District 40770001941 79646 White Mountain Institute   Regular School No High 09 12 2019   pk_12_total 12 * *   * *     *   *   15 *     *                 19 12                       15                   19
594383 AZ     school 400214 79131   The Shelby School 40021401980 79132 The Shelby School   Regular School Yes Other KG 10 2019   pk_12_total 23 * *   * *     *   *   15 12     *             *   27 23                       15 12                 27
594510 AZ     school   8304   Utah High School   8305 Utah             2019   pk_12_total 31 * *   * *     *   *   15 16     *                 31 31                       15 16                 31
594591 AZ     school 409190 4236   Wickenburg Unified District 40919003248 91264 Wickenburg Virtual Academy   Regular School No Other KG 12 2019   pk_12_total 21 * *   * *     *   *   15 18     *             *   33 21                       15 18                 33
592762 AZ     school 400680 4406   Amphitheater Unified District 40068003330 91755 Amphi Academy Online   Regular School No Other KG 12 2019   pk_12_total 18 * 24   * *     *   *   16 27     *             *   43 18   24                   16 27                 43
593225 AZ     school 400157 4329   Edkey, Inc. - Sequoia Choice Schools 40015703046 90322 Edkey, Inc. - Precision Learning Center   Regular School Yes High 09 12 2019   pk_12_total * * 22   * *     *   *   16 12     *             *   28     22                   16 12                 28
593293 AZ     school 402920 4437   Florence Unified School District 40292003195 90781 Florence Virtual Academy   Regular School No Other KG 12 2019   pk_12_total 17 * 12   * *     *   *   16 13     *             *   29 17   12                   16 13                 29
594132 AZ     school 406870 4159   Red Mesa Unified District 40687002867 88386 Red Valley/Cove High School   Regular School No High 09 12 2019   pk_12_total * * *   33 *     *   *   16 17     *             11   33         33               16 17             11   33
594251 AZ     school 407630 4472   Seligman Unified District 40763000668 6105 Seligman High School   Regular School No High 09 12 2019   pk_12_total 15 * *   * *     *   *   16 15     *             *   31 15                       16 15                 31
594287 AZ     school 400192 78868   Sonoran Desert School 40019201910 78869 Sonoran Desert School   Regular School Yes High 05 12 2019   pk_12_total 11 * 11   * *     *   *   16 *     *             *   23 11   11                   16                   23
593242 AZ     school 400311 79059   E-Institute Charter Schools, Inc. 40031103001 90389 E-Institute at Grovers   Regular School Yes High 09 12 2019   pk_12_total 16 * *   * *     *   *   17 *     *             *   26 16                       17                   26
594299 AZ     school 408080 4153   St Johns Unified District 40808002871 89607 St. Johns Learning Center   Regular School No High 09 12 2019   pk_12_total 15 * *   * *     *   *   17 *     *             *   23 15                       17                   23
594609 AZ     school 409510 4485   Yarnell Elementary District 40951000977 6121 Yarnell Elementary School   Regular School No Elementary PK 08 2019   pk_12_total 30 * *   * *     *   *   17 27     *             *   44 30                       17 27                 44
594610 AZ     school 400315 79379   Yavapai Accommodation School District 40031502217 79380 Yavapai County High School   Regular School No High 09 12 2019   pk_12_total 22 * *   * *     *   *   17 11     *             11   28 22                       17 11             11   28
592836 AZ     school 403950 4412   Baboquivari Unified School District #40 40395003222 90822 Alternative High School (Indian Oasis High School)   Regular School No High 09 12 2019   pk_12_total * * *   37 *     *   *   19 18     *             *   37         37               19 18                 37
592894 AZ     school 401290 4513   Bouse Elementary District 40129000071 6201 Bouse Elementary School   Regular School No Elementary PK 08 2019   pk_12_total 15 * 17   * *     *   *   19 21     *             *   40 15   17                   19 21                 40
593204 AZ     school 402690 4243   Dysart Unified District 40269003193 90875 Dysart iSchool   Regular School No High 07 12 2019   pk_12_total 29 * 15   * *     *   *   19 29     *                 48 29   15                   19 29                 48
593962 AZ     school 400263 79069   Patagonia Montessori Elementary School 40026302083 79107 Patagonia Montessori School   Regular School Yes Elementary KG 08 2019   pk_12_total 26 * *   * *     *   *   19 *     *             *   28 26                       19                   28
594202 AZ     school 407520 4458   Santa Cruz Valley Unified District 40752000637 5963 San Cayetano Elementary School   Regular School No Elementary PK 05 2019   pk_12_total * * 34   * *     *   *   19 16     14             *   35     34                   19 16     14           35
594243 AZ     school 407570 4240   Scottsdale Unified District 40757003250 91286 Scottsdale Online Learning   Regular School No Other KG 12 2019   pk_12_total 36 * *   * *     *   *   19 25     *                 44 36                       19 25                 44
594252 AZ     school 407680 4250   Sentinel Elementary District 40768000669 5188 Sentinel Elementary School   Regular School No Elementary KG 08 2019   pk_12_total 24 * 12   * *     *   *   19 17     *             *   36 24   12                   19 17                 36
592879 AZ     school 400212 79226   Benson Unified School District 40021202444 85879 San Pedro Valley High School   Regular School No High 09 12 2019   pk_12_total 22 * *   * *     *   *   20 11     *             *   31 22                       20 11                 31
593147 AZ     school 407750 4246   Deer Valley Unified District 40775002591 79414 Deer Valley Online Learning Program   Regular School No High 07 12 2019   pk_12_total 41 * 11   * *     *   *   20 34     *             *   54 41   11                   20 34                 54
593279 AZ     school 402860 4192   Flagstaff Unified District 40286003506 230656 Northern Arizona Distance Learning   Regular School No High 07 12 2019   pk_12_total 26 * *   * *     *   *   20 22     *                 42 26                       20 22                 42
593346 AZ     school 400145 6372   Gem Charter School, Inc. 40014501750 6045 Gem Charter School   Regular School Yes Elementary KG 06 2019   pk_12_total 17 * 13   * *     *   *   20 19     *             *   39 17   13                   20 19                 39
593549 AZ     school 400267 79065   Kestrel Schools, Inc. 40026702091 79111 Valley Preparatory Academy   Regular School Yes High 09 12 2019   pk_12_total * * *   * *     *   *   20 *     *             *   28                         20                   28
593833 AZ     school 400285 79548   Montessori House, Inc. 40028502173 79549 Montessori House Charter School   Regular School Yes Elementary KG 06 2019   pk_12_total 37 * *   * *     *   *   20 18     *             *   38 37                       20 18                 38
594074 AZ     school 400367 79959   Pima Prevention Partnership dba Pima Partnership School, The 40036703531 92994 Pima Prevention Partnership-Tucson   Regular School Yes High 09 12 2019   pk_12_total * * 38   * *     *   *   20 21     *             12   41     38                   20 21             12   41
592926 AZ     school 401600 4470   Camp Verde Unified District 40160003053 90137 South Verde Technology Magnet   Regular School No High 09 12 2019   pk_12_total 13 * 11   * *     *   *   21 12     *             *   33 13   11                   21 12                 33

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