enrollments

Data source: Big Local News · About: Big Local

20,454 rows where state = "CT" and year = 2020 sorted by female_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
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
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
2778975 2778975 CT     school 904860 1520011   Waterford School District 90486001001 1526111 Waterford High School Public Schools Regular School No High 09 12 2020   pk_12_total 619 18 96   * 46     *   25   407 *     8             132   811 619 18 96     46         25   407       8       132   811
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
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
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
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            
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
2779048 2779048 CT     school 905070 1590011   Wethersfield School District 90507001068 1596111 Wethersfield High School Public Schools Regular School No High 09 12 2020   pk_12_total 804 46 204   * 62     *   24   574 *     38             140   1144 804 46 204     62         24   574       38       140   1144
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
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
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
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
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
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
2779142 2779142 CT     school 905372 9020022   The Gilbert School District 90537201222 9026122 The Gilbert School Endowed and Incorporated Academies Schools Regular School No High 07 12 2020   pk_12_total 327 9 73   0 36     0   22   253 *     13             70   467 327 9 73   0 36     0   22   253       13       70   467
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
2779158 2779158 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201138 9001916 E. C. Goodwin Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2020   pk_12_total 177 50 395   * 9     *   23   368 *     33             53   658 177 50 395     9         23   368       33       53   658
2779170 2779170 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201150 9001816 Vinal Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2020   pk_12_total 286 31 69   0 *     *   29   299 *     9             66   418 286 31 69   0           29   299       9       66   418
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            
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            
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
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
2777848 2777848 CT     school   170011   Bristol School District 90051001711 173111 South Side GOAL Program           2020   pk_12_total * 0 *   0 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            
2777876 2777876 CT     school   230011   Canton School District 90069001695 230411 Canton Academy Program           2020   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
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            
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            
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            
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            
2778028 2778028 CT     school   2420014   EdAdvance 90351201476 2429014 The ACCESS School at The Danuta M. Thibodeau Education Center Program           2020   pk_12_total 14 * 7   * *     0   0   25 0     0             25   25 14   7           0   0   25 0     0       25   25
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    
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            
2778046 2778046 CT     school   490011   Enfield School District 90147001792 490311 Henry Barnard - Autism Spectrum Disorder (ASD) Program           2020   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2778050 2778050 CT     school   490011   Enfield School District 90147001696 490611 Henry Barnard - Educational Counseling Program (ECP) Program           2020   pk_12_total * * *   0 0     0   *   * 0     0             *   *         0 0     0         0     0            
2778051 2778051 CT     school   490011   Enfield School District   492411 Eagle Academy Program           2020   pk_12_total * * *   0 0     0   *   7 0     0             7   7         0 0     0       7 0     0       7   7
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
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            
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
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                  
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            
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            
2778259 2778259 CT     school   2450014   Learn 90345001757 2450414 LEARN Transition Academy Program           2020   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
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
2778329 2778329 CT     school   800011   Meriden School District   802511 SOAR - PHS Program           2020   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
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
2778418 2778418 CT     school   890011   New Britain School District   891711 Slade KEY Middle Program           2020   pk_12_total * * 10   0 *     0   *   19 0     0             19   19     10   0       0       19 0     0       19   19
2778473 2778473 CT     school   930011   New Haven School District   938711 Fair Haven Self Contained ID Program           2020   pk_12_total * 6 *   0 0     0   *   12 0     0             12   12   6     0 0     0       12 0     0       12   12
2778578 2778578 CT     school   1040011   Norwich School District   1040911 Stanton Special Learning Center Program           2020   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2778598 2778598 CT     school   1080011   Oxford School District   1080511 Community Explorations Program           2020   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2778653 2778653 CT     school   2140012   Regional School District 14   2140412 Region 14 Transition Academy Program           2020   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2778661 2778661 CT     school   2150012   Regional School District 15   2150112 MIJ Program Program           2020   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2778672 2778672 CT     school   2170012   Regional School District 17   2170412 RSD17 Transition Program Program           2020   pk_12_total 0 0 0   0 *     0   0   * 0     0             *   * 0 0 0   0       0   0     0     0            
2778678 2778678 CT     school   2180012   Regional School District 18   2180412 Alternative Program Program           2020   pk_12_total 0 0 *   0 0     0   0   * 0     0             0   * 0 0     0 0     0   0     0     0       0    
2778683 2778683 CT     school   1180011   Ridgefield School District   1181211 District Program FES Program           2020   pk_12_total 0 0 0   0 *     0   0   * 0     0             *   * 0 0 0   0       0   0     0     0            
2778701 2778701 CT     school   1190011   Rocky Hill School District   1190311 Pathways Program           2020   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2778702 2778702 CT     school   1190011   Rocky Hill School District   1190711 Rocky Hill DREAM Transition Academy Program           2020   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2778717 2778717 CT     school   1260011   Shelton School District   1260211 Alternative Learning Center 1 Program           2020   pk_12_total 6 * *   0 0     0   *   9 0     *             9   9 6       0 0     0       9 0             9   9
2778719 2778719 CT     school   1260011   Shelton School District   1261211 Therapeutic Learning Center Program           2020   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2778744 2778744 CT     school 904170 1320011   South Windsor School District 90417000826 1320311 Alternative Education Program Program Regular School No High 09 12 2020   pk_12_total 6 * *   0 0     0   0   9 0     0             *   9 6       0 0     0   0   9 0     0           9
2778807 2778807 CT     school   1370011   Stonington School District   1370911 The Learning Annex Program           2020   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2778809 2778809 CT     school   1370011   Stonington School District   1370711 SAILS Program           2020   pk_12_total * * 0   0 0     0   0   * 0     0             0   *     0   0 0     0   0     0     0       0    
2778822 2778822 CT     school   1380011   Stratford School District   1382711 ALL Class Room - Second Hill Lane Program           2020   pk_12_total * * *   0 0     0   0   * 0     0             *   *         0 0     0   0     0     0            
2778826 2778826 CT     school   1380011   Stratford School District 90444001706 1381911 STEPS 7-8 Program           2020   pk_12_total 0 * *   0 0     0   0   7 0     0             7   7 0       0 0     0   0   7 0     0       7   7
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            
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            
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            
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    

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