Data source: Big Local News · About: Big Local

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

View and edit SQL

grade

year

  • 2020 · 33,650
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
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
162451 AZ     school 400831 90862   BASIS Charter Schools, Inc. 40083103196 90863 BASIS Flagstaff   Regular School Yes Other KG 12 2020   pk_12_total 574 * 104   26 82         57   403 447     *   *         29   850 574   104   26 82         57   403 447             29   850
162463 AZ     school 400903 92320   BASIS Charter Schools, Inc. 40090303418 92321 BASIS Prescott   Regular School Yes Other KG 12 2020   pk_12_total 543 * 114   * 49         29   400 347     *   *         21   747 543   114     49         29   400 347             21   747
162466 AZ     school 400980 783027   BASIS Charter Schools, Inc. 40098003607 893297 BASIS Scottsdale Primary - West Campus   Regular School Yes Elementary KG 04 2020   pk_12_total 108 * 39   * 268         29   228 224     26   *         12   452 108   39     268         29   228 224     26       12   452
162469 AZ     school 401080 4481   Beaver Creek Elementary District 40108000059 6116 Beaver Creek School   Regular School No Elementary PK 08 2020   pk_12_total 204 * 105   * *         13   175 157     23   *         51   332 204   105               13   175 157     23       51   332
162471 AZ     school 400181 10972   Benchmark School, Inc. 40018101889 78803 Benchmark School   Regular School Yes Elementary KG 06 2020   pk_12_total 363 * 37   * 19         18   221 224     *   *         55   445 363   37     19         18   221 224             55   445
162472 AZ     school 400065 4355   Benjamin Franklin Charter School - Queen Creek 40006501599 5537 Benjamin Franklin Charter School - Crismon   Regular School Yes Elementary KG 06 2020   pk_12_total 578 * 103   * *         16   356 354     *   *         72   710 578   103               16   356 354             72   710
162474 AZ     school 400065 4355   Benjamin Franklin Charter School - Queen Creek 40006502685 88341 Benjamin Franklin Charter School - Power   Regular School Yes Elementary KG 06 2020   pk_12_total 468 * 55   * 14         27   292 283     *   *         57   575 468   55     14         27   292 283             57   575
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
162478 AZ     school 400212 79226   Benson Unified School District 40021200060 4793 Benson Primary School   Regular School No Elementary PK 05 2020   pk_12_total 354 * 175   * *         22   280 289     *   *         131   569 354   175               22   280 289             131   569
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 * * *   * *         *   * *     *   *         *   *                                              
162489 AZ     school 406580 4397   Blue Ridge Unified School District No. 32 40658000560 5645 Blue Ridge Elementary School   Regular School No Elementary PK 06 2020   pk_12_total 471 * 242   139 *         55   475 446     55   *         146   921 471   242   139           55   475 446     55       146   921
162490 AZ     school 406580 4397   Blue Ridge Unified School District No. 32 40658000561 5648 Blue Ridge High School   Regular School No High 09 12 2020   pk_12_total 307 * 172   135 *         27   317 334     20   *         61   651 307   172   135           27   317 334     20       61   651
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
162492 AZ     school 406580 4397   Blue Ridge Unified School District No. 32 40658001140 5647 Blue Ridge Jr High School   Regular School No Middle 07 08 2020   pk_12_total 159 * 73   64 *         17   165 153     15   *         42   318 159   73   64           17   165 153     15       42   318
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
162500 AZ     school   92367   Breakthrough Academy   92914 Breakthrough Academy- East Campus             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162501 AZ     school 400071 4362   Bright Beginnings School, Inc. 40007100832 5550 Bright Beginnings School #1   Regular School Yes Elementary KG 06 2020   pk_12_total 154 * 26   * 62         22   130 136     *   *         14   267 154   26     62         22   130 136             14   267
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
162516 AZ     school 401500 4378   Bullhead City School District 40150001053 5584 Desert Valley School   Regular School No Elementary KG 04 2020   pk_12_total 268 * 248   * *         17   297 246     40   *         68   543 268   248               17   297 246     40       68   543
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
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 * * *   * *         *   * *     *   *         *   *                                              
162529 AZ     school 401600 4470   Camp Verde Unified District 40160000086 6098 Camp Verde Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 372 * 198   64 *         34   349 327     36   15         111   676 372   198   64           34   349 327     36 15     111   676
162530 AZ     school 401600 4470   Camp Verde Unified District 40160000087 6100 Camp Verde High School   Regular School No High 09 12 2020   pk_12_total 291 * 180   37 *         20   278 256     22   *         71   534 291   180   37           20   278 256     22       71   534
162531 AZ     school 401600 4470   Camp Verde Unified District 40160001529 6099 Camp Verde Middle School   Regular School No Middle 06 08 2020   pk_12_total 197 * 136   39 *         14   183 206     21   *         51   389 197   136   39           14   183 206     21       51   389
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
162533 AZ     school 400758 89758   Candeo Schools, Inc. 40075802766 89759 Candeo Peoria   Regular School Yes Elementary KG 08 2020   pk_12_total 443 * 69   * 48         34   296 307     *   *         41   603 443   69     48         34   296 307             41   603
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
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
162578 AZ     school 401710 4446   Casa Grande Elementary District 40171002865 89578 McCartney Ranch Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 200 * 428   33 *         21   344 353     83   *         86   693 200   428   33           21   344 353     83       86   693
162587 AZ     school 401760 4410   Catalina Foothills Unified District 40176001531 5836 Catalina Foothills Valley View Early Learning Center   Regular School No Prekindergarten PK PK 2020   pk_12_total 171 * 37   * 24         34   134 134     *   *         35   268 171   37     24         34   134 134             35   268
162589 AZ     school 401760 4410   Catalina Foothills Unified District 40176001032 5833 Manzanita School   Regular School No Elementary KG 05 2020   pk_12_total 405 * 151   * 26         34   337 287     11   *         58   624 405   151     26         34   337 287     11       58   624
162590 AZ     school 401760 4410   Catalina Foothills Unified District 40176000116 5834 Orange Grove Middle School   Regular School No Middle 06 08 2020   pk_12_total 396 * 165   * 48         43   355 312     11   *         77   667 396   165     48         43   355 312     11       77   667
162591 AZ     school 401760 4410   Catalina Foothills Unified District 40176000117 5832 Sunrise Drive Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 322 * 94   * 58         63   263 284     21   *         37   547 322   94     58         63   263 284     21       37   547
162592 AZ     school 401760 4410   Catalina Foothills Unified District 40176001002 5838 Ventana Vista Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 301 * 180   * 22         34   268 278     14   *         49   546 301   180     22         34   268 278     14       49   546
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 * * *   * *         *   * *     *   *         *   *                                              
162605 AZ     school 400001 4244   Cave Creek Unified District 40000100120 5134 Black Mountain Elementary School   Regular School No Elementary KG 06 2020   pk_12_total 454 * 53   * *         18   269 271     *   *         125   540 454   53               18   269 271             125   540
162607 AZ     school 400001 4244   Cave Creek Unified District 40000100616 5136 Desert Sun Academy   Regular School No Elementary PK 06 2020   pk_12_total 309 * 53   * *         17   208 185     13   *         123   393 309   53               17   208 185     13       123   393
162608 AZ     school 400001 4244   Cave Creek Unified District 40000101872 78912 Desert Willow Elementary School   Regular School No Elementary KG 06 2020   pk_12_total 481 * 76   * *         17   302 287     *   *         60   589 481   76               17   302 287             60   589
162609 AZ     school 400001 4244   Cave Creek Unified District 40000102484 87477 Horseshoe Trails Elementary School   Regular School No Elementary KG 06 2020   pk_12_total 505 * 42   * 20         39   334 280     *   *         75   614 505   42     20         39   334 280             75   614
162610 AZ     school 400001 4244   Cave Creek Unified District 40000102344 80056 Lone Mountain Elementary School   Regular School No Elementary KG 06 2020   pk_12_total 431 * 49   * 13         20   283 238     *   *         77   521 431   49     13         20   283 238             77   521
162611 AZ     school 400001 4244   Cave Creek Unified District 40000101871 78911 Sonoran Trails Middle School   Regular School No Middle 06 08 2020   pk_12_total 753 * 110   * 22         26   463 461     12   *         126   924 753   110     22         26   463 461     12       126   924
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
162615 AZ     school 400016 4191   Center for Academic Success, Inc. 40001600476 4801 Center for Academic Success, The #1   Alternative School Yes High 09 12 2020   pk_12_total 74 * 50   * *         11   75 70     *   *         23   145 74   50               11   75 70             23   145
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
162626 AZ     school 401870 4242   Chandler Unified District #80 40187002587 85838 Audrey & Robert Ryan Elementary   Regular School No Elementary PK 06 2020   pk_12_total 533 * 78   * 68         48   408 331     *   *         86   739 533   78     68         48   408 331             86   739
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
162651 AZ     school 401870 4242   Chandler Unified District #80 40187000131 5115 Knox Gifted Academy   Regular School No Elementary PK 06 2020   pk_12_total 293 * 46   * 301         44   385 307     *   *         15   692 293   46     301         44   385 307             15   692
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 * * *   * *         *   * *     *   *         *   *                                              

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