enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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 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 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 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 563209 AZ     school 400750 4178   Apache Elementary District 40075000039 4786 Apache Elementary School   Regular School No Elementary KG 08 2018   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
563215 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
563247 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 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 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 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 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 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 * * *   * *     *   *   * *     *             *   *                                              
563323 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
563375 563375 AZ     school 400381 80001   Carpe Diem Collegiate High School 40038102866 89656 iSchool2020   Regular School Yes High 07 12 2018   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
563495 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 * * *   * *     *   *   * *     *             *   *                                              
563526 563526 AZ     school 402400 4501   Crane Elementary District 40240003521 778305 Crane iLearning Academy   Regular School No Elementary PK 08 2018   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
563547 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 * * *   * *     *   *   * *     *             *   *                                              
563650 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
563708 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
563715 563715 AZ     school 400144 4300   Florence Crittenton Services of Arizona, Inc. 40014401717 5466 Girls Leadership Academy of Arizona   Regular School Yes High 09 12 2018   pk_12_total * * 87   * *     *   *   * 112     *             15   112     87                     112             15   112
563740 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 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
563785 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 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 * * *   * *     *   *   * *     *             *   *                                              
563910 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 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 * * *   * *     *   *   * *     *             *   *                                              
564081 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 564095 AZ     school 404380 4281   Litchfield Elementary District 40438002431 85844 Verrado Middle School   Regular School No Middle 05 08 2018   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
564124 564124 AZ     school 404630 4404   Marana Unified District 40463000999 5768 A. C. E.   Regular School No High 07 12 2018   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
564149 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 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 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 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 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 564321 AZ     school   4262   Osborn Elementary District   6021 Montecito Community School             2018   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
564324 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
564343 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
564406 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 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 564458 AZ     school 406250 4237   Peoria Unified School District 40625002396 81207 Peoria eCampus   Regular School No Other KG 12 2018   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
564505 564505 AZ     school 400420 87334   Pillar Charter School 40042003277 91213 Pillar Academy Online   Regular School Yes High 09 12 2018   pk_12_total * * 23   * *     *   *   * 21     *             *   29     23                     21                 29
564506 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
564562 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
564602 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
564611 564611 AZ     school 407240 4218   Safford Unified District 40724003507 216045 Henry Dunkerson Pathways Academy   Regular School No High 09 12 2018   pk_12_total 17 * 25   * *     *   *   * 37     *             *   44 17   25                     37                 44
564632 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
564645 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 564695 AZ     school 407700 4393   Show Low Unified District 40770003276 91203 WMI ON LINE   Regular School No High 09 12 2018   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
564704 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
564707 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
564727 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 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 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 * * *   * *     *   *   * *     *             *   *                                              
564926 564926 AZ     school 408800 4403   Tucson Unified District 40880001509 6272 Teenage Parent Program - TAPP   Alternative School No High 06 12 2018   pk_12_total * * 44   * *     *   *   * 62     *             12   68     44                     62             12   68
564974 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
565045 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
565047 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 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 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 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 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 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 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 592766 AZ     school 400750 4178   Apache Elementary District 40075000039 4786 Apache Elementary School   Regular School No Elementary KG 08 2019   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
592804 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 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 592886 AZ     school 401230 4231   Blue Elementary District 40123000069 4908 Blue Elementary School   Regular School No Other KG 12 2019   pk_12_total * * *   * *     *   *   * *     *                 *                                              
592890 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 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 593059 AZ     school   1000098   City School District of Albany   1000099 William S. Hackett Middle School             2019   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
593064 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 593102 AZ     school 402400 4501   Crane Elementary District 40240003521 778305 Crane iLearning Academy   Regular School No Elementary PK 08 2019   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
593114 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 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 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 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 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 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 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 593465 AZ     school 408460 4482   Hillside Elementary District 40846000800 6117 Hillside Elementary School   Regular School No Elementary PK 08 2019   pk_12_total * * *   * *     *   *   * *     *                 *                                              
593475 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 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 593688 AZ     school 404630 4404   Marana Unified District 40463000999 5768 A. C. E.   Regular School No High 07 12 2019   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
593710 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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

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