Data source: Big Local News · About: Big Local

20,216 rows where state = "CT" and year = 2021 sorted by black_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
2757670 CT     school 901710 570011   Greenwich School District 90171000303 570611 New Lebanon School Public Schools Regular School No Elementary PK 05 2021   pk_12_total 70 * 180   * 15     0   12   155 135     32             59   290 70   180     15     0   12   155 135     32       59   290
2757671 CT     school 901710 570011   Greenwich School District 90171000304 570711 North Mianus School Public Schools Regular School No Elementary PK 05 2021   pk_12_total 319 * 66   * 75     *   25   260 229     25             44   489 319   66     75         25   260 229     25       44   489
2757672 CT     school 901710 570011   Greenwich School District 90171000305 570811 North Street School Public Schools Regular School No Elementary PK 05 2021   pk_12_total 289 * 32   * 24     0   21   186 186     *             43   372 289   32     24     0   21   186 186             43   372
2757675 CT     school 901710 570011   Greenwich School District 90171000299 570411 Glenville School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 272 * 60   0 *     0   33   215 183     13             37   398 272   60   0       0   33   215 183     13       37   398
2757677 CT     school 901710 570011   Greenwich School District 90171000308 571011 Riverside School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 326 * 69   0 30     0   *   239 206     12             27   445 326   69   0 30     0       239 206     12       27   445
2757678 CT     school 901710 570011   Greenwich School District 90171000295 575111 Central Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 377 * 116   0 *     0   48   304 273     13             69   577 377   116   0       0   48   304 273     13       69   577
2757679 CT     school 901710 570011   Greenwich School District 90171000298 575211 Eastern Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 555 * 114   * 102     0   53   453 384     11             97   837 555   114     102     0   53   453 384     11       97   837
2757680 CT     school 901710 570011   Greenwich School District 90171000309 575311 Western Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 284 * 244   * 47     0   26   333 295     21             95   628 284   244     47     0   26   333 295     21       95   628
2757682 CT     school   570011   Greenwich School District   571511 Windrose Program           2021   pk_12_total 9 * 10   0 0     0   *   * 14     *             10   23 9   10   0 0     0         14             10   23
2757683 CT     school   570011   Greenwich School District 90171001664 571211 Community Connections Program           2021   pk_12_total 16 * *   0 *     0   0   * *     *             21   21 16       0       0   0                   21   21
2757695 CT     school   590011   Groton School District   590611 Apex Academy Program           2021   pk_12_total * * *   0 0     0   0   * *     0             *   *         0 0     0   0           0            
2757696 CT     school   590011   Groton School District   590211 New Beginnings Alternative Program Program           2021   pk_12_total * * 8   * 0     0   *   13 9     *             22   22     8     0     0       13 9             22   22
2757698 CT     school   590011   Groton School District   591011 Transition Academy Program           2021   pk_12_total 7 * *   0 0     0   *   * *     *             12   12 7       0 0     0                       12   12
2757699 CT     school 901800 600011   Guilford School District 90180000333 600211 Guilford Lakes School Public Schools Regular School No Elementary PK 04 2021   pk_12_total 226 * 27   0 *     0   19   157 135     8             39   292 226   27   0       0   19   157 135     8       39   292
2757700 CT     school 901800 600011   Guilford School District 90180000329 600611 A. W. Cox School Public Schools Regular School No Elementary KG 04 2021   pk_12_total 187 * 20   0 21     0   *   121 120     15             22   241 187   20   0 21     0       121 120     15       22   241
2757701 CT     school 901800 600011   Guilford School District 90180000330 600411 Calvin Leete School Public Schools Regular School No Elementary KG 04 2021   pk_12_total 192 * 15   0 *     0   14   117 113     14             21   230 192   15   0       0   14   117 113     14       21   230
2757703 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2021   pk_12_total 385 * 30   0 21     *   26   244 224     10             66   468 385   30   0 21         26   244 224     10       66   468
2757705 CT     school 901800 600011   Guilford School District 90180000332 606111 Guilford High School Public Schools Regular School No High 09 12 2021   pk_12_total 903 * 93   0 53     *   37   569 *     *             118   1104 903   93   0 53         37   569               118   1104
2757713 CT     school   620011   Hamden School District   621911 Intensive Support Classroom Program           2021   pk_12_total 6 * *   0 0     0   0   * *     0             13   13 6       0 0     0   0           0       13   13
2757721 CT     school   620011   Hamden School District   621511 Dunbar Hill IIC Program           2021   pk_12_total * * *   0 0     0   0   * 0     0             *   *         0 0     0   0     0     0            
2757722 CT     school   620011   Hamden School District   621311 Church Street IIC Program           2021   pk_12_total 0 * *   0 0     0   0   * *     *             6   6 0       0 0     0   0                   6   6
2757745 CT     school   640011   Hartford School District   640510 Pre-K Integrated - Naylor School Program           2021   pk_12_total * * 14   0 *     0   0   * *     0             18   18     14   0       0   0           0       18   18
2757748 CT     school   640011   Hartford School District   641510 Pre-K Integrated - Sanchez School Program           2021   pk_12_total 0 * *   0 0     0   0   * *     0             10   10 0       0 0     0   0           0       10   10
2757749 CT     school   640011   Hartford School District   640610 Pre-K Integrated - West Middle School Program           2021   pk_12_total * * *   0 0     0   0   6 6     0             *   12         0 0     0   0   6 6     0           12
2757756 CT     school   640011   Hartford School District   648711 iGOAL 1 - Parkville School Program           2021   pk_12_total * * 18   0 0     0   *   16 7     *             *   23     18   0 0     0       16 7                 23
2757757 CT     school   640011   Hartford School District 90192001764 648511 iGOAL 2 - Moylan School Program           2021   pk_12_total 0 * 7   0 0     0   *   * *     0             14   14 0   7   0 0     0               0       14   14
2757762 CT     school   640011   Hartford School District   644711 iGOAL 1 - Burns School Program           2021   pk_12_total * * 23   0 *     0   0   * *     12             29   29     23   0       0   0           12       29   29
2757763 CT     school   640011   Hartford School District 90192001732 645711 iGOAL 1 - M.D. Fox School Program           2021   pk_12_total 0 * *   0 0     0   0   * *     *             13   13 0       0 0     0   0                   13   13
2757766 CT     school   640011   Hartford School District   649511 iGOAL 1 - Breakthrough Magnet School, North Program           2021   pk_12_total 0 * *   0 0     0   0   * *     *             13   13 0       0 0     0   0                   13   13
2757769 CT     school   640011   Hartford School District   640210 iGOAL 2 - Kennelly School Program           2021   pk_12_total 0 * *   0 0     0   0   * *     *             9   9 0       0 0     0   0                   9   9
2757776 CT     school   640011   Hartford School District   641310 RISE - M.L. King Middle School Program           2021   pk_12_total 0 * *   0 0     0   0   * *     *             8   8 0       0 0     0   0                   8   8
2757779 CT     school   640011   Hartford School District   640910 New Visions Program           2021   pk_12_total * * 24   0 0     0   0   18 16     *             15   34     24   0 0     0   0   18 16             15   34
2757784 CT     school   640011   Hartford School District 90192001770 648311 RISE - Bulkeley High School Program           2021   pk_12_total * * 9   0 0     0   0   * *     *             12   12     9   0 0     0   0                   12   12
2757785 CT     school   640011   Hartford School District 90192001677 648211 RISE - Hartford Public High School Program           2021   pk_12_total * * 17   0 0     0   0   15 10     7             25   25     17   0 0     0   0   15 10     7       25   25
2757788 CT     school   640011   Hartford School District   641410 iGOAL - Weaver High School Program           2021   pk_12_total 0 * *   0 0     0   0   12 6     *             18   18 0       0 0     0   0   12 6             18   18
2757789 CT     school   640011   Hartford School District 90192001660 644911 iGOAL 1 - HPHS Program           2021   pk_12_total * * 21   0 0     0   0   23 7     12             30   30     21   0 0     0   0   23 7     12       30   30
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
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
2757798 CT     school   690011   Killingly School District 90207000083 698011 Goodyear Early Childhood Center Program           2021   pk_12_total 52 * 8   0 *     0   *   37 31     0             28   68 52   8   0       0       37 31     0       28   68
2757799 CT     school 902070 690011   Killingly School District 90207000391 690111 Killingly Central School Public Schools Regular School No Elementary PK 01 2021   pk_12_total 268 * 40   * 8     0   30   197 152     16             60   349 268   40     8     0   30   197 152     16       60   349
2757803 CT     school   2450014   Learn   2451514 LEARN Integrated Program at TFS Program           2021   pk_12_total 0 * *   0 0     0   0   * 0     0             *   * 0       0 0     0   0     0     0            
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
2757811 CT     school   2450014   Learn 90345001795 2450614 Learn High School Program           2021   pk_12_total * * *   0 *     0   0   * *     0             *   *         0       0   0           0            
2757812 CT     school 903450 2450014   Learn 90345001617 2456214 Three Rivers Middle College Magnet School Regional Education Service Center Schools Regular School No High 11 12 2021   pk_12_total 41 * 18   * *     0   *   16 51     0             *   67 41   18           0       16 51     0           67
2757814 CT     school 902130 710011   Lebanon School District 90213000395 710111 Lebanon Elementary School Public Schools Regular School No Elementary PK 04 2021   pk_12_total 286 * 30   * *     *   7   189 146     6             61   335 286   30               7   189 146     6       61   335
2757816 CT     school 902130 710011   Lebanon School District 90213000396 716211 Lyman Memorial High School Public Schools Regular School No High 09 12 2021   pk_12_total 272 * 20   0 7     *   *   146 158     0             51   304 272   20   0 7             146 158     0       51   304
2757819 CT     school 902160 720011   Ledyard School District 90216000399 720311 Juliet W. Long School Public Schools Regular School No Elementary 03 05 2021   pk_12_total 185 * 35   0 12     *   13   116 137     10             47   253 185   35   0 12         13   116 137     10       47   253
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
2757823 CT     school 902190 730011   Lisbon School District 90219000403 730111 Lisbon Central School Public Schools Regular School No Elementary PK 08 2021   pk_12_total 332 * 54   * *     *   27   206 221     12             66   427 332   54               27   206 221     12       66   427
2757824 CT     school 902220 740011   Litchfield School District 90222000405 740211 Center School Public Schools Regular School No Elementary PK 03 2021   pk_12_total 231 * 14   0 *     0   *   123 131     0             31   254 231   14   0       0       123 131     0       31   254
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
2757829 CT     school 902280 760011   Madison School District 90228000410 760111 J. Milton Jeffrey Elementary School Public Schools Regular School No Elementary KG 03 2021   pk_12_total 278 * 18   0 11     *   13   177 *     9             41   324 278   18   0 11         13   177       9       41   324
2757830 CT     school 902280 760011   Madison School District 90228000413 760311 Kathleen H. Ryerson Elementary School Public Schools Regular School No Elementary KG 03 2021   pk_12_total 239 * 17   0 10     0   *   148 129     14             37   277 239   17   0 10     0       148 129     14       37   277
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
2757846 CT     school   770011   Manchester School District 90231000427 779011 Manchester Regional Academy Program           2021   pk_12_total 20 * 23   0 0     0   *   49 14     0             53   63 20   23   0 0     0       49 14     0       53   63
2757851 CT     school 902340 780011   Mansfield School District 90234000432 780411 Annie E. Vinton School Public Schools Regular School No Elementary PK 04 2021   pk_12_total 117 * 38   * 24     0   8   93 103     11             32   196 117   38     24     0   8   93 103     11       32   196
2757852 CT     school 902340 780011   Mansfield School District 90234000434 780211 Dorothy C. Goodwin School Public Schools Regular School No Elementary PK 04 2021   pk_12_total 103 * 17   0 33     0   *   97 71     12             18   168 103   17   0 33     0       97 71     12       18   168
2757853 CT     school 902340 780011   Mansfield School District 90234000435 780511 Southeast Elementary School Public Schools Regular School No Elementary PK 04 2021   pk_12_total 108 * 27   0 11     0   *   75 77     8             20   152 108   27   0 11     0       75 77     8       20   152
2757854 CT     school 902340 780011   Mansfield School District 90234000433 785111 Mansfield Middle School Public Schools Regular School No Middle 05 08 2021   pk_12_total 342 * 76   * 62     0   24   242 279     15             69   521 342   76     62     0   24   242 279     15       69   521
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
2757865 CT     school   800011   Meriden School District   802211 SOAR- ES Program           2021   pk_12_total * * 8   0 0     0   0   6 6     0             12   12     8   0 0     0   0   6 6     0       12   12
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
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
2757874 CT     school   800011   Meriden School District   801311 Venture Academy Program           2021   pk_12_total 9 * 43   0 0     0   *   43 16     11             59   59 9   43   0 0     0       43 16     11       59   59
2757877 CT     school   800011   Meriden School District   801411 Success Academy Program           2021   pk_12_total * * 19   0 0     0   0   9 15     7             *   24     19   0 0     0   0   9 15     7           24
2757878 CT     school   800011   Meriden School District   802011 TLC - MHS Program           2021   pk_12_total 7 * 24   0 *     0   *   25 14     12             39   39 7   24   0       0       25 14     12       39   39
2757879 CT     school   800011   Meriden School District   801911 TLC - PHS Program           2021   pk_12_total * * 10   0 *     0   0   13 6     6             19   19     10   0       0   0   13 6     6       19   19
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
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
2757889 CT     school   830011   Middletown School District 90249001758 830611 ICM - Farm Hill Program           2021   pk_12_total * * *   0 0     0   0   * 0     0             *   *         0 0     0   0     0     0            
2757895 CT     school   830011   Middletown School District 90249001719 830811 ICM - Moody K-2 Program           2021   pk_12_total * * *   0 0     0   0   * *     0             *   *         0 0     0   0           0            
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
2757897 CT     school   830011   Middletown School District   832011 ICM - Spencer Program           2021   pk_12_total * * *   0 0     0   0   * *     0             *   *         0 0     0   0           0            
2757898 CT     school   830011   Middletown School District 90249001793 830411 ICM- Woodrow Wilson Middle School Program           2021   pk_12_total * * *   0 0     0   *   * *     0             9   9         0 0     0               0       9   9
2757902 CT     school   830011   Middletown School District 90249001765 831711 Virtual Learning Academy - MHS Program           2021   pk_12_total * * *   0 0     0   0   * *     0             *   9         0 0     0   0           0           9
2757903 CT     school   830011   Middletown School District 90249001657 831611 Evening Program - MHS Program           2021   pk_12_total * * *   0 0     0   *   * *     0             *   9         0 0     0               0           9
2757904 CT     school   830011   Middletown School District 90249001768 831911 MHS - Alternative Education Program 2 Program           2021   pk_12_total 0 * *   0 0     0   *   * *     0             0   11 0       0 0     0               0       0   11
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
2757907 CT     school 902520 840011   Milford School District 90252000471 841911 J. F. Kennedy School Public Schools Regular School No Elementary PK 05 2021   pk_12_total 196 * 70   0 30     *   20   168 154     18             45   322 196   70   0 30         20   168 154     18       45   322
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
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
2757921 CT     school   840011   Milford School District   840411 Fifth Year Vocational Experience Program           2021   pk_12_total * * 0   0 0     0   0   * *     0             8   8     0   0 0     0   0           0       8   8
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
2757925 CT     school 902550 850011   Monroe School District 90255000491 850311 Stepney Elementary School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 293 * 69   0 23     *   29   215 214     11             47   429 293   69   0 23         29   215 214     11       47   429
2757927 CT     school 902550 850011   Monroe School District 90255000489 856111 Masuk High School Public Schools Regular School No High 09 12 2021   pk_12_total 815 * 109   * 59     0   31   518 *     8             134   1033 815   109     59     0   31   518       8       134   1033
2757930 CT     school   860011   Montville School District 90258001663 860311 Pre School Program Program           2021   pk_12_total 26 * 6   0 *     0   *   26 11     0             17   37 26   6   0       0       26 11     0       17   37
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
2757934 CT     school 902580 860011   Montville School District 90258000495 866111 Montville High School Public Schools Regular School No High 09 12 2021   pk_12_total 304 * 60   * 57     0   54   * 264     14             58   496 304   60     57     0   54     264     14       58   496
2757935 CT     school   860011   Montville School District 90258001481 869011 Palmer Academy Program           2021   pk_12_total 25 * *   0 0     0   *   20 *     0             18   32 25       0 0     0       20       0       18   32
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
2757937 CT     school   880011   Naugatuck School District 90264001591 888211 Central Avenue Preschool Program           2021   pk_12_total 14 * 6   0 0     0   *   16 6     0             22   22 14   6   0 0     0       16 6     0       22   22

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