Data source: Big Local News · About: Big Local

2,250 rows where grade = "pk_12_total", state = "AZ" and year = 2020 sorted by multiracial

View and edit SQL

year

  • 2020 · 2,150

grade

  • pk_12_total · 2,150
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
162424 AZ     school 400960 4272   Avondale Elementary District 40096000051 5349 Lattie Coor   Regular School No Elementary PK 02 2020   pk_12_total 53 63 221   * *         *   180 167     85   17         52   346 53 63 221                   180 167     85 17     52   346
162425 AZ     school 400960 4272   Avondale Elementary District 40096000049 5347 Michael Anderson   Regular School No Elementary PK 08 2020   pk_12_total 39 44 745   * *         *   425 414     171   *         91   839 39 44 745                   425 414     171       91   839
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
162429 AZ     school 400094 4508   Az-Tec High School 40009401109 6192 AZTEC High School   Alternative School Yes High 09 12 2020   pk_12_total * * 82   * *         *   47 42     *   *         15   89     82                   47 42             15   89
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 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 * * *   * *         *   * *     *   *         *   *                                              
162432 AZ     school 403950 4412   Baboquivari Unified School District #40 40395000310 5847 Baboquivari High School   Regular School No High 09 12 2020   pk_12_total * * *   192 *         *   103 99     *   *         35   202         192               103 99             35   202
162433 AZ     school 403950 4412   Baboquivari Unified School District #40 40395000311 5846 Baboquivari Middle School   Regular School No Middle 07 08 2020   pk_12_total * * *   129 *         *   72 64     *   *         35   136         129               72 64             35   136
162434 AZ     school 403950 4412   Baboquivari Unified School District #40 40395003566 948673 Indian Oasis Intermediate Elementary School   Regular School No Middle 04 06 2020   pk_12_total * * 12   228 *         *   112 133     *   29         46   245     12   228               112 133       29     46   245
162435 AZ     school 403950 4412   Baboquivari Unified School District #40 40395000312 5844 Indian Oasis Primary Elementary School   Regular School No Elementary PK 03 2020   pk_12_total * * 17   343 *         *   175 193     *   27         62   368     17   343               175 193       27     62   368
162436 AZ     school 401000 4468   Bagdad Unified District 40100000052 6088 Bagdad Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 143 * 65   17 *         *   119 116     *   27         56   235 143   65   17               119 116       27     56   235
162437 AZ     school 401000 4468   Bagdad Unified District 40100000053 6089 Bagdad Middle / Senior High School   Regular School No High 06 12 2020   pk_12_total 160 * 81   * *         *   139 114     *   31         43   253 160   81                   139 114       31     43   253
162444 AZ     school 401050 4268   Balsz Elementary District 40105003374 92301 Orangedale Early Learning Center   Special Education School No Prekindergarten PK PK 2020   pk_12_total * * 12   * *         *   14 11     *   *         25   25     12                   14 11             25   25
162446 AZ     school   7340   Banner Children's Academy of Education & Development   7341 Banner Academy             2020   pk_12_total 15 * *   * *         *   * *     *   *         19   21 15                                       19   21
162476 AZ     school 400212 79226   Benson Unified School District 40021200061 4799 Benson High School   Regular School No High 09 12 2020   pk_12_total 276 * 101   * *         *   210 190     *   *         42   400 276   101                   210 190             42   400
162477 AZ     school 400212 79226   Benson Unified School District 40021201120 4794 Benson Middle School   Regular School No Middle 05 08 2020   pk_12_total 221 * 89   * *         *   169 158     *   *         49   327 221   89                   169 158             49   327
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 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 AZ     school   92692   Beyond Autism, Inc.   92693 Beyond Autism, Inc.             2020   pk_12_total * * *   * *         *   * *     *   *         *   2                                             2
162482 AZ     school 401160 4515   Bicentennial Union High School District 40116000062 6203 Salome High School   Regular School No High 09 12 2020   pk_12_total 42 * 85   * *         *   71 62     12   *         24   133 42   85                   71 62     12       24   133
162483 AZ     school 401180 4169   Bisbee Unified District 40118000063 4754 Bisbee High School   Regular School No High 09 12 2020   pk_12_total 58 * 243   * *         *   177 133     55   *         33   310 58   243                   177 133     55       33   310
162484 AZ     school 401180 4169   Bisbee Unified District 40118003655 1000301 Copper Credits   Regular School No High 09 12 2020   pk_12_total * * *   * *         *   * *     *   *         *   2                                             2
162485 AZ     school 401180 4169   Bisbee Unified District 40118000066 4752 Greenway Primary School   Regular School No Elementary KG 05 2020   pk_12_total 76 * 146   * *         *   114 114     14   *         21   228 76   146                   114 114     14       21   228
162486 AZ     school 401180 4169   Bisbee Unified District 40118000064 4753 Lowell School   Regular School No Middle 06 08 2020   pk_12_total 38 * 110   * *         *   85 69     19   *         23   154 38   110                   85 69     19       23   154
162487 AZ     school 400771 89871   Blue Adobe Project 40077102899 89872 Sky Islands   Regular School Yes High 09 12 2020   pk_12_total 35 * 23   * *         *   37 36     *   *         20   73 35   23                   37 36             20   73
162488 AZ     school 401230 4231   Blue Elementary District 40123000069 4908 Blue Elementary School   Regular School No Other KG 12 2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
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
162493 AZ     school 400636 81041   Blueprint Education 40063603108 81042 Hope High School   Alternative School Yes High 09 12 2020   pk_12_total 28 33 156   * *         *   136 101     *   *         38   237 28 33 156                   136 101             38   237
162495 AZ     school 401260 4224   Bonita Elementary District 40126000070 4896 Bonita Elementary School   Regular School No Elementary KG 08 2020   pk_12_total 57 * 39   * *         *   45 55     *   *         13   100 57   39                   45 55             13   100
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 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 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
162499 AZ     school 400033 4305   Boys & Girls Clubs of the East Valley dba Mesa Arts Academy 40003300703 5470 Mesa Arts Academy   Regular School Yes Elementary KG 08 2020   pk_12_total 41 22 152   * *         *   122 108     25   *         30   230 41 22 152                   122 108     25       30   230
162500 AZ     school   92367   Breakthrough Academy   92914 Breakthrough Academy- East Campus             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162502 AZ     school   91301   Brightmont Academy   91927 Brightmont Academy, Chandler Campus             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162503 AZ     school   91301   Brightmont Academy   92238 Brightmont Academy, Scottsdale Campus             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162515 AZ     school 401500 4378   Bullhead City School District 40150000855 5583 Coyote Canyon School   Special Education School No Elementary PK 08 2020   pk_12_total * * *   * *         *   * *     *   *         18   18                                         18   18
162525 AZ     school 400182 78888   Cambridge Academy East, Inc 40018201890 78889 Cambridge Academy East   Regular School Yes Elementary KG 06 2020   pk_12_total 154 * 60   * *         *   112 118     *   *         32   230 154   60                   112 118             32   230
162526 AZ     school 400182 78888   Cambridge Academy East, Inc 40018202964 90325 Cambridge Academy East   Regular School Yes Elementary KG 08 2020   pk_12_total 79 18 49   * *         *   76 82     *   *         32   158 79 18 49                   76 82             32   158
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 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
162534 AZ     school 401650 4484   Canon Elementary District 40165000088 6119 Canon School   Regular School No Elementary PK 08 2020   pk_12_total 107 * 18   * *         *   75 68     *   11         16   143 107   18                   75 68       11     16   143
162535 AZ     school 400633 81029   Canyon Rose Academy, Inc. 40063303106 81030 Canyon Rose Academy   Alternative School Yes High 09 12 2020   pk_12_total 51 * 146   * *         *   104 115     *   *         33   219 51   146                   104 115             33   219
162536 AZ     school 400633 81029   Canyon Rose Academy, Inc. 40063303536 605648 Canyon Rose Academy-East   Alternative School Yes High 09 12 2020   pk_12_total 50 * 35   * *         *   62 36     *   *         20   98 50   35                   62 36             20   98
162537 AZ     school   79302   Canyon State Academy   79303 Canyon State Academy             2020   pk_12_total 18 * 29   * *         *   * *     *   *         32   60 18   29                                   32   60
162538 AZ     school   79302   Canyon State Academy   90438 Prestige School at Rite of Passage             2020   pk_12_total * * *   * *         *   * *     *   *         16   16                                         16   16
162539 AZ     school   79302   Canyon State Academy   89565 Sycamore Canyon Ctr for Youth             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
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
162541 AZ     school 400077 4400   Career Development, Inc. 40007700943 5652 Northern AZ Academy for Career Dev. - Taylor   Alternative School Yes High 09 12 2020   pk_12_total 33 * *   * *         *   27 22     *   *         18   49 33                       27 22             18   49
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 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 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
162546 AZ     school 400381 80001   Carpe Diem Collegiate High School 40038102319 80002 Desert View Middle & High School   Regular School Yes High 06 12 2020   pk_12_total 43 * 149   * *         *   106 99     14   *         34   205 43   149                   106 99     14       34   205
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
162548 AZ     school 401680 4282   Cartwright Elementary District 40168002135 79283 Bret R. Tarver   Regular School No Elementary KG 06 2020   pk_12_total 19 61 587   17 *         *   357 333     202   16         52   690 19 61 587   17               357 333     202 16     52   690
162549 AZ     school 401680 4282   Cartwright Elementary District 40168001054 5414 Byron A. Barry School   Regular School No Prekindergarten PK PK 2020   pk_12_total 19 16 278   * *         *   182 141     *   *         155   323 19 16 278                   182 141             155   323
162550 AZ     school 401680 4282   Cartwright Elementary District 40168000089 5398 Cartwright School   Regular School No Elementary KG 08 2020   pk_12_total 15 18 651   * *         *   355 346     195   *         64   701 15 18 651                   355 346     195       64   701
162551 AZ     school 401680 4282   Cartwright Elementary District 40168000091 5405 Charles W. Harris School   Regular School No Elementary KG 08 2020   pk_12_total 18 24 927   * *         *   526 456     338   17         93   982 18 24 927                   526 456     338 17     93   982
162552 AZ     school 401680 4282   Cartwright Elementary District 40168000092 5406 Desert Sands Middle School   Regular School No Middle 06 08 2020   pk_12_total 24 27 471   * *         *   267 278     81   *         85   545 24 27 471                   267 278     81       85   545
162555 AZ     school 401680 4282   Cartwright Elementary District 40168001709 6032 G. Frank Davidson   Regular School No Elementary KG 06 2020   pk_12_total 18 32 704   * *         *   401 369     257   *         49   770 18 32 704                   401 369     257       49   770
162556 AZ     school 401680 4282   Cartwright Elementary District 40168000095 5399 Glenn L. Downs School   Regular School No Elementary KG 08 2020   pk_12_total 22 21 687   * *         *   362 378     178   *         59   740 22 21 687                   362 378     178       59   740
162558 AZ     school 401680 4282   Cartwright Elementary District 40168000097 5402 Holiday Park School   Regular School No Elementary KG 06 2020   pk_12_total 38 34 605   * *         *   369 330     195   *         94   699 38 34 605                   369 330     195       94   699
162559 AZ     school 401680 4282   Cartwright Elementary District 40168000098 5400 John F. Long   Regular School No Elementary KG 06 2020   pk_12_total 22 66 704   13 *         *   416 403     232   13         69   819 22 66 704   13               416 403     232 13     69   819
162560 AZ     school 401680 4282   Cartwright Elementary District 40168000100 5401 Justine Spitalny School   Regular School No Elementary KG 06 2020   pk_12_total 21 32 542   * *         *   312 287     141   *         85   599 21 32 542                   312 287     141       85   599
162565 AZ     school 401680 4282   Cartwright Elementary District 40168002904 89955 Raul H. Castro Middle School   Regular School No Middle 06 08 2020   pk_12_total 13 49 493   * *         *   274 293     116   *         46   567 13 49 493                   274 293     116       46   567
162567 AZ     school 401680 4282   Cartwright Elementary District 40168000105 5403 Sunset School   Regular School No Elementary KG 06 2020   pk_12_total 33 45 730   22 *         *   424 409     198   *         92   833 33 45 730   22               424 409     198       92   833
162569 AZ     school 400915 91934   CASA Academy 40091503422 92498 CASA Academy   Regular School Yes Elementary KG 02 2020   pk_12_total * 41 95   * 14         *   85 76     *   *         11   161   41 95     14             85 76             11   161
162575 AZ     school 401710 4446   Casa Grande Elementary District 40171003201 90899 Early Childhood Learning Center   Regular School No Prekindergarten PK PK 2020   pk_12_total 34 * 98   * *         *   92 55     *   *         78   147 34   98                   92 55             78   147
162593 AZ     school   8840   Catholic Charities Westside Head Start   7448 Glendale - Burton Head Start             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162594 AZ     school   8840   Catholic Charities Westside Head Start   7453 Glendale - Discovery Head Start             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162595 AZ     school   8840   Catholic Charities Westside Head Start   7450 Glendale - Imes Head Start             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162596 AZ     school   8840   Catholic Charities Westside Head Start   7451 Glendale - Jack Head Start             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162597 AZ     school   8840   Catholic Charities Westside Head Start   84676 Glendale - Mensendick Head Start             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162598 AZ     school   8840   Catholic Charities Westside Head Start   7447 Glendale - Sine Head Start             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162599 AZ     school   8840   Catholic Charities Westside Head Start   7452 Lamar Head Start             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162600 AZ     school   8840   Catholic Charities Westside Head Start   89240 Lattie Coor I AM             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162601 AZ     school   8840   Catholic Charities Westside Head Start   90473 Michael Anderson             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162602 AZ     school   8840   Catholic Charities Westside Head Start   84675 Ocotillo Head Start             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162603 AZ     school   8840   Catholic Charities Westside Head Start   89731 Palo Verde             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162604 AZ     school   8840   Catholic Charities Westside Head Start   92964 Wildflower Catholic Charities Westside Head Start             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162612 AZ     school 401810 4395   Cedar Unified District 40181000325 5638 Jeddito School   Regular School No Elementary PK 08 2020   pk_12_total * * *   121 *         *   59 64     12   *         24   123         121               59 64     12       24   123
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 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 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 AZ     school   92918   Center for Autism and Related Disorders   539264 CARD Academy Chandler             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
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
162621 AZ     school 400359 79886   Challenger Basic School, Inc. 40035902292 79910 Challenger Basic School   Regular School Yes Elementary KG 06 2020   pk_12_total 232 * 32   * *         *   157 124     *   *         14   281 232   32                   157 124             14   281
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
162642 AZ     school 401870 4242   Chandler Unified District #80 40187000128 5113 Galveston Elementary School   Regular School No Elementary PK 06 2020   pk_12_total 96 23 410   * *         *   277 262     129   *         92   539 96 23 410                   277 262     129       92   539
162666 AZ     school   8929   Chicanos Por La Causa, Inc.   80639 Eloy Center             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162667 AZ     school   8929   Chicanos Por La Causa, Inc.   80640 Willcox Center             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162668 AZ     school   7927   CHILD PARENT CENTERS, INC   84192 Ajo Headstart             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162669 AZ     school   7927   CHILD PARENT CENTERS, INC   85921 Laguna Headstart             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162670 AZ     school   7927   CHILD PARENT CENTERS, INC   7936 LIBERTY HEAD START             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162671 AZ     school   7927   CHILD PARENT CENTERS, INC   7938 LOS NINOS SUNNYSIDE HEAD START             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162672 AZ     school   7927   CHILD PARENT CENTERS, INC   7942 MISSION MANOR HEAD START             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162673 AZ     school   7927   CHILD PARENT CENTERS, INC   10901 SANTA CLARA HEADSTART             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162674 AZ     school   7927   CHILD PARENT CENTERS, INC   80623 Summitt View Head Start             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162675 AZ     school   7927   CHILD PARENT CENTERS, INC   7952 SUNNYSIDE HEAD START             2020   pk_12_total * * *   * *         *   * *     *   *         12   12                                         12   12
162676 AZ     school   7363   CHILDREN'S CENTER FOR NEURODEVELOPMENTAL STUDIES   7364 The Childrens Center for Neurodevelopmental Studies             2020   pk_12_total 21 * 13   * *         *   * *     *   *         43   43 21   13                                   43   43

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