enrollments

Data source: Big Local News · About: Big Local

693 rows where grade = "grade_6", state = "IN" and year = 2018 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 693 ✖

grade ✖

  • grade_6 · 693 ✖
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
1788500 1788500 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No High 05 12 2018   grade_6                         1.0 0.0                       1.0                         1 0                 1
1789395 1789395 IN     school 1812240 2285   Wa-Nee Community Schools 181224000028 1735 Wakarusa Elementary School   Regular School No Elementary KG 06 2018   grade_6                         1.0 0.0                       1.0                         1 0                 1
1789624 1789624 IN     school 1803930 2315   Goshen Community Schools 180393002180 1847 Prairie View Elementary School   Regular School No Elementary PK 06 2018   grade_6                         1.0 0.0                       1.0                         1 0                 1
1790303 1790303 IN     school 1813080 3030   Westfield-Washington Schools 181308002074 2491 Westfield Middle School   Regular School No Middle 05 08 2018   grade_6                         1.0 0.0                       1.0                         1 0                 1
1791074 1791074 IN     school 1807440 3445   New Castle Community School Corp 180744001289 2853 Sunnyside Elementary School   Regular School No Elementary KG 06 2018   grade_6                         0.0 1.0                       1.0                         0 1                 1
1791155 1791155 IN     school 1803150 3480   Eastern Howard School Corporation 180315000412 2909 Eastern Elementary School   Regular School No Elementary PK 07 2018   grade_6                         0.0 1.0                       1.0                         0 1                 1
1791183 1791183 IN     school 1804470 3490   Western School Corporation 180447002224 2923 Western Intermediate School   Regular School No Middle 03 08 2018   grade_6                         1.0 0.0                       1.0                         1 0                 1
1792106 1792106 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No High 06 12 2018   grade_6                         1.0 0.0                       1.0                         1 0                 1
1792125 1792125 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No Elementary PK 06 2018   grade_6                         1.0 0.0                       1.0                         1 0                 1
1793533 1793533 IN     school 1805670 5330   M S D Lawrence Township 180567000139 5291 Fall Creek Valley Middle School   Regular School No Middle 06 08 2018   grade_6                         0.0 1.0                       1.0                         0 1                 1
1795156 1795156 IN     school 1806510 5925   M S D Martinsville Schools 180651002355 6344 South Elementary School   Regular School No Elementary PK 06 2018   grade_6                         0.0 1.0                       1.0                         0 1                 1
1796823 1796823 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other 02 12 2018   grade_6                         0.0 1.0                       1.0                         0 1                 1
1796895 1796895 IN     school 1808010 7385   North Spencer County Sch Corp 180801001898 7761 Heritage Hills Middle School   Regular School No Middle 06 09 2018   grade_6                         1.0 0.0                       1.0                         1 0                 1
1797873 1797873 IN     school 1812180 8050   M S D Wabash County Schools 181218001945 8651 Northfield Jr-Sr High School   Regular School No High 06 12 2018   grade_6                         0.0 1.0                       1.0                         0 1                 1
1797468 1797468 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2018   grade_6                         8.0 2.0                       10.0                         8 2                 10
1787311 1787311 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 05 08 2018   grade_6                         49.0 51.0                       100.0                         49 51                 100
1790555 1790555 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071001760 2564 New Palestine Elementary School   Regular School No Elementary PK 06 2018   grade_6                         55.0 45.0                       100.0                         55 45                 100
1791871 1791871 IN     school 1807830 4315   North Knox School Corp 180783001335 3545 North Knox Intermediate   Regular School No Elementary 03 06 2018   grade_6                         52.0 48.0                       100.0                         52 48                 100
1795737 1795737 IN     school 1811700 6530   Union Township School Corp 181170000793 6843 Union Township Middle School   Regular School No Middle 06 08 2018   grade_6                         54.0 46.0                       100.0                         54 46                 100
1796796 1796796 IN     school 1808310 7350   Northwestern Con School Corp 180831001425 7697 Triton Central Middle School   Regular School No Middle 05 08 2018   grade_6                         55.0 45.0                       100.0                         55 45                 100
1791031 1791031 IN     school 1808280 3435   Shenandoah School Corporation 180828001421 2819 Shenandoah Middle School   Regular School No Middle 06 08 2018   grade_6                         49.0 52.0                       101.0                         49 52                 101
1787287 1787287 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2018   grade_6                         51.0 51.0                       102.0                         51 51                 102
1791136 1791136 IN     school 1802040 3470   Northwestern School Corp 180204000254 2904 Northwestern Elementary School   Regular School No Elementary KG 06 2018   grade_6                         66.0 36.0                       102.0                         66 36                 102
1795509 1795509 IN     school 1801740 6325   Perry Central Com Schools Corp 180174000232 6705 Perry Central Elementary School   Regular School No Elementary PK 06 2018   grade_6                         59.0 43.0                       102.0                         59 43                 102
1796545 1796545 IN     school 1810290 7205   South Bend Community School Corp 181029002296 7521 Brown Intermediate Center   Regular School No Middle 04 08 2018   grade_6                         64.0 38.0                       102.0                         64 38                 102
1788218 1788218 IN     school 1802700 755   Delphi Community School Corp 180270000327 609 Delphi Community Middle School   Regular School No Middle 06 08 2018   grade_6                         51.0 52.0                       103.0                         51 52                 103
1791583 1791583 IN     school 1810800 4000   Southwestern-Jefferson Co Con 181080002547 3343 Southwestern Middle School   Regular School No Middle 06 08 2018   grade_6                         54.0 49.0                       103.0                         54 49                 103
1793401 1793401 IN     school 1802640 5300   M S D Decatur Township 180264002271 5187 Valley Mills Elementary School   Regular School No Elementary 01 06 2018   grade_6                         60.0 43.0                       103.0                         60 43                 103
1795420 1795420 IN     school 1808640 6155   Paoli Community School Corp 180864001439 6587 Throop Elementary School   Regular School No Elementary KG 06 2018   grade_6                         53.0 50.0                       103.0                         53 50                 103
1788046 1788046 IN     school 1800570 515   Blackford County Schools 180057000108 494 North Side Elementary School   Regular School No Middle 04 06 2018   grade_6                         51.0 53.0                       104.0                         51 53                 104
1796622 1796622 IN     school 1810290 7205   South Bend Community School Corp 181029001666 7581 Marshall Intermediate Center   Regular School No Middle 05 08 2018   grade_6                         52.0 52.0                       104.0                         52 52                 104
1798094 1798094 IN     school 1803000 8215   East Washington School Corp 180300000073 8906 East Washington Middle School   Regular School No Middle 05 08 2018   grade_6                         55.0 49.0                       104.0                         55 49                 104
1789841 1789841 IN     school 1803700 2475   Franklin County Community Sch Corp 180370000589 2123 Franklin County Middle School   Regular School No Middle 06 08 2018   grade_6                         51.0 54.0                       105.0                         51 54                 105
1797265 1797265 IN     school 1811340 7865   Tippecanoe School Corp 181134001833 8026 Wainwright Middle School   Regular School No Middle 06 08 2018   grade_6                         65.0 40.0                       105.0                         65 40                 105
1792092 1792092 IN     school 1809300 4515   Prairie Heights Community Sch Corp 180930001525 3688 Prairie Heights Middle School   Regular School No Middle 05 08 2018   grade_6                         64.0 42.0                       106.0                         64 42                 106
1793359 1793359 IN     school 1803300 5280   Elwood Community School Corp 180330002309 5151 Elwood Intermediate School   Regular School No Elementary 03 06 2018   grade_6                         52.0 54.0                       106.0                         52 54                 106
1796081 1796081 IN     school 1811730 6795   Union School Corporation 181173001874 7117 Union Elementary School   Regular School No Elementary KG 06 2018   grade_6                         39.0 67.0                       106.0                         39 67                 106
1796502 1796502 IN     school 1810290 7205   South Bend Community School Corp 181029001650 7425 Clay International Academy   Regular School No Middle 05 08 2018   grade_6                         61.0 45.0                       106.0                         61 45                 106
1793413 1793413 IN     school 1802640 5300   M S D Decatur Township 180264000317 5189 West Newton Elementary School   Regular School No Elementary 01 06 2018   grade_6                         49.0 58.0                       107.0                         49 58                 107
1795722 1795722 IN     school 1809180 6520   Porter Township School Corp 180918000523 6839 Boone Grove Middle School   Regular School No Middle 06 08 2018   grade_6                         58.0 49.0                       107.0                         58 49                 107
1797096 1797096 IN     school 1810860 7715   Southwest School Corporation 181086002359 7961 Sullivan Middle School   Regular School No Middle 06 08 2018   grade_6                         56.0 51.0                       107.0                         56 51                 107
1793951 1793951 IN     school 1812810 5375   M S D Wayne Township 181281002033 5241 Garden City Elementary School   Regular School No Elementary PK 06 2018   grade_6                         46.0 62.0                       108.0                         46 62                 108
1795290 1795290 IN     school 1801710 6055   Central Noble Com School Corp 180171000230 6453 Central Noble Junior Senior HS   Regular School No High 06 12 2018   grade_6                         52.0 56.0                       108.0                         52 56                 108
1796524 1796524 IN     school 1810290 7205   South Bend Community School Corp 181029001645 7510 Jackson Middle School   Regular School No Middle 05 08 2018   grade_6                         52.0 56.0                       108.0                         52 56                 108
1799265 1799265 IN     school 1800164 9965   Career Academy Middle School 180016402593 7563 Career Academy Middle School   Regular School Yes Middle 06 08 2018   grade_6                         62.0 46.0                       108.0                         62 46                 108
1793377 1793377 IN     school 1802640 5300   M S D Decatur Township 180264002111 5178 Gold Academy   Regular School No Elementary 01 06 2018   grade_6                         51.0 58.0                       109.0                         51 58                 109
1793993 1793993 IN     school 1812810 5375   M S D Wayne Township 181281002040 5270 Stout Field Elementary School   Regular School No Elementary PK 06 2018   grade_6                         54.0 55.0                       109.0                         54 55                 109
1794994 1794994 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000138 6226 University Elementary School   Regular School No Elementary PK 06 2018   grade_6                         56.0 53.0                       109.0                         56 53                 109
1796025 1796025 IN     school 1807980 6715   North Putnam Community Schools 180798000316 7049 North Putnam Middle School   Regular School No Middle 06 08 2018   grade_6                         44.0 65.0                       109.0                         44 65                 109
1793290 1793290 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Middle 06 09 2018   grade_6                         8.0 3.0                       11.0                         8 3                 11
1799196 1799196 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other KG 12 2018   grade_6                         10.0 1.0                       11.0                         10 1                 11
1788256 1788256 IN     school 1810680 815   Lewis Cass Schools 181068002625 691 Lewis Cass Junior High School   Regular School No Middle 06 08 2018   grade_6                         55.0 55.0                       110.0                         55 55                 110
1788608 1788608 IN     school 1802160 1160   Clinton Prairie School Corporation 180216002245 981 Clinton Prairie Elementary School   Regular School No Elementary PK 06 2018   grade_6                         50.0 60.0                       110.0                         50 60                 110
1789535 1789535 IN     school 1803270 2305   Elkhart Community Schools 180327000441 1785 Pinewood Elementary School   Regular School No Elementary KG 06 2018   grade_6                         54.0 56.0                       110.0                         54 56                 110
1792068 1792068 IN     school 1813230 4455   Whitko Community School Corp 181323000068 3644 Whitko Middle School   Regular School No Middle 06 08 2018   grade_6                         62.0 48.0                       110.0                         62 48                 110
1795548 1795548 IN     school 1811260 6350   Tell City-Troy Twp School Corp 181126001282 6745 William Tell Elementary School   Regular School No Elementary KG 06 2018   grade_6                         50.0 60.0                       110.0                         50 60                 110
1787900 1787900 IN     school 1800360 365   Bartholomew Con School Corp 180036000077 357 Parkside Elementary School   Regular School No Elementary PK 06 2018   grade_6                         55.0 56.0                       111.0                         55 56                 111
1793228 1793228 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002418 5012 Lapel Middle School   Regular School No Middle 06 08 2018   grade_6                         67.0 44.0                       111.0                         67 44                 111
1793960 1793960 IN     school 1812810 5375   M S D Wayne Township 181281002035 5257 McClelland Elementary School   Regular School No Elementary KG 06 2018   grade_6                         55.0 56.0                       111.0                         55 56                 111
1796127 1796127 IN     school 1801770 6825   Randolph Central School Corp 180177000235 7129 Lee L Driver Middle School   Regular School No Middle 06 08 2018   grade_6                         58.0 53.0                       111.0                         58 53                 111
1796560 1796560 IN     school 1810290 7205   South Bend Community School Corp 181029001681 7537 Edison Middle School   Regular School No Middle 05 08 2018   grade_6                         64.0 47.0                       111.0                         64 47                 111
1791641 1791641 IN     school 1805190 4015   Jennings County School Corporation 180519000924 3397 North Vernon Elementary School   Regular School No Elementary KG 06 2018   grade_6                         62.0 50.0                       112.0                         62 50                 112
1794016 1794016 IN     school 1812810 5375   M S D Wayne Township 181281002042 5273 Westlake Elementary School   Regular School No Elementary KG 06 2018   grade_6                         62.0 50.0                       112.0                         62 50                 112
1793384 1793384 IN     school 1802640 5300   M S D Decatur Township 180264002112 5179 Blue Academy   Regular School No Elementary 01 06 2018   grade_6                         58.0 56.0                       114.0                         58 56                 114
1793968 1793968 IN     school 1812810 5375   M S D Wayne Township 181281002036 5261 Rhoades Elementary School   Regular School No Elementary PK 06 2018   grade_6                         55.0 59.0                       114.0                         55 59                 114
1795013 1795013 IN     school 1807900 5835   North Montgomery Com Sch Corp 180790002293 6244 Northridge Middle School   Regular School No Middle 06 08 2018   grade_6                         63.0 51.0                       114.0                         63 51                 114
1787963 1787963 IN     school 1800360 365   Bartholomew Con School Corp 180036000080 392 Southside Elementary School   Regular School No Elementary PK 06 2018   grade_6                         66.0 49.0                       115.0                         66 49                 115
1794647 1794647 IN     school 1800900 5480   Bremen Public Schools 180090000166 5943 Bremen Elementary/Middle School   Regular School No Elementary KG 08 2018   grade_6                         56.0 59.0                       115.0                         56 59                 115
1797867 1797867 IN     school 1806270 8045   Manchester Community Schools 180627001102 8645 Manchester Intermediate School   Regular School No Middle 04 06 2018   grade_6                         57.0 58.0                       115.0                         57 58                 115
1792203 1792203 IN     school 1804620 4590   River Forest Community Sch Corp 180462000780 3801 River Forest Middle School   Regular School No Middle 06 08 2018   grade_6                         60.0 57.0                       117.0                         60 57                 117
1793977 1793977 IN     school 1812810 5375   M S D Wayne Township 181281002037 5265 Robey Elementary School   Regular School No Elementary KG 06 2018   grade_6                         65.0 52.0                       117.0                         65 52                 117
1793507 1793507 IN     school 1805670 5330   M S D Lawrence Township 180567001032 5283 Mary Evelyn Castle Elementary Sch   Regular School No Elementary 01 06 2018   grade_6                         63.0 55.0                       118.0                         63 55                 118
1790573 1790573 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071001407 2567 Sugar Creek Elementary Sch   Regular School No Elementary KG 06 2018   grade_6                         69.0 50.0                       119.0                         69 50                 119
1793500 1793500 IN     school 1805670 5330   M S D Lawrence Township 180567001024 5281 Brook Park Elementary School   Regular School No Elementary 01 06 2018   grade_6                         65.0 54.0                       119.0                         65 54                 119
1794037 1794037 IN     school 1812810 5375   M S D Wayne Township 181281002123 5446 Bridgeport Elementary School   Regular School No Elementary KG 06 2018   grade_6                         54.0 65.0                       119.0                         54 65                 119
1793985 1793985 IN     school 1812810 5375   M S D Wayne Township 181281000238 5267 North Wayne Elementary School   Regular School No Elementary KG 06 2018   grade_6                         68.0 52.0                       120.0                         68 52                 120
1793245 1793245 IN     school 1810440 5255   South Madison Com Sch Corp 181044002167 4935 East Elementary School   Regular School No Elementary KG 06 2018   grade_6                         68.0 53.0                       121.0                         68 53                 121
1794024 1794024 IN     school 1812810 5375   M S D Wayne Township 181281002031 5274 Chapelwood Elementary School   Regular School No Elementary KG 06 2018   grade_6                         69.0 52.0                       121.0                         69 52                 121
1797366 1797366 IN     school 1811610 7950   Union Co/Clg Corner Joint Sch Dist 181161001868 8206 Union County Middle School   Regular School No Middle 06 08 2018   grade_6                         68.0 53.0                       121.0                         68 53                 121
1793564 1793564 IN     school 1805670 5330   M S D Lawrence Township 180567001033 5296 Oaklandon Elementary School   Regular School No Elementary 01 06 2018   grade_6                         67.0 56.0                       123.0                         67 56                 123
1797700 1797700 IN     school 1812090 8030   Vigo County School Corp 181209001915 8481 Sarah Scott Middle School   Regular School No Middle 06 08 2018   grade_6                         60.0 63.0                       123.0                         60 63                 123
1788675 1788675 IN     school 1802440 1300   Crawford County Community Sch Corp 180244000282 1061 Crawford County Middle School   Regular School No Middle 06 08 2018   grade_6                         65.0 59.0                       124.0                         65 59                 124
1791468 1791468 IN     school 1809420 3815   Rensselaer Central School Corp 180942001544 3221 Rensselaer Middle School   Regular School No Middle 06 08 2018   grade_6                         66.0 58.0                       124.0                         66 58                 124
1793283 1793283 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No Elementary 03 06 2018   grade_6                         74.0 50.0                       124.0                         74 50                 124
1791229 1791229 IN     school 1805370 3500   Kokomo School Corporation 180537001018 2963 Maple Crest Middle School   Regular School No Middle 06 08 2018   grade_6                         65.0 60.0                       125.0                         65 60                 125
1793542 1793542 IN     school 1805670 5330   M S D Lawrence Township 180567002278 5293 Indian Creek Elementary School   Regular School No Elementary 01 06 2018   grade_6                         66.0 59.0                       125.0                         66 59                 125
1793557 1793557 IN     school 1805670 5330   M S D Lawrence Township 180567002114 5295 Winding Ridge Elementary School   Regular School No Elementary 01 06 2018   grade_6                         59.0 66.0                       125.0                         59 66                 125
1797919 1797919 IN     school 1812150 8060   Wabash City Schools 181215002301 8694 Wabash Middle School   Regular School No Middle 05 08 2018   grade_6                         73.0 52.0                       125.0                         73 52                 125
1797352 1797352 IN     school 1811400 7945   Tipton Community School Corp 181140001842 8167 Tipton Middle School   Regular School No Middle 06 08 2018   grade_6                         56.0 70.0                       126.0                         56 70                 126
1793198 1793198 IN     school 1806900 5085   Mitchell Community Schools 180690002151 4924 Mitchell Jr High School   Regular School No Middle 06 08 2018   grade_6                         67.0 60.0                       127.0                         67 60                 127
1790977 1790977 IN     school 1806660 3335   Mill Creek Community Sch Corp 180666001170 2687 Cascade Middle School   Regular School No Middle 06 08 2018   grade_6                         79.0 49.0                       128.0                         79 49                 128
1798301 1798301 IN     school 1800720 8445   M S D Bluffton-Harrison 180072000147 9093 Bluffton-Harrison Middle School   Regular School No Middle 05 08 2018   grade_6                         64.0 64.0                       128.0                         64 64                 128
1789308 1789308 IN     school 1800420 2260   Baugo Community Schools 180042002026 1707 Jimtown Intermediate School   Regular School No Elementary 03 06 2018   grade_6                         62.0 67.0                       129.0                         62 67                 129
1798944 1798944 IN     school 1800167 9710   Carpe Diem - Northwest 180016702579 5977 Carpe Diem - Northwest   Regular School Yes High 06 12 2018   grade_6                         6.0 7.0                       13.0                         6 7                 13
1790132 1790132 IN     school 1805910 2950   Linton-Stockton School Corporation 180591002147 2438 Linton-Stockton Middle School   Regular School No Middle 06 08 2018   grade_6                         72.0 58.0                       130.0                         72 58                 130
1791387 1791387 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105000181 3107 Brownstown Central Middle School   Regular School No Middle 06 08 2018   grade_6                         72.0 58.0                       130.0                         72 58                 130
1792056 1792056 IN     school 1811370 4445   Tippecanoe Valley School Corp 181137000397 3619 Tippecanoe Valley Middle School   Regular School No Middle 06 08 2018   grade_6                         65.0 65.0                       130.0                         65 65                 130
1797661 1797661 IN     school 1810590 8020   South Vermillion Com Sch Corp 181059001740 8434 South Vermillion Middle School   Regular School No Middle 06 08 2018   grade_6                         63.0 68.0                       131.0                         63 68                 131
1788936 1788936 IN     school 1803840 1820   Garrett-Keyser-Butler Com Sch Corp 180384001389 1331 Garrett Middle School   Regular School No Middle 06 08 2018   grade_6                         68.0 65.0                       133.0                         68 65                 133
1789867 1789867 IN     school 1809630 2645   Rochester Community School Corp 180963001577 2177 Rochester Community Middle School   Regular School No Middle 06 08 2018   grade_6                         70.0 63.0                       133.0                         70 63                 133

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