enrollments

Data source: Big Local News · About: Big Local

1,461 rows where grade = "pk_12_total", state = "CT" and year = 2020 sorted by ccd_school_low_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 1,461 ✖

grade ✖

  • pk_12_total · 1,461 ✖
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
2777726 2777726 CT     school   20011   Ansonia School District   20911 Ansonia Public Schools Pre-K Program Program           2020   pk_12_total 32 16 41   0 *     0   *   58 35     0             30   93 32 16 41   0       0       58 35     0       30   93
2777731 2777731 CT     school   20011   Ansonia School District 90006001678 20111 P.A.C.E. (Positive And Creative Education) Program           2020   pk_12_total * 10 13   0 0     0   *   17 12     0             6   29   10 13   0 0     0       17 12     0       6   29
2777732 2777732 CT     school   20011   Ansonia School District   20411 P.A.C.E. - PM (Positive And Creative Education - PM) Program           2020   pk_12_total 0 * *   0 0     0   0   * *     0             *   8 0       0 0     0   0           0           8
2777733 2777733 CT     school   20011   Ansonia School District   21011 Ansonia 18-21 Transition Program Program           2020   pk_12_total * 0 *   0 0     0   *   * *     *             7   7   0     0 0     0                       7   7
2777734 2777734 CT     school   2440014   Area Cooperative Educational Services 90007001499 2449514 Village School Program           2020   pk_12_total 44 48 29   * *     *   *   97 32     *             129   129 44 48 29                   97 32             129   129
2777735 2777735 CT     school   2440014   Area Cooperative Educational Services   2440214 ACES Mill Elementary School Program           2020   pk_12_total * 44 22   0 0     0   *   71 15     *             *   86   44 22   0 0     0       71 15                 86
2777737 2777737 CT     school   2440014   Area Cooperative Educational Services   2440414 ACES at Mead Elementary School Program           2020   pk_12_total 0 * *   0 0     0   *   * *     0             *   * 0       0 0     0               0            
2777738 2777738 CT     school   2440014   Area Cooperative Educational Services 90007001505 2449414 Mill Academy Program           2020   pk_12_total 15 46 34   0 0     0   7   85 17     0             95   102 15 46 34   0 0     0   7   85 17     0       95   102
2777740 2777740 CT     school   2440014   Area Cooperative Educational Services 90007001588 2449614 Center for Autism Spectrum and Development Disorders Program           2020   pk_12_total 25 7 *   0 *     0   *   30 10     0             40   40 25 7     0       0       30 10     0       40   40
2777741 2777741 CT     school   2440014   Area Cooperative Educational Services 90007001502 2449214 Whitney Academy Program           2020   pk_12_total 43 22 30   0 *     0   *   75 25     *             100   100 43 22 30   0       0       75 25             100   100
2777742 2777742 CT     school   2440014   Area Cooperative Educational Services 90007001490 2449114 Whitney High School North Program           2020   pk_12_total 13 54 25   0 0     *   *   77 24     *             101   101 13 54 25   0 0             77 24             101   101
2777743 2777743 CT     school   2440014   Area Cooperative Educational Services   2440114 CREATE at Whitney Academy Program           2020   pk_12_total 20 16 21   0 *     0   *   41 19     *             60   60 20 16 21   0       0       41 19             60   60
2777745 2777745 CT     school   40011   Avon School District 90012001737 40111 Avon Early Learning Center at Roaring Brook School Program           2020   pk_12_total 29 11 *   * 10     0   *   29 27     0             23   56 29 11       10     0       29 27     0       23   56
2777752 2777752 CT     school   50011   Barkhamsted School District 90015001373 58011 Shared Services Integrated Preschool Program           2020   pk_12_total 17 0 0   0 0     0   0   10 7     0             6   17 17 0 0   0 0     0   0   10 7     0       6   17
2777753 2777753 CT     school   50011   Barkhamsted School District   50211 Bridges at Barkhamsted Elementary School Program           2020   pk_12_total * 0 0   0 0     0   *   * *     0             *   *   0 0   0 0     0               0            
2777759 2777759 CT     school   70011   Berlin School District   70311 Transition Academy Program           2020   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2777766 2777766 CT     school   90011   Bethel School District   90311 TASK Program           2020   pk_12_total 6 0 *   0 *     0   *   * *     *             *   12 6 0     0       0                           12
2777767 2777767 CT     school   90011   Bethel School District   90211 Community Partnership Program Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             6   6   0     0 0     0   0           0       6   6
2777770 2777770 CT     school   110011   Bloomfield School District   110111 Steps to Success Program           2020   pk_12_total * 9 *   0 0     0   0   11 0     0             11   11   9     0 0     0   0   11 0     0       11   11
2777779 2777779 CT     school   120011   Bolton School District   120211 Bolton Transition Program Program           2020   pk_12_total * 0 0   0 0     0   0   0 *     0             *   *   0 0   0 0     0   0   0       0            
2777781 2777781 CT     school   140011   Branford School District 90042000177 148011 Indian Neck School Program           2020   pk_12_total 33 * 10   0 *     0   *   29 21     0             27   50 33   10   0       0       29 21     0       27   50
2777787 2777787 CT     school   140011   Branford School District 90042001742 140211 Branford High School Atlas Program Program           2020   pk_12_total 20 * *   0 0     0   0   18 9     0             *   27 20       0 0     0   0   18 9     0           27
2777788 2777788 CT     school   140011   Branford School District   140311 Access Transition Program Program           2020   pk_12_total * 0 0   0 *     0   0   * *     *             15   15   0 0   0       0   0                   15   15
2777819 2777819 CT     school   150011   Bridgeport School District 90045001472 159011 Bridgeport Learning Center Program           2020   pk_12_total 0 44 *   0 *     0   0   67 9     7             *   76 0 44     0       0   0   67 9     7           76
2777827 2777827 CT     school   150011   Bridgeport School District   152811 The Transition Academy Program           2020   pk_12_total 0 16 *   0 *     0   0   22 6     *             28   28 0 16     0       0   0   22 6             28   28
2777828 2777828 CT     school   170011   Bristol School District 90051001728 172911 BECC Autism Program           2020   pk_12_total * 0 *   0 0     0   *   * *     0             6   6   0     0 0     0               0       6   6
2777836 2777836 CT     school   170011   Bristol School District   173811 Greene Hills Extended Resource Program           2020   pk_12_total * 0 *   0 *     0   0   * *     *             6   6   0     0       0   0                   6   6
2777837 2777837 CT     school   170011   Bristol School District 90051001692 172311 Ivy Drive Medically Fragile Program           2020   pk_12_total * * *   0 0     0   0   * *     0             *   *         0 0     0   0           0            
2777838 2777838 CT     school   170011   Bristol School District   172411 Mt. View Extended Resource Program           2020   pk_12_total * * *   0 0     0   0   * *     *             *   *         0 0     0   0                        
2777839 2777839 CT     school   170011   Bristol School District 90051001755 173011 South Side Extended Resource Program           2020   pk_12_total * * 6   0 0     0   *   * *     *             11   11     6   0 0     0                       11   11
2777840 2777840 CT     school   170011   Bristol School District 90051001707 173211 Stafford Autism Program           2020   pk_12_total * * *   * *     0   0   * *     0             14   14                 0   0           0       14   14
2777843 2777843 CT     school   170011   Bristol School District 90051001646 172111 Hubbell/Extended Resource Program           2020   pk_12_total 0 0 *   0 *     0   0   * *     0             *   * 0 0     0       0   0           0            
2777844 2777844 CT     school   170011   Bristol School District 90051001726 172511 Mt. View GOAL Program           2020   pk_12_total 0 * *   0 0     0   0   * *     0             *   * 0       0 0     0   0           0            
2777845 2777845 CT     school   170011   Bristol School District 90051001688 172611 Ivy Drive GOAL Program           2020   pk_12_total * * *   0 0     0   *   7 0     *             7   7         0 0     0       7 0             7   7
2777846 2777846 CT     school   170011   Bristol School District 90051001429 179011 Alternative Special Education Program (ASEP) Program           2020   pk_12_total 12 * *   0 0     0   0   18 6     *             24   24 12       0 0     0   0   18 6             24   24
2777847 2777847 CT     school   170011   Bristol School District   173711 Hubbell Autism Program Program           2020   pk_12_total * * *   0 *     0   0   * *     *             9   9         0       0   0                   9   9
2777848 2777848 CT     school   170011   Bristol School District 90051001711 173111 South Side GOAL Program           2020   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2777849 2777849 CT     school   170011   Bristol School District   173611 West bristol Extended Resource Program           2020   pk_12_total 0 0 *   0 0     0   0   * 0     0             *   * 0 0     0 0     0   0     0     0            
2777851 2777851 CT     school   170011   Bristol School District 90051001748 171011 Chippens Hill Middle School Functional Program Program           2020   pk_12_total * * 6   0 0     0   0   * *     *             11   11     6   0 0     0   0                   11   11
2777852 2777852 CT     school   170011   Bristol School District   171611 Chippens Hill Middle School Medically Fragile Program           2020   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2777853 2777853 CT     school   170011   Bristol School District   170811 Chippens Hilll Middle School Extended Resource Program           2020   pk_12_total * 0 8   0 *     0   0   7 7     *             14   14   0 8   0       0   0   7 7             14   14
2777854 2777854 CT     school   170011   Bristol School District 90051001753 173411 Chms Goal Program           2020   pk_12_total * 0 *   0 0     0   0   * *     *             9   9   0     0 0     0   0                   9   9
2777855 2777855 CT     school   170011   Bristol School District 90051001661 170911 Greene-Hills GOAL Program           2020   pk_12_total * * *   0 0     0   *   * *     *             6   6         0 0     0                       6   6
2777856 2777856 CT     school   170011   Bristol School District 90051001651 172711 Northeast MS/Extended Resource Program           2020   pk_12_total * 0 *   0 0     0   0   * *     *             6   6   0     0 0     0   0                   6   6
2777857 2777857 CT     school   170011   Bristol School District 90051001796 172811 Northeast MS/GOAL Program           2020   pk_12_total * * 0   0 0     0   0   * *     0             *   *     0   0 0     0   0           0            
2777861 2777861 CT     school   170011   Bristol School District 90051001746 173311 Bristol Preparatory Academy Program           2020   pk_12_total 26 * 11   0 0     0   *   32 8     0             0   40 26   11   0 0     0       32 8     0       0   40
2777862 2777862 CT     school   170011   Bristol School District   170211 ACCESS Program           2020   pk_12_total * * *   0 0     0   *   * *     0             10   10         0 0     0               0       10   10
2777863 2777863 CT     school   170011   Bristol School District 90051001515 179211 Community/Vocational Program Program           2020   pk_12_total 17 * *   0 0     0   *   13 11     *             24   24 17       0 0     0       13 11             24   24
2777876 2777876 CT     school   230011   Canton School District 90069001695 230411 Canton Academy Program           2020   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2777885 2777885 CT     school   2410014   Capitol Region Education Council   2411414 River Street School Early Learning Center Program           2020   pk_12_total * * *   0 0     0   0   * *     0             0   9         0 0     0   0           0       0   9
2777886 2777886 CT     school   2410014   Capitol Region Education Council 90070001492 2419114 Soundbridge Program           2020   pk_12_total 24 0 6   0 *     *   0   21 12     0             8   33 24 0 6   0           0   21 12     0       8   33
2777888 2777888 CT     school   2410014   Capitol Region Education Council 90070001154 2419014 John J. Allison Polaris Center Program           2020   pk_12_total * * 34   0 0     0   0   37 18     6             *   55     34   0 0     0   0   37 18     6           55
2777889 2777889 CT     school   2410014   Capitol Region Education Council 90070001495 2419314 River Street School Program           2020   pk_12_total 57 28 24   0 *     0   *   96 20     0             116   116 57 28 24   0       0       96 20     0       116   116
2777890 2777890 CT     school   2410014   Capitol Region Education Council 90070001510 2419514 River Street School Birken Campus Program           2020   pk_12_total 25 9 10   0 *     0   *   40 9     *             49   49 25 9 10   0       0       40 9             49   49
2777896 2777896 CT     school   2410014   Capitol Region Education Council 90070001489 2419214 Farmington Valley Regional Diagnostic Center Program           2020   pk_12_total 8 * 0   0 0     0   *   * *     0             *   11 8   0   0 0     0               0           11
2777897 2777897 CT     school   2410014   Capitol Region Education Council   2411914 CREC Impact Academy Program           2020   pk_12_total * 14 21   0 0     0   *   29 9     *             *   38   14 21   0 0     0       29 9                 38
2777900 2777900 CT     school   2410014   Capitol Region Education Council   2419414 IPM @ Plainville High School             2020   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2777901 2777901 CT     school   2410014   Capitol Region Education Council 90070001802 2419714 Strive (Southern Transition Real-World and Independent Vocational Education Program Program           2020   pk_12_total * 0 0   0 *     0   0   * *     0             13   13   0 0   0       0   0           0       13   13
2777906 2777906 CT     school   250011   Cheshire School District   250711 Highland School Autism Program Program           2020   pk_12_total 12 * *   0 *     0   0   * *     0             17   17 12       0       0   0           0       17   17
2777908 2777908 CT     school   250011   Cheshire School District   251111 Doolittle Bridges Program Program           2020   pk_12_total * * *   0 0     0   0   * 0     0             *   *         0 0     0   0     0     0            
2777912 2777912 CT     school   250011   Cheshire School District 90075001682 250911 Humiston Alternative School Program           2020   pk_12_total 27 * *   0 0     0   0   15 15     0             *   30 27       0 0     0   0   15 15     0           30
2777913 2777913 CT     school   250011   Cheshire School District 90075001766 250311 Cheshire Quinnipiac University Transition Collaborative Program           2020   pk_12_total * 0 0   0 *     0   0   * *     0             6   6   0 0   0       0   0           0       6   6
2777914 2777914 CT     school   250011   Cheshire School District   251011 QU College Life Program           2020   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2777922 2777922 CT     school   280011   Colchester School District   280511 Bacon Academy Alternative Education Program           2020   pk_12_total 9 0 0   0 0     0   0   6 *     0             *   9 9 0 0   0 0     0   0   6       0           9
2777923 2777923 CT     school   280011   Colchester School District   280711 Community Transition Academy of Colchester Program           2020   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2777925 2777925 CT     school   2430014   Cooperative Educational Services 90091001561 2439114 Preschool-Primary Learning Center (PLC) Program           2020   pk_12_total 16 12 16   0 *     *   *   42 9     0             51   51 16 12 16   0               42 9     0       51   51
2777926 2777926 CT     school   2430014   Cooperative Educational Services 90091001520 2438014 School Readiness Program           2020   pk_12_total * 31 53   0 0     0   *   40 47     0             *   87   31 53   0 0     0       40 47     0           87
2777928 2777928 CT     school   2430014   Cooperative Educational Services   2430314 Eastern Fairfield County Diagnostic Center Program           2020   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2777929 2777929 CT     school   2430014   Cooperative Educational Services 90091001573 2439414 Therapeutic Day Program Program           2020   pk_12_total 80 25 40   0 *     0   *   122 33     *             155   155 80 25 40   0       0       122 33             155   155
2777930 2777930 CT     school   2430014   Cooperative Educational Services 90091001554 2439214 Developmental Learning Center (DLC) Program           2020   pk_12_total 16 18 20   0 *     0   *   41 18     *             59   59 16 18 20   0       0       41 18             59   59
2777931 2777931 CT     school   2430014   Cooperative Educational Services 90091001555 2439314 RISE Transitional Program Program           2020   pk_12_total 8 0 *   0 0     0   *   * *     0             12   12 8 0     0 0     0               0       12   12
2777932 2777932 CT     school   2430014   Cooperative Educational Services   2430214 Transition Learning Center Program           2020   pk_12_total 18 * 7   0 *     0   *   27 6     *             33   33 18   7   0       0       27 6             33   33
2777933 2777933 CT     school   320011   Coventry School District   320311 Hale Early Education Center Program           2020   pk_12_total 83 0 6   0 *     0   *   38 58     0             20   96 83 0 6   0       0       38 58     0       20   96
2777937 2777937 CT     school   320011   Coventry School District 90096001787 320111 Coventry Academy Public Schools           2020   pk_12_total 14 0 *   0 0     0   *   12 7     0             8   19 14 0     0 0     0       12 7     0       8   19
2777960 2777960 CT     school   340011   Danbury School District 90102001129 346211 Alternative Center For Excellence Program           2020   pk_12_total 29 9 39   0 *     0   *   37 48     *             20   85 29 9 39   0       0       37 48             20   85
2777962 2777962 CT     school   340011   Danbury School District   340711 Western Connection Program           2020   pk_12_total * * 0   0 0     0   0   * *     0             11   11     0   0 0     0   0           0       11   11
2777974 2777974 CT     school   370011   Derby School District   370511 RAISE Academy Program           2020   pk_12_total 8 * *   0 0     0   *   * *     0             9   17 8       0 0     0               0       9   17
2777975 2777975 CT     school   370011   Derby School District   370211 Alternative Education Program Program           2020   pk_12_total 0 0 0   0 0     0   *   * 0     0             *   * 0 0 0   0 0     0         0     0            
2777988 2777988 CT     school   420011   East Hampton School District 90123001514 429011 The Learning Center at East Hampton Program           2020   pk_12_total 8 0 0   0 0     0   0   * *     0             *   8 8 0 0   0 0     0   0           0           8
2777989 2777989 CT     school   430011   East Hartford School District   430211 Early Childhood Learning Center at Hockanum School Program           2020   pk_12_total 42 95 162   0 15     *   *   176 145     0             86   321 42 95 162   0 15             176 145     0       86   321
2777998 2777998 CT     school   430011   East Hartford School District 90126000205 439011 Woodland School Program           2020   pk_12_total 27 67 98   * *     0   11   166 40     24             *   206 27 67 98           0   11   166 40     24           206
2778003 2778003 CT     school   430011   East Hartford School District 90126001377 436411 Synergy Alternative Program Program           2020   pk_12_total * 27 63   0 0     0   *   68 33     12             30   101   27 63   0 0     0       68 33     12       30   101
2778012 2778012 CT     school   450011   East Lyme School District 90132001450 458011 Integrated Preschool Program           2020   pk_12_total 47 * *   0 *     0   0   24 26     0             24   50 47       0       0   0   24 26     0       24   50
2778017 2778017 CT     school   450011   East Lyme School District 90132001760 450611 Coastal Connections Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             *   16   0     0 0     0   0           0           16
2778019 2778019 CT     school   450011   East Lyme School District 90132001730 450511 Abilities in Motion (AIM) Program Program           2020   pk_12_total * * 0   0 0     0   0   * *     *             10   10     0   0 0     0   0                   10   10
2778023 2778023 CT     school   470011   East Windsor School District   470411 East Windsor Transition Program Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             8   8   0     0 0     0   0           0       8   8
2778027 2778027 CT     school   2420014   EdAdvance 90351200575 2428014 EdAdvance Headstart Program           2020   pk_12_total 100 8 61   * 8     *   7   88 104     0             *   192 100 8 61     8         7   88 104     0           192
2778028 2778028 CT     school   2420014   EdAdvance 90351201476 2429014 The ACCESS School at The Danuta M. Thibodeau Education Center Program           2020   pk_12_total 14 * 7   * *     0   0   25 0     0             25   25 14   7           0   0   25 0     0       25   25
2778029 2778029 CT     school   2420014   EdAdvance   2420114 Steps Program           2020   pk_12_total 16 * 7   * 0     0   0   * *     *             29   29 16   7     0     0   0                   29   29
2778030 2778030 CT     school   2420014   EdAdvance   2420314 Steps-North Expelled Student Program           2020   pk_12_total 0 0 *   0 0     0   0   * 0     *             *   * 0 0     0 0     0   0     0                  
2778031 2778031 CT     school   2420014   EdAdvance   2420414 ACCESS-South Expelled Student Program           2020   pk_12_total * 0 0   0 0     0   0   * 0     0             0   *   0 0   0 0     0   0     0     0       0    
2778032 2778032 CT     school   2420014   EdAdvance   2420514 University Pathways Program Program           2020   pk_12_total 9 * *   0 0     0   0   9 6     0             15   15 9       0 0     0   0   9 6     0       15   15
2778038 2778038 CT     school   480011   Ellington School District   480511 The Ellington Public Schools Expulsion Program (TEPSEP) Program           2020   pk_12_total * 0 0   0 0     0   *   * 0     0             *   *   0 0   0 0     0         0     0            
2778039 2778039 CT     school   480011   Ellington School District   480411 Ellington Continuing Life Independence Post-Secondary Education (ECLIPSE) Program           2020   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2778041 2778041 CT     school   490011   Enfield School District 90147001915 492211 EPS Integrated Pre-Kindergarten Program           2020   pk_12_total 59 * 11   0 *     0   *   49 31     0             49   80 59   11   0       0       49 31     0       49   80
2778042 2778042 CT     school   490011   Enfield School District 90147001810 491011 EPS PK STEAM Academy Program           2020   pk_12_total 31 10 16   0 *     0   *   43 24     0             *   67 31 10 16   0       0       43 24     0           67
2778043 2778043 CT     school   490011   Enfield School District 90147000207 498011 Head Start Program Program           2020   pk_12_total 59 * 29   0 *     0   9   55 47     0             10   102 59   29   0       0   9   55 47     0       10   102
2778046 2778046 CT     school   490011   Enfield School District 90147001792 490311 Henry Barnard - Autism Spectrum Disorder (ASD) Program           2020   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2778047 2778047 CT     school   490011   Enfield School District 90147001743 490811 Henry Barnard - Primary Adaptive Learning (PAL) Program           2020   pk_12_total * * *   0 0     0   *   * *     0             *   *         0 0     0               0            
2778050 2778050 CT     school   490011   Enfield School District 90147001696 490611 Henry Barnard - Educational Counseling Program (ECP) Program           2020   pk_12_total * * *   0 0     0   *   * 0     0             *   *         0 0     0         0     0            

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);