enrollments

Data source: Big Local News · About: Big Local

7,371 rows where grade = "grade_2" and state = "IN" sorted by school_nces_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_2 · 7,371 ✖
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
1162376 1162376 IN     school 1800008 2980   White River Valley Sch Dist 180000802090 2460 Worthington Elementary School   Regular School No 1.0 PK 06 2015   grade_2                         8.0 16.0                       24.0                         8 16                 24
1283786 1283786 IN     school 1800008 2980   White River Valley Sch Dist 180000802090 2460 Worthington Elementary School   Regular School No 1.0 PK 06 2016   grade_2                         22.0 9.0                       31.0                         22 9                 31
1295823 1295823 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2017   grade_2                         35.0 24.0                       59.0                         35 24                 59
1754432 1754432 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2019   grade_2                         27.0 28.0                       55.0                         27 28                 55
1790169 1790169 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2018   grade_2                         23.0 29.0                       52.0                         23 29                 52
1909865 1909865 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2020   grade_2                         19.0 22.0                       41.0                         19 22                 41
1921818 1921818 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2021   grade_2                         32.0 19.0                       51.0                         32 19                 51
1162368 1162368 IN     school 1800008 2980   White River Valley Sch Dist 180000802304 2457 Lyons Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         10.0 17.0                       27.0                         10 17                 27
1283778 1283778 IN     school 1800008 2980   White River Valley Sch Dist 180000802304 2457 Lyons Elementary School   Regular School No 1.0 KG 06 2016   grade_2                         10.0 13.0                       23.0                         10 13                 23
1170796 1170796 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2015   grade_2                         19.0 23.0                       42.0                         19 23                 42
1292173 1292173 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2016   grade_2                         17.0 20.0                       37.0                         17 20                 37
1304207 1304207 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other KG 12 2017   grade_2                         30.0 17.0                       47.0                         30 17                 47
1762846 1762846 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other PK 12 2019   grade_2                         20.0 23.0                       43.0                         20 23                 43
1798572 1798572 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other KG 12 2018   grade_2                         18.0 20.0                       38.0                         18 20                 38
1918309 1918309 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other PK 12 2020   grade_2                         17.0 25.0                       42.0                         17 25                 42
1930285 1930285 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other PK 12 2021   grade_2                         24.0 18.0                       42.0                         24 18                 42
1170832 1170832 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes 1.0 KG 08 2015   grade_2                         21.0 14.0                       35.0                         21 14                 35
1292208 1292208 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes 1.0 KG 08 2016   grade_2                         17.0 12.0                       29.0                         17 12                 29
1304241 1304241 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes Elementary KG 08 2017   grade_2                         6.0 10.0                       16.0                         6 10                 16
1170848 1170848 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes 1.0 KG 06 2015   grade_2                         26.0 22.0                       48.0                         26 22                 48
1292223 1292223 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes 1.0 KG 06 2016   grade_2                         21.0 19.0                       40.0                         21 19                 40
1304255 1304255 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes Elementary KG 06 2017   grade_2                         22.0 26.0                       48.0                         22 26                 48
1762886 1762886 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes Elementary KG 05 2019   grade_2                         29.0 37.0                       66.0                         29 37                 66
1798610 1798610 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes Elementary KG 06 2018   grade_2                         29.0 19.0                       48.0                         29 19                 48
1918347 1918347 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes Elementary KG 05 2020   grade_2                         33.0 33.0                       66.0                         33 33                 66
1930343 1930343 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes Elementary KG 05 2021   grade_2                         30.0 27.0                       57.0                         30 27                 57
1170815 1170815 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2015   grade_2                         32.0 41.0                       73.0                         32 41                 73
1292192 1292192 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2016   grade_2                         38.0 37.0                       75.0                         38 37                 75
1304226 1304226 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2017   grade_2                         35.0 40.0                       75.0                         35 40                 75
1762866 1762866 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2019   grade_2                         25.0 43.0                       68.0                         25 43                 68
1798591 1798591 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2018   grade_2                         39.0 30.0                       69.0                         39 30                 69
1918329 1918329 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2020   grade_2                         34.0 33.0                       67.0                         34 33                 67
1930324 1930324 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2021   grade_2                         39.0 28.0                       67.0                         39 28                 67
1170862 1170862 IN     school 1800015 9360   Veritas Academy 180001501786 1540 Veritas Academy   Regular School Yes 1.0 KG 08 2015   grade_2                         8.0 4.0                       12.0                         8 4                 12
1292236 1292236 IN     school 1800015 9360   Veritas Academy 180001501786 1540 Veritas Academy   Regular School Yes 1.0 KG 08 2016   grade_2                         4.0 5.0                       9.0                         4 5                 9
1304267 1304267 IN     school 1800015 9360   Veritas Academy 180001501786 1540 Veritas Academy   Regular School Yes Elementary KG 08 2017   grade_2                         1.0 1.0                       2.0                         1 1                 2
1170899 1170899 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes 4.0 KG 12 2015   grade_2                         14.0 39.0                       53.0                         14 39                 53
1292266 1292266 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes 4.0 KG 12 2016   grade_2                         35.0 19.0                       54.0                         35 19                 54
1304298 1304298 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2017   grade_2                         28.0 26.0                       54.0                         28 26                 54
1762910 1762910 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2019   grade_2                         25.0 30.0                       55.0                         25 30                 55
1798634 1798634 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2018   grade_2                         25.0 29.0                       54.0                         25 29                 54
1918372 1918372 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2020   grade_2                         21.0 33.0                       54.0                         21 33                 54
1930367 1930367 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2021   grade_2                         30.0 26.0                       56.0                         30 26                 56
1171056 1171056 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_2                         2.0 0.0                       2.0                         2 0                 2
1292433 1292433 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_2                         2.0 1.0                       3.0                         2 1                 3
1304466 1304466 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_2                         4.0 3.0                       7.0                         4 3                 7
1763078 1763078 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_2                         7.0 0.0                       7.0                         7 0                 7
1798808 1798808 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_2                         2.0 1.0                       3.0                         2 1                 3
1918547 1918547 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_2                         5.0 3.0                       8.0                         5 3                 8
1930542 1930542 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_2                         2.0 2.0                       4.0                         2 2                 4
1171071 1171071 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_2                         10.0 11.0                       21.0                         10 11                 21
1292448 1292448 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_2                         3.0 9.0                       12.0                         3 9                 12
1304481 1304481 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   grade_2                         6.0 4.0                       10.0                         6 4                 10
1763093 1763093 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_2                         14.0 7.0                       21.0                         14 7                 21
1798823 1798823 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_2                         8.0 9.0                       17.0                         8 9                 17
1918562 1918562 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_2                         7.0 20.0                       27.0                         7 20                 27
1930558 1930558 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_2                         9.0 10.0                       19.0                         9 10                 19
1170944 1170944 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes 4.0 KG 12 2015   grade_2                         50.0 56.0                       106.0                         50 56                 106
1292319 1292319 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes 4.0 KG 12 2016   grade_2                         54.0 41.0                       95.0                         54 41                 95
1304352 1304352 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2017   grade_2                         47.0 36.0                       83.0                         47 36                 83
1762966 1762966 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2019   grade_2                         41.0 29.0                       70.0                         41 29                 70
1798693 1798693 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2018   grade_2                         43.0 36.0                       79.0                         43 36                 79
1918434 1918434 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2020   grade_2                         46.0 35.0                       81.0                         46 35                 81
1930430 1930430 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2021   grade_2                         22.0 30.0                       52.0                         22 30                 52
1170777 1170777 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_2                         29.0 20.0                       49.0                         29 20                 49
1292155 1292155 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_2                         33.0 27.0                       60.0                         33 27                 60
1304189 1304189 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2017   grade_2                         30.0 26.0                       56.0                         30 26                 56
1762828 1762828 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2019   grade_2                         30.0 41.0                       71.0                         30 41                 71
1798554 1798554 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2018   grade_2                         30.0 44.0                       74.0                         30 44                 74
1918291 1918291 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2020   grade_2                         29.0 40.0                       69.0                         29 40                 69
1930267 1930267 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2021   grade_2                         32.0 46.0                       78.0                         32 46                 78
1159516 1159516 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_2                         55.0 42.0                       97.0                         55 42                 97
1280906 1280906 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_2                         36.0 42.0                       78.0                         36 42                 78
1292968 1292968 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2017   grade_2                         47.0 38.0                       85.0                         47 38                 85
1751600 1751600 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2019   grade_2                         44.0 40.0                       84.0                         44 40                 84
1787341 1787341 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2018   grade_2                         48.0 34.0                       82.0                         48 34                 82
1907041 1907041 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2020   grade_2                         44.0 33.0                       77.0                         44 33                 77
1919007 1919007 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2021   grade_2                         36.0 29.0                       65.0                         36 29                 65
1159523 1159523 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_2                         34.0 45.0                       79.0                         34 45                 79
1280913 1280913 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_2                         46.0 34.0                       80.0                         46 34                 80
1292975 1292975 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_2                         35.0 37.0                       72.0                         35 37                 72
1751607 1751607 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_2                         43.0 45.0                       88.0                         43 45                 88
1787348 1787348 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_2                         44.0 39.0                       83.0                         44 39                 83
1907048 1907048 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_2                         48.0 41.0                       89.0                         48 41                 89
1919014 1919014 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2021   grade_2                         35.0 41.0                       76.0                         35 41                 76
1159565 1159565 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_2                         58.0 59.0                       117.0                         58 59                 117
1280955 1280955 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_2                         55.0 73.0                       128.0                         55 73                 128
1293017 1293017 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2017   grade_2                         73.0 63.0                       136.0                         73 63                 136
1751649 1751649 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2019   grade_2                         60.0 70.0                       130.0                         60 70                 130
1787390 1787390 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2018   grade_2                         68.0 59.0                       127.0                         68 59                 127
1907090 1907090 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2020   grade_2                         88.0 60.0                       148.0                         88 60                 148
1919056 1919056 IN     school 1800030 125   MSD Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2021   grade_2                         79.0 55.0                       134.0                         79 55                 134
1159540 1159540 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_2                         44.0 37.0                       81.0                         44 37                 81
1280930 1280930 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_2                         53.0 34.0                       87.0                         53 34                 87
1292992 1292992 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2017   grade_2                         40.0 44.0                       84.0                         40 44                 84
1751624 1751624 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2019   grade_2                         47.0 48.0                       95.0                         47 48                 95
1787365 1787365 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2018   grade_2                         59.0 46.0                       105.0                         59 46                 105
1907065 1907065 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2020   grade_2                         66.0 62.0                       128.0                         66 62                 128
1919031 1919031 IN     school 1800030 125   MSD Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2021   grade_2                         63.0 47.0                       110.0                         63 47                 110
1159551 1159551 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_2                         26.0 28.0                       54.0                         26 28                 54

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