enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
2777922 2777922 CT     school   280011   Colchester School District   280511 Bacon Academy Alternative Education Program           2020   pk_12_total 9 0 0   0 0     0   0   6 *     0             *   9 9 0 0   0 0     0   0   6       0           9
2777923 2777923 CT     school   280011   Colchester School District   280711 Community Transition Academy of Colchester Program           2020   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2777925 2777925 CT     school   2430014   Cooperative Educational Services 90091001561 2439114 Preschool-Primary Learning Center (PLC) Program           2020   pk_12_total 16 12 16   0 *     *   *   42 9     0             51   51 16 12 16   0               42 9     0       51   51
2777926 2777926 CT     school   2430014   Cooperative Educational Services 90091001520 2438014 School Readiness Program           2020   pk_12_total * 31 53   0 0     0   *   40 47     0             *   87   31 53   0 0     0       40 47     0           87
2777928 2777928 CT     school   2430014   Cooperative Educational Services   2430314 Eastern Fairfield County Diagnostic Center Program           2020   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2777929 2777929 CT     school   2430014   Cooperative Educational Services 90091001573 2439414 Therapeutic Day Program Program           2020   pk_12_total 80 25 40   0 *     0   *   122 33     *             155   155 80 25 40   0       0       122 33             155   155
2777930 2777930 CT     school   2430014   Cooperative Educational Services 90091001554 2439214 Developmental Learning Center (DLC) Program           2020   pk_12_total 16 18 20   0 *     0   *   41 18     *             59   59 16 18 20   0       0       41 18             59   59
2777931 2777931 CT     school   2430014   Cooperative Educational Services 90091001555 2439314 RISE Transitional Program Program           2020   pk_12_total 8 0 *   0 0     0   *   * *     0             12   12 8 0     0 0     0               0       12   12
2777932 2777932 CT     school   2430014   Cooperative Educational Services   2430214 Transition Learning Center Program           2020   pk_12_total 18 * 7   0 *     0   *   27 6     *             33   33 18   7   0       0       27 6             33   33
2777933 2777933 CT     school   320011   Coventry School District   320311 Hale Early Education Center Program           2020   pk_12_total 83 0 6   0 *     0   *   38 58     0             20   96 83 0 6   0       0       38 58     0       20   96
2777960 2777960 CT     school   340011   Danbury School District 90102001129 346211 Alternative Center For Excellence Program           2020   pk_12_total 29 9 39   0 *     0   *   37 48     *             20   85 29 9 39   0       0       37 48             20   85
2777962 2777962 CT     school   340011   Danbury School District   340711 Western Connection Program           2020   pk_12_total * * 0   0 0     0   0   * *     0             11   11     0   0 0     0   0           0       11   11
2777974 2777974 CT     school   370011   Derby School District   370511 RAISE Academy Program           2020   pk_12_total 8 * *   0 0     0   *   * *     0             9   17 8       0 0     0               0       9   17
2777975 2777975 CT     school   370011   Derby School District   370211 Alternative Education Program Program           2020   pk_12_total 0 0 0   0 0     0   *   * 0     0             *   * 0 0 0   0 0     0         0     0            
2777988 2777988 CT     school   420011   East Hampton School District 90123001514 429011 The Learning Center at East Hampton Program           2020   pk_12_total 8 0 0   0 0     0   0   * *     0             *   8 8 0 0   0 0     0   0           0           8
2777989 2777989 CT     school   430011   East Hartford School District   430211 Early Childhood Learning Center at Hockanum School Program           2020   pk_12_total 42 95 162   0 15     *   *   176 145     0             86   321 42 95 162   0 15             176 145     0       86   321
2777998 2777998 CT     school   430011   East Hartford School District 90126000205 439011 Woodland School Program           2020   pk_12_total 27 67 98   * *     0   11   166 40     24             *   206 27 67 98           0   11   166 40     24           206
2778003 2778003 CT     school   430011   East Hartford School District 90126001377 436411 Synergy Alternative Program Program           2020   pk_12_total * 27 63   0 0     0   *   68 33     12             30   101   27 63   0 0     0       68 33     12       30   101
2778012 2778012 CT     school   450011   East Lyme School District 90132001450 458011 Integrated Preschool Program           2020   pk_12_total 47 * *   0 *     0   0   24 26     0             24   50 47       0       0   0   24 26     0       24   50
2778017 2778017 CT     school   450011   East Lyme School District 90132001760 450611 Coastal Connections Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             *   16   0     0 0     0   0           0           16
2778019 2778019 CT     school   450011   East Lyme School District 90132001730 450511 Abilities in Motion (AIM) Program Program           2020   pk_12_total * * 0   0 0     0   0   * *     *             10   10     0   0 0     0   0                   10   10
2778023 2778023 CT     school   470011   East Windsor School District   470411 East Windsor Transition Program Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             8   8   0     0 0     0   0           0       8   8
2778027 2778027 CT     school   2420014   EdAdvance 90351200575 2428014 EdAdvance Headstart Program           2020   pk_12_total 100 8 61   * 8     *   7   88 104     0             *   192 100 8 61     8         7   88 104     0           192
2778028 2778028 CT     school   2420014   EdAdvance 90351201476 2429014 The ACCESS School at The Danuta M. Thibodeau Education Center Program           2020   pk_12_total 14 * 7   * *     0   0   25 0     0             25   25 14   7           0   0   25 0     0       25   25
2778029 2778029 CT     school   2420014   EdAdvance   2420114 Steps Program           2020   pk_12_total 16 * 7   * 0     0   0   * *     *             29   29 16   7     0     0   0                   29   29
2778030 2778030 CT     school   2420014   EdAdvance   2420314 Steps-North Expelled Student Program           2020   pk_12_total 0 0 *   0 0     0   0   * 0     *             *   * 0 0     0 0     0   0     0                  
2778031 2778031 CT     school   2420014   EdAdvance   2420414 ACCESS-South Expelled Student Program           2020   pk_12_total * 0 0   0 0     0   0   * 0     0             0   *   0 0   0 0     0   0     0     0       0    
2778032 2778032 CT     school   2420014   EdAdvance   2420514 University Pathways Program Program           2020   pk_12_total 9 * *   0 0     0   0   9 6     0             15   15 9       0 0     0   0   9 6     0       15   15
2778038 2778038 CT     school   480011   Ellington School District   480511 The Ellington Public Schools Expulsion Program (TEPSEP) Program           2020   pk_12_total * 0 0   0 0     0   *   * 0     0             *   *   0 0   0 0     0         0     0            
2778039 2778039 CT     school   480011   Ellington School District   480411 Ellington Continuing Life Independence Post-Secondary Education (ECLIPSE) Program           2020   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2778041 2778041 CT     school   490011   Enfield School District 90147001915 492211 EPS Integrated Pre-Kindergarten Program           2020   pk_12_total 59 * 11   0 *     0   *   49 31     0             49   80 59   11   0       0       49 31     0       49   80
2778042 2778042 CT     school   490011   Enfield School District 90147001810 491011 EPS PK STEAM Academy Program           2020   pk_12_total 31 10 16   0 *     0   *   43 24     0             *   67 31 10 16   0       0       43 24     0           67
2778043 2778043 CT     school   490011   Enfield School District 90147000207 498011 Head Start Program Program           2020   pk_12_total 59 * 29   0 *     0   9   55 47     0             10   102 59   29   0       0   9   55 47     0       10   102
2778046 2778046 CT     school   490011   Enfield School District 90147001792 490311 Henry Barnard - Autism Spectrum Disorder (ASD) Program           2020   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2778047 2778047 CT     school   490011   Enfield School District 90147001743 490811 Henry Barnard - Primary Adaptive Learning (PAL) Program           2020   pk_12_total * * *   0 0     0   *   * *     0             *   *         0 0     0               0            
2778050 2778050 CT     school   490011   Enfield School District 90147001696 490611 Henry Barnard - Educational Counseling Program (ECP) Program           2020   pk_12_total * * *   0 0     0   *   * 0     0             *   *         0 0     0         0     0            
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
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                  
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
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
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
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            
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

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