Data source: Big Local News · About: Big Local

127,680 rows where state = "AZ" sorted by hispanic_int

View and edit SQL

grade

year

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
564413 AZ     school 406120 4369   Peach Springs Unified District 40612000502 5566 Peach Springs School   Regular School No Elementary PK 08 2018   pk_12_total * * *   175 *     *   *   94 85     *             18   179         175               94 85             18   179
564458 AZ     school 406250 4237   Peoria Unified School District 40625002396 81207 Peoria eCampus   Regular School No Other KG 12 2018   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
564506 AZ     school 400420 87334   Pillar Charter School 40042002522 87335 Pillar Academy of Business & Finance   Regular School Yes High 09 12 2018   pk_12_total * * *   * *     *   *   * *     *             *   11                                             11
564515 AZ     school 406440 4220   Pima Unified District 40644003362 92296 Gila Valley Learning Center   Regular School No High 09 12 2018   pk_12_total 12 * *   * *     *   *   15 *     *             *   17 12                       15                   17
564527 AZ     school 400023 4390   Pinon Unified District 40002301355 5612 Pinon Accelerated Middle School   Regular School No Middle 06 08 2018   pk_12_total * * *   278 *     *   *   152 131     18             33   283         278               152 131     18       33   283
564528 AZ     school 400023 4390   Pinon Unified District 40002301352 5611 Pinon Elementary School   Regular School No Elementary PK 05 2018   pk_12_total * * *   505 *     *   *   264 250     66             56   514         505               264 250     66       56   514
564529 AZ     school 400023 4390   Pinon Unified District 40002301524 5613 Pinon High School   Regular School No High 09 12 2018   pk_12_total * * *   289 *     *   *   157 140     15             33   297         289               157 140     15       33   297
564562 AZ     school 406810 4245   Queen Creek Unified District 40681003438 92628 Queen Creek Virtual Academy   Regular School No High 06 12 2018   pk_12_total * * *   * *     *   *   * 11     *             *   13                           11                 13
564566 AZ     school 406870 4159   Red Mesa Unified District 40687000141 4738 Red Mesa Elementary School   Regular School No Elementary PK 08 2018   pk_12_total * * *   123 *     *   *   66 59     *             17   125         123               66 59             17   125
564567 AZ     school 406870 4159   Red Mesa Unified District 40687000142 4741 Red Mesa High School   Regular School No High 09 12 2018   pk_12_total * * *   152 *     *   *   77 76     *             23   153         152               77 76             23   153
564568 AZ     school 406870 4159   Red Mesa Unified District 40687000206 4740 Red Mesa Junior High School   Regular School No Middle 06 08 2018   pk_12_total * * *   98 *     *   *   46 53     *             14   99         98               46 53             14   99
564569 AZ     school 406870 4159   Red Mesa Unified District 40687002867 88386 Red Valley/Cove High School   Regular School No High 09 12 2018   pk_12_total * * *   39 *     *   *   22 17     *             13   39         39               22 17             13   39
564570 AZ     school 406870 4159   Red Mesa Unified District 40687000143 4739 Round Rock Elementary School   Regular School No Elementary PK 08 2018   pk_12_total * * *   67 *     *   *   41 26     *             12   67         67               41 26             12   67
564602 AZ     school 407130 4155   Round Valley Unified District 40713003442 92686 White Mountain Academy   Regular School No High 09 12 2018   pk_12_total 18 * *   * *     *   *   * 13     *             *   23 18                         13                 23
564627 AZ     school 400047 4320   Salt River Pima-Maricopa Community Schools 40004703031 90159 Salt River Accelerated Learning Academy   Regular School Yes High 09 12 2018   pk_12_total * * *   58 *     *   *   30 36     *             13   66         58               30 36             13   66
564629 AZ     school 406960 4210   San Carlos Unified District 40696001656 5989 Rice Elementary School   Regular School No Elementary PK 06 2018   pk_12_total * * *   922 *     *   *   475 464     32             165   939         922               475 464     32       165   939
564630 AZ     school 406960 4210   San Carlos Unified District 40696000526 4863 San Carlos Secondary   Regular School No High 07 12 2018   pk_12_total * * *   517 *     *   *   270 255     20             61   525         517               270 255     20       61   525
564631 AZ     school 406960 4210   San Carlos Unified District 40696002788 89776 San Carlos Unified School District #20 Alternative Center   Regular School No Other KG 12 2018   pk_12_total * * *   49 *     *   *   20 29     *             *   49         49               20 29                 49
564635 AZ     school 406740 4156   Sanders Unified District 40674000572 4722 Sanders Elementary School   Regular School No Elementary PK 07 2018   pk_12_total * * *   286 *     *   *   148 166     28             35   314         286               148 166     28       35   314
564636 AZ     school 406740 4156   Sanders Unified District 40674001043 4723 Sanders Middle School   Regular School No Middle 06 08 2018   pk_12_total * * *   180 *     *   *   96 95     29             31   191         180               96 95     29       31   191
564637 AZ     school 406740 4156   Sanders Unified District 40674001142 4724 Valley High School   Regular School No High 09 12 2018   pk_12_total * * *   204 *     *   *   110 99     24             19   209         204               110 99     24       19   209
564645 AZ     school 407530 4454   Santa Cruz Valley Union High School District 40753002966 90415 Santa Cruz Center for Success   Regular School No High 09 12 2018   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
564675 AZ     school 407570 4240   Scottsdale Unified District 40757003250 91286 Scottsdale Online Learning   Regular School No Other KG 12 2018   pk_12_total 31 * *   * *     *   *   16 24     *             *   40 31                       16 24                 40
564682 AZ     school 409733 4467   Sedona-Oak Creek JUSD #9 40973303188 90826 Red Rock Academy   Regular School No High 09 12 2018   pk_12_total 17 * *   * *     *   *   11 17     *             *   28 17                       11 17                 28
564688 AZ     school 407630 4472   Seligman Unified District 40763000668 6105 Seligman High School   Regular School No High 09 12 2018   pk_12_total 27 * *   12 *     *   *   27 24     *             *   51 27       12               27 24                 51
564690 AZ     school 400154 6353   Shonto Governing Board of Education, Inc. 40015401770 5653 Shonto Preparatory Technology High School   Regular School Yes High 09 12 2018   pk_12_total * * *   70 *     *   *   34 39     *             *   73         70               34 39                 73
564691 AZ     school 407700 4393   Show Low Unified District 40770001253 5628 Linden Elementary School   Regular School No Elementary KG 05 2018   pk_12_total 158 * *   * *     *   *   87 88     *             17   177 158                       87 88             17   177
564695 AZ     school 407700 4393   Show Low Unified District 40770003276 91203 WMI ON LINE   Regular School No High 09 12 2018   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
564697 AZ     school 407700 4393   Show Low Unified District 40770001941 79646 White Mountain Institute   Regular School No High 09 12 2018   pk_12_total 11 * *   * *     *   *   12 *     *             *   18 11                       12                   18
564704 AZ     school 401460 4175   Sierra Vista Unified District 40146003524 440989 Sierra Vista Online   Regular School No High 09 12 2018   pk_12_total * * *   * *     *   *   * *     *             *   12                                             12
564707 AZ     school 407770 4478   Skull Valley Elementary District 40777000390 6113 Skull Valley Elementary School   Regular School No Elementary KG 08 2018   pk_12_total 19 * *   * *     *   *   * 12     *             *   22 19                         12                 22
564708 AZ     school 400801 90329   Skyline Gila River Schools, LLC 40080102941 89941 Skyline D5   Regular School Yes High 05 12 2018   pk_12_total * * *   150 *     *   *   76 79     *             24   155         150               76 79             24   155
564724 AZ     school 400192 78868   Sonoran Desert School 40019201910 78869 Sonoran Desert School   Regular School Yes High 05 12 2018   pk_12_total 25 * *   * *     *   *   15 14     *             *   29 25                       15 14                 29
564727 AZ     school 400254 79000   Southern Arizona Community Academy, Inc. 40025403420 92518 SACA Online   Regular School Yes High 09 12 2018   pk_12_total * * *   * *     *   *   * *     *             *   17                                             17
564732 AZ     school 408020 4173   St David Unified District 40802000701 4762 St David High School   Regular School No High 09 12 2018   pk_12_total 90 * *   * *     *   *   46 58     *             19   104 90                       46 58             19   104
564736 AZ     school 408080 4153   St Johns Unified District 40808002871 89607 St. Johns Learning Center   Regular School No High 09 12 2018   pk_12_total * * *   * *     *   *   * *     *             *   13                                             13
564813 AZ     school 400902 91340   The Farm at Mission Montessori Academy 40090203413 92247 The Farm at Mission Montessori Academy   Regular School Yes Middle 04 08 2018   pk_12_total 25 * *   * *     *   *   17 13     *             *   30 25                       17 13                 30
564820 AZ     school 400214 79131   The Shelby School 40021401980 79132 The Shelby School   Regular School Yes Other KG 10 2018   pk_12_total 23 * *   * *     *   *   16 11     *             *   27 23                       16 11                 27
564829 AZ     school 408520 4288   Tolleson Union High School District 40852003206 90551 University High School   Regular School No High 09 12 2018   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
564836 AZ     school 405760 4215   Tonto Basin Elementary District 40576000467 4877 Tonto Basin Elementary   Regular School No Elementary PK 08 2018   pk_12_total 62 * *   * *     *   *   34 35     *             *   69 62                       34 35                 69
564840 AZ     school 408680 4197   Tuba City Unified School District #15 40868001152 4834 Dzil Libei Elementary School   Regular School No Elementary KG 06 2018   pk_12_total * * *   69 *     *   *   37 32     *             *   69         69               37 32                 69
564841 AZ     school 408680 4197   Tuba City Unified School District #15 40868001153 4835 Gap Primary School   Regular School No Elementary PK 04 2018   pk_12_total * * *   56 *     *   *   32 24     *             *   56         56               32 24                 56
564842 AZ     school 408680 4197   Tuba City Unified School District #15 40868001822 78916 Tuba City Alternative School   Alternative School No High 07 12 2018   pk_12_total * * *   26 *     *   *   11 15     *             *   26         26               11 15                 26
564843 AZ     school 408680 4197   Tuba City Unified School District #15 40868000812 4838 Tuba City High School   Regular School No High 09 12 2018   pk_12_total * * *   670 *     *   *   361 327     26             100   688         670               361 327     26       100   688
564844 AZ     school 408680 4197   Tuba City Unified School District #15 40868000814 4837 Tuba City Junior High School   Regular School No Middle 06 08 2018   pk_12_total * * *   317 *     *   *   179 156     30             45   335         317               179 156     30       45   335
564845 AZ     school 408680 4197   Tuba City Unified School District #15 40868000815 4833 Tuba City Primary School   Regular School No Elementary PK 05 2018   pk_12_total * * *   498 *     *   *   279 239     30             88   518         498               279 239     30       88   518
565016 AZ     school 409160 4394   Whiteriver Unified District 40916000005 5637 Alchesay High School   Regular School No High 09 12 2018   pk_12_total * * *   507 *     *   *   277 241     11             84   518         507               277 241     11       84   518
565017 AZ     school 409160 4394   Whiteriver Unified District 40916000952 5635 Canyon Day Junior High School   Regular School No Middle 06 08 2018   pk_12_total * * *   392 *     *   *   224 178     12             66   402         392               224 178     12       66   402
565018 AZ     school 409160 4394   Whiteriver Unified District 40916001768 5636 Cradleboard School   Regular School No Elementary PK 05 2018   pk_12_total * * *   278 *     *   *   141 143     *             25   284         278               141 143             25   284
565019 AZ     school 409160 4394   Whiteriver Unified District 40916002190 79698 Seven Mile School   Regular School No Elementary PK 05 2018   pk_12_total * * *   513 *     *   *   247 269     24             57   516         513               247 269     24       57   516
565020 AZ     school 409160 4394   Whiteriver Unified District 40916000951 5633 Whiteriver Elementary   Regular School No Elementary PK 05 2018   pk_12_total * * *   481 *     *   *   249 238     18             68   487         481               249 238     18       68   487
565033 AZ     school 409430 4154   Window Rock Unified District 40943002447 85882 Tsehootsooi Dine Bi'Olta   Regular School No Elementary KG 06 2018   pk_12_total * * *   144 *     *   *   80 64     44             *   144         144               80 64     44           144
565034 AZ     school 409430 4154   Window Rock Unified District 40943000967 4714 Tsehootsooi Intermediate Learning Center   Regular School No Middle 04 06 2018   pk_12_total * * *   395 *     *   *   216 183     28             41   399         395               216 183     28       41   399
565035 AZ     school 409430 4154   Window Rock Unified District 40943000968 4716 Tsehootsooi Middle School   Regular School No Middle 07 08 2018   pk_12_total * * *   345 *     *   *   191 161     20             48   352         345               191 161     20       48   352
565036 AZ     school 409430 4154   Window Rock Unified District 40943001648 4715 Tsehootsooi Primary Learning Center   Regular School No Elementary KG 03 2018   pk_12_total * * *   422 *     *   *   242 186     38             42   428         422               242 186     38       42   428
565037 AZ     school 409430 4154   Window Rock Unified District 40943000970 4717 Window Rock High School   Regular School No High 09 12 2018   pk_12_total * * *   573 *     *   *   297 287     14             81   584         573               297 287     14       81   584
565043 AZ     school 409510 4485   Yarnell Elementary District 40951000977 6121 Yarnell Elementary School   Regular School No Elementary PK 08 2018   pk_12_total 36 * *   * *     *   *   20 26     *             14   46 36                       20 26             14   46
565045 AZ     school 400315 79379   Yavapai Accommodation School District 40031502217 79380 Yavapai County High School   Regular School No High 09 12 2018   pk_12_total 18 * *   * *     *   *   * 11     *             *   20 18                         11                 20
565046 AZ     school 409540 4213   Young Elementary District 40954000978 4874 Young Elementary School   Regular School No Elementary PK 08 2018   pk_12_total 21 * *   * *     *   *   14 14     *             *   28 21                       14 14                 28
565047 AZ     school 409540 4213   Young Elementary District 40954001119 4875 Young High School   Regular School No High 09 12 2018   pk_12_total 12 * *   * *     *   *   * *     *             *   13 12                                           13
565049 AZ     school 409570 4377   Yucca Elementary District 40957000323 5582 Yucca Elementary School   Regular School No Elementary PK 08 2018   pk_12_total 19 * *   * *     *   *   16 14     *             *   30 19                       16 14                 30
565067 AZ     school 409600 4499   Yuma Elementary District 40960003430 92641 Yuma District One Digital Learning Academy   Regular School No Elementary KG 08 2018   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
565075 AZ     school 409630 4507   Yuma Union High School District 40963003280 91316 Yuma Online Distance Academy   Regular School No High 09 12 2018   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
592694 AZ     school 400970 449790   AIBT Non-Profit Charter High School, Inc. 40097003546 742847 RCB College Preparatory Academy   Regular School Yes High 09 12 2019   pk_12_total * * *   * *     *   *   * *     *             *   14                                             14
592697 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 2019   pk_12_total * * *   15 *     *   *   * *     *             *   16         15                                   16
592698 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 2019   pk_12_total * * *   * *     *   *   * *     *                 12                                             12
592715 AZ     school 400630 4161   Alpine Elementary District 40063000019 4743 Alpine Elementary School   Regular School No Elementary KG 08 2019   pk_12_total 42 * *   * *     *   *   25 29     *             12   54 42                       25 29             12   54
592764 AZ     school 400720 4506   Antelope Union High School District 40072003466 92739 AUHS Online Acadamy   Regular School No High 09 12 2019   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
592766 AZ     school 400750 4178   Apache Elementary District 40075000039 4786 Apache Elementary School   Regular School No Elementary KG 08 2019   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
592804 AZ     school 400870 4187   Ash Creek Elementary District 40087000046 4797 Ash Creek Elementary   Regular School No Elementary PK 08 2019   pk_12_total 14 * *   * *     *   *   * *     *             *   16 14                                           16
592833 AZ     school 403950 4412   Baboquivari Unified School District #40 40395000311 5846 Baboquivari Middle School   Regular School No Middle 07 08 2019   pk_12_total * * *   154 *     *   *   78 81     *             37   159         154               78 81             37   159
592834 AZ     school 403950 4412   Baboquivari Unified School District #40 40395000310 5847 Baboquivari High School   Regular School No High 09 12 2019   pk_12_total * * *   190 *     *   *   104 94     *             40   198         190               104 94             40   198
592835 AZ     school 403950 4412   Baboquivari Unified School District #40 40395003210 90821 Alternative Middle School (Indian Oasis Middle School)   Regular School No Middle 06 08 2019   pk_12_total * * *   14 *     *   *   11 *     *             *   16         14               11                   16
592836 AZ     school 403950 4412   Baboquivari Unified School District #40 40395003222 90822 Alternative High School (Indian Oasis High School)   Regular School No High 09 12 2019   pk_12_total * * *   37 *     *   *   19 18     *             *   37         37               19 18                 37
592879 AZ     school 400212 79226   Benson Unified School District 40021202444 85879 San Pedro Valley High School   Regular School No High 09 12 2019   pk_12_total 22 * *   * *     *   *   20 11     *             *   31 22                       20 11                 31
592880 AZ     school 400212 79226   Benson Unified School District 40021203232 90775 San Pedro Valley Online Academy   Regular School No High 05 12 2019   pk_12_total * * *   * *     *   *   * *     *             *   11                                             11
592886 AZ     school 401230 4231   Blue Elementary District 40123000069 4908 Blue Elementary School   Regular School No Other KG 12 2019   pk_12_total * * *   * *     *   *   * *     *                 *                                              
592890 AZ     school 406580 4397   Blue Ridge Unified School District No. 32 40658003564 456092 Blue Ridge High School Online   Regular School No High 09 12 2019   pk_12_total * * *   * *     *   *   * *     *                 *                                              
592896 AZ     school 401330 4171   Bowie Unified District 40133000073 4759 Bowie High School   Regular School No High 09 12 2019   pk_12_total * * *   * *     *   *   11 *     *             *   18                         11                   18
592932 AZ     school 400077 4400   Career Development, Inc. 40007700943 5652 Northern AZ Academy for Career Dev. - Taylor   Regular School Yes High 09 12 2019   pk_12_total 34 * *   * *     *   *   21 24     *             18   45 34                       21 24             18   45
592938 AZ     school 400381 80001   Carpe Diem Collegiate High School 40038102866 89656 Desert View Online School   Regular School Yes High 07 12 2019   pk_12_total * * *   * *     *   *   * *     *                 *                                              
592988 AZ     school 401810 4395   Cedar Unified District 40181000325 5638 Jeddito School   Regular School No Elementary PK 08 2019   pk_12_total * * *   142 *     *   *   71 71     25             33   142         142               71 71     25       33   142
593040 AZ     school 401940 4158   Chinle Unified District 40194000138 4731 Chinle Junior High School   Regular School No Middle 07 08 2019   pk_12_total * * *   361 *     *   *   186 175     14             47   361         361               186 175     14       47   361
593041 AZ     school 401940 4158   Chinle Unified District 40194000135 4732 Chinle Elementary School   Regular School No Elementary PK 06 2019   pk_12_total * * *   474 *     *   *   262 216     19             65   478         474               262 216     19       65   478
593042 AZ     school 401940 4158   Chinle Unified District 40194000136 4733 Canyon De Chelly Elementary School   Regular School No Elementary PK 06 2019   pk_12_total * * *   320 *     *   *   166 157     25             31   323         320               166 157     25       31   323
593043 AZ     school 401940 4158   Chinle Unified District 40194000140 4734 Many Farms Elementary School   Regular School No Elementary KG 08 2019   pk_12_total * * *   463 *     *   *   250 217     85             40   467         463               250 217     85       40   467
593044 AZ     school 401940 4158   Chinle Unified District 40194000145 4735 Tsaile Elementary School   Regular School No Elementary KG 08 2019   pk_12_total * * *   455 *     *   *   229 228     26             44   457         455               229 228     26       44   457
593045 AZ     school 401940 4158   Chinle Unified District 40194001488 4736 Mesa View Elementary   Regular School No Elementary PK 06 2019   pk_12_total * * *   383 *     *   *   201 188     23             47   389         383               201 188     23       47   389
593046 AZ     school 401940 4158   Chinle Unified District 40194000137 4737 Chinle High School   Regular School No High 09 12 2019   pk_12_total * * *   1000 *     *   *   498 511     38             162   1009         1000               498 511     38       162   1009
593059 AZ     school   1000098   City School District of Albany   1000099 William S. Hackett Middle School             2019   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
593063 AZ     school 400163 10386   Coconino County Accommodation School District 40016301820 78915 Juvenile Detention   Regular School No Other 04 12 2019   pk_12_total * * *   * *     *   *   11 *     *             *   16                         11                   16
593064 AZ     school 400163 10386   Coconino County Accommodation School District 40016301821 79010 Jail - Coconino County Accommodation School District   Regular School No High 07 12 2019   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
593065 AZ     school 400163 10386   Coconino County Accommodation School District 40016303138 81127 Tse'yaato' High School   Regular School No High 09 12 2019   pk_12_total * * *   53 *     *   *   29 29     *             *   58         53               29 29                 58
593068 AZ     school 400021 4370   Colorado City Unified District 40002101276 5567 El Capitan Public School   Regular School No High 06 12 2019   pk_12_total 241 * *   * *     *   *   132 119     *             54   251 241                       132 119             54   251
593069 AZ     school 400021 4370   Colorado City Unified District 40002103446 92635 Cottonwood Elementary   Regular School No Elementary PK 05 2019   pk_12_total 346 * *   * *     *   *   178 176     *             124   354 346                       178 176             124   354
593102 AZ     school 402400 4501   Crane Elementary District 40240003521 778305 Crane iLearning Academy   Regular School No Elementary PK 08 2019   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
593114 AZ     school 402460 4483   Crown King Elementary District 40246000182 6118 Crown King Elementary School   Regular School No Elementary KG 08 2019   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
593121 AZ     school 400278 79496   Deer Valley Charter Schools, Inc. 40027802168 79506 Deer Valley Academy   Regular School Yes High 09 12 2019   pk_12_total * * *   * *     *   *   * *     *             *   18                                             18
593170 AZ     school 402490 4179   Double Adobe Elementary District 40249000183 4787 Double Adobe Elementary School   Regular School No Elementary PK 08 2019   pk_12_total 32 * *   * *     *   *   22 15     *             *   37 32                       22 15                 37
593210 AZ     school 400189 10971   East Valley Academy 40018901907 78806 East Valley Academy   Regular School Yes Elementary KG 06 2019   pk_12_total * * *   * *     *   *   * *     *                 13                                             13

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