enrollments

Data source: Big Local News · About: Big Local

3,528 rows where grade = "grade_8" and state = "IN" sorted by ccd_school_low_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_8 · 3,528 ✖
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
1166240 1166240 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_8                         6.0 0.0                       6.0                         6 0                 6
1287642 1287642 IN     school   5375   M S D Wayne Township   5271 Sanders School             2016   grade_8                         12.0 1.0                       13.0                         12 1                 13
1299679 1299679 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_8                         6.0 1.0                       7.0                         6 1                 7
1758217 1758217 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_8                         5.0 1.0                       6.0                         5 1                 6
1794007 1794007 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_8                         7.0 1.0                       8.0                         7 1                 8
1908012 1908012 IN     school   940   West Clark Community Schools   765 Henryville Jr & Sr High School             2020   grade_8                         49.0 41.0                       90.0                         49 41                 90
1908032 1908032 IN     school   940   West Clark Community Schools   781 Silver Creek Middle School             2020   grade_8                         125.0 126.0                       251.0                         125 126                 251
1908044 1908044 IN     school   940   West Clark Community Schools   813 William W Borden High School             2020   grade_8                         31.0 27.0                       58.0                         31 27                 58
1909788 1909788 IN     school   2865   Marion Community Schools   2416 Grant County Comm Justice Center             2020   grade_8                         1.0 0.0                       1.0                         1 0                 1
1913645 1913645 IN     school   5375   M S D Wayne Township   5271 Sanders School             2020   grade_8                         2.0 2.0                       4.0                         2 2                 4
1925551 1925551 IN     school   5375   MSD Wayne Township   5271 Sanders School             2021   grade_8                         6.0 1.0                       7.0                         6 1                 7
1927141 1927141 IN     school   6510   East Porter County School Corp   6811 Porter County Education Services             2021   grade_8                         1.0 0.0                       1.0                         1 0                 1
1927249 1927249 IN     school   6550   Portage Township Schools   6811 Porter County Education Services             2021   grade_8                         4.0 2.0                       6.0                         4 2                 6
1159673 1159673 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No 1.0 01 08 2015   grade_8                         35.0 41.0                       76.0                         35 41                 76
1281030 1281030 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative Education School No 4.0 01 10 2016   grade_8                         1.0 1.0                       2.0                         1 1                 2
1281065 1281065 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No 1.0 01 08 2016   grade_8                         34.0 38.0                       72.0                         34 38                 72
1283101 1283101 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No 4.0 01 12 2016   grade_8                         8.0 3.0                       11.0                         8 3                 11
1291125 1291125 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345002462 8270 Academy for Innovative Studies   Regular School No 4.0 01 12 2016   grade_8                         31.0 21.0                       52.0                         31 21                 52
1293126 1293126 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2017   grade_8                         37.0 45.0                       82.0                         37 45                 82
1295139 1295139 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2017   grade_8                         10.0 7.0                       17.0                         10 7                 17
1303930 1303930 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other 01 12 2017   grade_8                         8.0 4.0                       12.0                         8 4                 12
1751751 1751751 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2019   grade_8                         43.0 42.0                       85.0                         43 42                 85
1761665 1761665 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2019   grade_8                         36.0 16.0                       52.0                         36 16                 52
1761676 1761676 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002649 8271 Harwood Career Prep High School   Regular School No Other 01 12 2019   grade_8                         2.0 1.0                       3.0                         2 1                 3
1787495 1787495 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2018   grade_8                         39.0 38.0                       77.0                         39 38                 77
1789484 1789484 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2018   grade_8                         8.0 8.0                       16.0                         8 8                 16
1797470 1797470 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2018   grade_8                         25.0 13.0                       38.0                         25 13                 38
1907191 1907191 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2020   grade_8                         42.0 43.0                       85.0                         42 43                 85
1916420 1916420 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other 01 12 2020   grade_8                         0.0 2.0                       2.0                         0 2                 2
1917071 1917071 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2020   grade_8                         26.0 19.0                       45.0                         26 19                 45
1918846 1918846 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other 01 12 2020   grade_8                         15.0 8.0                       23.0                         15 8                 23
1919157 1919157 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2021   grade_8                         41.0 32.0                       73.0                         41 32                 73
1921143 1921143 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2021   grade_8                         4.0 0.0                       4.0                         4 0                 4
1928013 1928013 IN     school 1810290 7205   South Bend Community School Corp 181029002699 7248 South Bend Virtual School   Regular School No Other 01 12 2021   grade_8                         3.0 3.0                       6.0                         3 3                 6
1929816 1929816 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other 01 12 2021   grade_8                         9.0 6.0                       15.0                         9 6                 15
1166588 1166588 IN     school 1804770 5385   Indianapolis Public Schools 180477002439 5577 Merle Sidener Gifted Academy   Regular School No 1.0 02 08 2015   grade_8                         20.0 24.0                       44.0                         20 24                 44
1284793 1284793 IN     school 1804470 3490   Western School Corp 180447002224 2923 Western Intermediate School   Regular School No 1.0 02 08 2016   grade_8                         0.0 1.0                       1.0                         0 1                 1
1287998 1287998 IN     school 1804770 5385   Indianapolis Public Schools 180477002439 5577 Merle Sidener Gifted Academy   Regular School No 1.0 02 08 2016   grade_8                         23.0 30.0                       53.0                         23 30                 53
1290485 1290485 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No 4.0 02 12 2016   grade_8                         0.0 2.0                       2.0                         0 2                 2
1292634 1292634 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes 4.0 02 12 2016   grade_8                         11.0 0.0                       11.0                         11 0                 11
1294815 1294815 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 02 12 2017   grade_8                         12.0 10.0                       22.0                         12 10                 22
1300026 1300026 IN     school 1804770 5385   Indianapolis Public Schools 180477002439 5577 Merle Sidener Gifted Academy   Regular School No Elementary 02 08 2017   grade_8                         30.0 24.0                       54.0                         30 24                 54
1753744 1753744 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 02 12 2019   grade_8                         19.0 3.0                       22.0                         19 3                 22
1758527 1758527 IN     school 1804770 5385   Indianapolis Public Schools 180477002439 5577 Merle Sidener Gifted Academy   Regular School No Middle 02 08 2019   grade_8                         27.0 31.0                       58.0                         27 31                 58
1794339 1794339 IN     school 1804770 5385   Indianapolis Public Schools 180477002439 5577 Merle Sidener Gifted Academy   Regular School No Middle 02 08 2018   grade_8                         30.0 26.0                       56.0                         30 26                 56
1796825 1796825 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other 02 12 2018   grade_8                         0.0 2.0                       2.0                         0 2                 2
1908004 1908004 IN     school 1806030 875   Logansport Community Sch Corp 180603001052 715 Columbia 6th Grade Academy   Regular School No Other 02 09 2020   grade_8                         1.0 0.0                       1.0                         1 0                 1
1913954 1913954 IN     school 1804770 5385   Indianapolis Public Schools 180477002439 5577 Merle Sidener Gifted Academy   Regular School No Middle 02 08 2020   grade_8                         34.0 23.0                       57.0                         34 23                 57
1917081 1917081 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002649 8271 Harwood Career Prep High School   Regular School No Other 02 12 2020   grade_8                         1.0 4.0                       5.0                         1 4                 5
1925848 1925848 IN     school 1804770 5385   Indianapolis Public Schools 180477002439 5577 Merle Sidener Gifted Academy   Regular School No Middle 02 08 2021   grade_8                         32.0 27.0                       59.0                         32 27                 59
1929001 1929001 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 02 12 2021   grade_8                         20.0 9.0                       29.0                         20 9                 29
1930091 1930091 IN     school 1800222 9000   Phalen Virtual Leadership Academy 180022202707 9992 Phalen Virtual Leadership Academy   Regular School Yes Other 02 12 2021   grade_8                         2.0 1.0                       3.0                         2 1                 3
1160264 1160264 IN     school 1802830 630   Zionsville Community Schools 180283002046 510 Zionsville West Middle School   Regular School No 1.0 03 08 2015   grade_8                         119.0 97.0                       216.0                         119 97                 216
1161376 1161376 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative Education School No 4.0 03 12 2015   grade_8                         14.0 4.0                       18.0                         14 4                 18
1168692 1168692 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Joint Service Campus Program   Special Education School No 4.0 03 12 2015   grade_8                         13.0 3.0                       16.0                         13 3                 16
1168815 1168815 IN     school 1810290 7205   South Bend Community Sch Corp 181029002296 7521 Brown Intermediate Center   Regular School No 1.0 03 08 2015   grade_8                         50.0 33.0                       83.0                         50 33                 83
1171265 1171265 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes 4.0 03 11 2015   grade_8                         11.0 0.0                       11.0                         11 0                 11
1282779 1282779 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative Education School No 4.0 03 12 2016   grade_8                         12.0 6.0                       18.0                         12 6                 18
1284528 1284528 IN     school 1802550 3325   Danville Community School Corp 180255000305 2743 Danville Middle School   Regular School No 1.0 03 08 2016   grade_8                         116.0 108.0                       224.0                         116 108                 224
1296827 1296827 IN     school 1804470 3490   Western School Corporation 180447002224 2923 Western Intermediate School   Regular School No Elementary 03 08 2017   grade_8                         0.0 1.0                       1.0                         0 1                 1
1302109 1302109 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Oaklawn Campus Program   Special Education School No Other 03 12 2017   grade_8                         4.0 2.0                       6.0                         4 2                 6
1302234 1302234 IN     school 1810290 7205   South Bend Community School Corp 181029002296 7521 Brown Intermediate Center   Regular School No Elementary 03 08 2017   grade_8                         54.0 43.0                       97.0                         54 43                 97
1755444 1755444 IN     school 1804470 3490   Western School Corporation 180447002224 2923 Western Intermediate School   Regular School No Middle 03 08 2019   grade_8                         1.0 1.0                       2.0                         1 1                 2
1758282 1758282 IN     school 1804770 5385   Indianapolis Public Schools 180477002651 108 Impact Academy   Regular School No Other 03 12 2019   grade_8                         21.0 8.0                       29.0                         21 8                 29
1789159 1789159 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 03 12 2018   grade_8                         10.0 1.0                       11.0                         10 1                 11
1791185 1791185 IN     school 1804470 3490   Western School Corporation 180447002224 2923 Western Intermediate School   Regular School No Middle 03 08 2018   grade_8                         0.0 1.0                       1.0                         0 1                 1
1791546 1791546 IN     school 1806120 3995   Madison Consolidated Schools 180612001091 3313 Madison Consolidated Jr High Sch   Regular School No Middle 03 08 2018   grade_8                         124.0 109.0                       233.0                         124 109                 233
1796426 1796426 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Oaklawn Campus Program   Special Education School No Other 03 12 2018   grade_8                         7.0 4.0                       11.0                         7 4                 11
1910890 1910890 IN     school 1804470 3490   Western School Corporation 180447002224 2923 Western Intermediate School   Regular School No Middle 03 08 2020   grade_8                         1.0 0.0                       1.0                         1 0                 1
1913712 1913712 IN     school 1804770 5385   Indianapolis Public Schools 180477002651 108 Impact Academy   Regular School No Other 03 12 2020   grade_8                         15.0 11.0                       26.0                         15 11                 26
1919971 1919971 IN     school 1806030 875   Logansport Community Sch Corp 180603001052 715 Columbia 6th Grade Academy   Regular School No Other 03 12 2021   grade_8                         3.0 1.0                       4.0                         3 1                 4
1922849 1922849 IN     school 1804470 3490   Western School Corporation 180447002224 2923 Western Intermediate School   Regular School No Middle 03 08 2021   grade_8                         1.0 1.0                       2.0                         1 1                 2
1925616 1925616 IN     school 1804770 5385   Indianapolis Public Schools 180477002651 108 Impact Academy   Regular School No Other 03 12 2021   grade_8                         10.0 13.0                       23.0                         10 13                 23
1160684 1160684 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 04 12 2015   grade_8                         8.0 0.0                       8.0                         8 0                 8
1161577 1161577 IN     school 1806600 2275   Middlebury Community Schools 180660001162 1657 Northridge Middle School   Regular School No 2.0 04 09 2015   grade_8                         172.0 186.0                       358.0                         172 186                 358
1163121 1163121 IN     school 1802550 3325   Danville Community School Corp 180255000305 2743 Danville Middle School   Regular School No 2.0 04 08 2015   grade_8                         120.0 97.0                       217.0                         120 97                 217
1163304 1163304 IN     school 1801060 3455   C A Beard Memorial School Corp 180106002012 2870 Knightstown Intermediate School   Regular School No 2.0 04 08 2015   grade_8                         54.0 48.0                       102.0                         54 48                 102
1163378 1163378 IN     school 1804470 3490   Western School Corp 180447000756 2921 Western High School   Regular School No 4.0 04 12 2015   grade_8                         3.0 0.0                       3.0                         3 0                 3
1167063 1167063 IN     school 1808850 5635   Peru Community Schools 180885001477 6089 Peru Junior High School   Regular School No 2.0 04 09 2015   grade_8                         98.0 71.0                       169.0                         98 71                 169
1281658 1281658 IN     school 1802830 630   Zionsville Community Schools 180283002046 510 Zionsville West Middle School   Regular School No 2.0 04 08 2016   grade_8                         129.0 92.0                       221.0                         129 92                 221
1284711 1284711 IN     school 1801060 3455   C A Beard Memorial School Corp 180106002012 2870 Knightstown Intermediate School   Regular School No 2.0 04 08 2016   grade_8                         63.0 33.0                       96.0                         63 33                 96
1288460 1288460 IN     school 1808850 5635   Peru Community Schools 180885001477 6089 Peru Junior High School   Regular School No 2.0 04 09 2016   grade_8                         91.0 67.0                       158.0                         91 67                 158
1290083 1290083 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Joint Service Campus Program   Special Education School No 4.0 04 12 2016   grade_8                         9.0 2.0                       11.0                         9 2                 11
1290205 1290205 IN     school 1810290 7205   South Bend Community Sch Corp 181029002296 7521 Brown Intermediate Center   Regular School No 2.0 04 08 2016   grade_8                         30.0 43.0                       73.0                         30 43                 73
1294144 1294144 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No Other 04 12 2017   grade_8                         6.0 0.0                       6.0                         6 0                 6
1296564 1296564 IN     school 1802550 3325   Danville Community School Corp 180255000305 2743 Danville Middle School   Regular School No Elementary 04 08 2017   grade_8                         93.0 90.0                       183.0                         93 90                 183
1296746 1296746 IN     school 1801060 3455   C A Beard Memorial School Corp 180106002012 2870 Knightstown Intermediate School   Regular School No Elementary 04 08 2017   grade_8                         50.0 41.0                       91.0                         50 41                 91
1300490 1300490 IN     school 1808850 5635   Peru Community Schools 180885001477 6089 Peru Junior High School   Regular School No Elementary 04 08 2017   grade_8                         79.0 82.0                       161.0                         79 82                 161
1304672 1304672 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes Other 04 12 2017   grade_8                         7.0 0.0                       7.0                         7 0                 7
1752566 1752566 IN     school 1806030 875   Logansport Community Sch Corp 180603001052 715 Columbia 6th Grade Academy   Regular School No Middle 04 08 2019   grade_8                         2.0 2.0                       4.0                         2 2                 4
1753419 1753419 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 04 12 2019   grade_8                         10.0 8.0                       18.0                         10 8                 18
1755178 1755178 IN     school 1802550 3325   Danville Community School Corp 180255000305 2743 Danville Middle School   Regular School No Other 04 09 2019   grade_8                         96.0 81.0                       177.0                         96 81                 177
1755361 1755361 IN     school 1801060 3455   C A Beard Memorial School Corp 180106002012 2870 Knightstown Intermediate School   Regular School No Middle 04 08 2019   grade_8                         52.0 43.0                       95.0                         52 43                 95
1760617 1760617 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Oaklawn Campus Program   Special Education School No Other 04 12 2019   grade_8                         5.0 3.0                       8.0                         5 3                 8
1763251 1763251 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes Other 04 12 2019   grade_8                         17.0 0.0                       17.0                         17 0                 17
1789358 1789358 IN     school 1806600 2275   Middlebury Community Schools 180660001162 1657 Northridge Middle School   Regular School No Other 04 11 2018   grade_8                         170.0 193.0                       363.0                         170 193                 363
1790917 1790917 IN     school 1802550 3325   Danville Community School Corp 180255000305 2743 Danville Middle School   Regular School No Middle 04 08 2018   grade_8                         107.0 81.0                       188.0                         107 81                 188
1791101 1791101 IN     school 1801060 3455   C A Beard Memorial School Corp 180106002012 2870 Knightstown Intermediate School   Regular School No Middle 04 08 2018   grade_8                         46.0 32.0                       78.0                         46 32                 78
1796547 1796547 IN     school 1810290 7205   South Bend Community School Corp 181029002296 7521 Brown Intermediate Center   Regular School No Middle 04 08 2018   grade_8                         48.0 24.0                       72.0                         48 24                 72
1798997 1798997 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes Other 04 12 2018   grade_8                         6.0 0.0                       6.0                         6 0                 6

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