enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
2749562 2749562 CT     school 903540 2180012   Regional School District 18 90354000761 2180312 Center School Regional Schools Special Education School No Prekindergarten PK PK 2021   grade_7                                                   0                                             0
2749637 2749637 CT     school 904230 1310011   Southington School District 90423001808 1312011 Southington Public Schools Preschool Program at Hatton School Public Schools Regular School No Prekindergarten PK PK 2021   grade_7                                                   0                                             0
2750101 2750101 CT     school 900330 110011   Bloomfield School District 90033001565 110811 Wintonbury Early Childhood Magnet School Public Schools Regular School No Prekindergarten PK PK 2021   grade_8                                                   0                                             0
2750122 2750122 CT     school 900450 150011   Bridgeport School District 90045000085 154411 A.B. Skane Center Public Schools Regular School No Prekindergarten PK PK 2021   grade_8                                                   0                                             0
2750161 2750161 CT     school 900510 170011   Bristol School District 90051001774 170411 Bristol Early Childhood Center-BECC Public Schools Special Education School No Prekindergarten PK PK 2021   grade_8                                                   0                                             0
2750274 2750274 CT     school 901020 340011   Danbury School District 90102001634 340111 DPS Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2021   grade_8                                                   0                                             0
2750301 2750301 CT     school 901110 370011   Derby School District 90111001806 370111 Little Raiders University Public Schools Regular School No Prekindergarten PK PK 2021   grade_8                                                   0                                             0
2750336 2750336 CT     school 901290 440011   East Haven School District 90129001350 441811 Overbrook Early Learning Center Public Schools Regular School No Prekindergarten PK PK 2021   grade_8                                                   0                                             0
2750517 2750517 CT     school 901920 640011   Hartford School District 90192001643 641311 Hartford PreKindergarten Magnet School Public Schools Regular School No Prekindergarten PK PK 2021   grade_8                                                   0                                             0
2750885 2750885 CT     school 903090 1030011   Norwalk School District 90309001914 1030111 Norwalk Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2021   grade_8                                                   0                                             0
2750904 2750904 CT     school 903120 1040011   Norwich School District 90312000663 1040111 Bishop School Early Learning Center Public Schools Regular School No Prekindergarten PK PK 2021   grade_8                                                   0                                             0
2751006 2751006 CT     school 903540 2180012   Regional School District 18 90354000761 2180312 Center School Regional Schools Special Education School No Prekindergarten PK PK 2021   grade_8                                                   0                                             0
2751081 2751081 CT     school 904230 1310011   Southington School District 90423001808 1312011 Southington Public Schools Preschool Program at Hatton School Public Schools Regular School No Prekindergarten PK PK 2021   grade_8                                                   0                                             0
2751545 2751545 CT     school 900330 110011   Bloomfield School District 90033001565 110811 Wintonbury Early Childhood Magnet School Public Schools Regular School No Prekindergarten PK PK 2021   grade_9                                                   0                                             0
2751566 2751566 CT     school 900450 150011   Bridgeport School District 90045000085 154411 A.B. Skane Center Public Schools Regular School No Prekindergarten PK PK 2021   grade_9                                                   0                                             0
2751605 2751605 CT     school 900510 170011   Bristol School District 90051001774 170411 Bristol Early Childhood Center-BECC Public Schools Special Education School No Prekindergarten PK PK 2021   grade_9                                                   0                                             0
2751718 2751718 CT     school 901020 340011   Danbury School District 90102001634 340111 DPS Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2021   grade_9                                                   0                                             0
2751745 2751745 CT     school 901110 370011   Derby School District 90111001806 370111 Little Raiders University Public Schools Regular School No Prekindergarten PK PK 2021   grade_9                                                   0                                             0
2751780 2751780 CT     school 901290 440011   East Haven School District 90129001350 441811 Overbrook Early Learning Center Public Schools Regular School No Prekindergarten PK PK 2021   grade_9                                                   0                                             0
2751961 2751961 CT     school 901920 640011   Hartford School District 90192001643 641311 Hartford PreKindergarten Magnet School Public Schools Regular School No Prekindergarten PK PK 2021   grade_9                                                   0                                             0
2752329 2752329 CT     school 903090 1030011   Norwalk School District 90309001914 1030111 Norwalk Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2021   grade_9                                                   0                                             0
2752348 2752348 CT     school 903120 1040011   Norwich School District 90312000663 1040111 Bishop School Early Learning Center Public Schools Regular School No Prekindergarten PK PK 2021   grade_9                                                   0                                             0
2752450 2752450 CT     school 903540 2180012   Regional School District 18 90354000761 2180312 Center School Regional Schools Special Education School No Prekindergarten PK PK 2021   grade_9                                                   0                                             0
2752525 2752525 CT     school 904230 1310011   Southington School District 90423001808 1312011 Southington Public Schools Preschool Program at Hatton School Public Schools Regular School No Prekindergarten PK PK 2021   grade_9                                                   0                                             0
2752989 2752989 CT     school 900330 110011   Bloomfield School District 90033001565 110811 Wintonbury Early Childhood Magnet School Public Schools Regular School No Prekindergarten PK PK 2021   grade_10                                                   0                                             0
2753010 2753010 CT     school 900450 150011   Bridgeport School District 90045000085 154411 A.B. Skane Center Public Schools Regular School No Prekindergarten PK PK 2021   grade_10                                                   0                                             0
2753049 2753049 CT     school 900510 170011   Bristol School District 90051001774 170411 Bristol Early Childhood Center-BECC Public Schools Special Education School No Prekindergarten PK PK 2021   grade_10                                                   0                                             0
2753162 2753162 CT     school 901020 340011   Danbury School District 90102001634 340111 DPS Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2021   grade_10                                                   0                                             0
2753189 2753189 CT     school 901110 370011   Derby School District 90111001806 370111 Little Raiders University Public Schools Regular School No Prekindergarten PK PK 2021   grade_10                                                   0                                             0
2753224 2753224 CT     school 901290 440011   East Haven School District 90129001350 441811 Overbrook Early Learning Center Public Schools Regular School No Prekindergarten PK PK 2021   grade_10                                                   0                                             0
2753405 2753405 CT     school 901920 640011   Hartford School District 90192001643 641311 Hartford PreKindergarten Magnet School Public Schools Regular School No Prekindergarten PK PK 2021   grade_10                                                   0                                             0
2753773 2753773 CT     school 903090 1030011   Norwalk School District 90309001914 1030111 Norwalk Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2021   grade_10                                                   0                                             0
2753792 2753792 CT     school 903120 1040011   Norwich School District 90312000663 1040111 Bishop School Early Learning Center Public Schools Regular School No Prekindergarten PK PK 2021   grade_10                                                   0                                             0
2753894 2753894 CT     school 903540 2180012   Regional School District 18 90354000761 2180312 Center School Regional Schools Special Education School No Prekindergarten PK PK 2021   grade_10                                                   0                                             0
2753969 2753969 CT     school 904230 1310011   Southington School District 90423001808 1312011 Southington Public Schools Preschool Program at Hatton School Public Schools Regular School No Prekindergarten PK PK 2021   grade_10                                                   0                                             0
2754433 2754433 CT     school 900330 110011   Bloomfield School District 90033001565 110811 Wintonbury Early Childhood Magnet School Public Schools Regular School No Prekindergarten PK PK 2021   grade_11                                                   0                                             0
2754454 2754454 CT     school 900450 150011   Bridgeport School District 90045000085 154411 A.B. Skane Center Public Schools Regular School No Prekindergarten PK PK 2021   grade_11                                                   0                                             0
2754493 2754493 CT     school 900510 170011   Bristol School District 90051001774 170411 Bristol Early Childhood Center-BECC Public Schools Special Education School No Prekindergarten PK PK 2021   grade_11                                                   0                                             0
2754606 2754606 CT     school 901020 340011   Danbury School District 90102001634 340111 DPS Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2021   grade_11                                                   0                                             0
2754633 2754633 CT     school 901110 370011   Derby School District 90111001806 370111 Little Raiders University Public Schools Regular School No Prekindergarten PK PK 2021   grade_11                                                   0                                             0
2754668 2754668 CT     school 901290 440011   East Haven School District 90129001350 441811 Overbrook Early Learning Center Public Schools Regular School No Prekindergarten PK PK 2021   grade_11                                                   0                                             0
2754849 2754849 CT     school 901920 640011   Hartford School District 90192001643 641311 Hartford PreKindergarten Magnet School Public Schools Regular School No Prekindergarten PK PK 2021   grade_11                                                   0                                             0
2755217 2755217 CT     school 903090 1030011   Norwalk School District 90309001914 1030111 Norwalk Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2021   grade_11                                                   0                                             0
2755236 2755236 CT     school 903120 1040011   Norwich School District 90312000663 1040111 Bishop School Early Learning Center Public Schools Regular School No Prekindergarten PK PK 2021   grade_11                                                   0                                             0
2755338 2755338 CT     school 903540 2180012   Regional School District 18 90354000761 2180312 Center School Regional Schools Special Education School No Prekindergarten PK PK 2021   grade_11                                                   0                                             0
2755413 2755413 CT     school 904230 1310011   Southington School District 90423001808 1312011 Southington Public Schools Preschool Program at Hatton School Public Schools Regular School No Prekindergarten PK PK 2021   grade_11                                                   0                                             0
2755877 2755877 CT     school 900330 110011   Bloomfield School District 90033001565 110811 Wintonbury Early Childhood Magnet School Public Schools Regular School No Prekindergarten PK PK 2021   grade_12                                                   0                                             0
2755898 2755898 CT     school 900450 150011   Bridgeport School District 90045000085 154411 A.B. Skane Center Public Schools Regular School No Prekindergarten PK PK 2021   grade_12                                                   0                                             0
2755937 2755937 CT     school 900510 170011   Bristol School District 90051001774 170411 Bristol Early Childhood Center-BECC Public Schools Special Education School No Prekindergarten PK PK 2021   grade_12                                                   0                                             0
2756050 2756050 CT     school 901020 340011   Danbury School District 90102001634 340111 DPS Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2021   grade_12                                                   0                                             0
2756077 2756077 CT     school 901110 370011   Derby School District 90111001806 370111 Little Raiders University Public Schools Regular School No Prekindergarten PK PK 2021   grade_12                                                   0                                             0
2756112 2756112 CT     school 901290 440011   East Haven School District 90129001350 441811 Overbrook Early Learning Center Public Schools Regular School No Prekindergarten PK PK 2021   grade_12                                                   0                                             0
2756293 2756293 CT     school 901920 640011   Hartford School District 90192001643 641311 Hartford PreKindergarten Magnet School Public Schools Regular School No Prekindergarten PK PK 2021   grade_12                                                   0                                             0
2756661 2756661 CT     school 903090 1030011   Norwalk School District 90309001914 1030111 Norwalk Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2021   grade_12                                                   0                                             0
2756680 2756680 CT     school 903120 1040011   Norwich School District 90312000663 1040111 Bishop School Early Learning Center Public Schools Regular School No Prekindergarten PK PK 2021   grade_12                                                   0                                             0
2756782 2756782 CT     school 903540 2180012   Regional School District 18 90354000761 2180312 Center School Regional Schools Special Education School No Prekindergarten PK PK 2021   grade_12                                                   0                                             0
2756857 2756857 CT     school 904230 1310011   Southington School District 90423001808 1312011 Southington Public Schools Preschool Program at Hatton School Public Schools Regular School No Prekindergarten PK PK 2021   grade_12                                                   0                                             0
2757321 2757321 CT     school 900330 110011   Bloomfield School District 90033001565 110811 Wintonbury Early Childhood Magnet School Public Schools Regular School No Prekindergarten PK PK 2021   pk_12_total 106 113 37   0 35     0   18   139 170     0             37   309 106 113 37   0 35     0   18   139 170     0       37   309
2757342 2757342 CT     school 900450 150011   Bridgeport School District 90045000085 154411 A.B. Skane Center Public Schools Regular School No Prekindergarten PK PK 2021   pk_12_total 20 58 117   * 6     0   *   125 80     0             126   205 20 58 117     6     0       125 80     0       126   205
2757381 2757381 CT     school 900510 170011   Bristol School District 90051001774 170411 Bristol Early Childhood Center-BECC Public Schools Special Education School No Prekindergarten PK PK 2021   pk_12_total 46 * 38   0 *     0   10   63 33     0             71   96 46   38   0       0   10   63 33     0       71   96
2757494 2757494 CT     school 901020 340011   Danbury School District 90102001634 340111 DPS Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2021   pk_12_total 31 12 80   0 *     0   *   80 54     0             97   134 31 12 80   0       0       80 54     0       97   134
2757521 2757521 CT     school 901110 370011   Derby School District 90111001806 370111 Little Raiders University Public Schools Regular School No Prekindergarten PK PK 2021   pk_12_total 18 * 16   0 *     0   *   25 18     0             18   43 18   16   0       0       25 18     0       18   43
2757556 2757556 CT     school 901290 440011   East Haven School District 90129001350 441811 Overbrook Early Learning Center Public Schools Regular School No Prekindergarten PK PK 2021   pk_12_total 55 * 36   0 7     0   *   56 51     0             *   107 55   36   0 7     0       56 51     0           107
2757737 2757737 CT     school 901920 640011   Hartford School District 90192001643 641311 Hartford PreKindergarten Magnet School Public Schools Regular School No Prekindergarten PK PK 2021   pk_12_total 12 64 37   * 55     0   *   82 98     0             10   180 12 64 37     55     0       82 98     0       10   180
2758105 2758105 CT     school 903090 1030011   Norwalk School District 90309001914 1030111 Norwalk Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2021   pk_12_total 38 16 59   0 *     0   *   78 47     0             82   125 38 16 59   0       0       78 47     0       82   125
2758124 2758124 CT     school 903120 1040011   Norwich School District 90312000663 1040111 Bishop School Early Learning Center Public Schools Regular School No Prekindergarten PK PK 2021   pk_12_total 34 25 36   * *     0   12   73 40     0             64   113 34 25 36           0   12   73 40     0       64   113
2758226 2758226 CT     school 903540 2180012   Regional School District 18 90354000761 2180312 Center School Regional Schools Special Education School No Prekindergarten PK PK 2021   pk_12_total 85 * *   0 *     0   *   52 43     0             17   95 85       0       0       52 43     0       17   95
2758301 2758301 CT     school 904230 1310011   Southington School District 90423001808 1312011 Southington Public Schools Preschool Program at Hatton School Public Schools Regular School No Prekindergarten PK PK 2021   pk_12_total 30 0 *   0 *     0   *   23 15     0             25   38 30 0     0       0       23 15     0       25   38
2738960 2738960 CT     school 901920 640011   Hartford School District 90192001435 646911 Capital Preparatory Magnet School Public Schools Regular School No Other PK 12 2021   kindergarten                                                   44                                             44
2738967 2738967 CT     school 901920 640011   Hartford School District 90192000370 641111 Kinsella Magnet School of Performing Arts Public Schools Regular School No Other PK 12 2021   kindergarten                                                   55                                             55
2739022 2739022 CT     school 900207 2860013   Highville Charter School District 90020700907 2860113 Highville Charter School Public Charter Schools Regular School Yes Other PK 12 2021   kindergarten                                                   54                                             54
2739024 2739024 CT     school 900007 2610013   Jumoke Academy District 90000700747 2610113 Jumoke Academy Public Charter Schools Regular School Yes Other PK 12 2021   kindergarten                                                   61                                             61
2739874 2739874 CT     school 900208 2850013   Achievement First Bridgeport Academy District 90020801493 2850113 Achievement First Bridgeport Academy Public Charter Schools Regular School Yes Other KG 12 2021   kindergarten                                                   96                                             96
2739875 2739875 CT     school 900212 2880013   Achievement First Hartford Academy District 90021201528 2880113 Achievement First Hartford Academy Public Charter Schools Regular School Yes Other KG 12 2021   kindergarten                                                   60                                             60
2739876 2739876 CT     school 900024 2790013   Amistad Academy District 90002400981 2795113 Amistad Academy Public Charter Schools Regular School Yes Other KG 12 2021   kindergarten                                                   92                                             92
2739889 2739889 CT     school 900221 2970013   Capital Preparatory Harbor School District 90022101803 2970113 Capital Preparatory Harbor School Public Charter Schools Regular School Yes Other KG 12 2021   kindergarten                                                   52                                             52
2739893 2739893 CT     school 900214 2890013   Elm City College Preparatory School District 90021401548 2890113 Elm City College Preparatory School Public Charter Schools Regular School Yes Other KG 12 2021   kindergarten                                                   56                                             56
2740404 2740404 CT     school 901920 640011   Hartford School District 90192001435 646911 Capital Preparatory Magnet School Public Schools Regular School No Other PK 12 2021   grade_1                                                   47                                             47
2740411 2740411 CT     school 901920 640011   Hartford School District 90192000370 641111 Kinsella Magnet School of Performing Arts Public Schools Regular School No Other PK 12 2021   grade_1                                                   53                                             53
2740466 2740466 CT     school 900207 2860013   Highville Charter School District 90020700907 2860113 Highville Charter School Public Charter Schools Regular School Yes Other PK 12 2021   grade_1                                                   26                                             26
2740468 2740468 CT     school 900007 2610013   Jumoke Academy District 90000700747 2610113 Jumoke Academy Public Charter Schools Regular School Yes Other PK 12 2021   grade_1                                                   71                                             71
2741318 2741318 CT     school 900208 2850013   Achievement First Bridgeport Academy District 90020801493 2850113 Achievement First Bridgeport Academy Public Charter Schools Regular School Yes Other KG 12 2021   grade_1                                                   94                                             94
2741319 2741319 CT     school 900212 2880013   Achievement First Hartford Academy District 90021201528 2880113 Achievement First Hartford Academy Public Charter Schools Regular School Yes Other KG 12 2021   grade_1                                                   101                                             101
2741320 2741320 CT     school 900024 2790013   Amistad Academy District 90002400981 2795113 Amistad Academy Public Charter Schools Regular School Yes Other KG 12 2021   grade_1                                                   95                                             95
2741333 2741333 CT     school 900221 2970013   Capital Preparatory Harbor School District 90022101803 2970113 Capital Preparatory Harbor School Public Charter Schools Regular School Yes Other KG 12 2021   grade_1                                                   76                                             76
2741337 2741337 CT     school 900214 2890013   Elm City College Preparatory School District 90021401548 2890113 Elm City College Preparatory School Public Charter Schools Regular School Yes Other KG 12 2021   grade_1                                                   66                                             66
2741848 2741848 CT     school 901920 640011   Hartford School District 90192001435 646911 Capital Preparatory Magnet School Public Schools Regular School No Other PK 12 2021   grade_2                                                   44                                             44
2741855 2741855 CT     school 901920 640011   Hartford School District 90192000370 641111 Kinsella Magnet School of Performing Arts Public Schools Regular School No Other PK 12 2021   grade_2                                                   57                                             57
2741910 2741910 CT     school 900207 2860013   Highville Charter School District 90020700907 2860113 Highville Charter School Public Charter Schools Regular School Yes Other PK 12 2021   grade_2                                                   34                                             34
2741912 2741912 CT     school 900007 2610013   Jumoke Academy District 90000700747 2610113 Jumoke Academy Public Charter Schools Regular School Yes Other PK 12 2021   grade_2                                                   70                                             70
2742762 2742762 CT     school 900208 2850013   Achievement First Bridgeport Academy District 90020801493 2850113 Achievement First Bridgeport Academy Public Charter Schools Regular School Yes Other KG 12 2021   grade_2                                                   94                                             94
2742763 2742763 CT     school 900212 2880013   Achievement First Hartford Academy District 90021201528 2880113 Achievement First Hartford Academy Public Charter Schools Regular School Yes Other KG 12 2021   grade_2                                                   107                                             107
2742764 2742764 CT     school 900024 2790013   Amistad Academy District 90002400981 2795113 Amistad Academy Public Charter Schools Regular School Yes Other KG 12 2021   grade_2                                                   95                                             95
2742777 2742777 CT     school 900221 2970013   Capital Preparatory Harbor School District 90022101803 2970113 Capital Preparatory Harbor School Public Charter Schools Regular School Yes Other KG 12 2021   grade_2                                                   64                                             64
2742781 2742781 CT     school 900214 2890013   Elm City College Preparatory School District 90021401548 2890113 Elm City College Preparatory School Public Charter Schools Regular School Yes Other KG 12 2021   grade_2                                                   69                                             69
2743292 2743292 CT     school 901920 640011   Hartford School District 90192001435 646911 Capital Preparatory Magnet School Public Schools Regular School No Other PK 12 2021   grade_3                                                   40                                             40
2743299 2743299 CT     school 901920 640011   Hartford School District 90192000370 641111 Kinsella Magnet School of Performing Arts Public Schools Regular School No Other PK 12 2021   grade_3                                                   47                                             47
2743354 2743354 CT     school 900207 2860013   Highville Charter School District 90020700907 2860113 Highville Charter School Public Charter Schools Regular School Yes Other PK 12 2021   grade_3                                                   25                                             25
2743356 2743356 CT     school 900007 2610013   Jumoke Academy District 90000700747 2610113 Jumoke Academy Public Charter Schools Regular School Yes Other PK 12 2021   grade_3                                                   62                                             62
2744206 2744206 CT     school 900208 2850013   Achievement First Bridgeport Academy District 90020801493 2850113 Achievement First Bridgeport Academy Public Charter Schools Regular School Yes Other KG 12 2021   grade_3                                                   92                                             92

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