enrollments

Data source: Big Local News · About: Big Local

20,286 rows where state = "CT" and year = 2019 sorted by female_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
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
2451739 2451739 CT     school   90011   Bethel School District   90211 Community Partnership Program Program           2019   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
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
2451751 2451751 CT     school   120011   Bolton School District   120211 Bolton Transition Program Program           2019   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2451812 2451812 CT     school   170011   Bristol School District 90051001692 172311 Ivy Drive Medically Fragile Program           2019   pk_12_total * 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
2451827 2451827 CT     school   170011   Bristol School District 90051001796 172811 Northeast MS/GOAL Program           2019   pk_12_total * 0 *   0 0     0   0   * 0     *             *   *   0     0 0     0   0     0                  
2452003 2452003 CT     school   2420014   EdAdvance   2420414 ACCESS-South Expelled Student Program           2019   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
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    
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            
2452021 2452021 CT     school   490011   Enfield School District 90147001792 490311 Henry Barnard - Autism Spectrum Disorder (ASD) Program           2019   pk_12_total * * 0   0 0     0   0   * 0     0             *   *     0   0 0     0   0     0     0            
2452026 2452026 CT     school   490011   Enfield School District 90147001702 490711 Prudence Crandall - Educational Counseling Program (ECP) Program           2019   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2452126 2452126 CT     school   620011   Hamden School District   621611 Helen Street IIC Program           2019   pk_12_total * * 6   0 *     0   0   12 0     *             12   12     6   0       0   0   12 0             12   12
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            
2452226 2452226 CT     school   2450014   Learn   2451414 LEARN Diagnostic and Wellness Center Program           2019   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
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
2452235 2452235 CT     school   2450014   Learn 90345001757 2450414 LEARN Transition Academy Program           2019   pk_12_total * 0 *   0 *     0   0   * 0     *             *   *   0     0       0   0     0                  
2452322 2452322 CT     school   830011   Middletown School District 90249001652 830711 ICM - Moody 3-5 Program           2019   pk_12_total * * *   0 0     0   *   * 0     0             *   *         0 0     0         0     0            
2452323 2452323 CT     school   830011   Middletown School District   832011 ICM - Spencer Program           2019   pk_12_total * * *   0 0     0   *   8 0     0             8   8         0 0     0       8 0     0       8   8
2452363 2452363 CT     school   860011   Montville School District   860611 Montville Transition and Vocational Training Academy Program           2019   pk_12_total 6 * 0   0 *     0   0   8 0     *             8   8 6   0   0       0   0   8 0             8   8
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            
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
2452604 2452604 CT     school   2010012   Regional School District 01   2010412 LEAPSS Program           2019   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2452631 2452631 CT     school   2140012   Regional School District 14   2140412 Region 14 Transition Academy Program           2019   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2452665 2452665 CT     school   1180011   Ridgefield School District   1180911 District Program SES Program           2019   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
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
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
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
2452738 2452738 CT     school   1310011   Southington School District 90423001720 1311611 Therapeutic Educational Alternative Model (TEAM) Program           2019   pk_12_total * 0 0   0 0     0   *   10 0     0             10   10   0 0   0 0     0       10 0     0       10   10
2452786 2452786 CT     school   1370011   Stonington School District   1370711 SAILS Program           2019   pk_12_total * 0 *   0 0     0   0   7 0     0             *   7   0     0 0     0   0   7 0     0           7
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
2452802 2452802 CT     school   1380011   Stratford School District 90444001756 1381811 Middle School Sails Program           2019   pk_12_total * * *   * 0     0   0   8 0     *             8   8           0     0   0   8 0             8   8
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            
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            
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            
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            
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            
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            
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
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    
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
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            
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            
2451705 2451705 CT     school   20011   Ansonia School District   20411 P.A.C.E. - PM (Positive And Creative Education - PM) Program           2019   pk_12_total * * *   0 0     0   0   0 6     0             *   6         0 0     0   0   0 6     0           6
2451881 2451881 CT     school   250011   Cheshire School District 90075001682 250911 Humiston Alternative School Program           2019   pk_12_total 12 * *   0 0     0   0   11 6     0             *   17 12       0 0     0   0   11 6     0           17
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
2452001 2452001 CT     school   2420014   EdAdvance   2420114 Steps Program           2019   pk_12_total 14 * *   0 0     0   *   16 6     0             22   22 14       0 0     0       16 6     0       22   22
2452002 2452002 CT     school   2420014   EdAdvance   2420214 Torrington Alternative Program             2019   pk_12_total 10 * *   * 0     0   *   11 6     0             *   17 10         0     0       11 6     0           17
2452032 2452032 CT     school   490011   Enfield School District 90147001523 499011 Enfield Transitional Learning Academy Program           2019   pk_12_total * * 0   0 0     0   0   6 6     0             12   12     0   0 0     0   0   6 6     0       12   12
2452108 2452108 CT     school   590011   Groton School District   590611 Apex Academy Program           2019   pk_12_total 8 0 6   * 0     0   *   11 6     *             11   17 8 0 6     0     0       11 6             11   17
2452109 2452109 CT     school   590011   Groton School District   590211 New Beginnings Alternative Program Program           2019   pk_12_total 6 * *   0 0     *   *   9 6     0             15   15 6       0 0             9 6     0       15   15
2452133 2452133 CT     school   620011   Hamden School District   621711 Ridge Hill IIC Program           2019   pk_12_total * 12 *   0 *     0   0   16 6     *             22   22   12     0       0   0   16 6             22   22
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

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