Data source: Big Local News · About: Big Local

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

View and edit SQL

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
1162379 IN     school 1800008 2980   White River Valley Sch Dist 180000802090 2460 Worthington Elementary School   Regular School No 1.0 PK 06 2015   grade_5                         21.0 14.0                       35.0                         21 14                 35
1283789 IN     school 1800008 2980   White River Valley Sch Dist 180000802090 2460 Worthington Elementary School   Regular School No 1.0 PK 06 2016   grade_5                         15.0 10.0                       25.0                         15 10                 25
1162371 IN     school 1800008 2980   White River Valley Sch Dist 180000802304 2457 Lyons Elementary School   Regular School No 1.0 KG 06 2015   grade_5                         13.0 9.0                       22.0                         13 9                 22
1283781 IN     school 1800008 2980   White River Valley Sch Dist 180000802304 2457 Lyons Elementary School   Regular School No 1.0 KG 06 2016   grade_5                         13.0 10.0                       23.0                         13 10                 23
1295818 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 07 2017   grade_5                         31.0 22.0                       53.0                         31 22                 53
1754426 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 08 2019   grade_5                         30.0 23.0                       53.0                         30 23                 53
1790163 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 08 2018   grade_5                         15.0 32.0                       47.0                         15 32                 47
1909859 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 08 2020   grade_5                         33.0 29.0                       62.0                         33 29                 62
1921812 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 08 2021   grade_5                         27.0 26.0                       53.0                         27 26                 53
1170799 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2015   grade_5                         21.0 25.0                       46.0                         21 25                 46
1292176 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2016   grade_5                         21.0 20.0                       41.0                         21 20                 41
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
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
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
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
1930288 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other PK 12 2021   grade_5                         24.0 20.0                       44.0                         24 20                 44
1170835 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes 1.0 KG 08 2015   grade_5                         13.0 13.0                       26.0                         13 13                 26
1292211 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes 1.0 KG 08 2016   grade_5                         18.0 10.0                       28.0                         18 10                 28
1304244 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes Elementary KG 08 2017   grade_5                         6.0 3.0                       9.0                         6 3                 9
1170851 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes 1.0 KG 06 2015   grade_5                         11.0 12.0                       23.0                         11 12                 23
1292226 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes 1.0 KG 06 2016   grade_5                         21.0 11.0                       32.0                         21 11                 32
1304258 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes Elementary KG 06 2017   grade_5                         22.0 22.0                       44.0                         22 22                 44
1762889 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes Elementary KG 05 2019   grade_5                         19.0 20.0                       39.0                         19 20                 39
1798613 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes Elementary KG 06 2018   grade_5                         13.0 9.0                       22.0                         13 9                 22
1918350 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes Elementary KG 05 2020   grade_5                         21.0 28.0                       49.0                         21 28                 49
1930346 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes Elementary KG 05 2021   grade_5                         34.0 29.0                       63.0                         34 29                 63
1170818 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2015   grade_5                         41.0 34.0                       75.0                         41 34                 75
1292195 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2016   grade_5                         32.0 43.0                       75.0                         32 43                 75
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
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
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
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
1930327 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2021   grade_5                         34.0 32.0                       66.0                         34 32                 66
1170865 IN     school 1800015 9360   Veritas Academy 180001501786 1540 Veritas Academy   Regular School Yes 1.0 KG 08 2015   grade_5                         7.0 5.0                       12.0                         7 5                 12
1292239 IN     school 1800015 9360   Veritas Academy 180001501786 1540 Veritas Academy   Regular School Yes 1.0 KG 08 2016   grade_5                         5.0 8.0                       13.0                         5 8                 13
1304270 IN     school 1800015 9360   Veritas Academy 180001501786 1540 Veritas Academy   Regular School Yes Elementary KG 08 2017   grade_5                         8.0 3.0                       11.0                         8 3                 11
1170902 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes 4.0 KG 12 2015   grade_5                         28.0 26.0                       54.0                         28 26                 54
1292269 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes 4.0 KG 12 2016   grade_5                         26.0 22.0                       48.0                         26 22                 48
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
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
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
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
1930370 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2021   grade_5                         24.0 27.0                       51.0                         24 27                 51
1171059 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_5                         3.0 5.0                       8.0                         3 5                 8
1292436 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_5                         7.0 2.0                       9.0                         7 2                 9
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
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
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
1918550 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_5                         3.0 3.0                       6.0                         3 3                 6
1930545 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_5                         4.0 2.0                       6.0                         4 2                 6
1171074 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_5                         7.0 15.0                       22.0                         7 15                 22
1292451 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_5                         8.0 8.0                       16.0                         8 8                 16
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
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
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
1918565 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_5                         8.0 7.0                       15.0                         8 7                 15
1930561 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_5                         8.0 10.0                       18.0                         8 10                 18
1170947 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes 4.0 KG 12 2015   grade_5                         39.0 54.0                       93.0                         39 54                 93
1292322 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes 4.0 KG 12 2016   grade_5                         45.0 47.0                       92.0                         45 47                 92
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
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
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
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
1930433 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2021   grade_5                         36.0 45.0                       81.0                         36 45                 81
1170780 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes 4.0 KG 12 2015   grade_5                         20.0 31.0                       51.0                         20 31                 51
1292158 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes 1.0 KG 08 2016   grade_5                         29.0 29.0                       58.0                         29 29                 58
1304192 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2017   grade_5                         21.0 25.0                       46.0                         21 25                 46
1762831 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2019   grade_5                         36.0 22.0                       58.0                         36 22                 58
1798557 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2018   grade_5                         30.0 27.0                       57.0                         30 27                 57
1918294 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2020   grade_5                         31.0 46.0                       77.0                         31 46                 77
1930270 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2021   grade_5                         41.0 39.0                       80.0                         41 39                 80
1170918 IN     school 1800028 9400   KIPP Indpls College Preparatory 180002802136 5860 KIPP Indy College Prep Middle   Regular School Yes 2.0 05 08 2015   grade_5                         38.0 22.0                       60.0                         38 22                 60
1292286 IN     school 1800028 9400   KIPP Indpls College Preparatory 180002802136 5860 KIPP Indy College Prep Middle   Regular School Yes 2.0 05 08 2016   grade_5                         34.0 19.0                       53.0                         34 19                 53
1159519 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         59.0 64.0                       123.0                         59 64                 123
1280909 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         49.0 50.0                       99.0                         49 50                 99
1292971 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2017   grade_5                         53.0 45.0                       98.0                         53 45                 98
1751603 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2019   grade_5                         44.0 49.0                       93.0                         44 49                 93
1787344 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2018   grade_5                         68.0 52.0                       120.0                         68 52                 120
1907044 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2020   grade_5                         50.0 46.0                       96.0                         50 46                 96
1919010 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2021   grade_5                         57.0 43.0                       100.0                         57 43                 100
1159526 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elem Sch   Regular School No 1.0 PK 05 2015   grade_5                         34.0 38.0                       72.0                         34 38                 72
1280916 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elem Sch   Regular School No 1.0 PK 05 2016   grade_5                         39.0 34.0                       73.0                         39 34                 73
1292978 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2017   grade_5                         26.0 42.0                       68.0                         26 42                 68
1751610 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2019   grade_5                         55.0 35.0                       90.0                         55 35                 90
1787351 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2018   grade_5                         40.0 35.0                       75.0                         40 35                 75
1907051 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2020   grade_5                         51.0 41.0                       92.0                         51 41                 92
1919017 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2021   grade_5                         50.0 42.0                       92.0                         50 42                 92
1159568 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         75.0 78.0                       153.0                         75 78                 153
1280958 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         71.0 55.0                       126.0                         71 55                 126
1293020 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2017   grade_5                         58.0 80.0                       138.0                         58 80                 138
1751652 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2019   grade_5                         65.0 75.0                       140.0                         65 75                 140
1787393 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2018   grade_5                         60.0 77.0                       137.0                         60 77                 137
1907093 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2020   grade_5                         76.0 66.0                       142.0                         76 66                 142
1919059 IN     school 1800030 125   MSD Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2021   grade_5                         56.0 62.0                       118.0                         56 62                 118
1159543 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No 1.0 KG 05 2015   grade_5                         58.0 42.0                       100.0                         58 42                 100
1280933 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No 1.0 KG 05 2016   grade_5                         39.0 35.0                       74.0                         39 35                 74
1292995 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2017   grade_5                         42.0 52.0                       94.0                         42 52                 94
1751627 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2019   grade_5                         52.0 41.0                       93.0                         52 41                 93
1787368 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2018   grade_5                         57.0 40.0                       97.0                         57 40                 97
1907068 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2020   grade_5                         57.0 60.0                       117.0                         57 60                 117

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