Data source: Big Local News · About: Big Local

4,354 rows where grade = "pk_12_total" and state = "CT" sorted by total_int

View and edit SQL

year

grade

  • pk_12_total · 4,354
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 CT     school   640011   Hartford School District   649811 iGOAL 1 - Moylan School             2019   pk_12_total 0 * *   0 0     0   *   * *     *             *   * 0       0 0     0                            
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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            
2757296 CT     school   20011   Ansonia School District   21011 Ansonia 18-21 Transition Program Program           2021   pk_12_total * 0 *   0 0     0   0   * 0     *             *   *   0     0 0     0   0     0                  
2757320 CT     school   90011   Bethel School District   90211 Community Partnership Program Program           2021   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2757331 CT     school   120011   Bolton School District   120211 Bolton Transition Program Program           2021   pk_12_total * 0 0   0 0     0   0   0 *     0             *   *   0 0   0 0     0   0   0       0            
2757388 CT     school   170011   Bristol School District 90051001646 172111 Hubbell/Extended Resource Program           2021   pk_12_total 0 0 *   0 *     0   0   * *     0             *   * 0 0     0       0   0           0            
2757395 CT     school   170011   Bristol School District 90051001726 172511 Mt. View GOAL Program           2021   pk_12_total * 0 0   0 0     0   *   * 0     0             *   *   0 0   0 0     0         0     0            
2757397 CT     school   170011   Bristol School District   172211 Ivy Drive Extended Resource Program           2021   pk_12_total 0 0 *   0 0     0   0   * 0     0             *   * 0 0     0 0     0   0     0     0            
2757400 CT     school   170011   Bristol School District   172411 Mt. View Extended Resource Program           2021   pk_12_total * 0 *   0 0     0   0   * *     0             *   *   0     0 0     0   0           0            
2757401 CT     school   170011   Bristol School District 90051001711 173111 South Side GOAL Program           2021   pk_12_total * * *   0 0     0   *   * *     0             *   *         0 0     0               0            
2757404 CT     school   170011   Bristol School District   171611 Chippens Hill Middle School Medically Fragile Program           2021   pk_12_total * 0 0   0 *     0   0   * *     0             *   *   0 0   0       0   0           0            
2757410 CT     school   170011   Bristol School District 90051001661 170911 Greene-Hills GOAL Program           2021   pk_12_total 0 0 *   0 0     0   0   * 0     *             *   * 0 0     0 0     0   0     0                  
2757458 CT     school   250011   Cheshire School District   251111 Doolittle Bridges Program Program           2021   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2757463 CT     school   250011   Cheshire School District 90075001766 250311 Cheshire Quinnipiac University Transition Collaborative Program           2021   pk_12_total * 0 0   0 *     0   0   * *     0             *   *   0 0   0       0   0           0            
2757472 CT     school   280011   Colchester School District   280511 Bacon Academy Alternative Education Program           2021   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2757473 CT     school   280011   Colchester School District   280711 Community Transition Academy of Colchester Program           2021   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2757478 CT     school   2430014   Cooperative Educational Services   2430314 Eastern Fairfield County Diagnostic Center Program           2021   pk_12_total 0 * 0   * 0     0   0   * 0     0             0   * 0   0     0     0   0     0     0       0    
2757534 CT     school   410011   East Haddam School District   410311 East Haddam Cooperative Transition Program Program           2021   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2757588 CT     school   2420014   EdAdvance   2420314 Steps-North Expelled Student Program           2021   pk_12_total 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]);