Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2020 · 1,361

grade

  • pk_12_total · 1,361
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
2778701 CT     school   1190011   Rocky Hill School District   1190311 Pathways Program           2020   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2778702 CT     school   1190011   Rocky Hill School District   1190711 Rocky Hill DREAM Transition Academy Program           2020   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2778715 CT     school   1260011   Shelton School District   1260111 Pre-Kindergarten Program           2020   pk_12_total 22 * 7   0 *     0   0   26 *     0             *   31 22   7   0       0   0   26       0           31
2778719 CT     school   1260011   Shelton School District   1261211 Therapeutic Learning Center Program           2020   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2778720 CT     school   1260011   Shelton School District   1260311 Life Skills Program           2020   pk_12_total * 0 0   0 0     0   *   * *     0             *   *   0 0   0 0     0               0            
2778744 CT     school 904170 1320011   South Windsor School District 90417000826 1320311 Alternative Education Program Program Regular School No High 09 12 2020   pk_12_total 6 * *   0 0     0   0   9 0     0             *   9 6       0 0     0   0   9 0     0           9
2778807 CT     school   1370011   Stonington School District   1370911 The Learning Annex Program           2020   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2778822 CT     school   1380011   Stratford School District   1382711 ALL Class Room - Second Hill Lane Program           2020   pk_12_total * * *   0 0     0   0   * 0     0             *   *         0 0     0   0     0     0            
2778850 CT     school   1420011   Tolland School District   1420611 Tolland Transition Academy Program           2020   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2778852 CT     school   1430011   Torrington School District   1430611 TPS Preschool Lab Program           2020   pk_12_total 15 0 *   0 *     0   0   11 7     0             *   18 15 0     0       0   0   11 7     0           18
2778891 CT     school   1480011   Wallingford School District   1481411 Ben Haven ABC Primary Program             2020   pk_12_total * 0 0   0 *     0   0   * *     *             *   *   0 0   0       0   0                        
2778892 CT     school   1480011   Wallingford School District   1480611 Benhaven ABC Intermediate Program Program           2020   pk_12_total * 0 *   0 0     0   0   * *     *             *   *   0     0 0     0   0                        
2778900 CT     school   1480011   Wallingford School District   1481511 Ben Haven ABC Middle School Program Program           2020   pk_12_total * 0 *   0 0     0   0   * *     *             *   *   0     0 0     0   0                        
2778934 CT     school   1510011   Waterbury School District   1516911 Gilmartin Scope Program           2020   pk_12_total * * 13   0 0     0   0   10 8     7             *   18     13   0 0     0   0   10 8     7           18
2778942 CT     school   1510011   Waterbury School District   1511211 Woodrow Wilson BDLC Program           2020   pk_12_total * * 15   0 0     0   *   * *     *             *   21     15   0 0     0                           21
2778943 CT     school   1510011   Waterbury School District   1517211 Hearing Lab Program           2020   pk_12_total 0 0 *   * 0     0   0   * 0     0             *   * 0 0       0     0   0     0     0            
2778976 CT     school   1520011   Waterford School District   1520311 Avery Point Transition Program Program           2020   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2778982 CT     school   1530011   Watertown School District   1530811 Watertown Transition Academy Program           2020   pk_12_total * 0 0   0 *     0   0   * 0     0             *   *   0 0   0       0   0     0     0            
2778992 CT     school   1550011   West Hartford School District   1559711 Morley Learning Center Program           2020   pk_12_total * 0 0   0 0     0   *   * 0     0             *   *   0 0   0 0     0         0     0            
2779015 CT     school   1560011   West Haven School District   1561111 ASD Lab             2020   pk_12_total * 0 *   0 *     0   0   * *     0             *   *   0     0       0   0           0            
2779018 CT     school   1560011   West Haven School District   1560711 Blended Program           2020   pk_12_total 6 * *   0 0     0   0   * *     0             *   11 6       0 0     0   0           0           11
2779019 CT     school   1560011   West Haven School District   1560511 Blended (Molloy) Program           2020   pk_12_total * 0 *   0 0     0   0   0 6     0             *   6   0     0 0     0   0   0 6     0           6
2779029 CT     school   1570011   Weston School District   1570311 Post-High School Community Class Transition Program Program           2020   pk_12_total 0 0 0   0 0     0   *   0 *     0             *   * 0 0 0   0 0     0       0       0            
2779037 CT     school   1580011   Westport School District   1580111 LLS Intensive Resource Program           2020   pk_12_total * 0 *   0 *     0   0   * 0     0             *   *   0     0       0   0     0     0            
2779046 CT     school   1590011   Wethersfield School District   1590311 STRIVE Program           2020   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2779055 CT     school   1610011   Wilton School District   1610211 Genesis Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             *   10   0     0 0     0   0           0           10
2779068 CT     school   1630011   Windham School District   1630911 Sweeney Medically Fragile Program Program           2020   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2779069 CT     school   1630011   Windham School District   1630711 Natchaug Emotional Disturbance Program Program           2020   pk_12_total * * *   0 0     0   0   * 0     *             *   *         0 0     0   0     0                  
2779073 CT     school   1630011   Windham School District   1631411 Assisted Work Program at WHS Program           2020   pk_12_total * 0 *   0 0     0   0   * *     *             *   *   0     0 0     0   0                        
2779090 CT     school   1660011   Wolcott School District 90528001783 1660311 ABC Classroom Program           2020   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2779113 CT     school 901360 2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN) 90136001937 2530314 LEAP Alternative High School Regional Education Service Center Schools Alternative School No High 10 12 2020   pk_12_total * 0 8   0 0     0   *   * *     *             *   11   0 8   0 0     0                           11
2779117 CT     school   2010012   Regional School District 01   2010312 SELC Program           2020   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2779122 CT     school   3470015   Unified School District #2 90000400475 3470115 Children's Place School State Agency Facilities           2020   pk_12_total * * 11   0 0     0   0   22 0     *             *   22     11   0 0     0   0   22 0                 22
2779133 CT     school   2070012   Regional School District 07 90372001399 2079012 FLEX Program           2020   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2779146 CT     school   3360015   Unified School District #1 90000300343 3360115 Bridgeport Correctional Center State Agency Facilities           2020   pk_12_total 0 0 *   0 0     0   0   * 0     0             *   * 0 0     0 0     0   0     0     0            
2779149 CT     school   3360015   Unified School District #1 90000301349 3362615 Northern Correctional Institution State Agency Facilities           2020   pk_12_total 0 * 0   0 0     0   0   * 0     0             *   * 0   0   0 0     0   0     0     0            
2779150 CT     school   3360015   Unified School District #1 90000300454 3361915 Garner Correctional Institution State Agency Facilities           2020   pk_12_total 0 * 0   0 0     0   0   * 0     0             *   * 0   0   0 0     0   0     0     0            
2779151 CT     school   3360015   Unified School District #1 90000300361 3360615 Hartford Correctional Center State Agency Facilities           2020   pk_12_total 0 0 *   0 0     0   0   * 0     0             *   * 0 0     0 0     0   0     0     0            
2779152 CT     school   3360015   Unified School District #1 90000300408 3361215 Osborn Correctional Institution State Agency Facilities           2020   pk_12_total 0 * *   0 0     0   0   * 0     0             *   * 0       0 0     0   0     0     0            
2779153 CT     school   3360015   Unified School District #1 90000300436 3361515 Willard/Cybulski Correctional Institution State Agency Facilities           2020   pk_12_total 0 * 0   0 0     0   0   * 0     0             *   * 0   0   0 0     0   0     0     0            
2779154 CT     school   3360015   Unified School District #1 90000300419 3361315 Robinson Correctional Institution State Agency Facilities           2020   pk_12_total 0 * 0   0 0     0   0   * 0     0             *   * 0   0   0 0     0   0     0     0            
2779175 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010322 Alternative Pathways to Success Program Regular School No High 09 12 2020   pk_12_total * * 0   0 0     0   0   * *     0             *   11     0   0 0     0   0           0           11
2779176 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010222 Night School Program Regular School No High 09 12 2020   pk_12_total * * *   0 0     *   *   7 7     0             *   14         0 0             7 7     0           14
2779183 CT     school   3370015   Department of Mental Health and Addiction Services 90002701539 3370215 Connecticut Valley Hospital State Agency Facilities           2020   pk_12_total * * *   0 0     0   0   * *     0             *   *         0 0     0   0           0            
2779184 CT     school   3370015   Department of Mental Health and Addiction Services 90002701537 3370515 Greater Bridgeport Community Mental Health Center State Agency Facilities           2020   pk_12_total 0 0 *   0 0     0   0   * 0     0             *   * 0 0     0 0     0   0     0     0            
2779185 CT     school   3370015   Department of Mental Health and Addiction Services 90002701922 3370915 Whiting Forensic Hospital State Agency Facilities           2020   pk_12_total 0 0 *   0 0     0   0   0 *     0             *   * 0 0     0 0     0   0   0       0            
2777861 CT     school   170011   Bristol School District 90051001746 173311 Bristol Preparatory Academy Program           2020   pk_12_total 26 * 11   0 0     0   *   32 8     0             0   40 26   11   0 0     0       32 8     0       0   40
2777885 CT     school   2410014   Capitol Region Education Council   2411414 River Street School Early Learning Center Program           2020   pk_12_total * * *   0 0     0   0   * *     0             0   9         0 0     0   0           0       0   9
2778031 CT     school   2420014   EdAdvance   2420414 ACCESS-South Expelled Student Program           2020   pk_12_total * 0 0   0 0     0   0   * 0     0             0   *   0 0   0 0     0   0     0     0       0    
2778351 CT     school   830011   Middletown School District 90249001657 831611 Evening Program - MHS Program           2020   pk_12_total * 6 *   0 0     0   *   8 7     0             0   15   6     0 0     0       8 7     0       0   15
2778396 CT     school   880011   Naugatuck School District   880911 Genesis Academy Program           2020   pk_12_total * * *   0 0     0   0   * *     *             0   11         0 0     0   0                   0   11
2778678 CT     school   2180012   Regional School District 18   2180412 Alternative Program Program           2020   pk_12_total 0 0 *   0 0     0   0   * 0     0             0   * 0 0     0 0     0   0     0     0       0    
2778809 CT     school   1370011   Stonington School District   1370711 SAILS Program           2020   pk_12_total * * 0   0 0     0   0   * 0     0             0   *     0   0 0     0   0     0     0       0    
2778849 CT     school   1420011   Tolland School District 90456001738 1420311 TALC Program           2020   pk_12_total 6 0 0   0 0     0   0   * *     0             0   6 6 0 0   0 0     0   0           0       0   6
2778871 CT     school   1440011   Trumbull School District 90462001669 1440211 Trumbull Alternative School Program           2020   pk_12_total 15 0 *   0 *     0   0   * *     0             0   18 15 0     0       0   0           0       0   18
2779002 CT     school   1550011   West Hartford School District 90492001791 1557311 REACH Program           2020   pk_12_total 7 * 22   0 *     0   0   23 11     *             0   34 7   22   0       0   0   23 11             0   34
2779006 CT     school   1550011   West Hartford School District   1550111 Alternative Educational Program Program           2020   pk_12_total 0 0 *   0 0     0   0   * 0     0             0   * 0 0     0 0     0   0     0     0       0    
2779060 CT     school   1630011   Windham School District 90519000307 1638011 Early Headstart Program           2020   pk_12_total * 0 26   0 *     0   0   16 15     0             0   31   0 26   0       0   0   16 15     0       0   31
2779085 CT     school   1640011   Windsor School District   1640411 Expulsion Program           2020   pk_12_total 0 * 0   0 0     0   0   * 0     0             0   * 0   0   0 0     0   0     0     0       0    
2777862 CT     school   170011   Bristol School District   170211 ACCESS Program           2020   pk_12_total * * *   0 0     0   *   * *     0             10   10         0 0     0               0       10   10
2778019 CT     school   450011   East Lyme School District 90132001730 450511 Abilities in Motion (AIM) Program Program           2020   pk_12_total * * 0   0 0     0   0   * *     *             10   10     0   0 0     0   0                   10   10
2778043 CT     school   490011   Enfield School District 90147000207 498011 Head Start Program Program           2020   pk_12_total 59 * 29   0 *     0   9   55 47     0             10   102 59   29   0       0   9   55 47     0       10   102
2778169 CT     school   620011   Hamden School District   620611 Hamden Transition Academy @ SCSU (AACPB) Program           2020   pk_12_total * 7 0   0 *     0   0   * *     *             10   10   7 0   0       0   0                   10   10
2778190 CT     school   640011   Hartford School District   640610 Pre-K Integrated - West Middle School Program           2020   pk_12_total * 7 7   0 *     0   0   10 8     0             10   18   7 7   0       0   0   10 8     0       10   18
2778318 CT     school   800011   Meriden School District   801511 STARS-MS Program           2020   pk_12_total * * *   0 0     0   *   * *     *             10   10         0 0     0                       10   10
2778456 CT     school   930011   New Haven School District   930510 Lincoln Bassett Integrated PK Program           2020   pk_12_total 0 * *   0 0     0   0   * *     0             10   10 0       0 0     0   0           0       10   10
2778474 CT     school   930011   New Haven School District   930310 Lincoln Bassett Self Contained Program           2020   pk_12_total 0 * *   0 0     0   0   * *     0             10   10 0       0 0     0   0           0       10   10
2778481 CT     school   930011   New Haven School District   938611 Wexler Grant Self Contained Program           2020   pk_12_total * 7 *   0 0     0   0   * *     0             10   10   7     0 0     0   0           0       10   10
2778562 CT     school 903090 1030011   Norwalk School District 90309001917 1030511 Center for Global Studies Public Schools Regular School No High 09 12 2020   pk_12_total 120 38 83   0 29     0   7   90 187     *             10   277 120 38 83   0 29     0   7   90 187             10   277
2778567 CT     school   1030011   Norwalk School District   1030611 Norwalk 18-21 Project SEARCH Program           2020   pk_12_total * 0 *   0 0     0   0   * *     *             10   10   0     0 0     0   0                   10   10
2778639 CT     school 903530 2120012   Regional School District 12 90353000731 2120212 Booth Free School Regional Schools Regular School No Elementary KG 05 2020   pk_12_total 65 * *   0 *     0   *   32 39     *             10   71 65       0       0       32 39             10   71
2778718 CT     school   1260011   Shelton School District   1261311 Alternative Learning Center 2 Program           2020   pk_12_total * 0 0   0 *     0   0   * *     *             10   10   0 0   0       0   0                   10   10
2778828 CT     school   1380011   Stratford School District   1380111 BRIDGES 9-12 Program           2020   pk_12_total * 0 *   0 0     0   0   * *     *             10   10   0     0 0     0   0                   10   10
2778831 CT     school   1380011   Stratford School District 90444001710 1382011 STEPS 9-12 Program           2020   pk_12_total * * *   0 0     0   0   * *     0             10   10         0 0     0   0           0       10   10
2778951 CT     school   1510011   Waterbury School District   1511811 North End ESC Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             10   10   0     0 0     0   0           0       10   10
2778959 CT     school   1510011   Waterbury School District   1515611 West Side Bilingual Program           2020   pk_12_total * 0 *   0 0     0   0   40 34     *             10   74   0     0 0     0   0   40 34             10   74
2779014 CT     school   1560011   West Haven School District 90495001799 1560111 Life Skills Program           2020   pk_12_total * * *   0 0     0   0   * *     *             10   10         0 0     0   0                   10   10
2779103 CT     school 900630 210011   Canaan School District 90063000115 210111 Lee H. Kellogg School Public Schools Regular School No Elementary KG 08 2020   pk_12_total 63 0 *   0 0     0   *   38 29     *             10   67 63 0     0 0     0       38 29             10   67
2777741 CT     school   2440014   Area Cooperative Educational Services 90007001502 2449214 Whitney Academy Program           2020   pk_12_total 43 22 30   0 *     0   *   75 25     *             100   100 43 22 30   0       0       75 25             100   100
2778560 CT     school 903090 1030011   Norwalk School District 90309000661 1035411 West Rocks Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 166 123 385   * 32     0   *   368 348     114             100   716 166 123 385     32     0       368 348     114       100   716
2778583 CT     school 903120 1040011   Norwich School District 90312000674 1045211 Teachers' Memorial Global Studies Magnet Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 104 71 143   * 25     *   44   202 194     66             100   396 104 71 143     25         44   202 194     66       100   396
2778987 CT     school 904920 1550011   West Hartford School District 90492001025 1551311 Whiting Lane School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 180 29 69   0 40     *   *   195 140     58             100   335 180 29 69   0 40             195 140     58       100   335
2777742 CT     school   2440014   Area Cooperative Educational Services 90007001490 2449114 Whitney High School North Program           2020   pk_12_total 13 54 25   0 0     *   *   77 24     *             101   101 13 54 25   0 0             77 24             101   101
2777750 CT     school 900120 40011   Avon School District 90012000011 46111 Avon High School Public Schools Regular School No High 09 12 2020   pk_12_total 658 48 60   * 153     0   *   510 447     6             101   957 658 48 60     153     0       510 447     6       101   957
2778121 CT     school 901710 570011   Greenwich School District 90171000298 575211 Eastern Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 589 * 114   * 97     0   50   456 406     13             101   862 589   114     97     0   50   456 406     13       101   862
2778129 CT     school 901740 580011   Griswold School District 90174000311 586211 Griswold High School Public Schools Regular School No High 09 12 2020   pk_12_total 414 12 47   * 10     *   27   247 274     *             101   521 414 12 47     10         27   247 274             101   521
2778181 CT     school 901920 640011   Hartford School District 90192000368 641011 Kennelly School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 26 98 495   * 12     *   *   315 329     204             101   644 26 98 495     12             315 329     204       101   644
2778224 CT     school 901920 640011   Hartford School District 90192001572 647111 Bulkeley High School Public Schools Regular School No High 09 12 2020   pk_12_total 13 140 393   * 8     *   *   290 272     222             101   562 13 140 393     8             290 272     222       101   562
2778451 CT     school 902790 930011   New Haven School District 90279000554 931611 Fair Haven School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 32 73 682   0 40     *   *   423 410     466             101   833 32 73 682   0 40             423 410     466       101   833
2778539 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 559 27 67   0 60     0   25   385 353     11             101   738 559 27 67   0 60     0   25   385 353     11       101   738
2778558 CT     school 903090 1030011   Norwalk School District 90309000656 1035311 Ponus Ridge Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 91 109 418   * 37     0   *   346 325     123             101   671 91 109 418     37     0       346 325     123       101   671
2778636 CT     school 903520 2100012   Regional School District 10 90352000727 2105112 Har-Bur Middle School Regional Schools Regular School No Middle 05 08 2020   pk_12_total 628 * 27   * 8     0   47   391 325     *             102   716 628   27     8     0   47   391 325             102   716
2778760 CT     school 904230 1310011   Southington School District 90423000832 1315311 John F. Kennedy Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 586 * 84   * 25     0   23   374 366     8             102   740 586   84     25     0   23   374 366     8       102   740
2778811 CT     school 904440 1380011   Stratford School District 90444000895 1381011 Second Hill Lane School Public Schools Regular School No Elementary PK 06 2020   pk_12_total 159 79 192   0 18     0   31   248 231     46             102   479 159 79 192   0 18     0   31   248 231     46       102   479
2778231 CT     school   640011   Hartford School District 90192000382 646311 Weaver High School Public Schools           2020   pk_12_total * 229 178   * *     0   6   * 215     53             103   423   229 178           0   6     215     53       103   423
2778557 CT     school 903090 1030011   Norwalk School District 90309000653 1035211 Nathan Hale Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 201 91 293   0 30     0   12   342 285     60             103   627 201 91 293   0 30     0   12   342 285     60       103   627
2778787 CT     school 904320 1350011   Stamford School District 90432000868 1352111 Stillmeadow School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 192 43 344   * 39     *   31   351 301     100             103   652 192 43 344     39         31   351 301     100       103   652
2778829 CT     school 904440 1380011   Stratford School District 90444000885 1386211 Bunnell High School Public Schools Regular School No High 09 12 2020   pk_12_total 413 248 299   * 33     0   *   500 512     17             103   1012 413 248 299     33     0       500 512     17       103   1012
2777786 CT     school 900420 140011   Branford School District 90042000039 146111 Branford High School Public Schools Regular School No High 09 12 2020   pk_12_total 607 22 94   0 60     0   21   * 404     15             104   804 607 22 94   0 60     0   21     404     15       104   804
2777945 CT     school 901020 340011   Danbury School District 90102000152 340211 Hayestown Avenue School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 132 31 243   * 57     *   7   237 236     168             104   473 132 31 243     57         7   237 236     168       104   473

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