Data source: Big Local News · About: Big Local

20,216 rows where state = "CT" and year = 2021 sorted by ell_int

View and edit SQL

grade

year

  • 2021 · 20,116
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
2757791 CT     school 901950 650011   Hartland School District 90195000386 650111 Hartland School Public Schools Regular School No Elementary PK 08 2021   pk_12_total 124 * *   0 0     0   11   82 63     *             32   145 124       0 0     0   11   82 63             32   145
2757792 CT     school 902010 670011   Hebron School District 90201000387 670211 Gilead Hill School Public Schools Regular School No Elementary PK 02 2021   pk_12_total 269 * 9   * *     0   *   151 142     *             33   293 269   9           0       151 142             33   293
2757793 CT     school 902010 670011   Hebron School District 90201000388 670111 Hebron Elementary School Public Schools Regular School No Elementary 03 06 2021   pk_12_total 309 * 21   0 6     0   *   174 169     *             42   343 309   21   0 6     0       174 169             42   343
2757794 CT     school 900207 2860013   Highville Charter School District 90020700907 2860113 Highville Charter School Public Charter Schools Regular School Yes Other PK 12 2021   pk_12_total 6 405 29   * 0     *   *   190 257     *             23   447 6 405 29     0             190 257             23   447
2757796 CT     school 900007 2610013   Jumoke Academy District 90000700747 2610113 Jumoke Academy Public Charter Schools Regular School Yes Other PK 12 2021   pk_12_total * 639 34   * *     0   6   * 358     *             51   686   639 34           0   6     358             51   686
2757797 CT     school 902040 680011   Kent School District 90204000389 680111 Kent Center School Public Schools Regular School No Elementary PK 08 2021   pk_12_total 169 * 18   0 *     0   10   114 93     *             23   207 169   18   0       0   10   114 93             23   207
2757807 CT     school   2450014   Learn 90345001680 2451114 Learn Intensive Program Program           2021   pk_12_total 18 6 8   0 *     0   *   30 8     *             38   38 18 6 8   0       0       30 8             38   38
2757808 CT     school   2450014   Learn   2451614 LEARN SAILS Program Program           2021   pk_12_total 11 * *   0 0     0   *   22 0     *             22   22 11       0 0     0       22 0             22   22
2757810 CT     school 903450 2450014   Learn 90345001606 2456114 Marine Science Magnet High School Regional Education Service Center Schools Regular School No High 09 12 2021   pk_12_total 197 * 37   * 10     0   17   136 135     *             25   271 197   37     10     0   17   136 135             25   271
2757815 CT     school 902130 710011   Lebanon School District 90213000028 715111 Lebanon Middle School Public Schools Regular School No Middle 05 08 2021   pk_12_total 257 9 14   7 *     *   *   158 137     *             42   295 257 9 14   7               158 137             42   295
2757818 CT     school 902160 720011   Ledyard School District 90216000397 720211 Gales Ferry School Public Schools Regular School No Elementary KG 02 2021   pk_12_total 173 6 20   * 15     *   8   125 103     *             29   228 173 6 20     15         8   125 103             29   228
2757822 CT     school   720011   Ledyard School District   720511 Ledyard Transition Academy Program           2021   pk_12_total 7 * 0   0 *     0   0   * *     *             11   11 7   0   0       0   0                   11   11
2757826 CT     school 902220 740011   Litchfield School District 90222001809 746011 Litchfield Middle School Public Schools Regular School No Middle 07 08 2021   pk_12_total 118 0 *   0 *     0   0   64 67     *             26   131 118 0     0       0   0   64 67             26   131
2757827 CT     school 902220 740011   Litchfield School District 90222000406 746111 Litchfield High School Public Schools Regular School No High 09 12 2021   pk_12_total 206 * 14   0 *     7   7   125 *     *             44   237 206   14   0       7   7   125               44   237
2757831 CT     school 902280 760011   Madison School District 90228001382 760611 Dr. Robert H. Brown Intermediate School Public Schools Regular School No Elementary 04 05 2021   pk_12_total 278 0 19   0 12     0   9   163 155     *             56   318 278 0 19   0 12     0   9   163 155             56   318
2757832 CT     school 902280 760011   Madison School District 90228001480 765211 Walter C. Polson Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 460 * 37   * 21     *   23   287 261     *             85   548 460   37     21         23   287 261             85   548
2757833 CT     school 902280 760011   Madison School District 90228000411 766111 Daniel Hand High School Public Schools Regular School No High 09 12 2021   pk_12_total 829 * 51   * 35     0   37   535 *     *             113   958 829   51     35     0   37   535               113   958
2757844 CT     school   770011   Manchester School District   771511 Manchester Middle Academy Program           2021   pk_12_total 14 * 19   0 0     0   *   29 14     *             27   43 14   19   0 0     0       29 14             27   43
2757849 CT     school   770011   Manchester School District 90231001717 770711 New Horizons Program           2021   pk_12_total * 11 10   0 0     0   *   24 7     *             14   31   11 10   0 0     0       24 7             14   31
2757850 CT     school   770011   Manchester School District 90231001599 779111 Manchester Transition Center Program           2021   pk_12_total * 9 *   0 0     0   0   15 7     *             22   22   9     0 0     0   0   15 7             22   22
2757855 CT     school 902370 790011   Marlborough School District 90237000437 790111 Elmer Thienes-Mary Hall Elementary School Public Schools Regular School No Elementary PK 06 2021   pk_12_total 388 * 28   * 7     0   12   228 213     *             53   441 388   28     7     0   12   228 213             53   441
2757866 CT     school   800011   Meriden School District   800611 STARS - ES Program           2021   pk_12_total 11 * 32   0 *     0   7   42 13     *             55   55 11   32   0       0   7   42 13             55   55
2757867 CT     school   800011   Meriden School District   800911 STEP - ES Program           2021   pk_12_total * 10 26   0 0     0   *   37 9     *             *   46   10 26   0 0     0       37 9                 46
2757869 CT     school   800011   Meriden School District   802311 SOAR - LMS             2021   pk_12_total * 0 *   0 0     0   0   * *     *             8   8   0     0 0     0   0                   8   8
2757870 CT     school   800011   Meriden School District   802411 SOAR - WMS Program           2021   pk_12_total * * 9   0 0     0   0   * *     *             16   16     9   0 0     0   0                   16   16
2757871 CT     school   800011   Meriden School District   801511 STARS-MS Program           2021   pk_12_total * * 8   0 0     0   0   * *     *             17   17     8   0 0     0   0                   17   17
2757872 CT     school   800011   Meriden School District   801211 STEPS - MS Program           2021   pk_12_total 8 * 16   0 0     0   *   * *     *             28   28 8   16   0 0     0                       28   28
2757880 CT     school   800011   Meriden School District   801611 TSC - MHS Program           2021   pk_12_total * * 8   0 0     0   *   * *     *             16   16     8   0 0     0                       16   16
2757881 CT     school   800011   Meriden School District   801711 TSC - PHS Program           2021   pk_12_total * * 10   0 0     0   0   * *     *             17   17     10   0 0     0   0                   17   17
2757882 CT     school   800011   Meriden School District   802511 SOAR - PHS Program           2021   pk_12_total * 0 *   0 0     0   0   * *     *             7   7   0     0 0     0   0                   7   7
2757883 CT     school   800011   Meriden School District   801811 STARS - HS Program           2021   pk_12_total * 0 *   0 *     0   0   10 0     *             10   10   0     0       0   0   10 0             10   10
2757884 CT     school   800011   Meriden School District 90240001800 800211 Community Classroom Collaborative Program           2021   pk_12_total * 0 6   0 *     0   *   * *     *             13   13   0 6   0       0                       13   13
2757885 CT     school   800011   Meriden School District   802111 Community Collaborative Classroom - ACADEMY Program           2021   pk_12_total * * *   0 0     0   0   * *     *             11   11         0 0     0   0                   11   11
2757892 CT     school 902490 830011   Middletown School District 90249000460 831211 Moody School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 105 33 21   0 *     *   34   110 100     *             24   210 105 33 21   0           34   110 100             24   210
2757894 CT     school 902490 830011   Middletown School District 90249000464 831411 Wesley School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 115 42 25   0 6     0   25   115 98     *             35   213 115 42 25   0 6     0   25   115 98             35   213
2757896 CT     school   830011   Middletown School District 90249001652 830711 ICM - Moody 3-5 Program           2021   pk_12_total * * *   0 *     0   *   * *     *             7   7         0       0                       7   7
2757906 CT     school   830011   Middletown School District 90249001598 839111 Middletown Transition Center Program           2021   pk_12_total 13 * *   * *     0   *   11 12     *             23   23 13               0       11 12             23   23
2757908 CT     school 902520 840011   Milford School District 90252000476 841611 Live Oaks School Public Schools Regular School No Elementary PK 05 2021   pk_12_total 188 * 29   * 28     0   20   156 123     *             57   279 188   29     28     0   20   156 123             57   279
2757910 CT     school 902520 840011   Milford School District 90252000481 841811 Orchard Hills School Public Schools Regular School No Elementary PK 05 2021   pk_12_total 246 * 40   0 *     0   21   165 154     *             53   319 246   40   0       0   21   165 154             53   319
2757912 CT     school 902520 840011   Milford School District 90252000467 840111 Calf Pen Meadow School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 195 8 36   0 6     0   13   135 123     *             35   258 195 8 36   0 6     0   13   135 123             35   258
2757919 CT     school 902520 840011   Milford School District 90252000473 846311 Joseph A. Foran High School Public Schools Regular School No High 09 12 2021   pk_12_total 633 47 84   * 56     0   *   402 426     *             120   828 633 47 84     56     0       402 426             120   828
2757920 CT     school   840011   Milford School District 90252001679 840311 The Academy Program           2021   pk_12_total 23 * 8   0 *     0   *   21 14     *             14   35 23   8   0       0       21 14             14   35
2757923 CT     school 902550 850011   Monroe School District 90255000490 850111 Monroe Elementary School Public Schools Regular School No Elementary PK 05 2021   pk_12_total 263 * 48   0 7     *   11   181 156     *             57   337 263   48   0 7         11   181 156             57   337
2757932 CT     school 902580 860011   Montville School District 90258000496 860511 Oakdale School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 214 * 33   0 *     0   28   160 124     *             44   284 214   33   0       0   28   160 124             44   284
2757936 CT     school   860011   Montville School District   860611 Montville Transition and Vocational Training Academy Program           2021   pk_12_total 7 * *   * *     0   0   * *     *             11   11 7               0   0                   11   11
2757938 CT     school   880011   Naugatuck School District 90264001384 888111 Head Start Program           2021   pk_12_total 49 22 29   0 *     0   *   54 57     *             17   111 49 22 29   0       0       54 57             17   111
2757948 CT     school   880011   Naugatuck School District   880911 Genesis Academy Program           2021   pk_12_total * * 6   0 *     0   *   * *     *             0   15     6   0       0                       0   15
2757957 CT     school   890011   New Britain School District   890211 Chamberlain Bridges Program           2021   pk_12_total * * 17   0 0     0   *   * *     *             22   22     17   0 0     0                       22   22
2757960 CT     school   890011   New Britain School District   892011 Lincoln KEY Elementary Program           2021   pk_12_total * * 12   0 0     0   *   * *     *             17   17     12   0 0     0                       17   17
2757964 CT     school   890011   New Britain School District   892111 Smith KEY Elementary Program           2021   pk_12_total 0 * *   0 0     0   0   * *     *             10   10 0       0 0     0   0                   10   10
2757965 CT     school   890011   New Britain School District   891911 Smith Pathways Program           2021   pk_12_total * * 15   0 0     0   *   12 7     *             19   19     15   0 0     0       12 7             19   19
2757967 CT     school   890011   New Britain School District 90267001566 899011 New Britain Transition Center Program           2021   pk_12_total 9 6 27   0 0     0   0   27 15     *             42   42 9 6 27   0 0     0   0   27 15             42   42
2757968 CT     school   890011   New Britain School District   890411 Holmes Bridges Program           2021   pk_12_total * * 11   0 0     0   *   * *     *             17   17     11   0 0     0                       17   17
2757969 CT     school   890011   New Britain School District   891011 Lincoln SCS Program           2021   pk_12_total 0 * *   0 0     0   0   * *     *             *   14 0       0 0     0   0                       14
2757978 CT     school 902700 900011   New Canaan School District 90270000534 900311 West School Public Schools Regular School No Elementary PK 04 2021   pk_12_total 389 * *   0 30     0   21   239 224     *             63   463 389       0 30     0   21   239 224             63   463
2757979 CT     school 902700 900011   New Canaan School District 90270000530 900411 East School Public Schools Regular School No Elementary KG 04 2021   pk_12_total 423 16 32   0 33     0   45   260 289     *             45   549 423 16 32   0 33     0   45   260 289             45   549
2757982 CT     school 902700 900011   New Canaan School District 90270000531 906111 New Canaan High School Public Schools Regular School No High 09 12 2021   pk_12_total 1139 * 69   * 81     0   34   689 655     *             183   1344 1139   69     81     0   34   689 655             183   1344
2757987 CT     school 902730 910011   New Fairfield School District 90273000537 916111 New Fairfield High School Public Schools Regular School No High 09 12 2021   pk_12_total 558 13 98   * *     0   17   348 350     *             102   698 558 13 98           0   17   348 350             102   698
2757990 CT     school 902760 920011   New Hartford School District 90276000539 920111 Bakerville Consolidated School Public Schools Regular School No Elementary KG 02 2021   pk_12_total 93 0 *   0 0     0   *   50 47     *             9   97 93 0     0 0     0       50 47             9   97
2757991 CT     school 902760 920011   New Hartford School District 90276000538 920311 Ann Antolini School Public Schools Regular School No Elementary 03 06 2021   pk_12_total 227 0 10   0 *     0   *   118 128     *             36   246 227 0 10   0       0       118 128             36   246
2758020 CT     school   930011   New Haven School District   937611 Barack H. Obama Self Contained Autism Program           2021   pk_12_total * 13 *   0 0     0   0   * *     *             *   28   13     0 0     0   0                       28
2758024 CT     school   930011   New Haven School District   937411 Celentano Self Contained ID Program           2021   pk_12_total * 14 8   0 0     0   *   19 8     *             27   27   14 8   0 0     0       19 8             27   27
2758026 CT     school   930011   New Haven School District   937511 East Rock Self Contained MD Program           2021   pk_12_total * 15 22   0 *     0   0   23 18     *             41   41   15 22   0       0   0   23 18             41   41
2758027 CT     school   930011   New Haven School District   938711 Fair Haven Self Contained ID Program           2021   pk_12_total * 6 *   0 0     0   *   * *     *             13   13   6     0 0     0                       13   13
2758028 CT     school   930011   New Haven School District   937711 Nathan Hale Self Contained ID Program           2021   pk_12_total * * 10   0 0     0   0   11 10     *             21   21     10   0 0     0   0   11 10             21   21
2758031 CT     school   930011   New Haven School District   938411 West Rock Self Contained Autism Program           2021   pk_12_total * 10 *   0 0     0   0   * *     *             13   13   10     0 0     0   0                   13   13
2758034 CT     school   930011   New Haven School District   937811 Clinton Self Contained ID Program           2021   pk_12_total * 0 *   0 0     0   0   6 8     *             14   14   0     0 0     0   0   6 8             14   14
2758039 CT     school   930011   New Haven School District   930110 Gateway to College Program Program           2021   pk_12_total * 26 13   0 *     0   *   23 19     *             6   42   26 13   0       0       23 19             6   42
2758043 CT     school   930011   New Haven School District   930210 James Hillhouse Self Contained MD Program           2021   pk_12_total 0 * *   0 0     0   0   * *     *             6   6 0       0 0     0   0                   6   6
2758049 CT     school   930011   New Haven School District   938511 Wilbur Cross Self Contained MD Program           2021   pk_12_total * * 9   0 0     0   0   * *     *             16   16     9   0 0     0   0                   16   16
2758074 CT     school 902910 970011   Newtown School District 90291000613 970111 Hawley Elementary School Public Schools Regular School No Elementary KG 04 2021   pk_12_total 239 * 27   0 6     0   *   137 142     *             35   279 239   27   0 6     0       137 142             35   279
2758075 CT     school 902910 970011   Newtown School District 90291001121 970411 Head O'Meadow Elementary School Public Schools Regular School No Elementary KG 04 2021   pk_12_total 241 * 33   0 *     *   *   150 137     *             26   287 241   33   0               150 137             26   287
2758076 CT     school 902910 970011   Newtown School District 90291000614 970311 Middle Gate Elementary School Public Schools Regular School No Elementary KG 04 2021   pk_12_total 302 * 55   * 6     0   *   195 176     *             47   371 302   55     6     0       195 176             47   371
2758077 CT     school   970011   Newtown School District   970811 Program for Adaptive Learning Program           2021   pk_12_total * 0 *   0 0     0   0   * *     *             6   6   0     0 0     0   0                   6   6
2758078 CT     school 902910 970011   Newtown School District 90291000617 970211 Sandy Hook Elementary School Public Schools Regular School No Elementary KG 04 2021   pk_12_total 299 * 39   0 9     *   *   163 193     *             56   356 299   39   0 9             163 193             56   356
2758079 CT     school 902910 970011   Newtown School District 90291001487 970511 Reed Intermediate School Public Schools Regular School No Middle 05 06 2021   pk_12_total 484 * 50   * 16     0   19   308 274     *             87   582 484   50     16     0   19   308 274             87   582
2758081 CT     school 902910 970011   Newtown School District 90291000616 975111 Newtown Middle School Public Schools Regular School No Middle 07 08 2021   pk_12_total 526 * 54   0 19     *   14   * 322     *             85   623 526   54   0 19         14     322             85   623
2758082 CT     school 902910 970011   Newtown School District 90291000615 976111 Newtown High School Public Schools Regular School No High 09 12 2021   pk_12_total 1230 23 110   0 54     0   24   * 720     *             168   1441 1230 23 110   0 54     0   24     720             168   1441
2758084 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2021   pk_12_total 68 0 *   0 0     0   *   42 38     *             18   80 68 0     0 0     0       42 38             18   80
2758087 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2021   pk_12_total 336 * 38   * 7     0   9   228 170     *             59   398 336   38     7     0   9   228 170             59   398
2758088 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2021   pk_12_total 424 14 38   0 9     0   7   232 260     *             79   492 424 14 38   0 9     0   7   232 260             79   492
2758118 CT     school 903090 1030011   Norwalk School District 90309001917 1030511 Center for Global Studies Public Schools Regular School No High 09 12 2021   pk_12_total 114 38 89   0 27     0   8   89 187     *             14   276 114 38 89   0 27     0   8   89 187             14   276
2758122 CT     school   1030011   Norwalk School District   1031111 Norwalk 18-21 Next Steps (NNS) Program           2021   pk_12_total 9 11 *   0 *     0   0   15 12     *             27   27 9 11     0       0   0   15 12             27   27
2758123 CT     school   1030011   Norwalk School District   1030611 Norwalk 18-21 Project SEARCH Program           2021   pk_12_total 6 * *   0 0     0   0   * *     *             12   12 6       0 0     0   0                   12   12
2758130 CT     school   1040011   Norwich School District   1040411 Strive Autism Program @ Huntington Program           2021   pk_12_total * * 6   0 0     0   0   * *     *             12   12     6   0 0     0   0                   12   12
2758131 CT     school   1040011   Norwich School District   1041211 Strive Program @ Stanton Program           2021   pk_12_total * * *   0 0     0   *   * *     *             7   7         0 0     0                       7   7
2758135 CT     school   1040011   Norwich School District   1040511 Special Needs Program @ Mahan Program           2021   pk_12_total * 0 *   0 *     0   0   * *     *             7   7   0     0       0   0                   7   7
2758137 CT     school   1040011   Norwich School District   1041111 Strive Program @ Kelly Program           2021   pk_12_total * 0 *   0 0     0   0   * *     *             9   9   0     0 0     0   0                   9   9
2758155 CT     school 903270 1090011   Plainfield School District 90327000692 1090111 Moosup Elementary School Public Schools Regular School No Elementary KG 03 2021   pk_12_total 256 8 22   * *     *   9   143 157     *             42   300 256 8 22               9   143 157             42   300
2758159 CT     school 903270 1090011   Plainfield School District 90327000695 1096111 Plainfield High School Public Schools Regular School No High 09 12 2021   pk_12_total 488 25 27   * *     *   *   265 288     *             102   553 488 25 27                   265 288             102   553
2758168 CT     school 903330 1110011   Plymouth School District 90333000705 1115111 Eli Terry Jr. Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 259 * 42   * *     0   10   160 154     *             61   314 259   42           0   10   160 154             61   314
2758173 CT     school 903390 1130011   Portland School District 90339001393 1130511 Brownstone Intermediate School Public Schools Regular School No Middle 05 06 2021   pk_12_total 146 * 30   0 *     0   9   104 *     *             38   196 146   30   0       0   9   104               38   196
2758174 CT     school 903390 1130011   Portland School District 90339000713 1135111 Portland Middle School Public Schools Regular School No Middle 07 08 2021   pk_12_total 160 * 31   0 *     0   13   108 106     *             29   214 160   31   0       0   13   108 106             29   214
2758175 CT     school 903390 1130011   Portland School District 90339000712 1136111 Portland High School Public Schools Regular School No High 09 12 2021   pk_12_total 280 * 37   0 *     0   16   172 176     *             40   348 280   37   0       0   16   172 176             40   348
2758176 CT     school 903420 1140011   Preston School District 90342001466 1140411 Preston Veterans' Memorial School Public Schools Regular School No Elementary PK 05 2021   pk_12_total 219 * 21   0 7     *   9   136 126     *             38   262 219   21   0 7         9   136 126             38   262
2758177 CT     school 903420 1140011   Preston School District 90342000717 1145111 Preston Plains School Public Schools Regular School No Middle 06 08 2021   pk_12_total 115 * 7   0 *     *   8   69 69     *             25   138 115   7   0           8   69 69             25   138
2758185 CT     school 903515 2060012   Regional School District 06 90351500724 2060212 James Morris School Regional Schools Regular School No Elementary PK 06 2021   pk_12_total 116 * 9   0 0     0   *   65 64     *             26   129 116   9   0 0     0       65 64             26   129
2758187 CT     school 903515 2060012   Regional School District 06 90351500725 2066112 Wamogo Regional High School Regional Schools Regular School No High 07 12 2021   pk_12_total 432 8 28   * *     *   9   * 267     *             87   484 432 8 28               9     267             87   484
2758189 CT     school 903520 2100012   Regional School District 10 90352000728 2100312 Harwinton Consolidated School Regional Schools Regular School No Elementary PK 04 2021   pk_12_total 286 * *   0 0     0   54   180 177     *             49   357 286       0 0     0   54   180 177             49   357
2758192 CT     school 903520 2100012   Regional School District 10 90352000730 2106112 Lewis S. Mills High School Regional Schools Regular School No High 09 12 2021   pk_12_total 524 * 34   0 *     0   133   368 335     *             69   703 524   34   0       0   133   368 335             69   703

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