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,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
1159644 1159644 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No 3.0 07 12 2015   grade_8                         1.0 0.0                       1.0                         1 0                 1
1164647 1164647 IN     school 1802880 4670   School City of East Chicago 180288000365 3937 Carrie Gosch Elementary School   Regular School No 1.0 PK 08 2015   grade_8                         0.0 1.0                       1.0                         0 1                 1
1168953 1168953 IN     school 1810290 7205   South Bend Community Sch Corp 181029000898 7632 Juvenile Justice Center   Alternative Education School No 3.0 07 12 2015   grade_8                         1.0 0.0                       1.0                         1 0                 1
1169101 1169101 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No 4.0 PK 12 2015   grade_8                         1.0 0.0                       1.0                         1 0                 1
1281036 1281036 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No 3.0 08 12 2016   grade_8                         1.0 0.0                       1.0                         1 0                 1
1282154 1282154 IN     school 1800840 1125   Clay Community Schools 180084000159 942 Forest Park Elementary School   Regular School No 1.0 PK 08 2016   grade_8                         1.0 0.0                       1.0                         1 0                 1
1284649 1284649 IN     school 1807440 3445   New Castle Community Sch Corp 180744001290 2825 New Castle High School   Regular School No 3.0 07 12 2016   grade_8                         0.0 1.0                       1.0                         0 1                 1
1284793 1284793 IN     school 1804470 3490   Western School Corp 180447002224 2923 Western Intermediate School   Regular School No 1.0 02 08 2016   grade_8                         0.0 1.0                       1.0                         0 1                 1
1286035 1286035 IN     school 1802880 4670   School City of East Chicago 180288000365 3937 Carrie Gosch Elementary School   Regular School No 1.0 PK 08 2016   grade_8                         0.0 1.0                       1.0                         0 1                 1
1296684 1296684 IN     school 1807440 3445   New Castle Community School Corp 180744001290 2825 New Castle High School   Regular School No High 08 12 2017   grade_8                         1.0 0.0                       1.0                         1 0                 1
1296827 1296827 IN     school 1804470 3490   Western School Corporation 180447002224 2923 Western Intermediate School   Regular School No Elementary 03 08 2017   grade_8                         0.0 1.0                       1.0                         0 1                 1
1298038 1298038 IN     school 1802490 4660   Crown Point Community School Corp 180249000293 3901 Crown Point High School   Regular School No High 08 12 2017   grade_8                         1.0 0.0                       1.0                         1 0                 1
1302365 1302365 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 07 12 2017   grade_8                         1.0 0.0                       1.0                         1 0                 1
1304155 1304155 IN     school 1800006 9100   Indiana Department of Corrections 180000601996 4846 Camp Summit Juvenile Facility   Regular School No High 08 12 2017   grade_8                         1.0 0.0                       1.0                         1 0                 1
1304169 1304169 IN     school 1800006 9100   Indiana Department of Corrections 180000601943 5452 Madison Juvenile Correctional   Regular School No High 08 12 2017   grade_8                         0.0 1.0                       1.0                         0 1                 1
1751722 1751722 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No High 08 12 2019   grade_8                         1.0 0.0                       1.0                         1 0                 1
1755300 1755300 IN     school 1807440 3445   New Castle Community School Corp 180744001290 2825 New Castle High School   Regular School No High 07 12 2019   grade_8                         1.0 0.0                       1.0                         1 0                 1
1755432 1755432 IN     school 1804470 3490   Western School Corporation 180447000756 2921 Western High School   Regular School No High 08 12 2019   grade_8                         0.0 1.0                       1.0                         0 1                 1
1755777 1755777 IN     school 1806120 3995   Madison Consolidated Schools 180612001090 3309 Madison Consolidated High School   Regular School No High 08 12 2019   grade_8                         1.0 0.0                       1.0                         1 0                 1
1787467 1787467 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 08 11 2018   grade_8                         1.0 0.0                       1.0                         1 0                 1
1790910 1790910 IN     school 1802550 3325   Danville Community School Corp 180255000304 2741 Danville Community High School   Regular School No High 08 12 2018   grade_8                         0.0 1.0                       1.0                         0 1                 1
1791039 1791039 IN     school 1807440 3445   New Castle Community School Corp 180744001290 2825 New Castle High School   Regular School No High 07 12 2018   grade_8                         0.0 1.0                       1.0                         0 1                 1
1791185 1791185 IN     school 1804470 3490   Western School Corporation 180447002224 2923 Western Intermediate School   Regular School No Middle 03 08 2018   grade_8                         0.0 1.0                       1.0                         0 1                 1
1791395 1791395 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105001408 3108 Jackson Co Juvenile Detention Cntr   Alternative School No High 08 12 2018   grade_8                         1.0 0.0                       1.0                         1 0                 1
1794800 1794800 IN     school 1808850 5635   Peru Community Schools 180885001476 6085 Peru High School   Regular School No High 08 12 2018   grade_8                         1.0 0.0                       1.0                         1 0                 1
1907162 1907162 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 08 11 2020   grade_8                         1.0 0.0                       1.0                         1 0                 1
1908004 1908004 IN     school 1806030 875   Logansport Community Sch Corp 180603001052 715 Columbia 6th Grade Academy   Regular School No Other 02 09 2020   grade_8                         1.0 0.0                       1.0                         1 0                 1
1908527 1908527 IN     school 1805700 1620   Lawrenceburg Community School Corp 180570001037 1177 Lawrenceburg High School   Regular School No High 08 12 2020   grade_8                         1.0 0.0                       1.0                         1 0                 1
1909788 1909788 IN     school   2865   Marion Community Schools   2416 Grant County Comm Justice Center             2020   grade_8                         1.0 0.0                       1.0                         1 0                 1
1910890 1910890 IN     school 1804470 3490   Western School Corporation 180447002224 2923 Western Intermediate School   Regular School No Middle 03 08 2020   grade_8                         1.0 0.0                       1.0                         1 0                 1
1916271 1916271 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No Secondary 06 11 2020   grade_8                         1.0 0.0                       1.0                         1 0                 1
1918230 1918230 IN     school 1800006 9100   Indiana Department of Correction 180000601946 732 Logansport Juvenile Correctional   Regular School No High 08 12 2020   grade_8                         1.0 0.0                       1.0                         1 0                 1
1919129 1919129 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 06 11 2021   grade_8                         1.0 0.0                       1.0                         1 0                 1
1919928 1919928 IN     school 1806030 875   Logansport Community Sch Corp 180603001060 701 Logansport Community High School   Regular School No High 07 12 2021   grade_8                         1.0 0.0                       1.0                         1 0                 1
1920987 1920987 IN     school 1802400 2270   Concord Community Schools 180240002484 1718 Concord Intermediate School   Regular School No Middle 04 08 2021   grade_8                         0.0 1.0                       1.0                         0 1                 1
1922626 1922626 IN     school 1808970 3330   Plainfield Community School Corp 180897002694 3331 Pride Academy   Regular School No Secondary 05 11 2021   grade_8                         1.0 0.0                       1.0                         1 0                 1
1927141 1927141 IN     school   6510   East Porter County School Corp   6811 Porter County Education Services             2021   grade_8                         1.0 0.0                       1.0                         1 0                 1
1289746 1289746 IN     school 1811730 6795   Union School Corporation 181173001875 7119 Union Junior & High School   Regular School No 3.0 07 12 2016   grade_8                         4.0 6.0                       10.0                         4 6                 10
1292846 1292846 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes 4.0 KG 12 2016   grade_8                         9.0 1.0                       10.0                         9 1                 10
1304162 1304162 IN     school 1800006 9100   Indiana Department of Corrections 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2017   grade_8                         10.0 0.0                       10.0                         10 0                 10
1304754 1304754 IN     school 1800087 9845   Xavier School of Excellence 180008702445 7571 Xavier School of Excellence   Regular School Yes Elementary KG 08 2017   grade_8                         3.0 7.0                       10.0                         3 7                 10
1918553 1918553 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2020   grade_8                         5.0 5.0                       10.0                         5 5                 10
1918889 1918889 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes Elementary KG 08 2020   grade_8                         1.0 9.0                       10.0                         1 9                 10
1929412 1929412 IN     school 1812090 8030   Vigo County School Corp 181209002344 8611 Booker T Washington Alt Sch   Alternative School No High 06 12 2021   grade_8                         9.0 1.0                       10.0                         9 1                 10
1930317 1930317 IN     school 1800016 9325   Options Charter Schools 180001602700 9329 Options Indiana   Regular School Yes High 06 12 2021   grade_8                         5.0 5.0                       10.0                         5 5                 10
1930845 1930845 IN     school 1800124 9925   Phalen Leadership Academy - IN Inc 180012402550 5496 Phalen Leadership Academy - IN Inc   Regular School Yes Elementary KG 08 2021   grade_8                         6.0 4.0                       10.0                         6 4                 10
1930887 1930887 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes Elementary KG 08 2021   grade_8                         6.0 4.0                       10.0                         6 4                 10
1168836 1168836 IN     school 1810290 7205   South Bend Community Sch Corp 181029001681 7537 Edison Intermediate Center   Regular School No 2.0 05 08 2015   grade_8                         60.0 40.0                       100.0                         60 40                 100
1168960 1168960 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_8                         49.0 51.0                       100.0                         49 51                 100
1169238 1169238 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_8                         56.0 44.0                       100.0                         56 44                 100
1295668 1295668 IN     school 1803030 2815   Eastbrook Community Sch Corp 180303002273 2299 Eastbrook Junior High School   Regular School No Middle 07 08 2017   grade_8                         48.0 52.0                       100.0                         48 52                 100
1299026 1299026 IN     school 1803300 5280   Elwood Community School Corp 180330000449 5149 Elwood Jr-Sr High School   Regular School No High 07 12 2017   grade_8                         53.0 47.0                       100.0                         53 47                 100
1304321 1304321 IN     school 1800028 9400   KIPP Indy College Prep Middle 180002802136 5860 KIPP Indy College Prep Middle   Regular School Yes Middle 06 08 2017   grade_8                         53.0 47.0                       100.0                         53 47                 100
1796129 1796129 IN     school 1801770 6825   Randolph Central School Corp 180177000235 7129 Lee L Driver Middle School   Regular School No Middle 06 08 2018   grade_8                         51.0 49.0                       100.0                         51 49                 100
1796526 1796526 IN     school 1810290 7205   South Bend Community School Corp 181029001645 7510 Jackson Middle School   Regular School No Middle 05 08 2018   grade_8                         62.0 38.0                       100.0                         62 38                 100
1906989 1906989 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2020   grade_8                         49.0 51.0                       100.0                         49 51                 100
1908597 1908597 IN     school 1803060 1805   DeKalb Co Eastern Com Sch Dist 180306000405 1317 Eastside Junior-Senior High School   Regular School No High 07 12 2020   grade_8                         45.0 55.0                       100.0                         45 55                 100
1911561 1911561 IN     school 1807830 4315   North Knox School Corp 180783001334 3537 North Knox Jr-Sr High School   Regular School No High 07 12 2020   grade_8                         52.0 48.0                       100.0                         52 48                 100
1914997 1914997 IN     school 1808640 6155   Paoli Community School Corp 180864001438 6581 Paoli Jr & Sr High School   Regular School No High 07 12 2020   grade_8                         56.0 44.0                       100.0                         56 44                 100
1916690 1916690 IN     school 1810860 7715   Southwest School Corporation 181086002359 7961 Sullivan Middle School   Regular School No Middle 06 08 2020   grade_8                         52.0 48.0                       100.0                         52 48                 100
1918138 1918138 IN     school 1800127 8825   CSUSA Donnan 180012700823 5572 Emma Donnan Middle School   Regular School No Middle 07 08 2020   grade_8                         59.0 41.0                       100.0                         59 41                 100
1922700 1922700 IN     school 1808280 3435   Shenandoah School Corporation 180828001421 2819 Shenandoah Middle School   Regular School No Middle 06 08 2021   grade_8                         48.0 52.0                       100.0                         48 52                 100
1926736 1926736 IN     school 1807920 5945   North Newton School Corp 180792001363 6411 North Newton Jr-Sr High School   Regular School No High 07 12 2021   grade_8                         38.0 62.0                       100.0                         38 62                 100
1927471 1927471 IN     school 1807110 6620   Eastern Pulaski Community Sch Corp 180711001206 6996 Winamac Community Middle School   Regular School No Middle 06 08 2021   grade_8                         53.0 47.0                       100.0                         53 47                 100
1929512 1929512 IN     school 1806080 8115   MSD Warren County 180608001073 8737 Seeger Memorial Jr-Sr High School   Regular School No High 07 12 2021   grade_8                         49.0 51.0                       100.0                         49 51                 100
1281399 1281399 IN     school 1802850 255   East Allen County Schools 180285000361 285 Woodlan Jr/Sr High School   Regular School No 3.0 07 12 2016   grade_8                         56.0 45.0                       101.0                         56 45                 101
1282824 1282824 IN     school 1810640 2100   Southeast Dubois Co Sch Corp 181064001745 1583 Forest Park Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_8                         44.0 57.0                       101.0                         44 57                 101
1285483 1285483 IN     school 1810410 4325   South Knox School Corp 181041001706 3490 South Knox Middle-High School   Regular School No 3.0 07 12 2016   grade_8                         42.0 59.0                       101.0                         42 59                 101
1289654 1289654 IN     school 1810500 6705   South Putnam Community Schools 181050002542 7056 South Putnam Middle School   Regular School No 2.0 06 08 2016   grade_8                         55.0 46.0                       101.0                         55 46                 101
1301677 1301677 IN     school 1810500 6705   South Putnam Community Schools 181050002542 7056 South Putnam Middle School   Regular School No Middle 06 08 2017   grade_8                         56.0 45.0                       101.0                         56 45                 101
1302189 1302189 IN     school 1810290 7205   South Bend Community School Corp 181029001650 7425 Clay Intermediate Center   Regular School No Middle 05 08 2017   grade_8                         50.0 51.0                       101.0                         50 51                 101
1303774 1303774 IN     school 1803000 8215   East Washington School Corp 180300000073 8906 East Washington Middle School   Regular School No Middle 05 08 2017   grade_8                         50.0 51.0                       101.0                         50 51                 101
1752056 1752056 IN     school 1802850 255   East Allen County Schools 180285000344 81 Heritage Jr/Sr High School   Regular School No High 07 12 2019   grade_8                         48.0 53.0                       101.0                         48 53                 101
1760870 1760870 IN     school 1811910 7215   Union-North United School Corp 181191001879 7399 LaVille Jr-Sr High School   Regular School No High 07 12 2019   grade_8                         59.0 42.0                       101.0                         59 42                 101
1798182 1798182 IN     school 1808190 8375   Northeastern Wayne Schools 180819002567 8929 Northeastern Middle School   Regular School No Middle 06 08 2018   grade_8                         52.0 49.0                       101.0                         52 49                 101
1798449 1798449 IN     school 1800126 8810   CSUSA Howe 180012601445 5639 Thomas Carr Howe Comm High School   Regular School No High 07 12 2018   grade_8                         57.0 44.0                       101.0                         57 44                 101
1912769 1912769 IN     school 1807860 5075   North Lawrence Com Schools 180786000446 4878 Oolitic Middle School   Regular School No Middle 06 08 2020   grade_8                         61.0 40.0                       101.0                         61 40                 101
1929157 1929157 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000488 8369 Washington Middle School   Regular School No Middle 06 08 2021   grade_8                         51.0 50.0                       101.0                         51 50                 101
1163304 1163304 IN     school 1801060 3455   C A Beard Memorial School Corp 180106002012 2870 Knightstown Intermediate School   Regular School No 2.0 04 08 2015   grade_8                         54.0 48.0                       102.0                         54 48                 102
1169633 1169633 IN     school 1811610 7950   Union Co/Clg Corner Joint Sch Dist 181161001868 8206 Union County Middle School   Regular School No 2.0 06 08 2015   grade_8                         54.0 48.0                       102.0                         54 48                 102
1295674 1295674 IN     school 1806240 2825   Madison-Grant United School Corp 180624001097 2321 Madison-Grant Jr./Sr. High School   Regular School No High 07 12 2017   grade_8                         55.0 47.0                       102.0                         55 47                 102
1300943 1300943 IN     school 1807920 5945   North Newton School Corp 180792001363 6411 North Newton Jr-Sr High School   Regular School No High 07 12 2017   grade_8                         50.0 52.0                       102.0                         50 52                 102
1756332 1756332 IN     school 1809300 4515   Prairie Heights Community Sch Corp 180930001525 3688 Prairie Heights Middle School   Regular School No Middle 05 08 2019   grade_8                         65.0 37.0                       102.0                         65 37                 102
1796923 1796923 IN     school 1810560 7445   South Spencer County Sch Corp 181056001734 7797 South Spencer Middle School   Regular School No Middle 06 08 2018   grade_8                         43.0 59.0                       102.0                         43 59                 102
1907496 1907496 IN     school 1802850 255   East Allen County Schools 180285000344 81 Heritage Jr/Sr High School   Regular School No High 07 12 2020   grade_8                         59.0 43.0                       102.0                         59 43                 102
1916709 1916709 IN     school 1811220 7775   Switzerland County School Corp 181122000806 7987 Switzerland Co Middle School   Regular School No Middle 07 08 2020   grade_8                         57.0 45.0                       102.0                         57 45                 102
1928237 1928237 IN     school 1809990 7230   Scott County School District 1 180999001606 7631 Austin Middle School   Regular School No Middle 06 08 2021   grade_8                         46.0 56.0                       102.0                         46 56                 102
1161085 1161085 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_8                         50.0 53.0                       103.0                         50 53                 103
1170448 1170448 IN     school 1808190 8375   Northeastern Wayne Schools 180819002567 8929 Northeastern Middle School   Regular School No 2.0 06 08 2015   grade_8                         54.0 49.0                       103.0                         54 49                 103
1284734 1284734 IN     school 1811250 3460   Taylor Community School Corp 181125001263 2896 Taylor Middle School   Regular School No 2.0 06 08 2016   grade_8                         51.0 52.0                       103.0                         51 52                 103
1292916 1292916 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2017   grade_8                         48.0 55.0                       103.0                         48 55                 103
1302311 1302311 IN     school 1810290 7205   South Bend Community School Corp 181029001666 7581 Marshall Intermediate Center   Regular School No Middle 05 08 2017   grade_8                         51.0 52.0                       103.0                         51 52                 103
1753464 1753464 IN     school 1810640 2100   Southeast Dubois Co Sch Corp 181064001745 1583 Forest Park Jr-Sr High School   Regular School No High 07 12 2019   grade_8                         54.0 49.0                       103.0                         54 49                 103
1761282 1761282 IN     school 1810860 7715   Southwest School Corporation 181086002359 7961 Sullivan Middle School   Regular School No Middle 06 08 2019   grade_8                         56.0 47.0                       103.0                         56 47                 103
1907024 1907024 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No Middle 06 08 2020   grade_8                         46.0 57.0                       103.0                         46 57                 103
1910347 1910347 IN     school 1803120 3145   Eastern Hancock Co Com Sch Corp 180312000658 2582 Eastern Hancock Middle School   Regular School No Middle 06 08 2020   grade_8                         55.0 48.0                       103.0                         55 48                 103
1915195 1915195 IN     school 1800750 6460   M S D Boone Township 180075002216 6814 Hebron Middle School   Regular School No Middle 06 08 2020   grade_8                         51.0 52.0                       103.0                         51 52                 103
1924784 1924784 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002418 5012 Lapel Middle School   Regular School No Middle 06 08 2021   grade_8                         57.0 46.0                       103.0                         57 46                 103
1928042 1928042 IN     school 1810290 7205   South Bend Community School Corp 181029001650 7425 Clay International Academy   Regular School No Elementary KG 08 2021   grade_8                         51.0 52.0                       103.0                         51 52                 103
1930485 1930485 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes Other KG 12 2021   grade_8                         58.0 45.0                       103.0                         58 45                 103

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