Data source: Big Local News · About: Big Local

697 rows where grade = "grade_6", state = "IN" and year = 2017 sorted by total

View and edit SQL

year

  • 2017 · 697

grade

  • grade_6 · 697
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
1293090 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Other 05 11 2017   grade_6                         0.0 1.0                       1.0                         0 1                 1
1294150 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No Other 06 12 2017   grade_6                         1.0 0.0                       1.0                         1 0                 1
1295052 IN     school 1812240 2285   Wa-Nee Community Schools 181224000028 1735 Wakarusa Elementary School   Regular School No Elementary KG 06 2017   grade_6                         0.0 1.0                       1.0                         0 1                 1
1295137 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2017   grade_6                         1.0 0.0                       1.0                         1 0                 1
1295281 IN     school 1803930 2315   Goshen Community Schools 180393002180 1847 Prairie View Elementary School   Regular School No Elementary PK 06 2017   grade_6                         1.0 0.0                       1.0                         1 0                 1
1298488 IN     school 1804590 4730   School City of Hobart 180459000775 4317 Liberty Elementary School   Regular School No Elementary 01 06 2017   grade_6                         1.0 0.0                       1.0                         1 0                 1
1298495 IN     school 1804590 4730   School City of Hobart 180459000777 4325 Ridge View Elementary School   Regular School No Elementary 01 06 2017   grade_6                         1.0 0.0                       1.0                         1 0                 1
1298502 IN     school 1804590 4730   School City of Hobart 180459000214 4327 Joan Martin Elementary School   Regular School No Elementary 01 06 2017   grade_6                         0.0 1.0                       1.0                         0 1                 1
1299164 IN     school 1805670 5330   M S D Lawrence Township 180567001023 5277 Belzer Middle School   Regular School No Middle 06 08 2017   grade_6                         1.0 0.0                       1.0                         1 0                 1
1300456 IN     school 1808340 5625   Oak Hill United School Corp 180834001430 2305 Oak Hill Junior High School   Regular School No Middle 06 08 2017   grade_6                         0.0 1.0                       1.0                         0 1                 1
1301747 IN     school 1803990 6755   Greencastle Community School Corp 180399000693 7102 Tzouanakis Intermediate School   Regular School No Elementary 02 06 2017   grade_6                         1.0 0.0                       1.0                         1 0                 1
1303581 IN     school 1812180 8050   M S D Wabash County Schools 181218001951 8673 White's Jr-Sr High School   Regular School No Other 06 12 2017   grade_6                         1.0 0.0                       1.0                         1 0                 1
1304271 IN     school 1800015 9360   Veritas Academy 180001501786 1540 Veritas Academy   Regular School Yes Elementary KG 08 2017   grade_6                         6.0 4.0                       10.0                         6 4                 10
1304716 IN     school 1800074 9795   Dr Robert H Faulkner Academy 180007402426 2411 Dr Robert H Faulkner Academy   Regular School Yes Elementary KG 06 2017   grade_6                         5.0 5.0                       10.0                         5 5                 10
1304871 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other KG 12 2017   grade_6                         8.0 2.0                       10.0                         8 2                 10
1299066 IN     school 1802640 5300   M S D Decatur Township 180264000315 5185 Stephen Decatur Elementary School   Regular School No Elementary 01 06 2017   grade_6                         51.0 49.0                       100.0                         51 49                 100
1299640 IN     school 1812810 5375   M S D Wayne Township 181281002036 5261 Rhoades Elementary School   Regular School No Elementary PK 06 2017   grade_6                         44.0 56.0                       100.0                         44 56                 100
1302247 IN     school 1810290 7205   South Bend Community School Corp 181029001681 7537 Edison Intermediate Center   Regular School No Middle 05 08 2017   grade_6                         51.0 49.0                       100.0                         51 49                 100
1299173 IN     school 1805670 5330   M S D Lawrence Township 180567001024 5281 Brook Park Elementary School   Regular School No Elementary 01 06 2017   grade_6                         49.0 52.0                       101.0                         49 52                 101
1299180 IN     school 1805670 5330   M S D Lawrence Township 180567001032 5283 Mary Evelyn Castle Elementary Sch   Regular School No Elementary 01 06 2017   grade_6                         52.0 49.0                       101.0                         52 49                 101
1299709 IN     school 1812810 5375   M S D Wayne Township 181281002123 5446 Bridgeport Elementary School   Regular School No Elementary KG 06 2017   grade_6                         49.0 52.0                       101.0                         49 52                 101
1303858 IN     school 1808190 8375   Northeastern Wayne Schools 180819002567 8929 Northeastern Middle School   Regular School No Middle 06 08 2017   grade_6                         50.0 51.0                       101.0                         50 51                 101
1299056 IN     school 1802640 5300   M S D Decatur Township 180264002112 5179 Blue Academy   Regular School No Elementary 01 06 2017   grade_6                         60.0 42.0                       102.0                         60 42                 102
1304408 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes Other KG 12 2017   grade_6                         53.0 50.0                       103.0                         53 50                 103
1304939 IN     school 1800164 9965   Career Academy Middle School 180016402593 7563 Career Academy Middle School   Regular School Yes Middle 05 08 2017   grade_6                         47.0 56.0                       103.0                         47 56                 103
1298898 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002049 5009 Frankton Elementary School   Regular School No Elementary PK 06 2017   grade_6                         59.0 45.0                       104.0                         59 45                 104
1293884 IN     school 1810680 815   Southeastern School Corp 181068001754 673 Galveston Elementary School   Regular School No Elementary 04 06 2017   grade_6                         56.0 49.0                       105.0                         56 49                 105
1295191 IN     school 1803270 2305   Elkhart Community Schools 180327000441 1785 Pinewood Elementary School   Regular School No Elementary KG 06 2017   grade_6                         60.0 45.0                       105.0                         60 45                 105
1301707 IN     school 1807980 6715   North Putnam Community Schools 180798000316 7049 North Putnam Middle School   Regular School No Middle 06 08 2017   grade_6                         50.0 55.0                       105.0                         50 55                 105
1293558 IN     school 1800360 365   Bartholomew Con School Corp 180036000071 369 Lillian Schmitt Elementary School   Regular School No Elementary KG 06 2017   grade_6                         52.0 54.0                       106.0                         52 54                 106
1297226 IN     school 1810800 4000   Southwestern-Jefferson Co Con 181080002547 3343 Southwestern Middle School   Regular School No Middle 06 08 2017   grade_6                         61.0 46.0                       107.0                         61 46                 107
1297515 IN     school 1807830 4315   North Knox School Corp 180783001335 3545 North Knox Intermediate   Regular School No Elementary 03 06 2017   grade_6                         48.0 59.0                       107.0                         48 59                 107
1299085 IN     school 1802640 5300   M S D Decatur Township 180264000317 5189 West Newton Elementary School   Regular School No Elementary 01 06 2017   grade_6                         50.0 57.0                       107.0                         50 57                 107
1299696 IN     school 1812810 5375   M S D Wayne Township 181281002031 5274 Chapelwood Elementary School   Regular School No Elementary KG 06 2017   grade_6                         63.0 44.0                       107.0                         63 44                 107
1300329 IN     school 1800900 5480   Bremen Public Schools 180090000166 5943 Bremen Elementary/Middle School   Regular School No Elementary KG 08 2017   grade_6                         56.0 51.0                       107.0                         56 51                 107
1301405 IN     school 1809180 6520   Porter Township School Corp 180918000523 6839 Boone Grove Middle School   Regular School No Middle 06 08 2017   grade_6                         54.0 54.0                       108.0                         54 54                 108
1302187 IN     school 1810290 7205   South Bend Community School Corp 181029001650 7425 Clay Intermediate Center   Regular School No Middle 05 08 2017   grade_6                         61.0 47.0                       108.0                         61 47                 108
1302232 IN     school 1810290 7205   South Bend Community School Corp 181029002296 7521 Brown Intermediate Center   Regular School No Elementary 03 08 2017   grade_6                         45.0 63.0                       108.0                         45 63                 108
1292938 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 05 08 2017   grade_6                         46.0 63.0                       109.0                         46 63                 109
1293531 IN     school 1800360 365   Bartholomew Con School Corp 180036000077 357 Parkside Elementary School   Regular School No Elementary PK 06 2017   grade_6                         55.0 54.0                       109.0                         55 54                 109
1297030 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105000181 3107 Brownstown Central Middle School   Regular School No Middle 06 08 2017   grade_6                         56.0 53.0                       109.0                         56 53                 109
1303152 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other KG 12 2017   grade_6                         9.0 2.0                       11.0                         9 2                 11
1296856 IN     school 1805370 3500   Kokomo School Corporation 180537000995 2951 Bon Air Middle School   Regular School No Middle 06 08 2017   grade_6                         60.0 50.0                       110.0                         60 50                 110
1297710 IN     school 1813230 4455   Whitko Community School Corp 181323000068 3644 Whitko Middle School   Regular School No Middle 06 08 2017   grade_6                         52.0 58.0                       110.0                         52 58                 110
1299632 IN     school 1812810 5375   M S D Wayne Township 181281002035 5257 McClelland Elementary School   Regular School No Elementary KG 06 2017   grade_6                         60.0 50.0                       110.0                         60 50                 110
1301105 IN     school 1808640 6155   Paoli Community School Corp 180864001439 6587 Throop Elementary School   Regular School No Elementary KG 06 2017   grade_6                         51.0 59.0                       110.0                         51 59                 110
1297284 IN     school 1805190 4015   Jennings County School Corporation 180519000924 3397 North Vernon Elementary School   Regular School No Elementary KG 06 2017   grade_6                         60.0 51.0                       111.0                         60 51                 111
1299214 IN     school 1805670 5330   M S D Lawrence Township 180567002278 5293 Indian Creek Elementary School   Regular School No Elementary 01 06 2017   grade_6                         59.0 52.0                       111.0                         59 52                 111
1303597 IN     school 1812150 8060   Wabash City Schools 181215002301 8694 Wabash Middle School   Regular School No Middle 05 08 2017   grade_6                         60.0 51.0                       111.0                         60 51                 111
1298961 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No Elementary 03 06 2017   grade_6                         55.0 57.0                       112.0                         55 57                 112
1293850 IN     school 1802700 755   Delphi Community School Corp 180270000327 609 Delphi Community Middle School   Regular School No Middle 06 08 2017   grade_6                         53.0 60.0                       113.0                         53 60                 113
1294317 IN     school 1802440 1300   Crawford County Community Sch Corp 180244000282 1061 Crawford County Middle School   Regular School No Middle 06 08 2017   grade_6                         55.0 58.0                       113.0                         55 58                 113
1299229 IN     school 1805670 5330   M S D Lawrence Township 180567002114 5295 Winding Ridge Elementary School   Regular School No Elementary 01 06 2017   grade_6                         55.0 58.0                       113.0                         55 58                 113
1299615 IN     school 1812810 5375   M S D Wayne Township 181281002030 5227 Chapel Glen Elementary School   Regular School No Elementary KG 06 2017   grade_6                         60.0 53.0                       113.0                         60 53                 113
1296802 IN     school 1803150 3480   Eastern Howard School Corporation 180315002589 2914 Eastern Middle School   Regular School No Middle 06 08 2017   grade_6                         53.0 61.0                       114.0                         53 61                 114
1303050 IN     school 1811610 7950   Union Co/Clg Corner Joint Sch Dist 181161001868 8206 Union County Middle School   Regular School No Middle 06 08 2017   grade_6                         58.0 56.0                       114.0                         58 56                 114
1303772 IN     school 1803000 8215   East Washington School Corp 180300000073 8906 East Washington Middle School   Regular School No Middle 05 08 2017   grade_6                         61.0 53.0                       114.0                         61 53                 114
1296624 IN     school 1806660 3335   Mill Creek Community Sch Corp 180666001170 2687 Cascade Middle School   Regular School No Middle 06 08 2017   grade_6                         57.0 58.0                       115.0                         57 58                 115
1298907 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002418 5012 Lapel Middle School   Regular School No Middle 06 08 2017   grade_6                         51.0 64.0                       115.0                         51 64                 115
1299032 IN     school 1803300 5280   Elwood Community School Corp 180330002309 5151 Elwood Intermediate School   Regular School No Elementary 03 06 2017   grade_6                         69.0 46.0                       115.0                         69 46                 115
1302210 IN     school 1810290 7205   South Bend Community School Corp 181029001645 7510 Jackson Intermediate Center   Regular School No Middle 05 08 2017   grade_6                         65.0 50.0                       115.0                         65 50                 115
1294672 IN     school 1805880 1895   Liberty-Perry Community Sch Corp 180588001046 1377 Selma Middle School   Regular School No Middle 06 08 2017   grade_6                         62.0 54.0                       116.0                         62 54                 116
1300764 IN     school 1804140 5900   Monroe-Gregg School District 180414002129 6315 Monrovia Middle School   Regular School No Middle 06 08 2017   grade_6                         58.0 58.0                       116.0                         58 58                 116
1298924 IN     school 1810440 5255   South Madison Com Sch Corp 181044002167 4935 East Elementary School   Regular School No Elementary KG 06 2017   grade_6                         54.0 63.0                       117.0                         54 63                 117
1303979 IN     school 1800720 8445   M S D Bluffton-Harrison 180072000147 9093 Bluffton-Harrison Middle School   Regular School No Middle 05 08 2017   grade_6                         57.0 60.0                       117.0                         57 60                 117
1295786 IN     school 1805910 2950   Linton-Stockton School Corporation 180591002147 2438 Linton-Stockton Jr High School   Regular School No Middle 06 08 2017   grade_6                         67.0 51.0                       118.0                         67 51                 118
1303249 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000477 8339 McGary Middle School   Regular School No Middle 06 08 2017   grade_6                         64.0 54.0                       118.0                         64 54                 118
1297841 IN     school 1804620 4590   River Forest Community Sch Corp 180462000780 3801 River Forest Middle School   Regular School No Middle 06 08 2017   grade_6                         70.0 49.0                       119.0                         70 49                 119
1301809 IN     school 1801770 6825   Randolph Central School Corp 180177000235 7129 Lee L Driver Middle School   Regular School No Middle 06 08 2017   grade_6                         58.0 61.0                       119.0                         58 61                 119
1301212 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elementary & High School   Regular School No Other PK 12 2017   grade_6                         6.0 6.0                       12.0                         6 6                 12
1303621 IN     school 1806080 8115   M S D Warren County 180608001072 8733 Pine Village Elementary School   Regular School No Elementary KG 06 2017   grade_6                         7.0 5.0                       12.0                         7 5                 12
1296221 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071001407 2567 Sugar Creek Elementary Sch   Regular School No Elementary KG 06 2017   grade_6                         62.0 59.0                       121.0                         62 59                 121
1298877 IN     school 1806900 5085   Mitchell Community Schools 180690002151 4924 Mitchell Jr High School   Regular School No Middle 06 08 2017   grade_6                         57.0 64.0                       121.0                         57 64                 121
1300461 IN     school 1808340 5625   Oak Hill United School Corp 180834001431 2306 Swayzee Elementary School   Regular School No Middle 05 06 2017   grade_6                         62.0 60.0                       122.0                         62 60                 122
1296677 IN     school 1808280 3435   Shenandoah School Corporation 180828001421 2819 Shenandoah Middle School   Regular School No Middle 06 08 2017   grade_6                         62.0 61.0                       123.0                         62 61                 123
1299657 IN     school 1812810 5375   M S D Wayne Township 181281000238 5267 North Wayne Elementary School   Regular School No Elementary KG 06 2017   grade_6                         63.0 60.0                       123.0                         63 60                 123
1293596 IN     school 1800360 365   Bartholomew Con School Corp 180036000080 392 Southside Elementary School   Regular School No Elementary PK 06 2017   grade_6                         68.0 56.0                       124.0                         68 56                 124
1298813 IN     school 1807860 5075   North Lawrence Com Schools 180786000446 4878 Oolitic Middle School   Regular School No Middle 06 08 2017   grade_6                         61.0 63.0                       124.0                         61 63                 124
1299236 IN     school 1805670 5330   M S D Lawrence Township 180567001033 5296 Oaklandon Elementary School   Regular School No Elementary 01 06 2017   grade_6                         65.0 60.0                       125.0                         65 60                 125
1299649 IN     school 1812810 5375   M S D Wayne Township 181281002037 5265 Robey Elementary School   Regular School No Elementary KG 06 2017   grade_6                         62.0 63.0                       125.0                         62 63                 125
1299197 IN     school 1805670 5330   M S D Lawrence Township 180567002339 5287 Amy Beverland Elementary   Regular School No Elementary 01 06 2017   grade_6                         53.0 73.0                       126.0                         53 73                 126
1296872 IN     school 1805370 3500   Kokomo School Corporation 180537001018 2963 Maple Crest Middle School   Regular School No Middle 06 08 2017   grade_6                         67.0 60.0                       127.0                         67 60                 127
1303036 IN     school 1811400 7945   Tipton Community School Corp 181140001842 8167 Tipton Middle School   Regular School No Middle 06 08 2017   grade_6                         58.0 69.0                       127.0                         58 69                 127
1303292 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000488 8369 Washington Middle School   Regular School No Middle 06 08 2017   grade_6                         51.0 76.0                       127.0                         51 76                 127
1301231 IN     school 1811260 6350   Tell City-Troy Twp School Corp 181126001282 6745 William Tell Elementary School   Regular School No Elementary KG 06 2017   grade_6                         69.0 60.0                       129.0                         69 60                 129
1304289 IN     school 1800143 9375   IN Math & Science Academy - South 180014302561 5671 IN Math & Science Academy - South   Regular School Yes Elementary KG 08 2017   grade_6                         5.0 8.0                       13.0                         5 8                 13
1304610 IN     school 1800167 9710   Carpe Diem - Northwest 180016702579 5977 Carpe Diem - Northwest   Regular School Yes Other 06 12 2017   grade_6                         6.0 7.0                       13.0                         6 7                 13
1304670 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes Other 04 12 2017   grade_6                         13.0 0.0                       13.0                         13 0                 13
1294873 IN     school 1810870 2110   Southwest Dubois Co Sch Corp 181087001777 1587 Southridge Middle School   Regular School No Middle 06 08 2017   grade_6                         64.0 66.0                       130.0                         64 66                 130
1300597 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000118 6173 Binford Elementary School   Regular School No Elementary 03 06 2017   grade_6                         73.0 57.0                       130.0                         73 57                 130
1300694 IN     school 1807900 5835   North Montgomery Com Sch Corp 180790002293 6244 Northridge Middle School   Regular School No Middle 06 08 2017   grade_6                         66.0 64.0                       130.0                         66 64                 130
1303378 IN     school 1812090 8030   Vigo County School Corp 181209001924 8461 West Vigo Middle School   Regular School No Middle 06 08 2017   grade_6                         62.0 68.0                       130.0                         62 68                 130
1303548 IN     school 1806270 8045   Manchester Community Schools 180627001102 8645 Manchester Intermediate School   Regular School No Elementary 04 06 2017   grade_6                         64.0 66.0                       130.0                         64 66                 130
1298940 IN     school 1810440 5255   South Madison Com Sch Corp 181044001713 5061 Pendleton Elementary School   Regular School No Elementary KG 06 2017   grade_6                         73.0 58.0                       131.0                         73 58                 131
1301739 IN     school 1803990 6755   Greencastle Community School Corp 180399000689 7093 Greencastle Middle School   Regular School No Middle 06 08 2017   grade_6                         63.0 68.0                       131.0                         63 68                 131
1297492 IN     school 1807620 4255   Nineveh-Hensley-Jackson United 180762001302 3418 Indian Creek Middle School   Regular School No Middle 06 08 2017   grade_6                         69.0 63.0                       132.0                         69 63                 132
1302333 IN     school 1810290 7205   South Bend Community School Corp 181029001679 7597 Navarre Intermediate Center   Regular School No Middle 05 08 2017   grade_6                         71.0 63.0                       134.0                         71 63                 134
1303092 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002507 8231 Oak Hill Elementary   Regular School No Elementary KG 06 2017   grade_6                         63.0 71.0                       134.0                         63 71                 134
1294578 IN     school 1803840 1820   Garrett-Keyser-Butler Com Sch Corp 180384001389 1331 Garrett Middle School   Regular School No Middle 06 08 2017   grade_6                         70.0 65.0                       135.0                         70 65                 135
1296401 IN     school 1808100 3295   North West Hendricks Schools 180810001670 2682 Tri-West Middle School   Regular School No Middle 06 08 2017   grade_6                         64.0 72.0                       136.0                         64 72                 136

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