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,427 ✖

grade ✖

  • pk_12_total · 1,427 ✖
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
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
2758507 2758507 CT     school   1510011   Waterbury School District   1515511 West Side SCOPE Program           2021   pk_12_total * * 6   0 0     0   0   * *     *             10   10     6   0 0     0   0                   10   10
2758541 2758541 CT     school   1550011   West Hartford School District 90492001681 1559411 Norfeldt Learning Center Program           2021   pk_12_total * * 0   0 *     0   0   * *     *             10   10     0   0       0   0                   10   10
2758652 2758652 CT     school   2440014   Area Cooperative Educational Services   2440414 ACES at Mead Elementary School Program           2021   pk_12_total * * *   0 0     0   *   * *     0             10   10         0 0     0               0       10   10
2758726 2758726 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010222 Night School Program Regular School No High 09 12 2021   pk_12_total * * *   0 0     0   *   * *     0             0   10         0 0     0               0       0   10
2757876 2757876 CT     school 902400 800011   Meriden School District 90240000449 806211 Orville H. Platt High School Public Schools Regular School No High 09 12 2021   pk_12_total 216 140 606   * *     0   24   494 514     138             177   1008 216 140 606           0   24   494 514     138       177   1008
2757953 2757953 CT     school   890011   New Britain School District   890111 Roosevelt Early Learning Center Program           2021   pk_12_total 15 * 69   0 0     0   *   65 36     0             55   101 15   69   0 0     0       65 36     0       55   101
2758656 2758656 CT     school   2440014   Area Cooperative Educational Services 90007001502 2449214 Whitney Academy Program           2021   pk_12_total 43 23 28   * *     *   *   74 27     *             101   101 43 23 28                   74 27             101   101
2757569 2757569 CT     school 901320 450011   East Lyme School District 90132000223 456111 East Lyme High School Public Schools Regular School No High 09 12 2021   pk_12_total 770 15 67   * 96     *   59   517 493     *             124   1010 770 15 67     96         59   517 493             124   1010
2758456 2758456 CT     school 904740 1480011   Wallingford School District 90474000955 1486111 Lyman Hall High School Public Schools Regular School No High 09 12 2021   pk_12_total 719 * 191   * 45     0   37   467 550     17             170   1017 719   191     45     0   37   467 550     17       170   1017
2758382 2758382 CT     school 904440 1380011   Stratford School District 90444000885 1386211 Bunnell High School Public Schools Regular School No High 09 12 2021   pk_12_total 393 237 330   0 32     0   30   489 533     24             107   1022 393 237 330   0 32     0   30   489 533     24       107   1022
2757508 2757508 CT     school 901020 340011   Danbury School District 90102000149 345111 Broadview Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 312 82 534   * 59     0   *   541 482     177             165   1023 312 82 534     59     0       541 482     177       165   1023
2757772 2757772 CT     school 901920 640011   Hartford School District 90192001295 645411 Hartford Magnet Trinity College Academy Public Schools Regular School No High 06 12 2021   pk_12_total 144 261 531   * 39     *   43   473 553     105             139   1026 144 261 531     39         43   473 553     105       139   1026
2757346 2757346 CT     school 900450 150011   Bridgeport School District 90045000053 154011 Blackham School Public Schools Regular School No Elementary PK 08 2021   pk_12_total 166 265 543   13 31     *   *   562 468     260             143   1030 166 265 543   13 31             562 468     260       143   1030
2757927 2757927 CT     school 902550 850011   Monroe School District 90255000489 856111 Masuk High School Public Schools Regular School No High 09 12 2021   pk_12_total 815 * 109   * 59     0   31   518 *     8             134   1033 815   109     59     0   31   518       8       134   1033
2757483 2757483 CT     school 900930 310011   Cornwall School District 90093000140 310111 Cornwall Consolidated School Public Schools Regular School No Elementary PK 08 2021   pk_12_total 83 * 12   0 7     0   *   51 53     *             11   104 83   12   0 7     0       51 53             11   104
2758731 2758731 CT     school 905373 9030022   The Woodstock Academy District 90537311223 9036122 The Woodstock Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2021   pk_12_total 900 18 38   * 73     0   *   523 *     *             74   1044 900 18 38     73     0       523               74   1044
2758385 2758385 CT     school 904440 1380011   Stratford School District 90444000897 1386111 Stratford High School Public Schools Regular School No High 09 12 2021   pk_12_total 365 270 354   0 30     0   32   525 526     51             128   1051 365 270 354   0 30     0   32   525 526     51       128   1051

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