enrollments

Data source: Big Local News · About: Big Local

4,822 rows where grade = "grade_6" and state = "IN" sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_6 · 4,822 ✖
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
1164393 1164393 IN     school 1804620 4590   River Forest Community Sch Corp 180462000781 3791 River Forest Jr-Sr High School   Regular School No 4.0 06 12 2015   grade_6                         1.0 0.0                       1.0                         1 0                 1
1164414 1164414 IN     school 1804620 4590   River Forest Community Sch Corp 180462000779 3805 John I Meister Elementary School   Regular School No 1.0 KG 06 2015   grade_6                         1.0 0.0                       1.0                         1 0                 1
1167061 1167061 IN     school 1808850 5635   Peru Community Schools 180885001477 6089 Peru Junior High School   Regular School No 2.0 04 09 2015   grade_6                         1.0 0.0                       1.0                         1 0                 1
1281028 1281028 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative Education School No 4.0 01 10 2016   grade_6                         1.0 0.0                       1.0                         1 0                 1
1282091 1282091 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative Education School No 4.0 06 12 2016   grade_6                         1.0 0.0                       1.0                         1 0                 1
1282613 1282613 IN     school 1802660 1875   Delaware Community School Corp 180266000318 1520 Albany Elementary School   Regular School No 1.0 KG 06 2016   grade_6                         1.0 0.0                       1.0                         1 0                 1
1285173 1285173 IN     school 1806120 3995   Madison Consolidated Schools 180612001088 3333 Emery O Muncie Elem School   Regular School No 1.0 PK 06 2016   grade_6                         0.0 1.0                       1.0                         0 1                 1
1285719 1285719 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No 1.0 KG 06 2016   grade_6                         1.0 0.0                       1.0                         1 0                 1
1286415 1286415 IN     school 1804560 4720   School Town of Highland 180456000767 4290 Mildred Merkley Elem School   Regular School No 1.0 KG 06 2016   grade_6                         0.0 1.0                       1.0                         0 1                 1
1286449 1286449 IN     school 1804590 4730   School City of Hobart 180459000775 4317 Liberty Elementary School   Regular School No 1.0 01 06 2016   grade_6                         0.0 1.0                       1.0                         0 1                 1
1286462 1286462 IN     school 1804590 4730   School City of Hobart 180459000214 4327 Joan Martin Elementary School   Regular School No 1.0 KG 06 2016   grade_6                         1.0 0.0                       1.0                         1 0                 1
1288458 1288458 IN     school 1808850 5635   Peru Community Schools 180885001477 6089 Peru Junior High School   Regular School No 2.0 04 09 2016   grade_6                         1.0 0.0                       1.0                         1 0                 1
1289723 1289723 IN     school 1803990 6755   Greencastle Community Sch Corp 180399000693 7102 Tzouanakis Intermediate School   Regular School No 1.0 01 06 2016   grade_6                         1.0 0.0                       1.0                         1 0                 1
1293090 1293090 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Other 05 11 2017   grade_6                         0.0 1.0                       1.0                         0 1                 1
1294150 1294150 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No Other 06 12 2017   grade_6                         1.0 0.0                       1.0                         1 0                 1
1295052 1295052 IN     school 1812240 2285   Wa-Nee Community Schools 181224000028 1735 Wakarusa Elementary School   Regular School No Elementary KG 06 2017   grade_6                         0.0 1.0                       1.0                         0 1                 1
1295137 1295137 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2017   grade_6                         1.0 0.0                       1.0                         1 0                 1
1295281 1295281 IN     school 1803930 2315   Goshen Community Schools 180393002180 1847 Prairie View Elementary School   Regular School No Elementary PK 06 2017   grade_6                         1.0 0.0                       1.0                         1 0                 1
1298488 1298488 IN     school 1804590 4730   School City of Hobart 180459000775 4317 Liberty Elementary School   Regular School No Elementary 01 06 2017   grade_6                         1.0 0.0                       1.0                         1 0                 1
1298495 1298495 IN     school 1804590 4730   School City of Hobart 180459000777 4325 Ridge View Elementary School   Regular School No Elementary 01 06 2017   grade_6                         1.0 0.0                       1.0                         1 0                 1
1298502 1298502 IN     school 1804590 4730   School City of Hobart 180459000214 4327 Joan Martin Elementary School   Regular School No Elementary 01 06 2017   grade_6                         0.0 1.0                       1.0                         0 1                 1
1299164 1299164 IN     school 1805670 5330   M S D Lawrence Township 180567001023 5277 Belzer Middle School   Regular School No Middle 06 08 2017   grade_6                         1.0 0.0                       1.0                         1 0                 1
1300456 1300456 IN     school 1808340 5625   Oak Hill United School Corp 180834001430 2305 Oak Hill Junior High School   Regular School No Middle 06 08 2017   grade_6                         0.0 1.0                       1.0                         0 1                 1
1301747 1301747 IN     school 1803990 6755   Greencastle Community School Corp 180399000693 7102 Tzouanakis Intermediate School   Regular School No Elementary 02 06 2017   grade_6                         1.0 0.0                       1.0                         1 0                 1
1303581 1303581 IN     school 1812180 8050   M S D Wabash County Schools 181218001951 8673 White's Jr-Sr High School   Regular School No Other 06 12 2017   grade_6                         1.0 0.0                       1.0                         1 0                 1
1752528 1752528 IN     school 1806030 875   Logansport Community Sch Corp 180603001058 702 Logansport Junior High School   Regular School No Middle 06 08 2019   grade_6                         1.0 0.0                       1.0                         1 0                 1
1752544 1752544 IN     school 1806030 875   Logansport Community Sch Corp 180603001055 709 Fairview Elementary School   Regular School No Elementary PK 06 2019   grade_6                         0.0 1.0                       1.0                         0 1                 1
1759314 1759314 IN     school 1806510 5925   M S D Martinsville Schools 180651002600 6332 John R. Wooden Middle School   Regular School No Middle 06 08 2019   grade_6                         1.0 0.0                       1.0                         1 0                 1
1760615 1760615 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Oaklawn Campus Program   Special Education School No Other 04 12 2019   grade_6                         1.0 0.0                       1.0                         1 0                 1
1762569 1762569 IN     school 1811430 8535   Tri-County School Corporation 181143001846 9141 Tri-County Jr/Sr High School   Regular School No High 06 12 2019   grade_6                         0.0 1.0                       1.0                         0 1                 1
1763412 1763412 IN     school 1800160 9915   Marion Academy 180016002588 5903 Marion Academy   Regular School Yes High 06 12 2019   grade_6                         1.0 0.0                       1.0                         1 0                 1
1788500 1788500 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No High 05 12 2018   grade_6                         1.0 0.0                       1.0                         1 0                 1
1789395 1789395 IN     school 1812240 2285   Wa-Nee Community Schools 181224000028 1735 Wakarusa Elementary School   Regular School No Elementary KG 06 2018   grade_6                         1.0 0.0                       1.0                         1 0                 1
1789624 1789624 IN     school 1803930 2315   Goshen Community Schools 180393002180 1847 Prairie View Elementary School   Regular School No Elementary PK 06 2018   grade_6                         1.0 0.0                       1.0                         1 0                 1
1790303 1790303 IN     school 1813080 3030   Westfield-Washington Schools 181308002074 2491 Westfield Middle School   Regular School No Middle 05 08 2018   grade_6                         1.0 0.0                       1.0                         1 0                 1
1791074 1791074 IN     school 1807440 3445   New Castle Community School Corp 180744001289 2853 Sunnyside Elementary School   Regular School No Elementary KG 06 2018   grade_6                         0.0 1.0                       1.0                         0 1                 1
1791155 1791155 IN     school 1803150 3480   Eastern Howard School Corporation 180315000412 2909 Eastern Elementary School   Regular School No Elementary PK 07 2018   grade_6                         0.0 1.0                       1.0                         0 1                 1
1791183 1791183 IN     school 1804470 3490   Western School Corporation 180447002224 2923 Western Intermediate School   Regular School No Middle 03 08 2018   grade_6                         1.0 0.0                       1.0                         1 0                 1
1792106 1792106 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No High 06 12 2018   grade_6                         1.0 0.0                       1.0                         1 0                 1
1792125 1792125 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No Elementary PK 06 2018   grade_6                         1.0 0.0                       1.0                         1 0                 1
1793533 1793533 IN     school 1805670 5330   M S D Lawrence Township 180567000139 5291 Fall Creek Valley Middle School   Regular School No Middle 06 08 2018   grade_6                         0.0 1.0                       1.0                         0 1                 1
1795156 1795156 IN     school 1806510 5925   M S D Martinsville Schools 180651002355 6344 South Elementary School   Regular School No Elementary PK 06 2018   grade_6                         0.0 1.0                       1.0                         0 1                 1
1796823 1796823 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other 02 12 2018   grade_6                         0.0 1.0                       1.0                         0 1                 1
1796895 1796895 IN     school 1808010 7385   North Spencer County Sch Corp 180801001898 7761 Heritage Hills Middle School   Regular School No Middle 06 09 2018   grade_6                         1.0 0.0                       1.0                         1 0                 1
1797873 1797873 IN     school 1812180 8050   M S D Wabash County Schools 181218001945 8651 Northfield Jr-Sr High School   Regular School No High 06 12 2018   grade_6                         0.0 1.0                       1.0                         0 1                 1
1909316 1909316 IN     school 1803930 2315   Goshen Community Schools 180393002180 1847 Prairie View Elementary School   Regular School No Elementary PK 06 2020   grade_6                         1.0 0.0                       1.0                         1 0                 1
1911155 1911155 IN     school 1809420 3815   Rensselaer Central School Corp 180942001545 3205 Van Rensselaer Elementary School   Regular School No Elementary 01 06 2020   grade_6                         1.0 0.0                       1.0                         1 0                 1
1912192 1912192 IN     school 1803870 4690   Gary Community School Corp 180387002684 4068 Gary Virtual Academy   Regular School No Other 02 09 2020   grade_6                         1.0 0.0                       1.0                         1 0                 1
1912466 1912466 IN     school 1804590 4730   School City of Hobart 180459000214 4327 Joan Martin Elementary School   Regular School No Elementary 01 06 2020   grade_6                         1.0 0.0                       1.0                         1 0                 1
1916025 1916025 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Oaklawn Campus Program   Special Education School No High 06 12 2020   grade_6                         1.0 0.0                       1.0                         1 0                 1
1917323 1917323 IN     school 1812090 8030   Vigo County School Corp 181209002676 8483 Vigo Virtual School Academy   Regular School No High 06 12 2020   grade_6                         1.0 0.0                       1.0                         1 0                 1
1917535 1917535 IN     school 1812180 8050   M S D Wabash County Schools 181218001951 8673 White's Jr-Sr High School   Regular School No High 06 12 2020   grade_6                         0.0 1.0                       1.0                         0 1                 1
1919128 1919128 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 06 11 2021   grade_6                         1.0 0.0                       1.0                         1 0                 1
1919931 1919931 IN     school 1806030 875   Logansport Community Sch Corp 180603001058 702 Logansport Junior High School   Regular School No Middle 06 08 2021   grade_6                         0.0 1.0                       1.0                         0 1                 1
1921081 1921081 IN     school 1812240 2285   Wa-Nee Community Schools 181224001954 1743 Nappanee Elementary School   Regular School No Elementary KG 06 2021   grade_6                         1.0 0.0                       1.0                         1 0                 1
1921959 1921959 IN     school 1813080 3030   Westfield-Washington Schools 181308002074 2491 Westfield Middle School   Regular School No Middle 05 08 2021   grade_6                         1.0 0.0                       1.0                         1 0                 1
1922509 1922509 IN     school 1800270 3315   Avon Community School Corp 180027002450 2730 Avon Middle School North   Regular School No Middle 06 08 2021   grade_6                         1.0 0.0                       1.0                         1 0                 1
1922625 1922625 IN     school 1808970 3330   Plainfield Community School Corp 180897002694 3331 Pride Academy   Regular School No Secondary 05 11 2021   grade_6                         1.0 0.0                       1.0                         1 0                 1
1922847 1922847 IN     school 1804470 3490   Western School Corporation 180447002224 2923 Western Intermediate School   Regular School No Middle 03 08 2021   grade_6                         1.0 0.0                       1.0                         1 0                 1
1923769 1923769 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No High 06 12 2021   grade_6                         0.0 1.0                       1.0                         0 1                 1
1926608 1926608 IN     school 1806510 5925   MSD Martinsville Schools 180651002600 6332 John R. Wooden Middle School   Regular School No Middle 06 08 2021   grade_6                         0.0 1.0                       1.0                         0 1                 1
1926633 1926633 IN     school 1806510 5925   MSD Martinsville Schools 180651002355 6344 South Elementary School of Communi   Regular School No Elementary PK 06 2021   grade_6                         0.0 1.0                       1.0                         0 1                 1
1927212 1927212 IN     school   6530   Union Township School Corp   6811 Porter County Education Services             2021   grade_6                         0.0 1.0                       1.0                         0 1                 1
1929425 1929425 IN     school 1806270 8045   Manchester Community Schools 180627001101 8633 Manchester Elementary School   Regular School No Elementary PK 06 2021   grade_6                         1.0 0.0                       1.0                         1 0                 1
1930089 1930089 IN     school 1800222 9000   Phalen Virtual Leadership Academy 180022202707 9992 Phalen Virtual Leadership Academy   Regular School Yes Other 02 12 2021   grade_6                         1.0 0.0                       1.0                         1 0                 1
1930299 1930299 IN     school 1800016 9325   Options Charter Schools 180001601738 2524 Options Charter School - Carmel   Regular School Yes High 06 12 2021   grade_6                         1.0 0.0                       1.0                         1 0                 1
1166817 1166817 IN     school 1800105 5390   Southside Sp Srvs Of Marion Co 180010502502 5320 RISE Learning Center   Regular School No 4.0 KG 12 2015   grade_6                         8.0 2.0                       10.0                         8 2                 10
1291123 1291123 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345002462 8270 Academy for Innovative Studies   Regular School No 4.0 01 12 2016   grade_6                         10.0 0.0                       10.0                         10 0                 10
1292487 1292487 IN     school 1800162 9630   Carpe Diem - Shadeland 180016202575 5978 Carpe Diem - Shadeland   Regular School Yes 4.0 06 10 2016   grade_6                         6.0 4.0                       10.0                         6 4                 10
1304271 1304271 IN     school 1800015 9360   Veritas Academy 180001501786 1540 Veritas Academy   Regular School Yes Elementary KG 08 2017   grade_6                         6.0 4.0                       10.0                         6 4                 10
1304716 1304716 IN     school 1800074 9795   Dr Robert H Faulkner Academy 180007402426 2411 Dr Robert H Faulkner Academy   Regular School Yes Elementary KG 06 2017   grade_6                         5.0 5.0                       10.0                         5 5                 10
1304871 1304871 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other KG 12 2017   grade_6                         8.0 2.0                       10.0                         8 2                 10
1754977 1754977 IN     school 1810360 3190   South Harrison Com Schools 181036001698 2649 New Middletown Elementary School   Regular School No Elementary KG 06 2019   grade_6                         7.0 3.0                       10.0                         7 3                 10
1797468 1797468 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2018   grade_6                         8.0 2.0                       10.0                         8 2                 10
1910888 1910888 IN     school 1804470 3490   Western School Corporation 180447002224 2923 Western Intermediate School   Regular School No Middle 03 08 2020   grade_6                         7.0 3.0                       10.0                         7 3                 10
1917886 1917886 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other KG 12 2020   grade_6                         10.0 0.0                       10.0                         10 0                 10
1918844 1918844 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other 01 12 2020   grade_6                         9.0 1.0                       10.0                         9 1                 10
1921141 1921141 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2021   grade_6                         8.0 2.0                       10.0                         8 2                 10
1921553 1921553 IN     school 1802940 2725   East Gibson School Corporation 180294000383 2189 Barton Township Elementary   Regular School No Elementary KG 06 2021   grade_6                         5.0 5.0                       10.0                         5 5                 10
1930733 1930733 IN     school 1800072 9805   Hoosier Academy - Indianapolis 180007202422 2527 Hoosier Academy - Indianapolis   Regular School Yes Elementary KG 08 2021   grade_6                         4.0 6.0                       10.0                         4 6                 10
1159462 1159462 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No 2.0 06 08 2015   grade_6                         45.0 55.0                       100.0                         45 55                 100
1166257 1166257 IN     school 1812810 5375   M S D Wayne Township 181281002031 5274 Chapelwood Elementary School   Regular School No 1.0 KG 06 2015   grade_6                         52.0 48.0                       100.0                         52 48                 100
1168252 1168252 IN     school 1810500 6705   South Putnam Community Schools 181050002542 7056 South Putnam Middle School   Regular School No 2.0 06 08 2015   grade_6                         57.0 43.0                       100.0                         57 43                 100
1287052 1287052 IN     school 1802640 5300   M S D Decatur Township 180264000317 5189 West Newton Elementary School   Regular School No 1.0 01 06 2016   grade_6                         50.0 50.0                       100.0                         50 50                 100
1288569 1288569 IN     school 1800630 5740   Monroe County Com Sch Corp 180063000118 6173 Binford Elementary School   Regular School No 1.0 03 06 2016   grade_6                         56.0 44.0                       100.0                         56 44                 100
1299066 1299066 IN     school 1802640 5300   M S D Decatur Township 180264000315 5185 Stephen Decatur Elementary School   Regular School No Elementary 01 06 2017   grade_6                         51.0 49.0                       100.0                         51 49                 100
1299640 1299640 IN     school 1812810 5375   M S D Wayne Township 181281002036 5261 Rhoades Elementary School   Regular School No Elementary PK 06 2017   grade_6                         44.0 56.0                       100.0                         44 56                 100
1302247 1302247 IN     school 1810290 7205   South Bend Community School Corp 181029001681 7537 Edison Intermediate Center   Regular School No Middle 05 08 2017   grade_6                         51.0 49.0                       100.0                         51 49                 100
1757610 1757610 IN     school 1802640 5300   M S D Decatur Township 180264002271 5187 Valley Mills Elementary School   Regular School No Elementary 01 06 2019   grade_6                         52.0 48.0                       100.0                         52 48                 100
1759910 1759910 IN     school 1811700 6530   Union Township School Corp 181170000793 6843 Union Township Middle School   Regular School No Middle 06 08 2019   grade_6                         53.0 47.0                       100.0                         53 47                 100
1763176 1763176 IN     school 1800086 9680   Paramount Brookside 180008602478 5508 Paramount Brookside   Regular School Yes Elementary KG 08 2019   grade_6                         55.0 45.0                       100.0                         55 45                 100
1787311 1787311 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 05 08 2018   grade_6                         49.0 51.0                       100.0                         49 51                 100
1790555 1790555 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071001760 2564 New Palestine Elementary School   Regular School No Elementary PK 06 2018   grade_6                         55.0 45.0                       100.0                         55 45                 100
1791871 1791871 IN     school 1807830 4315   North Knox School Corp 180783001335 3545 North Knox Intermediate   Regular School No Elementary 03 06 2018   grade_6                         52.0 48.0                       100.0                         52 48                 100
1795737 1795737 IN     school 1811700 6530   Union Township School Corp 181170000793 6843 Union Township Middle School   Regular School No Middle 06 08 2018   grade_6                         54.0 46.0                       100.0                         54 46                 100
1796796 1796796 IN     school 1808310 7350   Northwestern Con School Corp 180831001425 7697 Triton Central Middle School   Regular School No Middle 05 08 2018   grade_6                         55.0 45.0                       100.0                         55 45                 100
1907907 1907907 IN     school 1802700 755   Delphi Community School Corp 180270000327 609 Delphi Community Middle School   Regular School No Middle 06 08 2020   grade_6                         49.0 51.0                       100.0                         49 51                 100
1915303 1915303 IN     school 1809180 6520   Porter Township School Corp 180918000523 6839 Boone Grove Middle School   Regular School No Middle 06 08 2020   grade_6                         53.0 47.0                       100.0                         53 47                 100
1918031 1918031 IN     school 1810230 8625   Smith-Green Community Schools 181023001638 9193 Churubusco Jr-Sr High School   Regular School No High 06 12 2020   grade_6                         50.0 50.0                       100.0                         50 50                 100
1924815 1924815 IN     school 1810440 5255   South Madison Com Sch Corp 181044001713 5061 Pendleton Elementary School   Regular School No Elementary PK 06 2021   grade_6                         56.0 44.0                       100.0                         56 44                 100

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