enrollments

Data source: Big Local News · About: Big Local

4,354 rows where grade = "pk_12_total" and state = "CT" sorted by disability_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
2451704 2451704 CT     school   20011   Ansonia School District 90006001678 20111 P.A.C.E. (Positive And Creative Education) Program           2019   pk_12_total * 8 15   0 0     0   *   18 9     0             *   27   8 15   0 0     0       18 9     0           27
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
2451709 2451709 CT     school   2440014   Area Cooperative Educational Services 90007001505 2449414 Mill Academy Program           2019   pk_12_total 20 68 40   0 0     0   6   107 27     *             *   134 20 68 40   0 0     0   6   107 27                 134
2451725 2451725 CT     school   50011   Barkhamsted School District   50211 Bridges at Barkhamsted Elementary School Program           2019   pk_12_total * 0 0   0 0     0   *   * *     0             *   *   0 0   0 0     0               0            
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
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            
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
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            
2451785 2451785 CT     school   150011   Bridgeport School District 90045001472 159011 Bridgeport Learning Center Program           2019   pk_12_total * 37 32   0 *     0   0   64 9     *             *   73   37 32   0       0   0   64 9                 73
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            
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            
2451816 2451816 CT     school   170011   Bristol School District   172411 Mt. View Extended Resource Program           2019   pk_12_total * 0 0   0 0     0   0   0 *     0             *   *   0 0   0 0     0   0   0       0            
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            
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                  
2451845 2451845 CT     school   230011   Canton School District 90069001695 230411 Canton Academy 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            
2451870 2451870 CT     school   2410014   Capitol Region Education Council   2419414 IPM @ Plainville High School             2019   pk_12_total * * 0   0 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
2451892 2451892 CT     school   280011   Colchester School District   280611 School Resilience Program             2019   pk_12_total 7 0 0   0 0     0   0   * *     0             *   7 7 0 0   0 0     0   0           0           7
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
2451966 2451966 CT     school   430011   East Hartford School District 90126000205 439011 Woodland School Program           2019   pk_12_total 20 63 82   * *     0   9   146 32     11             *   178 20 63 82           0   9   146 32     11           178
2451969 2451969 CT     school 901260 430011   East Hartford School District 90126001477 436311 Connecticut IB Academy Public Schools Regular School No High 09 12 2019   pk_12_total 43 59 48   * 35     0   *   83 108     6             *   191 43 59 48     35     0       83 108     6           191
2452000 2452000 CT     school   2420014   EdAdvance 90351201476 2429014 The ACCESS School at The Danuta M. Thibodeau Education Center Program           2019   pk_12_total 17 0 7   0 0     0   0   * *     0             *   24 17 0 7   0 0     0   0           0           24
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
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            
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            
2452011 2452011 CT     school   480011   Ellington School District   480411 Ellington Continuing Life Independence Post-Secondary Education (ECLIPSE) Program           2019   pk_12_total * 0 0   0 *     0   0   * *     0             *   *   0 0   0       0   0           0            
2452018 2452018 CT     school   490011   Enfield School District 90147001743 490811 Henry Barnard - Primary Adaptive Learning (PAL) Program           2019   pk_12_total * * 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            
2452022 2452022 CT     school   490011   Enfield School District 90147001696 490611 Henry Barnard - Educational Counseling Program (ECP) Program           2019   pk_12_total * 0 0   0 0     0   *   0 *     0             *   *   0 0   0 0     0       0       0            
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            
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
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
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
2452146 2452146 CT     school   640011   Hartford School District 90192001723 644111 Early Childhood Development Center (ECDC) Program           2019   pk_12_total * 9 32   0 *     0   *   33 11     0             *   44   9 32   0       0       33 11     0           44
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            
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            
2452182 2452182 CT     school 901920 640011   Hartford School District 90192001582 644011 Renzulli Gifted and Talented Academy Public Schools Regular School No Middle 04 08 2019   pk_12_total 9 53 49   * *     0   6   64 59     *             *   123 9 53 49           0   6   64 59                 123
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            
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            
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                  
2452270 2452270 CT     school   770011   Manchester School District   771511 Manchester Middle Academy Program           2019   pk_12_total 9 * 11   0 0     0   *   21 6     0             *   27 9   11   0 0     0       21 6     0           27
2452286 2452286 CT     school   800011   Meriden School District   802611 PRIDE Program           2019   pk_12_total 33 8 50   0 *     0   *   77 22     0             *   99 33 8 50   0       0       77 22     0           99
2452321 2452321 CT     school   830011   Middletown School District 90249001758 830611 ICM - Farm Hill Program           2019   pk_12_total * * 0   0 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            
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
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            
2452349 2452349 CT     school   840011   Milford School District   840611 Post Grad Transitional Academy Program           2019   pk_12_total * 0 0   0 *     0   0   * *     0             *   *   0 0   0       0   0           0            
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
2452364 2452364 CT     school   880011   Naugatuck School District 90264001591 888211 Central Avenue Preschool Program           2019   pk_12_total 18 * 9   0 0     0   *   21 9     0             *   30 18   9   0 0     0       21 9     0           30
2452384 2452384 CT     school   890011   New Britain School District   890211 Chamberlain Bridges Program           2019   pk_12_total * * 19   0 0     0   0   * *     *             *   24     19   0 0     0   0                       24
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            
2452392 2452392 CT     school   890011   New Britain School District 90267001566 899011 New Britain Transition Center Program           2019   pk_12_total * * 34   0 0     0   0   30 17     *             *   47     34   0 0     0   0   30 17                 47
2452394 2452394 CT     school 902670 890011   New Britain School District 90267001445 895411 House of Arts Letters and Science (HALS) Academy Public Schools Regular School No Middle 06 08 2019   pk_12_total 61 15 58   0 *     0   *   68 80     0             *   148 61 15 58   0       0       68 80     0           148
2452407 2452407 CT     school   900011   New Canaan School District   900111 Launch Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             *   *   0     0 0     0   0           0            
2452412 2452412 CT     school   910011   New Fairfield School District 90273001687 910311 Alternative Learning Center Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             *   7   0     0 0     0   0           0           7
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            
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            
2452512 2452512 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2019   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2452545 2452545 CT     school   1040011   Norwich School District 90312001745 1040211 Case Street Early Learning Center at DTZ Program           2019   pk_12_total 10 18 18   * *     *   9   25 35     0             *   60 10 18 18               9   25 35     0           60
2452573 2452573 CT     school   1080011   Oxford School District   1080411 Connections Alternative Learning Center Program           2019   pk_12_total 6 0 0   0 0     0   0   * *     0             *   6 6 0 0   0 0     0   0           0           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            
2452605 2452605 CT     school   2010012   Regional School District 01   2010312 SELC Program           2019   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2452606 2452606 CT     school   2010012   Regional School District 01   2010612 Mountaineer Academy Program           2019   pk_12_total * 0 0   0 0     0   0   0 *     0             *   *   0 0   0 0     0   0   0       0            
2452618 2452618 CT     school 903530 2120012   Regional School District 12 90353000734 2120112 The Burnham School Regional Schools Regular School No Elementary KG 05 2019   pk_12_total 48 0 *   0 *     0   *   29 24     *             *   53 48 0     0       0       29 24                 53
2452620 2452620 CT     school   2120012   Regional School District 12   2120512 Shepaug Valley Partnership 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            
2452643 2452643 CT     school   2160012   Regional School District 16 90353801747 2160412 WRHS Alternative Education Program Program           2019   pk_12_total 7 * *   0 0     *   0   * *     0             *   10 7       0 0         0           0           10
2452650 2452650 CT     school   2170012   Regional School District 17   2170412 RSD17 Transition Program Program           2019   pk_12_total * 0 0   0 *     0   0   * *     0             *   *   0 0   0       0   0           0            
2452656 2452656 CT     school   2180012   Regional School District 18   2180412 Alternative Program Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             *   *   0     0 0     0   0           0            
2452662 2452662 CT     school   1180011   Ridgefield School District   1180111 District Program BMES 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            
2452669 2452669 CT     school   1180011   Ridgefield School District   1181011 District Program ERMS Program           2019   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2452670 2452670 CT     school   1180011   Ridgefield School District 90381001763 1188011 Alternative High School Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             *   11   0     0 0     0   0           0           11
2452676 2452676 CT     school   1190011   Rocky Hill School District   1190311 Pathways Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             *   7   0     0 0     0   0           0           7
2452692 2452692 CT     school   1260011   Shelton School District   1260311 Life Skills Program           2019   pk_12_total * 0 0   0 0     0   *   * *     0             *   *   0 0   0 0     0               0            
2452712 2452712 CT     school   1290011   Somers School District   1290511 Aspire Program           2019   pk_12_total * * 0   0 0     0   0   * *     0             *   *     0   0 0     0   0           0            
2452719 2452719 CT     school 904170 1320011   South Windsor School District 90417000826 1320311 Alternative Education Program Program Regular School No High 09 12 2019   pk_12_total * * 0   0 0     0   0   * *     0             *   12     0   0 0     0   0           0           12
2452750 2452750 CT     school   1340011   Stafford School District   1340211 Stafford Tutoring Program             2019   pk_12_total * 0 0   0 0     0   *   * *     0             *   7   0 0   0 0     0               0           7
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
2452797 2452797 CT     school   1380011   Stratford School District   1382311 DLC Whitney Program           2019   pk_12_total * * 0   0 0     0   0   * *     0             *   *     0   0 0     0   0           0            
2452826 2452826 CT     school   1430011   Torrington School District   1432211 East TPS - PreK - Reg Ed             2019   pk_12_total 12 * 30   0 *     0   0   26 18     0             *   44 12   30   0       0   0   26 18     0           44
2452827 2452827 CT     school   1430011   Torrington School District 90459001697 1431611 Pre-K SpEd Program           2019   pk_12_total 19 0 *   0 *     0   0   23 7     0             *   30 19 0     0       0   0   23 7     0           30
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            
2452873 2452873 CT     school   1480011   Wallingford School District   1480611 Benhaven ABC Intermediate Program Program           2019   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2452878 2452878 CT     school   1480011   Wallingford School District   1480511 Education Enhancement Program             2019   pk_12_total 14 0 6   0 0     0   0   13 7     *             *   20 14 0 6   0 0     0   0   13 7                 20

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