enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_8 · 3,528 ✖
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
1159499 1159499 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No 2.0 06 08 2015   grade_8                         45.0 54.0                       99.0                         45 54                 99
1283737 1283737 IN     school 1803090 2940   Eastern Greene Schools 180309002419 2436 Eastern Greene Middle School   Regular School No 2.0 05 08 2016   grade_8                         56.0 43.0                       99.0                         56 43                 99
1289194 1289194 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_8                         63.0 36.0                       99.0                         63 36                 99
1291772 1291772 IN     school 1807380 8305   Nettle Creek School Corp 180738001261 8985 Hagerstown Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_8                         50.0 49.0                       99.0                         50 49                 99
1301097 1301097 IN     school 1808640 6155   Paoli Community School Corp 180864001438 6581 Paoli Jr & Sr High School   Regular School No High 07 12 2017   grade_8                         51.0 48.0                       99.0                         51 48                 99
1301847 1301847 IN     school 1810530 6865   South Ripley Com Sch Corp 181053002482 7174 South Ripley Junior High School   Regular School No Middle 07 08 2017   grade_8                         56.0 43.0                       99.0                         56 43                 99
1759587 1759587 IN     school 1808640 6155   Paoli Community School Corp 180864001438 6581 Paoli Jr & Sr High School   Regular School No High 07 12 2019   grade_8                         53.0 46.0                       99.0                         53 46                 99
1760895 1760895 IN     school 1809990 7230   Scott County School District 1 180999001606 7631 Austin Middle School   Regular School No Middle 06 08 2019   grade_8                         43.0 56.0                       99.0                         43 56                 99
1761774 1761774 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000477 8339 McGary Middle School   Regular School No Middle 06 08 2019   grade_8                         52.0 47.0                       99.0                         52 47                 99
1763509 1763509 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Other KG 11 2019   grade_8                         51.0 48.0                       99.0                         51 48                 99
1791124 1791124 IN     school 1811250 3460   Taylor Community School Corp 181125001263 2896 Taylor Middle School   Regular School No Middle 06 08 2018   grade_8                         47.0 52.0                       99.0                         47 52                 99
1799280 1799280 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Secondary 07 10 2018   grade_8                         54.0 45.0                       99.0                         54 45                 99
1915508 1915508 IN     school 1807950 6600   M S D North Posey Co Schools 180795001365 6973 North Posey Junior High School   Regular School No Middle 07 08 2020   grade_8                         51.0 48.0                       99.0                         51 48                 99
1916394 1916394 IN     school 1808310 7350   Northwestern Con School Corp 180831001425 7697 Triton Central Middle School   Regular School No Middle 05 08 2020   grade_8                         54.0 45.0                       99.0                         54 45                 99
1918033 1918033 IN     school 1810230 8625   Smith-Green Community Schools 181023001638 9193 Churubusco Jr-Sr High School   Regular School No High 06 12 2020   grade_8                         50.0 49.0                       99.0                         50 49                 99
1924905 1924905 IN     school 1803300 5280   Elwood Community School Corp 180330000449 5149 Elwood Jr-Sr High School   Regular School No High 07 12 2021   grade_8                         48.0 51.0                       99.0                         48 51                 99
1927693 1927693 IN     school 1810530 6865   South Ripley Com Sch Corp 181053002482 7174 South Ripley Junior High School   Regular School No Middle 07 08 2021   grade_8                         48.0 51.0                       99.0                         48 51                 99
1160556 1160556 IN     school 1801920 1000   Clarksville Com School Corp 180192000248 851 Clarksville Middle School   Regular School No 2.0 05 08 2015   grade_8                         53.0 45.0                       98.0                         53 45                 98
1161235 1161235 IN     school 1805880 1895   Liberty-Perry Com School Corp 180588001046 1377 Selma Middle School   Regular School No 2.0 06 08 2015   grade_8                         41.0 57.0                       98.0                         41 57                 98
1167549 1167549 IN     school 1801710 6055   Central Noble Com School Corp 180171000230 6453 Central Noble Junior Senior HS   Regular School No 4.0 06 12 2015   grade_8                         53.0 45.0                       98.0                         53 45                 98
1282186 1282186 IN     school 1802160 1160   Clinton Prairie School Corp 180216000258 977 Clinton Prairie Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_8                         45.0 53.0                       98.0                         45 53                 98
1290284 1290284 IN     school 1810290 7205   South Bend Community Sch Corp 181029001666 7581 Marshall Intermediate Center   Regular School No 2.0 05 08 2016   grade_8                         61.0 37.0                       98.0                         61 37                 98
1291578 1291578 IN     school 1812150 8060   Wabash City Schools 181215002301 8694 Wabash Middle School   Regular School No 2.0 05 08 2016   grade_8                         49.0 49.0                       98.0                         49 49                 98
1301223 1301223 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_8                         48.0 50.0                       98.0                         48 50                 98
1301407 1301407 IN     school 1809180 6520   Porter Township School Corp 180918000523 6839 Boone Grove Middle School   Regular School No Middle 06 08 2017   grade_8                         46.0 52.0                       98.0                         46 52                 98
1759444 1759444 IN     school 1807920 5945   North Newton School Corp 180792001363 6411 North Newton Jr-Sr High School   Regular School No High 07 12 2019   grade_8                         43.0 55.0                       98.0                         43 55                 98
1790647 1790647 IN     school 1803120 3145   Eastern Hancock Co Com Sch Corp 180312000658 2582 Eastern Hancock Middle School   Regular School No Middle 06 08 2018   grade_8                         46.0 52.0                       98.0                         46 52                 98
1794322 1794322 IN     school 1804770 5385   Indianapolis Public Schools 180477000872 5570 Edison School of the Arts 47   Regular School No Elementary KG 08 2018   grade_8                         32.0 66.0                       98.0                         32 66                 98
1798536 1798536 IN     school 1800179 9120   Insight School of Indiana 180017902601 2528 Insight School of Indiana   Regular School Yes High 07 12 2018   grade_8                         35.0 63.0                       98.0                         35 63                 98
1907012 1907012 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 06 08 2020   grade_8                         43.0 55.0                       98.0                         43 55                 98
1909706 1909706 IN     school 1806240 2825   Madison-Grant United School Corp 180624001097 2321 Madison-Grant Jr./Sr. High School   Regular School No High 07 12 2020   grade_8                         52.0 46.0                       98.0                         52 46                 98
1915127 1915127 IN     school 1811260 6350   Tell City-Troy Twp School Corp 181126001819 6741 Tell City Jr-Sr High School   Regular School No High 07 12 2020   grade_8                         43.0 55.0                       98.0                         43 55                 98
1915731 1915731 IN     school 1801770 6825   Randolph Central School Corp 180177000235 7129 Lee L Driver Middle School   Regular School No Middle 06 08 2020   grade_8                         49.0 49.0                       98.0                         49 49                 98
1168254 1168254 IN     school 1810500 6705   South Putnam Community Schools 181050002542 7056 South Putnam Middle School   Regular School No 2.0 06 08 2015   grade_8                         55.0 42.0                       97.0                         55 42                 97
1168374 1168374 IN     school 1807080 6820   Monroe Central School Corp 180708001202 7151 Monroe Central Jr-Sr High Sch   Regular School No 3.0 07 12 2015   grade_8                         60.0 37.0                       97.0                         60 37                 97
1171498 1171498 IN     school 1800139 9940   Tindley Collegiate Academy 180013902559 5914 Tindley Collegiate Academy   Regular School Yes 2.0 05 08 2015   grade_8                         0.0 97.0                       97.0                         0 97                 97
1282487 1282487 IN     school 1802610 1655   Decatur County Com Schools 180261000309 1267 North Decatur Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_8                         52.0 45.0                       97.0                         52 45                 97
1285192 1285192 IN     school 1810800 4000   Southwestern-Jefferson Co Con 181080002547 3343 Southwestern Middle School   Regular School No 2.0 06 08 2016   grade_8                         51.0 46.0                       97.0                         51 46                 97
1294522 1294522 IN     school 1802610 1655   Decatur County Community Schools 180261000309 1267 North Decatur Jr-Sr High School   Regular School No High 07 12 2017   grade_8                         47.0 50.0                       97.0                         47 50                 97
1301732 1301732 IN     school 1802220 6750   Cloverdale Community Schools 180222001283 7085 Cloverdale Middle School   Regular School No Middle 05 08 2017   grade_8                         43.0 54.0                       97.0                         43 54                 97
1301906 1301906 IN     school 1806630 6910   Milan Community Schools 180663001626 7207 Milan Middle School   Regular School No Middle 06 08 2017   grade_8                         47.0 50.0                       97.0                         47 50                 97
1302234 1302234 IN     school 1810290 7205   South Bend Community School Corp 181029002296 7521 Brown Intermediate Center   Regular School No Elementary 03 08 2017   grade_8                         54.0 43.0                       97.0                         54 43                 97
1759694 1759694 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_8                         51.0 46.0                       97.0                         51 46                 97
1760099 1760099 IN     school 1807950 6600   M S D North Posey Co Schools 180795001365 6973 North Posey Junior High School   Regular School No Middle 07 08 2019   grade_8                         49.0 48.0                       97.0                         49 48                 97
1762715 1762715 IN     school 1800188 9045   J & R Phalen Leadership Academy 180018802618 4894 J & R Phalen Leadership Academy   Regular School Yes Middle 07 09 2019   grade_8                         49.0 48.0                       97.0                         49 48                 97
1789036 1789036 IN     school 1805880 1895   Liberty-Perry Community Sch Corp 180588001046 1377 Selma Middle School   Regular School No Middle 06 08 2018   grade_8                         47.0 50.0                       97.0                         47 50                 97
1796110 1796110 IN     school 1807080 6820   Monroe Central School Corp 180708001202 7151 Monroe Central Jr-Sr High School   Regular School No High 07 12 2018   grade_8                         54.0 43.0                       97.0                         54 43                 97
1913937 1913937 IN     school 1804770 5385   Indianapolis Public Schools 180477000872 5570 Edison School of the Arts 47   Regular School No Elementary KG 08 2020   grade_8                         45.0 52.0                       97.0                         45 52                 97
1921772 1921772 IN     school 1803090 2940   Eastern Greene Schools 180309002419 2436 Eastern Greene Middle School   Regular School No Middle 05 08 2021   grade_8                         57.0 40.0                       97.0                         57 40                 97
1924123 1924123 IN     school 1802910 4680   Lake Station Community Schools 180291000380 3965 Thomas A Edison Jr-Sr HS   Regular School No High 06 12 2021   grade_8                         42.0 55.0                       97.0                         42 55                 97
1928621 1928621 IN     school 1810860 7715   Southwest School Corporation 181086002359 7961 Sullivan Middle School   Regular School No Middle 06 08 2021   grade_8                         54.0 43.0                       97.0                         54 43                 97
1929960 1929960 IN     school 1810230 8625   Smith-Green Community Schools 181023001638 9193 Churubusco Jr-Sr High School   Regular School No High 06 12 2021   grade_8                         51.0 46.0                       97.0                         51 46                 97
1170921 1170921 IN     school 1800028 9400   KIPP Indpls College Preparatory 180002802136 5860 KIPP Indy College Prep Middle   Regular School Yes 2.0 05 08 2015   grade_8                         44.0 52.0                       96.0                         44 52                 96
1284711 1284711 IN     school 1801060 3455   C A Beard Memorial School Corp 180106002012 2870 Knightstown Intermediate School   Regular School No 2.0 04 08 2016   grade_8                         63.0 33.0                       96.0                         63 33                 96
1289708 1289708 IN     school 1802220 6750   Cloverdale Community Schools 180222001283 7085 Cloverdale Middle School   Regular School No 2.0 05 08 2016   grade_8                         45.0 51.0                       96.0                         45 51                 96
1290581 1290581 IN     school 1810560 7445   South Spencer County Sch Corp 181056001734 7797 South Spencer Middle School   Regular School No 2.0 06 08 2016   grade_8                         46.0 50.0                       96.0                         46 50                 96
1294009 1294009 IN     school 1801920 1000   Clarksville Community School Corp 180192000248 851 Clarksville Middle School   Regular School No Middle 05 08 2017   grade_8                         44.0 52.0                       96.0                         44 52                 96
1297509 1297509 IN     school 1807830 4315   North Knox School Corp 180783001334 3537 North Knox Jr-Sr High School   Regular School No High 07 12 2017   grade_8                         52.0 44.0                       96.0                         52 44                 96
1752458 1752458 IN     school 1801290 750   Carroll Consolidated School Corp 180129002573 623 Carroll Junior High School   Regular School No Middle 07 08 2019   grade_8                         45.0 51.0                       96.0                         45 51                 96
1755823 1755823 IN     school 1810800 4000   Southwestern-Jefferson Co Con 181080002547 3343 Southwestern Middle School   Regular School No Middle 06 08 2019   grade_8                         52.0 44.0                       96.0                         52 44                 96
1756124 1756124 IN     school 1810410 4325   South Knox School Corp 181041001706 3490 South Knox Middle-High School   Regular School No High 07 12 2019   grade_8                         64.0 32.0                       96.0                         64 32                 96
1762668 1762668 IN     school 1800126 8810   CSUSA Howe 180012601445 5639 Thomas Carr Howe Comm High School   Regular School No High 07 12 2019   grade_8                         59.0 37.0                       96.0                         59 37                 96
1911581 1911581 IN     school 1810410 4325   South Knox School Corp 181041001706 3490 South Knox Middle-High School   Regular School No High 07 12 2020   grade_8                         45.0 51.0                       96.0                         45 51                 96
1917179 1917179 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000477 8339 McGary Middle School   Regular School No Middle 06 08 2020   grade_8                         48.0 48.0                       96.0                         48 48                 96
1919863 1919863 IN     school 1801290 750   Carroll Consolidated School Corp 180129002573 623 Carroll Junior High School   Regular School No Middle 07 08 2021   grade_8                         44.0 52.0                       96.0                         44 52                 96
1922791 1922791 IN     school 1811250 3460   Taylor Community School Corp 181125001263 2896 Taylor Middle School   Regular School No Middle 05 08 2021   grade_8                         43.0 53.0                       96.0                         43 53                 96
1160386 1160386 IN     school 1801290 750   Carroll Consolidated Sch Corp 180129002573 623 Carroll Junior High School   Regular School No 2.0 07 08 2015   grade_8                         45.0 50.0                       95.0                         45 50                 95
1160918 1160918 IN     school 1807710 1375   North Daviess Com Schools 180771001319 1121 North Daviess Jr-Sr High Sch   Regular School No 3.0 07 12 2015   grade_8                         51.0 44.0                       95.0                         51 44                 95
1280854 1280854 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No 2.0 06 08 2016   grade_8                         44.0 51.0                       95.0                         44 51                 95
1286202 1286202 IN     school 1803870 4690   Gary Community School Corp 180387002199 4168 Wm A Wirt/Emerson VPA   Regular School No 4.0 05 12 2016   grade_8                         40.0 55.0                       95.0                         40 55                 95
1288947 1288947 IN     school 1801710 6055   Central Noble Com School Corp 180171000230 6453 Central Noble Junior Senior HS   Regular School No 4.0 06 12 2016   grade_8                         49.0 46.0                       95.0                         49 46                 95
1289621 1289621 IN     school 1807110 6620   Eastern Pulaski Com Sch Corp 180711001206 6996 Winamac Community Middle School   Regular School No 2.0 06 08 2016   grade_8                         47.0 48.0                       95.0                         47 48                 95
1290621 1290621 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 2016   grade_8                         41.0 54.0                       95.0                         41 54                 95
1295481 1295481 IN     school 1810620 2455   Southeast Fountain School Corp 181062001742 2022 Fountain Central High School   Regular School No High 07 12 2017   grade_8                         50.0 45.0                       95.0                         50 45                 95
1302249 1302249 IN     school 1810290 7205   South Bend Community School Corp 181029001681 7537 Edison Intermediate Center   Regular School No Middle 05 08 2017   grade_8                         49.0 46.0                       95.0                         49 46                 95
1302609 1302609 IN     school 1810560 7445   South Spencer County Sch Corp 181056001734 7797 South Spencer Middle School   Regular School No Middle 06 08 2017   grade_8                         58.0 37.0                       95.0                         58 37                 95
1302782 1302782 IN     school 1810860 7715   Southwest School Corporation 181086002359 7961 Sullivan Middle School   Regular School No Middle 06 08 2017   grade_8                         45.0 50.0                       95.0                         45 50                 95
1302802 1302802 IN     school 1811220 7775   Switzerland County School Corp 181122000806 7987 Switzerland Co Middle School   Regular School No Middle 07 08 2017   grade_8                         57.0 38.0                       95.0                         57 38                 95
1752974 1752974 IN     school 1807710 1375   North Daviess Com Schools 180771001319 1121 North Daviess Jr-Sr High School   Regular School No High 07 12 2019   grade_8                         48.0 47.0                       95.0                         48 47                 95
1755361 1755361 IN     school 1801060 3455   C A Beard Memorial School Corp 180106002012 2870 Knightstown Intermediate School   Regular School No Middle 04 08 2019   grade_8                         52.0 43.0                       95.0                         52 43                 95
1763021 1763021 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes Other KG 12 2019   grade_8                         48.0 47.0                       95.0                         48 47                 95
1790124 1790124 IN     school 1803090 2940   Eastern Greene Schools 180309002419 2436 Eastern Greene Middle School   Regular School No Middle 05 08 2018   grade_8                         42.0 53.0                       95.0                         42 53                 95
1797267 1797267 IN     school 1811340 7865   Tippecanoe School Corp 181134001833 8026 Wainwright Middle School   Regular School No Middle 06 08 2018   grade_8                         49.0 46.0                       95.0                         49 46                 95
1797950 1797950 IN     school 1806080 8115   M S D Warren County 180608001073 8737 Seeger Memorial Jr-Sr High School   Regular School No High 07 12 2018   grade_8                         44.0 51.0                       95.0                         44 51                 95
1912507 1912507 IN     school 1813200 4760   School City of Whiting 181320000398 4356 Whiting Middle School   Regular School No Middle 06 08 2020   grade_8                         49.0 46.0                       95.0                         49 46                 95
1915543 1915543 IN     school 1807110 6620   Eastern Pulaski Community Sch Corp 180711001206 6996 Winamac Community Middle School   Regular School No Middle 06 08 2020   grade_8                         57.0 38.0                       95.0                         57 38                 95
1916278 1916278 IN     school 1811910 7215   Union-North United School Corp 181191001879 7399 LaVille Jr-Sr High School   Regular School No High 07 12 2020   grade_8                         49.0 46.0                       95.0                         49 46                 95
1923231 1923231 IN     school 1810800 4000   Southwestern-Jefferson Co Con 181080002547 3343 Southwestern Middle School   Regular School No Middle 06 08 2021   grade_8                         48.0 47.0                       95.0                         48 47                 95
1159464 1159464 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No 2.0 06 08 2015   grade_8                         46.0 48.0                       94.0                         46 48                 94
1168222 1168222 IN     school 1807110 6620   Eastern Pulaski Com Sch Corp 180711001206 6996 Winamac Community Middle Sch   Regular School No 2.0 06 08 2015   grade_8                         49.0 45.0                       94.0                         49 45                 94
1168429 1168429 IN     school 1810530 6865   South Ripley Com Sch Corp 181053002482 7174 South Ripley Junior High School   Regular School No 2.0 07 08 2015   grade_8                         44.0 50.0                       94.0                         44 50                 94
1280889 1280889 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No 2.0 06 08 2016   grade_8                         49.0 45.0                       94.0                         49 45                 94
1284823 1284823 IN     school 1805370 3500   Kokomo School Corporation 180537000995 2951 Bon Air Middle School   Regular School No 2.0 06 08 2016   grade_8                         57.0 37.0                       94.0                         57 37                 94
1291835 1291835 IN     school 1808190 8375   Northeastern Wayne Schools 180819002567 8929 Northeastern Middle School   Regular School No 2.0 06 08 2016   grade_8                         50.0 44.0                       94.0                         50 44                 94
1302397 1302397 IN     school 1809990 7230   Scott County School District 1 180999001606 7631 Austin Middle School   Regular School No Middle 06 08 2017   grade_8                         52.0 42.0                       94.0                         52 42                 94
1908075 1908075 IN     school 1801920 1000   Clarksville Community School Corp 180192000248 851 Clarksville Middle School   Regular School No Middle 05 08 2020   grade_8                         63.0 31.0                       94.0                         63 31                 94
1919483 1919483 IN     school 1802850 255   East Allen County Schools 180285000361 285 Woodlan Jr/Sr High School   Regular School No High 07 12 2021   grade_8                         46.0 48.0                       94.0                         46 48                 94
1921669 1921669 IN     school 1806240 2825   Madison-Grant United School Corp 180624001097 2321 Madison-Grant Jr./Sr. High School   Regular School No High 07 12 2021   grade_8                         42.0 52.0                       94.0                         42 52                 94
1160493 1160493 IN     school 1809370 940   West Clark Community Schools 180937001531 765 Henryville Jr & Sr High Sch   Regular School No 3.0 07 12 2015   grade_8                         51.0 42.0                       93.0                         51 42                 93
1167879 1167879 IN     school 1800750 6460   M S D Boone Township 180075002216 6814 Hebron Middle School   Regular School No 2.0 06 08 2015   grade_8                         47.0 46.0                       93.0                         47 46                 93

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