enrollments

Data source: Big Local News · About: Big Local

3,371,677 rows sorted by hispanic_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
97187 97187 AZ     school   88618   Desert Choice Schools LLC   64254 Desert Choice Schools - Queen Creek Elementary             2021   pk_12_total 13 * *   * *     *   *   * *     *   *         22   22 13                                       22   22
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 * * *   * *     *   *   * *     *   *         *   *                                              
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 * * *   * *     *   *   * *     *   *         *   *                                              
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 * * *   * *     *   *   * *     *   *         *   *                                              
97272 97272 AZ     school 400246 79211   Edkey, Inc. - Sequoia Village School 40024603494 92912 George Washington Academy   Regular School Yes Elementary KG 08 2021   pk_12_total 168 * *   * *     *   *   101 95     *   *         31   196 168                       101 95             31   196
97273 97273 AZ     school 400246 79211   Edkey, Inc. - Sequoia Village School 40024603028 90324 Sequoia Village High School   Regular School Yes High 09 12 2021   pk_12_total 46 * *   * *     *   *   33 30     *   *         14   63 46                       33 30             14   63
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 * * *   * *     *   *   * *     *   *         *   *                                              
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 * * *   * *     *   *   * *     *   *         *   *                                              
97289 97289 AZ     school   1000037   Eleutheria LLC   1000038 Estrella Day School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97314 97314 AZ     school 402860 4192   Flagstaff Unified District 40286000219 4814 Leupp Public School   Regular School No Elementary PK 05 2021   pk_12_total * * *   149 *     *   *   81 72     12   *         27   152         149               81 72     12       27   152
97353 97353 AZ     school 403200 4221   Fort Thomas Unified District 40320000248 4892 Fort Thomas Elementary School   Regular School No Elementary PK 06 2021   pk_12_total * * *   193 *     *   *   101 103     *   *         31   204         193               101 103             31   204
97354 97354 AZ     school 403200 4221   Fort Thomas Unified District 40320000249 4893 Fort Thomas High School   Regular School No High 07 12 2021   pk_12_total 14 * *   218 *     *   *   120 126     *   *         44   246 14       218               120 126             44   246
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
97356 97356 AZ     school 403200 4221   Fort Thomas Unified District 40320003460 92618 Mt. Turnbull Elementary School   Regular School No Elementary PK 06 2021   pk_12_total * * *   108 *     *   *   68 40     *   *         11   108         108               68 40             11   108
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
97373 97373 AZ     school 403080 4195   Fredonia-Moccasin Unified District 40308000241 4826 Fredonia Elementary School   Regular School No Elementary PK 06 2021   pk_12_total 60 * *   35 *     *   *   47 53     *   *         24   100 60       35               47 53             24   100
97374 97374 AZ     school 403080 4195   Fredonia-Moccasin Unified District 40308000242 4828 Fredonia High School   Regular School No High 07 12 2021   pk_12_total 65 * *   * *     *   *   38 49     *   *         11   87 65                       38 49             11   87
97387 97387 AZ     school 403290 4157   Ganado Unified School District 40329000252 4728 Ganado High School   Regular School No High 09 12 2021   pk_12_total * * *   451 *     *   16   241 231     39   *         41   472         451           16   241 231     39       41   472
97388 97388 AZ     school 403290 4157   Ganado Unified School District 40329000253 4726 Ganado Intermediate School   Regular School No Elementary 03 05 2021   pk_12_total * * *   204 *     *   18   112 117     *   *         22   229         204           18   112 117             22   229
97389 97389 AZ     school 403290 4157   Ganado Unified School District 40329000254 4727 Ganado Middle School   Regular School No Middle 06 08 2021   pk_12_total * * *   340 *     *   14   176 185     29   *         27   361         340           14   176 185     29       27   361
97390 97390 AZ     school 403290 4157   Ganado Unified School District 40329000251 4725 Ganado Primary School   Regular School No Elementary PK 02 2021   pk_12_total * * *   215 *     *   13   121 114     *   *         13   235         215           13   121 114             13   235
97393 97393 AZ     school   87275   Gateway Academy   87276 Gateway Academy             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
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 * * *   * *     *   *   * *     *   *         *   *                                              
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
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
97500 97500 AZ     school   89760   Head Start Washington Elementary School District   90767 Head Start John Jacobs School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   14                                             14
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 * * *   * *     *   *   * *     *   *         *   *                                              
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
97510 97510 AZ     school   89760   Head Start Washington Elementary School District   90783 Head Start Sunburst School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   15                                             15
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 * * *   * *     *   *   * *     *   *         *   *                                              
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 * * *   * *     *   *   * *     *   *         *   *                                              
97544 97544 AZ     school 408460 4482   Hillside Elementary District 40846000800 6117 Hillside Elementary School   Regular School No Elementary PK 08 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
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
97629 97629 AZ     school 404060 4396   Kayenta Unified School District #27 40406001160 5642 Kayenta Elementary School   Regular School No Elementary PK 04 2021   pk_12_total * * *   517 *     *   *   284 249     68   *         61   533         517               284 249     68       61   533
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
97752 97752 AZ     school 404380 4281   Litchfield Elementary District 40438002003 79220 White Tanks Learning Center   Special Education School No Elementary KG 08 2021   pk_12_total * * *   * *     *   *   * *     *   *         20   21                                         20   21
97777 97777 AZ     school 404630 4404   Marana Unified District 40463000999 5768 A. C. E.   Regular School No High 07 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97799 97799 AZ     school   7432   Maricopa County Head Start   1000053 1ST ACADEMY PRESCHOOL & CHILDCARE             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97800 97800 AZ     school   7432   Maricopa County Head Start   988851 ADAMS MCHS             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97801 97801 AZ     school   7432   Maricopa County Head Start   277481 Beautiful Oasis             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97802 97802 AZ     school   7432   Maricopa County Head Start   90457 Bellview             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97803 97803 AZ     school   7432   Maricopa County Head Start   7442 EAST MESA-STEVENSON HEAD START             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97804 97804 AZ     school   7432   Maricopa County Head Start   89382 First Presbyterian Church (FPC) 1/11             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97805 97805 AZ     school   7432   Maricopa County Head Start   92642 First United Methodist Church of Mesa             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97806 97806 AZ     school   7432   Maricopa County Head Start   92283 La Mesita Head Start             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97807 97807 AZ     school   7432   Maricopa County Head Start   78790 Lincoln             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97808 97808 AZ     school   7432   Maricopa County Head Start   88393 MARICOPA COUNTY HUMAN SERVICES - HAWTHORNE HEAD ST             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97809 97809 AZ     school   7432   Maricopa County Head Start   78793 Taft             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97810 97810 AZ     school   7432   Maricopa County Head Start   92281 Whitman Head Start             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97827 97827 AZ     school 400281 79499   Masada Charter School, Inc. 40028102187 79511 Masada Charter School   Regular School Yes Other KG 09 2021   pk_12_total 478 * *   * *     *   *   235 243     *   *         124   478 478                       235 243             124   478
97832 97832 AZ     school 404860 4163   Mcnary Elementary District 40486000376 4745 Mcnary Elementary School   Regular School No Elementary PK 08 2021   pk_12_total * * *   131 *     *   *   70 63     *   *         19   133         131               70 63             19   133
97841 97841 AZ     school 404970 4235   Mesa Unified District 40497002337 80046 Early Education Center   Regular School No Prekindergarten PK PK 2021   pk_12_total 19 * *   * *     *   *   22 14     *   *         *   36 19                       22 14                 36
97916 97916 AZ     school 405030 4211   Miami Unified District 40503002789 89583 M.U.S.D. #40 - Little Vandal Preschool   Special Education School No Prekindergarten PK PK 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   11                                             11
97920 97920 AZ     school   90048   Mingus Mountain Estate Residential Center, Inc.   90049 Mingus Mountain Academy             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   16                                             16
97921 97921 AZ     school   90048   Mingus Mountain Estate Residential Center, Inc.   263569 Sequel Learning Academy (formerly Sequel Boy School)             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97923 97923 AZ     school 405070 4488   Mingus Union High School District 40507003308 91320 Mingus Online Academy   Regular School No High 08 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   12                                             12
97925 97925 AZ     school 405100 4253   Mobile Elementary District 40510000431 5191 Mobile Elementary School   Regular School No Elementary KG 08 2021   pk_12_total 13 * *   * *     *   *   11 13     *   *         *   24 13                       11 13                 24
97935 97935 AZ     school 400068 4359   Montessori Day Public Schools Chartered, Inc. 40006800825 5542 Montessori Day Public Schools Chartered - Tempe   Regular School Yes Elementary KG 08 2021   pk_12_total 57 * *   * 11     *   11   37 56     *   *         *   93 57         11         11   37 56                 93
97938 97938 AZ     school 400126 4428   Montessori Schoolhouse of Tucson, Inc. 40012601620 5869 Montessori Schoolhouse   Regular School Yes Elementary KG KG 2021   pk_12_total 11 * *   * *     *   *   * *     *   *         *   20 11                                           20
97946 97946 AZ     school 400772 90090   Mountain Institute JTED 40077203630 1000195 MICTED - Medical   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97947 97947 AZ     school 400772 90090   Mountain Institute JTED 40077202974 90405 MIJTED - Ashfork High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97948 97948 AZ     school 400772 90090   Mountain Institute JTED 40077202973 90412 MIJTED - Chino Valley High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97949 97949 AZ     school 400772 90090   Mountain Institute JTED 40077203033 90406 MIJTED - Yavapai College CTEC   Career and Technical School No High 09 12 2021   pk_12_total 14 * *   * *     *   *   * *     *   *         *   17 14                                           17
97958 97958 AZ     school 405460 4252   Nadaburg Unified School District 40546003690 1001155 Mountainside High School   Regular School No Secondary 09 09 2021   pk_12_total 17 * *   * *     *   *   16 11     *   *         *   27 17                       16 11                 27
97960 97960 AZ     school 405460 4252   Nadaburg Unified School District 40546003623 1000059 Nadaburg Online Virtual Academy   Regular School No High 07 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   18                                             18
97961 97961 AZ     school 405500 4386   Navajo County Accommodation District #99 40550001237 7654 Navajo County Instruction for Success (NCIS)   Alternative School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   18                                             18
97962 97962 AZ     school   6476   NAVAJO TRIBAL HEAD START   6488 CHINLE HEAD START             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97965 97965 AZ     school   32051   New Horizons Academy, LLC   837053 New Horizon Academy             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97969 97969 AZ     school   7303   New Way Academy   7304 New Way Academy             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97986 97986 AZ     school 400612 81114   Northeast Arizona Technological Institute of Vocational Education 40061203129 81117 NATIVE - Chinle High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   24 *     *   *   15 11     *   *         *   26         24               15 11                 26
97987 97987 AZ     school 400612 81114   Northeast Arizona Technological Institute of Vocational Education 40061203130 81118 NATIVE - Ganado High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   32 *     *   *   * *     *   *         *   33         32                                   33
97988 97988 AZ     school 400612 81114   Northeast Arizona Technological Institute of Vocational Education 40061203128 81116 NATIVE - Pinon High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   16 *     *   *   * *     *   *         *   16         16                                   16
97989 97989 AZ     school 400612 81114   Northeast Arizona Technological Institute of Vocational Education 40061203131 81119 NATIVE - Red Mesa High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97990 97990 AZ     school 400612 81114   Northeast Arizona Technological Institute of Vocational Education 40061202545 87488 NATIVE - Tuba City High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   15 *     *   *   * *     *   *         *   16         15                                   16
97991 97991 AZ     school 400612 81114   Northeast Arizona Technological Institute of Vocational Education 40061203132 81120 NATIVE - Window Rock High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97992 97992 AZ     school 400612 81114   Northeast Arizona Technological Institute of Vocational Education 40061203311 91802 NATIVE Central Campus   Career and Technical School No High 10 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   12                                             12

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