enrollments

Data source: Big Local News · About: Big Local

4,822 rows where grade = "grade_6" and state = "IN" sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_6 · 4,822 ✖
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
1160554 1160554 IN     school 1801920 1000   Clarksville Com School Corp 180192000248 851 Clarksville Middle School   Regular School No 2.0 05 08 2015   grade_6                         43.0 46.0                       89.0                         43 46                 89
1281949 1281949 IN     school 1801920 1000   Clarksville Com School Corp 180192000248 851 Clarksville Middle School   Regular School No 2.0 05 08 2016   grade_6                         53.0 51.0                       104.0                         53 51                 104
1294007 1294007 IN     school 1801920 1000   Clarksville Community School Corp 180192000248 851 Clarksville Middle School   Regular School No Middle 05 08 2017   grade_6                         44.0 41.0                       85.0                         44 41                 85
1752634 1752634 IN     school 1801920 1000   Clarksville Community School Corp 180192000248 851 Clarksville Middle School   Regular School No Middle 05 08 2019   grade_6                         47.0 62.0                       109.0                         47 62                 109
1788373 1788373 IN     school 1801920 1000   Clarksville Community School Corp 180192000248 851 Clarksville Middle School   Regular School No Middle 05 08 2018   grade_6                         61.0 36.0                       97.0                         61 36                 97
1908073 1908073 IN     school 1801920 1000   Clarksville Community School Corp 180192000248 851 Clarksville Middle School   Regular School No Middle 05 08 2020   grade_6                         48.0 42.0                       90.0                         48 42                 90
1920038 1920038 IN     school 1801920 1000   Clarksville Community School Corp 180192000248 851 Clarksville Middle School   Regular School No Middle 05 08 2021   grade_6                         35.0 54.0                       89.0                         35 54                 89
1920050 1920050 IN     school 1801920 1000   Clarksville Community School Corp 180192002690 1007 Indiana Gateway Digital Academy   Regular School No Other KG 12 2021   grade_6                         75.0 114.0                       189.0                         75 114                 189
1160598 1160598 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No 4.0 06 12 2015   grade_6                         18.0 27.0                       45.0                         18 27                 45
1160627 1160627 IN     school 1803940 1010   Greater Clark County Schools 180394000674 853 Parkview Middle School   Regular School No 2.0 06 08 2015   grade_6                         124.0 126.0                       250.0                         124 126                 250
1160631 1160631 IN     school 1803940 1010   Greater Clark County Schools 180394002128 863 Charlestown Middle School   Regular School No 2.0 06 08 2015   grade_6                         80.0 94.0                       174.0                         80 94                 174
1160673 1160673 IN     school 1803940 1010   Greater Clark County Schools 180394002131 883 River Valley Middle School   Regular School No 2.0 06 08 2015   grade_6                         145.0 133.0                       278.0                         145 133                 278
1160682 1160682 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 04 12 2015   grade_6                         3.0 1.0                       4.0                         3 1                 4
1281996 1281996 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No 4.0 06 12 2016   grade_6                         23.0 32.0                       55.0                         23 32                 55
1282027 1282027 IN     school 1803940 1010   Greater Clark County Schools 180394000674 853 Parkview Middle School   Regular School No 2.0 06 08 2016   grade_6                         145.0 109.0                       254.0                         145 109                 254
1282031 1282031 IN     school 1803940 1010   Greater Clark County Schools 180394002128 863 Charlestown Middle School   Regular School No 2.0 06 08 2016   grade_6                         92.0 81.0                       173.0                         92 81                 173
1282075 1282075 IN     school 1803940 1010   Greater Clark County Schools 180394002131 883 River Valley Middle School   Regular School No 2.0 06 08 2016   grade_6                         162.0 153.0                       315.0                         162 153                 315
1282083 1282083 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 05 12 2016   grade_6                         5.0 1.0                       6.0                         5 1                 6
1282091 1282091 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_6                         1.0 0.0                       1.0                         1 0                 1
1294054 1294054 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No Other 06 12 2017   grade_6                         18.0 31.0                       49.0                         18 31                 49
1294085 1294085 IN     school 1803940 1010   Greater Clark County Schools 180394000674 853 Parkview Middle School   Regular School No Middle 06 08 2017   grade_6                         111.0 110.0                       221.0                         111 110                 221
1294089 1294089 IN     school 1803940 1010   Greater Clark County Schools 180394002128 863 Charlestown Middle School   Regular School No Middle 06 08 2017   grade_6                         75.0 87.0                       162.0                         75 87                 162
1294133 1294133 IN     school 1803940 1010   Greater Clark County Schools 180394002131 883 River Valley Middle School   Regular School No Middle 06 08 2017   grade_6                         178.0 135.0                       313.0                         178 135                 313
1294142 1294142 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No Other 04 12 2017   grade_6                         2.0 0.0                       2.0                         2 0                 2
1294150 1294150 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No Other 06 12 2017   grade_6                         1.0 0.0                       1.0                         1 0                 1
1752681 1752681 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No High 06 12 2019   grade_6                         18.0 29.0                       47.0                         18 29                 47
1752705 1752705 IN     school 1803940 1010   Greater Clark County Schools 180394000674 853 Parkview Middle School   Regular School No Middle 06 08 2019   grade_6                         141.0 132.0                       273.0                         141 132                 273
1752709 1752709 IN     school 1803940 1010   Greater Clark County Schools 180394002128 863 Charlestown Middle School   Regular School No Middle 06 08 2019   grade_6                         96.0 75.0                       171.0                         96 75                 171
1752752 1752752 IN     school 1803940 1010   Greater Clark County Schools 180394002131 883 River Valley Middle School   Regular School No Middle 06 08 2019   grade_6                         150.0 160.0                       310.0                         150 160                 310
1752759 1752759 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No High 06 12 2019   grade_6                         2.0 0.0                       2.0                         2 0                 2
1788420 1788420 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No High 06 12 2018   grade_6                         28.0 24.0                       52.0                         28 24                 52
1788444 1788444 IN     school 1803940 1010   Greater Clark County Schools 180394000674 853 Parkview Middle School   Regular School No Middle 06 08 2018   grade_6                         105.0 120.0                       225.0                         105 120                 225
1788448 1788448 IN     school 1803940 1010   Greater Clark County Schools 180394002128 863 Charlestown Middle School   Regular School No Middle 06 08 2018   grade_6                         80.0 100.0                       180.0                         80 100                 180
1788492 1788492 IN     school 1803940 1010   Greater Clark County Schools 180394002131 883 River Valley Middle School   Regular School No Middle 06 08 2018   grade_6                         178.0 150.0                       328.0                         178 150                 328
1788500 1788500 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No High 05 12 2018   grade_6                         1.0 0.0                       1.0                         1 0                 1
1908117 1908117 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No High 06 12 2020   grade_6                         23.0 26.0                       49.0                         23 26                 49
1908141 1908141 IN     school 1803940 1010   Greater Clark County Schools 180394000674 853 Parkview Middle School   Regular School No Middle 06 08 2020   grade_6                         142.0 120.0                       262.0                         142 120                 262
1908145 1908145 IN     school 1803940 1010   Greater Clark County Schools 180394002128 863 Charlestown Middle School   Regular School No Middle 06 08 2020   grade_6                         84.0 106.0                       190.0                         84 106                 190
1908188 1908188 IN     school 1803940 1010   Greater Clark County Schools 180394002131 883 River Valley Middle School   Regular School No Middle 06 08 2020   grade_6                         155.0 171.0                       326.0                         155 171                 326
1908195 1908195 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No High 06 12 2020   grade_6                         3.0 0.0                       3.0                         3 0                 3
1920099 1920099 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No High 06 12 2021   grade_6                         17.0 26.0                       43.0                         17 26                 43
1920123 1920123 IN     school 1803940 1010   Greater Clark County Schools 180394000674 853 Parkview Middle School   Regular School No Middle 06 08 2021   grade_6                         146.0 120.0                       266.0                         146 120                 266
1920127 1920127 IN     school 1803940 1010   Greater Clark County Schools 180394002128 863 Charlestown Middle School   Regular School No Middle 06 08 2021   grade_6                         104.0 89.0                       193.0                         104 89                 193
1920163 1920163 IN     school 1803940 1010   Greater Clark County Schools 180394002131 883 River Valley Middle School   Regular School No Middle 06 08 2021   grade_6                         170.0 151.0                       321.0                         170 151                 321
1920170 1920170 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No High 06 12 2021   grade_6                         2.0 0.0                       2.0                         2 0                 2
1160699 1160699 IN     school 1800840 1125   Clay Community Schools 180084000156 895 Clay City Elementary School   Regular School No 1.0 KG 06 2015   grade_6                         27.0 31.0                       58.0                         27 31                 58
1160730 1160730 IN     school 1800840 1125   Clay Community Schools 180084000165 925 North Clay Middle School   Regular School No 2.0 06 08 2015   grade_6                         138.0 148.0                       286.0                         138 148                 286
1282101 1282101 IN     school 1800840 1125   Clay Community Schools 180084000156 895 Clay City Elementary School   Regular School No 1.0 KG 06 2016   grade_6                         31.0 36.0                       67.0                         31 36                 67
1282132 1282132 IN     school 1800840 1125   Clay Community Schools 180084000165 925 North Clay Middle School   Regular School No 2.0 06 08 2016   grade_6                         141.0 139.0                       280.0                         141 139                 280
1294160 1294160 IN     school 1800840 1125   Clay Community Schools 180084000156 895 Clay City Elementary School   Regular School No Elementary KG 06 2017   grade_6                         24.0 31.0                       55.0                         24 31                 55
1294191 1294191 IN     school 1800840 1125   Clay Community Schools 180084000165 925 North Clay Middle School   Regular School No Middle 06 08 2017   grade_6                         123.0 134.0                       257.0                         123 134                 257
1752776 1752776 IN     school 1800840 1125   Clay Community Schools 180084000156 895 Clay City Elementary School   Regular School No Elementary KG 06 2019   grade_6                         41.0 28.0                       69.0                         41 28                 69
1752807 1752807 IN     school 1800840 1125   Clay Community Schools 180084000165 925 North Clay Middle School   Regular School No Middle 06 08 2019   grade_6                         148.0 115.0                       263.0                         148 115                 263
1788517 1788517 IN     school 1800840 1125   Clay Community Schools 180084000156 895 Clay City Elementary School   Regular School No Elementary KG 06 2018   grade_6                         26.0 26.0                       52.0                         26 26                 52
1788548 1788548 IN     school 1800840 1125   Clay Community Schools 180084000165 925 North Clay Middle School   Regular School No Middle 06 08 2018   grade_6                         148.0 124.0                       272.0                         148 124                 272
1908205 1908205 IN     school 1800840 1125   Clay Community Schools 180084000156 895 Clay City Elementary School   Regular School No Elementary KG 06 2020   grade_6                         28.0 31.0                       59.0                         28 31                 59
1908236 1908236 IN     school 1800840 1125   Clay Community Schools 180084000165 925 North Clay Middle School   Regular School No Middle 06 08 2020   grade_6                         130.0 141.0                       271.0                         130 141                 271
1920180 1920180 IN     school 1800840 1125   Clay Community Schools 180084000156 895 Clay City Elementary School   Regular School No Elementary KG 06 2021   grade_6                         46.0 55.0                       101.0                         46 55                 101
1920211 1920211 IN     school 1800840 1125   Clay Community Schools 180084000165 925 North Clay Middle School   Regular School No Middle 06 08 2021   grade_6                         109.0 105.0                       214.0                         109 105                 214
1160776 1160776 IN     school 1802130 1150   Clinton Central School Corp 180213000256 961 Clinton Central Elem School   Regular School No 1.0 PK 06 2015   grade_6                         41.0 36.0                       77.0                         41 36                 77
1282178 1282178 IN     school 1802130 1150   Clinton Central School Corp 180213000256 961 Clinton Central Elementary School   Regular School No 1.0 PK 06 2016   grade_6                         39.0 42.0                       81.0                         39 42                 81
1294236 1294236 IN     school 1802130 1150   Clinton Central School Corporation 180213000256 961 Clinton Central Elementary School   Regular School No Elementary KG 06 2017   grade_6                         35.0 32.0                       67.0                         35 32                 67
1752852 1752852 IN     school 1802130 1150   Clinton Central School Corporation 180213000256 961 Clinton Central Elementary School   Regular School No Elementary KG 06 2019   grade_6                         32.0 37.0                       69.0                         32 37                 69
1788593 1788593 IN     school 1802130 1150   Clinton Central School Corporation 180213000256 961 Clinton Central Elementary School   Regular School No Elementary KG 06 2018   grade_6                         34.0 37.0                       71.0                         34 37                 71
1908281 1908281 IN     school 1802130 1150   Clinton Central School Corporation 180213000256 961 Clinton Central Elementary School   Regular School No Elementary KG 06 2020   grade_6                         42.0 50.0                       92.0                         42 50                 92
1920256 1920256 IN     school 1802130 1150   Clinton Central School Corporation 180213000256 961 Clinton Central Elementary School   Regular School No Elementary PK 06 2021   grade_6                         35.0 26.0                       61.0                         35 26                 61
1160792 1160792 IN     school 1802160 1160   Clinton Prairie School Corp 180216002245 981 Clinton Prairie Elem School   Regular School No 1.0 KG 06 2015   grade_6                         40.0 38.0                       78.0                         40 38                 78
1282194 1282194 IN     school 1802160 1160   Clinton Prairie School Corp 180216002245 981 Clinton Prairie Elementary School   Regular School No 1.0 PK 06 2016   grade_6                         54.0 43.0                       97.0                         54 43                 97
1294251 1294251 IN     school 1802160 1160   Clinton Prairie School Corporation 180216002245 981 Clinton Prairie Elementary School   Regular School No Elementary PK 06 2017   grade_6                         37.0 49.0                       86.0                         37 49                 86
1752867 1752867 IN     school 1802160 1160   Clinton Prairie School Corporation 180216002245 981 Clinton Prairie Elementary School   Regular School No Elementary PK 06 2019   grade_6                         52.0 42.0                       94.0                         52 42                 94
1788608 1788608 IN     school 1802160 1160   Clinton Prairie School Corporation 180216002245 981 Clinton Prairie Elementary School   Regular School No Elementary PK 06 2018   grade_6                         50.0 60.0                       110.0                         50 60                 110
1908296 1908296 IN     school 1802160 1160   Clinton Prairie School Corporation 180216002245 981 Clinton Prairie Elementary School   Regular School No Elementary PK 06 2020   grade_6                         50.0 51.0                       101.0                         50 51                 101
1920272 1920272 IN     school 1802160 1160   Clinton Prairie School Corporation 180216002245 981 Clinton Prairie Elementary School   Regular School No Elementary PK 06 2021   grade_6                         56.0 36.0                       92.0                         56 36                 92
1160800 1160800 IN     school 1803660 1170   Community Schools of Frankfort 180366000573 999 Frankfort Middle School   Regular School No 2.0 06 08 2015   grade_6                         126.0 123.0                       249.0                         126 123                 249
1282203 1282203 IN     school 1803660 1170   Community Schools of Frankfort 180366000573 999 Frankfort Middle School   Regular School No 2.0 06 08 2016   grade_6                         121.0 103.0                       224.0                         121 103                 224
1294260 1294260 IN     school 1803660 1170   Community Schools of Frankfort 180366000573 999 Frankfort Middle School   Regular School No Middle 06 08 2017   grade_6                         125.0 116.0                       241.0                         125 116                 241
1752876 1752876 IN     school 1803660 1170   Community Schools of Frankfort 180366000573 999 Frankfort Middle School   Regular School No Middle 06 08 2019   grade_6                         139.0 128.0                       267.0                         139 128                 267
1788617 1788617 IN     school 1803660 1170   Community Schools of Frankfort 180366000573 999 Frankfort Middle School   Regular School No Middle 06 08 2018   grade_6                         119.0 117.0                       236.0                         119 117                 236
1908305 1908305 IN     school 1803660 1170   Community Schools of Frankfort 180366000573 999 Frankfort Middle School   Regular School No Middle 06 08 2020   grade_6                         126.0 127.0                       253.0                         126 127                 253
1920281 1920281 IN     school 1803660 1170   Community Schools of Frankfort 180366000573 999 Frankfort Middle School   Regular School No Middle 06 08 2021   grade_6                         131.0 123.0                       254.0                         131 123                 254
1160824 1160824 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No 4.0 06 12 2015   grade_6                         51.0 41.0                       92.0                         51 41                 92
1282227 1282227 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No 4.0 06 12 2016   grade_6                         42.0 40.0                       82.0                         42 40                 82
1294284 1294284 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No Other 06 12 2017   grade_6                         25.0 33.0                       58.0                         25 33                 58
1752901 1752901 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No High 06 12 2019   grade_6                         36.0 32.0                       68.0                         36 32                 68
1788642 1788642 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No High 06 12 2018   grade_6                         36.0 45.0                       81.0                         36 45                 81
1908330 1908330 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No High 06 12 2020   grade_6                         41.0 50.0                       91.0                         41 50                 91
1920306 1920306 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No High 06 12 2021   grade_6                         38.0 26.0                       64.0                         38 26                 64
1159535 1159535 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_6                         116.0 104.0                       220.0                         116 104                 220
1159546 1159546 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_6                         171.0 158.0                       329.0                         171 158                 329
1280925 1280925 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_6                         126.0 115.0                       241.0                         126 115                 241
1280936 1280936 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_6                         186.0 183.0                       369.0                         186 183                 369
1292987 1292987 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No Middle 06 08 2017   grade_6                         114.0 114.0                       228.0                         114 114                 228
1292998 1292998 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2017   grade_6                         172.0 152.0                       324.0                         172 152                 324
1751619 1751619 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No Middle 06 08 2019   grade_6                         136.0 113.0                       249.0                         136 113                 249
1751630 1751630 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2019   grade_6                         168.0 169.0                       337.0                         168 169                 337
1787360 1787360 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No Middle 06 08 2018   grade_6                         109.0 119.0                       228.0                         109 119                 228
1787371 1787371 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2018   grade_6                         158.0 178.0                       336.0                         158 178                 336
1907060 1907060 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No Middle 06 08 2020   grade_6                         140.0 136.0                       276.0                         140 136                 276
1907071 1907071 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2020   grade_6                         156.0 163.0                       319.0                         156 163                 319
1919026 1919026 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No Middle 06 08 2021   grade_6                         153.0 122.0                       275.0                         153 122                 275

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