enrollments

Data source: Big Local News · About: Big Local

7,228 rows where grade = "kindergarten" and state = "IN" sorted by district descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • kindergarten · 7,228 ✖
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
1762745 1762745 IN     school 1800202 9085   pilotED Schools 180020202661 1006 pilotED Schools Bethel Park   Regular School Yes Elementary KG 02 2019   kindergarten                         21.0 23.0                       44.0                         21 23                 44
1918204 1918204 IN     school 1800202 9085   pilotED Schools 180020202661 1006 pilotED Schools Bethel Park   Regular School Yes Elementary KG 03 2020   kindergarten                         27.0 25.0                       52.0                         27 25                 52
1930158 1930158 IN     school 1800202 9085   pilotED Schools 180020202661 1006 pilotED Schools Bethel Park   Regular School Yes Elementary KG 04 2021   kindergarten                         26.0 25.0                       51.0                         26 25                 51
1160281 1160281 IN     school 1802830 630   Zionsville Community Schools 180283001219 514 Eagle Elementary School   Regular School No 1.0 KG 04 2015   kindergarten                         39.0 43.0                       82.0                         39 43                 82
1160287 1160287 IN     school 1802830 630   Zionsville Community Schools 180283001551 517 Zionsville Pleasant View Elem Sch   Regular School No 1.0 PK 04 2015   kindergarten                         71.0 55.0                       126.0                         71 55                 126
1160294 1160294 IN     school 1802830 630   Zionsville Community Schools 180283000340 541 Union Elementary School   Regular School No 1.0 PK 04 2015   kindergarten                         45.0 42.0                       87.0                         45 42                 87
1160301 1160301 IN     school 1802830 630   Zionsville Community Schools 180283001854 542 Stonegate Elementary   Regular School No 1.0 KG 04 2015   kindergarten                         46.0 39.0                       85.0                         46 39                 85
1160307 1160307 IN     school 1802830 630   Zionsville Community Schools 180283002481 544 Boone Meadow   Regular School No 1.0 PK 04 2015   kindergarten                         36.0 36.0                       72.0                         36 36                 72
1281676 1281676 IN     school 1802830 630   Zionsville Community Schools 180283001219 514 Eagle Elementary School   Regular School No 1.0 PK 04 2016   kindergarten                         32.0 30.0                       62.0                         32 30                 62
1281683 1281683 IN     school 1802830 630   Zionsville Community Schools 180283001551 517 Zionsville Pleasant View Elem Sch   Regular School No 1.0 PK 04 2016   kindergarten                         59.0 63.0                       122.0                         59 63                 122
1281690 1281690 IN     school 1802830 630   Zionsville Community Schools 180283000340 541 Union Elementary School   Regular School No 1.0 PK 04 2016   kindergarten                         60.0 50.0                       110.0                         60 50                 110
1281697 1281697 IN     school 1802830 630   Zionsville Community Schools 180283001854 542 Stonegate Elementary   Regular School No 1.0 PK 04 2016   kindergarten                         50.0 38.0                       88.0                         50 38                 88
1281704 1281704 IN     school 1802830 630   Zionsville Community Schools 180283002481 544 Boone Meadow   Regular School No 1.0 PK 04 2016   kindergarten                         51.0 31.0                       82.0                         51 31                 82
1293731 1293731 IN     school 1802830 630   Zionsville Community Schools 180283001219 514 Eagle Elementary School   Regular School No Elementary PK 04 2017   kindergarten                         32.0 35.0                       67.0                         32 35                 67
1293738 1293738 IN     school 1802830 630   Zionsville Community Schools 180283001551 517 Zionsville Pleasant View Elem Sch   Regular School No Elementary PK 04 2017   kindergarten                         81.0 61.0                       142.0                         81 61                 142
1293745 1293745 IN     school 1802830 630   Zionsville Community Schools 180283000340 541 Union Elementary School   Regular School No Elementary PK 04 2017   kindergarten                         51.0 61.0                       112.0                         51 61                 112
1293752 1293752 IN     school 1802830 630   Zionsville Community Schools 180283001854 542 Stonegate Elementary   Regular School No Elementary PK 04 2017   kindergarten                         40.0 48.0                       88.0                         40 48                 88
1293759 1293759 IN     school 1802830 630   Zionsville Community Schools 180283002481 544 Boone Meadow   Regular School No Elementary PK 04 2017   kindergarten                         45.0 39.0                       84.0                         45 39                 84
1752352 1752352 IN     school 1802830 630   Zionsville Community Schools 180283001219 514 Eagle Elementary School   Regular School No Elementary PK 04 2019   kindergarten                         38.0 24.0                       62.0                         38 24                 62
1752359 1752359 IN     school 1802830 630   Zionsville Community Schools 180283001551 517 Zionsville Pleasant View Elem Sch   Regular School No Elementary PK 04 2019   kindergarten                         70.0 57.0                       127.0                         70 57                 127
1752366 1752366 IN     school 1802830 630   Zionsville Community Schools 180283000340 541 Union Elementary School   Regular School No Elementary PK 04 2019   kindergarten                         88.0 54.0                       142.0                         88 54                 142
1752373 1752373 IN     school 1802830 630   Zionsville Community Schools 180283001854 542 Stonegate Elementary   Regular School No Elementary PK 04 2019   kindergarten                         56.0 47.0                       103.0                         56 47                 103
1752380 1752380 IN     school 1802830 630   Zionsville Community Schools 180283002481 544 Boone Meadow   Regular School No Elementary PK 04 2019   kindergarten                         51.0 53.0                       104.0                         51 53                 104
1788099 1788099 IN     school 1802830 630   Zionsville Community Schools 180283001219 514 Eagle Elementary School   Regular School No Elementary PK 04 2018   kindergarten                         39.0 19.0                       58.0                         39 19                 58
1788106 1788106 IN     school 1802830 630   Zionsville Community Schools 180283001551 517 Zionsville Pleasant View Elem Sch   Regular School No Elementary PK 04 2018   kindergarten                         71.0 55.0                       126.0                         71 55                 126
1788113 1788113 IN     school 1802830 630   Zionsville Community Schools 180283000340 541 Union Elementary School   Regular School No Elementary PK 04 2018   kindergarten                         47.0 57.0                       104.0                         47 57                 104
1788120 1788120 IN     school 1802830 630   Zionsville Community Schools 180283001854 542 Stonegate Elementary   Regular School No Elementary PK 04 2018   kindergarten                         48.0 50.0                       98.0                         48 50                 98
1788127 1788127 IN     school 1802830 630   Zionsville Community Schools 180283002481 544 Boone Meadow   Regular School No Elementary PK 04 2018   kindergarten                         38.0 64.0                       102.0                         38 64                 102
1907789 1907789 IN     school 1802830 630   Zionsville Community Schools 180283001219 514 Eagle Elementary School   Regular School No Elementary PK 04 2020   kindergarten                         39.0 39.0                       78.0                         39 39                 78
1907796 1907796 IN     school 1802830 630   Zionsville Community Schools 180283001551 517 Zionsville Pleasant View Elem Sch   Regular School No Elementary PK 04 2020   kindergarten                         72.0 64.0                       136.0                         72 64                 136
1907803 1907803 IN     school 1802830 630   Zionsville Community Schools 180283000340 541 Union Elementary School   Regular School No Elementary PK 04 2020   kindergarten                         55.0 53.0                       108.0                         55 53                 108
1907810 1907810 IN     school 1802830 630   Zionsville Community Schools 180283001854 542 Stonegate Elementary   Regular School No Elementary PK 04 2020   kindergarten                         51.0 42.0                       93.0                         51 42                 93
1907817 1907817 IN     school 1802830 630   Zionsville Community Schools 180283002481 544 Boone Meadow   Regular School No Elementary PK 04 2020   kindergarten                         65.0 60.0                       125.0                         65 60                 125
1919756 1919756 IN     school 1802830 630   Zionsville Community Schools 180283001219 514 Eagle Elementary School   Regular School No Elementary PK 04 2021   kindergarten                         37.0 43.0                       80.0                         37 43                 80
1919763 1919763 IN     school 1802830 630   Zionsville Community Schools 180283001551 517 Zionsville Pleasant View Elem Sch   Regular School No Elementary PK 04 2021   kindergarten                         67.0 63.0                       130.0                         67 63                 130
1919770 1919770 IN     school 1802830 630   Zionsville Community Schools 180283000340 541 Union Elementary School   Regular School No Elementary PK 04 2021   kindergarten                         51.0 61.0                       112.0                         51 61                 112
1919777 1919777 IN     school 1802830 630   Zionsville Community Schools 180283001854 542 Stonegate Elementary   Regular School No Elementary PK 04 2021   kindergarten                         43.0 39.0                       82.0                         43 39                 82
1919784 1919784 IN     school 1802830 630   Zionsville Community Schools 180283002481 544 Boone Meadow   Regular School No Elementary KG 04 2021   kindergarten                         65.0 47.0                       112.0                         65 47                 112
1161275 1161275 IN     school 1807230 1910   Yorktown Community Schools 180723001215 1395 Pleasant View Elementary School   Regular School No 1.0 KG 02 2015   kindergarten                         87.0 90.0                       177.0                         87 90                 177
1282678 1282678 IN     school 1807230 1910   Yorktown Community Schools 180723001215 1395 Pleasant View Elementary School   Regular School No 1.0 KG 02 2016   kindergarten                         105.0 106.0                       211.0                         105 106                 211
1294713 1294713 IN     school 1807230 1910   Yorktown Community Schools 180723001215 1395 Pleasant View Elementary School   Regular School No Elementary KG 02 2017   kindergarten                         101.0 83.0                       184.0                         101 83                 184
1753337 1753337 IN     school 1807230 1910   Yorktown Community Schools 180723001215 1395 Pleasant View Elementary School   Regular School No Elementary KG 02 2019   kindergarten                         104.0 113.0                       217.0                         104 113                 217
1789076 1789076 IN     school 1807230 1910   Yorktown Community Schools 180723001215 1395 Pleasant View Elementary School   Regular School No Elementary KG 02 2018   kindergarten                         104.0 103.0                       207.0                         104 103                 207
1908768 1908768 IN     school 1807230 1910   Yorktown Community Schools 180723001215 1395 Pleasant View Elementary School   Regular School No Elementary KG 02 2020   kindergarten                         105.0 118.0                       223.0                         105 118                 223
1920741 1920741 IN     school 1807230 1910   Yorktown Community Schools 180723001215 1395 Pleasant View Elementary School   Regular School No Elementary KG 02 2021   kindergarten                         99.0 95.0                       194.0                         99 95                 194
1171357 1171357 IN     school 1800087 9845   Xavier School of Excellence 180008702445 7571 Xavier School of Excellence   Regular School Yes 1.0 KG 08 2015   kindergarten                         20.0 24.0                       44.0                         20 24                 44
1292721 1292721 IN     school 1800087 9845   Xavier School of Excellence 180008702445 7571 Xavier School of Excellence   Regular School Yes 1.0 KG 08 2016   kindergarten                         20.0 15.0                       35.0                         20 15                 35
1304755 1304755 IN     school 1800087 9845   Xavier School of Excellence 180008702445 7571 Xavier School of Excellence   Regular School Yes Elementary KG 08 2017   kindergarten                         18.0 15.0                       33.0                         18 15                 33
1799082 1799082 IN     school 1800087 9845   Xavier School of Excellence 180008702445 7571 Xavier School of Excellence   Regular School Yes Elementary KG 08 2018   kindergarten                         16.0 23.0                       39.0                         16 23                 39
1304087 1304087 IN     school 1802280 8665   Whitley County Con Schools 180228002135 9178 Little Turtle Elementary School   Regular School No Elementary KG 05 2017   kindergarten                         41.0 38.0                       79.0                         41 38                 79
1304094 1304094 IN     school 1802280 8665   Whitley County Con Schools 180228001871 9179 Coesse School   Regular School No Elementary KG 05 2017   kindergarten                         21.0 28.0                       49.0                         21 28                 49
1304105 1304105 IN     school 1802280 8665   Whitley County Con Schools 180228001185 9186 Northern Heights Elementary School   Regular School No Elementary KG 05 2017   kindergarten                         38.0 33.0                       71.0                         38 33                 71
1304118 1304118 IN     school 1802280 8665   Whitley County Con Schools 180228002108 9196 Mary Raber Elementary School   Regular School No Elementary PK 05 2017   kindergarten                         24.0 31.0                       55.0                         24 31                 55
1762630 1762630 IN     school 1802280 8665   Whitley County Con Schools 180228002135 9178 Little Turtle Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         55.0 44.0                       99.0                         55 44                 99
1762637 1762637 IN     school 1802280 8665   Whitley County Con Schools 180228001871 9179 Coesse School   Regular School No Elementary KG 05 2019   kindergarten                         24.0 18.0                       42.0                         24 18                 42
1762648 1762648 IN     school 1802280 8665   Whitley County Con Schools 180228001185 9186 Northern Heights Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         36.0 43.0                       79.0                         36 43                 79
1762661 1762661 IN     school 1802280 8665   Whitley County Con Schools 180228002108 9196 Mary Raber Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         28.0 23.0                       51.0                         28 23                 51
1798411 1798411 IN     school 1802280 8665   Whitley County Con Schools 180228002135 9178 Little Turtle Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         38.0 39.0                       77.0                         38 39                 77
1798418 1798418 IN     school 1802280 8665   Whitley County Con Schools 180228001871 9179 Coesse School   Regular School No Elementary KG 05 2018   kindergarten                         23.0 26.0                       49.0                         23 26                 49
1798429 1798429 IN     school 1802280 8665   Whitley County Con Schools 180228001185 9186 Northern Heights Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         33.0 45.0                       78.0                         33 45                 78
1798442 1798442 IN     school 1802280 8665   Whitley County Con Schools 180228002108 9196 Mary Raber Elementary School   Regular School No Elementary PK 05 2018   kindergarten                         40.0 46.0                       86.0                         40 46                 86
1918054 1918054 IN     school 1802280 8665   Whitley County Con Schools 180228002135 9178 Little Turtle Elementary School   Regular School No Elementary KG 05 2020   kindergarten                         49.0 60.0                       109.0                         49 60                 109
1918061 1918061 IN     school 1802280 8665   Whitley County Con Schools 180228001871 9179 Coesse School   Regular School No Elementary KG 05 2020   kindergarten                         23.0 25.0                       48.0                         23 25                 48
1918072 1918072 IN     school 1802280 8665   Whitley County Con Schools 180228001185 9186 Northern Heights Elementary School   Regular School No Elementary KG 05 2020   kindergarten                         43.0 58.0                       101.0                         43 58                 101
1918085 1918085 IN     school 1802280 8665   Whitley County Con Schools 180228002108 9196 Mary Raber Elementary School   Regular School No Elementary PK 05 2020   kindergarten                         22.0 21.0                       43.0                         22 21                 43
1929984 1929984 IN     school 1802280 8665   Whitley County Con Schools 180228002135 9178 Little Turtle Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         39.0 39.0                       78.0                         39 39                 78
1929991 1929991 IN     school 1802280 8665   Whitley County Con Schools 180228001871 9179 Coesse School   Regular School No Elementary KG 05 2021   kindergarten                         19.0 21.0                       40.0                         19 21                 40
1930002 1930002 IN     school 1802280 8665   Whitley County Con Schools 180228001185 9186 Northern Heights Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         42.0 46.0                       88.0                         42 46                 88
1930015 1930015 IN     school 1802280 8665   Whitley County Con Schools 180228002108 9196 Mary Raber Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         23.0 18.0                       41.0                         23 18                 41
1170676 1170676 IN     school 1802280 8665   Whitley Co Cons Schools 180228002135 9178 Little Turtle Elementary School   Regular School No 1.0 KG 05 2015   kindergarten                         43.0 51.0                       94.0                         43 51                 94
1170683 1170683 IN     school 1802280 8665   Whitley Co Cons Schools 180228001871 9179 Coesse School   Regular School No 1.0 KG 05 2015   kindergarten                         34.0 22.0                       56.0                         34 22                 56
1170694 1170694 IN     school 1802280 8665   Whitley Co Cons Schools 180228001185 9186 Northern Heights Elementary Sch   Regular School No 1.0 KG 05 2015   kindergarten                         59.0 30.0                       89.0                         59 30                 89
1170707 1170707 IN     school 1802280 8665   Whitley Co Cons Schools 180228002108 9196 Mary Raber Elementary School   Regular School No 1.0 PK 05 2015   kindergarten                         31.0 22.0                       53.0                         31 22                 53
1292065 1292065 IN     school 1802280 8665   Whitley Co Cons Schools 180228002135 9178 Little Turtle Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         48.0 40.0                       88.0                         48 40                 88
1292072 1292072 IN     school 1802280 8665   Whitley Co Cons Schools 180228001871 9179 Coesse School   Regular School No 1.0 KG 05 2016   kindergarten                         16.0 32.0                       48.0                         16 32                 48
1292083 1292083 IN     school 1802280 8665   Whitley Co Cons Schools 180228001185 9186 Northern Heights Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         45.0 32.0                       77.0                         45 32                 77
1292096 1292096 IN     school 1802280 8665   Whitley Co Cons Schools 180228002108 9196 Mary Raber Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         30.0 28.0                       58.0                         30 28                 58
1164254 1164254 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No 1.0 PK 05 2015   kindergarten                         20.0 37.0                       57.0                         20 37                 57
1164266 1164266 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary Sch   Regular School No 1.0 PK 05 2015   kindergarten                         14.0 21.0                       35.0                         14 21                 35
1285661 1285661 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         27.0 20.0                       47.0                         27 20                 47
1285673 1285673 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         21.0 17.0                       38.0                         21 17                 38
1297707 1297707 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 05 2017   kindergarten                         21.0 25.0                       46.0                         21 25                 46
1297719 1297719 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary PK 05 2017   kindergarten                         15.0 26.0                       41.0                         15 26                 41
1756305 1756305 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 06 2019   kindergarten                         28.0 23.0                       51.0                         28 23                 51
1756314 1756314 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary KG 06 2019   kindergarten                         18.0 15.0                       33.0                         18 15                 33
1792065 1792065 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 05 2018   kindergarten                         26.0 37.0                       63.0                         26 37                 63
1792077 1792077 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary PK 05 2018   kindergarten                         15.0 26.0                       41.0                         15 26                 41
1911762 1911762 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 06 2020   kindergarten                         34.0 23.0                       57.0                         34 23                 57
1911771 1911771 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary KG 06 2020   kindergarten                         20.0 27.0                       47.0                         20 27                 47
1923730 1923730 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 06 2021   kindergarten                         32.0 31.0                       63.0                         32 31                 63
1923739 1923739 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary KG 06 2021   kindergarten                         23.0 23.0                       46.0                         23 23                 46
1165116 1165116 IN     school 1813200 4760   Whiting School City 181320002081 4361 Nathan Hale Elementary School   Regular School No 1.0 PK 05 2015   kindergarten                         20.0 40.0                       60.0                         20 40                 60
1295826 1295826 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2017   kindergarten                         25.0 24.0                       49.0                         25 24                 49
1754435 1754435 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2019   kindergarten                         31.0 26.0                       57.0                         31 26                 57
1790172 1790172 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2018   kindergarten                         20.0 21.0                       41.0                         20 21                 41
1909868 1909868 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2020   kindergarten                         34.0 21.0                       55.0                         34 21                 55
1921821 1921821 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2021   kindergarten                         42.0 28.0                       70.0                         42 28                 70
1162373 1162373 IN     school 1800008 2980   White River Valley Sch Dist 180000802304 2457 Lyons Elementary School   Regular School No 1.0 KG 06 2015   kindergarten                         17.0 10.0                       27.0                         17 10                 27
1162381 1162381 IN     school 1800008 2980   White River Valley Sch Dist 180000802090 2460 Worthington Elementary School   Regular School No 1.0 PK 06 2015   kindergarten                         20.0 17.0                       37.0                         20 17                 37
1283783 1283783 IN     school 1800008 2980   White River Valley Sch Dist 180000802304 2457 Lyons Elementary School   Regular School No 1.0 KG 06 2016   kindergarten                         9.0 12.0                       21.0                         9 12                 21

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