enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
1762744 1762744 IN     school 1800202 9085   pilotED Schools 180020202661 1006 pilotED Schools Bethel Park   Regular School Yes Elementary KG 02 2019   grade_2                         7.0 13.0                       20.0                         7 13                 20
1918202 1918202 IN     school 1800202 9085   pilotED Schools 180020202661 1006 pilotED Schools Bethel Park   Regular School Yes Elementary KG 03 2020   grade_2                         18.0 9.0                       27.0                         18 9                 27
1930155 1930155 IN     school 1800202 9085   pilotED Schools 180020202661 1006 pilotED Schools Bethel Park   Regular School Yes Elementary KG 04 2021   grade_2                         19.0 26.0                       45.0                         19 26                 45
1160278 1160278 IN     school 1802830 630   Zionsville Community Schools 180283001219 514 Eagle Elementary School   Regular School No 1.0 KG 04 2015   grade_2                         38.0 34.0                       72.0                         38 34                 72
1160284 1160284 IN     school 1802830 630   Zionsville Community Schools 180283001551 517 Zionsville Pleasant View Elem Sch   Regular School No 1.0 PK 04 2015   grade_2                         77.0 70.0                       147.0                         77 70                 147
1160291 1160291 IN     school 1802830 630   Zionsville Community Schools 180283000340 541 Union Elementary School   Regular School No 1.0 PK 04 2015   grade_2                         49.0 55.0                       104.0                         49 55                 104
1160298 1160298 IN     school 1802830 630   Zionsville Community Schools 180283001854 542 Stonegate Elementary   Regular School No 1.0 KG 04 2015   grade_2                         45.0 59.0                       104.0                         45 59                 104
1160304 1160304 IN     school 1802830 630   Zionsville Community Schools 180283002481 544 Boone Meadow   Regular School No 1.0 PK 04 2015   grade_2                         33.0 23.0                       56.0                         33 23                 56
1281673 1281673 IN     school 1802830 630   Zionsville Community Schools 180283001219 514 Eagle Elementary School   Regular School No 1.0 PK 04 2016   grade_2                         40.0 32.0                       72.0                         40 32                 72
1281680 1281680 IN     school 1802830 630   Zionsville Community Schools 180283001551 517 Zionsville Pleasant View Elem Sch   Regular School No 1.0 PK 04 2016   grade_2                         76.0 75.0                       151.0                         76 75                 151
1281687 1281687 IN     school 1802830 630   Zionsville Community Schools 180283000340 541 Union Elementary School   Regular School No 1.0 PK 04 2016   grade_2                         57.0 52.0                       109.0                         57 52                 109
1281694 1281694 IN     school 1802830 630   Zionsville Community Schools 180283001854 542 Stonegate Elementary   Regular School No 1.0 PK 04 2016   grade_2                         43.0 48.0                       91.0                         43 48                 91
1281701 1281701 IN     school 1802830 630   Zionsville Community Schools 180283002481 544 Boone Meadow   Regular School No 1.0 PK 04 2016   grade_2                         34.0 34.0                       68.0                         34 34                 68
1293728 1293728 IN     school 1802830 630   Zionsville Community Schools 180283001219 514 Eagle Elementary School   Regular School No Elementary PK 04 2017   grade_2                         38.0 54.0                       92.0                         38 54                 92
1293735 1293735 IN     school 1802830 630   Zionsville Community Schools 180283001551 517 Zionsville Pleasant View Elem Sch   Regular School No Elementary PK 04 2017   grade_2                         86.0 68.0                       154.0                         86 68                 154
1293742 1293742 IN     school 1802830 630   Zionsville Community Schools 180283000340 541 Union Elementary School   Regular School No Elementary PK 04 2017   grade_2                         51.0 55.0                       106.0                         51 55                 106
1293749 1293749 IN     school 1802830 630   Zionsville Community Schools 180283001854 542 Stonegate Elementary   Regular School No Elementary PK 04 2017   grade_2                         43.0 37.0                       80.0                         43 37                 80
1293756 1293756 IN     school 1802830 630   Zionsville Community Schools 180283002481 544 Boone Meadow   Regular School No Elementary PK 04 2017   grade_2                         40.0 34.0                       74.0                         40 34                 74
1752349 1752349 IN     school 1802830 630   Zionsville Community Schools 180283001219 514 Eagle Elementary School   Regular School No Elementary PK 04 2019   grade_2                         40.0 29.0                       69.0                         40 29                 69
1752356 1752356 IN     school 1802830 630   Zionsville Community Schools 180283001551 517 Zionsville Pleasant View Elem Sch   Regular School No Elementary PK 04 2019   grade_2                         87.0 69.0                       156.0                         87 69                 156
1752363 1752363 IN     school 1802830 630   Zionsville Community Schools 180283000340 541 Union Elementary School   Regular School No Elementary PK 04 2019   grade_2                         59.0 73.0                       132.0                         59 73                 132
1752370 1752370 IN     school 1802830 630   Zionsville Community Schools 180283001854 542 Stonegate Elementary   Regular School No Elementary PK 04 2019   grade_2                         36.0 48.0                       84.0                         36 48                 84
1752377 1752377 IN     school 1802830 630   Zionsville Community Schools 180283002481 544 Boone Meadow   Regular School No Elementary PK 04 2019   grade_2                         43.0 52.0                       95.0                         43 52                 95
1788096 1788096 IN     school 1802830 630   Zionsville Community Schools 180283001219 514 Eagle Elementary School   Regular School No Elementary PK 04 2018   grade_2                         38.0 34.0                       72.0                         38 34                 72
1788103 1788103 IN     school 1802830 630   Zionsville Community Schools 180283001551 517 Zionsville Pleasant View Elem Sch   Regular School No Elementary PK 04 2018   grade_2                         64.0 66.0                       130.0                         64 66                 130
1788110 1788110 IN     school 1802830 630   Zionsville Community Schools 180283000340 541 Union Elementary School   Regular School No Elementary PK 04 2018   grade_2                         67.0 59.0                       126.0                         67 59                 126
1788117 1788117 IN     school 1802830 630   Zionsville Community Schools 180283001854 542 Stonegate Elementary   Regular School No Elementary PK 04 2018   grade_2                         50.0 51.0                       101.0                         50 51                 101
1788124 1788124 IN     school 1802830 630   Zionsville Community Schools 180283002481 544 Boone Meadow   Regular School No Elementary PK 04 2018   grade_2                         53.0 47.0                       100.0                         53 47                 100
1907786 1907786 IN     school 1802830 630   Zionsville Community Schools 180283001219 514 Eagle Elementary School   Regular School No Elementary PK 04 2020   grade_2                         45.0 29.0                       74.0                         45 29                 74
1907793 1907793 IN     school 1802830 630   Zionsville Community Schools 180283001551 517 Zionsville Pleasant View Elem Sch   Regular School No Elementary PK 04 2020   grade_2                         80.0 70.0                       150.0                         80 70                 150
1907800 1907800 IN     school 1802830 630   Zionsville Community Schools 180283000340 541 Union Elementary School   Regular School No Elementary PK 04 2020   grade_2                         60.0 62.0                       122.0                         60 62                 122
1907807 1907807 IN     school 1802830 630   Zionsville Community Schools 180283001854 542 Stonegate Elementary   Regular School No Elementary PK 04 2020   grade_2                         49.0 49.0                       98.0                         49 49                 98
1907814 1907814 IN     school 1802830 630   Zionsville Community Schools 180283002481 544 Boone Meadow   Regular School No Elementary PK 04 2020   grade_2                         40.0 71.0                       111.0                         40 71                 111
1919753 1919753 IN     school 1802830 630   Zionsville Community Schools 180283001219 514 Eagle Elementary School   Regular School No Elementary PK 04 2021   grade_2                         47.0 31.0                       78.0                         47 31                 78
1919760 1919760 IN     school 1802830 630   Zionsville Community Schools 180283001551 517 Zionsville Pleasant View Elem Sch   Regular School No Elementary PK 04 2021   grade_2                         80.0 62.0                       142.0                         80 62                 142
1919767 1919767 IN     school 1802830 630   Zionsville Community Schools 180283000340 541 Union Elementary School   Regular School No Elementary PK 04 2021   grade_2                         86.0 53.0                       139.0                         86 53                 139
1919774 1919774 IN     school 1802830 630   Zionsville Community Schools 180283001854 542 Stonegate Elementary   Regular School No Elementary PK 04 2021   grade_2                         53.0 48.0                       101.0                         53 48                 101
1919781 1919781 IN     school 1802830 630   Zionsville Community Schools 180283002481 544 Boone Meadow   Regular School No Elementary KG 04 2021   grade_2                         56.0 44.0                       100.0                         56 44                 100
1161274 1161274 IN     school 1807230 1910   Yorktown Community Schools 180723001215 1395 Pleasant View Elementary School   Regular School No 1.0 KG 02 2015   grade_2                         95.0 88.0                       183.0                         95 88                 183
1282677 1282677 IN     school 1807230 1910   Yorktown Community Schools 180723001215 1395 Pleasant View Elementary School   Regular School No 1.0 KG 02 2016   grade_2                         115.0 88.0                       203.0                         115 88                 203
1294712 1294712 IN     school 1807230 1910   Yorktown Community Schools 180723001215 1395 Pleasant View Elementary School   Regular School No Elementary KG 02 2017   grade_2                         82.0 92.0                       174.0                         82 92                 174
1753336 1753336 IN     school 1807230 1910   Yorktown Community Schools 180723001215 1395 Pleasant View Elementary School   Regular School No Elementary KG 02 2019   grade_2                         109.0 87.0                       196.0                         109 87                 196
1789075 1789075 IN     school 1807230 1910   Yorktown Community Schools 180723001215 1395 Pleasant View Elementary School   Regular School No Elementary KG 02 2018   grade_2                         107.0 112.0                       219.0                         107 112                 219
1908767 1908767 IN     school 1807230 1910   Yorktown Community Schools 180723001215 1395 Pleasant View Elementary School   Regular School No Elementary KG 02 2020   grade_2                         106.0 102.0                       208.0                         106 102                 208
1920740 1920740 IN     school 1807230 1910   Yorktown Community Schools 180723001215 1395 Pleasant View Elementary School   Regular School No Elementary KG 02 2021   grade_2                         97.0 117.0                       214.0                         97 117                 214
1171350 1171350 IN     school 1800087 9845   Xavier School of Excellence 180008702445 7571 Xavier School of Excellence   Regular School Yes 1.0 KG 08 2015   grade_2                         19.0 22.0                       41.0                         19 22                 41
1292714 1292714 IN     school 1800087 9845   Xavier School of Excellence 180008702445 7571 Xavier School of Excellence   Regular School Yes 1.0 KG 08 2016   grade_2                         15.0 7.0                       22.0                         15 7                 22
1304748 1304748 IN     school 1800087 9845   Xavier School of Excellence 180008702445 7571 Xavier School of Excellence   Regular School Yes Elementary KG 08 2017   grade_2                         13.0 12.0                       25.0                         13 12                 25
1799075 1799075 IN     school 1800087 9845   Xavier School of Excellence 180008702445 7571 Xavier School of Excellence   Regular School Yes Elementary KG 08 2018   grade_2                         10.0 7.0                       17.0                         10 7                 17
1304083 1304083 IN     school 1802280 8665   Whitley County Con Schools 180228002135 9178 Little Turtle Elementary School   Regular School No Elementary KG 05 2017   grade_2                         44.0 37.0                       81.0                         44 37                 81
1304090 1304090 IN     school 1802280 8665   Whitley County Con Schools 180228001871 9179 Coesse School   Regular School No Elementary KG 05 2017   grade_2                         36.0 18.0                       54.0                         36 18                 54
1304101 1304101 IN     school 1802280 8665   Whitley County Con Schools 180228001185 9186 Northern Heights Elementary School   Regular School No Elementary KG 05 2017   grade_2                         55.0 29.0                       84.0                         55 29                 84
1304114 1304114 IN     school 1802280 8665   Whitley County Con Schools 180228002108 9196 Mary Raber Elementary School   Regular School No Elementary PK 05 2017   grade_2                         21.0 21.0                       42.0                         21 21                 42
1762626 1762626 IN     school 1802280 8665   Whitley County Con Schools 180228002135 9178 Little Turtle Elementary School   Regular School No Elementary KG 05 2019   grade_2                         45.0 40.0                       85.0                         45 40                 85
1762633 1762633 IN     school 1802280 8665   Whitley County Con Schools 180228001871 9179 Coesse School   Regular School No Elementary KG 05 2019   grade_2                         24.0 26.0                       50.0                         24 26                 50
1762644 1762644 IN     school 1802280 8665   Whitley County Con Schools 180228001185 9186 Northern Heights Elementary School   Regular School No Elementary KG 05 2019   grade_2                         42.0 30.0                       72.0                         42 30                 72
1762657 1762657 IN     school 1802280 8665   Whitley County Con Schools 180228002108 9196 Mary Raber Elementary School   Regular School No Elementary PK 05 2019   grade_2                         8.0 21.0                       29.0                         8 21                 29
1798407 1798407 IN     school 1802280 8665   Whitley County Con Schools 180228002135 9178 Little Turtle Elementary School   Regular School No Elementary KG 05 2018   grade_2                         51.0 46.0                       97.0                         51 46                 97
1798414 1798414 IN     school 1802280 8665   Whitley County Con Schools 180228001871 9179 Coesse School   Regular School No Elementary KG 05 2018   grade_2                         20.0 31.0                       51.0                         20 31                 51
1798425 1798425 IN     school 1802280 8665   Whitley County Con Schools 180228001185 9186 Northern Heights Elementary School   Regular School No Elementary KG 05 2018   grade_2                         47.0 32.0                       79.0                         47 32                 79
1798438 1798438 IN     school 1802280 8665   Whitley County Con Schools 180228002108 9196 Mary Raber Elementary School   Regular School No Elementary PK 05 2018   grade_2                         22.0 29.0                       51.0                         22 29                 51
1918050 1918050 IN     school 1802280 8665   Whitley County Con Schools 180228002135 9178 Little Turtle Elementary School   Regular School No Elementary KG 05 2020   grade_2                         44.0 43.0                       87.0                         44 43                 87
1918057 1918057 IN     school 1802280 8665   Whitley County Con Schools 180228001871 9179 Coesse School   Regular School No Elementary KG 05 2020   grade_2                         23.0 25.0                       48.0                         23 25                 48
1918068 1918068 IN     school 1802280 8665   Whitley County Con Schools 180228001185 9186 Northern Heights Elementary School   Regular School No Elementary KG 05 2020   grade_2                         32.0 41.0                       73.0                         32 41                 73
1918081 1918081 IN     school 1802280 8665   Whitley County Con Schools 180228002108 9196 Mary Raber Elementary School   Regular School No Elementary PK 05 2020   grade_2                         14.0 20.0                       34.0                         14 20                 34
1929980 1929980 IN     school 1802280 8665   Whitley County Con Schools 180228002135 9178 Little Turtle Elementary School   Regular School No Elementary KG 05 2021   grade_2                         55.0 47.0                       102.0                         55 47                 102
1929987 1929987 IN     school 1802280 8665   Whitley County Con Schools 180228001871 9179 Coesse School   Regular School No Elementary KG 05 2021   grade_2                         22.0 18.0                       40.0                         22 18                 40
1929998 1929998 IN     school 1802280 8665   Whitley County Con Schools 180228001185 9186 Northern Heights Elementary School   Regular School No Elementary KG 05 2021   grade_2                         41.0 41.0                       82.0                         41 41                 82
1930011 1930011 IN     school 1802280 8665   Whitley County Con Schools 180228002108 9196 Mary Raber Elementary School   Regular School No Elementary PK 05 2021   grade_2                         19.0 18.0                       37.0                         19 18                 37
1170672 1170672 IN     school 1802280 8665   Whitley Co Cons Schools 180228002135 9178 Little Turtle Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         57.0 34.0                       91.0                         57 34                 91
1170679 1170679 IN     school 1802280 8665   Whitley Co Cons Schools 180228001871 9179 Coesse School   Regular School No 1.0 KG 05 2015   grade_2                         29.0 25.0                       54.0                         29 25                 54
1170690 1170690 IN     school 1802280 8665   Whitley Co Cons Schools 180228001185 9186 Northern Heights Elementary Sch   Regular School No 1.0 KG 05 2015   grade_2                         48.0 32.0                       80.0                         48 32                 80
1170703 1170703 IN     school 1802280 8665   Whitley Co Cons Schools 180228002108 9196 Mary Raber Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         19.0 36.0                       55.0                         19 36                 55
1292061 1292061 IN     school 1802280 8665   Whitley Co Cons Schools 180228002135 9178 Little Turtle Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         52.0 42.0                       94.0                         52 42                 94
1292068 1292068 IN     school 1802280 8665   Whitley Co Cons Schools 180228001871 9179 Coesse School   Regular School No 1.0 KG 05 2016   grade_2                         16.0 30.0                       46.0                         16 30                 46
1292079 1292079 IN     school 1802280 8665   Whitley Co Cons Schools 180228001185 9186 Northern Heights Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         53.0 44.0                       97.0                         53 44                 97
1292092 1292092 IN     school 1802280 8665   Whitley Co Cons Schools 180228002108 9196 Mary Raber Elementary School   Regular School No 1.0 PK 05 2016   grade_2                         20.0 24.0                       44.0                         20 24                 44
1164250 1164250 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         30.0 32.0                       62.0                         30 32                 62
1164262 1164262 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary Sch   Regular School No 1.0 PK 05 2015   grade_2                         21.0 32.0                       53.0                         21 32                 53
1285657 1285657 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No 1.0 PK 05 2016   grade_2                         31.0 17.0                       48.0                         31 17                 48
1285669 1285669 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         27.0 29.0                       56.0                         27 29                 56
1297703 1297703 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 05 2017   grade_2                         15.0 31.0                       46.0                         15 31                 46
1297715 1297715 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary PK 05 2017   grade_2                         19.0 21.0                       40.0                         19 21                 40
1756300 1756300 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 06 2019   grade_2                         23.0 27.0                       50.0                         23 27                 50
1756309 1756309 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary KG 06 2019   grade_2                         16.0 27.0                       43.0                         16 27                 43
1792061 1792061 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 05 2018   grade_2                         28.0 17.0                       45.0                         28 17                 45
1792073 1792073 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary PK 05 2018   grade_2                         25.0 17.0                       42.0                         25 17                 42
1911757 1911757 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 06 2020   grade_2                         21.0 34.0                       55.0                         21 34                 55
1911766 1911766 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary KG 06 2020   grade_2                         16.0 23.0                       39.0                         16 23                 39
1923725 1923725 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 06 2021   grade_2                         29.0 26.0                       55.0                         29 26                 55
1923734 1923734 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary KG 06 2021   grade_2                         19.0 17.0                       36.0                         19 17                 36
1165112 1165112 IN     school 1813200 4760   Whiting School City 181320002081 4361 Nathan Hale Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         29.0 46.0                       75.0                         29 46                 75
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
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
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

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