enrollments

Data source: Big Local News · About: Big Local

7,359 rows where grade = "grade_1" and state = "IN" sorted by school_nces_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_1 · 7,359 ✖
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
1162375 1162375 IN     school 1800008 2980   White River Valley Sch Dist 180000802090 2460 Worthington Elementary School   Regular School No 1.0 PK 06 2015   grade_1                         23.0 8.0                       31.0                         23 8                 31
1283785 1283785 IN     school 1800008 2980   White River Valley Sch Dist 180000802090 2460 Worthington Elementary School   Regular School No 1.0 PK 06 2016   grade_1                         17.0 14.0                       31.0                         17 14                 31
1295822 1295822 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2017   grade_1                         24.0 28.0                       52.0                         24 28                 52
1754431 1754431 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2019   grade_1                         18.0 21.0                       39.0                         18 21                 39
1790168 1790168 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2018   grade_1                         25.0 26.0                       51.0                         25 26                 51
1909864 1909864 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2020   grade_1                         33.0 24.0                       57.0                         33 24                 57
1921817 1921817 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2021   grade_1                         30.0 23.0                       53.0                         30 23                 53
1162367 1162367 IN     school 1800008 2980   White River Valley Sch Dist 180000802304 2457 Lyons Elementary School   Regular School No 1.0 KG 06 2015   grade_1                         14.0 13.0                       27.0                         14 13                 27
1283777 1283777 IN     school 1800008 2980   White River Valley Sch Dist 180000802304 2457 Lyons Elementary School   Regular School No 1.0 KG 06 2016   grade_1                         14.0 12.0                       26.0                         14 12                 26
1170792 1170792 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2015   grade_1                         19.0 19.0                       38.0                         19 19                 38
1292169 1292169 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2016   grade_1                         31.0 18.0                       49.0                         31 18                 49
1304203 1304203 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other KG 12 2017   grade_1                         20.0 24.0                       44.0                         20 24                 44
1762842 1762842 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other PK 12 2019   grade_1                         19.0 24.0                       43.0                         19 24                 43
1798568 1798568 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other KG 12 2018   grade_1                         21.0 23.0                       44.0                         21 23                 44
1918305 1918305 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other PK 12 2020   grade_1                         25.0 20.0                       45.0                         25 20                 45
1930281 1930281 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other PK 12 2021   grade_1                         17.0 22.0                       39.0                         17 22                 39
1170831 1170831 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes 1.0 KG 08 2015   grade_1                         22.0 16.0                       38.0                         22 16                 38
1292207 1292207 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes 1.0 KG 08 2016   grade_1                         12.0 12.0                       24.0                         12 12                 24
1304240 1304240 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes Elementary KG 08 2017   grade_1                         17.0 11.0                       28.0                         17 11                 28
1170847 1170847 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes 1.0 KG 06 2015   grade_1                         19.0 21.0                       40.0                         19 21                 40
1292222 1292222 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes 1.0 KG 06 2016   grade_1                         26.0 27.0                       53.0                         26 27                 53
1304254 1304254 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes Elementary KG 06 2017   grade_1                         27.0 23.0                       50.0                         27 23                 50
1762885 1762885 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes Elementary KG 05 2019   grade_1                         33.0 25.0                       58.0                         33 25                 58
1798609 1798609 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes Elementary KG 06 2018   grade_1                         29.0 30.0                       59.0                         29 30                 59
1918346 1918346 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes Elementary KG 05 2020   grade_1                         30.0 25.0                       55.0                         30 25                 55
1930342 1930342 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes Elementary KG 05 2021   grade_1                         27.0 39.0                       66.0                         27 39                 66
1170811 1170811 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2015   grade_1                         37.0 35.0                       72.0                         37 35                 72
1292188 1292188 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2016   grade_1                         34.0 41.0                       75.0                         34 41                 75
1304222 1304222 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2017   grade_1                         41.0 34.0                       75.0                         41 34                 75
1762862 1762862 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2019   grade_1                         35.0 33.0                       68.0                         35 33                 68
1798587 1798587 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2018   grade_1                         33.0 41.0                       74.0                         33 41                 74
1918325 1918325 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2020   grade_1                         45.0 28.0                       73.0                         45 28                 73
1930320 1930320 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2021   grade_1                         36.0 36.0                       72.0                         36 36                 72
1170861 1170861 IN     school 1800015 9360   Veritas Academy 180001501786 1540 Veritas Academy   Regular School Yes 1.0 KG 08 2015   grade_1                         6.0 8.0                       14.0                         6 8                 14
1292235 1292235 IN     school 1800015 9360   Veritas Academy 180001501786 1540 Veritas Academy   Regular School Yes 1.0 KG 08 2016   grade_1                         6.0 5.0                       11.0                         6 5                 11
1304266 1304266 IN     school 1800015 9360   Veritas Academy 180001501786 1540 Veritas Academy   Regular School Yes Elementary KG 08 2017   grade_1                         9.0 5.0                       14.0                         9 5                 14
1170895 1170895 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes 4.0 KG 12 2015   grade_1                         34.0 19.0                       53.0                         34 19                 53
1292262 1292262 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes 4.0 KG 12 2016   grade_1                         31.0 25.0                       56.0                         31 25                 56
1304294 1304294 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2017   grade_1                         27.0 26.0                       53.0                         27 26                 53
1762906 1762906 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2019   grade_1                         27.0 26.0                       53.0                         27 26                 53
1798630 1798630 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2018   grade_1                         27.0 29.0                       56.0                         27 29                 56
1918368 1918368 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2020   grade_1                         33.0 20.0                       53.0                         33 20                 53
1930363 1930363 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2021   grade_1                         24.0 31.0                       55.0                         24 31                 55
1171052 1171052 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_1                         5.0 0.0                       5.0                         5 0                 5
1292429 1292429 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_1                         5.0 2.0                       7.0                         5 2                 7
1304462 1304462 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_1                         3.0 1.0                       4.0                         3 1                 4
1763074 1763074 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_1                         4.0 2.0                       6.0                         4 2                 6
1798804 1798804 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_1                         5.0 0.0                       5.0                         5 0                 5
1918543 1918543 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_1                         2.0 1.0                       3.0                         2 1                 3
1930538 1930538 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_1                         0.0 4.0                       4.0                         0 4                 4
1171067 1171067 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_1                         2.0 9.0                       11.0                         2 9                 11
1292444 1292444 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_1                         6.0 5.0                       11.0                         6 5                 11
1304477 1304477 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   grade_1                         5.0 4.0                       9.0                         5 4                 9
1763089 1763089 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_1                         5.0 18.0                       23.0                         5 18                 23
1798819 1798819 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_1                         13.0 8.0                       21.0                         13 8                 21
1918558 1918558 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_1                         10.0 10.0                       20.0                         10 10                 20
1930554 1930554 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_1                         5.0 8.0                       13.0                         5 8                 13
1170940 1170940 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes 4.0 KG 12 2015   grade_1                         51.0 42.0                       93.0                         51 42                 93
1292315 1292315 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes 4.0 KG 12 2016   grade_1                         55.0 40.0                       95.0                         55 40                 95
1304348 1304348 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2017   grade_1                         46.0 43.0                       89.0                         46 43                 89
1762962 1762962 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2019   grade_1                         39.0 32.0                       71.0                         39 32                 71
1798689 1798689 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2018   grade_1                         39.0 30.0                       69.0                         39 30                 69
1918430 1918430 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2020   grade_1                         29.0 40.0                       69.0                         29 40                 69
1930426 1930426 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2021   grade_1                         22.0 34.0                       56.0                         22 34                 56
1170773 1170773 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_1                         31.0 24.0                       55.0                         31 24                 55
1292154 1292154 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_1                         31.0 27.0                       58.0                         31 27                 58
1304188 1304188 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2017   grade_1                         33.0 28.0                       61.0                         33 28                 61
1762827 1762827 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2019   grade_1                         22.0 37.0                       59.0                         22 37                 59
1798553 1798553 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2018   grade_1                         27.0 38.0                       65.0                         27 38                 65
1918290 1918290 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2020   grade_1                         34.0 42.0                       76.0                         34 42                 76
1930266 1930266 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2021   grade_1                         42.0 38.0                       80.0                         42 38                 80
1159515 1159515 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_1                         27.0 28.0                       55.0                         27 28                 55
1280905 1280905 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_1                         42.0 27.0                       69.0                         42 27                 69
1292967 1292967 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2017   grade_1                         33.0 22.0                       55.0                         33 22                 55
1751599 1751599 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2019   grade_1                         34.0 26.0                       60.0                         34 26                 60
1787340 1787340 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2018   grade_1                         35.0 27.0                       62.0                         35 27                 62
1907040 1907040 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2020   grade_1                         36.0 22.0                       58.0                         36 22                 58
1919006 1919006 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2021   grade_1                         24.0 31.0                       55.0                         24 31                 55
1159522 1159522 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_1                         43.0 38.0                       81.0                         43 38                 81
1280912 1280912 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_1                         39.0 41.0                       80.0                         39 41                 80
1292974 1292974 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_1                         42.0 39.0                       81.0                         42 39                 81
1751606 1751606 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_1                         48.0 39.0                       87.0                         48 39                 87
1787347 1787347 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_1                         38.0 40.0                       78.0                         38 40                 78
1907047 1907047 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_1                         37.0 46.0                       83.0                         37 46                 83
1919013 1919013 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2021   grade_1                         55.0 38.0                       93.0                         55 38                 93
1159564 1159564 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_1                         53.0 70.0                       123.0                         53 70                 123
1280954 1280954 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_1                         71.0 63.0                       134.0                         71 63                 134
1293016 1293016 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2017   grade_1                         67.0 64.0                       131.0                         67 64                 131
1751648 1751648 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2019   grade_1                         94.0 61.0                       155.0                         94 61                 155
1787389 1787389 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2018   grade_1                         60.0 70.0                       130.0                         60 70                 130
1907089 1907089 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2020   grade_1                         78.0 55.0                       133.0                         78 55                 133
1919055 1919055 IN     school 1800030 125   MSD Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2021   grade_1                         80.0 72.0                       152.0                         80 72                 152
1159539 1159539 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_1                         54.0 32.0                       86.0                         54 32                 86
1280929 1280929 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_1                         46.0 42.0                       88.0                         46 42                 88
1292991 1292991 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2017   grade_1                         61.0 48.0                       109.0                         61 48                 109
1751623 1751623 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2019   grade_1                         56.0 49.0                       105.0                         56 49                 105
1787364 1787364 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2018   grade_1                         42.0 44.0                       86.0                         42 44                 86
1907064 1907064 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2020   grade_1                         51.0 48.0                       99.0                         51 48                 99
1919030 1919030 IN     school 1800030 125   MSD Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2021   grade_1                         56.0 41.0                       97.0                         56 41                 97
1159550 1159550 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         27.0 31.0                       58.0                         27 31                 58

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