enrollments

Data source: Big Local News · About: Big Local

503 rows where grade = "grade_7", state = "IN" and year = 2015 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2015 · 503 ✖

grade ✖

  • grade_7 · 503 ✖
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
1159643 1159643 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No 3.0 07 12 2015   grade_7                         1.0 0.0                       1.0                         1 0                 1
1160752 1160752 IN     school 1800840 1125   Clay Community Schools 180084000159 942 Forest Park Elementary School   Regular School No 1.0 PK 07 2015   grade_7                         1.0 0.0                       1.0                         1 0                 1
1163277 1163277 IN     school 1807440 3445   New Castle Community Sch Corp 180744001289 2853 Sunnyside Elementary School   Regular School No 1.0 KG 07 2015   grade_7                         0.0 1.0                       1.0                         0 1                 1
1168952 1168952 IN     school 1810290 7205   South Bend Community Sch Corp 181029000898 7632 Juvenile Justice Center   Alternative Education School No 3.0 07 12 2015   grade_7                         1.0 0.0                       1.0                         1 0                 1
1170744 1170744 IN     school 1800006 9100   IN Department of Correction 180000601946 732 Logansport Juvenile Cor Fac   Regular School No 3.0 07 12 2015   grade_7                         1.0 0.0                       1.0                         1 0                 1
1160683 1160683 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 04 12 2015   grade_7                         10.0 0.0                       10.0                         10 0                 10
1160004 1160004 IN     school 1802850 255   East Allen County Schools 180285000361 285 Woodlan Jr/Sr High School   Regular School No 3.0 07 12 2015   grade_7                         56.0 44.0                       100.0                         56 44                 100
1169388 1169388 IN     school 1811220 7775   Switzerland County School Corp 181122000806 7987 Switzerland Co Middle Sch   Regular School No 2.0 07 08 2015   grade_7                         50.0 50.0                       100.0                         50 50                 100
1170999 1170999 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes 4.0 KG 12 2015   grade_7                         50.0 50.0                       100.0                         50 50                 100
1164394 1164394 IN     school 1804620 4590   River Forest Community Sch Corp 180462000781 3791 River Forest Jr-Sr High School   Regular School No 4.0 06 12 2015   grade_7                         48.0 53.0                       101.0                         48 53                 101
1167795 1167795 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 2015   grade_7                         61.0 40.0                       101.0                         61 40                 101
1168428 1168428 IN     school 1810530 6865   South Ripley Com Sch Corp 181053002482 7174 South Ripley Junior High School   Regular School No 2.0 07 08 2015   grade_7                         51.0 50.0                       101.0                         51 50                 101
1160398 1160398 IN     school 1802700 755   Delphi Community School Corp 180270000327 609 Delphi Community Middle Sch   Regular School No 2.0 06 08 2015   grade_7                         54.0 50.0                       104.0                         54 50                 104
1161084 1161084 IN     school 1802610 1655   Decatur County Com Schools 180261000309 1267 North Decatur Jr-Sr High Sch   Regular School No 3.0 07 12 2015   grade_7                         58.0 46.0                       104.0                         58 46                 104
1166908 1166908 IN     school 1800900 5480   Bremen Public Schools 180090000166 5943 Bremen Elem/Middle School   Regular School No 1.0 KG 08 2015   grade_7                         57.0 47.0                       104.0                         57 47                 104
1168253 1168253 IN     school 1810500 6705   South Putnam Community Schools 181050002542 7056 South Putnam Middle School   Regular School No 2.0 06 08 2015   grade_7                         57.0 47.0                       104.0                         57 47                 104
1162334 1162334 IN     school 1805910 2950   Linton-Stockton School Corp 180591002147 2438 Linton-Stockton Jr High Sch   Regular School No 2.0 06 08 2015   grade_7                         57.0 48.0                       105.0                         57 48                 105
1170949 1170949 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes 4.0 KG 12 2015   grade_7                         52.0 53.0                       105.0                         52 53                 105
1170920 1170920 IN     school 1800028 9400   KIPP Indpls College Preparatory 180002802136 5860 KIPP Indy College Prep Middle   Regular School Yes 2.0 05 08 2015   grade_7                         48.0 58.0                       106.0                         48 58                 106
1171497 1171497 IN     school 1800139 9940   Tindley Collegiate Academy 180013902559 5914 Tindley Collegiate Academy   Regular School Yes 2.0 05 08 2015   grade_7                         0.0 106.0                       106.0                         0 106                 106
1164055 1164055 IN     school 1807830 4315   North Knox School Corp 180783001334 3537 North Knox Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_7                         54.0 53.0                       107.0                         54 53                 107
1161108 1161108 IN     school 1803060 1805   DeKalb Co Eastern Com Sch Dist 180306000405 1317 Eastside Junior-Senior High Sch   Regular School No 3.0 07 12 2015   grade_7                         60.0 48.0                       108.0                         60 48                 108
1168959 1168959 IN     school 1811910 7215   Union-North United School Corp 181191001879 7399 LaVille Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_7                         58.0 50.0                       108.0                         58 50                 108
1169237 1169237 IN     school 1807800 7515   North Judson-San Pierre Sch Corp 180780001329 7854 North Judson-San Pierre Mdl Sch   Regular School No 2.0 06 08 2015   grade_7                         49.0 59.0                       108.0                         49 59                 108
1169531 1169531 IN     school 1811340 7865   Tippecanoe School Corp 181134001833 8026 Wainwright Middle School   Regular School No 2.0 06 08 2015   grade_7                         55.0 53.0                       108.0                         55 53                 108
1168896 1168896 IN     school 1810290 7205   South Bend Community Sch Corp 181029001666 7581 Marshall Intermediate Center   Regular School No 2.0 05 08 2015   grade_7                         65.0 44.0                       109.0                         65 44                 109
1171037 1171037 IN     school 1800051 9575   Indpls Lighthouse Charter School 180005102165 5523 Indpls Lighthouse Charter School   Regular School Yes 4.0 KG 12 2015   grade_7                         50.0 59.0                       109.0                         50 59                 109
1163236 1163236 IN     school 1808280 3435   Shenandoah School Corporation 180828001421 2819 Shenandoah Middle School   Regular School No 2.0 06 08 2015   grade_7                         56.0 54.0                       110.0                         56 54                 110
1164258 1164258 IN     school 1813230 4455   Whitko Community School Corp 181323000068 3644 Whitko Middle Sch   Regular School No 2.0 06 08 2015   grade_7                         62.0 48.0                       110.0                         62 48                 110
1165382 1165382 IN     school 1807860 5075   North Lawrence Com Schools 180786000446 4878 Oolitic Middle School   Regular School No 2.0 06 08 2015   grade_7                         58.0 52.0                       110.0                         58 52                 110
1160256 1160256 IN     school 1812990 615   Western Boone Co Com Sch Dist 181299002066 539 Western Boone Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_7                         66.0 45.0                       111.0                         66 45                 111
1160555 1160555 IN     school 1801920 1000   Clarksville Com School Corp 180192000248 851 Clarksville Middle School   Regular School No 2.0 05 08 2015   grade_7                         57.0 54.0                       111.0                         57 54                 111
1168835 1168835 IN     school 1810290 7205   South Bend Community Sch Corp 181029001681 7537 Edison Intermediate Center   Regular School No 2.0 05 08 2015   grade_7                         65.0 46.0                       111.0                         65 46                 111
1165594 1165594 IN     school 1803300 5280   Elwood Community School Corp 180330000449 5149 Elwood Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_7                         47.0 65.0                       112.0                         47 65                 112
1169369 1169369 IN     school 1810860 7715   Southwest School Corp 181086002359 7961 Sullivan Middle School   Regular School No 2.0 06 08 2015   grade_7                         64.0 48.0                       112.0                         64 48                 112
1170568 1170568 IN     school 1800720 8445   M S D Bluffton-Harrison 180072000147 9093 Bluffton-Harrison Middle Sch   Regular School No 2.0 05 08 2015   grade_7                         53.0 59.0                       112.0                         53 59                 112
1163182 1163182 IN     school 1806660 3335   Mill Creek Community Sch Corp 180666001170 2687 Cascade Middle School   Regular School No 2.0 06 08 2015   grade_7                         59.0 54.0                       113.0                         59 54                 113
1165476 1165476 IN     school 1812880 5245   Frankton-Lapel Community Schs 181288002418 5012 Lapel Middle School   Regular School No 2.0 06 08 2015   grade_7                         62.0 51.0                       113.0                         62 51                 113
1162850 1162850 IN     school 1803120 3145   Eastern Hancock Co Com Sch Corp 180312000658 2582 Eastern Hancock Middle Sch   Regular School No 2.0 06 08 2015   grade_7                         58.0 56.0                       114.0                         58 56                 114
1159486 1159486 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No 2.0 05 08 2015   grade_7                         49.0 66.0                       115.0                         49 66                 115
1162047 1162047 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000589 2123 Brookville Middle Sch   Regular School No 2.0 05 08 2015   grade_7                         56.0 59.0                       115.0                         56 59                 115
1169632 1169632 IN     school 1811610 7950   Union Co/Clg Corner Joint Sch Dist 181161001868 8206 Union County Middle School   Regular School No 2.0 06 08 2015   grade_7                         61.0 54.0                       115.0                         61 54                 115
1164283 1164283 IN     school 1809300 4515   Prairie Heights Com Sch Corp 180930001525 3688 Prairie Heights Middle School   Regular School No 2.0 05 08 2015   grade_7                         56.0 60.0                       116.0                         56 60                 116
1162212 1162212 IN     school 1803030 2815   Eastbrook Community Sch Corp 180303002273 2299 Eastbrook Junior High School   Regular School No 2.0 07 08 2015   grade_7                         59.0 58.0                       117.0                         59 58                 117
1168285 1168285 IN     school 1807980 6715   North Putnam Community Schools 180798000316 7049 North Putnam Middle Sch   Regular School No 2.0 06 08 2015   grade_7                         58.0 59.0                       117.0                         58 59                 117
1168393 1168393 IN     school 1801770 6825   Randolph Central School Corp 180177000235 7129 Lee L Driver Middle School   Regular School No 2.0 06 08 2015   grade_7                         56.0 61.0                       117.0                         56 61                 117
1165457 1165457 IN     school 1812880 5245   Frankton-Lapel Community Schs 181288002050 5005 Frankton Jr-Sr High Sch   Regular School No 3.0 07 12 2015   grade_7                         60.0 58.0                       118.0                         60 58                 118
1168001 1168001 IN     school 1811700 6530   Union Township School Corp 181170000793 6843 Union Township Middle Sch   Regular School No 2.0 06 08 2015   grade_7                         57.0 61.0                       118.0                         57 61                 118
1169072 1169072 IN     school 1808310 7350   Northwestern Con School Corp 180831001425 7697 Triton Central Middle School   Regular School No 2.0 05 08 2015   grade_7                         60.0 58.0                       118.0                         60 58                 118
1160867 1160867 IN     school 1802440 1300   Crawford Co Com School Corp 180244000279 1059 Crawford County Jr-Sr HS   Regular School No 3.0 07 12 2015   grade_7                         58.0 61.0                       119.0                         58 61                 119
1170420 1170420 IN     school 1801560 8360   Centerville-Abington Com Schs 180156000216 8982 Centerville-Abington Jr High Sch   Regular School No 2.0 07 08 2015   grade_7                         64.0 55.0                       119.0                         64 55                 119
1166239 1166239 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_7                         11.0 1.0                       12.0                         11 1                 12
1168691 1168691 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Joint Service Campus Program   Special Education School No 4.0 03 12 2015   grade_7                         10.0 2.0                       12.0                         10 2                 12
1164694 1164694 IN     school 1802910 4680   Lake Station Community Schools 180291000380 3965 Thomas A Edison Jr-Sr HS   Regular School No 3.0 07 12 2015   grade_7                         65.0 56.0                       121.0                         65 56                 121
1170127 1170127 IN     school 1806270 8045   Manchester Community Schools 180627001103 8625 Manchester Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_7                         57.0 65.0                       122.0                         57 65                 122
1160437 1160437 IN     school 1810680 815   Southeastern School Corp 181068001755 689 Lewis Cass Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_7                         73.0 50.0                       123.0                         73 50                 123
1168188 1168188 IN     school 1807950 6600   M S D North Posey Co Schools 180795001365 6973 North Posey Jr High Sch   Regular School No 2.0 07 08 2015   grade_7                         65.0 59.0                       124.0                         65 59                 124
1168769 1168769 IN     school 1810290 7205   South Bend Community Sch Corp 181029001650 7425 Clay Intermediate Center   Regular School No 2.0 05 08 2015   grade_7                         65.0 59.0                       124.0                         65 59                 124
1163665 1163665 IN     school 1809420 3815   Rensselaer Central School Corp 180942001544 3221 Rensselaer Middle School   Regular School No 2.0 06 08 2015   grade_7                         66.0 60.0                       126.0                         66 60                 126
1169831 1169831 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000477 8339 McGary Middle School   Regular School No 2.0 06 08 2015   grade_7                         71.0 57.0                       128.0                         71 57                 128
1167987 1167987 IN     school 1809180 6520   Porter Township School Corp 180918000523 6839 Boone Grove Middle School   Regular School No 2.0 06 08 2015   grade_7                         76.0 53.0                       129.0                         76 53                 129
1168546 1168546 IN     school 1809120 7150   John Glenn School Corporation 180912001504 5916 Harold C Urey Middle School   Regular School No 2.0 07 08 2015   grade_7                         72.0 57.0                       129.0                         72 57                 129
1168792 1168792 IN     school 1810290 7205   South Bend Community Sch Corp 181029001645 7510 Jackson Intermediate Center   Regular School No 2.0 05 08 2015   grade_7                         64.0 65.0                       129.0                         64 65                 129
1169835 1169835 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000480 8345 Perry Heights Middle School   Regular School No 2.0 06 08 2015   grade_7                         75.0 54.0                       129.0                         75 54                 129
1171472 1171472 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes 4.0 KG 12 2015   grade_7                         12.0 1.0                       13.0                         12 1                 13
1161436 1161436 IN     school 1810870 2110   Southwest Dubois Co Sch Corp 181087001777 1587 Southridge Middle School   Regular School No 2.0 06 08 2015   grade_7                         61.0 70.0                       131.0                         61 70                 131
1170363 1170363 IN     school 1803000 8215   East Washington School Corp 180300000073 8906 East Washington Middle Sch   Regular School No 2.0 05 08 2015   grade_7                         74.0 57.0                       131.0                         74 57                 131
1165523 1165523 IN     school 1800120 5265   Alexandria Com School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No 3.0 07 12 2015   grade_7                         79.0 53.0                       132.0                         79 53                 132
1167337 1167337 IN     school 1804140 5900   Monroe-Gregg School District 180414002129 6315 Monrovia Middle School   Regular School No 2.0 06 08 2015   grade_7                         70.0 65.0                       135.0                         70 65                 135
1169618 1169618 IN     school 1811400 7945   Tipton Community School Corp 181140001842 8167 Tipton Middle School   Regular School No 2.0 06 08 2015   grade_7                         70.0 65.0                       135.0                         70 65                 135
1163591 1163591 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105000181 3107 Brownstown Central Middle Sch   Regular School No 2.0 06 08 2015   grade_7                         67.0 69.0                       136.0                         67 69                 136
1167667 1167667 IN     school 1808640 6155   Paoli Community School Corp 180864001438 6581 Paoli Jr & Sr High Sch   Regular School No 3.0 07 12 2015   grade_7                         68.0 68.0                       136.0                         68 68                 136
1165446 1165446 IN     school 1806900 5085   Mitchell Community Schools 180690002151 4924 Mitchell Jr High School   Regular School No 2.0 06 08 2015   grade_7                         70.0 67.0                       137.0                         70 67                 137
1169247 1169247 IN     school 1805340 7525   Knox Community School Corp 180534000939 7837 Knox Community Middle School   Regular School No 2.0 06 08 2015   grade_7                         60.0 77.0                       137.0                         60 77                 137
1169928 1169928 IN     school 1810590 8020   South Vermillion Com Sch Corp 181059001740 8434 South Vermillion Middle Sch   Regular School No 2.0 06 08 2015   grade_7                         78.0 59.0                       137.0                         78 59                 137
1163366 1163366 IN     school 1803150 3480   Eastern Howard School Corp 180315000413 2919 Eastern Jr & Sr High School   Regular School No 3.0 07 12 2015   grade_7                         69.0 69.0                       138.0                         69 69                 138
1166823 1166823 IN     school 1810920 5400   School Town of Speedway 181092001784 5889 Speedway Junior High School   Regular School No 2.0 07 08 2015   grade_7                         77.0 61.0                       138.0                         77 61                 138
1162889 1162889 IN     school 1800690 3180   North Harrison Com School Corp 180069000145 2625 North Harrison Middle School   Regular School No 2.0 06 08 2015   grade_7                         60.0 79.0                       139.0                         60 79                 139
1168324 1168324 IN     school 1803990 6755   Greencastle Community Sch Corp 180399000689 7093 Greencastle Middle School   Regular School No 2.0 06 08 2015   grade_7                         83.0 56.0                       139.0                         83 56                 139
1170960 1170960 IN     school 1800043 9465   Rural Community Schools Inc 180004302138 7951 Rural Community Academy   Regular School Yes 1.0 KG 08 2015   grade_7                         3.0 11.0                       14.0                         3 11                 14
1162074 1162074 IN     school 1809630 2645   Rochester Community Sch Corp 180963001577 2177 Rochester Community Md Sch   Regular School No 2.0 06 08 2015   grade_7                         67.0 73.0                       140.0                         67 73                 140
1167304 1167304 IN     school 1810450 5845   South Montgomery Com Sch Corp 181045002325 6261 Southmont Jr High School   Regular School No 2.0 07 08 2015   grade_7                         75.0 66.0                       141.0                         75 66                 141
1169540 1169540 IN     school 1811340 7865   Tippecanoe School Corp 181134001825 8033 East Tipp Middle School   Regular School No 2.0 06 08 2015   grade_7                         66.0 77.0                       143.0                         66 77                 143
1170730 1170730 IN     school 1800127 8825   CSUSA Donnan 180012700823 5572 Emma Donnan Middle School   Regular School No 2.0 07 08 2015   grade_7                         74.0 69.0                       143.0                         74 69                 143
1160013 1160013 IN     school 1802850 255   East Allen County Schools 180285002509 294 Paul Harding Jr High School   Regular School No 2.0 07 08 2015   grade_7                         74.0 70.0                       144.0                         74 70                 144
1164246 1164246 IN     school 1811370 4445   Tippecanoe Valley School Corp 181137000397 3619 Tippecanoe Valley Middle Sch   Regular School No 2.0 06 08 2015   grade_7                         84.0 60.0                       144.0                         84 60                 144
1164573 1164573 IN     school 1805460 4650   Lake Ridge Schools 180546000992 3893 Lake Ridge Middle School   Regular School No 2.0 06 08 2015   grade_7                         83.0 61.0                       144.0                         83 61                 144
1160485 1160485 IN     school 1806030 875   Logansport Community Sch Corp 180603001052 715 Columbia Middle School   Regular School No 2.0 06 08 2015   grade_7                         74.0 71.0                       145.0                         74 71                 145
1169873 1169873 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000488 8369 Washington Middle School   Regular School No 2.0 06 08 2015   grade_7                         63.0 82.0                       145.0                         63 82                 145
1167033 1167033 IN     school 1808340 5625   Oak Hill United School Corp 180834001430 2305 Oak Hill Junior High School   Regular School No 2.0 07 08 2015   grade_7                         75.0 72.0                       147.0                         75 72                 147
1168853 1168853 IN     school 1810290 7205   South Bend Community Sch Corp 181029001682 7549 Jefferson Intermediate Center   Regular School No 2.0 05 08 2015   grade_7                         80.0 67.0                       147.0                         80 67                 147
1160198 1160198 IN     school 1800480 395   Benton Community School Corp 180048000097 445 Benton Central Jr-Sr High Sch   Regular School No 3.0 07 12 2015   grade_7                         74.0 74.0                       148.0                         74 74                 148
1163433 1163433 IN     school 1805370 3500   Kokomo School Corporation 180537001018 2963 Maple Crest Middle Sch   Regular School No 2.0 06 08 2015   grade_7                         78.0 70.0                       148.0                         78 70                 148
1164341 1164341 IN     school 1805520 4535   Lakeland School Corporation 180552002145 3743 Lakeland Middle School   Regular School No 2.0 06 08 2015   grade_7                         76.0 72.0                       148.0                         76 72                 148
1161141 1161141 IN     school 1803840 1820   Garrett-Keyser-Butler Com 180384001389 1331 Garrett Middle Sch   Regular School No 2.0 06 08 2015   grade_7                         76.0 73.0                       149.0                         76 73                 149
1164040 1164040 IN     school 1807620 4255   Nineveh-Hensley-Jackson United 180762001302 3418 Indian Creek Middle School   Regular School No 2.0 06 08 2015   grade_7                         69.0 80.0                       149.0                         69 80                 149
1171175 1171175 IN     school 1800065 9690   Renaissance Academy Charter School 180006502415 4711 Renaissance Academy Charter Schl   Regular School Yes 1.0 KG 08 2015   grade_7                         9.0 6.0                       15.0                         9 6                 15
1162958 1162958 IN     school 1808100 3295   North West Hendricks Schools 180810001670 2682 Tri-West Middle School   Regular School No 2.0 06 08 2015   grade_7                         83.0 67.0                       150.0                         83 67                 150
1168457 1168457 IN     school 1800390 6895   Batesville Community Sch Corp 180039000085 7219 Batesville Middle School   Regular School No 2.0 06 08 2015   grade_7                         93.0 57.0                       150.0                         93 57                 150
1169171 1169171 IN     school 1808010 7385   North Spencer County Sch Corp 180801001898 7761 Heritage Hills Middle School   Regular School No 2.0 07 08 2015   grade_7                         80.0 70.0                       150.0                         80 70                 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]);