enrollments

Data source: Big Local News · About: Big Local

2,933 rows where grade = "grade_12" and state = "IN" sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_12 · 2,933 ✖
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
1159642 1159642 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No 3.0 07 12 2015   grade_12                         1.0 0.0                       1.0                         1 0                 1
1162675 1162675 IN     school 1807650 3070   Noblesville Schools 180765002369 2514 MOSAICS School   Special Education School No 3.0 07 12 2015   grade_12                         1.0 0.0                       1.0                         1 0                 1
1170743 1170743 IN     school 1800006 9100   IN Department of Correction 180000601946 732 Logansport Juvenile Cor Fac   Regular School No 3.0 07 12 2015   grade_12                         1.0 0.0                       1.0                         1 0                 1
1281035 1281035 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No 3.0 08 12 2016   grade_12                         1.0 0.0                       1.0                         1 0                 1
1751721 1751721 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No High 08 12 2019   grade_12                         1.0 0.0                       1.0                         1 0                 1
1753834 1753834 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No High 05 12 2019   grade_12                         0.0 1.0                       1.0                         0 1                 1
1789572 1789572 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No Middle 05 12 2018   grade_12                         0.0 1.0                       1.0                         0 1                 1
1796666 1796666 IN     school 1810290 7205   South Bend Community School Corp 181029002574 7617 Studebaker Center   Regular School No High 12 12 2018   grade_12                         1.0 0.0                       1.0                         1 0                 1
1910235 1910235 IN     school 1807650 3070   Noblesville Schools 180765002621 2546 Juvenile Services Center   Alternative School No High 12 12 2020   grade_12                         1.0 0.0                       1.0                         1 0                 1
1918272 1918272 IN     school 1800197 9160   Excel Center - Muncie 180019702662 1016 Excel Center - Muncie   Regular School Yes High 11 12 2020   grade_12                         0.0 1.0                       1.0                         0 1                 1
1919965 1919965 IN     school 1806030 875   Logansport Community Sch Corp 180603001052 715 Columbia 6th Grade Academy   Regular School No Other 03 12 2021   grade_12                         1.0 0.0                       1.0                         1 0                 1
1920045 1920045 IN     school 1801920 1000   Clarksville Community School Corp 180192002690 1007 Indiana Gateway Digital Academy   Regular School No Other KG 12 2021   grade_12                         0.0 1.0                       1.0                         0 1                 1
1927189 1927189 IN     school   6520   Porter Township School Corp   6811 Porter County Education Services             2021   grade_12                         1.0 0.0                       1.0                         1 0                 1
1927242 1927242 IN     school   6550   Portage Township Schools   6811 Porter County Education Services             2021   grade_12                         0.0 1.0                       1.0                         0 1                 1
1930084 1930084 IN     school 1800222 9000   Phalen Virtual Leadership Academy 180022202707 9992 Phalen Virtual Leadership Academy   Regular School Yes Other 02 12 2021   grade_12                         1.0 0.0                       1.0                         1 0                 1
1166745 1166745 IN     school 1804770 5385   Indianapolis Public Schools 180477001434 5631 Key Learning Community High School   Regular School No 3.0 09 12 2015   grade_12                         5.0 5.0                       10.0                         5 5                 10
1166812 1166812 IN     school 1800105 5390   Southside Sp Srvs Of Marion Co 180010502502 5320 RISE Learning Center   Regular School No 4.0 KG 12 2015   grade_12                         8.0 2.0                       10.0                         8 2                 10
1171130 1171130 IN     school 1800059 9655   Hope Academy 180005902386 5292 Hope Academy   Regular School Yes 3.0 09 12 2015   grade_12                         6.0 4.0                       10.0                         6 4                 10
1291898 1291898 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2016   grade_12                         9.0 1.0                       10.0                         9 1                 10
1292233 1292233 IN     school 1800135 9355   Excel Center - Kokomo 180013502553 2976 Excel Center - Kokomo   Regular School Yes 3.0 10 12 2016   grade_12                         4.0 6.0                       10.0                         4 6                 10
1302508 1302508 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other KG 12 2017   grade_12                         5.0 5.0                       10.0                         5 5                 10
1304154 1304154 IN     school 1800006 9100   Indiana Department of Corrections 180000601996 4846 Camp Summit Juvenile Facility   Regular School No High 08 12 2017   grade_12                         10.0 0.0                       10.0                         10 0                 10
1911029 1911029 IN     school 1801230 3640   Medora Community School Corp 180123000201 3093 Medora Jr & Sr High School   Regular School No High 07 12 2020   grade_12                         9.0 1.0                       10.0                         9 1                 10
1918623 1918623 IN     school 1800059 9655   Hope Academy 180005902386 5292 Hope Academy   Regular School Yes High 09 12 2020   grade_12                         5.0 5.0                       10.0                         5 5                 10
1286989 1286989 IN     school 1803300 5280   Elwood Community School Corp 180330000449 5149 Elwood Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_12                         58.0 42.0                       100.0                         58 42                 100
1289625 1289625 IN     school 1807110 6620   Eastern Pulaski Com Sch Corp 180711001205 6997 Winamac Community High School   Regular School No 3.0 09 12 2016   grade_12                         47.0 53.0                       100.0                         47 53                 100
1296809 1296809 IN     school 1803150 3480   Eastern Howard School Corporation 180315000413 2919 Eastern High School   Regular School No High 09 12 2017   grade_12                         45.0 55.0                       100.0                         45 55                 100
1299024 1299024 IN     school 1803300 5280   Elwood Community School Corp 180330000449 5149 Elwood Jr-Sr High School   Regular School No High 07 12 2017   grade_12                         35.0 65.0                       100.0                         35 65                 100
1302604 1302604 IN     school 1810560 7445   South Spencer County Sch Corp 181056001733 7795 South Spencer High School   Regular School No High 09 12 2017   grade_12                         51.0 49.0                       100.0                         51 49                 100
1760203 1760203 IN     school 1807980 6715   North Putnam Community Schools 180798001369 7061 North Putnam Sr High School   Regular School No High 09 12 2019   grade_12                         54.0 46.0                       100.0                         54 46                 100
1763389 1763389 IN     school 1800169 9900   Excel Center - South Bend 180016902596 7566 Excel Center - South Bend   Regular School Yes High 11 12 2019   grade_12                         32.0 68.0                       100.0                         32 68                 100
1797915 1797915 IN     school 1812150 8060   Wabash City Schools 181215001940 8693 Wabash High School   Regular School No High 09 12 2018   grade_12                         48.0 52.0                       100.0                         48 52                 100
1928225 1928225 IN     school 1809990 7230   Scott County School District 1 180999001605 7629 Austin High School   Regular School No High 09 12 2021   grade_12                         55.0 45.0                       100.0                         55 45                 100
1928444 1928444 IN     school 1810560 7445   South Spencer County Sch Corp 181056001733 7795 South Spencer High School   Regular School No High 09 12 2021   grade_12                         61.0 39.0                       100.0                         61 39                 100
1793919 1793919 IN     school 1812810 5375   M S D Wayne Township 181281002028 5213 Ben Davis High School   Regular School No High 10 12 2018   grade_12                         498.0 506.0                       1004.0                         498 506                 1004
1166152 1166152 IN     school 1812810 5375   M S D Wayne Township 181281002028 5213 Ben Davis High School   Regular School No 3.0 10 12 2015   grade_12                         501.0 505.0                       1006.0                         501 505                 1006
1299591 1299591 IN     school 1812810 5375   M S D Wayne Township 181281002028 5213 Ben Davis High School   Regular School No High 10 12 2017   grade_12                         504.0 504.0                       1008.0                         504 504                 1008
1161107 1161107 IN     school 1803060 1805   DeKalb Co Eastern Com Sch Dist 180306000405 1317 Eastside Junior-Senior High Sch   Regular School No 3.0 07 12 2015   grade_12                         57.0 44.0                       101.0                         57 44                 101
1164054 1164054 IN     school 1807830 4315   North Knox School Corp 180783001334 3537 North Knox Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_12                         56.0 45.0                       101.0                         56 45                 101
1282268 1282268 IN     school 1802440 1300   Crawford Co Com School Corp 180244000279 1059 Crawford County Jr-Sr HS   Regular School No 3.0 07 12 2016   grade_12                         55.0 46.0                       101.0                         55 46                 101
1291572 1291572 IN     school 1812150 8060   Wabash City Schools 181215001940 8693 Wabash High School   Regular School No 3.0 09 12 2016   grade_12                         58.0 43.0                       101.0                         58 43                 101
1759781 1759781 IN     school 1800750 6460   M S D Boone Township 180075000153 6813 Hebron High School   Regular School No High 09 12 2019   grade_12                         52.0 49.0                       101.0                         52 49                 101
1799160 1799160 IN     school 1800169 9900   Excel Center - South Bend 180016902596 7566 Excel Center - South Bend   Regular School Yes High 11 12 2018   grade_12                         25.0 76.0                       101.0                         25 76                 101
1908062 1908062 IN     school 1801920 1000   Clarksville Community School Corp 180192000249 833 Clarksville Senior High School   Regular School No High 09 12 2020   grade_12                         52.0 49.0                       101.0                         52 49                 101
1911579 1911579 IN     school 1810410 4325   South Knox School Corp 181041001706 3490 South Knox Middle-High School   Regular School No High 07 12 2020   grade_12                         44.0 57.0                       101.0                         44 57                 101
1912978 1912978 IN     school 1803300 5280   Elwood Community School Corp 180330000449 5149 Elwood Jr-Sr High School   Regular School No High 07 12 2020   grade_12                         39.0 62.0                       101.0                         39 62                 101
1923743 1923743 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko Jr/Sr High School   Regular School No High 07 12 2021   grade_12                         60.0 41.0                       101.0                         60 41                 101
1927516 1927516 IN     school 1810500 6705   South Putnam Community Schools 181050001726 7071 South Putnam High School   Regular School No High 09 12 2021   grade_12                         58.0 43.0                       101.0                         58 43                 101
1168482 1168482 IN     school 1806630 6910   Milan Community Schools 180663001168 7205 Milan High School   Regular School No 3.0 09 12 2015   grade_12                         46.0 56.0                       102.0                         46 56                 102
1281938 1281938 IN     school 1801920 1000   Clarksville Com School Corp 180192000249 833 Clarksville Senior High School   Regular School No 3.0 09 12 2016   grade_12                         43.0 59.0                       102.0                         43 59                 102
1284721 1284721 IN     school 1811250 3460   Taylor Community School Corp 181125001814 2894 Taylor High School   Regular School No 3.0 09 12 2016   grade_12                         66.0 36.0                       102.0                         66 36                 102
1285699 1285699 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No 4.0 06 12 2016   grade_12                         50.0 52.0                       102.0                         50 52                 102
1287722 1287722 IN     school 1804770 5385   Indianapolis Public Schools 180477000804 5477 Broad Ripple Mgnt HS for Prfm Arts   Regular School No 3.0 09 12 2016   grade_12                         46.0 56.0                       102.0                         46 56                 102
1292318 1292318 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes 4.0 KG 12 2016   grade_12                         51.0 51.0                       102.0                         51 51                 102
1292929 1292929 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2017   grade_12                         45.0 57.0                       102.0                         45 57                 102
1756102 1756102 IN     school 1807830 4315   North Knox School Corp 180783001334 3537 North Knox Jr-Sr High School   Regular School No High 07 12 2019   grade_12                         50.0 52.0                       102.0                         50 52                 102
1762679 1762679 IN     school 1800119 8820   Edison Learning Roosevelt 180011900645 4033 Theodore Roosevelt Car & Tech Acad   Regular School No High 07 12 2019   grade_12                         57.0 45.0                       102.0                         57 45                 102
1799086 1799086 IN     school 1800163 9855   Excel Center - Noblesville 180016302576 5748 Excel Center - Noblesville   Regular School Yes High 10 12 2018   grade_12                         42.0 60.0                       102.0                         42 60                 102
1910820 1910820 IN     school 1811250 3460   Taylor Community School Corp 181125001814 2894 Taylor High School   Regular School No High 09 12 2020   grade_12                         55.0 47.0                       102.0                         55 47                 102
1929417 1929417 IN     school 1806270 8045   Manchester Community Schools 180627001103 8625 Manchester Jr-Sr High School   Regular School No High 07 12 2021   grade_12                         57.0 45.0                       102.0                         57 45                 102
1168973 1168973 IN     school 1809990 7230   Scott County School District 1 180999001605 7629 Austin High School   Regular School No 3.0 09 12 2015   grade_12                         57.0 46.0                       103.0                         57 46                 103
1287663 1287663 IN     school 1812810 5375   M S D Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No 3.0 09 12 2016   grade_12                         36.0 67.0                       103.0                         36 67                 103
1287676 1287676 IN     school 1812810 5375   M S D Wayne Township 181281002410 5447 Ben Davis University High School   Regular School No 3.0 10 12 2016   grade_12                         43.0 60.0                       103.0                         43 60                 103
1287716 1287716 IN     school 1804770 5385   Indianapolis Public Schools 180477000815 5473 Crispus Attucks Medical Magnet HS   Regular School No 3.0 09 12 2016   grade_12                         37.0 66.0                       103.0                         37 66                 103
1289695 1289695 IN     school 1802220 6750   Cloverdale Community Schools 180222000265 7077 Cloverdale High School   Regular School No 3.0 09 12 2016   grade_12                         42.0 61.0                       103.0                         42 61                 103
1304136 1304136 IN     school 1800119 8820   Edison Learning Roosevelt 180011900645 4033 Theodore Roosevelt Car & Tech Acad   Regular School No High 07 12 2017   grade_12                         52.0 51.0                       103.0                         52 51                 103
1752075 1752075 IN     school 1802850 255   East Allen County Schools 180285000361 285 Woodlan Jr/Sr High School   Regular School No High 07 12 2019   grade_12                         56.0 47.0                       103.0                         56 47                 103
1759692 1759692 IN     school 1801740 6325   Perry Central Com Schools Corp 180174000234 6708 Perry Central Jr-Sr High School   Regular School No High 07 12 2019   grade_12                         49.0 54.0                       103.0                         49 54                 103
1790013 1790013 IN     school 1806240 2825   Madison-Grant United School Corp 180624001097 2321 Madison-Grant Jr./Sr. High School   Regular School No High 07 12 2018   grade_12                         52.0 51.0                       103.0                         52 51                 103
1794569 1794569 IN     school 1810920 5400   School Town of Speedway 181092001785 5891 Speedway Senior High School   Regular School No High 09 12 2018   grade_12                         59.0 44.0                       103.0                         59 44                 103
1796032 1796032 IN     school 1807980 6715   North Putnam Community Schools 180798001369 7061 North Putnam Sr High School   Regular School No High 09 12 2018   grade_12                         51.0 52.0                       103.0                         51 52                 103
1916276 1916276 IN     school 1811910 7215   Union-North United School Corp 181191001879 7399 LaVille Jr-Sr High School   Regular School No High 07 12 2020   grade_12                         61.0 42.0                       103.0                         61 42                 103
1166275 1166275 IN     school 1812810 5375   M S D Wayne Township 181281002410 5447 Ben Davis University High School   Regular School No 3.0 10 12 2015   grade_12                         43.0 61.0                       104.0                         43 61                 104
1167794 1167794 IN     school 1811260 6350   Tell City-Troy Twp School Corp 181126001819 6741 Tell City Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_12                         50.0 54.0                       104.0                         50 54                 104
1168389 1168389 IN     school 1801770 6825   Randolph Central School Corp 180177000242 7125 Winchester Community High Sch   Regular School No 3.0 09 12 2015   grade_12                         54.0 50.0                       104.0                         54 50                 104
1169226 1169226 IN     school 1807800 7515   North Judson-San Pierre Sch Corp 180780001330 7849 North Judson-San Pierre High Sch   Regular School No 3.0 09 12 2015   grade_12                         61.0 43.0                       104.0                         61 43                 104
1170126 1170126 IN     school 1806270 8045   Manchester Community Schools 180627001103 8625 Manchester Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_12                         54.0 50.0                       104.0                         54 50                 104
1285783 1285783 IN     school 1804620 4590   River Forest Community Sch Corp 180462000781 3791 River Forest High School   Regular School No 3.0 09 12 2016   grade_12                         53.0 51.0                       104.0                         53 51                 104
1755245 1755245 IN     school 1806660 3335   Mill Creek Community Sch Corp 180666001171 2692 Cascade Senior High School   Regular School No High 09 12 2019   grade_12                         49.0 55.0                       104.0                         49 55                 104
1759442 1759442 IN     school 1807920 5945   North Newton School Corp 180792001363 6411 North Newton Jr-Sr High School   Regular School No High 07 12 2019   grade_12                         58.0 46.0                       104.0                         58 46                 104
1909170 1909170 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other KG 12 2020   grade_12                         38.0 66.0                       104.0                         38 66                 104
1911775 1911775 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko Jr/Sr High School   Regular School No High 07 12 2020   grade_12                         51.0 53.0                       104.0                         51 53                 104
1916381 1916381 IN     school 1808310 7350   Northwestern Con School Corp 180831001423 7689 Triton Central High School   Regular School No High 09 12 2020   grade_12                         53.0 51.0                       104.0                         53 51                 104
1917727 1917727 IN     school 1803000 8215   East Washington School Corp 180300000395 8905 Eastern High School   Regular School No High 09 12 2020   grade_12                         56.0 48.0                       104.0                         56 48                 104
1918968 1918968 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2021   grade_12                         50.0 54.0                       104.0                         50 54                 104
1924452 1924452 IN     school 1813200 4760   School City of Whiting 181320002082 4353 Whiting High School   Regular School No High 09 12 2021   grade_12                         46.0 58.0                       104.0                         46 58                 104
1167042 1167042 IN     school 1808340 5625   Oak Hill United School Corp 180834001429 6069 Oak Hill High School   Regular School No 3.0 09 12 2015   grade_12                         51.0 54.0                       105.0                         51 54                 105
1169060 1169060 IN     school 1808310 7350   Northwestern Con School Corp 180831001423 7689 Triton Central High School   Regular School No 3.0 09 12 2015   grade_12                         56.0 49.0                       105.0                         56 49                 105
1169192 1169192 IN     school 1810560 7445   South Spencer County Sch Corp 181056001733 7795 South Spencer High School   Regular School No 3.0 09 12 2015   grade_12                         50.0 55.0                       105.0                         50 55                 105
1282822 1282822 IN     school 1810640 2100   Southeast Dubois Co Sch Corp 181064001745 1583 Forest Park Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_12                         52.0 53.0                       105.0                         52 53                 105
1292370 1292370 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes 4.0 KG 12 2016   grade_12                         44.0 61.0                       105.0                         44 61                 105
1296630 1296630 IN     school 1806660 3335   Mill Creek Community Sch Corp 180666001171 2692 Cascade Senior High School   Regular School No High 09 12 2017   grade_12                         52.0 53.0                       105.0                         52 53                 105
1296674 1296674 IN     school 1808280 3435   Shenandoah School Corporation 180828001420 2817 Shenandoah High School   Regular School No High 09 12 2017   grade_12                         51.0 54.0                       105.0                         51 54                 105
1297831 1297831 IN     school 1804620 4590   River Forest Community Sch Corp 180462000781 3791 River Forest High School   Regular School No High 09 12 2017   grade_12                         59.0 46.0                       105.0                         59 46                 105
1301199 1301199 IN     school 1801740 6325   Perry Central Com Schools Corp 180174000234 6708 Perry Central Jr-Sr High School   Regular School No High 07 12 2017   grade_12                         58.0 47.0                       105.0                         58 47                 105
1301221 1301221 IN     school 1811260 6350   Tell City-Troy Twp School Corp 181126001819 6741 Tell City Jr-Sr High School   Regular School No High 07 12 2017   grade_12                         59.0 46.0                       105.0                         59 46                 105
1763362 1763362 IN     school 1800102 9885   Gary Middle College 180010202535 4027 Gary Middle College   Regular School Yes High 09 12 2019   grade_12                         36.0 69.0                       105.0                         36 69                 105
1788253 1788253 IN     school 1810680 815   Lewis Cass Schools 181068001755 689 Lewis Cass High School   Regular School No High 09 12 2018   grade_12                         57.0 48.0                       105.0                         57 48                 105
1792099 1792099 IN     school 1809300 4515   Prairie Heights Community Sch Corp 180930001526 3690 Prairie Heights Sr High School   Regular School No High 09 12 2018   grade_12                         63.0 42.0                       105.0                         63 42                 105
1798460 1798460 IN     school 1800119 8820   Edison Learning Roosevelt 180011900645 4033 Theodore Roosevelt Car & Tech Acad   Regular School No High 07 12 2018   grade_12                         54.0 51.0                       105.0                         54 51                 105

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