enrollments

Data source: Big Local News · About: Big Local

60,956 rows where state = "CT" sorted by female_int

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

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
2452917 2452917 CT     school   1510011   Waterbury School District   1510111 Bunker Hill BDLC Program           2019   pk_12_total * * 17   0 0     0   0   * *     *             25   25     17   0 0     0   0                   25   25
2452919 2452919 CT     school   1510011   Waterbury School District   1516811 Duggan Scope             2019   pk_12_total * * *   0 0     0   0   * *     0             6   6         0 0     0   0           0       6   6
2452922 2452922 CT     school   1510011   Waterbury School District   1512911 North End Autism Program           2019   pk_12_total * * 7   0 *     0   0   * *     0             16   16     7   0       0   0           0       16   16
2452923 2452923 CT     school   1510011   Waterbury School District   1513711 North End BDLC Program           2019   pk_12_total 0 8 12   0 0     0   0   * *     *             20   20 0 8 12   0 0     0   0                   20   20
2452926 2452926 CT     school   1510011   Waterbury School District   1514811 North End SCOPE Program           2019   pk_12_total * * *   0 0     0   *   * *     *             10   10         0 0     0                       10   10
2452927 2452927 CT     school   1510011   Waterbury School District   1514411 Wallace BDLC Program           2019   pk_12_total * * 8   0 0     0   0   * *     0             14   14     8   0 0     0   0           0       14   14
2452931 2452931 CT     school   1510011   Waterbury School District   1514711 West Side BDLC Program           2019   pk_12_total * * 13   0 0     0   *   * *     *             23   23     13   0 0     0                       23   23
2452933 2452933 CT     school   1510011   Waterbury School District   1515511 West Side SCOPE Program           2019   pk_12_total * * 7   0 0     0   0   * *     *             9   9     7   0 0     0   0                   9   9
2452934 2452934 CT     school   1510011   Waterbury School District   1511811 North End ESC Program           2019   pk_12_total * * 6   0 0     0   0   * *     0             9   9     6   0 0     0   0           0       9   9
2452938 2452938 CT     school   1510011   Waterbury School District   1514511 Wilby Autism Program           2019   pk_12_total * * 6   0 0     0   0   * *     *             13   13     6   0 0     0   0                   13   13
2452939 2452939 CT     school   1510011   Waterbury School District   1511711 Wilby ESC Program           2019   pk_12_total * * *   0 0     0   0   * *     0             13   13         0 0     0   0           0       13   13
2452943 2452943 CT     school   1520011   Waterford School District   1521111 Autism Class Program           2019   pk_12_total * 0 0   0 0     *   0   * *     0             *   *   0 0   0 0         0           0            
2452948 2452948 CT     school 904860 1520011   Waterford School District 90486001001 1526111 Waterford High School Public Schools Regular School No High 09 12 2019   pk_12_total 643 19 98   * 52     *   20   432 *     7             138   838 643 19 98     52         20   432       7       138   838
2452949 2452949 CT     school   1520011   Waterford School District   1520311 Avery Point Transition Program Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             7   7   0     0 0     0   0           0       7   7
2452955 2452955 CT     school   1530011   Watertown School District   1530811 Watertown Transition Academy Program           2019   pk_12_total * 0 0   0 *     0   0   * *     0             *   *   0 0   0       0   0           0            
2452956 2452956 CT     school   1530011   Watertown School District   1530711 Watertown Transition Program at Post University             2019   pk_12_total 6 0 0   0 0     0   0   * *     0             6   6 6 0 0   0 0     0   0           0       6   6
2452972 2452972 CT     school   1550011   West Hartford School District 90492001780 1559511 Whiting Lane Learning Center Program           2019   pk_12_total * * *   0 0     0   *   * *     0             *   *         0 0     0               0            
2452987 2452987 CT     school   1560011   West Haven School District 90495001799 1560111 Life Skills Program           2019   pk_12_total * * 6   0 0     0   0   * *     *             11   11     6   0 0     0   0                   11   11
2452988 2452988 CT     school   1560011   West Haven School District   1561111 ASD Lab             2019   pk_12_total * 0 *   0 *     0   0   * *     0             *   *   0     0       0   0           0            
2452993 2452993 CT     school   1560011   West Haven School District   1560511 Blended (Molloy) Program           2019   pk_12_total * 0 *   0 0     0   0   0 *     0             0   *   0     0 0     0   0   0       0       0    
2453002 2453002 CT     school   1570011   Weston School District   1570311 Post-High School Community Class Transition Program Program           2019   pk_12_total 0 0 *   0 0     0   *   * *     0             *   * 0 0     0 0     0               0            
2453005 2453005 CT     school   1580011   Westport School District   1580211 GFS Intensive Resource Program           2019   pk_12_total * 0 0   0 *     0   0   * *     0             6   6   0 0   0       0   0           0       6   6
2453019 2453019 CT     school   1590011   Wethersfield School District   1590411 ABA Program           2019   pk_12_total 0 * *   0 0     0   *   * *     *             7   7 0       0 0     0                       7   7
2453023 2453023 CT     school   1590011   Wethersfield School District   1590111 Wethersfield Transition Academy Program           2019   pk_12_total 7 * *   0 0     0   0   * *     0             11   11 7       0 0     0   0           0       11   11
2453030 2453030 CT     school   1610011   Wilton School District   1610311 Community Steps Program           2019   pk_12_total 6 0 0   0 0     0   0   * *     0             6   6 6 0 0   0 0     0   0           0       6   6
2453031 2453031 CT     school 905160 1620011   Winchester School District 90516001077 1620411 Batcheller Early Education Center Public Schools Regular School No Elementary PK 02 2019   pk_12_total 210 * 20   0 *     0   *   122 *     22             48   243 210   20   0       0       122       22       48   243
2453038 2453038 CT     school   1630011   Windham School District   1631111 Sweeney ASD Program Program           2019   pk_12_total * 0 12   0 0     0   *   * *     *             15   15   0 12   0 0     0                       15   15
2453039 2453039 CT     school   1630011   Windham School District   1630911 Sweeney Medically Fragile Program Program           2019   pk_12_total * 0 *   0 0     0   0   * *     *             *   *   0     0 0     0   0                        
2453045 2453045 CT     school   1630011   Windham School District   1631211 Assisted Work Program Program           2019   pk_12_total * 0 9   * 0     0   0   * *     *             12   12   0 9     0     0   0                   12   12
2453057 2453057 CT     school   1640011   Windsor School District   1640311 Spark Program           2019   pk_12_total * 10 *   0 0     0   *   * *     0             17   17   10     0 0     0               0       17   17
2453061 2453061 CT     school   1660011   Wolcott School District 90528001783 1660311 ABC Classroom Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             *   *   0     0 0     0   0           0            
2453089 2453089 CT     school   2040012   Regional School District 04   2040112 Region 4 Transition Academy Program           2019   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2453093 2453093 CT     school   2050012   Regional School District 05   2050112 Amity Transition Academy Program           2019   pk_12_total * 0 0   0 *     0   0   * *     0             *   *   0 0   0       0   0           0            
2453094 2453094 CT     school   2070012   Regional School District 07 90372001399 2079012 FLEX Program           2019   pk_12_total 9 0 0   0 0     0   0   * *     0             9   9 9 0 0   0 0     0   0           0       9   9
2453100 2453100 CT     school   2070012   Regional School District 07   2070112 Highlander Transition Academy Program           2019   pk_12_total 12 0 0   0 0     0   0   * *     0             12   12 12 0 0   0 0     0   0           0       12   12
2453105 2453105 CT     school 905372 9020022   The Gilbert School District 90537201222 9026122 The Gilbert School Endowed and Incorporated Academies Schools Regular School No High 07 12 2019   pk_12_total 348 8 82   0 50     0   23   275 *     16             74   511 348 8 82   0 50     0   23   275       16       74   511
2453120 2453120 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 2019   pk_12_total 179 44 390   * *     0   21   369 *     33             48   647 179 44 390           0   21   369       33       48   647
2453137 2453137 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010322 Alternative Pathways to Success Program Regular School No High 09 12 2019   pk_12_total 7 * *   0 0     0   0   * *     *             *   15 7       0 0     0   0                       15
2453138 2453138 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010222 Night School Program Regular School No High 09 12 2019   pk_12_total * * *   0 0     0   0   * *     0             *   7         0 0     0   0           0           7
2453142 2453142 CT     school   2190012   Regional School District 19   2190212 PM Panthers             2019   pk_12_total 14 0 *   0 0     0   *   * *     *             6   17 14 0     0 0     0                       6   17
2757306 2757306 CT     school   50011   Barkhamsted School District   50211 Bridges at Barkhamsted Elementary School Program           2021   pk_12_total * 0 0   0 0     0   *   * *     0             6   6   0 0   0 0     0               0       6   6
2757312 2757312 CT     school   70011   Berlin School District   70311 Transition Academy Program           2021   pk_12_total * 0 0   0 0     0   *   * *     0             11   11   0 0   0 0     0               0       11   11
2757323 2757323 CT     school   110011   Bloomfield School District   110111 Steps to Success Program           2021   pk_12_total 0 * *   0 0     0   0   * *     *             15   15 0       0 0     0   0                   15   15
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            
2757337 2757337 CT     school 900420 140011   Branford School District 90042000041 145111 Francis Walsh Intermediate School Public Schools Regular School No Middle 05 08 2021   pk_12_total 588 41 105   * 62     0   *   435 *     29             103   825 588 41 105     62     0       435       29       103   825
2757338 2757338 CT     school 900420 140011   Branford School District 90042000039 146111 Branford High School Public Schools Regular School No High 09 12 2021   pk_12_total 575 25 95   * 63     0   *   398 *     14             94   780 575 25 95     63     0       398       14       94   780
2757340 2757340 CT     school   140011   Branford School District   140311 Access Transition Program Program           2021   pk_12_total * 0 0   0 *     0   0   * *     *             14   14   0 0   0       0   0                   14   14
2757345 2757345 CT     school 900450 150011   Bridgeport School District 90045000052 150311 Black Rock School Public Schools Regular School No Elementary PK 08 2021   pk_12_total 119 67 274   * 9     *   *   247 *     104             77   474 119 67 274     9             247       104       77   474
2757379 2757379 CT     school   150011   Bridgeport School District   152811 The Transition Academy Program           2021   pk_12_total * 15 12   0 *     0   0   * *     *             29   29   15 12   0       0   0                   29   29
2757380 2757380 CT     school   170011   Bristol School District 90051001728 172911 BECC Autism Program           2021   pk_12_total 6 0 *   0 *     0   0   * *     0             12   12 6 0     0       0   0           0       12   12
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            
2757389 2757389 CT     school   170011   Bristol School District 90051001692 172311 Ivy Drive Medically Fragile Program           2021   pk_12_total * * *   0 0     0   *   * *     0             7   7         0 0     0               0       7   7
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
2757391 2757391 CT     school   170011   Bristol School District 90051001707 173211 Stafford Autism Program           2021   pk_12_total * * *   * *     0   0   * *     0             13   13                 0   0           0       13   13
2757394 2757394 CT     school   170011   Bristol School District   173811 Greene Hills Extended Resource Program           2021   pk_12_total 0 0 *   0 *     0   0   * *     *             7   7 0 0     0       0   0                   7   7
2757396 2757396 CT     school   170011   Bristol School District   173711 Hubbell Autism Program Program           2021   pk_12_total * * *   0 *     0   0   * *     *             9   9         0       0   0                   9   9
2757398 2757398 CT     school   170011   Bristol School District 90051001688 172611 Ivy Drive GOAL Program           2021   pk_12_total * * *   0 0     0   *   * *     *             8   8         0 0     0                       8   8
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            
2757403 2757403 CT     school   170011   Bristol School District 90051001748 171011 Chippens Hill Middle School Functional Program Program           2021   pk_12_total * * *   0 0     0   *   * *     *             11   11         0 0     0                       11   11
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            
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
2757407 2757407 CT     school   170011   Bristol School District 90051001651 172711 Northeast MS/Extended Resource Program           2021   pk_12_total * 0 *   0 0     0   0   * *     *             6   6   0     0 0     0   0                   6   6
2757408 2757408 CT     school   170011   Bristol School District 90051001796 172811 Northeast MS/GOAL Program           2021   pk_12_total * * *   0 0     0   0   * *     0             9   9         0 0     0   0           0       9   9
2757414 2757414 CT     school   170011   Bristol School District   170211 ACCESS Program           2021   pk_12_total * 0 8   0 0     0   *   8 *     0             11   11   0 8   0 0     0       8       0       11   11
2757427 2757427 CT     school 900690 230011   Canton School District 90069000118 236111 Canton High School Public Schools Regular School No High 09 12 2021   pk_12_total 390 27 40   * 16     0   *   241 *     *             68   481 390 27 40     16     0       241               68   481
2757437 2757437 CT     school   2410014   Capitol Region Education Council   2411414 River Street School Early Learning Center Program           2021   pk_12_total * * *   0 0     0   0   * *     0             0   6         0 0     0   0           0       0   6
2757443 2757443 CT     school 900700 2410014   Capitol Region Education Council 90070001592 2416514 Academy of Science and Innovation Regional Education Service Center Schools Regular School No High 06 12 2021   pk_12_total 160 186 366   * *     0   32   425 *     63             134   778 160 186 366           0   32   425       63       134   778
2757447 2757447 CT     school   2410014   Capitol Region Education Council 90070001489 2419214 Farmington Valley Regional Diagnostic Center Program           2021   pk_12_total * 0 0   0 0     0   *   * *     0             9   9   0 0   0 0     0               0       9   9
2757451 2757451 CT     school   2410014   Capitol Region Education Council 90070001802 2419714 Strive (Southern Transition Real-World and Independent Vocational Education Program Program           2021   pk_12_total 10 0 *   0 *     *   0   * *     0             14   14 10 0     0           0           0       14   14
2757456 2757456 CT     school   250011   Cheshire School District   250711 Highland School Autism Program Program           2021   pk_12_total 11 * *   0 *     0   0   * *     0             15   15 11       0       0   0           0       15   15
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            
2757464 2757464 CT     school   250011   Cheshire School District   251011 QU College Life Program           2021   pk_12_total 7 0 0   0 0     0   0   * *     0             7   7 7 0 0   0 0     0   0           0       7   7
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            
2757481 2757481 CT     school   2430014   Cooperative Educational Services 90091001555 2439314 RISE Transitional Program Program           2021   pk_12_total 9 0 *   0 0     *   *   * *     0             13   13 9 0     0 0                     0       13   13
2757482 2757482 CT     school   2430014   Cooperative Educational Services   2430214 Transition Learning Center Program           2021   pk_12_total 16 8 *   0 *     0   *   * *     *             32   32 16 8     0       0                       32   32
2757513 2757513 CT     school   340011   Danbury School District   340711 Western Connection Program           2021   pk_12_total * 0 *   0 0     0   0   * *     0             11   11   0     0 0     0   0           0       11   11
2757525 2757525 CT     school   370011   Derby School District   370511 RAISE Academy Program           2021   pk_12_total 7 6 *   0 0     0   *   * *     0             12   22 7 6     0 0     0               0       12   22
2757535 2757535 CT     school 901230 420011   East Hampton School District 90123000189 420111 Memorial School Public Schools Regular School No Elementary PK 03 2021   pk_12_total 477 * 43   0 9     *   21   293 *     0             100   559 477   43   0 9         21   293       0       100   559
2757539 2757539 CT     school   420011   East Hampton School District 90123001514 429011 The Learning Center at East Hampton Program           2021   pk_12_total 9 0 0   0 0     0   0   * *     0             *   9 9 0 0   0 0     0   0           0           9
2757568 2757568 CT     school   450011   East Lyme School District 90132001760 450611 Coastal Connections Program           2021   pk_12_total * 0 *   0 0     0   0   * *     0             7   15   0     0 0     0   0           0       7   15
2757574 2757574 CT     school   470011   East Windsor School District   470411 East Windsor Transition Program Program           2021   pk_12_total * 0 *   0 0     0   0   * *     0             8   8   0     0 0     0   0           0       8   8
2757577 2757577 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 09 12 2021   pk_12_total * * *   0 0     0   *   * *     *             *   8         0 0     0                           8
2757579 2757579 CT     school   2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN)   2530214 Woodstock Academy Consortium Classroom Program           2021   pk_12_total 10 0 0   0 *     0   *   * *     0             14   14 10 0 0   0       0               0       14   14
2757580 2757580 CT     school   2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN)   2530114 Regional Transitional Services 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
2757585 2757585 CT     school   2420014   EdAdvance   2420614 Partnership Learning Academy Program           2021   pk_12_total * 0 *   0 0     0   0   * *     *             9   9   0     0 0     0   0                   9   9
2757586 2757586 CT     school   2420014   EdAdvance 90351201476 2429014 The ACCESS School at The Danuta M. Thibodeau Education Center Program           2021   pk_12_total 17 * *   * *     0   0   * *     0             26   26 17               0   0           0       26   26
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                        
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            
2757605 2757605 CT     school   490011   Enfield School District 90147001743 490811 Henry Barnard - Primary Adaptive Learning (PAL) Program           2021   pk_12_total * * *   0 0     0   *   * *     0             8   8         0 0     0               0       8   8
2757608 2757608 CT     school   490011   Enfield School District 90147001696 490611 Henry Barnard - Educational Counseling Program (ECP) Program           2021   pk_12_total * * *   0 0     0   *   * *     *             6   6         0 0     0                       6   6
2757609 2757609 CT     school   490011   Enfield School District   492411 Eagle Academy Program           2021   pk_12_total 10 * *   0 0     0   0   * *     0             17   17 10       0 0     0   0           0       17   17
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            
2757617 2757617 CT     school   490011   Enfield School District   492311 Enfield Alternative Education Program Program           2021   pk_12_total 7 * *   0 0     0   0   * *     0             *   13 7       0 0     0   0           0           13
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            
2757639 2757639 CT     school 901530 510011   Fairfield School District 90153000256 516211 Fairfield Warde High School Public Schools Regular School No High 09 12 2021   pk_12_total 1033 * 235   * 91     0   60   765 *     42             193   1472 1033   235     91     0   60   765       42       193   1472
2757641 2757641 CT     school   510011   Fairfield School District   510511 Fairfield School/Community Partnership Program           2021   pk_12_total * 0 *   0 0     0   0   * *     0             15   15   0     0 0     0   0           0       15   15
2757650 2757650 CT     school   520011   Farmington School District 90156001713 520611 Farmington Alternative High School Program           2021   pk_12_total * 0 *   0 *     0   0   * *     0             *   7   0     0       0   0           0           7

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