enrollments

Data source: Big Local News · About: Big Local

3,528 rows where grade = "grade_8" and state = "IN" sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_8 · 3,428 ✖
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
1162026 1162026 IN     school 1810620 2455   Southeast Fountain School Corp 181062001742 2022 Fountain Central High School   Regular School No 3.0 07 12 2015   grade_8                         65.0 39.0                       104.0                         65 39                 104
1162335 1162335 IN     school 1805910 2950   Linton-Stockton School Corp 180591002147 2438 Linton-Stockton Jr High Sch   Regular School No 2.0 06 08 2015   grade_8                         55.0 49.0                       104.0                         55 49                 104
1168316 1168316 IN     school 1802220 6750   Cloverdale Community Schools 180222001283 7085 Cloverdale Middle School   Regular School No 2.0 05 08 2015   grade_8                         52.0 52.0                       104.0                         52 52                 104
1170219 1170219 IN     school 1806080 8115   M S D Warren County 180608001073 8737 Seeger Memorial Jr-Sr HS   Regular School No 3.0 07 12 2015   grade_8                         53.0 51.0                       104.0                         53 51                 104
1285795 1285795 IN     school 1804620 4590   River Forest Community Sch Corp 180462000780 3801 River Forest Middle School   Regular School No 2.0 06 08 2016   grade_8                         48.0 56.0                       104.0                         48 56                 104
1752936 1752936 IN     school 1802440 1300   Crawford County Community Sch Corp 180244000282 1061 Crawford County Middle School   Regular School No Middle 06 08 2019   grade_8                         50.0 54.0                       104.0                         50 54                 104
1754397 1754397 IN     school 1805910 2950   Linton-Stockton School Corporation 180591002147 2438 Linton-Stockton Middle School   Regular School No Middle 06 08 2019   grade_8                         57.0 47.0                       104.0                         57 47                 104
1788600 1788600 IN     school 1802160 1160   Clinton Prairie School Corporation 180216000258 977 Clinton Prairie Jr-Sr High School   Regular School No High 07 12 2018   grade_8                         57.0 47.0                       104.0                         57 47                 104
1791865 1791865 IN     school 1807830 4315   North Knox School Corp 180783001334 3537 North Knox Jr-Sr High School   Regular School No High 07 12 2018   grade_8                         38.0 66.0                       104.0                         38 66                 104
1792094 1792094 IN     school 1809300 4515   Prairie Heights Community Sch Corp 180930001525 3688 Prairie Heights Middle School   Regular School No Middle 05 08 2018   grade_8                         49.0 55.0                       104.0                         49 55                 104
1792481 1792481 IN     school 1802910 4680   Lake Station Community Schools 180291000380 3965 Thomas A Edison Jr-Sr HS   Regular School No High 06 12 2018   grade_8                         59.0 45.0                       104.0                         59 45                 104
1794071 1794071 IN     school 1804770 5385   Indianapolis Public Schools 180477002630 5467 HW Longfellow Med/STEM Magnet Midl   Regular School No Middle 07 08 2018   grade_8                         47.0 57.0                       104.0                         47 57                 104
1796165 1796165 IN     school 1810530 6865   South Ripley Com Sch Corp 181053002482 7174 South Ripley Junior High School   Regular School No Middle 07 08 2018   grade_8                         47.0 57.0                       104.0                         47 57                 104
1915608 1915608 IN     school 1807980 6715   North Putnam Community Schools 180798000316 7049 North Putnam Middle School   Regular School No Middle 06 08 2020   grade_8                         43.0 61.0                       104.0                         43 61                 104
1927074 1927074 IN     school 1800750 6460   MSD Boone Township 180075002216 6814 Hebron Middle School   Regular School No Middle 06 08 2021   grade_8                         50.0 54.0                       104.0                         50 54                 104
1927536 1927536 IN     school 1807980 6715   North Putnam Community Schools 180798000316 7049 North Putnam Middle School   Regular School No Middle 06 08 2021   grade_8                         49.0 55.0                       104.0                         49 55                 104
1930499 1930499 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2021   grade_8                         49.0 55.0                       104.0                         49 55                 104
1162048 1162048 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000589 2123 Brookville Middle Sch   Regular School No 2.0 05 08 2015   grade_8                         47.0 58.0                       105.0                         47 58                 105
1163786 1163786 IN     school 1810800 4000   Southwestern-Jefferson Co Con 181080002547 3343 Southwestern Middle School   Regular School No 2.0 06 08 2015   grade_8                         61.0 44.0                       105.0                         61 44                 105
1168985 1168985 IN     school 1809990 7230   Scott County School District 1 180999001606 7631 Austin Middle School   Regular School No 2.0 06 08 2015   grade_8                         55.0 50.0                       105.0                         55 50                 105
1290923 1290923 IN     school 1811340 7865   Tippecanoe School Corp 181134001833 8026 Wainwright Middle School   Regular School No 2.0 06 08 2016   grade_8                         57.0 48.0                       105.0                         57 48                 105
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
1762165 1762165 IN     school 1806080 8115   M S D Warren County 180608001073 8737 Seeger Memorial Jr-Sr High School   Regular School No High 07 12 2019   grade_8                         45.0 60.0                       105.0                         45 60                 105
1762313 1762313 IN     school 1803000 8215   East Washington School Corp 180300000073 8906 East Washington Middle School   Regular School No Middle 05 08 2019   grade_8                         54.0 51.0                       105.0                         54 51                 105
1796684 1796684 IN     school 1811910 7215   Union-North United School Corp 181191001879 7399 LaVille Jr-Sr High School   Regular School No High 07 12 2018   grade_8                         53.0 52.0                       105.0                         53 52                 105
1797368 1797368 IN     school 1811610 7950   Union Co/Clg Corner Joint Sch Dist 181161001868 8206 Union County Middle School   Regular School No Middle 06 08 2018   grade_8                         51.0 54.0                       105.0                         51 54                 105
1907909 1907909 IN     school 1802700 755   Delphi Community School Corp 180270000327 609 Delphi Community Middle School   Regular School No Middle 06 08 2020   grade_8                         50.0 55.0                       105.0                         50 55                 105
1911777 1911777 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko Jr/Sr High School   Regular School No High 07 12 2020   grade_8                         58.0 47.0                       105.0                         58 47                 105
1914686 1914686 IN     school 1804140 5900   Monroe-Gregg School District 180414002129 6315 Monrovia Middle School   Regular School No Middle 06 08 2020   grade_8                         55.0 50.0                       105.0                         55 50                 105
1919914 1919914 IN     school 1810680 815   Lewis Cass Schools 181068002625 691 Lewis Cass Junior High School   Regular School No Middle 06 08 2021   grade_8                         54.0 51.0                       105.0                         54 51                 105
1923540 1923540 IN     school 1810410 4325   South Knox School Corp 181041001706 3490 South Knox Middle-High School   Regular School No High 07 12 2021   grade_8                         54.0 51.0                       105.0                         54 51                 105
1926874 1926874 IN     school 1808640 6155   Paoli Community School Corp 180864001438 6581 Paoli Jr & Sr High School   Regular School No High 07 12 2021   grade_8                         54.0 51.0                       105.0                         54 51                 105
1161109 1161109 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_8                         52.0 54.0                       106.0                         52 54                 106
1170569 1170569 IN     school 1800720 8445   M S D Bluffton-Harrison 180072000147 9093 Bluffton-Harrison Middle Sch   Regular School No 2.0 05 08 2015   grade_8                         53.0 53.0                       106.0                         53 53                 106
1289685 1289685 IN     school 1807980 6715   North Putnam Community Schools 180798000316 7049 North Putnam Middle Sch   Regular School No 2.0 06 08 2016   grade_8                         58.0 48.0                       106.0                         58 48                 106
1289824 1289824 IN     school 1810530 6865   South Ripley Com Sch Corp 181053002482 7174 South Ripley Junior High School   Regular School No 2.0 07 08 2016   grade_8                         57.0 49.0                       106.0                         57 49                 106
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
1753297 1753297 IN     school 1805880 1895   Liberty-Perry Community Sch Corp 180588001046 1377 Selma Middle School   Regular School No Middle 06 08 2019   grade_8                         55.0 51.0                       106.0                         55 51                 106
1761302 1761302 IN     school 1811220 7775   Switzerland County School Corp 181122000806 7987 Switzerland Co Middle School   Regular School No Middle 07 08 2019   grade_8                         55.0 51.0                       106.0                         55 51                 106
1761553 1761553 IN     school 1811610 7950   Union Co/Clg Corner Joint Sch Dist 181161001868 8206 Union County Middle School   Regular School No Middle 06 08 2019   grade_8                         52.0 54.0                       106.0                         52 54                 106
1797921 1797921 IN     school 1812150 8060   Wabash City Schools 181215002301 8694 Wabash Middle School   Regular School No Middle 05 08 2018   grade_8                         61.0 45.0                       106.0                         61 45                 106
1917818 1917818 IN     school 1808190 8375   Northeastern Wayne Schools 180819002567 8929 Northeastern Middle School   Regular School No Middle 06 08 2020   grade_8                         46.0 60.0                       106.0                         46 60                 106
1923745 1923745 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko Jr/Sr High School   Regular School No High 07 12 2021   grade_8                         52.0 54.0                       106.0                         52 54                 106
1927222 1927222 IN     school 1811700 6530   Union Township School Corp 181170000793 6843 Union Township Middle School   Regular School No Middle 06 08 2021   grade_8                         55.0 51.0                       106.0                         55 51                 106
1169197 1169197 IN     school 1810560 7445   South Spencer County Sch Corp 181056001734 7797 South Spencer Middle School   Regular School No 2.0 06 08 2015   grade_8                         47.0 60.0                       107.0                         47 60                 107
1284590 1284590 IN     school 1806660 3335   Mill Creek Community Sch Corp 180666001170 2687 Cascade Middle School   Regular School No 2.0 06 08 2016   grade_8                         53.0 54.0                       107.0                         53 54                 107
1755477 1755477 IN     school 1805370 3500   Kokomo School Corporation 180537000995 2951 Bon Air Middle School   Regular School No Middle 06 08 2019   grade_8                         53.0 54.0                       107.0                         53 54                 107
1756320 1756320 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko Jr/Sr High School   Regular School No High 07 12 2019   grade_8                         49.0 58.0                       107.0                         49 58                 107
1757419 1757419 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002050 5005 Frankton Jr-Sr High School   Regular School No High 07 12 2019   grade_8                         61.0 46.0                       107.0                         61 46                 107
1795292 1795292 IN     school 1801710 6055   Central Noble Com School Corp 180171000230 6453 Central Noble Junior Senior HS   Regular School No High 06 12 2018   grade_8                         57.0 50.0                       107.0                         57 50                 107
1912154 1912154 IN     school 1802910 4680   Lake Station Community Schools 180291000380 3965 Thomas A Edison Jr-Sr HS   Regular School No High 06 12 2020   grade_8                         55.0 52.0                       107.0                         55 52                 107
1918955 1918955 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2021   grade_8                         54.0 53.0                       107.0                         54 53                 107
1159985 1159985 IN     school 1802850 255   East Allen County Schools 180285000344 81 Heritage Jr/Sr High School   Regular School No 3.0 07 12 2015   grade_8                         49.0 59.0                       108.0                         49 59                 108
1160399 1160399 IN     school 1802700 755   Delphi Community School Corp 180270000327 609 Delphi Community Middle Sch   Regular School No 2.0 06 08 2015   grade_8                         46.0 62.0                       108.0                         46 62                 108
1162325 1162325 IN     school 1803090 2940   Eastern Greene Schools 180309002419 2436 Eastern Greene Middle School   Regular School No 2.0 05 08 2015   grade_8                         60.0 48.0                       108.0                         60 48                 108
1165383 1165383 IN     school 1807860 5075   North Lawrence Com Schools 180786000446 4878 Oolitic Middle School   Regular School No 2.0 06 08 2015   grade_8                         50.0 58.0                       108.0                         50 58                 108
1168189 1168189 IN     school 1807950 6600   M S D North Posey Co Schools 180795001365 6973 North Posey Jr High Sch   Regular School No 2.0 07 08 2015   grade_8                         54.0 54.0                       108.0                         54 54                 108
1168487 1168487 IN     school 1806630 6910   Milan Community Schools 180663001626 7207 Milan Middle School   Regular School No 2.0 06 08 2015   grade_8                         55.0 53.0                       108.0                         55 53                 108
1281795 1281795 IN     school 1802700 755   Delphi Community School Corp 180270000327 609 Delphi Community Middle School   Regular School No 2.0 06 08 2016   grade_8                         56.0 52.0                       108.0                         56 52                 108
1283746 1283746 IN     school 1805910 2950   Linton-Stockton School Corp 180591002147 2438 Linton-Stockton Jr High School   Regular School No 2.0 06 08 2016   grade_8                         57.0 51.0                       108.0                         57 51                 108
1285689 1285689 IN     school 1809300 4515   Prairie Heights Com Sch Corp 180930001525 3688 Prairie Heights Middle School   Regular School No 2.0 05 08 2016   grade_8                         51.0 57.0                       108.0                         51 57                 108
1290774 1290774 IN     school 1811220 7775   Switzerland County School Corp 181122000806 7987 Switzerland Co Middle School   Regular School No 2.0 07 08 2016   grade_8                         52.0 56.0                       108.0                         52 56                 108
1756104 1756104 IN     school 1807830 4315   North Knox School Corp 180783001334 3537 North Knox Jr-Sr High School   Regular School No High 07 12 2019   grade_8                         49.0 59.0                       108.0                         49 59                 108
1762398 1762398 IN     school 1808190 8375   Northeastern Wayne Schools 180819002567 8929 Northeastern Middle School   Regular School No Middle 06 08 2019   grade_8                         55.0 53.0                       108.0                         55 53                 108
1907948 1907948 IN     school 1810680 815   Lewis Cass Schools 181068002625 691 Lewis Cass Junior High School   Regular School No Middle 06 08 2020   grade_8                         57.0 51.0                       108.0                         57 51                 108
1910868 1910868 IN     school 1803150 3480   Eastern Howard School Corporation 180315002589 2914 Eastern Middle School   Regular School No Middle 06 08 2020   grade_8                         54.0 54.0                       108.0                         54 54                 108
1915104 1915104 IN     school 1801740 6325   Perry Central Com Schools Corp 180174000234 6708 Perry Central Jr-Sr High School   Regular School No High 07 12 2020   grade_8                         63.0 45.0                       108.0                         63 45                 108
1926136 1926136 IN     school 1800900 5480   Bremen Public Schools 180090000166 5943 Bremen Elementary/Middle School   Regular School No Elementary KG 08 2021   grade_8                         62.0 46.0                       108.0                         62 46                 108
1929866 1929866 IN     school 1800720 8445   MSD Bluffton-Harrison 180072000147 9093 Bluffton-Harrison Middle School   Regular School No Middle 05 08 2021   grade_8                         55.0 53.0                       108.0                         55 53                 108
1162221 1162221 IN     school 1806240 2825   Madison-Grant United Sch Corp 180624002279 2328 Madison-Grant Jr High Sch   Regular School No 2.0 07 08 2015   grade_8                         50.0 59.0                       109.0                         50 59                 109
1167773 1167773 IN     school 1801740 6325   Perry Central Com Schools Corp 180174000234 6708 Perry Central Jr-Sr High Sch   Regular School No 3.0 07 12 2015   grade_8                         53.0 56.0                       109.0                         53 56                 109
1169073 1169073 IN     school 1808310 7350   Northwestern Con School Corp 180831001425 7697 Triton Central Middle School   Regular School No 2.0 05 08 2015   grade_8                         63.0 46.0                       109.0                         63 46                 109
1282511 1282511 IN     school 1803060 1805   DeKalb Co Eastern Com Sch Dist 180306000405 1317 Eastside Junior-Senior High School   Regular School No 3.0 07 12 2016   grade_8                         60.0 49.0                       109.0                         60 49                 109
1288308 1288308 IN     school 1800900 5480   Bremen Public Schools 180090000166 5943 Bremen Elem/Middle School   Regular School No 1.0 KG 08 2016   grade_8                         59.0 50.0                       109.0                         59 50                 109
1290344 1290344 IN     school 1811910 7215   Union-North United School Corp 181191001879 7399 LaVille Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_8                         61.0 48.0                       109.0                         61 48                 109
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
1755644 1755644 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105000181 3107 Brownstown Central Middle School   Regular School No Middle 06 08 2019   grade_8                         58.0 51.0                       109.0                         58 51                 109
1759896 1759896 IN     school 1809180 6520   Porter Township School Corp 180918000523 6839 Boone Grove Middle School   Regular School No Middle 06 08 2019   grade_8                         55.0 54.0                       109.0                         55 54                 109
1759912 1759912 IN     school 1811700 6530   Union Township School Corp 181170000793 6843 Union Township Middle School   Regular School No Middle 06 08 2019   grade_8                         55.0 54.0                       109.0                         55 54                 109
1760199 1760199 IN     school 1807980 6715   North Putnam Community Schools 180798000316 7049 North Putnam Middle School   Regular School No Middle 06 08 2019   grade_8                         54.0 55.0                       109.0                         54 55                 109
1787325 1787325 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No Middle 06 08 2018   grade_8                         58.0 51.0                       109.0                         58 51                 109
1796562 1796562 IN     school 1810290 7205   South Bend Community School Corp 181029001681 7537 Edison Middle School   Regular School No Middle 05 08 2018   grade_8                         62.0 47.0                       109.0                         62 47                 109
1908288 1908288 IN     school 1802160 1160   Clinton Prairie School Corporation 180216000258 977 Clinton Prairie Jr-Sr High School   Regular School No High 07 12 2020   grade_8                         55.0 54.0                       109.0                         55 54                 109
1918901 1918901 IN     school 1800164 9965   Career Academy Middle School 180016402593 7563 Career Academy Middle School   Regular School Yes Middle 06 08 2020   grade_8                         64.0 45.0                       109.0                         64 45                 109
1166819 1166819 IN     school 1800105 5390   Southside Sp Srvs Of Marion Co 180010502502 5320 RISE Learning Center   Regular School No 4.0 KG 12 2015   grade_8                         8.0 3.0                       11.0                         8 3                 11
1170121 1170121 IN     school 1812090 8030   Vigo County School Corp 181209000926 8612 McLean Education Center (Alt)   Regular School No 4.0 06 12 2015   grade_8                         9.0 2.0                       11.0                         9 2                 11
1171265 1171265 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes 4.0 03 11 2015   grade_8                         11.0 0.0                       11.0                         11 0                 11
1283101 1283101 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No 4.0 01 12 2016   grade_8                         8.0 3.0                       11.0                         8 3                 11
1290083 1290083 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Joint Service Campus Program   Special Education School No 4.0 04 12 2016   grade_8                         9.0 2.0                       11.0                         9 2                 11
1292634 1292634 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes 4.0 02 12 2016   grade_8                         11.0 0.0                       11.0                         11 0                 11
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
1762468 1762468 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other KG 12 2019   grade_8                         9.0 2.0                       11.0                         9 2                 11
1762772 1762772 IN     school 1800006 9100   Indiana Department of Correction 180000601946 732 Logansport Juvenile Correctional   Regular School No High 07 12 2019   grade_8                         11.0 0.0                       11.0                         11 0                 11
1789159 1789159 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 03 12 2018   grade_8                         10.0 1.0                       11.0                         10 1                 11
1795316 1795316 IN     school 1802970 6060   East Noble School Corporation 180297000389 6458 East Noble High School   Regular School No High 08 12 2018   grade_8                         8.0 3.0                       11.0                         8 3                 11

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