enrollments

Data source: Big Local News · About: Big Local

1,461 rows where grade = "pk_12_total", state = "CT" and year = 2020 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 1,461 ✖

grade ✖

  • pk_12_total · 1,461 ✖
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
2777737 2777737 CT     school   2440014   Area Cooperative Educational Services   2440414 ACES at Mead Elementary School Program           2020   pk_12_total 0 * *   0 0     0   *   * *     0             *   * 0       0 0     0               0            
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            
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            
2777837 2777837 CT     school   170011   Bristol School District 90051001692 172311 Ivy Drive Medically Fragile Program           2020   pk_12_total * * *   0 0     0   0   * *     0             *   *         0 0     0   0           0            
2777838 2777838 CT     school   170011   Bristol School District   172411 Mt. View Extended Resource Program           2020   pk_12_total * * *   0 0     0   0   * *     *             *   *         0 0     0   0                        
2777843 2777843 CT     school   170011   Bristol School District 90051001646 172111 Hubbell/Extended Resource Program           2020   pk_12_total 0 0 *   0 *     0   0   * *     0             *   * 0 0     0       0   0           0            
2777844 2777844 CT     school   170011   Bristol School District 90051001726 172511 Mt. View GOAL Program           2020   pk_12_total 0 * *   0 0     0   0   * *     0             *   * 0       0 0     0   0           0            
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            
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            
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            
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            
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            
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            
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            
2778047 2778047 CT     school   490011   Enfield School District 90147001743 490811 Henry Barnard - Primary Adaptive Learning (PAL) Program           2020   pk_12_total * * *   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            
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            
2778054 2778054 CT     school   490011   Enfield School District   491411 Eli Whitney - Intermediate Adaptive Learning (IAL) Program           2020   pk_12_total * * *   0 0     0   0   * *     0             *   *         0 0     0   0           0            
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            
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            
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            
2778260 2778260 CT     school   2450014   Learn 90345001795 2450614 Learn High School Program           2020   pk_12_total * 0 *   0 *     0   0   * *     0             *   *   0     0       0   0           0            
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            
2778342 2778342 CT     school   830011   Middletown School District 90249001719 830811 ICM - Moody K-2 Program           2020   pk_12_total 0 * *   0 0     0   0   * *     0             *   * 0       0 0     0   0           0            
2778343 2778343 CT     school   830011   Middletown School District 90249001652 830711 ICM - Moody 3-5 Program           2020   pk_12_total * * *   0 0     0   0   * *     0             *   *         0 0     0   0           0            
2778353 2778353 CT     school   830011   Middletown School District   832211 MHS- Alternative Education Program 3 Program           2020   pk_12_total * * *   0 0     0   0   * *     0             *   *         0 0     0   0           0            
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            
2778580 2778580 CT     school   1040011   Norwich School District   1041211 Strive Program @ Stanton Program           2020   pk_12_total 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            
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            
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            
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            
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            
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            
2778687 2778687 CT     school   1180011   Ridgefield School District   1180911 District Program SES Program           2020   pk_12_total * 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            
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            
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            
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            
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            
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            
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                        
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                        
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    
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            
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            
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            
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                  
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    
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            
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            
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            
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            
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            
2777862 2777862 CT     school   170011   Bristol School District   170211 ACCESS Program           2020   pk_12_total * * *   0 0     0   *   * *     0             10   10         0 0     0               0       10   10
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
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
2778312 2778312 CT     school   800011   Meriden School District   802211 SOAR- ES Program           2020   pk_12_total * * *   0 0     0   0   * *     0             *   10         0 0     0   0           0           10
2778318 2778318 CT     school   800011   Meriden School District   801511 STARS-MS Program           2020   pk_12_total * * *   0 0     0   *   * *     *             10   10         0 0     0                       10   10
2778348 2778348 CT     school   830011   Middletown School District 90249001722 831811 MHS - Alternative Education Program 1 Program           2020   pk_12_total * * *   0 0     0   *   * *     0             *   10         0 0     0               0           10
2778456 2778456 CT     school   930011   New Haven School District   930510 Lincoln Bassett Integrated PK Program           2020   pk_12_total 0 * *   0 0     0   0   * *     0             10   10 0       0 0     0   0           0       10   10

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