enrollments

Data source: Big Local News · About: Big Local

2,960 rows where grade = "grade_11" and state = "IN" sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_11 · 2,960 ✖
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
1160542 1160542 IN     school 1801920 1000   Clarksville Com School Corp 180192000249 833 Clarksville Senior High Sch   Regular School No 3.0 09 12 2015   grade_11                         44.0 63.0                       107.0                         44 63                 107
1281937 1281937 IN     school 1801920 1000   Clarksville Com School Corp 180192000249 833 Clarksville Senior High School   Regular School No 3.0 09 12 2016   grade_11                         54.0 44.0                       98.0                         54 44                 98
1293995 1293995 IN     school 1801920 1000   Clarksville Community School Corp 180192000249 833 Clarksville Senior High School   Regular School No High 09 12 2017   grade_11                         64.0 58.0                       122.0                         64 58                 122
1752622 1752622 IN     school 1801920 1000   Clarksville Community School Corp 180192000249 833 Clarksville Senior High School   Regular School No High 09 12 2019   grade_11                         61.0 58.0                       119.0                         61 58                 119
1788361 1788361 IN     school 1801920 1000   Clarksville Community School Corp 180192000249 833 Clarksville Senior High School   Regular School No High 09 12 2018   grade_11                         61.0 45.0                       106.0                         61 45                 106
1908061 1908061 IN     school 1801920 1000   Clarksville Community School Corp 180192000249 833 Clarksville Senior High School   Regular School No High 09 12 2020   grade_11                         47.0 49.0                       96.0                         47 49                 96
1920026 1920026 IN     school 1801920 1000   Clarksville Community School Corp 180192000249 833 Clarksville Senior High School   Regular School No High 09 12 2021   grade_11                         56.0 55.0                       111.0                         56 55                 111
1920044 1920044 IN     school 1801920 1000   Clarksville Community School Corp 180192002690 1007 Indiana Gateway Digital Academy   Regular School No Other KG 12 2021   grade_11                         100.0 123.0                       223.0                         100 123                 223
1160596 1160596 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No 4.0 06 12 2015   grade_11                         33.0 27.0                       60.0                         33 27                 60
1160604 1160604 IN     school 1803940 1010   Greater Clark County Schools 180394000663 821 Charlestown Senior High Sch   Regular School No 3.0 09 12 2015   grade_11                         97.0 82.0                       179.0                         97 82                 179
1160623 1160623 IN     school 1803940 1010   Greater Clark County Schools 180394000666 849 Jeffersonville High School   Regular School No 3.0 09 12 2015   grade_11                         257.0 238.0                       495.0                         257 238                 495
1160678 1160678 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 04 12 2015   grade_11                         10.0 1.0                       11.0                         10 1                 11
1160688 1160688 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_11                         11.0 5.0                       16.0                         11 5                 16
1281994 1281994 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No 4.0 06 12 2016   grade_11                         30.0 35.0                       65.0                         30 35                 65
1282002 1282002 IN     school 1803940 1010   Greater Clark County Schools 180394000663 821 Charlestown Senior High School   Regular School No 3.0 09 12 2016   grade_11                         88.0 78.0                       166.0                         88 78                 166
1282023 1282023 IN     school 1803940 1010   Greater Clark County Schools 180394000666 849 Jeffersonville High School   Regular School No 3.0 09 12 2016   grade_11                         242.0 234.0                       476.0                         242 234                 476
1282080 1282080 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 05 12 2016   grade_11                         9.0 2.0                       11.0                         9 2                 11
1282089 1282089 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_11                         11.0 12.0                       23.0                         11 12                 23
1294052 1294052 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No Other 06 12 2017   grade_11                         17.0 25.0                       42.0                         17 25                 42
1294060 1294060 IN     school 1803940 1010   Greater Clark County Schools 180394000663 821 Charlestown Senior High School   Regular School No High 09 12 2017   grade_11                         96.0 85.0                       181.0                         96 85                 181
1294081 1294081 IN     school 1803940 1010   Greater Clark County Schools 180394000666 849 Jeffersonville High School   Regular School No High 09 12 2017   grade_11                         252.0 285.0                       537.0                         252 285                 537
1294138 1294138 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No Other 04 12 2017   grade_11                         9.0 0.0                       9.0                         9 0                 9
1294148 1294148 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No Other 06 12 2017   grade_11                         24.0 16.0                       40.0                         24 16                 40
1752679 1752679 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No High 06 12 2019   grade_11                         29.0 20.0                       49.0                         29 20                 49
1752687 1752687 IN     school 1803940 1010   Greater Clark County Schools 180394000663 821 Charlestown Senior High School   Regular School No High 09 12 2019   grade_11                         91.0 74.0                       165.0                         91 74                 165
1752701 1752701 IN     school 1803940 1010   Greater Clark County Schools 180394000666 849 Jeffersonville High School   Regular School No High 09 12 2019   grade_11                         275.0 223.0                       498.0                         275 223                 498
1752757 1752757 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No High 06 12 2019   grade_11                         6.0 2.0                       8.0                         6 2                 8
1752765 1752765 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No High 07 12 2019   grade_11                         10.0 3.0                       13.0                         10 3                 13
1788418 1788418 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No High 06 12 2018   grade_11                         31.0 29.0                       60.0                         31 29                 60
1788426 1788426 IN     school 1803940 1010   Greater Clark County Schools 180394000663 821 Charlestown Senior High School   Regular School No High 09 12 2018   grade_11                         99.0 77.0                       176.0                         99 77                 176
1788440 1788440 IN     school 1803940 1010   Greater Clark County Schools 180394000666 849 Jeffersonville High School   Regular School No High 09 12 2018   grade_11                         276.0 249.0                       525.0                         276 249                 525
1788497 1788497 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No High 05 12 2018   grade_11                         7.0 1.0                       8.0                         7 1                 8
1788506 1788506 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No High 07 12 2018   grade_11                         17.0 6.0                       23.0                         17 6                 23
1908115 1908115 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No High 06 12 2020   grade_11                         20.0 20.0                       40.0                         20 20                 40
1908123 1908123 IN     school 1803940 1010   Greater Clark County Schools 180394000663 821 Charlestown Senior High School   Regular School No High 09 12 2020   grade_11                         92.0 96.0                       188.0                         92 96                 188
1908137 1908137 IN     school 1803940 1010   Greater Clark County Schools 180394000666 849 Jeffersonville High School   Regular School No High 09 12 2020   grade_11                         259.0 235.0                       494.0                         259 235                 494
1908193 1908193 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No High 06 12 2020   grade_11                         6.0 2.0                       8.0                         6 2                 8
1920097 1920097 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No High 06 12 2021   grade_11                         21.0 23.0                       44.0                         21 23                 44
1920105 1920105 IN     school 1803940 1010   Greater Clark County Schools 180394000663 821 Charlestown Senior High School   Regular School No High 09 12 2021   grade_11                         94.0 78.0                       172.0                         94 78                 172
1920119 1920119 IN     school 1803940 1010   Greater Clark County Schools 180394000666 849 Jeffersonville High School   Regular School No High 09 12 2021   grade_11                         284.0 242.0                       526.0                         284 242                 526
1920168 1920168 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No High 06 12 2021   grade_11                         8.0 0.0                       8.0                         8 0                 8
1160703 1160703 IN     school 1800840 1125   Clay Community Schools 180084000157 897 Clay City Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_11                         24.0 36.0                       60.0                         24 36                 60
1160735 1160735 IN     school 1800840 1125   Clay Community Schools 180084000154 933 Northview High School   Regular School No 3.0 09 12 2015   grade_11                         128.0 124.0                       252.0                         128 124                 252
1282105 1282105 IN     school 1800840 1125   Clay Community Schools 180084000157 897 Clay City Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_11                         36.0 28.0                       64.0                         36 28                 64
1282137 1282137 IN     school 1800840 1125   Clay Community Schools 180084000154 933 Northview High School   Regular School No 3.0 09 12 2016   grade_11                         127.0 134.0                       261.0                         127 134                 261
1294164 1294164 IN     school 1800840 1125   Clay Community Schools 180084000157 897 Clay City Jr-Sr High School   Regular School No High 07 12 2017   grade_11                         28.0 36.0                       64.0                         28 36                 64
1294196 1294196 IN     school 1800840 1125   Clay Community Schools 180084000154 933 Northview High School   Regular School No High 09 12 2017   grade_11                         106.0 130.0                       236.0                         106 130                 236
1752780 1752780 IN     school 1800840 1125   Clay Community Schools 180084000157 897 Clay City Jr-Sr High School   Regular School No High 07 12 2019   grade_11                         30.0 35.0                       65.0                         30 35                 65
1752812 1752812 IN     school 1800840 1125   Clay Community Schools 180084000154 933 Northview High School   Regular School No High 09 12 2019   grade_11                         124.0 118.0                       242.0                         124 118                 242
1788521 1788521 IN     school 1800840 1125   Clay Community Schools 180084000157 897 Clay City Jr-Sr High School   Regular School No High 07 12 2018   grade_11                         18.0 35.0                       53.0                         18 35                 53
1788553 1788553 IN     school 1800840 1125   Clay Community Schools 180084000154 933 Northview High School   Regular School No High 09 12 2018   grade_11                         125.0 124.0                       249.0                         125 124                 249
1908209 1908209 IN     school 1800840 1125   Clay Community Schools 180084000157 897 Clay City Jr-Sr High School   Regular School No High 07 12 2020   grade_11                         31.0 31.0                       62.0                         31 31                 62
1908241 1908241 IN     school 1800840 1125   Clay Community Schools 180084000154 933 Northview High School   Regular School No High 09 12 2020   grade_11                         115.0 116.0                       231.0                         115 116                 231
1920184 1920184 IN     school 1800840 1125   Clay Community Schools 180084000157 897 Clay City Jr-Sr High School   Regular School No High 07 12 2021   grade_11                         33.0 38.0                       71.0                         33 38                 71
1920216 1920216 IN     school 1800840 1125   Clay Community Schools 180084000154 933 Northview High School   Regular School No High 09 12 2021   grade_11                         129.0 126.0                       255.0                         129 126                 255
1160765 1160765 IN     school 1802130 1150   Clinton Central School Corp 180213000257 957 Clinton Central Junior-Senior HS   Regular School No 3.0 07 12 2015   grade_11                         38.0 37.0                       75.0                         38 37                 75
1282167 1282167 IN     school 1802130 1150   Clinton Central School Corp 180213000257 957 Clinton Central Junior-Senior HS   Regular School No 3.0 07 12 2016   grade_11                         43.0 28.0                       71.0                         43 28                 71
1294225 1294225 IN     school 1802130 1150   Clinton Central School Corporation 180213000257 957 Clinton Central Junior-Senior HS   Regular School No High 07 12 2017   grade_11                         37.0 23.0                       60.0                         37 23                 60
1752841 1752841 IN     school 1802130 1150   Clinton Central School Corporation 180213000257 957 Clinton Central Junior-Senior HS   Regular School No High 07 12 2019   grade_11                         27.0 41.0                       68.0                         27 41                 68
1788582 1788582 IN     school 1802130 1150   Clinton Central School Corporation 180213000257 957 Clinton Central Junior-Senior HS   Regular School No High 07 12 2018   grade_11                         37.0 28.0                       65.0                         37 28                 65
1908270 1908270 IN     school 1802130 1150   Clinton Central School Corporation 180213000257 957 Clinton Central Junior-Senior HS   Regular School No High 07 12 2020   grade_11                         37.0 28.0                       65.0                         37 28                 65
1920245 1920245 IN     school 1802130 1150   Clinton Central School Corporation 180213000257 957 Clinton Central Junior-Senior HS   Regular School No High 07 12 2021   grade_11                         35.0 36.0                       71.0                         35 36                 71
1160781 1160781 IN     school 1802160 1160   Clinton Prairie School Corp 180216000258 977 Clinton Prairie Jr-Sr HS   Regular School No 3.0 07 12 2015   grade_11                         37.0 42.0                       79.0                         37 42                 79
1282183 1282183 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_11                         29.0 50.0                       79.0                         29 50                 79
1294240 1294240 IN     school 1802160 1160   Clinton Prairie School Corporation 180216000258 977 Clinton Prairie Jr-Sr High School   Regular School No High 07 12 2017   grade_11                         34.0 36.0                       70.0                         34 36                 70
1752856 1752856 IN     school 1802160 1160   Clinton Prairie School Corporation 180216000258 977 Clinton Prairie Jr-Sr High School   Regular School No High 07 12 2019   grade_11                         44.0 44.0                       88.0                         44 44                 88
1788597 1788597 IN     school 1802160 1160   Clinton Prairie School Corporation 180216000258 977 Clinton Prairie Jr-Sr High School   Regular School No High 07 12 2018   grade_11                         42.0 50.0                       92.0                         42 50                 92
1908285 1908285 IN     school 1802160 1160   Clinton Prairie School Corporation 180216000258 977 Clinton Prairie Jr-Sr High School   Regular School No High 07 12 2020   grade_11                         42.0 36.0                       78.0                         42 36                 78
1920261 1920261 IN     school 1802160 1160   Clinton Prairie School Corporation 180216000258 977 Clinton Prairie Jr-Sr High School   Regular School No High 07 12 2021   grade_11                         55.0 41.0                       96.0                         55 41                 96
1160796 1160796 IN     school 1803660 1170   Community Schools of Frankfort 180366000574 997 Frankfort Senior High School   Regular School No 3.0 09 12 2015   grade_11                         116.0 111.0                       227.0                         116 111                 227
1282199 1282199 IN     school 1803660 1170   Community Schools of Frankfort 180366000574 997 Frankfort Senior High School   Regular School No 3.0 09 12 2016   grade_11                         90.0 89.0                       179.0                         90 89                 179
1294256 1294256 IN     school 1803660 1170   Community Schools of Frankfort 180366000574 997 Frankfort Senior High School   Regular School No High 09 12 2017   grade_11                         112.0 106.0                       218.0                         112 106                 218
1752872 1752872 IN     school 1803660 1170   Community Schools of Frankfort 180366000574 997 Frankfort High School   Regular School No High 09 12 2019   grade_11                         104.0 103.0                       207.0                         104 103                 207
1788613 1788613 IN     school 1803660 1170   Community Schools of Frankfort 180366000574 997 Frankfort High School   Regular School No High 09 12 2018   grade_11                         120.0 132.0                       252.0                         120 132                 252
1908301 1908301 IN     school 1803660 1170   Community Schools of Frankfort 180366000574 997 Frankfort High School   Regular School No High 09 12 2020   grade_11                         109.0 117.0                       226.0                         109 117                 226
1920277 1920277 IN     school 1803660 1170   Community Schools of Frankfort 180366000574 997 Frankfort High School   Regular School No High 09 12 2021   grade_11                         122.0 101.0                       223.0                         122 101                 223
1160822 1160822 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No 4.0 06 12 2015   grade_11                         40.0 38.0                       78.0                         40 38                 78
1282225 1282225 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No 4.0 06 12 2016   grade_11                         47.0 39.0                       86.0                         47 39                 86
1294282 1294282 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No Other 06 12 2017   grade_11                         28.0 46.0                       74.0                         28 46                 74
1752899 1752899 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No High 06 12 2019   grade_11                         40.0 37.0                       77.0                         40 37                 77
1788640 1788640 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No High 06 12 2018   grade_11                         36.0 39.0                       75.0                         36 39                 75
1908328 1908328 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No High 06 12 2020   grade_11                         48.0 40.0                       88.0                         48 40                 88
1920304 1920304 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No High 06 12 2021   grade_11                         39.0 38.0                       77.0                         39 38                 77
1159531 1159531 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No 3.0 09 12 2015   grade_11                         287.0 285.0                       572.0                         287 285                 572
1280921 1280921 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No 3.0 09 12 2016   grade_11                         294.0 298.0                       592.0                         294 298                 592
1292983 1292983 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2017   grade_11                         292.0 279.0                       571.0                         292 279                 571
1751615 1751615 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2019   grade_11                         289.0 297.0                       586.0                         289 297                 586
1787356 1787356 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2018   grade_11                         291.0 301.0                       592.0                         291 301                 592
1907056 1907056 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2020   grade_11                         299.0 287.0                       586.0                         299 287                 586
1919022 1919022 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2021   grade_11                         334.0 324.0                       658.0                         334 324                 658
1160865 1160865 IN     school 1802440 1300   Crawford Co Com School Corp 180244000279 1059 Crawford County Jr-Sr HS   Regular School No 3.0 07 12 2015   grade_11                         61.0 51.0                       112.0                         61 51                 112
1282267 1282267 IN     school 1802440 1300   Crawford Co Com School Corp 180244000279 1059 Crawford County Jr-Sr HS   Regular School No 3.0 07 12 2016   grade_11                         66.0 61.0                       127.0                         66 61                 127
1294313 1294313 IN     school 1802440 1300   Crawford County Community Sch Corp 180244000279 1059 Crawford County High School   Regular School No High 09 12 2017   grade_11                         77.0 40.0                       117.0                         77 40                 117
1752930 1752930 IN     school 1802440 1300   Crawford County Community Sch Corp 180244000279 1059 Crawford County High School   Regular School No High 09 12 2019   grade_11                         61.0 62.0                       123.0                         61 62                 123
1788671 1788671 IN     school 1802440 1300   Crawford County Community Sch Corp 180244000279 1059 Crawford County High School   Regular School No High 09 12 2018   grade_11                         52.0 55.0                       107.0                         52 55                 107
1908361 1908361 IN     school 1802440 1300   Crawford County Community Sch Corp 180244000279 1059 Crawford County High School   Regular School No High 09 12 2020   grade_11                         54.0 51.0                       105.0                         54 51                 105
1920336 1920336 IN     school 1802440 1300   Crawford County Community Sch Corp 180244000279 1059 Crawford County High School   Regular School No High 09 12 2021   grade_11                         55.0 53.0                       108.0                         55 53                 108
1160890 1160890 IN     school 1800330 1315   Barr-Reeve Com Schools Inc 180033000061 1069 Barr Reeve Middle/High School   Regular School No 4.0 06 12 2015   grade_11                         30.0 19.0                       49.0                         30 19                 49
1282292 1282292 IN     school 1800330 1315   Barr-Reeve Com Schools Inc 180033000061 1069 Barr Reeve Middle/High School   Regular School No 4.0 06 12 2016   grade_11                         31.0 26.0                       57.0                         31 26                 57
1294330 1294330 IN     school 1800330 1315   Barr-Reeve Community Schools Inc 180033000061 1069 Barr Reeve Middle/High School   Regular School No Other 06 12 2017   grade_11                         23.0 24.0                       47.0                         23 24                 47

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