enrollments

Data source: Big Local News · About: Big Local

20,454 rows where state = "CT" and year = 2020 sorted by male_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
2778825 2778825 CT     school   1380011   Stratford School District 90444001756 1381811 Middle School Sails Program           2020   pk_12_total * * *   * 0     0   0   * *     *             9   9           0     0   0                   9   9
2778828 2778828 CT     school   1380011   Stratford School District   1380111 BRIDGES 9-12 Program           2020   pk_12_total * 0 *   0 0     0   0   * *     *             10   10   0     0 0     0   0                   10   10
2778831 2778831 CT     school   1380011   Stratford School District 90444001710 1382011 STEPS 9-12 Program           2020   pk_12_total * * *   0 0     0   0   * *     0             10   10         0 0     0   0           0       10   10
2778840 2778840 CT     school   1400011   Thomaston School District   1400311 PATHS Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             9   17   0     0 0     0   0           0       9   17
2778849 2778849 CT     school   1420011   Tolland School District 90456001738 1420311 TALC Program           2020   pk_12_total 6 0 0   0 0     0   0   * *     0             0   6 6 0 0   0 0     0   0           0       0   6
2778850 2778850 CT     school   1420011   Tolland School District   1420611 Tolland Transition Academy Program           2020   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2778859 2778859 CT     school   1430011   Torrington School District   1430311 Post Secondary Transition Services Program           2020   pk_12_total * * *   0 0     0   0   * *     0             7   7         0 0     0   0           0       7   7
2778871 2778871 CT     school   1440011   Trumbull School District 90462001669 1440211 Trumbull Alternative School Program           2020   pk_12_total 15 0 *   0 *     0   0   * *     0             0   18 15 0     0       0   0           0       0   18
2778872 2778872 CT     school   1440011   Trumbull School District   1440611 Educating Learners in Transitional Environments (ELITE) Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             11   11   0     0 0     0   0           0       11   11
2778878 2778878 CT     school   1460011   Vernon School District   1461111 Elementary Activities Based Learning Program Program           2020   pk_12_total * * *   0 *     0   *   * *     0             13   13         0       0               0       13   13
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
2778889 2778889 CT     school   1480011   Wallingford School District   1480711 STARS Primary Program Program           2020   pk_12_total 9 0 *   0 *     0   0   * *     *             13   13 9 0     0       0   0                   13   13
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
2778899 2778899 CT     school   1480011   Wallingford School District   1489011 A.R.T.S. Academy             2020   pk_12_total 12 * *   0 0     0   0   * *     0             16   16 12       0 0     0   0           0       16   16
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                        
2778903 2778903 CT     school   1480011   Wallingford School District   1481311 Inspire Middle School Program           2020   pk_12_total 6 0 *   0 *     0   0   * *     *             8   8 6 0     0       0   0                   8   8
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
2778941 2778941 CT     school   1510011   Waterbury School District   1510411 B.W. Tinker BDLC             2020   pk_12_total 0 * 6   0 0     0   *   * *     0             11   11 0   6   0 0     0               0       11   11
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
2778943 2778943 CT     school   1510011   Waterbury School District   1517211 Hearing Lab Program           2020   pk_12_total 0 0 *   * 0     0   0   * 0     0             *   * 0 0       0     0   0     0     0            
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
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
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
2778970 2778970 CT     school   1520011   Waterford School District   1521111 Autism Class Program           2020   pk_12_total 6 0 0   0 0     0   0   * *     0             6   6 6 0 0   0 0     0   0           0       6   6
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
2778996 2778996 CT     school   1550011   West Hartford School District 90492001780 1559511 Whiting Lane Learning Center Program           2020   pk_12_total 9 * *   0 *     0   0   * *     *             17   17 9       0       0   0                   17   17
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
2779006 2779006 CT     school   1550011   West Hartford School District   1550111 Alternative Educational Program Program           2020   pk_12_total 0 0 *   0 0     0   0   * 0     0             0   * 0 0     0 0     0   0     0     0       0    
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            
2779018 2779018 CT     school   1560011   West Haven School District   1560711 Blended Program           2020   pk_12_total 6 * *   0 0     0   0   * *     0             *   11 6       0 0     0   0           0           11
2779032 2779032 CT     school   1580011   Westport School District   1580211 GFS Intensive Resource Program           2020   pk_12_total 7 0 *   0 *     0   0   * *     0             11   11 7 0     0       0   0           0       11   11
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            
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
2779058 2779058 CT     school 905160 1620011   Winchester School District 90516001077 1620411 Batcheller Early Education Center Public Schools Regular School No Elementary PK 02 2020   pk_12_total 221 * 17   0 *     *   6   * 128     13             41   254 221   17   0           6     128     13       41   254
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                        
2779085 2779085 CT     school   1640011   Windsor School District   1640411 Expulsion Program           2020   pk_12_total 0 * 0   0 0     0   0   * 0     0             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
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
2779110 2779110 CT     school 901360 2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN) 90136001507 2536014 Arts at the Capitol Theater Magnet School (ACT) Regional Education Service Center Schools Regular School No High 09 12 2020   pk_12_total 90 9 40   0 0     0   11   * 102     *             27   150 90 9 40   0 0     0   11     102             27   150
2779112 2779112 CT     school   2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN)   2530214 Woodstock Academy Consortium Classroom Program           2020   pk_12_total 10 0 0   0 *     0   *   * *     0             12   12 10 0 0   0       0               0       12   12
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            
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
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
2779146 2779146 CT     school   3360015   Unified School District #1 90000300343 3360115 Bridgeport Correctional Center State Agency Facilities           2020   pk_12_total 0 0 *   0 0     0   0   * 0     0             *   * 0 0     0 0     0   0     0     0            
2779149 2779149 CT     school   3360015   Unified School District #1 90000301349 3362615 Northern Correctional Institution State Agency Facilities           2020   pk_12_total 0 * 0   0 0     0   0   * 0     0             *   * 0   0   0 0     0   0     0     0            
2779150 2779150 CT     school   3360015   Unified School District #1 90000300454 3361915 Garner Correctional Institution State Agency Facilities           2020   pk_12_total 0 * 0   0 0     0   0   * 0     0             *   * 0   0   0 0     0   0     0     0            
2779151 2779151 CT     school   3360015   Unified School District #1 90000300361 3360615 Hartford Correctional Center State Agency Facilities           2020   pk_12_total 0 0 *   0 0     0   0   * 0     0             *   * 0 0     0 0     0   0     0     0            
2779152 2779152 CT     school   3360015   Unified School District #1 90000300408 3361215 Osborn Correctional Institution State Agency Facilities           2020   pk_12_total 0 * *   0 0     0   0   * 0     0             *   * 0       0 0     0   0     0     0            
2779153 2779153 CT     school   3360015   Unified School District #1 90000300436 3361515 Willard/Cybulski Correctional Institution State Agency Facilities           2020   pk_12_total 0 * 0   0 0     0   0   * 0     0             *   * 0   0   0 0     0   0     0     0            
2779154 2779154 CT     school   3360015   Unified School District #1 90000300419 3361315 Robinson Correctional Institution State Agency Facilities           2020   pk_12_total 0 * 0   0 0     0   0   * 0     0             *   * 0   0   0 0     0   0     0     0            
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
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            
2779184 2779184 CT     school   3370015   Department of Mental Health and Addiction Services 90002701537 3370515 Greater Bridgeport Community Mental Health Center State Agency Facilities           2020   pk_12_total 0 0 *   0 0     0   0   * 0     0             *   * 0 0     0 0     0   0     0     0            
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            
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
2779029 2779029 CT     school   1570011   Weston School District   1570311 Post-High School Community Class Transition Program Program           2020   pk_12_total 0 0 0   0 0     0   *   0 *     0             *   * 0 0 0   0 0     0       0       0            
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
2779185 2779185 CT     school   3370015   Department of Mental Health and Addiction Services 90002701922 3370915 Whiting Forensic Hospital State Agency Facilities           2020   pk_12_total 0 0 *   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
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
2778761 2778761 CT     school   1310011   Southington School District 90423001668 1310511 EASE Program           2020   pk_12_total 8 * *   0 0     0   0   6 6     0             12   12 8       0 0     0   0   6 6     0       12   12
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
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
2779147 2779147 CT     school   3360015   Unified School District #1 90000300347 3360315 Cheshire Correctional Institution State Agency Facilities           2020   pk_12_total 0 * *   0 0     0   0   6 0     0             6   6 0       0 0     0   0   6 0     0       6   6
2777845 2777845 CT     school   170011   Bristol School District 90051001688 172611 Ivy Drive GOAL Program           2020   pk_12_total * * *   0 0     0   *   7 0     *             7   7         0 0     0       7 0             7   7
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
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
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
2778441 2778441 CT     school   930011   New Haven School District   933411 Benjamin Jepson Head Start Program           2020   pk_12_total * * 7   0 0     0   0   7 6     0             6   13     7   0 0     0   0   7 6     0       6   13
2778599 2778599 CT     school   1090011   Plainfield School District 90327001586 1098011 Early Childhood Center Program           2020   pk_12_total 12 * *   0 *     0   *   7 11     0             *   18 12       0       0       7 11     0           18

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);