Data source: Big Local News · About: Big Local

29,625 rows where state = "AZ" and year = 2018 sorted by female_int

View and edit SQL

grade

year

  • 2018 · 29,625
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 * * *   * *     *   *   * *     *             *   *                                              
564562 AZ     school 406810 4245   Queen Creek Unified District 40681003438 92628 Queen Creek Virtual Academy   Regular School No High 06 12 2018   pk_12_total * * *   * *     *   *   * 11     *             *   13                           11                 13
564578 AZ     school 407020 4257   Riverside Elementary District 40702003485 92961 Maricopa Institute of Technology   Regular School No Middle 07 08 2018   pk_12_total * * 19   * *     *   *   13 11     *             *   24     19                   13 11                 24
564820 AZ     school 400214 79131   The Shelby School 40021401980 79132 The Shelby School   Regular School Yes Other KG 10 2018   pk_12_total 23 * *   * *     *   *   16 11     *             *   27 23                       16 11                 27
565045 AZ     school 400315 79379   Yavapai Accommodation School District 40031502217 79380 Yavapai County High School   Regular School No High 09 12 2018   pk_12_total 18 * *   * *     *   *   * 11     *             *   20 18                         11                 20
563206 AZ     school 400720 4506   Antelope Union High School District 40072003466 92739 AUHS Online Acadamy   Regular School No High 09 12 2018   pk_12_total * * 19   * *     *   *   14 12     *             *   26     19                   14 12                 26
563650 AZ     school 400189 10971   East Valley Academy 40018901907 78806 East Valley Academy   Regular School Yes Elementary KG 06 2018   pk_12_total 11 * *   * *     *   *   * 12     *             *   17 11                         12                 17
564632 AZ     school 407380 4414   San Fernando Elementary District 40738000630 5853 San Fernando Elementary School   Regular School No Elementary KG 08 2018   pk_12_total * * 17   * *     *   *   * 12     *             *   18     17                     12                 18
564707 AZ     school 407770 4478   Skull Valley Elementary District 40777000390 6113 Skull Valley Elementary School   Regular School No Elementary KG 08 2018   pk_12_total 19 * *   * *     *   *   * 12     *             *   22 19                         12                 22
564975 AZ     school 400391 79907   Vista Charter School 40039103074 80385 Midtown High School   Regular School Yes High 09 12 2018   pk_12_total * * 22   * *     *   *   11 12     *             *   23     22                   11 12                 23
565044 AZ     school 400315 79379   Yavapai Accommodation School District 40031503318 91815 Aspire High School   Regular School No High 09 12 2018   pk_12_total 27 * 13   * *     *   *   30 12     *             11   42 27   13                   30 12             11   42
563234 AZ     school 400913 91958   Arizona Autism Charter Schools, Inc. 40091303455 92598 Arizona Autism Charter School   Regular School Yes Elementary KG 06 2018   pk_12_total 30 * 54   * *     *   *   93 13     *             104   106 30   54                   93 13             104   106
563323 AZ     school 401290 4513   Bouse Elementary District 40129000071 6201 Bouse Elementary School   Regular School No Elementary PK 08 2018   pk_12_total 16 * *   * *     *   *   * 13     *             *   21 16                         13                 21
564082 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 2018   pk_12_total * * 18   * *     *   *   16 13     *             *   29     18                   16 13                 29
564392 AZ     school 400874 91279   Paragon Preparatory Academy 40087403349 91896 Tucson Collegiate Prep   Regular School Yes Middle 06 08 2018   pk_12_total 17 * 12   * *     *   *   27 13     *             *   40 17   12                   27 13                 40
564602 AZ     school 407130 4155   Round Valley Unified District 40713003442 92686 White Mountain Academy   Regular School No High 09 12 2018   pk_12_total 18 * *   * *     *   *   * 13     *             *   23 18                         13                 23
564813 AZ     school 400902 91340   The Farm at Mission Montessori Academy 40090203413 92247 The Farm at Mission Montessori Academy   Regular School Yes Middle 04 08 2018   pk_12_total 25 * *   * *     *   *   17 13     *             *   30 25                       17 13                 30
563640 AZ     school 400311 79059   E-Institute Charter Schools, Inc. 40031103001 90389 E-Institute at Grovers   Regular School Yes High 09 12 2018   pk_12_total 19 * *   * *     *   *   15 14     *             *   29 19                       15 14                 29
563684 AZ     school 400133 6375   Employ-Ability Unlimited, Inc. 40013301888 10799 Desert Pointe Academy   Regular School Yes High 09 12 2018   pk_12_total * * 18   * *     *   *   19 14     *             *   33     18                   19 14                 33
563939 AZ     school 400650 5174   Integrity Education Incorporated 40065001846 10811 Integrity Education Centre   Regular School Yes Other KG 12 2018   pk_12_total 18 * *   * *     *   *   24 14     *             *   38 18                       24 14                 38
564343 AZ     school 405880 4180   Palominas Elementary District 40588001818 78914 Valley View Elementary School   Regular School No Prekindergarten PK PK 2018   pk_12_total 16 * *   * *     *   *   * 14     *             *   24 16                         14                 24
564724 AZ     school 400192 78868   Sonoran Desert School 40019201910 78869 Sonoran Desert School   Regular School Yes High 05 12 2018   pk_12_total 25 * *   * *     *   *   15 14     *             *   29 25                       15 14                 29
565046 AZ     school 409540 4213   Young Elementary District 40954000978 4874 Young Elementary School   Regular School No Elementary PK 08 2018   pk_12_total 21 * *   * *     *   *   14 14     *             *   28 21                       14 14                 28
565049 AZ     school 409570 4377   Yucca Elementary District 40957000323 5582 Yucca Elementary School   Regular School No Elementary PK 08 2018   pk_12_total 19 * *   * *     *   *   16 14     *             *   30 19                       16 14                 30
563115 AZ     school 400965 522074   ASU Preparatory Academy Digital 40096503556 860177 ASU Preparatory Academy Digital   Regular School Yes High 09 12 2018   pk_12_total 26 * *   * *     *   *   23 15     *             *   38 26                       23 15                 38
563708 AZ     school 402860 4192   Flagstaff Unified District 40286003506 230656 Northern Arizona Distance Learning   Regular School No High 07 12 2018   pk_12_total 13 * *   * *     *   *   * 15     *             *   23 13                         15                 23
564398 AZ     school 405980 4510   Parker Unified School District 40598002364 80408 Parker Alternative School   Alternative School No High 09 12 2018   pk_12_total 12 * *   12 *     *   *   18 15     *             *   33 12       12               18 15                 33
564763 AZ     school 408170 4407   Sunnyside Unified District 40817003316 91829 Sunnyside Online Success Academy   Regular School No Other KG 12 2018   pk_12_total * * 26   * *     *   *   16 15     *             *   31     26                   16 15                 31
564842 AZ     school 408680 4197   Tuba City Unified School District #15 40868001822 78916 Tuba City Alternative School   Alternative School No High 07 12 2018   pk_12_total * * *   26 *     *   *   11 15     *             *   26         26               11 15                 26
563554 AZ     school 400278 79496   Deer Valley Charter Schools, Inc. 40027802168 79506 Deer Valley Academy   Regular School Yes High 09 12 2018   pk_12_total 22 * *   * *     *   *   12 16     *             *   28 22                       12 16                 28
563867 AZ     school 403660 4371   Hackberry School District 40366000065 5570 Cedar Hills School   Regular School No Elementary KG 06 2018   pk_12_total 21 * *   * *     *   *   12 16     *             *   28 21                       12 16                 28
564525 AZ     school 400321 79439   Pinnacle Education-WMCB, Inc. 40032102155 79619 Pinnacle Charter High School   Regular School Yes High 09 12 2018   pk_12_total * * 17   * *     *   *   24 16     *             *   40     17                   24 16                 40
564580 AZ     school 407080 4279   Roosevelt Elementary District 40708000600 5375 Amy L. Houston Academy   Special Education School No Elementary PK 08 2018   pk_12_total * 36 52   * *     *   *   82 16     13             88   98   36 52                   82 16     13       88   98
563227 AZ     school 400164 6378   Arizona Academy of Science And Technology, Inc. 40016401726 10755 Arizona Academy of Science and Technology   Regular School Yes Elementary KG 08 2018   pk_12_total * * 17   * *     *   *   17 17     *             *   34     17                   17 17                 34
563367 AZ     school 400633 81029   Canyon Rose Academy, Inc. 40063303536 605648 Canyon Rose Academy-East   Regular School Yes High 09 12 2018   pk_12_total 15 * 15   * *     *   *   22 17     *             *   39 15   15                   22 17                 39

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