enrollments

Data source: Big Local News · About: Big Local

20,454 rows where state = "CT" and year = 2020 sorted by male_int

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2020 · 20,454 ✖
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
2777732 2777732 CT     school   20011   Ansonia School District   20411 P.A.C.E. - PM (Positive And Creative Education - PM) Program           2020   pk_12_total 0 * *   0 0     0   0   * *     0             *   8 0       0 0     0   0           0           8
2777733 2777733 CT     school   20011   Ansonia School District   21011 Ansonia 18-21 Transition Program Program           2020   pk_12_total * 0 *   0 0     0   *   * *     *             7   7   0     0 0     0                       7   7
2777737 2777737 CT     school   2440014   Area Cooperative Educational Services   2440414 ACES at Mead Elementary School Program           2020   pk_12_total 0 * *   0 0     0   *   * *     0             *   * 0       0 0     0               0            
2777753 2777753 CT     school   50011   Barkhamsted School District   50211 Bridges at Barkhamsted Elementary School Program           2020   pk_12_total * 0 0   0 0     0   *   * *     0             *   *   0 0   0 0     0               0            
2777759 2777759 CT     school   70011   Berlin School District   70311 Transition Academy Program           2020   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2777766 2777766 CT     school   90011   Bethel School District   90311 TASK Program           2020   pk_12_total 6 0 *   0 *     0   *   * *     *             *   12 6 0     0       0                           12
2777767 2777767 CT     school   90011   Bethel School District   90211 Community Partnership Program Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             6   6   0     0 0     0   0           0       6   6
2777776 2777776 CT     school 900330 110011   Bloomfield School District 90033001619 116411 Learning Academy at Bloomfield   Alternative School No High 11 12 2020   pk_12_total 0 9 0   0 0     0   0   * *     0             *   9 0 9 0   0 0     0   0           0           9
2777786 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
2777788 2777788 CT     school   140011   Branford School District   140311 Access Transition Program Program           2020   pk_12_total * 0 0   0 *     0   0   * *     *             15   15   0 0   0       0   0                   15   15
2777828 2777828 CT     school   170011   Bristol School District 90051001728 172911 BECC Autism Program           2020   pk_12_total * 0 *   0 0     0   *   * *     0             6   6   0     0 0     0               0       6   6
2777836 2777836 CT     school   170011   Bristol School District   173811 Greene Hills Extended Resource Program           2020   pk_12_total * 0 *   0 *     0   0   * *     *             6   6   0     0       0   0                   6   6
2777837 2777837 CT     school   170011   Bristol School District 90051001692 172311 Ivy Drive Medically Fragile Program           2020   pk_12_total * * *   0 0     0   0   * *     0             *   *         0 0     0   0           0            
2777838 2777838 CT     school   170011   Bristol School District   172411 Mt. View Extended Resource Program           2020   pk_12_total * * *   0 0     0   0   * *     *             *   *         0 0     0   0                        
2777839 2777839 CT     school   170011   Bristol School District 90051001755 173011 South Side Extended Resource Program           2020   pk_12_total * * 6   0 0     0   *   * *     *             11   11     6   0 0     0                       11   11
2777840 2777840 CT     school   170011   Bristol School District 90051001707 173211 Stafford Autism Program           2020   pk_12_total * * *   * *     0   0   * *     0             14   14                 0   0           0       14   14
2777843 2777843 CT     school   170011   Bristol School District 90051001646 172111 Hubbell/Extended Resource Program           2020   pk_12_total 0 0 *   0 *     0   0   * *     0             *   * 0 0     0       0   0           0            
2777844 2777844 CT     school   170011   Bristol School District 90051001726 172511 Mt. View GOAL Program           2020   pk_12_total 0 * *   0 0     0   0   * *     0             *   * 0       0 0     0   0           0            
2777847 2777847 CT     school   170011   Bristol School District   173711 Hubbell Autism Program Program           2020   pk_12_total * * *   0 *     0   0   * *     *             9   9         0       0   0                   9   9
2777848 2777848 CT     school   170011   Bristol School District 90051001711 173111 South Side GOAL Program           2020   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2777849 2777849 CT     school   170011   Bristol School District   173611 West bristol Extended Resource Program           2020   pk_12_total 0 0 *   0 0     0   0   * 0     0             *   * 0 0     0 0     0   0     0     0            
2777851 2777851 CT     school   170011   Bristol School District 90051001748 171011 Chippens Hill Middle School Functional Program Program           2020   pk_12_total * * 6   0 0     0   0   * *     *             11   11     6   0 0     0   0                   11   11
2777852 2777852 CT     school   170011   Bristol School District   171611 Chippens Hill Middle School Medically Fragile Program           2020   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2777854 2777854 CT     school   170011   Bristol School District 90051001753 173411 Chms Goal Program           2020   pk_12_total * 0 *   0 0     0   0   * *     *             9   9   0     0 0     0   0                   9   9
2777855 2777855 CT     school   170011   Bristol School District 90051001661 170911 Greene-Hills GOAL Program           2020   pk_12_total * * *   0 0     0   *   * *     *             6   6         0 0     0                       6   6
2777856 2777856 CT     school   170011   Bristol School District 90051001651 172711 Northeast MS/Extended Resource Program           2020   pk_12_total * 0 *   0 0     0   0   * *     *             6   6   0     0 0     0   0                   6   6
2777857 2777857 CT     school   170011   Bristol School District 90051001796 172811 Northeast MS/GOAL Program           2020   pk_12_total * * 0   0 0     0   0   * *     0             *   *     0   0 0     0   0           0            
2777860 2777860 CT     school 900510 170011   Bristol School District 90051000093 176211 Bristol Eastern High School Public Schools Regular School No High 09 12 2020   pk_12_total 677 67 260   * 36     *   35   * 545     30             216   1079 677 67 260     36         35     545     30       216   1079
2777862 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
2777874 2777874 CT     school 900690 230011   Canton School District 90069001376 235111 Canton Middle School Public Schools Regular School No Middle 07 08 2020   pk_12_total 197 20 24   0 *     0   *   * 125     *             34   250 197 20 24   0       0         125             34   250
2777876 2777876 CT     school   230011   Canton School District 90069001695 230411 Canton Academy Program           2020   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2777885 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
2777896 2777896 CT     school   2410014   Capitol Region Education Council 90070001489 2419214 Farmington Valley Regional Diagnostic Center Program           2020   pk_12_total 8 * 0   0 0     0   *   * *     0             *   11 8   0   0 0     0               0           11
2777900 2777900 CT     school   2410014   Capitol Region Education Council   2419414 IPM @ Plainville High School             2020   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2777901 2777901 CT     school   2410014   Capitol Region Education Council 90070001802 2419714 Strive (Southern Transition Real-World and Independent Vocational Education Program Program           2020   pk_12_total * 0 0   0 *     0   0   * *     0             13   13   0 0   0       0   0           0       13   13
2777906 2777906 CT     school   250011   Cheshire School District   250711 Highland School Autism Program Program           2020   pk_12_total 12 * *   0 *     0   0   * *     0             17   17 12       0       0   0           0       17   17
2777908 2777908 CT     school   250011   Cheshire School District   251111 Doolittle Bridges Program Program           2020   pk_12_total * * *   0 0     0   0   * 0     0             *   *         0 0     0   0     0     0            
2777913 2777913 CT     school   250011   Cheshire School District 90075001766 250311 Cheshire Quinnipiac University Transition Collaborative Program           2020   pk_12_total * 0 0   0 *     0   0   * *     0             6   6   0 0   0       0   0           0       6   6
2777914 2777914 CT     school   250011   Cheshire School District   251011 QU College Life Program           2020   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2777923 2777923 CT     school   280011   Colchester School District   280711 Community Transition Academy of Colchester Program           2020   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2777928 2777928 CT     school   2430014   Cooperative Educational Services   2430314 Eastern Fairfield County Diagnostic Center Program           2020   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2777931 2777931 CT     school   2430014   Cooperative Educational Services 90091001555 2439314 RISE Transitional Program Program           2020   pk_12_total 8 0 *   0 0     0   *   * *     0             12   12 8 0     0 0     0               0       12   12
2777938 2777938 CT     school 900960 320011   Coventry School District 90096000143 326111 Coventry High School Public Schools Regular School No High 09 12 2020   pk_12_total 379 * 28   * *     0   19   * 234     0             54   431 379   28           0   19     234     0       54   431
2777962 2777962 CT     school   340011   Danbury School District   340711 Western Connection Program           2020   pk_12_total * * 0   0 0     0   0   * *     0             11   11     0   0 0     0   0           0       11   11
2777974 2777974 CT     school   370011   Derby School District   370511 RAISE Academy Program           2020   pk_12_total 8 * *   0 0     0   *   * *     0             9   17 8       0 0     0               0       9   17
2777975 2777975 CT     school   370011   Derby School District   370211 Alternative Education Program Program           2020   pk_12_total 0 0 0   0 0     0   *   * 0     0             *   * 0 0 0   0 0     0         0     0            
2777988 2777988 CT     school   420011   East Hampton School District 90123001514 429011 The Learning Center at East Hampton Program           2020   pk_12_total 8 0 0   0 0     0   0   * *     0             *   8 8 0 0   0 0     0   0           0           8
2778017 2778017 CT     school   450011   East Lyme School District 90132001760 450611 Coastal Connections Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             *   16   0     0 0     0   0           0           16
2778019 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
2778023 2778023 CT     school   470011   East Windsor School District   470411 East Windsor Transition Program Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             8   8   0     0 0     0   0           0       8   8
2778029 2778029 CT     school   2420014   EdAdvance   2420114 Steps Program           2020   pk_12_total 16 * 7   * 0     0   0   * *     *             29   29 16   7     0     0   0                   29   29
2778030 2778030 CT     school   2420014   EdAdvance   2420314 Steps-North Expelled Student Program           2020   pk_12_total 0 0 *   0 0     0   0   * 0     *             *   * 0 0     0 0     0   0     0                  
2778031 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    
2778038 2778038 CT     school   480011   Ellington School District   480511 The Ellington Public Schools Expulsion Program (TEPSEP) Program           2020   pk_12_total * 0 0   0 0     0   *   * 0     0             *   *   0 0   0 0     0         0     0            
2778039 2778039 CT     school   480011   Ellington School District   480411 Ellington Continuing Life Independence Post-Secondary Education (ECLIPSE) Program           2020   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2778046 2778046 CT     school   490011   Enfield School District 90147001792 490311 Henry Barnard - Autism Spectrum Disorder (ASD) Program           2020   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2778047 2778047 CT     school   490011   Enfield School District 90147001743 490811 Henry Barnard - Primary Adaptive Learning (PAL) Program           2020   pk_12_total * * *   0 0     0   *   * *     0             *   *         0 0     0               0            
2778050 2778050 CT     school   490011   Enfield School District 90147001696 490611 Henry Barnard - Educational Counseling Program (ECP) Program           2020   pk_12_total * * *   0 0     0   *   * 0     0             *   *         0 0     0         0     0            
2778052 2778052 CT     school   490011   Enfield School District 90147001676 490511 Edgar H. Parkman - Autism Spectrum Disorder (ASD) Program           2020   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2778054 2778054 CT     school   490011   Enfield School District   491411 Eli Whitney - Intermediate Adaptive Learning (IAL) Program           2020   pk_12_total * * *   0 0     0   0   * *     0             *   *         0 0     0   0           0            
2778057 2778057 CT     school   490011   Enfield School District   490911 John F. Kennedy - Adaptive Learning Program (ALP) Program           2020   pk_12_total * * *   0 *     0   0   * *     *             12   12         0       0   0                   12   12
2778059 2778059 CT     school   490011   Enfield School District   492311 Enfield Alternative Education Program Program           2020   pk_12_total * * *   0 0     0   *   * *     0             *   7         0 0     0               0           7
2778060 2778060 CT     school   490011   Enfield School District   490111 Enfield High - Adaptive Learning Program (ALP) Program           2020   pk_12_total * 0 0   0 *     0   0   * *     0             6   6   0 0   0       0   0           0       6   6
2778092 2778092 CT     school   520011   Farmington School District 90156001713 520611 Farmington Alternative High School Program           2020   pk_12_total * * *   0 *     0   0   * *     *             *   7         0       0   0                       7
2778102 2778102 CT     school 901620 540011   Glastonbury School District 90162000282 545211 Smith Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 640 * 97   * 120     0   54   * 494     13             110   944 640   97     120     0   54     494     13       110   944
2778104 2778104 CT     school   540011   Glastonbury School District 90162001752 541411 Glastonbury Transition Academy Program           2020   pk_12_total 7 * *   0 *     0   0   * *     0             12   12 7       0       0   0           0       12   12
2778128 2778128 CT     school 901740 580011   Griswold School District 90174001721 580111 Griswold Alternative School Public Schools Alternative School No High 08 12 2020   pk_12_total 13 0 0   0 0     *   *   * *     0             15   15 13 0 0   0 0                     0       15   15
2778139 2778139 CT     school   590011   Groton School District   590611 Apex Academy Program           2020   pk_12_total * * 0   0 0     0   *   * *     0             *   *     0   0 0     0               0            
2778140 2778140 CT     school   590011   Groton School District   590211 New Beginnings Alternative Program Program           2020   pk_12_total * * *   0 0     0   *   * *     0             6   6         0 0     0               0       6   6
2778141 2778141 CT     school   590011   Groton School District   591011 Transition Academy Program           2020   pk_12_total 7 * *   0 0     0   *   * *     *             14   14 7       0 0     0                       14   14
2778155 2778155 CT     school   620011   Hamden School District   621711 Ridge Hill IIC Program           2020   pk_12_total 0 7 *   0 *     0   0   * *     0             15   15 0 7     0       0   0           0       15   15
2778160 2778160 CT     school   620011   Hamden School District   621611 Helen Street IIC Program           2020   pk_12_total 0 8 6   0 *     0   *   * *     *             16   16 0 8 6   0       0                       16   16
2778161 2778161 CT     school   620011   Hamden School District   621911 Intensive Support Classroom Program           2020   pk_12_total * * *   0 0     0   0   * 0     0             *   *         0 0     0   0     0     0            
2778164 2778164 CT     school   620011   Hamden School District   621511 Dunbar Hill IIC Program           2020   pk_12_total * 7 *   0 *     0   *   * *     *             16   16   7     0       0                       16   16
2778169 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
2778177 2778177 CT     school   640011   Hartford School District 90192001723 644111 Early Childhood Development Center (ECDC) Program           2020   pk_12_total * 8 8   0 *     0   *   * *     0             19   19   8 8   0       0               0       19   19
2778184 2778184 CT     school 901920 640011   Hartford School District 90192001641 640511 Montessori Magnet at Batchelder School Public Schools Regular School No Elementary PK 06 2020   pk_12_total 88 50 205   * *     0   11   * 191     76             45   367 88 50 205           0   11     191     76       45   367
2778197 2778197 CT     school   640011   Hartford School District 90192001764 648511 iGOAL 2 - Moylan School Program           2020   pk_12_total 0 * *   0 0     0   0   * *     0             6   6 0       0 0     0   0           0       6   6
2778199 2778199 CT     school   640011   Hartford School District   640810 iGOAL Pre-K - Rawson School Program           2020   pk_12_total * * *   0 0     0   0   * *     0             8   8         0 0     0   0           0       8   8
2778204 2778204 CT     school   640011   Hartford School District   649511 iGOAL 1 - Breakthrough Magnet School, North Program           2020   pk_12_total 0 * *   0 0     0   0   * *     *             11   11 0       0 0     0   0                   11   11
2778208 2778208 CT     school   640011   Hartford School District 90192001673 644411 iGOAL 1 - Rawson School Program           2020   pk_12_total 0 10 *   0 0     0   *   * *     *             *   18 0 10     0 0     0                           18
2778209 2778209 CT     school   640011   Hartford School District   644611 RISE - West Middle School Program           2020   pk_12_total 0 * *   0 0     0   0   * 0     *             *   * 0       0 0     0   0     0                  
2778210 2778210 CT     school   640011   Hartford School District   649811 iGOAL 1 - Moylan School             2020   pk_12_total 0 * *   0 0     0   *   * *     *             8   8 0       0 0     0                       8   8
2778211 2778211 CT     school   640011   Hartford School District   645911 RISE - M.D. Fox School             2020   pk_12_total * * 13   0 0     0   0   * *     *             27   27     13   0 0     0   0                   27   27
2778214 2778214 CT     school   640011   Hartford School District   640210 iGOAL 2 - Kennelly School Program           2020   pk_12_total 0 * *   0 0     0   0   * *     *             9   9 0       0 0     0   0                   9   9
2778215 2778215 CT     school 901920 640011   Hartford School District 90192001478 646411 Classical Magnet School Public Schools Regular School No High 06 12 2020   pk_12_total 52 184 172   0 *     *   10   * 237     40             75   429 52 184 172   0           10     237     40       75   429
2778221 2778221 CT     school   640011   Hartford School District   648911 iGOAL 1 - McDonough Middle School             2020   pk_12_total 0 * *   0 0     0   0   * *     *             9   9 0       0 0     0   0                   9   9
2778222 2778222 CT     school   640011   Hartford School District   640110 iGOAL 1 - Milner School Program           2020   pk_12_total 0 * *   0 0     0   0   * *     *             20   20 0       0 0     0   0                   20   20
2778228 2778228 CT     school   640011   Hartford School District 90192001770 648311 RISE - Bulkeley High School Program           2020   pk_12_total * * 14   0 0     0   0   * *     *             20   20     14   0 0     0   0                   20   20
2778229 2778229 CT     school   640011   Hartford School District 90192001677 648211 RISE - Hartford Public High School Program           2020   pk_12_total * * 15   0 0     0   0   * *     *             *   24     15   0 0     0   0                       24
2778231 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
2778233 2778233 CT     school   640011   Hartford School District   645011 iGOAL 2 - Weaver High School             2020   pk_12_total 0 6 10   0 0     0   0   * *     *             16   16 0 6 10   0 0     0   0                   16   16
2778240 2778240 CT     school 900007 2610013   Jumoke Academy District 90000700747 2610113 Jumoke Academy Public Charter Schools Regular School Yes Other PK 12 2020   pk_12_total * 650 39   * *     0   8   * 367     6             42   706   650 39           0   8     367     6       42   706
2778246 2778246 CT     school 902070 690011   Killingly School District 90207000392 696111 Killingly High School Public Schools Regular School No High 09 12 2020   pk_12_total 633 20 62   10 19     0   37   * 414     *             125   781 633 20 62   10 19     0   37     414             125   781
2778247 2778247 CT     school   2450014   Learn   2451514 LEARN Integrated Program at TFS Program           2020   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2778252 2778252 CT     school   2450014   Learn   2451614 LEARN SAILS Program Program           2020   pk_12_total 12 * *   0 0     0   *   * *     *             18   18 12       0 0     0                       18   18
2778254 2778254 CT     school   2450014   Learn   2451414 LEARN Diagnostic and Wellness Center Program           2020   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2778255 2778255 CT     school   2450014   Learn   2450814 Learn SAILS Middle School Program             2020   pk_12_total * * *   0 0     0   *   * 0     0             *   *         0 0     0         0     0            
2778259 2778259 CT     school   2450014   Learn 90345001757 2450414 LEARN Transition Academy Program           2020   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2778260 2778260 CT     school   2450014   Learn 90345001795 2450614 Learn High School Program           2020   pk_12_total * 0 *   0 *     0   0   * *     0             *   *   0     0       0   0           0            

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