enrollments

Data source: Big Local News · About: Big Local

3,530 rows where grade = "grade_7" and state = "IN" sorted by ccd_school_low_grade descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 3,530 ✖
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
1160752 1160752 IN     school 1800840 1125   Clay Community Schools 180084000159 942 Forest Park Elementary School   Regular School No 1.0 PK 07 2015   grade_7                         1.0 0.0                       1.0                         1 0                 1
1162035 1162035 IN     school 1803700 2475   Franklin County Com Sch Corp 180370002221 2082 Laurel School   Regular School No 1.0 PK 08 2015   grade_7                         25.0 18.0                       43.0                         25 18                 43
1164646 1164646 IN     school 1802880 4670   School City of East Chicago 180288000365 3937 Carrie Gosch Elementary School   Regular School No 1.0 PK 08 2015   grade_7                         3.0 2.0                       5.0                         3 2                 5
1166504 1166504 IN     school 1804770 5385   Indianapolis Public Schools 180477000831 5556 Francis W Parker School 56   Regular School No 1.0 PK 08 2015   grade_7                         11.0 9.0                       20.0                         11 9                 20
1166620 1166620 IN     school 1804770 5385   Indianapolis Public Schools 180477002555 5587 George W Carver School 87   Regular School No 1.0 PK 08 2015   grade_7                         1.0 6.0                       7.0                         1 6                 7
1166788 1166788 IN     school 1804770 5385   Indianapolis Public Schools 180477002510 5668 Center for Inquiry III   Regular School No 1.0 PK 08 2015   grade_7                         8.0 13.0                       21.0                         8 13                 21
1166799 1166799 IN     school 1804770 5385   Indianapolis Public Schools 180477002395 5674 Frederick Douglass School 19   Regular School No 1.0 PK 08 2015   grade_7                         25.0 26.0                       51.0                         25 26                 51
1167565 1167565 IN     school 1802970 6060   East Noble School Corp 180297000387 6457 Avilla Elementary School   Regular School No 1.0 PK 07 2015   grade_7                         2.0 1.0                       3.0                         2 1                 3
1167610 1167610 IN     school 1802970 6060   East Noble School Corp 180297000394 6485 Wayne Center Elem Sch   Regular School No 1.0 PK 07 2015   grade_7                         1.0 1.0                       2.0                         1 1                 2
1167785 1167785 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elem & High School   Regular School No 4.0 PK 12 2015   grade_7                         11.0 8.0                       19.0                         11 8                 19
1169100 1169100 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No 4.0 PK 12 2015   grade_7                         0.0 2.0                       2.0                         0 2                 2
1169357 1169357 IN     school 1810860 7715   Southwest School Corp 181086001770 7953 Carlisle Elem and Junior High   Regular School No 1.0 PK 08 2015   grade_7                         19.0 13.0                       32.0                         19 13                 32
1169720 1169720 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000458 8265 Cedar Hall Community School   Regular School No 1.0 PK 08 2015   grade_7                         33.0 33.0                       66.0                         33 33                 66
1171061 1171061 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_7                         10.0 8.0                       18.0                         10 8                 18
1171076 1171076 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_7                         15.0 14.0                       29.0                         15 14                 29
1283445 1283445 IN     school 1803700 2475   Franklin County Com Sch Corp 180370002221 2082 Laurel School   Regular School No 1.0 PK 08 2016   grade_7                         27.0 16.0                       43.0                         27 16                 43
1286034 1286034 IN     school 1802880 4670   School City of East Chicago 180288000365 3937 Carrie Gosch Elementary School   Regular School No 1.0 PK 08 2016   grade_7                         4.0 2.0                       6.0                         4 2                 6
1287912 1287912 IN     school 1804770 5385   Indianapolis Public Schools 180477000831 5556 Francis W Parker School 56   Regular School No 1.0 PK 08 2016   grade_7                         14.0 10.0                       24.0                         14 10                 24
1288031 1288031 IN     school 1804770 5385   Indianapolis Public Schools 180477002555 5587 George W Carver School 87   Regular School No 1.0 PK 08 2016   grade_7                         10.0 10.0                       20.0                         10 10                 20
1288207 1288207 IN     school 1804770 5385   Indianapolis Public Schools 180477002510 5668 Center for Inquiry III   Regular School No 1.0 PK 08 2016   grade_7                         26.0 11.0                       37.0                         26 11                 37
1288218 1288218 IN     school 1804770 5385   Indianapolis Public Schools 180477002395 5674 Frederick Douglass School 19   Regular School No 1.0 PK 08 2016   grade_7                         29.0 24.0                       53.0                         29 24                 53
1288963 1288963 IN     school 1802970 6060   East Noble School Corp 180297000387 6457 Avilla Elementary School   Regular School No 1.0 PK 07 2016   grade_7                         1.0 1.0                       2.0                         1 1                 2
1289184 1289184 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elem & High School   Regular School No 4.0 PK 12 2016   grade_7                         8.0 12.0                       20.0                         8 12                 20
1291110 1291110 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000458 8265 Cedar Hall Community School   Regular School No 1.0 PK 08 2016   grade_7                         25.0 27.0                       52.0                         25 27                 52
1292438 1292438 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_7                         0.0 3.0                       3.0                         0 3                 3
1292453 1292453 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_7                         11.0 14.0                       25.0                         11 14                 25
1295490 1295490 IN     school 1803700 2475   Franklin County Community Sch Corp 180370002221 2082 Laurel School   Regular School No Elementary PK 08 2017   grade_7                         22.0 10.0                       32.0                         22 10                 32
1298081 1298081 IN     school 1802880 4670   School City of East Chicago 180288000365 3937 Carrie Gosch Elementary School   Regular School No Elementary PK 07 2017   grade_7                         5.0 3.0                       8.0                         5 3                 8
1299939 1299939 IN     school 1804770 5385   Indianapolis Public Schools 180477000831 5556 Francis W Parker School 56   Regular School No Elementary PK 08 2017   grade_7                         11.0 13.0                       24.0                         11 13                 24
1300059 1300059 IN     school 1804770 5385   Indianapolis Public Schools 180477002555 5587 George Washington Carver School 87   Regular School No Elementary PK 08 2017   grade_7                         13.0 14.0                       27.0                         13 14                 27
1300230 1300230 IN     school 1804770 5385   Indianapolis Public Schools 180477002510 5668 Center for Inquiry School 27   Regular School No Elementary PK 08 2017   grade_7                         17.0 10.0                       27.0                         17 10                 27
1300241 1300241 IN     school 1804770 5385   Indianapolis Public Schools 180477002395 5674 Frederick Douglass School 19   Regular School No Elementary PK 08 2017   grade_7                         45.0 42.0                       87.0                         45 42                 87
1300992 1300992 IN     school 1802970 6060   East Noble School Corporation 180297000387 6457 Avilla Elementary School   Regular School No Elementary PK 07 2017   grade_7                         6.0 1.0                       7.0                         6 1                 7
1301037 1301037 IN     school 1802970 6060   East Noble School Corporation 180297000394 6485 Wayne Center Elem School   Regular School No Elementary PK 07 2017   grade_7                         0.0 2.0                       2.0                         0 2                 2
1301213 1301213 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elementary & High School   Regular School No Other PK 12 2017   grade_7                         16.0 6.0                       22.0                         16 6                 22
1303139 1303139 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000458 8265 Cedar Hall Community School   Regular School No Elementary PK 08 2017   grade_7                         21.0 29.0                       50.0                         21 29                 50
1304471 1304471 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_7                         3.0 3.0                       6.0                         3 3                 6
1304486 1304486 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   grade_7                         4.0 10.0                       14.0                         4 10                 14
1753888 1753888 IN     school 1803930 2315   Goshen Community Schools 180393002180 1847 Prairie View Elementary School   Regular School No Elementary PK 07 2019   grade_7                         1.0 0.0                       1.0                         1 0                 1
1755415 1755415 IN     school 1803150 3480   Eastern Howard School Corporation 180315000412 2909 Eastern Elementary School   Regular School No Elementary PK 07 2019   grade_7                         0.0 1.0                       1.0                         0 1                 1
1757137 1757137 IN     school 1800107 4915   Tri-Township Cons School Corp 180010702520 4696 Wanatah School   Regular School No Elementary PK 08 2019   grade_7                         21.0 10.0                       31.0                         21 10                 31
1758374 1758374 IN     school 1804770 5385   Indianapolis Public Schools 180477000854 5543 James Whitcomb Riley School 43   Regular School No Elementary PK 08 2019   grade_7                         17.0 16.0                       33.0                         17 16                 33
1758408 1758408 IN     school 1804770 5385   Indianapolis Public Schools 180477000904 5549 William Penn School 49   Regular School No Elementary PK 08 2019   grade_7                         29.0 35.0                       64.0                         29 35                 64
1758445 1758445 IN     school 1804770 5385   Indianapolis Public Schools 180477000831 5556 Francis W Parker School 56   Regular School No Elementary PK 08 2019   grade_7                         27.0 24.0                       51.0                         27 24                 51
1758475 1758475 IN     school 1804770 5385   Indianapolis Public Schools 180477000901 5560 IPS/ Butler Lab @ William Bell 60   Regular School No Elementary PK 08 2019   grade_7                         24.0 32.0                       56.0                         24 32                 56
1758495 1758495 IN     school 1804770 5385   Indianapolis Public Schools 180477000890 5567 Stephen Foster School 67   Regular School No Elementary PK 08 2019   grade_7                         27.0 22.0                       49.0                         27 22                 49
1758560 1758560 IN     school 1804770 5385   Indianapolis Public Schools 180477002555 5587 George Washington Carver School 87   Regular School No Elementary PK 08 2019   grade_7                         9.0 14.0                       23.0                         9 14                 23
1758589 1758589 IN     school 1804770 5385   Indianapolis Public Schools 180477002277 5591 Rousseau McClellan School 91   Regular School No Elementary PK 08 2019   grade_7                         25.0 22.0                       47.0                         25 22                 47
1758733 1758733 IN     school 1804770 5385   Indianapolis Public Schools 180477002510 5668 Center for Inquiry School 27   Regular School No Elementary PK 08 2019   grade_7                         17.0 30.0                       47.0                         17 30                 47
1758744 1758744 IN     school 1804770 5385   Indianapolis Public Schools 180477002395 5674 Frederick Douglass School 19   Regular School No Elementary PK 08 2019   grade_7                         44.0 35.0                       79.0                         44 35                 79
1759706 1759706 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elementary & High School   Regular School No Other PK 12 2019   grade_7                         7.0 8.0                       15.0                         7 8                 15
1761010 1761010 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other PK 12 2019   grade_7                         0.0 1.0                       1.0                         0 1                 1
1761650 1761650 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000458 8265 Cedar Hall Community School   Regular School No Elementary PK 08 2019   grade_7                         36.0 33.0                       69.0                         36 33                 69
1762851 1762851 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other PK 12 2019   grade_7                         18.0 20.0                       38.0                         18 20                 38
1763083 1763083 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_7                         3.0 5.0                       8.0                         3 5                 8
1763098 1763098 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_7                         13.0 15.0                       28.0                         13 15                 28
1791156 1791156 IN     school 1803150 3480   Eastern Howard School Corporation 180315000412 2909 Eastern Elementary School   Regular School No Elementary PK 07 2018   grade_7                         0.0 1.0                       1.0                         0 1                 1
1792929 1792929 IN     school 1800107 4915   Tri-Township Cons School Corp 180010702520 4696 Wanatah School   Regular School No Elementary PK 08 2018   grade_7                         14.0 18.0                       32.0                         14 18                 32
1794119 1794119 IN     school 1804770 5385   Indianapolis Public Schools 180477000897 5514 Washington Irving School 14   Regular School No Elementary PK 07 2018   grade_7                         31.0 17.0                       48.0                         31 17                 48
1794179 1794179 IN     school 1804770 5385   Indianapolis Public Schools 180477000854 5543 James Whitcomb Riley School 43   Regular School No Elementary PK 07 2018   grade_7                         90.0 60.0                       150.0                         90 60                 150
1794213 1794213 IN     school 1804770 5385   Indianapolis Public Schools 180477000904 5549 William Penn School 49   Regular School No Elementary PK 07 2018   grade_7                         44.0 42.0                       86.0                         44 42                 86
1794249 1794249 IN     school 1804770 5385   Indianapolis Public Schools 180477000831 5556 Francis W Parker School 56   Regular School No Elementary PK 08 2018   grade_7                         14.0 12.0                       26.0                         14 12                 26
1794278 1794278 IN     school 1804770 5385   Indianapolis Public Schools 180477000901 5560 IPS/ Butler Lab @ William Bell 60   Regular School No Elementary PK 07 2018   grade_7                         18.0 16.0                       34.0                         18 16                 34
1794288 1794288 IN     school 1804770 5385   Indianapolis Public Schools 180477002394 5563 Wendell Phillips School 63   Regular School No Elementary PK 07 2018   grade_7                         31.0 33.0                       64.0                         31 33                 64
1794307 1794307 IN     school 1804770 5385   Indianapolis Public Schools 180477000890 5567 Stephen Foster School 67   Regular School No Elementary PK 07 2018   grade_7                         66.0 68.0                       134.0                         66 68                 134
1794373 1794373 IN     school 1804770 5385   Indianapolis Public Schools 180477002555 5587 George Washington Carver School 87   Regular School No Elementary PK 08 2018   grade_7                         12.0 9.0                       21.0                         12 9                 21
1794401 1794401 IN     school 1804770 5385   Indianapolis Public Schools 180477002277 5591 Rousseau McClellan School 91   Regular School No Elementary PK 08 2018   grade_7                         18.0 25.0                       43.0                         18 25                 43
1794547 1794547 IN     school 1804770 5385   Indianapolis Public Schools 180477002510 5668 Center for Inquiry School 27   Regular School No Elementary PK 08 2018   grade_7                         15.0 18.0                       33.0                         15 18                 33
1794558 1794558 IN     school 1804770 5385   Indianapolis Public Schools 180477002395 5674 Frederick Douglass School 19   Regular School No Elementary PK 08 2018   grade_7                         38.0 21.0                       59.0                         38 21                 59
1795308 1795308 IN     school 1802970 6060   East Noble School Corporation 180297000387 6457 Avilla Elementary School   Regular School No Elementary PK 07 2018   grade_7                         3.0 2.0                       5.0                         3 2                 5
1795530 1795530 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elementary & High School   Regular School No Other PK 12 2018   grade_7                         7.0 8.0                       15.0                         7 8                 15
1797455 1797455 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000458 8265 Cedar Hall Community School   Regular School No Elementary PK 08 2018   grade_7                         28.0 24.0                       52.0                         28 24                 52
1798813 1798813 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_7                         10.0 2.0                       12.0                         10 2                 12
1798828 1798828 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_7                         11.0 9.0                       20.0                         11 9                 20
1912573 1912573 IN     school 1800107 4915   Tri-Township Cons School Corp 180010702520 4696 Wanatah School   Regular School No Elementary PK 08 2020   grade_7                         9.0 16.0                       25.0                         9 16                 25
1913803 1913803 IN     school 1804770 5385   Indianapolis Public Schools 180477000854 5543 James Whitcomb Riley School 43   Regular School No Elementary PK 08 2020   grade_7                         23.0 24.0                       47.0                         23 24                 47
1913835 1913835 IN     school 1804770 5385   Indianapolis Public Schools 180477000904 5549 William Penn School 49   Regular School No Elementary PK 08 2020   grade_7                         43.0 25.0                       68.0                         43 25                 68
1913863 1913863 IN     school 1804770 5385   Indianapolis Public Schools 180477000822 5555 IPS/Butler Lab at Eliza Blaker 55   Regular School No Elementary PK 07 2020   grade_7                         14.0 13.0                       27.0                         14 13                 27
1913873 1913873 IN     school 1804770 5385   Indianapolis Public Schools 180477000831 5556 Francis W Parker School 56   Regular School No Elementary PK 08 2020   grade_7                         21.0 20.0                       41.0                         21 20                 41
1913903 1913903 IN     school 1804770 5385   Indianapolis Public Schools 180477000901 5560 IPS/Butler Lab at William Bell 60   Regular School No Elementary PK 08 2020   grade_7                         27.0 30.0                       57.0                         27 30                 57
1913923 1913923 IN     school 1804770 5385   Indianapolis Public Schools 180477000890 5567 Stephen Foster School 67   Regular School No Elementary PK 08 2020   grade_7                         30.0 24.0                       54.0                         30 24                 54
1913987 1913987 IN     school 1804770 5385   Indianapolis Public Schools 180477002555 5587 George Washington Carver School 87   Regular School No Elementary PK 08 2020   grade_7                         13.0 11.0                       24.0                         13 11                 24
1914016 1914016 IN     school 1804770 5385   Indianapolis Public Schools 180477002277 5591 Rousseau McClellan School 91   Regular School No Elementary PK 08 2020   grade_7                         29.0 17.0                       46.0                         29 17                 46
1914151 1914151 IN     school 1804770 5385   Indianapolis Public Schools 180477002510 5668 Center for Inquiry School 27   Regular School No Elementary PK 08 2020   grade_7                         24.0 22.0                       46.0                         24 22                 46
1914162 1914162 IN     school 1804770 5385   Indianapolis Public Schools 180477002395 5674 Frederick Douglass School 19   Regular School No Elementary PK 08 2020   grade_7                         43.0 27.0                       70.0                         43 27                 70
1915117 1915117 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elementary & High School   Regular School No Other PK 12 2020   grade_7                         9.0 12.0                       21.0                         9 12                 21
1917056 1917056 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000458 8265 Cedar Hall Community School   Regular School No Elementary PK 08 2020   grade_7                         31.0 36.0                       67.0                         31 36                 67
1918314 1918314 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other PK 12 2020   grade_7                         20.0 24.0                       44.0                         20 24                 44
1918552 1918552 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_7                         3.0 0.0                       3.0                         3 0                 3
1918567 1918567 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_7                         4.0 6.0                       10.0                         4 6                 10
1924523 1924523 IN     school 1800107 4915   Tri-Township Cons School Corp 180010702520 4696 Wanatah School   Regular School No Elementary PK 08 2021   grade_7                         12.0 15.0                       27.0                         12 15                 27
1925676 1925676 IN     school 1804770 5385   Indianapolis Public Schools 180477000866 5531 James A Garfield School 31   Regular School No Elementary PK 08 2021   grade_7                         20.0 20.0                       40.0                         20 20                 40
1925715 1925715 IN     school 1804770 5385   Indianapolis Public Schools 180477000854 5543 James Whitcomb Riley School 43   Regular School No Elementary PK 08 2021   grade_7                         25.0 16.0                       41.0                         25 16                 41
1925728 1925728 IN     school 1804770 5385   Indianapolis Public Schools 180477000817 5546 Daniel Webster School 46   Regular School No Elementary PK 08 2021   grade_7                         24.0 21.0                       45.0                         24 21                 45
1925739 1925739 IN     school 1804770 5385   Indianapolis Public Schools 180477000904 5549 William Penn School 49   Regular School No Elementary PK 08 2021   grade_7                         36.0 37.0                       73.0                         36 37                 73
1925768 1925768 IN     school 1804770 5385   Indianapolis Public Schools 180477000822 5555 IPS/Butler Lab at Eliza Blaker 55   Regular School No Elementary PK 08 2021   grade_7                         14.0 14.0                       28.0                         14 14                 28
1925779 1925779 IN     school 1804770 5385   Indianapolis Public Schools 180477000831 5556 Francis W Parker School 56   Regular School No Elementary PK 08 2021   grade_7                         20.0 25.0                       45.0                         20 25                 45
1925790 1925790 IN     school 1804770 5385   Indianapolis Public Schools 180477000841 5557 George W Julian School 57   Regular School No Elementary PK 08 2021   grade_7                         13.0 7.0                       20.0                         13 7                 20
1925810 1925810 IN     school 1804770 5385   Indianapolis Public Schools 180477000901 5560 IPS/Butler Lab at William Bell 60   Regular School No Elementary PK 08 2021   grade_7                         35.0 26.0                       61.0                         35 26                 61
1925883 1925883 IN     school 1804770 5385   Indianapolis Public Schools 180477002555 5587 George Washington Carver School 87   Regular School No Elementary PK 08 2021   grade_7                         7.0 16.0                       23.0                         7 16                 23

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