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 descending

✎ 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
1162036 1162036 IN     school 1803700 2475   Franklin County Com Sch Corp 180370002221 2082 Laurel School   Regular School No 1.0 PK 08 2015   grade_8                         27.0 22.0                       49.0                         27 22                 49
1164647 1164647 IN     school 1802880 4670   School City of East Chicago 180288000365 3937 Carrie Gosch Elementary School   Regular School No 1.0 PK 08 2015   grade_8                         0.0 1.0                       1.0                         0 1                 1
1166505 1166505 IN     school 1804770 5385   Indianapolis Public Schools 180477000831 5556 Francis W Parker School 56   Regular School No 1.0 PK 08 2015   grade_8                         5.0 8.0                       13.0                         5 8                 13
1166621 1166621 IN     school 1804770 5385   Indianapolis Public Schools 180477002555 5587 George W Carver School 87   Regular School No 1.0 PK 08 2015   grade_8                         14.0 5.0                       19.0                         14 5                 19
1166789 1166789 IN     school 1804770 5385   Indianapolis Public Schools 180477002510 5668 Center for Inquiry III   Regular School No 1.0 PK 08 2015   grade_8                         8.0 9.0                       17.0                         8 9                 17
1166800 1166800 IN     school 1804770 5385   Indianapolis Public Schools 180477002395 5674 Frederick Douglass School 19   Regular School No 1.0 PK 08 2015   grade_8                         21.0 13.0                       34.0                         21 13                 34
1167786 1167786 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elem & High School   Regular School No 4.0 PK 12 2015   grade_8                         9.0 14.0                       23.0                         9 14                 23
1169101 1169101 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No 4.0 PK 12 2015   grade_8                         1.0 0.0                       1.0                         1 0                 1
1169358 1169358 IN     school 1810860 7715   Southwest School Corp 181086001770 7953 Carlisle Elem and Junior High   Regular School No 1.0 PK 08 2015   grade_8                         11.0 9.0                       20.0                         11 9                 20
1169721 1169721 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000458 8265 Cedar Hall Community School   Regular School No 1.0 PK 08 2015   grade_8                         25.0 32.0                       57.0                         25 32                 57
1171062 1171062 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 Indiana School For The Blind   Alternative Education School No 4.0 PK 12 2015   grade_8                         8.0 0.0                       8.0                         8 0                 8
1171077 1171077 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative Education School No 4.0 PK 12 2015   grade_8                         21.0 9.0                       30.0                         21 9                 30
1282154 1282154 IN     school 1800840 1125   Clay Community Schools 180084000159 942 Forest Park Elementary School   Regular School No 1.0 PK 08 2016   grade_8                         1.0 0.0                       1.0                         1 0                 1
1283446 1283446 IN     school 1803700 2475   Franklin County Com Sch Corp 180370002221 2082 Laurel School   Regular School No 1.0 PK 08 2016   grade_8                         26.0 22.0                       48.0                         26 22                 48
1286035 1286035 IN     school 1802880 4670   School City of East Chicago 180288000365 3937 Carrie Gosch Elementary School   Regular School No 1.0 PK 08 2016   grade_8                         0.0 1.0                       1.0                         0 1                 1
1287913 1287913 IN     school 1804770 5385   Indianapolis Public Schools 180477000831 5556 Francis W Parker School 56   Regular School No 1.0 PK 08 2016   grade_8                         7.0 6.0                       13.0                         7 6                 13
1288032 1288032 IN     school 1804770 5385   Indianapolis Public Schools 180477002555 5587 George W Carver School 87   Regular School No 1.0 PK 08 2016   grade_8                         1.0 6.0                       7.0                         1 6                 7
1288208 1288208 IN     school 1804770 5385   Indianapolis Public Schools 180477002510 5668 Center for Inquiry III   Regular School No 1.0 PK 08 2016   grade_8                         6.0 10.0                       16.0                         6 10                 16
1288219 1288219 IN     school 1804770 5385   Indianapolis Public Schools 180477002395 5674 Frederick Douglass School 19   Regular School No 1.0 PK 08 2016   grade_8                         21.0 24.0                       45.0                         21 24                 45
1289185 1289185 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elem & High School   Regular School No 4.0 PK 12 2016   grade_8                         10.0 7.0                       17.0                         10 7                 17
1291111 1291111 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000458 8265 Cedar Hall Community School   Regular School No 1.0 PK 08 2016   grade_8                         28.0 32.0                       60.0                         28 32                 60
1292439 1292439 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 Indiana School For The Blind   Alternative Education School No 4.0 PK 12 2016   grade_8                         10.0 8.0                       18.0                         10 8                 18
1292454 1292454 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative Education School No 4.0 PK 12 2016   grade_8                         16.0 17.0                       33.0                         16 17                 33
1295491 1295491 IN     school 1803700 2475   Franklin County Community Sch Corp 180370002221 2082 Laurel School   Regular School No Elementary PK 08 2017   grade_8                         22.0 19.0                       41.0                         22 19                 41
1299940 1299940 IN     school 1804770 5385   Indianapolis Public Schools 180477000831 5556 Francis W Parker School 56   Regular School No Elementary PK 08 2017   grade_8                         11.0 6.0                       17.0                         11 6                 17
1300060 1300060 IN     school 1804770 5385   Indianapolis Public Schools 180477002555 5587 George Washington Carver School 87   Regular School No Elementary PK 08 2017   grade_8                         10.0 10.0                       20.0                         10 10                 20
1300231 1300231 IN     school 1804770 5385   Indianapolis Public Schools 180477002510 5668 Center for Inquiry School 27   Regular School No Elementary PK 08 2017   grade_8                         22.0 10.0                       32.0                         22 10                 32
1300242 1300242 IN     school 1804770 5385   Indianapolis Public Schools 180477002395 5674 Frederick Douglass School 19   Regular School No Elementary PK 08 2017   grade_8                         27.0 26.0                       53.0                         27 26                 53
1301214 1301214 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elementary & High School   Regular School No Other PK 12 2017   grade_8                         12.0 9.0                       21.0                         12 9                 21
1303140 1303140 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000458 8265 Cedar Hall Community School   Regular School No Elementary PK 08 2017   grade_8                         28.0 23.0                       51.0                         28 23                 51
1304472 1304472 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Alternative School No Other PK 12 2017   grade_8                         2.0 5.0                       7.0                         2 5                 7
1304487 1304487 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   grade_8                         8.0 13.0                       21.0                         8 13                 21
1757138 1757138 IN     school 1800107 4915   Tri-Township Cons School Corp 180010702520 4696 Wanatah School   Regular School No Elementary PK 08 2019   grade_8                         15.0 15.0                       30.0                         15 15                 30
1758375 1758375 IN     school 1804770 5385   Indianapolis Public Schools 180477000854 5543 James Whitcomb Riley School 43   Regular School No Elementary PK 08 2019   grade_8                         29.0 25.0                       54.0                         29 25                 54
1758409 1758409 IN     school 1804770 5385   Indianapolis Public Schools 180477000904 5549 William Penn School 49   Regular School No Elementary PK 08 2019   grade_8                         37.0 29.0                       66.0                         37 29                 66
1758446 1758446 IN     school 1804770 5385   Indianapolis Public Schools 180477000831 5556 Francis W Parker School 56   Regular School No Elementary PK 08 2019   grade_8                         16.0 12.0                       28.0                         16 12                 28
1758476 1758476 IN     school 1804770 5385   Indianapolis Public Schools 180477000901 5560 IPS/ Butler Lab @ William Bell 60   Regular School No Elementary PK 08 2019   grade_8                         17.0 15.0                       32.0                         17 15                 32
1758496 1758496 IN     school 1804770 5385   Indianapolis Public Schools 180477000890 5567 Stephen Foster School 67   Regular School No Elementary PK 08 2019   grade_8                         42.0 23.0                       65.0                         42 23                 65
1758561 1758561 IN     school 1804770 5385   Indianapolis Public Schools 180477002555 5587 George Washington Carver School 87   Regular School No Elementary PK 08 2019   grade_8                         12.0 8.0                       20.0                         12 8                 20
1758590 1758590 IN     school 1804770 5385   Indianapolis Public Schools 180477002277 5591 Rousseau McClellan School 91   Regular School No Elementary PK 08 2019   grade_8                         11.0 21.0                       32.0                         11 21                 32
1758734 1758734 IN     school 1804770 5385   Indianapolis Public Schools 180477002510 5668 Center for Inquiry School 27   Regular School No Elementary PK 08 2019   grade_8                         13.0 15.0                       28.0                         13 15                 28
1758745 1758745 IN     school 1804770 5385   Indianapolis Public Schools 180477002395 5674 Frederick Douglass School 19   Regular School No Elementary PK 08 2019   grade_8                         41.0 23.0                       64.0                         41 23                 64
1759707 1759707 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elementary & High School   Regular School No Other PK 12 2019   grade_8                         10.0 11.0                       21.0                         10 11                 21
1761011 1761011 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other PK 12 2019   grade_8                         2.0 2.0                       4.0                         2 2                 4
1761651 1761651 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000458 8265 Cedar Hall Community School   Regular School No Elementary PK 08 2019   grade_8                         33.0 29.0                       62.0                         33 29                 62
1762852 1762852 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other PK 12 2019   grade_8                         20.0 22.0                       42.0                         20 22                 42
1763084 1763084 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2019   grade_8                         10.0 2.0                       12.0                         10 2                 12
1763099 1763099 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2019   grade_8                         12.0 11.0                       23.0                         12 11                 23
1792930 1792930 IN     school 1800107 4915   Tri-Township Cons School Corp 180010702520 4696 Wanatah School   Regular School No Elementary PK 08 2018   grade_8                         15.0 12.0                       27.0                         15 12                 27
1794250 1794250 IN     school 1804770 5385   Indianapolis Public Schools 180477000831 5556 Francis W Parker School 56   Regular School No Elementary PK 08 2018   grade_8                         12.0 12.0                       24.0                         12 12                 24
1794374 1794374 IN     school 1804770 5385   Indianapolis Public Schools 180477002555 5587 George Washington Carver School 87   Regular School No Elementary PK 08 2018   grade_8                         12.0 13.0                       25.0                         12 13                 25
1794402 1794402 IN     school 1804770 5385   Indianapolis Public Schools 180477002277 5591 Rousseau McClellan School 91   Regular School No Elementary PK 08 2018   grade_8                         24.0 16.0                       40.0                         24 16                 40
1794548 1794548 IN     school 1804770 5385   Indianapolis Public Schools 180477002510 5668 Center for Inquiry School 27   Regular School No Elementary PK 08 2018   grade_8                         16.0 11.0                       27.0                         16 11                 27
1794559 1794559 IN     school 1804770 5385   Indianapolis Public Schools 180477002395 5674 Frederick Douglass School 19   Regular School No Elementary PK 08 2018   grade_8                         40.0 38.0                       78.0                         40 38                 78
1795531 1795531 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elementary & High School   Regular School No Other PK 12 2018   grade_8                         16.0 7.0                       23.0                         16 7                 23
1797456 1797456 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000458 8265 Cedar Hall Community School   Regular School No Elementary PK 08 2018   grade_8                         18.0 34.0                       52.0                         18 34                 52
1798814 1798814 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2018   grade_8                         2.0 1.0                       3.0                         2 1                 3
1798829 1798829 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2018   grade_8                         7.0 13.0                       20.0                         7 13                 20
1912574 1912574 IN     school 1800107 4915   Tri-Township Cons School Corp 180010702520 4696 Wanatah School   Regular School No Elementary PK 08 2020   grade_8                         21.0 9.0                       30.0                         21 9                 30
1913804 1913804 IN     school 1804770 5385   Indianapolis Public Schools 180477000854 5543 James Whitcomb Riley School 43   Regular School No Elementary PK 08 2020   grade_8                         20.0 19.0                       39.0                         20 19                 39
1913836 1913836 IN     school 1804770 5385   Indianapolis Public Schools 180477000904 5549 William Penn School 49   Regular School No Elementary PK 08 2020   grade_8                         24.0 26.0                       50.0                         24 26                 50
1913874 1913874 IN     school 1804770 5385   Indianapolis Public Schools 180477000831 5556 Francis W Parker School 56   Regular School No Elementary PK 08 2020   grade_8                         21.0 23.0                       44.0                         21 23                 44
1913904 1913904 IN     school 1804770 5385   Indianapolis Public Schools 180477000901 5560 IPS/Butler Lab at William Bell 60   Regular School No Elementary PK 08 2020   grade_8                         23.0 32.0                       55.0                         23 32                 55
1913924 1913924 IN     school 1804770 5385   Indianapolis Public Schools 180477000890 5567 Stephen Foster School 67   Regular School No Elementary PK 08 2020   grade_8                         24.0 19.0                       43.0                         24 19                 43
1913988 1913988 IN     school 1804770 5385   Indianapolis Public Schools 180477002555 5587 George Washington Carver School 87   Regular School No Elementary PK 08 2020   grade_8                         8.0 13.0                       21.0                         8 13                 21
1914017 1914017 IN     school 1804770 5385   Indianapolis Public Schools 180477002277 5591 Rousseau McClellan School 91   Regular School No Elementary PK 08 2020   grade_8                         23.0 21.0                       44.0                         23 21                 44
1914152 1914152 IN     school 1804770 5385   Indianapolis Public Schools 180477002510 5668 Center for Inquiry School 27   Regular School No Elementary PK 08 2020   grade_8                         17.0 28.0                       45.0                         17 28                 45
1914163 1914163 IN     school 1804770 5385   Indianapolis Public Schools 180477002395 5674 Frederick Douglass School 19   Regular School No Elementary PK 08 2020   grade_8                         38.0 33.0                       71.0                         38 33                 71
1915118 1915118 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elementary & High School   Regular School No Other PK 12 2020   grade_8                         7.0 8.0                       15.0                         7 8                 15
1917057 1917057 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000458 8265 Cedar Hall Community School   Regular School No Elementary PK 08 2020   grade_8                         36.0 37.0                       73.0                         36 37                 73
1918315 1918315 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other PK 12 2020   grade_8                         22.0 18.0                       40.0                         22 18                 40
1918553 1918553 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2020   grade_8                         5.0 5.0                       10.0                         5 5                 10
1918568 1918568 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2020   grade_8                         11.0 15.0                       26.0                         11 15                 26
1924524 1924524 IN     school 1800107 4915   Tri-Township Cons School Corp 180010702520 4696 Wanatah School   Regular School No Elementary PK 08 2021   grade_8                         9.0 18.0                       27.0                         9 18                 27
1925677 1925677 IN     school 1804770 5385   Indianapolis Public Schools 180477000866 5531 James A Garfield School 31   Regular School No Elementary PK 08 2021   grade_8                         33.0 21.0                       54.0                         33 21                 54
1925716 1925716 IN     school 1804770 5385   Indianapolis Public Schools 180477000854 5543 James Whitcomb Riley School 43   Regular School No Elementary PK 08 2021   grade_8                         24.0 22.0                       46.0                         24 22                 46
1925729 1925729 IN     school 1804770 5385   Indianapolis Public Schools 180477000817 5546 Daniel Webster School 46   Regular School No Elementary PK 08 2021   grade_8                         27.0 22.0                       49.0                         27 22                 49
1925740 1925740 IN     school 1804770 5385   Indianapolis Public Schools 180477000904 5549 William Penn School 49   Regular School No Elementary PK 08 2021   grade_8                         40.0 24.0                       64.0                         40 24                 64
1925769 1925769 IN     school 1804770 5385   Indianapolis Public Schools 180477000822 5555 IPS/Butler Lab at Eliza Blaker 55   Regular School No Elementary PK 08 2021   grade_8                         16.0 13.0                       29.0                         16 13                 29
1925780 1925780 IN     school 1804770 5385   Indianapolis Public Schools 180477000831 5556 Francis W Parker School 56   Regular School No Elementary PK 08 2021   grade_8                         19.0 22.0                       41.0                         19 22                 41
1925791 1925791 IN     school 1804770 5385   Indianapolis Public Schools 180477000841 5557 George W Julian School 57   Regular School No Elementary PK 08 2021   grade_8                         13.0 4.0                       17.0                         13 4                 17
1925811 1925811 IN     school 1804770 5385   Indianapolis Public Schools 180477000901 5560 IPS/Butler Lab at William Bell 60   Regular School No Elementary PK 08 2021   grade_8                         26.0 30.0                       56.0                         26 30                 56
1925884 1925884 IN     school 1804770 5385   Indianapolis Public Schools 180477002555 5587 George Washington Carver School 87   Regular School No Elementary PK 08 2021   grade_8                         12.0 11.0                       23.0                         12 11                 23
1925913 1925913 IN     school 1804770 5385   Indianapolis Public Schools 180477002277 5591 Rousseau McClellan School 91   Regular School No Elementary PK 08 2021   grade_8                         26.0 13.0                       39.0                         26 13                 39
1926035 1926035 IN     school 1804770 5385   Indianapolis Public Schools 180477002510 5668 Center for Inquiry School 27   Regular School No Elementary PK 08 2021   grade_8                         23.0 19.0                       42.0                         23 19                 42
1926994 1926994 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elementary & High School   Regular School No Other PK 12 2021   grade_8                         9.0 10.0                       19.0                         9 10                 19
1928988 1928988 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000458 8265 Cedar Hall Community School   Regular School No Elementary PK 08 2021   grade_8                         20.0 27.0                       47.0                         20 27                 47
1930291 1930291 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other PK 12 2021   grade_8                         20.0 23.0                       43.0                         20 23                 43
1930548 1930548 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2021   grade_8                         2.0 1.0                       3.0                         2 1                 3
1930564 1930564 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2021   grade_8                         5.0 7.0                       12.0                         5 7                 12
1162064 1162064 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000591 2127 Mount Carmel School   Regular School No 1.0 KG 08 2015   grade_8                         24.0 23.0                       47.0                         24 23                 47
1162161 1162161 IN     school 1810350 2765   South Gibson School Corp 181035001689 2205 Haubstadt Community School   Regular School No 1.0 KG 08 2015   grade_8                         33.0 27.0                       60.0                         33 27                 60
1162176 1162176 IN     school 1810350 2765   South Gibson School Corp 181035002230 2214 Fort Branch Community School   Regular School No 1.0 KG 08 2015   grade_8                         24.0 26.0                       50.0                         24 26                 50
1162186 1162186 IN     school 1810350 2765   South Gibson School Corp 181035001691 2241 Owensville Community School   Regular School No 1.0 KG 08 2015   grade_8                         24.0 20.0                       44.0                         24 20                 44
1164134 1164134 IN     school 1805550 4345   Wawasee Community School Corp 180555001001 3635 Milford School   Regular School No 1.0 KG 08 2015   grade_8                         42.0 39.0                       81.0                         42 39                 81
1164362 1164362 IN     school 1808320 4570   Northwest Indiana Spec Ed Coop 180832002208 4287 Eagle Park Community School   Special Education School No 4.0 KG 12 2015   grade_8                         3.0 2.0                       5.0                         3 2                 5
1164727 1164727 IN     school 1803870 4690   Gary Community School Corp 180387000613 4053 Benjamin Banneker Achievement Ctr   Regular School No 1.0 KG 08 2015   grade_8                         21.0 27.0                       48.0                         21 27                 48
1165178 1165178 IN     school 1800107 4915   Tri-Township Cons School Corp 180010702520 4696 Wanatah School   Regular School No 1.0 KG 08 2015   grade_8                         18.0 10.0                       28.0                         18 10                 28
1166396 1166396 IN     school 1804770 5385   Indianapolis Public Schools 180477000866 5531 James A Garfield Sch 31   Regular School No 1.0 KG 08 2015   grade_8                         4.0 13.0                       17.0                         4 13                 17
1166433 1166433 IN     school 1804770 5385   Indianapolis Public Schools 180477000854 5543 James Whitcomb Riley Sch 43   Regular School No 1.0 KG 08 2015   grade_8                         9.0 7.0                       16.0                         9 7                 16

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