enrollments

Data source: Big Local News · About: Big Local

7,343 rows where grade = "grade_4" and state = "IN" sorted by district_nces_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_4 · 7,343 ✖
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
1166236 1166236 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_4                         5.0 1.0                       6.0                         5 1                 6
1287638 1287638 IN     school   5375   M S D Wayne Township   5271 Sanders School             2016   grade_4                         1.0 1.0                       2.0                         1 1                 2
1299675 1299675 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_4                         5.0 1.0                       6.0                         5 1                 6
1758213 1758213 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_4                         3.0 0.0                       3.0                         3 0                 3
1794003 1794003 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_4                         11.0 2.0                       13.0                         11 2                 13
1908018 1908018 IN     school   940   West Clark Community Schools   767 Henryville Elementary School             2020   grade_4                         48.0 47.0                       95.0                         48 47                 95
1908036 1908036 IN     school   940   West Clark Community Schools   789 Silver Creek Elementary School             2020   grade_4                         96.0 104.0                       200.0                         96 104                 200
1908050 1908050 IN     school   940   West Clark Community Schools   815 William W Borden Elementary School             2020   grade_4                         25.0 17.0                       42.0                         25 17                 42
1913641 1913641 IN     school   5375   M S D Wayne Township   5271 Sanders School             2020   grade_4                         4.0 1.0                       5.0                         4 1                 5
1925547 1925547 IN     school   5375   MSD Wayne Township   5271 Sanders School             2021   grade_4                         5.0 1.0                       6.0                         5 1                 6
1927086 1927086 IN     school   6470   Duneland School Corporation   6811 Porter County Education Services             2021   grade_4                         3.0 1.0                       4.0                         3 1                 4
1927138 1927138 IN     school   6510   East Porter County School Corp   6811 Porter County Education Services             2021   grade_4                         0.0 1.0                       1.0                         0 1                 1
1927245 1927245 IN     school   6550   Portage Township Schools   6811 Porter County Education Services             2021   grade_4                         4.0 0.0                       4.0                         4 0                 4
1927328 1927328 IN     school   6560   Valparaiso Community Schools   6811 Porter County Education Services             2021   grade_4                         2.0 1.0                       3.0                         2 1                 3
1164252 1164252 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No 1.0 PK 05 2015   grade_4                         23.0 32.0                       55.0                         23 32                 55
1164264 1164264 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary Sch   Regular School No 1.0 PK 05 2015   grade_4                         27.0 25.0                       52.0                         27 25                 52
1285659 1285659 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No 1.0 PK 05 2016   grade_4                         29.0 26.0                       55.0                         29 26                 55
1285671 1285671 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No 1.0 KG 05 2016   grade_4                         29.0 22.0                       51.0                         29 22                 51
1297705 1297705 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 05 2017   grade_4                         32.0 33.0                       65.0                         32 33                 65
1297717 1297717 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary PK 05 2017   grade_4                         21.0 30.0                       51.0                         21 30                 51
1756302 1756302 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 06 2019   grade_4                         15.0 34.0                       49.0                         15 34                 49
1756311 1756311 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary KG 06 2019   grade_4                         21.0 16.0                       37.0                         21 16                 37
1792063 1792063 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 05 2018   grade_4                         28.0 17.0                       45.0                         28 17                 45
1792075 1792075 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary PK 05 2018   grade_4                         28.0 30.0                       58.0                         28 30                 58
1911759 1911759 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 06 2020   grade_4                         27.0 22.0                       49.0                         27 22                 49
1911768 1911768 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary KG 06 2020   grade_4                         25.0 15.0                       40.0                         25 15                 40
1923727 1923727 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 06 2021   grade_4                         27.0 26.0                       53.0                         27 26                 53
1923736 1923736 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary KG 06 2021   grade_4                         14.0 27.0                       41.0                         14 27                 41
1165114 1165114 IN     school 1813200 4760   Whiting School City 181320002081 4361 Nathan Hale Elementary School   Regular School No 1.0 PK 05 2015   grade_4                         32.0 51.0                       83.0                         32 51                 83
1286509 1286509 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No 1.0 PK 05 2016   grade_4                         44.0 32.0                       76.0                         44 32                 76
1298548 1298548 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No Elementary PK 05 2017   grade_4                         27.0 48.0                       75.0                         27 48                 75
1757076 1757076 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No Elementary PK 05 2019   grade_4                         28.0 43.0                       71.0                         28 43                 71
1792867 1792867 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No Elementary PK 05 2018   grade_4                         30.0 46.0                       76.0                         30 46                 76
1912512 1912512 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No Elementary PK 05 2020   grade_4                         43.0 34.0                       77.0                         43 34                 77
1924462 1924462 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No Elementary PK 05 2021   grade_4                         38.0 33.0                       71.0                         38 33                 71
1164302 1164302 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No 1.0 KG 04 2015   grade_4                         42.0 32.0                       74.0                         42 32                 74
1164311 1164311 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary Sch   Regular School No 1.0 KG 05 2015   grade_4                         46.0 27.0                       73.0                         46 27                 73
1164318 1164318 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elem School   Regular School No 1.0 KG 04 2015   grade_4                         30.0 39.0                       69.0                         30 39                 69
1285708 1285708 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         26.0 46.0                       72.0                         26 46                 72
1285717 1285717 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No 1.0 KG 06 2016   grade_4                         39.0 19.0                       58.0                         39 19                 58
1285725 1285725 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No 1.0 KG 04 2016   grade_4                         40.0 37.0                       77.0                         40 37                 77
1297755 1297755 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No Elementary KG 04 2017   grade_4                         25.0 27.0                       52.0                         25 27                 52
1297764 1297764 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No Elementary PK 05 2017   grade_4                         37.0 29.0                       66.0                         37 29                 66
1297772 1297772 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No Elementary KG 04 2017   grade_4                         41.0 32.0                       73.0                         41 32                 73
1756352 1756352 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No Elementary KG 04 2019   grade_4                         30.0 28.0                       58.0                         30 28                 58
1756361 1756361 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No Elementary PK 06 2019   grade_4                         50.0 41.0                       91.0                         50 41                 91
1756370 1756370 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No Elementary KG 04 2019   grade_4                         32.0 33.0                       65.0                         32 33                 65
1792114 1792114 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No Elementary KG 04 2018   grade_4                         27.0 29.0                       56.0                         27 29                 56
1792123 1792123 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No Elementary PK 06 2018   grade_4                         35.0 35.0                       70.0                         35 35                 70
1792132 1792132 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No Elementary KG 04 2018   grade_4                         32.0 30.0                       62.0                         32 30                 62
1911809 1911809 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No Elementary KG 04 2020   grade_4                         29.0 26.0                       55.0                         29 26                 55
1911818 1911818 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No Elementary PK 06 2020   grade_4                         37.0 29.0                       66.0                         37 29                 66
1911827 1911827 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No Elementary KG 04 2020   grade_4                         34.0 37.0                       71.0                         34 37                 71
1923777 1923777 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No Elementary KG 04 2021   grade_4                         31.0 31.0                       62.0                         31 31                 62
1923786 1923786 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No Elementary PK 06 2021   grade_4                         45.0 37.0                       82.0                         45 37                 82
1923795 1923795 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No Elementary KG 04 2021   grade_4                         26.0 33.0                       59.0                         26 33                 59
1162510 1162510 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary Sch   Regular School No 1.0 KG 04 2015   grade_4                         51.0 40.0                       91.0                         51 40                 91
1162522 1162522 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary Sch   Regular School No 1.0 PK 04 2015   grade_4                         47.0 47.0                       94.0                         47 47                 94
1162529 1162529 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No 1.0 KG 04 2015   grade_4                         49.0 27.0                       76.0                         49 27                 76
1162535 1162535 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary Sch   Regular School No 1.0 PK 04 2015   grade_4                         57.0 47.0                       104.0                         57 47                 104
1162542 1162542 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No 1.0 PK 04 2015   grade_4                         30.0 21.0                       51.0                         30 21                 51
1162552 1162552 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No 1.0 PK 04 2015   grade_4                         48.0 51.0                       99.0                         48 51                 99
1283925 1283925 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         64.0 61.0                       125.0                         64 61                 125
1283937 1283937 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary School   Regular School No 1.0 PK 04 2016   grade_4                         48.0 52.0                       100.0                         48 52                 100
1283944 1283944 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         47.0 38.0                       85.0                         47 38                 85
1283950 1283950 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary School   Regular School No 1.0 PK 04 2016   grade_4                         57.0 52.0                       109.0                         57 52                 109
1283957 1283957 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No 1.0 PK 04 2016   grade_4                         19.0 26.0                       45.0                         19 26                 45
1283967 1283967 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No 1.0 PK 04 2016   grade_4                         74.0 40.0                       114.0                         74 40                 114
1295960 1295960 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No Elementary PK 04 2017   grade_4                         38.0 47.0                       85.0                         38 47                 85
1295973 1295973 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary School   Regular School No Elementary PK 04 2017   grade_4                         60.0 41.0                       101.0                         60 41                 101
1295980 1295980 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No Elementary KG 04 2017   grade_4                         41.0 45.0                       86.0                         41 45                 86
1295986 1295986 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary School   Regular School No Elementary PK 04 2017   grade_4                         66.0 62.0                       128.0                         66 62                 128
1295993 1295993 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No Elementary KG 04 2017   grade_4                         36.0 27.0                       63.0                         36 27                 63
1296002 1296002 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No Elementary PK 04 2017   grade_4                         68.0 60.0                       128.0                         68 60                 128
1754570 1754570 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No Elementary PK 04 2019   grade_4                         53.0 40.0                       93.0                         53 40                 93
1754583 1754583 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary School   Regular School No Elementary PK 04 2019   grade_4                         64.0 54.0                       118.0                         64 54                 118
1754590 1754590 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No Elementary PK 04 2019   grade_4                         47.0 52.0                       99.0                         47 52                 99
1754597 1754597 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary School   Regular School No Elementary PK 04 2019   grade_4                         62.0 57.0                       119.0                         62 57                 119
1754604 1754604 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No Elementary KG 04 2019   grade_4                         47.0 42.0                       89.0                         47 42                 89
1754613 1754613 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No Elementary PK 04 2019   grade_4                         59.0 64.0                       123.0                         59 64                 123
1790310 1790310 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No Elementary PK 04 2018   grade_4                         43.0 53.0                       96.0                         43 53                 96
1790323 1790323 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary School   Regular School No Elementary PK 04 2018   grade_4                         74.0 69.0                       143.0                         74 69                 143
1790330 1790330 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No Elementary PK 04 2018   grade_4                         49.0 49.0                       98.0                         49 49                 98
1790337 1790337 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary School   Regular School No Elementary PK 04 2018   grade_4                         56.0 67.0                       123.0                         56 67                 123
1790344 1790344 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No Elementary KG 04 2018   grade_4                         50.0 36.0                       86.0                         50 36                 86
1790353 1790353 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No Elementary PK 04 2018   grade_4                         51.0 33.0                       84.0                         51 33                 84
1910011 1910011 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No Elementary PK 04 2020   grade_4                         53.0 45.0                       98.0                         53 45                 98
1910024 1910024 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary School   Regular School No Elementary PK 04 2020   grade_4                         57.0 64.0                       121.0                         57 64                 121
1910031 1910031 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No Elementary PK 04 2020   grade_4                         47.0 36.0                       83.0                         47 36                 83
1910038 1910038 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary School   Regular School No Elementary PK 04 2020   grade_4                         71.0 47.0                       118.0                         71 47                 118
1910045 1910045 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No Elementary KG 04 2020   grade_4                         64.0 54.0                       118.0                         64 54                 118
1910054 1910054 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No Elementary PK 04 2020   grade_4                         74.0 41.0                       115.0                         74 41                 115
1921966 1921966 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No Elementary PK 04 2021   grade_4                         57.0 47.0                       104.0                         57 47                 104
1921979 1921979 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary School   Regular School No Elementary PK 04 2021   grade_4                         66.0 51.0                       117.0                         66 51                 117
1921986 1921986 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No Elementary PK 04 2021   grade_4                         52.0 51.0                       103.0                         52 51                 103
1921993 1921993 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary School   Regular School No Elementary PK 04 2021   grade_4                         62.0 65.0                       127.0                         62 65                 127
1922000 1922000 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No Elementary KG 04 2021   grade_4                         60.0 47.0                       107.0                         60 47                 107
1922009 1922009 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No Elementary PK 04 2021   grade_4                         63.0 48.0                       111.0                         63 48                 111
1170409 1170409 IN     school 1813050 8355   Western Wayne Schools 181305000807 8971 Western Wayne Elem Sch   Regular School No 1.0 PK 05 2015   grade_4                         39.0 29.0                       68.0                         39 29                 68
1291796 1291796 IN     school 1813050 8355   Western Wayne Schools 181305000807 8971 Western Wayne Elementary School   Regular School No 1.0 PK 05 2016   grade_4                         36.0 31.0                       67.0                         36 31                 67

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