enrollments

Data source: Big Local News · About: Big Local

20,286 rows where state = "CT" and year = 2019 sorted by male_int

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2019 · 20,086 ✖
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
2452906 2452906 CT     school   1510011   Waterbury School District   1513511 Generali Autism Program           2019   pk_12_total * 11 16   0 *     0   *   * *     *             31   31   11 16   0       0                       31   31
2452907 2452907 CT     school   1510011   Waterbury School District   1516911 Gilmartin Scope Program           2019   pk_12_total * * *   0 0     0   0   * *     *             9   9         0 0     0   0                   9   9
2452913 2452913 CT     school   1510011   Waterbury School District   1510411 B.W. Tinker BDLC             2019   pk_12_total 0 * *   0 0     0   0   * *     0             8   8 0       0 0     0   0           0       8   8
2452914 2452914 CT     school   1510011   Waterbury School District   1517211 Hearing Lab Program           2019   pk_12_total 0 0 *   * 0     0   0   * 0     0             *   * 0 0       0     0   0     0     0            
2452916 2452916 CT     school   1510011   Waterbury School District   1511211 Woodrow Wilson BDLC Program           2019   pk_12_total 0 * 15   0 0     0   *   * *     0             24   24 0   15   0 0     0               0       24   24
2452917 2452917 CT     school   1510011   Waterbury School District   1510111 Bunker Hill BDLC Program           2019   pk_12_total * * 17   0 0     0   0   * *     *             25   25     17   0 0     0   0                   25   25
2452919 2452919 CT     school   1510011   Waterbury School District   1516811 Duggan Scope             2019   pk_12_total * * *   0 0     0   0   * *     0             6   6         0 0     0   0           0       6   6
2452922 2452922 CT     school   1510011   Waterbury School District   1512911 North End Autism Program           2019   pk_12_total * * 7   0 *     0   0   * *     0             16   16     7   0       0   0           0       16   16
2452923 2452923 CT     school   1510011   Waterbury School District   1513711 North End BDLC Program           2019   pk_12_total 0 8 12   0 0     0   0   * *     *             20   20 0 8 12   0 0     0   0                   20   20
2452926 2452926 CT     school   1510011   Waterbury School District   1514811 North End SCOPE Program           2019   pk_12_total * * *   0 0     0   *   * *     *             10   10         0 0     0                       10   10
2452927 2452927 CT     school   1510011   Waterbury School District   1514411 Wallace BDLC Program           2019   pk_12_total * * 8   0 0     0   0   * *     0             14   14     8   0 0     0   0           0       14   14
2452931 2452931 CT     school   1510011   Waterbury School District   1514711 West Side BDLC Program           2019   pk_12_total * * 13   0 0     0   *   * *     *             23   23     13   0 0     0                       23   23
2452933 2452933 CT     school   1510011   Waterbury School District   1515511 West Side SCOPE Program           2019   pk_12_total * * 7   0 0     0   0   * *     *             9   9     7   0 0     0   0                   9   9
2452934 2452934 CT     school   1510011   Waterbury School District   1511811 North End ESC Program           2019   pk_12_total * * 6   0 0     0   0   * *     0             9   9     6   0 0     0   0           0       9   9
2452938 2452938 CT     school   1510011   Waterbury School District   1514511 Wilby Autism Program           2019   pk_12_total * * 6   0 0     0   0   * *     *             13   13     6   0 0     0   0                   13   13
2452939 2452939 CT     school   1510011   Waterbury School District   1511711 Wilby ESC Program           2019   pk_12_total * * *   0 0     0   0   * *     0             13   13         0 0     0   0           0       13   13
2452943 2452943 CT     school   1520011   Waterford School District   1521111 Autism Class Program           2019   pk_12_total * 0 0   0 0     *   0   * *     0             *   *   0 0   0 0         0           0            
2452947 2452947 CT     school   1520011   Waterford School District   1520911 Waterford Academy Program           2019   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2452949 2452949 CT     school   1520011   Waterford School District   1520311 Avery Point Transition Program Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             7   7   0     0 0     0   0           0       7   7
2452955 2452955 CT     school   1530011   Watertown School District   1530811 Watertown Transition Academy Program           2019   pk_12_total * 0 0   0 *     0   0   * *     0             *   *   0 0   0       0   0           0            
2452956 2452956 CT     school   1530011   Watertown School District   1530711 Watertown Transition Program at Post University             2019   pk_12_total 6 0 0   0 0     0   0   * *     0             6   6 6 0 0   0 0     0   0           0       6   6
2452965 2452965 CT     school   1550011   West Hartford School District   1559711 Morley Learning Center Program           2019   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2452971 2452971 CT     school   1550011   West Hartford School District 90492001705 1559311 Braeburn Learning Center Program           2019   pk_12_total * * 0   0 0     0   *   * 0     0             *   *     0   0 0     0         0     0            
2452972 2452972 CT     school   1550011   West Hartford School District 90492001780 1559511 Whiting Lane Learning Center Program           2019   pk_12_total * * *   0 0     0   *   * *     0             *   *         0 0     0               0            
2452987 2452987 CT     school   1560011   West Haven School District 90495001799 1560111 Life Skills Program           2019   pk_12_total * * 6   0 0     0   0   * *     *             11   11     6   0 0     0   0                   11   11
2452988 2452988 CT     school   1560011   West Haven School District   1561111 ASD Lab             2019   pk_12_total * 0 *   0 *     0   0   * *     0             *   *   0     0       0   0           0            
2453002 2453002 CT     school   1570011   Weston School District   1570311 Post-High School Community Class Transition Program Program           2019   pk_12_total 0 0 *   0 0     0   *   * *     0             *   * 0 0     0 0     0               0            
2453005 2453005 CT     school   1580011   Westport School District   1580211 GFS Intensive Resource Program           2019   pk_12_total * 0 0   0 *     0   0   * *     0             6   6   0 0   0       0   0           0       6   6
2453010 2453010 CT     school   1580011   Westport School District   1580111 LLS Intensive Resource Program           2019   pk_12_total * 0 *   0 *     0   0   * 0     0             *   *   0     0       0   0     0     0            
2453019 2453019 CT     school   1590011   Wethersfield School District   1590411 ABA Program           2019   pk_12_total 0 * *   0 0     0   *   * *     *             7   7 0       0 0     0                       7   7
2453020 2453020 CT     school   1590011   Wethersfield School District   1590311 STRIVE Program           2019   pk_12_total 0 0 *   0 0     0   0   * 0     0             *   * 0 0     0 0     0   0     0     0            
2453022 2453022 CT     school 905070 1590011   Wethersfield School District 90507001068 1596111 Wethersfield High School Public Schools Regular School No High 09 12 2019   pk_12_total 805 52 191   6 66     0   20   * 582     26             130   1140 805 52 191   6 66     0   20     582     26       130   1140
2453023 2453023 CT     school   1590011   Wethersfield School District   1590111 Wethersfield Transition Academy Program           2019   pk_12_total 7 * *   0 0     0   0   * *     0             11   11 7       0 0     0   0           0       11   11
2453030 2453030 CT     school   1610011   Wilton School District   1610311 Community Steps Program           2019   pk_12_total 6 0 0   0 0     0   0   * *     0             6   6 6 0 0   0 0     0   0           0       6   6
2453038 2453038 CT     school   1630011   Windham School District   1631111 Sweeney ASD Program Program           2019   pk_12_total * 0 12   0 0     0   *   * *     *             15   15   0 12   0 0     0                       15   15
2453039 2453039 CT     school   1630011   Windham School District   1630911 Sweeney Medically Fragile Program Program           2019   pk_12_total * 0 *   0 0     0   0   * *     *             *   *   0     0 0     0   0                        
2453045 2453045 CT     school   1630011   Windham School District   1631211 Assisted Work Program Program           2019   pk_12_total * 0 9   * 0     0   0   * *     *             12   12   0 9     0     0   0                   12   12
2453057 2453057 CT     school   1640011   Windsor School District   1640311 Spark Program           2019   pk_12_total * 10 *   0 0     0   *   * *     0             17   17   10     0 0     0               0       17   17
2453061 2453061 CT     school   1660011   Wolcott School District 90528001783 1660311 ABC Classroom Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             *   *   0     0 0     0   0           0            
2453066 2453066 CT     school   1660011   Wolcott School District 90528001772 1660411 Phoenix Program Program           2019   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2453089 2453089 CT     school   2040012   Regional School District 04   2040112 Region 4 Transition Academy Program           2019   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2453093 2453093 CT     school   2050012   Regional School District 05   2050112 Amity Transition Academy Program           2019   pk_12_total * 0 0   0 *     0   0   * *     0             *   *   0 0   0       0   0           0            
2453094 2453094 CT     school   2070012   Regional School District 07 90372001399 2079012 FLEX Program           2019   pk_12_total 9 0 0   0 0     0   0   * *     0             9   9 9 0 0   0 0     0   0           0       9   9
2453100 2453100 CT     school   2070012   Regional School District 07   2070112 Highlander Transition Academy Program           2019   pk_12_total 12 0 0   0 0     0   0   * *     0             12   12 12 0 0   0 0     0   0           0       12   12
2453108 2453108 CT     school   3470015   Unified School District #2   3470215 Virtual Academy Program           2019   pk_12_total 0 0 *   0 0     0   0   * 0     0             0   * 0 0     0 0     0   0     0     0       0    
2453111 2453111 CT     school   3360015   Unified School District #1 90000300347 3360315 Cheshire Correctional Institution State Agency Facilities           2019   pk_12_total 0 * 0   0 0     0   0   * 0     0             *   * 0   0   0 0     0   0     0     0            
2453112 2453112 CT     school   3360015   Unified School District #1 90000300844 3362415 Corrigan/Radgowski Correctional Institution State Agency Facilities           2019   pk_12_total * * *   0 0     0   0   * 0     0             *   *         0 0     0   0     0     0            
2453113 2453113 CT     school   3360015   Unified School District #1 90000301349 3362615 Northern Correctional Institution State Agency Facilities           2019   pk_12_total 0 * *   0 0     0   0   * 0     0             *   * 0       0 0     0   0     0     0            
2453114 2453114 CT     school   3360015   Unified School District #1 90000300361 3360615 Hartford Correctional Center State Agency Facilities           2019   pk_12_total 0 * *   0 0     0   0   * 0     0             *   * 0       0 0     0   0     0     0            
2453115 2453115 CT     school   3360015   Unified School District #1 90000300469 3362215 MacDougall/Walker Correctional Institution State Agency Facilities           2019   pk_12_total 0 * 0   0 0     0   0   * 0     0             *   * 0   0   0 0     0   0     0     0            
2453116 2453116 CT     school   3360015   Unified School District #1 90000300436 3361515 Willard/Cybulski Correctional Institution State Agency Facilities           2019   pk_12_total 0 0 0   0 0     0   *   * 0     0             *   * 0 0 0   0 0     0         0     0            
2453137 2453137 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010322 Alternative Pathways to Success Program Regular School No High 09 12 2019   pk_12_total 7 * *   0 0     0   0   * *     *             *   15 7       0 0     0   0                       15
2453138 2453138 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010222 Night School Program Regular School No High 09 12 2019   pk_12_total * * *   0 0     0   0   * *     0             *   7         0 0     0   0           0           7
2453142 2453142 CT     school   2190012   Regional School District 19   2190212 PM Panthers             2019   pk_12_total 14 0 *   0 0     0   *   * *     *             6   17 14 0     0 0     0                       6   17
2453146 2453146 CT     school   3370015   Department of Mental Health and Addiction Services 90002701539 3370215 Connecticut Valley Hospital State Agency Facilities           2019   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2451705 2451705 CT     school   20011   Ansonia School District   20411 P.A.C.E. - PM (Positive And Creative Education - PM) Program           2019   pk_12_total * * *   0 0     0   0   0 6     0             *   6         0 0     0   0   0 6     0           6
2451816 2451816 CT     school   170011   Bristol School District   172411 Mt. View Extended Resource Program           2019   pk_12_total * 0 0   0 0     0   0   0 *     0             *   *   0 0   0 0     0   0   0       0            
2452022 2452022 CT     school   490011   Enfield School District 90147001696 490611 Henry Barnard - Educational Counseling Program (ECP) Program           2019   pk_12_total * 0 0   0 0     0   *   0 *     0             *   *   0 0   0 0     0       0       0            
2452606 2452606 CT     school   2010012   Regional School District 01   2010612 Mountaineer Academy Program           2019   pk_12_total * 0 0   0 0     0   0   0 *     0             *   *   0 0   0 0     0   0   0       0            
2452662 2452662 CT     school   1180011   Ridgefield School District   1180111 District Program BMES Program           2019   pk_12_total * 0 0   0 0     0   0   0 *     0             *   *   0 0   0 0     0   0   0       0            
2452993 2452993 CT     school   1560011   West Haven School District   1560511 Blended (Molloy) Program           2019   pk_12_total * 0 *   0 0     0   0   0 *     0             0   *   0     0 0     0   0   0       0       0    
2453110 2453110 CT     school   3360015   Unified School District #1 90000300849 3362515 York Correctional Institution State Agency Facilities           2019   pk_12_total * * *   0 0     0   0   0 12     0             *   12         0 0     0   0   0 12     0           12
2451814 2451814 CT     school   170011   Bristol School District 90051001688 172611 Ivy Drive GOAL Program           2019   pk_12_total * * *   0 0     0   0   6 0     *             6   6         0 0     0   0   6 0             6   6
2451893 2451893 CT     school   280011   Colchester School District   280511 Bacon Academy Alternative Education Program           2019   pk_12_total * 0 *   0 0     0   0   6 *     0             *   10   0     0 0     0   0   6       0           10
2452032 2452032 CT     school   490011   Enfield School District 90147001523 499011 Enfield Transitional Learning Academy Program           2019   pk_12_total * * 0   0 0     0   0   6 6     0             12   12     0   0 0     0   0   6 6     0       12   12
2452455 2452455 CT     school   930011   New Haven School District   937811 Clinton Self Contained ID Program           2019   pk_12_total 0 * *   0 0     0   0   6 8     7             14   14 0       0 0     0   0   6 8     7       14   14
2452546 2452546 CT     school   1040011   Norwich School District   1040511 Special Needs Program @ Mahan Program           2019   pk_12_total * * 6   0 *     0   *   6 6     *             12   12     6   0       0       6 6             12   12
2452551 2452551 CT     school   1040011   Norwich School District   1040911 Stanton Special Learning Center Program           2019   pk_12_total * 0 *   0 0     0   0   6 0     0             6   6   0     0 0     0   0   6 0     0       6   6
2452666 2452666 CT     school   1180011   Ridgefield School District   1181111 District Program SRMS Program           2019   pk_12_total 6 0 0   0 0     0   0   6 0     0             6   6 6 0 0   0 0     0   0   6 0     0       6   6
2452694 2452694 CT     school   1260011   Shelton School District   1260211 Alternative Learning Center 1 Program           2019   pk_12_total * * *   0 0     0   0   6 0     *             6   6         0 0     0   0   6 0             6   6
2452799 2452799 CT     school   1380011   Stratford School District   1382711 ALL Class Room - Second Hill Lane Program           2019   pk_12_total * * *   0 0     0   0   6 0     0             6   6         0 0     0   0   6 0     0       6   6
2452876 2452876 CT     school   1480011   Wallingford School District   1481311 Inspire Middle School Program           2019   pk_12_total 9 0 *   0 *     0   0   6 7     *             13   13 9 0     0       0   0   6 7             13   13
2451742 2451742 CT     school   110011   Bloomfield School District   110111 Steps to Success Program           2019   pk_12_total * * 0   0 0     0   *   7 0     0             7   7     0   0 0     0       7 0     0       7   7
2452167 2452167 CT     school   640011   Hartford School District 90192001764 648511 iGOAL 2 - Moylan School Program           2019   pk_12_total 0 6 7   0 0     0   0   7 6     *             13   13 0 6 7   0 0     0   0   7 6             13   13
2452227 2452227 CT     school   2450014   Learn   2450814 Learn SAILS Middle School Program             2019   pk_12_total * * *   0 0     0   *   7 0     0             7   7         0 0     0       7 0     0       7   7
2452304 2452304 CT     school   800011   Meriden School District   801911 TLC - PHS Program           2019   pk_12_total * * 7   0 *     0   *   7 6     *             13   13     7   0       0       7 6             13   13
2452331 2452331 CT     school   830011   Middletown School District 90249001657 831611 Evening Program - MHS Program           2019   pk_12_total 6 * *   0 0     0   *   7 6     0             0   13 6       0 0     0       7 6     0       0   13
2452693 2452693 CT     school   1260011   Shelton School District   1261211 Therapeutic Learning Center Program           2019   pk_12_total * * *   0 0     0   0   7 0     *             7   7         0 0     0   0   7 0             7   7
2452786 2452786 CT     school   1370011   Stonington School District   1370711 SAILS Program           2019   pk_12_total * 0 *   0 0     0   0   7 0     0             *   7   0     0 0     0   0   7 0     0           7
2452903 2452903 CT     school   1510011   Waterbury School District   1511911 Carrington ESC Program           2019   pk_12_total * * 10   0 *     0   *   7 11     *             18   18     10   0       0       7 11             18   18
2452053 2452053 CT     school   510011   Fairfield School District   510511 Fairfield School/Community Partnership Program           2019   pk_12_total 10 * *   0 *     0   0   8 7     *             15   15 10       0       0   0   8 7             15   15
2452159 2452159 CT     school   640011   Hartford School District   640510 Pre-K Integrated - Naylor School Program           2019   pk_12_total * 0 11   0 *     0   0   8 7     0             6   15   0 11   0       0   0   8 7     0       6   15
2452204 2452204 CT     school   640011   Hartford School District   645011 iGOAL 2 - Weaver High School             2019   pk_12_total 0 6 9   0 0     0   0   8 7     *             15   15 0 6 9   0 0     0   0   8 7             15   15
2452323 2452323 CT     school   830011   Middletown School District   832011 ICM - Spencer Program           2019   pk_12_total * * *   0 0     0   *   8 0     0             8   8         0 0     0       8 0     0       8   8
2452363 2452363 CT     school   860011   Montville School District   860611 Montville Transition and Vocational Training Academy Program           2019   pk_12_total 6 * 0   0 *     0   0   8 0     *             8   8 6   0   0       0   0   8 0             8   8
2452698 2452698 CT     school   1260011   Shelton School District   1260711 Transition Program Program           2019   pk_12_total 14 * *   0 0     0   0   8 9     0             17   17 14       0 0     0   0   8 9     0       17   17
2452802 2452802 CT     school   1380011   Stratford School District 90444001756 1381811 Middle School Sails Program           2019   pk_12_total * * *   * 0     0   0   8 0     *             8   8           0     0   0   8 0             8   8
2452929 2452929 CT     school   1510011   Waterbury School District   1514911 Wallace SCOPE Program           2019   pk_12_total * * 7   0 0     0   0   8 6     *             14   14     7   0 0     0   0   8 6             14   14
2451724 2451724 CT     school   50011   Barkhamsted School District 90015001373 58011 Shared Services Integrated Preschool Program           2019   pk_12_total 17 0 0   0 0     0   0   9 8     0             8   17 17 0 0   0 0     0   0   9 8     0       8   17
2451985 2451985 CT     school   450011   East Lyme School District 90132001760 450611 Coastal Connections Program           2019   pk_12_total * 0 0   0 0     0   *   9 6     0             8   15   0 0   0 0     0       9 6     0       8   15
2452109 2452109 CT     school   590011   Groton School District   590211 New Beginnings Alternative Program Program           2019   pk_12_total 6 * *   0 0     *   *   9 6     0             15   15 6       0 0             9 6     0       15   15
2452189 2452189 CT     school   640011   Hartford School District   648911 iGOAL 1 - McDonough Middle School             2019   pk_12_total 0 * *   0 0     0   0   9 8     10             17   17 0       0 0     0   0   9 8     10       17   17
2452722 2452722 CT     school 904230 1310011   Southington School District 90423001804 1312111 Southington Public Schools Preschool Program Public Schools Regular School No Prekindergarten PK PK 2019   pk_12_total * * 0   0 0     0   0   9 10     0             11   19     0   0 0     0   0   9 10     0       11   19
2452740 2452740 CT     school   1310011   Southington School District 90423001649 1311211 Collaborative Learning Program (CLP) Program           2019   pk_12_total 8 * *   0 0     0   0   9 6     0             15   15 8       0 0     0   0   9 6     0       15   15
2451855 2451855 CT     school   2410014   Capitol Region Education Council 90070001492 2419114 Soundbridge Program           2019   pk_12_total * 0 0   0 *     0   0   10 8     0             8   18   0 0   0       0   0   10 8     0       8   18
2452420 2452420 CT     school   930011   New Haven School District   933411 Benjamin Jepson Head Start Program           2019   pk_12_total 0 * 9   0 0     0   *   10 6     0             8   16 0   9   0 0     0       10 6     0       8   16
2452543 2452543 CT     school   1030011   Norwalk School District   1030611 Norwalk 18-21 Project SEARCH Program           2019   pk_12_total 7 * *   0 0     0   0   10 7     *             17   17 7       0 0     0   0   10 7             17   17
2452738 2452738 CT     school   1310011   Southington School District 90423001720 1311611 Therapeutic Educational Alternative Model (TEAM) Program           2019   pk_12_total * 0 0   0 0     0   *   10 0     0             10   10   0 0   0 0     0       10 0     0       10   10
2452806 2452806 CT     school   1380011   Stratford School District 90444001671 1380711 High School Sails Program           2019   pk_12_total * * 6   0 0     0   *   10 7     *             17   17     6   0 0     0       10 7             17   17
2452992 2452992 CT     school   1560011   West Haven School District   1560711 Blended Program           2019   pk_12_total 11 * 6   0 0     0   *   10 9     *             *   19 11   6   0 0     0       10 9                 19

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