enrollments

Data source: Big Local News · About: Big Local

20,216 rows where state = "CT" and year = 2021 sorted by ccd_school_high_grade 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
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
2738681 2738681 CT     school 900750 250011   Cheshire School District 90075011188 250211 Darcey School Public Schools Regular School No Elementary PK KG 2021   kindergarten                                                   62                                             62
2739033 2739033 CT     school 903450 2450014   Learn 90345001430 2450214 The Friendship School Regional Education Service Center Schools Regular School No Elementary PK KG 2021   kindergarten                                                   105                                             105
2739372 2739372 CT     school 903210 1070011   Orange School District 90321001225 1070211 Mary L. Tracy School Public Schools Regular School No Elementary PK KG 2021   kindergarten                                                   162                                             162
2740125 2740125 CT     school 900750 250011   Cheshire School District 90075011188 250211 Darcey School Public Schools Regular School No Elementary PK KG 2021   grade_1                                                   0                                             0
2740477 2740477 CT     school 903450 2450014   Learn 90345001430 2450214 The Friendship School Regional Education Service Center Schools Regular School No Elementary PK KG 2021   grade_1                                                   0                                             0
2740816 2740816 CT     school 903210 1070011   Orange School District 90321001225 1070211 Mary L. Tracy School Public Schools Regular School No Elementary PK KG 2021   grade_1                                                   0                                             0
2741569 2741569 CT     school 900750 250011   Cheshire School District 90075011188 250211 Darcey School Public Schools Regular School No Elementary PK KG 2021   grade_2                                                   0                                             0
2741921 2741921 CT     school 903450 2450014   Learn 90345001430 2450214 The Friendship School Regional Education Service Center Schools Regular School No Elementary PK KG 2021   grade_2                                                   0                                             0
2742260 2742260 CT     school 903210 1070011   Orange School District 90321001225 1070211 Mary L. Tracy School Public Schools Regular School No Elementary PK KG 2021   grade_2                                                   0                                             0
2743013 2743013 CT     school 900750 250011   Cheshire School District 90075011188 250211 Darcey School Public Schools Regular School No Elementary PK KG 2021   grade_3                                                   0                                             0
2743365 2743365 CT     school 903450 2450014   Learn 90345001430 2450214 The Friendship School Regional Education Service Center Schools Regular School No Elementary PK KG 2021   grade_3                                                   0                                             0
2743704 2743704 CT     school 903210 1070011   Orange School District 90321001225 1070211 Mary L. Tracy School Public Schools Regular School No Elementary PK KG 2021   grade_3                                                   0                                             0
2744457 2744457 CT     school 900750 250011   Cheshire School District 90075011188 250211 Darcey School Public Schools Regular School No Elementary PK KG 2021   grade_4                                                   0                                             0
2744809 2744809 CT     school 903450 2450014   Learn 90345001430 2450214 The Friendship School Regional Education Service Center Schools Regular School No Elementary PK KG 2021   grade_4                                                   0                                             0
2745148 2745148 CT     school 903210 1070011   Orange School District 90321001225 1070211 Mary L. Tracy School Public Schools Regular School No Elementary PK KG 2021   grade_4                                                   0                                             0
2745901 2745901 CT     school 900750 250011   Cheshire School District 90075011188 250211 Darcey School Public Schools Regular School No Elementary PK KG 2021   grade_5                                                   0                                             0
2746253 2746253 CT     school 903450 2450014   Learn 90345001430 2450214 The Friendship School Regional Education Service Center Schools Regular School No Elementary PK KG 2021   grade_5                                                   0                                             0
2746592 2746592 CT     school 903210 1070011   Orange School District 90321001225 1070211 Mary L. Tracy School Public Schools Regular School No Elementary PK KG 2021   grade_5                                                   0                                             0
2747345 2747345 CT     school 900750 250011   Cheshire School District 90075011188 250211 Darcey School Public Schools Regular School No Elementary PK KG 2021   grade_6                                                   0                                             0
2747697 2747697 CT     school 903450 2450014   Learn 90345001430 2450214 The Friendship School Regional Education Service Center Schools Regular School No Elementary PK KG 2021   grade_6                                                   0                                             0
2748036 2748036 CT     school 903210 1070011   Orange School District 90321001225 1070211 Mary L. Tracy School Public Schools Regular School No Elementary PK KG 2021   grade_6                                                   0                                             0
2748789 2748789 CT     school 900750 250011   Cheshire School District 90075011188 250211 Darcey School Public Schools Regular School No Elementary PK KG 2021   grade_7                                                   0                                             0
2749141 2749141 CT     school 903450 2450014   Learn 90345001430 2450214 The Friendship School Regional Education Service Center Schools Regular School No Elementary PK KG 2021   grade_7                                                   0                                             0
2749480 2749480 CT     school 903210 1070011   Orange School District 90321001225 1070211 Mary L. Tracy School Public Schools Regular School No Elementary PK KG 2021   grade_7                                                   0                                             0
2750233 2750233 CT     school 900750 250011   Cheshire School District 90075011188 250211 Darcey School Public Schools Regular School No Elementary PK KG 2021   grade_8                                                   0                                             0
2750585 2750585 CT     school 903450 2450014   Learn 90345001430 2450214 The Friendship School Regional Education Service Center Schools Regular School No Elementary PK KG 2021   grade_8                                                   0                                             0
2750924 2750924 CT     school 903210 1070011   Orange School District 90321001225 1070211 Mary L. Tracy School Public Schools Regular School No Elementary PK KG 2021   grade_8                                                   0                                             0
2751677 2751677 CT     school 900750 250011   Cheshire School District 90075011188 250211 Darcey School Public Schools Regular School No Elementary PK KG 2021   grade_9                                                   0                                             0
2752029 2752029 CT     school 903450 2450014   Learn 90345001430 2450214 The Friendship School Regional Education Service Center Schools Regular School No Elementary PK KG 2021   grade_9                                                   0                                             0
2752368 2752368 CT     school 903210 1070011   Orange School District 90321001225 1070211 Mary L. Tracy School Public Schools Regular School No Elementary PK KG 2021   grade_9                                                   0                                             0
2753121 2753121 CT     school 900750 250011   Cheshire School District 90075011188 250211 Darcey School Public Schools Regular School No Elementary PK KG 2021   grade_10                                                   0                                             0
2753473 2753473 CT     school 903450 2450014   Learn 90345001430 2450214 The Friendship School Regional Education Service Center Schools Regular School No Elementary PK KG 2021   grade_10                                                   0                                             0
2753812 2753812 CT     school 903210 1070011   Orange School District 90321001225 1070211 Mary L. Tracy School Public Schools Regular School No Elementary PK KG 2021   grade_10                                                   0                                             0
2754565 2754565 CT     school 900750 250011   Cheshire School District 90075011188 250211 Darcey School Public Schools Regular School No Elementary PK KG 2021   grade_11                                                   0                                             0
2754917 2754917 CT     school 903450 2450014   Learn 90345001430 2450214 The Friendship School Regional Education Service Center Schools Regular School No Elementary PK KG 2021   grade_11                                                   0                                             0
2755256 2755256 CT     school 903210 1070011   Orange School District 90321001225 1070211 Mary L. Tracy School Public Schools Regular School No Elementary PK KG 2021   grade_11                                                   0                                             0
2756009 2756009 CT     school 900750 250011   Cheshire School District 90075011188 250211 Darcey School Public Schools Regular School No Elementary PK KG 2021   grade_12                                                   0                                             0
2756361 2756361 CT     school 903450 2450014   Learn 90345001430 2450214 The Friendship School Regional Education Service Center Schools Regular School No Elementary PK KG 2021   grade_12                                                   0                                             0
2756700 2756700 CT     school 903210 1070011   Orange School District 90321001225 1070211 Mary L. Tracy School Public Schools Regular School No Elementary PK KG 2021   grade_12                                                   0                                             0
2757453 2757453 CT     school 900750 250011   Cheshire School District 90075011188 250211 Darcey School Public Schools Regular School No Elementary PK KG 2021   pk_12_total 118 * 18   0 *     0   11   82 74     *             45   156 118   18   0       0   11   82 74             45   156
2757805 2757805 CT     school 903450 2450014   Learn 90345001430 2450214 The Friendship School Regional Education Service Center Schools Regular School No Elementary PK KG 2021   pk_12_total 158 43 172   * *     0   57   242 209     19             48   451 158 43 172           0   57   242 209     19       48   451
2758144 2758144 CT     school 903210 1070011   Orange School District 90321001225 1070211 Mary L. Tracy School Public Schools Regular School No Elementary PK KG 2021   pk_12_total 158 * 16   0 23     0   *   111 99     10             33   210 158   16   0 23     0       111 99     10       33   210
2738521 2738521 CT     school 900060 20011   Ansonia School District 90006010002 26111 Ansonia High School Public Schools Regular School No High 09 12 2021   kindergarten                                                   0                                             0
2738531 2738531 CT     school 900120 40011   Avon School District 90012000011 46111 Avon High School Public Schools Regular School No High 09 12 2021   kindergarten                                                   0                                             0
2738539 2738539 CT     school 900210 70011   Berlin School District 90021000016 76111 Berlin High School Public Schools Regular School No High 09 12 2021   kindergarten                                                   0                                             0
2738546 2738546 CT     school 900270 90011   Bethel School District 90027000024 96111 Bethel High School Public Schools Regular School No High 09 12 2021   kindergarten                                                   0                                             0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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