enrollments

Data source: Big Local News · About: Big Local

20,286 rows where state = "CT" and year = 2019 sorted by white_int

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2019 · 20,086 ✖
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
2452915 2452915 CT     school   1510011   Waterbury School District   1512411 Reed ESC Program           2019   pk_12_total * * 16   0 0     0   *   16 8     *             24   24     16   0 0     0       16 8             24   24
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
2452924 2452924 CT     school   1510011   Waterbury School District   1515711 North End Bilingual Program           2019   pk_12_total * 0 *   0 0     0   0   26 33     59             15   59   0     0 0     0   0   26 33     59       15   59
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
2452929 2452929 CT     school   1510011   Waterbury School District   1514911 Wallace SCOPE Program           2019   pk_12_total * * 7   0 0     0   0   8 6     *             14   14     7   0 0     0   0   8 6             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
2452932 2452932 CT     school   1510011   Waterbury School District   1515611 West Side Bilingual Program           2019   pk_12_total * 0 *   0 0     0   0   35 29     *             9   64   0     0 0     0   0   35 29             9   64
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            
2452947 2452947 CT     school   1520011   Waterford School District   1520911 Waterford Academy Program           2019   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
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            
2452965 2452965 CT     school   1550011   West Hartford School District   1559711 Morley Learning Center Program           2019   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2452971 2452971 CT     school   1550011   West Hartford School District 90492001705 1559311 Braeburn Learning Center Program           2019   pk_12_total * * 0   0 0     0   *   * 0     0             *   *     0   0 0     0         0     0            
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            
2452991 2452991 CT     school   1560011   West Haven School District 90495001775 1560211 PACE Program           2019   pk_12_total * 11 19   0 0     0   *   22 18     *             14   40   11 19   0 0     0       22 18             14   40
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    
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
2453010 2453010 CT     school   1580011   Westport School District   1580111 LLS Intensive Resource Program           2019   pk_12_total * 0 *   0 *     0   0   * 0     0             *   *   0     0       0   0     0     0            
2453033 2453033 CT     school   1630011   Windham School District 90519000307 1638011 Early Headstart Program           2019   pk_12_total * 0 *   0 0     0   0   15 15     0             0   30   0     0 0     0   0   15 15     0       0   30
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                        
2453044 2453044 CT     school 905190 1630011   Windham School District 90519001920 1631311 Windham STEPS Academy   Alternative School No High 09 12 2019   pk_12_total * * 26   0 0     0   *   20 14     14             9   34     26   0 0     0       20 14     14       9   34
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
2453059 2453059 CT     school   1640011   Windsor School District   1640211 Community Based Transition Academy Program           2019   pk_12_total * 13 *   0 *     0   0   13 10     *             23   23   13     0       0   0   13 10             23   23
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            
2453066 2453066 CT     school   1660011   Wolcott School District 90528001772 1660411 Phoenix Program Program           2019   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2453071 2453071 CT     school 900212 2880013   Achievement First Hartford Academy District 90021201528 2880113 Achievement First Hartford Academy Public Charter Schools Regular School Yes Other KG 12 2019   pk_12_total * 782 304   * *     *   15   519 593     52             115   1112   782 304               15   519 593     52       115   1112
2453073 2453073 CT     school 900217 2950013   Booker T. Washington Academy District 90021701750 2950113 Booker T. Washington Academy Public Charter Schools Regular School Yes Elementary KG 05 2019   pk_12_total * 309 45   0 0     0   *   186 174     27             22   360   309 45   0 0     0       186 174     27       22   360
2453074 2453074 CT     school 900630 210011   Canaan School District 90063000115 210111 Lee H. Kellogg School Public Schools Regular School No Elementary KG 08 2019   pk_12_total * 0 *   0 0     0   0   33 30     *             8   63   0     0 0     0   0   33 30             8   63
2453075 2453075 CT     school 900221 2970013   Capital Preparatory Harbor School District 90022101803 2970113 Capital Preparatory Harbor School Public Charter Schools Regular School Yes Other KG 12 2019   pk_12_total * 463 167   * 0     0   *   323 311     *             71   634   463 167     0     0       323 311             71   634
2453086 2453086 CT     school 900023 2780013   Trailblazers Academy District 90002300965 2785113 Trailblazers Academy   Regular School Yes Middle 06 08 2019   pk_12_total * 63 58   0 *     0   *   70 57     14             33   127   63 58   0       0       70 57     14       33   127
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            
2453104 2453104 CT     school 900015 2690013   The Bridge Academy District 90001500809 2696113 The Bridge Academy Public Charter Schools Regular School Yes High 07 12 2019   pk_12_total * 160 113   * *     0   0   139 142     8             55   281   160 113           0   0   139 142     8       55   281
2453109 2453109 CT     school   3360015   Unified School District #1 90000300404 3361115 Manson Youth Institution State Agency Facilities           2019   pk_12_total * 61 55   0 0     0   *   130 0     *             111   130   61 55   0 0     0       130 0             111   130
2453110 2453110 CT     school   3360015   Unified School District #1 90000300849 3362515 York Correctional Institution State Agency Facilities           2019   pk_12_total * * *   0 0     0   0   0 12     0             *   12         0 0     0   0   0 12     0           12
2453112 2453112 CT     school   3360015   Unified School District #1 90000300844 3362415 Corrigan/Radgowski Correctional Institution State Agency Facilities           2019   pk_12_total * * *   0 0     0   0   * 0     0             *   *         0 0     0   0     0     0            
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
2453146 2453146 CT     school   3370015   Department of Mental Health and Addiction Services 90002701539 3370215 Connecticut Valley Hospital State Agency Facilities           2019   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2451748 2451748 CT     school 900330 110011   Bloomfield School District 90033001619 116411 Learning Academy at Bloomfield   Alternative School No High 09 12 2019   pk_12_total 0 * *   0 0     0   0   * *     0             *   8 0       0 0     0   0           0           8
2451807 2451807 CT     school   170011   Bristol School District 90051001726 172511 Mt. View GOAL Program           2019   pk_12_total 0 0 *   0 0     0   *   * *     0             *   * 0 0     0 0     0               0            
2451867 2451867 CT     school   2410014   Capitol Region Education Council   2411514 Soundbridge @ Chippens Hill MS Bristol             2019   pk_12_total 0 * *   0 *     0   0   * *     0             *   * 0       0       0   0           0            
2452010 2452010 CT     school   480011   Ellington School District   480511 The Ellington Public Schools Expulsion Program (TEPSEP) Program           2019   pk_12_total 0 * 0   0 0     0   0   * 0     0             *   * 0   0   0 0     0   0     0     0            
2452134 2452134 CT     school   620011   Hamden School District   621811 West Woods IIC Program           2019   pk_12_total 0 * *   0 0     0   0   * *     0             8   8 0       0 0     0   0           0       8   8
2452161 2452161 CT     school   640011   Hartford School District   640610 Pre-K Integrated - West Middle School Program           2019   pk_12_total 0 7 *   0 *     0   0   * *     0             7   15 0 7     0       0   0           0       7   15
2452162 2452162 CT     school 901920 640011   Hartford School District 90192000376 641711 Rawson School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 0 268 83   * 0     *   8   185 177     53             67   362 0 268 83     0         8   185 177     53       67   362
2452167 2452167 CT     school   640011   Hartford School District 90192001764 648511 iGOAL 2 - Moylan School Program           2019   pk_12_total 0 6 7   0 0     0   0   7 6     *             13   13 0 6 7   0 0     0   0   7 6             13   13
2452168 2452168 CT     school   640011   Hartford School District   640710 iGOAL Pre-K - Naylor School Program           2019   pk_12_total 0 * *   0 0     0   0   * *     0             10   10 0       0 0     0   0           0       10   10
2452169 2452169 CT     school   640011   Hartford School District   640810 iGOAL Pre-K - Rawson School Program           2019   pk_12_total 0 * *   0 0     0   0   * *     0             *   * 0       0 0     0   0           0            
2452174 2452174 CT     school   640011   Hartford School District   649511 iGOAL 1 - Breakthrough Magnet School, North Program           2019   pk_12_total 0 * *   0 0     0   0   * *     0             10   10 0       0 0     0   0           0       10   10
2452175 2452175 CT     school   640011   Hartford School District   644711 iGOAL 1 - Burns School Program           2019   pk_12_total 0 * 21   0 *     0   0   20 8     8             28   28 0   21   0       0   0   20 8     8       28   28
2452176 2452176 CT     school   640011   Hartford School District 90192001732 645711 iGOAL 1 - M.D. Fox School Program           2019   pk_12_total 0 * 16   0 *     0   0   * *     9             20   20 0   16   0       0   0           9       20   20
2452178 2452178 CT     school   640011   Hartford School District 90192001673 644411 iGOAL 1 - Rawson School Program           2019   pk_12_total 0 9 *   0 0     0   *   * *     *             18   18 0 9     0 0     0                       18   18
2452179 2452179 CT     school   640011   Hartford School District   649811 iGOAL 1 - Moylan School             2019   pk_12_total 0 * *   0 0     0   *   * *     *             *   * 0       0 0     0                            
2452180 2452180 CT     school   640011   Hartford School District   644611 RISE - West Middle School Program           2019   pk_12_total 0 * *   0 0     0   0   * *     0             *   * 0       0 0     0   0           0            
2452181 2452181 CT     school   640011   Hartford School District   645911 RISE - M.D. Fox School             2019   pk_12_total 0 7 11   0 0     0   0   * *     *             18   18 0 7 11   0 0     0   0                   18   18
2452189 2452189 CT     school   640011   Hartford School District   648911 iGOAL 1 - McDonough Middle School             2019   pk_12_total 0 * *   0 0     0   0   9 8     10             17   17 0       0 0     0   0   9 8     10       17   17
2452191 2452191 CT     school   640011   Hartford School District   640210 iGOAL 2 - Kennelly School Program           2019   pk_12_total 0 * *   0 0     0   0   * *     0             *   * 0       0 0     0   0           0            
2452201 2452201 CT     school   640011   Hartford School District 90192001677 648211 RISE - Hartford Public High School Program           2019   pk_12_total 0 6 19   0 0     0   0   * *     6             25   25 0 6 19   0 0     0   0           6       25   25
2452204 2452204 CT     school   640011   Hartford School District   645011 iGOAL 2 - Weaver High School             2019   pk_12_total 0 6 9   0 0     0   0   8 7     *             15   15 0 6 9   0 0     0   0   8 7             15   15
2452205 2452205 CT     school 901920 640011   Hartford School District 90192001522 646011 Culinary Arts Academy at Weaver High School   Regular School No High 11 12 2019   pk_12_total 0 11 13   0 0     0   0   14 10     6             7   24 0 11 13   0 0     0   0   14 10     6       7   24
2452207 2452207 CT     school   640011   Hartford School District 90192001727 648411 STEP at Hartford Public High School Program           2019   pk_12_total 0 14 17   0 0     0   0   16 15     12             31   31 0 14 17   0 0     0   0   16 15     12       31   31
2452220 2452220 CT     school   2450014   Learn   2451514 LEARN Integrated Program at TFS Program           2019   pk_12_total 0 0 *   0 0     0   0   * 0     0             *   * 0 0     0 0     0   0     0     0            
2452332 2452332 CT     school   830011   Middletown School District 90249001768 831911 MHS - Alternative Education Program 2 Program           2019   pk_12_total 0 * *   * 0     0   *   * *     0             *   * 0         0     0               0            
2452387 2452387 CT     school   890011   New Britain School District   891011 Lincoln SCS Program           2019   pk_12_total 0 * *   0 0     0   0   * *     0             *   * 0       0 0     0   0           0            
2452393 2452393 CT     school   890011   New Britain School District   891911 Smith Pathways Program           2019   pk_12_total 0 * *   0 0     0   0   * *     *             9   9 0       0 0     0   0                   9   9
2452420 2452420 CT     school   930011   New Haven School District   933411 Benjamin Jepson Head Start Program           2019   pk_12_total 0 * 9   0 0     0   *   10 6     0             8   16 0   9   0 0     0       10 6     0       8   16
2452435 2452435 CT     school   930011   New Haven School District   930510 Lincoln Bassett Integrated PK Program           2019   pk_12_total 0 * *   0 0     0   0   * *     0             *   13 0       0 0     0   0           0           13
2452442 2452442 CT     school   930011   New Haven School District   930410 West Rock Integrated PK Program           2019   pk_12_total 0 * *   0 0     0   0   * *     0             *   * 0       0 0     0   0           0            
2452451 2452451 CT     school   930011   New Haven School District   930310 Lincoln Bassett Self Contained Program           2019   pk_12_total 0 * *   0 0     0   0   * 0     0             *   * 0       0 0     0   0     0     0            
2452455 2452455 CT     school   930011   New Haven School District   937811 Clinton Self Contained ID Program           2019   pk_12_total 0 * *   0 0     0   0   6 8     7             14   14 0       0 0     0   0   6 8     7       14   14
2452468 2452468 CT     school   930011   New Haven School District   930210 James Hillhouse Self Contained MD Program           2019   pk_12_total 0 * *   0 0     0   0   * *     *             *   9 0       0 0     0   0                       9
2452478 2452478 CT     school   950011   New London School District   950711 Pre-Kindergarten at Winthrop Program           2019   pk_12_total 0 0 *   0 0     0   0   * *     0             *   * 0 0     0 0     0   0           0            
2452835 2452835 CT     school   1430011   Torrington School District   1430311 Post Secondary Transition Services Program           2019   pk_12_total 0 0 *   0 0     0   *   * 0     0             *   * 0 0     0 0     0         0     0            
2452901 2452901 CT     school   1510011   Waterbury School District   1514311 Bucks Hill Bilingual Program           2019   pk_12_total 0 0 210   0 0     0   0   108 102     *             44   210 0 0 210   0 0     0   0   108 102             44   210
2452908 2452908 CT     school   1510011   Waterbury School District   1514211 Hopeville Bilingual Program           2019   pk_12_total 0 0 127   0 0     0   0   67 60     127             17   127 0 0 127   0 0     0   0   67 60     127       17   127
2452913 2452913 CT     school   1510011   Waterbury School District   1510411 B.W. Tinker BDLC             2019   pk_12_total 0 * *   0 0     0   0   * *     0             8   8 0       0 0     0   0           0       8   8
2452914 2452914 CT     school   1510011   Waterbury School District   1517211 Hearing Lab Program           2019   pk_12_total 0 0 *   * 0     0   0   * 0     0             *   * 0 0       0     0   0     0     0            
2452916 2452916 CT     school   1510011   Waterbury School District   1511211 Woodrow Wilson BDLC Program           2019   pk_12_total 0 * 15   0 0     0   *   * *     0             24   24 0   15   0 0     0               0       24   24
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
2452928 2452928 CT     school   1510011   Waterbury School District   1515811 Wallace Bilingual Program           2019   pk_12_total 0 0 54   0 0     0   0   26 28     *             13   54 0 0 54   0 0     0   0   26 28             13   54
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            
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
2453020 2453020 CT     school   1590011   Wethersfield School District   1590311 STRIVE Program           2019   pk_12_total 0 0 *   0 0     0   0   * 0     0             *   * 0 0     0 0     0   0     0     0            
2453108 2453108 CT     school   3470015   Unified School District #2   3470215 Virtual Academy Program           2019   pk_12_total 0 0 *   0 0     0   0   * 0     0             0   * 0 0     0 0     0   0     0     0       0    
2453111 2453111 CT     school   3360015   Unified School District #1 90000300347 3360315 Cheshire Correctional Institution State Agency Facilities           2019   pk_12_total 0 * 0   0 0     0   0   * 0     0             *   * 0   0   0 0     0   0     0     0            
2453113 2453113 CT     school   3360015   Unified School District #1 90000301349 3362615 Northern Correctional Institution State Agency Facilities           2019   pk_12_total 0 * *   0 0     0   0   * 0     0             *   * 0       0 0     0   0     0     0            
2453114 2453114 CT     school   3360015   Unified School District #1 90000300361 3360615 Hartford Correctional Center State Agency Facilities           2019   pk_12_total 0 * *   0 0     0   0   * 0     0             *   * 0       0 0     0   0     0     0            
2453115 2453115 CT     school   3360015   Unified School District #1 90000300469 3362215 MacDougall/Walker Correctional Institution State Agency Facilities           2019   pk_12_total 0 * 0   0 0     0   0   * 0     0             *   * 0   0   0 0     0   0     0     0            
2453116 2453116 CT     school   3360015   Unified School District #1 90000300436 3361515 Willard/Cybulski Correctional Institution State Agency Facilities           2019   pk_12_total 0 0 0   0 0     0   *   * 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]);