enrollments

Data source: Big Local News · About: Big Local

3,528 rows where grade = "grade_8" and state = "IN" sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_8 · 3,528 ✖
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
1160556 1160556 IN     school 1801920 1000   Clarksville Com School Corp 180192000248 851 Clarksville Middle School   Regular School No 2.0 05 08 2015   grade_8                         53.0 45.0                       98.0                         53 45                 98
1281951 1281951 IN     school 1801920 1000   Clarksville Com School Corp 180192000248 851 Clarksville Middle School   Regular School No 2.0 05 08 2016   grade_8                         53.0 60.0                       113.0                         53 60                 113
1294009 1294009 IN     school 1801920 1000   Clarksville Community School Corp 180192000248 851 Clarksville Middle School   Regular School No Middle 05 08 2017   grade_8                         44.0 52.0                       96.0                         44 52                 96
1752636 1752636 IN     school 1801920 1000   Clarksville Community School Corp 180192000248 851 Clarksville Middle School   Regular School No Middle 05 08 2019   grade_8                         53.0 40.0                       93.0                         53 40                 93
1788375 1788375 IN     school 1801920 1000   Clarksville Community School Corp 180192000248 851 Clarksville Middle School   Regular School No Middle 05 08 2018   grade_8                         61.0 57.0                       118.0                         61 57                 118
1908075 1908075 IN     school 1801920 1000   Clarksville Community School Corp 180192000248 851 Clarksville Middle School   Regular School No Middle 05 08 2020   grade_8                         63.0 31.0                       94.0                         63 31                 94
1920040 1920040 IN     school 1801920 1000   Clarksville Community School Corp 180192000248 851 Clarksville Middle School   Regular School No Middle 05 08 2021   grade_8                         37.0 48.0                       85.0                         37 48                 85
1920052 1920052 IN     school 1801920 1000   Clarksville Community School Corp 180192002690 1007 Indiana Gateway Digital Academy   Regular School No Other KG 12 2021   grade_8                         93.0 96.0                       189.0                         93 96                 189
1160600 1160600 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No 4.0 06 12 2015   grade_8                         38.0 37.0                       75.0                         38 37                 75
1160629 1160629 IN     school 1803940 1010   Greater Clark County Schools 180394000674 853 Parkview Middle School   Regular School No 2.0 06 08 2015   grade_8                         160.0 120.0                       280.0                         160 120                 280
1160633 1160633 IN     school 1803940 1010   Greater Clark County Schools 180394002128 863 Charlestown Middle School   Regular School No 2.0 06 08 2015   grade_8                         96.0 75.0                       171.0                         96 75                 171
1160675 1160675 IN     school 1803940 1010   Greater Clark County Schools 180394002131 883 River Valley Middle School   Regular School No 2.0 06 08 2015   grade_8                         151.0 149.0                       300.0                         151 149                 300
1160684 1160684 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 04 12 2015   grade_8                         8.0 0.0                       8.0                         8 0                 8
1160691 1160691 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative Education School No 3.0 07 12 2015   grade_8                         8.0 5.0                       13.0                         8 5                 13
1281998 1281998 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No 4.0 06 12 2016   grade_8                         26.0 30.0                       56.0                         26 30                 56
1282029 1282029 IN     school 1803940 1010   Greater Clark County Schools 180394000674 853 Parkview Middle School   Regular School No 2.0 06 08 2016   grade_8                         131.0 101.0                       232.0                         131 101                 232
1282033 1282033 IN     school 1803940 1010   Greater Clark County Schools 180394002128 863 Charlestown Middle School   Regular School No 2.0 06 08 2016   grade_8                         92.0 75.0                       167.0                         92 75                 167
1282077 1282077 IN     school 1803940 1010   Greater Clark County Schools 180394002131 883 River Valley Middle School   Regular School No 2.0 06 08 2016   grade_8                         148.0 126.0                       274.0                         148 126                 274
1282085 1282085 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 05 12 2016   grade_8                         8.0 4.0                       12.0                         8 4                 12
1282093 1282093 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative Education School No 4.0 06 12 2016   grade_8                         5.0 0.0                       5.0                         5 0                 5
1294056 1294056 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No Other 06 12 2017   grade_8                         23.0 22.0                       45.0                         23 22                 45
1294087 1294087 IN     school 1803940 1010   Greater Clark County Schools 180394000674 853 Parkview Middle School   Regular School No Middle 06 08 2017   grade_8                         111.0 108.0                       219.0                         111 108                 219
1294091 1294091 IN     school 1803940 1010   Greater Clark County Schools 180394002128 863 Charlestown Middle School   Regular School No Middle 06 08 2017   grade_8                         84.0 98.0                       182.0                         84 98                 182
1294135 1294135 IN     school 1803940 1010   Greater Clark County Schools 180394002131 883 River Valley Middle School   Regular School No Middle 06 08 2017   grade_8                         153.0 129.0                       282.0                         153 129                 282
1294144 1294144 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No Other 04 12 2017   grade_8                         6.0 0.0                       6.0                         6 0                 6
1294152 1294152 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No Other 06 12 2017   grade_8                         4.0 4.0                       8.0                         4 4                 8
1752683 1752683 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No High 06 12 2019   grade_8                         18.0 26.0                       44.0                         18 26                 44
1752707 1752707 IN     school 1803940 1010   Greater Clark County Schools 180394000674 853 Parkview Middle School   Regular School No Middle 06 08 2019   grade_8                         113.0 115.0                       228.0                         113 115                 228
1752711 1752711 IN     school 1803940 1010   Greater Clark County Schools 180394002128 863 Charlestown Middle School   Regular School No Middle 06 08 2019   grade_8                         78.0 97.0                       175.0                         78 97                 175
1752754 1752754 IN     school 1803940 1010   Greater Clark County Schools 180394002131 883 River Valley Middle School   Regular School No Middle 06 08 2019   grade_8                         174.0 130.0                       304.0                         174 130                 304
1752761 1752761 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No High 06 12 2019   grade_8                         4.0 0.0                       4.0                         4 0                 4
1752768 1752768 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No High 07 12 2019   grade_8                         5.0 1.0                       6.0                         5 1                 6
1788422 1788422 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No High 06 12 2018   grade_8                         23.0 24.0                       47.0                         23 24                 47
1788446 1788446 IN     school 1803940 1010   Greater Clark County Schools 180394000674 853 Parkview Middle School   Regular School No Middle 06 08 2018   grade_8                         125.0 103.0                       228.0                         125 103                 228
1788450 1788450 IN     school 1803940 1010   Greater Clark County Schools 180394002128 863 Charlestown Middle School   Regular School No Middle 06 08 2018   grade_8                         90.0 70.0                       160.0                         90 70                 160
1788494 1788494 IN     school 1803940 1010   Greater Clark County Schools 180394002131 883 River Valley Middle School   Regular School No Middle 06 08 2018   grade_8                         167.0 152.0                       319.0                         167 152                 319
1788502 1788502 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No High 05 12 2018   grade_8                         5.0 2.0                       7.0                         5 2                 7
1788509 1788509 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No High 07 12 2018   grade_8                         7.0 0.0                       7.0                         7 0                 7
1908119 1908119 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No High 06 12 2020   grade_8                         27.0 25.0                       52.0                         27 25                 52
1908143 1908143 IN     school 1803940 1010   Greater Clark County Schools 180394000674 853 Parkview Middle School   Regular School No Middle 06 08 2020   grade_8                         112.0 120.0                       232.0                         112 120                 232
1908147 1908147 IN     school 1803940 1010   Greater Clark County Schools 180394002128 863 Charlestown Middle School   Regular School No Middle 06 08 2020   grade_8                         91.0 102.0                       193.0                         91 102                 193
1908190 1908190 IN     school 1803940 1010   Greater Clark County Schools 180394002131 883 River Valley Middle School   Regular School No Middle 06 08 2020   grade_8                         171.0 157.0                       328.0                         171 157                 328
1908197 1908197 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No High 06 12 2020   grade_8                         6.0 2.0                       8.0                         6 2                 8
1920101 1920101 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No High 06 12 2021   grade_8                         17.0 32.0                       49.0                         17 32                 49
1920125 1920125 IN     school 1803940 1010   Greater Clark County Schools 180394000674 853 Parkview Middle School   Regular School No Middle 06 08 2021   grade_8                         135.0 123.0                       258.0                         135 123                 258
1920129 1920129 IN     school 1803940 1010   Greater Clark County Schools 180394002128 863 Charlestown Middle School   Regular School No Middle 06 08 2021   grade_8                         98.0 83.0                       181.0                         98 83                 181
1920165 1920165 IN     school 1803940 1010   Greater Clark County Schools 180394002131 883 River Valley Middle School   Regular School No Middle 06 08 2021   grade_8                         170.0 172.0                       342.0                         170 172                 342
1920172 1920172 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No High 06 12 2021   grade_8                         8.0 3.0                       11.0                         8 3                 11
1160706 1160706 IN     school 1800840 1125   Clay Community Schools 180084000157 897 Clay City Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_8                         22.0 33.0                       55.0                         22 33                 55
1160732 1160732 IN     school 1800840 1125   Clay Community Schools 180084000165 925 North Clay Middle School   Regular School No 2.0 06 08 2015   grade_8                         149.0 129.0                       278.0                         149 129                 278
1282108 1282108 IN     school 1800840 1125   Clay Community Schools 180084000157 897 Clay City Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_8                         27.0 34.0                       61.0                         27 34                 61
1282134 1282134 IN     school 1800840 1125   Clay Community Schools 180084000165 925 North Clay Middle School   Regular School No 2.0 06 08 2016   grade_8                         150.0 141.0                       291.0                         150 141                 291
1282154 1282154 IN     school 1800840 1125   Clay Community Schools 180084000159 942 Forest Park Elementary School   Regular School No 1.0 PK 08 2016   grade_8                         1.0 0.0                       1.0                         1 0                 1
1294167 1294167 IN     school 1800840 1125   Clay Community Schools 180084000157 897 Clay City Jr-Sr High School   Regular School No High 07 12 2017   grade_8                         31.0 31.0                       62.0                         31 31                 62
1294193 1294193 IN     school 1800840 1125   Clay Community Schools 180084000165 925 North Clay Middle School   Regular School No Middle 06 08 2017   grade_8                         149.0 144.0                       293.0                         149 144                 293
1752783 1752783 IN     school 1800840 1125   Clay Community Schools 180084000157 897 Clay City Jr-Sr High School   Regular School No High 07 12 2019   grade_8                         26.0 32.0                       58.0                         26 32                 58
1752809 1752809 IN     school 1800840 1125   Clay Community Schools 180084000165 925 North Clay Middle School   Regular School No Middle 06 08 2019   grade_8                         131.0 126.0                       257.0                         131 126                 257
1788524 1788524 IN     school 1800840 1125   Clay Community Schools 180084000157 897 Clay City Jr-Sr High School   Regular School No High 07 12 2018   grade_8                         32.0 37.0                       69.0                         32 37                 69
1788550 1788550 IN     school 1800840 1125   Clay Community Schools 180084000165 925 North Clay Middle School   Regular School No Middle 06 08 2018   grade_8                         150.0 146.0                       296.0                         150 146                 296
1908212 1908212 IN     school 1800840 1125   Clay Community Schools 180084000157 897 Clay City Jr-Sr High School   Regular School No High 07 12 2020   grade_8                         29.0 29.0                       58.0                         29 29                 58
1908238 1908238 IN     school 1800840 1125   Clay Community Schools 180084000165 925 North Clay Middle School   Regular School No Middle 06 08 2020   grade_8                         139.0 128.0                       267.0                         139 128                 267
1920187 1920187 IN     school 1800840 1125   Clay Community Schools 180084000157 897 Clay City Jr-Sr High School   Regular School No High 07 12 2021   grade_8                         43.0 32.0                       75.0                         43 32                 75
1920213 1920213 IN     school 1800840 1125   Clay Community Schools 180084000165 925 North Clay Middle School   Regular School No Middle 06 08 2021   grade_8                         135.0 115.0                       250.0                         135 115                 250
1160768 1160768 IN     school 1802130 1150   Clinton Central School Corp 180213000257 957 Clinton Central Junior-Senior HS   Regular School No 3.0 07 12 2015   grade_8                         45.0 31.0                       76.0                         45 31                 76
1282170 1282170 IN     school 1802130 1150   Clinton Central School Corp 180213000257 957 Clinton Central Junior-Senior HS   Regular School No 3.0 07 12 2016   grade_8                         33.0 47.0                       80.0                         33 47                 80
1294228 1294228 IN     school 1802130 1150   Clinton Central School Corporation 180213000257 957 Clinton Central Junior-Senior HS   Regular School No High 07 12 2017   grade_8                         43.0 36.0                       79.0                         43 36                 79
1752844 1752844 IN     school 1802130 1150   Clinton Central School Corporation 180213000257 957 Clinton Central Junior-Senior HS   Regular School No High 07 12 2019   grade_8                         38.0 34.0                       72.0                         38 34                 72
1788585 1788585 IN     school 1802130 1150   Clinton Central School Corporation 180213000257 957 Clinton Central Junior-Senior HS   Regular School No High 07 12 2018   grade_8                         42.0 41.0                       83.0                         42 41                 83
1908273 1908273 IN     school 1802130 1150   Clinton Central School Corporation 180213000257 957 Clinton Central Junior-Senior HS   Regular School No High 07 12 2020   grade_8                         37.0 40.0                       77.0                         37 40                 77
1920248 1920248 IN     school 1802130 1150   Clinton Central School Corporation 180213000257 957 Clinton Central Junior-Senior HS   Regular School No High 07 12 2021   grade_8                         36.0 32.0                       68.0                         36 32                 68
1160784 1160784 IN     school 1802160 1160   Clinton Prairie School Corp 180216000258 977 Clinton Prairie Jr-Sr HS   Regular School No 3.0 07 12 2015   grade_8                         36.0 54.0                       90.0                         36 54                 90
1282186 1282186 IN     school 1802160 1160   Clinton Prairie School Corp 180216000258 977 Clinton Prairie Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_8                         45.0 53.0                       98.0                         45 53                 98
1294243 1294243 IN     school 1802160 1160   Clinton Prairie School Corporation 180216000258 977 Clinton Prairie Jr-Sr High School   Regular School No High 07 12 2017   grade_8                         44.0 41.0                       85.0                         44 41                 85
1752859 1752859 IN     school 1802160 1160   Clinton Prairie School Corporation 180216000258 977 Clinton Prairie Jr-Sr High School   Regular School No High 07 12 2019   grade_8                         41.0 50.0                       91.0                         41 50                 91
1788600 1788600 IN     school 1802160 1160   Clinton Prairie School Corporation 180216000258 977 Clinton Prairie Jr-Sr High School   Regular School No High 07 12 2018   grade_8                         57.0 47.0                       104.0                         57 47                 104
1908288 1908288 IN     school 1802160 1160   Clinton Prairie School Corporation 180216000258 977 Clinton Prairie Jr-Sr High School   Regular School No High 07 12 2020   grade_8                         55.0 54.0                       109.0                         55 54                 109
1920264 1920264 IN     school 1802160 1160   Clinton Prairie School Corporation 180216000258 977 Clinton Prairie Jr-Sr High School   Regular School No High 07 12 2021   grade_8                         43.0 43.0                       86.0                         43 43                 86
1160802 1160802 IN     school 1803660 1170   Community Schools of Frankfort 180366000573 999 Frankfort Middle School   Regular School No 2.0 06 08 2015   grade_8                         126.0 138.0                       264.0                         126 138                 264
1282205 1282205 IN     school 1803660 1170   Community Schools of Frankfort 180366000573 999 Frankfort Middle School   Regular School No 2.0 06 08 2016   grade_8                         119.0 108.0                       227.0                         119 108                 227
1294262 1294262 IN     school 1803660 1170   Community Schools of Frankfort 180366000573 999 Frankfort Middle School   Regular School No Middle 06 08 2017   grade_8                         118.0 128.0                       246.0                         118 128                 246
1752878 1752878 IN     school 1803660 1170   Community Schools of Frankfort 180366000573 999 Frankfort Middle School   Regular School No Middle 06 08 2019   grade_8                         126.0 117.0                       243.0                         126 117                 243
1788619 1788619 IN     school 1803660 1170   Community Schools of Frankfort 180366000573 999 Frankfort Middle School   Regular School No Middle 06 08 2018   grade_8                         118.0 95.0                       213.0                         118 95                 213
1908307 1908307 IN     school 1803660 1170   Community Schools of Frankfort 180366000573 999 Frankfort Middle School   Regular School No Middle 06 08 2020   grade_8                         122.0 119.0                       241.0                         122 119                 241
1920283 1920283 IN     school 1803660 1170   Community Schools of Frankfort 180366000573 999 Frankfort Middle School   Regular School No Middle 06 08 2021   grade_8                         140.0 128.0                       268.0                         140 128                 268
1160826 1160826 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No 4.0 06 12 2015   grade_8                         35.0 47.0                       82.0                         35 47                 82
1282229 1282229 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No 4.0 06 12 2016   grade_8                         41.0 44.0                       85.0                         41 44                 85
1294286 1294286 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No Other 06 12 2017   grade_8                         50.0 41.0                       91.0                         50 41                 91
1752903 1752903 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No High 06 12 2019   grade_8                         23.0 32.0                       55.0                         23 32                 55
1788644 1788644 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No High 06 12 2018   grade_8                         43.0 40.0                       83.0                         43 40                 83
1908332 1908332 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No High 06 12 2020   grade_8                         35.0 43.0                       78.0                         35 43                 78
1920308 1920308 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No High 06 12 2021   grade_8                         39.0 30.0                       69.0                         39 30                 69
1159537 1159537 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No 2.0 06 08 2015   grade_8                         134.0 109.0                       243.0                         134 109                 243
1159548 1159548 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No 2.0 06 08 2015   grade_8                         157.0 171.0                       328.0                         157 171                 328
1280927 1280927 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No 2.0 06 08 2016   grade_8                         125.0 112.0                       237.0                         125 112                 237
1280938 1280938 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No 2.0 06 08 2016   grade_8                         165.0 154.0                       319.0                         165 154                 319
1292989 1292989 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No Middle 06 08 2017   grade_8                         122.0 108.0                       230.0                         122 108                 230
1293000 1293000 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2017   grade_8                         171.0 169.0                       340.0                         171 169                 340
1751621 1751621 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No Middle 06 08 2019   grade_8                         116.0 118.0                       234.0                         116 118                 234
1751632 1751632 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2019   grade_8                         182.0 163.0                       345.0                         182 163                 345
1787362 1787362 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No Middle 06 08 2018   grade_8                         132.0 118.0                       250.0                         132 118                 250

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