enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 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
1281029 1281029 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_7                         1.0 0.0                       1.0                         1 0                 1
1284648 1284648 IN     school 1807440 3445   New Castle Community Sch Corp 180744001290 2825 New Castle High School   Regular School No 3.0 07 12 2016   grade_7                         1.0 0.0                       1.0                         1 0                 1
1284792 1284792 IN     school 1804470 3490   Western School Corp 180447002224 2923 Western Intermediate School   Regular School No 1.0 02 08 2016   grade_7                         0.0 1.0                       1.0                         0 1                 1
1288970 1288970 IN     school 1802970 6060   East Noble School Corp 180297000389 6458 East Noble High School   Regular School No 3.0 07 12 2016   grade_7                         1.0 0.0                       1.0                         1 0                 1
1290337 1290337 IN     school 1810290 7205   South Bend Community Sch Corp 181029000898 7632 Juvenile Justice Center   Alternative Education School No 3.0 07 12 2016   grade_7                         1.0 0.0                       1.0                         1 0                 1
1291556 1291556 IN     school 1812180 8050   M S D Wabash County Schools 181218002178 8657 Sharp Creek Elementary School   Regular School No 1.0 01 07 2016   grade_7                         0.0 1.0                       1.0                         0 1                 1
1292890 1292890 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes 4.0 KG 12 2016   grade_7                         3.0 7.0                       10.0                         3 7                 10
1290773 1290773 IN     school 1811220 7775   Switzerland County School Corp 181122000806 7987 Switzerland Co Middle School   Regular School No 2.0 07 08 2016   grade_7                         58.0 42.0                       100.0                         58 42                 100
1288914 1288914 IN     school 1807920 5945   North Newton School Corp 180792001363 6411 North Newton Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_7                         52.0 49.0                       101.0                         52 49                 101
1289066 1289066 IN     school 1808640 6155   Paoli Community School Corp 180864001438 6581 Paoli Jr & Sr High School   Regular School No 3.0 07 12 2016   grade_7                         53.0 48.0                       101.0                         53 48                 101
1289653 1289653 IN     school 1810500 6705   South Putnam Community Schools 181050002542 7056 South Putnam Middle School   Regular School No 2.0 06 08 2016   grade_7                         58.0 43.0                       101.0                         58 43                 101
1286990 1286990 IN     school 1803300 5280   Elwood Community School Corp 180330000449 5149 Elwood Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_7                         53.0 49.0                       102.0                         53 49                 102
1287763 1287763 IN     school 1804770 5385   Indianapolis Public Schools 180477002526 5513 George Washington Comm Jr HS   Regular School No 2.0 07 08 2016   grade_7                         58.0 44.0                       102.0                         58 44                 102
1291750 1291750 IN     school 1803000 8215   East Washington School Corp 180300000073 8906 East Washington Middle School   Regular School No 2.0 05 08 2016   grade_7                         51.0 51.0                       102.0                         51 51                 102
1283630 1283630 IN     school 1806240 2825   Madison-Grant United Sch Corp 180624002279 2328 Madison-Grant Jr High School   Regular School No 2.0 07 08 2016   grade_7                         56.0 47.0                       103.0                         56 47                 103
1290221 1290221 IN     school 1810290 7205   South Bend Community Sch Corp 181029001681 7537 Edison Intermediate Center   Regular School No 2.0 05 08 2016   grade_7                         51.0 52.0                       103.0                         51 52                 103
1280853 1280853 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No 2.0 06 08 2016   grade_7                         49.0 56.0                       105.0                         49 56                 105
1289193 1289193 IN     school 1811260 6350   Tell City-Troy Twp School Corp 181126001819 6741 Tell City Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_7                         57.0 48.0                       105.0                         57 48                 105
1290204 1290204 IN     school 1810290 7205   South Bend Community Sch Corp 181029002296 7521 Brown Intermediate Center   Regular School No 2.0 04 08 2016   grade_7                         61.0 44.0                       105.0                         61 44                 105
1290283 1290283 IN     school 1810290 7205   South Bend Community Sch Corp 181029001666 7581 Marshall Intermediate Center   Regular School No 2.0 05 08 2016   grade_7                         56.0 49.0                       105.0                         56 49                 105
1291514 1291514 IN     school 1806270 8045   Manchester Community Schools 180627001103 8625 Manchester Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_7                         58.0 49.0                       107.0                         58 49                 107
1281832 1281832 IN     school 1810680 815   Southeastern School Corp 181068001755 689 Lewis Cass Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_7                         44.0 64.0                       108.0                         44 64                 108
1282778 1282778 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative Education School No 4.0 03 12 2016   grade_7                         9.0 2.0                       11.0                         9 2                 11
1288736 1288736 IN     school 1804140 5900   Monroe-Gregg School District 180414002129 6315 Monrovia Middle School   Regular School No 2.0 06 08 2016   grade_7                         59.0 51.0                       110.0                         59 51                 110
1284997 1284997 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105000181 3107 Brownstown Central Middle School   Regular School No 2.0 06 08 2016   grade_7                         60.0 51.0                       111.0                         60 51                 111
1289787 1289787 IN     school 1801770 6825   Randolph Central School Corp 180177000235 7129 Lee L Driver Middle School   Regular School No 2.0 06 08 2016   grade_7                         63.0 48.0                       111.0                         63 48                 111
1282269 1282269 IN     school 1802440 1300   Crawford Co Com School Corp 180244000279 1059 Crawford County Jr-Sr HS   Regular School No 3.0 07 12 2016   grade_7                         58.0 54.0                       112.0                         58 54                 112
1285191 1285191 IN     school 1810800 4000   Southwestern-Jefferson Co Con 181080002547 3343 Southwestern Middle School   Regular School No 2.0 06 08 2016   grade_7                         66.0 46.0                       112.0                         66 46                 112
1284642 1284642 IN     school 1808280 3435   Shenandoah School Corporation 180828001421 2819 Shenandoah Middle School   Regular School No 2.0 06 08 2016   grade_7                         53.0 60.0                       113.0                         53 60                 113
1285665 1285665 IN     school 1813230 4455   Whitko Community School Corp 181323000068 3644 Whitko Middle School   Regular School No 2.0 06 08 2016   grade_7                         66.0 47.0                       113.0                         66 47                 113
1291220 1291220 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000477 8339 McGary Middle School   Regular School No 2.0 06 08 2016   grade_7                         59.0 54.0                       113.0                         59 54                 113
1292288 1292288 IN     school 1800028 9400   KIPP Indpls College Preparatory 180002802136 5860 KIPP Indy College Prep Middle   Regular School Yes 2.0 05 08 2016   grade_7                         56.0 58.0                       114.0                         56 58                 114
1283457 1283457 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000589 2123 Brookville Middle Sch   Regular School No 2.0 05 08 2016   grade_7                         57.0 58.0                       115.0                         57 58                 115
1291957 1291957 IN     school 1800720 8445   M S D Bluffton-Harrison 180072000147 9093 Bluffton-Harrison Middle Sch   Regular School No 2.0 05 08 2016   grade_7                         58.0 57.0                       115.0                         58 57                 115
1280888 1280888 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No 2.0 06 08 2016   grade_7                         65.0 51.0                       116.0                         65 51                 116
1281794 1281794 IN     school 1802700 755   Delphi Community School Corp 180270000327 609 Delphi Community Middle School   Regular School No 2.0 06 08 2016   grade_7                         64.0 52.0                       116.0                         64 52                 116
1284589 1284589 IN     school 1806660 3335   Mill Creek Community Sch Corp 180666001170 2687 Cascade Middle School   Regular School No 2.0 06 08 2016   grade_7                         59.0 57.0                       116.0                         59 57                 116
1286853 1286853 IN     school 1812880 5245   Frankton-Lapel Community Schs 181288002050 5005 Frankton Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_7                         58.0 58.0                       116.0                         58 58                 116
1289684 1289684 IN     school 1807980 6715   North Putnam Community Schools 180798000316 7049 North Putnam Middle Sch   Regular School No 2.0 06 08 2016   grade_7                         55.0 61.0                       116.0                         55 61                 116
1291577 1291577 IN     school 1812150 8060   Wabash City Schools 181215002301 8694 Wabash Middle School   Regular School No 2.0 05 08 2016   grade_7                         57.0 59.0                       116.0                         57 59                 116
1283736 1283736 IN     school 1803090 2940   Eastern Greene Schools 180309002419 2436 Eastern Greene Middle School   Regular School No 2.0 05 08 2016   grade_7                         71.0 46.0                       117.0                         71 46                 117
1285071 1285071 IN     school 1809420 3815   Rensselaer Central School Corp 180942001544 3221 Rensselaer Middle School   Regular School No 2.0 06 08 2016   grade_7                         64.0 53.0                       117.0                         64 53                 117
1286919 1286919 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No 3.0 07 12 2016   grade_7                         57.0 60.0                       117.0                         57 60                 117
1289399 1289399 IN     school 1811700 6530   Union Township School Corp 181170000793 6843 Union Township Middle Sch   Regular School No 2.0 06 08 2016   grade_7                         61.0 57.0                       118.0                         61 57                 118
1290457 1290457 IN     school 1808310 7350   Northwestern Con School Corp 180831001425 7697 Triton Central Middle School   Regular School No 2.0 05 08 2016   grade_7                         56.0 62.0                       118.0                         56 62                 118
1288307 1288307 IN     school 1800900 5480   Bremen Public Schools 180090000166 5943 Bremen Elem/Middle School   Regular School No 1.0 KG 08 2016   grade_7                         54.0 65.0                       119.0                         54 65                 119
1289745 1289745 IN     school 1811730 6795   Union School Corporation 181173001875 7119 Union Junior & High School   Regular School No 3.0 07 12 2016   grade_7                         3.0 9.0                       12.0                         3 9                 12
1283484 1283484 IN     school 1809630 2645   Rochester Community Sch Corp 180963001577 2177 Rochester Community Md Sch   Regular School No 2.0 06 08 2016   grade_7                         60.0 60.0                       120.0                         60 60                 120
1282838 1282838 IN     school 1810870 2110   Southwest Dubois Co Sch Corp 181087001777 1587 Southridge Middle School   Regular School No 2.0 06 08 2016   grade_7                         63.0 58.0                       121.0                         63 58                 121
1281617 1281617 IN     school 1800570 515   Blackford County Schools 180057000103 491 Blackford Junior High School   Regular School No 2.0 07 08 2016   grade_7                         63.0 59.0                       122.0                         63 59                 122
1283745 1283745 IN     school 1805910 2950   Linton-Stockton School Corp 180591002147 2438 Linton-Stockton Jr High School   Regular School No 2.0 06 08 2016   grade_7                         62.0 60.0                       122.0                         62 60                 122
1286777 1286777 IN     school 1807860 5075   North Lawrence Com Schools 180786000446 4878 Oolitic Middle School   Regular School No 2.0 06 08 2016   grade_7                         57.0 65.0                       122.0                         57 65                 122
1288703 1288703 IN     school 1810450 5845   South Montgomery Com Sch Corp 181045002325 6261 Southmont Jr High School   Regular School No 2.0 07 08 2016   grade_7                         62.0 60.0                       122.0                         62 60                 122
1280876 1280876 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No 2.0 05 08 2016   grade_7                         53.0 70.0                       123.0                         53 70                 123
1281096 1281096 IN     school 1803630 235   Fort Wayne Community Schools 180363000555 133 Portage Middle School   Regular School No 2.0 06 08 2016   grade_7                         74.0 49.0                       123.0                         74 49                 123
1282510 1282510 IN     school 1803060 1805   DeKalb Co Eastern Com Sch Dist 180306000405 1317 Eastside Junior-Senior High School   Regular School No 3.0 07 12 2016   grade_7                         68.0 57.0                       125.0                         68 57                 125
1286842 1286842 IN     school 1806900 5085   Mitchell Community Schools 180690002151 4924 Mitchell Jr High School   Regular School No 2.0 06 08 2016   grade_7                         58.0 67.0                       125.0                         58 67                 125
1291807 1291807 IN     school 1801560 8360   Centerville-Abington Com Schs 180156000216 8982 Centerville-Abington Jr High Sch   Regular School No 2.0 07 08 2016   grade_7                         64.0 61.0                       125.0                         64 61                 125
1288667 1288667 IN     school 1807900 5835   North Montgomery Com Sch Corp 180790002293 6244 Northridge Middle School   Regular School No 2.0 06 08 2016   grade_7                         54.0 72.0                       126.0                         54 72                 126
1290183 1290183 IN     school 1810290 7205   South Bend Community Sch Corp 181029001645 7510 Jackson Intermediate Center   Regular School No 2.0 05 08 2016   grade_7                         66.0 62.0                       128.0                         66 62                 128
1287787 1287787 IN     school 1804770 5385   Indianapolis Public Schools 180477002524 5517 John Marshall Community Jr HS   Regular School No 2.0 07 08 2016   grade_7                         76.0 53.0                       129.0                         76 53                 129
1291022 1291022 IN     school 1811610 7950   Union Co/Clg Corner Joint Sch Dist 181161001868 8206 Union County Middle School   Regular School No 2.0 06 08 2016   grade_7                         70.0 59.0                       129.0                         70 59                 129
1292633 1292633 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes 4.0 02 12 2016   grade_7                         13.0 0.0                       13.0                         13 0                 13
1292845 1292845 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes 4.0 KG 12 2016   grade_7                         10.0 3.0                       13.0                         10 3                 13
1285794 1285794 IN     school 1804620 4590   River Forest Community Sch Corp 180462000780 3801 River Forest Middle School   Regular School No 2.0 06 08 2016   grade_7                         79.0 52.0                       131.0                         79 52                 131
1288223 1288223 IN     school 1810920 5400   School Town of Speedway 181092001784 5889 Speedway Junior High School   Regular School No 2.0 07 08 2016   grade_7                         66.0 65.0                       131.0                         66 65                 131
1290555 1290555 IN     school 1808010 7385   North Spencer County Sch Corp 180801001898 7761 Heritage Hills Middle School   Regular School No 2.0 07 08 2016   grade_7                         65.0 69.0                       134.0                         65 69                 134
1290307 1290307 IN     school 1810290 7205   South Bend Community Sch Corp 181029001679 7597 Navarre Intermediate Center   Regular School No 2.0 05 08 2016   grade_7                         79.0 56.0                       135.0                         79 56                 135
1281881 1281881 IN     school 1806030 875   Logansport Community Sch Corp 180603001052 715 Columbia Middle School   Regular School No 2.0 06 08 2016   grade_7                         73.0 64.0                       137.0                         73 64                 137
1291349 1291349 IN     school 1812090 8030   Vigo County School Corp 181209001924 8461 West Vigo Middle School   Regular School No 2.0 06 08 2016   grade_7                         75.0 62.0                       137.0                         75 62                 137
1289251 1289251 IN     school 1808900 6445   Pike County School Corp 180890000889 6768 Pike Central Middle School   Regular School No 2.0 06 08 2016   grade_7                         76.0 62.0                       138.0                         76 62                 138
1284757 1284757 IN     school 1802040 3470   Northwestern School Corp 180204002334 2907 Northwestern Middle School   Regular School No 2.0 07 08 2016   grade_7                         59.0 80.0                       139.0                         59 80                 139
1287784 1287784 IN     school 1804770 5385   Indianapolis Public Schools 180477002528 5516 Northwest Community Jr High School   Regular School No 2.0 07 08 2016   grade_7                         77.0 62.0                       139.0                         77 62                 139
1292335 1292335 IN     school 1800043 9465   Rural Community Schools Inc 180004302138 7951 Rural Community Academy   Regular School Yes 1.0 KG 08 2016   grade_7                         8.0 6.0                       14.0                         8 6                 14
1292570 1292570 IN     school 1800167 9710   Carpe Diem - Northwest 180016702579 5977 Carpe Diem - Northwest   Regular School Yes 4.0 06 10 2016   grade_7                         8.0 6.0                       14.0                         8 6                 14
1285446 1285446 IN     school 1807620 4255   Nineveh-Hensley-Jackson United 180762001302 3418 Indian Creek Middle School   Regular School No 2.0 06 08 2016   grade_7                         69.0 71.0                       140.0                         69 71                 140
1285960 1285960 IN     school 1805460 4650   Lake Ridge New Tech Schools 180546000992 3893 Lake Ridge New Tech Middle School   Regular School No 2.0 06 08 2016   grade_7                         61.0 79.0                       140.0                         61 79                 140
1286075 1286075 IN     school 1802880 4670   School City of East Chicago 180288000370 3963 Joseph Block Middle School   Regular School No 2.0 07 08 2016   grade_7                         76.0 64.0                       140.0                         76 64                 140
1286211 1286211 IN     school 1803870 4690   Gary Community School Corp 180387002104 4169 Daniel Hale Williams Elem Sch   Regular School No 1.0 KG 08 2016   grade_7                         82.0 58.0                       140.0                         82 58                 140
1282446 1282446 IN     school 1805700 1620   Lawrenceburg Com School Corp 180570001036 1209 Greendale Middle School   Regular School No 2.0 06 08 2016   grade_7                         72.0 69.0                       141.0                         72 69                 141
1288431 1288431 IN     school 1808340 5625   Oak Hill United School Corp 180834001430 2305 Oak Hill Junior High School   Regular School No 2.0 07 08 2016   grade_7                         70.0 72.0                       142.0                         70 72                 142
1291224 1291224 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000480 8345 Perry Heights Middle School   Regular School No 2.0 06 08 2016   grade_7                         74.0 68.0                       142.0                         74 68                 142
1282543 1282543 IN     school 1803840 1820   Garrett-Keyser-Butler Com 180384001389 1331 Garrett Middle Sch   Regular School No 2.0 06 08 2016   grade_7                         66.0 78.0                       144.0                         66 78                 144
1289716 1289716 IN     school 1803990 6755   Greencastle Community Sch Corp 180399000689 7093 Greencastle Middle School   Regular School No 2.0 06 08 2016   grade_7                         65.0 79.0                       144.0                         65 79                 144
1291008 1291008 IN     school 1811400 7945   Tipton Community School Corp 181140001842 8167 Tipton Middle School   Regular School No 2.0 06 08 2016   grade_7                         65.0 79.0                       144.0                         65 79                 144
1284364 1284364 IN     school 1808100 3295   North West Hendricks Schools 180810001670 2682 Tri-West Middle School   Regular School No 2.0 06 08 2016   grade_7                         74.0 71.0                       145.0                         74 71                 145
1285653 1285653 IN     school 1811370 4445   Tippecanoe Valley School Corp 181137000397 3619 Tippecanoe Valley Middle School   Regular School No 2.0 06 08 2016   grade_7                         63.0 83.0                       146.0                         63 83                 146
1291357 1291357 IN     school 1812090 8030   Vigo County School Corp 181209001915 8481 Sarah Scott Middle School   Regular School No 2.0 06 08 2016   grade_7                         88.0 59.0                       147.0                         88 59                 147
1281076 1281076 IN     school 1803630 235   Fort Wayne Community Schools 180363000538 125 Lakeside Middle School   Regular School No 2.0 06 08 2016   grade_7                         84.0 64.0                       148.0                         84 64                 148
1285748 1285748 IN     school 1805520 4535   Lakeland School Corporation 180552002145 3743 Lakeland Middle School   Regular School No 2.0 06 08 2016   grade_7                         71.0 77.0                       148.0                         71 77                 148
1288459 1288459 IN     school 1808850 5635   Peru Community Schools 180885001477 6089 Peru Junior High School   Regular School No 2.0 04 09 2016   grade_7                         75.0 73.0                       148.0                         75 73                 148
1290239 1290239 IN     school 1810290 7205   South Bend Community Sch Corp 181029001682 7549 Jefferson Intermediate Center   Regular School No 2.0 05 08 2016   grade_7                         78.0 70.0                       148.0                         78 70                 148
1290953 1290953 IN     school 1811340 7865   Tippecanoe School Corp 181134001832 8045 Southwestern Middle School   Regular School No 2.0 06 08 2016   grade_7                         76.0 73.0                       149.0                         76 73                 149
1284938 1284938 IN     school 1801230 3640   Medora Community School Corp 180123000201 3093 Medora Jr & Sr High School   Regular School No 4.0 06 12 2016   grade_7                         6.0 9.0                       15.0                         6 9                 15
1290660 1290660 IN     school 1804230 7610   Hamilton Community Schools 180423000724 7885 Hamilton Community High Sch   Regular School No 3.0 07 12 2016   grade_7                         10.0 5.0                       15.0                         10 5                 15
1292488 1292488 IN     school 1800162 9630   Carpe Diem - Shadeland 180016202575 5978 Carpe Diem - Shadeland   Regular School Yes 4.0 06 10 2016   grade_7                         7.0 8.0                       15.0                         7 8                 15
1281847 1281847 IN     school 1806030 875   Logansport Community Sch Corp 180603001058 702 Lincoln Middle School   Regular School No 2.0 06 08 2016   grade_7                         73.0 77.0                       150.0                         73 77                 150
1282917 1282917 IN     school 1800420 2260   Baugo Community Schools 180042000091 1703 Jimtown Junior High School   Regular School No 2.0 07 08 2016   grade_7                         74.0 76.0                       150.0                         74 76                 150
1284769 1284769 IN     school 1803150 3480   Eastern Howard School Corporation 180315002589 2914 Eastern Middle School   Regular School No 2.0 06 08 2016   grade_7                         74.0 76.0                       150.0                         74 76                 150
1287704 1287704 IN     school 1804770 5385   Indianapolis Public Schools 180477002597 5466 Arlington Community Middle School   Regular School No 2.0 07 08 2016   grade_7                         89.0 61.0                       150.0                         89 61                 150

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