enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_1 · 7,359 ✖
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id ▲ school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
1166230 1166230 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_1                         2.0 1.0                       3.0                         2 1                 3
1287632 1287632 IN     school   5375   M S D Wayne Township   5271 Sanders School             2016   grade_1                         3.0 0.0                       3.0                         3 0                 3
1299669 1299669 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_1                         3.0 0.0                       3.0                         3 0                 3
1758207 1758207 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_1                         6.0 0.0                       6.0                         6 0                 6
1793997 1793997 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_1                         2.0 2.0                       4.0                         2 2                 4
1908015 1908015 IN     school   940   West Clark Community Schools   767 Henryville Elementary School             2020   grade_1                         50.0 43.0                       93.0                         50 43                 93
1908047 1908047 IN     school   940   West Clark Community Schools   815 William W Borden Elementary School             2020   grade_1                         25.0 17.0                       42.0                         25 17                 42
1908055 1908055 IN     school   940   West Clark Community Schools   818 Silver Creek Primary School             2020   grade_1                         90.0 92.0                       182.0                         90 92                 182
1913635 1913635 IN     school   5375   M S D Wayne Township   5271 Sanders School             2020   grade_1                         4.0 0.0                       4.0                         4 0                 4
1927188 1927188 IN     school   6520   Porter Township School Corp   6811 Porter County Education Services             2021   grade_1                         0.0 1.0                       1.0                         0 1                 1
1927239 1927239 IN     school   6550   Portage Township Schools   6811 Porter County Education Services             2021   grade_1                         0.0 1.0                       1.0                         0 1                 1
1927323 1927323 IN     school   6560   Valparaiso Community Schools   6811 Porter County Education Services             2021   grade_1                         2.0 2.0                       4.0                         2 2                 4
1164261 1164261 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary Sch   Regular School No 1.0 PK 05 2015   grade_1                         28.0 30.0                       58.0                         28 30                 58
1285668 1285668 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No 1.0 KG 05 2016   grade_1                         17.0 21.0                       38.0                         17 21                 38
1297714 1297714 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary PK 05 2017   grade_1                         20.0 18.0                       38.0                         20 18                 38
1756308 1756308 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary KG 06 2019   grade_1                         19.0 28.0                       47.0                         19 28                 47
1792072 1792072 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary PK 05 2018   grade_1                         18.0 24.0                       42.0                         18 24                 42
1911765 1911765 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary KG 06 2020   grade_1                         18.0 18.0                       36.0                         18 18                 36
1923733 1923733 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary KG 06 2021   grade_1                         20.0 25.0                       45.0                         20 25                 45
1164249 1164249 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         26.0 15.0                       41.0                         26 15                 41
1285656 1285656 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No 1.0 PK 05 2016   grade_1                         19.0 33.0                       52.0                         19 33                 52
1297702 1297702 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 05 2017   grade_1                         33.0 21.0                       54.0                         33 21                 54
1756299 1756299 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 06 2019   grade_1                         22.0 38.0                       60.0                         22 38                 60
1792060 1792060 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 05 2018   grade_1                         28.0 24.0                       52.0                         28 24                 52
1911756 1911756 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 06 2020   grade_1                         27.0 22.0                       49.0                         27 22                 49
1923724 1923724 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 06 2021   grade_1                         27.0 23.0                       50.0                         27 23                 50
1165111 1165111 IN     school 1813200 4760   Whiting School City 181320002081 4361 Nathan Hale Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         25.0 39.0                       64.0                         25 39                 64
1286506 1286506 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No 1.0 PK 05 2016   grade_1                         22.0 37.0                       59.0                         22 37                 59
1298545 1298545 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No Elementary PK 05 2017   grade_1                         42.0 34.0                       76.0                         42 34                 76
1757073 1757073 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No Elementary PK 05 2019   grade_1                         28.0 26.0                       54.0                         28 26                 54
1792864 1792864 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No Elementary PK 05 2018   grade_1                         39.0 27.0                       66.0                         39 27                 66
1912509 1912509 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No Elementary PK 05 2020   grade_1                         37.0 45.0                       82.0                         37 45                 82
1924459 1924459 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No Elementary PK 05 2021   grade_1                         24.0 31.0                       55.0                         24 31                 55
1164299 1164299 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No 1.0 KG 04 2015   grade_1                         35.0 34.0                       69.0                         35 34                 69
1285705 1285705 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No 1.0 KG 04 2016   grade_1                         27.0 32.0                       59.0                         27 32                 59
1297752 1297752 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No Elementary KG 04 2017   grade_1                         33.0 29.0                       62.0                         33 29                 62
1756349 1756349 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No Elementary KG 04 2019   grade_1                         29.0 27.0                       56.0                         29 27                 56
1792111 1792111 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No Elementary KG 04 2018   grade_1                         39.0 34.0                       73.0                         39 34                 73
1911806 1911806 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No Elementary KG 04 2020   grade_1                         35.0 28.0                       63.0                         35 28                 63
1923774 1923774 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No Elementary KG 04 2021   grade_1                         30.0 33.0                       63.0                         30 33                 63
1164315 1164315 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elem School   Regular School No 1.0 KG 04 2015   grade_1                         37.0 29.0                       66.0                         37 29                 66
1285722 1285722 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No 1.0 KG 04 2016   grade_1                         27.0 37.0                       64.0                         27 37                 64
1297769 1297769 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No Elementary KG 04 2017   grade_1                         32.0 34.0                       66.0                         32 34                 66
1756367 1756367 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No Elementary KG 04 2019   grade_1                         29.0 35.0                       64.0                         29 35                 64
1792129 1792129 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No Elementary KG 04 2018   grade_1                         27.0 32.0                       59.0                         27 32                 59
1911824 1911824 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No Elementary KG 04 2020   grade_1                         40.0 43.0                       83.0                         40 43                 83
1923792 1923792 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No Elementary KG 04 2021   grade_1                         42.0 40.0                       82.0                         42 40                 82
1164308 1164308 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary Sch   Regular School No 1.0 KG 05 2015   grade_1                         34.0 36.0                       70.0                         34 36                 70
1285714 1285714 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No 1.0 KG 06 2016   grade_1                         54.0 49.0                       103.0                         54 49                 103
1297761 1297761 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No Elementary PK 05 2017   grade_1                         42.0 22.0                       64.0                         42 22                 64
1756358 1756358 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No Elementary PK 06 2019   grade_1                         38.0 29.0                       67.0                         38 29                 67
1792120 1792120 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No Elementary PK 06 2018   grade_1                         51.0 35.0                       86.0                         51 35                 86
1911815 1911815 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No Elementary PK 06 2020   grade_1                         39.0 42.0                       81.0                         39 42                 81
1923783 1923783 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No Elementary PK 06 2021   grade_1                         45.0 34.0                       79.0                         45 34                 79
1162539 1162539 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No 1.0 PK 04 2015   grade_1                         34.0 28.0                       62.0                         34 28                 62
1283954 1283954 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No 1.0 PK 04 2016   grade_1                         45.0 42.0                       87.0                         45 42                 87
1295990 1295990 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No Elementary KG 04 2017   grade_1                         69.0 35.0                       104.0                         69 35                 104
1754601 1754601 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No Elementary KG 04 2019   grade_1                         55.0 47.0                       102.0                         55 47                 102
1790341 1790341 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No Elementary KG 04 2018   grade_1                         48.0 41.0                       89.0                         48 41                 89
1910042 1910042 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No Elementary KG 04 2020   grade_1                         45.0 48.0                       93.0                         45 48                 93
1921997 1921997 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No Elementary KG 04 2021   grade_1                         58.0 55.0                       113.0                         58 55                 113
1162549 1162549 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No 1.0 PK 04 2015   grade_1                         49.0 32.0                       81.0                         49 32                 81
1283964 1283964 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No 1.0 PK 04 2016   grade_1                         58.0 58.0                       116.0                         58 58                 116
1295999 1295999 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No Elementary PK 04 2017   grade_1                         71.0 41.0                       112.0                         71 41                 112
1754610 1754610 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No Elementary PK 04 2019   grade_1                         51.0 75.0                       126.0                         51 75                 126
1790350 1790350 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No Elementary PK 04 2018   grade_1                         61.0 50.0                       111.0                         61 50                 111
1910051 1910051 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No Elementary PK 04 2020   grade_1                         57.0 54.0                       111.0                         57 54                 111
1922006 1922006 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No Elementary PK 04 2021   grade_1                         65.0 61.0                       126.0                         65 61                 126
1162526 1162526 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No 1.0 KG 04 2015   grade_1                         38.0 47.0                       85.0                         38 47                 85
1283941 1283941 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No 1.0 KG 04 2016   grade_1                         35.0 35.0                       70.0                         35 35                 70
1295977 1295977 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No Elementary KG 04 2017   grade_1                         47.0 35.0                       82.0                         47 35                 82
1754587 1754587 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No Elementary PK 04 2019   grade_1                         63.0 52.0                       115.0                         63 52                 115
1790327 1790327 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No Elementary PK 04 2018   grade_1                         58.0 47.0                       105.0                         58 47                 105
1910028 1910028 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No Elementary PK 04 2020   grade_1                         53.0 46.0                       99.0                         53 46                 99
1921983 1921983 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No Elementary PK 04 2021   grade_1                         74.0 40.0                       114.0                         74 40                 114
1162532 1162532 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary Sch   Regular School No 1.0 PK 04 2015   grade_1                         52.0 62.0                       114.0                         52 62                 114
1283947 1283947 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary School   Regular School No 1.0 PK 04 2016   grade_1                         60.0 56.0                       116.0                         60 56                 116
1295983 1295983 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary School   Regular School No Elementary PK 04 2017   grade_1                         69.0 45.0                       114.0                         69 45                 114
1754594 1754594 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary School   Regular School No Elementary PK 04 2019   grade_1                         61.0 40.0                       101.0                         61 40                 101
1790334 1790334 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary School   Regular School No Elementary PK 04 2018   grade_1                         65.0 66.0                       131.0                         65 66                 131
1910035 1910035 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary School   Regular School No Elementary PK 04 2020   grade_1                         54.0 44.0                       98.0                         54 44                 98
1921990 1921990 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary School   Regular School No Elementary PK 04 2021   grade_1                         52.0 56.0                       108.0                         52 56                 108
1162519 1162519 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary Sch   Regular School No 1.0 PK 04 2015   grade_1                         64.0 66.0                       130.0                         64 66                 130
1283934 1283934 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary School   Regular School No 1.0 PK 04 2016   grade_1                         54.0 51.0                       105.0                         54 51                 105
1295970 1295970 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary School   Regular School No Elementary PK 04 2017   grade_1                         49.0 60.0                       109.0                         49 60                 109
1754580 1754580 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary School   Regular School No Elementary PK 04 2019   grade_1                         71.0 56.0                       127.0                         71 56                 127
1790320 1790320 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary School   Regular School No Elementary PK 04 2018   grade_1                         57.0 52.0                       109.0                         57 52                 109
1910021 1910021 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary School   Regular School No Elementary PK 04 2020   grade_1                         58.0 63.0                       121.0                         58 63                 121
1921976 1921976 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary School   Regular School No Elementary PK 04 2021   grade_1                         66.0 55.0                       121.0                         66 55                 121
1162507 1162507 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary Sch   Regular School No 1.0 KG 04 2015   grade_1                         43.0 53.0                       96.0                         43 53                 96
1283922 1283922 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No 1.0 KG 04 2016   grade_1                         49.0 43.0                       92.0                         49 43                 92
1295957 1295957 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No Elementary PK 04 2017   grade_1                         39.0 35.0                       74.0                         39 35                 74
1754567 1754567 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No Elementary PK 04 2019   grade_1                         55.0 50.0                       105.0                         55 50                 105
1790307 1790307 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No Elementary PK 04 2018   grade_1                         49.0 37.0                       86.0                         49 37                 86
1910008 1910008 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No Elementary PK 04 2020   grade_1                         55.0 38.0                       93.0                         55 38                 93
1921963 1921963 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No Elementary PK 04 2021   grade_1                         59.0 52.0                       111.0                         59 52                 111
1170406 1170406 IN     school 1813050 8355   Western Wayne Schools 181305000807 8971 Western Wayne Elem Sch   Regular School No 1.0 PK 05 2015   grade_1                         36.0 39.0                       75.0                         36 39                 75
1291793 1291793 IN     school 1813050 8355   Western Wayne Schools 181305000807 8971 Western Wayne Elementary School   Regular School No 1.0 PK 05 2016   grade_1                         31.0 34.0                       65.0                         31 34                 65
1303818 1303818 IN     school 1813050 8355   Western Wayne Schools 181305000807 8971 Western Wayne Elementary School   Regular School No Elementary PK 05 2017   grade_1                         32.0 36.0                       68.0                         32 36                 68
1762357 1762357 IN     school 1813050 8355   Western Wayne Schools 181305000807 8971 Western Wayne Elementary School   Regular School No Elementary PK 05 2019   grade_1                         30.0 25.0                       55.0                         30 25                 55

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