enrollments

Data source: Big Local News · About: Big Local

2,924 rows where grade = "grade_9" and state = "IN" sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_9 · 2,924 ✖
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
1160544 1160544 IN     school 1801920 1000   Clarksville Com School Corp 180192000249 833 Clarksville Senior High Sch   Regular School No 3.0 09 12 2015   grade_9                         75.0 70.0                       145.0                         75 70                 145
1281939 1281939 IN     school 1801920 1000   Clarksville Com School Corp 180192000249 833 Clarksville Senior High School   Regular School No 3.0 09 12 2016   grade_9                         61.0 54.0                       115.0                         61 54                 115
1293997 1293997 IN     school 1801920 1000   Clarksville Community School Corp 180192000249 833 Clarksville Senior High School   Regular School No High 09 12 2017   grade_9                         67.0 71.0                       138.0                         67 71                 138
1752624 1752624 IN     school 1801920 1000   Clarksville Community School Corp 180192000249 833 Clarksville Senior High School   Regular School No High 09 12 2019   grade_9                         71.0 59.0                       130.0                         71 59                 130
1788363 1788363 IN     school 1801920 1000   Clarksville Community School Corp 180192000249 833 Clarksville Senior High School   Regular School No High 09 12 2018   grade_9                         45.0 46.0                       91.0                         45 46                 91
1908063 1908063 IN     school 1801920 1000   Clarksville Community School Corp 180192000249 833 Clarksville Senior High School   Regular School No High 09 12 2020   grade_9                         50.0 45.0                       95.0                         50 45                 95
1920028 1920028 IN     school 1801920 1000   Clarksville Community School Corp 180192000249 833 Clarksville Senior High School   Regular School No High 09 12 2021   grade_9                         50.0 32.0                       82.0                         50 32                 82
1920053 1920053 IN     school 1801920 1000   Clarksville Community School Corp 180192002690 1007 Indiana Gateway Digital Academy   Regular School No Other KG 12 2021   grade_9                         87.0 102.0                       189.0                         87 102                 189
1160601 1160601 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No 4.0 06 12 2015   grade_9                         22.0 36.0                       58.0                         22 36                 58
1160606 1160606 IN     school 1803940 1010   Greater Clark County Schools 180394000663 821 Charlestown Senior High Sch   Regular School No 3.0 09 12 2015   grade_9                         106.0 81.0                       187.0                         106 81                 187
1160625 1160625 IN     school 1803940 1010   Greater Clark County Schools 180394000666 849 Jeffersonville High School   Regular School No 3.0 09 12 2015   grade_9                         267.0 286.0                       553.0                         267 286                 553
1160685 1160685 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 04 12 2015   grade_9                         4.0 0.0                       4.0                         4 0                 4
1160692 1160692 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_9                         7.0 8.0                       15.0                         7 8                 15
1281999 1281999 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No 4.0 06 12 2016   grade_9                         35.0 35.0                       70.0                         35 35                 70
1282004 1282004 IN     school 1803940 1010   Greater Clark County Schools 180394000663 821 Charlestown Senior High School   Regular School No 3.0 09 12 2016   grade_9                         98.0 77.0                       175.0                         98 77                 175
1282025 1282025 IN     school 1803940 1010   Greater Clark County Schools 180394000666 849 Jeffersonville High School   Regular School No 3.0 09 12 2016   grade_9                         301.0 271.0                       572.0                         301 271                 572
1282086 1282086 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 05 12 2016   grade_9                         6.0 1.0                       7.0                         6 1                 7
1282094 1282094 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_9                         6.0 2.0                       8.0                         6 2                 8
1294057 1294057 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No Other 06 12 2017   grade_9                         28.0 28.0                       56.0                         28 28                 56
1294062 1294062 IN     school 1803940 1010   Greater Clark County Schools 180394000663 821 Charlestown Senior High School   Regular School No High 09 12 2017   grade_9                         89.0 77.0                       166.0                         89 77                 166
1294083 1294083 IN     school 1803940 1010   Greater Clark County Schools 180394000666 849 Jeffersonville High School   Regular School No High 09 12 2017   grade_9                         283.0 225.0                       508.0                         283 225                 508
1294145 1294145 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No Other 04 12 2017   grade_9                         9.0 4.0                       13.0                         9 4                 13
1294153 1294153 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No Other 06 12 2017   grade_9                         5.0 0.0                       5.0                         5 0                 5
1752684 1752684 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No High 06 12 2019   grade_9                         21.0 25.0                       46.0                         21 25                 46
1752689 1752689 IN     school 1803940 1010   Greater Clark County Schools 180394000663 821 Charlestown Senior High School   Regular School No High 09 12 2019   grade_9                         86.0 78.0                       164.0                         86 78                 164
1752703 1752703 IN     school 1803940 1010   Greater Clark County Schools 180394000666 849 Jeffersonville High School   Regular School No High 09 12 2019   grade_9                         291.0 245.0                       536.0                         291 245                 536
1752762 1752762 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No High 06 12 2019   grade_9                         8.0 2.0                       10.0                         8 2                 10
1752769 1752769 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No High 07 12 2019   grade_9                         3.0 2.0                       5.0                         3 2                 5
1788423 1788423 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No High 06 12 2018   grade_9                         22.0 23.0                       45.0                         22 23                 45
1788428 1788428 IN     school 1803940 1010   Greater Clark County Schools 180394000663 821 Charlestown Senior High School   Regular School No High 09 12 2018   grade_9                         88.0 95.0                       183.0                         88 95                 183
1788442 1788442 IN     school 1803940 1010   Greater Clark County Schools 180394000666 849 Jeffersonville High School   Regular School No High 09 12 2018   grade_9                         274.0 243.0                       517.0                         274 243                 517
1788503 1788503 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No High 05 12 2018   grade_9                         4.0 2.0                       6.0                         4 2                 6
1788510 1788510 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No High 07 12 2018   grade_9                         6.0 1.0                       7.0                         6 1                 7
1908120 1908120 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No High 06 12 2020   grade_9                         18.0 26.0                       44.0                         18 26                 44
1908125 1908125 IN     school 1803940 1010   Greater Clark County Schools 180394000663 821 Charlestown Senior High School   Regular School No High 09 12 2020   grade_9                         81.0 98.0                       179.0                         81 98                 179
1908139 1908139 IN     school 1803940 1010   Greater Clark County Schools 180394000666 849 Jeffersonville High School   Regular School No High 09 12 2020   grade_9                         290.0 241.0                       531.0                         290 241                 531
1908198 1908198 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No High 06 12 2020   grade_9                         3.0 0.0                       3.0                         3 0                 3
1920102 1920102 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No High 06 12 2021   grade_9                         25.0 23.0                       48.0                         25 23                 48
1920107 1920107 IN     school 1803940 1010   Greater Clark County Schools 180394000663 821 Charlestown Senior High School   Regular School No High 09 12 2021   grade_9                         95.0 109.0                       204.0                         95 109                 204
1920121 1920121 IN     school 1803940 1010   Greater Clark County Schools 180394000666 849 Jeffersonville High School   Regular School No High 09 12 2021   grade_9                         297.0 288.0                       585.0                         297 288                 585
1920173 1920173 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No High 06 12 2021   grade_9                         6.0 3.0                       9.0                         6 3                 9
1160707 1160707 IN     school 1800840 1125   Clay Community Schools 180084000157 897 Clay City Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_9                         32.0 35.0                       67.0                         32 35                 67
1160737 1160737 IN     school 1800840 1125   Clay Community Schools 180084000154 933 Northview High School   Regular School No 3.0 09 12 2015   grade_9                         125.0 145.0                       270.0                         125 145                 270
1282109 1282109 IN     school 1800840 1125   Clay Community Schools 180084000157 897 Clay City Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_9                         25.0 35.0                       60.0                         25 35                 60
1282139 1282139 IN     school 1800840 1125   Clay Community Schools 180084000154 933 Northview High School   Regular School No 3.0 09 12 2016   grade_9                         147.0 139.0                       286.0                         147 139                 286
1294168 1294168 IN     school 1800840 1125   Clay Community Schools 180084000157 897 Clay City Jr-Sr High School   Regular School No High 07 12 2017   grade_9                         32.0 32.0                       64.0                         32 32                 64
1294198 1294198 IN     school 1800840 1125   Clay Community Schools 180084000154 933 Northview High School   Regular School No High 09 12 2017   grade_9                         143.0 135.0                       278.0                         143 135                 278
1752784 1752784 IN     school 1800840 1125   Clay Community Schools 180084000157 897 Clay City Jr-Sr High School   Regular School No High 07 12 2019   grade_9                         36.0 36.0                       72.0                         36 36                 72
1752814 1752814 IN     school 1800840 1125   Clay Community Schools 180084000154 933 Northview High School   Regular School No High 09 12 2019   grade_9                         139.0 140.0                       279.0                         139 140                 279
1788525 1788525 IN     school 1800840 1125   Clay Community Schools 180084000157 897 Clay City Jr-Sr High School   Regular School No High 07 12 2018   grade_9                         33.0 34.0                       67.0                         33 34                 67
1788555 1788555 IN     school 1800840 1125   Clay Community Schools 180084000154 933 Northview High School   Regular School No High 09 12 2018   grade_9                         139.0 140.0                       279.0                         139 140                 279
1908213 1908213 IN     school 1800840 1125   Clay Community Schools 180084000157 897 Clay City Jr-Sr High School   Regular School No High 07 12 2020   grade_9                         27.0 29.0                       56.0                         27 29                 56
1908243 1908243 IN     school 1800840 1125   Clay Community Schools 180084000154 933 Northview High School   Regular School No High 09 12 2020   grade_9                         128.0 121.0                       249.0                         128 121                 249
1920188 1920188 IN     school 1800840 1125   Clay Community Schools 180084000157 897 Clay City Jr-Sr High School   Regular School No High 07 12 2021   grade_9                         29.0 26.0                       55.0                         29 26                 55
1920218 1920218 IN     school 1800840 1125   Clay Community Schools 180084000154 933 Northview High School   Regular School No High 09 12 2021   grade_9                         142.0 129.0                       271.0                         142 129                 271
1160769 1160769 IN     school 1802130 1150   Clinton Central School Corp 180213000257 957 Clinton Central Junior-Senior HS   Regular School No 3.0 07 12 2015   grade_9                         40.0 28.0                       68.0                         40 28                 68
1282171 1282171 IN     school 1802130 1150   Clinton Central School Corp 180213000257 957 Clinton Central Junior-Senior HS   Regular School No 3.0 07 12 2016   grade_9                         43.0 28.0                       71.0                         43 28                 71
1294229 1294229 IN     school 1802130 1150   Clinton Central School Corporation 180213000257 957 Clinton Central Junior-Senior HS   Regular School No High 07 12 2017   grade_9                         28.0 49.0                       77.0                         28 49                 77
1752845 1752845 IN     school 1802130 1150   Clinton Central School Corporation 180213000257 957 Clinton Central Junior-Senior HS   Regular School No High 07 12 2019   grade_9                         39.0 40.0                       79.0                         39 40                 79
1788586 1788586 IN     school 1802130 1150   Clinton Central School Corporation 180213000257 957 Clinton Central Junior-Senior HS   Regular School No High 07 12 2018   grade_9                         40.0 30.0                       70.0                         40 30                 70
1908274 1908274 IN     school 1802130 1150   Clinton Central School Corporation 180213000257 957 Clinton Central Junior-Senior HS   Regular School No High 07 12 2020   grade_9                         41.0 30.0                       71.0                         41 30                 71
1920249 1920249 IN     school 1802130 1150   Clinton Central School Corporation 180213000257 957 Clinton Central Junior-Senior HS   Regular School No High 07 12 2021   grade_9                         37.0 39.0                       76.0                         37 39                 76
1160785 1160785 IN     school 1802160 1160   Clinton Prairie School Corp 180216000258 977 Clinton Prairie Jr-Sr HS   Regular School No 3.0 07 12 2015   grade_9                         44.0 34.0                       78.0                         44 34                 78
1282187 1282187 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_9                         38.0 53.0                       91.0                         38 53                 91
1294244 1294244 IN     school 1802160 1160   Clinton Prairie School Corporation 180216000258 977 Clinton Prairie Jr-Sr High School   Regular School No High 07 12 2017   grade_9                         46.0 48.0                       94.0                         46 48                 94
1752860 1752860 IN     school 1802160 1160   Clinton Prairie School Corporation 180216000258 977 Clinton Prairie Jr-Sr High School   Regular School No High 07 12 2019   grade_9                         58.0 46.0                       104.0                         58 46                 104
1788601 1788601 IN     school 1802160 1160   Clinton Prairie School Corporation 180216000258 977 Clinton Prairie Jr-Sr High School   Regular School No High 07 12 2018   grade_9                         42.0 42.0                       84.0                         42 42                 84
1908289 1908289 IN     school 1802160 1160   Clinton Prairie School Corporation 180216000258 977 Clinton Prairie Jr-Sr High School   Regular School No High 07 12 2020   grade_9                         39.0 53.0                       92.0                         39 53                 92
1920265 1920265 IN     school 1802160 1160   Clinton Prairie School Corporation 180216000258 977 Clinton Prairie Jr-Sr High School   Regular School No High 07 12 2021   grade_9                         50.0 48.0                       98.0                         50 48                 98
1160798 1160798 IN     school 1803660 1170   Community Schools of Frankfort 180366000574 997 Frankfort Senior High School   Regular School No 3.0 09 12 2015   grade_9                         119.0 105.0                       224.0                         119 105                 224
1282201 1282201 IN     school 1803660 1170   Community Schools of Frankfort 180366000574 997 Frankfort Senior High School   Regular School No 3.0 09 12 2016   grade_9                         133.0 134.0                       267.0                         133 134                 267
1294258 1294258 IN     school 1803660 1170   Community Schools of Frankfort 180366000574 997 Frankfort Senior High School   Regular School No High 09 12 2017   grade_9                         116.0 107.0                       223.0                         116 107                 223
1752874 1752874 IN     school 1803660 1170   Community Schools of Frankfort 180366000574 997 Frankfort High School   Regular School No High 09 12 2019   grade_9                         120.0 105.0                       225.0                         120 105                 225
1788615 1788615 IN     school 1803660 1170   Community Schools of Frankfort 180366000574 997 Frankfort High School   Regular School No High 09 12 2018   grade_9                         118.0 121.0                       239.0                         118 121                 239
1908303 1908303 IN     school 1803660 1170   Community Schools of Frankfort 180366000574 997 Frankfort High School   Regular School No High 09 12 2020   grade_9                         116.0 116.0                       232.0                         116 116                 232
1920279 1920279 IN     school 1803660 1170   Community Schools of Frankfort 180366000574 997 Frankfort High School   Regular School No High 09 12 2021   grade_9                         117.0 113.0                       230.0                         117 113                 230
1160827 1160827 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No 4.0 06 12 2015   grade_9                         32.0 49.0                       81.0                         32 49                 81
1282230 1282230 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No 4.0 06 12 2016   grade_9                         37.0 42.0                       79.0                         37 42                 79
1294287 1294287 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No Other 06 12 2017   grade_9                         39.0 46.0                       85.0                         39 46                 85
1752904 1752904 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No High 06 12 2019   grade_9                         44.0 39.0                       83.0                         44 39                 83
1788645 1788645 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No High 06 12 2018   grade_9                         50.0 38.0                       88.0                         50 38                 88
1908333 1908333 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No High 06 12 2020   grade_9                         25.0 34.0                       59.0                         25 34                 59
1920309 1920309 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No High 06 12 2021   grade_9                         32.0 38.0                       70.0                         32 38                 70
1159533 1159533 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_9                         289.0 289.0                       578.0                         289 289                 578
1280923 1280923 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_9                         302.0 293.0                       595.0                         302 293                 595
1292985 1292985 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_9                         301.0 291.0                       592.0                         301 291                 592
1751617 1751617 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_9                         340.0 338.0                       678.0                         340 338                 678
1787358 1787358 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_9                         305.0 287.0                       592.0                         305 287                 592
1907058 1907058 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_9                         317.0 302.0                       619.0                         317 302                 619
1919024 1919024 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2021   grade_9                         304.0 329.0                       633.0                         304 329                 633
1160869 1160869 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_9                         79.0 44.0                       123.0                         79 44                 123
1282271 1282271 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_9                         57.0 55.0                       112.0                         57 55                 112
1294315 1294315 IN     school 1802440 1300   Crawford County Community Sch Corp 180244000279 1059 Crawford County High School   Regular School No High 09 12 2017   grade_9                         57.0 65.0                       122.0                         57 65                 122
1752932 1752932 IN     school 1802440 1300   Crawford County Community Sch Corp 180244000279 1059 Crawford County High School   Regular School No High 09 12 2019   grade_9                         60.0 62.0                       122.0                         60 62                 122
1788673 1788673 IN     school 1802440 1300   Crawford County Community Sch Corp 180244000279 1059 Crawford County High School   Regular School No High 09 12 2018   grade_9                         58.0 51.0                       109.0                         58 51                 109
1908363 1908363 IN     school 1802440 1300   Crawford County Community Sch Corp 180244000279 1059 Crawford County High School   Regular School No High 09 12 2020   grade_9                         55.0 58.0                       113.0                         55 58                 113
1920338 1920338 IN     school 1802440 1300   Crawford County Community Sch Corp 180244000279 1059 Crawford County High School   Regular School No High 09 12 2021   grade_9                         59.0 55.0                       114.0                         59 55                 114
1160895 1160895 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_9                         22.0 19.0                       41.0                         22 19                 41
1282297 1282297 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_9                         29.0 24.0                       53.0                         29 24                 53
1294335 1294335 IN     school 1800330 1315   Barr-Reeve Community Schools Inc 180033000061 1069 Barr Reeve Middle/High School   Regular School No Other 06 12 2017   grade_9                         32.0 22.0                       54.0                         32 22                 54

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