enrollments

Data source: Big Local News · About: Big Local

3,371,677 rows sorted by male_int

✎ View and edit SQL

This data as json, CSV (advanced)

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
96614 96614 AZ     school   7355   ACCEL   91260 ACCEL Buckeye Learning Center             2021   pk_12_total * * 12   * *     *   *   * *     *   *         24   24     12                                   24   24
96629 96629 AZ     school 400970 449790   AIBT Non-Profit Charter High School, Inc. 40097003546 742847 RCB College Preparatory Academy   Regular School Yes High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   16                                             16
96632 96632 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 2021   pk_12_total * * *   11 *     *   *   * *     *   *         *   17         11                                   17
96633 96633 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 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
96641 96641 AZ     school 400600 4280   Alhambra Elementary District 40060003700 1001167 Girls Innovation Academy   Regular School No Middle 05 08 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
96700 96700 AZ     school 400720 4506   Antelope Union High School District 40072003466 92739 AUHS Online Acadamy   Regular School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
96702 96702 AZ     school 400750 4178   Apache Elementary District 40075000039 4786 Apache Elementary School   Regular School No Elementary KG 08 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   12                                             12
96734 96734 AZ     school   8336   Arizona Department of Corrections   92289 Life Learning Academy             2021   pk_12_total * * 23   * *     *   *   * *     *   *         *   35     23                                       35
96735 96735 AZ     school   8336   Arizona Department of Corrections   8348 Success Academy - Eyman             2021   pk_12_total * * *   * *     *   *   * *     *   *         15   16                                         15   16
96736 96736 AZ     school   8336   Arizona Department of Corrections   8337 Success Academy - Florence             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
96737 96737 AZ     school   8336   Arizona Department of Corrections   10229 Success Academy - Lewis             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
96738 96738 AZ     school   8336   Arizona Department of Corrections   8343 Success Academy - Perryville             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
96739 96739 AZ     school   8336   Arizona Department of Corrections   8344 Success Academy - Phoenix             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
96740 96740 AZ     school   8336   Arizona Department of Corrections   93017 Success Academy - Safford             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
96741 96741 AZ     school   8336   Arizona Department of Corrections   8341 Success Academy - Tucson             2021   pk_12_total * * 19   * *     *   *   * *     *   *         28   38     19                                   28   38
96742 96742 AZ     school   8336   Arizona Department of Corrections   8340 Success Academy - Yuma             2021   pk_12_total * * *   * *     *   *   * *     *   *         14   16                                         14   16
96750 96750 AZ     school   89922   ASCEND (Autism Spectrum Center for Educational and Neurological Development)   89923 ASCEND (Autism Spectrum Center for Educational and Neurological Development)             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
96755 96755 AZ     school   92932   Assist Enterprises, LLC   648314 AZ Aspire Academy - Goodyear             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
96756 96756 AZ     school   92932   Assist Enterprises, LLC   339186 AZ Aspire Academy - Queen Creek             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
96757 96757 AZ     school   92932   Assist Enterprises, LLC   996075 AZ Aspire Academy - Scottsdale             2021   pk_12_total * * *   * *     *   *   * *     *   *         12   12                                         12   12
96758 96758 AZ     school   92932   Assist Enterprises, LLC   92933 AZ Aspire Academy - Tempe             2021   pk_12_total 26 * *   * *     *   *   * *     *   *         33   34 26                                       33   34
96770 96770 AZ     school   91877   Autism Academy of Education and Development   92679 Autism Academy for Education and Development             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
96771 96771 AZ     school   91877   Autism Academy of Education and Development   92639 Autism Academy for Education and Development - Tempe             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
96772 96772 AZ     school   91877   Autism Academy of Education and Development   91919 Autism Academy of Education and Development             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
96786 96786 AZ     school 403950 4412   Baboquivari Unified School District #40 40395003210 90821 Alternative Middle School (Indian Oasis Middle School)   Alternative School No Middle 06 08 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
96801 96801 AZ     school   7340   Banner Children's Academy of Education & Development   7341 Banner Academy             2021   pk_12_total * * *   * *     *   *   * *     *   *         14   14                                         14   14
96841 96841 AZ     school 401230 4231   Blue Elementary District 40123000069 4908 Blue Elementary School   Regular School No Other KG 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
96844 96844 AZ     school 406580 4397   Blue Ridge Unified School District No. 32 40658003564 456092 Blue Ridge High School Online   Regular School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
96851 96851 AZ     school 401330 4171   Bowie Unified District 40133000073 4759 Bowie High School   Regular School No High 09 12 2021   pk_12_total * * 12   * *     *   *   * *     *   *         *   21     12                                       21
96853 96853 AZ     school   92367   Breakthrough Academy   92914 Breakthrough Academy- East Campus             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
96864 96864 AZ     school 401410 4284   Buckeye Union High School District 40141003320 91826 BUHSD Institute of Online Learning   Regular School No High 09 12 2021   pk_12_total * * 11   * *     *   *   * *     *   *         *   21     11                                       21
96868 96868 AZ     school 401500 4378   Bullhead City School District 40150000855 5583 Coyote Canyon School   Special Education School No Elementary PK 08 2021   pk_12_total * * *   * *     *   *   * *     *   *         16   16                                         16   16
96881 96881 AZ     school 401600 4470   Camp Verde Unified District 40160003173 84659 Camp Verde Accommodation School   Regular School No High 06 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
96898 96898 AZ     school 400381 80001   Carpe Diem Collegiate High School 40038102866 89656 Desert View Online School   Regular School Yes High 07 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
96944 96944 AZ     school   8840   Catholic Charities Westside Head Start (Use 8808)   7448 Glendale - Burton Head Start             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
96945 96945 AZ     school   8840   Catholic Charities Westside Head Start (Use 8808)   7453 Glendale - Discovery Head Start             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
96946 96946 AZ     school   8840   Catholic Charities Westside Head Start (Use 8808)   7450 Glendale - Imes Head Start             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
96947 96947 AZ     school   8840   Catholic Charities Westside Head Start (Use 8808)   7451 Glendale - Jack Head Start             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
96948 96948 AZ     school   8840   Catholic Charities Westside Head Start (Use 8808)   84676 Glendale - Mensendick Head Start             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
96949 96949 AZ     school   8840   Catholic Charities Westside Head Start (Use 8808)   7447 Glendale - Sine Head Start             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
96950 96950 AZ     school   8840   Catholic Charities Westside Head Start (Use 8808)   7452 Lamar Head Start             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
96951 96951 AZ     school   8840   Catholic Charities Westside Head Start (Use 8808)   89240 Lattie Coor I AM             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
96952 96952 AZ     school   8840   Catholic Charities Westside Head Start (Use 8808)   84675 Ocotillo Head Start             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
96953 96953 AZ     school   8840   Catholic Charities Westside Head Start (Use 8808)   89731 Palo Verde             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
96968 96968 AZ     school   92918   Center for Autism and Related Disorders   539264 CARD Academy Chandler             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
96969 96969 AZ     school 400348 79385   Central Arizona Valley Institute of Technology 40034802279 79806 CAVIT - Casa Grande Union High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
96970 96970 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 2021   pk_12_total * * 18   * *     *   *   * *     *   *         *   31     18                                       31
96971 96971 AZ     school 400348 79385   Central Arizona Valley Institute of Technology 40034802278 79805 CAVIT - Coolidge High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
96972 96972 AZ     school 400348 79385   Central Arizona Valley Institute of Technology 40034802276 79803 CAVIT - Maricopa Unified   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
96973 96973 AZ     school 400348 79385   Central Arizona Valley Institute of Technology 40034803019 90310 CAVIT - Poston Butte High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
96974 96974 AZ     school 400348 79385   Central Arizona Valley Institute of Technology 40034802275 79802 CAVIT - Santa Cruz Valley Union High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97021 97021 AZ     school   7927   Child-Parent Centers, Inc.   84192 Ajo Headstart             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97022 97022 AZ     school   7927   Child-Parent Centers, Inc.   85921 Laguna Head Start             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97023 97023 AZ     school   7927   Child-Parent Centers, Inc.   7936 LIBERTY HEAD START             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97024 97024 AZ     school   7927   Child-Parent Centers, Inc.   7938 LOS NINOS SUNNYSIDE HEAD START             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97025 97025 AZ     school   7927   Child-Parent Centers, Inc.   7942 MISSION MANOR HEAD START             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97026 97026 AZ     school   7927   Child-Parent Centers, Inc.   10901 SANTA CLARA HEADSTART             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97027 97027 AZ     school   7927   Child-Parent Centers, Inc.   80623 Summitt View Head Start             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97028 97028 AZ     school   7927   Child-Parent Centers, Inc.   7952 SUNNYSIDE HEAD START             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97029 97029 AZ     school   7363   Children's Center for Neurodevelopmental Studies   7364 The Childrens Center for Neurodevelopmental Studies             2021   pk_12_total 25 * 13   * *     *   *   * *     *   *         43   45 25   13                                   43   45
97045 97045 AZ     school   81205   Chrysalis Academy   81206 Chrysalis Academy             2021   pk_12_total 13 * *   * *     *   *   * *     *   *         22   22 13                                       22   22
97051 97051 AZ     school   89418   City of Phoenix Roosevelt School District Head Start   89420 Bernard Black Headstart             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   18                                             18
97053 97053 AZ     school   89418   City of Phoenix Roosevelt School District Head Start   89426 J.F. Kennedy Headstart             2021   pk_12_total * * 11   * *     *   *   * *     *   *         *   14     11                                       14
97054 97054 AZ     school   89418   City of Phoenix Roosevelt School District Head Start   89424 J.R. Davis Headstart             2021   pk_12_total * * 17   * *     *   *   * *     *   *         *   20     17                                       20
97057 97057 AZ     school   89418   City of Phoenix Roosevelt School District Head Start   1000383 R.E.S.D.#66 - Campbell School             2021   pk_12_total * * 16   * *     *   *   * *     *   *         *   22     16                                       22
97058 97058 AZ     school   89418   City of Phoenix Roosevelt School District Head Start   1000384 R.E.S.D.#66 - Ed Pastor School             2021   pk_12_total * * 14   * *     *   *   * *     *   *         *   17     14                                       17
97059 97059 AZ     school   89418   City of Phoenix Roosevelt School District Head Start   475946 Southwest Headstart             2021   pk_12_total * * 13   * *     *   *   * *     *   *         *   19     13                                       19
97060 97060 AZ     school   89418   City of Phoenix Roosevelt School District Head Start   89419 T.G. Barr Headstart             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   12                                             12
97062 97062 AZ     school 400316 79391   Cobre Valley Institute of Technology District 40031602979 90402 CVIT - Central Campus EAC Gila Pueblo   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97063 97063 AZ     school 400316 79391   Cobre Valley Institute of Technology District 40031602940 90103 CVIT - Globe High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97064 97064 AZ     school 400316 79391   Cobre Valley Institute of Technology District 40031602103 79791 CVIT - Superior High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97067 97067 AZ     school 400345 79403   Cochise Technology District 40034502261 79680 CTD - Benson High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97068 97068 AZ     school 400345 79403   Cochise Technology District 40034503589 1000115 CTD - Cochise College   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97069 97069 AZ     school 400345 79403   Cochise Technology District 40034502577 79404 CTD - Cochise Technology School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97070 97070 AZ     school 400345 79403   Cochise Technology District 40034502260 79679 CTD - Tombstone High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97071 97071 AZ     school 400345 79403   Cochise Technology District 40034502257 79676 CTD - Valley Union High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97072 97072 AZ     school 400347 79381   Coconino Association for Vocation Industry and Technology 40034702944 89913 CAVIAT - CCC Central Campus   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97073 97073 AZ     school 400347 79381   Coconino Association for Vocation Industry and Technology 40034702470 87467 CAVIAT - Coconino High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97074 97074 AZ     school 400347 79381   Coconino Association for Vocation Industry and Technology 40034703425 92660 CAVIAT - Flagstaff Central Campus   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97075 97075 AZ     school 400347 79381   Coconino Association for Vocation Industry and Technology 40034702471 87468 CAVIAT - Flagstaff High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97076 97076 AZ     school 400347 79381   Coconino Association for Vocation Industry and Technology 40034702269 79784 CAVIAT - Page High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97077 97077 AZ     school 400347 79381   Coconino Association for Vocation Industry and Technology 40034702271 79786 CAVIAT - Williams High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97078 97078 AZ     school 400163 10386   Coconino County Accommodation School District 40016303711 1001242 CCASD Online Instruction   Regular School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97079 97079 AZ     school   10386   Coconino County Accommodation School District   79010 Jail - Coconino County Accommodation School District             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97130 97130 AZ     school 402460 4483   Crown King Elementary District 40246000182 6118 Crown King Elementary School   Regular School No Elementary KG 08 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97131 97131 AZ     school   60691   Cupertino Power Learning Center, Inc.   733509 Cupertino Power Learning Center             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97138 97138 AZ     school 400278 79496   Deer Valley Charter Schools, Inc. 40027802168 79506 Deer Valley Academy   Regular School Yes High 09 12 2021   pk_12_total 15 * *   * *     *   *   * *     *   *         *   21 15                                           21
97177 97177 AZ     school 407750 4246   Deer Valley Unified District 40775003454 92525 Vista Peak   Special Education School No Other PK 12 2021   pk_12_total 46 * 11   * *     *   *   * *     *   *         69   72 46   11                                   69   72
97180 97180 AZ     school   88618   Desert Choice Schools LLC   147909 Desert Choice Schools - Casa Grande Middle School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97181 97181 AZ     school   88618   Desert Choice Schools LLC   812691 Desert Choice Schools - Dos Rios Elementary School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97182 97182 AZ     school   88618   Desert Choice Schools LLC   1000296 Desert Choice Schools - Dysart High School             2021   pk_12_total 11 * *   * *     *   *   * *     *   *         14   14 11                                       14   14
97183 97183 AZ     school   88618   Desert Choice Schools LLC   92894 Desert Choice Schools - Evans Learning Center             2021   pk_12_total * * *   * *     *   *   * *     *   *         19   20                                         19   20
97184 97184 AZ     school   88618   Desert Choice Schools LLC   657386 Desert Choice Schools - Newell Barney Junior High School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97185 97185 AZ     school   88618   Desert Choice Schools LLC   1000049 Desert Choice Schools - Palo Verde Elementary School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97186 97186 AZ     school   88618   Desert Choice Schools LLC   92895 Desert Choice Schools - Pecan Grove Elementary             2021   pk_12_total * * *   * *     *   *   * *     *   *         14   14                                         14   14
97187 97187 AZ     school   88618   Desert Choice Schools LLC   64254 Desert Choice Schools - Queen Creek Elementary             2021   pk_12_total 13 * *   * *     *   *   * *     *   *         22   22 13                                       22   22
97188 97188 AZ     school   88618   Desert Choice Schools LLC   1000297 Desert Choice Schools - Riverview School             2021   pk_12_total 18 * 11   * *     *   *   * *     *   *         38   40 18   11                                   38   40
97189 97189 AZ     school   88618   Desert Choice Schools LLC   88619 Desert Choice Schools - Sheely Farms Elementary School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97190 97190 AZ     school   88618   Desert Choice Schools LLC   1000142 Desert Choice Schools - Yuma High School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97196 97196 AZ     school   7301   Desert Voices Oral Learning Center   7302 Desert Voices Oral Learning Center             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              

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