enrollments

Data source: Big Local News · About: Big Local

2,939 rows where grade = "grade_10" and state = "IN" sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_10 · 2,939 ✖
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
1160541 1160541 IN     school 1801920 1000   Clarksville Com School Corp 180192000249 833 Clarksville Senior High Sch   Regular School No 3.0 09 12 2015   grade_10                         64.0 45.0                       109.0                         64 45                 109
1281936 1281936 IN     school 1801920 1000   Clarksville Com School Corp 180192000249 833 Clarksville Senior High School   Regular School No 3.0 09 12 2016   grade_10                         70.0 70.0                       140.0                         70 70                 140
1293994 1293994 IN     school 1801920 1000   Clarksville Community School Corp 180192000249 833 Clarksville Senior High School   Regular School No High 09 12 2017   grade_10                         63.0 49.0                       112.0                         63 49                 112
1752621 1752621 IN     school 1801920 1000   Clarksville Community School Corp 180192000249 833 Clarksville Senior High School   Regular School No High 09 12 2019   grade_10                         50.0 47.0                       97.0                         50 47                 97
1788360 1788360 IN     school 1801920 1000   Clarksville Community School Corp 180192000249 833 Clarksville Senior High School   Regular School No High 09 12 2018   grade_10                         64.0 62.0                       126.0                         64 62                 126
1908060 1908060 IN     school 1801920 1000   Clarksville Community School Corp 180192000249 833 Clarksville Senior High School   Regular School No High 09 12 2020   grade_10                         69.0 61.0                       130.0                         69 61                 130
1920025 1920025 IN     school 1801920 1000   Clarksville Community School Corp 180192000249 833 Clarksville Senior High School   Regular School No High 09 12 2021   grade_10                         41.0 40.0                       81.0                         41 40                 81
1920043 1920043 IN     school 1801920 1000   Clarksville Community School Corp 180192002690 1007 Indiana Gateway Digital Academy   Regular School No Other KG 12 2021   grade_10                         86.0 90.0                       176.0                         86 90                 176
1160595 1160595 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No 4.0 06 12 2015   grade_10                         33.0 34.0                       67.0                         33 34                 67
1160603 1160603 IN     school 1803940 1010   Greater Clark County Schools 180394000663 821 Charlestown Senior High Sch   Regular School No 3.0 09 12 2015   grade_10                         86.0 75.0                       161.0                         86 75                 161
1160622 1160622 IN     school 1803940 1010   Greater Clark County Schools 180394000666 849 Jeffersonville High School   Regular School No 3.0 09 12 2015   grade_10                         256.0 255.0                       511.0                         256 255                 511
1160677 1160677 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 04 12 2015   grade_10                         11.0 1.0                       12.0                         11 1                 12
1160687 1160687 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_10                         9.0 8.0                       17.0                         9 8                 17
1281993 1281993 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No 4.0 06 12 2016   grade_10                         20.0 34.0                       54.0                         20 34                 54
1282001 1282001 IN     school 1803940 1010   Greater Clark County Schools 180394000663 821 Charlestown Senior High School   Regular School No 3.0 09 12 2016   grade_10                         98.0 89.0                       187.0                         98 89                 187
1282022 1282022 IN     school 1803940 1010   Greater Clark County Schools 180394000666 849 Jeffersonville High School   Regular School No 3.0 09 12 2016   grade_10                         280.0 279.0                       559.0                         280 279                 559
1282079 1282079 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 05 12 2016   grade_10                         6.0 1.0                       7.0                         6 1                 7
1282088 1282088 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_10                         10.0 7.0                       17.0                         10 7                 17
1294051 1294051 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No Other 06 12 2017   grade_10                         31.0 33.0                       64.0                         31 33                 64
1294059 1294059 IN     school 1803940 1010   Greater Clark County Schools 180394000663 821 Charlestown Senior High School   Regular School No High 09 12 2017   grade_10                         104.0 78.0                       182.0                         104 78                 182
1294080 1294080 IN     school 1803940 1010   Greater Clark County Schools 180394000666 849 Jeffersonville High School   Regular School No High 09 12 2017   grade_10                         286.0 261.0                       547.0                         286 261                 547
1294137 1294137 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No Other 04 12 2017   grade_10                         10.0 2.0                       12.0                         10 2                 12
1294147 1294147 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No Other 06 12 2017   grade_10                         11.0 6.0                       17.0                         11 6                 17
1752678 1752678 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No High 06 12 2019   grade_10                         20.0 24.0                       44.0                         20 24                 44
1752686 1752686 IN     school 1803940 1010   Greater Clark County Schools 180394000663 821 Charlestown Senior High School   Regular School No High 09 12 2019   grade_10                         95.0 87.0                       182.0                         95 87                 182
1752700 1752700 IN     school 1803940 1010   Greater Clark County Schools 180394000666 849 Jeffersonville High School   Regular School No High 09 12 2019   grade_10                         261.0 245.0                       506.0                         261 245                 506
1752756 1752756 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No High 06 12 2019   grade_10                         6.0 1.0                       7.0                         6 1                 7
1752764 1752764 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No High 07 12 2019   grade_10                         12.0 6.0                       18.0                         12 6                 18
1788417 1788417 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No High 06 12 2018   grade_10                         28.0 26.0                       54.0                         28 26                 54
1788425 1788425 IN     school 1803940 1010   Greater Clark County Schools 180394000663 821 Charlestown Senior High School   Regular School No High 09 12 2018   grade_10                         90.0 70.0                       160.0                         90 70                 160
1788439 1788439 IN     school 1803940 1010   Greater Clark County Schools 180394000666 849 Jeffersonville High School   Regular School No High 09 12 2018   grade_10                         276.0 226.0                       502.0                         276 226                 502
1788496 1788496 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No High 05 12 2018   grade_10                         11.0 6.0                       17.0                         11 6                 17
1788505 1788505 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No High 07 12 2018   grade_10                         10.0 2.0                       12.0                         10 2                 12
1908114 1908114 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No High 06 12 2020   grade_10                         24.0 27.0                       51.0                         24 27                 51
1908122 1908122 IN     school 1803940 1010   Greater Clark County Schools 180394000663 821 Charlestown Senior High School   Regular School No High 09 12 2020   grade_10                         89.0 80.0                       169.0                         89 80                 169
1908136 1908136 IN     school 1803940 1010   Greater Clark County Schools 180394000666 849 Jeffersonville High School   Regular School No High 09 12 2020   grade_10                         288.0 245.0                       533.0                         288 245                 533
1908192 1908192 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No High 06 12 2020   grade_10                         11.0 0.0                       11.0                         11 0                 11
1920096 1920096 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No High 06 12 2021   grade_10                         18.0 24.0                       42.0                         18 24                 42
1920104 1920104 IN     school 1803940 1010   Greater Clark County Schools 180394000663 821 Charlestown Senior High School   Regular School No High 09 12 2021   grade_10                         86.0 99.0                       185.0                         86 99                 185
1920118 1920118 IN     school 1803940 1010   Greater Clark County Schools 180394000666 849 Jeffersonville High School   Regular School No High 09 12 2021   grade_10                         288.0 251.0                       539.0                         288 251                 539
1920167 1920167 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No High 06 12 2021   grade_10                         7.0 2.0                       9.0                         7 2                 9
1160702 1160702 IN     school 1800840 1125   Clay Community Schools 180084000157 897 Clay City Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_10                         29.0 25.0                       54.0                         29 25                 54
1160734 1160734 IN     school 1800840 1125   Clay Community Schools 180084000154 933 Northview High School   Regular School No 3.0 09 12 2015   grade_10                         135.0 145.0                       280.0                         135 145                 280
1282104 1282104 IN     school 1800840 1125   Clay Community Schools 180084000157 897 Clay City Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_10                         28.0 35.0                       63.0                         28 35                 63
1282136 1282136 IN     school 1800840 1125   Clay Community Schools 180084000154 933 Northview High School   Regular School No 3.0 09 12 2016   grade_10                         122.0 140.0                       262.0                         122 140                 262
1294163 1294163 IN     school 1800840 1125   Clay Community Schools 180084000157 897 Clay City Jr-Sr High School   Regular School No High 07 12 2017   grade_10                         24.0 36.0                       60.0                         24 36                 60
1294195 1294195 IN     school 1800840 1125   Clay Community Schools 180084000154 933 Northview High School   Regular School No High 09 12 2017   grade_10                         134.0 129.0                       263.0                         134 129                 263
1752779 1752779 IN     school 1800840 1125   Clay Community Schools 180084000157 897 Clay City Jr-Sr High School   Regular School No High 07 12 2019   grade_10                         31.0 32.0                       63.0                         31 32                 63
1752811 1752811 IN     school 1800840 1125   Clay Community Schools 180084000154 933 Northview High School   Regular School No High 09 12 2019   grade_10                         134.0 127.0                       261.0                         134 127                 261
1788520 1788520 IN     school 1800840 1125   Clay Community Schools 180084000157 897 Clay City Jr-Sr High School   Regular School No High 07 12 2018   grade_10                         33.0 32.0                       65.0                         33 32                 65
1788552 1788552 IN     school 1800840 1125   Clay Community Schools 180084000154 933 Northview High School   Regular School No High 09 12 2018   grade_10                         141.0 129.0                       270.0                         141 129                 270
1908208 1908208 IN     school 1800840 1125   Clay Community Schools 180084000157 897 Clay City Jr-Sr High School   Regular School No High 07 12 2020   grade_10                         35.0 38.0                       73.0                         35 38                 73
1908240 1908240 IN     school 1800840 1125   Clay Community Schools 180084000154 933 Northview High School   Regular School No High 09 12 2020   grade_10                         131.0 130.0                       261.0                         131 130                 261
1920183 1920183 IN     school 1800840 1125   Clay Community Schools 180084000157 897 Clay City Jr-Sr High School   Regular School No High 07 12 2021   grade_10                         29.0 31.0                       60.0                         29 31                 60
1920215 1920215 IN     school 1800840 1125   Clay Community Schools 180084000154 933 Northview High School   Regular School No High 09 12 2021   grade_10                         123.0 125.0                       248.0                         123 125                 248
1160764 1160764 IN     school 1802130 1150   Clinton Central School Corp 180213000257 957 Clinton Central Junior-Senior HS   Regular School No 3.0 07 12 2015   grade_10                         45.0 33.0                       78.0                         45 33                 78
1282166 1282166 IN     school 1802130 1150   Clinton Central School Corp 180213000257 957 Clinton Central Junior-Senior HS   Regular School No 3.0 07 12 2016   grade_10                         38.0 24.0                       62.0                         38 24                 62
1294224 1294224 IN     school 1802130 1150   Clinton Central School Corporation 180213000257 957 Clinton Central Junior-Senior HS   Regular School No High 07 12 2017   grade_10                         39.0 30.0                       69.0                         39 30                 69
1752840 1752840 IN     school 1802130 1150   Clinton Central School Corporation 180213000257 957 Clinton Central Junior-Senior HS   Regular School No High 07 12 2019   grade_10                         40.0 27.0                       67.0                         40 27                 67
1788581 1788581 IN     school 1802130 1150   Clinton Central School Corporation 180213000257 957 Clinton Central Junior-Senior HS   Regular School No High 07 12 2018   grade_10                         28.0 44.0                       72.0                         28 44                 72
1908269 1908269 IN     school 1802130 1150   Clinton Central School Corporation 180213000257 957 Clinton Central Junior-Senior HS   Regular School No High 07 12 2020   grade_10                         39.0 38.0                       77.0                         39 38                 77
1920244 1920244 IN     school 1802130 1150   Clinton Central School Corporation 180213000257 957 Clinton Central Junior-Senior HS   Regular School No High 07 12 2021   grade_10                         36.0 27.0                       63.0                         36 27                 63
1160780 1160780 IN     school 1802160 1160   Clinton Prairie School Corp 180216000258 977 Clinton Prairie Jr-Sr HS   Regular School No 3.0 07 12 2015   grade_10                         31.0 51.0                       82.0                         31 51                 82
1282182 1282182 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_10                         37.0 33.0                       70.0                         37 33                 70
1294239 1294239 IN     school 1802160 1160   Clinton Prairie School Corporation 180216000258 977 Clinton Prairie Jr-Sr High School   Regular School No High 07 12 2017   grade_10                         39.0 51.0                       90.0                         39 51                 90
1752855 1752855 IN     school 1802160 1160   Clinton Prairie School Corporation 180216000258 977 Clinton Prairie Jr-Sr High School   Regular School No High 07 12 2019   grade_10                         41.0 41.0                       82.0                         41 41                 82
1788596 1788596 IN     school 1802160 1160   Clinton Prairie School Corporation 180216000258 977 Clinton Prairie Jr-Sr High School   Regular School No High 07 12 2018   grade_10                         45.0 51.0                       96.0                         45 51                 96
1908284 1908284 IN     school 1802160 1160   Clinton Prairie School Corporation 180216000258 977 Clinton Prairie Jr-Sr High School   Regular School No High 07 12 2020   grade_10                         56.0 45.0                       101.0                         56 45                 101
1920260 1920260 IN     school 1802160 1160   Clinton Prairie School Corporation 180216000258 977 Clinton Prairie Jr-Sr High School   Regular School No High 07 12 2021   grade_10                         39.0 52.0                       91.0                         39 52                 91
1160795 1160795 IN     school 1803660 1170   Community Schools of Frankfort 180366000574 997 Frankfort Senior High School   Regular School No 3.0 09 12 2015   grade_10                         101.0 87.0                       188.0                         101 87                 188
1282198 1282198 IN     school 1803660 1170   Community Schools of Frankfort 180366000574 997 Frankfort Senior High School   Regular School No 3.0 09 12 2016   grade_10                         119.0 107.0                       226.0                         119 107                 226
1294255 1294255 IN     school 1803660 1170   Community Schools of Frankfort 180366000574 997 Frankfort Senior High School   Regular School No High 09 12 2017   grade_10                         121.0 134.0                       255.0                         121 134                 255
1752871 1752871 IN     school 1803660 1170   Community Schools of Frankfort 180366000574 997 Frankfort High School   Regular School No High 09 12 2019   grade_10                         115.0 118.0                       233.0                         115 118                 233
1788612 1788612 IN     school 1803660 1170   Community Schools of Frankfort 180366000574 997 Frankfort High School   Regular School No High 09 12 2018   grade_10                         114.0 108.0                       222.0                         114 108                 222
1908300 1908300 IN     school 1803660 1170   Community Schools of Frankfort 180366000574 997 Frankfort High School   Regular School No High 09 12 2020   grade_10                         124.0 103.0                       227.0                         124 103                 227
1920276 1920276 IN     school 1803660 1170   Community Schools of Frankfort 180366000574 997 Frankfort High School   Regular School No High 09 12 2021   grade_10                         118.0 105.0                       223.0                         118 105                 223
1160821 1160821 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No 4.0 06 12 2015   grade_10                         45.0 40.0                       85.0                         45 40                 85
1282224 1282224 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No 4.0 06 12 2016   grade_10                         30.0 48.0                       78.0                         30 48                 78
1294281 1294281 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No Other 06 12 2017   grade_10                         32.0 40.0                       72.0                         32 40                 72
1752898 1752898 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No High 06 12 2019   grade_10                         49.0 40.0                       89.0                         49 40                 89
1788639 1788639 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No High 06 12 2018   grade_10                         43.0 39.0                       82.0                         43 39                 82
1908327 1908327 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No High 06 12 2020   grade_10                         42.0 41.0                       83.0                         42 41                 83
1920303 1920303 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No High 06 12 2021   grade_10                         23.0 32.0                       55.0                         23 32                 55
1159530 1159530 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_10                         291.0 296.0                       587.0                         291 296                 587
1280920 1280920 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_10                         283.0 282.0                       565.0                         283 282                 565
1292982 1292982 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_10                         298.0 300.0                       598.0                         298 300                 598
1751614 1751614 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_10                         299.0 281.0                       580.0                         299 281                 580
1787355 1787355 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_10                         293.0 295.0                       588.0                         293 295                 588
1907055 1907055 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_10                         339.0 334.0                       673.0                         339 334                 673
1919021 1919021 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2021   grade_10                         326.0 309.0                       635.0                         326 309                 635
1160864 1160864 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_10                         64.0 61.0                       125.0                         64 61                 125
1282266 1282266 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_10                         81.0 38.0                       119.0                         81 38                 119
1294312 1294312 IN     school 1802440 1300   Crawford County Community Sch Corp 180244000279 1059 Crawford County High School   Regular School No High 09 12 2017   grade_10                         53.0 56.0                       109.0                         53 56                 109
1752929 1752929 IN     school 1802440 1300   Crawford County Community Sch Corp 180244000279 1059 Crawford County High School   Regular School No High 09 12 2019   grade_10                         58.0 49.0                       107.0                         58 49                 107
1788670 1788670 IN     school 1802440 1300   Crawford County Community Sch Corp 180244000279 1059 Crawford County High School   Regular School No High 09 12 2018   grade_10                         58.0 61.0                       119.0                         58 61                 119
1908360 1908360 IN     school 1802440 1300   Crawford County Community Sch Corp 180244000279 1059 Crawford County High School   Regular School No High 09 12 2020   grade_10                         58.0 54.0                       112.0                         58 54                 112
1920335 1920335 IN     school 1802440 1300   Crawford County Community Sch Corp 180244000279 1059 Crawford County High School   Regular School No High 09 12 2021   grade_10                         53.0 56.0                       109.0                         53 56                 109
1160889 1160889 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_10                         31.0 25.0                       56.0                         31 25                 56
1282291 1282291 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_10                         21.0 19.0                       40.0                         21 19                 40
1294329 1294329 IN     school 1800330 1315   Barr-Reeve Community Schools Inc 180033000061 1069 Barr Reeve Middle/High School   Regular School No Other 06 12 2017   grade_10                         25.0 22.0                       47.0                         25 22                 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]);