enrollments

Data source: Big Local News · About: Big Local

20,216 rows where state = "CT" and year = 2021 sorted by female_int

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2021 · 20,016 ✖
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
2758406 2758406 CT     school   1430011   Torrington School District   1430611 TPS Preschool Lab Program           2021   pk_12_total 14 0 *   0 *     0   0   * *     0             *   18 14 0     0       0   0           0           18
2758408 2758408 CT     school 904590 1430011   Torrington School District 90459001211 1431311 Vogel-Wetmore School Public Schools Regular School No Elementary KG 03 2021   pk_12_total 299 14 171   0 17     *   *   266 *     78             76   514 299 14 171   0 17             266       78       76   514
2758410 2758410 CT     school 904590 1430011   Torrington School District 90459000925 1435111 Torrington Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 550 40 318   * 44     *   34   516 *     77             170   988 550 40 318     44         34   516       77       170   988
2758411 2758411 CT     school 904590 1430011   Torrington School District 90459000924 1436111 Torrington High School Public Schools Regular School No High 09 12 2021   pk_12_total 444 55 301   * 49     *   33   452 *     74             156   888 444 55 301     49         33   452       74       156   888
2758412 2758412 CT     school   1430011   Torrington School District   1430311 Post Secondary Transition Services Program           2021   pk_12_total 8 * *   0 0     0   0   * *     0             11   11 8       0 0     0   0           0       11   11
2758424 2758424 CT     school   1440011   Trumbull School District 90462001669 1440211 Trumbull Alternative School Program           2021   pk_12_total 10 * *   0 *     0   0   * *     0             0   15 10       0       0   0           0       0   15
2758431 2758431 CT     school   1460011   Vernon School District   1461111 Elementary Activities Based Learning Program Program           2021   pk_12_total * * *   0 *     0   *   * *     0             11   11         0       0               0       11   11
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
2758442 2758442 CT     school   1480011   Wallingford School District   1480711 STARS Primary Program Program           2021   pk_12_total 7 0 *   0 *     0   0   * *     *             13   13 7 0     0       0   0                   13   13
2758443 2758443 CT     school   1480011   Wallingford School District   1481611 WISE Primary Program Program           2021   pk_12_total * 0 *   0 0     0   *   * *     0             8   8   0     0 0     0               0       8   8
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                        
2758446 2758446 CT     school 904740 1480011   Wallingford School District 90474001213 1480311 Parker Farms School Public Schools Regular School No Elementary 03 05 2021   pk_12_total 150 * 71   0 8     0   *   122 *     25             44   239 150   71   0 8     0       122       25       44   239
2758449 2758449 CT     school   1480011   Wallingford School District   1481111 STARS Intermediate Program Program           2021   pk_12_total * 0 *   0 0     0   *   * *     *             7   7   0     0 0     0                       7   7
2758450 2758450 CT     school   1480011   Wallingford School District 90474001595 1489211 WISE Intermediate Program Program           2021   pk_12_total * 0 *   0 0     0   0   * *     0             8   8   0     0 0     0   0           0       8   8
2758451 2758451 CT     school   1480011   Wallingford School District   1481511 Ben Haven ABC Middle School Program Program           2021   pk_12_total * 0 *   0 *     0   0   * *     *             7   7   0     0       0   0                   7   7
2758453 2758453 CT     school   1480011   Wallingford School District   1481311 Inspire Middle School Program           2021   pk_12_total * * 6   0 *     0   *   * *     *             14   14     6   0       0                       14   14
2758458 2758458 CT     school   1480011   Wallingford School District 90474001594 1489111 Wallingford Transition Academy Program           2021   pk_12_total 9 0 *   0 *     0   0   * *     *             13   13 9 0     0       0   0                   13   13
2758480 2758480 CT     school   1510011   Waterbury School District   1510111 Bunker Hill BDLC Program           2021   pk_12_total * * 10   0 0     0   0   * *     *             20   20     10   0 0     0   0                   20   20
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            
2758490 2758490 CT     school   1510011   Waterbury School District   1512411 Reed ESC Program           2021   pk_12_total * * 16   0 *     0   *   * *     *             25   25     16   0       0                       25   25
2758493 2758493 CT     school   1510011   Waterbury School District   1511211 Woodrow Wilson BDLC Program           2021   pk_12_total * * 10   0 0     0   *   * *     *             18   18     10   0 0     0                       18   18
2758495 2758495 CT     school   1510011   Waterbury School District   1512911 North End Autism Program           2021   pk_12_total * 7 8   0 *     0   *   * *     *             18   18   7 8   0       0                       18   18
2758496 2758496 CT     school   1510011   Waterbury School District   1513711 North End BDLC Program           2021   pk_12_total * * 18   0 0     0   0   * *     *             27   27     18   0 0     0   0                   27   27
2758499 2758499 CT     school   1510011   Waterbury School District   1514811 North End SCOPE Program           2021   pk_12_total * * 7   0 0     0   *   * *     *             11   11     7   0 0     0                       11   11
2758500 2758500 CT     school   1510011   Waterbury School District   1514411 Wallace BDLC Program           2021   pk_12_total * * 11   0 0     0   *   * *     0             *   18     11   0 0     0               0           18
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
2758504 2758504 CT     school   1510011   Waterbury School District   1514711 West Side BDLC Program           2021   pk_12_total * * 10   0 0     0   *   * *     *             18   18     10   0 0     0                       18   18
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
2758509 2758509 CT     school   1510011   Waterbury School District   1511811 North End ESC Program           2021   pk_12_total * 0 *   0 0     0   0   * *     0             9   9   0     0 0     0   0           0       9   9
2758513 2758513 CT     school   1510011   Waterbury School District   1514511 Wilby Autism Program           2021   pk_12_total * * 10   0 0     0   0   * *     *             19   19     10   0 0     0   0                   19   19
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            
2758525 2758525 CT     school   1520011   Waterford School District   1520311 Avery Point Transition Program Program           2021   pk_12_total * 0 *   0 0     0   0   * *     0             12   12   0     0 0     0   0           0       12   12
2758531 2758531 CT     school   1530011   Watertown School District   1530811 Watertown Transition Academy Program           2021   pk_12_total 8 0 0   0 0     0   0   * *     0             8   8 8 0 0   0 0     0   0           0       8   8
2758534 2758534 CT     school 904920 1550011   West Hartford School District 90492001217 1551711 Smith School Public Schools Regular School No Elementary PK 05 2021   pk_12_total 114 43 102   0 59     0   6   180 *     65             44   324 114 43 102   0 59     0   6   180       65       44   324
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
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                        
2758552 2758552 CT     school 904920 1550011   West Hartford School District 90492001013 1556111 Conard High School Public Schools Regular School No High 09 12 2021   pk_12_total 810 118 276   * 190     *   56   726 *     53             192   1453 810 118 276     190         56   726       53       192   1453
2758553 2758553 CT     school 904920 1550011   West Hartford School District 90492001015 1556211 Hall High School Public Schools Regular School No High 09 12 2021   pk_12_total 889 141 228   * 156     *   74   756 *     46             162   1492 889 141 228     156         74   756       46       162   1492
2758562 2758562 CT     school   1560011   West Haven School District 90495001799 1560111 Life Skills Program           2021   pk_12_total * * *   0 *     0   0   * *     *             12   12         0       0   0                   12   12
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            
2758584 2758584 CT     school   1580011   Westport School District   1580211 GFS Intensive Resource Program           2021   pk_12_total * 0 *   0 *     0   0   * *     0             8   8   0     0       0   0           0       8   8
2758586 2758586 CT     school 905040 1580011   Westport School District 90504001058 1586111 Staples High School Public Schools Regular School No High 09 12 2021   pk_12_total 1483 37 97   0 119     0   68   912 *     10             252   1804 1483 37 97   0 119     0   68   912       10       252   1804
2758596 2758596 CT     school   1590011   Wethersfield School District   1590111 Wethersfield Transition Academy Program           2021   pk_12_total 7 * *   0 0     0   0   * *     0             11   11 7       0 0     0   0           0       11   11
2758602 2758602 CT     school   1610011   Wilton School District   1610211 Genesis Program           2021   pk_12_total * 0 *   0 0     0   0   * *     0             *   14   0     0 0     0   0           0           14
2758604 2758604 CT     school   1610011   Wilton School District   1610311 Community Steps Program           2021   pk_12_total * 0 *   0 0     0   0   * *     0             8   8   0     0 0     0   0           0       8   8
2758612 2758612 CT     school   1630011   Windham School District   1631111 Sweeney ASD Program Program           2021   pk_12_total * 0 15   0 0     0   *   * *     *             17   17   0 15   0 0     0                       17   17
2758619 2758619 CT     school   1630011   Windham School District   1631211 Assisted Work Program Program           2021   pk_12_total * 0 *   0 0     0   0   * *     *             13   13   0     0 0     0   0                   13   13
2758620 2758620 CT     school   1630011   Windham School District   1631411 Assisted Work Program at WHS Program           2021   pk_12_total * 0 *   0 0     0   0   * *     *             6   6   0     0 0     0   0                   6   6
2758639 2758639 CT     school   1660011   Wolcott School District 90528001783 1660311 ABC Classroom Program           2021   pk_12_total * 0 0   0 0     0   *   * *     0             7   7   0 0   0 0     0               0       7   7
2758641 2758641 CT     school   1660011   Wolcott School District 90528001772 1660411 Phoenix Program Program           2021   pk_12_total * * *   0 0     0   0   * *     *             6   6         0 0     0   0                   6   6
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
2758662 2758662 CT     school 900780 260011   Chester School District 90078000130 260111 Chester Elementary School Public Schools Regular School No Elementary KG 06 2021   pk_12_total 173 0 16   0 *     0   *   103 *     *             25   201 173 0 16   0       0       103               25   201
2758677 2758677 CT     school   2040012   Regional School District 04   2040112 Region 4 Transition Academy Program           2021   pk_12_total 9 * 0   0 *     0   0   * *     0             11   11 9   0   0       0   0           0       11   11
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            
2758689 2758689 CT     school 903750 2080012   Regional School District 08 90375001210 2085112 RHAM Middle School Regional Schools Regular School No Middle 07 08 2021   pk_12_total 336 * 36   0 *     0   10   201 *     *             55   390 336   36   0       0   10   201               55   390
2758690 2758690 CT     school 903750 2080012   Regional School District 08 90375000772 2086112 RHAM High School Regional Schools Regular School No High 09 12 2021   pk_12_total 808 8 49   * 20     *   *   456 *     *             111   889 808 8 49     20             456               111   889
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            
2758704 2758704 CT     school 900014 2680013   Common Ground High School District 90001400807 2686113 Common Ground High School Public Charter Schools Regular School Yes High 09 12 2021   pk_12_total 52 78 98   0 0     *   *   136 *     11             56   236 52 78 98   0 0             136       11       56   236
2758707 2758707 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201138 9001916 E. C. Goodwin Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   pk_12_total 181 58 403   0 *     *   30   375 *     25             70   677 181 58 403   0           30   375       25       70   677
2758713 2758713 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201144 9001216 Henry Abbott Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   pk_12_total 326 23 333   0 *     *   21   425 *     34             93   713 326 23 333   0           21   425       34       93   713
2758716 2758716 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201147 9002016 Norwich Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   pk_12_total 437 51 135   * 8     *   43   413 *     16             61   681 437 51 135     8         43   413       16       61   681
2758718 2758718 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201149 9002616 Platt Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   pk_12_total 297 123 364   * 9     *   27   516 *     22             115   824 297 123 364     9         27   516       22       115   824
2758719 2758719 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201150 9001816 Vinal Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   pk_12_total 274 27 77   0 *     *   25   301 *     7             78   405 274 27 77   0           25   301       7       78   405
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            
2758724 2758724 CT     school 900018 2720013   Explorations District 90001800834 2726113 Explorations Public Charter Schools Regular School Yes High 09 12 2021   pk_12_total 68 * 13   0 0     0   *   45 *     0             33   86 68   13   0 0     0       45       0       33   86
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
2758730 2758730 CT     school   2190012   Regional School District 19   2190312 STAAR Program Program           2021   pk_12_total 10 * *   0 *     0   *   * *     0             16   16 10       0       0               0       16   16
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
2757295 2757295 CT     school   20011   Ansonia School District   20411 P.A.C.E. - PM (Positive And Creative Education - PM) Program           2021   pk_12_total * * 0   0 0     0   *   6 0     0             *   6     0   0 0     0       6 0     0           6
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            
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            
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            
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    
2757489 2757489 CT     school   320011   Coventry School District 90096001787 320111 Coventry Academy Public Schools           2021   pk_12_total 9 0 *   0 0     0   *   12 0     0             *   12 9 0     0 0     0       12 0     0           12
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            
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            
2757604 2757604 CT     school   490011   Enfield School District 90147001792 490311 Henry Barnard - Autism Spectrum Disorder (ASD) Program           2021   pk_12_total * * 0   0 0     0   0   8 0     0             8   8     0   0 0     0   0   8 0     0       8   8
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            
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            
2757758 2757758 CT     school   640011   Hartford School District   640810 iGOAL Pre-K - Rawson School Program           2021   pk_12_total * 0 *   0 *     0   0   7 0     0             7   7   0     0       0   0   7 0     0       7   7
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            
2757808 2757808 CT     school   2450014   Learn   2451614 LEARN SAILS Program Program           2021   pk_12_total 11 * *   0 0     0   *   22 0     *             22   22 11       0 0     0       22 0             22   22
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
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            
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            
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            
2758018 2758018 CT     school   930011   New Haven School District   930410 West Rock Integrated PK Program           2021   pk_12_total * * *   0 0     0   0   7 0     0             *   7         0 0     0   0   7 0     0           7
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            
2758255 2758255 CT     school   1190011   Rocky Hill School District   1190711 Rocky Hill DREAM Transition Academy Program           2021   pk_12_total * * *   0 *     0   *   8 0     0             8   8         0       0       8 0     0       8   8
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            
2758298 2758298 CT     school 904170 1320011   South Windsor School District 90417000826 1320311 Alternative Education Program Program Regular School No High 09 12 2021   pk_12_total * * *   0 0     0   0   9 0     0             *   9         0 0     0   0   9 0     0           9

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