enrollments

Data source: Big Local News · About: Big Local

3,371,677 rows sorted by white_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
96627 96627 AZ     school 400480 4249   Aguila Elementary District 40048000002 5187 Aguila Elementary School   Regular School No Elementary KG 08 2021   pk_12_total * * 127   * *     *   *   68 69     37   *         19   137     127                   68 69     37       19   137
96628 96628 AZ     school 400274 79053   AIBT Non-Profit Charter High School - Phoenix 40027402020 79123 Career and College Prep   Alternative School Yes High 07 12 2021   pk_12_total * * 77   * *     *   *   49 44     *   *         16   93     77                   49 44             16   93
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 * * *   * *     *   *   * *     *   *         *   *                                              
96634 96634 AZ     school 400600 4280   Alhambra Elementary District 40060003660 1000261 Alhambra Preschool Academy   Regular School No Prekindergarten PK PK 2021   pk_12_total * * 73   * *     *   *   55 35     *   *         72   90     73                   55 35             72   90
96641 96641 AZ     school 400600 4280   Alhambra Elementary District 40060003700 1001167 Girls Innovation Academy   Regular School No Middle 05 08 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
96649 96649 AZ     school 400600 4280   Alhambra Elementary District 40060003599 1000042 Valencia Newcomer School   Regular School No Elementary PK 08 2021   pk_12_total * 64 69   * *     *   *   76 71     147   *         *   147   64 69                   76 71     147           147
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
96708 96708 AZ     school 400318 79426   Aprender Tucson 40031802203 79432 Southside Community School   Regular School Yes Other KG 09 2021   pk_12_total * * 227   * *     *   *   119 118     71   23         30   237     227                   119 118     71 23     30   237
96729 96729 AZ     school 400057 4346   Arizona Call-a-Teen Youth Resources, Inc. 40005700784 5520 City View High School   Alternative School Yes High 09 12 2021   pk_12_total * * 78   * *     *   *   41 54     *   *         *   95     78                   41 54                 95
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
96761 96761 AZ     school 400788 90273   ASU Preparatory Academy 40078802999 90274 ASU Preparatory Academy - South Phoenix Intermediate   Regular School Yes Elementary 03 06 2021   pk_12_total * 12 120   * *     *   *   65 77     32   *         22   142   12 120                   65 77     32       22   142
96762 96762 AZ     school 400956 92716   ASU Preparatory Academy 40095603505 70692 ASU Preparatory Academy - South Phoenix Primary   Regular School Yes Elementary PK 04 2021   pk_12_total * * 55   * *     *   *   39 43     *   *         *   82     55                   39 43                 82
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 * * *   * *     *   *   * *     *   *         *   *                                              
96782 96782 AZ     school 400394 79929   Avondale Learning dba Precision Academy 40039402323 80006 Precision Academy   Regular School Yes High 09 12 2021   pk_12_total * * 67   * *     *   *   32 36     26   *         *   68     67                   32 36     26           68
96784 96784 AZ     school 400094 4508   Az-Tec High School 40009401109 6192 AZTEC High School   Alternative School Yes High 09 12 2021   pk_12_total * * 85   * *     *   *   43 53     *   *         17   96     85                   43 53             17   96
96785 96785 AZ     school 403950 4412   Baboquivari Unified School District #40 40395003222 90822 Alternative High School (Indian Oasis High School)   Alternative School No High 09 12 2021   pk_12_total * * *   45 *     *   *   21 31     *   12         *   52         45               21 31       12         52
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 * * *   * *     *   *   * *     *   *         *   *                                              
96787 96787 AZ     school 403950 4412   Baboquivari Unified School District #40 40395000310 5847 Baboquivari High School   Regular School No High 09 12 2021   pk_12_total * * *   195 *     *   *   111 97     *   43         36   208         195               111 97       43     36   208
96788 96788 AZ     school 403950 4412   Baboquivari Unified School District #40 40395000311 5846 Baboquivari Middle School   Regular School No Middle 07 08 2021   pk_12_total * * *   123 *     *   *   73 63     *   29         25   136         123               73 63       29     25   136
96789 96789 AZ     school 403950 4412   Baboquivari Unified School District #40 40395003566 948673 Indian Oasis Intermediate Elementary School   Regular School No Middle 04 06 2021   pk_12_total * * *   214 *     *   *   107 125     *   27         22   232         214               107 125       27     22   232
96790 96790 AZ     school 403950 4412   Baboquivari Unified School District #40 40395000312 5844 Indian Oasis Primary Elementary School   Regular School No Elementary PK 03 2021   pk_12_total * * 17   307 *     *   *   152 180     *   44         43   332     17   307               152 180       44     43   332
96799 96799 AZ     school 401050 4268   Balsz Elementary District 40105003374 92301 Orangedale Early Learning Center   Special Education School No Prekindergarten PK PK 2021   pk_12_total * * 16   * *     *   *   15 11     *   *         26   26     16                   15 11             26   26
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 * * *   * *     *   *   * *     *   *         *   *                                              
96849 96849 AZ     school 401290 4513   Bouse Elementary District 40129000071 6201 Bouse Elementary School   Regular School No Elementary PK 08 2021   pk_12_total * * 22   * *     *   *   18 23     11   *         *   41     22                   18 23     11           41
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 * * *   * *     *   *   * *     *   *         *   *                                              
96895 96895 AZ     school 400219 79047   Career Success Schools 40021902367 80430 Robert L. Duffy High School   Alternative School Yes High 07 12 2021   pk_12_total * * 17   * *     *   *   16 12     *   *         *   28     17                   16 12                 28
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 * * *   * *     *   *   * *     *   *         *   *                                              
96920 96920 AZ     school 400915 91934   CASA Academy 40091503422 92498 CASA Academy   Regular School Yes Elementary KG 03 2021   pk_12_total * 39 94   * 16     *   *   71 85     *   *         13   156   39 94     16             71 85             13   156
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 * * *   * *     *   *   * *     *   *         *   *                                              
96962 96962 AZ     school 401810 4395   Cedar Unified District 40181000325 5638 Jeddito School   Regular School No Elementary PK 08 2021   pk_12_total * * *   102 *     *   *   48 57     14   32         15   105         102               48 57     14 32     15   105
96963 96963 AZ     school 400016 4191   Center for Academic Success, Inc. 40001602442 85876 Center for Academic Success #4   Regular School Yes Middle 05 08 2021   pk_12_total * * 213   * *     *   *   107 106     70   134         *   213     213                   107 106     70 134         213
96966 96966 AZ     school 400016 4191   Center for Academic Success, Inc. 40001600481 4802 Center for Academic Success, The #2   Alternative School Yes High 07 12 2021   pk_12_total * * 184   * *     *   *   90 97     61   143         *   187     184                   90 97     61 143         187
96967 96967 AZ     school 400016 4191   Center for Academic Success, Inc. 40001601942 79039 Center for Academic Success, The #3   Regular School Yes Elementary KG 04 2021   pk_12_total * * 199   * *     *   *   95 105     130   98         *   200     199                   95 105     130 98         200
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 * * *   * *     *   *   * *     *   *         *   *                                              
97030 97030 AZ     school 401940 4158   Chinle Unified District 40194000136 4733 Canyon De Chelly Elementary School   Regular School No Elementary PK 06 2021   pk_12_total * * *   306 *     *   *   153 159     28   *         38   312         306               153 159     28       38   312
97031 97031 AZ     school 401940 4158   Chinle Unified District 40194000135 4732 Chinle Elementary School   Regular School No Elementary PK 06 2021   pk_12_total * * *   484 *     *   *   254 238     30   *         49   492         484               254 238     30       49   492
97032 97032 AZ     school 401940 4158   Chinle Unified District 40194000137 4737 Chinle High School   Regular School No High 09 12 2021   pk_12_total * * *   866 *     *   *   444 436     82   *         123   880         866               444 436     82       123   880
97033 97033 AZ     school 401940 4158   Chinle Unified District 40194000138 4731 Chinle Junior High School   Regular School No Middle 07 08 2021   pk_12_total * * *   308 *     *   *   162 152     31   *         44   314         308               162 152     31       44   314
97034 97034 AZ     school 401940 4158   Chinle Unified District 40194000140 4734 Many Farms Elementary School   Regular School No Elementary KG 08 2021   pk_12_total * * *   356 *     *   *   182 181     52   *         27   363         356               182 181     52       27   363
97035 97035 AZ     school 401940 4158   Chinle Unified District 40194001488 4736 Mesa View Elementary   Regular School No Elementary PK 06 2021   pk_12_total * * *   363 *     *   *   195 176     35   *         42   371         363               195 176     35       42   371
97036 97036 AZ     school 401940 4158   Chinle Unified District 40194000145 4735 Tsaile Elementary School   Regular School No Elementary PK 08 2021   pk_12_total * * *   466 *     *   *   244 222     48   *         48   466         466               244 222     48       48   466
97050 97050 AZ     school   8823   City of Phoenix - Alhambra H/S   8824 City Of Phoenix Alhambra Headstart             2021   pk_12_total * 20 217   * *     *   *   132 129     *   *         21   261   20 217                   132 129             21   261
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
97055 97055 AZ     school   89418   City of Phoenix Roosevelt School District Head Start   89427 M.L. King Headstart             2021   pk_12_total * 16 31   * *     *   *   24 25     *   *         *   49   16 31                   24 25                 49
97056 97056 AZ     school   89418   City of Phoenix Roosevelt School District Head Start   89422 Maxine O. Bush Headstart             2021   pk_12_total * * 27   * *     *   *   23 19     *   *         *   42     27                   23 19                 42
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 * * *   * *     *   *   * *     *   *         *   *                                              

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