enrollments

Data source: Big Local News · About: Big Local

1,449 rows where grade = "pk_12_total", state = "CT" and year = 2019 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 1,449 ✖

grade ✖

  • pk_12_total · 1,449 ✖
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
2451725 2451725 CT     school   50011   Barkhamsted School District   50211 Bridges at Barkhamsted Elementary School Program           2019   pk_12_total * 0 0   0 0     0   *   * *     0             *   *   0 0   0 0     0               0            
2451731 2451731 CT     school   70011   Berlin School District   70311 Transition Academy Program           2019   pk_12_total * 0 *   0 0     0   0   * *     *             *   *   0     0 0     0   0                        
2451739 2451739 CT     school   90011   Bethel School District   90211 Community Partnership Program Program           2019   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2451751 2451751 CT     school   120011   Bolton School District   120211 Bolton Transition Program Program           2019   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2451807 2451807 CT     school   170011   Bristol School District 90051001726 172511 Mt. View GOAL Program           2019   pk_12_total 0 0 *   0 0     0   *   * *     0             *   * 0 0     0 0     0               0            
2451812 2451812 CT     school   170011   Bristol School District 90051001692 172311 Ivy Drive Medically Fragile Program           2019   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2451813 2451813 CT     school   170011   Bristol School District 90051001646 172111 Hubbell/Extended Resource Program           2019   pk_12_total * 0 *   0 *     0   0   * *     0             *   *   0     0       0   0           0            
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            
2451821 2451821 CT     school   170011   Bristol School District   171611 Chippens Hill Middle School Medically Fragile Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             *   *   0     0 0     0   0           0            
2451827 2451827 CT     school   170011   Bristol School District 90051001796 172811 Northeast MS/GOAL Program           2019   pk_12_total * 0 *   0 0     0   0   * 0     *             *   *   0     0 0     0   0     0                  
2451845 2451845 CT     school   230011   Canton School District 90069001695 230411 Canton Academy Program           2019   pk_12_total * 0 0   0 *     0   0   * *     0             *   *   0 0   0       0   0           0            
2451867 2451867 CT     school   2410014   Capitol Region Education Council   2411514 Soundbridge @ Chippens Hill MS Bristol             2019   pk_12_total 0 * *   0 *     0   0   * *     0             *   * 0       0       0   0           0            
2451870 2451870 CT     school   2410014   Capitol Region Education Council   2419414 IPM @ Plainville High School             2019   pk_12_total * * 0   0 0     0   0   * *     0             *   *     0   0 0     0   0           0            
2452003 2452003 CT     school   2420014   EdAdvance   2420414 ACCESS-South Expelled Student Program           2019   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2452004 2452004 CT     school   2420014   EdAdvance   2420314 Steps-North Expelled Student Program           2019   pk_12_total * * *   0 0     0   0   * 0     0             0   *         0 0     0   0     0     0       0    
2452010 2452010 CT     school   480011   Ellington School District   480511 The Ellington Public Schools Expulsion Program (TEPSEP) Program           2019   pk_12_total 0 * 0   0 0     0   0   * 0     0             *   * 0   0   0 0     0   0     0     0            
2452011 2452011 CT     school   480011   Ellington School District   480411 Ellington Continuing Life Independence Post-Secondary Education (ECLIPSE) Program           2019   pk_12_total * 0 0   0 *     0   0   * *     0             *   *   0 0   0       0   0           0            
2452018 2452018 CT     school   490011   Enfield School District 90147001743 490811 Henry Barnard - Primary Adaptive Learning (PAL) Program           2019   pk_12_total * * 0   0 0     0   0   * *     0             *   *     0   0 0     0   0           0            
2452021 2452021 CT     school   490011   Enfield School District 90147001792 490311 Henry Barnard - Autism Spectrum Disorder (ASD) Program           2019   pk_12_total * * 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            
2452023 2452023 CT     school   490011   Enfield School District 90147001676 490511 Edgar H. Parkman - Autism Spectrum Disorder (ASD) Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             *   *   0     0 0     0   0           0            
2452025 2452025 CT     school   490011   Enfield School District   491411 Eli Whitney - Intermediate Adaptive Learning (IAL) Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             *   *   0     0 0     0   0           0            
2452026 2452026 CT     school   490011   Enfield School District 90147001702 490711 Prudence Crandall - Educational Counseling Program (ECP) Program           2019   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2452169 2452169 CT     school   640011   Hartford School District   640810 iGOAL Pre-K - Rawson School Program           2019   pk_12_total 0 * *   0 0     0   0   * *     0             *   * 0       0 0     0   0           0            
2452179 2452179 CT     school   640011   Hartford School District   649811 iGOAL 1 - Moylan School             2019   pk_12_total 0 * *   0 0     0   *   * *     *             *   * 0       0 0     0                            
2452180 2452180 CT     school   640011   Hartford School District   644611 RISE - West Middle School Program           2019   pk_12_total 0 * *   0 0     0   0   * *     0             *   * 0       0 0     0   0           0            
2452191 2452191 CT     school   640011   Hartford School District   640210 iGOAL 2 - Kennelly School Program           2019   pk_12_total 0 * *   0 0     0   0   * *     0             *   * 0       0 0     0   0           0            
2452220 2452220 CT     school   2450014   Learn   2451514 LEARN Integrated Program at TFS Program           2019   pk_12_total 0 0 *   0 0     0   0   * 0     0             *   * 0 0     0 0     0   0     0     0            
2452226 2452226 CT     school   2450014   Learn   2451414 LEARN Diagnostic and Wellness Center Program           2019   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2452230 2452230 CT     school   2450014   Learn   2450514 Learn Pathways Program             2019   pk_12_total * 0 *   0 0     0   0   * *     0             *   *   0     0 0     0   0           0            
2452233 2452233 CT     school   2450014   Learn 90345001795 2450614 Learn High School Program           2019   pk_12_total * 0 *   0 *     0   0   * *     0             *   *   0     0       0   0           0            
2452235 2452235 CT     school   2450014   Learn 90345001757 2450414 LEARN Transition Academy Program           2019   pk_12_total * 0 *   0 *     0   0   * 0     *             *   *   0     0       0   0     0                  
2452268 2452268 CT     school   770011   Manchester School District   771111 Elementary Site 2             2019   pk_12_total * 0 0   0 *     0   0   * *     *             0   *   0 0   0       0   0                   0    
2452321 2452321 CT     school   830011   Middletown School District 90249001758 830611 ICM - Farm Hill Program           2019   pk_12_total * * 0   0 0     0   0   * *     0             *   *     0   0 0     0   0           0            
2452322 2452322 CT     school   830011   Middletown School District 90249001652 830711 ICM - Moody 3-5 Program           2019   pk_12_total * * *   0 0     0   *   * 0     0             *   *         0 0     0         0     0            
2452332 2452332 CT     school   830011   Middletown School District 90249001768 831911 MHS - Alternative Education Program 2 Program           2019   pk_12_total 0 * *   * 0     0   *   * *     0             *   * 0         0     0               0            
2452349 2452349 CT     school   840011   Milford School District   840611 Post Grad Transitional Academy Program           2019   pk_12_total * 0 0   0 *     0   0   * *     0             *   *   0 0   0       0   0           0            
2452387 2452387 CT     school   890011   New Britain School District   891011 Lincoln SCS Program           2019   pk_12_total 0 * *   0 0     0   0   * *     0             *   * 0       0 0     0   0           0            
2452407 2452407 CT     school   900011   New Canaan School District   900111 Launch Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             *   *   0     0 0     0   0           0            
2452442 2452442 CT     school   930011   New Haven School District   930410 West Rock Integrated PK Program           2019   pk_12_total 0 * *   0 0     0   0   * *     0             *   * 0       0 0     0   0           0            
2452451 2452451 CT     school   930011   New Haven School District   930310 Lincoln Bassett Self Contained Program           2019   pk_12_total 0 * *   0 0     0   0   * 0     0             *   * 0       0 0     0   0     0     0            
2452478 2452478 CT     school   950011   New London School District   950711 Pre-Kindergarten at Winthrop Program           2019   pk_12_total 0 0 *   0 0     0   0   * *     0             *   * 0 0     0 0     0   0           0            
2452512 2452512 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2019   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2452604 2452604 CT     school   2010012   Regional School District 01   2010412 LEAPSS Program           2019   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2452605 2452605 CT     school   2010012   Regional School District 01   2010312 SELC 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            
2452620 2452620 CT     school   2120012   Regional School District 12   2120512 Shepaug Valley Partnership Program           2019   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2452631 2452631 CT     school   2140012   Regional School District 14   2140412 Region 14 Transition Academy Program           2019   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2452650 2452650 CT     school   2170012   Regional School District 17   2170412 RSD17 Transition Program Program           2019   pk_12_total * 0 0   0 *     0   0   * *     0             *   *   0 0   0       0   0           0            
2452656 2452656 CT     school   2180012   Regional School District 18   2180412 Alternative Program Program           2019   pk_12_total * 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            
2452665 2452665 CT     school   1180011   Ridgefield School District   1180911 District Program SES Program           2019   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2452669 2452669 CT     school   1180011   Ridgefield School District   1181011 District Program ERMS Program           2019   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2452692 2452692 CT     school   1260011   Shelton School District   1260311 Life Skills Program           2019   pk_12_total * 0 0   0 0     0   *   * *     0             *   *   0 0   0 0     0               0            
2452712 2452712 CT     school   1290011   Somers School District   1290511 Aspire Program           2019   pk_12_total * * 0   0 0     0   0   * *     0             *   *     0   0 0     0   0           0            
2452797 2452797 CT     school   1380011   Stratford School District   1382311 DLC Whitney Program           2019   pk_12_total * * 0   0 0     0   0   * *     0             *   *     0   0 0     0   0           0            
2452835 2452835 CT     school   1430011   Torrington School District   1430311 Post Secondary Transition Services Program           2019   pk_12_total 0 0 *   0 0     0   *   * 0     0             *   * 0 0     0 0     0         0     0            
2452873 2452873 CT     school   1480011   Wallingford School District   1480611 Benhaven ABC Intermediate Program Program           2019   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
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            
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            
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            
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            
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            
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    
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            
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            
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            
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                        
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            
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            
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            
2451809 2451809 CT     school   170011   Bristol School District 90051001707 173211 Stafford Autism Program           2019   pk_12_total * * *   0 *     0   0   * *     0             10   10         0       0   0           0       10   10
2451831 2451831 CT     school   170011   Bristol School District   170211 ACCESS Program           2019   pk_12_total * 0 *   0 0     0   0   * *     *             10   10   0     0 0     0   0                   10   10
2451858 2451858 CT     school   2410014   Capitol Region Education Council   2411714 Soundbridge@Mountain View Elementary School             2019   pk_12_total * 0 *   0 *     0   0   * *     0             10   10   0     0       0   0           0       10   10
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
2451900 2451900 CT     school   2430014   Cooperative Educational Services 90091001555 2439314 RISE Transitional Program Program           2019   pk_12_total 7 * 0   0 0     0   *   * *     0             10   10 7   0   0 0     0               0       10   10
2452168 2452168 CT     school   640011   Hartford School District   640710 iGOAL Pre-K - Naylor School Program           2019   pk_12_total 0 * *   0 0     0   0   * *     0             10   10 0       0 0     0   0           0       10   10
2452174 2452174 CT     school   640011   Hartford School District   649511 iGOAL 1 - Breakthrough Magnet School, North Program           2019   pk_12_total 0 * *   0 0     0   0   * *     0             10   10 0       0 0     0   0           0       10   10
2452457 2452457 CT     school   930011   New Haven School District   937711 Nathan Hale Self Contained ID Program           2019   pk_12_total * * 7   0 0     0   0   * *     *             10   10     7   0 0     0   0                   10   10
2452490 2452490 CT     school   960011   New Milford School District 90285001577 969011 Litchfield Hills Transition Center Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             10   10   0     0 0     0   0           0       10   10
2452558 2452558 CT     school   1040011   Norwich School District   1041111 Strive Program @ Kelly Program           2019   pk_12_total * 0 *   0 0     0   0   * *     *             10   10   0     0 0     0   0                   10   10
2452643 2452643 CT     school   2160012   Regional School District 16 90353801747 2160412 WRHS Alternative Education Program Program           2019   pk_12_total 7 * *   0 0     *   0   * *     0             *   10 7       0 0         0           0           10
2452728 2452728 CT     school   1310011   Southington School District   1312311 Language Based Classroom II Program           2019   pk_12_total 8 * *   0 0     0   0   * *     0             10   10 8       0 0     0   0           0       10   10
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
2452848 2452848 CT     school   1440011   Trumbull School District   1440611 Educating Learners in Transitional Environments (ELITE) Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             10   10   0     0 0     0   0           0       10   10
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
2451986 2451986 CT     school 901320 450011   East Lyme School District 90132000223 456111 East Lyme High School Public Schools Regular School No High 09 12 2019   pk_12_total 750 23 74   * 96     *   53   506 496     *             132   1002 750 23 74     96         53   506 496             132   1002
2452940 2452940 CT     school 904830 1510011   Waterbury School District 90483000992 1516311 Wilby High School Public Schools Regular School No High 09 12 2019   pk_12_total 100 284 590   * *     0   19   545 457     177             239   1002 100 284 590           0   19   545 457     177       239   1002

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