Data source: Big Local News · About: Big Local

3,371,677 rows sorted by white_int

View and edit SQL

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
97064 AZ     school 400316 79391   Cobre Valley Institute of Technology District 40031602103 79791 CVIT - Superior High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97067 AZ     school 400345 79403   Cochise Technology District 40034502261 79680 CTD - Benson High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97068 AZ     school 400345 79403   Cochise Technology District 40034503589 1000115 CTD - Cochise College   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97069 AZ     school 400345 79403   Cochise Technology District 40034502577 79404 CTD - Cochise Technology School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97070 AZ     school 400345 79403   Cochise Technology District 40034502260 79679 CTD - Tombstone High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97071 AZ     school 400345 79403   Cochise Technology District 40034502257 79676 CTD - Valley Union High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97072 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 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97073 AZ     school 400347 79381   Coconino Association for Vocation Industry and Technology 40034702470 87467 CAVIAT - Coconino High School   Career and Technical School No High 09 12 2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
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 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 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 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 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 AZ     school   10386   Coconino County Accommodation School District   79010 Jail - Coconino County Accommodation School District             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
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 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
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
97108 AZ     school 400382 80032   CPLC Community Schools dba Toltecalli High School 40038202331 80033 Toltecali High School   Alternative School Yes High 09 12 2021   pk_12_total * * 139   * *     *   *   85 64     23   13         23   149     139                   85 64     23 13     23   149
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 AZ     school   60691   Cupertino Power Learning Center, Inc.   733509 Cupertino Power Learning Center             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97180 AZ     school   88618   Desert Choice Schools LLC   147909 Desert Choice Schools - Casa Grande Middle School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97181 AZ     school   88618   Desert Choice Schools LLC   812691 Desert Choice Schools - Dos Rios Elementary School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97183 AZ     school   88618   Desert Choice Schools LLC   92894 Desert Choice Schools - Evans Learning Center             2021   pk_12_total * * *   * *     *   *   * *     *   *         19   20                                         19   20
97184 AZ     school   88618   Desert Choice Schools LLC   657386 Desert Choice Schools - Newell Barney Junior High School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97185 AZ     school   88618   Desert Choice Schools LLC   1000049 Desert Choice Schools - Palo Verde Elementary School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97186 AZ     school   88618   Desert Choice Schools LLC   92895 Desert Choice Schools - Pecan Grove Elementary             2021   pk_12_total * * *   * *     *   *   * *     *   *         14   14                                         14   14
97189 AZ     school   88618   Desert Choice Schools LLC   88619 Desert Choice Schools - Sheely Farms Elementary School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97190 AZ     school   88618   Desert Choice Schools LLC   1000142 Desert Choice Schools - Yuma High School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97196 AZ     school   7301   Desert Voices Oral Learning Center   7302 Desert Voices Oral Learning Center             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97200 AZ     school 402530 4174   Douglas Unified District 40253000186 4765 Clawson School   Regular School No Elementary KG 05 2021   pk_12_total * * 292   * *     *   *   146 155     66   *         19   301     292                   146 155     66       19   301
97203 AZ     school 402530 4174   Douglas Unified District 40253000191 4767 Faras Elementary School   Regular School No Elementary KG 05 2021   pk_12_total * * 145   * *     *   *   77 71     46   *         17   148     145                   77 71     46       17   148
97204 AZ     school 402530 4174   Douglas Unified District 40253000190 4766 Joe Carlson Elementary School   Regular School No Elementary KG 06 2021   pk_12_total * * 366   * *     *   *   183 198     124   *         43   381     366                   183 198     124       43   381
97205 AZ     school 402530 4174   Douglas Unified District 40253000185 4771 Paul H Huber Jr High School   Regular School No Middle 06 08 2021   pk_12_total * * 434   * *     *   *   235 208     65   *         37   443     434                   235 208     65       37   443
97206 AZ     school 402530 4174   Douglas Unified District 40253000194 4770 Ray Borane Middle School   Regular School No Middle 06 08 2021   pk_12_total * * 401   * *     *   *   225 187     126   *         34   412     401                   225 187     126       34   412
97207 AZ     school 402530 4174   Douglas Unified District 40253000192 4768 Sarah Marley School   Regular School No Elementary KG 05 2021   pk_12_total * * 228   * *     *   *   126 110     117   *         15   236     228                   126 110     117       15   236
97208 AZ     school 402530 4174   Douglas Unified District 40253000193 4769 Stevenson Elementary School   Regular School No Elementary KG 05 2021   pk_12_total * * 364   * *     *   *   186 188     86   *         25   374     364                   186 188     86       25   374
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 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 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 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 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 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 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 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 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
97269 AZ     school 400641 81052   Edkey, Inc. - Sequoia Ranch School 40064102881 89920 Children First Leadership Academy   Regular School Yes Elementary KG 08 2021   pk_12_total * 21 112   * *     *   *   63 85     21   *         21   148   21 112                   63 85     21       21   148
97271 AZ     school 400640 81050   Edkey, Inc. - Sequoia School for the Deaf and Hard of Hearing 40064003569 920316 KELLY   Special Education School Yes Other KG 12 2021   pk_12_total * * 17   * *     *   *   * *     *   *         37   37     17                                   37   37
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 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 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 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 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 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 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 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 AZ     school   1000037   Eleutheria LLC   1000038 Estrella Day School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97292 AZ     school 402790 4448   Eloy Elementary District 40279001060 5941 Eloy Intermediate School   Regular School No Elementary 03 05 2021   pk_12_total * 22 183   16 *     *   *   128 103     19   *         29   231   22 183   16               128 103     19       29   231
97293 AZ     school 402790 4448   Eloy Elementary District 40279000209 5942 Eloy Junior High School   Regular School No Middle 06 08 2021   pk_12_total * 18 230   11 *     *   *   145 131     17   *         35   276   18 230   11               145 131     17       35   276
97295 AZ     school 400877 91277   Empower College Prep 40087703354 91783 Empower College Prep   Regular School Yes Elementary KG 08 2021   pk_12_total * 46 454   * *     *   19   281 263     182   *         49   544   46 454               19   281 263     182       49   544
97296 AZ     school 400877 91277   Empower College Prep 40087703522 92975 Empower College Prep High School   Regular School Yes High 09 12 2021   pk_12_total * 20 276   * *     *   *   171 139     92   *         38   310   20 276                   171 139     92       38   310
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
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
97325 AZ     school 400144 4300   Florence Crittenton Services of Arizona, Inc. 40014401717 5466 Girls Leadership Academy of Arizona   Regular School Yes High 09 12 2021   pk_12_total * * 73   * *     *   *   * *     19   *         17   90     73                           19       17   90
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
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 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
97369 AZ     school 403060 4273   Fowler Elementary District 40306003085 80916 Western Valley Middle School   Regular School No Middle 06 08 2021   pk_12_total * 13 177   * *     *   *   106 98     36   *         40   204   13 177                   106 98     36       40   204
97377 AZ     school 400102 4303   Friendly House, Inc. 40010201582 6036 Friendly House Academia Del Pueblo Elem   Regular School Yes Elementary KG 08 2021   pk_12_total * 14 310   * *     *   *   172 165     76   *         34   337   14 310                   172 165     76       34   337
97378 AZ     school 403240 4505   Gadsden Elementary District 40324001806 6187 Arizona Desert Elementary School   Regular School No Elementary KG 06 2021   pk_12_total * * 625   * *     *   *   338 291     332   *         70   627     625                   338 291     332       70   627
97379 AZ     school 403240 4505   Gadsden Elementary District 40324003066 79724 Cesar Chavez Elementary   Regular School No Elementary KG 06 2021   pk_12_total * * 692   * *     *   *   374 327     350   *         78   700     692                   374 327     350       78   700
97380 AZ     school 403240 4505   Gadsden Elementary District 40324003116 81096 Desert View Elementary   Regular School No Elementary KG 06 2021   pk_12_total * * 711   * *     *   *   354 360     231   *         88   712     711                   354 360     231       88   712
97381 AZ     school 403240 4505   Gadsden Elementary District 40324002389 81106 Ed Pastor Elementary 4   Regular School No Elementary KG 06 2021   pk_12_total * * 551   * *     *   *   280 275     305   *         58   555     551                   280 275     305       58   555
97382 AZ     school 403240 4505   Gadsden Elementary District 40324000250 6183 Gadsden Elementary School   Regular School No Elementary PK 08 2021   pk_12_total * * 508   * *     *   *   238 270     276   *         56   508     508                   238 270     276       56   508
97383 AZ     school 403240 4505   Gadsden Elementary District 40324001213 6184 Rio Colorado Elementary School   Regular School No Elementary KG 06 2021   pk_12_total * * 494   * *     *   *   255 240     278   *         57   495     494                   255 240     278       57   495
97384 AZ     school 403240 4505   Gadsden Elementary District 40324001101 6185 San Luis Middle School   Regular School No Middle 07 08 2021   pk_12_total * * 620   * *     *   *   308 314     263   *         60   622     620                   308 314     263       60   622
97385 AZ     school 403240 4505   Gadsden Elementary District 40324001108 6186 San Luis Pre-School   Regular School No Prekindergarten PK PK 2021   pk_12_total * * 61   * *     *   *   40 21     *   *         44   61     61                   40 21             44   61
97386 AZ     school 403240 4505   Gadsden Elementary District 40324002388 81105 Southwest Jr. High School   Regular School No Middle 07 08 2021   pk_12_total * * 644   * *     *   *   331 313     161   *         80   644     644                   331 313     161       80   644
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 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 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 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 AZ     school   87275   Gateway Academy   87276 Gateway Academy             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
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
97396 AZ     school 400876 90884   George Gervin Youth Center, Inc. 40087603352 91712 George Gervin Prep Academy   Regular School Yes Elementary KG 08 2021   pk_12_total * 58 84   * *     *   *   86 69     29   *         12   155   58 84                   86 69     29       12   155
97398 AZ     school 403310 4238   Gila Bend Unified District 40331000256 5019 Gila Bend High School   Regular School No High 06 12 2021   pk_12_total * * 122   58 *     *   *   113 81     49   *         29   194     122   58               113 81     49       29   194
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 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 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 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 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 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 AZ     school   8059   GILA RIVER HEAD START   8062 SACATON HEAD START             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97406 AZ     school   8059   GILA RIVER HEAD START   8063 SANTAN HEAD START             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
97460 AZ     school 403420 4271   Glendale Elementary District 40342000267 5333 Isaac E Imes School   Regular School No Elementary PK 08 2021   pk_12_total * 24 317   * *     *   *   183 183     114   *         51   366   24 317                   183 183     114       51   366
97479 AZ     school   7317   Gompers   7318 Gompers Private School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   *                                              
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
97485 AZ     school 400343 79500   Griffin Foundation, Inc. The 40034303003 90470 Future Investment Middle School   Regular School Yes Middle 06 08 2021   pk_12_total * * 50   * *     *   *   31 33     *   *         13   64     50                   31 33             13   64
97486 AZ     school 400147 6369   Ha:san Educational Services 40014701787 5872 Ha:san Preparatory & Leadership School   Alternative School Yes High 09 12 2021   pk_12_total * * 19   97 *     *   *   59 63     *   *         32   122     19   97               59 63             32   122
97495 AZ     school   89760   Head Start Washington Elementary School District   89761 Head Start Acacia School             2021   pk_12_total * * *   * *     *   *   * *     *   *         *   17                                             17
97496 AZ     school   89760   Head Start Washington Elementary School District   89762 Head Start Alta Vista School             2021   pk_12_total * * 12   * *     *   *   * *     *   *         *   18     12                                       18

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