enrollments

Data source: Big Local News · About: Big Local

3,530 rows where grade = "grade_7" and state = "IN" sorted by school_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 3,530 ✖
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
1159463 1159463 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No 2.0 06 08 2015   grade_7                         42.0 48.0                       90.0                         42 48                 90
1280853 1280853 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No 2.0 06 08 2016   grade_7                         49.0 56.0                       105.0                         49 56                 105
1292915 1292915 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2017   grade_7                         38.0 42.0                       80.0                         38 42                 80
1751547 1751547 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2019   grade_7                         50.0 51.0                       101.0                         50 51                 101
1787288 1787288 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2018   grade_7                         49.0 33.0                       82.0                         49 33                 82
1906988 1906988 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2020   grade_7                         52.0 53.0                       105.0                         52 53                 105
1918954 1918954 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2021   grade_7                         64.0 43.0                       107.0                         64 43                 107
1159498 1159498 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No 2.0 06 08 2015   grade_7                         49.0 47.0                       96.0                         49 47                 96
1280888 1280888 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No 2.0 06 08 2016   grade_7                         65.0 51.0                       116.0                         65 51                 116
1292951 1292951 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No Middle 06 08 2017   grade_7                         59.0 53.0                       112.0                         59 53                 112
1751582 1751582 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No Middle 06 08 2019   grade_7                         46.0 56.0                       102.0                         46 56                 102
1787324 1787324 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No Middle 06 08 2018   grade_7                         47.0 42.0                       89.0                         47 42                 89
1907023 1907023 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No Middle 06 08 2020   grade_7                         47.0 46.0                       93.0                         47 46                 93
1918989 1918989 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No Middle 06 08 2021   grade_7                         41.0 45.0                       86.0                         41 45                 86
1159486 1159486 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No 2.0 05 08 2015   grade_7                         49.0 66.0                       115.0                         49 66                 115
1280876 1280876 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No 2.0 05 08 2016   grade_7                         53.0 70.0                       123.0                         53 70                 123
1292939 1292939 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 05 08 2017   grade_7                         69.0 54.0                       123.0                         69 54                 123
1751570 1751570 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 06 08 2019   grade_7                         43.0 56.0                       99.0                         43 56                 99
1787312 1787312 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 05 08 2018   grade_7                         49.0 59.0                       108.0                         49 59                 108
1907011 1907011 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 06 08 2020   grade_7                         52.0 64.0                       116.0                         52 64                 116
1918977 1918977 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 06 08 2021   grade_7                         50.0 72.0                       122.0                         50 72                 122
1159972 1159972 IN     school 1802850 255   East Allen County Schools 180285000349 49 Leo Junior/Senior High School   Regular School No 3.0 07 12 2015   grade_7                         109.0 105.0                       214.0                         109 105                 214
1281365 1281365 IN     school 1802850 255   East Allen County Schools 180285000349 49 Leo Junior/Senior High School   Regular School No 3.0 07 12 2016   grade_7                         121.0 93.0                       214.0                         121 93                 214
1293419 1293419 IN     school 1802850 255   East Allen County Schools 180285000349 49 Leo Junior/Senior High School   Regular School No High 07 12 2017   grade_7                         111.0 107.0                       218.0                         111 107                 218
1752043 1752043 IN     school 1802850 255   East Allen County Schools 180285000349 49 Leo Junior/Senior High School   Regular School No High 07 12 2019   grade_7                         97.0 125.0                       222.0                         97 125                 222
1787788 1787788 IN     school 1802850 255   East Allen County Schools 180285000349 49 Leo Junior/Senior High School   Regular School No High 07 12 2018   grade_7                         108.0 112.0                       220.0                         108 112                 220
1907483 1907483 IN     school 1802850 255   East Allen County Schools 180285000349 49 Leo Junior/Senior High School   Regular School No High 07 12 2020   grade_7                         99.0 111.0                       210.0                         99 111                 210
1919449 1919449 IN     school 1802850 255   East Allen County Schools 180285000349 49 Leo Junior/Senior High School   Regular School No High 07 12 2021   grade_7                         120.0 94.0                       214.0                         120 94                 214
1159536 1159536 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No 2.0 06 08 2015   grade_7                         118.0 112.0                       230.0                         118 112                 230
1280926 1280926 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No 2.0 06 08 2016   grade_7                         120.0 111.0                       231.0                         120 111                 231
1292988 1292988 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No Middle 06 08 2017   grade_7                         125.0 123.0                       248.0                         125 123                 248
1751620 1751620 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No Middle 06 08 2019   grade_7                         110.0 125.0                       235.0                         110 125                 235
1787361 1787361 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No Middle 06 08 2018   grade_7                         108.0 120.0                       228.0                         108 120                 228
1907061 1907061 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No Middle 06 08 2020   grade_7                         151.0 128.0                       279.0                         151 128                 279
1919027 1919027 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No Middle 06 08 2021   grade_7                         144.0 136.0                       280.0                         144 136                 280
1159547 1159547 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No 2.0 06 08 2015   grade_7                         159.0 160.0                       319.0                         159 160                 319
1280937 1280937 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No 2.0 06 08 2016   grade_7                         162.0 162.0                       324.0                         162 162                 324
1292999 1292999 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2017   grade_7                         183.0 186.0                       369.0                         183 186                 369
1751631 1751631 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2019   grade_7                         174.0 182.0                       356.0                         174 182                 356
1787372 1787372 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2018   grade_7                         179.0 161.0                       340.0                         179 161                 340
1907072 1907072 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2020   grade_7                         169.0 174.0                       343.0                         169 174                 343
1919038 1919038 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2021   grade_7                         162.0 163.0                       325.0                         162 163                 325
1159579 1159579 IN     school 1808250 225   Northwest Allen County Schools 180825001380 79 Maple Creek Middle Sch   Regular School No 2.0 06 08 2015   grade_7                         114.0 143.0                       257.0                         114 143                 257
1280969 1280969 IN     school 1808250 225   Northwest Allen County Schools 180825001380 79 Maple Creek Middle School   Regular School No 2.0 06 08 2016   grade_7                         135.0 143.0                       278.0                         135 143                 278
1293031 1293031 IN     school 1808250 225   Northwest Allen County Schools 180825001380 79 Maple Creek Middle School   Regular School No Middle 06 08 2017   grade_7                         129.0 124.0                       253.0                         129 124                 253
1751663 1751663 IN     school 1808250 225   Northwest Allen County Schools 180825001380 79 Maple Creek Middle School   Regular School No Middle 06 08 2019   grade_7                         160.0 127.0                       287.0                         160 127                 287
1787404 1787404 IN     school 1808250 225   Northwest Allen County Schools 180825001380 79 Maple Creek Middle School   Regular School No Middle 06 08 2018   grade_7                         152.0 140.0                       292.0                         152 140                 292
1907104 1907104 IN     school 1808250 225   Northwest Allen County Schools 180825001380 79 Maple Creek Middle School   Regular School No Middle 06 08 2020   grade_7                         173.0 149.0                       322.0                         173 149                 322
1919070 1919070 IN     school 1808250 225   Northwest Allen County Schools 180825001380 79 Maple Creek Middle School   Regular School No Middle 06 08 2021   grade_7                         143.0 153.0                       296.0                         143 153                 296
1159984 1159984 IN     school 1802850 255   East Allen County Schools 180285000344 81 Heritage Jr/Sr High School   Regular School No 3.0 07 12 2015   grade_7                         35.0 55.0                       90.0                         35 55                 90
1281377 1281377 IN     school 1802850 255   East Allen County Schools 180285000344 81 Heritage Jr/Sr High School   Regular School No 3.0 07 12 2016   grade_7                         30.0 45.0                       75.0                         30 45                 75
1293432 1293432 IN     school 1802850 255   East Allen County Schools 180285000344 81 Heritage Jr/Sr High School   Regular School No High 07 12 2017   grade_7                         45.0 35.0                       80.0                         45 35                 80
1752055 1752055 IN     school 1802850 255   East Allen County Schools 180285000344 81 Heritage Jr/Sr High School   Regular School No High 07 12 2019   grade_7                         57.0 42.0                       99.0                         57 42                 99
1787800 1787800 IN     school 1802850 255   East Allen County Schools 180285000344 81 Heritage Jr/Sr High School   Regular School No High 07 12 2018   grade_7                         50.0 53.0                       103.0                         50 53                 103
1907495 1907495 IN     school 1802850 255   East Allen County Schools 180285000344 81 Heritage Jr/Sr High School   Regular School No High 07 12 2020   grade_7                         43.0 39.0                       82.0                         43 39                 82
1919461 1919461 IN     school 1802850 255   East Allen County Schools 180285000344 81 Heritage Jr/Sr High School   Regular School No High 07 12 2021   grade_7                         48.0 35.0                       83.0                         48 35                 83
1159597 1159597 IN     school 1808250 225   Northwest Allen County Schools 180825002294 90 Carroll Middle School   Regular School No 2.0 06 08 2015   grade_7                         154.0 162.0                       316.0                         154 162                 316
1280987 1280987 IN     school 1808250 225   Northwest Allen County Schools 180825002294 90 Carroll Middle School   Regular School No 2.0 06 08 2016   grade_7                         183.0 164.0                       347.0                         183 164                 347
1293050 1293050 IN     school 1808250 225   Northwest Allen County Schools 180825002294 90 Carroll Middle School   Regular School No Middle 06 08 2017   grade_7                         173.0 127.0                       300.0                         173 127                 300
1751682 1751682 IN     school 1808250 225   Northwest Allen County Schools 180825002294 90 Carroll Middle School   Regular School No Middle 06 08 2019   grade_7                         153.0 154.0                       307.0                         153 154                 307
1787423 1787423 IN     school 1808250 225   Northwest Allen County Schools 180825002294 90 Carroll Middle School   Regular School No Middle 06 08 2018   grade_7                         140.0 149.0                       289.0                         140 149                 289
1907123 1907123 IN     school 1808250 225   Northwest Allen County Schools 180825002294 90 Carroll Middle School   Regular School No Middle 06 08 2020   grade_7                         160.0 159.0                       319.0                         160 159                 319
1919089 1919089 IN     school 1808250 225   Northwest Allen County Schools 180825002294 90 Carroll Middle School   Regular School No Middle 06 08 2021   grade_7                         160.0 174.0                       334.0                         160 174                 334
1159643 1159643 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No 3.0 07 12 2015   grade_7                         1.0 0.0                       1.0                         1 0                 1
1159663 1159663 IN     school 1803630 235   Fort Wayne Community Schools 180363000516 107 Blackhawk Middle School   Regular School No 2.0 06 08 2015   grade_7                         151.0 144.0                       295.0                         151 144                 295
1281055 1281055 IN     school 1803630 235   Fort Wayne Community Schools 180363000516 107 Blackhawk Middle School   Regular School No 2.0 06 08 2016   grade_7                         137.0 133.0                       270.0                         137 133                 270
1293116 1293116 IN     school 1803630 235   Fort Wayne Community Schools 180363000516 107 Blackhawk Middle School   Regular School No Middle 06 08 2017   grade_7                         139.0 132.0                       271.0                         139 132                 271
1751741 1751741 IN     school 1803630 235   Fort Wayne Community Schools 180363000516 107 Blackhawk Middle School   Regular School No Middle 06 08 2019   grade_7                         152.0 134.0                       286.0                         152 134                 286
1787485 1787485 IN     school 1803630 235   Fort Wayne Community Schools 180363000516 107 Blackhawk Middle School   Regular School No Middle 06 08 2018   grade_7                         119.0 138.0                       257.0                         119 138                 257
1907181 1907181 IN     school 1803630 235   Fort Wayne Community Schools 180363000516 107 Blackhawk Middle School   Regular School No Middle 06 08 2020   grade_7                         134.0 139.0                       273.0                         134 139                 273
1919147 1919147 IN     school 1803630 235   Fort Wayne Community Schools 180363000516 107 Blackhawk Middle School   Regular School No Middle 06 08 2021   grade_7                         145.0 144.0                       289.0                         145 144                 289
1758281 1758281 IN     school 1804770 5385   Indianapolis Public Schools 180477002651 108 Impact Academy   Regular School No Other 03 12 2019   grade_7                         16.0 8.0                       24.0                         16 8                 24
1913711 1913711 IN     school 1804770 5385   Indianapolis Public Schools 180477002651 108 Impact Academy   Regular School No Other 03 12 2020   grade_7                         6.0 7.0                       13.0                         6 7                 13
1925615 1925615 IN     school 1804770 5385   Indianapolis Public Schools 180477002651 108 Impact Academy   Regular School No Other 03 12 2021   grade_7                         8.0 2.0                       10.0                         8 2                 10
1159672 1159672 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No 1.0 01 08 2015   grade_7                         32.0 39.0                       71.0                         32 39                 71
1281064 1281064 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No 1.0 01 08 2016   grade_7                         40.0 45.0                       85.0                         40 45                 85
1293125 1293125 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2017   grade_7                         44.0 34.0                       78.0                         44 34                 78
1751750 1751750 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2019   grade_7                         45.0 43.0                       88.0                         45 43                 88
1787494 1787494 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2018   grade_7                         41.0 43.0                       84.0                         41 43                 84
1907190 1907190 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2020   grade_7                         38.0 40.0                       78.0                         38 40                 78
1919156 1919156 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2021   grade_7                         30.0 38.0                       68.0                         30 38                 68
1159676 1159676 IN     school 1803630 235   Fort Wayne Community Schools 180363000534 119 Jefferson Middle School   Regular School No 2.0 06 08 2015   grade_7                         104.0 101.0                       205.0                         104 101                 205
1281068 1281068 IN     school 1803630 235   Fort Wayne Community Schools 180363000534 119 Jefferson Middle School   Regular School No 2.0 06 08 2016   grade_7                         127.0 121.0                       248.0                         127 121                 248
1293129 1293129 IN     school 1803630 235   Fort Wayne Community Schools 180363000534 119 Jefferson Middle School   Regular School No Middle 06 08 2017   grade_7                         102.0 125.0                       227.0                         102 125                 227
1751754 1751754 IN     school 1803630 235   Fort Wayne Community Schools 180363000534 119 Jefferson Middle School   Regular School No Middle 06 08 2019   grade_7                         111.0 117.0                       228.0                         111 117                 228
1787498 1787498 IN     school 1803630 235   Fort Wayne Community Schools 180363000534 119 Jefferson Middle School   Regular School No Middle 06 08 2018   grade_7                         141.0 117.0                       258.0                         141 117                 258
1907194 1907194 IN     school 1803630 235   Fort Wayne Community Schools 180363000534 119 Jefferson Middle School   Regular School No Middle 06 08 2020   grade_7                         118.0 117.0                       235.0                         118 117                 235
1919160 1919160 IN     school 1803630 235   Fort Wayne Community Schools 180363000534 119 Jefferson Middle School   Regular School No Middle 06 08 2021   grade_7                         122.0 141.0                       263.0                         122 141                 263
1159680 1159680 IN     school 1803630 235   Fort Wayne Community Schools 180363000537 121 Kekionga Middle School   Regular School No 2.0 06 08 2015   grade_7                         99.0 77.0                       176.0                         99 77                 176
1281072 1281072 IN     school 1803630 235   Fort Wayne Community Schools 180363000537 121 Kekionga Middle School   Regular School No 2.0 06 08 2016   grade_7                         95.0 84.0                       179.0                         95 84                 179
1293133 1293133 IN     school 1803630 235   Fort Wayne Community Schools 180363000537 121 Kekionga Middle School   Regular School No Middle 06 08 2017   grade_7                         87.0 73.0                       160.0                         87 73                 160
1751758 1751758 IN     school 1803630 235   Fort Wayne Community Schools 180363000537 121 Kekionga Middle School   Regular School No Middle 06 08 2019   grade_7                         80.0 70.0                       150.0                         80 70                 150
1787502 1787502 IN     school 1803630 235   Fort Wayne Community Schools 180363000537 121 Kekionga Middle School   Regular School No Middle 06 08 2018   grade_7                         110.0 86.0                       196.0                         110 86                 196
1907198 1907198 IN     school 1803630 235   Fort Wayne Community Schools 180363000537 121 Kekionga Middle School   Regular School No Middle 06 08 2020   grade_7                         98.0 99.0                       197.0                         98 99                 197
1919164 1919164 IN     school 1803630 235   Fort Wayne Community Schools 180363000537 121 Kekionga Middle School   Regular School No Middle 06 08 2021   grade_7                         94.0 86.0                       180.0                         94 86                 180
1159684 1159684 IN     school 1803630 235   Fort Wayne Community Schools 180363000538 125 Lakeside Middle School   Regular School No 2.0 06 08 2015   grade_7                         78.0 80.0                       158.0                         78 80                 158
1281076 1281076 IN     school 1803630 235   Fort Wayne Community Schools 180363000538 125 Lakeside Middle School   Regular School No 2.0 06 08 2016   grade_7                         84.0 64.0                       148.0                         84 64                 148
1293137 1293137 IN     school 1803630 235   Fort Wayne Community Schools 180363000538 125 Lakeside Middle School   Regular School No Middle 06 08 2017   grade_7                         85.0 68.0                       153.0                         85 68                 153
1751762 1751762 IN     school 1803630 235   Fort Wayne Community Schools 180363000538 125 Lakeside Middle School   Regular School No Middle 06 08 2019   grade_7                         88.0 100.0                       188.0                         88 100                 188
1787506 1787506 IN     school 1803630 235   Fort Wayne Community Schools 180363000538 125 Lakeside Middle School   Regular School No Middle 06 08 2018   grade_7                         89.0 81.0                       170.0                         89 81                 170

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