Data source: Big Local News · About: Big Local

29,565 rows where state = "AZ" and year = 2019 sorted by female_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
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
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 * * *   * *     *   *   * *     *                 *                                              
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
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 * * *   * *     *   *   * *     *             *   *                                              
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
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
593229 AZ     school 400640 81050   Edkey, Inc. - Sequoia School for the Deaf and Hard of Hearing 40064003569 920316 KELLY   Regular School Yes Other KG 12 2019   pk_12_total * * 20   * *     *   *   30 *     *             37   39     20                   30               37   39
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
593292 AZ     school 402920 4437   Florence Unified School District 40292002987 90393 Summit School   Regular School No Other KG 12 2019   pk_12_total 25 * *   * *     *   *   36 *     *             41   41 25                       36               41   41
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 * * *   * *     *   *   * *     *                 *                                              
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
593655 AZ     school 404380 4281   Litchfield Elementary District 40438002003 79220 White Tanks Learning Center   Special Education School No Elementary KG 08 2019   pk_12_total * * 14   * *     *   *   28 *     *             25   32     14                   28               25   32
593688 AZ     school 404630 4404   Marana Unified District 40463000999 5768 A. C. E.   Regular School No High 07 12 2019   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
593708 AZ     school 403860 4234   Maricopa County Regional School District 40386000079 6822 Mesa Transitional Learning Center   Alternative School No Other 03 12 2019   pk_12_total 15 14 25   * *     *   *   52 *     *             23   61 15 14 25                   52               23   61
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
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
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 * * *   * *     *   *   * *     *                 *                                              
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
594068 AZ     school 405360 4401   Pima Accommodation District 40536000961 5654 Court Alternative Program of Education - Detention   Regular School No Other 03 12 2019   pk_12_total 11 * 20   * *     *   *   30 *     *             11   37 11   20                   30               11   37
594069 AZ     school 405360 4401   Pima Accommodation District 40536000963 5656 CAPE School-Jail   Regular School No High 07 12 2019   pk_12_total * * 16   * *     *   *   23 *     *             *   23     16                   23                   23
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
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
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 * * *   * *     *   *   * *     *                 *                                              
594208 AZ     school 407530 4454   Santa Cruz Valley Union High School District 40753002966 90415 Santa Cruz Center for Success   Regular School No High 09 12 2019   pk_12_total * * 25   * *     *   *   25 *     *             *   33     25                   25                   33
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
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
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
594291 AZ     school 400254 79000   Southern Arizona Community Academy, Inc. 40025403420 92518 SACA Online   Regular School Yes High 09 12 2019   pk_12_total * * *   * *     *   *   * *     *                 *                                              
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
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
594495 AZ     school 408800 4403   Tucson Unified District 40880001606 6269 Mary Meredith K-12 School   Alternative School No Other KG 12 2019   pk_12_total 19 * 19   * *     *   *   36 *     *             45   45 19   19                   36               45   45
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
594612 AZ     school 409540 4213   Young Elementary District 40954000978 4874 Young Elementary School   Regular School No Elementary PK 08 2019   pk_12_total 26 * *   * *     *   *   22 *     *             *   32 26                       22                   32
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 * * *   * *     *   *   * *     *                 *                                              
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
593426 AZ     school 400854 90894   Graysmark Schools Corporation 40085403249 91147 Holsteiner Agricultural School   Regular School Yes Elementary KG 06 2019   pk_12_total 26 * *   * *     *   *   28 13     *             *   41 26                       28 13                 41
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
592792 AZ     school 400913 91958   Arizona Autism Charter Schools, Inc. 40091303512 92984 Arizona Autism Charter School, Upper School Campus   Regular School Yes High 05 12 2019   pk_12_total 26 * 43   * *     *   *   70 14     *             83   84 26   43                   70 14             83   84
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
593894 AZ     school 405820 4196   Page Unified District 40582003492 92913 Manson Mesa High School   Regular School No High 09 12 2019   pk_12_total * * *   30 *     *   *   21 14     *             *   35         30               21 14                 35
593159 AZ     school 407750 4246   Deer Valley Unified District 40775003454 92525 Vista Peak   Regular School No Other PK 12 2019   pk_12_total 54 * 13   * *     *   *   68 15     *             69   83 54   13                   68 15             69   83
593170 AZ     school 402490 4179   Double Adobe Elementary District 40249000183 4787 Double Adobe Elementary School   Regular School No Elementary PK 08 2019   pk_12_total 32 * *   * *     *   *   22 15     *             *   37 32                       22 15                 37
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
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
593502 AZ     school 400650 5174   Integrity Education Incorporated 40065001846 10811 Integrity Education Centre   Regular School Yes Other KG 12 2019   pk_12_total 17 * 13   * *     *   *   33 15     *             *   48 17   13                   33 15                 48
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
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
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
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
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
594510 AZ     school   8304   Utah High School   8305 Utah             2019   pk_12_total 31 * *   * *     *   *   15 16     *                 31 31                       15 16                 31
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
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
592791 AZ     school 400913 91958   Arizona Autism Charter Schools, Inc. 40091303455 92598 Arizona Autism Charter School   Regular School Yes Elementary KG 06 2019   pk_12_total 30 * 58   * *     *   *   90 17     *             102   107 30   58                   90 17             102   107
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
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
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
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
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
593958 AZ     school 405980 4510   Parker Unified School District 40598002364 80408 Parker Alternative School   Alternative School No High 09 12 2019   pk_12_total * * 14   22 *     *   *   22 18     *             *   40     14   22               22 18                 40
594129 AZ     school 406870 4159   Red Mesa Unified District 40687000143 4739 Round Rock Elementary School   Regular School No Elementary PK 08 2019   pk_12_total * * *   47 *     *   *   29 18     *             *   47         47               29 18                 47
594405 AZ     school 408680 4197   Tuba City Unified School District #15 40868001152 4834 Dzil Libei Elementary School   Regular School No Elementary PK 06 2019   pk_12_total * * *   41 *     *   *   23 18     *             *   41         41               23 18                 41

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