enrollments

Data source: Big Local News · About: Big Local

6,726 rows where grade = "grade_5" and state = "IN" sorted by ccd_school_lvl descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_5 · 6,726 ✖
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
1922624 1922624 IN     school 1808970 3330   Plainfield Community School Corp 180897002694 3331 Pride Academy   Regular School No Secondary 05 11 2021   grade_5                         5.0 0.0                       5.0                         5 0                 5
1293089 1293089 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Other 05 11 2017   grade_5                         1.0 0.0                       1.0                         1 0                 1
1294141 1294141 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No Other 04 12 2017   grade_5                         1.0 1.0                       2.0                         1 1                 2
1294813 1294813 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 02 12 2017   grade_5                         4.0 2.0                       6.0                         4 2                 6
1295012 1295012 IN     school 1806600 2275   Middlebury Community Schools 180660001162 1657 Northridge Middle School   Regular School No Other 05 10 2017   grade_5                         2.0 1.0                       3.0                         2 1                 3
1295136 1295136 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2017   grade_5                         3.0 0.0                       3.0                         3 0                 3
1301211 1301211 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elementary & High School   Regular School No Other PK 12 2017   grade_5                         7.0 8.0                       15.0                         7 8                 15
1302106 1302106 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Oaklawn Campus Program   Special Education School No Other 03 12 2017   grade_5                         1.0 0.0                       1.0                         1 0                 1
1302511 1302511 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other KG 12 2017   grade_5                         1.0 1.0                       2.0                         1 1                 2
1303151 1303151 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other KG 12 2017   grade_5                         8.0 0.0                       8.0                         8 0                 8
1303927 1303927 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other 01 12 2017   grade_5                         2.0 0.0                       2.0                         2 0                 2
1304210 1304210 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other KG 12 2017   grade_5                         19.0 25.0                       44.0                         19 25                 44
1304229 1304229 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2017   grade_5                         42.0 33.0                       75.0                         42 33                 75
1304301 1304301 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2017   grade_5                         25.0 29.0                       54.0                         25 29                 54
1304355 1304355 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2017   grade_5                         44.0 47.0                       91.0                         44 47                 91
1304407 1304407 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes Other KG 12 2017   grade_5                         43.0 66.0                       109.0                         43 66                 109
1304421 1304421 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_5                         38.0 23.0                       61.0                         38 23                 61
1304445 1304445 IN     school 1800051 9575   Indpls Lighthouse Charter School 180005102165 5523 Indpls Lighthouse Charter School   Regular School Yes Other KG 12 2017   grade_5                         38.0 48.0                       86.0                         38 48                 86
1304469 1304469 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_5                         3.0 3.0                       6.0                         3 3                 6
1304484 1304484 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   grade_5                         9.0 14.0                       23.0                         9 14                 23
1304509 1304509 IN     school 1800038 9620   Burris Laboratory School 180003800185 1441 Burris Laboratory School   Regular School No Other KG 12 2017   grade_5                         22.0 26.0                       48.0                         22 26                 48
1304669 1304669 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes Other 04 12 2017   grade_5                         6.0 0.0                       6.0                         6 0                 6
1304704 1304704 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2017   grade_5                         34.0 24.0                       58.0                         34 24                 58
1304726 1304726 IN     school 1800072 9805   Hoosier Academy - Indianapolis 180007202422 2527 Hoosier Academy - Indianapolis   Regular School Yes Other KG 12 2017   grade_5                         10.0 13.0                       23.0                         10 13                 23
1304769 1304769 IN     school 1800081 9865   Hoosier Acad Virtual Charter 180008102458 5290 Hoosier Acad Virtual Charter Sch   Regular School Yes Other KG 12 2017   grade_5                         99.0 94.0                       193.0                         99 94                 193
1304793 1304793 IN     school 1800099 9875   Rock Creek Community Academy 180009902497 771 Rock Creek Community Academy   Regular School Yes Other KG 12 2017   grade_5                         25.0 24.0                       49.0                         25 24                 49
1304826 1304826 IN     school 1800094 9895   IN Math & Science Academy - North 180009402487 5444 IN Math & Science Academy - North   Regular School Yes Other KG 12 2017   grade_5                         19.0 21.0                       40.0                         19 21                 40
1304844 1304844 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes Other KG 12 2017   grade_5                         80.0 81.0                       161.0                         80 81                 161
1304870 1304870 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other KG 12 2017   grade_5                         10.0 0.0                       10.0                         10 0                 10
1304917 1304917 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2017   grade_5                         13.0 11.0                       24.0                         13 11                 24
1753741 1753741 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 02 12 2019   grade_5                         5.0 0.0                       5.0                         5 0                 5
1755175 1755175 IN     school 1802550 3325   Danville Community School Corp 180255000305 2743 Danville Middle School   Regular School No Other 04 09 2019   grade_5                         107.0 102.0                       209.0                         107 102                 209
1758279 1758279 IN     school 1804770 5385   Indianapolis Public Schools 180477002651 108 Impact Academy   Regular School No Other 03 12 2019   grade_5                         4.0 2.0                       6.0                         4 2                 6
1759704 1759704 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elementary & High School   Regular School No Other PK 12 2019   grade_5                         5.0 3.0                       8.0                         5 3                 8
1761009 1761009 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other PK 12 2019   grade_5                         2.0 1.0                       3.0                         2 1                 3
1761662 1761662 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2019   grade_5                         10.0 1.0                       11.0                         10 1                 11
1761673 1761673 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002649 8271 Harwood Career Prep High School   Regular School No Other 01 12 2019   grade_5                         1.0 0.0                       1.0                         1 0                 1
1762465 1762465 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other KG 12 2019   grade_5                         7.0 0.0                       7.0                         7 0                 7
1762849 1762849 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other PK 12 2019   grade_5                         21.0 22.0                       43.0                         21 22                 43
1762869 1762869 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2019   grade_5                         33.0 43.0                       76.0                         33 43                 76
1762913 1762913 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2019   grade_5                         27.0 27.0                       54.0                         27 27                 54
1762969 1762969 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2019   grade_5                         37.0 38.0                       75.0                         37 38                 75
1763018 1763018 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes Other KG 12 2019   grade_5                         57.0 41.0                       98.0                         57 41                 98
1763032 1763032 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_5                         25.0 30.0                       55.0                         25 30                 55
1763056 1763056 IN     school 1800051 9575   Indpls Lighthouse Charter School 180005102165 5523 Indpls Lighthouse Charter School   Regular School Yes Other KG 12 2019   grade_5                         41.0 39.0                       80.0                         41 39                 80
1763081 1763081 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_5                         5.0 2.0                       7.0                         5 2                 7
1763096 1763096 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_5                         10.0 8.0                       18.0                         10 8                 18
1763121 1763121 IN     school 1800038 9620   Burris Laboratory School 180003800185 1441 Burris Laboratory School   Regular School No Other KG 12 2019   grade_5                         25.0 23.0                       48.0                         25 23                 48
1763248 1763248 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes Other 04 12 2019   grade_5                         3.0 0.0                       3.0                         3 0                 3
1763286 1763286 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2019   grade_5                         29.0 24.0                       53.0                         29 24                 53
1763308 1763308 IN     school 1800072 9805   Hoosier Academy - Indianapolis 180007202422 2527 Hoosier Academy - Indianapolis   Regular School Yes Other KG 12 2019   grade_5                         8.0 12.0                       20.0                         8 12                 20
1763348 1763348 IN     school 1800099 9875   Rock Creek Community Academy 180009902497 771 Rock Creek Community Academy   Regular School Yes Other KG 12 2019   grade_5                         20.0 25.0                       45.0                         20 25                 45
1763381 1763381 IN     school 1800094 9895   IN Math & Science Academy - North 180009402487 5444 IN Math & Science Academy - North   Regular School Yes Other KG 12 2019   grade_5                         25.0 22.0                       47.0                         25 22                 47
1763398 1763398 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes Other KG 12 2019   grade_5                         115.0 93.0                       208.0                         115 93                 208
1763424 1763424 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other KG 12 2019   grade_5                         12.0 1.0                       13.0                         12 1                 13
1763467 1763467 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2019   grade_5                         9.0 9.0                       18.0                         9 9                 18
1763518 1763518 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 10 2019   grade_5                         14.0 16.0                       30.0                         14 16                 30
1789156 1789156 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 03 12 2018   grade_5                         3.0 2.0                       5.0                         3 2                 5
1789355 1789355 IN     school 1806600 2275   Middlebury Community Schools 180660001162 1657 Northridge Middle School   Regular School No Other 04 11 2018   grade_5                         1.0 0.0                       1.0                         1 0                 1
1789481 1789481 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2018   grade_5                         3.0 0.0                       3.0                         3 0                 3
1795528 1795528 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elementary & High School   Regular School No Other PK 12 2018   grade_5                         8.0 9.0                       17.0                         8 9                 17
1796423 1796423 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Oaklawn Campus Program   Special Education School No Other 03 12 2018   grade_5                         3.0 0.0                       3.0                         3 0                 3
1797467 1797467 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2018   grade_5                         7.0 2.0                       9.0                         7 2                 9
1798249 1798249 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other KG 12 2018   grade_5                         8.0 1.0                       9.0                         8 1                 9
1798575 1798575 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other KG 12 2018   grade_5                         22.0 24.0                       46.0                         22 24                 46
1798594 1798594 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2018   grade_5                         30.0 40.0                       70.0                         30 40                 70
1798637 1798637 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2018   grade_5                         18.0 36.0                       54.0                         18 36                 54
1798696 1798696 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2018   grade_5                         42.0 43.0                       85.0                         42 43                 85
1798748 1798748 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes Other KG 12 2018   grade_5                         55.0 55.0                       110.0                         55 55                 110
1798762 1798762 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_5                         28.0 34.0                       62.0                         28 34                 62
1798786 1798786 IN     school 1800051 9575   Indpls Lighthouse Charter School 180005102165 5523 Indpls Lighthouse Charter School   Regular School Yes Other KG 12 2018   grade_5                         47.0 46.0                       93.0                         47 46                 93
1798811 1798811 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_5                         3.0 2.0                       5.0                         3 2                 5
1798826 1798826 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_5                         5.0 8.0                       13.0                         5 8                 13
1798851 1798851 IN     school 1800038 9620   Burris Laboratory School 180003800185 1441 Burris Laboratory School   Regular School No Other KG 12 2018   grade_5                         24.0 24.0                       48.0                         24 24                 48
1798994 1798994 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes Other 04 12 2018   grade_5                         6.0 0.0                       6.0                         6 0                 6
1799031 1799031 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2018   grade_5                         31.0 21.0                       52.0                         31 21                 52
1799053 1799053 IN     school 1800072 9805   Hoosier Academy - Indianapolis 180007202422 2527 Hoosier Academy - Indianapolis   Regular School Yes Other KG 12 2018   grade_5                         5.0 7.0                       12.0                         5 7                 12
1799096 1799096 IN     school 1800081 9865   Hoosier Acad Virtual Charter 180008102458 5290 Hoosier Acad Virtual Charter Sch   Regular School Yes Other KG 12 2018   grade_5                         56.0 55.0                       111.0                         56 55                 111
1799120 1799120 IN     school 1800099 9875   Rock Creek Community Academy 180009902497 771 Rock Creek Community Academy   Regular School Yes Other KG 12 2018   grade_5                         20.0 18.0                       38.0                         20 18                 38
1799152 1799152 IN     school 1800094 9895   IN Math & Science Academy - North 180009402487 5444 IN Math & Science Academy - North   Regular School Yes Other KG 12 2018   grade_5                         33.0 23.0                       56.0                         33 23                 56
1799169 1799169 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes Other KG 12 2018   grade_5                         97.0 103.0                       200.0                         97 103                 200
1799195 1799195 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other KG 12 2018   grade_5                         9.0 2.0                       11.0                         9 2                 11
1799243 1799243 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2018   grade_5                         7.0 12.0                       19.0                         7 12                 19
1799287 1799287 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 09 2018   grade_5                         12.0 11.0                       23.0                         12 11                 23
1908001 1908001 IN     school 1806030 875   Logansport Community Sch Corp 180603001052 715 Columbia 6th Grade Academy   Regular School No Other 02 09 2020   grade_5                         1.0 0.0                       1.0                         1 0                 1
1909173 1909173 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other KG 12 2020   grade_5                         4.0 1.0                       5.0                         4 1                 5
1910621 1910621 IN     school 1802550 3325   Danville Community School Corp 180255000305 2743 Danville Middle School   Regular School No Other 04 09 2020   grade_5                         98.0 100.0                       198.0                         98 100                 198
1912191 1912191 IN     school 1803870 4690   Gary Community School Corp 180387002684 4068 Gary Virtual Academy   Regular School No Other 02 09 2020   grade_5                         1.0 1.0                       2.0                         1 1                 2
1913709 1913709 IN     school 1804770 5385   Indianapolis Public Schools 180477002651 108 Impact Academy   Regular School No Other 03 12 2020   grade_5                         2.0 0.0                       2.0                         2 0                 2
1915115 1915115 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elementary & High School   Regular School No Other PK 12 2020   grade_5                         8.0 9.0                       17.0                         8 9                 17
1916418 1916418 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other 01 12 2020   grade_5                         0.0 2.0                       2.0                         0 2                 2
1917068 1917068 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2020   grade_5                         4.0 4.0                       8.0                         4 4                 8
1917078 1917078 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002649 8271 Harwood Career Prep High School   Regular School No Other 02 12 2020   grade_5                         4.0 1.0                       5.0                         4 1                 5
1917885 1917885 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other KG 12 2020   grade_5                         7.0 0.0                       7.0                         7 0                 7
1918110 1918110 IN     school 1800205 8690   Dynamic Minds Academy 180020502673 8692 Dynamic Minds Academy   Regular School Yes Other KG 12 2020   grade_5                         8.0 1.0                       9.0                         8 1                 9
1918312 1918312 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other PK 12 2020   grade_5                         27.0 16.0                       43.0                         27 16                 43
1918332 1918332 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2020   grade_5                         37.0 39.0                       76.0                         37 39                 76
1918375 1918375 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2020   grade_5                         27.0 28.0                       55.0                         27 28                 55
1918437 1918437 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2020   grade_5                         33.0 35.0                       68.0                         33 35                 68
1918487 1918487 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes Other KG 12 2020   grade_5                         50.0 47.0                       97.0                         50 47                 97

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