enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 3,430 ✖
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
1304124 1304124 IN     school 1800126 8810   CSUSA Howe 180012601445 5639 Thomas Carr Howe Comm High School   Regular School No High 07 12 2017   grade_7                         59.0 44.0                       103.0                         59 44                 103
1761281 1761281 IN     school 1810860 7715   Southwest School Corporation 181086002359 7961 Sullivan Middle School   Regular School No Middle 06 08 2019   grade_7                         51.0 52.0                       103.0                         51 52                 103
1762397 1762397 IN     school 1808190 8375   Northeastern Wayne Schools 180819002567 8929 Northeastern Middle School   Regular School No Middle 06 08 2019   grade_7                         44.0 59.0                       103.0                         44 59                 103
1787800 1787800 IN     school 1802850 255   East Allen County Schools 180285000344 81 Heritage Jr/Sr High School   Regular School No High 07 12 2018   grade_7                         50.0 53.0                       103.0                         50 53                 103
1160398 1160398 IN     school 1802700 755   Delphi Community School Corp 180270000327 609 Delphi Community Middle Sch   Regular School No 2.0 06 08 2015   grade_7                         54.0 50.0                       104.0                         54 50                 104
1161084 1161084 IN     school 1802610 1655   Decatur County Com Schools 180261000309 1267 North Decatur Jr-Sr High Sch   Regular School No 3.0 07 12 2015   grade_7                         58.0 46.0                       104.0                         58 46                 104
1166908 1166908 IN     school 1800900 5480   Bremen Public Schools 180090000166 5943 Bremen Elem/Middle School   Regular School No 1.0 KG 08 2015   grade_7                         57.0 47.0                       104.0                         57 47                 104
1168253 1168253 IN     school 1810500 6705   South Putnam Community Schools 181050002542 7056 South Putnam Middle School   Regular School No 2.0 06 08 2015   grade_7                         57.0 47.0                       104.0                         57 47                 104
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
1300975 1300975 IN     school 1801710 6055   Central Noble Com School Corp 180171000230 6453 Central Noble Junior Senior HS   Regular School No Other 06 12 2017   grade_7                         55.0 49.0                       104.0                         55 49                 104
1756103 1756103 IN     school 1807830 4315   North Knox School Corp 180783001334 3537 North Knox Jr-Sr High School   Regular School No High 07 12 2019   grade_7                         56.0 48.0                       104.0                         56 48                 104
1759715 1759715 IN     school 1811260 6350   Tell City-Troy Twp School Corp 181126001819 6741 Tell City Jr-Sr High School   Regular School No High 07 12 2019   grade_7                         46.0 58.0                       104.0                         46 58                 104
1798181 1798181 IN     school 1808190 8375   Northeastern Wayne Schools 180819002567 8929 Northeastern Middle School   Regular School No Middle 06 08 2018   grade_7                         53.0 51.0                       104.0                         53 51                 104
1912153 1912153 IN     school 1802910 4680   Lake Station Community Schools 180291000380 3965 Thomas A Edison Jr-Sr HS   Regular School No High 06 12 2020   grade_7                         50.0 54.0                       104.0                         50 54                 104
1914855 1914855 IN     school 1807920 5945   North Newton School Corp 180792001363 6411 North Newton Jr-Sr High School   Regular School No High 07 12 2020   grade_7                         38.0 66.0                       104.0                         38 66                 104
1924704 1924704 IN     school 1807860 5075   North Lawrence Com Schools 180786001344 4885 Oolitic School   Regular School No Elementary KG 08 2021   grade_7                         67.0 37.0                       104.0                         67 37                 104
1926873 1926873 IN     school 1808640 6155   Paoli Community School Corp 180864001438 6581 Paoli Jr & Sr High School   Regular School No High 07 12 2021   grade_7                         56.0 48.0                       104.0                         56 48                 104
1162334 1162334 IN     school 1805910 2950   Linton-Stockton School Corp 180591002147 2438 Linton-Stockton Jr High Sch   Regular School No 2.0 06 08 2015   grade_7                         57.0 48.0                       105.0                         57 48                 105
1170949 1170949 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes 4.0 KG 12 2015   grade_7                         52.0 53.0                       105.0                         52 53                 105
1280853 1280853 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No 2.0 06 08 2016   grade_7                         49.0 56.0                       105.0                         49 56                 105
1289193 1289193 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 2016   grade_7                         57.0 48.0                       105.0                         57 48                 105
1290204 1290204 IN     school 1810290 7205   South Bend Community Sch Corp 181029002296 7521 Brown Intermediate Center   Regular School No 2.0 04 08 2016   grade_7                         61.0 44.0                       105.0                         61 44                 105
1290283 1290283 IN     school 1810290 7205   South Bend Community Sch Corp 181029001666 7581 Marshall Intermediate Center   Regular School No 2.0 05 08 2016   grade_7                         56.0 49.0                       105.0                         56 49                 105
1302950 1302950 IN     school 1811340 7865   Tippecanoe School Corp 181134001833 8026 Wainwright Middle School   Regular School No Middle 06 08 2017   grade_7                         56.0 49.0                       105.0                         56 49                 105
1757562 1757562 IN     school 1803300 5280   Elwood Community School Corp 180330000449 5149 Elwood Jr-Sr High School   Regular School No High 07 12 2019   grade_7                         51.0 54.0                       105.0                         51 54                 105
1759693 1759693 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_7                         62.0 43.0                       105.0                         62 43                 105
1759785 1759785 IN     school 1800750 6460   M S D Boone Township 180075002216 6814 Hebron Middle School   Regular School No Middle 06 08 2019   grade_7                         53.0 52.0                       105.0                         53 52                 105
1791388 1791388 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105000181 3107 Brownstown Central Middle School   Regular School No Middle 06 08 2018   grade_7                         56.0 49.0                       105.0                         56 49                 105
1906988 1906988 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2020   grade_7                         52.0 53.0                       105.0                         52 53                 105
1915607 1915607 IN     school 1807980 6715   North Putnam Community Schools 180798000316 7049 North Putnam Middle School   Regular School No Middle 06 08 2020   grade_7                         50.0 55.0                       105.0                         50 55                 105
1922790 1922790 IN     school 1811250 3460   Taylor Community School Corp 181125001263 2896 Taylor Middle School   Regular School No Middle 05 08 2021   grade_7                         56.0 49.0                       105.0                         56 49                 105
1923756 1923756 IN     school 1809300 4515   Prairie Heights Community Sch Corp 180930001525 3688 Prairie Heights Middle School   Regular School No Middle 05 08 2021   grade_7                         62.0 43.0                       105.0                         62 43                 105
1170920 1170920 IN     school 1800028 9400   KIPP Indpls College Preparatory 180002802136 5860 KIPP Indy College Prep Middle   Regular School Yes 2.0 05 08 2015   grade_7                         48.0 58.0                       106.0                         48 58                 106
1171497 1171497 IN     school 1800139 9940   Tindley Collegiate Academy 180013902559 5914 Tindley Collegiate Academy   Regular School Yes 2.0 05 08 2015   grade_7                         0.0 106.0                       106.0                         0 106                 106
1300942 1300942 IN     school 1807920 5945   North Newton School Corp 180792001363 6411 North Newton Jr-Sr High School   Regular School No High 07 12 2017   grade_7                         54.0 52.0                       106.0                         54 52                 106
1302608 1302608 IN     school 1810560 7445   South Spencer County Sch Corp 181056001734 7797 South Spencer Middle School   Regular School No Middle 06 08 2017   grade_7                         46.0 60.0                       106.0                         46 60                 106
1752470 1752470 IN     school 1802700 755   Delphi Community School Corp 180270000327 609 Delphi Community Middle School   Regular School No Middle 06 08 2019   grade_7                         49.0 57.0                       106.0                         49 57                 106
1759268 1759268 IN     school 1804140 5900   Monroe-Gregg School District 180414002129 6315 Monrovia Middle School   Regular School No Middle 06 08 2019   grade_7                         55.0 51.0                       106.0                         55 51                 106
1793210 1793210 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002050 5005 Frankton Jr-Sr High School   Regular School No High 07 12 2018   grade_7                         64.0 42.0                       106.0                         64 42                 106
1794648 1794648 IN     school 1800900 5480   Bremen Public Schools 180090000166 5943 Bremen Elementary/Middle School   Regular School No Elementary KG 08 2018   grade_7                         57.0 49.0                       106.0                         57 49                 106
1796087 1796087 IN     school 1811730 6795   Union School Corporation 181173001875 7119 Union Junior & High School   Regular School No High 07 12 2018   grade_7                         50.0 56.0                       106.0                         50 56                 106
1908074 1908074 IN     school 1801920 1000   Clarksville Community School Corp 180192000248 851 Clarksville Middle School   Regular School No Middle 05 08 2020   grade_7                         47.0 59.0                       106.0                         47 59                 106
1915194 1915194 IN     school 1800750 6460   M S D Boone Township 180075002216 6814 Hebron Middle School   Regular School No Middle 06 08 2020   grade_7                         52.0 54.0                       106.0                         52 54                 106
1919875 1919875 IN     school 1802700 755   Delphi Community School Corp 180270000327 609 Delphi Community Middle School   Regular School No Middle 06 08 2021   grade_7                         53.0 53.0                       106.0                         53 53                 106
1919913 1919913 IN     school 1810680 815   Lewis Cass Schools 181068002625 691 Lewis Cass Junior High School   Regular School No Middle 06 08 2021   grade_7                         57.0 49.0                       106.0                         57 49                 106
1920568 1920568 IN     school 1803060 1805   DeKalb Co Eastern Com Sch Dist 180306000405 1317 Eastside Junior-Senior High School   Regular School No High 07 12 2021   grade_7                         63.0 43.0                       106.0                         63 43                 106
1923124 1923124 IN     school 1809420 3815   Rensselaer Central School Corp 180942001544 3221 Rensselaer Middle School   Regular School No Middle 05 08 2021   grade_7                         59.0 47.0                       106.0                         59 47                 106
1164055 1164055 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_7                         54.0 53.0                       107.0                         54 53                 107
1291514 1291514 IN     school 1806270 8045   Manchester Community Schools 180627001103 8625 Manchester Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_7                         58.0 49.0                       107.0                         58 49                 107
1303051 1303051 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_7                         53.0 54.0                       107.0                         53 54                 107
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
1755293 1755293 IN     school 1808280 3435   Shenandoah School Corporation 180828001421 2819 Shenandoah Middle School   Regular School No Middle 06 08 2019   grade_7                         56.0 51.0                       107.0                         56 51                 107
1792069 1792069 IN     school 1813230 4455   Whitko Community School Corp 181323000068 3644 Whitko Middle School   Regular School No Middle 06 08 2018   grade_7                         49.0 58.0                       107.0                         49 58                 107
1915766 1915766 IN     school 1810530 6865   South Ripley Com Sch Corp 181053002482 7174 South Ripley Junior High School   Regular School No Middle 07 08 2020   grade_7                         52.0 55.0                       107.0                         52 55                 107
1918489 1918489 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes Other KG 12 2020   grade_7                         55.0 52.0                       107.0                         55 52                 107
1918954 1918954 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2021   grade_7                         64.0 43.0                       107.0                         64 43                 107
1923539 1923539 IN     school 1810410 4325   South Knox School Corp 181041001706 3490 South Knox Middle-High School   Regular School No High 07 12 2021   grade_7                         51.0 56.0                       107.0                         51 56                 107
1161108 1161108 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_7                         60.0 48.0                       108.0                         60 48                 108
1168959 1168959 IN     school 1811910 7215   Union-North United School Corp 181191001879 7399 LaVille Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_7                         58.0 50.0                       108.0                         58 50                 108
1169237 1169237 IN     school 1807800 7515   North Judson-San Pierre Sch Corp 180780001329 7854 North Judson-San Pierre Mdl Sch   Regular School No 2.0 06 08 2015   grade_7                         49.0 59.0                       108.0                         49 59                 108
1169531 1169531 IN     school 1811340 7865   Tippecanoe School Corp 181134001833 8026 Wainwright Middle School   Regular School No 2.0 06 08 2015   grade_7                         55.0 53.0                       108.0                         55 53                 108
1281832 1281832 IN     school 1810680 815   Southeastern School Corp 181068001755 689 Lewis Cass Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_7                         44.0 64.0                       108.0                         44 64                 108
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
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
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
1756319 1756319 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko Jr/Sr High School   Regular School No High 07 12 2019   grade_7                         58.0 50.0                       108.0                         58 50                 108
1763491 1763491 IN     school 1800164 9965   Career Academy Middle School 180016402593 7563 Career Academy Middle School   Regular School Yes Middle 06 08 2019   grade_7                         64.0 44.0                       108.0                         64 44                 108
1787312 1787312 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 05 08 2018   grade_7                         49.0 59.0                       108.0                         49 59                 108
1795723 1795723 IN     school 1809180 6520   Porter Township School Corp 180918000523 6839 Boone Grove Middle School   Regular School No Middle 06 08 2018   grade_7                         54.0 54.0                       108.0                         54 54                 108
1796561 1796561 IN     school 1810290 7205   South Bend Community School Corp 181029001681 7537 Edison Middle School   Regular School No Middle 05 08 2018   grade_7                         55.0 53.0                       108.0                         55 53                 108
1907730 1907730 IN     school 1800570 515   Blackford County Schools 180057000102 489 Blackford Jr-Sr High School   Regular School No High 07 12 2020   grade_7                         54.0 54.0                       108.0                         54 54                 108
1914996 1914996 IN     school 1808640 6155   Paoli Community School Corp 180864001438 6581 Paoli Jr & Sr High School   Regular School No High 07 12 2020   grade_7                         59.0 49.0                       108.0                         59 49                 108
1924752 1924752 IN     school 1806900 5085   Mitchell Community Schools 180690002151 4924 Mitchell Jr High School   Regular School No Middle 06 08 2021   grade_7                         55.0 53.0                       108.0                         55 53                 108
1927435 1927435 IN     school 1807950 6600   MSD North Posey Co Schools 180795001365 6973 North Posey Junior High School   Regular School No Middle 07 08 2021   grade_7                         57.0 51.0                       108.0                         57 51                 108
1927656 1927656 IN     school 1801770 6825   Randolph Central School Corp 180177000235 7129 Lee L Driver Middle School   Regular School No Middle 06 08 2021   grade_7                         51.0 57.0                       108.0                         51 57                 108
1929156 1929156 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000488 8369 Washington Middle School   Regular School No Middle 06 08 2021   grade_7                         56.0 52.0                       108.0                         56 52                 108
1168896 1168896 IN     school 1810290 7205   South Bend Community Sch Corp 181029001666 7581 Marshall Intermediate Center   Regular School No 2.0 05 08 2015   grade_7                         65.0 44.0                       109.0                         65 44                 109
1171037 1171037 IN     school 1800051 9575   Indpls Lighthouse Charter School 180005102165 5523 Indpls Lighthouse Charter School   Regular School Yes 4.0 KG 12 2015   grade_7                         50.0 59.0                       109.0                         50 59                 109
1294859 1294859 IN     school 1810640 2100   Southeast Dubois Co Sch Corp 181064001745 1583 Forest Park Jr-Sr High School   Regular School No High 07 12 2017   grade_7                         57.0 52.0                       109.0                         57 52                 109
1299025 1299025 IN     school 1803300 5280   Elwood Community School Corp 180330000449 5149 Elwood Jr-Sr High School   Regular School No High 07 12 2017   grade_7                         55.0 54.0                       109.0                         55 54                 109
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
1756331 1756331 IN     school 1809300 4515   Prairie Heights Community Sch Corp 180930001525 3688 Prairie Heights Middle School   Regular School No Middle 05 08 2019   grade_7                         66.0 43.0                       109.0                         66 43                 109
1760198 1760198 IN     school 1807980 6715   North Putnam Community Schools 180798000316 7049 North Putnam Middle School   Regular School No Middle 06 08 2019   grade_7                         44.0 65.0                       109.0                         44 65                 109
1762312 1762312 IN     school 1803000 8215   East Washington School Corp 180300000073 8906 East Washington Middle School   Regular School No Middle 05 08 2019   grade_7                         58.0 51.0                       109.0                         58 51                 109
1790133 1790133 IN     school 1805910 2950   Linton-Stockton School Corporation 180591002147 2438 Linton-Stockton Middle School   Regular School No Middle 06 08 2018   grade_7                         59.0 50.0                       109.0                         59 50                 109
1795411 1795411 IN     school 1808640 6155   Paoli Community School Corp 180864001438 6581 Paoli Jr & Sr High School   Regular School No High 07 12 2018   grade_7                         54.0 55.0                       109.0                         54 55                 109
1797117 1797117 IN     school 1811220 7775   Switzerland County School Corp 181122000806 7987 Switzerland Co Middle School   Regular School No Middle 07 08 2018   grade_7                         55.0 54.0                       109.0                         55 54                 109
1797920 1797920 IN     school 1812150 8060   Wabash City Schools 181215002301 8694 Wabash Middle School   Regular School No Middle 05 08 2018   grade_7                         59.0 50.0                       109.0                         59 50                 109
1914253 1914253 IN     school 1800900 5480   Bremen Public Schools 180090000166 5943 Bremen Elementary/Middle School   Regular School No Elementary KG 08 2020   grade_7                         62.0 47.0                       109.0                         62 47                 109
1282778 1282778 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative Education School No 4.0 03 12 2016   grade_7                         9.0 2.0                       11.0                         9 2                 11
1301769 1301769 IN     school 1811730 6795   Union School Corporation 181173001875 7119 Union Junior & High School   Regular School No High 07 12 2017   grade_7                         8.0 3.0                       11.0                         8 3                 11
1304635 1304635 IN     school 1800123 9735   Inspire Academy - A Sch of Inquiry 180012302560 1518 Inspire Academy - A Sch of Inquiry   Regular School Yes Elementary KG 08 2017   grade_7                         7.0 4.0                       11.0                         7 4                 11
1304959 1304959 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Elementary KG 08 2017   grade_7                         4.0 7.0                       11.0                         4 7                 11
1753418 1753418 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 04 12 2019   grade_7                         8.0 3.0                       11.0                         8 3                 11
1798866 1798866 IN     school 1800056 9640   Options Charter School Noblesville 180005602313 2551 Options Charter School Noblesville   Regular School Yes High 06 12 2018   grade_7                         8.0 3.0                       11.0                         8 3                 11
1908849 1908849 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No High 05 12 2020   grade_7                         8.0 3.0                       11.0                         8 3                 11
1163236 1163236 IN     school 1808280 3435   Shenandoah School Corporation 180828001421 2819 Shenandoah Middle School   Regular School No 2.0 06 08 2015   grade_7                         56.0 54.0                       110.0                         56 54                 110
1164258 1164258 IN     school 1813230 4455   Whitko Community School Corp 181323000068 3644 Whitko Middle Sch   Regular School No 2.0 06 08 2015   grade_7                         62.0 48.0                       110.0                         62 48                 110
1165382 1165382 IN     school 1807860 5075   North Lawrence Com Schools 180786000446 4878 Oolitic Middle School   Regular School No 2.0 06 08 2015   grade_7                         58.0 52.0                       110.0                         58 52                 110
1288736 1288736 IN     school 1804140 5900   Monroe-Gregg School District 180414002129 6315 Monrovia Middle School   Regular School No 2.0 06 08 2016   grade_7                         59.0 51.0                       110.0                         59 51                 110

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