enrollments

Data source: Big Local News · About: Big Local

3,371,677 rows sorted by disability_int

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int ▼ section_504_int total_int
97074 97074 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 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97075 97075 AZ     school 400347 79381   Coconino Association for Vocation Industry and Technology 40034702471 87468 CAVIAT - Flagstaff High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97076 97076 AZ     school 400347 79381   Coconino Association for Vocation Industry and Technology 40034702269 79784 CAVIAT - Page High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97077 97077 AZ     school 400347 79381   Coconino Association for Vocation Industry and Technology 40034702271 79786 CAVIAT - Williams High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97078 97078 AZ     school 400163 10386   Coconino County Accommodation School District 40016303711 1001242 CCASD Online Instruction   Regular School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97079 97079 AZ     school   10386   Coconino County Accommodation School District   79010 Jail - Coconino County Accommodation School District             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97080 97080 AZ     school 400163 10386   Coconino County Accommodation School District 40016302429 85842 Ponderosa High School   Alternative School No High 09 12 2021   pk_12_total * * 16   16 *     *   *   22 19     *   *         *   41     16   16               22 19                 41
97081 97081 AZ     school 400163 10386   Coconino County Accommodation School District 40016303138 81127 Tse'yaato' High School   Alternative School No High 09 12 2021   pk_12_total * * *   23 *     *   *   11 19     *   *         *   30         23               11 19                 30
97085 97085 AZ     school 400082 4381   Colorado River Union High School District 40008203225 90858 CRUHSD Academy   Regular School No High 09 12 2021   pk_12_total 72 * 67   * *     *   *   82 74     *   *         *   156 72   67                   82 74                 156
97107 97107 AZ     school 400814 90331   CPLC Community Schools dba Hiaki High School 40081402554 87412 Envision High School   Alternative School Yes High 09 12 2021   pk_12_total * * 60   * *     *   *   42 31     *   *         *   73     60                   42 31                 73
97110 97110 AZ     school 402400 4501   Crane Elementary District 40240003521 778305 Crane iLearning Academy   Regular School No Elementary PK 08 2021   pk_12_total 14 * 45   * *     *   *   37 27     *   *         *   64 14   45                   37 27                 64
97130 97130 AZ     school 402460 4483   Crown King Elementary District 40246000182 6118 Crown King Elementary School   Regular School No Elementary KG 08 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97131 97131 AZ     school   60691   Cupertino Power Learning Center, Inc.   733509 Cupertino Power Learning Center             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97138 97138 AZ     school 400278 79496   Deer Valley Charter Schools, Inc. 40027802168 79506 Deer Valley Academy   Regular School Yes High 09 12 2021   pk_12_total 15 * *   * *     *   *   * *     *   *         *   21 15                                           21
97180 97180 AZ     school   88618   Desert Choice Schools LLC   147909 Desert Choice Schools - Casa Grande Middle School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97181 97181 AZ     school   88618   Desert Choice Schools LLC   812691 Desert Choice Schools - Dos Rios Elementary School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97184 97184 AZ     school   88618   Desert Choice Schools LLC   657386 Desert Choice Schools - Newell Barney Junior High School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97185 97185 AZ     school   88618   Desert Choice Schools LLC   1000049 Desert Choice Schools - Palo Verde Elementary School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97189 97189 AZ     school   88618   Desert Choice Schools LLC   88619 Desert Choice Schools - Sheely Farms Elementary School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97190 97190 AZ     school   88618   Desert Choice Schools LLC   1000142 Desert Choice Schools - Yuma High School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97193 97193 AZ     school 400448 88308   Desert Sky Community School, Inc. 40044802638 88309 Desert Sky Community School   Regular School Yes Elementary KG 05 2021   pk_12_total 33 * 17   * *     *   *   19 31     *   *         *   50 33   17                   19 31                 50
97196 97196 AZ     school   7301   Desert Voices Oral Learning Center   7302 Desert Voices Oral Learning Center             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97199 97199 AZ     school 402490 4179   Double Adobe Elementary District 40249000183 4787 Double Adobe Elementary School   Regular School No Elementary PK 08 2021   pk_12_total 28 * *   * *     *   *   17 17     *   *         *   34 28                       17 17                 34
97241 97241 AZ     school 409731 4516   East Valley Institute of Technology 40973103081 80662 EVIT - Basha High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97242 97242 AZ     school 409731 4516   East Valley Institute of Technology 40973103487 92840 EVIT - Casteel High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97243 97243 AZ     school 409731 4516   East Valley Institute of Technology 40973101515 7284 EVIT - Chandler High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97244 97244 AZ     school 409731 4516   East Valley Institute of Technology 40973103224 90912 EVIT - East Campus   Career and Technical School No High 10 12 2021   pk_12_total 186 * 64   * *     *   12   58 220     *   *         *   278 186   64               12   58 220                 278
97245 97245 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 2021   pk_12_total 309 * 157   * *     *   19   220 288     *   *         *   508 309   157               19   220 288                 508
97246 97246 AZ     school 409731 4516   East Valley Institute of Technology 40973102234 7287 EVIT - Gilbert High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97247 97247 AZ     school 409731 4516   East Valley Institute of Technology 40973102935 89939 EVIT - Mesquite High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97248 97248 AZ     school 409731 4516   East Valley Institute of Technology 40973102821 89632 EVIT - Perry High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97249 97249 AZ     school 409731 4516   East Valley Institute of Technology 40973103549 25790 EVIT East Apache Junction   Career and Technical School No High 10 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97250 97250 AZ     school 409731 4516   East Valley Institute of Technology 40973103544 165668 EVIT North Fountain Hills   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97252 97252 AZ     school 400817 90506   Ed Ahead 40081703191 90507 Academy Adventures Midtown   Regular School Yes Elementary KG 05 2021   pk_12_total * * 13   * *     *   *   16 14     *   *         *   30     13                   16 14                 30
97256 97256 AZ     school 400130 6365   Edkey Inc. dba American Heritage Academy 40013002569 88201 American Heritage Academy - Camp Verde   Regular School Yes Elementary KG 08 2021   pk_12_total 47 * 23   20 *     *   *   46 53     *   *         *   99 47   23   20               46 53                 99
97276 97276 AZ     school 401001 1000167   Educational Models for Learning, Inc. 40100103718 1001129 Educational Models for Learning – Arizona   Regular School Yes High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97278 97278 AZ     school 400816 90201   Educational Options Foundation 40081602998 90202 EdOptions Preparatory Academy   Alternative School Yes High 07 12 2021   pk_12_total * * 99   * *     *   *   65 35     *   *         *   100     99                   65 35                 100
97279 97279 AZ     school 400055 4341   EduPreneurship, Inc. 40005501731 10752 EduPreneurship Student Center (ESC) Phoenix   Regular School Yes Elementary KG 08 2021   pk_12_total * * 16   * *     *   *   15 18     *   *         *   33     16                   15 18                 33
97282 97282 AZ     school 400311 79059   E-Institute Charter Schools, Inc. 40031103292 91199 E-Institute at Avondale   Alternative School Yes High 09 12 2021   pk_12_total * * 34   * *     *   *   25 23     *   *         *   48     34                   25 23                 48
97283 97283 AZ     school 400311 79059   E-Institute Charter Schools, Inc. 40031103186 90768 E-Institute at Buckeye   Alternative School Yes High 09 12 2021   pk_12_total * * 33   * *     *   *   22 22     *   *         *   44     33                   22 22                 44
97284 97284 AZ     school 400311 79059   E-Institute Charter Schools, Inc. 40031103001 90389 E-Institute at Grovers   Alternative School Yes High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97285 97285 AZ     school 400311 79059   E-Institute Charter Schools, Inc. 40031102919 90075 E-Institute at Metro   Alternative School Yes High 09 12 2021   pk_12_total * * 11   * *     *   *   * *     *   *         *   25     11                                       25
97288 97288 AZ     school 400311 79059   E-Institute Charter Schools, Inc. 40031102151 79117 E-Institute at Union Hills   Alternative School Yes High 09 12 2021   pk_12_total * * 51   * *     *   *   31 30     *   *         *   61     51                   31 30                 61
97289 97289 AZ     school   1000037   Eleutheria LLC   1000038 Estrella Day School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97299 97299 AZ     school 400939 92902   Espiritu Schools 40093903495 92903 AIM Higher College Prep Academy   Regular School Yes High 07 12 2021   pk_12_total * * 44   * *     *   *   27 19     14   *         *   46     44                   27 19     14           46
97300 97300 AZ     school 400955 92988   Estrella Educational Foundation 40095503519 181823 Maricopa Institute of Technology   Regular School Yes High 09 12 2021   pk_12_total 25 24 215   * 11     *   11   177 109     *   *         *   286 25 24 215     11         11   177 109                 286
97331 97331 AZ     school 402920 4437   Florence Unified School District 40292003195 90781 Florence Virtual Academy   Regular School No Other KG 12 2021   pk_12_total 15 * 13   * *     *   *   * *     *   *         *   30 15   13                                       30
97342 97342 AZ     school 403010 4405   Flowing Wells Unified District 40301003331 91832 Flowing Wells Digital Campus   Regular School No Other KG 12 2021   pk_12_total 127 * 203   * *     *   12   180 171     17   *         *   351 127   203               12   180 171     17           351
97355 97355 AZ     school 403200 4221   Fort Thomas Unified District 40320002946 90064 Mt. Turnbull Academy   Alternative School No Other PK 12 2021   pk_12_total * * *   23 *     *   *   * *     *   *         *   23         23                                   23
97358 97358 AZ     school 400113 4356   Fountain Hills Charter School 40011301601 5539 Fountain Hills Charter School   Regular School Yes Elementary KG 08 2021   pk_12_total 34 * *   * *     *   *   27 21     *   *         *   48 34                       27 21                 48
97393 97393 AZ     school   87275   Gateway Academy   87276 Gateway Academy             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97394 97394 AZ     school 400145 6372   Gem Charter School, Inc. 40014501750 6045 Gem Charter School   Regular School Yes Elementary KG 06 2021   pk_12_total 54 * 22   * *     *   *   33 47     *   *         *   80 54   22                   33 47                 80
97395 97395 AZ     school 400124 4332   Genesis Program, Inc. 40012401589 5504 Genesis Academy   Alternative School Yes High 09 12 2021   pk_12_total * * 40   * *     *   *   21 27     *   *         *   48     40                   21 27                 48
97399 97399 AZ     school 400419 87600   Gila County Regional School District 40041902897 90038 Biyaagozhoo Center   Regular School No Other 03 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97400 97400 AZ     school 400349 79387   Gila Institute for Technology 40034902254 79650 GIFT - Ft. Thomas High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97401 97401 AZ     school 400349 79387   Gila Institute for Technology 40034902242 79388 GIFT - Gila Institute for Technology   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97402 97402 AZ     school 400349 79387   Gila Institute for Technology 40034902253 79649 GIFT - Pima High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97403 97403 AZ     school 400349 79387   Gila Institute for Technology 40034902252 79647 GIFT - Safford High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97404 97404 AZ     school 400349 79387   Gila Institute for Technology 40034903239 90892 GIFT-Morenci High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97405 97405 AZ     school   8059   GILA RIVER HEAD START   8062 SACATON HEAD START             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97406 97406 AZ     school   8059   GILA RIVER HEAD START   8063 SANTAN HEAD START             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97479 97479 AZ     school   7317   Gompers   7318 Gompers Private School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97484 97484 AZ     school 400343 79500   Griffin Foundation, Inc. The 40034302246 79512 Children Reaching for the Sky Preparatory   Regular School Yes Elementary KG 05 2021   pk_12_total * * 88   * *     *   *   45 69     12   *         *   114     88                   45 69     12           114
97487 97487 AZ     school 403660 4371   Hackberry School District 40366000065 5570 Cedar Hills School   Regular School No Elementary KG 08 2021   pk_12_total 34 * 13   * *     *   *   28 19     *   *         *   47 34   13                   28 19                 47
97492 97492 AZ     school 400782 89951   Haven Montessori Children's House, Inc. 40078202954 89952 Haven Montessori Charter School   Regular School Yes Elementary KG 06 2021   pk_12_total 57 * *   * *     *   *   39 30     *   *         *   69 57                       39 30                 69
97495 97495 AZ     school   89760   Head Start Washington Elementary School District   89761 Head Start Acacia School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   17                                             17
97496 97496 AZ     school   89760   Head Start Washington Elementary School District   89762 Head Start Alta Vista School             2021   pk_12_total * * 12   * *     *   *   * *     *   *         *   18     12                                       18
97497 97497 AZ     school   89760   Head Start Washington Elementary School District   90756 Head Start Arroyo School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97498 97498 AZ     school   89760   Head Start Washington Elementary School District   1000292 Head Start Cactus Wren             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   14                                             14
97499 97499 AZ     school   89760   Head Start Washington Elementary School District   89763 Head Start Desert View School             2021   pk_12_total * * 11   * *     *   *   * *     *   *         *   14     11                                       14
97500 97500 AZ     school   89760   Head Start Washington Elementary School District   90767 Head Start John Jacobs School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   14                                             14
97501 97501 AZ     school   89760   Head Start Washington Elementary School District   89764 Head Start Manzanita School             2021   pk_12_total * * 12   * *     *   *   * *     *   *         *   21     12                                       21
97502 97502 AZ     school   89760   Head Start Washington Elementary School District   89765 Head Start Maryland School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97503 97503 AZ     school   89760   Head Start Washington Elementary School District   89766 Head Start Moon Mountain School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97504 97504 AZ     school   89760   Head Start Washington Elementary School District   89767 Head Start Mountain View School             2021   pk_12_total * * 34   * *     *   *   19 22     *   *         *   41     34                   19 22                 41
97505 97505 AZ     school   89760   Head Start Washington Elementary School District   89768 Head Start Ocotillo School             2021   pk_12_total * * 22   * *     *   *   22 19     *   *         *   41     22                   22 19                 41
97506 97506 AZ     school   89760   Head Start Washington Elementary School District   92910 Head Start Palo Verde             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   12                                             12
97507 97507 AZ     school   89760   Head Start Washington Elementary School District   90386 Head Start Richard E. Miller School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   17                                             17
97508 97508 AZ     school   89760   Head Start Washington Elementary School District   89771 Head Start Sahuaro School             2021   pk_12_total 14 * 14   * *     *   *   18 16     *   *         *   34 14   14                   18 16                 34
97509 97509 AZ     school   89760   Head Start Washington Elementary School District   89772 Head Start Shaw Butte School             2021   pk_12_total * * 18   * *     *   *   13 14     *   *         *   27     18                   13 14                 27
97510 97510 AZ     school   89760   Head Start Washington Elementary School District   90783 Head Start Sunburst School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   15                                             15
97511 97511 AZ     school   89760   Head Start Washington Elementary School District   89773 Head Start Sunnyslope School             2021   pk_12_total * * 16   * *     *   *   * *     *   *         *   19     16                                       19
97512 97512 AZ     school   89760   Head Start Washington Elementary School District   90785 Head Start Tumbleweed School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97513 97513 AZ     school   89760   Head Start Washington Elementary School District   89774 Head Start Washington School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97514 97514 AZ     school   645408   Heartspring   791780 Heartspring             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97523 97523 AZ     school 400649 81076   Heritage Elementary School 40064902846 89624 Heritage Elementary - Williams   Regular School Yes Elementary KG 08 2021   pk_12_total 17 * 26   * *     *   *   20 25     *   *         *   45 17   26                   20 25                 45
97526 97526 AZ     school   92191   Herzberg Educational Services, dba The Jones-Gordon School   92298 Herzberg Educational Services, dba The Jones-Gordon School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97527 97527 AZ     school 400275 79061   Highland Free School 40027502077 79115 Highland Free School   Regular School Yes Elementary KG 06 2021   pk_12_total 24 * 21   * *     *   *   28 26     *   *         *   54 24   21                   28 26                 54
97544 97544 AZ     school 408460 4482   Hillside Elementary District 40846000800 6117 Hillside Elementary School   Regular School No Elementary PK 08 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97557 97557 AZ     school 403870 4469   Humboldt Unified District 40387002564 87536 Bradshaw Mountain Online Academy   Regular School No High 09 12 2021   pk_12_total 34 * 26   * *     *   *   34 29     *   *         *   63 34   26                   34 29                 63
97579 97579 AZ     school 400810 90160   Imagine Superstition Middle, Inc. 40081003026 90161 Imagine Superstition Middle   Regular School Yes Middle 06 08 2021   pk_12_total 73 * 50   * *     *   *   73 65     *   *         *   138 73   50                   73 65                 138
97581 97581 AZ     school   91326   Incito Schools   1000253 Incito Schools-Phoenix             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   13                                             13
97582 97582 AZ     school   92633   Individualized Learning Centers, LLC   92634 NOVA Individualized Learning Center             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   12                                             12
97584 97584 AZ     school 400650 5174   Integrity Education Incorporated 40065001846 10811 Integrity Education Centre   Regular School Yes Other KG 12 2021   pk_12_total * * 11   * *     *   *   * *     *   *         *   24     11                                       24
97599 97599 AZ     school 403990 4445   J O Combs Unified School District 40399003231 90807 Combs Traditional Academy   Regular School No Elementary KG 06 2021   pk_12_total 124 17 105   * *     *   17   123 146     11   *         *   269 124 17 105               17   123 146     11           269
97606 97606 AZ     school 400332 79475   James Sandoval Preparatory High School 40033202165 79476 Crown Point High School   Alternative School Yes High 09 12 2021   pk_12_total * * 47   * *     *   *   31 18     *   *         *   49     47                   31 18                 49
97611 97611 AZ     school 400882 91329   Kaizen Education Foundation dba Advance U 40088203409 92225 South Mountain Preparatory Academy   Regular School Yes Elementary KG 03 2021   pk_12_total * 14 34   * *     *   *   33 24     *   *         *   57   14 34                   33 24                 57
97625 97625 AZ     school 400387 79878   Kaizen Education Foundation dba Tempe Accelerated High School 40038701735 6349 Kaizen Education Foundation dba Quest High School   Alternative School Yes High 09 12 2021   pk_12_total * * 40   * *     *   *   23 29     *   *         *   52     40                   23 29                 52
97627 97627 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 2021   pk_12_total * * 17   * *     *   *   18 16     *   13         *   34     17                   18 16       13         34
97632 97632 AZ     school 400267 79065   Kestrel Schools, Inc. 40026702091 79111 Valley Preparatory Academy   Alternative School Yes High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   25                                             25

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