enrollments

Data source: Big Local News · About: Big Local

4,354 rows where grade = "pk_12_total" and state = "CT" sorted by hispanic_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • pk_12_total · 4,354 ✖
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
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
2451711 2451711 CT     school   2440014   Area Cooperative Educational Services 90007001588 2449614 Center for Autism Spectrum and Development Disorders Program           2019   pk_12_total 26 8 *   0 *     0   *   30 10     0             40   40 26 8     0       0       30 10     0       40   40
2451714 2451714 CT     school   2440014   Area Cooperative Educational Services   2449314 Whitney High School West             2019   pk_12_total 9 9 *   0 *     0   0   * *     *             26   26 9 9     0       0   0                   26   26
2451717 2451717 CT     school   40011   Avon School District 90012001737 40111 Avon Early Learning Center at Roaring Brook School Program           2019   pk_12_total 31 10 *   0 10     0   *   34 24     0             24   58 31 10     0 10     0       34 24     0       24   58
2451731 2451731 CT     school   70011   Berlin School District   70311 Transition Academy Program           2019   pk_12_total * 0 *   0 0     0   0   * *     *             *   *   0     0 0     0   0                        
2451738 2451738 CT     school   90011   Bethel School District   90311 TASK Program           2019   pk_12_total * 0 *   0 *     0   *   * *     *             *   12   0     0       0                           12
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
2451752 2451752 CT     school 900390 130011   Bozrah School District 90039000038 130111 Fields Memorial School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 157 * *   0 0     0   21   112 89     *             27   201 157       0 0     0   21   112 89             27   201
2451759 2451759 CT     school   140011   Branford School District 90042001742 140211 Branford High School Atlas Program Program           2019   pk_12_total 35 * *   0 0     0   0   22 18     0             11   40 35       0 0     0   0   22 18     0       11   40
2451798 2451798 CT     school   150011   Bridgeport School District   152811 The Transition Academy Program           2019   pk_12_total * 16 *   0 0     0   0   19 8     *             27   27   16     0 0     0   0   19 8             27   27
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
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            
2451809 2451809 CT     school   170011   Bristol School District 90051001707 173211 Stafford Autism Program           2019   pk_12_total * * *   0 *     0   0   * *     0             10   10         0       0   0           0       10   10
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            
2451813 2451813 CT     school   170011   Bristol School District 90051001646 172111 Hubbell/Extended Resource Program           2019   pk_12_total * 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
2451815 2451815 CT     school   170011   Bristol School District   173711 Hubbell Autism Program Program           2019   pk_12_total * * *   0 *     0   0   * *     *             9   9         0       0   0                   9   9
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
2451821 2451821 CT     school   170011   Bristol School District   171611 Chippens Hill Middle School Medically Fragile Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             *   *   0     0 0     0   0           0            
2451822 2451822 CT     school   170011   Bristol School District   170811 Chippens Hilll Middle School Extended Resource Program           2019   pk_12_total 6 0 *   0 *     0   0   * *     *             13   13 6 0     0       0   0                   13   13
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
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
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                  
2451831 2451831 CT     school   170011   Bristol School District   170211 ACCESS Program           2019   pk_12_total * 0 *   0 0     0   0   * *     *             10   10   0     0 0     0   0                   10   10
2451832 2451832 CT     school   170011   Bristol School District 90051001515 179211 Community/Vocational Program Program           2019   pk_12_total 11 * *   0 0     0   *   * *     *             17   17 11       0 0     0                       17   17
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
2451858 2451858 CT     school   2410014   Capitol Region Education Council   2411714 Soundbridge@Mountain View Elementary School             2019   pk_12_total * 0 *   0 *     0   0   * *     0             10   10   0     0       0   0           0       10   10
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            
2451871 2451871 CT     school   2410014   Capitol Region Education Council   2419614 Lincoln Academy Regional Interdistrict Collaborative             2019   pk_12_total * * *   0 0     0   0   * *     0             *   7         0 0     0   0           0           7
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
2451893 2451893 CT     school   280011   Colchester School District   280511 Bacon Academy Alternative Education Program           2019   pk_12_total * 0 *   0 0     0   0   6 *     0             *   10   0     0 0     0   0   6       0           10
2451902 2451902 CT     school   320011   Coventry School District   320311 Hale Early Education Center Program           2019   pk_12_total 90 0 *   0 *     0   *   43 55     0             13   98 90 0     0       0       43 55     0       13   98
2451906 2451906 CT     school   320011   Coventry School District 90096001787 320111 Coventry Academy Public Schools           2019   pk_12_total * 0 *   0 0     0   0   12 7     0             12   19   0     0 0     0   0   12 7     0       12   19
2451931 2451931 CT     school   340011   Danbury School District   340711 Western Connection Program           2019   pk_12_total 7 * *   0 0     0   0   * *     0             9   9 7       0 0     0   0           0       9   9
2451932 2451932 CT     school 901050 350011   Darien School District 90105000165 350211 Hindley Elementary School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 386 * *   0 28     0   23   249 211     7             60   460 386       0 28     0   23   249 211     7       60   460
2451936 2451936 CT     school 901050 350011   Darien School District 90105000498 350711 Holmes Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 380 * *   0 23     0   25   230 219     9             53   449 380       0 23     0   25   230 219     9       53   449
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
2451947 2451947 CT     school 901170 400011   East Granby School District 90117000182 405111 East Granby Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 155 16 *   0 16     0   *   107 94     0             29   201 155 16     0 16     0       107 94     0       29   201
2451980 2451980 CT     school   450011   East Lyme School District 90132001450 458011 Integrated Preschool Program           2019   pk_12_total 49 * *   0 *     0   *   31 26     0             28   57 49       0       0       31 26     0       28   57
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
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
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
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    
2452008 2452008 CT     school 901440 480011   Ellington School District 90144000238 485111 Ellington Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 352 20 *   * 43     0   13   225 213     *             56   438 352 20       43     0   13   225 213             56   438
2452013 2452013 CT     school 901470 490011   Enfield School District 90147001915 492211 EPS Integrated Pre-Kindergarten Program Special Education School No Prekindergarten PK PK 2019   pk_12_total 62 * *   0 *     0   *   48 26     0             46   74 62       0       0       48 26     0       46   74
2452023 2452023 CT     school   490011   Enfield School District 90147001676 490511 Edgar H. Parkman - Autism Spectrum Disorder (ASD) Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             *   *   0     0 0     0   0           0            
2452025 2452025 CT     school   490011   Enfield School District   491411 Eli Whitney - Intermediate Adaptive Learning (IAL) Program           2019   pk_12_total * 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            
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
2452052 2452052 CT     school   510011   Fairfield School District   510311 Walter Fitzgerald Campus Program           2019   pk_12_total * 0 *   0 0     0   0   15 8     0             *   23   0     0 0     0   0   15 8     0           23
2452053 2452053 CT     school   510011   Fairfield School District   510511 Fairfield School/Community Partnership Program           2019   pk_12_total 10 * *   0 *     0   0   8 7     *             15   15 10       0       0   0   8 7             15   15
2452062 2452062 CT     school   520011   Farmington School District 90156001713 520611 Farmington Alternative High School Program           2019   pk_12_total 6 0 *   0 *     0   *   * *     *             *   9 6 0     0       0                           9
2452074 2452074 CT     school   540011   Glastonbury School District 90162001752 541411 Glastonbury Transition Academy Program           2019   pk_12_total 13 * *   0 *     0   0   * *     *             17   17 13       0       0   0                   17   17
2452095 2452095 CT     school   570011   Greenwich School District 90171001664 571211 Community Connections Program           2019   pk_12_total 11 * *   0 *     0   0   12 7     0             19   19 11       0       0   0   12 7     0       19   19
2452098 2452098 CT     school 901740 580011   Griswold School District 90174001721 580111 Griswold Alternative School Public Schools Alternative School No High 09 12 2019   pk_12_total 10 * *   0 0     0   *   * *     0             *   14 10       0 0     0               0           14
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
2452111 2452111 CT     school   590011   Groton School District   591011 Transition Academy Program           2019   pk_12_total 11 * *   0 0     0   *   * *     0             15   15 11       0 0     0               0       15   15
2452132 2452132 CT     school   620011   Hamden School District   620911 Bear Path IIC Program           2019   pk_12_total 6 9 *   0 0     0   *   * *     *             24   24 6 9     0 0     0                       24   24
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
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
2452136 2452136 CT     school   620011   Hamden School District 90186001741 620511 Hamden Collaborative Learning Center Program           2019   pk_12_total 12 24 *   0 0     0   *   29 17     0             28   46 12 24     0 0     0       29 17     0       28   46
2452139 2452139 CT     school 901890 630011   Hampton School District 90189000351 630111 Hampton Elementary School Public Schools Regular School No Elementary PK 06 2019   pk_12_total 82 0 *   * *     0   6   51 42     0             17   93 82 0             0   6   51 42     0       17   93
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
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
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            
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            
2452206 2452206 CT     school 901920 640011   Hartford School District 90192001650 643911 Capital Community College Magnet Academy   Regular School No High 12 12 2019   pk_12_total * 7 *   0 0     0   *   * *     0             *   11   7     0 0     0               0           11
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            
2452224 2452224 CT     school   2450014   Learn 90345001680 2451114 Learn Intensive Program Program           2019   pk_12_total * * *   0 0     0   *   * *     *             15   15         0 0     0                       15   15
2452225 2452225 CT     school   2450014   Learn   2451614 LEARN SAILS Program Program           2019   pk_12_total 6 * *   0 0     0   *   * *     0             11   11 6       0 0     0               0       11   11
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
2452230 2452230 CT     school   2450014   Learn   2450514 Learn Pathways Program             2019   pk_12_total * 0 *   0 0     0   0   * *     0             *   *   0     0 0     0   0           0            
2452233 2452233 CT     school   2450014   Learn 90345001795 2450614 Learn High School Program           2019   pk_12_total * 0 *   0 *     0   0   * *     0             *   *   0     0       0   0           0            
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                  
2452251 2452251 CT     school   760011   Madison School District 90228001549 769011 Town Campus Learning Center Program           2019   pk_12_total 44 0 *   0 *     *   0   30 20     0             26   50 44 0     0           0   30 20     0       26   50
2452254 2452254 CT     school 902280 760011   Madison School District 90228000413 760311 Kathleen H. Ryerson Elementary School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 169 0 *   0 13     0   *   107 87     *             22   194 169 0     0 13     0       107 87             22   194
2452260 2452260 CT     school   770011   Manchester School District   770811 Manchester Preschool - Site 2 Program           2019   pk_12_total 19 * *   0 7     0   0   24 10     0             19   34 19       0 7     0   0   24 10     0       19   34
2452293 2452293 CT     school   800011   Meriden School District   802211 SOAR- ES Program           2019   pk_12_total * * *   0 0     0   0   * *     0             9   9         0 0     0   0           0       9   9
2452296 2452296 CT     school   800011   Meriden School District   802411 SOAR - WMS Program           2019   pk_12_total * * *   0 0     0   0   * *     *             14   14         0 0     0   0                   14   14
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
2452310 2452310 CT     school   800011   Meriden School District 90240001800 800211 Community Classroom Collaborative Program           2019   pk_12_total * * *   * 0     0   0   * *     *             11   11           0     0   0                   11   11
2452311 2452311 CT     school   800011   Meriden School District   802111 Community Collaborative Classroom - ACADEMY Program           2019   pk_12_total * * *   0 0     0   0   * *     *             8   8         0 0     0   0                   8   8
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
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
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
2452327 2452327 CT     school   830011   Middletown School District 90249001722 831811 MHS - Alternative Education Program 1 Program           2019   pk_12_total * * *   0 0     0   0   * *     0             *   8         0 0     0   0           0           8
2452328 2452328 CT     school   830011   Middletown School District   832211 MHS- Alternative Education Program 3 Program           2019   pk_12_total 7 * *   0 0     0   0   * *     0             *   11 7       0 0     0   0           0           11
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
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            
2452333 2452333 CT     school   830011   Middletown School District 90249001598 839111 Middletown Transition Center Program           2019   pk_12_total 10 * *   * 0     0   *   14 6     *             20   20 10         0     0       14 6             20   20
2452347 2452347 CT     school   840011   Milford School District 90252001679 840311 The Academy Program           2019   pk_12_total 39 * *   0 0     0   *   31 18     0             15   49 39       0 0     0       31 18     0       15   49
2452355 2452355 CT     school   850011   Monroe School District 90255001670 850211 Masuk Alternative Program Program           2019   pk_12_total 12 0 *   0 0     0   *   * *     0             *   15 12 0     0 0     0               0           15
2452362 2452362 CT     school   860011   Montville School District 90258001481 869011 Palmer Academy Program           2019   pk_12_total 29 * *   0 0     0   *   24 14     0             17   38 29       0 0     0       24 14     0       17   38

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