enrollments

Data source: Big Local News · About: Big Local

4,822 rows where grade = "grade_6" and state = "IN" sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_6 · 4,822 ✖
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
1171012 1171012 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes 4.0 KG 12 2015   grade_6                         36.0 26.0                       62.0                         36 26                 62
1292389 1292389 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes 4.0 KG 12 2016   grade_6                         36.0 24.0                       60.0                         36 24                 60
1304422 1304422 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2017   grade_6                         31.0 28.0                       59.0                         31 28                 59
1763033 1763033 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2019   grade_6                         27.0 30.0                       57.0                         27 30                 57
1798763 1798763 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2018   grade_6                         34.0 25.0                       59.0                         34 25                 59
1918502 1918502 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2020   grade_6                         53.0 49.0                       102.0                         53 49                 102
1930497 1930497 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2021   grade_6                         47.0 52.0                       99.0                         47 52                 99
1286053 1286053 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No 1.0 PK 06 2016   grade_6                         24.0 25.0                       49.0                         24 25                 49
1298099 1298099 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary PK 06 2017   grade_6                         33.0 8.0                       41.0                         33 8                 41
1756687 1756687 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary KG 06 2019   grade_6                         21.0 18.0                       39.0                         21 18                 39
1792451 1792451 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary KG 07 2018   grade_6                         27.0 18.0                       45.0                         27 18                 45
1912127 1912127 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary KG 06 2020   grade_6                         21.0 19.0                       40.0                         21 19                 40
1924096 1924096 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary KG 06 2021   grade_6                         30.0 13.0                       43.0                         30 13                 43
1169733 1169733 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345002462 8270 Academy for Innovative Studies   Regular School No 4.0 KG 12 2015   grade_6                         6.0 2.0                       8.0                         6 2                 8
1291123 1291123 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345002462 8270 Academy for Innovative Studies   Regular School No 4.0 01 12 2016   grade_6                         10.0 0.0                       10.0                         10 0                 10
1303152 1303152 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other KG 12 2017   grade_6                         9.0 2.0                       11.0                         9 2                 11
1761663 1761663 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2019   grade_6                         7.0 0.0                       7.0                         7 0                 7
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
1917069 1917069 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2020   grade_6                         17.0 2.0                       19.0                         17 2                 19
1928999 1928999 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 02 12 2021   grade_6                         6.0 2.0                       8.0                         6 2                 8
1159462 1159462 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No 2.0 06 08 2015   grade_6                         45.0 55.0                       100.0                         45 55                 100
1280852 1280852 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No 2.0 06 08 2016   grade_6                         38.0 41.0                       79.0                         38 41                 79
1292914 1292914 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2017   grade_6                         50.0 36.0                       86.0                         50 36                 86
1751546 1751546 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2019   grade_6                         55.0 51.0                       106.0                         55 51                 106
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
1906987 1906987 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2020   grade_6                         62.0 45.0                       107.0                         62 45                 107
1918953 1918953 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2021   grade_6                         53.0 45.0                       98.0                         53 45                 98
1282613 1282613 IN     school 1802660 1875   Delaware Community School Corp 180266000318 1520 Albany Elementary School   Regular School No 1.0 KG 06 2016   grade_6                         1.0 0.0                       1.0                         1 0                 1
1164703 1164703 IN     school 1802910 4680   Lake Station Community Schools 180291000376 3973 Alexander Hamilton Elementary Sch   Regular School No 1.0 01 06 2015   grade_6                         21.0 13.0                       34.0                         21 13                 34
1286093 1286093 IN     school 1802910 4680   Lake Station Community Schools 180291000376 3973 Alexander Hamilton Elementary Sch   Regular School No 1.0 01 06 2016   grade_6                         24.0 15.0                       39.0                         24 15                 39
1298136 1298136 IN     school 1802910 4680   Lake Station Community Schools 180291000376 3973 Alexander Hamilton Elementary Sch   Regular School No Elementary 01 06 2017   grade_6                         17.0 11.0                       28.0                         17 11                 28
1924839 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
1165530 1165530 IN     school 1800120 5265   Alexandria Com School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No 1.0 03 06 2015   grade_6                         55.0 65.0                       120.0                         55 65                 120
1286926 1286926 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No 1.0 03 06 2016   grade_6                         42.0 60.0                       102.0                         42 60                 102
1298961 1298961 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No Elementary 03 06 2017   grade_6                         55.0 57.0                       112.0                         55 57                 112
1757492 1757492 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No Elementary 03 06 2019   grade_6                         51.0 50.0                       101.0                         51 50                 101
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
1912915 1912915 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No Elementary 03 06 2020   grade_6                         70.0 51.0                       121.0                         70 51                 121
1919128 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
1281028 1281028 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_6                         1.0 0.0                       1.0                         1 0                 1
1293090 1293090 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Other 05 11 2017   grade_6                         0.0 1.0                       1.0                         0 1                 1
1159637 1159637 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Ctr   Alternative Education School No 4.0 04 11 2015   grade_6                         2.0 0.0                       2.0                         2 0                 2
1165761 1165761 IN     school 1805670 5330   M S D Lawrence Township 180567002339 5287 Amy Beverland Elementary   Regular School No 1.0 01 06 2015   grade_6                         39.0 59.0                       98.0                         39 59                 98
1287157 1287157 IN     school 1805670 5330   M S D Lawrence Township 180567002339 5287 Amy Beverland Elementary   Regular School No 1.0 01 06 2016   grade_6                         66.0 56.0                       122.0                         66 56                 122
1299197 1299197 IN     school 1805670 5330   M S D Lawrence Township 180567002339 5287 Amy Beverland Elementary   Regular School No Elementary 01 06 2017   grade_6                         53.0 73.0                       126.0                         53 73                 126
1757735 1757735 IN     school 1805670 5330   M S D Lawrence Township 180567002339 5287 Amy Beverland Elementary   Regular School No Elementary 01 06 2019   grade_6                         66.0 56.0                       122.0                         66 56                 122
1793524 1793524 IN     school 1805670 5330   M S D Lawrence Township 180567002339 5287 Amy Beverland Elementary   Regular School No Elementary 01 06 2018   grade_6                         59.0 74.0                       133.0                         59 74                 133
1913154 1913154 IN     school 1805670 5330   M S D Lawrence Township 180567002339 5287 Amy Beverland Elementary   Regular School No Elementary 01 06 2020   grade_6                         82.0 66.0                       148.0                         82 66                 148
1925063 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
1912939 1912939 IN     school 1800150 5275   Anderson Community School Corp 180015002682 4967 Anderson Intermediate School   Regular School No Middle 05 06 2020   grade_6                         282.0 261.0                       543.0                         282 261                 543
1924864 1924864 IN     school 1800150 5275   Anderson Community School Corp 180015002682 4967 Anderson Intermediate School   Regular School No Middle 05 06 2021   grade_6                         276.0 235.0                       511.0                         276 235                 511
1171305 1171305 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes 4.0 KG 12 2015   grade_6                         35.0 30.0                       65.0                         35 30                 65
1292665 1292665 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes 4.0 KG 12 2016   grade_6                         40.0 23.0                       63.0                         40 23                 63
1304705 1304705 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2017   grade_6                         28.0 32.0                       60.0                         28 32                 60
1763287 1763287 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2019   grade_6                         32.0 22.0                       54.0                         32 22                 54
1799032 1799032 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2018   grade_6                         31.0 25.0                       56.0                         31 25                 56
1918734 1918734 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2020   grade_6                         34.0 24.0                       58.0                         34 24                 58
1930722 1930722 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2021   grade_6                         49.0 42.0                       91.0                         49 42                 91
1171192 1171192 IN     school 1800092 9715   Andrew Academy 180009202493 5785 Andrew Academy   Regular School Yes 1.0 KG 08 2015   grade_6                         14.0 8.0                       22.0                         14 8                 22
1171087 1171087 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes 1.0 KG 08 2015   grade_6                         30.0 14.0                       44.0                         30 14                 44
1292464 1292464 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes 1.0 KG 08 2016   grade_6                         37.0 26.0                       63.0                         37 26                 63
1304497 1304497 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes Elementary KG 08 2017   grade_6                         30.0 41.0                       71.0                         30 41                 71
1763109 1763109 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes Elementary KG 08 2019   grade_6                         43.0 33.0                       76.0                         43 33                 76
1798839 1798839 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes Elementary KG 08 2018   grade_6                         26.0 29.0                       55.0                         26 29                 55
1918578 1918578 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes Elementary KG 08 2020   grade_6                         41.0 34.0                       75.0                         41 34                 75
1930574 1930574 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes Elementary KG 08 2021   grade_6                         23.0 43.0                       66.0                         23 43                 66
1169295 1169295 IN     school 1811100 7615   M S D Steuben County 181110001798 7895 Angola Middle School   Regular School No 2.0 06 08 2015   grade_6                         112.0 121.0                       233.0                         112 121                 233
1290678 1290678 IN     school 1811100 7615   M S D Steuben County 181110001798 7895 Angola Middle School   Regular School No 2.0 06 08 2016   grade_6                         109.0 105.0                       214.0                         109 105                 214
1302705 1302705 IN     school 1811100 7615   M S D Steuben County 181110001798 7895 Angola Middle School   Regular School No Middle 06 08 2017   grade_6                         111.0 124.0                       235.0                         111 124                 235
1761205 1761205 IN     school 1811100 7615   M S D Steuben County 181110001798 7895 Angola Middle School   Regular School No Middle 06 08 2019   grade_6                         104.0 95.0                       199.0                         104 95                 199
1797021 1797021 IN     school 1811100 7615   M S D Steuben County 181110001798 7895 Angola Middle School   Regular School No Middle 06 08 2018   grade_6                         126.0 96.0                       222.0                         126 96                 222
1916614 1916614 IN     school 1811100 7615   M S D Steuben County 181110001798 7895 Angola Middle School   Regular School No Middle 06 08 2020   grade_6                         118.0 121.0                       239.0                         118 121                 239
1928545 1928545 IN     school 1811100 7615   MSD Steuben County 181110001798 7895 Angola Middle School   Regular School No Middle 06 08 2021   grade_6                         97.0 100.0                       197.0                         97 100                 197
1166630 1166630 IN     school 1804770 5385   Indianapolis Public Schools 180477000797 5588 Anna Brochhausen School 88   Regular School No 1.0 PK 06 2015   grade_6                         13.0 17.0                       30.0                         13 17                 30
1288041 1288041 IN     school 1804770 5385   Indianapolis Public Schools 180477000797 5588 Anna Brochhausen School 88   Regular School No 1.0 PK 06 2016   grade_6                         16.0 14.0                       30.0                         16 14                 30
1300069 1300069 IN     school 1804770 5385   Indianapolis Public Schools 180477000797 5588 Anna Brochhausen School 88   Regular School No Elementary PK 06 2017   grade_6                         23.0 15.0                       38.0                         23 15                 38
1758570 1758570 IN     school 1804770 5385   Indianapolis Public Schools 180477000797 5588 Anna Brochhausen School 88   Regular School No Elementary PK 06 2019   grade_6                         29.0 21.0                       50.0                         29 21                 50
1794383 1794383 IN     school 1804770 5385   Indianapolis Public Schools 180477000797 5588 Anna Brochhausen School 88   Regular School No Elementary PK 06 2018   grade_6                         22.0 8.0                       30.0                         22 8                 30
1913997 1913997 IN     school 1804770 5385   Indianapolis Public Schools 180477000797 5588 Anna Brochhausen School 88   Regular School No Elementary PK 06 2020   grade_6                         20.0 17.0                       37.0                         20 17                 37
1925893 1925893 IN     school 1804770 5385   Indianapolis Public Schools 180477000797 5588 Anna Brochhausen School 88   Regular School No Elementary PK 06 2021   grade_6                         22.0 24.0                       46.0                         22 24                 46
1914236 1914236 IN     school 1800180 5470   Argos Community Schools 180018000048 5937 Argos Comm Jr-Sr High School   Regular School No High 06 12 2020   grade_6                         23.0 17.0                       40.0                         23 17                 40
1926119 1926119 IN     school 1800180 5470   Argos Community Schools 180018000048 5937 Argos Comm Jr-Sr High School   Regular School No High 06 12 2021   grade_6                         23.0 31.0                       54.0                         23 31                 54
1166886 1166886 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No 1.0 KG 06 2015   grade_6                         26.0 17.0                       43.0                         26 17                 43
1288285 1288285 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No 1.0 PK 06 2016   grade_6                         28.0 28.0                       56.0                         28 28                 56
1300308 1300308 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No Elementary PK 06 2017   grade_6                         25.0 17.0                       42.0                         25 17                 42
1758812 1758812 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No Elementary PK 06 2019   grade_6                         25.0 20.0                       45.0                         25 20                 45
1794625 1794625 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No Elementary PK 06 2018   grade_6                         18.0 23.0                       41.0                         18 23                 41
1168517 1168517 IN     school 1809750 6995   Rush County Schools 180975001591 7253 Arlington Elementary School   Regular School No 1.0 KG 06 2015   grade_6                         20.0 9.0                       29.0                         20 9                 29
1289904 1289904 IN     school 1809750 6995   Rush County Schools 180975001591 7253 Arlington Elementary School   Regular School No 1.0 KG 06 2016   grade_6                         17.0 14.0                       31.0                         17 14                 31
1301928 1301928 IN     school 1809750 6995   Rush County Schools 180975001591 7253 Arlington Elementary School   Regular School No Elementary KG 06 2017   grade_6                         16.0 14.0                       30.0                         16 14                 30
1760438 1760438 IN     school 1809750 6995   Rush County Schools 180975001591 7253 Arlington Elementary School   Regular School No Elementary KG 06 2019   grade_6                         20.0 19.0                       39.0                         20 19                 39
1796246 1796246 IN     school 1809750 6995   Rush County Schools 180975001591 7253 Arlington Elementary School   Regular School No Elementary KG 06 2018   grade_6                         19.0 14.0                       33.0                         19 14                 33
1915849 1915849 IN     school 1809750 6995   Rush County Schools 180975001591 7253 Arlington Elementary School   Regular School No Elementary KG 06 2020   grade_6                         3.0 12.0                       15.0                         3 12                 15
1927774 1927774 IN     school 1809750 6995   Rush County Schools 180975001591 7253 Arlington Elementary School   Regular School No Elementary KG 06 2021   grade_6                         18.0 15.0                       33.0                         18 15                 33
1167179 1167179 IN     school 1800630 5740   Monroe County Com Sch Corp 180063000117 6181 Arlington Heights Elem Sch   Regular School No 1.0 KG 06 2015   grade_6                         21.0 24.0                       45.0                         21 24                 45
1288577 1288577 IN     school 1800630 5740   Monroe County Com Sch Corp 180063000117 6181 Arlington Heights Elementary Sch   Regular School No 1.0 PK 06 2016   grade_6                         24.0 22.0                       46.0                         24 22                 46
1300605 1300605 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000117 6181 Arlington Heights Elementary Sch   Regular School No Elementary PK 06 2017   grade_6                         17.0 14.0                       31.0                         17 14                 31
1759104 1759104 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000117 6181 Arlington Heights Elementary Sch   Regular School No Elementary PK 06 2019   grade_6                         18.0 19.0                       37.0                         18 19                 37
1794922 1794922 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000117 6181 Arlington Heights Elementary Sch   Regular School No Elementary PK 06 2018   grade_6                         21.0 14.0                       35.0                         21 14                 35
1914519 1914519 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000117 6181 Arlington Heights Elementary Sch   Regular School No Elementary PK 06 2020   grade_6                         26.0 24.0                       50.0                         26 24                 50

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