enrollments

Data source: Big Local News · About: Big Local

1,444 rows where grade = "pk_12_total", state = "CT" and year = 2021 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 1,444 ✖

grade ✖

  • pk_12_total · 1,444 ✖
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
2757296 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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                        
2757589 2757589 CT     school   2420014   EdAdvance   2420414 ACCESS-South Expelled Student Program           2021   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2757596 2757596 CT     school   480011   Ellington School District   480511 The Ellington Public Schools Expulsion Program (TEPSEP) Program           2021   pk_12_total * 0 0   0 0     0   *   * 0     0             *   *   0 0   0 0     0         0     0            
2757597 2757597 CT     school   480011   Ellington School District   480411 Ellington Continuing Life Independence Post-Secondary Education (ECLIPSE) Program           2021   pk_12_total 0 0 0   0 *     0   *   * *     0             *   * 0 0 0   0       0               0            
2757610 2757610 CT     school   490011   Enfield School District 90147001676 490511 Edgar H. Parkman - Autism Spectrum Disorder (ASD) Program           2021   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2757612 2757612 CT     school   490011   Enfield School District   491411 Eli Whitney - Intermediate Adaptive Learning (IAL) Program           2021   pk_12_total 0 * *   0 0     0   *   * *     0             *   * 0       0 0     0               0            
2757613 2757613 CT     school   490011   Enfield School District 90147001702 490711 Prudence Crandall - Educational Counseling Program (ECP) Program           2021   pk_12_total * * 0   0 0     0   *   * 0     0             *   *     0   0 0     0         0     0            
2757619 2757619 CT     school   490011   Enfield School District   490111 Enfield High - Adaptive Learning Program (ALP) Program           2021   pk_12_total * 0 0   0 *     0   0   * *     0             *   *   0 0   0       0   0           0            
2757695 2757695 CT     school   590011   Groton School District   590611 Apex Academy Program           2021   pk_12_total * * *   0 0     0   0   * *     0             *   *         0 0     0   0           0            
2757721 2757721 CT     school   620011   Hamden School District   621511 Dunbar Hill IIC Program           2021   pk_12_total * * *   0 0     0   0   * 0     0             *   *         0 0     0   0     0     0            
2757746 2757746 CT     school   640011   Hartford School District   640410 Pre-K Integrated - Parkville School Program           2021   pk_12_total 0 0 *   0 0     0   0   * 0     0             0   * 0 0     0 0     0   0     0     0       0    
2757747 2757747 CT     school   640011   Hartford School District   641110 Pre-K Integrated - SAND School Program           2021   pk_12_total 0 0 *   0 0     0   0   * 0     0             *   * 0 0     0 0     0   0     0     0            
2757803 2757803 CT     school   2450014   Learn   2451514 LEARN Integrated Program at TFS Program           2021   pk_12_total 0 * *   0 0     0   0   * 0     0             *   * 0       0 0     0   0     0     0            
2757811 2757811 CT     school   2450014   Learn 90345001795 2450614 Learn High School Program           2021   pk_12_total * * *   0 *     0   0   * *     0             *   *         0       0   0           0            
2757813 2757813 CT     school   2450014   Learn 90345001757 2450414 LEARN Transition Academy Program           2021   pk_12_total * 0 *   0 0     0   0   * *     0             *   *   0     0 0     0   0           0            
2757889 2757889 CT     school   830011   Middletown School District 90249001758 830611 ICM - Farm Hill Program           2021   pk_12_total * * *   0 0     0   0   * 0     0             *   *         0 0     0   0     0     0            
2757895 2757895 CT     school   830011   Middletown School District 90249001719 830811 ICM - Moody K-2 Program           2021   pk_12_total * * *   0 0     0   0   * *     0             *   *         0 0     0   0           0            
2757897 2757897 CT     school   830011   Middletown School District   832011 ICM - Spencer Program           2021   pk_12_total * * *   0 0     0   0   * *     0             *   *         0 0     0   0           0            
2757905 2757905 CT     school   830011   Middletown School District   832211 MHS- Alternative Education Program 3 Program           2021   pk_12_total 0 0 *   0 0     0   0   * 0     0             *   * 0 0     0 0     0   0     0     0            
2757983 2757983 CT     school   900011   New Canaan School District   900111 Launch Program           2021   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2757988 2757988 CT     school   910011   New Fairfield School District 90273001687 910311 Alternative Learning Center Program           2021   pk_12_total * 0 *   0 *     0   0   * 0     0             *   *   0     0       0   0     0     0            
2758119 2758119 CT     school   1030011   Norwalk School District   1031011 Norwalk Alternative Opportunity Program Program           2021   pk_12_total 0 * 0   0 0     0   0   * *     0             0   * 0   0   0 0     0   0           0       0    
2758139 2758139 CT     school   1040011   Norwich School District 90312001622 1049211 Virtual Learning Academy Program           2021   pk_12_total * 0 *   0 0     0   0   * *     0             *   *   0     0 0     0   0           0            
2758153 2758153 CT     school   1080011   Oxford School District   1080511 Community Explorations Program           2021   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2758165 2758165 CT     school   1100011   Plainville School District   1100111 Plainville Transition Program Program           2021   pk_12_total * * 0   0 0     0   0   * *     0             *   *     0   0 0     0   0           0            
2758181 2758181 CT     school   1160011   Putnam School District 90348001518 1169011 Helping Hands Program           2021   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2758197 2758197 CT     school   2120012   Regional School District 12   2120512 Shepaug Valley Partnership Program           2021   pk_12_total * 0 0   0 *     0   0   * *     0             *   *   0 0   0       0   0           0            
2758215 2758215 CT     school   2150012   Regional School District 15   2150112 MIJ Program Program           2021   pk_12_total * * 0   0 0     0   0   * *     0             *   *     0   0 0     0   0           0            
2758220 2758220 CT     school   2160012   Regional School District 16 90353801747 2160412 WRHS Alternative Education Program Program           2021   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2758231 2758231 CT     school   2180012   Regional School District 18   2180412 Alternative Program Program           2021   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2758237 2758237 CT     school   1180011   Ridgefield School District   1180111 District Program BMES Program           2021   pk_12_total * 0 *   0 0     0   0   * *     0             *   *   0     0 0     0   0           0            
2758239 2758239 CT     school   1180011   Ridgefield School District   1181211 District Program FES Program           2021   pk_12_total 0 0 0   0 *     0   0   * *     0             *   * 0 0 0   0       0   0           0            
2758240 2758240 CT     school   1180011   Ridgefield School District   1180711 District Program RES Program           2021   pk_12_total * 0 *   0 0     0   0   * *     0             *   *   0     0 0     0   0           0            
2758241 2758241 CT     school   1180011   Ridgefield School District   1180911 District Program SES Program           2021   pk_12_total * 0 *   0 *     0   0   * *     0             *   *   0     0       0   0           0            
2758244 2758244 CT     school   1180011   Ridgefield School District   1181011 District Program ERMS Program           2021   pk_12_total * 0 0   0 0     0   *   * *     0             *   *   0 0   0 0     0               0            
2758245 2758245 CT     school   1180011   Ridgefield School District   1181111 District Program SRMS Program           2021   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2758248 2758248 CT     school   1180011   Ridgefield School District   1181311 District Program RHS Program           2021   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2758271 2758271 CT     school   1260011   Shelton School District   1260211 Alternative Learning Center 1 Program           2021   pk_12_total * 0 0   0 0     0   *   * 0     0             *   *   0 0   0 0     0         0     0            
2758272 2758272 CT     school   1260011   Shelton School District   1261211 Therapeutic Learning Center Program           2021   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2758273 2758273 CT     school   1260011   Shelton School District   1260311 Life Skills Program           2021   pk_12_total * 0 0   0 0     0   *   * *     0             *   *   0 0   0 0     0               0            
2758309 2758309 CT     school   1310011   Southington School District   1311111 SPACE Program           2021   pk_12_total * 0 *   0 0     0   0   * *     0             *   *   0     0 0     0   0           0            
2758321 2758321 CT     school   1310011   Southington School District 90423001649 1311211 Collaborative Learning Program (CLP) Program           2021   pk_12_total * * *   0 0     0   *   * *     0             *   *         0 0     0               0            
2758355 2758355 CT     school   1350011   Stamford School District   1351311 PAVE (Post-Secondary Adaptive Vocational Experience) Program           2021   pk_12_total * * *   0 0     0   0   * *     0             *   *         0 0     0   0           0            
2758361 2758361 CT     school   1370011   Stonington School District   1370911 The Learning Annex Program           2021   pk_12_total * * 0   0 0     0   0   * 0     0             *   *     0   0 0     0   0     0     0            
2758362 2758362 CT     school   1370011   Stonington School District   1370711 SAILS Program           2021   pk_12_total * 0 0   0 0     0   *   * *     0             0   *   0 0   0 0     0               0       0    
2758372 2758372 CT     school   1380011   Stratford School District   1382311 DLC Whitney Program           2021   pk_12_total * * *   0 0     0   0   * *     0             *   *         0 0     0   0           0            
2758375 2758375 CT     school   1380011   Stratford School District   1382711 ALL Class Room - Second Hill Lane Program           2021   pk_12_total * * 0   0 0     0   0   * 0     0             *   *     0   0 0     0   0     0     0            
2758378 2758378 CT     school   1380011   Stratford School District 90444001756 1381811 Middle School Sails Program           2021   pk_12_total * 0 *   0 0     0   0   * *     0             *   *   0     0 0     0   0           0            
2758444 2758444 CT     school   1480011   Wallingford School District   1480611 Benhaven ABC Intermediate Program Program           2021   pk_12_total * 0 *   0 *     0   0   * *     *             *   *   0     0       0   0                        
2758486 2758486 CT     school   1510011   Waterbury School District   1517211 Hearing Lab Program           2021   pk_12_total * 0 *   * 0     0   0   * *     0             *   *   0       0     0   0           0            
2758520 2758520 CT     school   1520011   Waterford School District   1521111 Autism Class Program           2021   pk_12_total * 0 0   0 *     0   0   * *     0             *   *   0 0   0       0   0           0            
2758546 2758546 CT     school   1550011   West Hartford School District 90492001705 1559311 Braeburn Learning Center Program           2021   pk_12_total 0 0 *   0 0     0   0   * *     *             *   * 0 0     0 0     0   0                        
2758547 2758547 CT     school   1550011   West Hartford School District   1559711 Morley Learning Center Program           2021   pk_12_total * * *   0 0     0   0   * 0     0             *   *         0 0     0   0     0     0            
2758566 2758566 CT     school   1560011   West Haven School District   1560511 Blended (Molloy) Program           2021   pk_12_total 0 * *   0 0     0   0   * *     0             *   * 0       0 0     0   0           0            
2758576 2758576 CT     school   1570011   Weston School District   1570311 Post-High School Community Class Transition Program Program           2021   pk_12_total 0 0 0   0 0     0   *   0 *     0             *   * 0 0 0   0 0     0       0       0            
2758581 2758581 CT     school   1580011   Westport School District   1580111 LLS Intensive Resource Program           2021   pk_12_total * 0 *   0 *     0   0   * *     0             *   *   0     0       0   0           0            
2758593 2758593 CT     school   1590011   Wethersfield School District   1590311 STRIVE Program           2021   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2758616 2758616 CT     school   1630011   Windham School District   1630911 Sweeney Medically Fragile Program Program           2021   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2758634 2758634 CT     school   1640011   Windsor School District   1640411 Expulsion Program           2021   pk_12_total 0 * 0   0 0     0   0   * 0     0             0   * 0   0   0 0     0   0     0     0       0    
2758668 2758668 CT     school   2010012   Regional School District 01   2010312 SELC Program           2021   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2758682 2758682 CT     school   2070012   Regional School District 07 90372001399 2079012 FLEX Program           2021   pk_12_total * 0 *   0 0     0   0   * *     0             *   *   0     0 0     0   0           0            
2758696 2758696 CT     school   3360015   Unified School District #1 90000300849 3362515 York Correctional Institution State Agency Facilities           2021   pk_12_total * * *   0 0     0   0   0 *     0             *   *         0 0     0   0   0       0            
2758697 2758697 CT     school   3360015   Unified School District #1 90000300347 3360315 Cheshire Correctional Institution State Agency Facilities           2021   pk_12_total * * *   0 0     0   0   * 0     0             *   *         0 0     0   0     0     0            
2758698 2758698 CT     school   3360015   Unified School District #1 90000300454 3361915 Garner Correctional Institution State Agency Facilities           2021   pk_12_total 0 0 *   0 0     0   0   * 0     0             *   * 0 0     0 0     0   0     0     0            
2758699 2758699 CT     school   3360015   Unified School District #1 90000300469 3362215 MacDougall/Walker Correctional Institution State Agency Facilities           2021   pk_12_total 0 * *   0 0     0   0   * 0     0             *   * 0       0 0     0   0     0     0            
2758700 2758700 CT     school   3360015   Unified School District #1 90000300374 3360915 New Haven Correctional Center State Agency Facilities           2021   pk_12_total 0 * 0   0 0     0   0   * 0     0             *   * 0   0   0 0     0   0     0     0            
2758701 2758701 CT     school   3360015   Unified School District #1 90000300408 3361215 Osborn Correctional Institution State Agency Facilities           2021   pk_12_total 0 * 0   0 0     0   *   * 0     0             *   * 0   0   0 0     0         0     0            
2758702 2758702 CT     school   3360015   Unified School District #1 90000300343 3360115 Bridgeport Correctional Center State Agency Facilities           2021   pk_12_total 0 0 *   0 0     0   0   * 0     0             *   * 0 0     0 0     0   0     0     0            
2758703 2758703 CT     school   3360015   Unified School District #1 90000301349 3362615 Northern Correctional Institution State Agency Facilities           2021   pk_12_total 0 * 0   0 0     0   0   * 0     0             *   * 0   0   0 0     0   0     0     0            
2758722 2758722 CT     school   3370015   Department of Mental Health and Addiction Services 90002701922 3370915 Whiting Forensic Hospital State Agency Facilities           2021   pk_12_total 0 * 0   0 0     0   0   * 0     0             *   * 0   0   0 0     0   0     0     0            
2758723 2758723 CT     school   3370015   Department of Mental Health and Addiction Services 90002701539 3370215 Connecticut Valley Hospital State Agency Facilities           2021   pk_12_total 0 * 0   0 0     0   0   0 *     0             *   * 0   0   0 0     0   0   0       0            
2757390 2757390 CT     school   170011   Bristol School District 90051001755 173011 South Side Extended Resource Program           2021   pk_12_total * 0 *   0 0     0   *   * *     0             10   10   0     0 0     0               0       10   10
2757406 2757406 CT     school   170011   Bristol School District 90051001753 173411 Chms Goal Program           2021   pk_12_total * * *   0 0     0   *   * *     *             10   10         0 0     0                       10   10
2757748 2757748 CT     school   640011   Hartford School District   641510 Pre-K Integrated - Sanchez School Program           2021   pk_12_total 0 * *   0 0     0   0   * *     0             10   10 0       0 0     0   0           0       10   10
2757883 2757883 CT     school   800011   Meriden School District   801811 STARS - HS Program           2021   pk_12_total * 0 *   0 *     0   0   10 0     *             10   10   0     0       0   0   10 0             10   10
2757922 2757922 CT     school   840011   Milford School District   840611 Post Grad Transitional Academy Program           2021   pk_12_total * 0 *   0 0     0   0   * *     0             10   10   0     0 0     0   0           0       10   10
2757964 2757964 CT     school   890011   New Britain School District   892111 Smith KEY Elementary Program           2021   pk_12_total 0 * *   0 0     0   0   * *     *             10   10 0       0 0     0   0                   10   10
2757997 2757997 CT     school   930011   New Haven School District   933411 Benjamin Jepson Head Start Program           2021   pk_12_total * * *   0 0     0   0   * *     0             *   10         0 0     0   0           0           10
2758035 2758035 CT     school   930011   New Haven School District   938611 Wexler Grant Self Contained Program           2021   pk_12_total * * *   0 0     0   0   * *     0             10   10         0 0     0   0           0       10   10
2758097 2758097 CT     school   1010011   North Haven School District 90303001733 1010111 North Haven Transition Partnership Program           2021   pk_12_total 7 * *   0 *     0   0   * *     0             10   10 7       0       0   0           0       10   10
2758317 2758317 CT     school   1310011   Southington School District 90423001720 1311611 Therapeutic Educational Alternative Model (TEAM) Program           2021   pk_12_total * 0 *   0 0     0   0   * *     0             10   10   0     0 0     0   0           0       10   10
2758384 2758384 CT     school   1380011   Stratford School District 90444001710 1382011 STEPS 9-12 Program           2021   pk_12_total * * *   0 0     0   0   * *     0             10   10         0 0     0   0           0       10   10
2758433 2758433 CT     school   1460011   Vernon School District   1460811 Renaissance Program Program           2021   pk_12_total 6 0 *   0 0     0   *   * *     0             10   10 6 0     0 0     0               0       10   10
2758502 2758502 CT     school   1510011   Waterbury School District   1514911 Wallace SCOPE Program           2021   pk_12_total 0 * *   0 0     0   0   * *     *             10   10 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]);