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_nces_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 1,461 ✖

grade ✖

  • pk_12_total · 1,461 ✖
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
2777726 2777726 CT     school   20011   Ansonia School District   20911 Ansonia Public Schools Pre-K Program Program           2020   pk_12_total 32 16 41   0 *     0   *   58 35     0             30   93 32 16 41   0       0       58 35     0       30   93
2777732 2777732 CT     school   20011   Ansonia School District   20411 P.A.C.E. - PM (Positive And Creative Education - PM) Program           2020   pk_12_total 0 * *   0 0     0   0   * *     0             *   8 0       0 0     0   0           0           8
2777733 2777733 CT     school   20011   Ansonia School District   21011 Ansonia 18-21 Transition Program Program           2020   pk_12_total * 0 *   0 0     0   *   * *     *             7   7   0     0 0     0                       7   7
2777735 2777735 CT     school   2440014   Area Cooperative Educational Services   2440214 ACES Mill Elementary School Program           2020   pk_12_total * 44 22   0 0     0   *   71 15     *             *   86   44 22   0 0     0       71 15                 86
2777737 2777737 CT     school   2440014   Area Cooperative Educational Services   2440414 ACES at Mead Elementary School Program           2020   pk_12_total 0 * *   0 0     0   *   * *     0             *   * 0       0 0     0               0            
2777743 2777743 CT     school   2440014   Area Cooperative Educational Services   2440114 CREATE at Whitney Academy Program           2020   pk_12_total 20 16 21   0 *     0   *   41 19     *             60   60 20 16 21   0       0       41 19             60   60
2777753 2777753 CT     school   50011   Barkhamsted School District   50211 Bridges at Barkhamsted Elementary School Program           2020   pk_12_total * 0 0   0 0     0   *   * *     0             *   *   0 0   0 0     0               0            
2777759 2777759 CT     school   70011   Berlin School District   70311 Transition Academy Program           2020   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2777766 2777766 CT     school   90011   Bethel School District   90311 TASK Program           2020   pk_12_total 6 0 *   0 *     0   *   * *     *             *   12 6 0     0       0                           12
2777767 2777767 CT     school   90011   Bethel School District   90211 Community Partnership Program Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             6   6   0     0 0     0   0           0       6   6
2777770 2777770 CT     school   110011   Bloomfield School District   110111 Steps to Success Program           2020   pk_12_total * 9 *   0 0     0   0   11 0     0             11   11   9     0 0     0   0   11 0     0       11   11
2777779 2777779 CT     school   120011   Bolton School District   120211 Bolton Transition Program Program           2020   pk_12_total * 0 0   0 0     0   0   0 *     0             *   *   0 0   0 0     0   0   0       0            
2777788 2777788 CT     school   140011   Branford School District   140311 Access Transition Program Program           2020   pk_12_total * 0 0   0 *     0   0   * *     *             15   15   0 0   0       0   0                   15   15
2777827 2777827 CT     school   150011   Bridgeport School District   152811 The Transition Academy Program           2020   pk_12_total 0 16 *   0 *     0   0   22 6     *             28   28 0 16     0       0   0   22 6             28   28
2777836 2777836 CT     school   170011   Bristol School District   173811 Greene Hills Extended Resource Program           2020   pk_12_total * 0 *   0 *     0   0   * *     *             6   6   0     0       0   0                   6   6
2777838 2777838 CT     school   170011   Bristol School District   172411 Mt. View Extended Resource Program           2020   pk_12_total * * *   0 0     0   0   * *     *             *   *         0 0     0   0                        
2777847 2777847 CT     school   170011   Bristol School District   173711 Hubbell Autism Program Program           2020   pk_12_total * * *   0 *     0   0   * *     *             9   9         0       0   0                   9   9
2777849 2777849 CT     school   170011   Bristol School District   173611 West bristol Extended Resource Program           2020   pk_12_total 0 0 *   0 0     0   0   * 0     0             *   * 0 0     0 0     0   0     0     0            
2777852 2777852 CT     school   170011   Bristol School District   171611 Chippens Hill Middle School Medically Fragile Program           2020   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2777853 2777853 CT     school   170011   Bristol School District   170811 Chippens Hilll Middle School Extended Resource Program           2020   pk_12_total * 0 8   0 *     0   0   7 7     *             14   14   0 8   0       0   0   7 7             14   14
2777862 2777862 CT     school   170011   Bristol School District   170211 ACCESS Program           2020   pk_12_total * * *   0 0     0   *   * *     0             10   10         0 0     0               0       10   10
2777885 2777885 CT     school   2410014   Capitol Region Education Council   2411414 River Street School Early Learning Center Program           2020   pk_12_total * * *   0 0     0   0   * *     0             0   9         0 0     0   0           0       0   9
2777897 2777897 CT     school   2410014   Capitol Region Education Council   2411914 CREC Impact Academy Program           2020   pk_12_total * 14 21   0 0     0   *   29 9     *             *   38   14 21   0 0     0       29 9                 38
2777900 2777900 CT     school   2410014   Capitol Region Education Council   2419414 IPM @ Plainville High School             2020   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2777906 2777906 CT     school   250011   Cheshire School District   250711 Highland School Autism Program Program           2020   pk_12_total 12 * *   0 *     0   0   * *     0             17   17 12       0       0   0           0       17   17
2777908 2777908 CT     school   250011   Cheshire School District   251111 Doolittle Bridges Program Program           2020   pk_12_total * * *   0 0     0   0   * 0     0             *   *         0 0     0   0     0     0            
2777914 2777914 CT     school   250011   Cheshire School District   251011 QU College Life Program           2020   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
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            
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            
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
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            
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
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
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            
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
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            
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
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
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
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
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
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
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
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
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
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
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
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
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            
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            
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
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
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
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

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