enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_6 · 4,822 ✖
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id ▼ school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
1159462 1159462 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No 2.0 06 08 2015   grade_6                         45.0 55.0                       100.0                         45 55                 100
1280852 1280852 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No 2.0 06 08 2016   grade_6                         38.0 41.0                       79.0                         38 41                 79
1292914 1292914 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2017   grade_6                         50.0 36.0                       86.0                         50 36                 86
1751546 1751546 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2019   grade_6                         55.0 51.0                       106.0                         55 51                 106
1787287 1787287 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2018   grade_6                         51.0 51.0                       102.0                         51 51                 102
1906987 1906987 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2020   grade_6                         62.0 45.0                       107.0                         62 45                 107
1918953 1918953 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2021   grade_6                         53.0 45.0                       98.0                         53 45                 98
1159497 1159497 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No 2.0 06 08 2015   grade_6                         63.0 56.0                       119.0                         63 56                 119
1280887 1280887 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No 2.0 06 08 2016   grade_6                         58.0 51.0                       109.0                         58 51                 109
1292950 1292950 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No Middle 06 08 2017   grade_6                         42.0 43.0                       85.0                         42 43                 85
1751581 1751581 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No Middle 06 08 2019   grade_6                         47.0 49.0                       96.0                         47 49                 96
1787323 1787323 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No Middle 06 08 2018   grade_6                         43.0 53.0                       96.0                         43 53                 96
1907022 1907022 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No Middle 06 08 2020   grade_6                         41.0 46.0                       87.0                         41 46                 87
1918988 1918988 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No Middle 06 08 2021   grade_6                         39.0 48.0                       87.0                         39 48                 87
1159485 1159485 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No 2.0 05 08 2015   grade_6                         53.0 68.0                       121.0                         53 68                 121
1280875 1280875 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No 2.0 05 08 2016   grade_6                         71.0 57.0                       128.0                         71 57                 128
1292938 1292938 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 05 08 2017   grade_6                         46.0 63.0                       109.0                         46 63                 109
1751569 1751569 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 06 08 2019   grade_6                         57.0 63.0                       120.0                         57 63                 120
1787311 1787311 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 05 08 2018   grade_6                         49.0 51.0                       100.0                         49 51                 100
1907010 1907010 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 06 08 2020   grade_6                         58.0 76.0                       134.0                         58 76                 134
1918976 1918976 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 06 08 2021   grade_6                         60.0 63.0                       123.0                         60 63                 123
1159967 1159967 IN     school 1802850 255   East Allen County Schools 180285002519 43 Prince Chapman Academy   Regular School No 1.0 03 06 2015   grade_6                         86.0 74.0                       160.0                         86 74                 160
1281359 1281359 IN     school 1802850 255   East Allen County Schools 180285002519 43 Prince Chapman Academy   Regular School No 1.0 03 06 2016   grade_6                         66.0 82.0                       148.0                         66 82                 148
1293413 1293413 IN     school 1802850 255   East Allen County Schools 180285002519 43 Prince Chapman Academy   Regular School No Elementary 03 06 2017   grade_6                         77.0 82.0                       159.0                         77 82                 159
1752037 1752037 IN     school 1802850 255   East Allen County Schools 180285002519 43 Prince Chapman Academy   Regular School No Elementary 03 06 2019   grade_6                         115.0 102.0                       217.0                         115 102                 217
1787782 1787782 IN     school 1802850 255   East Allen County Schools 180285002519 43 Prince Chapman Academy   Regular School No Elementary 03 06 2018   grade_6                         98.0 93.0                       191.0                         98 93                 191
1907477 1907477 IN     school 1802850 255   East Allen County Schools 180285002519 43 Prince Chapman Academy   Regular School No Elementary 03 06 2020   grade_6                         103.0 101.0                       204.0                         103 101                 204
1919443 1919443 IN     school 1802850 255   East Allen County Schools 180285002519 43 Prince Chapman Academy   Regular School No Elementary 03 06 2021   grade_6                         104.0 101.0                       205.0                         104 101                 205
1159979 1159979 IN     school 1802850 255   East Allen County Schools 180285000348 53 Leo Elementary School   Regular School No 1.0 03 06 2015   grade_6                         115.0 81.0                       196.0                         115 81                 196
1281371 1281371 IN     school 1802850 255   East Allen County Schools 180285000348 53 Leo Elementary School   Regular School No 2.0 04 06 2016   grade_6                         103.0 103.0                       206.0                         103 103                 206
1293426 1293426 IN     school 1802850 255   East Allen County Schools 180285000348 53 Leo Elementary School   Regular School No Elementary 03 06 2017   grade_6                         105.0 109.0                       214.0                         105 109                 214
1752049 1752049 IN     school 1802850 255   East Allen County Schools 180285000348 53 Leo Elementary School   Regular School No Middle 04 06 2019   grade_6                         99.0 105.0                       204.0                         99 105                 204
1787794 1787794 IN     school 1802850 255   East Allen County Schools 180285000348 53 Leo Elementary School   Regular School No Middle 04 06 2018   grade_6                         92.0 112.0                       204.0                         92 112                 204
1907489 1907489 IN     school 1802850 255   East Allen County Schools 180285000348 53 Leo Elementary School   Regular School No Middle 04 06 2020   grade_6                         113.0 95.0                       208.0                         113 95                 208
1919455 1919455 IN     school 1802850 255   East Allen County Schools 180285000348 53 Leo Elementary School   Regular School No Middle 04 06 2021   grade_6                         97.0 100.0                       197.0                         97 100                 197
1159535 1159535 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No 2.0 06 08 2015   grade_6                         116.0 104.0                       220.0                         116 104                 220
1280925 1280925 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No 2.0 06 08 2016   grade_6                         126.0 115.0                       241.0                         126 115                 241
1292987 1292987 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No Middle 06 08 2017   grade_6                         114.0 114.0                       228.0                         114 114                 228
1751619 1751619 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No Middle 06 08 2019   grade_6                         136.0 113.0                       249.0                         136 113                 249
1787360 1787360 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No Middle 06 08 2018   grade_6                         109.0 119.0                       228.0                         109 119                 228
1907060 1907060 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No Middle 06 08 2020   grade_6                         140.0 136.0                       276.0                         140 136                 276
1919026 1919026 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No Middle 06 08 2021   grade_6                         153.0 122.0                       275.0                         153 122                 275
1159546 1159546 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No 2.0 06 08 2015   grade_6                         171.0 158.0                       329.0                         171 158                 329
1280936 1280936 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No 2.0 06 08 2016   grade_6                         186.0 183.0                       369.0                         186 183                 369
1292998 1292998 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2017   grade_6                         172.0 152.0                       324.0                         172 152                 324
1751630 1751630 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2019   grade_6                         168.0 169.0                       337.0                         168 169                 337
1787371 1787371 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2018   grade_6                         158.0 178.0                       336.0                         158 178                 336
1907071 1907071 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2020   grade_6                         156.0 163.0                       319.0                         156 163                 319
1919037 1919037 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2021   grade_6                         176.0 169.0                       345.0                         176 169                 345
1159578 1159578 IN     school 1808250 225   Northwest Allen County Schools 180825001380 79 Maple Creek Middle Sch   Regular School No 2.0 06 08 2015   grade_6                         133.0 132.0                       265.0                         133 132                 265
1280968 1280968 IN     school 1808250 225   Northwest Allen County Schools 180825001380 79 Maple Creek Middle School   Regular School No 2.0 06 08 2016   grade_6                         125.0 125.0                       250.0                         125 125                 250
1293030 1293030 IN     school 1808250 225   Northwest Allen County Schools 180825001380 79 Maple Creek Middle School   Regular School No Middle 06 08 2017   grade_6                         150.0 135.0                       285.0                         150 135                 285
1751662 1751662 IN     school 1808250 225   Northwest Allen County Schools 180825001380 79 Maple Creek Middle School   Regular School No Middle 06 08 2019   grade_6                         166.0 144.0                       310.0                         166 144                 310
1787403 1787403 IN     school 1808250 225   Northwest Allen County Schools 180825001380 79 Maple Creek Middle School   Regular School No Middle 06 08 2018   grade_6                         162.0 127.0                       289.0                         162 127                 289
1907103 1907103 IN     school 1808250 225   Northwest Allen County Schools 180825001380 79 Maple Creek Middle School   Regular School No Middle 06 08 2020   grade_6                         139.0 147.0                       286.0                         139 147                 286
1919069 1919069 IN     school 1808250 225   Northwest Allen County Schools 180825001380 79 Maple Creek Middle School   Regular School No Middle 06 08 2021   grade_6                         145.0 149.0                       294.0                         145 149                 294
1159596 1159596 IN     school 1808250 225   Northwest Allen County Schools 180825002294 90 Carroll Middle School   Regular School No 2.0 06 08 2015   grade_6                         169.0 165.0                       334.0                         169 165                 334
1280986 1280986 IN     school 1808250 225   Northwest Allen County Schools 180825002294 90 Carroll Middle School   Regular School No 2.0 06 08 2016   grade_6                         160.0 128.0                       288.0                         160 128                 288
1293049 1293049 IN     school 1808250 225   Northwest Allen County Schools 180825002294 90 Carroll Middle School   Regular School No Middle 06 08 2017   grade_6                         135.0 143.0                       278.0                         135 143                 278
1751681 1751681 IN     school 1808250 225   Northwest Allen County Schools 180825002294 90 Carroll Middle School   Regular School No Middle 06 08 2019   grade_6                         159.0 153.0                       312.0                         159 153                 312
1787422 1787422 IN     school 1808250 225   Northwest Allen County Schools 180825002294 90 Carroll Middle School   Regular School No Middle 06 08 2018   grade_6                         148.0 150.0                       298.0                         148 150                 298
1907122 1907122 IN     school 1808250 225   Northwest Allen County Schools 180825002294 90 Carroll Middle School   Regular School No Middle 06 08 2020   grade_6                         156.0 178.0                       334.0                         156 178                 334
1919088 1919088 IN     school 1808250 225   Northwest Allen County Schools 180825002294 90 Carroll Middle School   Regular School No Middle 06 08 2021   grade_6                         167.0 147.0                       314.0                         167 147                 314
1919128 1919128 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 06 11 2021   grade_6                         1.0 0.0                       1.0                         1 0                 1
1159662 1159662 IN     school 1803630 235   Fort Wayne Community Schools 180363000516 107 Blackhawk Middle School   Regular School No 2.0 06 08 2015   grade_6                         142.0 135.0                       277.0                         142 135                 277
1281054 1281054 IN     school 1803630 235   Fort Wayne Community Schools 180363000516 107 Blackhawk Middle School   Regular School No 2.0 06 08 2016   grade_6                         148.0 137.0                       285.0                         148 137                 285
1293115 1293115 IN     school 1803630 235   Fort Wayne Community Schools 180363000516 107 Blackhawk Middle School   Regular School No Middle 06 08 2017   grade_6                         111.0 132.0                       243.0                         111 132                 243
1751740 1751740 IN     school 1803630 235   Fort Wayne Community Schools 180363000516 107 Blackhawk Middle School   Regular School No Middle 06 08 2019   grade_6                         135.0 134.0                       269.0                         135 134                 269
1787484 1787484 IN     school 1803630 235   Fort Wayne Community Schools 180363000516 107 Blackhawk Middle School   Regular School No Middle 06 08 2018   grade_6                         156.0 126.0                       282.0                         156 126                 282
1907180 1907180 IN     school 1803630 235   Fort Wayne Community Schools 180363000516 107 Blackhawk Middle School   Regular School No Middle 06 08 2020   grade_6                         144.0 143.0                       287.0                         144 143                 287
1919146 1919146 IN     school 1803630 235   Fort Wayne Community Schools 180363000516 107 Blackhawk Middle School   Regular School No Middle 06 08 2021   grade_6                         129.0 136.0                       265.0                         129 136                 265
1758280 1758280 IN     school 1804770 5385   Indianapolis Public Schools 180477002651 108 Impact Academy   Regular School No Other 03 12 2019   grade_6                         8.0 5.0                       13.0                         8 5                 13
1913710 1913710 IN     school 1804770 5385   Indianapolis Public Schools 180477002651 108 Impact Academy   Regular School No Other 03 12 2020   grade_6                         6.0 2.0                       8.0                         6 2                 8
1925614 1925614 IN     school 1804770 5385   Indianapolis Public Schools 180477002651 108 Impact Academy   Regular School No Other 03 12 2021   grade_6                         1.0 1.0                       2.0                         1 1                 2
1159671 1159671 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No 1.0 01 08 2015   grade_6                         40.0 43.0                       83.0                         40 43                 83
1281063 1281063 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No 1.0 01 08 2016   grade_6                         38.0 31.0                       69.0                         38 31                 69
1293124 1293124 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2017   grade_6                         38.0 38.0                       76.0                         38 38                 76
1751749 1751749 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2019   grade_6                         33.0 40.0                       73.0                         33 40                 73
1787493 1787493 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2018   grade_6                         46.0 40.0                       86.0                         46 40                 86
1907189 1907189 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2020   grade_6                         35.0 42.0                       77.0                         35 42                 77
1919155 1919155 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2021   grade_6                         41.0 34.0                       75.0                         41 34                 75
1159675 1159675 IN     school 1803630 235   Fort Wayne Community Schools 180363000534 119 Jefferson Middle School   Regular School No 2.0 06 08 2015   grade_6                         120.0 112.0                       232.0                         120 112                 232
1281067 1281067 IN     school 1803630 235   Fort Wayne Community Schools 180363000534 119 Jefferson Middle School   Regular School No 2.0 06 08 2016   grade_6                         102.0 129.0                       231.0                         102 129                 231
1293128 1293128 IN     school 1803630 235   Fort Wayne Community Schools 180363000534 119 Jefferson Middle School   Regular School No Middle 06 08 2017   grade_6                         144.0 111.0                       255.0                         144 111                 255
1751753 1751753 IN     school 1803630 235   Fort Wayne Community Schools 180363000534 119 Jefferson Middle School   Regular School No Middle 06 08 2019   grade_6                         114.0 125.0                       239.0                         114 125                 239
1787497 1787497 IN     school 1803630 235   Fort Wayne Community Schools 180363000534 119 Jefferson Middle School   Regular School No Middle 06 08 2018   grade_6                         109.0 118.0                       227.0                         109 118                 227
1907193 1907193 IN     school 1803630 235   Fort Wayne Community Schools 180363000534 119 Jefferson Middle School   Regular School No Middle 06 08 2020   grade_6                         132.0 146.0                       278.0                         132 146                 278
1919159 1919159 IN     school 1803630 235   Fort Wayne Community Schools 180363000534 119 Jefferson Middle School   Regular School No Middle 06 08 2021   grade_6                         125.0 98.0                       223.0                         125 98                 223
1159679 1159679 IN     school 1803630 235   Fort Wayne Community Schools 180363000537 121 Kekionga Middle School   Regular School No 2.0 06 08 2015   grade_6                         113.0 80.0                       193.0                         113 80                 193
1281071 1281071 IN     school 1803630 235   Fort Wayne Community Schools 180363000537 121 Kekionga Middle School   Regular School No 2.0 06 08 2016   grade_6                         83.0 79.0                       162.0                         83 79                 162
1293132 1293132 IN     school 1803630 235   Fort Wayne Community Schools 180363000537 121 Kekionga Middle School   Regular School No Middle 06 08 2017   grade_6                         103.0 84.0                       187.0                         103 84                 187
1751757 1751757 IN     school 1803630 235   Fort Wayne Community Schools 180363000537 121 Kekionga Middle School   Regular School No Middle 06 08 2019   grade_6                         99.0 96.0                       195.0                         99 96                 195
1787501 1787501 IN     school 1803630 235   Fort Wayne Community Schools 180363000537 121 Kekionga Middle School   Regular School No Middle 06 08 2018   grade_6                         80.0 69.0                       149.0                         80 69                 149
1907197 1907197 IN     school 1803630 235   Fort Wayne Community Schools 180363000537 121 Kekionga Middle School   Regular School No Middle 06 08 2020   grade_6                         97.0 91.0                       188.0                         97 91                 188
1919163 1919163 IN     school 1803630 235   Fort Wayne Community Schools 180363000537 121 Kekionga Middle School   Regular School No Middle 06 08 2021   grade_6                         107.0 108.0                       215.0                         107 108                 215
1159683 1159683 IN     school 1803630 235   Fort Wayne Community Schools 180363000538 125 Lakeside Middle School   Regular School No 2.0 06 08 2015   grade_6                         72.0 61.0                       133.0                         72 61                 133
1281075 1281075 IN     school 1803630 235   Fort Wayne Community Schools 180363000538 125 Lakeside Middle School   Regular School No 2.0 06 08 2016   grade_6                         83.0 58.0                       141.0                         83 58                 141
1293136 1293136 IN     school 1803630 235   Fort Wayne Community Schools 180363000538 125 Lakeside Middle School   Regular School No Middle 06 08 2017   grade_6                         82.0 95.0                       177.0                         82 95                 177
1751761 1751761 IN     school 1803630 235   Fort Wayne Community Schools 180363000538 125 Lakeside Middle School   Regular School No Middle 06 08 2019   grade_6                         86.0 87.0                       173.0                         86 87                 173
1787505 1787505 IN     school 1803630 235   Fort Wayne Community Schools 180363000538 125 Lakeside Middle School   Regular School No Middle 06 08 2018   grade_6                         91.0 85.0                       176.0                         91 85                 176

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