enrollments

Data source: Big Local News · About: Big Local

415 rows where grade = "grade_9", state = "IN" and year = 2020 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 415 ✖

grade ✖

  • grade_9 · 415 ✖
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
1909051 1909051 IN     school 1806600 2275   Middlebury Community Schools 180660001162 1657 Northridge Middle School   Regular School No Middle 06 09 2020   grade_9                         0.0 1.0                       1.0                         0 1                 1
1909268 1909268 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No Middle 06 09 2020   grade_9                         1.0 0.0                       1.0                         1 0                 1
1910625 1910625 IN     school 1802550 3325   Danville Community School Corp 180255000305 2743 Danville Middle School   Regular School No Other 04 09 2020   grade_9                         0.0 1.0                       1.0                         0 1                 1
1915643 1915643 IN     school 1803990 6755   Greencastle Community School Corp 180399000689 7093 Greencastle Middle School   Regular School No Middle 06 10 2020   grade_9                         1.0 0.0                       1.0                         1 0                 1
1916491 1916491 IN     school 1808010 7385   North Spencer County Sch Corp 180801001898 7761 Heritage Hills Middle School   Regular School No Middle 07 09 2020   grade_9                         0.0 1.0                       1.0                         0 1                 1
1918356 1918356 IN     school 1800135 9355   Excel Center - Kokomo 180013502553 2976 Excel Center - Kokomo   Regular School Yes High 09 12 2020   grade_9                         1.0 0.0                       1.0                         1 0                 1
1917483 1917483 IN     school 1812090 8030   Vigo County School Corp 181209000926 8612 McLean Education Center (Alt)   Regular School No High 06 12 2020   grade_9                         8.0 2.0                       10.0                         8 2                 10
1917889 1917889 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other KG 12 2020   grade_9                         8.0 2.0                       10.0                         8 2                 10
1908896 1908896 IN     school 1810640 2100   Southeast Dubois Co Sch Corp 181064001745 1583 Forest Park Jr-Sr High School   Regular School No High 07 12 2020   grade_9                         55.0 46.0                       101.0                         55 46                 101
1911778 1911778 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko Jr/Sr High School   Regular School No High 07 12 2020   grade_9                         46.0 55.0                       101.0                         46 55                 101
1914998 1914998 IN     school 1808640 6155   Paoli Community School Corp 180864001438 6581 Paoli Jr & Sr High School   Regular School No High 07 12 2020   grade_9                         51.0 50.0                       101.0                         51 50                 101
1917585 1917585 IN     school 1806080 8115   M S D Warren County 180608001073 8737 Seeger Memorial Jr-Sr High School   Regular School No High 07 12 2020   grade_9                         38.0 63.0                       101.0                         38 63                 101
1918303 1918303 IN     school 1800021 9315   Signature School Inc 180002100319 8295 Signature School Inc   Regular School Yes High 09 12 2020   grade_9                         41.0 60.0                       101.0                         41 60                 101
1914886 1914886 IN     school 1801710 6055   Central Noble Com School Corp 180171000230 6453 Central Noble Junior Senior HS   Regular School No High 06 12 2020   grade_9                         47.0 55.0                       102.0                         47 55                 102
1918336 1918336 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2020   grade_9                         57.0 45.0                       102.0                         57 45                 102
1916955 1916955 IN     school 1811610 7950   Union Co/Clg Corner Joint Sch Dist 181161001869 8193 Union County High School   Regular School No High 09 12 2020   grade_9                         48.0 55.0                       103.0                         48 55                 103
1911795 1911795 IN     school 1809300 4515   Prairie Heights Community Sch Corp 180930001526 3690 Prairie Heights Sr High School   Regular School No High 09 12 2020   grade_9                         64.0 40.0                       104.0                         64 40                 104
1911562 1911562 IN     school 1807830 4315   North Knox School Corp 180783001334 3537 North Knox Jr-Sr High School   Regular School No High 07 12 2020   grade_9                         46.0 59.0                       105.0                         46 59                 105
1918441 1918441 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2020   grade_9                         58.0 47.0                       105.0                         58 47                 105
1916279 1916279 IN     school 1811910 7215   Union-North United School Corp 181191001879 7399 LaVille Jr-Sr High School   Regular School No High 07 12 2020   grade_9                         58.0 48.0                       106.0                         58 48                 106
1917728 1917728 IN     school 1803000 8215   East Washington School Corp 180300000395 8905 Eastern High School   Regular School No High 09 12 2020   grade_9                         52.0 54.0                       106.0                         52 54                 106
1917935 1917935 IN     school 1800720 8445   M S D Bluffton-Harrison 180072000146 9089 Bluffton High School   Regular School No High 09 12 2020   grade_9                         54.0 52.0                       106.0                         54 52                 106
1918122 1918122 IN     school 1800126 8810   CSUSA Howe 180012601445 5639 Thomas Carr Howe Comm High School   Regular School No High 07 12 2020   grade_9                         66.0 41.0                       107.0                         66 41                 107
1918794 1918794 IN     school 1800101 9880   Career Academy High School 180010102521 7567 Career Academy High School   Regular School Yes High 09 12 2020   grade_9                         53.0 54.0                       107.0                         53 54                 107
1909826 1909826 IN     school 1805910 2950   Linton-Stockton School Corporation 180591001049 2437 Linton-Stockton High School   Regular School No High 09 12 2020   grade_9                         58.0 50.0                       108.0                         58 50                 108
1915128 1915128 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_9                         53.0 55.0                       108.0                         53 55                 108
1916028 1916028 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Oaklawn Campus Program   Special Education School No High 06 12 2020   grade_9                         6.0 5.0                       11.0                         6 5                 11
1918194 1918194 IN     school 1800195 9070   Gary Middle College West 180019502641 1003 Gary Middle College West   Regular School Yes High 09 12 2020   grade_9                         4.0 7.0                       11.0                         4 7                 11
1918231 1918231 IN     school 1800006 9100   Indiana Department of Correction 180000601946 732 Logansport Juvenile Correctional   Regular School No High 08 12 2020   grade_9                         11.0 0.0                       11.0                         11 0                 11
1915614 1915614 IN     school 1807980 6715   North Putnam Community Schools 180798001369 7061 North Putnam Sr High School   Regular School No High 09 12 2020   grade_9                         52.0 58.0                       110.0                         52 58                 110
1915637 1915637 IN     school 1803990 6755   Greencastle Community School Corp 180399000690 7089 Greencastle Senior High School   Regular School No High 09 12 2020   grade_9                         50.0 60.0                       110.0                         50 60                 110
1917806 1917806 IN     school 1808190 8375   Northeastern Wayne Schools 180819001406 8927 Northeastern High School   Regular School No High 09 12 2020   grade_9                         56.0 54.0                       110.0                         56 54                 110
1918505 1918505 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2020   grade_9                         58.0 52.0                       110.0                         58 52                 110
1915301 1915301 IN     school 1809180 6520   Porter Township School Corp 180918001521 6838 Boone Grove High School   Regular School No High 09 12 2020   grade_9                         51.0 60.0                       111.0                         51 60                 111
1918171 1918171 IN     school 1800188 9045   J & R Phalen Leadership Academy 180018802618 4894 J & R Phalen Leadership Academy   Regular School Yes Secondary 07 10 2020   grade_9                         58.0 53.0                       111.0                         58 53                 111
1908363 1908363 IN     school 1802440 1300   Crawford County Community Sch Corp 180244000279 1059 Crawford County High School   Regular School No High 09 12 2020   grade_9                         55.0 58.0                       113.0                         55 58                 113
1908724 1908724 IN     school 1805880 1895   Liberty-Perry Community Sch Corp 180588001047 1375 Wapahani High School   Regular School No High 09 12 2020   grade_9                         64.0 49.0                       113.0                         64 49                 113
1916950 1916950 IN     school 1811400 7945   Tipton Community School Corp 181140001843 8177 Tipton High School   Regular School No High 09 12 2020   grade_9                         53.0 60.0                       113.0                         53 60                 113
1911804 1911804 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No High 06 12 2020   grade_9                         57.0 57.0                       114.0                         57 57                 114
1912845 1912845 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002050 5005 Frankton Jr-Sr High School   Regular School No High 07 12 2020   grade_9                         63.0 51.0                       114.0                         63 51                 114
1910693 1910693 IN     school 1806660 3335   Mill Creek Community Sch Corp 180666001171 2692 Cascade Senior High School   Regular School No High 09 12 2020   grade_9                         58.0 57.0                       115.0                         58 57                 115
1912859 1912859 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002328 5011 Lapel Sr High School   Regular School No High 09 12 2020   grade_9                         52.0 63.0                       115.0                         52 63                 115
1912981 1912981 IN     school 1803300 5280   Elwood Community School Corp 180330000449 5149 Elwood Jr-Sr High School   Regular School No High 07 12 2020   grade_9                         66.0 49.0                       115.0                         66 49                 115
1907944 1907944 IN     school 1810680 815   Lewis Cass Schools 181068001755 689 Lewis Cass High School   Regular School No High 09 12 2020   grade_9                         62.0 54.0                       116.0                         62 54                 116
1915317 1915317 IN     school 1811700 6530   Union Township School Corp 181170001873 6841 Wheeler High School   Regular School No High 09 12 2020   grade_9                         58.0 58.0                       116.0                         58 58                 116
1917550 1917550 IN     school 1812150 8060   Wabash City Schools 181215001940 8693 Wabash High School   Regular School No High 09 12 2020   grade_9                         60.0 56.0                       116.0                         60 56                 116
1910737 1910737 IN     school 1808280 3435   Shenandoah School Corporation 180828001420 2817 Shenandoah High School   Regular School No High 09 12 2020   grade_9                         59.0 59.0                       118.0                         59 59                 118
1914245 1914245 IN     school 1800900 5480   Bremen Public Schools 180090000168 5941 Bremen Senior High School   Regular School No High 09 12 2020   grade_9                         62.0 56.0                       118.0                         62 56                 118
1915727 1915727 IN     school 1801770 6825   Randolph Central School Corp 180177000242 7125 Winchester Community High School   Regular School No High 09 12 2020   grade_9                         56.0 62.0                       118.0                         56 62                 118
1916382 1916382 IN     school 1808310 7350   Northwestern Con School Corp 180831001423 7689 Triton Central High School   Regular School No High 09 12 2020   grade_9                         59.0 59.0                       118.0                         59 59                 118
1911095 1911095 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105000180 3126 Brownstown Central High School   Regular School No High 09 12 2020   grade_9                         67.0 52.0                       119.0                         67 52                 119
1914391 1914391 IN     school 1808340 5625   Oak Hill United School Corp 180834001429 6069 Oak Hill High School   Regular School No High 09 12 2020   grade_9                         62.0 57.0                       119.0                         62 57                 119
1916686 1916686 IN     school 1810860 7715   Southwest School Corporation 181086001773 7957 Sullivan High School   Regular School No High 09 12 2020   grade_9                         64.0 55.0                       119.0                         64 55                 119
1918114 1918114 IN     school 1800205 8690   Dynamic Minds Academy 180020502673 8692 Dynamic Minds Academy   Regular School Yes Other KG 12 2020   grade_9                         10.0 2.0                       12.0                         10 2                 12
1918714 1918714 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes Other 04 12 2020   grade_9                         12.0 0.0                       12.0                         12 0                 12
1910874 1910874 IN     school 1803150 3480   Eastern Howard School Corporation 180315000413 2919 Eastern High School   Regular School No High 09 12 2020   grade_9                         56.0 64.0                       120.0                         56 64                 120
1907732 1907732 IN     school 1800570 515   Blackford County Schools 180057000102 489 Blackford Jr-Sr High School   Regular School No High 07 12 2020   grade_9                         67.0 55.0                       122.0                         67 55                 122
1908598 1908598 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_9                         58.0 65.0                       123.0                         58 65                 123
1907518 1907518 IN     school 1802850 255   East Allen County Schools 180285000361 285 Woodlan Jr/Sr High School   Regular School No High 07 12 2020   grade_9                         64.0 61.0                       125.0                         64 61                 125
1918260 1918260 IN     school 1800206 9135   KIPP Indy Legacy High 180020602669 9138 KIPP Indy Legacy High   Regular School Yes Secondary 09 09 2020   grade_9                         72.0 53.0                       125.0                         72 53                 125
1907914 1907914 IN     school 1802700 755   Delphi Community School Corp 180270000326 637 Delphi Community High School   Regular School No High 09 12 2020   grade_9                         63.0 63.0                       126.0                         63 63                 126
1909697 1909697 IN     school 1803030 2815   Eastbrook Community Sch Corp 180303000399 2293 Eastbrook High School   Regular School No High 09 12 2020   grade_9                         63.0 63.0                       126.0                         63 63                 126
1914641 1914641 IN     school 1810450 5845   South Montgomery Com Sch Corp 181045001716 6257 Southmont Sr High School   Regular School No High 09 12 2020   grade_9                         69.0 57.0                       126.0                         69 57                 126
1915166 1915166 IN     school 1808900 6445   Pike County School Corp 180890001482 6763 Pike Central High School   Regular School No High 09 12 2020   grade_9                         64.0 63.0                       127.0                         64 63                 127
1917490 1917490 IN     school 1806270 8045   Manchester Community Schools 180627001103 8625 Manchester Jr-Sr High School   Regular School No High 07 12 2020   grade_9                         67.0 60.0                       127.0                         67 60                 127
1913555 1913555 IN     school 1812810 5375   M S D Wayne Township 181281002122 5219 Ben Davis Ninth Grade Center   Regular School No Secondary 09 09 2020   grade_9                         664.0 606.0                       1270.0                         664 606                 1270
1912838 1912838 IN     school 1806900 5085   Mitchell Community Schools 180690001198 4925 Mitchell High School   Regular School No High 09 12 2020   grade_9                         65.0 64.0                       129.0                         65 64                 129
1908917 1908917 IN     school 1810870 2110   Southwest Dubois Co Sch Corp 181087001779 1588 Southridge High School   Regular School No High 09 12 2020   grade_9                         63.0 67.0                       130.0                         63 67                 130
1911877 1911877 IN     school 1804620 4590   River Forest Community Sch Corp 180462000781 3791 River Forest High School   Regular School No High 09 12 2020   grade_9                         71.0 60.0                       131.0                         71 60                 131
1914691 1914691 IN     school 1804140 5900   Monroe-Gregg School District 180414000716 6321 Monrovia High School   Regular School No High 09 12 2020   grade_9                         65.0 66.0                       131.0                         65 66                 131
1908958 1908958 IN     school 1803480 2155   Fairfield Community Schools 180348000491 1613 Fairfield Jr-Sr High School   Regular School No High 07 12 2020   grade_9                         70.0 62.0                       132.0                         70 62                 132
1917704 1917704 IN     school 1809810 8205   Salem Community Schools 180981001600 8857 Salem High School   Regular School No High 09 12 2020   grade_9                         67.0 65.0                       132.0                         67 65                 132
1912910 1912910 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No High 07 12 2020   grade_9                         67.0 66.0                       133.0                         67 66                 133
1910078 1910078 IN     school 1801200 3060   Carmel Clay Schools 180120000193 2505 Carmel High School   Regular School No High 09 12 2020   grade_9                         678.0 668.0                       1346.0                         678 668                 1346
1914628 1914628 IN     school 1807900 5835   North Montgomery Com Sch Corp 180790001357 6271 North Montgomery High School   Regular School No High 09 12 2020   grade_9                         70.0 65.0                       135.0                         70 65                 135
1912503 1912503 IN     school 1813200 4760   School City of Whiting 181320002082 4353 Whiting High School   Regular School No High 09 12 2020   grade_9                         55.0 81.0                       136.0                         55 81                 136
1917274 1917274 IN     school 1810590 8020   South Vermillion Com Sch Corp 181059001739 8432 South Vermillion High School   Regular School No High 09 12 2020   grade_9                         79.0 57.0                       136.0                         79 57                 136
1918150 1918150 IN     school 1800183 9015   Purdue Polytechnic High School Ind 180018302632 4271 Purdue Polytechnic High School Ind   Regular School Yes Secondary 09 11 2020   grade_9                         89.0 47.0                       136.0                         89 47                 136
1907766 1907766 IN     school 1812990 615   Western Boone Co Com Sch Dist 181299002066 539 Western Boone Jr-Sr High School   Regular School No High 07 12 2020   grade_9                         70.0 69.0                       139.0                         70 69                 139
1907864 1907864 IN     school 1800960 670   Brown County School Corporation 180096000169 573 Brown County High School   Regular School No High 09 12 2020   grade_9                         74.0 67.0                       141.0                         74 67                 141
1917301 1917301 IN     school 1812090 8030   Vigo County School Corp 181209001923 8453 West Vigo High School   Regular School No High 09 12 2020   grade_9                         72.0 69.0                       141.0                         72 69                 141
1914174 1914174 IN     school 1810920 5400   School Town of Speedway 181092001785 5891 Speedway Senior High School   Regular School No High 09 12 2020   grade_9                         75.0 67.0                       142.0                         75 67                 142
1910479 1910479 IN     school 1808100 3295   North West Hendricks Schools 180810001387 2731 Tri-West Senior High School   Regular School No High 09 12 2020   grade_9                         69.0 74.0                       143.0                         69 74                 143
1911836 1911836 IN     school 1805520 4535   Lakeland School Corporation 180552000996 3730 Lakeland Jr/Sr High School   Regular School No High 07 12 2020   grade_9                         76.0 67.0                       143.0                         76 67                 143
1918491 1918491 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes Other KG 12 2020   grade_9                         75.0 68.0                       143.0                         75 68                 143
1918258 1918258 IN     school 1800179 9120   Insight School of Indiana 180017902601 2528 Insight School of Indiana   Regular School Yes High 07 12 2020   grade_9                         86.0 60.0                       146.0                         86 60                 146
1908619 1908619 IN     school 1803840 1820   Garrett-Keyser-Butler Com Sch Corp 180384000605 1325 Garrett High School   Regular School No High 09 12 2020   grade_9                         76.0 71.0                       147.0                         76 71                 147
1909556 1909556 IN     school 1809630 2645   Rochester Community School Corp 180963001576 2173 Rochester Community High School   Regular School No High 09 12 2020   grade_9                         79.0 68.0                       147.0                         79 68                 147
1911149 1911149 IN     school 1809420 3815   Rensselaer Central School Corp 180942001543 3201 Rensselaer Central High School   Regular School No High 09 12 2020   grade_9                         82.0 66.0                       148.0                         82 66                 148
1911551 1911551 IN     school 1807620 4255   Nineveh-Hensley-Jackson United 180762001303 3419 Indian Creek Sr High School   Regular School No High 09 12 2020   grade_9                         81.0 68.0                       149.0                         81 68                 149
1912925 1912925 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Secondary 07 10 2020   grade_9                         10.0 5.0                       15.0                         10 5                 15
1918554 1918554 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_9                         11.0 4.0                       15.0                         11 4                 15
1907709 1907709 IN     school 1800480 395   Benton Community School Corp 180048000097 445 Benton Central Jr-Sr High School   Regular School No High 07 12 2020   grade_9                         58.0 92.0                       150.0                         58 92                 150
1907497 1907497 IN     school 1802850 255   East Allen County Schools 180285000344 81 Heritage Jr/Sr High School   Regular School No High 07 12 2020   grade_9                         84.0 67.0                       151.0                         84 67                 151
1916487 1916487 IN     school 1808010 7385   North Spencer County Sch Corp 180801001376 7759 Heritage Hills High School   Regular School No High 09 12 2020   grade_9                         80.0 72.0                       152.0                         80 72                 152
1911742 1911742 IN     school 1811370 4445   Tippecanoe Valley School Corp 181137001839 3602 Tippecanoe Valley High School   Regular School No High 09 12 2020   grade_9                         77.0 76.0                       153.0                         77 76                 153
1918127 1918127 IN     school 1800112 8815   CSUSA Manual 180011200825 5481 Emmerich Manual High School   Regular School No High 09 12 2020   grade_9                         89.0 66.0                       155.0                         89 66                 155
1910838 1910838 IN     school 1802040 3470   Northwestern School Corp 180204000255 2897 Northwestern Senior High School   Regular School No High 09 12 2020   grade_9                         73.0 84.0                       157.0                         73 84                 157
1915479 1915479 IN     school 1807290 6590   M S D Mount Vernon 180729001226 6949 Mount Vernon High School   Regular School No High 09 12 2020   grade_9                         83.0 74.0                       157.0                         83 74                 157
1916562 1916562 IN     school 1805340 7525   Knox Community School Corp 180534000938 7833 Knox Community High School   Regular School No High 09 12 2020   grade_9                         75.0 82.0                       157.0                         75 82                 157

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