enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
162707 162707 AZ     school   1000098   City School District of Albany   1000099 William S. Hackett Middle School             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162709 162709 AZ     school 400316 79391   Cobre Valley Institute of Technology District 40031602979 90402 Cobre Valley Central Programs   Career and Technical School No High 09 12 2020   pk_12_total * * *   * *         *   * *     *   *         *   5                                             5
162712 162712 AZ     school 400345 79403   Cochise Technology District 40034502577 79404 CTD - Cochise Technology School   Career and Technical School No High 09 12 2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162713 162713 AZ     school 400347 79381   Coconino Association for Vocation Industry and Technology 40034702944 89913 CAVIAT - CCC Central Campus   Career and Technical School No High 09 12 2020   pk_12_total * * *   * *         *   * *     *   *         *   6                                             6
162714 162714 AZ     school 400347 79381   Coconino Association for Vocation Industry and Technology 40034703425 92660 CAVIAT - Flagstaff Central Campus   Career and Technical School No High 09 12 2020   pk_12_total * * *   * *         *   * *     *   *         *   1                                             1
162715 162715 AZ     school   10386   Coconino County Accommodation School District   79010 Jail - Coconino County Accommodation School District             2020   pk_12_total * * *   * *         *   * *     *   *         *   1                                             1
162716 162716 AZ     school   10386   Coconino County Accommodation School District   78915 Juvenile Detention - Coconino County Accommodation School District             2020   pk_12_total * * *   * *         *   * *     *   *         *   7                                             7
162717 162717 AZ     school 400163 10386   Coconino County Accommodation School District 40016302429 85842 Ponderosa High School   Alternative School No High 09 12 2020   pk_12_total * * 21   23 *         *   34 19     *   *         *   53     21   23               34 19                 53
162718 162718 AZ     school 400163 10386   Coconino County Accommodation School District 40016303138 81127 Tse'yaato' High School   Alternative School No High 09 12 2020   pk_12_total * * *   36 *         *   21 22     *   *         *   43         36               21 22                 43
162744 162744 AZ     school 400814 90331   CPLC Community Schools dba Hiaki High School 40081402554 87412 Envision High School   Alternative School Yes High 09 12 2020   pk_12_total * * 41   * *         *   28 17     *   *         *   45     41                   28 17                 45
162747 162747 AZ     school 402400 4501   Crane Elementary District 40240003521 778305 Crane iLearning Academy   Regular School No Elementary PK 08 2020   pk_12_total * * *   * *         *   * *     *   *         *   13                                             13
162751 162751 AZ     school 402400 4501   Crane Elementary District 40240002882 87486 Great Beginnings Pre-School   Regular School No Prekindergarten PK PK 2020   pk_12_total * * 99   * *         *   59 49     *   *         *   108     99                   59 49                 108
162770 162770 AZ     school 402460 4483   Crown King Elementary District 40246000182 6118 Crown King Elementary School   Regular School No Elementary KG 08 2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162771 162771 AZ     school   60691   Cupertino Power Learning Center, Inc.   733509 Cupertino Power Learning Center             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162778 162778 AZ     school 400278 79496   Deer Valley Charter Schools, Inc. 40027802168 79506 Deer Valley Academy   Regular School Yes High 09 12 2020   pk_12_total 12 * *   * *         *   * *     *   *         *   18 12                                           18
162789 162789 AZ     school 407750 4246   Deer Valley Unified District 40775002591 79414 Deer Valley Online Learning Program   Regular School No High 07 12 2020   pk_12_total 43 * *   * *         *   27 29     *   *         *   56 43                       27 29                 56
162818 162818 AZ     school   88618   Desert Choice Schools LLC   1000142 Desert Choice - Yuma Union High School             2020   pk_12_total * * *   * *         *   * *     *   *         *   6                                             6
162820 162820 AZ     school   88618   Desert Choice Schools LLC   147909 Desert Choice School Casa Grande Elementary - CG Middle             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162821 162821 AZ     school   88618   Desert Choice Schools LLC   1000049 Desert Choice School Casa Grande Elementary - Palo Verde             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162826 162826 AZ     school   88618   Desert Choice Schools LLC   812691 Desert Choice School Union Elementary-Dos Rios             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162829 162829 AZ     school   88618   Desert Choice Schools LLC   88619 Desert Choices Tolleson - Sheely Farms             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
162833 162833 AZ     school 400448 88308   Desert Sky Community School, Inc. 40044802638 88309 Desert Sky Community School   Regular School Yes Elementary KG 05 2020   pk_12_total 35 * 17   * *         *   26 29     *   *         *   55 35   17                   26 29                 55
162838 162838 AZ     school   7295   Devereux Arizona   7296 Devereux             2020   pk_12_total * * *   * *         *   * *     *   *         *   15                                             15
162840 162840 AZ     school 402490 4179   Double Adobe Elementary District 40249000183 4787 Double Adobe Elementary School   Regular School No Elementary PK 08 2020   pk_12_total 31 * *   * *         *   19 16     *   *         *   35 31                       19 16                 35
162859 162859 AZ     school 402690 4243   Dysart Unified District 40269003193 90875 Dysart iSchool   Regular School No High 07 12 2020   pk_12_total 13 * *   * *         *   11 16     *   *         *   27 13                       11 16                 27
162882 162882 AZ     school 409731 4516   East Valley Institute of Technology 40973103224 90912 EVIT - East Campus   Career and Technical School No High 10 12 2020   pk_12_total 169 * 54   * *         *   52 186     *   *         *   238 169   54                   52 186                 238
162883 162883 AZ     school 409731 4516   East Valley Institute of Technology 40973101514 7282 EVIT - East Valley Institute of Technology   Career and Technical School No High 09 12 2020   pk_12_total 241 16 151   * *         16   208 233     *   *         *   441 241 16 151               16   208 233                 441
162884 162884 AZ     school 409731 4516   East Valley Institute of Technology 40973103549 25790 EVIT East Apache Junction   Career and Technical School No High 10 12 2020   pk_12_total * * *   * *         *   * *     *   *         *   12                                             12
162885 162885 AZ     school 409731 4516   East Valley Institute of Technology 40973103544 165668 EVIT North Fountain Hills   Career and Technical School No High 09 12 2020   pk_12_total * * *   * *         *   * *     *   *         *   5                                             5
162887 162887 AZ     school 400817 90506   Ed Ahead 40081703191 90507 Academy Adventures Midtown   Regular School Yes Elementary KG 05 2020   pk_12_total * 13 22   * *         *   24 20     *   *         *   44   13 22                   24 20                 44
162901 162901 AZ     school 400157 4329   Edkey, Inc. - Sequoia Choice Schools 40015703046 90322 Edkey, Inc. - Precision Learning Center   Regular School Yes High 09 12 2020   pk_12_total * * 22   * *         *   * *     *   *         *   27     22                                       27
162912 162912 AZ     school 400816 90201   Educational Options Foundation 40081602998 90202 EdOptions Preparatory Academy   Alternative School Yes High 07 12 2020   pk_12_total * * 99   * *         *   62 37     *   *         *   99     99                   62 37                 99
162913 162913 AZ     school 400055 4341   EduPreneurship, Inc. 40005501731 10752 EduPreneurship Student Center (ESC) Phoenix   Regular School Yes Elementary KG 08 2020   pk_12_total 12 11 20   * *         *   26 20     *   *         *   46 12 11 20                   26 20                 46
162916 162916 AZ     school 400311 79059   E-Institute Charter Schools, Inc. 40031103292 91199 E-Institute at Avondale   Alternative School Yes High 09 12 2020   pk_12_total 16 * 49   * *         *   32 41     *   *         *   73 16   49                   32 41                 73
162917 162917 AZ     school 400311 79059   E-Institute Charter Schools, Inc. 40031103186 90768 E-Institute at Buckeye   Alternative School Yes High 09 12 2020   pk_12_total * * 45   * *         *   29 27     *   *         *   56     45                   29 27                 56
162918 162918 AZ     school 400311 79059   E-Institute Charter Schools, Inc. 40031103001 90389 E-Institute at Grovers   Alternative School Yes High 09 12 2020   pk_12_total * * 17   * *         *   * *     *   *         *   21     17                                       21
162919 162919 AZ     school 400311 79059   E-Institute Charter Schools, Inc. 40031102919 90075 E-Institute at Metro   Alternative School Yes High 09 12 2020   pk_12_total * * 31   * *         *   30 17     *   *         *   47     31                   30 17                 47
162922 162922 AZ     school 400311 79059   E-Institute Charter Schools, Inc. 40031102151 79117 E-Institute at Union Hills   Alternative School Yes High 09 12 2020   pk_12_total 15 * 53   * *         *   45 34     *   *         *   79 15   53                   45 34                 79
162932 162932 AZ     school 400939 92902   Espiritu Schools 40093903495 92903 AIM Higher College Prep Academy   Regular School Yes High 07 12 2020   pk_12_total * * 50   * *         *   27 31     16   *         *   58     50                   27 31     16           58
162933 162933 AZ     school 400955 92988   Estrella Educational Foundation 40095503519 181823 Maricopa Institute of Technology   Regular School Yes Secondary 09 11 2020   pk_12_total 19 14 156   * *         *   124 74     *   *         *   198 19 14 156                   124 74                 198
162951 162951 AZ     school 402860 4192   Flagstaff Unified District 40286003506 230656 Northern Arizona Distance Learning   Regular School No High 07 12 2020   pk_12_total 15 * *   * *         *   16 13     *   *         *   29 15                       16 13                 29
162964 162964 AZ     school 402920 4437   Florence Unified School District 40292003195 90781 Florence Virtual Academy   Regular School No Other KG 12 2020   pk_12_total 17 * 11   * *         *   12 16     *   *         *   28 17   11                   12 16                 28
162974 162974 AZ     school 403010 4405   Flowing Wells Unified District 40301003331 91832 Flowing Wells Digital Campus   Regular School No High 07 12 2020   pk_12_total * * 44   * *         *   29 27     *   *         *   56     44                   29 27                 56
162983 162983 AZ     school 400036 4309   Foothills Academy 40003600709 5474 Foothills Academy   Regular School Yes Elementary KG 08 2020   pk_12_total 88 * *   * *         *   49 56     *   *         *   105 88                       49 56                 105
162984 162984 AZ     school 400036 4309   Foothills Academy 40003603421 92407 Foothills Academy Connected   Regular School Yes High 07 12 2020   pk_12_total * * *   * *         *   * *     *   *         *   1                                             1
162990 162990 AZ     school 403200 4221   Fort Thomas Unified District 40320002946 90064 Mt. Turnbull Academy   Alternative School No Other PK 12 2020   pk_12_total * * *   28 *         *   13 15     *   *         *   28         28               13 15                 28
162993 162993 AZ     school 400113 4356   Fountain Hills Charter School 40011301601 5539 Fountain Hills Charter School   Regular School Yes Elementary KG 08 2020   pk_12_total 31 * *   * *         *   32 23     *   *         *   55 31                       32 23                 55
162996 162996 AZ     school 403040 4247   Fountain Hills Unified District 40304003240 90932 Fountain.Hills Online   Regular School No High 09 12 2020   pk_12_total * * *   * *         *   * *     *   *         *   3                                             3
163027 163027 AZ     school   87275   Gateway Academy   87276 Gateway Academy             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
163028 163028 AZ     school 400145 6372   Gem Charter School, Inc. 40014501750 6045 Gem Charter School   Regular School Yes Elementary KG 06 2020   pk_12_total 15 * *   * *         *   14 19     *   *         *   33 15                       14 19                 33
163029 163029 AZ     school 400124 4332   Genesis Program, Inc. 40012401589 5504 Genesis Academy   Alternative School Yes High 09 12 2020   pk_12_total * * 63   * *         *   42 38     *   *         *   80     63                   42 38                 80
163033 163033 AZ     school 400419 87600   Gila County Regional School District 40041902897 90038 Biyaagozhoo Center   Regular School No Other 03 12 2020   pk_12_total * * *   15 *         *   * *     *   14         *   15         15                         14         15
163034 163034 AZ     school 400349 79387   Gila Institute for Technology 40034902242 79388 GIFT - Gila Institute for Technology   Career and Technical School No High 09 12 2020   pk_12_total * * *   * *         *   * *     *   *         *   6                                             6
163035 163035 AZ     school   8059   GILA RIVER HEAD START   8062 SACATON HEAD START             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
163036 163036 AZ     school   8059   GILA RIVER HEAD START   8063 SANTAN HEAD START             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
163037 163037 AZ     school   8059   GILA RIVER HEAD START   8064 VAH-KI HEAD START             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
163050 163050 AZ     school 403400 4239   Gilbert Unified District 40340003261 91209 Gilbert Global Academy 7-12   Regular School No High 07 12 2020   pk_12_total 76 * 28   * *         *   58 72     *   *         *   130 76   28                   58 72                 130
163099 163099 AZ     school 403450 4285   Glendale Union High School District 40345003510 794564 Glendale Union Online   Regular School No High 09 12 2020   pk_12_total 48 18 77   * *         11   63 100     *   *         *   163 48 18 77               11   63 100                 163
163109 163109 AZ     school   7317   Gompers   7318 Gompers Private School             2020   pk_12_total * * *   * *         *   * *     *   *         *   6                                             6
163114 163114 AZ     school   8816   Greater Phoenix Urban League Headstart   80655 St. Martin             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
163118 163118 AZ     school 403660 4371   Hackberry School District 40366000065 5570 Cedar Hills School   Regular School No Elementary KG 08 2020   pk_12_total 19 * *   * *         *   15 14     *   *         *   29 19                       15 14                 29
163123 163123 AZ     school 400782 89951   Haven Montessori Children's House, Inc. 40078202954 89952 Haven Montessori Charter School   Regular School Yes Elementary KG 06 2020   pk_12_total 61 * *   * *         *   38 36     *   *         *   74 61                       38 36                 74
163126 163126 AZ     school   89760   Head Start Washington Elementary School District   89761 Head Start Acacia School             2020   pk_12_total 11 * 13   * *         *   20 12     *   *         *   32 11   13                   20 12                 32
163127 163127 AZ     school   89760   Head Start Washington Elementary School District   89762 Head Start Alta Vista School             2020   pk_12_total * * 14   * *         *   13 18     *   *         *   31     14                   13 18                 31
163128 163128 AZ     school   89760   Head Start Washington Elementary School District   90756 Head Start Arroyo School             2020   pk_12_total * * *   * *         *   * *     *   *         *   16                                             16
163129 163129 AZ     school   89760   Head Start Washington Elementary School District   1000292 Head Start Cactus Wren             2020   pk_12_total * * 18   * *         *   17 16     *   *         *   33     18                   17 16                 33
163130 163130 AZ     school   89760   Head Start Washington Elementary School District   89763 Head Start Desert View School             2020   pk_12_total * * 13   * *         *   11 14     *   *         *   25     13                   11 14                 25
163131 163131 AZ     school   89760   Head Start Washington Elementary School District   90767 Head Start John Jacobs School             2020   pk_12_total * * 11   * *         *   * *     *   *         *   18     11                                       18
163132 163132 AZ     school   89760   Head Start Washington Elementary School District   89764 Head Start Manzanita School             2020   pk_12_total * * 22   * *         *   15 16     *   *         *   31     22                   15 16                 31
163133 163133 AZ     school   89760   Head Start Washington Elementary School District   89765 Head Start Maryland School             2020   pk_12_total * * *   * *         *   * *     *   *         *   17                                             17
163134 163134 AZ     school   89760   Head Start Washington Elementary School District   89766 Head Start Moon Mountain School             2020   pk_12_total * * 14   * *         *   * *     *   *         *   17     14                                       17
163135 163135 AZ     school   89760   Head Start Washington Elementary School District   89767 Head Start Mountain View School             2020   pk_12_total * * 48   * *         *   23 37     *   *         *   60     48                   23 37                 60
163136 163136 AZ     school   89760   Head Start Washington Elementary School District   89768 Head Start Ocotillo School             2020   pk_12_total * * 34   * *         *   23 28     *   *         *   51     34                   23 28                 51
163137 163137 AZ     school   89760   Head Start Washington Elementary School District   92910 Head Start Palo Verde             2020   pk_12_total * * 11   * *         *   * *     *   *         *   16     11                                       16
163138 163138 AZ     school   89760   Head Start Washington Elementary School District   90386 Head Start Richard E. Miller School             2020   pk_12_total * * 26   * *         *   24 24     *   *         *   48     26                   24 24                 48
163139 163139 AZ     school   89760   Head Start Washington Elementary School District   89771 Head Start Sahuaro School             2020   pk_12_total 14 * 27   * *         *   26 20     *   *         *   46 14   27                   26 20                 46
163140 163140 AZ     school   89760   Head Start Washington Elementary School District   89772 Head Start Shaw Butte School             2020   pk_12_total * * 25   * *         *   * *     *   *         *   33     25                                       33
163141 163141 AZ     school   89760   Head Start Washington Elementary School District   90783 Head Start Sunburst School             2020   pk_12_total * * *   * *         *   * *     *   *         *   16                                             16
163142 163142 AZ     school   89760   Head Start Washington Elementary School District   89773 Head Start Sunnyslope School             2020   pk_12_total * * 16   * *         *   * *     *   *         *   19     16                                       19
163143 163143 AZ     school   89760   Head Start Washington Elementary School District   90784 Head Start Sunset School             2020   pk_12_total * * *   * *         *   * *     *   *         *   17                                             17
163144 163144 AZ     school   89760   Head Start Washington Elementary School District   90785 Head Start Tumbleweed School             2020   pk_12_total * * 11   * *         *   * *     *   *         *   17     11                                       17
163145 163145 AZ     school   89760   Head Start Washington Elementary School District   89774 Head Start Washington School             2020   pk_12_total * * 20   * *         *   15 15     *   *         *   30     20                   15 15                 30
163146 163146 AZ     school   645408   Heartspring   791780 Heartspring             2020   pk_12_total * * *   * *         *   * *     *   *         *   1                                             1
163155 163155 AZ     school 400649 81076   Heritage Elementary School 40064902846 89624 Heritage Elementary - Williams   Regular School Yes Elementary KG 08 2020   pk_12_total 26 * 45   * *         *   38 38     11   *         *   76 26   45                   38 38     11           76
163158 163158 AZ     school   92191   Herzberg Educational Services, dba The Jones-Gordon School   92298 Herzberg Educational Services, dba The Jones-Gordon School             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
163159 163159 AZ     school 400275 79061   Highland Free School 40027502077 79115 Highland Free School   Regular School Yes Elementary KG 06 2020   pk_12_total 30 * 20   * *         *   31 25     *   *         *   56 30   20                   31 25                 56
163176 163176 AZ     school 408460 4482   Hillside Elementary District 40846000800 6117 Hillside Elementary School   Regular School No Elementary PK 08 2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
163179 163179 AZ     school   7372   Hi-Star Center for Children   92231 Hi-Star Center-Cactus Wren             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
163190 163190 AZ     school 403870 4469   Humboldt Unified District 40387002564 87536 Bradshaw Mountain Online Academy   Regular School No High 09 12 2020   pk_12_total 25 * 11   * *         *   18 20     *   *         *   38 25   11                   18 20                 38
163214 163214 AZ     school   91326   Incito Schools   1000253 Incito Schools-Phoenix             2020   pk_12_total * * *   * *         *   * *     *   *         *   *                                              
163217 163217 AZ     school 400992 1000164   Integrated Education Foundation, Inc. 40099203644 1000277 Kaleidoscope School   Regular School Yes Elementary KG 01 2020   pk_12_total 15 * *   * *         *   14 16     *   *         *   30 15                       14 16                 30
163218 163218 AZ     school 400650 5174   Integrity Education Incorporated 40065001846 10811 Integrity Education Centre   Regular School Yes Other KG 12 2020   pk_12_total 11 * *   * *         *   19 11     *   *         *   30 11                       19 11                 30
163233 163233 AZ     school 403990 4445   J O Combs Unified School District 40399003231 90807 Combs Traditional Academy   Regular School No Elementary KG 06 2020   pk_12_total 141 21 112   * *         18   131 167     11   *         *   298 141 21 112               18   131 167     11           298
163240 163240 AZ     school 400332 79475   James Sandoval Preparatory High School 40033202165 79476 Crown Point High School   Alternative School Yes High 09 12 2020   pk_12_total * * 47   * *         *   31 19     *   *         *   50     47                   31 19                 50
163245 163245 AZ     school 400882 91329   Kaizen Education Foundation dba Advance U 40088203409 92225 South Mountain Preparatory Academy   Regular School Yes Elementary KG 03 2020   pk_12_total * 14 42   * *         *   37 26     *   *         *   63   14 42                   37 26                 63
163261 163261 AZ     school 400351 79871   Kaizen Education Foundation dba Vista Grove Preparatory Academy Middle School 40035102148 79177 Vista Grove Preparatory Academy Middle School   Alternative School Yes Middle 07 09 2020   pk_12_total * * 16   * *         *   19 16     *   *         *   35     16                   19 16                 35
163265 163265 AZ     school 400267 79065   Kestrel Schools, Inc. 40026702091 79111 Valley Preparatory Academy   Alternative School Yes High 09 12 2020   pk_12_total * * *   * *         *   * *     *   *         *   26                                             26
163268 163268 AZ     school 400069 4360   Khalsa Montessori Elementary Schools 40006900826 5547 Khalsa Montessori Elementary School - Phoenix   Regular School Yes Elementary KG 07 2020   pk_12_total 106 * 25   * 11         *   76 79     *   *         *   155 106   25     11             76 79                 155
163350 163350 AZ     school 400944 92730   Leman Academy of Excellence, Inc. 40094403584 573453 Leman Academy of Excellence East Mesa   Regular School Yes Elementary KG 08 2020   pk_12_total 60 * 38   * *         *   54 63     *   *         *   117 60   38                   54 63                 117
163354 163354 AZ     school 400944 92730   Leman Academy of Excellence, Inc. 40094403547 271268 Leman Virtual Academy   Regular School Yes Elementary KG 08 2020   pk_12_total 59 * 16   * *         *   42 46     *   *         *   88 59   16                   42 46                 88

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