enrollments

Data source: Big Local News · About: Big Local

1,461 rows where grade = "pk_12_total", state = "CT" and year = 2020 sorted by ccd_school_low_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 1,361 ✖

grade ✖

  • pk_12_total · 1,361 ✖
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
2778051 2778051 CT     school   490011   Enfield School District   492411 Eagle Academy Program           2020   pk_12_total * * *   0 0     0   *   7 0     0             7   7         0 0     0       7 0     0       7   7
2778052 2778052 CT     school   490011   Enfield School District 90147001676 490511 Edgar H. Parkman - Autism Spectrum Disorder (ASD) Program           2020   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2778054 2778054 CT     school   490011   Enfield School District   491411 Eli Whitney - Intermediate Adaptive Learning (IAL) Program           2020   pk_12_total * * *   0 0     0   0   * *     0             *   *         0 0     0   0           0            
2778056 2778056 CT     school   490011   Enfield School District 90147001702 490711 Prudence Crandall - Educational Counseling Program (ECP) Program           2020   pk_12_total * 0 *   0 0     0   0   6 0     0             6   6   0     0 0     0   0   6 0     0       6   6
2778057 2778057 CT     school   490011   Enfield School District   490911 John F. Kennedy - Adaptive Learning Program (ALP) Program           2020   pk_12_total * * *   0 *     0   0   * *     *             12   12         0       0   0                   12   12
2778059 2778059 CT     school   490011   Enfield School District   492311 Enfield Alternative Education Program Program           2020   pk_12_total * * *   0 0     0   *   * *     0             *   7         0 0     0               0           7
2778060 2778060 CT     school   490011   Enfield School District   490111 Enfield High - Adaptive Learning Program (ALP) Program           2020   pk_12_total * 0 0   0 *     0   0   * *     0             6   6   0 0   0       0   0           0       6   6
2778062 2778062 CT     school   490011   Enfield School District 90147001523 499011 Enfield Transitional Learning Academy Program           2020   pk_12_total 12 * 0   0 *     0   *   10 7     0             17   17 12   0   0       0       10 7     0       17   17
2778064 2778064 CT     school   510011   Fairfield School District   510811 Early Childhood Center(0510811) Program           2020   pk_12_total 46 * 14   0 *     0   *   41 27     0             41   68 46   14   0       0       41 27     0       41   68
2778065 2778065 CT     school   510011   Fairfield School District 90153000989 518011 Early Childhood Center(0518011) Program           2020   pk_12_total 67 0 20   0 9     0   6   63 39     0             65   102 67 0 20   0 9     0   6   63 39     0       65   102
2778082 2778082 CT     school   510011   Fairfield School District   510311 Walter Fitzgerald Campus Program           2020   pk_12_total 19 * *   0 0     0   0   20 7     *             *   27 19       0 0     0   0   20 7                 27
2778083 2778083 CT     school   510011   Fairfield School District   510511 Fairfield School/Community Partnership Program           2020   pk_12_total 16 * *   0 *     0   0   13 7     0             20   20 16       0       0   0   13 7     0       20   20
2778084 2778084 CT     school   520011   Farmington School District 90156001441 528011 Farmington Collaborative PK Program           2020   pk_12_total 69 8 15   0 16     0   7   60 55     0             35   115 69 8 15   0 16     0   7   60 55     0       35   115
2778092 2778092 CT     school   520011   Farmington School District 90156001713 520611 Farmington Alternative High School Program           2020   pk_12_total * * *   0 *     0   0   * *     *             *   7         0       0   0                       7
2778094 2778094 CT     school   540011   Glastonbury School District 90162001724 540511 PreK-Eastbury Program           2020   pk_12_total 44 * 8   0 *     0   0   38 18     0             38   56 44   8   0       0   0   38 18     0       38   56
2778100 2778100 CT     school   540011   Glastonbury School District 90162001801 540111 Links Academy Program           2020   pk_12_total 26 * 10   * 0     0   *   29 15     0             44   44 26   10     0     0       29 15     0       44   44
2778104 2778104 CT     school   540011   Glastonbury School District 90162001752 541411 Glastonbury Transition Academy Program           2020   pk_12_total 7 * *   0 *     0   0   * *     0             12   12 7       0       0   0           0       12   12
2778124 2778124 CT     school   570011   Greenwich School District   571511 Windrose Program           2020   pk_12_total 15 * 13   0 0     0   *   15 15     0             12   30 15   13   0 0     0       15 15     0       12   30
2778125 2778125 CT     school   570011   Greenwich School District 90171001664 571211 Community Connections Program           2020   pk_12_total 10 * *   0 *     0   0   12 6     0             *   18 10       0       0   0   12 6     0           18
2778139 2778139 CT     school   590011   Groton School District   590611 Apex Academy Program           2020   pk_12_total * * 0   0 0     0   *   * *     0             *   *     0   0 0     0               0            
2778140 2778140 CT     school   590011   Groton School District   590211 New Beginnings Alternative Program Program           2020   pk_12_total * * *   0 0     0   *   * *     0             6   6         0 0     0               0       6   6
2778141 2778141 CT     school   590011   Groton School District   591011 Transition Academy Program           2020   pk_12_total 7 * *   0 0     0   *   * *     *             14   14 7       0 0     0                       14   14
2778149 2778149 CT     school   620011   Hamden School District 90186001433 628011 Alice Peck Learning Center Program           2020   pk_12_total 36 36 25   0 16     0   9   66 56     0             58   122 36 36 25   0 16     0   9   66 56     0       58   122
2778153 2778153 CT     school   620011   Hamden School District   620711 Alice Peck IIC Program           2020   pk_12_total * 12 8   0 *     0   *   24 7     0             31   31   12 8   0       0       24 7     0       31   31
2778155 2778155 CT     school   620011   Hamden School District   621711 Ridge Hill IIC Program           2020   pk_12_total 0 7 *   0 *     0   0   * *     0             15   15 0 7     0       0   0           0       15   15
2778160 2778160 CT     school   620011   Hamden School District   621611 Helen Street IIC Program           2020   pk_12_total 0 8 6   0 *     0   *   * *     *             16   16 0 8 6   0       0                       16   16
2778161 2778161 CT     school   620011   Hamden School District   621911 Intensive Support Classroom Program           2020   pk_12_total * * *   0 0     0   0   * 0     0             *   *         0 0     0   0     0     0            
2778162 2778162 CT     school   620011   Hamden School District   621811 West Woods IIC Program           2020   pk_12_total * 13 *   0 0     0   *   15 8     0             23   23   13     0 0     0       15 8     0       23   23
2778163 2778163 CT     school   620011   Hamden School District   621311 Church Street IIC Program           2020   pk_12_total * 6 7   0 *     0   0   10 6     *             16   16   6 7   0       0   0   10 6             16   16
2778164 2778164 CT     school   620011   Hamden School District   621511 Dunbar Hill IIC Program           2020   pk_12_total * 7 *   0 *     0   *   * *     *             16   16   7     0       0                       16   16
2778165 2778165 CT     school   620011   Hamden School District   620911 Bear Path IIC Program           2020   pk_12_total * 15 *   0 *     0   *   17 6     0             23   23   15     0       0       17 6     0       23   23
2778167 2778167 CT     school   620011   Hamden School District 90186001741 620511 Hamden Collaborative Learning Center Program           2020   pk_12_total 14 20 15   0 *     0   *   32 20     *             32   52 14 20 15   0       0       32 20             32   52
2778169 2778169 CT     school   620011   Hamden School District   620611 Hamden Transition Academy @ SCSU (AACPB) Program           2020   pk_12_total * 7 0   0 *     0   0   * *     *             10   10   7 0   0       0   0                   10   10
2778177 2778177 CT     school   640011   Hartford School District 90192001723 644111 Early Childhood Development Center (ECDC) Program           2020   pk_12_total * 8 8   0 *     0   *   * *     0             19   19   8 8   0       0               0       19   19
2778187 2778187 CT     school   640011   Hartford School District   640310 Pre-K Integrated - Burr School             2020   pk_12_total 0 6 24   0 0     0   0   17 13     0             11   30 0 6 24   0 0     0   0   17 13     0       11   30
2778188 2778188 CT     school   640011   Hartford School District   640510 Pre-K Integrated - Naylor School Program           2020   pk_12_total * 8 29   0 *     0   0   23 18     0             22   41   8 29   0       0   0   23 18     0       22   41
2778189 2778189 CT     school   640011   Hartford School District   640410 Pre-K Integrated - Parkville School Program           2020   pk_12_total * * 15   0 0     0   0   9 8     0             7   17     15   0 0     0   0   9 8     0       7   17
2778190 2778190 CT     school   640011   Hartford School District   640610 Pre-K Integrated - West Middle School Program           2020   pk_12_total * 7 7   0 *     0   0   10 8     0             10   18   7 7   0       0   0   10 8     0       10   18
2778197 2778197 CT     school   640011   Hartford School District 90192001764 648511 iGOAL 2 - Moylan School Program           2020   pk_12_total 0 * *   0 0     0   0   * *     0             6   6 0       0 0     0   0           0       6   6
2778198 2778198 CT     school   640011   Hartford School District   640710 iGOAL Pre-K - Naylor School Program           2020   pk_12_total * * 6   0 0     0   *   9 0     0             9   9     6   0 0     0       9 0     0       9   9
2778199 2778199 CT     school   640011   Hartford School District   640810 iGOAL Pre-K - Rawson School Program           2020   pk_12_total * * *   0 0     0   0   * *     0             8   8         0 0     0   0           0       8   8
2778204 2778204 CT     school   640011   Hartford School District   649511 iGOAL 1 - Breakthrough Magnet School, North Program           2020   pk_12_total 0 * *   0 0     0   0   * *     *             11   11 0       0 0     0   0                   11   11
2778205 2778205 CT     school   640011   Hartford School District   644711 iGOAL 1 - Burns School Program           2020   pk_12_total 0 * 26   0 *     0   0   24 8     10             32   32 0   26   0       0   0   24 8     10       32   32
2778206 2778206 CT     school   640011   Hartford School District 90192001732 645711 iGOAL 1 - M.D. Fox School Program           2020   pk_12_total * * 26   0 0     *   0   20 14     13             19   34     26   0 0         0   20 14     13       19   34
2778207 2778207 CT     school   640011   Hartford School District   648711 iGOAL 1 - Parkville School Program           2020   pk_12_total 0 * *   0 0     0   0   9 0     *             9   9 0       0 0     0   0   9 0             9   9
2778208 2778208 CT     school   640011   Hartford School District 90192001673 644411 iGOAL 1 - Rawson School Program           2020   pk_12_total 0 10 *   0 0     0   *   * *     *             *   18 0 10     0 0     0                           18
2778209 2778209 CT     school   640011   Hartford School District   644611 RISE - West Middle School Program           2020   pk_12_total 0 * *   0 0     0   0   * 0     *             *   * 0       0 0     0   0     0                  
2778210 2778210 CT     school   640011   Hartford School District   649811 iGOAL 1 - Moylan School             2020   pk_12_total 0 * *   0 0     0   *   * *     *             8   8 0       0 0     0                       8   8
2778211 2778211 CT     school   640011   Hartford School District   645911 RISE - M.D. Fox School             2020   pk_12_total * * 13   0 0     0   0   * *     *             27   27     13   0 0     0   0                   27   27
2778214 2778214 CT     school   640011   Hartford School District   640210 iGOAL 2 - Kennelly School Program           2020   pk_12_total 0 * *   0 0     0   0   * *     *             9   9 0       0 0     0   0                   9   9
2778221 2778221 CT     school   640011   Hartford School District   648911 iGOAL 1 - McDonough Middle School             2020   pk_12_total 0 * *   0 0     0   0   * *     *             9   9 0       0 0     0   0                   9   9
2778222 2778222 CT     school   640011   Hartford School District   640110 iGOAL 1 - Milner School Program           2020   pk_12_total 0 * *   0 0     0   0   * *     *             20   20 0       0 0     0   0                   20   20
2778223 2778223 CT     school   640011   Hartford School District   640910 New Visions Program           2020   pk_12_total * * 25   0 0     0   0   28 13     13             13   41     25   0 0     0   0   28 13     13       13   41
2778228 2778228 CT     school   640011   Hartford School District 90192001770 648311 RISE - Bulkeley High School Program           2020   pk_12_total * * 14   0 0     0   0   * *     *             20   20     14   0 0     0   0                   20   20
2778229 2778229 CT     school   640011   Hartford School District 90192001677 648211 RISE - Hartford Public High School Program           2020   pk_12_total * * 15   0 0     0   0   * *     *             *   24     15   0 0     0   0                       24
2778231 2778231 CT     school   640011   Hartford School District 90192000382 646311 Weaver High School Public Schools           2020   pk_12_total * 229 178   * *     0   6   * 215     53             103   423   229 178           0   6     215     53       103   423
2778232 2778232 CT     school   640011   Hartford School District 90192001660 644911 iGOAL 1 - HPHS Program           2020   pk_12_total * * 18   0 0     0   0   22 8     11             30   30     18   0 0     0   0   22 8     11       30   30
2778233 2778233 CT     school   640011   Hartford School District   645011 iGOAL 2 - Weaver High School             2020   pk_12_total 0 6 10   0 0     0   0   * *     *             16   16 0 6 10   0 0     0   0                   16   16
2778234 2778234 CT     school   640011   Hartford School District 90192001727 648411 STEP at Hartford Public High School Program           2020   pk_12_total 0 15 19   0 0     0   0   24 10     9             34   34 0 15 19   0 0     0   0   24 10     9       34   34
2778242 2778242 CT     school   690011   Killingly School District 90207000083 698011 Goodyear Early Childhood Center Program           2020   pk_12_total 93 0 11   0 *     0   *   68 49     0             36   117 93 0 11   0       0       68 49     0       36   117
2778247 2778247 CT     school   2450014   Learn   2451514 LEARN Integrated Program at TFS Program           2020   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2778250 2778250 CT     school   2450014   Learn 90345001680 2451114 Learn Intensive Program Program           2020   pk_12_total 12 7 9   0 *     0   *   27 8     *             35   35 12 7 9   0       0       27 8             35   35
2778252 2778252 CT     school   2450014   Learn   2451614 LEARN SAILS Program Program           2020   pk_12_total 12 * *   0 0     0   *   * *     *             18   18 12       0 0     0                       18   18
2778254 2778254 CT     school   2450014   Learn   2451414 LEARN Diagnostic and Wellness Center Program           2020   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2778255 2778255 CT     school   2450014   Learn   2450814 Learn SAILS Middle School Program             2020   pk_12_total * * *   0 0     0   *   * 0     0             *   *         0 0     0         0     0            
2778259 2778259 CT     school   2450014   Learn 90345001757 2450414 LEARN Transition Academy Program           2020   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2778260 2778260 CT     school   2450014   Learn 90345001795 2450614 Learn High School Program           2020   pk_12_total * 0 *   0 *     0   0   * *     0             *   *   0     0       0   0           0            
2778269 2778269 CT     school   720011   Ledyard School District   720511 Ledyard Transition Academy Program           2020   pk_12_total * * 0   0 *     0   0   * *     0             8   8     0   0       0   0           0       8   8
2778275 2778275 CT     school   760011   Madison School District 90228001549 769011 Town Campus Learning Center Program           2020   pk_12_total 40 0 *   0 *     0   *   22 21     0             22   43 40 0     0       0       22 21     0       22   43
2778283 2778283 CT     school   770011   Manchester School District   770811 Manchester Preschool - Site 2 Program           2020   pk_12_total 18 * *   0 11     0   0   24 16     0             23   40 18       0 11     0   0   24 16     0       23   40
2778284 2778284 CT     school   770011   Manchester School District 90231000519 778011 Manchester Preschool Center Program           2020   pk_12_total 37 54 81   0 17     0   7   97 99     0             49   196 37 54 81   0 17     0   7   97 99     0       49   196
2778291 2778291 CT     school   770011   Manchester School District   771511 Manchester Middle Academy Program           2020   pk_12_total 13 16 *   0 0     0   *   28 13     0             28   41 13 16     0 0     0       28 13     0       28   41
2778293 2778293 CT     school   770011   Manchester School District 90231000427 779011 Manchester Regional Academy Program           2020   pk_12_total * 21 26   0 0     0   *   51 15     *             57   66   21 26   0 0     0       51 15             57   66
2778295 2778295 CT     school   770011   Manchester School District 90231001769 770211 Manchester High School-Site 2 Program           2020   pk_12_total 16 10 15   0 0     0   0   25 16     *             20   41 16 10 15   0 0     0   0   25 16             20   41
2778296 2778296 CT     school   770011   Manchester School District 90231001717 770711 New Horizons Program           2020   pk_12_total * 10 8   * 0     0   0   * *     0             8   24   10 8     0     0   0           0       8   24
2778297 2778297 CT     school   770011   Manchester School District 90231001599 779111 Manchester Transition Center Program           2020   pk_12_total 11 7 8   0 0     0   0   17 9     *             26   26 11 7 8   0 0     0   0   17 9             26   26
2778306 2778306 CT     school   800011   Meriden School District   802611 PRIDE Program           2020   pk_12_total 25 * 53   0 *     0   *   64 24     0             88   88 25   53   0       0       64 24     0       88   88
2778312 2778312 CT     school   800011   Meriden School District   802211 SOAR- ES Program           2020   pk_12_total * * *   0 0     0   0   * *     0             *   10         0 0     0   0           0           10
2778313 2778313 CT     school   800011   Meriden School District   800611 STARS - ES Program           2020   pk_12_total 9 * 32   0 0     0   *   38 11     *             49   49 9   32   0 0     0       38 11             49   49
2778314 2778314 CT     school   800011   Meriden School District   800911 STEP - ES Program           2020   pk_12_total 9 * 23   0 0     0   *   36 7     *             43   43 9   23   0 0     0       36 7             43   43
2778316 2778316 CT     school   800011   Meriden School District   802311 SOAR - LMS             2020   pk_12_total * * 9   0 0     0   0   * *     6             12   12     9   0 0     0   0           6       12   12
2778317 2778317 CT     school   800011   Meriden School District   802411 SOAR - WMS Program           2020   pk_12_total * * 9   0 0     0   0   * *     6             22   22     9   0 0     0   0           6       22   22
2778318 2778318 CT     school   800011   Meriden School District   801511 STARS-MS Program           2020   pk_12_total * * *   0 0     0   *   * *     *             10   10         0 0     0                       10   10
2778319 2778319 CT     school   800011   Meriden School District   801211 STEPS - MS Program           2020   pk_12_total 10 * 10   0 0     0   *   * *     *             24   24 10   10   0 0     0                       24   24
2778321 2778321 CT     school   800011   Meriden School District   801311 Venture Academy Program           2020   pk_12_total 20 * 41   0 0     0   *   53 19     8             72   72 20   41   0 0     0       53 19     8       72   72
2778324 2778324 CT     school   800011   Meriden School District   801811 STARS - HS Program           2020   pk_12_total * 0 *   0 *     0   0   8 0     *             8   8   0     0       0   0   8 0             8   8
2778325 2778325 CT     school   800011   Meriden School District   802011 TLC - MHS Program           2020   pk_12_total 9 * 24   0 *     0   0   26 13     11             39   39 9   24   0       0   0   26 13     11       39   39
2778326 2778326 CT     school   800011   Meriden School District   801911 TLC - PHS Program           2020   pk_12_total * * 10   0 *     0   *   11 9     *             20   20     10   0       0       11 9             20   20
2778327 2778327 CT     school   800011   Meriden School District   801611 TSC - MHS Program           2020   pk_12_total * * 8   0 0     0   *   * *     *             14   14     8   0 0     0                       14   14
2778328 2778328 CT     school   800011   Meriden School District   801711 TSC - PHS Program           2020   pk_12_total * * 16   * 0     0   0   * *     *             22   22     16     0     0   0                   22   22
2778329 2778329 CT     school   800011   Meriden School District   802511 SOAR - PHS Program           2020   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2778330 2778330 CT     school   800011   Meriden School District   801411 Success Academy Program           2020   pk_12_total * * 22   0 0     0   *   10 18     6             *   28     22   0 0     0       10 18     6           28
2778331 2778331 CT     school   800011   Meriden School District 90240001800 800211 Community Classroom Collaborative Program           2020   pk_12_total * * 6   0 0     0   0   * *     *             11   11     6   0 0     0   0                   11   11
2778332 2778332 CT     school   800011   Meriden School District   802111 Community Collaborative Classroom - ACADEMY Program           2020   pk_12_total 6 * *   * 0     0   0   * *     *             14   14 6         0     0   0                   14   14
2778341 2778341 CT     school   830011   Middletown School District 90249001758 830611 ICM - Farm Hill Program           2020   pk_12_total * * *   0 0     0   0   * *     0             6   6         0 0     0   0           0       6   6
2778342 2778342 CT     school   830011   Middletown School District 90249001719 830811 ICM - Moody K-2 Program           2020   pk_12_total 0 * *   0 0     0   0   * *     0             *   * 0       0 0     0   0           0            
2778343 2778343 CT     school   830011   Middletown School District 90249001652 830711 ICM - Moody 3-5 Program           2020   pk_12_total * * *   0 0     0   0   * *     0             *   *         0 0     0   0           0            
2778344 2778344 CT     school   830011   Middletown School District   832011 ICM - Spencer Program           2020   pk_12_total * * *   0 0     0   *   7 0     0             7   7         0 0     0       7 0     0       7   7
2778345 2778345 CT     school   830011   Middletown School District 90249001793 830411 ICM- Woodrow Wilson Middle School Program           2020   pk_12_total * 0 *   0 0     0   *   * *     0             8   8   0     0 0     0               0       8   8
2778348 2778348 CT     school   830011   Middletown School District 90249001722 831811 MHS - Alternative Education Program 1 Program           2020   pk_12_total * * *   0 0     0   *   * *     0             *   10         0 0     0               0           10

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