enrollments

Data source: Big Local News · About: Big Local

511 rows where grade = "grade_7", state = "IN" and year = 2017 sorted by ccd_school_low_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 511 ✖

grade ✖

  • grade_7 · 511 ✖
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
1299678 1299678 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_7                         10.0 2.0                       12.0                         10 2                 12
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
1295138 1295138 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2017   grade_7                         5.0 1.0                       6.0                         5 1                 6
1303929 1303929 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other 01 12 2017   grade_7                         2.0 0.0                       2.0                         2 0                 2
1294814 1294814 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 02 12 2017   grade_7                         5.0 4.0                       9.0                         5 4                 9
1300025 1300025 IN     school 1804770 5385   Indianapolis Public Schools 180477002439 5577 Merle Sidener Gifted Academy   Regular School No Elementary 02 08 2017   grade_7                         28.0 30.0                       58.0                         28 30                 58
1296826 1296826 IN     school 1804470 3490   Western School Corporation 180447002224 2923 Western Intermediate School   Regular School No Elementary 03 08 2017   grade_7                         1.0 1.0                       2.0                         1 1                 2
1302108 1302108 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Oaklawn Campus Program   Special Education School No Other 03 12 2017   grade_7                         4.0 3.0                       7.0                         4 3                 7
1302233 1302233 IN     school 1810290 7205   South Bend Community School Corp 181029002296 7521 Brown Intermediate Center   Regular School No Elementary 03 08 2017   grade_7                         47.0 32.0                       79.0                         47 32                 79
1303576 1303576 IN     school 1812180 8050   M S D Wabash County Schools 181218002178 8657 Sharp Creek Elementary School   Regular School No Elementary 03 07 2017   grade_7                         1.0 0.0                       1.0                         1 0                 1
1294143 1294143 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No Other 04 12 2017   grade_7                         7.0 3.0                       10.0                         7 3                 10
1294980 1294980 IN     school 1802400 2270   Concord Community Schools 180240002484 1718 Concord Intermediate School   Regular School No Elementary 04 07 2017   grade_7                         1.0 0.0                       1.0                         1 0                 1
1296563 1296563 IN     school 1802550 3325   Danville Community School Corp 180255000305 2743 Danville Middle School   Regular School No Elementary 04 08 2017   grade_7                         105.0 85.0                       190.0                         105 85                 190
1296745 1296745 IN     school 1801060 3455   C A Beard Memorial School Corp 180106002012 2870 Knightstown Intermediate School   Regular School No Elementary 04 08 2017   grade_7                         49.0 38.0                       87.0                         49 38                 87
1300489 1300489 IN     school 1808850 5635   Peru Community Schools 180885001477 6089 Peru Junior High School   Regular School No Elementary 04 08 2017   grade_7                         94.0 77.0                       171.0                         94 77                 171
1304671 1304671 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes Other 04 12 2017   grade_7                         5.0 0.0                       5.0                         5 0                 5
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
1293712 1293712 IN     school 1802830 630   Zionsville Community Schools 180283002046 510 Zionsville West Middle School   Regular School No Middle 05 08 2017   grade_7                         145.0 112.0                       257.0                         145 112                 257
1293718 1293718 IN     school 1802830 630   Zionsville Community Schools 180283000342 511 Zionsville Middle School   Regular School No Middle 05 08 2017   grade_7                         155.0 152.0                       307.0                         155 152                 307
1294008 1294008 IN     school 1801920 1000   Clarksville Community School Corp 180192000248 851 Clarksville Middle School   Regular School No Middle 05 08 2017   grade_7                         54.0 54.0                       108.0                         54 54                 108
1294831 1294831 IN     school 1808120 2040   Northeast Dubois Co Sch Corp 180812001391 1549 Dubois Middle School   Regular School No Middle 05 08 2017   grade_7                         39.0 33.0                       72.0                         39 33                 72
1295014 1295014 IN     school 1806600 2275   Middlebury Community Schools 180660001162 1657 Northridge Middle School   Regular School No Other 05 10 2017   grade_7                         173.0 198.0                       371.0                         173 198                 371
1295371 1295371 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741002057 1931 Highland Hills Middle School   Regular School No Middle 05 08 2017   grade_7                         209.0 195.0                       404.0                         209 195                 404
1295376 1295376 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001271 1933 Hazelwood Middle School   Regular School No Middle 05 08 2017   grade_7                         119.0 109.0                       228.0                         119 109                 228
1295381 1295381 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001276 1937 Nathaniel Scribner Middle School   Regular School No Middle 05 08 2017   grade_7                         106.0 127.0                       233.0                         106 127                 233
1295502 1295502 IN     school 1803700 2475   Franklin County Community Sch Corp 180370000589 2123 Brookville Middle School   Regular School No Middle 05 08 2017   grade_7                         54.0 57.0                       111.0                         54 57                 111
1295778 1295778 IN     school 1803090 2940   Eastern Greene Schools 180309002419 2436 Eastern Greene Middle School   Regular School No Middle 05 08 2017   grade_7                         44.0 60.0                       104.0                         44 60                 104
1295820 1295820 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 07 2017   grade_7                         36.0 30.0                       66.0                         36 30                 66
1295915 1295915 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000133 2489 Hamilton SE Int and Jr High Sch   Regular School No Middle 05 08 2017   grade_7                         160.0 129.0                       289.0                         160 129                 289
1297735 1297735 IN     school 1809300 4515   Prairie Heights Community Sch Corp 180930001525 3688 Prairie Heights Middle School   Regular School No Middle 05 08 2017   grade_7                         53.0 57.0                       110.0                         53 57                 110
1297863 1297863 IN     school 1809690 4600   Merrillville Community School Corp 180969001581 3813 Merrillville Intermediate School   Regular School No Middle 05 07 2017   grade_7                         1.0 0.0                       1.0                         1 0                 1
1297898 1297898 IN     school 1805450 4615   Lake Central School Corporation 180545000985 3831 Michael Grimmer Middle School   Regular School No Middle 05 08 2017   grade_7                         106.0 108.0                       214.0                         106 108                 214
1297915 1297915 IN     school 1805450 4615   Lake Central School Corporation 180545002420 3838 Hal E Clark Middle School   Regular School No Middle 05 08 2017   grade_7                         171.0 149.0                       320.0                         171 149                 320
1297934 1297934 IN     school 1805450 4615   Lake Central School Corporation 180545000982 3841 Kahler Middle School   Regular School No Middle 05 08 2017   grade_7                         136.0 118.0                       254.0                         136 118                 254
1300349 1300349 IN     school 1809060 5485   Plymouth Community School Corp 180906001499 5949 Lincoln Junior High School   Regular School No Middle 05 08 2017   grade_7                         146.0 137.0                       283.0                         146 137                 283
1300413 1300413 IN     school 1806060 5525   Loogootee Community Sch Corp 180606001070 6001 Loogootee Middle School   Regular School No Middle 05 08 2017   grade_7                         38.0 33.0                       71.0                         38 33                 71
1301053 1301053 IN     school 1812900 6065   West Noble School Corporation 181290002059 6509 West Noble Middle School   Regular School No Middle 05 08 2017   grade_7                         93.0 99.0                       192.0                         93 99                 192
1301731 1301731 IN     school 1802220 6750   Cloverdale Community Schools 180222001283 7085 Cloverdale Middle School   Regular School No Middle 05 08 2017   grade_7                         45.0 40.0                       85.0                         45 40                 85
1302171 1302171 IN     school 1810290 7205   South Bend Community School Corp 181029001656 7321 Greene Intermediate Center   Regular School No Middle 05 08 2017   grade_7                         21.0 29.0                       50.0                         21 29                 50
1302188 1302188 IN     school 1810290 7205   South Bend Community School Corp 181029001650 7425 Clay Intermediate Center   Regular School No Middle 05 08 2017   grade_7                         43.0 56.0                       99.0                         43 56                 99
1302211 1302211 IN     school 1810290 7205   South Bend Community School Corp 181029001645 7510 Jackson Intermediate Center   Regular School No Middle 05 08 2017   grade_7                         67.0 41.0                       108.0                         67 41                 108
1302216 1302216 IN     school 1810290 7205   South Bend Community School Corp 181029001709 7512 LaSalle Intermediate Academy   Regular School No Middle 05 08 2017   grade_7                         91.0 107.0                       198.0                         91 107                 198
1302248 1302248 IN     school 1810290 7205   South Bend Community School Corp 181029001681 7537 Edison Intermediate Center   Regular School No Middle 05 08 2017   grade_7                         60.0 50.0                       110.0                         60 50                 110
1302266 1302266 IN     school 1810290 7205   South Bend Community School Corp 181029001682 7549 Jefferson Intermediate Center   Regular School No Middle 05 08 2017   grade_7                         78.0 77.0                       155.0                         78 77                 155
1302279 1302279 IN     school 1810290 7205   South Bend Community School Corp 181029001661 7559 Dickinson Fine Arts Academy   Regular School No Middle 05 08 2017   grade_7                         74.0 76.0                       150.0                         74 76                 150
1302310 1302310 IN     school 1810290 7205   South Bend Community School Corp 181029001666 7581 Marshall Intermediate Center   Regular School No Middle 05 08 2017   grade_7                         45.0 44.0                       89.0                         45 44                 89
1302334 1302334 IN     school 1810290 7205   South Bend Community School Corp 181029001679 7597 Navarre Intermediate Center   Regular School No Middle 05 08 2017   grade_7                         68.0 72.0                       140.0                         68 72                 140
1302485 1302485 IN     school 1808310 7350   Northwestern Con School Corp 180831001425 7697 Triton Central Middle School   Regular School No Middle 05 08 2017   grade_7                         61.0 47.0                       108.0                         61 47                 108
1302681 1302681 IN     school 1803780 7605   Fremont Community Schools 180378000177 7884 Fremont Middle School   Regular School No Middle 05 08 2017   grade_7                         35.0 32.0                       67.0                         35 32                 67
1303598 1303598 IN     school 1812150 8060   Wabash City Schools 181215002301 8694 Wabash Middle School   Regular School No Middle 05 08 2017   grade_7                         59.0 48.0                       107.0                         59 48                 107
1303773 1303773 IN     school 1803000 8215   East Washington School Corp 180300000073 8906 East Washington Middle School   Regular School No Middle 05 08 2017   grade_7                         54.0 55.0                       109.0                         54 55                 109
1303870 1303870 IN     school 1809510 8385   Richmond Community Schools 180951001561 8997 Test Intermediate School   Regular School No Middle 05 08 2017   grade_7                         98.0 76.0                       174.0                         98 76                 174
1303875 1303875 IN     school 1809510 8385   Richmond Community Schools 180951001555 9001 Dennis Intermediate School   Regular School No Middle 05 08 2017   grade_7                         85.0 84.0                       169.0                         85 84                 169
1303980 1303980 IN     school 1800720 8445   M S D Bluffton-Harrison 180072000147 9093 Bluffton-Harrison Middle School   Regular School No Middle 05 08 2017   grade_7                         75.0 64.0                       139.0                         75 64                 139
1304940 1304940 IN     school 1800164 9965   Career Academy Middle School 180016402593 7563 Career Academy Middle School   Regular School Yes Middle 05 08 2017   grade_7                         59.0 52.0                       111.0                         59 52                 111
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
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
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
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
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
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
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
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
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
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
1293141 1293141 IN     school 1803630 235   Fort Wayne Community Schools 180363000539 126 Lane Middle School   Regular School No Middle 06 08 2017   grade_7                         99.0 114.0                       213.0                         99 114                 213
1293145 1293145 IN     school 1803630 235   Fort Wayne Community Schools 180363000546 127 Memorial Park Middle School   Regular School No Middle 06 08 2017   grade_7                         80.0 111.0                       191.0                         80 111                 191
1293149 1293149 IN     school 1803630 235   Fort Wayne Community Schools 180363000548 128 Miami Middle School   Regular School No Middle 06 08 2017   grade_7                         95.0 87.0                       182.0                         95 87                 182
1293153 1293153 IN     school 1803630 235   Fort Wayne Community Schools 180363000553 129 Northwood Middle School   Regular School No Middle 06 08 2017   grade_7                         110.0 100.0                       210.0                         110 100                 210
1293157 1293157 IN     school 1803630 235   Fort Wayne Community Schools 180363000555 133 Portage Middle School   Regular School No Middle 06 08 2017   grade_7                         73.0 62.0                       135.0                         73 62                 135
1293342 1293342 IN     school 1803630 235   Fort Wayne Community Schools 180363000560 240 Shawnee Middle School   Regular School No Middle 06 08 2017   grade_7                         91.0 102.0                       193.0                         91 102                 193
1293472 1293472 IN     school 1802850 255   East Allen County Schools 180285000354 301 New Haven Middle School   Regular School No Middle 06 08 2017   grade_7                         72.0 74.0                       146.0                         72 74                 146
1293775 1293775 IN     school 1805790 665   Lebanon Community School Corp 180579001040 557 Lebanon Middle School   Regular School No Middle 06 08 2017   grade_7                         126.0 128.0                       254.0                         126 128                 254
1293851 1293851 IN     school 1802700 755   Delphi Community School Corp 180270000327 609 Delphi Community Middle School   Regular School No Middle 06 08 2017   grade_7                         64.0 63.0                       127.0                         64 63                 127
1293904 1293904 IN     school 1806030 875   Logansport Community Sch Corp 180603001058 702 Lincoln Middle School   Regular School No Middle 06 08 2017   grade_7                         73.0 98.0                       171.0                         73 98                 171
1293938 1293938 IN     school 1806030 875   Logansport Community Sch Corp 180603001052 715 Columbia Middle School   Regular School No Middle 06 08 2017   grade_7                         71.0 67.0                       138.0                         71 67                 138
1293965 1293965 IN     school 1809370 940   West Clark Community Schools 180937001537 781 Silver Creek Middle School   Regular School No Middle 06 08 2017   grade_7                         100.0 111.0                       211.0                         100 111                 211
1294055 1294055 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No Other 06 12 2017   grade_7                         23.0 31.0                       54.0                         23 31                 54
1294086 1294086 IN     school 1803940 1010   Greater Clark County Schools 180394000674 853 Parkview Middle School   Regular School No Middle 06 08 2017   grade_7                         151.0 100.0                       251.0                         151 100                 251
1294090 1294090 IN     school 1803940 1010   Greater Clark County Schools 180394002128 863 Charlestown Middle School   Regular School No Middle 06 08 2017   grade_7                         88.0 72.0                       160.0                         88 72                 160
1294134 1294134 IN     school 1803940 1010   Greater Clark County Schools 180394002131 883 River Valley Middle School   Regular School No Middle 06 08 2017   grade_7                         161.0 158.0                       319.0                         161 158                 319
1294151 1294151 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No Other 06 12 2017   grade_7                         5.0 0.0                       5.0                         5 0                 5
1294192 1294192 IN     school 1800840 1125   Clay Community Schools 180084000165 925 North Clay Middle School   Regular School No Middle 06 08 2017   grade_7                         137.0 139.0                       276.0                         137 139                 276
1294261 1294261 IN     school 1803660 1170   Community Schools of Frankfort 180366000573 999 Frankfort Middle School   Regular School No Middle 06 08 2017   grade_7                         123.0 104.0                       227.0                         123 104                 227
1294285 1294285 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No Other 06 12 2017   grade_7                         44.0 40.0                       84.0                         44 40                 84
1294318 1294318 IN     school 1802440 1300   Crawford County Community Sch Corp 180244000282 1061 Crawford County Middle School   Regular School No Middle 06 08 2017   grade_7                         58.0 58.0                       116.0                         58 58                 116
1294333 1294333 IN     school 1800330 1315   Barr-Reeve Community Schools Inc 180033000061 1069 Barr Reeve Middle/High School   Regular School No Other 06 12 2017   grade_7                         28.0 29.0                       57.0                         28 29                 57
1294409 1294409 IN     school 1811190 1560   Sunman-Dearborn Com Sch Corp 181119002300 1190 Sunman-Dearborn Middle School   Regular School No Middle 06 08 2017   grade_7                         155.0 145.0                       300.0                         155 145                 300
1294481 1294481 IN     school 1805700 1620   Lawrenceburg Community School Corp 180570001036 1209 Greendale Middle School   Regular School No Middle 06 08 2017   grade_7                         77.0 84.0                       161.0                         77 84                 161
1294531 1294531 IN     school 1804080 1730   Greensburg Community Schools 180408000705 1269 Greensburg Community Jr High   Regular School No Middle 06 08 2017   grade_7                         77.0 95.0                       172.0                         77 95                 172
1294579 1294579 IN     school 1803840 1820   Garrett-Keyser-Butler Com Sch Corp 180384001389 1331 Garrett Middle School   Regular School No Middle 06 08 2017   grade_7                         61.0 72.0                       133.0                         61 72                 133
1294597 1294597 IN     school 1801590 1835   DeKalb Co Ctl United Sch Dist 180159000221 1346 DeKalb Middle School   Regular School No Middle 06 08 2017   grade_7                         131.0 126.0                       257.0                         131 126                 257
1294630 1294630 IN     school 1802660 1875   Delaware Community School Corp 180266000323 1367 Delta Middle School   Regular School No Middle 06 08 2017   grade_7                         110.0 93.0                       203.0                         110 93                 203
1294656 1294656 IN     school 1804500 1885   Wes-Del Community Schools 180450000761 1372 Wes-Del Middle/Senior High School   Regular School No Other 06 12 2017   grade_7                         39.0 34.0                       73.0                         39 34                 73
1294673 1294673 IN     school 1805880 1895   Liberty-Perry Community Sch Corp 180588001046 1377 Selma Middle School   Regular School No Middle 06 08 2017   grade_7                         49.0 46.0                       95.0                         49 46                 95
1294699 1294699 IN     school 1807230 1910   Yorktown Community Schools 180723001218 1387 Yorktown Middle School   Regular School No Middle 06 08 2017   grade_7                         95.0 102.0                       197.0                         95 102                 197
1294744 1294744 IN     school 1807320 1970   Muncie Community Schools 180732002320 1431 Northside Middle School   Regular School No Middle 06 08 2017   grade_7                         118.0 97.0                       215.0                         118 97                 215
1294748 1294748 IN     school 1807320 1970   Muncie Community Schools 180732001252 1437 Southside Middle School   Regular School No Middle 06 08 2017   grade_7                         101.0 91.0                       192.0                         101 91                 192
1294874 1294874 IN     school 1810870 2110   Southwest Dubois Co Sch Corp 181087001777 1587 Southridge Middle School   Regular School No Middle 06 08 2017   grade_7                         55.0 66.0                       121.0                         55 66                 121
1294898 1294898 IN     school 1803960 2120   Greater Jasper Consolidated Schs 180396000686 1575 Jasper Middle School   Regular School No Middle 06 08 2017   grade_7                         141.0 125.0                       266.0                         141 125                 266

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