Data source: Big Local News · About: Big Local

127,680 rows where state = "AZ" sorted by female_int

View and edit SQL

grade

year

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
563103 AZ     school 400970 449790   AIBT Non-Profit Charter High School, Inc. 40097003546 742847 RCB College Preparatory Academy   Regular School Yes High 09 12 2018   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
563113 AZ     school 400971 631426   ASU Preparatory Academy 40097103567 338609 ASU Preparatory Academy - Tempe   Regular School Yes High 09 12 2018   pk_12_total * * *   * *     *   *   * *     *             *   17                                             17
563140 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 2018   pk_12_total * * *   13 *     *   *   * *     *             *   17         13                                   17
563209 AZ     school 400750 4178   Apache Elementary District 40075000039 4786 Apache Elementary School   Regular School No Elementary KG 08 2018   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
563215 AZ     school 400790 4443   Apache Junction Unified District 40079003333 91810 Superstition Mountain On-Line School   Regular School No High 07 12 2018   pk_12_total * * *   * *     *   *   * *     *             *   13                                             13
563235 AZ     school 400913 91958   Arizona Autism Charter Schools, Inc. 40091303512 92984 Arizona Autism Charter School, Upper School Campus   Regular School Yes Middle 05 08 2018   pk_12_total 21 * 35   * *     *   *   61 *     *             70   71 21   35                   61               70   71
563247 AZ     school 400870 4187   Ash Creek Elementary District 40087000046 4797 Ash Creek Elementary   Regular School No Elementary PK 08 2018   pk_12_total 17 * *   * *     *   *   * *     *             *   18 17                                           18
563283 AZ     school 403950 4412   Baboquivari Unified School District #40 40395003210 90821 Alternative Middle School (Indian Oasis Middle School)   Regular School No Middle 06 08 2018   pk_12_total * * *   11 *     *   *   * *     *             *   11         11                                   11
563307 AZ     school 400212 79226   Benson Unified School District 40021202444 85879 San Pedro Valley High School   Regular School No High 09 12 2018   pk_12_total * * *   * *     *   *   * *     *             *   16                                             16
563308 AZ     school 400212 79226   Benson Unified School District 40021203232 90775 San Pedro Valley Online Academy   Regular School No High 05 12 2018   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
563314 AZ     school 401230 4231   Blue Elementary District 40123000069 4908 Blue Elementary School   Regular School No Other KG 12 2018   pk_12_total 12 * *   * *     *   *   * *     *             *   12 12                                           12
563317 AZ     school 406580 4397   Blue Ridge Unified School District No. 32 40658003564 456092 Blue Ridge High School Online   Regular School No High 09 12 2018   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
563325 AZ     school 401330 4171   Bowie Unified District 40133000073 4759 Bowie High School   Regular School No High 09 12 2018   pk_12_total * * 14   * *     *   *   14 *     *             *   22     14                   14                   22
563359 AZ     school 401600 4470   Camp Verde Unified District 40160003173 84659 Camp Verde Accommodation School   Alternative School No High 06 12 2018   pk_12_total * * *   * *     *   *   12 *     *             *   17                         12                   17
563363 AZ     school 401600 4470   Camp Verde Unified District 40160003053 90137 South Verde Technology Magnet   Regular School No High 09 12 2018   pk_12_total 11 * *   * *     *   *   13 *     *             *   23 11                       13                   23
563375 AZ     school 400381 80001   Carpe Diem Collegiate High School 40038102866 89656 iSchool2020   Regular School Yes High 07 12 2018   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
563495 AZ     school 400163 10386   Coconino County Accommodation School District 40016301821 79010 County Jail Education Program   Regular School No High 07 12 2018   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
563496 AZ     school 400163 10386   Coconino County Accommodation School District 40016301820 78915 Juvenile Detention Education Program   Regular School No Other 04 12 2018   pk_12_total * * *   * *     *   *   13 *     *             *   14                         13                   14
563526 AZ     school 402400 4501   Crane Elementary District 40240003521 778305 Crane iLearning Academy   Regular School No Elementary PK 08 2018   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
563547 AZ     school 402460 4483   Crown King Elementary District 40246000182 6118 Crown King Elementary School   Regular School No Elementary KG 08 2018   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
563592 AZ     school 407750 4246   Deer Valley Unified District 40775003454 92525 Vista Peak   Regular School No Other PK 12 2018   pk_12_total 40 * *   * *     *   *   55 *     *             55   59 40                       55               55   59
563668 AZ     school 400640 81050   Edkey, Inc. - Sequoia School for the Deaf and Hard of Hearing 40064003569 920316 KELLY   Regular School Yes Other KG 12 2018   pk_12_total * * 15   * *     *   *   27 *     *             33   33     15                   27               33   33
563727 AZ     school 402920 4437   Florence Unified School District 40292002987 90393 Summit School   Regular School No Other KG 12 2018   pk_12_total 28 * *   * *     *   *   41 *     *             45   45 28                       41               45   45
563740 AZ     school 400036 4309   Foothills Academy 40003603421 92407 Foothills Academy Connected   Regular School Yes High 07 12 2018   pk_12_total 14 * *   * *     *   *   * *     *             *   14 14                                           14
563746 AZ     school 403200 4221   Fort Thomas Unified District 40320002946 90064 Mt. Turnbull Academy   Regular School No High 09 12 2018   pk_12_total * * *   19 *     *   *   * *     *             *   19         19                                   19
563780 AZ     school 400145 6372   Gem Charter School, Inc. 40014501750 6045 Gem Charter School   Regular School Yes Elementary KG 06 2018   pk_12_total * * 12   * *     *   *   19 *     *             *   29     12                   19                   29
563785 AZ     school 400419 87600   Gila County Regional School District 40041902897 90038 Biyaagozhoo Center   Regular School No Other 03 12 2018   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
563800 AZ     school 403400 4239   Gilbert Unified District 40340003262 91155 Gilbert Global Academy Junior High   Regular School No Middle 07 08 2018   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
563901 AZ     school 408460 4482   Hillside Elementary District 40846000800 6117 Hillside Elementary School   Regular School No Elementary PK 08 2018   pk_12_total 12 * *   * *     *   *   11 *     *             *   16 12                       11                   16
563910 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 2018   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
563941 AZ     school 400107 4334   International Commerce Secondary Schools, Inc. 40010701590 5506 Humanities and Sciences High School - Phoenix   Regular School Yes High 09 12 2018   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
563986 AZ     school 400267 79065   Kestrel Schools, Inc. 40026702091 79111 Valley Preparatory Academy   Regular School Yes High 09 12 2018   pk_12_total * * *   * *     *   *   19 *     *             *   24                         19                   24
564070 AZ     school 400944 92730   Leman Academy of Excellence, Inc. 40094403547 271268 Leman Virtual Academy   Regular School Yes Elementary KG 08 2018   pk_12_total 14 * *   * *     *   *   11 *     *             *   21 14                       11                   21
564081 AZ     school 400393 79926   Lifelong Learning Research Institute, Inc. 40039302297 79927 Lifelong Learning Academy   Regular School Yes Elementary KG 08 2018   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
564095 AZ     school 404380 4281   Litchfield Elementary District 40438002431 85844 Verrado Middle School   Regular School No Middle 05 08 2018   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
564097 AZ     school 404380 4281   Litchfield Elementary District 40438002003 79220 White Tanks Learning Center   Special Education School No Elementary KG 08 2018   pk_12_total * * *   * *     *   *   26 *     *             25   29                         26               25   29
564124 AZ     school 404630 4404   Marana Unified District 40463000999 5768 A. C. E.   Regular School No High 07 12 2018   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
564147 AZ     school 403860 4234   Maricopa County Regional School District 40386000079 6822 Mesa Transitional Learning Center   Alternative School No Other 03 12 2018   pk_12_total 15 * 23   * *     *   *   47 *     *             13   54 15   23                   47               13   54
564149 AZ     school 403860 4234   Maricopa County Regional School District 40386002365 80410 Tumbleweed Transitional Learning Center   Regular School No High 08 12 2018   pk_12_total * * 11   * *     *   *   * *     *             *   12     11                                       12
564254 AZ     school 405070 4488   Mingus Union High School District 40507003308 91320 Mingus Online Academy   Regular School No High 08 12 2018   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
564256 AZ     school 405100 4253   Mobile Elementary District 40510000431 5191 Mobile Elementary School   Regular School No Elementary KG 08 2018   pk_12_total * * *   * *     *   *   * *     *             *   19                                             19
564270 AZ     school 400126 4428   Montessori Schoolhouse of Tucson, Inc. 40012601620 5869 Montessori Schoolhouse   Regular School Yes Elementary KG KG 2018   pk_12_total * * *   * *     *   *   * *     *             *   13                                             13
564287 AZ     school 405500 4386   Navajo County Accommodation District #99 40550001237 7654 Navajo County Instruction for Success (NCIS)   Special Education School No High 09 12 2018   pk_12_total * * *   * *     *   *   * *     *             *   12                                             12
564321 AZ     school   4262   Osborn Elementary District   6021 Montecito Community School             2018   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
564324 AZ     school 405730 4373   Owens School District No.6 40573000466 5578 Owens Elementary School   Regular School No Elementary KG 08 2018   pk_12_total 16 * *   * *     *   *   * *     *             *   18 16                                           18
564403 AZ     school 400263 79069   Patagonia Montessori Elementary School 40026302083 79107 Patagonia Montessori School   Regular School Yes Elementary KG 08 2018   pk_12_total 23 * *   * *     *   *   18 *     *             *   26 23                       18                   26
564406 AZ     school 400344 78890   Pathways KM Charter Schools, Inc 40034403467 92883 Bella Vista Academy   Regular School Yes Middle 06 08 2018   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
564408 AZ     school 406070 4209   Payson Unified District 40607003305 91196 Payson Center for Success - Online   Regular School No High 07 12 2018   pk_12_total * * *   * *     *   *   * *     *             *   15                                             15
564458 AZ     school 406250 4237   Peoria Unified School District 40625002396 81207 Peoria eCampus   Regular School No Other KG 12 2018   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
564506 AZ     school 400420 87334   Pillar Charter School 40042002522 87335 Pillar Academy of Business & Finance   Regular School Yes High 09 12 2018   pk_12_total * * *   * *     *   *   * *     *             *   11                                             11
564507 AZ     school 405360 4401   Pima Accommodation District 40536000961 5654 CAPE School-Detention   Regular School No Other 03 12 2018   pk_12_total * * 17   * *     *   *   22 *     *             *   28     17                   22                   28
564508 AZ     school 405360 4401   Pima Accommodation District 40536000963 5656 CAPE School-Jail   Regular School No High 08 12 2018   pk_12_total * * 17   * *     *   *   23 *     *             *   25     17                   23                   25
564515 AZ     school 406440 4220   Pima Unified District 40644003362 92296 Gila Valley Learning Center   Regular School No High 09 12 2018   pk_12_total 12 * *   * *     *   *   15 *     *             *   17 12                       15                   17
564526 AZ     school 400321 79439   Pinnacle Education-WMCB, Inc. 40032103565 289884 Pinnacle Online - WMCB   Regular School Yes High 09 12 2018   pk_12_total * * 11   * *     *   *   13 *     *             *   22     11                   13                   22
564645 AZ     school 407530 4454   Santa Cruz Valley Union High School District 40753002966 90415 Santa Cruz Center for Success   Regular School No High 09 12 2018   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
564695 AZ     school 407700 4393   Show Low Unified District 40770003276 91203 WMI ON LINE   Regular School No High 09 12 2018   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
564697 AZ     school 407700 4393   Show Low Unified District 40770001941 79646 White Mountain Institute   Regular School No High 09 12 2018   pk_12_total 11 * *   * *     *   *   12 *     *             *   18 11                       12                   18
564704 AZ     school 401460 4175   Sierra Vista Unified District 40146003524 440989 Sierra Vista Online   Regular School No High 09 12 2018   pk_12_total * * *   * *     *   *   * *     *             *   12                                             12
564727 AZ     school 400254 79000   Southern Arizona Community Academy, Inc. 40025403420 92518 SACA Online   Regular School Yes High 09 12 2018   pk_12_total * * *   * *     *   *   * *     *             *   17                                             17
564736 AZ     school 408080 4153   St Johns Unified District 40808002871 89607 St. Johns Learning Center   Regular School No High 09 12 2018   pk_12_total * * *   * *     *   *   * *     *             *   13                                             13
564829 AZ     school 408520 4288   Tolleson Union High School District 40852003206 90551 University High School   Regular School No High 09 12 2018   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
564899 AZ     school 408800 4403   Tucson Unified District 40880001606 6269 Mary Meredith K-12 School   Alternative School No Other KG 12 2018   pk_12_total 16 * 16   * *     *   *   32 *     *             41   41 16   16                   32               41   41
564974 AZ     school 400160 4430   Vision Charter School, Inc. 40016001779 5871 Vision Charter School   Regular School Yes High 09 12 2018   pk_12_total * * 13   * *     *   *   * *     *             *   20     13                                       20
565047 AZ     school 409540 4213   Young Elementary District 40954001119 4875 Young High School   Regular School No High 09 12 2018   pk_12_total 12 * *   * *     *   *   * *     *             *   13 12                                           13
565067 AZ     school 409600 4499   Yuma Elementary District 40960003430 92641 Yuma District One Digital Learning Academy   Regular School No Elementary KG 08 2018   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
565075 AZ     school 409630 4507   Yuma Union High School District 40963003280 91316 Yuma Online Distance Academy   Regular School No High 09 12 2018   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
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

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