enrollments

Data source: Big Local News · About: Big Local

20,454 rows where state = "CT" and year = 2020 sorted by hispanic_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
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
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
2778968 2778968 CT     school   1520011   Waterford School District   1520811 The Early Childhood Center Program           2020   pk_12_total 20 * *   0 0     0   0   15 10     0             13   25 20       0 0     0   0   15 10     0       13   25
2778969 2778969 CT     school   1520011   Waterford School District   1521011 The Early Learning Center II Program           2020   pk_12_total 21 * *   0 0     *   *   14 12     0             12   26 21       0 0             14 12     0       12   26
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
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
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
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
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                        
2779079 2779079 CT     school   1650011   Windsor Locks School District 90525001777 1650211 RISE Transition Academy Program           2020   pk_12_total 10 * *   0 0     0   *   7 8     0             15   15 10       0 0     0       7 8     0       15   15
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
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
2779103 2779103 CT     school 900630 210011   Canaan School District 90063000115 210111 Lee H. Kellogg School Public Schools Regular School No Elementary KG 08 2020   pk_12_total 63 0 *   0 0     0   *   38 29     *             10   67 63 0     0 0     0       38 29             10   67
2779106 2779106 CT     school 900870 290011   Colebrook School District 90087000138 290111 Colebrook Consolidated School Public Schools Regular School No Elementary KG 06 2020   pk_12_total 68 0 *   0 0     0   *   50 24     0             18   74 68 0     0 0     0       50 24     0       18   74
2779123 2779123 CT     school   3470015   Unified School District #2 90000400479 3470315 Riverview School State Agency Facilities           2020   pk_12_total 23 12 *   0 0     0   *   12 34     *             39   46 23 12     0 0     0       12 34             39   46
2779134 2779134 CT     school   2070012   Regional School District 07 90372001400 2079112 AIM Program           2020   pk_12_total 18 * *   0 0     0   *   11 11     0             22   22 18       0 0     0       11 11     0       22   22
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
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
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            
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
2779148 2779148 CT     school   3360015   Unified School District #1 90000300469 3362215 MacDougall/Walker Correctional Institution State Agency Facilities           2020   pk_12_total 0 * *   0 0     0   0   9 0     0             9   9 0       0 0     0   0   9 0     0       9   9
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            
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
2779179 2779179 CT     school   2190012   Regional School District 19 90000501729 2190112 E.O. Smith High School at the Depot Campus Program           2020   pk_12_total 19 0 *   0 0     0   *   14 8     0             7   22 19 0     0 0     0       14 8     0       7   22
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            
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            
2777752 2777752 CT     school   50011   Barkhamsted School District 90015001373 58011 Shared Services Integrated Preschool Program           2020   pk_12_total 17 0 0   0 0     0   0   10 7     0             6   17 17 0 0   0 0     0   0   10 7     0       6   17
2777753 2777753 CT     school   50011   Barkhamsted School District   50211 Bridges at Barkhamsted Elementary School Program           2020   pk_12_total * 0 0   0 0     0   *   * *     0             *   *   0 0   0 0     0               0            
2777759 2777759 CT     school   70011   Berlin School District   70311 Transition Academy Program           2020   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
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
2777779 2777779 CT     school   120011   Bolton School District   120211 Bolton Transition Program Program           2020   pk_12_total * 0 0   0 0     0   0   0 *     0             *   *   0 0   0 0     0   0   0       0            
2777788 2777788 CT     school   140011   Branford School District   140311 Access Transition Program Program           2020   pk_12_total * 0 0   0 *     0   0   * *     *             15   15   0 0   0       0   0                   15   15
2777852 2777852 CT     school   170011   Bristol School District   171611 Chippens Hill Middle School Medically Fragile Program           2020   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2777857 2777857 CT     school   170011   Bristol School District 90051001796 172811 Northeast MS/GOAL Program           2020   pk_12_total * * 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            
2777896 2777896 CT     school   2410014   Capitol Region Education Council 90070001489 2419214 Farmington Valley Regional Diagnostic Center Program           2020   pk_12_total 8 * 0   0 0     0   *   * *     0             *   11 8   0   0 0     0               0           11
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            
2777901 2777901 CT     school   2410014   Capitol Region Education Council 90070001802 2419714 Strive (Southern Transition Real-World and Independent Vocational Education Program Program           2020   pk_12_total * 0 0   0 *     0   0   * *     0             13   13   0 0   0       0   0           0       13   13
2777913 2777913 CT     school   250011   Cheshire School District 90075001766 250311 Cheshire Quinnipiac University Transition Collaborative Program           2020   pk_12_total * 0 0   0 *     0   0   * *     0             6   6   0 0   0       0   0           0       6   6
2777914 2777914 CT     school   250011   Cheshire School District   251011 QU College Life Program           2020   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2777922 2777922 CT     school   280011   Colchester School District   280511 Bacon Academy Alternative Education Program           2020   pk_12_total 9 0 0   0 0     0   0   6 *     0             *   9 9 0 0   0 0     0   0   6       0           9
2777923 2777923 CT     school   280011   Colchester School District   280711 Community Transition Academy of Colchester Program           2020   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2777962 2777962 CT     school   340011   Danbury School District   340711 Western Connection Program           2020   pk_12_total * * 0   0 0     0   0   * *     0             11   11     0   0 0     0   0           0       11   11
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            
2777988 2777988 CT     school   420011   East Hampton School District 90123001514 429011 The Learning Center at East Hampton Program           2020   pk_12_total 8 0 0   0 0     0   0   * *     0             *   8 8 0 0   0 0     0   0           0           8
2778019 2778019 CT     school   450011   East Lyme School District 90132001730 450511 Abilities in Motion (AIM) Program Program           2020   pk_12_total * * 0   0 0     0   0   * *     *             10   10     0   0 0     0   0                   10   10
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            
2778052 2778052 CT     school   490011   Enfield School District 90147001676 490511 Edgar H. Parkman - Autism Spectrum Disorder (ASD) Program           2020   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2778060 2778060 CT     school   490011   Enfield School District   490111 Enfield High - Adaptive Learning Program (ALP) Program           2020   pk_12_total * 0 0   0 *     0   0   * *     0             6   6   0 0   0       0   0           0       6   6
2778062 2778062 CT     school   490011   Enfield School District 90147001523 499011 Enfield Transitional Learning Academy Program           2020   pk_12_total 12 * 0   0 *     0   *   10 7     0             17   17 12   0   0       0       10 7     0       17   17
2778128 2778128 CT     school 901740 580011   Griswold School District 90174001721 580111 Griswold Alternative School Public Schools Alternative School No High 08 12 2020   pk_12_total 13 0 0   0 0     *   *   * *     0             15   15 13 0 0   0 0                     0       15   15
2778139 2778139 CT     school   590011   Groton School District   590611 Apex Academy Program           2020   pk_12_total * * 0   0 0     0   *   * *     0             *   *     0   0 0     0               0            
2778169 2778169 CT     school   620011   Hamden School District   620611 Hamden Transition Academy @ SCSU (AACPB) Program           2020   pk_12_total * 7 0   0 *     0   0   * *     *             10   10   7 0   0       0   0                   10   10
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            
2778269 2778269 CT     school   720011   Ledyard School District   720511 Ledyard Transition Academy Program           2020   pk_12_total * * 0   0 *     0   0   * *     0             8   8     0   0       0   0           0       8   8
2778384 2778384 CT     school   860011   Montville School District   860611 Montville Transition and Vocational Training Academy Program           2020   pk_12_total * * 0   0 *     0   0   * *     0             7   7     0   0       0   0           0       7   7
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            
2778610 2778610 CT     school   1100011   Plainville School District   1100111 Plainville Transition Program Program           2020   pk_12_total * * 0   0 0     0   0   * *     0             *   *     0   0 0     0   0           0            
2778626 2778626 CT     school   1160011   Putnam School District 90348001518 1169011 Helping Hands 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
2778633 2778633 CT     school   2060012   Regional School District 06   2060412 Wamogo Transition Program Program           2020   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2778642 2778642 CT     school   2120012   Regional School District 12   2120512 Shepaug Valley Partnership Program           2020   pk_12_total * 0 0   0 *     0   0   * *     0             *   *   0 0   0       0   0           0            
2778648 2778648 CT     school   2130012   Regional School District 13 90353501731 2130312 Middlesex Transition Academy Program           2020   pk_12_total 12 * 0   0 *     0   0   * *     0             15   15 12   0   0       0   0           0       15   15
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            
2778665 2778665 CT     school   2160012   Regional School District 16 90353801747 2160412 WRHS Alternative Education Program Program           2020   pk_12_total * 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            
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            
2778684 2778684 CT     school   1180011   Ridgefield School District   1180711 District Program RES Program           2020   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2778688 2778688 CT     school   1180011   Ridgefield School District   1181011 District Program ERMS Program           2020   pk_12_total * 0 0   0 0     0   *   * *     0             *   *   0 0   0 0     0               0            
2778689 2778689 CT     school   1180011   Ridgefield School District   1181111 District Program SRMS Program           2020   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2778692 2778692 CT     school   1180011   Ridgefield School District   1181311 District Program RHS Program           2020   pk_12_total * 0 0   0 *     0   0   * *     0             9   9   0 0   0       0   0           0       9   9
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            
2778718 2778718 CT     school   1260011   Shelton School District   1261311 Alternative Learning Center 2 Program           2020   pk_12_total * 0 0   0 *     0   0   * *     *             10   10   0 0   0       0   0                   10   10
2778720 2778720 CT     school   1260011   Shelton School District   1260311 Life Skills Program           2020   pk_12_total * 0 0   0 0     0   *   * *     0             *   *   0 0   0 0     0               0            
2778724 2778724 CT     school   1260011   Shelton School District   1260711 Transition Program Program           2020   pk_12_total * * 0   0 0     0   0   10 9     0             19   19     0   0 0     0   0   10 9     0       19   19
2778746 2778746 CT     school   1320011   South Windsor School District 90417001605 1329011 Project Worth Young Adult Academy Program           2020   pk_12_total 11 * 0   0 *     0   0   * *     0             14   14 11   0   0       0   0           0       14   14
2778747 2778747 CT     school   1310011   Southington School District 90423001804 1312111 Southington Public Schools Preschool Program Public Schools           2020   pk_12_total * * 0   0 0     0   0   12 12     0             15   24     0   0 0     0   0   12 12     0       15   24
2778768 2778768 CT     school   1310011   Southington School District   1312211 STELLAR Program           2020   pk_12_total * 0 0   0 0     0   *   * *     0             11   11   0 0   0 0     0               0       11   11
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    
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

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