enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2019 · 20,186 ✖
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
2452912 2452912 CT     school   1510011   Waterbury School District 90483000958 1519011 State Street School Program           2019   pk_12_total 8 24 65   0 *     0   *   77 25     24             *   102 8 24 65   0       0       77 25     24           102
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            
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            
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            
2452979 2452979 CT     school   1550011   West Hartford School District 90492001600 1559211 Strive-West Hartford Program           2019   pk_12_total 10 * 21   0 0     0   *   27 12     *             *   39 10   21   0 0     0       27 12                 39
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            
2452992 2452992 CT     school   1560011   West Haven School District   1560711 Blended Program           2019   pk_12_total 11 * 6   0 0     0   *   10 9     *             *   19 11   6   0 0     0       10 9                 19
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            
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            
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            
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                        
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            
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            
2453106 2453106 CT     school   3470015   Unified School District #2 90000400475 3470115 Children's Place School State Agency Facilities           2019   pk_12_total 7 * 10   0 0     0   *   24 0     *             *   24 7   10   0 0     0       24 0                 24
2453107 2453107 CT     school   3470015   Unified School District #2 90000400479 3470315 Riverview School State Agency Facilities           2019   pk_12_total 15 11 17   0 *     0   *   17 32     *             *   49 15 11 17   0       0       17 32                 49
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
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            
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            
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            
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
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            
2451830 2451830 CT     school   170011   Bristol School District 90051001746 173311 Bristol Preparatory Academy Program           2019   pk_12_total 18 * 15   0 0     0   *   28 9     *             0   37 18   15   0 0     0       28 9             0   37
2451854 2451854 CT     school   2410014   Capitol Region Education Council   2411414 River Street School Early Learning Center Program           2019   pk_12_total * * *   0 0     0   *   * *     0             0   8         0 0     0               0       0   8
2452004 2452004 CT     school   2420014   EdAdvance   2420314 Steps-North Expelled Student Program           2019   pk_12_total * * *   0 0     0   0   * 0     0             0   *         0 0     0   0     0     0       0    
2452268 2452268 CT     school   770011   Manchester School District   771111 Elementary Site 2             2019   pk_12_total * 0 0   0 *     0   0   * *     *             0   *   0 0   0       0   0                   0    
2452330 2452330 CT     school   830011   Middletown School District 90249001765 831711 Virtual Learning Academy - MHS Program           2019   pk_12_total * * 0   0 0     0   *   * *     0             0   6     0   0 0     0               0       0   6
2452331 2452331 CT     school   830011   Middletown School District 90249001657 831611 Evening Program - MHS Program           2019   pk_12_total 6 * *   0 0     0   *   7 6     0             0   13 6       0 0     0       7 6     0       0   13
2452375 2452375 CT     school   880011   Naugatuck School District   880911 Genesis Academy Program           2019   pk_12_total 8 * *   0 0     0   0   * *     *             0   15 8       0 0     0   0                   0   15
2452574 2452574 CT     school   1090011   Plainfield School District 90327001586 1098011 Early Childhood Center Program           2019   pk_12_total 11 * *   0 *     0   *   11 7     0             0   18 11       0       0       11 7     0       0   18
2452825 2452825 CT     school   1420011   Tolland School District 90456001738 1420311 TALC Program           2019   pk_12_total * * 0   0 0     0   0   * *     0             0   9     0   0 0     0   0           0       0   9
2452846 2452846 CT     school   1440011   Trumbull School District 90462001669 1440211 Trumbull Alternative School Program           2019   pk_12_total 19 0 *   0 *     0   0   * *     0             0   22 19 0     0       0   0           0       0   22
2452976 2452976 CT     school   1550011   West Hartford School District 90492001791 1557311 REACH Program           2019   pk_12_total 10 * 24   0 *     *   *   24 17     *             0   41 10   24   0               24 17             0   41
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    
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
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    
2451814 2451814 CT     school   170011   Bristol School District 90051001688 172611 Ivy Drive GOAL Program           2019   pk_12_total * * *   0 0     0   0   6 0     *             6   6         0 0     0   0   6 0             6   6
2451818 2451818 CT     school   170011   Bristol School District 90051001711 173111 South Side GOAL Program           2019   pk_12_total * 0 *   0 0     0   *   * *     0             6   6   0     0 0     0               0       6   6
2451824 2451824 CT     school   170011   Bristol School District 90051001651 172711 Northeast MS/Extended Resource Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             6   6   0     0 0     0   0           0       6   6
2451956 2451956 CT     school   420011   East Hampton School District 90123001514 429011 The Learning Center at East Hampton Program           2019   pk_12_total * 0 0   0 0     0   *   * *     0             6   6   0 0   0 0     0               0       6   6
2451991 2451991 CT     school   470011   East Windsor School District   470411 East Windsor Transition Program Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             6   6   0     0 0     0   0           0       6   6
2452028 2452028 CT     school   490011   Enfield School District   490911 John F. Kennedy - Adaptive Learning Program (ALP) Program           2019   pk_12_total * * *   0 *     0   0   * *     0             6   6         0       0   0           0       6   6
2452031 2452031 CT     school   490011   Enfield School District   490111 Enfield High - Adaptive Learning Program (ALP) Program           2019   pk_12_total * * 0   0 *     0   0   * *     0             6   6     0   0       0   0           0       6   6
2452149 2452149 CT     school 901920 640011   Hartford School District 90192001643 641311 Hartford PreKindergarten Magnet School Public Schools Regular School No Prekindergarten PK PK 2019   pk_12_total 12 50 23   * 57     0   *   71 80     0             6   151 12 50 23     57     0       71 80     0       6   151
2452159 2452159 CT     school   640011   Hartford School District   640510 Pre-K Integrated - Naylor School Program           2019   pk_12_total * 0 11   0 *     0   0   8 7     0             6   15   0 11   0       0   0   8 7     0       6   15
2452299 2452299 CT     school   800011   Meriden School District   801511 STARS-MS Program           2019   pk_12_total * 0 *   0 0     0   0   * *     *             6   6   0     0 0     0   0                   6   6
2452315 2452315 CT     school   830011   Middletown School District 90249001719 830811 ICM - Moody K-2 Program           2019   pk_12_total * * *   0 0     0   0   * *     0             6   6         0 0     0   0           0       6   6
2452324 2452324 CT     school   830011   Middletown School District 90249001793 830411 ICM- Woodrow Wilson Middle School Program           2019   pk_12_total * 0 *   0 *     0   0   * *     0             6   6   0     0       0   0           0       6   6
2452348 2452348 CT     school   840011   Milford School District   840411 Fifth Year Vocational Experience Program           2019   pk_12_total * * 0   0 0     0   0   * *     *             6   6     0   0 0     0   0                   6   6
2452414 2452414 CT     school 902760 920011   New Hartford School District 90276000539 920111 Bakerville Consolidated School Public Schools Regular School No Elementary KG 02 2019   pk_12_total 87 0 *   0 0     0   *   50 40     0             6   90 87 0     0 0     0       50 40     0       6   90
2452551 2452551 CT     school   1040011   Norwich School District   1040911 Stanton Special Learning Center Program           2019   pk_12_total * 0 *   0 0     0   0   6 0     0             6   6   0     0 0     0   0   6 0     0       6   6
2452553 2452553 CT     school   1040011   Norwich School District   1041211 Strive Program @ Stanton Program           2019   pk_12_total * * *   0 0     0   0   * *     *             6   6         0 0     0   0                   6   6
2452585 2452585 CT     school   1100011   Plainville School District   1100111 Plainville Transition Program Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             6   6   0     0 0     0   0           0       6   6
2452601 2452601 CT     school   1160011   Putnam School District 90348001518 1169011 Helping Hands Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             6   6   0     0 0     0   0           0       6   6
2452639 2452639 CT     school   2150012   Regional School District 15   2150112 MIJ Program Program           2019   pk_12_total * * 0   0 0     0   0   * *     0             6   13     0   0 0     0   0           0       6   13
2452666 2452666 CT     school   1180011   Ridgefield School District   1181111 District Program SRMS Program           2019   pk_12_total 6 0 0   0 0     0   0   6 0     0             6   6 6 0 0   0 0     0   0   6 0     0       6   6
2452694 2452694 CT     school   1260011   Shelton School District   1260211 Alternative Learning Center 1 Program           2019   pk_12_total * * *   0 0     0   0   6 0     *             6   6         0 0     0   0   6 0             6   6
2452799 2452799 CT     school   1380011   Stratford School District   1382711 ALL Class Room - Second Hill Lane Program           2019   pk_12_total * * *   0 0     0   0   6 0     0             6   6         0 0     0   0   6 0     0       6   6
2452803 2452803 CT     school   1380011   Stratford School District 90444001706 1381911 STEPS 7-8 Program           2019   pk_12_total * * *   0 0     0   0   * *     0             6   6         0 0     0   0           0       6   6
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
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
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
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
2453099 2453099 CT     school   2070012   Regional School District 07 90372001402 2079312 STEP Program           2019   pk_12_total 17 0 0   0 *     0   *   13 7     0             6   20 17 0 0   0       0       13 7     0       6   20
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
2451742 2451742 CT     school   110011   Bloomfield School District   110111 Steps to Success Program           2019   pk_12_total * * 0   0 0     0   *   7 0     0             7   7     0   0 0     0       7 0     0       7   7
2451799 2451799 CT     school   170011   Bristol School District 90051001728 172911 BECC Autism Program           2019   pk_12_total * * *   0 *     0   *   * *     0             7   7         0       0               0       7   7
2451826 2451826 CT     school   170011   Bristol School District 90051001661 170911 Greene-Hills GOAL Program           2019   pk_12_total * * *   0 0     0   0   * *     0             7   7         0 0     0   0           0       7   7
2451861 2451861 CT     school   2410014   Capitol Region Education Council 90070001489 2419214 Farmington Valley Regional Diagnostic Center Program           2019   pk_12_total * * 0   0 0     0   *   * *     0             7   7     0   0 0     0               0       7   7
2451883 2451883 CT     school   250011   Cheshire School District   251011 QU College Life Program           2019   pk_12_total 7 0 0   0 0     0   0   * *     0             7   7 7 0 0   0 0     0   0           0       7   7
2451896 2451896 CT     school   2430014   Cooperative Educational Services 90091001520 2438014 School Readiness Program           2019   pk_12_total * * 52   0 0     0   0   41 40     0             7   81     52   0 0     0   0   41 40     0       7   81
2451973 2451973 CT     school 901290 440011   East Haven School District 90129001350 441811 Overbrook Early Learning Center Public Schools Regular School No Prekindergarten PK PK 2019   pk_12_total 74 9 55   0 9     0   12   69 90     0             7   159 74 9 55   0 9     0   12   69 90     0       7   159
2452035 2452035 CT     school   510011   Fairfield School District   510811 Early Childhood Center(0510811) Program           2019   pk_12_total 7 0 0   0 0     0   0   * *     0             7   7 7 0 0   0 0     0   0           0       7   7
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
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
2452227 2452227 CT     school   2450014   Learn   2450814 Learn SAILS Middle School Program             2019   pk_12_total * * *   0 0     0   *   7 0     0             7   7         0 0     0       7 0     0       7   7
2452234 2452234 CT     school 903450 2450014   Learn 90345001617 2456214 Three Rivers Middle College Magnet School Regional Education Service Center Schools Regular School No High 11 12 2019   pk_12_total 42 * 14   * *     0   7   25 42     *             7   67 42   14           0   7   25 42             7   67
2452664 2452664 CT     school   1180011   Ridgefield School District   1180711 District Program RES Program           2019   pk_12_total * 0 0   0 0     0   *   * *     0             7   7   0 0   0 0     0               0       7   7
2452693 2452693 CT     school   1260011   Shelton School District   1261211 Therapeutic Learning Center Program           2019   pk_12_total * * *   0 0     0   0   7 0     *             7   7         0 0     0   0   7 0             7   7
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
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
2453141 2453141 CT     school   2190012   Regional School District 19 90000501729 2190112 E.O. Smith High School at the Depot Campus Program           2019   pk_12_total 16 0 *   0 0     0   *   14 6     0             7   20 16 0     0 0     0       14 6     0       7   20
2451724 2451724 CT     school   50011   Barkhamsted School District 90015001373 58011 Shared Services Integrated Preschool Program           2019   pk_12_total 17 0 0   0 0     0   0   9 8     0             8   17 17 0 0   0 0     0   0   9 8     0       8   17
2451855 2451855 CT     school   2410014   Capitol Region Education Council 90070001492 2419114 Soundbridge Program           2019   pk_12_total * 0 0   0 *     0   0   10 8     0             8   18   0 0   0       0   0   10 8     0       8   18
2451943 2451943 CT     school   370011   Derby School District   370511 RAISE Academy Program           2019   pk_12_total 9 * *   0 0     0   0   12 6     0             8   18 9       0 0     0   0   12 6     0       8   18
2451985 2451985 CT     school   450011   East Lyme School District 90132001760 450611 Coastal Connections Program           2019   pk_12_total * 0 0   0 0     0   *   9 6     0             8   15   0 0   0 0     0       9 6     0       8   15
2451987 2451987 CT     school   450011   East Lyme School District 90132001730 450511 Abilities in Motion (AIM) Program Program           2019   pk_12_total 6 * *   0 0     0   0   * *     0             8   8 6       0 0     0   0           0       8   8
2452012 2452012 CT     school 900216 2910013   Elm City Montessori School District 90021601683 2910113 Elm City Montessori School Public Charter Schools Regular School Yes Elementary PK 04 2019   pk_12_total 51 83 52   0 *     0   *   95 104     *             8   199 51 83 52   0       0       95 104             8   199
2452094 2452094 CT     school   570011   Greenwich School District   571511 Windrose Program           2019   pk_12_total * * 8   0 0     0   0   * *     *             8   20     8   0 0     0   0                   8   20
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
2452275 2452275 CT     school   770011   Manchester School District 90231001717 770711 New Horizons Program           2019   pk_12_total 6 8 9   * *     0   0   16 9     0             8   25 6 8 9           0   0   16 9     0       8   25

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