enrollments

Data source: Big Local News · About: Big Local

505 rows where grade = "grade_7", state = "IN" and year = 2021 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 505 ✖

grade ✖

  • grade_7 · 505 ✖
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
1919927 1919927 IN     school 1806030 875   Logansport Community Sch Corp 180603001060 701 Logansport Community High School   Regular School No High 07 12 2021   grade_7                         1.0 0.0                       1.0                         1 0                 1
1920986 1920986 IN     school 1802400 2270   Concord Community Schools 180240002484 1718 Concord Intermediate School   Regular School No Middle 04 08 2021   grade_7                         0.0 1.0                       1.0                         0 1                 1
1922705 1922705 IN     school 1807440 3445   New Castle Community School Corp 180744001290 2825 New Castle High School   Regular School No High 07 12 2021   grade_7                         1.0 0.0                       1.0                         1 0                 1
1922848 1922848 IN     school 1804470 3490   Western School Corporation 180447002224 2923 Western Intermediate School   Regular School No Middle 03 08 2021   grade_7                         7.0 3.0                       10.0                         7 3                 10
1925615 1925615 IN     school 1804770 5385   Indianapolis Public Schools 180477002651 108 Impact Academy   Regular School No Other 03 12 2021   grade_7                         8.0 2.0                       10.0                         8 2                 10
1929411 1929411 IN     school 1812090 8030   Vigo County School Corp 181209002344 8611 Booker T Washington Alt Sch   Alternative School No High 06 12 2021   grade_7                         9.0 1.0                       10.0                         9 1                 10
1930446 1930446 IN     school 1800043 9465   Rural Community Schools Inc 180004302138 7951 Rural Community Academy   Regular School Yes Elementary KG 08 2021   grade_7                         5.0 5.0                       10.0                         5 5                 10
1920378 1920378 IN     school 1807710 1375   North Daviess Com Schools 180771001319 1121 North Daviess Jr-Sr High School   Regular School No High 07 12 2021   grade_7                         58.0 42.0                       100.0                         58 42                 100
1924122 1924122 IN     school 1802910 4680   Lake Station Community Schools 180291000380 3965 Thomas A Edison Jr-Sr HS   Regular School No High 06 12 2021   grade_7                         49.0 51.0                       100.0                         49 51                 100
1929959 1929959 IN     school 1810230 8625   Smith-Green Community Schools 181023001638 9193 Churubusco Jr-Sr High School   Regular School No High 06 12 2021   grade_7                         50.0 51.0                       101.0                         50 51                 101
1930498 1930498 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2021   grade_7                         51.0 51.0                       102.0                         51 51                 102
1924704 1924704 IN     school 1807860 5075   North Lawrence Com Schools 180786001344 4885 Oolitic School   Regular School No Elementary KG 08 2021   grade_7                         67.0 37.0                       104.0                         67 37                 104
1926873 1926873 IN     school 1808640 6155   Paoli Community School Corp 180864001438 6581 Paoli Jr & Sr High School   Regular School No High 07 12 2021   grade_7                         56.0 48.0                       104.0                         56 48                 104
1922790 1922790 IN     school 1811250 3460   Taylor Community School Corp 181125001263 2896 Taylor Middle School   Regular School No Middle 05 08 2021   grade_7                         56.0 49.0                       105.0                         56 49                 105
1923756 1923756 IN     school 1809300 4515   Prairie Heights Community Sch Corp 180930001525 3688 Prairie Heights Middle School   Regular School No Middle 05 08 2021   grade_7                         62.0 43.0                       105.0                         62 43                 105
1919875 1919875 IN     school 1802700 755   Delphi Community School Corp 180270000327 609 Delphi Community Middle School   Regular School No Middle 06 08 2021   grade_7                         53.0 53.0                       106.0                         53 53                 106
1919913 1919913 IN     school 1810680 815   Lewis Cass Schools 181068002625 691 Lewis Cass Junior High School   Regular School No Middle 06 08 2021   grade_7                         57.0 49.0                       106.0                         57 49                 106
1920568 1920568 IN     school 1803060 1805   DeKalb Co Eastern Com Sch Dist 180306000405 1317 Eastside Junior-Senior High School   Regular School No High 07 12 2021   grade_7                         63.0 43.0                       106.0                         63 43                 106
1923124 1923124 IN     school 1809420 3815   Rensselaer Central School Corp 180942001544 3221 Rensselaer Middle School   Regular School No Middle 05 08 2021   grade_7                         59.0 47.0                       106.0                         59 47                 106
1918954 1918954 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2021   grade_7                         64.0 43.0                       107.0                         64 43                 107
1923539 1923539 IN     school 1810410 4325   South Knox School Corp 181041001706 3490 South Knox Middle-High School   Regular School No High 07 12 2021   grade_7                         51.0 56.0                       107.0                         51 56                 107
1924752 1924752 IN     school 1806900 5085   Mitchell Community Schools 180690002151 4924 Mitchell Jr High School   Regular School No Middle 06 08 2021   grade_7                         55.0 53.0                       108.0                         55 53                 108
1927435 1927435 IN     school 1807950 6600   MSD North Posey Co Schools 180795001365 6973 North Posey Junior High School   Regular School No Middle 07 08 2021   grade_7                         57.0 51.0                       108.0                         57 51                 108
1927656 1927656 IN     school 1801770 6825   Randolph Central School Corp 180177000235 7129 Lee L Driver Middle School   Regular School No Middle 06 08 2021   grade_7                         51.0 57.0                       108.0                         51 57                 108
1929156 1929156 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000488 8369 Washington Middle School   Regular School No Middle 06 08 2021   grade_7                         56.0 52.0                       108.0                         56 52                 108
1923519 1923519 IN     school 1807830 4315   North Knox School Corp 180783001334 3537 North Knox Jr-Sr High School   Regular School No High 07 12 2021   grade_7                         54.0 56.0                       110.0                         54 56                 110
1924783 1924783 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002418 5012 Lapel Middle School   Regular School No Middle 06 08 2021   grade_7                         60.0 50.0                       110.0                         60 50                 110
1929660 1929660 IN     school 1803000 8215   East Washington School Corp 180300000073 8906 East Washington Middle School   Regular School No Middle 05 08 2021   grade_7                         52.0 58.0                       110.0                         52 58                 110
1929745 1929745 IN     school 1808190 8375   Northeastern Wayne Schools 180819002567 8929 Northeastern Middle School   Regular School No Middle 06 08 2021   grade_7                         54.0 56.0                       110.0                         54 56                 110
1927535 1927535 IN     school 1807980 6715   North Putnam Community Schools 180798000316 7049 North Putnam Middle School   Regular School No Middle 06 08 2021   grade_7                         64.0 47.0                       111.0                         64 47                 111
1928875 1928875 IN     school 1811400 7945   Tipton Community School Corp 181140001842 8167 Tipton Middle School   Regular School No Middle 06 08 2021   grade_7                         64.0 47.0                       111.0                         64 47                 111
1926531 1926531 IN     school 1810450 5845   South Montgomery Com Sch Corp 181045002325 6261 Southmont Jr High School   Regular School No Middle 06 08 2021   grade_7                         59.0 53.0                       112.0                         59 53                 112
1928236 1928236 IN     school 1809990 7230   Scott County School District 1 180999001606 7631 Austin Middle School   Regular School No Middle 06 08 2021   grade_7                         55.0 58.0                       113.0                         55 58                 113
1922699 1922699 IN     school 1808280 3435   Shenandoah School Corporation 180828001421 2819 Shenandoah Middle School   Regular School No Middle 06 08 2021   grade_7                         63.0 51.0                       114.0                         63 51                 114
1922825 1922825 IN     school 1803150 3480   Eastern Howard School Corporation 180315002589 2914 Eastern Middle School   Regular School No Middle 06 08 2021   grade_7                         65.0 50.0                       115.0                         65 50                 115
1929511 1929511 IN     school 1806080 8115   MSD Warren County 180608001073 8737 Seeger Memorial Jr-Sr High School   Regular School No High 07 12 2021   grade_7                         64.0 51.0                       115.0                         64 51                 115
1928211 1928211 IN     school 1811910 7215   Union-North United School Corp 181191001879 7399 LaVille Jr-Sr High School   Regular School No High 07 12 2021   grade_7                         55.0 63.0                       118.0                         55 63                 118
1928620 1928620 IN     school 1810860 7715   Southwest School Corporation 181086002359 7961 Sullivan Middle School   Regular School No Middle 06 08 2021   grade_7                         64.0 54.0                       118.0                         64 54                 118
1929210 1929210 IN     school 1810590 8020   South Vermillion Com Sch Corp 181059001740 8434 South Vermillion Middle School   Regular School No Middle 06 08 2021   grade_7                         62.0 56.0                       118.0                         62 56                 118
1929418 1929418 IN     school 1806270 8045   Manchester Community Schools 180627001103 8625 Manchester Jr-Sr High School   Regular School No High 07 12 2021   grade_7                         53.0 65.0                       118.0                         53 65                 118
1923048 1923048 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105000181 3107 Brownstown Central Middle School   Regular School No Middle 06 08 2021   grade_7                         69.0 50.0                       119.0                         69 50                 119
1923230 1923230 IN     school 1810800 4000   Southwestern-Jefferson Co Con 181080002547 3343 Southwestern Middle School   Regular School No Middle 06 08 2021   grade_7                         60.0 60.0                       120.0                         60 60                 120
1929865 1929865 IN     school 1800720 8445   MSD Bluffton-Harrison 180072000147 9093 Bluffton-Harrison Middle School   Regular School No Middle 05 08 2021   grade_7                         70.0 50.0                       120.0                         70 50                 120
1920341 1920341 IN     school 1802440 1300   Crawford County Community Sch Corp 180244000282 1061 Crawford County Middle School   Regular School No Middle 06 08 2021   grade_7                         68.0 53.0                       121.0                         68 53                 121
1924904 1924904 IN     school 1803300 5280   Elwood Community School Corp 180330000449 5149 Elwood Jr-Sr High School   Regular School No High 07 12 2021   grade_7                         67.0 54.0                       121.0                         67 54                 121
1918977 1918977 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 06 08 2021   grade_7                         50.0 72.0                       122.0                         50 72                 122
1919697 1919697 IN     school 1800570 515   Blackford County Schools 180057000102 489 Blackford Jr-Sr High School   Regular School No High 07 12 2021   grade_7                         67.0 55.0                       122.0                         67 55                 122
1926135 1926135 IN     school 1800900 5480   Bremen Public Schools 180090000166 5943 Bremen Elementary/Middle School   Regular School No Elementary KG 08 2021   grade_7                         61.0 62.0                       123.0                         61 62                 123
1930393 1930393 IN     school 1800028 9400   KIPP Indy College Prep Middle 180002802136 5860 KIPP Indy College Prep Middle   Regular School Yes Middle 06 08 2021   grade_7                         61.0 63.0                       124.0                         61 63                 124
1924764 1924764 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002050 5005 Frankton Jr-Sr High School   Regular School No High 07 12 2021   grade_7                         64.0 61.0                       125.0                         64 61                 125
1924830 1924830 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No High 07 12 2021   grade_7                         73.0 52.0                       125.0                         73 52                 125
1929482 1929482 IN     school 1812150 8060   Wabash City Schools 181215002301 8694 Wabash Middle School   Regular School No Middle 05 08 2021   grade_7                         61.0 64.0                       125.0                         61 64                 125
1927221 1927221 IN     school 1811700 6530   Union Township School Corp 181170000793 6843 Union Township Middle School   Regular School No Middle 06 08 2021   grade_7                         74.0 52.0                       126.0                         74 52                 126
1927048 1927048 IN     school 1808900 6445   Pike County School Corp 180890000889 6768 Pike Central Middle School   Regular School No Middle 06 08 2021   grade_7                         63.0 64.0                       127.0                         63 64                 127
1930686 1930686 IN     school 1800123 9735   Inspire Academy - A Sch of Inquiry 180012302560 1518 Inspire Academy - A Sch of Inquiry   Regular School Yes Elementary KG 08 2021   grade_7                         6.0 7.0                       13.0                         6 7                 13
1930833 1930833 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other KG 12 2021   grade_7                         11.0 2.0                       13.0                         11 2                 13
1928638 1928638 IN     school 1811220 7775   Switzerland County School Corp 181122000806 7987 Switzerland Co Middle School   Regular School No Middle 07 08 2021   grade_7                         68.0 62.0                       130.0                         68 62                 130
1930124 1930124 IN     school 1800188 9045   James & Rosemary Phalen Leadership 180018802618 4894 James & Rosemary Phalen Leadership   Regular School Yes Middle 07 08 2021   grade_7                         64.0 67.0                       131.0                         64 67                 131
1923504 1923504 IN     school 1807620 4255   Nineveh-Hensley-Jackson United 180762001302 3418 Indian Creek Middle School   Regular School No Middle 06 08 2021   grade_7                         66.0 66.0                       132.0                         66 66                 132
1922897 1922897 IN     school 1805370 3500   Kokomo School Corporation 180537001018 2963 Maple Crest Middle School   Regular School No Middle 06 08 2021   grade_7                         76.0 57.0                       133.0                         76 57                 133
1929250 1929250 IN     school 1812090 8030   Vigo County School Corp 181209001915 8481 Sarah Scott Middle School   Regular School No Middle 06 08 2021   grade_7                         71.0 62.0                       133.0                         71 62                 133
1930898 1930898 IN     school 1800164 9965   Career Academy Middle School 180016402593 7563 Career Academy Middle School   Regular School Yes Middle 06 08 2021   grade_7                         85.0 48.0                       133.0                         85 48                 133
1929635 1929635 IN     school 1809810 8205   Salem Community Schools 180981001601 8861 Salem Middle School   Regular School No Middle 06 08 2021   grade_7                         66.0 68.0                       134.0                         66 68                 134
1922646 1922646 IN     school 1806660 3335   Mill Creek Community Sch Corp 180666001170 2687 Cascade Middle School   Regular School No Middle 06 08 2021   grade_7                         81.0 54.0                       135.0                         81 54                 135
1929717 1929717 IN     school 1801560 8360   Centerville-Abington Com Schs 180156000216 8982 Centerville-Abington Jr High Sch   Regular School No Middle 07 08 2021   grade_7                         71.0 64.0                       135.0                         71 64                 135
1928326 1928326 IN     school 1808310 7350   Northwestern Con School Corp 180831001425 7697 Triton Central Middle School   Regular School No Middle 05 08 2021   grade_7                         72.0 65.0                       137.0                         72 65                 137
1921521 1921521 IN     school 1809630 2645   Rochester Community School Corp 180963001577 2177 Rochester Community Middle School   Regular School No Middle 06 08 2021   grade_7                         81.0 58.0                       139.0                         81 58                 139
1924848 1924848 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Secondary 07 10 2021   grade_7                         11.0 3.0                       14.0                         11 3                 14
1929815 1929815 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other 01 12 2021   grade_7                         11.0 3.0                       14.0                         11 3                 14
1930844 1930844 IN     school 1800124 9925   Phalen Leadership Academy - IN Inc 180012402550 5496 Phalen Leadership Academy - IN Inc   Regular School Yes Elementary KG 08 2021   grade_7                         6.0 8.0                       14.0                         6 8                 14
1930886 1930886 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes Elementary KG 08 2021   grade_7                         8.0 6.0                       14.0                         8 6                 14
1919674 1919674 IN     school 1800480 395   Benton Community School Corp 180048000097 445 Benton Central Jr-Sr High School   Regular School No High 07 12 2021   grade_7                         73.0 67.0                       140.0                         73 67                 140
1922406 1922406 IN     school 1808100 3295   North West Hendricks Schools 180810001670 2682 Tri-West Middle School   Regular School No Middle 06 08 2021   grade_7                         67.0 73.0                       140.0                         67 73                 140
1924188 1924188 IN     school 1803870 4690   Gary Community School Corp 180387002664 4178 Gary Middle School   Regular School No Middle 06 08 2021   grade_7                         85.0 56.0                       141.0                         85 56                 141
1926493 1926493 IN     school 1807900 5835   North Montgomery Com Sch Corp 180790002293 6244 North Montgomery Middle School   Regular School No Middle 06 08 2021   grade_7                         72.0 69.0                       141.0                         72 69                 141
1926564 1926564 IN     school 1804140 5900   Monroe-Gregg School District 180414002129 6315 Monrovia Middle School   Regular School No Middle 06 08 2021   grade_7                         63.0 78.0                       141.0                         63 78                 141
1920879 1920879 IN     school 1810870 2110   Southwest Dubois Co Sch Corp 181087001777 1587 Southridge Middle School   Regular School No Middle 06 08 2021   grade_7                         67.0 75.0                       142.0                         67 75                 142
1924015 1924015 IN     school 1805460 4650   Lake Ridge New Tech Schools 180546000992 3893 Lake Ridge New Tech Middle School   Regular School No Middle 05 08 2021   grade_7                         74.0 68.0                       142.0                         74 68                 142
1923856 1923856 IN     school 1804620 4590   River Forest Community Sch Corp 180462000780 3801 River Forest Middle School   Regular School No Middle 06 08 2021   grade_7                         75.0 68.0                       143.0                         75 68                 143
1921662 1921662 IN     school 1803030 2815   Eastbrook Community Sch Corp 180303002273 2299 Eastbrook Junior High School   Regular School No Middle 07 08 2021   grade_7                         72.0 72.0                       144.0                         72 72                 144
1926263 1926263 IN     school 1808340 5625   Oak Hill United School Corp 180834001430 2305 Oak Hill Junior High School   Regular School No Middle 07 08 2021   grade_7                         71.0 73.0                       144.0                         71 73                 144
1919853 1919853 IN     school 1800960 670   Brown County School Corporation 180096002190 587 Brown County Junior High   Regular School No Middle 07 08 2021   grade_7                         69.0 76.0                       145.0                         69 76                 145
1923721 1923721 IN     school 1811370 4445   Tippecanoe Valley School Corp 181137000397 3619 Tippecanoe Valley Middle School   Regular School No Middle 06 08 2021   grade_7                         72.0 74.0                       146.0                         72 74                 146
1928069 1928069 IN     school 1810290 7205   South Bend Community School Corp 181029001709 7512 LaSalle Academy   Regular School No Middle 06 08 2021   grade_7                         68.0 78.0                       146.0                         68 78                 146
1929242 1929242 IN     school 1812090 8030   Vigo County School Corp 181209001924 8461 West Vigo Middle School   Regular School No Middle 06 08 2021   grade_7                         70.0 76.0                       146.0                         70 76                 146
1928497 1928497 IN     school 1805340 7525   Knox Community School Corp 180534000939 7837 Knox Community Middle School   Regular School No Middle 05 08 2021   grade_7                         72.0 75.0                       147.0                         72 75                 147
1928808 1928808 IN     school 1811340 7865   Tippecanoe School Corp 181134001828 8041 Klondike Middle School   Regular School No Middle 06 08 2021   grade_7                         81.0 67.0                       148.0                         81 67                 148
1920553 1920553 IN     school 1804080 1730   Greensburg Community Schools 180408000705 1269 Greensburg Community Jr High   Regular School No Middle 06 08 2021   grade_7                         74.0 75.0                       149.0                         74 75                 149
1926049 1926049 IN     school 1810920 5400   School Town of Speedway 181092001784 5889 Speedway Junior High School   Regular School No Middle 07 08 2021   grade_7                         73.0 76.0                       149.0                         73 76                 149
1926993 1926993 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elementary & High School   Regular School No Other PK 12 2021   grade_7                         7.0 8.0                       15.0                         7 8                 15
1922814 1922814 IN     school 1802040 3470   Northwestern School Corp 180204002334 2907 Northwestern Middle School   Regular School No Middle 07 08 2021   grade_7                         84.0 67.0                       151.0                         84 67                 151
1929761 1929761 IN     school 1809510 8385   Richmond Community Schools 180951001555 9001 Dennis Intermediate School   Regular School No Middle 05 08 2021   grade_7                         77.0 74.0                       151.0                         77 74                 151
1920602 1920602 IN     school 1803840 1820   Garrett-Keyser-Butler Com Sch Corp 180384001389 1331 Garrett Middle School   Regular School No Middle 06 08 2021   grade_7                         75.0 77.0                       152.0                         75 77                 152
1920962 1920962 IN     school 1800420 2260   Baugo Community Schools 180042000091 1703 Jimtown Junior High School   Regular School No Middle 07 08 2021   grade_7                         86.0 66.0                       152.0                         86 66                 152
1919498 1919498 IN     school 1802850 255   East Allen County Schools 180285000353 297 New Haven Jr/Sr High School   Regular School No High 07 12 2021   grade_7                         76.0 77.0                       153.0                         76 77                 153
1923802 1923802 IN     school 1805520 4535   Lakeland School Corporation 180552000996 3730 Lakeland Jr/Sr High School   Regular School No High 07 12 2021   grade_7                         71.0 84.0                       155.0                         71 84                 155
1928095 1928095 IN     school 1810290 7205   South Bend Community School Corp 181029001681 7537 Edison Middle School   Regular School No Middle 06 08 2021   grade_7                         74.0 81.0                       155.0                         74 81                 155
1927567 1927567 IN     school 1803990 6755   Greencastle Community School Corp 180399000689 7093 Greencastle Middle School   Regular School No Middle 06 08 2021   grade_7                         80.0 76.0                       156.0                         80 76                 156
1928819 1928819 IN     school 1811340 7865   Tippecanoe School Corp 181134001832 8045 Southwestern Middle School   Regular School No Middle 06 08 2021   grade_7                         79.0 77.0                       156.0                         79 77                 156
1919188 1919188 IN     school 1803630 235   Fort Wayne Community Schools 180363000555 133 Portage Middle School   Regular School No Middle 06 08 2021   grade_7                         90.0 67.0                       157.0                         90 67                 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]);