enrollments

Data source: Big Local News · About: Big Local

20,454 rows where state = "CT" and year = 2020 sorted by white_int

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2020 · 20,254 ✖
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
2778880 2778880 CT     school   1460011   Vernon School District   1460811 Renaissance Program Program           2020   pk_12_total * * *   0 0     0   *   * *     0             11   11         0 0     0               0       11   11
2778890 2778890 CT     school   1480011   Wallingford School District   1481611 WISE Primary Program Program           2020   pk_12_total * 0 *   0 0     0   *   * *     *             9   9   0     0 0     0                       9   9
2778891 2778891 CT     school   1480011   Wallingford School District   1481411 Ben Haven ABC Primary Program             2020   pk_12_total * 0 0   0 *     0   0   * *     *             *   *   0 0   0       0   0                        
2778892 2778892 CT     school   1480011   Wallingford School District   1480611 Benhaven ABC Intermediate Program Program           2020   pk_12_total * 0 *   0 0     0   0   * *     *             *   *   0     0 0     0   0                        
2778897 2778897 CT     school   1480011   Wallingford School District   1481111 STARS Intermediate Program Program           2020   pk_12_total * 0 0   0 *     0   0   * *     *             6   6   0 0   0       0   0                   6   6
2778898 2778898 CT     school   1480011   Wallingford School District 90474001595 1489211 WISE Intermediate Program Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             8   8   0     0 0     0   0           0       8   8
2778900 2778900 CT     school   1480011   Wallingford School District   1481511 Ben Haven ABC Middle School Program Program           2020   pk_12_total * 0 *   0 0     0   0   * *     *             *   *   0     0 0     0   0                        
2778908 2778908 CT     school   1480011   Wallingford School District 90474001594 1489111 Wallingford Transition Academy Program           2020   pk_12_total * 0 0   0 *     0   0   * *     *             6   6   0 0   0       0   0                   6   6
2778918 2778918 CT     school   1510011   Waterbury School District   1519811 Maloney Prek Program           2020   pk_12_total * * *   0 0     0   0   * *     0             8   8         0 0     0   0           0       8   8
2778933 2778933 CT     school   1510011   Waterbury School District   1513511 Generali Autism Program           2020   pk_12_total * 12 17   0 *     0   *   27 6     *             33   33   12 17   0       0       27 6             33   33
2778934 2778934 CT     school   1510011   Waterbury School District   1516911 Gilmartin Scope Program           2020   pk_12_total * * 13   0 0     0   0   10 8     7             *   18     13   0 0     0   0   10 8     7           18
2778938 2778938 CT     school   1510011   Waterbury School District   1512411 Reed ESC Program           2020   pk_12_total * 6 17   0 0     0   *   18 8     *             26   26   6 17   0 0     0       18 8             26   26
2778942 2778942 CT     school   1510011   Waterbury School District   1511211 Woodrow Wilson BDLC Program           2020   pk_12_total * * 15   0 0     0   *   * *     *             *   21     15   0 0     0                           21
2778944 2778944 CT     school   1510011   Waterbury School District   1510111 Bunker Hill BDLC Program           2020   pk_12_total * * 13   0 0     0   0   * *     *             23   23     13   0 0     0   0                   23   23
2778948 2778948 CT     school   1510011   Waterbury School District   1512911 North End Autism Program           2020   pk_12_total * * 8   0 *     0   *   * *     0             18   18     8   0       0               0       18   18
2778949 2778949 CT     school   1510011   Waterbury School District   1513711 North End BDLC Program           2020   pk_12_total * * 16   0 0     0   0   * *     *             30   30     16   0 0     0   0                   30   30
2778951 2778951 CT     school   1510011   Waterbury School District   1511811 North End ESC Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             10   10   0     0 0     0   0           0       10   10
2778953 2778953 CT     school   1510011   Waterbury School District   1514811 North End SCOPE Program           2020   pk_12_total * * 6   0 0     0   *   6 6     *             12   12     6   0 0     0       6 6             12   12
2778954 2778954 CT     school   1510011   Waterbury School District   1514411 Wallace BDLC Program           2020   pk_12_total * * 8   0 0     0   0   * *     *             11   11     8   0 0     0   0                   11   11
2778956 2778956 CT     school   1510011   Waterbury School District   1514911 Wallace SCOPE Program           2020   pk_12_total * * 6   0 0     0   0   * *     *             11   11     6   0 0     0   0                   11   11
2778958 2778958 CT     school   1510011   Waterbury School District   1514711 West Side BDLC Program           2020   pk_12_total * 6 10   0 0     0   *   * *     *             19   19   6 10   0 0     0                       19   19
2778959 2778959 CT     school   1510011   Waterbury School District   1515611 West Side Bilingual Program           2020   pk_12_total * 0 *   0 0     0   0   40 34     *             10   74   0     0 0     0   0   40 34             10   74
2778960 2778960 CT     school   1510011   Waterbury School District   1515511 West Side SCOPE Program           2020   pk_12_total * * *   0 0     0   0   * *     *             11   11         0 0     0   0                   11   11
2778964 2778964 CT     school   1510011   Waterbury School District   1514511 Wilby Autism Program           2020   pk_12_total * * 7   0 0     0   0   * *     *             15   15     7   0 0     0   0                   15   15
2778965 2778965 CT     school   1510011   Waterbury School District   1511711 Wilby ESC Program           2020   pk_12_total * * 7   0 0     0   0   * *     0             14   14     7   0 0     0   0           0       14   14
2778967 2778967 CT     school   1510011   Waterbury School District   1517111 School to Work Transition Academy Program           2020   pk_12_total * 7 6   0 *     0   0   * *     *             15   15   7 6   0       0   0                   15   15
2778976 2778976 CT     school   1520011   Waterford School District   1520311 Avery Point Transition Program Program           2020   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2778982 2778982 CT     school   1530011   Watertown School District   1530811 Watertown Transition Academy Program           2020   pk_12_total * 0 0   0 *     0   0   * 0     0             *   *   0 0   0       0   0     0     0            
2778988 2778988 CT     school   1550011   West Hartford School District 90492001705 1559311 Braeburn Learning Center Program           2020   pk_12_total * * *   0 0     0   *   * *     *             11   11         0 0     0                       11   11
2778992 2778992 CT     school   1550011   West Hartford School District   1559711 Morley Learning Center Program           2020   pk_12_total * 0 0   0 0     0   *   * 0     0             *   *   0 0   0 0     0         0     0            
2778994 2778994 CT     school   1550011   West Hartford School District 90492001681 1559411 Norfeldt Learning Center Program           2020   pk_12_total * * 0   0 *     0   0   * *     0             7   7     0   0       0   0           0       7   7
2778998 2778998 CT     school   1550011   West Hartford School District 90492001790 1559611 Wolcott Learning Center Program           2020   pk_12_total * * *   0 0     0   0   * *     *             7   7         0 0     0   0                   7   7
2779014 2779014 CT     school   1560011   West Haven School District 90495001799 1560111 Life Skills Program           2020   pk_12_total * * *   0 0     0   0   * *     *             10   10         0 0     0   0                   10   10
2779015 2779015 CT     school   1560011   West Haven School District   1561111 ASD Lab             2020   pk_12_total * 0 *   0 *     0   0   * *     0             *   *   0     0       0   0           0            
2779019 2779019 CT     school   1560011   West Haven School District   1560511 Blended (Molloy) Program           2020   pk_12_total * 0 *   0 0     0   0   0 6     0             *   6   0     0 0     0   0   0 6     0           6
2779037 2779037 CT     school   1580011   Westport School District   1580111 LLS Intensive Resource Program           2020   pk_12_total * 0 *   0 *     0   0   * 0     0             *   *   0     0       0   0     0     0            
2779040 2779040 CT     school   1590011   Wethersfield School District   1590411 ABA Program           2020   pk_12_total * * 10   0 *     0   *   8 8     *             16   16     10   0       0       8 8             16   16
2779046 2779046 CT     school   1590011   Wethersfield School District   1590311 STRIVE Program           2020   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2779049 2779049 CT     school   1590011   Wethersfield School District   1590111 Wethersfield Transition Academy Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             6   6   0     0 0     0   0           0       6   6
2779055 2779055 CT     school   1610011   Wilton School District   1610211 Genesis Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             *   10   0     0 0     0   0           0           10
2779057 2779057 CT     school   1610011   Wilton School District   1610311 Community Steps Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             7   7   0     0 0     0   0           0       7   7
2779060 2779060 CT     school   1630011   Windham School District 90519000307 1638011 Early Headstart Program           2020   pk_12_total * 0 26   0 *     0   0   16 15     0             0   31   0 26   0       0   0   16 15     0       0   31
2779065 2779065 CT     school   1630011   Windham School District   1631111 Sweeney ASD Program Program           2020   pk_12_total * 0 13   0 0     0   *   * *     *             16   16   0 13   0 0     0                       16   16
2779068 2779068 CT     school   1630011   Windham School District   1630911 Sweeney Medically Fragile Program Program           2020   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2779069 2779069 CT     school   1630011   Windham School District   1630711 Natchaug Emotional Disturbance Program Program           2020   pk_12_total * * *   0 0     0   0   * 0     *             *   *         0 0     0   0     0                  
2779072 2779072 CT     school   1630011   Windham School District   1631211 Assisted Work Program Program           2020   pk_12_total * 0 *   0 0     0   0   * *     6             12   12   0     0 0     0   0           6       12   12
2779073 2779073 CT     school   1630011   Windham School District   1631411 Assisted Work Program at WHS Program           2020   pk_12_total * 0 *   0 0     0   0   * *     *             *   *   0     0 0     0   0                        
2779086 2779086 CT     school   1640011   Windsor School District   1640311 Spark Program           2020   pk_12_total * 7 *   0 0     0   *   * *     0             12   12   7     0 0     0               0       12   12
2779088 2779088 CT     school   1640011   Windsor School District   1640211 Community Based Transition Academy Program           2020   pk_12_total * 12 *   0 0     0   0   11 10     *             21   21   12     0 0     0   0   11 10             21   21
2779090 2779090 CT     school   1660011   Wolcott School District 90528001783 1660311 ABC Classroom Program           2020   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2779094 2779094 CT     school   1660011   Wolcott School District 90528001772 1660411 Phoenix Program Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             9   9   0     0 0     0   0           0       9   9
2779100 2779100 CT     school 900212 2880013   Achievement First Hartford Academy District 90021201528 2880113 Achievement First Hartford Academy Public Charter Schools Regular School Yes Other KG 12 2020   pk_12_total * 842 299   6 *     *   15   553 616     70             117   1169   842 299   6           15   553 616     70       117   1169
2779101 2779101 CT     school 900024 2790013   Amistad Academy District 90002400981 2795113 Amistad Academy Public Charter Schools Regular School Yes Other KG 12 2020   pk_12_total * 684 381   * 0     0   20   498 605     111             80   1103   684 381     0     0   20   498 605     111       80   1103
2779102 2779102 CT     school 900217 2950013   Booker T. Washington Academy District 90021701750 2950113 Booker T. Washington Academy Public Charter Schools Regular School Yes Elementary KG 06 2020   pk_12_total * 354 55   0 *     0   6   212 208     26             29   420   354 55   0       0   6   212 208     26       29   420
2779104 2779104 CT     school 900221 2970013   Capital Preparatory Harbor School District 90022101803 2970113 Capital Preparatory Harbor School Public Charter Schools Regular School Yes Other KG 12 2020   pk_12_total * 539 211   0 0     0   *   387 373     50             77   760   539 211   0 0     0       387 373     50       77   760
2779113 2779113 CT     school 901360 2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN) 90136001937 2530314 LEAP Alternative High School Regional Education Service Center Schools Alternative School No High 10 12 2020   pk_12_total * 0 8   0 0     0   *   * *     *             *   11   0 8   0 0     0                           11
2779114 2779114 CT     school   2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN)   2530114 Regional Transitional Services Program           2020   pk_12_total * * 0   0 0     0   0   * *     0             11   11     0   0 0     0   0           0       11   11
2779117 2779117 CT     school   2010012   Regional School District 01   2010312 SELC Program           2020   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2779122 2779122 CT     school   3470015   Unified School District #2 90000400475 3470115 Children's Place School State Agency Facilities           2020   pk_12_total * * 11   0 0     0   0   22 0     *             *   22     11   0 0     0   0   22 0                 22
2779126 2779126 CT     school   2040012   Regional School District 04   2040112 Region 4 Transition Academy Program           2020   pk_12_total * * 0   0 0     0   0   * *     0             7   7     0   0 0     0   0           0       7   7
2779130 2779130 CT     school   2050012   Regional School District 05   2050112 Amity Transition Academy Program           2020   pk_12_total * 0 0   0 *     0   0   * *     0             8   8   0 0   0       0   0           0       8   8
2779131 2779131 CT     school   2070012   Regional School District 07 90372001401 2079212 Links Program           2020   pk_12_total * 0 0   0 0     0   *   16 8     0             24   24   0 0   0 0     0       16 8     0       24   24
2779133 2779133 CT     school   2070012   Regional School District 07 90372001399 2079012 FLEX Program           2020   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2779136 2779136 CT     school   2070012   Regional School District 07 90372001402 2079312 STEP Program           2020   pk_12_total * 0 0   0 *     0   0   * *     0             6   16   0 0   0       0   0           0       6   16
2779137 2779137 CT     school   2070012   Regional School District 07   2070112 Highlander Transition Academy Program           2020   pk_12_total * 0 *   0 0     0   0   6 9     0             15   15   0     0 0     0   0   6 9     0       15   15
2779141 2779141 CT     school 900015 2690013   The Bridge Academy District 90001500809 2696113 The Bridge Academy Public Charter Schools Regular School Yes High 07 12 2020   pk_12_total * 129 122   0 *     24   0   144 137     12             60   281   129 122   0       24   0   144 137     12       60   281
2779144 2779144 CT     school   3360015   Unified School District #1 90000300844 3362415 Corrigan/Radgowski Correctional Institution State Agency Facilities           2020   pk_12_total * * *   0 0     0   0   7 0     *             7   7         0 0     0   0   7 0             7   7
2779145 2779145 CT     school   3360015   Unified School District #1 90000300849 3362515 York Correctional Institution State Agency Facilities           2020   pk_12_total * 6 *   0 0     0   0   0 9     0             9   9   6     0 0     0   0   0 9     0       9   9
2779155 2779155 CT     school 900014 2680013   Common Ground High School District 90001400807 2686113 Common Ground High School Public Charter Schools Regular School Yes High 09 12 2020   pk_12_total * 84 90   0 0     0   *   131 *     11             55   223   84 90   0 0     0       131       11       55   223
2779175 2779175 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010322 Alternative Pathways to Success Program Regular School No High 09 12 2020   pk_12_total * * 0   0 0     0   0   * *     0             *   11     0   0 0     0   0           0           11
2779176 2779176 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010222 Night School Program Regular School No High 09 12 2020   pk_12_total * * *   0 0     *   *   7 7     0             *   14         0 0             7 7     0           14
2779183 2779183 CT     school   3370015   Department of Mental Health and Addiction Services 90002701539 3370215 Connecticut Valley Hospital State Agency Facilities           2020   pk_12_total * * *   0 0     0   0   * *     0             *   *         0 0     0   0           0            
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
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            
2777776 2777776 CT     school 900330 110011   Bloomfield School District 90033001619 116411 Learning Academy at Bloomfield   Alternative School No High 11 12 2020   pk_12_total 0 9 0   0 0     0   0   * *     0             *   9 0 9 0   0 0     0   0           0           9
2777819 2777819 CT     school   150011   Bridgeport School District 90045001472 159011 Bridgeport Learning Center Program           2020   pk_12_total 0 44 *   0 *     0   0   67 9     7             *   76 0 44     0       0   0   67 9     7           76
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
2777843 2777843 CT     school   170011   Bristol School District 90051001646 172111 Hubbell/Extended Resource Program           2020   pk_12_total 0 0 *   0 *     0   0   * *     0             *   * 0 0     0       0   0           0            
2777844 2777844 CT     school   170011   Bristol School District 90051001726 172511 Mt. View GOAL Program           2020   pk_12_total 0 * *   0 0     0   0   * *     0             *   * 0       0 0     0   0           0            
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            
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            
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                  
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
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
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
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
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
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
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
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            
2778352 2778352 CT     school   830011   Middletown School District 90249001768 831911 MHS - Alternative Education Program 2 Program           2020   pk_12_total 0 * *   0 0     0   *   * *     *             *   9 0       0 0     0                           9
2778410 2778410 CT     school   890011   New Britain School District   891911 Smith Pathways Program           2020   pk_12_total 0 * 13   0 *     0   *   9 7     *             16   16 0   13   0       0       9 7             16   16

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