enrollments

Data source: Big Local News · About: Big Local

33,750 rows where state = "AZ" and year = 2020 sorted by disability_int

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2020 · 33,750 ✖
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
162233 162233 AZ     school 400328 79457   A Center for Creative Education 40032802228 79458 Verde Valley Montessori School - A Center for Creative Education   Regular School Yes Elementary KG 08 2020   pk_12_total 40 * 20   * *         *   34 33     *   *         *   67 40   20                   34 33                 67
162244 162244 AZ     school 400276 79213   Academy with Community Partners Inc 40027601841 10795 Academy with Community Partners   Alternative School Yes High 09 12 2020   pk_12_total 30 * 90   * *         *   77 55     *   12         *   132 30   90                   77 55       12         132
162248 162248 AZ     school   7355   ACCEL   1000307 ACCEL Ruth Fisher Campus             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162261 162261 AZ     school 400970 449790   AIBT Non-Profit Charter High School, Inc. 40097003546 742847 RCB College Preparatory Academy   Regular School Yes High 09 12 2020   pk_12_total * * *   * *         *   * *     *   *         *   7                                             7
162264 162264 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 2020   pk_12_total * * *   * *         *   * *     *   *         *   11                                             11
162265 162265 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 2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162267 162267 AZ     school 400600 4280   Alhambra Elementary District 40060001283 5381 Alhambra Traditional School   Regular School No Elementary KG 08 2020   pk_12_total 90 60 584   * 19         29   366 424     28   *         *   790 90 60 584     19         29   366 424     28           790
162280 162280 AZ     school 400600 4280   Alhambra Elementary District 40060003599 1000042 Valencia Newcomer School   Regular School No Elementary PK 08 2020   pk_12_total * 85 107   * *         *   105 104     200   *         *   209   85 107                   105 104     200           209
162308 162308 AZ     school 400680 4406   Amphitheater Unified District 40068003330 91755 Amphi Academy Online   Regular School No Other KG 12 2020   pk_12_total 34 * 31   * *         *   41 31     *   *         *   72 34   31                   41 31                 72
162331 162331 AZ     school 400720 4506   Antelope Union High School District 40072003466 92739 AUHS Online Acadamy   Regular School No High 09 12 2020   pk_12_total * * *   * *         *   * *     *   *         *   4                                             4
162333 162333 AZ     school 400750 4178   Apache Elementary District 40075000039 4786 Apache Elementary School   Regular School No Elementary KG 08 2020   pk_12_total * * *   * *         *   * *     *   *         *   12                                             12
162340 162340 AZ     school 400989 92980   ARCHES Academy 40098903642 1000276 ARCHES Academy   Regular School Yes Elementary KG 07 2020   pk_12_total 20 * *   * *         *   15 15     *   *         *   30 20                       15 15                 30
162352 162352 AZ     school 400969 134379   Arizona Agribusiness & Equine Center INC. 40096903543 156568 Arizona Agribusiness & Equine Center, Inc. - Mesa   Regular School Yes High 09 12 2020   pk_12_total 52 * 16   * *         *   28 53     *   *         *   81 52   16                   28 53                 81
162357 162357 AZ     school 400426 87403   Arizona Agribusiness & Equine Center, Inc. 40042602528 87404 Arizona Agribusiness & Equine Center, Inc. - Red Mountain   Regular School Yes High 09 12 2020   pk_12_total 94 * 17   * *         *   48 73     *   *         *   121 94   17                   48 73                 121
162360 162360 AZ     school 400057 4346   Arizona Call-a-Teen Youth Resources, Inc. 40005700784 5520 City View High School   Alternative School Yes High 09 12 2020   pk_12_total * * 94   * *         *   44 65     *   *         *   109     94                   44 65                 109
162367 162367 AZ     school   8336   Arizona Department of Corrections   8337 Success Academy - Florence             2020   pk_12_total * * *   * *         *   * *     *   *         *   5                                             5
162368 162368 AZ     school   8336   Arizona Department of Corrections   8344 Success Academy - Phoenix             2020   pk_12_total * * *   * *         *   * *     *   *         *   1                                             1
162370 162370 AZ     school 400120 8336   Arizona Department of Corrections 40012001812 8339 Success Academy - Winslow   Alternative School No High 09 12 2020   pk_12_total * * *   * *         *   * *     *   *         *   2                                             2
162371 162371 AZ     school   8336   Arizona Department of Corrections   93016 Success Academy Douglas             2020   pk_12_total * * *   * *         *   * *     *   *         *   6                                             6
162372 162372 AZ     school   8336   Arizona Department of Corrections   10229 Success Academy Lewis             2020   pk_12_total * * *   * *         *   * *     *   *         *   11                                             11
162373 162373 AZ     school   8336   Arizona Department of Corrections   8343 Success Academy Perryville             2020   pk_12_total * * *   * *         *   * *     *   *         *   6                                             6
162374 162374 AZ     school   8336   Arizona Department of Corrections   93017 Success Academy Safford             2020   pk_12_total * * *   * *         *   * *     *   *         *   1                                             1
162375 162375 AZ     school   8336   Arizona Department of Corrections   8340 Success Academy Yuma             2020   pk_12_total * * *   * *         *   * *     *   *         *   11                                             11
162377 162377 AZ     school 400827 90758   Arizona Education Solutions 40082703252 91184 Valiant Academy   Regular School Yes Elementary KG 08 2020   pk_12_total 69 27 50   * *         *   82 81     *   *         *   163 69 27 50                   82 81                 163
162379 162379 AZ     school 400918 92566   Arizona Language Preparatory 40091803426 92567 Arizona Language Preparatory   Regular School Yes Elementary KG 06 2020   pk_12_total 41 * 27   * *         *   42 39     *   *         *   81 41   27                   42 39                 81
162394 162394 AZ     school   89922   ASCEND (Autism Spectrum Center for Educational and Neurological Development)   89923 ASCEND (Autism Spectrum Center for Educational and Neurological Development)             2020   pk_12_total * * *   * *         *   * *     *   *         *   2                                             2
162395 162395 AZ     school 400870 4187   Ash Creek Elementary District 40087000046 4797 Ash Creek Elementary   Regular School No Elementary PK 08 2020   pk_12_total 12 * *   * *         *   * *     *   *         *   20 12                                           20
162399 162399 AZ     school   92932   Assist Enterprises, LLC   648314 AZ Aspire Academy - Goodyear             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162400 162400 AZ     school   92932   Assist Enterprises, LLC   339186 AZ Aspire Academy - Queen Creek             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162401 162401 AZ     school   92932   Assist Enterprises, LLC   996075 AZ Aspire Academy - Scottsdale             2020   pk_12_total * * *   * *         *   * *     *   *         *   7                                             7
162413 162413 AZ     school 400947 92987   ASU Preparatory Academy - Casa Grande 40094703526 635758 ASU Preparatory Academy - Casa Grande HS   Regular School Yes High 09 12 2020   pk_12_total 89 * 73   * *         14   156 48     *   *         *   204 89   73               14   156 48                 204
162415 162415 AZ     school   91877   Autism Academy of Education and Development   92679 Autism Academy for Education and Development             2020   pk_12_total * * *   * *         *   * *     *   *         *   6                                             6
162416 162416 AZ     school   91877   Autism Academy of Education and Development   92639 Autism Academy for Education and Development-Tempe             2020   pk_12_total * * *   * *         *   * *     *   *         *   4                                             4
162417 162417 AZ     school   91877   Autism Academy of Education and Development   91919 Autism Academy of Education and Development             2020   pk_12_total * * *   * *         *   * *     *   *         *   5                                             5
162427 162427 AZ     school 400394 79929   Avondale Learning dba Precision Academy 40039402323 80006 Precision Academy   Regular School Yes High 09 12 2020   pk_12_total * * 62   * *         *   36 31     23   *         *   67     62                   36 31     23           67
162430 162430 AZ     school 403950 4412   Baboquivari Unified School District #40 40395003222 90822 Alternative High School (Indian Oasis High School)   Alternative School No High 09 12 2020   pk_12_total * * *   62 *         *   33 33     *   14         *   66         62               33 33       14         66
162431 162431 AZ     school 403950 4412   Baboquivari Unified School District #40 40395003210 90821 Alternative Middle School (Indian Oasis Middle School)   Alternative School No Middle 06 08 2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162452 162452 AZ     school 400941 92734   BASIS Charter Schools, Inc. 40094103502 92735 BASIS Goodyear   Regular School Yes High 05 12 2020   pk_12_total 71 34 66   * 67         23   120 142     *   *         *   262 71 34 66     67         23   120 142                 262
162455 162455 AZ     school 400818 90508   BASIS Charter Schools, Inc. 40081803197 90509 BASIS Oro Valley   Regular School Yes High 05 12 2020   pk_12_total 315 13 104   * 161         27   311 315     *   *         *   626 315 13 104     161         27   311 315                 626
162459 162459 AZ     school 400843 91280   BASIS Charter Schools, Inc. 40084303351 91343 BASIS Phoenix   Regular School Yes High 05 12 2020   pk_12_total 307 19 57   * 346         38   374 398     *   *         *   772 307 19 57     346         38   374 398                 772
162464 162464 AZ     school 400608 81078   BASIS Charter Schools, Inc. 40060803115 81079 BASIS Scottsdale   Regular School Yes Other 04 12 2020   pk_12_total 339 17 62   * 632         68   589 534     *   *         *   1123 339 17 62     632         68   589 534                 1123
162467 162467 AZ     school 400878 91309   BASIS Charter Schools, Inc. 40087803350 91766 BASIS Tucson North   Regular School Yes High 05 12 2020   pk_12_total 433 42 221   11 217         51   490 485     *   *         *   975 433 42 221   11 217         51   490 485                 975
162479 162479 AZ     school 400212 79226   Benson Unified School District 40021202444 85879 San Pedro Valley High School   Alternative School No High 09 12 2020   pk_12_total 18 * *   * *         *   13 15     *   *         *   28 18                       13 15                 28
162480 162480 AZ     school 400212 79226   Benson Unified School District 40021203232 90775 San Pedro Valley Online Academy   Regular School No High 05 12 2020   pk_12_total * * *   * *         *   * *     *   *         *   11                                             11
162481 162481 AZ     school   92692   Beyond Autism, Inc.   92693 Beyond Autism, Inc.             2020   pk_12_total * * *   * *         *   * *     *   *         *   2                                             2
162484 162484 AZ     school 401180 4169   Bisbee Unified District 40118003655 1000301 Copper Credits   Regular School No High 09 12 2020   pk_12_total * * *   * *         *   * *     *   *         *   2                                             2
162488 162488 AZ     school 401230 4231   Blue Elementary District 40123000069 4908 Blue Elementary School   Regular School No Other KG 12 2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162491 162491 AZ     school 406580 4397   Blue Ridge Unified School District No. 32 40658003564 456092 Blue Ridge High School Online   Regular School No High 09 12 2020   pk_12_total * * *   * *         *   * *     *   *         *   8                                             8
162496 162496 AZ     school 401290 4513   Bouse Elementary District 40129000071 6201 Bouse Elementary School   Regular School No Elementary PK 08 2020   pk_12_total 13 * 14   * *         *   15 20     *   *         *   35 13   14                   15 20                 35
162497 162497 AZ     school 401330 4171   Bowie Unified District 40133000072 4758 Bowie Elementary School   Regular School No Elementary PK 08 2020   pk_12_total * * 30   * *         *   19 17     *   *         *   36     30                   19 17                 36
162498 162498 AZ     school 401330 4171   Bowie Unified District 40133000073 4759 Bowie High School   Regular School No High 09 12 2020   pk_12_total 13 * *   * *         *   * *     *   *         *   22 13                                           22
162500 162500 AZ     school   92367   Breakthrough Academy   92914 Breakthrough Academy- East Campus             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162502 162502 AZ     school   91301   Brightmont Academy   91927 Brightmont Academy, Chandler Campus             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162503 162503 AZ     school   91301   Brightmont Academy   92238 Brightmont Academy, Scottsdale Campus             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162528 162528 AZ     school 401600 4470   Camp Verde Unified District 40160003173 84659 Camp Verde Accommodation School   Regular School No High 06 12 2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162532 162532 AZ     school 401600 4470   Camp Verde Unified District 40160003666 1000257 Camp Verde Online   Regular School No High 06 12 2020   pk_12_total 14 * 23   * *         *   20 26     *   *         *   46 14   23                   20 26                 46
162539 162539 AZ     school   79302   Canyon State Academy   89565 Sycamore Canyon Ctr for Youth             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162540 162540 AZ     school 400258 78858   Carden of Tucson, Inc. 40025802079 78859 Carden of Tucson   Regular School Yes Elementary KG 08 2020   pk_12_total 50 * *   * *         *   36 32     *   *         *   68 50                       36 32                 68
162542 162542 AZ     school 400219 79047   Career Success Schools 40021902328 80025 Career Success Jr/Sr High School - North Phoenix   Alternative School Yes High 07 12 2020   pk_12_total 22 * 38   154 *         *   129 96     *   *         *   225 22   38   154               129 96                 225
162543 162543 AZ     school 400219 79047   Career Success Schools 40021902338 80050 Career Success School - Sage Campus   Alternative School Yes Elementary KG 08 2020   pk_12_total * * 125   * *         *   82 77     54   14         *   159     125                   82 77     54 14         159
162544 162544 AZ     school 400219 79047   Career Success Schools 40021902367 80430 Robert L. Duffy High School   Alternative School Yes High 07 12 2020   pk_12_total * * 25   * *         *   17 16     *   *         *   33     25                   17 16                 33
162547 162547 AZ     school 400381 80001   Carpe Diem Collegiate High School 40038102866 89656 Desert View Online School   Regular School Yes High 07 12 2020   pk_12_total * * *   * *         *   * *     *   *         *   2                                             2
162593 162593 AZ     school   8840   Catholic Charities Westside Head Start   7448 Glendale - Burton Head Start             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162594 162594 AZ     school   8840   Catholic Charities Westside Head Start   7453 Glendale - Discovery Head Start             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162595 162595 AZ     school   8840   Catholic Charities Westside Head Start   7450 Glendale - Imes Head Start             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162596 162596 AZ     school   8840   Catholic Charities Westside Head Start   7451 Glendale - Jack Head Start             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162597 162597 AZ     school   8840   Catholic Charities Westside Head Start   84676 Glendale - Mensendick Head Start             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162598 162598 AZ     school   8840   Catholic Charities Westside Head Start   7447 Glendale - Sine Head Start             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162599 162599 AZ     school   8840   Catholic Charities Westside Head Start   7452 Lamar Head Start             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162600 162600 AZ     school   8840   Catholic Charities Westside Head Start   89240 Lattie Coor I AM             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162601 162601 AZ     school   8840   Catholic Charities Westside Head Start   90473 Michael Anderson             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162602 162602 AZ     school   8840   Catholic Charities Westside Head Start   84675 Ocotillo Head Start             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162603 162603 AZ     school   8840   Catholic Charities Westside Head Start   89731 Palo Verde             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162604 162604 AZ     school   8840   Catholic Charities Westside Head Start   92964 Wildflower Catholic Charities Westside Head Start             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162613 162613 AZ     school 400016 4191   Center for Academic Success, Inc. 40001602442 85876 Center for Academic Success #4   Regular School Yes Middle 05 08 2020   pk_12_total * * 238   * *         *   112 127     101   53         *   239     238                   112 127     101 53         239
162616 162616 AZ     school 400016 4191   Center for Academic Success, Inc. 40001600481 4802 Center for Academic Success, The #2   Alternative School Yes High 07 12 2020   pk_12_total * * 193   * *         *   99 96     56   48         *   195     193                   99 96     56 48         195
162617 162617 AZ     school 400016 4191   Center for Academic Success, Inc. 40001601942 79039 Center for Academic Success, The #3   Regular School Yes Elementary KG 04 2020   pk_12_total * * 209   * *         *   102 108     147   44         *   210     209                   102 108     147 44         210
162618 162618 AZ     school   92918   Center for Autism and Related Disorders   539264 CARD Academy Chandler             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162619 162619 AZ     school 400348 79385   Central Arizona Valley Institute of Technology 40034802241 79386 CAVIT - Central Arizona Valley Institute of Technology   Career and Technical School No High 09 12 2020   pk_12_total * * 16   * *         *   * *     *   *         *   26     16                                       26
162625 162625 AZ     school 401870 4242   Chandler Unified District #80 40187002995 90302 Arizona College Prep Oakland Campus   Regular School No Middle 06 08 2020   pk_12_total 277 17 85   * 304         62   380 370     *   *         *   750 277 17 85     304         62   380 370                 750
162631 162631 AZ     school 401870 4242   Chandler Unified District #80 40187003306 91282 Chandler Online Academy   Regular School No High 07 12 2020   pk_12_total 125 * 29   * *         *   72 107     *   *         *   179 125   29                   72 107                 179
162666 162666 AZ     school   8929   Chicanos Por La Causa, Inc.   80639 Eloy Center             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162667 162667 AZ     school   8929   Chicanos Por La Causa, Inc.   80640 Willcox Center             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162668 162668 AZ     school   7927   CHILD PARENT CENTERS, INC   84192 Ajo Headstart             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162669 162669 AZ     school   7927   CHILD PARENT CENTERS, INC   85921 Laguna Headstart             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162670 162670 AZ     school   7927   CHILD PARENT CENTERS, INC   7936 LIBERTY HEAD START             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162671 162671 AZ     school   7927   CHILD PARENT CENTERS, INC   7938 LOS NINOS SUNNYSIDE HEAD START             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162672 162672 AZ     school   7927   CHILD PARENT CENTERS, INC   7942 MISSION MANOR HEAD START             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162673 162673 AZ     school   7927   CHILD PARENT CENTERS, INC   10901 SANTA CLARA HEADSTART             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162674 162674 AZ     school   7927   CHILD PARENT CENTERS, INC   80623 Summitt View Head Start             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162695 162695 AZ     school 400407 85448   CITY Center for Collaborative Learning 40040703448 92561 Paulo Freire Freedom School - Downtown   Regular School Yes Middle 06 08 2020   pk_12_total 37 * 29   * *         *   41 37     *   *         *   78 37   29                   41 37                 78
162698 162698 AZ     school   8821   City of Phoenix - Wilson Headstart   8822 Wilson Headstart             2020   pk_12_total * * 29   * *         *   31 42     *   *         *   73     29                   31 42                 73
162699 162699 AZ     school   89418   City of Phoenix Roosevelt Headstart   89420 Bernard Black Headstart             2020   pk_12_total * * 16   * *         *   * *     *   *         *   20     16                                       20
162700 162700 AZ     school   89418   City of Phoenix Roosevelt Headstart   89423 Cesar Chavez Headstart             2020   pk_12_total * * 76   * *         *   41 43     *   *         *   84     76                   41 43                 84
162701 162701 AZ     school   89418   City of Phoenix Roosevelt Headstart   89426 J.F. Kennedy Headstart             2020   pk_12_total * * 28   * *         *   16 16     *   *         *   32     28                   16 16                 32
162702 162702 AZ     school   89418   City of Phoenix Roosevelt Headstart   89424 J.R. Davis Headstart             2020   pk_12_total * * 20   * *         *   17 13     *   *         *   30     20                   17 13                 30
162703 162703 AZ     school   89418   City of Phoenix Roosevelt Headstart   89427 M.L. King Headstart             2020   pk_12_total * 16 44   * *         *   32 30     *   *         *   62   16 44                   32 30                 62
162704 162704 AZ     school   89418   City of Phoenix Roosevelt Headstart   89422 Maxine O. Bush Headstart             2020   pk_12_total * * 41   * *         *   28 22     *   *         *   50     41                   28 22                 50
162705 162705 AZ     school   89418   City of Phoenix Roosevelt Headstart   475946 Southwest Headstart             2020   pk_12_total * * 45   * *         *   22 29     *   *         *   51     45                   22 29                 51
162706 162706 AZ     school   89418   City of Phoenix Roosevelt Headstart   89419 T.G. Barr Headstart             2020   pk_12_total * * 15   * *         *   * *     *   *         *   20     15                                       20

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