Data source: Big Local News · About: Big Local

686 rows where grade = "grade_6", state = "IN" and year = 2021 sorted by total

View and edit SQL

year

  • 2021 · 686

grade

  • grade_6 · 686
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
1919128 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 06 11 2021   grade_6                         1.0 0.0                       1.0                         1 0                 1
1919931 IN     school 1806030 875   Logansport Community Sch Corp 180603001058 702 Logansport Junior High School   Regular School No Middle 06 08 2021   grade_6                         0.0 1.0                       1.0                         0 1                 1
1921081 IN     school 1812240 2285   Wa-Nee Community Schools 181224001954 1743 Nappanee Elementary School   Regular School No Elementary KG 06 2021   grade_6                         1.0 0.0                       1.0                         1 0                 1
1921959 IN     school 1813080 3030   Westfield-Washington Schools 181308002074 2491 Westfield Middle School   Regular School No Middle 05 08 2021   grade_6                         1.0 0.0                       1.0                         1 0                 1
1922509 IN     school 1800270 3315   Avon Community School Corp 180027002450 2730 Avon Middle School North   Regular School No Middle 06 08 2021   grade_6                         1.0 0.0                       1.0                         1 0                 1
1922625 IN     school 1808970 3330   Plainfield Community School Corp 180897002694 3331 Pride Academy   Regular School No Secondary 05 11 2021   grade_6                         1.0 0.0                       1.0                         1 0                 1
1922847 IN     school 1804470 3490   Western School Corporation 180447002224 2923 Western Intermediate School   Regular School No Middle 03 08 2021   grade_6                         1.0 0.0                       1.0                         1 0                 1
1923769 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No High 06 12 2021   grade_6                         0.0 1.0                       1.0                         0 1                 1
1926608 IN     school 1806510 5925   MSD Martinsville Schools 180651002600 6332 John R. Wooden Middle School   Regular School No Middle 06 08 2021   grade_6                         0.0 1.0                       1.0                         0 1                 1
1926633 IN     school 1806510 5925   MSD Martinsville Schools 180651002355 6344 South Elementary School of Communi   Regular School No Elementary PK 06 2021   grade_6                         0.0 1.0                       1.0                         0 1                 1
1927212 IN     school   6530   Union Township School Corp   6811 Porter County Education Services             2021   grade_6                         0.0 1.0                       1.0                         0 1                 1
1929425 IN     school 1806270 8045   Manchester Community Schools 180627001101 8633 Manchester Elementary School   Regular School No Elementary PK 06 2021   grade_6                         1.0 0.0                       1.0                         1 0                 1
1930089 IN     school 1800222 9000   Phalen Virtual Leadership Academy 180022202707 9992 Phalen Virtual Leadership Academy   Regular School Yes Other 02 12 2021   grade_6                         1.0 0.0                       1.0                         1 0                 1
1930299 IN     school 1800016 9325   Options Charter Schools 180001601738 2524 Options Charter School - Carmel   Regular School Yes High 06 12 2021   grade_6                         1.0 0.0                       1.0                         1 0                 1
1921141 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2021   grade_6                         8.0 2.0                       10.0                         8 2                 10
1921553 IN     school 1802940 2725   East Gibson School Corporation 180294000383 2189 Barton Township Elementary   Regular School No Elementary KG 06 2021   grade_6                         5.0 5.0                       10.0                         5 5                 10
1930733 IN     school 1800072 9805   Hoosier Academy - Indianapolis 180007202422 2527 Hoosier Academy - Indianapolis   Regular School Yes Elementary KG 08 2021   grade_6                         4.0 6.0                       10.0                         4 6                 10
1924815 IN     school 1810440 5255   South Madison Com Sch Corp 181044001713 5061 Pendleton Elementary School   Regular School No Elementary PK 06 2021   grade_6                         56.0 44.0                       100.0                         56 44                 100
1924965 IN     school 1802640 5300   MSD Decatur Township 180264000317 5189 West Newton Elementary School   Regular School No Elementary 01 06 2021   grade_6                         44.0 56.0                       100.0                         44 56                 100
1928888 IN     school 1811610 7950   Union Co/Clg Corner Joint Sch Dist 181161001868 8206 Union County Middle School   Regular School No Middle 06 08 2021   grade_6                         50.0 50.0                       100.0                         50 50                 100
1928949 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002627 8242 McCutchanville Elementary School   Regular School No Elementary PK 06 2021   grade_6                         58.0 42.0                       100.0                         58 42                 100
1920180 IN     school 1800840 1125   Clay Community Schools 180084000156 895 Clay City Elementary School   Regular School No Elementary KG 06 2021   grade_6                         46.0 55.0                       101.0                         46 55                 101
1926134 IN     school 1800900 5480   Bremen Public Schools 180090000166 5943 Bremen Elementary/Middle School   Regular School No Elementary KG 08 2021   grade_6                         55.0 46.0                       101.0                         55 46                 101
1928220 IN     school 1811910 7215   Union-North United School Corp 181191002242 7400 LaVille Elementary School   Regular School No Elementary KG 06 2021   grade_6                         63.0 39.0                       102.0                         63 39                 102
1925087 IN     school 1805670 5330   MSD Lawrence Township 180567000150 5294 Forest Glen Elementary School   Regular School No Elementary PK 06 2021   grade_6                         48.0 55.0                       103.0                         48 55                 103
1927012 IN     school 1811260 6350   Tell City-Troy Twp School Corp 181126001282 6745 William Tell Elementary School   Regular School No Elementary PK 06 2021   grade_6                         50.0 53.0                       103.0                         50 53                 103
1924911 IN     school 1803300 5280   Elwood Community School Corp 180330002309 5151 Elwood Intermediate School   Regular School No Elementary 03 06 2021   grade_6                         41.0 63.0                       104.0                         41 63                 104
1919584 IN     school 1800360 365   Bartholomew Con School Corp 180036000071 369 Lillian Schmitt Elementary School   Regular School No Elementary PK 06 2021   grade_6                         62.0 43.0                       105.0                         62 43                 105
1922803 IN     school 1802040 3470   Northwestern School Corp 180204000254 2904 Northwestern Elementary School   Regular School No Elementary KG 06 2021   grade_6                         57.0 48.0                       105.0                         57 48                 105
1923047 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105000181 3107 Brownstown Central Middle School   Regular School No Middle 06 08 2021   grade_6                         52.0 53.0                       105.0                         52 53                 105
1929659 IN     school 1803000 8215   East Washington School Corp 180300000073 8906 East Washington Middle School   Regular School No Middle 05 08 2021   grade_6                         46.0 59.0                       105.0                         46 59                 105
1921200 IN     school 1803270 2305   Elkhart Community Schools 180327000441 1785 Pinewood Elementary School   Regular School No Elementary KG 06 2021   grade_6                         64.0 42.0                       106.0                         64 42                 106
1921780 IN     school 1805910 2950   Linton-Stockton School Corporation 180591002147 2438 Linton-Stockton Middle School   Regular School No Middle 06 08 2021   grade_6                         54.0 52.0                       106.0                         54 52                 106
1925496 IN     school 1812810 5375   MSD Wayne Township 181281002033 5241 Garden City Elementary School   Regular School No Elementary PK 06 2021   grade_6                         55.0 51.0                       106.0                         55 51                 106
1919912 IN     school 1810680 815   Lewis Cass Schools 181068002625 691 Lewis Cass Junior High School   Regular School No Middle 06 08 2021   grade_6                         58.0 49.0                       107.0                         58 49                 107
1923755 IN     school 1809300 4515   Prairie Heights Community Sch Corp 180930001525 3688 Prairie Heights Middle School   Regular School No Middle 05 08 2021   grade_6                         56.0 51.0                       107.0                         56 51                 107
1925039 IN     school 1805670 5330   MSD Lawrence Township 180567001024 5281 Brook Park Elementary School   Regular School No Elementary 01 06 2021   grade_6                         52.0 55.0                       107.0                         52 55                 107
1925046 IN     school 1805670 5330   MSD Lawrence Township 180567001032 5283 Mary Evelyn Castle Elementary Sch   Regular School No Elementary 01 06 2021   grade_6                         51.0 57.0                       108.0                         51 57                 108
1928787 IN     school 1811340 7865   Tippecanoe School Corp 181134001833 8026 Wainwright Middle School   Regular School No Middle 06 08 2021   grade_6                         44.0 64.0                       108.0                         44 64                 108
1925096 IN     school 1805670 5330   MSD Lawrence Township 180567002114 5295 Winding Ridge Elementary School   Regular School No Elementary 01 06 2021   grade_6                         57.0 52.0                       109.0                         57 52                 109
1925559 IN     school 1812810 5375   MSD Wayne Township 181281002042 5273 Westlake Elementary School   Regular School No Elementary PK 06 2021   grade_6                         61.0 48.0                       109.0                         61 48                 109
1927220 IN     school 1811700 6530   Union Township School Corp 181170000793 6843 Union Township Middle School   Regular School No Middle 06 08 2021   grade_6                         54.0 55.0                       109.0                         54 55                 109
1928325 IN     school 1808310 7350   Northwestern Con School Corp 180831001425 7697 Triton Central Middle School   Regular School No Middle 05 08 2021   grade_6                         54.0 55.0                       109.0                         54 55                 109
1929814 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other 01 12 2021   grade_6                         10.0 1.0                       11.0                         10 1                 11
1930150 IN     school 1800193 9080   Vanguard Collegiate of Indy 180019302639 1004 Vanguard Collegiate of Indy   Regular School Yes Middle 05 08 2021   grade_6                         5.0 6.0                       11.0                         5 6                 11
1930832 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other KG 12 2021   grade_6                         8.0 3.0                       11.0                         8 3                 11
1922698 IN     school 1808280 3435   Shenandoah School Corporation 180828001421 2819 Shenandoah Middle School   Regular School No Middle 06 08 2021   grade_6                         58.0 52.0                       110.0                         58 52                 110
1924824 IN     school 1810440 5255   South Madison Com Sch Corp 181044001676 5064 Maple Ridge Elementary School   Regular School No Elementary KG 06 2021   grade_6                         57.0 53.0                       110.0                         57 53                 110
1924952 IN     school 1802640 5300   MSD Decatur Township 180264002271 5187 Valley Mills Elementary School   Regular School No Elementary 01 06 2021   grade_6                         50.0 60.0                       110.0                         50 60                 110
1927047 IN     school 1808900 6445   Pike County School Corp 180890000889 6768 Pike Central Middle School   Regular School No Middle 06 08 2021   grade_6                         62.0 48.0                       110.0                         62 48                 110
1927655 IN     school 1801770 6825   Randolph Central School Corp 180177000235 7129 Lee L Driver Middle School   Regular School No Middle 06 08 2021   grade_6                         59.0 52.0                       111.0                         59 52                 111
1930897 IN     school 1800164 9965   Career Academy Middle School 180016402593 7563 Career Academy Middle School   Regular School Yes Middle 06 08 2021   grade_6                         62.0 49.0                       111.0                         62 49                 111
1925513 IN     school 1812810 5375   MSD Wayne Township 181281002036 5261 Rhoades Elementary School   Regular School No Elementary PK 06 2021   grade_6                         56.0 57.0                       113.0                         56 57                 113
1926530 IN     school 1810450 5845   South Montgomery Com Sch Corp 181045002325 6261 Southmont Jr High School   Regular School No Middle 06 08 2021   grade_6                         56.0 58.0                       114.0                         56 58                 114
1919874 IN     school 1802700 755   Delphi Community School Corp 180270000327 609 Delphi Community Middle School   Regular School No Middle 06 08 2021   grade_6                         57.0 59.0                       116.0                         57 59                 116
1924782 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002418 5012 Lapel Middle School   Regular School No Middle 06 08 2021   grade_6                         62.0 54.0                       116.0                         62 54                 116
1924799 IN     school 1810440 5255   South Madison Com Sch Corp 181044002167 4935 East Elementary School   Regular School No Elementary KG 06 2021   grade_6                         44.0 72.0                       116.0                         44 72                 116
1925056 IN     school 1805670 5330   MSD Lawrence Township 180567001026 5285 Crestview Elementary School   Regular School No Elementary 01 06 2021   grade_6                         62.0 54.0                       116.0                         62 54                 116
1929209 IN     school 1810590 8020   South Vermillion Com Sch Corp 181059001740 8434 South Vermillion Middle School   Regular School No Middle 06 08 2021   grade_6                         63.0 53.0                       116.0                         63 53                 116
1929431 IN     school 1806270 8045   Manchester Community Schools 180627001102 8645 Manchester Intermediate School   Regular School No Middle 04 06 2021   grade_6                         57.0 59.0                       116.0                         57 59                 116
1923855 IN     school 1804620 4590   River Forest Community Sch Corp 180462000780 3801 River Forest Middle School   Regular School No Middle 06 08 2021   grade_6                         63.0 54.0                       117.0                         63 54                 117
1928496 IN     school 1805340 7525   Knox Community School Corp 180534000939 7837 Knox Community Middle School   Regular School No Middle 05 08 2021   grade_6                         58.0 59.0                       117.0                         58 59                 117
1923813 IN     school 1805520 4535   Lakeland School Corporation 180552002672 3739 Lakeland Intermediate School   Regular School No Elementary 03 06 2021   grade_6                         68.0 50.0                       118.0                         68 50                 118
1923287 IN     school 1805190 4015   Jennings County School Corporation 180519000924 3397 North Vernon Elementary School   Regular School No Elementary PK 06 2021   grade_6                         54.0 65.0                       119.0                         54 65                 119
1925070 IN     school 1805670 5330   MSD Lawrence Township 180567001027 5289 Harrison Hill Elementary School   Regular School No Elementary 01 06 2021   grade_6                         65.0 54.0                       119.0                         65 54                 119
1925479 IN     school 1812810 5375   MSD Wayne Township 181281002034 5223 Maplewood Elementary School   Regular School No Elementary PK 06 2021   grade_6                         70.0 49.0                       119.0                         70 49                 119
1925581 IN     school 1812810 5375   MSD Wayne Township 181281002123 5446 Bridgeport Elementary School   Regular School No Elementary KG 06 2021   grade_6                         62.0 57.0                       119.0                         62 57                 119
1929241 IN     school 1812090 8030   Vigo County School Corp 181209001924 8461 West Vigo Middle School   Regular School No Middle 06 08 2021   grade_6                         62.0 57.0                       119.0                         62 57                 119
1919559 IN     school 1800360 365   Bartholomew Con School Corp 180036000077 357 Parkside Elementary School   Regular School No Elementary PK 06 2021   grade_6                         70.0 50.0                       120.0                         70 50                 120
1919622 IN     school 1800360 365   Bartholomew Con School Corp 180036000080 392 Southside Elementary School   Regular School No Elementary PK 06 2021   grade_6                         50.0 70.0                       120.0                         50 70                 120
1929481 IN     school 1812150 8060   Wabash City Schools 181215002301 8694 Wabash Middle School   Regular School No Middle 05 08 2021   grade_6                         54.0 66.0                       120.0                         54 66                 120
1924935 IN     school 1802640 5300   MSD Decatur Township 180264002112 5179 Blue Academy   Regular School No Elementary 01 06 2021   grade_6                         59.0 62.0                       121.0                         59 62                 121
1926390 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000118 6173 Binford Elementary School   Regular School No Elementary 03 06 2021   grade_6                         76.0 45.0                       121.0                         76 45                 121
1923123 IN     school 1809420 3815   Rensselaer Central School Corp 180942001544 3221 Rensselaer Middle School   Regular School No Middle 05 08 2021   grade_6                         63.0 59.0                       122.0                         63 59                 122
1925063 IN     school 1805670 5330   MSD Lawrence Township 180567002339 5287 Amy Beverland Elementary   Regular School No Elementary 01 06 2021   grade_6                         67.0 55.0                       122.0                         67 55                 122
1930392 IN     school 1800028 9400   KIPP Indy College Prep Middle 180002802136 5860 KIPP Indy College Prep Middle   Regular School Yes Middle 06 08 2021   grade_6                         61.0 61.0                       122.0                         61 61                 122
1918976 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 06 08 2021   grade_6                         60.0 63.0                       123.0                         60 63                 123
1924928 IN     school 1802640 5300   MSD Decatur Township 180264002111 5178 Gold Academy   Regular School No Elementary 01 06 2021   grade_6                         62.0 61.0                       123.0                         62 61                 123
1924014 IN     school 1805460 4650   Lake Ridge New Tech Schools 180546000992 3893 Lake Ridge New Tech Middle School   Regular School No Middle 05 08 2021   grade_6                         64.0 60.0                       124.0                         64 60                 124
1919824 IN     school 1800960 670   Brown County School Corporation 180096002556 571 Brown County Intermediate School   Regular School No Middle 05 06 2021   grade_6                         59.0 66.0                       125.0                         59 66                 125
1922896 IN     school 1805370 3500   Kokomo School Corporation 180537001018 2963 Maple Crest Middle School   Regular School No Middle 06 08 2021   grade_6                         77.0 48.0                       125.0                         77 48                 125
1925522 IN     school 1812810 5375   MSD Wayne Township 181281002037 5265 Robey Elementary School   Regular School No Elementary KG 06 2021   grade_6                         62.0 63.0                       125.0                         62 63                 125
1925080 IN     school 1805670 5330   MSD Lawrence Township 180567002278 5293 Indian Creek Elementary School   Regular School No Elementary 01 06 2021   grade_6                         70.0 56.0                       126.0                         70 56                 126
1922645 IN     school 1806660 3335   Mill Creek Community Sch Corp 180666001170 2687 Cascade Middle School   Regular School No Middle 06 08 2021   grade_6                         67.0 61.0                       128.0                         67 61                 128
1923154 IN     school 1804980 3945   Jay School Corporation 180498000913 3273 East Jay Elementary   Regular School No Elementary 03 06 2021   grade_6                         70.0 58.0                       128.0                         70 58                 128
1925505 IN     school 1812810 5375   MSD Wayne Township 181281002035 5257 McClelland Elementary School   Regular School No Elementary KG 06 2021   grade_6                         66.0 62.0                       128.0                         66 62                 128
1923720 IN     school 1811370 4445   Tippecanoe Valley School Corp 181137000397 3619 Tippecanoe Valley Middle School   Regular School No Middle 06 08 2021   grade_6                         67.0 62.0                       129.0                         67 62                 129
1921055 IN     school 1806600 2275   Middlebury Community Schools 180660002692 1738 Inspire Digital Learning School   Regular School No Elementary KG 06 2021   grade_6                         6.0 7.0                       13.0                         6 7                 13
1930685 IN     school 1800123 9735   Inspire Academy - A Sch of Inquiry 180012302560 1518 Inspire Academy - A Sch of Inquiry   Regular School Yes Elementary KG 08 2021   grade_6                         4.0 9.0                       13.0                         4 9                 13
1924839 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria Monroe Elementary Schoo   Regular School No Elementary PK 06 2021   grade_6                         60.0 70.0                       130.0                         60 70                 130
1925119 IN     school 1805670 5330   MSD Lawrence Township 180567001066 5299 Sunnyside Elementary School   Regular School No Elementary 01 06 2021   grade_6                         78.0 52.0                       130.0                         78 52                 130
1927566 IN     school 1803990 6755   Greencastle Community School Corp 180399000689 7093 Greencastle Middle School   Regular School No Middle 06 08 2021   grade_6                         66.0 64.0                       130.0                         66 64                 130
1921520 IN     school 1809630 2645   Rochester Community School Corp 180963001577 2177 Rochester Community Middle School   Regular School No Middle 06 08 2021   grade_6                         60.0 71.0                       131.0                         60 71                 131
1926267 IN     school 1808340 5625   Oak Hill United School Corp 180834001431 2306 Swayzee Elementary School   Regular School No Middle 05 06 2021   grade_6                         71.0 62.0                       133.0                         71 62                 133
1922824 IN     school 1803150 3480   Eastern Howard School Corporation 180315002589 2914 Eastern Middle School   Regular School No Middle 06 08 2021   grade_6                         64.0 70.0                       134.0                         64 70                 134
1924773 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002049 5009 Frankton Elementary School   Regular School No Elementary PK 06 2021   grade_6                         60.0 74.0                       134.0                         60 74                 134
1920601 IN     school 1803840 1820   Garrett-Keyser-Butler Com Sch Corp 180384001389 1331 Garrett Middle School   Regular School No Middle 06 08 2021   grade_6                         68.0 67.0                       135.0                         68 67                 135
1924751 IN     school 1806900 5085   Mitchell Community Schools 180690002151 4924 Mitchell Jr High School   Regular School No Middle 06 08 2021   grade_6                         67.0 68.0                       135.0                         67 68                 135
1926492 IN     school 1807900 5835   North Montgomery Com Sch Corp 180790002293 6244 North Montgomery Middle School   Regular School No Middle 06 08 2021   grade_6                         68.0 67.0                       135.0                         68 67                 135
1927409 IN     school 1807290 6590   MSD Mount Vernon 180729001227 6953 Mount Vernon Jr High School   Regular School No Middle 06 08 2021   grade_6                         68.0 69.0                       137.0                         68 69                 137

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