enrollments

Data source: Big Local News · About: Big Local

507 rows where grade = "grade_8", state = "IN" and year = 2017 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 507 ✖

grade ✖

  • grade_8 · 507 ✖
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
1296684 1296684 IN     school 1807440 3445   New Castle Community School Corp 180744001290 2825 New Castle High School   Regular School No High 08 12 2017   grade_8                         1.0 0.0                       1.0                         1 0                 1
1296827 1296827 IN     school 1804470 3490   Western School Corporation 180447002224 2923 Western Intermediate School   Regular School No Elementary 03 08 2017   grade_8                         0.0 1.0                       1.0                         0 1                 1
1298038 1298038 IN     school 1802490 4660   Crown Point Community School Corp 180249000293 3901 Crown Point High School   Regular School No High 08 12 2017   grade_8                         1.0 0.0                       1.0                         1 0                 1
1302365 1302365 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 07 12 2017   grade_8                         1.0 0.0                       1.0                         1 0                 1
1304155 1304155 IN     school 1800006 9100   Indiana Department of Corrections 180000601996 4846 Camp Summit Juvenile Facility   Regular School No High 08 12 2017   grade_8                         1.0 0.0                       1.0                         1 0                 1
1304169 1304169 IN     school 1800006 9100   Indiana Department of Corrections 180000601943 5452 Madison Juvenile Correctional   Regular School No High 08 12 2017   grade_8                         0.0 1.0                       1.0                         0 1                 1
1304162 1304162 IN     school 1800006 9100   Indiana Department of Corrections 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2017   grade_8                         10.0 0.0                       10.0                         10 0                 10
1304754 1304754 IN     school 1800087 9845   Xavier School of Excellence 180008702445 7571 Xavier School of Excellence   Regular School Yes Elementary KG 08 2017   grade_8                         3.0 7.0                       10.0                         3 7                 10
1295668 1295668 IN     school 1803030 2815   Eastbrook Community Sch Corp 180303002273 2299 Eastbrook Junior High School   Regular School No Middle 07 08 2017   grade_8                         48.0 52.0                       100.0                         48 52                 100
1299026 1299026 IN     school 1803300 5280   Elwood Community School Corp 180330000449 5149 Elwood Jr-Sr High School   Regular School No High 07 12 2017   grade_8                         53.0 47.0                       100.0                         53 47                 100
1304321 1304321 IN     school 1800028 9400   KIPP Indy College Prep Middle 180002802136 5860 KIPP Indy College Prep Middle   Regular School Yes Middle 06 08 2017   grade_8                         53.0 47.0                       100.0                         53 47                 100
1301677 1301677 IN     school 1810500 6705   South Putnam Community Schools 181050002542 7056 South Putnam Middle School   Regular School No Middle 06 08 2017   grade_8                         56.0 45.0                       101.0                         56 45                 101
1302189 1302189 IN     school 1810290 7205   South Bend Community School Corp 181029001650 7425 Clay Intermediate Center   Regular School No Middle 05 08 2017   grade_8                         50.0 51.0                       101.0                         50 51                 101
1303774 1303774 IN     school 1803000 8215   East Washington School Corp 180300000073 8906 East Washington Middle School   Regular School No Middle 05 08 2017   grade_8                         50.0 51.0                       101.0                         50 51                 101
1295674 1295674 IN     school 1806240 2825   Madison-Grant United School Corp 180624001097 2321 Madison-Grant Jr./Sr. High School   Regular School No High 07 12 2017   grade_8                         55.0 47.0                       102.0                         55 47                 102
1300943 1300943 IN     school 1807920 5945   North Newton School Corp 180792001363 6411 North Newton Jr-Sr High School   Regular School No High 07 12 2017   grade_8                         50.0 52.0                       102.0                         50 52                 102
1292916 1292916 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2017   grade_8                         48.0 55.0                       103.0                         48 55                 103
1302311 1302311 IN     school 1810290 7205   South Bend Community School Corp 181029001666 7581 Marshall Intermediate Center   Regular School No Middle 05 08 2017   grade_8                         51.0 52.0                       103.0                         51 52                 103
1293890 1293890 IN     school 1810680 815   Southeastern School Corp 181068001755 689 Lewis Cass Jr-Sr High School   Regular School No High 07 12 2017   grade_8                         44.0 61.0                       105.0                         44 61                 105
1298909 1298909 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002418 5012 Lapel Middle School   Regular School No Middle 06 08 2017   grade_8                         65.0 40.0                       105.0                         65 40                 105
1303538 1303538 IN     school 1806270 8045   Manchester Community Schools 180627001103 8625 Manchester Jr-Sr High School   Regular School No High 07 12 2017   grade_8                         59.0 46.0                       105.0                         59 46                 105
1297712 1297712 IN     school 1813230 4455   Whitko Community School Corp 181323000068 3644 Whitko Middle School   Regular School No Middle 06 08 2017   grade_8                         65.0 41.0                       106.0                         65 41                 106
1295779 1295779 IN     school 1803090 2940   Eastern Greene Schools 180309002419 2436 Eastern Greene Middle School   Regular School No Middle 05 08 2017   grade_8                         72.0 37.0                       109.0                         72 37                 109
1301811 1301811 IN     school 1801770 6825   Randolph Central School Corp 180177000235 7129 Lee L Driver Middle School   Regular School No Middle 06 08 2017   grade_8                         63.0 46.0                       109.0                         63 46                 109
1298180 1298180 IN     school 1803870 4690   Gary Community School Corp 180387000617 4081 Dr Bernard C Watson Acad for Boys   Regular School No Elementary KG 08 2017   grade_8                         11.0 0.0                       11.0                         11 0                 11
1302688 1302688 IN     school 1804230 7610   Hamilton Community Schools 180423000724 7885 Hamilton Community High School   Regular School No High 07 12 2017   grade_8                         9.0 2.0                       11.0                         9 2                 11
1304960 1304960 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Elementary KG 08 2017   grade_8                         5.0 6.0                       11.0                         5 6                 11
1297032 1297032 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105000181 3107 Brownstown Central Middle School   Regular School No Middle 06 08 2017   grade_8                         59.0 51.0                       110.0                         59 51                 110
1297228 1297228 IN     school 1810800 4000   Southwestern-Jefferson Co Con 181080002547 3343 Southwestern Middle School   Regular School No Middle 06 08 2017   grade_8                         64.0 46.0                       110.0                         64 46                 110
1300766 1300766 IN     school 1804140 5900   Monroe-Gregg School District 180414002129 6315 Monrovia Middle School   Regular School No Middle 06 08 2017   grade_8                         62.0 48.0                       110.0                         62 48                 110
1292952 1292952 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No Middle 06 08 2017   grade_8                         65.0 48.0                       113.0                         65 48                 113
1294547 1294547 IN     school 1803060 1805   DeKalb Co Eastern Com Sch Dist 180306000405 1317 Eastside Junior-Senior High School   Regular School No High 07 12 2017   grade_8                         64.0 49.0                       113.0                         64 49                 113
1294319 1294319 IN     school 1802440 1300   Crawford County Community Sch Corp 180244000282 1061 Crawford County Middle School   Regular School No Middle 06 08 2017   grade_8                         59.0 55.0                       114.0                         59 55                 114
1298253 1298253 IN     school 1803870 4690   Gary Community School Corp 180387002104 4169 Daniel Hale Williams Elem Sch   Regular School No Elementary KG 08 2017   grade_8                         70.0 45.0                       115.0                         70 45                 115
1303251 1303251 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000477 8339 McGary Middle School   Regular School No Middle 06 08 2017   grade_8                         63.0 52.0                       115.0                         63 52                 115
1293852 1293852 IN     school 1802700 755   Delphi Community School Corp 180270000327 609 Delphi Community Middle School   Regular School No Middle 06 08 2017   grade_8                         61.0 55.0                       116.0                         61 55                 116
1295788 1295788 IN     school 1805910 2950   Linton-Stockton School Corporation 180591002147 2438 Linton-Stockton Jr High School   Regular School No Middle 06 08 2017   grade_8                         61.0 56.0                       117.0                         61 56                 117
1298815 1298815 IN     school 1807860 5075   North Lawrence Com Schools 180786000446 4878 Oolitic Middle School   Regular School No Middle 06 08 2017   grade_8                         53.0 64.0                       117.0                         53 64                 117
1303981 1303981 IN     school 1800720 8445   M S D Bluffton-Harrison 180072000147 9093 Bluffton-Harrison Middle School   Regular School No Middle 05 08 2017   grade_8                         60.0 58.0                       118.0                         60 58                 118
1295503 1295503 IN     school 1803700 2475   Franklin County Community Sch Corp 180370000589 2123 Brookville Middle School   Regular School No Middle 05 08 2017   grade_8                         56.0 63.0                       119.0                         56 63                 119
1301421 1301421 IN     school 1811700 6530   Union Township School Corp 181170000793 6843 Union Township Middle School   Regular School No Middle 06 08 2017   grade_8                         62.0 57.0                       119.0                         62 57                 119
1301709 1301709 IN     school 1807980 6715   North Putnam Community Schools 180798000316 7049 North Putnam Middle School   Regular School No Middle 06 08 2017   grade_8                         60.0 59.0                       119.0                         60 59                 119
1303930 1303930 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other 01 12 2017   grade_8                         8.0 4.0                       12.0                         8 4                 12
1304291 1304291 IN     school 1800143 9375   IN Math & Science Academy - South 180014302561 5671 IN Math & Science Academy - South   Regular School Yes Elementary KG 08 2017   grade_8                         5.0 7.0                       12.0                         5 7                 12
1304873 1304873 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other KG 12 2017   grade_8                         10.0 2.0                       12.0                         10 2                 12
1296626 1296626 IN     school 1806660 3335   Mill Creek Community Sch Corp 180666001170 2687 Cascade Middle School   Regular School No Middle 06 08 2017   grade_8                         63.0 57.0                       120.0                         63 57                 120
1300331 1300331 IN     school 1800900 5480   Bremen Public Schools 180090000166 5943 Bremen Elementary/Middle School   Regular School No Elementary KG 08 2017   grade_8                         59.0 61.0                       120.0                         59 61                 120
1294875 1294875 IN     school 1810870 2110   Southwest Dubois Co Sch Corp 181087001777 1587 Southridge Middle School   Regular School No Middle 06 08 2017   grade_8                         65.0 56.0                       121.0                         65 56                 121
1299794 1299794 IN     school 1804770 5385   Indianapolis Public Schools 180477002526 5513 George Washington Comm Jr HS   Regular School No Middle 07 08 2017   grade_8                         71.0 50.0                       121.0                         71 50                 121
1296679 1296679 IN     school 1808280 3435   Shenandoah School Corporation 180828001421 2819 Shenandoah Middle School   Regular School No Middle 06 08 2017   grade_8                         60.0 62.0                       122.0                         60 62                 122
1298890 1298890 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002050 5005 Frankton Jr-Sr High School   Regular School No High 07 12 2017   grade_8                         61.0 61.0                       122.0                         61 61                 122
1293158 1293158 IN     school 1803630 235   Fort Wayne Community Schools 180363000555 133 Portage Middle School   Regular School No Middle 06 08 2017   grade_8                         75.0 49.0                       124.0                         75 49                 124
1295530 1295530 IN     school 1809630 2645   Rochester Community School Corp 180963001577 2177 Rochester Community Middle School   Regular School No Middle 06 08 2017   grade_8                         64.0 60.0                       124.0                         64 60                 124
1297107 1297107 IN     school 1809420 3815   Rensselaer Central School Corp 180942001544 3221 Rensselaer Middle School   Regular School No Middle 06 08 2017   grade_8                         71.0 53.0                       124.0                         71 53                 124
1298879 1298879 IN     school 1806900 5085   Mitchell Community Schools 180690002151 4924 Mitchell Jr High School   Regular School No Middle 06 08 2017   grade_8                         58.0 66.0                       124.0                         58 66                 124
1302212 1302212 IN     school 1810290 7205   South Bend Community School Corp 181029001645 7510 Jackson Intermediate Center   Regular School No Middle 05 08 2017   grade_8                         66.0 58.0                       124.0                         66 58                 124
1302486 1302486 IN     school 1808310 7350   Northwestern Con School Corp 180831001425 7697 Triton Central Middle School   Regular School No Middle 05 08 2017   grade_8                         57.0 67.0                       124.0                         57 67                 124
1303599 1303599 IN     school 1812150 8060   Wabash City Schools 181215002301 8694 Wabash Middle School   Regular School No Middle 05 08 2017   grade_8                         61.0 63.0                       124.0                         61 63                 124
1293674 1293674 IN     school 1800570 515   Blackford County Schools 180057000103 491 Blackford Junior High School   Regular School No Middle 07 08 2017   grade_8                         64.0 61.0                       125.0                         64 61                 125
1300696 1300696 IN     school 1807900 5835   North Montgomery Com Sch Corp 180790002293 6244 Northridge Middle School   Regular School No Middle 06 08 2017   grade_8                         55.0 70.0                       125.0                         55 70                 125
1297843 1297843 IN     school 1804620 4590   River Forest Community Sch Corp 180462000780 3801 River Forest Middle School   Regular School No Middle 06 08 2017   grade_8                         76.0 50.0                       126.0                         76 50                 126
1298955 1298955 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No High 07 12 2017   grade_8                         58.0 69.0                       127.0                         58 69                 127
1304410 1304410 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes Other KG 12 2017   grade_8                         65.0 62.0                       127.0                         65 62                 127
1302335 1302335 IN     school 1810290 7205   South Bend Community School Corp 181029001679 7597 Navarre Intermediate Center   Regular School No Middle 05 08 2017   grade_8                         73.0 56.0                       129.0                         73 56                 129
1303052 1303052 IN     school 1811610 7950   Union Co/Clg Corner Joint Sch Dist 181161001868 8206 Union County Middle School   Regular School No Middle 06 08 2017   grade_8                         69.0 60.0                       129.0                         69 60                 129
1301770 1301770 IN     school 1811730 6795   Union School Corporation 181173001875 7119 Union Junior & High School   Regular School No High 07 12 2017   grade_8                         5.0 8.0                       13.0                         5 8                 13
1304783 1304783 IN     school 1800088 9870   Discovery Charter School 180008802495 6824 Discovery Charter School   Regular School Yes Elementary KG 08 2017   grade_8                         6.0 7.0                       13.0                         6 7                 13
1292940 1292940 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 05 08 2017   grade_8                         61.0 69.0                       130.0                         61 69                 130
1300733 1300733 IN     school 1810450 5845   South Montgomery Com Sch Corp 181045002325 6261 Southmont Jr High School   Regular School No Middle 07 08 2017   grade_8                         64.0 67.0                       131.0                         64 67                 131
1298009 1298009 IN     school 1805460 4650   Lake Ridge New Tech Schools 180546000992 3893 Lake Ridge New Tech Middle School   Regular School No Middle 06 08 2017   grade_8                         61.0 71.0                       132.0                         61 71                 132
1303294 1303294 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000488 8369 Washington Middle School   Regular School No Middle 06 08 2017   grade_8                         72.0 60.0                       132.0                         72 60                 132
1299742 1299742 IN     school 1804770 5385   Indianapolis Public Schools 180477002597 5466 Arlington Community Middle School   Regular School No Middle 07 08 2017   grade_8                         83.0 50.0                       133.0                         83 50                 133
1303833 1303833 IN     school 1801560 8360   Centerville-Abington Com Schs 180156000216 8982 Centerville-Abington Jr High Sch   Regular School No Middle 07 08 2017   grade_8                         71.0 62.0                       133.0                         71 62                 133
1294920 1294920 IN     school 1803480 2155   Fairfield Community Schools 180348000491 1613 Fairfield Jr-Sr High School   Regular School No High 07 12 2017   grade_8                         80.0 57.0                       137.0                         80 57                 137
1296793 1296793 IN     school 1802040 3470   Northwestern School Corp 180204002334 2907 Northwestern Middle School   Regular School No Middle 07 08 2017   grade_8                         59.0 78.0                       137.0                         59 78                 137
1300247 1300247 IN     school 1810920 5400   School Town of Speedway 181092001784 5889 Speedway Junior High School   Regular School No Middle 07 08 2017   grade_8                         69.0 68.0                       137.0                         69 68                 137
1303388 1303388 IN     school 1812090 8030   Vigo County School Corp 181209001915 8481 Sarah Scott Middle School   Regular School No Middle 06 08 2017   grade_8                         81.0 57.0                       138.0                         81 57                 138
1304369 1304369 IN     school 1800043 9465   Rural Community Schools Inc 180004302138 7951 Rural Community Academy   Regular School Yes Elementary KG 08 2017   grade_8                         7.0 7.0                       14.0                         7 7                 14
1304525 1304525 IN     school 1800162 9630   Carpe Diem - Shadeland 180016202575 5978 Carpe Diem - Shadeland   Regular School Yes Other 06 12 2017   grade_8                         7.0 7.0                       14.0                         7 7                 14
1293939 1293939 IN     school 1806030 875   Logansport Community Sch Corp 180603001052 715 Columbia Middle School   Regular School No Middle 06 08 2017   grade_8                         75.0 65.0                       140.0                         75 65                 140
1294482 1294482 IN     school 1805700 1620   Lawrenceburg Community School Corp 180570001036 1209 Greendale Middle School   Regular School No Middle 06 08 2017   grade_8                         75.0 65.0                       140.0                         75 65                 140
1304816 1304816 IN     school 1800106 9890   Indiana Virtual School 180010602515 2488 Indiana Virtual School   Regular School Yes Other 06 12 2017   grade_8                         70.0 70.0                       140.0                         70 70                 140
1301272 1301272 IN     school 1808900 6445   Pike County School Corp 180890000889 6768 Pike Central Middle School   Regular School No Middle 06 08 2017   grade_8                         80.0 61.0                       141.0                         80 61                 141
1303380 1303380 IN     school 1812090 8030   Vigo County School Corp 181209001924 8461 West Vigo Middle School   Regular School No Middle 06 08 2017   grade_8                         75.0 66.0                       141.0                         75 66                 141
1296403 1296403 IN     school 1808100 3295   North West Hendricks Schools 180810001670 2682 Tri-West Middle School   Regular School No Middle 06 08 2017   grade_8                         73.0 69.0                       142.0                         73 69                 142
1296804 1296804 IN     school 1803150 3480   Eastern Howard School Corporation 180315002589 2914 Eastern Middle School   Regular School No Middle 06 08 2017   grade_8                         67.0 75.0                       142.0                         67 75                 142
1301741 1301741 IN     school 1803990 6755   Greencastle Community School Corp 180399000689 7093 Greencastle Middle School   Regular School No Middle 06 08 2017   grade_8                         67.0 75.0                       142.0                         67 75                 142
1303038 1303038 IN     school 1811400 7945   Tipton Community School Corp 181140001842 8167 Tipton Middle School   Regular School No Middle 06 08 2017   grade_8                         69.0 73.0                       142.0                         69 73                 142
1297494 1297494 IN     school 1807620 4255   Nineveh-Hensley-Jackson United 180762001302 3418 Indian Creek Middle School   Regular School No Middle 06 08 2017   grade_8                         68.0 75.0                       143.0                         68 75                 143
1303871 1303871 IN     school 1809510 8385   Richmond Community Schools 180951001561 8997 Test Intermediate School   Regular School No Middle 05 08 2017   grade_8                         80.0 64.0                       144.0                         80 64                 144
1294955 1294955 IN     school 1800420 2260   Baugo Community Schools 180042000091 1703 Jimtown Junior High School   Regular School No Middle 07 08 2017   grade_8                         71.0 74.0                       145.0                         71 74                 145
1297797 1297797 IN     school 1805520 4535   Lakeland School Corporation 180552002145 3743 Lakeland Middle School   Regular School No Middle 06 08 2017   grade_8                         68.0 78.0                       146.0                         68 78                 146
1303876 1303876 IN     school 1809510 8385   Richmond Community Schools 180951001555 9001 Dennis Intermediate School   Regular School No Middle 05 08 2017   grade_8                         70.0 76.0                       146.0                         70 76                 146
1293649 1293649 IN     school 1800480 395   Benton Community School Corp 180048000097 445 Benton Central Jr-Sr High School   Regular School No High 07 12 2017   grade_8                         80.0 67.0                       147.0                         80 67                 147
1302280 1302280 IN     school 1810290 7205   South Bend Community School Corp 181029001661 7559 Dickinson Fine Arts Academy   Regular School No Middle 05 08 2017   grade_8                         81.0 67.0                       148.0                         81 67                 148
1302584 1302584 IN     school 1808010 7385   North Spencer County Sch Corp 180801001898 7761 Heritage Hills Middle School   Regular School No Middle 07 08 2017   grade_8                         74.0 74.0                       148.0                         74 74                 148
1294930 1294930 IN     school 1803480 2155   Fairfield Community Schools 180348000492 1621 Millersburg Elementary- Middle Sch   Regular School No Elementary KG 08 2017   grade_8                         11.0 4.0                       15.0                         11 4                 15
1293905 1293905 IN     school 1806030 875   Logansport Community Sch Corp 180603001058 702 Lincoln Middle School   Regular School No Middle 06 08 2017   grade_8                         75.0 75.0                       150.0                         75 75                 150
1295596 1295596 IN     school 1807770 2735   North Gibson School Corp 180777001327 2225 Princeton Community Middle   Regular School No Middle 06 08 2017   grade_8                         78.0 72.0                       150.0                         78 72                 150
1294580 1294580 IN     school 1803840 1820   Garrett-Keyser-Butler Com Sch Corp 180384001389 1331 Garrett Middle School   Regular School No Middle 06 08 2017   grade_8                         68.0 83.0                       151.0                         68 83                 151

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